ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68662298bff4b: POST https://beta.jinchangxiao.com/vue/analysis/purchase-collected-payment-collection at 2025-07-03 02:26:32 pm by 114.254.1.137

Database Queries

总计11条数据
TimeDurationTypeQuery
  
14:26:32.7892.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:26:32.7920.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:26:32.7931.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:26:32.79748.2 msSELECTSELECT 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 approve_amount DESC nulls last, "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"

[+] Explain
14:26:32.84547.5 msSELECTSELECT 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 approve_amount DESC nulls last, "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20

[+] Explain
14:26:32.8930.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (90, 431, 557, 46, 629, 516, 614, 68, 564, 671, 607, 662, 163, 598, 138, 511)

[+] Explain
14:26:32.8940.4 msSELECTSELECT "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 (3494, 3848, 3479, 3079, 3640, 3429, 3706, 3614, 3723, 3687, 3741, 3704, 3599, 3772, 3668, 3566, 3720, 3554, 3774, 3617) ORDER BY "remind_date"

[+] Explain
14:26:32.89545.4 msSELECTSELECT 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"

[+] Explain
14:26:32.9423.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-07-03')

[+] Explain
14:26:32.9460.9 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=35, "last_visit_at"='now()' WHERE "id"=49773

[+] Explain
14:26:32.9471.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/purchase-collected-payment-collection', '{"status":"","approve_status":"","period":"","to":"","from":"","page":"1","Filter":{"sort":"DESC","name":"approve_amount"},"web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"code":2000,"result":{"list":[{"id":3494,"supplier_id":90,"contract_type":1,"signed_at":"2024-08-26","amount":"5384842.10","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-08-26 17:20:47","updated_at":"2024-09-10 09:29:43","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ22400","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-10 09:29:43.831611+08","is_chargeback":false,"cost_type":1,"collected":"5384842.10","invoiced":"5384842.1","approve_amount":"5384842.10","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":326,"key":326,"contract_id":3494,"name":"2024-10-26","value":"5384842.1","overdue_days":4}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3848,"supplier_id":431,"contract_type":3,"signed_at":"2025-07-03","amount":"50000000","handler":1011,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-07-03 14:21:31","updated_at":"2025-07-03 14:21:31","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u8d39\u7528\u5408\u540c","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":2,"collected":"0","invoiced":"0","approve_amount":"4000000","un_approve_amount":"46000000","uncollected":"50000000","uninvoiced":"50000000","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3479,"supplier_id":557,"contract_type":1,"signed_at":"2024-08-19","amount":"3853810.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-08-19 17:05:00","updated_at":"2024-08-19 17:06:54","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240819-HYF-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-19 17:06:54.158325+08","is_chargeback":false,"cost_type":1,"collected":"3853810.00","invoiced":"3853810","approve_amount":"3853810","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":557,"key":557,"name":"\u5b89\u5168\u80fd\u529b\u751f\u6001\u805a\u5408\uff08\u5317\u4eac\uff09\u8fd0\u8425\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":273,"key":273,"contract_id":3479,"name":"2024-09-06","value":"1156143","overdue_days":40},{"id":274,"key":274,"contract_id":3479,"name":"2024-10-31","value":"1541524","overdue_days":""},{"id":275,"key":275,"contract_id":3479,"name":"2024-12-31","value":"1156143","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3079,"supplier_id":557,"contract_type":1,"signed_at":"2024-01-15","amount":"3682840.00","handler":1011,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-01-15 11:15:20","updated_at":"2024-05-07 17:11:26","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240115-HYF-001","payment_collection_remind_ahead":"7 days","including_tax":true,"is_save_collection":true,"save_collection_at":"","is_chargeback":false,"cost_type":1,"collected":"3682840.00","invoiced":"3682840.00","approve_amount":"2577988","un_approve_amount":"1104852.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":557,"key":557,"name":"\u5b89\u5168\u80fd\u529b\u751f\u6001\u805a\u5408\uff08\u5317\u4eac\uff09\u8fd0\u8425\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":68,"key":68,"contract_id":3079,"name":"2024-02-23","value":"1104852","overdue_days":0},{"id":66,"key":66,"contract_id":3079,"name":"2024-07-31","value":"1473136","overdue_days":166},{"id":67,"key":67,"contract_id":3079,"name":"2024-09-30","value":"1104852","overdue_days":105}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3640,"supplier_id":46,"contract_type":1,"signed_at":"2024-10-30","amount":"1868000.00","handler":1011,"description":"\u5317\u5954\u7684\u9879\u76ee\uff0c\u5e94\u8be5\u7b7e\u7684\u5408\u540c\u91d1\u989d\u662f\uff1a\uffe52,496,572.00\uff0c\u5e2e\u5fd9\u62b5\u6263628572\uff0c\u5b9e\u9645\u7b7e\u7ea6\u5408\u540c\u91d1\u989d\u662f\uff1a1868000","contract_scan":"","created_by":1011,"created_at":"2024-10-30 14:18:46","updated_at":"2025-01-21 09:47:24","client_id":"","project_id":"","sales_rep":"","serial_no":"DZ202410291132612","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-30 14:19:18.748468+08","is_chargeback":false,"cost_type":1,"collected":"1868000.00","invoiced":"1868000","approve_amount":"1868000","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":438,"key":438,"contract_id":3640,"name":"2025-02-08","value":"1868000","overdue_days":37}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3429,"supplier_id":629,"contract_type":1,"signed_at":"2024-07-24","amount":"1696500.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2024-07-24 13:23:28","updated_at":"2024-08-09 13:12:53","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240724-LW-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-08-09 13:12:53.570393+08","is_chargeback":false,"cost_type":1,"collected":"1696500.00","invoiced":"1696500","approve_amount":"1187550","un_approve_amount":"508950.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":629,"key":629,"name":"\u5317\u4eac\u521b\u9a70\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":255,"key":255,"contract_id":3429,"name":"2024-08-08","value":"508950","overdue_days":""},{"id":256,"key":256,"contract_id":3429,"name":"2024-10-08","value":"1187550","overdue_days":3}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3706,"supplier_id":516,"contract_type":1,"signed_at":"2024-12-12","amount":"1235000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-12 14:00:06","updated_at":"2024-12-30 17:01:54","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241212-ZHY-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-20 09:25:50.774895+08","is_chargeback":false,"cost_type":1,"collected":"741000.00","invoiced":"741000","approve_amount":"741000","un_approve_amount":"494000.00","uncollected":"494000.00","uninvoiced":"494000.00","overdue":"494000.00","status":0,"sort_date":"2025-04-30","supplier":{"id":516,"key":516,"name":"\u5929\u6d25\u665f\u6e90\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":521,"key":521,"contract_id":3706,"name":"2024-12-20","value":"494000","overdue_days":0},{"id":522,"key":522,"contract_id":3706,"name":"2025-03-07","value":"247000","overdue_days":""},{"id":523,"key":523,"contract_id":3706,"name":"2025-03-28","value":"370500","overdue_days":""},{"id":524,"key":524,"contract_id":3706,"name":"2025-04-30","value":"123500","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f97\u5929","overdue_amount":494000,"remind_date":"2025-04-30"},{"id":3614,"supplier_id":557,"contract_type":1,"signed_at":"2024-10-21","amount":"2217032.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-21 16:29:11","updated_at":"2024-10-24 13:06:36","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241021-ZHY-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-21 16:30:10.674156+08","is_chargeback":false,"cost_type":1,"collected":"665109.60","invoiced":"1551922.4","approve_amount":"665109.60","un_approve_amount":"1551922.40","uncollected":"1551922.40","uninvoiced":"665109.60","overdue":"1551922.40","status":0,"sort_date":"2024-12-31","supplier":{"id":557,"key":557,"name":"\u5b89\u5168\u80fd\u529b\u751f\u6001\u805a\u5408\uff08\u5317\u4eac\uff09\u8fd0\u8425\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":408,"key":408,"contract_id":3614,"name":"2024-10-31","value":"665109.6","overdue_days":28},{"id":409,"key":409,"contract_id":3614,"name":"2024-11-30","value":"886812.8","overdue_days":""},{"id":410,"key":410,"contract_id":3614,"name":"2024-12-31","value":"665109.6","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f215\u5929","overdue_amount":1551922.4,"remind_date":"2024-12-31"},{"id":3723,"supplier_id":614,"contract_type":1,"signed_at":"2024-12-17","amount":"389392.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-25 10:25:07","updated_at":"2024-12-25 10:25:24","client_id":"","project_id":"","sales_rep":"","serial_no":"BQ-S-2024-12-07-P","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-25 10:25:24.613003+08","is_chargeback":false,"cost_type":1,"collected":"389392.00","invoiced":"389392","approve_amount":"389392","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":614,"key":614,"name":"\u4e0a\u6d77\u5e76\u64ce\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":530,"key":530,"contract_id":3723,"name":"2025-02-28","value":"389392","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3687,"supplier_id":68,"contract_type":1,"signed_at":"2024-12-03","amount":"377200.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-03 16:44:39","updated_at":"2025-01-21 09:21:54","client_id":"","project_id":"","sales_rep":"","serial_no":"BJ7067IM202401203-01","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-21 09:21:54.025513+08","is_chargeback":false,"cost_type":1,"collected":"377200.00","invoiced":"377200","approve_amount":"377200","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":68,"key":68,"name":"\u82f1\u8fc8\u7535\u5b50\u5546\u8d38(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":561,"key":561,"contract_id":3687,"name":"2025-02-10","value":"377200","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"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,"cost_type":1,"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":3704,"supplier_id":90,"contract_type":1,"signed_at":"2024-12-11","amount":"291807.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-12-11 14:48:33","updated_at":"2025-01-07 10:53:54","client_id":"","project_id":"","sales_rep":"","serial_no":"X_2024SBQ32972","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-01-06 15:04:10.946509+08","is_chargeback":false,"cost_type":1,"collected":"291807.00","invoiced":"291807","approve_amount":"291807","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":542,"key":542,"contract_id":3704,"name":"2025-03-04","value":"291807","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3599,"supplier_id":671,"contract_type":1,"signed_at":"2024-10-16","amount":"278000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-16 11:14:49","updated_at":"2024-12-09 11:13:23","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241016-HYF-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-12-03 10:30:22.763003+08","is_chargeback":false,"cost_type":1,"collected":"278000.00","invoiced":"278000","approve_amount":"278000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":671,"key":671,"name":"\u56db\u5ddd\u957f\u8679\u4f73\u534e\u6570\u5b57\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":488,"key":488,"contract_id":3599,"name":"2024-12-12","value":"278000","overdue_days":0}],"contract_type_display":"\u4ea7\u54c1\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,"cost_type":1,"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":3668,"supplier_id":662,"contract_type":1,"signed_at":"2024-11-19","amount":"192000.00","handler":5360,"description":"\u5382\u5546\u63d0\u4f9b\u4e0a\u95e8\u670d\u52a1","contract_scan":"","created_by":5360,"created_at":"2024-11-19 13:28:50","updated_at":"2024-12-11 15:09:59","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241115-LW-001","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-19 13:29:04.232771+08","is_chargeback":false,"cost_type":1,"collected":"192000.00","invoiced":"192000","approve_amount":"192000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":662,"key":662,"name":"\u5317\u4eac\u7f51\u5fa1\u661f\u4e91\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":470,"key":470,"contract_id":3668,"name":"2024-11-29","value":"192000","overdue_days":3}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":3566,"supplier_id":163,"contract_type":3,"signed_at":"2024-09-27","amount":"187297.50","handler":1011,"description":"\u5b9e\u9645\u6210\u672c\uff1a199301\uff0c\u5e2e\u9c81\u4e9a\u5a1f\u5904\u740612000\u8d39\u7528\uff0c\u6309\u716725%\u6263\u7a0e","contract_scan":"","created_by":1011,"created_at":"2024-09-27 09:37:42","updated_at":"2024-11-08 09:19:20","client_id":"","project_id":"","sales_rep":"","serial_no":"2024WSCN-L-020-C4061-PAN","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-11-08 09:19:20.484275+08","is_chargeback":false,"cost_type":1,"collected":"187297.50","invoiced":"187297.5","approve_amount":"187297.5","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":456,"key":456,"contract_id":3566,"name":"2024-11-26","value":"187297.5","overdue_days":0}],"contract_type_display":"\u670d\u52a1\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,"cost_type":1,"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":3554,"supplier_id":598,"contract_type":1,"signed_at":"2024-08-26","amount":"170000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-09-24 14:28:42","updated_at":"2024-09-25 10:52:44","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20240826-HYF-002","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-09-24 14:28:51.822279+08","is_chargeback":false,"cost_type":1,"collected":"170000.00","invoiced":"170000","approve_amount":"170000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":598,"key":598,"name":"\u5317\u4eac\u94f6\u65af\u6cf0\u7ecf\u8d38\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":343,"key":343,"contract_id":3554,"name":"2024-09-30","value":"170000","overdue_days":12}],"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,"cost_type":1,"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":3617,"supplier_id":511,"contract_type":1,"signed_at":"2024-10-22","amount":"164065.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2024-10-22 12:53:19","updated_at":"2024-12-17 14:40:09","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20241022-HYF-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2024-10-22 12:53:45.010155+08","is_chargeback":false,"cost_type":1,"collected":"164065.00","invoiced":"164065","approve_amount":"164065","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":415,"key":415,"contract_id":3617,"name":"2024-11-22","value":"164065","overdue_days":33}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""}],"count":{"amount":"268869828.67","collected":"210147043.93","approve_amount":"26559245.88","uncollected":"58722784.74","un_approve_amount":242310582.79},"pagenation":{"totalcount":1868,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 14:26:32') RETURNING "id"

[+] Explain