ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d32fd35935: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/list-export at 2026-06-01 03:21:33 pm by 43.224.72.82

Log Messages

总计88条数据
TimeLevelCategoryMessage
 
15:21:33.219traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:21:33.219traceyii\base\Module::getModuleLoading module: debug
15:21:33.219traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:21:33.219traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:21:33.219traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:21:33.219traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.219infotime tracing start1780298493219963136
15:21:33.220traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:21:33.220traceyii\web\Application::handleRequestRoute requested: 'vue/erp-sales-outbound/list-export'
15:21:33.220traceyii\base\Module::getModuleLoading module: vue
15:21:33.220infoyii\web\Session::openSession started
15:21:33.221infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5495
15:21:33.221infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:21:33.222traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.222traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:21:33.222traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.222traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:21:33.222infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
15:21:33.223traceyii\base\Controller::runActionRoute to run: vue/erp-sales-outbound/list-export
15:21:33.223traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.224traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:21:33.224traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewErpSalesOutbound
15:21:33.224traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:21:33.224traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
15:21:33.224traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpSalesOutboundController::actionListExport()
15:21:33.224traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.224traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:21:33.225traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'erp_store_id' in 'app\models\search\ErpSalesOutboundSearch'.
15:21:33.225traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.225traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:21:33.225infoyii\db\Command::querySELECT "s"."accessible_user" FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_visibles" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5495) AND (s.accessible_user IS NOT NULL) GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
15:21:33.226infoyii\db\Command::querySELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 5495 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 5495 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "r" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" "rvr" ON rvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" "rsvr" ON rsvr.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" "epop" ON epop.erp_sales_outbound_id = r.id LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=5495) OR ("r"."created_by"=5495) OR ("rvr"."user_id"=5495) OR ("r"."created_by" IN (5493, 5495, 5495))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=5495))) GROUP BY "r"."id" ORDER BY need_verify_sort asc, created_at DESC
15:21:33.228infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
15:21:33.228infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
15:21:33.229infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1
15:21:33.229infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
15:21:33.229infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
15:21:33.229infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1
15:21:33.230infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
15:21:33.230infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1
15:21:33.230infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name", "from_project", "erp_settle_amount", "erp_un_settle_amount" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project"=1
15:21:33.231infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_carbon_copy_rels" WHERE "erp_sales_outbound_id"=1
15:21:33.231infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id"
15:21:33.231infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id"
15:21:33.232infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id"
15:21:33.232infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1)
15:21:33.232infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20011) AND ("object_id"=1)
15:21:33.232infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=20012) AND ("object_id"=1)
15:21:33.233infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1
15:21:33.233infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=1
15:21:33.233infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "id"=1
15:21:33.233infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1
15:21:33.234infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1
15:21:33.234infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1
15:21:33.235infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1
15:21:33.235infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1
15:21:33.235infoyii\db\Command::querySELECT "eip"."product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" "eip" WHERE "product_id"=1 GROUP BY "eip"."product_id"
15:21:33.235infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=1
15:21:33.236infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1
15:21:33.236infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1
15:21:33.237infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1
15:21:33.237infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1
15:21:33.237infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1
15:21:33.237infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=1
15:21:33.238infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_product_spents" WHERE "erp_sales_outbound_spent_product_id"=1
15:21:33.238infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_inventory_products" WHERE "id"=4
15:21:33.239infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_purchase_inbounds" WHERE "id"=4
15:21:33.239infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_order_products" WHERE "id"=1
15:21:33.239infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id"=1
15:21:33.240infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" WHERE "id"=1
15:21:33.240infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE "erp_sales_outbound_id"=1 ORDER BY "id"
15:21:33.240infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_outbound_id"=1) ORDER BY "id"
15:21:33.240infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_outbound_id"=1) ORDER BY "id"
15:21:33.241infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5495) AND ("erp_sales_outbound_id"=1)
15:21:33.241infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_id"=1
15:21:33.241infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1
15:21:33.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1
15:21:33.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1
15:21:33.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1
15:21:33.242infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1
15:21:33.243infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=20008) AND ("object_id"=1) GROUP BY "object_id"
15:21:33.243infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "o6a13e2c574d5a"."tbl_unread_comments" WHERE ("object_type"=20008) AND (remind_user_id = 5495 AND is_read = false) AND ("object_id"=1) GROUP BY "object_id"
15:21:33.243traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createErpSalesReturn
15:21:33.243traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:21:33.243traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:21:33.244traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
15:21:33.244traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:21:33.244traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer