<template>
|
<div class="app-container">
|
<div class="filter-container">
|
<div style="display: block;">
|
<span>查询时间:</span>
|
<el-date-picker
|
value-format="yyyy-MM-dd"
|
v-model="listQuery.filter.specificDate"
|
type="date"
|
>
|
</el-date-picker>
|
<span>安全监管分类:</span>
|
<el-select v-model="listQuery.filter.safetysupervision" clearable filterable>
|
<el-option value="" label="全部">
|
</el-option>
|
<el-option
|
v-for="item in safetysupervision"
|
:key="item"
|
:label="item"
|
:value="item"
|
>
|
</el-option>
|
</el-select>
|
<span>企业名称:</span>
|
<el-input filterable clearable v-model="listQuery.filter.enterprisename" style="width:200px">
|
</el-input>
|
<el-button style="margin-left: 10px;" type="primary" icon="el-icon-search" @click="search()">查询</el-button>
|
<el-button style="margin-left: 10px;" type="primary" icon="el-icon-download" @click="exportToExcel">导出</el-button>
|
</div>
|
</div>
|
<div class="table_content">
|
<el-table
|
v-loading="listLoading"
|
:data="tableData"
|
border
|
fit
|
highlight-current-row
|
style="width: 100%;"
|
>
|
<el-table-column label="序号" type="index" align="center" width="60"/>
|
<el-table-column label="地区" prop="city" align="center">
|
</el-table-column>
|
<el-table-column label="库存总数(箱)" prop="stocknum" align="center">
|
</el-table-column>
|
<el-table-column label="爆竹类(箱)" prop="firecracker" align="center">
|
</el-table-column>
|
<el-table-column label="喷花类(箱)" prop="spray" align="center">
|
</el-table-column>
|
<el-table-column label="旋转类(箱)" prop="rotation" align="center">
|
</el-table-column>
|
<el-table-column label="吐珠类(箱)" prop="bead" align="center">
|
</el-table-column>
|
<el-table-column label="玩具类(箱)" prop="toy" align="center">
|
</el-table-column>
|
<el-table-column label="组合烟花类(箱)" prop="combined" align="center">
|
</el-table-column>
|
</el-table>
|
<br>
|
<el-pagination
|
v-show="recordTotal>0"
|
:current-page="listQuery.pageIndex"
|
:page-sizes="[10, 20, ]"
|
:page-size="listQuery.pageSize"
|
:total="recordTotal"
|
layout="total, sizes, prev, pager, next, jumper"
|
background
|
style="float:right;"
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
/>
|
<br>
|
</div>
|
</div>
|
</template>
|
|
|
<script>
|
import {getHistoryCityStock} from "@/api/stock";
|
import { computePageCount } from "@/utils";
|
import Cookies from 'js-cookie'
|
export default {
|
name: 'cityStock',
|
data(){
|
return{
|
pageSize: 20,
|
recordTotal: 0,
|
pageTotal: 0,
|
currentDate:"",
|
listLoading:false,
|
tableData:[],
|
isSupervision : Cookies.get('isSupervision'),
|
safetysupervision:[
|
"烟花爆竹生产",
|
"烟花爆竹批发经营",
|
"烟花爆竹零售经营(短期)",
|
"烟花爆竹零售经营(长期)",
|
],
|
listQuery: {
|
pageSize:20,
|
pageIndex:1,
|
filter: {
|
specificDate:'',
|
province: '',
|
city:"",
|
district:"",
|
},
|
},
|
}
|
},
|
created(){
|
this.initCurrentDate()
|
this.getHistoryCityStock()
|
if (this.isSupervision === 'null'){
|
this.listQuery.filter.safetysupervision = "烟花爆竹批发经营"
|
}
|
},
|
methods:{
|
handleSizeChange(val) {
|
this.listQuery.pageSize = val
|
this.getHistoryCityStock()
|
},
|
handleCurrentChange(val) {
|
this.listQuery.pageIndex = val
|
this.getHistoryCityStock()
|
},
|
search(){
|
this.getHistoryCityStock()
|
|
},
|
getHistoryCityStock(){
|
if(this.listQuery.filter.specificDate == null)
|
this.initCurrentDate()
|
|
this.listLoading = true
|
getHistoryCityStock(this.listQuery).then(res=>{
|
if (res.data.code === '200') {
|
this.tableData = res.data.result.records
|
this.recordTotal = res.data.result.total
|
this.pageTotal = computePageCount(res.data.result.total, res.data.result.size)
|
}else{
|
this.$message({
|
type:'warning',
|
message:res.data.message
|
})
|
}
|
})
|
.finally(res=>{
|
this.listLoading = false
|
})
|
},
|
initCurrentDate(){
|
let now = new Date();
|
let year = now.getFullYear(); //得到年份
|
let month = now.getMonth(); //得到月份
|
let date = now.getDate(); //得到日期
|
month = month + 1;
|
month = month.toString().padStart(2, "0");
|
date = date.toString().padStart(2, "0");
|
let defaultDate = `${year}-${month}-${date}`;
|
this.$set(this.listQuery.filter, "specificDate", defaultDate);
|
},
|
formatJson(filterVal, jsonData) {
|
return jsonData.map(v => filterVal.map(j => v[j]))
|
},
|
async exportToExcel(){
|
if(this.listQuery.filter.specificDate == null)
|
this.initCurrentDate()
|
|
this.listQuery.pageSize = 20
|
let res = await getHistoryCityStock(this.listQuery)
|
if(res.data.code === '200'){
|
if(res.data.result === null ||res.data.result === [] || res.data.result.length === 0){
|
this.$message({
|
type:'warning',
|
message:'无数据可导出'
|
})
|
}else{
|
let allData = res.data.result.records
|
import('@/vendor/Export2Excel').then((excel) => {
|
const tHeader = [
|
'地区',
|
'库存总数(箱)',
|
'爆竹类(箱)',
|
'喷花类(箱)',
|
'旋转类(箱)',
|
'吐珠类(箱)',
|
'玩具类(箱)',
|
'组合烟花类(箱)',
|
|
]
|
const filterVal = [
|
'city',
|
'stocknum',
|
"firecracker",
|
'spray',
|
'rotation',
|
'bead',
|
'toy',
|
'combined'
|
]
|
const data = this.formatJson(filterVal, allData)
|
excel.export_json_to_excel({
|
header: tHeader,
|
data,
|
filename: '各地州历史库存统计'
|
})
|
})
|
}
|
|
}else{
|
this.$message({
|
message:res.data.message,
|
type:'warning'
|
})
|
}
|
},
|
|
|
|
}
|
}
|
</script>
|
|
<style scoped>
|
|
</style>
|