-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathgenerator.sql
378 lines (356 loc) · 143 KB
/
generator.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
/*
Navicat Premium Data Transfer
Source Server Type : MySQL
Source Server Version : 50734
Source Schema : generator
Target Server Type : MySQL
Target Server Version : 50734
File Encoding : 65001
Date: 06/12/2022 14:29:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for dict_type
-- ----------------------------
DROP TABLE IF EXISTS `dict_type`;
CREATE TABLE `dict_type`
(
`id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码',
`sort` tinyint(2) UNSIGNED NOT NULL COMMENT '排序',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态（0停用 1正常）',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `code_index` (`code`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 8
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '系统字典类型表';
-- ----------------------------
-- Records of dict_type
-- ----------------------------
BEGIN;
INSERT INTO `dict_type`
VALUES (1, '通用状态', 'common_status', 1, '', 1, NOW(), NULL),
(2, '是否标识', 'status', 2, NULL, 1, NOW(), NULL),
(3, '数据库类型', 'database_type', 3, NULL, 1, NOW(), NULL),
(4, 'java数据类型', 'java_data_type', 4, NULL, 1, NOW(), NULL),
(5, '网页标签', 'web_label', 5, NULL, 1, NOW(), NULL),
(6, '查询条件', 'query_type', 6, NULL, 1, NOW(), NULL),
(7, '键值对类型', 'field_mapping', 7, NULL, 1, NOW(), NULL);
COMMIT;
-- ----------------------------
-- Table structure for dict_data
-- ----------------------------
DROP TABLE IF EXISTS `dict_data`;
CREATE TABLE `dict_data`
(
`id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`type_id` int(6) NOT NULL COMMENT '字典类型id',
`name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典名称',
`value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码',
`sort` tinyint(2) UNSIGNED NOT NULL COMMENT '排序',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态（0正常 1停用）',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 31
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '系统字典值表';
-- ----------------------------
-- Records of dict_data
-- ----------------------------
BEGIN;
INSERT INTO `dict_data`
VALUES (1, 1, '停用', '0', 1, NULL, 1, NOW(), NULL),
(2, 1, '正常', '1', 2, NULL, 1, NOW(), NULL),
(3, 2, '否', '0', 1, NULL, 1, NOW(), NULL),
(4, 2, '是', '1', 2, NULL, 1, NOW(), NULL),
(5, 3, 'MySQL', '0', 1, NULL, 1, NOW(), NULL),
(6, 3, 'PostgreSQL', '1', 2, NULL, 1, NOW(), NULL),
(7, 3, 'Oracle', '2', 3, NULL, 1, NOW(), NULL),
(8, 4, 'String', 'String', 1, NULL, 1, NOW(), NULL),
(9, 4, 'Integer', 'Integer', 2, NULL, 1, NOW(), NULL),
(10, 4, 'Float', 'Float', 3, NULL, 1, NOW(), NULL),
(11, 4, 'Double', 'Double', 4, NULL, 1, NOW(), NULL),
(12, 4, 'Long', 'Long', 5, NULL, 1, NOW(), NULL),
(13, 4, 'Boolean', 'Boolean', 6, NULL, 1, NOW(), NULL),
(14, 4, 'LocalDateTime', 'LocalDateTime', 7, NULL, 1, NOW(), NULL),
(15, 4, 'BigDecimal', 'BigDecimal', 8, NULL, 1, NOW(), NULL),
(16, 5, '输入框', 'input', 1, NULL, 1, NOW(), NULL),
(17, 5, '文本域', 'text', 2, NULL, 1, NOW(), NULL),
(18, 5, '下拉框', 'dropdown', 3, NULL, 1, NOW(), NULL),
(19, 5, '复选框', 'checkbox', 4, NULL, 1, NOW(), NULL),
(20, 5, '单选框', 'radio', 5, NULL, 1, NOW(), NULL),
(21, 5, '日期控件', 'datetime', 6, NULL, 1, NOW(), NULL),
(22, 6, '等于', 'eq', 1, NULL, 1, NOW(), NULL),
(23, 6, '不等于', 'ne', 2, NULL, 1, NOW(), NULL),
(24, 6, '大于', 'gt', 3, NULL, 1, NOW(), NULL),
(25, 6, '小于', 'lt', 4, NULL, 1, NOW(), NULL),
(26, 6, '范围', 'like', 5, NULL, 1, NOW(), NULL),
(27, 7, 'String', '0', 1, NULL, 1, NOW(), NULL),
(28, 7, 'Boolean', '1', 2, NULL, 1, NOW(), NULL),
(29, 7, 'Integer', '2', 3, NULL, 1, NOW(), NULL),
(30, 7, 'List', '3', 4, NULL, 1, NOW(), NULL);
COMMIT;
-- ----------------------------
-- Table structure for gen_system_config
-- ----------------------------
DROP TABLE IF EXISTS `gen_system_config`;
CREATE TABLE `gen_system_config`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`private_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '私钥',
`public_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '公钥',
`salt` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '盐',
`state` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '盐是否持久化(0:否 1:是)',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 2
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '系统配置表';
-- ----------------------------
-- Records of gen_system_config
-- ----------------------------
BEGIN;
INSERT INTO `gen_system_config`
VALUES (1,
'MIICdwIBADANBgkqhkiG9w0BAQEFAASCAmEwggJdAgEAAoGBAI/Ce+SRYmPbM5bzEvR+f5tAsmizhziUy4YG8FnelYNhAxz2FJagnB4Rk+cQjBAg7pjsMg87ofS9kfJA16/iZbRfepYIo0YsyfyEzcj3P3QW5M1ryGgHxAmbY8/+p3d283hxaNVlBJLyZgn9Dewjui2/Ims5AtNLZ2K9g5LJy7XrAgMBAAECgYEAjPRCCdBKymHo6X6X/UXy1ETRKTutv9qU22r+Sv+lVVXPeZwGf9ImgIz3mb1tt3qytxoP00PC/nbJHOBbGsc+s+0YgGT5K3CPQUBJ8eulFQpZS8YG6a5MCN4R1pbLHp0VEyx3TJd7rtTWWLxRmpd6UyoFjrJdddagg46uy30lR0ECQQDOjMf5F8Orw3qZJ/ADAco7gXnlXh00/id5lCLKWZeziDK58RiFQ0Sqo4NBLfFV3pt7q7/VnOZH6jTXHI1Lr+gRAkEAsi1b1+AICe1ABR3Li7bYIPRHBrIBHZm4f96GrVZi2aBy7aGpGkUmJuldCxUO3vP/kMXkKOOum92EqFC3+zeaOwJAO1BqTLnqUvT7y+eQIQzuilAQNTHlqUYjB+Lmar13tvKxvnvh0sMSgP4bvyf2WfZnKAiWOj2oU5aKPgvQ9584QQJBAK9FV1dgFghNzfA6gwQI9UpVgZjgeaB4mrmOWMUieVLDNsrzf7lL1F/qp5BDQsGnG/t57xsZ/aVtnxVDcfg5lgkCQBUJgZauo5SSeB8h3tpHE+j+4EIdvi1LcD3AB2BYfVgohB7DA3iOA2Z4el84pbiVsidI9uFMa0rbWFN6Duy76pQ=',
'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCPwnvkkWJj2zOW8xL0fn+bQLJos4c4lMuGBvBZ3pWDYQMc9hSWoJweEZPnEIwQIO6Y7DIPO6H0vZHyQNev4mW0X3qWCKNGLMn8hM3I9z90FuTNa8hoB8QJm2PP/qd3dvN4cWjVZQSS8mYJ/Q3sI7otvyJrOQLTS2divYOSycu16wIDAQAB',
'S3xrre5rM0SBHUDRGpX7Zj5PsG0ynJ2A6LfYS/NzVD5cJqz+NHmtsxSE4YAmYo8O332XksC+Qm6WcjtCzHKLA/Z1dpNXbqGR2Kvyh4V/QPhyjOV+nluwP7QQqEcddz59XGySjJYuMqZNYKoSa719j3vhH1cf4r1goNLWRfA2FK4=',
1, NOW(), NULL);
COMMIT;
-- ----------------------------
-- Table structure for gen_database
-- ----------------------------
DROP TABLE IF EXISTS `gen_database`;
CREATE TABLE `gen_database`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`address` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据库地址',
`port` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据库端口',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '库名称',
`type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '数据库类型',
`driver_class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '数据库驱动',
`user_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
`password` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码（私钥加密）',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '数据库详情表';
-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`database_id` int(10) UNSIGNED NOT NULL COMMENT '数据库id',
`table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '表名称',
`table_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表描述',
`object_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '对象名',
`business_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '业务名',
`function_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '功能名',
`config_id` int(10) UNSIGNED NOT NULL COMMENT '配置表id',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '表详情表';
-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`table_id` int(10) UNSIGNED NOT NULL COMMENT '表id',
`column_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字段名',
`column_comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段描述',
`sort` tinyint(3) NULL DEFAULT NULL COMMENT '排序',
`column_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '列类型',
`is_primary_key` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否主键（0否，1是）',
`is_increment` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否自增（0否，1是）',
`is_required` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否为空（0否，1是）',
`java_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'String' COMMENT 'JAVA类型',
`java_field` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'JAVA字段名',
`is_insert` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否为插入字段（0否，1是）',
`is_edit` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否编辑字段（0否，1是）',
`is_list` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否列表字段（0否，1是）',
`is_query` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否查询字段（0否，1是）',
`query_type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'eq' COMMENT '查询方式（等于-eq、不等于-ne、大于-gt、小于-lt、范围-like）',
`html_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'input' COMMENT '显示类型（文本框-input、文本域-text、下拉框-dropdown、复选框-checkbox、单选框-radio、日期控件-datetime）',
`dict_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_date` datetime NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 1
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '字段详情表';
-- ----------------------------
-- Table structure for gen_table_config
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_config`;
CREATE TABLE `gen_table_config`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置名称',
`author` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '作者',
`package_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '包名',
`module_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名',
`date_format` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时间格式',
`table_prefix` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表前綴',
`remove_prefix` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '移除表前綴(0 否 1 是)',
`create_date` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 2
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '基础配置表';
-- ----------------------------
-- Records of gen_table_config
-- ----------------------------
INSERT INTO `gen_table_config`
VALUES (1, '默认', 'Joshua', 'com.moonlit', 'generator', NULL, NULL, 0, NOW());
-- ----------------------------
-- Table structure for gen_field_mapping
-- ----------------------------
DROP TABLE IF EXISTS `gen_field_mapping`;
CREATE TABLE `gen_field_mapping`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`comment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '键',
`mapping` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '值',
`type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '类型（0：String、1：Boolean、2：Integer、3：List）',
`state` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态（0 否 1 是）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 2
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '键值映射表';
-- ----------------------------
-- Records of gen_field_mapping
-- ----------------------------
BEGIN;
INSERT INTO `gen_field_mapping`
VALUES (1, 'email', 'you@Email.com', 0, 1);
COMMIT;
-- ----------------------------
-- Table structure for gen_template_collection
-- ----------------------------
DROP TABLE IF EXISTS `gen_template_collection`;
CREATE TABLE `gen_template_collection`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板名称',
`state` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态（0否、1是）',
`create_date` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 5
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '模板组表';
-- ----------------------------
-- Records of gen_template_collection
-- ----------------------------
BEGIN;
INSERT INTO `gen_template_collection`
VALUES (1, '默认', 1, NOW()),
(2, 'Java', 1, NOW()),
(3, 'Vue', 1, NOW()),
(4, 'Js', 1, NOW());
COMMIT;
-- ----------------------------
-- Table structure for gen_template_config
-- ----------------------------
DROP TABLE IF EXISTS `gen_template_config`;
CREATE TABLE `gen_template_config`
(
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`collection_id` int(10) NOT NULL DEFAULT 1 COMMENT '模板組id',
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
`template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '模板',
`suffix_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模板后缀名',
`display` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '展示（0:否 1:是）',
`state` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态（0:否 1:是）',
`create_date` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
AUTO_INCREMENT = 19
CHARACTER SET = utf8mb4
COLLATE = utf8mb4_general_ci COMMENT = '模板配置表';
-- ----------------------------
-- Records of gen_template_config
-- ----------------------------
BEGIN;
INSERT INTO `gen_template_config`
VALUES (1, 1, 'Controller',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.controller;\n\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.response.<span class=\"hljs-type\">Result</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.entity.<span class=\"hljs-string\">${</span>className};\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.service.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span>;\nimport org.springframework.beans.factory.annotation.<span class=\"hljs-type\">Autowired</span>;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>控制层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">RestController</span>\n@<span class=\"hljs-type\">RequestMapping</span>(<span class=\"hljs-comment\">\"/${businessName}\"</span>)\npublic class <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Controller</span> {\n\n @<span class=\"hljs-type\">Autowired</span>\n private <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> <span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>;\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <span class=\"hljs-string\">${</span>comment}集合\n */\n @<span class=\"hljs-type\">GetMapping</span>(<span class=\"hljs-comment\">\"/pageList\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}>> page(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.pageList(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <span class=\"hljs-string\">${</span>comment}集合\n */\n @<span class=\"hljs-type\">GetMapping</span>(<span class=\"hljs-comment\">\"/list\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}>> list(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/save\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> addSave(@<span class=\"hljs-type\">RequestBody</span> <span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/update\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> editSave(@<span class=\"hljs-type\">RequestBody</span> <span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/delete\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> delete(<span class=\"hljs-type\">String</span> ids) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(ids));\n }\n\n}\n</pre>',
'java', 1, 1, NOW()),
(2, 1, 'Service',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service;\n\nimport com.baomidou.mybatisplus.extension.service.<span class=\"hljs-type\">IService</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.entity.<span class=\"hljs-string\">${</span>className};\n\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>业务层\n * \n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\npublic interface <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> extends <span class=\"hljs-type\">IService</span><<span class=\"hljs-string\">${</span>className}> {\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n <span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}> pageList(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n <span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}> select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(<span class=\"hljs-type\">String</span> ids);\n\n}\n</pre>',
'java', 1, 1, NOW()),
(3, 1, 'ServiceImpl',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service.impl;\n\nimport cn.hutool.core.convert.<span class=\"hljs-type\">Convert</span>;\nimport cn.hutool.core.util.<span class=\"hljs-type\">ObjectUtil</span>;\nimport com.baomidou.mybatisplus.core.conditions.query.<span class=\"hljs-type\">LambdaQueryWrapper</span>;\nimport com.baomidou.mybatisplus.core.toolkit.<span class=\"hljs-type\">Wrappers</span>;\nimport com.baomidou.mybatisplus.extension.service.impl.<span class=\"hljs-type\">ServiceImpl</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageFactory</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.entity.<span class=\"hljs-string\">${</span>className};\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.mapper.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span>;\nimport org.springframework.stereotype.<span class=\"hljs-type\">Service</span>;\n\nimport java.time.<span class=\"hljs-type\">LocalDateTime</span>;\nimport java.util.<span class=\"hljs-type\">Arrays</span>;\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>业务实现层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">Service</span>\npublic class <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ServiceImpl</span> extends <span class=\"hljs-type\">ServiceImpl</span><<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span>, <span class=\"hljs-string\">${</span>className}> implements <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> {\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}> pageList(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n <span class=\"hljs-type\">LambdaQueryWrapper</span><<span class=\"hljs-string\">${</span>className}> queryWrapper = <span class=\"hljs-type\">Wrappers</span>.lambdaQuery();\n if (<span class=\"hljs-type\">ObjectUtil</span>.isNotNull(<span class=\"hljs-string\">${</span>objectName})) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.isQuery && column.javaType != <span class=\"hljs-string\">\'LocalDateTime\'</span>>\n if (<span class=\"hljs-type\">ObjectUtil</span>.isNotEmpty(<span class=\"hljs-string\">${</span>objectName}.get<span class=\"hljs-string\">${</span>column.javaField?cap_first}())){\n queryWrapper.<span class=\"hljs-string\">${</span>column.queryType}(<span class=\"hljs-string\">${</span>className}::get<span class=\"hljs-string\">${</span>column.javaField?cap_first}, <span class=\"hljs-string\">${</span>objectName}.get${column.javaField?cap_first}());\n }\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n }\n return new <span class=\"hljs-type\">PageResult</span><>(this.page(<span class=\"hljs-type\">PageFactory</span>.defaultPage(), queryWrapper));\n }\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}> select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n <span class=\"hljs-type\">LambdaQueryWrapper</span><<span class=\"hljs-string\">${</span>className}> queryWrapper = <span class=\"hljs-type\">Wrappers</span>.lambdaQuery();\n return this.list(queryWrapper);\n }\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.javaType == <span class=\"hljs-string\">\'LocalDateTime\'</span> && <span class=\"hljs-comment\">\"createDateTime,createDate,createTime\"</span>?contains(column.javaField)>\n <span class=\"hljs-string\">${</span>objectName}.set<span class=\"hljs-string\">${</span>column.javaField?cap_first}(<span class=\"hljs-type\">LocalDateTime</span>.now());\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n return this.save(<span class=\"hljs-string\">${</span>objectName});\n }\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.javaType == <span class=\"hljs-string\">\'LocalDateTime\'</span> && <span class=\"hljs-comment\">\"updateDateTime,updateDate,updateTime\"</span>?contains(column.javaField)>\n <span class=\"hljs-string\">${</span>objectName}.set<span class=\"hljs-string\">${</span>column.javaField?cap_first}(<span class=\"hljs-type\">LocalDateTime</span>.now());\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n return this.updateById(<span class=\"hljs-string\">${</span>objectName});\n }\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(<span class=\"hljs-type\">String</span> ids) {\n return this.removeByIds(<span class=\"hljs-type\">Arrays</span>.asList(<span class=\"hljs-type\">Convert</span>.toStrArray(ids)));\n }\n\n}\n</pre>',
'java', 1, 1, NOW()),
(4, 1, 'Mapper',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.<span class=\"hljs-type\">BaseMapper</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.entity.<span class=\"hljs-string\">${</span>className};\nimport org.apache.ibatis.annotations.<span class=\"hljs-type\">Mapper</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>映射层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">Mapper</span>\npublic interface <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span> extends <span class=\"hljs-type\">BaseMapper</span><<span class=\"hljs-string\">${</span>className}> {\n\n}\n</pre>',
'java', 1, 1, NOW()),
(5, 1, 'Mapping',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><span class=\"hljs-meta\"><?xml version=\"1.0\" encoding=\"UTF-8\"?></span>\n<span class=\"hljs-meta\"><!DOCTYPE mapper\n PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\n \"http://mybatis.org/dtd/mybatis-3-mapper.dtd\"></span>\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">mapper</span> <span class=\"hljs-attr\">namespace</span>=<span class=\"hljs-string\">\"$</span></span>{packageName}<span class=\"hljs-tag\"><span class=\"hljs-string\"><#if moduleName?? && moduleName != \"\">.$</span></span>{moduleName}<span class=\"hljs-tag\"><span class=\"hljs-string\"></#if>.mapper.$</span></span>{className}<span class=\"hljs-tag\"><span class=\"hljs-string\">Mapper\"</span>></span>\n\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">mapper</span>></span>\n</pre>',
'xml', 1, 1, NOW()),
(6, 1, 'Entity',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-variable\">${</span>packageName}<<span class=\"hljs-comment\">#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.entity;</span>\n\n<<span class=\"hljs-comment\">#list importList as import></span>\n<span class=\"hljs-keyword\">import</span> <span class=\"hljs-variable\">${</span><span class=\"hljs-keyword\">import</span>};\n</<span class=\"hljs-comment\">#list></span>\n<span class=\"hljs-keyword\">import</span> lombok.<span class=\"hljs-title class_\">Data</span>;\n\n<span class=\"hljs-keyword\">import</span> java.io.<span class=\"hljs-title class_\">Serial</span>;\n<span class=\"hljs-keyword\">import</span> java.io.<span class=\"hljs-title class_\">Serializable</span>;\n\n/**\n * <<span class=\"hljs-comment\">#if comment??>${comment}</#if>实体</span>\n * \n * <span class=\"hljs-variable\">@author</span> <span class=\"hljs-variable\">${</span>author}\n * <span class=\"hljs-variable\">@version</span> <span class=\"hljs-number\">1.0</span>\n * <span class=\"hljs-variable\">@date</span> <span class=\"hljs-variable\">${</span>datetime}\n */\n<span class=\"hljs-variable\">@Data</span>\npublic class <span class=\"hljs-variable\">${</span>className} implements <span class=\"hljs-title class_\">Serializable</span> {\n \n <span class=\"hljs-variable\">@Serial</span>\n private static final long serialVersionUID = -<span class=\"hljs-variable\">${</span>serialVersionUid}L;\n\n<<span class=\"hljs-comment\">#list tableColumns as column></span>\n /**\n * <<span class=\"hljs-comment\">#if column.columnComment??>${column.columnComment}</#if></span>\n */\n <<span class=\"hljs-comment\">#if column.javaType == \'LocalDateTime\'>\n @JsonFormat(timezone = \"GMT+8\", pattern = DatePattern.NORM_DATETIME_PATTERN)</span>\n </<span class=\"hljs-comment\">#if></span>\n private <span class=\"hljs-variable\">${</span>column.javaType} <span class=\"hljs-variable\">${</span>column.javaField};\n\n</<span class=\"hljs-comment\">#list></span>\n}\n</pre>',
'java', 1, 1, NOW()),
(7, 2, 'Controller',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.controller;\n\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.response.<span class=\"hljs-type\">Result</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.entity.<span class=\"hljs-string\">${</span>className};\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.service.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span>;\nimport org.springframework.beans.factory.annotation.<span class=\"hljs-type\">Autowired</span>;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>控制层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">RestController</span>\n@<span class=\"hljs-type\">RequestMapping</span>(<span class=\"hljs-comment\">\"/${businessName}\"</span>)\npublic class <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Controller</span> {\n\n @<span class=\"hljs-type\">Autowired</span>\n private <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> <span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>;\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <span class=\"hljs-string\">${</span>comment}集合\n */\n @<span class=\"hljs-type\">GetMapping</span>(<span class=\"hljs-comment\">\"/pageList\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}>> page(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.pageList(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <span class=\"hljs-string\">${</span>comment}集合\n */\n @<span class=\"hljs-type\">GetMapping</span>(<span class=\"hljs-comment\">\"/list\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}>> list(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/save\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> addSave(@<span class=\"hljs-type\">RequestBody</span> <span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/update\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> editSave(@<span class=\"hljs-type\">RequestBody</span> <span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>objectName}));\n }\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n @<span class=\"hljs-type\">PostMapping</span>(<span class=\"hljs-comment\">\"/delete\"</span>)\n public <span class=\"hljs-type\">Result</span><<span class=\"hljs-type\">Boolean</span>> delete(<span class=\"hljs-type\">String</span> ids) {\n return <span class=\"hljs-type\">Result</span>.success(<span class=\"hljs-string\">${</span>objectName}<span class=\"hljs-type\">Service</span>.delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(ids));\n }\n\n}\n</pre>',
'java', 0, 1, NOW()),
(8, 2, 'Service',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service;\n\nimport com.baomidou.mybatisplus.extension.service.<span class=\"hljs-type\">IService</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.entity.<span class=\"hljs-string\">${</span>className};\n\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>业务层\n * \n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\npublic interface <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> extends <span class=\"hljs-type\">IService</span><<span class=\"hljs-string\">${</span>className}> {\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n <span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}> pageList(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n <span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}> select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName});\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n * \n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n <span class=\"hljs-type\">Boolean</span> delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(<span class=\"hljs-type\">String</span> ids);\n\n}\n</pre>',
'java', 0, 1, NOW()),
(9, 2, 'ServiceImpl',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service.impl;\n\nimport cn.hutool.core.convert.<span class=\"hljs-type\">Convert</span>;\nimport cn.hutool.core.util.<span class=\"hljs-type\">ObjectUtil</span>;\nimport com.baomidou.mybatisplus.core.conditions.query.<span class=\"hljs-type\">LambdaQueryWrapper</span>;\nimport com.baomidou.mybatisplus.core.toolkit.<span class=\"hljs-type\">Wrappers</span>;\nimport com.baomidou.mybatisplus.extension.service.impl.<span class=\"hljs-type\">ServiceImpl</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageFactory</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.common.page.<span class=\"hljs-type\">PageResult</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.entity.<span class=\"hljs-string\">${</span>className};\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.mapper.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.service.<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span>;\nimport org.springframework.stereotype.<span class=\"hljs-type\">Service</span>;\n\nimport java.time.<span class=\"hljs-type\">LocalDateTime</span>;\nimport java.util.<span class=\"hljs-type\">Arrays</span>;\nimport java.util.<span class=\"hljs-type\">List</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>业务实现层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">Service</span>\npublic class <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ServiceImpl</span> extends <span class=\"hljs-type\">ServiceImpl</span><<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span>, <span class=\"hljs-string\">${</span>className}> implements <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Service</span> {\n\n /**\n * 分页查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">PageResult</span><<span class=\"hljs-string\">${</span>className}> pageList(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n <span class=\"hljs-type\">LambdaQueryWrapper</span><<span class=\"hljs-string\">${</span>className}> queryWrapper = <span class=\"hljs-type\">Wrappers</span>.lambdaQuery();\n if (<span class=\"hljs-type\">ObjectUtil</span>.isNotNull(<span class=\"hljs-string\">${</span>objectName})) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.isQuery && column.javaType != <span class=\"hljs-string\">\'LocalDateTime\'</span>>\n if (<span class=\"hljs-type\">ObjectUtil</span>.isNotEmpty(<span class=\"hljs-string\">${</span>objectName}.get<span class=\"hljs-string\">${</span>column.javaField?cap_first}())){\n queryWrapper.<span class=\"hljs-string\">${</span>column.queryType}(<span class=\"hljs-string\">${</span>className}::get<span class=\"hljs-string\">${</span>column.javaField?cap_first}, <span class=\"hljs-string\">${</span>objectName}.get${column.javaField?cap_first}());\n }\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n }\n return new <span class=\"hljs-type\">PageResult</span><>(this.page(<span class=\"hljs-type\">PageFactory</span>.defaultPage(), queryWrapper));\n }\n\n /**\n * 查询<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>列表\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>集合\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">List</span><<span class=\"hljs-string\">${</span>className}> select<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">List</span>(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n <span class=\"hljs-type\">LambdaQueryWrapper</span><<span class=\"hljs-string\">${</span>className}> queryWrapper = <span class=\"hljs-type\">Wrappers</span>.lambdaQuery();\n return this.list(queryWrapper);\n }\n\n /**\n * 新增<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> insert<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.javaType == <span class=\"hljs-string\">\'LocalDateTime\'</span> && <span class=\"hljs-comment\">\"createDateTime,createDate,createTime\"</span>?contains(column.javaField)>\n <span class=\"hljs-string\">${</span>objectName}.set<span class=\"hljs-string\">${</span>column.javaField?cap_first}(<span class=\"hljs-type\">LocalDateTime</span>.now());\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n return this.save(<span class=\"hljs-string\">${</span>objectName});\n }\n\n /**\n * 修改<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param <span class=\"hljs-string\">${</span>objectName} <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> update<span class=\"hljs-string\">${</span>className}(<span class=\"hljs-string\">${</span>className} <span class=\"hljs-string\">${</span>objectName}) {\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n <<span class=\"hljs-symbol\">#if</span> column.javaType == <span class=\"hljs-string\">\'LocalDateTime\'</span> && <span class=\"hljs-comment\">\"updateDateTime,updateDate,updateTime\"</span>?contains(column.javaField)>\n <span class=\"hljs-string\">${</span>objectName}.set<span class=\"hljs-string\">${</span>column.javaField?cap_first}(<span class=\"hljs-type\">LocalDateTime</span>.now());\n </<span class=\"hljs-symbol\">#if</span>>\n</<span class=\"hljs-symbol\">#list</span>>\n return this.updateById(<span class=\"hljs-string\">${</span>objectName});\n }\n\n /**\n * 批量删除<<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>\n *\n * @param ids 需要删除的数据<span class=\"hljs-type\">ID</span>\n * @return 结果\n */\n @<span class=\"hljs-type\">Override</span>\n public <span class=\"hljs-type\">Boolean</span> delete<span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">ByIds</span>(<span class=\"hljs-type\">String</span> ids) {\n return this.removeByIds(<span class=\"hljs-type\">Arrays</span>.asList(<span class=\"hljs-type\">Convert</span>.toStrArray(ids)));\n }\n\n}\n</pre>',
'java', 0, 1, NOW()),
(10, 2, 'Mapper',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<<span class=\"hljs-symbol\">#if</span> moduleName?? && moduleName != <span class=\"hljs-comment\">\"\"</span>>.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.mapper;\n\nimport com.baomidou.mybatisplus.core.mapper.<span class=\"hljs-type\">BaseMapper</span>;\nimport <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.${moduleName}</#if>.entity.<span class=\"hljs-string\">${</span>className};\nimport org.apache.ibatis.annotations.<span class=\"hljs-type\">Mapper</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>映射层\n *\n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">Mapper</span>\npublic interface <span class=\"hljs-string\">${</span>className}<span class=\"hljs-type\">Mapper</span> extends <span class=\"hljs-type\">BaseMapper</span><<span class=\"hljs-string\">${</span>className}> {\n\n}\n</pre>',
'java', 0, 1, NOW()),
(11, 2, 'Mapping',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><span class=\"hljs-meta\"><?xml version=\"1.0\" encoding=\"UTF-8\"?></span>\n<span class=\"hljs-meta\"><!DOCTYPE mapper\n PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\n \"http://mybatis.org/dtd/mybatis-3-mapper.dtd\"></span>\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">mapper</span> <span class=\"hljs-attr\">namespace</span>=<span class=\"hljs-string\">\"$</span></span>{packageName}<span class=\"hljs-tag\"><span class=\"hljs-string\"><#if moduleName?? && moduleName != \"\">.$</span></span>{moduleName}<span class=\"hljs-tag\"><span class=\"hljs-string\"></#if>.mapper.$</span></span>{className}<span class=\"hljs-tag\"><span class=\"hljs-string\">Mapper\"</span>></span>\n\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">mapper</span>></span>\n</pre>',
'xml', 0, 1, NOW()),
(12, 2, 'Entity',
'<pre class=\"ql-syntax\" spellcheck=\"false\">package <span class=\"hljs-string\">${</span>packageName}<#if moduleName?? && moduleName != \"\">.<span class=\"hljs-string\">${</span>moduleName}</<span class=\"hljs-symbol\">#if</span>>.entity;\n\n<<span class=\"hljs-symbol\">#list</span> importList as import>\nimport <span class=\"hljs-string\">${</span>import};\n</<span class=\"hljs-symbol\">#list</span>>\nimport lombok.<span class=\"hljs-type\">Data</span>;\n\nimport java.io.<span class=\"hljs-type\">Serializable</span>;\n\n/**\n * <<span class=\"hljs-symbol\">#if</span> comment??><span class=\"hljs-string\">${</span>comment}</<span class=\"hljs-symbol\">#if</span>>实体\n * \n * @author <span class=\"hljs-string\">${</span>author}\n * @version <span class=\"hljs-number\">1.0</span>\n * @date <span class=\"hljs-string\">${</span>datetime}\n */\n@<span class=\"hljs-type\">Data</span>\npublic class <span class=\"hljs-string\">${</span>className} implements <span class=\"hljs-type\">Serializable</span> {\n\n private static final long serialVersionUID = <span class=\"hljs-number\">1</span>L;\n\n<<span class=\"hljs-symbol\">#list</span> tableColumns as column>\n /**\n * <<span class=\"hljs-symbol\">#if</span> column.columnComment??><span class=\"hljs-string\">${</span>column.columnComment}</<span class=\"hljs-symbol\">#if</span>>\n */\n <<span class=\"hljs-symbol\">#if</span> column.javaType == <span class=\"hljs-string\">\'LocalDateTime\'</span>>\n @<span class=\"hljs-type\">JsonFormat</span>(timezone = <span class=\"hljs-comment\">\"GMT+8\"</span>, pattern = <span class=\"hljs-type\">DatePattern</span>.<span class=\"hljs-type\">NORM_DATETIME_PATTERN</span>)\n </<span class=\"hljs-symbol\">#if</span>>\n private <span class=\"hljs-string\">${</span>column.javaType} <span class=\"hljs-string\">${</span>column.javaField};\n\n</<span class=\"hljs-symbol\">#list</span>>\n}\n</pre>',
'java', 0, 1, NOW()),
(13, 1, 'Api',
'<pre class=\"ql-syntax\" spellcheck=\"false\">import request from <span class=\"hljs-string\">\'@/utils/request\'</span>\n\n/**\n* <<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\nconst api = {\n <span class=\"hljs-variable\">${objectName}</span>: <span class=\"hljs-string\">\'/${businessName}\'</span>\n}\n\n/**\n* 分页查询<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> get<span class=\"hljs-variable\">${className}</span>PageList (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + <span class=\"hljs-string\">\'/pageList\'</span>,\n method: <span class=\"hljs-string\">\'get\'</span>,\n params: parameter\n })\n}\n\n/**\n* 修改/保存<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> save<span class=\"hljs-variable\">${className}</span> (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + (parameter.<span class=\"hljs-variable\">${primaryKeyColumn.javaField}</span> > 0 ? <span class=\"hljs-string\">\'/update\'</span> : <span class=\"hljs-string\">\'/save\'</span>),\n method: <span class=\"hljs-string\">\'post\'</span>,\n data: parameter,\n headers: {\n <span class=\"hljs-string\">\'Content-Type\'</span>: <span class=\"hljs-string\">\'application/json;charset=UTF-8\'</span>\n }\n })\n}\n\n/**\n* 批量删除<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> del<span class=\"hljs-variable\">${className}</span> (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + <span class=\"hljs-string\">\'/delete\'</span>,\n method: <span class=\"hljs-string\">\'post\'</span>,\n params: parameter\n })\n}\n</pre>',
'js', 1, 1, NOW()),
(14, 1, 'List',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><span class=\"hljs-tag\"><template>\n <a-card :bordered=\"false\">\n <div class=\"table-page-search-wrapper\">\n <a-form layout=\"inline\">\n <a-row :gutter=\"48\">\n<#list tableColumns as column>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#else>${column_index}</#if></#assign>\n<#if column.isQuery && column.htmlType == \"input\">\n <a-col :md=\"5\" :sm=\"15\">\n <a-form-item label=\"${columnComment}\">\n <a-input allow-clear placeholder=\"请输入${columnComment}\" v-model=\"queryParam.${column.javaField}\"/>\n </a-form-item>\n </a-col>\n<#elseif column.htmlType == \"dropdown\">\n <a-col :md=\"5\" :sm=\"15\">\n <a-form-item label=\"${columnComment}\">\n <a-select allow-clear v-model=\"queryParam.${column.javaField}\" allow-clear placeholder=\"请选择${columnComment}\">\n <a-select-option v-for=\"(item,index) in ${column.javaField}DictTypeDropDown\" :key=\"index\" :value=\"item.key\" >\n {{ item.name }}\n </a-select-option>\n </a-select>\n </a-form-item>\n </a-col>\n<#else>\n</#if>\n</#list>\n <a-col :md=\"5\" :sm=\"15\">\n <span class=\"table-page-search-submitButtons\">\n <a-button type=\"primary\" @click=\"$refs.table.refresh(true)\">查询</a-button>\n <a-button style=\"margin-left: 8px\" @click=\"() => queryParam = {}\">重置</a-button>\n <a @click=\"toggleAdvanced\" style=\"margin-left: 8px\">\n {{ advanced ? \'收起\' : \'展开\' }}\n <a-icon :type=\"advanced ? \'up\' : \'down\'\"/>\n </a>\n </span>\n </a-col>\n </a-row>\n </a-form>\n </div>\n\n <a-space align=\"center\" style=\"margin-bottom: 16px\">\n <a-button type=\"primary\" icon=\"plus\" @click=\"handleAdd\">新增</a-button>\n <a-dropdown v-if=\"selectedRowKeys.length > 0\">\n <a-popconfirm placement=\"topRight\" title=\"确认删除？\" @confirm=\"() => delByIds(selectedRowKeys)\">\n <a-button type=\"primary\" icon=\"close\">删除</a-button>\n </a-popconfirm>\n </a-dropdown>\n </a-space>\n\n <s-table\n size=\"default\"\n ref=\"table\"\n rowKey=\"${primaryKeyColumn.javaField}\"\n :rowSelection=\"{selectedRowKeys: selectedRowKeys, onChange: onSelectChange}\"\n :columns=\"columns\"\n :data=\"loadData\"\n :rangPicker=\"range\"\n >\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\n <span slot=\"${column.javaField}\" slot-scope=\"text\">\n {{ ${column.javaField}Filter(text) }}\n </span>\n</#if>\n</#list>\n <span slot=\"action\" slot-scope=\"text, record\">\n <a @click=\"handleEdit(record)\">编辑</a>\n <a-divider type=\"vertical\"/>\n <a-popconfirm placement=\"topRight\" title=\"确认删除？\" @confirm=\"() => delByIds([record.${primaryKeyColumn.javaField}])\">\n <a>删除</a>\n </a-popconfirm>\n </span>\n </s-table>\n <${objectName}-modal ref=\"${businessName}\" @ok=\"handleOk\"/>\n </a-card>\n</template>\n\n<script>\nimport { STable } from \'@/components\'\nimport { del${className}, get${className}PageList } from \'@/api<#if moduleName?? && moduleName != \"\">/${moduleName}</#if>/${businessName}/${objectName}\'\nimport ${className}Modal from \'./modal/${className}Modal\'\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\nimport { sysDictTypeDropDown } from \'@/api/system/dict/sysDictType\'\n<#break>\n</#if>\n</#list>\n\nexport default {\n name: \'${className}List\',\n components: {\n STable,\n ${className}Modal\n },\n data () {\n return {\n labelCol: {\n xs: { span: 24 },\n sm: { span: 5 }\n },\n wrapperCol: {\n xs: { span: 24 },\n sm: { span: 16 }\n },\n form: this.$form.createForm(this),\n mdl: {},\n // 高级搜索 展开/关闭\n advanced: false,\n // 查询参数\n queryParam: {},\n // 表头\n columns: [\n<#list tableColumns as column>\n<#assign javaField = \'${column.javaField}\'>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#else>${column_index}</#if></#assign>\n<#if column.isList == true>\n<#if column.htmlType == \'datetime\'>\n {\n title: \'${columnComment}\',\n dataIndex: \'${javaField}\',\n scopedSlots: { customRender: \'${javaField}\' },\n sorter: true,\n align: \'center\'\n },\n<#else>\n {\n title: \'${columnComment}\',\n dataIndex: \'${javaField}\',\n scopedSlots: { customRender: \'${javaField}\' },\n align: \'center\'\n },\n</#if>\n</#if>\n</#list>\n {\n title: \'操作\',\n width: \'240px\',\n dataIndex: \'action\',\n align: \'center\',\n scopedSlots: { customRender: \'action\' }\n }\n ],\n range: null,\n // 加载数据方法 必须为 Promise 对象\n loadData: parameter => {\n return get${className}PageList(Object.assign(parameter, this.queryParam)).then((res) => {\n return res.data\n })\n },\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\n ${column.javaField}DictTypeDropDown: [],\n</#if>\n</#list>\n selectedRowKeys: [],\n selectedRows: []\n }\n },\n filters: {\n },\n created () {\n this.sysDictTypeDropDown()\n },\n methods: {\n // 处理多选\n onSelectChange (selectedRowKeys, selectedRows) {\n this.selectedRowKeys = selectedRowKeys\n this.selectedRows = selectedRows\n },\n // 提交完成后刷新\n handleOk () {\n this.$refs.table.refresh(true)\n },\n // 加载字典\n sysDictTypeDropDown () {\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\n sysDictTypeDropDown({ code: \'${column.javaField}\' }).then((res) => {\n this.${column.javaField}DictTypeDropDown = res.data\n })\n</#if>\n</#list>\n },\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\n // 匹配字典\n ${column.javaField}Filter (${column.javaField}) {\n // eslint-disable-next-line eqeqeq\n const values = this.${column.javaField}DictTypeDropDown.filter(item => item.key == ${column.javaField})\n if (values.length > 0) {\n return values[0].name\n }\n },\n</#if>\n</#list>\n // 添加\n handleAdd () {\n this.$refs.${businessName}.add()\n },\n // 修改\n handleEdit (record) {\n this.$refs.${businessName}.edit(record)\n },\n // 批量删除\n delByIds (ids) {\n del${className}({ ids: ids.join(\',\') }).then(res => {\n if (res.code === 200) {\n this.$message.success(\'删除成功\')\n this.handleOk()\n } else {\n this.$message.error(res.message)\n }\n this.selectedRowKeys = []\n })\n },\n // 提供更多查询条件选项\n toggleAdvanced () {\n this.advanced = !this.advanced\n }\n }\n}\n</script>\n</span>\n</pre>',
'vue', 1, 1, NOW()),
(15, 1, 'Modal',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><#assign primaryKeyColumn = \'${primaryKeyColumn.javaField}\'>\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">template</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-modal</span>\n <span class=\"hljs-attr\">:title</span>=<span class=\"hljs-string\">\"title\"</span>\n <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"top: 20px;\"</span>\n <span class=\"hljs-attr\">width</span>=<span class=\"hljs-string\">\"40%\"</span>\n <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"visible\"</span>\n <span class=\"hljs-attr\">:confirmLoading</span>=<span class=\"hljs-string\">\"confirmLoading\"</span>\n @<span class=\"hljs-attr\">ok</span>=<span class=\"hljs-string\">\"handleSubmit\"</span>\n ></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form</span> <span class=\"hljs-attr\">:form</span>=<span class=\"hljs-string\">\"form\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"display:none\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-input</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${primaryKeyColumn}\']\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#list tableColumns as column>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#else>${column_index}</#if></#assign>\n<#assign javaField = \'${column.javaField}\'>\n<#if !column.isPrimaryKey && column.isEdit>\n<#if column.htmlType == \"input\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-input</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请输入${columnComment}\'}]}</#if>]\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"dropdown\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"请选择${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请选择${columnComment}\'}]}</#if>]\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select-option</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictTypeDropDown\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span> ></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select-option</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"text\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-textarea</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">:auto-size</span>=<span class=\"hljs-string\">\"{ minRows: 3, maxRows: 8 }\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\']\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"radio\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-radio-group</span> <span class=\"hljs-attr\">name</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请选择${columnComment}\'}]}</#if>]\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-radio</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictRadio\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span>></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-radio</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-radio-group</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"checkbox\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox</span> <span class=\"hljs-attr\">:indeterminate</span>=<span class=\"hljs-string\">\"indeterminate\"</span> <span class=\"hljs-attr\">:checked</span>=<span class=\"hljs-string\">\"checkAll\"</span> @<span class=\"hljs-attr\">change</span>=<span class=\"hljs-string\">\"onCheckAllChange\"</span>></span>\n Check all\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox-group</span> <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"checkboxList\"</span> @<span class=\"hljs-attr\">change</span>=<span class=\"hljs-string\">\"checkboxOnChange\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictRadio\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span>></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox-group</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#else>\n</#if>\n</#if>\n</#list>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-modal</span>></span>\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">template</span>></span>\n\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">script</span>></span>\n<span class=\"hljs-keyword\">import</span> { save${className} } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api<#if moduleName?? && moduleName != \"\">/${moduleName}</#if>/${businessName}/${objectName}\'</span>\n<span class=\"hljs-keyword\">import</span> pick <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'lodash.pick\'</span>\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n<span class=\"hljs-keyword\">import</span> { sysDictTypeDropDown } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api/system/dict/sysDictType\'</span>\n<#<span class=\"hljs-keyword\">break</span>>\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n\n<span class=\"hljs-keyword\">export</span> <span class=\"hljs-keyword\">default</span> {\n <span class=\"hljs-attr\">name</span>: <span class=\"hljs-string\">\'${className}Modal\'</span>,\n <span class=\"hljs-attr\">props</span>: {},\n <span class=\"hljs-attr\">components</span>: {},\n data () {\n <span class=\"hljs-keyword\">return</span> {\n <span class=\"hljs-attr\">visible</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">labelCol</span>: {\n <span class=\"hljs-attr\">xs</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">24</span> },\n <span class=\"hljs-attr\">sm</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">5</span> }\n },\n <span class=\"hljs-attr\">wrapperCol</span>: {\n <span class=\"hljs-attr\">xs</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">24</span> },\n <span class=\"hljs-attr\">sm</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">16</span> }\n },\n <span class=\"hljs-attr\">confirmLoading</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">mdl</span>: {},\n <span class=\"hljs-attr\">form</span>: <span class=\"hljs-built_in\">this</span>.$form.createForm(<span class=\"hljs-built_in\">this</span>),\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n ${column.javaField}DictTypeDropDown: [],\n<#elseif column.htmlType == <span class=\"hljs-string\">\"radio\"</span>>\n ${column.javaField}DictRadio: [],\n<#elseif column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n ${column.javaField}DictCheckbox: [],\n <span class=\"hljs-attr\">checkboxList</span>: [],\n <span class=\"hljs-attr\">indeterminate</span>: <span class=\"hljs-literal\">true</span>,\n <span class=\"hljs-attr\">checkAll</span>: <span class=\"hljs-literal\">false</span>,\n<#<span class=\"hljs-keyword\">else</span>>\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n title: <span class=\"hljs-string\">\'\'</span>\n }\n },\n beforeCreate () {},\n created () {\n <span class=\"hljs-built_in\">this</span>.sysDictTypeDropDown()\n },\n <span class=\"hljs-attr\">methods</span>: {\n <span class=\"hljs-comment\">// 添加</span>\n add () {\n <span class=\"hljs-built_in\">this</span>.form.resetFields()\n <span class=\"hljs-built_in\">this</span>.edit({ ${primaryKeyColumn}: <span class=\"hljs-number\">0</span> })\n },\n <span class=\"hljs-comment\">// 编辑修改</span>\n edit (record) {\n <span class=\"hljs-built_in\">this</span>.mdl = <span class=\"hljs-built_in\">Object</span>.assign(record)\n <span class=\"hljs-built_in\">this</span>.title = record.${primaryKeyColumn} === <span class=\"hljs-number\">0</span> ? <span class=\"hljs-string\">\'添加<#if comment??>${comment}</#if>\'</span> : <span class=\"hljs-string\">\'修改<#if comment??>${comment}</#if>\'</span>\n <span class=\"hljs-built_in\">this</span>.visible = <span class=\"hljs-literal\">true</span>\n <span class=\"hljs-built_in\">this</span>.$nextTick(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.form.setFieldsValue(pick(<span class=\"hljs-built_in\">this</span>.mdl, <#list tableColumns <span class=\"hljs-keyword\">as</span> column><#<span class=\"hljs-keyword\">if</span> column.htmlType != <span class=\"hljs-string\">\'datetime\'</span>><#<span class=\"hljs-keyword\">if</span> column_index = <span class=\"hljs-number\">0</span>><span class=\"hljs-string\">\'${column.javaField}\'</span><#elseif column_has_next>, <span class=\"hljs-string\">\'${column.javaField}\'</span><<span class=\"hljs-regexp\">/#if></</span>#<span class=\"hljs-keyword\">if</span>></#list>))\n })\n },\n <span class=\"hljs-comment\">// 加载字典</span>\n sysDictTypeDropDown () {\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictTypeDropDown = res.data\n })\n<#elseif column.htmlType == <span class=\"hljs-string\">\"radio\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictRadio = res.data\n })\n<#elseif column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictCheckbox = res.data\n })\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n },\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n <span class=\"hljs-comment\">// 处理多选框全选</span>\n onChange (checkedList) {\n <span class=\"hljs-built_in\">this</span>.indeterminate = !!checkedList.length && checkedList.length < ${column.javaField}DictCheckbox.length;\n <span class=\"hljs-built_in\">this</span>.checkAll = checkedList.length === ${column.javaField}DictCheckbox.length;\n },\n <span class=\"hljs-function\"><span class=\"hljs-title\">onCheckAllChange</span>(<span class=\"hljs-params\">e</span>)</span> {\n <span class=\"hljs-built_in\">Object</span>.assign(<span class=\"hljs-built_in\">this</span>, {\n <span class=\"hljs-attr\">checkedList</span>: e.target.checked ? ${column.javaField}DictCheckbox : [],\n <span class=\"hljs-attr\">indeterminate</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">checkAll</span>: e.target.checked,\n });\n },\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n <span class=\"hljs-comment\">// 提交数据</span>\n handleSubmit (e) {\n e.preventDefault()\n <span class=\"hljs-built_in\">this</span>.form.validateFields(<span class=\"hljs-function\">(<span class=\"hljs-params\">err, values</span>) =></span> {\n <span class=\"hljs-keyword\">if</span> (!err) {\n <span class=\"hljs-built_in\">this</span>.confirmLoading = <span class=\"hljs-literal\">true</span>\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n values.${column} == checkboxList.join(<span class=\"hljs-string\">\',\'</span>)\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n save${className}(values).then(<span class=\"hljs-function\"><span class=\"hljs-params\">res</span> =></span> {\n <span class=\"hljs-keyword\">if</span> (res.code === <span class=\"hljs-number\">200</span>) {\n <span class=\"hljs-built_in\">this</span>.$message.success(<span class=\"hljs-string\">\'保存成功\'</span>)\n <span class=\"hljs-built_in\">this</span>.$emit(<span class=\"hljs-string\">\'ok\'</span>)\n <span class=\"hljs-built_in\">this</span>.visible = <span class=\"hljs-literal\">false</span>\n } <span class=\"hljs-keyword\">else</span> {\n <span class=\"hljs-built_in\">this</span>.$message.error(res.message)\n }\n }).catch(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.$message.error(<span class=\"hljs-string\">\'系统错误，请稍后再试\'</span>)\n }).finally(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.confirmLoading = <span class=\"hljs-literal\">false</span>\n })\n }\n })\n }\n }\n}\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">script</span>></span>\n</pre>',
'vue', 1, 1, NOW()),
(16, 4, 'Api',
'<pre class=\"ql-syntax\" spellcheck=\"false\">import request from <span class=\"hljs-string\">\'@/utils/request\'</span>\n\n/**\n* <<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\nconst api = {\n <span class=\"hljs-variable\">${objectName}</span>: <span class=\"hljs-string\">\'/${businessName}\'</span>\n}\n\n/**\n* 分页查询<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> get<span class=\"hljs-variable\">${className}</span>PageList (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + <span class=\"hljs-string\">\'/pageList\'</span>,\n method: <span class=\"hljs-string\">\'get\'</span>,\n params: parameter\n })\n}\n\n/**\n* 修改/保存<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> save<span class=\"hljs-variable\">${className}</span> (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + (parameter.<span class=\"hljs-variable\">${primaryKeyColumn.javaField}</span> > 0 ? <span class=\"hljs-string\">\'/update\'</span> : <span class=\"hljs-string\">\'/save\'</span>),\n method: <span class=\"hljs-string\">\'post\'</span>,\n data: parameter,\n headers: {\n <span class=\"hljs-string\">\'Content-Type\'</span>: <span class=\"hljs-string\">\'application/json;charset=UTF-8\'</span>\n }\n })\n}\n\n/**\n* 批量删除<<span class=\"hljs-comment\">#if comment??>${comment}</#if></span>\n*/\n<span class=\"hljs-built_in\">export</span> <span class=\"hljs-keyword\">function</span> del<span class=\"hljs-variable\">${className}</span> (parameter) {\n <span class=\"hljs-built_in\">return</span> request({\n url: api.<span class=\"hljs-variable\">${objectName}</span> + <span class=\"hljs-string\">\'/delete\'</span>,\n method: <span class=\"hljs-string\">\'post\'</span>,\n params: parameter\n })\n}\n</pre>',
'js', 0, 1, NOW()),
(17, 3, 'List',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><span class=\"hljs-tag\"><<span class=\"hljs-name\">template</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-card</span> <span class=\"hljs-attr\">:bordered</span>=<span class=\"hljs-string\">\"false\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">div</span> <span class=\"hljs-attr\">class</span>=<span class=\"hljs-string\">\"table-page-search-wrapper\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form</span> <span class=\"hljs-attr\">layout</span>=<span class=\"hljs-string\">\"inline\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-row</span> <span class=\"hljs-attr\">:gutter</span>=<span class=\"hljs-string\">\"48\"</span>></span>\n<#list tableColumns as column>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#else>${column_index}</#if></#assign>\n<#if column.isQuery && column.htmlType == \"input\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-col</span> <span class=\"hljs-attr\">:md</span>=<span class=\"hljs-string\">\"5\"</span> <span class=\"hljs-attr\">:sm</span>=<span class=\"hljs-string\">\"15\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"$</span></span>{columnComment}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-input</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"请输入$</span></span>{columnComment}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span> <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"queryParam.$</span></span>{column.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-col</span>></span>\n<#elseif column.htmlType == \"dropdown\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-col</span> <span class=\"hljs-attr\">:md</span>=<span class=\"hljs-string\">\"5\"</span> <span class=\"hljs-attr\">:sm</span>=<span class=\"hljs-string\">\"15\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"$</span></span>{columnComment}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"queryParam.$</span></span>{column.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"请选择$</span></span>{columnComment}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select-option</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in $</span></span>{column.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">DictTypeDropDown\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span> ></span>\n {{ item.name }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select-option</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-col</span>></span>\n<#else>\n</#if>\n</#list>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-col</span> <span class=\"hljs-attr\">:md</span>=<span class=\"hljs-string\">\"5\"</span> <span class=\"hljs-attr\">:sm</span>=<span class=\"hljs-string\">\"15\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">span</span> <span class=\"hljs-attr\">class</span>=<span class=\"hljs-string\">\"table-page-search-submitButtons\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-button</span> <span class=\"hljs-attr\">type</span>=<span class=\"hljs-string\">\"primary\"</span> @<span class=\"hljs-attr\">click</span>=<span class=\"hljs-string\">\"$refs.table.refresh(true)\"</span>></span>查询<span class=\"hljs-tag\"></<span class=\"hljs-name\">a-button</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-button</span> <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"margin-left: 8px\"</span> @<span class=\"hljs-attr\">click</span>=<span class=\"hljs-string\">\"() => queryParam = </span></span>{}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>></span>重置<span class=\"hljs-tag\"></<span class=\"hljs-name\">a-button</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a</span> @<span class=\"hljs-attr\">click</span>=<span class=\"hljs-string\">\"toggleAdvanced\"</span> <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"margin-left: 8px\"</span>></span>\n {{ advanced ? \'收起\' : \'展开\' }}\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-icon</span> <span class=\"hljs-attr\">:type</span>=<span class=\"hljs-string\">\"advanced ? \'up\' : \'down\'\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">span</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-col</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-row</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">div</span>></span>\n\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-space</span> <span class=\"hljs-attr\">align</span>=<span class=\"hljs-string\">\"center\"</span> <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"margin-bottom: 16px\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-button</span> <span class=\"hljs-attr\">type</span>=<span class=\"hljs-string\">\"primary\"</span> <span class=\"hljs-attr\">icon</span>=<span class=\"hljs-string\">\"plus\"</span> @<span class=\"hljs-attr\">click</span>=<span class=\"hljs-string\">\"handleAdd\"</span>></span>新增<span class=\"hljs-tag\"></<span class=\"hljs-name\">a-button</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-dropdown</span> <span class=\"hljs-attr\">v-if</span>=<span class=\"hljs-string\">\"selectedRowKeys.length > 0\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-popconfirm</span> <span class=\"hljs-attr\">placement</span>=<span class=\"hljs-string\">\"topRight\"</span> <span class=\"hljs-attr\">title</span>=<span class=\"hljs-string\">\"确认删除？\"</span> @<span class=\"hljs-attr\">confirm</span>=<span class=\"hljs-string\">\"() => delByIds(selectedRowKeys)\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-button</span> <span class=\"hljs-attr\">type</span>=<span class=\"hljs-string\">\"primary\"</span> <span class=\"hljs-attr\">icon</span>=<span class=\"hljs-string\">\"close\"</span>></span>删除<span class=\"hljs-tag\"></<span class=\"hljs-name\">a-button</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-popconfirm</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-dropdown</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-space</span>></span>\n\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">s-table</span>\n <span class=\"hljs-attr\">size</span>=<span class=\"hljs-string\">\"default\"</span>\n <span class=\"hljs-attr\">ref</span>=<span class=\"hljs-string\">\"table\"</span>\n <span class=\"hljs-attr\">rowKey</span>=<span class=\"hljs-string\">\"$</span></span>{primaryKeyColumn.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>\n <span class=\"hljs-attr\">:rowSelection</span>=<span class=\"hljs-string\">\"</span></span>{selectedRowKeys: selectedRowKeys, onChange: onSelectChange}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span>\n <span class=\"hljs-attr\">:columns</span>=<span class=\"hljs-string\">\"columns\"</span>\n <span class=\"hljs-attr\">:data</span>=<span class=\"hljs-string\">\"loadData\"</span>\n <span class=\"hljs-attr\">:rangPicker</span>=<span class=\"hljs-string\">\"range\"</span>\n ></span>\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">span</span> <span class=\"hljs-attr\">slot</span>=<span class=\"hljs-string\">\"$</span></span>{column.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">\"</span> <span class=\"hljs-attr\">slot-scope</span>=<span class=\"hljs-string\">\"text\"</span>></span>\n {{ ${column.javaField}Filter(text) }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">span</span>></span>\n</#if>\n</#list>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">span</span> <span class=\"hljs-attr\">slot</span>=<span class=\"hljs-string\">\"action\"</span> <span class=\"hljs-attr\">slot-scope</span>=<span class=\"hljs-string\">\"text, record\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a</span> @<span class=\"hljs-attr\">click</span>=<span class=\"hljs-string\">\"handleEdit(record)\"</span>></span>编辑<span class=\"hljs-tag\"></<span class=\"hljs-name\">a</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-divider</span> <span class=\"hljs-attr\">type</span>=<span class=\"hljs-string\">\"vertical\"</span>/></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-popconfirm</span> <span class=\"hljs-attr\">placement</span>=<span class=\"hljs-string\">\"topRight\"</span> <span class=\"hljs-attr\">title</span>=<span class=\"hljs-string\">\"确认删除？\"</span> @<span class=\"hljs-attr\">confirm</span>=<span class=\"hljs-string\">\"() => delByIds([record.$</span></span>{primaryKeyColumn.javaField}<span class=\"hljs-tag\"><span class=\"hljs-string\">])\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a</span>></span>删除<span class=\"hljs-tag\"></<span class=\"hljs-name\">a</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-popconfirm</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">span</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">s-table</span>></span>\n <${objectName}-modal ref=\"${businessName}\" @ok=\"handleOk\"/>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-card</span>></span>\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">template</span>></span>\n\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">script</span>></span>\n<span class=\"hljs-keyword\">import</span> { STable } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/components\'</span>\n<span class=\"hljs-keyword\">import</span> { del${className}, get${className}PageList } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api<#if moduleName??>/$</span>{moduleName}<<span class=\"hljs-regexp\">/#if>/</span>${businessName}/${objectName}\'\nimport ${className}Modal <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'./modal/$</span>{className}Modal\'\n<#list tableColumns as column>\n<#if column.htmlType == \"dropdown\">\nimport { sysDictTypeDropDown } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api/system/dict/sysDictType\'</span>\n<#<span class=\"hljs-keyword\">break</span>>\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n\n<span class=\"hljs-keyword\">export</span> <span class=\"hljs-keyword\">default</span> {\n name: \'${className}List\',\n components: {\n STable,\n ${className}Modal\n },\n data () {\n return {\n labelCol: {\n xs: { span: 24 },\n sm: { span: 5 }\n },\n wrapperCol: {\n xs: { span: 24 },\n sm: { span: 16 }\n },\n <span class=\"hljs-attr\">form</span>: <span class=\"hljs-built_in\">this</span>.$form.createForm(<span class=\"hljs-built_in\">this</span>),\n <span class=\"hljs-attr\">mdl</span>: {},\n <span class=\"hljs-comment\">// 高级搜索 展开/关闭</span>\n <span class=\"hljs-attr\">advanced</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-comment\">// 查询参数</span>\n <span class=\"hljs-attr\">queryParam</span>: {},\n <span class=\"hljs-comment\">// 表头</span>\n <span class=\"hljs-attr\">columns</span>: [\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#assign javaField = <span class=\"hljs-string\">\'$</span>{column.javaField}\'>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#<span class=\"hljs-keyword\">else</span>>${column_index}<<span class=\"hljs-regexp\">/#if></</span>#assign>\n<#<span class=\"hljs-keyword\">if</span> column.isList == <span class=\"hljs-literal\">true</span>>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\'datetime\'</span>>\n {\n title: \'${columnComment}\',\n dataIndex: \'${javaField}\',\n scopedSlots: { customRender: \'${javaField}\' },\n sorter: true,\n align: \'center\'\n },\n<#else>\n {\n title: \'${columnComment}\',\n dataIndex: \'${javaField}\',\n scopedSlots: { customRender: \'${javaField}\' },\n align: \'center\'\n },\n</#if>\n</#if>\n</#list>\n {\n title: \'操作\',\n width: \'240px\',\n dataIndex: \'action\',\n align: \'center\',\n scopedSlots: { customRender: \'action\' }\n }\n ],\n <span class=\"hljs-attr\">range</span>: <span class=\"hljs-literal\">null</span>,\n <span class=\"hljs-comment\">// 加载数据方法 必须为 Promise 对象</span>\n <span class=\"hljs-attr\">loadData</span>: <span class=\"hljs-function\"><span class=\"hljs-params\">parameter</span> =></span> {\n return get${className}PageList(<span class=\"hljs-built_in\">Object</span>.assign(parameter, <span class=\"hljs-built_in\">this</span>.queryParam)).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n return res.data\n })\n },\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n ${column.javaField}DictTypeDropDown: [],\n</#if>\n</#list>\n selectedRowKeys: [],\n selectedRows: []\n }\n },\n filters: {\n },\n created () {\n this.sysDictTypeDropDown()\n },\n methods: {\n // 处理多选\n onSelectChange (selectedRowKeys, selectedRows) {\n this.selectedRowKeys = selectedRowKeys\n this.selectedRows = selectedRows\n },\n <span class=\"hljs-comment\">// 提交完成后刷新</span>\n handleOk () {\n this.$refs.table.refresh(true)\n },\n <span class=\"hljs-comment\">// 加载字典</span>\n sysDictTypeDropDown () {\n<#list tableColumns as column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == \"dropdown\">\n sysDictTypeDropDown({ code: \'${column.javaField}\' }).then((res) => {\n this.${column.javaField}DictTypeDropDown = res.data\n })\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n },\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n <span class=\"hljs-comment\">// 匹配字典</span>\n ${column.javaField}Filter (${column.javaField}) {\n // eslint-disable-next-line eqeqeq\n const values = this.${column.javaField}DictTypeDropDown.filter(<span class=\"hljs-function\"><span class=\"hljs-params\">item</span> =></span> item.key == ${column.javaField})\n if (values.length > 0) {\n return values[0].name\n }\n },\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n <span class=\"hljs-comment\">// 添加</span>\n handleAdd () {\n this.$refs.${businessName}.add()\n },\n <span class=\"hljs-comment\">// 修改</span>\n handleEdit (record) {\n this.$refs.${businessName}.edit(record)\n },\n <span class=\"hljs-comment\">// 批量删除</span>\n delByIds (ids) {\n del${className}({ ids: ids.join(\',\') }).then(<span class=\"hljs-function\"><span class=\"hljs-params\">res</span> =></span> {\n <span class=\"hljs-keyword\">if</span> (res.code === 200) {\n this.$message.success(\'删除成功\')\n this.handleOk()\n } <span class=\"hljs-keyword\">else</span> {\n this.$message.error(res.message)\n }\n <span class=\"hljs-built_in\">this</span>.selectedRowKeys = []\n })\n },\n <span class=\"hljs-comment\">// 提供更多查询条件选项</span>\n toggleAdvanced () {\n this.advanced = !this.advanced\n }\n }\n}\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">script</span>></span>\n</pre>',
'vue', 0, 1, NOW()),
(18, 3, 'Modal',
'<pre class=\"ql-syntax\" spellcheck=\"false\"><#assign primaryKeyColumn = \'${primaryKeyColumn.javaField}\'>\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">template</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-modal</span>\n <span class=\"hljs-attr\">:title</span>=<span class=\"hljs-string\">\"title\"</span>\n <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"top: 20px;\"</span>\n <span class=\"hljs-attr\">width</span>=<span class=\"hljs-string\">\"40%\"</span>\n <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"visible\"</span>\n <span class=\"hljs-attr\">:confirmLoading</span>=<span class=\"hljs-string\">\"confirmLoading\"</span>\n @<span class=\"hljs-attr\">ok</span>=<span class=\"hljs-string\">\"handleSubmit\"</span>\n ></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form</span> <span class=\"hljs-attr\">:form</span>=<span class=\"hljs-string\">\"form\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">style</span>=<span class=\"hljs-string\">\"display:none\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-input</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${primaryKeyColumn}\']\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#list tableColumns as column>\n<#assign columnComment><#if column.columnComment??>${column.columnComment}<#else>${column_index}</#if></#assign>\n<#assign javaField = \'${column.javaField}\'>\n<#if !column.isPrimaryKey && column.isEdit>\n<#if column.htmlType == \"input\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-input</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请输入${columnComment}\'}]}</#if>]\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"dropdown\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"请选择${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请选择${columnComment}\'}]}</#if>]\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-select-option</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictTypeDropDown\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span> ></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select-option</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-select</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"text\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-textarea</span> <span class=\"hljs-attr\">allow-clear</span> <span class=\"hljs-attr\">placeholder</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">:auto-size</span>=<span class=\"hljs-string\">\"{ minRows: 3, maxRows: 8 }\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\']\"</span>/></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"radio\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">has-feedback</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-radio-group</span> <span class=\"hljs-attr\">name</span>=<span class=\"hljs-string\">\"${columnComment}\"</span> <span class=\"hljs-attr\">v-decorator</span>=<span class=\"hljs-string\">\"[\'${javaField}\'<#if column.isRequired>, {rules: [{required: true, message: \'请选择${columnComment}\'}]}</#if>]\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-radio</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictRadio\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span>></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-radio</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-radio-group</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#elseif column.htmlType == \"checkbox\">\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-form-item</span> <span class=\"hljs-attr\">:labelCol</span>=<span class=\"hljs-string\">\"labelCol\"</span> <span class=\"hljs-attr\">:wrapperCol</span>=<span class=\"hljs-string\">\"wrapperCol\"</span> <span class=\"hljs-attr\">label</span>=<span class=\"hljs-string\">\"${columnComment}\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox</span> <span class=\"hljs-attr\">:indeterminate</span>=<span class=\"hljs-string\">\"indeterminate\"</span> <span class=\"hljs-attr\">:checked</span>=<span class=\"hljs-string\">\"checkAll\"</span> @<span class=\"hljs-attr\">change</span>=<span class=\"hljs-string\">\"onCheckAllChange\"</span>></span>\n Check all\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox-group</span> <span class=\"hljs-attr\">v-model</span>=<span class=\"hljs-string\">\"checkboxList\"</span> @<span class=\"hljs-attr\">change</span>=<span class=\"hljs-string\">\"checkboxOnChange\"</span>></span>\n <span class=\"hljs-tag\"><<span class=\"hljs-name\">a-checkbox</span> <span class=\"hljs-attr\">v-for</span>=<span class=\"hljs-string\">\"(item,index) in ${javaField}DictRadio\"</span> <span class=\"hljs-attr\">:key</span>=<span class=\"hljs-string\">\"index\"</span> <span class=\"hljs-attr\">:value</span>=<span class=\"hljs-string\">\"item.key\"</span>></span>\n {{ <span class=\"hljs-name\">item.name</span> }}\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-checkbox-group</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form-item</span>></span>\n<#else>\n</#if>\n</#if>\n</#list>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-form</span>></span>\n <span class=\"hljs-tag\"></<span class=\"hljs-name\">a-modal</span>></span>\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">template</span>></span>\n\n<span class=\"hljs-tag\"><<span class=\"hljs-name\">script</span>></span>\n<span class=\"hljs-keyword\">import</span> { save${className} } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api/${moduleName}/${businessName}/${objectName}\'</span>\n<span class=\"hljs-keyword\">import</span> pick <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'lodash.pick\'</span>\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n<span class=\"hljs-keyword\">import</span> { sysDictTypeDropDown } <span class=\"hljs-keyword\">from</span> <span class=\"hljs-string\">\'@/api/system/dict/sysDictType\'</span>\n<#<span class=\"hljs-keyword\">break</span>>\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n\n<span class=\"hljs-keyword\">export</span> <span class=\"hljs-keyword\">default</span> {\n <span class=\"hljs-attr\">name</span>: <span class=\"hljs-string\">\'${className}Modal\'</span>,\n <span class=\"hljs-attr\">props</span>: {},\n <span class=\"hljs-attr\">components</span>: {},\n data () {\n <span class=\"hljs-keyword\">return</span> {\n <span class=\"hljs-attr\">visible</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">labelCol</span>: {\n <span class=\"hljs-attr\">xs</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">24</span> },\n <span class=\"hljs-attr\">sm</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">5</span> }\n },\n <span class=\"hljs-attr\">wrapperCol</span>: {\n <span class=\"hljs-attr\">xs</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">24</span> },\n <span class=\"hljs-attr\">sm</span>: { <span class=\"hljs-attr\">span</span>: <span class=\"hljs-number\">16</span> }\n },\n <span class=\"hljs-attr\">confirmLoading</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">mdl</span>: {},\n <span class=\"hljs-attr\">form</span>: <span class=\"hljs-built_in\">this</span>.$form.createForm(<span class=\"hljs-built_in\">this</span>),\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n ${column.javaField}DictTypeDropDown: [],\n<#elseif column.htmlType == <span class=\"hljs-string\">\"radio\"</span>>\n ${column.javaField}DictRadio: [],\n<#elseif column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n ${column.javaField}DictCheckbox: [],\n <span class=\"hljs-attr\">checkboxList</span>: [],\n <span class=\"hljs-attr\">indeterminate</span>: <span class=\"hljs-literal\">true</span>,\n <span class=\"hljs-attr\">checkAll</span>: <span class=\"hljs-literal\">false</span>,\n<#<span class=\"hljs-keyword\">else</span>>\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n title: <span class=\"hljs-string\">\'\'</span>\n }\n },\n beforeCreate () {},\n created () {\n <span class=\"hljs-built_in\">this</span>.sysDictTypeDropDown()\n },\n <span class=\"hljs-attr\">methods</span>: {\n <span class=\"hljs-comment\">// 添加</span>\n add () {\n <span class=\"hljs-built_in\">this</span>.form.resetFields()\n <span class=\"hljs-built_in\">this</span>.edit({ ${primaryKeyColumn}: <span class=\"hljs-number\">0</span> })\n },\n <span class=\"hljs-comment\">// 编辑修改</span>\n edit (record) {\n <span class=\"hljs-built_in\">this</span>.mdl = <span class=\"hljs-built_in\">Object</span>.assign(record)\n <span class=\"hljs-built_in\">this</span>.title = record.${primaryKeyColumn} === <span class=\"hljs-number\">0</span> ? <span class=\"hljs-string\">\'添加<#if comment??>${comment}</#if>\'</span> : <span class=\"hljs-string\">\'修改<#if comment??>${comment}</#if>\'</span>\n <span class=\"hljs-built_in\">this</span>.visible = <span class=\"hljs-literal\">true</span>\n <span class=\"hljs-built_in\">this</span>.$nextTick(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.form.setFieldsValue(pick(<span class=\"hljs-built_in\">this</span>.mdl, <#list tableColumns <span class=\"hljs-keyword\">as</span> column><#<span class=\"hljs-keyword\">if</span> column.htmlType != <span class=\"hljs-string\">\'datetime\'</span>><#<span class=\"hljs-keyword\">if</span> column_index = <span class=\"hljs-number\">0</span>><span class=\"hljs-string\">\'${column.javaField}\'</span><#elseif column_has_next>, <span class=\"hljs-string\">\'${column.javaField}\'</span><<span class=\"hljs-regexp\">/#if></</span>#<span class=\"hljs-keyword\">if</span>></#list>))\n })\n },\n <span class=\"hljs-comment\">// 加载字典</span>\n sysDictTypeDropDown () {\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"dropdown\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictTypeDropDown = res.data\n })\n<#elseif column.htmlType == <span class=\"hljs-string\">\"radio\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictRadio = res.data\n })\n<#elseif column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n sysDictTypeDropDown({ <span class=\"hljs-attr\">code</span>: <span class=\"hljs-string\">\'${column.javaField}\'</span> }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">res</span>) =></span> {\n <span class=\"hljs-built_in\">this</span>.${column.javaField}DictCheckbox = res.data\n })\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n },\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n <span class=\"hljs-comment\">// 处理多选框全选</span>\n onChange (checkedList) {\n <span class=\"hljs-built_in\">this</span>.indeterminate = !!checkedList.length && checkedList.length < ${column.javaField}DictCheckbox.length;\n <span class=\"hljs-built_in\">this</span>.checkAll = checkedList.length === ${column.javaField}DictCheckbox.length;\n },\n <span class=\"hljs-function\"><span class=\"hljs-title\">onCheckAllChange</span>(<span class=\"hljs-params\">e</span>)</span> {\n <span class=\"hljs-built_in\">Object</span>.assign(<span class=\"hljs-built_in\">this</span>, {\n <span class=\"hljs-attr\">checkedList</span>: e.target.checked ? ${column.javaField}DictCheckbox : [],\n <span class=\"hljs-attr\">indeterminate</span>: <span class=\"hljs-literal\">false</span>,\n <span class=\"hljs-attr\">checkAll</span>: e.target.checked,\n });\n },\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n <span class=\"hljs-comment\">// 提交数据</span>\n handleSubmit (e) {\n e.preventDefault()\n <span class=\"hljs-built_in\">this</span>.form.validateFields(<span class=\"hljs-function\">(<span class=\"hljs-params\">err, values</span>) =></span> {\n <span class=\"hljs-keyword\">if</span> (!err) {\n <span class=\"hljs-built_in\">this</span>.confirmLoading = <span class=\"hljs-literal\">true</span>\n<#list tableColumns <span class=\"hljs-keyword\">as</span> column>\n<#<span class=\"hljs-keyword\">if</span> column.htmlType == <span class=\"hljs-string\">\"checkbox\"</span>>\n values.${column} == checkboxList.join(<span class=\"hljs-string\">\',\'</span>)\n</#<span class=\"hljs-keyword\">if</span>>\n</#list>\n save${className}(values).then(<span class=\"hljs-function\"><span class=\"hljs-params\">res</span> =></span> {\n <span class=\"hljs-keyword\">if</span> (res.code === <span class=\"hljs-number\">200</span>) {\n <span class=\"hljs-built_in\">this</span>.$message.success(<span class=\"hljs-string\">\'保存成功\'</span>)\n <span class=\"hljs-built_in\">this</span>.$emit(<span class=\"hljs-string\">\'ok\'</span>)\n <span class=\"hljs-built_in\">this</span>.visible = <span class=\"hljs-literal\">false</span>\n } <span class=\"hljs-keyword\">else</span> {\n <span class=\"hljs-built_in\">this</span>.$message.error(res.message)\n }\n }).catch(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.$message.error(<span class=\"hljs-string\">\'系统错误，请稍后再试\'</span>)\n }).finally(<span class=\"hljs-function\">() =></span> {\n <span class=\"hljs-built_in\">this</span>.confirmLoading = <span class=\"hljs-literal\">false</span>\n })\n }\n })\n }\n }\n}\n<span class=\"hljs-tag\"></<span class=\"hljs-name\">script</span>></span>\n</pre>',
'vue', 0, 1, NOW());
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;