687765b505ed6: POST https://beta.jinchangxiao.com/v2/schedule/save-new-description at 2025-07-16 04:41:25 pm by 223.104.40.191
Database Queries
总计66条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:41:25.027 | 2.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH' |
| 16:41:25.031 | 1.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:41:25.035 | 5.6 ms | SELECT | 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_schedule_descriptions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 16:41:25.041 | 18.5 ms | SELECT | 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_schedule_descriptions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 16:41:25.061 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17704' |
| 16:41:25.065 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17704') |
| 16:41:25.066 | 3.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_schedule_descriptions" ("description", "schedule_id", "created_at") VALUES ('那你', 17704, 'now()') RETURNING "id" |
| 16:41:25.070 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ScheduleDescriptions', 12435, 'a:4:{s:2:"id";i:12435;s:11:"schedule_id";s:5:"17704";s:11:"description";s:6:"那你";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1000, '223.104.40.191') |
| 16:41:25.072 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'scheduleDescriptions', 17704, 9, 1000, 'now()', '["\u90a3\u4f60"]', '[[]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]}') |
| 16:41:25.073 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17704 |
| 16:41:25.076 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17704 |
| 16:41:25.077 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 16:41:25.078 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '9', 17704, '曹永生更新了一条待办事项', TRUE, '宝贝宝贝') RETURNING "id" |
| 16:41:25.079 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170515, 'a:11:{s:2:"id";i:170515;s:9:"object_id";i:17704;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"曹永生更新了一条待办事项";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:12:"宝贝宝贝";}', '', 1000, '223.104.40.191') |
| 16:41:25.080 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (17704, '9', 170515, 1017), (17704, '9', 170515, 5250) |
| 16:41:25.082 | 0.5 ms | SELECT | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1017, 5250)) AND ("id" != 1000) AND (channel_id IS NOT NULL) |
| 16:41:25.083 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17704 |
| 16:41:25.083 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.086 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.088 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815 |
| 16:41:25.089 | 17.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 16:41:25.107 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
| 16:41:25.108 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165376, 'a:5:{s:2:"id";i:165376;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.40.191') |
| 16:41:25.109 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1000, '223.104.40.191') |
| 16:41:25.110 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 2815, 10, 17704, 9, 1000, '17704', '17704', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:41:25.111 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510888, 'a:13:{s:2:"id";i:510888;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17704;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17704";s:9:"new_value";s:5:"17704";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.40.191') |
| 16:41:25.112 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.113 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 2815, 10, 17704, 9, 1000, '17704', '17704', array[1004], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:41:25.115 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137256, 'a:15:{s:2:"id";i:137256;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17704;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17704";s:9:"new_value";s:5:"17704";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.40.191') |
| 16:41:25.116 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3811 |
| 16:41:25.118 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3811 |
| 16:41:25.119 | 2.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3811) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 16:41:25.124 | 4.6 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3811, 'a:0:{}', '', 1000, '223.104.40.191') |
| 16:41:25.129 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.130 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3811, 1, 17704, 9, 1000, '17704', '17704', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:41:25.131 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510889, 'a:13:{s:2:"id";i:510889;s:9:"object_id";i:3811;s:11:"object_type";i:1;s:9:"target_id";i:17704;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17704";s:9:"new_value";s:5:"17704";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.40.191') |
| 16:41:25.132 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3811 |
| 16:41:25.132 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.133 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 3811, 1, 17704, 9, 1000, '17704', '17704', array[1004], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:41:25.134 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137257, 'a:15:{s:2:"id";i:137257;s:9:"object_id";i:3811;s:11:"object_type";i:1;s:9:"target_id";i:17704;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17704";s:9:"new_value";s:5:"17704";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.40.191') |
| 16:41:25.135 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17704' |
| 16:41:25.136 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 16:41:25.137 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 16:41:25.137 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3811 |
| 16:41:25.137 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2 |
| 16:41:25.138 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:41:25.139 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:41:25.139 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:41:25.140 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 16:41:25.140 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:41:25.141 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:41:25.141 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 16:41:25.141 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=17704 |
| 16:41:25.143 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:41:25.143 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 16:41:25.144 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17704) |
| 16:41:25.146 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id"=17704) |
| 16:41:25.148 | 2.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17704 |
| 16:41:25.151 | 0.7 ms | SELECT | SELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5250) |
| 16:41:25.152 | 0.3 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1017)) |
| 16:41:25.153 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17704 ORDER BY "created_at" DESC |
| 16:41:25.155 | 20.9 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=17704) GROUP BY "object_id" |
| 16:41:25.176 | 18.9 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=17704) GROUP BY "object_id" |
| 16:41:25.195 | 0.3 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
| 16:41:25.196 | 0.8 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" 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)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 16:41:25.197 | 2.7 ms | INSERT | 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, 1142, 'v2/schedule/save-new-description', '{"ScheduleDescriptions":{"description":"\u90a3\u4f60","schedule_id":"17704"},"access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"2","posttime":"1752655232","token":"f4ac8a838058454be6daf2303a7f9c40","version_code":"1142"}', '{"code":200,"data":{"model":{"id":17704,"client_id":2815,"schedule_title":"\u5b9d\u8d1d\u5b9d\u8d1d","description":null,"schedule_week":null,"start_at":"2025-07-11 16:24:00","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1000,"created_at":"2025-07-11 16:25:05","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2025-07-11 18:00:00","is_public":1,"system_calendar_id":null,"creator":1000,"project_id":3811,"updated_at":"2025-07-16 16:41:18","set_top_at":null,"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":null,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"project":{"id":3811,"key":3811,"name":"\u6ef4\u6ef4\u6253\u8f66","project_status":2,"budget":"104800","collected":"0","projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"project_status_display":"\u660e\u786e\u9700\u6c42","bgcolor":"#0064ec"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"attachmentRelationships":[],"files":[],"scheduleCarbonCopyRels":[{"id":960,"schedule_id":17704,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":961,"schedule_id":17704,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[{"id":12435,"schedule_id":17704,"description":"\u90a3\u4f60","created_at":"2025-07-16 16:41:25","created_at_display":"07-16 (\u4eca\u5929) 16:41"}],"commentCount":{"object_id":17704,"comment":3},"unreadComments":null,"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"2025-07-11 18:00:00+08","end_at_display2":"","is_self":true,"is_overdue":true,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":"2025-07-11 16:24:00+08"},"options":[{"key":"Schedules[headUsers]","name":"Creator","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de"},{"id":5250,"key":5250,"name":"\u8463\u8363"},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633"},{"id":5329,"key":5329,"name":"\u9ad8\u5ce5"},{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633"},{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"},{"id":5420,"key":5420,"name":"\u674e\u6ea6"},{"id":5445,"key":5445,"name":"\u674e\u9896"},{"id":5446,"key":5446,"name":"\u5218\u5a1f"},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},{"id":5087,"key":5087,"name":"\u5218\u5fae"},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"},{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99"},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"id":1015,"key":1015,"name":"\u5434\u660a"},{"id":5404,"key":5404,"name":"\u6b66\u51ef"},{"id":1022,"key":1022,"name":"\u5f90\u7855"},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e"},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":5440,"key":5440,"name":"\u5f20\u6210"},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"},{"id":5296,"key":5296,"name":"\u8d75\u5b87"},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065"}]},{"key":"Schedules[alarm_before]","name":"\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u4e0d\u63d0\u9192"},{"key":"00:05:00","name":"\u63d0\u524d5\u5206\u949f"},{"key":"00:15:00","name":"\u63d0\u524d15\u5206\u949f"},{"key":"00:30:00","name":"\u63d0\u524d30\u5206\u949f"},{"key":"01:00:00","name":"\u63d0\u524d1\u5c0f\u65f6"},{"key":"02:00:00","name":"\u63d0\u524d2\u5c0f\u65f6"},{"key":"24:00:00","name":"\u63d0\u524d1\u5929"},{"key":"48:00:00","name":"\u63d0\u524d2\u5929"}]}]},"status":1,"msg":[{"name":"success","success":"\u65b0\u603b\u7ed3\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-16 16:41:25') RETURNING "id" |