Warehouse_management_lc_ui/src/views/reportManagement/Statistics/index.vue

<template>
  <div class="app-container">
    <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"
        >
        </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">
      <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>
    </el-row>

    <el-table v-loading="loading" :data="whgenlegList" show-summary :summary-method="getSum">
      <!-- <el-table-column type="selection" width="55" align="center" /> -->
      <el-table-column type="index" label="行号" align="center" width="100" fixed/>
      <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"
    />

    <!-- 添加或修改库存总账对话框 -->
    <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";

export default {
  name: "Whgenleg",
  components: {
    Treeselect
  },
  data() {
    return {
      //仓库树状下拉
      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" }
        ],
      }
    };
  },
  created() {
    this.getList();
    this.getDicts("data_trademodes").then((response) => {
      this.fTrademodeidOptions = response.data;
    });
    treeselect().then(response => {
      this.fWarehouseidOption = response.data
    })
  },
  methods: {
    //合计
    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;
      });
    },
    // 取消按钮
    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);
        })
    }
  }
};
</script>
<style lang="scss">
.el-table {
  .el-table__body-wrapper {
    z-index: 2;
  }
}
</style>