17:29:41.139 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
17:29:41.139 | trace | yii\base\Module::getModule | Loading module: debug |
17:29:41.140 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
17:29:41.140 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
17:29:41.140 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
17:29:41.140 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.140 | trace | yii\base\Module::getModule | Loading module: gii |
17:29:41.141 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
17:29:41.141 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
17:29:41.141 | trace | yii\web\Application::handleRequest | Route requested: 'v2/schedule/fulfill' |
17:29:41.141 | trace | yii\base\Module::getModule | Loading module: v2 |
17:29:41.141 | info | yii\web\Session::open | Session started |
17:29:41.142 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
17:29:41.145 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc' |
17:29:41.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.149 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.150 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.150 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.152 | trace | yii\base\Controller::runAction | Route to run: v2/schedule/fulfill |
17:29:41.152 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createSchedule |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
17:29:41.153 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
17:29:41.153 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ScheduleController::actionFulfill() |
17:29:41.154 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.154 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.154 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17705' |
17:29:41.155 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.155 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.155 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17705') |
17:29:41.156 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17705' |
17:29:41.156 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_schedule_descriptions" ("description", "schedule_id", "created_at") VALUES ('积极的就放假', 17705, 'now()') RETURNING "id" |
17:29:41.158 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.158 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.158 | 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', 12434, 'a:4:{s:2:"id";i:12434;s:11:"schedule_id";s:5:"17705";s:11:"description";s:18:"积极的就放假";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1004, '120.244.156.33') |
17:29:41.160 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.160 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.160 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.160 | 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', 17705, 9, 1004, 'now()', '["\u79ef\u6781\u7684\u5c31\u653e\u5047"]', '[[]]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]}') |
17:29:41.162 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17705 |
17:29:41.162 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.163 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.164 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.165 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.165 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17705 |
17:29:41.165 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
17:29:41.166 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1004, '9', 17705, '伊峻辰更新了一条待办事项', TRUE, '回复回复娜娜') RETURNING "id" |
17:29:41.167 | 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', 170505, 'a:11:{s:2:"id";i:170505;s:9:"object_id";i:17705;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"伊峻辰更新了一条待办事项";s:10:"created_by";i:1004;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:"回复回复娜娜";}', '', 1004, '120.244.156.33') |
17:29:41.168 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1004) AND (channel_id IS NOT NULL) |
17:29:41.169 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.169 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.169 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
17:29:41.171 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815 |
17:29:41.173 | info | yii\db\Command::query | 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 |
17:29:41.191 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.191 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.191 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
17:29:41.193 | 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', 165364, 'a:5:{s:2:"id";i:165364;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1004, '120.244.156.33') |
17:29:41.194 | 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', 2815, 'a:0:{}', '', 1004, '120.244.156.33') |
17:29:41.195 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.195 | 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', 2815, 10, 17705, 9, 1004, '[17705]', '[17705]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
17:29:41.196 | 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', 510843, 'a:13:{s:2:"id";i:510843;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[17705]";s:9:"new_value";s:7:"[17705]";s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.33') |
17:29:41.197 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
17:29:41.198 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.199 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.199 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.199 | 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', 2815, 10, 17705, 9, 1004, '17705', '17705', array[1004], '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
17:29:41.201 | 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', 137240, 'a:15:{s:2:"id";i:137240;s:9:"object_id";i:2815;s:11:"object_type";i:10;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17705";s:9:"new_value";s:5:"17705";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":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1004, '120.244.156.33') |
17:29:41.202 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.202 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.202 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3822 |
17:29:41.204 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3822 |
17:29:41.205 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3822) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
17:29:41.207 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.207 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.207 | 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', 3822, 'a:0:{}', '', 1004, '120.244.156.33') |
17:29:41.208 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
17:29:41.209 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.210 | 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', 3822, 1, 17705, 9, 1004, '[17705]', '[17705]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
17:29:41.211 | 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', 510844, 'a:13:{s:2:"id";i:510844;s:9:"object_id";i:3822;s:11:"object_type";i:1;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[17705]";s:9:"new_value";s:7:"[17705]";s:11:"description";s:95:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.33') |
17:29:41.212 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3822 |
17:29:41.212 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
17:29:41.213 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.214 | 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', 3822, 1, 17705, 9, 1004, '17705', '17705', array[1004], '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id" |
17:29:41.215 | 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', 137241, 'a:15:{s:2:"id";i:137241;s:9:"object_id";i:3822;s:11:"object_type";i:1;s:9:"target_id";i:17705;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"17705";s:9:"new_value";s:5:"17705";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":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1004, '120.244.156.33') |
17:29:41.216 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.217 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_schedules" SET "complete_at"='now()', "is_complete"=TRUE, "is_closed"=TRUE WHERE "id"=17705 |
17:29:41.218 | 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\Schedules', 17705, 'a:3:{s:8:"start_at";s:19:"2025-07-13 17:28:00";s:6:"end_at";s:19:"2025-07-13 18:00:00";s:11:"complete_at";s:5:"now()";}', '', 1004, '120.244.156.33') |
17:29:41.218 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17705 |
17:29:41.219 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.220 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=17705 |
17:29:41.220 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
17:29:41.221 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1004, '9', 17705, '伊峻辰完成了一条待办事项', TRUE, '回复回复娜娜') RETURNING "id" |
17:29:41.222 | 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', 170506, 'a:11:{s:2:"id";i:170506;s:9:"object_id";i:17705;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"伊峻辰完成了一条待办事项";s:10:"created_by";i:1004;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:"回复回复娜娜";}', '', 1004, '120.244.156.33') |
17:29:41.223 | info | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1004) AND (channel_id IS NOT NULL) |
17:29:41.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: INCR |
17:29:41.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: HSET |
17:29:41.224 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: LPUSH |
17:29:41.224 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'is_closed', 17705, 9, NULL, NULL, 1004, 'now()', '[false]', '[true]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}'), (2, 'is_closed', 2815, 10, 17705, 9, 1004, 'now()', '[false]', '[true]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}'), (2, 'is_closed', 3822, 1, 17705, 9, 1004, 'now()', '[false]', '[true]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}') |
17:29:41.225 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17705' |
17:29:41.226 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
17:29:41.227 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.227 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3822 |
17:29:41.227 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2 |
17:29:41.228 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.229 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
17:29:41.229 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.230 | 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:29:41.230 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.231 | 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:29:41.231 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=17705 |
17:29:41.233 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
17:29:41.233 | 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:29:41.233 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17705) |
17:29:41.236 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17705 |
17:29:41.237 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17705 ORDER BY "created_at" DESC |
17:29:41.239 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=17705) GROUP BY "object_id" |
17:29:41.262 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1004 AND is_read = false) AND ("object_id"=17705) GROUP BY "object_id" |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateSchedule |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: deleteSchedule |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: createProject |
17:29:41.279 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
17:29:41.279 | 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:29:41.281 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" 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)) 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 |
17:29:41.282 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:29:41.282 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:29:41.282 | 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/schedule/fulfill', '{"ScheduleDescriptions":{"description":"\u79ef\u6781\u7684\u5c31\u653e\u5047","schedule_id":"17705"},"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","posttime":"1752398976","token":"d5b9afdbdfc179978a191474581fe4e0","version_code":"1141"}', '{"code":200,"data":{"model":{"id":17705,"client_id":2815,"schedule_title":"\u56de\u590d\u56de\u590d\u5a1c\u5a1c","description":null,"schedule_week":null,"start_at":"2025-07-13 17:28:00","complete_at":"2025-07-13 17:29:41","complete_description":null,"is_complete":true,"alarm_before":"00:05:00","created_by":1004,"created_at":"2025-07-13 17:28:53","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2025-07-13 18:00:00","is_public":1,"system_calendar_id":null,"creator":1004,"project_id":3822,"updated_at":"2025-07-13 17:29:28","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":3822,"key":3822,"name":"\u9ad8\u5fb7\u5eb7\u8f6f","project_status":2,"budget":"5215","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":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"scheduleCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"headUsers":[{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}],"attachmentRelationships":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":12434,"schedule_id":17705,"description":"\u79ef\u6781\u7684\u5c31\u653e\u5047","created_at":"2025-07-13 17:29:41","created_at_display":"07-13 (\u4eca\u5929) 17:29"},{"id":12433,"schedule_id":17705,"description":"\u79ef\u6781\u53c2\u52a0\u53cd\u6050","created_at":"2025-07-13 17:29:34","created_at_display":"07-13 (\u4eca\u5929) 17:29"}],"commentCount":{"object_id":17705,"comment":5},"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"07-13 (\u4eca\u5929) 17:29","complete_at_display2":"","end_at_display":"2025-07-13 18:00:00+08","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":"2025-07-13 17:28: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":"\u5f85\u529e\u4e8b\u9879\u5df2\u6210\u529f\u6c47\u62a5","error":""}]}', FALSE, '2025-07-13 17:29:41') RETURNING "id" |