一、前台vue代码
在首页index.vue中添加
<el-row style="width: 100%; font-weight: bold; top: 10px;" :gutter="10" :sm="24" :lg="24" type="flex">
<el-col :xs="18" :sm="18">
<div class="chart-wrapper">
<bar-chart />
</div>
</el-col>
<el-col :xs="6" :sm="6"></el-col>
</el-row>
并调用BarChart.vue
import BarChart from './dashboard/BarChart'
components: {
BarChart,
},
然后BarChart.vue代码如下
<template>
<div :class="className" :style="{height:height,width:width}" />
</template>
<script>
import echarts from 'echarts'
require('echarts/theme/macarons') // echarts theme
import {newsCount } from "@/api/news/news";
import resize from './mixins/resize'
const animationDuration = 6000
export default {
mixins: [resize],
props: {
className: {
type: String,
default: 'chart'
},
width: {
type: String,
default: '100%'
},
height: {
type: String,
default: '300px'
}
},
data() {
return {
chart: null,
item:[],
value:[],
}
},
mounted() {
this.$nextTick(() => {
this.initChart()
})
},
beforeDestroy() {
if (!this.chart) {
return
}
this.chart.dispose()
this.chart = null
},
methods: {
initChart() {
this.chart = echarts.init(this.$el, 'infographic')
//this.chart.showLoading();
newsCount(this.queryParams).then(response => {
console.log(response);
this.listData = response.data;
for (let i = 0; i < this.listData.length; i++) {
this.item.push(this.listData[i].item);
this.value.push(this.listData[i].value)
}
console.log(this.item);
this.chart.setOption({
tooltip: {
trigger: 'axis',
axisPointer: { // 坐标轴指示器,坐标轴触发有效
type: 'shadow' // 默认为直线,可选为:'line' | 'shadow'
}
},
grid: {
top: 10,
left: '2%',
right: '2%',
bottom: '3%',
containLabel: true
},
xAxis: [{
type: 'category',
data: this.item,
axisTick: {
alignWithLabel: true
}
}],
yAxis: [{
type: 'value',
axisTick: {
show: false
}
}],
series: [{
name: '信息数量',
type: 'bar',
stack: 'vistors',
barWidth: '60%',
data: this.value,
animationDuration
}]
})
})
}
}
}
</script>
new.js中新增
export function newsCount(query) {
return request({
url: '/news/news/dateCount',
method: 'get',
params: query
})
}
二、后台
Controller代码为
@ApiOperation("dateCount")
@GetMapping("/dateCount")
public AjaxResult dateCount(News news)
{
List<Map<String, Object>> listMaps = newsService.selectListCount(news);
return AjaxResult.success(listMaps);
}
service代码为
@Override
public List<Map<String, Object>> selectListCount(News news) {
return newsMapper.selectListCount(news);
}
newsMapper.xml
<select id="selectListCount" resultType="java.util.Map">
SELECT a.item,IFNULL(b.value,0) AS value
FROM (
SELECT CURDATE() AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY) AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 2 DAY) AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 3 DAY) AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 4 DAY) AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 5 DAY) AS item
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 6 DAY) AS item
) a LEFT JOIN (
SELECT DATE(create_time) AS date, count(date_format(create_time,'%Y-%m-%d')) AS value
FROM news_tbl
GROUP BY DATE(create_time)
) b ON a.item = b.date;
</select>