ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6865d530d391d: POST https://beta.jinchangxiao.com/vue/analysis/purchase-collected-payment-collection at 2025-07-03 08:56:16 am by 115.171.251.24

Performance Profiling

Total processing time: 161 ms; Peak memory: 4.093 MB. Show Profiling Timeline

总计11条数据
TimeDurationCategoryInfo
  
08:56:16.92245.9 msyii\db\Command::querySELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20 OFFSET 20
08:56:16.87745.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"
08:56:16.97042.1 msyii\db\Command::querySELECT sum(amount) as amount, sum(collected) as collected, sum(approve_amount) as approve_amount, sum(amount - collected) as uncollected FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_payments" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-07-03') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "contract_id", sum(amount) as collected FROM "a57be577deb434"."tbl_purchase_contract_payments" GROUP BY "contract_id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-07-03') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE "is_chargeback"=FALSE GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "signed_at" DESC) "sub"
08:56:17.0187.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/analysis/purchase-collected-payment-collection', '{"status":"","approve_status":"","period":"","to":"","from":"","page":"2","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":{"list":[{"id":3807,"supplier_id":67,"contract_type":1,"signed_at":"2025-02-25","amount":"198840.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-05 10:03:59","updated_at":"2025-03-05 17:13:50","client_id":"","project_id":"","sales_rep":"","serial_no":"XM20250225000132","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-05 10:04:26.571739+08","is_chargeback":false,"collected":"0","invoiced":"198840","approve_amount":"","un_approve_amount":"","uncollected":"198840.00","uninvoiced":"0.00","overdue":"198840","status":0,"sort_date":"2025-05-05","supplier":{"id":67,"key":67,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":595,"key":595,"contract_id":3807,"name":"2025-05-05","value":"198840","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f59\u5929","overdue_amount":198840,"remind_date":"2025-05-05"},{"id":3794,"supplier_id":262,"contract_type":1,"signed_at":"2025-02-24","amount":"5769.94","handler":1011,"description":"\u5ba2\u6237\u8c03\u7814\uff0c\u7528\u6237\u4f34\u624b\u793c\u3002","contract_scan":"","created_by":1011,"created_at":"2025-02-25 11:38:40","updated_at":"2025-02-25 11:39:29","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 309973450263","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-25 11:39:29.090288+08","is_chargeback":false,"collected":"5769.94","invoiced":"5769.94","approve_amount":"5769.94","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":587,"key":587,"contract_id":3794,"name":"2025-02-28","value":"5769.94","overdue_days":5}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3793,"supplier_id":505,"contract_type":1,"signed_at":"2025-02-24","amount":"530.00","handler":5360,"description":"\u4e00\u5e74\u4fdd\u4fee","contract_scan":"","created_by":5360,"created_at":"2025-02-24 17:21:35","updated_at":"2025-02-27 10:46:24","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-24 17:21:55.251924+08","is_chargeback":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"530.00","uninvoiced":"530.00","overdue":"530","status":0,"sort_date":"2025-03-24","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u795e\u5dde\u540c\u6b63\u8ba1\u7b97\u673a\u8bbe\u5907\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":585,"key":585,"contract_id":3793,"name":"2025-03-24","value":"530","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f101\u5929","overdue_amount":530,"remind_date":"2025-03-24"},{"id":3798,"supplier_id":479,"contract_type":3,"signed_at":"2025-02-18","amount":"0","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-27 10:27:19","updated_at":"2025-02-27 10:27:19","client_id":"","project_id":"","sales_rep":"","serial_no":"CG20250218201","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"0","uninvoiced":"0","overdue":"","status":2,"sort_date":"","supplier":{"id":479,"key":479,"name":"\u4e0a\u6d77\u4e91\u8f74\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3788,"supplier_id":623,"contract_type":1,"signed_at":"2025-02-18","amount":"222000.00","handler":1011,"description":"\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240-\u76f4\u63a5\u7528\u6237","contract_scan":"","created_by":1011,"created_at":"2025-02-18 10:42:27","updated_at":"2025-02-24 11:34:16","client_id":"","project_id":"","sales_rep":"","serial_no":"20250218","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-18 10:43:07.418242+08","is_chargeback":false,"collected":"0","invoiced":"222000","approve_amount":"","un_approve_amount":"","uncollected":"222000.00","uninvoiced":"0.00","overdue":"222000","status":0,"sort_date":"2025-03-24","supplier":{"id":623,"key":623,"name":"\u5317\u4eac\u9f50\u4fe1\u5171\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":579,"key":579,"contract_id":3788,"name":"2025-03-24","value":"222000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f101\u5929","overdue_amount":222000,"remind_date":"2025-03-24"},{"id":3827,"supplier_id":165,"contract_type":1,"signed_at":"2025-02-13","amount":"600.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-03-12 11:46:49","updated_at":"2025-03-12 11:46:58","client_id":"","project_id":"","sales_rep":"","serial_no":"20250213","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 11:46:58.174049+08","is_chargeback":false,"collected":"600.00","invoiced":"600","approve_amount":"600","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":165,"key":165,"name":"\u5317\u4eac\u7eb3\u6069\u6052\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":618,"key":618,"contract_id":3827,"name":"2025-03-13","value":"600","overdue_days":1}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3785,"supplier_id":355,"contract_type":3,"signed_at":"2025-02-13","amount":"25080.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-13 16:13:14","updated_at":"2025-02-17 09:27:15","client_id":"","project_id":"","sales_rep":"","serial_no":"ZBHT2025021301","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-13 16:13:36.090171+08","is_chargeback":false,"collected":"25080.00","invoiced":"25080","approve_amount":"25080","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":355,"key":355,"name":"\u4e2d\u5317\u6c47\u901a(\u5317\u4eac)\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":577,"key":577,"contract_id":3785,"name":"2025-02-17","value":"25080","overdue_days":3}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3784,"supplier_id":174,"contract_type":1,"signed_at":"2025-02-12","amount":"2000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-13 09:43:52","updated_at":"2025-02-13 11:13:56","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250212-HYF-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-13 09:44:05.763981+08","is_chargeback":false,"collected":"2000.00","invoiced":"2000","approve_amount":"2000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":174,"key":174,"name":"\u5317\u4eac\u79d1\u534e\u5609\u4e1a\u79d1\u8d38\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":576,"key":576,"contract_id":3784,"name":"2025-02-17","value":"2000","overdue_days":1}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3786,"supplier_id":683,"contract_type":3,"signed_at":"2025-02-11","amount":"35000.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-02-13 17:26:24","updated_at":"2025-02-13 17:27:11","client_id":"","project_id":"","sales_rep":"","serial_no":"CNDC250206002","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-13 17:26:47.420296+08","is_chargeback":false,"collected":"35000.00","invoiced":"35000","approve_amount":"35000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":683,"key":683,"name":"\u4e0a\u6d77\u534e\u6602\u5546\u52a1\u54a8\u8be2\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":578,"key":578,"contract_id":3786,"name":"2025-02-28","value":"35000","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3781,"supplier_id":682,"contract_type":1,"signed_at":"2025-02-11","amount":"2515.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-02-11 11:08:51","updated_at":"2025-03-12 09:06:32","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250211-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-12 09:06:32.807674+08","is_chargeback":false,"collected":"2515.00","invoiced":"2515","approve_amount":"2515","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":682,"key":682,"name":"\u5317\u4eac\u4f73\u65e5\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":616,"key":616,"contract_id":3781,"name":"2025-03-13","value":"2515","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3779,"supplier_id":608,"contract_type":1,"signed_at":"2025-02-10","amount":"768.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-02-10 14:19:48","updated_at":"2025-02-10 14:20:01","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4227032052866592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-10 14:20:01.92498+08","is_chargeback":false,"collected":"768.00","invoiced":"768","approve_amount":"768","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":572,"key":572,"contract_id":3779,"name":"2025-02-21","value":"768","overdue_days":7}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3776,"supplier_id":659,"contract_type":1,"signed_at":"2025-01-24","amount":"22420.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-24 10:52:50","updated_at":"2025-03-11 10:04:35","client_id":"","project_id":"","sales_rep":"","serial_no":"XM20250124000033","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-03-11 10:04:35.227533+08","is_chargeback":false,"collected":"22420.00","invoiced":"22420","approve_amount":"22420","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":659,"key":659,"name":"\u4f73\u6770\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":612,"key":612,"contract_id":3776,"name":"2025-02-24","value":"10778","overdue_days":0},{"id":613,"key":613,"contract_id":3776,"name":"2025-03-13","value":"11642","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3775,"supplier_id":262,"contract_type":1,"signed_at":"2025-01-23","amount":"1807.98","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-23 10:03:02","updated_at":"2025-01-23 10:05:52","client_id":"","project_id":"","sales_rep":"","serial_no":" 309063394782","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-23 10:03:22.985147+08","is_chargeback":false,"collected":"1807.98","invoiced":"1827.98","approve_amount":"1807.98","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"-20.00","overdue":"","status":2,"sort_date":"","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":567,"key":567,"contract_id":3775,"name":"2025-02-14","value":"1807.98","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3774,"supplier_id":138,"contract_type":3,"signed_at":"2025-01-22","amount":"165433.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-22 17:13:53","updated_at":"2025-01-23 10:13:49","client_id":"","project_id":"","sales_rep":"","serial_no":"SFJDFWH202501220039","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-22 17:14:06.010835+08","is_chargeback":false,"collected":"165433.00","invoiced":"165433","approve_amount":"165433","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchaseContractPaymentCollectionRemindDates":[{"id":566,"key":566,"contract_id":3774,"name":"2025-01-22","value":"165433","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3772,"supplier_id":607,"contract_type":3,"signed_at":"2025-01-21","amount":"254235.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-22 11:38:20","updated_at":"2025-01-22 11:38:32","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ0120-ZHY-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-22 11:38:32.268737+08","is_chargeback":false,"collected":"254235.00","invoiced":"254235","approve_amount":"254235.00","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":607,"key":607,"name":"\u4e2d\u6d77\u57ce(\u5317\u4eac)\u5efa\u8bbe\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":563,"key":563,"contract_id":3772,"name":"2025-01-24","value":"254235","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3780,"supplier_id":236,"contract_type":3,"signed_at":"2025-01-20","amount":"7313.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-02-11 10:02:33","updated_at":"2025-02-11 10:05:58","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250120-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-11 10:02:47.098177+08","is_chargeback":false,"collected":"7313.00","invoiced":"7313","approve_amount":"","un_approve_amount":"","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":573,"key":573,"contract_id":3780,"name":"2025-01-20","value":"7313","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3769,"supplier_id":90,"contract_type":1,"signed_at":"2025-01-20","amount":"64665.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-21 15:26:45","updated_at":"2025-03-12 13:48:25","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2025SBQ01556","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-21 15:27:04.316481+08","is_chargeback":false,"collected":"0","invoiced":"64665","approve_amount":"","un_approve_amount":"","uncollected":"64665.00","uninvoiced":"0.00","overdue":"64665","status":0,"sort_date":"2025-04-15","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":562,"key":562,"contract_id":3769,"name":"2025-04-15","value":"64665","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f79\u5929","overdue_amount":64665,"remind_date":"2025-04-15"},{"id":3766,"supplier_id":138,"contract_type":3,"signed_at":"2025-01-20","amount":"76920.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-20 10:52:20","updated_at":"2025-01-21 14:42:54","client_id":"","project_id":"","sales_rep":"","serial_no":"SFSSFWH202501200015","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-20 10:52:35.154199+08","is_chargeback":false,"collected":"76920.00","invoiced":"76920","approve_amount":"76920","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6df1\u4fe1\u670d\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff09"},"purchaseContractPaymentCollectionRemindDates":[{"id":560,"key":560,"contract_id":3766,"name":"2025-01-22","value":"76920","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3765,"supplier_id":680,"contract_type":3,"signed_at":"2025-01-20","amount":"63360.00","handler":1011,"description":"\u4ee3\u8d75\u6657\u7131\u7b7e\u7f72\u3002","contract_scan":"","created_by":1011,"created_at":"2025-01-20 09:57:20","updated_at":"2025-01-20 09:57:47","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250120-ZHY-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-20 09:57:29.510161+08","is_chargeback":false,"collected":"63360.00","invoiced":"63360","approve_amount":"63360","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":680,"key":680,"name":"\u70df\u53f0\u5e02\u8000\u534e\u6d4b\u63a7\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":559,"key":559,"contract_id":3765,"name":"2025-01-24","value":"63360","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3760,"supplier_id":137,"contract_type":1,"signed_at":"2025-01-15","amount":"25750.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-01-15 15:46:23","updated_at":"2025-02-24 15:07:51","client_id":"","project_id":"","sales_rep":"","serial_no":"A202501-15","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-24 09:50:08.370774+08","is_chargeback":false,"collected":"25750.00","invoiced":"25750","approve_amount":"25750","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":137,"key":137,"name":"\u5317\u4eac\u79e6\u8fbe\u5609\u5174\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":583,"key":583,"contract_id":3760,"name":"2025-02-17","value":"25300","overdue_days":9},{"id":584,"key":584,"contract_id":3760,"name":"2025-03-13","value":"450","overdue_days":1}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""}],"count":{"amount":"218869828.67","collected":"210147043.93","approve_amount":"22559245.88","uncollected":"8722784.74","un_approve_amount":196310582.79},"pagenation":{"totalcount":1867,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 08:56:17') RETURNING "id"
08:56:17.0143.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=23) AND ("visit_date"='2025-07-03')
08:56:16.8702.4 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
08:56:16.8682.1 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
08:56:16.8731.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
08:56:17.0170.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=15, "last_visit_at"='now()' WHERE "id"=49771
08:56:16.9690.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (67, 262, 505, 479, 623, 165, 355, 174, 683, 682, 608, 659, 138, 607, 236, 90, 680, 137)
08:56:16.9690.4 msyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3807, 3794, 3793, 3798, 3788, 3827, 3785, 3784, 3786, 3781, 3779, 3776, 3775, 3774, 3772, 3780, 3769, 3766, 3765, 3760) ORDER BY "remind_date"