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

Performance Profiling

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

总计11条数据
TimeDurationCategoryInfo
  
08:56:49.68845.4 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 40
08:56:49.64345.1 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:49.73642.0 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:49.7843.4 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":"3","web_access_token":"KTg8BnZ5JFWa2YxBawF8Yj9F0pEyUuJt"}', '{"code":2000,"result":{"list":[{"id":3757,"supplier_id":262,"contract_type":1,"signed_at":"2025-01-14","amount":"15.59","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-14 10:51:29","updated_at":"2025-01-14 10:51:40","client_id":"","project_id":"","sales_rep":"","serial_no":"308798164676","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-14 10:51:40.539634+08","is_chargeback":false,"collected":"15.59","invoiced":"15.59","approve_amount":"15.59","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":554,"key":554,"contract_id":3757,"name":"2025-01-17","value":"15.59","overdue_days":5}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3756,"supplier_id":46,"contract_type":1,"signed_at":"2025-01-14","amount":"119272.06","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-14 10:25:12","updated_at":"2025-02-19 15:39:38","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202501133114542","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-14 17:33:23.909327+08","is_chargeback":false,"collected":"119272.06","invoiced":"119272.06","approve_amount":"119272.06","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":556,"key":556,"contract_id":3756,"name":"2025-03-10","value":"119272.06","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3754,"supplier_id":236,"contract_type":1,"signed_at":"2025-01-13","amount":"3556.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-01-13 16:16:37","updated_at":"2025-01-13 16:27:27","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250113-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-13 16:16:47.261278+08","is_chargeback":false,"collected":"3556.00","invoiced":"3556","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":552,"key":552,"contract_id":3754,"name":"2025-01-13","value":"3556","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3753,"supplier_id":478,"contract_type":1,"signed_at":"2025-01-13","amount":"915.00","handler":1013,"description":"LC-LC 10M 14\u6839*37.5\u5143\uff1b\nLC-LC 5M 4\u6839*25\u5143\uff1b\nLC-LC 15M 4\u6839*50\u5143\n\u516d\u7c7b\u7f51\u7ebf5M 6\u6839*15\u5143","contract_scan":"","created_by":1011,"created_at":"2025-01-13 11:13:07","updated_at":"2025-01-14 16:15:02","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250113-WJC-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-14 16:15:02.576013+08","is_chargeback":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"915.00","uninvoiced":"915.00","overdue":"915","status":0,"sort_date":"2025-02-13","supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":555,"key":555,"contract_id":3753,"name":"2025-02-13","value":"915","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f140\u5929","overdue_amount":915,"remind_date":"2025-02-13"},{"id":3752,"supplier_id":679,"contract_type":1,"signed_at":"2025-01-13","amount":"6900.00","handler":1011,"description":"\u5218\u5fae\u6625\u8282\u793c\u54c1\u8d60\u9001\u91c7\u8d2d-\u897f\u8d1d\u725b\u7f8a\u8089\u793c\u76d2\uff0c\u7ebf\u4e0a\u5546\u57ce\u5145\u503c\u540e\u4e0b\u5355","contract_scan":"","created_by":1011,"created_at":"2025-01-13 11:02:09","updated_at":"2025-01-16 16:02:54","client_id":"","project_id":"","sales_rep":"","serial_no":"20250113","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-13 11:02:22.33729+08","is_chargeback":false,"collected":"6900.00","invoiced":"6900","approve_amount":"6900","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":679,"key":679,"name":"\u5185\u8499\u53e4\u897f\u8d1d\u9910\u996e\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":550,"key":550,"contract_id":3752,"name":"2025-01-24","value":"6900","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3773,"supplier_id":38,"contract_type":1,"signed_at":"2025-01-10","amount":"5520.00","handler":1013,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-22 14:28:57","updated_at":"2025-01-22 15:03:04","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250110-WJC-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-22 14:29:07.675259+08","is_chargeback":false,"collected":"5520.00","invoiced":"5520","approve_amount":"5520","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":38,"key":38,"name":"\u5317\u4eac\u4e91\u9526\u975e\u51e1\u79d1\u6280\u6709\u9650\u516c\u53f8 \/\u5317\u4eac\u5929\u52e4\u76ca\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8\u3010\u5b89\u82af\u64ce\u5929(\u5929\u6d25)\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011\/\u5317\u4eac\u5747\u4f18\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":565,"key":565,"contract_id":3773,"name":"2025-01-24","value":"5520","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3751,"supplier_id":236,"contract_type":3,"signed_at":"2025-01-10","amount":"3057.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-01-10 17:59:59","updated_at":"2025-01-13 08:56:12","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250110-ZHF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-10 18:00:09.514233+08","is_chargeback":false,"collected":"3057.00","invoiced":"3057","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":549,"key":549,"contract_id":3751,"name":"2025-01-10","value":"3057","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3747,"supplier_id":678,"contract_type":1,"signed_at":"2025-01-09","amount":"43800.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-01-09 10:18:12","updated_at":"2025-01-10 17:45:20","client_id":"","project_id":"","sales_rep":"","serial_no":"YTYG2025","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-09 10:18:26.215208+08","is_chargeback":false,"collected":"43800.00","invoiced":"43800","approve_amount":"43800","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":678,"key":678,"name":"\u5317\u4eac\u667a\u9886\u8d8b\u52bf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":546,"key":546,"contract_id":3747,"name":"2025-02-10","value":"43800","overdue_days":3}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3688,"supplier_id":489,"contract_type":1,"signed_at":"2025-01-09","amount":"9500.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-03 17:46:01","updated_at":"2025-01-09 16:25:40","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241203-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-09 13:56:04.340093+08","is_chargeback":false,"collected":"9500.00","invoiced":"9500","approve_amount":"9500","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":489,"key":489,"name":"\u5317\u4eac\u6234\u68ee\u7279\u7cfb\u7edf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":547,"key":547,"contract_id":3688,"name":"2025-01-17","value":"9500","overdue_days":5}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3743,"supplier_id":677,"contract_type":3,"signed_at":"2024-12-31","amount":"496808.00","handler":1011,"description":"\u4ee3\u8d75\u6657\u7131-\u660e\u5e74\u4f1a\u627e\u5bf9\u5e94\u7684\u4f9b\u5e94\u5546\u7b7e\u7ea6\uff0c2024\u5e74\u5148\u5165\u5728Toast\u4e0b","contract_scan":"","created_by":1011,"created_at":"2025-01-03 10:14:53","updated_at":"2025-01-03 10:15:28","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241231-ZHY-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-03 10:15:11.875636+08","is_chargeback":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"496808.00","uninvoiced":"496808.00","overdue":"496808","status":0,"sort_date":"2025-03-31","supplier":{"id":677,"key":677,"name":"TOAST"},"purchaseContractPaymentCollectionRemindDates":[{"id":541,"key":541,"contract_id":3743,"name":"2025-03-31","value":"496808","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f94\u5929","overdue_amount":496808,"remind_date":"2025-03-31"},{"id":3741,"supplier_id":564,"contract_type":1,"signed_at":"2024-12-31","amount":"335350.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-12-31 09:55:20","updated_at":"2025-02-19 14:08:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241231-SQY-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-31 13:35:25.962961+08","is_chargeback":false,"collected":"335350.00","invoiced":"335350","approve_amount":"335350","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":564,"key":564,"name":"\u767e\u552f\u901a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":539,"key":539,"contract_id":3741,"name":"2025-01-15","value":"335350","overdue_days":29}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3739,"supplier_id":608,"contract_type":1,"signed_at":"2024-12-30","amount":"142.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-12-30 15:06:24","updated_at":"2024-12-30 15:06:38","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4185011232263592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-30 15:06:38.962662+08","is_chargeback":false,"collected":"142.00","invoiced":"142","approve_amount":"142","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":537,"key":537,"contract_id":3739,"name":"2025-01-10","value":"142","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3730,"supplier_id":608,"contract_type":1,"signed_at":"2024-12-26","amount":"142.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-12-26 17:02:24","updated_at":"2024-12-26 17:02:39","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4180884231614592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-26 17:02:39.413353+08","is_chargeback":false,"collected":"142.00","invoiced":"142","approve_amount":"142","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":534,"key":534,"contract_id":3730,"name":"2025-01-10","value":"142","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3727,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"67594.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:48:04","updated_at":"2025-03-12 13:48:33","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ36962","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-25 14:48:18.417249+08","is_chargeback":false,"collected":"0","invoiced":"67594","approve_amount":"","un_approve_amount":"","uncollected":"67594.00","uninvoiced":"0.00","overdue":"67594","status":0,"sort_date":"2025-03-28","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":532,"key":532,"contract_id":3727,"name":"2025-03-28","value":"67594","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f97\u5929","overdue_amount":67594,"remind_date":"2025-03-28"},{"id":3726,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-26","amount":"51606.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 14:47:02","updated_at":"2025-01-07 11:07:51","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ37023","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-07 11:07:51.356049+08","is_chargeback":false,"collected":"51606.00","invoiced":"51606","approve_amount":"51606","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":90,"key":90,"name":"\u7d2b\u5149\u6653\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":544,"key":544,"contract_id":3726,"name":"2025-02-25","value":"51606","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3728,"supplier_id":106,"contract_type":1,"signed_at":"2024-12-25","amount":"1900.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-26 13:51:57","updated_at":"2024-12-31 11:27:00","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241225-HYF-009","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-26 13:52:12.306922+08","is_chargeback":false,"collected":"1900.00","invoiced":"1900","approve_amount":"1900","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":106,"key":106,"name":"\u5317\u4eac\u8fd0\u8054\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":533,"key":533,"contract_id":3728,"name":"2025-01-23","value":"1900","overdue_days":1}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3722,"supplier_id":116,"contract_type":3,"signed_at":"2024-12-24","amount":"7500.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-24 16:57:32","updated_at":"2025-01-16 10:48:26","client_id":"","project_id":"","sales_rep":"","serial_no":"20241224001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-24 16:57:40.485186+08","is_chargeback":false,"collected":"7500.00","invoiced":"7500","approve_amount":"7500","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":116,"key":116,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u4fe1\u606f\u4ea7\u54c1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":528,"key":528,"contract_id":3722,"name":"2024-12-25","value":"7500","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3721,"supplier_id":59,"contract_type":1,"signed_at":"2024-12-24","amount":"1550.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-12-24 16:39:47","updated_at":"2025-02-13 15:07:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250110-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-02-11 15:14:48.005725+08","is_chargeback":false,"collected":"1550.00","invoiced":"1550","approve_amount":"1550","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":59,"key":59,"name":"\u5317\u4eac\u592a\u8c37\u8baf\u8bda\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":575,"key":575,"contract_id":3721,"name":"2025-02-14","value":"1550","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3720,"supplier_id":163,"contract_type":3,"signed_at":"2024-12-24","amount":"179280.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-24 13:28:59","updated_at":"2025-01-16 10:18:31","client_id":"","project_id":"","sales_rep":"","serial_no":"2024WSCN-L-014-C4423-PAN","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-24 13:29:16.29923+08","is_chargeback":false,"collected":"179280.00","invoiced":"179280","approve_amount":"179280","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":163,"key":163,"name":"\u536b\u5b9e\u5eb7\u79d1\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":526,"key":526,"contract_id":3720,"name":"2025-02-25","value":"179280","overdue_days":0}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3719,"supplier_id":673,"contract_type":1,"signed_at":"2024-12-19","amount":"299600.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-19 15:13:38","updated_at":"2024-12-30 16:38:56","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241219-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-19 15:13:54.384255+08","is_chargeback":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"299600.00","uninvoiced":"299600.00","overdue":"299600","status":0,"sort_date":"2025-04-30","supplier":{"id":673,"key":673,"name":"\u5317\u4eac\u5eb7\u4e7e\u5efa\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":520,"key":520,"contract_id":3719,"name":"2025-04-30","value":"299600","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f64\u5929","overdue_amount":299600,"remind_date":"2025-04-30"}],"count":{"amount":"218869828.67","collected":"210147043.93","approve_amount":"22559245.88","uncollected":"8722784.74","un_approve_amount":196310582.79},"pagenation":{"totalcount":1867,"thispage":3,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 08:56:49') RETURNING "id"
08:56:49.7793.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:49.6362.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
08:56:49.6351.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
08:56:49.6401.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
08:56:49.7820.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=16, "last_visit_at"='now()' WHERE "id"=49771
08:56:49.7340.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (262, 46, 236, 478, 679, 38, 678, 489, 677, 564, 608, 90, 106, 116, 59, 163, 673)
08:56:49.7350.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 (3757, 3756, 3754, 3753, 3752, 3773, 3751, 3747, 3688, 3743, 3741, 3739, 3730, 3727, 3726, 3728, 3722, 3721, 3720, 3719) ORDER BY "remind_date"