14:47:10.743 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
14:47:10.743 | trace | yii\base\Module::getModule | Loading module: debug |
14:47:10.743 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
14:47:10.744 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
14:47:10.744 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
14:47:10.745 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.745 | trace | yii\base\Module::getModule | Loading module: gii |
14:47:10.745 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
14:47:10.745 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
14:47:10.745 | trace | yii\web\Application::handleRequest | Route requested: 'v2/calendar/save-synchronize' |
14:47:10.745 | trace | yii\base\Module::getModule | Loading module: v2 |
14:47:10.746 | info | yii\web\Session::open | Session started |
14:47:10.746 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
14:47:10.752 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
14:47:10.756 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.756 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:47:10.757 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.757 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:47:10.757 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
14:47:10.762 | trace | yii\base\Controller::runAction | Route to run: v2/calendar/save-synchronize |
14:47:10.762 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.764 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
14:47:10.764 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\CalendarController::actionSaveSynchronize() |
14:47:10.764 | info | yii\db\Command::query | SELECT "system_calendar_id" FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) AND ("is_remind"=TRUE) |
14:47:10.768 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) AND ("system_calendar_id" NOT IN ('2774b13f-91ff-4813-87d5-a7d62d22d87d_65', '2774b13f-91ff-4813-87d5-a7d62d22d87d_67', '2774b13f-91ff-4813-87d5-a7d62d22d87d_258', '2774b13f-91ff-4813-87d5-a7d62d22d87d_259', '2774b13f-91ff-4813-87d5-a7d62d22d87d_262', '2774b13f-91ff-4813-87d5-a7d62d22d87d_264', '2774b13f-91ff-4813-87d5-a7d62d22d87d_268', '2774b13f-91ff-4813-87d5-a7d62d22d87d_269', '2774b13f-91ff-4813-87d5-a7d62d22d87d_270', '2774b13f-91ff-4813-87d5-a7d62d22d87d_271', '2774b13f-91ff-4813-87d5-a7d62d22d87d_274', '2774b13f-91ff-4813-87d5-a7d62d22d87d_275', '2774b13f-91ff-4813-87d5-a7d62d22d87d_301')) |
14:47:10.772 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND ("is_system"=TRUE) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.775 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_65') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.778 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_67') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.781 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_258') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.784 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_259') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.787 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_262') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.790 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_264') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.793 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_268') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.796 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_269') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.798 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_270') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.801 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_271') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.804 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_274') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.807 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_275') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.810 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_301') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) |
14:47:10.813 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.813 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:47:10.813 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_calendars" ("title", "start_at", "end_at", "alarm_before", "system_calendar_id", "is_public", "is_sync", "is_system", "is_remind", "created_by") VALUES ('哈哈哈哈', '2024-09-19 09:00:00', '2024-09-19 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_65', 0, TRUE, TRUE, FALSE, 1000), ('test', '2024-09-24 09:00:00', '2024-09-24 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_67', 0, TRUE, TRUE, FALSE, 1000), ('', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_258', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_259', 0, TRUE, TRUE, FALSE, 1000), ('test again', '2024-10-31 14:00:00', '2024-10-31 15:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_262', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_264', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-一级文档:hfjfjnf', '2024-12-13 14:00:00', '2024-12-13 16:00:00', '1800', '2774b13f-91ff-4813-87d5-a7d62d22d87d_268', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-二级文档:xvsdfsdfdsfdsfdsf', '2024-12-31 00:00:00', '2024-12-31 01:00:00', '900', '2774b13f-91ff-4813-87d5-a7d62d22d87d_269', 0, TRUE, TRUE, FALSE, 1000), ('咨询服务:发送范德萨', '2024-12-30 14:00:00', '2024-12-30 15:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_270', 0, TRUE, TRUE, FALSE, 1000), ('好吧宝贝', '2025-03-02 09:00:00', '2025-03-02 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_271', 0, TRUE, TRUE, FALSE, 1000), ('电话沟通项目进展', '2025-03-25 09:00:00', '2025-03-25 10:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_274', 0, TRUE, TRUE, FALSE, 1000), ('综合服务大半天:经常你从哪你', '2025-03-25 10:00:00', '2025-03-25 13:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_275', 0, TRUE, TRUE, FALSE, 1000), ('gvvh', '2025-04-21 09:00:00', '2025-04-21 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_301', 0, TRUE, TRUE, FALSE, 1000) |
14:47:10.835 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:47:10.838 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:47:10.839 | 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', 1000, 6, 165, 'v2/calendar/save-synchronize', '{"SynchronizeData":["{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_65\", \"Calendars[title]\": \"\u54c8\u54c8\u54c8\u54c8\",\n \"Calendars[start_at]\": \"2024-09-19 09:00:00\", \"Calendars[end_at]\": \"2024-09-19 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_67\", \"Calendars[title]\": \"test\",\n \"Calendars[start_at]\": \"2024-09-24 09:00:00\", \"Calendars[end_at]\": \"2024-09-24 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_258\", \"Calendars[title]\": \"\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_259\", \"Calendars[title]\": \"\u6d4b\u8bd5\u9e3f\u8499\u65e5\u7a0b\u540c\u6b65\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_262\", \"Calendars[title]\": \"test again\",\n \"Calendars[start_at]\": \"2024-10-31 14:00:00\", \"Calendars[end_at]\": \"2024-10-31 15:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_264\", \"Calendars[title]\": \"\u6d4b\u8bd5\u9e3f\u8499\u65e5\u7a0b\u540c\u6b65\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_268\", \"Calendars[title]\": \"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863:hfjfjnf\",\n \"Calendars[start_at]\": \"2024-12-13 14:00:00\", \"Calendars[end_at]\": \"2024-12-13 16:00:00\",\n \"Calendars[alarm_before]\": \"1800\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_269\", \"Calendars[title]\": \"\u6280\u672f\u65b9\u6848-\u4e8c\u7ea7\u6587\u6863:xvsdfsdfdsfdsfdsf\",\n \"Calendars[start_at]\": \"2024-12-31 00:00:00\", \"Calendars[end_at]\": \"2024-12-31 01:00:00\",\n \"Calendars[alarm_before]\": \"900\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_270\", \"Calendars[title]\": \"\u54a8\u8be2\u670d\u52a1:\u53d1\u9001\u8303\u5fb7\u8428\",\n \"Calendars[start_at]\": \"2024-12-30 14:00:00\", \"Calendars[end_at]\": \"2024-12-30 15:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_271\", \"Calendars[title]\": \"\u597d\u5427\u5b9d\u8d1d\",\n \"Calendars[start_at]\": \"2025-03-02 09:00:00\", \"Calendars[end_at]\": \"2025-03-02 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_274\", \"Calendars[title]\": \"\u7535\u8bdd\u6c9f\u901a\u9879\u76ee\u8fdb\u5c55\",\n \"Calendars[start_at]\": \"2025-03-25 09:00:00\", \"Calendars[end_at]\": \"2025-03-25 10:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_275\", \"Calendars[title]\": \"\u7efc\u5408\u670d\u52a1\u5927\u534a\u5929:\u7ecf\u5e38\u4f60\u4ece\u54ea\u4f60\",\n \"Calendars[start_at]\": \"2025-03-25 10:00:00\", \"Calendars[end_at]\": \"2025-03-25 13:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_301\", \"Calendars[title]\": \"gvvh\",\n \"Calendars[start_at]\": \"2025-04-21 09:00:00\", \"Calendars[end_at]\": \"2025-04-21 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}"],"posttime":"1751006831","access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"6","version_code":"165","token":"194f7352b677b620002f4dd3b305ce1e"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u65e5\u7a0b\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-06-27 14:47:10') RETURNING "id" |