ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2131abd86c7: POST https://beta.jinchangxiao.com/vue/analysis/purchase-payment-collection at 2026-06-04 04:04:59 pm by 221.216.117.119

Database Queries

总计12条数据
TimeDurationTypeQuery
  
16:04:59.9016.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:04:59.9215.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:04:59.93914.1 msSELECTSELECT COUNT(*) FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "c"

[+] Explain
16:04:59.95735.2 msSELECTSELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC LIMIT 20

[+] Explain
16:05:00.0006.0 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 489, 46, 431, 268, 262, 763, 701, 762, 487, 144, 761)

[+] Explain
16:05:00.0081.7 msSELECTSELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN ('4122941', '4177914', '4123863', '44471125', '4482', '4477', '4475', '44651134', '4452', '44401119', '44411120', '44381116', '44421121', '44391117', '44371113', '44361112', '44291107', '44281106', '44271105', '44341110') ORDER BY "remind_date"

[+] Explain
16:05:00.01110.9 msSELECTSELECT sum(case when is_chargeback = false THEN amount ELSE 0 END) as amount, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"

[+] Explain
16:05:00.0226.9 msSELECTSELECT sum(collected) as collected FROM (SELECT coalesce(scp.collected, 0) as collected FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id2 WHERE "sc"."is_chargeback"=TRUE GROUP BY "sc"."id", "scp"."collected") "sub"

[+] Explain
16:05:00.0298.3 msSELECTSELECT sum(case when is_chargeback = false THEN amount ELSE 0 END) as amount, sum(collected) as collected, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"

[+] Explain
16:05:00.0385.3 msSELECTSELECT sum(case when is_chargeback = false THEN amount ELSE 0 END) as amount, sum(collected) as collected, sum(uncollected) as uncollected FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"

[+] Explain
16:05:00.0446.1 msSELECTSELECT SUM(r.amount) 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) AND ("r"."purchase_contract_id" IN (SELECT "id2" FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.supplier_id, sc.is_chargeback, sc.contract_type, sc.erp_un_settle_amount, sc.signed_at, sc.handler, a.approve_amount as approve_amount, sc.amount - a.approve_amount as un_approve_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.is_chargeback = false THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2026-06-04'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2026-06-04' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, sci.invoiced, scpcrds.overdue_days, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "t1" ON t0.contract_id = t1.id WHERE t1.is_chargeback = false GROUP BY "t0"."id") "scpcrds" ON scpcrds.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_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.is_chargeback = false GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2026-06-04'))) GROUP BY "t1"."id") "ovsub" ON ovsub.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 "a57be577deb434"."tbl_suppliers" "c" ON c.id = sc.supplier_id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "s"))

[+] Explain
16:05:00.0511.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/purchase-payment-collection', '{"status":"","approve_status":"","collect_period":"","collect_to":"","collect_from":"","is_paid":"1","page":"1","web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"list":[{"id":4122,"id2":4122,"serial_no":"X_2025SBQ23652","supplier_id":90,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2025-08-26","handler":1011,"approve_amount":"19502","un_approve_amount":"0","remind_date":"2026-10-26","amount":"19502","status":1,"uncollected":"0","collected":"19502","overdue":"","overdue_collect_amount":"","invoiced":"19502","overdue_days":"","uninvoiced":"0","c_date":"2026-10-26","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4177,"id2":4177,"serial_no":"TSKJ20250924-HYF-01","supplier_id":489,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-09-24","handler":1011,"approve_amount":"1000","un_approve_amount":"0","remind_date":"2026-09-24","amount":"1000","status":1,"uncollected":"0","collected":"1000","overdue":"","overdue_collect_amount":"","invoiced":"1000","overdue_days":"","uninvoiced":"0","c_date":"2026-09-24","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4123,"id2":4123,"serial_no":"TSKJ20250826-HYF-001","supplier_id":489,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-08-26","handler":1011,"approve_amount":"2900","un_approve_amount":"0","remind_date":"2026-08-26","amount":"2900","status":1,"uncollected":"0","collected":"2900","overdue":"","overdue_collect_amount":"","invoiced":"2900","overdue_days":"","uninvoiced":"0","c_date":"2026-08-26","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4447,"id2":4447,"serial_no":"DZ202603233147774","supplier_id":46,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"278488.32","signed_at":"2026-03-24","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"2026-06-30","amount":"278488.32","status":1,"uncollected":"0.00","collected":"278488.32","overdue":"","overdue_collect_amount":"","invoiced":"533","overdue_days":"","uninvoiced":"277955.32","c_date":"2026-06-30","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4482,"id2":4482,"serial_no":"\u6d4b\u8bd5\u6284\u9001\u4eba\u63d0\u9192","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"80","signed_at":"2026-05-25","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"88","status":0,"uncollected":"80","collected":"8","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"88","c_date":"2026-05-25","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":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4477,"id2":4477,"serial_no":"\u65b9\u5f0f\u7b2c\u4e09\u65b9\u7684\u8eab\u4efd","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"1300","signed_at":"2026-05-21","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"1400","status":0,"uncollected":"1300","collected":"100","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"1400","c_date":"2026-05-21","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":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4475,"id2":4475,"serial_no":"\u7ecf\u624b\u4eba\u5173\u8054\u5ba2\u6237\u5546\u673a","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"284","signed_at":"2026-05-20","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"888","status":0,"uncollected":"284","collected":"604","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"888","c_date":"2026-05-20","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":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4465,"id2":4465,"serial_no":"\u6d4b\u8bd5\u6d4b\u8bd5","supplier_id":431,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"150","signed_at":"2026-05-12","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"2026-05-13","amount":"100","status":0,"uncollected":"50","collected":"50","overdue":"50","overdue_collect_amount":"50","invoiced":"0","overdue_days":22,"uninvoiced":"200","c_date":"2026-05-13","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":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f22\u5929","overdue_amount":"50"},{"id":4452,"id2":4452,"serial_no":"\u6d4b\u8bd5\u9000\u5355\u95ee\u9898","supplier_id":268,"is_chargeback":true,"contract_type":1,"erp_un_settle_amount":"-4000","signed_at":"2026-04-01","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"4000","status":0,"uncollected":"0","collected":"4000","overdue":"","overdue_collect_amount":"","invoiced":"","overdue_days":"","uninvoiced":"","c_date":"2026-04-01","supplier":{"id":268,"key":268,"name":"\u5e38\u9752\u6cf0\u8fbe(\u5317\u4eac)\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4440,"id2":4440,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3442475016987410","supplier_id":262,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-03-20","handler":1011,"approve_amount":"644.54","un_approve_amount":"0.00","remind_date":"2026-03-27","amount":"644.54","status":1,"uncollected":"0.00","collected":"644.54","overdue":"0.00","overdue_collect_amount":"","invoiced":"645","overdue_days":"","uninvoiced":"-0.46","c_date":"2026-03-27","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4441,"id2":4441,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3443475017227610","supplier_id":262,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-03-20","handler":1011,"approve_amount":"15332.71","un_approve_amount":"0.00","remind_date":"2026-03-27","amount":"15332.71","status":1,"uncollected":"0.00","collected":"15332.71","overdue":"0.00","overdue_collect_amount":"","invoiced":"15332.71","overdue_days":"","uninvoiced":"0.00","c_date":"2026-03-27","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4438,"id2":4438,"serial_no":"\u8ba2\u5355\u53f7\uff1a 3437475000857790","supplier_id":262,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-03-16","handler":1011,"approve_amount":"1294.41","un_approve_amount":"0.00","remind_date":"2026-03-20","amount":"1294.41","status":1,"uncollected":"0.00","collected":"1294.41","overdue":"0.00","overdue_collect_amount":"","invoiced":"1294.41","overdue_days":"","uninvoiced":"0.00","c_date":"2026-03-20","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4442,"id2":4442,"serial_no":"TSKJ20260320-WH-01","supplier_id":763,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-03-20","handler":1011,"approve_amount":"1980","un_approve_amount":"0","remind_date":"2026-03-20","amount":"1980","status":1,"uncollected":"0","collected":"1980","overdue":"0","overdue_collect_amount":"1980","invoiced":"1980","overdue_days":0,"uninvoiced":"0","c_date":"2026-03-20","supplier":{"id":763,"key":763,"name":"\u521b\u4e1a\u9ed1\u9a6c\u79d1\u6280\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":4439,"id2":4439,"serial_no":"TSKJ20260318-HYF-01","supplier_id":701,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-03-18","handler":1011,"approve_amount":"23040","un_approve_amount":"0","remind_date":"2026-03-20","amount":"23040","status":1,"uncollected":"0","collected":"23040","overdue":"0","overdue_collect_amount":"23040","invoiced":"23510.64","overdue_days":0,"uninvoiced":"-470.64","c_date":"2026-03-20","supplier":{"id":701,"key":701,"name":"\u6570\u529b\uff08\u5929\u6d25\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":4437,"id2":4437,"serial_no":"TSKJ20260309-HYF-01","supplier_id":762,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"8000","signed_at":"2026-03-09","handler":1011,"approve_amount":"2000","un_approve_amount":"8000","remind_date":"2026-03-17","amount":"2000","status":1,"uncollected":"0","collected":"2000","overdue":"0","overdue_collect_amount":"","invoiced":"119538.18","overdue_days":"","uninvoiced":"-109538.18","c_date":"2026-03-17","supplier":{"id":762,"key":762,"name":"\u5357\u4eac\u9ec4\u89d2\u6811\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":"0"},{"id":4436,"id2":4436,"serial_no":"TSKJ20260310-HYF-01","supplier_id":487,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-03-10","handler":1011,"approve_amount":"2500","un_approve_amount":"0","remind_date":"2026-03-17","amount":"2500","status":1,"uncollected":"0","collected":"2500","overdue":"0","overdue_collect_amount":"","invoiced":"2500","overdue_days":"","uninvoiced":"0","c_date":"2026-03-17","supplier":{"id":487,"key":487,"name":"\u5317\u4eac\u6613\u540c\u4fe1\u548c\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":"0"},{"id":4429,"id2":4429,"serial_no":"TSKJ20260228-HYF-02","supplier_id":144,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-02-28","handler":1011,"approve_amount":"4504.15","un_approve_amount":"0.00","remind_date":"2026-03-06","amount":"4504.15","status":1,"uncollected":"0.00","collected":"4504.15","overdue":"0.00","overdue_collect_amount":"","invoiced":"4504.15","overdue_days":"","uninvoiced":"0.00","c_date":"2026-03-06","supplier":{"id":144,"key":144,"name":"\u534e\u4e3a\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4428,"id2":4428,"serial_no":"\u8ba2\u5355\u53f7\uff1a 346125033762","supplier_id":262,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-03-03","handler":1011,"approve_amount":"4502.42","un_approve_amount":"0.00","remind_date":"2026-03-06","amount":"4502.42","status":1,"uncollected":"0.00","collected":"4502.42","overdue":"0.00","overdue_collect_amount":"","invoiced":"4502.42","overdue_days":"","uninvoiced":"0.00","c_date":"2026-03-06","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4427,"id2":4427,"serial_no":"TSKJ20260303-HYF-01","supplier_id":262,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-03-03","handler":1011,"approve_amount":"5322.61","un_approve_amount":"0.00","remind_date":"2026-03-06","amount":"5322.61","status":1,"uncollected":"0.00","collected":"5322.61","overdue":"0.00","overdue_collect_amount":"","invoiced":"5322.61","overdue_days":"","uninvoiced":"0.00","c_date":"2026-03-06","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4434,"id2":4434,"serial_no":"100202539818","supplier_id":761,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-03-04","handler":1011,"approve_amount":"12000","un_approve_amount":"0","remind_date":"2026-03-05","amount":"12000","status":1,"uncollected":"0","collected":"12000","overdue":"0","overdue_collect_amount":"12000","invoiced":"12000","overdue_days":4,"uninvoiced":"0","c_date":"2026-03-05","supplier":{"id":761,"key":761,"name":"\u4e2d\u56fd\u7f51\u7edc\u5b89\u5168\u5ba1\u6838\u8ba4\u8bc1\u548c\u5e02\u573a\u76d1\u7ba1\u5927\u6570\u636e\u4e2d\u5fc3"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"\u903e\u671f4\u5929","overdue_amount":"0"}],"count":{"amount":"237121055.95","uncollected":"249712.00","overdue":"248048.00","chargeback_amount":"24388"},"count_days":{"amount":"237121055.95","collected":"236895731.95","uncollected":"249712.00","overdue":"248048.00"},"count_pay":{"amount":"237121055.95","collected":"236895731.95","uncollected":"249712.00","approve_amount":"48951448.55","un_approve_amount":188169607.4},"pagenation":{"totalcount":2252,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 16:05:00', 157587200) RETURNING "id"

[+] Explain