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);
} |
