SZYGM1.0/src/views/statisticalanalysis/pickingstatistics/index.vue

<template>
  <div class="airportInfo">
    <div class="variable">
      <StatisticsHeader
        :title="titleTop"
        :items="formItems"
        :data="formData"
        :eledata="eledata"
        with-setting
        :withSetting="false"
        :withExport="true"
        :set="set"
        :action="action"
        :asShow="asShow"
        @getFormData="getFormData"
        @export="tableToExcel"
        @upset="upset"
      />
    </div>
    <div class="echart">
      <Echarts
        :id="dataid"
        :option="tableData"
        v-if="picShow == true ? true : false"
      />
      <Tableformbrs
        :tableList="tableList"
        :action="action"
        v-if="!picShow"
        :set="set"
        :total-num="totalNum"
      />
    </div>
  </div>
</template>

<script>
import Echarts from "../components/echart/index.vue";
import Tableformbrs from "../components/echart/tableforms.vue";
import StatisticsHeader from "../components/echart/statisticsHeader.vue";
import { export_json_to_excel } from "@/utils/Export2Excel";
import { Query } from "@/api/webApi";
export default {
  name: "ChartsBar",
  data() {
    return {
      asShow: true,
      optiondata: [],
      picShow: true, //图片表格切换
      action: 4,
      dataid: "collection_ecahrt4",
      listqueryTemplateID: DATACONTENT_ID.modePullgoods,
      eledata: 4,
      set: "",
      isShow: Echarts,
      tableList: [],
      tableListcop: [],
      listname: "",
      listHeader: [],
      tableData: {
        time: [],
        data1: [],
        data2: [],
        kg: "",
        tyol: "",
      },
      formData: {
        airport: "",
        dateTime: "",
      },
      titleTop: "拉货统计",
      formItems: [
        {
          prop: "fttp",
          inputType: "select",
          placeholder: "国内国际",
          requiredWarning: "请先选择国内国际",
          clearable: true,
          options: [
            {
              value: "国内离港",
              label: "国内出港",
            },
            {
              value: "国际离港",
              label: "国际出港",
            },
          ],
        },
        {
          prop: "kht",
          inputType: "select",
          placeholder: "客货类型",
          requiredWarning: "请先选择客货类型",
          clearable: true,
          options: [
            {
              value: "客机",
              label: "客机",
            },
            {
              value: "货机",
              label: "货机",
            },
            {
              value: "其它",
              label: "其它",
            },
            {
              value: "全部",
              label: "全部",
            },
          ],
        },
        {
          prop: "td",
          inputType: "select",
          placeholder: "统计维度",
          requiredWarning: "请先选择统计时间维度",
          clearable: true,
          options: [
            {
              value: "月",
              label: "月",
            },
            {
              value: "年",
              label: "年",
            },
          ],
        },
        {
          prop: "set",
          inputType: "select",
          placeholder: "统计航班",
          requiredWarning: "",
          clearable: true,
          options: [
            {
              value: 1,
              label: "统计航班",
            },
            {
              value: 2,
              label: "统计重量",
            },
          ],
        },
        {
          prop: "dateTime",
          inputType: "datePicker",
          clearable: true,
          width: "240px",
          options: [],
        },
      ],
      totalNum: 0
    };
  },
  mounted() {
    // this.getQuery([]);
  },
  watch: {
    // 监听数据变化，重绘折线图
    option: {
      deep: true,
      handler(newVal) {},
    },
  },
  destroyed() {},
  methods: {
    getFormData(data) {
      this.tableData.time = [];
      this.tableData.data1 = [];
      this.tableData.data2 = [];
      this.set = data.set;
      let option = [
        {
          fttp: data.fttp,
          kht: data.kht,
          td: data.td,
          fd1: data.dateTime[0],
          fd2: data.dateTime[1],
          spe: data.spe,
        },
      ];
      this.optiondata = [
        {
          fttp: data.fttp,
          kht: data.kht,
          td: data.td,
          fd1: data.dateTime[0],
          fd2: data.dateTime[1],
          spe: data.spe,
        },
      ];
      this.getQuery(option, data.set);
      this.listname =
        "拉货统计" +
        data.fttp +
        data.kht +
        data.td +
        data.dateTime[0] +
        "--" +
        data.dateTime[1];
      this.listHeader = [
        "序号",
        "时间",
        "航班量(班)",
        "环比(%)",
        "重量(吨)",
        "环比(%)",
      ];
    },
    //获取表格数据
    async getQuery(data, dat) {
      try {
        const { code, returnData } = await Query({
          id: this.listqueryTemplateID,
          dataContent: data,
        });
        if (code == 0) {
          this.tableData.time = [];
          this.tableData.data1 = [];
          this.tableData.data2 = [];
          this.totalNum = returnData.listValues.length
          this.tableList = JSON.parse(JSON.stringify(returnData.listValues));
          this.tableListcop = JSON.parse(JSON.stringify(returnData.listValues));
          this.tableList.forEach((item, index) => {
            item.indexs = index + 1;
          });
          for (let i = 0; i < 10; i++) {
            if (!this.tableList[i]) {
              this.tableList.push({});
            }
          }
          this.tableListcop.forEach((item, index) => {
            item.indexs = index + 1;
          });
          if (this.picShow == true) {
            let objar = {
              indexs: "合计",
              pullFlightNum: returnData.listValues[0].totalPullFlightNum,
              pullWeight: returnData.listValues[0].totalPullWeight,
            };
            this.tableListcop.push(objar);
          } else {
            let objar = {
              indexs: "合计",
              totalWeight: returnData.listValues[0].hejiTotalWeight,
              pullWeight: returnData.listValues[0].hejiPullWeight,
            };
            this.tableListcop.push(objar);
          }
          returnData.listValues.forEach((element) => {
            this.tableData.time.push(element.dat);
            this.tableData.kg = "单位：吨";
            if (dat == 1) {
              this.tableData.data2.push(
                element.pullFlightNum ? element.pullFlightNum : 0
              );
              this.tableData.kg = "单位：班";
            } else if (dat == 2) {
              this.tableData.kg = "单位:吨";
              this.tableData.data2.push(
                element.pullWeight ? element.pullWeight : 0
              );
            }
            this.tableData.data1 = [];
          });
          this.tableData.data1.push(0);
          for (let index = 0; index < this.tableData.data2.length; index++) {
            if (index > 0) {
              const element =
                (this.tableData.data2[index] -
                  this.tableData.data2[index - 1]) /
                this.tableData.data2[index - 1];
              this.tableData.data1.push(
                element.toFixed(2) ? element.toFixed(2) : 0
              );
              this.tableData.data1.forEach((element) => {
                element = Number(element);
                if (typeof element !== "number") {
                  element = 0;
                }
              });
            }
          }
        }
      } catch (error) {
        this.page--;
      }
    },
    //导出
    tableToExcel() {
      import("../../../utils/Export2Excel").then((excel) => {
        // 设置导出表格的头部
        const tHeader = this.listHeader;
        // 将要导出的数据进行一个过滤
        /**
         * 源数据导入到excel的数据每一条重新拼成一个数组,数组里的每个元素就是filterVal里的每个字段
         */
        const data = this.tableListcop.map((item, index) => {
          if (this.picShow == true) {
            return [
              item.indexs,
              item.dat,
              item.pullFlightNum,
              item.flightChain,
              item.pullWeight,
              item.weightChain,
            ];
          } else {
            return [
              item.indexs,
              item.flightdate,
              item.flightNo,
              item.line,
              item.stand,
              item.totalWeight,
              item.pullWeight,
            ];
          }
        });
        data[data.length - 1].indexs = "总计";
        // 调用我们封装好的方法进行导出Excel
        excel.export_json_to_excel({
          // 导出的头部
          header: tHeader,
          // 导出的内容
          data,
          // 导出的文件名称
          filename: this.listname,
          // 导出的表格宽度是否自动
          autoWidth: true,
          // 导出文件的后缀类型
          bookType: "xlsx",
        });
      });
    },
    upset(data) {
      this.picShow = data;
      if (this.picShow == false) {
        this.tableData.time = [];
        this.tableData.data1 = [];
        this.tableData.data2 = [];
        this.listHeader = [
          "序号",
          "日期",
          "航班号",
          "航线",
          "机位",
          "货物总重 (KG)",
          "拉货 (KG)",
        ];
        this.listqueryTemplateID = DATACONTENT_ID.modePulltable;
        this.getQuery(this.optiondata, this.set);
        // console.log(this.tableListcop);
      } else if (this.picShow == true) {
        this.tableData.time = [];
        this.tableData.data1 = [];
        this.tableData.data2 = [];
        this.listHeader = [
          "序号",
          "时间",
          "航班量(班)",
          "环比(%)",
          "重量(吨)",
          "环比(%)",
        ];
        this.listqueryTemplateID = DATACONTENT_ID.modePullgoods;
        this.getQuery(this.optiondata, this.set);
      }
    },
  },
  components: {
    Echarts,
    StatisticsHeader,
    Tableformbrs,
  },
};
</script>
<style lang="scss" scoped>
.airportInfo {
  position: relative;
  .header {
    width: 103%;
    height: 36px;
    display: flex;
    align-items: center;
    justify-content: center;
    background: #f7f7f7;
    position: relative;
    left: -23px;
    > .nav {
      padding: 0 30px 0 30px;
      cursor: pointer;
      font-size: 16px;
      font-family: Microsoft YaHei;
      font-weight: 400;
      color: #101116;
    }
    > .navs {
      height: 100%;
      padding: 0 30px 0 30px;
      cursor: pointer;
      display: flex;
      align-items: center;
      font-size: 16px;
      font-family: Microsoft YaHei;
      font-weight: bold;
      color: #ac014d;
      border-bottom: 2px solid #ac014d;
    }
  }
  .variable {
    width: 100%;
    height: 52px;
  }
  .echart {
    width: 100%;
    height: 746px;
    position: absolute;
    background: #ffffff;
    box-shadow: 0px 3px 3px 0px rgba(0, 0, 0, 0.1);
    border-radius: 4px;
  }
}
</style>