ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a24e1191e49a: POST https://beta.jinchangxiao.com/v2/project/of-client at 2026-06-07 11:10:17 am by 111.9.5.86

Performance Profiling

Total processing time: 455 ms; Peak memory: 7.972 MB. Show Profiling Timeline

总计81条数据
TimeDurationCategoryInfo
  
11:10:17.17829.3 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, 5301, 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"."client_id"=93) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c"
11:10:17.50127.4 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "object_id"
11:10:17.52921.4 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "object_id"
11:10:17.41219.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (20020, 25332, 29909)
11:10:17.38017.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19978, 23653, 23652)
11:10:17.31314.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(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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "c"."project_id"
11:10:17.43413.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (4497, 4074, 3325, 3679, 3705)) ORDER BY "id" DESC
11:10:17.29412.2 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417) GROUP BY "c"."project_id"
11:10:17.35311.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (19507, 23140, 22964, 27622)
11:10:17.44811.3 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 (4497, 4074, 3325, 3679, 3705) ORDER BY "id" DESC
11:10:17.21111.0 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, 5301, 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"."client_id"=93) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10
11:10:17.25610.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=3
11:10:17.3689.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4497, 4074, 3325, 3679, 3705))
11:10:17.4019.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4497, 4074, 3325, 3679, 3705))
11:10:17.4669.0 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4137, 3340, 3817, 3687, 3387, 3461, 3723)
11:10:17.4798.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 941, 1227, 942, 899, 900, 1886, 220, 1906, 1907, 2127, 952, 2126)
11:10:17.1386.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
11:10:17.5705.5 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, 2, 1159, 'v2/project/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"93","page":"1","posttime":"1780801792","token":"727a5d32f211a1acba6b637f96b0819a","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":4146,"client_id":93,"project_status":3,"project_progress":3,"budget":"500000","profit_pct":"15","bargain_date":"2026-06-05","description":null,"created_by":1005,"created_at":"2026-03-20 13:31:49","updated_at":"2026-06-05 11:27:18","engineer_id":null,"project_title":"\u98de\u5854\u96f6\u4fe1\u4efb\u65b0\u8d2d","collected":"0","status_updated_at":"2026-06-05 11:27:18.441125+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-20 13:31:49.105412+08","forecast_updated_at":"2026-06-05 11:21:31.150777+08","end_at":"","pinyin_shortcut":"ftlxrxg","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":true,"collected_plan":0,"change_status_to":5,"is_verify":true,"profits":"75000.0000000000000000","remain":"1 day 23:42:58.7722","progress_remain":"78 days 21:38:28.107913","forecast_remain":"1 day 23:48:46.062548","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"78 days 21:38:28.107913","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"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":3,"key":3,"name":"\u65b9\u6848\u8bbe\u8ba1","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u9762\u4e34\u7684\u95ee\u9898\u53ca\u6311\u6218\uff0c \u63d0\u51fa\u6211\u65b9\u7684\u4ea7\u54c1\u65b9\u6848\u3002\u5177\u4f53\u7684\u54c1\u724c\uff0c \u578b\u53f7\uff0c\u914d\u7f6e\uff0c\u4fdd\u4fee\u3002 \n\u65b9\u6cd5\uff1a\u5c06\u5ba2\u6237\u7684\u95ee\u9898\u53ca\u9700\u6c42\u7528\u6587\u5b57\u63cf\u8ff0\u51fa\u6765\uff0c\u4ea4\u7ed9\u552e\u524d\u6216\u5382\u5546\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"500000","pct":"15","profit":"75000","project_id":4146}],"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":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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":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":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4497,"from_project":4146,"payment_collection_remind_ahead":"1 day","serial_no":"2026-06-05-007","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"0","erp_un_settle_amount":"500000","including_tax":true,"amount":"500000","contractScans":[],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[],"salesContractInvoices":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":10168,"user_id":1001,"key":1001,"contract_id":4497,"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":10169,"user_id":5087,"key":5087,"contract_id":4497,"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"}}},{"id":10170,"user_id":1005,"key":1005,"contract_id":4497,"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"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":0},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":4146,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1,"progress_remain_display":78,"forecast_remain_display":1,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":500000,"is_exceeded":false,"can_update":false,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_invoice":true,"can_payment":true,"duration_display":78,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"50\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":2,"un_collected":"500000","un_invoiced":500000,"object_type":1},{"id":4135,"client_id":93,"project_status":2,"project_progress":6,"budget":"288000","profit_pct":"15","bargain_date":"2026-03-31","description":null,"created_by":1005,"created_at":"2026-03-08 22:16:50","updated_at":"2026-03-22 19:23:34","engineer_id":null,"project_title":"\u65b0\u8d2d\u98de\u5854\u8d1f\u8f7d\u5747\u8861","collected":"0","status_updated_at":"2026-03-08 22:16:50.48654+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-08 22:16:50.48654+08","forecast_updated_at":"2026-03-08 22:16:50.48654+08","end_at":"","pinyin_shortcut":"xgftfzjh","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"15000","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":"43200.0000000000000000","remain":"90 days 12:53:26.726785","progress_remain":"90 days 12:53:26.726785","forecast_remain":"90 days 12:53:26.726785","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"90 days 12:53:26.726785","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"288000","pct":"15","profit":"43200","project_id":4135}],"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":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":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":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":4135,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1413,"project_id":4135,"contact_id":4701,"point":"10000.00","paid_point":null,"contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"},{"id":1414,"project_id":4135,"contact_id":5876,"point":"5000.00","paid_point":null,"contact":{"id":5876,"key":5876,"name":"\u51af\u5b66\u9e4f","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":90,"progress_remain_display":90,"forecast_remain_display":90,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":288000,"is_exceeded":true,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u660e\u786e\u9700\u6c42","is_collected":false,"bgcolor":"#0064ec","can_invoice":false,"can_payment":false,"duration_display":90,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"28.8\u4e07","contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":15000,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1},{"id":3954,"client_id":93,"project_status":4,"project_progress":4,"budget":"130000","profit_pct":"11.53","bargain_date":"2025-12-31","description":null,"created_by":1005,"created_at":"2025-08-25 09:17:17","updated_at":"2026-04-22 15:46:14","engineer_id":null,"project_title":"\u7fa4\u6656\u6269\u5bb9","collected":"0","status_updated_at":"2026-02-26 10:12:29.208254+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-25 09:17:42.234121+08","forecast_updated_at":"2026-02-26 10:12:29.208254+08","end_at":"2026-02-26 10:12:29","pinyin_shortcut":"qhkr","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":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"14989.000000000000000000","remain":"101 days 00:57:48.005071","progress_remain":"286 days 01:52:34.979204","forecast_remain":"101 days 00:57:48.005071","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"185 days 00:55:11.927378","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"130000","pct":"11.53","profit":"15000.65","project_id":3954}],"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":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":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":3954,"points":"31"},"workLogCount":null,"caseCount":{"project_id":3954,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3954,"sum":"3.86666666666667","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3954,"sum":"195.90"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3954,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":183,"project_id":3954,"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":101,"progress_remain_display":286,"forecast_remain_display":101,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":130000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":185,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"13\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},{"id":3461,"client_id":93,"project_status":4,"project_progress":6,"budget":"1000000","profit_pct":"20","bargain_date":"2025-08-31","description":null,"created_by":1005,"created_at":"2024-03-04 09:39:05","updated_at":"2025-12-30 16:18:51","engineer_id":null,"project_title":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee","collected":"0","status_updated_at":"2025-08-25 11:38:20.607799+08","success_rate":null,"comment":"NETAPP FAS2800*2","contract_type":1,"progress_updated_at":"2025-07-07 10:32:04.714509+08","forecast_updated_at":"2025-08-25 11:38:20.607799+08","end_at":"2025-08-25 11:38:20","pinyin_shortcut":"sjbffahsyshyxm","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":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"200000.0000000000000000","remain":"285 days 23:31:56.605526","progress_remain":"335 days 00:38:12.498816","forecast_remain":"285 days 23:31:56.605526","lost_contact_days":"633.79881033941","last_contact":"2024-09-11 16:00:00","last_arrive_days":null,"last_arrive":null,"duration":"539 days 01:59:15.022348","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3461,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1000000.00","pct":"20","profit":"200000","project_id":3461}],"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":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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":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":3461,"points":"125"},"workLogCount":{"project_id":3461,"count":3},"caseCount":{"project_id":3461,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":3461,"sum":"10.6605555555556","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3461,"sum":"500.36"},"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3461,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":145,"project_id":3461,"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":285,"progress_remain_display":335,"forecast_remain_display":285,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":1000000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":539,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"100\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},{"id":3488,"client_id":93,"project_status":3,"project_progress":6,"budget":"545000","profit_pct":"15.95","bargain_date":"2025-07-31","description":"","created_by":1005,"created_at":"2024-03-31 22:49:26","updated_at":"2026-01-15 15:05:15","engineer_id":null,"project_title":"\u591a\u56e0\u7d20\u8ba4\u8bc1-\u5b81\u76fe5000\u70b9","collected":"545000","status_updated_at":"2025-07-31 11:45:20.419173+08","success_rate":null,"comment":"\u89e3\u51b3\u7684\u95ee\u9898\uff1a\u5e10\u53f7\u88ab\u52ab\u6301\uff0c\u5185\u90e8\u5458\u5de5\u88ab\u9a97\u94b1","contract_type":1,"progress_updated_at":"2024-08-26 07:49:48.430459+08","forecast_updated_at":"2024-08-26 07:49:48.430459+08","end_at":"2026-01-14 09:38:52","pinyin_shortcut":"dysrznd5000d","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"70000","paid_contact_point":"70000","project_product_version_id":1069,"is_sales_order_ready":true,"collected_plan":545000,"change_status_to":null,"is_verify":false,"profits":"86927.500000000000000000","remain":"310 days 23:24:56.794152","progress_remain":"650 days 03:20:28.782866","forecast_remain":"650 days 03:20:28.782866","lost_contact_days":"449.847421450521","last_contact":"2025-03-14 14:50:00","last_arrive_days":"647.916865894965","last_arrive":"2024-08-28 13:10:00+08","duration":"653 days 10:49:25.804122","issued_invoices":"545000.00","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"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":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"90000","pct":"15.95","profit":"14355","project_id":3488},{"id":7,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"455000","pct":"15.95","profit":"72572.5","project_id":3488}],"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":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":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":null,"workLogCount":{"project_id":3488,"count":2},"caseCount":null,"salesTimeCount":{"project_id":3488,"hours":"0","times":1},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4074,"from_project":3488,"payment_collection_remind_ahead":"1 day","serial_no":"C202507230036","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"545000","erp_un_settle_amount":"0","including_tax":true,"amount":"545000","contractScans":[{"id":55304,"object_type":105,"object_id":4074,"attachment_id":27622,"attachment":{"id":27622,"key":27622,"name":"715e29f5-527f-3158-88c5-219d554ccfc3","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/715e29f5-527f-3158-88c5-219d554ccfc3\/2025_07_31_12_03_07.pdf","orig_name":"2025_07_31_12_03_07.pdf"}}],"receiptScans":[],"verifyScans":[{"id":52821,"object_type":107,"object_id":4074,"attachment_id":29909,"attachment":{"id":29909,"key":29909,"name":"d834d250-b54e-3357-af83-884b4857b551","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/d834d250-b54e-3357-af83-884b4857b551\/2025_11_21_13_20_49.pdf","orig_name":"2025_11_21_13_20_49.pdf"}}],"erpCollectTickets":[],"salesContractPayments":[{"id":"12104","key":"12104","contract_id":4074,"value":"545000","created_by":1013,"collected_date":"2025-12-08 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2200,"key":2200,"contract_id":4074,"value":"545000.00","attachment_id":null,"from_date":"2025-11-18","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2538,"key":2538,"contract_id":4074,"name":"2025-11-30","value":"545000","overdue_days":8,"status":1,"remind_date":"2025-11-30","pct":100,"overdue_display":"\u903e\u671f8\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":9752,"user_id":1005,"key":1005,"contract_id":4074,"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"}}}],"salesSupplierRels":[{"id":3881,"contract_id":4074,"supplier_id":729,"purchase_id":4137,"supplier":{"id":729,"key":729,"name":"\u5317\u4eac\u7f8e\u7f51\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4137,"key":4137,"serial_no":"TSKJ20250903-HYF-01"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":545000},"projectRemindReceivers":[],"projectProductRels":[{"id":11015,"project_id":3488,"product_id":2127,"amount":"90000","number":1,"cost":"24000","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"90000","total_cost":"24000","erp_sales_order_product_id":1875,"supplier":null,"product":{"id":2127,"name":"\u5b81\u76fe\u6280\u672f\u652f\u6301\u670d\u52a1","product_type":22,"product_component":189,"product_brand":137,"product_serie":1702,"product_misc":null,"product_qa":null,"pn":"","description":"\u514d\u8d39\u63d0\u4f9b\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u53ca\u63d0\u4f9b\u65e5\u5e38\u5de1\u68c0\u30015*8\u7684\u6280\u672f\u4fdd\u969c\uff0c\u5e38\u89c4\u4e8b\u4ef6\u54cd\u5e94\u65f6\u95f4\uff081\u5c0f\u65f6\u7684\u7535\u8bdd\u54cd\u5e94\uff0c2\u5c0f\u65f6\u5185\u627e\u51fa\u89e3\u51b3\u65b9\u6848\uff09\u3001\u7d27\u6025\u6545\u969c\u5e743\u6b21\u73b0\u573a\u670d\u52a1\u3002","created_by":1013,"created_at":"2025-09-03 11:04:41","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"ndjszcfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1702,"key":1702,"name":"\u539f\u5382\u4e09\u5e74\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1875,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":2127,"description":"","number":"1","outbound":"1","amount":"90000","total_amount":"90000","last_number":"1","last_amount":"90000","last_total_amount":"90000","cost":"24000","total_cost":"24000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11016,"project_id":3488,"product_id":952,"amount":"59","number":5000,"cost":"40","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"295000","total_cost":"200000","erp_sales_order_product_id":1876,"supplier":null,"product":{"id":952,"name":"\u52a8\u6001\u4ee4\u724c","product_type":7,"product_component":153,"product_brand":137,"product_serie":598,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 16:34:36","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"dtlp","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":598,"key":598,"name":"\u52a8\u6001\u4ee4\u724c"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1876,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":952,"description":"","number":"5000","outbound":"5000","amount":"59","total_amount":"295000","last_number":"5000","last_amount":"59","last_total_amount":"295000","cost":"40","total_cost":"200000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11017,"project_id":3488,"product_id":942,"amount":"0","number":3,"cost":"3000","description":"\u5b89\u88c5\u670d\u52a1","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"0","total_cost":"9000","erp_sales_order_product_id":1874,"supplier":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1874,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":942,"description":"\u5b89\u88c5\u670d\u52a1","number":"3","outbound":"3","amount":"0","total_amount":"0","last_number":"3","last_amount":"0","last_total_amount":"0","cost":"3000","total_cost":"9000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}},{"id":11018,"project_id":3488,"product_id":2126,"amount":"160000","number":1,"cost":"107000","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null,"total_amount":"160000","total_cost":"107000","erp_sales_order_product_id":1877,"supplier":null,"product":{"id":2126,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u8f6f\u4ef6\uff0dPro","product_type":7,"product_component":153,"product_brand":137,"product_serie":1701,"product_misc":null,"product_qa":null,"pn":"","description":"\u4e13\u4e1a\u7248\u5e73\u53f0\uff0c\u4e0d\u9650\u5236\u5e94\u7528\u6570\u4ee5\u53ca\u7528\u6237\u6570\u63a5\u5165\uff0cExchange\/Citrix\/SSL VPN\/VMWare View\/Web\/\u5821\u5792\u673a\/\u670d\u52a1\u5668\u7b49\u5728\u5e10\u53f7\u5bc6\u7801\u8ba4\u8bc1\u57fa\u7840\u4e0a\u589e\u52a0\u52a8\u6001\u5bc6\u7801\u4fdd\u62a4\u3002\u63d0\u4f9b\u6807\u51c6\u5f97API\u63a5\u53e3\uff1b","created_by":1013,"created_at":"2025-09-03 11:03:06","updated_at":"2025-11-10 11:30:48","pinyin_shortcut":"syzrzrjPro","product_unit":2,"is_renew":false,"in_out_at":"2025-11-10 11:30:48.584708+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":153,"key":153,"name":"\u8ba4\u8bc1\u5e73\u53f0"},"productBrand":{"id":137,"key":137,"name":"\u5b81\u76fe"},"productSerie":{"id":1701,"key":1701,"name":"\u53cc\u56e0\u5b50\u8ba4\u8bc1\u5e73\u53f0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1877,"erp_sales_order_id":1560,"erp_store_id":null,"product_id":2126,"description":"","number":"1","outbound":"1","amount":"160000","total_amount":"160000","last_number":"1","last_amount":"160000","last_total_amount":"160000","cost":"107000","total_cost":"107000","supplier_id":null,"hardware_from":null,"software_from":"2025-09-04","maintenance_from":null,"hardware_to":null,"software_to":"2028-09-03","maintenance_to":null}}],"commentCount":{"object_id":3488,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1348,"project_id":3488,"contact_id":4701,"point":"50000.00","paid_point":"50000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":236,"project_id":3488,"contact_id":4701,"point":"50000.00","day_at":"2025-12-15","description":"","created_at":"2025-12-15 09:17:12"}],"status_display":"\u5df2\u6838\u9500"},{"id":1349,"project_id":3488,"contact_id":5876,"point":"20000.00","paid_point":"20000","contact":{"id":5876,"key":5876,"name":"\u51af\u5b66\u9e4f","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":237,"project_id":3488,"contact_id":5876,"point":"20000.00","day_at":"2025-12-15","description":"","created_at":"2025-12-15 09:17:12"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1560,"serial_no":"XSDD-20250731-00002","from_date":null,"wrote_date":"2025-07-31","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3488,"sales_contract_id":4074,"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":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"5005","amount":"545000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-07-31 11:45:20","updated_at":"2025-07-31 11:45:20","print_times":null},"projectUsedClient":{"id":102,"project_id":3488,"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":310,"progress_remain_display":650,"forecast_remain_display":650,"projectProductTotalAmount":545000,"projectProductAllAmount":true,"projectProductTotalCost":340000,"projectProductAllCost":true,"projectProductTotalNumber":5005,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":653,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"54.5\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":70000,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3702,"client_id":93,"project_status":4,"project_progress":4,"budget":"700000","profit_pct":"15","bargain_date":"2025-05-01","description":null,"created_by":1005,"created_at":"2024-10-27 21:13:01","updated_at":"2026-03-23 09:37:56","engineer_id":null,"project_title":"\u7b2c\u4e8c\u56ed\u533a\u5185\u7f51\u9632\u706b\u5899-PA","collected":"0","status_updated_at":"2025-03-10 11:56:25.978057+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-27 21:47:41.442924+08","forecast_updated_at":"2025-02-17 10:53:22.589222+08","end_at":"2025-03-10 11:56:25","pinyin_shortcut":"deyqnwfhqPA","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":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"105000.0000000000000000","remain":"453 days 23:13:51.235268","progress_remain":"587 days 13:22:35.770401","forecast_remain":"475 days 00:16:54.624103","lost_contact_days":"556.754365894965","last_contact":"2024-11-27 17:04:00","last_arrive_days":"556.754365894965","last_arrive":"2024-11-27 17:04:00+08","duration":"133 days 14:43:24.172899","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"700000.00","pct":"15","profit":"105000","project_id":3702}],"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":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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":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":3702,"points":"442"},"workLogCount":{"project_id":3702,"count":1},"caseCount":{"project_id":3702,"count":8},"salesTimeCount":{"project_id":3702,"hours":"2.55","times":1},"implementTimeCount":{"project_id":3702,"sum":"18.8333333333333","times":"8"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3702,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":453,"progress_remain_display":587,"forecast_remain_display":475,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":700000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":133,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"70\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},{"id":3699,"client_id":93,"project_status":3,"project_progress":9,"budget":"458000","profit_pct":"11.13","bargain_date":"2024-11-29","description":"","created_by":1005,"created_at":"2024-10-25 10:19:06","updated_at":"2025-04-27 14:43:37","engineer_id":null,"project_title":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","collected":"458000","status_updated_at":"2024-12-12 13:39:18.105504+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-12 13:39:18.105504+08","forecast_updated_at":"2024-11-17 20:53:26.212332+08","end_at":"2025-05-16 16:54:30","pinyin_shortcut":"deyqxgckfhqft","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":802,"is_sales_order_ready":true,"collected_plan":458000,"change_status_to":null,"is_verify":false,"profits":"50975.400000000000000000","remain":"541 days 21:30:59.107821","progress_remain":"541 days 21:30:59.107821","forecast_remain":"566 days 14:16:51.000993","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"203 days 06:35:24.348091","issued_invoices":"458000.00","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"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":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"458000.00","pct":"11.13","profit":"50975.4","project_id":3699}],"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":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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":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":3699,"points":"31"},"workLogCount":null,"caseCount":{"project_id":3699,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3699,"sum":"2.26666666666667","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3699,"sum":"137"},"buildContract":{"id":3705,"from_project":3699,"payment_collection_remind_ahead":"7 days","serial_no":"C202411290020","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"458000","erp_un_settle_amount":"0","including_tax":true,"amount":"458000","contractScans":[{"id":31512,"object_type":105,"object_id":3705,"attachment_id":23140,"attachment":{"id":23140,"key":23140,"name":"221be467-2e34-378b-a893-1dc8bbcc49c3","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/221be467-2e34-378b-a893-1dc8bbcc49c3\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":33825,"object_type":106,"object_id":3705,"attachment_id":23652,"attachment":{"id":23652,"key":23652,"name":"a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/a0dbfb7d-deaa-30cb-ac43-f293a9cd8d43\/\u9632\u706b\u5899.pdf","orig_name":"\u9632\u706b\u5899.pdf"}}],"verifyScans":[{"id":33826,"object_type":107,"object_id":3705,"attachment_id":25332,"attachment":{"id":25332,"key":25332,"name":"bac7e3d9-59f3-325b-bf16-1e79aab93f2c","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/bac7e3d9-59f3-325b-bf16-1e79aab93f2c\/\u98de\u5854\u9632\u706b\u5899\u9a8c\u8bc1\u62a5\u544a.pdf","orig_name":"\u98de\u5854\u9632\u706b\u5899\u9a8c\u8bc1\u62a5\u544a.pdf"}}],"erpCollectTickets":[{"id":328,"serial_no":"SKD-20250516-00005","wrote_date":"2025-05-16","from_date":null,"handler":1005,"user_id":null,"client_id":93,"sales_contract_id":3705,"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-05-16 16:54:30","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"458000","settle_amount":"458000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-05-16 16:54:30","updated_at":"2025-05-16 16:54:30","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1328","key":"1328","contract_id":3705,"value":"458000","created_by":1013,"collected_date":"2025-05-16 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2018,"key":2018,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-27","attachment":null},{"id":2024,"key":2024,"contract_id":3705,"value":"-458000.00","attachment_id":null,"from_date":"2025-04-29","attachment":null},{"id":2025,"key":2025,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-28","attachment":null},{"id":2028,"key":2028,"contract_id":3705,"value":"-458000.00","attachment_id":null,"from_date":"2025-04-30","attachment":null},{"id":2029,"key":2029,"contract_id":3705,"value":"458000.00","attachment_id":null,"from_date":"2025-04-30","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2254,"key":2254,"contract_id":3705,"name":"2025-02-28","value":"458000","overdue_days":77,"status":1,"remind_date":"2025-02-28","pct":100,"overdue_display":"\u903e\u671f77\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7638,"user_id":1005,"key":1005,"contract_id":3705,"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"}}},{"id":7640,"user_id":1001,"key":1001,"contract_id":3705,"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":2529,"contract_id":3705,"supplier_id":534,"purchase_id":3817,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3817,"key":3817,"serial_no":"2025022801-TSZHY5"}},{"id":2300,"contract_id":3705,"supplier_id":614,"purchase_id":3723,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3723,"key":3723,"serial_no":"BQ-S-2024-12-07-P"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":458000},"projectRemindReceivers":[],"projectProductRels":[{"id":8952,"project_id":3699,"product_id":1625,"amount":"72983.00","number":2,"cost":"62866.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"145966","total_cost":"125732","erp_sales_order_product_id":1434,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1434,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":1625,"description":"","number":"2","outbound":"0","amount":"72983.00","total_amount":"145966","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"62866.00","total_cost":"125732","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8953,"project_id":3699,"product_id":1626,"amount":"153265.00","number":2,"cost":"131830.00","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"306530","total_cost":"263660","erp_sales_order_product_id":1435,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1435,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":1626,"description":"","number":"2","outbound":"0","amount":"153265.00","total_amount":"306530","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131830.00","total_cost":"263660","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":8954,"project_id":3699,"product_id":941,"amount":"5504.00","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":"5504","total_cost":"0","erp_sales_order_product_id":1436,"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":1436,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"5504.00","total_amount":"5504","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}},{"id":8955,"project_id":3699,"product_id":942,"amount":"0","number":1,"cost":"31000.00","description":"","supplier_id":534,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"31000","erp_sales_order_product_id":1437,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2026-01-28 10:32:39","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-01-28 10:32:39.333577+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":1437,"erp_sales_order_id":1407,"erp_store_id":null,"product_id":942,"description":"","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"31000.00","total_cost":"31000","supplier_id":534,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3699,"comment":7},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1407,"serial_no":"XSDD-20241212-00001","from_date":null,"wrote_date":"2024-11-29","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3699,"sales_contract_id":3705,"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-05-16 16:54:30","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"458000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-12-12 13:39:18","updated_at":"2025-05-16 16:54:30","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":541,"progress_remain_display":541,"forecast_remain_display":566,"projectProductTotalAmount":458000,"projectProductAllAmount":true,"projectProductTotalCost":420392,"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":203,"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":"45.8\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},{"id":3700,"client_id":93,"project_status":3,"project_progress":9,"budget":"550000","profit_pct":"5.21","bargain_date":"2024-11-21","description":"","created_by":1005,"created_at":"2024-10-25 10:26:45","updated_at":"2025-10-31 10:07:40","engineer_id":null,"project_title":"ADME \u5b9e\u9a8c\u5ba4\u5907\u4efd\u66ff\u6362","collected":"550000","status_updated_at":"2024-11-29 11:35:53.22883+08","success_rate":null,"comment":"\u7fa4\u6656 HD6500 2 \u53f0","contract_type":1,"progress_updated_at":"2024-11-29 11:35:53.22883+08","forecast_updated_at":"2024-10-25 10:26:45.687876+08","end_at":"2025-04-17 17:16:20","pinyin_shortcut":"ADMEsysbfth","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"100000","paid_contact_point":"100000","project_product_version_id":723,"is_sales_order_ready":true,"collected_plan":550000,"change_status_to":null,"is_verify":false,"profits":"28655.000000000000000000","remain":"554 days 23:34:23.984495","progress_remain":"554 days 23:34:23.984495","forecast_remain":"590 days 00:43:31.525449","lost_contact_days":"561.833532561632","last_contact":"2024-11-22 15:10:00","last_arrive_days":null,"last_arrive":null,"duration":"174 days 06:49:34.907611","issued_invoices":"550000.00","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"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":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"550000.00","pct":"5.21","profit":"28655","project_id":3700}],"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":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"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":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":3700,"points":"1276"},"workLogCount":{"project_id":3700,"count":1},"caseCount":{"project_id":3700,"count":21},"salesTimeCount":null,"implementTimeCount":{"project_id":3700,"sum":"103.55","times":"21"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3700,"sum":"3065.63"},"buildContract":{"id":3679,"from_project":3700,"payment_collection_remind_ahead":"7 days","serial_no":"TS-ZHY-2024112101","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"550000","erp_un_settle_amount":"0","including_tax":true,"amount":"550000","contractScans":[{"id":33719,"object_type":105,"object_id":3679,"attachment_id":22964,"attachment":{"id":22964,"key":22964,"name":"779fa961-1727-3dd3-a93f-3e0fdd79d44a","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/779fa961-1727-3dd3-a93f-3e0fdd79d44a\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":31724,"object_type":106,"object_id":3679,"attachment_id":23653,"attachment":{"id":23653,"key":23653,"name":"5db488b9-8429-3f03-9446-f1ea5a5dcf03","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/5db488b9-8429-3f03-9446-f1ea5a5dcf03\/\u7fa4\u6656.pdf","orig_name":"\u7fa4\u6656.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":293,"serial_no":"SKD-20250417-00003","wrote_date":"2025-04-17","from_date":null,"handler":1005,"user_id":null,"client_id":93,"sales_contract_id":3679,"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-04-17 17:16:20","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"550000","settle_amount":"550000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-04-17 17:16:20","updated_at":"2025-04-17 17:16:20","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1293","key":"1293","contract_id":3679,"value":"550000","created_by":1013,"collected_date":"2025-04-17 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1931,"key":1931,"contract_id":3679,"value":"550000.00","attachment_id":null,"from_date":"2025-01-09","attachment":null},{"id":2010,"key":2010,"contract_id":3679,"value":"-550000.00","attachment_id":null,"from_date":"2025-04-10","attachment":null},{"id":2011,"key":2011,"contract_id":3679,"value":"550000.00","attachment_id":null,"from_date":"2025-04-10","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2252,"key":2252,"contract_id":3679,"name":"2025-01-31","value":"550000","overdue_days":76,"status":1,"remind_date":"2025-01-31","pct":100,"overdue_display":"\u903e\u671f76\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":8255,"user_id":1005,"key":1005,"contract_id":3679,"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"}}},{"id":8257,"user_id":1001,"key":1001,"contract_id":3679,"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":2604,"contract_id":3679,"supplier_id":68,"purchase_id":3687,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":3687,"key":3687,"serial_no":"BJ7067IM202401203-01"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":550000},"projectRemindReceivers":[],"projectProductRels":[{"id":9250,"project_id":3700,"product_id":899,"amount":"170000.00","number":2,"cost":"131500.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"340000","total_cost":"263000","erp_sales_order_product_id":1395,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":899,"name":"HD6500","product_type":3,"product_component":14,"product_brand":27,"product_serie":563,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-08 14:51:14","updated_at":"2024-01-16 11:50:50","pinyin_shortcut":"HD6500","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":563,"key":563,"name":"HD6500 NAS\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":1395,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":899,"description":"","number":"2","outbound":"0","amount":"170000.00","total_amount":"340000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131500.00","total_cost":"263000","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9251,"project_id":3700,"product_id":900,"amount":"4800.00","number":26,"cost":"3710.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"124800","total_cost":"96460","erp_sales_order_product_id":1396,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":900,"name":"HAS5300-16T","product_type":3,"product_component":15,"product_brand":27,"product_serie":564,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-08 14:56:07","updated_at":"2024-01-16 13:48:58","pinyin_shortcut":"HAS530016T","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":564,"key":564,"name":"16TB 7.2K 3.5 SAS\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":1396,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":900,"description":"","number":"26","outbound":"0","amount":"4800.00","total_amount":"124800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3710.00","total_cost":"96460","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9252,"project_id":3700,"product_id":1886,"amount":"5650.00","number":2,"cost":"5305.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"11300","total_cost":"10610","erp_sales_order_product_id":1397,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1886,"name":"D4ER01-32G","product_type":3,"product_component":39,"product_brand":27,"product_serie":1577,"product_misc":null,"product_qa":null,"pn":"","description":"\u7fa4\u665632GB\u5185\u5b58","created_by":1013,"created_at":"2024-12-03 15:31:33","updated_at":"2024-12-03 15:31:33","pinyin_shortcut":"D4ER0132G","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1577,"key":1577,"name":"\u5b58\u50a8\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1397,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1886,"description":"","number":"2","outbound":"0","amount":"5650.00","total_amount":"11300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5305.00","total_cost":"10610","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9253,"project_id":3700,"product_id":220,"amount":"200.00","number":4,"cost":"70.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"800","total_cost":"280","erp_sales_order_product_id":1398,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":220,"name":"46C3447","product_type":4,"product_component":43,"product_brand":4,"product_serie":1127,"product_misc":8,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-06-16 09:28:20","updated_at":"2024-02-01 11:07:29","pinyin_shortcut":"46C3447","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1127,"key":1127,"name":"\u8054\u60f346C3447\u4e07\u5146\u591a\u6a21SFP+\u5149\u7ea4\u6a21\u5757"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1398,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":220,"description":"","number":"4","outbound":"0","amount":"200.00","total_amount":"800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"70.00","total_cost":"280","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9254,"project_id":3700,"product_id":941,"amount":"9020.00","number":1,"cost":"0","description":"","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27","total_amount":"9020","total_cost":"0","erp_sales_order_product_id":1399,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"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":1399,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"9020.00","total_amount":"9020","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27"}},{"id":9255,"project_id":3700,"product_id":941,"amount":"9000.00","number":5,"cost":"0","description":"","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27","total_amount":"45000","total_cost":"0","erp_sales_order_product_id":1400,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"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":1400,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":941,"description":"","number":"5","outbound":"0","amount":"9000.00","total_amount":"45000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":68,"hardware_from":null,"software_from":null,"maintenance_from":"2024-12-27","hardware_to":null,"software_to":null,"maintenance_to":"2029-12-27"}},{"id":9256,"project_id":3700,"product_id":1906,"amount":"945.00","number":4,"cost":"885.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"3780","total_cost":"3540","erp_sales_order_product_id":1401,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1906,"name":"E10G18-T1","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":null,"product_qa":null,"pn":"","description":"\u5355\u7aef\u53e310G\u7535\u53e3\u7f51\u5361","created_by":1013,"created_at":"2024-12-24 15:38:55","updated_at":"2024-12-24 15:38:55","pinyin_shortcut":"E10G18T1","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1401,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1906,"description":"","number":"4","outbound":"0","amount":"945.00","total_amount":"3780","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"885.00","total_cost":"3540","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9257,"project_id":3700,"product_id":1907,"amount":"2000.00","number":2,"cost":"1655.00","description":"","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"4000","total_cost":"3310","erp_sales_order_product_id":1402,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"product":{"id":1907,"name":"E10G30-F2","product_type":3,"product_component":39,"product_brand":27,"product_serie":1578,"product_misc":null,"product_qa":null,"pn":"","description":"\u53cc\u7aef\u53e310G SFP+\u7f51\u5361","created_by":1013,"created_at":"2024-12-24 15:39:26","updated_at":"2024-12-24 15:39:26","pinyin_shortcut":"E10G30F2","product_unit":3,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1578,"key":1578,"name":"\u5b58\u50a8\u9002\u914d\u5361"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":1402,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1907,"description":"","number":"2","outbound":"0","amount":"2000.00","total_amount":"4000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1655.00","total_cost":"3310","supplier_id":68,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}},{"id":9258,"project_id":3700,"product_id":1886,"amount":"5650.00","number":2,"cost":"0","description":"\u5e93\u5b58\u4ea7\u54c1","supplier_id":null,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null,"total_amount":"11300","total_cost":"0","erp_sales_order_product_id":1403,"supplier":null,"product":{"id":1886,"name":"D4ER01-32G","product_type":3,"product_component":39,"product_brand":27,"product_serie":1577,"product_misc":null,"product_qa":null,"pn":"","description":"\u7fa4\u665632GB\u5185\u5b58","created_by":1013,"created_at":"2024-12-03 15:31:33","updated_at":"2024-12-03 15:31:33","pinyin_shortcut":"D4ER0132G","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":39,"key":39,"name":"\u5b58\u50a8\u914d\u4ef6"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1577,"key":1577,"name":"\u5b58\u50a8\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":1403,"erp_sales_order_id":1394,"erp_store_id":null,"product_id":1886,"description":"\u5e93\u5b58\u4ea7\u54c1","number":"2","outbound":"0","amount":"5650.00","total_amount":"11300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":"2024-12-27","software_from":null,"maintenance_from":null,"hardware_to":"2029-12-27","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3700,"comment":7},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":957,"project_id":3700,"contact_id":4701,"point":"100000.00","paid_point":"100000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":189,"project_id":3700,"contact_id":4701,"point":"100000.00","day_at":"2025-04-22","description":"\u73b0\u91d1\u4ea4\u4e8e\u8d75\u6657\u7131\u672c\u4eba","created_at":"2025-04-22 10:01:24"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1394,"serial_no":"XSDD-20241129-00002","from_date":null,"wrote_date":"2024-11-21","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3700,"sales_contract_id":3679,"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-04-17 17:16:20","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"48","amount":"550000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-11-29 11:35:53","updated_at":"2025-04-17 17:16:20","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":554,"progress_remain_display":554,"forecast_remain_display":590,"projectProductTotalAmount":550000,"projectProductAllAmount":true,"projectProductTotalCost":377200,"projectProductAllCost":true,"projectProductTotalNumber":48,"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":174,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"55\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":100000,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3451,"client_id":93,"project_status":4,"project_progress":2,"budget":"500000","profit_pct":"20","bargain_date":"2024-09-30","description":null,"created_by":1005,"created_at":"2024-02-22 10:34:52","updated_at":"2024-03-04 18:58:19","engineer_id":null,"project_title":"\u7ec8\u7aef\u5b89\u5168+\u6001\u52bf\u611f\u77e5\u9879\u76ee","collected":"0","status_updated_at":"2024-03-04 18:58:19.740204+08","success_rate":null,"comment":"\u9879\u76ee\u9884\u7b97\u5df2\u7ecf\u6279\u5b8c\uff0c\u4eca\u5e74\u8981\u505a\n\u76ee\u524d\u6d4b\u8bd5\u4e86\u6df1\u4fe1\u670d\uff0c\u5fae\u8f6f\uff0c\u4e9a\u4fe1\u7684\n\u4e9a\u4fe1\u4e0d\u597d\u7528\uff0c\u5fae\u8f6f\u592a\u8d35\uff0c\u6df1\u4fe1\u670d\u8fd8\u53ef\u4ee5\n","contract_type":1,"progress_updated_at":"2024-03-04 18:39:39.864866+08","forecast_updated_at":"2024-03-04 18:58:19.740204+08","end_at":"2024-03-04 18:58:19","pinyin_shortcut":"zdaqtsgzxm","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":"100000.0000000000000000","remain":"824 days 16:11:57.473121","progress_remain":"824 days 16:30:37.348459","forecast_remain":"824 days 16:11:57.473121","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"11 days 08:23:27.256637","issued_invoices":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"500000.00","pct":"20","profit":"100000","project_id":3451}],"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":null,"purchaseType":{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},"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":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":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3451,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":824,"progress_remain_display":824,"forecast_remain_display":824,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":500000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":11,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"50\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},{"id":3417,"client_id":93,"project_status":3,"project_progress":9,"budget":"2630000","profit_pct":"14.16","bargain_date":"2024-05-14","description":"","created_by":1005,"created_at":"2024-01-08 13:13:08","updated_at":"2026-01-15 14:54:22","engineer_id":null,"project_title":"\u8fb9\u754c\u9632\u706b\u5899\u66ff\u6362","collected":"2630000","status_updated_at":"2024-05-31 11:50:54.692691+08","success_rate":null,"comment":"\u98de\u5854\u9632\u706b\u5899\uff0c\u6df1\u4fe1\u670d\u9632\u706b\u5899","contract_type":1,"progress_updated_at":"2024-05-20 12:21:40.939154+08","forecast_updated_at":"2024-07-28 23:11:21.672993+08","end_at":"2025-01-07 16:51:14","pinyin_shortcut":"bjfhqth","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":"100000","paid_contact_point":"100000","project_product_version_id":467,"is_sales_order_ready":true,"collected_plan":2630000,"change_status_to":null,"is_verify":false,"profits":"372408.00000000000000","remain":"736 days 23:19:22.520634","progress_remain":"747 days 22:48:36.274171","forecast_remain":"678 days 11:58:55.540332","lost_contact_days":"647.814088117188","last_contact":"2024-08-28 15:38:00","last_arrive_days":"647.814088117188","last_arrive":"2024-08-28 15:38:00+08","duration":"365 days 03:38:05.373405","issued_invoices":"2630000.00","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5,"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":3,"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3417,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"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":"2630000","pct":"14.16","profit":"372408","project_id":3417}],"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":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},"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":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":3417,"points":"3258"},"workLogCount":{"project_id":3417,"count":6},"caseCount":{"project_id":3417,"count":66},"salesTimeCount":{"project_id":3417,"hours":"4.28333333333333","times":5},"implementTimeCount":{"project_id":3417,"sum":"307.486944444444","times":"63"},"presalesTimeCount":{"project_id":3417,"sum":"3.1475","times":"3"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3417,"sum":"5136.36"},"buildContract":{"id":3325,"from_project":3417,"payment_collection_remind_ahead":"7 days","serial_no":"C202405150012","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"2630000","erp_un_settle_amount":"0","including_tax":true,"amount":"2630000","contractScans":[{"id":29032,"object_type":105,"object_id":3325,"attachment_id":19507,"attachment":{"id":19507,"key":19507,"name":"934c58d9-6044-3a30-89c2-e1c23dda3e85","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/934c58d9-6044-3a30-89c2-e1c23dda3e85\/\u5eb7\u9f99\u5316\u6210.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210.pdf"}}],"receiptScans":[{"id":26772,"object_type":106,"object_id":3325,"attachment_id":19978,"attachment":{"id":19978,"key":19978,"name":"ccb8cd70-d3a1-31c9-9063-043c6e49fd24","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/ccb8cd70-d3a1-31c9-9063-043c6e49fd24\/\u5317\u4eac\u62d3\u5b9e\u8d27\u7269\u7b7e\u6536\u5355.pdf","orig_name":"\u5317\u4eac\u62d3\u5b9e\u8d27\u7269\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[{"id":26773,"object_type":107,"object_id":3325,"attachment_id":20020,"attachment":{"id":20020,"key":20020,"name":"06c9e3df-706a-3ed0-870c-49a8b359fe9f","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/06c9e3df-706a-3ed0-870c-49a8b359fe9f\/\u5eb7\u9f99\u5316\u6210-\u9a8c\u6536\u62a5\u544a2024.7.2.pdf","orig_name":"\u5eb7\u9f99\u5316\u6210-\u9a8c\u6536\u62a5\u544a2024.7.2.pdf"}}],"erpCollectTickets":[{"id":204,"serial_no":"SKD-20250107-00002","wrote_date":"2025-01-07","from_date":null,"handler":1005,"user_id":null,"client_id":93,"sales_contract_id":3325,"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-01-07 16:51:13","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"280000","settle_amount":"280000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-01-07 16:51:13","updated_at":"2025-01-07 16:51:13","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":108,"serial_no":"SKD-20240920-00001","wrote_date":"2024-09-20","from_date":null,"handler":1005,"user_id":null,"client_id":93,"sales_contract_id":3325,"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-20 17:44:35","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1410000","settle_amount":"1410000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-09-20 17:44:35","updated_at":"2024-09-20 17:44:35","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":41,"serial_no":"SKD-20240704-00001","wrote_date":"2024-07-04","from_date":null,"handler":1005,"user_id":null,"client_id":93,"sales_contract_id":3325,"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-07-04 17:12:46","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"940000","settle_amount":"940000","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-07-04 17:12:46","updated_at":"2024-07-04 17:12:46","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"141","key":"141","contract_id":3325,"value":"940000","created_by":1013,"collected_date":"2024-07-04 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":35.74},{"id":"1204","key":"1204","contract_id":3325,"value":"280000","created_by":1013,"collected_date":"2025-01-07 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":10.65},{"id":"1108","key":"1108","contract_id":3325,"value":"1410000","created_by":1013,"collected_date":"2024-09-20 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":53.61}],"salesContractInvoices":[{"id":1696,"key":1696,"contract_id":3325,"value":"2350000.00","attachment_id":null,"from_date":"2024-06-26","attachment":null},{"id":1910,"key":1910,"contract_id":3325,"value":"280000.00","attachment_id":null,"from_date":"2024-12-24","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1865,"key":1865,"contract_id":3325,"name":"2024-07-26","value":"940000","overdue_days":null,"status":1,"remind_date":"2024-07-26","pct":35.74,"overdue_display":""},{"id":1866,"key":1866,"contract_id":3325,"name":"2024-08-31","value":"1410000","overdue_days":20,"status":1,"remind_date":"2024-08-31","pct":53.61,"overdue_display":"\u903e\u671f20\u5929"},{"id":1867,"key":1867,"contract_id":3325,"name":"2024-10-31","value":"280000","overdue_days":68,"status":1,"remind_date":"2024-10-31","pct":10.65,"overdue_display":"\u903e\u671f68\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":6715,"user_id":1005,"key":1005,"contract_id":3325,"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"}}},{"id":6716,"user_id":1001,"key":1001,"contract_id":3325,"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":2118,"contract_id":3325,"supplier_id":614,"purchase_id":3340,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3340,"key":3340,"serial_no":"TSKJ20240531-HYF-004"}},{"id":1834,"contract_id":3325,"supplier_id":262,"purchase_id":3387,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":3387,"key":3387,"serial_no":" 294739496177"}},{"id":1835,"contract_id":3325,"supplier_id":534,"purchase_id":3461,"supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3461,"key":3461,"serial_no":"20240809-TSZHY5"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","invoiced":2630000},"projectRemindReceivers":[],"projectProductRels":[{"id":6556,"project_id":3417,"product_id":1625,"amount":"72983","number":4,"cost":"62866","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"291932","total_cost":"251464","erp_sales_order_product_id":909,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1625,"name":"FG-401F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1383,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 8 x 10GE SFP+ slots, SPU NP7 and CP9 hardware accelerated, 960GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:02:22","updated_at":"2024-05-31 16:02:22","pinyin_shortcut":"FG401F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1383,"key":1383,"name":"FG-401F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":909,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1625,"description":"","number":"4","outbound":"0","amount":"72983","total_amount":"291932","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"62866","total_cost":"251464","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6557,"project_id":3417,"product_id":1626,"amount":"153265","number":4,"cost":"131830","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"613060","total_cost":"527320","erp_sales_order_product_id":910,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1626,"name":"FC-10-0401F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1384,"product_misc":null,"product_qa":null,"pn":"","description":"FG-401F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:04:08","updated_at":"2024-05-31 16:04:08","pinyin_shortcut":"FC100401F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1384,"key":1384,"name":"FG-401F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":910,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1626,"description":"","number":"4","outbound":"0","amount":"153265","total_amount":"613060","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"131830","total_cost":"527320","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6558,"project_id":3417,"product_id":1627,"amount":"34288","number":1,"cost":"42091","description":"\u5408\u540c\u4f18\u60e030101","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"34288","total_cost":"42091","erp_sales_order_product_id":911,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1627,"name":"FG-400E","product_type":5,"product_component":26,"product_brand":40,"product_serie":1385,"product_misc":null,"product_qa":null,"pn":"","description":"18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 16 x GE SFP slots, SPU NP6 and CP9 hardware accelerated\n\u5e76\u53d1 SSL VPN \u7528\u6237\uff08\u5efa\u8bae\u7684\u6700\u5927\u6570\u91cf\uff0c\u96a7\u9053\u6a21\u5f0f\uff09\uff1a5000\u4eba","created_by":1013,"created_at":"2024-05-31 16:05:08","updated_at":"2024-05-31 16:05:08","pinyin_shortcut":"FG400E","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1385,"key":1385,"name":"FG-400E\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":911,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1627,"description":"\u5408\u540c\u4f18\u60e030101","number":"1","outbound":"0","amount":"34288","total_amount":"34288","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"42091","total_cost":"42091","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6559,"project_id":3417,"product_id":1628,"amount":"22472","number":1,"cost":"25254","description":"\u5408\u540c\u4f18\u60e030101","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"22472","total_cost":"25254","erp_sales_order_product_id":912,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1628,"name":"FC-10-0400E-247-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1386,"product_misc":null,"product_qa":null,"pn":"","description":"FortiCare Premium Support - 3Year","created_by":1013,"created_at":"2024-05-31 16:06:10","updated_at":"2024-05-31 16:06:10","pinyin_shortcut":"FC100400E2470236","product_unit":8,"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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1386,"key":1386,"name":"FG-400E\u4e09\u5e74\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":912,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1628,"description":"\u5408\u540c\u4f18\u60e030101","number":"1","outbound":"0","amount":"22472","total_amount":"22472","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"25254","total_cost":"25254","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6560,"project_id":3417,"product_id":1629,"amount":"31677","number":6,"cost":"27311","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"190062","total_cost":"163866","erp_sales_order_product_id":913,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1629,"name":"FG-201F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1387,"product_misc":null,"product_qa":null,"pn":"","description":"FG-201F 18 x GE RJ45 (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 4 x 10GE SFP+ slots, NP6XLite and CP9 hardware accelerated, 480GB onboard SSD storage","created_by":1013,"created_at":"2024-05-31 16:06:57","updated_at":"2024-05-31 16:06:57","pinyin_shortcut":"FG201F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1387,"key":1387,"name":"FG-201F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":913,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1629,"description":"","number":"6","outbound":"0","amount":"31677","total_amount":"190062","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"27311","total_cost":"163866","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6561,"project_id":3417,"product_id":1630,"amount":"66521","number":6,"cost":"57322","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"399126","total_cost":"343932","erp_sales_order_product_id":914,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1630,"name":"FC-10-F201F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1388,"product_misc":null,"product_qa":null,"pn":"","description":"FG-201F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:08:03","updated_at":"2024-05-31 16:08:03","pinyin_shortcut":"FC10F201F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1388,"key":1388,"name":"FG-201F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":914,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1630,"description":"","number":"6","outbound":"0","amount":"66521","total_amount":"399126","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"57322","total_cost":"343932","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6562,"project_id":3417,"product_id":1631,"amount":"16398","number":8,"cost":"14124","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"131184","total_cost":"112992","erp_sales_order_product_id":915,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1631,"name":"FG-121G","product_type":5,"product_component":26,"product_brand":40,"product_serie":1389,"product_misc":null,"product_qa":null,"pn":"","description":"FG-121G 18 x GE RJ45 ports (including 1 x MGMT port, 1 X HA port, 16 x switch ports), 8 x GE SFP slots, 4 x 10GE SFP+ slots, SP5 hardware accelerated, 480GB onboard SSD storage, dual AC power supplies","created_by":1013,"created_at":"2024-05-31 16:08:45","updated_at":"2024-05-31 16:08:45","pinyin_shortcut":"FG121G","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1389,"key":1389,"name":"FG-121G\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":915,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1631,"description":"","number":"8","outbound":"0","amount":"16398","total_amount":"131184","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"14124","total_cost":"112992","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6563,"project_id":3417,"product_id":1632,"amount":"34435","number":8,"cost":"29661","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"275480","total_cost":"237288","erp_sales_order_product_id":916,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1632,"name":"FC-10-F121G-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1390,"product_misc":null,"product_qa":null,"pn":"","description":"FG-121G Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium) -3Year","created_by":1013,"created_at":"2024-05-31 16:09:37","updated_at":"2024-05-31 16:09:37","pinyin_shortcut":"FC10F121G9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1390,"key":1390,"name":"FG-121G\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":916,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1632,"description":"","number":"8","outbound":"0","amount":"34435","total_amount":"275480","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"29661","total_cost":"237288","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6564,"project_id":3417,"product_id":1633,"amount":"9824","number":1,"cost":"8475","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"9824","total_cost":"8475","erp_sales_order_product_id":917,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1633,"name":"FG-81F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1391,"product_misc":null,"product_qa":null,"pn":"","description":"FG-81F 8 x GE RJ45 ports, 2 x RJ45\/SFP shared media WAN ports, 128GB SSD","created_by":1013,"created_at":"2024-05-31 16:10:29","updated_at":"2024-05-31 16:10:29","pinyin_shortcut":"FG81F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1391,"key":1391,"name":"FG-81F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":917,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1633,"description":"","number":"1","outbound":"0","amount":"9824","total_amount":"9824","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"8475","total_cost":"8475","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6565,"project_id":3417,"product_id":1634,"amount":"18569","number":1,"cost":"16008","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"18569","total_cost":"16008","erp_sales_order_product_id":918,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1634,"name":"FC-10-0081F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1392,"product_misc":null,"product_qa":null,"pn":"","description":"FG-81F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium)-3Year","created_by":1013,"created_at":"2024-05-31 16:11:05","updated_at":"2024-05-31 16:11:05","pinyin_shortcut":"FC100081F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1392,"key":1392,"name":"FG-81F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":918,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1634,"description":"","number":"1","outbound":"0","amount":"18569","total_amount":"18569","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"16008","total_cost":"16008","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6566,"project_id":3417,"product_id":1635,"amount":"4448","number":3,"cost":"3884","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"13344","total_cost":"11652","erp_sales_order_product_id":919,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1635,"name":"FG-61F","product_type":5,"product_component":26,"product_brand":40,"product_serie":1393,"product_misc":null,"product_qa":null,"pn":"","description":"FG-61F 10 x GE RJ45 ports (including 2 x WAN Ports, 1 x DMZ Port, 7 x Internal Ports), 128GB SSD onboard storage","created_by":1013,"created_at":"2024-05-31 16:11:43","updated_at":"2024-05-31 16:11:43","pinyin_shortcut":"FG61F","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1393,"key":1393,"name":"FG-61F\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":919,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1635,"description":"","number":"3","outbound":"0","amount":"4448","total_amount":"13344","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3884","total_cost":"11652","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6567,"project_id":3417,"product_id":1636,"amount":"8408","number":3,"cost":"7297","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"25224","total_cost":"21891","erp_sales_order_product_id":920,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1636,"name":"FC-10-0061F-950-02-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":1394,"product_misc":null,"product_qa":null,"pn":"","description":"FG-61F Unified Threat Protection (UTP) (IPS, Advanced Malware Protection, Application Control, URL, DNS & Video Filtering, Antispam Service, and FortiCare Premium)-3Year","created_by":1013,"created_at":"2024-05-31 16:12:19","updated_at":"2024-05-31 16:12:19","pinyin_shortcut":"FC100061F9500236","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":1394,"key":1394,"name":"FG-61F\u9632\u706b\u5899\u4e09\u5e74\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":920,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1636,"description":"","number":"3","outbound":"0","amount":"8408","total_amount":"25224","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"7297","total_cost":"21891","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6568,"project_id":3417,"product_id":1637,"amount":"6941","number":3,"cost":"5414","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"20823","total_cost":"16242","erp_sales_order_product_id":921,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1637,"name":"FC1-10-FMGVS-258-01-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":338,"product_misc":null,"product_qa":null,"pn":"","description":"FortiManager-VM Subscription License with Support 3 Year Subscription license for 10 devices\/vdoms managed by FortiManager VM S-series, including FortiCare Premium.","created_by":1013,"created_at":"2024-05-31 16:12:49","updated_at":"2024-05-31 16:12:49","pinyin_shortcut":"FC110FMGVS2580136","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":338,"key":338,"name":"\u98de\u5854\u865a\u62df\u673a\u7248\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":921,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1637,"description":"","number":"3","outbound":"0","amount":"6941","total_amount":"20823","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"5414","total_cost":"16242","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6569,"project_id":3417,"product_id":1638,"amount":"152306","number":2,"cost":"115346","description":"","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"304612","total_cost":"230692","erp_sales_order_product_id":922,"supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1638,"name":"FC2-10-AZVMS-465-01-36","product_type":5,"product_component":35,"product_brand":40,"product_serie":338,"product_misc":null,"product_qa":null,"pn":"","description":"Subscription license for 50 GB\/Day Central Logging & Analytics. Include FortiCare Premium support, IOC, Security Automation Service and FortiGuard Outbreak Detection Service.-3Year","created_by":1013,"created_at":"2024-05-31 16:13:12","updated_at":"2024-05-31 16:13:12","pinyin_shortcut":"FC210AZVMS4650136","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":40,"key":40,"name":"\u98de\u5854"},"productSerie":{"id":338,"key":338,"name":"\u98de\u5854\u865a\u62df\u673a\u7248\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":922,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1638,"description":"","number":"2","outbound":"0","amount":"152306","total_amount":"304612","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"115346","total_cost":"230692","supplier_id":614,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":6570,"project_id":3417,"product_id":941,"amount":"280000","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":"280000","total_cost":"0","erp_sales_order_product_id":923,"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":923,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"280000","total_amount":"280000","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}},{"id":6571,"project_id":3417,"product_id":1227,"amount":"0","number":1,"cost":"7909.16","description":"\u8d60\u9001","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"7909.16","erp_sales_order_product_id":924,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"product":{"id":1227,"name":"A2896\uff08\u94f6\u8272\uff09","product_type":23,"product_component":193,"product_brand":190,"product_serie":812,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-12 16:18:41","updated_at":"2024-01-12 16:18:41","pinyin_shortcut":"A2896ys","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":193,"key":193,"name":"\u6570\u7801\u7535\u5b50\u4ea7\u54c1"},"productBrand":{"id":190,"key":190,"name":"Apple\/\u82f9\u679c"},"productSerie":{"id":812,"key":812,"name":"Apple iPhone 14 Pro Max 256GB"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":924,"erp_sales_order_id":1253,"erp_store_id":null,"product_id":1227,"description":"\u8d60\u9001","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"7909.16","total_cost":"7909.16","supplier_id":262,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3417,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":675,"project_id":3417,"contact_id":4701,"point":"100000.00","paid_point":"100000","contact":{"id":4701,"key":4701,"name":"\u5218\u6653\u51cc","client_id":93,"supplier_id":null,"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null},"projectContactPointRels":[{"id":120,"project_id":3417,"contact_id":4701,"point":"100000.00","day_at":"2024-09-29","description":"\u8f6c\u5230\u8d75\u6657\u7131\u5361\u91cc\uff0c\u7533\u8bf7\u7684\u81ea\u9001","created_at":"2024-09-30 11:27:25"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1253,"serial_no":"XSDD-20240531-00001","from_date":null,"wrote_date":"2024-05-14","handler":1005,"client_id":93,"purchase_contract_id":null,"project_id":3417,"sales_contract_id":3325,"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-01-07 16:51:14","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"53","amount":"2630000","created_by":1005,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-05-31 11:50:54","updated_at":"2025-01-07 16:51:14","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":736,"progress_remain_display":747,"forecast_remain_display":678,"projectProductTotalAmount":2630000,"projectProductAllAmount":true,"projectProductTotalCost":2017076.16,"projectProductAllCost":true,"projectProductTotalNumber":53,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":365,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"1\u5e74\u524d","can_view_product":true,"budget_display":"263\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":100000,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1}],"pagenation":{"totalcount":10,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.86","ua":"jinchangxiao\/2.3.156 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-07 11:10:17', 441469952) RETURNING "id"
11:10:17.4905.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1383, 1386, 1384, 1387, 1385, 1388, 1389, 1390, 1391, 1701, 1392, 593, 1702, 592, 564, 1393, 1394, 338, 1577, 1578, 1127, 563, 598, 812)
11:10:17.2375.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:10:17.3474.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4497, 4074, 3325, 3679, 3705))
11:10:17.4964.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 1434, 1435, 1436, 1437, 1395, 1396, 1397, 1398, 1399, 1400, 1401, 1402, 1403, 1875, 1876, 1874, 1877)
11:10:17.1564.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:10:17.3284.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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "c"."project_id"
11:10:17.3393.8 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.2433.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
11:10:17.2503.6 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
11:10:17.3083.4 msyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417) GROUP BY "project_id"
11:10:17.2703.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47
11:10:17.3362.9 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "project_id"
11:10:17.1362.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:10:17.2831.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.2901.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
11:10:17.5551.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417))
11:10:17.2801.3 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.4771.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417) ORDER BY "id"
11:10:17.2751.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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417) ORDER BY "contribution" DESC, "engineer_id"
11:10:17.4751.0 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.5521.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (4701, 5876)
11:10:17.4600.9 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 (4497, 4074, 3325, 3679, 3705) ORDER BY "id"
11:10:17.4590.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
11:10:17.3120.7 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "project_id"
11:10:17.2810.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.5630.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417))
11:10:17.5510.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.4620.7 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 (4497, 4074, 3325, 3679, 3705) ORDER BY "remind_date"
11:10:17.5540.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((4701, 3417), (4701, 3700), (4701, 3488), (5876, 3488), (4701, 4135), (5876, 4135))
11:10:17.4640.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4497, 4074, 3325, 3679, 3705)
11:10:17.1660.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='93') AND ("deleted"=FALSE)
11:10:17.3350.6 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 (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "project_id"
11:10:17.2860.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.3070.6 msyii\db\Command::querySELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)) GROUP BY "project_id"
11:10:17.4620.6 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 (4497, 4074, 3325, 3679, 3705)
11:10:17.2930.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:10:17.4650.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (729, 614, 534, 68, 262)
11:10:17.4880.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 7, 19, 22, 3, 4, 23)
11:10:17.2820.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (135, 1, 164, 172, 5, 226, 215, 196, 204, 184, 189, 185, 191, 340, 128, 130, 142, 2, 349, 369, 377, 350, 416)) ORDER BY "sort"
11:10:17.4890.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (26, 35, 153, 151, 189, 15, 39, 43, 14, 193)
11:10:17.5570.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (4146, 4135, 3954, 3461, 3488, 3702, 3699, 3700, 3451, 3417)
11:10:17.2790.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 2, 4)
11:10:17.2890.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
11:10:17.5620.4 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 (145, 102, 183)
11:10:17.2740.4 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
11:10:17.4890.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (40, 137, 134, 133, 27, 4, 190)
11:10:17.2870.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (135, 1, 164, 172, 5, 226, 215, 196, 204, 184, 189, 185, 191, 340, 128, 130, 142, 2, 349, 369, 377, 350, 416)) ORDER BY "sort"
11:10:17.2730.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=5
11:10:17.2790.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (3, 6, 4, 9, 2)
11:10:17.4950.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (1, 8, 2, 7, 4, 6, 3)
11:10:17.2850.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (135, 1, 164, 172, 5, 226, 215, 196, 204, 184, 189, 185, 191, 340, 128, 130, 142, 2, 349, 369, 377, 350, 416)) ORDER BY "sort"
11:10:17.5540.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=93
11:10:17.4630.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 5087)
11:10:17.5610.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (145, 102, 183)
11:10:17.4640.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 (1001, 5087, 1005))
11:10:17.4780.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (614, 262, 534, 68)
11:10:17.2880.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
11:10:17.2940.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
11:10:17.2880.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
11:10:17.5620.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (145, 102, 183)
11:10:17.5630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (145, 102, 183)
11:10:17.2890.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
11:10:17.2930.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005