1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| ResultSet rs=session.connection().createStatement().executeQuery("select NUM_SEMAINE, DEBUT_SEMAINE," +
" FIN_SEMAINE,ID_RESSOURCE,sum(DUREETACHE)as cum, count(distinct STATUT) as lg from GPL_POINTAGES " +
"group by NUM_SEMAINE, DEBUT_SEMAINE,FIN_SEMAINE,ID_RESSOURCE having ID_RESSOURCE="+idr);
GregorianCalendar c = new GregorianCalendar(Locale.FRANCE);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
while(rs.next()){
CumulPointage cp =new CumulPointage();
cp.setNumSemaine(rs.getInt("NUM_SEMAINE"));
cp.setCumul(rs.getInt("cum"));
cp.setIdRessource(idr);
if((rs.getInt("lg")==1) ){
cp.setStatut("Valide");
}
else cp.setStatut("Non Valide");
cp.setDds(rs.getDate("DEBUT_SEMAINE"));
c.setTime(cp.getDds());
int year = c.get(Calendar.YEAR);
cp.setAnnee(year);
cp.setDonnee(cp.getNumSemaine()+"/"+cp.getAnnee());
cp.setDfs(rs.getDate("FIN_SEMAINE"));
list.add(cp);
}
}
catch (Exception e) {
e.printStackTrace();
}
return list;
} |
Partager