exportLevel.vue 9.12 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 :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="certTimeRange">-->
          <!--              <el-date-picker-->
          <!--                v-model="queryParams.certTimeRange"-->
          <!--                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="8" style="display: flex">
            <el-form-item style="width: 100%;" label="审核日期" prop="certTimeRange">
              <el-date-picker
                v-model="queryParams.certTimeRange[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.certTimeRange[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>
          </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="examCode" min-width="120" :show-overflow-tooltip="true" />
        <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="submitTime" min-width="190">
          <template #default="scope">
            <span>{{ parseTime(scope.row.startTime, '{y}-{m}-{d}') }} ~ {{ parseTime(scope.row.endTime,'{y}-{m}-{d}') }}</span>
          </template>
        </el-table-column>
        <el-table-column label="考级考官" align="center" prop="examinerNames" min-width="120" show-overflow-tooltip />
        <el-table-column label="考级人数" align="center" prop="totalNum" min-width="80" />
        <el-table-column label="金额" align="center" prop="totalAmount" min-width="100" />
        <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.verityDate, '{y}-{m}-{d}') }}</span>
          </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.totalNum }} </span>
        费用合计:<span>{{ statistical.totalCost?.toFixed(2) }} </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" />
    <student-view ref="studentViewRef" :export-data="true" />
    <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 { getExamPayments, settlePayment } 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 StudentView from '@/views/exam/level/cert/studentList'
import _ from 'lodash'

const { proxy } = getCurrentInstance()
const route = useRoute()
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,
    verityStatus: '1',
    certTimeRange: [null, null]
    // 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()
})

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


/** 查询考级信息列表 */
function getList() {
  if ((queryParams.value.certTimeRange[0] == null && queryParams.value.certTimeRange[1] != null) || (queryParams.value.certTimeRange[1] == null && queryParams.value.certTimeRange[0] != null)) return proxy.$modal.msgError('请完善审核日期')
  loading.value = true

  getExamPayments(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['studentViewRef'].open(row, '1')
}

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

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

</style>