ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a62efb2f0d: POST https://beta.jinchangxiao.com/vue/erp-analysis/sales-histogram at 2026-06-11 03:25:35 pm by 221.216.117.119

Database Queries

总计13条数据
TimeDurationTypeQuery
  
15:25:35.7370.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5064

[+] Explain
15:25:35.7400.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
15:25:35.7480.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)

[+] Explain
15:25:35.7490.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)

[+] Explain
15:25:35.7491.8 msSELECTSELECT "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

[+] Explain
15:25:35.7522.0 msSELECTSELECT "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"

[+] Explain
15:25:35.7541.8 msSELECTSELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, "created_by" FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '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"

[+] Explain
15:25:35.75924.9 msSELECTSELECT u.id, u.name, u.sex, u.department_id, u.department_position_id, sub.erp_sales_amount, sub.erp_cost_amount, sub.erp_other_in_amount, sub.erp_use_amount, sub.out_amount, sub.in_amount, sub.amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN (SELECT u.id, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) as erp_sales_amount, COALESCE(sum(sub_in.actual_total_amount), 0) + COALESCE(sum(start.cost), 0) as erp_cost_amount, COALESCE(sum(sub_other_in.amount), 0) as erp_other_in_amount, COALESCE(sum(sub_out.amount), 0) + COALESCE(sum(start.expense), 0) as erp_use_amount, 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 out_amount, COALESCE(sum(sub_in.total_amount), 0) + COALESCE(sum(start.budget), 0) + COALESCE(sum(sub_other_in.amount), 0) as in_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') 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') 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 (("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 ("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" )) "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 (("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 ("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 (("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 ("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 (("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 ("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') 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') 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 GROUP BY "u"."id") "sub" ON sub.id = u.id WHERE (("user_status"='1') OR (sub.id is not null)) AND ("u"."id" IN (5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) AND (("user_status"='1') OR ((sub.erp_sales_amount != 0) OR (sub.erp_cost_amount != 0) OR (sub.erp_other_in_amount != 0) OR (sub.erp_use_amount != 0) OR (sub.out_amount != 0) OR (sub.in_amount != 0) OR (sub.amount != 0)) OR ("u"."id" IN (1001, 1004, 1005, 5087, 5295, 5300))) ORDER BY "amount" DESC, "u"."id"

[+] Explain
15:25:35.7840.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5087, 1005, 5295, 5300, 5332, 5476, 1013, 1004, 5311))

[+] Explain
15:25:35.7851.0 msSELECTSELECT sum(p.budget) AS avg_budget, sum(p.budget /100 * profit_pct) AS avg_profit FROM "a57be577deb434"."tbl_projects" "p" WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59')

[+] Explain
15:25:35.7871.1 msSELECTSELECT "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 (daterange(start_from::date, end_at::date, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::daterange) AND ("user_id" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) 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

[+] Explain
15:25:35.7881.0 msSELECTSELECT "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"

[+] Explain
15:25:35.7901.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-analysis/sales-histogram', '{"period":"erpcurrentfascalyear","project_status":"3","alert":"false","web_access_token":"4eQAiv21khj4ckVl-aCvgG-h5XZj42Z5"}', '{"code":2000,"result":{"category":{"budgetCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"],"profitsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>"],"clientsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"],"projectsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"]},"seriesBudget":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"14577148.00"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"4445464.00"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"1007100.00"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"176680.20"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"57720.00"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"2000.00"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"0.00"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"0.00"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"}],"seriesProfits":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"12963507.60"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"383449.67"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"109466.13"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"41974.07"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"3953.21"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"-1213.60"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"-7671.41"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"-17256.91"}],"seriesClients":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":12},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":9},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":6},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":4},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0}],"seriesProjects":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":18},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":9},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":7},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":5},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0}],"avg":{"avg_budget":"7333918.61","avg_profit":"2009603.53"}},"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-11 15:25:35', 56614912) RETURNING "id"

[+] Explain