Performance Profiling

Total processing time: 245 ms; Peak memory: 7.712 MB. Show Profiling Timeline

总计73条数据

Time	Duration	Category	Info

13:11:40.807	52.8 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "object_id"
13:11:40.860	24.2 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "object_id"
13:11:40.697	17.2 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.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=48) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10 OFFSET 10
13:11:40.682	14.2 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.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=1000) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) AND ("p"."client_id"=48) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c"
13:11:40.736	8.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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906) GROUP BY "c"."project_id"
13:11:40.750	8.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(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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "c"."project_id"
13:11:40.899	6.4 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/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"48","page":"2","token":"5da72fe8f6c52f1b758bbfdce83ad88e","posttime":"1783919500","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":3498,"client_id":48,"project_status":3,"project_progress":10,"budget":"950","profit_pct":"57.53","bargain_date":"2024-04-15","description":"","created_by":1004,"created_at":"2024-04-14 15:56:49","updated_at":"2024-10-17 14:53:38","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u786c\u76d8300GB","collected":"950","status_updated_at":"2024-04-15 09:55:16.664185+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-04-15 09:54:44.182243+08","forecast_updated_at":"2024-04-15 09:54:44.182243+08","end_at":"2024-05-20 17:33:21","pinyin_shortcut":"fwqyp300GB","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":334,"is_sales_order_ready":true,"collected_plan":950,"change_status_to":null,"is_verify":false,"profits":"546.535000000000000000","remain":"819 days 03:16:24.034249","progress_remain":"819 days 03:16:56.516191","forecast_remain":"819 days 03:16:56.516191","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"36 days 01:36:32.027906","issued_invoices":"950.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3498,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"950.00","pct":"57.53","profit":"546.535","project_id":3498}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3498,"points":"26"},"workLogCount":null,"caseCount":{"project_id":3498,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":3498,"sum":"3.78333333333333","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3498,"sum":"376.77"},"buildContract":{"id":3228,"from_project":3498,"payment_collection_remind_ahead":null,"serial_no":"TS-YJC-2024041501","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"950","erp_un_settle_amount":"0","including_tax":true,"amount":"950","contractScans":[{"id":25538,"object_type":105,"object_id":3228,"attachment_id":18637,"attachment":{"id":18637,"key":18637,"name":"fac0252f-40a8-3030-af01-f6eb514109ed","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/fac0252f-40a8-3030-af01-f6eb514109ed\/2024_04_16_09_42_11.pdf","orig_name":"2024_04_16_09_42_11.pdf"}}],"receiptScans":[{"id":25148,"object_type":106,"object_id":3228,"attachment_id":18638,"attachment":{"id":18638,"key":18638,"name":"2c97374d-aea4-352d-9065-248babaa4967","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/2c97374d-aea4-352d-9065-248babaa4967\/2024_04_16_09_42_20.pdf","orig_name":"2024_04_16_09_42_20.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1833,"serial_no":"SKD-20240520-00002","wrote_date":"2024-05-20","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3228,"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-05-20 17:33:21","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"950","settle_amount":"950","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-05-20 17:33:21","updated_at":"2024-05-20 17:33:21","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11833","key":"11833","contract_id":3228,"value":"950","created_by":1013,"collected_date":"2024-05-20 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1632,"key":1632,"contract_id":3228,"value":"950.00","attachment_id":null,"from_date":"2024-04-15","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":2159,"key":2159,"contract_id":3228,"name":"2024-05-20","value":"950","overdue_days":0,"status":1,"remind_date":"2024-05-20","pct":100,"overdue_display":"\u903e\u671f0\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":7116,"user_id":1004,"key":1004,"contract_id":3228,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1458,"contract_id":3228,"supplier_id":81,"purchase_id":3267,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"purchase":{"id":3267,"key":3267,"serial_no":"20240411"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":950},"projectRemindReceivers":[],"projectProductRels":[{"id":4534,"project_id":3498,"product_id":1557,"amount":"950","number":1,"cost":"300","description":"","supplier_id":81,"hardware_from":"2024-04-15","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-14","software_to":null,"maintenance_to":null,"total_amount":"950","total_cost":"300","erp_sales_order_product_id":788,"supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"product":{"id":1557,"name":"42D0613","product_type":2,"product_component":5,"product_brand":4,"product_serie":1191,"product_misc":null,"product_qa":null,"pn":"","description":"300GB 10K 6Gb SAS ","created_by":1013,"created_at":"2024-04-15 09:14:51","updated_at":"2024-04-15 09:14:51","pinyin_shortcut":"42D0613","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1191,"key":1191,"name":"300G 10K 2.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":788,"erp_sales_order_id":1219,"erp_store_id":null,"product_id":1557,"description":"","number":"1","outbound":"0","amount":"950","total_amount":"950","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"300","total_cost":"300","supplier_id":81,"hardware_from":"2024-04-15","software_from":null,"maintenance_from":null,"hardware_to":"2025-04-14","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3498,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1219,"serial_no":"XSDD-20240415-00001","from_date":null,"wrote_date":"2024-04-15","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3498,"sales_contract_id":3228,"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-20 17:33:21","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"1","amount":"950","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-04-15 09:55:16","updated_at":"2024-05-20 17:33:21","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":819,"progress_remain_display":819,"forecast_remain_display":819,"projectProductTotalAmount":950,"projectProductAllAmount":true,"projectProductTotalCost":300,"projectProductAllCost":true,"projectProductTotalNumber":1,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":36,"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":"950","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3484,"client_id":48,"project_status":3,"project_progress":7,"budget":"12950","profit_pct":"18.49","bargain_date":"2024-04-02","description":"","created_by":1004,"created_at":"2024-03-27 17:41:21","updated_at":"2024-05-30 11:11:28","engineer_id":null,"project_title":"\u7fa4\u6656\u53ca\u66f4\u6362\u786c\u76d8\u9879\u76ee","collected":"12950","status_updated_at":"2024-03-27 17:42:07.081839+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-03-27 17:41:21.122101+08","forecast_updated_at":"2024-03-27 17:41:21.122101+08","end_at":"2024-05-20 17:33:52","pinyin_shortcut":"qhjghypxm","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":314,"is_sales_order_ready":true,"collected_plan":12950,"change_status_to":null,"is_verify":false,"profits":"2394.455000000000000000","remain":"837 days 19:29:33.616595","progress_remain":"837 days 19:30:19.576333","forecast_remain":"837 days 19:30:19.576333","lost_contact_days":"811.149776602245","last_contact":"2024-04-23 09:36:00","last_arrive_days":null,"last_arrive":null,"duration":"53 days 23:52:31.504552","issued_invoices":"12950.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3484,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"12950.00","pct":"18.49","profit":"2394.455","project_id":3484}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3484,"points":"337"},"workLogCount":{"project_id":3484,"count":1},"caseCount":{"project_id":3484,"count":5},"salesTimeCount":null,"implementTimeCount":{"project_id":3484,"sum":"15.8147222222222","times":"5"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3484,"sum":"388.92"},"buildContract":{"id":3208,"from_project":3484,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2024040201","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"12950","erp_un_settle_amount":"0","including_tax":true,"amount":"12950","contractScans":[{"id":25539,"object_type":105,"object_id":3208,"attachment_id":18969,"attachment":{"id":18969,"key":18969,"name":"989b0f1b-10bb-3408-9ef7-6d95687e216d","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/989b0f1b-10bb-3408-9ef7-6d95687e216d\/2024_05_07_14_37_39.pdf","orig_name":"2024_05_07_14_37_39.pdf"}}],"receiptScans":[{"id":25476,"object_type":106,"object_id":3208,"attachment_id":18933,"attachment":{"id":18933,"key":18933,"name":"47b99e86-5a73-3631-b425-c4f5d7452733","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/47b99e86-5a73-3631-b425-c4f5d7452733\/2024_05_06_09_49_38.pdf","orig_name":"2024_05_06_09_49_38.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1731,"serial_no":"SKD-20240520-00001","wrote_date":"2024-05-20","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":3208,"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-05-20 17:33:52","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"12950","settle_amount":"12950","created_by":1013,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2024-05-20 17:33:52","updated_at":"2024-05-20 17:33:52","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11731","key":"11731","contract_id":3208,"value":"12950","created_by":1013,"collected_date":"2024-05-20 00:00:00","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":100}],"salesContractInvoices":[{"id":1644,"key":1644,"contract_id":3208,"value":"12950.00","attachment_id":null,"from_date":"2024-04-29","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1593,"key":1593,"contract_id":3208,"name":"2024-05-31","value":"12950","overdue_days":null,"status":1,"remind_date":"2024-05-31","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":5055,"user_id":1004,"key":1004,"contract_id":3208,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":45,"contract_id":3208,"supplier_id":530,"purchase_id":3211,"supplier":{"id":530,"key":530,"name":"\u5317\u4eac\u4e2d\u521b\u667a\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3211,"key":3211,"serial_no":"HXYY-2024\/3\/27"}},{"id":1048,"contract_id":3208,"supplier_id":489,"purchase_id":3268,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3268,"key":3268,"serial_no":""}},{"id":1192,"contract_id":3208,"supplier_id":59,"purchase_id":3223,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":3223,"key":3223,"serial_no":"TGXC20240311-1"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":12950},"projectRemindReceivers":[],"projectProductRels":[{"id":4535,"project_id":3484,"product_id":41,"amount":"1000","number":2,"cost":"500","description":"","supplier_id":489,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-28","software_to":null,"maintenance_to":null,"total_amount":"2000","total_cost":"1000","erp_sales_order_product_id":769,"supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":769,"erp_sales_order_id":1216,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"0","amount":"1000","total_amount":"2000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"500","total_cost":"1000","supplier_id":489,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-28","software_to":null,"maintenance_to":null}},{"id":4536,"project_id":3484,"product_id":1536,"amount":"1050","number":1,"cost":"550","description":"","supplier_id":59,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-28","software_to":null,"maintenance_to":null,"total_amount":"1050","total_cost":"550","erp_sales_order_product_id":770,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"product":{"id":1536,"name":"601713-001","product_type":3,"product_component":15,"product_brand":2,"product_serie":1326,"product_misc":null,"product_qa":null,"pn":"","description":"HP P2000 2TB 3G DP SATA 7.2K 3.5 \u786c\u76d8","created_by":1013,"created_at":"2024-03-28 10:15:56","updated_at":"2024-03-28 10:15:56","pinyin_shortcut":"601713001","product_unit":null,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":1326,"key":1326,"name":"HP P2000 2TB 3G DP SATA 7.2K 3.5 \u786c\u76d8"},"productUnit":null},"erpSalesOrderProduct":{"id":770,"erp_sales_order_id":1216,"erp_store_id":null,"product_id":1536,"description":"","number":"1","outbound":"0","amount":"1050","total_amount":"1050","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"550","total_cost":"550","supplier_id":59,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2025-03-28","software_to":null,"maintenance_to":null}},{"id":4537,"project_id":3484,"product_id":972,"amount":"4950","number":2,"cost":"4090","description":"","supplier_id":530,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2027-03-28","software_to":null,"maintenance_to":null,"total_amount":"9900","total_cost":"8180","erp_sales_order_product_id":771,"supplier":{"id":530,"key":530,"name":"\u5317\u4eac\u4e2d\u521b\u667a\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":972,"name":"DS923+","product_type":3,"product_component":14,"product_brand":27,"product_serie":857,"product_misc":null,"product_qa":null,"pn":"","description":"4 \u69fd\u5f0f NAS\uff0cAMD Ryzen\u2122 R1600 \u53cc\u6838\uff084 \u7ebf\u7a0b\uff09\uff0c\u65f6\u949f\u63d0\u5347\u4e0a\u9650\u4e3a 3.1 GHz\uff0c\u5185\u5b58\uff1a4 GB DDR4 ECC SODIMM\uff08\u53ef\u6269\u5145\u5230 32 GB\uff09\uff0c4 x 3.5 \u82f1\u5bf8\u6216 2.5 \u82f1\u5bf8 SATA HDD\/SSD\uff08\u4e0d\u542b\u786c\u76d8\uff092 x M.2 2280 NVMe SSD\uff08\u4e0d\u542b\u786c\u76d8\uff09\uff0c\u70ed\u63d2\u62d4\u786c\u76d8\uff0c\u5916\u7aef\u63a5\u53e3\uff1a2 x USB 3.2 \u7b2c 1 \u4ee3\u7aef\u53e3\u548c1 x \u6269\u5145\u7aef\u53e3 (eSATA\uff09\uff0c3\u5e74\u4fdd\u4fee\uff1b\u4e0d\u542b\u786c\u76d8","created_by":1013,"created_at":"2023-08-04 17:33:20","updated_at":"2024-03-28 10:14:31","pinyin_shortcut":"DS923","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":857,"key":857,"name":"DS923+ NAS\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":771,"erp_sales_order_id":1216,"erp_store_id":null,"product_id":972,"description":"","number":"2","outbound":"0","amount":"4950","total_amount":"9900","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4090","total_cost":"8180","supplier_id":530,"hardware_from":"2024-03-28","software_from":null,"maintenance_from":null,"hardware_to":"2027-03-28","software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3484,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1216,"serial_no":"XSDD-20240327-00001","from_date":null,"wrote_date":"2024-04-02","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3484,"sales_contract_id":3208,"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-20 17:33:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"5","amount":"12950","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2024-03-27 17:42:07","updated_at":"2024-05-20 17:33:52","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":837,"progress_remain_display":837,"forecast_remain_display":837,"projectProductTotalAmount":12950,"projectProductAllAmount":true,"projectProductTotalCost":9730,"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":53,"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":"1.3\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3215,"client_id":48,"project_status":3,"project_progress":9,"budget":"110000","profit_pct":"21.55","bargain_date":"2023-07-31","description":"PA850\u5b89\u5168\u4ea7\u54c1\uff0c\u7eed\u4fdd\u670d\u52a1","created_by":1004,"created_at":"2023-05-29 14:08:22","updated_at":"2024-05-09 14:25:05","engineer_id":null,"project_title":"\u5b89\u5168\u4ea7\u54c1\u7eed\u4fdd\u670d\u52a1-K","collected":"110000","status_updated_at":"2023-08-04 18:13:03.023592+08","success_rate":null,"comment":"PA850\u5b89\u5168\u4ea7\u54c1\uff0c\u7eed\u4fdd\u670d\u52a1\r\n","contract_type":2,"progress_updated_at":"2023-08-04 18:13:20.183038+08","forecast_updated_at":"2023-06-18 20:34:45.899393+08","end_at":"2023-08-16 11:23:21","pinyin_shortcut":"aqcpxbfwK","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":222,"is_sales_order_ready":true,"collected_plan":110000,"change_status_to":null,"is_verify":false,"profits":"23705.000000000000000000","remain":"1073 days 18:58:37.674842","progress_remain":"1073 days 18:58:20.515396","forecast_remain":"1120 days 16:36:54.799041","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"78 days 21:14:58.730807","issued_invoices":"110000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3215,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"110000","pct":"21.55","profit":"23705","project_id":3215}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3215,"points":"538"},"workLogCount":null,"caseCount":{"project_id":3215,"count":6},"salesTimeCount":null,"implementTimeCount":{"project_id":3215,"sum":"13.2833333333333","times":"5"},"presalesTimeCount":{"project_id":3215,"sum":"3","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3215,"sum":"315.82"},"buildContract":{"id":2789,"from_project":3215,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023073148","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"110000","erp_un_settle_amount":"0","including_tax":true,"amount":"110000","contractScans":[{"id":23740,"object_type":105,"object_id":2789,"attachment_id":14228,"attachment":{"id":14228,"key":14228,"name":"0d088c41-8036-37c5-8c1f-ab9854e5924d","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0d088c41-8036-37c5-8c1f-ab9854e5924d\/2023_08_03_15_17_00.pdf","orig_name":"2023_08_03_15_17_00.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":959,"serial_no":"SKD-20230816-00001","wrote_date":"2023-08-16","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2789,"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-08-16 11:23:21","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"110000","settle_amount":"110000","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-08-16 11:23:21","updated_at":"2023-08-16 11:23:21","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1959","key":"1959","contract_id":2789,"value":"110000","created_by":1014,"collected_date":"2023-08-16 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1455,"key":1455,"contract_id":2789,"value":"110000.00","attachment_id":null,"from_date":"2023-08-08","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1305,"key":1305,"contract_id":2789,"name":"2023-09-30","value":"110000","overdue_days":null,"status":1,"remind_date":"2023-09-30","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":4795,"user_id":1004,"key":1004,"contract_id":2789,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1110,"contract_id":2789,"supplier_id":68,"purchase_id":2810,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2810,"key":2810,"serial_no":"30-62731-11"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":110000},"projectRemindReceivers":[],"projectProductRels":[{"id":3207,"project_id":3215,"product_id":289,"amount":"15000","number":2,"cost":"10385","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"30000","total_cost":"20770","erp_sales_order_product_id":303,"supplier":null,"product":{"id":289,"name":"PAN-SVC-BKLN-850","product_type":5,"product_component":35,"product_brand":8,"product_serie":210,"product_misc":5,"product_qa":2,"pn":"","description":"Partner enabled premium support year 1, PA-850","created_by":1013,"created_at":"2017-09-28 16:03:37","updated_at":"2024-01-12 14:30:43","pinyin_shortcut":"PANSVCBKLN850","product_unit":8,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":210,"key":210,"name":"PA850\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":303,"erp_sales_order_id":1074,"erp_store_id":null,"product_id":289,"description":"","number":"2","outbound":"0","amount":"15000","total_amount":"30000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"10385","total_cost":"20770","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3208,"project_id":3215,"product_id":1354,"amount":"20000","number":2,"cost":"13646","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"40000","total_cost":"27292","erp_sales_order_product_id":304,"supplier":null,"product":{"id":1354,"name":"PAN-PA-850-TP-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"Threat prevention subscription for device in an HA pair year 1, PA-850\n","created_by":1013,"created_at":"2024-01-26 13:48:15","updated_at":"2024-01-26 13:52:20","pinyin_shortcut":"PANPA850TPHA2R","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":304,"erp_sales_order_id":1074,"erp_store_id":null,"product_id":1354,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"13646","total_cost":"27292","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3209,"project_id":3215,"product_id":1355,"amount":"20000","number":2,"cost":"13647","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"40000","total_cost":"27294","erp_sales_order_product_id":305,"supplier":null,"product":{"id":1355,"name":"PAN-PA-850-WF-HA2-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1026,"product_misc":null,"product_qa":null,"pn":"","description":"WildFire subscription for device in an HA pair year 1, PA-850","created_by":1013,"created_at":"2024-01-26 13:48:45","updated_at":"2024-01-26 13:48:45","pinyin_shortcut":"PANPA850WFHA2R","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1026,"key":1026,"name":"PA850\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":305,"erp_sales_order_id":1074,"erp_store_id":null,"product_id":1355,"description":"","number":"2","outbound":"0","amount":"20000","total_amount":"40000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"13647","total_cost":"27294","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3215,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1074,"serial_no":"XSDD-20230804-00002","from_date":null,"wrote_date":"2023-07-31","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3215,"sales_contract_id":2789,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"PA850\u5b89\u5168\u4ea7\u54c1\uff0c\u7eed\u4fdd\u670d\u52a1","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-08-16 11:23:21","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"6","amount":"110000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-08-04 18:13:03","updated_at":"2023-08-16 11:23:21","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1073,"progress_remain_display":1073,"forecast_remain_display":1120,"projectProductTotalAmount":110000,"projectProductAllAmount":true,"projectProductTotalCost":75356,"projectProductAllCost":true,"projectProductTotalNumber":6,"unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","can_invoice":true,"can_payment":true,"duration_display":78,"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":"11\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3231,"client_id":48,"project_status":3,"project_progress":9,"budget":"50404.1","profit_pct":"73.93","bargain_date":"2023-07-12","description":"Vmware+netapp+\u670d\u52a1\u5668\u7b49\u8fd0\u7ef4\u670d\u52a1\u3002\n\u4e0eTS-YJC-2023062103-2\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","created_by":1004,"created_at":"2023-06-18 20:44:40","updated_at":"2024-07-26 13:40:43","engineer_id":null,"project_title":"2023\u5e74\u8fd0\u7ef4\u670d\u52a1G","collected":"50404.1","status_updated_at":"2023-07-16 18:43:00.673285+08","success_rate":null,"comment":"Vmware+netapp+\u670d\u52a1\u5668\u7b49\u8fd0\u7ef4\u670d\u52a1\u3002\n\u4e0eTS-YJC-2023062103-2\u4e3a\u540c\u4e00\u4e2a\u5408\u540c\r\n","contract_type":2,"progress_updated_at":"2023-07-16 18:43:00.673285+08","forecast_updated_at":"2023-07-16 18:43:00.673285+08","end_at":"2023-07-28 15:13:19","pinyin_shortcut":"2023nywfwG","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":237,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"37263.751130000000000000","remain":"1092 days 18:28:40.025149","progress_remain":"1092 days 18:28:40.025149","forecast_remain":"1092 days 18:28:40.025149","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"39 days 18:28:39.599929","issued_invoices":"50404.10","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3231,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":"50404.10","pct":"73.93","profit":"37263.75113","project_id":3231}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3231,"points":"1412"},"workLogCount":null,"caseCount":{"project_id":3231,"count":23},"salesTimeCount":null,"implementTimeCount":{"project_id":3231,"sum":"45.5666666666667","times":"22"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3231,"sum":"1192.08"},"buildContract":{"id":2741,"from_project":3231,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023062103-1","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"50404.1","erp_un_settle_amount":"0","including_tax":true,"amount":"50404.1","contractScans":[{"id":23332,"object_type":105,"object_id":2741,"attachment_id":13996,"attachment":{"id":13996,"key":13996,"name":"3a4bcd54-2f7e-3f7f-b50e-9cf53d77f8d4","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/3a4bcd54-2f7e-3f7f-b50e-9cf53d77f8d4\/2023_07_19_13_41_33.pdf","orig_name":"2023_07_19_13_41_33.pdf"}}],"receiptScans":[{"id":19425,"object_type":106,"object_id":2741,"attachment_id":13875,"attachment":{"id":13875,"key":13875,"name":"7758e2f9-935b-3bd4-9f5b-08b084a82a6c","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/7758e2f9-935b-3bd4-9f5b-08b084a82a6c\/\u4e2d\u90fd\u7b7e\u6536\u5355.pdf","orig_name":"\u4e2d\u90fd\u7b7e\u6536\u5355.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":708,"serial_no":"SKD-20230728-00001","wrote_date":"2023-07-28","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2741,"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-28 15:13:19","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"50404.1","settle_amount":"50404.1","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-07-28 15:13:19","updated_at":"2023-07-28 15:13:19","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1708","key":"1708","contract_id":2741,"value":"50404.1","created_by":1014,"collected_date":"2023-07-28 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1428,"key":1428,"contract_id":2741,"value":"50404.10","attachment_id":null,"from_date":"2023-07-11","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4558,"user_id":1004,"key":1004,"contract_id":2741,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":135,"contract_id":2741,"supplier_id":116,"purchase_id":2952,"supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchase":{"id":2952,"key":2952,"serial_no":"TSKJ20231121-HYF-001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":50404.1},"projectRemindReceivers":[],"projectProductRels":[{"id":3327,"project_id":3231,"product_id":941,"amount":"21157.6","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"21157.6","total_cost":"0","erp_sales_order_product_id":228,"supplier":null,"product":{"id":941,"name":"\u62d3\u5b9e\u4eba\u5de5\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":133,"product_serie":592,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:29:24","updated_at":"2026-02-05 16:37:56","pinyin_shortcut":"tsrgjsfw","product_unit":7,"is_renew":false,"in_out_at":"2026-02-05 16:37:56.557723+08","productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":133,"key":133,"name":"\u62d3\u5b9e"},"productSerie":{"id":592,"key":592,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}},"erpSalesOrderProduct":{"id":228,"erp_sales_order_id":1049,"erp_store_id":null,"product_id":941,"description":"","number":"1","outbound":"0","amount":"21157.6","total_amount":"21157.6","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"0","total_cost":"0","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3328,"project_id":3231,"product_id":41,"amount":"1600","number":2,"cost":"900","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3200","total_cost":"1800","erp_sales_order_product_id":229,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":229,"erp_sales_order_id":1049,"erp_store_id":null,"product_id":41,"description":"","number":"2","outbound":"0","amount":"1600","total_amount":"3200","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"900","total_cost":"1800","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3329,"project_id":3231,"product_id":41,"amount":"0","number":2,"cost":"450","description":"\u552e\u540e\u7ef4\u4fdd","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":"900","erp_sales_order_product_id":230,"supplier":null,"product":{"id":41,"name":"X423A-R5","product_type":3,"product_component":15,"product_brand":6,"product_serie":1015,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-02-16 12:06:10","updated_at":"2026-01-06 11:47:31","pinyin_shortcut":"X423AR5","product_unit":4,"is_renew":false,"in_out_at":"2026-01-06 11:47:31.374476+08","productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":6,"key":6,"name":"NetApp"},"productSerie":{"id":1015,"key":1015,"name":"900G 10K 2.5 SAS\u5b58\u50a8\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":230,"erp_sales_order_id":1049,"erp_store_id":null,"product_id":41,"description":"\u552e\u540e\u7ef4\u4fdd","number":"2","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"450","total_cost":"900","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3330,"project_id":3231,"product_id":298,"amount":"0","number":1,"cost":"500","description":"\u552e\u540e\u7ef4\u4fdd","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":"500","erp_sales_order_product_id":231,"supplier":null,"product":{"id":298,"name":"32GB PC4-2400P\u5185\u5b58","product_type":2,"product_component":4,"product_brand":3,"product_serie":27,"product_misc":4,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-11-03 10:11:58","updated_at":"2024-01-12 11:12:38","pinyin_shortcut":"32GBPC42400Pnc","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":3,"key":3,"name":"\u601d\u79d1"},"productSerie":{"id":27,"key":27,"name":"32GB PC4-2400P\u5185\u5b58"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":231,"erp_sales_order_id":1049,"erp_store_id":null,"product_id":298,"description":"\u552e\u540e\u7ef4\u4fdd","number":"1","outbound":"0","amount":"0","total_amount":"0","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"500","total_cost":"500","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3331,"project_id":3231,"product_id":1376,"amount":"5209.3","number":5,"cost":"1500","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"26046.5","total_cost":"7500","erp_sales_order_product_id":232,"supplier":null,"product":{"id":1376,"name":"CBSOMA11M","product_type":2,"product_component":13,"product_brand":4,"product_serie":1052,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3\u539f\u5382\u4e00\u5e7459\u670d\u52a1","created_by":1001,"created_at":"2024-01-26 17:55:26","updated_at":"2025-10-29 17:37:40","pinyin_shortcut":"CBSOMA11M","product_unit":8,"is_renew":false,"in_out_at":"2025-10-29 17:37:40.337224+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":13,"key":13,"name":"\u670d\u52a1\u5668\u91d1\u724c\u670d\u52a1"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1052,"key":1052,"name":"SR650\u670d\u52a1\u5668\u4e00\u5e7459\u539f\u5382\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":232,"erp_sales_order_id":1049,"erp_store_id":null,"product_id":1376,"description":"","number":"5","outbound":"0","amount":"5209.3","total_amount":"26046.5","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1500","total_cost":"7500","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3231,"comment":5},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1049,"serial_no":"XSDD-20230712-00001","from_date":null,"wrote_date":"2023-07-12","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3231,"sales_contract_id":2741,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"Vmware+netapp+\u670d\u52a1\u5668\u7b49\u8fd0\u7ef4\u670d\u52a1\u3002\n\u4e0eTS-YJC-2023062103-2\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-28 15:13:19","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"11","amount":"50404.1","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-12 14:15:37","updated_at":"2023-07-28 15:13:19","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1092,"progress_remain_display":1092,"forecast_remain_display":1092,"projectProductTotalAmount":50404.1,"projectProductAllAmount":true,"projectProductTotalCost":10700,"projectProductAllCost":true,"projectProductTotalNumber":11,"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":39,"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":"5.04\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3141,"client_id":48,"project_status":3,"project_progress":10,"budget":"3000","profit_pct":"43.45","bargain_date":"2023-07-12","description":"HP 2T sata\u786c\u76d8\u00d72\n\u4e0eTS-YJC-2023062103-1\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","created_by":1004,"created_at":"2023-03-09 09:52:31","updated_at":"2024-01-26 17:50:31","engineer_id":null,"project_title":"P2000\u786c\u76d8\u6269\u5bb9","collected":"3000","status_updated_at":"2023-03-09 10:03:45.079641+08","success_rate":null,"comment":"HP 2T sata\u786c\u76d8\u00d72\n\u4e0eTS-YJC-2023062103-1\u4e3a\u540c\u4e00\u4e2a\u5408\u540c\r\n","contract_type":1,"progress_updated_at":"2023-03-09 09:52:31.295773+08","forecast_updated_at":"2023-03-09 09:52:31.295773+08","end_at":"2023-07-28 15:13:34","pinyin_shortcut":"P2000ypkr","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":17,"is_sales_order_ready":true,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"1303.500000000000000000","remain":"1222 days 03:07:55.618793","progress_remain":"1222 days 03:19:09.402661","forecast_remain":"1222 days 03:19:09.402661","lost_contact_days":"1222.08797104669","last_contact":"2023-03-09 11:05:00","last_arrive_days":null,"last_arrive":null,"duration":"141 days 05:21:03.233055","issued_invoices":"3000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3141,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"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":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"3000","pct":"43.45","profit":"1303.5","project_id":3141}],"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":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3141,"points":"25"},"workLogCount":{"project_id":3141,"count":1},"caseCount":{"project_id":3141,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3141,"sum":"1.03333333333333","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3141,"sum":"139.47"},"buildContract":{"id":2584,"from_project":3141,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023062103-2","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"3000","erp_un_settle_amount":"0","including_tax":true,"amount":"3000","contractScans":[{"id":23337,"object_type":105,"object_id":2584,"attachment_id":13997,"attachment":{"id":13997,"key":13997,"name":"e10186f8-665e-307f-bb8f-21506b44c1a6","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e10186f8-665e-307f-bb8f-21506b44c1a6\/2023_07_19_13_41_33.pdf","orig_name":"2023_07_19_13_41_33.pdf"}}],"receiptScans":[{"id":17533,"object_type":106,"object_id":2584,"attachment_id":12217,"attachment":{"id":12217,"key":12217,"name":"dd4fe944-bdfc-343e-8040-cbca731618af","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/dd4fe944-bdfc-343e-8040-cbca731618af\/2023_03_13_10_03_28.pdf","orig_name":"2023_03_13_10_03_28.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1685,"serial_no":"SKD-20230728-00003","wrote_date":"2023-07-28","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2584,"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-28 15:13:34","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3000","settle_amount":"3000","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-07-28 15:13:34","updated_at":"2023-07-28 15:13:34","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11685","key":"11685","contract_id":2584,"value":"3000","created_by":1014,"collected_date":"2023-07-28 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1430,"key":1430,"contract_id":2584,"value":"3000.00","attachment_id":null,"from_date":"2023-07-11","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":4563,"user_id":1004,"key":1004,"contract_id":2584,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1316,"contract_id":2584,"supplier_id":59,"purchase_id":2629,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2629,"key":2629,"serial_no":"TGXC20230306-1"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":3000},"projectRemindReceivers":[],"projectProductRels":[{"id":2484,"project_id":3141,"product_id":468,"amount":"1500","number":2,"cost":"650","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"3000","total_cost":"1300","erp_sales_order_product_id":39,"supplier":null,"product":{"id":468,"name":"AW590A","product_type":2,"product_component":5,"product_brand":2,"product_serie":903,"product_misc":8,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2018-11-08 10:35:46","updated_at":"2024-01-18 17:38:16","pinyin_shortcut":"AW590A","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":2,"key":2,"name":"HP"},"productSerie":{"id":903,"key":903,"name":"2TB 7.2K 3.5 SAS \u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":39,"erp_sales_order_id":982,"erp_store_id":null,"product_id":468,"description":"","number":"2","outbound":"0","amount":"1500","total_amount":"3000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"650","total_cost":"1300","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3141,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":982,"serial_no":"XSDD-20230309-00001","from_date":null,"wrote_date":"2023-07-12","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3141,"sales_contract_id":2584,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"HP 2T sata\u786c\u76d8\u00d72\n\u4e0eTS-YJC-2023062103-1\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-28 15:13:34","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"2","amount":"3000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-03-09 10:03:45","updated_at":"2023-07-28 15:13:34","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1222,"progress_remain_display":1222,"forecast_remain_display":1222,"projectProductTotalAmount":3000,"projectProductAllAmount":true,"projectProductTotalCost":1300,"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":141,"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":"3000","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3254,"client_id":48,"project_status":3,"project_progress":9,"budget":"23951","profit_pct":"27.59","bargain_date":"2023-07-10","description":"\u6df1\u4fe1\u670dEDR\u5b89\u5168\u4ea7\u54c1\u7eed\u4fdd","created_by":1004,"created_at":"2023-07-14 10:56:42","updated_at":"2024-02-22 11:57:59","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u4ea7\u54c1\u7eed\u4fdd","collected":"23951","status_updated_at":"2023-07-16 18:41:20.33806+08","success_rate":null,"comment":"\u6df1\u4fe1\u670dEDR\u5b89\u5168\u4ea7\u54c1\u7eed\u4fdd\r\n","contract_type":2,"progress_updated_at":"2023-07-16 18:41:20.33806+08","forecast_updated_at":"2023-07-16 18:41:20.33806+08","end_at":"2023-07-25 09:49:18","pinyin_shortcut":"sxfcpxb","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":15,"is_sales_order_ready":false,"collected_plan":23951,"change_status_to":null,"is_verify":false,"profits":"6608.080900000000000000","remain":"1092 days 18:30:20.360374","progress_remain":"1092 days 18:30:20.360374","forecast_remain":"1092 days 18:30:20.360374","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"10 days 22:52:36.211957","issued_invoices":"23951.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[{"project_id":3254,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"23951.00","pct":"27.59","profit":"6608.0809","project_id":3254}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3254,"points":"31"},"workLogCount":null,"caseCount":{"project_id":3254,"count":1},"salesTimeCount":null,"implementTimeCount":{"project_id":3254,"sum":"8","times":"1"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2749,"from_project":3254,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023071003","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"23951","erp_un_settle_amount":"0","including_tax":true,"amount":"23951","contractScans":[{"id":23335,"object_type":105,"object_id":2749,"attachment_id":13925,"attachment":{"id":13925,"key":13925,"name":"072ff458-4dbb-3d91-b6c5-426cd0d12a85","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/072ff458-4dbb-3d91-b6c5-426cd0d12a85\/2023_07_14_09_42_39.pdf","orig_name":"2023_07_14_09_42_39.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":429,"serial_no":"SKD-20230725-00001","wrote_date":"2023-07-25","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2749,"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 09:49:18","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"23951","settle_amount":"23951","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-07-25 09:49:18","updated_at":"2023-07-25 09:49:18","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1429","key":"1429","contract_id":2749,"value":"23951","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":1434,"key":1434,"contract_id":2749,"value":"23951.00","attachment_id":null,"from_date":"2023-07-14","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1282,"key":1282,"contract_id":2749,"name":"2023-09-29","value":"23951","overdue_days":null,"status":1,"remind_date":"2023-09-29","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":4561,"user_id":1004,"key":1004,"contract_id":2749,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1247,"contract_id":2749,"supplier_id":236,"purchase_id":2779,"supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchase":{"id":2779,"key":2779,"serial_no":"TSKJ-ZHF-20230725"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":23951},"projectRemindReceivers":[],"projectProductRels":[{"id":2479,"project_id":3254,"product_id":734,"amount":"7071","number":1,"cost":"4884.48","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7071","total_cost":"4884.48","erp_sales_order_product_id":255,"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":255,"erp_sales_order_id":1053,"erp_store_id":null,"product_id":734,"description":"","number":"1","outbound":"0","amount":"7071","total_amount":"7071","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4884.48","total_cost":"4884.48","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2480,"project_id":3254,"product_id":421,"amount":"4540","number":2,"cost":"2930.56","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"9080","total_cost":"5861.12","erp_sales_order_product_id":256,"supplier":null,"product":{"id":421,"name":"\u6df1\u4fe1\u670d\u7eed\u4fdd\u670d\u52a1","product_type":4,"product_component":51,"product_brand":12,"product_serie":274,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2018-08-28 12:17:51","updated_at":"2025-12-23 17:44:35","pinyin_shortcut":"sxfxbfw","product_unit":8,"is_renew":false,"in_out_at":"2025-12-23 17:44:35.752473+08","productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":274,"key":274,"name":" \u6df1\u4fe1\u670d\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}},"erpSalesOrderProduct":{"id":256,"erp_sales_order_id":1053,"erp_store_id":null,"product_id":421,"description":"","number":"2","outbound":"0","amount":"4540","total_amount":"9080","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2930.56","total_cost":"5861.12","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":2481,"project_id":3254,"product_id":816,"amount":"7800","number":1,"cost":"4000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7800","total_cost":"4000","erp_sales_order_product_id":257,"supplier":null,"product":{"id":816,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0","product_type":7,"product_component":41,"product_brand":12,"product_serie":1272,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2021-09-14 10:51:28","updated_at":"2024-03-11 13:52:56","pinyin_shortcut":"sxfzdjcxyptrjV30","product_unit":2,"is_renew":false,"in_out_at":null,"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":41,"key":41,"name":"\u5b89\u5168\u8f6f\u4ef6"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1272,"key":1272,"name":"\u6df1\u4fe1\u670d\u7ec8\u7aef\u68c0\u6d4b\u54cd\u5e94\u5e73\u53f0\u8f6f\u4ef6V3.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":257,"erp_sales_order_id":1053,"erp_store_id":null,"product_id":816,"description":"","number":"1","outbound":"0","amount":"7800","total_amount":"7800","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"4000","total_cost":"4000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3254,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1053,"serial_no":"XSDD-20230714-00001","from_date":null,"wrote_date":"2023-07-10","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3254,"sales_contract_id":2749,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6df1\u4fe1\u670dEDR\u5b89\u5168\u4ea7\u54c1\u7eed\u4fdd","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-07-25 09:49:18","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"4","amount":"23951","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-14 11:02:37","updated_at":"2023-07-25 09:49:18","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1092,"progress_remain_display":1092,"forecast_remain_display":1092,"projectProductTotalAmount":23951,"projectProductAllAmount":true,"projectProductTotalCost":14745.6,"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":10,"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.4\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3244,"client_id":48,"project_status":3,"project_progress":7,"budget":"40410","profit_pct":"13.62","bargain_date":"2023-07-05","description":"\u7fa4\u6656DS1621+ ,NAS\u670d\u52a1\u5668\u662f6\u76d8\u4f4d\u65e0\u5185\u7f6e\u786c\u76d8\uff0c\u652f\u6301SATA\u7684HDD\u673a\u68b0\u786c\u76d8\u548cSSD\u786c\u76d8\uff0cNVMe SSD\u786c\u76d8\uff0c \u5355\u76d8\u652f\u6301\u6700\u5927\u5bb9\u91cf16TB\uff0cCPU AMD Ryzen V1500B \u56db\u6838 2.2GHz,\u5185\u5b58\u5bb9\u91cf 4GB DDR4 ECC SODIMM\uff0c\u53ef\u6269\u5c55\u81f332GB\uff0c3 x USB 3.2 \u7b2c 1 \u4ee3\uff0c2 x eSATA \uff0c4 x 1GbE RJ-45\uff0c1 x 4-lane x8 \u63d2\u69fd\uff0c\u652f\u6301 10GbE\/25GbE \u7f51\u5361\u00b3\uff1b\u539f\u5382\u4fdd\u4fee3\u5e74","created_by":1004,"created_at":"2023-07-05 09:59:14","updated_at":"2024-01-26 15:25:04","engineer_id":null,"project_title":"\u7fa4\u6656\u5b58\u50a8\u9879\u76ee","collected":"40410","status_updated_at":"2023-07-12 14:13:55.475334+08","success_rate":null,"comment":"\u7fa4\u6656DS1621+ ,NAS\u670d\u52a1\u5668\u662f6\u76d8\u4f4d\u65e0\u5185\u7f6e\u786c\u76d8\uff0c\u652f\u6301SATA\u7684HDD\u673a\u68b0\u786c\u76d8\u548cSSD\u786c\u76d8\uff0cNVMe SSD\u786c\u76d8\uff0c \u5355\u76d8\u652f\u6301\u6700\u5927\u5bb9\u91cf16TB\uff0cCPU AMD Ryzen V1500B \u56db\u6838 2.2GHz,\u5185\u5b58\u5bb9\u91cf 4GB DDR4 ECC SODIMM\uff0c\u53ef\u6269\u5c55\u81f332GB\uff0c3 x USB 3.2 \u7b2c 1 \u4ee3\uff0c2 x eSATA \uff0c4 x 1GbE RJ-45\uff0c1 x 4-lane x8 \u63d2\u69fd\uff0c\u652f\u6301 10GbE\/25GbE \u7f51\u5361\u00b3\uff1b\u539f\u5382\u4fdd\u4fee3\u5e74\r\n","contract_type":1,"progress_updated_at":"2023-07-05 09:59:14.72332+08","forecast_updated_at":"2023-07-05 09:59:14.72332+08","end_at":"2023-08-09 10:48:52","pinyin_shortcut":"qhccxm","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":231,"is_sales_order_ready":true,"collected_plan":40410,"change_status_to":null,"is_verify":false,"profits":"5503.842000000000000000","remain":"1096 days 22:57:45.2231","progress_remain":"1104 days 03:12:25.975114","forecast_remain":"1104 days 03:12:25.975114","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"35 days 00:49:37.882143","issued_invoices":"40410.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3244,"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":"40410.00","pct":"13.62","profit":"5503.842","project_id":3244}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3244,"points":"169"},"workLogCount":null,"caseCount":{"project_id":3244,"count":5},"salesTimeCount":null,"implementTimeCount":{"project_id":3244,"sum":"9.01666666666667","times":"5"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3244,"sum":"771.36"},"buildContract":{"id":2740,"from_project":3244,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023070502","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"40410","erp_un_settle_amount":"0","including_tax":true,"amount":"40410","contractScans":[{"id":23336,"object_type":105,"object_id":2740,"attachment_id":13876,"attachment":{"id":13876,"key":13876,"name":"47217099-d78d-3da3-af1b-e4fc322b4811","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/47217099-d78d-3da3-af1b-e4fc322b4811\/\u4e2d\u90fd\u7269\u6d4140410\u5408\u540c.pdf","orig_name":"\u4e2d\u90fd\u7269\u6d4140410\u5408\u540c.pdf"}}],"receiptScans":[{"id":19490,"object_type":106,"object_id":2740,"attachment_id":14059,"attachment":{"id":14059,"key":14059,"name":"b928b83d-5644-3161-8138-4610c645b728","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/b928b83d-5644-3161-8138-4610c645b728\/2023_07_24_15_08_54.pdf","orig_name":"2023_07_24_15_08_54.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":424,"serial_no":"SKD-20230809-00001","wrote_date":"2023-08-09","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2740,"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-08-09 10:48:52","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"40410","settle_amount":"40410","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-08-09 10:48:52","updated_at":"2023-08-09 10:48:52","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1424","key":"1424","contract_id":2740,"value":"40410","created_by":1014,"collected_date":"2023-08-09 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1429,"key":1429,"contract_id":2740,"value":"40410.00","attachment_id":null,"from_date":"2023-07-11","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1276,"key":1276,"contract_id":2740,"name":"2023-09-29","value":"40410","overdue_days":null,"status":1,"remind_date":"2023-09-29","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":4562,"user_id":1004,"key":1004,"contract_id":2740,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1207,"contract_id":2740,"supplier_id":68,"purchase_id":2746,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2746,"key":2746,"serial_no":"BJ7067IM20230705A001"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":40410},"projectRemindReceivers":[],"projectProductRels":[{"id":3251,"project_id":3244,"product_id":817,"amount":"7480","number":1,"cost":"6440","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7480","total_cost":"6440","erp_sales_order_product_id":225,"supplier":null,"product":{"id":817,"name":"DS1621+","product_type":3,"product_component":14,"product_brand":27,"product_serie":852,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2021-09-14 10:57:47","updated_at":"2024-01-16 11:51:50","pinyin_shortcut":"DS1621","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":14,"key":14,"name":"\u5b58\u50a8\u4e3b\u673a"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":852,"key":852,"name":"DS1621+ NAS\u5b58\u50a8"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":225,"erp_sales_order_id":1048,"erp_store_id":null,"product_id":817,"description":"","number":"1","outbound":"0","amount":"7480","total_amount":"7480","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"6440","total_cost":"6440","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3252,"project_id":3244,"product_id":893,"amount":"3942","number":2,"cost":"3442","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"7884","total_cost":"6884","erp_sales_order_product_id":226,"supplier":null,"product":{"id":893,"name":"DX517","product_type":3,"product_component":17,"product_brand":27,"product_serie":559,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-01-03 15:56:18","updated_at":"2024-01-16 11:57:37","pinyin_shortcut":"DX517","product_unit":1,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":17,"key":17,"name":"\u5b58\u50a8\u6269\u5c55\u67dc"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":559,"key":559,"name":"DX517 \u5b58\u50a8\u6269\u5c55\u67dc"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}},"erpSalesOrderProduct":{"id":226,"erp_sales_order_id":1048,"erp_store_id":null,"product_id":893,"description":"","number":"2","outbound":"0","amount":"3942","total_amount":"7884","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"3442","total_cost":"6884","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":3253,"project_id":3244,"product_id":1250,"amount":"1789","number":14,"cost":"1289","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"25046","total_cost":"18046","erp_sales_order_product_id":227,"supplier":null,"product":{"id":1250,"name":"HAT5300-4T","product_type":3,"product_component":15,"product_brand":27,"product_serie":557,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-16 13:33:01","updated_at":"2024-01-16 13:33:01","pinyin_shortcut":"HAT53004T","product_unit":4,"is_renew":false,"in_out_at":null,"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":557,"key":557,"name":"4TB 7.2K 3.5 SATA\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":227,"erp_sales_order_id":1048,"erp_store_id":null,"product_id":1250,"description":"","number":"14","outbound":"0","amount":"1789","total_amount":"25046","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"1289","total_cost":"18046","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3244,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1048,"serial_no":"XSDD-20230809-00001","from_date":null,"wrote_date":"2023-07-05","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3244,"sales_contract_id":2740,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7fa4\u6656DS1621+ ,NAS\u670d\u52a1\u5668\u662f6\u76d8\u4f4d\u65e0\u5185\u7f6e\u786c\u76d8\uff0c\u652f\u6301SATA\u7684HDD\u673a\u68b0\u786c\u76d8\u548cSSD\u786c\u76d8\uff0cNVMe SSD\u786c\u76d8\uff0c \u5355\u76d8\u652f\u6301\u6700\u5927\u5bb9\u91cf16TB\uff0cCPU AMD Ryzen V1500B \u56db\u6838 2.2GHz,\u5185\u5b58\u5bb9\u91cf 4GB DDR4 ECC SODIMM\uff0c\u53ef\u6269\u5c55\u81f332GB\uff0c3 x USB 3.2 \u7b2c 1 \u4ee3\uff0c2 x eSATA \uff0c4 x 1GbE RJ-45\uff0c1 x 4-lane x8 \u63d2\u69fd\uff0c\u652f\u6301 10GbE\/25GbE \u7f51\u5361\u00b3\uff1b\u539f\u5382\u4fdd\u4fee3\u5e74","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-08-09 10:48:52","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"17","amount":"40410","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-07-12 14:13:55","updated_at":"2023-08-09 10:48:52","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1096,"progress_remain_display":1104,"forecast_remain_display":1104,"projectProductTotalAmount":40410,"projectProductAllAmount":true,"projectProductTotalCost":31370,"projectProductAllCost":true,"projectProductTotalNumber":17,"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":35,"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":"4.04\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3116,"client_id":48,"project_status":3,"project_progress":10,"budget":"62000","profit_pct":"18.01","bargain_date":"2023-02-24","description":"\u8054\u60f3S650\u670d\u52a1\u5668\u5185\u5b58\u6269\u5bb9\uff1a2064GB","created_by":1004,"created_at":"2023-02-15 14:18:37","updated_at":"2024-02-02 14:16:43","engineer_id":null,"project_title":"\u670d\u52a1\u5668\u5185\u5b58\u6269\u5bb9\u9879\u76ee","collected":"62000","status_updated_at":"2023-02-26 11:29:17.809996+08","success_rate":null,"comment":"\u8054\u60f3S650\u670d\u52a1\u5668\u5185\u5b58\u6269\u5bb9\uff1a2064GB\r\n","contract_type":1,"progress_updated_at":"2023-02-26 11:29:17.809996+08","forecast_updated_at":"2023-02-26 11:29:17.809996+08","end_at":"2023-04-18 15:46:36","pinyin_shortcut":"fwqnckrxm","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":18,"is_sales_order_ready":true,"collected_plan":62000,"change_status_to":null,"is_verify":false,"profits":"11166.200000000000000000","remain":"1233 days 01:42:22.888438","progress_remain":"1233 days 01:42:22.888438","forecast_remain":"1233 days 01:42:22.888438","lost_contact_days":"1188.78935993558","last_contact":"2023-04-11 18:15:00","last_arrive_days":null,"last_arrive":null,"duration":"62 days 01:27:59.206501","issued_invoices":"62000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3116,"value":"1","key":1023,"name":"\u5468\u5b50\u5065"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"62000","pct":"18.01","profit":"11166.2","project_id":3116}],"salesForecast":{"id":177,"key":177,"name":"70%","description":"\u8ddf\u5ba2\u6237\u5173\u952e\u51b3\u7b56\u4eba\u5728\u5229\u76ca\u4e0a\u8fbe\u6210\u4e00\u81f4"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3116,"points":"219"},"workLogCount":{"project_id":3116,"count":3},"caseCount":{"project_id":3116,"count":4},"salesTimeCount":null,"implementTimeCount":{"project_id":3116,"sum":"9.81527777777778","times":"4"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3116,"sum":"506.61"},"buildContract":{"id":2572,"from_project":3116,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2023022403","is_settle":true,"is_deliver":true,"is_outbound":true,"erp_settle_amount":"62000","erp_un_settle_amount":"0","including_tax":true,"amount":"62000","contractScans":[{"id":23339,"object_type":105,"object_id":2572,"attachment_id":12807,"attachment":{"id":12807,"key":12807,"name":"e81e89fb-3af8-3f36-8280-528e516ae0aa","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e81e89fb-3af8-3f36-8280-528e516ae0aa\/2023_04_21_10_20_24.pdf","orig_name":"2023_04_21_10_20_24.pdf"}}],"receiptScans":[{"id":17372,"object_type":106,"object_id":2572,"attachment_id":12142,"attachment":{"id":12142,"key":12142,"name":"0e7f4bc2-f59b-31a1-babd-76de4c4fb38b","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/0e7f4bc2-f59b-31a1-babd-76de4c4fb38b\/2023_02_27_09_31_51.pdf","orig_name":"2023_02_27_09_31_51.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1204,"serial_no":"SKD-20230418-00002","wrote_date":"2023-04-18","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2572,"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-04-18 15:46:36","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"62000","settle_amount":"62000","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-04-18 15:46:36","updated_at":"2023-04-18 15:46:36","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11204","key":"11204","contract_id":2572,"value":"62000","created_by":1014,"collected_date":"2023-04-18 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1371,"key":1371,"contract_id":2572,"value":"62000.00","attachment_id":null,"from_date":"2023-03-29","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1162,"key":1162,"contract_id":2572,"name":"2023-04-25","value":"62000","overdue_days":null,"status":1,"remind_date":"2023-04-25","pct":100,"overdue_display":""}],"salesContractPaymentCollectionRemindReceivers":[{"id":4565,"user_id":1004,"key":1004,"contract_id":2572,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":95,"contract_id":2572,"supplier_id":186,"purchase_id":2576,"supplier":{"id":186,"key":186,"name":"\u5317\u4eac\u5353\u4e3a\u6052\u5929\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2576,"key":2576,"serial_no":"TSKJ20230223-HYF-002"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":62000},"projectRemindReceivers":[],"projectProductRels":[{"id":2487,"project_id":3116,"product_id":915,"amount":"3100","number":20,"cost":"2250","description":"\u8054\u60f3\u539f\u5382\u4fdd\u4fee","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"62000","total_cost":"45000","erp_sales_order_product_id":28,"supplier":null,"product":{"id":915,"name":"64GB PC4-2933\u5185\u5b58","product_type":2,"product_component":4,"product_brand":4,"product_serie":29,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-03-23 15:58:26","updated_at":"2023-08-11 16:05:33","pinyin_shortcut":"64GBPC42933nc","product_unit":6,"is_renew":false,"in_out_at":null,"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":29,"key":29,"name":"DDR4"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":28,"erp_sales_order_id":977,"erp_store_id":null,"product_id":915,"description":"\u8054\u60f3\u539f\u5382\u4fdd\u4fee","number":"20","outbound":"0","amount":"3100","total_amount":"62000","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2250","total_cost":"45000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"commentCount":{"object_id":3116,"comment":4},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":977,"serial_no":"XSDD-20230224-00001","from_date":null,"wrote_date":"2023-02-24","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3116,"sales_contract_id":2572,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8054\u60f3S650\u670d\u52a1\u5668\u5185\u5b58\u6269\u5bb9\uff1a20*64GB","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-04-18 15:46:36","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"20","amount":"62000","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-02-24 09:48:04","updated_at":"2023-04-18 15:46:36","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1233,"progress_remain_display":1233,"forecast_remain_display":1233,"projectProductTotalAmount":62000,"projectProductAllAmount":true,"projectProductTotalCost":45000,"projectProductAllCost":true,"projectProductTotalNumber":20,"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":62,"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":"6.2\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":3072,"client_id":48,"project_status":3,"project_progress":7,"budget":"6400","profit_pct":"52.38","bargain_date":"2022-12-29","description":"netapp 900G\u00d74\u5757","created_by":1004,"created_at":"2022-12-29 11:54:38","updated_at":"2023-05-29 16:16:56","engineer_id":null,"project_title":"\u786c\u76d8\u66f4\u6362","collected":"6400","status_updated_at":"2022-12-29 12:00:06.728837+08","success_rate":null,"comment":"netapp 900G\u00d74\u5757\r\n","contract_type":1,"progress_updated_at":"2022-12-29 11:54:38.658161+08","forecast_updated_at":"2023-01-03 15:27:43.242317+08","end_at":"2023-04-18 15:46:48","pinyin_shortcut":"ypgh","creator":1004,"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":6400,"change_status_to":null,"is_verify":false,"profits":"3352.320000000000000000","remain":"1292 days 01:11:33.969597","progress_remain":"1292 days 01:17:02.040273","forecast_remain":"1286 days 21:43:57.456117","lost_contact_days":"1258.08797104669","last_contact":"2023-02-01 11:05:00","last_arrive_days":null,"last_arrive":null,"duration":"110 days 03:52:10.304377","issued_invoices":"6400.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3072,"value":"1","key":5248,"name":"\u6587\u4f73\u9f99"}],"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":"6400","pct":"52.38","profit":"3352.32","project_id":3072}],"salesForecast":{"id":174,"key":174,"name":"80%","description":"\u7528\u56f4\u6807\u7684\u65b9\u5f0f\u7ade\u4ef7"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":3072,"points":"19"},"workLogCount":{"project_id":3072,"count":2},"caseCount":{"project_id":3072,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":3072,"sum":"3.36666666666667","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":3072,"sum":"294.68"},"buildContract":{"id":2533,"from_project":3072,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2022122901","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"6400","erp_un_settle_amount":"0","including_tax":true,"amount":"6400","contractScans":[{"id":17056,"object_type":105,"object_id":2533,"attachment_id":11862,"attachment":{"id":11862,"key":11862,"name":"ba45eec0-7487-336e-95ba-3dfff6afb8c0","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/ba45eec0-7487-336e-95ba-3dfff6afb8c0\/2023_01_03_16_01_28.pdf","orig_name":"2023_01_03_16_01_28.pdf"}}],"receiptScans":[{"id":17090,"object_type":106,"object_id":2533,"attachment_id":11887,"attachment":{"id":11887,"key":11887,"name":"24d7f738-e1d7-36aa-95c1-3ed7962f497d","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/24d7f738-e1d7-36aa-95c1-3ed7962f497d\/2023_01_06_10_14_24.pdf","orig_name":"2023_01_06_10_14_24.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":500,"serial_no":"SKD-20230418-00001","wrote_date":"2023-04-18","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2533,"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-04-18 15:46:48","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"6400","settle_amount":"6400","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2023-04-18 15:46:48","updated_at":"2023-04-18 15:46:48","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1500","key":"1500","contract_id":2533,"value":"6400","created_by":1014,"collected_date":"2023-04-18 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1372,"key":1372,"contract_id":2533,"value":"6400.00","attachment_id":null,"from_date":"2023-03-29","attachment":null}],"salesContractPaymentCollectionRemindDates":[{"id":1103,"key":1103,"contract_id":2533,"name":"2023-02-28","value":"6400","overdue_days":49,"status":1,"remind_date":"2023-02-28","pct":100,"overdue_display":"\u903e\u671f49\u5929"}],"salesContractPaymentCollectionRemindReceivers":[{"id":3533,"user_id":1004,"key":1004,"contract_id":2533,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":6400},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":3072,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":959,"serial_no":"XSDD-20221229-00001","from_date":null,"wrote_date":"2022-12-29","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":3072,"sales_contract_id":2533,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"netapp 900G\u00d74\u5757","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-04-18 15:46:48","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"6400","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-12-29 12:00:06","updated_at":"2023-04-18 15:46:48","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1292,"progress_remain_display":1292,"forecast_remain_display":1286,"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":110,"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":"6400","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":"0","un_invoiced":0,"object_type":1},{"id":2906,"client_id":48,"project_status":3,"project_progress":10,"budget":"1600","profit_pct":"52.38","bargain_date":"2022-07-14","description":"netapp\u786c\u76d8\u4e00\u5757","created_by":1004,"created_at":"2022-07-14 11:41:12","updated_at":"2023-09-08 09:10:09","engineer_id":null,"project_title":"netapp\u5b58\u50a8\u786c\u76d8","collected":"1600","status_updated_at":"2022-07-14 11:43:12.606787+08","success_rate":null,"comment":"netapp\u786c\u76d8\u4e00\u5757\r\n","contract_type":1,"progress_updated_at":"2022-07-14 11:41:12.601701+08","forecast_updated_at":"2022-07-14 11:41:12.601701+08","end_at":"2022-08-12 16:02:11","pinyin_shortcut":"netappccyp","creator":1004,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"838.080000000000000000","remain":"1460 days 01:28:28.091647","progress_remain":"1460 days 01:30:28.096733","forecast_remain":"1460 days 01:30:28.096733","lost_contact_days":"1431.14005438002","last_contact":"2022-08-12 09:50:00","last_arrive_days":null,"last_arrive":null,"duration":"29 days 04:20:58.754463","issued_invoices":"1600.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":8,"key":8,"name":"\u7269\u6d41"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"1600.00","pct":"52.38","profit":"838.08","project_id":2906}],"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":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"casePoints":{"project_id":2906,"points":"94"},"workLogCount":{"project_id":2906,"count":2},"caseCount":{"project_id":2906,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":2906,"sum":"5.30055555555556","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2337,"from_project":2906,"payment_collection_remind_ahead":"00:00:00","serial_no":"TS-YJC-2022071401","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"1600","erp_un_settle_amount":"0","including_tax":true,"amount":"1600","contractScans":[{"id":15759,"object_type":105,"object_id":2337,"attachment_id":10587,"attachment":{"id":10587,"key":10587,"name":"a91f384e-8541-35cd-b8e7-654c74ddee26","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/a91f384e-8541-35cd-b8e7-654c74ddee26\/2022_07_15_10_51_44.pdf","orig_name":"2022_07_15_10_51_44.pdf"}}],"receiptScans":[{"id":15603,"object_type":106,"object_id":2337,"attachment_id":10592,"attachment":{"id":10592,"key":10592,"name":"293b2efb-7430-3741-80d4-700be82f27ba","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/293b2efb-7430-3741-80d4-700be82f27ba\/2022_07_18_10_04_32.pdf","orig_name":"2022_07_18_10_04_32.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1853,"serial_no":"SKD-20220812-00001","wrote_date":"2022-08-12","from_date":null,"handler":1004,"user_id":null,"client_id":48,"sales_contract_id":2337,"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-12 16:02:11","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"1600","settle_amount":"1600","created_by":1014,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2022-08-12 16:02:11","updated_at":"2022-08-12 16:02:11","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11853","key":"11853","contract_id":2337,"value":"1600","created_by":1014,"collected_date":"2022-08-12 00:00:00","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":100}],"salesContractInvoices":[{"id":1235,"key":1235,"contract_id":2337,"value":"1600.00","attachment_id":null,"from_date":"2022-07-26","attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3235,"user_id":1004,"key":1004,"contract_id":2337,"user":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}}],"salesSupplierRels":[{"id":1277,"contract_id":2337,"supplier_id":165,"purchase_id":2408,"supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2408,"key":2408,"serial_no":"NICERBJRL20221027"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":1600},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":2906,"comment":3},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":876,"serial_no":"XSDD-20220812-00001","from_date":null,"wrote_date":"2022-07-14","handler":1004,"client_id":48,"purchase_contract_id":null,"project_id":2906,"sales_contract_id":2337,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"netapp\u786c\u76d8\u4e00\u5757","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2022-08-12 16:02:11","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"1600","created_by":1004,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-07-14 11:43:12","updated_at":"2022-08-12 16:02:11","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":1460,"progress_remain_display":1460,"forecast_remain_display":1460,"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":29,"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":"1600","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}],"pagenation":{"totalcount":56,"thispage":2,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-13 13:11:40', 232332800) RETURNING "id"
13:11:40.768	3.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228))
13:11:40.785	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 (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228) ORDER BY "id" DESC
13:11:40.776	3.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228))
13:11:40.759	3.1 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "c"."project_id"
13:11:40.780	3.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228))
13:11:40.763	2.7 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "project_id"
13:11:40.773	2.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10587, 11862, 13996, 13925, 13876, 13997, 12807, 14228, 18637, 18969)
13:11:40.747	1.9 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906) GROUP BY "project_id"
13:11:40.800	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (734, 421, 816, 468, 915, 289, 1354, 1355, 817, 893, 1250, 941, 41, 298, 1376, 1557, 1536, 972)
13:11:40.783	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228)) ORDER BY "id" DESC
13:11:40.886	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906))
13:11:40.726	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.725	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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.798	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906) ORDER BY "id"
13:11:40.670	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
13:11:40.766	0.9 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.794	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228)
13:11:40.791	0.8 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 (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228) ORDER BY "remind_date"
13:11:40.722	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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906) ORDER BY "contribution" DESC, "engineer_id"
13:11:40.789	0.8 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 (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228) ORDER BY "id"
13:11:40.806	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (255, 256, 257, 39, 28, 303, 304, 305, 225, 226, 227, 228, 229, 230, 231, 232, 788, 769, 770, 771)
13:11:40.721	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
13:11:40.885	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.672	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
13:11:40.796	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3211, 2576, 2952, 3268, 2810, 3223, 2746, 2779, 2408, 2629, 3267)
13:11:40.749	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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "project_id"
13:11:40.792	0.7 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 (2337, 2533, 2572, 2584, 2789, 2741, 2740, 2749, 3208, 3228)
13:11:40.889	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906))
13:11:40.716	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"=48
13:11:40.795	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (530, 186, 116, 489, 68, 59, 236, 165, 81)
13:11:40.729	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.676	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='48') AND ("deleted"=FALSE)
13:11:40.746	0.6 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "project_id"
13:11:40.804	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1015, 857, 1326, 27, 1191, 592, 1272, 852, 274, 903, 1020, 559, 29, 210, 557, 1026, 1052)
13:11:40.731	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.888	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.728	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 (326, 2, 1, 136, 139, 215, 185, 5, 135, 191, 164, 179, 181, 140, 226, 197, 194, 178, 183, 205, 204, 307, 184, 189, 174, 165, 177, 160, 349, 352, 354, 359, 369, 363, 350, 356, 340)) ORDER BY "sort"
13:11:40.718	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:11:40.803	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (15, 14, 4, 5, 151, 41, 51, 200, 17, 35, 36, 13)
13:11:40.762	0.5 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)) GROUP BY "project_id"
13:11:40.804	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (6, 27, 2, 3, 4, 133, 12, 8)
13:11:40.797	0.4 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 (3498, 3484, 3215, 3231, 3141, 3254, 3244, 3116, 3072, 2906)
13:11:40.735	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=48
13:11:40.779	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10592, 11887, 12142, 12217, 13875, 14059, 18638, 18933)
13:11:40.805	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 1, 6, 7, 2, 8)
13:11:40.730	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 (326, 2, 1, 136, 139, 215, 185, 5, 135, 191, 164, 179, 181, 140, 226, 197, 194, 178, 183, 205, 204, 307, 184, 189, 174, 165, 177, 160, 349, 352, 354, 359, 369, 363, 350, 356, 340)) ORDER BY "sort"
13:11:40.731	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 (326, 2, 1, 136, 139, 215, 185, 5, 135, 191, 164, 179, 181, 140, 226, 197, 194, 178, 183, 205, 204, 307, 184, 189, 174, 165, 177, 160, 349, 352, 354, 359, 369, 363, 350, 356, 340)) ORDER BY "sort"
13:11:40.719	0.4 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"=1004)
13:11:40.733	0.4 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"=1004)
13:11:40.669	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:11:40.719	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=5
13:11:40.720	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47
13:11:40.724	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
13:11:40.789	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013)
13:11:40.724	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (10, 7, 9)
13:11:40.799	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (81, 489, 59, 530)
13:11:40.802	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (3, 2, 19, 7, 4, 22, 5)
13:11:40.720	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=8
13:11:40.734	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"=1004)
13:11:40.732	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:11:40.793	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:11:40.734	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:11:40.793	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"=1004)
13:11:40.736	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"=1004)
13:11:40.735	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
13:11:40.733	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1