WebSVN - OpenConcerto - Diff - Rev 149 and 156 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/supplychain/order/component/CommandeSQLComponent.java

 import org.openconcerto.sql.model.SQLRow;
 import org.openconcerto.sql.model.SQLRowAccessor;
 import org.openconcerto.sql.model.SQLRowValues;
 import org.openconcerto.sql.model.SQLTable;
 import org.openconcerto.sql.model.Where;
+import org.openconcerto.sql.preferences.SQLPreferences;
 import org.openconcerto.sql.sqlobject.ElementComboBox;
 import org.openconcerto.sql.sqlobject.JUniqueTextField;
 import org.openconcerto.sql.sqlobject.SQLRequestComboBox;
 import org.openconcerto.sql.users.UserManager;
 import org.openconcerto.sql.view.EditFrame;
 import java.awt.event.ActionEvent;
 import java.awt.event.ActionListener;
 import java.beans.PropertyChangeEvent;
 import java.beans.PropertyChangeListener;
 import java.sql.SQLException;
+import java.util.List;
 import javax.swing.JCheckBox;
 import javax.swing.JLabel;
 import javax.swing.JOptionPane;
 import javax.swing.JPanel;
         c.weightx = 1;
         c.weighty = 0;
         c.fill = GridBagConstraints.NONE;
         this.add(this.fourn, c);
         addRequiredSQLObject(this.fourn, "ID_FOURNISSEUR");
+        fourn.addModelListener("wantedID", new PropertyChangeListener() {
+            @Override
+            public void propertyChange(PropertyChangeEvent evt) {
+                int wantedID = fourn.getWantedID();
+                if (wantedID != SQLRow.NONEXISTANT_ID && wantedID >= SQLRow.MIN_VALID_ID) {
+                    final SQLRow rowF = getTable().getForeignTable("ID_FOURNISSEUR").getRow(wantedID);
+                    if (rowF.getObject("ID_CATEGORIE_COMPTABLE") != null && !rowF.isForeignEmpty("ID_CATEGORIE_COMPTABLE")) {
+                        table.setRowCatComptable(rowF.getForeign("ID_CATEGORIE_COMPTABLE"));
+                    } else {
+                        table.setRowCatComptable(null);
+                    }
+                } else {
+                    table.setRowCatComptable(null);
+                }
+            }
+        });
         if (!getTable().getFieldsName().contains("LIVRER")) {
             // Commande en cours
             JCheckBox boxEnCours = new JCheckBox(getLabelFor("EN_COURS"));
             c.gridx += 2;
             } else {
                 c.gridy++;
                 c.gridx = 1;
                 c.gridwidth = GridBagConstraints.REMAINDER;
                 this.add(boxLivrClient, c);
                 c.gridwidth = 1;
                 final GridBagConstraints cAdr = new DefaultGridBagConstraints();
         this.add(addP, c);
         c.gridy++;
         c.gridwidth = 1;
+        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());
+        final boolean showDevise = prefs.getBoolean(AbstractVenteArticleItemTable.ARTICLE_SHOW_DEVISE, false);
         final ElementComboBox boxDevise = new ElementComboBox();
-        if (DefaultNXProps.getInstance().getBooleanValue(AbstractVenteArticleItemTable.ARTICLE_SHOW_DEVISE, false)) {
+        if (showDevise) {
             // Devise
             c.gridx = 0;
             c.gridy++;
             c.weightx = 0;
             c.fill = GridBagConstraints.HORIZONTAL;
         c.gridx = 0;
         c.weightx = 0;
         c.weighty = 1;
         c.gridwidth = 4;
         this.add(this.table, c);
-        if (DefaultNXProps.getInstance().getBooleanValue(AbstractVenteArticleItemTable.ARTICLE_SHOW_DEVISE, false)) {
+        if (showDevise) {
             boxDevise.addValueListener(new PropertyChangeListener() {
                 @Override
                 public void propertyChange(PropertyChangeEvent evt) {
             final boolean bLivraison = r != null && r.getFields().contains("ID_ADRESSE") && !r.isForeignEmpty("ID_ADRESSE");
             componentPrincipaleAdr.setEditable(bLivraison ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);
+        }
         super.select(r);
-        if (r != null) {
-            this.table.insertFrom("ID_COMMANDE", r.getID());
-        }
+    }
     @Override
     public void update() {
         if (!this.numeroUniqueCommande.checkValidation()) {
         if (this.dateCommande.getValue() != null) {
             this.table.setDateDevise(this.dateCommande.getValue());
+        }
+    }
+    public void duplicate(final int idCmd) {
+        final SQLElement cmd = Configuration.getInstance().getDirectory().getElement("COMMANDE");
+        final SQLElement cmdElt = Configuration.getInstance().getDirectory().getElement("COMMANDE_ELEMENT");
+        if (idCmd > 1) {
+            final SQLRow row = cmd.getTable().getRow(idCmd);
+            final SQLRowValues rowVals = new SQLRowValues(cmd.getTable());
+            rowVals.put("ID_FOURNISSEUR", row.getInt("ID_FOURNISSEUR"));
+            rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(getElement().getClass()));
+            this.select(rowVals);
+        }
+        final List<SQLRow> myListItem = cmd.getTable().getRow(idCmd).getReferentRows(cmdElt.getTable());
+        if (myListItem.size() != 0) {
+            this.table.getModel().clearRows();
+            for (final SQLRow rowElt : myListItem) {
+                final SQLRowValues rowVals = rowElt.createUpdateRow();
+                rowVals.clearPrimaryKeys();
+                this.table.getModel().addRow(rowVals);
+                final int rowIndex = this.table.getModel().getRowCount() - 1;
+                this.table.getModel().fireTableModelModified(rowIndex);
+            }
+        } else {
+            this.table.getModel().clearRows();
+        }
+        this.table.getModel().fireTableDataChanged();
+        this.table.repaint();
+    }
+}

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/component/CommandeSQLComponent.java - Rev 149 → 156