WebSVN - OpenConcerto - Diff - Rev 180 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/order/component/CommandeClientSQLComponent.java

 /*
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
+ *
- * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
+ * Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.
+ *
  * The contents of this file are subject to the terms of the GNU General Public License Version 3
  * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
  * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
  * language governing permissions and limitations under the License.
 import org.openconcerto.sql.model.SQLBackgroundTableCache;
 import org.openconcerto.sql.model.SQLInjector;
 import org.openconcerto.sql.model.SQLRow;
 import org.openconcerto.sql.model.SQLRowAccessor;
 import org.openconcerto.sql.model.SQLRowValues;
+import org.openconcerto.sql.model.SQLSelect;
 import org.openconcerto.sql.model.SQLTable;
 import org.openconcerto.sql.model.Where;
 import org.openconcerto.sql.preferences.SQLPreferences;
 import org.openconcerto.sql.sqlobject.ElementComboBox;
 import org.openconcerto.sql.sqlobject.JUniqueTextField;
 import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
 import org.openconcerto.sql.sqlobject.SQLTextCombo;
+import org.openconcerto.sql.sqlobject.itemview.SimpleRowItemView;
 import org.openconcerto.sql.users.UserManager;
 import org.openconcerto.sql.view.EditFrame;
 import org.openconcerto.sql.view.list.RowValuesTable;
 import org.openconcerto.ui.DefaultGridBagConstraints;
 import org.openconcerto.ui.FormLayouter;
 import org.openconcerto.ui.JDate;
 import org.openconcerto.ui.TitledSeparator;
 import org.openconcerto.ui.component.ITextArea;
+import org.openconcerto.ui.valuewrapper.ValidatedValueWrapper;
 import org.openconcerto.utils.ExceptionHandler;
+import org.openconcerto.utils.cc.ITransformer;
+import org.openconcerto.utils.checks.ValidState;
 import java.awt.Color;
 import java.awt.GridBagConstraints;
 import java.awt.GridBagLayout;
 import java.beans.PropertyChangeEvent;
 import java.beans.PropertyChangeListener;
+import java.math.BigDecimal;
 import java.sql.SQLException;
 import java.util.Date;
 import java.util.HashSet;
 import java.util.List;
 import java.util.Set;
 import javax.swing.event.DocumentEvent;
 import javax.swing.event.DocumentListener;
 import javax.swing.event.TableModelEvent;
 import javax.swing.event.TableModelListener;
+import org.apache.commons.dbutils.handlers.ArrayListHandler;
 public class CommandeClientSQLComponent extends TransfertBaseSQLComponent {
     private CommandeClientItemTable table;
     private FacturationCommandeTable tableFacturationItem;
     private ChiffrageCommandeTable tableChiffrageItem;
         c.gridy++;
         c.weightx = 0;
         c.fill = GridBagConstraints.HORIZONTAL;
         this.add(new JLabel(getLabelFor("ID_CLIENT"), SwingConstants.RIGHT), c);
+        final ValidatedValueWrapper<Integer> clientValidatedValueWrapper = ValidatedValueWrapper.add(new ElementComboBox(), new ITransformer<Integer, ValidState>() {
+            @Override
+            public ValidState transformChecked(Integer t) {
+                ElementComboBox boxClient = (ElementComboBox) getView("ID_CLIENT").getComp();
+                if (getMode() == Mode.INSERTION && boxClient != null && !boxClient.isEmpty() && boxClient.getSelectedRow().getBoolean("BLOQUE")) {
+                    return ValidState.create(false, "Les intéractions avec ce client sont verrouillées.");
+                } else {
+                    return ValidState.getTrueInstance();
+                }
+            }
+        });
-        this.comboClient = new ElementComboBox();
+        this.comboClient = (ElementComboBox) clientValidatedValueWrapper.getComp();
+        addView(new SimpleRowItemView<Integer>(clientValidatedValueWrapper), "ID_CLIENT", REQ);
         c.gridx++;
         c.gridwidth = 1;
         c.weightx = 1;
         c.weighty = 0;
         c.fill = GridBagConstraints.NONE;
                     Integer id = comboClient.getValue();
                     if (id > 1) {
                         SQLRow row = comboClient.getElement().getTable().getRow(id);
+                        String alerte = row.getString("ALERTE");
+                        if (alerte != null && alerte.trim().length() > 0) {
+                            JOptionPane.showMessageDialog(comboClient, alerte);
+                        }
                         if (comboClient.getElement().getTable().getFieldsName().contains("ID_TARIF")) {
                             SQLRowAccessor foreignRow = row.getForeignRow("ID_TARIF");
                             if (!foreignRow.isUndefined() && (boxTarif.getSelectedRow() == null || boxTarif.getSelectedId() != foreignRow.getID())
                                     && JOptionPane.showConfirmDialog(null, TM.tr("apply.associated.pricelist.to.customer")) == JOptionPane.YES_OPTION) {
+                    }
+                }
+            }
         });
-        addRequiredSQLObject(this.comboClient, "ID_CLIENT");
         if (this.displayDpt) {
             c.gridx++;
             c.gridwidth = 1;
             final JLabel labelDpt = new JLabel(getLabelFor("ID_CLIENT_DEPARTEMENT"));
         cFrais.gridy++;
         cFrais.gridx = 0;
         panel.add(labelRemiseHT, cFrais);
         cFrais.gridx++;
         panel.add(textRemiseHT, cFrais);
+        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ACOMPTE_DEVIS, false) && getTable().contains("T_ACOMPTE")) {
+            // Acompte
+            cFrais.gridy++;
+            cFrais.gridx = 0;
+            cFrais.weightx = 0;
+            cFrais.weighty = 0;
+            cFrais.gridwidth = 1;
+            JLabel compAcompte = new JLabel(getLabelFor("T_ACOMPTE"), SwingConstants.RIGHT);
+            panel.add(compAcompte, cFrais);
+            cFrais.gridx++;
+            cFrais.gridwidth = GridBagConstraints.REMAINDER;
+            DeviseField fieldAcompte = new DeviseField();
+            fieldAcompte.setEnabled(false);
+            cFrais.weightx = 1;
+            panel.add(fieldAcompte, cFrais);
+            this.addView(fieldAcompte, "T_ACOMPTE");
+        }
         c.gridx = 2;
         c.weightx = 0;
         c.weighty = 0;
         c.gridwidth = 1;
                 textPoidsTotal.setText(String.valueOf(CommandeClientSQLComponent.this.table.getPoidsTotal()));
+            }
         });
         this.addView(this.table.getRowValuesTable(), "");
+        comboClient.addModelListener("wantedID", new PropertyChangeListener() {
+            @Override
+            public void propertyChange(PropertyChangeEvent arg0) {
+                Integer id = comboClient.getWantedID();
+                if (id > 1) {
+                    SQLRow rowClient = comboClient.getElement().getTable().getRow(id);
+                    if (rowClient.getObject("ID_CATEGORIE_COMPTABLE") != null && !rowClient.isForeignEmpty("ID_CATEGORIE_COMPTABLE")) {
+                        totalTTC.setCategorieComptable(rowClient.getForeign("ID_CATEGORIE_COMPTABLE"));
+                        table.setRowCatComptable(rowClient.getForeign("ID_CATEGORIE_COMPTABLE"));
+                    } else {
+                        totalTTC.setCategorieComptable(null);
+                        table.setRowCatComptable(null);
+                    }
+                }
+            }
+        });
         DefaultGridBagConstraints.lockMinimumSize(comboClient);
         DefaultGridBagConstraints.lockMinimumSize(comboCommercial);
         DefaultGridBagConstraints.lockMinimumSize(comboDevis);
         DefaultGridBagConstraints.lockMinimumSize(totalTTC);
         DefaultGridBagConstraints.lockMaximumSize(totalTTC);
+            }
             // Création des articles
             this.table.createArticle(idCommande, this.getElement());
             // generation du document
+            SQLRow row = this.getElement().getTable().getRow(idCommande);
             try {
                 CommandeClientXmlSheet sheet = new CommandeClientXmlSheet(getTable().getRow(idCommande));
                 sheet.createDocumentAsynchronous();
-                sheet.showPrintAndExportAsynchronous(CommandeClientSQLComponent.this.panelOO.isVisualisationSelected(), CommandeClientSQLComponent.this.panelOO.isImpressionSelected(), true);
+                sheet.showPrintAndExportAsynchronous(CommandeClientSQLComponent.this.panelOO.isVisualisationSelected(), CommandeClientSQLComponent.this.panelOO.isImpressionSelected(), true,
+                        this.getElement(), row);
             } catch (Exception e) {
                 ExceptionHandler.handle("Impossible de créer la commande", e);
+            }
             // incrémentation du numéro auto
                     public void run() {
                         JOptionPane.showMessageDialog(null, "Le numéro a été actualisé en " + num);
+                    }
                 });
+            }
+            ((CommandeClientSQLElement) getElement()).fireInsertedCmdListener(row);
+        }
         return idCommande;
+    }
         // generation du document
         try {
             CommandeClientXmlSheet sheet = new CommandeClientXmlSheet(row);
             sheet.createDocumentAsynchronous();
-            sheet.showPrintAndExportAsynchronous(CommandeClientSQLComponent.this.panelOO.isVisualisationSelected(), CommandeClientSQLComponent.this.panelOO.isImpressionSelected(), true);
+            sheet.showPrintAndExportAsynchronous(CommandeClientSQLComponent.this.panelOO.isVisualisationSelected(), CommandeClientSQLComponent.this.panelOO.isImpressionSelected(), true, getElement(),
+                    row);
         } catch (Exception e) {
             ExceptionHandler.handle("Impossible de créer la commande", e);
+        }
+    }
      * @throws SQLException
      */
     private void updateStock(int id) throws SQLException {
         SQLRow row = getTable().getRow(id);
+        if (row.getInt("ETAT_COMMANDE") != EtatCommandeClient.ANNULEE.getId()) {
-        StockItemsUpdater stockUpdater = new StockItemsUpdater(new StockLabel() {
+            StockItemsUpdater stockUpdater = new StockItemsUpdater(new StockLabel() {
-            @Override
+                @Override
-            public String getLabel(SQLRowAccessor rowOrigin, SQLRowAccessor rowElt) {
+                public String getLabel(SQLRowAccessor rowOrigin, SQLRowAccessor rowElt) {
-                return getLibelleStock(rowOrigin, rowElt);
+                    return getLibelleStock(rowOrigin, rowElt);
+                }
-        }, row, row.getReferentRows(getTable().getTable("COMMANDE_CLIENT_ELEMENT")), TypeStockUpdate.VIRTUAL_DELIVER);
+            }, row, row.getReferentRows(getTable().getTable("COMMANDE_CLIENT_ELEMENT")), TypeStockUpdate.VIRTUAL_DELIVER);
-        stockUpdater.update();
+            stockUpdater.update();
+        } else {
+            // Suppression des stocks si commande annulée
+            SQLElement eltMvtStock = getDirectory().getElement("MOUVEMENT_STOCK");
+            SQLSelect sel = new SQLSelect();
+            sel.addSelect(eltMvtStock.getTable().getField("ID"));
+            Where w = new Where(eltMvtStock.getTable().getField("IDSOURCE"), "=", row.getID());
+            Where w2 = new Where(eltMvtStock.getTable().getField("SOURCE"), "=", getTable().getName());
+            sel.setWhere(w.and(w2));
+            @SuppressWarnings("rawtypes")
+            List l = (List) eltMvtStock.getTable().getBase().getDataSource().execute(sel.asString(), new ArrayListHandler());
+            if (l != null) {
+                for (int i = 0; i < l.size(); i++) {
+                    Object[] tmp = (Object[]) l.get(i);
+                    eltMvtStock.archive(((Number) tmp[0]).intValue());
+                }
+            }
+        }
+    }
     public void setDefaults() {
         this.resetValue();
         this.numeroUniqueCommande.setText(NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), new Date()));
             for (final SQLRow rowElt : myListItem) {
                 final SQLRowValues rowVals = rowElt.createUpdateRow();
                 rowVals.clearPrimaryKeys();
+                if (rowVals.getTable().contains("ID_DEVIS_ELEMENT")) {
+                    rowVals.putEmptyLink("ID_DEVIS_ELEMENT");
+                }
+                rowVals.put("QTE_LIVREE", BigDecimal.ZERO);
+                rowVals.put("LIVRE", Boolean.FALSE);
+                rowVals.put("LIVRE_FORCED", Boolean.FALSE);
-                this.table.getModel().addRow(rowVals);
+                this.table.getModel().addRow(rowVals, false);
                 final int rowIndex = this.table.getModel().getRowCount() - 1;
                 this.table.getModel().fireTableModelModified(rowIndex);
+            }
         } else {
             this.table.getModel().clearRows();

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/order/component/CommandeClientSQLComponent.java - Rev 180 → 182