Performance Profiling

Total processing time: 332 ms; Peak memory: 8.014 MB. Show Profiling Timeline

总计89条数据

Time	Duration	Category	Info

12:03:26.024	45.5 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "object_id"
12:03:25.883	42.5 ms	yii\db\Command::query	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"."name" ILIKE '%重庆灵狐%') OR ("c"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("usedclient"."name" ILIKE '%重庆灵狐%') OR ("usedclient"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("p"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("p"."project_title" ILIKE '%重庆灵狐%') OR ("p"."description" ILIKE '%重庆灵狐%') OR ("p"."comment" ILIKE '%重庆灵狐%')) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC LIMIT 10
12:03:25.841	41.5 ms	yii\db\Command::query	SELECT 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"."name" ILIKE '%重庆灵狐%') OR ("c"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("usedclient"."name" ILIKE '%重庆灵狐%') OR ("usedclient"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("p"."pinyin_shortcut" ILIKE '%重庆灵狐%') OR ("p"."project_title" ILIKE '%重庆灵狐%') OR ("p"."description" ILIKE '%重庆灵狐%') OR ("p"."comment" ILIKE '%重庆灵狐%')) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "p"."id" ORDER BY "p"."updated_at" DESC) "c"
12:03:26.109	38.3 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/project/list', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","ProjectSearch":{"projectProductTypes":"","keyword":"\u91cd\u5e86\u7075\u72d0","created_by":"","salesForecast":"","project_status":"","project_progress":"","engineer_id":"","period":""},"device_type":"0","version_code":"276","page":"1","token":"5afa790920038c617a9521d51260254c","posttime":"1783915405","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":4130,"client_id":2032,"project_status":3,"project_progress":6,"budget":"3900","profit_pct":"32.26","bargain_date":"2026-03-04","description":"","created_by":5295,"created_at":"2026-03-04 09:18:25","updated_at":"2026-03-13 15:41:20","engineer_id":null,"project_title":"2026\u9632\u706b\u5899\u7eed\u4fdd","collected":"3900","status_updated_at":"2026-03-04 09:18:25.382492+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2026-03-04 09:18:25.382492+08","forecast_updated_at":"2026-03-04 09:18:25.382492+08","end_at":"2026-03-13 15:41:20","pinyin_shortcut":"2026fhqxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1331,"is_sales_order_ready":true,"collected_plan":3900,"change_status_to":null,"is_verify":true,"profits":"1258.140000000000000000","remain":"131 days 02:45:00.502439","progress_remain":"131 days 02:45:00.502439","forecast_remain":"131 days 02:45:00.502439","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"9 days 06:22:54.771989","issued_invoices":"3900","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"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":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"3900","pct":"32.26","profit":"1258.14","project_id":4130}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":4130,"points":"31"},"workLogCount":null,"caseCount":{"project_id":4130,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":4130,"sum":"1","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4430,"from_project":4130,"payment_collection_remind_ahead":"00:00:00","serial_no":"\u5317\u4eac\u7075\u72d0\u4f20\u797aTS-WZW-20260309-001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3900","erp_un_settle_amount":"0","including_tax":true,"amount":"3900","contractScans":[{"id":57702,"object_type":105,"object_id":4430,"attachment_id":32309,"attachment":{"id":32309,"key":32309,"name":"8e00d6fd-23d1-3411-a162-cf65bda87d17","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8e00d6fd-23d1-3411-a162-cf65bda87d17\/2026_03_13_15_39_57.pdf","orig_name":"2026_03_13_15_39_57.pdf"}}],"receiptScans":[{"id":57340,"object_type":106,"object_id":4430,"attachment_id":32492,"attachment":{"id":32492,"key":32492,"name":"f533deec-0862-303b-bd28-8e79de9c4c55","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/f533deec-0862-303b-bd28-8e79de9c4c55\/74161774239526_.pic.jpg","orig_name":"74161774239526_.pic.jpg"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12186","key":"12186","contract_id":4430,"value":"3900","created_by":1013,"collected_date":"2026-03-09 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":2315,"key":2315,"contract_id":4430,"value":"3900","attachment_id":null,"from_date":"2026-03-04","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2759,"key":2759,"contract_id":4430,"name":"2026-03-31","value":"3900","overdue_days":null,"status":1,"remind_date":"2026-03-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":4216,"contract_id":4430,"supplier_id":686,"purchase_id":4435,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":4435,"key":4435,"serial_no":"TSKJ20260309-ZHF-001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":3900},"projectRemindReceivers":[{"id":2131,"user_id":1001,"key":1001,"project_id":4130,"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":2132,"user_id":1005,"key":1005,"project_id":4130,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"projectProductRels":[{"id":12011,"project_id":4130,"product_id":867,"amount":"1300","number":1,"cost":"777","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1300","total_cost":"777","erp_sales_order_product_id":2204,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2204,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"1","amount":"1300","total_amount":"1300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12012,"project_id":4130,"product_id":868,"amount":"1400","number":1,"cost":"713","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":"713","erp_sales_order_product_id":2205,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2205,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"1","amount":"1400","total_amount":"1400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":12013,"project_id":4130,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":2206,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":2206,"erp_sales_order_id":1688,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"1","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":4130,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1688,"serial_no":"XSDD-20260304-00001","from_date":null,"wrote_date":"2026-03-04","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":4130,"sales_contract_id":4430,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2026-03-04 09:19:27","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":null,\"salesContractPaymentCollectionRemindReceivers\":null,\"salesContractPaymentCollectionRemindDates\":[{\"amount\":\"3900\",\"remind_date\":\"2026-03-31\",\"pct\":1}]}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2026-03-04 09:18:25","updated_at":"2026-03-04 09:19:27","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":131,"progress_remain_display":131,"forecast_remain_display":131,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":2364,"projectProductAllCost":true,"projectProductTotalNumber":3,"unissued_invoice":0,"is_exceeded":false,"can_update":false,"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":9,"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":"3900","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":3,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":126,"erp_sales_order_id":1688,"user_id":1001,"status":1,"description":null,"verify_at":"2026-03-04 09:19:27","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":3800,"client_id":2032,"project_status":3,"project_progress":4,"budget":"3900","profit_pct":"32.26","bargain_date":"2025-03-18","description":"","created_by":5295,"created_at":"2025-03-17 18:28:37","updated_at":"2026-01-14 10:52:34","engineer_id":null,"project_title":"25\u5e74\u9632\u706b\u5899\u7eed\u4fdd","collected":"3900","status_updated_at":"2025-03-17 18:28:37.03026+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-17 18:28:37.03026+08","forecast_updated_at":"2025-03-17 18:28:37.03026+08","end_at":"2026-01-14 10:52:34","pinyin_shortcut":"25nfhqxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":1291,"is_sales_order_ready":true,"collected_plan":3900,"change_status_to":null,"is_verify":false,"profits":"1258.140000000000000000","remain":"482 days 17:34:48.854671","progress_remain":"482 days 17:34:48.854671","forecast_remain":"482 days 17:34:48.854671","lost_contact_days":"481.957244038553","last_contact":"2025-03-18 13:05:00","last_arrive_days":null,"last_arrive":null,"duration":"302 days 16:23:57.144579","issued_invoices":"3900.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"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":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":"3900","pct":"32.26","profit":"1258.14","project_id":3800}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3800,"points":"31"},"workLogCount":{"project_id":3800,"count":2},"caseCount":{"project_id":3800,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3800,"sum":"0.583333333333333","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3829,"from_project":3800,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-20250318001","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3900","erp_un_settle_amount":"0","including_tax":true,"amount":"3900","contractScans":[{"id":55411,"object_type":105,"object_id":3829,"attachment_id":24854,"attachment":{"id":24854,"key":24854,"name":"051e12d5-5aec-3753-a200-7ba77ca34d83","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/051e12d5-5aec-3753-a200-7ba77ca34d83\/\u7075\u72d0\u79d1\u6280.pdf","orig_name":"\u7075\u72d0\u79d1\u6280.pdf"}}],"receiptScans":[{"id":33225,"object_type":106,"object_id":3829,"attachment_id":24874,"attachment":{"id":24874,"key":24874,"name":"c0d7194b-2b2f-32f9-a0fd-d6eda19a05a5","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/c0d7194b-2b2f-32f9-a0fd-d6eda19a05a5\/2025_03_20_10_04_29.pdf","orig_name":"2025_03_20_10_04_29.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":253,"serial_no":"SKD-20250318-00002","wrote_date":"2025-03-18","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":3829,"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-03-18 17:03:22","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3900","settle_amount":"3900","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2025-03-18 17:03:22","updated_at":"2025-03-18 17:03:22","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1253","key":"1253","contract_id":3829,"value":"3900","created_by":1013,"collected_date":"2025-03-18 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1989,"key":1989,"contract_id":3829,"value":"3900.00","attachment_id":null,"from_date":"2025-03-19","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2361,"key":2361,"contract_id":3829,"name":"2025-03-19","value":"3900","overdue_days":null,"status":1,"remind_date":"2025-03-19","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":4038,"contract_id":3829,"supplier_id":686,"purchase_id":3964,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":3964,"key":3964,"serial_no":"TSKJ20250318-HYF-001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":3900},"projectRemindReceivers":[{"id":1438,"user_id":1001,"key":1001,"project_id":3800,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":11846,"project_id":3800,"product_id":867,"amount":"1300","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1300","total_cost":null,"erp_sales_order_product_id":1547,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1547,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1300","total_amount":"1300","last_number":"1","last_amount":"1300","last_total_amount":"1300","cost":"777.00","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11847,"project_id":3800,"product_id":868,"amount":"1400","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1400","total_cost":null,"erp_sales_order_product_id":1548,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1548,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1400","total_amount":"1400","last_number":"1","last_amount":"1400","last_total_amount":"1400","cost":"713.00","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11848,"project_id":3800,"product_id":870,"amount":"1200","number":1,"cost":null,"description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":null,"erp_sales_order_product_id":1549,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":1549,"erp_sales_order_id":1460,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":"1","last_amount":"1200","last_total_amount":"1200","cost":"874.00","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3800,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1460,"serial_no":"XSDD-20250317-00001","from_date":null,"wrote_date":"2025-03-18","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3800,"sales_contract_id":3829,"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-03-18 17:03:22","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2025-03-17 18:28:37","updated_at":"2025-03-18 17:03:22","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":482,"progress_remain_display":482,"forecast_remain_display":482,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":false,"projectProductTotalNumber":3,"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":302,"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":"3900","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3936,"client_id":2032,"project_status":3,"project_progress":9,"budget":"11779","profit_pct":"21.29","bargain_date":"2025-08-11","description":"","created_by":5295,"created_at":"2025-08-01 07:47:45","updated_at":"2026-01-14 09:38:00","engineer_id":null,"project_title":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","collected":"11779","status_updated_at":"2025-08-11 11:02:32.607523+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-08-11 11:02:32.607523+08","forecast_updated_at":"2025-08-01 07:47:45.056585+08","end_at":"2026-01-14 09:38:00","pinyin_shortcut":"2025nswxwglsbxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"1000","paid_contact_point":null,"project_product_version_id":1203,"is_sales_order_ready":true,"collected_plan":11779,"change_status_to":null,"is_verify":false,"profits":"2507.749100000000000000","remain":"336 days 01:00:53.277408","progress_remain":"336 days 01:00:53.277408","forecast_remain":"346 days 04:15:40.828346","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"166 days 01:50:15.808965","issued_invoices":"11779.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"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":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"11779","pct":"21.29","profit":"2507.74","project_id":3936}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":4086,"from_project":3936,"payment_collection_remind_ahead":"1 day","serial_no":"TS-WZW-2025080401","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"11779","erp_un_settle_amount":"0","including_tax":true,"amount":"11779","contractScans":[{"id":55300,"object_type":105,"object_id":4086,"attachment_id":27465,"attachment":{"id":27465,"key":27465,"name":"7482626a-7483-377b-9446-07103aae1479","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7482626a-7483-377b-9446-07103aae1479\/11779.pdf","orig_name":"11779.pdf"}}],"receiptScans":[{"id":48869,"object_type":106,"object_id":4086,"attachment_id":27797,"attachment":{"id":27797,"key":27797,"name":"d224a4de-860a-3dd3-9b20-c18758a75ef9","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/d224a4de-860a-3dd3-9b20-c18758a75ef9\/59251756100887_.pic_hd.jpg","orig_name":"59251756100887_.pic_hd.jpg"}}],"verifyScans":[],"erpCollectTickets":[],"salesContractPayments":[{"id":"12008","key":"12008","contract_id":4086,"value":"11779","created_by":5388,"collected_date":"2025-08-15 00:00:00","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":2118,"key":2118,"contract_id":4086,"value":"11779.00","attachment_id":null,"from_date":"2025-08-11","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2542,"key":2542,"contract_id":4086,"name":"2025-09-30","value":"11779","overdue_days":null,"status":1,"remind_date":"2025-09-30","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":9748,"user_id":5295,"key":5295,"contract_id":4086,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":3876,"contract_id":4086,"supplier_id":236,"purchase_id":4093,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":4093,"key":4093,"serial_no":"TSKJ20250815-ZHF-001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":11779},"projectRemindReceivers":[{"id":1725,"user_id":1001,"key":1001,"project_id":3936,"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":1726,"user_id":1005,"key":1005,"project_id":3936,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"projectProductRels":[{"id":11609,"project_id":3936,"product_id":1717,"amount":"5235","number":1,"cost":"3246","description":"","supplier_id":null,"hardware_from":"2025-08-17","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-17","software_to":null,"maintenance_to":null,"total_amount":"5235","total_cost":"3246","erp_sales_order_product_id":1831,"supplier":null,"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1831,"erp_sales_order_id":1563,"erp_store_id":null,"product_id":1717,"description":"","number":"1","outbound":"1","amount":"5235","total_amount":"5235","last_number":"1","last_amount":"5235","last_total_amount":"5235","cost":"3246","total_cost":"3246","supplier_id":null,"hardware_from":"2025-08-17","software_from":null,"maintenance_from":null,"hardware_to":"2026-08-17","software_to":null,"maintenance_to":null}},{"id":11610,"project_id":3936,"product_id":1722,"amount":"6544","number":1,"cost":"4058","description":"","supplier_id":null,"hardware_from":null,"software_from":"2025-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-17","maintenance_to":null,"total_amount":"6544","total_cost":"4058","erp_sales_order_product_id":1830,"supplier":null,"product":{"id":1722,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1457,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:32","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1457,"key":1457,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1830,"erp_sales_order_id":1563,"erp_store_id":null,"product_id":1722,"description":"","number":"1","outbound":"1","amount":"6544","total_amount":"6544","last_number":"1","last_amount":"6544","last_total_amount":"6544","cost":"4058","total_cost":"4058","supplier_id":null,"hardware_from":null,"software_from":"2025-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2026-08-17","maintenance_to":null}}],"commentCount":{"object_id":3936,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":1347,"project_id":3936,"contact_id":3509,"point":"1000.00","paid_point":null,"contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[],"status_display":"\u672a\u6838\u9500"}],"erpSalesOrder":{"id":1563,"serial_no":"XSDD-20250811-00001","from_date":null,"wrote_date":"2025-08-11","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3936,"sales_contract_id":4086,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-08-11 15:53:55","stop_at":"2025-08-15 15:03:00.658357+08","cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"2","amount":"11779","created_by":5295,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5295\"],\"salesContractPaymentCollectionRemindDates\":{\"2025-09-30\":\"11779.00\"}}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":true,"is_old":false,"created_at":"2025-08-11 11:02:32","updated_at":"2025-08-15 15:03:41","print_times":null},"projectUsedClient":{"id":176,"project_id":3936,"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":336,"progress_remain_display":336,"forecast_remain_display":346,"projectProductTotalAmount":11779,"projectProductAllAmount":true,"projectProductTotalCost":7304,"projectProductAllCost":true,"projectProductTotalNumber":2,"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":166,"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":"1.18\u4e07","contact_points_status_display":"\u672a\u6838\u9500","total_contact_paid_point":0,"total_contact_un_paid_point":1000,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[{"id":1,"erp_sales_order_id":1563,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-11 15:53:55","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":3861,"client_id":2032,"project_status":5,"project_progress":5,"budget":"19000","profit_pct":"20","bargain_date":"2025-06-30","description":null,"created_by":5295,"created_at":"2025-05-19 13:23:49","updated_at":"2025-07-31 13:56:46","engineer_id":null,"project_title":"2025\u65b0\u8d2d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406-K","collected":"0","status_updated_at":"2025-07-07 17:12:46.06748+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-05-19 13:24:08.121016+08","forecast_updated_at":"2025-07-07 17:12:46.06748+08","end_at":"2025-07-07 17:12:46","pinyin_shortcut":"2025xgswxwglK","creator":5295,"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":"3800.0000000000000000","remain":"370 days 18:50:39.817451","progress_remain":"419 days 22:39:17.763915","forecast_remain":"370 days 18:50:39.817451","lost_contact_days":"390.811908390405","last_contact":"2025-06-17 16:34:17","last_arrive_days":"390.811908390405","last_arrive":"2025-06-17 16:34:17+08","duration":"49 days 03:48:56.249991","issued_invoices":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"19000.00","pct":"20","profit":"3800","project_id":3861}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":null,"workLogCount":{"project_id":3861,"count":3},"caseCount":null,"salesTimeCount":{"project_id":3861,"hours":"2.35166666666667","times":3},"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3861,"sum":"158.00"},"buildContract":null,"projectRemindReceivers":[{"id":1599,"user_id":1001,"key":1001,"project_id":3861,"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":1600,"user_id":1005,"key":1005,"project_id":3861,"user":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"projectProductRels":[],"commentCount":{"object_id":3861,"comment":2},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":{"id":147,"project_id":3861,"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":370,"progress_remain_display":419,"forecast_remain_display":370,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":19000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"1\u5e74\u524d","project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":49,"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":"1.9\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3479,"client_id":2032,"project_status":3,"project_progress":7,"budget":"3900","profit_pct":"32.26","bargain_date":"2024-03-22","description":"","created_by":5295,"created_at":"2024-03-22 15:05:24","updated_at":"2025-03-18 11:39:12","engineer_id":null,"project_title":"2024\u5e74\u9632\u706b\u5899\u8bbe\u5907\u7eed\u4fdd","collected":"3900","status_updated_at":"2024-03-22 15:05:24.349345+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-03-22 15:05:24.349345+08","forecast_updated_at":"2024-03-22 15:05:24.349345+08","end_at":"2024-05-21 10:19:34","pinyin_shortcut":"2024nfhqsbxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"500","paid_contact_point":"500","project_product_version_id":308,"is_sales_order_ready":true,"collected_plan":3900,"change_status_to":null,"is_verify":false,"profits":"1258.140000000000000000","remain":"842 days 20:58:01.535586","progress_remain":"842 days 20:58:01.535586","forecast_remain":"842 days 20:58:01.535586","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"59 days 19:14:09.987207","issued_invoices":"3900.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"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":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"3900","pct":"32.26","profit":"1258.14","project_id":3479}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3479,"points":"125"},"workLogCount":null,"caseCount":{"project_id":3479,"count":3},"salesTimeCount":null,"implementTimeCount":{"project_id":3479,"sum":"3.13333333333333","times":"3"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":3196,"from_project":3479,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2024032236","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3900","erp_un_settle_amount":"0","including_tax":true,"amount":"3900","contractScans":[{"id":31987,"object_type":105,"object_id":3196,"attachment_id":18331,"attachment":{"id":18331,"key":18331,"name":"5d631b06-7aac-38fc-b3e2-5c59db60e835","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5d631b06-7aac-38fc-b3e2-5c59db60e835\/2024_03_26_13_51_27.pdf","orig_name":"2024_03_26_13_51_27.pdf"}}],"receiptScans":[{"id":24819,"object_type":106,"object_id":3196,"attachment_id":18373,"attachment":{"id":18373,"key":18373,"name":"b9072831-ac9e-30d6-9353-efa1a66440a1","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b9072831-ac9e-30d6-9353-efa1a66440a1\/2024_03_28_09_21_00.pdf","orig_name":"2024_03_28_09_21_00.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":649,"serial_no":"SKD-20240322-00001","wrote_date":"2024-03-22","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":3196,"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-03-22 16:56:42","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3900","settle_amount":"3900","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-03-22 16:56:42","updated_at":"2024-03-22 16:56:42","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1649","key":"1649","contract_id":3196,"value":"3900","created_by":1013,"collected_date":"2024-03-22 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1621,"key":1621,"contract_id":3196,"value":"3900.00","attachment_id":null,"from_date":"2024-03-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1670,"key":1670,"contract_id":3196,"name":"2024-03-31","value":"3900","overdue_days":null,"status":1,"remind_date":"2024-03-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":7773,"user_id":5295,"key":5295,"contract_id":3196,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":2517,"contract_id":3196,"supplier_id":686,"purchase_id":3269,"supplier":{"id":686,"key":686,"name":"\u5317\u4eac\u4e07\u7f51\u878d\u901a\u4fe1\u606f\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"purchase":{"id":3269,"key":3269,"serial_no":"TSKJ20240326-HYF-001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":3900},"projectRemindReceivers":[{"id":1050,"user_id":1001,"key":1001,"project_id":3479,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":8716,"project_id":3479,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":741,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":741,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}},{"id":8717,"project_id":3479,"product_id":868,"amount":"1400","number":1,"cost":"713","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1400","total_cost":"713","erp_sales_order_product_id":742,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":742,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1400","total_amount":"1400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}},{"id":8718,"project_id":3479,"product_id":867,"amount":"1300","number":1,"cost":"777","description":"","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null,"total_amount":"1300","total_cost":"777","erp_sales_order_product_id":743,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":743,"erp_sales_order_id":1209,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1300","total_amount":"1300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":146,"hardware_from":null,"software_from":"2024-03-31","maintenance_from":null,"hardware_to":null,"software_to":"2025-03-30","maintenance_to":null}}],"commentCount":{"object_id":3479,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":854,"project_id":3479,"contact_id":3509,"point":"500.00","paid_point":"500","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":152,"project_id":3479,"contact_id":3509,"point":"500.00","day_at":"2024-05-22","description":"\u79ef\u5206\u8f6c\u4eac\u4e1c\u5361","created_at":"2025-01-21 09:44:51"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1209,"serial_no":"XSDD-20240322-00002","from_date":null,"wrote_date":"2024-03-22","handler":5015,"client_id":2032,"purchase_contract_id":null,"project_id":3479,"sales_contract_id":3196,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-05-21 10:19:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"3900","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-03-22 15:05:24","updated_at":"2024-05-21 10:19:34","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":842,"progress_remain_display":842,"forecast_remain_display":842,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":2364,"projectProductAllCost":true,"projectProductTotalNumber":3,"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":59,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"3900","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":500,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3082,"client_id":2032,"project_status":3,"project_progress":9,"budget":"28949","profit_pct":"15.06","bargain_date":"2023-07-25","description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","created_by":5295,"created_at":"2023-01-06 16:52:34","updated_at":"2025-01-21 13:10:34","engineer_id":null,"project_title":"\u534e\u4e09\u7f51\u7edc\u4ea7\u54c1\u5347\u7ea7-K","collected":"28949","status_updated_at":"2023-07-24 18:12:25.283666+08","success_rate":null,"comment":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd\r\n","contract_type":1,"progress_updated_at":"2023-07-23 21:30:49.709434+08","forecast_updated_at":"2023-07-23 21:30:49.709434+08","end_at":"2023-07-25 15:30:56","pinyin_shortcut":"hswlcpsjK","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"2000","paid_contact_point":"2000","project_product_version_id":188,"is_sales_order_ready":true,"collected_plan":28949,"change_status_to":null,"is_verify":false,"profits":"4359.719400000000000000","remain":"1084 days 17:51:00.601265","progress_remain":"1085 days 14:32:36.175497","forecast_remain":"1085 days 14:32:36.175497","lost_contact_days":"1077.91904959411","last_contact":"2023-07-31 14:00:00","last_arrive_days":"1090.86349403855","last_arrive":"2023-07-18 15:20:00+08","duration":"199 days 22:38:21.757251","issued_invoices":"28949.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3082,"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":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"28949.00","pct":"15.06","profit":"4359.7194","project_id":3082}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3082,"points":"156"},"workLogCount":{"project_id":3082,"count":17},"caseCount":{"project_id":3082,"count":5},"salesTimeCount":{"project_id":3082,"hours":"2.51666666666667","times":2},"implementTimeCount":{"project_id":3082,"sum":"11.8433333333333","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3082,"sum":"141.25"},"buildContract":{"id":2762,"from_project":3082,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2023072533","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"28949","erp_un_settle_amount":"0","including_tax":true,"amount":"28949","contractScans":[{"id":23612,"object_type":105,"object_id":2762,"attachment_id":14166,"attachment":{"id":14166,"key":14166,"name":"43ca74f4-cea9-391a-8b20-0309134330ff","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/43ca74f4-cea9-391a-8b20-0309134330ff\/2023_07_31_15_22_08.pdf","orig_name":"2023_07_31_15_22_08.pdf"}}],"receiptScans":[{"id":19627,"object_type":106,"object_id":2762,"attachment_id":14181,"attachment":{"id":14181,"key":14181,"name":"8c041fa3-c908-3ea8-a31a-90178a1c5cd1","extension":"jpg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/8c041fa3-c908-3ea8-a31a-90178a1c5cd1\/69351690867223_.pic_hd.jpg","orig_name":"69351690867223_.pic_hd.jpg"}}],"verifyScans":[],"erpCollectTickets":[{"id":1042,"serial_no":"SKD-20230725-00002","wrote_date":"2023-07-25","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":2762,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2023-07-25 15:30:56","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"28949","settle_amount":"28949","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-07-25 15:30:56","updated_at":"2023-07-25 15:30:56","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11042","key":"11042","contract_id":2762,"value":"28949","created_by":1014,"collected_date":"2023-07-25 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1447,"key":1447,"contract_id":2762,"value":"28949.00","attachment_id":null,"from_date":"2023-08-01","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1292,"key":1292,"contract_id":2762,"name":"2023-08-31","value":"28949","overdue_days":null,"status":1,"remind_date":"2023-08-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":4743,"user_id":5295,"key":5295,"contract_id":2762,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":489,"contract_id":2762,"supplier_id":236,"purchase_id":2778,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2778,"key":2778,"serial_no":"TSKJ-ZHF-20230725002"}},{"id":2378,"contract_id":2762,"supplier_id":681,"purchase_id":2775,"supplier":{"id":681,"key":681,"name":"\u5317\u4eac\u9e3f\u8499\u8c6b\u901a\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2775,"key":2775,"serial_no":"A202307-27"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":28949},"projectRemindReceivers":[{"id":649,"user_id":1001,"key":1001,"project_id":3082,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":2991,"project_id":3082,"product_id":734,"amount":"10524.5","number":2,"cost":"6526.08","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21049.0","total_cost":"13052.16","erp_sales_order_product_id":270,"supplier":null,"product":{"id":734,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1","product_type":22,"product_component":200,"product_brand":12,"product_serie":1020,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-10-13 11:12:39","updated_at":"2025-11-21 15:46:18","pinyin_shortcut":"sxfAC1000xbfw","product_unit":8,"is_renew":false,"in_out_at":"2025-11-21 15:46:18.087915+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":200,"key":200,"name":"\u7eed\u4fdd\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1020,"key":1020,"name":"\u6df1\u4fe1\u670d AC-1000 \u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":270,"erp_sales_order_id":1061,"erp_store_id":null,"product_id":734,"description":"","number":"2","outbound":"0","amount":"10524.5","total_amount":"21049.0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6526.08","total_cost":"13052.16","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2992,"project_id":3082,"product_id":742,"amount":"7900","number":1,"cost":"6700","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7900","total_cost":"6700","erp_sales_order_product_id":271,"supplier":null,"product":{"id":742,"name":"H3C S5560X-30C-EI","product_type":4,"product_component":19,"product_brand":20,"product_serie":1220,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2020-12-24 11:36:22","updated_at":"2024-02-21 17:27:33","pinyin_shortcut":"H3CS5560X30CEI","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":19,"key":19,"name":"\u4ea4\u6362\u673a"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1220,"key":1220,"name":"H3C S5560X-30C-EI L3\u4ee5\u592a\u7f51\u4ea4\u6362\u673a"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":271,"erp_sales_order_id":1061,"erp_store_id":null,"product_id":742,"description":"","number":"1","outbound":"0","amount":"7900","total_amount":"7900","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6700","total_cost":"6700","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3082,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":340,"project_id":3082,"contact_id":3509,"point":"2000.00","paid_point":"2000","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":57,"project_id":3082,"contact_id":3509,"point":"2000.00","day_at":"2023-08-24","description":"","created_at":"2024-01-11 16:11:57"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1061,"serial_no":"XSDD-20230724-00002","from_date":null,"wrote_date":"2023-07-25","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3082,"sales_contract_id":2762,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u91c7\u8d2d\u534e\u4e09\u4ea4\u6362\u673a\u548c\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-25 15:30:56","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"3","amount":"28949","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-24 18:12:25","updated_at":"2023-07-25 15:30:56","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1084,"progress_remain_display":1085,"forecast_remain_display":1085,"projectProductTotalAmount":28949,"projectProductAllAmount":true,"projectProductTotalCost":19752.16,"projectProductAllCost":true,"projectProductTotalNumber":3,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"2\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":199,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"2\u5e74\u524d","can_view_product":true,"budget_display":"2.89\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":2000,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3619,"client_id":2032,"project_status":3,"project_progress":5,"budget":"21049","profit_pct":"20.13","bargain_date":"2024-08-06","description":"","created_by":5295,"created_at":"2024-08-02 16:14:35","updated_at":"2025-01-13 14:50:16","engineer_id":null,"project_title":"2024\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd-K","collected":"21049","status_updated_at":"2024-08-02 17:07:14.781368+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-08-02 16:14:35.689205+08","forecast_updated_at":"2024-08-02 16:14:35.689205+08","end_at":"2024-08-02 17:12:55","pinyin_shortcut":"2024swxwglsbxbK","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":"2000","paid_contact_point":"2000","project_product_version_id":519,"is_sales_order_ready":true,"collected_plan":21049,"change_status_to":null,"is_verify":false,"profits":"4237.163700000000000000","remain":"709 days 18:56:11.103563","progress_remain":"709 days 19:48:50.195726","forecast_remain":"709 days 19:48:50.195726","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"00:58:19.994186","issued_invoices":"21049.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"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":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7","description":"\u5b9a\u4e49\uff1a1.\u62a5\u4ef7\u6709\u6548\u671f 2.\u6838\u7b97\u5229\u6da6\u7387 3. \u4ea4\u8d27\u65b9\u5f0f\u53ca\u65f6\u95f4 4.\u9a8c\u6536\u65b9\u5f0f 5.\u6536\u6b3e\u65b9\u5f0f 6.\u8fdd\u7ea6\u6761\u6b3e \n\u65b9\u6cd5\uff1a\u7528\u516c\u53f8\u6807\u51c6\u7684\u62a5\u4ef7\u5355\u6837\u5f0f\u5411\u5ba2\u6237\u63d0\u4f9b\u62a5\u4ef7\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"21049.00","pct":"20.13","profit":"4237.1637","project_id":3619}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"opportunityFrom":null,"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3619,"points":"157"},"workLogCount":null,"caseCount":{"project_id":3619,"count":3},"salesTimeCount":null,"implementTimeCount":{"project_id":3619,"sum":"10.4069444444444","times":"3"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3619,"sum":"90.00"},"buildContract":{"id":3451,"from_project":3619,"payment_collection_remind_ahead":"1 day","serial_no":"TS-WZW-2024080601","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"21049","erp_un_settle_amount":"0","including_tax":true,"amount":"21049","contractScans":[{"id":31880,"object_type":105,"object_id":3451,"attachment_id":20799,"attachment":{"id":20799,"key":20799,"name":"4d0012ef-bc48-3d40-8b20-eadb3d801bd9","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/4d0012ef-bc48-3d40-8b20-eadb3d801bd9\/\u7075\u72d021049.pdf","orig_name":"\u7075\u72d021049.pdf"}}],"receiptScans":[{"id":28089,"object_type":106,"object_id":3451,"attachment_id":21105,"attachment":{"id":21105,"key":21105,"name":"bff240a8-6711-396b-8fb1-e2042cc06e0e","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/bff240a8-6711-396b-8fb1-e2042cc06e0e\/WechatIMG226.jpeg","orig_name":"WechatIMG226.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":64,"serial_no":"SKD-20240802-00001","wrote_date":"2024-08-02","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":3451,"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-08-02 17:12:55","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"21049","settle_amount":"21049","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-08-02 17:12:55","updated_at":"2024-08-02 17:12:55","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"164","key":"164","contract_id":3451,"value":"21049","created_by":1013,"collected_date":"2024-08-02 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1798,"key":1798,"contract_id":3451,"value":"21049.00","attachment_id":null,"from_date":"2024-09-12","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1890,"key":1890,"contract_id":3451,"name":"2024-08-15","value":"21049","overdue_days":null,"status":1,"remind_date":"2024-08-15","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":7732,"user_id":5295,"key":5295,"contract_id":3451,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},{"id":7733,"user_id":1001,"key":1001,"contract_id":3451,"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":2353,"contract_id":3451,"supplier_id":236,"purchase_id":3454,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":3454,"key":3454,"serial_no":"TSKJ20240802-ZHF-001"}}],"payment_collection_remind_ahead_display":"\u63d0\u524d1\u5929","invoiced":21049},"projectRemindReceivers":[{"id":1162,"user_id":1001,"key":1001,"project_id":3619,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":8620,"project_id":3619,"product_id":1717,"amount":"5235","number":1,"cost":"3246","description":"","supplier_id":236,"hardware_from":"2024-08-17","software_from":"2024-08-17","maintenance_from":null,"hardware_to":"2025-08-17","software_to":"2025-08-17","maintenance_to":null,"total_amount":"5235","total_cost":"3246","erp_sales_order_product_id":1128,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1717,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1455,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:18:36","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+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":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1455,"key":1455,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1128,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1717,"description":"","number":"1","outbound":"0","amount":"5235","total_amount":"5235","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3246","total_cost":"3246","supplier_id":236,"hardware_from":"2024-08-17","software_from":"2024-08-17","maintenance_from":null,"hardware_to":"2025-08-17","software_to":"2025-08-17","maintenance_to":null}},{"id":8621,"project_id":3619,"product_id":1722,"amount":"6544","number":1,"cost":"4057.6","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2025-08-17","maintenance_to":null,"total_amount":"6544","total_cost":"4057.6","erp_sales_order_product_id":1129,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1722,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1457,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:32","updated_at":"2025-12-26 15:15:23","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1400","product_unit":2,"is_renew":true,"in_out_at":"2025-12-26 15:15:23.079959+08","productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1457,"key":1457,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1400\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1129,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1722,"description":"","number":"1","outbound":"0","amount":"6544","total_amount":"6544","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4057.6","total_cost":"4057.6","supplier_id":236,"hardware_from":null,"software_from":"2024-08-17","maintenance_from":null,"hardware_to":null,"software_to":"2025-08-17","maintenance_to":null}},{"id":8622,"project_id":3619,"product_id":1719,"amount":"4120","number":1,"cost":"2554.8","description":"","supplier_id":236,"hardware_from":"2024-11-26","software_from":"2024-11-26","maintenance_from":null,"hardware_to":"2025-11-26","software_to":"2025-11-26","maintenance_to":null,"total_amount":"4120","total_cost":"2554.8","erp_sales_order_product_id":1130,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1719,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09","product_type":22,"product_component":189,"product_brand":12,"product_serie":1456,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:20:04","updated_at":"2024-08-05 15:20:04","pinyin_shortcut":"sxfcpzbrjsjfwsyyAC1000B1300","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":189,"key":189,"name":"\u8f6f\u4ef6\u5347\u7ea7\u786c\u4ef6\u8d28\u4fdd"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1456,"key":1456,"name":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u8d28\u4fdd+\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1130,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1719,"description":"","number":"1","outbound":"0","amount":"4120","total_amount":"4120","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2554.8","total_cost":"2554.8","supplier_id":236,"hardware_from":"2024-11-26","software_from":"2024-11-26","maintenance_from":null,"hardware_to":"2025-11-26","software_to":"2025-11-26","maintenance_to":null}},{"id":8623,"project_id":3619,"product_id":1723,"amount":"5150","number":1,"cost":"3193.6","description":"","supplier_id":236,"hardware_from":null,"software_from":"2024-11-26","maintenance_from":null,"hardware_to":null,"software_to":"2025-11-26","maintenance_to":null,"total_amount":"5150","total_cost":"3193.6","erp_sales_order_product_id":1131,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"product":{"id":1723,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09","product_type":22,"product_component":208,"product_brand":12,"product_serie":1458,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-08-05 15:28:55","updated_at":"2024-08-05 15:28:55","pinyin_shortcut":"URLampyysbgzksjsyyAC1000B1300","product_unit":2,"is_renew":true,"in_out_at":null,"productType":{"id":22,"key":22,"name":"\u670d\u52a1"},"productComponent":{"id":208,"key":208,"name":"\u4ea7\u54c1\u5347\u7ea7"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1458,"key":1458,"name":"URL&\u5e94\u7528\u8bc6\u522b\u89c4\u5219\u5e93\u5347\u7ea7\uff08\u9002\u7528\u4e8eAC-1000-B1300\uff09"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":1131,"erp_sales_order_id":1313,"erp_store_id":null,"product_id":1723,"description":"","number":"1","outbound":"0","amount":"5150","total_amount":"5150","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3193.6","total_cost":"3193.6","supplier_id":236,"hardware_from":null,"software_from":"2024-11-26","maintenance_from":null,"hardware_to":null,"software_to":"2025-11-26","maintenance_to":null}}],"commentCount":{"object_id":3619,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[{"id":848,"project_id":3619,"contact_id":3509,"point":"2000.00","paid_point":"2000","contact":{"id":3509,"key":3509,"name":"\u9648\u519b","client_id":2032,"supplier_id":null,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"supplier":null},"projectContactPointRels":[{"id":150,"project_id":3619,"contact_id":3509,"point":"2000.00","day_at":"2025-01-15","description":"","created_at":"2025-01-16 10:54:28"}],"status_display":"\u5df2\u6838\u9500"}],"erpSalesOrder":{"id":1313,"serial_no":"XSDD-20240802-00001","from_date":null,"wrote_date":"2024-08-06","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3619,"sales_contract_id":3451,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-08-02 17:12:55","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-08-02 17:07:14","updated_at":"2024-08-02 17:12:55","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":709,"progress_remain_display":709,"forecast_remain_display":709,"projectProductTotalAmount":21049,"projectProductAllAmount":true,"projectProductTotalCost":13052,"projectProductAllCost":true,"projectProductTotalNumber":4,"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":1,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"2.1\u4e07","contact_points_status_display":"\u5df2\u6838\u9500","total_contact_paid_point":2000,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":3127,"client_id":2032,"project_status":3,"project_progress":7,"budget":"3900","profit_pct":"26.28","bargain_date":"2023-02-27","description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","created_by":5295,"created_at":"2023-02-27 11:50:30","updated_at":"2024-03-22 13:55:02","engineer_id":null,"project_title":"\u9632\u706b\u5899\u7eed\u4fdd","collected":"3900","status_updated_at":"2023-02-27 17:13:59.878536+08","success_rate":null,"comment":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd\r\n","contract_type":2,"progress_updated_at":"2023-02-27 11:50:30.300026+08","forecast_updated_at":"2023-02-27 11:50:30.300026+08","end_at":"2023-02-27 17:48:51","pinyin_shortcut":"fhqxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":189,"is_sales_order_ready":false,"collected_plan":3900,"change_status_to":null,"is_verify":false,"profits":"1024.920000000000000000","remain":"1231 days 18:49:26.006395","progress_remain":"1232 days 00:12:55.584905","forecast_remain":"1232 days 00:12:55.584905","lost_contact_days":"1222.04404959411","last_contact":"2023-03-09 11:00:00","last_arrive_days":null,"last_arrive":null,"duration":"05:58:20.927043","issued_invoices":"3900.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3127,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"3900.00","pct":"26.28","profit":"1024.92","project_id":3127}],"salesForecast":{"id":178,"key":178,"name":"90%","description":"\u7b49\u5f85\u7b7e\u7ea6"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":3127,"points":"62"},"workLogCount":{"project_id":3127,"count":2},"caseCount":{"project_id":3127,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":3127,"sum":"3","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2578,"from_project":3127,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2023022755","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3900","erp_un_settle_amount":"0","including_tax":true,"amount":"3900","contractScans":[{"id":23613,"object_type":105,"object_id":2578,"attachment_id":12153,"attachment":{"id":12153,"key":12153,"name":"0e359fc0-6ed5-38f7-aa03-b7dd2c8bc695","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0e359fc0-6ed5-38f7-aa03-b7dd2c8bc695\/2023_03_01_17_05_40.pdf","orig_name":"2023_03_01_17_05_40.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":1445,"serial_no":"SKD-20230227-00002","wrote_date":"2023-02-27","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":2578,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2023-02-27 17:48:51","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3900","settle_amount":"3900","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-02-27 17:48:51","updated_at":"2023-02-27 17:48:51","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11445","key":"11445","contract_id":2578,"value":"3900","created_by":1014,"collected_date":"2023-02-27 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1353,"key":1353,"contract_id":2578,"value":"3900.00","attachment_id":null,"from_date":"2023-03-03","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1163,"key":1163,"contract_id":2578,"name":"2023-02-27","value":"3900","overdue_days":0,"status":1,"remind_date":"2023-02-27","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":4744,"user_id":5295,"key":5295,"contract_id":2578,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":166,"contract_id":2578,"supplier_id":453,"purchase_id":2579,"supplier":{"id":453,"key":453,"name":"\u5317\u4eac\u7eff\u8272\u82f9\u679c\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2579,"key":2579,"serial_no":"TSKJ20230301-HYF-001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":3900},"projectRemindReceivers":[{"id":422,"user_id":1001,"key":1001,"project_id":3127,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[{"id":2993,"project_id":3127,"product_id":865,"amount":"400","number":1,"cost":"150","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"400","total_cost":"150","erp_sales_order_product_id":29,"supplier":null,"product":{"id":865,"name":"H3C SecPath F1000-AK135","product_type":5,"product_component":26,"product_brand":20,"product_serie":332,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2022-10-24 10:30:36","updated_at":"2024-02-22 14:39:53","pinyin_shortcut":"H3CSecPathF1000AK135","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":20,"key":20,"name":"H3C"},"productSerie":{"id":332,"key":332,"name":"H3C SecPath F1000-AK135\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":29,"erp_sales_order_id":978,"erp_store_id":null,"product_id":865,"description":"","number":"1","outbound":"0","amount":"400","total_amount":"400","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"150","total_cost":"150","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2994,"project_id":3127,"product_id":870,"amount":"1200","number":1,"cost":"874","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"874","erp_sales_order_product_id":30,"supplier":null,"product":{"id":870,"name":"LIS-F1000-AK-AV-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":551,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:46:22","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKAV1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":30,"erp_sales_order_id":978,"erp_store_id":null,"product_id":870,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"874","total_cost":"874","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2995,"project_id":3127,"product_id":868,"amount":"1100","number":1,"cost":"713","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1100","total_cost":"713","erp_sales_order_product_id":31,"supplier":null,"product":{"id":868,"name":"LIS-F1000-AK-URL-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1223,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:45:05","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKURL1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":31,"erp_sales_order_id":978,"erp_store_id":null,"product_id":868,"description":"","number":"1","outbound":"0","amount":"1100","total_amount":"1100","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"713","total_cost":"713","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2996,"project_id":3127,"product_id":867,"amount":"1200","number":1,"cost":"777","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1200","total_cost":"777","erp_sales_order_product_id":32,"supplier":null,"product":{"id":867,"name":"LIS-F1000-AK-IPS-1Y","product_type":5,"product_component":35,"product_brand":20,"product_serie":1222,"product_misc":null,"product_qa":null,"pn":"","description":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\uff08\u4e00\u5e74\u670d\u52a1\uff09","created_by":1013,"created_at":"2022-10-24 10:44:42","updated_at":"2026-07-04 23:56:28","pinyin_shortcut":"LISF1000AKIPS1Y","product_unit":8,"is_renew":false,"in_out_at":"2026-07-04 23:56:28.995218+08","productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":32,"erp_sales_order_id":978,"erp_store_id":null,"product_id":867,"description":"","number":"1","outbound":"0","amount":"1200","total_amount":"1200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"777","total_cost":"777","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2997,"project_id":3127,"product_id":1213,"amount":"0","number":1,"cost":"796.09","description":"\u8d60\u9001","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"796.09","erp_sales_order_product_id":33,"supplier":null,"product":{"id":1213,"name":"\u6d0b\u6cb3\u84dd\u8272\u7ecf\u5178 \u68a6\u4e4b\u84ddM3\uff08 500ml \u00d7 2\uff09","product_type":23,"product_component":194,"product_brand":180,"product_serie":755,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-11 11:50:08","updated_at":"2024-01-11 11:50:08","pinyin_shortcut":"yhlsjdmzlM3500ml2","product_unit":11,"is_renew":false,"in_out_at":null,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":194,"key":194,"name":"\u70df\u9152\u8336\u53f6"},"productBrand":{"id":180,"key":180,"name":"\u6d0b\u6cb3"},"productSerie":{"id":755,"key":755,"name":"\u6d0b\u6cb3\u84dd\u8272\u7ecf\u5178M3 52\u5ea6\u6d53\u9999\u578b\u767d\u9152"},"productUnit":{"id":11,"key":11,"name":"\u74f6"}},"erpSalesOrderProduct":{"id":33,"erp_sales_order_id":978,"erp_store_id":null,"product_id":1213,"description":"\u8d60\u9001","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"796.09","total_cost":"796.09","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3127,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":978,"serial_no":"XSDD-20230227-00001","from_date":null,"wrote_date":"2023-02-27","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":3127,"sales_contract_id":2578,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u534e\u4e09\u9632\u706b\u5899\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-02-27 17:48:51","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"3900","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-02-27 17:13:59","updated_at":"2023-02-27 17:48:51","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1231,"progress_remain_display":1232,"forecast_remain_display":1232,"projectProductTotalAmount":3900,"projectProductAllAmount":true,"projectProductTotalCost":3310.09,"projectProductAllCost":true,"projectProductTotalNumber":5,"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":1,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":"3\u5e74\u524d","can_view_product":true,"budget_display":"3900","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":2972,"client_id":2032,"project_status":3,"project_progress":7,"budget":"84950","profit_pct":"4.47","bargain_date":"2022-09-14","description":"\u7fa4\u6656\u5b58\u50a8","created_by":5295,"created_at":"2022-09-05 11:39:55","updated_at":"2024-01-16 13:59:56","engineer_id":null,"project_title":"\u5b58\u50a8\u65b0\u8d2d","collected":"84950","status_updated_at":"2022-09-15 11:14:23.577222+08","success_rate":null,"comment":"\u7fa4\u6656\u5b58\u50a8\r\n","contract_type":1,"progress_updated_at":"2022-09-15 11:14:23.577222+08","forecast_updated_at":"2022-09-15 11:14:23.577222+08","end_at":"2022-09-16 09:59:24","pinyin_shortcut":"ccxg","creator":5295,"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":84950,"change_status_to":null,"is_verify":false,"profits":"3797.265000000000000000","remain":"1397 days 00:49:02.307709","progress_remain":"1397 days 00:49:02.307709","forecast_remain":"1397 days 00:49:02.307709","lost_contact_days":"1258.83571626078","last_contact":"2023-01-31 16:00:00","last_arrive_days":"1395.84960514966","last_arrive":"2022-09-16 15:40:00+08","duration":"10 days 22:19:28.653052","issued_invoices":"84950.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":2972,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"84950.00","pct":"4.47","profit":"3797.265","project_id":2972}],"salesForecast":{"id":178,"key":178,"name":"90%","description":"\u7b49\u5f85\u7b7e\u7ea6"},"opportunityFrom":{"id":168,"key":168,"name":"\u670b\u53cb\u4ecb\u7ecd"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":2972,"points":"258"},"workLogCount":{"project_id":2972,"count":6},"caseCount":{"project_id":2972,"count":4},"salesTimeCount":{"project_id":2972,"hours":"3.7","times":4},"implementTimeCount":{"project_id":2972,"sum":"6.56666666666667","times":"2"},"presalesTimeCount":{"project_id":2972,"sum":"2.48333333333333","times":"2"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":2972,"sum":"203.35"},"buildContract":{"id":2413,"from_project":2972,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2022091426","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"84950","erp_un_settle_amount":"0","including_tax":true,"amount":"84950","contractScans":[{"id":16234,"object_type":105,"object_id":2413,"attachment_id":11102,"attachment":{"id":11102,"key":11102,"name":"7e4c62f6-ed53-300e-9068-5a6f118bf082","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7e4c62f6-ed53-300e-9068-5a6f118bf082\/\u7075\u72d0\u5408\u540c.pdf","orig_name":"\u7075\u72d0\u5408\u540c.pdf"}}],"receiptScans":[{"id":16399,"object_type":106,"object_id":2413,"attachment_id":11294,"attachment":{"id":11294,"key":11294,"name":"6a6c6a26-c1d3-36e6-9eef-47ba166b71c0","extension":"jpeg","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/6a6c6a26-c1d3-36e6-9eef-47ba166b71c0\/WechatIMG777.jpeg","orig_name":"WechatIMG777.jpeg"}}],"verifyScans":[],"erpCollectTickets":[{"id":885,"serial_no":"SKD-20220916-00003","wrote_date":"2022-09-16","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":2413,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2022-09-16 09:59:24","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"84950","settle_amount":"84950","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2022-09-16 09:59:24","updated_at":"2022-09-16 09:59:24","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1885","key":"1885","contract_id":2413,"value":"84950","created_by":1014,"collected_date":"2022-09-16 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1272,"key":1272,"contract_id":2413,"value":"84950.00","attachment_id":null,"from_date":"2022-09-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1039,"key":1039,"contract_id":2413,"name":"2022-11-30","value":"84950","overdue_days":null,"status":1,"remind_date":"2022-11-30","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":3347,"user_id":5295,"key":5295,"contract_id":2413,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":47,"contract_id":2413,"supplier_id":68,"purchase_id":2420,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2420,"key":2420,"serial_no":"BJ706720220916A01"}},{"id":823,"contract_id":2413,"supplier_id":477,"purchase_id":2430,"supplier":{"id":477,"key":477,"name":"\u601d\u521b\u667a\u5f97(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2430,"key":2430,"serial_no":"SCZD20220926TGSD"}},{"id":1354,"contract_id":2413,"supplier_id":477,"purchase_id":2416,"supplier":{"id":477,"key":477,"name":"\u601d\u521b\u667a\u5f97(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2416,"key":2416,"serial_no":"SCZD20220916TGSD"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":84950},"projectRemindReceivers":[{"id":212,"user_id":1001,"key":1001,"project_id":2972,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":2972,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":909,"serial_no":"XSDD-20220915-00001","from_date":null,"wrote_date":"2022-09-14","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2972,"sales_contract_id":2413,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7fa4\u6656\u5b58\u50a8","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-09-16 09:59:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"84950","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-09-15 11:14:23","updated_at":"2022-09-16 09:59:24","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1397,"progress_remain_display":1397,"forecast_remain_display":1397,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"3\u5e74\u524d","project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":10,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"3\u5e74\u524d","can_view_product":true,"budget_display":"8.5\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]},{"id":2947,"client_id":2032,"project_status":3,"project_progress":10,"budget":"21049","profit_pct":"20.13","bargain_date":"2022-08-16","description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","created_by":5295,"created_at":"2022-08-16 20:43:05","updated_at":"2023-08-28 10:35:07","engineer_id":null,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd2022","collected":"21049","status_updated_at":"2022-08-17 09:37:15.287167+08","success_rate":null,"comment":"\u6df1\u4fe1\u670d\u7eed\u4fdd\r\n","contract_type":2,"progress_updated_at":"2022-08-16 20:43:05.565972+08","forecast_updated_at":"2022-08-16 20:43:05.565972+08","end_at":"2022-08-25 16:44:59","pinyin_shortcut":"sxfACxb2022","creator":5295,"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":21049,"change_status_to":null,"is_verify":false,"profits":"4237.163700000000000000","remain":"1426 days 02:26:10.597764","progress_remain":"1426 days 15:20:20.318959","forecast_remain":"1426 days 15:20:20.318959","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"8 days 20:01:54.409513","issued_invoices":"21049.00","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":null,"client_type":1,"client_class":43,"client_industry":20,"sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"21049","pct":"20.13","profit":"4237.1637","project_id":2947}],"salesForecast":{"id":178,"key":178,"name":"90%","description":"\u7b49\u5f85\u7b7e\u7ea6"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"casePoints":{"project_id":2947,"points":"31"},"workLogCount":null,"caseCount":{"project_id":2947,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":2947,"sum":"2.31861111111111","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":2947,"sum":"16.00"},"buildContract":{"id":2376,"from_project":2947,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-WZW-2022081622","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"21049","erp_un_settle_amount":"0","including_tax":true,"amount":"21049","contractScans":[{"id":15958,"object_type":105,"object_id":2376,"attachment_id":10851,"attachment":{"id":10851,"key":10851,"name":"95ca473a-742a-330f-863c-18a78be2c2ea","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/95ca473a-742a-330f-863c-18a78be2c2ea\/2022_08_22_17_22_54.pdf","orig_name":"2022_08_22_17_22_54.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":1671,"serial_no":"SKD-20220825-00006","wrote_date":"2022-08-17","from_date":null,"handler":5295,"user_id":null,"client_id":2032,"sales_contract_id":2376,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2022-08-25 16:44:59","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"21049","settle_amount":"21049","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2022-08-25 16:44:59","updated_at":"2022-08-25 16:44:59","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11671","key":"11671","contract_id":2376,"value":"21049","created_by":1014,"collected_date":"2022-08-17 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1252,"key":1252,"contract_id":2376,"value":"21049.00","attachment_id":null,"from_date":"2022-08-17","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1023,"key":1023,"contract_id":2376,"name":"2022-08-31","value":"21049","overdue_days":null,"status":1,"remind_date":"2022-08-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":3285,"user_id":5295,"key":5295,"contract_id":2376,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}}],"salesSupplierRels":[{"id":208,"contract_id":2376,"supplier_id":236,"purchase_id":2389,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2389,"key":2389,"serial_no":"TSKJ20220817"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":21049},"projectRemindReceivers":[{"id":162,"user_id":1001,"key":1001,"project_id":2947,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}}],"projectProductRels":[],"commentCount":{"object_id":2947,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":893,"serial_no":"XSDD-20220817-00001","from_date":null,"wrote_date":"2022-08-16","handler":5295,"client_id":2032,"purchase_contract_id":null,"project_id":2947,"sales_contract_id":2376,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6df1\u4fe1\u670d\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-25 16:44:59","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"21049","created_by":5295,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-17 09:37:15","updated_at":"2022-08-25 16:44:59","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1426,"progress_remain_display":1426,"forecast_remain_display":1426,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":8,"contract_type_display":"\u8fd0\u7ef4\u670d\u52a1","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"2.1\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1,"verifyList":[]}],"pagenation":{"totalcount":15,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 12:03:26', 286620928) RETURNING "id"
12:03:26.070	19.9 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "object_id"
12:03:25.948	9.8 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947) GROUP BY "c"."project_id"
12:03:25.963	9.0 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "c"."project_id"
12:03:25.983	3.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430))
12:03:25.972	3.6 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "c"."project_id"
12:03:25.997	3.5 ms	yii\db\Command::query	SELECT "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 (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430) ORDER BY "id" DESC
12:03:25.977	3.3 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "project_id"
12:03:25.988	3.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430))
12:03:25.992	3.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430))
12:03:25.959	2.1 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947) GROUP BY "project_id"
12:03:25.826	2.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
12:03:25.995	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430)) ORDER BY "id" DESC
12:03:25.937	1.2 ms	yii\db\Command::query	SELECT 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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:26.094	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947))
12:03:26.016	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947) ORDER BY "id"
12:03:26.008	1.0 ms	yii\db\Command::query	SELECT "id", "sales_contract_id", "status" FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430) ORDER BY "id" DESC
12:03:25.938	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:25.830	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
12:03:26.002	0.9 ms	yii\db\Command::query	SELECT "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 (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430) ORDER BY "remind_date"
12:03:26.018	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (734, 742, 865, 870, 868, 867, 1213, 1717, 1722, 1719, 1723)
12:03:25.934	0.8 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947) ORDER BY "contribution" DESC, "engineer_id"
12:03:25.980	0.8 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:25.946	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032
12:03:26.001	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430) ORDER BY "id"
12:03:26.005	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430)
12:03:25.958	0.7 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "project_id"
12:03:26.023	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (270, 271, 29, 30, 31, 32, 33, 1128, 1129, 1130, 1131, 741, 742, 743, 1831, 1830, 1547, 1548, 1549, 2204, 2205, 2206)
12:03:25.987	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10851, 11102, 14166, 12153, 20799, 18331, 27465, 24854, 32309)
12:03:26.092	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=3509
12:03:26.090	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:25.962	0.7 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "project_id"
12:03:26.099	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947))
12:03:26.093	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((3509, 3082), (3509, 3936), (3509, 3619), (3509, 3479))
12:03:26.004	0.6 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (2376, 2413, 2762, 2578, 3196, 3451, 3829, 4086, 4430)
12:03:25.928	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032
12:03:25.940	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:26.007	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (68, 453, 236, 477, 681, 686)
12:03:26.008	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2420, 2579, 2389, 2778, 2430, 2416, 2775, 3269, 3454, 4093, 3964, 4435)
12:03:25.930	0.6 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
12:03:25.976	0.6 ms	yii\db\Command::query	SELECT "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 (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)) GROUP BY "project_id"
12:03:25.941	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:26.097	0.6 ms	yii\db\Command::query	SELECT "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 (147, 176)
12:03:26.097	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id" IN (147, 176)
12:03:25.939	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (184, 189, 226, 140, 5, 2, 1, 160, 197, 199, 136, 164, 179, 181, 196, 204, 185, 191, 178, 168, 192, 340, 348, 349, 369, 377, 142)) ORDER BY "sort"
12:03:25.944	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
12:03:26.010	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893) ORDER BY "id"
12:03:26.096	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:26.014	0.5 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (4130, 3800, 3936, 3861, 3479, 3082, 3619, 3127, 2972, 2947)
12:03:26.022	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1457, 1456, 1458, 1020, 332, 1220, 755, 1455, 1222, 551, 1223)
12:03:25.936	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (6, 4, 9, 5, 7, 10)
12:03:26.013	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893) ORDER BY "id"
12:03:26.020	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (208, 189, 200, 26, 19, 194, 35)
12:03:25.935	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5)
12:03:26.020	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (22, 5, 4, 23)
12:03:26.021	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (12, 20, 180)
12:03:26.012	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1688, 1563, 1460, 1313, 1209, 1061, 978, 909, 893) ORDER BY "id"
12:03:25.932	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43
12:03:25.930	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
12:03:25.931	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1
12:03:26.022	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 8, 1, 11)
12:03:25.825	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:03:25.933	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
12:03:26.001	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013, 5388)
12:03:25.932	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=20
12:03:26.098	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id" IN (147, 176)
12:03:26.011	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:03:25.991	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11294, 14181, 18373, 21105, 24874, 27797, 32492)
12:03:26.099	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id" IN (147, 176)
12:03:25.941	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (184, 189, 226, 140, 5, 2, 1, 160, 197, 199, 136, 164, 179, 181, 196, 204, 185, 191, 178, 168, 192, 340, 348, 349, 369, 377, 142)) ORDER BY "sort"
12:03:26.093	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2032
12:03:25.942	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (184, 189, 226, 140, 5, 2, 1, 160, 197, 199, 136, 164, 179, 181, 196, 204, 185, 191, 178, 168, 192, 340, 348, 349, 369, 377, 142)) ORDER BY "sort"
12:03:25.944	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
12:03:26.004	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1001)
12:03:26.018	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (236, 146)
12:03:26.005	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1001))
12:03:26.011	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
12:03:25.943	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
12:03:26.013	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:03:26.015	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
12:03:26.015	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 1001))
12:03:25.945	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
12:03:25.947	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
12:03:26.013	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
12:03:25.945	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
12:03:25.947	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)