江湖数字化平台
登录

接口

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', '{}', '{ "table": "course_class", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  118. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (117, 'sys_admin', NULL, NULL, 'courseClassManagement', 'updateItem', '✅班级查询-更新成员', 'sql', '{}', '{ "table": "course_class", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  119. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (118, 'sys_admin', NULL, NULL, 'courseClassManagement', 'deleteItem', '✅班级查询-删除信息', 'sql', '{}', '{ "table": "course_class", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  120. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (119, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'selectCurrentList', '✅班级的班级成员管理-查询当前班级成员下的班级列表', 'sql', '{}', '{ "table": "class_member", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  121. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (120, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'insertItem', '✅班级的班级成员管理-建立关系', 'sql', '{}', '{ "table": "class_member", "operation": "jhInsert" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  122. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (121, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'updateItem', '✅班级的班级成员管理-更新数据', 'sql', '{}', '{ "table": "class_member", "operation": "jhUpdate" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  123. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (122, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'deleteItem', '✅班级的班级成员管理-删除信息', 'sql', '{}', '{ "table": "class_member", "operation": "jhDelete" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  124. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (123, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'selectAllList', '✅班级查询-查询列表', 'sql', '{}', '{ "table": "class_member", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  125. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (124, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'getMemberList', '✅成员查询', 'sql', '{}', '{ "table": "cgg_member_v3", "operation": "select" }', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  126. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (125, 'sys_admin', NULL, NULL, 'courseClassMemberManagement', 'insertClassMember', '✅成员查询', 'service', '{}', '{"service": "class", "serviceFunction": "insertClassMember"}', NULL, NULL, 'jhInsert', NULL, NULL, NULL);
  127. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (126, 'student', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
  128. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (127, 'student', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
  129. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (128, 'student', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  130. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (129, 'student', NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  131. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (130, 'student', NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
  132. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (131, 'student', NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  133. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (132, 'student', NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  134. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (133, 'student', NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', '', '', 'insert', NULL, NULL, NULL);
  135. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (134, 'student', NULL, '{ "before": [], "after": [{"service": "userCenter", "serviceFunction": "afterLoginEditLoginAt"}] }', 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
  136. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (135, 'student', NULL, '', 'home_note', 'saveArticleNote', '✅保存笔记', 'service', '{}', '{ "service": "note", "serviceFunction": "saveArticleNote" }', '', '', 'insert', NULL, NULL, NULL);
  137. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (136, 'student', NULL, NULL, 'courseList', 'getMyCourseList', '✅课程列表-获取我的课程', 'sql', '{}', '{ "table": "view01_user_course", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  138. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (139, 'student', NULL, NULL, 'courseArticleList', 'getNoteList', '✅学习内容-获取笔记列表', 'sql', '{}', '{ "table": "view01_note_list", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  139. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (140, 'student', NULL, NULL, 'courseArticleList', 'getAssignmentList', '✅学习内容-获取作业列表', 'sql', '{}', '{ "table": "view01_assignment_list", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  140. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (141, 'student', NULL, NULL, 'courseArticleList', 'getExamList', '✅学习内容-获取考试列表', 'sql', '{}', '{ "table": "view01_exam_list", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  141. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (142, 'student', NULL, NULL, 'courseArticleList', 'getMyCourseArticleList', '✅学习内容-获取课程学习内容', 'sql', '{}', '{ "table": "view01_user_course_article", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  142. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (143, 'student', NULL, NULL, 'courseArticleList', 'getAttendanceList', '✅学习内容-获取出勤列表', 'sql', '{}', '{ "table": "attendance", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  143. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (145, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "passcodeCheck"}], "after": [] }', 'examPaper', 'getExamPaper', NULL, 'sql', '{}', '{ "table": "view01_course_article_detail", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  144. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (146, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "appendAssignIdToActionData"}], "after": [{"service": "exam", "serviceFunction": "insertAutomaticScoring"}] }', 'examPaper', 'insertItem', NULL, 'sql', NULL, '{ "table": "examination", "operation": "insert" }', '', '', 'insert', NULL, NULL, NULL);
  145. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (147, 'student', NULL, '', 'examPaper', 'updateItem', NULL, 'sql', NULL, '{ "table": "examination", "operation": "update" }', '', '', 'insert', NULL, NULL, NULL);
  146. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (148, 'student', NULL, NULL, 'examPaper', 'getSavedAnswer', NULL, 'sql', '{}', '{ "table": "view01_exam", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  147. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (151, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "checkUserExam"}], "after": [] }', 'examPaper', 'getExamInfo', NULL, 'sql', '{}', '{ "table": "view01_course_article_detail", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  148. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (152, 'student', NULL, NULL, 'articleDetail', 'getArticleInfo', '文章详情', 'sql', NULL, '{ "table": "view01_article", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  149. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (156, 'student', NULL, NULL, 'articleDetail', 'addVideoPlayTime', '✅文章详情-添加视频播放时长', 'service', '{}', '{ "service": "student", "serviceFunction": "addVideoPlayTime" }', '', '', 'insert', NULL, NULL, NULL);
  150. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (157, 'student', NULL, '{ "before": [{"service": "userCenter", "serviceFunction": "appendUserIdToWhere"}] }', 'articleDetail', 'selectItemList', '?笔记-获取笔记内容', 'sql', '{}', '{ "table": "note", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  151. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (158, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "insertAutomaticScoring"}] }', 'assignmentPaper', 'insertUserAssignment', '✅作业-创建作业', 'service', '{}', '{"service": "assignment", "serviceFunction": "insertUserAssignment"}', '', '', 'insert', NULL, NULL, NULL);
  152. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (159, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "checkAndRemoveStandardAnswer"}] }', 'assignmentPaper', 'getUserAssignment', '✅作业-获取作业', 'sql', '{}', '{ "table": "assignment", "operation": "select"}', '', '', 'insert', NULL, NULL, NULL);
  153. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (160, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "afterRecordBehaviorHook"}] }', 'assignmentPaper', 'saveUserAssignment', '✅作业-保存作业草稿', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  154. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (161, 'student', NULL, '{ "before": [{"service": "assignment", "serviceFunction": "autoReviewUserAssignment"}], "after": [{"service": "assignment", "serviceFunction": "afterRecordBehaviorHook"}, {"service": "assignment", "serviceFunction": "updateAutomaticScoring"}] }', 'assignmentPaper', 'submitUserAssignment', '✅作业-提交作业', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  155. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (162, 'student', NULL, '{ "before": [{"service": "assignment", "serviceFunction": "redoUserAssignment"}] }', 'assignmentPaper', 'redoUserAssignment', '✅作业-重做作业', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  156. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (163, 'student', NULL, NULL, 'courseArticleList', 'getCourseInfo', '✅学习内容-获取课程信息', 'sql', '{}', '{ "table": "course", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  157. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (170, 'student', NULL, NULL, 'home_assignment', 'revertUserNote', '✅笔记-撤销提交', 'sql', NULL, '{ "table": "note", "operation": "jhUpdate" }', '', '', 'insert', NULL, NULL, NULL);
  158. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (198, 'student', NULL, NULL, 'allPage', 'updateUserInfo', '✅更新用户信息', 'sql', NULL, '{"table": "_user", "operation": "jhUpdate"}', NULL, NULL, 'update', NULL, NULL, '2023-02-07T15:19:29+08:00');
  159. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (199, 'student', NULL, '', 'courseDetail', 'getCourseDetail', '✅获取课程详情', 'sql', NULL, '{"table": "course", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  160. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (200, 'student', NULL, '', 'courseDetail', 'getArticleList', '✅获取文章列表', 'sql', NULL, '{"table": "view01_course_article_detail", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  161. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (201, 'student', NULL, '', 'courseDetail', 'getCommentList', '✅获取课程评论列表', 'sql', NULL, '{"table": "user_comment", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  162. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (202, 'student', NULL, '', 'courseDetail', 'addComment', '✅添加评论', 'sql', NULL, '{"table": "user_comment", "operation": "jhInsert"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  163. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (203, 'student', NULL, NULL, 'courseDetail', 'getCourseUserList', '✅课程详情-获取课程用户', 'sql', NULL, '{"table": "course_user", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  164. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (204, 'student', NULL, NULL, 'courseDetail', 'createCourseOrder', '✅创建课程订单', 'service', NULL, '{"service": "order", "serviceFunction": "createCourseOrder"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  165. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (205, 'student', NULL, NULL, 'wap/articleDetail', 'getArticleDetail', '✅获取文章详情', 'sql', NULL, '{"table": "article", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  166. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (206, 'student', NULL, '{ "after": [
  167.     {"service": "assignment", "serviceFunction": "checkUserAssignmentStatusAfterHook"}
  168. ] }', 'assignmentPaper', 'getAssignmentDetail', '✅获取作业详情', 'sql', NULL, '{"table": "view01_article", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  169. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (207, 'student', NULL, '{ "before": [], "after": [{"service": "exam", "serviceFunction": "passcodeCheck"}] }', 'wap/examIndex', 'passwordCheck', NULL, 'sql', '{}', '{ "table": "view01_course_article_detail", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  170. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (208, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "checkUserExam"}], "after": [] }', 'wap/examIndex', 'getUserExamInfo', NULL, 'sql', '{}', '{ "table": "examination", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  171. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (209, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "appendAssignIdToActionData"}], "after": [{"service": "exam", "serviceFunction": "insertAutomaticScoring"}] }', 'wap/examIndex', 'insertItem', NULL, 'sql', NULL, '{ "table": "examination", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  172. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (210, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "checkUserExam"}], "after": [] }', 'wap/examDetail', 'getAssignmentDetail', NULL, 'sql', '{}', '{ "table": "view01_exam", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  173. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (211, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "afterRecordBehaviorHook"}] }', 'wap/examDetail', 'saveUserAssignment', '✅作业-保存作业草稿', 'sql', '{}', '{ "table": "examination", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  174. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (212, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "checkUserExam"}], "after": [] }', 'wap/examIndex', 'getExamInfo', NULL, 'sql', '{}', '{ "table": "view01_course_article_detail", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  175. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (213, 'student', NULL, NULL, 'wap/examDetail', 'getCourseArticleInfo', NULL, 'sql', NULL, '{ "table": "view01_course_article_detail", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  176. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (214, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "redoUserExam"}] }', 'wap/examDetail', 'redoUserExam', '✅作业-重做考试', 'sql', '{}', '{ "table": "examination", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  177. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (215, 'student', NULL, '{ "after": [{"service": "course", "serviceFunction": "courseListAfterHook"}] }', 'wap/courseList', 'getMyCourseList', '✅课程列表-获取我的课程', 'sql', '{}', '{ "table": "view01_user_course", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  178. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (217, 'student', NULL, '{ "after": [{"service": "course", "serviceFunction": "courseListAfterHook"}] }', 'wap/courseDetail', 'getCourseDetail', '✅获取课程详情', 'sql', NULL, '{"table": "course", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  179. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (218, 'student', NULL, '{ "after": [{"service": "article", "serviceFunction": "articleListAfterHook"}] }', 'wap/courseDetail', 'getArticleList', '✅获取文章列表', 'sql', NULL, '{"table": "view01_course_article_detail", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  180. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (219, 'student', NULL, '', 'wap/assignmentDetail', 'getUserAssignment', '✅作业-获取作业', 'sql', '{}', '{ "table": "assignment", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  181. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (220, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "afterRecordBehaviorHook"}] }', 'wap/assignmentDetail', 'saveUserAssignment', '✅作业-保存作业草稿', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  182. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (221, 'student', NULL, '{ "before": [{"service": "assignment", "serviceFunction": "autoReviewUserAssignment"}], "after": [{"service": "assignment", "serviceFunction": "afterRecordBehaviorHook"}, {"service": "assignment", "serviceFunction": "updateAutomaticScoring"}] }', 'wap/assignmentDetail', 'submitUserAssignment', '✅作业-提交作业', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  183. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (222, 'student', NULL, '{ "before": [{"service": "assignment", "serviceFunction": "redoUserAssignment"}] }', 'wap/assignmentDetail', 'redoUserAssignment', '✅作业-重做作业', 'sql', '{}', '{ "table": "assignment", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  184. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (223, 'student', NULL, '{ "after": [{"service": "assignment", "serviceFunction": "insertAutomaticScoring"}] }', 'wap/assignmentIndex', 'insertUserAssignment', '✅作业-创建作业', 'service', '{}', '{"service": "assignment", "serviceFunction": "insertUserAssignment"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  185. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (224, 'student', NULL, '{ "after": [
  186.     {"service": "assignment", "serviceFunction": "checkUserAssignmentStatusAfterHook"}
  187. ] }', 'wap/assignmentIndex', 'getAssignmentDetail', '✅获取作业详情', 'sql', NULL, '{"table": "view01_article", "operation": "select"}', NULL, NULL, 'update', NULL, NULL, '2022-04-25T15:31:12+08:00');
  188. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (225, 'student', NULL, '{ "after": [{"service": "article", "serviceFunction": "recordAssignArticleId"}] }', 'wap/my/studyRecord', 'getNoteList', '✅笔记列表', 'sql', NULL, '{"table": "note", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  189. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (226, 'student', NULL, '{ "after": [{"service": "article", "serviceFunction": "recordAssignArticleId"}] }', 'wap/my/studyRecord', 'getAssignmentList', '✅作业列表', 'sql', NULL, '{"table": "assignment", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  190. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (227, 'student', NULL, '{ "after": [{"service": "article", "serviceFunction": "recordAssignArticleId"}] }', 'wap/my/studyRecord', 'getExamList', '✅考试列表', 'sql', NULL, '{"table": "examination", "operation": "select"}', NULL, NULL, 'insert', NULL, NULL, NULL);
  191. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (228, 'student', NULL, NULL, 'wap/assignmentDetail', 'getCourseArticleInfo', NULL, 'sql', NULL, '{ "table": "view01_course_article_detail", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  192. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (229, 'student', NULL, '{ "before": [{"service": "exam", "serviceFunction": "appendAssignIdToActionData"}], "after": [{"service": "exam", "serviceFunction": "insertAutomaticScoring"}] }', 'wap/examIndex', 'insertItem', NULL, 'sql', NULL, '{ "table": "examination", "operation": "insert" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  193. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (230, 'student', NULL, NULL, 'wap/articleDetail', 'saveArticleNote', '✅保存笔记', 'service', '{}', '{ "service": "note", "serviceFunction": "saveArticleNote" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  194. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (231, 'student', NULL, NULL, 'wap/articleDetail', 'revertUserNote', '✅笔记-撤销提交', 'sql', NULL, '{ "table": "note", "operation": "jhUpdate" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  195. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (232, 'student', NULL, '{ "before": [{"service": "userCenter", "serviceFunction": "appendUserIdToWhere"}] }', 'wap/articleDetail', 'selectItemList', '?笔记-获取笔记内容', 'sql', '{}', '{ "table": "note", "operation": "select" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  196. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (233, 'student', NULL, NULL, 'md2html', 'selectItemList', NULL, 'service', NULL, '{ "service": "article", "serviceFunction": "getArticleListFromArticleQuery" }', NULL, NULL, 'insert', NULL, NULL, NULL);
  197. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (234, 'teacher', NULL, NULL, 'login', 'passwordLogin', '✅登陆', 'service', '{}', '{ "service": "user", "serviceFunction": "passwordLogin" }', '', '', 'insert', NULL, NULL, NULL);
  198. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (235, 'teacher', NULL, NULL, 'allPage', 'logout', '✅登出', 'service', '{}', '{ "service": "user", "serviceFunction": "logout" }', '', '', 'insert', NULL, NULL, NULL);
  199. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (236, 'teacher', NULL, NULL, 'allPage', 'userInfo', '✅获取用户信息', 'service', '{}', '{ "service": "user", "serviceFunction": "userInfo" }', '', '', 'insert', NULL, NULL, NULL);
  200. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (237, 'teacher', NULL, NULL, 'allPage', 'getConstantList', '✅查询常量', 'sql', '{}', '{ "table": "_constant", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  201. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (238, 'teacher', NULL, NULL, 'allPage', 'resetPassword', '✅修改用户密码', 'service', '{}', '{ "service": "user", "serviceFunction": "resetPassword" }', '', '', 'insert', NULL, NULL, NULL);
  202. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (239, 'teacher', NULL, NULL, 'allPage', 'getChunkInfo', '✅ 文件分片下载-获取分片信息', 'service', '{}', '{ "service": "file", "serviceFunction": "getChunkInfo" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  203. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (240, 'teacher', NULL, NULL, 'allPage', 'uploadFileDone', '✅ 文件分片上传-所有分片上传完毕', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileDone" }', '', '', 'insert', NULL, NULL, NULL);
  204. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (241, 'teacher', NULL, NULL, 'allPage', 'httpUploadByStream', '✅ 文件分片上传-http文件流', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByStream" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  205. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (242, 'teacher', NULL, NULL, 'allPage', 'httpUploadByBase64', '✅ 文件分片上传-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "uploadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  206. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (243, 'teacher', NULL, NULL, 'allPage', 'httpDownloadByBase64', '✅ 文件分片下载-http base64', 'service', '{}', '{ "service": "file", "serviceFunction": "downloadFileChunkByBase64" }', '', '', 'update', NULL, NULL, '2022-03-10T22:27:32+08:00');
  207. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (244, 'teacher', NULL, NULL, 'allPage', 'htmlErrorLogRecord', '✅异常日志记录', 'service', '{}', '{"service": "error", "serviceFunction": "htmlErrorLogRecord"}', '', '', 'insert', NULL, NULL, NULL);
  208. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (245, 'teacher', NULL, NULL, 'assignmentList', 'getClassList', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  209. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (246, 'teacher', NULL, NULL, 'assignmentList', 'getStudentListByClass', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  210. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (247, 'teacher', NULL, NULL, 'assignmentList', 'getLessonListByClass', NULL, 'sql', '{}', '{"table":"view01_course_article","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  211. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (248, 'teacher', NULL, NULL, 'assignmentList', 'getAssignmentListByClass', NULL, 'sql', '{}', '{"table":"assignment","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  212. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (249, 'teacher', NULL, '{"before":[{"service":"assignment","serviceFunction":"checkAssignmentReview"}]}', 'assignmentReview', 'selectItemList', '✅assignmentManagement查询-查询列表', 'sql', '{}', '{"table":"view02_assignment_for_review","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-11-02T16:45:33+08:00');
  213. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (250, 'teacher', NULL, NULL, 'assignmentReview', 'getCourseInfo', NULL, 'sql', '{}', '{"table":"course","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  214. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (251, 'teacher', NULL, '{"after":[{"service":"assignment","serviceFunction":"afterRecordTeacherBehaviorHook"}]}', 'assignmentReview', 'updateItem', '✅模拟做题-更新', 'sql', '{}', '{"table": "assignment", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-11-02T16:45:33+08:00');
  215. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (252, 'teacher', NULL, NULL, 'noteList', 'getClassList', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  216. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (253, 'teacher', NULL, NULL, 'noteList', 'getStudentListByClass', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  217. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (254, 'teacher', NULL, NULL, 'noteList', 'getLessonListByClass', NULL, 'sql', '{}', '{"table":"view01_course_article","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  218. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (255, 'teacher', NULL, NULL, 'noteList', 'getNoteListByClass', NULL, 'sql', '{}', '{"table":"note","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  219. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (256, 'teacher', NULL, '{"before":[{"service":"note","serviceFunction":"checkNoteReview"}]}', 'assignmentReview', 'selectNoteList', '✅查询-查询列表', 'sql', NULL, '{"table":"note","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-11-02T16:45:33+08:00');
  220. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (257, 'teacher', NULL, '{"after":[{"service":"note","serviceFunction":"afterRecordTeacherBehaviorHook"}]}', 'noteManagement', 'updateItem', '✅更新', 'sql', '{}', '{ "table": "note", "operation": "jhUpdate" }', '', '', 'update', 'vscode', 'vscode', '2022-09-16T14:49:31+08:00');
  221. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (258, 'teacher', NULL, NULL, 'examManagement', 'selectItemList', '✅作业管理-查询列表', 'service', '{}', '{"service":"assignment","serviceFunction":"selectTeacherExam"}', '', '', 'update', 'vscode', 'vscode', '2022-08-25T23:37:19+08:00');
  222. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (260, 'teacher', NULL, NULL, 'examManagement', 'cancelSubmit', '✅撤销提交', 'sql', NULL, '{"table":"examination","operation":"jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-08-25T23:37:20+08:00');
  223. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (261, 'teacher', NULL, '{"before":[{"service":"assignment","serviceFunction":"checkAssignmentReview"}]}', 'examReview', 'selectItemList', '✅assignmentManagement查询-查询列表', 'sql', '{}', '{"table":"view02_examination_for_review","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-11-02T16:45:33+08:00');
  224. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (262, 'teacher', NULL, '{"after":[{"service":"assignment","serviceFunction":"afterRecordTeacherBehaviorHook"}]}', 'examReview', 'updateItem', '✅模拟做题-更新', 'sql', '{}', '{"table": "examination", "operation": "jhUpdate"}', '', '', 'update', 'vscode', 'vscode', '2022-11-02T16:45:33+08:00');
  225. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (263, 'teacher', NULL, NULL, 'attendanceList', 'getClassList', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  226. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (264, 'teacher', NULL, NULL, 'attendanceList', 'getStudentListByClass', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  227. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (265, 'teacher', NULL, NULL, 'attendanceList', 'getLessonListByClass', NULL, 'sql', '{}', '{"table":"view01_course_article","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  228. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (266, 'teacher', NULL, NULL, 'attendanceList', 'getAttendanceListByClass', NULL, 'sql', '{}', '{"table":"attendance","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  229. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (267, 'teacher', NULL, NULL, 'attendanceList', 'updateItem', '✅出勤记录-更新', 'sql', '{}', '{"table":"attendance","operation":"jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  230. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (268, 'teacher', NULL, '{"before":[{"service":"group","serviceFunction":"beforeAppendGroupIdToWhereIn"}]}', 'attendanceRecord', 'selectGroupList', '✅出勤记录-查询班级', 'sql', NULL, '{"table":"view01_class_attendance","operation":"select"}', '', '', 'insert', 'vscode', 'vscode', '2022-11-26T15:48:20+08:00');
  231. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (270, 'teacher', NULL, '{"before":[{"service":"group","serviceFunction":"beforeAppendGroupIdToWhereIn"}]}', 'attendanceRecord', 'selectTeacherStudentList', '✅出勤记录-查询学员列表', 'sql', '{}', '{"table":"view01_baofeng_student_group_role","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  232. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (271, 'teacher', NULL, '', 'attendanceRecord', 'selectAttendanceRecordList', '✅出勤记录-查询出勤记录', 'sql', '{}', '{"table":"view02_attendance","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  233. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (272, 'teacher', NULL, NULL, 'attendanceRecord', 'createAttendanceRecord', '✅创建出勤记录', 'service', NULL, '{"service":"attendance","serviceFunction":"createAttendanceRecord"}', '', '', 'insert', NULL, NULL, NULL);
  234. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (273, 'teacher', NULL, '', 'attendanceRecord', 'updateItem', '✅出勤记录-更新', 'sql', '{}', '{"table":"attendance","operation":"jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  235. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (274, 'teacher', NULL, NULL, 'attendanceRecord', 'updateAttendanceRecord', '✅创建出勤记录', 'service', NULL, '{"service":"attendance","serviceFunction":"updateAttendanceRecord"}', '', '', 'insert', NULL, NULL, NULL);
  236. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (275, 'teacher', NULL, NULL, 'myStudentList', 'getCourseListByTeacher', NULL, 'sql', '{}', '{"table":"view01_class_member","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  237. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (276, 'teacher', NULL, '{"before":[{"service":"learningRecord","serviceFunction":"beforeAppendClassStudentIdToWhereIn"}]}', 'myStudentList', 'getStudentListByCourse', NULL, 'sql', '{}', '{ "table": "view01_student_learning_record", "operation": "select" }', '', '', 'insert', NULL, NULL, NULL);
  238. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (277, 'teacher', NULL, NULL, 'myStudentList', 'getCourseLessonDataForTeacher', NULL, 'service', '{}', '{ "service": "learningRecord", "serviceFunction": "getCourseLessonDataForTeacher" }', '', '', 'insert', NULL, NULL, NULL);
  239. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (278, 'teacher', NULL, NULL, 'myStudentList', 'getStudentLearningRecordByStudent', NULL, 'sql', '{}', '{"table":"student_learning_record","operation":"select"}', '', '', 'insert', NULL, NULL, NULL);
  240. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (279, 'teacher', NULL, '{"before":[{"service":"learningRecord","serviceFunction":"checkExistCourseMemberId"}]}', 'myStudentList', 'updateItem', NULL, 'sql', '{}', '{"table":"student_learning_record","operation":"jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  241. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (280, 'teacher', NULL, NULL, 'myStudentList', 'getLatestLearningRecordForStudent', NULL, 'service', '{}', '{ "service": "learningRecord", "serviceFunction": "getLatestLearningRecordForStudent" }', '', '', 'insert', NULL, NULL, NULL);
  242. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (281, 'teacher', NULL, NULL, 'studentWarn', 'selectItemList', '✅查询列表', 'service', '{}', '{"service":"assignment","serviceFunction":"studentBehavior"}', '', '', 'update', 'vscode', 'vscode', '2022-11-25T20:55:57+08:00');
  243. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (282, 'teacher', NULL, NULL, 'teacherWarn', 'selectItemList', '✅查询列表', 'sql', '{}', '{"table":"view01_teacher_behavior","operation":"select"}', '', '', 'update', 'vscode', 'vscode', '2022-11-25T20:55:57+08:00');
  244. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (346, 'teacher', NULL, NULL, 'myStudentList', 'createCompleteCourseRecord', '✅我的学员-发布学生毕业记录', 'sql', '{}', '{"table":"student_complete_course_record","operation":"jhInsert"}', '', '', 'insert', NULL, NULL, NULL);
  245. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (347, 'teacher', NULL, '{"before":[{"service":"learningRecord","serviceFunction":"checkExistCourseMemberId"}]}', 'myStudentList', 'updateItemDev', NULL, 'sql', '{}', '{"table":"__dev__student_learning_record","operation":"jhUpdate"}', '', '', 'insert', NULL, NULL, NULL);
  246. INSERT INTO _resource (id, jhId, accessControlTable, resourceHook, pageId, actionId, desc, resourceType, appDataSchema, resourceData, requestDemo, responseDemo, operation, operationByUserId, operationByUser, operationAt) VALUES (348, 'teacher', NULL, NULL, 'myStudentList', 'revokeCompleteCourseRecord', NULL, 'sql', '{}', '{"table":"student_complete_course_record","operation":"jhDelete"}', '', '', 'insert', NULL, NULL, NULL);