| 16:15:48.907 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 16:15:48.907 | trace | yii\base\Module::getModule | Loading module: debug |
| 16:15:48.908 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 16:15:48.909 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 16:15:48.909 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 16:15:48.909 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.910 | info | time tracing start | 1781252148910373888 |
| 16:15:48.910 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 16:15:48.910 | trace | yii\web\Application::handleRequest | Route requested: 'v2/schedule/save-new-description' |
| 16:15:48.910 | trace | yii\base\Module::getModule | Loading module: v2 |
| 16:15:48.911 | info | yii\web\Session::open | Session started |
| 16:15:48.912 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:15:48.914 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC' |
| 16:15:48.915 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.915 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.916 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.916 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.916 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:15:48.917 | trace | yii\base\Controller::runAction | Route to run: v2/schedule/save-new-description |
| 16:15:48.917 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.920 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:15:48.920 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ScheduleController::actionSaveNewDescription() |
| 16:15:48.920 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.921 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364' |
| 16:15:48.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createSchedule |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Operator |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 人力资源 |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Treasurer |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: GM |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
| 16:15:48.922 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 软件开发 |
| 16:15:48.922 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364') |
| 16:15:48.923 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_schedule_descriptions" ("description", "schedule_id", "created_at") VALUES ('好成绩', 18364, 'now()') RETURNING "id" |
| 16:15:48.925 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.925 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.925 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ScheduleDescriptions', 21067, 'a:4:{s:2:"id";i:21067;s:11:"schedule_id";s:5:"18364";s:11:"description";s:9:"好成绩";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1000, '223.104.41.38') |
| 16:15:48.927 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.927 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.927 | info | yii\db\Command::execute | 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', 18364, 9, 1000, 'now()', '["\u597d\u6210\u7ee9"]', '[[]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]}') |
| 16:15:48.929 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=18364 |
| 16:15:48.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.930 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.931 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.932 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.932 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=18364 |
| 16:15:48.933 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 16:15:48.933 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '9', 18364, '曹永生更新了一条待办事项', TRUE, '新建代办事项') RETURNING "id" |
| 16:15:48.935 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220863, 'a:11:{s:2:"id";i:220863;s:9:"object_id";i:18364;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:18:"新建代办事项";}', '', 1000, '223.104.41.38') |
| 16:15:48.936 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.936 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.936 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (18364, '9', 220863, 5016) |
| 16:15:48.937 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5016) AND ("id" != 1000) AND (channel_id IS NOT NULL) |
| 16:15:48.938 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.938 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.939 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 16:15:48.941 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982 |
| 16:15:48.943 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 16:15:48.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.973 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.973 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id" |
| 16:15:48.975 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 199975, 'a:5:{s:2:"id";i:199975;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.38') |
| 16:15:48.976 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1000, '223.104.41.38') |
| 16:15:48.978 | info | yii\db\Command::query | 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', 982, 10, 18364, 9, 1000, '18364', '18364', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:15:48.979 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641886, 'a:13:{s:2:"id";i:641886;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";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.41.38') |
| 16:15:48.980 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 16:15:48.981 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.982 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.982 | info | yii\db\Command::query | 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', 982, 10, 18364, 9, 1000, '18364', '18364', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:15:48.984 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 172011, 'a:15:{s:2:"id";i:172011;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";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.41.38') |
| 16:15:48.985 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.985 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.985 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184 |
| 16:15:48.987 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4184 |
| 16:15:48.988 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4184) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 16:15:48.991 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:48.991 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:48.991 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4184, 'a:0:{}', '', 1000, '223.104.41.38') |
| 16:15:48.992 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 16:15:48.993 | info | yii\db\Command::query | 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', 4184, 1, 18364, 9, 1000, '18364', '18364', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:15:48.994 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 641887, 'a:13:{s:2:"id";i:641887;s:9:"object_id";i:4184;s:11:"object_type";i:1;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";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.41.38') |
| 16:15:48.995 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184 |
| 16:15:48.996 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 16:15:48.997 | info | yii\db\Command::query | 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', 4184, 1, 18364, 9, 1000, '18364', '18364', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
| 16:15:48.998 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 172012, 'a:15:{s:2:"id";i:172012;s:9:"object_id";i:4184;s:11:"object_type";i:1;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";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.41.38') |
| 16:15:48.999 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364' |
| 16:15:49.000 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982 |
| 16:15:49.000 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:15:49.001 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184 |
| 16:15:49.001 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1 |
| 16:15:49.002 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:15:49.002 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:15:49.003 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:15:49.003 | 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) |
| 16:15:49.004 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 16:15:49.004 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:15:49.005 | 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) |
| 16:15:49.005 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=18364 |
| 16:15:49.006 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 16:15:49.007 | 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) |
| 16:15:49.007 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=18364) |
| 16:15:49.011 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32713 |
| 16:15:49.011 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id"=18364) |
| 16:15:49.015 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=18364 |
| 16:15:49.015 | info | yii\db\Command::query | SELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 16:15:49.016 | 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"=5016) |
| 16:15:49.016 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=18364 ORDER BY "created_at" DESC |
| 16:15:49.019 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=18364) GROUP BY "object_id" |
| 16:15:49.047 | info | yii\db\Command::query | 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"=18364) GROUP BY "object_id" |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateSchedule |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: deleteSchedule |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: StoreKeeper |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
| 16:15:49.067 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:15:49.068 | info | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
| 16:15:49.069 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) 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:15:49.070 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:15:49.071 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:15:49.071 | 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", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/schedule/save-new-description', '{"ScheduleDescriptions":{"description":"\u597d\u6210\u7ee9","schedule_id":"18364"},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1781252096","token":"467964ec5ef045a9ab72f55d5108ef58","version_code":"1159"}', '{"code":200,"data":{"model":{"id":18364,"client_id":982,"schedule_title":"\u65b0\u5efa\u4ee3\u529e\u4e8b\u9879","description":null,"schedule_week":null,"start_at":"2026-06-12 16:14:00","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1000,"created_at":"2026-06-12 16:15:14","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-06-12 18:00:00","is_public":1,"system_calendar_id":null,"creator":1000,"project_id":4184,"updated_at":"2026-06-12 16:15:30","set_top_at":null,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"project":{"id":4184,"key":4184,"name":"\u560e\u560e\u560e","project_status":1,"budget":"0","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"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\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"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\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}}],"attachmentRelationships":[{"id":57698,"object_type":9,"object_id":18364,"attachment_id":32713,"attachment":{"id":32713,"key":32713,"name":"8871557a-c0b6-35ac-b951-69ddd138558f","extension":"png","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8871557a-c0b6-35ac-b951-69ddd138558f\/20260612161504.png","orig_name":"20260612161504.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":1015,"schedule_id":18364,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"scheduleDescriptions":[{"id":21067,"schedule_id":18364,"description":"\u597d\u6210\u7ee9","created_at":"2026-06-12 16:15:48","created_at_display":"06-12 (\u4eca\u5929) 16:15"},{"id":21066,"schedule_id":18364,"description":"\u4e0d\u7b26\u5408\u54c8\u54c8","created_at":"2026-06-12 16:15:40","created_at_display":"06-12 (\u4eca\u5929) 16:15"}],"commentCount":{"object_id":18364,"comment":4},"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2026-06-12 18:00:00+08","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":"2026-06-12 16:14:00+08"},"options":[{"key":"Schedules[headUsers]","name":"Creator","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":5250,"key":5250,"name":"\u8463\u8363"},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633"},{"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":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\u5b9e\u79d1\u6280"},{"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":5461,"key":5461,"name":"\u8096\u5e05"},{"id":1022,"key":1022,"name":"\u5f90\u7855"},{"id":5476,"key":5476,"name":"\u6768\u5dcd"},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},{"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":""}],"ip":"223.104.41.38","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-12 16:15:49', 161144064) RETURNING "id" |