ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c1376e915d4: POST https://beta.jinchangxiao.com/v2/user/get-index at 2025-09-10 04:31:42 pm by 114.246.239.150

Log Messages

总计73条数据
TimeLevelCategoryMessage
 
16:31:42.595traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:31:42.595traceyii\base\Module::getModuleLoading module: debug
16:31:42.595traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:31:42.595traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:31:42.596traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:31:42.596traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.596traceyii\base\Module::getModuleLoading module: gii
16:31:42.596traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:31:42.596traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:31:42.596traceyii\web\Application::handleRequestRoute requested: 'v2/user/get-index'
16:31:42.596traceyii\base\Module::getModuleLoading module: v2
16:31:42.597infoyii\web\Session::openSession started
16:31:42.598infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:31:42.600infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'
16:31:42.603traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.603traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:31:42.603traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.603traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:31:42.603infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:31:42.605traceyii\base\Controller::runActionRoute to run: v2/user/get-index
16:31:42.605traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\UserController::actionGetIndex()
16:31:42.605infoyii\db\Command::querySELECT * FROM "global"."tbl_logins" WHERE "id"=1000
16:31:42.606traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.606traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:31:42.607infoyii\db\Command::querySELECT 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"
16:31:42.608infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND ("is_read"=FALSE)
16:31:42.626infoyii\db\Command::querySELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND (is_read = false) GROUP BY "object_type"
16:31:42.644traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewCalendarMng
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
16:31:42.645traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:31:42.645traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.646traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.646infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:31:42.647infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:31:42.648infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:31:42.648infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:31:42.649infoyii\db\Command::querySELECT 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('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250930', '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
16:31:42.678traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.679traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:31:42.679infoyii\db\Command::querySELECT 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('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250930', '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-09-10 04:31:42') OR (sh.start_at - sh.alarm_before > '2025-09-10 04:31:42') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC
16:31:42.704infoyii\db\Command::querySELECT 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-09-10 00:00:00') AND ("w"."end_at" < '2025-09-10 23:59:59')) OR (("w"."start_at" <= '2025-09-10 00:00:00') AND ("w"."end_at" > '2025-09-10 00:00:00')) OR (("w"."start_at" <= '2025-09-10 23:59:59') AND ("w"."end_at" > '2025-09-10 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) 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-09-10 00:00:00') AND ("s"."e_at" < '2025-09-10 23:59:59')) OR (("s"."s_at" <= '2025-09-10 00:00:00') AND ("s"."e_at" > '2025-09-10 00:00:00')) OR (("s"."s_at" <= '2025-09-10 23:59:59') AND ("s"."e_at" > '2025-09-10 23:59:59'))) AND ("s"."created_by"=1000) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) 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-09-10 00:00:00') AND ("c"."end_at" < '2025-09-10 23:59:59')) OR (("c"."start_at" <= '2025-09-10 00:00:00') AND ("c"."end_at" > '2025-09-10 00:00:00')) OR (("c"."start_at" <= '2025-09-10 23:59:59') AND ("c"."end_at" > '2025-09-10 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at") "c"
16:31:42.708infoyii\db\Command::querySELECT * 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-09-10 00:00:00') AND ("w"."end_at" < '2025-09-10 23:59:59')) OR (("w"."start_at" <= '2025-09-10 00:00:00') AND ("w"."end_at" > '2025-09-10 00:00:00')) OR (("w"."start_at" <= '2025-09-10 23:59:59') AND ("w"."end_at" > '2025-09-10 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) 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-09-10 00:00:00') AND ("s"."e_at" < '2025-09-10 23:59:59')) OR (("s"."s_at" <= '2025-09-10 00:00:00') AND ("s"."e_at" > '2025-09-10 00:00:00')) OR (("s"."s_at" <= '2025-09-10 23:59:59') AND ("s"."e_at" > '2025-09-10 23:59:59'))) AND ("s"."created_by"=1000) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449))) 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-09-10 00:00:00') AND ("c"."end_at" < '2025-09-10 23:59:59')) OR (("c"."start_at" <= '2025-09-10 00:00:00') AND ("c"."end_at" > '2025-09-10 00:00:00')) OR (("c"."start_at" <= '2025-09-10 23:59:59') AND ("c"."end_at" > '2025-09-10 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at"
16:31:42.711infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:31:42.712infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
16:31:42.712infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
16:31:42.713infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: updateCalendarMng
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: deleteCalendarMng
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
16:31:42.713traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:31:42.714infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND ("object_id"=277429)
16:31:42.716infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28079
16:31:42.716infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17939)
16:31:42.718infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28082
16:31:42.718infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=38038)
16:31:42.721traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:31:42.721traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:31:42.721infoyii\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, 0, 266, 'v2/user/get-index', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","token":"be9484dd0f8f674db5ea52d628082b8b","posttime":"1757493101"}', '{"code":200,"data":{"announcementUnread":{"count":5},"unread":[{"key":"20028","value":4}],"calendar":{"list":[{"id":277429,"title":"\u6d4b\u6d4b\u6d4b","client_id":null,"created_by":1000,"start_at":"2025-09-10 09:00:00","end_at":"2025-09-10 18:00:00","type":1,"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\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},"client":null,"start_at_display":"09:00","end_at_display":"18:00","can_update":true,"can_delete":true,"attachmentRelationships":[{"id":49459,"object_type":26,"object_id":277429,"attachment_id":28079,"attachment":{"id":28079,"key":28079,"name":"1cb08a88-e25b-3c31-99df-ddb5cd56fe8d","extension":"jpg","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/09\/"}}]},{"id":38038,"title":"\u552e\u540e\u670d\u52a1","client_id":1661,"created_by":1000,"start_at":"2025-09-10 14:14:04","end_at":"2025-09-10 14:14:16","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\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":null},"start_at_display":"14:14","end_at_display":"14:14","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17939,"title":"\u98de\u98de\u98de","client_id":1661,"created_by":1000,"start_at":"2025-09-10 14:33:00","end_at":"2025-09-10 18:00:00","type":2,"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\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},"client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"logo":null},"start_at_display":"14:33","end_at_display":"18:00","can_update":false,"can_delete":false,"attachmentRelationships":[{"id":49463,"object_type":9,"object_id":17939,"attachment_id":28082,"attachment":{"id":28082,"key":28082,"name":"55b503b3-c2ef-3cc5-9702-7097dcb9638e","extension":"jpg","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/09\/"}}]}],"point":[{"edate":"2025-09-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-12","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-10","is_used":true,"is_calendar_used":true,"is_schedule_used":true,"is_work_log_used":true},{"edate":"2025-09-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-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-09-10 16:31:42') RETURNING "id"