江湖数字化平台
登录

页面

12123

页面总览

_page结构

  1. CREATE TABLE `_page` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `jhId` varchar(255) DEFAULT NULL,
  4.   `pageId` varchar(255) DEFAULT NULL COMMENT 'pageId',
  5.   `pageName` varchar(255) DEFAULT NULL COMMENT 'page name',
  6.   `pageFile` varchar(255) DEFAULT NULL,
  7.   `pageType` varchar(255) DEFAULT NULL COMMENT '页面类型; showInMenu, dynamicInMenu',
  8.   `pageIcon` text,
  9.   `sort` varchar(255) DEFAULT NULL,
  10.   `pageHook` text COMMENT '{\n  "beforeHook":[\n  {"field": "doc", "service": "doc", "serviceFunc": "getDoc"}\n  ]\n}',
  11.   `operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  12.   `operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',
  13.   `operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',
  14.   `operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  15.   PRIMARY KEY (`id`) USING BTREE
  16. ) ENGINE = InnoDB AUTO_INCREMENT = 243 DEFAULT CHARSET = utf8mb4 COMMENT = '页面表; 软删除未启用;'

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 1 course_mgmt update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 94 sys_admin update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin { "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] } service { "service": "user", "serviceFunction": "passwordLogin" } {} 134 student insert
✅登陆 login passwordLogin null service { "service": "user", "serviceFunction": "passwordLogin" } {} 234 teacher insert

操作手册

  • 页面信息
pageName pageId pageType pageFile sort pageHook
操作手册 manual null null 998 null

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help null helpV4 999 null

课程列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程列表 courseList showInMenu null 101 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程列表-查询课程 courseList selectItemList null sql { "table": "view01_course_with_article_count", "operation": "select" } access_control_course {} 11 course_mgmt insert
课程-从课程与班级管理同步课程 courseList syncCourseList null service { "service": "course", "serviceFunction": "syncCourseList" } 12 course_mgmt insert
✅课程列表-获取我的课程 courseList getMyCourseList null sql { "table": "view01_user_course", "operation": "select" } {} 136 student insert

课程的文章列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程的文章列表 articleListByCourse null null 103 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程的文章列表-按课程获取文章 articleListByCourse getArticleListByCourse null sql { "table": "view01_course_article", "operation": "select" } access_control_album_or_article 13 course_mgmt insert
✅课程的文章列表-绑定教材 articleListByCourse insertItem null sql { "table": "course_article", "operation": "jhInsert" } 14 course_mgmt insert
✅课程的文章列表- articleListByCourse updateItem null sql { "table": "course_article", "operation": "jhUpdate" } 15 course_mgmt insert
✅课程的文章列表-解绑教材 articleListByCourse deleteItem null sql { "table": "course_article", "operation": "jhDelete" } 16 course_mgmt insert
✅课程的文章列表-获取文章分类列表 articleListByCourse selectCategoryList null sql { "table": "view01_category", "operation": "select" } 18 course_mgmt insert
articleListByCourse getArticleList null sql { "table": "view01_article_list", "operation": "select" } access_control_album_or_article 19 course_mgmt insert
✅课程文章列表-添加文章或考试 articleListByCourse insertArticleItem { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } sql { "table": "article", "operation": "jhInsert" } {} 21 course_mgmt insert
______✅[可取消]课程文章列表-获取没有绑定课程的文章 articleListByCourse getCourseArticleBinding service { "service": "course", "serviceFunction": "getCourseArticleBinding" } {} 22 course_mgmt insert
✅课程文章列表-更新文章标题 articleListByCourse updateArticleTitle null sql { "table": "article", "operation": "jhUpdate" } 24 course_mgmt insert
articleListByCourse getCourseInfo null sql {"table":"course","operation":"select"} 25 course_mgmt insert
✅课程的文章列表-向课程绑定文章 articleListByCourse bindNewArticleToCourse null service { "service": "article", "serviceFunction": "bindNewArticleToCourse" } {} 26 course_mgmt insert
✅课程的文章列表-将文章移入回收站 articleListByCourse setArticleAsDeleted null service { "service": "article", "serviceFunction": "deletedArticle" } {} 27 course_mgmt insert
✅课程的文章列表-从课程中解除绑定文章 articleListByCourse unbindArticleFromCourse null sql { "table": "course_article", "operation": "jhDelete" } {} 28 course_mgmt insert
articleListByCourse getArticleJustInserted null sql { "table": "article", "operation": "select" } {} 29 course_mgmt insert

课程的试卷列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程的试卷列表 examListByCourse null null 104 null

教材管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
教材管理 albumList null null 201 null

教材的文章列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
教材的文章列表 articleListByAlbum null null 202 null

文章列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章列表 articleList showInMenu null 401 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅文章列表-查询列表(不包含内容) articleList selectItemList null sql { "table": "view01_article", "operation": "select" } access_control_album_or_article {} 45 course_mgmt jhInsert
✅文章列表-查询分类列表 articleList selectCategoryList null sql { "table": "view01_category", "operation": "select" } {} 46 course_mgmt insert
✅文章列表-更新成员 articleList jhUpdateItem { "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } sql { "table": "article", "operation": "jhUpdate" } {} 49 course_mgmt insert
✅文章编辑-将文章移至回收站 articleList deletedArticle null service { "service": "article", "serviceFunction": "deletedArticle" } {} 50 course_mgmt insert
✅文章编辑-文章恢复 articleList restoreArticle null service { "service": "article", "serviceFunction": "restoreArticle" } {} 51 course_mgmt insert
✅文章列表-从课程中解除绑定文章 articleList unbindArticleFromCourse null sql { "table": "course_article", "operation": "jhDelete" } {} 52 course_mgmt insert

文章编辑

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章编辑 articleEdit null null 403 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅文章编辑-查询文章列表 articleEdit selectItemList null sql { "table": "article", "operation": "select" } {} 53 course_mgmt jhInsert
✅文章编辑-查询列表 articleEdit selectCategoryList null sql { "table": "view01_category", "operation": "select" } {} 54 course_mgmt insert
✅文章编辑-课程列表 articleEdit selectCourseList null sql {"table":"course","operation":"select", "fieldList": ["courseId", "courseBatchId", "courseName", "courseStatus", "operationAt"]} access_control_course {} 55 course_mgmt update 2022-07-28T08:56:53+08:00 vscode vscode
✅文章编辑-查询带文集信息的文章 articleEdit selectArticleWithCategory null service { "service": "article", "serviceFunction": "getArticleAndFillArticles" } {} 57 course_mgmt insert
✅文章编辑-添加成员 articleEdit jhInsertItem { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } sql { "table": "article", "operation": "jhInsert" } {} 58 course_mgmt jhInsert
✅文章编辑-更新成员 articleEdit jhUpdateItem { "before": [ { "service": "article", "serviceFunction": "fillUpdateItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } sql { "table": "article", "operation": "jhUpdate" } {} 59 course_mgmt insert
✅文章编辑-将文章移至回收站 articleEdit deletedArticle service { "service": "article", "serviceFunction": "deletedArticle" } {} 60 course_mgmt insert
✅文章编辑-文章恢复 articleEdit restoreArticle null service { "service": "article", "serviceFunction": "restoreArticle" } {} 61 course_mgmt insert
✅文章编辑-使用素材 articleEdit useMaterial null service { "service": "material", "serviceFunction": "useMaterial" } {} 62 course_mgmt insert
✅xf编辑-文件列表 articleEdit list null service { "service": "material", "serviceFunction": "list" } {} 68 course_mgmt insert
✅xf编辑-创建文件夹 articleEdit mkdir null service { "service": "material", "serviceFunction": "mkdir" } {} 69 course_mgmt insert
✅xf编辑-移动文件 articleEdit moveFile null service { "service": "material", "serviceFunction": "moveFile" } {} 70 course_mgmt insert
✅xf编辑-复制文件 articleEdit copyFile null service { "service": "material", "serviceFunction": "copyFile" } {} 71 course_mgmt insert
✅xf编辑-文件重命名 articleEdit renameFile null service { "service": "material", "serviceFunction": "renameFile" } {} 72 course_mgmt insert
✅xf编辑-删除 articleEdit delete null service { "service": "material", "serviceFunction": "delete" } {} 73 course_mgmt insert
✅xf编辑-清空回收站 articleEdit clearRecycle null service { "service": "material", "serviceFunction": "clearRecycle" } {} 74 course_mgmt insert
✅文章编辑-从课程中解除绑定文章 articleEdit unbindArticleFromCourse null sql { "table": "course_article", "operation": "jhDelete" } {} 89 course_mgmt insert

作业设计

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业设计 assignmentDesign null null 405 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询文章作业 assignmentDesign selectArticleAssignment null sql { "table": "article", "operation": "select" } {} 63 course_mgmt insert
✅更新文章作业 assignmentDesign updateArticleAssignment { "after": [ { "service": "article", "serviceFunction": "afterEditQuestionHook" } ] } sql { "table": "article", "operation": "jhUpdate" } {} 64 course_mgmt insert
✅作业设计-题库列表 assignmentDesign selectQuestionList null sql {"table":"question","operation":"select"} {} 65 course_mgmt update 2022-07-28T08:56:53+08:00 vscode vscode
✅获取题目建议 assignmentDesign getAnswerPoints null service {"service": "assignment", "serviceFunction": "getAnswerPoints"} 93 course_mgmt insert

文章预览

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章预览 articlePreview seo articleViewer 406 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" }, { "field": "userInfo", "service": "user", "serviceFunc": "userInfo" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
articlePreview selectItemList null service { "service": "article", "serviceFunction": "getArticleListFromArticleQuery" } 66 course_mgmt insert
articlePreview selectArticleInfo null service { "service": "article", "serviceFunction": "getArticleAndFillArticles" } 67 course_mgmt insert

考卷列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
考卷列表 examList showInMenu null 402 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅考试列表-查询列表(不包含内容) examList selectItemList null sql { "table": "view01_article", "operation": "select" } {} 75 course_mgmt jhInsert
✅考试列表-查询分类列表 examList selectCategoryList null sql { "table": "view01_category", "operation": "select" } {} 76 course_mgmt insert
✅考卷列表-获取课程列表 examList selectCourseList null sql {"table":"course","operation":"select"} {} 77 course_mgmt update 2022-07-28T08:56:53+08:00 vscode vscode
examList insertArticleItem { "before": [ { "service": "article", "serviceFunction": "fillInsertItemParamsBeforeHook" } ], "after": [ { "service": "article", "serviceFunction": "articleHistoryRecordAfterHook" } ] } sql { "table": "article", "operation": "jhInsert" } {} 78 course_mgmt insert
examList updateArticleTitle null sql { "table": "article", "operation": "jhUpdate" } {} 79 course_mgmt insert
✅试卷列表-从课程中解除绑定文章 examList unbindArticleFromCourse null sql { "table": "course_article", "operation": "jhDelete" } {} 80 course_mgmt insert

素材库

  • 页面信息
pageName pageId pageType pageFile sort pageHook
素材库 mediaLibrary showInMenu null 501 { "beforeHook": [ { "field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅素材管理-文件列表 mediaLibrary list null service { "service": "material", "serviceFunction": "list" } {} 81 course_mgmt insert
✅素材管理-创建文件夹 mediaLibrary mkdir null service { "service": "material", "serviceFunction": "mkdir" } {} 82 course_mgmt insert
✅素材管理-删除 mediaLibrary delete null service { "service": "material", "serviceFunction": "delete" } {} 83 course_mgmt insert
✅素材管理-清空回收站 mediaLibrary clearRecycle null service { "service": "material", "serviceFunction": "clearRecycle" } {} 84 course_mgmt insert
✅素材管理-文件重命名 mediaLibrary renameFile null service { "service": "material", "serviceFunction": "renameFile" } {} 85 course_mgmt insert
✅素材管理-移动文件 mediaLibrary moveFile null service { "service": "material", "serviceFunction": "moveFile" } {} 86 course_mgmt insert
✅素材管理-复制文件 mediaLibrary copyFile null service { "service": "material", "serviceFunction": "copyFile" } {} 87 course_mgmt insert

待批准的文章

  • 页面信息
pageName pageId pageType pageFile sort pageHook
待批准的文章 designArticleManagement null 901 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅待批准的文章-待批准的文章列表 designArticleManagement selectItemList null sql {"table":"view01_design_article","operation":"select"} {} 90 course_mgmt update 2022-10-15T22:54:05+08:00 vscode vscode
✅待批准的文章-查询分类列表 designArticleManagement selectDesignCategoryList null sql { "table": "view01_design_category", "operation": "select" } {} 91 course_mgmt insert
✅待批准的文章-批准“文章开发平台”的三稿 designArticleManagement copyArticleFromDesign null service {"service": "article", "serviceFunction": "copyArticleFromDesign"} 92 course_mgmt update 2022-10-15T22:54:06+08:00 vscode vscode

课程与班级管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程与班级管理 courseManagement 900 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程的课程分期管理-查询当前课程分期下的课程列表 courseManagement selectCurrentList null sql { "table": "cgg_course", "operation": "select" } {} 110 sys_admin jhInsert
✅课程的课程分期管理-建立关系 courseManagement insertItem null sql { "table": "cgg_course", "operation": "jhInsert" } {} 111 sys_admin jhInsert
✅课程的课程分期管理-更新数据 courseManagement updateItem null sql { "table": "cgg_course", "operation": "jhUpdate" } {} 112 sys_admin jhInsert
✅课程的课程分期管理-删除信息 courseManagement deleteItem null sql { "table": "cgg_course", "operation": "jhDelete" } {} 113 sys_admin jhInsert
✅课程查询-查询列表 courseManagement selectAllList null sql { "table": "cgg_course", "operation": "select" } {} 114 sys_admin jhInsert

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 1 course_mgmt update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 94 sys_admin update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin { "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] } service { "service": "user", "serviceFunction": "passwordLogin" } {} 134 student insert
✅登陆 login passwordLogin null service { "service": "user", "serviceFunction": "passwordLogin" } {} 234 teacher insert

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help dynamicInMenu helpV4 11 null

用户管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
用户管理 userManagement showInAvatarMenu null 6 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅用户管理-查询信息 userManagement selectItemList null sql {"table": "_user", "operation": "select"} 98 sys_admin update 2022-04-29T16:33:28+08:00 {"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"}
✅用户管理-查询信息 userManagement insertItem null service {"service": "userManagement", "serviceFunction": "addUser"} 99 sys_admin update 2022-04-28T16:36:00+08:00 {"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"}
✅用户管理-修改密码 userManagement resetUserPassword null service {"service": "userManagement", "serviceFunction": "resetUserPassword"} 100 sys_admin update 2022-04-28T16:37:21+08:00 {"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"}
✅用户管理-更新用户 userManagement updateItem null sql {"table": "_user", "operation": "jhUpdate"} 101 sys_admin update 2022-04-29T16:33:27+08:00 {"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"}

成员管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
成员管理 memberManagement showInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 memberManagement selectItemList null sql { "table": "cgg_member_v3", "operation": "select" } {} 102 sys_admin insert
✅添加 memberManagement insertItem null sql { "table": "cgg_member_v3", "operation": "insert" } {} 103 sys_admin insert
✅更新 memberManagement updateItem null sql { "table": "cgg_member_v3", "operation": "jhUpdate" } {} 104 sys_admin insert
✅删除 memberManagement deleteItem null sql { "table": "cgg_member_v3", "operation": "jhDelete" } {} 105 sys_admin insert

课程管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程管理 courseSeriesManagement showInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程查询-查询列表 courseSeriesManagement selectItemList null sql { "table": "cgg_course_series", "operation": "select" } {} 106 sys_admin jhInsert
✅课程查询-添加成员 courseSeriesManagement insertItem null sql { "table": "cgg_course_series", "operation": "jhInsert" } {} 107 sys_admin jhInsert
✅课程查询-更新成员 courseSeriesManagement updateItem null sql { "table": "cgg_course_series", "operation": "jhUpdate" } {} 108 sys_admin jhInsert
✅课程查询-删除信息 courseSeriesManagement deleteItem null sql { "table": "cgg_course_series", "operation": "jhDelete" } {} 109 sys_admin jhInsert

课程分期管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程分期管理 courseManagement dynamicInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程的课程分期管理-查询当前课程分期下的课程列表 courseManagement selectCurrentList null sql { "table": "cgg_course", "operation": "select" } {} 110 sys_admin jhInsert
✅课程的课程分期管理-建立关系 courseManagement insertItem null sql { "table": "cgg_course", "operation": "jhInsert" } {} 111 sys_admin jhInsert
✅课程的课程分期管理-更新数据 courseManagement updateItem null sql { "table": "cgg_course", "operation": "jhUpdate" } {} 112 sys_admin jhInsert
✅课程的课程分期管理-删除信息 courseManagement deleteItem null sql { "table": "cgg_course", "operation": "jhDelete" } {} 113 sys_admin jhInsert
✅课程查询-查询列表 courseManagement selectAllList null sql { "table": "cgg_course", "operation": "select" } {} 114 sys_admin jhInsert

班级管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
班级管理 courseClassManagement showInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅班级查询-查询列表 courseClassManagement selectItemList null sql { "table": "course_class", "operation": "select" } {} 115 sys_admin jhInsert
✅班级查询-添加成员 courseClassManagement insertItem null sql { "table": "course_class", "operation": "jhInsert" } {} 116 sys_admin jhInsert
✅班级查询-更新成员 courseClassManagement updateItem null sql { "table": "course_class", "operation": "jhUpdate" } {} 117 sys_admin jhInsert
✅班级查询-删除信息 courseClassManagement deleteItem null sql { "table": "course_class", "operation": "jhDelete" } {} 118 sys_admin jhInsert

班级成员

  • 页面信息
pageName pageId pageType pageFile sort pageHook
班级成员 courseClassMemberManagement dynamicInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅班级的班级成员管理-查询当前班级成员下的班级列表 courseClassMemberManagement selectCurrentList null sql { "table": "class_member", "operation": "select" } {} 119 sys_admin jhInsert
✅班级的班级成员管理-建立关系 courseClassMemberManagement insertItem null sql { "table": "class_member", "operation": "jhInsert" } {} 120 sys_admin jhInsert
✅班级的班级成员管理-更新数据 courseClassMemberManagement updateItem null sql { "table": "class_member", "operation": "jhUpdate" } {} 121 sys_admin jhInsert
✅班级的班级成员管理-删除信息 courseClassMemberManagement deleteItem null sql { "table": "class_member", "operation": "jhDelete" } {} 122 sys_admin jhInsert
✅班级查询-查询列表 courseClassMemberManagement selectAllList null sql { "table": "class_member", "operation": "select" } {} 123 sys_admin jhInsert
✅成员查询 courseClassMemberManagement getMemberList null sql { "table": "cgg_member_v3", "operation": "select" } {} 124 sys_admin jhInsert
✅成员查询 courseClassMemberManagement insertClassMember null service {"service": "class", "serviceFunction": "insertClassMember"} {} 125 sys_admin jhInsert

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 1 course_mgmt update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 94 sys_admin update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin { "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] } service { "service": "user", "serviceFunction": "passwordLogin" } {} 134 student insert
✅登陆 login passwordLogin null service { "service": "user", "serviceFunction": "passwordLogin" } {} 234 teacher insert

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help dynamicInMenu helpV4 11 null

操作手册

  • 页面信息
pageName pageId pageType pageFile sort pageHook
操作手册 manual null null 0 null

课程列表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
课程列表 courseList showInMenu null null { "beforeHook": [ { "field": "constantUiObj", "service": "constantUi", "serviceFunc": "getConstantUiObj" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅课程列表-查询课程 courseList selectItemList null sql { "table": "view01_course_with_article_count", "operation": "select" } access_control_course {} 11 course_mgmt insert
课程-从课程与班级管理同步课程 courseList syncCourseList null service { "service": "course", "serviceFunction": "syncCourseList" } 12 course_mgmt insert
✅课程列表-获取我的课程 courseList getMyCourseList null sql { "table": "view01_user_course", "operation": "select" } {} 136 student insert

学习内容

  • 页面信息
pageName pageId pageType pageFile sort pageHook
学习内容 courseArticleList showInMenu null null null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅学习内容-获取笔记列表 courseArticleList getNoteList null sql { "table": "view01_note_list", "operation": "select" } {} 139 student insert
✅学习内容-获取作业列表 courseArticleList getAssignmentList null sql { "table": "view01_assignment_list", "operation": "select" } {} 140 student insert
✅学习内容-获取考试列表 courseArticleList getExamList null sql { "table": "view01_exam_list", "operation": "select" } {} 141 student insert
✅学习内容-获取课程学习内容 courseArticleList getMyCourseArticleList null sql { "table": "view01_user_course_article", "operation": "select" } {} 142 student insert
✅学习内容-获取出勤列表 courseArticleList getAttendanceList null sql { "table": "attendance", "operation": "select" } {} 143 student insert
✅学习内容-获取课程信息 courseArticleList getCourseInfo null sql { "table": "course", "operation": "select" } {} 163 student insert

文章详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章详情 articleDetail seo null null { "beforeHook": [ { "field": "configData", "service": "special", "serviceFunc": "mockDetail" } ] }
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
文章详情 articleDetail getArticleInfo null sql { "table": "view01_article", "operation": "select" } 152 student insert
✅文章详情-添加视频播放时长 articleDetail addVideoPlayTime null service { "service": "student", "serviceFunction": "addVideoPlayTime" } {} 156 student insert
?笔记-获取笔记内容 articleDetail selectItemList { "before": [ { "service": "userCenter", "serviceFunction": "appendUserIdToWhere" } ] } sql { "table": "note", "operation": "select" } {} 157 student insert

练习题

  • 页面信息
pageName pageId pageType pageFile sort pageHook
练习题 assignmentPaper dynamicInMenu null null null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅作业-创建作业 assignmentPaper insertUserAssignment { "after": [ { "service": "assignment", "serviceFunction": "insertAutomaticScoring" } ] } service {"service": "assignment", "serviceFunction": "insertUserAssignment"} {} 158 student insert
✅作业-获取作业 assignmentPaper getUserAssignment { "after": [ { "service": "assignment", "serviceFunction": "checkAndRemoveStandardAnswer" } ] } sql { "table": "assignment", "operation": "select"} {} 159 student insert
✅作业-保存作业草稿 assignmentPaper saveUserAssignment { "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" } ] } sql { "table": "assignment", "operation": "jhUpdate" } {} 160 student insert
✅作业-提交作业 assignmentPaper submitUserAssignment { "before": [ { "service": "assignment", "serviceFunction": "autoReviewUserAssignment" } ], "after": [ { "service": "assignment", "serviceFunction": "afterRecordBehaviorHook" }, { "service": "assignment", "serviceFunction": "updateAutomaticScoring" } ] } sql { "table": "assignment", "operation": "jhUpdate" } {} 161 student insert
✅作业-重做作业 assignmentPaper redoUserAssignment { "before": [ { "service": "assignment", "serviceFunction": "redoUserAssignment" } ] } sql { "table": "assignment", "operation": "jhUpdate" } {} 162 student insert
✅获取作业详情 assignmentPaper getAssignmentDetail { "after": [ { "service": "assignment", "serviceFunction": "checkUserAssignmentStatusAfterHook" } ] } sql {"table": "view01_article", "operation": "select"} 206 student update 2022-04-25T15:31:12+08:00

考试

  • 页面信息
pageName pageId pageType pageFile sort pageHook
考试 examPaper dynamicInMenu null null null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
examPaper getExamPaper { "before": [ { "service": "exam", "serviceFunction": "passcodeCheck" } ], "after": [] } sql { "table": "view01_course_article_detail", "operation": "select" } {} 145 student insert
examPaper insertItem { "before": [ { "service": "exam", "serviceFunction": "appendAssignIdToActionData" } ], "after": [ { "service": "exam", "serviceFunction": "insertAutomaticScoring" } ] } sql { "table": "examination", "operation": "insert" } 146 student insert
examPaper updateItem sql { "table": "examination", "operation": "update" } 147 student insert
examPaper getSavedAnswer null sql { "table": "view01_exam", "operation": "select" } {} 148 student insert
examPaper getExamInfo { "before": [ { "service": "exam", "serviceFunction": "checkUserExam" } ], "after": [] } sql { "table": "view01_course_article_detail", "operation": "select" } {} 151 student insert

我的

  • 页面信息
pageName pageId pageType pageFile sort pageHook
我的 my/index seo null null { "beforeHook": [ { "field": "constantUiObj", "service": "constantUi", "serviceFunc": "getConstantUiObj" } ] }

设置页

  • 页面信息
pageName pageId pageType pageFile sort pageHook
设置页 my/info seo null null null

文章详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
文章详情 article/detail seo null null null

作业详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业详情 assignment/detail seo null null null

作业首页

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业首页 assignment/index seo null null null

作业详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业详情 exam/detail seo null null null

作业首页

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业首页 exam/index seo null null null

练习题

  • 页面信息
pageName pageId pageType pageFile sort pageHook
练习题 assignmentIndex seo null null null

考试

  • 页面信息
pageName pageId pageType pageFile sort pageHook
考试 examIndex seo null null null

学习记录

  • 页面信息
pageName pageId pageType pageFile sort pageHook
学习记录 my/studyRecord seo null null null

登陆

  • 页面信息
pageName pageId pageType pageFile sort pageHook
登陆 login loginV4 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 1 course_mgmt update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin null service {"service": "user", "serviceFunction": "passwordLogin"} {} 94 sys_admin update 2022-04-27T15:32:57+08:00
✅登陆 login passwordLogin { "before": [], "after": [ { "service": "userCenter", "serviceFunction": "afterLoginEditLoginAt" } ] } service { "service": "user", "serviceFunction": "passwordLogin" } {} 134 student insert
✅登陆 login passwordLogin null service { "service": "user", "serviceFunction": "passwordLogin" } {} 234 teacher insert

帮助

  • 页面信息
pageName pageId pageType pageFile sort pageHook
帮助 help dynamicInMenu helpV4 11 null

操作手册

  • 页面信息
pageName pageId pageType pageFile sort pageHook
操作手册 manual null 0 null

批改作业

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改作业 assignmentManagement showInMenu null 3 null

批改作业-详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改作业-详情 assignmentReview dynamicInMenu null 3 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅assignmentManagement查询-查询列表 assignmentReview selectItemList { "before": [ { "service": "assignment", "serviceFunction": "checkAssignmentReview" } ] } sql {"table":"view02_assignment_for_review","operation":"select"} {} 249 teacher update 2022-11-02T16:45:33+08:00 vscode vscode
assignmentReview getCourseInfo null sql {"table":"course","operation":"select"} {} 250 teacher insert
✅模拟做题-更新 assignmentReview updateItem { "after": [ { "service": "assignment", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } sql {"table": "assignment", "operation": "jhUpdate"} {} 251 teacher update 2022-11-02T16:45:33+08:00 vscode vscode
✅查询-查询列表 assignmentReview selectNoteList { "before": [ { "service": "note", "serviceFunction": "checkNoteReview" } ] } sql {"table":"note","operation":"select"} 256 teacher update 2022-11-02T16:45:33+08:00 vscode vscode

批改笔记

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改笔记 noteManagement showInMenu null 4 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅更新 noteManagement updateItem { "after": [ { "service": "note", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } sql { "table": "note", "operation": "jhUpdate" } {} 257 teacher update 2022-09-16T14:49:31+08:00 vscode vscode

批改笔记-详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改笔记-详情 noteReview dynamicInMenu null 4 null

批改考试

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改考试 examManagement showInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅作业管理-查询列表 examManagement selectItemList null service {"service":"assignment","serviceFunction":"selectTeacherExam"} {} 258 teacher update 2022-08-25T23:37:19+08:00 vscode vscode
✅撤销提交 examManagement cancelSubmit null sql {"table":"examination","operation":"jhUpdate"} 260 teacher update 2022-08-25T23:37:20+08:00 vscode vscode

批改考试-详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
批改考试-详情 examReview dynamicInMenu null 5 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅assignmentManagement查询-查询列表 examReview selectItemList { "before": [ { "service": "assignment", "serviceFunction": "checkAssignmentReview" } ] } sql {"table":"view02_examination_for_review","operation":"select"} {} 261 teacher update 2022-11-02T16:45:33+08:00 vscode vscode
✅模拟做题-更新 examReview updateItem { "after": [ { "service": "assignment", "serviceFunction": "afterRecordTeacherBehaviorHook" } ] } sql {"table": "examination", "operation": "jhUpdate"} {} 262 teacher update 2022-11-02T16:45:33+08:00 vscode vscode

出勤记录

  • 页面信息
pageName pageId pageType pageFile sort pageHook
出勤记录 attendanceRecord dynamicInMenu null 2 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅出勤记录-查询班级 attendanceRecord selectGroupList { "before": [ { "service": "group", "serviceFunction": "beforeAppendGroupIdToWhereIn" } ] } sql {"table":"view01_class_attendance","operation":"select"} 268 teacher insert 2022-11-26T15:48:20+08:00 vscode vscode
✅出勤记录-查询学员列表 attendanceRecord selectTeacherStudentList { "before": [ { "service": "group", "serviceFunction": "beforeAppendGroupIdToWhereIn" } ] } sql {"table":"view01_baofeng_student_group_role","operation":"select"} {} 270 teacher insert
✅出勤记录-查询出勤记录 attendanceRecord selectAttendanceRecordList sql {"table":"view02_attendance","operation":"select"} {} 271 teacher insert
✅创建出勤记录 attendanceRecord createAttendanceRecord null service {"service":"attendance","serviceFunction":"createAttendanceRecord"} 272 teacher insert
✅出勤记录-更新 attendanceRecord updateItem sql {"table":"attendance","operation":"jhUpdate"} {} 273 teacher insert
✅创建出勤记录 attendanceRecord updateAttendanceRecord null service {"service":"attendance","serviceFunction":"updateAttendanceRecord"} 274 teacher insert

我的学员

  • 页面信息
pageName pageId pageType pageFile sort pageHook
我的学员 myStudentList showInMenu null 98 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
myStudentList getCourseListByTeacher null sql {"table":"view01_class_member","operation":"select"} {} 275 teacher insert
myStudentList getStudentListByCourse { "before": [ { "service": "learningRecord", "serviceFunction": "beforeAppendClassStudentIdToWhereIn" } ] } sql { "table": "view01_student_learning_record", "operation": "select" } {} 276 teacher insert
myStudentList getCourseLessonDataForTeacher null service { "service": "learningRecord", "serviceFunction": "getCourseLessonDataForTeacher" } {} 277 teacher insert
myStudentList getStudentLearningRecordByStudent null sql {"table":"student_learning_record","operation":"select"} {} 278 teacher insert
myStudentList updateItem { "before": [ { "service": "learningRecord", "serviceFunction": "checkExistCourseMemberId" } ] } sql {"table":"student_learning_record","operation":"jhUpdate"} {} 279 teacher insert
myStudentList getLatestLearningRecordForStudent null service { "service": "learningRecord", "serviceFunction": "getLatestLearningRecordForStudent" } {} 280 teacher insert
✅我的学员-发布学生毕业记录 myStudentList createCompleteCourseRecord null sql {"table":"student_complete_course_record","operation":"jhInsert"} {} 346 teacher insert
myStudentList updateItemDev { "before": [ { "service": "learningRecord", "serviceFunction": "checkExistCourseMemberId" } ] } sql {"table":"__dev__student_learning_record","operation":"jhUpdate"} {} 347 teacher insert
myStudentList revokeCompleteCourseRecord null sql {"table":"student_complete_course_record","operation":"jhDelete"} {} 348 teacher insert

学员提醒

  • 页面信息
pageName pageId pageType pageFile sort pageHook
学员提醒 studentWarn showInMenu null 9 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 studentWarn selectItemList null service {"service":"assignment","serviceFunction":"studentBehavior"} {} 281 teacher update 2022-11-25T20:55:57+08:00 vscode vscode

教师提醒

  • 页面信息
pageName pageId pageType pageFile sort pageHook
教师提醒 teacherWarn showInMenu null 9 null
  • 接口信息
desc pageId actionId resourceHook resourceType resourceData accessControlTable appDataSchema id jhId operation operationAt operationByUser operationByUserId requestDemo responseDemo
✅查询列表 teacherWarn selectItemList null sql {"table":"view01_teacher_behavior","operation":"select"} {} 282 teacher update 2022-11-25T20:55:57+08:00 vscode vscode

作业重置

  • 页面信息
pageName pageId pageType pageFile sort pageHook
作业重置 __assignmentRevert dynamicInMenu null 7 null

班级管理

  • 页面信息
pageName pageId pageType pageFile sort pageHook
班级管理 __classList dynamicInMenu null 7 null

班级报表

  • 页面信息
pageName pageId pageType pageFile sort pageHook
班级报表 __classReportForms dynamicInMenu null 8 null

我的学员

  • 页面信息
pageName pageId pageType pageFile sort pageHook
我的学员 __studentManagement dynamicInMenu null 1 null

学员详情

  • 页面信息
pageName pageId pageType pageFile sort pageHook
学员详情 __student dynamicInMenu student 1 { "beforeHook": [ { "service": "userCenter", "serviceFunc": "appendStudentPageUserIdToCookie", "field": "" } ] }

我的学员

  • 页面信息
pageName pageId pageType pageFile sort pageHook
我的学员 __studentCourseDetail dynamicInMenu null 10 null

班级信息

  • 页面信息
pageName pageId pageType pageFile sort pageHook
班级信息 __baofengGroup dynamicInMenu null 11 null

通知/待办

  • 页面信息
pageName pageId pageType pageFile sort pageHook
通知/待办 https://demo.jianghujs.org/task/page/noticeManagement showInRightMenu null null null

_page语句

  1. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'course_mgmt', 'login', '登陆', 'loginV4', '', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  2. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'course_mgmt', 'manual', '操作手册', NULL, NULL, NULL, '998', NULL, 'insert', NULL, NULL, NULL);
  3. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'course_mgmt', 'help', '帮助', 'helpV4', NULL, NULL, '999', NULL, 'insert', NULL, NULL, NULL);
  4. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'course_mgmt', 'courseList', '课程列表', NULL, 'showInMenu', NULL, '101', NULL, 'insert', NULL, NULL, NULL);
  5. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'course_mgmt', 'articleListByCourse', '课程的文章列表', NULL, NULL, NULL, '103', NULL, 'insert', NULL, NULL, NULL);
  6. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'course_mgmt', 'examListByCourse', '课程的试卷列表', NULL, NULL, NULL, '104', NULL, 'insert', NULL, NULL, NULL);
  7. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'course_mgmt', 'albumList', '教材管理', NULL, NULL, NULL, '201', NULL, 'insert', NULL, NULL, NULL);
  8. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'course_mgmt', 'articleListByAlbum', '教材的文章列表', NULL, NULL, NULL, '202', NULL, 'insert', NULL, NULL, NULL);
  9. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'course_mgmt', 'articleList', '文章列表', NULL, 'showInMenu', NULL, '401', NULL, 'insert', NULL, NULL, NULL);
  10. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'course_mgmt', 'articleEdit', '文章编辑', NULL, NULL, NULL, '403', '{
  11.   "beforeHook":[
  12.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  13.     ]
  14. }', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'course_mgmt', 'assignmentDesign', '作业设计', NULL, NULL, NULL, '405', NULL, 'insert', 'vscode', 'vscode', '2022-08-25T23:02:59+08:00');
  16. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'course_mgmt', 'articlePreview', '文章预览', 'articleViewer', 'seo', NULL, '406', '{
  17.   "beforeHook":[
  18.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"},
  19.         {"field": "userInfo", "service": "user", "serviceFunc": "userInfo"}
  20.   ]
  21. }', 'insert', NULL, NULL, NULL);
  22. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'course_mgmt', 'examList', '考卷列表', NULL, 'showInMenu', NULL, '402', NULL, 'insert', NULL, NULL, NULL);
  23. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'course_mgmt', 'mediaLibrary', '素材库', NULL, 'showInMenu', NULL, '501', '{
  24.   "beforeHook":[
  25.     {"field": "constantUiMap", "service": "constantUi", "serviceFunc": "getConstantUiMap"}
  26.     ]
  27. }', 'insert', NULL, NULL, NULL);
  28. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'course_mgmt', 'designArticleManagement', '待批准的文章', NULL, '', NULL, '901', NULL, 'insert', 'vscode', 'vscode', '2022-10-15T21:34:50+08:00');
  29. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'course_mgmt', 'courseManagement', '课程与班级管理', '', '', NULL, '900', NULL, 'insert', NULL, NULL, NULL);
  30. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'sys_admin', 'login', '登陆', 'loginV4', '', NULL, '', NULL, 'insert', NULL, NULL, NULL);
  31. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'sys_admin', 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, '11', NULL, 'insert', NULL, NULL, NULL);
  32. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'sys_admin', 'userManagement', '用户管理', NULL, 'showInAvatarMenu', NULL, '6', NULL, 'insert', NULL, NULL, NULL);
  33. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'sys_admin', 'memberManagement', '成员管理', NULL, 'showInMenu', NULL, '5', NULL, 'insert', NULL, NULL, NULL);
  34. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'sys_admin', 'courseSeriesManagement', '课程管理', NULL, 'showInMenu', NULL, '5', NULL, 'jhInsert', NULL, NULL, NULL);
  35. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'sys_admin', 'courseManagement', '课程分期管理', NULL, 'dynamicInMenu', NULL, '5', NULL, 'jhInsert', NULL, NULL, NULL);
  36. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'sys_admin', 'courseClassManagement', '班级管理', NULL, 'showInMenu', NULL, '5', NULL, 'jhInsert', NULL, NULL, NULL);
  37. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'sys_admin', 'courseClassMemberManagement', '班级成员', NULL, 'dynamicInMenu', NULL, '5', NULL, 'jhInsert', NULL, NULL, NULL);
  38. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'student', 'login', '登陆', 'loginV4', '', NULL, '', NULL, 'insert', NULL, NULL, NULL);
  39. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'student', 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, '11', NULL, 'insert', NULL, NULL, NULL);
  40. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'student', 'manual', '操作手册', NULL, NULL, NULL, '0', NULL, 'insert', NULL, NULL, NULL);
  41. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'student', 'courseList', '课程列表', NULL, 'showInMenu', NULL, NULL, '{
  42.   "beforeHook":[
  43.     {"field": "constantUiObj", "service": "constantUi", "serviceFunc": "getConstantUiObj"}
  44.     ]
  45. }', 'insert', NULL, NULL, NULL);
  46. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'student', 'courseArticleList', '学习内容', NULL, 'showInMenu', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  47. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'student', 'articleDetail', '文章详情', NULL, 'seo', NULL, NULL, '{
  48.   "beforeHook":[
  49.     {"field": "configData", "service": "special", "serviceFunc": "mockDetail"}
  50.     ]
  51. }', 'insert', NULL, NULL, NULL);
  52. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'student', 'assignmentPaper', '练习题', NULL, 'dynamicInMenu', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  53. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (32, 'student', 'examPaper', '考试', NULL, 'dynamicInMenu', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  54. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (45, 'student', 'my/index', '我的', NULL, 'seo', NULL, NULL, '{
  55.   "beforeHook":[
  56.     {"field": "constantUiObj", "service": "constantUi", "serviceFunc": "getConstantUiObj"}
  57.     ]
  58. }', 'insert', NULL, NULL, NULL);
  59. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (46, 'student', 'my/info', '设置页', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  60. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (47, 'student', 'article/detail', '文章详情', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  61. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (48, 'student', 'assignment/detail', '作业详情', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  62. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (49, 'student', 'assignment/index', '作业首页', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  63. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (50, 'student', 'exam/detail', '作业详情', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  64. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (51, 'student', 'exam/index', '作业首页', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  65. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (52, 'student', 'assignmentIndex', '练习题', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  66. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (53, 'student', 'examIndex', '考试', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  67. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (54, 'student', 'my/studyRecord', '学习记录', NULL, 'seo', NULL, NULL, NULL, 'insert', NULL, NULL, NULL);
  68. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (55, 'teacher', 'login', '登陆', 'loginV4', '', NULL, '', NULL, 'insert', NULL, NULL, NULL);
  69. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (56, 'teacher', 'help', '帮助', 'helpV4', 'dynamicInMenu', NULL, '11', NULL, 'insert', NULL, NULL, NULL);
  70. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (57, 'teacher', 'manual', '操作手册', NULL, '', NULL, '0', NULL, 'update', 'vscode', 'vscode', '2022-08-26T09:34:11+08:00');
  71. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (58, 'teacher', 'assignmentManagement', '批改作业', NULL, 'showInMenu', NULL, '3', NULL, 'update', 'vscode', 'vscode', '2022-07-22T22:42:54+08:00');
  72. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (59, 'teacher', 'assignmentReview', '批改作业-详情', NULL, 'dynamicInMenu', NULL, '3', NULL, 'insert', NULL, NULL, NULL);
  73. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (60, 'teacher', 'noteManagement', '批改笔记', NULL, 'showInMenu', NULL, '4', NULL, 'update', 'vscode', 'vscode', '2022-09-15T00:22:11+08:00');
  74. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (61, 'teacher', 'noteReview', '批改笔记-详情', NULL, 'dynamicInMenu', NULL, '4', NULL, 'insert', 'vscode', 'vscode', '2022-10-05T16:34:51+08:00');
  75. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (62, 'teacher', 'examManagement', '批改考试', NULL, 'showInMenu', NULL, '5', NULL, 'update', 'vscode', 'vscode', '2022-07-22T22:42:54+08:00');
  76. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (63, 'teacher', 'examReview', '批改考试-详情', NULL, 'dynamicInMenu', NULL, '5', NULL, 'insert', NULL, NULL, NULL);
  77. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (64, 'teacher', 'attendanceRecord', '出勤记录', NULL, 'dynamicInMenu', NULL, '2', NULL, 'insert', 'vscode', 'vscode', '2022-11-26T15:46:48+08:00');
  78. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (65, 'teacher', 'myStudentList', '我的学员', NULL, 'showInMenu', NULL, '98', NULL, 'insert', NULL, NULL, NULL);
  79. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (66, 'teacher', 'studentWarn', '学员提醒', NULL, 'showInMenu', NULL, '9', NULL, 'update', 'vscode', 'vscode', '2022-11-25T20:49:51+08:00');
  80. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (67, 'teacher', 'teacherWarn', '教师提醒', NULL, 'showInMenu', NULL, '9', NULL, 'update', 'vscode', 'vscode', '2022-11-25T20:49:51+08:00');
  81. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (68, 'teacher', '__assignmentRevert', '作业重置', NULL, 'dynamicInMenu', NULL, '7', NULL, 'update', 'vscode', 'vscode', '2022-10-05T21:49:32+08:00');
  82. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (69, 'teacher', '__classList', '班级管理', NULL, 'dynamicInMenu', NULL, '7', NULL, 'insert', NULL, NULL, NULL);
  83. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (70, 'teacher', '__classReportForms', '班级报表', NULL, 'dynamicInMenu', NULL, '8', NULL, 'insert', NULL, NULL, NULL);
  84. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (71, 'teacher', '__studentManagement', '我的学员', NULL, 'dynamicInMenu', NULL, '1', NULL, 'insert', NULL, NULL, NULL);
  85. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (72, 'teacher', '__student', '学员详情', 'student', 'dynamicInMenu', NULL, '1', '{"beforeHook": [{"service": "userCenter", "serviceFunc": "appendStudentPageUserIdToCookie", "field": ""}]}', 'insert', NULL, NULL, NULL);
  86. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (73, 'teacher', '__studentCourseDetail', '我的学员', NULL, 'dynamicInMenu', NULL, '10', NULL, 'insert', NULL, NULL, NULL);
  87. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (74, 'teacher', '__baofengGroup', '班级信息', NULL, 'dynamicInMenu', NULL, '11', NULL, 'insert', 'vscode', 'vscode', '2022-11-26T15:46:48+08:00');
  88. INSERT INTO _page (id, jhId, pageId, pageName, pageFile, pageType, pageIcon, sort, pageHook, operation, operationByUserId, operationByUser, operationAt) VALUES (242, NULL, 'https://demo.jianghujs.org/task/page/noticeManagement', '通知/待办', NULL, 'showInRightMenu', '<svg width="28" height="28" viewBox="0 0 28 28" fill="none" xmlns="http://www.w3.org/2000/svg"> <g id="Frame 19"> <path id="Vector" d="M14 0C6.2695 0 0 6.2695 0 14C0 21.7305 6.2695 28 14 28C21.7305 28 28 21.7305 28 14C28 6.2695 21.7305 0 14 0Z" fill="#5DB55F"/> <g id="Frame"> <path id="Vector_2" d="M15.2698 19.44L15.307 19.4419C15.5022 19.4633 15.6398 19.6499 15.5895 19.8403L15.57 19.9088C15.3646 20.5638 14.7393 21.04 14.0001 21.04L13.9239 21.0384C13.193 21.0057 12.5866 20.5075 12.4103 19.8403L12.4033 19.8048C12.3758 19.6153 12.5284 19.44 12.7303 19.44H15.2698ZM14.0001 6.95996C14.1274 6.95996 14.2495 7.01053 14.3395 7.10055C14.4295 7.19057 14.4801 7.31266 14.4801 7.43996V7.94364C16.9402 8.191 18.8001 10.3545 18.8001 12.8556V16.24L18.802 16.288C18.8141 16.4489 18.8866 16.5994 19.0049 16.7091C19.1232 16.8189 19.2787 16.8799 19.4401 16.88H19.5543L19.6087 16.8816C20.0055 16.9065 20.3562 17.1993 20.3959 17.5974L20.3994 17.6486C20.4037 17.7562 20.3861 17.8635 20.3479 17.9642C20.3096 18.0648 20.2514 18.1567 20.1768 18.2343C20.1022 18.312 20.0127 18.3737 19.9137 18.4159C19.8146 18.4581 19.7081 18.4799 19.6004 18.48H8.44583L8.39143 18.4784C7.99463 18.4534 7.64391 18.1606 7.60423 17.7625L7.60071 17.7113C7.59649 17.6037 7.61404 17.4964 7.65231 17.3957C7.69058 17.295 7.74878 17.2031 7.82342 17.1255C7.89807 17.0479 7.98762 16.9861 8.0867 16.9439C8.18579 16.9017 8.29238 16.88 8.40007 16.88H8.56007L8.60807 16.8784C8.76908 16.8663 8.91956 16.7937 9.02935 16.6753C9.13914 16.5569 9.20012 16.4014 9.20007 16.24V12.72C9.20007 10.231 11.0945 8.1846 13.5201 7.94364V7.43996C13.5201 7.31266 13.5706 7.19057 13.6607 7.10055C13.7507 7.01053 13.8728 6.95996 14.0001 6.95996Z" fill="white"/> </g> </g> </svg>', NULL, NULL, 'insert', NULL, NULL, NULL);