68d3bf54a511e: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out-view at 2025-09-24 05:52:20 pm by 221.216.117.180
Log Messages
总计65条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:52:20.675 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:52:20.675 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:52:20.676 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:52:20.676 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:52:20.676 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:52:20.676 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.676 | trace | yii\base\Module::getModule | Loading module: gii |
| 17:52:20.677 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 17:52:20.677 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:52:20.677 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-wage-analysis/in-out-view' |
| 17:52:20.677 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:52:20.677 | info | yii\web\Session::open | Session started |
| 17:52:20.678 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 17:52:20.678 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:52:20.684 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.684 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:52:20.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.685 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:52:20.685 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:52:20.688 | trace | yii\base\Controller::runAction | Route to run: vue/erp-wage-analysis/in-out-view |
| 17:52:20.689 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.690 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:52:20.690 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpWageAnalysisController::actionInOutView() |
| 17:52:20.690 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001' |
| 17:52:20.691 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 17:52:20.692 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=7 |
| 17:52:20.693 | info | yii\db\Command::query | SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 17:52:20.694 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=1001 |
| 17:52:20.694 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name" IN ('AccountManager', 'Admin')) |
| 17:52:20.696 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id"=1001 |
| 17:52:20.696 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id"=1 |
| 17:52:20.697 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_engineer_group_relationships" WHERE "engineer_id"=1001 |
| 17:52:20.697 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_engineer_groups" WHERE "id"=1 |
| 17:52:20.698 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.699 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.700 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.701 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON am.erp_wage_prize_id = t.id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.701 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.702 | info | yii\db\Command::query | SELECT SUM(am.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 ("am"."user_id"='1001') AND (am.user_id is not 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)) |
| 17:52:20.705 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct) 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 ("am"."user_id"='1001') AND (am.user_id is not null) 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")) |
| 17:52:20.706 | info | yii\db\Command::query | SELECT SUM(am.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 LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not 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)) |
| 17:52:20.707 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct) 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_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) 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")) |
| 17:52:20.708 | info | yii\db\Command::query | SELECT SUM(am.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 ("am"."user_id"='1001') AND (am.user_id is not 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)) |
| 17:52:20.709 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct) 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 ("am"."user_id"='1001') AND (am.user_id is not null) 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")) |
| 17:52:20.710 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount - eipss.total_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"."handler"='1001') AND (t.handler is not null) |
| 17:52:20.711 | info | yii\db\Command::query | SELECT SUM((eipss.actual_total_amount - eipss.total_amount) * am.pct) 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 ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.712 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.713 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.714 | info | yii\db\Command::query | SELECT COALESCE(sum(am.actual_total_amount), 0) as outbound_cost, COALESCE(sum(am.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "am" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON am.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"."handler"='1001') AND (t.handler is not null) |
| 17:52:20.714 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.715 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:52:20.715 | info | yii\db\Command::query | SELECT COALESCE(sum(am.actual_total_amount), 0) as outbound_cost, COALESCE(sum(am.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "am" LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON am.erp_sales_outbound_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am2" ON am2.erp_profit_distribute_id = pd.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 ("am2"."user_id"='1001') AND (am2.user_id is not null) |
| 17:52:20.716 | info | yii\db\Command::query | SELECT SUM(am.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.from_project = t.sales_contract_id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not null) |
| 17:52:20.717 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct) 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 ("am"."user_id"='1001') AND (am.user_id is not null) 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")) |
| 17:52:20.718 | info | yii\db\Command::query | SELECT SUM(am.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.from_project = t.sales_contract_id WHERE ("t"."status"=2) AND ("am"."user_id"='1001') AND (am.user_id is not 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)) |
| 17:52:20.719 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct) 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 ("am"."user_id"='1001') AND (am.user_id is not null) 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")) |
| 17:52:20.720 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.720 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:52:20.721 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5064) AND ("object_type"=20000) AND ("visit_date"='2025-09-24') |
| 17:52:20.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:52:20.724 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=233, "last_visit_at"='now()' WHERE "id"=57055 |
| 17:52:20.726 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-wage-analysis/in-out-view', '{"created_at_period":"","created_at_to":"","created_at_from":"","user_id":["1001"],"web_access_token":"_AoGeYJ0QgSiLktGksNR6aswyct1iLo2"}', '{"code":2000,"result":{"model":{"id":1001,"email":"lrc@toast.com.cn","name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","sex":"M","birth_date":"1977-04-06","entry_date":"2005-06-06","department_id":4,"department_position_id":7,"mobile":"13501128560","telephone":"88864628","created_at":"2017-02-06 13:05:08","updated_at":"2025-06-19 11:56:42","id_number":"220523197704064411","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u5de5\u4e1a\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"821","leave_date":"","pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":"","namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","namecut4":"","budget_count":"5344256","profit_count":"82610.795400000000000000","bargain_count":"15","opportunity_budget_count":"322324.06","opportunity_count":"1","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"departmentPosition":{"id":7,"key":7,"name":"\u603b\u7ecf\u7406"},"avatar":{"user_id":1001,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"userRoles":[{"id":77,"key":77,"name":"Admin","display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458"},{"id":81,"key":81,"name":"AccountManager","display_name":"\u5ba2\u6237\u7ecf\u7406"}],"salesGroup":{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4"},"engineerGroup":{"id":1,"key":1,"name":"\u5168\u4f53"},"sex_display":"\u7537"},"outCircle":[{"key":"cost","name":"\u8d39\u7528","value":889345.5,"y":100},{"key":"erpPersonalTaxs","name":"\u4e2a\u7a0e","value":"0","y":0},{"key":"erpProvidentFunds","name":"\u516c\u79ef\u91d1","value":"0","y":0},{"key":"erpSocialInsurances","name":"\u793e\u4fdd","value":"0","y":0},{"key":"erpWagePrizes","name":"\u5956\u91d1","value":"","y":0},{"key":"erpWageTickets","name":"\u5de5\u8d44","value":"0","y":0}],"inCircle":[{"key":"outboundIn","name":"\u9500\u552e\u6536\u5165","value":515120.98,"y":99.88},{"key":"otherIn","name":"\u5176\u4ed6\u6536\u5165","value":615,"y":0.12}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-24 17:52:20') RETURNING "id" |
| 17:52:20.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:52:20.727 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |