689954fb4d5d1: POST https://beta.jinchangxiao.com/vue/erp-inventory-product/product-list at 2025-08-11 10:27:07 am by 124.64.23.198
Log Messages
总计47条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 10:27:07.314 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 10:27:07.314 | trace | yii\base\Module::getModule | Loading module: debug |
| 10:27:07.316 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 10:27:07.317 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 10:27:07.317 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 10:27:07.317 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.317 | trace | yii\base\Module::getModule | Loading module: gii |
| 10:27:07.317 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 10:27:07.317 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 10:27:07.317 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-inventory-product/product-list' |
| 10:27:07.317 | trace | yii\base\Module::getModule | Loading module: vue |
| 10:27:07.322 | info | yii\web\Session::open | Session started |
| 10:27:07.337 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5016 |
| 10:27:07.337 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 10:27:07.373 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.375 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:27:07.375 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:27:07.376 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.377 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:27:07.377 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:27:07.382 | trace | yii\base\Controller::runAction | Route to run: vue/erp-inventory-product/product-list |
| 10:27:07.385 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.387 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 10:27:07.387 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpInventoryProductController::actionProductList() |
| 10:27:07.388 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.388 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:27:07.398 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id" ORDER BY p.updated_at DESC, p.id desc) "c" |
| 10:27:07.417 | info | yii\db\Command::query | SELECT "p".* FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id" ORDER BY p.updated_at DESC, p.id desc LIMIT 20 |
| 10:27:07.430 | info | yii\db\Command::query | SELECT "product_id", "erp_store_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(amount) as avg_amount, avg(amount * inventory) as avg_total_amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051) GROUP BY "product_id", "erp_store_id" |
| 10:27:07.436 | info | yii\db\Command::query | SELECT "product_id", sum(outbound) as outbound, sum(number) as number, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051) GROUP BY "product_id" |
| 10:27:07.437 | info | yii\db\Command::query | SELECT "product_id", sum(inventory) as inventory, avg(actual_amount) as avg_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051)) GROUP BY "product_id" |
| 10:27:07.438 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE (inventory > 0) AND ("product_id" IN (947, 2067, 2068, 2069, 2066, 2065, 2064, 2063, 2062, 2061, 2060, 2057, 2058, 2059, 2056, 2055, 2054, 2053, 2052, 2051)) |
| 10:27:07.439 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id" IN (5, 4, 2, 10, 12, 11, 3) |
| 10:27:07.439 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id" IN (35, 51, 23, 2, 199, 34, 22, 21, 19, 157, 36, 214, 26, 43, 154, 15, 135) |
| 10:27:07.440 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id" IN (8, 12, 4, 208, 20, 253, 21) |
| 10:27:07.440 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id" IN (806, 231, 172, 1671, 1670, 1669, 1668, 1667, 1666, 615, 1664, 1665, 1012, 1663, 1662, 1661, 1227, 1660) |
| 10:27:07.441 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id" IN (8, 2, 1, 3, 10, 4) |
| 10:27:07.442 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.443 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.444 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id" |
| 10:27:07.453 | info | yii\db\Command::query | SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id") "sub" |
| 10:27:07.455 | error | yii\db\Exception | PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "total_actual_amount" does not exist LINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)... ^ in /var/www/beta/vendor/yiisoft/yii2/db/Command.php:900 Stack trace: #0 /var/www/beta/vendor/yiisoft/yii2/db/Command.php(900): PDOStatement->execute() #1 /var/www/beta/vendor/yiisoft/yii2/db/Command.php(376): yii\db\Command->queryInternal('fetch', NULL) #2 /var/www/beta/vendor/yiisoft/yii2/db/Query.php(253): yii\db\Command->queryOne() #3 /var/www/beta/modules/vue/controllers/ErpInventoryProductController.php(554): yii\db\Query->one() #4 [internal function]: app\modules\vue\controllers\ErpInventoryProductController->actionProductList() #5 /var/www/beta/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array) #6 /var/www/beta/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array) #7 /var/www/beta/vendor/yiisoft/yii2/base/Module.php(522): yii\base\Controller->runAction('product-list', Array) #8 /var/www/beta/vendor/yiisoft/yii2/web/Application.php(102): yii\base\Module->runAction('vue/erp-invento...', Array) #9 /var/www/beta/vendor/yiisoft/yii2/base/Application.php(379): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 /var/www/beta/web/index.php(24): yii\base\Application->run() #11 {main} Next yii\db\Exception: SQLSTATE[42703]: Undefined column: 7 ERROR: column "total_actual_amount" does not exist LINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)... ^ The SQL being executed was: SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON p.product_brand = pb.id LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON p.product_type = pt.id LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON p.product_serie = ps.id LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON p.product_component = pc.id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.product_id = p.id GROUP BY "p"."id") "sub" in /var/www/beta/vendor/yiisoft/yii2/db/Schema.php:637 Stack trace: #0 /var/www/beta/vendor/yiisoft/yii2/db/Command.php(915): yii\db\Schema->convertException(Object(PDOException), 'SELECT sum(inve...') #1 /var/www/beta/vendor/yiisoft/yii2/db/Command.php(376): yii\db\Command->queryInternal('fetch', NULL) #2 /var/www/beta/vendor/yiisoft/yii2/db/Query.php(253): yii\db\Command->queryOne() #3 /var/www/beta/modules/vue/controllers/ErpInventoryProductController.php(554): yii\db\Query->one() #4 [internal function]: app\modules\vue\controllers\ErpInventoryProductController->actionProductList() #5 /var/www/beta/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array) #6 /var/www/beta/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array) #7 /var/www/beta/vendor/yiisoft/yii2/base/Module.php(522): yii\base\Controller->runAction('product-list', Array) #8 /var/www/beta/vendor/yiisoft/yii2/web/Application.php(102): yii\base\Module->runAction('vue/erp-invento...', Array) #9 /var/www/beta/vendor/yiisoft/yii2/base/Application.php(379): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 /var/www/beta/web/index.php(24): yii\base\Application->run() #11 {main} Additional Information: Array ( [0] => 42703 [1] => 7 [2] => ERROR: column "total_actual_amount" does not exist LINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)... ^ ) |
| 10:27:07.455 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.455 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 10:27:07.456 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (NULL, 'a57be577deb434', 1001, 5, 'vue/erp-inventory-product/product-list', '{"Filter":{"name":"updated_at","sort":"DESC"},"ErpProductSearch":{"erp_store_id":"","product_type":"","product_component":"","product_brand":"","product_serie":"","handler":"","number_range_to":"","number_range_from":"","inventory":""},"page":"1","web_access_token":"YkvMWkUL2263Z49tytqyBRm0LxFzf1j_"}', '{"code":"","data":null,"status":0,"msg":[{"name":"error","success":"","error":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^\nThe SQL being executed was: SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM \"a57be577deb434\".\"tbl_products\" \"p\" LEFT JOIN \"a57be577deb434\".\"tbl_product_brands\" \"pb\" ON p.product_brand = pb.id LEFT JOIN \"a57be577deb434\".\"tbl_product_types\" \"pt\" ON p.product_type = pt.id LEFT JOIN \"a57be577deb434\".\"tbl_product_series\" \"ps\" ON p.product_serie = ps.id LEFT JOIN \"a57be577deb434\".\"tbl_product_components\" \"pc\" ON p.product_component = pc.id LEFT JOIN \"a57be577deb434\".\"tbl_erp_inventory_products\" \"eip\" ON eip.product_id = p.id GROUP BY \"p\".\"id\") \"sub\"","trace":{"name":"Database Exception","message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^\nThe SQL being executed was: SELECT sum(inventory) as inventory, sum(total_actual_amount) as total_amount FROM (SELECT sum(eip.inventory) as inventory, sum(eip.actual_amount * eip.inventory) as total_amount FROM \"a57be577deb434\".\"tbl_products\" \"p\" LEFT JOIN \"a57be577deb434\".\"tbl_product_brands\" \"pb\" ON p.product_brand = pb.id LEFT JOIN \"a57be577deb434\".\"tbl_product_types\" \"pt\" ON p.product_type = pt.id LEFT JOIN \"a57be577deb434\".\"tbl_product_series\" \"ps\" ON p.product_serie = ps.id LEFT JOIN \"a57be577deb434\".\"tbl_product_components\" \"pc\" ON p.product_component = pc.id LEFT JOIN \"a57be577deb434\".\"tbl_erp_inventory_products\" \"eip\" ON eip.product_id = p.id GROUP BY \"p\".\"id\") \"sub\"","code":42703,"type":"yii\\db\\Exception","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Schema.php","line":637,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(915): yii\\db\\Schema->convertException(Object(PDOException), ''SELECT sum(inve...'')","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(376): yii\\db\\Command->queryInternal(''fetch'', NULL)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(253): yii\\db\\Command->queryOne()","#3 \/var\/www\/beta\/modules\/vue\/controllers\/ErpInventoryProductController.php(554): yii\\db\\Query->one()","#4 [internal function]: app\\modules\\vue\\controllers\\ErpInventoryProductController->actionProductList()","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''product-list'', Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-invento...'', Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#11 {main}"],"error-info":["42703",7,"ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^"],"previous":{"name":"Exception","message":"SQLSTATE[42703]: Undefined column: 7 ERROR: column \"total_actual_amount\" does not exist\nLINE 1: SELECT sum(inventory) as inventory, sum(total_actual_amount)...\n ^","code":"42703","type":"PDOException","file":"\/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php","line":900,"stack-trace":["#0 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(900): PDOStatement->execute()","#1 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Command.php(376): yii\\db\\Command->queryInternal(''fetch'', NULL)","#2 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/db\/Query.php(253): yii\\db\\Command->queryOne()","#3 \/var\/www\/beta\/modules\/vue\/controllers\/ErpInventoryProductController.php(554): yii\\db\\Query->one()","#4 [internal function]: app\\modules\\vue\\controllers\\ErpInventoryProductController->actionProductList()","#5 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/InlineAction.php(57): call_user_func_array(Array, Array)","#6 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Controller.php(156): yii\\base\\InlineAction->runWithParams(Array)","#7 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Module.php(522): yii\\base\\Controller->runAction(''product-list'', Array)","#8 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/web\/Application.php(102): yii\\base\\Module->runAction(''vue\/erp-invento...'', Array)","#9 \/var\/www\/beta\/vendor\/yiisoft\/yii2\/base\/Application.php(379): yii\\web\\Application->handleRequest(Object(yii\\web\\Request))","#10 \/var\/www\/beta\/web\/index.php(24): yii\\base\\Application->run()","#11 {main}"]}}}]}', TRUE, '2025-08-11 10:27:07') RETURNING "id" |
| 10:27:07.459 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 10:27:07.459 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |