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

Log Messages

总计40条数据
TimeLevelCategoryMessage
 
17:22:54.541traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:22:54.541traceyii\base\Module::getModuleLoading module: debug
17:22:54.542traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:22:54.542traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:22:54.542traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:22:54.542traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.542infotime tracing start1780392174542632960
17:22:54.542traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:22:54.542traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-payment-collection'
17:22:54.542traceyii\base\Module::getModuleLoading module: vue
17:22:54.543infoyii\web\Session::openSession started
17:22:54.544infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:22:54.544infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:22:54.548traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.549traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:22:54.549traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.549traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:22:54.549infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:22:54.551traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-payment-collection
17:22:54.551traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.552traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:22:54.553traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesPaymentCollection()
17:22:54.553traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.554traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.555infoyii\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:54.564infoyii\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 80
17:22:54.580traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.580traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:22:54.580infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3441, 3424, 3371, 3372, 3269, 3216, 3251, 3318, 3235, 3265, 3281, 3274, 3263, 3195, 3157, 3300, 3246)
17:22:54.581infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2798, 2553, 2719, 2718, 2150, 1933, 2593, 2582, 2545, 2536, 2520, 2511, 2551)
17:22:54.581infoyii\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:54.589infoyii\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:54.594infoyii\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:54.601infoyii\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:54.606infoyii\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:54.616traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.617traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:22:54.617infoyii\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":"5","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":3112,"id2":3112,"serial_no":"TS-HYF-2024012301","project_id":3441,"client_id":2798,"need_analysis":true,"bargain_date":"2024-01-25","collected":"13704","remind_date":"2024-03-20","amount":"13704","status":1,"uncollected":"0","overdue":"0","invoiced":"13704.00","overdue_days":0,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"13704","c_date":"2024-03-20","project":{"id":3441,"key":3441,"name":"PA440\u65b0\u8d2d\u9879\u76ee","bargain_date":"2024-01-25","budget":"13704","collected":"13704"},"client":{"id":2798,"key":2798,"name":"\u5317\u4eac\u827e\u4e00\u82f1\u5b5a\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f0\u5929","overdue_amount":"0"},{"id":3101,"id2":3101,"serial_no":"W-KJ-CG-ZBL-20240119-01","project_id":3424,"client_id":2553,"need_analysis":true,"bargain_date":"2024-01-31","collected":"120431","remind_date":"2024-02-29","amount":"120431","status":1,"uncollected":"0","overdue":"0","invoiced":"120431.00","overdue_days":11,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"120431","c_date":"2024-02-29","project":{"id":3424,"key":3424,"name":"\u4e2d\u56fd\u7535\u5efa\u5c71\u4e1c\u7535\u5efa\u4e09\u516c\u53f8\u9890\u6770\u9e3f\u5229\u516c\u53f8\u6c99\u7279\u6731\u62dc\u52d2\u4e09A\u9879\u76ee\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee","bargain_date":"2024-01-31","budget":"120431","collected":"120431"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f11\u5929","overdue_amount":"0"},{"id":2963,"id2":2963,"serial_no":"TS-HYF-20231124011","project_id":3371,"client_id":2719,"need_analysis":true,"bargain_date":"2023-11-24","collected":"229272","remind_date":"2024-02-10","amount":"229272","status":1,"uncollected":"0","overdue":"0","invoiced":"229272.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-02-10","project":{"id":3371,"key":3371,"name":"\u6708\u521d\u79d1\u6280PAN-M-200\uff08\u8fc7\u5355\uff09","bargain_date":"2023-11-24","budget":"229272","collected":"229272"},"client":{"id":2719,"key":2719,"name":"\u91d1\u9510\u540c\u521b\uff08\u5317\u4eac\uff09\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"overdue_display":"","overdue_amount":"0"},{"id":2981,"id2":2981,"serial_no":"TS-HYF-2023112401","project_id":3372,"client_id":2718,"need_analysis":true,"bargain_date":"2023-11-27","collected":"160480","remind_date":"2024-01-19","amount":"160480","status":1,"uncollected":"0","overdue":"0","invoiced":"160480.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2024-01-19","project":{"id":3372,"key":3372,"name":"Software NGFW\u7eed\u4fdd\u670d\u52a1\u91c7\u8d2d\u9879\u76ee\uff08\u8fc7\u5355\uff09","bargain_date":"2023-11-27","budget":"160480","collected":"160480"},"client":{"id":2718,"key":2718,"name":"\u4e0a\u6d77\u745e\u6280\u8ba1\u7b97\u673a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"overdue_display":"","overdue_amount":"0"},{"id":2777,"id2":2777,"serial_no":"TS-WZW-2023072505","project_id":3269,"client_id":2150,"need_analysis":true,"bargain_date":"2023-10-27","collected":"105602","remind_date":"2023-12-31","amount":"105602","status":1,"uncollected":"0","overdue":"0","invoiced":"105602.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-12-31","project":{"id":3269,"key":3269,"name":"\uff08\u8fc7\u5355\uff09PA460\u65b0\u8d2d-C-2","bargain_date":"2023-10-27","budget":"105602","collected":"105602"},"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":2865,"id2":2865,"serial_no":"TS-SQY-2023090401","project_id":3216,"client_id":1933,"need_analysis":true,"bargain_date":"2023-10-07","collected":"30190","remind_date":"2023-12-31","amount":"30190","status":1,"uncollected":"0","overdue":"0","invoiced":"30190.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-12-31","project":{"id":3216,"key":3216,"name":"\u601d\u79d1\u7ef4\u4fdd1\u5e74-2023-K","bargain_date":"2023-10-07","budget":"30190","collected":"30190"},"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":2742,"id2":2742,"serial_no":"TSKJ20230707-006","project_id":3251,"client_id":2553,"need_analysis":true,"bargain_date":"2023-08-08","collected":"38846.2","remind_date":"2023-10-31","amount":"38846.2","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"388462.00","overdue_days":28,"collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"38846.2","c_date":"2023-10-31","project":{"id":3251,"key":3251,"name":"\u6c99\u7279\u7ea2\u6d77\u516c\u7528\u4e8b\u4e1a\u57fa\u7840\u8bbe\u65bd\u9879\u76ee\u7f51\u7edc\u5b89\u5168\u7cfb\u7edfPA\u8bbe\u5907","bargain_date":"2023-08-08","budget":"388462","collected":"388462"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f28\u5929","overdue_amount":"0.0"},{"id":2878,"id2":2878,"serial_no":"Z2023331","project_id":3318,"client_id":2593,"need_analysis":true,"bargain_date":"2023-10-13","collected":"49500","remind_date":"2023-10-31","amount":"49500","status":1,"uncollected":"0","overdue":"0","invoiced":"49500.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-10-31","project":{"id":3318,"key":3318,"name":"23\u5e74-24\u5e74zstack\u539f\u5382\u7ef4\u4fdd","bargain_date":"2023-10-13","budget":"49500","collected":"49500"},"client":{"id":2593,"key":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"overdue_display":"","overdue_amount":"0"},{"id":2739,"id2":2739,"serial_no":"TS-WZW-2023062701","project_id":3235,"client_id":2150,"need_analysis":true,"bargain_date":"2023-07-07","collected":"211204","remind_date":"2023-10-07","amount":"211204","status":1,"uncollected":"0","overdue":"0","invoiced":"211204.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-10-07","project":{"id":3235,"key":3235,"name":"\uff08\u8fc7\u5355\uff09PA460\u65b0\u8d2d-C","bargain_date":"2023-07-07","budget":"211204","collected":"211204"},"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":2765,"id2":2765,"serial_no":"HT02-202307260010","project_id":3265,"client_id":2150,"need_analysis":true,"bargain_date":"2023-07-28","collected":"166703","remind_date":"2023-09-30","amount":"166703","status":1,"uncollected":"0","overdue":"0","invoiced":"166703.00","overdue_days":18,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"166703","c_date":"2023-09-30","project":{"id":3265,"key":3265,"name":"\uff08\u8fc7\u5355\uff09PA5220\u7eed\u4fdd-C","bargain_date":"2023-07-28","budget":"166703","collected":"166703"},"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":"\u903e\u671f18\u5929","overdue_amount":"0"},{"id":2812,"id2":2812,"serial_no":"TSC-HYF-20230810","project_id":3281,"client_id":2582,"need_analysis":true,"bargain_date":"2023-08-22","collected":"153650","remind_date":"2023-09-29","amount":"153650","status":1,"uncollected":"0","overdue":"0","invoiced":"219500.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-09-29","project":{"id":3281,"key":3281,"name":"\u7f51\u7edc\u5b89\u5168\u8bbe\u5907\u53ca\u6c47\u805a\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","bargain_date":"2023-08-22","budget":"219500","collected":"219500"},"client":{"id":2582,"key":2582,"name":"\u4e2d\u56fd\u80fd\u6e90\u4f20\u5a92\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":2776,"id2":2776,"serial_no":"POB-23071421","project_id":3274,"client_id":1933,"need_analysis":true,"bargain_date":"2023-07-24","collected":"8800","remind_date":"2023-09-15","amount":"8800","status":1,"uncollected":"0","overdue":"0","invoiced":"8800.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-09-15","project":{"id":3274,"key":3274,"name":"\u786c\u76d8\u65b0\u8d2d4\u5757-2023-G","bargain_date":"2023-07-24","budget":"8800","collected":"8800"},"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":2812,"id2":2812,"serial_no":"TSC-HYF-20230810","project_id":3281,"client_id":2582,"need_analysis":true,"bargain_date":"2023-08-22","collected":"65850","remind_date":"2023-09-08","amount":"65850","status":1,"uncollected":"0","overdue":"0","invoiced":"219500.00","overdue_days":5,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"65850","c_date":"2023-09-08","project":{"id":3281,"key":3281,"name":"\u7f51\u7edc\u5b89\u5168\u8bbe\u5907\u53ca\u6c47\u805a\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","bargain_date":"2023-08-22","budget":"219500","collected":"219500"},"client":{"id":2582,"key":2582,"name":"\u4e2d\u56fd\u80fd\u6e90\u4f20\u5a92\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f5\u5929","overdue_amount":"0"},{"id":2756,"id2":2756,"serial_no":"TSC-LRC-2023072003","project_id":3263,"client_id":2545,"need_analysis":true,"bargain_date":"2023-07-20","collected":"99400","remind_date":"2023-08-31","amount":"99400","status":1,"uncollected":"0","overdue":"0","invoiced":"198800.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-08-31","project":{"id":3263,"key":3263,"name":"\u65b0\u8d2dDellME5024\u5b58\u50a8\u4e00\u53f0","bargain_date":"2023-07-20","budget":"198800","collected":"198800"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":2647,"id2":2647,"serial_no":"TSKJ20230504-LRC","project_id":3195,"client_id":2536,"need_analysis":true,"bargain_date":"2023-05-04","collected":"133300","remind_date":"2023-08-31","amount":"133300","status":1,"uncollected":"0","overdue":"0","invoiced":"182300.00","overdue_days":57,"collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"133300","c_date":"2023-08-31","project":{"id":3195,"key":3195,"name":"Symantec \u9632\u75c5\u6bd2\u8f6f\u4ef6\u4ea7\u54c1\u7eed\u8ba2\u4e00\u5e74","bargain_date":"2023-05-04","budget":"182300","collected":"182300"},"client":{"id":2536,"key":2536,"name":"\u9996\u90fd\u533b\u79d1\u5927\u5b66\u9644\u5c5e\u5317\u4eac\u5b89\u8d1e\u533b\u9662"},"overdue_display":"\u903e\u671f57\u5929","overdue_amount":"0"},{"id":2599,"id2":2599,"serial_no":"TSKJ20230317-HYF-002","project_id":3157,"client_id":2520,"need_analysis":true,"bargain_date":"2023-03-17","collected":"154171","remind_date":"2023-08-31","amount":"154171","status":1,"uncollected":"0","overdue":"0","invoiced":"1541710.00","overdue_days":"","collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-08-31","project":{"id":3157,"key":3157,"name":"\u5927\u9ea6\u79d1\u6280-\u8d85\u878d\u5408\u9879\u76ee","bargain_date":"2023-03-17","budget":"1541710","collected":"1541710"},"client":{"id":2520,"key":2520,"name":"\u5317\u4eac\u5168\u65b0\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":"0"},{"id":2817,"id2":2817,"serial_no":"TS-LRC-2023082801","project_id":3300,"client_id":2511,"need_analysis":true,"bargain_date":"2023-08-28","collected":"3000","remind_date":"","amount":"3000","status":1,"uncollected":"0","overdue":"","invoiced":"3000.00","overdue_days":"","collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-08-28","project":{"id":3300,"key":3300,"name":"\u4ea4\u6362\u673a\u8c03\u8bd5\u4e00\u6b21\u6027\u670d\u52a1","bargain_date":"2023-08-28","budget":"3000","collected":"3000"},"client":{"id":2511,"key":2511,"name":"\u5927\u8fde\u65e5\u4fe1\u8d44\u8baf\u7cfb\u7edf\u6709\u9650\u516c\u53f8"},"overdue_display":"","overdue_amount":""},{"id":2742,"id2":2742,"serial_no":"TSKJ20230707-006","project_id":3251,"client_id":2553,"need_analysis":true,"bargain_date":"2023-08-08","collected":"349615.8","remind_date":"2023-08-25","amount":"349615.8","status":1,"uncollected":"0.0","overdue":"0.0","invoiced":"388462.00","overdue_days":34,"collected_count":3,"uninvoiced":"0.00","overdue_collect_amount":"349615.8","c_date":"2023-08-25","project":{"id":3251,"key":3251,"name":"\u6c99\u7279\u7ea2\u6d77\u516c\u7528\u4e8b\u4e1a\u57fa\u7840\u8bbe\u65bd\u9879\u76ee\u7f51\u7edc\u5b89\u5168\u7cfb\u7edfPA\u8bbe\u5907","bargain_date":"2023-08-08","budget":"388462","collected":"388462"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f34\u5929","overdue_amount":"0.0"},{"id":2737,"id2":2737,"serial_no":"TS-HYF-2023070425","project_id":3246,"client_id":2551,"need_analysis":true,"bargain_date":"2023-07-04","collected":"74790","remind_date":"2023-08-21","amount":"74790","status":1,"uncollected":"0","overdue":"0","invoiced":"74790.00","overdue_days":56,"collected_count":1,"uninvoiced":"0.00","overdue_collect_amount":"74790","c_date":"2023-08-21","project":{"id":3246,"key":3246,"name":"\u3010\u6d89\u5bc6\u3011\u5929\u519b-xx \u6570\u636e\u6e90\u68b3\u7406\u53ca\u5206\u5e03\u5f0f\u6570\u636e\u5bfc\u5165\u9879\u76ee\u4e4b\u6c14\u8c61\u6d77\u6d0b\u5206\u652f\u4e91\u5e73\u53f0","bargain_date":"2023-07-04","budget":"74790","collected":"74790"},"client":{"id":2551,"key":2551,"name":"\u5317\u4eac\u601d\u8fbe\u777f\u667a\u7cfb\u7edf\u96c6\u6210\u6709\u9650\u516c\u53f8"},"overdue_display":"\u903e\u671f56\u5929","overdue_amount":"0"},{"id":2756,"id2":2756,"serial_no":"TSC-LRC-2023072003","project_id":3263,"client_id":2545,"need_analysis":true,"bargain_date":"2023-07-20","collected":"99400","remind_date":"2023-07-28","amount":"99400","status":1,"uncollected":"0","overdue":"0","invoiced":"198800.00","overdue_days":"","collected_count":2,"uninvoiced":"0.00","overdue_collect_amount":"","c_date":"2023-07-28","project":{"id":3263,"key":3263,"name":"\u65b0\u8d2dDellME5024\u5b58\u50a8\u4e00\u53f0","bargain_date":"2023-07-20","budget":"198800","collected":"198800"},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"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":5,"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:54', 74589952) RETURNING "id"
17:22:54.620traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:22:54.620traceyii\redis\Connection::executeCommandExecuting Redis Command: SET