xh-client-background/src/views/basicData/xcrExternalGuarantee/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="!guaranteeList.length"
            v-hasPermi="['basicData:xcrExternalGuarantee:export']"
        >导出
        </el-button>
      </el-col>
    </el-row>

    <el-table v-loading="loading" :data="guaranteeList" height="650" @selection-change="handleSelectionChange">
                                  <el-table-column label="对外担保标识ID" align="center" prop="MOREID" :show-overflow-tooltip='true'/>
                  <el-table-column label="年报ID" align="center" prop="ANCHEID" :show-overflow-tooltip='true'/>
                  <el-table-column label="债权人" align="center" prop="MORE" :show-overflow-tooltip='true'/>
                  <el-table-column label="债务人" align="center" prop="MORTGAGOR" :show-overflow-tooltip='true'/>
                  <el-table-column label="主债权种类 1、合同,2、其他" align="center" prop="PRICLASECKIND" :show-overflow-tooltip='true'/>
                  <el-table-column label="主债权数额" align="center" prop="PRICLASECAM" :show-overflow-tooltip='true'/>
              <el-table-column label="履行债务的期限自 YYYYMMDD" align="center" prop="PEFPERFORM" width="180">
                <template #default="scope">
                  <span>{{ parseTime(scope.row.PEFPERFORM, '{y}-{m}-{d}') }}</span>
                </template>
              </el-table-column>
              <el-table-column label="履行债务的期限至 YYYYMMDD" align="center" prop="PEFPERTO" width="180">
                <template #default="scope">
                  <span>{{ parseTime(scope.row.PEFPERTO, '{y}-{m}-{d}') }}</span>
                </template>
              </el-table-column>
                  <el-table-column label="保证的期间 1、期限，2、未约定" align="center" prop="GUARANPERIOD" :show-overflow-tooltip='true'/>
                  <el-table-column label="对外担保是否公示 1、是，2、否" align="center" prop="MOREDIS" :show-overflow-tooltip='true'/>
                  <el-table-column label="${comment}" align="center" prop="ENTCHEYEAR" :show-overflow-tooltip='true'/>
                  <el-table-column label="保证的方式 1、一般保证，2、连带保证，3、未约定" align="center" prop="GATYPE" :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="Guarantee">
  import {
    listGuarantee,
    getGuarantee,
    delGuarantee,
    delGuaranteeBatch
  } from "@/api/basicData/xcrExternalGuarantee";
  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 guaranteeList = 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 + '/xcrExternalGuarantee/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,
                        MOREID: null,
                        ANCHEID: null,
                        MORE: null,
                        MORTGAGOR: null,
                        PRICLASECKIND: null,
                        PRICLASECAM: null,
                        PEFPERFORM: null,
                        PEFPERTO: null,
                        GUARANPERIOD: null,
                        MOREDIS: null,
                        ENTCHEYEAR: null,
                        GATYPE: 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);
    listGuarantee(toServerObj).then(response => {
            guaranteeList.value = response.records;
      total.value = response.total;
      loading.value = false;
    });
  }


  // 表单重置
  function reset() {
    form.value = {
                        xhCodeId: null,
                        MOREID: null,
                        ANCHEID: null,
                        MORE: null,
                        MORTGAGOR: null,
                        PRICLASECKIND: null,
                        PRICLASECAM: null,
                        PEFPERFORM: null,
                        PEFPERTO: null,
                        GUARANPERIOD: null,
                        MOREDIS: null,
                        ENTCHEYEAR: null,
                        GATYPE: null,
                        sExtDatatime: null,
                        uniCode: ''
    };
    proxy.resetForm("guaranteeRef");
  }

  /** 搜索按钮操作 */
  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 delGuarantee();
    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 delGuaranteeBatch(toRaw(idsToS));
    }).then(() => {
      getList();
      proxy.$modal.msgSuccess("删除成功");
    }).catch(() => {});
  }

  /** 导出按钮操作 */
  function handleExport() {
    proxy.download('basicData/xcrExternalGuarantee/export', {
      ...queryParams.value
    }, `企业年报对外提供保证担保信息_${new Date().getTime()}.xlsx`)
  }

  getList();
</script>