68d3beeea165e: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out at 2025-09-24 05:50:38 pm by 221.216.117.180
Log Messages
总计56条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:50:38.660 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:50:38.660 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:50:38.661 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:50:38.661 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:50:38.661 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:50:38.661 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.661 | trace | yii\base\Module::getModule | Loading module: gii |
| 17:50:38.661 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 17:50:38.661 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:50:38.661 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-wage-analysis/in-out' |
| 17:50:38.661 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:50:38.662 | info | yii\web\Session::open | Session started |
| 17:50:38.662 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 17:50:38.662 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:50:38.666 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.667 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:50:38.667 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.667 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:50:38.667 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:50:38.669 | trace | yii\base\Controller::runAction | Route to run: vue/erp-wage-analysis/in-out |
| 17:50:38.669 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.670 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:50:38.670 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpWageAnalysisController::actionInOut() |
| 17:50:38.670 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.671 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.672 | 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.673 | 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.674 | 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.675 | 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.676 | 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.677 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.682 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.683 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.684 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.685 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.686 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.687 | 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"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND (t.handler is not null) |
| 17:50:38.688 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND (am.user_id is not null) |
| 17:50:38.690 | info | yii\db\Command::query | SELECT COALESCE(sum(am.actual_total_amount * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END)), 0) as outbound_cost, COALESCE(sum(am.total_amount * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END)), 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 (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ((pd.user_id is not null) OR (t.handler is not null)) |
| 17:50:38.691 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.691 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:50:38.691 | 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.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.692 | 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 ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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:50:38.694 | info | yii\db\Command::query | SELECT u.*, sum(sub.amount) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN ((SELECT am.user_id, sum(am.amount) as 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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-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 "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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-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 "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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-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 "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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-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 "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 ("t"."settle_month" >= '2025-01-01 00:00:00') AND ("t"."settle_month" <= '2025-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 "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"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct) 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"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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")) 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 LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct) 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_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, sum(eipss.actual_total_amount - eipss.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND (t.handler is not null) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, sum((eipss.actual_total_amount - eipss.total_amount) * am.pct) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id" |
| 17:50:38.705 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5332, 5360, 5388, 5413, 5445, 5446, 5449)) |
| 17:50:38.706 | info | yii\db\Command::query | SELECT u.*, sum(sub.amount) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN ((SELECT t.handler as user_id, sum(eipss.total_amount - eipss.actual_total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (("t"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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) 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_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-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 "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-01-01 00:00:00') AND ("t"."created_at" <= '2025-12-31 23:59:59') 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")) GROUP BY "am"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id" |
| 17:50:38.710 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 1023, 5248, 5311, 5446, 5087, 1022, 5016, 1004, 1015, 5295, 1001, 1000, 5300, 1013, 5332, 5250, 5360, 5388, 1011, 1005, 5085, 5449, 5064)) |
| 17:50:38.710 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.710 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:50:38.711 | 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:50:38.714 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.714 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:50:38.714 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=224, "last_visit_at"='now()' WHERE "id"=57055 |
| 17:50:38.716 | 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', '{"created_at_period":"","user_id":"","created_at_to":"","created_at_from":"","web_access_token":"_AoGeYJ0QgSiLktGksNR6aswyct1iLo2"}', '{"code":2000,"result":{"outCircle":[{"key":"cost","name":"\u8d39\u7528","value":974288.08,"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":"0","y":0},{"key":"erpWageTickets","name":"\u5de5\u8d44","value":"0","y":0}],"inCircle":[{"key":"outboundIn","name":"\u9500\u552e\u6536\u5165","value":1762166.98,"y":99.68},{"key":"otherIn","name":"\u5176\u4ed6\u6536\u5165","value":5693.3,"y":0.32}],"seriesOut":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png","y":"360882.50"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"194784.14"},{"key":1005,"name":"\u8d75\u6657\u7131","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"87892.00"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"65038.92"},{"key":1011,"name":"\u97e9\u96c5\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png","y":"65005.68"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"39232.70"},{"key":1023,"name":"\u5468\u5b50\u5065","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg","y":"28809.40"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"21822.92"},{"key":1015,"name":"\u5434\u660a","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg","y":"20137.63"},{"key":1017,"name":"\u8f66\u660e\u98de","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg","y":"18290"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"16713.86"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"16336.51"},{"key":5085,"name":"\u970d\u4e1c\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg","y":"15157.19"},{"key":5248,"name":"\u6587\u4f73\u9f99","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png","y":"6884.98"},{"key":5296,"name":"\u8d75\u5b87","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e5531358-5951-3209-9b90-0e3199f1b575.jpg","y":"5679.55"},{"key":1022,"name":"\u5f90\u7855","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png","y":"5311"},{"key":5445,"name":"\u674e\u9896","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/adb56a38-edbe-3b24-b50d-2231495d5449.jpg","y":"3077.78"},{"key":5360,"name":"\u5f20\u7ea2\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png","y":"1205.70"},{"key":5413,"name":"\u8096\u6167\u4e3d","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg","y":"1101.48"},{"key":5388,"name":"\u6768\u71d5\u971e","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png","y":"362.43"},{"key":5252,"name":"\u738b\u7b11\u7b11","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png","y":"361.71"},{"key":5446,"name":"\u5218\u5a1f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg","y":"200.00"},{"key":1000,"name":"\u66f9\u6c38\u751f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png","y":"0"},{"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png","y":"0"},{"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png","y":"0"},{"key":5250,"name":"\u8463\u8363","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png","y":"0"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":""},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"0"}],"seriesIn":[{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"910479.00"},{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png","y":"515485.98"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"229016.50"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"109877"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"3001.80"},{"key":1000,"name":"\u66f9\u6c38\u751f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png","y":""},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":""},{"key":1005,"name":"\u8d75\u6657\u7131","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":""},{"key":1011,"name":"\u97e9\u96c5\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png","y":""},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":""},{"key":1015,"name":"\u5434\u660a","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg","y":""},{"key":1022,"name":"\u5f90\u7855","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png","y":""},{"key":1023,"name":"\u5468\u5b50\u5065","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg","y":""},{"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png","y":""},{"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png","y":""},{"key":5085,"name":"\u970d\u4e1c\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg","y":""},{"key":5248,"name":"\u6587\u4f73\u9f99","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png","y":""},{"key":5250,"name":"\u8463\u8363","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png","y":""},{"key":5252,"name":"\u738b\u7b11\u7b11","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png","y":""},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":""},{"key":5360,"name":"\u5f20\u7ea2\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png","y":""},{"key":5388,"name":"\u6768\u71d5\u971e","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png","y":""},{"key":5446,"name":"\u5218\u5a1f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg","y":""},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":""}],"total_in":1767860.28,"total_out":974288.08},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-24 17:50:38') RETURNING "id" |
| 17:50:38.717 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:50:38.718 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |