ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6949fd7d18334: POST https://beta.jinchangxiao.com/vue/analysis/sales-payment-collection at 2025-12-23 10:25:01 am by 223.72.15.12

Performance Profiling

Total processing time: 152 ms; Peak memory: 5.772 MB. Show Profiling Timeline

总计15条数据
TimeDurationCategoryInfo
  
10:25:01.13737.6 msyii\db\Command::querySELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC LIMIT 20 OFFSET 20
10:25:01.21422.8 msyii\db\Command::querySELECT sum(collected) as collected, count(distinct client_id) as client_count, sum(collected_count) as collected_count, sum(overdue_collect_amount) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"
10:25:01.12016.2 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "c"
10:25:01.17714.0 msyii\db\Command::querySELECT sum(case when sub.need_analysis = true THEN amount ELSE 0 END) as amount, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"
10:25:01.20112.4 msyii\db\Command::querySELECT sum(case when need_analysis = true THEN amount ELSE 0 END) as amount, sum(collected) as collected, sum(uncollected) as uncollected, sum(overdue) as overdue FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sub"
10:25:01.1928.5 msyii\db\Command::querySELECT sum(collected) as collected FROM (SELECT coalesce(scp.collected, 0) as collected FROM (SELECT (sc.id::varchar || ( CASE WHEN scpcrds.id is not null THEN scpcrds.id::varchar ELSE ''::varchar END)) as id, sc.id as id2, sc.serial_no, sc.project_id, sc.client_id, sc.need_analysis, p.bargain_date, CASE WHEN scpcrds.id is not null THEN scpcrds.paid_amount ELSE sc.erp_settle_amount END as collected, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE null END as remind_date, CASE WHEN scpcrds.id is not null THEN scpcrds.amount ELSE sc.amount END as amount, CASE WHEN scpcrds.id is not null THEN scpcrds.status ELSE (CASE WHEN sc.erp_un_settle_amount != 0 THEN 0 ELSE 1 END) END as status, CASE WHEN scpcrds.id is not null THEN scpcrds.amount - scpcrds.paid_amount ELSE (CASE WHEN sc.need_analysis = true THEN sc.erp_un_settle_amount ELSE 0 END) END as uncollected, CASE WHEN scpcrds.id is not null AND scpcrds.remind_date <= '2025-12-23'THEN scpcrds.amount - scpcrds.paid_amount ELSE null END as overdue, sci.invoiced, scpcrds.overdue_days, tcollect.collected_count as collected_count, (sc.amount - sci.invoiced) as uninvoiced, CASE WHEN scpcrds.id is not null THEN (CASE WHEN (scpcrds.remind_date <= '2025-12-23' AND scpcrds.status = 0) OR scpcrds.overdue_days is not null THEN scpcrds.paid_amount ELSE null END) ELSE ovsub.amount END as overdue_collect_amount, CASE WHEN scpcrds.id is not null THEN scpcrds.remind_date ELSE sc.signed_at END as c_date FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN (SELECT t0.* FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) GROUP BY "t0"."id") "scpcrds" ON scpcrds.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "tcollect" ON tcollect.contract_id = sc.id LEFT JOIN (SELECT t1.id, sum(t0.paid_amount) as amount FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "t1" ON t0.contract_id = t1.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON t1.from_project = p.id WHERE (t1.need_analysis = true) AND (t1.from_project is not null) AND (p.project_status = 3) AND (((t0.status = 1) AND (t0.overdue_days is not null)) OR ((t0.status = 0) AND ("t0"."remind_date" <= '2025-12-23'))) GROUP BY "t1"."id") "ovsub" ON ovsub.id = sc.id WHERE (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("sc"."build_by_project"=TRUE) AND (((scpcrds.id is not null) AND (scpcrds.paid_amount != 0)) OR ((scpcrds.id is null) AND (sc.erp_settle_amount > 0))) ORDER BY "c_date" DESC) "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_sales_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id2 WHERE "sc"."need_analysis"=FALSE GROUP BY "sc"."id2", "scp"."collected") "sub"
10:25:01.2395.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-23')
10:25:01.1033.1 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:25:01.1012.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:25:01.1102.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:25:01.2471.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-payment-collection', '{"status":"","collect_period":"","collect_to":"","collect_from":"","is_paid":"1","dataUserId":"","group":"","page":"2","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":4130,"id2":4130,"serial_no":"TS-WZW-20250826006","project_id":3945,"client_id":1301,"need_analysis":true,"bargain_date":"2025-08-26","collected":"69850.2","remind_date":"2025-10-31","amount":"69850.2","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"99786.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-31","project":{"id":3945,"key":3945,"name":"\u65b0\u8d2d\u5b89\u5168\u8bbe\u5907","bargain_date":"2025-08-26","budget":"99786","collected":"99786"},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"overdue_display":"","overdue_amount":"0.0"},{"id":4146,"id2":4146,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25091709","project_id":3961,"client_id":12,"need_analysis":true,"bargain_date":"2025-09-05","collected":"598","remind_date":"2025-10-18","amount":"598","status":1,"uncollected":"0","overdue":"0","invoiced":"598.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-18","project":{"id":3961,"key":3961,"name":"POTJ25091709-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-09-05","budget":"598","collected":"598"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4156,"id2":4156,"serial_no":"SMC\u5929\u6d25POTJ25093735","project_id":3966,"client_id":12,"need_analysis":true,"bargain_date":"2025-09-11","collected":"299","remind_date":"2025-10-17","amount":"299","status":1,"uncollected":"0","overdue":"0","invoiced":"299.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-17","project":{"id":3966,"key":3966,"name":"POTJ25093735-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-09-11","budget":"299","collected":"299"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4152,"id2":4152,"serial_no":"TS-SQY-2025082001","project_id":3942,"client_id":497,"need_analysis":true,"bargain_date":"2025-09-05","collected":"49500","remind_date":"2025-10-17","amount":"49500","status":1,"uncollected":"0","overdue":"0","invoiced":"49500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-17","project":{"id":3942,"key":3942,"name":"\u865a\u62df\u5316\u8fd0\u7ef4-2025","bargain_date":"2025-09-05","budget":"49500","collected":"49500"},"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4153,"id2":4153,"serial_no":"TS-SQY-2025081501","project_id":3943,"client_id":497,"need_analysis":true,"bargain_date":"2025-09-05","collected":"67119","remind_date":"2025-10-17","amount":"67119","status":1,"uncollected":"0","overdue":"0","invoiced":"67119.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-17","project":{"id":3943,"key":3943,"name":"PA\u7eed\u4fdd-K-2025","bargain_date":"2025-09-05","budget":"67119","collected":"67119"},"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4157,"id2":4157,"serial_no":"SMC\u6295\u8d44\u7ba1\u7406POIM25094141","project_id":3965,"client_id":12,"need_analysis":true,"bargain_date":"2025-09-11","collected":"299","remind_date":"2025-10-17","amount":"299","status":1,"uncollected":"0","overdue":"0","invoiced":"299.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-10-17","project":{"id":3965,"key":3965,"name":"POIM25094141-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-09-11","budget":"299","collected":"299"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4112,"id2":4112,"serial_no":"PO2500925\/PO2500926","project_id":3927,"client_id":3286,"need_analysis":true,"bargain_date":"2025-08-22","collected":"42448","remind_date":"2025-10-09","amount":"42448","status":1,"uncollected":"0","overdue":"0","invoiced":"42448.00","overdue_days":4,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"42448","c_date":"2025-10-09","project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-22","budget":"42448","collected":"42448"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f4\u5929","overdue_amount":"0"},{"id":4105,"id2":4105,"serial_no":"TS-ZHY-20250408001","project_id":3931,"client_id":3384,"need_analysis":true,"bargain_date":"2025-08-05","collected":"300000","remind_date":"2025-09-30","amount":"300000","status":1,"uncollected":"0","overdue":"0","invoiced":"300000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3931,"key":3931,"name":"\u6df1\u4fe1\u670d\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u9879\u76ee","bargain_date":"2025-08-05","budget":"300000","collected":"300000"},"client":{"id":3384,"key":3384,"name":"\u5e7f\u5dde\u7eb3\u667a\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":4111,"id2":4111,"serial_no":"2025-08-21-002","project_id":3947,"client_id":304,"need_analysis":true,"bargain_date":"2025-08-21","collected":"7300","remind_date":"2025-09-30","amount":"7300","status":1,"uncollected":"0","overdue":"0","invoiced":"7300.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3947,"key":3947,"name":"\u91c7\u8d2dAdobe\u8f6f\u4ef6","bargain_date":"2025-08-21","budget":"7300","collected":"7300"},"client":{"id":304,"key":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4016,"id2":4016,"serial_no":"2025\/BJ262\/BJBJ2025-1191","project_id":3874,"client_id":3377,"need_analysis":true,"bargain_date":"2025-06-27","collected":"228000","remind_date":"2025-09-30","amount":"228000","status":1,"uncollected":"0","overdue":"0","invoiced":"228000.00","overdue_days":"","collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3874,"key":3874,"name":"ZStack\u4e91\u4ea7\u54c1\uff08\u7518\u674e\u836f\u4e1a\uff09\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-06-27","budget":"228000","collected":"228000"},"client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":4035,"id2":4035,"serial_no":"TS-YJC-20250904-01","project_id":3841,"client_id":3343,"need_analysis":true,"bargain_date":"2025-07-12","collected":"183000","remind_date":"2025-09-30","amount":"183000","status":1,"uncollected":"0","overdue":"0","invoiced":"183000.00","overdue_days":41,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"183000","c_date":"2025-09-30","project":{"id":3841,"key":3841,"name":"2025PA\u9632\u706b\u5899\u66ff\u6362","bargain_date":"2025-07-12","budget":"183000","collected":"183000"},"client":{"id":3343,"key":3343,"name":"\u5317\u4eac\u5317\u6c7d\u79d1\u6280\u670d\u52a1\u6709\u9650\u516c\u53f8(\u4e2d\u90fd\u4e09\u4ea7\uff09"},"overdue_display":"\u903e\u671f41\u5929","overdue_amount":"0"},{"id":4086,"id2":4086,"serial_no":"TS-WZW-2025080401","project_id":3936,"client_id":2032,"need_analysis":true,"bargain_date":"2025-08-11","collected":"11779","remind_date":"2025-09-30","amount":"11779","status":1,"uncollected":"0","overdue":"0","invoiced":"11779.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3936,"key":3936,"name":"2025\u5e74\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u8bbe\u5907\u7eed\u4fdd","bargain_date":"2025-08-11","budget":"11779","collected":"11779"},"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"overdue_display":"","overdue_amount":"0"},{"id":4120,"id2":4120,"serial_no":"SMC\u4e2d\u56fd\u8ba2\u5355POCN25085613","project_id":3953,"client_id":12,"need_analysis":true,"bargain_date":"2025-08-22","collected":"4942","remind_date":"2025-09-30","amount":"4942","status":1,"uncollected":"0","overdue":"0","invoiced":"4942.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3953,"key":3953,"name":"POCN25085613-8\u53e3POE\u4ea4\u6362\u673a","bargain_date":"2025-08-22","budget":"4942","collected":"4942"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3916,"id2":3916,"serial_no":"TS-LRC-20250514002","project_id":3857,"client_id":3364,"need_analysis":true,"bargain_date":"2025-05-19","collected":"570000","remind_date":"2025-09-30","amount":"570000","status":1,"uncollected":"0","overdue":"0","invoiced":"570000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","bargain_date":"2025-05-19","budget":"570000","collected":"570000"},"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":4168,"id2":4168,"serial_no":"TS-YJC-20250917-01","project_id":3969,"client_id":48,"need_analysis":true,"bargain_date":"2025-09-17","collected":"2000","remind_date":"2025-09-30","amount":"2000","status":1,"uncollected":"0","overdue":"0","invoiced":"2000.00","overdue_days":13,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"2000","c_date":"2025-09-30","project":{"id":3969,"key":3969,"name":"\u5b58\u50a8\u786c\u76d8\u914d\u4ef6","bargain_date":"2025-09-17","budget":"2000","collected":"2000"},"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f13\u5929","overdue_amount":"0"},{"id":3886,"id2":3886,"serial_no":"TS-WZW-20250422001","project_id":3822,"client_id":1301,"need_analysis":true,"bargain_date":"2025-04-28","collected":"19200","remind_date":"2025-09-30","amount":"19200","status":1,"uncollected":"0","overdue":"0","invoiced":"33600.00","overdue_days":"","collected_count":2,"uninvoiced":"14400.00","overdue_collect_amount":"","c_date":"2025-09-30","project":{"id":3822,"key":3822,"name":"2025\u7f51\u7edc\u6280\u672f\u670d\u52a1","bargain_date":"2025-04-28","budget":"48000","collected":"33600"},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"overdue_display":"","overdue_amount":"0"},{"id":4071,"id2":4071,"serial_no":"JACG20250006","project_id":3934,"client_id":3387,"need_analysis":true,"bargain_date":"2025-07-28","collected":"57316","remind_date":"2025-09-28","amount":"57316","status":1,"uncollected":"0","overdue":"0","invoiced":"91705.60","overdue_days":15,"collected_count":1,"uninvoiced":"22926.40","overdue_collect_amount":"57316","c_date":"2025-09-28","project":{"id":3934,"key":3934,"name":"\u6d77\u6dc0\u8fdb\u4fee\u5b66\u6821\u5b89\u5168\u7eed\u4fdd\u9879\u76ee-2025\u5e74","bargain_date":"2025-07-28","budget":"114632","collected":"57316"},"client":{"id":3387,"key":3387,"name":"\u5317\u4eac\u4e45\u5b89\u667a\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f15\u5929","overdue_amount":"0"},{"id":4147,"id2":4147,"serial_no":"TSJ-2025082701-SQY","project_id":3888,"client_id":3370,"need_analysis":true,"bargain_date":"2025-08-27","collected":"107850","remind_date":"2025-09-27","amount":"107850","status":1,"uncollected":"0","overdue":"0","invoiced":"100107.00","overdue_days":30,"collected_count":2,"uninvoiced":"115593.00","overdue_collect_amount":"107850","c_date":"2025-09-27","project":{"id":3888,"key":3888,"name":"\u8054\u60f3\u670d\u52a1\u5668\u65b0\u8d2d-K-2025","bargain_date":"2025-08-27","budget":"215700","collected":"107850"},"client":{"id":3370,"key":3370,"name":"\u77e5\u884c\u89c2\u590d\uff08\u6210\u90fd\uff09\u6587\u5316\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f30\u5929","overdue_amount":"0"},{"id":4094,"id2":4094,"serial_no":"PO-2025-08-0002","project_id":3849,"client_id":2182,"need_analysis":true,"bargain_date":"2025-08-15","collected":"17500","remind_date":"2025-09-26","amount":"17500","status":1,"uncollected":"0","overdue":"0","invoiced":"17500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-26","project":{"id":3849,"key":3849,"name":"PA440\u7ef4\u4fdd-K-2025","bargain_date":"2025-08-15","budget":"17500","collected":"17500"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":4129,"id2":4129,"serial_no":"TS-SQY-2025082701","project_id":3956,"client_id":2182,"need_analysis":true,"bargain_date":"2025-08-26","collected":"1360","remind_date":"2025-09-26","amount":"1360","status":1,"uncollected":"0","overdue":"0","invoiced":"1360.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2025-09-26","project":{"id":3956,"key":3956,"name":"\u534e\u4e09\u9762\u677fAP\u65b0\u8d2d-2025","bargain_date":"2025-08-26","budget":"1360","collected":"1360"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"}],"count":{"amount":"327241543.80","uncollected":"384048.04","overdue":"357488.76","chargeback_amount":""},"count_days":{"amount":"327241543.80","collected":"326857495.76","uncollected":"384048.04","overdue":"357488.76"},"count_pay":{"collected":"326857495.76","client_count":356,"collected_count":"2474","overdue":"87899485.41"},"pagenation":{"totalcount":1745,"thispage":2,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.12","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-23 10:25:01') RETURNING "id"
10:25:01.2451.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=106, "last_visit_at"='now()' WHERE "id"=59629
10:25:01.1750.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3945, 3961, 3966, 3942, 3943, 3965, 3927, 3931, 3947, 3874, 3841, 3936, 3953, 3857, 3969, 3822, 3934, 3888, 3849, 3956)
10:25:01.1070.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:25:01.1760.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1301, 12, 497, 3286, 3384, 304, 3377, 3343, 2032, 3364, 48, 3387, 3370, 2182)