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 13... Line 13...
13
 
13
 
14
 package org.openconcerto.erp.core.sales.invoice.ui;
14
 package org.openconcerto.erp.core.sales.invoice.ui;
15
 
15
 
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
17
import org.openconcerto.erp.config.Gestion;
17
import org.openconcerto.erp.config.Gestion;
18
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
-
 
19
import org.openconcerto.erp.core.common.ui.IListFilterDatePanel;
18
import org.openconcerto.erp.core.common.ui.IListFilterDatePanel;
20
import org.openconcerto.erp.core.common.ui.IListTotalPanel;
19
import org.openconcerto.erp.core.common.ui.IListTotalPanel;
21
import org.openconcerto.erp.core.customerrelationship.customer.element.RelanceSQLElement;
-
 
22
import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;
20
import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;
23
import org.openconcerto.erp.core.finance.payment.component.EncaisserMontantSQLComponent;
21
import org.openconcerto.erp.core.finance.payment.component.EncaisserMontantSQLComponent;
-
 
22
import org.openconcerto.erp.core.sales.invoice.element.EcheanceClientSQLElement;
24
import org.openconcerto.erp.rights.ComptaUserRight;
23
import org.openconcerto.erp.rights.ComptaUserRight;
25
import org.openconcerto.erp.rights.NXRights;
24
import org.openconcerto.erp.rights.NXRights;
26
import org.openconcerto.sql.Configuration;
25
import org.openconcerto.sql.Configuration;
27
import org.openconcerto.sql.element.SQLElement;
26
import org.openconcerto.sql.element.SQLElement;
28
import org.openconcerto.sql.model.SQLBase;
27
import org.openconcerto.sql.model.SQLBase;
29
import org.openconcerto.sql.model.SQLRow;
28
import org.openconcerto.sql.model.SQLRow;
30
import org.openconcerto.sql.model.SQLRowValues;
29
import org.openconcerto.sql.model.SQLRowValues;
31
import org.openconcerto.sql.model.SQLTable;
30
import org.openconcerto.sql.model.SQLTable;
32
import org.openconcerto.sql.users.rights.UserRightsManager;
31
import org.openconcerto.sql.users.rights.UserRightsManager;
33
import org.openconcerto.sql.view.EditFrame;
32
import org.openconcerto.sql.view.EditFrame;
34
import org.openconcerto.sql.view.EditPanelListener;
-
 
35
import org.openconcerto.sql.view.IListPanel;
33
import org.openconcerto.sql.view.IListPanel;
36
import org.openconcerto.sql.view.IListener;
34
import org.openconcerto.sql.view.IListener;
37
import org.openconcerto.sql.view.list.IListe;
35
import org.openconcerto.sql.view.list.IListe;
38
import org.openconcerto.ui.DefaultGridBagConstraints;
36
import org.openconcerto.ui.DefaultGridBagConstraints;
39
import org.openconcerto.utils.ExceptionHandler;
-
 
40
 
37
 
41
import java.awt.GridBagConstraints;
38
import java.awt.GridBagConstraints;
42
import java.awt.GridBagLayout;
39
import java.awt.GridBagLayout;
43
import java.awt.event.ActionEvent;
40
import java.awt.event.ActionEvent;
44
import java.awt.event.ActionListener;
41
import java.awt.event.ActionListener;
45
import java.awt.event.MouseAdapter;
42
import java.awt.event.MouseAdapter;
46
import java.awt.event.MouseEvent;
43
import java.awt.event.MouseEvent;
47
import java.sql.SQLException;
-
 
48
import java.util.ArrayList;
44
import java.util.ArrayList;
49
import java.util.Arrays;
45
import java.util.Arrays;
50
import java.util.Date;
-
 
51
import java.util.List;
46
import java.util.List;
52
 
47
 
53
import javax.swing.JButton;
48
import javax.swing.JButton;
54
import javax.swing.JCheckBox;
49
import javax.swing.JCheckBox;
55
import javax.swing.JOptionPane;
50
import javax.swing.JOptionPane;
Line 128... Line 123...
128
        if (UserRightsManager.getCurrentUserRights().haveRight(NXRights.GESTION_ENCAISSEMENT.getCode())) {
123
        if (UserRightsManager.getCurrentUserRights().haveRight(NXRights.GESTION_ENCAISSEMENT.getCode())) {
129
            c.gridx++;
124
            c.gridx++;
130
            this.add(this.relancer, c);
125
            this.add(this.relancer, c);
131
            this.relancer.addActionListener(new ActionListener() {
126
            this.relancer.addActionListener(new ActionListener() {
132
                public void actionPerformed(ActionEvent e) {
127
                public void actionPerformed(ActionEvent e) {
133
                    relanceClient();
128
                    ((EcheanceClientSQLElement) panelEcheances.getElement()).relanceClient(getListPanelEcheancesClients().getListe().getSelectedRow().asRow());
134
                }
129
                }
135
            });
130
            });
136
        }
131
        }
137
 
132
 
138
        // Bouton Encaisser
133
        // Bouton Encaisser
Line 270... Line 265...
270
        this.relancer.setEnabled(false);
265
        this.relancer.setEnabled(false);
271
        this.encaisser.setEnabled(false);
266
        this.encaisser.setEnabled(false);
272
 
267
 
273
    }
268
    }
274
 
269
 
275
    private void relanceClient() {
-
 
276
        SQLBase base = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
-
 
277
        final SQLElement relanceElt = Configuration.getInstance().getDirectory().getElement("RELANCE");
-
 
278
 
-
 
279
        final SQLRow rowSource = this.panelEcheances.getListe().fetchSelectedRow();
-
 
280
 
-
 
281
        if (rowSource != null) {
-
 
282
            int idMvtSource = MouvementSQLElement.getSourceId(rowSource.getInt("ID_MOUVEMENT"));
-
 
283
            SQLRow rowMvtSource = base.getTable("MOUVEMENT").getRow(idMvtSource);
-
 
284
 
-
 
285
            if (!rowMvtSource.getString("SOURCE").equalsIgnoreCase("SAISIE_VENTE_FACTURE")) {
-
 
286
                this.relancer.setEnabled(false);
-
 
287
                return;
-
 
288
            }
-
 
289
 
-
 
290
            if (this.editRelance == null) {
-
 
291
                this.editRelance = new EditFrame(relanceElt);
-
 
292
                this.editRelance.setIconImages(Gestion.getFrameIcon());
-
 
293
                this.editRelance.addEditPanelListener(new EditPanelListener() {
-
 
294
 
-
 
295
                    public void cancelled() {
-
 
296
                        // rien
-
 
297
                    }
-
 
298
 
-
 
299
                    public void modified() {
-
 
300
                        // rien
-
 
301
                    }
-
 
302
 
-
 
303
                    public void deleted() {
-
 
304
                        // rien
-
 
305
                    }
-
 
306
 
-
 
307
                    public void inserted(int id) {
-
 
308
                        int nbRelance = rowSource.getInt("NOMBRE_RELANCE");
-
 
309
                        nbRelance++;
-
 
310
 
-
 
311
                        SQLRowValues rowValsEch = new SQLRowValues(rowSource.getTable());
-
 
312
                        rowValsEch.put("NOMBRE_RELANCE", nbRelance);
-
 
313
                        rowValsEch.put("DATE_LAST_RELANCE", new Date());
-
 
314
 
-
 
315
                        try {
-
 
316
                            rowValsEch.update(rowSource.getID());
-
 
317
                            relanceElt.getTable().getRow(id).createEmptyUpdateRow().put("ID_ECHEANCE_CLIENT", rowSource.getID()).commit();
-
 
318
                        } catch (SQLException e1) {
-
 
319
                            ExceptionHandler.handle("erreur lors de la mise à jour du nombre de relances", e1);
-
 
320
                        }
-
 
321
                    }
-
 
322
                });
-
 
323
            }
-
 
324
 
-
 
325
            SQLRowValues rowVals = new SQLRowValues(relanceElt.getTable());
-
 
326
            rowVals.put("ID_SAISIE_VENTE_FACTURE", rowMvtSource.getInt("IDSOURCE"));
-
 
327
            rowVals.put("MONTANT", rowSource.getObject("MONTANT"));
-
 
328
            rowVals.put("ID_CLIENT", rowSource.getInt("ID_CLIENT"));
-
 
329
            rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(RelanceSQLElement.class, new Date()));
-
 
330
            this.editRelance.getSQLComponent().select(rowVals);
-
 
331
 
-
 
332
            this.editRelance.pack();
-
 
333
            this.editRelance.setVisible(true);
-
 
334
        } else {
-
 
335
            Thread.dumpStack();
-
 
336
        }
-
 
337
    }
-
 
338
 
-
 
339
    public IListPanel getListPanelEcheancesClients() {
270
    public IListPanel getListPanelEcheancesClients() {
340
        return this.panelEcheances;
271
        return this.panelEcheances;
341
    }
272
    }
342
}
273
}