<!-- 库存报表 -->
|
<template>
|
<div class="rightContent">
|
<div class="top">
|
<SearchCommonView
|
:showAdd="false"
|
:add-title="'新建'"
|
:placeholder="'请输入产品名称或产品类别'"
|
:amount-view="false"
|
@addCommonClick="addBtnClick"
|
@searchClick="getList"
|
:isDisabled="true"
|
:showDownload="true"
|
@downloadClick="downHttpClick"
|
/>
|
</div>
|
<div class="content_wrap">
|
<div class="con_left">
|
<div class="con_left_div">
|
<p>仓库</p>
|
<div class="stash">
|
<template>
|
<el-radio v-for="(item, index) in warehouseList" :key="index" v-model="stashRadio" :label="item.code" @change="radioHandleChange(item)">
|
<el-tooltip class="item" effect="dark" :content="item.name" placement="bottom">
|
<span class="radio-text">{{ item.name }}</span>
|
</el-tooltip>
|
</el-radio>
|
</template>
|
</div>
|
</div>
|
<div class="con_left_div">
|
<p>类别</p>
|
<div class="category">
|
<el-tree node-key="id" :data="categoryList" show-checkbox :props="treeProps" @check="checkListHandler"></el-tree>
|
<!-- <el-checkbox-group v-model="checkList" @change="checkListHandler">
|
<el-checkbox v-for="item in categoryList" :key="item.id" :label="item.id">
|
<el-tooltip class="item" effect="dark" :content="item.name" placement="bottom">
|
<span class="radio-text">{{ item.name }}</span>
|
</el-tooltip>
|
</el-checkbox>
|
</el-checkbox-group> -->
|
</div>
|
</div>
|
</div>
|
<div class="list-view">
|
<div class="table">
|
<TableCommonView
|
ref="tableListRef"
|
:table-list="tableList"
|
@selTableCol="selTableCol"
|
@tableRowClick="tableRowClick"
|
:showSummary="true"
|
>
|
<template slot="tableButton">
|
<el-table-column label="在库" prop='amount'>
|
<el-table-column v-for="unit in unitList" :label="unit.name" prop='availableNumber' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.amountMoreUnits,unit.name,scope.row.amount,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
|
</el-table-column>
|
<el-table-column label="可用库存" prop='availableNumber'>
|
<el-table-column v-for="unit in unitList" :label="unit.name" prop='amount' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.availableNumberMoreUnits,unit.name,scope.row.availableNumber,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<!-- <el-table-column label="件" prop='availableNumber' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.availableNumberMoreUnits,'件',scope.row.availableNumber,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="匹" prop='availableNumber' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.availableNumberMoreUnits,'匹',scope.row.availableNumber,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="米数" prop='availableNumber' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.availableNumberMoreUnits,'米数',scope.row.availableNumber,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="重量" prop='availableNumber' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.availableNumberMoreUnits,'重量',scope.row.availableNumber,scope.row.unit)}}
|
</template>
|
</el-table-column>-->
|
</el-table-column>
|
<el-table-column label="入库" prop='in'>
|
<el-table-column v-for="unit in unitList" :label="unit.name" prop='in' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.inMoreUnits,unit.name,scope.row.in,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<!--<el-table-column label="件" prop='in' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.inMoreUnits,'件',scope.row.in,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="匹" prop='in' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.inMoreUnits,'匹',scope.row.in,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="米数" prop='in' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.inMoreUnits,'米数',scope.row.in,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="重量" prop='in' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.inMoreUnits,'重量',scope.row.in,scope.row.unit)}}
|
</template>
|
</el-table-column>-->
|
</el-table-column>
|
<el-table-column label="出库" prop='out'>
|
<el-table-column v-for="unit in unitList" :label="unit.name" prop='out' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.outMoreUnits,unit.name,scope.row.out,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<!--<el-table-column label="件" prop='out' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.outMoreUnits,'件',scope.row.out,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="匹" prop='out' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.outMoreUnits,'匹',scope.row.out,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="米数" prop='out' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.outMoreUnits,'米数',scope.row.out,scope.row.unit)}}
|
</template>
|
</el-table-column>
|
<el-table-column label="重量" prop='out' min="90">
|
<template slot-scope="scope">
|
{{getUnitValue(scope.row.outMoreUnits,'重量',scope.row.out,scope.row.unit)}}
|
</template>
|
</el-table-column>-->
|
</el-table-column>
|
<el-table-column label="操作" width="220" align="center">
|
<template slot-scope="scope">
|
<span @click="handleHistoryClick(scope.row)" class="yes-cursor">
|
<i class="el-icon-refresh-left"></i>
|
<span>历史</span>
|
</span>
|
<span @click="handleAddGoods(scope.row)" class="margin_left_5px;" style="cursor: pointer">
|
<i class="el-icon-refresh"></i>
|
<span>补货</span>
|
</span>
|
<template>
|
<span @click="handleLocation(scope)" class="margin_left_5px yes-cursor">
|
<i class="el-icon-menu"></i>
|
<span>位置</span>
|
</span>
|
<span @click="handleForecast(scope)" class="margin_left_5px no-cursor">
|
<i class="el-icon-s-data"></i>
|
<span>预测</span>
|
</span>
|
</template>
|
</template>
|
</el-table-column>
|
</template>
|
</TableCommonView>
|
</div>
|
<div class="btn-pager">
|
<PagerView class="page" :pager-options="pagerOptions" :page-size="pageSizes" v-on="pagerEvents" />
|
</div>
|
</div>
|
|
</div>
|
<!-- 编辑 dialog-->
|
<AddOverviewDialog v-if="editConfig.visible" :edit-common-config="editConfig" :add-name="this.$route.params.name" />
|
</div>
|
</template>
|
|
<script>
|
import pageMixin from "@/components/makepager/pager/mixin/pageMixin"
|
import AddOverviewDialog from "@/views/overview/AddOverviewDialog"
|
import { getInventoryData, getProductCategoryList, getWarehouseList } from "@/api/reportForm/inventoryRwport"
|
import { downloadInventoryForms } from "@/api/downFile"
|
import FileSaver from 'file-saver';
|
import axios from 'axios';
|
import _ from 'lodash'
|
import {getUnitInfo} from "@/api/basic/standard";
|
export default {
|
name: "inventoryReport",
|
props: {},
|
components: { AddOverviewDialog },
|
mixins: [pageMixin],
|
computed: {},
|
data() {
|
return {
|
unitList:[],
|
keyword: "",
|
treeProps: {
|
label: 'name',
|
value: 'id',
|
children: 'children',
|
},
|
checkList: [],
|
testArr: [],
|
testArr2: [
|
{
|
product: "南方丝巢xxx", //产品
|
category: "丝绸制品/真丝睡袍", // 产品类别
|
cost: "100.00", //单位成本
|
inStore: "12.00", // 在库
|
totalPrices: 10, // 总价值
|
availableStore: "0.00", //可用库存
|
inStorage: "100.00", // 入库
|
toStore: "20.00", // 出库
|
forecast: "0.00", //预测
|
unit: "件" //单位
|
},
|
{
|
product: "南方丝巢12306xxx",
|
category: "丝绸制品/真丝睡袍",
|
cost: "9980.00",
|
totalPrices: "0.00",
|
inStore: "10.00",
|
availableStore: "0.00",
|
inStorage: "0.00",
|
toStore: "0.00",
|
forecast: "0.00",
|
unit: "件"
|
}
|
],
|
tableList: {},
|
showcol: ["产品类别", "单位成本", "总价值", "入库", "出库"],
|
countcol: ["总价值", "在库", "可用库存", "入库", "出库", "预测"],
|
searchOptions: [],
|
commonDetail: {
|
visible: false,
|
title: "新建",
|
infomation: {}
|
},
|
editConfig: {
|
visible: false,
|
title: "新建",
|
infomation: {}
|
},
|
productId: this.$route.params.id,
|
productName: this.$route.params.name,
|
categoryList: [], // 类别
|
categoryListId: [], //类别id
|
warehouseList: [], // 仓库
|
warehouseListName: "", // 仓库名称
|
stashRadio: "1",
|
pageSizes: [15, 30],
|
oldRadioBtn: "",
|
metaTitle: this.$route.meta.title,
|
searchStr: this.$route.params.name ?? ""
|
}
|
},
|
created() {
|
this.setTable()
|
this.getData() //库存报表
|
this.getStashData() // 仓库列表数据
|
this.getProductCategoryList()
|
},
|
mounted() {
|
this.countSums();
|
this.getUnitInfo();
|
},
|
methods: {
|
async getUnitInfo(){
|
const { code,data }=await getUnitInfo();
|
if(code===200){
|
this.unitList=data;
|
}
|
},
|
getUnitValue(list,val,num,unit){
|
let string='--'
|
if(list){
|
if(list.length>0){
|
for(let i in list){
|
if(list[i].unit==val){
|
string=list[i].amount
|
break;
|
}
|
}
|
}
|
}
|
if(unit==val){
|
string=num
|
}
|
if(string.length>6){
|
return string.substring(0,6);
|
}
|
return string
|
},
|
// 下载
|
downHttpClick: _.debounce(function(){
|
let token = document.cookie.replace(
|
/(?:(?:^|.*;\s*)token\s*=\s*([^;]*).*$)|^.*$/,
|
"$1",
|
);
|
/*axios({
|
url: "/api-wms/v1/forms/downloadInventoryForms",
|
method: "post",
|
methodType:'down',
|
headers:{
|
Authorization:"Bearer " + token
|
},
|
data:{
|
page: this.pagerOptions.currPage,
|
pageSize: this.pagerOptions.pageSize,
|
keyword:this.keyword,
|
}
|
}).then(res=>{
|
console.log(decodeURIComponent(res.headers['content-disposition'].split(';')[1].split('filename=')[1]));
|
})*/
|
downloadInventoryForms({
|
page: this.pagerOptions.currPage,
|
pageSize: this.pagerOptions.pageSize,
|
keyword:this.keyword,
|
baseOperationType:1
|
}).then(res => {
|
if (res) {
|
FileSaver.saveAs(res, '库存报表.xlsx');
|
this.$message.success("下载成功！");
|
}
|
})
|
}, 1000),
|
checkListHandler(_, checkObj) {
|
this.categoryListId = checkObj.checkedKeys
|
this.getData()
|
},
|
radioHandleChange(e) {
|
this.warehouseListName = e.id
|
this.getData()
|
},
|
// checkRadio(val){
|
// console.log(val)
|
// val == this.stashRadio ? this.stashRadio = '' : this.stashRadio = val
|
// this.warehouseListName = val
|
// this.getData()
|
// },
|
setTable() {
|
if (this.isIconIndex === "1") {
|
this.pageSizes = [30, 60]
|
this.pagerOptions.pageSize = 30
|
}
|
this.tableList = {
|
tableInfomation: [],
|
selectBox: false,
|
selectIndex: true,
|
showcol: this.showcol,
|
countcol: this.countcol,
|
allcol: [],
|
tableColumn: this.setTableColumn(this.showcol)
|
}
|
// this.tableList.tableInfomation = this.testArr;
|
let allcol = []
|
for (let i = 0; i < this.tableList.tableColumn.length; i++) {
|
if (!this.tableList.tableColumn[i].default) {
|
const label = this.tableList.tableColumn[i].label
|
allcol.push(label)
|
}
|
}
|
this.tableList.allcol = allcol
|
},
|
setTableColumn(showcol) {
|
let tableColumn = [
|
{
|
label: "产品",
|
prop: "productName",
|
default: true,
|
width: 300,
|
isShowColumn: true
|
// date: true, // 是否为日期格式
|
},
|
{
|
label: "产品规格",
|
prop: "productSpecs",
|
default: true,
|
width: 100,
|
isShowColumn: true
|
// date: true, // 是否为日期格式
|
},
|
{
|
label: "产品型号",
|
prop: "productType",
|
default: true,
|
width: 100,
|
isShowColumn: true
|
// date: true, // 是否为日期格式
|
},
|
{
|
label: "产品类别",
|
prop: "productCategory",
|
default: true,
|
isShowColumn: showcol.includes("产品类别")
|
},
|
{
|
label: "单位成本",
|
prop: "cost",
|
default: false,
|
isShowColumn: showcol.includes("单位成本"),
|
textAlign: "right"
|
},
|
{
|
label: "总价值",
|
prop: "value",
|
default: false,
|
isShowColumn: showcol.includes("总价值"),
|
unit: "￥",
|
textAlign: "right"
|
},
|
/*{
|
label: "在库",
|
prop: "amount",
|
default: true,
|
isShowColumn: true,
|
unit: "",
|
textAlign: "right"
|
},
|
{
|
label: "可用库存",
|
prop: "availableNumber",
|
default: true,
|
isShowColumn: true,
|
unit: "",
|
textAlign: "right"
|
},
|
{
|
label: "入库",
|
prop: "in",
|
default: false,
|
isShowColumn: showcol.includes("入库"),
|
unit: "",
|
textAlign: "right"
|
},
|
{
|
label: "出库",
|
prop: "out",
|
isShowColumn: showcol.includes("出库"),
|
default: false,
|
unit: "",
|
textAlign: "right"
|
},*/
|
{
|
label: "预测",
|
prop: "forecast",
|
isShowColumn: showcol.includes("预测"),
|
default: false,
|
unit: ""
|
},
|
/*{
|
label: "单位",
|
prop: "unit",
|
default: true,
|
isShowColumn: true
|
}*/
|
]
|
return tableColumn
|
},
|
selTableCol(val) {
|
this.showcol = val
|
this.tableList.tableColumn = this.setTableColumn(val)
|
},
|
getList(val) {
|
this.searchStr = val
|
this.getData()
|
},
|
// 行点击
|
tableRowClick(row) {
|
console.log(row)
|
// this.editConfig.visible = true;
|
this.editConfig.title = "查看"
|
this.editConfig.infomation = { ...row }
|
},
|
// 新建
|
addBtnClick() {
|
// this.editConfig.visible = true;
|
// this.editConfig.title = "新建"
|
// this.getData()
|
},
|
// 状态
|
getStatus(val) {
|
return val === 1 ? "草稿" : val === 3 ? "就绪" : "完成"
|
},
|
// 历史
|
handleHistoryClick(row) {
|
this.$router.push({
|
name: "inboundOutboundDetail",
|
params: {
|
keyWord: row.productName,
|
produceId: row.produceId,
|
unit: row.unit,
|
productName: row.productName,
|
name: "报表"
|
}
|
})
|
},
|
|
// 补货
|
handleAddGoods(row) {
|
this.$router.push({
|
name: "orderPoint",
|
params: {
|
productId: row.produceId
|
}
|
})
|
},
|
// 位置
|
handleLocation(row) {
|
this.$router.push({
|
name: "locationReport",
|
params: {
|
// keyWord:row.row.productName,
|
wareHouseCode: this.warehouseListName,
|
productId: row.row.produceId,
|
name: "库存报表"
|
}
|
})
|
},
|
// 预测
|
handleForecast() {},
|
//总价计算
|
countSums() {
|
this.testArr2.map((item) => {
|
let obj = {
|
product: item.product, //产品
|
category: item.category, // 产品类别
|
cost: item.cost, //单位成本
|
inStore: item.inStore, // 在库
|
totalPrices: item.cost * item.inStore, // 总价值
|
availableStore: item.availableStore, //可用库存
|
inStorage: item.inStorage, // 入库
|
toStore: item.toStore, // 出库
|
forecast: item.forecast, //预测
|
unit: item.unit //单位
|
}
|
this.testArr.push(obj)
|
})
|
},
|
|
//接口请求-----------------------------------------------------------------------------------------------
|
// 获取库存报表数据
|
async getInventoryData(params) {
|
await getInventoryData(params).then((res) => {
|
if (res.code === 200) {
|
const list = res.data
|
this.tableList.tableInfomation = list || []
|
this.pagerOptions.totalCount = res.total
|
}
|
})
|
},
|
getData() {
|
let params = {
|
keyWord: this.searchStr,
|
categoryIds: this.categoryListId,
|
page: this.pagerOptions.currPage,
|
pageSize: this.pagerOptions.pageSize,
|
warehouseId: this.warehouseListName||0
|
}
|
this.getInventoryData(params)
|
},
|
getTreeData(dataList, childFieldName = 'children', pIdFieldName = 'parentId', idFieldName = 'id', rootValue = 0) {
|
const rootArr = []
|
//1.先获取根节点列表
|
dataList.forEach((item) => {
|
const children = getChildrenNode(item[idFieldName], dataList)
|
if (Array.isArray(children) && children.length > 0) {
|
item[childFieldName] = children
|
}
|
if (!item.isParent) {
|
rootArr.push(item)
|
}
|
})
|
//2.递归获取根节点的所有下级节点
|
function getChildrenNode(parentId, dataList) {
|
//1.根据根节点获取 子节点列表
|
const childrenArr = dataList.filter((item) => parentId === item[pIdFieldName])
|
//2.孩子有可能还有孩子 遍历孩子进行重新递归
|
childrenArr.forEach((item) => {
|
const children = getChildrenNode(item[idFieldName], dataList)
|
if (children.length > 0) {
|
item[childFieldName] = children
|
}
|
})
|
return childrenArr
|
}
|
return rootArr
|
},
|
// 获取产品类型列表数据
|
async getProductCategoryList() {
|
await getProductCategoryList({
|
keyWord: "",
|
page: 0,
|
pageSize: 0
|
}).then((res) => {
|
if (res.code === 200) {
|
this.categoryList = res.data;
|
(res.data||[]).forEach((item,index1)=>{
|
item.isParent=res.data.some((cItem,index2)=>{
|
if(index1!==index2){
|
return item.parentId==cItem.id;
|
}
|
});
|
});
|
this.categoryList = this.getTreeData(res.data)
|
}
|
})
|
},
|
// 请求仓库列表数据
|
async getStashData() {
|
await getWarehouseList({
|
keyword: "",
|
page: this.pagerOptions.currPage,
|
pageSize: this.pagerOptions.pageSize
|
}).then((res) => {
|
if (res.code === 200) {
|
this.warehouseList = res.data
|
|
|
}
|
})
|
}
|
}
|
}
|
</script>
|
|
<!-- Add "scoped" attribute to limit CSS to this component only -->
|
<style lang="scss" scoped>
|
.radio-text{
|
display:inline-block;
|
width: 100%;
|
overflow: hidden;
|
white-space: nowrap;
|
text-overflow: ellipsis;
|
}
|
.content_wrap {
|
height: calc(100% - 0px);
|
display: flex;
|
justify-content: start;
|
.con_left {
|
height: calc(100% - 90px);
|
width: 15%;
|
overflow: hidden;
|
.con_left_div {
|
height: 50%;
|
border: 1px solid rgba(0, 0, 0, 0);
|
.stash,
|
.category {
|
height: calc(100% - 52px);
|
display: flex;
|
flex-direction: column;
|
overflow: auto;
|
}
|
}
|
}
|
.list-view {
|
width: 85%;
|
flex: 1;
|
}
|
}
|
::v-deep {
|
.el-checkbox {
|
padding: 5px;
|
}
|
.el-checkbox__label {
|
width: 95%;
|
box-sizing: border-box;
|
padding-right: 5px;
|
word-break: break-all;
|
word-wrap: break-word;
|
white-space: pre-wrap !important;
|
}
|
.el-tree {
|
background: no-repeat;
|
}
|
.el-tree-node > .el-tree-node__children {
|
overflow: visible !important;
|
}
|
.el-tree-node__content:hover,
|
.el-upload-list__item:hover {
|
width: 100%;
|
}
|
}
|
</style>
|
