صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
zrd
/
server
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: b0fbec0525
شاخه‌ها تگ‌ها
server
/
build-cloud
/
sql
/
ry-gen.sql

ry-gen.sql 90 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 167
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50734
    7. 

  7.  Source Host           : 192.168.0.167:3306
    8. 

  8.  Source Schema         : ry-gen
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50734
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 06/08/2021 16:01:02
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for flyway_schema_history
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `flyway_schema_history`;
    24. 

  24. CREATE TABLE `flyway_schema_history`  (
    25. 

  25.   `installed_rank` int(11) NOT NULL,
    26. 

  26.   `version` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    27. 

  27.   `description` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    28. 

  28.   `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    29. 

  29.   `script` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    30. 

  30.   `checksum` int(11) NULL DEFAULT NULL,
    31. 

  31.   `installed_by` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    32. 

  32.   `installed_on` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    33. 

  33.   `execution_time` int(11) NOT NULL,
    34. 

  34.   `success` tinyint(1) NOT NULL,
    35. 

  35.   PRIMARY KEY (`installed_rank`) USING BTREE,
    36. 

  36.   INDEX `flyway_schema_history_s_idx`(`success`) USING BTREE
    37. 

  37. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    38. 

  38. 

  39. -- ----------------------------
    40. 

  40. -- Records of flyway_schema_history
    41. 

  41. -- ----------------------------
    42. 

  42. INSERT INTO `flyway_schema_history` VALUES (1, '1', '<< Flyway Baseline >>', 'BASELINE', '<< Flyway Baseline >>', NULL, 'root', '2021-08-06 07:36:01', 0, 1);
    43. 

  43. 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);
    44. 

  44. 

  45. -- ----------------------------
    46. 

  46. -- Table structure for gen_table
    47. 

  47. -- ----------------------------
    48. 

  48. DROP TABLE IF EXISTS `gen_table`;
    49. 

  49. CREATE TABLE `gen_table`  (
    50. 

  50.   `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    51. 

  51.   `table_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表名称',
    52. 

  52.   `table_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表描述',
    53. 

  53.   `class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '实体类名称',
    54. 

  54.   `tpl_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '使用的模板（crud单表操作 tree树表操作）',
    55. 

  55.   `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成包路径',
    56. 

  56.   `module_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成模块名',
    57. 

  57.   `business_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成业务名',
    58. 

  58.   `function_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能名',
    59. 

  59.   `function_author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能作者',
    60. 

  60.   `gen_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）',
    61. 

  61.   `gen_path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）',
    62. 

  62.   `options` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其它生成选项',
    63. 

  63.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    64. 

  64.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    65. 

  65.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    66. 

  66.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    67. 

  67.   `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    68. 

  68.   `sub_table_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名',
    69. 

  69.   `sub_table_fk_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名',
    70. 

  70.   PRIMARY KEY (`table_id`) USING BTREE
    71. 

  71. ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic;
    72. 

  72. 

  73. -- ----------------------------
    74. 

  74. -- Records of gen_table
    75. 

  75. -- ----------------------------
    76. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. 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);
    79. 

  79. 

  80. -- ----------------------------
    81. 

  81. -- Table structure for gen_table_column
    82. 

  82. -- ----------------------------
    83. 

  83. DROP TABLE IF EXISTS `gen_table_column`;
    84. 

  84. CREATE TABLE `gen_table_column`  (
    85. 

  85.   `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    86. 

  86.   `table_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '归属表编号',
    87. 

  87.   `column_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列名称',
    88. 

  88.   `column_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列描述',
    89. 

  89.   `column_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列类型',
    90. 

  90.   `java_type` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型',
    91. 

  91.   `java_field` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名',
    92. 

  92.   `is_pk` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）',
    93. 

  93.   `is_increment` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）',
    94. 

  94.   `is_required` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）',
    95. 

  95.   `is_insert` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）',
    96. 

  96.   `is_edit` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）',
    97. 

  97.   `is_list` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）',
    98. 

  98.   `is_query` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）',
    99. 

  99.   `query_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）',
    100. 

  100.   `html_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）',
    101. 

  101.   `dict_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型',
    102. 

  102.   `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
    103. 

  103.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    104. 

  104.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    105. 

  105.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    106. 

  106.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    107. 

  107.   PRIMARY KEY (`column_id`) USING BTREE
    108. 

  108. ) ENGINE = InnoDB AUTO_INCREMENT = 260 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic;
    109. 

  109. 

  110. -- ----------------------------
    111. 

  111. -- Records of gen_table_column
    112. 

  112. -- ----------------------------
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. 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);
    117. 

  117. 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');
    118. 

  118. 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');
    119. 

  119. 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');
    120. 

  120. 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');
    121. 

  121. 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');
    122. 

  122. 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');
    123. 

  123. 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');
    124. 

  124. 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');
    125. 

  125. 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');
    126. 

  126. 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');
    127. 

  127. 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');
    128. 

  128. 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');
    129. 

  129. 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');
    130. 

  130. 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');
    131. 

  131. 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');
    132. 

  132. 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');
    133. 

  133. 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');
    134. 

  134. 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');
    135. 

  135. 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');
    136. 

  136. 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');
    137. 

  137. 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');
    138. 

  138. 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');
    139. 

  139. 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');
    140. 

  140. 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');
    141. 

  141. 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');
    142. 

  142. 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');
    143. 

  143. 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');
    144. 

  144. 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');
    145. 

  145. 

  146. -- ----------------------------
    147. 

  147. -- Table structure for gen_template
    148. 

  148. -- ----------------------------
    149. 

  149. DROP TABLE IF EXISTS `gen_template`;
    150. 

  150. CREATE TABLE `gen_template`  (
    151. 

  151.   `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
    152. 

  152.   `name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板名称',
    153. 

  153.   `file_Name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称',
    154. 

  154.   `target_package` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标包路径',
    155. 

  155.   `template_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板内容',
    156. 

  156.   `scheme_id` int(32) NULL DEFAULT NULL COMMENT '方案ID',
    157. 

  157.   `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
    158. 

  158.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
    159. 

  159.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    160. 

  160.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
    161. 

  161.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    162. 

  162.   `template_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板类型',
    163. 

  163.   PRIMARY KEY (`id`) USING BTREE
    164. 

  164. ) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成模板管理' ROW_FORMAT = Dynamic;
    165. 

  165. 

  166. -- ----------------------------
    167. 

  167. -- Records of gen_template
    168. 

  168. -- ----------------------------
    169. 

  169. 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');
    170. 

  170. 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');
    171. 

  171. 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');
    172. 

  172. 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');
    173. 

  173. 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');
    174. 

  174. 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');
    175. 

  175. 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');
    176. 

  176. 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');
    177. 

  177. 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');
    178. 

  178. 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');
    179. 

  179. 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');
    180. 

  180. 

  181. -- ----------------------------
    182. 

  182. -- Table structure for gen_template_scheme
    183. 

  183. -- ----------------------------
    184. 

  184. DROP TABLE IF EXISTS `gen_template_scheme`;
    185. 

  185. CREATE TABLE `gen_template_scheme`  (
    186. 

  186.   `id` int(32) NOT NULL AUTO_INCREMENT COMMENT '主键',
    187. 

  187.   `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方案标题',
    188. 

  188.   `description` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '方案描述',
    189. 

  189.   `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '删除标志（0代表存在 2代表删除）',
    190. 

  190.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建者',
    191. 

  191.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    192. 

  192.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新者',
    193. 

  193.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    194. 

  194.   PRIMARY KEY (`id`) USING BTREE
    195. 

  195. ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成模板组管理' ROW_FORMAT = Dynamic;
    196. 

  196. 

  197. -- ----------------------------
    198. 

  198. -- Records of gen_template_scheme
    199. 

  199. -- ----------------------------
    200. 

  200. INSERT INTO `gen_template_scheme` VALUES (1, '基础增删查改', '基础增删查改', '0', NULL, NULL, 'admin', '2020-06-19 14:01:13');
    201. 

  201. INSERT INTO `gen_template_scheme` VALUES (8, '增删改查001', '进行数据更新zrd', NULL, NULL, NULL, 'admin', '2021-01-21 10:57:34');
    202. 

  202. 

  203. -- ----------------------------
    204. 

  204. -- Table structure for generator_data_source
    205. 

  205. -- ----------------------------
    206. 

  206. DROP TABLE IF EXISTS `generator_data_source`;
    207. 

  207. CREATE TABLE `generator_data_source`  (
    208. 

  208.   `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    209. 

  209.   `db_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '索引关键字',
    210. 

  210.   `description` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述',
    211. 

  211.   `driver_class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '驱动',
    212. 

  212.   `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'URL',
    213. 

  213.   `db_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帐号',
    214. 

  214.   `db_password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
    215. 

  215.   `db_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库类型',
    216. 

  216.   `db_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库名称',
    217. 

  217.   `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'create_by',
    218. 

  218.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT 'create_date',
    219. 

  219.   `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'update_by',
    220. 

  220.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT 'update_date',
    221. 

  221.   `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'remarks',
    222. 

  222.   `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'del_flag',
    223. 

  223.   PRIMARY KEY (`id`) USING BTREE
    224. 

  224. ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '数据源' ROW_FORMAT = Dynamic;
    225. 

  225. 

  226. -- ----------------------------
    227. 

  227. -- Records of generator_data_source
    228. 

  228. -- ----------------------------
    229. 

  229. 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);
    230. 

  230. 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);
    231. 

  231. 

  232. -- ----------------------------
    233. 

  233. -- Table structure for p_activity_scene
    234. 

  234. -- ----------------------------
    235. 

  235. DROP TABLE IF EXISTS `p_activity_scene`;
    236. 

  236. CREATE TABLE `p_activity_scene`  (
    237. 

  237.   `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:支付',
    238. 

  238.   `sceneDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
    239. 

  239.   `SCENECHANNELNO` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    240. 

  240.   `sceneName` varchar(42) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景名称',
    241. 

  241.   `sceneCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景码',
    242. 

  242.   `CREATETIME` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
    243. 

  243.   `CheckStatus` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '复核状态（0：待复核，1：已通过，2：已拒绝）',
    244. 

  244.   `USERSEQ` decimal(20, 0) NULL DEFAULT NULL,
    245. 

  245.   `DEPTSEQ` decimal(20, 0) NULL DEFAULT NULL,
    246. 

  246.   `IsNormal` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N' COMMENT '是否正常（Y：正常，N：不可用）',
    247. 

  247.   `SceneType` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '场景类型  A:活动场景   E:事件场景',
    248. 

  248.   PRIMARY KEY (`SceneNo`) USING BTREE,
    249. 

  249.   UNIQUE INDEX `SCENECODE`(`sceneCode`) USING BTREE
    250. 

  250. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    251. 

  251. 

  252. -- ----------------------------
    253. 

  253. -- Records of p_activity_scene
    254. 

  254. -- ----------------------------
    255. 

  255. 

  256. -- ----------------------------
    257. 

  257. -- Table structure for template_engine
    258. 

  258. -- ----------------------------
    259. 

  259. DROP TABLE IF EXISTS `template_engine`;
    260. 

  260. CREATE TABLE `template_engine`  (
    261. 

  261.   `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'id主键',
    262. 

  262.   `del_Flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识（0正常 1关闭）',
    263. 

  263.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    264. 

  264.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    265. 

  265.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    266. 

  266.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    267. 

  267.   `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板名称',
    268. 

  268.   `template_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板编码',
    269. 

  269.   `json_str` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '测试json',
    270. 

  270.   `template_content` blob NULL COMMENT '模板内容',
    271. 

  271.   `template_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板类型',
    272. 

  272.   `template_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板上传的地址',
    273. 

  273.   `results_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输出结果',
    274. 

  274.   PRIMARY KEY (`id`) USING BTREE
    275. 

  275. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '导出模板管理' ROW_FORMAT = Dynamic;
    276. 

  276. 

  277. -- ----------------------------
    278. 

  278. -- Records of template_engine
    279. 

  279. -- ----------------------------
    280. 

  280. 

  281. -- ----------------------------
    282. 

  282. -- Table structure for test_case
    283. 

  283. -- ----------------------------
    284. 

  284. DROP TABLE IF EXISTS `test_case`;
    285. 

  285. CREATE TABLE `test_case`  (
    286. 

  286.   `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'id主键',
    287. 

  287.   `del_Flag` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标识（0正常 1关闭）',
    288. 

  288.   `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者',
    289. 

  289.   `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    290. 

  290.   `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者',
    291. 

  291.   `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
    292. 

  292.   `theme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主题',
    293. 

  293.   `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
    294. 

  294.   `parent_task` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级任务',
    295. 

  295.   `agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人',
    296. 

  296.   `priority` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优先级',
    297. 

  297.   `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
    298. 

  298.   `solve_results` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '解决结果',
    299. 

  299.   `module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块',
    300. 

  300.   `expected_completion_time` datetime(0) NULL DEFAULT NULL COMMENT '期望完成时间',
    301. 

  301.   `original_estimate_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原估时间',
    302. 

  302.   `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
    303. 

  303.   PRIMARY KEY (`id`) USING BTREE
    304. 

  304. ) ENGINE = InnoDB AUTO_INCREMENT = 139 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '测试用例表' ROW_FORMAT = Dynamic;
    305. 

  305. 

  306. -- ----------------------------
    307. 

  307. -- Records of test_case
    308. 

  308. -- ----------------------------
    309. 

  309. INSERT INTO `test_case` VALUES (100, '0', '', NULL, '', NULL, '测试用例-水印信息管理的界面查询', '任务', '1', '胡琴', '重要', '开始', '未解决', '111', NULL, '1h', NULL);
    310. 

  310. INSERT INTO `test_case` VALUES (102, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据修改', '任务', '2551111111', '胡琴', '重要', '开始', '未解决', '12', NULL, '1h', NULL);
    311. 

  311. INSERT INTO `test_case` VALUES (103, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    312. 

  312. INSERT INTO `test_case` VALUES (104, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    313. 

  313. INSERT INTO `test_case` VALUES (105, '0', '', NULL, '', NULL, '测试用例-水印信息管理的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    314. 

  314. INSERT INTO `test_case` VALUES (106, '0', '', NULL, '', NULL, '测试用例-产品评分表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    315. 

  315. INSERT INTO `test_case` VALUES (107, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    316. 

  316. INSERT INTO `test_case` VALUES (108, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    317. 

  317. INSERT INTO `test_case` VALUES (109, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    318. 

  318. INSERT INTO `test_case` VALUES (110, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    319. 

  319. INSERT INTO `test_case` VALUES (111, '0', '', NULL, '', NULL, '测试用例-产品评分表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    320. 

  320. INSERT INTO `test_case` VALUES (112, '0', '', NULL, '', NULL, '测试用例-产品收藏表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    321. 

  321. INSERT INTO `test_case` VALUES (113, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    322. 

  322. INSERT INTO `test_case` VALUES (114, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    323. 

  323. INSERT INTO `test_case` VALUES (115, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    324. 

  324. INSERT INTO `test_case` VALUES (116, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    325. 

  325. INSERT INTO `test_case` VALUES (117, '0', '', NULL, '', NULL, '测试用例-产品收藏表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    326. 

  326. INSERT INTO `test_case` VALUES (118, '0', '', NULL, '', NULL, '测试用例-产品信息表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    327. 

  327. INSERT INTO `test_case` VALUES (119, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    328. 

  328. INSERT INTO `test_case` VALUES (120, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    329. 

  329. INSERT INTO `test_case` VALUES (121, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    330. 

  330. INSERT INTO `test_case` VALUES (122, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    331. 

  331. INSERT INTO `test_case` VALUES (123, '0', '', NULL, '', NULL, '测试用例-产品信息表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    332. 

  332. INSERT INTO `test_case` VALUES (124, '0', '', NULL, '', NULL, '测试用例-基础表的界面查询', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    333. 

  333. INSERT INTO `test_case` VALUES (125, '0', '', NULL, '', NULL, '测试用例-基础表的数据新增', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    334. 

  334. INSERT INTO `test_case` VALUES (126, '0', '', NULL, '', NULL, '测试用例-基础表的数据修改', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    335. 

  335. INSERT INTO `test_case` VALUES (127, '0', '', NULL, '', NULL, '测试用例-基础表的数据删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    336. 

  336. INSERT INTO `test_case` VALUES (128, '0', '', NULL, '', NULL, '测试用例-基础表的数据批量删除', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    337. 

  337. INSERT INTO `test_case` VALUES (129, '0', '', NULL, '', NULL, '测试用例-基础表的数据导出', '任务', NULL, '胡琴', '重要', '开始', '未解决', NULL, NULL, '1h', NULL);
    338. 

  338. INSERT INTO `test_case` VALUES (131, '0', '', NULL, '', NULL, '测试', '任务', '测试01', '胡琴', '重要', '1', '未解决', '测试', '2020-12-31 00:00:00', '1h', '110');
    339. 

  339. INSERT INTO `test_case` VALUES (132, '0', '', NULL, '', NULL, '测试02', '新功能', '测试01', '小胡鸭', '重要', '1', '为解决', '前端', '2020-12-28 00:00:00', '1h', '222');
    340. 

  340. 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');
    341. 

  341. 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');
    342. 

  342. INSERT INTO `test_case` VALUES (136, '0', 'admin', NULL, '', NULL, '12', '312', '312223123', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL);
    343. 

  343. INSERT INTO `test_case` VALUES (137, '0', 'admin', NULL, '', NULL, '123111111111', '123', '123', '123', '123', '0', '123', '123', NULL, '123', '123');
    344. 

  344. INSERT INTO `test_case` VALUES (138, '0', 'admin', NULL, '', NULL, '封杀的', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL);
    345. 

  345. 

  346. SET FOREIGN_KEY_CHECKS = 1;
    347.