TblSalaryCalculationList.vue 11.4 KB
<template>
  <a-card :bordered="false">
    <!-- 查询区域 -->
    <div class="table-page-search-wrapper">
      <a-form layout="inline" @keyup.enter.native="searchQuery">
        <a-row :gutter="24">
          <a-col :xl="6" :lg="7" :md="8" :sm="24">
            <a-form-item label="姓名">
              <j-input placeholder="请输入姓名" v-model="queryParam.userName"></j-input>
            </a-form-item>
          </a-col>
          <a-col :span="12">
            <a-form-item label="工资月份">
              <a-month-picker
                v-model="queryParam.salarymonth"
                placeholder="请选择工资月份"
                format="YYYY-MM"
                @change="handleMonthChange"
              />
            </a-form-item>
          </a-col>
          <a-col :xl="6" :lg="7" :md="8" :sm="24">
            <span style="float: right; overflow: hidden" class="table-page-search-submitButtons">
              <a-button type="primary" @click="searchQuery" icon="search">查询</a-button>
              <a-button type="primary" @click="searchReset" icon="reload" style="margin-left: 8px">重置</a-button>
            </span>
          </a-col>
        </a-row>
      </a-form>
    </div>
    <!-- 查询区域-END -->

    <!-- 操作按钮区域 -->
    <div class="table-operator">
      <!-- <a-button @click="handleAdd" type="primary" icon="plus">新增</a-button> -->
      <!-- <a-button @click="handleAddUser" type="primary" icon="plus">新增用户</a-button> -->
      <a-button type="primary" icon="download" @click="handleExportXls('工资信息')">导出</a-button>
      <a-upload
        name="file"
        :showUploadList="false"
        :multiple="false"
        :headers="tokenHeader"
        :action="importExcelUrl"
        @change="handleImportExcel"
      >
        <a-button type="primary" icon="import">导入</a-button>
      </a-upload>
      <!-- 高级查询区域 -->
      <j-super-query
        :fieldList="superFieldList"
        ref="superQueryModal"
        @handleSuperQuery="handleSuperQuery"
      ></j-super-query>
      <a-button type="primary" @click="selectup(salaryMonth)" icon="search">计算</a-button>
      <a-button type="primary" @click="downloadFile2('工资导入.xlsx')" download="工资导入.xlsx">导入模板下载</a-button>
      <!--
      <a href="https://feite-1300636907.cos.ap-chongqing.myqcloud.com/工资导入.xlsx" download="工资导入.xlsx"
        >下载工资导入文件</a
      >
      -->
      <a-dropdown v-if="selectedRowKeys.length > 0">
        <a-menu slot="overlay">
          <a-menu-item key="1" @click="batchDel"><a-icon type="delete" />删除</a-menu-item>
        </a-menu>
        <a-button style="margin-left: 8px"> 批量操作 <a-icon type="down" /></a-button>
      </a-dropdown>
    </div>
    <!-- https://feite-1300636907.cos.ap-chongqing.myqcloud.com/工资导入.xlsx -->
    <!-- http://factory.zgftlm.com/mnt/docker/app/factory/工资导入.xlsx -->
    <!-- table区域-begin -->
    <div>
      <div class="ant-alert ant-alert-info" style="margin-bottom: 16px">
        <i class="anticon anticon-info-circle ant-alert-icon"></i> 已选择
        <a style="font-weight: 600">{{ selectedRowKeys.length }}</a
        >项
        <a style="margin-left: 24px" @click="onClearSelected">清空</a>
      </div>

      <a-table
        ref="table"
        size="middle"
        :scroll="{ x: true }"
        bordered
        rowKey="id"
        :columns="columns"
        :dataSource="dataSource"
        :pagination="ipagination"
        :loading="loading"
        :rowSelection="{ selectedRowKeys: selectedRowKeys, onChange: onSelectChange }"
        class="j-table-force-nowrap"
        @change="handleTableChange"
      >
        <span slot="action" slot-scope="text, record">
          <!-- <a @click="handleEdit(record)">编辑</a> -->

          <!-- <a-divider type="vertical" /> -->
          <a-dropdown>
            <a class="ant-dropdown-link">更多<a-icon type="down" /></a>
            <a-menu slot="overlay">
              <!-- <a-menu-item>
                <a @click="handleDetail(record)">详情</a>
              </a-menu-item> -->
              <a-menu-item>
                <a-popconfirm title="确定删除吗?" @confirm="() => handleDelete(record.id)">
                  <a>删除</a>
                </a-popconfirm>
              </a-menu-item>
            </a-menu>
          </a-dropdown>
        </span>
      </a-table>
    </div>

    <tbl-salary-calculation-modal ref="modalForm" @ok="modalFormOk"></tbl-salary-calculation-modal>

    <tbl-salary-calculation-modal-tan ref="tanForm" @ok="modalFormOk"></tbl-salary-calculation-modal-tan>
  </a-card>
</template>
  
<script>
import '@/assets/less/TableExpand.less'
import { mixinDevice } from '@/utils/mixin'
import { JeecgListMixin } from '@/mixins/JeecgListMixin'
import TblSalaryCalculationModal from './modules/TblSalaryCalculationModal'
import TblSalaryCalculationBase from './TblSalaryCalculationBase'
import TblSalaryCalculationModalTan from './modules/TblSalaryCalculationModalTan'
import Vue from 'vue'
import { ACCESS_TOKEN } from '@/store/mutation-types'
import Axios from 'axios'
// import TblSalaryCalculationModalTan from './modules/TblSalaryCalculationModalTan.vue'
export default {
  name: 'TblSalaryCalculationList',
  mixins: [JeecgListMixin, mixinDevice],
  components: {
    TblSalaryCalculationModal,
    TblSalaryCalculationBase,
    TblSalaryCalculationModalTan,
  },
  data() {
    return {
      modalFormUserOk: false,
      salaryMonth: '',
      description: 'tbl_salary_calculation管理页面',
      // 表头
      columns: [
        {
          title: '序号',
          dataIndex: 'xuhao',
          fixed: 'left',
          key: 'xuhao',
          width: 60,
          align: 'center',
          customRender: function (t, r, index) {
            return parseInt(index) + 1
          },
        },
        {
          title: '月份',
          align: 'center',
          dataIndex: 'salaryMonth',
          fixed: 'left',
          width: 100,
          customRender: function (text) {
            return !text ? '' : text.length > 10 ? text.substr(0, 10) : text
          },
        },
        {
          title: '工号',
          align: 'center',
          dataIndex: 'jobId',
          fixed: 'left',
          width: 100,
        },
        {
          title: '姓名',
          align: 'center',
          dataIndex: 'userName',
          key: 'userName',
        },
        {
          title: '身份证号',
          align: 'center',
          dataIndex: 'idCard',
        },
        {
          title: '银行卡号',
          align: 'center',
          dataIndex: 'bankCard',
        },
        {
          title: '手机号',
          align: 'center',
          dataIndex: 'phone',
        },
        {
          title: '基本工资',
          align: 'center',
          dataIndex: 'basicSalary',
        },

        {
          title: '绩效工资',
          align: 'center',
          dataIndex: 'meritPay',
        },
        {
          title: '应发工资',
          align: 'center',
          dataIndex: 'salariesPayable',
        },
        {
          title: '社保个人',
          align: 'center',
          dataIndex: 'socialPerson',
        },
        {
          title: '个税',
          align: 'center',
          dataIndex: 'personalTax',
        },

        {
          title: '实发工资',
          align: 'center',
          fixed: 'right',
          dataIndex: 'netSalary',
          width: 140,
        },
        {
          title: '操作',
          dataIndex: 'action',
          align: 'center',
          fixed: 'right',
          width: 147,
          scopedSlots: { customRender: 'action' },
        },
      ],
      // 每一列的插槽名 - 表格行内编辑用
      customRenderList: ['day'],
      // 用来匹配插槽中显示input框
      inputScopedSlots: ['day'],
      url: {
        list: '/salary/calculation/list',
        delete: '/salary/calculation/delete',
        deleteBatch: '/salary/calculation/deleteBatch',
        exportXlsUrl: '/salary/calculation/exportXls',
        importExcelUrl: '/salary/calculation/importExcel',
        downloadLocal: '/salary/calculation/downloadLocal',
      },
      dictOptions: {},
      superFieldList: [],
    }
  },
  created() {
    this.getSuperFieldList()
  },
  computed: {
    importExcelUrl: function () {
      return `${window._CONFIG['domianURL']}${this.url.importExcelUrl}`
    },
  },
  methods: {
    async downloadFile2(filePath) {
      try {
        if (!filePath) {
          throw new Error('File path is empty.')
        }
        let token = Vue.ls.get(ACCESS_TOKEN)
        // console.log(token)
        // 发起文件下载请求
        const response = await fetch(Vue.prototype.API_BASE_URL + `/salary/calculation/download/${filePath}`, {
          method: 'GET',
          mode: 'cors',
          headers: {
            'Access-Control-Expose-Headers': 'Content-Disposition',
            'X-Access-Token': `${token}`, // 添加身份验证信息
          },
          credentials: 'include', // 允许发送 Cookie
        })
        if (!response.ok) {
          throw new Error(`HTTP error! status: ${response.status}`)
        }
        const blob = await response.blob()
        const filename = filePath.split('/').pop() // 提取文件名

        // 创建临时链接
        const url = window.URL.createObjectURL(blob)
        const link = document.createElement('a')
        link.href = url
        link.setAttribute('download', filename)
        document.body.appendChild(link)
        link.click()

        // 释放对象 URL
        window.URL.revokeObjectURL(url)
        document.body.removeChild(link)
      } catch (error) {
        console.error('Failed to download file:', error)
      }
    },

    // handleAddUser(){
    //   this.$refs.modalFormUser.add();
    //   this.$refs.modalFormUser.title = "新增";
    //   this.$refs.modalFormUser.disableSubmit = false;
    // },
    handleMonthChange(value) {
      this.queryParam.salaryMonth = value ? value.format('YYYY-MM') : null
    },

    initDictConfig() {},
    getSuperFieldList() {
      let fieldList = []
      fieldList.push({ type: 'string', value: 'salarymonth', text: '月份' })
      fieldList.push({ type: 'string', value: 'userName', text: '姓名' })
      // fieldList.push({ type: 'string', value: 'idcard', text: '身份证号' })
      fieldList.push({ type: 'string', value: 'basicsalary', text: '基本工资' })
      fieldList.push({ type: 'string', value: 'day', text: '天数' })
      fieldList.push({ type: 'string', value: 'meritpay', text: '绩效工资' })
      fieldList.push({ type: 'string', value: 'totalwages', text: '总工资' })
      fieldList.push({ type: 'string', value: 'mealallowance', text: '餐费补助' })
      fieldList.push({ type: 'string', value: 'fullattendanceaward', text: '全勤奖' })
      fieldList.push({ type: 'string', value: 'socialcompany', text: '社保公司' })
      fieldList.push({ type: 'string', value: 'socialperson', text: '社保个人' })
      fieldList.push({ type: 'string', value: 'deduction', text: '减项' })
      fieldList.push({ type: 'string', value: 'supplementary', text: '补项' })
      fieldList.push({ type: 'string', value: 'salariespayable', text: '应发工资' })
      fieldList.push({ type: 'string', value: 'personaltax', text: '个税' })
      fieldList.push({ type: 'string', value: 'netsalary', text: '实发工资' })
      this.superFieldList = fieldList
    },
  },
}
</script>
<style scoped>
@import '~@assets/less/common.less';
</style>