ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6863838fc2231: POST https://beta.jinchangxiao.com/v2/schedule/get-filter at 2025-07-01 02:43:27 pm by 223.104.41.148

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
14:43:27.794traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:43:27.794traceyii\base\Module::getModuleLoading module: debug
14:43:27.795traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:43:27.795traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:43:27.795traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:43:27.795traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.795traceyii\base\Module::getModuleLoading module: gii
14:43:27.795traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:43:27.796traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:43:27.796traceyii\web\Application::handleRequestRoute requested: 'v2/schedule/get-filter'
14:43:27.796traceyii\base\Module::getModuleLoading module: v2
14:43:27.796infoyii\web\Session::openSession started
14:43:27.797infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:43:27.799infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
14:43:27.803traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.803traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:43:27.803traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.803traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:43:27.803infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
14:43:27.805traceyii\base\Controller::runActionRoute to run: v2/schedule/get-filter
14:43:27.805traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSchedule
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
14:43:27.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
14:43:27.806traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ScheduleController::actionGetFilter()
14:43:27.807infoyii\db\Command::querySELECT distinct s.created_by FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE "ccr"."user_id"=5295
14:43:27.808traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.809traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.809infoyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
14:43:27.811infoyii\db\Command::querySELECT "d"."id" FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON u.department_id = d.id WHERE ("user_status"='1') AND (("u"."id" IN (5300, 5295, 5295)) OR ("u"."id"=5413)) GROUP BY "u"."id", "d"."id", "d"."order" ORDER BY "d"."order"
14:43:27.812infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 1) ORDER BY "order"
14:43:27.813infoyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
14:43:27.814infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND (("id" IN (5300, 5295, 5295)) OR ("id"=5413)) AND ("department_id"=1) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
14:43:27.814infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5300, 5295))
14:43:27.815traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:43:27.815traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:43:27.816infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1141, 'v2/schedule/get-filter', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1751352192","token":"e7a2a09547dddf3f47e675b00e6b7626","version_code":"1141"}', '{"code":200,"data":[{"key":"ScheduleSearch[status]","name":"\u72b6\u6001","value":[{"key":"completed","name":"\u5df2\u5b8c\u6210"},{"key":"ongoing","name":"\u8fdb\u884c\u4e2d"},{"key":"overdue","name":"\u5df2\u903e\u671f"}],"default":""},{"key":"ScheduleSearch[department_id]","name":"\u90e8\u95e8\/\u8d1f\u8d23\u4eba","value":[{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}]}],"default":5295,"itemKey":"ScheduleSearch[created_by]"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-01 14:43:27') RETURNING "id"