| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603 |
- <template>
- <div class="app-container">
- <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
- {%- for column in table.columns %}
- {%- if column.is_query %}
- <el-form-item label="{{ column.column_comment }}" prop="{{ column.java_field }}">
- {%- if column.html_type == 'input' %}
- <el-input
- v-model="queryParams.{{ column.java_field }}"
- placeholder="请输入{{ column.column_comment }}"
- clearable
- @keyup.enter.native="handleQuery"
- />
- {%- elif column.html_type == 'select' %}
- {%- if column.dict_type != '' %}
- <el-select v-model="queryParams.{{ column.java_field }}" placeholder="请选择{{ column.column_comment }}" clearable>
- <el-option
- v-for="dict in dict.type.{{ column.dict_type }}"
- :key="dict.value"
- :label="dict.label"
- :value="dict.value"
- />
- </el-select>
- {%- else %}
- <el-select v-model="queryParams.{{ column.java_field }}" placeholder="请选择{{ column.column_comment }}" clearable>
- <el-option label="请选择字典生成" value="" />
- </el-select>
- {%- endif %}
- {%- elif column.html_type == 'datetime' %}
- {%- set attr_name = capitalize_first(column.java_field) %}
- <el-date-picker
- v-model="dateRange{{ attr_name }}"
- value-format="yyyy-MM-dd"
- type="daterange"
- range-separator="-"
- start-placeholder="开始日期"
- end-placeholder="结束日期"
- ></el-date-picker>
- {%- endif %}
- </el-form-item>
- {%- endif %}
- {%- endfor %}
- <el-form-item>
- <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
- <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
- </el-form-item>
- </el-form>
- <el-row :gutter="10" class="mb8">
- <el-col :span="1.5">
- <el-button
- type="primary"
- plain
- icon="el-icon-plus"
- size="mini"
- @click="handleAdd"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:add']"
- >新增</el-button>
- </el-col>
- <el-col :span="1.5">
- <el-button
- type="success"
- plain
- icon="el-icon-edit"
- size="mini"
- :disabled="single"
- @click="handleUpdate"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:edit']"
- >修改</el-button>
- </el-col>
- <el-col :span="1.5">
- <el-button
- type="danger"
- plain
- icon="el-icon-delete"
- size="mini"
- :disabled="multiple"
- @click="handleDelete"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:remove']"
- >删除</el-button>
- </el-col>
- <el-col :span="1.5">
- <el-button
- type="warning"
- plain
- icon="el-icon-download"
- size="mini"
- @click="handleExport"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:export']"
- >导出</el-button>
- </el-col>
- <el-col :span="1.5">
- <el-button
- type="info"
- plain
- icon="el-icon-upload2"
- size="mini"
- @click="handleImport"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:import']"
- >导入</el-button>
- </el-col>
- <right-toolbar :showSearch.sync="showSearch" @queryTable="getList" :columns="columns"></right-toolbar>
- </el-row>
- <el-table :loading="loading" :data="{{ table.business_name }}List" @selection-change="handleSelectionChange">
- <el-table-column type="selection" width="55" align="center" />
- {%- for column in table.columns %}
- {%- set java_field = column.java_field %}
- {%- set comment = column.column_comment %}
- {%- if '(' in comment or '(' in comment %}
- {%- if '(' in comment %}
- {%- set comment = comment.split('(')[0] %}
- {%- elif '(' in comment %}
- {%- set comment = comment.split('(')[0] %}
- {%- endif %}
- {%- endif %}
- {%- if column.is_list and column.list_index is not none and column.html_type == 'datetime' %}
- <el-table-column label="{{ comment }}" align="center" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}" width="180">
- <template slot-scope="scope">
- <span>{{ "{{ parseTime(scope.row." }}{{ java_field }}{{ ", '{y}-{m}-{d}') }}" }}</span>
- </template>
- </el-table-column>
- {%- elif column.is_list and column.list_index is not none and column.html_type == 'imageUpload' %}
- <el-table-column label="{{ comment }}" align="center" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}" width="100">
- <template slot-scope="scope">
- <image-preview :src="scope.row.{{ java_field }}" :width="50" :height="50"/>
- </template>
- </el-table-column>
- {%- elif column.is_list and column.list_index is not none and column.html_type == 'fileUpload' %}
- <el-table-column label="{{ comment }}" align="center" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}" width="100">
- <template slot-scope="scope">
- <div v-if="scope.row.{{ underscore(java_field) }}">
- <el-tooltip placement="top" effect="light">
- <div slot="content">
- <div v-for="(file,index) in scope.row.{{ java_field }}.split(',')"
- :key="index"
- style="text-align: left;padding: 5px;">
- <el-link
- :download="getFileName(file)"
- :href="getFilePath(file)"
- :underline="false"
- target="_blank"
- style="font-size: 14px"
- >
- <span style="cursor: pointer;"> {{ "{{ getFileName(file) }}" }} </span>
- </el-link>
- </div>
- </div>
- <span style="cursor: pointer; color: #409EFF;">查看文件</span>
- </el-tooltip>
- </div>
- <div v-else>
- -
- </div>
- </template>
- </el-table-column>
- {%- elif column.is_list and column.list_index is not none and column.dict_type and column.dict_type != '' %}
- <el-table-column label="{{ comment }}" align="center" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}">
- <template slot-scope="scope">
- {%- if column.html_type == 'checkbox' %}
- <dict-tag :options="dict.type.{{ column.dict_type }}" :value="scope.row.{{ java_field }} ? scope.row.{{ java_field }}.split(',') : []"/>
- {%- else %}
- <dict-tag :options="dict.type.{{ column.dict_type }}" :value="scope.row.{{ java_field }}"/>
- {%- endif %}
- </template>
- </el-table-column>
- {%- elif column.is_list and column.list_index is not none and java_field %}
- {%- if column.list_index == 0 %}
- <el-table-column label="{{ comment }}" :show-overflow-tooltip="true" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}" />
- {%- else %}
- <el-table-column label="{{ comment }}" align="center" :show-overflow-tooltip="true" v-if="columns[{{ column.list_index }}].visible" prop="{{ java_field }}" />
- {%- endif %}
- {%- endif %}
- {%- endfor %}
- <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
- <template slot-scope="scope">
- <el-button
- size="mini"
- type="text"
- icon="el-icon-edit"
- @click="handleUpdate(scope.row)"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:edit']"
- >修改</el-button>
- <el-button
- size="mini"
- type="text"
- icon="el-icon-delete"
- @click="handleDelete(scope.row)"
- v-hasPermi="['{{ table.module_name }}:{{ table.business_name }}:remove']"
- >删除</el-button>
- </template>
- </el-table-column>
- </el-table>
- <pagination
- v-show="total>0"
- :total="total"
- :page.sync="queryParams.pageNum"
- :limit.sync="queryParams.pageSize"
- @pagination="getList"
- />
- <!-- 添加或修改{{ table.function_name }}对话框 -->
- <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
- <el-form ref="form" :model="form" :rules="rules" label-width="80px">
- {%- for column in table.columns %}
- {%- if column.is_insert %}
- <el-form-item label="{{ column.column_comment }}" prop="{{ column.java_field }}">
- {%- if column.html_type == 'input' %}
- <el-input v-model="form.{{ column.java_field }}" placeholder="请输入{{ column.column_comment }}" />
- {%- elif column.html_type == 'textarea' %}
- <el-input v-model="form.{{ column.java_field }}" type="textarea" placeholder="请输入内容" />
- {%- elif column.html_type == 'select' %}
- {%- if column.dict_type != '' %}
- <el-select v-model="form.{{ column.java_field }}" placeholder="请选择{{ column.column_comment }}">
- <el-option
- v-for="dict in dict.type.{{ column.dict_type }}"
- :key="dict.value"
- :label="dict.label"
- :value="{% if column.java_type == 'Integer' or column.java_type == 'Long' %}parseInt(dict.value){% else %}dict.value{% endif %}"
- ></el-option>
- </el-select>
- {%- else %}
- <el-select v-model="form.{{ column.java_field }}" placeholder="请选择{{ column.column_comment }}">
- <el-option label="请选择字典生成" value="" />
- </el-select>
- {%- endif %}
- {%- elif column.html_type == 'radio' %}
- {%- if column.dict_type != '' %}
- <el-radio-group v-model="form.{{ column.java_field }}">
- <el-radio
- v-for="dict in dict.type.{{ column.dict_type }}"
- :key="dict.value"
- :label="{% if column.java_type == 'Integer' or column.java_type == 'Long' %}parseInt(dict.value){% else %}dict.value{% endif %}"
- >{{ dict.label }}</el-radio>
- </el-radio-group>
- {%- else %}
- <el-radio-group v-model="form.{{ column.java_field }}">
- <el-radio label="1">请选择字典生成</el-radio>
- </el-radio-group>
- {%- endif %}
- {%- elif column.html_type == 'checkbox' %}
- {%- if column.dict_type != '' %}
- <el-checkbox-group v-model="form.{{ column.java_field }}">
- <el-checkbox
- v-for="dict in dict.type.{{ column.dict_type }}"
- :key="dict.value"
- :label="dict.value"
- >{{ dict.label }}</el-checkbox>
- </el-checkbox-group>
- {%- else %}
- <el-checkbox-group v-model="form.{{ column.java_field }}">
- <el-checkbox>请选择字典生成</el-checkbox>
- </el-checkbox-group>
- {%- endif %}
- {%- elif column.html_type == 'datetime' %}
- <el-date-picker clearable
- v-model="form.{{ column.java_field }}"
- type="date"
- value-format="yyyy-MM-dd"
- placeholder="选择{{ column.column_comment }}">
- </el-date-picker>
- {%- elif column.html_type == 'imageUpload' %}
- <image-upload v-model="form.{{ column.java_field }}"/>
- {%- elif column.html_type == 'fileUpload' %}
- <file-upload v-model="form.{{ column.java_field }}"/>
- {%- endif %}
- </el-form-item>
- {%- endif %}
- {%- endfor %}
- </el-form>
- <div slot="footer" class="dialog-footer">
- <el-button type="primary" @click="submitForm">确 定</el-button>
- <el-button @click="cancel">取 消</el-button>
- </div>
- </el-dialog>
- <!-- 导入对话框 -->
- <el-dialog :title="upload.title" :visible.sync="upload.open" width="400px" append-to-body>
- <el-upload
- ref="upload"
- :limit="1"
- accept=".xlsx, .xls"
- :headers="upload.headers"
- :action="upload.url + '?updateSupport=' + upload.updateSupport"
- :disabled="upload.isUploading"
- :on-progress="handleFileUploadProgress"
- :on-success="handleFileSuccess"
- :auto-upload="false"
- drag
- >
- <i class="el-icon-upload"></i>
- <div class="el-upload__text">将文件拖到此处,或<em>点击上传</em></div>
- <div class="el-upload__tip text-center" slot="tip">
- <div class="el-upload__tip" slot="tip">
- <el-checkbox v-model="upload.updateSupport" /> 是否更新已经存在的{{ table.function_name }}数据
- </div>
- <span>仅允许导入xls、xlsx格式文件。</span>
- <el-link type="primary" :underline="false" style="font-size:12px;vertical-align: baseline;" @click="importTemplate">下载模板</el-link>
- </div>
- </el-upload>
- <div slot="footer" class="dialog-footer">
- <el-button type="primary" @click="submitFileForm">确 定</el-button>
- <el-button @click="upload.open = false">取 消</el-button>
- </div>
- </el-dialog>
- </div>
- </template>
- <script>
- {% set apiName = to_camel_case(table.class_name, False) %}
- {% set ApiName = capitalize_first(apiName) %}
- import { list{{ ApiName }}, get{{ ApiName }}, del{{ ApiName }}, add{{ ApiName }}, update{{ ApiName }} } from "@/api/{{ table.module_name }}/{{ table.business_name }}";
- import { getToken } from "@/utils/auth";
- export default {
- name: "{{ table.class_name }}",
- {%- set dicts_list = [] %}
- {%- for column in table.columns %}
- {%- if column.dict_type and column.dict_type != '' %}
- {%- if column.dict_type not in dicts_list %}
- {%- set _ = dicts_list.append(column.dict_type) %}
- {%- endif %}
- {%- endif %}
- {%- endfor %}
- {%- if dicts_list|length > 0 %}
- dicts: [{%- for dict_type in dicts_list %}'{{ dict_type }}'{%- if not loop.last %}, {% endif %}{%- endfor %}],
- {%- endif %}
- data() {
- return {
- // 遮罩层
- loading: true,
- // 选中数组
- ids: [],
- // 非单个禁用
- single: true,
- // 非多个禁用
- multiple: true,
- // 显示搜索条件
- showSearch: true,
- // 总条数
- total: 0,
- // {{ table.function_name }}表格数据
- {{ table.business_name }}List: [],
- // 表格列信息
- columns: [
- {%- for column in table.columns %}
- {%- if column.is_list %}
- { key: {{ column.list_index }}, label: '{{ column.column_comment }}', visible: true }{% if not loop.last %},{% endif %}
- {%- endif %}
- {%- endfor %}
- ],
- // 弹出层标题
- title: "",
- // 是否显示弹出层
- open: false,
- {%- for column in table.columns %}
- {%- if column.html_type == 'datetime' %}
- // {{ column.column_comment }}时间范围
- {%- set attr_name = capitalize_first(column.java_field) %}
- dateRange{{ attr_name }}: [],
- {%- endif %}
- {%- endfor %}
- // 查询参数
- queryParams: {
- pageNum: 1,
- pageSize: 10,
- {%- for column in table.columns %}
- {%- if column.is_query %}
- {{ column.java_field }}: null{% if not loop.last %},{% endif %}
- {%- endif %}
- {%- endfor %}
- },
- // 表单参数
- form: {},
- // 导入参数
- upload: {
- // 是否显示弹出层(导入)
- open: false,
- // 弹出层标题(导入)
- title: "",
- // 是否禁用上传
- isUploading: false,
- // 是否更新已经存在的{{ table.function_name }}数据
- updateSupport: 0,
- // 设置上传的请求头部
- headers: { Authorization: "Bearer " + getToken() },
- // 上传的地址
- url: process.env.VUE_APP_BASE_API + "/{{ table.module_name }}/{{ table.business_name }}/importData"
- },
- // 表单校验
- rules: {
- {%- set required_cols = [] %}
- {%- for column in table.columns %}
- {%- if column.is_required == '1' %}
- {%- set _ = required_cols.append(column) %}
- {%- endif %}
- {%- endfor %}
- {%- for column in required_cols %}
- {%- set comment = column.column_comment %}
- {%- if '(' in comment or '(' in comment %}
- {%- if '(' in comment %}
- {%- set comment = comment.split('(')[0] %}
- {%- elif '(' in comment %}
- {%- set comment = comment.split('(')[0] %}
- {%- endif %}
- {%- endif %}
- {{ column.java_field }}: [
- { required: true, message: "{{ comment }}不能为空", trigger: {% if column.html_type == 'select' or column.html_type == 'radio' %}"change"{% else %}"blur"{% endif %} }
- ]{% if not loop.last %},{% endif %}
- {%- endfor %}
- }
- };
- },
- created() {
- this.getList();
- },
- methods: {
- /** 查询{{ table.function_name }}列表 */
- getList() {
- this.loading = true;
- {%- set has_datetime = false %}
- {%- for column in table.columns %}
- {%- if column.html_type == 'datetime' %}
- {%- if not has_datetime %}
- this.queryParams.params = {};
- {%- set has_datetime = true %}
- {%- endif %}
- {%- set attr_name = capitalize_first(column.java_field) %}
- if (null != this.dateRange{{ attr_name }} && '' != this.dateRange{{ attr_name }}.toString()) {
- this.queryParams.params["begin{{ column.java_field }}"] = this.dateRange{{ attr_name }}[0];
- this.queryParams.params["end{{ column.java_field }}"] = this.dateRange{{ attr_name }}[1];
- }
- {%- endif %}
- {%- endfor %}
- list{{ ApiName }}(this.queryParams).then(response => {
- this.{{ table.business_name }}List = response.rows;
- this.total = response.total;
- this.loading = false;
- });
- },
- // 取消按钮
- cancel() {
- this.open = false;
- this.reset();
- },
- // 表单重置
- reset() {
- this.form = {
- {%- for column in table.columns %}
- {%- if column.html_type == 'checkbox' %}
- {{ column.java_field }}: []{% if not loop.last %},{% endif %}
- {%- else %}
- {{ column.java_field }}: null{% if not loop.last %},{% endif %}
- {%- endif %}
- {%- endfor %}
- };
- this.resetForm("form");
- },
- /** 搜索按钮操作 */
- handleQuery() {
- this.queryParams.pageNum = 1;
- this.getList();
- },
- /** 重置按钮操作 */
- resetQuery() {
- {%- for column in table.columns %}
- {%- if column.html_type == 'datetime' %}
- {%- set attr_name = capitalize_first(column.java_field) %}
- this.dateRange{{ attr_name }} = [];
- {%- endif %}
- {%- endfor %}
- this.resetForm("queryForm");
- this.handleQuery();
- },
- // 多选框选中数据
- handleSelectionChange(selection) {
- this.ids = selection.map(item => item.{{ table.pk_column.java_field if table.pk_column }})
- this.single = selection.length!==1
- this.multiple = !selection.length
- },
- /** 新增按钮操作 */
- handleAdd() {
- this.reset();
- this.open = true;
- this.title = "添加{{ table.function_name }}";
- },
- /** 修改按钮操作 */
- handleUpdate(row) {
- this.reset();
- const {{ table.pk_column.java_field if table.pk_column }} = row.{{ table.pk_column.java_field if table.pk_column }} || this.ids
- get{{ ApiName }}({{ table.pk_column.java_field if table.pk_column }}).then(response => {
- this.form = response.data;
- {%- for column in table.columns %}
- {%- if column.html_type == 'checkbox' %}
- if (this.form.{{ column.java_field }}) {
- this.form.{{ column.java_field }} = this.form.{{ column.java_field }}.split(",");
- } else {
- this.form.{{ column.java_field }} = [];
- }
- {%- endif %}
- {%- endfor %}
- this.open = true;
- this.title = "修改{{ table.function_name }}";
- });
- },
- /** 提交按钮 */
- submitForm() {
- this.$refs["form"].validate(valid => {
- if (valid) {
- const submitData = this.buildSubmitData();
- if (submitData.{{ table.pk_column.java_field if table.pk_column }} != null) {
- update{{ ApiName }}(submitData).then(response => {
- this.$modal.msgSuccess("修改成功");
- this.open = false;
- this.getList();
- });
- } else {
- add{{ ApiName }}(submitData).then(response => {
- this.$modal.msgSuccess("新增成功");
- this.open = false;
- this.getList();
- });
- }
- }
- });
- },
- /** 删除按钮操作 */
- handleDelete(row) {
- const {{ table.business_name }}Ids = row.{{ table.pk_column.java_field if table.pk_column }} || this.ids;
- this.$modal.confirm('是否确认删除{{ table.function_name }}编号为"' + {{ table.business_name }}Ids + '"的数据项?').then(function() {
- return del{{ ApiName }}({{ table.business_name }}Ids);
- }).then(() => {
- this.getList();
- this.$modal.msgSuccess("删除成功");
- }).catch(() => {});
- },
- /** 导出按钮操作 */
- handleExport() {
- this.download('{{ table.module_name }}/{{ table.business_name }}/export', {
- ...this.queryParams
- }, `{{ table.business_name }}_${new Date().getTime()}.xlsx`)
- },
- /** 导入按钮操作 */
- handleImport() {
- this.upload.title = "{{ table.function_name }}导入";
- this.upload.open = true;
- },
- /** 下载模板操作 */
- importTemplate() {
- this.download(
- "{{ table.module_name }}/{{ table.business_name }}/importTemplate",
- {},
- "{{ table.business_name }}_template_" + new Date().getTime() + ".xlsx"
- );
- },
- // 文件上传中处理
- handleFileUploadProgress(event, file, fileList) {
- this.upload.isUploading = true;
- },
- // 文件上传成功处理
- handleFileSuccess(response, file, fileList) {
- this.upload.open = false;
- this.upload.isUploading = false;
- this.$refs.upload.clearFiles();
- this.$alert("<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" + response.msg + "</div>", "导入结果", { dangerouslyUseHTMLString: true });
- this.$modal.closeLoading()
- this.getList();
- },
- buildSubmitData() {
- const data = { ...this.form };
- {%- for column in table.columns %}
- {%- if column.html_type == 'checkbox' %}
- if (Array.isArray(data.{{ column.java_field }})) {
- data.{{ column.java_field }} = data.{{ column.java_field }}.join(",");
- } else if (data.{{ column.java_field }}) {
- data.{{ column.java_field }} = String(data.{{ column.java_field }});
- }
- {%- endif %}
- {%- if column.java_type in ['Integer', 'Long', 'Short'] %}
- if (data.{{ column.java_field }} !== null && data.{{ column.java_field }} !== undefined && data.{{ column.java_field }} !== "") {
- data.{{ column.java_field }} = parseInt(data.{{ column.java_field }}, 10);
- } else {
- data.{{ column.java_field }} = null;
- }
- {%- elif column.java_type in ['Float', 'Double', 'BigDecimal', 'Decimal'] %}
- if (data.{{ column.java_field }} !== null && data.{{ column.java_field }} !== undefined && data.{{ column.java_field }} !== "") {
- data.{{ column.java_field }} = parseFloat(data.{{ column.java_field }});
- } else {
- data.{{ column.java_field }} = null;
- }
- {%- endif %}
- {%- endfor %}
- return data;
- },
- // 提交上传文件
- submitFileForm() {
- this.$modal.loading("导入中请稍后")
- this.$refs.upload.submit();
- }
- }
- };
- </script>
|