| 22:59:26.546 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 22:59:26.546 | trace | yii\base\Module::getModule | Loading module: debug |
| 22:59:26.547 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 22:59:26.547 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 22:59:26.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 22:59:26.548 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.548 | info | time tracing start | 1783090766548563968 |
| 22:59:26.548 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 22:59:26.548 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-sales-outbound/save-new-sn' |
| 22:59:26.548 | trace | yii\base\Module::getModule | Loading module: vue |
| 22:59:26.550 | info | yii\web\Session::open | Session started |
| 22:59:26.551 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 22:59:26.551 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 22:59:26.553 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.553 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.553 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.554 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.554 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 22:59:26.555 | trace | yii\base\Controller::runAction | Route to run: vue/erp-sales-outbound/save-new-sn |
| 22:59:26.556 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.557 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 22:59:26.558 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpSalesOutboundController::actionSaveNewSn() |
| 22:59:26.558 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"='517' |
| 22:59:26.558 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.559 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.559 | info | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=517 |
| 22:59:26.559 | trace | yii\db\Transaction::begin | Begin transaction |
| 22:59:26.560 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.560 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.560 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "id"=28 |
| 22:59:26.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.561 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.561 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_purchase_gift_product_sns" ("erp_purchase_gift_product_id", "sn") VALUES (28, '222') |
| 22:59:26.562 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gifts" WHERE "id"=24 |
| 22:59:26.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.562 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.562 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE "erp_purchase_gift_id"=24 |
| 22:59:26.563 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=26 |
| 22:59:26.564 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=515 |
| 22:59:26.565 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.565 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.565 | info | yii\db\Command::execute | INSERT 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.565 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=26 |
| 22:59:26.566 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=515) |
| 22:59:26.566 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=515 |
| 22:59:26.567 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=515 |
| 22:59:26.567 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=515 |
| 22:59:26.568 | info | yii\db\Command::execute | INSERT 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.568 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.569 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.569 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.569 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.570 | info | yii\db\Command::execute | INSERT 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.570 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=26 |
| 22:59:26.571 | info | yii\db\Command::execute | INSERT 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.571 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=29 |
| 22:59:26.572 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=518 |
| 22:59:26.572 | info | yii\db\Command::execute | INSERT 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.573 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=29 |
| 22:59:26.573 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=518) |
| 22:59:26.574 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=518 |
| 22:59:26.574 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=518 |
| 22:59:26.575 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=518 |
| 22:59:26.575 | info | yii\db\Command::execute | INSERT 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.576 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.576 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.577 | info | yii\db\Command::execute | INSERT 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.577 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=29 |
| 22:59:26.577 | info | yii\db\Command::execute | INSERT 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.578 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=30 |
| 22:59:26.579 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=519 |
| 22:59:26.579 | info | yii\db\Command::execute | INSERT 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.580 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=30 |
| 22:59:26.580 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=519) |
| 22:59:26.580 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=519 |
| 22:59:26.581 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=519 |
| 22:59:26.581 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=519 |
| 22:59:26.582 | info | yii\db\Command::execute | INSERT 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.582 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.583 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.583 | info | yii\db\Command::execute | INSERT 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.584 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=30 |
| 22:59:26.584 | info | yii\db\Command::execute | INSERT 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.584 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=31 |
| 22:59:26.585 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=520 |
| 22:59:26.586 | info | yii\db\Command::execute | INSERT 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.586 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=31 |
| 22:59:26.586 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=520) |
| 22:59:26.587 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=520 |
| 22:59:26.587 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=520 |
| 22:59:26.588 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=520 |
| 22:59:26.588 | info | yii\db\Command::execute | INSERT 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.589 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.589 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.589 | info | yii\db\Command::execute | INSERT 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.590 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=31 |
| 22:59:26.590 | info | yii\db\Command::execute | INSERT 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.591 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=32 |
| 22:59:26.591 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=521 |
| 22:59:26.592 | info | yii\db\Command::execute | INSERT 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.592 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=32 |
| 22:59:26.593 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=521) |
| 22:59:26.593 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=521 |
| 22:59:26.593 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=521 |
| 22:59:26.594 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "outbound"='0' WHERE "id"=521 |
| 22:59:26.594 | info | yii\db\Command::execute | INSERT 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.595 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.595 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.596 | info | yii\db\Command::execute | INSERT 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.596 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "outbound"='0', "inventory"='66' WHERE "id"=32 |
| 22:59:26.597 | info | yii\db\Command::execute | INSERT 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.597 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=28 |
| 22:59:26.598 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='66', "inventory"='66', "total_amount"='0' WHERE "id"=517 |
| 22:59:26.598 | info | yii\db\Command::execute | INSERT 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.599 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=28 |
| 22:59:26.599 | info | yii\db\Command::execute | DELETE 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.600 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=517 |
| 22:59:26.600 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.600 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.601 | info | yii\db\Command::query | INSERT 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.601 | info | yii\db\Command::execute | INSERT 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.602 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=517 |
| 22:59:26.602 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='49' WHERE "id"=517 |
| 22:59:26.603 | info | yii\db\Command::execute | INSERT 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.603 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.604 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.604 | info | yii\db\Command::execute | INSERT 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.605 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='49' WHERE "id"=28 |
| 22:59:26.605 | info | yii\db\Command::execute | INSERT 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.605 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "erp_purchase_gift_product_id"=27 |
| 22:59:26.606 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "number"='666', "inventory"='666', "total_amount"='0' WHERE "id"=516 |
| 22:59:26.607 | info | yii\db\Command::execute | INSERT 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.607 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_product_sns" WHERE "erp_purchase_gift_product_id"=27 |
| 22:59:26.607 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE ("erp_inventory_product_id"=516) |
| 22:59:26.608 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_sns" WHERE "erp_inventory_product_id"=516 |
| 22:59:26.608 | info | yii\db\Command::query | SELECT SUM(outbound) FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_inventory_product_id"=516 |
| 22:59:26.609 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_inventory_products" SET "inventory"='658' WHERE "id"=516 |
| 22:59:26.609 | info | yii\db\Command::execute | INSERT 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.610 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_cost_type' |
| 22:59:26.610 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_settings" WHERE "setting_key"='erp_decimal_point' |
| 22:59:26.611 | info | yii\db\Command::execute | INSERT 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.611 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_purchase_gift_products" SET "inventory"='658' WHERE "id"=27 |
| 22:59:26.611 | info | yii\db\Command::execute | INSERT 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.612 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.612 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.612 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_products" SET "updated_at"='now()', "in_out_at"='now()' WHERE "id" IN (1558, 867, 2231, 969, 989, 870, 868) |
| 22:59:26.613 | info | yii\db\Command::execute | INSERT 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.614 | info | yii\db\Command::execute | UPDATE "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.614 | trace | yii\db\Transaction::commit | Commit transaction |
| 22:59:26.617 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.617 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 22:59:26.618 | info | yii\db\Command::query | INSERT 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.620 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 22:59:26.620 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |