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

Performance Profiling

Total processing time: 138 ms; Peak memory: 4.340 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
16:04:57.30060.5 msyii\db\Command::querySELECT (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) ORDER BY "c_date" DESC LIMIT 20
16:04:57.39711.7 msyii\db\Command::querySELECT 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) ORDER BY "c_date" DESC) "s"))
16:04:57.28810.9 msyii\db\Command::querySELECT 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) ORDER BY "c_date" DESC) "c"
16:04:57.3668.1 msyii\db\Command::querySELECT 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) ORDER BY "c_date" DESC) "sub"
16:04:57.3817.9 msyii\db\Command::querySELECT 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) ORDER BY "c_date" DESC) "sub"
16:04:57.3756.0 msyii\db\Command::querySELECT 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) 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"
16:04:57.3905.9 msyii\db\Command::querySELECT 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) ORDER BY "c_date" DESC) "sub"
16:04:57.4101.4 msyii\db\Command::queryINSERT 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":"","period":"","to":"","from":"","is_paid":"0","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":4416,"id2":4416,"serial_no":"SLKX20260210","supplier_id":660,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"264300","signed_at":"2026-01-23","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"2026-08-31","amount":"132150","status":0,"uncollected":"132150","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"264300","overdue_days":"","uninvoiced":"0","c_date":"2026-08-31","supplier":{"id":660,"key":660,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\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":4282,"id2":4282,"serial_no":"QA251202-01","supplier_id":745,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"5200","signed_at":"2025-12-02","handler":5360,"approve_amount":"","un_approve_amount":"","remind_date":"2026-06-30","amount":"5200","status":0,"uncollected":"5200","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"5200","overdue_days":"","uninvoiced":"0","c_date":"2026-06-30","supplier":{"id":745,"key":745,"name":"\u5317\u4eac\u79e6\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4487,"id2":4487,"serial_no":"\u6d4b\u8bd55555","supplier_id":431,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"55","signed_at":"2026-06-02","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"55","status":0,"uncollected":"55","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"55","c_date":"2026-06-02","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":"","overdue_amount":""},{"id":4485,"id2":4485,"serial_no":"\u4efb\u52a1\u800c\u4e3a","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"300","signed_at":"2026-06-01","handler":1011,"approve_amount":"900","un_approve_amount":"-600","remind_date":"","amount":"300","status":0,"uncollected":"300","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"300","c_date":"2026-06-01","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":4336,"id2":4336,"serial_no":"TSKJ20251224-HYF-01","supplier_id":583,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"42039.92","signed_at":"2025-12-24","handler":1011,"approve_amount":"56656.70","un_approve_amount":"42039.92","remind_date":"2026-05-31","amount":"42039.92","status":0,"uncollected":"42039.92","collected":"0","overdue":"42039.92","overdue_collect_amount":"0","invoiced":"56656.7","overdue_days":4,"uninvoiced":"42039.92","c_date":"2026-05-31","supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"\u903e\u671f4\u5929","overdue_amount":"42039.92"},{"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":4474,"id2":4474,"serial_no":"8457384","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"70","signed_at":"2026-05-20","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"70","status":0,"uncollected":"70","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"70","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":4472,"id2":4472,"serial_no":"\u6d4b\u8bd5\u590d\u53e4\u98ce","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"100","signed_at":"2026-05-15","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"100","status":0,"uncollected":"100","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"100","c_date":"2026-05-15","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":4473,"id2":4473,"serial_no":"","supplier_id":431,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"2222","signed_at":"2026-05-15","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"2222","status":0,"uncollected":"2222","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"2222","c_date":"2026-05-15","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":"","overdue_amount":""},{"id":4469,"id2":4469,"serial_no":"99999999","supplier_id":445,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"9966","signed_at":"2026-05-15","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"9966","status":0,"uncollected":"9966","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"9966","c_date":"2026-05-15","supplier":{"id":445,"key":445,"name":"\u4e2d\u94c1\u4fe1\u5b89(\u5317\u4eac)\u4fe1\u606f\u5b89\u5168\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"","overdue_amount":""},{"id":4470,"id2":4470,"serial_no":"\u6d4b\u7f51\u901f","supplier_id":431,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"2530","signed_at":"2026-05-15","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"2530","status":0,"uncollected":"2530","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"0","overdue_days":"","uninvoiced":"2530","c_date":"2026-05-15","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":"","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":4466,"id2":4466,"serial_no":"\u623f\u79df","supplier_id":431,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"100","signed_at":"2026-05-12","handler":1011,"approve_amount":"","un_approve_amount":"","remind_date":"","amount":"100","status":0,"uncollected":"100","collected":"0","overdue":"","overdue_collect_amount":"","invoiced":"100","overdue_days":"","uninvoiced":"0","c_date":"2026-05-12","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":4445,"id2":4445,"serial_no":"20260814SYNTS01","supplier_id":68,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"56920","signed_at":"2026-03-20","handler":5360,"approve_amount":"","un_approve_amount":"","remind_date":"2026-05-07","amount":"56920","status":0,"uncollected":"56920","collected":"0","overdue":"56920","overdue_collect_amount":"0","invoiced":"0","overdue_days":28,"uninvoiced":"56920","c_date":"2026-05-07","supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f28\u5929","overdue_amount":"56920"}],"count":{"amount":"244264327.71","uncollected":"7392983.76","overdue":"7198764.76","chargeback_amount":"24388"},"count_days":{"amount":"244264327.71","collected":"236895731.95","uncollected":"7392983.76","overdue":"7198764.76"},"count_pay":{"amount":"244264327.71","collected":"236895731.95","uncollected":"7392983.76","approve_amount":"49073058.55","un_approve_amount":195191269.16},"pagenation":{"totalcount":2343,"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:04:57', 132689920) RETURNING "id"
16:04:57.3621.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 489, 660, 46, 745, 431, 583, 445, 68)
16:04:57.3641.3 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days", "status", "remind_date" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN ('4122941', '4177914', '44161098', '4123863', '44471125', '4282994', '4487', '4485', '43361027', '4482', '4477', '4475', '4474', '4472', '4473', '4469', '4470', '44651134', '4466', '44451122') ORDER BY "remind_date"
16:04:57.2800.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:04:57.2820.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:04:57.2800.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta