江湖数字化平台
登录

常量

12120

常量总览

_constant结构

  1. CREATE TABLE `_constant` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `jhId` varchar(255)  DEFAULT NULL,
  4.   `constantKey` varchar(255)  DEFAULT NULL,
  5.   `constantType` varchar(255)  DEFAULT NULL COMMENT '常量类型; object, array',
  6.   `desc` varchar(255)  DEFAULT NULL COMMENT '描述',
  7.   `constantValue` text  COMMENT '常量内容; object, array',
  8.   `operation` varchar(255)  DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',
  9.   `operationByUserId` varchar(255)  DEFAULT NULL COMMENT '操作者userId',
  10.   `operationByUser` varchar(255)  DEFAULT NULL COMMENT '操作者用户名',
  11.   `operationAt` varchar(255)  DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',
  12.   PRIMARY KEY (`id`) USING BTREE
  13. ) ENGINE = InnoDB AUTO_INCREMENT = 32 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'

_constant 表数据

会员价格

constantKey constantType
memberPrice integer 
  1. 99

homeRecommendType

constantKey constantType
homeRecommendType array 
  1. [
  2.   {
  3.     "value": "banner",
  4.     "text": "轮播图"
  5.   },
  6.   {
  7.     "value": "navIcon",
  8.     "text": "跳转图标"
  9.   },
  10.   {
  11.     "value": "news",
  12.     "text": "新闻"
  13.   },
  14.   {
  15.     "value": "bulletin",
  16.     "text": "简报"
  17.   },
  18.   {
  19.     "value": "activity",
  20.     "text": "活动"
  21.   },
  22.   {
  23.     "value": "ad",
  24.     "text": "广告"
  25.   },
  26.   {
  27.     "value": "live",
  28.     "text": "直播"
  29.   },
  30.   {
  31.     "value": "course",
  32.     "text": "课程"
  33.   },
  34.   {
  35.     "value": "link",
  36.     "text": "自定义跳转"
  37.   },
  38.   {
  39.     "value": "goods",
  40.     "text": "商品"
  41.   },
  42.   {
  43.     "value": "hotLive",
  44.     "text": "热门直播"
  45.   },
  46.   {
  47.     "value": "teacher",
  48.     "text": "讲师"
  49.   },
  50.   {
  51.     "value": "groupBooking",
  52.     "text": "拼团"
  53.   },
  54.   {
  55.     "value": "menu",
  56.     "text": "菜单"
  57.   },
  58.   {
  59.     "value": "material",
  60.     "text": "素材"
  61.   },
  62.   {
  63.     "value": "exam",
  64.     "text": "考试"
  65.   },
  66.   {
  67.     "value": "data",
  68.     "text": "文档"
  69.   },
  70.   {
  71.     "value": "exercise",
  72.     "text": "练习"
  73.   }
  74. ]

homeRecommendContentDisplay

constantKey constantType
homeRecommendContentDisplay array 
  1. [
  2.   {
  3.     "value": "big",
  4.     "text": "大图"
  5.   },
  6.   {
  7.     "value": "grid",
  8.     "text": "宫图"
  9.   },
  10.   {
  11.     "value": "small",
  12.     "text": "小图"
  13.   },
  14.   {
  15.     "value": "row",
  16.     "text": "左右切换"
  17.   }
  18. ]

订单状态

constantKey constantType
orderStatus array 
  1. [
  2.   {
  3.     "value": "waitpay",
  4.     "text": "待支付"
  5.   },
  6.   {
  7.     "value": "paid",
  8.     "text": "已支付"
  9.   },
  10.   {
  11.     "value": "refunded",
  12.     "text": "已退款"
  13.   },
  14.   {
  15.     "value": "cancel",
  16.     "text": "已取消"
  17.   },
  18.   {
  19.     "value": "waitSend",
  20.     "text": "待发货"
  21.   },
  22.   {
  23.     "value": "waitReceive",
  24.     "text": "待收货"
  25.   },
  26.   {
  27.     "value": "waitComment",
  28.     "text": "待评价"
  29.   },
  30.   {
  31.     "value": "commented",
  32.     "text": "已评价"
  33.   }
  34. ]

退款状态

constantKey constantType
refundStatus array 
  1. [
  2.   {
  3.     "value": "unrefund",
  4.     "text": "未退款"
  5.   },
  6.   {
  7.     "value": "applying",
  8.     "text": "申请退款中"
  9.   },
  10.   {
  11.     "value": "refunded",
  12.     "text": "已退款"
  13.   }
  14. ]

商品类型

constantKey constantType
productType array 
  1. [
  2.   {
  3.     "value": "product",
  4.     "text": "商品"
  5.   },
  6.   {
  7.     "value": "course",
  8.     "text": "课程"
  9.   },
  10.   {
  11.     "value": "exam",
  12.     "text": "考试"
  13.   },
  14.   {
  15.     "value": "material",
  16.     "text": "资料"
  17.   }
  18. ]

会员等级

constantKey constantType
memberPrivilegeLevel array 
  1. [
  2.   {
  3.     "value": "001",
  4.     "text": "001会员"
  5.   },
  6.   {
  7.     "value": "101",
  8.     "text": "101会员"
  9.   },
  10.   {
  11.     "value": "201",
  12.     "text": "201会员"
  13.   }
  14. ]

notice

constantKey constantType
notice object 
  1. {
  2.   "title": "4.3.7 版本发布",
  3.   "content": "快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n",
  4.   "imageSrc": "/noticeImage/1647076649263_719911_noticeImage.jpeg",
  5.   "isImageShown": false,
  6.   "isTextShown": true
  7. }

userStatus

constantKey constantType
userStatus array 
  1. [
  2.   {
  3.     "value": "active",
  4.     "text": "正常"
  5.   },
  6.   {
  7.     "value": "banned",
  8.     "text": "禁用"
  9.   }
  10. ]

userType

constantKey constantType
userType array 
  1. [
  2.   {
  3.     "value": "common",
  4.     "text": "普通用户"
  5.   },
  6.   {
  7.     "value": "xiaochengxu",
  8.     "text": "小程序机器人"
  9.   }
  10. ]

gender

constantKey constantType
gender array 
  1. [
  2.   {
  3.     "value": "male",
  4.     "text": "男"
  5.   },
  6.   {
  7.     "value": "female",
  8.     "text": "女"
  9.   }
  10. ]

version

constantKey constantType
version object 
  1. {
  2.   "testUserIdList": "",
  3.   "version": "4.3.11",
  4.   "title": "4.3.7 版本发布",
  5.   "note": "新版本介绍\n 1. 聊天输入优化",
  6.   "apkVersion": "5.0.20",
  7.   "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk",
  8.   "apkNote": "",
  9.   "desktopVersion": "4.3.2",
  10.   "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip",
  11.   "desktopNote": "测试桌面客户端升级"
  12. }

emotion

constantKey constantType
emotion array 
  1. [
  2.   {
  3.     "dir": "face01",
  4.     "cover": "face-lbl",
  5.     "ext": "png",
  6.     "cols": 5,
  7.     "total": 86
  8.   },
  9.   {
  10.     "dir": "face02",
  11.     "cover": "face-lbl",
  12.     "ext": "gif",
  13.     "cols": 2,
  14.     "total": 16
  15.   },
  16.   {
  17.     "dir": "face03",
  18.     "cover": "face-lbl",
  19.     "ext": "gif",
  20.     "cols": 2,
  21.     "total": 16
  22.   },
  23.   {
  24.     "dir": "face04",
  25.     "cover": "face-lbl",
  26.     "ext": "gif",
  27.     "cols": 2,
  28.     "total": 16
  29.   },
  30.   {
  31.     "dir": "face05",
  32.     "cover": "face-lbl",
  33.     "ext": "gif",
  34.     "cols": 1,
  35.     "total": 7
  36.   },
  37.   {
  38.     "dir": "face06",
  39.     "cover": "face-lbl",
  40.     "ext": "gif",
  41.     "cols": 3,
  42.     "total": 24
  43.   },
  44.   {
  45.     "dir": "face07",
  46.     "cover": "face-lbl",
  47.     "ext": "gif",
  48.     "cols": 2,
  49.     "total": 16
  50.   },
  51.   {
  52.     "dir": "face08",
  53.     "cover": "face-lbl",
  54.     "ext": "gif",
  55.     "cols": 3,
  56.     "total": 23
  57.   },
  58.   {
  59.     "dir": "face09",
  60.     "cover": "face-lbl",
  61.     "ext": "gif",
  62.     "cols": 2,
  63.     "total": 16
  64.   },
  65.   {
  66.     "dir": "face10",
  67.     "cover": "face-lbl",
  68.     "ext": "gif",
  69.     "cols": 3,
  70.     "total": 20
  71.   },
  72.   {
  73.     "dir": "face11",
  74.     "cover": "face-lbl",
  75.     "ext": "gif",
  76.     "cols": 2,
  77.     "total": 13
  78.   },
  79.   {
  80.     "dir": "face12",
  81.     "cover": "face-lbl",
  82.     "ext": "gif",
  83.     "cols": 2,
  84.     "total": 16
  85.   },
  86.   {
  87.     "dir": "face13",
  88.     "cover": "face-lbl",
  89.     "ext": "gif",
  90.     "cols": 2,
  91.     "total": 15
  92.   },
  93.   {
  94.     "dir": "face14",
  95.     "cover": "face-lbl",
  96.     "ext": "gif",
  97.     "cols": 2,
  98.     "total": 16
  99.   }
  100. ]

appLinkActionConfig

constantKey constantType
appLinkActionConfig array 
  1. [
  2.   {
  3.     "regex": ".openjianghu.org/*",
  4.     "action": "internal"
  5.   },
  6.   {
  7.     "regex": "http://192.168./*",
  8.     "action": "internal"
  9.   }
  10. ]

链接列表

constantKey constantType
linkList object 
  1. [
  2.   {
  3.     "linkName": "courseCRUD",
  4.     "url": "https://fsapp.eggjs.tech/fs_member-course_v1/page/courseManagement",
  5.     "appId": "fs_member-course_v1",
  6.     "pageId": "courseManagement",
  7.     "params": [
  8.       "courseBatchId",
  9.       "title"
  10.     ]
  11.   }
  12. ]

文章类型

constantKey constantType
articleType array 
  1. [
  2.   {
  3.     "text": "文章",
  4.     "value": "article"
  5.   },
  6.   {
  7.     "text": "作业",
  8.     "value": "assignment"
  9.   },
  10.   {
  11.     "text": "考试",
  12.     "value": "exam"
  13.   },
  14.   {
  15.     "text": "资料",
  16.     "value": "material"
  17.   },
  18.   {
  19.     "text": "新闻",
  20.     "value": "news"
  21.   }
  22. ]

文章发布状态

constantKey constantType
articlePublishStatus array 
  1. [
  2.   {
  3.     "text": "登录可见",
  4.     "value": "login"
  5.   },
  6.   {
  7.     "text": "草稿",
  8.     "value": "draft"
  9.   },
  10.   {
  11.     "text": "回收站",
  12.     "value": "deleted"
  13.   }
  14. ]

显示状态

constantKey constantType
isDelShowStatus array 
  1. [
  2.   {
  3.     "text": "全部",
  4.     "value": null
  5.   },
  6.   {
  7.     "text": "正常",
  8.     "value": "false"
  9.   },
  10.   {
  11.     "text": "回收站",
  12.     "value": "true"
  13.   }
  14. ]

审核状态

constantKey constantType
auditStatus array 
  1. [
  2.   {
  3.     "text": "全部",
  4.     "value": null
  5.   },
  6.   {
  7.     "text": "等待中",
  8.     "value": "pending"
  9.   },
  10.   {
  11.     "text": "已通过",
  12.     "value": "approve"
  13.   },
  14.   {
  15.     "text": "已拒绝",
  16.     "value": "reject"
  17.   }
  18. ]

会员等级

constantKey constantType
memberPrivilegeLevel array 
  1. [
  2.   {
  3.     "value": "001",
  4.     "text": "001会员"
  5.   },
  6.   {
  7.     "value": "101",
  8.     "text": "101会员"
  9.   },
  10.   {
  11.     "value": "201",
  12.     "text": "201会员"
  13.   }
  14. ]

notice

constantKey constantType
notice object 
  1. {
  2.   "title": "4.3.7 版本发布",
  3.   "content": "快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n",
  4.   "imageSrc": "/noticeImage/1647076649263_719911_noticeImage.jpeg",
  5.   "isImageShown": false,
  6.   "isTextShown": true
  7. }

userStatus

constantKey constantType
userStatus array 
  1. [
  2.   {
  3.     "value": "active",
  4.     "text": "正常"
  5.   },
  6.   {
  7.     "value": "banned",
  8.     "text": "禁用"
  9.   }
  10. ]

userType

constantKey constantType
userType array 
  1. [
  2.   {
  3.     "value": "common",
  4.     "text": "普通用户"
  5.   },
  6.   {
  7.     "value": "xiaochengxu",
  8.     "text": "小程序机器人"
  9.   }
  10. ]

gender

constantKey constantType
gender array 
  1. [
  2.   {
  3.     "value": "male",
  4.     "text": "男"
  5.   },
  6.   {
  7.     "value": "female",
  8.     "text": "女"
  9.   }
  10. ]

version

constantKey constantType
version object 
  1. {
  2.   "testUserIdList": "admin01",
  3.   "version": "5.0.22",
  4.   "title": "5.0.19 版本发布",
  5.   "note": "新版本介绍\n 1. 网页版ui修复",
  6.   "apkVersion": "5.1.8",
  7.   "apkLink": "https://nextcloud.openjianghu.org/index.php/s/SyRaPyt9nFbFryX/download/%E6%97%8B%E9%A3%8E5-5.0.20.apk",
  8.   "apkNote": "新版本介绍\n 1. 网页版ui修复",
  9.   "desktopVersion": "4.3.2",
  10.   "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip",
  11.   "desktopNote": "测试桌面客户端升级"
  12. }

emotion

constantKey constantType
emotion array 
  1. [
  2.   {
  3.     "dir": "face01",
  4.     "cover": "face-lbl",
  5.     "ext": "png",
  6.     "cols": 5,
  7.     "total": 86
  8.   },
  9.   {
  10.     "dir": "face02",
  11.     "cover": "face-lbl",
  12.     "ext": "gif",
  13.     "cols": 2,
  14.     "total": 16
  15.   },
  16.   {
  17.     "dir": "face03",
  18.     "cover": "face-lbl",
  19.     "ext": "gif",
  20.     "cols": 2,
  21.     "total": 16
  22.   },
  23.   {
  24.     "dir": "face04",
  25.     "cover": "face-lbl",
  26.     "ext": "gif",
  27.     "cols": 2,
  28.     "total": 16
  29.   },
  30.   {
  31.     "dir": "face05",
  32.     "cover": "face-lbl",
  33.     "ext": "gif",
  34.     "cols": 1,
  35.     "total": 7
  36.   },
  37.   {
  38.     "dir": "face06",
  39.     "cover": "face-lbl",
  40.     "ext": "gif",
  41.     "cols": 3,
  42.     "total": 24
  43.   },
  44.   {
  45.     "dir": "face07",
  46.     "cover": "face-lbl",
  47.     "ext": "gif",
  48.     "cols": 2,
  49.     "total": 16
  50.   },
  51.   {
  52.     "dir": "face08",
  53.     "cover": "face-lbl",
  54.     "ext": "gif",
  55.     "cols": 3,
  56.     "total": 23
  57.   },
  58.   {
  59.     "dir": "face09",
  60.     "cover": "face-lbl",
  61.     "ext": "gif",
  62.     "cols": 2,
  63.     "total": 16
  64.   },
  65.   {
  66.     "dir": "face10",
  67.     "cover": "face-lbl",
  68.     "ext": "gif",
  69.     "cols": 3,
  70.     "total": 20
  71.   },
  72.   {
  73.     "dir": "face11",
  74.     "cover": "face-lbl",
  75.     "ext": "gif",
  76.     "cols": 2,
  77.     "total": 13
  78.   },
  79.   {
  80.     "dir": "face12",
  81.     "cover": "face-lbl",
  82.     "ext": "gif",
  83.     "cols": 2,
  84.     "total": 16
  85.   },
  86.   {
  87.     "dir": "face13",
  88.     "cover": "face-lbl",
  89.     "ext": "gif",
  90.     "cols": 2,
  91.     "total": 15
  92.   },
  93.   {
  94.     "dir": "face14",
  95.     "cover": "face-lbl",
  96.     "ext": "gif",
  97.     "cols": 2,
  98.     "total": 16
  99.   }
  100. ]

appLinkActionConfig

constantKey constantType
appLinkActionConfig array 
  1. [
  2.   {
  3.     "regex": ".openjianghu.org/*",
  4.     "action": "internal"
  5.   },
  6.   {
  7.     "regex": "http://192.168./*",
  8.     "action": "internal"
  9.   }
  10. ]

share

constantKey constantType
share array 
  1. [
  2.   {
  3.     "path": "/upload/image/share/shareImage01.jpg"
  4.   }
  5. ]

订单状态

constantKey constantType
orderStatus array 
  1. [
  2.   {
  3.     "value": "waitpay",
  4.     "text": "待支付"
  5.   },
  6.   {
  7.     "value": "paid",
  8.     "text": "已支付"
  9.   },
  10.   {
  11.     "value": "refunding",
  12.     "text": "退款中"
  13.   },
  14.   {
  15.     "value": "refunded",
  16.     "text": "已退款"
  17.   },
  18.   {
  19.     "value": "cancel",
  20.     "text": "已取消"
  21.   },
  22.   {
  23.     "value": "waitSend",
  24.     "text": "待发货"
  25.   },
  26.   {
  27.     "value": "waitReceive",
  28.     "text": "待收货"
  29.   },
  30.   {
  31.     "value": "waitComment",
  32.     "text": "待评价"
  33.   },
  34.   {
  35.     "value": "commented",
  36.     "text": "已评价"
  37.   }
  38. ]

退款状态

constantKey constantType
refundStatus array 
  1. [
  2.   {
  3.     "value": "unrefund",
  4.     "text": "未退款"
  5.   },
  6.   {
  7.     "value": "applying",
  8.     "text": "退款中"
  9.   },
  10.   {
  11.     "value": "refunded",
  12.     "text": "已退款"
  13.   }
  14. ]

_constant语句

  1. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'mgmt', 'memberPrice', 'integer', '会员价格', '99', 'insert', NULL, NULL, NULL);
  2. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'mgmt', 'homeRecommendType', 'array', NULL, '[{"value": "banner", "text": "轮播图"}, {"value": "navIcon", "text": "跳转图标"}, {"value": "news", "text": "新闻"}, {"value": "bulletin", "text": "简报"}, {"value": "activity", "text": "活动"}, {"value": "ad", "text": "广告"}, {"value": "live", "text": "直播"}, {"value": "course", "text": "课程"}, {"value": "link", "text": "自定义跳转"}, {"value": "goods", "text": "商品"}, {"value": "hotLive", "text": "热门直播"}, {"value": "teacher", "text": "讲师"}, {"value": "groupBooking", "text": "拼团"}, {"value": "menu", "text": "菜单"}, {"value": "material", "text": "素材"}, {"value": "exam", "text": "考试"}, {"value": "data", "text": "文档"}, {"value": "exercise", "text": "练习"}]', 'insert', NULL, NULL, NULL);
  3. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'mgmt', 'homeRecommendContentDisplay', 'array', NULL, '[{"value": "big", "text": "大图"}, {"value": "grid", "text": "宫图"}, {"value": "small", "text": "小图"}, {"value": "row", "text": "左右切换"}]', 'insert', NULL, NULL, NULL);
  4. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'mgmt', 'orderStatus', 'array', '订单状态', '[{"value":"waitpay","text":"待支付"},{"value":"paid","text":"已支付"},{"value":"refunded","text":"已退款"},{"value":"cancel","text":"已取消"},{"value":"waitSend","text":"待发货"},{"value":"waitReceive","text":"待收货"},{"value":"waitComment","text":"待评价"},{"value":"commented","text":"已评价"}]', 'insert', NULL, NULL, NULL);
  5. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, 'mgmt', 'refundStatus', 'array', '退款状态', '[{"value":"unrefund","text":"未退款"},{"value":"applying","text":"申请退款中"},{"value":"refunded","text":"已退款"}]
  6. ', 'insert', NULL, NULL, NULL);
  7. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'mgmt', 'productType', 'array', '商品类型', '[{"value":"product","text":"商品"},{"value":"course","text":"课程"},{"value":"exam","text":"考试"},{"value":"material","text":"资料"}]
  8. ', 'insert', NULL, NULL, NULL);
  9. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'mgmt', 'memberPrivilegeLevel', 'array', '会员等级', '[{"value":"001","text":"001会员"},{"value":"101","text":"101会员"},{"value":"201","text":"201会员"}]
  10. ', 'insert', NULL, NULL, NULL);
  11. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'teacher', 'notice', 'object', '', '{"title":"4.3.7 版本发布","content":"快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
  12. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'teacher', 'userStatus', 'array', NULL, '[{"value": "active", "text": "正常"}, {"value": "banned", "text": "禁用"}]', 'insert', NULL, NULL, NULL);
  13. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'teacher', 'userType', 'array', NULL, '[{"value": "common", "text": "普通用户"},{"value": "xiaochengxu", "text": "小程序机器人"}]', 'insert', NULL, NULL, NULL);
  14. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'teacher', 'gender', 'array', NULL, '[{"value": "male", "text": "男"}, {"value": "female", "text": "女"}]', 'insert', NULL, NULL, NULL);
  15. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'teacher', 'version', 'object', NULL, '{"testUserIdList": "","version": "4.3.11", "title": "4.3.7 版本发布", "note": "新版本介绍\n 1. 聊天输入优化", "apkVersion": "5.0.20", "apkLink": "https://duoxing.openjianghu.org/duoxing/upload/10002/1647840662817_956853_D多星MD-4.7.10.apk", "apkNote": "", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "测试桌面客户端升级" }', 'insert', NULL, NULL, NULL);
  16. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, 'teacher', 'emotion', 'array', NULL, '[
  17.   {
  18.     "dir":"face01",
  19.     "cover":"face-lbl",
  20.     "ext":"png",
  21.     "cols":5,
  22.     "total":86
  23.   },
  24.   {
  25.     "dir":"face02",
  26.     "cover":"face-lbl",
  27.     "ext":"gif",
  28.     "cols":2,
  29.     "total":16
  30.   },
  31.   {
  32.     "dir":"face03",
  33.     "cover":"face-lbl",
  34.     "ext":"gif",
  35.     "cols":2,
  36.     "total":16
  37.   },
  38.   {
  39.     "dir":"face04",
  40.     "cover":"face-lbl",
  41.     "ext":"gif",
  42.     "cols":2,
  43.     "total":16
  44.   },
  45.   {
  46.     "dir":"face05",
  47.     "cover":"face-lbl",
  48.     "ext":"gif",
  49.     "cols":1,
  50.     "total":7
  51.   },
  52.   {
  53.     "dir":"face06",
  54.     "cover":"face-lbl",
  55.     "ext":"gif",
  56.     "cols":3,
  57.     "total":24
  58.   },
  59.   {
  60.     "dir":"face07",
  61.     "cover":"face-lbl",
  62.     "ext":"gif",
  63.     "cols":2,
  64.     "total":16
  65.   },
  66.   {
  67.     "dir":"face08",
  68.     "cover":"face-lbl",
  69.     "ext":"gif",
  70.     "cols":3,
  71.     "total":23
  72.   },
  73.   {
  74.     "dir":"face09",
  75.     "cover":"face-lbl",
  76.     "ext":"gif",
  77.     "cols":2,
  78.     "total":16
  79.   },
  80.   {
  81.     "dir":"face10",
  82.     "cover":"face-lbl",
  83.     "ext":"gif",
  84.     "cols":3,
  85.     "total":20
  86.   },
  87.   {
  88.     "dir":"face11",
  89.     "cover":"face-lbl",
  90.     "ext":"gif",
  91.     "cols":2,
  92.     "total":13
  93.   },
  94.   {
  95.     "dir":"face12",
  96.     "cover":"face-lbl",
  97.     "ext":"gif",
  98.     "cols":2,
  99.     "total":16
  100.   },
  101.   {
  102.     "dir":"face13",
  103.     "cover":"face-lbl",
  104.     "ext":"gif",
  105.     "cols":2,
  106.     "total":15
  107.   },
  108.   {
  109.     "dir":"face14",
  110.     "cover":"face-lbl",
  111.     "ext":"gif",
  112.     "cols":2,
  113.     "total":16
  114.   }
  115. ]
  116. ', 'insert', NULL, NULL, NULL);
  117. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacher', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
  118. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'teacher', 'linkList', 'object', '链接列表', '[
  119.     {
  120.     "linkName": "courseCRUD",
  121.     "url": "https://fsapp.eggjs.tech/fs_member-course_v1/page/courseManagement",
  122.         "appId": "fs_member-course_v1",
  123.         "pageId": "courseManagement",
  124.     "params": [
  125.       "courseBatchId",
  126.       "title"
  127.     ]
  128.   }
  129. ]', 'insert', NULL, NULL, NULL);
  130. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teacher', 'articleType', 'array', '文章类型', '[
  131.     {
  132.             "text": "文章",
  133.             "value": "article"
  134.     },
  135.     {
  136.             "text": "作业",
  137.             "value": "assignment"
  138.     },
  139.     {
  140.             "text": "考试",
  141.             "value": "exam"
  142.     },
  143.     {
  144.             "text": "资料",
  145.             "value": "material"
  146.     },
  147.     {
  148.             "text": "新闻",
  149.             "value": "news"
  150.     }
  151. ]', 'insert', NULL, NULL, NULL);
  152. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, 'teacher', 'articlePublishStatus', 'array', '文章发布状态', '[
  153.     {
  154.         "text": "登录可见",
  155.         "value": "login"
  156.     },
  157.     {
  158.         "text": "草稿",
  159.         "value": "draft"
  160.     },
  161.     {
  162.         "text": "回收站",
  163.         "value": "deleted"
  164.     }
  165. ]', 'insert', NULL, NULL, NULL);
  166. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'teacher', 'isDelShowStatus', 'array', '显示状态', '[
  167.     {
  168.             "text": "全部",
  169.             "value": null
  170.     },
  171.     {
  172.             "text": "正常",
  173.             "value": "false"
  174.     },
  175.     {
  176.             "text": "回收站",
  177.             "value": "true"
  178.     }
  179. ]', 'insert', NULL, NULL, NULL);
  180. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'teacher', 'auditStatus', 'array', '审核状态', '[
  181.     {
  182.             "text": "全部",
  183.             "value": null
  184.     },
  185.     {
  186.             "text": "等待中",
  187.             "value": "pending"
  188.     },
  189.     {
  190.             "text": "已通过",
  191.             "value": "approve"
  192.     },
  193.     {
  194.             "text": "已拒绝",
  195.             "value": "reject"
  196.     }
  197. ]', 'insert', NULL, NULL, NULL);
  198. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'teacher', 'memberPrivilegeLevel', 'array', '会员等级', '[{"value":"001","text":"001会员"},{"value":"101","text":"101会员"},{"value":"201","text":"201会员"}]
  199. ', 'insert', NULL, NULL, NULL);
  200. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'student', 'notice', 'object', '', '{"title":"4.3.7 版本发布","content":"快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n快来使用吧！\n测试12123123\n","imageSrc":"/noticeImage/1647076649263_719911_noticeImage.jpeg","isImageShown":false,"isTextShown":true}', 'update', 'admin01', 'admin01', '2022-03-12T17:19:50+08:00');
  201. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'student', 'userStatus', 'array', NULL, '[{"value": "active", "text": "正常"}, {"value": "banned", "text": "禁用"}]', 'insert', NULL, NULL, NULL);
  202. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (24, 'student', 'userType', 'array', NULL, '[{"value": "common", "text": "普通用户"},{"value": "xiaochengxu", "text": "小程序机器人"}]', 'insert', NULL, NULL, NULL);
  203. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (25, 'student', 'gender', 'array', NULL, '[{"value": "male", "text": "男"}, {"value": "female", "text": "女"}]', 'insert', NULL, NULL, NULL);
  204. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (26, 'student', 'version', 'object', NULL, '{"testUserIdList": "admin01","version": "5.0.22", "title": "5.0.19 版本发布", "note": "新版本介绍\n 1. 网页版ui修复", "apkVersion": "5.1.8", "apkLink": "https://nextcloud.openjianghu.org/index.php/s/SyRaPyt9nFbFryX/download/%E6%97%8B%E9%A3%8E5-5.0.20.apk", "apkNote": "新版本介绍\n 1. 网页版ui修复", "desktopVersion": "4.3.2", "desktopLink": "http://192.168.110.215:8082/duoxing/upload/duoxing-1.0.1.dmg.zip", "desktopNote": "测试桌面客户端升级" }', 'insert', NULL, NULL, NULL);
  205. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (27, 'student', 'emotion', 'array', NULL, '[
  206.   {
  207.     "dir":"face01",
  208.     "cover":"face-lbl",
  209.     "ext":"png",
  210.     "cols":5,
  211.     "total":86
  212.   },
  213.   {
  214.     "dir":"face02",
  215.     "cover":"face-lbl",
  216.     "ext":"gif",
  217.     "cols":2,
  218.     "total":16
  219.   },
  220.   {
  221.     "dir":"face03",
  222.     "cover":"face-lbl",
  223.     "ext":"gif",
  224.     "cols":2,
  225.     "total":16
  226.   },
  227.   {
  228.     "dir":"face04",
  229.     "cover":"face-lbl",
  230.     "ext":"gif",
  231.     "cols":2,
  232.     "total":16
  233.   },
  234.   {
  235.     "dir":"face05",
  236.     "cover":"face-lbl",
  237.     "ext":"gif",
  238.     "cols":1,
  239.     "total":7
  240.   },
  241.   {
  242.     "dir":"face06",
  243.     "cover":"face-lbl",
  244.     "ext":"gif",
  245.     "cols":3,
  246.     "total":24
  247.   },
  248.   {
  249.     "dir":"face07",
  250.     "cover":"face-lbl",
  251.     "ext":"gif",
  252.     "cols":2,
  253.     "total":16
  254.   },
  255.   {
  256.     "dir":"face08",
  257.     "cover":"face-lbl",
  258.     "ext":"gif",
  259.     "cols":3,
  260.     "total":23
  261.   },
  262.   {
  263.     "dir":"face09",
  264.     "cover":"face-lbl",
  265.     "ext":"gif",
  266.     "cols":2,
  267.     "total":16
  268.   },
  269.   {
  270.     "dir":"face10",
  271.     "cover":"face-lbl",
  272.     "ext":"gif",
  273.     "cols":3,
  274.     "total":20
  275.   },
  276.   {
  277.     "dir":"face11",
  278.     "cover":"face-lbl",
  279.     "ext":"gif",
  280.     "cols":2,
  281.     "total":13
  282.   },
  283.   {
  284.     "dir":"face12",
  285.     "cover":"face-lbl",
  286.     "ext":"gif",
  287.     "cols":2,
  288.     "total":16
  289.   },
  290.   {
  291.     "dir":"face13",
  292.     "cover":"face-lbl",
  293.     "ext":"gif",
  294.     "cols":2,
  295.     "total":15
  296.   },
  297.   {
  298.     "dir":"face14",
  299.     "cover":"face-lbl",
  300.     "ext":"gif",
  301.     "cols":2,
  302.     "total":16
  303.   }
  304. ]
  305. ', 'insert', NULL, NULL, NULL);
  306. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (28, 'student', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
  307. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (29, 'student', 'share', 'array', NULL, '[{"path":"/upload/image/share/shareImage01.jpg"}]', 'insert', NULL, NULL, NULL);
  308. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (30, 'student', 'orderStatus', 'array', '订单状态', '[{"value":"waitpay","text":"待支付"},{"value":"paid","text":"已支付"},{"value":"refunding","text":"退款中"},{"value":"refunded","text":"已退款"},{"value":"cancel","text":"已取消"},{"value":"waitSend","text":"待发货"},{"value":"waitReceive","text":"待收货"},{"value":"waitComment","text":"待评价"},{"value":"commented","text":"已评价"}]', 'insert', NULL, NULL, NULL);
  309. INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (31, 'student', 'refundStatus', 'array', '退款状态', '[{"value":"unrefund","text":"未退款"},{"value":"applying","text":"退款中"},{"value":"refunded","text":"已退款"}]
  310. ', 'insert', NULL, NULL, NULL);