WebSVN - OpenConcerto - Diff - Rev 180 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/order/element/CommandeClientSQLElement.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.core.sales.account.VenteFactureSituationSQLComponent;
 import org.openconcerto.erp.core.sales.account.VenteFactureSoldeSQLComponent;
 import org.openconcerto.erp.core.sales.order.component.CommandeClientSQLComponent;
 import org.openconcerto.erp.core.sales.order.report.CommandeClientXmlSheet;
 import org.openconcerto.erp.core.sales.order.ui.EtatCommandeClient;
+import org.openconcerto.erp.core.sales.order.ui.ReliquatCommandeTableModel;
 import org.openconcerto.erp.core.sales.product.element.UniteVenteArticleSQLElement;
 import org.openconcerto.erp.core.sales.product.model.ProductComponent;
 import org.openconcerto.erp.core.sales.product.model.ProductHelper;
 import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;
 import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;
 import org.openconcerto.sql.model.SQLRowValues;
 import org.openconcerto.sql.model.SQLRowValuesListFetcher;
 import org.openconcerto.sql.model.SQLSelect;
 import org.openconcerto.sql.model.SQLSelectJoin;
 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.UpdateBuilder;
 import org.openconcerto.sql.utils.SQLUtils;
 import org.openconcerto.sql.view.EditFrame;
 import org.openconcerto.sql.view.EditPanel;
+import org.openconcerto.sql.view.EditPanel.EditMode;
+import org.openconcerto.sql.view.EditPanelListener;
 import org.openconcerto.sql.view.list.IListe;
 import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
 import org.openconcerto.sql.view.list.RowAction;
 import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
 import org.openconcerto.sql.view.list.SQLTableModelColumn;
 import org.openconcerto.sql.view.list.SQLTableModelSource;
+import org.openconcerto.ui.PanelFrame;
+import org.openconcerto.utils.CollectionUtils;
 import org.openconcerto.utils.CompareUtils;
 import org.openconcerto.utils.DecimalUtils;
 import org.openconcerto.utils.ExceptionHandler;
 import org.openconcerto.utils.ListMap;
 import org.openconcerto.utils.NumberUtils;
 import org.openconcerto.utils.cc.ITransformer;
 import java.awt.Component;
+import java.awt.GridBagConstraints;
+import java.awt.GridBagLayout;
 import java.awt.event.ActionEvent;
 import java.io.IOException;
 import java.math.BigDecimal;
 import java.math.RoundingMode;
 import java.sql.SQLException;
 import java.util.Map;
 import java.util.Set;
 import javax.swing.AbstractAction;
 import javax.swing.JLabel;
+import javax.swing.JOptionPane;
+import javax.swing.JPanel;
+import javax.swing.JScrollPane;
 import javax.swing.JTable;
 import javax.swing.SwingUtilities;
 import javax.swing.table.DefaultTableCellRenderer;
 import org.apache.commons.dbutils.ResultSetHandler;
             PredicateRowAction actionTransfertBL = new PredicateRowAction(new AbstractAction("Transfert automatique vers BL") {
                 @Override
                 public void actionPerformed(ActionEvent e) {
                     TransfertCommandeAutoUtils transfert = new TransfertCommandeAutoUtils(getTable());
+                    List<SQLRowValues> selectedRows = IListe.get(e).getSelectedRows();
+                    Set<String> clientBloque = checkClient(selectedRows);
+                    if (clientBloque.isEmpty()) {
-                    transfert.transfertMultiBL(IListe.get(e).getSelectedRows());
+                        transfert.transfertMultiBL(IListe.get(e).getSelectedRows());
+                    } else if (clientBloque.size() == 1) {
+                        JOptionPane.showMessageDialog(null, "Impossible de faire le transfert car le client " + clientBloque.iterator().next() + " est bloqué!");
+                    } else {
+                        JOptionPane.showMessageDialog(null, "Impossible de faire le transfert car les clients " + CollectionUtils.join(clientBloque, ",") + " sont bloqués!");
+                    }
+                }
             }, false);
             actionTransfertBL.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
             getRowActions().add(actionTransfertBL);
             PredicateRowAction actionFacture = new PredicateRowAction(new AbstractAction("Transfert automatique en facture") {
                 @Override
                 public void actionPerformed(ActionEvent e) {
                     TransfertCommandeAutoUtils transfert = new TransfertCommandeAutoUtils(getTable());
+                    List<SQLRowValues> selectedRows = IListe.get(e).getSelectedRows();
+                    Set<String> clientBloque = checkClient(selectedRows);
+                    if (clientBloque.isEmpty()) {
-                    transfert.transfertFacture(IListe.get(e).getSelectedRows());
+                        transfert.transfertFacture(IListe.get(e).getSelectedRows());
+                    } else if (clientBloque.size() == 1) {
+                        JOptionPane.showMessageDialog(null, "Impossible de faire le transfert car le client " + clientBloque.iterator().next() + " est bloqué!");
+                    } else {
+                        JOptionPane.showMessageDialog(null, "Impossible de faire le transfert car les clients " + CollectionUtils.join(clientBloque, ",") + " sont bloqués!");
+                    }
+                }
             }, false);
             actionFacture.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
             getRowActions().add(actionFacture);
+        }
+        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ACOMPTE_DEVIS, false)) {
+            PredicateRowAction actionClient = new PredicateRowAction(new AbstractAction("Saisir un acompte") {
+                EditFrame edit;
+                public void actionPerformed(ActionEvent e) {
+                    final SQLElement eltEncaisser = Configuration.getInstance().getDirectory()
+                            .getElement(((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("ENCAISSER_MONTANT"));
+                    if (this.edit == null) {
+                        this.edit = new EditFrame(eltEncaisser, EditMode.CREATION);
+                    }
+                    final SQLRowAccessor selRow = IListe.get(e).getSelectedRow();
+                    SQLRowValues rowVals = new SQLRowValues(eltEncaisser.getTable());
+                    rowVals.put("ACOMPTE", true);
+                    rowVals.put("NOM", "Acompte commande " + selRow.getString("NUMERO"));
+                    rowVals.put("ID_CLIENT", selRow.getForeignID("ID_CLIENT"));
+                    rowVals.put("ID_COMMANDE_CLIENT", selRow.getID());
+                    SQLRowValues rowValsElt = new SQLRowValues(eltEncaisser.getTable().getTable("ENCAISSER_MONTANT_ELEMENT"));
+                    rowValsElt.put("MONTANT_A_REGLER", selRow.getLong("T_TTC"));
+                    rowValsElt.put("DATE", selRow.getObject("DATE"));
+                    rowValsElt.put("ID_ENCAISSER_MONTANT", rowVals);
+                    this.edit.getSQLComponent().select(rowVals);
+                    this.edit.setVisible(true);
+                    this.edit.addEditPanelListener(new EditPanelListener() {
+                        @Override
+                        public void modified() {
+                        }
+                        @Override
+                        public void inserted(int id) {
+                            // Put id devis and refresh devis.t_acompte
+                            SQLRow rowE = eltEncaisser.getTable().getRow(id);
+                            String up = "UPDATE " + selRow.getTable().getSQLName().quote() + " set \"T_ACOMPTE\"=(SELECT COALESCE(SUM(\"MONTANT\"),0) from " + rowE.getTable().getSQLName().quote()
+                                    + " where \"ARCHIVE\"=0 and \"ID_COMMANDE_CLIENT\"=" + selRow.getID() + ") where \"ID\"=" + selRow.getID();
+                            eltEncaisser.getTable().getDBSystemRoot().getDataSource().execute(up);
+                        }
+                        @Override
+                        public void deleted() {
+                        }
+                        @Override
+                        public void cancelled() {
+                        }
+                    });
+                }
+            }, false);
+            actionClient.setPredicate(IListeEvent.getSingleSelectionPredicate());
+            getRowActions().add(actionClient);
+        }
         final List<RowAction> allowedActions = new ArrayList<RowAction>();
         // Transfert vers facture
         PredicateRowAction bonAction = new PredicateRowAction(new AbstractAction() {
             public void actionPerformed(ActionEvent e) {
                 transfertBonLivraisonClient(IListe.get(e).getSelectedRows());
         cmdAction.setPredicate(IListeEvent.getSingleSelectionPredicate());
         bonAction.setPredicate(IListeEvent.getSingleSelectionPredicate());
+        // Reliquat
+        PredicateRowAction reliquatAction = new PredicateRowAction(new AbstractAction() {
+            public void actionPerformed(ActionEvent e) {
+                JPanel panelReliquat = new JPanel(new GridBagLayout());
+                GridBagConstraints c = new GridBagConstraints();
+                final ReliquatCommandeTableModel dm = new ReliquatCommandeTableModel(IListe.get(e).getSelectedRowAccessor());
+                if (dm.getRowCount() > 0) {
+                    JTable table = new JTable(dm);
+                    JScrollPane comp = new JScrollPane(table);
+                    c.weightx = 1;
+                    c.weighty = 1;
+                    c.fill = GridBagConstraints.BOTH;
+                    panelReliquat.add(comp, c);
+                    PanelFrame frame = new PanelFrame(panelReliquat, "Reliquat commande");
+                    frame.pack();
+                    frame.setVisible(true);
+                } else {
+                    JOptionPane.showMessageDialog(null, "Aucun reliquat restant");
+                }
+            }
+        }, false, "sales.order.reliquat.show");
+        reliquatAction.setPredicate(IListeEvent.getSingleSelectionPredicate());
-        MouseSheetXmlListeListener mouseSheetXmlListeListener = new MouseSheetXmlListeListener(CommandeClientXmlSheet.class);
+        MouseSheetXmlListeListener mouseSheetXmlListeListener = new MouseSheetXmlListeListener(this, CommandeClientXmlSheet.class);
         mouseSheetXmlListeListener.setGenerateHeader(true);
         mouseSheetXmlListeListener.setShowHeader(true);
         // Dupliquer
         RowAction cloneAction = getCloneAction();
         allowedActions.add(bonAction);
         allowedActions.add(factureAction);
         allowedActions.add(acompteAction);
         allowedActions.add(soldeAction);
         allowedActions.add(cmdAction);
+        allowedActions.add(reliquatAction);
         allowedActions.addAll(mouseSheetXmlListeListener.getRowActions());
         getRowActions().addAll(allowedActions);
+    }
     private boolean chiffrageEditableInUI = true;
         builder.setObject("ETAT_COMMANDE", etat.getId());
         builder.setWhere(new Where(getTable().getKey(), ids));
         getTable().getDBSystemRoot().getDataSource().execute(builder.asString());
         getTable().fireTableModified(-1);
+        if (etat == EtatCommandeClient.ANNULEE) {
+            // 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"), ids);
+            Where w2 = new Where(eltMvtStock.getTable().getField("SOURCE"), "=", getTable().getName());
+            sel.setWhere(w.and(w2));
+            try {
+                @SuppressWarnings("rawtypes")
+                List res = (List) eltMvtStock.getTable().getBase().getDataSource().execute(sel.asString(), new ArrayListHandler());
+                if (res != null) {
+                    for (int i = 0; i < res.size(); i++) {
+                        Object[] tmp = (Object[]) res.get(i);
+                        eltMvtStock.archive(((Number) tmp[0]).intValue());
+                    }
+                }
+            } catch (SQLException e) {
+                ExceptionHandler.handle("Erreur lors de la suppression des mouvements de stocks", e);
+            }
+        }
+    }
     /*
      * (non-Javadoc)
+     *
+        }
         l.add("ID_CLIENT");
         l.add("ID_COMMERCIAL");
         l.add("T_HT");
         l.add("T_TTC");
+        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());
+        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ACOMPTE_DEVIS, false)) {
+            l.add("T_ACOMPTE");
+        }
         if (getTable().getFieldsName().contains("ACOMPTE_COMMANDE")) {
             l.add("ACOMPTE_COMMANDE");
+        }
         l.add("NOM");
         l.add("INFOS");
-        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());
         if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ORDER_PACKAGING_MANAGEMENT, true)) {
             l.add("NUMERO_EXPEDITION");
             l.add("ETAT_COMMANDE");
+        }
         return l;
     @Override
     public Set<String> getReadOnlyFields() {
         final Set<String> s = new HashSet<String>();
         s.add("ID_DEVIS");
+        if (getTable().contains("T_ACOMPTE")) {
+            s.add("T_ACOMPTE");
+        }
         return s;
+    }
     @Override
     protected void archive(TreesOfSQLRows trees, boolean cutLinks) throws SQLException {
                         rowValsElt.put("T_POIDS", rowValsElt.getLong("POIDS") * rowValsElt.getInt("QTE"));
                         rowValsElt.put("T_PA_HT", ((BigDecimal) rowValsElt.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE")), DecimalUtils.HIGH_PRECISION));
                         rowValsElt.put("T_PA_TTC", ((BigDecimal) rowValsElt.getObject("T_PA_HT")).multiply(new BigDecimal((rowValsElt.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0)),
                                 DecimalUtils.HIGH_PRECISION));
+                        final SQLRow asRow = rowArticleFind.getForeign("ID_FOURNISSEUR").asRow();
+                        final SQLRowAccessor rowDeviseF = asRow.getNonEmptyForeign("ID_DEVISE");
-                        // rowValsElt.put("ID_DEVISE",
+                        if (rowDeviseF != null) {
-                        // rowCmd.getForeignRow("ID_TARIF").getForeignID("ID_DEVISE"));
+                            rowValsElt.put("ID_DEVISE", rowDeviseF.getID());
+                        }
                         map.add(rowArticleFind.getForeign("ID_FOURNISSEUR").asRow(), rowValsElt);
+                    }
+                }
                 MouvementStockSQLElement.createCommandeF(map, null, "");
                 System.err.println(input.asString());
                 return input;
+            }
         });
         comp.loadQuantity(fetcher.fetch(), "COMMANDE_CLIENT_ELEMENT");
+        comp.removeZeroQtyLines();
+    }
     /**
      * Transfert en Facture
+     *
+    }
     @Override
     protected String createCode() {
         return "sales.order";
+        // r32617 | ludo | 2021-12-20 11:42:44 CET
+        //
+        // blocage des intéractions
+        // ----------------------------------------------------------------------------
+    }
+    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));
+        }
+    }
+    private Set<String> checkClient(List<? extends SQLRowAccessor> rows) {
+        Set<String> clientBloque = new HashSet<>();
+        for (SQLRowAccessor sqlRowAccessor : rows) {
+            SQLRowAccessor client = sqlRowAccessor.getForeign("ID_CLIENT").fetchNewRow();
+            if (client.getBoolean("BLOQUE_LIVRAISON") || client.getBoolean("BLOQUE")) {
+                clientBloque.add(client.getString("CODE") + " " + client.getString("NOM"));
+            }
+        }
+        return clientBloque;
+    }
+}

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/element/CommandeClientSQLElement.java @ 180 - Rev 180 → 182