OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

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

Rev 146 Rev 170
Line 1... Line 1...
1
/*
1
/*
2
 * Créé le 3 juin 2012
2
 * Créé le 3 juin 2012
3
 */
3
 */
4
package org.openconcerto.modules.project;
4
package org.openconcerto.modules.project;
5
 
5
 
6
import java.awt.Component;
-
 
7
import java.awt.FileDialog;
-
 
8
import java.awt.Frame;
-
 
9
import java.awt.GridBagConstraints;
6
import java.awt.GridBagConstraints;
10
import java.awt.event.ActionEvent;
-
 
11
import java.awt.event.WindowAdapter;
7
import java.awt.event.WindowAdapter;
12
import java.awt.event.WindowEvent;
8
import java.awt.event.WindowEvent;
13
import java.io.File;
9
import java.io.File;
14
import java.io.FilenameFilter;
-
 
15
import java.io.IOException;
-
 
16
import java.sql.SQLException;
-
 
17
import java.util.Arrays;
10
import java.util.Arrays;
18
import java.util.HashMap;
11
import java.util.HashMap;
19
import java.util.LinkedHashMap;
12
import java.util.LinkedHashMap;
20
import java.util.List;
13
import java.util.List;
21
import java.util.Map;
14
import java.util.Map;
22
 
15
 
23
import javax.swing.AbstractAction;
-
 
24
import javax.swing.JFrame;
16
import javax.swing.JFrame;
25
import javax.swing.JOptionPane;
17
import javax.swing.event.ListSelectionEvent;
-
 
18
import javax.swing.event.ListSelectionListener;
26
import javax.swing.event.TableModelEvent;
19
import javax.swing.event.TableModelEvent;
27
import javax.swing.event.TableModelListener;
20
import javax.swing.event.TableModelListener;
28
 
21
 
29
import org.openconcerto.erp.config.ComptaPropsConfiguration;
22
import org.openconcerto.erp.config.ComptaPropsConfiguration;
30
import org.openconcerto.erp.config.Gestion;
23
import org.openconcerto.erp.config.Gestion;
31
import org.openconcerto.erp.core.reports.history.ui.ListeHistoriquePanel;
24
import org.openconcerto.erp.core.reports.history.ui.ListeHistoriquePanel;
32
import org.openconcerto.erp.core.supplychain.order.action.ImportProductsToOrder;
25
import org.openconcerto.modules.project.panel.HistoriqueAffaireBilanPanel;
33
import org.openconcerto.sql.Configuration;
26
import org.openconcerto.sql.Configuration;
34
import org.openconcerto.sql.model.SQLBase;
27
import org.openconcerto.sql.model.SQLBase;
-
 
28
import org.openconcerto.sql.model.SQLField;
-
 
29
import org.openconcerto.sql.model.SQLRowAccessor;
-
 
30
import org.openconcerto.sql.model.SQLSelect;
-
 
31
import org.openconcerto.sql.model.SQLTable;
-
 
32
import org.openconcerto.sql.model.SQLTableEvent;
-
 
33
import org.openconcerto.sql.model.SQLTableModifiedListener;
-
 
34
import org.openconcerto.sql.model.Where;
35
import org.openconcerto.sql.request.ComboSQLRequest;
35
import org.openconcerto.sql.request.ComboSQLRequest;
36
import org.openconcerto.sql.view.IListPanel;
36
import org.openconcerto.sql.view.IListPanel;
37
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
-
 
38
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
-
 
39
import org.openconcerto.ui.DefaultGridBagConstraints;
37
import org.openconcerto.ui.DefaultGridBagConstraints;
40
import org.openconcerto.ui.PanelFrame;
38
import org.openconcerto.ui.PanelFrame;
41
import org.openconcerto.ui.SwingThreadUtils;
-
 
42
import org.openconcerto.ui.state.WindowStateManager;
39
import org.openconcerto.ui.state.WindowStateManager;
-
 
40
import org.openconcerto.utils.cc.ITransformer;
43
 
41
 
44
public class ProjectHistory {
42
public class ProjectHistory {
45
    private PanelFrame panelFrame;
43
    private PanelFrame panelFrame;
46
    private ListeHistoriquePanel listPanel;
44
    private ListeHistoriquePanel listPanel;
47
 
45
 
Line 61... Line 59...
61
        final SQLBase b = comptaPropsConfiguration.getSQLBaseSociete();
59
        final SQLBase b = comptaPropsConfiguration.getSQLBaseSociete();
62
 
60
 
63
        final Map<String, List<String>> mapList = new LinkedHashMap<String, List<String>>();
61
        final Map<String, List<String>> mapList = new LinkedHashMap<String, List<String>>();
64
        mapList.put("Devis", Arrays.asList("DEVIS"));
62
        mapList.put("Devis", Arrays.asList("DEVIS"));
65
        mapList.put("Bons de commande", Arrays.asList("COMMANDE_CLIENT"));
63
        mapList.put("Bons de commande", Arrays.asList("COMMANDE_CLIENT"));
-
 
64
        mapList.put("Chiffrage", Arrays.asList("CHIFFRAGE_COMMANDE_CLIENT"));
66
        mapList.put("Factures", Arrays.asList("SAISIE_VENTE_FACTURE"));
65
        mapList.put("Factures", Arrays.asList("SAISIE_VENTE_FACTURE"));
67
        mapList.put("Avoirs", Arrays.asList("AVOIR_CLIENT"));
66
        mapList.put("Avoirs", Arrays.asList("AVOIR_CLIENT"));
68
        mapList.put("Demandes d'achat", Arrays.asList("DEMANDE_ACHAT_ELEMENT"));
67
        mapList.put("Demandes d'achat", Arrays.asList("DEMANDE_ACHAT_ELEMENT"));
69
        mapList.put("Demandes de prix", Arrays.asList("DEMANDE_PRIX"));
68
        mapList.put("Demandes de prix", Arrays.asList("DEMANDE_PRIX"));
70
        mapList.put("Commandes", Arrays.asList("COMMANDE"));
69
        mapList.put("Commandes", Arrays.asList("COMMANDE"));
-
 
70
        mapList.put("Bons de réception", Arrays.asList("BON_RECEPTION"));
71
        mapList.put("Achats", Arrays.asList("SAISIE_ACHAT"));
71
        mapList.put("Achats", Arrays.asList("SAISIE_ACHAT"));
-
 
72
        // mapList.put("Factures fournisseurs", Arrays.asList("FACTURE_FOURNISSEUR"));
-
 
73
        mapList.put("Avoirs fournisseurs", Arrays.asList("AVOIR_FOURNISSEUR"));
72
 
74
 
73
        if (Configuration.getInstance().getRoot().findTable("AFFAIRE_TEMPS") != null) {
75
        if (Configuration.getInstance().getRoot().findTable("AFFAIRE_TEMPS") != null) {
74
            mapList.put("Temps", Arrays.asList("AFFAIRE_TEMPS"));
76
            mapList.put("Temps", Arrays.asList("AFFAIRE_TEMPS"));
75
        }
77
        }
76
 
78
 
77
        mapList.putAll(moduleTab);
79
        mapList.putAll(moduleTab);
78
 
80
 
-
 
81
        final HistoriqueAffaireBilanPanel bilanPanel = new HistoriqueAffaireBilanPanel();
-
 
82
 
79
        final ComboSQLRequest request = new org.openconcerto.sql.request.ComboSQLRequest(b.getTable("AFFAIRE"), Arrays.asList("NUMERO", "ID_CLIENT"));
83
        final ComboSQLRequest request = new org.openconcerto.sql.request.ComboSQLRequest(b.getTable("AFFAIRE"), Arrays.asList("NUMERO", "ID_CLIENT"));
-
 
84
        if (b.getTable("AFFAIRE").contains("ID_SOCIETE_COMMON")) {
-
 
85
 
-
 
86
            final int socID = comptaPropsConfiguration.getSocieteID();
-
 
87
            request.setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {
-
 
88
                @Override
-
 
89
                public SQLSelect transformChecked(SQLSelect input) {
-
 
90
                    Where w = new Where(b.getTable("AFFAIRE").getField("ID_SOCIETE_COMMON"), "=", (Object) null).or(new Where(b.getTable("AFFAIRE").getField("ID_SOCIETE_COMMON"), "=", 1))
-
 
91
                            .or(new Where(b.getTable("AFFAIRE").getField("ID_SOCIETE_COMMON"), "=", socID));
-
 
92
 
-
 
93
                    input.andWhere(w);
-
 
94
                    return input;
-
 
95
                }
-
 
96
            });
-
 
97
        }
80
        request.setUndefLabel("Toutes les affaires");
98
        request.setUndefLabel("Toutes les affaires");
81
        request.setFieldSeparator(" ");
99
        request.setFieldSeparator(" ");
82
 
-
 
-
 
100
        Map<String, String> splitter = new HashMap<String, String>();
-
 
101
        splitter.put("DEMANDE_ACHAT_ELEMENT", "ID_FAMILLE_ARTICLE");
-
 
102
        Map<SQLTable, SQLField> fieldLink = new HashMap<SQLTable, SQLField>();
-
 
103
        fieldLink.put(b.getTable("CHIFFRAGE_COMMANDE_CLIENT"), b.getTable("CHIFFRAGE_COMMANDE_CLIENT").getField("ID_COMMANDE_CLIENT"));
83
        this.listPanel = new ListeHistoriquePanel("Affaires", request, mapList, null, null, "Toutes les affaires", true, null, null);
104
        this.listPanel = new ListeHistoriquePanel("Affaires", request, mapList, bilanPanel, fieldLink, "Toutes les affaires", true, null, null, splitter);
84
 
105
 
85
        final IListPanel listeDevis = listPanel.getIListePanelFromTableName("DEVIS");
106
        final IListPanel listeDevis = listPanel.getIListePanelFromTableName("DEVIS");
86
        GridBagConstraints c = new DefaultGridBagConstraints();
107
        GridBagConstraints c = new DefaultGridBagConstraints();
87
        c.gridy = 4;
108
        c.gridy = 4;
88
        c.fill = GridBagConstraints.BOTH;
109
        c.fill = GridBagConstraints.BOTH;
Line 95... Line 116...
95
                devisPanel.updateDevis(listeDevis.getListe());
116
                devisPanel.updateDevis(listeDevis.getListe());
96
                devisPanel.updateTimeDevis(listeDevis.getListe());
117
                devisPanel.updateTimeDevis(listeDevis.getListe());
97
            }
118
            }
98
        });
119
        });
99
 
120
 
100
        final IListPanel listeDmdAchat = listPanel.getIListePanelFromTableName("DEMANDE_ACHAT_ELEMENT");
-
 
101
        PredicateRowAction actionDrop = new PredicateRowAction(new AbstractAction("Importer depuis Fichier Inventor") {
-
 
102
 
-
 
103
            @Override
-
 
104
            public void actionPerformed(ActionEvent e) {
-
 
105
                final Frame frame = SwingThreadUtils.getAncestorOrSelf(Frame.class, (Component) e.getSource());
-
 
106
                final FileDialog fd = new FileDialog(frame, "Import fichier inventor", FileDialog.LOAD);
-
 
107
                fd.setFilenameFilter(new FilenameFilter() {
-
 
108
                    @Override
-
 
109
                    public boolean accept(File dir, String name) {
-
 
110
                        return name.endsWith(".xls");
-
 
111
                    }
-
 
112
                });
-
 
113
                fd.setVisible(true);
-
 
114
                if (fd.getFile() != null) {
-
 
115
 
-
 
116
                    ImportProductsToOrder importer = new ImportProductsToOrder();
-
 
117
 
-
 
118
                    int a = JOptionPane.showConfirmDialog(frame, "Etes vous sûr de vouloir importer ces éléments dans l'affaire N°" + listPanel.getSelectedRow().getString("NUMERO") + "?",
-
 
119
                            "Import invertor", JOptionPane.YES_NO_OPTION);
-
 
120
                    if (a == JOptionPane.YES_OPTION) {
-
 
121
                        importer.setRowAffaire(listPanel.getSelectedRow());
-
 
122
                        try {
-
 
123
                            importer.importFile(new File(fd.getDirectory(), fd.getFile()), b.getTable("DEMANDE_ACHAT_ELEMENT").getDBRoot());
-
 
124
                            listeDmdAchat.getListe().getModel().updateAll();
-
 
125
                        } catch (IOException e1) {
-
 
126
                            org.openconcerto.utils.ExceptionHandler.handle("Erreur lors de l'import du fichier!", e1);
-
 
127
                        } catch (SQLException e1) {
-
 
128
                            org.openconcerto.utils.ExceptionHandler.handle("Erreur lors de l'import du fichier!", e1);
-
 
129
                        }
-
 
130
                    }
-
 
131
                }
-
 
132
            }
-
 
133
        }, true);
-
 
134
        actionDrop.setPredicate(IListeEvent.createSelectionCountPredicate(0, Integer.MAX_VALUE));
-
 
135
        listeDmdAchat.getListe().addIListeAction(actionDrop);
-
 
136
 
-
 
137
        final IListPanel listeCmd = listPanel.getIListePanelFromTableName("COMMANDE_CLIENT");
121
        final IListPanel listeCmd = listPanel.getIListePanelFromTableName("COMMANDE_CLIENT");
138
        final ProjectHistoryCmdBottomPanel cmdPanel = new ProjectHistoryCmdBottomPanel();
122
        final ProjectHistoryCmdBottomPanel cmdPanel = new ProjectHistoryCmdBottomPanel();
139
 
123
 
140
        listeCmd.add(cmdPanel, c);
124
        listeCmd.add(cmdPanel, c);
141
        listeCmd.getListe().getTableModel().addTableModelListener(new TableModelListener() {
125
        listeCmd.getListe().getTableModel().addTableModelListener(new TableModelListener() {
Line 161... Line 145...
161
            });
145
            });
162
        }
146
        }
163
        // History
147
        // History
164
        this.panelFrame = new PanelFrame(this.listPanel, "Historique affaires");
148
        this.panelFrame = new PanelFrame(this.listPanel, "Historique affaires");
165
        this.panelFrame.addWindowListener(new WindowAdapter() {
149
        this.panelFrame.addWindowListener(new WindowAdapter() {
-
 
150
 
166
            public void windowClosing(WindowEvent e) {
151
            public void windowClosing(WindowEvent e) {
167
                listPanel.removeAllTableListener();
152
                listPanel.removeAllTableListener();
168
            };
153
            };
-
 
154
 
169
        });
155
        });
170
 
156
 
171
        this.panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
157
        this.panelFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
172
 
158
 
-
 
159
        final SQLTableModifiedListener cmdClientListener = new SQLTableModifiedListener() {
-
 
160
 
-
 
161
            @Override
-
 
162
            public void tableModified(SQLTableEvent evt) {
-
 
163
                if (bilanPanel != null) {
-
 
164
                    final SQLRowAccessor selectedRow = ProjectHistory.this.listPanel.getSelectedRow();
-
 
165
                    if (selectedRow != null) {
-
 
166
                        bilanPanel.updateCommandeClient(selectedRow.asRow());
-
 
167
                    }
-
 
168
                }
-
 
169
            }
-
 
170
        };
-
 
171
        final SQLTableModifiedListener devisListener = new SQLTableModifiedListener() {
-
 
172
 
-
 
173
            @Override
-
 
174
            public void tableModified(SQLTableEvent evt) {
-
 
175
                if (bilanPanel != null) {
-
 
176
                    final SQLRowAccessor selectedRow = ProjectHistory.this.listPanel.getSelectedRow();
-
 
177
                    if (selectedRow != null) {
-
 
178
                        bilanPanel.updateDevis(selectedRow.asRow());
-
 
179
                    }
-
 
180
                }
-
 
181
            }
-
 
182
        };
-
 
183
        this.panelFrame.addWindowListener(new WindowAdapter() {
-
 
184
            public void windowClosing(WindowEvent e) {
-
 
185
                listPanel.removeAllTableListener();
-
 
186
                b.getTable("COMMANDE_CLIENT").removeTableModifiedListener(cmdClientListener);
-
 
187
                b.getTable("DEVIS").removeTableModifiedListener(devisListener);
-
 
188
            };
-
 
189
        });
-
 
190
 
-
 
191
        b.getTable("COMMANDE_CLIENT").addTableModifiedListener(cmdClientListener);
-
 
192
        b.getTable("DEVIS").addTableModifiedListener(devisListener);
-
 
193
 
-
 
194
        this.listPanel.addListSelectionListener(new ListSelectionListener() {
-
 
195
 
-
 
196
            @Override
-
 
197
            public void valueChanged(ListSelectionEvent arg0) {
-
 
198
 
-
 
199
                final SQLRowAccessor selectedRow = ProjectHistory.this.listPanel.getSelectedRow();
-
 
200
                if (selectedRow != null) {
-
 
201
                    bilanPanel.updateCommandeClient(selectedRow.asRow());
-
 
202
                    bilanPanel.updateDevis(selectedRow.asRow());
-
 
203
                    bilanPanel.updateBilanPreBilan(ProjectHistory.this.listPanel.getIListeFromTableName("COMMANDE"));
-
 
204
                }
-
 
205
            }
-
 
206
        });
-
 
207
 
-
 
208
        this.listPanel.addListenerTable(new TableModelListener() {
-
 
209
            public void tableChanged(TableModelEvent arg0) {
-
 
210
                final SQLRowAccessor selectedRow = ProjectHistory.this.listPanel.getSelectedRow();
-
 
211
                if (selectedRow != null) {
-
 
212
                    bilanPanel.updateBilanPreBilan(ProjectHistory.this.listPanel.getIListeFromTableName("COMMANDE"));
-
 
213
                }
-
 
214
            }
-
 
215
        }, "COMMANDE");
-
 
216
 
-
 
217
        this.listPanel.addListenerTable(new TableModelListener() {
-
 
218
            public void tableChanged(TableModelEvent arg0) {
-
 
219
                bilanPanel.updateAchat(ProjectHistory.this.listPanel.getIListeFromTableName("SAISIE_ACHAT"), ProjectHistory.this.listPanel.getIListeFromTableName("AVOIR_FOURNISSEUR"));
-
 
220
            }
-
 
221
        }, "SAISIE_ACHAT");
-
 
222
        this.listPanel.addListenerTable(new TableModelListener() {
-
 
223
            public void tableChanged(TableModelEvent arg0) {
-
 
224
                bilanPanel.updateAchat(ProjectHistory.this.listPanel.getIListeFromTableName("SAISIE_ACHAT"), ProjectHistory.this.listPanel.getIListeFromTableName("AVOIR_FOURNISSEUR"));
-
 
225
            }
-
 
226
        }, "AVOIR_FOURNISSEUR");
-
 
227
 
-
 
228
        this.listPanel.addListenerTable(new TableModelListener() {
-
 
229
            public void tableChanged(TableModelEvent arg0) {
-
 
230
                bilanPanel.updateFacturer(ProjectHistory.this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE"), ProjectHistory.this.listPanel.getIListeFromTableName("AVOIR_CLIENT"));
-
 
231
            }
-
 
232
        }, "SAISIE_VENTE_FACTURE");
-
 
233
 
-
 
234
        this.listPanel.addListenerTable(new TableModelListener() {
-
 
235
            public void tableChanged(TableModelEvent arg0) {
-
 
236
                bilanPanel.updateFacturer(ProjectHistory.this.listPanel.getIListeFromTableName("SAISIE_VENTE_FACTURE"), ProjectHistory.this.listPanel.getIListeFromTableName("AVOIR_CLIENT"));
-
 
237
            }
-
 
238
        }, "AVOIR_CLIENT");
173
    }
239
    }
174
 
240
 
175
    public PanelFrame getFrame() {
241
    public PanelFrame getFrame() {
176
        this.panelFrame.setIconImages(Gestion.getFrameIcon());
242
        this.panelFrame.setIconImages(Gestion.getFrameIcon());
177
        final WindowStateManager stateManager = new WindowStateManager(this.panelFrame,
243
        final WindowStateManager stateManager = new WindowStateManager(this.panelFrame,