order-ui-pc/src/views/dataReport/table3.vue

<template>
  <div style="padding:10px">
    <ex-table
      v-if="powers.some((i) => i == '001')"
      v-loading="loading"
      :table="table"
      :data="tableData"
      :columns="table3"
      :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_day"
                :end="parmValue.end_day"
                :placeholder="'竞价'"
                :width="'165px'"
                :size="searchSize"
                @timeReturned="time"
              />
            </el-col>

            <el-col :span="6">
              <search-work-company
                :value="parmValue.companyNo"
                :placeholder="'业务公司名称'"
                :disabled="false"
                :size="'mini'"
                :no-disabled="true"
                @searchChange="company_idsearchChange"
              />
            </el-col>

            <el-col :span="4" style="width: 66px; float: right">
              <el-button type="primary" style="margin-left:30px;" :size="searchSize" class="fr" @click="download">
                导出
              </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-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 v-else>
      <no-auth></no-auth>
    </div>
  </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/newReport'
import periodDatePickerActive from './period-date-picker/main.vue'
import { table3 } from './columns'
import { mapGetters } from 'vuex'
import dayjs from 'dayjs'

export default {
  name: 'SaleReport',
  components: {
    periodDatePickerActive
  },
  mixins: [mixinPage, resToken],
  computed: {
    ...mapGetters(['tablebtnSize', 'searchSize', 'size']),
    powers() {
      const tran =
        this.$store.getters.btnList.find((i) => i.menu_route == "reportTableThree") || {};
      const { action } = tran ?? {};
      return action ?? [];
    }
  },
  data() {
    return {
    // 选中数组
      changeList: [],
      // 全局url
      fileUrl: urlConfig.baseURL,
      // loading
      loading: false,
      // 请求参数集合
      parmValue: {
        companyNo: '',
        start_day: '', // 起始时间
        end_day: '', // 结束时间
        // is_export:0,//是否导出0/1

        page: 1, // 页码
        size: 15 // 每页显示条数

      },
      // 表格 - 数据集合
      tableData: [],
      // 表格 - 参数
      table: {
        stripe: true,
        border: true,
        _defaultHeader_: ['setcol']
      },
      // 表格 - 分页
      pageInfo: {
        size: 15,
        curr: 1,
        total: 0
      },
      // 表格表头 - 列参数
      table3: table3
    }
  },
  mounted() {
    this.parmValue.start_day = dayjs().subtract(0, 'day').format('YYYY-MM-DD')
    this.parmValue.end_day = dayjs().subtract(-1, 'day').format('YYYY-MM-DD')
    this.searchList()
  },

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

      const start_day = new Date(this.parmValue.start_day).valueOf()
      const end_day = new Date(this.parmValue.end_day).valueOf()
      const flag = end_day - start_day > 31 * 24 * 60 * 60 * 1000

      if (this.parmValue.start_day != '' && this.parmValue.end_day != '') {
        if (flag) {
          this.$message.warning('筛选的时间区间不能超过31天')
          return
        }
      }

      this.loading = true

      const res = await asyncRequest.salestock(this.parmValue)
      if (res && res.code === 0 && res.data) {
        this.tableData = res.data.list

        console.log(this.tableData)
        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
    },

    company_idsearchChange(e) {
      const { code } = e
      this.parmValue.companyNo = code || ''
      this.searchList()
    },

    // 重置
    restSearch() {
      this.parmValue = {
        companyNo: '',
        start_day: '', // 新建起始时间
        end_day: '', // 新建结束时间
        // is_export:0,//是否导出0/1
        page: 1, // 页码
        size: 15 // 每页显示条数
      }
      this.parmValue.start_day = dayjs().subtract(0, 'day').format('YYYY-MM-DD')
      this.parmValue.end_day = dayjs().subtract(-1, 'day').format('YYYY-MM-DD')
      // 表格 - 分页
      this.pageInfo = {
        size: 15,
        curr: 1,
        total: 0
      }
      this.searchList()
    },

    // 时间函数
    async time(e) {
      this.parmValue.start_day = e.startTime || ''
      this.parmValue.end_day = e.endTime || ''
      if (
        (this.parmValue.start_day !== '' && this.parmValue.end_day === '') ||
      (this.parmValue.start_day === '' && this.parmValue.end_day !== '')
      ) {
        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;
    // }
      const model = JSON.parse(JSON.stringify(this.parmValue))
      delete model['page']
      delete model['size']
      // model.is_export = 1;
      const start_day = new Date(this.parmValue.start_day).valueOf()
      const end_day = new Date(this.parmValue.end_day).valueOf()
      const flag = end_day - start_day > 31 * 24 * 60 * 60 * 1000
      if (this.parmValue.start_day != '' && this.parmValue.end_day != '') {
        if (flag) {
          this.$message.warning('导出文件的时间区间不能超过31天')
          return
        }
      } else {
        this.$message.warning('请选择导出文件的时间区间')
        return
      }
      if (!this.loading) {
        this.loading = true
        const httpType = `aplication/zip`
        axios({
          method: 'post',
          url: this.fileUrl + 'admin/sse',
          responseType: 'blob',
          data: model,
          headers: {
            Accept: httpType
          }
        })
          .then((res) => {
            if (res && res.status == 200 && res.data) {
              const url = window.URL.createObjectURL(
                new Blob([res.data], {
                  type: httpType
                })
              )
              const link = document.createElement('a')
              link.style.display = 'none'
              link.href = url
              const 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>