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
|
ResultSet rs=session.connection().createStatement().executeQuery("select NUM_SEMAINE, DEBUT_SEMAINE," +
" FIN_SEMAINE,ID_RESSOURCE,sum(DUREETACHE)as cum from GPL_POINTAGES " +
"group by NUM_SEMAINE, DEBUT_SEMAINE,FIN_SEMAINE,ID_RESSOURCE having ID_RESSOURCE="+idr);
while(rs.next()){
CumulPointage cp =new CumulPointage();
cp.setNumSemaine(rs.getInt("NUM_SEMAINE"));
cp.setCumul(rs.getInt("cum"));
cp.setIdRessource(idr);
cp.setStatut(rs.getString("lg"));
cp.setDds(rs.getDate("DEBUT_SEMAINE"));
cp.setDfs(rs.getDate("FIN_SEMAINE"));
/*ResultSet ss = session.connection().createStatement().executeQuery("select STATUT from (select NUM_SEMAINE," +
" DEBUT_SEMAINE, FIN_SEMAINE,ID_RESSOURCE,STATUT,sum(DUREETACHE)as cum from GPL_POINTAGES " +
"group by NUM_SEMAINE, DEBUT_SEMAINE,FIN_SEMAINE,ID_RESSOURCE,STATUT having ID_RESSOURCE="+idr+"and NUM_SEMAINE="+cp.getNumSemaine()+")");
ResultSet sr = session.connection().createStatement().executeQuery("select count(*) as lg from (select STATUT from (select NUM_SEMAINE," +
" DEBUT_SEMAINE, FIN_SEMAINE,ID_RESSOURCE,STATUT,sum(DUREETACHE)as cum from GPL_POINTAGES " +
"group by NUM_SEMAINE, DEBUT_SEMAINE,FIN_SEMAINE,ID_RESSOURCE,STATUT having ID_RESSOURCE="+idr+"and NUM_SEMAINE="+cp.getNumSemaine()+"))");
if((sr.getInt("lg")==1) && (ss.getString("STATUT").equalsIgnoreCase("Valide"))){
cp.setStatut("Valide");
}
else cp.setStatut("Non Valide");*/
list.add(cp);
} |
Partager