6865d4b06b1fd: POST https://beta.jinchangxiao.com/vue/analysis/sales-collected-payment-collection at 2025-07-03 08:54:08 am by 115.171.251.24
Database Queries
总计11条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 08:54:08.442 | 2.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5016 |
| 08:54:08.445 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 08:54:08.451 | 7.2 ms | SELECT | SELECT COUNT(*) FROM (SELECT sc.*, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c" |
| 08:54:08.458 | 78.5 ms | SELECT | SELECT sc.*, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20 |
| 08:54:08.537 | 1.6 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3304, 3056, 918, 3300, 3278, 2125, 2032, 2736, 12, 20, 531, 3326, 4, 518, 3334, 3281) |
| 08:54:08.539 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3809, 3808, 3807, 3804, 3461, 3806, 3796, 3801, 3800, 3793, 3794, 3792, 3791, 3769, 3789, 3788, 3786, 3782, 3771) |
| 08:54:08.540 | 0.5 ms | SELECT | SELECT "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, 3836, 3831, 3844, 3830, 3822, 3816, 3812, 3811, 3770, 3809, 3805, 3803, 3792, 3791) ORDER BY "remind_date" |
| 08:54:08.541 | 10.9 ms | SELECT | SELECT sum(amount) as amount, sum(this_collected) as collected, sum(amount - collected) as uncollected, count(distinct client_id) as client_count, sum(collected_count) as collected_count FROM (SELECT sc.*, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.amount - scp.collected) as uncollected, sum(sc.amount - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_sales_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id WHERE sc.need_analysis = true GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-03') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id" ORDER BY "signed_at" DESC) "sub" |
| 08:54:08.553 | 3.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=23) AND ("visit_date"='2025-07-03') |
| 08:54:08.557 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=8, "last_visit_at"='now()' WHERE "id"=49771 |
| 08:54:08.558 | 1.9 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/analysis/sales-collected-payment-collection', '{"status":"","period":"","to":"","from":"","dataUserId":"","group":"","page":"1","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"1","uninvoiced":"1","overdue":"3000","status":0,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3809,"key":3809,"name":"\u6d4b\u8bd5\u9ed8\u8ba4\u9009\u4e2d\u660e\u786e\u9700\u6c42"},"salesContractPaymentCollectionRemindDates":[{"id":2382,"key":2382,"contract_id":3843,"name":"2025-06-11","value":"3000","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f22\u5929","overdue_amount":3000,"remind_date":"2025-06-11"},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"0","uninvoiced":"0","overdue":"2000","status":0,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3808,"key":3808,"name":"\u7684\u662f\u5426\u5730\u65b9\u6492"},"salesContractPaymentCollectionRemindDates":[{"id":2378,"key":2378,"contract_id":3841,"name":"2025-06-11","value":"2000","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"34000","invoiced":"0","this_collected":"34000","collected_count":"1","uncollected":"0","uninvoiced":"34000","overdue":"","status":2,"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"project":{"id":3807,"key":3807,"name":"\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a"},"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":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"0","uninvoiced":"0","overdue":"2222","status":0,"client":{"id":3056,"key":3056,"name":"\u4e2d\u56fd\u822a\u5929"},"project":{"id":3804,"key":3804,"name":"\u54c8\u62c9\u54c8\u5566"},"salesContractPaymentCollectionRemindDates":[{"id":2381,"key":2381,"contract_id":3842,"name":"2025-06-11","value":"2222","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"1000000","uninvoiced":"1000000","overdue":"12322","status":0,"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"project":{"id":3461,"key":3461,"name":"\u6570\u636e\u5907\u4efd\u65b9\u6848\uff08\u542b\u5b9e\u9a8c\u5ba4\uff09-\u4f55\u5ca9\u9879\u76ee"},"salesContractPaymentCollectionRemindDates":[{"id":2410,"key":2410,"contract_id":3845,"name":"2025-06-11","value":"12322","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f22\u5929","overdue_amount":12322,"remind_date":"2025-06-11"},{"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","collected":"700.00","invoiced":"0","this_collected":"700.00","collected_count":"3","uncollected":"0.00","uninvoiced":"700","overdue":"","status":2,"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"},"project":{"id":3806,"key":3806,"name":"dddd"},"salesContractPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3836,"client_id":3278,"signed_at":"2025-05-08","amount":"22.00","handler":1001,"description":"","created_by":1001,"created_at":"2025-05-08 09:34:17","updated_at":"2025-06-11 13:37:48","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":"","valid_date":"","expire_date":"2025-05-08","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"00:00:00","from_project":"","receipt_date":"","verify_date":"","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":"","collected":"22","invoiced":"0","this_collected":"22","collected_count":"1","uncollected":"0.00","uninvoiced":"22.00","overdue":"","status":2,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"project":{},"salesContractPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"790000","uninvoiced":"790000","overdue":"3","status":0,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382"},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72-239-K"},"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":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f63\u5929","overdue_amount":3,"remind_date":"2025-05-29"},{"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","collected":"1","invoiced":"0","this_collected":"1","collected_count":"1","uncollected":"7999","uninvoiced":"8000","overdue":"7999","status":0,"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898"},"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":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f22\u5929","overdue_amount":7999,"remind_date":"2025-06-20"},{"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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"615615","uninvoiced":"615615","overdue":"","status":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)"},"project":{"id":3800,"key":3800,"name":"26\u5e74\u9632\u706b\u5899\u7eed\u4fdd"},"salesContractPaymentCollectionRemindDates":[],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3822,"client_id":2736,"signed_at":"2025-03-10","amount":"2500","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-10 10:17:21","updated_at":"2025-03-12 17:05:47","contract_scan":"","receipt_scan":"","contract_type":2,"project_id":3793,"valid_date":"","expire_date":"","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"7 days","from_project":3793,"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 10:17:21.573991+08","collected":"0","invoiced":"2501.00","this_collected":"0","collected_count":"0","uncollected":"2500","uninvoiced":"-1.00","overdue":"2500","status":0,"client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)"},"project":{"id":3793,"key":3793,"name":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025"},"salesContractPaymentCollectionRemindDates":[{"id":2357,"key":2357,"contract_id":3822,"name":"2025-04-21","value":"2500","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f73\u5929","overdue_amount":2500,"remind_date":"2025-04-21"},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"511","uninvoiced":"511","overdue":"511","status":0,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3794,"key":3794,"name":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025"},"salesContractPaymentCollectionRemindDates":[{"id":2356,"key":2356,"contract_id":3816,"name":"2025-04-18","value":"511","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f76\u5929","overdue_amount":511,"remind_date":"2025-04-18"},{"id":3812,"client_id":20,"signed_at":"2025-03-06","amount":"500","handler":1005,"description":"","created_by":1005,"created_at":"2025-03-06 09:01:21","updated_at":"2025-03-14 15:15:11","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3792,"valid_date":"","expire_date":"2026-03-04","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"00:00:00","from_project":3792,"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":"","collected":"0","invoiced":"500.00","this_collected":"0","collected_count":"0","uncollected":"500","uninvoiced":"0.00","overdue":"500","status":0,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"project":{"id":3792,"key":3792,"name":"IBM\u7535\u6e90\u66f4\u6362"},"salesContractPaymentCollectionRemindDates":[{"id":2354,"key":2354,"contract_id":3812,"name":"2025-04-06","value":"500","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f88\u5929","overdue_amount":500,"remind_date":"2025-04-06"},{"id":3811,"client_id":531,"signed_at":"2025-03-05","amount":"3150","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 17:28:13","updated_at":"2025-03-12 13:59:08","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3791,"valid_date":"","expire_date":"","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"TS-SQY-20250305001","payment_collection_remind_ahead":"00:00:00","from_project":3791,"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-05 17:28:35.841072+08","collected":"3150","invoiced":"3150.00","this_collected":"3150","collected_count":"1","uncollected":"0","uninvoiced":"0.00","overdue":"","status":2,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"},"salesContractPaymentCollectionRemindDates":[{"id":2353,"key":2353,"contract_id":3811,"name":"2025-03-21","value":"3150","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3770,"client_id":3326,"signed_at":"2025-03-05","amount":"32000","handler":5087,"description":"","created_by":5087,"created_at":"2025-01-21 15:45:01","updated_at":"2025-03-06 09:23:53","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3769,"valid_date":"","expire_date":"","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"TS-LW-20250305001","payment_collection_remind_ahead":"1 day","from_project":3769,"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-01-21 16:22:12.892494+08","collected":"32000","invoiced":"32000.00","this_collected":"32000","collected_count":"1","uncollected":"0","uninvoiced":"0.00","overdue":"","status":2,"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"project":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39"},"salesContractPaymentCollectionRemindDates":[{"id":2325,"key":2325,"contract_id":3770,"name":"2025-04-30","value":"32000","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3809,"client_id":4,"signed_at":"2025-03-04","amount":"1700","handler":5300,"description":"","created_by":5300,"created_at":"2025-03-05 14:27:35","updated_at":"2025-03-14 15:19:55","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3789,"valid_date":"","expire_date":"","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"TS-SQY-20250304002","payment_collection_remind_ahead":"1 day","from_project":3789,"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:23:01.426167+08","collected":"1700","invoiced":"1700.00","this_collected":"1700","collected_count":"1","uncollected":"0","uninvoiced":"0.00","overdue":"","status":2,"client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8"},"project":{"id":3789,"key":3789,"name":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025"},"salesContractPaymentCollectionRemindDates":[{"id":2395,"key":2395,"contract_id":3809,"name":"2025-04-05","value":"22","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3805,"client_id":518,"signed_at":"2025-03-03","amount":"1200","handler":5295,"description":"","created_by":5295,"created_at":"2025-03-03 17:13:54","updated_at":"2025-03-05 09:27:13","contract_scan":"","receipt_scan":"","contract_type":1,"project_id":3788,"valid_date":"","expire_date":"","sla":"","remind_ahead":"00:00:00","expire_remind_ahead":"00:00:00","expire_reminded":false,"serial_no":"","payment_collection_remind_ahead":"00:00:00","from_project":3788,"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-03 17:13:54.915446+08","collected":"0","invoiced":"1200.00","this_collected":"0","collected_count":"0","uncollected":"1200","uninvoiced":"0.00","overdue":"1200","status":0,"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"},"project":{"id":3788,"key":3788,"name":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8"},"salesContractPaymentCollectionRemindDates":[{"id":2348,"key":2348,"contract_id":3805,"name":"2025-04-30","value":"1200","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f64\u5929","overdue_amount":1200,"remind_date":"2025-04-30"},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"-1","invoiced":"0","this_collected":"-1","collected_count":"1","uncollected":"3593748","uninvoiced":"3593747","overdue":"3048206","status":0,"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1"},"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":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f94\u5929","overdue_amount":3048206,"remind_date":"2025-06-11"},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"629","uninvoiced":"629","overdue":"629","status":0,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3782,"key":3782,"name":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025"},"salesContractPaymentCollectionRemindDates":[{"id":2339,"key":2339,"contract_id":3792,"name":"2025-04-11","value":"629","overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f83\u5929","overdue_amount":629,"remind_date":"2025-04-11"},{"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":"00:00:00","expire_remind_ahead":"00:00:00","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","collected":"5869.5","invoiced":"0","this_collected":"5869.5","collected_count":"1","uncollected":"0.0","uninvoiced":"5869.5","overdue":"","status":2,"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"},"project":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9"},"salesContractPaymentCollectionRemindDates":[{"id":2338,"key":2338,"contract_id":3791,"name":"2025-04-30","value":"5869.5","overdue_days":""}],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""}],"count":{"amount":"354764849.72","collected":"334912555.66","uncollected":"19852294.06","client_count":340,"collected_count":"1880"},"pagenation":{"totalcount":1481,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 08:54:08') RETURNING "id" |