| | |
| | | public List<vo_kaoqin_p> getRealAttendance(int page) { |
| | | int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")); |
| | | int start = (page - 1) * perPage; |
| | | int end = perPage; |
| | | int end = 50; |
| | | String sql = null; |
| | | Query query = null; |
| | | // sql = "SELECT id,area,name,bumen,tagid,intime,beizhu FROM |
| | |
| | | public List<vo_kaoqin_p> getHistoricalAttendance(int page) { |
| | | int perPage = Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage")); |
| | | int start = (page - 1) * perPage; |
| | | int end = perPage; |
| | | int end = 50; |
| | | String sql = null; |
| | | Query query = null; |
| | | sql = "SELECT k.id,k.area,k.name,k.bumen,k.tagid,k.intime,k.outtime,k.alltime,k.beizhu,t.power FROM tb_kaoqing k,tb_tag t LIMIT :start,:end"; |
| | |
| | | sql = "select id,tagid,name,heart,okheart,state,time from tb_heart_record ORDER BY time DESC LIMIT :start,:end"; |
| | | query = this.em.createNativeQuery(sql); |
| | | query.setParameter("start", (page - 1) * Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"))); |
| | | query.setParameter("end", Integer.parseInt(ModifyConfig.readData(Config.getPageConfig(), "perPage"))); |
| | | query.setParameter("end",50); |
| | | List resultlist = query.getResultList(); |
| | | List<tb_heart_record> permissions = new ArrayList<>(); |
| | | if (resultlist.size() > 0) { |