68a6ca604eba3: POST https://beta.jinchangxiao.com/v2/calendar/list at 2025-08-21 03:27:28 pm by 223.104.41.143
Log Messages
总计76条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:27:28.317 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:27:28.317 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:27:28.318 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:27:28.322 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:27:28.322 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:27:28.327 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:28.328 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:27:28.328 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:27:28.328 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:27:28.328 | trace | yii\web\Application::handleRequest | Route requested: 'v2/calendar/list' |
| 15:27:28.328 | trace | yii\base\Module::getModule | Loading module: v2 |
| 15:27:30.500 | info | yii\web\Session::open | Session started |
| 15:27:30.501 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:27:30.506 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='tnwd0bCdPezg-JBOsRPBmnL0JfJg3LvK' |
| 15:27:30.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.510 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.511 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.511 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.511 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 15:27:30.514 | trace | yii\base\Controller::runAction | Route to run: v2/calendar/list |
| 15:27:30.515 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewCalendarMng |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:27:30.518 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 15:27:30.518 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\CalendarController::actionList() |
| 15:27:30.518 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.518 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.519 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'is_self' in 'app\models\search\CalendarSearch'. |
| 15:27:30.519 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.520 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.521 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "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" |
| 15:27:30.525 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 15:27:30.526 | info | yii\db\Command::query | SELECT "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" |
| 15:27:30.527 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "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"."id" |
| 15:27:30.528 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 15:27:30.529 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "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" |
| 15:27:30.530 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE (("user_status"='1') AND ("department_id"=1)) AND ("id"=5295) 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 |
| 15:27:30.531 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id"=1) ORDER BY "name" |
| 15:27:30.531 | info | yii\db\Command::query | SELECT "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" |
| 15:27:30.532 | info | yii\db\Command::query | SELECT s.id, s_at as start_at, e_at as end_at FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ((("s"."s_at" >= '2025-08-01 00:00:00') AND ("s"."e_at" < '2025-08-31 00:00:00')) OR (("s"."s_at" <= '2025-08-01 00:00:00') AND ("s"."e_at" > '2025-08-01 00:00:00')) OR (("s"."s_at" <= '2025-08-31 00:00:00') AND ("s"."e_at" > '2025-08-31 00:00:00'))) AND ("s"."created_by"=5295) |
| 15:27:30.535 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.535 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.537 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "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" |
| 15:27:30.540 | info | yii\db\Command::query | SELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-08-01 00:00:00') AND ("c"."end_at" < '2025-08-31 00:00:00')) OR (("c"."start_at" <= '2025-08-01 00:00:00') AND ("c"."end_at" > '2025-08-01 00:00:00')) OR (("c"."start_at" <= '2025-08-31 00:00:00') AND ("c"."end_at" > '2025-08-31 00:00:00'))) AND ("c"."created_by"=5295) AND ("c"."created_by"=5295) |
| 15:27:30.542 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "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"."id" |
| 15:27:30.543 | info | yii\db\Command::query | SELECT w.id, start_at, end_at FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by"=5295) AND ((w.start_at is not null) OR (w.end_at is not null)) AND ((("w"."start_at" >= '2025-08-01 00:00:00') AND ("w"."end_at" < '2025-08-31 00:00:00')) OR (("w"."start_at" <= '2025-08-01 00:00:00') AND ("w"."end_at" > '2025-08-01 00:00:00')) OR (("w"."start_at" <= '2025-08-31 00:00:00') AND ("w"."end_at" > '2025-08-31 00:00:00'))) AND ("w"."created_by"=5295) |
| 15:27:30.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.547 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.547 | info | yii\db\Command::query | SELECT "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" |
| 15:27:30.548 | info | yii\db\Command::query | SELECT s.id, s_at as start_at, e_at as end_at FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ("s"."created_by"=5295) AND (s.alarm_before is not null) |
| 15:27:30.550 | info | yii\db\Command::query | SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "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" |
| 15:27:30.551 | info | yii\db\Command::query | SELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-08-01 00:00:00') AND ("c"."end_at" < '2025-08-31 00:00:00')) OR (("c"."start_at" <= '2025-08-01 00:00:00') AND ("c"."end_at" > '2025-08-01 00:00:00')) OR (("c"."start_at" <= '2025-08-31 00:00:00') AND ("c"."end_at" > '2025-08-31 00:00:00'))) AND ("c"."created_by"=5295) AND ("c"."created_by"=5295) AND (c.alarm_before is not null) |
| 15:27:30.554 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT "s".* FROM ((SELECT w.id, wlso.name AS title, w.client_id, w.created_by, start_at, end_at, 3 AS type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by"=5295) AND ((("w"."start_at" >= '2025-08-21 00:00:00') AND ("w"."end_at" < '2025-08-21 23:59:59')) OR (("w"."start_at" <= '2025-08-21 00:00:00') AND ("w"."end_at" > '2025-08-21 00:00:00')) OR (("w"."start_at" <= '2025-08-21 23:59:59') AND ("w"."end_at" > '2025-08-21 23:59:59')))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ((("s"."s_at" >= '2025-08-21 00:00:00') AND ("s"."e_at" < '2025-08-21 23:59:59')) OR (("s"."s_at" <= '2025-08-21 00:00:00') AND ("s"."e_at" > '2025-08-21 00:00:00')) OR (("s"."s_at" <= '2025-08-21 23:59:59') AND ("s"."e_at" > '2025-08-21 23:59:59')))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 AS type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) AND ((("c"."start_at" >= '2025-08-21 00:00:00') AND ("c"."end_at" < '2025-08-21 23:59:59')) OR (("c"."start_at" <= '2025-08-21 00:00:00') AND ("c"."end_at" > '2025-08-21 00:00:00')) OR (("c"."start_at" <= '2025-08-21 23:59:59') AND ("c"."end_at" > '2025-08-21 23:59:59'))) AND ("c"."created_by"=5295) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=1) AND ("s"."created_by"=5295) AND ((("s"."start_at" >= '2025-08-21 00:00:00') AND ("s"."end_at" < '2025-08-21 23:59:59')) OR (("s"."start_at" <= '2025-08-21 00:00:00') AND ("s"."end_at" > '2025-08-21 00:00:00')) OR (("s"."start_at" <= '2025-08-21 23:59:59') AND ("s"."end_at" > '2025-08-21 23:59:59'))) ORDER BY "s"."start_at") "c" |
| 15:27:30.560 | info | yii\db\Command::query | SELECT "s".* FROM ((SELECT w.id, wlso.name AS title, w.client_id, w.created_by, start_at, end_at, 3 AS type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by"=5295) AND ((("w"."start_at" >= '2025-08-21 00:00:00') AND ("w"."end_at" < '2025-08-21 23:59:59')) OR (("w"."start_at" <= '2025-08-21 00:00:00') AND ("w"."end_at" > '2025-08-21 00:00:00')) OR (("w"."start_at" <= '2025-08-21 23:59:59') AND ("w"."end_at" > '2025-08-21 23:59:59')))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ((("s"."s_at" >= '2025-08-21 00:00:00') AND ("s"."e_at" < '2025-08-21 23:59:59')) OR (("s"."s_at" <= '2025-08-21 00:00:00') AND ("s"."e_at" > '2025-08-21 00:00:00')) OR (("s"."s_at" <= '2025-08-21 23:59:59') AND ("s"."e_at" > '2025-08-21 23:59:59')))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 AS type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) AND ((("c"."start_at" >= '2025-08-21 00:00:00') AND ("c"."end_at" < '2025-08-21 23:59:59')) OR (("c"."start_at" <= '2025-08-21 00:00:00') AND ("c"."end_at" > '2025-08-21 00:00:00')) OR (("c"."start_at" <= '2025-08-21 23:59:59') AND ("c"."end_at" > '2025-08-21 23:59:59'))) AND ("c"."created_by"=5295) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=1) AND ("s"."created_by"=5295) AND ((("s"."start_at" >= '2025-08-21 00:00:00') AND ("s"."end_at" < '2025-08-21 23:59:59')) OR (("s"."start_at" <= '2025-08-21 00:00:00') AND ("s"."end_at" > '2025-08-21 00:00:00')) OR (("s"."start_at" <= '2025-08-21 23:59:59') AND ("s"."end_at" > '2025-08-21 23:59:59'))) ORDER BY "s"."start_at" |
| 15:27:30.566 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 15:27:30.567 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 15:27:30.567 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) |
| 15:27:30.568 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (107, 2600, 1301, 31, 518, 2032, 3281) |
| 15:27:30.569 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1) |
| 15:27:30.569 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (17866, 17869, 17907, 17904, 17903, 17906, 17902, 17905)) |
| 15:27:30.571 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1) |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createCalendarMng |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:27:30.571 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 15:27:30.572 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:27:30.572 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:27:30.572 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1148, 'v2/calendar/list', '{"CalendarSearch":{"date":"2025-08-21","is_self":"1"},"access_token":"tnwd0bCdPezg-JBOsRPBmnL0JfJg3LvK","device_type":"2","posttime":"1755761280","token":"f27c3e4a33c7be35bf44a543d208fd47","version_code":"1148"}', '{"code":200,"data":{"list":[{"id":17866,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u6807\uff1a\u4e86\u89e3\u5ba2\u6237\u6570\u5b57\u5316\u65b9\u6848\u7684\u6c9f\u901a\u60c5\u51b5","client_id":107,"created_by":5295,"start_at":"2025-06-29 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17869,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u6807\uff1a\u7ed9\u5ba2\u6237\u51fa\u6d6a\u6f6e\u670d\u52a1\u5668\u914d\u7f6e\u548c\u4ef7\u683c","client_id":2600,"created_by":5295,"start_at":"2025-06-29 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":2600,"key":2600,"name":"\u822a\u5929\u79d1\u5de5\uff08\u5317\u4eac\uff09\u7a7a\u95f4\u4fe1\u606f\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17907,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u6807\uff1a\u7ed9\u5ba2\u6237\u51fa\u4f20\u7edf\u65b9\u6848\u4ea7\u54c1\u8bbe\u5907\u62a5\u4ef7","client_id":1301,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17904,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u63a8\u52a8\u6210\u4ea4\n\u76ee\u6807\uff1a\u63a8\u52a8\u5408\u540c\u7b7e\u8ba2\u6d41\u7a0b","client_id":31,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17903,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u63a8\u52a8\u6210\u4ea4\n\u76ee\u6807\uff1a\u7b49\u5f85\u5ba2\u6237\u518d\u6b21\u63d0\u91c7\u8d2d\u7533\u8bf7","client_id":31,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17906,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u63a8\u52a8\u6210\u4ea4\n\u76ee\u6807\uff1a\u4e86\u89e3\u7814\u53d1\u90e8\u95e8\u662f\u5426\u505a\u4ea7\u54c1\u7eed\u4fdd","client_id":518,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17902,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u63a8\u52a8\u6210\u4ea4\n\u76ee\u6807\uff1a\u7ed9\u5ba2\u6237\u63d0\u4f9b\u5408\u540c\uff0c\u8ddf\u8fdb\u5408\u540c\u7b7e\u8ba2","client_id":2032,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8)","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17905,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u6807\uff1a\u7ed9\u5ba2\u6237\u53d1\u62a5\u4ef7\u548c\u5408\u540c","client_id":3281,"created_by":5295,"start_at":"2025-08-10 00:00:00","end_at":"2025-08-21 15:27:30","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"15:27","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-08-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":true},{"edate":"2025-08-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-03","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-04","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-05","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-06","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-07","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-08","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-09","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-10","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-11","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-12","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-13","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-14","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-15","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-16","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-17","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-18","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-19","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-20","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-21","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-08-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-08-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[{"edate":"2025-08-01","is_alarm":false},{"edate":"2025-08-02","is_alarm":false},{"edate":"2025-08-03","is_alarm":false},{"edate":"2025-08-04","is_alarm":false},{"edate":"2025-08-05","is_alarm":false},{"edate":"2025-08-06","is_alarm":false},{"edate":"2025-08-07","is_alarm":false},{"edate":"2025-08-08","is_alarm":false},{"edate":"2025-08-09","is_alarm":false},{"edate":"2025-08-10","is_alarm":false},{"edate":"2025-08-11","is_alarm":false},{"edate":"2025-08-12","is_alarm":false},{"edate":"2025-08-13","is_alarm":false},{"edate":"2025-08-14","is_alarm":false},{"edate":"2025-08-15","is_alarm":false},{"edate":"2025-08-16","is_alarm":false},{"edate":"2025-08-17","is_alarm":false},{"edate":"2025-08-18","is_alarm":false},{"edate":"2025-08-19","is_alarm":false},{"edate":"2025-08-20","is_alarm":false},{"edate":"2025-08-21","is_alarm":false},{"edate":"2025-08-22","is_alarm":false},{"edate":"2025-08-23","is_alarm":false},{"edate":"2025-08-24","is_alarm":false},{"edate":"2025-08-25","is_alarm":false},{"edate":"2025-08-26","is_alarm":false},{"edate":"2025-08-27","is_alarm":false},{"edate":"2025-08-28","is_alarm":false},{"edate":"2025-08-29","is_alarm":false},{"edate":"2025-08-30","is_alarm":false},{"edate":"2025-08-31","is_alarm":false}],"pagenation":{"totalcount":8,"thispage":1,"pagesize":-1},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-21 15:27:30') RETURNING "id" |