ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1e5253df9cc: POST https://beta.jinchangxiao.com/vue/smart-board/account-list at 2026-06-02 11:47:31 am by 221.216.117.119

Performance Profiling

Total processing time: 206 ms; Peak memory: 5.839 MB. Show Profiling Timeline

总计32条数据
TimeDurationCategoryInfo
  
11:47:32.01825.0 msyii\db\Command::querySELECT "created_by", COUNT(DISTINCT client_id) AS cnt FROM ((SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2026-01-01') AND ("start_at" <= '2026-12-31 23:59:59')) UNION ( SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_schedules" WHERE ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2026-01-01') AND ("created_at" <= '2026-12-31 23:59:59') )) "combined" GROUP BY "created_by"
11:47:31.94922.1 msyii\db\Command::querySELECT "sub"."id", "sub"."erp_sales_amount", "sub"."amount" FROM (SELECT u.id, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) as erp_sales_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) - COALESCE(sum(sub_in.actual_total_amount), 0) - COALESCE(sum(start.cost), 0) - COALESCE(sum(sub_out.amount), 0) - COALESCE(sum(start.expense), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT "user_id", sum(actual_total_amount) as actual_total_amount, sum(total_amount) as total_amount FROM ((SELECT t.handler as user_id, sum(eipss.actual_total_amount) as actual_total_amount, sum(eipss.total_amount) as total_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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum(eipss.actual_total_amount * am.pct / 100) as actual_total_amount, sum(eipss.total_amount * am.pct / 100) as total_amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_in" ON sub_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_overflows" "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"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" )) "sub" GROUP BY "user_id") "sub_other_in" ON sub_other_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON pd.project_id = t.project_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_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 ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(eipss.actual_total_amount - eipss.total_amount) 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_out" ON sub_out.user_id = u.id LEFT JOIN (SELECT user_id, budget, cost, expense, profit FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59')) "start" ON start.user_id = u.id WHERE "u"."id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "u"."id") "sub"
11:47:31.97219.0 msyii\db\Command::querySELECT "sub"."id", "sub"."erp_sales_amount", "sub"."amount" FROM (SELECT u.id, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) as erp_sales_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) - COALESCE(sum(sub_in.actual_total_amount), 0) - COALESCE(sum(start.cost), 0) - COALESCE(sum(sub_out.amount), 0) - COALESCE(sum(start.expense), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT "user_id", sum(actual_total_amount) as actual_total_amount, sum(total_amount) as total_amount FROM ((SELECT t.handler as user_id, sum(eipss.actual_total_amount) as actual_total_amount, sum(eipss.total_amount) as total_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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum(eipss.actual_total_amount * am.pct / 100) as actual_total_amount, sum(eipss.total_amount * am.pct / 100) as total_amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_in" ON sub_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" )) "sub" GROUP BY "user_id") "sub_other_in" ON sub_other_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON pd.project_id = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(eipss.actual_total_amount - eipss.total_amount) 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_out" ON sub_out.user_id = u.id LEFT JOIN (SELECT user_id, budget, cost, expense, profit FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "start" ON start.user_id = u.id WHERE "u"."id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "u"."id") "sub"
11:47:31.99318.6 msyii\db\Command::querySELECT "sub"."id", "sub"."erp_sales_amount", "sub"."amount" FROM (SELECT u.id, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) as erp_sales_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) - COALESCE(sum(sub_in.actual_total_amount), 0) - COALESCE(sum(start.cost), 0) - COALESCE(sum(sub_out.amount), 0) - COALESCE(sum(start.expense), 0) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT "user_id", sum(actual_total_amount) as actual_total_amount, sum(total_amount) as total_amount FROM ((SELECT t.handler as user_id, sum(eipss.actual_total_amount) as actual_total_amount, sum(eipss.total_amount) as total_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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum(eipss.actual_total_amount * am.pct / 100) as actual_total_amount, sum(eipss.total_amount * am.pct / 100) as total_amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_in" ON sub_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" )) "sub" GROUP BY "user_id") "sub_other_in" ON sub_other_in.user_id = u.id LEFT JOIN (SELECT "user_id", sum(amount) as amount FROM ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON pd.project_id = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(eipss.actual_total_amount - eipss.total_amount) 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("t"."handler" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59') AND ("am"."user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "am"."user_id" )) "sub" GROUP BY "user_id") "sub_out" ON sub_out.user_id = u.id LEFT JOIN (SELECT user_id, budget, cost, expense, profit FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-06-02 23:59:59')) "start" ON start.user_id = u.id WHERE "u"."id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "u"."id") "sub"
11:47:32.0777.2 msyii\db\Command::querySELECT "created_by", COUNT(DISTINCT client_id) AS cnt FROM ((SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2025-01-01') AND ("start_at" <= '2025-06-02 23:59:59')) UNION ( SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_schedules" WHERE ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2025-01-01') AND ("created_at" <= '2025-06-02 23:59:59') )) "combined" GROUP BY "created_by"
11:47:32.0576.4 msyii\db\Command::querySELECT "created_by", COUNT(DISTINCT client_id) AS cnt FROM ((SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2025-08-01') AND ("start_at" <= '2025-12-31 23:59:59')) UNION ( SELECT "created_by", "client_id" FROM "a57be577deb434"."tbl_schedules" WHERE ("client_id" IS NOT NULL) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2025-08-01') AND ("created_at" <= '2025-12-31 23:59:59') )) "combined" GROUP BY "created_by"
11:47:32.0445.5 msyii\db\Command::querySELECT "created_by", COUNT(*) AS visit_count, COALESCE(SUM(EXTRACT(EPOCH FROM (end_at - start_at)) / 3600), 0) AS visit_duration FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2026-01-01') AND ("start_at" <= '2026-12-31 23:59:59') AND ("end_at" IS NOT NULL) AND ("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL) GROUP BY "created_by"
11:47:32.1124.7 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/account-list', '{"period":"currentfascalyear","sales_rep":"","web_access_token":"wTKilqflq6B-eOSFd1z6EzcpqcAU3V6m"}', '{"code":2000,"result":{"list":[{"id":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"revenue_index":"14577147.000000000000","profit_index":"13198498.59500000000000000000","revenue":{"current":"14577147.000000000000","previous":"9554927.87","last_year":"0","target":"","rate":null,"vs_previous":0.5256,"vs_last_year":"1"},"profit":{"current":"13198498.59500000000000000000","previous":"494290.72","last_year":"0","target":"","rate":null,"vs_previous":25.7018,"vs_last_year":"1"},"clients":{"total_clients":66,"active_clients":6,"maintenance_rate":0.0909,"visit_count":0,"visit_duration":"0","pending_tasks":1,"explicit_opportunity_number":6,"explicit_opportunity_amount":"488113.06","pending_tasks_vs_previous":-0.6666,"pending_tasks_vs_last_year":"1","visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"15479","last_amount":"0","growth":"1"},"y":"15479"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"10436","growth":-1},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"1221.00","last_amount":"0","growth":"1"},"y":"1221.00"},{"key":"2026-05","name":"2026-05","model":{"amount":"1889.50","last_amount":"0","growth":"1"},"y":"1889.50"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"12171","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"15479","last_amount":"0","growth":"1"},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"10436","growth":-1},"y":"10436"},{"key":"2025-04","name":"2026-04","model":{"amount":"1221.00","last_amount":"0","growth":"1"},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"1889.50","last_amount":"0","growth":"1"},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"12171","growth":null},"y":"12171"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":18589.5,"totalLastAmount":10436,"totalGrowth":0.7812},"expense_type":[{"name":"\u9910\u996e\u8d39","amount":"18589.50","percentage":1}]},"receivable":{"receivable":"15386174.06"}},{"id":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"revenue_index":"4445464","profit_index":"109466.130","revenue":{"current":"4445464","previous":"12003453.44","last_year":"0","target":12000000,"rate":0.3704,"vs_previous":-0.6296,"vs_last_year":"1"},"profit":{"current":"109466.130","previous":"1792933.3900000012","last_year":"0","target":"","rate":null,"vs_previous":-0.9389,"vs_last_year":"1"},"clients":{"total_clients":122,"active_clients":21,"maintenance_rate":0.1721,"visit_count":1,"visit_duration":"0","pending_tasks":21,"explicit_opportunity_number":7,"explicit_opportunity_amount":"4206000","pending_tasks_vs_previous":-0.125,"pending_tasks_vs_last_year":0.75,"visit_count_vs_previous":-0.9375,"visit_count_vs_last_year":-0.8333,"visit_duration_vs_previous":-0.9999,"visit_duration_vs_last_year":-0.9999},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"5996.00","last_amount":"5992.00","growth":0.0006},"y":"5996.00"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"2870.00","growth":-1},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"20601.00","last_amount":"7164.00","growth":1.8756},"y":"20601.00"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"10986.00","growth":-1},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"15354.00","growth":-1},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"5759.00","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"10301.00","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"6079.00","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"8762.00","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"14939.50","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"2675.00","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"5996.00","last_amount":"5992.00","growth":0.0006},"y":"5992.00"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"2870.00","growth":-1},"y":"2870.00"},{"key":"2025-03","name":"2026-03","model":{"amount":"20601.00","last_amount":"7164.00","growth":1.8756},"y":"7164.00"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"10986.00","growth":-1},"y":"10986.00"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"15354.00","growth":-1},"y":"15354.00"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"5759.00","growth":null},"y":"5759.00"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"10301.00","growth":null},"y":"10301.00"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"6079.00","growth":null},"y":"6079.00"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"8762.00","growth":null},"y":"8762.00"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"14939.50","growth":null},"y":"14939.50"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"2675.00","growth":null},"y":"2675.00"}],"totalAmount":26597,"totalLastAmount":42366,"totalGrowth":-0.3722},"expense_type":[{"name":"\u9910\u996e\u8d39","amount":"14905.00","percentage":0.5604},{"name":"\u5f80\u8fd4\u4ea4\u901a\u8d39","amount":"5391.00","percentage":0.2026},{"name":"\u51fa\u79df\u8f66\u8d39","amount":"3074.00","percentage":0.1155},{"name":"\u4f4f\u5bbf\u8d39","amount":"2827.00","percentage":0.1062},{"name":"\u7535\u8bdd\u8d39","amount":"400.00","percentage":0.015}]},"receivable":{"receivable":"9558117.26"}},{"id":5087,"name":"\u5218\u5fae","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"revenue_index":"1007100","profit_index":"383449.67","revenue":{"current":"1007100","previous":"4428728","last_year":"0","target":"","rate":null,"vs_previous":-0.7725,"vs_last_year":"1"},"profit":{"current":"383449.67","previous":"848261.80","last_year":"0","target":"","rate":null,"vs_previous":-0.5479,"vs_last_year":"1"},"clients":{"total_clients":44,"active_clients":42,"maintenance_rate":0.9545,"visit_count":0,"visit_duration":"0","pending_tasks":41,"explicit_opportunity_number":15,"explicit_opportunity_amount":"66540200","pending_tasks_vs_previous":1.05,"pending_tasks_vs_last_year":2.1538,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"583.00","growth":-1},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"700.00","growth":-1},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"2000.00","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"583.00","growth":-1},"y":"583.00"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"700.00","growth":-1},"y":"700.00"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"2000.00","growth":null},"y":"2000.00"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":1283,"totalGrowth":-1},"expense_type":[]},"receivable":{"receivable":"1390606.4"}},{"id":5295,"name":"\u9b4f\u6cfd\u6587","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"revenue_index":"176680.2","profit_index":"41974.07","revenue":{"current":"176680.2","previous":"3148845.30","last_year":"0","target":"","rate":null,"vs_previous":-0.9438,"vs_last_year":"1"},"profit":{"current":"41974.07","previous":"632410.35","last_year":"0","target":"","rate":null,"vs_previous":-0.9336,"vs_last_year":"1"},"clients":{"total_clients":48,"active_clients":48,"maintenance_rate":1,"visit_count":51,"visit_duration":"43.1444444444445","pending_tasks":47,"explicit_opportunity_number":8,"explicit_opportunity_amount":"623519","pending_tasks_vs_previous":1.35,"pending_tasks_vs_last_year":-0.1454,"visit_count_vs_previous":-0.5714,"visit_count_vs_last_year":-0.4456,"visit_duration_vs_previous":-0.6624,"visit_duration_vs_last_year":-0.5871},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"2138.30","last_amount":"1711.00","growth":0.2497},"y":"2138.30"},{"key":"2026-02","name":"2026-02","model":{"amount":"609.00","last_amount":"2818.50","growth":-0.7839},"y":"609.00"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"3554.80","growth":-1},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"2107.20","growth":-1},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"2228.50","growth":-1},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"1806.00","growth":-1},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"1431.50","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"1718.30","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"2016.50","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"1357.00","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"1898.00","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"1668.00","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"2138.30","last_amount":"1711.00","growth":0.2497},"y":"1711.00"},{"key":"2025-02","name":"2026-02","model":{"amount":"609.00","last_amount":"2818.50","growth":-0.7839},"y":"2818.50"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"3554.80","growth":-1},"y":"3554.80"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"2107.20","growth":-1},"y":"2107.20"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"2228.50","growth":-1},"y":"2228.50"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"1806.00","growth":-1},"y":"1806.00"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"1431.50","growth":null},"y":"1431.50"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"1718.30","growth":null},"y":"1718.30"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"2016.50","growth":null},"y":"2016.50"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"1357.00","growth":null},"y":"1357.00"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"1898.00","growth":null},"y":"1898.00"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"1668.00","growth":null},"y":"1668.00"}],"totalAmount":2747.3,"totalLastAmount":14226,"totalGrowth":-0.8068},"expense_type":[{"name":"\u51fa\u79df\u8f66\u8d39","amount":"1459.00","percentage":0.531},{"name":"\u9910\u996e\u8d39","amount":"988.30","percentage":0.3597},{"name":"\u7535\u8bdd\u8d39","amount":"300","percentage":0.1091}]},"receivable":{"receivable":"0.00"}},{"id":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"revenue_index":"57720","profit_index":"3953.2100","revenue":{"current":"57720","previous":"2422194","last_year":"0","target":"","rate":null,"vs_previous":-0.9761,"vs_last_year":"1"},"profit":{"current":"3953.2100","previous":"513841.74","last_year":"0","target":"","rate":null,"vs_previous":-0.9923,"vs_last_year":"1"},"clients":{"total_clients":51,"active_clients":51,"maintenance_rate":1,"visit_count":47,"visit_duration":"50.9166666666667","pending_tasks":56,"explicit_opportunity_number":12,"explicit_opportunity_amount":"1000000","pending_tasks_vs_previous":1.074,"pending_tasks_vs_last_year":2.5,"visit_count_vs_previous":-0.5913,"visit_count_vs_last_year":-0.5648,"visit_duration_vs_previous":-0.6073,"visit_duration_vs_last_year":-0.6249},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"2425.60","last_amount":"2405.03","growth":0.0085},"y":"2425.60"},{"key":"2026-02","name":"2026-02","model":{"amount":"713.00","last_amount":"2548","growth":-0.7201},"y":"713.00"},{"key":"2026-03","name":"2026-03","model":{"amount":"58.00","last_amount":"2137.34","growth":-0.9728},"y":"58.00"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"2246.7","growth":-1},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"2453.20","growth":-1},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"2283.80","growth":-1},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"2094.08","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"2576.70","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"2127.32","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"2498.50","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"2170.10","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"1304.66","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"2425.60","last_amount":"2405.03","growth":0.0085},"y":"2405.03"},{"key":"2025-02","name":"2026-02","model":{"amount":"713.00","last_amount":"2548","growth":-0.7201},"y":"2548"},{"key":"2025-03","name":"2026-03","model":{"amount":"58.00","last_amount":"2137.34","growth":-0.9728},"y":"2137.34"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"2246.7","growth":-1},"y":"2246.7"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"2453.20","growth":-1},"y":"2453.20"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"2283.80","growth":-1},"y":"2283.80"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"2094.08","growth":null},"y":"2094.08"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"2576.70","growth":null},"y":"2576.70"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"2127.32","growth":null},"y":"2127.32"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"2498.50","growth":null},"y":"2498.50"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"2170.10","growth":null},"y":"2170.10"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"1304.66","growth":null},"y":"1304.66"}],"totalAmount":3196.6,"totalLastAmount":14074.07,"totalGrowth":-0.7728},"expense_type":[{"name":"\u51fa\u79df\u8f66\u8d39","amount":"1563.00","percentage":0.4889},{"name":"\u9910\u996e\u8d39","amount":"1333.60","percentage":0.4171},{"name":"\u7535\u8bdd\u8d39","amount":"300.00","percentage":0.0938}]},"receivable":{"receivable":"132500.0"}},{"id":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"revenue_index":"2000","profit_index":"-7671.41","revenue":{"current":"2000","previous":"3264712.44","last_year":"0","target":"","rate":null,"vs_previous":-0.9993,"vs_last_year":"1"},"profit":{"current":"-7671.41","previous":"1112823.51","last_year":"0","target":"","rate":null,"vs_previous":-1.0068,"vs_last_year":null},"clients":{"total_clients":32,"active_clients":15,"maintenance_rate":0.4687,"visit_count":0,"visit_duration":"0","pending_tasks":16,"explicit_opportunity_number":2,"explicit_opportunity_amount":"407400","pending_tasks_vs_previous":0.7777,"pending_tasks_vs_last_year":1.2857,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"9.00","last_amount":"0","growth":"1"},"y":"9.00"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"11900","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"9.00","last_amount":"0","growth":"1"},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"11900","growth":null},"y":"11900"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":9,"totalLastAmount":0,"totalGrowth":"1"},"expense_type":[{"name":"\u7535\u8bdd\u8d39","amount":"9.00","percentage":1}]},"receivable":{"receivable":"21104.99"}},{"id":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"},"revenue_index":"0","profit_index":"-17256.9133333332","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"-17256.9133333332","previous":"-191846.32","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":234,"active_clients":0,"maintenance_rate":"0","visit_count":0,"visit_duration":"0","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":0,"totalGrowth":null},"expense_type":[]},"receivable":{"receivable":"0"}},{"id":5332,"name":"\u970d\u536b\u8d85","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"},"revenue_index":"0","profit_index":"0","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":238,"active_clients":0,"maintenance_rate":"0","visit_count":0,"visit_duration":"0","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":0,"totalGrowth":null},"expense_type":[]},"receivable":{"receivable":"0"}},{"id":5467,"name":"\u9a6c\u6668\u5e0c","avatar":null,"revenue_index":"0","profit_index":"0","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":0,"active_clients":0,"maintenance_rate":"0","visit_count":0,"visit_duration":"0","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":0,"totalGrowth":null},"expense_type":[]},"receivable":{"receivable":"0"}},{"id":5449,"name":"\u5468\u4e3d\u98de","avatar":null,"revenue_index":"0","profit_index":"0","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":2,"active_clients":0,"maintenance_rate":"0","visit_count":0,"visit_duration":"0","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":0,"totalGrowth":null},"expense_type":[]},"receivable":{"receivable":"0"}},{"id":1013,"name":"\u7fc1\u5bb6\u6210","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"revenue_index":"0","profit_index":"-1213.6","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"-1213.6","previous":"-15937.40","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":193,"active_clients":0,"maintenance_rate":"0","visit_count":0,"visit_duration":"0","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":null,"visit_count_vs_last_year":null,"visit_duration_vs_previous":null,"visit_duration_vs_last_year":null},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"5202.56","last_amount":"0","growth":"1"},"y":"5202.56"},{"key":"2026-02","name":"2026-02","model":{"amount":"5250","last_amount":"2395.92","growth":1.1912},"y":"5250"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"6761.67","growth":-1},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"1623.77","growth":-1},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"3555.15","growth":-1},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"2000","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"5873.21","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"9870.40","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"10371.52","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"1614.91","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"5202.56","last_amount":"0","growth":"1"},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"5250","last_amount":"2395.92","growth":1.1912},"y":"2395.92"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"6761.67","growth":-1},"y":"6761.67"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"1623.77","growth":-1},"y":"1623.77"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"3555.15","growth":-1},"y":"3555.15"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"2000","growth":null},"y":"2000"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"5873.21","growth":null},"y":"5873.21"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"9870.40","growth":null},"y":"9870.40"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"10371.52","growth":null},"y":"10371.52"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"1614.91","growth":null},"y":"1614.91"}],"totalAmount":10452.56,"totalLastAmount":14336.51,"totalGrowth":-0.2709},"expense_type":[{"name":"\u7f51\u7edc\u8d39\u7528","amount":"5250","percentage":0.5022},{"name":"\u6c34\u7535\u51b7\u6696\u8d39","amount":"2180.00","percentage":0.2085},{"name":"\u529e\u516c\u7528\u54c1","amount":"1758","percentage":0.1681},{"name":"\u71c3\u6cb9\u8d39","amount":"1000","percentage":0.0956},{"name":"\u7535\u8bdd\u8d39","amount":"264.56","percentage":0.0253}]},"receivable":{"receivable":"0"}},{"id":5476,"name":"\u6768\u5dcd","avatar":null,"revenue_index":"0","profit_index":"0","revenue":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"profit":{"current":"0","previous":"0","last_year":"0","target":"","rate":null,"vs_previous":null,"vs_last_year":null},"clients":{"total_clients":0,"active_clients":6,"maintenance_rate":"0","visit_count":4,"visit_duration":"10.2025","pending_tasks":0,"explicit_opportunity_number":0,"explicit_opportunity_amount":"0","pending_tasks_vs_previous":null,"pending_tasks_vs_last_year":null,"visit_count_vs_previous":"1","visit_count_vs_last_year":"1","visit_duration_vs_previous":"1","visit_duration_vs_last_year":"1"},"expense":{"expense_trend":{"categories":["2026-01","2026-02","2026-03","2026-04","2026-05","2026-06","2026-07","2026-08","2026-09","2026-10","2026-11","2026-12"],"currentYear":[{"key":"2026-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2026-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":null},{"key":"2026-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":null}],"lastYear":[{"key":"2025-01","name":"2026-01","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-02","name":"2026-02","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-03","name":"2026-03","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-04","name":"2026-04","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-05","name":"2026-05","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-06","name":"2026-06","model":{"amount":"0","last_amount":"0","growth":null},"y":"0"},{"key":"2025-07","name":"2026-07","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-08","name":"2026-08","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-09","name":"2026-09","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-10","name":"2026-10","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-11","name":"2026-11","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"},{"key":"2025-12","name":"2026-12","model":{"amount":null,"last_amount":"0","growth":null},"y":"0"}],"totalAmount":0,"totalLastAmount":0,"totalGrowth":null},"expense_type":[]},"receivable":{"receivable":"0"}}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 11:47:32', 195592960) RETURNING "id"
11:47:32.0644.7 msyii\db\Command::querySELECT "created_by", COUNT(*) AS visit_count, COALESCE(SUM(EXTRACT(EPOCH FROM (end_at - start_at)) / 3600), 0) AS visit_duration FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2025-08-01') AND ("start_at" <= '2025-12-31 23:59:59') AND ("end_at" IS NOT NULL) AND ("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL) GROUP BY "created_by"
11:47:32.0854.5 msyii\db\Command::querySELECT "created_by", COUNT(*) AS visit_count, COALESCE(SUM(EXTRACT(EPOCH FROM (end_at - start_at)) / 3600), 0) AS visit_duration FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("start_at" >= '2025-01-01') AND ("start_at" <= '2025-06-02 23:59:59') AND ("end_at" IS NOT NULL) AND ("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL) GROUP BY "created_by"
11:47:32.1004.0 msyii\db\Command::querySELECT "r"."created_by", COALESCE(tt.id, 0) AS type_id, COALESCE(tt.name, '未分类') AS type_name, COALESCE(SUM(r.amount), 0) AS total_amount FROM "a57be577deb434"."tbl_reimbursements" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = r.id AND ttr.term_id = 18 AND ttr.object_type = 7 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON tt.id = ttr.taxonomy_id WHERE ("r"."status" IN (1, 2, 3)) AND ("r"."occurrence_at" >= '2026-01-01') AND ("r"."occurrence_at" <= '2026-12-31 23:59:59') AND ("r"."created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "r"."created_by", tt.id, tt.name ORDER BY COALESCE(SUM(r.amount), 0) DESC
11:47:32.0973.2 msyii\db\Command::querySELECT "created_by", TO_CHAR(occurrence_at, 'YYYY-MM') AS month_key, COALESCE(SUM(amount), 0) AS total_amount FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2025-01-01') AND ("occurrence_at" <= '2025-12-31 23:59:59') AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by", TO_CHAR(occurrence_at, 'YYYY-MM')
11:47:31.9223.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:47:32.0932.8 msyii\db\Command::querySELECT "created_by", TO_CHAR(occurrence_at, 'YYYY-MM') AS month_key, COALESCE(SUM(amount), 0) AS total_amount FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2026-01-01') AND ("occurrence_at" <= '2026-12-31 23:59:59') AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by", TO_CHAR(occurrence_at, 'YYYY-MM')
11:47:31.9192.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:47:32.0492.6 msyii\db\Command::querySELECT "created_by", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2026-01-01') AND ("created_at" <= '2026-12-31 23:59:59') AND (("complete_at" IS NULL) OR ("complete_at" > '2026-12-31 23:59:59')) GROUP BY "created_by"
11:47:31.9282.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:47:31.9412.1 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
11:47:32.0531.9 msyii\db\Command::querySELECT "created_by", COUNT(*) AS explicit_count, COALESCE(SUM(budget), 0) AS explicit_amount FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=2) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
11:47:32.0691.9 msyii\db\Command::querySELECT "created_by", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2025-08-01') AND ("created_at" <= '2025-12-31 23:59:59') AND (("complete_at" IS NULL) OR ("complete_at" > '2025-12-31 23:59:59')) GROUP BY "created_by"
11:47:32.0721.8 msyii\db\Command::querySELECT "created_by", COUNT(*) AS explicit_count, COALESCE(SUM(budget), 0) AS explicit_amount FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=2) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
11:47:32.1071.8 msyii\db\Command::querySELECT "created_by", COALESCE(SUM(budget - COALESCE(collected, 0)), 0) AS receivable FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
11:47:32.0741.8 msyii\db\Command::querySELECT "sales_rep", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_clients" WHERE ("deleted"=FALSE) AND ("sales_rep" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "sales_rep"
11:47:32.0161.7 msyii\db\Command::querySELECT "sales_rep", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_clients" WHERE ("deleted"=FALSE) AND ("sales_rep" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "sales_rep"
11:47:32.0901.7 msyii\db\Command::querySELECT "created_by", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND ("created_at" >= '2025-01-01') AND ("created_at" <= '2025-06-02 23:59:59') AND (("complete_at" IS NULL) OR ("complete_at" > '2025-06-02 23:59:59')) GROUP BY "created_by"
11:47:31.9441.5 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-01-01 00:00:00') AND ("bargain_date" <= '2026-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
11:47:32.0551.3 msyii\db\Command::querySELECT "sales_rep", COUNT(*) AS cnt FROM "a57be577deb434"."tbl_clients" WHERE ("deleted"=FALSE) AND ("sales_rep" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "sales_rep"
11:47:32.0921.1 msyii\db\Command::querySELECT "created_by", COUNT(*) AS explicit_count, COALESCE(SUM(budget), 0) AS explicit_amount FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=2) AND ("created_by" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
11:47:32.0130.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_goals" WHERE ("id" IN (2, 4, 5, 7, 6, 8, 1, 9, 10, 11, 13, 15)) AND ("goal_year"=2026)
11:47:31.9460.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5311, 1001, 5295, 5332, 5300, 5467, 5449, 5087, 1004, 1013, 1005, 5476))
11:47:32.0120.5 msyii\db\Command::querySELECT "sales_goal_id", "user_id" FROM "a57be577deb434"."tbl_sales_goal_rels" WHERE "user_id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)
11:47:31.9450.4 msyii\db\Command::querySELECT "id", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)