xh-client-background/src/views/basicData/xcrAgriculturalCollegeAnnualReport/index.vue

<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="68px">
                  <el-form-item label="统一社会信用代码" prop="uniCode" label-width="200">
                    <el-input
                        v-model="queryParams.uniCode"
                        placeholder="请输入统一社会信用代码"
                        clearable
                        @keyup.enter="handleQuery"
                    />
                  </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
        <el-button icon="Refresh" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
            type="warning"
            plain
            icon="Download"
            @click="handleExport"
            :disabled="!reportList.length"
            v-hasPermi="['basicData:xcrAgriculturalCollegeAnnualReport:export']"
        >导出
        </el-button>
      </el-col>
    </el-row>

    <el-table v-loading="loading" :data="reportList" height="650" @selection-change="handleSelectionChange">
                                  <el-table-column label="年报ID" align="center" prop="ANCHEID" :show-overflow-tooltip='true'/>
                  <el-table-column label="主体身份代码" align="center" prop="PRIPID" :show-overflow-tooltip='true'/>
              <el-table-column label="年报时间 (YYYYMMDDHHMMSS)" align="center" prop="ANCHEDATE" width="180">
                <template #default="scope">
                  <span>{{ parseTime(scope.row.ANCHEDATE, '{y}-{m}-{d}') }}</span>
                </template>
              </el-table-column>
                  <el-table-column label="年报年度 (YYYY)" align="center" prop="ANCHEYEAR" :show-overflow-tooltip='true'/>
                  <el-table-column label="合作社名称" align="center" prop="FARSPEARTNAME" :show-overflow-tooltip='true'/>
                  <el-table-column label="统一社会信用代码 (CA91)" align="center" prop="UNISCID" :show-overflow-tooltip='true'/>
                  <el-table-column label="注册号 (CA15)" align="center" prop="REGNO" :show-overflow-tooltip='true'/>
                  <el-table-column label="成员人数" align="center" prop="MEMNUM" :show-overflow-tooltip='true'/>
                  <el-table-column label="成员人数中农民人数" align="center" prop="FARNUM" :show-overflow-tooltip='true'/>
                  <el-table-column label="本年度新增成员人数" align="center" prop="ANNNEWMEMNUM" :show-overflow-tooltip='true'/>
                  <el-table-column label="本年度退出成员人数" align="center" prop="ANNREDMEMNUM" :show-overflow-tooltip='true'/>
                  <el-table-column label="联系电话" align="center" prop="TEL" :show-overflow-tooltip='true'/>
                  <el-table-column label="电子邮件" align="center" prop="EMAIL" :show-overflow-tooltip='true'/>
                  <el-table-column label="销售额或营业收入 (单元：万元)" align="center" prop="PRIYEASALES" :show-overflow-tooltip='true'/>
                  <el-table-column label="销售额或营业收入是否公示 (1 公示，2不公示)" align="center" prop="PRIYEASALESDIS" :show-overflow-tooltip='true'/>
                  <el-table-column label="盈余总额 (单元：万元)" align="center" prop="PRIYEAPROFIT" :show-overflow-tooltip='true'/>
                  <el-table-column label="盈余总额是否公示 (1 公示，2不公示)" align="center" prop="PRIYEAPROFITDIS" :show-overflow-tooltip='true'/>
                  <el-table-column label="获得政府扶持资金、补助 (单元：万元)" align="center" prop="PRIYEASUB" :show-overflow-tooltip='true'/>
                  <el-table-column label="获得政府扶持资金、补助是否公示 (1 公示，2不公示)" align="center" prop="PRIYEASUBDIS" :show-overflow-tooltip='true'/>
                  <el-table-column label="纳税金额 (单位：万元)" align="center" prop="RATGRO" :show-overflow-tooltip='true'/>
                  <el-table-column label="纳税金额是否公示 (1 公示，2不公示)" align="center" prop="RATGRODIS" :show-overflow-tooltip='true'/>
                  <el-table-column label="金融贷款 (单元：万元)" align="center" prop="PRIYEALOAN" :show-overflow-tooltip='true'/>
                  <el-table-column label="金融贷款是否公示 (1 公示，2不公示)" align="center" prop="PRIYEALOANDIS" :show-overflow-tooltip='true'/>
              <el-table-column label="最后一次修改时间" align="center" prop="LASTUPDATETIME" width="180">
                <template #default="scope">
                  <span>{{ parseTime(scope.row.LASTUPDATETIME, '{y}-{m}-{d}') }}</span>
                </template>
              </el-table-column>
                  <el-table-column label="${comment}" align="center" prop="ENTCHEYEAR" :show-overflow-tooltip='true'/>
              <el-table-column label="数据初始化或更新时间戳" align="center" prop="sExtDatatime" width="180">
                <template #default="scope">
                  <span>{{ parseTime(scope.row.sExtDatatime, '{y}-{m}-{d}') }}</span>
                </template>
              </el-table-column>
                  <el-table-column label="统一社会信用代码" align="center" prop="uniCode" width="200"/>
    </el-table>

    <div style="position: fixed;bottom: 20px;right: 10px;">
      <pagination
          v-show="total>0"
          :total="total"
          v-model:page="queryParams.pageNum"
          v-model:limit="queryParams.pageSize"
          @pagination="getList"
      />
    </div>

    <el-dialog :title="upload.title" v-model="upload.open" width="400px" append-to-body>
      <el-upload ref="uploadRef" :limit="1" accept=".xlsx, .xls" :headers="upload.headers"
                 :action="upload.url + '?updateSupport=' + upload.updateSupport" :disabled="upload.isUploading"
                 :on-progress="handleFileUploadProgress" :on-success="handleFileSuccess" :auto-upload="false" drag>
        <el-icon class="el-icon--upload">
          <upload-filled/>
        </el-icon>
        <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
        <template #tip>
          <div class="el-upload__tip text-center">
            <span>仅允许导入xls、xlsx格式文件。</span>
          </div>
        </template>
      </el-upload>
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitFileForm">确 定</el-button>
          <el-button @click="upload.open = false">取 消</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script setup name="Report">
  import {
    listReport,
    getReport,
    delReport,
    delReportBatch
  } from "@/api/basicData/xcrAgriculturalCollegeAnnualReport";
  import {reactive, ref, toRaw} from "vue";
  import {getToken} from "@/utils/auth";
  import {ElMessage} from "element-plus";
  import {likeQueryMethod} from "@/utils/likeQueryMethod";

  const {proxy} = getCurrentInstance();

  const reportList = ref([]);
  const open = ref(false);
  const loading = ref(true);
  const showSearch = ref(true);
  const ids = ref([]);
  const single = ref(true);
  const multiple = ref(true);
  const total = ref(0);
  const title = ref("");

  const upload = reactive({
    // 是否显示弹出层（用户导入）
    open: false,
    // 弹出层标题（用户导入）
    title: '',
    // 是否禁用上传
    isUploading: false,
    // 设置上传的请求头部
    headers: {Authorization: getToken()},
    // 上传的地址
    url: import.meta.env.VITE_APP_BASE_API + '/xcrAgriculturalCollegeAnnualReport/importData'
  })
  const handleFileSuccess = (e) => {
    if (e.code == 200) {
      ElMessage({
        type: "success",
        message: e.msg
      })
      getList()
      proxy.$refs['uploadRef']?.clearFiles()
    } else {
      ElMessage({
        type: "error",
        message: e.msg
      })
      proxy.$refs['uploadRef']?.clearFiles()
    }
  }

  function submitFileForm() {
    proxy.$refs['uploadRef']?.submit();
    upload.open = false;
  }

  function handleImport() {
    upload.open = true
  }

  const data = reactive({
    form: {},
    queryParams: {
      pageNum: 1,
      pageSize: 20,
                        ANCHEID: null,
                        PRIPID: null,
                        ANCHEDATE: null,
                        ANCHEYEAR: null,
                        FARSPEARTNAME: null,
                        UNISCID: null,
                        REGNO: null,
                        MEMNUM: null,
                        FARNUM: null,
                        ANNNEWMEMNUM: null,
                        ANNREDMEMNUM: null,
                        TEL: null,
                        EMAIL: null,
                        PRIYEASALES: null,
                        PRIYEASALESDIS: null,
                        PRIYEAPROFIT: null,
                        PRIYEAPROFITDIS: null,
                        PRIYEASUB: null,
                        PRIYEASUBDIS: null,
                        RATGRO: null,
                        RATGRODIS: null,
                        PRIYEALOAN: null,
                        PRIYEALOANDIS: null,
                        LASTUPDATETIME: null,
                        ENTCHEYEAR: null,
                        sExtDatatime: null,
                        uniCode: ''
    },
    rules: {
    }
  });

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

  /** 查询农专年报基本信息列表 */
  function getList() {
    loading.value = true;
                                                                                              let toServerObj = likeQueryMethod('uni_code', queryParams.value.uniCode, queryParams.value.pageNum, queryParams.value.pageSize);
    listReport(toServerObj).then(response => {
            reportList.value = response.records;
      total.value = response.total;
      loading.value = false;
    });
  }


  // 表单重置
  function reset() {
    form.value = {
                        xhCodeId: null,
                        ANCHEID: null,
                        PRIPID: null,
                        ANCHEDATE: null,
                        ANCHEYEAR: null,
                        FARSPEARTNAME: null,
                        UNISCID: null,
                        REGNO: null,
                        MEMNUM: null,
                        FARNUM: null,
                        ANNNEWMEMNUM: null,
                        ANNREDMEMNUM: null,
                        TEL: null,
                        EMAIL: null,
                        PRIYEASALES: null,
                        PRIYEASALESDIS: null,
                        PRIYEAPROFIT: null,
                        PRIYEAPROFITDIS: null,
                        PRIYEASUB: null,
                        PRIYEASUBDIS: null,
                        RATGRO: null,
                        RATGRODIS: null,
                        PRIYEALOAN: null,
                        PRIYEALOANDIS: null,
                        LASTUPDATETIME: null,
                        ENTCHEYEAR: null,
                        sExtDatatime: null,
                        uniCode: ''
    };
    proxy.resetForm("reportRef");
  }

  /** 搜索按钮操作 */
  function handleQuery() {
    queryParams.value.pageNum = 1;
    getList();
  }

  /** 重置按钮操作 */
  function resetQuery() {
    proxy.resetForm("queryRef");
    handleQuery();
  }

  // 多选框选中数据
  function handleSelectionChange(selection) {
    ids.value = selection.map(item => item.xhCodeId);
    single.value = selection.length != 1;
    multiple.value = !selection.length;
  }


  /** 删除按钮操作 */
  async function handleDelete(row) {
    const res = await delReport();
    if(res.code == 200){
      ElMessage({
        type:'success',
        message:'删除成功'
      })
      getList();
    }
  }
  /** 批量删除*/
  const batchDelete = (row)=>{
    const idsToS = row.xhCodeId || ids.value;
    (proxy.$modal).confirm('是否确认删除这' + idsToS.length+'条的数据项？').then(function() {
      return delReportBatch(toRaw(idsToS));
    }).then(() => {
      getList();
      proxy.$modal.msgSuccess("删除成功");
    }).catch(() => {});
  }

  /** 导出按钮操作 */
  function handleExport() {
    proxy.download('basicData/xcrAgriculturalCollegeAnnualReport/export', {
      ...queryParams.value
    }, `农专年报基本信息_${new Date().getTime()}.xlsx`)
  }

  getList();
</script>