ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4ccbc20dcaf: POST https://beta.jinchangxiao.com/vue/smart-board/account at 2026-07-07 05:49:54 pm by 114.244.130.20

Log Messages

总计41条数据
TimeLevelCategoryMessage
 
17:49:54.054traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:49:54.054traceyii\base\Module::getModuleLoading module: debug
17:49:54.055traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:49:54.056traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:49:54.057traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:49:54.057traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.057infotime tracing start1783417794057715968
17:49:54.058traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:49:54.058traceyii\web\Application::handleRequestRoute requested: 'vue/smart-board/account'
17:49:54.058traceyii\base\Module::getModuleLoading module: vue
17:49:54.059infoyii\web\Session::openSession started
17:49:54.060infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:49:54.060infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:49:54.062traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.062traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:49:54.064infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:49:54.066traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.066traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:49:54.066infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:49:54.067traceyii\base\Controller::runActionRoute to run: vue/smart-board/account
17:49:54.068traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.069traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:49:54.070traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SmartBoardController::actionAccount()
17:49:54.070traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.071traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.072infoyii\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
17:49:54.074traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.074traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:49:54.075infoyii\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 (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "created_by"
17:49:54.076infoyii\db\Command::querySELECT "client"."sales_rep" AS "sales_rep", COALESCE(SUM(contract.amount), 0) AS revenue FROM "a57be577deb434"."tbl_sales_contracts" "contract" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = contract.client_id WHERE (COALESCE(contract.is_draft, false) = false) AND (COALESCE(contract.need_analysis, true) = true) AND ("contract"."signed_at" >= '2026-01-01') AND ("contract"."signed_at" <= '2026-12-31') AND ("client"."sales_rep" IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "client"."sales_rep"
17:49:54.078traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.079traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:49:54.081infoyii\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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 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 (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449) GROUP BY "u"."id") "sub"
17:49:54.112infoyii\db\Command::querySELECT "sales_goal_id" FROM "a57be577deb434"."tbl_sales_goal_rels" WHERE "user_id" IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)
17:49:54.113infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_goals" WHERE ("id" IN (2, 2, 4, 5, 7, 6, 8, 1, 1, 1, 1, 9, 9, 9, 9, 9, 9, 10, 10, 11, 11, 13, 15)) AND ("goal_year"=2026)
17:49:54.114infoyii\db\Command::querySELECT "sales_goal_id", COUNT(*) AS member_count FROM "a57be577deb434"."tbl_sales_goal_rels" WHERE ("sales_goal_id"=15) AND ("user_id" IN (5500, 5499, 5332, 1001, 5087, 5467, 5300, 5311, 5295, 1013, 5476, 1004, 1005, 5449)) GROUP BY "sales_goal_id"
17:49:54.115traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.116traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:49:54.116infoyii\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', '{"period":"currentfascalyear","sales_rep":"","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"target_revenue":12000000,"current_revenue":991271373.78,"revenue_rate":82.6059,"target_profit":4999992,"current_profit":191445993.75167,"profit_rate":38.2892,"sales_count":14},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 17:49:54', 58509056) RETURNING "id"
17:49:54.118traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:49:54.118traceyii\redis\Connection::executeCommandExecuting Redis Command: SET