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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
|
private void majDuree(String heuredeb,String heurefin) {
// Calcul de la duree de la vacation max 24h
int duree,dureeJour,dureeNuit;
duree = dureeJour = dureeNuit = 0; (never used ca je comprend a peu pret ;) , sauf que je l'utilise !!)
duree = this.calculDuree(heuredeb, heurefin);
int dhdeb = this.calculNbSeconde(heuredeb);
int dhfin = this.calculNbSeconde(heurefin);
dhfin = dhfin<dhdeb?dhfin+86400:dhfin;
int ddebutheurenuit = this.calculNbSeconde(debutheurenuit);
int dfinheurenuit0,dfinheurenuit;
dfinheurenuit0 = dfinheurenuit = this.calculNbSeconde(finheurenuit);
if(dfinheurenuit<ddebutheurenuit) {
dfinheurenuit = dfinheurenuit+86400;
}
//JOptionPane.showMessageDialog(this,"deb : "+dhdeb + "\nfin : "+dhfin+"\nNuit : "+ddebutheurenuit + " - " +dfinheurenuit,"Durees",JOptionPane.INFORMATION_MESSAGE);
if (dfinheurenuit != dfinheurenuit0 && dhdeb < dfinheurenuit0) {
if(dhfin<=dfinheurenuit0) {
dureeJour = 0;
dureeNuit = dhfin - dhdeb;
} else if(dhfin > dfinheurenuit0 && dhfin <= ddebutheurenuit) {
dureeJour = dhfin - dfinheurenuit0;
dureeNuit = dfinheurenuit0 - dhdeb;
} else if(dhfin > ddebutheurenuit && dhfin <= dfinheurenuit) {
dureeJour = ddebutheurenuit - dfinheurenuit0;
dureeNuit = (dfinheurenuit0 - dhdeb) + (dhfin - ddebutheurenuit);
} else if(dhfin > dfinheurenuit) {
dureeJour = (ddebutheurenuit - dfinheurenuit0) + (dhfin - dfinheurenuit);
dureeNuit = (dfinheurenuit - ddebutheurenuit) + (dfinheurenuit0 - dhdeb);
}else {
dureeJour = dureeNuit = 0;
}
} else {
if(dhdeb<ddebutheurenuit) {
if(dhfin <= ddebutheurenuit) {
dureeJour = dhfin - dhdeb;
dureeNuit = 0;
} else if(dhfin > ddebutheurenuit && dhfin <= dfinheurenuit) {
dureeJour = ddebutheurenuit - dhdeb;
dureeNuit = dhfin - ddebutheurenuit;
} else if (dhfin > dfinheurenuit) {
dureeJour = (ddebutheurenuit - dhdeb) + (dhfin - dfinheurenuit);
dureeNuit = dfinheurenuit - ddebutheurenuit;
} else {
dureeJour = dureeNuit = 0;
}
} else {
if(dhfin <= dfinheurenuit) {
dureeJour = 0;
dureeNuit = dhfin - dhdeb;
} else if (dhfin > dfinheurenuit) {
dureeJour = dhfin - dfinheurenuit;
dureeNuit = dfinheurenuit - dhdeb;
} else {
dureeJour = dureeNuit = 0;
}
}
}
String req = "UPDATE vacations SET totalheure="+transformSecond(duree); (Local variable hides a field : ?????)
req += ",totaljour="+transformSecond(dureeJour);
req += ",totalnuit="+transformSecond(dureeNuit);
req += " WHERE idposte="+idposte+" AND idsite="+idsite+" AND idvacation="+idvacation;
//JOptionPane.showMessageDialog(this,req,"",JOptionPane.INFORMATION_MESSAGE);
//Mise a jour de la base de données
try {
int res = connection.updateSql(req);
//JOptionPane.showMessageDialog(this,req,"",JOptionPane.INFORMATION_MESSAGE);
if(!(res>=0))
JOptionPane.showMessageDialog(this,this.connection.getErreurSql(),"erreur classe connection",JOptionPane.INFORMATION_MESSAGE);
} catch (Exception e) { The catch(java.lang.Exception) is too broad, the actually caught exception is java.awt.HeadlessException
JOptionPane.showMessageDialog(this,e.toString(),"erreur",JOptionPane.INFORMATION_MESSAGE); }
if (transformSecond(duree)>this.connection.getVacmax())
JOptionPane.showMessageDialog(this,"La durée de la vacation est supérieure à la limite autorisée\nLimite : "+this.connection.getVacmax(),"Durée vacation trop longue",JOptionPane.WARNING_MESSAGE);
this.initTableVacation();
} |
Partager