江湖数字化平台
登录

常量

12114

常量总览

_constant结构

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

_constant 表数据

区域列表

  • constantKey：areaList

  • constantType：array

  1. [
  2.   {
  3.     "areaId": "小学-1",
  4.     "areaName": "求实楼空地"
  5.   },
  6.   {
  7.     "areaId": "小学-2",
  8.     "areaName": "静志居后面靠饭堂的草坪"
  9.   },
  10.   {
  11.     "areaId": "初中-1",
  12.     "areaName": "求实楼A栋后方停车场及四周草坪门卫室与接待室沥青路面"
  13.   },
  14.   {
  15.     "areaId": "初中-2",
  16.     "areaName": "国旗下四周空地"
  17.   },
  18.   {
  19.     "areaId": "初中-3",
  20.     "areaName": "孔子像正前方两块草坪及中间和两边空地"
  21.   },
  22.   {
  23.     "areaId": "初中-4",
  24.     "areaName": "孔子像后方两块草坪及中间和两边空地"
  25.   },
  26.   {
  27.     "areaId": "初中-5",
  28.     "areaName": "名人广场"
  29.   },
  30.   {
  31.     "areaId": "初中-6",
  32.     "areaName": "才艺楼前空地及两侧草坪和沥青路面"
  33.   },
  34.   {
  35.     "areaId": "初中-7",
  36.     "areaName": "静志居至清朗居西侧两块草坪区域及中间过道"
  37.   },
  38.   {
  39.     "areaId": "初中-8",
  40.     "areaName": "求实楼A、B栋西侧两块草坪及中间过道"
  41.   },
  42.   {
  43.     "areaId": "初中-9",
  44.     "areaName": "静志居与景和居中间乒乓球空地及两侧草坪"
  45.   },
  46.   {
  47.     "areaId": "初中-10",
  48.     "areaName": "景和居与清朗居中间乒乓球空地及两侧草坪"
  49.   },
  50.   {
  51.     "areaId": "初中-11",
  52.     "areaName": "清朗居与求实楼B栋中间乒乓球空地及两侧草坪"
  53.   },
  54.   {
  55.     "areaId": "初中-12",
  56.     "areaName": "静志居至求实楼B栋连廊"
  57.   },
  58.   {
  59.     "areaId": "初中-13",
  60.     "areaName": "求实楼A、B栋靠国旗方向1-5楼楼梯间"
  61.   },
  62.   {
  63.     "areaId": "初中-14",
  64.     "areaName": "求实楼A、B栋中间楼道1-5楼楼梯间"
  65.   },
  66.   {
  67.     "areaId": "初中-15",
  68.     "areaName": "静志居与景和居（足球场一侧）沥青路面及两块草坪"
  69.   },
  70.   {
  71.     "areaId": "初中-16",
  72.     "areaName": "清朗居与求实楼B栋（篮球场一侧)沥青路面及两块草坪"
  73.   },
  74.   {
  75.     "areaId": "初中-17",
  76.     "areaName": "1号篮球场及球场入口处两块草坪和中间过道"
  77.   },
  78.   {
  79.     "areaId": "初中-18",
  80.     "areaName": "2、 3、4号篮球场"
  81.   },
  82.   {
  83.     "areaId": "高中-1",
  84.     "areaName": "创新楼A南面草坪至沥青路"
  85.   },
  86.   {
  87.     "areaId": "高中-2",
  88.     "areaName": "创新楼A、B东面草坪"
  89.   },
  90.   {
  91.     "areaId": "高中-3",
  92.     "areaName": "创新楼一楼空地（东）、草坪及出口通道"
  93.   },
  94.   {
  95.     "areaId": "高中-4",
  96.     "areaName": "创新楼一楼空地（西）、草坪"
  97.   },
  98.   {
  99.     "areaId": "高中-5",
  100.     "areaName": "创新楼A栋楼梯1-5楼含楼梯间"
  101.   },
  102.   {
  103.     "areaId": "高中-6",
  104.     "areaName": "创新楼B栋楼梯1-5楼含楼梯间"
  105.   },
  106.   {
  107.     "areaId": "高中-7",
  108.     "areaName": "创新楼中间楼梯1-5楼含楼梯间及楼梯口"
  109.   },
  110.   {
  111.     "areaId": "高中-8",
  112.     "areaName": "接待室、校大门空地"
  113.   },
  114.   {
  115.     "areaId": "高中-9",
  116.     "areaName": "茂松居、修竹居东面草坪"
  117.   },
  118.   {
  119.     "areaId": "高中-10",
  120.     "areaName": "创新楼B栋楼下通道至连廊①"
  121.   },
  122.   {
  123.     "areaId": "高中-11",
  124.     "areaName": "篮球场及两边草坪"
  125.   },
  126.   {
  127.     "areaId": "高中-12",
  128.     "areaName": "茂松居楼下通道至连廊②"
  129.   },
  130.   {
  131.     "areaId": "高中-13",
  132.     "areaName": "茂松居与修竹居之间空地及草坪"
  133.   },
  134.   {
  135.     "areaId": "高中-14",
  136.     "areaName": "修竹居楼下通道至兰蕙居A楼下通道"
  137.   },
  138.   {
  139.     "areaId": "高中-15",
  140.     "areaName": "修竹居、兰意居A楼之间沥青路及草坪"
  141.   },
  142.   {
  143.     "areaId": "高中-16",
  144.     "areaName": "兰意居A、B栋东面的草坪"
  145.   },
  146.   {
  147.     "areaId": "高中-17",
  148.     "areaName": "兰意居A、B栋东面沥青路至才艺楼西边草坪"
  149.   },
  150.   {
  151.     "areaId": "高中-18",
  152.     "areaName": "兰意居中间的空地及草坪"
  153.   },
  154.   {
  155.     "areaId": "高中-19",
  156.     "areaName": "兰意居B栋北南的空地及草坪"
  157.   },
  158.   {
  159.     "areaId": "高中-20",
  160.     "areaName": "兰意居西面的空地至自行车棚及草坪"
  161.   },
  162.   {
  163.     "areaId": "高中-21",
  164.     "areaName": "修竹居西面的空地至自行车棚及草坪"
  165.   },
  166.   {
  167.     "areaId": "高中-22",
  168.     "areaName": "茂松居西面的空地至自行车棚及草坪"
  169.   },
  170.   {
  171.     "areaId": "高中-23",
  172.     "areaName": "创新楼西面的空地至自行车棚及草坪"
  173.   },
  174.   {
  175.     "areaId": "高中-24",
  176.     "areaName": "创新楼南面的停车场至围墙"
  177.   }
  178. ]

区域列表

  • constantKey：areaConfig

  • constantType：array

  1. [
  2.   {
  3.     "userIdList": [
  4.       "admin"
  5.     ],
  6.     "areaIdList": [
  7.       "初中-6"
  8.     ],
  9.     "classId": "2024-春季-07-01"
  10.   },
  11.   {
  12.     "userIdList": [
  13.       "admin"
  14.     ],
  15.     "areaIdList": [
  16.       "初中-1"
  17.     ],
  18.     "classId": "2024-春季-07-02"
  19.   }
  20. ]

学部列表

  • constantKey：segment

  • constantType：array

  1. [
  2.   {
  3.     "value": "小学",
  4.     "text": "小学"
  5.   },
  6.   {
  7.     "value": "初中",
  8.     "text": "初中"
  9.   },
  10.   {
  11.     "value": "高中",
  12.     "text": "高中"
  13.   }
  14. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'areaList', 'array', '区域列表', '[
  2.     {"areaId":"小学-1","areaName":"求实楼空地"},
  3.     {"areaId":"小学-2","areaName":"静志居后面靠饭堂的草坪"},
  4.     {"areaId":"初中-1","areaName":"求实楼A栋后方停车场及四周草坪门卫室与接待室沥青路面"},
  5.     {"areaId":"初中-2","areaName":"国旗下四周空地"},
  6.     {"areaId":"初中-3","areaName":"孔子像正前方两块草坪及中间和两边空地"},
  7.     {"areaId":"初中-4","areaName":"孔子像后方两块草坪及中间和两边空地"},
  8.     {"areaId":"初中-5","areaName":"名人广场"},
  9.     {"areaId":"初中-6","areaName":"才艺楼前空地及两侧草坪和沥青路面"},
  10.     {"areaId":"初中-7","areaName":"静志居至清朗居西侧两块草坪区域及中间过道"},
  11.     {"areaId":"初中-8","areaName":"求实楼A、B栋西侧两块草坪及中间过道"},
  12.     {"areaId":"初中-9","areaName":"静志居与景和居中间乒乓球空地及两侧草坪"},
  13.     {"areaId":"初中-10","areaName":"景和居与清朗居中间乒乓球空地及两侧草坪"},
  14.     {"areaId":"初中-11","areaName":"清朗居与求实楼B栋中间乒乓球空地及两侧草坪"},
  15.     {"areaId":"初中-12","areaName":"静志居至求实楼B栋连廊"},
  16.     {"areaId":"初中-13","areaName":"求实楼A、B栋靠国旗方向1-5楼楼梯间"},
  17.     {"areaId":"初中-14","areaName":"求实楼A、B栋中间楼道1-5楼楼梯间"},
  18.     {"areaId":"初中-15","areaName":"静志居与景和居（足球场一侧）沥青路面及两块草坪"},
  19.     {"areaId":"初中-16","areaName":"清朗居与求实楼B栋（篮球场一侧)沥青路面及两块草坪"},
  20.     {"areaId":"初中-17","areaName":"1号篮球场及球场入口处两块草坪和中间过道"},
  21.     {"areaId":"初中-18","areaName":"2、 3、4号篮球场"},
  22.     {"areaId":"高中-1","areaName":"创新楼A南面草坪至沥青路"},
  23.     {"areaId":"高中-2","areaName":"创新楼A、B东面草坪"},
  24.     {"areaId":"高中-3","areaName":"创新楼一楼空地（东）、草坪及出口通道"},
  25.     {"areaId":"高中-4","areaName":"创新楼一楼空地（西）、草坪"},
  26.     {"areaId":"高中-5","areaName":"创新楼A栋楼梯1-5楼含楼梯间"},
  27.     {"areaId":"高中-6","areaName":"创新楼B栋楼梯1-5楼含楼梯间"},
  28.     {"areaId":"高中-7","areaName":"创新楼中间楼梯1-5楼含楼梯间及楼梯口"},
  29.     {"areaId":"高中-8","areaName":"接待室、校大门空地"},
  30.     {"areaId":"高中-9","areaName":"茂松居、修竹居东面草坪"},
  31.     {"areaId":"高中-10","areaName":"创新楼B栋楼下通道至连廊①"},
  32.     {"areaId":"高中-11","areaName":"篮球场及两边草坪"},
  33.     {"areaId":"高中-12","areaName":"茂松居楼下通道至连廊②"},
  34.     {"areaId":"高中-13","areaName":"茂松居与修竹居之间空地及草坪"},
  35.     {"areaId":"高中-14","areaName":"修竹居楼下通道至兰蕙居A楼下通道"},
  36.     {"areaId":"高中-15","areaName":"修竹居、兰意居A楼之间沥青路及草坪"},
  37.     {"areaId":"高中-16","areaName":"兰意居A、B栋东面的草坪"},
  38.     {"areaId":"高中-17","areaName":"兰意居A、B栋东面沥青路至才艺楼西边草坪"},
  39.     {"areaId":"高中-18","areaName":"兰意居中间的空地及草坪"},
  40.     {"areaId":"高中-19","areaName":"兰意居B栋北南的空地及草坪"},
  41.     {"areaId":"高中-20","areaName":"兰意居西面的空地至自行车棚及草坪"},
  42.     {"areaId":"高中-21","areaName":"修竹居西面的空地至自行车棚及草坪"},
  43.     {"areaId":"高中-22","areaName":"茂松居西面的空地至自行车棚及草坪"},
  44.     {"areaId":"高中-23","areaName":"创新楼西面的空地至自行车棚及草坪"},
  45.     {"areaId":"高中-24","areaName":"创新楼南面的停车场至围墙"}
  46. ]', 'jhUpdate', 'admin', '超级管理员', '2024-01-25T13:31:20+08:00');
  47. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'areaConfig', 'array', '区域列表', '[{"userIdList":["admin"],"areaIdList":["初中-6"],"classId":"2024-春季-07-01"},{"userIdList":["admin"],"areaIdList":["初中-1"],"classId":"2024-春季-07-02"}]', 'jhUpdate', 'admin', '系统管理员', '2024-03-06T16:10:27+08:00');
  48. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'segment', 'array', '学部列表', '[{"value":"小学","text":"小学"},{"value": "初中","text": "初中"},{"value": "高中","text": "高中"}]', 'insert', NULL, NULL, NULL);