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 174
Line 16... Line 16...
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
16
import org.openconcerto.erp.config.ComptaPropsConfiguration;
17
import org.openconcerto.erp.core.finance.payment.element.ChequeAEncaisserSQLElement;
17
import org.openconcerto.erp.core.finance.payment.element.ChequeAEncaisserSQLElement;
18
import org.openconcerto.erp.rights.ComptaTotalUserRight;
18
import org.openconcerto.erp.rights.ComptaTotalUserRight;
19
import org.openconcerto.sql.Configuration;
19
import org.openconcerto.sql.Configuration;
20
import org.openconcerto.sql.model.SQLRow;
20
import org.openconcerto.sql.model.SQLRow;
-
 
21
import org.openconcerto.sql.model.SQLRowListRSH;
21
import org.openconcerto.sql.model.SQLRowValues;
22
import org.openconcerto.sql.model.SQLRowValues;
22
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
23
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
23
import org.openconcerto.sql.users.rights.UserRightsManager;
24
import org.openconcerto.sql.users.rights.UserRightsManager;
24
import org.openconcerto.sql.view.EditFrame;
25
import org.openconcerto.sql.view.EditFrame;
25
import org.openconcerto.sql.view.EditPanel.EditMode;
26
import org.openconcerto.sql.view.EditPanel.EditMode;
Line 51... Line 52...
51
        return new JButton("Aperçu du relevé");
52
        return new JButton("Aperçu du relevé");
52
    }
53
    }
53
 
54
 
54
    @Override
55
    @Override
55
    protected JTextComponent createLabelText() {
56
    protected JTextComponent createLabelText() {
56
        if (fieldLabel == null) {
57
        if (this.fieldLabel == null) {
57
            this.fieldLabel = new JTextField();
58
            this.fieldLabel = new JTextField();
58
        }
59
        }
59
        return fieldLabel;
60
        return this.fieldLabel;
60
    }
61
    }
61
 
62
 
62
    @Override
63
    @Override
63
    protected JButton createSubmitBtn(final SQLRequestComboBox banqueSelect, final JDate dateDepot, final JCheckBox checkImpression, final JTextComponent text) {
64
    protected JButton createSubmitBtn(final SQLRequestComboBox banqueSelect, final JDate dateDepot, final JCheckBox checkImpression, final JTextComponent text) {
64
        final JButton res = new JButton("Valider le dépôt");
65
        final JButton res = new JButton("Valider le dépôt");
65
        res.addActionListener(new ActionListener() {
66
        res.addActionListener(new ActionListener() {
66
            @Override
67
            @Override
67
            public void actionPerformed(ActionEvent e) {
68
            public void actionPerformed(ActionEvent e) {
68
                final String s = text.getText();
69
                final String s = text.getText();
69
                SQLRowValues rowValsDepot = new SQLRowValues(element.getTable().getTable("DEPOT_CHEQUE"));
70
                SQLRowValues rowValsDepot = new SQLRowValues(ListeDesChequesAEncaisserPanel.this.element.getTable().getTable("DEPOT_CHEQUE"));
70
                rowValsDepot.put("DATE", dateDepot.getValue());
71
                rowValsDepot.put("DATE", dateDepot.getValue());
71
                rowValsDepot.put("NOM", fieldLabel.getText());
72
                rowValsDepot.put("NOM", ListeDesChequesAEncaisserPanel.this.fieldLabel.getText());
72
                final SQLRow selectedBanque = banqueSelect.getSelectedRow();
73
                final SQLRow selectedBanque = banqueSelect.getSelectedRow();
73
                if (selectedBanque != null) {
74
                if (selectedBanque != null) {
74
                    rowValsDepot.put("ID_" + selectedBanque.getTable().getName(), selectedBanque.getID());
75
                    rowValsDepot.put("ID_" + selectedBanque.getTable().getName(), selectedBanque.getID());
75
                }
76
                }
76
                List<SQLRowValues> chq = getListe().getSelectedRows();
77
                final List<SQLRow> chq = SQLRowListRSH.fetch(getListe().getRequest().getPrimaryTable(), getListe().getSelection().getSelectedIDs());
77
                for (SQLRowValues sqlRowValues : chq) {
78
                for (SQLRow rowChq : chq) {
78
                    SQLRow rowChq = sqlRowValues.asRow();
-
 
79
                    rowChq.fetchValues();
-
 
80
                    SQLRowValues rowValsDepotElt = new SQLRowValues(element.getTable().getTable("DEPOT_CHEQUE_ELEMENT"));
79
                    SQLRowValues rowValsDepotElt = new SQLRowValues(ListeDesChequesAEncaisserPanel.this.element.getTable().getTable("DEPOT_CHEQUE_ELEMENT"));
81
                    rowValsDepotElt.put("ID_DEPOT_CHEQUE", rowValsDepot);
80
                    rowValsDepotElt.put("ID_DEPOT_CHEQUE", rowValsDepot);
82
                    if (rowChq.getObject("ID_CLIENT") != null && !rowChq.isForeignEmpty("ID_CLIENT")) {
81
                    if (rowChq.getObject("ID_CLIENT") != null && !rowChq.isForeignEmpty("ID_CLIENT")) {
83
                        rowValsDepotElt.put("ID_CLIENT", rowChq.getForeignID("ID_CLIENT"));
82
                        rowValsDepotElt.put("ID_CLIENT", rowChq.getForeignID("ID_CLIENT"));
84
                    }
83
                    }
85
                    rowValsDepotElt.put("TIERS", rowChq.getString("TIERS"));
84
                    rowValsDepotElt.put("TIERS", rowChq.getString("TIERS"));
Line 94... Line 93...
94
                        rowValsDepotElt.put("PIECE", rowChq.getForeign("ID_MOUVEMENT").getForeign("ID_PIECE").getString("NOM"));
93
                        rowValsDepotElt.put("PIECE", rowChq.getForeign("ID_MOUVEMENT").getForeign("ID_PIECE").getString("NOM"));
95
                    }
94
                    }
96
                    rowValsDepotElt.put("NUMERO", (rowChq.getObject("NUMERO") == null ? "" : rowChq.getObject("NUMERO")));
95
                    rowValsDepotElt.put("NUMERO", (rowChq.getObject("NUMERO") == null ? "" : rowChq.getObject("NUMERO")));
97
                    rowValsDepotElt.put("MONTANT", rowChq.getObject("MONTANT"));
96
                    rowValsDepotElt.put("MONTANT", rowChq.getObject("MONTANT"));
98
                }
97
                }
99
                EditFrame frame = new EditFrame(element.getDirectory().getElement("DEPOT_CHEQUE"), EditMode.CREATION);
98
                EditFrame frame = new EditFrame(ListeDesChequesAEncaisserPanel.this.element.getDirectory().getElement("DEPOT_CHEQUE"), EditMode.CREATION);
100
                frame.getSQLComponent().select(rowValsDepot);
99
                frame.getSQLComponent().select(rowValsDepot);
101
                frame.setVisible(true);
100
                frame.setVisible(true);
102
                text.setText("");
101
                text.setText("");
103
            }
102
            }
104
        });
103
        });