ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a64a9cc4d7: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-bank-view at 2026-06-11 03:32:57 pm by 221.216.117.119

Log Messages

总计41条数据
TimeLevelCategoryMessage
 
15:32:57.835traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:32:57.835traceyii\base\Module::getModuleLoading module: debug
15:32:57.836traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:32:57.837traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:32:57.837traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:32:57.837traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.837infotime tracing start1781163177837892096
15:32:57.838traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:32:57.838traceyii\web\Application::handleRequestRoute requested: 'vue/erp-analysis/list-bank-view'
15:32:57.838traceyii\base\Module::getModuleLoading module: vue
15:32:57.839infoyii\web\Session::openSession started
15:32:57.840infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:32:57.840infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:32:57.843traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.843traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:32:57.844traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.844traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:32:57.845infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:32:57.846traceyii\base\Controller::runActionRoute to run: vue/erp-analysis/list-bank-view
15:32:57.846traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.848traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:32:57.848traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAnalysisController::actionListBankView()
15:32:57.848traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.849traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.851infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC) "c"
15:32:57.854infoyii\db\Command::querySELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id" ORDER BY settle_at DESC LIMIT 40
15:32:57.855traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.855traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:32:57.856infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
15:32:57.857infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
15:32:57.857infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
15:32:57.858infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=100
15:32:57.858infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=2
15:32:57.858infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" WHERE "erp_bank_amount_change_log_id"=1646
15:32:57.859infoyii\db\Command::querySELECT SUM(in_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id") "c"
15:32:57.861infoyii\db\Command::querySELECT SUM(out_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='2') AND ("settle_at" >= '2026-01-01 00:00:00') AND ("settle_at" <= '2026-12-31 23:59:59') GROUP BY "l"."id") "c"
15:32:57.863traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.863traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:32:57.864infoyii\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-analysis/list-bank-view', '{"created_at_period":"currentfascalyear","not_zero":"","is_delete":"","erp_bank_id":"2","keyword":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"id":1646,"object_id":37,"ticket_type":20015,"serial_no":"QTSRD-20260320-00001","erp_bank_id":2,"wrote_date":"2026-03-20","status":2,"amount":"703.6","in_amount":"703.6","out_amount":"","balance_amount":"23097.26","supplier_id":100,"client_id":"","contact_id":"","user_id":"","abstract":"\u6536PA\u8fd4\u70b9\u6536\u5165\u7f8e\u5143102.49*6.865048","description":"","settle_at":"2026-03-20 15:10:12.595528+08","verify_at":"2026-03-20 15:12:48","created_by":5252,"created_at":"2026-03-20 15:10:12","updated_at":"2026-03-20 15:12:48","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"supplier":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"client":"","user":"","contact":"","erpBank":{"id":2,"key":2,"name":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495"},"handlers":[{"user":{"name":"\u516c\u53f8\u6536\u5165"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":100,"key":100,"name":"\u6d3e\u62d3\u7f51\u7edc(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"contract_no":"","settleTickets":[]}],"in_amount":"703.6","out_amount":"","pagenation":{"totalcount":1,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 15:32:57', 26012928) RETURNING "id"
15:32:57.866traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:32:57.866traceyii\redis\Connection::executeCommandExecuting Redis Command: SET