22:20:08.165 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
22:20:08.165 | trace | yii\base\Module::getModule | Loading module: debug |
22:20:08.166 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
22:20:08.166 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
22:20:08.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
22:20:08.170 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.171 | trace | yii\base\Module::getModule | Loading module: gii |
22:20:08.171 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
22:20:08.171 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
22:20:08.171 | trace | yii\web\Application::handleRequest | Route requested: 'v2/user/get-index' |
22:20:08.171 | trace | yii\base\Module::getModule | Loading module: v2 |
22:20:08.252 | info | yii\web\Session::open | Session started |
22:20:08.252 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
22:20:08.256 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u' |
22:20:08.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
22:20:08.259 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.260 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
22:20:08.260 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
22:20:08.262 | trace | yii\base\Controller::runAction | Route to run: v2/user/get-index |
22:20:08.262 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\UserController::actionGetIndex() |
22:20:08.262 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE "id"=1000 |
22:20:08.264 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.266 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
22:20:08.266 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT "a".* FROM "global"."tbl_announcements" "a" LEFT JOIN "global"."tbl_read_announcement" "r" ON a.id = r.announcement_id AND r.user_id = 1000 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2016-10-14 22:23:37') ORDER BY "a"."created_at" DESC) "c" |
22:20:08.268 | info | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND ("is_read"=FALSE) |
22:20:08.288 | info | yii\db\Command::query | SELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND (is_read = false) GROUP BY "object_type" |
22:20:08.313 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewCalendarMng |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
22:20:08.315 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
22:20:08.315 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.316 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.317 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
22:20:08.319 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
22:20:08.320 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
22:20:08.320 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
22:20:08.321 | info | yii\db\Command::query | SELECT DISTINCT date(dt) AS edate,
CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_used,
CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_calendar_used,
CASE WHEN count(sh.id) !=0 THEN true ELSE false END AS is_schedule_used,
CASE WHEN count(wl.id) !=0 THEN true ELSE false END AS is_work_log_used FROM generate_series(date_trunc('day', to_date('20250601', 'yyyymmdd')), date_trunc('day', to_date('20250630', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_calendars" "c" WHERE (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by"=1000)) "cl" ON
(
(
(date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at
)
)
LEFT JOIN (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)) "sh" ON
(
(
(date(dt) || ' 00:00:00')::timestamp without time zone >= sh.s_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone <= sh.e_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= sh.s_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= sh.s_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= sh.e_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= sh.e_at
)
)
AND sh.created_by = 1000 LEFT JOIN (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.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1000)) "wl" ON
(
(
(date(dt) || ' 00:00:00')::timestamp without time zone >= wl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone <= wl.end_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= wl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= wl.start_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= wl.end_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= wl.end_at
)
)
GROUP BY "tt"."dt" ORDER BY "edate" DESC |
22:20:08.380 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.380 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
22:20:08.380 | info | yii\db\Command::query | SELECT DISTINCT date(dt) AS edate,CASE WHEN count(cl.alarm_before) !=0 or count(sh.alarm_before) !=0 THEN true ELSE false END AS is_alarm FROM generate_series(date_trunc('day', to_date('20250601', 'yyyymmdd')), date_trunc('day', to_date('20250630', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_calendars" "cl" ON
(
(
(date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at
)
)
AND cl.created_by = 1000 LEFT JOIN "a57be577deb434"."tbl_schedules" "sh" ON
(
(
(date(dt) || ' 00:00:00')::timestamp without time zone >= sh.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone <= sh.end_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= sh.start_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= sh.start_at
)
OR
(
(date(dt) || ' 00:00:00')::timestamp without time zone <= sh.end_at
AND
(date(dt) || ' 23:59:59')::timestamp without time zone >= sh.end_at
)
)
AND sh.created_by = 1000 WHERE (cl.start_at - cl.alarm_before > '2025-06-24 10:20:08') OR (sh.start_at - sh.alarm_before > '2025-06-24 10:20:08') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC |
22:20:08.430 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * 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"."start_at" >= '2025-06-24 00:00:00') AND ("w"."end_at" < '2025-06-24 23:59:59')) OR (("w"."start_at" <= '2025-06-24 00:00:00') AND ("w"."end_at" > '2025-06-24 00:00:00')) OR (("w"."start_at" <= '2025-06-24 23:59:59') AND ("w"."end_at" > '2025-06-24 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1000) AND ("w"."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))) 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" WHERE ((("s"."s_at" >= '2025-06-24 00:00:00') AND ("s"."e_at" < '2025-06-24 23:59:59')) OR (("s"."s_at" <= '2025-06-24 00:00:00') AND ("s"."e_at" > '2025-06-24 00:00:00')) OR (("s"."s_at" <= '2025-06-24 23:59:59') AND ("s"."e_at" > '2025-06-24 23:59:59'))) AND ("s"."created_by"=1000) 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))) 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"."start_at" >= '2025-06-24 00:00:00') AND ("c"."end_at" < '2025-06-24 23:59:59')) OR (("c"."start_at" <= '2025-06-24 00:00:00') AND ("c"."end_at" > '2025-06-24 00:00:00')) OR (("c"."start_at" <= '2025-06-24 23:59:59') AND ("c"."end_at" > '2025-06-24 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."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)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at") "c" |
22:20:08.434 | info | yii\db\Command::query | SELECT * 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"."start_at" >= '2025-06-24 00:00:00') AND ("w"."end_at" < '2025-06-24 23:59:59')) OR (("w"."start_at" <= '2025-06-24 00:00:00') AND ("w"."end_at" > '2025-06-24 00:00:00')) OR (("w"."start_at" <= '2025-06-24 23:59:59') AND ("w"."end_at" > '2025-06-24 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1000) AND ("w"."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))) 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" WHERE ((("s"."s_at" >= '2025-06-24 00:00:00') AND ("s"."e_at" < '2025-06-24 23:59:59')) OR (("s"."s_at" <= '2025-06-24 00:00:00') AND ("s"."e_at" > '2025-06-24 00:00:00')) OR (("s"."s_at" <= '2025-06-24 23:59:59') AND ("s"."e_at" > '2025-06-24 23:59:59'))) AND ("s"."created_by"=1000) 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))) 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"."start_at" >= '2025-06-24 00:00:00') AND ("c"."end_at" < '2025-06-24 23:59:59')) OR (("c"."start_at" <= '2025-06-24 00:00:00') AND ("c"."end_at" > '2025-06-24 00:00:00')) OR (("c"."start_at" <= '2025-06-24 23:59:59') AND ("c"."end_at" > '2025-06-24 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."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)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at" |
22:20:08.440 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
22:20:08.440 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
22:20:08.441 | 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"=1000) |
22:20:08.442 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1) |
22:20:08.442 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND (0=1) |
22:20:08.443 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id" IN (37023, 37024, 37022)) |
22:20:08.445 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24765, 24766, 24767) |
22:20:08.446 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
22:20:08.447 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
22:20:08.447 | 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, 2, 1141, 'v2/user/get-index', '{"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1750774784","token":"e0a4e02cef338260109dcf024669eb8f","version_code":"1141"}', '{"code":200,"data":{"announcementUnread":{"count":0},"unread":[],"calendar":{"list":[{"id":37023,"title":"\u552e\u540e\u670d\u52a1","client_id":null,"created_by":1000,"start_at":"2025-06-24 20:00:00","end_at":"2025-06-24 20:00:00","type":3,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"client":null,"start_at_display":"20:00","end_at_display":"20:00","can_update":false,"can_delete":false,"attachmentRelationships":[{"id":33141,"object_type":18,"object_id":37023,"attachment_id":24765,"attachment":{"id":24765,"key":24765,"name":"0cccc158-321d-3ddb-a0e7-4f26e1995c5f","extension":"png","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/06\/"}},{"id":33142,"object_type":18,"object_id":37023,"attachment_id":24766,"attachment":{"id":24766,"key":24766,"name":"98f15dde-3b7f-3ba7-b40f-4c8b31125e93","extension":"png","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/06\/"}}]},{"id":37024,"title":"\u552e\u540e\u670d\u52a1","client_id":null,"created_by":1000,"start_at":"2025-06-24 20:00:00","end_at":"2025-06-24 21:56:00","type":3,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"client":null,"start_at_display":"20:00","end_at_display":"21:56","can_update":false,"can_delete":false,"attachmentRelationships":[{"id":33143,"object_type":18,"object_id":37024,"attachment_id":24767,"attachment":{"id":24767,"key":24767,"name":"e6640989-f9b5-3726-aa96-1be4e7fbbc72","extension":"png","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/06\/"}}]},{"id":37022,"title":"\u552e\u540e\u670d\u52a1","client_id":null,"created_by":1000,"start_at":"2025-06-24 20:00:00","end_at":"2025-06-24 20:49:00","type":3,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"client":null,"start_at_display":"20:00","end_at_display":"20:49","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-06-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":true},{"edate":"2025-06-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-22","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-21","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-12","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-10","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-01","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":3,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-24 22:20:08') RETURNING "id" |