order-ui-pc/src/views/reportQuery/purchaseReport/components/table9.vue

<template>
    <div>
      <ex-table
        v-loading="loading"
        :table="table"
        :data="tableData"
        :columns="table9"
        :page="pageInfo"
        :size="size"
        @page-curr-change="handlePageChange"
        @page-size-change="handleSizeChange"
        @screen-reset="
          pageInfo.curr = 1;
          parmValue.page = 1;
          searchList();
        "
        @screen-submit="
          pageInfo.curr = 1;
          parmValue.page = 1;
          searchList();
        "
        @selection="selection_change"
      >
        <template #table-header="{}">
          <div style="width: 100%">
            <el-row style="padding: 0 0 0 80px">
             
               <el-col :span="6" style="width: 463px;">
                <periodDatePickerActive
                      :start="parmValue.start_date"
                      :end="parmValue.end_date"
                      :placeholder="'录入供应商'"
                      :width="'205px'"
                      :size="searchSize"
                      @timeReturned="time"
                    />
              </el-col>  
              <el-col :span="4" style="width: 66px; float: right">       
                <el-button type="primary" style="margin-left:30px;" @click="download" :size="searchSize"  class="fr">
                    导出
                </el-button>
              </el-col>
              <el-col :span="3" style="width: 66px; float: right">
                <el-button
                  :size="searchSize"
                  type="primary"
                  style="float: right; margin-left: 5px"
                  @click="searchList"
                >
                  刷新
                </el-button>
              </el-col>
              
            </el-row>
            <el-row style="padding: 10px 0 0 0">
              <el-col :span="6" style="width: 463px;">
                <periodDatePickerActive
                      :start="parmValue.start_date22"
                      :end="parmValue.end_date22"
                      :placeholder="'修改供应商'"
                      :width="'205px'"
                      :size="searchSize"
                      @timeReturned="time2"
                    />
              </el-col>  
              
              <el-col :span="4" style="width: 66px; float: right">
                <el-button
                  type="warning"
                  class="fr"
                  :size="searchSize"
                  @click="restSearch"
                >
                  重置
                </el-button>
              </el-col>     
            </el-row>
          </div>
       </template>

        
      </ex-table>
    </div>

  
</template>
   <script>
import mixinPage from "@/mixins/elPaginationHandle";
import resToken from "@/mixins/resToken";
import urlConfig from "@/apis/url-config";
import asyncRequest from "@/apis/service/reportQuery/purchaseReport";
import periodDatePickerActive from "../period-date-picker/main.vue";
import { table9} from "./columns";
import { mapGetters } from "vuex";

export default {
  name: "purchaseOrder",
  mixins: [mixinPage, resToken],
  components: {
    periodDatePickerActive
  },
  computed: {
    ...mapGetters(["tablebtnSize", "searchSize", "size"]),
    
  },
  data() {
    return {
      //选中数组
      changeList: [],
      //全局url
      fileUrl: urlConfig.baseURL,
      //loading
      loading: false,
      //请求参数集合
      parmValue: {
          start_date: "", //起始时间
          end_date: "", // 结束时间
        update_start_date: "", //起始时间22
        update_end_date: "", // 结束时间22
        page: 1, // 页码
        size: 15, // 每页显示条数
       
      },
      // 表格 - 数据集合
      tableData: [],
      // 表格 - 参数
      table: {
        stripe: true,
        border: true,
        _defaultHeader_: ["setcol"],
      },
      // 表格 - 分页
      pageInfo: {
        size: 15,
        curr: 1,
        total: 0,
      },
      // 表格表头 - 列参数
      table9: table9,
    };
  },
  mounted() {

    this.searchList();
  },

  methods: {
    //初始化http请求
    async searchList() {
      if (
        (this.parmValue.start_date !== "" && this.parmValue.end_date === "") ||
        (this.parmValue.start_date === "" && this.parmValue.end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }

      if (
        (this.parmValue.update_start_date !== "" && this.parmValue.update_end_date === "") ||
        (this.parmValue.update_start_date === "" && this.parmValue.update_end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }
      // return;
      this.loading = true;
      
      const res = await asyncRequest.reportsupplierlist(this.parmValue);
      if (res && res.code === 0 && res.data) {
        this.tableData = res.data.list;
        this.pageInfo.total = Number(res.data.count);
      } else if (res && res.code >= 100 && res.code <= 104) {
        await this.logout();
      } else {
        this.tableData = [];
        this.pageInfo.total = 0;
      }
      this.loading = false;
    },
   
    //重置
    restSearch() {
      this.parmValue = {
        start_date: "", //起始时间
          end_date: "", // 结束时间
        update_start_date: "", //起始时间22
        update_end_date: "", // 结束时间22
        page: 1, // 页码
        size: 15, // 每页显示条数
      };
      // 表格 - 分页
      this.pageInfo = {
        size: 15,
        curr: 1,
        total: 0,
      };
      this.searchList();
    },
    
    // 时间函数
    async time(e) {
      this.parmValue.start_date = e.startTime || "";
      this.parmValue.end_date = e.endTime || "";
      if (
        (this.parmValue.start_date !== "" && this.parmValue.end_date === "") ||
        (this.parmValue.start_date === "" && this.parmValue.end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }
      this.pageInfo.curr = 1;
      this.parmValue.page = 1;
      await this.searchList();
    },

    async time2(e) {
      this.parmValue.update_start_date = e.startTime || "";
      this.parmValue.update_end_date = e.endTime || "";
      if (
        (this.parmValue.update_start_date !== "" && this.parmValue.update_end_date === "") ||
        (this.parmValue.update_start_date === "" && this.parmValue.update_end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }
      this.pageInfo.curr = 1;
      this.parmValue.page = 1;
      await this.searchList();
    },
     //选中触发函数
    selection_change(e) {
      const { list } = e;
      //选中的数组集合
      this.changeList = list.length > 0 ? JSON.parse(JSON.stringify(list)) : [];
    },
     //导出文件 
    async download() {
      // if(this.changeList.length<=0){
      //   this.$message.warning("请选择有效数据")
      //   return;
      // }
      if (
        (this.parmValue.start_date !== "" && this.parmValue.end_date === "") ||
        (this.parmValue.start_date === "" && this.parmValue.end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }

      if (
        (this.parmValue.update_start_date !== "" && this.parmValue.update_end_date === "") ||
        (this.parmValue.update_start_date === "" && this.parmValue.update_end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }
      
      if((this.parmValue.start_date != "" && this.parmValue.end_date != "") || (this.parmValue.update_start_date != "" && this.parmValue.update_end_date != "")){
        let start_date = new Date(this.parmValue.start_date).valueOf() || new Date(this.parmValue.update_start_date).valueOf() ;
        let end_date = new Date(this.parmValue.end_date).valueOf() || new Date(this.parmValue.update_end_date).valueOf() ;
        let start_date2 = new Date(this.parmValue.update_start_date).valueOf() ;
        let end_date2 = new Date(this.parmValue.update_end_date).valueOf() ;
        let flag = (end_date - start_date > 30 * 24 * 60 * 60 * 1000) || (end_date2 - start_date2 > 30 * 24 * 60 * 60 * 1000) ;
        if(flag){
          this.$message.warning("导出文件的时间区间不能超过30天")
          return;
        }
      }else{
        this.$message.warning("请选择至少一种导出文件的时间区间")
        return;
      }
      let model = JSON.parse(JSON.stringify(this.parmValue))
      // model.is_export = 1;
      if (!this.loading) {
        this.loading = true;
        let httpType = `aplication/zip`;
        axios({
          method: "post",
          url: this.fileUrl + "admin/reportsupplierlistexport",
          responseType: "blob",
          data: model,
          headers: {
            // 'Content-Type': 'multipart/form-data',
            // Accept: "application/vnd.ms-excel"
            Accept: httpType,
          },
        })
          .then((res) => {
            // console.log(res)
            // console.log(this.fileUrl)
            // return;
            if (res && res.status == 200 && res.data) {
              let url = window.URL.createObjectURL(
                new Blob([res.data], {
                  // type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8",
                  type: httpType
                })
              );
              let link = document.createElement("a");
              link.style.display = "none";
              link.href = url;
              let excelName = "每日录入供应商报表.zip";
              link.setAttribute("download", excelName);
              document.body.appendChild(link);
              link.click();
              link.remove();
              window.URL.revokeObjectURL(url); //释放掉blob对象
              this.$message.success(`导出成功！`);
              setTimeout(() => {
                this.loading = false;
              }, 500);
            } else {
              this.$message.error(res.data.message);
              setTimeout(() => {
                this.loading = false;
              }, 500);
            }
          })
          .catch((error) => {
            console.log(error);
            this.loading = false;
          });
      }
    },
  },
};
</script>
   <style lang="scss" scoped>
.purchaseOrder {
  // text-align: right;
}
</style>