ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868c1ade5956: POST https://beta.jinchangxiao.com/vue/analysis/sales-contract-list at 2025-07-05 02:09:49 pm by 223.72.35.175

Database Queries

总计31条数据
TimeDurationTypeQuery
  
14:09:49.9432.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5250

[+] Explain
14:09:49.9471.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
14:09:49.9497.0 msSELECTSELECT 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.project_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT sc.id, CASE WHEN sc.including_tax = true and (SUM ( sci.amount ) < sc.amount OR SUM ( sci.amount ) IS NULL) THEN 0 ELSE 1 END as invoice_status, CASE WHEN SUM ( sci.amount ) > 0 THEN 1 ELSE 0 END as invoice_collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE "p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420') GROUP BY "sc"."id") "sub" ON c.id = sub.id WHERE (c.need_analysis = true) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (sub.invoice_status = 0) ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC) "c"

[+] Explain
14:09:49.9575.1 msSELECTSELECT 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.project_id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN (SELECT sc.id, CASE WHEN sc.including_tax = true and (SUM ( sci.amount ) < sc.amount OR SUM ( sci.amount ) IS NULL) THEN 0 ELSE 1 END as invoice_status, CASE WHEN SUM ( sci.amount ) > 0 THEN 1 ELSE 0 END as invoice_collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE "p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420') GROUP BY "sc"."id") "sub" ON c.id = sub.id WHERE (c.need_analysis = true) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND (sub.invoice_status = 0) ORDER BY "c"."signed_at" DESC, "c"."created_at" DESC LIMIT 20

[+] Explain
14:09:49.9630.4 msSELECTSELECT "id", "id" AS "key", "name", "logo", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3304, 3056, 918, 3300, 2125, 3278, 2032, 12, 3334, 3281, 2546, 3333, 518, 3329, 189, 1121, 149)

[+] Explain
14:09:49.9630.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1005, 1001, 5295, 5300, 1013)

[+] Explain
14:09:49.9640.6 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1013, 5300))

[+] Explain
14:09:49.9640.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3809, 3808, 3807, 3804, 3461, 3806, 3796, 3801, 3800, 3794, 3786, 3782, 3771, 3785, 3783, 3772, 3780, 3770, 3684, 3547)

[+] Explain
14:09:49.9650.3 msSELECTSELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id" IN (1, 2)

[+] Explain
14:09:49.9650.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5016, 5300, 5295, 1005, 5087)

[+] Explain
14:09:49.9660.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5250, 5295, 5016, 1005, 5087, 5300))

[+] Explain
14:09:49.9660.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1)

[+] Explain
14:09:49.9670.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1013, 1005, 5087, 5295, 5300)

[+] Explain
14:09:49.9670.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1013, 5300))

[+] Explain
14:09:49.9670.4 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("reminded"=FALSE) AND ("contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)) ORDER BY "remind_date"

[+] Explain
14:09:49.9680.3 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)

[+] Explain
14:09:49.9680.5 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)

[+] Explain
14:09:49.9690.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

[+] Explain
14:09:49.9690.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)

[+] Explain
14:09:49.9700.5 msSELECTSELECT "id", "user_id", "user_id" AS "key", "contract_id" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)

[+] Explain
14:09:49.9700.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5388, 1001, 1005, 5295, 5087, 1013, 1011)

[+] Explain
14:09:49.9710.5 msSELECTSELECT "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 (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764) ORDER BY "remind_date"

[+] Explain
14:09:49.9710.6 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "created_by" FROM "a57be577deb434"."tbl_sales_contract_payments" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764) ORDER BY "id"

[+] Explain
14:09:49.9720.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 1001, 5016, 5250)

[+] Explain
14:09:49.9720.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5250, 5016, 1013))

[+] Explain
14:09:49.9730.5 msSELECTSELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date", "created_by" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764) ORDER BY "id"

[+] Explain
14:09:49.97318.3 msSELECTSELECT "object_id", count(*) AS comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=7) AND ("object_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)) GROUP BY "object_id"

[+] Explain
14:09:49.99215.6 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=7) AND (remind_user_id = 5250 AND is_read = false) AND ("object_id" IN (3843, 3841, 3840, 3842, 3845, 3837, 3831, 3844, 3830, 3816, 3803, 3792, 3791, 3797, 3795, 3796, 3789, 3790, 3768, 3764)) GROUP BY "object_id"

[+] Explain
14:09:50.0113.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')

[+] Explain
14:09:50.0150.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=193, "last_visit_at"='now()' WHERE "id"=49799

[+] Explain
14:09:50.0162.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/sales-contract-list', '{"dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420","is_invoice":"0","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":3843,"client_id":3304,"signed_at":"2025-06-11","amount":"1","handler":1001,"description":"","created_by":1001,"created_at":"2025-06-11 11:06:41","updated_at":"2025-06-27 14:39:20","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3809,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-LRC-20250611001","payment_collection_remind_ahead":"1 day","from_project":3809,"receipt_date":"","verify_date":"","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":"2025-06-11 11:10:21.568929+08","b_date":"","passed":1,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3809,"key":3809,"name":"\u6d4b\u8bd5\u9ed8\u8ba4\u9009\u4e2d\u660e\u786e\u9700\u6c42"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8223,"user_id":1005,"key":1005,"contract_id":3843,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}},{"id":8224,"user_id":1001,"key":1001,"contract_id":3843,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2382,"key":2382,"contract_id":3843,"name":"2025-06-11","value":"3000","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3843,"comment":26},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3841,"client_id":3304,"signed_at":"2025-06-10","amount":"0","handler":1001,"description":"","created_by":1001,"created_at":"2025-06-10 16:16:49","updated_at":"2025-06-10 16:22:13","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3808,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"1 day","from_project":3808,"receipt_date":"","verify_date":"","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":"2025-06-11 11:03:55.970013+08","b_date":"","passed":1,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3808,"key":3808,"name":"\u7684\u662f\u5426\u5730\u65b9\u6492"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8148,"user_id":1005,"key":1005,"contract_id":3841,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}},{"id":8149,"user_id":1001,"key":1001,"contract_id":3841,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2378,"key":2378,"contract_id":3841,"name":"2025-06-11","value":"2000","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3840,"client_id":3304,"signed_at":"2025-06-09","amount":"34000","handler":1001,"description":"","created_by":1001,"created_at":"2025-06-09 17:26:40","updated_at":"2025-06-11 11:22:44","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3807,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"2 days","from_project":3807,"receipt_date":"","verify_date":"","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":"2025-06-11 11:24:24.19598+08","b_date":"","passed":1,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3807,"key":3807,"name":"\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8185,"user_id":1005,"key":1005,"contract_id":3840,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}},{"id":8186,"user_id":1001,"key":1001,"contract_id":3840,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2398,"key":2398,"contract_id":3840,"name":"2025-06-11","value":"222","overdue_days":""},{"id":2399,"key":2399,"contract_id":3840,"name":"2025-06-12","value":"4000","overdue_days":""}],"salesContractPayments":[{"id":2162,"key":2162,"contract_id":3840,"value":"34000","created_by":5250,"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"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3840,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3842,"client_id":3056,"signed_at":"2025-06-04","amount":"0","handler":1013,"description":"","created_by":5250,"created_at":"2025-06-11 11:06:35","updated_at":"2025-06-11 11:06:35","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3804,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"1 day","from_project":3804,"receipt_date":"","verify_date":"","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":"2025-06-11 11:06:57.751079+08","b_date":"","passed":1,"client":{"id":3056,"key":3056,"name":"\u4e2d\u56fd\u822a\u5929","logo":"","sales_rep":1013,"salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},"project":{"id":3804,"key":3804,"name":"\u54c8\u62c9\u54c8\u5566"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"handleBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8155,"user_id":5295,"key":5295,"contract_id":3842,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}},{"id":8156,"user_id":5087,"key":5087,"contract_id":3842,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"}},{"id":8157,"user_id":1013,"key":1013,"contract_id":3842,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2381,"key":2381,"contract_id":3842,"name":"2025-06-11","value":"2222","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3845,"client_id":918,"signed_at":"2025-06-03","amount":"1000000","handler":1005,"description":"","created_by":5250,"created_at":"2025-06-11 11:37:57","updated_at":"2025-06-11 11:37:57","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3461,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"7 days","from_project":3461,"receipt_date":"","verify_date":"","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":"2025-06-11 11:41:41.655689+08","b_date":"","passed":1,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"project":{"id":3461,"key":3461,"name":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8203,"user_id":1005,"key":1005,"contract_id":3845,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}},{"id":8204,"user_id":1001,"key":1001,"contract_id":3845,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2410,"key":2410,"contract_id":3845,"name":"2025-06-11","value":"12322","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3837,"client_id":3300,"signed_at":"2025-06-03","amount":"700","handler":5087,"description":"","created_by":5016,"created_at":"2025-06-03 17:43:37","updated_at":"2025-06-03 17:43:37","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3806,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"1 day","from_project":3806,"receipt_date":"","verify_date":"","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":"2025-06-03 17:43:37.578289+08","b_date":"","passed":1,"client":{"id":3300,"key":3300,"name":"\u4e2d\u56fd\u822a\u5929\u7cfb\u7edf\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u822a\u5929\u6d4b\u63a7\u4e0a\u7ea7\u5355\u4f4d\uff09","logo":"","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"}}},"project":{"id":3806,"key":3806,"name":"dddd"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8100,"user_id":5295,"key":5295,"contract_id":3837,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}},{"id":8101,"user_id":5087,"key":5087,"contract_id":3837,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[{"id":2159,"key":2159,"contract_id":3837,"value":"46.95","created_by":5016,"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"id":2160,"key":2160,"contract_id":3837,"value":"645.95","created_by":5016,"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}},{"id":2161,"key":2161,"contract_id":3837,"value":"7.10","created_by":5016,"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3837,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3831,"client_id":2125,"signed_at":"2025-04-13","amount":"790000","handler":5087,"description":"","created_by":5250,"created_at":"2025-04-14 13:27:44","updated_at":"2025-05-28 10:33:42","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3796,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"1 day","from_project":3796,"receipt_date":"","verify_date":"","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":"2025-06-11 11:21:10.675113+08","b_date":"","passed":1,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","logo":"","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"}}},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"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":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8166,"user_id":5295,"key":5295,"contract_id":3831,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}},{"id":8167,"user_id":5087,"key":5087,"contract_id":3831,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2389,"key":2389,"contract_id":3831,"name":"2025-05-01","value":"1","overdue_days":""},{"id":2390,"key":2390,"contract_id":3831,"name":"2025-05-29","value":"2","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3831,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3844,"client_id":3278,"signed_at":"2025-04-09","amount":"8000","handler":1001,"description":"","created_by":1001,"created_at":"2025-06-11 11:14:46","updated_at":"2025-06-11 11:14:46","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3801,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":3801,"receipt_date":"","verify_date":"","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":"2025-06-11 15:29:06.898793+08","b_date":"","passed":1,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8221,"user_id":1005,"key":1005,"contract_id":3844,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}},{"id":8222,"user_id":1001,"key":1001,"contract_id":3844,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2426,"key":2426,"contract_id":3844,"name":"2025-06-11","value":"4000","overdue_days":""},{"id":2427,"key":2427,"contract_id":3844,"name":"2025-06-19","value":"3000","overdue_days":""},{"id":2428,"key":2428,"contract_id":3844,"name":"2025-06-20","value":"1000","overdue_days":""}],"salesContractPayments":[{"id":2163,"key":2163,"contract_id":3844,"value":"1","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3844,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3830,"client_id":2032,"signed_at":"2025-03-17","amount":"615615","handler":5295,"description":"","created_by":5250,"created_at":"2025-04-11 11:00:39","updated_at":"2025-04-11 11:00:39","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3800,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"","from_project":3800,"receipt_date":"","verify_date":"","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":"2025-06-28 17:41:05.610438+08","b_date":"","passed":1,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8071,"user_id":5295,"key":5295,"contract_id":3830,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3816,"client_id":12,"signed_at":"2025-03-06","amount":"511","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-06 19:44:56","updated_at":"2025-03-14 17:29:50","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3794,"valid_date":"","expire_date":"2026-03-05","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25031110","payment_collection_remind_ahead":"1 day","from_project":3794,"receipt_date":"","verify_date":"","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-03-06 19:45:22.44096+08","b_date":243,"passed":2,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","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"}}},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"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":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8047,"user_id":5300,"key":5300,"contract_id":3816,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":8048,"user_id":5388,"key":5388,"contract_id":3816,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":8049,"user_id":1001,"key":1001,"contract_id":3816,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2356,"key":2356,"contract_id":3816,"name":"2025-04-18","value":"511","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3816,"comment":6},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3803,"client_id":3334,"signed_at":"2025-02-28","amount":"3593747","handler":1001,"description":"","created_by":1001,"created_at":"2025-02-28 16:22:01","updated_at":"2025-06-09 17:17:30","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3786,"valid_date":"","expire_date":"2026-02-27","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250228-LRC-001","payment_collection_remind_ahead":"","from_project":3786,"receipt_date":"","verify_date":"","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-06-11 11:24:15.876522+08","b_date":237,"passed":2,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handleBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8182,"user_id":1001,"key":1001,"contract_id":3803,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}},{"id":8183,"user_id":1011,"key":1011,"contract_id":3803,"user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"}},{"id":8184,"user_id":5388,"key":5388,"contract_id":3803,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2396,"key":2396,"contract_id":3803,"name":"2025-03-31","value":"3048204","overdue_days":""},{"id":2397,"key":2397,"contract_id":3803,"name":"2025-06-11","value":"1","overdue_days":""}],"salesContractPayments":[{"id":2156,"key":2156,"contract_id":3803,"value":"-1","created_by":1001,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3803,"comment":6},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3792,"client_id":12,"signed_at":"2025-02-24","amount":"629","handler":5300,"description":"","created_by":5300,"created_at":"2025-02-24 11:47:14","updated_at":"2025-03-11 10:58:26","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3782,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355POBJ25024486","payment_collection_remind_ahead":"7 days","from_project":3782,"receipt_date":"","verify_date":"","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-02-24 11:47:14.087116+08","b_date":"","passed":1,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","logo":"","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"}}},"project":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"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":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7930,"user_id":5300,"key":5300,"contract_id":3792,"user":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"}},{"id":7931,"user_id":5388,"key":5388,"contract_id":3792,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7932,"user_id":1001,"key":1001,"contract_id":3792,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2339,"key":2339,"contract_id":3792,"name":"2025-04-11","value":"629","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3792,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3791,"client_id":3281,"signed_at":"2025-02-24","amount":"5869.5","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-24 11:10:34","updated_at":"2025-03-11 10:55:26","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3771,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025012003","payment_collection_remind_ahead":"1 day","from_project":3771,"receipt_date":"","verify_date":"","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-02-24 11:10:34.942465+08","b_date":"","passed":1,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8015,"user_id":5295,"key":5295,"contract_id":3791,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2338,"key":2338,"contract_id":3791,"name":"2025-04-30","value":"5869.5","overdue_days":""}],"salesContractPayments":[{"id":2118,"key":2118,"contract_id":3791,"value":"5869.5","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3791,"comment":6},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3797,"client_id":2546,"signed_at":"2025-02-21","amount":"10800","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-27 10:14:14","updated_at":"2025-03-03 17:57:51","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3785,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025022101","payment_collection_remind_ahead":"00:00:00","from_project":3785,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":true,"is_deliver":true,"is_outbound":true,"is_save_collection":false,"save_collection_at":"","b_date":"","passed":1,"client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3785,"key":3785,"name":"2025\u65b0\u8d2dUPS"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7950,"user_id":5295,"key":5295,"contract_id":3797,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2346,"key":2346,"contract_id":3797,"name":"2025-04-15","value":"10800","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3797,"comment":4},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3795,"client_id":3333,"signed_at":"2025-02-21","amount":"2310000","handler":1005,"description":"","created_by":1005,"created_at":"2025-02-26 10:24:57","updated_at":"2025-02-26 11:58:32","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3783,"valid_date":"","expire_date":"2028-02-21","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TSKJ20250221-ZHY-001","payment_collection_remind_ahead":"1 day","from_project":3783,"receipt_date":"","verify_date":"","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":"2025-02-26 10:24:57.496964+08","b_date":961,"passed":2,"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","sales_rep":"","salesRep":{}},"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7914,"user_id":1005,"key":1005,"contract_id":3795,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2342,"key":2342,"contract_id":3795,"name":"2025-03-26","value":"693000","overdue_days":""},{"id":2343,"key":2343,"contract_id":3795,"name":"2025-04-30","value":"1501500","overdue_days":""},{"id":2344,"key":2344,"contract_id":3795,"name":"2028-02-29","value":"115500","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3795,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3796,"client_id":518,"signed_at":"2025-02-17","amount":"28000","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-26 10:39:10","updated_at":"2025-03-12 17:08:27","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3772,"valid_date":"","expire_date":"2026-02-17","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025021701","payment_collection_remind_ahead":"00:00:00","from_project":3772,"receipt_date":"","verify_date":"","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-03-10 15:23:58.285958+08","b_date":227,"passed":2,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3772,"key":3772,"name":"2025\u65b0\u8d2d4090\u663e\u5361-K"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8041,"user_id":5295,"key":5295,"contract_id":3796,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2359,"key":2359,"contract_id":3796,"name":"2025-04-30","value":"28000","overdue_days":""}],"salesContractPayments":[{"id":2129,"key":2129,"contract_id":3796,"value":"28000","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3796,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3789,"client_id":3329,"signed_at":"2025-02-10","amount":"277500","handler":5087,"description":"\u7528\u6237\uff1a\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240\uff0c\u4e0b\u5355\u91d1\u989d\uff1a5\u4e07*6=30\u4e07\n\u9f50\u5fc3\u6263\u9664\u5e73\u53f0\u70b97.5\u70b9\u540e\uff0c\u7ed3\u7b97277500","created_by":5087,"created_at":"2025-02-23 08:37:49","updated_at":"2025-03-11 11:15:20","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3780,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"LINK20250210340000693","payment_collection_remind_ahead":"30 days","from_project":3780,"receipt_date":"","verify_date":"","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-02-23 08:37:49.23438+08","b_date":"","passed":1,"client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09","logo":"","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"}}},"project":{"id":3780,"key":3780,"name":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"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":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":8016,"user_id":5087,"key":5087,"contract_id":3789,"user":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2336,"key":2336,"contract_id":3789,"name":"2025-06-30","value":"277500","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3789,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3790,"client_id":189,"signed_at":"2025-02-07","amount":"22200","handler":5295,"description":"","created_by":5295,"created_at":"2025-02-24 11:00:58","updated_at":"2025-03-05 09:30:24","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3770,"valid_date":"","expire_date":"2026-02-07","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2025020701","payment_collection_remind_ahead":"1 day","from_project":3770,"receipt_date":"","verify_date":"","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-03-04 09:49:47.682196+08","b_date":217,"passed":2,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7956,"user_id":5295,"key":5295,"contract_id":3790,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2349,"key":2349,"contract_id":3790,"name":"2025-03-31","value":"22200","overdue_days":""}],"salesContractPayments":[{"id":2117,"key":2117,"contract_id":3790,"value":"22200","created_by":1013,"createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"salesContractInvoices":[],"commentCount":{"object_id":3790,"comment":5},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3768,"client_id":1121,"signed_at":"2025-01-20","amount":"83081","handler":5295,"description":"","created_by":5295,"created_at":"2025-01-20 15:50:03","updated_at":"2025-01-21 15:11:41","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3684,"valid_date":"","expire_date":"","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"TS-WZW-2024101402","payment_collection_remind_ahead":"1 day","from_project":3684,"receipt_date":"","verify_date":"","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":"2025-01-20 15:50:03.316077+08","b_date":"","passed":1,"client":{"id":1121,"key":1121,"name":"\u5317\u4eac\u4e1c\u65b9\u8ba1\u91cf\u6d4b\u8bd5\u7814\u7a76\u6240","logo":"","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}},"project":{"id":3684,"key":3684,"name":"2024\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd"},"contractScan":"","receiptScan":"","contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7790,"user_id":5295,"key":5295,"contract_id":3768,"user":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"}},{"id":7791,"user_id":5388,"key":5388,"contract_id":3768,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F"}},{"id":7792,"user_id":1001,"key":1001,"contract_id":3768,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"}}],"salesContractPaymentCollectionRemindDates":[{"id":2322,"key":2322,"contract_id":3768,"name":"2025-12-31","value":"83081","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3768,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false},{"id":3764,"client_id":149,"signed_at":"2025-01-13","amount":"205900","handler":1005,"description":"","created_by":1005,"created_at":"2025-01-17 12:57:21","updated_at":"2025-01-17 13:28:03","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3547,"valid_date":"","expire_date":"2026-05-31","sla":"","remind_ahead":"","expire_remind_ahead":"","expire_reminded":false,"serial_no":"FZ-2024-137-SC-004","payment_collection_remind_ahead":"00:00:00","from_project":3547,"receipt_date":"","verify_date":"","including_tax":true,"build_by_project":true,"need_analysis":true,"is_settle":false,"is_deliver":false,"is_outbound":false,"is_save_collection":false,"save_collection_at":"","b_date":330,"passed":2,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09","logo":"","sales_rep":1005,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}},"project":{"id":3547,"key":3547,"name":"\u79d1\u7814\u7ecf\u8d39\u8f6f\u4ef6\u5f00\u53d1\u9879\u76ee"},"contractScan":"","receiptScan":"","contractType":{"id":2,"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"handleBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"remindDate":"","serviceContractRemindDates":[],"salesContractRemindReceivers":[{"id":8288,"user_id":1005,"key":1005,"contract_id":3764,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}}],"serviceContractRemindReceivers":[],"salesContractPaymentCollectionRemindReceivers":[{"id":7746,"user_id":1005,"key":1005,"contract_id":3764,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F"}}],"salesContractPaymentCollectionRemindDates":[{"id":2318,"key":2318,"contract_id":3764,"name":"2025-04-17","value":"205900","overdue_days":""}],"salesContractPayments":[],"salesContractInvoices":[],"commentCount":{"object_id":3764,"comment":1},"unreadComments":{},"remind_date":"","remind_ahead_display":"\u65e0","expire_remind_ahead_display":"\u65e0","unread":0,"bgcolor":"#89c541","can_update":true,"can_delete":false}],"can_create":true,"pagenation":{"totalcount":48,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:09:50') RETURNING "id"

[+] Explain