营销管理-添加导出功能

gaoluyang

5 天以前 4f6275648bb8da724825c0e6c580c83aaa1cb9bf

 src/views/salesManagement/receiptPaymentHistory/index.vue

@@ -44,6 +44,7 @@
      </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">
@@ -56,7 +57,7 @@
        :isShowSummary="isShowSummarySon"
        :summaryMethod="summarizeMainTable1"
        :tableLoading="tableLoading"
        :total="total"
        :total="page.total"
        @pagination="pagination"
        @selection-change="handleSelectionChange"
      ></PIMTable>
@@ -65,7 +66,7 @@
</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";
@@ -101,7 +102,7 @@
  {
    label: "回款金额（元）",
    prop: "receiptPaymentAmount",
    width:150,
    width:200,
    formatData: (params) => {
      return params ? parseFloat(params).toFixed(2) : 0;
    },
@@ -139,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,
});
@@ -174,7 +171,7 @@
  receiptPaymentHistoryListPage({ ...rest, ...page }).then((res) => {
    tableLoading.value = false;
    tableData.value = res.records;
    total.value = res.total;
      page.total = res.total;
  });
};
// 子表合计方法
@@ -208,6 +205,12 @@
  getList();
};

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

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