String[] els = line.split(";");
for (int i = 0; i < 12; i++)
if(i==4){ // code ministere
- ps.setString(i + 1, new StringBuilder("MIN").append(els[i]).toString());
+ ps.setString(i + 1, new StringBuilder("MIN").append(els[i]).toString()); // Ajout du MIN au code ministere du fichier de patch car il est manquant
} else {
ps.setString(i + 1, els[i]);
}
- logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
+ //logger.debug("inserting ["+els[0]+","+els[1]+","+els[2]+","+els[3]+","+els[4]+","+els[5]+"]");
ps.executeUpdate();
line = br.readLine();
}
rs.next();
int rows = rs.getInt(1);
- logger.debug("Nombre de ligne à patcher" + rows);
+ logger.debug("Nombre de ligne EDMN à patcher : " + rows);
getImportServiceProvider().endLongWait();
br.close();
psLiassesLocales.setString(2, budget);
psLiassesLocales.setString(3, docId);
ResultSet rsLiasses = psLiassesLocales.executeQuery();
+
if (rsLiasses.next()) {
String comptable = rsLiasses.getString(1);
String imputation = rsLiasses.getString(2);
- String ministere = new StringBuilder("MIN").append(rsLiasses.getString(3)).toString(); // TODO : Ajout du MIN au code ministere du patch
+ String ministere = new StringBuilder("MIN").append(rsLiasses.getString(3)).toString(); // Ajout du MIN au code ministere du patch
String annee = rsLiasses.getString(4);
String trimestre = rsLiasses.getString(5);
String numLiasseDeb = rsLiasses.getString(6);
String sql = queryProvider.getQuery("selectIndexPatch").replace("{:liasse}", numLiasses);
PreparedStatement ps = conPatch.prepareStatement(sql);
- ps.setString(1, annee.substring(2));
+ ps.setString(1, annee);
ps.setString(2, trimestre);
ps.setString(3, comptable);
ps.setString(4, imputation);
ps.setString(5, ministere);
ResultSet rs2 = ps.executeQuery();
- // logger.debug("querying ["+annee.substring(2)+","+trimestre+","+comptable+","+imputation+","+ministere+","+numLiasseDeb+","+numLiasseFin+"]");
+ logger.debug("selectIndexPatch ["+annee+","+trimestre+","+comptable+","+imputation+","+ministere+","+numLiasseDeb+","+numLiasseFin+"]");
// StringBuilder numLiassesNat = new StringBuilder();
ArrayList<Liasse> liasses = new ArrayList<Liasse>();
while (rs2.next()) {
rs2.close();
ps.close();
if (liasses.size() > 0) {
- // logger.debug("patching ["+collectivite+","+budget+","+docId+"]");
+ //logger.debug("patching ["+collectivite+","+budget+","+docId+"]");
// numLiassesNat.deleteCharAt(numLiassesNat.length()-1);
ps = con2.prepareStatement(queryProvider.getQuery("insertLiasse"));
ps.setString(1, collectivite);