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

Performance Profiling

Total processing time: 172 ms; Peak memory: 4.801 MB. Show Profiling Timeline

总计8条数据
TimeDurationCategoryInfo
  
17:57:46.02040.8 msyii\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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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") "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:46.0108.9 msyii\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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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" >= '2024-01-01 00:00:00') AND ("t"."created_at" <= '2024-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") "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:46.0675.1 msyii\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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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:46.0624.6 msyii\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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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:46.0741.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/smart-board/last-year-top-clients', '{"page":"1","Filter":{"name":"revenue","sort":"DESC"},"web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"fiscal_year":2025,"top10_revenue_pct":0.7266,"list":[{"rank":1,"client_id":3429,"client_name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u4eba\u8bda","revenue":"3587784","revenue_growth":"1","profit":"71756","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":2,"client_id":2762,"client_name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep_name":"\u5218\u5fae","revenue":"3003980","revenue_growth":"1","profit":"768264.65","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":3,"client_id":2737,"client_name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"2551700","revenue_growth":"1","profit":"291306.610000001","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":4,"client_id":3363,"client_name":"\u5317\u4eac\u91d1\u7545\u900d\u8f6f\u4ef6\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep_name":"\u4f0a\u5cfb\u8fb0","revenue":"1708235","revenue_growth":"1","profit":"1131637.00","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":5,"client_id":2553,"client_name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep_name":"\u5218\u4eba\u8bda","revenue":"885664.98","revenue_growth":"1","profit":"500653.98","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":6,"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":"865700","revenue_growth":"1","profit":"180481.0600000002","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":7,"client_id":93,"client_name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"545000","revenue_growth":"1","profit":"117071.640","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":8,"client_id":304,"client_name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep_name":"\u9b4f\u6cfd\u6587","revenue":"446714","revenue_growth":"1","profit":"98717.13","profit_growth":"1","contact_status":"\u903e\u671f"},{"rank":9,"client_id":2094,"client_name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep_name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","revenue":"432000","revenue_growth":"1","profit":"-39405.34","profit_growth":"","contact_status":"\u903e\u671f"},{"rank":10,"client_id":3383,"client_name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09","sales_rep_name":"\u9b4f\u6cfd\u6587","revenue":"363893.00","revenue_growth":"1","profit":"89063.01","profit_growth":"1","contact_status":"\u903e\u671f"}],"pagenation":{"totalcount":61,"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:46', 166309120) RETURNING "id"
17:57:46.0000.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:57:46.0030.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:57:46.0000.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta