server/build-cloud/sql/ry-gen.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 167
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : 192.168.0.167:3306
 Source Schema         : ry-gen

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

 Date: 06/08/2021 16:01:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for flyway_schema_history
-- ----------------------------
DROP TABLE IF EXISTS `flyway_schema_history`;
CREATE TABLE `flyway_schema_history`  (
  `installed_rank` int(11) NOT NULL,
  `version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `script` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `checksum` int(11) NULL DEFAULT NULL,
  `installed_by` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `installed_on` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  `execution_time` int(11) NOT NULL,
  `success` tinyint(1) NOT NULL,
  PRIMARY KEY (`installed_rank`) USING BTREE,
  INDEX `flyway_schema_history_s_idx`(`success`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of flyway_schema_history
-- ----------------------------
INSERT INTO `flyway_schema_history` VALUES (1, '1', '<< Flyway Baseline >>', 'BASELINE', '<< Flyway Baseline >>', NULL, 'root', '2021-08-06 07:36:01', 0, 1);
INSERT INTO `flyway_schema_history` VALUES (2, '1.1', 'test-db', 'SQL', 'V1_1__test-db.sql', 870275984, 'root', '2021-08-06 07:36:02', 441, 1);

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table`  (
  `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表名称',
  `table_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表描述',
  `class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '实体类名称',
  `tpl_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '使用的模板（crud单表操作 tree树表操作）',
  `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成包路径',
  `module_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成模块名',
  `business_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成业务名',
  `function_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能名',
  `function_author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能作者',
  `gen_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
  `gen_path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
  `options` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其它生成选项',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `sub_table_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
  `sub_table_fk_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
  PRIMARY KEY (`table_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_table
-- ----------------------------
INSERT INTO `gen_table` VALUES (11, 'batch_job_instance', '', 'BatchJobInstance', '1', 'com.ruoyi.system', 'system', 'instance', NULL, 'ruoyi', '0', '/', NULL, 'admin', '2021-03-25 16:41:44', '', NULL, NULL, NULL, NULL);
INSERT INTO `gen_table` VALUES (12, 'template_engine', '导出模板管理', 'TemplateEngine', '1', 'com.ruoyi.system', 'gen', 'engine', '导出模板管理', 'ruoyi', '0', '/', '{\"parentMenuId\":\"3\"}', 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08', NULL, NULL, NULL);
INSERT INTO `gen_table` VALUES (13, 'generator_data_source', '数据源', 'GeneratorDataSource', '1', 'com.ruoyi.gen', 'system', 'gen', '数据源', 'ruoyi', '0', 'c:', '{\"parentMenuId\":\"2\"}', 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column`  (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列类型',
  `java_type` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
  `java_field` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
  `is_pk` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
  `is_increment` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
  `is_required` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
  `is_insert` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
  `is_edit` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
  `is_list` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
  `is_query` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
  `query_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
  `html_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
  `dict_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`column_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
INSERT INTO `gen_table_column` VALUES (228, '11', 'JOB_INSTANCE_ID', NULL, 'bigint(20)', 'Long', 'jobInstanceId', '1', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2021-03-25 16:41:44', '', NULL);
INSERT INTO `gen_table_column` VALUES (229, '11', 'VERSION', NULL, 'bigint(20)', 'Long', 'version', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2021-03-25 16:41:44', '', NULL);
INSERT INTO `gen_table_column` VALUES (230, '11', 'JOB_NAME', NULL, 'varchar(100)', 'String', 'jobName', '0', '0', '1', '1', '1', '1', '1', 'LIKE', 'input', '', 3, 'admin', '2021-03-25 16:41:44', '', NULL);
INSERT INTO `gen_table_column` VALUES (231, '11', 'JOB_KEY', NULL, 'varchar(32)', 'String', 'jobKey', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2021-03-25 16:41:44', '', NULL);
INSERT INTO `gen_table_column` VALUES (232, '12', 'id', 'id主键', 'int(4)', 'Integer', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (233, '12', 'del_Flag', '删除标识（0正常 1关闭）', 'varchar(2)', 'String', 'delFlag', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', '', 2, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (234, '12', 'create_by', '创建者', 'varchar(64)', 'String', 'createBy', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', '', 3, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (235, '12', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', '', 4, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (236, '12', 'update_by', '更新者', 'varchar(64)', 'String', 'updateBy', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'input', '', 5, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (237, '12', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, NULL, NULL, NULL, NULL, 'EQ', 'datetime', '', 6, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (238, '12', 'template_name', '模板名称', 'varchar(255)', 'String', 'templateName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 7, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (239, '12', 'template_code', '模板编码', 'varchar(255)', 'String', 'templateCode', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 8, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (240, '12', 'json_str', '测试json', 'varchar(255)', 'String', 'jsonStr', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 9, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (241, '12', 'template_content', '模板内容', 'blob', 'String', 'templateContent', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'editor', '', 10, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (242, '12', 'template_type', '模板类型', 'varchar(1)', 'String', 'templateType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'template_type', 11, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (243, '12', 'template_url', '模板上传的地址', 'varchar(255)', 'String', 'templateUrl', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 12, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (244, '12', 'results_type', '输出类型', 'varchar(255)', 'String', 'resultsType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', 'results_type', 13, 'admin', '2021-03-26 17:29:31', '', '2021-03-26 17:49:08');
INSERT INTO `gen_table_column` VALUES (245, '13', 'id', '主键', 'int(11)', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 1, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (246, '13', 'db_key', '索引关键字', 'varchar(50)', 'String', 'dbKey', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 2, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (247, '13', 'description', '描述', 'varchar(50)', 'String', 'description', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 3, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (248, '13', 'driver_class', '驱动', 'varchar(50)', 'String', 'driverClass', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 4, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (249, '13', 'url', 'URL', 'varchar(200)', 'String', 'url', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 5, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (250, '13', 'db_user', '帐号', 'varchar(50)', 'String', 'dbUser', '0', '0', '1', '1', '1', '1', '1', 'EQ', 'input', '', 6, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (251, '13', 'db_password', '密码', 'varchar(50)', 'String', 'dbPassword', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 7, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (252, '13', 'db_type', '数据库类型', 'varchar(50)', 'String', 'dbType', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'select', '', 8, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (253, '13', 'db_name', '数据库名称', 'varchar(50)', 'String', 'dbName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', '', 9, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (254, '13', 'create_by', 'create_by', 'varchar(32)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 10, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (255, '13', 'create_time', 'create_date', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', '', 11, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (256, '13', 'update_by', 'update_by', 'varchar(32)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', '', 12, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (257, '13', 'update_time', 'update_date', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', '', 13, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (258, '13', 'remarks', 'remarks', 'varchar(255)', 'String', 'remarks', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'input', '', 14, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');
INSERT INTO `gen_table_column` VALUES (259, '13', 'del_flag', 'del_flag', 'char(1)', 'String', 'delFlag', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', '', 15, 'admin', '2021-04-12 11:14:26', '', '2021-04-12 17:12:26');

-- ----------------------------
-- Table structure for gen_template
-- ----------------------------
DROP TABLE IF EXISTS `gen_template`;
CREATE TABLE `gen_template`  (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称',
  `file_Name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `target_package` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标包路径',
  `template_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板内容',
  `scheme_id` int(32) NULL DEFAULT NULL COMMENT '方案ID',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `template_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成模板管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_template
-- ----------------------------
INSERT INTO `gen_template` VALUES (22, 'service', 'I{}Service', 'service', 'package ${packageName}.service;\n\nimport com.baomidou.mybatisplus.extension.service.IService;\nimport ${packageName}.domain.${ClassName};\n\nimport java.util.List;\n\n/**\n * ${functionName}组管理Service接口\n *\n * @author ruoyi\n * @date 2020-12-24\n */\npublic interface I${ClassName}Service extends IService<${ClassName}> {\n\n\n    /**\n     * 查询${functionName}组管理列表\n     *\n     * @param ${ClassName} ${functionName}组管理\n     * @return ${functionName}组管理集合\n     */\n    List<${ClassName}> select${ClassName}List(${ClassName} ${className});\n\n\n}\n', 1, '0', 'admin', '2020-06-19 11:37:30', 'admin', '2020-07-20 15:38:24', '1');
INSERT INTO `gen_template` VALUES (23, 'domain', '{}', 'domain', 'package ${packageName}.domain;\n\n    #foreach ($import in $importList)\n    import ${import};\n    #end\nimport org.apache.commons.lang3.builder.ToStringBuilder;\nimport org.apache.commons.lang3.builder.ToStringStyle;\nimport com.ruoyi.framework.aspectj.lang.annotation.Excel;\n    #if($table.crud)\n    import com.ruoyi.framework.web.domain.BaseEntity;\n    #elseif($table.tree)\n    import com.ruoyi.framework.web.domain.TreeEntity;\n    #end\nimport io.swagger.annotations.ApiModelProperty;\nimport java.util.Date;\nimport com.alibaba.excel.annotation.ExcelProperty;\nimport com.ruoyi.framework.web.domain.BaseZrdEntity;\nimport lombok.AllArgsConstructor;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\nimport com.ruoyi.common.enums.TranslateAnnotation;\nimport javax.validation.constraints.NotBlank;\nimport javax.validation.constraints.NotNull;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.Id;\nimport java.io.Serializable;\nimport io.swagger.annotations.ApiModel;\nimport com.alibaba.excel.annotation.ExcelIgnoreUnannotated;\n/**\n * ${functionName}对象 ${tableName}\n *\n * @author ${author}\n * @date ${datetime}\n */\n#if($table.crud)\n    #set($Entity=\"BaseEntity\")\n#elseif($table.tree)\n    #set($Entity=\"TreeEntity\")\n#end\n@ApiModel(\"${functionName}\")\n@Data\n@AllArgsConstructor\n@NoArgsConstructor\n@ExcelIgnoreUnannotated\npublic class ${ClassName}  extends BaseZrdEntity implements Serializable\n        {\nprivate static final long serialVersionUID = 1L;\n\n#foreach ($column in $columns)\n#if(!$table.isSuperColumn($column.javaField))\n/** $column.columnComment */\n    #if($column.list)\n        #set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n        #if($parentheseIndex != -1)\n            #set($comment=$column.columnComment.substring(0, $parentheseIndex))\n        #else\n            #set($comment=$column.columnComment)\n        #end\n        #if($parentheseIndex != -1)\n        \n        #elseif($column.javaType == \'Date\')\n        @JsonFormat(pattern = \"yyyy-MM-dd\")\n       \n        #else\n		@ExcelProperty(\"${comment}\")\n        #end\n        #if(${column.javaField}==\'id\')\n        @Id\n        @GeneratedValue(generator = \"JDBC\")\n        #end\n        #if(${column.dictType} != \'\')\n        @TranslateAnnotation(filed = \"${column.javaField}Name}\",  distCode = \"${column.dictType}\")\n        #end\n        #if($column.isRequired)\n            #if($column.javaType==\'String\')\n            @NotBlank(message = \"请输入${comment}\")\n            #else\n            @NotNull(message = \"请输入${comment}\")\n            #end\n        #end\n    #end\n@ApiModelProperty(value = \"${comment}\"  #if($column.javaField.isRequired) , required = true  #end)\nprivate $column.javaType $column.javaField;\n\n#end\n#end\n\n\n\n}\n', 1, '0', 'admin', '2020-06-19 13:41:45', 'admin', '2020-08-28 15:21:28', '1');
INSERT INTO `gen_template` VALUES (24, 'serviceImpl', '{}ServiceImpl', 'service/impl', 'package ${packageName}.service.impl;\n\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport ${packageName}.domain.${ClassName};\nimport ${packageName}.mapper.${ClassName}Mapper;\nimport ${packageName}.service.I${ClassName}Service;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.stereotype.Service;\n\nimport java.util.List;\n\n/**\n * ${functionName}组管理Service业务层处理\n *\n * @author ruoyi\n * @date 2020-12-24\n */\n@Service\npublic class ${ClassName}ServiceImpl extends ServiceImpl<${ClassName}Mapper, ${ClassName}> implements I${ClassName}Service {\n    @Autowired\n    private ${ClassName}Mapper ${className}Mapper;\n\n\n    /**\n     * 查询${functionName}组管理列表\n     *\n     * @param ${className} ${functionName}组管理\n     * @return ${functionName}组管理\n     */\n    @Override\n    public List<${ClassName}> select${ClassName}List(${ClassName} ${className}) {\n        return ${className}Mapper.select${ClassName}List(${className});\n    }\n\n\n}\n', 1, '0', 'admin', '2020-06-19 13:44:23', 'admin', '2020-07-20 15:39:13', '1');
INSERT INTO `gen_template` VALUES (25, 'Controller', '{}Controller', 'controller', 'package ${packageName}.controller;\n\nimport com.common.zrd.json.CommonJsonResult;\nimport com.ruoyi.common.core.utils.poi.ExcelUtil;\nimport com.ruoyi.common.core.web.controller.BaseController;\nimport com.ruoyi.common.core.web.domain.AjaxResult;\nimport com.ruoyi.common.core.web.page.TableDataInfo;\nimport com.ruoyi.common.log.annotation.Log;\nimport com.ruoyi.common.log.enums.BusinessType;\nimport com.ruoyi.common.security.annotation.PreAuthorize;\nimport ${packageName}.domain.${ClassName};\nimport ${packageName}.domain.entity.${ClassName}Entity;\nimport ${packageName}.service.I${ClassName}Service;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.*;\n\nimport javax.servlet.http.HttpServletResponse;\nimport java.io.IOException;\nimport java.util.Arrays;\nimport java.util.List;\n\n/**\n * ${functionName}Controller\n *\n * @author ruoyi\n * @date 2020-12-24\n */\n@RestController\n@RequestMapping(\"/${businessName}\" )\npublic class ${ClassName}Controller extends BaseController {\n    @Autowired\n    private I${ClassName}Service ${className}Service;\n\n    /**\n     * 查询${functionName}列表\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:list\" )\n    @GetMapping(\"/list\" )\n    public TableDataInfo list(${ClassName}Entity ${className}) {\n        startPage();\n        List<${ClassName}Entity> list = ${className}Service.select${ClassName}List(${className});\n        return getDataTable(list, ${ClassName}Entity.class);\n    }\n\n    /**\n     * 导出${functionName}列表\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:export\" )\n    @Log(title = \"${functionName}\" , businessType = BusinessType.EXPORT)\n    @PostMapping(\"/export\" )\n    public void export(HttpServletResponse response, ${ClassName}Entity ${className}) throws IOException {\n        List<${ClassName}Entity> list = ${className}Service.select${ClassName}List(${className});\n        ExcelUtil<${ClassName}Entity> util = new ExcelUtil<>(${ClassName}Entity.class);\n        util.exportExcel(response, list, \"template\" );\n    }\n\n    /**\n     * 获取${functionName}详细信息\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:query\" )\n    @GetMapping(value = \"/{id}\" )\n    public AjaxResult getInfo(@PathVariable(\"id\" ) Long id) {\n        return AjaxResult.success(${className}Service.getById(id));\n    }\n\n    /**\n     * 新增${functionName}\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:add\" )\n    @Log(title = \"${functionName}\" , businessType = BusinessType.INSERT)\n    @PostMapping\n    public CommonJsonResult add(@RequestBody ${ClassName} ${className}) {\n        ${className}Service.save(${className});\n        return CommonJsonResult.of(${className});\n    }\n\n    /**\n     * 修改${functionName}\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:edit\" )\n    @Log(title = \"${functionName}\" , businessType = BusinessType.UPDATE)\n    @PutMapping\n    public CommonJsonResult edit(@RequestBody ${ClassName} ${className}) {\n        ${className}Service.updateById(${className});\n        return CommonJsonResult.of(${className});\n    }\n\n    /**\n     * 删除${functionName}\n     */\n    @PreAuthorize(hasPermi = \"${permissionPrefix}:remove\" )\n    @Log(title = \"${functionName}\" , businessType = BusinessType.DELETE)\n    @DeleteMapping(\"/{ids}\" )\n    public CommonJsonResult remove(@PathVariable Long[] ids) {\n\n        ${className}Service.removeByIds(Arrays.asList(ids));\n        return CommonJsonResult.empty();\n    }\n}\n', 1, '0', 'admin', '2020-06-19 13:44:54', 'admin', '2020-07-20 15:36:52', '1');
INSERT INTO `gen_template` VALUES (26, 'Mapper', '{}Mapper', 'mapper', 'package com.ruoyi.gen.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport com.ruoyi.gen.domain.${ClassName};\n\nimport java.util.List;\n\n/**\n * ${functionName}Mapper接口\n *\n * @author ${author}\n * @date ${datetime}\n */\npublic interface ${ClassName}Mapper extends BaseMapper<${ClassName}> {\n\n    /**\n     * 查询${functionName}组管理列表\n     *\n     * @param ${ClassName} ${functionName}组管理\n     * @return ${functionName}组管理集合\n     */\n    List<${ClassName}> select${ClassName}List(${ClassName} ${className});\n\n\n}\n', 1, '0', 'admin', '2020-06-19 13:45:28', 'admin', '2020-08-26 16:25:15', '1');
INSERT INTO `gen_template` VALUES (27, 'xml', '{}Mapper', NULL, '<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\nPUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\n\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\">\n<mapper namespace=\"${packageName}.mapper.${ClassName}Mapper\">\n    \n  \n\n    <sql id=\"select${ClassName}Vo\">\n        select#foreach($column in $columns) t.$column.columnName  $column.javaField #if($velocityCount != $columns.size()),#end#end from ${tableName} t\n    </sql>\n\n    <select id=\"select${ClassName}List\" parameterType=\"${ClassName}Entity\"    resultType=\"${ClassName}Entity\">\n        <include refid=\"select${ClassName}Vo\"/>\n        <where>  \n#foreach($column in $columns)\n#set($queryType=$column.queryType)\n#set($javaField=$column.javaField)\n#set($javaType=$column.javaType)\n#set($columnName=$column.columnName)\n#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n#if($column.query)\n#if($column.queryType == \"EQ\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName = #{$javaField}</if>\n#elseif($queryType == \"NE\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName != #{$javaField}</if>\n#elseif($queryType == \"GT\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName &gt; #{$javaField}</if>\n#elseif($queryType == \"GTE\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName &gt;= #{$javaField}</if>\n#elseif($queryType == \"LT\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName &lt; #{$javaField}</if>\n#elseif($queryType == \"LTE\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName &lt;= #{$javaField}</if>\n#elseif($queryType == \"IN\")   \n        <if test=\"${javaField}Arr != null  and ${javaField}Arr.length>0  \">and t.$columnName in\n            <foreach item=\"${javaField}Item\" collection=\"${javaField}Arr\" open=\"(\" separator=\",\" close=\")\">\n                #{${javaField}Item}\n            </foreach>\n        </if>\n#elseif($queryType == \"LIKE\")\n            <if test=\"$javaField != null #if($javaType == \'String\' ) and $javaField.trim() != \'\'#end\"> and t.$columnName like concat(\'%\', #{$javaField}, \'%\')</if>\n#elseif($queryType == \"BETWEEN\")\n            <if test=\"params.begin$AttrName != null and params.begin$AttrName != \'\' and params.end$AttrName != null and params.end$AttrName != \'\'\"> and t.$columnName between #{params.begin$AttrName} and #{params.end$AttrName}</if>\n#end\n#end\n#end\n        </where>\n    </select>\n\n\n</mapper>', 1, '0', 'admin', '2020-06-19 13:46:44', 'admin', '2020-09-23 17:50:02', '2');
INSERT INTO `gen_template` VALUES (28, 'JS', '{}', NULL, 'import request from \'@/utils/request\'\n\n// 查询${functionName}列表\nexport function list${BusinessName}(query) {\n  return request({\n    url: \'/${moduleName}/${businessName}/list\',\n    method: \'get\',\n    params: query\n  })\n}\n\n// 查询${functionName}详细\nexport function get${BusinessName}(${pkColumn.javaField}) {\n  return request({\n    url: \'/${moduleName}/${businessName}/\' + ${pkColumn.javaField},\n    method: \'get\'\n  })\n}\n\n// 新增${functionName}\nexport function add${BusinessName}(data) {\n  return request({\n    url: \'/${moduleName}/${businessName}\',\n    method: \'post\',\n    data: data\n  })\n}\n\n// 修改${functionName}\nexport function update${BusinessName}(data) {\n  return request({\n    url: \'/${moduleName}/${businessName}\',\n    method: \'put\',\n    data: data\n  })\n}\n\n// 删除${functionName}\nexport function del${BusinessName}(${pkColumn.javaField}) {\n  return request({\n    url: \'/${moduleName}/${businessName}/\' + ${pkColumn.javaField},\n    method: \'delete\'\n  })\n}\n\n// 导出${functionName}\nexport function export${BusinessName}(query) {\n  return request({\n    url: \'/${moduleName}/${businessName}/export\',\n    method: \'get\',\n    params: query\n  })\n}', 1, '0', 'admin', '2020-06-19 13:47:31', NULL, NULL, '4');
INSERT INTO `gen_template` VALUES (29, 'vue', '{}index', NULL, '<template>\n  <div class=\"app-container\">\n    <el-form :model=\"queryParams\" ref=\"queryForm\" :inline=\"true\" v-show=\"showSearch\" label-width=\"68px\">\n#foreach($column in $columns)\n#if($column.query)\n#set($dictType=$column.dictType)\n#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n#if($column.htmlType == \"input\")\n      <el-form-item label=\"${comment}\" prop=\"${column.javaField}\">\n        <el-input\n          v-model=\"queryParams.${column.javaField}\"\n          placeholder=\"请输入${comment}\"\n          clearable\n          size=\"small\"\n          @keyup.enter.native=\"handleQuery\"\n        />\n      </el-form-item>\n#elseif(($column.htmlType == \"select\" || $column.htmlType == \"radio\") && \"\" != $dictType)\n      <el-form-item label=\"${comment}\" prop=\"${column.javaField}\">\n        <el-select v-model=\"queryParams.${column.javaField}\" placeholder=\"请选择${comment}\" clearable size=\"small\">\n          <el-option\n            v-for=\"dict in ${column.javaField}Options\"\n            :key=\"dict.dictValue\"\n            :label=\"dict.dictLabel\"\n            :value=\"dict.dictValue\"\n          />\n        </el-select>\n      </el-form-item>\n#elseif(($column.htmlType == \"select\" || $column.htmlType == \"radio\") && $dictType)\n      <el-form-item label=\"${comment}\" prop=\"${column.javaField}\">\n        <el-select v-model=\"queryParams.${column.javaField}\" placeholder=\"请选择${comment}\" clearable size=\"small\">\n          <el-option label=\"请选择字典生成\" value=\"\" />\n        </el-select>\n      </el-form-item>\n#elseif($column.htmlType == \"datetime\" && $column.queryType != \"BETWEEN\")\n      <el-form-item label=\"${comment}\" prop=\"${column.javaField}\">\n        <el-date-picker clearable size=\"small\"\n          v-model=\"queryParams.${column.javaField}\"\n          type=\"date\"\n          value-format=\"yyyy-MM-dd\"\n          placeholder=\"选择${comment}\">\n        </el-date-picker>\n      </el-form-item>\n#elseif($column.htmlType == \"datetime\" && $column.queryType == \"BETWEEN\")\n      <el-form-item label=\"${comment}\">\n        <el-date-picker\n          v-model=\"daterange${AttrName}\"\n          size=\"small\"\n          style=\"width: 240px\"\n          value-format=\"yyyy-MM-dd\"\n          type=\"daterange\"\n          range-separator=\"-\"\n          start-placeholder=\"开始日期\"\n          end-placeholder=\"结束日期\"\n        ></el-date-picker>\n      </el-form-item>\n#end\n#end\n#end\n      <el-form-item>\n        <el-button type=\"primary\" icon=\"el-icon-search\" size=\"mini\" @click=\"handleQuery\">搜索</el-button>\n        <el-button icon=\"el-icon-refresh\" size=\"mini\" @click=\"resetQuery\">重置</el-button>\n      </el-form-item>\n    </el-form>\n\n    <el-row :gutter=\"10\" class=\"mb8\">\n      <el-col :span=\"1.5\">\n        <el-button\n          type=\"primary\"\n          plain\n          icon=\"el-icon-plus\"\n          size=\"mini\"\n          @click=\"handleAdd\"\n          v-hasPermi=\"[\'${moduleName}:${businessName}:add\']\"\n        >新增</el-button>\n      </el-col>\n      <el-col :span=\"1.5\">\n        <el-button\n          type=\"success\"\n          plain\n          icon=\"el-icon-edit\"\n          size=\"mini\"\n          :disabled=\"single\"\n          @click=\"handleUpdate\"\n          v-hasPermi=\"[\'${moduleName}:${businessName}:edit\']\"\n        >修改</el-button>\n      </el-col>\n      <el-col :span=\"1.5\">\n        <el-button\n          type=\"danger\"\n          plain\n          icon=\"el-icon-delete\"\n          size=\"mini\"\n          :disabled=\"multiple\"\n          @click=\"handleDelete\"\n          v-hasPermi=\"[\'${moduleName}:${businessName}:remove\']\"\n        >删除</el-button>\n      </el-col>\n      <el-col :span=\"1.5\">\n        <el-button\n          type=\"warning\"\n          plain\n          icon=\"el-icon-download\"\n          size=\"mini\"\n          @click=\"handleExport\"\n          v-hasPermi=\"[\'${moduleName}:${businessName}:export\']\"\n        >导出</el-button>\n      </el-col>\n      <right-toolbar :showSearch.sync=\"showSearch\" @queryTable=\"getList\"></right-toolbar>\n    </el-row>\n\n    <el-table v-loading=\"loading\" :data=\"${businessName}List\" @selection-change=\"handleSelectionChange\">\n      <el-table-column type=\"selection\" width=\"55\" align=\"center\" />\n#foreach($column in $columns)\n#set($javaField=$column.javaField)\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n#if($column.pk)\n      <el-table-column label=\"${comment}\" align=\"center\" prop=\"${javaField}\" />\n#elseif($column.list && $column.htmlType == \"datetime\")\n      <el-table-column label=\"${comment}\" align=\"center\" prop=\"${javaField}\" width=\"180\">\n        <template slot-scope=\"scope\">\n          <span>{{ parseTime(scope.row.${javaField}, \'{y}-{m}-{d}\') }}</span>\n        </template>\n      </el-table-column>\n#elseif($column.list && \"\" != $column.dictType)\n      <el-table-column label=\"${comment}\" align=\"center\" prop=\"${javaField}\" :formatter=\"${javaField}Format\" />\n#elseif($column.list && \"\" != $javaField)\n      <el-table-column label=\"${comment}\" align=\"center\" prop=\"${javaField}\" />\n#end\n#end\n      <el-table-column label=\"操作\" align=\"center\" class-name=\"small-padding fixed-width\">\n        <template slot-scope=\"scope\">\n          <el-button\n            size=\"mini\"\n            type=\"text\"\n            icon=\"el-icon-edit\"\n            @click=\"handleUpdate(scope.row)\"\n            v-hasPermi=\"[\'${moduleName}:${businessName}:edit\']\"\n          >修改</el-button>\n          <el-button\n            size=\"mini\"\n            type=\"text\"\n            icon=\"el-icon-delete\"\n            @click=\"handleDelete(scope.row)\"\n            v-hasPermi=\"[\'${moduleName}:${businessName}:remove\']\"\n          >删除</el-button>\n        </template>\n      </el-table-column>\n    </el-table>\n    \n    <pagination\n      v-show=\"total>0\"\n      :total=\"total\"\n      :page.sync=\"queryParams.pageNum\"\n      :limit.sync=\"queryParams.pageSize\"\n      @pagination=\"getList\"\n    />\n\n    <!-- 添加或修改${functionName}对话框 -->\n    <el-dialog :title=\"title\" :visible.sync=\"open\" width=\"500px\" append-to-body>\n      <el-form ref=\"form\" :model=\"form\" :rules=\"rules\" label-width=\"80px\">\n#foreach($column in $columns)\n#set($field=$column.javaField)\n#if($column.insert && !$column.pk)\n#if(($column.usableColumn) || (!$column.superColumn))\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n#set($dictType=$column.dictType)\n#if($column.htmlType == \"input\")\n        <el-form-item label=\"${comment}\" prop=\"${field}\">\n          <el-input v-model=\"form.${field}\" placeholder=\"请输入${comment}\" />\n        </el-form-item>\n#elseif($column.htmlType == \"imageUpload\")\n        <el-form-item label=\"${comment}\">\n          <imageUpload v-model=\"form.${field}\"/>\n        </el-form-item>\n#elseif($column.htmlType == \"fileUpload\")\n        <el-form-item label=\"${comment}\">\n          <fileUpload v-model=\"form.${field}\"/>\n        </el-form-item>\n#elseif($column.htmlType == \"editor\")\n        <el-form-item label=\"${comment}\">\n          <editor v-model=\"form.${field}\" :min-height=\"192\"/>\n        </el-form-item>\n#elseif($column.htmlType == \"select\" && \"\" != $dictType)\n        <el-form-item label=\"${comment}\" prop=\"${field}\">\n          <el-select v-model=\"form.${field}\" placeholder=\"请选择${comment}\">\n            <el-option\n              v-for=\"dict in ${field}Options\"\n              :key=\"dict.dictValue\"\n              :label=\"dict.dictLabel\"\n              #if($column.javaType == \"Integer\" || $column.javaType == \"Long\"):value=\"parseInt(dict.dictValue)\"#else:value=\"dict.dictValue\"#end\n\n            ></el-option>\n          </el-select>\n        </el-form-item>\n#elseif($column.htmlType == \"select\" && $dictType)\n        <el-form-item label=\"${comment}\" prop=\"${field}\">\n          <el-select v-model=\"form.${field}\" placeholder=\"请选择${comment}\">\n            <el-option label=\"请选择字典生成\" value=\"\" />\n          </el-select>\n        </el-form-item>\n#elseif($column.htmlType == \"checkbox\" && \"\" != $dictType)\n        <el-form-item label=\"${comment}\">\n          <el-checkbox-group v-model=\"form.${field}\">\n            <el-checkbox\n              v-for=\"dict in ${field}Options\"\n              :key=\"dict.dictValue\"\n              :label=\"dict.dictValue\">\n              {{dict.dictLabel}}\n            </el-checkbox>\n          </el-checkbox-group>\n        </el-form-item>\n#elseif($column.htmlType == \"checkbox\" && $dictType)\n        <el-form-item label=\"${comment}\">\n          <el-checkbox-group v-model=\"form.${field}\">\n            <el-checkbox>请选择字典生成</el-checkbox>\n          </el-checkbox-group>\n        </el-form-item>\n#elseif($column.htmlType == \"radio\" && \"\" != $dictType)\n        <el-form-item label=\"${comment}\">\n          <el-radio-group v-model=\"form.${field}\">\n            <el-radio\n              v-for=\"dict in ${field}Options\"\n              :key=\"dict.dictValue\"\n              #if($column.javaType == \"Integer\" || $column.javaType == \"Long\"):label=\"parseInt(dict.dictValue)\"#else:label=\"dict.dictValue\"#end\n\n            >{{dict.dictLabel}}</el-radio>\n          </el-radio-group>\n        </el-form-item>\n#elseif($column.htmlType == \"radio\" && $dictType)\n        <el-form-item label=\"${comment}\">\n          <el-radio-group v-model=\"form.${field}\">\n            <el-radio label=\"1\">请选择字典生成</el-radio>\n          </el-radio-group>\n        </el-form-item>\n#elseif($column.htmlType == \"datetime\")\n        <el-form-item label=\"${comment}\" prop=\"${field}\">\n          <el-date-picker clearable size=\"small\"\n            v-model=\"form.${field}\"\n            type=\"date\"\n            value-format=\"yyyy-MM-dd\"\n            placeholder=\"选择${comment}\">\n          </el-date-picker>\n        </el-form-item>\n#elseif($column.htmlType == \"textarea\")\n        <el-form-item label=\"${comment}\" prop=\"${field}\">\n          <el-input v-model=\"form.${field}\" type=\"textarea\" placeholder=\"请输入内容\" />\n        </el-form-item>\n#end\n#end\n#end\n#end\n#if($table.sub)\n        <el-divider content-position=\"center\">${subTable.functionName}信息</el-divider>\n        <el-row :gutter=\"10\" class=\"mb8\">\n          <el-col :span=\"1.5\">\n            <el-button type=\"primary\" icon=\"el-icon-plus\" size=\"mini\" @click=\"handleAdd${subClassName}\">添加</el-button>\n          </el-col>\n          <el-col :span=\"1.5\">\n            <el-button type=\"danger\" icon=\"el-icon-delete\" size=\"mini\" @click=\"handleDelete${subClassName}\">删除</el-button>\n          </el-col>\n        </el-row>\n        <el-table :data=\"${subclassName}List\" :row-class-name=\"row${subClassName}Index\" @selection-change=\"handle${subClassName}SelectionChange\" ref=\"${subclassName}\">\n          <el-table-column type=\"selection\" width=\"50\" align=\"center\" />\n          <el-table-column label=\"序号\" align=\"center\" prop=\"index\" width=\"50\"/>\n#foreach($column in $subTable.columns)\n#set($javaField=$column.javaField)\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n#if($column.pk || $javaField == ${subTableFkclassName})\n#elseif($column.list && \"\" != $javaField)\n          <el-table-column label=\"$comment\" prop=\"${javaField}\">\n            <template slot-scope=\"scope\">\n              <el-input v-model=\"scope.row.$javaField\" placeholder=\"请输入$comment\" />\n            </template>\n          </el-table-column>\n#end\n#end\n        </el-table>\n#end\n      </el-form>\n      <div slot=\"footer\" class=\"dialog-footer\">\n        <el-button type=\"primary\" @click=\"submitForm\">确 定</el-button>\n        <el-button @click=\"cancel\">取 消</el-button>\n      </div>\n    </el-dialog>\n  </div>\n</template>\n\n<script>\nimport { list${BusinessName}, get${BusinessName}, del${BusinessName}, add${BusinessName}, update${BusinessName} } from \"@/api/${moduleName}/${businessName}\";\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"imageUpload\")\nimport ImageUpload from \'@/components/ImageUpload\';\n#break\n#end\n#end\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"fileUpload\")\nimport FileUpload from \'@/components/FileUpload\';\n#break\n#end\n#end\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"editor\")\nimport Editor from \'@/components/Editor\';\n#break\n#end\n#end\n\nexport default {\n  name: \"${BusinessName}\",\n  components: {\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"imageUpload\")\n    ImageUpload,\n#break\n#end\n#end\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"fileUpload\")\n    FileUpload,\n#break\n#end\n#end\n#foreach($column in $columns)\n#if($column.insert && !$column.superColumn && !$column.pk && $column.htmlType == \"editor\")\n    Editor,\n#break\n#end\n#end\n  },\n  data() {\n    return {\n      // 遮罩层\n      loading: true,\n      // 选中数组\n      ids: [],\n#if($table.sub)\n      // 子表选中数据\n      checked${subClassName}: [],\n#end\n      // 非单个禁用\n      single: true,\n      // 非多个禁用\n      multiple: true,\n      // 显示搜索条件\n      showSearch: true,\n      // 总条数\n      total: 0,\n      // ${functionName}表格数据\n      ${businessName}List: [],\n#if($table.sub)\n      // ${subTable.functionName}表格数据\n      ${subclassName}List: [],\n#end\n      // 弹出层标题\n      title: \"\",\n      // 是否显示弹出层\n      open: false,\n#foreach ($column in $columns)\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n#if(${column.dictType} != \'\')\n      // $comment字典\n      ${column.javaField}Options: [],\n#elseif($column.htmlType == \"datetime\" && $column.queryType == \"BETWEEN\")\n#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n      // $comment时间范围\n      daterange${AttrName}: [],\n#end\n#end\n      // 查询参数\n      queryParams: {\n        pageNum: 1,\n        pageSize: 10,\n#foreach ($column in $columns)\n#if($column.query)\n        $column.javaField: null#if($velocityCount != $columns.size()),#end\n\n#end\n#end\n      },\n      // 表单参数\n      form: {},\n      // 表单校验\n      rules: {\n#foreach ($column in $columns)\n#if($column.required)\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n        $column.javaField: [\n          { required: true, message: \"$comment不能为空\", trigger: #if($column.htmlType == \"select\")\"change\"#else\"blur\"#end }\n        ]#if($velocityCount != $columns.size()),#end\n\n#end\n#end\n      }\n    };\n  },\n  created() {\n    this.getList();\n#foreach ($column in $columns)\n#if(${column.dictType} != \'\')\n    this.getDicts(\"${column.dictType}\").then(response => {\n      this.${column.javaField}Options = response.data;\n    });\n#end\n#end\n  },\n  methods: {\n    /** 查询${functionName}列表 */\n    getList() {\n      this.loading = true;\n#foreach ($column in $columns)\n#if($column.htmlType == \"datetime\" && $column.queryType == \"BETWEEN\")\n      this.queryParams.params = {};\n#break\n#end\n#end\n#foreach ($column in $columns)\n#if($column.htmlType == \"datetime\" && $column.queryType == \"BETWEEN\")\n#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n      if (null != this.daterange${AttrName} && \'\' != this.daterange${AttrName}) {\n        this.queryParams.params[\"begin${AttrName}\"] = this.daterange${AttrName}[0];\n        this.queryParams.params[\"end${AttrName}\"] = this.daterange${AttrName}[1];\n      }\n#end\n#end\n      list${BusinessName}(this.queryParams).then(response => {\n        this.${businessName}List = response.rows;\n        this.total = response.total;\n        this.loading = false;\n      });\n    },\n#foreach ($column in $columns)\n#if(${column.dictType} != \'\')\n#set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n#if($parentheseIndex != -1)\n#set($comment=$column.columnComment.substring(0, $parentheseIndex))\n#else\n#set($comment=$column.columnComment)\n#end\n    // $comment字典翻译\n    ${column.javaField}Format(row, column) {\n      return this.selectDictLabel#if($column.htmlType == \"checkbox\")s#end(this.${column.javaField}Options, row.${column.javaField});\n    },\n#end\n#end\n    // 取消按钮\n    cancel() {\n      this.open = false;\n      this.reset();\n    },\n    // 表单重置\n    reset() {\n      this.form = {\n#foreach ($column in $columns)\n#if($column.htmlType == \"radio\")\n        $column.javaField: #if($column.javaType == \"Integer\" || $column.javaType == \"Long\")0#else\"0\"#end#if($velocityCount != $columns.size()),#end\n\n#elseif($column.htmlType == \"checkbox\")\n        $column.javaField: []#if($velocityCount != $columns.size()),#end\n\n#else\n        $column.javaField: null#if($velocityCount != $columns.size()),#end\n\n#end\n#end\n      };\n#if($table.sub)\n      this.${subclassName}List = [];\n#end\n      this.resetForm(\"form\");\n    },\n    /** 搜索按钮操作 */\n    handleQuery() {\n      this.queryParams.pageNum = 1;\n      this.getList();\n    },\n    /** 重置按钮操作 */\n    resetQuery() {\n#foreach ($column in $columns)\n#if($column.htmlType == \"datetime\" && $column.queryType == \"BETWEEN\")\n#set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n      this.daterange${AttrName} = [];\n#end\n#end\n      this.resetForm(\"queryForm\");\n      this.handleQuery();\n    },\n    // 多选框选中数据\n    handleSelectionChange(selection) {\n      this.ids = selection.map(item => item.${pkColumn.javaField})\n      this.single = selection.length!==1\n      this.multiple = !selection.length\n    },\n    /** 新增按钮操作 */\n    handleAdd() {\n      this.reset();\n      this.open = true;\n      this.title = \"添加${functionName}\";\n    },\n    /** 修改按钮操作 */\n    handleUpdate(row) {\n      this.reset();\n      const ${pkColumn.javaField} = row.${pkColumn.javaField} || this.ids\n      get${BusinessName}(${pkColumn.javaField}).then(response => {\n        this.form = response.data;\n#foreach ($column in $columns)\n#if($column.htmlType == \"checkbox\")\n        this.form.$column.javaField = this.form.${column.javaField}.split(\",\");\n#end\n#end\n#if($table.sub)\n        this.${subclassName}List = response.data.${subclassName}List;\n#end\n        this.open = true;\n        this.title = \"修改${functionName}\";\n      });\n    },\n    /** 提交按钮 */\n    submitForm() {\n      this.#[[$]]#refs[\"form\"].validate(valid => {\n        if (valid) {\n#foreach ($column in $columns)\n#if($column.htmlType == \"checkbox\")\n          this.form.$column.javaField = this.form.${column.javaField}.join(\",\");\n#end\n#end\n#if($table.sub)\n          this.form.${subclassName}List = this.${subclassName}List;\n#end\n          if (this.form.${pkColumn.javaField} != null) {\n            update${BusinessName}(this.form).then(response => {\n              this.msgSuccess(\"修改成功\");\n              this.open = false;\n              this.getList();\n            });\n          } else {\n            add${BusinessName}(this.form).then(response => {\n              this.msgSuccess(\"新增成功\");\n              this.open = false;\n              this.getList();\n            });\n          }\n        }\n      });\n    },\n    /** 删除按钮操作 */\n    handleDelete(row) {\n      const ${pkColumn.javaField}s = row.${pkColumn.javaField} || this.ids;\n      this.$confirm(\'是否确认删除${functionName}编号为\"\' + ${pkColumn.javaField}s + \'\"的数据项?\', \"警告\", {\n          confirmButtonText: \"确定\",\n          cancelButtonText: \"取消\",\n          type: \"warning\"\n        }).then(function() {\n          return del${BusinessName}(${pkColumn.javaField}s);\n        }).then(() => {\n          this.getList();\n          this.msgSuccess(\"删除成功\");\n        })\n    },\n#if($table.sub)\n	/** ${subTable.functionName}序号 */\n    row${subClassName}Index({ row, rowIndex }) {\n      row.index = rowIndex + 1;\n    },\n    /** ${subTable.functionName}添加按钮操作 */\n    handleAdd${subClassName}() {\n      let obj = {};\n#foreach($column in $subTable.columns)\n#if($column.pk || $column.javaField == ${subTableFkclassName})\n#elseif($column.list && \"\" != $javaField)\n      obj.$column.javaField = \"\";\n#end\n#end\n      this.${subclassName}List.push(obj);\n    },\n    /** ${subTable.functionName}删除按钮操作 */\n    handleDelete${subClassName}() {\n      if (this.checked${subClassName}.length == 0) {\n        this.$alert(\"请先选择要删除的${subTable.functionName}数据\", \"提示\", { confirmButtonText: \"确定\", });\n      } else {\n        this.${subclassName}List.splice(this.checked${subClassName}[0].index - 1, 1);\n      }\n    },\n    /** 单选框选中数据 */\n    handle${subClassName}SelectionChange(selection) {\n      if (selection.length > 1) {\n        this.$refs.${subclassName}.clearSelection();\n        this.$refs.${subclassName}.toggleRowSelection(selection.pop());\n      } else {\n        this.checked${subClassName} = selection;\n      }\n    },\n#end\n    /** 导出按钮操作 */\n    handleExport() {\n      this.download(\'${moduleName}/${businessName}/export\', {\n        ...this.queryParams\n      }, `${moduleName}_${businessName}.xlsx`)\n    }\n  }\n};\n</script>', 1, '0', 'admin', '2020-06-19 13:47:57', 'admin', '2020-07-20 15:54:01', '3');
INSERT INTO `gen_template` VALUES (34, '更改合同', '{}data', NULL, '<!--\n * @Author: daifen\n * @Date: 2020-06-30 11:34:30\n * @LastEditors: daifen\n--> \n<template>\n  <div class=\"appointmentWhole\">\n    <div class=\"appointmentTop\">\n      <el-button\n        @click=\"saveTaskForm\"\n        type=\"primary\"\n        v-if=\"(taskNowStatus==0||taskNowStatus==1)&checkFalg\"\n      >保存</el-button>\n      <el-button\n        @click=\"sendTaskForm\"\n        type=\"primary\"\n        v-if=\"(taskNowStatus==0||taskNowStatus==1)&checkFalg\"\n      >发送</el-button>\n      <el-button icon=\"el-icon-printer\" type=\"primary\" v-print=\"\'#taskForm\'\">打印</el-button>\n      <el-button type=\"primary\" icon=\"el-icon-paperclip\" @click=\"enclosure\">附件</el-button>\n      <el-button @click=\"taskRecordsShow\" type=\"primary\">流程记录</el-button>\n      <el-button @click=\"goback\" type=\"primary\">返回</el-button>\n      <el-button\n        @click=\"receiveTaskFlow\"\n        type=\"primary\"\n        v-if=\"(taskNowStatus==5||taskNowStatus==6)\"\n      >接收</el-button>\n    </div>\n    <div class=\"appointmentContent ix-hidden-scrollbar\">\n      <div class=\"processform\" id=\"taskForm\">\n        <div class=\"processName\">{{taskTypeName}}</div>\n        <el-form :model=\"taskForm\" :rules=\"rules\" ref=\"taskForm\">\n          #foreach($column in $columns)\n          <el-row class=\"commonTableLRB\">\n            #if($column.query)\n            #set($dictType=$column.dictType)\n            #set($AttrName=$column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})\n            #set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n            #if($parentheseIndex != -1)\n            #set($comment=$column.columnComment.substring(1, $parentheseIndex))\n            #else\n            #set($comment=$column.columnComment)\n            #end\n            #if($column.htmlType == \"input\")\n            <el-col :span=\"4\">\n              <p class=\"text-center\">${comment}</p>\n            </el-col>\n\n            <el-col :span=\"20\" class=\"commonTableLeftQuality\">\n              <el-form-item prop=\"${column.javaField}\">\n                <el-input\n                  v-model=\"taskForm.${column.javaField}\"\n                  placeholder=\"请输入${comment}\"\n                  clearable\n				  #if($column.javaType == \'Double\') type=\"number\"  #end\n                  size=\"small\"\n               \n                />\n              </el-form-item>\n            </el-col>#elseif(($column.htmlType == \"select\" || $column.htmlType == \"radio\") && \"\" != $dictType)\n            <el-col :span=\"4\">\n              <p  class=\"text-center\">${comment}</p>\n            </el-col>\n\n            <el-col :span=\"20\" class=\"commonTableLeftQuality\">\n              <el-form-item prop=\"${column.javaField}\">\n               <common-select distType=\"$dictType\" v-model=\"taskForm.${column.javaField}\" ></common-select>\n              </el-form-item>\n            </el-col>#elseif(($column.htmlType == \"select\" || $column.htmlType == \"radio\") && $dictType)\n            <el-col :span=\"4\">\n              <p  class=\"text-center\">${comment}</p>\n            </el-col>\n\n            <el-col :span=\"20\" class=\"commonTableLeftQuality\">\n              <el-form-item prop=\"${column.javaField}\">\n                <el-select\n                  v-model=\"taskForm.${column.javaField}\"\n                  placeholder=\"请选择${comment}\"\n                  clearable\n                  size=\"small\"\n                >\n                  <el-option label=\"请选择字典生成\" value />\n                </el-select>\n              </el-form-item>\n            </el-col>#elseif($column.htmlType == \"datetime\")\n            <el-col :span=\"4\">\n              <p  class=\"text-center\">${comment}</p>\n            </el-col>\n\n            <el-col :span=\"20\" class=\"commonTableLeftQuality\">\n              <el-form-item prop=\"${column.javaField}\">\n                <el-date-picker\n                  clearable\n                  size=\"small\"\n                  style=\"width: 200px\"\n                  v-model=\"taskForm.${column.javaField}\"\n                  type=\"date\"\n                  value-format=\"yyyy-MM-dd\"\n                  placeholder=\"选择${comment}\"\n                ></el-date-picker>\n              </el-form-item>\n            </el-col>\n#end\n            #end\n          </el-row>\n#end\n          <el-row class=\"commonTableContent\">\n            <el-col :span=\"4\" class=\"commonTableFileUpload\">附件</el-col>\n            <el-col :span=\"20\" class=\"enclosure\" style=\"height: 82px;overflow-y: scroll;\">\n              <common-upload\n                :uplodaData=\"uplodaData\"\n                :nowStep=\"nowStep\"\n                :firstStepFalg=\"firstStepFalg\"\n                :taskMatterId=\"taskMatterId\"\n                :fileUploads=\"fileUploads\"\n                ref=\"uplodas\"\n              ></common-upload>\n            </el-col>\n          </el-row>\n\n          <el-row class=\"commonTableLRB\" v-for=\"(v,i) in distList\" v-if=\"v.needSign==\'0\'\">\n            <el-col :span=\"4\" class=\"commonColTextQuality\">{{distList[i].taskRoleName}}意见</el-col>\n            <el-col :span=\"20\" class=\"commonTableLeftQuality\">\n              <el-row>\n                <el-col :span=\"24\">\n                  <el-input\n                    :disabled=\"nowStep!=(i+1)\"\n                    placeholder=\"请输入\"\n                    type=\"textarea\"\n                    v-model=\"distList[i].opinions\"\n                  ></el-input>\n                </el-col>\n              </el-row>\n              <el-row class=\"commonTableTop\">\n                <el-col :span=\"4\" class=\"commonColText\">{{distList[i].taskRoleName}}签字</el-col>\n                <el-col :span=\"8\" class=\"commonText commonTableLeftQuality\">\n                  <passmessage :disabled=\"nowStep!=(i+1)\" :signActive=\"distList[i].avatar\"></passmessage>\n                </el-col>\n                <el-col :span=\"6\" class=\"commonTableInput\">日期</el-col>\n                <el-col :span=\"6\" class=\"commonTableInput\">\n                  <el-date-picker\n                    :clearable=\"true\"\n                    :editable=\"true\"\n                    disabled=\"disabled\"\n                    style=\"width:90%;padding:0px 0px 1px 12px\"\n                    v-model=\"distList[i].shtime\"\n                  ></el-date-picker>\n                </el-col>\n              </el-row>\n            </el-col>\n          </el-row>\n        </el-form>\n\n        <div class=\"appointmentBottom\">\n          <el-steps\n            :active=\"nowStep-1\"\n            align-center\n            finish-status=\"finish\"\n            process-status=\"success\"\n          >\n            <el-step :title=\"dist.taskRoleName\" v-for=\"dist in distList\"></el-step>\n          </el-steps>\n        </div>\n\n        <process-record :allprojects=\"opinionsRecords\"></process-record>\n      </div>\n    </div>\n    <!-- 附件上传 -->\n    <el-dialog\n      title=\"附件上传\"\n      :visible.sync=\"enclosureModal\"\n      width=\"40%\"\n      height=\"300px\"\n      :before-close=\"acceptHandleClose\"\n    >\n      <common-upload-file :taskMatterId=\"taskMatterId\" type=\"2\"></common-upload-file>\n      <span slot=\"footer\" class=\"dialog-footer\">\n        <el-button @click=\"enclosureModal = false\">关闭</el-button>\n      </span>\n    </el-dialog>\n    <el-dialog\n      :before-close=\"acceptHandleClose\"\n      :title=\"taskTypeName\"\n      :visible.sync=\"opinionsRecordsShow\"\n      height=\"300px\"\n      width=\"40%\"\n    >\n      <p style=\"text-align: center;font-size:20px;padding-bottom: 20px;\">{{taskTypeName}}</p>\n      <option-record :optRecord=\"opinionsRecords\"></option-record>\n      <span class=\"dialog-footer\" slot=\"footer\">\n        <el-button @click=\"opinionsRecordsShow = false\">取 消</el-button>\n      </span>\n    </el-dialog>\n    <el-dialog\n      :before-close=\"close_dialog\"\n      :visible.sync=\"sendShow\"\n      height=\"300px\"\n      title=\"发送\"\n      width=\"40%\"\n    >\n      <send\n        :getMatterId=\"taskMatterId\"\n        :sendOption=\"sendOption\"\n        :sendStep=\"nowStep\"\n        :deptId=\"taskForm.cendandepartment\"\n        :stepInfo=\"distList\"\n        @close-dialogStatus=\"close_dialog\"\n        @onToggle=\"onToggle\"\n      ></send>\n    </el-dialog>\n  </div>\n</template>\n\n<script>\nimport {\n  getContract,\n  getOneProject,\n  saveProProjec,\n  sendProProjec\n} from \"@/api/projecttask/contract\";\n\nimport { getMatterInfo, receiveTaskFlow } from \"@/api/task/matter\";\nimport ProcessRecord from \"@/views/project/proapproval/processRecord\";\nimport OptionRecord from \"@/views/project/proapproval/optionRecord\";\nimport Send from \"@/views/project/proapproval/send\";\nimport { getToken } from \"@/utils/auth\";\nimport { delUpload } from \"@/api/task/upload\";\nimport passmessage from \"../../shared-common/passmessage\";\nimport CommonSelect from \"@/components/zrd/commonSelect\";\nimport commonUpload from \"@/components/Upload/upload\";\nimport commonUploadFile from \"@/components/df/commonUploadFile\";\nimport commonRadio from \"@/components/zrd/commonRadio\";\n\nvar vm;\nexport default {\n  name: \"taskapproval\",\n  data() {\n    return {\n      allprojects: [],\n      uplodaData: {},\n      taskType: \"3\",\n      taskTypeName: \"生产任务通知单\",\n      enclosureModal: false, //附件上传模态框\n      sendOption: null,\n      opinionsRecordsShow: false,\n      sendShow: false,\n      taskOpinionsRecordsId: 0,\n      taskNowStatus: undefined,\n      taskMatterId: null,\n      taskData: {},\n      distList: {},\n      fileUploads: {},\n      opinionsRecords: [],\n      nowStep: 1,\n            checkFalg: true,\n      firstStepFalg: true,\n      queryParams: {},\n      redioStatus: true,\n      rules: {\n	   #foreach ($column in $columns)\n                    #if($column.required)\n                        #set($parentheseIndex=$column.columnComment.indexOf(\"（\"))\n                        #if($parentheseIndex != -1)\n                            #set($comment=$column.columnComment.substring(0, $parentheseIndex))\n                        #else\n                            #set($comment=$column.columnComment)\n                        #end\n                        #set($comment=$column.columnComment)\n                        $column.javaField: [\n                        { required: true, message: \"$comment不能为空\", trigger: \"blur\" }\n                    ]#if($velocityCount != $columns.size()),#end\n\n                    #end\n                #end\n	   \n	  },\n      taskForm: {\n        #foreach ($column in $columns)\n\n                    $column.javaField: null,//$column.columnComment\n                #end\n      }\n    };\n  },\n\n  created() {\n    vm = this;\n    let a = this.$route.query.taskOpinionsRecordsId;\n    if (a) {\n      this.taskOpinionsRecordsId = a;\n      this.getMatterInfo(this.taskOpinionsRecordsId);\n    } else {\n      let tableId = this.$route.query.tableId;\n\n      this.getMatterInfo(null);\n      if (tableId) {\n        vm.getContract(tableId);\n      }\n    }\n \n  },\n  components: {\n    ProcessRecord,\n    OptionRecord,\n    CommonSelect,\n    Send,\n    passmessage,\n    commonUpload,\n    commonUploadFile,\n    commonRadio\n  },\n\n  methods: {\n    //点击附件\n    enclosure() {\n      this.enclosureModal = true;\n    },\n    selectedRadio() {\n      vm.redioStatus = true;\n    },\n    radioExistence() {\n      vm.redioStatus = false;\n    },\n    handleRemove(val) {\n      delUpload(val.id).then(response => {});\n    },\n\n    handlePreview(val) {\n      this.downloadFile(val.url);\n    },\n    goback() {\n      this.MMMrouter.go(-1);\n    },\n    close_dialog() {\n      this.sendShow = false;\n    },\n    onToggle(taskStep) {\n      this.sendShow = false;\n      this.taskForm.accountname = taskStep.accountname;\n      this.taskForm.opinions = taskStep.opinions;\n      this.taskForm.checkFlag = taskStep.checkFlag;\n      this.taskForm.userSign = taskStep.userSign;\n      this.taskForm.taskType = this.taskType;\n      this.taskForm.taskMatterId = this.taskMatterId;\n\n      sendProProjec(this.taskForm).then(response => {\n        this.MMMrefs.uplodas.uploadFile(response.data.taskMatterId3);\n        this.MMMrouter.push({ path: _cfg.sendTaskUrl });\n        this.msgSuccess(\"发送成功\");\n      });\n    },\n    getContract(id) {\n      getContract(id).then(response => {\n        const data = response.data;\n        this.taskForm.name = data.name;\n        this.taskForm.type = data.category;\n        this.taskForm.contractId = data.id;\n        this.taskForm.contractno = data.number;\n        this.taskForm.kind = data.projecttype;\n        this.taskForm.weituofang = data.wetuofang;\n        this.taskForm.owner = data.projectleader;\n        this.taskForm.tecowner = data.technicaldirector;\n        this.taskForm.takepartpeople = data.participant;\n        this.taskForm.projectmoney = data.contractmoney;\n        this.taskForm.proTypeTwo = data.proTypeTwo;\n        this.taskForm.cendandepartment = data.cendandepartment;\n        this.taskForm.askfinishdatestart = data.beginDate;\n        this.taskForm.askfinishdateend = data.enddate;\n      });\n    },\n    getMatterInfo(id) {\n      this.taskData.taskOpinionsRecordsId = id;\n      this.taskData.taskType = vm.taskType;\n\n      getMatterInfo(this.taskData).then(response => {\n        this.taskForm.taskMatterId = response.data.taskMatterId;\n        this.taskMatterId = response.data.taskMatterId;\n        this.taskNowStatus = response.data.taskStatus;\n        	          this.checkFalg = response.data.checkFalg;\n        this.firstStepFalg = response.data.firstStepFalg;\n        if (this.taskMatterId) {\n          this.get(this.taskMatterId);\n        }\n        console.log(response.data.taskOpinionsRecords);\n        this.distList = response.data.taskStepDistEntities;\n        const taskOpinionsRecords = response.data.taskOpinionsRecords;\n        for (let i = 0; i < taskOpinionsRecords.length; i++) {\n          taskOpinionsRecords[i].createTime = this.formatDuringMin(\n            taskOpinionsRecords[i].createTime\n          );\n          this.opinionsRecords.push(taskOpinionsRecords[i]);\n        }\n        this.nowStep = response.data.nowStep;\n        this.fileUploads = response.data.fileUploads;\n        if (this.nowStep) {\n          this.distList[this.nowStep - 1].shtime = new Date();\n        }\n      });\n    },\n    get(id) {\n      this.queryParams.taskMatterId = id;\n      this.queryParams.taskType = this.taskType;\n\n      getOneProject(this.queryParams).then(response => {\n        this.taskForm = response.data;\n      });\n    },\n\n    saveTaskForm() {\n      this.MMMrefs[\"taskForm\"].validate(valid => {\n        if (!valid) return;\n        this.taskForm.opinions = vm.distList[vm.nowStep - 1].opinions;\n        this.taskForm.taskType = this.taskType;\n        this.taskForm.taskMatterId = this.taskMatterId;\n        saveProProjec(this.taskForm).then(response => {\n          this.MMMrefs.uplodas.uploadFile(response.data.taskMatterId3);\n          this.MMMrouter.push({ path: _cfg.saveTaskUrl });\n          this.msgSuccess(\"保存成功\");\n        });\n      });\n    },\n    sendTaskForm() {\n      this.MMMrefs[\"taskForm\"].validate(valid => {\n        if (!valid) return;\n        vm.sendOption = vm.distList[vm.nowStep - 1].opinions;\n        this.sendShow = true;\n      });\n    },\n    taskRecordsShow() {\n      this.opinionsRecordsShow = true;\n    },\n    receiveTaskFlow() {\n      receiveTaskFlow(vm.taskOpinionsRecordsId).then(response => {\n        this.MMMrouter.push({ path: _cfg.sendTaskUrl });\n        this.msgSuccess(\"接收成功\");\n      });\n    },\n\n    acceptHandleClose(done) {\n      this.$confirm(\"确认关闭？\")\n        .then(_ => {\n          done();\n        })\n        .catch(_ => {});\n    },\n\n    resetForm() {\n      this.MMMrefs[\"taskForm\"].resetFields();\n    }\n  }\n};\n</script>\n\n<style lang=\"less\" scoped>\n@import \"~@/assets/styles/operation.less\";\n@import \"~@/assets/styles/taskapproval.css\";\n\n.el-input.is-disabled .el-input__inner {\n  color: #4299ed;\n}\n\n.el-input__icon .el-icon-date {\n  padding-left: 10px;\n}\n\n.appointmentBottom {\n  width: 100%;\n  height: calc(4% - 10px);\n  padding: 10px;\n  padding-top: 10px;\n}\n\n.el-input.is-disabled /deep/ .el-input__inner {\n  width: 95%;\n  margin: 0 auto;\n  color: #4299ed;\n}\n\n.commonTableLRB {\n  display: flex;\n  align-items: center;\n  justify-content: center;\n}\n\n.text-center {\n  text-align: center;\n}\n</style>\n\n', 1, '0', 'admin', '2020-07-03 11:55:15', 'admin', '2020-07-07 09:16:33', '3');
INSERT INTO `gen_template` VALUES (35, 'sql', '{}sql', NULL, '-- 菜单 SQL\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}\', \'${parentMenuId}\', \'1\', \'${businessName}\', \'${moduleName}/${businessName}/index\', 1, 0, \'C\', \'0\', \'0\', \'${permissionPrefix}:list\', \'#\', \'admin\', sysdate(), \'\', null, \'${functionName}菜单\');\n\n-- 按钮父菜单ID\nSELECT @parentId := LAST_INSERT_ID();\n\n-- 按钮 SQL\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}查询\', @parentId, \'1\',  \'#\', \'\', 1, 0, \'F\', \'0\', \'0\', \'${permissionPrefix}:query\',        \'#\', \'admin\', sysdate(), \'\', null, \'\');\n\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}新增\', @parentId, \'2\',  \'#\', \'\', 1, 0, \'F\', \'0\', \'0\', \'${permissionPrefix}:add\',          \'#\', \'admin\', sysdate(), \'\', null, \'\');\n\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}修改\', @parentId, \'3\',  \'#\', \'\', 1, 0, \'F\', \'0\', \'0\', \'${permissionPrefix}:edit\',         \'#\', \'admin\', sysdate(), \'\', null, \'\');\n\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}删除\', @parentId, \'4\',  \'#\', \'\', 1, 0, \'F\', \'0\', \'0\', \'${permissionPrefix}:remove\',       \'#\', \'admin\', sysdate(), \'\', null, \'\');\n\ninsert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)\nvalues(\'${functionName}导出\', @parentId, \'5\',  \'#\', \'\', 1, 0, \'F\', \'0\', \'0\', \'${permissionPrefix}:export\',       \'#\', \'admin\', sysdate(), \'\', null, \'\');', 1, '0', 'admin', '2020-07-06 18:13:42', 'admin', '2021-03-26 17:48:44', '5');
INSERT INTO `gen_template` VALUES (36, 'entity', '{}Entity', 'domain/entity', 'package ${packageName}.domain;\n\n    #foreach ($import in $importList)\n    import ${import};\n    #end\nimport org.apache.commons.lang3.builder.ToStringBuilder;\nimport org.apache.commons.lang3.builder.ToStringStyle;\nimport com.ruoyi.framework.aspectj.lang.annotation.Excel;\n    #if($table.crud)\n    import com.ruoyi.framework.web.domain.BaseEntity;\n    #elseif($table.tree)\n    import com.ruoyi.framework.web.domain.TreeEntity;\n    #end\nimport io.swagger.annotations.ApiModelProperty;\nimport java.util.Date;\nimport com.ruoyi.framework.web.domain.BaseZrdEntity;\nimport lombok.AllArgsConstructor;\nimport lombok.Data;\nimport lombok.NoArgsConstructor;\nimport com.ruoyi.common.enums.TranslateAnnotation;\nimport javax.validation.constraints.NotBlank;\nimport javax.validation.constraints.NotNull;\nimport javax.persistence.GeneratedValue;\nimport javax.persistence.Id;\nimport java.io.Serializable;\nimport io.swagger.annotations.ApiModel;\n/**\n * ${functionName}对象 ${tableName}\n *\n * @author ${author}\n * @date ${datetime}\n */\n\n@ApiModel(\"${functionName}\")\n@Data\n\npublic class ${ClassName}Entity  extends ${ClassName} \n        {\n\n#foreach ($column in $columns)\n        #if(${column.dictType} != \'\')\n      private $column.javaType ${column.javaField}Name;\n        #end\n		       #if(${column.queryType} == \'IN\')\n      private String[] ${column.javaField}Arr;\n        #end\n#end\n\n\n}\n', 1, '0', 'admin', '2020-06-19 13:41:45', 'admin', '2020-09-23 17:47:05', '1');

-- ----------------------------
-- Table structure for gen_template_scheme
-- ----------------------------
DROP TABLE IF EXISTS `gen_template_scheme`;
CREATE TABLE `gen_template_scheme`  (
  `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方案标题',
  `description` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方案描述',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成模板组管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gen_template_scheme
-- ----------------------------
INSERT INTO `gen_template_scheme` VALUES (1, '基础增删查改', '基础增删查改', '0', NULL, NULL, 'admin', '2020-06-19 14:01:13');
INSERT INTO `gen_template_scheme` VALUES (8, '增删改查001', '进行数据更新zrd', NULL, NULL, NULL, 'admin', '2021-01-21 10:57:34');

-- ----------------------------
-- Table structure for generator_data_source
-- ----------------------------
DROP TABLE IF EXISTS `generator_data_source`;
CREATE TABLE `generator_data_source`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `db_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '索引关键字',
  `description` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
  `driver_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驱动',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'URL',
  `db_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帐号',
  `db_password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `db_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库类型',
  `db_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库名称',
  `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'create_by',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT 'create_date',
  `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'update_by',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT 'update_date',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarks',
  `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'del_flag',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据源' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of generator_data_source
-- ----------------------------
INSERT INTO `generator_data_source` VALUES (3, 'sy', '展会', 'com.mysql.cj.jdbc.Driver', 'jdbc:mysql://192.168.0.234:3306/ry-gen?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8', 'root', '123456', NULL, 'ry-gen', NULL, NULL, 'admin', '2021-03-25 16:40:24', NULL, NULL);
INSERT INTO `generator_data_source` VALUES (4, 'wzg', '王志刚', 'com.mysql.cj.jdbc.Driver', 'jdbc:mysql://172.21.41.172:3306/myblog?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8', 'root', 'root', NULL, 'myblog', 'admin', '2021-03-25 16:33:38', 'admin', '2021-03-25 16:37:27', NULL, NULL);

-- ----------------------------
-- Table structure for p_activity_scene
-- ----------------------------
DROP TABLE IF EXISTS `p_activity_scene`;
CREATE TABLE `p_activity_scene`  (
  `SceneNo` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标注活动来源场景,如:\n            01:注册\n            02:转账\n            03:购买理财\n            04:分享\n            05:缴费\n            06:支付',
  `sceneDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `SCENECHANNELNO` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sceneName` varchar(42) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景名称',
  `sceneCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景码',
  `CREATETIME` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `CheckStatus` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '复核状态（0：待复核，1：已通过，2：已拒绝）',
  `USERSEQ` decimal(20, 0) NULL DEFAULT NULL,
  `DEPTSEQ` decimal(20, 0) NULL DEFAULT NULL,
  `IsNormal` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否正常（Y：正常，N：不可用）',
  `SceneType` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景类型  A:活动场景   E:事件场景',
  PRIMARY KEY (`SceneNo`) USING BTREE,
  UNIQUE INDEX `SCENECODE`(`sceneCode`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of p_activity_scene
-- ----------------------------

-- ----------------------------
-- Table structure for template_engine
-- ----------------------------
DROP TABLE IF EXISTS `template_engine`;
CREATE TABLE `template_engine`  (
  `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'id主键',
  `del_Flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识（0正常 1关闭）',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板名称',
  `template_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板编码',
  `json_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测试json',
  `template_content` blob NULL COMMENT '模板内容',
  `template_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板类型',
  `template_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板上传的地址',
  `results_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输出结果',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '导出模板管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of template_engine
-- ----------------------------

-- ----------------------------
-- Table structure for test_case
-- ----------------------------
DROP TABLE IF EXISTS `test_case`;
CREATE TABLE `test_case`  (
  `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'id主键',
  `del_Flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识（0正常 1关闭）',
  `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `theme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主题',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `parent_task` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级任务',
  `agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人',
  `priority` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优先级',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
  `solve_results` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '解决结果',
  `module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块',
  `expected_completion_time` datetime(0) NULL DEFAULT NULL COMMENT '期望完成时间',
  `original_estimate_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原估时间',
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 139 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '测试用例表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of test_case
-- ----------------------------
INSERT INTO `test_case` VALUES (100, '0', '', NULL, '', NULL, '测试用例-水印信息管理的界面查询', '任务', '1', '胡琴', '重要', '开始', '未解决', '111', NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (102, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据修改', '任务', '2551111111', '胡琴', '重要', '开始', '未解决', '12', NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (103, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (104, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (105, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (106, '0', '', NULL, '', NULL, '测试用例-产品评分表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (107, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (108, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (109, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (110, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (111, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (112, '0', '', NULL, '', NULL, '测试用例-产品收藏表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (113, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (114, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (115, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (116, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (117, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (118, '0', '', NULL, '', NULL, '测试用例-产品信息表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (119, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (120, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (121, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (122, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (123, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (124, '0', '', NULL, '', NULL, '测试用例-基础表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (125, '0', '', NULL, '', NULL, '测试用例-基础表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (126, '0', '', NULL, '', NULL, '测试用例-基础表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (127, '0', '', NULL, '', NULL, '测试用例-基础表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (128, '0', '', NULL, '', NULL, '测试用例-基础表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (129, '0', '', NULL, '', NULL, '测试用例-基础表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
INSERT INTO `test_case` VALUES (131, '0', '', NULL, '', NULL, '测试', '任务', '测试01', '胡琴', '重要', '1', '未解决', '测试', '2020-12-31 00:00:00', '1h', '110');
INSERT INTO `test_case` VALUES (132, '0', '', NULL, '', NULL, '测试02', '新功能', '测试01', '小胡鸭', '重要', '1', '为解决', '前端', '2020-12-28 00:00:00', '1h', '222');
INSERT INTO `test_case` VALUES (134, '0', NULL, NULL, '', NULL, '123', '123', '213', '213', '213', '0', '321', '213', '2020-12-28 00:00:00', '312', '123');
INSERT INTO `test_case` VALUES (135, '0', 'admin', NULL, '', NULL, '123', '123', '12312123', '123', '123', '0', '123', '123', '2020-12-29 00:00:00', '123', '123');
INSERT INTO `test_case` VALUES (136, '0', 'admin', NULL, '', NULL, '12', '312', '312223123', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `test_case` VALUES (137, '0', 'admin', NULL, '', NULL, '123111111111', '123', '123', '123', '123', '0', '123', '123', NULL, '123', '123');
INSERT INTO `test_case` VALUES (138, '0', 'admin', NULL, '', NULL, '封杀的', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;