江湖数字化平台
登录

常量

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 = 5 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = DYNAMIC COMMENT = '常量表; 软删除未启用;'

_constant 表数据

通用权限配置

  • constantKey：commonAuthList

  • constantType：array

  1. [
  2.   {
  3.     "appId": "directory",
  4.     "user": "*",
  5.     "group": "login",
  6.     "role": "*",
  7.     "pageIdList": [
  8.       "directory",
  9.       "changePassword"
  10.     ]
  11.   },
  12.   {
  13.     "appId": "task",
  14.     "user": "*",
  15.     "group": "login",
  16.     "role": "*",
  17.     "pageIdList": [
  18.       "*"
  19.     ]
  20.   },
  21.   {
  22.     "appId": "student_admin",
  23.     "user": "*",
  24.     "group": "login",
  25.     "role": "*",
  26.     "pageIdList": [
  27.       "enrollment",
  28.       "workflowPrintPreview",
  29.       "logisticsAssignment",
  30.       "updatePaymentStatus",
  31.       "classManagement",
  32.       "studentManagementOfOneClass",
  33.       "classManagementOfOneStudent",
  34.       "enrollmentApproved",
  35.       "approvalAcknowledgementPrintPreview",
  36.       "studentUpgrade",
  37.       "quitApproved",
  38.       "studentManagement",
  39.       "quitRequest",
  40.       "changeLevelRequest",
  41.       "approvalChangeLevel",
  42.       "quitAssignment",
  43.       "quitPayment"
  44.     ]
  45.   },
  46.   {
  47.     "appId": "mentor",
  48.     "user": "*",
  49.     "group": "login",
  50.     "role": "*",
  51.     "pageIdList": [
  52.       "studentList",
  53.       "studentNewStructureList",
  54.       "studentContactList",
  55.       "studentEducationBackgroundList",
  56.       "studentFinancialAidList",
  57.       "studentGuardianList",
  58.       "studentHometownList",
  59.       "studentLogisticsList",
  60.       "studentCommentList",
  61.       "appraisalStudentManagementOfOneAppraisal",
  62.       "appraisalView"
  63.     ]
  64.   },
  65.   {
  66.     "appId": "recruitment",
  67.     "user": "*",
  68.     "group": "login",
  69.     "role": "*",
  70.     "pageIdList": [
  71.       "followUpStudent"
  72.     ]
  73.   },
  74.   {
  75.     "appId": "recruitment",
  76.     "user": "*",
  77.     "group": "public",
  78.     "role": "*",
  79.     "pageIdList": [
  80.       "studentRecruitment"
  81.     ]
  82.   },
  83.   {
  84.     "appId": "notice",
  85.     "user": "*",
  86.     "group": "public",
  87.     "role": "*",
  88.     "pageIdList": [
  89.       "bindStudent",
  90.       "messageList",
  91.       "otherBrowser",
  92.       "noticeTemplate/*"
  93.     ]
  94.   },
  95.   {
  96.     "appId": "calendar",
  97.     "user": "*",
  98.     "group": "public",
  99.     "role": "*",
  100.     "pageIdList": [
  101.       "calendarEventView"
  102.     ]
  103.   },
  104.   {
  105.     "appId": "work_order",
  106.     "user": "*",
  107.     "group": "login",
  108.     "role": "*",
  109.     "pageIdList": [
  110.       "workflowEditor",
  111.       "createTask",
  112.       "todo",
  113.       "taskHistory"
  114.     ]
  115.   },
  116.   {
  117.     "appId": "hostel",
  118.     "user": "*",
  119.     "group": "login",
  120.     "role": "*",
  121.     "pageIdList": [
  122.       "studentHostelManagement",
  123.       "studentBedAllocation"
  124.     ]
  125.   },
  126.   {
  127.     "appId": "restaurant",
  128.     "user": "*",
  129.     "group": "public",
  130.     "role": "*",
  131.     "pageIdList": [
  132.       "restaurantManagement",
  133.       "oneBatchStudentAllocation",
  134.       "twoBatchStudentAllocation"
  135.     ]
  136.   },
  137.   {
  138.     "appId": "public_hygiene",
  139.     "user": "*",
  140.     "group": "login",
  141.     "role": "*",
  142.     "pageIdList": [
  143.       "areaView",
  144.       "areaMonth",
  145.       "classMonth"
  146.     ]
  147.   }
  148. ]

临时期限日期

  • constantKey：roleDeadlineItem

  • constantType：array

  1. [
  2.   {
  3.     "value": "0",
  4.     "text": "非公共"
  5.   },
  6.   {
  7.     "value": "1",
  8.     "text": "阳光公寓公共"
  9.   },
  10.   {
  11.     "value": "2",
  12.     "text": "商业中心公共"
  13.   }
  14. ]

待创建的用户列表，每12小时更新一次

  • constantKey：userToBeCreatedList

  • constantType：array

  1. [
  2.   {
  3.     "userid": "ChuBing",
  4.     "name": "储兵",
  5.     "department": [
  6.       223
  7.     ],
  8.     "position": "",
  9.     "status": 1,
  10.     "extattr": {},
  11.     "telephone": "",
  12.     "order": [
  13.       268435456
  14.     ],
  15.     "external_profile": {
  16.       "wechat_channels": {
  17.         "nickname": "风神集团",
  18.         "status": 0
  19.       }
  20.     },
  21.     "main_department": 223,
  22.     "alias": "",
  23.     "is_leader_in_dept": [
  24.       0
  25.     ]
  26.   },
  27.   {
  28.     "userid": "WangXiaoChen",
  29.     "name": "王晓晨",
  30.     "department": [
  31.       81
  32.     ],
  33.     "position": "销售顾问",
  34.     "status": 1,
  35.     "extattr": {},
  36.     "telephone": "",
  37.     "order": [
  38.       0
  39.     ],
  40.     "external_profile": {
  41.       "external_corp_name": "",
  42.       "wechat_channels": {
  43.         "nickname": "风神集团",
  44.         "status": 0
  45.       }
  46.     },
  47.     "main_department": 81,
  48.     "alias": "",
  49.     "is_leader_in_dept": [
  50.       0
  51.     ]
  52.   },
  53.   {
  54.     "userid": "LuoLongFei",
  55.     "name": "罗龙飞",
  56.     "department": [
  57.       76
  58.     ],
  59.     "position": "销售总监",
  60.     "status": 1,
  61.     "extattr": {},
  62.     "telephone": "",
  63.     "order": [
  64.       0
  65.     ],
  66.     "external_profile": {
  67.       "external_corp_name": "",
  68.       "wechat_channels": {
  69.         "nickname": "风神集团",
  70.         "status": 0
  71.       }
  72.     },
  73.     "main_department": 76,
  74.     "alias": "",
  75.     "is_leader_in_dept": [
  76.       0
  77.     ]
  78.   },
  79.   {
  80.     "userid": "QinXiuJun",
  81.     "name": "秦修军",
  82.     "department": [
  83.       16
  84.     ],
  85.     "position": "",
  86.     "status": 1,
  87.     "extattr": {},
  88.     "telephone": "",
  89.     "order": [
  90.       268472320
  91.     ],
  92.     "external_profile": {
  93.       "wechat_channels": {
  94.         "nickname": "风神集团",
  95.         "status": 0
  96.       }
  97.     },
  98.     "main_department": 16,
  99.     "alias": "",
  100.     "is_leader_in_dept": [
  101.       0
  102.     ]
  103.   },
  104.   {
  105.     "userid": "CuiNingDong",
  106.     "name": "崔宁栋",
  107.     "department": [
  108.       16
  109.     ],
  110.     "position": "",
  111.     "status": 1,
  112.     "extattr": {},
  113.     "telephone": "",
  114.     "order": [
  115.       268480512
  116.     ],
  117.     "external_profile": {
  118.       "wechat_channels": {
  119.         "nickname": "风神集团",
  120.         "status": 0
  121.       }
  122.     },
  123.     "main_department": 16,
  124.     "alias": "",
  125.     "is_leader_in_dept": [
  126.       0
  127.     ]
  128.   },
  129.   {
  130.     "userid": "lixingbin",
  131.     "name": "李兴斌",
  132.     "department": [
  133.       216
  134.     ],
  135.     "position": "维修技师",
  136.     "status": 1,
  137.     "extattr": {},
  138.     "telephone": "",
  139.     "order": [
  140.       268439552
  141.     ],
  142.     "external_profile": {
  143.       "external_corp_name": "",
  144.       "wechat_channels": {
  145.         "nickname": "风神集团",
  146.         "status": 0
  147.       }
  148.     },
  149.     "main_department": 216,
  150.     "alias": "",
  151.     "is_leader_in_dept": [
  152.       0
  153.     ]
  154.   },
  155.   {
  156.     "userid": "ZiYuanZhengHeYunYingShang-QiXion",
  157.     "name": "资源整合运营商-齐兄",
  158.     "department": [
  159.       270
  160.     ],
  161.     "position": "",
  162.     "status": 4,
  163.     "extattr": {},
  164.     "telephone": "",
  165.     "order": [
  166.       0
  167.     ],
  168.     "main_department": 270,
  169.     "alias": "",
  170.     "is_leader_in_dept": [
  171.       0
  172.     ]
  173.   },
  174.   {
  175.     "userid": "PanJiaLin",
  176.     "name": "潘嘉林钣喷主管18366562892",
  177.     "department": [
  178.       40
  179.     ],
  180.     "position": "喷漆工",
  181.     "status": 1,
  182.     "extattr": {},
  183.     "telephone": "",
  184.     "order": [
  185.       268484608
  186.     ],
  187.     "external_profile": {
  188.       "external_corp_name": ""
  189.     },
  190.     "main_department": 40,
  191.     "alias": "",
  192.     "is_leader_in_dept": [
  193.       0
  194.     ]
  195.   },
  196.   {
  197.     "userid": "kaleb",
  198.     "name": "伽勒",
  199.     "department": [
  200.       223
  201.     ],
  202.     "position": "",
  203.     "status": 1,
  204.     "extattr": {},
  205.     "telephone": "",
  206.     "order": [
  207.       268480512
  208.     ],
  209.     "external_profile": {
  210.       "external_corp_name": "",
  211.       "wechat_channels": {
  212.         "nickname": "风神集团",
  213.         "status": 0
  214.       }
  215.     },
  216.     "main_department": 223,
  217.     "alias": "",
  218.     "is_leader_in_dept": [
  219.       0
  220.     ]
  221.   },
  222.   {
  223.     "userid": "colin",
  224.     "name": "colin",
  225.     "department": [
  226.       223
  227.     ],
  228.     "position": "",
  229.     "status": 1,
  230.     "extattr": {},
  231.     "telephone": "",
  232.     "order": [
  233.       268439552
  234.     ],
  235.     "external_profile": {
  236.       "external_corp_name": "",
  237.       "wechat_channels": {
  238.         "nickname": "风神集团",
  239.         "status": 0
  240.       }
  241.     },
  242.     "main_department": 223,
  243.     "alias": "",
  244.     "is_leader_in_dept": [
  245.       0
  246.     ]
  247.   },
  248.   {
  249.     "userid": "qujiang",
  250.     "name": "屈江",
  251.     "department": [
  252.       44,
  253.       3
  254.     ],
  255.     "position": "副总裁",
  256.     "status": 1,
  257.     "extattr": {},
  258.     "telephone": "",
  259.     "order": [
  260.       268439552,
  261.       268439552
  262.     ],
  263.     "external_profile": {
  264.       "external_corp_name": "",
  265.       "wechat_channels": {
  266.         "nickname": "风神集团",
  267.         "status": 0
  268.       }
  269.     },
  270.     "main_department": 44,
  271.     "alias": "",
  272.     "is_leader_in_dept": [
  273.       0,
  274.       0
  275.     ]
  276.   },
  277.   {
  278.     "userid": "YinWenXin",
  279.     "name": "尹文鑫",
  280.     "department": [
  281.       81
  282.     ],
  283.     "position": "销售信息员",
  284.     "status": 1,
  285.     "extattr": {},
  286.     "telephone": "",
  287.     "order": [
  288.       0
  289.     ],
  290.     "external_profile": {
  291.       "external_corp_name": "",
  292.       "wechat_channels": {
  293.         "nickname": "风神集团",
  294.         "status": 0
  295.       }
  296.     },
  297.     "main_department": 81,
  298.     "alias": "",
  299.     "is_leader_in_dept": [
  300.       0
  301.     ]
  302.   },
  303.   {
  304.     "userid": "liuwenhui",
  305.     "name": "刘文辉",
  306.     "department": [
  307.       177
  308.     ],
  309.     "position": "主管",
  310.     "status": 4,
  311.     "extattr": {},
  312.     "telephone": "",
  313.     "order": [
  314.       268439552
  315.     ],
  316.     "external_profile": {
  317.       "external_corp_name": "",
  318.       "wechat_channels": {
  319.         "nickname": "风神集团",
  320.         "status": 0
  321.       }
  322.     },
  323.     "main_department": 177,
  324.     "alias": "",
  325.     "is_leader_in_dept": [
  326.       1
  327.     ],
  328.     "direct_leader": [
  329.       "HRAG000041"
  330.     ]
  331.   },
  332.   {
  333.     "userid": "lixinli",
  334.     "name": "李蕊莉",
  335.     "department": [
  336.       171
  337.     ],
  338.     "position": "仓管员",
  339.     "status": 4,
  340.     "extattr": {},
  341.     "telephone": "",
  342.     "order": [
  343.       268439552
  344.     ],
  345.     "external_profile": {
  346.       "external_corp_name": "",
  347.       "wechat_channels": {
  348.         "nickname": "风神集团",
  349.         "status": 0
  350.       }
  351.     },
  352.     "main_department": 171,
  353.     "alias": "",
  354.     "is_leader_in_dept": [
  355.       0
  356.     ],
  357.     "direct_leader": [
  358.       "HRAG000003",
  359.       "HRAG000043"
  360.     ]
  361.   }
  362. ]

_constant语句

  1. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'commonAuthList', 'array', '通用权限配置', '[
  2.         {"appId": "directory","user": "*", "group": "login", "role": "*", "pageIdList": ["directory","changePassword"]},
  3.         {"appId": "task","user": "*", "group": "login", "role": "*", "pageIdList": ["*"]},
  4.         {"appId": "student_admin","user": "*", "group": "login", "role": "*", "pageIdList": ["enrollment","workflowPrintPreview","logisticsAssignment","updatePaymentStatus","classManagement","studentManagementOfOneClass","classManagementOfOneStudent","enrollmentApproved","approvalAcknowledgementPrintPreview","studentUpgrade","quitApproved","studentManagement","quitRequest","changeLevelRequest","approvalChangeLevel","quitAssignment","quitPayment"]},
  5.         {"appId": "mentor","user": "*", "group": "login", "role": "*", "pageIdList": ["studentList","studentNewStructureList","studentContactList","studentEducationBackgroundList","studentFinancialAidList","studentGuardianList","studentHometownList","studentLogisticsList","studentCommentList","appraisalStudentManagementOfOneAppraisal","appraisalView"]},
  6.         {"appId": "recruitment","user": "*", "group": "login", "role": "*", "pageIdList": ["followUpStudent"]},
  7.         {"appId": "recruitment","user": "*", "group": "public", "role": "*", "pageIdList": ["studentRecruitment"]},
  8.         {"appId": "notice","user": "*", "group": "public", "role": "*", "pageIdList": ["bindStudent","messageList","otherBrowser","noticeTemplate/*"]},
  9.         {"appId": "calendar","user": "*", "group": "public", "role": "*", "pageIdList": ["calendarEventView"]},
  10.         {"appId": "work_order","user": "*", "group": "login", "role": "*", "pageIdList": ["workflowEditor","createTask","todo","taskHistory"]},
  11.         {"appId": "hostel","user": "*", "group": "login", "role": "*", "pageIdList": ["studentHostelManagement","studentBedAllocation"]},
  12.         
  13.         {"appId": "restaurant","user": "*", "group": "public", "role": "*", "pageIdList": ["restaurantManagement", "oneBatchStudentAllocation", "twoBatchStudentAllocation"]},
  14.         {"appId": "public_hygiene","user": "*", "group": "login", "role": "*", "pageIdList": ["areaView", "areaMonth", "classMonth"]}
  15. ]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');
  16. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'roleDeadlineItem', 'array', '临时期限日期', '[
  17.     {
  18.         "value": "0",
  19.         "text": "非公共"
  20.     },
  21.     {
  22.         "value": "1",
  23.         "text": "阳光公寓公共"
  24.     },
  25.     {
  26.         "value": "2",
  27.         "text": "商业中心公共"
  28.     }
  29. ]', 'insert', '[{ "text":"7天", "days":7 },{ "text":"14天", "days":14 },{ "text":"30天", "days":30 }]', NULL, NULL);
  30. INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (4, 'userToBeCreatedList', 'array', '待创建的用户列表，每12小时更新一次', '[{"userid":"ChuBing","name":"储兵","department":[223],"position":"","status":1,"extattr":{},"telephone":"","order":[268435456],"external_profile":{"wechat_channels":{"nickname":"风神集团","status":0}},"main_department":223,"alias":"","is_leader_in_dept":[0]},{"userid":"WangXiaoChen","name":"王晓晨","department":[81],"position":"销售顾问","status":1,"extattr":{},"telephone":"","order":[0],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":81,"alias":"","is_leader_in_dept":[0]},{"userid":"LuoLongFei","name":"罗龙飞","department":[76],"position":"销售总监","status":1,"extattr":{},"telephone":"","order":[0],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":76,"alias":"","is_leader_in_dept":[0]},{"userid":"QinXiuJun","name":"秦修军","department":[16],"position":"","status":1,"extattr":{},"telephone":"","order":[268472320],"external_profile":{"wechat_channels":{"nickname":"风神集团","status":0}},"main_department":16,"alias":"","is_leader_in_dept":[0]},{"userid":"CuiNingDong","name":"崔宁栋","department":[16],"position":"","status":1,"extattr":{},"telephone":"","order":[268480512],"external_profile":{"wechat_channels":{"nickname":"风神集团","status":0}},"main_department":16,"alias":"","is_leader_in_dept":[0]},{"userid":"lixingbin","name":"李兴斌","department":[216],"position":"维修技师","status":1,"extattr":{},"telephone":"","order":[268439552],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":216,"alias":"","is_leader_in_dept":[0]},{"userid":"ZiYuanZhengHeYunYingShang-QiXion","name":"资源整合运营商-齐兄","department":[270],"position":"","status":4,"extattr":{},"telephone":"","order":[0],"main_department":270,"alias":"","is_leader_in_dept":[0]},{"userid":"PanJiaLin","name":"潘嘉林钣喷主管18366562892","department":[40],"position":"喷漆工","status":1,"extattr":{},"telephone":"","order":[268484608],"external_profile":{"external_corp_name":""},"main_department":40,"alias":"","is_leader_in_dept":[0]},{"userid":"kaleb","name":"伽勒","department":[223],"position":"","status":1,"extattr":{},"telephone":"","order":[268480512],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":223,"alias":"","is_leader_in_dept":[0]},{"userid":"colin","name":"colin","department":[223],"position":"","status":1,"extattr":{},"telephone":"","order":[268439552],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":223,"alias":"","is_leader_in_dept":[0]},{"userid":"qujiang","name":"屈江","department":[44,3],"position":"副总裁","status":1,"extattr":{},"telephone":"","order":[268439552,268439552],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":44,"alias":"","is_leader_in_dept":[0,0]},{"userid":"YinWenXin","name":"尹文鑫","department":[81],"position":"销售信息员","status":1,"extattr":{},"telephone":"","order":[0],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":81,"alias":"","is_leader_in_dept":[0]},{"userid":"liuwenhui","name":"刘文辉","department":[177],"position":"主管","status":4,"extattr":{},"telephone":"","order":[268439552],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":177,"alias":"","is_leader_in_dept":[1],"direct_leader":["HRAG000041"]},{"userid":"lixinli","name":"李蕊莉","department":[171],"position":"仓管员","status":4,"extattr":{},"telephone":"","order":[268439552],"external_profile":{"external_corp_name":"","wechat_channels":{"nickname":"风神集团","status":0}},"main_department":171,"alias":"","is_leader_in_dept":[0],"direct_leader":["HRAG000003","HRAG000043"]}]', 'update', 'F00998', '李世钦', '2024-03-13T09:15:50+08:00');