OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 156 | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 156 Rev 177
Line 19... Line 19...
19
import org.openconcerto.erp.core.finance.payment.element.ModeDeReglementSQLElement;
19
import org.openconcerto.erp.core.finance.payment.element.ModeDeReglementSQLElement;
20
import org.openconcerto.erp.model.PrixTTC;
20
import org.openconcerto.erp.model.PrixTTC;
21
import org.openconcerto.sql.model.SQLRow;
21
import org.openconcerto.sql.model.SQLRow;
22
import org.openconcerto.sql.model.SQLRowValues;
22
import org.openconcerto.sql.model.SQLRowValues;
23
import org.openconcerto.sql.model.SQLTable;
23
import org.openconcerto.sql.model.SQLTable;
-
 
24
import org.openconcerto.sql.model.Where;
-
 
25
import org.openconcerto.sql.request.UpdateBuilder;
24
 
26
 
25
import java.sql.SQLException;
27
import java.sql.SQLException;
26
import java.text.DateFormat;
28
import java.text.DateFormat;
27
import java.text.SimpleDateFormat;
29
import java.text.SimpleDateFormat;
-
 
30
import java.util.ArrayList;
28
import java.util.Date;
31
import java.util.Date;
29
import java.util.HashMap;
32
import java.util.HashMap;
30
import java.util.List;
33
import java.util.List;
31
import java.util.Map;
34
import java.util.Map;
32
 
35
 
Line 59... Line 62...
59
        // "Règlement achat" + SOURCE.getNom() ??
62
        // "Règlement achat" + SOURCE.getNom() ??
60
        this.nom = "Règlement achat " + rowFournisseur.getString("NOM") + " (" + typeRegRow.getString("NOM") + ")";
63
        this.nom = "Règlement achat " + rowFournisseur.getString("NOM") + " (" + typeRegRow.getString("NOM") + ")";
61
 
64
 
62
        List<SQLRow> l = regMontantRow.getReferentRows(regMontantRow.getTable().getTable("REGLER_MONTANT_ELEMENT"));
65
        List<SQLRow> l = regMontantRow.getReferentRows(regMontantRow.getTable().getTable("REGLER_MONTANT_ELEMENT"));
63
        int mvtSource = -1;
66
        int mvtSource = -1;
-
 
67
        List<Integer> factureFids = new ArrayList<Integer>();
-
 
68
 
64
        for (SQLRow sqlRow : l) {
69
        for (SQLRow sqlRow : l) {
65
            SQLRow mvtEch = sqlRow.getForeignRow("ID_MOUVEMENT_ECHEANCE");
70
            SQLRow mvtEch = sqlRow.getForeignRow("ID_MOUVEMENT_ECHEANCE");
66
            if (mvtEch.getID() != mvtSource) {
71
            if (mvtEch.getID() != mvtSource) {
67
                getNewMouvement("REGLER_MONTANT", idRegMontant, mvtEch.getID(), mvtEch.getInt("ID_PIECE"));
72
                getNewMouvement("REGLER_MONTANT", idRegMontant, mvtEch.getID(), mvtEch.getInt("ID_PIECE"));
68
                if (mvtSource == -1) {
73
                if (mvtSource == -1) {
69
                    mvtSource = mvtEch.getID();
74
                    mvtSource = mvtEch.getID();
70
                }
75
                }
71
            }
76
            }
-
 
77
            if (!sqlRow.isForeignEmpty("ID_ECHEANCE_FOURNISSEUR")) {
-
 
78
                SQLRow ech = sqlRow.getForeign("ID_ECHEANCE_FOURNISSEUR");
-
 
79
                if (!ech.isForeignEmpty("ID_FACTURE_FOURNISSEUR")) {
-
 
80
                    factureFids.add(ech.getForeignID("ID_FACTURE_FOURNISSEUR"));
-
 
81
                }
-
 
82
            }
72
        }
83
        }
73
 
84
 
74
        SQLRow rowMvtSource = tableMouvement.getRow(mvtSource);
85
        SQLRow rowMvtSource = tableMouvement.getRow(mvtSource);
75
        if (rowMvtSource == null) {
86
        if (rowMvtSource == null) {
76
            throw new IllegalStateException("Aucun mouvement source associé aux échéances.\n(Mouvement source : " + mvtSource + ", REGLER_MONTANT " + regMontantRow.getID() + ")");
87
            throw new IllegalStateException("Aucun mouvement source associé aux échéances.\n(Mouvement source : " + mvtSource + ", REGLER_MONTANT " + regMontantRow.getID() + ")");
Line 122... Line 133...
122
                this.putValue("DEBIT", new Long(0));
133
                this.putValue("DEBIT", new Long(0));
123
                this.putValue("CREDIT", new Long(prixTTC.getLongValue()));
134
                this.putValue("CREDIT", new Long(prixTTC.getLongValue()));
124
                ajoutEcriture();
135
                ajoutEcriture();
125
 
136
 
126
            }
137
            }
-
 
138
 
-
 
139
            setDateReglement(regMontantRow.getTable().getTable("FACTURE_FOURNISSEUR"), factureFids, this.date);
-
 
140
 
127
        } else {
141
        } else {
128
 
142
 
129
            Date dateEch = ModeDeReglementSQLElement.calculDate(modeRegRow.getInt("AJOURS"), modeRegRow.getInt("LENJOUR"), this.date);
143
            Date dateEch = ModeDeReglementSQLElement.calculDate(modeRegRow.getInt("AJOURS"), modeRegRow.getInt("LENJOUR"), this.date);
130
            DateFormat dateFormat = new SimpleDateFormat();
144
            DateFormat dateFormat = new SimpleDateFormat();
131
            System.out.println("Date d'échéance " + dateFormat.format(dateEch));
145
            System.out.println("Date d'échéance " + dateFormat.format(dateEch));
Line 139... Line 153...
139
            } else {
153
            } else {
140
 
154
 
141
                // Ajout dans echeance
155
                // Ajout dans echeance
142
                Map<String, Object> mEcheance = new HashMap<String, Object>();
156
                Map<String, Object> mEcheance = new HashMap<String, Object>();
143
 
157
 
144
                this.idMvt = getNewMouvement("ECHEANCE_FOURNISSEUR", 1, rowMvtSource.getID(), rowMvtSource.getInt("ID_PIECE"));
158
                this.idMvt = getNewMouvement(rowMvtSource.getString("SOURCE"), rowMvtSource.getInt("IDSOURCE"), rowMvtSource.getID(), rowMvtSource.getInt("ID_PIECE"));
145
                mEcheance.put("ID_MOUVEMENT", new Integer(this.idMvt));
159
                mEcheance.put("ID_MOUVEMENT", new Integer(this.idMvt));
146
 
160
 
147
                mEcheance.put("DATE", dateEch);
161
                mEcheance.put("DATE", dateEch);
148
                mEcheance.put("MONTANT", new Long(prixTTC.getLongValue()));
162
                mEcheance.put("MONTANT", new Long(prixTTC.getLongValue()));
149
 
163
 
Line 160... Line 174...
160
 
174
 
161
            }
175
            }
162
        }
176
        }
163
    }
177
    }
164
 
178
 
-
 
179
    private void setDateReglement(SQLTable table, List<Integer> ids, Date d) throws SQLException {
-
 
180
        if (!ids.isEmpty()) {
-
 
181
            UpdateBuilder b = new UpdateBuilder(table);
-
 
182
            b.setObject("DATE_REGLEMENT", d);
-
 
183
            b.setWhere(new Where(table.getKey(), ids));
-
 
184
            table.getDBSystemRoot().getDataSource().execute(b.asString());
-
 
185
        }
-
 
186
    }
-
 
187
 
165
    private void paiementCheque(Date dateEch, SQLRow rowMvtSource, int idFourn, int idRegMontant) throws SQLException {
188
    private void paiementCheque(Date dateEch, SQLRow rowMvtSource, int idFourn, int idRegMontant) throws SQLException {
166
 
189
 
167
        SQLRow regMontantRow = base.getTable("REGLER_MONTANT").getRow(idRegMontant);
190
        SQLRow regMontantRow = base.getTable("REGLER_MONTANT").getRow(idRegMontant);
168
        PrixTTC prixTTC = new PrixTTC(((Long) regMontantRow.getObject("MONTANT")).longValue());
191
        PrixTTC prixTTC = new PrixTTC(((Long) regMontantRow.getObject("MONTANT")).longValue());
169
 
192