Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit 77dc82b

Browse filesBrowse files
fankayfankay
committed
演示echarts饼图
1 parent dcb8991 commit 77dc82b
Copy full SHA for 77dc82b

File tree

Expand file treeCollapse file tree

8 files changed

+135
-46
lines changed
Open diff view settings
Filter options
Expand file treeCollapse file tree

8 files changed

+135
-46
lines changed
Open diff view settings
Collapse file

‎ssm/src/main/java/com/kaishengit/Test.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/Test.java
-46Lines changed: 0 additions & 46 deletions
This file was deleted.
Collapse file

‎ssm/src/main/java/com/kaishengit/controller/FinanceController.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/controller/FinanceController.java
+13Lines changed: 13 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -127,4 +127,17 @@ public void exportCsvFile(@PathVariable String today, HttpServletResponse respon
127127

128128
}
129129

130+
/**
131+
* 按天加载数据饼图
132+
* @param today
133+
* @return
134+
*/
135+
@GetMapping("/day/{type}/{today}/pie")
136+
@ResponseBody
137+
public AjaxResult dayPieData(@PathVariable String type,@PathVariable String today) {
138+
type = "in".equals(type) ? "收入" : "支出";
139+
List<Map<String,Object>> pieData = financeService.findPieDataByDay(today,type);
140+
return new AjaxResult(AjaxResult.SUCCESS,"",pieData);
141+
}
142+
130143
}
Collapse file

‎ssm/src/main/java/com/kaishengit/dto/AjaxResult.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/dto/AjaxResult.java
+2Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,10 @@
11
package com.kaishengit.dto;
22

3+
import lombok.AllArgsConstructor;
34
import lombok.Data;
45

56
@Data
7+
@AllArgsConstructor
68
public class AjaxResult {
79

810
public static final String SUCCESS = "success";
Collapse file

‎ssm/src/main/java/com/kaishengit/mapper/FinanceMapper.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/mapper/FinanceMapper.java
+4Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
package com.kaishengit.mapper;
22

33
import com.kaishengit.pojo.Finance;
4+
import org.apache.ibatis.annotations.Param;
45

56
import java.util.List;
67
import java.util.Map;
@@ -20,4 +21,7 @@ public interface FinanceMapper {
2021
Long filterCount(Map<String, Object> queryParam);
2122

2223
List<Finance> findByCreateDate(String today);
24+
25+
List<Map<String,Object>> findPieData(@Param("today") String today,@Param("type") String type);
26+
2327
}
Collapse file

‎ssm/src/main/java/com/kaishengit/service/FinanceService.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/service/FinanceService.java
+2Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -16,4 +16,6 @@ public interface FinanceService {
1616
Long filterCount(Map<String, Object> queryParam);
1717

1818
List<Finance> findByCreatDate(String today);
19+
20+
List<Map<String,Object>> findPieDataByDay(String today,String type);
1921
}
Collapse file

‎ssm/src/main/java/com/kaishengit/service/impl/FinanceServiceImpl.java‎

Copy file name to clipboardExpand all lines: ssm/src/main/java/com/kaishengit/service/impl/FinanceServiceImpl.java
+10Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -51,4 +51,14 @@ public Long filterCount(Map<String, Object> queryParam) {
5151
public List<Finance> findByCreatDate(String today) {
5252
return financeMapper.findByCreateDate(today);
5353
}
54+
55+
/**
56+
* 日报表中显示饼图数据
57+
* @param today
58+
* @return
59+
*/
60+
@Override
61+
public List<Map<String, Object>> findPieDataByDay(String today,String type) {
62+
return financeMapper.findPieData(today,type);
63+
}
5464
}
Collapse file

‎ssm/src/main/resources/mapper/FinanceMapper.xml‎

Copy file name to clipboardExpand all lines: ssm/src/main/resources/mapper/FinanceMapper.xml
+6Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -35,4 +35,10 @@
3535
<select id="findByCreateDate" resultType="com.kaishengit.pojo.Finance">
3636
SELECT * FROM t_finance WHERE create_date = #{today}
3737
</select>
38+
<select id="findPieData" resultType="java.util.Map">
39+
select tf.module as 'name',sum(tf.money) as 'value'
40+
from t_finance as tf
41+
where tf.confirm_user is not null and tf.confirm_date = #{today} and tf.type = #{type}
42+
GROUP BY tf.module;
43+
</select>
3844
</mapper>
Collapse file

‎ssm/src/main/webapp/WEB-INF/views/finance/day.jsp‎

Copy file name to clipboardExpand all lines: ssm/src/main/webapp/WEB-INF/views/finance/day.jsp
+98Lines changed: 98 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -61,6 +61,22 @@
6161
</div>
6262
<!-- /.box -->
6363

64+
<div class="box">
65+
<div class="box-header">
66+
<h3 class="box-title">今日收支统计</h3>
67+
</div>
68+
<div class="box-body">
69+
<div class="row">
70+
<div class="col-md-6">
71+
<div id="inChart" style="width: 100%;height: 300px"></div>
72+
</div>
73+
<div class="col-md-6">
74+
<div id="outChart" style="width: 100%;height: 300px"></div>
75+
</div>
76+
</div>
77+
</div>
78+
</div>
79+
6480
</section>
6581
<!-- /.content -->
6682
</div>
@@ -75,6 +91,7 @@
7591
<script src="/static/plugins/moment.js"></script>
7692
<script src="/static/plugins/datepicker/bootstrap-datepicker.js"></script>
7793
<script src="/static/plugins/datepicker/locales/bootstrap-datepicker.zh-CN.js"></script>
94+
<script src="/static/plugins/echarts.min.js"></script>
7895
<script>
7996
$(function () {
8097
$("#date").val(moment().format("YYYY-MM-DD"));
@@ -88,6 +105,7 @@
88105
var today = e.format(0,'yyyy-mm-dd');
89106
//table.ajax.reload(false,null);
90107
table.ajax.reload();
108+
loadPie();
91109
});
92110
93111
var table = $(".table").DataTable({
@@ -166,6 +184,86 @@
166184
window.location.href = "/finance/day/"+day+"/data.xls";
167185
})
168186
187+
//echart图
188+
var inChart = echarts.init($("#inChart")[0]);
189+
var outChart = echarts.init($("#outChart")[0]);
190+
var option = {
191+
title : {
192+
left:'center'
193+
},
194+
tooltip: {},
195+
legend:{
196+
left:20,
197+
orient:'vertical',
198+
data:[]
199+
},
200+
series:[]
201+
};
202+
203+
inChart.setOption(option);
204+
outChart.setOption(option);
205+
206+
function loadPie() {
207+
//收入统计
208+
$.get("/finance/day/in/"+$("#date").val()+"/pie").done(function(result){
209+
if(result.status == 'success') {
210+
var nameArray = [];
211+
for(var i = 0;i < result.data.length;i++) {
212+
var obj = result.data[i];
213+
nameArray.push(obj.name);
214+
}
215+
inChart.setOption({
216+
title:{
217+
text : "收入统计"
218+
},
219+
legend:{
220+
data:nameArray
221+
},
222+
series:[{
223+
type:'pie',
224+
name:"金额",
225+
data:result.data
226+
}]
227+
});
228+
} else {
229+
layer.msg(result.message);
230+
}
231+
}).error(function(){
232+
layer.msg("加载饼图异常");
233+
});
234+
//支出统计
235+
$.get("/finance/day/out/"+$("#date").val()+"/pie").done(function(result){
236+
if(result.status == 'success') {
237+
var nameArray = [];
238+
for(var i = 0;i < result.data.length;i++) {
239+
var obj = result.data[i];
240+
nameArray.push(obj.name);
241+
}
242+
outChart.setOption({
243+
title:{
244+
text : "支出统计"
245+
},
246+
legend:{
247+
data:nameArray
248+
},
249+
series:[{
250+
type:'pie',
251+
name:"金额",
252+
data:result.data
253+
}]
254+
});
255+
} else {
256+
layer.msg(result.message);
257+
}
258+
}).error(function(){
259+
layer.msg("加载饼图异常");
260+
});
261+
}
262+
263+
264+
loadPie();
265+
266+
169267
});
170268
</script>
171269
</body>

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.