ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a547359d8f8e: POST https://beta.jinchangxiao.com/v2/project/list at 2026-07-13 01:10:49 pm by 39.156.194.178

Performance Profiling

Total processing time: 516 ms; Peak memory: 8.206 MB. Show Profiling Timeline

总计92条数据
TimeDurationCategoryInfo
  
13:10:49.976121.9 msyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10
13:10:49.92054.7 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c"
13:10:50.26751.0 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "object_id"
13:10:50.31931.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "object_id"
13:10:50.16017.8 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "c"."project_id"
13:10:50.14112.7 msyii\db\Command::querySELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055) GROUP BY "c"."project_id"
13:10:50.25412.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (969, 970, 971, 2047, 2048, 1760, 1757, 1759, 1758, 1832, 1833, 1834, 1835, 1836, 1837, 1734, 1732, 1733, 1730, 1731, 2150)
13:10:50.2189.2 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388) ORDER BY "id"
13:10:50.1138.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.3917.6 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/project/list', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","ProjectSearch":{"projectProductTypes":"","created_by":"","salesForecast":"","project_status":"-1","project_progress":"","engineer_id":"","period":""},"device_type":"0","version_code":"276","page":"1","token":"af9531021c9f613ab855453ba821aaa1","posttime":"1783919450","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":263,"client_id":399,"project_status":3,"project_progress":10,"budget":"863675","profit_pct":"9","bargain_date":"2017-06-21","description":"\u6d6a\u6f6e\u670d\u52a1\u5668","created_by":1001,"created_at":"2017-07-10 13:50:18","updated_at":"2026-05-18 13:48:27","engineer_id":null,"project_title":"\u4e92\u8054\u7f51+\u7b2c\u4e8c\u6279","collected":"863675","status_updated_at":"2019-01-15 15:55:53.441106+08","success_rate":100,"comment":"\u6d6a\u6f6e\u670d\u52a1\u5668\r\n","contract_type":1,"progress_updated_at":"2019-05-05 16:39:47.132109+08","forecast_updated_at":"2019-05-05 16:39:47.132109+08","end_at":"2019-05-05 16:39:47","pinyin_shortcut":"hlwdep","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"77730.7500000000000000","remain":"2735 days 21:14:56.537349","progress_remain":"2625 days 20:31:02.846346","forecast_remain":"2625 days 20:31:02.846346","lost_contact_days":"56.0116895654514","last_contact":"2026-05-18 12:54:00","last_arrive_days":null,"last_arrive":null,"duration":"664 days 02:49:28.30236","issued_invoices":"863675","client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"863675","pct":"9","profit":"77730.75","project_id":263}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":263,"points":"30"},"workLogCount":{"project_id":263,"count":1},"caseCount":{"project_id":263,"count":6},"salesTimeCount":null,"implementTimeCount":{"project_id":263,"sum":"7.75","times":"5"},"presalesTimeCount":{"project_id":263,"sum":"7","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":195,"from_project":263,"payment_collection_remind_ahead":null,"serial_no":null,"is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"863675","erp_un_settle_amount":"0","including_tax":true,"amount":"863675","contractScans":[{"id":12627,"object_type":105,"object_id":195,"attachment_id":753,"attachment":{"id":753,"key":753,"name":"abad7e91-7907-37a8-b86d-db4aa8d59a68","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/abad7e91-7907-37a8-b86d-db4aa8d59a68\/\u5317\u4eac\u4e2d\u76fe\u5b89\u5168\u6280\u672f\u5f00\u53d1\u516c\u53f8\u201420170626\u2014863675.pdf","orig_name":"\u5317\u4eac\u4e2d\u76fe\u5b89\u5168\u6280\u672f\u5f00\u53d1\u516c\u53f8\u201420170626\u2014863675.pdf"}}],"receiptScans":[{"id":13329,"object_type":106,"object_id":195,"attachment_id":395,"attachment":{"id":395,"key":395,"name":"9e1cd502-f245-3232-99de-4d05f36926ce","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9e1cd502-f245-3232-99de-4d05f36926ce\/\u4e2d\u76fe\u201420170717.pdf","orig_name":"\u4e2d\u76fe\u201420170717.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":948,"serial_no":"SKD-20170724-00003","wrote_date":null,"from_date":null,"handler":1005,"user_id":null,"client_id":399,"sales_contract_id":195,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-07-24 14:52:37","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"43184.00","settle_amount":"43184.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-07-24 14:52:37","updated_at":"2017-07-24 14:52:37","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":947,"serial_no":"SKD-20170724-00002","wrote_date":null,"from_date":null,"handler":1005,"user_id":null,"client_id":399,"sales_contract_id":195,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-07-24 14:52:37","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"820491.00","settle_amount":"820491.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-07-24 14:52:37","updated_at":"2017-07-24 14:52:37","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1948","key":"1948","contract_id":195,"value":"43184.00","created_by":null,"collected_date":"","createdBy":null,"pct":5},{"id":"1947","key":"1947","contract_id":195,"value":"820491.00","created_by":null,"collected_date":"","createdBy":null,"pct":95}],"salesContractInvoices":[{"id":729,"key":729,"contract_id":195,"value":"863675.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":863675},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":263,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":74,"serial_no":"XSDD-20170724-00002","from_date":null,"wrote_date":"2017-06-21","handler":5015,"client_id":399,"purchase_contract_id":null,"project_id":263,"sales_contract_id":195,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8ba1\u7b97","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 16:39:47","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"863675","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-07-24 14:52:37","updated_at":"2019-05-05 16:39:47","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":2735,"progress_remain_display":2625,"forecast_remain_display":2625,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":664,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"1\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"86.37\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":1111,"client_id":982,"project_status":3,"project_progress":49,"budget":"2486850","profit_pct":"15","bargain_date":"2019-09-23","description":"1.\u4ebf\u8054V880+V800\u4f1a\u8bae\u5ba4\u7ec8\u7aef\u2795Ume\u7cfb\u7edf\u4e00\u5957","created_by":1003,"created_at":"2019-04-24 06:22:09","updated_at":"2026-05-15 13:07:37","engineer_id":null,"project_title":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf","collected":"2486850","status_updated_at":"2020-09-17 09:57:01.503052+08","success_rate":null,"comment":"1.\u4ebf\u8054V880+V800\u4f1a\u8bae\u5ba4\u7ec8\u7aef\u2795Ume\u7cfb\u7edf\u4e00\u5957\r\n1. \u5ba2\u6237\u5173\u6ce8\u70b9\uff1a\u4ea7\u54c1\u7684\u6613\u7528\uff0c\u7a33\u5b9a\uff0c\u53ef\u6301\u7eed\u5347\u7ea7\u6539\u9020\u548c\u4f18\u8d28\u540e\u671f\u670d\u52a1\r\n2. \u8d62\u5355\u5173\u952e\u6761\u4ef6\uff1a\u6700\u5408\u7406\u6280\u672f\u65b9\u6848\uff0c\u5408\u7406\u7684\u4ef7\u683c\u3002\r\n3. \u9879\u76ee\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u9ad8\u6548\uff0c\u4fbf\u6377\uff0c\u534f\u4f5c\u7684\u7edf\u4e00\u901a\u8baf\u89e3\u51b3\u65b9\u6848\r\n4. \u5ba2\u6237\u503e\u5411\u7684\u65b9\u6848\u662f\uff1a\u5ba2\u6237\u81ea\u9009\uff1f\u6211\u4eec\u63a8\u8350\uff1f\u7ade\u4e89\u5bf9\u624b\u65b9\u6848\uff1f\u6211\u4eec\u63a8\u8350\u7684\u4ebf\u8054\u65b9\u6848\r\n5. \u7ade\u4e89\u5bf9\u624b\u7684\u65b9\u6848\uff1a\u534e\u4e3a\uff0c\u5c0f\u9c7c\uff0c\u5fae\u4fe1\r\n6. \u662f\u5426\u6709\u9886\u8def\u4eba\uff1a\u6ca1\u6709\r\n7. \u5ba2\u6237\u5173\u952e\u4eba\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u652f\u6301\r\n8. \u5382\u5546\u662f\u5426\u652f\u6301\u6211\u4eec\uff1a\u9700\u8981\u5382\u5546\u652f\u6301\r\n9. \u5408\u4f5c\u65b9\u5f0f\uff1a\u5ba2\u6237\u6346\u7ed1\uff1f\u5382\u5546\u6346\u7ed1\uff1f\u8ddf\u5ba2\u6237\u6346\u7ed1\u3002\r\n10. \u4ed8\u6b3e\u65b9\u5f0f\uff1a\u7b7e\u5408\u540c30%\u5230\u8d2740%\u9a8c\u653630%\r\n11. \u51b3\u7b56\u6d41\u7a0b\uff1a\u516c\u5f00\u62db\u6807\r\n12. \u6211\u7684\u95ee\u9898\uff1a\u6682\u65e0 ","contract_type":1,"progress_updated_at":"2022-10-19 23:06:49.491901+08","forecast_updated_at":"2020-09-17 09:57:01.503052+08","end_at":"2024-09-02 10:10:17","pinyin_shortcut":"ylsphytytx","creator":1003,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"373027.500000000000","remain":"2125 days 03:13:48.475403","progress_remain":"1362 days 14:04:00.486554","forecast_remain":"2125 days 03:13:48.475403","lost_contact_days":"74.0644673432292","last_contact":"2026-04-30 11:38:00","last_arrive_days":"74.0644673432292","last_arrive":"2026-04-30 11:38:00+08","duration":"1958 days 03:48:08.315769","issued_invoices":"7460550","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","logo":null,"client_type":6,"client_class":1,"client_industry":4,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":4,"key":4,"name":"\u901a\u4fe1"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":1111,"value":"0.7","key":1016,"name":"\u8346\u626c"},{"project_id":1111,"value":"0.3","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":96,"product_type_id":96,"key":96,"name":"\u89c6\u9891","budget":"2486850","pct":"15","profit":"373027.5","project_id":1111}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"opportunityFrom":{"id":171,"key":171,"name":"cold call"},"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"casePoints":{"project_id":1111,"points":"2617"},"workLogCount":{"project_id":1111,"count":45},"caseCount":{"project_id":1111,"count":55},"salesTimeCount":{"project_id":1111,"hours":"0.0333333333333333","times":3},"implementTimeCount":{"project_id":1111,"sum":"25.05","times":"13"},"presalesTimeCount":{"project_id":1111,"sum":"165.5","times":"29"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":1111,"sum":"958.03"},"buildContract":{"id":1186,"from_project":1111,"payment_collection_remind_ahead":"1 day","serial_no":"DX190911WLQ01 ","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"2486850","erp_un_settle_amount":"0","including_tax":true,"amount":"2486850","contractScans":[{"id":12926,"object_type":105,"object_id":1186,"attachment_id":3675,"attachment":{"id":3675,"key":3675,"name":"92d3a097-1e56-35c9-a200-6598a42f9a14","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/92d3a097-1e56-35c9-a200-6598a42f9a14\/\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662.pdf","orig_name":"\u4e2d\u56fd\u4fe1\u606f\u901a\u4fe1\u7814\u7a76\u9662.pdf"}}],"receiptScans":[{"id":13576,"object_type":106,"object_id":1186,"attachment_id":5408,"attachment":{"id":5408,"key":5408,"name":"a7f7c1cd-e9fb-3dfa-bbd8-22694c03e4fd","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a7f7c1cd-e9fb-3dfa-bbd8-22694c03e4fd\/preview.pdf","orig_name":"preview.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1927,"serial_no":"SKD-20240902-00005","wrote_date":"2024-09-02","from_date":null,"handler":1001,"user_id":null,"client_id":982,"sales_contract_id":1186,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-02 10:10:17","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"746054.09","settle_amount":"746054.09","created_by":5064,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-02 10:10:17","updated_at":"2024-09-02 10:10:17","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":1926,"serial_no":"SKD-20240902-00004","wrote_date":"2024-09-30","from_date":null,"handler":1001,"user_id":null,"client_id":982,"sales_contract_id":1186,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-02 10:10:17","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"994740.91","settle_amount":"994740.91","created_by":5064,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-02 10:10:17","updated_at":"2024-09-02 10:10:17","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":1925,"serial_no":"SKD-20240902-00003","wrote_date":"2024-09-02","from_date":null,"handler":1001,"user_id":null,"client_id":982,"sales_contract_id":1186,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-02 10:10:17","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"746055.00","settle_amount":"746055.00","created_by":5064,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-02 10:10:17","updated_at":"2024-09-02 10:10:17","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11927","key":"11927","contract_id":1186,"value":"746054.09","created_by":5064,"collected_date":"2024-09-02 00:00:00","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10},"pct":30},{"id":"11926","key":"11926","contract_id":1186,"value":"994740.91","created_by":5064,"collected_date":"2024-09-30 00:00:00","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10},"pct":40},{"id":"11925","key":"11925","contract_id":1186,"value":"746055.00","created_by":5064,"collected_date":"2024-09-02 00:00:00","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10},"pct":30}],"salesContractInvoices":[{"id":96,"key":96,"contract_id":1186,"value":"746055.00","attachment_id":5693,"from_date":"2019-09-23","attachment":{"id":5693,"key":5693,"name":"af816b6d-3942-324d-91a1-d39e89f807ed","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/af816b6d-3942-324d-91a1-d39e89f807ed\/1.pdf","orig_name":"1.pdf"}},{"id":571,"key":571,"contract_id":1186,"value":"994740.00","attachment_id":5209,"from_date":"2020-04-15","attachment":{"id":5209,"key":5209,"name":"a2fc016a-f926-30e1-b137-e64e17fe624d","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a2fc016a-f926-30e1-b137-e64e17fe624d\/2020_06_23_17_18_27.pdf","orig_name":"2020_06_23_17_18_27.pdf"}},{"id":893,"key":893,"contract_id":1186,"value":"746055.00","attachment_id":5690,"from_date":"2020-09-09","attachment":{"id":5690,"key":5690,"name":"9de0a436-39c6-3ee6-8025-e98e94c8cecc","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9de0a436-39c6-3ee6-8025-e98e94c8cecc\/2020_09_09_11_15_07.pdf","orig_name":"2020_09_09_11_15_07.pdf"}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":2745,"user_id":1001,"key":1001,"contract_id":1186,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2746,"user_id":1003,"key":1003,"contract_id":1186,"user":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}}}],"salesSupplierRels":[{"id":521,"contract_id":1186,"supplier_id":252,"purchase_id":1234,"supplier":{"id":252,"key":252,"name":"\u5317\u4eac\u601d\u8bfa\u6587\u901a\u8baf\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":1234,"key":1234,"serial_no":"20190919"}},{"id":780,"contract_id":1186,"supplier_id":305,"purchase_id":1213,"supplier":{"id":305,"key":305,"name":"\u5317\u4eac\u535a\u4f1f\u4f1f\u4e1a\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":1213,"key":1213,"serial_no":"20191012001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":2486850},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1111,"comment":6},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":471,"serial_no":"XSDD-20190926-00003","from_date":null,"wrote_date":"2019-09-23","handler":5015,"client_id":982,"purchase_contract_id":null,"project_id":1111,"sales_contract_id":1186,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u534f\u4f5c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-02 10:10:17","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"2486850","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2019-09-26 11:47:16","updated_at":"2024-09-02 10:10:17","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":2125,"progress_remain_display":1362,"forecast_remain_display":2125,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":-4973700,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"2\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":1958,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"248.69\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":2504,"client_id":146,"project_status":3,"project_progress":9,"budget":"12930","profit_pct":"0","bargain_date":"2021-04-01","description":"288 3\u53f0","created_by":1005,"created_at":"2021-04-02 16:46:57","updated_at":"2026-05-09 17:18:36","engineer_id":null,"project_title":"hp288PC","collected":"12930","status_updated_at":"2021-04-02 16:46:57.705323+08","success_rate":null,"comment":"288 3\u53f0\r\n","contract_type":1,"progress_updated_at":"2021-04-06 09:25:04.694623+08","forecast_updated_at":"2021-04-06 09:25:04.694623+08","end_at":"2021-04-06 09:25:04","pinyin_shortcut":"hp288PC","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"0.0000000000000000","remain":"1927 days 20:23:52.273132","progress_remain":"1924 days 03:45:45.283832","forecast_remain":"1924 days 03:45:45.283832","lost_contact_days":"64.8665506765625","last_contact":"2026-05-09 16:23:00","last_arrive_days":null,"last_arrive":null,"duration":"3 days 16:38:06.9893","issued_invoices":"12930","client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":null,"client_type":5,"client_class":43,"client_industry":5,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"12930","pct":"0","profit":"0","project_id":2504}],"salesForecast":{"id":175,"key":175,"name":"100%","description":"\u6210\u529f\u7b7e\u8ba2\u5408\u540c"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"casePoints":null,"workLogCount":{"project_id":2504,"count":1},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":1930,"from_project":2504,"payment_collection_remind_ahead":"00:00:00","serial_no":"POT-21010008","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"12930","erp_un_settle_amount":"0","including_tax":true,"amount":"12930","contractScans":[{"id":12488,"object_type":105,"object_id":1930,"attachment_id":7201,"attachment":{"id":7201,"key":7201,"name":"07be8f3c-6aab-37f3-ac14-0f30ef259a50","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/07be8f3c-6aab-37f3-ac14-0f30ef259a50\/2021_04_06_09_23_21.pdf","orig_name":"2021_04_06_09_23_21.pdf"}}],"receiptScans":[{"id":13221,"object_type":106,"object_id":1930,"attachment_id":7202,"attachment":{"id":7202,"key":7202,"name":"b31b5e2c-a20d-38b5-9ea4-1030a3354f84","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b31b5e2c-a20d-38b5-9ea4-1030a3354f84\/2021_04_06_09_23_21.pdf","orig_name":"2021_04_06_09_23_21.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1500,"serial_no":"SKD-20210426-00002","wrote_date":"2021-04-26","from_date":null,"handler":1001,"user_id":null,"client_id":146,"sales_contract_id":1930,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2021-04-26 10:42:31","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"12930.00","settle_amount":"12930.00","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2021-04-26 10:42:31","updated_at":"2021-04-26 10:42:31","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11500","key":"11500","contract_id":1930,"value":"12930.00","created_by":1014,"collected_date":"2021-04-26 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1036,"key":1036,"contract_id":1930,"value":"12930.00","attachment_id":7207,"from_date":"2021-04-06","attachment":{"id":7207,"key":7207,"name":"8773903e-01de-3247-be7b-1b7693a82cad","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8773903e-01de-3247-be7b-1b7693a82cad\/2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf","orig_name":"2021_04_06_15_50_44\uff08\u88ab\u62d6\u79fb\uff09.pdf"}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":12930},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":2504,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":699,"serial_no":"XSDD-20210406-00001","from_date":null,"wrote_date":"2021-04-01","handler":5015,"client_id":146,"purchase_contract_id":null,"project_id":2504,"sales_contract_id":1930,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u529e\u516c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-06 09:25:04","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"12930","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2021-04-02 16:46:57","updated_at":"2021-04-06 09:25:04","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1927,"progress_remain_display":1924,"forecast_remain_display":1924,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":3,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"1.29\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":1791,"client_id":1661,"project_status":3,"project_progress":49,"budget":"514761.00","profit_pct":"0.56","bargain_date":"2020-06-03","description":"1\u53f05500VX-HW\u8bbe\u5907","created_by":1001,"created_at":"2020-06-23 16:32:19","updated_at":"2026-05-09 17:07:05","engineer_id":null,"project_title":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","collected":"514761","status_updated_at":"2020-08-10 17:52:12.720678+08","success_rate":null,"comment":"1\u53f05500VX-HW\u8bbe\u5907\r\n1.\n2.\n3.\n","contract_type":1,"progress_updated_at":"2022-10-19 23:06:35.395931+08","forecast_updated_at":"2021-04-19 22:25:38.787859+08","end_at":"2021-04-19 22:25:38","pinyin_shortcut":"hy5500VXcgxm","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":514761,"change_status_to":null,"is_verify":false,"profits":"2882.661600000000000000","remain":"2162 days 19:18:37.257777","progress_remain":"1362 days 14:04:14.582524","forecast_remain":"1910 days 14:45:11.190596","lost_contact_days":"64.8755784543403","last_contact":"2026-05-09 16:10:00","last_arrive_days":null,"last_arrive":null,"duration":"300 days 05:53:19.020575","issued_invoices":"514761.00","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"514761.00","pct":"0.56","profit":"2882.6616","project_id":1791}],"salesForecast":{"id":175,"key":175,"name":"100%","description":"\u6210\u529f\u7b7e\u8ba2\u5408\u540c"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"casePoints":null,"workLogCount":{"project_id":1791,"count":3},"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":{"project_id":1791,"hours":"0","times":1},"reimbursementAmountSum":{"project_id":1791,"sum":"222.00"},"buildContract":{"id":1558,"from_project":1791,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20200602-HYF-004","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"514761","erp_un_settle_amount":"0","including_tax":true,"amount":"514761.00","contractScans":[{"id":12313,"object_type":105,"object_id":1558,"attachment_id":5271,"attachment":{"id":5271,"key":5271,"name":"1727e634-855f-3aa3-86ce-f19c5df0e9dd","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/1727e634-855f-3aa3-86ce-f19c5df0e9dd\/2020_06_29_09_03_56.pdf","orig_name":"2020_06_29_09_03_56.pdf"}}],"receiptScans":[{"id":13085,"object_type":106,"object_id":1558,"attachment_id":5320,"attachment":{"id":5320,"key":5320,"name":"b0db54c2-4b7d-3b26-b333-1bcd84fc2666","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b0db54c2-4b7d-3b26-b333-1bcd84fc2666\/\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf","orig_name":"\u626b\u63cf\u5168\u80fd\u738b 2020-07-08 14.11.10.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":423,"serial_no":"SKD-20200623-00001","wrote_date":null,"from_date":null,"handler":1001,"user_id":null,"client_id":1661,"sales_contract_id":1558,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2020-06-23 16:32:19","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"514761.00","settle_amount":"514761.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2020-06-23 16:32:19","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1423","key":"1423","contract_id":1558,"value":"514761.00","created_by":null,"collected_date":"","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":854,"key":854,"contract_id":1558,"value":"514761.00","attachment_id":5400,"from_date":"2020-07-15","attachment":{"id":5400,"key":5400,"name":"b0be27a4-0269-36ec-99ed-ef2ca596d429","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b0be27a4-0269-36ec-99ed-ef2ca596d429\/2020_07_15_11_35_57.pdf","orig_name":"2020_07_15_11_35_57.pdf"}}],"salesContractPaymentCollectionRemindDates":[{"id":550,"key":550,"contract_id":1558,"name":"2020-08-11","value":"514761.00","overdue_days":null,"status":1,"remind_date":"2020-08-11","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":1252,"user_id":1001,"key":1001,"contract_id":1558,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":1253,"user_id":1011,"key":1011,"contract_id":1558,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}}],"salesSupplierRels":[{"id":635,"contract_id":1558,"supplier_id":365,"purchase_id":1559,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":1559,"key":1559,"serial_no":"TSKJ20200603-HYF-002"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":514761},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1791,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":584,"serial_no":"XSDD-20200623-00001","from_date":null,"wrote_date":"2020-06-03","handler":5015,"client_id":1661,"purchase_contract_id":null,"project_id":1791,"sales_contract_id":1558,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u5b89\u5168 ","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-04-19 22:25:38","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"514761","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-06-23 16:32:19","updated_at":"2021-04-19 22:25:38","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":2162,"progress_remain_display":1362,"forecast_remain_display":1910,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":300,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"51.48\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":4111,"client_id":3435,"project_status":3,"project_progress":9,"budget":"29800","profit_pct":"93","bargain_date":"2026-01-22","description":"","created_by":1001,"created_at":"2026-01-22 11:53:00","updated_at":"2026-04-30 13:48:32","engineer_id":null,"project_title":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee","collected":"29800","status_updated_at":"2026-01-22 12:17:04.022004+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-01-22 12:17:04.022004+08","forecast_updated_at":"2026-01-22 11:53:00.849244+08","end_at":"2026-04-01 10:09:20","pinyin_shortcut":"jcxERPrjytcgxm","creator":1011,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1307,"is_sales_order_ready":true,"collected_plan":29800,"change_status_to":null,"is_verify":false,"profits":"27714.0000000000000000","remain":"172 days 00:53:45.956451","progress_remain":"172 days 00:53:45.956451","forecast_remain":"172 days 01:17:49.129211","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"68 days 22:16:19.315421","issued_invoices":"29800","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"29800","pct":"93","profit":"27714","project_id":4111}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4388,"from_project":4111,"payment_collection_remind_ahead":"1 day","serial_no":"JCX-ZHY-2025110101","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"29800","erp_un_settle_amount":"0","including_tax":true,"amount":"29800","contractScans":[{"id":57488,"object_type":105,"object_id":4388,"attachment_id":31575,"attachment":{"id":31575,"key":31575,"name":"76f9e3d4-033b-3b14-8467-87fb461c607a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/76f9e3d4-033b-3b14-8467-87fb461c607a\/2026_01_23_16_50_59.pdf","orig_name":"2026_01_23_16_50_59.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12168","key":"12168","contract_id":4388,"value":"29800","created_by":1013,"collected_date":"2026-01-27 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2294,"key":2294,"contract_id":4388,"value":"29800","attachment_id":null,"from_date":"2026-01-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2728,"key":2728,"contract_id":4388,"name":"2026-01-30","value":"29800","overdue_days":null,"status":1,"remind_date":"2026-01-30","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":10102,"user_id":1001,"key":1001,"contract_id":4388,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":10103,"user_id":1011,"key":1011,"contract_id":4388,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":10104,"user_id":5252,"key":5252,"contract_id":4388,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":29800},"projectRemindReceivers":[],"projectProductRels":[{"id":11884,"project_id":4111,"product_id":2171,"amount":"29800","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"29800","total_cost":"0","erp_sales_order_product_id":2150,"supplier":null,"product":{"id":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_type":7,"product_component":159,"product_brand":270,"product_serie":1724,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-11-24 16:16:45","updated_at":"2026-06-23 13:48:49","pinyin_shortcut":"jcxCRMrjfw","product_unit":2,"is_renew":false,"in_out_at":"2026-06-23 13:48:49.894578+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2150,"erp_sales_order_id":1675,"erp_store_id":null,"product_id":2171,"description":"","number":"1","outbound":"1","amount":"29800","total_amount":"29800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":4111,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1675,"serial_no":"XSDD-20260122-00001","from_date":null,"wrote_date":"2026-01-22","handler":1001,"client_id":3435,"purchase_contract_id":null,"project_id":4111,"sales_contract_id":4388,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-01-22 12:32:43","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"1","amount":"29800","created_by":1001,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"1001\",\"1011\",\"5252\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-01-22 12:17:04","updated_at":"2026-01-22 12:32:43","print_times":null},"projectUsedClient":{"id":289,"project_id":4111,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":172,"progress_remain_display":172,"forecast_remain_display":172,"projectProductTotalAmount":29800,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":68,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"2.98\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":113,"erp_sales_order_id":1675,"user_id":1001,"status":1,"description":null,"verify_at":"2026-01-22 12:32:43","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]},{"id":1972,"client_id":1956,"project_status":3,"project_progress":49,"budget":"1066393.00","profit_pct":"0","bargain_date":"2020-11-10","description":"1.2\u53f0Fireeye EX3500\u4e3b\u673a+1\u5e74\u670d\u52a1\uff1b\n2.1\u53f0Fireeye NX4500\u4e3b\u673a+1\u5e74\u670d\u52a1","created_by":1001,"created_at":"2020-11-06 09:55:40","updated_at":"2026-04-23 16:20:15","engineer_id":null,"project_title":"Fire-eye\u7f51\u7edc\u90ae\u4ef6\u6c99\u7bb1\u7cfb\u7edf\u91c7\u8d2d","collected":"1066393","status_updated_at":"2022-10-19 16:34:27.250235+08","success_rate":null,"comment":"1.2\u53f0Fireeye EX3500\u4e3b\u673a+1\u5e74\u670d\u52a1\uff1b\n2.1\u53f0Fireeye NX4500\u4e3b\u673a+1\u5e74\u670d\u52a1\r\n","contract_type":1,"progress_updated_at":"2022-10-19 16:34:27.250235+08","forecast_updated_at":"2022-10-19 16:34:27.250235+08","end_at":"2021-01-04 16:45:30","pinyin_shortcut":"Fireeyewlyjsxxtcg","creator":1001,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"0.000000000000","remain":"1362 days 20:36:22.72822","progress_remain":"1362 days 20:36:22.72822","forecast_remain":"1362 days 20:36:22.72822","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"59 days 06:49:49.978332","issued_invoices":"2132786.00","client":{"id":1956,"key":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":10,"sales_rep":null,"salesRep":null,"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"1066393.00","pct":"0","profit":"0","project_id":1972}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":167,"key":167,"name":"\u5382\u5546\u4ecb\u7ecd"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesRep":null,"casePoints":{"project_id":1972,"points":"150"},"workLogCount":null,"caseCount":{"project_id":1972,"count":1},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"project_id":1972,"sum":null,"times":null},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":1755,"from_project":1972,"payment_collection_remind_ahead":"00:00:00","serial_no":"TSKJ20201105-HYF","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"1066393","erp_un_settle_amount":"0","including_tax":true,"amount":"1066393.00","contractScans":[{"id":12171,"object_type":105,"object_id":1755,"attachment_id":6219,"attachment":{"id":6219,"key":6219,"name":"b12f35bb-79f9-3491-90e1-56820fca83a8","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b12f35bb-79f9-3491-90e1-56820fca83a8\/\u5408\u540c.pdf","orig_name":"\u5408\u540c.pdf"}}],"receiptScans":[{"id":13003,"object_type":106,"object_id":1755,"attachment_id":6544,"attachment":{"id":6544,"key":6544,"name":"0be0fbde-253e-33ab-ae06-5df3c8410c10","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0be0fbde-253e-33ab-ae06-5df3c8410c10\/\u7b7e\u6536\u5355.jpeg","orig_name":"\u7b7e\u6536\u5355.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":493,"serial_no":"SKD-20201231-00002","wrote_date":"2020-12-31","from_date":null,"handler":1001,"user_id":null,"client_id":1956,"sales_contract_id":1755,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2020-12-31 17:37:28","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"899350.50","settle_amount":"899350.50","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2020-12-31 17:37:28","updated_at":"2020-12-31 17:37:28","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":492,"serial_no":"SKD-20201231-00001","wrote_date":"2020-12-31","from_date":null,"handler":1001,"user_id":null,"client_id":1956,"sales_contract_id":1755,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2020-12-31 17:31:44","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"167042.50","settle_amount":"167042.50","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2020-12-31 17:31:44","updated_at":"2020-12-31 17:31:44","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1493","key":"1493","contract_id":1755,"value":"899350.50","created_by":1014,"collected_date":"2020-12-31 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":84.34},{"id":"1492","key":"1492","contract_id":1755,"value":"167042.50","created_by":1014,"collected_date":"2020-12-31 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":15.66}],"salesContractInvoices":[{"id":955,"key":955,"contract_id":1755,"value":"167042.50","attachment_id":6554,"from_date":"2020-12-23","attachment":{"id":6554,"key":6554,"name":"1fd25757-15d9-3677-a6e6-caf63a9422b4","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/1fd25757-15d9-3677-a6e6-caf63a9422b4\/2020_12_23_18_01_01.pdf","orig_name":"2020_12_23_18_01_01.pdf"}},{"id":965,"key":965,"contract_id":1755,"value":"899350.50","attachment_id":6553,"from_date":"2020-12-23","attachment":{"id":6553,"key":6553,"name":"cd06a30e-1226-38b7-956c-5bbcaa509bec","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/cd06a30e-1226-38b7-956c-5bbcaa509bec\/2020_12_23_18_01_01 2.pdf","orig_name":"2020_12_23_18_01_01 2.pdf"}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":316,"contract_id":1755,"supplier_id":383,"purchase_id":1792,"supplier":{"id":383,"key":383,"name":"\u5317\u4eac\u6717\u7ef4\u8ba1\u7b97\u673a\u5e94\u7528\u6280\u672f\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"purchase":{"id":1792,"key":1792,"serial_no":"TSKJ20201208-HYF-002"}},{"id":974,"contract_id":1755,"supplier_id":46,"purchase_id":1754,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":1754,"key":1754,"serial_no":"DZ20201105312016"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":1066393},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":1972,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":641,"serial_no":"XSDD-20201113-00001","from_date":null,"wrote_date":"2020-11-10","handler":1011,"client_id":1956,"purchase_contract_id":null,"project_id":1972,"sales_contract_id":1755,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2021-01-04 16:45:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"1066393","created_by":1011,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2020-11-13 10:43:33","updated_at":"2021-01-04 16:45:30","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1362,"progress_remain_display":1362,"forecast_remain_display":1362,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":-1066393,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":59,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"106.64\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3910,"client_id":2762,"project_status":3,"project_progress":10,"budget":"3003980","profit_pct":"20.72","bargain_date":"2025-07-11","description":"","created_by":5087,"created_at":"2025-07-09 21:28:44","updated_at":"2026-04-22 15:46:14","engineer_id":null,"project_title":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","collected":"3003980","status_updated_at":"2025-07-13 23:45:04.905541+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-07-13 23:45:04.905541+08","forecast_updated_at":"2025-07-13 23:45:04.905541+08","end_at":"2026-01-14 09:46:36","pinyin_shortcut":"33sgxnxm","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1223,"is_sales_order_ready":true,"collected_plan":3003980,"change_status_to":null,"is_verify":false,"profits":"622424.65600000000000","remain":"364 days 13:25:45.072914","progress_remain":"364 days 13:25:45.072914","forecast_remain":"364 days 13:25:45.072914","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"188 days 12:17:52.695119","issued_invoices":"3003980.00","client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3910,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":10,"product_type_id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","budget":"2516000","pct":"20.72","profit":"521315.2","project_id":3910},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"200000","pct":"20.72","profit":"41440","project_id":3910},{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"287980","pct":"20.72","profit":"59669.45","project_id":3910}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"casePoints":{"project_id":3910,"points":"2546"},"workLogCount":null,"caseCount":{"project_id":3910,"count":36},"salesTimeCount":null,"implementTimeCount":{"project_id":3910,"sum":"177.6","times":"35"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3910,"sum":"6404.33"},"buildContract":{"id":4024,"from_project":3910,"payment_collection_remind_ahead":"15 days","serial_no":"2025EC-BJ-74-0530","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3003980","erp_un_settle_amount":"0","including_tax":true,"amount":"3003980","contractScans":[{"id":55326,"object_type":105,"object_id":4024,"attachment_id":26791,"attachment":{"id":26791,"key":26791,"name":"4abda343-dab5-324c-9385-0a8c0cf82fd7","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4abda343-dab5-324c-9385-0a8c0cf82fd7\/\u534e\u8baf-\u7b7e\u7ea6\u5408\u540c.pdf","orig_name":"\u534e\u8baf-\u7b7e\u7ea6\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":377,"serial_no":"SKD-20250729-00001","wrote_date":"2025-07-29","from_date":null,"handler":5087,"user_id":null,"client_id":2762,"sales_contract_id":4024,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-07-29 13:57:57","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"2102786","settle_amount":"2102786","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-07-29 13:57:57","updated_at":"2025-07-29 13:57:57","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1377","key":"1377","contract_id":4024,"value":"2102786","created_by":1013,"collected_date":"2025-07-29 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":70},{"id":"12123","key":"12123","contract_id":4024,"value":"901194","created_by":1013,"collected_date":"2025-12-22 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":30}],"salesContractInvoices":[{"id":2093,"key":2093,"contract_id":4024,"value":"2102786.00","attachment_id":null,"from_date":"2025-07-11","attachment":null},{"id":2150,"key":2150,"contract_id":4024,"value":"901194.00","attachment_id":null,"from_date":"2025-09-15","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2492,"key":2492,"contract_id":4024,"name":"2025-07-25","value":"2102786","overdue_days":4,"status":1,"remind_date":"2025-07-25","pct":70,"overdue_display":"\u903e\u671f4\u5929"},{"id":2493,"key":2493,"contract_id":4024,"name":"2025-10-31","value":"901194","overdue_days":52,"status":1,"remind_date":"2025-10-31","pct":30,"overdue_display":"\u903e\u671f52\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":9779,"user_id":5087,"key":5087,"contract_id":4024,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesSupplierRels":[{"id":3921,"contract_id":4024,"supplier_id":262,"purchase_id":4367,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4367,"key":4367,"serial_no":"\u8ba2\u5355\u53f7\uff1a3371275009774072"}},{"id":3922,"contract_id":4024,"supplier_id":721,"purchase_id":4085,"supplier":{"id":721,"key":721,"name":"\u5317\u4eac\u7b97\u529b\u4e4b\u5149\u901a\u4fe1\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4085,"key":4085,"serial_no":"SLZG20250811"}},{"id":3923,"contract_id":4024,"supplier_id":608,"purchase_id":4088,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4088,"key":4088,"serial_no":"\u8ba2\u5355\u53f7: 4671680724983161702"}},{"id":3924,"contract_id":4024,"supplier_id":676,"purchase_id":4076,"supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4076,"key":4076,"serial_no":"ALX-Q20250731-0529 "}},{"id":3925,"contract_id":4024,"supplier_id":38,"purchase_id":4077,"supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4077,"key":4077,"serial_no":"YJTS20250806"}},{"id":3926,"contract_id":4024,"supplier_id":718,"purchase_id":4075,"supplier":{"id":718,"key":718,"name":"\u5317\u4eac\u7406\u60f3\u4e91\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4075,"key":4075,"serial_no":"BJLXYT20250801"}},{"id":3927,"contract_id":4024,"supplier_id":478,"purchase_id":4081,"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4081,"key":4081,"serial_no":"TSKJ20250807-HYF-001"}},{"id":3928,"contract_id":4024,"supplier_id":262,"purchase_id":4090,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4090,"key":4090,"serial_no":"\u8ba2\u5355\u53f7\uff1a 320185123830"}},{"id":3929,"contract_id":4024,"supplier_id":608,"purchase_id":4101,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchase":{"id":4101,"key":4101,"serial_no":"\u8ba2\u5355\u53f7: 4691922230281161702"}},{"id":3930,"contract_id":4024,"supplier_id":123,"purchase_id":4102,"supplier":{"id":123,"key":123,"name":"\u667a\u76df\u4e16\u7eaa(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4102,"key":4102,"serial_no":"TSKJ20250819-HYF-001"}},{"id":3931,"contract_id":4024,"supplier_id":262,"purchase_id":4115,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4115,"key":4115,"serial_no":"\u8ba2\u5355\u53f7\uff1a 320899347253"}},{"id":3932,"contract_id":4024,"supplier_id":262,"purchase_id":4126,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4126,"key":4126,"serial_no":"\u8ba2\u5355\u53f7\uff1a321262742811"}},{"id":3933,"contract_id":4024,"supplier_id":478,"purchase_id":4127,"supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4127,"key":4127,"serial_no":"TSKJ20250826-HYF-002"}},{"id":3934,"contract_id":4024,"supplier_id":730,"purchase_id":4140,"supplier":{"id":730,"key":730,"name":"\u6210\u90fd\u5854\u4e07\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":4140,"key":4140,"serial_no":"TAVAN-2025-011"}},{"id":3935,"contract_id":4024,"supplier_id":262,"purchase_id":4162,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4162,"key":4162,"serial_no":"\u8ba2\u5355\uff1a322452140307"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d15\u5929","invoiced":3003980},"projectRemindReceivers":[{"id":1625,"user_id":1001,"key":1001,"project_id":3910,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":11659,"project_id":3910,"product_id":2071,"amount":"200000","number":1,"cost":"100000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"200000","total_cost":"100000","erp_sales_order_product_id":1760,"supplier":null,"product":{"id":2071,"name":"\u5854\u4e07\u4eba\u5de5\u667a\u80fd\u6a21\u5757","product_type":7,"product_component":204,"product_brand":254,"product_serie":1673,"product_misc":null,"product_qa":null,"pn":"","description":"AI\u5927\u6a21\u578b\u63a8\u7406\u5e73\u53f0\u8f6f\u4ef6","created_by":1013,"created_at":"2025-08-06 16:05:49","updated_at":"2025-09-09 17:11:42","pinyin_shortcut":"twrgznmk","product_unit":2,"is_renew":false,"in_out_at":"2025-09-09 17:11:42+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":204,"key":204,"name":"HPC\u8f6f\u4ef6"},"productBrand":{"id":254,"key":254,"name":"\u5854\u4e07"},"productSerie":{"id":1673,"key":1673,"name":"\u5927\u6a21\u578b\u63a8\u7406\u5e73\u53f0\u8f6f\u4ef6"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1760,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2071,"description":"","number":"1","outbound":"1","amount":"200000","total_amount":"200000","last_number":"1","last_amount":"200000","last_total_amount":"200000","cost":"100000","total_cost":"100000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11660,"project_id":3910,"product_id":2065,"amount":"203980","number":1,"cost":"145400","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"203980","total_cost":"145400","erp_sales_order_product_id":1757,"supplier":null,"product":{"id":2065,"name":"\u8054\u60f3\u95ee\u5929WA7780 G3\u670d\u52a1\u5668","product_type":2,"product_component":2,"product_brand":4,"product_serie":1671,"product_misc":null,"product_qa":null,"pn":"","description":"\u914d\u7f6e2\u9897Intel Xeon Platinum 8562Y+ 32C 300W 2.8GHz \u5904\u7406\u5668\n\u914d\u7f6e4\u683964GB DDR5 5600MHz ECC RDIMM\u5185\u5b58\uff0c\u5185\u5b58\u5bb9\u91cf\u4e3a2TB\n\u914d\u7f6e2\u5757480GB\u4f01\u4e1a\u7ea7\u70ed\u63d2\u62d4SSD\u56fa\u6001\u786c\u76d8\uff0c\u914d\u7f6e4\u57573.84TB U.2 \u4f01\u4e1a\u7ea7NVMe SSD\u56fa\u6001\u786c\u76d8\n\u914d\u7f6e2\u5757Mellanox ConnectX-7 NDR\/HDR 200Gb\/s 2\u7aef\u53e3InfiniBand\u9ad8\u901f\u7f51\u5361\uff1b\n\u914d\u7f6e1\u575710\/25GbE SFP28 2\u7aef\u53e3\u4e07\u5146\u4ee5\u592a\u7f51\u5361\uff08\u542bSFP+\u5149\u6a21\u5757\uff09\uff1b\n\u914d\u7f6e1\u57572\u7aef\u53e31GbE RJ45\u5343\u5146\u4ee5\u592a\u7f51\u5361\uff1b","created_by":1013,"created_at":"2025-07-25 13:51:34","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"lxwtWA7780G3fwq","product_unit":1,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":2,"key":2,"name":"\u670d\u52a1\u5668\u4e3b\u673a"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1671,"key":1671,"name":"\u8054\u60f3\u95ee\u5929\u7cfb\u5217"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1757,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2065,"description":"","number":"1","outbound":"1","amount":"203980","total_amount":"203980","last_number":"1","last_amount":"203980","last_total_amount":"203980","cost":"145400","total_cost":"145400","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11661,"project_id":3910,"product_id":2064,"amount":"2516000","number":1,"cost":"1888000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2516000","total_cost":"1888000","erp_sales_order_product_id":1759,"supplier":null,"product":{"id":2064,"name":"NVIDIA H200 8GPU NVLINK\u6a21\u7ec4","product_type":10,"product_component":199,"product_brand":208,"product_serie":1670,"product_misc":null,"product_qa":null,"pn":"","description":"NVIDIA H200 141GB SXM 8GPU NVLINK\u6a21\u7ec4\uff08\u542b8\u4e2aH200 GPU\uff09","created_by":1013,"created_at":"2025-07-25 13:49:37","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"NVIDIAH2008GPUNVLINKmz","product_unit":2,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":10,"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},"productComponent":{"id":199,"key":199,"name":"\u5de5\u4f5c\u7ad9\u914d\u4ef6"},"productBrand":{"id":208,"key":208,"name":"NVIDIA"},"productSerie":{"id":1670,"key":1670,"name":"NVIDIA H200 8GPU NVLINK\u6a21\u7ec4"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1759,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2064,"description":"","number":"1","outbound":"1","amount":"2516000","total_amount":"2516000","last_number":"1","last_amount":"2516000","last_total_amount":"2516000","cost":"1888000","total_cost":"1888000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11662,"project_id":3910,"product_id":2070,"amount":"3000","number":28,"cost":"2250","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"84000","total_cost":"63000","erp_sales_order_product_id":1758,"supplier":null,"product":{"id":2070,"name":"M321R8GA0PB0-CWM","product_type":2,"product_component":4,"product_brand":10,"product_serie":1672,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-08-06 10:47:00","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"M321R8GA0PB0CWM","product_unit":6,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":1672,"key":1672,"name":"\u4e09\u661f 64GB DDR5-5600\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1758,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2070,"description":"","number":"28","outbound":"28","amount":"3000","total_amount":"84000","last_number":"28","last_amount":"3000","last_total_amount":"84000","cost":"2250","total_cost":"63000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11663,"project_id":3910,"product_id":1372,"amount":"0","number":19,"cost":"25","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"475","erp_sales_order_product_id":1832,"supplier":null,"product":{"id":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1047,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-26 16:48:55","updated_at":"2026-07-04 21:40:53","pinyin_shortcut":"LCLCgxx5m","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:40:53.440657+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1832,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":1372,"description":"","number":"19","outbound":"19","amount":"0","total_amount":"0","last_number":"19","last_amount":"0","last_total_amount":"0","cost":"25","total_cost":"475","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11664,"project_id":3910,"product_id":2079,"amount":"0","number":2,"cost":"64","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"128","erp_sales_order_product_id":1833,"supplier":null,"product":{"id":2079,"name":"LC-LC \u5149\u7ea4\u7ebf25\u7c73","product_type":4,"product_component":43,"product_brand":134,"product_serie":1680,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1001,"created_at":"2025-08-08 17:03:40","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"LCLCgxx25m","product_unit":6,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1680,"key":1680,"name":"LC-LC \u5149\u7ea4\u7ebf25\u7c73"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1833,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2079,"description":"","number":"2","outbound":"2","amount":"0","total_amount":"0","last_number":"2","last_amount":"0","last_total_amount":"0","cost":"64","total_cost":"128","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11665,"project_id":3910,"product_id":1943,"amount":"0","number":12,"cost":"15","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"180","erp_sales_order_product_id":1834,"supplier":null,"product":{"id":1943,"name":"\u8d85\u516d\u7c7b\u7f51\u7ebf 5M","product_type":4,"product_component":43,"product_brand":191,"product_serie":813,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-02-26 15:20:21","updated_at":"2026-07-04 21:25:19","pinyin_shortcut":"cllwx5M","product_unit":6,"is_renew":false,"in_out_at":"2026-07-04 21:25:19.277799+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":191,"key":191,"name":"\u957f\u987a\u7f51\u8054"},"productSerie":{"id":813,"key":813,"name":"\u8d85\u516d\u7c7b\u7f51\u7edc\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1834,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":1943,"description":"","number":"12","outbound":"12","amount":"0","total_amount":"0","last_number":"12","last_amount":"0","last_total_amount":"0","cost":"15","total_cost":"180","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11666,"project_id":3910,"product_id":2092,"amount":"0","number":1,"cost":"55","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"55","erp_sales_order_product_id":1835,"supplier":null,"product":{"id":2092,"name":"USB \u5916\u7f6e\u53ea\u8bfbDVD\u5149\u9a71","product_type":11,"product_component":179,"product_brand":250,"product_serie":1642,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-08-12 10:11:10","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"USBwzzdDVDgq","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":250,"key":250,"name":"\u5148\u950b"},"productSerie":{"id":1642,"key":1642,"name":"\u5149\u9a71"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1835,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2092,"description":"","number":"1","outbound":"1","amount":"0","total_amount":"0","last_number":"1","last_amount":"0","last_total_amount":"0","cost":"55","total_cost":"55","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11667,"project_id":3910,"product_id":2089,"amount":"0","number":18,"cost":"1050","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"18900","erp_sales_order_product_id":1836,"supplier":null,"product":{"id":2089,"name":"Q56-200G-A5H","product_type":4,"product_component":43,"product_brand":150,"product_serie":716,"product_misc":null,"product_qa":null,"pn":"","description":"QSFP56 AOC 200G 5M\uff0c\u9ad8\u6027\u80fd\u7ebf\u7f06","created_by":1013,"created_at":"2025-08-11 14:05:04","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"Q56200GA5H","product_unit":6,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":150,"key":150,"name":"\u7eb3\u591a\u5fb7"},"productSerie":{"id":716,"key":716,"name":"\u7ebf\u7f06"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1836,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2089,"description":"","number":"18","outbound":"18","amount":"0","total_amount":"0","last_number":"18","last_amount":"0","last_total_amount":"0","cost":"1050","total_cost":"18900","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11668,"project_id":3910,"product_id":2094,"amount":"0","number":1,"cost":"979","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"979","erp_sales_order_product_id":1837,"supplier":null,"product":{"id":2094,"name":"WDBAGF0020BGY","product_type":11,"product_component":179,"product_brand":260,"product_serie":1690,"product_misc":null,"product_qa":null,"pn":"","description":"\u897f\u90e8\u6570\u636e\uff08WD\uff092TB NVMe \u79fb\u52a8\u56fa\u6001\u786c\u76d8\uff08PSSD\uff09My Passport\u968f\u884cSSD type-c\u63a5\u53e3 1050MB\/s \u624b\u673a\u76f4\u8fde\u7b14\u8bb0\u672c\u4e24\u7528\u5916\u63a5","created_by":1013,"created_at":"2025-08-13 11:18:56","updated_at":"2025-08-15 11:06:34","pinyin_shortcut":"WDBAGF0020BGY","product_unit":3,"is_renew":false,"in_out_at":"2025-08-15 11:06:34+08","productType":{"id":11,"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},"productComponent":{"id":179,"key":179,"name":"\u914d\u4ef6"},"productBrand":{"id":260,"key":260,"name":"\u897f\u90e8\u6570\u636e"},"productSerie":{"id":1690,"key":1690,"name":"\u786c\u76d8"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1837,"erp_sales_order_id":1538,"erp_store_id":null,"product_id":2094,"description":"","number":"1","outbound":"1","amount":"0","total_amount":"0","last_number":"1","last_amount":"0","last_total_amount":"0","cost":"979","total_cost":"979","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3910,"comment":6},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1538,"serial_no":"XSDD-20250711-00001","from_date":null,"wrote_date":"2025-07-11","handler":5087,"client_id":2762,"purchase_contract_id":null,"project_id":3910,"sales_contract_id":4024,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"","stop_at":"2025-08-13 11:25:19.519832+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"84","amount":"3003980","created_by":5087,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-07-11 11:32:13","updated_at":"2025-08-13 11:25:19","print_times":null},"projectUsedClient":{"id":155,"project_id":3910,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":364,"progress_remain_display":364,"forecast_remain_display":364,"projectProductTotalAmount":3003980,"projectProductAllAmount":true,"projectProductTotalCost":2217117,"projectProductAllCost":true,"projectProductTotalNumber":84,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":188,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"300.4\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3577,"client_id":3278,"project_status":3,"project_progress":9,"budget":"198354","profit_pct":"-0.71","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 10:50:35","updated_at":"2026-04-20 14:20:09","engineer_id":null,"project_title":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","collected":"198354","status_updated_at":"2024-06-26 10:50:35.474112+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-06-26 10:50:35.474112+08","forecast_updated_at":"2024-06-26 10:50:35.474112+08","end_at":"2024-09-24 13:35:40","pinyin_shortcut":"PA1410fhq2txgxm","creator":1001,"used_client":null,"from_contact":1262,"total_contact_point":"26476","paid_contact_point":"26476","project_product_version_id":523,"is_sales_order_ready":true,"collected_plan":198354,"change_status_to":null,"is_verify":false,"profits":"-1408.313400000000000000","remain":"747 days 02:20:14.504343","progress_remain":"747 days 02:20:14.504343","forecast_remain":"747 days 02:20:14.504343","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"90 days 02:45:04.663669","issued_invoices":"198354.00","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"198354.00","pct":"-0.71","profit":"-1408.3134","project_id":3577}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355","description":"\u4fdd\u63015%\u57fa\u672c\u5229\u6da6\u7387\uff0c\u5e2e\u52a9\u5382\u5546\u4ea4\u4ed8\u9879\u76ee\u3002"},"opportunityFrom":null,"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"projectCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"casePoints":{"project_id":3577,"points":"0"},"workLogCount":null,"caseCount":{"project_id":3577,"count":1},"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":{"project_id":3577,"sum":null,"times":null},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3364,"from_project":3577,"payment_collection_remind_ahead":"7 days","serial_no":"TS-HYF-2024062501","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"198354","erp_un_settle_amount":"0","including_tax":true,"amount":"198354","contractScans":[{"id":31070,"object_type":105,"object_id":3364,"attachment_id":19980,"attachment":{"id":19980,"key":19980,"name":"3f4fb0c6-72d6-34ed-ade6-f90f9c306016","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3f4fb0c6-72d6-34ed-ade6-f90f9c306016\/\u521b\u5b89\u5149\u901a.pdf","orig_name":"\u521b\u5b89\u5149\u901a.pdf"}}],"receiptScans":[{"id":27594,"object_type":106,"object_id":3364,"attachment_id":20715,"attachment":{"id":20715,"key":20715,"name":"4626bfd6-f39b-38de-bc6e-d57b6a614c1b","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4626bfd6-f39b-38de-bc6e-d57b6a614c1b\/WechatIMG180.jpeg","orig_name":"WechatIMG180.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":115,"serial_no":"SKD-20240924-00002","wrote_date":"2024-09-24","from_date":null,"handler":1001,"user_id":null,"client_id":3278,"sales_contract_id":3364,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2024-09-24 13:35:39","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"198354","settle_amount":"198354","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-24 13:35:39","updated_at":"2024-09-24 13:35:39","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1115","key":"1115","contract_id":3364,"value":"198354","created_by":1013,"collected_date":"2024-09-24 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1740,"key":1740,"contract_id":3364,"value":"198354.00","attachment_id":null,"from_date":"2024-08-05","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2010,"key":2010,"contract_id":3364,"name":"2024-09-19","value":"198354","overdue_days":5,"status":1,"remind_date":"2024-09-19","pct":100,"overdue_display":"\u903e\u671f5\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7325,"user_id":1001,"key":1001,"contract_id":3364,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"salesSupplierRels":[{"id":2199,"contract_id":3364,"supplier_id":90,"purchase_id":3365,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3365,"key":3365,"serial_no":"X_2024SBQ15876"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":198354},"projectRemindReceivers":[{"id":1091,"user_id":1001,"key":1001,"project_id":3577,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":7951,"project_id":3577,"product_id":969,"amount":"47830","number":2,"cost":"35000","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"95660","total_cost":"70000","erp_sales_order_product_id":969,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":969,"name":"PAN-PA-1410","product_type":5,"product_component":26,"product_brand":8,"product_serie":607,"product_misc":null,"product_qa":null,"pn":"","description":"Palo Alto Networks PA-1410","created_by":1013,"created_at":"2023-08-04 15:49:28","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"PANPA1410","product_unit":1,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":969,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":969,"description":"","number":"2","outbound":"0","amount":"47830","total_amount":"95660","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"35000","total_cost":"70000","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7952,"project_id":3577,"product_id":1586,"amount":"11868","number":2,"cost":"15203.5","description":"","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null,"total_amount":"23736","total_cost":"30407.0","erp_sales_order_product_id":970,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1586,"name":"PAN-SVC-BKLN-1410","product_type":5,"product_component":35,"product_brand":8,"product_serie":1359,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Partner enabled premium support, 1 year (12 months) term.","created_by":1013,"created_at":"2024-04-26 09:35:29","updated_at":"2024-06-26 13:07:03","pinyin_shortcut":"PANSVCBKLN1410","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1359,"key":1359,"name":"PA-1410\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":970,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1586,"description":"","number":"2","outbound":"0","amount":"11868","total_amount":"23736","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"15203.5","total_cost":"30407.0","supplier_id":90,"hardware_from":"2025-07-31","software_from":null,"maintenance_from":null,"hardware_to":"2025-07-31","software_to":null,"maintenance_to":null}},{"id":7953,"project_id":3577,"product_id":1657,"amount":"39479","number":2,"cost":"30000","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null,"total_amount":"78958","total_cost":"60000","erp_sales_order_product_id":971,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1657,"name":"PAN-PA-1410-BND-CORESEC","product_type":5,"product_component":36,"product_brand":8,"product_serie":1243,"product_misc":null,"product_qa":null,"pn":"","description":"PA-1410, Core Security Subscription Bundle (Advanced Threat Prevention, Advanced URL Filtering, Advanced Wildfire, DNS Security and SD-WAN ), 1 years (12 months) term\n","created_by":1013,"created_at":"2024-06-26 10:53:31","updated_at":"2024-06-26 10:53:31","pinyin_shortcut":"PANPA1410BNDCORESEC","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1243,"key":1243,"name":"PA1410\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":971,"erp_sales_order_id":1271,"erp_store_id":null,"product_id":1657,"description":"","number":"2","outbound":"0","amount":"39479","total_amount":"78958","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"30000","total_cost":"60000","supplier_id":90,"hardware_from":null,"software_from":"2024-08-01","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-31","maintenance_to":null}}],"commentCount":{"object_id":3577,"comment":3},"unreadComments":null,"fromContact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"mobiles":[{"id":6789,"contact_id":1262,"mobile":"15810817538","mp_open_id":null}],"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPoints":[{"id":774,"project_id":3577,"contact_id":1262,"point":"26476.00","paid_point":"26476","contact":{"id":1262,"key":1262,"name":"\u5218\u70b3\u5764","client_id":null,"supplier_id":100,"client":null,"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"}},"projectContactPointRels":[{"id":138,"project_id":3577,"contact_id":1262,"point":"26476.00","day_at":"2024-12-16","description":"","created_at":"2024-12-16 10:10:44"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1271,"serial_no":"XSDD-20240626-00002","from_date":null,"wrote_date":"2024-06-25","handler":1001,"client_id":3278,"purchase_contract_id":null,"project_id":3577,"sales_contract_id":3364,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-09-24 13:35:40","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"198354","created_by":1001,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-06-26 10:50:35","updated_at":"2024-09-24 13:35:40","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":747,"progress_remain_display":747,"forecast_remain_display":747,"projectProductTotalAmount":198354,"projectProductAllAmount":true,"projectProductTotalCost":160407,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":90,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"19.84\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":26476,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3873,"client_id":48,"project_status":3,"project_progress":9,"budget":"62075.1","profit_pct":"76.05","bargain_date":"2025-06-24","description":"","created_by":1004,"created_at":"2025-05-29 14:02:17","updated_at":"2026-04-15 10:29:06","engineer_id":null,"project_title":"2025\u5e74\u6570\u636e\u4e2d\u5fc3\u7ef4\u4fdd","collected":"62075.1","status_updated_at":"2025-06-24 17:49:25.334992+08","success_rate":null,"comment":"","contract_type":2,"progress_updated_at":"2025-06-24 17:48:20.531314+08","forecast_updated_at":"2025-06-24 17:48:20.531314+08","end_at":"2026-01-14 09:54:04","pinyin_shortcut":"2025nsjzxwb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1234,"is_sales_order_ready":true,"collected_plan":62075.1,"change_status_to":null,"is_verify":false,"profits":"47208.113550000000000000","remain":"383 days 19:21:24.643463","progress_remain":"383 days 19:22:29.447141","forecast_remain":"383 days 19:22:29.447141","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"229 days 19:51:46.977064","issued_invoices":"62075.10","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"21157.6","pct":"76.05","profit":"16090.35","project_id":3873},{"id":2,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"26046.5","pct":"76.05","profit":"19808.36","project_id":3873},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"14871","pct":"76.05","profit":"11309.39","project_id":3873}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3873,"points":"884"},"workLogCount":null,"caseCount":{"project_id":3873,"count":19},"salesTimeCount":null,"implementTimeCount":{"project_id":3873,"sum":"31.75","times":"18"},"presalesTimeCount":{"project_id":3873,"sum":"0.966666666666667","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3873,"sum":"1044.63"},"buildContract":{"id":3998,"from_project":3873,"payment_collection_remind_ahead":"1 day","serial_no":"TS-YJC-20250526-001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"62075.1","erp_un_settle_amount":"0","including_tax":true,"amount":"62075.1","contractScans":[{"id":55337,"object_type":105,"object_id":3998,"attachment_id":26540,"attachment":{"id":26540,"key":26540,"name":"f60f6e42-f01c-31e2-9913-9b08f0b63f0a","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f60f6e42-f01c-31e2-9913-9b08f0b63f0a\/\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u6570\u79d1\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":361,"serial_no":"SKD-20250630-00001","wrote_date":"2025-06-30","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3998,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2025-06-30 09:50:54","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"62075.1","settle_amount":"62075.1","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-06-30 09:50:54","updated_at":"2025-06-30 09:50:54","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1361","key":"1361","contract_id":3998,"value":"62075.1","created_by":1013,"collected_date":"2025-06-30 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2084,"key":2084,"contract_id":3998,"value":"62075.10","attachment_id":null,"from_date":"2025-06-25","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2475,"key":2475,"contract_id":3998,"name":"2025-07-31","value":"62075.1","overdue_days":null,"status":1,"remind_date":"2025-07-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9790,"user_id":1004,"key":1004,"contract_id":3998,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":3949,"contract_id":3998,"supplier_id":236,"purchase_id":4004,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4004,"key":4004,"serial_no":"TSKJ20250630-HYF-002"}},{"id":3950,"contract_id":3998,"supplier_id":116,"purchase_id":4220,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":4220,"key":4220,"serial_no":"20251028001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":62075.1},"projectRemindReceivers":[],"projectProductRels":[{"id":11706,"project_id":3873,"product_id":922,"amount":"7800","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"7800","total_cost":null,"erp_sales_order_product_id":1734,"supplier":null,"product":{"id":922,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1024,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-05-08 12:11:04","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"sxfzdjcxyptEDRxbfw","product_unit":2,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1024,"key":1024,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0EDR\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1734,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":922,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":"1","last_amount":"7800","last_total_amount":"7800","cost":"5000.00","total_cost":"5000","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11707,"project_id":3873,"product_id":1663,"amount":"3960","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null,"total_amount":"3960","total_cost":null,"erp_sales_order_product_id":1732,"supplier":null,"product":{"id":1663,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1414,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:30:00","updated_at":"2024-07-04 15:30:00","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1414,"key":1414,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1732,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1663,"description":"","number":"1","outbound":"0","amount":"3960","total_amount":"3960","last_number":"1","last_amount":"3960","last_total_amount":"3960","cost":"2714.00","total_cost":"2714","supplier_id":null,"hardware_from":null,"software_from":"2025-07-25","maintenance_from":null,"hardware_to":null,"software_to":"2026-07-25","maintenance_to":null}},{"id":11708,"project_id":3873,"product_id":1664,"amount":"3111","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null,"total_amount":"3111","total_cost":null,"erp_sales_order_product_id":1733,"supplier":null,"product":{"id":1664,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1415,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-04 15:31:49","updated_at":"2024-07-04 15:31:49","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1250","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1415,"key":1415,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1250\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1733,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1664,"description":"","number":"1","outbound":"0","amount":"3111","total_amount":"3111","last_number":"1","last_amount":"3111","last_total_amount":"3111","cost":"2261.00","total_cost":"2261","supplier_id":null,"hardware_from":"2025-07-25","software_from":null,"maintenance_from":null,"hardware_to":"2026-07-25","software_to":null,"maintenance_to":null}},{"id":11709,"project_id":3873,"product_id":941,"amount":"21157.6","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13","total_amount":"21157.6","total_cost":null,"erp_sales_order_product_id":1730,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1730,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","last_number":"1","last_amount":"21157.6","last_total_amount":"21157.6","cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":"2025-07-14","hardware_to":null,"software_to":null,"maintenance_to":"2026-07-13"}},{"id":11710,"project_id":3873,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null,"total_amount":"26046.50","total_cost":"7500","erp_sales_order_product_id":1731,"supplier":null,"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e745*9\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e745*9\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1731,"erp_sales_order_id":1529,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"5","amount":"5209.3","total_amount":"26046.50","last_number":"5","last_amount":"5209.3","last_total_amount":"26046.50","cost":"1500","total_cost":"7500","supplier_id":null,"hardware_from":"2025-08-08","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-07","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3873,"comment":8},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1529,"serial_no":"XSDD-20250624-00002","from_date":null,"wrote_date":"2025-06-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3873,"sales_contract_id":3998,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-06-30 09:50:54","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"9","amount":"62075.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-06-24 17:49:25","updated_at":"2025-06-30 09:50:54","print_times":null},"projectUsedClient":{"id":138,"project_id":3873,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":383,"progress_remain_display":383,"forecast_remain_display":383,"projectProductTotalAmount":62075.1,"projectProductAllAmount":true,"projectProductTotalCost":7500,"projectProductAllCost":false,"projectProductTotalNumber":9,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":229,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"6.21\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":4055,"client_id":90,"project_status":3,"project_progress":9,"budget":"140250","profit_pct":"35.97","bargain_date":"2025-12-11","description":"","created_by":5295,"created_at":"2025-11-26 10:40:24","updated_at":"2026-03-25 16:32:13","engineer_id":null,"project_title":"2025veeam\u7eed\u4fdd\u53ca\u786c\u4ef6\u7ef4\u4fdd","collected":"140250","status_updated_at":"2025-12-11 14:45:14.353529+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-12-08 10:32:40.700324+08","forecast_updated_at":"2025-12-08 10:32:40.700324+08","end_at":"2026-01-07 10:45:31","pinyin_shortcut":"2025veeamxbjyjwb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"30000","paid_contact_point":null,"project_product_version_id":1109,"is_sales_order_ready":true,"collected_plan":140250,"change_status_to":null,"is_verify":false,"profits":"50447.925000000000000000","remain":"213 days 22:25:35.624926","progress_remain":"217 days 02:38:09.278131","forecast_remain":"217 days 02:38:09.278131","lost_contact_days":"215.929502065451","last_contact":"2025-12-09 14:52:21","last_arrive_days":"215.929502065451","last_arrive":"2025-12-09 14:52:21+08","duration":"42 days 00:05:07.282632","issued_invoices":"140250.00","client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","logo":null,"client_type":1,"client_class":1,"client_industry":10,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4055,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":19,"product_type_id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1","budget":"17050","pct":"35.97","profit":"6132.88","project_id":4055},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"123200","pct":"35.97","profit":"44315.04","project_id":4055}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":4055,"points":"218"},"workLogCount":{"project_id":4055,"count":3},"caseCount":{"project_id":4055,"count":5},"salesTimeCount":{"project_id":4055,"hours":"1.67527777777778","times":2},"implementTimeCount":{"project_id":4055,"sum":"15","times":"5"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":4055,"sum":"82.00"},"buildContract":{"id":4304,"from_project":4055,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20251204001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"140250","erp_un_settle_amount":"0","including_tax":true,"amount":"140250","contractScans":[{"id":55061,"object_type":105,"object_id":4304,"attachment_id":30402,"attachment":{"id":30402,"key":30402,"name":"41aafbfe-7964-3554-9408-a1dd019a4c7f","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/41aafbfe-7964-3554-9408-a1dd019a4c7f\/\u82cf\u9ece\u4e16\u5408\u540c140250\u5143.pdf","orig_name":"\u82cf\u9ece\u4e16\u5408\u540c140250\u5143.pdf"}}],"receiptScans":[{"id":53946,"object_type":106,"object_id":4304,"attachment_id":30654,"attachment":{"id":30654,"key":30654,"name":"f8432f2c-551a-3903-9209-1abf347bb504","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f8432f2c-551a-3903-9209-1abf347bb504\/\u7b7e\u6536\u5355_2026.pdf","orig_name":"\u7b7e\u6536\u5355_2026.pdf"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12138","key":"12138","contract_id":4304,"value":"140250","created_by":1013,"collected_date":"2025-12-29 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2245,"key":2245,"contract_id":4304,"value":"140250.00","attachment_id":null,"from_date":"2025-12-15","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2674,"key":2674,"contract_id":4304,"name":"2026-02-15","value":"140250","overdue_days":null,"status":1,"remind_date":"2026-02-15","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":3760,"contract_id":4304,"supplier_id":67,"purchase_id":4309,"supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":4309,"key":4309,"serial_no":"XM20251215000246"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":140250},"projectRemindReceivers":[{"id":2023,"user_id":1001,"key":1001,"project_id":4055,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":2024,"user_id":1005,"key":1005,"project_id":4055,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"projectProductRels":[{"id":11241,"project_id":4055,"product_id":1511,"amount":"30800","number":4,"cost":"10240","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"123200","total_cost":"40960","erp_sales_order_product_id":2047,"supplier":null,"product":{"id":1511,"name":"V-FDNVUL-0I-SU1AR-00","product_type":7,"product_component":30,"product_brand":16,"product_serie":1240,"product_misc":null,"product_qa":null,"pn":"","description":"Veeam Data Platform Foundation Universal Subscription License. Includes Enterprise Plus Edition features. 1 Year Renewal Subscription Upfront Billing & Production (24\/7) Support. 10 instance pack.","created_by":1001,"created_at":"2024-03-13 17:49:30","updated_at":"2026-01-30 13:24:39","pinyin_shortcut":"VFDNVUL0ISU1AR00","product_unit":2,"is_renew":true,"in_out_at":"2026-01-30 13:24:39.260488+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":16,"key":16,"name":"Veeam"},"productSerie":{"id":1240,"key":1240,"name":"Veeam VDP\u4e00\u5e74\u8ba2\u9605\u5f0f\u4f01\u4e1a\u589e\u5f3a\u7248\uff08\u7eed\u4fdd\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2047,"erp_sales_order_id":1641,"erp_store_id":null,"product_id":1511,"description":"","number":"4","outbound":"4","amount":"30800","total_amount":"123200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"10240","total_cost":"40960","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11242,"project_id":4055,"product_id":941,"amount":"17050","number":1,"cost":"0","description":"3\u5957CISCO UCS\/NetApp\u5b58\u50a8\u7cfb\u7edf\/Veeam\u5907\u4efd\u30011*E2724\u30011*FAS2750\u30011*FAS2650\u30011*DL388 Gen9\u30011*\u601d\u79d1MDS9148","supplier_id":null,"hardware_from":"2026-01-01","software_from":null,"maintenance_from":null,"hardware_to":"2026-12-31","software_to":null,"maintenance_to":null,"total_amount":"17050","total_cost":"0","erp_sales_order_product_id":2048,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":2048,"erp_sales_order_id":1641,"erp_store_id":null,"product_id":941,"description":"3\u5957CISCO UCS\/NetApp\u5b58\u50a8\u7cfb\u7edf\/Veeam\u5907\u4efd\u30011*E2724\u30011*FAS2750\u30011*FAS2650\u30011*DL388 Gen9\u30011*\u601d\u79d1MDS9148","number":"1","outbound":"1","amount":"17050","total_amount":"17050","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":"2026-01-01","software_from":null,"maintenance_from":null,"hardware_to":"2026-12-31","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":4055,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1312,"project_id":4055,"contact_id":443,"point":"30000.00","paid_point":null,"contact":{"id":443,"key":443,"name":"\u5b59\u51ef","client_id":90,"supplier_id":null,"client":{"id":90,"key":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1641,"serial_no":"XSDD-20251211-00002","from_date":null,"wrote_date":"2025-12-11","handler":5295,"client_id":90,"purchase_contract_id":null,"project_id":4055,"sales_contract_id":4304,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-11 15:06:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"5","amount":"140250","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"140250\",\"remind_date\":\"2026-02-15\",\"pct\":1}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-11 14:45:14","updated_at":"2025-12-11 15:06:14","print_times":null},"projectUsedClient":{"id":263,"project_id":4055,"used_client":null,"budget":null,"profit":null,"profit_pct":null,"collected_plan":null,"remind_ahead":null,"usedClient":null,"projectUsedClientPaymentCollectionRemindReceivers":[],"projectUsedClientPaymentCollectionRemindDates":[],"projectUsedClientPayments":[],"projectUsedClientInvoices":[],"invoiced":0,"collected":0,"un_invoiced":0,"un_collected":0,"remind_ahead_display":"\u4e0d\u63d0\u9192","project_used_client_collected_plan":0,"project_used_client_collected_plan_pct":""},"erpSalesOrderVerify":null,"remain_display":213,"progress_remain_display":217,"forecast_remain_display":217,"projectProductTotalAmount":140250,"projectProductAllAmount":true,"projectProductTotalCost":40960,"projectProductAllCost":true,"projectProductTotalNumber":5,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"7\u4e2a\u6708\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":42,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"7\u4e2a\u6708\u524d","can_view_product":true,"budget_display":"14.03\u4e07","contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":30000,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":79,"erp_sales_order_id":1641,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-11 15:06:14","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}]}],"pagenation":{"totalcount":1637,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 13:10:50', 500204032) RETURNING "id"
13:10:50.1797.4 msyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "c"."project_id"
13:10:50.3556.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id"=1262
13:10:50.1236.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (45, 159, 165, 179, 142, 136, 139, 129, 167, 175, 107, 226, 183, 189, 8, 184, 185, 191, 228, 128, 1, 166, 171, 304, 154, 5, 172, 137, 140, 192, 197, 199, 319, 348, 2100000000, 130, 181, 232, 349, 367, 369, 377, 359, 340, 350, 313, 164)) ORDER BY "sort"
13:10:49.8945.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:10:50.1885.0 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "project_id"
13:10:50.3634.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100
13:10:50.3513.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=1262
13:10:50.2143.7 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "collected_date" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388) ORDER BY "id" DESC
13:10:50.1973.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388))
13:10:50.2013.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (753, 3675, 6219, 5271, 7201, 19980, 30402, 26791, 26540, 31575)
13:10:49.9003.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
13:10:50.2463.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (969, 1586, 1657, 1511, 941, 2071, 2065, 2064, 2070, 1372, 2079, 1943, 2092, 2089, 2094, 922, 1663, 1664, 1376, 2171)
13:10:50.2053.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388))
13:10:50.2093.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388))
13:10:50.1562.9 msyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055) GROUP BY "project_id"
13:10:50.3692.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (443, 1262)
13:10:49.9062.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
13:10:50.1111.9 msyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.2281.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (5693, 5209, 5400, 5690, 6554, 6553, 7207)
13:10:50.1001.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (399, 982, 146, 1661, 3435, 1956, 2762, 3278, 48, 90)
13:10:50.2121.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388)) ORDER BY "id" DESC
13:10:50.1381.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (399, 982, 146, 1661, 3435, 1956, 2762, 3278, 48, 90)
13:10:50.3741.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055))
13:10:50.1931.2 msyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.1081.2 msyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055) ORDER BY "contribution" DESC, "engineer_id"
13:10:50.2431.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055) ORDER BY "id"
13:10:50.1541.1 msyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "project_id"
13:10:50.1591.0 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "project_id"
13:10:50.1871.0 msyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)) GROUP BY "project_id"
13:10:50.2301.0 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388) ORDER BY "remind_date"
13:10:50.2371.0 msyii\db\Command::querySELECT "id", "sales_contract_id", "status" FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388) ORDER BY "id" DESC
13:10:50.1030.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5087, 1004, 1005, 1001))
13:10:50.2350.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (383, 252, 365, 305, 46, 90, 67, 262, 721, 608, 676, 38, 718, 478, 123, 730, 236, 116)
13:10:50.2330.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388)
13:10:50.3670.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.3790.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055))
13:10:50.2360.7 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (1792, 1234, 1559, 1213, 1754, 3365, 4309, 4367, 4085, 4088, 4076, 4077, 4075, 4081, 4090, 4101, 4102, 4115, 4126, 4127, 4140, 4162, 4004, 4220)
13:10:50.2530.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1359, 1243, 1414, 1415, 1024, 592, 1673, 1680, 1670, 1672, 1690, 716, 1671, 813, 1052, 1642, 1724, 1240, 1047, 607)
13:10:50.2310.7 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (195, 1186, 1558, 1755, 1930, 3364, 3998, 4024, 4304, 4388)
13:10:50.1300.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.1020.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1001, 1004, 5087, 1005)
13:10:50.1350.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 4)
13:10:50.3730.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((443, 4055), (1262, 3577))
13:10:50.1050.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (1, 5, 6)
13:10:50.2520.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 12, 133, 254, 134, 208, 10, 260, 150, 4, 191, 250, 270, 16)
13:10:50.1050.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (1, 43, 47)
13:10:50.1310.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.2510.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (35, 36, 208, 189, 200, 151, 204, 43, 199, 4, 179, 2, 13, 159, 30, 26)
13:10:50.1100.6 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
13:10:50.3750.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.1060.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (10, 13, 4, 5, 8, 1)
13:10:50.1110.6 msyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (10, 49, 9)
13:10:50.3780.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (155, 138, 263, 289)
13:10:50.2500.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 22, 19, 7, 4, 10, 2, 11)
13:10:50.2380.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1675, 1641, 1538, 1529, 1271, 699, 641, 584, 471, 74) ORDER BY "id"
13:10:50.1070.5 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
13:10:50.3760.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (155, 138, 263, 289)
13:10:50.3770.5 msyii\db\Command::querySELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (155, 138, 263, 289)
13:10:50.1310.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (45, 159, 165, 179, 142, 136, 139, 129, 167, 175, 107, 226, 183, 189, 8, 184, 185, 191, 228, 128, 1, 166, 171, 304, 154, 5, 172, 137, 140, 192, 197, 199, 319, 348, 2100000000, 130, 181, 232, 349, 367, 369, 377, 359, 340, 350, 313, 164)) ORDER BY "sort"
13:10:50.1360.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003, 1005, 1011, 5087, 1004, 5295)
13:10:50.1340.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5087, 1004, 1005, 1003, 1001))
13:10:50.2530.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 7, 6, 3, 1, 8)
13:10:50.1330.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003, 1005, 5087, 1004, 5295)
13:10:50.1370.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5087, 1004, 1005, 1011, 1003, 1001))
13:10:50.2420.5 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (263, 1111, 2504, 1791, 4111, 1972, 3910, 3577, 3873, 4055)
13:10:50.2410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1675, 1641, 1538, 1529, 1271, 699, 641, 584, 471, 74) ORDER BY "id"
13:10:50.1320.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (45, 159, 165, 179, 142, 136, 139, 129, 167, 175, 107, 226, 183, 189, 8, 184, 185, 191, 228, 128, 1, 166, 171, 304, 154, 5, 172, 137, 140, 192, 197, 199, 319, 348, 2100000000, 130, 181, 232, 349, 367, 369, 377, 359, 340, 350, 313, 164)) ORDER BY "sort"
13:10:50.2400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1675, 1641, 1538, 1529, 1271, 699, 641, 584, 471, 74) ORDER BY "id"
13:10:50.1400.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5087, 1004, 1005, 1001))
13:10:50.2080.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (6544, 5320, 7202, 395, 5408, 20715, 30654)
13:10:50.1390.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1001, 1004, 5087, 1005)
13:10:50.3780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (155, 138, 263, 289)
13:10:50.3720.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=90
13:10:50.2180.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013, 5064)
13:10:50.2330.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5087, 1004, 1011, 1003, 5252, 1001))
13:10:50.2320.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1003, 1011, 5087, 1004, 5252)
13:10:50.2400.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
13:10:50.3720.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100
13:10:50.2390.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:10:50.2420.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
13:10:50.2450.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=90
13:10:50.2430.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 1001))