WebSVN - OpenConcerto - Diff - Rev 174 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/shipment/element/BonDeLivraisonSQLElement.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.
  package org.openconcerto.erp.core.sales.shipment.element;
 import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
 import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;
 import org.openconcerto.erp.preferences.DefaultNXProps;
-import org.openconcerto.erp.preferences.GestionArticleGlobalPreferencePanel;
 import org.openconcerto.sql.Configuration;
 import org.openconcerto.sql.element.SQLComponent;
 import org.openconcerto.sql.element.SQLElement;
 import org.openconcerto.sql.element.SQLElementLink.LinkType;
 import org.openconcerto.sql.element.SQLElementLinksSetup;
 import org.openconcerto.sql.model.SQLName;
 import org.openconcerto.sql.model.SQLRow;
 import org.openconcerto.sql.model.SQLRowAccessor;
 import org.openconcerto.sql.model.SQLSelect;
 import org.openconcerto.sql.model.SQLTable;
+import org.openconcerto.sql.model.SQLTableEvent;
+import org.openconcerto.sql.model.SQLTableEvent.Mode;
+import org.openconcerto.sql.model.SQLTableModifiedListener;
 import org.openconcerto.sql.model.Where;
-import org.openconcerto.sql.preferences.SQLPreferences;
+import org.openconcerto.sql.request.ListSQLRequest;
 import org.openconcerto.sql.request.UpdateBuilder;
 import org.openconcerto.sql.view.EditFrame;
 import org.openconcerto.sql.view.EditPanel;
 import org.openconcerto.sql.view.list.IListe;
 import org.openconcerto.sql.view.list.RowAction;
+import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
+import org.openconcerto.sql.view.list.action.ListEvent;
 import org.openconcerto.ui.preferences.DefaultProps;
 import org.openconcerto.utils.ListMap;
 import java.awt.event.ActionEvent;
 import java.sql.SQLException;
 import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.List;
 import javax.swing.AbstractAction;
 import org.apache.commons.dbutils.handlers.ArrayListHandler;
     // TODO afficher uniquement les factures non livrees dans la combo
     // MAYBE mettre un niceCellRenderer dans les rowValuesTable
     public BonDeLivraisonSQLElement(String single, String plural) {
         super("BON_DE_LIVRAISON", single, plural);
+        // Verrou facture
+        if (getTable().contains("VERROU_FACTURATION")) {
+            PredicateRowAction lock = new PredicateRowAction(new AbstractAction("Verrouiller") {
+                @Override
+                public void actionPerformed(ActionEvent e) {
+                    updateVerrouFacture(IListe.get(e).getSelectedRowAccessors(), true);
+                }
+            }, false);
+            lock.setPredicate(ListEvent.getNonEmptySelectionPredicate());
+            lock.setPath(Arrays.asList("Verrou facturaction", "Verrou facturaction", "Verrou facturaction"));
+            PredicateRowAction unlock = new PredicateRowAction(new AbstractAction("Déverrouiller") {
+                @Override
+                public void actionPerformed(ActionEvent e) {
+                    updateVerrouFacture(IListe.get(e).getSelectedRowAccessors(), false);
+                }
+            }, false);
+            unlock.setPath(Arrays.asList("Verrou facturaction", "Verrou facturaction", "Verrou facturaction"));
+            unlock.setPredicate(ListEvent.getNonEmptySelectionPredicate());
+            getRowActions().add(lock);
+            getRowActions().add(unlock);
+        }
+    }
+    @Override
+    protected void _initListRequest(ListSQLRequest req) {
+        super._initListRequest(req);
+        req.addToGraphToFetch("VERROU_FACTURATION");
+    }
+    private void updateVerrouFacture(List<SQLRowAccessor> rows, boolean state) {
+        UpdateBuilder builder = new UpdateBuilder(getTable());
+        builder.setObject("VERROU_FACTURATION", state);
+        builder.setWhere(Where.inValues(getTable().getKey(), SQLRow.getIDs(rows)));
+        getTable().getDBSystemRoot().getDataSource().execute(builder.asString());
+        getTable().fireTableModified();
+    }
     public BonDeLivraisonSQLElement() {
         this("un bon de livraison", "bons de livraison");
+    }
         List<Object> cmds = new ArrayList<>();
         List<Object> devis = new ArrayList<>();
         List<Integer> ids = new ArrayList<>();
         for (SQLRow row : trees.getRows()) {
-            SQLPreferences prefs = new SQLPreferences(getTable().getDBRoot());
             cmds.addAll(getSourceTrRowsFrom(row.getID(), "COMMANDE_CLIENT_ELEMENT", "COMMANDE_CLIENT"));
             devis.addAll(getSourceTrRowsFrom(row.getID(), "DEVIS_ELEMENT", "DEVIS"));
             ids.add(row.getID());
-            if (!prefs.getBoolean(GestionArticleGlobalPreferencePanel.STOCK_FACT, true)) {
-                // Mise à jour des stocks
+            // Mise à jour des stocks
-                SQLElement eltMvtStock = Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK");
+            SQLElement eltMvtStock = Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK");
-                SQLSelect sel = new SQLSelect();
+            SQLSelect sel = new SQLSelect();
-                sel.addSelect(eltMvtStock.getTable().getField("ID"));
+            sel.addSelect(eltMvtStock.getTable().getField("ID"));
-                    for (int i = 0; i < l.size(); i++) {
+                for (int i = 0; i < l.size(); i++) {
-                        Object[] tmp = (Object[]) l.get(i);
+                    Object[] tmp = (Object[]) l.get(i);
-                        eltMvtStock.archive(((Number) tmp[0]).intValue());
+                    eltMvtStock.archive(((Number) tmp[0]).intValue());
+                }
+            }
-            }
+        }
         super.archive(trees, cutLinks);
         updateQteLivree(devis, "DEVIS_ELEMENT", "DEVIS");
         updateQteLivree(cmds, "COMMANDE_CLIENT_ELEMENT", "COMMANDE_CLIENT");
                 return (selection != null && selection.size() == 1);
+            }
         };
+    }
+    private final List<SQLTableModifiedListener> listenerCmdInserted = new ArrayList<>();
+    public void addInsertedCmdListener(SQLTableModifiedListener l) {
+        this.listenerCmdInserted.add(l);
+    }
+    public void removeInsertedCmdListener(SQLTableModifiedListener l) {
+        this.listenerCmdInserted.remove(l);
+    }
+    public void fireInsertedCmdListener(SQLRow row) {
+        for (SQLTableModifiedListener sqlTableModifiedListener : this.listenerCmdInserted) {
+            sqlTableModifiedListener.tableModified(new SQLTableEvent(row, Mode.ROW_ADDED, null));
+        }
+    }
     @Override
     protected String createCodeSuffix() {
         return ".delivery.note";
+    }

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/shipment/element/BonDeLivraisonSQLElement.java - Rev 174 → 182