ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a4909bf40a19: POST https://beta.jinchangxiao.com/vue/erp-purchase-inbound/save-sn at 2026-07-04 09:25:19 pm by 111.194.208.14

Log Messages

总计148条数据
TimeLevelCategoryMessage
 
21:25:19.263traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
21:25:19.263traceyii\base\Module::getModuleLoading module: debug
21:25:19.264traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
21:25:19.265traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
21:25:19.265traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
21:25:19.265traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.265infotime tracing start1783171519265964032
21:25:19.266traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
21:25:19.266traceyii\web\Application::handleRequestRoute requested: 'vue/erp-purchase-inbound/save-sn'
21:25:19.266traceyii\base\Module::getModuleLoading module: vue
21:25:19.267infoyii\web\Session::openSession started
21:25:19.268infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5064
21:25:19.268infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:25:19.270traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.270traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.271infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
21:25:19.272traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.272traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.273infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
21:25:19.273traceyii\base\Controller::runActionRoute to run: vue/erp-purchase-inbound/save-sn
21:25:19.274traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.276traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
21:25:19.276traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpPurchaseInboundController::actionSaveSn()
21:25:19.276infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"='26'
21:25:19.277traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.277traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.277traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewErpPurchaseInbound
21:25:19.277traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
21:25:19.277traceyii\db\Transaction::beginBegin transaction
21:25:19.277traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.278traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.278infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=42
21:25:19.278infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=42
21:25:19.279traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.279traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.279infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (42, '申请类型'), (42, '提前开发票申请'), (42, '付款申请'), (42, '正常开票'), (42, '其他'), (42, '请假申请'), (42, '正常备货'), (42, '0出库申请'), (42, '提前备货申请')
21:25:19.280infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1
21:25:19.281infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=43
21:25:19.281infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=43
21:25:19.282infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" ("erp_purchase_inbound_product_id", "sn") VALUES (43, '79'), (43, '78'), (43, '77')
21:25:19.282infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1
21:25:19.283infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=44
21:25:19.283infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=44
21:25:19.283infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE 0=1
21:25:19.284infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_inbound_id"=26
21:25:19.284infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=42
21:25:19.285traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.285traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.285infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='150' WHERE "id"=93
21:25:19.286traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.286traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.287infoyii\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', 93, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.288infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=42
21:25:19.288infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=93) AND ("erp_purchase_inbound_product_sn_id" NOT IN (58, 59, 60, 61, 62, 63, 64, 65, 66))
21:25:19.289infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=93
21:25:19.289traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.289traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.290infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 58, '申请类型') RETURNING "id"
21:25:19.292infoyii\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', 71, 'a:27:{s:2:"id";i:71;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:58;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;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')
21:25:19.292infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 59, '提前开发票申请') RETURNING "id"
21:25:19.293infoyii\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', 72, 'a:27:{s:2:"id";i:72;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:59;s:2:"sn";s:21:"提前开发票申请";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;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')
21:25:19.293infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 60, '付款申请') RETURNING "id"
21:25:19.294infoyii\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', 73, 'a:27:{s:2:"id";i:73;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:60;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;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')
21:25:19.294infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 61, '正常开票') RETURNING "id"
21:25:19.295infoyii\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', 74, 'a:27:{s:2:"id";i:74;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:61;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;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')
21:25:19.296infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 62, '其他') RETURNING "id"
21:25:19.296infoyii\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', 75, 'a:27:{s:2:"id";i:75;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:62;s:2:"sn";s:6:"其他";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;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')
21:25:19.297infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 63, '请假申请') RETURNING "id"
21:25:19.298infoyii\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', 76, 'a:27:{s:2:"id";i:76;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:63;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;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')
21:25:19.298infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 64, '正常备货') RETURNING "id"
21:25:19.299infoyii\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', 77, 'a:27:{s:2:"id";i:77;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:64;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;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')
21:25:19.299infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 65, '0出库申请') RETURNING "id"
21:25:19.300infoyii\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', 78, 'a:27:{s:2:"id";i:78;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:65;s:2:"sn";s:13:"0出库申请";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;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')
21:25:19.300infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (93, 66, '提前备货申请') RETURNING "id"
21:25:19.301infoyii\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', 79, 'a:27:{s:2:"id";i:79;s:24:"erp_inventory_product_id";i:93;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:66;s:2:"sn";s:18:"提前备货申请";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;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')
21:25:19.301infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=93
21:25:19.302infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=93
21:25:19.304infoyii\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', 93, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.305infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
21:25:19.305traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.305traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.306infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
21:25:19.306infoyii\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', 93, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.307infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='10', "inventory"='0' WHERE "id"=42
21:25:19.307infoyii\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', 42, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.308infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=43
21:25:19.308infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='375' WHERE "id"=94
21:25:19.309infoyii\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', 94, 'a:1:{s:9:"inventory";s:1:"0";}', '', 1001, '111.194.208.14')
21:25:19.309infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=43
21:25:19.310infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=94) AND ("erp_purchase_inbound_product_sn_id" NOT IN (67, 68, 69))
21:25:19.310infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=94
21:25:19.310infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 67, '79') RETURNING "id"
21:25:19.311infoyii\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', 80, 'a:27:{s:2:"id";i:80;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:67;s:2:"sn";s:2:"79";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;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')
21:25:19.312infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 68, '78') RETURNING "id"
21:25:19.312infoyii\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', 81, 'a:27:{s:2:"id";i:81;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:68;s:2:"sn";s:2:"78";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;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')
21:25:19.313infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_erp_inventory_product_sns" ("erp_inventory_product_id", "erp_purchase_inbound_product_sn_id", "sn") VALUES (94, 69, '77') RETURNING "id"
21:25:19.313infoyii\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', 82, 'a:27:{s:2:"id";i:82;s:24:"erp_inventory_product_id";i:94;s:23:"erp_purchase_inbound_id";N;s:34:"erp_purchase_inbound_product_sn_id";i:69;s:2:"sn";s:2:"77";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;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')
21:25:19.314infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=94
21:25:19.314infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0' WHERE "id"=94
21:25:19.315infoyii\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', 94, 'a:1:{s:9:"inventory";i:0;}', '', 1001, '111.194.208.14')
21:25:19.315infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
21:25:19.316infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
21:25:19.316infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='0' WHERE "id"=94
21:25:19.317infoyii\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', 94, 'a:1:{s:19:"actual_total_amount";s:3:"0.0";}', '', 1001, '111.194.208.14')
21:25:19.318infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='10', "inventory"='0' WHERE "id"=43
21:25:19.318infoyii\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', 43, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.319infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_inbound_product_id"=44
21:25:19.320infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='10', "inventory"='10', "total_amount"='250' WHERE "id"=95
21:25:19.320infoyii\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', 95, 'a:1:{s:9:"inventory";s:1:"9";}', '', 1001, '111.194.208.14')
21:25:19.320infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_product_sns" WHERE "erp_purchase_inbound_product_id"=44
21:25:19.321infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=95)
21:25:19.321infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=95
21:25:19.322infoyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=95
21:25:19.322infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='9' WHERE "id"=95
21:25:19.323infoyii\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', 95, 'a:1:{s:9:"inventory";d:9;}', '', 1001, '111.194.208.14')
21:25:19.323infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type'
21:25:19.324infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point'
21:25:19.324infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "actual_total_amount"='225' WHERE "id"=95
21:25:19.325infoyii\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', 95, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.325infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_inbound_products" SET "outbound"='1', "inventory"='9' WHERE "id"=44
21:25:19.326infoyii\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', 44, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.326traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.327traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.327infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (1943, 1373, 1372)
21:25:19.328infoyii\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', 26, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.328infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='0', "number"='0', "actual_total_amount"='0' WHERE ("erp_purchase_inbound_id"=26) AND ("erp_purchase_inbound_product_id" NOT IN (42, 43, 44))
21:25:19.329infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_orders" WHERE "id"=2042
21:25:19.329traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.330traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.330infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_order_products" WHERE "erp_purchase_order_id"=2042
21:25:19.330traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.331traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.331infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "erp_purchase_order_product_id" IN (62, 63, 64)
21:25:19.332infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=26
21:25:19.332infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_return_products" WHERE "erp_purchase_inbound_product_id" IN (42, 44, 43)
21:25:19.333infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=62
21:25:19.334infoyii\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', 62, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.334infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=63
21:25:19.335infoyii\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', 63, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.335infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_erp_purchase_order_products" SET "into_inventory"='10' WHERE "id"=64
21:25:19.335infoyii\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', 64, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.336infoyii\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', 2042, 'a:0:{}', '', 1001, '111.194.208.14')
21:25:19.336traceyii\db\Transaction::commitCommit transaction
21:25:19.339traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.339traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:25:19.339infoyii\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-purchase-inbound/save-sn', '{"ErpPurchaseInbounds":{"erpPurchaseInboundProducts":{"42":{"product_id":"1943","number":"10","amount":"15","total_amount":"150","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"new":[{"sn":"\u7533\u8bf7\u7c7b\u578b"},{"sn":"\u63d0\u524d\u5f00\u53d1\u7968\u7533\u8bf7"},{"sn":"\u4ed8\u6b3e\u7533\u8bf7"},{"sn":"\u6b63\u5e38\u5f00\u7968"},{"sn":"\u5176\u4ed6"},{"sn":"\u8bf7\u5047\u7533\u8bf7"},{"sn":"\u6b63\u5e38\u5907\u8d27"},{"sn":"0\u51fa\u5e93\u7533\u8bf7"},{"sn":"\u63d0\u524d\u5907\u8d27\u7533\u8bf7"}]}},"43":{"product_id":"1373","number":"10","amount":"37.5","total_amount":"375","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":{"new":[{"sn":"79"},{"sn":"78"},{"sn":"77"}]}},"44":{"product_id":"1372","number":"10","amount":"25","total_amount":"250","erp_store_id":"1","description":"","erp_purchase_order_id":"","erp_purchase_order_product_id":"","sns":""}},"id":"26"},"web_access_token":"wx4hXh9V-DIrZeBjtGStxgwx5HvDWnxk"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u91c7\u8d2d\u5165\u5e93\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"111.194.208.14","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-07-04 21:25:19', 73641984) RETURNING "id"
21:25:19.341traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:25:19.341traceyii\redis\Connection::executeCommandExecuting Redis Command: SET