Warehouse_management_ui/src/views/reportManagement/profitGeneralLedger/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="fCorpid">
        <el-select
          v-model="queryParams.fCorpid"
          filterable
          remote
          clearable
          style="width: 200px"
          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
          style="width: 200px"
          size="small"
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="结算单位" prop="fToCorpid">
        <el-select
          v-model="queryParams.fToCorpid"
          placeholder="请选择结算单位"
          filterable
          remote
          clearable
          style="width: 200px"
          size="small"
          @keyup.enter.native="handleQuery"
          :remote-method="corpsRemoteMethod"
        >
          <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="fProductName">
        <el-select
          v-model="queryParams.fProductName"
          filterable
          remote
          clearable
          size="small"
          style="width: 200px"
          :remote-method="goodsRemoteMethod"
          @keyup.enter.native="handleQuery"
          placeholder="请选择货物名称"
        >
          <el-option
            v-for="(dict, index) in goodsOptions"
            :key="index.fId"
            :label="dict.fName"
            :value="dict.fName"
          ></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="品牌" prop="fMarks">
        <el-input
          v-model="queryParams.fMarks"
          placeholder="请输入品牌"
          clearable
          style="width: 200px"
          size="small"
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="结算状态" prop="fReconciliation">
        <el-select
          v-model="queryParams.fReconciliation"
          clearable
          style="width: 200px"
          size="small"
          @keyup.enter.native="handleQuery"
        >
          <el-option label="未收" value="0"/>
          <el-option label="全部" value="1"/>
        </el-select>
      </el-form-item>

      <el-form-item label="费用状态" prop="fBillstatus">
        <el-select
          v-model="queryParams.fBillstatus"
          clearable
          style="width: 200px"
          size="small"
          @keyup.enter.native="handleQuery"
        >
          <el-option label="录入" value="0"/>
          <el-option label="审核通过" value="1"/>

        </el-select>
      </el-form-item>
      <el-form-item label="作业类型" prop="fBusinessType">
        <el-select
          style="width: 200px"
          multiple
          v-model="queryParams.fBusinessType"
          filterable
        >
          <el-option
            v-for="(dict, index) in businessTypeOption"
            :key="index.dictValue"
            :label="dict.dictLabel"
            :value="dict.dictValue"
          ></el-option>
        </el-select>
      </el-form-item>
      <el-form-item label="费用名称" prop="fFeeid">
        <el-select
          style="width: 200px"
          multiple
          :remote-method="fWRemoteMethod"
          v-model="queryParams.fFeeid"
          filterable
        >
          <el-option
            v-for="(dict, index) in fWbuOptions"
            :key="index.fId"
            :label="dict.fName"
            :value="dict.fId"
          ></el-option>
        </el-select>
      </el-form-item>

      <el-form-item label="审核日期" prop="timeExamine">
        <el-date-picker
          v-model="queryParams.timeExamine"
          type="daterange"
          value-format="yyyy-MM-dd"
          clearable
          style="width: 280px"
          range-separator="至"
          start-placeholder="开始日期"
          end-placeholder="结束日期"
          @keyup.enter.native="handleQuery"
        >
        </el-date-picker>
      </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:profit: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="receivableList" show-summary :summary-method="getSum">
      <!-- <el-table-column type="selection" width="55" align="center" /> -->
      <el-table-column type="index" label="行号" align="center" width="100"/>
        <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"
      />
      <!-- <el-table-column label="货权方" sortable align="center" prop="fName" width="220"/>
      <el-table-column label="结算单位" sortable align="center" prop="fFeesName" width="220"/>
      <el-table-column label="提单号" sortable align="center" prop="fMblno" width="216" show-overflow-tooltip/>
      <el-table-column label="货物名称" align="center" prop="fProductName" show-overflow-tooltip/>
      <el-table-column label="品牌" align="center" prop="fMarks" width="120"/>
      <el-table-column label="审核日期" align="center" prop="fReviewDate">
        <template slot-scope="scope">
          <span>{{ parseTime(scope.row.fReviewDate, '{y}-{m}-{d}') }}</span>
        </template>
      </el-table-column>
      <el-table-column label="应收金额" align="center" prop="fAmount"/>
      <el-table-column label="应付金额" align="center" prop="fStlamount"/>
      <el-table-column label="利润" align="center" prop="nnfinished"/> -->
    </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"
    />
  </div>
</template>

<script>
import {
  listpayable,
  listWhgenleg,
  getWhgenleg,
  delWhgenleg,
  addWhgenleg,
  updateWhgenleg,
  exportWhgenleg
} from '@/api/reportManagement/profit'
import { listWarehouse } from '@/api/basicdata/warehouse'
import { listArea } from '@/api/basicdata/area'
import { listGoods } from '@/api/basicdata/goods'
import { listCorps } from '@/api/basicdata/corps'
import { listFees } from '@/api/basicdata/fees'
import { addSet, select, resetModule } from "@/api/system/set";
import Cookies from "js-cookie";
import draggable from "vuedraggable";

export default {
  name: 'profitGeneralLedger',
  components: {draggable},
  data() {
    return {
      //费用名称
      fWbuOptions:[],
      businessInTypeOption:[],
      businessOutTypeOption:[],
      businessTransTypeOption:[],
      businessTypeOption: [],
      // 货权方(客户数据)
      fMblnoOptions: [],
      // 贸易方式(数据字典),对应t_trademodels 字典
      fTrademodeidOptions: [],
      // 货物
      goodsOptions: [],
      // 仓库(仓库数据)
      warehouseOptions: [],
      kqhouseOptions: [],
      // 遮罩层
      loading: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // 库存总账表格数据
      receivableList: [],
      // 弹出层标题
      title: '',
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 50,
        fCorpid: null,
        fMblno: null,
        timeExamine: null,
        fToCorpid: null,
        fProductName: null,
        fMarks: null,
        fReconciliation: null,
        fBillstatus: null,
        fBusinessType:null,
        fFeeid:null
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
        fMarks: [
          { required: true, message: '唛头不能为空', trigger: 'blur' }
        ]
      },
      showSetting: false,
      drag: false,
      setRowList: [],
      getRowList: [],
      tableDate: [
        {
          surface: "1",
          label: "fName",
          name: "货权方",
          checked: 0,
          width: 150,
        },
        {
          surface: "2",
          label: "fFeesName",
          name: "结算单位",
          checked: 0,
          width: 120,
        },
        {
          surface: "3",
          label: "fMblno",
          name: "提单号",
          checked: 0,
          width: 150,
        },
        {
          surface: "4",
          label: "fProductName",
          name: "货物名称",
          checked: 0,
          width: 150,
        },
        {
          surface: "5",
          label: "fMarks",
          name: "品牌",
          checked: 0,
          width: 150,
        },
        {
          surface: "6",
          label: "fReviewDate",
          name: "审核日期",
          checked: 0,
          width: 150,
        },
        {
          surface: "7",
          label: "fAmount",
          name: "应收金额",
          checked: 0,
          width: 120,
        },
        {
          surface: "8",
          label: "fStlamount",
          name: "应付金额",
          checked: 0,
          width: 120,
        },
        {
          surface: "9",
          label: "nnfinished",
          name: "利润",
          checked: 0,
          width: 120,
        }
      ],
      allCheck: false,
    }
  },
  created() {
    this.setRowList = this.tableDate;
    this.getRowList = this.tableDate;
    /* 远程模糊查询费用名称 */
    this.fWRemoteMethod()
    let this_ = this
    this_.getList()
    this_.getDicts('data_trademodes').then((response) => {
      this_.fTrademodeidOptions = response.data
    })
    this_.getDicts('st_in_type').then((response) => {
      this_.businessInTypeOption = response.data
      this_.getDicts('st_out_type').then((response) => {
        this_.businessOutTypeOption = response.data
        this_.getDicts('st_trans_type').then((response) => {
          this_.businessTransTypeOption = response.data
          this_.merge(this_.businessOutTypeOption,this_.businessInTypeOption,this_.businessTransTypeOption)
        })
      })
    })
    this.getRow();
  },
  methods: {
    //列设置全选
    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 === 7 || index === 8 || index === 9) {
          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)
          }
        }
      })
      return sums
    },

    // 贸易方式(数据字典),对���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
      })
    },
    /* 远程模糊查询费用名称 */
    fWRemoteMethod(name) {
      // if (name == null || name === "") {
      //   return false;
      // }
      let queryParams = { pageNum: 1, fName: name };
      console.log(queryParams)
      listFees(queryParams).then((response) => {
        this.fWbuOptions = response.rows
        console.log(response)
      });
    },
    /* 远程模糊查询库区 */
    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
      })
    },
    merge(index,list,err){
      this.businessTypeOption = this.businessTypeOption.concat(index,list,err)
    },
    /** 查询库存总账列表 */
    getList() {
      this.loading = true
      this.getDicts('approval_process').then((response) => {
        this.options = response.data
      })
      listpayable(this.queryParams).then(response => {
        this.receivableList = 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,
        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.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">
.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>