exportLevelSettlement.vue 12.7 KB
<template>
  <div class="">
    <div class="from-Card">
      <el-form
        v-show="showSearch" ref="queryRef" size="small" :model="queryParams" :inline="true"
        label-position="top"
      >
        <el-row style="width: 100%;">
          <el-col :span="4">
            <el-form-item label="结算编号" prop="payCode">
              <el-input
                v-model.trim="queryParams.payCode"
                placeholder="请输入结算编号"
                clearable
                style="width: 100%;"
                @keyup.enter="handleQuery"
              />
            </el-form-item>
          </el-col>
          <el-col v-show="queryParams.type == '1'" :span="4">
            <el-form-item label="缴费编号" prop="examCodes">
              <el-input
                v-model.trim="queryParams.examCodes"
                placeholder="请输入缴费编号"
                clearable
                style="width: 100%;"
                @keyup.enter="handleQuery"
              />
            </el-form-item>
          </el-col>
          <el-col :span="4">
            <el-form-item label="缴费名称" prop="name">
              <el-input
                v-model.trim="queryParams.name"
                placeholder="请输入缴费名称"
                clearable
                style="width: 100%;"
                @keyup.enter="handleQuery"
              />
            </el-form-item>
          </el-col>
          <el-col :span="4">
            <el-form-item label="缴费单位" prop="memName">
              <el-input
                v-model.trim="queryParams.memName"
                placeholder="请输入缴费单位"
                clearable
                style="width: 100%;"
                @keyup.enter="handleQuery"
              />
            </el-form-item>
          </el-col>
          <!--          <el-col :span="5">-->
          <!--            <el-form-item label="审核日期" prop="verityTimeRange">-->
          <!--              <el-date-picker-->
          <!--                v-model="queryParams.verityTimeRange"-->
          <!--                clearable-->
          <!--                type="daterange"-->
          <!--                range-separator="至"-->
          <!--                start-placeholder="开始时间"-->
          <!--                end-placeholder="结束时间"-->
          <!--                value-format="YYYY-MM-DD"-->
          <!--                style="width: 100%;"-->
          <!--                @change="handleQuery"-->
          <!--              />-->
          <!--            </el-form-item>-->
          <!--          </el-col>-->
          <el-col :span="5" style="display: flex">
            <el-form-item style="width: 100%;" label="审核日期" prop="verityTimeRange">
              <el-date-picker
                v-model="queryParams.verityTimeRange[0]" type="date" value-format="YYYY-MM-DD"
                placeholder="开始时间" style="width: 100%;"
              />
            </el-form-item>
            <el-form-item style="width: 100%;" label="审核日期" prop="verityTimeRange">
              <el-date-picker
                v-model="queryParams.verityTimeRange[1]" type="date" value-format="YYYY-MM-DD"
                placeholder="结束时间" style="width: 100%;"
              />
            </el-form-item>
          </el-col>
          <div class="po-r-btns">
            <el-button size="small" type="primary" @click="handleQuery">搜索</el-button>
            <el-button size="small" @click="resetQuery">重置</el-button>
            <el-button
              v-if="showCollect" size="small" type="primary" link icon="ArrowDown"
              @click="showCollect=!showCollect"
            >展开</el-button>
            <el-button
              v-else size="small" type="primary" link icon="ArrowUp"
              @click="showCollect=!showCollect"
            >收起</el-button>
          </div>
        </el-row>
      </el-form>
      <el-row justify="space-between">
        <div>
          <el-button type="warning" :icon="Download" @click="handleExport">导出</el-button>
        </div>
      </el-row>
    </div>
    <div class="table">
      <el-table v-loading="loading" :row-class-name="tableRowClassName" border :data="infoList">
        <el-table-column type="index" width="55" align="center" label="序号" />
        <el-table-column label="结算编号" align="center" prop="payCode" min-width="120" :show-overflow-tooltip="true">
          <template #default="scope">
            <el-button link type="primary" :disabled=" scope.row.verityStatus=='2'||scope.row.verityStatus=='3'" @click="handlePaymentView(scope.row) ">
              {{ scope.row.payCode }}
            </el-button>
          </template>
        </el-table-column>
        <el-table-column label="缴费名称" align="center" prop="name" :show-overflow-tooltip="true" min-width="250" />
        <el-table-column label="缴费单位" align="center" prop="memberName" :show-overflow-tooltip="true" min-width="100" />
        <el-table-column label="审批状态" align="center" prop="verityStatusStr" min-width="100">
          <template #default="scope">
            <span
              :class="{
                'text-success':scope.row.verityStatus=='1',
                'text-danger':scope.row.verityStatus=='2',
                'text-warning':scope.row.verityStatus=='3'
              }"
            >{{ scope.row.verityStatusStr }}</span>
          </template>
        </el-table-column>
        <el-table-column label="缴费状态" align="center" prop="payStatusStr" min-width="100">
          <template #default="scope">
            <div
              :class="{
                ' text-success s':scope.row.payStatusStr=='已上传凭证',
                'text-danger':scope.row.payStatusStr=='未上传凭证',
                'text-warning s':scope.row.payStatusStr=='已结算'
              }"
              @click="downloadPayment(scope.row)"
            >
              {{ scope.row.payStatusStr }}
            </div>
          </template>
        </el-table-column>
        <el-table-column label="人数合计" align="center" prop="totalNum" min-width="80" />
        <el-table-column label="费用合计" align="center" prop="totalAmount" min-width="80" />
        <el-table-column label="缴费单创建日期" align="center" prop="submitTime" min-width="120">
          <template #default="scope">
            <span>{{ parseTime(scope.row.submitTime, '{y}-{m}-{d}') }}</span>
          </template>
        </el-table-column>

        <el-table-column label="缴费日期" align="center" prop="payTime" min-width="100">
          <template #default="scope">
            <span>{{ parseTime(scope.row.payTime, '{y}-{m}-{d}') }}</span>
          </template>
        </el-table-column>
        <el-table-column label="结算日期" align="center" prop="settleTime" min-width="100">
          <template #default="scope">
            <span>{{ parseTime(scope.row.settleTime, '{y}-{m}-{d}') }}</span>
          </template>
        </el-table-column>
        <el-table-column label="审核日期" align="center" prop="payTime" min-width="100">
          <template #default="scope">
            <span>{{ parseTime(scope.row.verityDate, '{y}-{m}-{d}') }}</span>
          </template>
        </el-table-column>
        <!--        <el-table-column label="操作" width="260" fixed="right" align="center" class-name="small-padding fixed-width">-->
        <!--          <template #default="scope">-->
        <!--            <el-button type="primary" @click="handleView(scope.row)">查看</el-button>-->
        <!--            <el-button color="#13B5B1" style="&#45;&#45;el-color-black:#fff;" :disabled="!(scope.row.payStatus == '3' || scope.row.payStatus == '5')" @click="downloadPayment(scope.row)">下载凭证</el-button>-->
        <!--            <el-button v-if="scope.row.payStatus != '3'" :disabled="!((scope.row.verityStatus == '1'||scope.row.verityStatus == '0') && scope.row.payStatus == '5')" type="warning" @click="settle(scope.row,0)">结算</el-button>-->
        <!--            <el-button v-if="scope.row.payStatus == '3'" :disabled="!(scope.row.verityStatus == '1')" type="danger" @click="settle(scope.row,1)">取消结算</el-button>-->
        <!--          </template>-->
        <!--        </el-table-column>-->
        <el-table-column label="操作" width="100" fixed="right" align="center" class-name="small-padding fixed-width">
          <template #default="scope">
            <div>
              <el-button type="primary" @click="handleView(scope.row)">查看</el-button>
            </div>
          </template>
        </el-table-column>
      </el-table>
      <div v-show="total>0" class="totalCost">
        费用合计:<span>{{ statistical.totalCost?.toFixed(2) }} </span>
        人数合计:<span>{{ statistical.totalNum }} </span>
      </div>
      <pagination
        v-show="total>0"
        v-model:page="queryParams.pageNum"
        v-model:limit="queryParams.pageSize"
        :total="total"
        @pagination="getList"
      />
    </div>
    <view-payment ref="viewPaymentRef" />
    <view-merge ref="viewMergeRef" />
    <el-link v-show="false" ref="payCertRef" :href="fillImgUrl(currPayCert.url)" :download="currPayCert.name" target="_blank">{{ currPayCert.name }}</el-link>
  </div>
</template>

<script>
let pageName
if (location.href.indexOf('/level/') > -1) {
  pageName = 'Level_Settlement'
} else if (location.href.indexOf('/rank/') > -1) {
  pageName = 'Rank_Settlement'
} else if (location.href.indexOf('/beyond/') > -1) {
  pageName = 'Beyond_Settlement'
}

export default {
  name: pageName
}
</script>

<script setup>
import { getCurrentInstance, reactive } from '@vue/runtime-core'
import { nextTick, onMounted, ref, toRefs } from 'vue'
import { parseTime } from '@/utils/ruoyi'
import { paymentList } from '@/api/exam/payment'
import ViewPayment from './paymentView'
import { useRoute } from 'vue-router'
import { Download } from '@element-plus/icons-vue'
import ViewMerge from '@/views/exam/level/approval/components/mergeView'
import _ from 'lodash'

const { proxy } = getCurrentInstance()
const route = useRoute()
const showCollect = ref(true)
const infoList = ref([])
const loading = ref(false)
const showSearch = ref(true)
const total = ref(0)
const currPayCert = ref({})
const statistical = ref({})

const data = reactive({
  queryParams: {
    pageNum: 1,
    pageSize: 10,
    name: undefined,
    payCode: undefined,
    memName: undefined,
    submitTimeRange: undefined,
    settleTimeRange: undefined,
    payTimeRange: undefined,
    status: undefined,
    payStatus: undefined,
    examCodes: undefined,
    verityTimeRange: [null, null],
    verityStatus: '1'
    // type: '1'
  },
  transcript: [],
  payId: undefined
})
const { queryParams } = toRefs(data)

onMounted(() => {
  if (route.path.indexOf('level') > -1) {
    queryParams.value.type = '1'
  } else if (route.path.indexOf('rank') > -1) {
    queryParams.value.type = '2'
  } else if (route.path.indexOf('beyond') > -1) {
    queryParams.value.type = '3'
  }

  getList()
})

function downloadPayment(row) {
  if (row.payStatusStr == '未上传凭证') return
  try {
    const payCert = JSON.parse(row.payCert)
    currPayCert.value = payCert[0]
    // console.log(currPayCert.value)
    nextTick(() => {
      proxy.$refs['payCertRef'].$el.click()
    })
  } catch (e) {
    currPayCert.value = {}
    proxy.$modal.msgError('下载失败')
  }
}

// // 背景色
const tableRowClassName = ({
  row,
  rowIndex
}) => {
  if (row.payStatusStr == '已结算') {
    return 'success-row'
  }
}


/** 查询考级信息列表 */
function getList() {
  if ((queryParams.value.verityTimeRange[0] == null && queryParams.value.verityTimeRange[1] != null) || (queryParams.value.verityTimeRange[1] == null && queryParams.value.verityTimeRange[0] != null)) return proxy.$modal.msgError('请完善审核日期')
  loading.value = true
  paymentList(queryParams.value).then(response => {
    statistical.value = {
      totalCost: 0,
      totalNum: 0
    }
    infoList.value = response.rows
    total.value = response.total
    loading.value = false
    _.each(infoList.value, (info) => {
      statistical.value.totalCost += (info.totalAmount * 1)
      statistical.value.totalNum += (info.totalNum * 1)
    })
  })
}

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

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

function handleView(row) {
  proxy.$refs['viewMergeRef'].open(null, row, true)
}

function handlePaymentView(row) {
  proxy.$refs['viewPaymentRef'].open(row.payId, queryParams.value.type)
}

function handleExport() {
  proxy.download('/exam/payment/export2', {
    ...queryParams.value
  }, `考试缴费单_${new Date().getTime()}.xlsx`)
}

</script>
<style lang="scss" scoped >

</style>