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

Performance Profiling

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

总计13条数据
TimeDurationCategoryInfo
  
17:22:55.83514.9 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 120
17:22:55.87611.9 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:55.8527.1 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:55.8655.8 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:55.8305.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 <= '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:55.8714.9 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:55.8594.8 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:55.8892.0 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":"7","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":1946,"id2":1946,"serial_no":"TSKJ-20210422-HYF-001","project_id":2530,"client_id":1098,"need_analysis":true,"bargain_date":"2021-04-22","collected":"2400","remind_date":"2021-04-25","amount":"2400.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"2400.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"2400","c_date":"2021-04-25","project":{"id":2530,"key":2530,"name":"\u89c6\u9891\u4e91\u670d\u52a1\u5317\u4eac\u529e\u516c\u5ba4\u7eed\u8d39","bargain_date":"2021-04-22","budget":"2400","collected":"2400"},"client":{"id":1098,"key":1098,"name":"\u4fe1\u4ea6\u5b8f\u8fbe\u7f51\u7edc\u5b58\u50a8\u6280\u672f(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0.00"},{"id":1934,"id2":1934,"serial_no":"POB-21032447","project_id":2508,"client_id":1933,"need_analysis":true,"bargain_date":"2021-04-06","collected":"10220","remind_date":"","amount":"10220","status":1,"uncollected":"0","overdue":"","invoiced":"10220.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-04-06","project":{"id":2508,"key":2508,"name":"\u5de5\u4f5c\u7ad9","bargain_date":"2021-04-06","budget":"10220","collected":"10220"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":""},{"id":1930,"id2":1930,"serial_no":"POT-21010008","project_id":2504,"client_id":146,"need_analysis":true,"bargain_date":"2021-04-01","collected":"12930","remind_date":"","amount":"12930","status":1,"uncollected":"0","overdue":"","invoiced":"12930.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-04-01","project":{"id":2504,"key":2504,"name":"hp288PC","bargain_date":"2021-04-01","budget":"12930","collected":"12930"},"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":""},{"id":1843,"id2":1843,"serial_no":"POB-20120175","project_id":2080,"client_id":1933,"need_analysis":true,"bargain_date":"2021-01-15","collected":"4310","remind_date":"2021-03-31","amount":"4310.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"4310.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-03-31","project":{"id":2080,"key":2080,"name":"HP 288pro G6","bargain_date":"2021-01-15","budget":"4310","collected":"4310"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0.00"},{"id":1842,"id2":1842,"serial_no":"POB-20120176","project_id":2079,"client_id":1933,"need_analysis":true,"bargain_date":"2021-01-15","collected":"10220","remind_date":"2021-03-31","amount":"10220.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"10220.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-03-31","project":{"id":2079,"key":2079,"name":"HP\u5de5\u4f5c\u7ad9","bargain_date":"2021-01-15","budget":"10220","collected":"10220"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0.00"},{"id":1872,"id2":1872,"serial_no":"POB-20121426","project_id":2422,"client_id":1933,"need_analysis":true,"bargain_date":"2021-03-01","collected":"8620","remind_date":"","amount":"8620","status":1,"uncollected":"0","overdue":"","invoiced":"8620.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-03-01","project":{"id":2422,"key":2422,"name":"HP 288Pro G6 2\u53f0","bargain_date":"2021-03-01","budget":"8620","collected":"8620"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":""},{"id":1756,"id2":1756,"serial_no":"POB-20110666","project_id":1983,"client_id":1933,"need_analysis":true,"bargain_date":"2020-11-16","collected":"5500","remind_date":"2021-02-15","amount":"5500.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"5500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-02-15","project":{"id":1983,"key":1983,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20202216","bargain_date":"2020-11-16","budget":"5500.00","collected":"5500"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0.00"},{"id":1734,"id2":1734,"serial_no":"\u8be6\u89c1pdf","project_id":1963,"client_id":146,"need_analysis":true,"bargain_date":"2020-11-02","collected":"31922.23","remind_date":"2021-01-29","amount":"31922.23","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"31922.23","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2021-01-29","project":{"id":1963,"key":1963,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20201102","bargain_date":"2020-11-02","budget":"31922.23","collected":"31922.23"},"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0.00"},{"id":1697,"id2":1697,"serial_no":"POB-20071346","project_id":1929,"client_id":1933,"need_analysis":true,"bargain_date":"2020-09-25","collected":"4396.37","remind_date":"2020-12-24","amount":"4396.37","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"4396.37","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2020-12-24","project":{"id":1929,"key":1929,"name":"\u529e\u516c\u8bbe\u5907\u65b0\u589e 20200929","bargain_date":"2020-09-25","budget":"4396.37","collected":"4396.37"},"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":"0.00"},{"id":1702,"id2":1702,"serial_no":"POT-20100001","project_id":1938,"client_id":146,"need_analysis":true,"bargain_date":"2020-10-14","collected":"1500","remind_date":"","amount":"1500","status":1,"uncollected":"0","overdue":"","invoiced":"1500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2020-10-14","project":{"id":1938,"key":1938,"name":"\u529e\u516c\u8bbe\u5907\u91c7\u8d2d 20201014","bargain_date":"2020-10-14","budget":"1500","collected":"1500"},"client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)"},"overdue_display":"","overdue_amount":""},{"id":1692,"id2":1692,"serial_no":"TSKJ20200917-HYF-006","project_id":1925,"client_id":1098,"need_analysis":true,"bargain_date":"2020-09-23","collected":"27200","remind_date":"","amount":"27200.00","status":1,"uncollected":"0","overdue":"","invoiced":"27200.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2020-09-23","project":{"id":1925,"key":1925,"name":"2020\u89c6\u9891\u4f1a\u8bae\u7cfb\u7edf\u7eed\u4fdd\u4e00\u5e74\u670d\u52a1","bargain_date":"2020-09-23","budget":"27200.00","collected":"27200"},"client":{"id":1098,"key":1098,"name":"\u4fe1\u4ea6\u5b8f\u8fbe\u7f51\u7edc\u5b58\u50a8\u6280\u672f(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":1558,"id2":1558,"serial_no":"TSKJ20200602-HYF-004","project_id":1791,"client_id":1661,"need_analysis":true,"bargain_date":"2020-06-03","collected":"514761","remind_date":"2020-08-11","amount":"514761.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"514761.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2020-08-11","project":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee","bargain_date":"2020-06-03","budget":"514761.00","collected":"514761"},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0.00"},{"id":1186,"id2":1186,"serial_no":"DX190911WLQ01 ","project_id":1111,"client_id":982,"need_analysis":true,"bargain_date":"2019-09-23","collected":"2486850","remind_date":"","amount":"2486850","status":1,"uncollected":"0","overdue":"","invoiced":"2486850.00","overdue_days":"","collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2019-09-23","project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf","bargain_date":"2019-09-23","budget":"2486850","collected":"2486850"},"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"overdue_display":"","overdue_amount":""},{"id":1177,"id2":1177,"serial_no":"TSKJ20190912-LRC-001","project_id":1460,"client_id":1098,"need_analysis":true,"bargain_date":"2019-09-12","collected":"32000","remind_date":"","amount":"32000","status":1,"uncollected":"0","overdue":"","invoiced":"32000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2019-09-12","project":{"id":1460,"key":1460,"name":"\u89c6\u9891\u4f1a\u8bae\u7cfb\u7edf\u65b0\u8d2d\u4e00\u5e74\u670d\u52a1\u9879\u76ee","bargain_date":"2019-09-12","budget":"32000","collected":"32000"},"client":{"id":1098,"key":1098,"name":"\u4fe1\u4ea6\u5b8f\u8fbe\u7f51\u7edc\u5b58\u50a8\u6280\u672f(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":1091,"id2":1091,"serial_no":"TSKJ-20190627-HYF-001","project_id":1240,"client_id":1032,"need_analysis":true,"bargain_date":"2019-06-27","collected":"147634","remind_date":"2019-08-06","amount":"147634.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"184542.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2019-08-06","project":{"id":1240,"key":1240,"name":"PA3250\u9632\u706b\u5899\u8bbe\u5907\u7eed\u4fdd","bargain_date":"2019-06-27","budget":"184542.00","collected":"184542"},"client":{"id":1032,"key":1032,"name":"\u5c71\u4e1c\u4e91\u521b\u4fe1\u606f\u7f51\u7edc\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0.00"},{"id":798,"id2":798,"serial_no":"TS-HYF-20181030001","project_id":986,"client_id":1178,"need_analysis":true,"bargain_date":"2018-10-25","collected":"40000","remind_date":"2019-07-13","amount":"40000.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"305000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2019-07-13","project":{"id":986,"key":986,"name":"VMware\u4ea7\u54c1,SVC-CR-10","bargain_date":"2018-10-25","budget":"305000","collected":"305000"},"client":{"id":1178,"key":1178,"name":"\u5317\u4eac\u5b87\u4fe1\u5b89\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0.00"},{"id":798,"id2":798,"serial_no":"TS-HYF-20181030001","project_id":986,"client_id":1178,"need_analysis":true,"bargain_date":"2018-10-25","collected":"20000","remind_date":"2019-04-30","amount":"20000.00","status":1,"uncollected":"0.00","overdue":"0.00","invoiced":"305000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2019-04-30","project":{"id":986,"key":986,"name":"VMware\u4ea7\u54c1,SVC-CR-10","bargain_date":"2018-10-25","budget":"305000","collected":"305000"},"client":{"id":1178,"key":1178,"name":"\u5317\u4eac\u5b87\u4fe1\u5b89\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0.00"},{"id":786,"id2":786,"serial_no":"\u65e0","project_id":983,"client_id":1175,"need_analysis":true,"bargain_date":"2018-10-24","collected":"307512","remind_date":"","amount":"307512","status":1,"uncollected":"0","overdue":"","invoiced":"307512.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2018-10-24","project":{"id":983,"key":983,"name":"Vmware \u865a\u62df\u5316\u9879\u76ee","bargain_date":"2018-10-24","budget":"307512","collected":"307512"},"client":{"id":1175,"key":1175,"name":"\u5317\u4eac\u82f1\u901a\u8d5b\u4e3a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":656,"id2":656,"serial_no":"TSC-X-2018081523","project_id":887,"client_id":1098,"need_analysis":true,"bargain_date":"2018-08-15","collected":"188000","remind_date":"","amount":"188000","status":1,"uncollected":"0","overdue":"","invoiced":"188000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2018-08-15","project":{"id":887,"key":887,"name":"\u89c6\u9891\u534f\u4f5c\u65b0\u8d2d\u9879\u76ee","bargain_date":"2018-08-15","budget":"188000","collected":"188000"},"client":{"id":1098,"key":1098,"name":"\u4fe1\u4ea6\u5b8f\u8fbe\u7f51\u7edc\u5b58\u50a8\u6280\u672f(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":655,"id2":655,"serial_no":"JAVM-20180814","project_id":884,"client_id":1094,"need_analysis":true,"bargain_date":"2018-08-14","collected":"36000","remind_date":"","amount":"36000","status":1,"uncollected":"0","overdue":"","invoiced":"36000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2018-08-14","project":{"id":884,"key":884,"name":"VMware \u865a\u62df\u5316\u9879\u76ee","bargain_date":"2018-08-14","budget":"36000","collected":"36000"},"client":{"id":1094,"key":1094,"name":"\u6c5f\u82cf\u84dd\u77aa\u7f9a\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""}],"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":7,"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:55', 66715904) RETURNING "id"
17:22:55.8240.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:22:55.8260.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:22:55.8510.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2530, 2508, 2504, 2080, 2079, 2422, 1983, 1963, 1929, 1938, 1925, 1791, 1111, 1460, 1240, 986, 983, 887, 884)
17:22:55.8240.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:22:55.8510.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (1098, 1933, 146, 1661, 982, 1032, 1178, 1175, 1094)