ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6895c19197e4a: POST https://beta.jinchangxiao.com/vue/setting/list-erp-account-caption at 2025-08-08 05:21:21 pm by 124.64.23.198

Log Messages

总计62条数据
TimeLevelCategoryMessage
 
17:21:21.621traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:21:21.621traceyii\base\Module::getModuleLoading module: debug
17:21:21.622traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:21:21.622traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:21:21.622traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:21:21.622traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.622traceyii\base\Module::getModuleLoading module: gii
17:21:21.622traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:21:21.622traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:21:21.622traceyii\web\Application::handleRequestRoute requested: 'vue/setting/list-erp-account-caption'
17:21:21.622traceyii\base\Module::getModuleLoading module: vue
17:21:21.623infoyii\web\Session::openSession started
17:21:21.623infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:21:21.623infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:21:21.628traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.628traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:21.628traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.628traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:21.628infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:21:21.630traceyii\base\Controller::runActionRoute to run: vue/setting/list-erp-account-caption
17:21:21.630traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.631traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:21:21.631traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SettingController::actionListErpAccountCaption()
17:21:21.631infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"
17:21:21.633infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
17:21:21.633infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56)
17:21:21.634infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:21:21.634infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
17:21:21.635infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:21:21.635infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (54, 52, 53)
17:21:21.636infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:21:21.636infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
17:21:21.637infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:21:21.637infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410406
17:21:21.637traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.637traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:21.637infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410102
17:21:21.638infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410101
17:21:21.638infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.640infoyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.641infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.643infoyii\db\Command::querySELECT SUM(esrps.total_actual_amount) FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON esrps.erp_sales_return_id = t.id WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.648infoyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.649infoyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.650infoyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE "t"."status" IN (2, 5)
17:21:21.654infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.655infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.660infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.665infoyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.666traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.666traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.667traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.667traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:21.668infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-erp-account-caption', '{"is_delete":"","type":"3","keyword":"","page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":53,"parent_id":"","title":"\u5229\u6da6\u5206\u914d","serial_no":"4104","amount":"0","balance_amount":"0","actual_amount":90000,"description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[{"id":66,"parent_id":53,"title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"410406","amount":"90000","balance_amount":"90000","actual_amount":"90000","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":53,"parent_id":"","title":"\u5229\u6da6\u5206\u914d","serial_no":"4104","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":false,"can_start":false}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[{"id":67,"parent_id":54,"title":"\u4f18\u5148\u80a1","serial_no":"611601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":68,"parent_id":54,"title":"\u6c38\u7eed\u503a","serial_no":"611602","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":55,"parent_id":"","title":"\u5176\u4ed6\u7efc\u5408\u6536\u76ca","serial_no":"6111","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":56,"parent_id":"","title":"\u4e13\u9879\u50a8\u5907","serial_no":"4301","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":7,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:21:21') RETURNING "id"
17:21:21.670traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.670traceyii\db\Transaction::beginBegin transaction
17:21:21.671infoyii\db\Command::querySELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:141.0) Gecko/20100101 Firefox/141.0'
17:21:21.671traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:21:21.671traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:21:21.671infoyii\db\Command::executeUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=6800 WHERE "id"=154
17:21:21.672traceyii\db\Transaction::commitCommit transaction
17:21:21.673traceyii\redis\Connection::executeCommandExecuting Redis Command: SET