14:38:47.979 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
14:38:47.979 | trace | yii\base\Module::getModule | Loading module: debug |
14:38:47.979 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
14:38:47.979 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
14:38:47.979 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
14:38:47.980 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.980 | trace | yii\base\Module::getModule | Loading module: gii |
14:38:47.980 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
14:38:47.980 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
14:38:47.980 | trace | yii\web\Application::handleRequest | Route requested: 'v2/task/save-edit-group' |
14:38:47.980 | trace | yii\base\Module::getModule | Loading module: v2 |
14:38:47.980 | info | yii\web\Session::open | Session started |
14:38:47.981 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
14:38:47.983 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L' |
14:38:47.986 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.986 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:47.986 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.987 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:47.987 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:47.988 | trace | yii\base\Controller::runAction | Route to run: v2/task/save-edit-group |
14:38:47.988 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\TaskController::actionSaveEditGroup() |
14:38:47.988 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.988 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:47.988 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='192' |
14:38:47.989 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking permission: updateTask |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Accountant |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Engineer |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: TechDirector |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: ProjectManager |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 电话销售 |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: AccountManager |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesManager |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 人力资源 |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: SalesDirector |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: CommercialAttache |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: GM |
14:38:47.990 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: 软件开发 |
14:38:47.990 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=5016) AND ("task_group_id"=192) |
14:38:47.991 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.991 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.993 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'id' in 'app\models\TaskGroups'. |
14:38:47.993 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'taskGroupHeads' in 'app\models\TaskGroups'. |
14:38:47.993 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'taskGroupUsers' in 'app\models\TaskGroups'. |
14:38:47.993 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
14:38:47.994 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805') |
14:38:47.994 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
14:38:47.995 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
14:38:47.996 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:47.996 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:47.996 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "object_id"=3805 WHERE ("object_type"=1) AND ("target_id"=192) AND ("target_object_type"=102) |
14:38:48.703 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.703 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.703 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805' |
14:38:48.704 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:48.705 | 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, 'project_id', 192, 102, 5016, 'now()', '["\u54c8\u597d\u54c8\u7535\u8bdd"]', '[null]', '{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u54c8\u597d\u54c8\u7535\u8bdd"]}') |
14:38:48.713 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=2815, "updated_at"='now()', "start_at"='2025-05-12', "project_id"=3805 WHERE "id"=192 |
14:38:48.715 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.715 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.715 | 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\TaskGroups', 192, 'a:1:{s:10:"project_id";s:4:"3805";}', '', 5016, '223.104.41.148') |
14:38:48.723 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=192 |
14:38:48.724 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
14:38:48.724 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000' |
14:38:48.725 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1017' |
14:38:48.725 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
14:38:48.726 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
14:38:48.726 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:48.727 | 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, 'taskGroupUsers', 192, 102, 5016, 'now()', '[["\u66f9\u6c38\u751f","\u8f66\u660e\u98de","\u8463\u8363"]]', '[["\u66f9\u6c38\u751f"]]', '{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u5458","d4":["\u66f9\u6c38\u751f; <b>\u53d8\u4e3a<\/b> \u66f9\u6c38\u751f;\u8f66\u660e\u98de;\u8463\u8363;"]}') |
14:38:48.727 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=192 |
14:38:48.728 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.728 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.728 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (192, 1000), (192, 1017), (192, 5250) |
14:38:48.735 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=192 |
14:38:48.735 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
14:38:48.735 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000' |
14:38:48.736 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1017' |
14:38:48.736 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
14:38:48.737 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:48.737 | 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, 'taskGroupHeads', 192, 102, 5016, 'now()', '[["\u66f9\u6c38\u751f","\u8f66\u660e\u98de"]]', '[["\u66f9\u6c38\u751f"]]', '{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee\u7ecf\u7406","d4":["\u66f9\u6c38\u751f; <b>\u53d8\u4e3a<\/b> \u66f9\u6c38\u751f;\u8f66\u660e\u98de;"]}') |
14:38:48.738 | info | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=192 |
14:38:48.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.739 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.739 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (192, 1000), (192, 1017) |
14:38:48.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.742 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.742 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=192) AND ("status"=0) AND ("head_of" NOT IN ('1000', '1017', '5250')) |
14:38:48.743 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.743 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.743 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
14:38:48.751 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815 |
14:38:48.754 | 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 |
14:38:48.785 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.785 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.785 | 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" |
14:38:48.790 | 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', 164988, 'a:5:{s:2:"id";i:164988;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5016, '223.104.41.148') |
14:38:48.791 | 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:{}', '', 5016, '223.104.41.148') |
14:38:48.793 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:48.793 | 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, 192, 102, 5016, '[192]', '[192]', '{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u60e0\u83f2\u5b81\u7c89"]}') RETURNING "id" |
14:38:48.794 | 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', 509553, 'a:13:{s:2:"id";i:509553;s:9:"object_id";s:4:"2815";s:11:"object_type";i:10;s:9:"target_id";i:192;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[192]";s:9:"new_value";s:5:"[192]";s:11:"description";s:107:"{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u60e0\u83f2\u5b81\u7c89"]}";s:10:"created_by";i:5016;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5016, '223.104.41.148') |
14:38:48.795 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805' |
14:38:48.796 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3805 |
14:38:48.798 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3805) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
14:38:48.805 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.805 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.805 | 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', 3805, 'a:0:{}', '', 5016, '223.104.41.148') |
14:38:48.806 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
14:38:48.807 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
14:38:48.807 | 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', 3805, 1, 192, 102, 5016, '[192]', '[192]', '{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u60e0\u83f2\u5b81\u7c89"]}') RETURNING "id" |
14:38:48.808 | 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', 509554, 'a:13:{s:2:"id";i:509554;s:9:"object_id";s:4:"3805";s:11:"object_type";i:1;s:9:"target_id";i:192;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[192]";s:9:"new_value";s:5:"[192]";s:11:"description";s:107:"{"d1":"\u9ad8\u90e1\u9633","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u60e0\u83f2\u5b81\u7c89"]}";s:10:"created_by";i:5016;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5016, '223.104.41.148') |
14:38:48.809 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
14:38:48.810 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
14:38:48.810 | 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', 5016, 2, 1141, 'v2/task/save-edit-group', '{"TaskGroups":{"client_id":"2815","description":"","id":"192","progress":"","project_id":"3805","situation":"\u529e\u6cd5\u89e3\u51b3\u653e\u5047","start_at":"2025-05-12","target_completed_at":"2025-10-01","taskGroupHeads":["1000","1017"],"taskGroupUsers":["1000","1017","5250"],"title":"\u60e0\u83f2\u5b81\u7c89"},"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","posttime":"1750833536","token":"d0137f56a68ce8fe1700939a03e49b8e","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5217\u8868\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-06-25 14:38:48') RETURNING "id" |