package com.hzb.echarts;
import com.jfinal.core.Controller;
import com.jfinal.plugin.activerecord.Db;
/**
*
* @author Evloution_
* @author 显示某岗位有多少员工,显示成饼图。
*/
public class EchartsController extends Controller {
public void index() {
}
// eCharts 饼图
public void selectEcharts() {
// sql语句查询出来你要显示的数据,这个仅供参考。
String sql = "SELECT COUNT(DISTINCT spe.ID) AS \"value\",sde.DEPTNAME AS \"name\" FROM SYS_PERSON spe,SYS_PERSON_POST_MAP spm,SYS_POST spo,SYS_DEPT sde " +
"WHERE spe.ID=spm.SYS_PERSONID AND spm.SYS_POSTID=spo.ID AND sde.ID=spo.SYS_DEPTID GROUP BY sde.DEPTNAME";
renderJson(Db.find(sql));
}
}