order-ui-pc/src/views/reportQuery/saleReport/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: 363px;">
                <periodDatePickerActive
                      :start="parmValue.start_date"
                      :end="parmValue.end_date"
                      :placeholder="'咨询'"
                      :width="'165px'"
                      :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: 150px">
                

                <el-select
                  :size="searchSize"
                  v-model="parmValue.status"
                  filterable
                  clearable
                  placeholder="处理状态"
                  style="width: 100%"
                  @change="
                    pageInfo.curr = 1;
                    parmValue.page = 1;
                    searchList();
                  "
                >
                    <el-option label="待发货" value="0"></el-option>
                    <el-option label="待发货完成" value="1"></el-option>
                    <el-option label="发货已完成" value="2"></el-option>
                    <el-option label="订单已取消" value="3"></el-option>
                </el-select>
              </el-col>
              <!-- 销售方公司 -->
              <el-col :span="4" style="width: 240px; padding: 0 0 0 10px">
                <search-work-company
                  :type="'1'"
                  :value="parmValue.company"
                  :size="'mini'"
                  :placeholder="'销售方公司'"
                  :disabled="false"
                  :isDetail="false"
                  @searchChange="supplierChange"
                />
              </el-col>
               <el-col :span="4" style="width: 170px; padding: 0 0 0 10px">
                  <el-input
                    placeholder="申请人部门"
                    v-model="parmValue.create_company"
                    :size="searchSize"
                    maxlength="100"
                    @blur="
                      pageInfo.curr = 1;
                      parmValue.page = 1;
                      searchList();
                    "
                  >
                  </el-input>
                </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/saleReport";
import periodDatePickerActive from "../period-date-picker/main.vue";
import { table9} from "./columns";
import { mapGetters } from "vuex";

export default {
  name: "saleReport",
  mixins: [mixinPage, resToken],
  components: {
    periodDatePickerActive
  },
  computed: {
    ...mapGetters(["tablebtnSize", "searchSize", "size"]),
    
  },
  data() {
    return {
      //选中数组
      changeList: [],
      //全局url
      fileUrl: urlConfig.baseURL,
      //loading
      loading: false,
      //请求参数集合
      parmValue: {
        status:"", //处理状态
        create_company:"",//部门
        company:"",//销售方公司
        start_date: "", //起始时间
        end_date: "", // 结束时间
        // is_export:0,//是否导出0/1
        page: 1, // 页码
        size: 15, // 每页显示条数
       
      },
      // 表格 - 数据集合
      tableData: [],
      // 表格 - 参数
      table: {
        stripe: true,
        border: true,
        _defaultHeader_: ["setcol"],
      },
      // 表格 - 分页
      pageInfo: {
        size: 15,
        curr: 1,
        total: 0,
      },
      // 表格表头 - 列参数
      table9: table9,
    };
  },
  mounted() {
    // alert("未采反信息：接口暂无数据，以此提示")
    this.searchList();
  },

  methods: {
    async supplierChange(e) {
      const { id, code, label } = e;
      this.parmValue.company = code || "";
      this.parmValue.page = 1;
      this.pageInfo.curr = 1;
      await this.searchList();
    },
    //初始化http请求
    async searchList() {
      if (
        (this.parmValue.start_date !== "" && this.parmValue.end_date === "") ||
        (this.parmValue.start_date === "" && this.parmValue.end_date !== "")
      ) {
        this.$message.warning("时间区间不完整！");
        return;
      }
      // return;
      this.loading = true;
      
      const res = await asyncRequest.saleexportsaledetailed(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.$message.warning(res.message)
        this.tableData = [];
        this.pageInfo.total = 0;
      }
      this.loading = false;
    },
   
    //重置
    restSearch() {
      this.parmValue = {
        status:"", //处理状态
        start_date: "", //新建起始时间
        end_date: "", // 新建结束时间
        create_company:"",//部门
        company:"",//销售方公司
        page: 1, // 页码
        size: 15, // 每页显示条数
        // is_export:0//是否导出0/1
      };
      // 表格 - 分页
      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();
    },

     //选中触发函数
    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;
      // }
      let start_date = new Date(this.parmValue.start_date).valueOf();
      let end_date = new Date(this.parmValue.end_date).valueOf();
      let flag = end_date - start_date > 30 * 24 * 60 * 60 * 1000;
      if(this.parmValue.start_date != "" && this.parmValue.end_date != ""){
        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/saleexportsaledetailedexport",
          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>