yjhtgl-web/src/views/dataFilling/fillingManage.vue

<template>
  <div>
    <div v-show="!fillingAddState.show && !tableDetailsState.show" class="app-container">
      <div>
        <transition name="fade">
          <div v-show="showSearch">
            <el-form ref="queryFormRef" :model="queryParams">
              <el-row :gutter="20">
                <!-- 表格名称 -->
                <el-col :span="6">
                  <el-form-item label="表格名称：" prop="table_name" label-width="auto">
                    <el-input v-model="queryParams.table_name" placeholder="请输入表格名称"></el-input>
                  </el-form-item>
                </el-col>
                <!-- 表格状态 -->
                <el-col :span="6">
                  <el-form-item label="表格状态：" prop="status">
<!--                    <el-radio-group v-model="form.task_status">-->
<!--                      <el-radio value="0" size="large">在用</el-radio>-->
<!--                      <el-radio value="1" size="large">禁止</el-radio>-->
<!--                    </el-radio-group>-->
                    <el-select
                      v-model="queryParams.status"
                      clearable
                      placeholder="请选择"
                      style="width: 240px"
                    >
                      <el-option
                        v-for="item in options"
                        :key="item.value"
                        :label="item.label"
                        :value="item.value"
                      />
                    </el-select>
                  </el-form-item>
                </el-col>
                <!-- 发布时间 -->
                <el-col :span="6">
                  <el-form-item label="发布时间：" prop="release_time">
                    <el-date-picker
                      v-model="selectedTime"
                      type="daterange"
                      range-separator="至"
                      start-placeholder="开始日期"
                      end-placeholder="结束日期"
                      value-format="YYYY-MM-DD HH:mm:ss"
                    />
                  </el-form-item>
                </el-col>
                <!-- 下发状态 -->
                <el-col :span="6">
                  <el-form-item label="发布状态：" prop="issued_status">
<!--                    <el-radio-group v-model="queryParams.issued_status">-->
<!--                      <el-radio value="0" size="large">待发布</el-radio>-->
<!--                      <el-radio value="1" size="large">已发布</el-radio>-->
<!--                    </el-radio-group>-->
                    <el-select
                      v-model="queryParams.issued_status"
                      clearable
                      placeholder="请选择"
                      style="width: 240px"
                    >
                      <el-option
                        v-for="item in options1"
                        :key="item.value"
                        :label="item.label"
                        :value="item.value"
                      />
                    </el-select>
                  </el-form-item>
                </el-col>
                <!-- 操作按钮 -->
                <el-col :span="6">
                  <el-button type="primary" @click="handleQuery">查询</el-button>
                  <el-button type="primary" @click="resetQuery">重置</el-button>
                  <el-button type="primary" @click="exportTableData()">导出</el-button>
                  <el-button type="primary" @click="handleAdd">新增</el-button>
                </el-col>
              </el-row>
            </el-form>
          </div>
        </transition>
        <!-- 表格组件 -->
        <el-table ref="multipleTable" v-loading="loading" :data="tableData" @selection-change="handleSelectionChange">
          <el-table-column label="序号" align="center" prop="id" />
          <el-table-column label="表格名称" align="center" prop="table_name" />
          <el-table-column label="发布日期" align="center" prop="start_time" />
          <el-table-column label="发布状态" align="center" prop="issued_status">
            <template #default="scope">
              {{ scope.row.issued_status === 2 ? '已发布' : '待发布' }}
            </template>
          </el-table-column>
          <el-table-column label="截止填报时间" align="center" prop="end_time" />
          <el-table-column label="状态" align="center" prop="status">
            <template #default="scope">
              {{ scope.row.status === 1 ? '禁用' : scope.row.status === 0 ? "在用" : "废止" }}
            </template>
          </el-table-column>
          <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
            <template #default="scope">
              <!-- 只有待发布状态才显示下发按钮 -->
              <el-text v-if="scope.row.issued_status === 1" class="common-btn-text-primary" @click="handleIssue(scope.row)">下发</el-text>
              <el-text class="common-btn-text-primary" @click="handleView(scope.row)">详情</el-text>
            </template>
          </el-table-column>
        </el-table>
        <pagination
          v-show="total > 0"
          v-model:page="queryParams.page"
          v-model:limit="queryParams.pageSize"
          :total="total"
          @pagination="handlePagination"
        />
      </div>
    </div>
    <FillingAdd v-if="fillingAddState.show" :event-id="fillingAddState.eventId" @close="handleCancel" />
    <TableDetails v-if="tableDetailsState.show" :event-id="tableDetailsState.eventId" @close="handleCancel" />
  </div>
</template>

<script setup lang="ts">
import { onMounted, reactive, ref, toRefs } from 'vue';
import FillingAdd from './fillingAdd.vue';
import TableDetails from './tableDetails.vue';
import { ElButton, ElCol } from 'element-plus';
import { fillingSelect, fillingRelease } from '@/api/dataFilling/fillingManage';
import * as XLSX from 'xlsx';
import { deepClone } from '@/utils';
import { addDateRange2, parseTime } from '@/utils/ruoyi';
import { fillList } from '@/api/dataFilling/datafilling';

const loading = ref(true);
const showSearch = ref(true);
const selectedTime = ref([]);
const ids = ref<Array<number | string>>([]);
const total = ref(0);
const tableData = ref([]);
const { proxy } = getCurrentInstance() as ComponentInternalInstance;

const options = [
  {
    value: '1',
    label: '禁止',
  },
  {
    value: '0',
    label: '在用',
  }]
const options1 = [
  {
    value: '1',
    label: '待发布',
  },
  {
    value: '2',
    label: '已发布',
  }]
const initFormData = reactive({
  table_id: '',
  table_name: '',
  filling_time: '',
  release_time: '',
  release_status: '',
  task_status: '',
  status: ''
});

const data = reactive({
  form: { ...initFormData },
  queryParams: {
    page: 1,
    pageSize: 10,
    table_name: '',
    release_status: '',
    task_status: '',
    status: '',
    issued_status:''
  }
});

const { form, queryParams } = toRefs(data);

let fillingAddState = reactive({
  show: false,
  eventId: ''
});

let tableDetailsState = reactive({
  show: false,
  eventId: ''
});

const handleCancel = () => {
  fillingAddState.show = false;
  tableDetailsState.show = false;
  fetchFillList();
};

const handleAdd = () => {
  fillingAddState.eventId = null; // 表示新增记录
  fillingAddState.show = true;
};

const handleView = (row) => {
  if (row) {
    tableDetailsState.eventId = row.report_id; // 使用 report_id 作为事件ID
    tableDetailsState.show = true;
  }
};

const fetchFillList = () => {
  loading.value = true;
  let params = addDateRange2(deepClone(queryParams.value), selectedTime.value, 'start_time', 'end_time');
  // params.status = !queryParams.value.status ? [] : [queryParams.value.status];
  // params.issued_status = !queryParams.value.issued_status ? [] : [queryParams.value.issued_status];
  fillingSelect(params)
    .then((res) => {
      for(let i = 0; i < res.data.length; i++) {
        res.data[i].end_time = parseTime(res.data[i].end_time);
        res.data[i].start_time = parseTime(res.data[i].start_time);
      }
      tableData.value = res.data;
      total.value = res.total;
    })
    .finally(() => {
      loading.value = false;
    });
};

onMounted(() => {
  fetchFillList();
});

const handleQuery = () => {
  queryParams.value.page = 1; // 重置页码
  fetchFillList();
};

// 重置查询条件
const resetQuery = () => {
  queryParams.value = { page: 1, pageSize: 10, table_name: '', release_status: '', task_status: '' };
  selectedTime.value = [];
  handleQuery();
};

const handleSelectionChange = (selection) => {
  ids.value = selection.map((item) => item.id);
};

const handleTimeChange = () => {
  // selectedTimeLabel.value = value ? `${value[0]} 至 ${value[1]}` : '请选择时间';
};

const exportTableData = () => {
  const worksheet = XLSX.utils.json_to_sheet(tableData.value);
  const workbook = { Sheets: { data: worksheet }, SheetNames: ['data'] };
  const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });

  const blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
  const link = document.createElement('a');
  const url = window.URL.createObjectURL(blob);
  link.href = url;
  link.download = 'SheetJS.xlsx';
  link.click();
  window.URL.revokeObjectURL(url); // 清理
};

const handlePagination = ({ page, limit }) => {
  queryParams.value.page = page;
  queryParams.value.pageSize = limit;
  fetchFillList();
};

const handleIssue = (row) => {
  fillingAddState.show = true;
  fillingAddState.eventId = row.id;
  // 检查是否有report_id
  // if (!row.report_id) {
  //   console.error('报告ID不存在，无法下发');
  //   return;
  // }
  // // 构造下发请求的URL
  // const releaseUrl = `${row.report_id}`;
  // 发起下发请求
  // fillingRelease(releaseUrl)
  //   .then(() => {
  //     fetchFillList();
  //   })
  //   .catch((error) => {
  //     console.error('下发操作失败:', error);
  //   });
};
</script>