| Line 1... |
Line 1... |
| 1 |
package org.openconcerto.modules.project;
|
1 |
package org.openconcerto.modules.project;
|
| 2 |
|
2 |
|
| 3 |
import java.awt.Color;
|
3 |
import java.awt.Color;
|
| - |
|
4 |
import java.awt.GridBagConstraints;
|
| - |
|
5 |
import java.awt.GridBagLayout;
|
| 4 |
import java.awt.event.ActionEvent;
|
6 |
import java.awt.event.ActionEvent;
|
| - |
|
7 |
import java.awt.event.ActionListener;
|
| - |
|
8 |
import java.beans.PropertyChangeEvent;
|
| - |
|
9 |
import java.beans.PropertyChangeListener;
|
| 5 |
import java.io.IOException;
|
10 |
import java.io.IOException;
|
| - |
|
11 |
import java.math.BigDecimal;
|
| - |
|
12 |
import java.math.RoundingMode;
|
| 6 |
import java.sql.SQLException;
|
13 |
import java.sql.SQLException;
|
| 7 |
import java.util.ArrayList;
|
14 |
import java.util.ArrayList;
|
| 8 |
import java.util.Arrays;
|
15 |
import java.util.Arrays;
|
| 9 |
import java.util.Collection;
|
16 |
import java.util.Collection;
|
| 10 |
import java.util.Date;
|
17 |
import java.util.Date;
|
| 11 |
import java.util.List;
|
18 |
import java.util.List;
|
| 12 |
import java.util.Map;
|
19 |
import java.util.Map;
|
| 13 |
import java.util.Set;
|
20 |
import java.util.Set;
|
| 14 |
|
21 |
|
| 15 |
import javax.swing.AbstractAction;
|
22 |
import javax.swing.AbstractAction;
|
| - |
|
23 |
import javax.swing.JButton;
|
| 16 |
import javax.swing.JComponent;
|
24 |
import javax.swing.JComponent;
|
| 17 |
import javax.swing.JFrame;
|
25 |
import javax.swing.JFrame;
|
| - |
|
26 |
import javax.swing.JLabel;
|
| 18 |
import javax.swing.JOptionPane;
|
27 |
import javax.swing.JOptionPane;
|
| - |
|
28 |
import javax.swing.JPanel;
|
| 19 |
import javax.swing.JScrollPane;
|
29 |
import javax.swing.JScrollPane;
|
| 20 |
import javax.swing.SwingUtilities;
|
30 |
import javax.swing.SwingUtilities;
|
| 21 |
|
31 |
|
| 22 |
import org.openconcerto.erp.action.CreateFrameAbstractAction;
|
32 |
import org.openconcerto.erp.action.CreateFrameAbstractAction;
|
| 23 |
import org.openconcerto.erp.config.ComptaPropsConfiguration;
|
33 |
import org.openconcerto.erp.config.ComptaPropsConfiguration;
|
| Line 49... |
Line 59... |
| 49 |
import org.openconcerto.sql.model.DBRoot;
|
59 |
import org.openconcerto.sql.model.DBRoot;
|
| 50 |
import org.openconcerto.sql.model.FieldPath;
|
60 |
import org.openconcerto.sql.model.FieldPath;
|
| 51 |
import org.openconcerto.sql.model.SQLRow;
|
61 |
import org.openconcerto.sql.model.SQLRow;
|
| 52 |
import org.openconcerto.sql.model.SQLRowAccessor;
|
62 |
import org.openconcerto.sql.model.SQLRowAccessor;
|
| 53 |
import org.openconcerto.sql.model.SQLRowValues;
|
63 |
import org.openconcerto.sql.model.SQLRowValues;
|
| - |
|
64 |
import org.openconcerto.sql.model.SQLRowValuesListFetcher;
|
| 54 |
import org.openconcerto.sql.model.SQLSelect;
|
65 |
import org.openconcerto.sql.model.SQLSelect;
|
| - |
|
66 |
import org.openconcerto.sql.model.SQLSelectJoin;
|
| 55 |
import org.openconcerto.sql.model.SQLTable;
|
67 |
import org.openconcerto.sql.model.SQLTable;
|
| 56 |
import org.openconcerto.sql.model.SQLTableEvent;
|
68 |
import org.openconcerto.sql.model.SQLTableEvent;
|
| 57 |
import org.openconcerto.sql.model.SQLTableEvent.Mode;
|
69 |
import org.openconcerto.sql.model.SQLTableEvent.Mode;
|
| 58 |
import org.openconcerto.sql.model.SQLTableModifiedListener;
|
70 |
import org.openconcerto.sql.model.SQLTableModifiedListener;
|
| 59 |
import org.openconcerto.sql.model.Where;
|
71 |
import org.openconcerto.sql.model.Where;
|
| 60 |
import org.openconcerto.sql.model.graph.Link.Direction;
|
72 |
import org.openconcerto.sql.model.graph.Link.Direction;
|
| 61 |
import org.openconcerto.sql.model.graph.Path;
|
73 |
import org.openconcerto.sql.model.graph.Path;
|
| - |
|
74 |
import org.openconcerto.sql.request.ComboSQLRequest;
|
| - |
|
75 |
import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
|
| 62 |
import org.openconcerto.sql.utils.AlterTable;
|
76 |
import org.openconcerto.sql.utils.AlterTable;
|
| 63 |
import org.openconcerto.sql.utils.SQLCreateTable;
|
77 |
import org.openconcerto.sql.utils.SQLCreateTable;
|
| 64 |
import org.openconcerto.sql.view.EditFrame;
|
78 |
import org.openconcerto.sql.view.EditFrame;
|
| - |
|
79 |
import org.openconcerto.sql.view.EditPanel.EditMode;
|
| 65 |
import org.openconcerto.sql.view.IListFrame;
|
80 |
import org.openconcerto.sql.view.IListFrame;
|
| 66 |
import org.openconcerto.sql.view.ListeAddPanel;
|
81 |
import org.openconcerto.sql.view.ListeAddPanel;
|
| 67 |
import org.openconcerto.sql.view.column.ColumnFooterRenderer;
|
82 |
import org.openconcerto.sql.view.column.ColumnFooterRenderer;
|
| 68 |
import org.openconcerto.sql.view.column.ColumnPanel;
|
83 |
import org.openconcerto.sql.view.column.ColumnPanel;
|
| 69 |
import org.openconcerto.sql.view.column.ColumnPanelFetcher;
|
84 |
import org.openconcerto.sql.view.column.ColumnPanelFetcher;
|
| 70 |
import org.openconcerto.sql.view.column.ColumnRowRenderer;
|
85 |
import org.openconcerto.sql.view.column.ColumnRowRenderer;
|
| 71 |
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
|
86 |
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
|
| 72 |
import org.openconcerto.sql.view.list.IListe;
|
87 |
import org.openconcerto.sql.view.list.IListe;
|
| 73 |
import org.openconcerto.sql.view.list.RowAction;
|
88 |
import org.openconcerto.sql.view.list.RowAction;
|
| - |
|
89 |
import org.openconcerto.ui.DefaultGridBagConstraints;
|
| - |
|
90 |
import org.openconcerto.ui.FrameUtil;
|
| - |
|
91 |
import org.openconcerto.ui.PanelFrame;
|
| 74 |
import org.openconcerto.utils.CollectionUtils;
|
92 |
import org.openconcerto.utils.CollectionUtils;
|
| 75 |
import org.openconcerto.utils.ExceptionHandler;
|
93 |
import org.openconcerto.utils.ExceptionHandler;
|
| 76 |
import org.openconcerto.utils.Tuple2;
|
94 |
import org.openconcerto.utils.Tuple2;
|
| 77 |
import org.openconcerto.utils.cc.IClosure;
|
95 |
import org.openconcerto.utils.cc.IExnClosure;
|
| 78 |
import org.openconcerto.utils.cc.ITransformer;
|
96 |
import org.openconcerto.utils.cc.ITransformer;
|
| 79 |
import org.openconcerto.utils.i18n.TranslationManager;
|
97 |
import org.openconcerto.utils.i18n.TranslationManager;
|
| 80 |
|
98 |
|
| 81 |
public final class Module extends AbstractModule {
|
99 |
public final class Module extends AbstractModule {
|
| 82 |
|
100 |
|
| 83 |
public static final String PROJECT_TABLENAME = "AFFAIRE";
|
101 |
public static final String PROJECT_TABLENAME = "AFFAIRE";
|
| 84 |
private List<String> listTableAffaire = Arrays.asList("DEMANDE_PRIX", "DEMANDE_ACHAT_ELEMENT", "SAISIE_VENTE_FACTURE", "AVOIR_CLIENT", "BON_DE_LIVRAISON", "COMMANDE_CLIENT", "DEVIS", "COMMANDE",
|
102 |
private List<String> listTableAffaire = Arrays.asList("DEMANDE_PRIX", "BON_RECEPTION", "DEMANDE_ACHAT_ELEMENT", "SAISIE_VENTE_FACTURE", "AVOIR_CLIENT", "BON_DE_LIVRAISON", "COMMANDE_CLIENT",
|
| 85 |
"SAISIE_ACHAT", "AVOIR_FOURNISSEUR");
|
103 |
"DEVIS", "COMMANDE", "SAISIE_ACHAT", "AVOIR_FOURNISSEUR");
|
| 86 |
|
104 |
|
| 87 |
public Module(ModuleFactory f) throws IOException {
|
105 |
public Module(ModuleFactory f) throws IOException {
|
| 88 |
super(f);
|
106 |
super(f);
|
| 89 |
|
107 |
|
| 90 |
}
|
108 |
}
|
| 91 |
|
109 |
|
| 92 |
@Override
|
110 |
@Override
|
| 93 |
protected void install(DBContext ctxt) {
|
111 |
protected void install(DBContext ctxt) throws SQLException, IOException {
|
| 94 |
super.install(ctxt);
|
112 |
super.install(ctxt);
|
| 95 |
|
113 |
|
| 96 |
if (ctxt.getLastInstalledVersion() == null) {
|
114 |
if (ctxt.getLastInstalledVersion() == null) {
|
| 97 |
|
115 |
|
| 98 |
if (ctxt.getRoot().getTable(PROJECT_TABLENAME) == null) {
|
116 |
if (ctxt.getRoot().getTable(PROJECT_TABLENAME) == null) {
|
| Line 119... |
Line 137... |
| 119 |
if (!tableDevis.getFieldsName().contains("ID_AFFAIRE")) {
|
137 |
if (!tableDevis.getFieldsName().contains("ID_AFFAIRE")) {
|
| 120 |
AlterTableRestricted alter = ctxt.getAlterTable(table);
|
138 |
AlterTableRestricted alter = ctxt.getAlterTable(table);
|
| 121 |
alter.addForeignColumn("ID_AFFAIRE", createTable);
|
139 |
alter.addForeignColumn("ID_AFFAIRE", createTable);
|
| 122 |
}
|
140 |
}
|
| 123 |
}
|
141 |
}
|
| - |
|
142 |
|
| 124 |
ctxt.manipulateData(new IClosure<DBRoot>() {
|
143 |
ctxt.manipulateData(new IExnClosure<DBRoot, SQLException>() {
|
| - |
|
144 |
|
| 125 |
@Override
|
145 |
@Override
|
| 126 |
public void executeChecked(DBRoot input) {
|
146 |
public void executeChecked(DBRoot input) throws SQLException {
|
| 127 |
// Undefined Affaire
|
147 |
// Undefined Affaire
|
| 128 |
SQLTable tableAff = input.getTable(PROJECT_TABLENAME);
|
148 |
SQLTable tableAff = input.getTable(PROJECT_TABLENAME);
|
| 129 |
SQLRowValues rowVals = new SQLRowValues(tableAff);
|
149 |
SQLRowValues rowVals = new SQLRowValues(tableAff);
|
| 130 |
try {
|
- |
|
| 131 |
rowVals.insert();
|
150 |
rowVals.insert();
|
| 132 |
} catch (SQLException exn) {
|
- |
|
| 133 |
// TODO Bloc catch auto-généré
|
- |
|
| 134 |
exn.printStackTrace();
|
- |
|
| 135 |
}
|
- |
|
| 136 |
|
151 |
|
| 137 |
// Etat Affaire
|
152 |
// Etat Affaire
|
| 138 |
SQLTable tableTypeAffaire = input.getTable("TYPE_AFFAIRE");
|
153 |
SQLTable tableTypeAffaire = input.getTable("TYPE_AFFAIRE");
|
| 139 |
rowVals = new SQLRowValues(tableTypeAffaire);
|
154 |
rowVals = new SQLRowValues(tableTypeAffaire);
|
| 140 |
try {
|
- |
|
| 141 |
rowVals.put("NOM", "Indéfini");
|
155 |
rowVals.put("NOM", "Indéfini");
|
| 142 |
rowVals.insert();
|
156 |
rowVals.insert();
|
| 143 |
} catch (SQLException exn) {
|
- |
|
| 144 |
// TODO Bloc catch auto-généré
|
- |
|
| 145 |
exn.printStackTrace();
|
- |
|
| 146 |
}
|
- |
|
| 147 |
|
157 |
|
| 148 |
// Etat Affaire
|
158 |
// Etat Affaire
|
| 149 |
SQLTable tableEtatAffaire = input.getTable("ETAT_AFFAIRE");
|
159 |
SQLTable tableEtatAffaire = input.getTable("ETAT_AFFAIRE");
|
| 150 |
rowVals = new SQLRowValues(tableEtatAffaire);
|
160 |
rowVals = new SQLRowValues(tableEtatAffaire);
|
| 151 |
try {
|
- |
|
| 152 |
rowVals.put("NOM", "Indéfini");
|
161 |
rowVals.put("NOM", "Indéfini");
|
| 153 |
rowVals.insert();
|
162 |
rowVals.insert();
|
| 154 |
|
163 |
|
| 155 |
rowVals.clear();
|
164 |
rowVals.clear();
|
| 156 |
rowVals.put("NOM", "A traiter");
|
165 |
rowVals.put("NOM", "A traiter");
|
| Line 169... |
Line 178... |
| 169 |
rowVals.insert();
|
178 |
rowVals.insert();
|
| 170 |
|
179 |
|
| 171 |
rowVals.clear();
|
180 |
rowVals.clear();
|
| 172 |
rowVals.put("NOM", "Dossier clos");
|
181 |
rowVals.put("NOM", "Dossier clos");
|
| 173 |
rowVals.insert();
|
182 |
rowVals.insert();
|
| 174 |
} catch (SQLException exn) {
|
- |
|
| 175 |
exn.printStackTrace();
|
- |
|
| 176 |
}
|
- |
|
| 177 |
|
- |
|
| 178 |
}
|
183 |
}
|
| 179 |
});
|
184 |
});
|
| - |
|
185 |
|
| 180 |
}
|
186 |
}
|
| 181 |
}
|
187 |
}
|
| 182 |
|
188 |
|
| 183 |
}
|
189 |
}
|
| 184 |
|
190 |
|
| Line 305... |
Line 311... |
| 305 |
ProjectHistory histo = new ProjectHistory();
|
311 |
ProjectHistory histo = new ProjectHistory();
|
| 306 |
histo.getHistoriquePanel().selectIDinJList(IListe.get(e).getSelectedRow().getForeignID("ID_AFFAIRE"));
|
312 |
histo.getHistoriquePanel().selectIDinJList(IListe.get(e).getSelectedRow().getForeignID("ID_AFFAIRE"));
|
| 307 |
histo.getFrame().setVisible(true);
|
313 |
histo.getFrame().setVisible(true);
|
| 308 |
}
|
314 |
}
|
| 309 |
}, false) {
|
315 |
}, false) {
|
| - |
|
316 |
|
| 310 |
@Override
|
317 |
@Override
|
| 311 |
public boolean enabledFor(IListeEvent evt) {
|
318 |
public boolean enabledFor(IListeEvent evt) {
|
| 312 |
if (evt.getSelectedRows().size() == 1) {
|
319 |
if (evt.getSelectedRows().size() == 1) {
|
| 313 |
SQLRowAccessor r = evt.getSelectedRow();
|
320 |
SQLRowAccessor r = evt.getSelectedRow();
|
| 314 |
return !r.isForeignEmpty("ID_AFFAIRE");
|
321 |
return !r.isForeignEmpty("ID_AFFAIRE");
|
| Line 348... |
Line 355... |
| 348 |
Collection<? extends SQLRowAccessor> l = selectedRow.getReferentRows(selectedRow.getTable().getTable("AFFAIRE"));
|
355 |
Collection<? extends SQLRowAccessor> l = selectedRow.getReferentRows(selectedRow.getTable().getTable("AFFAIRE"));
|
| 349 |
histo.getHistoriquePanel().selectIDinJList(l.iterator().next().getID());
|
356 |
histo.getHistoriquePanel().selectIDinJList(l.iterator().next().getID());
|
| 350 |
histo.getFrame().setVisible(true);
|
357 |
histo.getFrame().setVisible(true);
|
| 351 |
}
|
358 |
}
|
| 352 |
}, false) {
|
359 |
}, false) {
|
| - |
|
360 |
|
| 353 |
@Override
|
361 |
@Override
|
| 354 |
public boolean enabledFor(IListeEvent evt) {
|
362 |
public boolean enabledFor(IListeEvent evt) {
|
| 355 |
if (evt.getSelectedRows().size() == 1) {
|
363 |
if (evt.getSelectedRows().size() == 1) {
|
| 356 |
SQLRowAccessor r = evt.getSelectedRow();
|
364 |
SQLRowAccessor r = evt.getSelectedRow();
|
| 357 |
Collection<? extends SQLRowAccessor> l = r.getReferentRows(r.getTable().getTable("AFFAIRE"));
|
365 |
Collection<? extends SQLRowAccessor> l = r.getReferentRows(r.getTable().getTable("AFFAIRE"));
|
| Line 380... |
Line 388... |
| 380 |
SQLTable table = elt.getTable();
|
388 |
SQLTable table = elt.getTable();
|
| 381 |
Path p = new Path(table).add(table.getTable("AFFAIRE"), Direction.REFERENT);
|
389 |
Path p = new Path(table).add(table.getTable("AFFAIRE"), Direction.REFERENT);
|
| 382 |
return CollectionUtils.createSet(new FieldPath(p, "NUMERO"));
|
390 |
return CollectionUtils.createSet(new FieldPath(p, "NUMERO"));
|
| 383 |
}
|
391 |
}
|
| 384 |
});
|
392 |
});
|
| 385 |
|
- |
|
| - |
|
393 |
new CmdToBrSQLInjector();
|
| 386 |
new QuoteToOrderSQLInjector();
|
394 |
new QuoteToOrderSQLInjector();
|
| 387 |
new QuoteToInvoiceSQLInjector();
|
395 |
new QuoteToInvoiceSQLInjector();
|
| 388 |
new OrderToInvoiceSQLInjector();
|
396 |
new OrderToInvoiceSQLInjector();
|
| 389 |
}
|
397 |
}
|
| 390 |
|
398 |
|
| 391 |
public void checkAffaire(int id) {
|
399 |
public static JFrame checkAffaire(int id) {
|
| - |
|
400 |
return checkAffaire(id, true);
|
| - |
|
401 |
}
|
| - |
|
402 |
|
| - |
|
403 |
public static JFrame checkAffaire(int id, final boolean createCommandeClient) {
|
| 392 |
final SQLTable tableDevis = Configuration.getInstance().getRoot().findTable("DEVIS");
|
404 |
final SQLTable tableDevis = Configuration.getInstance().getRoot().findTable("DEVIS");
|
| 393 |
final SQLTable tableNum = Configuration.getInstance().getRoot().findTable("NUMEROTATION_AUTO");
|
405 |
final SQLTable tableNum = Configuration.getInstance().getRoot().findTable("NUMEROTATION_AUTO");
|
| 394 |
final SQLRow row = tableDevis.getRow(id);
|
406 |
final SQLRow row = tableDevis.getRow(id);
|
| 395 |
final SQLRow rowAffaire = row.getForeign("ID_AFFAIRE");
|
407 |
final SQLRow rowAffaire = row.getForeign("ID_AFFAIRE");
|
| 396 |
if (rowAffaire == null || rowAffaire.isUndefined()) {
|
408 |
if (rowAffaire == null || rowAffaire.isUndefined()) {
|
| 397 |
if (row.getInt("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE) {
|
409 |
if (row.getInt("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE) {
|
| 398 |
// FIXME Vérifier si le devis n'est pas déjà rattaché à une affaire
|
410 |
// FIXME Vérifier si le devis n'est pas déjà rattaché à une affaire
|
| - |
|
411 |
|
| - |
|
412 |
JPanel p = new JPanel(new GridBagLayout());
|
| - |
|
413 |
GridBagConstraints c = new DefaultGridBagConstraints();
|
| - |
|
414 |
c.gridwidth = GridBagConstraints.REMAINDER;
|
| - |
|
415 |
p.add(new JLabel("Voulez vous intégrer ce devis sur une affaire existante?"), c);
|
| - |
|
416 |
c.gridy++;
|
| - |
|
417 |
c.gridwidth = 1;
|
| - |
|
418 |
p.add(new JLabel("Rattacher à l'affaire : "), c);
|
| - |
|
419 |
c.gridx++;
|
| - |
|
420 |
final SQLRequestComboBox box = new SQLRequestComboBox();
|
| - |
|
421 |
final ComboSQLRequest comboRequest = Configuration.getInstance().getDirectory().getElement("AFFAIRE").getComboRequest(true);
|
| - |
|
422 |
Where w = new Where(comboRequest.getPrimaryTable().getField("ID_CLIENT"), "=", row.getForeignID("ID_CLIENT"));
|
| - |
|
423 |
comboRequest.setWhere(w);
|
| - |
|
424 |
box.uiInit(comboRequest);
|
| - |
|
425 |
p.add(box, c);
|
| - |
|
426 |
c.gridy++;
|
| - |
|
427 |
c.gridx = 0;
|
| - |
|
428 |
final JButton buttonApply = new JButton("Appliquer");
|
| - |
|
429 |
JButton buttonAnnuler = new JButton("Nouvelle affaire");
|
| - |
|
430 |
p.add(buttonApply, c);
|
| - |
|
431 |
buttonApply.setEnabled(false);
|
| - |
|
432 |
box.addValueListener(new PropertyChangeListener() {
|
| - |
|
433 |
|
| - |
|
434 |
@Override
|
| - |
|
435 |
public void propertyChange(PropertyChangeEvent evt) {
|
| - |
|
436 |
buttonApply.setEnabled(box.getSelectedRow() != null);
|
| - |
|
437 |
|
| - |
|
438 |
}
|
| - |
|
439 |
});
|
| - |
|
440 |
c.gridx++;
|
| - |
|
441 |
p.add(buttonAnnuler, c);
|
| - |
|
442 |
final PanelFrame f = new PanelFrame(p, "Affection d'un devis à une affaire");
|
| - |
|
443 |
|
| - |
|
444 |
buttonAnnuler.addActionListener(new ActionListener() {
|
| - |
|
445 |
|
| - |
|
446 |
@Override
|
| - |
|
447 |
public void actionPerformed(ActionEvent ae) {
|
| - |
|
448 |
f.dispose();
|
| 399 |
final SQLTable table = tableDevis.getTable(PROJECT_TABLENAME);
|
449 |
final SQLTable table = tableDevis.getTable(PROJECT_TABLENAME);
|
| 400 |
final SQLRowValues rowVals = new SQLRowValues(table);
|
450 |
final SQLRowValues rowVals = new SQLRowValues(table);
|
| 401 |
|
451 |
|
| 402 |
final String nextNumero = NumerotationAutoSQLElement.getNextNumero(ProjectSQLElement.class);
|
452 |
final String nextNumero = NumerotationAutoSQLElement.getNextNumero(ProjectSQLElement.class);
|
| 403 |
rowVals.put("NUMERO", nextNumero);
|
453 |
rowVals.put("NUMERO", nextNumero);
|
| Line 421... |
Line 471... |
| 421 |
|
471 |
|
| 422 |
SQLRowValues rowValsDevis = row.asRowValues();
|
472 |
SQLRowValues rowValsDevis = row.asRowValues();
|
| 423 |
rowValsDevis.put("ID_AFFAIRE", rowVals);
|
473 |
rowValsDevis.put("ID_AFFAIRE", rowVals);
|
| 424 |
|
474 |
|
| 425 |
try {
|
475 |
try {
|
| - |
|
476 |
int id = rowVals.commit().getID();
|
| - |
|
477 |
row.fetchValues();
|
| - |
|
478 |
if (createCommandeClient) {
|
| - |
|
479 |
Configuration.getInstance().getDirectory().getElement(DevisSQLElement.class).transfertCommandeClient(Arrays.asList(row.asRowValues()));
|
| - |
|
480 |
EditFrame frame = new EditFrame(Configuration.getInstance().getDirectory().getElement("AFFAIRE"), EditMode.MODIFICATION);
|
| - |
|
481 |
frame.selectionId(id);
|
| - |
|
482 |
FrameUtil.showPacked(frame);
|
| - |
|
483 |
}
|
| - |
|
484 |
} catch (SQLException exn) {
|
| - |
|
485 |
// TODO Bloc catch auto-généré
|
| - |
|
486 |
exn.printStackTrace();
|
| - |
|
487 |
}
|
| - |
|
488 |
}
|
| - |
|
489 |
});
|
| - |
|
490 |
|
| - |
|
491 |
buttonApply.addActionListener(new ActionListener() {
|
| - |
|
492 |
|
| - |
|
493 |
@Override
|
| - |
|
494 |
public void actionPerformed(ActionEvent e) {
|
| - |
|
495 |
f.dispose();
|
| - |
|
496 |
|
| - |
|
497 |
SQLRowValues rowValsDevis = row.asRowValues();
|
| - |
|
498 |
rowValsDevis.put("ID_AFFAIRE", box.getSelectedId());
|
| - |
|
499 |
|
| - |
|
500 |
try {
|
| 426 |
rowVals.commit();
|
501 |
rowValsDevis.commit();
|
| 427 |
} catch (SQLException exn) {
|
502 |
} catch (SQLException exn) {
|
| 428 |
// TODO Bloc catch auto-généré
|
503 |
// TODO Bloc catch auto-généré
|
| 429 |
exn.printStackTrace();
|
504 |
exn.printStackTrace();
|
| 430 |
}
|
505 |
}
|
| 431 |
}
|
506 |
}
|
| - |
|
507 |
});
|
| - |
|
508 |
FrameUtil.show(f);
|
| - |
|
509 |
return f;
|
| - |
|
510 |
}
|
| 432 |
|
511 |
|
| 433 |
} else if (row.getInt("ID_ETAT_DEVIS") != EtatDevisSQLElement.ACCEPTE) {
|
512 |
} else if (row.getInt("ID_ETAT_DEVIS") != EtatDevisSQLElement.ACCEPTE) {
|
| 434 |
SQLRowValues rowVals = rowAffaire.asRowValues();
|
513 |
SQLRowValues rowVals = rowAffaire.asRowValues();
|
| 435 |
rowVals.putEmptyLink("ID_DEVIS");
|
514 |
rowVals.putEmptyLink("ID_DEVIS");
|
| 436 |
try {
|
515 |
try {
|
| 437 |
rowVals.update();
|
516 |
rowVals.update();
|
| 438 |
} catch (SQLException exn) {
|
517 |
} catch (SQLException exn) {
|
| 439 |
exn.printStackTrace();
|
518 |
exn.printStackTrace();
|
| 440 |
}
|
519 |
}
|
| 441 |
}
|
520 |
}
|
| - |
|
521 |
return null;
|
| 442 |
}
|
522 |
}
|
| 443 |
|
523 |
|
| 444 |
List<Integer> idsAsked = new ArrayList<Integer>();
|
524 |
List<Integer> idsAsked = new ArrayList<Integer>();
|
| 445 |
|
525 |
|
| 446 |
public void checkProjectState(final SQLRowAccessor rowFact) {
|
526 |
public void checkProjectState(final SQLRowAccessor rowFact) {
|
| Line 499... |
Line 579... |
| 499 |
}
|
579 |
}
|
| 500 |
selectedRow.getTable().fireTableModified(selectedRow.getID());
|
580 |
selectedRow.getTable().fireTableModified(selectedRow.getID());
|
| 501 |
checkAffaire(selectedRow.getID());
|
581 |
checkAffaire(selectedRow.getID());
|
| 502 |
}
|
582 |
}
|
| 503 |
}, false, "project.accept") {
|
583 |
}, false, "project.accept") {
|
| - |
|
584 |
|
| 504 |
public boolean enabledFor(List<SQLRowValues> selection) {
|
585 |
public boolean enabledFor(List<SQLRowValues> selection) {
|
| 505 |
if (selection != null && selection.size() == 1) {
|
586 |
if (selection != null && selection.size() == 1) {
|
| 506 |
if (selection.get(0).getInt("ID_ETAT_DEVIS") == EtatDevisSQLElement.EN_ATTENTE) {
|
587 |
if (selection.get(0).getInt("ID_ETAT_DEVIS") == EtatDevisSQLElement.EN_ATTENTE) {
|
| 507 |
return true;
|
588 |
return true;
|
| 508 |
}
|
589 |
}
|
| 509 |
}
|
590 |
}
|
| 510 |
return false;
|
591 |
return false;
|
| 511 |
};
|
592 |
};
|
| - |
|
593 |
|
| 512 |
};
|
594 |
};
|
| 513 |
}
|
595 |
}
|
| 514 |
|
596 |
|
| 515 |
@Override
|
597 |
@Override
|
| 516 |
protected void setupComponents(final ComponentsContext ctxt) {
|
598 |
protected void setupComponents(final ComponentsContext ctxt) {
|
| - |
|
599 |
|
| 517 |
DBRoot root = ComptaPropsConfiguration.getInstanceCompta().getRootSociete();
|
600 |
DBRoot root = ComptaPropsConfiguration.getInstanceCompta().getRootSociete();
|
| 518 |
List<String> table2check = Arrays.asList("DEMANDE_PRIX", "DEMANDE_ACHAT_ELEMENT");
|
601 |
List<String> table2check = Arrays.asList("BON_RECEPTION", "DEMANDE_PRIX", "DEMANDE_ACHAT_ELEMENT");
|
| 519 |
for (String table : table2check) {
|
602 |
for (String table : table2check) {
|
| 520 |
if (root.contains(table)) {
|
603 |
if (root.contains(table)) {
|
| 521 |
SQLTable tableCR = root.getTable(table);
|
604 |
SQLTable tableCR = root.getTable(table);
|
| 522 |
if (!tableCR.contains("ID_AFFAIRE")) {
|
605 |
if (!tableCR.contains("ID_AFFAIRE")) {
|
| 523 |
try {
|
606 |
try {
|
| Line 533... |
Line 616... |
| 533 |
e.printStackTrace();
|
616 |
e.printStackTrace();
|
| 534 |
}
|
617 |
}
|
| 535 |
}
|
618 |
}
|
| 536 |
}
|
619 |
}
|
| 537 |
}
|
620 |
}
|
| - |
|
621 |
|
| 538 |
for (String table : this.listTableAffaire) {
|
622 |
for (String table : this.listTableAffaire) {
|
| 539 |
if (!table.equalsIgnoreCase("DEVIS"))
|
623 |
if (!table.equalsIgnoreCase("DEVIS"))
|
| 540 |
ctxt.putAdditionalField(table, "ID_AFFAIRE");
|
624 |
ctxt.putAdditionalField(table, "ID_AFFAIRE");
|
| 541 |
}
|
625 |
}
|
| 542 |
|
626 |
|
| Line 565... |
Line 649... |
| 565 |
public JFrame createFrame() {
|
649 |
public JFrame createFrame() {
|
| 566 |
return new EditFrame(ctxt.getElement(PROJECT_TABLENAME));
|
650 |
return new EditFrame(ctxt.getElement(PROJECT_TABLENAME));
|
| 567 |
}
|
651 |
}
|
| 568 |
}, MainFrame.CREATE_MENU);
|
652 |
}, MainFrame.CREATE_MENU);
|
| 569 |
|
653 |
|
| 570 |
// ctxt.addMenuItem(new AbstractAction("Export Affaire") {
|
- |
|
| 571 |
// @Override
|
- |
|
| 572 |
// public void actionPerformed(ActionEvent e) {
|
- |
|
| 573 |
// ProjectImportExport importExport = new
|
- |
|
| 574 |
// ProjectImportExport(ctxt.getElement("AFFAIRE").getTable().getDBRoot());
|
- |
|
| 575 |
// importExport.export();
|
654 |
addMenuImportExport(ctxt);
|
| 576 |
// }
|
- |
|
| 577 |
// }, MainFrame.HELP_MENU);
|
- |
|
| 578 |
//
|
- |
|
| 579 |
// ctxt.addMenuItem(new AbstractAction("Import Affaire") {
|
- |
|
| 580 |
// @Override
|
- |
|
| 581 |
// public void actionPerformed(ActionEvent e) {
|
- |
|
| 582 |
// ProjectImportExport importExport = new
|
- |
|
| 583 |
// ProjectImportExport(ctxt.getElement("AFFAIRE").getTable().getDBRoot());
|
- |
|
| 584 |
// importExport.importProjects();
|
- |
|
| 585 |
// }
|
- |
|
| 586 |
// }, MainFrame.HELP_MENU);
|
- |
|
| 587 |
//
|
- |
|
| 588 |
// ctxt.addMenuItem(new AbstractAction("Fix ID_AFFAIRE") {
|
- |
|
| 589 |
// @Override
|
- |
|
| 590 |
// public void actionPerformed(ActionEvent e) {
|
- |
|
| 591 |
// {
|
- |
|
| 592 |
// SQLTable tableCmd = ctxt.getElement("COMMANDE_CLIENT").getTable();
|
- |
|
| 593 |
// SQLSelect selBadCmd = new SQLSelect();
|
- |
|
| 594 |
// selBadCmd.addSelect(tableCmd.getKey());
|
- |
|
| 595 |
// selBadCmd.addSelect(tableCmd.getField("ID_AFFAIRE"));
|
- |
|
| 596 |
// SQLSelectJoin joinTR = selBadCmd.addBackwardJoin("RIGHT", "tr",
|
- |
|
| 597 |
// tableCmd.getTable().getTable("TR_DEVIS").getField("ID_COMMANDE_CLIENT"), null);
|
- |
|
| 598 |
// SQLSelectJoin joinDevis = selBadCmd.addJoin("LEFT",
|
- |
|
| 599 |
// joinTR.getJoinedTable().getField("ID_DEVIS"));
|
- |
|
| 600 |
// SQLSelectJoin joinAff = selBadCmd.addBackwardJoin("LEFT", "aff",
|
- |
|
| 601 |
// tableCmd.getTable().getTable("AFFAIRE").getField("ID_DEVIS"), null);
|
- |
|
| 602 |
// selBadCmd.addSelect(joinAff.getJoinedTable().getKey());
|
- |
|
| 603 |
//
|
- |
|
| 604 |
// selBadCmd.setWhere(Where.isNull(tableCmd.getField("ID_AFFAIRE")));
|
- |
|
| 605 |
// System.err.println(selBadCmd.asString());
|
- |
|
| 606 |
//
|
- |
|
| 607 |
// List<Object[]> result = (List<Object[]>)
|
- |
|
| 608 |
// tableCmd.getDBSystemRoot().getDataSource().executeA(selBadCmd.asString());
|
- |
|
| 609 |
// try {
|
- |
|
| 610 |
// for (Object[] objects : result) {
|
- |
|
| 611 |
// if (objects[2] != null && objects[2].toString().trim().length() > 0)
|
- |
|
| 612 |
// tableCmd.getRow(((Number)
|
- |
|
| 613 |
// objects[0]).intValue()).createEmptyUpdateRow().put("ID_AFFAIRE", ((Number)
|
- |
|
| 614 |
// objects[2]).intValue()).commit();
|
- |
|
| 615 |
// }
|
- |
|
| 616 |
// } catch (SQLException e1) {
|
- |
|
| 617 |
// // TODO Auto-generated catch block
|
- |
|
| 618 |
// e1.printStackTrace();
|
- |
|
| 619 |
// }
|
- |
|
| 620 |
//
|
- |
|
| 621 |
// // List<SQLRow> list = SQLRowListRSH.execute(selBadVF);
|
- |
|
| 622 |
// }
|
- |
|
| 623 |
// {
|
- |
|
| 624 |
// SQLTable tableVF = ctxt.getElement("SAISIE_VENTE_FACTURE").getTable();
|
- |
|
| 625 |
// SQLSelect selBadVF = new SQLSelect();
|
- |
|
| 626 |
// selBadVF.addSelect(tableVF.getKey());
|
- |
|
| 627 |
// selBadVF.addSelect(tableVF.getField("ID_AFFAIRE"));
|
- |
|
| 628 |
// SQLSelectJoin joinTR = selBadVF.addBackwardJoin("RIGHT", "tr",
|
- |
|
| 629 |
// tableVF.getTable().getTable("TR_COMMANDE_CLIENT").getField("ID_SAISIE_VENTE_FACTURE"),
|
- |
|
| 630 |
// null);
|
- |
|
| 631 |
// SQLSelectJoin joinCmd = selBadVF.addJoin("LEFT",
|
- |
|
| 632 |
// joinTR.getJoinedTable().getField("ID_COMMANDE_CLIENT"));
|
- |
|
| 633 |
// selBadVF.addSelect(joinCmd.getJoinedTable().getField("ID_AFFAIRE"));
|
- |
|
| 634 |
//
|
- |
|
| 635 |
// selBadVF.setWhere(Where.isNull(tableVF.getField("ID_AFFAIRE")));
|
- |
|
| 636 |
// System.err.println(selBadVF.asString());
|
- |
|
| 637 |
// List<Object[]> result = (List<Object[]>)
|
- |
|
| 638 |
// tableVF.getDBSystemRoot().getDataSource().executeA(selBadVF.asString());
|
- |
|
| 639 |
// try {
|
- |
|
| 640 |
// for (Object[] objects : result) {
|
- |
|
| 641 |
// if (objects[2] != null && objects[2].toString().trim().length() > 0)
|
- |
|
| 642 |
// tableVF.getRow(((Number) objects[0]).intValue()).createEmptyUpdateRow().put("ID_AFFAIRE",
|
- |
|
| 643 |
// ((Number) objects[2]).intValue()).commit();
|
- |
|
| 644 |
// }
|
- |
|
| 645 |
// } catch (SQLException e1) {
|
- |
|
| 646 |
// // TODO Auto-generated catch block
|
- |
|
| 647 |
// e1.printStackTrace();
|
- |
|
| 648 |
// }
|
- |
|
| 649 |
// }
|
- |
|
| 650 |
// }
|
- |
|
| 651 |
// }, MainFrame.CREATE_MENU);
|
- |
|
| 652 |
//
|
- |
|
| 653 |
// ctxt.addMenuItem(new AbstractAction("Recalcul Total achat facture prorata") {
|
- |
|
| 654 |
// @Override
|
- |
|
| 655 |
// public void actionPerformed(ActionEvent e) {
|
- |
|
| 656 |
//
|
- |
|
| 657 |
// {
|
- |
|
| 658 |
// final SQLTable table = ctxt.getElement("SAISIE_VENTE_FACTURE").getTable();
|
- |
|
| 659 |
// SQLRowValues rowValsFact = new SQLRowValues(table);
|
- |
|
| 660 |
// rowValsFact.putNulls("SOLDE", "PARTIAL", "T_HA", "T_HT");
|
- |
|
| 661 |
//
|
- |
|
| 662 |
// final SQLTable tableCmd = ctxt.getElement("COMMANDE_CLIENT").getTable();
|
- |
|
| 663 |
// SQLRowValues rowValsCmd = new SQLRowValues(tableCmd);
|
- |
|
| 664 |
// rowValsCmd.putNulls("T_HT");
|
- |
|
| 665 |
//
|
- |
|
| 666 |
// final SQLTable tableCmdElt = ctxt.getElement("COMMANDE_CLIENT_ELEMENT").getTable();
|
- |
|
| 667 |
// SQLRowValues rowValsCmdElt = new SQLRowValues(tableCmdElt);
|
- |
|
| 668 |
// rowValsCmdElt.put("ID_COMMANDE_CLIENT", rowValsCmd);
|
- |
|
| 669 |
// rowValsCmdElt.putNulls("T_PA_HT", "NIVEAU");
|
- |
|
| 670 |
//
|
- |
|
| 671 |
// final SQLTable tableTR = table.getTable("TR_COMMANDE_CLIENT");
|
- |
|
| 672 |
// SQLRowValues rowValsTR = new SQLRowValues(tableTR);
|
- |
|
| 673 |
// rowValsTR.put("ID_SAISIE_VENTE_FACTURE", rowValsFact);
|
- |
|
| 674 |
// rowValsTR.put("ID_COMMANDE_CLIENT", rowValsCmd);
|
- |
|
| 675 |
//
|
- |
|
| 676 |
// SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(rowValsFact);
|
- |
|
| 677 |
// fetcher.appendSelTransf(new ITransformer<SQLSelect, SQLSelect>() {
|
- |
|
| 678 |
// @Override
|
- |
|
| 679 |
// public SQLSelect transformChecked(SQLSelect input) {
|
- |
|
| 680 |
// Where w = new Where(table.getField("SOLDE"), "=", Boolean.TRUE);
|
- |
|
| 681 |
// w = w.or(new Where(table.getField("PARTIAL"), "=", Boolean.TRUE));
|
- |
|
| 682 |
// input.setWhere(w);
|
- |
|
| 683 |
// return input;
|
- |
|
| 684 |
// }
|
- |
|
| 685 |
// });
|
- |
|
| 686 |
//
|
- |
|
| 687 |
// List<SQLRowValues> rowVals = fetcher.fetch();
|
- |
|
| 688 |
//
|
- |
|
| 689 |
// for (SQLRowValues sqlRowValues : rowVals) {
|
- |
|
| 690 |
// // Recuperation de la commande
|
- |
|
| 691 |
// final Collection<SQLRowValues> referentRows = sqlRowValues.getReferentRows(tableTR);
|
- |
|
| 692 |
// if (!referentRows.isEmpty()) {
|
- |
|
| 693 |
// SQLRowAccessor rowTR = referentRows.iterator().next();
|
- |
|
| 694 |
// SQLRowAccessor rowCmd = rowTR.getForeign("ID_COMMANDE_CLIENT");
|
- |
|
| 695 |
// final long htCmd = rowCmd.getLong("T_HT");
|
- |
|
| 696 |
// if (htCmd != 0) {
|
- |
|
| 697 |
//
|
- |
|
| 698 |
// BigDecimal totalHA = BigDecimal.ZERO;
|
- |
|
| 699 |
// Collection<? extends SQLRowAccessor> elt = rowCmd.getReferentRows(tableCmdElt);
|
- |
|
| 700 |
// for (SQLRowAccessor sqlRowAccessor : elt) {
|
- |
|
| 701 |
// if (sqlRowAccessor.getInt("NIVEAU") == 1) {
|
- |
|
| 702 |
// totalHA = totalHA.add(sqlRowAccessor.getBigDecimal("T_PA_HT"));
|
- |
|
| 703 |
// }
|
- |
|
| 704 |
// }
|
- |
|
| 705 |
// BigDecimal prorata = new BigDecimal((double) sqlRowValues.getLong("T_HT") / (double)
|
- |
|
| 706 |
// htCmd);
|
- |
|
| 707 |
// try {
|
- |
|
| 708 |
// sqlRowValues.createEmptyUpdateRow().put("T_HA",
|
- |
|
| 709 |
// totalHA.multiply(prorata).movePointRight(2).setScale(0,
|
- |
|
| 710 |
// RoundingMode.HALF_UP).longValue()).update();
|
- |
|
| 711 |
// } catch (SQLException e1) {
|
- |
|
| 712 |
// e1.printStackTrace();
|
- |
|
| 713 |
// }
|
- |
|
| 714 |
// }
|
- |
|
| 715 |
// }
|
- |
|
| 716 |
// }
|
- |
|
| 717 |
// }
|
- |
|
| 718 |
// }
|
- |
|
| 719 |
// }, MainFrame.CREATE_MENU);
|
- |
|
| 720 |
|
655 |
|
| 721 |
}
|
656 |
}
|
| 722 |
|
657 |
|
| - |
|
658 |
private void addMenuImportExport(final MenuContext ctxt) {
|
| - |
|
659 |
////
|
| - |
|
660 |
|
| - |
|
661 |
ctxt.addMenuItem(new AbstractAction("Export Affaire") {
|
| 723 |
@Override
|
662 |
@Override
|
| - |
|
663 |
public void actionPerformed(ActionEvent e) {
|
| - |
|
664 |
ProjectImportExport importExport = new ProjectImportExport(ctxt.getElement("AFFAIRE").getTable().getDBRoot());
|
| - |
|
665 |
importExport.export();
|
| - |
|
666 |
}
|
| - |
|
667 |
}, MainFrame.HELP_MENU);
|
| - |
|
668 |
|
| - |
|
669 |
ctxt.addMenuItem(new AbstractAction("Import Affaire") {
|
| - |
|
670 |
@Override
|
| - |
|
671 |
public void actionPerformed(ActionEvent e) {
|
| - |
|
672 |
ProjectImportExport importExport = new ProjectImportExport(ctxt.getElement("AFFAIRE").getTable().getDBRoot());
|
| - |
|
673 |
importExport.importProjects();
|
| - |
|
674 |
}
|
| - |
|
675 |
}, MainFrame.HELP_MENU);
|
| - |
|
676 |
|
| - |
|
677 |
ctxt.addMenuItem(new AbstractAction("Fix ID_AFFAIRE") {
|
| - |
|
678 |
@Override
|
| - |
|
679 |
public void actionPerformed(ActionEvent e) {
|
| - |
|
680 |
{
|
| - |
|
681 |
SQLTable tableCmd = ctxt.getElement("COMMANDE_CLIENT").getTable();
|
| - |
|
682 |
SQLSelect selBadCmd = new SQLSelect();
|
| - |
|
683 |
selBadCmd.addSelect(tableCmd.getKey());
|
| - |
|
684 |
selBadCmd.addSelect(tableCmd.getField("ID_AFFAIRE"));
|
| - |
|
685 |
SQLSelectJoin joinTR = selBadCmd.addBackwardJoin("RIGHT", "tr", tableCmd.getTable().getTable("TR_DEVIS").getField("ID_COMMANDE_CLIENT"), null);
|
| - |
|
686 |
SQLSelectJoin joinDevis = selBadCmd.addJoin("LEFT", joinTR.getJoinedTable().getField("ID_DEVIS"));
|
| - |
|
687 |
SQLSelectJoin joinAff = selBadCmd.addBackwardJoin("LEFT", "aff", tableCmd.getTable().getTable("AFFAIRE").getField("ID_DEVIS"), null);
|
| - |
|
688 |
selBadCmd.addSelect(joinAff.getJoinedTable().getKey());
|
| - |
|
689 |
|
| - |
|
690 |
selBadCmd.setWhere(Where.isNull(tableCmd.getField("ID_AFFAIRE")));
|
| - |
|
691 |
System.err.println(selBadCmd.asString());
|
| - |
|
692 |
|
| - |
|
693 |
List<Object[]> result = (List<Object[]>) tableCmd.getDBSystemRoot().getDataSource().executeA(selBadCmd.asString());
|
| - |
|
694 |
try {
|
| - |
|
695 |
for (Object[] objects : result) {
|
| - |
|
696 |
if (objects[2] != null && objects[2].toString().trim().length() > 0)
|
| - |
|
697 |
tableCmd.getRow(((Number) objects[0]).intValue()).createEmptyUpdateRow().put("ID_AFFAIRE", ((Number) objects[2]).intValue()).commit();
|
| - |
|
698 |
}
|
| - |
|
699 |
} catch (SQLException e1) {
|
| - |
|
700 |
// TODO Auto-generated catch block
|
| - |
|
701 |
e1.printStackTrace();
|
| - |
|
702 |
}
|
| - |
|
703 |
|
| - |
|
704 |
// List<SQLRow> list = SQLRowListRSH.execute(selBadVF);
|
| - |
|
705 |
}
|
| - |
|
706 |
{
|
| - |
|
707 |
SQLTable tableVF = ctxt.getElement("SAISIE_VENTE_FACTURE").getTable();
|
| - |
|
708 |
SQLSelect selBadVF = new SQLSelect();
|
| - |
|
709 |
selBadVF.addSelect(tableVF.getKey());
|
| - |
|
710 |
selBadVF.addSelect(tableVF.getField("ID_AFFAIRE"));
|
| - |
|
711 |
SQLSelectJoin joinTR = selBadVF.addBackwardJoin("RIGHT", "tr", tableVF.getTable().getTable("TR_COMMANDE_CLIENT").getField("ID_SAISIE_VENTE_FACTURE"), null);
|
| - |
|
712 |
SQLSelectJoin joinCmd = selBadVF.addJoin("LEFT", joinTR.getJoinedTable().getField("ID_COMMANDE_CLIENT"));
|
| - |
|
713 |
selBadVF.addSelect(joinCmd.getJoinedTable().getField("ID_AFFAIRE"));
|
| - |
|
714 |
|
| - |
|
715 |
selBadVF.setWhere(Where.isNull(tableVF.getField("ID_AFFAIRE")));
|
| - |
|
716 |
System.err.println(selBadVF.asString());
|
| - |
|
717 |
List<Object[]> result = (List<Object[]>) tableVF.getDBSystemRoot().getDataSource().executeA(selBadVF.asString());
|
| 724 |
protected void start() {
|
718 |
try {
|
| - |
|
719 |
for (Object[] objects : result) {
|
| - |
|
720 |
if (objects[2] != null && objects[2].toString().trim().length() > 0)
|
| - |
|
721 |
tableVF.getRow(((Number) objects[0]).intValue()).createEmptyUpdateRow().put("ID_AFFAIRE", ((Number) objects[2]).intValue()).commit();
|
| - |
|
722 |
}
|
| - |
|
723 |
} catch (SQLException e1) {
|
| - |
|
724 |
// TODO Auto-generated catch block
|
| - |
|
725 |
e1.printStackTrace();
|
| - |
|
726 |
}
|
| - |
|
727 |
}
|
| - |
|
728 |
}
|
| - |
|
729 |
}, MainFrame.CREATE_MENU);
|
| - |
|
730 |
|
| - |
|
731 |
ctxt.addMenuItem(new AbstractAction("Recalcul Total achat facture prorata") {
|
| - |
|
732 |
@Override
|
| - |
|
733 |
public void actionPerformed(ActionEvent e) {
|
| 725 |
|
734 |
|
| - |
|
735 |
{
|
| - |
|
736 |
final SQLTable table = ctxt.getElement("SAISIE_VENTE_FACTURE").getTable();
|
| - |
|
737 |
SQLRowValues rowValsFact = new SQLRowValues(table);
|
| - |
|
738 |
rowValsFact.putNulls("SOLDE", "PARTIAL", "T_HA", "T_HT");
|
| - |
|
739 |
|
| - |
|
740 |
final SQLTable tableCmd = ctxt.getElement("COMMANDE_CLIENT").getTable();
|
| - |
|
741 |
SQLRowValues rowValsCmd = new SQLRowValues(tableCmd);
|
| - |
|
742 |
rowValsCmd.putNulls("T_HT");
|
| - |
|
743 |
|
| - |
|
744 |
final SQLTable tableCmdElt = ctxt.getElement("COMMANDE_CLIENT_ELEMENT").getTable();
|
| - |
|
745 |
SQLRowValues rowValsCmdElt = new SQLRowValues(tableCmdElt);
|
| - |
|
746 |
rowValsCmdElt.put("ID_COMMANDE_CLIENT", rowValsCmd);
|
| - |
|
747 |
rowValsCmdElt.putNulls("T_PA_HT", "NIVEAU");
|
| - |
|
748 |
|
| - |
|
749 |
final SQLTable tableTR = table.getTable("TR_COMMANDE_CLIENT");
|
| - |
|
750 |
SQLRowValues rowValsTR = new SQLRowValues(tableTR);
|
| - |
|
751 |
rowValsTR.put("ID_SAISIE_VENTE_FACTURE", rowValsFact);
|
| - |
|
752 |
rowValsTR.put("ID_COMMANDE_CLIENT", rowValsCmd);
|
| - |
|
753 |
|
| - |
|
754 |
SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(rowValsFact);
|
| - |
|
755 |
fetcher.appendSelTransf(new ITransformer<SQLSelect, SQLSelect>() {
|
| - |
|
756 |
@Override
|
| - |
|
757 |
public SQLSelect transformChecked(SQLSelect input) {
|
| - |
|
758 |
Where w = new Where(table.getField("SOLDE"), "=", Boolean.TRUE);
|
| - |
|
759 |
w = w.or(new Where(table.getField("PARTIAL"), "=", Boolean.TRUE));
|
| - |
|
760 |
input.setWhere(w);
|
| - |
|
761 |
return input;
|
| - |
|
762 |
}
|
| - |
|
763 |
});
|
| - |
|
764 |
|
| - |
|
765 |
List<SQLRowValues> rowVals = fetcher.fetch();
|
| - |
|
766 |
|
| - |
|
767 |
for (SQLRowValues sqlRowValues : rowVals) {
|
| - |
|
768 |
// Recuperation de la commande
|
| - |
|
769 |
final Collection<SQLRowValues> referentRows = sqlRowValues.getReferentRows(tableTR);
|
| - |
|
770 |
if (!referentRows.isEmpty()) {
|
| - |
|
771 |
SQLRowAccessor rowTR = referentRows.iterator().next();
|
| - |
|
772 |
SQLRowAccessor rowCmd = rowTR.getForeign("ID_COMMANDE_CLIENT");
|
| - |
|
773 |
final long htCmd = rowCmd.getLong("T_HT");
|
| - |
|
774 |
if (htCmd != 0) {
|
| - |
|
775 |
|
| - |
|
776 |
BigDecimal totalHA = BigDecimal.ZERO;
|
| - |
|
777 |
Collection<? extends SQLRowAccessor> elt = rowCmd.getReferentRows(tableCmdElt);
|
| - |
|
778 |
for (SQLRowAccessor sqlRowAccessor : elt) {
|
| - |
|
779 |
if (sqlRowAccessor.getInt("NIVEAU") == 1) {
|
| - |
|
780 |
totalHA = totalHA.add(sqlRowAccessor.getBigDecimal("T_PA_HT"));
|
| - |
|
781 |
}
|
| - |
|
782 |
}
|
| - |
|
783 |
BigDecimal prorata = new BigDecimal((double) sqlRowValues.getLong("T_HT") / (double) htCmd);
|
| - |
|
784 |
try {
|
| - |
|
785 |
sqlRowValues.createEmptyUpdateRow().put("T_HA", totalHA.multiply(prorata).movePointRight(2).setScale(0, RoundingMode.HALF_UP).longValue()).update();
|
| - |
|
786 |
} catch (SQLException e1) {
|
| - |
|
787 |
e1.printStackTrace();
|
| - |
|
788 |
}
|
| - |
|
789 |
}
|
| - |
|
790 |
}
|
| - |
|
791 |
}
|
| - |
|
792 |
}
|
| - |
|
793 |
}
|
| - |
|
794 |
}, MainFrame.CREATE_MENU);
|
| - |
|
795 |
}
|
| 726 |
|
796 |
|
| - |
|
797 |
@Override
|
| - |
|
798 |
protected void start() {
|
| 727 |
|
799 |
|
| 728 |
final JComponent quoteComponent = createQuotePanel();
|
800 |
final JComponent quoteComponent = createQuotePanel();
|
| 729 |
final JComponent orderComponent = createOrderPanel();
|
801 |
final JComponent orderComponent = createOrderPanel();
|
| 730 |
MainFrame.getInstance().getTabbedPane().addTab("Commandes en cours", orderComponent);
|
802 |
MainFrame.getInstance().getTabbedPane().addTab("Commandes en cours", orderComponent);
|
| 731 |
MainFrame.getInstance().getTabbedPane().addTab("Devis en attente", quoteComponent);
|
803 |
MainFrame.getInstance().getTabbedPane().addTab("Devis en attente", quoteComponent);
|
