zrlibs
2025-03-21 cd24c776d772c7ad797891afd779b3b072293ec2
src/views/examples/report.vue
@@ -1,141 +1,20 @@
<template>
  <div class="example-report-view" ref="refView">
    <div class="search-form">
      <Form :model="form" :label-width="110">
        <Row>
          <Col span="6">
            <FormItem label="供应商编码:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="供应商名称:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="ASN单号:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="存货:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
        </Row>
        <Row>
          <Col span="6">
            <FormItem label="代购订单号:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="12">
            <FormItem label="订单交期:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="状态:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
        </Row>
        <Row>
          <Col span="6">
            <FormItem label="采购员:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="采购类型:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="单据类型:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="关闭状态:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
        </Row>
        <Row>
          <Col span="6">
            <FormItem label="是否到货完成:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
          <Col span="6">
            <FormItem label="ASN创建日期:">
              <Input
                v-model="form.WH_Code"
                placeholder="Enter something..."
                size="small"
              ></Input>
            </FormItem>
          </Col>
        </Row>
      </Form>
    </div>
    <div class="buttons">
      <Button type="success" size="small" @click="onExportClick">导出</Button>
    </div>
    <DataTable
      :tableHeight="tableHeight"
      :height="height"
      :formObject="formObject"
      :buttons="buttons"
      :columns="columns"
      :data="data"
      :page="page"
      :limit="limit"
      :limits="limits"
      :total="total"
      :loading="loading"
      @on-change="onPageChange"
      @on-page-size-change="onPageSizeChange"
      @on-prev="onPrev"
      @on-next="onNext"
    ></DataTable>
  </div>
</template>
@@ -143,6 +22,7 @@
<script>
import { ref } from "vue";
import DataTable from "@/components/examples/data-table.vue";
import { exportExcel } from "./excel.js";
export default {
  name: "ExampleReportView",
  components: {
@@ -150,102 +30,302 @@
  },
  data() {
    return {
      formObject: {
        options: {},
        items: [],
      },
      buttons: [
        {
          showName: "查询",
          onClick: () => this.onSearchClick(),
        },
        {
          showName: "清空",
          onClick: () => this.onClearClick(),
        },
        {
          showName: "导出",
          onClick: () => this.onExportClick(),
        },
      ],
      columns: [],
      data: [],
      tableHeight: 0,
      form: {
        WH_Code: "",
      },
      height: 0,
      // 分页参数
      page: 1,
      limit: 30,
      limits: [10, 20, 30],
      total: 0,
      loading: false,
    };
  },
  methods: {
    async loadForm() {
      this.formObject.options = {
        labelWidth: 110,
      };
      this.formObject.items = [
        {
          label: "供应商编码:",
          field: "SupplierCode",
          value: "",
          type: "input",
          suffix: "ios-more",
          span: 6,
          onSuffixClick: () => {},
        },
        {
          label: "供应商名称:",
          field: "SupplierName",
          value: "",
          type: "input",
          suffix: "ios-more",
          span: 6,
          onSuffixClick: () => {},
        },
        {
          label: "ASN单号:",
          field: "ASNCode",
          value: "",
          type: "input",
          suffix: "ios-more",
          span: 6,
          onSuffixClick: () => {},
        },
        {
          label: "存货:",
          field: "Invertory",
          value: "",
          type: "input",
          suffix: "ios-more",
          span: 6,
          onSuffixClick: () => {},
        },
        {
          label: "代购订单号:",
          field: "PurchaseOrderNo",
          value: "",
          type: "input",
          suffix: "ios-more",
          span: 6,
          onSuffixClick: () => {},
        },
        {
          label: "订单交期:",
          field: "OrderDate",
          value: "",
          type: "daterange",
          span: 12,
          onChange: () => {},
        },
        {
          label: "状态:",
          field: "State",
          value: "",
          type: "input",
          span: 6,
          options: [
            { labe: "一", value: 1 },
            { labe: "二", value: 2 },
            { labe: "三", value: 3 },
          ],
        },
        {
          label: "采购员:",
          field: "Purchase",
          value: "",
          type: "input",
          span: 6,
        },
      ];
    },
    async loadColumns() {
      this.columns = [
        {
          type: "index",
          key: "index",
          title: " ",
          render: (h, { index }) => {
            return h(index);
            return h("div", (this.page - 1) * this.limit + index + 1);
          },
          width: 50,
          width: 40,
          align: "center",
        },
        {
          key: "",
          key: "ASNCode",
          title: "ASN单号",
          width: 100,
          sortable: true,
          resizable: true,
        },
        {
          key: "",
          key: "CloseState",
          title: "关闭状态",
          width: 100,
          sortable: true,
          resizable: true,
        },
        {
          key: "",
          key: "InventoryState",
          title: "存货状态",
          width: 100,
          sortable: true,
          resizable: true,
        },
        {
          key: "",
          key: "InvertoryName",
          title: "存货名称",
          width: 100,
          resizable: true,
        },
        {
          key: "",
          key: "SpecModel",
          title: "规格型号",
          width: 100,
          sortable: true,
          resizable: true,
        },
        {
          key: "",
          key: "AuditState",
          title: "审核状态",
          width: 100,
          resizable: true,
        },
        {
          key: "",
          key: "SendDate",
          title: "发货日期",
          width: 100,
          sortable: true,
          resizable: true,
        },
        {
          key: "",
          key: "SupplierCode",
          title: "供应商编码",
          width: 100,
          resizable: true,
        },
        {
          key: "",
          key: "SupplierName",
          title: "供应商名称",
          width: 100,
          resizable: true,
        },
        {
          key: "",
          key: "Creator",
          title: "创建人",
          width: 100,
        },
        {
          key: "",
          key: "CreateTime",
          title: "创建时间",
          width: 100,
          sortable: true,
        },
        {
          key: "",
          key: "PurchasePoint",
          title: "采购点",
          width: 100,
        },
      ];
    },
    async loadData() {},
    resize() {
      let height =
        this.refView.clientHeight -
        this.$el.querySelector(".search-form").clientHeight -
        this.$el.querySelector(".buttons").clientHeight -
        9 -
        9;
      this.tableHeight = height;
    // 加载数据行
    async loadData() {
      let msg = this.$Message.loading("正在加载数据...");
      this.loading = true;
      let { data, total } = await this.fakeDataList();
      msg();
      this.data = data;
      this.total = total;
      this.loading = false;
    },
    onExportClick() {},
    // 加载全部数据(导出)
    async loadAllData() {
      let msg = this.$Message.loading("正在加载数据...");
      this.loading = true;
      let { data } = await this.fakeDataList(this.total);
      msg();
      this.loading = false;
      return data;
    },
    // 测试数据列表
    fakeDataList(limit) {
      return new Promise((resolve) => {
        let total = 99;
        let fakeList = [];
        for (let i = 0; i < (limit || this.limit); i++) {
          let row = {
            ASNCode: `ASN单号-${(this.page - 1) * this.limit + i + 1}`,
            CloseState: `关闭状态-${(this.page - 1) * this.limit + i + 1}`,
            InventoryState: `存货状态-${(this.page - 1) * this.limit + i + 1}`,
            InvertoryName: `存货名称-${(this.page - 1) * this.limit + i + 1}`,
            SpecModel: `规格型号-${(this.page - 1) * this.limit + i + 1}`,
            AuditState: `审核状态-${(this.page - 1) * this.limit + i + 1}`,
            SendDate: `发货日期-${(this.page - 1) * this.limit + i + 1}`,
            SupplierCode: `供应商编码-${(this.page - 1) * this.limit + i + 1}`,
            SupplierName: `供应商名称-${(this.page - 1) * this.limit + i + 1}`,
            Creator: `创建人-${(this.page - 1) * this.limit + i + 1}`,
            CreateTime: `创建时间-${(this.page - 1) * this.limit + i + 1}`,
            PurchasePoint: `采购点-${(this.page - 1) * this.limit + i + 1}`,
          };
          if ((this.page - 1) * this.limit + i + 1 < 100) fakeList.push(row);
        }
        setTimeout(() => {
          resolve({ data: fakeList, total });
        }, 1 * 1000);
      });
    },
    resize() {
      this.height = this.refView.clientHeight - 20;
    },
    onSearchClick() {
      alert(JSON.stringify(this.form, "", "    "));
    },
    onClearClick() {
      this.form.SupplierCode = "";
      this.form.ASNName = "";
      this.form.ASNCode = "";
      this.form.Invertory = "";
      this.form.PurchaseOrderNo = "";
      this.form.OrderDate = [];
      this.form.State = "";
      this.form.Purchase = "";
      this.form.PurchaseType = "";
      this.form.DocumentType = "";
      this.form.CloseState = "";
      this.form.IsArrived = "";
      this.form.ASNCreateDate = "";
    },
    async onExportClick() {
      let datas = await this.loadAllData();
      await exportExcel(this, datas);
    },
    onPageChange(page) {
      this.page = page;
      this.loadData();
    },
    onPageSizeChange(limit) {
      this.limit = limit;
      this.loadData();
    },
    onPrev(page) {
      this.page = page;
      this.loadData();
    },
    onNext(page) {
      this.page = page;
      this.loadData();
    },
  },
  async mounted() {
    await this.loadForm();
    await this.loadColumns();
    await this.loadData();
    this.loadData();
    this.$nextTick(() => {
      this.resize();
    });
@@ -260,13 +340,5 @@
<style lang="less">
.example-report-view {
  height: 100%;
  .search-form,
  .buttons {
    margin-bottom: 9px;
  }
  .ivu-form .ivu-form-item-label,
  .ivu-checkbox-wrapper {
    font-size: 12px;
  }
}
</style>