ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68662265e6ca7: POST https://beta.jinchangxiao.com/vue/analysis/purchase-collected-payment-collection at 2025-07-03 02:25:41 pm by 114.254.1.137

Database Queries

总计11条数据
TimeDurationTypeQuery
  
14:25:41.9492.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:25:41.9520.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:25:41.9531.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:25:41.95647.8 msSELECTSELECT COUNT(*) FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.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_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"

[+] Explain
14:25:42.00547.5 msSELECTSELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.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_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20

[+] Explain
14:25:42.0530.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 438, 669, 664, 262, 236, 685, 676, 608, 684, 534, 678, 489, 81, 59, 90, 668, 223, 618)

[+] Explain
14:25:42.0530.4 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3848, 3832, 3828, 3826, 3825, 3824, 3823, 3821, 3820, 3819, 3818, 3817, 3814, 3810, 3813, 3806, 3804, 3802, 3801, 3800) ORDER BY "remind_date"

[+] Explain
14:25:42.05444.8 msSELECTSELECT sum(amount) as amount, sum(collected) as collected, sum(approve_amount) as approve_amount, sum(amount - collected) as uncollected FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.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_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_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_purchase_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_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "signed_at" DESC) "sub"

[+] Explain
14:25:42.1013.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-07-03')

[+] Explain
14:25:42.1040.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=19, "last_visit_at"='now()' WHERE "id"=49773

[+] Explain
14:25:42.1061.7 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/purchase-collected-payment-collection', '{"status":"","approve_status":"","period":"","to":"","from":"","page":"1","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"list":[{"id":3848,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"50000000","handler":1011,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-07-03 14:21:31","updated_at":"2025-07-03 14:21:31","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u8d39\u7528\u5408\u540c","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2,"collected":"0","invoiced":"0","approve_amount":"4000000","un_approve_amount":"46000000","uncollected":"50000000","uninvoiced":"50000000","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3832,"supplier_id":438,"contract_type":1,"signed_at":"2025-04-14","amount":"111.00","handler":1011,"description":"","contract_scan":"","created_by":5016,"created_at":"2025-04-14 14:24:27","updated_at":"2025-04-14 14:24:27","client_id":"","project_id":"","sales_rep":"","serial_no":"aqdqwe","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"111.00","uninvoiced":"111.00","overdue":"","status":1,"sort_date":"","supplier":{"id":438,"key":438,"name":"\u9752\u5c9b\u946b\u96f7\u97f3\u7535\u5b50\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3828,"supplier_id":669,"contract_type":3,"signed_at":"2025-03-12","amount":"15000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-12 15:32:14","updated_at":"2025-04-14 13:27:00","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250312-HYF-002","payment_collection_remind_ahead":"00:00:00","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-03-12 15:32:23.850163+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"15000.00","uninvoiced":"0","overdue":"15000","status":0,"sort_date":"2025-03-21","supplier":{"id":669,"key":669,"name":"\u5b8b\u56fd\u5efa"},"purchaseContractPaymentCollectionRemindDates":[{"id":619,"key":619,"contract_id":3828,"name":"2025-03-21","value":"15000","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f104\u5929","overdue_amount":15000,"remind_date":"2025-03-21"},{"id":3826,"supplier_id":664,"contract_type":3,"signed_at":"2025-03-12","amount":"1800.00","handler":1011,"description":"3AAA \u4fe1\u7528\u8bc1\u4e66\u7533\u8bf7","contract_scan":"","created_by":1011,"created_at":"2025-03-12 10:10:23","updated_at":"2025-03-13 09:55:26","client_id":"","project_id":"","sales_rep":"","serial_no":"\u516c\u53f8\u81ea\u7528\u7c7bTSKJ20250312-HYF-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 10:10:33.03161+08","is_chargeback":false,"cost_type":1,"collected":"1800.00","invoiced":"1800","approve_amount":"1800","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":664,"key":664,"name":"\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":617,"key":617,"contract_id":3826,"name":"2025-03-14","value":"1800","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3825,"supplier_id":262,"contract_type":1,"signed_at":"2025-03-11","amount":"1000.00","handler":1011,"description":"\u79ef\u5206\u8f6c\u4eac\u4e1c\u5361","contract_scan":"","created_by":1011,"created_at":"2025-03-11 18:00:20","updated_at":"2025-03-12 13:41:32","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a310549989269","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-11 18:00:27.203813+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"1000","approve_amount":"1000","un_approve_amount":"0.00","uncollected":"1000.00","uninvoiced":"0.00","overdue":"1000","status":0,"sort_date":"2025-03-14","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":615,"key":615,"contract_id":3825,"name":"2025-03-14","value":"1000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f111\u5929","overdue_amount":1000,"remind_date":"2025-03-14"},{"id":3824,"supplier_id":262,"contract_type":1,"signed_at":"2025-03-11","amount":"5399.18","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-11 17:17:46","updated_at":"2025-03-11 17:17:57","client_id":"","project_id":"","sales_rep":"","serial_no":"311433509610","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-11 17:17:57.404527+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"5399.18","approve_amount":"5399.18","un_approve_amount":"0.00","uncollected":"5399.18","uninvoiced":"0.00","overdue":"5399.18","status":0,"sort_date":"2025-03-14","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":614,"key":614,"contract_id":3824,"name":"2025-03-14","value":"5399.18","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f111\u5929","overdue_amount":5399.18,"remind_date":"2025-03-14"},{"id":3823,"supplier_id":236,"contract_type":1,"signed_at":"2025-03-10","amount":"9378.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-10 17:24:05","updated_at":"2025-03-14 11:30:38","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250310-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-10 17:24:19.398219+08","is_chargeback":false,"cost_type":1,"collected":"9378.00","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"0.00","uninvoiced":"9378.00","overdue":"","status":2,"sort_date":"","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":609,"key":609,"contract_id":3823,"name":"2025-03-10","value":"9378","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3821,"supplier_id":685,"contract_type":1,"signed_at":"2025-03-10","amount":"1835600.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-10 10:00:39","updated_at":"2025-03-12 09:12:31","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250305-ZHY-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-10 10:02:46.792734+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"1835600.00","uninvoiced":"1835600.00","overdue":"1835600","status":0,"sort_date":"2025-06-30","supplier":{"id":685,"key":685,"name":"\u5317\u4eac\u4e2d\u73af\u4e00\u94ed\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":606,"key":606,"contract_id":3821,"name":"2025-04-04","value":"550680","overdue_days":""},{"id":607,"key":607,"contract_id":3821,"name":"2025-05-30","value":"1193140","overdue_days":""},{"id":608,"key":608,"contract_id":3821,"name":"2025-06-30","value":"91780","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f90\u5929","overdue_amount":1835600,"remind_date":"2025-06-30"},{"id":3820,"supplier_id":676,"contract_type":1,"signed_at":"2025-03-07","amount":"25000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-07 13:47:55","updated_at":"2025-03-11 09:17:42","client_id":"","project_id":"","sales_rep":"","serial_no":"ALX-Q20250310-0105","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 13:48:10.910116+08","is_chargeback":false,"cost_type":1,"collected":"25000.00","invoiced":"25000","approve_amount":"25000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":676,"key":676,"name":"\u5317\u4eac\u5b89\u8054\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":603,"key":603,"contract_id":3820,"name":"2025-03-07","value":"25000","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3819,"supplier_id":608,"contract_type":1,"signed_at":"2025-03-07","amount":"256.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-07 09:58:30","updated_at":"2025-03-12 16:07:16","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4256424362229592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 16:07:16.377674+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"256","approve_amount":"256","un_approve_amount":"0.00","uncollected":"256.00","uninvoiced":"0.00","overdue":"256","status":0,"sort_date":"2025-03-28","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":620,"key":620,"contract_id":3819,"name":"2025-03-28","value":"256","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f97\u5929","overdue_amount":256,"remind_date":"2025-03-28"},{"id":3818,"supplier_id":684,"contract_type":3,"signed_at":"2025-03-07","amount":"3500.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-07 09:50:03","updated_at":"2025-03-07 11:01:34","client_id":"","project_id":"","sales_rep":"","serial_no":"SFSHFWH202503060228","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:50:11.494352+08","is_chargeback":false,"cost_type":1,"collected":"3500.00","invoiced":"3500","approve_amount":"3500","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":684,"key":684,"name":"\u6e56\u5357\u6df1\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":601,"key":601,"contract_id":3818,"name":"2025-03-07","value":"3500","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3817,"supplier_id":534,"contract_type":3,"signed_at":"2025-03-06","amount":"31000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-07 09:42:23","updated_at":"2025-03-07 09:42:59","client_id":"","project_id":"","sales_rep":"","serial_no":"2025022801-TSZHY5","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-07 09:42:59.885037+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"31000.00","uninvoiced":"31000.00","overdue":"31000","status":0,"sort_date":"2025-04-07","supplier":{"id":534,"key":534,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":600,"key":600,"contract_id":3817,"name":"2025-04-07","value":"31000","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f87\u5929","overdue_amount":31000,"remind_date":"2025-04-07"},{"id":3814,"supplier_id":678,"contract_type":1,"signed_at":"2025-03-06","amount":"1300.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-06 11:37:44","updated_at":"2025-03-06 11:38:00","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG20250306","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 11:38:00.265795+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"1300","approve_amount":"","un_approve_amount":"","uncollected":"1300.00","uninvoiced":"0.00","overdue":"1300","status":0,"sort_date":"2025-04-07","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":598,"key":598,"contract_id":3814,"name":"2025-04-07","value":"1300","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f87\u5929","overdue_amount":1300,"remind_date":"2025-04-07"},{"id":3810,"supplier_id":489,"contract_type":1,"signed_at":"2025-03-05","amount":"1000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-05 14:34:26","updated_at":"2025-03-05 14:34:39","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250305-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-05 14:34:39.512905+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"1000.00","uninvoiced":"1000.00","overdue":"1000","status":0,"sort_date":"2025-04-04","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":596,"key":596,"contract_id":3810,"name":"2025-04-04","value":"1000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f90\u5929","overdue_amount":1000,"remind_date":"2025-04-04"},{"id":3813,"supplier_id":81,"contract_type":1,"signed_at":"2025-03-04","amount":"300.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-06 09:36:20","updated_at":"2025-03-06 09:36:35","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250304-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-06 09:36:35.475788+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"300","approve_amount":"","un_approve_amount":"","uncollected":"300.00","uninvoiced":"0.00","overdue":"300","status":0,"sort_date":"2025-04-04","supplier":{"id":81,"key":81,"name":"\u5317\u4eac\u4ebf\u901a\u65b0\u6708\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8\/\u4ebf\u901a\u9633\u5149"},"purchaseContractPaymentCollectionRemindDates":[{"id":597,"key":597,"contract_id":3813,"name":"2025-04-04","value":"300","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f90\u5929","overdue_amount":300,"remind_date":"2025-04-04"},{"id":3806,"supplier_id":59,"contract_type":1,"signed_at":"2025-03-03","amount":"800.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-03-04 09:39:32","updated_at":"2025-03-11 13:25:18","client_id":"","project_id":"","sales_rep":"","serial_no":"TGXC20250303-1","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-04 09:39:45.167064+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"800","approve_amount":"","un_approve_amount":"","uncollected":"800.00","uninvoiced":"0.00","overdue":"800","status":0,"sort_date":"2025-04-03","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":594,"key":594,"contract_id":3806,"name":"2025-04-03","value":"800","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f91\u5929","overdue_amount":800,"remind_date":"2025-04-03"},{"id":3804,"supplier_id":90,"contract_type":1,"signed_at":"2025-02-28","amount":"2987240.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 17:39:38","updated_at":"2025-03-04 14:06:13","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ03860","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 17:41:00.380205+08","is_chargeback":false,"cost_type":1,"collected":"0.00","invoiced":"2987240","approve_amount":"","un_approve_amount":"","uncollected":"2987240.00","uninvoiced":"0.00","overdue":"2987240.00","status":0,"sort_date":"2025-04-14","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":593,"key":593,"contract_id":3804,"name":"2025-04-14","value":"2987240","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f80\u5929","overdue_amount":2987240,"remind_date":"2025-04-14"},{"id":3802,"supplier_id":668,"contract_type":3,"signed_at":"2025-02-28","amount":"3000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 10:50:02","updated_at":"2025-02-28 13:21:53","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250228-HYF-002","payment_collection_remind_ahead":"00:00:00","including_tax":false,"is_save_collection":true,"save_collection_at":"2025-02-28 10:50:11.824878+08","is_chargeback":false,"cost_type":1,"collected":"3000.00","invoiced":"0","approve_amount":"3000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0","overdue":"","status":2,"sort_date":"","supplier":{"id":668,"key":668,"name":"\u9ec4\u5d58"},"purchaseContractPaymentCollectionRemindDates":[{"id":590,"key":590,"contract_id":3802,"name":"2025-03-07","value":"3000","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3801,"supplier_id":223,"contract_type":1,"signed_at":"2025-02-28","amount":"12919.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-28 10:49:09","updated_at":"2025-03-05 09:15:46","client_id":"","project_id":"","sales_rep":"","serial_no":"WYY-ZC-2025022801-BJJX","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 10:49:24.601955+08","is_chargeback":false,"cost_type":1,"collected":"12919.00","invoiced":"12919","approve_amount":"12919","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":223,"key":223,"name":"\u5353\u8c6a(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":589,"key":589,"contract_id":3801,"name":"2025-03-04","value":"12919","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3800,"supplier_id":618,"contract_type":1,"signed_at":"2025-02-28","amount":"9155.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-02-28 09:33:10","updated_at":"2025-02-28 09:35:29","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250228-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-28 09:33:22.643253+08","is_chargeback":false,"cost_type":1,"collected":"0","invoiced":"9155","approve_amount":"","un_approve_amount":"","uncollected":"9155.00","uninvoiced":"0.00","overdue":"9155","status":0,"sort_date":"2025-03-25","supplier":{"id":618,"key":618,"name":"\u5317\u4eac\u6052\u6cf0\u6b63\u5b87\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":588,"key":588,"contract_id":3800,"name":"2025-03-25","value":"9155","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f100\u5929","overdue_amount":9155,"remind_date":"2025-03-25"}],"count":{"amount":"268869828.67","collected":"210147043.93","approve_amount":"26559245.88","uncollected":"58722784.74","un_approve_amount":242310582.79},"pagenation":{"totalcount":1868,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 14:25:42') RETURNING "id"

[+] Explain