传智健康项目讲义第十章 二

1.3 后台代码 
1.3.1 Controller 
在health_backend工程的ReportController中提供getSetmealReport方法

@Reference
private SetmealService setmealService;
/**
* 套餐占比统计
* @return
*/
@RequestMapping("/getSetmealReport")
public Result getSetmealReport(){
List<Map<String, Object>> list = setmealService.findSetmealCount();
Map<String,Object> map = new HashMap<>();
map.put("setmealCount",list);
List<String> setmealNames = new ArrayList<>();
for(Map<String,Object> m : list){
String name = (String) m.get("name");
setmealNames.add(name);
}
map.put("setmealNames",setmealNames);
return new Result(true,
MessageConstant.GET_SETMEAL_COUNT_REPORT_SUCCESS,map);
}

1.3.2 服务接口 
在SetmealService服务接口中扩展方法findSetmealCount

public List<Map<String,Object>> findSetmealCount();

1.3.3 服务实现类 
在SetmealServiceImpl服务实现类中实现findSetmealCount方法
 

public List<Map<String, Object>> findSetmealCount() {
return setmealDao.findSetmealCount();
}

1.3.4 Dao接口
在SetmealDao接口中扩展方法findSetmealCount 

public List<Map<String,Object>> findSetmealCount();

1.3.5 Mapper映射文件 
在SetmealDao.xml映射文件中提供SQL语句

<select id="findSetmealCount" resultType="map">
select s.name,count(o.id) as value
from t_order o ,t_setmeal s
where o.setmeal_id = s.id
group by s.name
</select>