ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a196319dc8f2: POST https://beta.jinchangxiao.com/vue/smart-board/top-clients at 2026-05-29 05:57:45 pm by 221.216.117.119

Log Messages

总计38条数据
TimeLevelCategoryMessage
 
17:57:45.902traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:57:45.902traceyii\base\Module::getModuleLoading module: debug
17:57:45.903traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:57:45.903traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:57:45.903traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:57:45.903traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.904infotime tracing start1780048665904104960
17:57:45.904traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:57:45.904traceyii\web\Application::handleRequestRoute requested: 'vue/smart-board/top-clients'
17:57:45.904traceyii\base\Module::getModuleLoading module: vue
17:57:45.904infoyii\web\Session::openSession started
17:57:45.905infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:57:45.905infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:57:45.907traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.907traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:45.907traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.907traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:45.908infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:57:45.909traceyii\base\Controller::runActionRoute to run: vue/smart-board/top-clients
17:57:45.909traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.910traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:57:45.910traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SmartBoardController::actionTopClients()
17:57:45.910traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.911traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.913infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "c"."id" AS "client_id", "c"."name" AS "client_name", sr.name AS sales_rep_name, COALESCE(curr.erp_revenue, 0) AS revenue, COALESCE(curr.erp_profit, 0) AS profit, COALESCE(prev.erp_revenue, 0) AS prev_revenue, COALESCE(prev.erp_profit, 0) AS prev_profit, CASE WHEN COALESCE(prev.erp_revenue, 0) > 0 THEN (COALESCE(curr.erp_revenue, 0) - prev.erp_revenue) / prev.erp_revenue WHEN COALESCE(curr.erp_revenue, 0) > 0 THEN 1 ELSE NULL END AS revenue_growth, CASE WHEN COALESCE(prev.erp_profit, 0) > 0 THEN (COALESCE(curr.erp_profit, 0) - prev.erp_profit) / prev.erp_profit WHEN COALESCE(curr.erp_profit, 0) > 0 THEN 1 ELSE NULL END AS profit_growth, CASE WHEN wl.lost_contact_days IS NOT NULL AND cc.notice_days IS NOT NULL AND cc.notice_days > 0 AND wl.lost_contact_days > cc.notice_days THEN '逾期' WHEN wl.lost_contact_days IS NULL AND cc.notice_days IS NOT NULL AND cc.notice_days > 0 AND extract(epoch from (now() - c.created_at)) / 86400 > cc.notice_days THEN '逾期' ELSE '正常' END AS contact_status FROM "a57be577deb434"."tbl_clients" "c" INNER JOIN (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") "curr" ON curr.client_id = c.id AND curr.erp_revenue > 0 LEFT JOIN (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") "prev" ON prev.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_users" "sr" ON sr.id = c.sales_rep LEFT JOIN (SELECT "client_id", extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "wl" ON wl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE "c"."deleted"=FALSE ORDER BY revenue DESC NULLS LAST) AS cnt_sub
17:57:45.924infoyii\db\Command::querySELECT "c"."id" AS "client_id", "c"."name" AS "client_name", sr.name AS sales_rep_name, COALESCE(curr.erp_revenue, 0) AS revenue, COALESCE(curr.erp_profit, 0) AS profit, COALESCE(prev.erp_revenue, 0) AS prev_revenue, COALESCE(prev.erp_profit, 0) AS prev_profit, CASE WHEN COALESCE(prev.erp_revenue, 0) > 0 THEN (COALESCE(curr.erp_revenue, 0) - prev.erp_revenue) / prev.erp_revenue WHEN COALESCE(curr.erp_revenue, 0) > 0 THEN 1 ELSE NULL END AS revenue_growth, CASE WHEN COALESCE(prev.erp_profit, 0) > 0 THEN (COALESCE(curr.erp_profit, 0) - prev.erp_profit) / prev.erp_profit WHEN COALESCE(curr.erp_profit, 0) > 0 THEN 1 ELSE NULL END AS profit_growth, CASE WHEN wl.lost_contact_days IS NOT NULL AND cc.notice_days IS NOT NULL AND cc.notice_days > 0 AND wl.lost_contact_days > cc.notice_days THEN '逾期' WHEN wl.lost_contact_days IS NULL AND cc.notice_days IS NOT NULL AND cc.notice_days > 0 AND extract(epoch from (now() - c.created_at)) / 86400 > cc.notice_days THEN '逾期' ELSE '正常' END AS contact_status FROM "a57be577deb434"."tbl_clients" "c" INNER JOIN (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") "curr" ON curr.client_id = c.id AND curr.erp_revenue > 0 LEFT JOIN (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-05-29 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") "prev" ON prev.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_users" "sr" ON sr.id = c.sales_rep LEFT JOIN (SELECT "client_id", extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "wl" ON wl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE "c"."deleted"=FALSE ORDER BY revenue DESC NULLS LAST LIMIT 10
17:57:45.959traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.959infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_clients' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
17:57:45.966infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_clients' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
17:57:45.989traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:45.989traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
17:57:45.989infoyii\db\Command::querySELECT COALESCE(SUM(erp_revenue), 0) FROM (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") AS total_sub WHERE erp_revenue > 0
17:57:45.993infoyii\db\Command::querySELECT COALESCE(SUM(t10.erp_revenue), 0) FROM (SELECT erp_revenue FROM (SELECT c.id AS client_id, COALESCE(sum(o.outbound_amount), 0) + COALESCE(sum(eoi.amount), 0) AS erp_revenue, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - COALESCE(sum(ect.amount), 0) - COALESCE(sum(ect2.amount), 0) - COALESCE(sum(ecct.amount), 0) - COALESCE(sum(eccrt.amount), 0) - COALESCE(sum(esgs.amount), 0) AS erp_profit FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT con.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "con" ON con.id = t.contact_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (con.client_id IS NOT NULL) GROUP BY "con"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id WHERE "c"."deleted"=FALSE GROUP BY "c"."id") AS inner_sub WHERE erp_revenue > 0 ORDER BY erp_revenue DESC LIMIT 10) AS t10
17:57:45.997traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.997traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:45.997infoyii\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/smart-board/top-clients', '{"page":"1","Filter":{"name":"revenue","sort":"DESC"},"web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"fiscal_year":2026,"top10_revenue_pct":0.98,"list":[{"rank":1,"client_id":982,"client_name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep_name":"\u5218\u4eba\u8bda","revenue":"12703072","revenue_growth":"1","profit":"12702288.795","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":2,"client_id":3438,"client_name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"3837034","revenue_growth":"1","profit":"115112","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":3,"client_id":3377,"client_name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep_name":"\u5218\u4eba\u8bda","revenue":"1630000","revenue_growth":"1","profit":"193773","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":4,"client_id":2128,"client_name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u5fae","revenue":"631660","revenue_growth":"1","profit":"318615.26","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":5,"client_id":2125,"client_name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u5fae","revenue":"333880","revenue_growth":"1","profit":"29643.54","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":6,"client_id":918,"client_name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"220750","revenue_growth":"1","profit":"3507.60","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":7,"client_id":3286,"client_name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u4eba\u8bda","revenue":"176442","revenue_growth":"1","profit":"17643.8","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":8,"client_id":3359,"client_name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"137520","revenue_growth":"1","profit":"31520","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":9,"client_id":20,"client_name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"117500","revenue_growth":"1","profit":"33863.5400000002","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":10,"client_id":107,"client_name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","sales_rep_name":"\u9b4f\u6cfd\u6587","revenue":"88240.2","revenue_growth":"1","profit":"33969.96","profit_growth":"1","contact_status":"\u903e\u671f"}],"pagenation":{"totalcount":29,"thispage":1,"pagesize":10}},"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-05-29 17:57:45', 93685248) RETURNING "id"
17:57:45.999traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:45.999traceyii\redis\Connection::executeCommandExecuting Redis Command: SET