<template>
  <div>
    <el-card class="box-card" shadow="always">
      <div slot="header" class="clearfix">
        <span>{{ title }}</span>
        <el-button-group style="float: right;">
          <el-button size="mini" icon="el-icon-plus" round @click="submitForm" :loading="loadingOptions.loading" :disabled="loadingOptions.isDisabled">{{loadingOptions.loadingText}}</el-button>
          <el-button size="mini" icon="el-icon-back" round @click="showCard">返回</el-button>
        </el-button-group>
      </div>
      <div :style="classCardbody">
        <el-form ref="form" :model="form" :rules="rules" label-width="80px">
          <el-form-item label="数据源" prop="sourceId">
            <el-select v-model="form.sourceId" placeholder="请选择数据源">
              <el-option
                v-for="source in sourceOptions"
                :key="source.id"
                :label="source.sourceName"
                :value="source.id"
                :disabled="source.status === '0'"
              ></el-option>
            </el-select>
          </el-form-item>
          <el-form-item label="数据集名称" prop="setName">
            <el-input v-model="form.setName" placeholder="请输入数据集名称" />
          </el-form-item>
          <el-form-item label="数据集sql" prop="setSql">
            <sql-editor
              ref="sqleditor"
              :value="form.setSql"
              @changeTextarea="changeTextarea($event)"
              style="height: 300px;"
            ></sql-editor>
          </el-form-item>
          <el-form-item>
            <el-button size="mini" type="primary" @click="formaterSql">Sql格式化</el-button>
            <el-button size="mini" type="primary" @click="dataPreview">预览</el-button>
          </el-form-item>
          <el-form-item label="状态" prop="status">
            <el-radio-group v-model="form.status">
              <el-radio
                v-for="dict in statusOptions"
                :key="dict.id"
                :label="dict.itemText"
              >{{dict.itemValue}}</el-radio>
            </el-radio-group>
          </el-form-item>
          <el-form-item label="备注" prop="remark">
            <el-input v-model="form.remark" type="textarea" placeholder="请输入内容" />
          </el-form-item>
        </el-form>
        <el-drawer
          :visible.sync="drawer"
          direction="btt"
          :with-header="false">
          <el-table :data="previewData.dataList" stripe border
                    :max-height="200"
                    style="width: 100%; margin: 15px 0;">
            <el-table-column label="序号" width="55" align="center">
              <template slot-scope="scope">
                <span>{{ scope.$index + 1 }}</span>
              </template>
            </el-table-column>
            <template v-for="(column, index) in previewData.columnList">
              <el-table-column
                :prop="column"
                :label="column"
                :key="index"
                align="center"
                show-overflow-tooltip
              />
            </template>
          </el-table>
          <el-pagination
            :page-sizes="[10, 20, 50, 100]"
            layout="total, sizes, prev, pager, next, jumper"
            @size-change="handleSizeChange"
            @current-change="handleCurrentChange"
            :current-page.sync="previewData.pageNum"
            :page-size.sync="previewData.pageSize"
            :total="previewData.dataTotal"
          ></el-pagination>
        </el-drawer>
      </div>
    </el-card>
  </div>
</template>

<script>
import { getDataSet, updateDataSet } from '@/api/factory/dataset'
import { listDataSource, queryByPage } from '@/api/factory/datasource'
import sqlFormatter from 'sql-formatter'
import SqlEditor from '@/components/SqlEditor'

export default {
  name: 'DataSetEdit',
  components: {
    SqlEditor
  },
  props: {
    data: {
      type: Object,
      default: function () {
        return {}
      }
    }
  },
  data () {
    return {
      classCardbody: {
        overflow: 'auto',
        height: document.body.offsetHeight - 240 + 'px'
      },
      title: '数据集编辑',
      // 展示切换
      showOptions: {
        data: {},
        showList: true,
        showAdd: false,
        showEdit: false,
        showDetail: false
      },
      // 保存按钮
      loadingOptions: {
        loading: false,
        loadingText: '保存',
        isDisabled: false
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
        setName: [
          { required: true, message: '数据集名称不能为空', trigger: 'blur' }
        ]
      },
      // 状态数据字典
      statusOptions: [],
      // 数据源数据字典
      sourceOptions: [],
      drawer: false,
      previewData: {
        dataList: [],
        columnList: [],
        pageNum: 1,
        pageSize: 20,
        dataTotal: 0
      }
    }
  },
  created () {
    console.log('id:' + this.data.id)
    this.getDicts('sys_common_status').then(response => {
      if (response.success) {
        this.statusOptions = response.data
      }
    })
    this.getDataSourceList()
    this.getDataSet(this.data.id)
  },
  methods: {
    showCard () {
      this.$emit('showCard', this.showOptions)
    },
    getDataSourceList () {
      listDataSource().then(response => {
        if (response.success) {
          this.sourceOptions = response.data
        }
      })
    },
    /** 获取详情 */
    getDataSet: function (id) {
      getDataSet(id).then(response => {
        if (response.success) {
          this.form = response.data
          this.$refs.sqleditor.editor.setValue(this.form.setSql)
        }
      })
    },
    // 绑定编辑器value值的变化
    changeTextarea (val) {
      this.$set(this.form, 'setSql', val)
    },
    formaterSql (val) {
      this.$refs.sqleditor.editor.setValue(sqlFormatter.format(this.$refs.sqleditor.editor.getValue()))
    },
    dataPreview () {
      if (!this.form.sourceId) {
        return
      }
      if (!this.form.setSql) {
        return
      }
      let data = {}
      data.dataSourceId = this.form.sourceId
      data.sql = this.form.setSql
      data.pageNum = this.previewData.pageNum
      data.pageSize = this.previewData.pageSize
      queryByPage(data).then(response => {
        if (response.success) {
          const { data } = response
          let dataList = data.data || []
          let columnList = []
          if (dataList.length > 0) {
            columnList = Object.keys(dataList[0])
          }
          this.previewData.dataList = dataList
          this.previewData.columnList = columnList
          this.previewData.dataTotal = data.total
          this.drawer = true
        }
      })
    },
    handleSizeChange (val) {
      this.previewData.pageNum = 1
      this.previewData.pageSize = val
      this.dataPreview()
    },
    handleCurrentChange (val) {
      this.previewData.pageNum = val
      this.dataPreview()
    },
    /** 提交按钮 */
    submitForm: function () {
      this.$refs['form'].validate(valid => {
        if (valid) {
          this.loadingOptions.loading = true
          this.loadingOptions.loadingText = '保存中...'
          this.loadingOptions.isDisabled = true
          updateDataSet(this.form).then(response => {
            if (response.success) {
              this.$message.success('保存成功')
              setTimeout(() => {
                // 2秒后跳转列表页
                this.$emit('showCard', this.showOptions)
              }, 2000)
            } else {
              this.$message.error('保存失败')
              this.loadingOptions.loading = false
              this.loadingOptions.loadingText = '保存'
              this.loadingOptions.isDisabled = false
            }
          }).catch(error => {
            this.$message.error(error.data.msg || '保存失败')
            this.loadingOptions.loading = false
            this.loadingOptions.loadingText = '保存'
            this.loadingOptions.isDisabled = false
          })
        }
      })
    }
  }
}
</script>

<style lang="scss" scoped>

</style>
