ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6943aa01206d5: POST https://beta.jinchangxiao.com/vue/erp-sales-gift/save-new-sn at 2025-12-18 03:15:13 pm by 223.72.15.22

Log Messages

总计86条数据
TimeLevelCategoryMessage
 
15:15:13.129traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:15:13.129traceyii\base\Module::getModuleLoading module: debug
15:15:13.129traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:15:13.133traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:15:13.133traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:15:13.136traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.138traceyii\base\Module::getModuleLoading module: gii
15:15:13.138traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:15:13.138traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:15:13.138traceyii\web\Application::handleRequestRoute requested: 'vue/erp-sales-gift/save-new-sn'
15:15:13.138traceyii\base\Module::getModuleLoading module: vue
15:15:13.139infoyii\web\Session::openSession started
15:15:13.140infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:15:13.140infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:15:13.169traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.172traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.174infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:15:13.182traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.183traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.183infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:15:13.189traceyii\base\Controller::runActionRoute to run: vue/erp-sales-gift/save-new-sn
15:15:13.189traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.195traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:15:13.195traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpSalesGiftController::actionSaveNewSn()
15:15:13.195infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='226'
15:15:13.196traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.196traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.197traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.197traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.197infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=171
15:15:13.200traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.200traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.200infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (171, '阿文企鹅')
15:15:13.212infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87
15:15:13.214traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.214traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.214infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=87
15:15:13.215infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.216infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='142', "inventory"='142', "total_amount"='143704' WHERE "id"=226
15:15:13.217traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.217traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.218infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:1:{s:9:"inventory";s:3:"139";}', '', 1001, '223.72.15.22')
15:15:13.219infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.220infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=226) AND ("erp_purchase_inbound_product_sn_id" NOT IN (13, 16))
15:15:13.221infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=226
15:15:13.221traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.221traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.222infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (226, 16, '阿文企鹅') RETURNING "id"
15:15:13.225infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpInventoryProductSns', 19, 'a:21:{s:2:"id";i:19;s:24:"erp_inventory_product_id";i:226;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:16;s:2:"sn";s:12:"阿文企鹅";s:7:"is_used";N;s:11:"description";N;s:22:"erp_inventory_start_id";N;s:33:"erp_inventory_start_product_sn_id";N;s:22:"erp_inventory_build_id";N;s:33:"erp_inventory_build_product_sn_id";N;s:26:"used_erp_inventory_lost_id";N;s:27:"used_erp_inventory_build_id";N;s:37:"used_erp_inventory_lost_product_sn_id";N;s:44:"used_erp_inventory_build_spent_product_sn_id";N;s:26:"used_erp_sales_outbound_id";N;s:43:"used_erp_sales_outbound_spent_product_sn_id";N;s:31:"erp_purchase_gift_product_sn_id";N;s:20:"erp_purchase_gift_id";N;s:22:"used_erp_sales_gift_id";N;s:39:"used_erp_sales_gift_spent_product_sn_id";N;}', '', 1001, '223.72.15.22')
15:15:13.226infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=226
15:15:13.227infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='139' WHERE "id"=226
15:15:13.228infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:1:{s:9:"inventory";d:139;}', '', 1001, '223.72.15.22')
15:15:13.229infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
15:15:13.230traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.231traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.231infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
15:15:13.231infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='140668' WHERE "id"=226
15:15:13.232infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpInventoryProducts', 226, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.234infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='3', "inventory"='139' WHERE "id"=171
15:15:13.235infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInboundProducts', 171, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.236traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.236traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.236infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id"=1624
15:15:13.238infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseInbounds', 87, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.239infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0' WHERE ("erp_purchase_inbound_id"=87) AND ("erp_purchase_inbound_product_id"<>171)
15:15:13.240infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2094
15:15:13.242traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.242traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.243infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2094
15:15:13.246traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.247traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.247infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id"=185
15:15:13.249infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=87
15:15:13.250infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id"=171
15:15:13.253infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='142' WHERE "id"=185
15:15:13.257infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrderProducts', 185, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.259infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpPurchaseOrders', 2094, 'a:0:{}', '', 1001, '223.72.15.22')
15:15:13.265traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.266traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.266infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-12-18')
15:15:13.276traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.277traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:15:13.277infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1056, "last_visit_at"='now()' WHERE "id"=59588
15:15:13.280infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-gift/save-new-sn', '{"id":"226","sns":["\u963f\u6587\u4f01\u9e45"],"web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 15:15:13') RETURNING "id"
15:15:13.283traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:15:13.283traceyii\redis\Connection::executeCommandExecuting Redis Command: SET