/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : localhost:3306
 Source Schema         : awards

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 25/09/2024 15:06:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for application
-- ----------------------------
DROP TABLE IF EXISTS `application`;
CREATE TABLE `application`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NULL DEFAULT NULL,
  `studentname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `studentid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `contact` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `politics` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `profession` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `studentclass` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `averagescores` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `post` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `applicationawards` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `approvalstatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `createtime` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `pkid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `director` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `studentnumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `evaluate` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `evaluatetitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `workflownumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程节点号，对应wf表的number',
  `numberofedits` int(11) NULL DEFAULT NULL COMMENT '被退回剩余编辑次数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of application
-- ----------------------------
INSERT INTO `application` VALUES (16, 3, NULL, NULL, NULL, NULL, NULL, NULL, '信息学院', '计算机科学与技术', '计本17-1班', NULL, NULL, '校级二等奖学金、院级先进集体', '6', '2022-10-28 16:49:24', 'organization', '20221028164924797', '郭强、刘宇', '6676', '<p>总之就是牛批</p>', NULL, '6', 1);
INSERT INTO `application` VALUES (17, 3, NULL, NULL, NULL, NULL, NULL, NULL, '信息学院', '计算机科学与技术', '计本17-1班', NULL, NULL, '校级二等奖学金、院级先进集体、校级先进集体', '6', '2022-10-28 16:52:00', 'organization', '20221028165200702', '郭强、刘宇', '66', '<p>球球，让我过了吧</p>', NULL, '10', 0);
INSERT INTO `application` VALUES (18, 3, NULL, NULL, NULL, NULL, NULL, NULL, '信息学院', '计算机科学与技术', '计本17-1班', NULL, NULL, '校级级先进集体，校级一等奖、院级先进集体', '7', '2022-10-28 17:14:25', 'organization', '20221028171425163', '郭强、刘宇', '88', '<p>让我们过了吧</p>', NULL, '8', 0);
INSERT INTO `application` VALUES (19, 3, NULL, NULL, NULL, NULL, NULL, NULL, '信息学院', '计算机科学与技术', '计本17-1班', NULL, NULL, '校级二等奖学金、院级先进集体', '7', '2022-10-28 17:16:53', 'organization', '20221028171653581', '郭强、刘宇', '6676', '<p>反反复复申请</p>', NULL, '10', 0);
INSERT INTO `application` VALUES (21, 4, NULL, NULL, NULL, NULL, NULL, NULL, '信息学院', '计算机科学与技术', '计本17-1班', NULL, NULL, '校级二等奖学金、院级先进集体', '6', '2022-11-27 22:05:37', 'organization', '20221127220537554', '郭强、刘宇', '6676', '<p>我命由我不由天</p>', NULL, '10', 0);
INSERT INTO `application` VALUES (22, 13, NULL, NULL, NULL, NULL, NULL, NULL, '艺术学院', '音乐学', '音乐1班', NULL, NULL, '院级先进集体', '2', '2022-11-27 22:08:06', 'organization', '20221127220806088', '6545656', '6676', '<p>DVDSV电视边框局部SV会计师报VS看看</p>', NULL, '2', 1);
INSERT INTO `application` VALUES (23, 15, '牛七', '7273762382', '1912727472', '1', '汉族', '1', '艺术学院', '音乐表演', '表演1班', '90', '组织委员，院学生会秘书处副部长', '校级二等奖学金', '2', '2022-11-30 16:43:14', 'individual', '20221130164314078', NULL, NULL, NULL, NULL, '2', 1);

-- ----------------------------
-- Table structure for dict
-- ----------------------------
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `dictname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of dict
-- ----------------------------
INSERT INTO `dict` VALUES (1, 'approvalstatus', '1', '编辑', '0');
INSERT INTO `dict` VALUES (2, 'approvalstatus', '2', '提交', '0');
INSERT INTO `dict` VALUES (3, 'approvalstatus', '3', '初审审批中', '0');
INSERT INTO `dict` VALUES (4, 'approvalstatus', '0', '初审驳回', '0');
INSERT INTO `dict` VALUES (5, 'approvalstatus', '4', '初审通过', '0');
INSERT INTO `dict` VALUES (6, 'approvalstatus', '5', '终审审批中', '0');
INSERT INTO `dict` VALUES (7, 'approvalstatus', '6', '终审通过', '0');
INSERT INTO `dict` VALUES (8, 'approvalstatus', '7', '终审不通过', '0');

-- ----------------------------
-- Table structure for fakecode
-- ----------------------------
DROP TABLE IF EXISTS `fakecode`;
CREATE TABLE `fakecode`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of fakecode
-- ----------------------------
INSERT INTO `fakecode` VALUES (1, 1, '1000');
INSERT INTO `fakecode` VALUES (2, 1, '3000');
INSERT INTO `fakecode` VALUES (3, 1, '5000');
INSERT INTO `fakecode` VALUES (4, 2, '2000');
INSERT INTO `fakecode` VALUES (5, 2, '4000');
INSERT INTO `fakecode` VALUES (6, 2, '6000');
INSERT INTO `fakecode` VALUES (7, 3, '2000');
INSERT INTO `fakecode` VALUES (8, 3, '4000');
INSERT INTO `fakecode` VALUES (9, 3, '6000');
INSERT INTO `fakecode` VALUES (10, 4, '2000');
INSERT INTO `fakecode` VALUES (12, 10, '2000');
INSERT INTO `fakecode` VALUES (13, 11, '2000');
INSERT INTO `fakecode` VALUES (14, 12, '2000');
INSERT INTO `fakecode` VALUES (15, 13, '2000');
INSERT INTO `fakecode` VALUES (16, 14, '2000');
INSERT INTO `fakecode` VALUES (17, 15, '2000');

-- ----------------------------
-- Table structure for honors
-- ----------------------------
DROP TABLE IF EXISTS `honors`;
CREATE TABLE `honors`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pkid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of honors
-- ----------------------------
INSERT INTO `honors` VALUES (31, '20221028164924797', '机器人大赛一等奖', '校级', '2022');
INSERT INTO `honors` VALUES (34, '20221028165200702', '机器人大赛一等奖', '校级', '2022');
INSERT INTO `honors` VALUES (35, '20221028165200702', '篮球大赛第一名', '校级', '2021');
INSERT INTO `honors` VALUES (37, '20221028171425163', '英语大赛一等奖', '国赛', '2019');
INSERT INTO `honors` VALUES (39, '20221028171653581', '英语大赛一等奖', '国赛', '2019');
INSERT INTO `honors` VALUES (42, '20221127220806088', '未启翁群', '电动车第三次', '存的是');
INSERT INTO `honors` VALUES (43, '20221127220537554', '未启翁群', '电动车第三次', '存的是');
INSERT INTO `honors` VALUES (44, '20221130164314078', '装逼大赛', '宇宙一等奖', '2022');

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  `readid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `creater` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `createtime` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `istop` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tstime` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tsuser` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `dr` int(255) NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (2, '内容为:## 红绿灯倒计时\n\n### 1、实现效果\n\n绿(35秒)→黄(5秒)→红(30秒)→绿(35秒)…依次循环\n\n### 2、代码分析\n\n首先编写html代码要用到盒子模型，还要用css来布置盒子模型的样式。其次编写JavaScript代码，先创建红、黄、绿灯对象，保存相关数据，设置信号背景灯样式。然后创建倒计时对象，实现倒计时的时间设置。初始化页面，根据lamp对象和count对象分别获取并设置绿灯亮时的页面初始化。实现红绿灯倒计时，利用setInterval()函数完成信号灯倒计时的动态改变效果。\n\n### 3、代码实现\n\n#### 3.1 编写HTML代码\n\n```html\n<body>\n    \n<p id=\"\" style=\"font-family: cursive;\n    font-style: oblique;\n    color: papayawhip;\">\n@Description: 红绿灯小程序\n @Author: 姜锦昊及其家人 \n @Date: 2021/11/21\n @Version:v1.0\n </p>\n <p id=\"\" style=\"margin-top:100px;\"></p>\n \n      <div class=\"box\">\n		  <div id=\"red\"></div>   <!-- 红灯 -->\n		  <div id=\"yellow\"></div>  <!--黄灯 -->\n		  <div id=\"green\"></div>   <!-- 绿灯 -->\n		  <div class=\"count\" id=\"count\"></div>  <!-- 倒计时 -->\n      </div>\n	\n	<p id=\"\"></p>\n	<!-- 当前状态的红绿灯的秒数 -->\n	<span style=\"background:red\"> 红灯：</span><span style=\"color:red\" id=\"hd\">15</span><span style=\"color:red\">秒  |</span>\n	<span style=\"background:yellow\"> 黄灯：</span><span  id=\"h_d\">1</span><span >秒  |</span>\n	<span style=\"background:green\"> 绿灯：</span><span style=\"color:green\" id=\"ld\">2</span><span style=\"color:green\" >秒  |</span>\n	\n	<p id=\"\"></p>\n	\n	<p id=\"\" style=\"\n	font-size: 10px;\n    color: cornsilk;\n    font-style: oblique;\n    font-family: cursive;\">\n	<-------------------------可输入红黄绿灯的时间进行修改------------------------>\n	</p>\n	\n	<form action=\"\" id=\"sub1\" method=\"post\" onsubmit=\"return false\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;border-color:red\" type=\"text\" name=\"red1\" id=\"red1\"  placeholder=\"红灯(秒)\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;background:yellow\" type=\"text\" name=\"yellow1\" id=\"yellow1\" placeholder=\"黄灯(秒)\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;border-color:green\" type=\"text\" name=\"green1\" id=\"green1\" placeholder=\"绿灯(秒)\">\n		<input id=\"in4\" class=\"button\"  type=\"submit\" onclick=\"my_function()\" value=\"修改\"></input>     <!-- 点击按钮则执行my_function函数，进行秒数更新 -->\n	</form>\n```\n\n#### 3.2 编写盒子模型样式\n\n两种样式编写均可实现\n\n```html\n<style>\n		body{\n		text-align:center;\n		background:darkgray;\n		background-repeat:no-repeat ;background-size:100% 100%;\n		background-attachment: fixed;\n		margin-top: 25px;\n	}\n\n    .box{ width:290px;height:70px;border-radius:10px;border:9px solid black;background: rgb(31 30 48 / 58%);padding: 5px;margin: 0 auto;margin-top: 25px;}\n    .box .count{width: 60px;border: 0px;font-size: 280%;color: white}\n    .box div{float:left;margin-left:20px;width:45px;height: 45px;border-radius: 45px;border:1px solid purple;margin-top: 10px;}\n    .gray{background-color:#eee;}\n    .red{\n	background-color:red;\n        box-shadow: \n          1px 0 15px 0 rgb(247, 78, 26), /* 红灯光影 */\n          1px 0 15px 0 transparent\n		  }\n    .yellow{\n	background-color:yellow;\n	box-shadow: \n          1px 0 15px 0 rgb(231, 183, 78), /* 黄灯光影 */\n          1px 0 15px 0 transparent\n		  }\n    .green{\n	background-color:#26ff00;\n	box-shadow: \n	1px 0 15px 0 rgb(38, 175, 84), /* 绿灯光影 */\n          1px 0 15px 0 transparent\n	}\n	.in1{\n	border-radius:10px;\n	background: rgb(13 13 27 / 72%);\n	}\n	.button {\n    background-color: #e7e7e7; color: black;\n    border: none;\n    color: black;\n    padding: 8px 22px;\n    text-align: center;\n    text-decoration: none;\n    display: inline-block;\n    font-size: 14px;\n	border-radius:10px;\n}\n```\n\n#### 3.3 创建红绿灯对象\n\n```js\nvar lamp = {\n        red: { //红灯相关数据\n          obj: document.getElementById(\'red\'),\n          timeout: parseInt(document.getElementById(\"hd\").innerHTML),//获取对应的秒数，或者被更新的秒数\n          style: [\'red\', \'gray\', \'gray\'],\n          next: \'green\'\n        },\n        yellow: {  //黄灯相关数据\n          obj: document.getElementById(\'yellow\'),\n          timeout: parseInt(document.getElementById(\"h_d\").innerHTML),\n          style: [\'gray\', \'yellow\', \'gray\'],\n          next: \'red\'\n        },\n        green: {  //绿灯相关数据\n          obj: document.getElementById(\'green\'),\n          timeout: parseInt(document.getElementById(\"ld\").innerHTML),\n          style: [\'gray\', \'gray\', \'green\'],\n          next: \'yellow\'\n        },\n        changeStyle(style) {  //设置信号背景色样式\n          this.red.obj.className = style[0];\n          this.yellow.obj.className = style[1];\n          this.green.obj.className = style[2];\n        }\n      };\n```\n\nobj：存储信号灯的元素对象；\ntimeout：存储对应信号灯剩余亮灯时间；\nstyle：存储某信号灯亮时，红绿灯元素背景色的class名称，数组元素 保存的信号灯顺序为红黄绿；\nnext：存储下一次亮灯的信号灯。\n\n#### 3.4 创建倒计时对象\n\n```js\nvar count={\n				obj:document.getElementById(\'count\'),  //倒计时的元素对象\n				change:function(num){\n					this.obj.innerHTML=(num<10)?(\'0\'+num):num;//判断倒计时数字是否小于10\n				}\n			};\n```\n\nchange()方法的参数num表示信号灯的倒计时时间，并以两位数字的格式将num显示到对应位置。\n\nchange()方法的参数num表示信号灯的倒计时时间，并以两位数字的格式将num显示到对应位置。\n\n#### 3.5 初始化页面\n\n```js\nvar now=lamp.green;           //获取绿灯亮的相关数据\n			var timeout=now.timeout;      //获取绿灯亮灯的剩余时间\n			lamp.changeStyle(now.style);  //设置绿灯亮时,红绿灯背景色样式\n			count.change(timeout);        //设置绿灯亮灯的剩余时间\n```\n\n#### 3.6 实现红绿灯倒计时\n\n```js\nsetInterval(function(){\n				if(--timeout<=0){         //切换信号灯\n					now=lamp[now.next];   //获取下一个亮灯的信号灯的相关数据\n					timeout=now.timeout;  //获取信号灯的剩余时间\n					lamp.changeStyle(now.style); //设置信号灯背景色样式\n				}\n				count.change(timeout);    //设置信号灯亮灯的剩余时间\n			},1000);\n```\n\n利用setInterval()函数，在初始化页面后每隔1秒钟间歇调用一次匿名函数。若当前亮灯的剩余时间减1小于等于0后，切换信号灯，重新获取信号灯样式及亮灯的剩余时间。\n\n#### 3.7实现更新倒计时\n\n定义my_function函数\n\n```js\nfunction my_function() {\n			  //获取输入框的对象\n              var red1 = document.getElementById(\'red1\');\n			  var yellow1 = document.getElementById(\'yellow1\');\n			  var green1 = document.getElementById(\'green1\');\n			 //判断输入框是否输入了数据，没输入则不进行更新，目前是红灯的\n			  if(red1.value != \"\"){\n			  lamp.red.timeout=parseInt(red1.value);\n			  var obj = document.getElementById(\"hd\");\n              obj.innerHTML= parseInt(red1.value);\n			  }\n			   //目前到黄灯的\n			  if(yellow1.value != \"\"){\n			  lamp.yellow.timeout=parseInt(yellow1.value);\n			  var obj = document.getElementById(\"h_d\");\n              obj.innerHTML= parseInt(yellow1.value); \n			  }\n			  //目前到绿灯的\n			  if(green1.value != \"\"){\n			  lamp.green.timeout=parseInt(green1.value);\n			  var obj = document.getElementById(\"ld\");\n              obj.innerHTML= parseInt(green1.value); \n			  }\n			  //信号灯数据更新完毕，清空输入框\n			  document.getElementById(\"sub1\").reset();\n			\n         }\n```\n\n输入框及修改按钮，点击修改按钮跳转my_function函数，把输入的秒数更新到秒数状态栏\n\n```html\n<!-- 当前状态的红绿灯的秒数 -->\n	<span style=\"background:red\"> 红灯：</span><span style=\"color:red\" id=\"hd\">15</span><span style=\"color:red\">秒  |</span>\n	<span style=\"background:yellow\"> 黄灯：</span><span  id=\"h_d\">1</span><span >秒  |</span>\n	<span style=\"background:green\"> 绿灯：</span><span style=\"color:green\" id=\"ld\">2</span><span style=\"color:green\" >秒  |</span>\n	\n	<p id=\"\"></p>\n	\n	<p id=\"\" style=\"\n	font-size: 10px;\n    color: cornsilk;\n    font-style: oblique;\n    font-family: cursive;\">\n	<-------------------------可输入红黄绿灯的时间进行修改------------------------>\n	</p>\n	\n	<form action=\"\" id=\"sub1\" method=\"post\" onsubmit=\"return false\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;border-color:red\" type=\"text\" name=\"red1\" id=\"red1\"  placeholder=\"红灯(秒)\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;background:yellow\" type=\"text\" name=\"yellow1\" id=\"yellow1\" placeholder=\"黄灯(秒)\">\n		<input style=\"width:40mm;border-radius:10px;padding:1px;text-align:center;border-color:green\" type=\"text\" name=\"green1\" id=\"green1\" placeholder=\"绿灯(秒)\">\n		<input id=\"in4\" class=\"button\"  type=\"submit\" onclick=\"my_function()\" value=\"修改\"></input>     <!-- 点击按钮则执行my_function函数，进行秒数更新 -->\n	</form>\n```', 'notice20221030230829655', 'department', '2022-10-30 23:08:29', '1', '2022-10-31 18:06:01', 'department', 1, NULL, NULL);
INSERT INTO `notice` VALUES (3, '<h1>\\u6807\\u9898h1</h1>\\n\\\" +\\n                \\\"<h5>\\u6807\\u9898h5</h5>\\n\\\" +\\n                \\\"<p><strong>\\u52A0\\u7C97</strong><br />\\n\\\" +\\n                \\\"<em>\\u659C\\u4F53</em><br />\\n\\\" +\\n                \\\"<del>\\u5220\\u9664\\u7EBF</del><br />\\n\\\" +\\n                \\\"<a href=\\\"https://github.com/vbenjs/vue-vben-admin\\\">\\u94FE\\u63A5</a><br />\\n\\\" +\\n                \\\"\\u2193\\u5206\\u5272\\u7EBF\\u2193</p>\\n\\\" +\\n                \\\"<hr />\\n\\\" +\\n                \\\"<ul>\\n\\\" +\\n                \\\"<li>\\u65E0\\u5E8F\\u5217\\u88681\\n\\\" +\\n                \\\"<ul>\\n\\\" +\\n                \\\"<li>\\u65E0\\u5E8F\\u5217\\u88681.1</li>\\n\\\" +\\n                \\\"</ul>\\n\\\" +\\n                \\\"</li>\\n\\\" +\\n                \\\"</ul>\\n\\\" +\\n                \\\"<ol>\\n\\\" +\\n                \\\"<li>\\u6709\\u5E8F\\u5217\\u88681</li>\\n\\\" +\\n                \\\"<li>\\u6709\\u5E8F\\u5217\\u88682</li>\\n\\\" +\\n                \\\"</ol>\\n\\\" +\\n                \\\"<ul>\\n\\\" +\\n                \\\"<li class=\\\"vditor-task\\\"><input disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88681</li>\\n\\\" +\\n                \\\"<li class=\\\"vditor-task vditor-task--done\\\"><input checked=\\\"\\\" disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88682</li>\\n\\\" +\\n                \\\"</ul>\\n\\\" +\\n                \\\"<blockquote>\\n\\\" +\\n                \\\"<p>\\u5F15\\u7528\\u793A\\u4F8B</p>\\n\\\" +\\n                \\\"</blockquote>\\n\\\" +\\n                \\\"<pre><code class=\\\"language-js\\\">// \\u4EE3\\u7801\\u5757:\\n\\\" +\\n                \\\"(() =&gt; {\\n\\\" +\\n                \\\"  var htmlRoot = document.getElementById(\'htmlRoot\');\\n\\\" +\\n                \\\"  var theme = window.localStorage.getItem(\'__APP__DARK__MODE__\');\\n\\\" +\\n                \\\"  if (htmlRoot &amp;&amp; theme) {\\n\\\" +\\n                \\\"    htmlRoot.setAttribute(\'data-theme\', theme);\\n\\\" +\\n                \\\"    theme = htmlRoot = null;\\n\\\" +\\n                \\\"  }\\n\\\" +\\n                \\\"})();\\n\\\" +\\n                \\\"</code></pre>\\n\\\" +\\n                \\\"<table>\\n\\\" +\\n                \\\"<thead>\\n\\\" +\\n                \\\"<tr>\\n\\\" +\\n                \\\"<th>\\u8868\\u683C</th>\\n\\\" +\\n                \\\"<th>\\u793A\\u4F8B</th>\\n\\\" +\\n                \\\"<th>\\uD83C\\uDF89\\uFE0F</th>\\n\\\" +\\n                \\\"</tr>\\n\\\" +\\n                \\\"</thead>\\n\\\" +\\n                \\\"<tbody>\\n\\\" +\\n                \\\"<tr>\\n\\\" +\\n                \\\"<td>1</td>\\n\\\" +\\n                \\\"<td>2</td>\\n\\\" +\\n                \\\"<td>3</td>\\n\\\" +\\n                \\\"</tr>\\n\\\" +\\n                \\\"<tr>\\n\\\" +\\n                \\\"<td>4</td>\\n\\\" +\\n                \\\"<td>5</td>\\n\\\" +\\n                \\\"<td>6</td>\\n\\\" +\\n                \\\"</tr>\\n\\\" +\\n                \\\"</tbody>\\n\\\" +\\n                \\\"</table>', '202210311001231', '张三', '2022-10-31 11:14:00', '1', '2022-11-30 16:14:20', 'department', 0, 'Markdown语法', NULL);
INSERT INTO `notice` VALUES (4, '<h1>u6807u9898h1</h1>\n<h5>u6807u9898h5</h5>\n<p><strong>u52A0u7C97</strong><br />\n<em>u659Cu4F53</em><br />\n<del>u5220u9664u7EBF</del><br />\n<a href=\"https://github.com/vbenjs/vue-vben-admin\">u94FEu63A5</a><br />\nu2193u5206u5272u7EBFu2193</p>\n<hr />\n<ul>\n<li>u65E0u5E8Fu5217u88681\n<ul>\n<li>u65E0u5E8Fu5217u88681.1</li>\n</ul>\n</li>\n</ul>\n<ol>\n<li>u6709u5E8Fu5217u88681</li>\n<li>u6709u5E8Fu5217u88682</li>\n</ol>\n<ul>\n<li class=\"vditor-task\"><input disabled=\"\" type=\"checkbox\" /> u4EFBu52A1u5217u88681</li>\n<li class=\"vditor-task vditor-task--done\"><input checked=\"\" disabled=\"\" type=\"checkbox\" /> u4EFBu52A1u5217u88682</li>\n</ul>\n<blockquote>\n<p>u5F15u7528u793Au4F8B</p>\n</blockquote>\n<pre><code class=\"language-js\">// u4EE3u7801u5757:\n(() =&gt; {\n  var htmlRoot = document.getElementById(\'htmlRoot\');\n  var theme = window.localStorage.getItem(\'__APP__DARK__MODE__\');\n  if (htmlRoot &amp;&amp; theme) {\n    htmlRoot.setAttribute(\'data-theme\', theme);\n    theme = htmlRoot = null;\n  }\n})();\n</code></pre>\n<table>\n<thead>\n<tr>\n<th>u8868u683C</th>\n<th>u793Au4F8B</th>\n<th>uD83CuDF89uFE0F</th>\n</tr>\n</thead>\n<tbody>\n<tr>\n<td>1</td>\n<td>2</td>\n<td>3</td>\n</tr>\n<tr>\n<td>4</td>\n<td>5</td>\n<td>6</td>\n</tr>\n</tbody>\n</table>', 'notice20221031111600484', 'department', '2022-10-31 11:16:00', '1', '2022-11-28 17:05:44', 'super', 1, NULL, NULL);
INSERT INTO `notice` VALUES (5, '<h1>\\u6807\\u9898h1</h1>\\n<h5>\\u6807\\u9898h5</h5>\\n<p><strong>\\u52A0\\u7C97</strong><br />\\n<em>\\u659C\\u4F53</em><br />\\n<del>\\u5220\\u9664\\u7EBF</del><br />\\n<a href=\\\"https://github.com/vbenjs/vue-vben-admin\\\">\\u94FE\\u63A5</a><br />\\n\\u2193\\u5206\\u5272\\u7EBF\\u2193</p>\\n<hr />\\n<ul>\\n<li>\\u65E0\\u5E8F\\u5217\\u88681\\n<ul>\\n<li>\\u65E0\\u5E8F\\u5217\\u88681.1</li>\\n</ul>\\n</li>\\n</ul>\\n<ol>\\n<li>\\u6709\\u5E8F\\u5217\\u88681</li>\\n<li>\\u6709\\u5E8F\\u5217\\u88682</li>\\n</ol>\\n<ul>\\n<li class=\\\"vditor-task\\\"><input disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88681</li>\\n<li class=\\\"vditor-task vditor-task--done\\\"><input checked=\\\"\\\" disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88682</li>\\n</ul>\\n<blockquote>\\n<p>\\u5F15\\u7528\\u793A\\u4F8B</p>\\n</blockquote>\\n<pre><code class=\\\"language-js\\\">// \\u4EE3\\u7801\\u5757:\\n(() =&gt; {\\n  var htmlRoot = document.getElementById(\'htmlRoot\');\\n  var theme = window.localStorage.getItem(\'__APP__DARK__MODE__\');\\n  if (htmlRoot &amp;&amp; theme) {\\n    htmlRoot.setAttribute(\'data-theme\', theme);\\n    theme = htmlRoot = null;\\n  }\\n})();\\n</code></pre>\\n<table>\\n<thead>\\n<tr>\\n<th>\\u8868\\u683C</th>\\n<th>\\u793A\\u4F8B</th>\\n<th>\\uD83C\\uDF89\\uFE0F</th>\\n</tr>\\n</thead>\\n<tbody>\\n<tr>\\n<td>1</td>\\n<td>2</td>\\n<td>3</td>\\n</tr>\\n<tr>\\n<td>4</td>\\n<td>5</td>\\n<td>6</td>\\n</tr>\\n</tbody>\\n</table>', 'notice20221031112510435', 'department', '2022-10-31 11:25:10', '0', '2022-11-30 16:14:21', 'super', 0, 'Markdown语法2', NULL);
INSERT INTO `notice` VALUES (8, '<h1>\\u6807\\u9898h1</h1>\\n<h5>\\u6807\\u9898h5</h5>\\n<p><strong>\\u52A0\\u7C97</strong><br />\\n<em>\\u659C\\u4F53</em><br />\\n<del>\\u5220\\u9664\\u7EBF</del><br />\\n<a href=\\\"https://github.com/vbenjs/vue-vben-admin\\\">\\u94FE\\u63A5</a><br />\\n\\u2193\\u5206\\u5272\\u7EBF\\u2193</p>\\n<hr />\\n<ul>\\n<li>\\u65E0\\u5E8F\\u5217\\u88681\\n<ul>\\n<li>\\u65E0\\u5E8F\\u5217\\u88681.1</li>\\n</ul>\\n</li>\\n</ul>\\n<ol>\\n<li>\\u6709\\u5E8F\\u5217\\u88681</li>\\n<li>\\u6709\\u5E8F\\u5217\\u88682</li>\\n</ol>\\n<ul>\\n<li class=\\\"vditor-task\\\"><input disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88681</li>\\n<li class=\\\"vditor-task vditor-task--done\\\"><input checked=\\\"\\\" disabled=\\\"\\\" type=\\\"checkbox\\\" /> \\u4EFB\\u52A1\\u5217\\u88682</li>\\n</ul>\\n<blockquote>\\n<p>\\u5F15\\u7528\\u793A\\u4F8B</p>\\n</blockquote>\\n<pre><code class=\\\"language-js\\\">// \\u4EE3\\u7801\\u5757:\\n(() =&gt; {\\n  var htmlRoot = document.getElementById(\'htmlRoot\');\\n  var theme = window.localStorage.getItem(\'__APP__DARK__MODE__\');\\n  if (htmlRoot &amp;&amp; theme) {\\n    htmlRoot.setAttribute(\'data-theme\', theme);\\n    theme = htmlRoot = null;\\n  }\\n})();\\n</code></pre>\\n<table>\\n<thead>\\n<tr>\\n<th>\\u8868\\u683C</th>\\n<th>\\u793A\\u4F8B</th>\\n<th>\\uD83C\\uDF89\\uFE0F</th>\\n</tr>\\n</thead>\\n<tbody>\\n<tr>\\n<td>1</td>\\n<td>2</td>\\n<td>3</td>\\n</tr>\\n<tr>\\n<td>4</td>\\n<td>5</td>\\n<td>6</td>\\n</tr>\\n</tbody>\\n</table>', 'notice20221031114124810', 'department', '2022-10-31 11:41:24', '1', '2022-11-30 16:14:19', 'super', 0, 'Markdown语法1', NULL);
INSERT INTO `notice` VALUES (9, '**\\u4FDD\\u5B58\\u6309\\u94AE\\uFF1A\\u672A\\u63D0\\u4EA4\\u4E4B\\u524D\\u7684\\u4FDD\\u5B58\\uFF0C\\u70B9\\u51FB\\u65F6\\uFF0C\\u4F1A\\u5728application\\u8868\\u3001honor\\u8868\\u3001workflow\\u8868\\u65B0\\u589E\\uFF0C\\u72B6\\u6001\\u4E3A\\u7F16\\u8F91\\u4E2D\\u3002**\\n\\n**\\u63D0\\u4EA4\\u6309\\u94AE\\uFF1A\\u5206\\u4E3A\\u4E24\\u79CD\\uFF0C\\u4E00\\u79CD\\u662F\\u76F4\\u63A5\\u70B9\\u65B0\\u589E\\u7533\\u8BF7\\u9875\\u9762\\u8FDB\\u884C\\u63D0\\u4EA4\\u7684\\uFF0C\\u4F1A\\u540C\\u65F6\\u8FDB\\u884C\\u7F16\\u8F91\\u4E2D\\u548C\\u63D0\\u4EA4\\u4E24\\u4E2A\\u5DE5\\u4F5C\\u6D41\\u7684\\u521B\\u5EFA\\uFF0C\\u4E00\\u79CD\\u662F\\u5DF2\\u7ECF\\u4FDD\\u5B58\\u8FC7\\u7684\\uFF0C\\u4ECE\\u6211\\u7684\\u4EFB\\u52A1\\u5217\\u8868\\u4E2D\\u6253\\u5F00\\u7684\\uFF0C\\u4F1A\\u83B7\\u53D6\\u5176pkid\\u8FDB\\u884C\\u6D41\\u7A0B\\u7684\\u66F4\\u66FF\\u6D41\\u8F6C\\u3002**\\n\\n**\\u5173\\u4E8E\\u6D41\\u7A0B\\u72B6\\u6001\\u7684\\u786E\\u5B9A\\uFF1Aapplication\\u8868\\u7684pkid\\u786E\\u5B9A\\u6240\\u5C5E\\u7684\\u5DE5\\u4F5C\\u6D41\\uFF0Cworkflownumber\\u5B57\\u6BB5\\u786E\\u5B9A\\u6700\\u65B0\\u7684\\u5DE5\\u4F5C\\u6D41\\u72B6\\u6001\\uFF0C\\u5176approvalstatus\\u4E0Eworkflow\\u5BF9\\u5E94\\u5DE5\\u4F5C\\u6D41\\u7684status\\u4FDD\\u6301\\u4E00\\u81F4\\u3002**\\n\\n**\\u5176\\u4E2Dapprovalstatus\\u5B57\\u6BB5\\u7684\\u6570\\u5B57\\u5F62\\u5F0F\\u4F1A\\u4F20\\u5230\\u524D\\u7AEF\\uFF0C\\u5176\\u8868\\u793A\\u6B65\\u9AA4\\u6761\\u7684\\u6B65\\u6570\\uFF0C\\u7279\\u6B8A\\u60C5\\u51B5\\u662F\\u88AB\\u9000\\u56DE\\u7684\\u60C5\\u51B5\\uFF0C\\u4F1A\\u8FD4\\u56DE\\u4E00\\u4E2A0\\uFF0C\\u6B65\\u9AA4\\u6761\\u4F1A\\u76F4\\u63A5\\u53D8\\u4E3A\\u7B2C\\u4E00\\u6B65\\uFF0C\\u6240\\u4EE5\\u4E3A\\u4E86\\u8BF4\\u660E\\u60C5\\u51B5\\uFF0C\\u4F1A\\u5728\\u524D\\u7AEF\\u6B65\\u9AA4\\u6761\\u5904\\u6DFB\\u52A0\\u64CD\\u4F5C\\u8BF4\\u660E\\u3002**\\n\\n**\\u5BF9\\u4E8E\\u88AB\\u9000\\u56DE\\u7684\\u60C5\\u51B5\\u6709\\u70B9\\u590D\\u6742\\uFF0C\\u6709\\u4E24\\u79CD\\u65B9\\u6848\\u5904\\u7406\\uFF0C\\u4E00\\u79CD\\u662F\\u5220\\u6389\\uFF0C\\u8FD9\\u79CD\\u6BD4\\u8F83\\u7B80\\u5355\\uFF0C\\u53E6\\u4E00\\u79CD\\u662F\\u52A0\\u6807\\u5FD7\\u4F4Ddr\\uFF0Cdr=0\\u4E3A\\u542F\\u7528\\u3002**\\n\\n**\\u5BF9\\u4E8E\\u7B2C\\u4E8C\\u79CD\\uFF1A\\u9000\\u56DE\\u53D1\\u751F\\u65F6\\uFF0Cwf\\u8868\\u4E4B\\u524D\\u7684\\u5DE5\\u4F5C\\u6D41dr\\u5168\\u90E8\\u53D8\\u4E3A1\\uFF0C\\u65B0\\u589E\\u4E00\\u6761\\u7F16\\u8F91\\u72B6\\u6001\\u7684\\u5DE5\\u4F5C\\u6D41\\uFF0C\\u5176number\\u5B57\\u6BB5\\u6B63\\u5E38\\u589E\\u52A0\\uFF0Cstatus\\u7F6E\\u4E3A1\\uFF0C\\u5BF9\\u4E8E\\u6B65\\u9AA4\\u6761\\u7684\\u6392\\u5E8F\\u95EE\\u9898\\uFF0C\\u76EE\\u524D\\u6765\\u770B\\u597D\\u50CF\\u662F\\u4EE5\\u67E5\\u51FA\\u6765\\u7684\\u987A\\u5E8F\\u4E3A\\u4E3B\\uFF0C\\u800Cv-for\\u7684key\\u4EE5\\u67E5\\u51FA\\u6765\\u7684id\\u4F5C\\u4E3A\\u6761\\u4EF6\\uFF0C\\u6216\\u8005\\u4E00\\u6B21\\u6765\\u4F5C\\u4E3A\\u6392\\u5E8F\\u7684\\u6761\\u4EF6\\uFF0C\\u9ED8\\u8BA4\\u662F\\u5347\\u5E8F\\uFF0C\\u6BCF\\u52A0\\u4E00\\u6761id\\u4F1A\\u81EA\\u589E\\uFF0C\\u6240\\u4EE5\\u5E94\\u8BE5\\u4E0D\\u4F1A\\u51FA\\u73B0\\u6392\\u5E8F\\u6DF7\\u4E71\\u7684\\u60C5\\u51B5\\u3002**\\n\\n**application\\u8868\\u7684\\u72B6\\u6001\\u4F4Dapprovalstatus\\u53D8\\u56DE1\\uFF0C\\u6D41\\u7A0B\\u4ECE\\u5934\\u5F00\\u59CB\\u3002**\\n\\n**numberofedits  \\u88AB\\u9000\\u56DE\\u5269\\u4F59\\u7F16\\u8F91\\u6B21\\u6570 \\u73B0\\u5728\\u89C4\\u5B9A\\u53EA\\u80FD\\u4FEE\\u6539\\u4E00\\u6B21\\uFF0C\\u6240\\u4EE5\\u4EE3\\u7801\\u91CC\\u8BBE\\u7F6E\\u7684\\u662F1**\\n\\n**fakecode\\u8868\\uFF0C\\u6743\\u9650\\u7F16\\u7801\\u8868\\uFF0C\\u7528\\u4E8E\\u505A\\u6309\\u94AE\\u7EA7\\u522B\\u7684\\u63A7\\u5236\\uFF0C\\u5BF9\\u5E94\\u63A5\\u53E3/getPermCode\\uFF1B**\\n\\n**userinfo\\u5982\\u679C\\u6CA1\\u6709\\u6570\\u636E\\uFF0C\\u5219\\u4F1A\\u4F7F\\u4EFB\\u52A1\\u5217\\u8868\\u5F02\\u5E38\\uFF0C\\u56E0\\u4E3A\\u4F1A\\u4F7F\\u7528\\u5230userinfo\\u7684userid**\\n\\n**\\u5B66\\u9662\\u7684\\u4EFB\\u52A1\\u5217\\u8868\\u91CC\\uFF0C\\u4F1A\\u62C9\\u53D6\\u5B66\\u751F\\u63D0\\u4EA4\\u72B6\\u6001\\uFF082\\uFF09\\u7684\\u5355\\u636E\\uFF0C\\u4E5F\\u6709\\u5B66\\u9662\\u5BA1\\u6279\\u4E2D\\uFF083\\uFF09\\u7684\\u5355\\u636E\\uFF0C\\u5B66\\u9662\\u6253\\u5F00\\u5355\\u636E\\u540E\\uFF0C\\u8BE5\\u5355\\u636E\\u4F1A\\u4ECE\\u63D0\\u4EA4\\u72B6\\u6001\\u7F16\\u7A0B\\u5B66\\u9662\\u5BA1\\u6279\\u4E2D\\u72B6\\u6001\\uFF0C\\u7ECF\\u8FC7\\u5BA1\\u6279\\u540E\\uFF0C\\u53D8\\u4E3A\\u5B66\\u9662\\u5BA1\\u6279\\u901A\\u8FC7\\u72B6\\u6001\\u6216\\u8005\\u9A73\\u56DE\\uFF08\\u7B2C\\u4E8C\\u6B21\\u9A73\\u56DE\\u5219\\u53D8\\u4E3A\\u5BA1\\u6279\\u4E0D\\u901A\\u8FC7\\uFF09\\uFF0C\\u5BA1\\u6279\\u901A\\u8FC7\\uFF084\\uFF09\\u540E\\u5355\\u636E\\u4F1A\\u7EE7\\u7EED\\u505C\\u7559\\uFF0C\\u5F53\\u72B6\\u6001\\u53D8\\u6210\\u5B66\\u6821\\u5BA1\\u6279\\u4E2D\\uFF085\\uFF09\\u7684\\u72B6\\u6001\\u65F6\\uFF0C\\u624D\\u4F1A\\u53BB\\u6389\\uFF0C\\u5B66\\u6821\\u7684\\u5217\\u8868\\u5219\\u4F1A\\u62C9\\u53D6\\u5B66\\u9662\\u5BA1\\u6279\\u901A\\u8FC7\\uFF084\\uFF09\\u53CA\\u5B66\\u6821\\u5BA1\\u6279\\u4E2D\\uFF085\\uFF09\\u7684\\u72B6\\u6001\\uFF0C\\u6279\\u51C6\\uFF086\\uFF09\\u540E\\u6216\\u62D2\\u7EDD\\uFF087\\uFF09\\u540E\\u53BB\\u6389\\u3002**\\n\\n**\\u5DF2\\u7ECF\\u5B8C\\u6210\\u7684\\u4EFB\\u52A1\\u4F1A\\u5728\\u4EFB\\u52A1\\u8868\\u683C\\u91CC\\u5C55\\u793A**\\n\\n**\\u5173\\u4E8E\\u603B\\u4EFB\\u52A1\\u6570\\uFF0C\\u9662\\u7EA7\\uFF1A\\u5B66\\u9662\\u5BA1\\u6279\\u901A\\u8FC7\\u72B6\\u6001\\uFF084\\uFF09\\u4E14\\u4E0D\\u8FBE\\u5230\\u901A\\u8FC7\\uFF086\\uFF09\\u6216\\u4E0D\\u901A\\u8FC7\\uFF087\\uFF09\\u7684  \\u52A0\\u4E0A \\u6240\\u6709\\u901A\\u8FC7\\uFF086\\uFF09\\u6216\\u4E0D\\u901A\\u8FC7\\uFF087\\uFF09\\uFF0C\\u6821\\u7EA7\\uFF1B\\u6240\\u6709\\u901A\\u8FC7\\uFF086\\uFF09\\u6216\\u4E0D\\u901A\\u8FC7\\uFF087\\uFF09\\uFF0C\\u4E2A\\u4EBA\\uFF1A\\u63D0\\u4EA4\\u72B6\\u6001\\uFF082\\uFF09\\u4E14\\u4E0D\\u8FBE\\u5230\\u901A\\u8FC7\\uFF086\\uFF09\\u6216\\u4E0D\\u901A\\u8FC7\\uFF087\\uFF09\\u7684 \\u52A0\\u4E0A \\u6240\\u6709\\u901A\\u8FC7\\u6216\\u4E0D\\u901A\\u8FC7**\\n\\n**\\u603B\\u7ED3\\uFF1A**\\n\\n**super\\uFF1A4\\u30015**\\n\\n**department\\uFF1A2\\u30013\\u30014**\\n\\n**student\\uFF1A\\u53EA\\u62C9\\u53D6\\u81EA\\u5DF1\\u7684\\uFF0C\\u6392\\u96646\\u30017\\uFF0C0-5\\u90FD\\u4F1A\\u5B58\\u5728\\uFF0C\\u4F46\\u524D\\u671F\\u5148\\u90FD\\u663E\\u793A**\\n\\n**\\u66F4\\u6539\\u72B6\\u6001\\uFF1A\\u7ED9workflow\\u589E\\u52A0\\u4E00\\u6761\\u6D41\\u7A0B\\u4FE1\\u606F\\u5E76\\u8BBE\\u7F6Estatus\\uFF0C\\u505A\\u4E2A\\u89E6\\u53D1\\u5668\\uFF0C\\u63D2\\u5165workflow\\u8868\\u7684\\u65F6\\u5019\\u540C\\u65F6\\u66F4\\u65B0application\\u7684approvalstatus**\\n\\n**\\u4F7F\\u7528\\u65B9\\u5F0F\\uFF1A**\\n\\n**1\\u3001\\u51FD\\u6570\\u65B9\\u5F0F**\\n\\n[usePermission](https://github.com/vbenjs/vue-vben-admin/tree/main/src/hooks/web/usePermission.ts) \\u8FD8\\u63D0\\u4F9B\\u4E86\\u6309\\u94AE\\u7EA7\\u522B\\u7684\\u6743\\u9650\\u63A7\\u5236\\u3002\\n\\n```\\n<template>\\n  <a-button v-if=\\\"hasPermission([\'20000\', \'2000010\'])\\\" color=\\\"error\\\" class=\\\"mx-4\\\">\\n    \\u62E5\\u6709[20000,2000010]code\\u53EF\\u89C1\\n  </a-button>\\n</template>\\n<script lang=\\\"ts\\\">\\n  import { usePermission } from \'/@/hooks/web/usePermission\';\\n  import { RoleEnum } from \'/@/enums/roleEnum\';\\n\\u200B\\n  export default defineComponent({\\n    setup() {\\n      const { hasPermission } = usePermission();\\n      return { hasPermission };\\n    },\\n  });\\n</script>\\n```\\n\\n**2\\u3001\\u7EC4\\u4EF6\\u65B9\\u5F0F**\\n\\n**\\u5177\\u4F53\\u67E5\\u770B**[\\u6743\\u9650\\u7EC4\\u4EF6\\u4F7F\\u7528](https://vvbin.cn/doc-next/components/auth.html)\\n\\n**\\u5BF9\\u5E94\\u5B57\\u6BB5\\u5728user\\u8868\\u7684rolevalue**\\n\\n```\\nexport enum RoleEnum {\\n// super admin //\\u6821\\u7EA7\\u7BA1\\u7406\\u5458\\n    SUPER = \'super\',\\n// tester //\\u666E\\u901A\\u5B66\\u751F\\u7528\\u6237\\nTEST = \'test\',\\n\\u200B\\n//\\u5B66\\u9662\\u7EA7\\u7BA1\\u7406\\u5458\\n    Department = \'Department\'\\n```\\n\\n**}**\\n\\n```\\n<template>\\n  <div>\\n    <Authority :value=\\\"RoleEnum.ADMIN\\\">\\n      <a-button type=\\\"primary\\\" block> \\u53EA\\u6709admin\\u89D2\\u8272\\u53EF\\u89C1 </a-button>\\n    </Authority>\\n  </div>\\n</template>\\n<script>\\n  import Authority from \'/@/components/Authority\';\\n  import { defineComponent } from \'vue\';\\n  export default defineComponent({\\n    components: { Authority },\\n  });\\n</script>\\n```\\n\\n**3\\u3001\\u6307\\u4EE4\\u65B9\\u5F0F**\\n\\n**\\u6307\\u4EE4\\u65B9\\u5F0F\\u4E0D\\u80FD\\u52A8\\u6001\\u66F4\\u6539\\u6743\\u9650**\\n\\n```\\n<a-button v-auth=\\\"\'1000\'\\\" type=\\\"primary\\\" class=\\\"mx-4\\\"> \\u62E5\\u6709code [\'1000\']\\u6743\\u9650\\u53EF\\u89C1 </a-button>\\n```\\n\\n**\\u53D8\\u91CF/\\u5E38\\u91CF\\u7C7B\\u578B\\u7684\\u5B9A\\u4E49\\uFF1A**\\n\\n**const data = ref**<any>**(null);**\\n\\n**var mylist = [] as any;**\\n\\n**let otherParam = reactive({**\\n**              showA: false,**\\n**              result: null as any, //\\u8BBE\\u7F6E\\u7C7B\\u578B\\uFF0C\\u4E0D\\u8BBE\\u7F6E\\u5219\\u4E3Anever**\\n**              title: \'\',**\\n**              tabledata: [] as any[],**\\n**              pkid: null as any,**\\n**              type: null as any,**\\n**              data: null as any,**\\n**              tdata: \'\',**\\n**              workflownumber: \'\'**\\n**          });**', 'notice20221031115029726', 'department', '2022-10-31 11:50:29', '1', '2022-11-30 16:14:06', 'department', 0, '开发笔记', NULL);
INSERT INTO `notice` VALUES (14, '# \\u6807\\u9898h1\\n\\n                        ##### \\u6807\\u9898h5\\n\\n                        **\\u52A0\\u7C97**\\n                        *\\u659C\\u4F53*\\n                        ~~\\u5220\\u9664\\u7EBF~~\\n                        [\\u94FE\\u63A5](https://github.com/vbenjs/vue-vben-admin)\\n                        \\u2193\\u5206\\u5272\\u7EBF\\u2193\\n\\n                        ---\\n\\n\\n                        * \\u65E0\\u5E8F\\u5217\\u88681\\n                          * \\u65E0\\u5E8F\\u5217\\u88681.1\\n\\n                        1. \\u6709\\u5E8F\\u5217\\u88681\\n                        2. \\u6709\\u5E8F\\u5217\\u88682\\n\\n                        * [ ] \\u4EFB\\u52A1\\u5217\\u88681\\n                        * [x] \\u4EFB\\u52A1\\u5217\\u88682\\n\\n                        > \\u5F15\\u7528\\u793A\\u4F8B\\n\\n                        ```js\\n                        // \\u4EE3\\u7801\\u5757:\\n                        (() => {\\n                          var htmlRoot = document.getElementById(\'htmlRoot\');\\n                          var theme = window.localStorage.getItem(\'__APP__DARK__MODE__\');\\n                          if (htmlRoot && theme) {\\n                            htmlRoot.setAttribute(\'data-theme\', theme);\\n                            theme = htmlRoot = null;\\n                          }\\n                        })();\\n                        ```\\n\\n                        | \\u8868\\u683C | \\u793A\\u4F8B | \\uD83C\\uDF89\\uFE0F |\\n                        | --- | --- | --- |\\n                        | 1 | 2 | 3 |\\n                        | 4 | 5 | 6 |', 'notice20221128133618124', 'department', '2022-11-28 13:36:18', '1', '2022-11-30 16:14:15', NULL, 0, '2022年11月28日公告', NULL);

-- ----------------------------
-- Table structure for organization
-- ----------------------------
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `father` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of organization
-- ----------------------------
INSERT INTO `organization` VALUES (1, '信息科学与工程学院', '1', 'college', '0');
INSERT INTO `organization` VALUES (2, '艺术学院', '2', 'college', '0');
INSERT INTO `organization` VALUES (3, '旅游学院', '3', 'college', '0');
INSERT INTO `organization` VALUES (4, '计算机科学与技术专业', '1-1', 'profession', '1');
INSERT INTO `organization` VALUES (5, '软件工程专业', '1-2', 'profession', '1');
INSERT INTO `organization` VALUES (6, '电子信息专业', '1-3', 'profession', '1');
INSERT INTO `organization` VALUES (7, '物联网专业', '1-4', 'profession', '1');
INSERT INTO `organization` VALUES (8, '音乐学', '2-1', 'profession', '2');
INSERT INTO `organization` VALUES (9, '音乐表演', '2-2', 'profession', '2');
INSERT INTO `organization` VALUES (10, '作曲与作曲技术理论', '2-3', 'profession', '2');
INSERT INTO `organization` VALUES (11, '旅游管理', '3-1', 'profession', '3');
INSERT INTO `organization` VALUES (12, '导游', '3-2', 'profession', '3');
INSERT INTO `organization` VALUES (13, '景区开发与管理', '3-3', 'profession', '3');
INSERT INTO `organization` VALUES (14, '计本1班', '1-1-1', 'tclass', '1-1');
INSERT INTO `organization` VALUES (15, '计本2班', '1-1-2', 'tclass', '1-1');
INSERT INTO `organization` VALUES (16, '软件1班', '1-2-1', 'tclass', '1-2');
INSERT INTO `organization` VALUES (17, '软件2班', '1-2-2', 'tclass', '1-2');
INSERT INTO `organization` VALUES (18, '电信1班', '1-3-1', 'tclass', '1-3');
INSERT INTO `organization` VALUES (19, '电信2班', '1-3-2', 'tclass', '1-3');
INSERT INTO `organization` VALUES (20, '物联网1班', '1-4-1', 'tclass', '1-4');
INSERT INTO `organization` VALUES (21, '物联网2班', '1-4-2', 'tclass', '1-4');
INSERT INTO `organization` VALUES (22, '音乐1班', '2-1-1', 'tclass', '2-1');
INSERT INTO `organization` VALUES (23, '音乐2班', '2-1-2', 'tclass', '2-1');
INSERT INTO `organization` VALUES (24, '表演1班', '2-2-1', 'tclass', '2-2');
INSERT INTO `organization` VALUES (25, '表演2班', '2-2-2', 'tclass', '2-2');
INSERT INTO `organization` VALUES (26, '作曲1班', '2-3-1', 'tclass', '2-3');
INSERT INTO `organization` VALUES (27, '作曲2班', '2-3-2', 'tclass', '2-3');
INSERT INTO `organization` VALUES (28, '旅游管理1班', '3-1-1', 'tclass', '3-1');
INSERT INTO `organization` VALUES (29, '旅游管理2班', '3-1-2', 'tclass', '3-1');
INSERT INTO `organization` VALUES (30, '导游1班', '3-2-1', 'tclass', '3-2');
INSERT INTO `organization` VALUES (31, '导游2班', '3-2-2', 'tclass', '3-2');
INSERT INTO `organization` VALUES (32, '景区开发1班', '3-3-1', 'tclass', '3-3');
INSERT INTO `organization` VALUES (33, '景区开发2班', '3-3-2', 'tclass', '3-3');

-- ----------------------------
-- Table structure for tags
-- ----------------------------
DROP TABLE IF EXISTS `tags`;
CREATE TABLE `tags`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tagid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `key` int(255) NULL DEFAULT NULL,
  `lable` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tags
-- ----------------------------
INSERT INTO `tags` VALUES (1, '1', 0, '很有想法的');
INSERT INTO `tags` VALUES (2, '1', 1, '专注设计');
INSERT INTO `tags` VALUES (3, '1', 2, '辣~');
INSERT INTO `tags` VALUES (4, '1', 3, '大长腿');
INSERT INTO `tags` VALUES (5, '1', 4, '川汉子');
INSERT INTO `tags` VALUES (6, '1', 5, '海纳百川');

-- ----------------------------
-- Table structure for tags_copy1
-- ----------------------------
DROP TABLE IF EXISTS `tags_copy1`;
CREATE TABLE `tags_copy1`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tagid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `key` int(255) NULL DEFAULT NULL,
  `lable` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of tags_copy1
-- ----------------------------
INSERT INTO `tags_copy1` VALUES (1, '1', 0, '很有想法的');
INSERT INTO `tags_copy1` VALUES (2, '1', 1, '专注设计');
INSERT INTO `tags_copy1` VALUES (3, '1', 2, '辣~');
INSERT INTO `tags_copy1` VALUES (4, '1', 3, '大长腿');
INSERT INTO `tags_copy1` VALUES (5, '1', 4, '川汉子');
INSERT INTO `tags_copy1` VALUES (6, '1', 5, '海纳百川');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `rolevalue` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `userId` int(11) NULL DEFAULT NULL COMMENT '前端配置用户组，以及在fakecode中配置',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '昵称',
  `desc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `homePath` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sex` int(255) NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `Birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' COMMENT '个人简介',
  `studentid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `noticeid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `college` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `profession` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tclass` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `userid`(`userId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'Super Admin', 'Super', 1, 'super', '123456', 'super', 'super', 'niubi', 'avatar2022-10-13-18-24-45-934.jpg', '/dashboard/analysis', NULL, NULL, NULL, NULL, '', NULL, '11', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (2, 'Department', 'Department', 2, 'department', '123456', 'Department', 'department', '实打实大所', 'avatar2022-10-21-21-08-17-935.jpg', '/dashboard/workbench', NULL, NULL, NULL, NULL, '', NULL, 'notice20221031112510435', '0', '1', NULL, NULL);
INSERT INTO `user` VALUES (3, 'student', 'student', 3, '张三', '123456', 'student', '张三', '张三就是张三', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, NULL, NULL, NULL, '', NULL, 'notice20221128133618124', '0', '1', '1-1', '1-1-1');
INSERT INTO `user` VALUES (4, 'student', 'student', 4, '李四', '123456', 'student', '李四', 'geilaozishuaxin', 'avatar2022-10-24-13-45-14-887.jpg', '/dashboard/workbench', NULL, NULL, NULL, NULL, '', NULL, '11', '0', '1', '1-1', '1-1-2');
INSERT INTO `user` VALUES (10, 'student', 'student', NULL, 'lamp', '123456', 'student', 'lamp', '测试账号1', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '1916762635', NULL, 'lamp@qq.com', '测试账号1', NULL, 'notice123', '1', '1', '1-1', '1-1-2');
INSERT INTO `user` VALUES (11, 'student', 'student', NULL, '王五', '123456', 'student', '王五', '发吃撒擦擦', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '1916762635', NULL, 'asdfgh@fff.com', 'null', NULL, 'notice123', '0', '1', '1-2', '1-2-1');
INSERT INTO `user` VALUES (12, 'student', 'student', NULL, '赵六', '123456', 'student', '赵六', '按时发放处', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '1916762635', NULL, 'asdfgh@fff.com', '按时发放处', NULL, 'notice123', '0', '1', '1-3', '1-3-1');
INSERT INTO `user` VALUES (13, 'student', 'student', NULL, '夏美', '123456', 'student', '夏美', '塞擦声才散场', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '1916762635', NULL, 'asdfgh@fff.com', '塞擦声才散场', NULL, 'notice123', '0', '2', '2-1', '2-1-1');
INSERT INTO `user` VALUES (14, 'Department', 'Department', NULL, '艺术dept', '123456', 'Department', '艺术dept', '艺术ing', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '19167765463', NULL, '454356@qq.com', '艺术ing', NULL, 'notice123', '0', '2', 'null', 'null');
INSERT INTO `user` VALUES (15, 'student', 'student', NULL, '牛七', '123456', 'student', '牛七', '表演试试', 'avatar2022-10-23-22-20-32-744.jpg', '/dashboard/workbench', NULL, '19167765463', NULL, 'asdfgh@fff.com', '表演试试', NULL, 'notice20221031112510435', '1', '2', '2-2', '2-2-1');

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sex` int(255) NULL DEFAULT NULL,
  `userid` int(11) NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `birthday` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `remarks` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  `signature` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `introduction` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `group` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `notifyCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `unreadCount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `avatar` text CHARACTER SET utf8 COLLATE utf8_bin NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES (1, 'super', 1, 1, '19167738695', '1998-08-29 00:00:00', 'test@gmail.com', '要使整个人生都过得舒适、愉快，这是不可能的，因为人类必须具备一种能应付逆境的态度', '海纳百川，有容乃大', '微笑着，努力着，欣赏着', '交互专家', '某某某事业群－某某平台部－某某技术部－UED', '1', '12', '11', 'China', 'Xiamen City 77', 'avatar2022-10-13-18-24-45-934.jpg');
INSERT INTO `userinfo` VALUES (4, '张三', 1, 3, '1916762635', '2008-10-03 22:02:17', 'fqqdsff@fff.com', '张三就是张三', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (5, '李四', 2, 4, '1916762635', '2003-10-02 13:44:34', 'asdfgh@fff.com', 'geilaozishuaxin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-24-13-45-14-887.jpg');
INSERT INTO `userinfo` VALUES (6, 'department', 1, 2, '1916762635', '2014-10-23 15:18:00', 'fqqdsff@fff.com', '实打实大所', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-21-21-08-17-935.jpg');
INSERT INTO `userinfo` VALUES (14, 'lamp', 2, 10, '1916762635', '2022-11-02 19:06:12', 'lamp@qq.com', '测试账号1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (15, '王五', NULL, 11, '1916762635', NULL, 'asdfgh@fff.com', '发吃撒擦擦', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (16, '赵六', 2, 12, '1916762635', 'null', 'asdfgh@fff.com', '按时发放处', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (17, '夏美', NULL, 13, '1916762635', NULL, 'asdfgh@fff.com', '塞擦声才散场', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (18, '艺术dept', NULL, 14, '19167765463', NULL, '454356@qq.com', '艺术ing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');
INSERT INTO `userinfo` VALUES (19, '牛七', NULL, 15, '19167765463', NULL, 'asdfgh@fff.com', '表演试试', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'avatar2022-10-23-22-20-32-744.jpg');

-- ----------------------------
-- Table structure for workflow
-- ----------------------------
DROP TABLE IF EXISTS `workflow`;
CREATE TABLE `workflow`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pkid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `number` int(11) NULL DEFAULT NULL COMMENT '工作流节点数',
  `previousnumber` int(11) NULL DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '流程状态',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `handler` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `handletime` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `handleaction` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `ishandle` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `dr` int(255) NULL DEFAULT NULL,
  `isread` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of workflow
-- ----------------------------
INSERT INTO `workflow` VALUES (46, '20221028164924797', 1, 0, '1', 'organization', '张三', '2022-10-28 16:49:24', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (47, '20221028164924797', 2, 1, '2', 'organization', '张三', '2022-10-28 16:49:24', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (48, '20221028164924797', 3, 2, '3', 'organization', 'department', '2022-10-28 16:49:46', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (49, '20221028164924797', 4, 3, '4', 'organization', 'department', '2022-10-28 16:49:51', '初审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (50, '20221028164924797', 5, 4, '5', 'organization', 'super', '2022-10-28 16:50:12', '终审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (51, '20221028164924797', 6, 5, '6', 'organization', 'super', '2022-10-28 16:50:15', '终审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (52, '20221028165200702', 1, 0, '1', 'organization', '张三', '2022-10-28 16:52:00', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (53, '20221028165200702', 2, 1, '2', 'organization', '张三', '2022-10-28 16:52:00', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (54, '20221028165200702', 3, 2, '3', 'organization', 'department', '2022-10-28 16:53:24', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (55, '20221028165200702', 4, 3, '0', 'organization', 'department', '2022-10-28 16:54:14', '初审驳回', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (56, '20221028165200702', 5, 4, '1', 'organization', '张三', '2022-10-28 16:54:44', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (57, '20221028165200702', 6, 5, '2', 'organization', '张三', '2022-10-28 16:55:10', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (58, '20221028165200702', 7, 6, '3', 'organization', 'department', '2022-10-28 16:55:51', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (59, '20221028165200702', 8, 7, '4', 'organization', 'department', '2022-10-28 17:11:39', '初审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (60, '20221028165200702', 9, 8, '5', 'organization', 'super', '2022-10-28 17:11:55', '终审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (61, '20221028165200702', 10, 9, '6', 'organization', 'super', '2022-10-28 17:12:05', '终审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (62, '20221028171425163', 1, 0, '1', 'organization', '张三', '2022-10-28 17:14:25', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (63, '20221028171425163', 2, 1, '2', 'organization', '张三', '2022-10-28 17:14:25', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (64, '20221028171425163', 3, 2, '3', 'organization', 'department', '2022-10-28 17:14:42', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (65, '20221028171425163', 4, 3, '0', 'organization', 'department', '2022-10-28 17:14:45', '初审驳回', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (66, '20221028171425163', 5, 4, '1', 'organization', '张三', '2022-10-28 17:15:02', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (67, '20221028171425163', 6, 5, '2', 'organization', '张三', '2022-10-28 17:15:31', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (68, '20221028171425163', 7, 6, '3', 'organization', 'department', '2022-10-28 17:15:48', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (69, '20221028171425163', 8, 7, '7', 'organization', 'department', '2022-10-28 17:15:58', '终审不通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (70, '20221028171653581', 1, 0, '1', 'organization', '张三', '2022-10-28 17:16:53', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (71, '20221028171653581', 2, 1, '2', 'organization', '张三', '2022-10-28 17:16:53', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (72, '20221028171653581', 3, 2, '3', 'organization', 'department', '2022-10-28 17:17:06', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (73, '20221028171653581', 4, 3, '0', 'organization', 'department', '2022-10-28 17:17:07', '初审驳回', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (74, '20221028171653581', 5, 4, '1', 'organization', '张三', '2022-10-28 17:17:19', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (75, '20221028171653581', 6, 5, '2', 'organization', '张三', '2022-10-28 17:17:38', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (76, '20221028171653581', 7, 6, '3', 'organization', 'department', '2022-10-28 17:17:50', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (78, '20221028171653581', 8, 7, '4', 'organization', 'department', '2022-10-28 17:21:44', '初审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (79, '20221028171653581', 9, 8, '5', 'organization', 'super', '2022-10-28 17:21:55', '终审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (80, '20221028171653581', 10, 9, '7', 'organization', 'super', '2022-10-28 17:21:57', '终审不通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (87, '20221127220537554', 1, 0, '1', 'organization', '李四', '2022-11-27 22:05:37', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (88, '20221127220537554', 2, 1, '2', 'organization', '李四', '2022-11-27 22:05:37', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (89, '20221127220806088', 1, 0, '1', 'organization', '夏美', '2022-11-27 22:08:06', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (90, '20221127220806088', 2, 1, '2', 'organization', '夏美', '2022-11-27 22:08:06', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (91, '20221127220537554', 3, 2, '3', 'organization', 'department', '2022-11-27 22:42:26', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (92, '20221127220537554', 4, 3, '0', 'organization', 'department', '2022-11-27 22:42:28', '初审驳回', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (93, '20221127220537554', 5, 4, '1', 'organization', '李四', '2022-11-27 22:42:48', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (94, '20221127220537554', 6, 5, '2', 'organization', '李四', '2022-11-30 16:18:59', '提交', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (95, '20221127220537554', 7, 6, '3', 'organization', 'department', '2022-11-30 16:19:24', '初审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (96, '20221127220537554', 8, 7, '4', 'organization', 'department', '2022-11-30 16:19:28', '初审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (97, '20221127220537554', 9, 8, '5', 'organization', 'super', '2022-11-30 16:19:45', '终审审批中', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (98, '20221127220537554', 10, 9, '6', 'organization', 'super', '2022-11-30 16:19:48', '终审通过', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (99, '20221130164314078', 1, 0, '1', 'individual', '牛七', '2022-11-30 16:43:14', '编辑', NULL, 0, 'true');
INSERT INTO `workflow` VALUES (100, '20221130164314078', 2, 1, '2', 'individual', '牛七', '2022-11-30 16:43:14', '提交', NULL, 0, 'true');

-- ----------------------------
-- Triggers structure for table user
-- ----------------------------
DROP TRIGGER IF EXISTS `updateavatar`;
delimiter ;;
CREATE TRIGGER `updateavatar` AFTER UPDATE ON `user` FOR EACH ROW update awards.`userinfo` a set a.avatar = NEW.avatar where a.userid=OLD.id
;
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table workflow
-- ----------------------------
DROP TRIGGER IF EXISTS `updateapplicstatus`;
delimiter ;;
CREATE TRIGGER `updateapplicstatus` AFTER INSERT ON `workflow` FOR EACH ROW update awards.`application` a set a.approvalstatus = NEW.`status` where a.pkid=NEW.pkid
;
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table workflow
-- ----------------------------
DROP TRIGGER IF EXISTS `updateapplicwfnum`;
delimiter ;;
CREATE TRIGGER `updateapplicwfnum` AFTER INSERT ON `workflow` FOR EACH ROW UPDATE awards.application a SET a.workflownumber = NEW.number WHERE a.pkid = NEW.pkid
;
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;