<template>
    <div>
        <el-form :model="formData" :rules="rules" ref="form" label-width="80px" label-position="right" size="small">
            <el-form-item prop="databasetype" label="库类型">
                <el-select placeholder="库类型" size="small" v-model="formData.databasetype" @change="changeDataBaseType" class="filter-item">
                    <el-option label="Mysql" value="Mysql">
                    </el-option>
                    <el-option label="SqlServer" value="SqlServer">
                    </el-option>
                </el-select>
            </el-form-item>

            <el-form-item prop="dataSourceCode" label="数据库">

                <el-select placeholder="数据库" size="small" v-model="formData.dataSourceCode" @change="changeDataSourceCode" class="filter-item">
                    <el-option v-for="item in datasourceInfoList" :label="item.databaseName" :value="item.code" :key="item.code"></el-option>
                </el-select>

            </el-form-item>

            <el-form-item prop="tableName" label="表名">

                <el-select placeholder="表名" size="small" clearable filterable v-model="formData.tableName" @change="changeTableName" class="filter-item">
                    <el-option v-for="item in tableList" :label="item" :value="item" :key="item"></el-option>
                </el-select>

            </el-form-item>

            <el-form-item prop="code" label="code" style="width:300px;">
                <el-input v-model="formData.code"></el-input>
            </el-form-item>

            <el-form-item prop="typeFlag" label="分类" style="width:300px;">
                <el-input v-model="formData.typeFlag"></el-input>
            </el-form-item>

            <el-form-item prop="modules" label="功能">
                <el-select placeholder="modules" size="small" multiple v-model="formData.modules" class="filter-item">
                    <el-option label="搜索" value="search">
                    </el-option>
                    <el-option label="高级搜索" value="query">
                    </el-option>
                    <el-option label="添加" value="add">
                    </el-option>
                    <el-option label="编辑" value="edit">
                    </el-option>
                    <el-option label="删除" value="del">
                    </el-option>
                    <el-option label="导出" value="excel">
                    </el-option>
                </el-select>
            </el-form-item>

            <el-form-item prop="tablecolumns" label="字段">
                <el-tabs value="1" type="border-card">
                    <el-tab-pane label="字段" name="1">

                        <el-table :data="tablecolumnsFields" border>

                            <el-table-column prop="value" label="字段" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.name"></el-input>
                                </template>
                            </el-table-column>

                            <el-table-column prop="remark" label="显示" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.remark"></el-input>
                                </template>
                            </el-table-column>

                            <el-table-column prop="formType" label="类型" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.formType">
                                        <el-option v-for="item in columnTypes" :label="item.label" :value="item.value" :key="item.value"></el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                            <el-table-column prop="apiFlag" label="接口" width="300" align="center">
                                <template slot-scope="{row}">
                                    <el-radio v-model="row.apiFlag" label="1" :disabled="row.formType!='select'&&row.formType!='multiSelect'">枚举</el-radio>
                                    <el-radio v-model="row.apiFlag" label="2" :disabled="row.formType!='select'&&row.formType!='multiSelect'">接口</el-radio>
                                    <el-radio v-model="row.apiFlag" label="3" :disabled="row.formType!='select'&&row.formType!='multiSelect'">表</el-radio>
                                </template>
                            </el-table-column>

                            <el-table-column prop="optionsValue" label="选项" min-width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input type="textarea" v-if="row.apiFlag=='1'&&(row.formType=='select'||row.formType=='multiSelect')" v-model="row.optionsValue"></el-input>
                                    <div v-if="(row.apiFlag=='2'||row.apiFlag=='3')&&(row.formType=='select'||row.formType=='multiSelect')" @click="editSelectField(row)">
                                        <el-input type="textarea" :value="optionsInfo(row)"></el-input>
                                    </div>

                                </template>
                            </el-table-column>

                            <el-table-column width="60" align="center">
                                <template slot-scope="{ row, column, $index }">
                                    <el-button @click="removeField($index)" size="small" type="text">删除</el-button>
                                </template>
                            </el-table-column>
                        </el-table>
                        <el-button @click="addField" type="text" icon="el-icon-plus">添加</el-button>
                        <el-button @click="changeRankDialog = !changeRankDialog" type="primary" size="small" icon="el-icon-sort" class="filter-item">排序
                        </el-button>
                    </el-tab-pane>
                    <el-tab-pane label="表单校验" name="2">
                        <el-table :data="tablecolumnsFields" border>

                            <el-table-column prop="name" label="字段" width="150" align="center">
                            </el-table-column>

                            <el-table-column prop="remark" label="显示" width="150" align="center">
                            </el-table-column>

                            <el-table-column prop="logicalKey" label="逻辑关键字" width="50" align="center">
                                <template slot-scope="{row}">
                                    <el-checkbox v-model="row.logicalKey"></el-checkbox>
                                </template>
                            </el-table-column>

                            <el-table-column prop="required" label="必填" width="50" align="center">
                                <template slot-scope="{row}">
                                    <el-checkbox v-model="row.required"></el-checkbox>
                                </template>
                            </el-table-column>
                            <el-table-column prop="validate" label="校验" width="50" align="center">
                                <template slot-scope="{row}">
                                    <el-checkbox v-model="row.validate"></el-checkbox>
                                </template>
                            </el-table-column>
                            <el-table-column prop="minLength" label="最短" width="80" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model.number="row.minLength"></el-input>
                                </template>
                            </el-table-column>
                            <el-table-column prop="maxLength" label="最长" width="80" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model.number="row.maxLength"></el-input>
                                </template>
                            </el-table-column>
                            <el-table-column prop="min" label="最小值" width="80" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.min"></el-input>
                                </template>
                            </el-table-column>
                            <el-table-column prop="max" label="最大值" width="80" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.max"></el-input>
                                </template>
                            </el-table-column>
                            <el-table-column prop="validatorType" label="校验类型" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.validatorType" clearable>
                                        <el-option v-for="item in validatorTypes" :label="item.label" :value="item.value" :key="item.value"></el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                        </el-table>
                    </el-tab-pane>
                    <el-tab-pane label="子表" name="3" border>
                        <el-table :data="subtables">

                            <el-table-column prop="name" label="控件名" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.name"></el-input>
                                </template>
                            </el-table-column>

                            <el-table-column prop="column" label="主表字段" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.column"></el-input>
                                </template>
                            </el-table-column>

                            <el-table-column prop="subColumn" label="子表字段" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-input v-model="row.subColumn"></el-input>
                                </template>
                            </el-table-column>
                            <el-table-column prop="subCode" label="子表Code" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.subCode" clearable>
                                        <el-option v-for="item in subCodes" :label="item.code" :value="item.code" :key="item.code"></el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                            <el-table-column width="60" align="center">
                                <template slot-scope="{ row, column, $index }">
                                    <el-button @click="removeSubtable($index)" size="small" type="text">删除</el-button>
                                </template>
                            </el-table-column>
                        </el-table>
                        <el-button @click="addSubtable" type="text" icon="el-icon-plus">添加</el-button>
                    </el-tab-pane>
                    <el-tab-pane label="排序" name="4">
                        <el-table :data="tablecolumnsFields" border>

                            <el-table-column prop="name" label="字段" width="150" align="center">
                            </el-table-column>

                            <el-table-column prop="remark" label="显示" width="150" align="center">
                            </el-table-column>

                            <el-table-column prop="orderFlag" label="排序" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.orderFlag" clearable>
                                        <el-option label="降序" value="desc">
                                        </el-option>
                                        <el-option label="升序" value="asc">
                                        </el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                        </el-table>
                    </el-tab-pane>
                    <el-tab-pane label="默认条件" name="5">
                        <el-table :data="advancedQueryFields" border>

                            <el-table-column prop="link" label="链接符" align="center">
                                <template slot-scope="{row}">
                                    <el-select placeholder="链接" size="small" v-model="row.link" class="filter-item">
                                        <el-option label="AND" value="AND">
                                        </el-option>
                                        <el-option label="OR" value="OR">
                                        </el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                            <el-table-column prop="name" label="字段" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.name">

                                        <el-option v-for="item in tablecolumnsFields" :label="item.name" :value="item.name" :key="item.name"></el-option>
                                    </el-select>
                                </template>
                            </el-table-column>
                            <el-table-column prop="searchMethod" label="搜索方式" width="150" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.searchMethod">
                                        <el-option v-for="item in searchMethods" :label="item" :value="item" :key="item"></el-option>
                                    </el-select>
                                </template>
                            </el-table-column>

                            <el-table-column prop="systemFlag" label="系统参数" width="50" align="center">
                                <template slot-scope="{row}">
                                    <el-checkbox v-model="row.systemFlag"></el-checkbox>
                                </template>
                            </el-table-column>

                            <el-table-column prop="value" label="参数" align="center">
                                <template slot-scope="{row}">
                                    <el-select v-model="row.value" v-if="row.systemFlag">
                                        <el-option v-for="item in systemParameters" :label="item.label" :value="item.value" :key="item.value"></el-option>
                                    </el-select>
                                    <el-input v-model="row.value" v-else></el-input>

                                </template>
                            </el-table-column>
                            <el-table-column prop="noChange" label="不可修改" width="50" align="center">
                                <template slot-scope="{row}">
                                    <el-checkbox v-model="row.noChange"></el-checkbox>
                                </template>
                            </el-table-column>

                            <el-table-column width="60" align="center">
                                <template slot-scope="{ row, column, $index }">
                                    <el-button @click="removeQueryField($index)" size="small" type="text">删除</el-button>
                                </template>
                            </el-table-column>
                        </el-table>

                        <el-button @click="addQueryField" type="text" icon="el-icon-plus">添加</el-button>
                    </el-tab-pane>
                </el-tabs>
            </el-form-item>

            <el-form-item>
                <el-button @click="onSave" :loading="$store.state.fetchingData" type="primary">保存</el-button>
                <el-button @click="$router.go(-1)">取消</el-button>
            </el-form-item>
        </el-form>

        <el-dialog title="调整顺序" :visible.sync="changeRankDialog">
            <div class="colorList">
                <div class="color-item" v-for="color in tablecolumnsFields" v-dragging="{ item: color, list: tablecolumnsFields, group: 'color' }" :key="color.name">{{color.name}}——{{color.remark}}</div>

            </div>
        </el-dialog>

        <el-dialog title="接口选项" :visible.sync="showSelectDialog">
            <el-form :model="selectField">
                <el-form-item label="接口">
                    <el-select placeholder="接口" size="small" filterable clearable v-model="selectField.optionsMethod" class="filter-item">
                        <el-option v-for="item in selectMappings" :label="item.url" :value="item.url" :key="item.url"></el-option>
                    </el-select>
                </el-form-item>
                <el-form-item label="显示">
                    <el-select v-if="selectField.optionsMethod&&selectField.apiFlag=='2'" filterable clearable placeholder="显示" size="small" v-model="selectField.optionsLabel" class="filter-item">
                        <el-option v-for="item in selectMappingsJson[selectField.optionsMethod].fileds.split(',')" :label="item" :value="item" :key="item"></el-option>
                    </el-select>
                </el-form-item>
                <el-form-item label="选项">
                    <el-select v-if="selectField.optionsMethod&&selectField.apiFlag=='2'" filterable clearable placeholder="选项" size="small" v-model="selectField.optionsValue" class="filter-item">
                        <el-option v-for="item in selectMappingsJson[selectField.optionsMethod].fileds.split(',')" :label="item" :value="item" :key="item"></el-option>
                    </el-select>
                </el-form-item>
                <el-form-item>
                    <el-button type="primary" @click="selectMappingSubmit">确定</el-button>
                </el-form-item>
            </el-form>

        </el-dialog>

        <el-dialog title="表选项" :visible.sync="showTableSelectDialog">
            <el-form :model="selectField">
                <el-form-item label="库类型">
                    <el-select placeholder="库类型" size="small" filterable clearable v-model="selectField.optionsDataBaseType" @change="changeOptionsDataBaseType" class="filter-item">
                        <el-option label="Mysql" value="Mysql">
                        </el-option>
                        <el-option label="SqlServer" value="SqlServer">
                        </el-option>
                    </el-select>
                </el-form-item>
                <el-form-item label="数据库">

                    <el-select placeholder="数据库" size="small" filterable clearable v-model="selectField.optionsDataSourceCode" @change="changeOptionsDataSourceCode" class="filter-item">
                        <el-option v-for="item in optionsDatasourceInfoList" :label="item.databaseName" :value="item.code" :key="item.code"></el-option>
                    </el-select>

                </el-form-item>

                <el-form-item label="表名">

                    <el-select placeholder="表名" size="small" clearable filterable v-model="selectField.optionsMethod" @change="changeOptionsTableName" class="filter-item">
                        <el-option v-for="item in optionsTableList" :label="item" :value="item" :key="item"></el-option>
                    </el-select>

                </el-form-item>

                <el-form-item label="显示">
                    <el-select v-if="selectField.optionsMethod&&selectField.apiFlag=='3'" filterable clearable placeholder="显示" size="small" v-model="selectField.optionsLabel" class="filter-item">
                        <el-option v-for="item in optionsFields" :label="item.name" :value="item.name" :key="item.name"></el-option>
                    </el-select>
                </el-form-item>

                <el-form-item label="选项">
                    <el-select v-if="selectField.optionsMethod&&selectField.apiFlag=='3'" filterable clearable placeholder="选项" size="small" v-model="selectField.optionsValue" class="filter-item">
                        <el-option v-for="item in optionsFields" :label="item.name" :value="item.name" :key="item.name"></el-option>
                    </el-select>
                </el-form-item>
                <el-form-item>
                    <el-button type="primary" @click="selectMappingSubmit">确定</el-button>
                </el-form-item>
            </el-form>

        </el-dialog>

    </div>
</template>
<script>
import formValidator from '../formValidator'
import axios from 'axios'

export default {
    created() {
        if (this.$route.query.id) {
            this.$http.get({
                url: '/queryConfig/getOne',
                data: {
                    id: this.$route.query.id
                }
            }).then(res => {
                if (res.success) {

                    res.data.modules = res.data.modules ? res.data.modules.split(',').map(i => String(i)) : [];

                    this.formData = res.data;

                    this.tablecolumnsFields = [];
                    // var tableColumnsStr = res.data.tablecolumns;

                    // var columns = tableColumnsStr.split('_;');

                    // columns.forEach(element => {
                    //     var items = element.split('_,');
                    //     var temp = {
                    //         label: items[0],
                    //         value: items[1],
                    //         type: items[2]
                    //     }

                    //     this.tablecolumnsFields.push(temp);
                    // });

                    this.tablecolumnsFields = JSON.parse(res.data.configJson);

                    this.subtables = [];
                    if (res.data.subJson) {

                        this.subtables = JSON.parse(res.data.subJson);
                    }

                    this.advancedQueryFields = [];
                    if (res.data.queryJson) {
                        this.advancedQueryFields = JSON.parse(res.data.queryJson);
                    }

                }
            })
        }

        this.$http.get({
            url: '/dataSourceInfo/all'
        }).then(res => {
            if (res.success) {
                this.MysqlDataSourceInfos.push(this.baseDataSource);

                if (res.data.length > 0) {
                    res.data.forEach(item => {
                        if ('Mysql' == item.databaseType) {
                            this.MysqlDataSourceInfos.push(item);
                        } else if ('SqlServer' == item.databaseType) {
                            this.SqlServerDataSourceInfos.push(item);
                        }
                    })
                }
                this.datasourceInfoList = this.MysqlDataSourceInfos;
            }
        });

        this.$http.get({
            url: '/queryConfig/all'
        }).then(res => {
            if (res.success) {
                this.subCodes = res.data;
            }
        });

        this.$http.get({
            url: '/dev/selectMappings'
        }).then(res => {
            if (res.success) {
                if (res.data.length > 0) {
                    var temp = {}
                    res.data.forEach(item => {
                        temp[item.url] = item
                    })
                }
                this.selectMappingsJson = temp;
                this.selectMappings = res.data;
            }
        });


        this.getDatabaseTables();

    },
    data() {
        return {
            saving: false,
            formData: {
                databasetype: 'Mysql',
                dataSourceCode: 'dataSource',
                tableName: '',
                modules: []
            },
            rules: {
                databasetype: [
                    { required: true, message: '请选择数据库类型', trigger: 'blur' },
                ],
                code: [
                    { required: true, message: '请填写CODE', trigger: 'blur' },
                ],
                modules: [
                    { required: true, message: '请选择功能', trigger: 'blur' },
                ],
                tableName: [
                    { required: true, message: '请填写表名', trigger: 'blur' },
                ],
                dataSourceCode: [
                    { required: true, message: '请填选择数据库', trigger: 'blur' },
                ],
                typeFlag: [
                    { required: true, message: '请填写分类', trigger: 'blur' },
                ],
            },

            tablecolumnsFields: [
            ],
            tablecolumnsStr: '',
            columnTypes: [
                { label: '单行文本', value: 'singleLineText' },
                { label: '多行文本', value: 'textarea' },
                { label: '富文本', value: 'richText' },
                { label: '数字', value: 'number' },
                { label: '日期选择', value: 'date' },
                { label: '日期时间选择', value: 'datetime' },
                { label: '单选下拉框', value: 'select' },
                { label: '多选下拉框', value: 'multiSelect' },
                { label: '单图上传', value: 'singleImage' },
                { label: '登录名', value: 'loginName' },
                { label: '工号', value: 'workNumber' },
                { label: '部门', value: 'departId' },
                { label: '当前时间', value: 'currentTime' },
                { label: '当前日期', value: 'currentDate' },
                { label: ' 布尔值开关', value: 'switch' },
            ],
            validatorTypes: [
                { label: '英文', value: 'english' },
                { label: '数字', value: 'number' },
                { label: '手机', value: 'phone' },
                { label: '网址', value: 'url' },
                { label: '电子邮件', value: 'email' },
                { label: '身份证', value: 'id' }
            ],
            MysqlDataSourceInfos: [],
            SqlServerDataSourceInfos: [],
            baseDataSource: {
                databaseType: 'Mysql',
                code: 'dataSource',
                databaseName: '基础数据库'

            },
            datasourceInfoList: [],
            tableList: [],
            subtables: [],
            subCodes: [],
            changeRankDialog: false,

            selectMappings: [],
            selectMappingsJson: {},
            showSelectDialog: false,
            selectField: {},
            showTableSelectDialog: false,
            optionsDatasourceInfoList: [],
            optionsTableList: [],
            optionsFields: [],
            advancedQueryFields: [],
            searchMethods: ['=', '!=', '>', '>=', '<', '<=', 'in', 'like'],
            systemParameters: [

                { label: '登录名', value: 'loginName' },
                { label: '工号', value: 'workNumber' },
                { label: '部门', value: 'departId' },
                { label: '当前时间', value: 'currentTime' },
                { label: '当前日期', value: 'currentDate' },
                { label: 'MIS代码', value: 'misCode' },
                { label: 'MIS名称', value: 'misName' },
                { label: '下辖MIS代码', value: 'misChildCode' },
                { label: '下辖MIS名称', value: 'misChildName' },
                { label: '下辖MIS代码和名称', value: 'misChildCodeAndName' },
            ],

        }
    },
    methods: {
        onSave() {
            this.$refs.form.validate((valid) => {
                if (valid) {
                    this.checkCodeName();
                } else {
                    return false;
                }
            });
        },

        checkCodeName() {

            this.$http.get({
                url: '/queryConfig/check',
                data: {
                    id: this.formData.id,
                    code: this.formData.code,
                }
            }).then(res => {
                if (res.success) {

                    this.submit();

                } else {
                    this.$msgbox({ title: '提示', type: 'error', message: 'CODE以存在' });
                }
            })


        },

        submit() {

            this.tablecolumnsStr = '';

            if (this.tablecolumnsFields.length > 0) {

                this.formData.subtables = this.subtables;
                this.formData.advancedQueryFields = this.advancedQueryFields;
                this.formData.fields = this.tablecolumnsFields;
                this.formData.configJson = '';
                var data = JSON.parse(JSON.stringify(this.formData));;
                data.modules = this.formData.modules.join();

                this.$alert('确认要生成么？', '警告', { type: 'error' }).then(() => {
                    this.loading = true;
                    return axios.post(this.formData.id ? '/queryConfig/update' : '/queryConfig/save', data)
                }).then(() => {
                    this.loading = false;
                    this.$message.success('代码生成成功');
                    this.$router.go(-1);
                }).catch(res => {
                    this.loading = false;
                    if ('cancel' === res) {
                        this.$msgbox({ title: '提示', type: 'error', message: '生成取消' });
                    } else {
                        this.$msgbox({ title: '提示', type: 'error', message: '生成失败' });
                    }
                })
            } else {
                this.$message.warning('请添加字段')
            }
        },
        addField() {
            this.tablecolumnsFields.push({
                label: '',
                value: '',
                type: 'singleLineText',
                orderFlag: '',
            });
        },
        removeField(i) {
            if (this.tablecolumnsFields.length > 0) {
                this.tablecolumnsFields.splice(i, 1);
            }
        },
        changeDataBaseType() {
            if ('Mysql' == this.formData.databasetype) {
                this.datasourceInfoList = this.MysqlDataSourceInfos;
                this.formData.dataSourceCode = 'dataSource';
                this.getDatabaseTables();
            } else if ('SqlServer' == this.formData.databasetype) {
                this.datasourceInfoList = this.SqlServerDataSourceInfos;
                this.formData.dataSourceCode = '';
            }
        },
        getDatabaseTables(code) {
            this.tableList = [];
            this.$http.get({
                url: '/genCode/tables',
                data: {
                    code: code
                }
            }).then(res => {
                if (res.success) {

                    this.tableList = res.data;
                }
            })
        },
        changeDataSourceCode() {

            this.formData.tableName = '';
            this.getDatabaseTables(this.formData.dataSourceCode);
        },
        changeTableName() {

            this.tablecolumnsFields = [];

            this.getTableFields(this.formData.tableName);
        },
        getTableFields(tableName) {
            this.$http.get({
                url: '/genCode/tableFields',
                data: {
                    code: this.formData.dataSourceCode,
                    tableName: tableName,
                    databaseType: this.formData.databasetype,
                }
            }).then(res => {
                if (res.success) {



                    this.tablecolumnsFields = res.data;

                    // res.data.forEach(item => {

                    //     this.tablecolumnsFields.push({
                    //         label: item.remark,
                    //         value: item.name,
                    //         type: 'singleLineText',
                    //     })
                    // })

                }
            })
        },
        addSubtable() {
            this.subtables.push({
                name: '',
                column: '',
                subColumn: '',
                subCode: '',
            });
        },
        removeSubtable(i) {
            if (this.subtables.length > 0) {
                this.subtables.splice(i, 1);
            }
        },

        editSelectField(row) {
            this.selectField = row;

            if (row.apiFlag == '2') {

                this.showSelectDialog = true;
            } else if (row.apiFlag == '3') {
                this.showTableSelectDialog = true;
            }
        },
        optionsInfo(row) {
            var value = '';
            if (row.apiFlag == '1') {
                value = row.optionsValue;
            } else if (row.apiFlag == '2') {

                value = row.optionsMethod + ',' + row.optionsLabel + ',' + row.optionsValue;
            } else if (row.apiFlag == '3') {
                value = row.optionsMethod + ',' + row.optionsLabel + ',' + row.optionsValue;
            }
            return value;
        },
        selectMappingSubmit() {

            if (this.selectField.apiFlag == '2') {

                this.showSelectDialog = false;
            } else if (this.selectField.apiFlag == '3') {
                this.showTableSelectDialog = false;
            }


        },
        changeOptionsDataBaseType() {
            if ('Mysql' == this.selectField.optionsDataBaseType) {
                this.optionsDatasourceInfoList = this.MysqlDataSourceInfos;
                this.selectField.optionsDataSourceCode = 'dataSource';
                this.getOptionsDatabaseTables();
            } else if ('SqlServer' == this.selectField.optionsDataBaseType) {
                this.optionsDatasourceInfoList = this.SqlServerDataSourceInfos;
                this.selectField.optionsDataSourceCode = '';
            }
        },
        getOptionsDatabaseTables(code) {
            this.optionsTableList = [];
            this.$http.get({
                url: '/genCode/tables',
                data: {
                    code: code
                }
            }).then(res => {
                if (res.success) {

                    this.optionsTableList = res.data;
                }
            })
        },
        changeOptionsDataSourceCode() {

            this.getOptionsDatabaseTables(this.selectField.optionsDataSourceCode);
        },
        changeOptionsTableName() {

            this.optionsFields = [];

            this.getOptionsTableFields(this.selectField.optionsMethod);
        },

        getOptionsTableFields(tableName) {
            this.$http.get({
                url: '/genCode/tableFields',
                data: {
                    code: this.selectField.optionsDataSourceCode,
                    tableName: tableName,
                    databaseType: this.selectField.optionsDataBaseType,
                }
            }).then(res => {
                if (res.success) {

                    this.optionsFields = res.data;
                }
            })
        },
        addQueryField() {
            this.advancedQueryFields.push({
                link: 'AND',
                name: '',
                searchMethod: '=',
                value: '',
                systemFlag: false,
            });
        },
        removeQueryField(i) {
            if (this.advancedQueryFields.length > 0) {
                this.advancedQueryFields.splice(i, 1);
            }
        },
    }
}
</script>
<style lang="less" scoped>
.color-item {
    height: 42px;
    font-size: 14px;
    border-bottom: 1px solid #eee;
    line-height: 42px;
    padding: 0 20px;
    cursor: move;
    &:last-child {
        border-bottom: none;
    }
}
.colorList {
    border: 1px solid #eee;
    max-height: 60vh;
    overflow: auto;
}
</style>
