江湖数字化平台
登录

接口

12123

接口总览

_resource结构

  1. CREATE TABLE `_resource` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `jhId` varchar(255) DEFAULT NULL,
  4.   `accessControlTable` varchar(255) DEFAULT NULL COMMENT '数据规则控制表',
  5.   `resourceHook` text COMMENT '[ "before": {"service": "xx", "serviceFunction": "xxx"}, "after": [] }',
  6.   `pageId` varchar(255) DEFAULT NULL COMMENT 'page id; E.g: index',
  7.   `actionId` varchar(255) DEFAULT NULL COMMENT 'action id; E.g: selectXXXByXXX',
  8.   `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  9.   `resourceType` varchar(255) DEFAULT NULL COMMENT 'resource 类型; E.g: auth service sql',
  10.   `appDataSchema` text COMMENT 'appData 参数校验',
  11.   `resourceData` text COMMENT 'resource 数据; { "service": "auth", "serviceFunction": "passwordLogin" } or  { "table": "${tableName}", "action": "select", "whereCondition": ".where(function() {this.whereNot( { recordStatus: \\"active\\" })})" }',
  12.   `requestDemo` text COMMENT '请求Demo',
  13.   `responseDemo` text COMMENT '响应Demo',
  14.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  15.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  16.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  17.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  18.   PRIMARY KEY (`id`) USING BTREE
  19. ) ENGINE = InnoDB AUTO_INCREMENT = 349 DEFAULT CHARSET = utf8mb4 COMMENT = '请求资源表; 软删除未启用; resourceId=`${appId}.${pageId}.${actionId}`'

_resource 内容

id desc pageId actionId resourceType resourceHook resourceData
1 ✅登陆 login passwordLogin service null { "service": "user", "serviceFunction": "passwordLogin" }
2 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
3 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
4 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
5 ✅ 文件分片下载-获取分片信息 allPage getChunkInfo service null { "service": "file", "serviceFunction": "getChunkInfo" }
6 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service null { "service": "file", "serviceFunction": "uploadFileDone" }
7 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service null { "service": "file", "serviceFunction": "uploadFileChunkByStream" }
8 ✅ 文件分片上传-http base64 allPage httpUploadByBase64 service null { "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
9 ✅ 文件分片下载-http base64 allPage httpDownloadByBase64 service null { "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
10 ✅异常日志记录 allPage htmlErrorLogRecord service null { "service": "error", "serviceFunction": "htmlErrorLogRecord" }
11 ✅课程列表-查询课程 courseList selectItemList sql null { "table": "view01_course_with_article_count", "operation": "select" }
12 课程-从课程与班级管理同步课程 courseList syncCourseList service null { "service": "course", "serviceFunction": "syncCourseList" }
13 ✅课程的文章列表-按课程获取文章 articleListByCourse getArticleListByCourse sql null { "table": "view01_course_article", "operation": "select" }
14 ✅课程的文章列表-绑定教材 articleListByCourse insertItem sql null { "table": "course_article", "operation": "jhInsert" }
15 ✅课程的文章列表- articleListByCourse updateItem sql null { "table": "course_article", "operation": "jhUpdate" }
16 ✅课程的文章列表-解绑教材 articleListByCourse deleteItem sql null { "table": "course_article", "operation": "jhDelete" }
18 ✅课程的文章列表-获取文章分类列表 articleListByCourse selectCategoryList sql null { "table": "view01_category", "operation": "select" }
19 articleListByCourse getArticleList sql null { "table": "view01_article_list", "operation": "select" }
21 ✅课程文章列表-添加文章或考试 articleListByCourse insertArticleItem sql { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } { "table": "article", "operation": "jhInsert" }
22 ______✅[可取消]课程文章列表-获取没有绑定课程的文章 articleListByCourse getCourseArticleBinding service { "service": "course", "serviceFunction": "getCourseArticleBinding" }
24 ✅课程文章列表-更新文章标题 articleListByCourse updateArticleTitle sql null { "table": "article", "operation": "jhUpdate" }
25 articleListByCourse getCourseInfo sql null { "table": "course", "operation": "select" }
26 ✅课程的文章列表-向课程绑定文章 articleListByCourse bindNewArticleToCourse service null { "service": "article", "serviceFunction": "bindNewArticleToCourse" }
27 ✅课程的文章列表-将文章移入回收站 articleListByCourse setArticleAsDeleted service null { "service": "article", "serviceFunction": "deletedArticle" }
28 ✅课程的文章列表-从课程中解除绑定文章 articleListByCourse unbindArticleFromCourse sql null { "table": "course_article", "operation": "jhDelete" }
29 articleListByCourse getArticleJustInserted sql null { "table": "article", "operation": "select" }
45 ✅文章列表-查询列表(不包含内容) articleList selectItemList sql null { "table": "view01_article", "operation": "select" }
46 ✅文章列表-查询分类列表 articleList selectCategoryList sql null { "table": "view01_category", "operation": "select" }
49 ✅文章列表-更新成员 articleList jhUpdateItem sql { "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } { "table": "article", "operation": "jhUpdate" }
50 ✅文章编辑-将文章移至回收站 articleList deletedArticle service null { "service": "article", "serviceFunction": "deletedArticle" }
51 ✅文章编辑-文章恢复 articleList restoreArticle service null { "service": "article", "serviceFunction": "restoreArticle" }
52 ✅文章列表-从课程中解除绑定文章 articleList unbindArticleFromCourse sql null { "table": "course_article", "operation": "jhDelete" }
53 ✅文章编辑-查询文章列表 articleEdit selectItemList sql null { "table": "article", "operation": "select" }
54 ✅文章编辑-查询列表 articleEdit selectCategoryList sql null { "table": "view01_category", "operation": "select" }
55 ✅文章编辑-课程列表 articleEdit selectCourseList sql null { "table": "course", "operation": "select", "fieldList": [ "courseId", "courseBatchId", "courseName", "courseStatus", "operationAt" ] }
57 ✅文章编辑-查询带文集信息的文章 articleEdit selectArticleWithCategory service null { "service": "article", "serviceFunction": "getArticleAndFillArticles" }
58 ✅文章编辑-添加成员 articleEdit jhInsertItem sql { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } { "table": "article", "operation": "jhInsert" }
59 ✅文章编辑-更新成员 articleEdit jhUpdateItem sql { "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } { "table": "article", "operation": "jhUpdate" }
60 ✅文章编辑-将文章移至回收站 articleEdit deletedArticle service { "service": "article", "serviceFunction": "deletedArticle" }
61 ✅文章编辑-文章恢复 articleEdit restoreArticle service null { "service": "article", "serviceFunction": "restoreArticle" }
62 ✅文章编辑-使用素材 articleEdit useMaterial service null { "service": "material", "serviceFunction": "useMaterial" }
63 ✅查询文章作业 assignmentDesign selectArticleAssignment sql null { "table": "article", "operation": "select" }
64 ✅更新文章作业 assignmentDesign updateArticleAssignment sql { "after": [ { "service": "article", "serviceFunction": "afterEditQuestionHook" } ] } { "table": "article", "operation": "jhUpdate" }
65 ✅作业设计-题库列表 assignmentDesign selectQuestionList sql null { "table": "question", "operation": "select" }
66 articlePreview selectItemList service null { "service": "article", "serviceFunction": "getArticleListFromArticleQuery" }
67 articlePreview selectArticleInfo service null { "service": "article", "serviceFunction": "getArticleAndFillArticles" }
68 ✅xf编辑-文件列表 articleEdit list service null { "service": "material", "serviceFunction": "list" }
69 ✅xf编辑-创建文件夹 articleEdit mkdir service null { "service": "material", "serviceFunction": "mkdir" }
70 ✅xf编辑-移动文件 articleEdit moveFile service null { "service": "material", "serviceFunction": "moveFile" }
71 ✅xf编辑-复制文件 articleEdit copyFile service null { "service": "material", "serviceFunction": "copyFile" }
72 ✅xf编辑-文件重命名 articleEdit renameFile service null { "service": "material", "serviceFunction": "renameFile" }
73 ✅xf编辑-删除 articleEdit delete service null { "service": "material", "serviceFunction": "delete" }
74 ✅xf编辑-清空回收站 articleEdit clearRecycle service null { "service": "material", "serviceFunction": "clearRecycle" }
75 ✅考试列表-查询列表(不包含内容) examList selectItemList sql null { "table": "view01_article", "operation": "select" }
76 ✅考试列表-查询分类列表 examList selectCategoryList sql null { "table": "view01_category", "operation": "select" }
77 ✅考卷列表-获取课程列表 examList selectCourseList sql null { "table": "course", "operation": "select" }
78 examList insertArticleItem sql { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } { "table": "article", "operation": "jhInsert" }
79 examList updateArticleTitle sql null { "table": "article", "operation": "jhUpdate" }
80 ✅试卷列表-从课程中解除绑定文章 examList unbindArticleFromCourse sql null { "table": "course_article", "operation": "jhDelete" }
81 ✅素材管理-文件列表 mediaLibrary list service null { "service": "material", "serviceFunction": "list" }
82 ✅素材管理-创建文件夹 mediaLibrary mkdir service null { "service": "material", "serviceFunction": "mkdir" }
83 ✅素材管理-删除 mediaLibrary delete service null { "service": "material", "serviceFunction": "delete" }
84 ✅素材管理-清空回收站 mediaLibrary clearRecycle service null { "service": "material", "serviceFunction": "clearRecycle" }
85 ✅素材管理-文件重命名 mediaLibrary renameFile service null { "service": "material", "serviceFunction": "renameFile" }
86 ✅素材管理-移动文件 mediaLibrary moveFile service null { "service": "material", "serviceFunction": "moveFile" }
87 ✅素材管理-复制文件 mediaLibrary copyFile service null { "service": "material", "serviceFunction": "copyFile" }
88 ✅查询列表 questionManagement selectItemList sql null { "table": "question", "operation": "select" }
89 ✅文章编辑-从课程中解除绑定文章 articleEdit unbindArticleFromCourse sql null { "table": "course_article", "operation": "jhDelete" }
90 ✅待批准的文章-待批准的文章列表 designArticleManagement selectItemList sql null { "table": "view01_design_article", "operation": "select" }
91 ✅待批准的文章-查询分类列表 designArticleManagement selectDesignCategoryList sql null { "table": "view01_design_category", "operation": "select" }
92 ✅待批准的文章-批准“文章开发平台”的三稿 designArticleManagement copyArticleFromDesign service null { "service": "article", "serviceFunction": "copyArticleFromDesign" }
93 ✅获取题目建议 assignmentDesign getAnswerPoints service null { "service": "assignment", "serviceFunction": "getAnswerPoints" }
94 ✅登陆 login passwordLogin service null { "service": "user", "serviceFunction": "passwordLogin" }
95 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
96 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
97 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
98 ✅用户管理-查询信息 userManagement selectItemList sql null { "table": "_user", "operation": "select" }
99 ✅用户管理-查询信息 userManagement insertItem service null { "service": "userManagement", "serviceFunction": "addUser" }
100 ✅用户管理-修改密码 userManagement resetUserPassword service null { "service": "userManagement", "serviceFunction": "resetUserPassword" }
101 ✅用户管理-更新用户 userManagement updateItem sql null { "table": "_user", "operation": "jhUpdate" }
102 ✅查询列表 memberManagement selectItemList sql null { "table": "cgg_member_v3", "operation": "select" }
103 ✅添加 memberManagement insertItem sql null { "table": "cgg_member_v3", "operation": "insert" }
104 ✅更新 memberManagement updateItem sql null { "table": "cgg_member_v3", "operation": "jhUpdate" }
105 ✅删除 memberManagement deleteItem sql null { "table": "cgg_member_v3", "operation": "jhDelete" }
106 ✅课程查询-查询列表 courseSeriesManagement selectItemList sql null { "table": "cgg_course_series", "operation": "select" }
107 ✅课程查询-添加成员 courseSeriesManagement insertItem sql null { "table": "cgg_course_series", "operation": "jhInsert" }
108 ✅课程查询-更新成员 courseSeriesManagement updateItem sql null { "table": "cgg_course_series", "operation": "jhUpdate" }
109 ✅课程查询-删除信息 courseSeriesManagement deleteItem sql null { "table": "cgg_course_series", "operation": "jhDelete" }
110 ✅课程的课程分期管理-查询当前课程分期下的课程列表 courseManagement selectCurrentList sql null { "table": "cgg_course", "operation": "select" }
111 ✅课程的课程分期管理-建立关系 courseManagement insertItem sql null { "table": "cgg_course", "operation": "jhInsert" }
112 ✅课程的课程分期管理-更新数据 courseManagement updateItem sql null { "table": "cgg_course", "operation": "jhUpdate" }
113 ✅课程的课程分期管理-删除信息 courseManagement deleteItem sql null { "table": "cgg_course", "operation": "jhDelete" }
114 ✅课程查询-查询列表 courseManagement selectAllList sql null { "table": "cgg_course", "operation": "select" }
115 ✅班级查询-查询列表 courseClassManagement selectItemList sql null { "table": "course_class", "operation": "select" }
116 ✅班级查询-添加成员 courseClassManagement insertItem sql null { "table": "course_class", "operation": "jhInsert" }
117 ✅班级查询-更新成员 courseClassManagement updateItem sql null { "table": "course_class", "operation": "jhUpdate" }
118 ✅班级查询-删除信息 courseClassManagement deleteItem sql null { "table": "course_class", "operation": "jhDelete" }
119 ✅班级的班级成员管理-查询当前班级成员下的班级列表 courseClassMemberManagement selectCurrentList sql null { "table": "class_member", "operation": "select" }
120 ✅班级的班级成员管理-建立关系 courseClassMemberManagement insertItem sql null { "table": "class_member", "operation": "jhInsert" }
121 ✅班级的班级成员管理-更新数据 courseClassMemberManagement updateItem sql null { "table": "class_member", "operation": "jhUpdate" }
122 ✅班级的班级成员管理-删除信息 courseClassMemberManagement deleteItem sql null { "table": "class_member", "operation": "jhDelete" }
123 ✅班级查询-查询列表 courseClassMemberManagement selectAllList sql null { "table": "class_member", "operation": "select" }
124 ✅成员查询 courseClassMemberManagement getMemberList sql null { "table": "cgg_member_v3", "operation": "select" }
125 ✅成员查询 courseClassMemberManagement insertClassMember service null { "service": "class", "serviceFunction": "insertClassMember" }
126 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
127 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
128 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
129 ✅ 文件分片下载-获取分片信息 allPage getChunkInfo service null { "service": "file", "serviceFunction": "getChunkInfo" }
130 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service null { "service": "file", "serviceFunction": "uploadFileDone" }
131 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service null { "service": "file", "serviceFunction": "uploadFileChunkByStream" }
132 ✅ 文件分片上传-http base64 allPage httpUploadByBase64 service null { "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
133 ✅异常日志记录 allPage htmlErrorLogRecord service null { "service": "error", "serviceFunction": "htmlErrorLogRecord" }
134 ✅登陆 login passwordLogin service { "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] } { "service": "user", "serviceFunction": "passwordLogin" }
135 ✅保存笔记 home_note saveArticleNote service { "service": "note", "serviceFunction": "saveArticleNote" }
136 ✅课程列表-获取我的课程 courseList getMyCourseList sql null { "table": "view01_user_course", "operation": "select" }
139 ✅学习内容-获取笔记列表 courseArticleList getNoteList sql null { "table": "view01_note_list", "operation": "select" }
140 ✅学习内容-获取作业列表 courseArticleList getAssignmentList sql null { "table": "view01_assignment_list", "operation": "select" }
141 ✅学习内容-获取考试列表 courseArticleList getExamList sql null { "table": "view01_exam_list", "operation": "select" }
142 ✅学习内容-获取课程学习内容 courseArticleList getMyCourseArticleList sql null { "table": "view01_user_course_article", "operation": "select" }
143 ✅学习内容-获取出勤列表 courseArticleList getAttendanceList sql null { "table": "attendance", "operation": "select" }
145 examPaper getExamPaper sql { "before": [ { "service": "exam", "serviceFunction": "passcodeCheck" } ], "after": [] } { "table": "view01_course_article_detail", "operation": "select" }
146 examPaper insertItem sql { "before": [ { "service": "exam", "serviceFunction": "appendAssignIdToActionData" } ], "after": [ { "service": "exam", "serviceFunction": "insertAutomaticScoring" } ] } { "table": "examination", "operation": "insert" }
147 examPaper updateItem sql { "table": "examination", "operation": "update" }
148 examPaper getSavedAnswer sql null { "table": "view01_exam", "operation": "select" }
151 examPaper getExamInfo sql { "before": [ { "service": "exam", "serviceFunction": "checkUserExam" } ], "after": [] } { "table": "view01_course_article_detail", "operation": "select" }
152 文章详情 articleDetail getArticleInfo sql null { "table": "view01_article", "operation": "select" }
156 ✅文章详情-添加视频播放时长 articleDetail addVideoPlayTime service null { "service": "student", "serviceFunction": "addVideoPlayTime" }
157 ?笔记-获取笔记内容 articleDetail selectItemList sql { "before": [ { "service": "userCenter", "serviceFunction": "appendUserIdToWhere" } ] } { "table": "note", "operation": "select" }
158 ✅作业-创建作业 assignmentPaper insertUserAssignment service { "after": [ { "service": "assignment", "serviceFunction": "insertAutomaticScoring" } ] } { "service": "assignment", "serviceFunction": "insertUserAssignment" }
159 ✅作业-获取作业 assignmentPaper getUserAssignment sql { "after": [ { "service": "assignment", "serviceFunction": "checkAndRemoveStandardAnswer" } ] } { "table": "assignment", "operation": "select" }
160 ✅作业-保存作业草稿 assignmentPaper saveUserAssignment sql { "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" } ] } { "table": "assignment", "operation": "jhUpdate" }
161 ✅作业-提交作业 assignmentPaper submitUserAssignment sql { "before": [ { "service": "assignment", "serviceFunction": "autoReviewUserAssignment" } ], "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" }, { "service": "assignment", "serviceFunction": "updateAutomaticScoring" } ] } { "table": "assignment", "operation": "jhUpdate" }
162 ✅作业-重做作业 assignmentPaper redoUserAssignment sql { "before": [ { "service": "assignment", "serviceFunction": "redoUserAssignment" } ] } { "table": "assignment", "operation": "jhUpdate" }
163 ✅学习内容-获取课程信息 courseArticleList getCourseInfo sql null { "table": "course", "operation": "select" }
170 ✅笔记-撤销提交 home_assignment revertUserNote sql null { "table": "note", "operation": "jhUpdate" }
198 ✅更新用户信息 allPage updateUserInfo sql null { "table": "_user", "operation": "jhUpdate" }
199 ✅获取课程详情 courseDetail getCourseDetail sql { "table": "course", "operation": "select" }
200 ✅获取文章列表 courseDetail getArticleList sql { "table": "view01_course_article_detail", "operation": "select" }
201 ✅获取课程评论列表 courseDetail getCommentList sql { "table": "user_comment", "operation": "select" }
202 ✅添加评论 courseDetail addComment sql { "table": "user_comment", "operation": "jhInsert" }
203 ✅课程详情-获取课程用户 courseDetail getCourseUserList sql null { "table": "course_user", "operation": "select" }
204 ✅创建课程订单 courseDetail createCourseOrder service null { "service": "order", "serviceFunction": "createCourseOrder" }
205 ✅获取文章详情 wap/articleDetail getArticleDetail sql null { "table": "article", "operation": "select" }
206 ✅获取作业详情 assignmentPaper getAssignmentDetail sql { "after": [ { "service": "assignment", "serviceFunction": "checkUserAssignmentStatusAfterHook" } ] } { "table": "view01_article", "operation": "select" }
207 wap/examIndex passwordCheck sql { "before": [], "after": [ { "service": "exam", "serviceFunction": "passcodeCheck" } ] } { "table": "view01_course_article_detail", "operation": "select" }
208 wap/examIndex getUserExamInfo sql { "before": [ { "service": "exam", "serviceFunction": "checkUserExam" } ], "after": [] } { "table": "examination", "operation": "select" }
209 wap/examIndex insertItem sql { "before": [ { "service": "exam", "serviceFunction": "appendAssignIdToActionData" } ], "after": [ { "service": "exam", "serviceFunction": "insertAutomaticScoring" } ] } { "table": "examination", "operation": "insert" }
210 wap/examDetail getAssignmentDetail sql { "before": [ { "service": "exam", "serviceFunction": "checkUserExam" } ], "after": [] } { "table": "view01_exam", "operation": "select" }
211 ✅作业-保存作业草稿 wap/examDetail saveUserAssignment sql { "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" } ] } { "table": "examination", "operation": "jhUpdate" }
212 wap/examIndex getExamInfo sql { "before": [ { "service": "exam", "serviceFunction": "checkUserExam" } ], "after": [] } { "table": "view01_course_article_detail", "operation": "select" }
213 wap/examDetail getCourseArticleInfo sql null { "table": "view01_course_article_detail", "operation": "select" }
214 ✅作业-重做考试 wap/examDetail redoUserExam sql { "before": [ { "service": "exam", "serviceFunction": "redoUserExam" } ] } { "table": "examination", "operation": "jhUpdate" }
215 ✅课程列表-获取我的课程 wap/courseList getMyCourseList sql { "after": [ { "service": "course", "serviceFunction": "courseListAfterHook" } ] } { "table": "view01_user_course", "operation": "select" }
217 ✅获取课程详情 wap/courseDetail getCourseDetail sql { "after": [ { "service": "course", "serviceFunction": "courseListAfterHook" } ] } { "table": "course", "operation": "select" }
218 ✅获取文章列表 wap/courseDetail getArticleList sql { "after": [ { "service": "article", "serviceFunction": "articleListAfterHook" } ] } { "table": "view01_course_article_detail", "operation": "select" }
219 ✅作业-获取作业 wap/assignmentDetail getUserAssignment sql { "table": "assignment", "operation": "select" }
220 ✅作业-保存作业草稿 wap/assignmentDetail saveUserAssignment sql { "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" } ] } { "table": "assignment", "operation": "jhUpdate" }
221 ✅作业-提交作业 wap/assignmentDetail submitUserAssignment sql { "before": [ { "service": "assignment", "serviceFunction": "autoReviewUserAssignment" } ], "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" }, { "service": "assignment", "serviceFunction": "updateAutomaticScoring" } ] } { "table": "assignment", "operation": "jhUpdate" }
222 ✅作业-重做作业 wap/assignmentDetail redoUserAssignment sql { "before": [ { "service": "assignment", "serviceFunction": "redoUserAssignment" } ] } { "table": "assignment", "operation": "jhUpdate" }
223 ✅作业-创建作业 wap/assignmentIndex insertUserAssignment service { "after": [ { "service": "assignment", "serviceFunction": "insertAutomaticScoring" } ] } { "service": "assignment", "serviceFunction": "insertUserAssignment" }
224 ✅获取作业详情 wap/assignmentIndex getAssignmentDetail sql { "after": [ { "service": "assignment", "serviceFunction": "checkUserAssignmentStatusAfterHook" } ] } { "table": "view01_article", "operation": "select" }
225 ✅笔记列表 wap/my/studyRecord getNoteList sql { "after": [ { "service": "article", "serviceFunction": "recordAssignArticleId" } ] } { "table": "note", "operation": "select" }
226 ✅作业列表 wap/my/studyRecord getAssignmentList sql { "after": [ { "service": "article", "serviceFunction": "recordAssignArticleId" } ] } { "table": "assignment", "operation": "select" }
227 ✅考试列表 wap/my/studyRecord getExamList sql { "after": [ { "service": "article", "serviceFunction": "recordAssignArticleId" } ] } { "table": "examination", "operation": "select" }
228 wap/assignmentDetail getCourseArticleInfo sql null { "table": "view01_course_article_detail", "operation": "select" }
229 wap/examIndex insertItem sql { "before": [ { "service": "exam", "serviceFunction": "appendAssignIdToActionData" } ], "after": [ { "service": "exam", "serviceFunction": "insertAutomaticScoring" } ] } { "table": "examination", "operation": "insert" }
230 ✅保存笔记 wap/articleDetail saveArticleNote service null { "service": "note", "serviceFunction": "saveArticleNote" }
231 ✅笔记-撤销提交 wap/articleDetail revertUserNote sql null { "table": "note", "operation": "jhUpdate" }
232 ?笔记-获取笔记内容 wap/articleDetail selectItemList sql { "before": [ { "service": "userCenter", "serviceFunction": "appendUserIdToWhere" } ] } { "table": "note", "operation": "select" }
233 md2html selectItemList service null { "service": "article", "serviceFunction": "getArticleListFromArticleQuery" }
234 ✅登陆 login passwordLogin service null { "service": "user", "serviceFunction": "passwordLogin" }
235 ✅登出 allPage logout service null { "service": "user", "serviceFunction": "logout" }
236 ✅获取用户信息 allPage userInfo service null { "service": "user", "serviceFunction": "userInfo" }
237 ✅查询常量 allPage getConstantList sql null { "table": "_constant", "operation": "select" }
238 ✅修改用户密码 allPage resetPassword service null { "service": "user", "serviceFunction": "resetPassword" }
239 ✅ 文件分片下载-获取分片信息 allPage getChunkInfo service null { "service": "file", "serviceFunction": "getChunkInfo" }
240 ✅ 文件分片上传-所有分片上传完毕 allPage uploadFileDone service null { "service": "file", "serviceFunction": "uploadFileDone" }
241 ✅ 文件分片上传-http文件流 allPage httpUploadByStream service null { "service": "file", "serviceFunction": "uploadFileChunkByStream" }
242 ✅ 文件分片上传-http base64 allPage httpUploadByBase64 service null { "service": "file", "serviceFunction": "uploadFileChunkByBase64" }
243 ✅ 文件分片下载-http base64 allPage httpDownloadByBase64 service null { "service": "file", "serviceFunction": "downloadFileChunkByBase64" }
244 ✅异常日志记录 allPage htmlErrorLogRecord service null { "service": "error", "serviceFunction": "htmlErrorLogRecord" }
245 assignmentList getClassList sql null { "table": "view01_class_member", "operation": "select" }
246 assignmentList getStudentListByClass sql null { "table": "view01_class_member", "operation": "select" }
247 assignmentList getLessonListByClass sql null { "table": "view01_course_article", "operation": "select" }
248 assignmentList getAssignmentListByClass sql null { "table": "assignment", "operation": "select" }
249 ✅assignmentManagement查询-查询列表 assignmentReview selectItemList sql { "before": [ { "service": "assignment", "serviceFunction": "checkAssignmentReview" } ] } { "table": "view02_assignment_for_review", "operation": "select" }
250 assignmentReview getCourseInfo sql null { "table": "course", "operation": "select" }
251 ✅模拟做题-更新 assignmentReview updateItem sql { "after": [ { "service": "assignment", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } { "table": "assignment", "operation": "jhUpdate" }
252 noteList getClassList sql null { "table": "view01_class_member", "operation": "select" }
253 noteList getStudentListByClass sql null { "table": "view01_class_member", "operation": "select" }
254 noteList getLessonListByClass sql null { "table": "view01_course_article", "operation": "select" }
255 noteList getNoteListByClass sql null { "table": "note", "operation": "select" }
256 ✅查询-查询列表 assignmentReview selectNoteList sql { "before": [ { "service": "note", "serviceFunction": "checkNoteReview" } ] } { "table": "note", "operation": "select" }
257 ✅更新 noteManagement updateItem sql { "after": [ { "service": "note", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } { "table": "note", "operation": "jhUpdate" }
258 ✅作业管理-查询列表 examManagement selectItemList service null { "service": "assignment", "serviceFunction": "selectTeacherExam" }
260 ✅撤销提交 examManagement cancelSubmit sql null { "table": "examination", "operation": "jhUpdate" }
261 ✅assignmentManagement查询-查询列表 examReview selectItemList sql { "before": [ { "service": "assignment", "serviceFunction": "checkAssignmentReview" } ] } { "table": "view02_examination_for_review", "operation": "select" }
262 ✅模拟做题-更新 examReview updateItem sql { "after": [ { "service": "assignment", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } { "table": "examination", "operation": "jhUpdate" }
263 attendanceList getClassList sql null { "table": "view01_class_member", "operation": "select" }
264 attendanceList getStudentListByClass sql null { "table": "view01_class_member", "operation": "select" }
265 attendanceList getLessonListByClass sql null { "table": "view01_course_article", "operation": "select" }
266 attendanceList getAttendanceListByClass sql null { "table": "attendance", "operation": "select" }
267 ✅出勤记录-更新 attendanceList updateItem sql null { "table": "attendance", "operation": "jhUpdate" }
268 ✅出勤记录-查询班级 attendanceRecord selectGroupList sql { "before": [ { "service": "group", "serviceFunction": "beforeAppendGroupIdToWhereIn" } ] } { "table": "view01_class_attendance", "operation": "select" }
270 ✅出勤记录-查询学员列表 attendanceRecord selectTeacherStudentList sql { "before": [ { "service": "group", "serviceFunction": "beforeAppendGroupIdToWhereIn" } ] } { "table": "view01_baofeng_student_group_role", "operation": "select" }
271 ✅出勤记录-查询出勤记录 attendanceRecord selectAttendanceRecordList sql { "table": "view02_attendance", "operation": "select" }
272 ✅创建出勤记录 attendanceRecord createAttendanceRecord service null { "service": "attendance", "serviceFunction": "createAttendanceRecord" }
273 ✅出勤记录-更新 attendanceRecord updateItem sql { "table": "attendance", "operation": "jhUpdate" }
274 ✅创建出勤记录 attendanceRecord updateAttendanceRecord service null { "service": "attendance", "serviceFunction": "updateAttendanceRecord" }
275 myStudentList getCourseListByTeacher sql null { "table": "view01_class_member", "operation": "select" }
276 myStudentList getStudentListByCourse sql { "before": [ { "service": "learningRecord", "serviceFunction": "beforeAppendClassStudentIdToWhereIn" } ] } { "table": "view01_student_learning_record", "operation": "select" }
277 myStudentList getCourseLessonDataForTeacher service null { "service": "learningRecord", "serviceFunction": "getCourseLessonDataForTeacher" }
278 myStudentList getStudentLearningRecordByStudent sql null { "table": "student_learning_record", "operation": "select" }
279 myStudentList updateItem sql { "before": [ { "service": "learningRecord", "serviceFunction": "checkExistCourseMemberId" } ] } { "table": "student_learning_record", "operation": "jhUpdate" }
280 myStudentList getLatestLearningRecordForStudent service null { "service": "learningRecord", "serviceFunction": "getLatestLearningRecordForStudent" }
281 ✅查询列表 studentWarn selectItemList service null { "service": "assignment", "serviceFunction": "studentBehavior" }
282 ✅查询列表 teacherWarn selectItemList sql null { "table": "view01_teacher_behavior", "operation": "select" }
346 ✅我的学员-发布学生毕业记录 myStudentList createCompleteCourseRecord sql null { "table": "student_complete_course_record", "operation": "jhInsert" }
347 myStudentList updateItemDev sql { "before": [ { "service": "learningRecord", "serviceFunction": "checkExistCourseMemberId" } ] } { "table": "__dev__student_learning_record", "operation": "jhUpdate" }
348 myStudentList revokeCompleteCourseRecord sql null { "table": "student_complete_course_record", "operation": "jhDelete" }

_resource语句

  1. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'course_mgmt', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  2. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'course_mgmt', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'course_mgmt', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  4. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'course_mgmt', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'course_mgmt', NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  6. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'course_mgmt', NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'course_mgmt', NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  8. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'course_mgmt', NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  9. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'course_mgmt', NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  10. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'course_mgmt', NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', '', '', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'course_mgmt', 'access_control_course', NULL, 'courseList', 'selectItemList', '✅课程列表-查询课程', 'sql', '{}', '{ "table": "view01_course_with_article_count", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  12. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'course_mgmt', NULL, NULL, 'courseList', 'syncCourseList', '课程-从课程与班级管理同步课程', 'service', NULL, '{ "service": "course", "serviceFunction": "syncCourseList" }', '', '', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'course_mgmt', 'access_control_album_or_article', NULL, 'articleListByCourse', 'getArticleListByCourse', '✅课程的文章列表-按课程获取文章', 'sql', NULL, '{ "table": "view01_course_article", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  14. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'insertItem', '✅课程的文章列表-绑定教材', 'sql', NULL, '{ "table": "course_article", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'updateItem', '✅课程的文章列表-', 'sql', NULL, '{ "table": "course_article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'deleteItem', '✅课程的文章列表-解绑教材', 'sql', NULL, '{ "table": "course_article", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  17. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'selectCategoryList', '✅课程的文章列表-获取文章分类列表', 'sql', NULL, '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  18. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'course_mgmt', 'access_control_album_or_article', NULL, 'articleListByCourse', 'getArticleList', NULL, 'sql', NULL, '{ "table": "view01_article_list", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  19. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'course_mgmt', NULL, '{ "before": [
  20. {"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"}
  21. ], "after": [
  22. {"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
  23. ] }', 'articleListByCourse', 'insertArticleItem', '✅课程文章列表-添加文章或考试', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
  24. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'course_mgmt', NULL, '', 'articleListByCourse', 'getCourseArticleBinding', '______✅[可取消]课程文章列表-获取没有绑定课程的文章', 'service', '{}', '{ "service": "course", "serviceFunction": "getCourseArticleBinding" }', '', '', 'insert', NULL, NULL, NULL);
  25. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'updateArticleTitle', '✅课程文章列表-更新文章标题', 'sql', NULL, '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  26. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'getCourseInfo', NULL, 'sql', NULL, '{"table":"course","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  27. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'bindNewArticleToCourse', '✅课程的文章列表-向课程绑定文章', 'service', '{}', '{ "service": "article", "serviceFunction": "bindNewArticleToCourse" }', '', '', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'setArticleAsDeleted', '✅课程的文章列表-将文章移入回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
  29. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'unbindArticleFromCourse', '✅课程的文章列表-从课程中解除绑定文章', 'sql', '{}', '{ "table": "course_article", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  30. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'course_mgmt', NULL, NULL, 'articleListByCourse', 'getArticleJustInserted', NULL, 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  31. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'course_mgmt', 'access_control_album_or_article', NULL, 'articleList', 'selectItemList', '✅文章列表-查询列表(不包含内容)', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
  32. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'course_mgmt', NULL, NULL, 'articleList', 'selectCategoryList', '✅文章列表-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  33. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'course_mgmt', NULL, '{ "before": [
  34. {"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
  35. ], "after": [
  36. {"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
  37. ] }', 'articleList', 'jhUpdateItem', '✅文章列表-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  38. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'course_mgmt', NULL, NULL, 'articleList', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
  39. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'course_mgmt', NULL, NULL, 'articleList', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
  40. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'course_mgmt', NULL, NULL, 'articleList', 'unbindArticleFromCourse', '✅文章列表-从课程中解除绑定文章', 'sql', '{}', '{ "table": "course_article", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  41. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'course_mgmt', NULL, NULL, 'articleEdit', 'selectItemList', '✅文章编辑-查询文章列表', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
  42. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'course_mgmt', NULL, NULL, 'articleEdit', 'selectCategoryList', '✅文章编辑-查询列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  43. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'course_mgmt', 'access_control_course', NULL, 'articleEdit', 'selectCourseList', '✅文章编辑-课程列表', 'sql', '{}', '{"table":"course","operation":"select", "fieldList": ["courseId", "courseBatchId", "courseName", "courseStatus", "operationAt"]}', '', '', 'update', 'vscode', 'vscode', '2022-07-28T08:56:53+08:00');
  44. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'course_mgmt', NULL, NULL, 'articleEdit', 'selectArticleWithCategory', '✅文章编辑-查询带文集信息的文章', 'service', '{}', '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
  45. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'course_mgmt', NULL, '{ "before": [
  46. {"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"}
  47. ], "after": [
  48. {"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
  49. ] }', 'articleEdit', 'jhInsertItem', '✅文章编辑-添加成员', 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'jhInsert', NULL, NULL, NULL);
  50. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'course_mgmt', NULL, '{ "before": [
  51. {"service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook"}
  52. ], "after": [
  53. {"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
  54. ] }', 'articleEdit', 'jhUpdateItem', '✅文章编辑-更新成员', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  55. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'course_mgmt', NULL, '', 'articleEdit', 'deletedArticle', '✅文章编辑-将文章移至回收站', 'service', '{}', '{ "service": "article", "serviceFunction": "deletedArticle" }', '', '', 'insert', NULL, NULL, NULL);
  56. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'course_mgmt', NULL, NULL, 'articleEdit', 'restoreArticle', '✅文章编辑-文章恢复', 'service', '{}', '{ "service": "article", "serviceFunction": "restoreArticle" }', '', '', 'insert', NULL, NULL, NULL);
  57. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'course_mgmt', NULL, NULL, 'articleEdit', 'useMaterial', '✅文章编辑-使用素材', 'service', '{}', '{ "service": "material", "serviceFunction": "useMaterial" }', '', '', 'insert', NULL, NULL, NULL);
  58. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'course_mgmt', NULL, NULL, 'assignmentDesign', 'selectArticleAssignment', '✅查询文章作业', 'sql', '{}', '{ "table": "article", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  59. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (64, 'course_mgmt', NULL, '{ "after": [
  60. {"service": "article", "serviceFunction": "afterEditQuestionHook"}
  61. ] }', 'assignmentDesign', 'updateArticleAssignment', '✅更新文章作业', 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  62. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'course_mgmt', NULL, NULL, 'assignmentDesign', 'selectQuestionList', '✅作业设计-题库列表', 'sql', '{}', '{"table":"question","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-07-28T08:56:53+08:00');
  63. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'course_mgmt', NULL, NULL, 'articlePreview', 'selectItemList', NULL, 'service', NULL, '{ "service": "article", "serviceFunction": "getArticleListFromArticleQuery" }', '', '', 'insert', NULL, NULL, NULL);
  64. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'course_mgmt', NULL, NULL, 'articlePreview', 'selectArticleInfo', NULL, 'service', NULL, '{ "service": "article", "serviceFunction": "getArticleAndFillArticles" }', '', '', 'insert', NULL, NULL, NULL);
  65. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'course_mgmt', NULL, NULL, 'articleEdit', 'list', '✅xf编辑-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
  66. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (69, 'course_mgmt', NULL, NULL, 'articleEdit', 'mkdir', '✅xf编辑-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
  67. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'course_mgmt', NULL, NULL, 'articleEdit', 'moveFile', '✅xf编辑-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
  68. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'course_mgmt', NULL, NULL, 'articleEdit', 'copyFile', '✅xf编辑-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
  69. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'course_mgmt', NULL, NULL, 'articleEdit', 'renameFile', '✅xf编辑-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
  70. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (73, 'course_mgmt', NULL, NULL, 'articleEdit', 'delete', '✅xf编辑-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
  71. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'course_mgmt', NULL, NULL, 'articleEdit', 'clearRecycle', '✅xf编辑-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
  72. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (75, 'course_mgmt', NULL, NULL, 'examList', 'selectItemList', '✅考试列表-查询列表(不包含内容)', 'sql', '{}', '{ "table": "view01_article", "operation": "select" }', '', '', 'jhInsert', NULL, NULL, NULL);
  73. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (76, 'course_mgmt', NULL, NULL, 'examList', 'selectCategoryList', '✅考试列表-查询分类列表', 'sql', '{}', '{ "table": "view01_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  74. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (77, 'course_mgmt', NULL, NULL, 'examList', 'selectCourseList', '✅考卷列表-获取课程列表', 'sql', '{}', '{"table":"course","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-07-28T08:56:53+08:00');
  75. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (78, 'course_mgmt', NULL, '{ "before": [
  76. {"service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook"}
  77. ], "after": [
  78. {"service": "article", "serviceFunction": "articleHistoryRecordAfterHook"}
  79. ] }', 'examList', 'insertArticleItem', NULL, 'sql', '{}', '{ "table": "article", "operation": "jhInsert" }', '', '', 'insert', NULL, NULL, NULL);
  80. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (79, 'course_mgmt', NULL, NULL, 'examList', 'updateArticleTitle', NULL, 'sql', '{}', '{ "table": "article", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  81. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (80, 'course_mgmt', NULL, NULL, 'examList', 'unbindArticleFromCourse', '✅试卷列表-从课程中解除绑定文章', 'sql', '{}', '{ "table": "course_article", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  82. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (81, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'list', '✅素材管理-文件列表', 'service', '{}', '{ "service": "material", "serviceFunction": "list" }', '', '', 'insert', NULL, NULL, NULL);
  83. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (82, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'mkdir', '✅素材管理-创建文件夹', 'service', '{}', '{ "service": "material", "serviceFunction": "mkdir" }', '', '', 'insert', NULL, NULL, NULL);
  84. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (83, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'delete', '✅素材管理-删除', 'service', '{}', '{ "service": "material", "serviceFunction": "delete" }', '', '', 'insert', NULL, NULL, NULL);
  85. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (84, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'clearRecycle', '✅素材管理-清空回收站', 'service', '{}', '{ "service": "material", "serviceFunction": "clearRecycle" }', '', '', 'insert', NULL, NULL, NULL);
  86. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (85, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'renameFile', '✅素材管理-文件重命名', 'service', '{}', '{ "service": "material", "serviceFunction": "renameFile" }', '', '', 'insert', NULL, NULL, NULL);
  87. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (86, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'moveFile', '✅素材管理-移动文件', 'service', '{}', '{ "service": "material", "serviceFunction": "moveFile" }', '', '', 'insert', NULL, NULL, NULL);
  88. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (87, 'course_mgmt', NULL, NULL, 'mediaLibrary', 'copyFile', '✅素材管理-复制文件', 'service', '{}', '{ "service": "material", "serviceFunction": "copyFile" }', '', '', 'insert', NULL, NULL, NULL);
  89. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (88, 'course_mgmt', NULL, NULL, 'questionManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "question", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  90. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (89, 'course_mgmt', NULL, NULL, 'articleEdit', 'unbindArticleFromCourse', '✅文章编辑-从课程中解除绑定文章', 'sql', '{}', '{ "table": "course_article", "operation": "jhDelete" }', '', '', 'insert', NULL, NULL, NULL);
  91. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (90, 'course_mgmt', NULL, NULL, 'designArticleManagement', 'selectItemList', '✅待批准的文章-待批准的文章列表', 'sql', '{}', '{"table":"view01_design_article","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-10-15T22:54:05+08:00');
  92. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (91, 'course_mgmt', NULL, NULL, 'designArticleManagement', 'selectDesignCategoryList', '✅待批准的文章-查询分类列表', 'sql', '{}', '{ "table": "view01_design_category", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  93. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (92, 'course_mgmt', NULL, NULL, 'designArticleManagement', 'copyArticleFromDesign', '✅待批准的文章-批准“文章开发平台”的三稿', 'service', NULL, '{"service": "article", "serviceFunction": "copyArticleFromDesign"}', '', '', 'update', 'vscode', 'vscode', '2022-10-15T22:54:06+08:00');
  94. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (93, 'course_mgmt', NULL, NULL, 'assignmentDesign', 'getAnswerPoints', '✅获取题目建议', 'service', NULL, '{"service": "assignment", "serviceFunction": "getAnswerPoints"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  95. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (94, 'sys_admin', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{"service": "user", "serviceFunction": "passwordLogin"}', '', '', 'update', NULL, NULL, '2022-04-27T15:32:57+08:00');
  96. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (95, 'sys_admin', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{"service": "user", "serviceFunction": "logout"}', '', '', 'insert', NULL, NULL, NULL);
  97. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (96, 'sys_admin', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{"service": "user", "serviceFunction": "userInfo"}', '', '', 'update', NULL, NULL, '2022-04-27T15:37:21+08:00');
  98. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (97, 'sys_admin', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{"table": "_constant", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  99. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (98, 'sys_admin', NULL, NULL, 'userManagement', 'selectItemList', '✅用户管理-查询信息', 'sql', NULL, '{"table": "_user", "operation": "select"}', '{"appData": {"appId": "demo_advanced", "where": {}, "pageId": "userManagement", "orderBy": [{"order": "desc", "column": "operationAt"}], "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": "1651221207913_1347965", "packageType": "httpRequest"}', '{"status": "success", "packageId": "1651221207913_1347965", "timestamp": "2022-04-29T16:33:28+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:28+08:00');
  100. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (99, 'sys_admin', NULL, NULL, 'userManagement', 'insertItem', '✅用户管理-查询信息', 'service', NULL, '{"service": "userManagement", "serviceFunction": "addUser"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "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": {"userId": "002", "username": "test", "clearTextPassword": "123456"}}, "packageId": "1651134960232_5022887", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "insertItem", "resultData": {}}, "packageId": "1651134960232_5022887", "timestamp": "2022-04-28T16:36:00+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:36:00+08:00');
  101. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (100, 'sys_admin', NULL, NULL, 'userManagement', 'resetUserPassword', '✅用户管理-修改密码', 'service', NULL, '{"service": "userManagement", "serviceFunction": "resetUserPassword"}', '{"appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "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": "002", "clearTextPassword": "12345678"}}, "packageId": "1651135041149_9148309", "packageType": "httpRequest"}', '{"status": "success", "appData": {"appId": "demo_advanced", "pageId": "userManagement", "actionId": "resetUserPassword", "resultData": {}}, "packageId": "1651135041149_9148309", "timestamp": "2022-04-28T16:37:21+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-28T16:37:21+08:00');
  102. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (101, 'sys_admin', NULL, NULL, 'userManagement', 'updateItem', '✅用户管理-更新用户', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', '{"appData": {"appId": "demo_advanced", "where": {"userId": "002"}, "pageId": "userManagement", "actionId": "updateItem", "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": {"userStatus": "active"}}, "packageId": "1651221207122_4349367", "packageType": "httpRequest"}', '{"status": "success", "appData": {"rows": 1, "appId": "demo_advanced", "pageId": "userManagement", "actionId": "updateItem", "resultData": {"rows": 1}}, "packageId": "1651221207122_4349367", "timestamp": "2022-04-29T16:33:27+08:00", "packageType": "httpResponse"}', 'update', NULL, NULL, '2022-04-29T16:33:27+08:00');
  103. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (102, 'sys_admin', NULL, NULL, 'memberManagement', 'selectItemList', '✅查询列表', 'sql', '{}', '{ "table": "cgg_member_v3", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  104. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (103, 'sys_admin', NULL, NULL, 'memberManagement', 'insertItem', '✅添加', 'sql', '{}', '{ "table": "cgg_member_v3", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  105. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (104, 'sys_admin', NULL, NULL, 'memberManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "cgg_member_v3", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  106. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (105, 'sys_admin', NULL, NULL, 'memberManagement', 'deleteItem', '✅删除', 'sql', '{}', '{ "table": "cgg_member_v3", "operation": "jhDelete" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  107. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (106, 'sys_admin', NULL, NULL, 'courseSeriesManagement', 'selectItemList', '✅课程查询-查询列表', 'sql', '{}', '{ "table": "cgg_course_series", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  108. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (107, 'sys_admin', NULL, NULL, 'courseSeriesManagement', 'insertItem', '✅课程查询-添加成员', 'sql', '{}', '{ "table": "cgg_course_series", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  109. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (108, 'sys_admin', NULL, NULL, 'courseSeriesManagement', 'updateItem', '✅课程查询-更新成员', 'sql', '{}', '{ "table": "cgg_course_series", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  110. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (109, 'sys_admin', NULL, NULL, 'courseSeriesManagement', 'deleteItem', '✅课程查询-删除信息', 'sql', '{}', '{ "table": "cgg_course_series", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  111. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (110, 'sys_admin', NULL, NULL, 'courseManagement', 'selectCurrentList', '✅课程的课程分期管理-查询当前课程分期下的课程列表', 'sql', '{}', '{ "table": "cgg_course", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  112. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (111, 'sys_admin', NULL, NULL, 'courseManagement', 'insertItem', '✅课程的课程分期管理-建立关系', 'sql', '{}', '{ "table": "cgg_course", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  113. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (112, 'sys_admin', NULL, NULL, 'courseManagement', 'updateItem', '✅课程的课程分期管理-更新数据', 'sql', '{}', '{ "table": "cgg_course", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  114. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (113, 'sys_admin', NULL, NULL, 'courseManagement', 'deleteItem', '✅课程的课程分期管理-删除信息', 'sql', '{}', '{ "table": "cgg_course", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  115. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (114, 'sys_admin', NULL, NULL, 'courseManagement', 'selectAllList', '✅课程查询-查询列表', 'sql', '{}', '{ "table": "cgg_course", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  116. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (115, 'sys_admin', NULL, NULL, 'courseClassManagement', 'selectItemList', '✅班级查询-查询列表', 'sql', '{}', '{ "table": "course_class", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  117. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (116, 'sys_admin', NULL, NULL, 'courseClassManagement', 'insertItem', '✅班级查询-添加成员', 'sql',