Time | Level | Category | Message |
---|---|---|---|
17:25:27.362 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
17:25:27.362 | trace | yii\base\Module::getModule | Loading module: debug |
17:25:27.362 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
17:25:27.363 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
17:25:27.363 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
17:25:27.363 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.363 | trace | yii\base\Module::getModule | Loading module: gii |
17:25:27.363 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
17:25:27.363 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
17:25:27.364 | trace | yii\web\Application::handleRequest | Route requested: 'v2/user/get-index' |
17:25:27.364 | trace | yii\base\Module::getModule | Loading module: v2 |
17:25:27.372 | info | yii\web\Session::open | Session started |
17:25:27.373 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
17:25:27.377 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc' |
17:25:27.381 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.382 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:25:27.382 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.383 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:25:27.383 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:25:27.385 | trace | yii\base\Controller::runAction | Route to run: v2/user/get-index |
17:25:27.385 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\UserController::actionGetIndex() |
17:25:27.385 | info | yii\db\Command::query | SELECT * FROM "global"."tbl_logins" WHERE "id"=1004 |
17:25:27.386 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.386 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:25:27.386 | 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 = 1004 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2017-02-06 13:07:29') ORDER BY "a"."created_at" DESC) "c" |
17:25:27.388 | info | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1004) AND ("is_read"=FALSE) |
17:25:27.407 | info | yii\db\Command::query | SELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1004) AND (is_read = false) GROUP BY "object_type" |
17:25:27.432 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: viewCalendarMng |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
17:25:27.434 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
17:25:27.434 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.435 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:27.436 | 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"=1004) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
17:25:27.438 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:25:27.439 | 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"=1004) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
17:25:27.441 | 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"=1004) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id" |
17:25:27.442 | 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('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', '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"=1004)) "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 = 1004 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"=1004)) "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 |
17:25:28.988 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:28.988 | info | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_calendars' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
17:25:28.994 | info | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_calendars' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
17:25:29.005 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:25:29.005 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
17:25:29.005 | 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('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', '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 = 1004 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 = 1004 WHERE (cl.start_at - cl.alarm_before > '2025-07-13 05:25:29') OR (sh.start_at - sh.alarm_before > '2025-07-13 05:25:29') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC |
17:25:29.164 | 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-07-13 00:00:00') AND ("w"."end_at" < '2025-07-13 23:59:59')) OR (("w"."start_at" <= '2025-07-13 00:00:00') AND ("w"."end_at" > '2025-07-13 00:00:00')) OR (("w"."start_at" <= '2025-07-13 23:59:59') AND ("w"."end_at" > '2025-07-13 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"=1004) AND ("w"."created_by" IN (1000, 1001, 1004, 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-07-13 00:00:00') AND ("s"."e_at" < '2025-07-13 23:59:59')) OR (("s"."s_at" <= '2025-07-13 00:00:00') AND ("s"."e_at" > '2025-07-13 00:00:00')) OR (("s"."s_at" <= '2025-07-13 23:59:59') AND ("s"."e_at" > '2025-07-13 23:59:59'))) AND ("s"."created_by"=1004) AND ("s"."created_by" IN (1004, 1004, 1001, 5446, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295))) 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-07-13 00:00:00') AND ("c"."end_at" < '2025-07-13 23:59:59')) OR (("c"."start_at" <= '2025-07-13 00:00:00') AND ("c"."end_at" > '2025-07-13 00:00:00')) OR (("c"."start_at" <= '2025-07-13 23:59:59') AND ("c"."end_at" > '2025-07-13 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1004, 1004, 1001, 5446, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295)) AND ("c"."created_by"=1004) ) )) "w" ORDER BY "start_at") "c" |
17:25:29.169 | 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-07-13 00:00:00') AND ("w"."end_at" < '2025-07-13 23:59:59')) OR (("w"."start_at" <= '2025-07-13 00:00:00') AND ("w"."end_at" > '2025-07-13 00:00:00')) OR (("w"."start_at" <= '2025-07-13 23:59:59') AND ("w"."end_at" > '2025-07-13 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"=1004) AND ("w"."created_by" IN (1000, 1001, 1004, 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-07-13 00:00:00') AND ("s"."e_at" < '2025-07-13 23:59:59')) OR (("s"."s_at" <= '2025-07-13 00:00:00') AND ("s"."e_at" > '2025-07-13 00:00:00')) OR (("s"."s_at" <= '2025-07-13 23:59:59') AND ("s"."e_at" > '2025-07-13 23:59:59'))) AND ("s"."created_by"=1004) AND ("s"."created_by" IN (1004, 1004, 1001, 5446, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295))) 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-07-13 00:00:00') AND ("c"."end_at" < '2025-07-13 23:59:59')) OR (("c"."start_at" <= '2025-07-13 00:00:00') AND ("c"."end_at" > '2025-07-13 00:00:00')) OR (("c"."start_at" <= '2025-07-13 23:59:59') AND ("c"."end_at" > '2025-07-13 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1004, 1004, 1001, 5446, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295)) AND ("c"."created_by"=1004) ) )) "w" ORDER BY "start_at" |
17:25:29.174 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:25:29.175 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
17:25:29.175 | 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"=1004) |
17:25:29.175 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2121, 2814, 2091, 15, 2714, 2803, 3303, 3324, 1172, 3302) |
17:25:29.176 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1) |
17:25:29.177 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (14916, 14428, 16659, 16687, 16897, 16896, 16775, 17336, 17349, 17508, 17543, 16869, 17561, 17649, 17676, 17683, 17579)) |
17:25:29.178 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1) |
17:25:29.179 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:25:29.179 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:25:29.179 | 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', 1004, 2, 1141, 'v2/user/get-index', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","posttime":"1752398720","token":"ee5ebc01accf3ebbcc45675d3b1e467c","version_code":"1141"}', '{"code":200,"data":{"announcementUnread":{"count":62},"unread":[{"key":"1","value":10},{"key":"10","value":2},{"key":"18","value":44},{"key":"5","value":1},{"key":"9","value":1},{"key":16,"value":4}],"calendar":{"list":[{"id":14916,"title":"\u76ee\u7684\uff1a\u8ddf\u5c39\u603b\u786e\u8ba4\u5408\u4f5c\u6846\u67b6\uff0c\u8bf7\u4ed6\u559d\u8305\u53f0\uff0c\u4ed6\u8ba9\u611f\u89c9\u9171\u9999\u7684\u7eaf\u539a\u3001\u6e05\u9999\u3002\n\u52a8\u4f5c\uff1a\u7ea6\u996d\u3002","client_id":null,"created_by":1004,"start_at":"2023-05-05 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":null,"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":14428,"title":"\u76ee\u7684\uff1a\u6536\u6b3e\uff0c\u8ba9\u5ba2\u6237\u5b8c\u6210\u5f88\u4e45\u4e4b\u524d\u7684\u5f85\u529e\u3002\n\u52a8\u4f5c\uff1a6\u6708\u5e95\u524d\u6536\u56de\u3002","client_id":2121,"created_by":1004,"start_at":"2023-06-30 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2121,"key":2121,"name":"\u4e2d\u56fd\u5175\u5668\u5de5\u4e1a\u5bfc\u822a\u4e0e\u63a7\u5236\u6280\u672f\u7814\u7a76\u6240","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16659,"title":"ZStack\u7535\u8bdd\u540d\u5355\uff0c\u76ee\u7684\uff0c\u8bdd\u672f\uff0c\u603b\u7ed3\n\n\u5f62\u5f0f\uff1aExcle\uff0c\u8be6\u7ec6\u8bb0\u5f55\u8fc7\u7a0b\uff0c\u662f\u5426\u901a\uff1f\u901a\u8bdd\u65f6\u957f\uff1f","client_id":null,"created_by":1004,"start_at":"2024-03-24 00:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":null,"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16687,"title":"\u76ee\u7684\uff1a\u5df2\u6536\u5230\u5ba2\u6237\u5168\u989d\u5ef6\u671f\u652f\u7968\u3002\u65f6\u95f45\u670810\u65e5\u5230\u8d26\u3002","client_id":2814,"created_by":1004,"start_at":"2024-05-13 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2814,"key":2814,"name":"\u5317\u4eac\u946b\u667a\u76db\u4e16\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16897,"title":"\u5546\u673a\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u786e\u8ba4\u62a5\u4ef7\u53ca\u7b7e\u5408\u540c\u65f6\u95f4\n\u52a8\u4f5c\uff1a\u8ddf\u738b\u603b\u5177\u4f53\u6c9f\u901a\u3002","client_id":2091,"created_by":1004,"start_at":"2024-05-17 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16896,"title":"\u5546\u673a\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u7684\uff1a\u786e\u8ba4\u5177\u4f53\u5ba1\u6279\u53ca\u5927\u6982\u542f\u52a8\u65f6\u95f4\u3002\n\u52a8\u4f5c\uff1a\u8ddf\u738b\u603b\u53ca\u8c22\u603b\u89c1\u9762\u6c9f\u901a\u3002","client_id":15,"created_by":1004,"start_at":"2024-05-24 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16775,"title":"\u76ee\u7684\uff1a8\u670831\u65e5\u524d\u6536\u56de\u5168\u6b3e\u3002","client_id":2714,"created_by":1004,"start_at":"2024-07-31 00:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2714,"key":2714,"name":"\u5317\u4eac\u534e\u590f\u51ef\u777f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17336,"title":"\u589e\u52a0Review\u62dc\u8bbf\u73af\u8282\n1.\u4e24\u4f4d\u9500\u552e\u603b\u76d1\u4e0a\u5468\u966a\u9500\u552e\u4ee3\u8868\u8dd1\u4e86\u54ea\u51e0\u5bb6\u7528\u6237\u548c\u5382\u5546\u53ca\u60c5\u51b5\u6c47\u62a5\uff01\uff08\u8981\u6c42\uff1a2\u4e2a\u5ba2\u6237\u6216\u80052\u4e2a\u5382\u5546\u3002\u6bcf\u5c11\u4e00\u4e2a\u8d21\u732e500\u5143\uff09","client_id":2803,"created_by":1004,"start_at":"2024-09-02 00:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17349,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u50ac\u6b3e\n\u52a8\u4f5c\uff1a\u627e\u795e\u7801\u52a9\u7406\u67e5\u770b\u6d41\u7a0b\u3002","client_id":3303,"created_by":1004,"start_at":"2024-09-30 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17508,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u786e\u8ba4\u4e00\u4e0b\u5408\u540c\u662f\u5426\u53d8\u66f4\u53ca\u9884\u4ed8\u6b3e\u7684\u4e8b\n\u52a8\u4f5c\uff1a\u8ddf\u738b\u603b\u6c9f\u901a\u786e\u8ba4\u3002","client_id":2091,"created_by":1004,"start_at":"2024-11-22 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17543,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u786e\u8ba4\u5177\u4f53\u91c7\u8d2d\u6d41\u7a0b\u53ca\u65f6\u95f4\n\u52a8\u4f5c\uff1a\u8ddf\u738b\u603b\u6c9f\u901a\u786e\u8ba4\u3002","client_id":3324,"created_by":1004,"start_at":"2024-12-06 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":3324,"key":3324,"name":"\u4e2d\u56fd\u5730\u8d28\u8c03\u67e5\u5c40","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16869,"title":"\u76ee\u7684\uff1a\u56de\u6b3e\u65f6\u95f4\uff0c7\u670820\u65e5\u524d\u56de90%\uff0c12\u670831\u65e5\u524d\u56de10%\u3002","client_id":2091,"created_by":1004,"start_at":"2024-12-31 00:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17561,"title":"\u76ee\u7684\uff1a\u672c\u6708\u5e95\u56de\u5168\u6b3e\u3002","client_id":3303,"created_by":1004,"start_at":"2024-12-31 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17649,"title":"\u51c6\u5907\u62db\u9500\u552e\u5de5\u4f5c\n1.\u7ea6\u4eba\u9762\u8bd5\u3002\n2.\u62dc\u8bbf3-4\u5bb6\u4ee3\u7406\u5546\u6216\u96c6\u6210\u5546\uff0c\u627e\u76ee\u6807\u4eba\u3002","client_id":2803,"created_by":1004,"start_at":"2025-03-14 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17676,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u7684\uff1a\u786e\u8ba4\u6295\u6807\u65b9\u6848\u3002\n\u52a8\u4f5c\uff1a\u627e\u738b\u603b\u5177\u4f53\u6c9f\u901a\u53ca\u79ef\u5206\u786e\u8ba4\u3002","client_id":2091,"created_by":1004,"start_at":"2025-03-14 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17683,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c\n\u76ee\u7684\uff1a\u786e\u8ba4\u5408\u540c\u8d70\u5408\u540c\u6d41\u7a0b\u3002\n\u52a8\u4f5c\uff1a\u8ddf\u6768\u5de5\u53ca\u53f6\u90e8\u786e\u8ba4\u7ec6\u8282\u3002","client_id":1172,"created_by":1004,"start_at":"2025-03-21 18:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u7269\u6d41\u6709\u9650\u516c\u53f8","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17579,"title":"\u672c\u9879\u76ee\u6ca1\u4e0b\u5355\uff0c\u6ca1\u4ea4\u8d27\uff0c\u5df2\u6536\u5230\u5ba2\u623730%\u9884\u4ed8\u6b3e\uff08\u53ef\u66ff\u4ee3\u4e4b\u524d122000\u5143\u6ca1\u4ed8\u6b3e\u7684\u9879\u76ee\u6b3e\uff09\u3002\u5982\u9700\u4e0b\u5355\u8981\u7b49\u5230122000\u5143\u7684\u6b3e\u90fd\u6536\u5b8c\u3002","client_id":3302,"created_by":1004,"start_at":"2025-03-31 00:00:00","end_at":"2025-07-13 17:25:29","type":2,"is_alarm":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"client":{"id":3302,"key":3302,"name":"\u6210\u90fd\u7cbe\u7075\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"17:25","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-07-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-13","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-12","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-11","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-10","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-09","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-08","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-07","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-06","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-05","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-04","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-03","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":17,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 17:25:29') RETURNING "id" |