OpenConcerto

Dépôt officiel du code source de l'ERP OpenConcerto
sonarqube

svn://code.openconcerto.org/openconcerto

Compare Revisions

Regard whitespace Rev 143 → Rev 144

/trunk/OpenConcerto/src/org/openconcerto/erp/core/humanresources/payroll/report/FichePayeSheetXML.java
13,26 → 13,247
package org.openconcerto.erp.core.humanresources.payroll.report;
 
import org.openconcerto.erp.core.common.element.StyleSQLElement;
import org.openconcerto.erp.generationDoc.AbstractSheetXMLWithDate;
import org.openconcerto.erp.preferences.PrinterNXProps;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.model.SQLRow;
import org.openconcerto.sql.model.SQLRowAccessor;
import org.openconcerto.sql.model.SQLRowListRSH;
import org.openconcerto.sql.model.SQLRowValues;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.utils.cc.ITransformer;
 
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
 
import javax.swing.JOptionPane;
import javax.swing.SwingUtilities;
 
public class FichePayeSheetXML extends AbstractSheetXMLWithDate {
 
public static final String TEMPLATE_ID = "FichePaye";
private static boolean prefBulletinSimpl = true;
public static final String TEMPLATE_ID = prefBulletinSimpl ? "FichePayeSimplifiee" : "FichePaye";
public static final String TEMPLATE_PROPERTY_NAME = "LocationFichePaye";
final Map<Integer, String> cotisationSimplifieeLink = new HashMap<>();
 
public FichePayeSheetXML(SQLRow row) {
public FichePayeSheetXML(final SQLRow row) {
super(row);
this.printer = PrinterNXProps.getInstance().getStringProperty("FichePayePrinter");
this.elt = Configuration.getInstance().getDirectory().getElement("FICHE_PAYE");
if (prefBulletinSimpl) {
SQLSelect sel = new SQLSelect();
sel.addSelect(row.getTable().getDBRoot().findTable("RUBRIQUE_COTISATION").getField("LIGNE_PAYE_SIMPLIFIEE"));
sel.addSelect(row.getTable().getDBRoot().findTable("RUBRIQUE_COTISATION").getKey());
List<SQLRow> rubCotis = SQLRowListRSH.execute(sel);
 
for (SQLRow sqlRow : rubCotis) {
cotisationSimplifieeLink.put(sqlRow.getID(), sqlRow.getString("LIGNE_PAYE_SIMPLIFIEE"));
}
 
final String codeStatu = row.getForeign("ID_SALARIE").getForeign("ID_INFOS_SALARIE_PAYE").getForeign("ID_CONTRAT_SALARIE").getForeign("ID_CODE_STATUT_CATEGORIEL").getString("CODE");
final boolean cadre = codeStatu.equals("01") || codeStatu.equals("02");
 
final Set<Integer> ignoredRubriqueComm = new HashSet<Integer>();
// Total nat
ignoredRubriqueComm.add(2);
// Total brut
// ignoredRubriqueComm.add(3);
// Ligne vide
ignoredRubriqueComm.add(7);
// Cotisations sal
ignoredRubriqueComm.add(4);
// Cotisation pat
ignoredRubriqueComm.add(5);
 
this.setPostProcess(new ITransformer<List<SQLRowAccessor>, List<SQLRowAccessor>>() {
 
@Override
public List<SQLRowAccessor> transformChecked(List<SQLRowAccessor> input) {
 
List<SQLRowAccessor> result = new ArrayList<SQLRowAccessor>(input.size());
List<SQLRowAccessor> resultCom = new ArrayList<SQLRowAccessor>(input.size());
List<SQLRowAccessor> resultNet = new ArrayList<SQLRowAccessor>(input.size());
 
List<SQLRowAccessor> resultCotis = new ArrayList<SQLRowAccessor>(input.size());
Map<String, SQLRowValues> mapLigneSimplifiee = initCotisations(cadre, resultCotis);
for (SQLRowAccessor sqlRowAccessor : input) {
if (sqlRowAccessor.getBoolean("IN_PERIODE")) {
if (sqlRowAccessor.getString("SOURCE").equals("RUBRIQUE_BRUT")) {
if (result.size() == 0) {
SQLRowValues rowValsTitle = new SQLRowValues(sqlRowAccessor.getTable());
rowValsTitle.put("ID_STYLE", eltStyle.getAllStyleByName().get("Titre 1"));
rowValsTitle.put("NOM", "Rubrique de brut");
rowValsTitle.put("IMPRESSION", Boolean.TRUE);
rowValsTitle.put("IN_PERIODE", Boolean.TRUE);
result.add(rowValsTitle);
}
SQLRowValues rowValsToAdd = sqlRowAccessor.asRowValues();
rowValsToAdd.put("ID_STYLE", 2);
result.add(rowValsToAdd);
}
if (sqlRowAccessor.getString("SOURCE").equals("RUBRIQUE_NET") && sqlRowAccessor.getBoolean("IMPRESSION") && sqlRowAccessor.getBoolean("IN_PERIODE")) {
if (resultNet.size() == 0) {
SQLRowValues rowValsTitle = new SQLRowValues(sqlRowAccessor.getTable());
rowValsTitle.put("ID_STYLE", eltStyle.getAllStyleByName().get("Titre 1"));
rowValsTitle.put("NOM", "Rubrique de net");
rowValsTitle.put("IMPRESSION", Boolean.TRUE);
rowValsTitle.put("IN_PERIODE", Boolean.TRUE);
resultNet.add(rowValsTitle);
}
SQLRowValues rowValsToAdd = sqlRowAccessor.asRowValues();
rowValsToAdd.put("ID_STYLE", 2);
resultNet.add(rowValsToAdd);
}
 
if (sqlRowAccessor.getString("SOURCE").equals("RUBRIQUE_COMM") && !ignoredRubriqueComm.contains(sqlRowAccessor.getInt("IDSOURCE"))) {
if (resultNet.size() == 0) {
result.add(sqlRowAccessor);
} else {
resultNet.add(sqlRowAccessor);
}
 
}
if (sqlRowAccessor.getString("SOURCE").equals("RUBRIQUE_COTISATION")) {
cumuls(sqlRowAccessor, mapLigneSimplifiee, cadre);
}
}
}
result.addAll(resultNet);
result.addAll(resultCom);
result.addAll(resultCotis);
return result;
}
});
}
}
 
private void cumuls(final SQLRowAccessor sqlRowAccessor, Map<String, SQLRowValues> mapLigneSimplifiee, final boolean cadre) {
// "TAUX_PAT" numeric(16,6) DEFAULT 0,
// "TAUX_SAL" numeric(16,6) DEFAULT 0,
// "NB_BASE" numeric(16,6) DEFAULT 0,
// "MONTANT_SAL_AJ" numeric(16,2) DEFAULT 0,
// "MONTANT_PAT" numeric(16,2) DEFAULT 0,
// "MONTANT_SAL_DED" numeric(16,2) DEFAULT 0,
String idLigneSimplifiee = this.cotisationSimplifieeLink.get(sqlRowAccessor.getInt("IDSOURCE"));
if (idLigneSimplifiee == null || idLigneSimplifiee.trim().length() == 0) {
final SQLRow rowRub = sqlRowAccessor.getTable().getDBRoot().findTable("RUBRIQUE_COTISATION").getRow(sqlRowAccessor.getInt("IDSOURCE"));
 
SwingUtilities.invokeLater(new Runnable() {
 
@Override
public void run() {
JOptionPane.showMessageDialog(null, "Aucune liaison définie vers une ligne de bulletin simplifié pour la cotisation " + rowRub.getString("CODE") + " - " + rowRub.getString("NOM")
+ ".\n La liaison sera faite sur autres contributions dues par l'employeur!");
}
});
idLigneSimplifiee = LignePayeSimplifiee.AUTRES_CONTRIBUTIONS.getId();
}
 
if (!idLigneSimplifiee.equals(LignePayeSimplifiee.IGNORE.getId())) {
SQLRowValues ligneSimplifiee = mapLigneSimplifiee.get(idLigneSimplifiee);
if (ligneSimplifiee == null) {
 
final LignePayeSimplifiee fromID = LignePayeSimplifiee.fromID(idLigneSimplifiee);
SwingUtilities.invokeLater(new Runnable() {
 
@Override
public void run() {
JOptionPane.showMessageDialog(null,
"Aucune ligne simplifiée " + fromID + " dans le bulletin " + (cadre ? "cadre!" : "non cadre!") + "\n La ligne " + sqlRowAccessor.getString("NOM") + " a été ignoré!");
}
});
 
} else {
BigDecimal montantPatBulletinSimpl = BigDecimal.ZERO;
BigDecimal montantSalBulletinSimpl = BigDecimal.ZERO;
if (ligneSimplifiee.getBigDecimal("MONTANT_SAL_DED") != null) {
montantSalBulletinSimpl = ligneSimplifiee.getBigDecimal("MONTANT_SAL_DED");
}
if (ligneSimplifiee.getBigDecimal("MONTANT_PAT") != null) {
montantPatBulletinSimpl = ligneSimplifiee.getBigDecimal("MONTANT_PAT");
}
 
BigDecimal montantPatLigne = BigDecimal.ZERO;
BigDecimal montantSalLigne = BigDecimal.ZERO;
if (sqlRowAccessor.getBigDecimal("MONTANT_SAL_DED") != null) {
montantSalLigne = sqlRowAccessor.getBigDecimal("MONTANT_SAL_DED");
}
if (sqlRowAccessor.getBigDecimal("MONTANT_PAT") != null) {
montantPatLigne = sqlRowAccessor.getBigDecimal("MONTANT_PAT");
}
ligneSimplifiee.put("NB_BASE", sqlRowAccessor.getBigDecimal("NB_BASE"));
ligneSimplifiee.put("MONTANT_SAL_DED", montantSalBulletinSimpl.add(montantSalLigne));
ligneSimplifiee.put("MONTANT_PAT", montantPatBulletinSimpl.add(montantPatLigne));
 
}
}
}
 
private StyleSQLElement eltStyle = Configuration.getInstance().getDirectory().getElement(StyleSQLElement.class);
 
private Map<String, SQLRowValues> initCotisations(boolean cadre, List<SQLRowAccessor> resultCotis) {
 
SQLTable tableFichePayeElt = this.row.getTable().getDBRoot().findTable("FICHE_PAYE_ELEMENT");
SQLRowValues rowValsCotis = new SQLRowValues(tableFichePayeElt);
 
rowValsCotis.put("ID_STYLE", eltStyle.getAllStyleByName().get("Titre 2"));
rowValsCotis.put("NOM", "Cotisations sociales");
// rowValsCotis.put("NB_BASE", BigDecimal.ZERO);
// rowValsCotis.put("TAUX_SAL", BigDecimal.ZERO);
// rowValsCotis.put("MONTANT_SAL_AJ", BigDecimal.ZERO);
// rowValsCotis.put("MONTANT_SAL_DED", BigDecimal.ZERO);
// rowValsCotis.put("MONTANT_PAT", BigDecimal.ZERO);
rowValsCotis.put("IMPRESSION", Boolean.TRUE);
rowValsCotis.put("IN_PERIODE", Boolean.TRUE);
resultCotis.add(rowValsCotis);
 
Map<String, SQLRowValues> mapPayeSimplifiee = new HashMap<String, SQLRowValues>();
List<GroupePayeSimplifiee> listGroupe = cadre ? StructurePayeSimplifiee.getStructureCadre() : StructurePayeSimplifiee.getStructureNonCadre();
for (GroupePayeSimplifiee groupe : listGroupe) {
SQLRowValues rowValsFichePaye = new SQLRowValues(tableFichePayeElt);
rowValsFichePaye.put("NOM", groupe.getTranslation());
rowValsFichePaye.put("IMPRESSION", Boolean.TRUE);
rowValsFichePaye.put("IN_PERIODE", Boolean.TRUE);
rowValsFichePaye.put("ID_STYLE", eltStyle.getAllStyleByName().get("Normal"));
// rowValsFichePaye.put("NB_BASE", BigDecimal.ZERO);
// rowValsFichePaye.put("TAUX_SAL", BigDecimal.ZERO);
// rowValsFichePaye.put("MONTANT_SAL_AJ", BigDecimal.ZERO);
// rowValsFichePaye.put("MONTANT_SAL_DED", BigDecimal.ZERO);
// rowValsFichePaye.put("MONTANT_PAT", BigDecimal.ZERO);
resultCotis.add(rowValsFichePaye);
mapPayeSimplifiee.put(groupe.getId(), rowValsFichePaye);
for (LignePayeSimplifiee lignePayeSimplifiee : groupe.getChildren()) {
 
if (groupe.isShowChildren()) {
SQLRowValues rowValsLPaye = new SQLRowValues(tableFichePayeElt);
rowValsLPaye.put("NOM", lignePayeSimplifiee.getTranslation());
rowValsLPaye.put("IMPRESSION", Boolean.TRUE);
rowValsLPaye.put("IN_PERIODE", Boolean.TRUE);
rowValsLPaye.put("ID_STYLE", eltStyle.getAllStyleByName().get("Normal"));
// rowValsLPaye.put("NB_BASE", BigDecimal.ZERO);
// rowValsLPaye.put("TAUX_SAL", BigDecimal.ZERO);
// rowValsLPaye.put("MONTANT_SAL_AJ", BigDecimal.ZERO);
// rowValsLPaye.put("MONTANT_SAL_DED", BigDecimal.ZERO);
// rowValsLPaye.put("MONTANT_PAT", BigDecimal.ZERO);
mapPayeSimplifiee.put(lignePayeSimplifiee.getId(), rowValsLPaye);
resultCotis.add(rowValsLPaye);
} else {
mapPayeSimplifiee.put(lignePayeSimplifiee.getId(), rowValsFichePaye);
}
}
}
return mapPayeSimplifiee;
}
 
@Override
public String getDefaultTemplateId() {
return TEMPLATE_ID;
}