<!-- 管线占压数据管理 -->
<script name="DatabaseManage" setup lang="ts">
import { ElLoading, ElMessage, ElMessageBox } from 'element-plus'
import detailDialog from './detail.vue'
import type { dictType } from '@/global'
import { getDictByCode } from '@/api/system/dict'
import { exportFile } from '@/utils/exportUtils'
import type { TableColumn } from '@/components/NormalTable/table_interface'
import { batchDeleteOver, exporOver, getOverListPage, importOver, templateOver } from '@/api/page/database'
const $router = useRouter()
const { proxy } = getCurrentInstance() as any

// 查询条件
const listQuery = ref({
  hiddenDangerNumber: '', // 隐患编号
  primaryClassification: '', // 一级分类
  secondaryClassification: '', // 二级分类
  hiddenDangerDescription: '', // 隐患描述
  hiddenDangerLevel: '', // 隐患等级
  responsibleManagementEnterprise: '', // 管理责任企业
  discoveryTime: '', // 发现时间
  governanceSituation: '', // 治理
  offset: 1,
  limit: 20,
})
const total = ref(0) // 数据条数
const loadingTable = ref(false) // 表格loading
// 表头
const columns = ref<TableColumn[]>([
  { text: '序号', value: 'serialNumber', align: 'center' },
  { text: '隐患编号', value: 'hiddenDangerNumber', align: 'center' },
  { text: '一级分类', value: 'primaryClassification', align: 'center' },
  { text: '二级分类', value: 'secondaryClassification', align: 'center' },
  { text: '地点', value: 'location', align: 'center' },
  { text: '发现时间', value: 'discoveryTime', align: 'center' },
  { text: '隐患等级', value: 'hiddenDangerLevel', align: 'center' },
  { text: '管理责任企业', value: 'responsibleManagementEnterprise', align: 'center' },
  { text: '责任人', value: 'personInCharge', align: 'center' },
  { text: '治理情况', value: 'governanceSituation', align: 'center' },
  { text: '消除时间', value: 'eliminationTime', align: 'center' },
])
const list = ref([]) // 表格数据
// 选中的内容
const checkoutList = ref<string[]>([])

// 数据查询
function fetchData(isNowPage = false) {
  loadingTable.value = true
  if (!isNowPage) {
    // 是否显示当前页，否则跳转第一页
    listQuery.value.offset = 1
  }
  getOverListPage(listQuery.value).then((res) => {
    console.log(res.data, '管线占压')
    list.value = res.data.rows.map((item: any) => {
      return {
        ...item,
        eliminationTime: item.eliminationTime ? item.eliminationTime : '/',
      }
    })
    total.value = parseInt(res.data.total)
    loadingTable.value = false
  }).catch(() => {
    loadingTable.value = false
  })
}
// 搜索
const searchList = () => {
  fetchData(true)
}

// 重置
const reset = () => {
  listQuery.value = {
    hiddenDangerNumber: '', // 隐患编号
    primaryClassification: '', // 一级分类
    secondaryClassification: '', // 二级分类
    hiddenDangerDescription: '', // 隐患描述
    hiddenDangerLevel: '', // 隐患等级
    responsibleManagementEnterprise: '', // 管理责任企业
    discoveryTime: '', // 发现时间
    governanceSituation: '', // 治理
    offset: 1,
    limit: 20,
  }
  fetchData(true)
}

// 多选发生改变时
function handleSelectionChange(e: any) {
  checkoutList.value = e.map((item: { id: string }) => item.id)
}

// 导出
const exportList = () => {
  if (!checkoutList.value.length) {
    ElMessage.warning('请选择需要导出的数据')
    return
  }
  const loading = ElLoading.service({
    lock: true,
    text: '下载中请稍后',
    background: 'rgba(255, 255, 255, 0.8)',
  })
  exportOver({ ids: checkoutList.value }).then((res) => {
    exportFile(res.data, '管线占压数据列表.xlsx')
    loading.close()
  }).catch(() => {
    loading.close()
  })
}
// 导入
const importRef = ref()
const importList = () => {
  importRef.value.click()
}
const onFileChange = (event: any) => {
  if (event.target.files?.length !== 0) {
    // 创建formdata对象
    const fd = new FormData()
    fd.append('file', event.target.files[0])
    // fd.append('equipmentType', $props.equipmentType)
    const loading = ElLoading.service({
      lock: true,
      background: 'rgba(255, 255, 255, 0.8)',
    })
    importOver(fd).then((res) => {
      // 清空上传缓存
      importRef.value.value = ''
      if (res.code === 200) {
        ElMessage.success('上传成功')
        loading.close()
        fetchData(true)
      }
      else {
        loading.close()
      }
    }).catch(() => {
      // 清空上传缓存
      importRef.value.value = ''
      loading.close()
    })
  }
}
// 删除
const deleteList = () => {
  if (!checkoutList.value.length) {
    ElMessage.warning('请选择需要删除的数据')
    return
  }
  batchDeleteOver({ ids: checkoutList.value }).then((res) => {
    ElMessage.success('操作成功')
    fetchData(true)
  })
}
// 模板下载
const templateDownload = () => {
  templateHole({}).then((res) => {
    exportFile(res.data, '地下空洞模板')
  })
}
// 页数发生变化后的操作，可能是页码变化，可能是每页容量变化，此函数必写
const changePage = (val: { size?: number; page?: number }) => {
  if (val && val.size) {
    listQuery.value.limit = val.size
  }
  if (val && val.page) {
    listQuery.value.offset = val.page
  }
  fetchData(true)
}

// 编辑
const handlerRef = ref()
const handler = (type: string, row: any) => {
  handlerRef.value.initDialog(type, row)
}

const hiddenDangerLevelList = ref<dictType[]>([]) // 隐患等级
const governanceSituationList = ref<dictType[]>([]) // 是否治理
// 查询字典
const getDict = async () => {
  // 巡检状态
  getDictByCode('hiddenDangerLevel').then((response) => {
    hiddenDangerLevelList.value = response.data
  })
  getDictByCode('isAlarm').then((response) => {
    governanceSituationList.value = response.data
  })
}

onMounted(async () => {
  await getDict()
  fetchData(true) // 获取数据
})
</script>

<template>
  <!-- 布局 -->
  <app-container>
    <!-- 编辑操作 -->
    <detail-dialog ref="handlerRef" @refresh="searchList" />
    <search-area :need-clear="true" @search="searchList" @clear="reset">
      <search-item>
        <el-input
          v-model.trim="listQuery.hiddenDangerNumber"
          placeholder="隐患编号"
          class="short-input"
          clearable
        />
      </search-item>
      <search-item>
        <el-input
          v-model.trim="listQuery.primaryClassification"
          placeholder="一级分类"
          class="short-input"
          clearable
        />
      </search-item>
      <search-item>
        <el-input
          v-model.trim="listQuery.secondaryClassification"
          placeholder="二级分类"
          class="short-input"
          clearable
        />
      </search-item>
      <search-item>
        <el-input
          v-model.trim="listQuery.hiddenDangerDescription"
          placeholder="隐患描述"
          class="short-input"
          clearable
        />
      </search-item>
      <search-item>
        <el-select v-model="listQuery.hiddenDangerLevel" class="short-input" placeholder="隐患等级" clearable>
          <el-option v-for="item in hiddenDangerLevelList" :key="item.id" :label="item.name" :value="item.value" />
        </el-select>
      </search-item>
      <search-item>
        <el-input
          v-model.trim="listQuery.responsibleManagementEnterprise"
          placeholder="管理责任公司"
          class="short-input"
          clearable
        />
      </search-item>
      <search-item>
        <el-date-picker
          v-model="listQuery.discoveryTime"
          type="date"
          placeholder="发现时间"
          style="width: 100%;"
          format="YYYY-MM-DD"
          value-format="YYYY-MM-DD HH:mm:ss"
        />
      </search-item>
      <search-item>
        <el-select v-model="listQuery.governanceSituation" class="short-input" placeholder="是否进行治理" clearable>
          <el-option v-for="item in governanceSituationList" :key="item.id" :label="item.name" :value="item.value" />
        </el-select>
      </search-item>
    </search-area>
    <table-container>
      <template #btns-right>
        <icon-button icon="icon-add" title="新增" type="primary" @click="handler('create', {})" />
        <icon-button icon="icon-delete" title="删除" type="primary" @click="deleteList" />
        <icon-button icon="icon-template" title="模板下载" type="primary" @click="templateDownload" />
        <icon-button icon="icon-import" title="导入" type="primary" @click="importList" />
        <input ref="importRef" style="display: none;" type="file" accept=".xls,.xlsx" @change="onFileChange">
        <icon-button icon="icon-export" title="导出" type="primary" @click="exportList" />
      </template>
      <normal-table
        :data="list" :total="total" :columns="columns" :query="listQuery" :list-loading="loadingTable"
        is-showmulti-select @change="changePage" @multi-select="handleSelectionChange"
      >
        <template #preColumns>
          <el-table-column label="#" width="55" align="center">
            <template #default="scope">
              {{ (listQuery.offset - 1) * listQuery.limit + scope.$index + 1 }}
            </template>
          </el-table-column>
        </template>
        <template #columns>
          <el-table-column label="操作" align="center" fixed="right" width="120">
            <template #default="{ row }">
              <el-button size="small" link type="primary" @click="handler('detail', row)">
                详情
              </el-button>
              <el-button size="small" link type="primary" @click="handler('update', row)">
                编辑
              </el-button>
            </template>
          </el-table-column>
        </template>
      </normal-table>
    </table-container>
  </app-container>
</template>

<style lang="scss" scoped>
// 样式
</style>