人力资源-添加导出功能

gaoluyang

5 天以前 af4f913751c08fd6ef70cb183de2fb3c604bab38

 src/views/salesManagement/receiptPaymentHistory/index.vue

@@ -10,10 +10,10 @@
          :prefix-icon="Search"
        />
      </el-form-item>
      <el-form-item label="合同号">
      <el-form-item label="客户合同号">
        <el-input
          v-model="searchForm.customerContractNo"
          placeholder="输入合同号"
          placeholder="输入客户合同号"
          @change="handleQuery"
          clearable
          :prefix-icon="Search"
@@ -44,27 +44,29 @@
      </el-form-item>
      <el-form-item>
        <el-button type="primary" @click="handleQuery"> 搜索 </el-button>
        <el-button @click="handleExport">导出</el-button>
      </el-form-item>
    </el-form>
    <div class="table_list">
      <PIMTable
        rowKey="id"
        :column="tableColumn"
        :tableData="tableData"
        :page="page"
        :isSelection="true"
        :isShowSummary="isShowSummarySon"
        :summaryMethod="summarizeMainTable1"
        :handleSelectionChange="handleSelectionChange"
        :tableLoading="tableLoading"
        :total="page.total"
        @pagination="pagination"
        :total="total"
        @selection-change="handleSelectionChange"
      ></PIMTable>
    </div>
  </div>
</template>

<script setup>
import { ref } from "vue";
import { ref, reactive, getCurrentInstance } from "vue";
import { Search } from "@element-plus/icons-vue";
import { receiptPaymentHistoryListPage } from "@/api/salesManagement/receiptPayment.js";
import useFormData from "@/hooks/useFormData";
@@ -73,30 +75,36 @@
const { proxy } = getCurrentInstance();
const tableColumn = ref([
  {
    label: "销售合同号",
    prop: "salesContractNo",
    width:240
  },
  {
    label: "客户合同号",
    prop: "customerContractNo",
    width:240
  },
  {
    label: "回款日期",
    prop: "receiptPaymentDate",
    width:100
  },
  {
    label: "客户名称",
    prop: "customerName",
    width:240
  },
  {
    label: "项目名称",
    prop: "projectName",
  },
  {
    label: "合同号",
    prop: "customerContractNo",
  },
  {
    label: "项目名称",
    prop: "projectName",
    width:200
  },
  {
    label: "回款金额（元）",
    prop: "receiptPaymentAmount",
    width:200,
    formatData: (params) => {
      return parseFloat(params).toFixed(2);
      return params ? parseFloat(params).toFixed(2) : 0;
    },
  },
  {
@@ -123,6 +131,7 @@
  {
    label: "登记日期",
    prop: "createTime",
    width:100
  },
]);
const tableData = ref([]);
@@ -131,19 +140,15 @@
const page = reactive({
  current: 1,
  size: 100,
   total: 0,
});
const total = ref(0);

const { form: searchForm } = useFormData({
  searchText: undefined,
  receiptPaymentDate: [
    dayjs().startOf("month").format("YYYY-MM-DD"),
    dayjs().endOf("month").format("YYYY-MM-DD"),
  ],
  receiptPaymentDateStart: dayjs()
    .startOf("month")
    .format("YYYY-MM-DD 00:00:00"),
  receiptPaymentDateEnd: dayjs().endOf("month").format("YYYY-MM-DD 23:59:59"),
  receiptPaymentDate: [],
  receiptPaymentDateStart: undefined,
  receiptPaymentDateEnd: undefined,
  customerContractNo: undefined,
  projectName: undefined,
});
@@ -166,7 +171,7 @@
  receiptPaymentHistoryListPage({ ...rest, ...page }).then((res) => {
    tableLoading.value = false;
    tableData.value = res.records;
    total.value = res.total;
      page.total = res.total;
  });
};
// 子表合计方法
@@ -200,6 +205,12 @@
  getList();
};

// 导出
const handleExport = () => {
  const { receiptPaymentDate, ...rest } = searchForm;
  proxy.download("/receiptPayment/exportOne", { ...rest, ...page }, "回款流水.xlsx");
};

onMounted(() => {
  getList();
});