6a1d36df25780: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out at 2026-06-01 03:38:07 pm by 43.224.72.82
Log Messages
总计55条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:38:07.149 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:38:07.149 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:38:07.151 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:38:07.153 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:38:07.153 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:38:07.156 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.156 | info | time tracing start | 1780299487156736000 |
| 15:38:07.156 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:38:07.156 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-wage-analysis/in-out' |
| 15:38:07.156 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:38:07.157 | info | yii\web\Session::open | Session started |
| 15:38:07.158 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5493 |
| 15:38:07.158 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:38:07.159 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.159 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:38:07.160 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.160 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:38:07.160 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493 |
| 15:38:07.163 | trace | yii\base\Controller::runAction | Route to run: vue/erp-wage-analysis/in-out |
| 15:38:07.164 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.166 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:38:07.166 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpWageAnalysisController::actionInOut() |
| 15:38:07.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.168 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.171 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE) |
| 15:38:07.185 | info | yii\db\Command::query | SELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE) |
| 15:38:07.195 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) |
| 15:38:07.204 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) |
| 15:38:07.214 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) |
| 15:38:07.235 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" ON am.erp_wage_prize_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) |
| 15:38:07.244 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) |
| 15:38:07.251 | info | yii\db\Command::query | SELECT SUM(wage) FROM "o6a13e2c574d5a"."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') |
| 15:38:07.271 | info | yii\db\Command::query | SELECT SUM(eipss.total_amount - eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) |
| 15:38:07.290 | info | yii\db\Command::query | SELECT SUM((eipss.total_amount - eipss.actual_total_amount) * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) |
| 15:38:07.295 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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)) |
| 15:38:07.298 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) |
| 15:38:07.299 | info | yii\db\Command::query | SELECT SUM(budget - cost) FROM "o6a13e2c574d5a"."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') |
| 15:38:07.300 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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)) |
| 15:38:07.306 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) |
| 15:38:07.308 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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)) |
| 15:38:07.310 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) |
| 15:38:07.313 | info | yii\db\Command::query | SELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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)) |
| 15:38:07.315 | info | yii\db\Command::query | SELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) |
| 15:38:07.316 | info | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount - eipss.total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) |
| 15:38:07.318 | info | yii\db\Command::query | SELECT SUM((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) |
| 15:38:07.319 | info | yii\db\Command::query | SELECT SUM(expense) FROM "o6a13e2c574d5a"."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') |
| 15:38:07.320 | info | yii\db\Command::query | SELECT u.*, sum(sub.amount) as amount FROM "o6a13e2c574d5a"."tbl_users" "u" LEFT JOIN ((SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_wage_prizes" "t" ON am.erp_wage_prize_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.user_id, sum(t.wage) as amount FROM "o6a13e2c574d5a"."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') GROUP BY "t"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id" |
| 15:38:07.322 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495)) |
| 15:38:07.323 | info | yii\db\Command::query | SELECT u.*, sum(sub.amount) as amount FROM "o6a13e2c574d5a"."tbl_users" "u" LEFT JOIN ((SELECT t.handler as user_id, sum(eipss.total_amount - eipss.actual_total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum((eipss.total_amount - eipss.actual_total_amount) * am.pct / 100) as amount FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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.user_id, sum(t.budget - t.cost) as amount FROM "o6a13e2c574d5a"."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') GROUP BY "t"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(t.amount * am.pct / 100) as amount FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(t.amount * am.pct / 100) as amount FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(t.amount * am.pct / 100) as amount FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "o6a13e2c574d5a"."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, 0 - sum(eipss.actual_total_amount - eipss.total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, 0 - sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.user_id, 0 - sum(t.expense) as amount FROM "o6a13e2c574d5a"."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') GROUP BY "t"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id" |
| 15:38:07.332 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495)) |
| 15:38:07.332 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.333 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:38:07.333 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5493, 5, 'vue/erp-wage-analysis/in-out', '{"created_at_period":"erpcurrentfascalyear","user_id":"","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"outCircle":[{"key":"erpPersonalTaxs","name":"\u4e2a\u7a0e","value":"","y":0},{"key":"erpProvidentFunds","name":"\u516c\u79ef\u91d1","value":"","y":0},{"key":"erpSocialInsurances","name":"\u793e\u4fdd","value":"","y":0},{"key":"erpWagePrizes","name":"\u5956\u91d1","value":"","y":0},{"key":"erpWageTickets","name":"\u5de5\u8d44","value":0,"y":0}],"inCircle":[{"key":"otherIn","name":"\u5176\u4ed6\u6536\u5165","value":0,"y":0},{"key":"outboundIn","name":"\u9500\u552e\u6536\u5165","value":0,"y":0}],"profitCircle":[{"key":"totalIn","name":"\u6536\u5165\u603b\u91d1\u989d","value":0,"y":0},{"key":"totalOut","name":"\u652f\u51fa\u603b\u91d1\u989d","value":0,"y":0}],"seriesOut":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":""},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":""}],"seriesIn":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":"0"},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":""}],"total_in":0,"total_out":0,"profit":0,"seriesProfit":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 15:38:07', 176442880) RETURNING "id" |
| 15:38:07.334 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:38:07.334 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |