接口
12114接口总览
_resource结构
CREATE TABLE `_resource` (`id` int(11) NOT NULL AUTO_INCREMENT,`accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',`resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',`pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',`actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',`desc` varchar(255) DEFAULT NULL COMMENT '描述',`resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',`appDataSchema` text COMMENT 'appData 参数校验',`resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',`requestDemo` text COMMENT '请求Demo',`responseDemo` text COMMENT '响应Demo',`operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',`operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',`operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',`operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 445 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'
_resource 内容
| id | desc | pageId | actionId | resourceType | resourceHook | resourceData |
|---|---|---|---|---|---|---|
| 231 | ✅登陆 | login | passwordLogin | service | { "service": "user", "serviceFunction": "passwordLogin" } | |
| 251 | ✅登出 | allPage | logout | service | { "service": "user", "serviceFunction": "logout" } | |
| 253 | ✅获取用户信息 | allPage | userInfo | service | { "service": "user", "serviceFunction": "userInfo" } | |
| 258 | ✅查询常量 | allPage | getConstantList | sql | { "table": "_constant", "operation": "select" } | |
| 259 | ✅异常日志记录 | allPage | htmlErrorLogRecord | service | {"service": "error", "serviceFunction": "htmlErrorLogRecord"} | |
| 331 | ✅学生宿舍管理-查询列表 | studentHostelManagement | selectItemList | sql | {"table":"view02_student_hostel","operation":"select"} | |
| 332 | ✅学生宿舍管理-添加信息 | studentHostelManagement | insertItem | service | {"before": [{"service": "studentHostel", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []} | {"service":"studentHostel","serviceFunction":"addHostel"} |
| 333 | ✅学生宿舍管理-更新信息 | studentHostelManagement | updateItem | service | {"service":"studentHostel","serviceFunction":"updateHostel"} | |
| 334 | ✅学生宿舍管理-删除信息 | studentHostelManagement | deleteItem | sql | { "table": "student_hostel", "operation": "jhDelete" } | |
| 350 | ✅学生宿舍管理-查询房间信息 | studentHostelManagement | selectRoomList | sql | {"table":"view01_student_hostel_room","operation":"select"} | |
| 351 | ✅学生床位分配-查询楼栋信息 | studentBedAllocation | selectHotelList | sql | {"table":"view02_student_hostel","operation":"select"} | |
| 352 | ✅学生床位分配-查询房间信息 | studentBedAllocation | selectRoomList | service | {"service":"studentHostel","serviceFunction":"selectRoomList"} | |
| 353 | ✅学生床位分配-分配床位 | studentBedAllocation | allotRoomBed | service | {"service":"studentHostel","serviceFunction":"allotRoomBed"} | |
| 354 | ✅学生床位分配-查询学生信息 | studentBedAllocation | selectStudentList | service | {"service":"studentHostel","serviceFunction":"selectStudentList"} | |
| 355 | ✅职员宿舍管理-查询列表 | employeeHostelManagement | selectItemList | sql | {"table":"view02_employee_hostel","operation":"select"} | |
| 356 | ✅职员宿舍管理-添加信息 | employeeHostelManagement | insertItem | service | {"before": [{"service": "employeeHostel", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []} | {"service":"employeeHostel","serviceFunction":"addHostel"} |
| 357 | ✅职员宿舍管理-更新信息 | employeeHostelManagement | updateItem | service | {"service":"employeeHostel","serviceFunction":"updateHostel"} | |
| 358 | ✅职员宿舍管理-删除信息 | employeeHostelManagement | deleteItem | sql | { "table": "employee_hostel", "operation": "jhDelete" } | |
| 359 | ✅职员宿舍管理-查询房间信息 | employeeHostelManagement | selectRoomList | sql | {"table":"view01_employee_hostel_room","operation":"select"} | |
| 360 | ✅职员床位分配-查询楼栋信息 | employeeBedAllocation | selectHotelList | sql | {"table":"view02_employee_hostel","operation":"select"} | |
| 361 | ✅职员床位分配-查询房间信息 | employeeBedAllocation | selectRoomList | service | {"service":"employeeHostel","serviceFunction":"selectRoomList"} | |
| 362 | ✅职员床位分配-分配床位 | employeeBedAllocation | allotRoomBed | service | {"service":"employeeHostel","serviceFunction":"allotRoomBed"} | |
| 363 | ✅职员床位分配-查询职员信息 | employeeBedAllocation | selectEmployeeList | service | {"service":"employeeHostel","serviceFunction":"selectEmployeeList"} | |
| 366 | ✅学生宿舍导入-导入 | importHostelData | importStudentData | service | {"service":"studentHostel","serviceFunction":"importStudentData"} | |
| 367 | ✅学生宿舍导入-查询学生信息 | importHostelData | getStudentData | sql | { "table": "view01_student_basic_class", "operation": "select" } | |
| 368 | ✅职员宿舍导入-查询楼栋列表 | importEmployeeHostelData | selectHostelItemList | sql | { "table": "employee_hostel", "operation": "select" } | |
| 369 | ✅职员宿舍导入-导入 | importEmployeeHostelData | importEmployeeData | service | {"service":"employeeHostel","serviceFunction":"importEmployeeData"} | |
| 372 | ✅职员宿舍导入-获取员工列表 | importEmployeeHostelData | getEmployeeList | sql | { "table": "view01_employee", "operation": "select" } | |
| 373 | ✅职员宿舍导入-查询楼栋房间列表 | importEmployeeHostelData | selectHostelRoomItemList | sql | { "table": "employee_hostel_room", "operation": "select" } | |
| 374 | ✅权限管理页-查询已配置权限列表 | userGroupRole | selectItemList | sql | {"table": "_user_group_role", "operation": "select"} | |
| 375 | ✅权限管理页-查询用户 | userGroupRole | selectUser | sql | {"table": "_view02_user_app", "operation": "select"} | |
| 376 | ✅权限管理页-查询群组 | userGroupRole | selectGroup | sql | {"table": "_group", "operation": "select"} | |
| 377 | ✅权限管理页-创建权限配置 | userGroupRole | insertItem | sql | {"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""} | |
| 378 | ✅权限管理页-更新权限配置 | userGroupRole | updateItem | sql | {"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} | |
| 379 | ✅权限管理页-删除权限配置 | userGroupRole | deleteItem | sql | {"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"} | |
| 380 | ✅权限管理页-查询角色 | userGroupRole | selectRole | sql | {"table": "_role", "operation": "select"} | |
| 381 | ✅权限管理页-添加用户 | userGroupRole | insertUser | service | {"service": "userManagement", "serviceFunction": "addUser"} | |
| 382 | ✅权限管理页-添加群组 | userGroupRole | insertGroup | sql | {"table": "_group", "operation": "jhInsert"} | |
| 383 | ✅权限管理页-添加角色 | userGroupRole | insertRole | sql | {"table": "_role", "operation": "jhInsert"} | |
| 384 | ✅权限管理页-删除用户 | userGroupRole | deleteUser | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_user", "operation": "jhDelete"} |
| 385 | ✅权限管理页-删除群组 | userGroupRole | deleteGroup | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_group", "operation": "jhDelete"} |
| 386 | ✅权限管理页-删除角色 | userGroupRole | deleteRole | sql | { "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] } | {"table": "_role", "operation": "jhDelete"} |
| 387 | ✅权限管理页-更新用户 | userGroupRole | updateUser | sql | {"table": "_user", "operation": "jhUpdate"} | |
| 388 | ✅权限管理页-更新群组 | userGroupRole | updateGroup | sql | {"table": "_group", "operation": "jhUpdate"} | |
| 389 | ✅权限管理页-更新角色 | userGroupRole | updateRole | sql | {"table": "_role", "operation": "jhUpdate"} | |
| 390 | ✅学生床位分配-查询房间信息 | studentBedAllocation | searchStudentItem | sql | {"table": "view02_student_hostel_detail", "operation": "select"} | |
| 391 | ✅职员床位分配-查询职员信息 | employeeBedAllocation | searchEmployeeItem | sql | {"table": "view02_employee_hostel_detail", "operation": "select"} | |
| 392 | ✅查询列表 | semesterArchive | semesterArchive | service | {"service": "semester", "serviceFunction": "semesterArchive"} | |
| 396 | ✅查询没有分配床位的学生 | studentBedAllocation | waitingStudent | sql | {"table": "view01_waiting_student", "operation": "select"} |
_resource语句
INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (259, NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (331, NULL, NULL, 'studentHostelManagement', 'selectItemList', '✅学生宿舍管理-查询列表', 'sql', '{}', '{"table":"view02_student_hostel","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (332, NULL, '{"before": [{"service": "studentHostel", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []}', 'studentHostelManagement', 'insertItem', '✅学生宿舍管理-添加信息', 'service', '{}', '{"service":"studentHostel","serviceFunction":"addHostel"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (333, NULL, NULL, 'studentHostelManagement', 'updateItem', '✅学生宿舍管理-更新信息', 'service', '{}', '{"service":"studentHostel","serviceFunction":"updateHostel"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (334, NULL, NULL, 'studentHostelManagement', 'deleteItem', '✅学生宿舍管理-删除信息', 'sql', '{}', '{ "table": "student_hostel", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (350, NULL, NULL, 'studentHostelManagement', 'selectRoomList', '✅学生宿舍管理-查询房间信息', 'sql', '{}', '{"table":"view01_student_hostel_room","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (351, NULL, NULL, 'studentBedAllocation', 'selectHotelList', '✅学生床位分配-查询楼栋信息', 'sql', '{}', '{"table":"view02_student_hostel","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (352, NULL, NULL, 'studentBedAllocation', 'selectRoomList', '✅学生床位分配-查询房间信息', 'service', '{}', '{"service":"studentHostel","serviceFunction":"selectRoomList"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (353, NULL, NULL, 'studentBedAllocation', 'allotRoomBed', '✅学生床位分配-分配床位', 'service', '{}', '{"service":"studentHostel","serviceFunction":"allotRoomBed"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (354, NULL, NULL, 'studentBedAllocation', 'selectStudentList', '✅学生床位分配-查询学生信息', 'service', '{}', '{"service":"studentHostel","serviceFunction":"selectStudentList"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (355, NULL, NULL, 'employeeHostelManagement', 'selectItemList', '✅职员宿舍管理-查询列表', 'sql', '{}', '{"table":"view02_employee_hostel","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (356, NULL, '{"before": [{"service": "employeeHostel", "serviceFunction": "fillInsertItemParamsBeforeHook"}], "after": []}', 'employeeHostelManagement', 'insertItem', '✅职员宿舍管理-添加信息', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"addHostel"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (357, NULL, NULL, 'employeeHostelManagement', 'updateItem', '✅职员宿舍管理-更新信息', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"updateHostel"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (358, NULL, NULL, 'employeeHostelManagement', 'deleteItem', '✅职员宿舍管理-删除信息', 'sql', '{}', '{ "table": "employee_hostel", "operation": "jhDelete" }', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (359, NULL, NULL, 'employeeHostelManagement', 'selectRoomList', '✅职员宿舍管理-查询房间信息', 'sql', '{}', '{"table":"view01_employee_hostel_room","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (360, NULL, NULL, 'employeeBedAllocation', 'selectHotelList', '✅职员床位分配-查询楼栋信息', 'sql', '{}', '{"table":"view02_employee_hostel","operation":"select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (361, NULL, NULL, 'employeeBedAllocation', 'selectRoomList', '✅职员床位分配-查询房间信息', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"selectRoomList"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (362, NULL, NULL, 'employeeBedAllocation', 'allotRoomBed', '✅职员床位分配-分配床位', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"allotRoomBed"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (363, NULL, NULL, 'employeeBedAllocation', 'selectEmployeeList', '✅职员床位分配-查询职员信息', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"selectEmployeeList"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (366, NULL, NULL, 'importHostelData', 'importStudentData', '✅学生宿舍导入-导入', 'service', '{}', '{"service":"studentHostel","serviceFunction":"importStudentData"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (367, NULL, NULL, 'importHostelData', 'getStudentData', '✅学生宿舍导入-查询学生信息', 'sql', '{}', '{ "table": "view01_student_basic_class", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (368, NULL, NULL, 'importEmployeeHostelData', 'selectHostelItemList', '✅职员宿舍导入-查询楼栋列表', 'sql', '{}', '{ "table": "employee_hostel", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (369, NULL, NULL, 'importEmployeeHostelData', 'importEmployeeData', '✅职员宿舍导入-导入', 'service', '{}', '{"service":"employeeHostel","serviceFunction":"importEmployeeData"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (372, NULL, NULL, 'importEmployeeHostelData', 'getEmployeeList', '✅职员宿舍导入-获取员工列表', 'sql', '{}', '{ "table": "view01_employee", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (373, NULL, NULL, 'importEmployeeHostelData', 'selectHostelRoomItemList', '✅职员宿舍导入-查询楼栋房间列表', 'sql', '{}', '{ "table": "employee_hostel_room", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (374, NULL, NULL, 'userGroupRole', 'selectItemList', '✅权限管理页-查询已配置权限列表', 'sql', NULL, '{"table": "_user_group_role", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "001"}, "pageId": "userGroupRole", "actionId": "selectItemList", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476230231_7262893", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectItemList", "resultData": {"rows": [{"id": 597, "roleId": "teacher", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-02-21T00:41:54+08:00", "operationByUser": "admin", "operationByUserId": "admin"}, {"id": 598, "roleId": "appAdmin", "userId": "001", "groupId": "adminGroup", "operation": "jhInsert", "operationAt": "2022-04-25T14:39:44+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476230231_7262893", "timestamp": "2022-05-02T15:23:50+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:51+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (375, NULL, NULL, 'userGroupRole', 'selectUser', '✅权限管理页-查询用户', 'sql', NULL, '{"table": "_view02_user_app", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476237658_7645348", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651476237658_7645348", "timestamp": "2022-05-02T15:23:58+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:58+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (376, NULL, NULL, 'userGroupRole', 'selectGroup', '✅权限管理页-查询群组', 'sql', NULL, '{"table": "_group", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_6618462", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "管çÂÂç»Â", "groupName": "管çÂÂç»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectGroup", "resultData": {"rows": [{"id": 1, "groupId": "adminGroup", "groupDesc": "管çÂÂç»Â", "groupName": "管çÂÂç»Â", "operation": "jhUpdate", "groupAvatar": null, "groupExtend": "{}", "operationAt": "2022-02-18T20:45:25+08:00", "operationByUser": "admin", "operationByUserId": "admin"}]}}, "packageId": "1651476088200_6618462", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:21:29+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (377, NULL, NULL, 'userGroupRole', 'insertItem', '✅权限管理页-创建权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhInsert", "whereCondition": ""}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"roleId": "teacher", "userId": "admin2", "groupId": "adminGroup"}}, "packageId": "1651149371608_1485871", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [599], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertItem", "resultData": {"rows": [599]}}, "packageId": "1651149371608_1485871", "timestamp": "2022-04-28T20:36:12+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:36:12+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (378, NULL, NULL, 'userGroupRole', 'updateItem', '✅权限管理页-更新权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhUpdate", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T12:09:29+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (379, NULL, NULL, 'userGroupRole', 'deleteItem', '✅权限管理页-删除权限配置', 'sql', NULL, '{"table": "_user_group_role", "operation": "jhDelete", "whereParamsCondition": ".where(function() {this.where(whereParams)})"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T21:03:41+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (380, NULL, NULL, 'userGroupRole', 'selectRole', '✅权限管理页-查询角色', 'sql', NULL, '{"table": "_role", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651476088200_7966907", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "ç³»ç»Â管çÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "èÂÂå¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "å¦çÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}], "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "selectRole", "resultData": {"rows": [{"id": 1, "roleId": "appAdmin", "roleDesc": null, "roleName": "ç³»ç»Â管çÂÂÃ¥ÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 2, "roleId": "teacher", "roleDesc": null, "roleName": "èÂÂå¸Â", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}, {"id": 3, "roleId": "student", "roleDesc": null, "roleName": "å¦çÂÂ", "operation": null, "operationAt": null, "operationByUser": null, "operationByUserId": null}]}}, "packageId": "1651476088200_7966907", "timestamp": "2022-05-02T15:21:29+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:21:29+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (381, NULL, NULL, 'userGroupRole', 'insertUser', '✅权限管理页-添加用户', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"userId": "admin2", "username": "admin2", "clearTextPassword": "123456"}}, "packageId": "1651149323428_7722305", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "insertUser", "resultData": {}}, "packageId": "1651149323428_7722305", "timestamp": "2022-04-28T20:35:24+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:35:24+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (382, NULL, NULL, 'userGroupRole', 'insertGroup', '✅权限管理页-添加群组', 'sql', NULL, '{"table": "_group", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:55:57+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (383, NULL, NULL, 'userGroupRole', 'insertRole', '✅权限管理页-添加角色', 'sql', NULL, '{"table": "_role", "operation": "jhInsert"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:00:37+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (384, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteUser', '✅权限管理页-删除用户', 'sql', NULL, '{"table": "_user", "operation": "jhDelete"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "admin2"}, "pageId": "userGroupRole", "actionId": "deleteUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {}}, "packageId": "1651149383707_8632195", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "deleteUser", "resultData": {"rows": 1}}, "packageId": "1651149383707_8632195", "timestamp": "2022-04-28T20:36:24+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T20:36:24+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (385, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteGroup', '✅权限管理页-删除群组', 'sql', NULL, '{"table": "_group", "operation": "jhDelete"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (386, NULL, '{ "before": [], "after": [{ "service": "userGroupRole", "serviceFunction": "deleteUserGroupRole" }] }', 'userGroupRole', 'deleteRole', '✅权限管理页-删除角色', 'sql', NULL, '{"table": "_role", "operation": "jhDelete"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:04:23+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (387, NULL, NULL, 'userGroupRole', 'updateUser', '✅权限管理页-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"appData": {"appId": "demo_advanced", "where": {"id": 68}, "pageId": "userGroupRole", "actionId": "updateUser", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36", "actionData": {"config": null, "userId": "001", "md5Salt": "ZsPkQcHpYZQT", "password": "b9e96d6ebc84dd51f2bd1fb56a79d8cb", "userType": "common", "username": "å°ÂÃ¥ÂÂ", "operation": "jhUpdate", "idSequence": "26260000", "userStatus": "active", "operationAt": "2022-05-02T15:21:34+08:00", "initPassword": null, "operationByUser": "adminName", "clearTextPassword": "1234567", "operationByUserId": "admin"}}, "packageId": "1651476236716_5991856", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userGroupRole", "actionId": "updateUser", "resultData": {"rows": 1}}, "packageId": "1651476236716_5991856", "timestamp": "2022-05-02T15:23:57+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-05-02T15:23:57+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (388, NULL, NULL, 'userGroupRole', 'updateGroup', '✅权限管理页-更新群组', 'sql', NULL, '{"table": "_group", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T20:45:26+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (389, NULL, NULL, 'userGroupRole', 'updateRole', '✅权限管理页-更新角色', 'sql', NULL, '{"table": "_role", "operation": "jhUpdate"}', '{}', '{}', 'update', NULL, NULL, '2022-02-18T19:56:37+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (390, NULL, NULL, 'studentBedAllocation', 'searchStudentItem', '✅学生床位分配-查询房间信息', 'sql', '{}', '{"table": "view02_student_hostel_detail", "operation": "select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (391, NULL, NULL, 'employeeBedAllocation', 'searchEmployeeItem', '✅职员床位分配-查询职员信息', 'sql', '{}', '{"table": "view02_employee_hostel_detail", "operation": "select"}', NULL, NULL, 'update', 'vscode', 'vscode', '2022-07-19T13:45:11+08:00');INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (392, NULL, NULL, 'semesterArchive', 'semesterArchive', '✅查询列表', 'service', NULL, '{"service": "semester", "serviceFunction": "semesterArchive"}', NULL, NULL, 'insert', NULL, NULL, NULL);INSERT INTO _resource (id, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (396, NULL, NULL, 'studentBedAllocation', 'waitingStudent', '✅查询没有分配床位的学生', 'sql', NULL, '{"table": "view01_waiting_student", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);