ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a207b069d55e: POST https://beta.jinchangxiao.com/vue/sales-order-item/list at 2026-06-04 03:05:42 am by 43.224.72.82

Log Messages

总计64条数据
TimeLevelCategoryMessage
 
03:05:42.644traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
03:05:42.644traceyii\base\Module::getModuleLoading module: debug
03:05:42.644traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
03:05:42.644traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
03:05:42.644traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
03:05:42.645traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.645infotime tracing start1780513542645602048
03:05:42.645traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
03:05:42.645traceyii\web\Application::handleRequestRoute requested: 'vue/sales-order-item/list'
03:05:42.645traceyii\base\Module::getModuleLoading module: vue
03:05:42.701infoyii\web\Session::openSession started
03:05:42.702infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5495
03:05:42.702infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
03:05:42.703traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.703traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
03:05:42.704traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.704traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
03:05:42.704infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
03:05:42.705traceyii\base\Controller::runActionRoute to run: vue/sales-order-item/list
03:05:42.705traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSalesOrder
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
03:05:42.706traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
03:05:42.706traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SalesOrderItemController::actionList()
03:05:42.706traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.706traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
03:05:42.709traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.709traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.711infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT DISTINCT s.* FROM "o6a13e2c574d5a"."tbl_sales_order_items" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "o6a13e2c574d5a"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "o6a13e2c574d5a"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep"=5493) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC) "c"
03:05:42.717infoyii\db\Command::querySELECT DISTINCT s.* FROM "o6a13e2c574d5a"."tbl_sales_order_items" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "client" ON client.id = s.client_id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = client.sales_rep LEFT JOIN "o6a13e2c574d5a"."tbl_users" "salesRep" ON "salesRep"."id" = "client"."sales_rep" LEFT JOIN "o6a13e2c574d5a"."tbl_products" "product" ON "product"."id" = "product_id" LEFT JOIN "o6a13e2c574d5a"."tbl_projects" "project" ON "project"."id" = "s"."project_id" LEFT JOIN "o6a13e2c574d5a"."tbl_suppliers" "supplier" ON "supplier"."id" = "supplier_id" LEFT JOIN "o6a13e2c574d5a"."tbl_sales_order_item_renew_logs" "log" ON log.sales_order_item_id = s.id WHERE ("client"."deleted"=FALSE) AND (("client"."sales_rep"=5493) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "s"."id" ORDER BY "s"."updated_at" DESC LIMIT 20
03:05:42.721infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
03:05:42.721infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
03:05:42.722infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
03:05:42.723infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1
03:05:42.723infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_products" WHERE "id"=1
03:05:42.724infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_types" WHERE "id"=1
03:05:42.724infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_components" WHERE "id"=1
03:05:42.725infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_brands" WHERE "id"=1
03:05:42.725infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_product_series" WHERE "id"=1
03:05:42.726infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_suppliers" WHERE "id"=1
03:05:42.726infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
03:05:42.727infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
03:05:42.728infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=1
03:05:42.729infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id"=1
03:05:42.729infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
03:05:42.730infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
03:05:42.730infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id"=1 ORDER BY "sales_date", "created_at"
03:05:42.731infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id"=1)
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateSalesOrder
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: deleteSalesOrder
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSalesOrder
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
03:05:42.731traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Treasurer
03:05:42.731traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.735traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
03:05:42.735infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/sales-order-item/list', '{"is_all":"0","except":"","from_project":"1","SalesOrderItemSearch":{"group":"","sales_rep":"","sn":"","created_by":"","is_merge":"","is_renew":"","renew_to_sales_order_item_id":"","client_id":"","project_id":""},"hardware_period":"","software_period":"","maintenance_period":"","Filter":{"name":"updated_at","sort":"DESC"},"page":"1","web_access_token":"y5bkfO5HuIJNqY-Jlz2UmvGim2HR_PGe"}', '{"code":2000,"result":{"list":[{"id":1,"sales_order_id":"","product_id":1,"parent":"","sn":"","supplier_id":1,"order":0,"created_by":5493,"created_at":"2026-06-01 15:19:56","updated_at":"2026-06-01 15:19:56","pn":"","product_type":"","product_component":"","product_brand":"","product_serie":"","product_misc":"","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","new_hardware_deadline":"","new_software_deadline":"","new_maintenance_deadline":"","client_id":1,"project_id":1,"sales_rep":5493,"sales_date":"2026-06-01","description":"","software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"10000","cost":"","is_renew":false,"renew_to_sales_order_item_id":"","number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":1,"erp_sales_gift_id":"","client":{"id":1,"key":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","sales_rep":5493,"logo":"","salesRep":{"id":5493,"key":5493,"name":"97289742","avatar":{}}},"project":{"id":1,"key":1,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260527001"},"product":{"id":1,"name":"\u6df1\u4fe1\u670d AF-1210-A","product_type":1,"product_component":1,"product_brand":1,"product_serie":1,"product_misc":"","product_qa":"","pn":"","description":"","created_by":5493,"created_at":"2026-05-25 13:48:53","updated_at":"2026-06-01 15:21:10","pinyin_shortcut":"","product_unit":"","is_renew":false,"in_out_at":"2026-06-01 15:21:10.749785+08","productType":{"id":1,"key":1,"name":"\u9632\u706b\u5899"},"productComponent":{"id":1,"key":1,"name":"\u786c\u4ef6\u4e3b\u673a"},"productBrand":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1,"key":1,"name":"\u6df1\u4fe1\u670dAF-1210"}},"supplier":{"id":1,"key":1,"name":"\u91c7\u8d2d\u903b\u8f91-\u5546\u52a1\u4e13\u5458"},"createdBy":{"id":5493,"key":5493,"name":"97289742","sex":"M","department_id":1,"avatar":{},"department":{"id":1,"key":1,"name":"\u603b\u7ecf\u7406"}},"salesOrderItemRemindReceivers":[{"id":1,"sales_order_item_id":1,"user_id":5493,"user":{"id":5493,"key":5493,"name":"97289742","sex":"M","avatar":{}}}],"renewLogs":[],"files":[],"renewToSalesOrderItem":{},"can_update":true,"can_delete":false,"bgcolor":"#89c541"}],"can_create":true,"can_update":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 03:05:42', 89893120) RETURNING "id"
03:05:42.737traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
03:05:42.737traceyii\redis\Connection::executeCommandExecuting Redis Command: SET