<!-- 管线占压数据管理 -->
<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'
import { exportExcel } from '@/utils/exportXlsx'
const $router = useRouter()
const { proxy } = getCurrentInstance() as any

// 查询条件
const listQuery = ref({
  // hiddenDangerNumber: '', // 隐患编号
  // primaryClassification: '', // 一级分类
  // secondaryClassification: '', // 二级分类
  // hiddenDangerDescription: '', // 隐患描述
  // hiddenDangerLevel: '', // 隐患等级
  // responsibleManagementEnterprise: '', // 管理责任企业
  // discoveryTime: '', // 发现时间
  // governanceSituation: '', // 治理
  begTime: '',
  endTime: '',
  isProcess: '',
  overLevel: '',
  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[]>([])
// 筛选时间段数据
const dateRange = ref<any[]>(['', ''])

// 时间变更
watch(dateRange, (val) => {
  if (val) {
    listQuery.value.begTime = `${val[0]}`
    listQuery.value.endTime = `${val[1]}`
  }
  else {
    listQuery.value.begTime = ''
    listQuery.value.endTime = ''
  }
})
// 数据查询
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: '', // 治理
    begTime: '',
    endTime: '',
    isProcess: '',
    overLevel: '',
    offset: 1,
    limit: 20,
  }
  dateRange.value = ['', '']
  fetchData(true)
}

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

// 导出
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 titleArr = ['#', ...columns.value.map((item: any) => item.text)]
  const json = checkoutList.value.map((item: any, index: number) => {
    const obj = {} as any
    columns.value.map((item: any) => item.value).forEach((element: any) => {
      obj[element] = item[element]
    })
    return {
      index: index + 1,
      ...obj,
    }
  })
  exportExcel({
    json,
    name: '管线占压数据列表',
    titleArr,
    sheetName: 'sheet1',
  })
  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
  }
  ElMessageBox.confirm(
    '确认删除所选数据吗？',
    '提示',
    {
      confirmButtonText: '确认',
      cancelButtonText: '取消',
      type: 'warning',
    },
  ).then(() => {
    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-date-picker
          v-model="dateRange"
          class="short-input"
          type="datetimerange"
          range-separator="至"
          format="YYYY-MM-DD HH:mm:ss"
          value-format="YYYY-MM-DD HH:mm:ss"
          start-placeholder="发现开始时间"
          end-placeholder="发现结束时间"
        />
      </search-item>
      <search-item>
        <el-select v-model="listQuery.overLevel" 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.isProcess" class="short-input" placeholder="是否进行治理" clearable>
          <!-- <el-option v-for="item in governanceSituationList" :key="item.id" :label="item.name" :value="item.value" /> -->
          <el-option value="已治理" label="已治理">
            已治理
          </el-option>
          <el-option value="未治理" label="未治理">
            未治理
          </el-option>
        </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" /> -->
        <icon-button icon="icon-export" title="导出" type="primary" @click="exportList" />
        <input ref="importRef" style="display: none;" type="file" accept=".xls,.xlsx" @change="onFileChange">
      </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>