ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686288249ab3b: POST https://beta.jinchangxiao.com/v2/schedule/list at 2025-06-30 08:50:44 pm by 183.221.113.44

Log Messages

总计73条数据
TimeLevelCategoryMessage
 
20:50:44.633traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
20:50:44.633traceyii\base\Module::getModuleLoading module: debug
20:50:44.633traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
20:50:44.633traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
20:50:44.633traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
20:50:44.633traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.634traceyii\base\Module::getModuleLoading module: gii
20:50:44.634traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
20:50:44.634traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
20:50:44.634traceyii\web\Application::handleRequestRoute requested: 'v2/schedule/list'
20:50:44.634traceyii\base\Module::getModuleLoading module: v2
20:50:44.634infoyii\web\Session::openSession started
20:50:44.635infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:50:44.637infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
20:50:44.643traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.643traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:50:44.644traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.644traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:50:44.644infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:50:44.646traceyii\base\Controller::runActionRoute to run: v2/schedule/list
20:50:44.646traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.647traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
20:50:44.647traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ScheduleController::actionList()
20:50:44.648traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.648traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:50:44.649traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.650traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.651infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
20:50:44.652infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1000)) AND ("u"."department_id"='10') AND ("s"."created_by"='5250') AND ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when s.is_complete = true then complete_at END desc, case when s.is_complete = false then end_at END asc, s.created_at DESC) "c"
20:50:44.656infoyii\db\Command::querySELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1000)) AND ("u"."department_id"='10') AND ("s"."created_by"='5250') AND ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when s.is_complete = true then complete_at END desc, case when s.is_complete = false then end_at END asc, s.created_at DESC LIMIT 10
20:50:44.658infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
20:50:44.658infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
20:50:44.659infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
20:50:44.659infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)
20:50:44.659infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
20:50:44.660infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=17688) GROUP BY "object_id"
20:50:44.678infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17688)
20:50:44.681infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
20:50:44.682infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)
20:50:44.682infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=17688
20:50:44.684infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
20:50:44.685infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)
20:50:44.686infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id"=17688)
20:50:44.688infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24679, 24680)
20:50:44.689infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17688
20:50:44.689infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17688 ORDER BY "created_at" DESC
20:50:44.691infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=17688) GROUP BY "object_id"
20:50:44.716traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateSchedule
20:50:44.716traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
20:50:44.716traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
20:50:44.716traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
20:50:44.716traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: deleteSchedule
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSchedule
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
20:50:44.717traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
20:50:44.717infoyii\db\Command::querySELECT "id", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"='5250'
20:50:44.718infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)
20:50:44.718traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20:50:44.718traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
20:50:44.719infoyii\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', 1000, 2, 1141, 'v2/schedule/list', '{"ScheduleSearch":{"created_by":"5250","department_id":"10","status":""},"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1751287808","token":"380fe1d3142dc44efca2ec11b4606c53","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":17688,"client_id":null,"schedule_title":"\u6d4b\u8bd5123","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5250,"created_at":"2025-04-30 15:22:04","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":5250,"project_id":null,"updated_at":"2025-05-08 09:42:20","set_top_at":null,"sort":1,"client":null,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17688,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"project":null,"headUsers":[{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}],"files":[{"id":33033,"object_type":32,"object_id":17688,"attachment_id":24679,"attachment":{"id":24679,"key":24679,"name":"f2b73bcc-78a2-3a58-90e8-72a918f28fc8","extension":"png","path":"\/v2\/attachment\/view\/rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u\/f2b73bcc-78a2-3a58-90e8-72a918f28fc8\/\u5fae\u4fe1\u56fe\u7247_20250508002011_2.png","orig_name":"\u5fae\u4fe1\u56fe\u7247_20250508002011_2.png"}},{"id":33034,"object_type":32,"object_id":17688,"attachment_id":24680,"attachment":{"id":24680,"key":24680,"name":"85b01b8c-1193-3f95-858a-564610f90c4c","extension":"jpeg","path":"\/v2\/attachment\/view\/rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u\/85b01b8c-1193-3f95-858a-564610f90c4c\/images.jpeg","orig_name":"images.jpeg"}}],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null}],"thisUser":{"id":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"pagenation":{"totalcount":1,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-30 20:50:44') RETURNING "id"