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 180
Line 18... Line 18...
18 
import org.openconcerto.sql.Configuration;
 18 
import org.openconcerto.sql.Configuration;
19 
import org.openconcerto.sql.model.SQLBase;
 19 
import org.openconcerto.sql.model.SQLBase;
20 
import org.openconcerto.sql.model.SQLRow;
 20 
import org.openconcerto.sql.model.SQLRow;
21 
import org.openconcerto.sql.model.SQLSelect;
 21 
import org.openconcerto.sql.model.SQLSelect;
22 
import org.openconcerto.sql.model.SQLTable;
 22 
import org.openconcerto.sql.model.SQLTable;
- 
 
 23 
import org.openconcerto.sql.model.Where;
23 
import org.openconcerto.ui.DefaultGridBagConstraints;
 24 
import org.openconcerto.ui.DefaultGridBagConstraints;
24 
import org.openconcerto.ui.warning.JLabelWarning;
 25 
import org.openconcerto.ui.warning.JLabelWarning;
25 
 
 26 
 
26 
import java.awt.GridBagConstraints;
 27 
import java.awt.GridBagConstraints;
27 
import java.awt.GridBagLayout;
 28 
import java.awt.GridBagLayout;
28 
import java.awt.event.ActionEvent;
 29 
import java.awt.event.ActionEvent;
29 
import java.awt.event.ActionListener;
 30 
import java.awt.event.ActionListener;
- 
 
 31 
import java.util.ArrayList;
- 
 
 32 
import java.util.HashSet;
30 
import java.util.List;
 33 
import java.util.List;
- 
 
 34 
import java.util.Set;
31 
 
 35 
 
32 
import javax.swing.JButton;
 36 
import javax.swing.JButton;
33 
import javax.swing.JFrame;
 37 
import javax.swing.JFrame;
34 
import javax.swing.JLabel;
 38 
import javax.swing.JLabel;
35 
import javax.swing.JOptionPane;
 39 
import javax.swing.JOptionPane;
Line 67... Line 71...
67 
            // c.gridwidth = 1;
 71 
            // c.gridwidth = 1;
68 
            c.gridy++;
 72 
            c.gridy++;
69 
            c.gridx = 0;
 73 
            c.gridx = 0;
70 
            this.add(labelMouv, c);
 74 
            this.add(labelMouv, c);
71 
            s.append(idS[0]);
 75 
            s.append(idS[0]);
- 
 
 76 
            List<Integer> idMvts = new ArrayList<>();
72 
            for (int i = 1; i < idS.length; i++) {
 77 
            for (int i = 1; i < idS.length; i++) {
73 
 
 - 
 
- 
 
 78 
                idMvts.add(idS[i]);
74 
                s.append(", ");
 79 
                s.append(", ");
75 
                s.append(idS[i]);
 80 
                s.append(idS[i]);
76 
            }
 81 
            }
77 
            s.append(')');
 82 
            s.append(')');
- 
 
 83 
 
- 
 
 84 
            Set<String> lettrage = getLettrage(idMvts);
- 
 
 85 
            if (lettrage != null && !lettrage.isEmpty()) {
- 
 
 86 
                s.append("\nAttention certaines écritures sont lettrées avec les codes(" + org.openconcerto.utils.CollectionUtils.join(lettrage, ",") + "!");
- 
 
 87 
            }
78 
            labelMouv.setText(s.toString());
 88 
            labelMouv.setText(s.toString());
- 
 
 89 
 
79 
        }
 90 
        }
80 
 
 91 
 
81 
        JButton buttonOK = new JButton("OK");
 92 
        JButton buttonOK = new JButton("OK");
82 
        JButton buttonCancel = new JButton("Annuler");
 93 
        JButton buttonCancel = new JButton("Annuler");
83 
 
 94 
 
Line 130... Line 141...
130 
        }
 141 
        }
131 
 
 142 
 
132 
        return idS;
 143 
        return idS;
133 
    }
 144 
    }
134 
 
 145 
 
- 
 
 146 
    private Set<String> getLettrage(List<Integer> mvtIds) {
- 
 
 147 
 
- 
 
 148 
        Set<String> codes = new HashSet<>();
- 
 
 149 
 
- 
 
 150 
        SQLBase b = ((ComptaPropsConfiguration) Configuration.getInstance()).getSQLBaseSociete();
- 
 
 151 
        SQLTable tableEcr = b.getTable("ECRITURE");
- 
 
 152 
 
- 
 
 153 
        SQLSelect sel = new SQLSelect();
- 
 
 154 
        sel.setDistinct(true);
- 
 
 155 
        sel.addSelect(tableEcr.getField("LETTRAGE"));
- 
 
 156 
        sel.setWhere(new Where(tableEcr.getField("ID_MOUVEMENT"), mvtIds).and(new Where(tableEcr.getField("LETTRAGE"), "=", "").and(new Where(tableEcr.getField("LETTRAGE"), "!=", (Object) null))));
- 
 
 157 
 
- 
 
 158 
        List l = (List) b.getDataSource().execute(sel.asString(), new ArrayListHandler());
- 
 
 159 
 
- 
 
 160 
        for (int i = 0; i < l.size(); i++) {
- 
 
 161 
            Object[] tmp = (Object[]) l.get(i);
- 
 
 162 
            codes.add(((String) tmp[0]));
- 
 
 163 
        }
- 
 
 164 
 
- 
 
 165 
        return codes;
- 
 
 166 
    }
- 
 
 167 
 
135 
}
 168 
}