@Override
    public List<JobTrackerMDataPo> querySum(MDataPaginationReq request) {

        return new SelectSql(getSqlTemplate())
                .select()
                .columns("timestamp",
                        "SUM(receive_job_num) AS receive_job_num",
                        "SUM(push_job_num) AS push_job_num" ,
                        "SUM(exe_success_num) AS exe_success_num" ,
                        "SUM(exe_failed_num) AS exe_failed_num" ,
                        "SUM(exe_later_num) AS exe_later_num" ,
                        "SUM(exe_exception_num) AS exe_exception_num" ,
                        "SUM(fix_executing_job_num) AS fix_executing_job_num")
                .from()
                .table(getTableName())
                .whereSql(buildWhereSql(request))
                .groupBy(" timestamp ASC ")
                .limit(request.getStart(), request.getLimit())
                .list(RshHandler.JOB_TRACKER_SUM_M_DATA_RSH);
    }
@author Robert HG (254963746@qq.com) on 3/9/16.
lts-admin/src/main/java/com/github/ltsopensource/admin/access/mysql/MysqlBackendJobTrackerMAccess.java