ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a20e09de3b3b: POST https://beta.jinchangxiao.com/v2/sales-contract/of-client at 2026-06-04 10:19:09 am by 223.104.42.221

Performance Profiling

Total processing time: 709 ms; Peak memory: 6.150 MB. Show Profiling Timeline

总计67条数据
TimeDurationCategoryInfo
  
10:19:10.52030.2 msyii\db\Command::querySELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (4483, 4289, 2818, 2358)) GROUP BY "object_id"
10:19:10.60424.3 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 (4483, 4289, 2818, 2358)) GROUP BY "object_id"
10:19:10.48317.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='2128' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"
10:19:10.50114.9 msyii\db\Command::querySELECT c.*, abs(c.expire_date - current_date) AS b_date, CASE WHEN c.expire_date IS NULL THEN 1 ELSE 2 END AS passed FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = c.from_project LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "cs" ON cs.object_id = c.id AND cs.object_type = 105 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "rs" ON rs.object_id = c.id AND rs.object_type = 106 LEFT JOIN "a57be577deb434"."tbl_attachement_relationships" "vs" ON vs.object_id = c.id AND vs.object_type = 107 WHERE "client"."id"='2128' GROUP BY "c"."id" ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 10
10:19:10.5924.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id" IN (4483, 4289, 2818, 2358))
10:19:10.5834.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1259, 1542, 2257))
10:19:10.5874.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1259, 1542, 2257))
10:19:10.4713.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
10:19:10.5643.6 msyii\db\Command::querySELECT "id", "project_id" FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("is_system"=TRUE) AND ("project_id" IN (2882, 3695, 2775))
10:19:10.6003.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=107) AND ("object_id" IN (4483, 4289, 2818, 2358))
10:19:10.6362.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/sales-contract/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"2128","page":"1","posttime":"1780539520","token":"07bdc824e77c4d5592868273ae1cca3b","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":4483,"client_id":2128,"signed_at":"2026-05-27","amount":"0","handler":5087,"description":"","created_by":5250,"created_at":"2026-05-27 19:24:26","updated_at":"2026-05-27 19:24:26","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":null,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":null,"receipt_date":null,"verify_date":null,"including_tax":true,"build_by_project":false,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":"","is_verify":false,"is_draft":false,"erp_settle_amount":"0","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"0","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":false,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":null,"project":null,"erpSalesOrder":null,"fromProject":null,"salesSupplierRels":[],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"contractScans":[],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":0,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":null,"un_invoiced":0,"collected":"0","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","payment_collection_remind_ahead_display":"\u65e0","can_update":true,"can_delete":true,"unread":0,"bgcolor":"#89c541","can_view_product":true,"can_progress":true,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":4289,"client_id":2128,"signed_at":"2025-11-30","amount":"631660","handler":5087,"description":"","created_by":5087,"created_at":"2025-12-07 22:24:07","updated_at":"2026-02-02 08:56:38","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":3695,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"2025-12-07-002","payment_collection_remind_ahead":"30 days","from_project":3695,"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":"2025-12-30 11:38:41","is_verify":false,"is_draft":true,"erp_settle_amount":"600077","erp_un_settle_amount":"31583","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"600077","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":4289,"comment":8},"project":{"id":3695,"key":3695,"name":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","erpSalesOrder":{"id":1635,"serial_no":"XSDD-20251207-00002","from_date":null,"wrote_date":"2025-11-30","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3695,"sales_contract_id":4289,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-07 22:24:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"23","amount":"631660","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-07 22:23:52","updated_at":"2025-12-07 22:24:07","print_times":null,"erpSalesOrderVerifyRels":[{"id":73,"erp_sales_order_id":1635,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-07 22:24:07"}],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1635,"serial_no":"XSDD-20251207-00002","from_date":null,"wrote_date":"2025-11-30","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3695,"sales_contract_id":4289,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-07 22:24:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"23","amount":"631660","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-07 22:23:52","updated_at":"2025-12-07 22:24:07","print_times":null,"erpSalesOrderVerifyRels":[{"id":73,"erp_sales_order_id":1635,"user_id":1001,"status":1,"description":null,"verify_at":"2025-12-07 22:24:07"}],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":3695,"key":3695,"name":"\u5907\u4efd\u7cfb\u7edf\u56fd\u4ea7\u5316\u66ff\u4ee3-K","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":true,"project_product_version_id":1312,"bargain_date":"2025-11-30","collected":"600077","profit_pct":"42.15","budget":"631660","erpSalesOrder":{"id":1635,"serial_no":"XSDD-20251207-00002","from_date":null,"wrote_date":"2025-11-30","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":3695,"sales_contract_id":4289,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":null,"verify_type":2,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2025-12-07 22:24:07","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"23","amount":"631660","created_by":5087,"stop_description":null,"extra":"{\"payment_collection_remind_ahead\":\"1 day\",\"salesContractPaymentCollectionRemindReceivers\":[\"5087\"],\"salesContractPaymentCollectionRemindDates\":null}","outbound_status":true,"is_used":true,"is_cancel":false,"is_settle":false,"is_old":false,"created_at":"2025-12-07 22:23:52","updated_at":"2025-12-07 22:24:07","print_times":null},"projectProductTypes":[{"id":8339,"product_type_id":2,"key":2,"name":"\u670d\u52a1\u5668","budget":"63139","pct":"42.15","project_id":3695,"profit":"26613.08"},{"id":8340,"product_type_id":7,"key":7,"name":"\u8f6f\u4ef6","budget":"568521","pct":"42.15","project_id":3695,"profit":"239631.60"}],"projectProductRels":[{"id":11903,"project_id":3695,"product_id":1942,"amount":"568521","number":1,"cost":"250000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"568521","total_cost":"250000","erp_sales_order_product_id":2139,"supplier":null,"product":{"id":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","product_type":7,"product_component":30,"product_brand":227,"product_serie":1600,"product_misc":null,"product_qa":null,"pn":"","description":"\"\u8f6f\u4ef6\u57fa\u7840\u5e73\u53f0\uff1a\n64bit \u4f01\u4e1a\u7ea7 Linux \u5185\u6838\uff0c\u57fa\u4e8eWEB \u754c\u9762\u7684\u6570\u636e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf \u8f6f\u4ef6\uff0c\u6807\u914d\u6587\u4ef6\/\u6570\u636e\u5e93\n\/Windows\/Linux\/\u865a\u62df\u5316\u5b9a\u65f6\u5907\u4efd\u529f\u80fd\u3002\n\u5bb9\u91cf\u6388\u6743\uff1a\nUnaRDP-1P\uff1a1P \u5b9a\u65f6\u5907\u4efd\u5bb9\u91cf\u6388\u6743\u3002\n\u9ad8\u7ea7\u529f\u80fd\u6388\u6743\uff1a\nUnaDedupe-LIC*3\uff1a3\u4e2a\u91cd\u5220\u529f\u80fd \u6388\u6743\uff0c\u542b\u6e90\u7aef\u548c\u76ee\u6807\u7aef\u91cd\u5220\uff1b\u5b9e \u65f6\u5907\u4efd\u5bb9\u91cf\u4e0d\u652f\u6301\u91cd\u5220\u529f\u80fd\uff1bCDM \u529f\u80fd\u6253\u5f00\u65f6\u4ec5\u652f\u6301\u76ee\u6807\u7aef\u91cd\u5220\u3002\n(\u6ce8\uff1a\u5982\u679c\u9009\u62e9\u91cd\u5220\u529f\u80fd\uff0c\u5fc5\u987b\u589e \u914d RAID \u5361\u6389\u7535\u4fdd\u62a4)\u3002\nUnaD2D2R-LIC*3\uff1a3\u4e2a\u4e24\u53f0\u9ed1\u65b9\u670d \u52a1\u5668\u4e4b\u95f4\u7684\u6570\u636e\u5f02\u5730\u540c\u6b65\u901a\u9053\u6388 \u6743\uff0c\u652f\u6301\u5c06\u672c\u5730\u9ed1\u65b9\u670d\u52a1\u5668\u4e2d\u5907 \u4efd\u6216\u5bb9\u707e\u6570\u636e\u96c6\u540c\u6b65\u81f3\u5f02\u5730\u9ed1\u65b9 \u670d\u52a1\u5668\u3002\u76ee\u7684\u7aef\u53ea\u9700\u786e\u4fdd\u914d\u7f6e\u57fa \u672c\u4ef6\uff0c\u65e0\u9700\u914d\u7f6e\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u3002\u8fdc\u7a0b\u590d\u5236\u4ee3\u7406\u6570\u91cf\u7531\u6e90\u7aef\u7ba1\u7406\u63a7 \u5236\u53f0\u7684\u6570\u91cf\u51b3\u5b9a\u3002\"\n","created_by":1013,"created_at":"2025-02-26 11:00:56","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"yjzhfrzbfyhfxtrjV6","product_unit":2,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":30,"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6"},"productBrand":{"id":227,"key":227,"name":"\u58f9\u8fdb\u5236"},"productSerie":{"id":1600,"key":1600,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6.0"},"productUnit":{"id":2,"key":2,"name":"\u5957"}},"erpSalesOrderProduct":{"id":2139,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":1942,"description":"","number":"1","outbound":"1","amount":"568521","total_amount":"568521","last_number":"1","last_amount":"568521","last_total_amount":"568521","cost":"250000","total_cost":"250000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11904,"project_id":3695,"product_id":2227,"amount":"3580","number":9,"cost":"3766.67","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"32220","total_cost":"33900","erp_sales_order_product_id":2140,"supplier":null,"product":{"id":2227,"name":"00Y9087","product_type":2,"product_component":5,"product_brand":4,"product_serie":41,"product_misc":null,"product_qa":null,"pn":"","description":"\u8054\u60f3 00Y9087 4XB7A13911 16TB SAS 3.5\u5bf8","created_by":1013,"created_at":"2026-01-08 10:11:34","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"00Y9087","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":41,"key":41,"name":"SATA"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2140,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2227,"description":"","number":"9","outbound":"9","amount":"3580","total_amount":"32220","last_number":"9","last_amount":"3580","last_total_amount":"32220","cost":"3766.67","total_cost":"33900","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11905,"project_id":3695,"product_id":2226,"amount":"2640","number":1,"cost":"2500","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2640","total_cost":"2500","erp_sales_order_product_id":2141,"supplier":null,"product":{"id":2226,"name":"\u8054\u60f3RAID\u5361 730-8i-2G\u7f13\u5b58\/\u542b\u7535\u6c60","product_type":2,"product_component":7,"product_brand":4,"product_serie":1755,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-01-08 10:03:59","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"lxRAIDk7308i2Ghchdc","product_unit":3,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1755,"key":1755,"name":"RAID\u5361 730-8i-2G"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2141,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2226,"description":"","number":"1","outbound":"1","amount":"2640","total_amount":"2640","last_number":"1","last_amount":"2640","last_total_amount":"2640","cost":"2500","total_cost":"2500","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11906,"project_id":3695,"product_id":2225,"amount":"2640","number":1,"cost":"1400","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"2640","total_cost":"1400","erp_sales_order_product_id":2142,"supplier":null,"product":{"id":2225,"name":"Mega RAID SAS 9361-8i 1G\u542b\u6389\u7535\u4fdd\u62a4","product_type":2,"product_component":7,"product_brand":4,"product_serie":1754,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2026-01-08 10:02:49","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"MegaRAIDSAS93618i1Ghddbh","product_unit":3,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":7,"key":7,"name":"\u670d\u52a1\u5668\u9635\u5217\u5361"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1754,"key":1754,"name":"Mega RAID SAS 9361-8i"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesOrderProduct":{"id":2142,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2225,"description":"","number":"1","outbound":"1","amount":"2640","total_amount":"2640","last_number":"1","last_amount":"2640","last_total_amount":"2640","cost":"1400","total_cost":"1400","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11907,"project_id":3695,"product_id":2041,"amount":"1539","number":1,"cost":"800","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"1539","total_cost":"800","erp_sales_order_product_id":2143,"supplier":null,"product":{"id":2041,"name":"X710-DA2","product_type":2,"product_component":9,"product_brand":5,"product_serie":1658,"product_misc":null,"product_qa":null,"pn":"","description":" intel \u53cc\u53e3\u4e07\u5146\u5149\u7ea4\u7f51\u5361 X710-DA2 10G SFP+\u7f51\u5361\uff08\u542b\u6a21\u5757\uff09","created_by":1013,"created_at":"2025-07-15 13:52:12","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"X710DA2","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":9,"key":9,"name":"\u670d\u52a1\u5668\u7f51\u5361"},"productBrand":{"id":5,"key":5,"name":"\u82f1\u7279\u5c14"},"productSerie":{"id":1658,"key":1658,"name":"X710-DA2\u53cc\u53e3\u4e07\u5146\u7f51\u5361"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2143,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2041,"description":"","number":"1","outbound":"1","amount":"1539","total_amount":"1539","last_number":"1","last_amount":"1539","last_total_amount":"1539","cost":"800","total_cost":"800","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11908,"project_id":3695,"product_id":1923,"amount":"2250","number":6,"cost":"2233","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"13500","total_cost":"13398","erp_sales_order_product_id":2144,"supplier":null,"product":{"id":1923,"name":"32GB PC4-2666P\u5185\u5b58","product_type":2,"product_component":4,"product_brand":10,"product_serie":31,"product_misc":null,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2025-01-09 10:41:37","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"32GBPC42666Pnc","product_unit":6,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":4,"key":4,"name":"\u670d\u52a1\u5668\u5185\u5b58"},"productBrand":{"id":10,"key":10,"name":"\u4e09\u661f"},"productSerie":{"id":31,"key":31,"name":"DDR4"},"productUnit":{"id":6,"key":6,"name":"\u6761"}},"erpSalesOrderProduct":{"id":2144,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":1923,"description":"","number":"6","outbound":"6","amount":"2250","total_amount":"13500","last_number":"6","last_amount":"2250","last_total_amount":"13500","cost":"2233","total_cost":"13398","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11909,"project_id":3695,"product_id":587,"amount":"2650","number":2,"cost":"2000","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"4000","erp_sales_order_product_id":2159,"supplier":null,"product":{"id":587,"name":"4XB7A10154","product_type":2,"product_component":5,"product_brand":4,"product_serie":42,"product_misc":8,"product_qa":null,"pn":"","description":"","created_by":1013,"created_at":"2019-07-22 11:15:57","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"4XB7A10154","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":42,"key":42,"name":"960G SATA SSD 2.5 \u56fa\u6001\u786c\u76d8"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2159,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":587,"description":"","number":"2","outbound":"2","amount":"2650","total_amount":"5300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2000","total_cost":"4000","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}},{"id":11910,"project_id":3695,"product_id":2228,"amount":"2650","number":2,"cost":"2399","description":"","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"total_amount":"5300","total_cost":"4798","erp_sales_order_product_id":2160,"supplier":null,"product":{"id":2228,"name":"XA960LE10016","product_type":2,"product_component":5,"product_brand":21,"product_serie":1756,"product_misc":null,"product_qa":null,"pn":"","description":"\u5e0c\u6377Nytro1361\u7cfb\u5217 960G SATA SSD\u56fa\u6001\u786c\u76d8","created_by":1013,"created_at":"2026-01-08 10:20:33","updated_at":"2026-01-23 17:26:34","pinyin_shortcut":"XA960LE10016","product_unit":4,"is_renew":false,"in_out_at":"2026-01-23 17:26:34.477698+08","productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"},"productBrand":{"id":21,"key":21,"name":"\u5e0c\u6377"},"productSerie":{"id":1756,"key":1756,"name":"SSD"},"productUnit":{"id":4,"key":4,"name":"\u5757"}},"erpSalesOrderProduct":{"id":2160,"erp_sales_order_id":1635,"erp_store_id":null,"product_id":2228,"description":"","number":"2","outbound":"2","amount":"2650","total_amount":"5300","last_number":null,"last_amount":null,"last_total_amount":null,"cost":"2399","total_cost":"4798","supplier_id":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null}}],"projectContactPoints":[],"buildSalesOrderItems":[{"id":13848,"project_id":3695},{"id":13852,"project_id":3695},{"id":13861,"project_id":3695},{"id":13851,"project_id":3695},{"id":13850,"project_id":3695},{"id":13860,"project_id":3695},{"id":13849,"project_id":3695},{"id":13847,"project_id":3695},{"id":13843,"project_id":3695},{"id":13859,"project_id":3695},{"id":13842,"project_id":3695},{"id":13864,"project_id":3695},{"id":13863,"project_id":3695},{"id":13862,"project_id":3695},{"id":13858,"project_id":3695},{"id":13845,"project_id":3695},{"id":13857,"project_id":3695},{"id":13844,"project_id":3695},{"id":13856,"project_id":3695},{"id":13855,"project_id":3695},{"id":13853,"project_id":3695},{"id":13854,"project_id":3695},{"id":13846,"project_id":3695}],"reimbursementAmountSum":{"project_id":3695,"sum":"2028.08"},"profit":266244.69,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":4074,"contract_id":4289,"supplier_id":661,"purchase_id":4355,"supplier":{"id":661,"key":661,"name":"\u822a\u5929\u58f9\u8fdb\u5236\uff08\u6c5f\u82cf\uff09\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4355,"key":4355,"serial_no":"Unary-SO-2025122311"}},{"id":4075,"contract_id":4289,"supplier_id":678,"purchase_id":4368,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4368,"key":4368,"serial_no":"ZLQS20260107"}},{"id":4077,"contract_id":4289,"supplier_id":262,"purchase_id":4370,"supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchase":{"id":4370,"key":4370,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3371274017958727\/3371274017959694"}},{"id":4078,"contract_id":4289,"supplier_id":695,"purchase_id":3888,"supplier":{"id":695,"key":695,"name":"\u9b4f\u82f1\u660e"},"purchase":{"id":3888,"key":3888,"serial_no":"TSKJ20250430-HYF-001"}},{"id":4079,"contract_id":4289,"supplier_id":678,"purchase_id":4379,"supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4379,"key":4379,"serial_no":"ZLQS20260115"}},{"id":4080,"contract_id":4289,"supplier_id":505,"purchase_id":4387,"supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":4387,"key":4387,"serial_no":"TSKJ20260120-ZHF-001"}},{"id":4113,"contract_id":4289,"supplier_id":59,"purchase_id":4369,"supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":4369,"key":4369,"serial_no":"TGXC20260107-1"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":9983,"user_id":5087,"key":5087,"contract_id":4289,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":2703,"key":2703,"contract_id":4289,"name":"2026-01-31","value":"189498","overdue_days":53,"status":1,"remind_date":"2026-01-31","pct":30,"overdue_display":"\u903e\u671f53\u5929"},{"id":2704,"key":2704,"contract_id":4289,"name":"2026-04-30","value":"410579","overdue_days":null,"status":1,"remind_date":"2026-04-30","pct":65,"overdue_display":""},{"id":2705,"key":2705,"contract_id":4289,"name":"2027-01-31","value":"31583","overdue_days":null,"status":0,"remind_date":"2027-01-31","pct":5,"overdue_display":""}],"salesContractPayments":[{"id":"12196","key":"12196","contract_id":4289,"value":"600077","created_by":1013,"created_at":"2026-03-25 10:08:16","description":null,"collected_date":"2026-03-25 00:00:00","amount":"600077","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":95}],"salesContractInvoices":[{"id":2257,"key":2257,"contract_id":4289,"value":"631660.00","attachment_id":null,"from_date":"2025-12-23","description":"","is_draft":false,"is_cancel":false,"salesInvoiceAmounts":[{"id":1054,"sales_invoice_id":2257,"amount":"631660","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":54146,"object_type":102,"object_id":2257,"attachment_id":30778,"attachment":{"id":30778,"key":30778,"name":"c6890bcf-08d3-32b7-9bcf-70204696dac0","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/c6890bcf-08d3-32b7-9bcf-70204696dac0\/dzfp_25112000000292148380_\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u6240_20251223153656.pdf","orig_name":"dzfp_25112000000292148380_\u5317\u4eac\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u6240_20251223153656.pdf"}}]}],"contractScans":[{"id":55990,"object_type":105,"object_id":4289,"attachment_id":30794,"attachment":{"id":30794,"key":30794,"name":"de846180-cf65-3d7b-a817-1ad2d09cc669","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/de846180-cf65-3d7b-a817-1ad2d09cc669\/33\u6240-\u5907\u4efd\u5347\u7ea7\u6539\u9020\u5408\u540c.pdf","orig_name":"33\u6240-\u5907\u4efd\u5347\u7ea7\u6539\u9020\u5408\u540c.pdf"}}],"receiptScans":[{"id":56088,"object_type":106,"object_id":4289,"attachment_id":31683,"attachment":{"id":31683,"key":31683,"name":"c3987c2e-496d-3cf7-822f-67198b6d3098","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/c3987c2e-496d-3cf7-822f-67198b6d3098\/2026_02_02_08_55_58.pdf","orig_name":"2026_02_02_08_55_58.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":631660,"projectProductTotalAmount":631660,"projectProductAllAmount":true,"projectProductTotalCost":310796,"projectProductAllCost":true,"projectProductTotalCount":23,"invoiced":"631660.00","un_invoiced":0,"collected":"600077","un_collected":31583,"is_collected":false,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","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,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":31583},{"id":2818,"client_id":2128,"signed_at":"2023-01-16","amount":"260000","handler":5087,"description":"\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f01 \u6d41\u7a0b\u7ba1\u7406 2\u76d1\u63a73\u7f51\u7edcNAC\u51c6\u5165","created_by":5087,"created_at":"2023-08-28 17:00:14","updated_at":"2024-01-23 16:05:49","contract_scan":null,"receipt_scan":null,"contract_type":2,"project_id":2775,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"Z2023Q0024NT","payment_collection_remind_ahead":"30 days","from_project":2775,"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-06-03 18:25:50","is_verify":false,"is_draft":false,"erp_settle_amount":"260000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"260000","receipt_scan_uploaded":false,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2818,"comment":8},"project":{"id":2775,"key":2775,"name":"\u8fd0\u7ef4\u5e73\u53f0-k","erpSalesOrder":{"id":1085,"serial_no":"XSDD-20230828-00002","from_date":null,"wrote_date":"2023-01-16","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2775,"sales_contract_id":2818,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f01 \u6d41\u7a0b\u7ba1\u7406 2\u76d1\u63a73\u7f51\u7edcNAC\u51c6\u5165","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-06 11:17:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"0","amount":"260000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-08-28 17:00:14","updated_at":"2024-12-06 11:17:24","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":1085,"serial_no":"XSDD-20230828-00002","from_date":null,"wrote_date":"2023-01-16","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2775,"sales_contract_id":2818,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f01 \u6d41\u7a0b\u7ba1\u7406 2\u76d1\u63a73\u7f51\u7edcNAC\u51c6\u5165","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-06 11:17:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"0","amount":"260000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-08-28 17:00:14","updated_at":"2024-12-06 11:17:24","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2775,"key":2775,"name":"\u8fd0\u7ef4\u5e73\u53f0-k","description":"\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f01 \u6d41\u7a0b\u7ba1\u7406 2\u76d1\u63a73\u7f51\u7edcNAC\u51c6\u5165","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":74,"bargain_date":"2023-01-16","collected":"260000","profit_pct":"46.81","budget":"260000","erpSalesOrder":{"id":1085,"serial_no":"XSDD-20230828-00002","from_date":null,"wrote_date":"2023-01-16","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2775,"sales_contract_id":2818,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"\u8fd0\u7ef4\u7ba1\u7406\u5e73\u53f01 \u6d41\u7a0b\u7ba1\u7406 2\u76d1\u63a73\u7f51\u7edcNAC\u51c6\u5165","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2024-12-06 11:17:24","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":true,"number":"0","amount":"260000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2023-08-28 17:00:14","updated_at":"2024-12-06 11:17:24","print_times":null},"projectProductTypes":[{"id":2219,"product_type_id":22,"key":22,"name":"\u670d\u52a1","budget":"260000.00","pct":"46.81","project_id":2775,"profit":"121706"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2775,"sum":"196.98"},"profit":121706,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":1402,"contract_id":2818,"supplier_id":497,"purchase_id":2902,"supplier":{"id":497,"key":497,"name":"\u5317\u4eac\u7ef4\u8054\u4f17\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2902,"key":2902,"serial_no":"TSKJ-WLZC-20230215D1"}}],"contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":5256,"user_id":5087,"key":5087,"contract_id":2818,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1706,"key":1706,"contract_id":2818,"name":"2023-09-30","value":"78000","overdue_days":null,"status":1,"remind_date":"2023-09-30","pct":30,"overdue_display":""},{"id":1707,"key":1707,"contract_id":2818,"name":"2024-01-31","value":"156000","overdue_days":null,"status":1,"remind_date":"2024-01-31","pct":60,"overdue_display":""},{"id":1708,"key":1708,"contract_id":2818,"name":"2024-06-30","value":"26000","overdue_days":159,"status":1,"remind_date":"2024-06-30","pct":10,"overdue_display":"\u903e\u671f159\u5929"}],"salesContractPayments":[{"id":"1165","key":"1165","contract_id":2818,"value":"26000","created_by":1013,"created_at":"2024-12-06 11:17:24","description":null,"collected_date":"2024-10-21 00:00:00","amount":"26000","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7},"pct":10},{"id":"11396","key":"11396","contract_id":2818,"value":"156000","created_by":1014,"created_at":"2024-01-15 16:40:35","description":null,"collected_date":"2024-01-15 00:00:00","amount":"156000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":60},{"id":"11395","key":"11395","contract_id":2818,"value":"78000","created_by":1014,"created_at":"2023-09-21 15:06:45","description":null,"collected_date":"2023-09-21 00:00:00","amount":"78000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":30}],"salesContractInvoices":[{"id":1542,"key":1542,"contract_id":2818,"value":"260000.00","attachment_id":null,"from_date":"2023-11-29","description":"","is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":2558,"sales_invoice_id":1542,"amount":"260000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":21997,"object_type":102,"object_id":1542,"attachment_id":16270,"attachment":{"id":16270,"key":16270,"name":"ebbb138a-6c39-3b5d-ba60-6930e3dfdb1b","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/ebbb138a-6c39-3b5d-ba60-6930e3dfdb1b\/2023_11_29_11_14_35.pdf","orig_name":"2023_11_29_11_14_35.pdf"}}]}],"contractScans":[{"id":23416,"object_type":105,"object_id":2818,"attachment_id":14755,"attachment":{"id":14755,"key":14755,"name":"2c8956fb-9a80-34de-a878-710d166f3c12","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/2c8956fb-9a80-34de-a878-710d166f3c12\/\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u6240\u2014260000.pdf","orig_name":"\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u7814\u7a76\u6240\u2014260000.pdf"}}],"receiptScans":[],"verifyScans":[],"unreadComments":null,"collected_plan":260000,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"260000.00","un_invoiced":0,"collected":"260000","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","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,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0},{"id":2358,"client_id":2128,"signed_at":"2022-07-31","amount":"590000","handler":5087,"description":"","created_by":5087,"created_at":"2022-08-01 05:31:01","updated_at":"2022-09-28 14:25:45","contract_scan":null,"receipt_scan":null,"contract_type":1,"project_id":2882,"valid_date":null,"expire_date":null,"sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"Z2022Q085ONT","payment_collection_remind_ahead":"7 days","from_project":2882,"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":"","is_verify":false,"is_draft":false,"erp_settle_amount":"590000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"erp_all_settle_amount":"590000","receipt_scan_uploaded":true,"verify_scan_uploaded":false,"contract_scan_uploaded":true,"is_edit_verify":false,"is_chargeback_verify":false,"b_date":null,"passed":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}},"contractScan":null,"receiptScan":null,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":2358,"comment":2},"project":{"id":2882,"key":2882,"name":"\u8d1f\u8f7d\u5747\u8861","erpSalesOrder":{"id":885,"serial_no":"XSDD-20220801-00001","from_date":null,"wrote_date":"2022-07-31","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2882,"sales_contract_id":2358,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-01-30 09:48:58","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"590000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-01 05:31:01","updated_at":"2023-01-30 09:48:58","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[]}},"erpSalesOrder":{"id":885,"serial_no":"XSDD-20220801-00001","from_date":null,"wrote_date":"2022-07-31","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2882,"sales_contract_id":2358,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-01-30 09:48:58","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"590000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-01 05:31:01","updated_at":"2023-01-30 09:48:58","print_times":null,"erpSalesOrderVerifyRels":[],"erpSalesOrderStopVerifyRels":[],"erpSalesOrderCancelVerifyRels":[]},"fromProject":{"id":2882,"key":2882,"name":"\u8d1f\u8f7d\u5747\u8861","description":"","total_contact_point":null,"paid_contact_point":null,"is_sales_order_ready":false,"project_product_version_id":null,"bargain_date":"2022-07-31","collected":"590000","profit_pct":"46.66","budget":"590000","erpSalesOrder":{"id":885,"serial_no":"XSDD-20220801-00001","from_date":null,"wrote_date":"2022-07-31","handler":5087,"client_id":2128,"purchase_contract_id":null,"project_id":2882,"sales_contract_id":2358,"erp_store_id":null,"status":2,"erp_send_type_id":null,"abstract":null,"description":"","verify_type":1,"next_verify_user":null,"next_stop_verify_user":null,"next_cancel_verify_user":null,"verify_at":"2023-01-30 09:48:58","stop_at":null,"cancel_at":null,"refuse_description":null,"is_resubmitted":false,"is_done":false,"number":"0","amount":"590000","created_by":5087,"stop_description":null,"extra":null,"outbound_status":false,"is_used":false,"is_cancel":false,"is_settle":true,"is_old":true,"created_at":"2022-08-01 05:31:01","updated_at":"2023-01-30 09:48:58","print_times":null},"projectProductTypes":[{"id":3806,"product_type_id":85,"key":85,"name":"\u7f51\u7edc","budget":"590000.00","pct":"46.66","project_id":2882,"profit":"275294"}],"projectProductRels":[],"projectContactPoints":[],"buildSalesOrderItems":[],"reimbursementAmountSum":{"project_id":2882,"sum":"2398.86"},"profit":275294,"contact_points_status_display":"\u672a\u8bbe\u7f6e","total_contact_paid_point":0,"total_contact_un_paid_point":0},"salesSupplierRels":[{"id":82,"contract_id":2358,"supplier_id":137,"purchase_id":2352,"supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2352,"key":2352,"serial_no":"20220726"}},{"id":989,"contract_id":2358,"supplier_id":298,"purchase_id":2411,"supplier":{"id":298,"key":298,"name":"\u5317\u4eac\u777f\u521b\u80dc\u4e3a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchase":{"id":2411,"key":2411,"serial_no":""}},{"id":1007,"contract_id":2358,"supplier_id":473,"purchase_id":2350,"supplier":{"id":473,"key":473,"name":"\u5317\u4eac\u745e\u901a\u9e3f\u4e1a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchase":{"id":2350,"key":2350,"serial_no":"20220713-rthy-006"}}],"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"handleBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"remindDate":null,"serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":3373,"user_id":5087,"key":5087,"contract_id":2358,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}}],"salesContractPaymentCollectionRemindDates":[{"id":1060,"key":1060,"contract_id":2358,"name":"2022-10-24","value":"531000","overdue_days":null,"status":1,"remind_date":"2022-10-24","pct":90,"overdue_display":""},{"id":1059,"key":1059,"contract_id":2358,"name":"2022-11-30","value":"59000","overdue_days":61,"status":1,"remind_date":"2022-11-30","pct":10,"overdue_display":"\u903e\u671f61\u5929"}],"salesContractPayments":[{"id":"11887","key":"11887","contract_id":2358,"value":"59000","created_by":1014,"created_at":"2023-01-30 09:48:58","description":null,"collected_date":"2023-01-30 00:00:00","amount":"59000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":10},{"id":"11886","key":"11886","contract_id":2358,"value":"531000","created_by":1014,"created_at":"2022-10-11 16:25:36","description":null,"collected_date":"2022-10-11 00:00:00","amount":"531000","createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","department_id":6},"pct":90}],"salesContractInvoices":[{"id":1259,"key":1259,"contract_id":2358,"value":"590000.00","attachment_id":null,"from_date":"2022-09-01","description":null,"is_draft":true,"is_cancel":false,"salesInvoiceAmounts":[{"id":1393,"sales_invoice_id":1259,"amount":"590000.00","tax_rate":"13"}],"attachment":null,"attachmentRelationships":[],"files":[{"id":15935,"object_type":102,"object_id":1259,"attachment_id":10893,"attachment":{"id":10893,"key":10893,"name":"1b8fe526-bf53-3add-af15-848bf893ccaf","extension":"pdf","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/1b8fe526-bf53-3add-af15-848bf893ccaf\/2022_09_01_09_32_44.pdf","orig_name":"2022_09_01_09_32_44.pdf"}}]}],"contractScans":[{"id":16197,"object_type":105,"object_id":2358,"attachment_id":11118,"attachment":{"id":11118,"key":11118,"name":"49a1a27a-f11b-3ff9-b88f-3734f967dd61","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/49a1a27a-f11b-3ff9-b88f-3734f967dd61\/2022_09_28_14_23_39.pdf","orig_name":"2022_09_28_14_23_39.pdf"}}],"receiptScans":[{"id":16198,"object_type":106,"object_id":2358,"attachment_id":10840,"attachment":{"id":10840,"key":10840,"name":"3fb51434-cb01-379f-aa95-d3c0bd1e55ed","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/3fb51434-cb01-379f-aa95-d3c0bd1e55ed\/2022_08_22_09_29_45.pdf","orig_name":"2022_08_22_09_29_45.pdf"}},{"id":16199,"object_type":106,"object_id":2358,"attachment_id":11119,"attachment":{"id":11119,"key":11119,"name":"c131bda6-471d-3e03-8742-505786a0ab75","extension":"pdf","path":"\/v2\/attachment\/preview\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/c131bda6-471d-3e03-8742-505786a0ab75\/2022_09_28_14_25_38.pdf","orig_name":"2022_09_28_14_25_38.pdf"}}],"verifyScans":[],"unreadComments":null,"collected_plan":590000,"projectProductTotalAmount":0,"projectProductAllAmount":true,"projectProductTotalCost":0,"projectProductAllCost":true,"projectProductTotalCount":0,"invoiced":"590000.00","un_invoiced":0,"collected":"590000","un_collected":0,"is_collected":true,"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.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,"is_chargeback":false,"is_done":false,"can_view_product_cost":true,"erp_all_un_settle_amount":0}],"pagenation":{"totalcount":4,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"223.104.42.221","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-04 10:19:10', 702641152) RETURNING "id"
10:19:10.5972.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=106) AND ("object_id" IN (4483, 4289, 2818, 2358))
10:19:10.5682.3 msyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (2882, 3695, 2775)) GROUP BY "project_id"
10:19:10.5782.3 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by", "created_at", "description", "collected_date", "amount" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.wrote_date as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "r" WHERE "contract_id" IN (4483, 4289, 2818, 2358) ORDER BY "id" DESC
10:19:10.5570.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (2882, 3695, 2775))
10:19:10.5540.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id" IN (4483, 4289, 2818, 2358) ORDER BY "id" DESC
10:19:10.5510.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (2882, 3695, 2775))
10:19:10.5580.8 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 (2882, 3695, 2775)
10:19:10.5820.7 msyii\db\Command::querySELECT "id", "sales_invoice_id", "amount", "tax_rate" FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id" IN (1259, 1542, 2257) ORDER BY "id"
10:19:10.5590.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (2882, 3695, 2775) ORDER BY "id"
10:19:10.5810.7 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "description", "is_draft", "is_cancel" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (4483, 4289, 2818, 2358) ORDER BY "id"
10:19:10.5740.7 msyii\db\Command::querySELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (4483, 4289, 2818, 2358)
10:19:10.6280.5 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4483
10:19:10.4790.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2128') AND ("deleted"=FALSE)
10:19:10.6300.5 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4289
10:19:10.5770.5 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4483, 4289, 2818, 2358) ORDER BY "remind_date"
10:19:10.5700.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id" IN (4483, 4289, 2818, 2358)
10:19:10.4760.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:19:10.5730.5 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 (4483, 4289, 2818, 2358)) ORDER BY "remind_date"
10:19:10.6310.5 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2818
10:19:10.5520.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (885, 1085, 1635) ORDER BY "id"
10:19:10.5600.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (1942, 2227, 2226, 2225, 2041, 1923, 587, 2228)
10:19:10.6310.4 msyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=2358
10:19:10.5510.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3695, 2775, 2882)
10:19:10.5760.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 (4483, 4289, 2818, 2358)
10:19:10.5560.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 (3695, 2775, 2882)
10:19:10.5630.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id" IN (2139, 2140, 2141, 2142, 2143, 2144, 2159, 2160)
10:19:10.5550.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_cancel_verify_rels" WHERE "erp_sales_order_id" IN (1635, 1085, 885) ORDER BY "id"
10:19:10.5530.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (885, 1085, 1635) ORDER BY "id"
10:19:10.5620.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (1658, 42, 1756, 1600, 31, 1754, 1755, 41)
10:19:10.5720.3 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (2352, 2411, 2350, 2902, 4355, 4368, 4370, 3888, 4379, 4387, 4369)
10:19:10.5750.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (4483, 4289, 2818, 2358)
10:19:10.5710.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (137, 298, 473, 497, 661, 678, 262, 695, 505, 59)
10:19:10.5170.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128
10:19:10.5190.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5087)
10:19:10.5550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id" IN (1635, 1085, 885) ORDER BY "id"
10:19:10.6000.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10840, 11119, 31683)
10:19:10.5800.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1014)
10:19:10.5730.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:19:10.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (9, 5, 30, 4, 7)
10:19:10.5550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id" IN (1635, 1085, 885) ORDER BY "id"
10:19:10.5740.3 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 (4483, 4289, 2818, 2358)
10:19:10.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (2, 7)
10:19:10.5920.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (10893, 16270, 30778)
10:19:10.5190.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5087))
10:19:10.5180.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:19:10.5610.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (5, 4, 21, 227, 10)
10:19:10.5180.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:19:10.5630.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (2882, 3695, 2775)
10:19:10.5970.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (11118, 14755, 30794)
10:19:10.5720.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:19:10.5630.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (4, 2, 6, 3)
10:19:10.4710.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:19:10.5720.2 msyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)
10:19:10.5770.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
10:19:10.5760.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
10:19:10.5200.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 1)