All Latest
6a47ce4e859ce: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/save-new-sn at 2026-07-03 10:59:26 pm by 111.194.208.14

Log Messages

总计154条数据
TimeLevelCategoryMessage
 
22:59:26.546traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
22:59:26.546traceyii\base\Module::getModuleLoading module: debug
22:59:26.547traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
22:59:26.547traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
22:59:26.547traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
22:59:26.548traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.548infotime tracing start1783090766548563968
22:59:26.548traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
22:59:26.548traceyii\web\Application::handleRequestRoute requested: 'vue/erp-sales-outbound/save-new-sn'
22:59:26.548traceyii\base\Module::getModuleLoading module: vue
22:59:26.550infoyii\web\Session::openSession started
22:59:26.551infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
22:59:26.551infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
22:59:26.553traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.553traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.553traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.554traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.554infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
22:59:26.555traceyii\base\Controller::runActionRoute to run: vue/erp-sales-outbound/save-new-sn
22:59:26.556traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.557traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
22:59:26.558traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpSalesOutboundController::actionSaveNewSn()
22:59:26.558infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='517'
22:59:26.558traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.559traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.559infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=517
22:59:26.559traceyii\db\Transaction::beginBegin transaction
22:59:26.560traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.560traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.560infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28
22:59:26.561traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.561traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.561infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_gift_product_sns" ("erp_purchase_gift_product_id", "sn") VALUES (28, '222')
22:59:26.562infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=24
22:59:26.562traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.562traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.562infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "erp_purchase_gift_id"=24
22:59:26.563infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=26
22:59:26.564infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=515
22:59:26.565traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.565traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.565infoyii\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', 515, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.565infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=26
22:59:26.566infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=515)
22:59:26.566infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=515
22:59:26.567infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=515
22:59:26.567infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=515
22:59:26.568infoyii\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', 515, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.568infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.569traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.569traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.569infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.570infoyii\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', 515, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.570infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=26
22:59:26.571infoyii\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\ErpPurchaseGiftProducts', 26, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.571infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=29
22:59:26.572infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=518
22:59:26.572infoyii\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', 518, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.573infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=29
22:59:26.573infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=518)
22:59:26.574infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=518
22:59:26.574infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=518
22:59:26.575infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=518
22:59:26.575infoyii\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', 518, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.576infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.576infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.577infoyii\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', 518, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.577infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=29
22:59:26.577infoyii\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\ErpPurchaseGiftProducts', 29, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.578infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=30
22:59:26.579infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=519
22:59:26.579infoyii\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', 519, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.580infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=30
22:59:26.580infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=519)
22:59:26.580infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=519
22:59:26.581infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=519
22:59:26.581infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=519
22:59:26.582infoyii\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', 519, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.582infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.583infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.583infoyii\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', 519, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.584infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=30
22:59:26.584infoyii\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\ErpPurchaseGiftProducts', 30, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.584infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=31
22:59:26.585infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=520
22:59:26.586infoyii\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', 520, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.586infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=31
22:59:26.586infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=520)
22:59:26.587infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=520
22:59:26.587infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=520
22:59:26.588infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=520
22:59:26.588infoyii\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', 520, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.589infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.589infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.589infoyii\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', 520, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.590infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=31
22:59:26.590infoyii\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\ErpPurchaseGiftProducts', 31, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.591infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=32
22:59:26.591infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=521
22:59:26.592infoyii\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', 521, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.592infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=32
22:59:26.593infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=521)
22:59:26.593infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=521
22:59:26.593infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=521
22:59:26.594infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=521
22:59:26.594infoyii\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', 521, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.595infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.595infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.596infoyii\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', 521, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.596infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=32
22:59:26.597infoyii\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\ErpPurchaseGiftProducts', 32, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.597infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=28
22:59:26.598infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=517
22:59:26.598infoyii\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', 517, 'a:1:{s:9:"inventory";s:2:"49";}', '', 1001, '111.194.208.14')
22:59:26.599infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=28
22:59:26.599infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=517) AND ("erp_purchase_gift_product_sn_id" NOT IN (2, 3))
22:59:26.600infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=517
22:59:26.600traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.600traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.601infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_gift_product_sn_id", "sn") VALUES (517, 3, '222') RETURNING "id"
22:59:26.601infoyii\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', 56, 'a:27:{s:2:"id";i:56;s:24:"erp_inventory_product_id";i:517;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";N;s:2:"sn";s:3:"222";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";i:3;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;s:28:"erp_inventory_disassemble_id";N;s:39:"erp_inventory_disassemble_product_sn_id";N;s:33:"used_erp_inventory_disassemble_id";N;s:50:"used_erp_inventory_disassemble_spent_product_sn_id";N;s:36:"erp_inventory_overflow_product_sn_id";N;s:25:"erp_inventory_overflow_id";N;}', '', 1001, '111.194.208.14')
22:59:26.602infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517
22:59:26.602infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='49' WHERE "id"=517
22:59:26.603infoyii\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', 517, 'a:1:{s:9:"inventory";d:49;}', '', 1001, '111.194.208.14')
22:59:26.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.604infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.604infoyii\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', 517, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.605infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='49' WHERE "id"=28
22:59:26.605infoyii\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\ErpPurchaseGiftProducts', 28, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.605infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=27
22:59:26.606infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='666', "inventory"='666', "total_amount"='0' WHERE "id"=516
22:59:26.607infoyii\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', 516, 'a:1:{s:9:"inventory";s:3:"658";}', '', 1001, '111.194.208.14')
22:59:26.607infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=27
22:59:26.607infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=516)
22:59:26.608infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=516
22:59:26.608infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516
22:59:26.609infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='658' WHERE "id"=516
22:59:26.609infoyii\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', 516, 'a:1:{s:9:"inventory";d:658;}', '', 1001, '111.194.208.14')
22:59:26.610infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
22:59:26.610infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
22:59:26.611infoyii\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', 516, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.611infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='658' WHERE "id"=27
22:59:26.611infoyii\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\ErpPurchaseGiftProducts', 27, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.612traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.612traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.612infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (1558, 867, 2231, 969, 989, 870, 868)
22:59:26.613infoyii\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\ErpPurchaseGifts', 24, 'a:0:{}', '', 1001, '111.194.208.14')
22:59:26.614infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_gift_id"=24) AND ("erp_purchase_gift_product_id" NOT IN (26, 29, 30, 31, 32, 28, 27))
22:59:26.614traceyii\db\Transaction::commitCommit transaction
22:59:26.617traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.617traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
22:59:26.618infoyii\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-sales-outbound/save-new-sn', '{"id":"517","sns":["222"]}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"111.194.208.14","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-07-03 22:59:26', 69541888) RETURNING "id"
22:59:26.620traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22:59:26.620traceyii\redis\Connection::executeCommandExecuting Redis Command: SET