ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3e167ac7e91: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-profit-a-loss at 2026-06-26 02:04:42 pm by 221.216.117.25

Log Messages

总计98条数据
TimeLevelCategoryMessage
 
14:04:42.817traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:04:42.817traceyii\base\Module::getModuleLoading module: debug
14:04:42.818traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:04:42.819traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:04:42.819traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:04:42.820traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:42.820infotime tracing start1782453882820676096
14:04:42.821traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:04:42.821traceyii\web\Application::handleRequestRoute requested: 'vue/erp-analysis/list-profit-a-loss'
14:04:42.821traceyii\base\Module::getModuleLoading module: vue
14:04:42.824infoyii\web\Session::openSession started
14:04:42.826infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:04:42.826infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:04:42.846traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:42.847traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:42.847traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:42.848traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:42.848infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:04:42.851traceyii\base\Controller::runActionRoute to run: vue/erp-analysis/list-profit-a-loss
14:04:42.852traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:42.855traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:04:42.855traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAnalysisController::actionListProfitALoss()
14:04:42.855infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)
14:04:42.858infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
14:04:42.858infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
14:04:42.859infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-07-01') AND ("is_settle"=TRUE)
14:04:42.859infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
14:04:42.860infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.861infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.862infoyii\db\Command::querySELECT SUM(budget) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.864infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.865infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.865infoyii\db\Command::querySELECT SUM(budget) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.866infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.867infoyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.867infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.868infoyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.868infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.869infoyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.870infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.870infoyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.871infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.871infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.872infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.873infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.874infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.874infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.875infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=19) AND ("is_system"=TRUE)
14:04:42.877traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:42.877traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:42.877infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"
14:04:42.878infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (399, 400, 401, 402, 430, 431, 439)) GROUP BY "id"
14:04:42.881infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (399, 400, 401, 402, 430, 431, 439)) GROUP BY "id"
14:04:42.884infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 398) AND ("term_id"=19) AND ("is_system"=FALSE)
14:04:42.884infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE 0=1 ORDER BY "is_delete", "sort"
14:04:42.885infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) GROUP BY "id"
14:04:42.886infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) AND ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) GROUP BY "id"
14:04:42.887infoyii\db\Command::querySELECT SUM(eipss.actual_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.891infoyii\db\Command::querySELECT SUM(cost) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.892infoyii\db\Command::querySELECT SUM(eipss.actual_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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.893infoyii\db\Command::querySELECT SUM(cost) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.893infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.894infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.895infoyii\db\Command::querySELECT SUM(eipss.actual_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.896infoyii\db\Command::querySELECT SUM(eipss.actual_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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:42.898infoyii\db\Command::querySELECT SUM(sub.amount) FROM ((SELECT r.amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 )) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:42.904infoyii\db\Command::querySELECT SUM(expense) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.905infoyii\db\Command::querySELECT SUM(wage) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.906infoyii\db\Command::querySELECT SUM(amount) FROM ((SELECT r.amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 )) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:42.909infoyii\db\Command::querySELECT SUM(expense) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.910infoyii\db\Command::querySELECT SUM(wage) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')
14:04:42.910infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=15) AND ("is_system"=TRUE)
14:04:42.911infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=385 ORDER BY "is_delete", "sort"
14:04:42.912infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 426, 427, 428, 425, 429, 432, 433, 434, 435, 438, 440)) GROUP BY "id"
14:04:42.930infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 426, 427, 428, 425, 429, 432, 433, 434, 435, 438, 440)) GROUP BY "id"
14:04:42.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 385) AND ("term_id"=15)
14:04:43.002infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id" IN (406, 417, 412, 436, 185, 419, 198, 196, 197, 184, 183, 205, 307, 415, 308) ORDER BY "is_delete", "sort"
14:04:43.014infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) GROUP BY "id"
14:04:43.027infoyii\db\Command::querySELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) AND ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) GROUP BY "id"
14:04:43.038infoyii\db\Command::querySELECT SUM(sub.amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:43.049infoyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) 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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.068infoyii\db\Command::querySELECT SUM(personal_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.097infoyii\db\Command::querySELECT 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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.110infoyii\db\Command::querySELECT SUM(amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:43.121infoyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) 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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.131infoyii\db\Command::querySELECT SUM(personal_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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.140infoyii\db\Command::querySELECT 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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.149infoyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) 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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.158infoyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) 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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.167infoyii\db\Command::querySELECT SUM(company_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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.176infoyii\db\Command::querySELECT SUM(company_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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
14:04:43.185infoyii\db\Command::querySELECT SUM(sub.amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:43.195infoyii\db\Command::querySELECT SUM(amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')
14:04:43.208traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:43.211traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:04:43.215infoyii\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/erp-analysis/list-profit-a-loss', '{"year":"2026","month":"6","hide":"1"}', '{"code":2000,"result":{"list":[{"title":"\u6536\u5165\u7c7b","type":"total_in","amount":-17999,"all_amount":20853830.69,"type_id":"","child_type_id":"","index":1},{"title":"\u9500\u552e\u6536\u5165","type":"sales_amount","amount":-17999,"all_amount":20263012.2,"type_id":"","child_type_id":"","index":2},{"title":"\u5546\u54c1\u7c7b\u6536\u5165","type":"inventory_build","amount":0,"all_amount":530893,"type_id":"","child_type_id":"","index":2},{"title":"\u5176\u4ed6\u6536\u5165","type":"other_income","amount":0,"all_amount":59925.49,"type_id":"","child_type_id":"","index":2},{"title":"\u652f\u51fa\u7c7b","type":"total_out","type_id":"","child_type_id":"","amount":871378,"all_amount":8273280.7183333,"index":1},{"title":"\u9500\u552e\u6210\u672c","type":"sales_cost","type_id":"","child_type_id":"","amount":888,"all_amount":6140583.235,"index":2},{"title":"\u5546\u54c1\u7c7b\u652f\u51fa","type":"product_out","type_id":"","child_type_id":"","amount":232323,"all_amount":394849.83333333,"index":2},{"title":"\u8d39\u7528\u5408\u8ba1","type":"total_cost","type_id":"","child_type_id":"","amount":638167,"all_amount":1737847.65,"index":2},{"title":"\u5229\u6da6","type":"profit","type_id":"","child_type_id":"","amount":-889377,"all_amount":12580549.971667,"index":1}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-26 14:04:43', 394819072) RETURNING "id"
14:04:43.233traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:04:43.237traceyii\redis\Connection::executeCommandExecuting Redis Command: SET