ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68760612755f2: POST https://beta.jinchangxiao.com/v2/sales-contract/list at 2025-07-15 03:41:06 pm by 117.176.186.93

Performance Profiling

Total processing time: 166 ms; Peak memory: 5.823 MB. Show Profiling Timeline

总计62条数据
TimeDurationCategoryInfo
  
15:41:06.49220.1 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 LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "c"."project_id" WHERE (true) AND (("c"."serial_no" ILIKE '%北京皮%') OR ("c"."description" ILIKE '%北京皮%') OR ("client"."name" ILIKE '%北京皮%') OR ("client"."en_name" ILIKE '%北京皮%') OR ("client"."pinyin_shortcut" ILIKE '%北京皮%') OR ("project"."project_title" ILIKE '%北京皮%') OR ("project"."pinyin_shortcut" ILIKE '%北京皮%')) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 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, 5409, 5412, 5229, 1005, 5304, 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" DESC, "c"."created_at" DESC) "c"
15:41:06.53117.7 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)) GROUP BY "object_id"
15:41:06.62215.5 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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)) GROUP BY "object_id"
15:41:06.51315.2 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 LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON "project"."id" = "c"."project_id" WHERE (true) AND (("c"."serial_no" ILIKE '%北京皮%') OR ("c"."description" ILIKE '%北京皮%') OR ("client"."name" ILIKE '%北京皮%') OR ("client"."en_name" ILIKE '%北京皮%') OR ("client"."pinyin_shortcut" ILIKE '%北京皮%') OR ("project"."project_title" ILIKE '%北京皮%') OR ("project"."pinyin_shortcut" ILIKE '%北京皮%')) AND (("client"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 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, 5409, 5412, 5229, 1005, 5304, 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" DESC, "c"."created_at" DESC LIMIT 10
15:41:06.5799.0 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (3034, 2715, 2530, 2781, 2826, 3320, 2489, 3319, 2280, 2689, 3405, 3321, 3442, 3584)
15:41:06.6038.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10363, 11578, 11591, 13601, 14347, 16836, 19601, 20669)
15:41:06.5537.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1624, 1357, 590, 942, 1693, 201, 947, 792, 377, 932, 254, 1208, 421, 1623)
15:41:06.6144.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10259, 11592, 11534, 16632, 14209, 13359, 19483, 20563)
15:41:06.5624.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (356, 1382, 593, 167, 274, 339, 806, 757, 256, 191, 1000)
15:41:06.6404.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":"","sort":""},"SalesContractSearch":{"contract_type":"","handler":"","keyword":"\u5317\u4eac\u76ae"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752565248","token":"d5d61cee0599bf796113e94c8f9c9a86","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":3437,"client_id":1663,"signed_at":"2024-07-17","amount":"144000","handler":5300,"description":"","created_by":5300,"created_at":"2024-07-26 12:02:27","updated_at":"2024-08-06 17:06:48","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3596,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY2024071701","payment_collection_remind_ahead":"7 days","from_project":3596,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-08-02 09:52:03.290511+08","b_date":null,"passed":1,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3437,"comment":8},"project":{"id":3596,"key":3596,"name":"PA5220-URL\u6388\u67431\u5e74-2024-C"},"fromProject":{"id":3596,"key":3596,"name":"PA5220-URL\u6388\u67431\u5e74-2024-C","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":522,"bargain_date":"2024-07-17","collected":"144000","profit_pct":"2.35","budget":"144000","projectProductTypes":[{"id":4985,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"144000.00","pct":"2.35","project_id":3596,"profit":"3384"}],"projectProductRels":[{"id":5804,"project_id":3596,"product_id":1693,"amount":"144000","number":1,"cost":"102000","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-08-11","maintenance_from":null,"hardware_to":null,"software_to":"2025-08-11","maintenance_to":null,"total_amount":"144000","total_cost":"102000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1693,"name":"PAN-PA-5220-ADVURL-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":356,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-07-30 16:35:19","updated_at":"2024-07-30 16:35:19","pinyin_shortcut":"PANPA5220ADVURLR","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":356,"key":356,"name":"PA5220\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5805,"project_id":3596,"product_id":942,"amount":"0","number":1,"cost":"34800","description":"\u738b\u5bb8-\u8c08\u597d\u5229\u6da6\u73875%","supplier_id":365,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"34800","supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":11192,"project_id":3596},{"id":9556,"project_id":3596}],"reimbursementAmountSum":null,"profit":3384,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1620,"contract_id":3437,"supplier_id":90,"purchase_id":3442,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3442,"key":3442,"serial_no":"X_2024SBQ19116"}},{"id":1876,"contract_id":3437,"supplier_id":365,"purchase_id":3584,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3584,"key":3584,"serial_no":"TSKJ20240814-HYF-003"}}],"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":[{"id":6107,"user_id":5300,"key":5300,"contract_id":3437,"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"}}},{"id":6108,"user_id":1001,"key":1001,"contract_id":3437,"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":6109,"user_id":5388,"key":5388,"contract_id":3437,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1889,"key":1889,"contract_id":3437,"name":"2024-10-10","value":"144000","overdue_days":11,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1989,"key":1989,"contract_id":3437,"value":"144000","created_by":1013,"created_at":"2024-10-21 13:24:27","description":"","collected_date":"2024-10-21","amount":"144000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":29465,"object_type":109,"object_id":1989,"attachment_id":22125,"attachment":{"id":22125,"key":22125,"name":"9bd3aa98-b9b6-32e1-8bf8-9bf702fea78a","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/9bd3aa98-b9b6-32e1-8bf8-9bf702fea78a\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1736,"key":1736,"contract_id":3437,"value":"144000.00","attachment_id":null,"from_date":"2024-08-02","attachment":null,"attachmentRelationships":[],"files":[{"id":28220,"object_type":102,"object_id":1736,"attachment_id":20669,"attachment":{"id":20669,"key":20669,"name":"a1249d9c-70f4-3640-8abc-68bfed3991f8","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/a1249d9c-70f4-3640-8abc-68bfed3991f8\/dzfp_24112000000097454766_\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8_20240802104147.pdf","orig_name":"dzfp_24112000000097454766_\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8_20240802104147.pdf"}}]}],"contractScans":[{"id":27628,"object_type":105,"object_id":3437,"attachment_id":20563,"attachment":{"id":20563,"key":20563,"name":"ae1133e7-ca79-3956-91d7-f84d099005e6","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/ae1133e7-ca79-3956-91d7-f84d099005e6\/\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf","orig_name":"\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":144000,"projectProductTotalAmount":144000,"projectProductAllAmount":true,"projectProductTotalCost":136800,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":144000,"un_invoiced":0,"collected":144000,"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":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3316,"client_id":1663,"signed_at":"2024-05-23","amount":"375500.1","handler":5300,"description":"","created_by":5300,"created_at":"2024-05-29 09:03:58","updated_at":"2024-06-04 10:18:53","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3507,"valid_date":null,"expire_date":"2025-05-22","sla":"","remind_ahead":"7 days","expire_remind_ahead":"30 days","expire_reminded":false,"serial_no":"CHZH-2024019","payment_collection_remind_ahead":"7 days","from_project":3507,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":"2024-05-31 15:27:46.609226+08","b_date":54,"passed":2,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3316,"comment":8},"project":{"id":3507,"key":3507,"name":"PA\u7eed\u4fdd1\u5e74-2024-C"},"fromProject":{"id":3507,"key":3507,"name":"PA\u7eed\u4fdd1\u5e74-2024-C","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":487,"bargain_date":"2024-05-23","collected":"375500.1","profit_pct":"3.21","budget":"375500.1","projectProductTypes":[{"id":4959,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"375500.1","pct":"3.21","project_id":3507,"profit":"12053.55321"}],"projectProductRels":[{"id":5494,"project_id":3507,"product_id":1624,"amount":"25466.7","number":3,"cost":"1022","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-05-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-05-30","maintenance_to":null,"total_amount":"76400.1","total_cost":"3066","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2024-05-28 17:27:39","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5495,"project_id":3507,"product_id":1357,"amount":"99700","number":1,"cost":"70000","description":"","supplier_id":90,"hardware_from":null,"software_from":"2024-05-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-05-22","maintenance_to":null,"total_amount":"99700","total_cost":"70000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1357,"name":"PAN-PA-5220-TP-R","product_type":5,"product_component":36,"product_brand":8,"product_serie":1000,"product_misc":null,"product_qa":null,"pn":"","description":"Threat prevention subscription renewal, PA-5220","created_by":1013,"created_at":"2024-01-26 13:49:55","updated_at":"2024-01-26 13:49:55","pinyin_shortcut":"PANPA5220TPR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1000,"key":1000,"name":"PA5220\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5496,"project_id":3507,"product_id":590,"amount":"99700","number":1,"cost":"0","description":"","supplier_id":90,"hardware_from":null,"software_from":null,"maintenance_from":"2024-05-23","hardware_to":null,"software_to":null,"maintenance_to":"2025-05-22","total_amount":"99700","total_cost":"0","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":590,"name":"PAN-SVC-BKLN-3050-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":191,"product_misc":5,"product_qa":null,"pn":"","description":"Partner enabled premium support year 1 renewal, PA-3050","created_by":1013,"created_at":"2019-07-22 16:40:16","updated_at":"2024-01-12 15:19:03","pinyin_shortcut":"PANSVCBKLN3050R","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":191,"key":191,"name":"PA3050\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":5498,"project_id":3507,"product_id":942,"amount":"0","number":1,"cost":"198321","description":"","supplier_id":365,"hardware_from":null,"software_from":null,"maintenance_from":"2024-05-23","hardware_to":null,"software_to":null,"maintenance_to":"2025-05-22","total_amount":"0","total_cost":"198321","supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}},{"id":5493,"project_id":3507,"product_id":1623,"amount":"99700","number":1,"cost":"50000","description":"","supplier_id":90,"hardware_from":"2024-05-22","software_from":null,"maintenance_from":null,"hardware_to":"2025-05-22","software_to":null,"maintenance_to":null,"total_amount":"99700","total_cost":"50000","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1623,"name":"PAN-SVC-BKLN-5220-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":356,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:18:17","updated_at":"2024-05-28 17:18:17","pinyin_shortcut":"PANSVCBKLN5220R","product_unit":2,"is_renew":true,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":356,"key":356,"name":"PA5220\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5497,"project_id":3507,"product_id":1624,"amount":"0","number":20,"cost":"1022","description":"\u8ddf\u7528\u6237\u7b7e\u7ea63\u4e2a\uff0c\u5b9e\u9645\u4e0b\u535523\u4e2a","supplier_id":90,"hardware_from":null,"software_from":"2024-05-30","maintenance_from":null,"hardware_to":null,"software_to":"2025-05-30","maintenance_to":null,"total_amount":"0","total_cost":"20440","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2024-05-28 17:27:39","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":5499,"project_id":3507,"product_id":1624,"amount":"0","number":10,"cost":"1114.3","description":"\u589e\u8d2d10\u4e2a","supplier_id":90,"hardware_from":null,"software_from":"2024-07-15","maintenance_from":null,"hardware_to":null,"software_to":"2025-07-15","maintenance_to":null,"total_amount":"0","total_cost":"11143.0","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"product":{"id":1624,"name":"PAN-SOFTWARE-NGFW-CR","product_type":5,"product_component":36,"product_brand":8,"product_serie":1382,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-05-28 17:27:39","updated_at":"2024-05-28 17:27:39","pinyin_shortcut":"PANSOFTWARENGFWCR","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":1382,"key":1382,"name":"PA\u865a\u62df\u9632\u706b\u5899\u8f6f\u4ef6\u6388\u6743"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":12276,"project_id":3507},{"id":12277,"project_id":3507},{"id":12279,"project_id":3507},{"id":12280,"project_id":3507},{"id":12281,"project_id":3507},{"id":12282,"project_id":3507},{"id":12278,"project_id":3507},{"id":11328,"project_id":3507},{"id":11338,"project_id":3507},{"id":11339,"project_id":3507},{"id":11340,"project_id":3507},{"id":11332,"project_id":3507},{"id":11333,"project_id":3507},{"id":11334,"project_id":3507},{"id":11335,"project_id":3507},{"id":11336,"project_id":3507},{"id":11337,"project_id":3507},{"id":9292,"project_id":3507},{"id":9293,"project_id":3507},{"id":11317,"project_id":3507},{"id":11318,"project_id":3507},{"id":11319,"project_id":3507},{"id":11320,"project_id":3507},{"id":11321,"project_id":3507},{"id":11322,"project_id":3507},{"id":11323,"project_id":3507},{"id":11324,"project_id":3507},{"id":11325,"project_id":3507},{"id":11326,"project_id":3507},{"id":11327,"project_id":3507},{"id":11329,"project_id":3507},{"id":11330,"project_id":3507},{"id":11331,"project_id":3507},{"id":11341,"project_id":3507},{"id":11342,"project_id":3507},{"id":11343,"project_id":3507},{"id":11344,"project_id":3507},{"id":11345,"project_id":3507},{"id":11346,"project_id":3507},{"id":11347,"project_id":3507},{"id":11349,"project_id":3507},{"id":11350,"project_id":3507},{"id":11351,"project_id":3507},{"id":11348,"project_id":3507}],"reimbursementAmountSum":{"project_id":3507,"sum":"87"},"profit":12053.55321,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1182,"contract_id":3316,"supplier_id":90,"purchase_id":3320,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3320,"key":3320,"serial_no":"X_2024SBQ12468"}},{"id":1260,"contract_id":3316,"supplier_id":90,"purchase_id":3319,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3319,"key":3319,"serial_no":"X_2024SBQ12340"}},{"id":1512,"contract_id":3316,"supplier_id":90,"purchase_id":3405,"supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3405,"key":3405,"serial_no":"X_2024SBQ17640"}},{"id":1618,"contract_id":3316,"supplier_id":365,"purchase_id":3321,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3321,"key":3321,"serial_no":"TSKJ-20240529-HYF-009"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":{"id":479,"key":479,"contract_id":3316,"remind_date":"2025-05-22"},"serviceContractRemindDates":[{"id":479,"key":479,"contract_id":3316,"name":"2025-05-22"},{"id":476,"key":476,"contract_id":3316,"name":"2024-09-01"},{"id":477,"key":477,"contract_id":3316,"name":"2024-12-01"},{"id":478,"key":478,"contract_id":3316,"name":"2025-03-01"}],"salesContractRemindReceivers":[{"id":8068,"user_id":1011,"key":1011,"contract_id":3316,"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":8069,"user_id":5300,"key":5300,"contract_id":3316,"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":[{"id":441,"contract_id":3316,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":5297,"user_id":5300,"key":5300,"contract_id":3316,"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"}}},{"id":5298,"user_id":1001,"key":1001,"contract_id":3316,"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":5299,"user_id":5388,"key":5388,"contract_id":3316,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1688,"key":1688,"contract_id":3316,"name":"2024-08-14","value":"375500.1","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1913,"key":1913,"contract_id":3316,"value":"375500.1","created_by":1013,"created_at":"2024-07-26 16:46:15","description":"","collected_date":"2024-07-26","amount":"375500.1","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"files":[{"id":27425,"object_type":109,"object_id":1913,"attachment_id":20578,"attachment":{"id":20578,"key":20578,"name":"6a265bb9-14fd-329c-aaf5-ed958acbd384","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6a265bb9-14fd-329c-aaf5-ed958acbd384\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1678,"key":1678,"contract_id":3316,"value":"375500.10","attachment_id":null,"from_date":"2024-06-05","attachment":null,"attachmentRelationships":[],"files":[{"id":26327,"object_type":102,"object_id":1678,"attachment_id":19601,"attachment":{"id":19601,"key":19601,"name":"42225ac1-c6be-3320-a4b3-e2bf82e65add","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/42225ac1-c6be-3320-a4b3-e2bf82e65add\/dzfp_24112000000054969993_\u5317\u4eac\u8f66\u667a\u6167\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20240605171059.pdf","orig_name":"dzfp_24112000000054969993_\u5317\u4eac\u8f66\u667a\u6167\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20240605171059.pdf"}}]}],"contractScans":[{"id":26287,"object_type":105,"object_id":3316,"attachment_id":19483,"attachment":{"id":19483,"key":19483,"name":"35a1af85-7ffb-3f85-a72e-b7d4aa9fe08c","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/35a1af85-7ffb-3f85-a72e-b7d4aa9fe08c\/2024_05_29_11_44_23.pdf","orig_name":"2024_05_29_11_44_23.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":375500.1,"projectProductTotalAmount":375500.1,"projectProductAllAmount":true,"projectProductTotalCost":352970,"projectProductAllCost":true,"projectProductTotalCount":37,"invoiced":375500.1,"un_invoiced":0,"collected":375500.1,"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":"2025-05-22","remind_ahead_display":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":3015,"client_id":1663,"signed_at":"2023-12-21","amount":"140800","handler":5300,"description":"","created_by":5300,"created_at":"2023-12-18 13:53:47","updated_at":"2024-01-30 15:50:04","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3361,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"ATPE-2023059","payment_collection_remind_ahead":"7 days","from_project":3361,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":3015,"comment":3},"project":{"id":3361,"key":3361,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd-2023-G"},"fromProject":{"id":3361,"key":3361,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd-2023-G","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":114,"bargain_date":"2023-12-21","collected":"140800","profit_pct":"1.16","budget":"140800","projectProductTypes":[{"id":4872,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"140800.00","pct":"1.16","project_id":3361,"profit":"1633.28"}],"projectProductRels":[{"id":2795,"project_id":3361,"product_id":421,"amount":"35200","number":4,"cost":"32450","description":"AC-7000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"140800","total_cost":"129800","supplier":null,"product":{"id":421,"name":"\u6df1\u4fe1\u670d\u7eed\u4fdd\u670d\u52a1","product_type":4,"product_component":51,"product_brand":12,"product_serie":274,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2018-08-28 12:17:51","updated_at":"2023-08-14 10:28:40","pinyin_shortcut":"sxfxbfw","product_unit":8,"is_renew":false,"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":51,"key":51,"name":"\u7ba1\u7406\u8f6f\u4ef6\u548c\u670d\u52a1"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":274,"key":274,"name":" \u6df1\u4fe1\u670d\u7eed\u4fdd\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3361,"sum":"25"},"profit":1633.28,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":189,"contract_id":3015,"supplier_id":488,"purchase_id":3034,"supplier":{"id":488,"key":488,"name":"\u65f6\u5229\u548c\u901a(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":3034,"key":3034,"serial_no":"SLHT20231221005"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[{"id":4667,"user_id":5300,"key":5300,"contract_id":3015,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1459,"key":1459,"contract_id":3015,"name":"2024-03-17","value":"140800","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1789,"key":1789,"contract_id":3015,"value":"140800","created_by":1014,"created_at":"2024-02-28 16:57:11","description":"","collected_date":"2024-02-28","amount":"140800","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[{"id":24182,"object_type":109,"object_id":1789,"attachment_id":17796,"attachment":{"id":17796,"key":17796,"name":"126993a3-1710-36e7-8885-7da2ccf444dc","extension":"png","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/126993a3-1710-36e7-8885-7da2ccf444dc\/image.png","orig_name":"image.png"}}],"pct":100}],"salesContractInvoices":[{"id":1568,"key":1568,"contract_id":3015,"value":"140800.00","attachment_id":null,"from_date":"2023-12-21","attachment":null,"attachmentRelationships":[],"files":[{"id":22646,"object_type":102,"object_id":1568,"attachment_id":16836,"attachment":{"id":16836,"key":16836,"name":"f21bb1a9-8400-3347-a331-b4ca6603c989","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f21bb1a9-8400-3347-a331-b4ca6603c989\/2023_12_21_17_37_49.pdf","orig_name":"2023_12_21_17_37_49.pdf"}}]}],"contractScans":[{"id":23468,"object_type":105,"object_id":3015,"attachment_id":16632,"attachment":{"id":16632,"key":16632,"name":"d55273a3-1ee6-3448-9925-a25fa1857c04","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d55273a3-1ee6-3448-9925-a25fa1857c04\/2023_12_18_11_27_12.pdf","orig_name":"2023_12_18_11_27_12.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":140800,"projectProductTotalAmount":140800,"projectProductAllAmount":true,"projectProductTotalCost":129800,"projectProductAllCost":true,"projectProductTotalCount":4,"invoiced":140800,"un_invoiced":0,"collected":140800,"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":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2788,"client_id":1663,"signed_at":"2023-08-04","amount":"144000","handler":5300,"description":"PA5220 URL\u6388\u67431\u5e74\uff1a\nPAN-PA-5220-ADVURL\uff1aPA-5220 Advanced URL Filtering \u8ba2\u9605\u670d\u52a11\u5e74\uff0c\u53ef\u4e0e\u60a8\u7684 PaloAlto Networks \u4e0b\u4e00\u4ee3\u9632\u706b\u5899 (NGFW) \u914d\u5408\u4f7f\u7528\uff0c\u4ee5\u4fdd\u62a4\u60a8\u7684\u7f51\u7edc\u514d\u53d7\u57fa\u4e8e Web \u7684\u5a01\u80c1, \u4f8b\u5982\u7f51\u7edc\u9493\u9c7c\u3001\u6076\u610f\u8f6f\u4ef6\u3001\u52d2\u7d22\u8f6f\u4ef6\u4ee5\u53ca\u547d\u4ee4\u548c\u63a7\u5236 (C2)\u3002","created_by":5300,"created_at":"2023-08-04 09:41:52","updated_at":"2024-01-26 11:16:05","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3261,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"7 days","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2023072601","payment_collection_remind_ahead":"7 days","from_project":3261,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2788,"comment":8},"project":{"id":3261,"key":3261,"name":"PA5220-URL\u6388\u67431\u5e74-2023-C"},"fromProject":{"id":3261,"key":3261,"name":"PA5220-URL\u6388\u67431\u5e74-2023-C","description":"PA5220 URL\u6388\u67431\u5e74\uff1a\nPAN-PA-5220-ADVURL\uff1aPA-5220 Advanced URL Filtering \u8ba2\u9605\u670d\u52a11\u5e74\uff0c\u53ef\u4e0e\u60a8\u7684 PaloAlto Networks \u4e0b\u4e00\u4ee3\u9632\u706b\u5899 (NGFW) \u914d\u5408\u4f7f\u7528\uff0c\u4ee5\u4fdd\u62a4\u60a8\u7684\u7f51\u7edc\u514d\u53d7\u57fa\u4e8e Web \u7684\u5a01\u80c1, \u4f8b\u5982\u7f51\u7edc\u9493\u9c7c\u3001\u6076\u610f\u8f6f\u4ef6\u3001\u52d2\u7d22\u8f6f\u4ef6\u4ee5\u53ca\u547d\u4ee4\u548c\u63a7\u5236 (C2)\u3002","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":107,"bargain_date":"2023-08-04","collected":"144000","profit_pct":"-1.28","budget":"144000","projectProductTypes":[{"id":4904,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"144000.00","pct":"-1.28","project_id":3261,"profit":"-1843.2"}],"projectProductRels":[{"id":3181,"project_id":3261,"product_id":201,"amount":"144000","number":1,"cost":"136800","description":"PAN-PA-5220-ADVURL","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"144000","total_cost":"136800","supplier":null,"product":{"id":201,"name":"Paloalto URL\u8fc7\u6ee4\u6388\u6743","product_type":5,"product_component":36,"product_brand":8,"product_serie":167,"product_misc":5,"product_qa":2,"pn":"","description":"","created_by":1013,"created_at":"2017-05-24 14:29:34","updated_at":"2023-08-14 15:58:32","pinyin_shortcut":"PaloaltoURLglsq","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":167,"key":167,"name":"Paloalto\u5168\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":3182,"project_id":3261,"product_id":947,"amount":"0","number":1,"cost":"1296","description":"4\u5929\u670d\u52a1\u8d39","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"1296","supplier":null,"product":{"id":947,"name":"PAN-SVC-BKLN-3260","product_type":5,"product_component":35,"product_brand":8,"product_serie":806,"product_misc":null,"product_qa":null,"pn":"","description":"Partner enabled premium support year 1, PA-3260","created_by":1013,"created_at":"2023-08-03 16:07:54","updated_at":"2024-01-12 15:47:22","pinyin_shortcut":"PANSVCBKLN3260","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":806,"key":806,"name":"PA-3260\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}}],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3261,"sum":"138"},"profit":-1843.2,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":443,"contract_id":2788,"supplier_id":68,"purchase_id":2781,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2781,"key":2781,"serial_no":"30-55468-11"}},{"id":748,"contract_id":2788,"supplier_id":68,"purchase_id":2826,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2826,"key":2826,"serial_no":"30-89595-11"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[{"id":419,"key":419,"contract_id":2788,"name":"2023-11-10"},{"id":420,"key":420,"contract_id":2788,"name":"2024-02-09"},{"id":421,"key":421,"contract_id":2788,"name":"2024-05-10"},{"id":422,"key":422,"contract_id":2788,"name":"2024-08-09"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":432,"contract_id":2788,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":4788,"user_id":5300,"key":5300,"contract_id":2788,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1304,"key":1304,"contract_id":2788,"name":"2023-10-15","value":"144000","overdue_days":3,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1645,"key":1645,"contract_id":2788,"value":"144000","created_by":1014,"created_at":"2023-10-18 16:47:40","description":null,"collected_date":"2023-10-18","amount":"144000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1460,"key":1460,"contract_id":2788,"value":"144000.00","attachment_id":null,"from_date":"2023-08-14","attachment":null,"attachmentRelationships":[],"files":[{"id":19841,"object_type":102,"object_id":1460,"attachment_id":14347,"attachment":{"id":14347,"key":14347,"name":"21d1b715-a39b-3843-8cf1-7759cb84d053","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/21d1b715-a39b-3843-8cf1-7759cb84d053\/2023_08_14_11_37_13.pdf","orig_name":"2023_08_14_11_37_13.pdf"}}]}],"contractScans":[{"id":23728,"object_type":105,"object_id":2788,"attachment_id":14209,"attachment":{"id":14209,"key":14209,"name":"1b1b1a7d-b2b7-3ea6-a37a-384902ae3f9d","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/1b1b1a7d-b2b7-3ea6-a37a-384902ae3f9d\/2023_08_04_09_36_23.pdf","orig_name":"2023_08_04_09_36_23.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":144000,"projectProductTotalAmount":144000,"projectProductAllAmount":true,"projectProductTotalCost":138096,"projectProductAllCost":true,"projectProductTotalCount":2,"invoiced":144000,"un_invoiced":0,"collected":144000,"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":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d7\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2690,"client_id":1663,"signed_at":"2023-05-19","amount":"353000","handler":5300,"description":"\u9632\u706b\u5899-Premium Support\tPAN-SVC-PREM-5220-R\t1.00\t\u9879\n\u9632\u706b\u5899-Threat Prevention\tPAN-PA-5220-TP-R\t1.00\t\u9879\nVPN-Premium Support\tPAN-VM-300-PERP-BND2-BKLN-1YR-R\uff0c\t3.00\t\u9879","created_by":5300,"created_at":"2023-06-07 21:52:14","updated_at":"2024-01-26 11:23:14","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":3176,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"7 days","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-SQY-2023051902","payment_collection_remind_ahead":"2 days","from_project":3176,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":true,"save_collection_at":null,"b_date":null,"passed":1,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2690,"comment":7},"project":{"id":3176,"key":3176,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-2023\u2014C"},"fromProject":{"id":3176,"key":3176,"name":"PA\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-2023\u2014C","description":"\u9632\u706b\u5899-Premium Support\tPAN-SVC-PREM-5220-R\t1.00\t\u9879\n\u9632\u706b\u5899-Threat Prevention\tPAN-PA-5220-TP-R\t1.00\t\u9879\nVPN-Premium Support\tPAN-VM-300-PERP-BND2-BKLN-1YR-R\uff0c\t3.00\t\u9879","total_contact_point":"264050","paid_contact_point":"264050","is_sales_order_ready":false,"project_product_version_id":115,"bargain_date":"2023-05-19","collected":"353000","profit_pct":"-0.63","budget":"353000","projectProductTypes":[{"id":4908,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"353000.00","pct":"-0.63","project_id":3176,"profit":"-2223.9"}],"projectProductRels":[{"id":3193,"project_id":3176,"product_id":792,"amount":"91445","number":1,"cost":"30528","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"91445","total_cost":"30528","supplier":null,"product":{"id":792,"name":"Paloalto TP\u6388\u6743","product_type":5,"product_component":36,"product_brand":8,"product_serie":167,"product_misc":5,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2021-04-12 17:34:27","updated_at":"2023-08-11 16:19:19","pinyin_shortcut":"PaloaltoTPsq","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":167,"key":167,"name":"Paloalto\u5168\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":3194,"project_id":3176,"product_id":377,"amount":"91445","number":1,"cost":"23472","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"91445","total_cost":"23472","supplier":null,"product":{"id":377,"name":"PAN-SVC-BKLN-820","product_type":5,"product_component":35,"product_brand":8,"product_serie":256,"product_misc":5,"product_qa":2,"pn":"","description":"Partner enabled premium support year 1, PA-820","created_by":1013,"created_at":"2018-06-06 10:58:17","updated_at":"2024-01-12 14:40:37","pinyin_shortcut":"PANSVCBKLN820","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":256,"key":256,"name":"PA820\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":3195,"project_id":3176,"product_id":932,"amount":"24370","number":3,"cost":"17300","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"73110","total_cost":"51900","supplier":null,"product":{"id":932,"name":"Paloalto Software NGFW\u865a\u62df\u9632\u706b\u5899","product_type":5,"product_component":26,"product_brand":8,"product_serie":339,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-07-12 09:44:29","updated_at":"2023-08-11 16:03:42","pinyin_shortcut":"PaloaltoSoftwareNGFWxnfhq","product_unit":1,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":339,"key":339,"name":"PA\u865a\u62df\u7aef\u9632\u706b\u5899"},"productUnit":{"id":1,"key":1,"name":"\u53f0"}}},{"id":3196,"project_id":3176,"product_id":254,"amount":"48500","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"48500","total_cost":"0","supplier":null,"product":{"id":254,"name":"Paloalto IPS+AV\u8fc7\u6ee4\u6388\u6743","product_type":5,"product_component":36,"product_brand":8,"product_serie":167,"product_misc":5,"product_qa":4,"pn":"","description":"","created_by":1013,"created_at":"2017-08-11 10:09:53","updated_at":"2023-08-14 15:39:32","pinyin_shortcut":"PaloaltoIPSAVglsq","product_unit":2,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":167,"key":167,"name":"Paloalto\u5168\u7cfb\u5217"},"productUnit":{"id":2,"key":2,"name":"\u5957"}}},{"id":3197,"project_id":3176,"product_id":590,"amount":"48500","number":1,"cost":"0","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"48500","total_cost":"0","supplier":null,"product":{"id":590,"name":"PAN-SVC-BKLN-3050-R","product_type":5,"product_component":35,"product_brand":8,"product_serie":191,"product_misc":5,"product_qa":null,"pn":"","description":"Partner enabled premium support year 1 renewal, PA-3050","created_by":1013,"created_at":"2019-07-22 16:40:16","updated_at":"2024-01-12 15:19:03","pinyin_shortcut":"PANSVCBKLN3050R","product_unit":8,"is_renew":false,"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"},"productBrand":{"id":8,"key":8,"name":"Paloalto"},"productSerie":{"id":191,"key":191,"name":"PA3050\u4e00\u5e74\u670d\u52a1"},"productUnit":{"id":8,"key":8,"name":"\u5e74"}}},{"id":3198,"project_id":3176,"product_id":942,"amount":"0","number":1,"cost":"229450","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"229450","supplier":null,"product":{"id":942,"name":"\u7b2c\u4e09\u65b9\u5916\u91c7\u6280\u672f\u670d\u52a1","product_type":19,"product_component":151,"product_brand":134,"product_serie":593,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2023-08-03 09:30:30","updated_at":"2023-08-11 16:02:40","pinyin_shortcut":"dsfwcjsfw","product_unit":7,"is_renew":false,"productType":{"id":19,"key":19,"name":"\u6280\u672f\u670d\u52a1"},"productComponent":{"id":151,"key":151,"name":"\u4eba\u5de5\u670d\u52a1"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":593,"key":593,"name":"\u5b89\u88c5\u8c03\u8bd5\u670d\u52a1"},"productUnit":{"id":7,"key":7,"name":"\u6b21"}}},{"id":3199,"project_id":3176,"product_id":1208,"amount":"0","number":2,"cost":"222.39","description":"\u8d60\u9001","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"0","total_cost":"444.78","supplier":null,"product":{"id":1208,"name":"\u4e1c\u6765\u987a \u798f\u8fd0\u4e1c\u6765\u719f\u98df\u793c\u76d2\uff081.85KG\uff09","product_type":23,"product_component":195,"product_brand":182,"product_serie":757,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2024-01-11 10:15:54","updated_at":"2024-01-11 10:15:54","pinyin_shortcut":"dlsfydlsslh185KG","product_unit":9,"is_renew":false,"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"},"productBrand":{"id":182,"key":182,"name":"\u4e1c\u6765\u987a"},"productSerie":{"id":757,"key":757,"name":"\u4e1c\u6765\u987a\u725b\u8089\u719f\u98df\u793c\u76d2"},"productUnit":{"id":9,"key":9,"name":"\u76d2"}}}],"projectContactPoints":[{"id":359,"project_id":3176,"contact_id":3287,"point":"264050.00","paid_point":"264050","contact":{"id":3287,"key":3287,"name":"\u738b\u5bb8","client_id":null,"supplier_id":68,"client":null,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"}},"projectContactPointRels":[{"id":29,"project_id":3176,"contact_id":3287,"point":"264050.00","day_at":"2023-08-22","description":"\u7ed9\u767e\u8fbe\u4fe1\u901a\u6c47\u6b3e \u6536\u53d1\u7968","created_at":"2024-01-11 15:02:00"}],"status_display":"\u5df2\u6838\u9500"}],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":-2223.9,"contact_points_status_display":"\u5df2\u6838\u9500"},"salesSupplierRels":[{"id":214,"contract_id":2690,"supplier_id":68,"purchase_id":2715,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2715,"key":2715,"serial_no":"BJ7067-PA-WXY-20230530"}},{"id":1375,"contract_id":2690,"supplier_id":68,"purchase_id":2689,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2689,"key":2689,"serial_no":"BJ7067-PA-WXY-20230607"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[{"id":407,"key":407,"contract_id":2690,"name":"2023-09-15"},{"id":408,"key":408,"contract_id":2690,"name":"2023-12-15"},{"id":409,"key":409,"contract_id":2690,"name":"2024-03-15"},{"id":410,"key":410,"contract_id":2690,"name":"2024-06-14"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":434,"contract_id":2690,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":4792,"user_id":5300,"key":5300,"contract_id":2690,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1244,"key":1244,"contract_id":2690,"name":"2023-08-31","value":"353000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1593,"key":1593,"contract_id":2690,"value":"353000","created_by":1014,"created_at":"2023-08-04 10:59:44","description":null,"collected_date":"2023-08-04","amount":"353000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1409,"key":1409,"contract_id":2690,"value":"353000.00","attachment_id":null,"from_date":"2023-06-16","attachment":null,"attachmentRelationships":[],"files":[{"id":19003,"object_type":102,"object_id":1409,"attachment_id":13601,"attachment":{"id":13601,"key":13601,"name":"12d55c6a-44a9-3147-aa6c-cd1da42608fc","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/12d55c6a-44a9-3147-aa6c-cd1da42608fc\/2023_06_16_10_47_02.pdf","orig_name":"2023_06_16_10_47_02.pdf"}}]}],"contractScans":[{"id":23735,"object_type":105,"object_id":2690,"attachment_id":13359,"attachment":{"id":13359,"key":13359,"name":"d8836341-f51c-3b2d-9b26-60a34bd77027","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d8836341-f51c-3b2d-9b26-60a34bd77027\/\u6c7d\u8f66\u4e4b\u5bb6\u5408\u540c.pdf","orig_name":"\u6c7d\u8f66\u4e4b\u5bb6\u5408\u540c.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":353000,"projectProductTotalAmount":353000,"projectProductAllAmount":true,"projectProductTotalCost":335794.78,"projectProductAllCost":true,"projectProductTotalCount":10,"invoiced":353000,"un_invoiced":0,"collected":353000,"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":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d2\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2487,"client_id":1663,"signed_at":"2022-12-21","amount":"132000","handler":5300,"description":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd\n4\u53f0\n1\u5e74","created_by":5300,"created_at":"2022-11-18 09:54:48","updated_at":"2022-12-30 16:27:24","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":2996,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"7 days","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSC-SQY-2022101002","payment_collection_remind_ahead":"15 days","from_project":2996,"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":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2487,"comment":5},"project":{"id":2996,"key":2996,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd-2022"},"fromProject":{"id":2996,"key":2996,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd-2022","description":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd\n4\u53f0\n1\u5e74","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-12-21","collected":"132000","profit_pct":"5.91","budget":"132000","projectProductTypes":[{"id":4817,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"132000","pct":"5.91","project_id":2996,"profit":"7801.2"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2996,"sum":"71.00"},"profit":7801.2,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1229,"contract_id":2487,"supplier_id":488,"purchase_id":2489,"supplier":{"id":488,"key":488,"name":"\u65f6\u5229\u548c\u901a(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2489,"key":2489,"serial_no":"SLHT20221024001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[{"id":326,"key":326,"contract_id":2487,"name":"2023-02-28"},{"id":327,"key":327,"contract_id":2487,"name":"2023-05-31"},{"id":328,"key":328,"contract_id":2487,"name":"2023-08-31"},{"id":329,"key":329,"contract_id":2487,"name":"2023-11-30"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":360,"contract_id":2487,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":3544,"user_id":5300,"key":5300,"contract_id":2487,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1116,"key":1116,"contract_id":2487,"name":"2023-02-28","value":"132000","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1493,"key":1493,"contract_id":2487,"value":"132000","created_by":1014,"created_at":"2023-02-23 17:22:36","description":null,"collected_date":"2023-02-23","amount":"132000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1314,"key":1314,"contract_id":2487,"value":"132000.00","attachment_id":null,"from_date":"2022-12-05","attachment":null,"attachmentRelationships":[],"files":[{"id":16704,"object_type":102,"object_id":1314,"attachment_id":11578,"attachment":{"id":11578,"key":11578,"name":"f43aa028-8b55-3423-97bd-97b6bb304431","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/f43aa028-8b55-3423-97bd-97b6bb304431\/2022_12_05_14_50_30.pdf","orig_name":"2022_12_05_14_50_30.pdf"}}]}],"contractScans":[{"id":17028,"object_type":105,"object_id":2487,"attachment_id":11534,"attachment":{"id":11534,"key":11534,"name":"c7e9ff6d-d00d-3a22-bb04-86c0700e57fa","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/c7e9ff6d-d00d-3a22-bb04-86c0700e57fa\/2022_11_21_14_46_12.pdf","orig_name":"2022_11_21_14_46_12.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":132000,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":132000,"un_invoiced":0,"collected":132000,"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":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d15\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2498,"client_id":1663,"signed_at":"2022-11-14","amount":"846500","handler":5300,"description":"PA\u9632\u706b\u5899\uff1a\nPA5220 1\u53f0\n\u9632\u706b\u5899\u541e\u5410 18Gbps \u5e76\u53d1\u4f1a\u8bdd\u6570 400\u4e07 \u6bcf\u79d2\u65b0\u5efa\u4f1a\u8bdd\u6570 17.1\u4e07 \u865a\u62df\u5316\u7cfb\u7edf \u9ed8\u8ba410\/20\u53ef\u6269\u5c55 \u5305\u542b\u53cc\u7535\u6e90\u53ca\u53cc\u673a\u90e8\u7f72\n\u5305\u542b\u786c\u4ef6\u8d28\u4fdd3\u5e74\uff0c\u786c\u4ef6\u6545\u969c\u76f4\u63a5\u66f4\u6362\u65b0\u9632\u706b\u5899\u786c\u4ef6\uff0c\u7b2c\u4e8c\u4e2a\u5de5\u4f5c\u65e5\u53d1\u8d27\u3002\n\u9ad8\u7ea7\u5a01\u80c1\u9632\u62a4\u7eed\u4fdd\u670d\u52a1,\u5305\u542b\u5165\u4fb5\u68c0\u6d4b\u5a01\u80c1\uff0c\u9632\u75c5\u6bd2\u5a01\u80c1\uff0c\u95f4\u8c0d\u8f6f\u4ef6\u3002","created_by":5300,"created_at":"2022-12-05 13:47:23","updated_at":"2023-03-13 09:48:03","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3020,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"7 days","expire_remind_ahead":"","expire_reminded":false,"serial_no":"ATPE-2022047","payment_collection_remind_ahead":"15 days","from_project":3020,"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":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2498,"comment":4},"project":{"id":3020,"key":3020,"name":"PA5220\u65b0\u8d2d1\u53f0-2022-C"},"fromProject":{"id":3020,"key":3020,"name":"PA5220\u65b0\u8d2d1\u53f0-2022-C","description":"PA\u9632\u706b\u5899\uff1a\nPA5220 1\u53f0\n\u9632\u706b\u5899\u541e\u5410 18Gbps \u5e76\u53d1\u4f1a\u8bdd\u6570 400\u4e07 \u6bcf\u79d2\u65b0\u5efa\u4f1a\u8bdd\u6570 17.1\u4e07 \u865a\u62df\u5316\u7cfb\u7edf \u9ed8\u8ba410\/20\u53ef\u6269\u5c55 \u5305\u542b\u53cc\u7535\u6e90\u53ca\u53cc\u673a\u90e8\u7f72\n\u5305\u542b\u786c\u4ef6\u8d28\u4fdd3\u5e74\uff0c\u786c\u4ef6\u6545\u969c\u76f4\u63a5\u66f4\u6362\u65b0\u9632\u706b\u5899\u786c\u4ef6\uff0c\u7b2c\u4e8c\u4e2a\u5de5\u4f5c\u65e5\u53d1\u8d27\u3002\n\u9ad8\u7ea7\u5a01\u80c1\u9632\u62a4\u7eed\u4fdd\u670d\u52a1,\u5305\u542b\u5165\u4fb5\u68c0\u6d4b\u5a01\u80c1\uff0c\u9632\u75c5\u6bd2\u5a01\u80c1\uff0c\u95f4\u8c0d\u8f6f\u4ef6\u3002","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-11-14","collected":"846500","profit_pct":"2.35","budget":"846500","projectProductTypes":[{"id":4846,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"846500.00","pct":"2.35","project_id":3020,"profit":"19892.75"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":3020,"sum":"269.00"},"profit":19892.75,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":395,"contract_id":2498,"supplier_id":68,"purchase_id":2530,"supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchase":{"id":2530,"key":2530,"serial_no":"BJ7067-WXY-20221124"}}],"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":[{"id":334,"key":334,"contract_id":2498,"name":"2023-03-31"},{"id":335,"key":335,"contract_id":2498,"name":"2023-06-30"},{"id":336,"key":336,"contract_id":2498,"name":"2023-09-29"},{"id":337,"key":337,"contract_id":2498,"name":"2023-12-29"}],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[{"id":359,"contract_id":2498,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":3722,"user_id":5300,"key":5300,"contract_id":2498,"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"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1216,"key":1216,"contract_id":2498,"name":"2023-05-31","value":"846500","overdue_days":null,"pct":100,"collect_status":"\u5df2\u5b8c\u6210"}],"salesContractPayments":[{"id":1529,"key":1529,"contract_id":2498,"value":"846500","created_by":1014,"created_at":"2023-05-11 14:50:02","description":null,"collected_date":"2023-05-11","amount":"846500","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1315,"key":1315,"contract_id":2498,"value":"846500.00","attachment_id":null,"from_date":"2022-12-08","attachment":null,"attachmentRelationships":[],"files":[{"id":16716,"object_type":102,"object_id":1315,"attachment_id":11591,"attachment":{"id":11591,"key":11591,"name":"4dd6c30c-fb08-32d3-935d-ed3c688cc43c","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/4dd6c30c-fb08-32d3-935d-ed3c688cc43c\/2022_12_08_10_36_08.pdf","orig_name":"2022_12_08_10_36_08.pdf"}}]}],"contractScans":[{"id":17024,"object_type":105,"object_id":2498,"attachment_id":11592,"attachment":{"id":11592,"key":11592,"name":"6df73f53-3c1e-314f-a37f-e33423790093","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/6df73f53-3c1e-314f-a37f-e33423790093\/2022_12_08_11_07_27.pdf","orig_name":"2022_12_08_11_07_27.pdf"}}],"receiptScans":[{"id":17530,"object_type":106,"object_id":2498,"attachment_id":12214,"attachment":{"id":12214,"key":12214,"name":"d7d40bce-ad23-34c3-89bf-c0509776645d","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/d7d40bce-ad23-34c3-89bf-c0509776645d\/2023_03_13_09_47_23.pdf","orig_name":"2023_03_13_09_47_23.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":846500,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":846500,"un_invoiced":0,"collected":846500,"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":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u63d0\u524d15\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true},{"id":2260,"client_id":1663,"signed_at":"2022-04-29","amount":"259000","handler":5300,"description":"PA\u9632\u706b\u5899+VPN\u7eed\u4fdd\n1\u3001Palo Alto Networks PA-5220 1\u53f0 \u9632\u706b\u5899\u7eed\u4fdd\u670d\u52a1\n\u5305\u542b\u786c\u4ef6\u8d28\u4fdd1\u5e74\uff0c\u786c\u4ef6\u6545\u969c\u76f4\u63a5\u66f4\u6362\u65b0\u9632\u706b\u5899\u786c\u4ef6\n2\u3001 Palo Alto Networks VPN \u7eed\u4fdd\u670d\u52a1\u9700\u6c42\u660e\u7ec6\nVM-300 3\u53f0\n\u5305\u542b\u865a\u62df\u5316\u8f6f\u4ef6\u8d28\u4fdd1\u5e74\uff0c\u8f6f\u4ef6\u7ef4\u62a4\uff0c\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\u5305\uff0c\u9ad8\u7ea7\u5a01\u80c1\u9632\u62a4\u7eed\u4fdd\u670d\u52a1,\u5305\u542b\u5165\u4fb5\u68c0\u6d4b\u5a01\u80c1\uff0c\u9632\u75c5\u6bd2\u5a01\u80c1\uff0c\u95f4\u8c0d\u8f6f\u4ef6,DNS\u5b89\u5168\uff0cURL\u8fc7\u6ee4\u5185\u5bb9\u5b89\u5168\uff0c\u79fb\u52a8\u7ec8\u7aef\u63a5\u5165\u5b89\u5168\uff0c\u6c99\u7bb1\u5206\u6790\u7b49\u3002","created_by":5300,"created_at":"2022-05-05 10:18:45","updated_at":"2022-07-05 11:00:17","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":2818,"valid_date":null,"expire_date":"2023-05-22","sla":"","remind_ahead":"7 days","expire_remind_ahead":"30 days","expire_reminded":true,"serial_no":"TS-SQY-2022042901","payment_collection_remind_ahead":"30 days","from_project":2818,"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":785,"passed":2,"client":{"id":1663,"key":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","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":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"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2260,"comment":5},"project":{"id":2818,"key":2818,"name":"PA\u9632\u706b\u5899+VPN\u7eed\u4fdd1\u5e74"},"fromProject":{"id":2818,"key":2818,"name":"PA\u9632\u706b\u5899+VPN\u7eed\u4fdd1\u5e74","description":"PA\u9632\u706b\u5899+VPN\u7eed\u4fdd\n1\u3001Palo Alto Networks PA-5220 1\u53f0 \u9632\u706b\u5899\u7eed\u4fdd\u670d\u52a1\n\u5305\u542b\u786c\u4ef6\u8d28\u4fdd1\u5e74\uff0c\u786c\u4ef6\u6545\u969c\u76f4\u63a5\u66f4\u6362\u65b0\u9632\u706b\u5899\u786c\u4ef6\n2\u3001 Palo Alto Networks VPN \u7eed\u4fdd\u670d\u52a1\u9700\u6c42\u660e\u7ec6\nVM-300 3\u53f0\n\u5305\u542b\u865a\u62df\u5316\u8f6f\u4ef6\u8d28\u4fdd1\u5e74\uff0c\u8f6f\u4ef6\u7ef4\u62a4\uff0c\u8f6f\u4ef6\u5347\u7ea7\u670d\u52a1\u5305\uff0c\u9ad8\u7ea7\u5a01\u80c1\u9632\u62a4\u7eed\u4fdd\u670d\u52a1,\u5305\u542b\u5165\u4fb5\u68c0\u6d4b\u5a01\u80c1\uff0c\u9632\u75c5\u6bd2\u5a01\u80c1\uff0c\u95f4\u8c0d\u8f6f\u4ef6,DNS\u5b89\u5168\uff0cURL\u8fc7\u6ee4\u5185\u5bb9\u5b89\u5168\uff0c\u79fb\u52a8\u7ec8\u7aef\u63a5\u5165\u5b89\u5168\uff0c\u6c99\u7bb1\u5206\u6790\u7b49\u3002","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-04-29","collected":"259000","profit_pct":"0","budget":"259000","projectProductTypes":[{"id":4779,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"259000.00","pct":"0","project_id":2818,"profit":"0"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":null,"profit":0,"contact_points_status_display":"\u672a\u8bbe\u7f6e"},"salesSupplierRels":[{"id":1324,"contract_id":2260,"supplier_id":365,"purchase_id":2280,"supplier":{"id":365,"key":365,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2280,"key":2280,"serial_no":"TSKJ-HYF-20220518001"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"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":[{"id":279,"key":279,"contract_id":2260,"name":"2022-08-19"},{"id":280,"key":280,"contract_id":2260,"name":"2022-11-21"},{"id":281,"key":281,"contract_id":2260,"name":"2023-02-20"},{"id":282,"key":282,"contract_id":2260,"name":"2023-05-19"}],"salesContractRemindReceivers":[{"id":7274,"user_id":5300,"key":5300,"contract_id":2260,"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"}}},{"id":7275,"user_id":1011,"key":1011,"contract_id":2260,"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"}}}],"serviceContractRemindReceivers":[{"id":326,"contract_id":2260,"user_id":5300,"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"}}}],"salesContractPaymentCollectionRemindReceivers":[{"id":3169,"user_id":5300,"key":5300,"contract_id":2260,"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"}}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":1357,"key":1357,"contract_id":2260,"value":"259000","created_by":1014,"created_at":"2022-07-25 14:07:23","description":null,"collected_date":"2022-07-25","amount":"259000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"files":[],"pct":100}],"salesContractInvoices":[{"id":1215,"key":1215,"contract_id":2260,"value":"259000.00","attachment_id":null,"from_date":"2022-06-15","attachment":null,"attachmentRelationships":[],"files":[{"id":15332,"object_type":102,"object_id":1215,"attachment_id":10363,"attachment":{"id":10363,"key":10363,"name":"bc3e1a9a-b712-31b4-b20a-4c4e301066c6","extension":"pdf","path":"\/v2\/attachment\/view\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/bc3e1a9a-b712-31b4-b20a-4c4e301066c6\/2022_06_15_15_16_35.pdf","orig_name":"2022_06_15_15_16_35.pdf"}}]}],"contractScans":[{"id":15464,"object_type":105,"object_id":2260,"attachment_id":10259,"attachment":{"id":10259,"key":10259,"name":"bd4b8c32-9654-37e5-b741-eb31ff57cf63","extension":"pdf","path":"\/v2\/attachment\/preview\/oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH\/bd4b8c32-9654-37e5-b741-eb31ff57cf63\/2022_06_06_09_56_41.pdf","orig_name":"2022_06_06_09_56_41.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":259000,"un_invoiced":0,"collected":259000,"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":"\u63d0\u524d7\u5929","expire_remind_ahead_display":"\u63d0\u524d30\u5929","payment_collection_remind_ahead_display":"\u63d0\u524d30\u5929","can_update":true,"can_delete":false,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-15 15:41:06') RETURNING "id"
15:41:06.5963.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (22125, 17796, 20578)
15:41:06.5693.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE "id"=3287
15:41:06.4842.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'
15:41:06.5722.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE ("contact_id", "project_id") IN ((3287, 3176))
15:41:06.5741.8 msyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (2818, 2996, 3020, 3176, 3261, 3361, 3507, 3596))
15:41:06.4821.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:41:06.5761.4 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("project_id" IN (2818, 2996, 3020, 3176, 3261, 3361, 3507, 3596)) GROUP BY "project_id"
15:41:06.6201.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=12214
15:41:06.6021.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1215, 1314, 1315, 1409, 1460, 1568, 1678, 1736))
15:41:06.5951.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=109) AND ("object_id" IN (1357, 1493, 1529, 1593, 1645, 1789, 1913, 1989))
15:41:06.6121.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260))
15:41:06.6191.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260))
15:41:06.6011.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1215, 1314, 1315, 1409, 1460, 1568, 1678, 1736))
15:41:06.4871.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:41:06.6211.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260))
15:41:06.5280.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1663
15:41:06.5490.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3596, 3507, 3361, 3261, 3176, 2996, 3020, 2818)
15:41:06.5510.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 (2818, 2996, 3020, 3176, 3261, 3361, 3507, 3596)
15:41:06.5520.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2818, 2996, 3020, 3176, 3261, 3361, 3507, 3596)
15:41:06.6000.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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260) ORDER BY "id"
15:41:06.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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260) ORDER BY "id"
15:41:06.5780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)
15:41:06.5900.4 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)
15:41:06.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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260) ORDER BY "remind_date"
15:41:06.5920.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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)
15:41:06.5500.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 (3596, 3507, 3361, 3261, 3176, 2996, 3020, 2818)
15:41:06.5890.4 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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)) ORDER BY "remind_date"
15:41:06.5300.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
15:41:06.5520.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 365)
15:41:06.5600.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 19, 4, 23)
15:41:06.5670.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2818, 2996, 3020, 3176, 3261, 3361, 3507, 3596)
15:41:06.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (35, 36, 151, 51, 26, 195)
15:41:06.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 134, 12, 182)
15:41:06.5310.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
15:41:06.5880.3 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
15:41:06.5910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)
15:41:06.5670.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (2, 7, 8, 1, 9)
15:41:06.5900.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 (3437, 3316, 3015, 2788, 2690, 2487, 2498, 2260)
15:41:06.5300.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
15:41:06.5310.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
15:41:06.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"=5300)
15:41:06.5790.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (488, 68, 90, 365)
15:41:06.5290.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
15:41:06.5930.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1001, 5388)
15:41:06.5880.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
15:41:06.5950.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 1013)
15:41:06.5910.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 (1011, 5300))
15:41:06.5930.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, 5388, 5300))
15:41:06.5890.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
15:41:06.5910.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1011)
15:41:06.5920.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
15:41:06.5720.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=68