WebSVN - OpenConcerto - Diff - Rev 156 and 174 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/common/ui/AbstractVenteArticleItemTable.java

 import org.openconcerto.erp.core.sales.product.model.ProductHelper.TypePrice;
 import org.openconcerto.erp.core.sales.product.ui.ArticleRowValuesRenderer;
 import org.openconcerto.erp.core.sales.product.ui.CurrencyWithSymbolRenderer;
 import org.openconcerto.erp.core.sales.product.ui.QteMultipleRowValuesRenderer;
 import org.openconcerto.erp.core.sales.product.ui.QteUnitRowValuesRenderer;
+import org.openconcerto.erp.core.supplychain.stock.element.StockSQLElement;
 import org.openconcerto.erp.importer.ArrayTableModel;
 import org.openconcerto.erp.importer.DataImporter;
 import org.openconcerto.erp.preferences.DefaultNXProps;
 import org.openconcerto.erp.preferences.GestionArticleGlobalPreferencePanel;
 import org.openconcerto.sql.Configuration;
 import org.openconcerto.sql.preferences.SQLPreferences;
 import org.openconcerto.sql.sqlobject.ITextArticleWithCompletionCellEditor;
 import org.openconcerto.sql.sqlobject.ITextWithCompletion;
 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.AutoCompletionManager;
 import org.openconcerto.sql.view.list.CellDynamicModifier;
 import org.openconcerto.sql.view.list.RowValuesTable;
 import org.openconcerto.sql.view.list.RowValuesTableModel;
 import org.openconcerto.sql.view.list.SQLTableElement;
 import java.awt.datatransfer.UnsupportedFlavorException;
 import java.awt.dnd.DnDConstants;
 import java.awt.dnd.DropTarget;
 import java.awt.dnd.DropTargetDropEvent;
 import java.awt.event.ActionEvent;
+import java.awt.event.ActionListener;
 import java.awt.event.HierarchyEvent;
 import java.awt.event.HierarchyListener;
 import java.awt.event.KeyEvent;
 import java.awt.event.MouseAdapter;
 import java.awt.event.MouseEvent;
 import javax.swing.AbstractAction;
 import javax.swing.JButton;
 import javax.swing.JFrame;
 import javax.swing.JLabel;
+import javax.swing.JMenu;
+import javax.swing.JMenuItem;
 import javax.swing.JOptionPane;
 import javax.swing.JPopupMenu;
 import javax.swing.JTable;
 import javax.swing.SwingUtilities;
 import javax.swing.ToolTipManager;
         eNiveau.setEditor(new NiveauTableCellEditor());
         list.add(eNiveau);
         list.add(new SQLTableElement(e.getTable().getField("ID_STYLE")));
+        if (e.getTable().contains("ID_COMPTE_PCE")) {
+            list.add(new SQLTableElement(e.getTable().getField("ID_COMPTE_PCE")));
+        }
         final SQLTableElement tableFamille = new SQLTableElement(e.getTable().getField("ID_FAMILLE_ARTICLE"));
         list.add(tableFamille);
         // Article
         SQLTableElement tableElementDepot = new SQLTableElement(e.getTable().getField("ID_DEPOT_STOCK"), true, true, true);
             @Override
             public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {
                 return isCellNiveauEditable(vals, rowIndex, columnIndex);
+            }
         };
+        CurrencyWithSymbolRenderer totalRenderer = new CurrencyWithSymbolRenderer();
+        totalRenderer.setHideZeroValue(true);
-        this.totalHT.setRenderer(new CurrencyWithSymbolRenderer());
+        this.totalHT.setRenderer(totalRenderer);
         this.totalHT.setEditable(false);
         if (e.getTable().getFieldsName().contains("MONTANT_FACTURABLE")) {
             // SQLTableElement tableElementAcompte = new
             // SQLTableElement(e.getTable().getField("POURCENT_ACOMPTE"));
             // list.add(tableElementAcompte);
             list.add(tableElementRG);
+        }
         // Total HT
         this.totalHA = new SQLTableElement(e.getTable().getField("T_PA_HT"), BigDecimal.class);
-        this.totalHA.setRenderer(new CurrencyWithSymbolRenderer());
+        this.totalHA.setRenderer(totalRenderer);
         this.totalHA.setEditable(false);
         list.add(this.totalHA);
         if (showDevise) {
             // Total HT
                 public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {
                     return isCellNiveauEditable(vals, rowIndex, columnIndex);
+                }
             };
             Path p = new Path(getSQLElement().getTable()).addForeignField("ID_DEVISE");
-            this.tableElementTotalDevise.setRenderer(new CurrencyWithSymbolRenderer(new FieldPath(p, "CODE")));
+            CurrencyWithSymbolRenderer currencyRenderer = new CurrencyWithSymbolRenderer(new FieldPath(p, "CODE"));
+            currencyRenderer.setHideZeroValue(true);
+            this.tableElementTotalDevise.setRenderer(currencyRenderer);
-            list.add(tableElementTotalDevise);
+            list.add(this.tableElementTotalDevise);
+        }
         // Marge HT
         if (e.getTable().getFieldsName().contains("MARGE_HT")) {
                 public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {
                     return isCellNiveauEditable(vals, rowIndex, columnIndex);
+                }
             };
-            marge.setRenderer(new CurrencyWithSymbolRenderer());
+            marge.setRenderer(totalRenderer);
             marge.setEditable(false);
             list.add(marge);
             this.totalHT.addModificationListener(marge);
             this.totalHA.addModificationListener(marge);
             marge.setModifier(new CellDynamicModifier() {
             @Override
             public boolean isCellEditable(SQLRowValues vals, int rowIndex, int columnIndex) {
                 return isCellNiveauEditable(vals, rowIndex, columnIndex);
+            }
         };
-        this.tableElementTotalTTC.setRenderer(new CurrencyWithSymbolRenderer());
+        this.tableElementTotalTTC.setRenderer(totalRenderer);
         this.tableElementTotalTTC.setEditable(false);
         list.add(this.tableElementTotalTTC);
         this.defaultRowVals = new SQLRowValues(UndefinedRowValuesCache.getInstance().getDefaultRowValues(e.getTable()));
         defaultRowVals.put("ID_TAXE", TaxeCache.getCache().getFirstTaxe().getID());
         this.table = new RowValuesTable(model, getConfigurationFile());
         ToolTipManager.sharedInstance().unregisterComponent(this.table);
         ToolTipManager.sharedInstance().unregisterComponent(this.table.getTableHeader());
+        this.table.getTableHeader().addMouseListener(new MouseAdapter() {
+            @Override
+            public void mousePressed(MouseEvent e) {
+                if (e.isPopupTrigger()) {
+                    displayPopupMenu(e);
+                }
+            }
+            @Override
+            public void mouseReleased(MouseEvent e) {
+                if (e.isPopupTrigger()) {
+                    displayPopupMenu(e);
+                }
+            }
+            private void displayPopupMenu(MouseEvent e) {
+                JPopupMenu menu = new JPopupMenu();
+                TaxeCache cache = TaxeCache.getCache();
+                Set<SQLRowAccessor> taxes = cache.getAllTaxe();
+                JMenu subMenuTVA = new JMenu("Appliquer une TVA spécifique sur toutes les lignes");
+                menu.add(subMenuTVA);
+                for (SQLRowAccessor taxe : taxes) {
+                    subMenuTVA.add(new JMenuItem(new AbstractAction(taxe.getFloat("TAUX") + "%") {
+                        @Override
+                        public void actionPerformed(ActionEvent e) {
+                            for (int i = 0; i < AbstractVenteArticleItemTable.this.table.getRowCount(); i++) {
+                                AbstractVenteArticleItemTable.this.table.getRowValuesTableModel().putValue(taxe.getID(), i, "ID_TAXE");
+                            }
+                        }
+                    }));
+                }
+                menu.show(e.getComponent(), e.getX(), e.getY());
+            }
+        });
         if (filterFamilleArticle) {
             ((SQLTextComboTableCellEditor) tableElementArticle.getTableCellEditor(this.table)).setDynamicWhere(e.getTable().getTable("ARTICLE").getField("ID_FAMILLE_ARTICLE"));
+        }
         // Autocompletion
             @Override
             protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {
                 Object res = tarifCompletion(row, field, rowDest, true);
                 if (res == null) {
-                    return super.getValueFrom(row, field, rowDest);
+                    res = super.getValueFrom(row, field, rowDest);
-                } else {
+                }
+                if (field.equals("POURCENT_REMISE")) {
-                    return res;
+                    return getRemiseClient(row);
+                }
+                return res;
+            }
         };
         m.fill("NOM", "NOM");
         m.fill("ID", "ID_ARTICLE");
         final AutoCompletionManager m2 = new AutoCompletionManager(tableElementNom, sqlTableArticle.getField("NOM"), this.table, this.table.getRowValuesTableModel()) {
             @Override
             protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {
                 Object res = tarifCompletion(row, field, rowDest, true);
                 if (res == null) {
-                    return super.getValueFrom(row, field, rowDest);
+                    res = super.getValueFrom(row, field, rowDest);
-                } else {
-                    return res;
+                }
+                if (field.equals("POURCENT_REMISE")) {
+                    return getRemiseClient(row);
+                }
+                return res;
+            }
         };
         m2.fill("CODE", "CODE");
         m2.fill("ID", "ID_ARTICLE");
                 ITextWithCompletion.MODE_CONTAINS, true, true, new ValidStateChecker()) {
             @Override
             protected Object getValueFrom(SQLRow row, String field, SQLRowAccessor rowDest) {
                 Object res = tarifCompletion(row, field, rowDest, true);
                 if (res == null) {
-                    return super.getValueFrom(row, field, rowDest);
+                    res = super.getValueFrom(row, field, rowDest);
-                } else {
-                    return res;
+                }
+                if (field.equals("POURCENT_REMISE")) {
+                    return getRemiseClient(row);
+                }
+                return res;
+            }
         };
         m3.fill("CODE", "CODE");
         m3.fill("NOM", "NOM");
+        }
         // On réécrit la configuration au cas ou les preferences aurait changé (ajout ou suppression
         // du mode de vente specifique)
         this.table.writeState();
+        if (this.table.getRowValuesTableModel().getColumnForField("ID_DEPOT_STOCK") >= 0 && this.table.getRowValuesTableModel().getColumnForField("ID_ARTICLE") >= 0) {
+            if (this.buttons == null) {
+                this.buttons = new ArrayList<>();
+            }
+            JButton buttonStock = new JButton("Consulter le stock");
+            buttonStock.addActionListener(new ActionListener() {
+                public void actionPerformed(ActionEvent event) {
+                    SQLRowValues rowValsSel = table.getSelectedRowValues();
+                    if (rowValsSel != null) {
+                        SQLRowAccessor foreignArt = rowValsSel.getForeign("ID_ARTICLE");
+                        if (foreignArt != null && !foreignArt.isUndefined()) {
+                            SQLRowAccessor rowValsStock = StockSQLElement.getStock(rowValsSel);
+                            if (rowValsStock != null && !rowValsStock.isUndefined()) {
+                                EditFrame frame = new EditFrame(table.getRowValuesTableModel().getSQLElement().getDirectory().getElement("STOCK"), EditMode.READONLY);
+                                frame.selectionId(rowValsStock.getID());
+                                frame.setVisible(true);
+                            }
+                        }
+                    }
+                }
+            });
+            this.buttons.add(buttonStock);
+        }
+    }
+    Collection<? extends SQLRowAccessor> cacheRemise = null;
+    protected BigDecimal getTarifRemiseClient(SQLRowAccessor article, BigDecimal pv) {
+        if (cacheRemise != null) {
+            if (getRowClient() != null && !getRowClient().isUndefined() && article != null && !article.isUndefined()) {
+                for (SQLRowAccessor sqlRowAccessor : cacheRemise) {
+                    if (!sqlRowAccessor.isForeignEmpty("ID_ARTICLE") && sqlRowAccessor.getForeignID("ID_ARTICLE") == article.getID()) {
+                        BigDecimal remise = sqlRowAccessor.getBigDecimal("POURCENT_REMISE");
+                        if (remise != null) {
+                            return pv.multiply(BigDecimal.ONE.subtract(remise.movePointLeft(2)), DecimalUtils.HIGH_PRECISION).setScale(pv.scale(), RoundingMode.HALF_UP);
+                        }
+                    }
+                }
+            }
+        }
+        return pv;
+    }
+    protected Acompte getRemiseClient(SQLRowAccessor article) {
+        Acompte remise = new Acompte(BigDecimal.ZERO, BigDecimal.ZERO);
+        if (this.cacheRemise != null) {
+            if (getRowClient() != null && !getRowClient().isUndefined() && article != null && !article.isUndefined()) {
+                for (SQLRowAccessor sqlRowAccessor : this.cacheRemise) {
+                    if (!sqlRowAccessor.isForeignEmpty("ID_ARTICLE") && sqlRowAccessor.getForeignID("ID_ARTICLE") == article.getID()) {
+                        BigDecimal r = sqlRowAccessor.getBigDecimal("POURCENT_REMISE");
+                        if (remise != null) {
+                            remise = new Acompte(r, null);
+                        }
+                    }
+                }
+            }
+        }
+        return remise;
+    }
     @Override
     protected void refreshDeviseAmount() {
         int count = getRowValuesTable().getRowCount();
             return null;
+        }
+    }
     @Override
+    public void setClient(SQLRowAccessor rowClient, boolean ask) {
+        if (rowClient == null || getRowClient() == null || rowClient.getID() != getRowClient().getID()) {
+            super.setClient(rowClient, ask);
+            if (getRowClient() != null && !getRowClient().isUndefined()) {
+                this.cacheRemise = getRowClient().getReferentRows(getSQLElement().getTable().getTable("TARIF_ARTICLE_CLIENT"));
+                if (ask && getRowValuesTable().getRowCount() > 0
+                        && JOptionPane.showConfirmDialog(null, "Appliquer les remises associées au client sur les lignes déjà présentes?") == JOptionPane.YES_OPTION) {
+                    int nbRows = this.table.getRowCount();
+                    for (int i = 0; i < nbRows; i++) {
+                        SQLRowValues rowVals = getRowValuesTable().getRowValuesTableModel().getRowValuesAt(i);
+                        if (!rowVals.isForeignEmpty("ID_ARTICLE")) {
+                            SQLRowAccessor rowValsArt = rowVals.getForeign("ID_ARTICLE");
+                            final Object taxeValue = tarifCompletion(rowValsArt, "ID_TAXE", rowVals);
+                            if (taxeValue != null) {
+                                getRowValuesTable().getRowValuesTableModel().putValue(taxeValue, i, "ID_TAXE");
+                            }
+                            final Object deviseValue = tarifCompletion(rowValsArt, "ID_DEVISE", rowVals);
+                            if (deviseValue != null) {
+                                getRowValuesTable().getRowValuesTableModel().putValue(deviseValue, i, "ID_DEVISE");
+                            }
+                            getRowValuesTable().getRowValuesTableModel().putValue(tarifCompletion(rowValsArt, "PV_U_DEVISE", rowVals), i, "PV_U_DEVISE");
+                            getRowValuesTable().getRowValuesTableModel().putValue(tarifCompletion(rowValsArt, "PRIX_METRIQUE_VT_1", rowVals), i, "PRIX_METRIQUE_VT_1");
+                        }
+                    }
+                }
+            } else {
+                this.cacheRemise = null;
+            }
+        }
+    }
+    @Override
     public void setTarif(SQLRowAccessor rowValuesTarif, boolean ask) {
         if (rowValuesTarif == null || getTarif() == null || rowValuesTarif.getID() != getTarif().getID()) {
             super.setTarif(rowValuesTarif, ask);
             if (ask && getRowValuesTable().getRowCount() > 0
                     && JOptionPane.showConfirmDialog(null, "Appliquer les tarifs associés au client sur les lignes déjà présentes?") == JOptionPane.YES_OPTION) {

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

svn://code.openconcerto.org/openconcerto

(root)/trunk/OpenConcerto/src/org/openconcerto/erp/core/common/ui/AbstractVenteArticleItemTable.java - Rev 156 → 174