Performance Profiling

Total processing time: 252 ms; Peak memory: 6.796 MB. Show Profiling Timeline

总计65条数据

Time	Duration	Category	Info

10:13:21.500	66.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))) GROUP BY "p"."id" ORDER BY "p"."created_at" LIMIT 10
10:13:21.456	42.7 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))) GROUP BY "p"."id" ORDER BY "p"."created_at") "c"
10:13:21.642	17.9 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "object_id"
10:13:21.660	16.6 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "object_id"
10:13:21.598	8.4 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "c"."project_id"
10:13:21.586	7.5 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12) GROUP BY "c"."project_id"
10:13:21.685	4.1 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, 2, 1161, 'v2/project/list', '{"Filter":{"name":"created_at","sort":"ASC"},"ProjectSearch":{"created_by":"","engineer_id":"","period":"","projectProductTypes":"","project_progress":"","project_status":"","salesForecast":""},"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"2","posttime":"1784081664","token":"8afea1f868b587bca6aa8a55365e8a20","version_code":"1161"}', '{"code":200,"data":{"list":[{"id":2,"client_id":5,"project_status":3,"project_progress":10,"budget":"4065723","profit_pct":"30","bargain_date":"2017-08-31","description":"\u601d\u79d1UCS UCS B2006\/B4204\/N93722\/35604\/29603\/vspere8\/\u5b58\u50a8LIes\/DS9148S2\u7b49\uff08\u6210\u5355\u738780%\uff09","created_by":1004,"created_at":"2017-02-08 16:42:36","updated_at":"2021-06-29 16:59:28","engineer_id":1017,"project_title":"\u6570\u636e\u4e2d\u5fc3\u5bb9\u707e\u5907\u4efd","collected":"4065723","status_updated_at":"2018-05-23 10:24:44.115055+08","success_rate":100,"comment":"\u601d\u79d1UCS UCS B2006\/B4204\/N93722\/35604\/29603\/vspere8\/\u5b58\u50a8LIes\/DS9148S2\u7b49\uff08\u6210\u5355\u738780%\uff09\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:29:03.988722+08","forecast_updated_at":"2019-05-05 20:29:03.988722+08","end_at":"2019-05-05 20:29:03","pinyin_shortcut":"sjzxrzbf","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":"1219716.900000000000","remain":"2974 days 23:48:37.386701","progress_remain":"2627 days 13:44:17.513034","forecast_remain":"2627 days 13:44:17.513034","lost_contact_days":"2317.99538775181","last_contact":"2020-03-10 10:20:00","last_arrive_days":null,"last_arrive":null,"duration":"816 days 03:46:27.034134","issued_invoices":"4065723","client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":6,"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":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":6,"key":6,"name":"\u7535\u5546"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":2,"value":"0.5","key":1015,"name":"\u5434\u660a"},{"project_id":2,"value":"0.5","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"951400.00","pct":"30","profit":"285420","project_id":2},{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"2237064.00","pct":"30","profit":"671119.2","project_id":2},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"80000.00","pct":"30","profit":"24000","project_id":2},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"344187.00","pct":"30","profit":"103256.1","project_id":2},{"id":88,"product_type_id":88,"key":88,"name":"\u79c1\u6709\u4e91","budget":"453072.00","pct":"30","profit":"135921.6","project_id":2}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":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":2,"points":"346"},"workLogCount":{"project_id":2,"count":1},"caseCount":{"project_id":2,"count":10},"salesTimeCount":null,"implementTimeCount":{"project_id":2,"sum":"57.5","times":"9"},"presalesTimeCount":{"project_id":2,"sum":"0.75","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":{"project_id":2,"sum":"3115.64"},"buildContract":{"id":229,"from_project":2,"payment_collection_remind_ahead":"00:00:00","serial_no":"H20170831S01","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"4065723","erp_un_settle_amount":"0","including_tax":true,"amount":"4065723","contractScans":[{"id":12492,"object_type":105,"object_id":229,"attachment_id":665,"attachment":{"id":665,"key":665,"name":"c2bf8ba9-e249-35d4-ab50-c7d3b190e365","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/c2bf8ba9-e249-35d4-ab50-c7d3b190e365\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170831\u20144065723.pdf","orig_name":"\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\u201420170831\u20144065723.pdf"}}],"receiptScans":[{"id":13225,"object_type":106,"object_id":229,"attachment_id":676,"attachment":{"id":676,"key":676,"name":"5b89ab3e-1a6f-3636-a7a3-61e83b6bf812","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/5b89ab3e-1a6f-3636-a7a3-61e83b6bf812\/\u666e\u5929\u592a\u529b\u201420171127.pdf","orig_name":"\u666e\u5929\u592a\u529b\u201420171127.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1372,"serial_no":"SKD-20170831-00003","wrote_date":null,"from_date":null,"handler":1004,"user_id":null,"client_id":5,"sales_contract_id":229,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-08-31 14:23:57","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"203286.00","settle_amount":"203286.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2017-08-31 14:23:57","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":1371,"serial_no":"SKD-20170831-00002","wrote_date":null,"from_date":null,"handler":1004,"user_id":null,"client_id":5,"sales_contract_id":229,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-08-31 14:23:57","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"3862437.00","settle_amount":"3862437.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2017-08-31 14:23:57","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11372","key":"11372","contract_id":229,"value":"203286.00","created_by":null,"collected_date":"","createdBy":null,"pct":5},{"id":"11371","key":"11371","contract_id":229,"value":"3862437.00","created_by":null,"collected_date":"","createdBy":null,"pct":95}],"salesContractInvoices":[{"id":799,"key":799,"contract_id":229,"value":"4065723.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":109,"contract_id":229,"supplier_id":46,"purchase_id":285,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":285,"key":285,"serial_no":"-"}},{"id":278,"contract_id":229,"supplier_id":147,"purchase_id":393,"supplier":{"id":147,"key":147,"name":"\u6d6a\u6f6e\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchase":{"id":393,"key":393,"serial_no":"-"}},{"id":301,"contract_id":229,"supplier_id":46,"purchase_id":224,"supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchase":{"id":224,"key":224,"serial_no":"-"}},{"id":425,"contract_id":229,"supplier_id":68,"purchase_id":303,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":303,"key":303,"serial_no":"-"}},{"id":919,"contract_id":229,"supplier_id":68,"purchase_id":288,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":288,"key":288,"serial_no":"-"}},{"id":1347,"contract_id":229,"supplier_id":95,"purchase_id":295,"supplier":{"id":95,"key":95,"name":"\u5317\u4eac\u5de8\u548c\u62d3\u65b0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":295,"key":295,"serial_no":"-"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":4065723},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":83,"serial_no":"XSDD-20170831-00002","from_date":null,"wrote_date":"2017-08-31","handler":5015,"client_id":5,"purchase_contract_id":null,"project_id":2,"sales_contract_id":229,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u865a\u62df\u5316\u3001\u7f51\u7edc ","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 20:29:03","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"4065723","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-08-31 14:23:57","updated_at":"2019-05-05 20:29:03","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":2974,"progress_remain_display":2627,"forecast_remain_display":2627,"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":816,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":"6\u5e74\u524d","can_view_product":true,"budget_display":"406.57\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,"can_view_verify_list":true,"verifyList":[]},{"id":3,"client_id":12,"project_status":3,"project_progress":10,"budget":"16150","profit_pct":"17","bargain_date":"2017-02-09","description":"1.\u7f57\u6280\u9f20\u6807 M100 5\u4e2a\r\n2.Z440\u5de5\u4f5c\u7ad9 \uff1a\u5355E5-1630v3\/32GB DDR\/1TB \/ K2200 4GB\/525W\/\u952e\u9f20\/V223 \u4e00\u5957","created_by":1003,"created_at":"2017-02-09 11:57:39","updated_at":"2021-06-25 10:23:40","engineer_id":1020,"project_title":"hp\u5de5\u4f5c\u7ad9","collected":"16150","status_updated_at":"2017-05-31 15:34:38.705455+08","success_rate":100,"comment":"1.\u7f57\u6280\u9f20\u6807 M100 5\u4e2a\r\n2.Z440\u5de5\u4f5c\u7ad9 \uff1a\u5355E5-1630v3\/32GB DDR\/1TB \/ K2200 4GB\/525W\/\u952e\u9f20\/V223 \u4e00\u5957\r\n","contract_type":1,"progress_updated_at":"2019-05-14 11:17:27.411265+08","forecast_updated_at":"2019-05-14 11:17:27.411265+08","end_at":"2019-05-14 11:17:27","pinyin_shortcut":"hpgzz","creator":1003,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"2745.5000000000000000","remain":"3331 days 18:38:42.796301","progress_remain":"2618 days 22:55:54.090491","forecast_remain":"2618 days 22:55:54.090491","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"823 days 23:19:48.255543","issued_invoices":"16150","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":80,"client_industry":5,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":3,"value":"1","key":1020,"name":"\u738b\u6069\u56fd"}],"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":"16150","pct":"17","profit":"2745.5","project_id":3}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M","department_id":1,"avatar":{"id":11,"user_id":1003,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":2,"from_project":3,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"16150","erp_un_settle_amount":"0","including_tax":true,"amount":"16150","contractScans":[{"id":12592,"object_type":105,"object_id":2,"attachment_id":122,"attachment":{"id":122,"key":122,"name":"e66c2a59-8b1c-39b9-bdcf-39902aea1aa1","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e66c2a59-8b1c-39b9-bdcf-39902aea1aa1\/SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf","orig_name":"SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf"}}],"receiptScans":[{"id":13296,"object_type":106,"object_id":2,"attachment_id":26,"attachment":{"id":26,"key":26,"name":"9c77fe3d-28c3-35c8-b869-2dbbf33060f1","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9c77fe3d-28c3-35c8-b869-2dbbf33060f1\/smc16150.pdf","orig_name":"smc16150.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":516,"serial_no":"SKD-20170209-00001","wrote_date":null,"from_date":null,"handler":5300,"user_id":null,"client_id":12,"sales_contract_id":2,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-02-09 12:02:04","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"16150.00","settle_amount":"16150.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-02-09 12:02:04","updated_at":"2017-02-09 12:02:04","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1516","key":"1516","contract_id":2,"value":"16150.00","created_by":null,"collected_date":"","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":446,"key":446,"contract_id":2,"value":"16150.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":16150},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":1,"serial_no":"XSDD-20170209-00001","from_date":null,"wrote_date":"2017-02-09","handler":1010,"client_id":12,"purchase_contract_id":null,"project_id":3,"sales_contract_id":2,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8ba1\u7b97","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-14 11:17:27","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"16150","created_by":1010,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-02-09 12:02:04","updated_at":"2019-05-14 11:17:27","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3331,"progress_remain_display":2618,"forecast_remain_display":2618,"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":823,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":false,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"1.62\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,"can_view_verify_list":true,"verifyList":[]},{"id":4,"client_id":23,"project_status":4,"project_progress":2,"budget":"370000","profit_pct":"20","bargain_date":"2017-10-20","description":"2554 \u5f02\u5730\u5907\u4efd","created_by":1005,"created_at":"2017-02-09 12:32:55","updated_at":"2019-05-05 22:33:36","engineer_id":1015,"project_title":"2554 \u5f02\u5730\u5907\u4efd","collected":"0","status_updated_at":"2017-06-15 16:08:01.841928+08","success_rate":0,"comment":"2554 \u5f02\u5730\u5907\u4efd\r\n","contract_type":1,"progress_updated_at":"2019-05-05 22:33:36.993032+08","forecast_updated_at":"2019-05-05 22:33:36.993032+08","end_at":"2019-05-05 22:33:36","pinyin_shortcut":"2554ydbf","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"74000.0000000000000000","remain":"3316 days 18:05:19.659828","progress_remain":"2627 days 11:39:44.508724","forecast_remain":"2627 days 11:39:44.508724","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 10:00:41.714661","issued_invoices":null,"client":{"id":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":5,"sales_rep":null,"salesRep":null,"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":4,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":2,"key":2,"name":"\u786e\u8ba4\u95ee\u9898","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u5ba2\u6237\u5f53\u524d\u9047\u5230\u7684\u5b9e\u9645\u95ee\u9898\uff0c \u6216\u8005\u5f85\u529e\u4efb\u52a1\uff0c\u6216\u8005\u9762\u4e34\u54ea\u4e9b\u6311\u6218\uff1f\n \u65b9\u6cd5\uff1a\u7b2c\u4e00\u6b65\uff1a5why\u6cd5\u8be2\u95ee\u771f\u95ee\u9898 \u7b2c\u4e8c\u6b65\uff1a\u53cd\u95ee\u5982\u679c\u4e0d\u89e3\u51b3\u4f1a\u600e\u6837\uff1f"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"370000","pct":"20","profit":"74000","project_id":4}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":null,"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3316,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":370000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"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":"37\u4e07","contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0,"verify_display":0,"un_collected":0,"un_invoiced":0,"object_type":1,"can_view_verify_list":true,"verifyList":[]},{"id":5,"client_id":20,"project_status":3,"project_progress":10,"budget":"2800000","profit_pct":"20","bargain_date":"2017-11-24","description":"\u4ea4\u6362\u673a\uff0c\u8def\u7531\u5668\uff0c\u9632\u706b\u5899\uff0c\u65e0\u7ebf","created_by":1005,"created_at":"2017-02-09 12:34:10","updated_at":"2024-12-25 15:17:21","engineer_id":1017,"project_title":"\u697c\u5b87\u7f51\u7edc\u65b0\u5efa\u9879\u76ee","collected":"2800000","status_updated_at":"2018-04-23 15:57:01.145126+08","success_rate":100,"comment":"\u4ea4\u6362\u673a\uff0c\u8def\u7531\u5668\uff0c\u9632\u706b\u5899\uff0c\u65e0\u7ebf\r\n","contract_type":1,"progress_updated_at":"2019-05-05 22:30:16.361831+08","forecast_updated_at":"2019-05-05 22:30:16.361831+08","end_at":"2019-05-05 22:30:16","pinyin_shortcut":"lywlxjxm","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":0,"change_status_to":null,"is_verify":false,"profits":"560000.000000000000","remain":"3004 days 18:16:20.35663","progress_remain":"2627 days 11:43:05.139925","forecast_remain":"2627 days 11:43:05.139925","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 09:56:06.268661","issued_invoices":"8400000","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","logo":null,"client_type":6,"client_class":47,"client_industry":5,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":6,"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":5,"key":5,"name":"\u5236\u9020"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":5,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":85,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"2067500.00","pct":"20","profit":"413500","project_id":5},{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"171500.00","pct":"20","profit":"34300","project_id":5},{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"561000.00","pct":"20","profit":"112200","project_id":5}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":{"project_id":5,"points":"51"},"workLogCount":null,"caseCount":{"project_id":5,"count":2},"salesTimeCount":null,"implementTimeCount":{"project_id":5,"sum":"3","times":"2"},"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":311,"from_project":5,"payment_collection_remind_ahead":"00:00:00","serial_no":"CHMC_XXB_2017_2","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"2800000","erp_un_settle_amount":"0","including_tax":true,"amount":"2800000","contractScans":[{"id":12702,"object_type":105,"object_id":311,"attachment_id":672,"attachment":{"id":672,"key":672,"name":"e709f87f-26bd-39d9-a830-adb2889e9590","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/e709f87f-26bd-39d9-a830-adb2889e9590\/\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u201420171124\u20143900000.pdf","orig_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u201420171124\u20143900000.pdf"}}],"receiptScans":[{"id":13395,"object_type":106,"object_id":311,"attachment_id":1098,"attachment":{"id":1098,"key":1098,"name":"50eb7a6e-61e4-3a2c-be5e-0722976fb134","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/50eb7a6e-61e4-3a2c-be5e-0722976fb134\/\u91cd\u578b\u673a\u68b0.pdf","orig_name":"\u91cd\u578b\u673a\u68b0.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1650,"serial_no":"SKD-20171124-00006","wrote_date":null,"from_date":null,"handler":1005,"user_id":null,"client_id":20,"sales_contract_id":311,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-11-24 17:35:42","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"70000.00","settle_amount":"70000.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2017-11-24 17:35:42","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null},{"id":1649,"serial_no":"SKD-20171124-00005","wrote_date":null,"from_date":null,"handler":1005,"user_id":null,"client_id":20,"sales_contract_id":311,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-11-24 17:35:42","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"2730000.00","settle_amount":"2730000.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2017-11-24 17:35:42","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11650","key":"11650","contract_id":311,"value":"70000.00","created_by":null,"collected_date":"","createdBy":null,"pct":2.5},{"id":"11649","key":"11649","contract_id":311,"value":"2730000.00","created_by":null,"collected_date":"","createdBy":null,"pct":97.5}],"salesContractInvoices":[{"id":297,"key":297,"contract_id":311,"value":"1950000.00","attachment_id":null,"from_date":null,"attachment":null},{"id":484,"key":484,"contract_id":311,"value":"780000.00","attachment_id":null,"from_date":null,"attachment":null},{"id":578,"key":578,"contract_id":311,"value":"70000.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[{"id":510,"contract_id":311,"supplier_id":122,"purchase_id":370,"supplier":{"id":122,"key":122,"name":"\u5317\u4eac\u6b23\u90a6\u5b9d\u901a\u8ba1\u7b97\u673a\u7f51\u7edc\u7cfb\u7edf\u5f00\u53d1\u6709\u9650\u516c\u53f8"},"purchase":{"id":370,"key":370,"serial_no":"-"}},{"id":549,"contract_id":311,"supplier_id":163,"purchase_id":358,"supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":358,"key":358,"serial_no":"-"}},{"id":777,"contract_id":311,"supplier_id":146,"purchase_id":340,"supplier":{"id":146,"key":146,"name":"\u5317\u4eac\u7f51\u5b89\u6377\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":340,"key":340,"serial_no":"-"}},{"id":940,"contract_id":311,"supplier_id":104,"purchase_id":388,"supplier":{"id":104,"key":104,"name":"\u5317\u4eac\u57fa\u4e1a\u50b2\u817e\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":388,"key":388,"serial_no":"-"}},{"id":1281,"contract_id":311,"supplier_id":204,"purchase_id":337,"supplier":{"id":204,"key":204,"name":"\u5317\u4eac\u946b\u88d5\u5bcc\u534e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":337,"key":337,"serial_no":"-"}},{"id":2242,"contract_id":311,"supplier_id":675,"purchase_id":375,"supplier":{"id":675,"key":675,"name":"\u7d2b\u5149\u6570\u7801(\u82cf\u5dde)\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchase":{"id":375,"key":375,"serial_no":"20171208"}}],"payment_collection_remind_ahead_display":"\u65e0","invoiced":2800000},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":119,"serial_no":"XSDD-20171124-00002","from_date":null,"wrote_date":"2017-11-24","handler":5015,"client_id":20,"purchase_contract_id":null,"project_id":5,"sales_contract_id":311,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u7f51\u7edc\u3001\u5b89\u5168\u3001\u5b58\u50a8 ","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 22:30:16","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"2800000","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-11-24 17:35:42","updated_at":"2019-05-05 22:30:16","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3004,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":-5600000,"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":815,"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":"280\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,"can_view_verify_list":true,"verifyList":[]},{"id":6,"client_id":3,"project_status":4,"project_progress":1,"budget":"1500000","profit_pct":"20","bargain_date":"2017-12-31","description":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762400\u4e2a\u70b9","created_by":1006,"created_at":"2017-02-09 16:37:28","updated_at":"2019-05-05 21:22:38","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762","collected":"0","status_updated_at":"2017-06-04 18:19:37.99473+08","success_rate":0,"comment":"\u6df1\u4fe1\u670d\u865a\u62df\u684c\u9762400\u4e2a\u70b9\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:22:38.953946+08","forecast_updated_at":"2019-05-05 21:22:38.953946+08","end_at":"2019-05-05 21:22:38","pinyin_shortcut":"sxfxnzm","creator":1006,"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":"300000.000000000000","remain":"3327 days 15:53:43.507026","progress_remain":"2627 days 12:50:42.54781","forecast_remain":"2627 days 12:50:42.54781","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 04:45:10.23018","issued_invoices":null,"client":{"id":3,"key":3,"name":"\u5317\u4eac\u4e50\u9014\u6c47\u8bda\u7f51\u7edc\u6280\u672f\u6709\u9650\u8d23\u4efb\u516c\u53f8-S","logo":null,"client_type":1,"client_class":43,"client_industry":19,"sales_rep":null,"salesRep":null,"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":19,"key":19,"name":"OTT"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":94,"product_type_id":94,"key":94,"name":"\u6df1\u4fe1\u670dAdesk","budget":"1500000","pct":"20","profit":"300000","project_id":6}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":null,"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3327,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":1500000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"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":"150\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,"can_view_verify_list":true,"verifyList":[]},{"id":7,"client_id":24,"project_status":3,"project_progress":10,"budget":"178850","profit_pct":"20","bargain_date":"2017-03-23","description":"388G94","created_by":1006,"created_at":"2017-02-09 16:38:27","updated_at":"2024-01-16 17:36:26","engineer_id":1015,"project_title":"388G94","collected":"178850","status_updated_at":"2017-05-31 17:51:55.880206+08","success_rate":100,"comment":"388G94\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:51:42.736202+08","forecast_updated_at":"2019-05-05 21:51:42.736202+08","end_at":"2019-05-05 21:51:42","pinyin_shortcut":"388G94","creator":1006,"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":"35770.0000000000000000","remain":"3331 days 16:21:25.62155","progress_remain":"2627 days 12:21:38.765554","forecast_remain":"2627 days 12:21:38.765554","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 05:13:15.590427","issued_invoices":"178850","client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":43,"client_industry":10,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":7,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"178850","pct":"20","profit":"35770","project_id":7}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":24,"from_project":7,"payment_collection_remind_ahead":null,"serial_no":"TSC-X-2017022001","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"178850","erp_un_settle_amount":"0","including_tax":true,"amount":"178850","contractScans":[{"id":12684,"object_type":105,"object_id":24,"attachment_id":795,"attachment":{"id":795,"key":795,"name":"327f8a9e-8fbb-3149-a35f-34a92a07eb18","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/327f8a9e-8fbb-3149-a35f-34a92a07eb18\/\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8\u201420170310\u2014178850.pdf","orig_name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8\u201420170310\u2014178850.pdf"}}],"receiptScans":[{"id":13379,"object_type":106,"object_id":24,"attachment_id":106,"attachment":{"id":106,"key":106,"name":"9b44257d-46ab-31a0-a26b-3deb991cfa72","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/9b44257d-46ab-31a0-a26b-3deb991cfa72\/\u4e2d\u822a\u946b\u6e2f.pdf","orig_name":"\u4e2d\u822a\u946b\u6e2f.pdf"}}],"verifyScans":[],"erpCollectTickets":[{"id":1157,"serial_no":"SKD-20170303-00001","wrote_date":null,"from_date":null,"handler":5300,"user_id":null,"client_id":24,"sales_contract_id":24,"supplier_id":null,"purchase_contract_id":null,"status":2,"abstract":null,"description":null,"verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"verify_at":"2017-03-03 17:30:27","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"178850.00","settle_amount":"178850.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2017-03-03 17:30:27","updated_at":"2017-03-03 17:30:27","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"11157","key":"11157","contract_id":24,"value":"178850.00","created_by":null,"collected_date":"","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":766,"key":766,"contract_id":24,"value":"178850.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":178850},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":13,"serial_no":"XSDD-20170303-00001","from_date":null,"wrote_date":"2017-03-23","handler":1010,"client_id":24,"purchase_contract_id":null,"project_id":7,"sales_contract_id":24,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8ba1\u7b97","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 21:51:42","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"178850","created_by":1010,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2017-03-03 17:30:27","updated_at":"2019-05-05 21:51:42","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3331,"progress_remain_display":2627,"forecast_remain_display":2627,"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":815,"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":"17.89\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,"can_view_verify_list":true,"verifyList":[]},{"id":8,"client_id":16,"project_status":5,"project_progress":1,"budget":"30000","profit_pct":"65","bargain_date":"2017-04-30","description":"webex 100\u65b9","created_by":1006,"created_at":"2017-02-09 16:43:11","updated_at":"2019-05-05 21:48:59","engineer_id":1017,"project_title":"webex \u670d\u52a1","collected":"0","status_updated_at":"2017-06-12 12:28:34.628695+08","success_rate":10,"comment":"webex 100\u65b9\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:48:59.728356+08","forecast_updated_at":"2019-05-05 21:48:59.728356+08","end_at":"2019-05-05 21:48:59","pinyin_shortcut":"webexfw","creator":1006,"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":"19500.0000000000000000","remain":"3319 days 21:44:46.873061","progress_remain":"2627 days 12:24:21.7734","forecast_remain":"2627 days 12:24:21.7734","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 05:05:48.295169","issued_invoices":null,"client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":80,"client_industry":25,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":8,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"0","pct":"0","profit":"0","project_id":8},{"id":91,"product_type_id":91,"key":91,"name":"\u534f\u4f5c","budget":"0","pct":"0","profit":"0","project_id":8}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3319,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":30000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"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,"can_view_verify_list":true,"verifyList":[]},{"id":10,"client_id":16,"project_status":5,"project_progress":1,"budget":"100000","profit_pct":"40","bargain_date":"2017-04-30","description":"VPN\u8bbe\u59072","created_by":1006,"created_at":"2017-02-09 16:44:31","updated_at":"2019-05-05 21:48:19","engineer_id":null,"project_title":"VPN\u8bbe\u5907","collected":"0","status_updated_at":"2017-06-02 18:14:25.852963+08","success_rate":10,"comment":"VPN\u8bbe\u59072\r\n","contract_type":1,"progress_updated_at":"2019-05-05 21:48:19.077071+08","forecast_updated_at":"2019-05-05 21:48:19.077071+08","end_at":"2019-05-05 21:48:19","pinyin_shortcut":"VPNsb","creator":1006,"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":"40000.0000000000000000","remain":"3329 days 15:58:55.648793","progress_remain":"2627 days 12:25:02.424685","forecast_remain":"2627 days 12:25:02.424685","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 05:03:48.02239","issued_invoices":null,"client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":null,"client_type":1,"client_class":80,"client_industry":25,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":80,"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237","notice_days":30,"color":"#0EE315"},"clientIndustry":{"id":25,"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[],"projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"projectProgress":{"id":1,"key":1,"name":"\u521d\u76f8\u8bc6","description":"\u5411\u5ba2\u6237\u4ecb\u7ecd\u81ea\u8eab\u4ef7\u503c\uff1a\n1.\u4ea7\u54c1\u9009\u578b\n2.\u6210\u672c\u4f18\u5316\n3.\u4ea7\u54c1\u4ea4\u4ed8\n4.\u540e\u671f\u8fd0\u7ef4"},"projectProductTypes":[{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"100000","pct":"40","profit":"40000","project_id":10}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":182,"key":182,"name":"\u56f4\u6807"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3329,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":100000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":null,"project_status_display":"\u5546\u673a\u6401\u7f6e","is_collected":false,"bgcolor":"#222222","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":null,"can_view_product":true,"budget_display":"10\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,"can_view_verify_list":true,"verifyList":[]},{"id":11,"client_id":25,"project_status":3,"project_progress":10,"budget":"5400","profit_pct":"81","bargain_date":"2018-03-12","description":"\uff08DS1\uff0cAV6\uff0cofficescan1\uff09\u5b89\u88c5\u670d\u52a1\u8d39","created_by":1006,"created_at":"2017-02-09 16:56:15","updated_at":"2021-06-28 15:24:44","engineer_id":null,"project_title":"\u8d8b\u52bf\u6740\u6bd2","collected":"5400","status_updated_at":"2018-05-18 15:03:58.941822+08","success_rate":100,"comment":"\uff08DS1\uff0cAV6\uff0cofficescan1\uff09\u5b89\u88c5\u670d\u52a1\u8d39\r\n","contract_type":2,"progress_updated_at":"2019-05-05 21:13:26.260253+08","forecast_updated_at":"2019-05-05 21:13:26.260253+08","end_at":"2019-05-05 21:13:26","pinyin_shortcut":"qssd","creator":1006,"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":"4374.0000000000000000","remain":"2979 days 19:09:22.559934","progress_remain":"2627 days 12:59:55.241503","forecast_remain":"2627 days 12:59:55.241503","lost_contact_days":null,"last_contact":"","last_arrive_days":null,"last_arrive":null,"duration":"815 days 04:17:11.188354","issued_invoices":"5400","client":{"id":25,"key":25,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6559\u5e08\u8fdb\u4fee\u5b66\u6821","logo":null,"client_type":1,"client_class":47,"client_industry":2,"sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientType":{"id":1,"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":2,"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"}},"usedClient":null,"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectProductTypes":[{"id":22,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"5400","pct":"81","profit":"4374","project_id":11}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"projectCreator":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"casePoints":null,"workLogCount":null,"caseCount":null,"salesTimeCount":null,"implementTimeCount":null,"presalesTimeCount":null,"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":{"id":479,"from_project":11,"payment_collection_remind_ahead":"00:00:00","serial_no":"-","is_settle":false,"is_deliver":false,"is_outbound":false,"erp_settle_amount":"5400","erp_un_settle_amount":"0","including_tax":true,"amount":"5400","contractScans":[{"id":12730,"object_type":105,"object_id":479,"attachment_id":1168,"attachment":{"id":1168,"key":1168,"name":"95a096ed-4691-38bd-990a-05e8083727ac","extension":"pdf","path":"\/v2\/attachment\/preview\/wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm\/95a096ed-4691-38bd-990a-05e8083727ac\/\u5f00\u83b1\u5174\u4e1a.pdf","orig_name":"\u5f00\u83b1\u5174\u4e1a.pdf"}}],"receiptScans":[],"verifyScans":[],"erpCollectTickets":[{"id":788,"serial_no":"SKD-20180417-00001","wrote_date":null,"from_date":null,"handler":1005,"user_id":null,"client_id":25,"sales_contract_id":479,"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":"2018-04-17 10:05:18","stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"5400.00","settle_amount":"5400.00","created_by":null,"stop_description":null,"is_settle":true,"is_old":true,"created_at":"2018-04-17 10:05:18","updated_at":"2018-04-17 10:05:18","paid_amount":null,"contact_id":null,"bank_settle_at":null,"print_times":null}],"salesContractPayments":[{"id":"1788","key":"1788","contract_id":479,"value":"5400.00","created_by":null,"collected_date":"","createdBy":null,"pct":100}],"salesContractInvoices":[{"id":317,"key":317,"contract_id":479,"value":"5400.00","attachment_id":null,"from_date":null,"attachment":null}],"salesContractPaymentCollectionRemindDates":[],"salesContractPaymentCollectionRemindReceivers":[],"salesSupplierRels":[],"payment_collection_remind_ahead_display":"\u65e0","invoiced":5400},"projectRemindReceivers":[],"projectProductRels":[],"commentCount":{"object_id":11,"comment":1},"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":{"id":176,"serial_no":"XSDD-20180417-00001","from_date":null,"wrote_date":"2018-03-12","handler":5015,"client_id":25,"purchase_contract_id":null,"project_id":11,"sales_contract_id":479,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u6280\u672f\u670d\u52a1\u8d39","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2019-05-05 21:13:26","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"5400","created_by":5015,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2018-04-17 10:05:18","updated_at":"2019-05-05 21:13:26","print_times":null},"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":2979,"progress_remain_display":2627,"forecast_remain_display":2627,"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":815,"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":"5400","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,"can_view_verify_list":true,"verifyList":[]},{"id":12,"client_id":18,"project_status":4,"project_progress":7,"budget":"800000","profit_pct":"20","bargain_date":"2017-11-10","description":"Netapp FAST 8200 20T+29148S +\u90ae\u4ef6\u53caVEEAM\u6210\u5355\u7387\uff1a80%\uff0c\u5931\u8d25\u539f\u56e0\uff1a\u56e0\u4e3a\u6211\u4eec\u5bf9\u8f6f\u4ef6\u90e8\u4efd\u7684Excheng\u65b9\u6848\u6ca1\u6709\uff0c\u4e0d\u4e13\u4e1a\uff0c\u5ba2\u6237\u611f\u89c9\u6211\u4eec\u4e0d\u91cd\u89c6\u53ca\u6280\u672f\u80fd\u529b\u4e0d\u884c\u3002\u6240\u4ee5\u6ca1\u9009\u62e9\u6211\u4eec\u3002","created_by":1004,"created_at":"2017-02-09 17:16:23","updated_at":"2021-08-24 22:16:38","engineer_id":1015,"project_title":"\u5b58\u50a8\u5907\u4efd\u6539\u9020","collected":"0","status_updated_at":"2017-08-07 20:15:31.009763+08","success_rate":0,"comment":"Netapp FAST 8200 20T+2*9148S +\u90ae\u4ef6\u53caVEEAM\u6210\u5355\u7387\uff1a80%\uff0c\u5931\u8d25\u539f\u56e0\uff1a\u56e0\u4e3a\u6211\u4eec\u5bf9\u8f6f\u4ef6\u90e8\u4efd\u7684Excheng\u65b9\u6848\u6ca1\u6709\uff0c\u4e0d\u4e13\u4e1a\uff0c\u5ba2\u6237\u611f\u89c9\u6211\u4eec\u4e0d\u91cd\u89c6\u53ca\u6280\u672f\u80fd\u529b\u4e0d\u884c\u3002\u6240\u4ee5\u6ca1\u9009\u62e9\u6211\u4eec\u3002\r\n","contract_type":1,"progress_updated_at":"2019-05-05 20:26:24.710697+08","forecast_updated_at":"2019-05-05 20:26:24.710697+08","end_at":"2019-05-05 20:26:24","pinyin_shortcut":"ccbfgz","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":"160000.0000000000000000","remain":"3263 days 13:57:50.491993","progress_remain":"2627 days 13:46:56.791059","forecast_remain":"2627 days 13:46:56.791059","lost_contact_days":"1785.8079340481","last_contact":"2021-08-24 14:49:56","last_arrive_days":"1785.8079340481","last_arrive":"2021-08-24 14:49:56+08","duration":"815 days 03:10:01.247478","issued_invoices":null,"client":{"id":18,"key":18,"name":"\u4e2d\u5fb7\u8bc1\u5238\u6709\u9650\u8d23\u4efb\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"clientType":{"id":5,"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"usedClient":null,"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"projectArchitects":[{"project_id":12,"value":"1","key":1015,"name":"\u5434\u660a"}],"projectStatus":{"id":4,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a"},"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":69,"product_type_id":69,"key":69,"name":"\u5907\u4efd","budget":"0","pct":"0","profit":"0","project_id":12},{"id":71,"product_type_id":71,"key":71,"name":"\u5176\u4ed6","budget":"0","pct":"0","profit":"0","project_id":12},{"id":83,"product_type_id":83,"key":83,"name":"\u601d\u79d1\u7f51\u7edc","budget":"0","pct":"0","profit":"0","project_id":12},{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"0","pct":"0","profit":"0","project_id":12}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"opportunityFrom":{"id":179,"key":179,"name":"\u8001\u5ba2\u6237"},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"createdBy":{"id":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":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"casePoints":{"project_id":12,"points":"50"},"workLogCount":{"project_id":12,"count":2},"caseCount":{"project_id":12,"count":1},"salesTimeCount":{"project_id":12,"hours":"0.605833333333333","times":1},"implementTimeCount":null,"presalesTimeCount":{"project_id":12,"sum":"0.216666666666667","times":"1"},"engineerTimeCount":null,"reimbursementAmountSum":null,"buildContract":null,"projectRemindReceivers":[],"projectProductRels":[],"commentCount":null,"unreadComments":null,"fromContact":null,"projectContactPoints":[],"erpSalesOrder":null,"projectUsedClient":null,"erpSalesOrderVerify":null,"remain_display":3263,"progress_remain_display":2627,"forecast_remain_display":2627,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalNumber":0,"unissued_invoice":800000,"is_exceeded":false,"can_update":true,"can_delete":true,"unread":0,"last_arrive_days_display":"4\u5e74\u524d","project_status_display":"\u5546\u673a\u5931\u8d25","is_collected":false,"bgcolor":"#e5000a","can_invoice":false,"can_payment":false,"duration_display":815,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","can_change_status":true,"is_admin":true,"lost_contact_days_display":"4\u5e74\u524d","can_view_product":true,"budget_display":"80\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,"can_view_verify_list":true,"verifyList":[]}],"pagenation":{"totalcount":3161,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.127","ua":"jinchangxiao\/2.3.158 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-07-15 10:13:21', 243475968) RETURNING "id"
10:13:21.619	3.8 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (122, 795, 672, 1168, 665)
10:13:21.607	3.4 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "c"."project_id"
10:13:21.623	3.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (229, 2, 311, 24, 479))
10:13:21.616	3.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (229, 2, 311, 24, 479))
10:13:21.627	3.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (229, 2, 311, 24, 479))
10:13:21.611	2.3 ms	yii\db\Command::query	SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "project_id"
10:13:21.632	2.0 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 (229, 2, 311, 24, 479) ORDER BY "id" DESC
10:13:21.595	1.7 ms	yii\db\Command::query	SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12) GROUP BY "project_id"
10:13:21.575	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.630	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE ("status"=2) AND ("sales_contract_id" IN (229, 2, 311, 24, 479)) ORDER BY "id" DESC
10:13:21.574	0.9 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.578	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.678	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12))
10:13:21.580	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.445	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
10:13:21.641	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12) ORDER BY "id"
10:13:21.447	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:13:21.638	0.6 ms	yii\db\Command::query	SELECT "id", "sales_contract_id", "status" FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (229, 2, 311, 24, 479) ORDER BY "id" DESC
10:13:21.680	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12))
10:13:21.572	0.6 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12) ORDER BY "contribution" DESC, "engineer_id"
10:13:21.568	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" IN (5, 12, 23, 20, 3, 24, 16, 25, 18)
10:13:21.635	0.6 ms	yii\db\Command::query	SELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (229, 2, 311, 24, 479)
10:13:21.577	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 (100, 97, 96, 112, 165, 179, 142, 213, 2, 7, 212, 1, 182, 94, 229, 5, 215, 133, 136, 135, 197, 194, 137, 139, 140, 129, 8, 198, 201, 164, 184, 189, 153, 185, 191, 199, 205, 204, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 6, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 332, 311, 315, 316, 2100000000, 349, 326, 359, 369, 377, 166, 356, 327, 352, 432, 429, 433, 402, 400, 340, 416, 380, 430, 401, 134, 399, 438, 439, 386)) ORDER BY "sort"
10:13:21.597	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"=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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "project_id"
10:13:21.636	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (229, 2, 311, 24, 479)
10:13:21.585	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (5, 12, 23, 20, 3, 24, 16, 25, 18)
10:13:21.634	0.5 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 (229, 2, 311, 24, 479) ORDER BY "remind_date"
10:13:21.581	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (100, 97, 96, 112, 165, 179, 142, 213, 2, 7, 212, 1, 182, 94, 229, 5, 215, 133, 136, 135, 197, 194, 137, 139, 140, 129, 8, 198, 201, 164, 184, 189, 153, 185, 191, 199, 205, 204, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 6, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 332, 311, 315, 316, 2100000000, 349, 326, 359, 369, 377, 166, 356, 327, 352, 432, 429, 433, 402, 400, 340, 416, 380, 430, 401, 134, 399, 438, 439, 386)) ORDER BY "sort"
10:13:21.611	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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "project_id"
10:13:21.579	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (100, 97, 96, 112, 165, 179, 142, 213, 2, 7, 212, 1, 182, 94, 229, 5, 215, 133, 136, 135, 197, 194, 137, 139, 140, 129, 8, 198, 201, 164, 184, 189, 153, 185, 191, 199, 205, 204, 226, 231, 207, 224, 223, 214, 219, 9, 208, 210, 211, 227, 216, 6, 93, 228, 11, 209, 217, 230, 218, 10, 221, 225, 222, 332, 311, 315, 316, 2100000000, 349, 326, 359, 369, 377, 166, 356, 327, 352, 432, 429, 433, 402, 400, 340, 416, 380, 430, 401, 134, 399, 438, 439, 386)) ORDER BY "sort"
10:13:21.595	0.5 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)) GROUP BY "project_id"
10:13:21.634	0.4 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 (229, 2, 311, 24, 479) ORDER BY "id"
10:13:21.637	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (46, 147, 68, 122, 163, 146, 104, 204, 95, 675)
10:13:21.677	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.679	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.444	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:13:21.614	0.4 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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.641	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 (2, 3, 4, 5, 6, 7, 8, 10, 11, 12)
10:13:21.639	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (176, 119, 83, 13, 1) ORDER BY "id"
10:13:21.638	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (285, 393, 224, 303, 370, 358, 340, 288, 388, 337, 295, 375)
10:13:21.569	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5311, 5300, 1005)
10:13:21.570	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1004, 1005, 5300))
10:13:21.626	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (676, 26, 106, 1098)
10:13:21.583	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1006, 1004, 1005, 1003))
10:13:21.582	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1003, 1005, 1006)
10:13:21.584	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1003, 1005, 1006)
10:13:21.585	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5311, 5300, 1005)
10:13:21.640	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (176, 119, 83, 13, 1) ORDER BY "id"
10:13:21.573	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 4, 5)
10:13:21.584	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1006, 1004, 1005, 1003))
10:13:21.586	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1004, 1005, 5300))
10:13:21.571	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (6, 10, 5, 2, 25, 19)
10:13:21.640	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (176, 119, 83, 13, 1) ORDER BY "id"
10:13:21.571	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (47, 43, 80)
10:13:21.574	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (10, 2, 1, 7)
10:13:21.570	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (6, 5, 1)
10:13:21.572	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
10:13:21.583	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1