<template>
|
<div class="app-container">
|
<div class="filter-container">
|
<div style="display: block;">
|
<div class="basic_search" style="padding-top: 10px;">
|
<span>按时间查询：</span>
|
<el-date-picker
|
value-format="yyyy-MM-dd HH:mm:ss"
|
v-model="validTime"
|
type="datetimerange"
|
:default-time="['00:00:00','23:59:59']"
|
:picker-options="pickerOptions"
|
range-separator="-"
|
start-placeholder="开始日期"
|
end-placeholder="结束日期"
|
>
|
</el-date-picker>
|
</div>
|
<div class="basic_search" style="padding-top: 10px;margin-left: 15px">
|
<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>
|
</div>
|
<div class="basic_search" style="padding-top: 10px">
|
<span>企业名称：</span>
|
<el-input filterable clearable v-model="listQuery.filter.enterprisename" style="width:200px">
|
</el-input>
|
</div>
|
<div class="basic_search" style="margin-right: 10px">
|
<el-button style="margin-left: 10px;" type="primary" @click="reset()">重置</el-button>
|
<el-button style="margin-left: 10px;" type="primary" icon="el-icon-search" @click="searchProductSearch('查询','')">查询</el-button>
|
<el-button style="margin-left: 10px;" type="primary" icon="el-icon-download" @click="exportToExcel">导出</el-button>
|
</div>
|
</div>
|
</div>
|
<div class="table_content">
|
<el-table
|
v-loading="listLoading"
|
:key="tableKey"
|
:data="personPurchaseData"
|
border
|
fit
|
highlight-current-row
|
style="width: 100%;"
|
>
|
<el-table-column label="序号" type="index" align="center" width="60"/>
|
<el-table-column label="地区" prop="name" align="center">
|
<template slot-scope="scope">
|
<el-link type="primary" v-if="scope.row.name !== '合计'" @click="showCityDetail(scope.row.name)">{{ scope.row.name }}</el-link>
|
<span v-if="scope.row.name === '合计'">合计</span>
|
</template>
|
</el-table-column>
|
<el-table-column label="爆竹类（箱）" prop="num_爆竹类" align="center">
|
</el-table-column>
|
<el-table-column label="喷花类（箱）" prop="num_喷花类" align="center">
|
</el-table-column>
|
<el-table-column label="旋转类（箱）" prop="num_旋转类" align="center">
|
</el-table-column>
|
<el-table-column label="吐珠类（箱）" prop="num_吐珠类" align="center">
|
</el-table-column>
|
<el-table-column label="玩具类（箱）" prop="num_玩具类" align="center">
|
</el-table-column>
|
<el-table-column label="组合烟花类（箱）" prop="num_组合烟花类" align="center">
|
</el-table-column>
|
<el-table-column label="合计（箱）" prop="totalcol" align="center">
|
</el-table-column>
|
<el-table-column label="总人数" prop="personnum" align="center">
|
</el-table-column>
|
</el-table>
|
<br>
|
<el-pagination
|
v-show="recordTotal>0"
|
:current-page="currentPage"
|
:page-sizes="[20, 50, 100, 200]"
|
:page-size="pageSize"
|
:total="recordTotal"
|
layout="total, sizes, prev, pager, next, jumper"
|
background
|
style="float:right;"
|
@size-change="handleSizeChange"
|
@current-change="handleCurrentChange"
|
/>
|
<br>
|
</div>
|
<citySaleDetail ref="citySale"></citySaleDetail>
|
</div>
|
</template>
|
|
<script>
|
import citySaleDetail from './citySaleDetail/index'
|
import { computePageCount } from "../../utils";
|
import {exportCity, getCitySaleStatistics} from "../../api/productPurchaseSearch";
|
import Cookies from "js-cookie";
|
export default {
|
name: "citySaleStatistics",
|
data(){
|
return{
|
tableKey:'',
|
validTime:['',''],
|
listQuery: {
|
pageSize:20,
|
pageIndex:1,
|
filter: {
|
starttime: '',
|
endtime: '',
|
enterprisename: '',
|
safetysupervision:"",
|
},
|
},
|
safetysupervision:[
|
"烟花爆竹生产",
|
"烟花爆竹批发经营",
|
"烟花爆竹零售经营（短期）",
|
"烟花爆竹零售经营（长期）",
|
],
|
Cookies:Cookies,
|
pageSize: 20,
|
recordTotal: 0,
|
currentPage: 1,
|
pageTotal: 0,
|
listLoading:false,
|
personPurchaseData:[],
|
previewList:[],
|
options: [
|
{ label: '全部', value: '' },
|
{ label: '是', value:1 },
|
{ label: '否', value: -1 }
|
],
|
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]);
|
}
|
}]
|
},
|
}
|
},
|
components:{
|
citySaleDetail
|
},
|
created() {
|
this.initValidTime()
|
this.getPersonProductList()
|
},
|
watch: {
|
},
|
methods:{
|
async getPersonProductList(){
|
this.listLoading = true
|
if( this.validTime !== null ){
|
this.listQuery.filter.starttime = this.validTime[0]
|
this.listQuery.filter.endtime = this.validTime[1]
|
}else{
|
this.listQuery.filter.starttime = ''
|
this.listQuery.filter.endtime = ''
|
}
|
let res = await getCitySaleStatistics(this.listQuery)
|
if(res.data.code === "200"){
|
this.recordTotal = res.data.result.total
|
this.pageSize = res.data.result.size
|
this.pageTotal = computePageCount(res.data.result.total, res.data.result.size)
|
this.personPurchaseData = res.data.result.records
|
}else{
|
this.$message({
|
type:'warning',
|
message:res.data.message
|
})
|
}
|
this.listLoading = false
|
},
|
showCityDetail(city){
|
this.$refs.citySale.showCitySaleDetail(this.listQuery.filter.starttime,this.listQuery.filter.endtime,this.listQuery.filter.enterprisename,this.listQuery.filter.safetysupervision,city)
|
},
|
refresh(){
|
this.getPersonProductList()
|
},
|
async exportToExcel(){
|
let res = await exportCity(this.listQuery)
|
if(res.data.code === '200'){
|
if(res.data.result === null ||res.data.result === [] || res.data.result.length === 0){
|
debugger
|
this.$message({
|
type:'warning',
|
message:'无数据可导出'
|
})
|
}else{
|
let allData = res.data.result
|
import('@/vendor/Export2Excel').then((excel) => {
|
const tHeader = [
|
'地区',
|
'爆竹类（箱）',
|
'喷花类（箱）',
|
'旋转类（箱）',
|
'吐珠类（箱）',
|
'玩具类（箱）',
|
'组合烟花类（箱）',
|
'合计（箱）',
|
'总人数',
|
]
|
const filterVal = [
|
'name',
|
'num_爆竹类',
|
'num_喷花类',
|
'num_旋转类',
|
'num_吐珠类',
|
'num_玩具类',
|
'num_组合烟花类',
|
'totalcol',
|
'personnum'
|
]
|
const data = this.formatJson(filterVal, allData)
|
excel.export_json_to_excel({
|
header: tHeader,
|
data,
|
filename: '地州市分类销售统计'
|
})
|
})
|
}
|
|
}else{
|
this.$message({
|
message:res.data.message,
|
type:'warning'
|
})
|
}
|
},
|
|
formatJson(filterVal, jsonData) {
|
return jsonData.map(v => filterVal.map(j => v[j]))
|
},
|
|
reset(){
|
this.listQuery= {
|
pageSize: 10,
|
pageIndex: 1,
|
filter: {
|
starttime: '',
|
endtime: '',
|
identify: '',
|
enterprisename: '',
|
parententerprisename:'',
|
itemcode:'',
|
},
|
}
|
},
|
|
searchProductSearch(){
|
this.getPersonProductList()
|
},
|
|
handleSizeChange(val) {
|
this.listQuery.pageSize = val
|
this.getPersonProductList()
|
},
|
handleCurrentChange(val) {
|
this.listQuery.pageIndex = val
|
this.getPersonProductList()
|
},
|
initValidTime(){
|
const end = new Date();
|
if(end.getDate() - 1 === 0){
|
this.validTime[0] = [end.getFullYear(), end.getMonth() , this.returnDay(end.getMonth(),end.getFullYear())].join("-") + " 00:00:00" ;
|
this.validTime[1] = [end.getFullYear(), end.getMonth() , this.returnDay(end.getMonth(),end.getFullYear())].join("-") +" 23:59:59";
|
}else if(end.getDate() - 1 === 0 && end.getMonth() === 0){
|
this.validTime[0] = [end.getFullYear() - 1, 12, 31].join("-") + " 00:00:00" ;
|
this.validTime[1] = [end.getFullYear() - 1, 12, 31].join("-") +" 23:59:59";
|
}
|
else{
|
this.validTime[0] = [end.getFullYear(), end.getMonth() + 1, end.getDate() - 1].join("-") + " 00:00:00" ;
|
this.validTime[1] = [end.getFullYear(), end.getMonth() + 1, end.getDate() - 1].join("-") +" 23:59:59";
|
}
|
},
|
returnDay(value,year){
|
if(value === 1 || value === 3|| value === 5 || value === 7 || value === 8 || value === 10 || value === 12){
|
return 31
|
}else if(value === 2){
|
if(year % 4 === 0){
|
return 29
|
}else{
|
return 28
|
}
|
}else{
|
return 30
|
}
|
}
|
},
|
}
|
</script>
|
|
<style scoped>
|
.basic_search{
|
display:inline-block;
|
}
|
|
</style>
|
