Smart_platform_ui/src/views/statisticAnalysis/statistics/index.vue

<template>
  <div class="app-container">
    <basic-container>
      <avue-crud
          ref="crud"
          :option="option"
          :data="whgenlegList"
          @resetColumn="resetColumn('crud','option','optionList',177)"
          @saveColumn="saveColumn('crud','option','optionList',177)">
        <template slot="menuLeft">
          <el-button
              type="warning"
              icon="el-icon-download"
              size="mini"
              @click="handleExport"
              v-hasPermi="['warehouseBusiness:whgenleg:export']"
          >导出
          </el-button>
        </template>
      </avue-crud>
    </basic-container>
    <span v-if="false">
      <el-form
          :model="queryParams"
          ref="queryForm"
          :inline="true"
          v-show="showSearch"
          label-width="68px"
      >
      <el-form-item label="仓库" prop="fwarehouseid">
        <treeselect
            style="width: 160px"
            v-model="queryParams.fWarehouseid"
            :options="fWarehouseidOption"
            @select="treeseLect"
            :show-count="true"
            placeholder="请选择归属库区"
        />
      </el-form-item>

      <el-form-item label="货物名称" prop="fgoodsid">
        <el-select
            v-model="queryParams.fGoodsid"
            filterable
            remote
            clearable
            size="small"
            :remote-method="goodsRemoteMethod"
            @keyup.enter.native="handleQuery"
            placeholder="请选择货物名称"
        >
          <el-option
              v-for="(dict, index) in goodsOptions"
              :key="index.fId"
              :label="dict.fName"
              :value="dict.fId"
          ></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="业务日期" prop="timeInterval">
        <el-date-picker
            v-model="queryParams.timeInterval"
            type="daterange"
            value-format="yyyy-MM-dd"
            clearable
            style="width: 60%"
            range-separator="至"
            start-placeholder="开始日期"
            end-placeholder="结束日期"
            @keyup.enter.native="handleQuery"
            :picker-options="pickerOptions"
            unlink-panels
        >
        </el-date-picker>
      </el-form-item>
      <el-form-item label="贸易方式" prop="fTrademodeid">
        <el-select
            v-model="queryParams.fTrademodeid"
            placeholder="请选择贸易方式"
            clearable
            size="small"
            @keyup.enter.native="handleQuery"
        >
          <el-option
              v-for="(dict, index) in fTrademodeidOptions"
              :key="index.dictValue"
              :label="dict.dictLabel"
              :value="dict.dictValue"
          />
        </el-select>
      </el-form-item>
      <el-form-item label="货权方" prop="fCorpid">
        <el-select
            v-model="queryParams.fCorpid"
            filterable
            remote
            clearable
            size="small"
            @keyup.enter.native="handleQuery"
            :remote-method="corpsRemoteMethod"
            placeholder="请选择货权方"
        >
          <el-option
              v-for="(dict, index) in fMblnoOptions"
              :key="index.fId"
              :label="dict.fName"
              :value="dict.fId"
          ></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="提单号" prop="fMblno">
        <el-input
            v-model="queryParams.fMblno"
            placeholder="请输入提单号"
            clearable
            size="small"
            @keyup.enter.native="handleQuery"
        />
      </el-form-item>
        <!--      <el-form-item label="箱号" prop="fCntrno">-->
        <!--        <el-input-->
        <!--          v-model="queryParams.fCntrno"-->
        <!--          placeholder="请输入箱号"-->
        <!--          clearable-->
        <!--          size="small"-->
        <!--          @keyup.enter.native="handleQuery"-->
        <!--        />-->
        <!--      </el-form-item>-->
      <el-form-item label="出库/入库" prop="fBilltype" label-width="80">
        <el-select
            v-model="queryParams.fBilltype"
            placeholder="请选择出库/入库"
            clearable
            size="small"
            @keyup.enter.native="handleQuery"
        >
          <el-option
              v-for="(dict, index) in options"
              :key="index.key"
              :label="dict.name"
              :value="dict.key"
          />
        </el-select>
      </el-form-item>
      <el-form-item>
        <el-button
            type="cyan"
            icon="el-icon-search"
            size="mini"
            @click="handleQuery"
        >搜索</el-button
        >
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery"
        >重置</el-button
        >
      </el-form-item>
    </el-form>
      <el-row :gutter="10" class="mb8">
        <div class="tabSetting">
          <el-col :span="1.5">
            <el-button
                type="warning"
                icon="el-icon-download"
                size="mini"
                @click="handleExport"
                v-hasPermi="['warehouseBusiness:whgenleg:export']"
            >导出</el-button
            >
          </el-col>
          <right-toolbar
              :showSearch.sync="showSearch"
              @queryTable="getList"
          ></right-toolbar>
          <div style="margin: 0 12px">
            <el-button
                icon="el-icon-setting"
                size="mini"
                circle
                @click="showSetting = !showSetting"
            ></el-button>
          </div>
        </div>
      </el-row>
      <el-dialog title="自定义列显示" :visible.sync="showSetting" width="700px">
        <div>配置排序列数据（拖动调整顺序）</div>
        <div style="margin-left: 17px">
          <el-checkbox
              v-model="allCheck"
              label="全选"
              @change="allChecked"
          ></el-checkbox>
        </div>
        <div style="padding: 4px; display: flex; justify-content: center">
          <draggable
              v-model="setRowList"
              group="site"
              animation="300"
              @start="onStart"
              @end="onEnd"
              handle=".indraggable"
          >
            <transition-group>
              <div
                  v-for="item in setRowList"
                  :key="item.surface"
                  class="listStyle"
              >
                <div style="width: 500px" class="indraggable">
                  <div class="progress" :style="{ width: item.width + 'px' }">
                    <el-checkbox
                        :label="item.name"
                        v-model="item.checked"
                        :true-label="0"
                        :false-label="1"
                    >{{ item.name }}
                    </el-checkbox>
                  </div>
                </div>
                <el-input-number
                    v-model.number="item.width"
                    controls-position="right"
                    :min="1"
                    :max="500"
                    size="mini"
                ></el-input-number>
              </div>
            </transition-group>
          </draggable>
        </div>
        <span slot="footer" class="dialog-footer">
          <el-button @click="showSetting = false">取 消</el-button>
          <el-button @click="delRow" type="danger">重 置</el-button>
          <el-button type="primary" @click="save()">确 定</el-button>
        </span>
      </el-dialog>
      <el-table
          v-loading="loading"
          :data="whgenlegList"
          show-summary
          :summary-method="getSum"
          ref="table"
          :height="tableHeight"
      >
        <!-- <el-table-column type="selection" width="55" align="center" /> -->
        <el-table-column
            type="index"
            label="行号"
            align="center"
            width="100"
            fixed
        />
        <el-table-column
            v-for="(item, index) in getRowList"
            :key="index"
            :label="item.name"
            :width="item.width"
            :prop="item.label"
            align="center"
            :show-overflow-tooltip="true"
            sortable
            :fixed="item.fixed"
        >
          <template slot-scope="scope">
              <span v-if="item.label == 'fMblno'">
                <span v-if="queryParams.isCntrno == 2">{{ scope.row.fMblno }}</span>
                <el-link v-else :underline="false" type="primary"
                ><div @click="goPage(scope.row)">
                    {{ scope.row.fMblno }}
                  </div></el-link
                >
              </span>
            <span v-else>{{ scope.row[item.label] }}</span>
          </template>
        </el-table-column>
        <!-- <el-table-column
          label="客户"
          sortable
          align="center"
          prop="fName"
          width="260"
          fixed
        />
        <el-table-column
          label="入库日期"
          sortable
          align="center"
          prop="fBsdate"
          width="120"
          fixed
        >
          <template slot-scope="scope">
            <span>{{ parseTime(scope.row.fBsdate, "{y}-{m}-{d}") }}</span>
          </template>
        </el-table-column>
        <el-table-column
          label="提单号"
          sortable
          align="center"
          fixed
          prop="fMblno"
          show-overflow-tooltip
          width="216"
        />
        <el-table-column
          label="出入库类型"
          align="center"
          prop="fBilltype"
          width="100"
        />
        <el-table-column
          label="货物属性"
          align="center"
          prop="fBusinessTypes"
          width="120"
        />
        <el-table-column
          label="属性详情"
          align="center"
          prop="fMarks"
          width="120"
        />
        <el-table-column
          label="品名"
          align="center"
          prop="fGoodsName"
          width="120"
        />
        <el-table-column
          label="库区"
          sortable
          align="center"
          prop="fWarehouseLocationids"
          width="160"
        />
        <el-table-column
          label="贸易方式"
          align="center"
          prop="fTrademodeid"
          width="120"
        /> -->
        <!--      <el-table-column
          label="贸易方式"
          align="center"
          prop="fTrademodeid"
          :formatter="fTrademodeidFormat"
          width="120"
        />-->
        <!-- <el-table-column label="件数" align="center" prop="fQty" />
        <el-table-column label="毛重(kg)" align="center" prop="fGrossweight" />
        <el-table-column label="净重(kg)" align="center" prop="fNetweight" /> -->

        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJRK'" label="入库件数" align="center" prop="fQty" width="120"/>-->
        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJCK'" label="出库件数" align="center" prop="fQty" width="120"/>-->
        <!--      <el-table-column label="入库尺码" align="center" prop="fVolumnD" />-->
        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJRK'" label="入库毛重" align="center" prop="fGrossweight" width="120"/>-->
        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJCK'" label="出库毛重" align="center" prop="fGrossweight" width="120"/>-->
        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJRK'" label="入库净重" align="center" prop="fNetweight" width="120"/>-->
        <!--      <el-table-column v-if="queryParams.fBilltype === 'SJCK'" label="出库净重" align="center" prop="fNetweight" width="120"/>-->
        <!--      <el-table-column label="出库尺码" align="center" prop="fVolumnC" />-->
        <!--      <el-table-column label="出库件数" align="center" prop="fQtyC" width="120"/>-->
        <!--      <el-table-column label="出库毛重" align="center" prop="fGrossweightC" width="120"/>-->
        <!--      <el-table-column label="出库净重" align="center" prop="fNetweightC" width="120"/>-->
        <!--      <el-table-column label="结余件数" align="center" prop="fQtyblc" width="120"/>-->
        <!--      <el-table-column label="结余毛重" align="center" prop="fGrossweightblc" width="120"/>-->
        <!--      <el-table-column label="结余净重" align="center" prop="fNetweightblc" width="120"/>-->
        <!--      <el-table-column label="箱号" align="center" prop="fCntrno" width="120"/>-->
        <!--      <el-table-column label="备注" align="center" prop="remark" width="120"/>-->
        <!-- <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
          <template slot-scope="scope">
            <el-button
              size="mini"
              type="text"
              icon="el-icon-edit"
              @click="handleUpdate(scope.row)"
              v-hasPermi="['warehouseBusiness:whgenleg:edit']"
            >修改</el-button>
            <el-button
              size="mini"
              type="text"
              icon="el-icon-delete"
              @click="handleDelete(scope.row)"
              v-hasPermi="['warehouseBusiness:whgenleg:remove']"
            >删除</el-button>
          </template>
        </el-table-column> -->
      </el-table>
      <pagination
          v-show="total > 0"
          :total="total"
          :page.sync="queryParams.pageNum"
          :limit.sync="queryParams.pageSize"
          :page-sizes="[50, 100, 200, 500, 1000]"
          @pagination="getList"
      />
    </span>

    <!-- 添加或修改库存总账对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="原始入库业务编号" prop="fOriginalbillno">
          <el-input
              v-model="form.fOriginalbillno"
              placeholder="请输入原始入库业务编号"
          />
        </el-form-item>
        <el-form-item label="上期件数" prop="fPreqty">
          <el-input v-model="form.fPreqty" placeholder="请输入上期件数"/>
        </el-form-item>
        <el-form-item
            label="上期毛重(kg),单位为吨，保留6位小数"
            prop="fPregrossweight"
        >
          <el-input
              v-model="form.fPregrossweight"
              placeholder="请输入上期毛重,单位为吨，保留6位小数"
          />
        </el-form-item>
        <el-form-item label="上期净重(kg)," prop="fPrenetweight">
          <el-input
              v-model="form.fPrenetweight"
              placeholder="请输入上期净重,"
          />
        </el-form-item>
        <el-form-item label="入库件数" prop="fQtyd">
          <el-input v-model="form.fQtyd" placeholder="请输入入库件数"/>
        </el-form-item>
        <el-form-item label="入库尺码" prop="fVolumnd">
          <el-input v-model="form.fVolumnd" placeholder="请输入入库尺码"/>
        </el-form-item>
        <el-form-item label="入库毛重(kg)" prop="fGrossweightd">
          <el-input v-model="form.fGrossweightd" placeholder="请输入入库毛重"/>
        </el-form-item>
        <el-form-item label="入库净重(kg)" prop="fNetweightd">
          <el-input v-model="form.fNetweightd" placeholder="请输入入库净重"/>
        </el-form-item>
        <el-form-item label="出口尺码" prop="fVolumnc">
          <el-input v-model="form.fVolumnc" placeholder="请输入出口尺码"/>
        </el-form-item>
        <el-form-item label="出库件数" prop="fQtyc">
          <el-input v-model="form.fQtyc" placeholder="请输入出库件数"/>
        </el-form-item>
        <el-form-item label="结余件数" prop="fQtyblc">
          <el-input v-model="form.fQtyblc" placeholder="请输入结余件数"/>
        </el-form-item>
        <el-form-item label="出库毛重(kg),单位为吨" prop="fGrossweightc">
          <el-input
              v-model="form.fGrossweightc"
              placeholder="请输入出库毛重(kg),单位为吨"
          />
        </el-form-item>
        <el-form-item label="出库净重(kg)" prop="fNetweightc">
          <el-input v-model="form.fNetweightc" placeholder="请输入出库净重"/>
        </el-form-item>
        <el-form-item label="结余毛重(kg)" prop="fGrossweightblc">
          <el-input
              v-model="form.fGrossweightblc"
              placeholder="请输入结余毛重"
          />
        </el-form-item>
        <el-form-item label="结余净重" prop="fNetweightblc">
          <el-input v-model="form.fNetweightblc" placeholder="请输入结余净重"/>
        </el-form-item>
        <el-form-item label="箱号" prop="fCntrno">
          <el-input v-model="form.fCntrno" placeholder="请输入箱号"/>
        </el-form-item>
        <el-form-item label="状态，默认 T ,正常T 停用F 下拉选择">
          <el-radio-group v-model="form.fStatus">
            <el-radio label="1">请选择字典生成</el-radio>
          </el-radio-group>
        </el-form-item>
        <el-form-item label="删除状态" prop="delFlag">
          <el-input v-model="form.delFlag" placeholder="请输入删除状态"/>
        </el-form-item>
        <el-form-item label="唛头" prop="fMarks">
          <el-input v-model="form.fMarks" placeholder="请输入唛头"/>
        </el-form-item>
        <el-form-item label="备注" prop="remark">
          <el-input
              v-model="form.remark"
              type="textarea"
              placeholder="请输入内容"
          />
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
// import {
//   listWhgenleg,
//   getWhgenleg,
//   delWhgenleg,
//   addWhgenleg,
//   updateWhgenleg,
//   exportWhgenleg,
// } from "@/api/reportManagement/Statistics";
// import { listWarehouse, treeselect } from "@/api/basicdata/warehouse";
// import { listArea } from "@/api/basicdata/area";
// import { listGoods } from "@/api/basicdata/goods";
// import { listCorps } from "@/api/basicdata/corps";
// import Treeselect from "@riophae/vue-treeselect";
// import "@riophae/vue-treeselect/dist/vue-treeselect.css";
// import { addSet, select, resetModule } from "@/api/system/set";
import Cookies from "js-cookie";
import draggable from "vuedraggable";

export default {
  name: "Whgenleg",
  components: {
    // Treeselect,
    draggable
  },
  data() {
    return {
      option:{},
      optionList: {
        border: true,
        align: 'center',
        stripe: true,
        index: true,
        addBtn: false,
        editBtn: false,
        delBtn: false,
        menu: false,
        height: "auto",
        searchSpan: 8,
        searchIcon: true,
        searchIndex: 2,
        highlightCurrentRow: true,
        column: [
          {
            index: "1",
            prop: "fName",
            label: "客户",
            width: 100,
          },
          {
            index: "2",
            prop: "fBsdate",
            label: "业务日期",
            width: 100,
            search: true,
          },
          {
            index: "3",
            prop: "fMblno",
            label: "提单号",
            width: 100,
            search: true,
          },
          {
            index: "4",
            prop: "fBilltype",
            label: "出入库类型",
            width: 100,
            search: true,
          },
          {
            index: "5",
            prop: "fBusinessTypes",
            label: "货物属性",
            width: 100,
          },
          {
            index: "6",
            prop: "fMarks",
            label: "属性详情",
            width: 100,
          },
          {
            index: "7",
            prop: "fGoodsName",
            label: "品名",
            width: 100,
            search: true,
          },
          {
            index: "8",
            prop: "fWarehouseLocationids",
            label: "库区",
            width: 100,
            search: true,
          },
          {
            index: "9",
            prop: "fTrademodeid",
            label: "贸易方式",
            width: 100,
            search: true,
          },
          {
            index: "10",
            prop: "fQty",
            label: "件数",
            width: 100,
          },
          {
            index: "11",
            prop: "fGrossweight",
            label: "毛重(kg)",
            width: 100,
          },
          {
            index: "12",
            prop: "fNetweight",
            label: "净重(kg)",
            width: 100,
          },
          {
            index: "13",
            prop: "fDrivername",
            label: "司机",
            width: 100,
          },
          {
            index: "14",
            prop: "fTruckno",
            label: "车号",
            width: 100,
          },
          {
            index: "15",
            prop: "fDriverIdCar",
            label: "司机身份证",
            width: 120,
          },
        ]
      },
      pickerOptions: {
        shortcuts: [{
          text: '最近一周',
          onClick(picker) {
            const end = new Date();
            const start = new Date();
            start.setTime(start.getTime() - 3600 * 1000 * 24 * 7);
            picker.$emit('pick', [start, end]);
          }
        }, {
          text: '最近一个月',
          onClick(picker) {
            const end = new Date();
            const start = new Date();
            start.setTime(start.getTime() - 3600 * 1000 * 24 * 30);
            picker.$emit('pick', [start, end]);
          }
        }, {
          text: '最近三个月',
          onClick(picker) {
            const end = new Date();
            const start = new Date();
            start.setTime(start.getTime() - 3600 * 1000 * 24 * 90);
            picker.$emit('pick', [start, end]);
          }
        }]
      },
      tableHeight: '0',
      //仓库树状下拉
      fWarehouseidOption: [],
      options: [
        {
          name: "出库",
          key: "SJCK",
        },
        {
          name: "入库",
          key: "SJRK",
        },
      ],
      // 货权方(客户数据)
      fMblnoOptions: [],
      // 贸易方式(数据字典),对应t_trademodels 字典
      fTrademodeidOptions: [],
      // 货物
      goodsOptions: [],
      // 仓库(仓库数据)
      warehouseOptions: [],
      kqhouseOptions: [],
      // 遮罩层
      loading: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // 库存总账表格数据
      whgenlegList: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 50,
        fOriginalbillno: null,
        fPreqty: null,
        fPregrossweight: null,
        fPrenetweight: null,
        fQtyd: null,
        fVolumnd: null,
        fGrossweightd: null,
        fNetweightd: null,
        fVolumnc: null,
        fQtyc: null,
        fQtyblc: null,
        fGrossweightc: null,
        fNetweightc: null,
        fGrossweightblc: null,
        fNetweightblc: null,
        fCntrno: null,
        fStatus: null,
        fMarks: null,
        fBusinessType: null,
        fBusinessTypes: null,
        fBilltype: "SJRK",
        fwarehouseid: null,
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
        fMarks: [{required: true, message: "唛头不能为空", trigger: "blur"}],
      },
      showSetting: false,
      drag: false,
      setRowList: [],
      getRowList: [],
      tableDate: [
        {
          surface: "1",
          label: "fName",
          name: "客户",
          checked: 0,
          width: 100,
          fixed: "left",
        },
        {
          surface: "2",
          label: "fBsdate",
          name: "业务日期",
          checked: 0,
          width: 100,
          fixed: "left",
        },
        {
          surface: "3",
          label: "fMblno",
          name: "提单号",
          checked: 0,
          width: 100,
          fixed: "left",
        },
        {
          surface: "4",
          label: "fBilltype",
          name: "出入库类型",
          checked: 0,
          width: 100,
        },
        {
          surface: "5",
          label: "fBusinessTypes",
          name: "货物属性",
          checked: 0,
          width: 100,
        },
        {
          surface: "6",
          label: "fMarks",
          name: "属性详情",
          checked: 0,
          width: 100,
        },
        {
          surface: "8",
          label: "fGoodsName",
          name: "品名",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fWarehouseLocationids",
          name: "库区",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fTrademodeid",
          name: "贸易方式",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fQty",
          name: "件数",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fGrossweight",
          name: "毛重(kg)",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fNetweight",
          name: "净重(kg)",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fDrivername",
          name: "司机",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fTruckno",
          name: "车号",
          checked: 0,
          width: 100,
        },
        {
          surface: "9",
          label: "fDriverIdCar",
          name: "司机身份证",
          checked: 0,
          width: 120,
        },
      ],
      allCheck: false,
    };
  },
  async created() {
    this.option = await this.getColumnData(this.getColumnName(175), this.optionList);
    // let date = new Date();
    // let year = parseInt(date.getFullYear())
    // let month = parseInt(date.getMonth() + 1)
    // let currentMonth = date.getMonth()
    // let nextMonth = ++currentMonth
    // let nextMonthFirstDay = new Date(date.getFullYear(), nextMonth, 1)  // 下个月的第一天
    // let oneDay = 1000*60*60*24
    // let lastTime = new Date(nextMonthFirstDay - oneDay) // 下个月的第一天减去一天，就是上个月的最后一天
    // let day = lastTime.getDate()
    // if (day < 10) {
    //   day = '0' + day
    // }
    // this.$set(this.queryParams,'timeInterval', [year + '-' + month + '-' + '01 00:00:00', year + '-' + month + '-' + day + ' 23:59:59'])

    this.setRowList = this.tableDate;
    this.getRowList = this.tableDate;
    this.getList();
    this.getDicts("data_trademodes").then((response) => {
      this.fTrademodeidOptions = response.data;
    });
    treeselect().then((response) => {
      this.fWarehouseidOption = response.data;
    });
    this.getRow();
  },
  mounted() {
    this.$nextTick(() => {
      // 监听浏览器高度变化，改变表格高度
      window.onresize = () => {
        this.tableHeight = window.innerHeight - this.$refs.table.$el.offsetTop - 70
      }
    })
  },
  methods: {
    //自定义列保存
    async saveColumn(ref, option, optionBack, code) {
      /**
       * 已定义全局方法，直接使用，saveColumnData保存列数据方法,参数传值(表格名称，当前表格的option数据)
       * 已定义全局方法，直接使用，getColumnName方法用来获取枚举值，参数根据自己定义的code值获取中文名
       * 一定要执行异步操作，要等接口成功返回，才能执行下一行代码
       */
      const inSave = await this.saveColumnData(this.getColumnName(code), this[option]);
      if (inSave) {
        this.$message.success("保存成功");
        //关闭窗口
        this.$refs[ref].$refs.dialogColumn.columnBox = false;
      }
    },
    //自定义列重置
    async resetColumn(ref, option, optionBack, code) {
      this[option] = this[optionBack];
      const inSave = await this.delColumnData(this.getColumnName(code), this[optionBack]);
      if (inSave) {
        this.$message.success("重置成功");
        this.$refs[ref].$refs.dialogColumn.columnBox = false;
      }
    },
    //列设置全选
    allChecked() {
      if (this.allCheck == true) {
        this.setRowList.map((e) => {
          return (e.checked = 0);
        });
      } else {
        this.setRowList.map((e) => {
          return (e.checked = 1);
        });
      }
    },
    //查询列数据
    getRow() {
      let that = this;
      this.data = {
        tableName: "出入库统计",
        userId: Cookies.get("userName"),
      };
      select(this.data).then((res) => {
        if (res.data.length != 0) {
          this.getRowList = res.data.filter((e) => e.checked == 0);
          this.setRowList = res.data;
          this.setRowList = this.setRowList.reduce((res, item) => {
            res.push({
              surface: item.surface,
              label: item.label,
              name: item.name,
              checked: item.checked,
              width: item.width,
              fixed: item.fixed,
            });
            return res;
          }, []);
        }
      });
    },
    delRow() {
      this.data = {
        tableName: "出入库统计",
        userId: Cookies.get("userName"),
      };
      resetModule(this.data).then((res) => {
        if (res.code == 200) {
          this.showSetting = false;
          this.setRowList = this.tableDate;
          this.getRowList = this.tableDate;
        }
      });
    },
    //保存列设置
    save() {
      this.showSetting = false;
      this.data = {
        tableName: "出入库统计",
        userId: Cookies.get("userName"),
        sysTableSetList: this.setRowList,
      };
      addSet(this.data).then((res) => {
        if (res.code == 200) {
          this.showSetting = false;
          this.getRowList = this.setRowList.filter((e) => e.checked == 0);
        }
      });
    },
    //开始拖拽事件
    onStart() {
      this.drag = true;
    },
    //拖拽结束事件
    onEnd() {
      this.drag = false;
    },
    //合计
    getSum(param) {
      const {columns, data} = param;
      const sums = [];
      columns.forEach((column, index) => {
        if (index === 0) {
          sums[index] = "总计";
        } else if (index === 12 || index === 10 || index === 11) {
          const values = data.map((item) => Number(item[column.property]));
          if (!values.every((value) => isNaN(value))) {
            sums[index] = values.reduce((prev, curr) => {
              const value = Number(curr);
              if (!isNaN(value)) {
                return prev + curr;
              } else {
                return prev;
              }
            }, 0);
            if (index === 12 || index === 11) {
              sums[index] = (sums[index] / 1000).toFixed(2) + "(吨)";
            }
          }
        }
      });
      return sums;
    },
    treeseLect(tree) {
      this.queryParams.fWarehouseid = tree.id;
    },
    getTreeselect() {
      treeselect().then((response) => {
        this.warehousesOptions = response.data;
      });
    },

    // 贸易方式(数据字典),对���t_trademodels 字典翻译
    fTrademodeidFormat(row, column) {
      return this.selectDictLabel(this.fTrademodeidOptions, row.fTrademodeid);
    },
    /* 远程模糊查询仓库 */
    warehouseRemoteMethod(name) {
      if (name == null || name === "") {
        return false;
      }
      let queryParams = {pageNum: 1, pageSize: 10, fName: name};
      listWarehouse(queryParams).then((response) => {
        this.warehouseOptions = response.rows;
      });
    },
    /* 远程模糊查询库区 */
    kqhouseRemoteMethod(name) {
      if (name == null || name === "") {
        return false;
      }
      if (!this.queryParams.fWarehouseid) {
        this.$message.error("请输入仓库!");
        return false;
      }

      let queryParams = {
        pageNum: 1,
        pageSize: 10,
        fWarehouseid: this.queryParams.fWarehouseid,
        fName: name,
      };
      listArea(queryParams).then((response) => {
        this.kqhouseOptions = response.rows;
      });
    },
    /* 远程模糊查询商品 */
    goodsRemoteMethod(name) {
      if (name == null || name === "") {
        return false;
      }
      let queryParams = {pageNum: 1, pageSize: 10, fName: name};
      listGoods(queryParams).then((response) => {
        this.goodsOptions = response.rows;
      });
    },
    /* 远程模糊查询用户 */
    corpsRemoteMethod(name) {
      if (name == null || name === "") {
        return false;
      }
      let queryParams = {pageNum: 1, pageSize: 10, fName: name};
      listCorps(queryParams).then((response) => {
        this.fMblnoOptions = response.rows;
        this.KHblnoOptions = response.rows;
      });
    },
    /** 查询库存总账列表 */
    getList() {
      this.loading = true;
      listWhgenleg(this.queryParams).then((response) => {
        this.whgenlegList = response.rows;
        this.total = response.total;
        this.loading = false;
        // 根据浏览器高度设置初始高度
        setTimeout(() => {
          this.tableHeight = window.innerHeight - this.$refs.table.$el.offsetTop - 70
        }, 300)
      });
    },
    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // 表单重置
    reset() {
      this.form = {
        fAccyear: null,
        fId: null,
        fAccmonth: null,
        fCorpid: null,
        fMblno: null,
        fOriginalbillno: null,
        fWarehouseLocationid: null,
        fGoodsid: null,
        fwarehouseid: null,
        fTrademodeid: null,
        fPreqty: null,
        fPregrossweight: null,
        fPrenetweight: null,
        fQtyd: null,
        fVolumnd: null,
        fGrossweightd: null,
        fNetweightd: null,
        fVolumnc: null,
        fQtyc: null,
        fQtyblc: null,
        fGrossweightc: null,
        fNetweightc: null,
        fGrossweightblc: null,
        fNetweightblc: null,
        fCntrno: null,
        fStatus: "0",
        delFlag: null,
        createBy: null,
        fMarks: null,
        createTime: null,
        updateBy: null,
        updateTime: null,
        remark: null,
      };
      this.resetForm("form");
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.queryParams = {
        pageNum: 1,
        pageSize: 10,
        fOriginalbillno: null,
        fPreqty: null,
        fPregrossweight: null,
        fPrenetweight: null,
        fQtyd: null,
        fVolumnd: null,
        fGrossweightd: null,
        fNetweightd: null,
        fVolumnc: null,
        fQtyc: null,
        fQtyblc: null,
        fGrossweightc: null,
        fNetweightc: null,
        fGrossweightblc: null,
        fNetweightblc: null,
        fCntrno: null,
        fStatus: null,
        fMarks: null,
        fBusinessType: null,
        fBusinessTypes: null,
        fBilltype: "SJRK",
        fwarehouseid: null,
      };
      // this.resetForm("queryForm");
      this.handleQuery();
    },
    /** 新增按钮操作 */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加库存总账";
    },
    /** 提交按钮 */
    submitForm() {
      this.$refs["form"].validate((valid) => {
        if (valid) {
          if (this.form.fAccyear != null) {
            updateWhgenleg(this.form).then((response) => {
              this.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addWhgenleg(this.form).then((response) => {
              this.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** 导出按钮操作 */
    handleExport() {
      const queryParams = this.queryParams;
      this.$confirm("是否确认导出所出入库统计数据项?", "警告", {
        confirmButtonText: "确定",
        cancelButtonText: "取消",
        type: "warning",
      })
          .then(function () {
            return exportWhgenleg(queryParams);
          })
          .then((response) => {
            this.download(response.msg);
          });
    },
    goPage(row) {
      switch (row.fBilltype) {
        case "入库": {
          this.$router.push({
            path: "/business/inStock",
            query: {id: row.fId},
          });
          break;
        }
        case "出库": {
          this.$router.push({
            path: "/business/outStock",
            query: {id: row.fId},
          });
          break;
        }
      }
    },
  },
};
</script>
<style lang="scss">
.el-table {
  .el-table__body-wrapper {
    z-index: 2;
  }
}

.tabSetting {
  display: flex;
  justify-content: flex-end;
}

.listStyle {
  display: flex;
  border-top: 1px solid #dcdfe6;
  border-left: 1px solid #dcdfe6;
  border-right: 1px solid #dcdfe6;
}

.listStyle:last-child {
  border-bottom: 1px solid #dcdfe6;
}

.progress {
  display: flex;
  align-items: center;
  padding: 2px;
  background-color: rgba(0, 0, 0, 0.05);
  height: 100%;
}
</style>