常量

12123

常量总览

_constant结构

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

_constant 表数据

链接列表

constantKey	constantType
linkList	object

[
  {
    "linkName": "courseCRUD",
    "url": "https://app.eggjs.tech/md_cgg-member-course_v3/page/courseManagement",
    "appId": "md_cgg-member-course_v3",
    "pageId": "courseManagement",
    "params": [
      "courseBatchId",
      "title"
    ]
  }
]

牧区列表

constantKey	constantType
districtList	array

[
  "JH",
  "AB",
  "CD",
  "EF"
]

同步学生毕业记录的参数

constantKey	constantType
completeCourseRecordSyncParams	object

{
  "maxId": 18,
  "maxCreateAt": "2023-05-27T21:06:06+08:00"
}

学生毕业记录允许撤销的小时数

constantKey	constantType
completeCourseRecordGraceHour	int

0

学生毕业记录的过期小时数

constantKey	constantType
completeCourseRecordExpiryTimeRange	object

{
  "type": "month",
  "value": 6
}

notice

constantKey	constantType
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
}

userStatus

constantKey	constantType
userStatus	array

[
  {
    "value": "active",
    "text": "正常"
  },
  {
    "value": "banned",
    "text": "禁用"
  }
]

userType

constantKey	constantType
userType	array

[
  {
    "value": "common",
    "text": "普通用户"
  },
  {
    "value": "xiaochengxu",
    "text": "小程序机器人"
  }
]

gender

constantKey	constantType
gender	array

[
  {
    "value": "male",
    "text": "男"
  },
  {
    "value": "female",
    "text": "女"
  }
]

version

constantKey	constantType
version	object

{
  "testUserIdList": "",
  "version": "1.0.24",
  "title": "1.0.24 版本发布",
  "note": "新版本介绍\n 1. bug修复",
  "apkVersion": "1.0.5",
  "apkLink": "https://directory.eggjs.tech/directory/public/暴风-1.0.5.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": "测试桌面客户端升级"
}

emotion

constantKey	constantType
emotion	array

[
  {
    "dir": "face01",
    "cover": "face-lbl",
    "ext": "png",
    "cols": 5,
    "total": 86
  },
  {
    "dir": "face02",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face03",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face04",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face05",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 1,
    "total": 7
  },
  {
    "dir": "face06",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 24
  },
  {
    "dir": "face07",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face08",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 23
  },
  {
    "dir": "face09",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face10",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 20
  },
  {
    "dir": "face11",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 13
  },
  {
    "dir": "face12",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face13",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 15
  },
  {
    "dir": "face14",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  }
]

appLinkActionConfig

constantKey	constantType
appLinkActionConfig	array

[
  {
    "regex": ".openjianghu.org/*",
    "action": "internal"
  },
  {
    "regex": "http://192.168./*",
    "action": "internal"
  }
]

share

constantKey	constantType
share	array

[
  {
    "path": "/upload/image/share/shareImage01.jpg"
  }
]

notice

constantKey	constantType
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
}

userStatus

constantKey	constantType
userStatus	array

[
  {
    "value": "active",
    "text": "正常"
  },
  {
    "value": "banned",
    "text": "禁用"
  }
]

userType

constantKey	constantType
userType	array

[
  {
    "value": "common",
    "text": "普通用户"
  },
  {
    "value": "xiaochengxu",
    "text": "小程序机器人"
  }
]

gender

constantKey	constantType
gender	array

[
  {
    "value": "male",
    "text": "男"
  },
  {
    "value": "female",
    "text": "女"
  }
]

version

constantKey	constantType
version	object

{
  "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": "测试桌面客户端升级"
}

emotion

constantKey	constantType
emotion	array

[
  {
    "dir": "face01",
    "cover": "face-lbl",
    "ext": "png",
    "cols": 5,
    "total": 86
  },
  {
    "dir": "face02",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face03",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face04",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face05",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 1,
    "total": 7
  },
  {
    "dir": "face06",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 24
  },
  {
    "dir": "face07",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face08",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 23
  },
  {
    "dir": "face09",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face10",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 3,
    "total": 20
  },
  {
    "dir": "face11",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 13
  },
  {
    "dir": "face12",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  },
  {
    "dir": "face13",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 15
  },
  {
    "dir": "face14",
    "cover": "face-lbl",
    "ext": "gif",
    "cols": 2,
    "total": 16
  }
]

appLinkActionConfig

constantKey	constantType
appLinkActionConfig	array

[
  {
    "regex": ".openjianghu.org/*",
    "action": "internal"
  },
  {
    "regex": "http://192.168./*",
    "action": "internal"
  }
]

同步学生毕业记录的参数

constantKey	constantType
completeCourseRecordSyncParams	object

{
  "maxId": 0,
  "maxCreateAt": ""
}

学生毕业记录允许撤销的小时数

constantKey	constantType
completeCourseRecordGraceHour	int

0

学生毕业记录的过期小时数

constantKey	constantType
completeCourseRecordExpiryTimeRange	object

{
  "type": "month",
  "value": 6
}

_constant语句

INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'course_mgmt', 'linkList', 'object', '链接列表', '[
    {
    "linkName": "courseCRUD",
    "url": "https://app.eggjs.tech/md_cgg-member-course_v3/page/courseManagement",
        "appId": "md_cgg-member-course_v3",
        "pageId": "courseManagement",
    "params": [
      "courseBatchId",
      "title"
    ]
  }
]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'sys_admin', 'districtList', 'array', '牧区列表', '
["JH","AB","CD","EF"]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'sys_admin', 'completeCourseRecordSyncParams', 'object', '同步学生毕业记录的参数', '{"maxId":18,"maxCreateAt":"2023-05-27T21:06:06+08:00"}', 'update', NULL, NULL, '2023-06-04T15:40:46+08:00');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'sys_admin', 'completeCourseRecordGraceHour', 'int', '学生毕业记录允许撤销的小时数', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (5, 'sys_admin', 'completeCourseRecordExpiryTimeRange', 'object', '学生毕业记录的过期小时数', '{"type":"month","value":6}', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (6, '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');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (7, 'student', 'userStatus', 'array', NULL, '[{"value": "active", "text": "正常"}, {"value": "banned", "text": "禁用"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (8, 'student', 'userType', 'array', NULL, '[{"value": "common", "text": "普通用户"},{"value": "xiaochengxu", "text": "小程序机器人"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (9, 'student', 'gender', 'array', NULL, '[{"value": "male", "text": "男"}, {"value": "female", "text": "女"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (10, 'student', 'version', 'object', NULL, '{
    "testUserIdList": "",
    "version": "1.0.24",
    "title": "1.0.24 版本发布",
    "note": "新版本介绍\n 1. bug修复",
    "apkVersion": "1.0.5",
    "apkLink": "https://directory.eggjs.tech/directory/public/暴风-1.0.5.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);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (11, 'student', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (12, 'student', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (13, 'student', 'share', 'array', NULL, '[{"path":"/upload/image/share/shareImage01.jpg"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (14, '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');
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (15, 'teacher', 'userStatus', 'array', NULL, '[{"value": "active", "text": "正常"}, {"value": "banned", "text": "禁用"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (16, 'teacher', 'userType', 'array', NULL, '[{"value": "common", "text": "普通用户"},{"value": "xiaochengxu", "text": "小程序机器人"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (17, 'teacher', 'gender', 'array', NULL, '[{"value": "male", "text": "男"}, {"value": "female", "text": "女"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (18, '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);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (19, 'teacher', 'emotion', 'array', NULL, '[
  {
    "dir":"face01",
    "cover":"face-lbl",
    "ext":"png",
    "cols":5,
    "total":86
  },
  {
    "dir":"face02",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face03",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face04",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face05",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":1,
    "total":7
  },
  {
    "dir":"face06",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":24
  },
  {
    "dir":"face07",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face08",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":23
  },
  {
    "dir":"face09",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face10",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":3,
    "total":20
  },
  {
    "dir":"face11",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":13
  },
  {
    "dir":"face12",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  },
  {
    "dir":"face13",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":15
  },
  {
    "dir":"face14",
    "cover":"face-lbl",
    "ext":"gif",
    "cols":2,
    "total":16
  }
]
', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (20, 'teacher', 'appLinkActionConfig', 'array', NULL, '[{"regex":".openjianghu.org\/*", "action": "internal"}, {"regex":"http:\/\/192.168.\/*", "action": "internal"}]', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (21, 'teacher', 'completeCourseRecordSyncParams', 'object', '同步学生毕业记录的参数', '{"maxId":0, "maxCreateAt":""}', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (22, 'teacher', 'completeCourseRecordGraceHour', 'int', '学生毕业记录允许撤销的小时数', '0', 'insert', NULL, NULL, NULL);
INSERT INTO _constant (id, jhId, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (23, 'teacher', 'completeCourseRecordExpiryTimeRange', 'object', '学生毕业记录的过期小时数', '{"type":"month","value":6}', 'insert', NULL, NULL, NULL);