ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a43326d8a7fe: POST https://beta.jinchangxiao.com/vue/analysis/purchase-payment-collection at 2026-06-30 11:05:17 am by 39.156.194.178

Performance Profiling

Total processing time: 103 ms; Peak memory: 4.371 MB. Show Profiling Timeline

总计14条数据
TimeDurationCategoryInfo
  
11:05:17.59225.6 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-30'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-30' 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-30'))) 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 OFFSET 20
11:05:17.6508.5 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-30'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-30' 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-30'))) 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"))
11:05:17.5838.2 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-30'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-30' 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-30'))) 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"
11:05:17.6427.4 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-30'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-30' 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-30'))) 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"
11:05:17.6216.9 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-30'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-30' 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-30'))) 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"
11:05:17.6356.6 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-30'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-30' 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-30'))) 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"
11:05:17.6286.2 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-30'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-30' 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-30'))) 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"
11:05:17.6602.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":"","approve_status":"","collect_period":"","collect_to":"","collect_from":"","is_paid":"1","page":"2","web_access_token":"x0LWxNxY1IWpHbWh_3nnhDQVjp8ngz97"}', '{"code":2000,"result":{"list":[{"id":4432,"id2":4432,"serial_no":"JXFKJ-20260304\/TSKJ","supplier_id":757,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2026-03-04","handler":1011,"approve_amount":"1661.92","un_approve_amount":"0.00","remind_date":"2026-03-04","amount":"1661.92","status":1,"uncollected":"0.00","collected":"1661.92","overdue":"0.00","overdue_collect_amount":"1661.92","invoiced":"1661.92","overdue_days":1,"uninvoiced":"0.00","c_date":"2026-03-04","supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"\u903e\u671f1\u5929","overdue_amount":"0.00"},{"id":4397,"id2":4397,"serial_no":"XM2026126000290","supplier_id":67,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2026-01-26","handler":5360,"approve_amount":"23654","un_approve_amount":"0","remind_date":"2026-03-01","amount":"23654","status":1,"uncollected":"0","collected":"23654","overdue":"0","overdue_collect_amount":"","invoiced":"23654","overdue_days":"","uninvoiced":"0","c_date":"2026-03-01","supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"","overdue_amount":"0"},{"id":4420,"id2":4420,"serial_no":"20260226","supplier_id":757,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2026-02-26","handler":5360,"approve_amount":"3429.30","un_approve_amount":"0.00","remind_date":"2026-02-27","amount":"3429.3","status":1,"uncollected":"0.0","collected":"3429.3","overdue":"0.0","overdue_collect_amount":"3429.3","invoiced":"3429.30","overdue_days":10,"uninvoiced":"0.00","c_date":"2026-02-27","supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"\u903e\u671f10\u5929","overdue_amount":"0.0"},{"id":4421,"id2":4421,"serial_no":"BJ20260226","supplier_id":757,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-02-26","handler":5360,"approve_amount":"3532","un_approve_amount":"0","remind_date":"2026-02-27","amount":"3532","status":1,"uncollected":"0","collected":"3532","overdue":"0","overdue_collect_amount":"3532","invoiced":"3532","overdue_days":10,"uninvoiced":"0","c_date":"2026-02-27","supplier":{"id":757,"key":757,"name":"\u5317\u4eac\u4eac\u4fe1\u670d\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f10\u5929","overdue_amount":"0"},{"id":4398,"id2":4398,"serial_no":"TSKJ20260127-HYF-008","supplier_id":598,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-01-28","handler":1011,"approve_amount":"32000","un_approve_amount":"0","remind_date":"2026-02-27","amount":"32000","status":1,"uncollected":"0","collected":"32000","overdue":"0","overdue_collect_amount":"32000","invoiced":"32000","overdue_days":19,"uninvoiced":"0","c_date":"2026-02-27","supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f19\u5929","overdue_amount":"0"},{"id":4392,"id2":4392,"serial_no":"XM20260123000275","supplier_id":67,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-01-23","handler":1011,"approve_amount":"25138","un_approve_amount":"0","remind_date":"2026-02-26","amount":"25138","status":1,"uncollected":"0","collected":"25138","overdue":"0","overdue_collect_amount":"25138","invoiced":"25138","overdue_days":1,"uninvoiced":"0","c_date":"2026-02-26","supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f1\u5929","overdue_amount":"0"},{"id":4348,"id2":4348,"serial_no":"XM20251223000711","supplier_id":67,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-12-23","handler":1011,"approve_amount":"186480","un_approve_amount":"0","remind_date":"2026-02-25","amount":"186480","status":1,"uncollected":"0","collected":"186480","overdue":"0","overdue_collect_amount":"186480","invoiced":"186480","overdue_days":6,"uninvoiced":"0","c_date":"2026-02-25","supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f6\u5929","overdue_amount":"0"},{"id":4331,"id2":4331,"serial_no":"TSKJ20251223-HYF-001","supplier_id":749,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2025-12-23","handler":1011,"approve_amount":"133000","un_approve_amount":"0","remind_date":"2026-02-23","amount":"133000","status":1,"uncollected":"0","collected":"133000","overdue":"0","overdue_collect_amount":"133000","invoiced":"133000","overdue_days":17,"uninvoiced":"0","c_date":"2026-02-23","supplier":{"id":749,"key":749,"name":"\u5317\u4eac\u8239\u6c34\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"\u903e\u671f17\u5929","overdue_amount":"0"},{"id":4379,"id2":4379,"serial_no":"ZLQS20260115","supplier_id":678,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-01-15","handler":1011,"approve_amount":"30400","un_approve_amount":"0","remind_date":"2026-02-15","amount":"30400","status":1,"uncollected":"0","collected":"30400","overdue":"0","overdue_collect_amount":"30400","invoiced":"30400","overdue_days":29,"uninvoiced":"0","c_date":"2026-02-15","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f29\u5929","overdue_amount":"0"},{"id":4376,"id2":4376,"serial_no":"TSKJ20260112-HYF-001","supplier_id":756,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"379","signed_at":"2026-01-12","handler":1011,"approve_amount":"1","un_approve_amount":"379","remind_date":"2026-02-12","amount":"380","status":0,"uncollected":"378","collected":"2","overdue":"378","overdue_collect_amount":"2","invoiced":"0","overdue_days":138,"uninvoiced":"380","c_date":"2026-02-12","supplier":{"id":756,"key":756,"name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f138\u5929","overdue_amount":"378"},{"id":4415,"id2":4415,"serial_no":"\u62d3\u5b9e&\u5bd2\u5e8f(FCC-E\u4e13\u6709\u533a\u57df\u6269\u5bb9\uff092026","supplier_id":583,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"38645","signed_at":"2026-02-06","handler":1011,"approve_amount":"12881.61","un_approve_amount":"38645.00","remind_date":"2026-02-11","amount":"12881.61","status":1,"uncollected":"0.00","collected":"12881.61","overdue":"0.00","overdue_collect_amount":"","invoiced":"12881.61","overdue_days":"","uninvoiced":"38645.00","c_date":"2026-02-11","supplier":{"id":583,"key":583,"name":"\u4e0a\u6d77\u901f\u77f3\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4418,"id2":4418,"serial_no":"TSKJ20260211-CYS-02","supplier_id":742,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-02-11","handler":1011,"approve_amount":"1800","un_approve_amount":"0","remind_date":"2026-02-11","amount":"1800","status":1,"uncollected":"0","collected":"1800","overdue":"0","overdue_collect_amount":"1800","invoiced":"1800","overdue_days":0,"uninvoiced":"0","c_date":"2026-02-11","supplier":{"id":742,"key":742,"name":"\u9648\u667a\u8339"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":4419,"id2":4419,"serial_no":"TSKJ20260211-CYS-01","supplier_id":741,"is_chargeback":false,"contract_type":4,"erp_un_settle_amount":"0","signed_at":"2026-02-11","handler":1011,"approve_amount":"2100","un_approve_amount":"0","remind_date":"2026-02-11","amount":"2100","status":1,"uncollected":"0","collected":"2100","overdue":"0","overdue_collect_amount":"2100","invoiced":"2100","overdue_days":0,"uninvoiced":"0","c_date":"2026-02-11","supplier":{"id":741,"key":741,"name":"\u4e8e\u6d9b"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":4329,"id2":4329,"serial_no":"PA20251222TOAST01","supplier_id":68,"is_chargeback":false,"contract_type":3,"erp_un_settle_amount":"0","signed_at":"2025-12-22","handler":1011,"approve_amount":"191143.96","un_approve_amount":"0.00","remind_date":"2026-02-11","amount":"191143.96","status":1,"uncollected":"0.00","collected":"191143.96","overdue":"0.00","overdue_collect_amount":"","invoiced":"191144.85","overdue_days":"","uninvoiced":"-0.89","c_date":"2026-02-11","supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","overdue_display":"","overdue_amount":"0.00"},{"id":4315,"id2":4315,"serial_no":"DZ202512161166283","supplier_id":46,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-12-16","handler":1011,"approve_amount":"23668","un_approve_amount":"0","remind_date":"2026-02-10","amount":"23668","status":1,"uncollected":"0","collected":"23668","overdue":"0","overdue_collect_amount":"","invoiced":"23668","overdue_days":"","uninvoiced":"0","c_date":"2026-02-10","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":"0"},{"id":4236,"id2":4236,"serial_no":"DZ202510281161608","supplier_id":46,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-11-06","handler":1011,"approve_amount":"21480","un_approve_amount":"0","remind_date":"2026-02-10","amount":"21480","status":1,"uncollected":"0","collected":"21480","overdue":"0","overdue_collect_amount":"","invoiced":"21480","overdue_days":"","uninvoiced":"0","c_date":"2026-02-10","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":"0"},{"id":4369,"id2":4369,"serial_no":"TGXC20260107-1","supplier_id":59,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-01-07","handler":5360,"approve_amount":"2200","un_approve_amount":"0","remind_date":"2026-02-08","amount":"2200","status":1,"uncollected":"0","collected":"2200","overdue":"0","overdue_collect_amount":"2200","invoiced":"2200","overdue_days":24,"uninvoiced":"0","c_date":"2026-02-08","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f24\u5929","overdue_amount":"0"},{"id":4368,"id2":4368,"serial_no":"ZLQS20260107","supplier_id":678,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-01-07","handler":5360,"approve_amount":"6000","un_approve_amount":"0","remind_date":"2026-02-08","amount":"6000","status":1,"uncollected":"0","collected":"6000","overdue":"0","overdue_collect_amount":"6000","invoiced":"6000","overdue_days":1,"uninvoiced":"0","c_date":"2026-02-08","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"\u903e\u671f1\u5929","overdue_amount":"0"},{"id":4292,"id2":4292,"serial_no":"juhongH320251128008A","supplier_id":746,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2025-12-08","handler":1011,"approve_amount":"1110000","un_approve_amount":"0","remind_date":"2026-02-07","amount":"1110000","status":1,"uncollected":"0","collected":"1110000","overdue":"0","overdue_collect_amount":"","invoiced":"1110000","overdue_days":"","uninvoiced":"0","c_date":"2026-02-07","supplier":{"id":746,"key":746,"name":"\u5317\u4eac\u6854\u7ea2\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","overdue_amount":"0"},{"id":4407,"id2":4407,"serial_no":"\u8ba2\u5355\u53f7\uff1a345859778243","supplier_id":262,"is_chargeback":false,"contract_type":1,"erp_un_settle_amount":"0","signed_at":"2026-02-02","handler":1011,"approve_amount":"1000","un_approve_amount":"0","remind_date":"2026-02-06","amount":"1000","status":1,"uncollected":"0","collected":"1000","overdue":"0","overdue_collect_amount":"","invoiced":"1000","overdue_days":"","uninvoiced":"0","c_date":"2026-02-06","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","overdue_display":"","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":"48951449.55","un_approve_amount":188169606.4},"pagenation":{"totalcount":2252,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Safari\/537.36"}', FALSE, '2026-06-30 11:05:17', 91848960) RETURNING "id"
11:05:17.5730.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:05:17.5750.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:05:17.6190.6 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 ('44321109', '43971080', '44201101', '44211102', '43981079', '43921077', '43481041', '43311023', '43791069', '43761066', '44151095', '44181099', '44191100', '43291092', '43151017', '4236964', '43691061', '43681060', '42921000', '44071087') ORDER BY "remind_date"
11:05:17.5770.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:05:17.6190.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (757, 67, 598, 749, 678, 756, 583, 742, 741, 68, 46, 59, 746, 262)
11:05:17.5720.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta