WebSVN - OpenConcerto - Diff - Rev 182 and 185 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/supplychain/order/element/CommandeSQLElement.java

 import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
 import org.openconcerto.erp.core.edm.AttachmentAction;
 import org.openconcerto.erp.core.sales.order.ui.ReliquatCommandeTableModel;
 import org.openconcerto.erp.core.supplychain.order.component.CommandeSQLComponent;
 import org.openconcerto.erp.core.supplychain.order.component.SaisieAchatSQLComponent;
+import org.openconcerto.erp.core.supplychain.order.ui.EtatCommandeFournisseur;
+import org.openconcerto.erp.core.supplychain.order.ui.EtatCommandeRenderer;
 import org.openconcerto.erp.core.supplychain.receipt.component.BonReceptionSQLComponent;
 import org.openconcerto.erp.generationDoc.gestcomm.CommandeXmlSheet;
 import org.openconcerto.erp.model.MouseSheetXmlListeListener;
 import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
 import org.openconcerto.sql.Configuration;
 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.view.EditFrame;
 import org.openconcerto.sql.view.EditPanel;
+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.ExceptionHandler;
 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.sql.SQLException;
 import java.util.ArrayList;
+import java.util.Arrays;
 import java.util.List;
 import javax.swing.AbstractAction;
 import javax.swing.ImageIcon;
 import javax.swing.JFrame;
+import javax.swing.JLabel;
 import javax.swing.JOptionPane;
 import javax.swing.JPanel;
 import javax.swing.JScrollPane;
 import javax.swing.JTable;
 import javax.swing.SwingWorker;
+import javax.swing.table.DefaultTableCellRenderer;
 import org.apache.commons.dbutils.handlers.ArrayListHandler;
 public class CommandeSQLElement extends ComptaSQLConfElement {
             PredicateRowAction actionAttachment = new PredicateRowAction(new AttachmentAction().getAction(), true);
             actionAttachment.setPredicate(IListeEvent.getSingleSelectionPredicate());
             getRowActions().add(actionAttachment);
+        }
+        for (final EtatCommandeFournisseur etat : EtatCommandeFournisseur.values()) {
+            PredicateRowAction action = new PredicateRowAction(new AbstractAction(etat.getTranslation()) {
+                @Override
+                public void actionPerformed(ActionEvent e) {
+                    changeStateOfRows(IListe.get(e).getSelectedRows(), etat);
+                }
+            }, false);
+            action.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
+            action.setPath(Arrays.asList("Etat", "Etat", "Etat"));
+            getRowActions().add(action);
+        }
         getRowActions().addAll(new MouseSheetXmlListeListener(this, CommandeXmlSheet.class).getRowActions());
         // Transfert vers BR
         PredicateRowAction bonAction = new PredicateRowAction(new AbstractAction() {
             public void actionPerformed(ActionEvent e) {
         l.add("T_TTC");
         Boolean useCommandeEnCours = SQLPreferences.getMemCached(getTable().getDBRoot()).getBoolean(GestionCommercialeGlobalPreferencePanel.COMMANDE_FOURNISSEUR_EN_COURS, false);
         if (useCommandeEnCours) {
             l.add("EN_COURS");
+        }
+        l.add("ETAT_COMMANDE");
         l.add("INFOS");
         return l;
+    }
     @Override
         l.add("NOM");
         l.add("DATE");
         return l;
+    }
+    @Override
+    protected void _initTableSource(SQLTableModelSource res) {
+        // TODO Auto-generated method stub
+        super._initTableSource(res);
+        SQLTableModelColumn col = res.getColumn(getTable().getField("ETAT_COMMANDE"));
+        if (col != null) {
+            col.setRenderer(new EtatCommandeRenderer());
+        }
+    }
     /*
      * (non-Javadoc)
+     *
      * @see org.openconcerto.devis.SQLElement#getComponent()
      */
         comp.loadCommande(commandeID);
         editFactureFrame.pack();
         editFactureFrame.setState(JFrame.NORMAL);
         editFactureFrame.setVisible(true);
+        editFactureFrame.addEditPanelListener(new EditPanelListener() {
+            @Override
+            public void modified() {
+            }
+            @Override
+            public void inserted(int id) {
+                try {
+                    SQLRowValues rowValsTR = new SQLRowValues(getTable().getTable("TR_COMMANDE"));
+                    rowValsTR.put("ID_COMMANDE", commandeID);
+                    rowValsTR.put("ID_SAISIE_ACHAT", id);
+                    rowValsTR.commit();
+                } catch (SQLException e) {
+                    ExceptionHandler.handle("Erreur lors de l'insertion de la ligne de transfert", e);
+                }
+            }
+            @Override
+            public void deleted() {
+            }
+            @Override
+            public void cancelled() {
+            }
+        });
+    }
     public RowAction getCloneAction() {
         return new RowAction(new AbstractAction() {
                 return (selection != null && selection.size() == 1);
+            }
         };
+    }
+    private void changeStateOfRows(List<SQLRowValues> l, EtatCommandeFournisseur etat) {
+        List<Integer> ids = new ArrayList<Integer>(l.size());
+        for (SQLRowValues sqlRowValues : l) {
+            ids.add(sqlRowValues.getID());
+        }
+        UpdateBuilder builder = new UpdateBuilder(getTable());
+        builder.setObject("ETAT_COMMANDE", etat.getId());
+        builder.setWhere(Where.inValues(getTable().getKey(), ids));
+        getTable().getDBSystemRoot().getDataSource().execute(builder.asString());
+        getTable().fireTableModified(-1);
+        if (etat == EtatCommandeFournisseur.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 = Where.inValues(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());
+                    }
+                }
+                final SQLTable tableCmdItem = getTable().getTable("COMMANDE_ELEMENT");
+                UpdateBuilder build = new UpdateBuilder(tableCmdItem);
+                build.setObject("RECU_FORCED", Boolean.TRUE);
+                build.setWhere(Where.inValues(tableCmdItem.getField("ID_COMMANDE"), ids));
+                getTable().getDBSystemRoot().getDataSource().execute(build.asString());
+            } catch (SQLException e) {
+                ExceptionHandler.handle("Erreur lors de la suppression des mouvements de stocks", e);
+            }
+        }
+    }
     @Override
     protected void archive(TreesOfSQLRows trees, boolean cutLinks) throws SQLException {
         for (SQLRow row : trees.getRows()) {

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/supplychain/order/element/CommandeSQLElement.java - Rev 182 → 185