ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6877a0567f18b: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-16 08:51:34 pm by 117.176.186.93

Performance Profiling

Total processing time: 107 ms; Peak memory: 5.175 MB. Show Profiling Timeline

总计46条数据
TimeDurationCategoryInfo
  
20:51:34.56017.7 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)) GROUP BY "object_id"
20:51:34.60515.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)) GROUP BY "object_id"
20:51:34.54210.6 msyii\db\Command::querySELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."signed_at", "c"."created_at" DESC LIMIT 10 OFFSET 10
20:51:34.5329.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE (true) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1000))) GROUP BY "c"."id" ORDER BY "c"."signed_at", "c"."created_at" DESC) "c"
20:51:34.5543.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (77, 10, 82, 122, 771, 145, 119, 788, 27)
20:51:34.5783.6 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (136, 34, 147, 3, 40, 101, 42, 26, 21)
20:51:34.6223.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/sales-contract/list', '{"Filter":{"name":"signed_at","sort":"ASC"},"SalesContractSearch":{"contract_type":"","handler":""},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","page":"2","posttime":"1752670336","token":"c8bb37ebaae03f12a71984e91dfc6b73","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":52,"client_id":16,"signed_at":"2017-01-13","amount":"51500","handler":1006,"description":"\u601d\u79d1\u65e0\u7ebf","created_by":1010,"created_at":"2017-03-24 20:07:25","updated_at":"2021-06-24 14:27:32","contract_scan":77,"receipt_scan":360,"contract_type":1,"project_id":136,"valid_date":null,"expire_date":"2018-01-12","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":136,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":2742,"passed":2,"client":{"id":16,"key":16,"name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":{"id":77,"key":77,"name":"65be0085-675a-3ec7-80fe-2be93f99b5ac","orig_name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170324\u201451500.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/65be0085-675a-3ec7-80fe-2be93f99b5ac\/\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170324\u201451500.pdf","download":"\/vue\/attachment\/download?name=65be0085-675a-3ec7-80fe-2be93f99b5ac"},"receiptScan":{"id":360,"key":360,"name":"7f4dacd3-a111-3619-a030-30e37d5a56d9","orig_name":"\u6e38\u5b66\u7f51\u201420170125.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/7f4dacd3-a111-3619-a030-30e37d5a56d9\/\u6e38\u5b66\u7f51\u201420170125.pdf","download":"\/vue\/attachment\/download?name=7f4dacd3-a111-3619-a030-30e37d5a56d9"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":52,"comment":5},"project":{"id":136,"key":136,"name":"\u601d\u79d1\u65e0\u7ebf"},"fromProject":{"id":136,"key":136,"name":"\u601d\u79d1\u65e0\u7ebf","description":"\u601d\u79d1\u65e0\u7ebf","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-01-12","collected":"51500.00","profit_pct":"30","budget":"51500","projectProductTypes":[{"id":3743,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"51500","pct":"30","project_id":136,"profit":"15450"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":15450,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":7972,"user_id":5311,"key":5311,"contract_id":52,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":472,"key":472,"contract_id":52,"value":"51500.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"51500.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":239,"key":239,"contract_id":52,"value":"51500.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12641,"object_type":105,"object_id":52,"attachment_id":77,"attachment":{"id":77,"key":77,"name":"65be0085-675a-3ec7-80fe-2be93f99b5ac","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/65be0085-675a-3ec7-80fe-2be93f99b5ac\/\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170324\u201451500.pdf","orig_name":"\u5317\u4eac\u6e38\u5b66\u7f51\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8\u201420170324\u201451500.pdf"}}],"receiptScans":[{"id":13341,"object_type":106,"object_id":52,"attachment_id":360,"attachment":{"id":360,"key":360,"name":"7f4dacd3-a111-3619-a030-30e37d5a56d9","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/7f4dacd3-a111-3619-a030-30e37d5a56d9\/\u6e38\u5b66\u7f51\u201420170125.pdf","orig_name":"\u6e38\u5b66\u7f51\u201420170125.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":51500,"un_invoiced":0,"collected":51500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":7,"client_id":6,"signed_at":"2017-01-13","amount":"10259","handler":1008,"description":"10\u697c\u9700\u8981\u505a\u65e0\u7ebf\u7f51\u7edc\uff0c\u548c4\u697c\u8fde\u63a5\uff0c\u5ba2\u6237\u8bf4\u4eca\u5e74\u5e74\u524d\u505a\uff08\u5408\u540c\u7b7e\u8ba2\uff0c\u6b3e\u5df2\u7ecf\u5230\u8d26\uff0c\u5ba2\u6237\u5b9e\u65bd\u65f6\u95f4\u4e0d\u786e\u5b9a\uff09","created_by":1000,"created_at":"2017-02-13 09:09:17","updated_at":"2021-06-24 14:26:48","contract_scan":10,"receipt_scan":258,"contract_type":1,"project_id":34,"valid_date":null,"expire_date":"2018-01-12","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"TSC-X-2017011301","payment_collection_remind_ahead":"","from_project":34,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":2742,"passed":2,"client":{"id":6,"key":6,"name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8(\u5317\u4eac\u5e02\u8054\u5fb7\u5f8b\u5e08\u4e8b\u52a1\u6240)","logo":"","sales_rep":null,"salesRep":null},"contractScan":{"id":10,"key":10,"name":"149a1ba5-dac0-3dac-8fa6-f8563414fcfd","orig_name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8\u201420170113\u201410259.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/149a1ba5-dac0-3dac-8fa6-f8563414fcfd\/\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8\u201420170113\u201410259.pdf","download":"\/vue\/attachment\/download?name=149a1ba5-dac0-3dac-8fa6-f8563414fcfd"},"receiptScan":{"id":258,"key":258,"name":"17dcf669-9116-3ecf-9fb6-d2fcef5b2ae1","orig_name":"\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/17dcf669-9116-3ecf-9fb6-d2fcef5b2ae1\/\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743.pdf","download":"\/vue\/attachment\/download?name=17dcf669-9116-3ecf-9fb6-d2fcef5b2ae1"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":7,"comment":5},"project":{"id":34,"key":34,"name":"\u65e0\u7ebf\u7f51\u7edc"},"fromProject":{"id":34,"key":34,"name":"\u65e0\u7ebf\u7f51\u7edc","description":"10\u697c\u9700\u8981\u505a\u65e0\u7ebf\u7f51\u7edc\uff0c\u548c4\u697c\u8fde\u63a5\uff0c\u5ba2\u6237\u8bf4\u4eca\u5e74\u5e74\u524d\u505a\uff08\u5408\u540c\u7b7e\u8ba2\uff0c\u6b3e\u5df2\u7ecf\u5230\u8d26\uff0c\u5ba2\u6237\u5b9e\u65bd\u65f6\u95f4\u4e0d\u786e\u5b9a\uff09","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-01-20","collected":"10259.00","profit_pct":"20","budget":"10259","projectProductTypes":[{"id":3676,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"8259.00","pct":"20","project_id":34,"profit":"1651.8"},{"id":2034,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"2000.00","pct":"20","project_id":34,"profit":"400"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":2051.8,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":187,"key":187,"contract_id":7,"value":"10259.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"10259.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":319,"key":319,"contract_id":7,"value":"10259.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12582,"object_type":105,"object_id":7,"attachment_id":10,"attachment":{"id":10,"key":10,"name":"149a1ba5-dac0-3dac-8fa6-f8563414fcfd","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/149a1ba5-dac0-3dac-8fa6-f8563414fcfd\/\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8\u201420170113\u201410259.pdf","orig_name":"\u5317\u4eac\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743\u4ee3\u7406\u6709\u9650\u516c\u53f8\u201420170113\u201410259.pdf"}}],"receiptScans":[{"id":13287,"object_type":106,"object_id":7,"attachment_id":258,"attachment":{"id":258,"key":258,"name":"17dcf669-9116-3ecf-9fb6-d2fcef5b2ae1","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/17dcf669-9116-3ecf-9fb6-d2fcef5b2ae1\/\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743.pdf","orig_name":"\u8054\u5fb7\u77e5\u8bc6\u4ea7\u6743.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":10259,"un_invoiced":0,"collected":10259,"un_collected":0,"is_collected":true,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":59,"client_id":206,"signed_at":"2017-01-17","amount":"17800","handler":1008,"description":"DELL\u670d\u52a1\u5668\u5185\u5b5816G*6 \u56fa\u6001\u786c\u76d8 800G*1","created_by":1010,"created_at":"2017-03-29 12:04:07","updated_at":"2019-01-21 11:21:03","contract_scan":82,"receipt_scan":257,"contract_type":1,"project_id":147,"valid_date":null,"expire_date":"2018-01-16","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"RWS-TS-20170117","payment_collection_remind_ahead":null,"from_project":147,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":2738,"passed":2,"client":{"id":206,"key":206,"name":"\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8-\u62d2\u7edd","logo":"","sales_rep":null,"salesRep":null},"contractScan":{"id":82,"key":82,"name":"6d526646-77e4-3a3f-82bc-016794c8f071","orig_name":"\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420170117\u201417800.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6d526646-77e4-3a3f-82bc-016794c8f071\/\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420170117\u201417800.pdf","download":"\/vue\/attachment\/download?name=6d526646-77e4-3a3f-82bc-016794c8f071"},"receiptScan":{"id":257,"key":257,"name":"179a9dcc-35bb-39e2-82c2-a64dc9f1c179","orig_name":"\u5982\u6587\u601d.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/179a9dcc-35bb-39e2-82c2-a64dc9f1c179\/\u5982\u6587\u601d.pdf","download":"\/vue\/attachment\/download?name=179a9dcc-35bb-39e2-82c2-a64dc9f1c179"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":59,"comment":5},"project":{"id":147,"key":147,"name":"DELL\u670d\u52a1\u5668\u5185\u5b58"},"fromProject":{"id":147,"key":147,"name":"DELL\u670d\u52a1\u5668\u5185\u5b58","description":"DELL\u670d\u52a1\u5668\u5185\u5b5816G*6 \u56fa\u6001\u786c\u76d8 800G*1","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-01-17","collected":"17800.00","profit_pct":"40","budget":"17800","projectProductTypes":[{"id":4122,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"17800","pct":"40","project_id":147,"profit":"7120"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":7120,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":348,"key":348,"contract_id":59,"value":"17800.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"17800.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":37,"key":37,"contract_id":59,"value":"17800.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12581,"object_type":105,"object_id":59,"attachment_id":82,"attachment":{"id":82,"key":82,"name":"6d526646-77e4-3a3f-82bc-016794c8f071","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6d526646-77e4-3a3f-82bc-016794c8f071\/\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420170117\u201417800.pdf","orig_name":"\u5317\u4eac\u5982\u6587\u601d\u79d1\u6280\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\u201420170117\u201417800.pdf"}}],"receiptScans":[{"id":13286,"object_type":106,"object_id":59,"attachment_id":257,"attachment":{"id":257,"key":257,"name":"179a9dcc-35bb-39e2-82c2-a64dc9f1c179","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/179a9dcc-35bb-39e2-82c2-a64dc9f1c179\/\u5982\u6587\u601d.pdf","orig_name":"\u5982\u6587\u601d.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":17800,"un_invoiced":0,"collected":17800,"un_collected":0,"is_collected":true,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2,"client_id":12,"signed_at":"2017-02-09","amount":"16150","handler":1003,"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":1010,"created_at":"2017-02-09 12:02:04","updated_at":"2021-06-25 10:23:40","contract_scan":122,"receipt_scan":26,"contract_type":1,"project_id":3,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"-","payment_collection_remind_ahead":"","from_project":3,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":{"id":122,"key":122,"name":"e66c2a59-8b1c-39b9-bdcf-39902aea1aa1","orig_name":"SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/e66c2a59-8b1c-39b9-bdcf-39902aea1aa1\/SMC_\u4e2d\u56fd_\u6709\u9650\u516c\u53f8\u201420170322\u201416150.pdf","download":"\/vue\/attachment\/download?name=e66c2a59-8b1c-39b9-bdcf-39902aea1aa1"},"receiptScan":{"id":26,"key":26,"name":"9c77fe3d-28c3-35c8-b869-2dbbf33060f1","orig_name":"smc16150.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9c77fe3d-28c3-35c8-b869-2dbbf33060f1\/smc16150.pdf","download":"\/vue\/attachment\/download?name=9c77fe3d-28c3-35c8-b869-2dbbf33060f1"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":3,"key":3,"name":"hp\u5de5\u4f5c\u7ad9"},"fromProject":{"id":3,"key":3,"name":"hp\u5de5\u4f5c\u7ad9","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","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-02-09","collected":"16150.00","profit_pct":"17","budget":"16150","projectProductTypes":[{"id":3888,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"16150","pct":"17","project_id":3,"profit":"2745.5"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":2745.5,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":7472,"user_id":5300,"key":5300,"contract_id":2,"user":{"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":199,"key":199,"contract_id":2,"value":"16150.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"16150.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":446,"key":446,"contract_id":2,"value":"16150.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"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\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/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\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9c77fe3d-28c3-35c8-b869-2dbbf33060f1\/smc16150.pdf","orig_name":"smc16150.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":16150,"un_invoiced":0,"collected":16150,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":9,"client_id":49,"signed_at":"2017-02-14","amount":"374200","handler":1003,"description":"1.\u5149\u7ea4\u7ebf5\u7c73 4\u6761\r\n2.\u5149\u7ea4\u7ebf3\u7c73 2\u6761\r\n3.\u5149\u7ea4\u7ebf40\u7c73 2\u6761\r\n4.\u5c71\u6cfd\u516d\u7c7b\u7f51\u7ebf3\u7c73 140\u6761\r\n5.\u601d\u79d1 ws-2960x-48ts-L 3\u53f0\r\n6.\u601d\u79d1 ws-2960x-48td-L 1\u53f0\r\n7.\u601d\u79d1 sfp-10g0sr \u6a21\u5757 36\u4e2a\r\n8.\u601d\u79d1 glc-sx-mmd= \u6a21\u5757 12\u4e2a\r\n9.\u601d\u79d1 glc-t RJ45\u6a21\u5757 100\u4e2a\r\n10.\u601d\u79d1 N3K-c3548P-10GX 4\u53f0","created_by":1010,"created_at":"2017-02-15 09:58:16","updated_at":"2021-06-28 14:17:50","contract_scan":771,"receipt_scan":23,"contract_type":1,"project_id":40,"valid_date":null,"expire_date":"2018-02-13","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"20170214-01","payment_collection_remind_ahead":"","from_project":40,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":2710,"passed":2,"client":{"id":49,"key":49,"name":"\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u96c6\u6210\u5546-)S","logo":"","sales_rep":null,"salesRep":null},"contractScan":{"id":771,"key":771,"name":"56e740ff-01d7-3d78-a251-31512b0e46f9","orig_name":"\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170214\u2014374200.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/56e740ff-01d7-3d78-a251-31512b0e46f9\/\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170214\u2014374200.pdf","download":"\/vue\/attachment\/download?name=56e740ff-01d7-3d78-a251-31512b0e46f9"},"receiptScan":{"id":23,"key":23,"name":"b2ed85bd-2f0d-32af-943e-2938539707d5","orig_name":"\u4e2d\u4f01\u52a8\u529b.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b2ed85bd-2f0d-32af-943e-2938539707d5\/\u4e2d\u4f01\u52a8\u529b.pdf","download":"\/vue\/attachment\/download?name=b2ed85bd-2f0d-32af-943e-2938539707d5"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":9,"comment":5},"project":{"id":40,"key":40,"name":"(\u672a\u8bbe\u7f6e)"},"fromProject":{"id":40,"key":40,"name":"(\u672a\u8bbe\u7f6e)","description":"1.\u5149\u7ea4\u7ebf5\u7c73 4\u6761\r\n2.\u5149\u7ea4\u7ebf3\u7c73 2\u6761\r\n3.\u5149\u7ea4\u7ebf40\u7c73 2\u6761\r\n4.\u5c71\u6cfd\u516d\u7c7b\u7f51\u7ebf3\u7c73 140\u6761\r\n5.\u601d\u79d1 ws-2960x-48ts-L 3\u53f0\r\n6.\u601d\u79d1 ws-2960x-48td-L 1\u53f0\r\n7.\u601d\u79d1 sfp-10g0sr \u6a21\u5757 36\u4e2a\r\n8.\u601d\u79d1 glc-sx-mmd= \u6a21\u5757 12\u4e2a\r\n9.\u601d\u79d1 glc-t RJ45\u6a21\u5757 100\u4e2a\r\n10.\u601d\u79d1 N3K-c3548P-10GX 4\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-02-17","collected":"374200.00","profit_pct":"9","budget":"374200","projectProductTypes":[{"id":3692,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"374200","pct":"9","project_id":40,"profit":"33678"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":33678,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":588,"key":588,"contract_id":9,"value":"374200.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"374200.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":213,"key":213,"contract_id":9,"value":"374200.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12618,"object_type":105,"object_id":9,"attachment_id":771,"attachment":{"id":771,"key":771,"name":"56e740ff-01d7-3d78-a251-31512b0e46f9","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/56e740ff-01d7-3d78-a251-31512b0e46f9\/\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170214\u2014374200.pdf","orig_name":"\u4e2d\u4f01\u52a8\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u201420170214\u2014374200.pdf"}}],"receiptScans":[{"id":13321,"object_type":106,"object_id":9,"attachment_id":23,"attachment":{"id":23,"key":23,"name":"b2ed85bd-2f0d-32af-943e-2938539707d5","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/b2ed85bd-2f0d-32af-943e-2938539707d5\/\u4e2d\u4f01\u52a8\u529b.pdf","orig_name":"\u4e2d\u4f01\u52a8\u529b.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":374200,"un_invoiced":0,"collected":374200,"un_collected":0,"is_collected":true,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":54,"client_id":38,"signed_at":"2017-02-15","amount":"47080","handler":1008,"description":"ProDesk 280G2 MT New Core i3-6100(3.7G\/3M\/2\u6838)\/8G(4G DDR4 2133 * 2)\/500G(SATA)\/\u8d85\u8584DVDRW\/Windows 10 Home 64\u4f4d FDD\/USB KB\/USB Optical Mouse\/\u65b0180W \u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee 11\u53f0\r\n\r\nV244h (23.8\"\u5bbd\u5c4f16:9 LED\u80cc\u5149VA\u6db2\u6676\u663e\u793a\u5668,VGA,DVI-D,HDMI\uff08\u652f\u6301HDCP\uff09\u63a5\u53e3,\u65e0DVI\u7ebf\u7f06,250nits,3000:1,6\u767e\u4e07:1(\u52a8\u6001\u5bf9\u6bd4\u5ea6),7ms(\u7070\u5ea6),1920x1080)\u7f8e\u56fd\u7535\u5b50\u4ea7\u54c1\u73af\u5883\u5f71\u54cd\u8bc4\u4ef7\u5de5\u5177EPEAT\u94f6\u5956 11\u53f0","created_by":1028,"created_at":"2017-03-27 13:32:49","updated_at":"2021-06-28 14:18:41","contract_scan":145,"receipt_scan":353,"contract_type":1,"project_id":101,"valid_date":null,"expire_date":"2020-02-14","sla":"","remind_ahead":"","expire_remind_ahead":"15 days","expire_reminded":true,"serial_no":"AMS-TS-20170215","payment_collection_remind_ahead":"","from_project":101,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":1979,"passed":2,"client":{"id":38,"key":38,"name":"\u5965\u871c\u601d\u5546\u8d38(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":null,"salesRep":null},"contractScan":{"id":145,"key":145,"name":"5d5f7f1d-3e6d-3981-8ad6-1b606535fbc5","orig_name":"\u5965\u871c\u601d\u5546\u8d38\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170310\u201447080.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/5d5f7f1d-3e6d-3981-8ad6-1b606535fbc5\/\u5965\u871c\u601d\u5546\u8d38\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170310\u201447080.pdf","download":"\/vue\/attachment\/download?name=5d5f7f1d-3e6d-3981-8ad6-1b606535fbc5"},"receiptScan":{"id":353,"key":353,"name":"88e669c9-b8d5-3809-b9c3-fb76a247cf5a","orig_name":"\u5965\u871c\u601d\u201420170222.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/88e669c9-b8d5-3809-b9c3-fb76a247cf5a\/\u5965\u871c\u601d\u201420170222.pdf","download":"\/vue\/attachment\/download?name=88e669c9-b8d5-3809-b9c3-fb76a247cf5a"},"createdBy":{"id":1028,"key":1028,"name":"\u5d14\u9e64\u5a77","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":101,"key":101,"name":"\u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee"},"fromProject":{"id":101,"key":101,"name":"\u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee","description":"ProDesk 280G2 MT New Core i3-6100(3.7G\/3M\/2\u6838)\/8G(4G DDR4 2133 * 2)\/500G(SATA)\/\u8d85\u8584DVDRW\/Windows 10 Home 64\u4f4d FDD\/USB KB\/USB Optical Mouse\/\u65b0180W \u9632\u96f7\u7535\u6e90\/3-3-3\u6709\u9650\u4fdd\u4fee 11\u53f0\r\n\r\nV244h (23.8\"\u5bbd\u5c4f16:9 LED\u80cc\u5149VA\u6db2\u6676\u663e\u793a\u5668,VGA,DVI-D,HDMI\uff08\u652f\u6301HDCP\uff09\u63a5\u53e3,\u65e0DVI\u7ebf\u7f06,250nits,3000:1,6\u767e\u4e07:1(\u52a8\u6001\u5bf9\u6bd4\u5ea6),7ms(\u7070\u5ea6),1920x1080)\u7f8e\u56fd\u7535\u5b50\u4ea7\u54c1\u73af\u5883\u5f71\u54cd\u8bc4\u4ef7\u5de5\u5177EPEAT\u94f6\u5956 11\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-03-15","collected":"47080.00","profit_pct":"15","budget":"47080","projectProductTypes":[{"id":4125,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"47080","pct":"15","project_id":101,"profit":"7062"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":7062,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1008,"key":1008,"name":"\u5218\u66e6\u7433","sex":"M","department_id":1,"avatar":{"id":19,"user_id":1008,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25b2f268-b259-387a-a4ec-a7bbc025565a.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":5664,"user_id":1001,"key":1001,"contract_id":54,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":5665,"user_id":1023,"key":1023,"contract_id":54,"user":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}},{"id":5666,"user_id":1011,"key":1011,"contract_id":54,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":5667,"user_id":1013,"key":1013,"contract_id":54,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":683,"key":683,"contract_id":54,"value":"47080.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"47080.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":667,"key":667,"contract_id":54,"value":"47080.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12663,"object_type":105,"object_id":54,"attachment_id":145,"attachment":{"id":145,"key":145,"name":"5d5f7f1d-3e6d-3981-8ad6-1b606535fbc5","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/5d5f7f1d-3e6d-3981-8ad6-1b606535fbc5\/\u5965\u871c\u601d\u5546\u8d38\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170310\u201447080.pdf","orig_name":"\u5965\u871c\u601d\u5546\u8d38\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\u201420170310\u201447080.pdf"}}],"receiptScans":[{"id":13361,"object_type":106,"object_id":54,"attachment_id":353,"attachment":{"id":353,"key":353,"name":"88e669c9-b8d5-3809-b9c3-fb76a247cf5a","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/88e669c9-b8d5-3809-b9c3-fb76a247cf5a\/\u5965\u871c\u601d\u201420170222.pdf","orig_name":"\u5965\u871c\u601d\u201420170222.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":47080,"un_invoiced":0,"collected":47080,"un_collected":0,"is_collected":true,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d15\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2327,"client_id":2202,"signed_at":"2017-02-17","amount":"1000.00","handler":5300,"description":"","created_by":1011,"created_at":"2022-07-05 10:41:04","updated_at":"2022-07-05 10:41:04","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":null,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"20170217","payment_collection_remind_ahead":"","from_project":null,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":false,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":null,"project":null,"fromProject":null,"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":1346,"key":1346,"contract_id":2327,"value":"1000","created_by":1011,"created_at":"2022-07-05 10:41:24","description":null,"collected_date":"2022-07-05","amount":"1000","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3},"files":[],"pct":100}],"salesContractInvoices":[{"id":1231,"key":1231,"contract_id":2327,"value":"1000.00","attachment_id":null,"from_date":"2022-07-05","attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":15459,"object_type":105,"object_id":2327,"attachment_id":10489,"attachment":{"id":10489,"key":10489,"name":"d84f8b23-62f5-3c4a-b7d1-3839ae0add93","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d84f8b23-62f5-3c4a-b7d1-3839ae0add93\/\u5317\u4eac\u4e50\u6210\u56fd\u9645\u5b66\u6821\u201420170217\u20141000.pdf","orig_name":"\u5317\u4eac\u4e50\u6210\u56fd\u9645\u5b66\u6821\u201420170217\u20141000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":1000,"un_invoiced":0,"collected":1000,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":12,"client_id":12,"signed_at":"2017-02-17","amount":"7500","handler":1003,"description":"1.\u60e0\u666e 840G3 W8G55PP \u7b14\u8bb0\u672c\u4e00\u53f0","created_by":1010,"created_at":"2017-02-17 18:43:44","updated_at":"2021-06-25 10:24:38","contract_scan":119,"receipt_scan":25,"contract_type":1,"project_id":42,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"-","payment_collection_remind_ahead":"","from_project":42,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}},"contractScan":{"id":119,"key":119,"name":"369d1e75-9213-3458-a1a2-58e00854b5a6","orig_name":"SMC\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170221\u20147500.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/369d1e75-9213-3458-a1a2-58e00854b5a6\/SMC\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170221\u20147500.pdf","download":"\/vue\/attachment\/download?name=369d1e75-9213-3458-a1a2-58e00854b5a6"},"receiptScan":{"id":25,"key":25,"name":"8ea657ef-33b1-3300-8ede-206655cd38fd","orig_name":"smc7500.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/8ea657ef-33b1-3300-8ede-206655cd38fd\/smc7500.pdf","download":"\/vue\/attachment\/download?name=8ea657ef-33b1-3300-8ede-206655cd38fd"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":42,"key":42,"name":"hp \u7b14\u8bb0\u672c"},"fromProject":{"id":42,"key":42,"name":"hp \u7b14\u8bb0\u672c","description":"1.\u60e0\u666e 840G3 W8G55PP \u7b14\u8bb0\u672c\u4e00\u53f0","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-02-17","collected":"7500.00","profit_pct":"14","budget":"7500","projectProductTypes":[{"id":4129,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"7500","pct":"14","project_id":42,"profit":"1050"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":1050,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"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"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":7473,"user_id":5300,"key":5300,"contract_id":12,"user":{"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"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":751,"key":751,"contract_id":12,"value":"7500.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"7500.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":628,"key":628,"contract_id":12,"value":"7500.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12593,"object_type":105,"object_id":12,"attachment_id":119,"attachment":{"id":119,"key":119,"name":"369d1e75-9213-3458-a1a2-58e00854b5a6","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/369d1e75-9213-3458-a1a2-58e00854b5a6\/SMC\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170221\u20147500.pdf","orig_name":"SMC\uff08\u4e2d\u56fd\uff09\u6709\u9650\u516c\u53f8\u201420170221\u20147500.pdf"}}],"receiptScans":[{"id":13297,"object_type":106,"object_id":12,"attachment_id":25,"attachment":{"id":25,"key":25,"name":"8ea657ef-33b1-3300-8ede-206655cd38fd","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/8ea657ef-33b1-3300-8ede-206655cd38fd\/smc7500.pdf","orig_name":"smc7500.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":7500,"un_invoiced":0,"collected":7500,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":20,"client_id":45,"signed_at":"2017-02-20","amount":"236500","handler":1005,"description":"IBM\u670d\u52a1\u5668\u4e00\u5957 4850*4\/512G\uff0f600*4","created_by":1010,"created_at":"2017-02-27 16:12:47","updated_at":"2019-01-21 11:17:37","contract_scan":788,"receipt_scan":242,"contract_type":1,"project_id":26,"valid_date":null,"expire_date":"2020-02-19","sla":"","remind_ahead":"","expire_remind_ahead":"15 days","expire_reminded":true,"serial_no":"DSC-F-ZX20170005","payment_collection_remind_ahead":null,"from_project":26,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":1974,"passed":2,"client":{"id":45,"key":45,"name":"\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":null,"salesRep":null},"contractScan":{"id":788,"key":788,"name":"57475059-3944-3795-86dc-868c02e9709d","orig_name":"\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\u6709\u9650\u516c\u53f8\u201420170220\u2014236500.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/57475059-3944-3795-86dc-868c02e9709d\/\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\u6709\u9650\u516c\u53f8\u201420170220\u2014236500.pdf","download":"\/vue\/attachment\/download?name=57475059-3944-3795-86dc-868c02e9709d"},"receiptScan":{"id":242,"key":242,"name":"02f0bb64-7bd0-316d-926e-743b2a7f58f6","orig_name":"\u822a\u5929\u4e1c\u65b9\u7ea2.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/02f0bb64-7bd0-316d-926e-743b2a7f58f6\/\u822a\u5929\u4e1c\u65b9\u7ea2.pdf","download":"\/vue\/attachment\/download?name=02f0bb64-7bd0-316d-926e-743b2a7f58f6"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":null,"project":{"id":26,"key":26,"name":"IBM\u670d\u52a1\u5668"},"fromProject":{"id":26,"key":26,"name":"IBM\u670d\u52a1\u5668","description":"IBM\u670d\u52a1\u5668\u4e00\u5957 4850*4\/512G\uff0f600*4","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-02-27","collected":"236500.00","profit_pct":"23","budget":"236500","projectProductTypes":[{"id":4141,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"236500","pct":"23","project_id":26,"profit":"54395"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":54395,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":1889,"user_id":1001,"key":1001,"contract_id":20,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":1892,"user_id":1023,"key":1023,"contract_id":20,"user":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}},{"id":1893,"user_id":1011,"key":1011,"contract_id":20,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":1894,"user_id":1013,"key":1013,"contract_id":20,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":418,"key":418,"contract_id":20,"value":"236500.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"236500.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":11,"key":11,"contract_id":20,"value":"236500.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12930,"object_type":105,"object_id":20,"attachment_id":788,"attachment":{"id":788,"key":788,"name":"57475059-3944-3795-86dc-868c02e9709d","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/57475059-3944-3795-86dc-868c02e9709d\/\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\u6709\u9650\u516c\u53f8\u201420170220\u2014236500.pdf","orig_name":"\u822a\u5929\u4e1c\u65b9\u7ea2\u536b\u661f\u6709\u9650\u516c\u53f8\u201420170220\u2014236500.pdf"}}],"receiptScans":[{"id":13578,"object_type":106,"object_id":20,"attachment_id":242,"attachment":{"id":242,"key":242,"name":"02f0bb64-7bd0-316d-926e-743b2a7f58f6","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/02f0bb64-7bd0-316d-926e-743b2a7f58f6\/\u822a\u5929\u4e1c\u65b9\u7ea2.pdf","orig_name":"\u822a\u5929\u4e1c\u65b9\u7ea2.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":236500,"un_invoiced":0,"collected":236500,"un_collected":0,"is_collected":true,"handlerPerson":null,"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u63d0\u524d15\u5929","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":18,"client_id":42,"signed_at":"2017-02-20","amount":"48400","handler":1007,"description":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd\uff083\u53f0\u670d\u52a1\u5668\u786c\u4ef6+3CPU\u5e74\u5ea6\u7ef4\u62a4\uff09\r\n6\u5757300GB\u786c\u76d8\r\n1\u53f0LS-3100-52TP-SI-H3(\u542b\u7ea7\u8054\u8fde\u63a5\u6a21\u5757)","created_by":1010,"created_at":"2017-02-24 23:30:32","updated_at":"2021-06-17 15:17:49","contract_scan":27,"receipt_scan":252,"contract_type":2,"project_id":21,"valid_date":null,"expire_date":"2018-02-26","sla":"5*8","remind_ahead":"","expire_remind_ahead":"","expire_reminded":true,"serial_no":"-","payment_collection_remind_ahead":"","from_project":21,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":true,"save_collection_at":null,"b_date":2697,"passed":2,"client":{"id":42,"key":42,"name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}},"contractScan":{"id":27,"key":27,"name":"74b6589a-6ff5-3f63-bb59-ed2a72e6058f","orig_name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/74b6589a-6ff5-3f63-bb59-ed2a72e6058f\/\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf","download":"\/vue\/attachment\/download?name=74b6589a-6ff5-3f63-bb59-ed2a72e6058f"},"receiptScan":{"id":252,"key":252,"name":"75f1ad7c-012d-3ef0-97d4-9c6d71e2c901","orig_name":"\u4e50\u5065\u533b\u7597.pdf","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/75f1ad7c-012d-3ef0-97d4-9c6d71e2c901\/\u4e50\u5065\u533b\u7597.pdf","download":"\/vue\/attachment\/download?name=75f1ad7c-012d-3ef0-97d4-9c6d71e2c901"},"createdBy":{"id":1010,"key":1010,"name":"\u9ad8\u73b2\u8273","sex":"F","department_id":9,"avatar":null,"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":18,"comment":5},"project":{"id":21,"key":21,"name":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd"},"fromProject":{"id":21,"key":21,"name":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd","description":"\u865a\u62df\u5316\u5e73\u53f0\u7ef4\u4fdd\uff083\u53f0\u670d\u52a1\u5668\u786c\u4ef6+3CPU\u5e74\u5ea6\u7ef4\u62a4\uff09\r\n6\u5757300GB\u786c\u76d8\r\n1\u53f0LS-3100-52TP-SI-H3(\u542b\u7ea7\u8054\u8fde\u63a5\u6a21\u5757)","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2017-03-24","collected":"48400.00","profit_pct":"20","budget":"48400","projectProductTypes":[{"id":3652,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"5500.00","pct":"20","project_id":21,"profit":"1100"},{"id":3974,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"5400.00","pct":"20","project_id":21,"profit":"1080"},{"id":2005,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"37500.00","pct":"20","project_id":21,"profit":"7500"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":21,"sum":"121.72"},"profit":9680,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":1007,"key":1007,"name":"\u5b59\u6167","sex":"F","department_id":9,"avatar":{"id":7,"user_id":1007,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1007.jpg"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8312,"user_id":5311,"key":5311,"contract_id":18,"user":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":596,"key":596,"contract_id":18,"value":"48400.00","created_by":null,"created_at":"","description":null,"collected_date":null,"amount":"48400.00","createdBy":null,"files":[],"pct":100}],"salesContractInvoices":[{"id":62,"key":62,"contract_id":18,"value":"48400.00","attachment_id":null,"from_date":null,"attachment":null,"attachmentRelationships":[],"files":[]}],"contractScans":[{"id":12682,"object_type":105,"object_id":18,"attachment_id":27,"attachment":{"id":27,"key":27,"name":"74b6589a-6ff5-3f63-bb59-ed2a72e6058f","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/74b6589a-6ff5-3f63-bb59-ed2a72e6058f\/\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf","orig_name":"\u5317\u4eac\u4e50\u5065\u4e1c\u5916\u95e8\u8bca\u90e8\u6709\u9650\u516c\u53f8_20170220__\u5408\u540c.pdf"}}],"receiptScans":[{"id":13377,"object_type":106,"object_id":18,"attachment_id":252,"attachment":{"id":252,"key":252,"name":"75f1ad7c-012d-3ef0-97d4-9c6d71e2c901","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/75f1ad7c-012d-3ef0-97d4-9c6d71e2c901\/\u4e50\u5065\u533b\u7597.pdf","orig_name":"\u4e50\u5065\u533b\u7597.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":48400,"un_invoiced":0,"collected":48400,"un_collected":0,"is_collected":true,"handlerPerson":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":1498,"thispage":2,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-16 20:51:34') RETURNING "id"
20:51:34.5242.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'
20:51:34.5851.9 msyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (3, 21, 26, 34, 40, 42, 101, 136, 147))
20:51:34.5221.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:51:34.6011.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (82, 10, 122, 119, 771, 77, 145, 27, 788, 10489)
20:51:34.5871.5 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (3, 21, 26, 34, 40, 42, 101, 136, 147)) GROUP BY "project_id"
20:51:34.5991.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18))
20:51:34.5951.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (187, 199, 348, 418, 472, 588, 596, 683, 751, 1346))
20:51:34.5981.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (11, 37, 62, 213, 239, 319, 446, 628, 667, 1231))
20:51:34.5971.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (11, 37, 62, 213, 239, 319, 446, 628, 667, 1231))
20:51:34.6021.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18))
20:51:34.5271.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:51:34.6041.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18))
20:51:34.5580.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "orig_name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (360, 258, 257, 26, 23, 353, 25, 242, 252)
20:51:34.5830.7 msyii\db\Command::querySELECT "id", "product_type_id", "product_type_id" AS "key", "name", "budget", "pct", "project_id", "profit" FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3, 21, 26, 34, 40, 42, 101, 136, 147)
20:51:34.5840.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3, 21, 26, 34, 40, 42, 101, 136, 147)
20:51:34.5940.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18) ORDER BY "id"
20:51:34.5960.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18) ORDER BY "id"
20:51:34.5910.5 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)
20:51:34.5930.4 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)
20:51:34.5880.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)
20:51:34.5820.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "description", "total_contact_point", "paid_contact_point", "is_sales_order_ready", "project_product_version_id", "bargain_date", "collected", "profit_pct", "budget" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (136, 34, 147, 3, 40, 101, 42, 26, 21)
20:51:34.5930.4 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18) ORDER BY "remind_date"
20:51:34.5540.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 5300))
20:51:34.5530.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (16, 6, 206, 12, 49, 38, 2202, 45, 42)
20:51:34.5900.3 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)) ORDER BY "remind_date"
20:51:34.5600.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 3, 10)
20:51:34.5920.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)
20:51:34.5840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3, 21, 26, 34, 40, 42, 101, 136, 147)
20:51:34.5890.3 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
20:51:34.5590.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1010, 1000, 1028, 1011)
20:51:34.5900.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1008, 1006, 1005, 1007, 5300, 1003))
20:51:34.5530.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5311)
20:51:34.5920.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5311, 1011, 1023, 1013, 5300))
20:51:34.5890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1006, 1008, 1003, 5300, 1005, 1007)
20:51:34.6030.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (257, 258, 26, 25, 23, 360, 353, 252, 242)
20:51:34.5600.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1028, 1011, 1010, 1000))
20:51:34.5910.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1023, 1011, 1013, 5311, 5300)
20:51:34.5910.2 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (52, 7, 59, 2, 9, 54, 2327, 12, 20, 18)
20:51:34.5940.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011