tenant-Platform/src/views/platform/platformReport.vue

<template>
  <PageMain class="vh100">
    <el-tabs v-model="activeName" style="height: 100%" class="demo-tabs" @tab-click="handleClick">
      <el-tab-pane style="height: 100%" name="2" label="对接人结算报表">
        <el-form v-model="recordForm1" label-width="120">
          <el-row :gutter="20">
            <el-col :span="8">
              <el-form-item prop="receiver" label="对接人">
                <el-input v-model="recordForm1.receiver"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="settlementStatus" label="结算状态">
                <el-select v-model="recordForm1.settlementStatus" placeholder="请选择" clearable>
                  <el-option :value="2" label="未结清"></el-option>
                  <el-option :value="1" label="已结清"></el-option>
                </el-select>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="settlementTime" label="签单时间">
                <el-date-picker v-model="recordForm1.signingTime" type="daterange" format="YYYY-MM-DD"
                  value-format="YYYY-MM-DD" />
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="receivePaymentDate" label="回款时间">
                <el-date-picker v-model="recordForm1.receivePaymentDate" type="daterange" format="YYYY-MM-DD"
                  value-format="YYYY-MM-DD" />
              </el-form-item>
            </el-col>
            <el-col :span="24" style="height: 50px; display: flex; align-items: start; justify-content: flex-end">
              <el-button type="primary" @click="initData2()">查询</el-button>
              <el-button plain type="primary" @click="handleReset(2)">重置</el-button>
              <el-button type="primary" @click="handleExport">导出结算记录</el-button>
            </el-col>
          </el-row>
        </el-form>
        <el-table height="calc(100% - 202px)" :data="recordData1" show-summary
          :summary-method="val => getSummaries(val, ['totalReceivable', 'settledAmount', 'unSettledAmount'])">
          <el-table-column prop="receiver" label="对接人"></el-table-column>
          <el-table-column prop="totalReceivable" label="应收金额"></el-table-column>
          <el-table-column prop="settledAmount" label="已结算"></el-table-column>
          <el-table-column prop="unSettledAmount" label="未结算"></el-table-column>
          <el-table-column prop="totalPaymentDifference" label="回款差额"></el-table-column>
          <el-table-column label="操作" width="200" align="center" fixed="right">
            <template #default="scope">
              <el-dropdown placement="bottom-start" trigger="click">
                <span class="el-dropdown-link">查看明细</span>
                <template #dropdown>
                  <el-dropdown-menu>
                    <el-dropdown-item @click="handleRecordDetail(scope.row)">结算记录</el-dropdown-item>
                    <el-dropdown-item @click="receiverView(scope.row)">车险结算明细</el-dropdown-item>
                  </el-dropdown-menu>
                </template>
              </el-dropdown>
            </template>
          </el-table-column>
        </el-table>
        <div class="pagination">
          <el-pagination v-model:current-page="pages" v-model:page-size="size" :page-sizes="[10, 20, 30, 40]"
            layout="total, sizes, prev, pager, next, jumper" :total="total1" @size-change="handleSizeChange"
            @current-change="handleCurrentChange"></el-pagination>
        </div>
      </el-tab-pane>
      <el-tab-pane style="height: 100%" name="3" label="车险结算明细">
        <el-form v-model="recordForm2" label-width="120">
          <el-row :gutter="20">
            <el-col :span="8">
              <el-form-item prop="companyId" label="保险公司">
                <el-cascader filterable clearable placeholder="请选择" v-model="recordForm2.companyId"
                  :options="companyList" :props="companyIdprops" style="width: 100%;" @change="handleCompanyChange" />
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="licenseNo" label="车牌号">
                <el-input v-model="recordForm2.licenseNo"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="insurName" label="被保人">
                <el-input v-model="recordForm2.insurName"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="orderNo" label="订单号">
                <el-input v-model="recordForm2.orderNo"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="signingTime" label="签单时间">
                <el-date-picker v-model="recordForm2.signingTime" type="daterange" format="YYYY-MM-DD"
                  value-format="YYYY-MM-DD" />
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="orderStatus" label="业务状态">
                <el-select v-model="recordForm2.orderStatus">
                  <el-option value="0" label="批加"></el-option>
                  <el-option value="1" label="退保"></el-option>
                </el-select>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="contactPerson" label="对接人">
                <el-input v-model="recordForm2.contactPerson"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="jqPolicyNo" label="交强保单号">
                <el-input v-model="recordForm2.jqPolicyNo"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="syPolicyNo" label="商业险保单号">
                <el-input v-model="recordForm2.syPolicyNo"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="jyPolicyNo" label="非车险保单号">
                <el-input v-model="recordForm2.jyPolicyNo"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="8">
              <el-form-item prop="settlementId" label="结算记录编号">
                <el-input v-model="recordForm2.settlementId"></el-input>
              </el-form-item>
            </el-col>
            <el-col :span="24" style="height: 50px; display: flex; align-items: start; justify-content: flex-end">
              <el-button type="primary" @click="initData3(['1'])">查询</el-button>
              <el-button plain type="primary" @click="handleReset(3)">重置</el-button>
              <el-button type="primary" @click="handleExport1">导出明细</el-button>
            </el-col>
          </el-row>
        </el-form>
        <el-table height="calc(100% - 292px)" :data="recordData2" show-summary
          :summary-method="val => getSummaries(val, ['receivableSuperviseCosts', 'jqPremium', 'syPremium', 'jyPremium', 'taxPremium'])">
          <el-table-column prop="orderStatus" label="业务状态" width="200"></el-table-column>
          <el-table-column prop="orderNo" label="订单号" width="150"></el-table-column>
          <el-table-column prop="signingTime" label="签单时间" width="150"></el-table-column>
          <el-table-column prop="companyName" label="保险公司" width="200"></el-table-column>
          <el-table-column prop="partnerCompanyName" label="保险机构" width="200"></el-table-column>
          <el-table-column prop="contactPerson" label="对接人" width="150"></el-table-column>
          <el-table-column prop="licenseNo" label="车牌号" width="150"></el-table-column>
          <el-table-column prop="insurName" label="被保人" width="150"></el-table-column>
          <el-table-column prop="productName" label="投保险种" width="150"></el-table-column>
          <el-table-column prop="receivableSuperviseCosts" label="应收金额" width="150"></el-table-column>
          <el-table-column prop="jqPolicyNo" label="交强险保单号" width="150"></el-table-column>
          <el-table-column prop="syPolicyNo" label="商业险保单号" width="150"></el-table-column>
          <el-table-column prop="jyPolicyNo" label="非车险保单号" width="150"></el-table-column>
          <el-table-column prop="jqPremium" label="交强险保费" width="150"></el-table-column>
          <el-table-column prop="taxPremium" label="车船税" width="150"></el-table-column>
          <el-table-column prop="syPremium" label="商业险保费" width="150"></el-table-column>
          <el-table-column prop="jyPremium" label="非车险保费" width="150"></el-table-column>
          <el-table-column prop="jqInlet" label="交强险应收比例" width="150"></el-table-column>
          <el-table-column prop="jqSuperviseCostsProportion" label="交强险手续费比例" width="150"></el-table-column>
          <el-table-column prop="jqOtherCostsProportion" label="交强险跟单费比例" width="150"></el-table-column>
          <el-table-column prop="syInlet" label="商业险应收比例" width="150"></el-table-column>
          <el-table-column prop="sySuperviseCostsProportion" label="商业险手续费比例" width="150"></el-table-column>
          <el-table-column prop="syOtherCostsProportion" label="商业险跟单费比例" width="150"></el-table-column>
          <el-table-column prop="jyInlet" label="非车险应收比例" width="150"></el-table-column>
          <el-table-column prop="jySuperviseCostsProportion" label="非车险手续费比例" width="150"></el-table-column>
          <el-table-column prop="jyOtherCostsProportion" label="非车险跟单费比例" width="150"></el-table-column>
          <el-table-column prop="settlementId" label="结算记录编号" width="200"></el-table-column>
          <el-table-column prop="settlementPerson" label="结算人" width="150"></el-table-column>
          <el-table-column prop="receivePaymentDate" label="回款时间" width="150"></el-table-column>
        </el-table>
        <div class="pagination">
          <el-pagination v-model:current-page="pages" v-model:page-size="size" :page-sizes="[10, 20, 30, 40]"
            layout="total, sizes, prev, pager, next, jumper" :total="total2" @size-change="handleSizeChange"
            @current-change="handleCurrentChange"></el-pagination>
        </div>
      </el-tab-pane>
    </el-tabs>
  </PageMain>
</template>

<script setup lang="ts">
import api from '@/api'
import { useRoute, useRouter } from 'vue-router';
const route = useRoute();
const router = useRouter();
// 结算记录
let recordForm = ref({})
let recordForm1 = ref({
  settlementStatus: '',
})
let recordForm2 = ref({})
let recordData = ref([])
let recordData1 = ref([])
let recordData2 = ref([])
let activeName = ref('3')
const handleClick = (e) => {
  pages.value = 1
  size.value = 10
  switch (e.props.name) {
    case '1':
      initData1()
      break;
    case '2':
      initData2()
      break;
    case '3':
      initData3()
      break;
  }
}
const companyIdprops = {
  expandTrigger: 'hover' as const,
  value: 'id',
  label: 'name',
  checkStrictly: true,
}
const handleCompanyChange = (e: any) => {
  recordForm2.value.companyId = e[e.length - 1] || ''
}
// 保险公司
let companyList = ref([])
const initCompany = () => {
  api.agreementApi.findTree({ name: "", systemCode: localStorage.getItem('login_system') }).then((res: any) => {
    if (res.code == 200) {
      companyList.value = res.data
    }
  })
}

// 分页
let pages = ref(1)
let size = ref(10)
let total = ref(0)
let total1 = ref(0)
let total2 = ref(0)
const handleSizeChange = (size) => {
  size.value = size
}
const handleCurrentChange = (page) => {
  pages.value = page
}

const getSummaries = (param, list) => {
  console.log(param)
  const { columns, data } = param
  const sums: (string | VNode)[] = []
  // 指定需要计算的字段列表（可根据需求添加字段名）
  const specifiedFields = list || [] // 替换为您需要的字段名

  columns.forEach((column, index) => {
    if (index === 0) {
      sums[index] = h('div', { style: { textDecoration: 'underline' } }, [
        '',
      ])
      return
    }
    // 计算数字类型字段和指定字段
    const values = data.map((item) => {
      const val = item[column.property]
      // 排除空值
      if (val === '' || val === null || val === undefined) {
        return NaN
      }
      // 如果是数字类型，直接参与计算
      if (typeof val === 'number') {
        return val
      }
      // 如果字段在指定列表中，尝试转换为数字
      if (specifiedFields.includes(column.property)) {
        const num = Number(val)
        return Number.isNaN(num) ? NaN : num
      }
      // 其他情况不参与计算
      return NaN
    })
    if (!values.every((value) => Number.isNaN(value))) {
      const total = values.reduce((prev, curr) => {
        if (!Number.isNaN(curr)) {
          return prev + curr
        } else {
          return prev
        }
      }, 0)
      // 保留五位小数
      sums[index] = ` ${total.toFixed(5)}`
    } else {
      sums[index] = '-'
    }
  })
  return sums
}

const initData1 = () => {
  api.settlementApi.platformCompanySuperviseSettlementReport({
    companyId: recordForm.value.companyId,
    startTime: recordForm.value.time?.[0],
    endTime: recordForm.value.time?.[1],
    settlementStartTime: recordForm.value.settlementTime?.[0],
    settlementEndTime: recordForm.value.settlementTime?.[1],
    status: recordForm.value.status,
    contactPerson: recordForm.value.contactPerson,
    contactPersonPhone: recordForm.value.contactPersonPhone,
    agreementType: '1'
  }).then((res: any) => {
    if (res.code == 200) {
      recordData.value = res.data
    }
  })
}
const initData2 = () => {
  api.settlementApi.receiverSettlementReport({
    ...recordForm1.value,
    signingStartTime: recordForm1.value.signingTime?.[0],
    signingEndTime: recordForm1.value.signingTime?.[1],
    receivePaymentDateBegin: recordForm1.value.receivePaymentDate?.[0],
    receivePaymentDateEnd: recordForm1.value.receivePaymentDate?.[1],
    pages: pages.value,
    size: size.value,
    invoiceTypes: ['5', '6']
  }).then((res: any) => {
    if (res.code == 200) {
      recordData1.value = res.data.records
      total1.value = res.data.total
    }
  })
}
const initData3 = () => {
  api.settlementApi.superviseSettlementDetailExcel({
    ...recordForm2.value,
    signingStartTime: recordForm2.value.signingTime?.[0],
    signingEndTime: recordForm2.value.signingTime?.[1],
    pages: pages.value,
    size: size.value,
    status: recordForm2.value.status,
    invoiceTypes: ['5', '6'],
    agreementType: '1'
  }).then((res: any) => {
    if (res.code == 200) {
      recordData2.value = res.data.records
      total2.value = res.data.total
    }
  })
}


const handleRecordDetail = (row) => {
  router.push({
    path: '/platform/platformRecord',
    query: {
      contactPerson: row.receiver
    }
  })
}

const handleReset = (type) => {

}
const handleExport = () => {
  api.settlementApi.exportReceiverSettlementReportExcel({

  }).then((res: any) => {
    const blob = new Blob([res], { type: 'application/vnd.ms-excel' });
    const fileName = '平台对接人结算报表' + new Date().getTime() + '.xlsx';
    if ('download' in document.createElement('a')) {
      const elink = document.createElement('a');
      elink.download = fileName;
      elink.style.display = 'none';
      elink.href = URL.createObjectURL(blob);
      document.body.appendChild(elink);
      elink.click();
      URL.revokeObjectURL(elink.href);
      document.body.removeChild(elink);
    } else {
      navigator.msSaveBlob(blob, fileName);
    }
  })
}
const handleExport1 = () => {
  api.financeApi.exportSuperviseExcel({
    agreementType: '1'
  }).then((res: any) => {
    const blob = new Blob([res], { type: 'application/vnd.ms-excel' });
    const fileName = '平台协议应收明细' + new Date().getTime() + '.xlsx';
    if ('download' in document.createElement('a')) {
      const elink = document.createElement('a');
      elink.download = fileName;
      elink.style.display = 'none';
      elink.href = URL.createObjectURL(blob);
      document.body.appendChild(elink);
      elink.click();
      URL.revokeObjectURL(elink.href);
      document.body.removeChild(elink);
    } else {
      navigator.msSaveBlob(blob, fileName);
    }
  })
}

const optionObj = ref({})
const initOption = () => {
  let list = ['settlement_status']
  list.forEach(item => {
    api.additionalApi.dictDetails(item).then((res: any) => {
      if (res.code == 200) {
        if (res.data) {
          optionObj.value[item] = res.data
        }
      }
    })
  })
}
const receiverView = (row) => {
  recordForm2.value.contactPerson = row.receiver
  activeName.value = '3'
  initData3()
}
const handleSettlementDetail = (row) => {
  activeName.value = '3'
  recordForm2.value.companyId = row.companyId
  initData3()
}
onMounted(() => {
  if (route.query.activeName === '3') {
    recordForm2.value.settlementId = route.query.settlementId
    activeName.value = '3'
    initData3();
  } else {
    initData2();
  }
  initCompany();
  initOption();
})

</script>

<style scoped lang="scss">
.pagination {
  margin-top: 10px;
  display: flex;
  justify-content: flex-end;
}

:deep(.el-dropdown-link) {
  display: flex;
  align-items: center;
  margin-left: 15px;
  color: var(--el-color-primary);
  cursor: pointer;
}

:deep(.subTable .el-table__header-wrapper) {
  display: none;
}
</style>