WebSVN - OpenConcerto - Diff - Rev 180 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/invoice/component/SaisieVenteFactureSQLComponent.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.erp.preferences.ModeReglementDefautPrefPanel;
 import org.openconcerto.sql.Configuration;
 import org.openconcerto.sql.element.ElementSQLObject;
 import org.openconcerto.sql.element.SQLComponent;
 import org.openconcerto.sql.element.SQLElement;
+import org.openconcerto.sql.element.SQLComponent.Mode;
 import org.openconcerto.sql.model.SQLBackgroundTableCache;
 import org.openconcerto.sql.model.SQLBase;
 import org.openconcerto.sql.model.SQLInjector;
 import org.openconcerto.sql.model.SQLRow;
 import org.openconcerto.sql.model.SQLRowAccessor;
 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.users.rights.UserRightsManager;
 import org.openconcerto.sql.view.EditFrame;
 import org.openconcerto.sql.view.EditPanel.EditMode;
 import org.openconcerto.sql.view.list.RowValuesTable;
 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.component.InteractionMode;
+import org.openconcerto.ui.valuewrapper.ValidatedValueWrapper;
 import org.openconcerto.utils.ExceptionHandler;
 import org.openconcerto.utils.GestionDevise;
 import org.openconcerto.utils.cc.IFactory;
+import org.openconcerto.utils.cc.ITransformer;
+import org.openconcerto.utils.checks.ValidState;
 import org.openconcerto.utils.text.SimpleDocumentListener;
 import java.awt.GridBagConstraints;
 import java.awt.GridBagLayout;
 import java.awt.event.ActionEvent;
         this.add(new JLabel(getLabelFor("ID_CLIENT"), SwingConstants.RIGHT), c);
         c.gridx++;
         c.weightx = 1;
         c.fill = GridBagConstraints.NONE;
+        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);
         this.add(this.comboClient, c);
-        this.addRequiredSQLObject(this.comboClient, "ID_CLIENT");
         if (this.displayDpt) {
             c.gridx++;
             c.gridwidth = 1;
             final JLabel labelDpt = new JLabel(getLabelFor("ID_CLIENT_DEPARTEMENT"));
                             if (row.getFields().contains("ID_COMPTE_PCE_PRODUIT") && !row.isForeignEmpty("ID_COMPTE_PCE_PRODUIT")) {
                                 totalTTC.setDefaultCompteProduit(row.getForeign("ID_COMPTE_PCE_PRODUIT"));
+                            }
+                        }
                     if (row != null) {
+                        String alerte = row.getString("ALERTE");
+                        if (!isFilling() && alerte != null && alerte.trim().length() > 0) {
+                            JOptionPane.showMessageDialog(comboClient, alerte);
+                        }
                         if (SaisieVenteFactureSQLComponent.this.contact != null) {
                             Where w = new Where(SaisieVenteFactureSQLComponent.this.eltContact.getTable().getField("ID_CLIENT"), "=", SQLRow.NONEXISTANT_ID);
                                 w = w.or(new Where(SaisieVenteFactureSQLComponent.this.eltContact.getTable().getField("ID_CLIENT"), "=", id));
                             SaisieVenteFactureSQLComponent.this.contact.getRequest().setWhere(w);
+                        }
                 int idMvt = -1;
                 if (!this.checkPrevisionnelle.isSelected()) {
                     if (getMode() == Mode.MODIFICATION) {
+                        if (!rowFacture.isForeignEmpty("ID_MOUVEMENT")) {
-                        idMvt = rowFacture.getInt("ID_MOUVEMENT");
+                            idMvt = rowFacture.getInt("ID_MOUVEMENT");
-                        // on supprime tout ce qui est lié à la facture
+                            // on supprime tout ce qui est lié à la facture
-                        System.err.println("Archivage des fils");
+                            System.err.println("Archivage des fils");
-                        EcritureSQLElement eltEcr = (EcritureSQLElement) Configuration.getInstance().getDirectory().getElement("ECRITURE");
+                            EcritureSQLElement eltEcr = (EcritureSQLElement) Configuration.getInstance().getDirectory().getElement("ECRITURE");
-                        eltEcr.archiveMouvementProfondeur(idMvt, false);
+                            eltEcr.archiveMouvementProfondeur(idMvt, false);
+                        }
+                    }
                     System.err.println("Regeneration des ecritures");
                     if (idMvt > 1) {
                         new GenerationMvtSaisieVenteFacture(idSaisieVF, idMvt);
                     } else {
         // generation du document
         final VenteFactureXmlSheet sheet = new VenteFactureXmlSheet(row);
         try {
             sheet.createDocumentAsynchronous();
-            sheet.showPrintAndExportAsynchronous(panelOO.isVisualisationSelected(), panelOO.isImpressionSelected(), true);
+            sheet.showPrintAndExportAsynchronous(panelOO.isVisualisationSelected(), panelOO.isImpressionSelected(), true, getElement(), row);
         } catch (Exception e) {
             ExceptionHandler.handle("Impossible de générer la facture", e);
+        }
+    }
             for (SQLRow rowElt : myListItem) {
                 SQLRowValues rowVals = rowElt.createUpdateRow();
                 rowVals.clearPrimaryKeys();
-                this.tableFacture.getModel().addRow(rowVals);
+                this.tableFacture.getModel().addRow(rowVals, false);
                 int rowIndex = this.tableFacture.getModel().getRowCount() - 1;
                 this.tableFacture.getModel().fireTableModelModified(rowIndex);
+            }
         } else {
             this.tableFacture.getModel().clearRows();
                     rowValsCCIP.put("ID_SAISIE_VENTE_FACTURE_ELEMENT", rowVals);
                     rowValsCCIP.put("NOM", "Acompte");
                     rowValsCCIP.put("POURCENT", pourcentCurrentAcompte);
+                }
                 System.err.println(value);
-                this.tableFacture.getModel().addRow(rowVals);
+                this.tableFacture.getModel().addRow(rowVals, false);
                 int rowIndex = this.tableFacture.getModel().getRowCount() - 1;
                 this.tableFacture.getModel().fireTableModelModified(rowIndex);
+            }
             if (toAdd > 0) {
                 for (int i = 0; i < this.tableFacture.getModel().getRowCount() && toAdd > 0; i++) {
         loadItem(this.tableFacture, bon, rowBL.getID(), bonElt, clear);
+    }
     public void addRowItem(SQLRowValues row) {
-        this.tableFacture.getModel().addRow(row);
+        this.tableFacture.getModel().addRow(row, false);
+    }
     private static final SQLElement eltModeReglement = Configuration.getInstance().getDirectory().getElement("MODE_REGLEMENT");
     @Override
+    public synchronized ValidState getValidState() {
+        final SQLRow clientSel = comboClient.getSelectedRow();
+        if (clientSel != null) {
+            if (getTable().getForeignTable("ID_CLIENT").contains("VERROU_COMPTA")) {
+                if (clientSel.getBoolean("VERROU_COMPTA")) {
+                    return new ValidState(false, "Le client n'a pas été vérifié par la comptabilité!");
+                }
+            }
+        }
+        return super.getValidState();
+    }
+    @Override
     protected SQLRowValues createDefaults() {
         SQLRowValues vals = new SQLRowValues(this.getTable());
         SQLRow r;
         try {
      */
     private void updateStock(int id) throws SQLException {
         SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());
         if (prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_FACT, true)) {
             SQLRow row = getTable().getRow(id);
             // Check if tr from bl or cmd pour DS
             if (getTable().getForeignTable("ID_CLIENT").contains("NOTE_2018")) {
                 List<SQLRow> trCmd = row.getReferentRows(getTable().getTable("TR_COMMANDE_CLIENT"));
                 if (!trCmd.isEmpty()) {
                     return;
+                }
+                List<SQLRow> trBls = row.getReferentRows(getTable().getTable("TR_BON_DE_LIVRAISON"));
+                if (!trBls.isEmpty()) {
+                    return;
+                }
+            }
             StockItemsUpdater stockUpdater = new StockItemsUpdater(new StockLabel() {
                 @Override

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/invoice/component/SaisieVenteFactureSQLComponent.java - Rev 180 → 182