WebSVN - OpenConcerto - Diff - Rev 149 and 156 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/invoice/element/SaisieVenteFactureItemSQLElement.java

  package org.openconcerto.erp.core.sales.invoice.element;
 import org.openconcerto.erp.config.ComptaPropsConfiguration;
 import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
 import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;
-import org.openconcerto.erp.core.common.ui.DeviseField;
 import org.openconcerto.erp.preferences.DefaultNXProps;
 import org.openconcerto.erp.rights.NXRights;
-import org.openconcerto.sql.Configuration;
 import org.openconcerto.sql.element.BaseSQLComponent;
 import org.openconcerto.sql.element.SQLComponent;
+import org.openconcerto.sql.element.SQLElement;
+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.sqlobject.ElementComboBox;
 import org.openconcerto.sql.users.rights.UserRights;
 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.IListe;
+import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
+import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
 import org.openconcerto.sql.view.list.SQLTableModelSource;
 import org.openconcerto.ui.DefaultGridBagConstraints;
 import org.openconcerto.ui.component.InteractionMode;
+import org.openconcerto.utils.DecimalUtils;
 import org.openconcerto.utils.cc.ITransformer;
 import java.awt.GridBagConstraints;
 import java.awt.GridBagLayout;
+import java.awt.event.ActionEvent;
+import java.math.BigDecimal;
 import java.sql.SQLException;
 import java.util.ArrayList;
+import java.util.HashMap;
 import java.util.HashSet;
 import java.util.List;
+import java.util.Map;
 import java.util.Set;
+import javax.swing.AbstractAction;
 import javax.swing.JLabel;
 import javax.swing.JTextField;
 public class SaisieVenteFactureItemSQLElement extends ComptaSQLConfElement {
+    private final ComptaPropsConfiguration conf;
-    public SaisieVenteFactureItemSQLElement() {
+    public SaisieVenteFactureItemSQLElement(final ComptaPropsConfiguration conf) {
-        super("SAISIE_VENTE_FACTURE_ELEMENT", "un article facturé", "articles facturés");
+        super(conf.getRootSociete().getTable("SAISIE_VENTE_FACTURE_ELEMENT"));
-    }
+        this.conf = conf;
+        PredicateRowAction action = new PredicateRowAction(new AbstractAction("Transfert vers commande fournisseur") {
+            @Override
+            public void actionPerformed(ActionEvent e) {
+                SQLElement cmd = getDirectory().getElement("COMMANDE");
+                EditFrame f = new EditFrame(cmd, EditMode.CREATION);
-    public SaisieVenteFactureItemSQLElement(String tableName, String singular, String plural) {
+                f.getSQLComponent().select(transfertCommande(IListe.get(e).getSelectedRows()));
+                f.setVisible(true);
+            }
+        }, false);
+        action.setPredicate(IListeEvent.getNonEmptySelectionPredicate());
-        super(tableName, singular, plural);
+        getRowActions().add(action);
+    }
+    public final ComptaPropsConfiguration getConf() {
+        return this.conf;
+    }
     @Override
     protected String getParentFFName() {
         return "ID_SAISIE_VENTE_FACTURE";
+    }
+    /**
+     * Transfert d'une commande en commande fournisseur
+     *
+     * @param commandeID
+     */
+    public SQLRowValues transfertCommande(List<SQLRowValues> factItems) {
+        SQLTable tableCmd = getDirectory().getElement("COMMANDE").getTable();
+        SQLTable tableCmdElt = getDirectory().getElement("COMMANDE_ELEMENT").getTable();
+        SQLRowValues rowCmd = new SQLRowValues(tableCmd);
+        final Map<Integer, SQLRowValues> map = new HashMap<Integer, SQLRowValues>();
+        for (SQLRowAccessor sqlRow : factItems) {
+            // on récupére l'article qui lui correspond
+            SQLRow sqlRowFetch = sqlRow.asRow();
+            sqlRowFetch.fetchValues();
+            if (sqlRowFetch.getObject("ID_ARTICLE") != null && !sqlRowFetch.getForeign("ID_ARTICLE").isUndefined()) {
+                int idArt = sqlRowFetch.getForeignID("ID_ARTICLE");
+                if (map.containsKey(idArt)) {
+                    SQLRowValues rowValsElt = map.get(idArt);
+                    rowValsElt.put("QTE", rowValsElt.getInt("QTE") + sqlRowFetch.getInt("QTE"));
+                } else {
+                    SQLInjector inj = SQLInjector.getInjector(sqlRowFetch.getForeign("ID_ARTICLE").getTable(), tableCmdElt);
+                    SQLRowValues rowValsElt = new SQLRowValues(inj.createRowValuesFrom(sqlRowFetch.getForeign("ID_ARTICLE").asRow()));
+                    rowValsElt.put("ID_STYLE", sqlRowFetch.getObject("ID_STYLE"));
+                    rowValsElt.put("QTE", sqlRowFetch.getObject("QTE"));
+                    rowValsElt.put("T_POIDS", sqlRowFetch.getLong("POIDS") * rowValsElt.getInt("QTE"));
+                    rowValsElt.put("T_PA_HT", ((BigDecimal) sqlRowFetch.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE")), DecimalUtils.HIGH_PRECISION));
+                    rowValsElt.put("T_PA_TTC",
+                            ((BigDecimal) sqlRowFetch.getObject("T_PA_HT")).multiply(new BigDecimal((sqlRowFetch.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0)), DecimalUtils.HIGH_PRECISION));
+                    rowValsElt.put("ID_COMMANDE", rowCmd);
+                    map.put(idArt, rowValsElt);
+                }
+            }
+        }
+        return rowCmd;
+    }
     /*
      * (non-Javadoc)
+     *
      * @see org.openconcerto.devis.BaseSQLElement#getComboFields()
      */
         };
+    }
     @Override
     protected String createCode() {
-        return createCodeFromPackage() + ".item";
+        return createCodeOfPackage() + ".item";
+    }
+}

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/element/SaisieVenteFactureItemSQLElement.java - Rev 149 → 156