ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1ea0edcf02d: POST https://beta.jinchangxiao.com/vue/analysis/sales-payment-collection at 2026-06-02 05:22:53 pm by 221.216.117.119

Performance Profiling

Total processing time: 72 ms; Peak memory: 5.774 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
17:22:53.86115.1 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC LIMIT 20 OFFSET 60
17:22:53.90410.4 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"
17:22:53.8797.3 msyii\db\Command::querySELECT sum(invoiced) as invoiced FROM (SELECT id2, max(invoiced) as invoiced 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub" GROUP BY "id2") "sub"
17:22:53.8926.0 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') 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"
17:22:53.8565.3 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "c"
17:22:53.8985.1 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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"
17:22:53.8865.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 <= '2026-06-02'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 <= '2026-06-02' 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.wrote_date 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" <= '2026-06-02'))) 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, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."sales_rep"='1001') AND ("sc"."build_by_project"=TRUE) AND ("sgr"."group_id"='1') ORDER BY "c_date" DESC) "sub"
17:22:53.9151.3 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-payment-collection', '{"status":"","period":"","to":"","from":"","is_paid":"0","dataUserId":"1001","group":"1","page":"4","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":3502,"id2":3502,"serial_no":"W-KJ-CG-ZBL-20240902-01","project_id":3644,"client_id":2553,"need_analysis":true,"bargain_date":"2024-08-28","collected":"120000","remind_date":"2024-11-15","amount":"120000","status":1,"uncollected":"0","overdue":"0","invoiced":"120000.00","overdue_days":70,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"120000","c_date":"2024-11-15","project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-08-28","budget":"120000","collected":"120000"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f70\u5929","overdue_amount":"0"},{"id":3598,"id2":3598,"serial_no":"TSKJ20241015","project_id":3686,"client_id":3311,"need_analysis":true,"bargain_date":"2024-10-15","collected":"75760","remind_date":"2024-10-31","amount":"75760","status":1,"uncollected":"0","overdue":"0","invoiced":"75760.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-10-31","project":{"id":3686,"key":3686,"name":"\u7fa4\u6656\u5b58\u50a8DS923+\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-10-15","budget":"75760","collected":"75760"},"client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3470,"id2":3470,"serial_no":"HT02-202408140013","project_id":3623,"client_id":2150,"need_analysis":true,"bargain_date":"2024-08-19","collected":"33042","remind_date":"2024-09-30","amount":"33042","status":1,"uncollected":"0","overdue":"0","invoiced":"33042.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-09-30","project":{"id":3623,"key":3623,"name":"(\u8fc7\u5355)\u65b0\u8d2d1\u53f0PA440","bargain_date":"2024-08-19","budget":"33042","collected":"33042"},"client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"overdue_display":"","overdue_amount":"0"},{"id":3384,"id2":3384,"serial_no":"PO2400474-Rev0","project_id":3589,"client_id":3286,"need_analysis":true,"bargain_date":"2024-07-03","collected":"208444.26","remind_date":"2024-09-30","amount":"208444.26","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"208444.26","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-09-30","project":{"id":3589,"key":3589,"name":"PaloAlto PA1420\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-07-03","budget":"208444.26","collected":"208444.26"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0.00"},{"id":3348,"id2":3348,"serial_no":"2024SZCB-0795-220893","project_id":3568,"client_id":3009,"need_analysis":true,"bargain_date":"2024-06-13","collected":"949200","remind_date":"2024-09-28","amount":"949200","status":1,"uncollected":"0","overdue":"0","invoiced":"949200.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-09-28","project":{"id":3568,"key":3568,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-06-13","budget":"949200","collected":"949200"},"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3493,"id2":3493,"serial_no":"WG2024-406-OT1031","project_id":3633,"client_id":3296,"need_analysis":true,"bargain_date":"2024-08-19","collected":"5494736.8","remind_date":"2024-09-25","amount":"5494736.8","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"5494736.80","overdue_days":35,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"5494736.8","c_date":"2024-09-25","project":{"id":3633,"key":3633,"name":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edf\u8f6f\u4ef6\u9879\u76ee\uff08\u8fc7\u5355\uff09","bargain_date":"2024-08-19","budget":"5494736.8","collected":"5494736.8"},"client":{"id":3296,"key":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f35\u5929","overdue_amount":"0.0"},{"id":3364,"id2":3364,"serial_no":"TS-HYF-2024062501","project_id":3577,"client_id":3278,"need_analysis":true,"bargain_date":"2024-06-25","collected":"198354","remind_date":"2024-09-19","amount":"198354","status":1,"uncollected":"0","overdue":"0","invoiced":"198354.00","overdue_days":5,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"198354","c_date":"2024-09-19","project":{"id":3577,"key":3577,"name":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","bargain_date":"2024-06-25","budget":"198354","collected":"198354"},"client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f5\u5929","overdue_amount":"0"},{"id":3392,"id2":3392,"serial_no":"W-KJ-CG-ZBL-20240715-01","project_id":3591,"client_id":2553,"need_analysis":true,"bargain_date":"2024-07-09","collected":"19800","remind_date":"2024-08-22","amount":"19800","status":1,"uncollected":"0","overdue":"0","invoiced":"19800.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"19800","c_date":"2024-08-22","project":{"id":3591,"key":3591,"name":"\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-07-09","budget":"19800","collected":"19800"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":3250,"id2":3250,"serial_no":"TS-HYF-2024042601","project_id":3515,"client_id":2845,"need_analysis":true,"bargain_date":"2024-04-26","collected":"444004.12","remind_date":"2024-08-03","amount":"444004.12","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"444004.12","overdue_days":9,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"444004.12","c_date":"2024-08-03","project":{"id":3515,"key":3515,"name":"PA1410&PA1420\u4e00\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-04-26","budget":"444004.12","collected":"444004.12"},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f9\u5929","overdue_amount":"0.00"},{"id":3300,"id2":3300,"serial_no":"2024SZCB-0795-220873","project_id":3544,"client_id":3009,"need_analysis":true,"bargain_date":"2024-05-20","collected":"949200","remind_date":"2024-07-21","amount":"949200","status":1,"uncollected":"0","overdue":"0","invoiced":"949200.00","overdue_days":45,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"949200","c_date":"2024-07-21","project":{"id":3544,"key":3544,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u9879\u76ee","bargain_date":"2024-05-20","budget":"949200","collected":"949200"},"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f45\u5929","overdue_amount":"0"},{"id":3249,"id2":3249,"serial_no":"TS-HYF-20240424006","project_id":3514,"client_id":2836,"need_analysis":true,"bargain_date":"2024-04-25","collected":"836310.6","remind_date":"2024-07-19","amount":"836310.6","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"836310.60","overdue_days":3,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"836310.6","c_date":"2024-07-19","project":{"id":3514,"key":3514,"name":"4\u53f0PA1410\u9632\u706b\u58993\u5e74\u670d\u52a1\u53cc\u7535 \u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-04-25","budget":"836310.6","collected":"836310.6"},"client":{"id":2836,"key":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f3\u5929","overdue_amount":"0.0"},{"id":3415,"id2":3415,"serial_no":"TSC-LRC-2024071601","project_id":3599,"client_id":2545,"need_analysis":true,"bargain_date":"2024-07-16","collected":"38000","remind_date":"","amount":"38000","status":1,"uncollected":"0","overdue":"","invoiced":"38000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-07-16","project":{"id":3599,"key":3599,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u4e8c","bargain_date":"2024-07-16","budget":"38000","collected":"38000"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":3235,"id2":3235,"serial_no":"TS-HYF-2024041502","project_id":3503,"client_id":2836,"need_analysis":true,"bargain_date":"2024-04-17","collected":"375748","remind_date":"2024-07-12","amount":"375748","status":1,"uncollected":"0","overdue":"0","invoiced":"375748.00","overdue_days":3,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"375748","c_date":"2024-07-12","project":{"id":3503,"key":3503,"name":"PA1420\u9632\u706b\u58993\u5e74\u670d\u52a1\u9879\u76ee","bargain_date":"2024-04-17","budget":"375748","collected":"375748"},"client":{"id":2836,"key":2836,"name":"\u5317\u4eac\u4e2d\u8bda\u7f51\u5b89\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"\u903e\u671f3\u5929","overdue_amount":"0"},{"id":3388,"id2":3388,"serial_no":"TSC-LRC-2024070501","project_id":3590,"client_id":2545,"need_analysis":true,"bargain_date":"2024-07-05","collected":"42600","remind_date":"2024-07-10","amount":"42600","status":1,"uncollected":"0","overdue":"0","invoiced":"42600.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-07-10","project":{"id":3590,"key":3590,"name":"\u8054\u60f3\u670d\u52a1\u5668\u4e0a\u7528\u4e07\u5146\u7f51\u53612\u5757\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-07-05","budget":"42600","collected":"42600"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3363,"id2":3363,"serial_no":"TSC-LRC-2024062501","project_id":3576,"client_id":2545,"need_analysis":true,"bargain_date":"2024-06-25","collected":"38000","remind_date":"2024-07-05","amount":"38000","status":1,"uncollected":"0","overdue":"0","invoiced":"38000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-07-05","project":{"id":3576,"key":3576,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-06-25","budget":"38000","collected":"38000"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3247,"id2":3247,"serial_no":"PO#8001874","project_id":3513,"client_id":2838,"need_analysis":true,"bargain_date":"2024-04-24","collected":"39554.52","remind_date":"2024-07-02","amount":"39554.52","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"39554.52","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-07-02","project":{"id":3513,"key":3513,"name":"pa-450 5\u5e74\u670d\u52a1\u4e00\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-04-24","budget":"39554.52","collected":"39554.52"},"client":{"id":2838,"key":2838,"name":"\u8d5b\u514b\u8c31\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"overdue_display":"","overdue_amount":"0.00"},{"id":3327,"id2":3327,"serial_no":"TSC-LRC-2024053101","project_id":3552,"client_id":2545,"need_analysis":true,"bargain_date":"2024-06-03","collected":"31883","remind_date":"2024-06-28","amount":"31883","status":1,"uncollected":"0","overdue":"0","invoiced":"63766.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-06-28","project":{"id":3552,"key":3552,"name":"\u6df1\u4fe1\u670dAF1000\u9632\u706b\u5899\u548c\u9510\u6377\u7f51\u7edc\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-06-03","budget":"63766","collected":"63766"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":3327,"id2":3327,"serial_no":"TSC-LRC-2024053101","project_id":3552,"client_id":2545,"need_analysis":true,"bargain_date":"2024-06-03","collected":"31883","remind_date":"2024-06-07","amount":"31883","status":1,"uncollected":"0","overdue":"0","invoiced":"63766.00","overdue_days":0,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"31883","c_date":"2024-06-07","project":{"id":3552,"key":3552,"name":"\u6df1\u4fe1\u670dAF1000\u9632\u706b\u5899\u548c\u9510\u6377\u7f51\u7edc\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-06-03","budget":"63766","collected":"63766"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":3232,"id2":3232,"serial_no":"SMC\u5317\u4eac\u8ba2\u5355TS-SQY-2024032801","project_id":3467,"client_id":1933,"need_analysis":true,"bargain_date":"2024-04-16","collected":"60000","remind_date":"2024-05-20","amount":"60000","status":1,"uncollected":"0","overdue":"0","invoiced":"60000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-05-20","project":{"id":3467,"key":3467,"name":"\u5b58\u50a8\u6570\u636e\u6062\u590d\u6280\u672f\u670d\u52a11\u6b21-2024-K","bargain_date":"2024-04-16","budget":"60000","collected":"60000"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0"},{"id":3151,"id2":3151,"serial_no":"HT02-202402290021","project_id":3458,"client_id":2150,"need_analysis":true,"bargain_date":"2024-03-07","collected":"33042","remind_date":"2024-04-30","amount":"33042","status":1,"uncollected":"0","overdue":"0","invoiced":"34115.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-04-30","project":{"id":3458,"key":3458,"name":"\uff08\u8fc7\u5355\uff09\u65b0\u8d2dPA440\u9632\u706b\u5899-C","bargain_date":"2024-03-07","budget":"34115","collected":"34115"},"client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"overdue_display":"","overdue_amount":"0"}],"count":{"amount":"53255613.23","uncollected":"15394519.06","overdue":"2104201.00","invoiced":"39981308.45","chargeback_amount":"2621953"},"count_days":{"amount":"53255613.23","collected":"40483047.17","uncollected":"15394519.06","overdue":"2104201.00","invoiced":"39981308.45"},"count_pay":{"collected":"40483047.17","client_count":58,"collected_count":"190","overdue":"18991935.81","invoiced":"39981308.45"},"pagenation":{"totalcount":145,"thispage":4,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 17:22:53', 67001088) RETURNING "id"
17:22:53.8770.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2553, 3311, 2150, 3286, 3009, 3296, 3278, 2845, 2836, 2545, 2838, 1933)
17:22:53.8500.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:22:53.8520.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:22:53.8770.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3644, 3686, 3623, 3589, 3568, 3633, 3577, 3591, 3515, 3544, 3514, 3599, 3503, 3590, 3576, 3513, 3552, 3467, 3458)
17:22:53.8500.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta