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 @ 177 - Rev 185
Rev 182 | Blame | Compare with Previous | Last modification | View Log | RSS feed
/** DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.** 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.** When distributing the software, include this License Header Notice in each file.*/package org.openconcerto.erp.core.supplychain.order.component;import org.openconcerto.erp.config.ComptaPropsConfiguration;import org.openconcerto.erp.core.common.component.AdresseSQLComponent;import org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent;import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;import org.openconcerto.erp.core.common.ui.DeviseField;import org.openconcerto.erp.core.common.ui.TotalPanel;import org.openconcerto.erp.core.finance.tax.model.TaxeCache;import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;import org.openconcerto.erp.core.supplychain.order.element.CommandeSQLElement;import org.openconcerto.erp.core.supplychain.order.element.DemandeAchatItemSQLElement;import org.openconcerto.erp.core.supplychain.order.ui.CommandeItemTable;import org.openconcerto.erp.core.supplychain.order.ui.EtatCommandeFournisseur;import org.openconcerto.erp.core.supplychain.order.ui.EtatCommandeFournisseurComboBox;import org.openconcerto.erp.core.supplychain.order.ui.EtatCommandeFournisseurRowItemView;import org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater;import org.openconcerto.erp.core.supplychain.stock.element.StockItemsUpdater.TypeStockUpdate;import org.openconcerto.erp.core.supplychain.stock.element.StockLabel;import org.openconcerto.erp.generationDoc.gestcomm.CommandeXmlSheet;import org.openconcerto.erp.panel.PanelOOSQLComponent;import org.openconcerto.erp.preferences.DefaultNXProps;import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;import org.openconcerto.erp.utils.TM;import org.openconcerto.sql.Configuration;import org.openconcerto.sql.element.DefaultElementSQLObject;import org.openconcerto.sql.element.ElementSQLObject;import org.openconcerto.sql.element.SQLElement;import org.openconcerto.sql.model.SQLBackgroundTableCache;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.SQLTable;import org.openconcerto.sql.model.Where;import org.openconcerto.sql.preferences.SQLPreferences;import org.openconcerto.sql.request.SQLRowItemView;import org.openconcerto.sql.sqlobject.ElementComboBox;import org.openconcerto.sql.sqlobject.JUniqueTextField;import org.openconcerto.sql.sqlobject.SQLRequestComboBox;import org.openconcerto.sql.sqlobject.SQLTextCombo;import org.openconcerto.sql.users.UserManager;import org.openconcerto.sql.view.EditFrame;import org.openconcerto.sql.view.list.RowValuesTable;import org.openconcerto.sql.view.list.RowValuesTableModel;import org.openconcerto.ui.AutoHideListener;import org.openconcerto.ui.DefaultGridBagConstraints;import org.openconcerto.ui.FormLayouter;import org.openconcerto.ui.JDate;import org.openconcerto.ui.TitledSeparator;import org.openconcerto.ui.component.ComboLockedMode;import org.openconcerto.ui.component.ITextArea;import org.openconcerto.ui.component.ITextCombo;import org.openconcerto.ui.component.InteractionMode;import org.openconcerto.ui.preferences.DefaultProps;import org.openconcerto.utils.ExceptionHandler;import org.openconcerto.utils.checks.ValidState;import java.awt.Color;import java.awt.GridBagConstraints;import java.awt.GridBagLayout;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.HashSet;import java.util.List;import java.util.Set;import javax.swing.JCheckBox;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTextField;import javax.swing.SwingConstants;import javax.swing.SwingUtilities;import javax.swing.event.DocumentEvent;import javax.swing.event.DocumentListener;import javax.swing.event.TableModelEvent;import javax.swing.event.TableModelListener;import com.ibm.icu.math.BigDecimal;public class CommandeSQLComponent extends TransfertBaseSQLComponent {protected CommandeItemTable table = new CommandeItemTable();protected PanelOOSQLComponent panelOO;protected JUniqueTextField numeroUniqueCommande;protected final SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");protected final ITextArea infos = new ITextArea(3, 3);protected ElementComboBox fourn = new ElementComboBox();protected final JCheckBox boxLivrClient = new JCheckBox("Livrer directement le client");protected DefaultElementSQLObject compAdr;protected final JPanel panelAdrSpec = new JPanel(new GridBagLayout());protected ElementComboBox boxAdr;protected JDate dateCommande = new JDate(true);protected ElementSQLObject componentPrincipaleAdr;public CommandeSQLComponent() {super(Configuration.getInstance().getDirectory().getElement("COMMANDE"));}public ElementComboBox getBoxFournisseur() {return this.fourn;}@Overrideprotected Set<String> createRequiredNames() {final Set<String> s = new HashSet<>(4);if (getTable().contains("ID_TYPE_CMD")) {s.add("ID_TYPE_CMD");s.add("DA1");s.add("ID_POLE_PRODUIT");}return s;}public void addViews() {this.setLayout(new GridBagLayout());final GridBagConstraints c = new DefaultGridBagConstraints();// Numero du commandec.gridx = 0;c.weightx = 0;this.add(new JLabel(getLabelFor("NUMERO"), SwingConstants.RIGHT), c);this.numeroUniqueCommande = new JUniqueTextField(16) {@Overridepublic String getAutoRefreshNumber() {if (getMode() == Mode.INSERTION) {return NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), dateCommande.getDate());} else {return null;}}};c.gridx++;c.weightx = 1;c.fill = GridBagConstraints.NONE;DefaultGridBagConstraints.lockMinimumSize(numeroUniqueCommande);this.add(this.numeroUniqueCommande, c);// DateJLabel labelDate = new JLabel(getLabelFor("DATE"));labelDate.setHorizontalAlignment(SwingConstants.RIGHT);c.gridx = 2;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(labelDate, c);c.gridx++;c.fill = GridBagConstraints.NONE;this.add(dateCommande, c);this.dateCommande.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {if (!isFilling() && dateCommande.getValue() != null) {table.setDateDevise(dateCommande.getValue());}}});// Fournisseurc.gridx = 0;c.gridy++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(new JLabel(getLabelFor("ID_FOURNISSEUR"), SwingConstants.RIGHT), c);c.gridx++;c.gridwidth = 1;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() {@Overridepublic 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);}if (getTable().contains("OFFRE_COM")) {final SQLRowItemView view = getView("OFFRE_COM");if (view != null) {((SQLTextCombo) view.getComp()).setValue(rowF.getString("RESPONSABLE"));}}} else {table.setRowCatComptable(null);}}});Boolean useCommandeEnCours = SQLPreferences.getMemCached(getElement().getTable().getDBRoot()).getBoolean(GestionCommercialeGlobalPreferencePanel.COMMANDE_FOURNISSEUR_EN_COURS, false);if (!getTable().getFieldsName().contains("LIVRER") && useCommandeEnCours) {// Commande en coursJCheckBox boxEnCours = new JCheckBox(getLabelFor("EN_COURS"));c.gridx += 2;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;c.gridwidth = GridBagConstraints.REMAINDER;this.add(boxEnCours, c);c.gridwidth = 1;this.addRequiredSQLObject(boxEnCours, "EN_COURS");}if (getTable().contains("DATE_RECEPTION_DEMANDEE")) {// DateJLabel labelDateRecptDemande = new JLabel(getLabelFor("DATE_RECEPTION_DEMANDEE"));labelDateRecptDemande.setHorizontalAlignment(SwingConstants.RIGHT);c.gridx = 0;c.gridy++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(labelDateRecptDemande, c);c.gridx++;c.fill = GridBagConstraints.NONE;JDate dateRecptDemande = new JDate();this.add(dateRecptDemande, c);this.addView(dateRecptDemande, "DATE_RECEPTION_DEMANDEE", REQ);JLabel labelDateRecptConfirme = new JLabel(getLabelFor("DATE_RECEPTION_CONFIRMEE"));labelDateRecptConfirme.setHorizontalAlignment(SwingConstants.RIGHT);c.gridx++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(labelDateRecptConfirme, c);c.gridx++;c.fill = GridBagConstraints.NONE;JDate dateRecptConfirme = new JDate();this.add(dateRecptConfirme, c);this.addView(dateRecptConfirme, "DATE_RECEPTION_CONFIRMEE");}// Fournisseurif (getTable().contains("ID_CONTACT_FOURNISSEUR")) {c.gridx = 0;c.gridy++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(new JLabel(getLabelFor("ID_CONTACT_FOURNISSEUR"), SwingConstants.RIGHT), c);c.gridx = GridBagConstraints.RELATIVE;c.gridwidth = 1;c.weightx = 1;c.weighty = 0;c.fill = GridBagConstraints.HORIZONTAL;final ElementComboBox boxContactFournisseur = new ElementComboBox();final SQLElement contactElement = Configuration.getInstance().getDirectory().getElement("CONTACT_FOURNISSEUR");boxContactFournisseur.init(contactElement, contactElement.getComboRequest(true));this.add(boxContactFournisseur, c);this.addView(boxContactFournisseur, "ID_CONTACT_FOURNISSEUR", REQ);fourn.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent arg0) {if (fourn.getSelectedRow() != null) {boxContactFournisseur.getRequest().setWhere(new Where(contactElement.getTable().getField("ID_FOURNISSEUR"), "=", fourn.getSelectedRow().getID()));} else {boxContactFournisseur.getRequest().setWhere(null);}}});}// Adresse de livraisonif (getTable().getFieldsName().contains("ID_ADRESSE")) {if (getTable().getFieldsName().contains("LIVRAISON_F")) {c.gridx = 0;c.gridy++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.boxAdr = new ElementComboBox();final SQLElement adrElement = getElement().getForeignElement("ID_ADRESSE");boxAdr.init(adrElement);c.gridwidth = 1;final JLabel labelAdrLiv = new JLabel("Adresse de livraison existante");this.add(labelAdrLiv, c);c.gridx++;c.gridwidth = 2;this.add(boxAdr, c);c.gridx = 0;c.gridy++;this.add(new JLabel(getLabelFor("ID_ADRESSE")), c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;// c.gridy++;this.addView("ID_ADRESSE");final DefaultElementSQLObject comp = (DefaultElementSQLObject) this.getView("ID_ADRESSE").getComp();componentPrincipaleAdr = (ElementSQLObject) this.getView("ID_ADRESSE");((AdresseSQLComponent) componentPrincipaleAdr.getSQLChild()).setDestinataireVisible(true);final JCheckBox boxLivr = new JCheckBox("Livré par le fournisseur");this.add(boxLivr, c);this.addSQLObject(boxLivr, "LIVRAISON_F");boxLivr.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {if (boxLivr.isSelected() && !comp.isCreated()) {comp.setCreated(true);componentPrincipaleAdr.setEditable(InteractionMode.READ_WRITE);if (CommandeSQLComponent.this.getTable().contains("ID_AFFAIRE")) {final SQLRow selectedRow = ((ElementComboBox) CommandeSQLComponent.this.getView("ID_AFFAIRE").getComp()).getSelectedRow();SQLRowValues rowVals = getLivraisonAdr(selectedRow);comp.setValue(rowVals);if (selectedRow != null && !selectedRow.isUndefined()) {final SQLRow clientRow = selectedRow.getForeign("ID_CLIENT");Where w = new Where(boxAdr.getRequest().getPrimaryTable().getField("ID_CLIENT"), "=", clientRow.getID());w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", clientRow.getInt("ID_ADRESSE")));// w = w.or(new// Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=",// clientRow.getInt("ID_ADRESSE_F")));w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", clientRow.getInt("ID_ADRESSE_L")));if (clientRow.getTable().contains("ID_ADRESSE_L_2")) {w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", clientRow.getInt("ID_ADRESSE_L_2")));}if (clientRow.getTable().contains("ID_ADRESSE_L_3")) {w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", clientRow.getInt("ID_ADRESSE_L_3")));}boxAdr.getRequest().setWhere(w);} else {boxAdr.getRequest().setWhere(null);}}} else {if (!boxLivr.isSelected()) {comp.setCreated(false);componentPrincipaleAdr.setEditable(InteractionMode.DISABLED);}}}});c.gridy++;this.add(comp, c);this.add(this.getView("ID_ADRESSE").getComp(), c);comp.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {boxAdr.setVisible(comp.isCreated());labelAdrLiv.setVisible(comp.isCreated());}});boxAdr.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {final SQLRow selectedRow = boxAdr.getSelectedRow();if (selectedRow != null && !selectedRow.isUndefined()) {SQLRowValues rowVals = selectedRow.asRowValues();rowVals.clearPrimaryKeys();comp.setValue(rowVals);}}});boxAdr.setVisible(false);labelAdrLiv.setVisible(false);} else {c.gridy++;c.gridx = 1;c.gridwidth = GridBagConstraints.REMAINDER;this.add(boxLivrClient, c);c.gridwidth = 1;final GridBagConstraints cAdr = new DefaultGridBagConstraints();panelAdrSpec.add(new JLabel(getLabelFor("ID_CLIENT"), SwingConstants.RIGHT), cAdr);final ElementComboBox boxClient = new ElementComboBox(true);cAdr.weightx = 1;cAdr.gridx++;panelAdrSpec.add(boxClient, cAdr);this.addView(boxClient, "ID_CLIENT");cAdr.gridy++;cAdr.weightx = 0;cAdr.gridx = 0;panelAdrSpec.add(new JLabel(TM.tr("address"), SwingConstants.RIGHT), cAdr);final SQLRequestComboBox boxAdr = new SQLRequestComboBox(true);boxAdr.uiInit(Configuration.getInstance().getDirectory().getElement(getTable().getTable("ADRESSE")).getComboRequest(true));boxClient.addModelListener("wantedID", new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {if (boxClient.getSelectedRow() != null && !boxClient.getSelectedRow().isUndefined()) {Where w = new Where(boxAdr.getRequest().getPrimaryTable().getField("ID_CLIENT"), "=", boxClient.getSelectedRow().getID());w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", boxClient.getSelectedRow().getInt("ID_ADRESSE")));w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", boxClient.getSelectedRow().getInt("ID_ADRESSE_F")));w = w.or(new Where(boxAdr.getRequest().getPrimaryTable().getKey(), "=", boxClient.getSelectedRow().getInt("ID_ADRESSE_L")));boxAdr.getRequest().setWhere(w);} else {boxAdr.getRequest().setWhere(null);}}});cAdr.weightx = 1;cAdr.gridx++;panelAdrSpec.add(boxAdr, cAdr);cAdr.gridx = 0;cAdr.gridy++;cAdr.weightx = 0;if (getMode() == Mode.MODIFICATION) {panelAdrSpec.add(new JLabel(getLabelFor("ID_ADRESSE")), cAdr);}cAdr.gridx++;cAdr.gridwidth = GridBagConstraints.REMAINDER;this.addView("ID_ADRESSE");compAdr = (DefaultElementSQLObject) this.getView("ID_ADRESSE").getComp();cAdr.gridy++;if (getMode() == Mode.MODIFICATION) {panelAdrSpec.add(compAdr, cAdr);}boxAdr.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {SQLRow row = boxAdr.getSelectedRow();if (row != null && !row.isUndefined()) {compAdr.setCreated(true);SQLRowValues asRowValues = new SQLRowValues(row.asRowValues());compAdr.setValue(asRowValues);}}});c.gridy++;c.gridx = 0;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 1;this.add(panelAdrSpec, c);c.gridwidth = 1;c.weightx = 0;boxLivrClient.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {panelAdrSpec.setVisible(boxLivrClient.isSelected());if (!boxLivrClient.isSelected()) {boxClient.setValue((Integer) null);boxAdr.setValue((Integer) null);compAdr.setCreated(false);}}});panelAdrSpec.setVisible(false);}}c.gridwidth = 1;// Champ Modulec.gridx = 0;c.gridy++;c.gridwidth = GridBagConstraints.REMAINDER;final JPanel addP = ComptaSQLConfElement.createAdditionalPanel();this.setAdditionalFieldsPanel(new FormLayouter(addP, 2));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 (showDevise) {// Devisec.gridx = 0;c.gridy++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(new JLabel(getLabelFor("ID_DEVISE"), SwingConstants.RIGHT), c);c.gridx++;c.gridwidth = 1;c.weightx = 1;c.weighty = 0;c.fill = GridBagConstraints.NONE;DefaultGridBagConstraints.lockMinimumSize(boxDevise);this.add(boxDevise, c);this.addView(boxDevise, "ID_DEVISE");fourn.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent arg0) {if (fourn.getSelectedRow() != null) {boxDevise.setValue(fourn.getSelectedRow().getForeignID("ID_DEVISE"));} else {boxDevise.setValue((SQLRowAccessor) null);}}});if (getTable().contains("INCOTERM")) {// Incotermc.gridx++;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(new JLabel(getLabelFor("INCOTERM"), SwingConstants.RIGHT), c);c.gridx++;c.gridwidth = 1;c.weightx = 1;c.weighty = 0;c.fill = GridBagConstraints.NONE;final ITextCombo box = new ITextCombo(ComboLockedMode.LOCKED);for (String s : ReferenceArticleSQLElement.CONDITIONS) {box.addItem(s);}this.add(box, c);this.addView(box, "INCOTERM", REQ);box.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {table.setIncoterms(box.getCurrentValue());}});}}// Referencec.gridx = 0;c.gridy++;c.gridwidth = 1;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;c.anchor = GridBagConstraints.EAST;this.add(new JLabel(getLabelFor("NOM"), SwingConstants.RIGHT), c);final SQLTextCombo textNom = new SQLTextCombo();c.gridx++;c.weightx = 1;this.add(textNom, c);String field;field = "ID_COMMERCIAL";// Commercialc.weightx = 0;c.gridx++;this.add(new JLabel(getLabelFor(field), SwingConstants.RIGHT), c);ElementComboBox commSel = new ElementComboBox(false, 25);c.gridx = GridBagConstraints.RELATIVE;c.gridwidth = 1;c.weightx = 1;c.weighty = 0;c.fill = GridBagConstraints.NONE;c.anchor = GridBagConstraints.WEST;this.add(commSel, c);addRequiredSQLObject(commSel, field);// Etatfinal JLabel labelEtat = new JLabel(getLabelFor("ETAT_COMMANDE"), SwingConstants.RIGHT);c.gridy++;c.gridx = 0;c.weightx = 0;c.fill = GridBagConstraints.HORIZONTAL;this.add(labelEtat, c);final EtatCommandeFournisseurComboBox comboEtat = new EtatCommandeFournisseurComboBox();c.gridx++;c.fill = GridBagConstraints.NONE;c.weightx = 1;this.add(comboEtat, c);addView(new EtatCommandeFournisseurRowItemView(comboEtat), "ETAT_COMMANDE", REQ);// Table d'élémentc.fill = GridBagConstraints.BOTH;c.gridy++;c.gridx = 0;c.weightx = 0;c.weighty = 1;c.gridwidth = 4;this.add(this.table, c);if (showDevise) {boxDevise.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {table.setDevise(boxDevise.getSelectedRow());}});}this.fourn.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {table.setFournisseur(fourn.getSelectedRow());}});// Bottomc.gridy++;c.weighty = 0;this.add(getBottomPanel(), c);c.gridx = 0;c.gridy++;c.fill = GridBagConstraints.NONE;c.anchor = GridBagConstraints.SOUTHEAST;c.gridwidth = GridBagConstraints.REMAINDER;this.panelOO = new PanelOOSQLComponent(this);this.add(this.panelOO, c);addSQLObject(textNom, "NOM");addRequiredSQLObject(dateCommande, "DATE");// addRequiredSQLObject(radioEtat, "ID_ETAT_DEVIS");addRequiredSQLObject(this.numeroUniqueCommande, "NUMERO");addSQLObject(this.infos, "INFOS");this.numeroUniqueCommande.setText(NumerotationAutoSQLElement.getNextNumero(getElement().getClass()));// radioEtat.setValue(EtatDevisSQLElement.EN_ATTENTE);// this.numeroUniqueDevis.addLabelWarningMouseListener(new MouseAdapter() {// public void mousePressed(MouseEvent e) {//// if (e.getClickCount() == 2 && e.getButton() == MouseEvent.BUTTON1) {// numeroUniqueDevis.setText(NumerotationAutoSQLElement.getNextNumeroDevis());// }// }// });DefaultGridBagConstraints.lockMinimumSize(this.fourn);DefaultGridBagConstraints.lockMinimumSize(commSel);this.addView(this.table.getRowValuesTable(), "");}protected SQLRowValues getLivraisonAdr(SQLRow rowAffaire) {if (rowAffaire != null) {SQLRow rowClient = rowAffaire.getForeignRow("ID_CLIENT");SQLRow rowAdrL = rowClient.getForeignRow("ID_ADRESSE_L");if (rowAdrL == null || rowAdrL.isUndefined()) {rowAdrL = rowClient.getForeignRow("ID_ADRESSE");}SQLRowValues rowVals = rowAdrL.asRowValues();rowVals.clearPrimaryKeys();return rowVals;} else {return new SQLRowValues(getTable().getTable("ADRESSE"));}}private JPanel getBottomPanel() {final JPanel panel = new JPanel(new GridBagLayout());final GridBagConstraints c = new DefaultGridBagConstraints();// Colonne 1 : Infosc.gridx = 0;c.weightx = 1;c.anchor = GridBagConstraints.WEST;c.fill = GridBagConstraints.HORIZONTAL;panel.add(new TitledSeparator(getLabelFor("INFOS")), c);c.gridy++;c.weighty = 0;c.weightx = 1;c.fill = GridBagConstraints.BOTH;final JScrollPane scrollPane = new JScrollPane(this.infos);scrollPane.setBorder(null);panel.add(scrollPane, c);// Colonne 2 : Poids & autresDefaultProps props = DefaultNXProps.getInstance();Boolean b = props.getBooleanValue("ArticleShowPoids");final JTextField textPoidsTotal = new JTextField(8);JTextField poids = new JTextField();if (b) {final JPanel panelPoids = new JPanel(new GridBagLayout());GridBagConstraints cPoids = new DefaultGridBagConstraints();cPoids.weightx = 0;panelPoids.add(new JLabel(getLabelFor("T_POIDS"), SwingConstants.RIGHT), cPoids);cPoids.weightx = 1;textPoidsTotal.setEnabled(false);textPoidsTotal.setHorizontalAlignment(JTextField.RIGHT);textPoidsTotal.setDisabledTextColor(Color.BLACK);cPoids.gridx++;panelPoids.add(textPoidsTotal, cPoids);c.gridx++;c.gridy = 0;c.weightx = 0;c.weighty = 0;c.gridwidth = 1;c.gridheight = 2;c.fill = GridBagConstraints.NONE;c.anchor = GridBagConstraints.NORTHEAST;panel.add(panelPoids, c);DefaultGridBagConstraints.lockMinimumSize(panelPoids);addSQLObject(textPoidsTotal, "T_POIDS");} else {addSQLObject(poids, "T_POIDS");}DeviseField textPortHT = new DeviseField();DeviseField textRemiseHT = new DeviseField();ElementComboBox comboTaxePort = new ElementComboBox(false, 10);if (getTable().contains("PORT_HT")) {final JPanel panelPoids = new JPanel(new GridBagLayout());GridBagConstraints cPort = new DefaultGridBagConstraints();cPort.gridx = 0;cPort.fill = GridBagConstraints.HORIZONTAL;cPort.weightx = 0;// Condition frais de portif (getTable().getForeignTable("ID_FOURNISSEUR").contains("CONDITIONS_PORT")) {cPort.gridwidth = 2;final JLabel labelConditionPort = new JLabel();labelConditionPort.setVisible(false);panelPoids.add(labelConditionPort, cPort);fourn.addModelListener("wantedID", (evt) -> {int wantedID = fourn.getWantedID();if (wantedID != SQLRow.NONEXISTANT_ID && wantedID >= SQLRow.MIN_VALID_ID) {final SQLRow rowF = getTable().getForeignTable("ID_FOURNISSEUR").getRow(wantedID);final String conditions = rowF.getString("CONDITIONS_PORT");if (conditions.trim().length() > 0) {labelConditionPort.setText(conditions);labelConditionPort.setVisible(true);} else {labelConditionPort.setText("");labelConditionPort.setVisible(false);}} else {labelConditionPort.setText("");labelConditionPort.setVisible(false);}});cPort.gridwidth = 1;cPort.gridy++;}addSQLObject(textPortHT, "PORT_HT");cPort.gridx = 0;cPort.fill = GridBagConstraints.HORIZONTAL;cPort.weightx = 0;panelPoids.add(new JLabel(getLabelFor("PORT_HT"), SwingConstants.RIGHT), cPort);textPortHT.setHorizontalAlignment(JTextField.RIGHT);cPort.gridx++;cPort.weightx = 1;panelPoids.add(textPortHT, cPort);cPort.gridy++;cPort.gridx = 0;cPort.weightx = 0;addRequiredSQLObject(comboTaxePort, "ID_TAXE_PORT");panelPoids.add(new JLabel(getLabelFor("ID_TAXE_PORT"), SwingConstants.RIGHT), cPort);cPort.gridx++;cPort.weightx = 1;panelPoids.add(comboTaxePort, cPort);addSQLObject(textRemiseHT, "REMISE_HT");cPort.gridy++;cPort.gridx = 0;cPort.fill = GridBagConstraints.HORIZONTAL;cPort.weightx = 0;panelPoids.add(new JLabel(getLabelFor("REMISE_HT"), SwingConstants.RIGHT), cPort);textRemiseHT.setHorizontalAlignment(JTextField.RIGHT);cPort.gridx++;cPort.weightx = 1;panelPoids.add(textRemiseHT, cPort);c.gridx++;c.gridy = 0;c.weightx = 0;c.weighty = 0;c.gridwidth = 1;c.gridheight = 2;c.fill = GridBagConstraints.NONE;c.anchor = GridBagConstraints.NORTHEAST;panel.add(panelPoids, c);DefaultGridBagConstraints.lockMinimumSize(panelPoids);}// TotalDeviseField fieldHT = new DeviseField();DeviseField fieldEco = new DeviseField();DeviseField fieldTVA = new DeviseField();DeviseField fieldTTC = new DeviseField();DeviseField fieldDevise = new DeviseField();DeviseField fieldService = new DeviseField();fieldHT.setOpaque(false);fieldTVA.setOpaque(false);fieldTTC.setOpaque(false);fieldService.setOpaque(false);addRequiredSQLObject(fieldEco, "T_ECO_CONTRIBUTION");addRequiredSQLObject(fieldDevise, "T_DEVISE");addRequiredSQLObject(fieldHT, "T_HT");addRequiredSQLObject(fieldTVA, "T_TVA");addRequiredSQLObject(fieldTTC, "T_TTC");addRequiredSQLObject(fieldService, "T_SERVICE");// Disablethis.allowEditable("T_ECO_CONTRIBUTION", false);this.allowEditable("T_HT", false);this.allowEditable("T_TVA", false);this.allowEditable("T_TTC", false);this.allowEditable("T_SERVICE", false);final TotalPanel totalTTC = new TotalPanel(this.table, fieldEco, fieldHT, fieldTVA, fieldTTC, textPortHT, textRemiseHT, fieldService, null, fieldDevise, null, null,(getTable().contains("ID_TAXE_PORT") ? comboTaxePort : null), null);c.gridx++;c.gridy--;c.gridwidth = GridBagConstraints.REMAINDER;c.gridheight = 2;c.anchor = GridBagConstraints.NORTHEAST;c.fill = GridBagConstraints.BOTH;c.weighty = 0;c.weightx = 0;DefaultGridBagConstraints.lockMinimumSize(totalTTC);panel.add(totalTTC, c);c.gridy += 3;c.gridheight = 2;c.fill = GridBagConstraints.NONE;c.anchor = GridBagConstraints.EAST;panel.add(getModuleTotalPanel(), c);table.getModel().addTableModelListener(new TableModelListener() {public void tableChanged(TableModelEvent e) {textPoidsTotal.setText(String.valueOf(table.getPoidsTotal()));}});textPortHT.getDocument().addDocumentListener(new DocumentListener() {public void changedUpdate(DocumentEvent e) {totalTTC.updateTotal();}public void removeUpdate(DocumentEvent e) {totalTTC.updateTotal();}public void insertUpdate(DocumentEvent e) {totalTTC.updateTotal();}});comboTaxePort.addValueListener(new PropertyChangeListener() {@Overridepublic void propertyChange(PropertyChangeEvent evt) {totalTTC.updateTotal();}});textRemiseHT.getDocument().addDocumentListener(new DocumentListener() {public void changedUpdate(DocumentEvent e) {totalTTC.updateTotal();}public void removeUpdate(DocumentEvent e) {totalTTC.updateTotal();}public void insertUpdate(DocumentEvent e) {totalTTC.updateTotal();}});return panel;}protected JPanel getModuleTotalPanel() {return AutoHideListener.listen(new JPanel());}public int insert(SQLRow order) {int idCommande = getSelectedID();// on verifie qu'un devis du meme numero n'a pas été inséré entre tempsint attempt = 0;if (!this.numeroUniqueCommande.checkValidation(false)) {while (attempt < JUniqueTextField.RETRY_COUNT) {String num = NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), dateCommande.getDate());this.numeroUniqueCommande.setText(num);attempt++;if (this.numeroUniqueCommande.checkValidation(false)) {System.err.println("ATEMPT " + attempt + " SUCCESS WITH NUMERO " + num);break;}try {Thread.sleep(JUniqueTextField.SLEEP_WAIT_MS);} catch (InterruptedException e) {e.printStackTrace();}}}final String num = this.numeroUniqueCommande.getText();if (attempt == JUniqueTextField.RETRY_COUNT) {idCommande = getSelectedID();ExceptionHandler.handle("Impossible d'ajouter, numéro de commande existant.");final Object root = SwingUtilities.getRoot(this);if (root instanceof EditFrame) {final EditFrame frame = (EditFrame) root;frame.getPanel().setAlwaysVisible(true);}} else {idCommande = super.insert(order);this.table.updateField("ID_COMMANDE", idCommande);// Création des articlesthis.table.createArticle(idCommande, this.getElement());try {updateStock(idCommande);} catch (SQLException e) {ExceptionHandler.handle("Erreur lors de la mise à jour du stock!", e);}// generation du documentfinal SQLRow row = getTable().getRow(idCommande);final CommandeXmlSheet sheet = new CommandeXmlSheet(row);sheet.createDocumentAsynchronous();sheet.showPrintAndExportAsynchronous(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true, getElement(), row);// incrémentation du numéro autoif (NumerotationAutoSQLElement.getNextNumero(getElement().getClass()).equalsIgnoreCase(this.numeroUniqueCommande.getText().trim())) {SQLRowValues rowVals = new SQLRowValues(this.tableNum);int val = this.tableNum.getRow(2).getInt(NumerotationAutoSQLElement.getLabelNumberFor(getElement().getClass()));val++;rowVals.put(NumerotationAutoSQLElement.getLabelNumberFor(getElement().getClass()), new Integer(val));try {rowVals.update(2);} catch (SQLException e) {e.printStackTrace();}}DemandeAchatItemSQLElement elt = getElement().getDirectory().getElement(DemandeAchatItemSQLElement.class);elt.updateStatus(getTable(), getTable().getTable("COMMANDE_ELEMENT"), idCommande);((CommandeSQLElement) getElement()).fireInsertedCmdListener(row);if (attempt > 0) {SwingUtilities.invokeLater(new Runnable() {public void run() {JOptionPane.showMessageDialog(null, "Le numéro a été actualisé en " + num);}});}}return idCommande;}@Overridepublic void select(SQLRowAccessor r) {if (!getTable().contains("LIVRAISON_F") && r != null && !r.isUndefined()) {SQLRowAccessor adr = (r.getFields().contains("ID_ADRESSE") ? r.getForeign("ID_ADRESSE") : null);boxLivrClient.setSelected(adr != null && !adr.isUndefined());panelAdrSpec.setVisible(boxLivrClient.isSelected());if (!boxLivrClient.isSelected()) {compAdr.setCreated(false);}}if (getTable().contains("LIVRAISON_F") && componentPrincipaleAdr != null) {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);}@Overridepublic void update() {if (!this.numeroUniqueCommande.checkValidation()) {ExceptionHandler.handle("Impossible d'ajouter, numéro de commande client existant.");Object root = SwingUtilities.getRoot(this);if (root instanceof EditFrame) {EditFrame frame = (EditFrame) root;frame.getPanel().setAlwaysVisible(true);}return;}super.update();final int id = getSelectedID();this.table.updateField("ID_COMMANDE", id);this.table.createArticle(id, this.getElement());ComptaPropsConfiguration.getInstanceCompta().getNonInteractiveSQLExecutor().execute(new Runnable() {@Overridepublic void run() {try {// Mise à jour du stockupdateStock(id);} catch (Exception e) {ExceptionHandler.handle("Update error", e);}}});DemandeAchatItemSQLElement elt = getElement().getDirectory().getElement(DemandeAchatItemSQLElement.class);elt.updateStatus(getTable(), getTable().getTable("COMMANDE_ELEMENT"), getSelectedID());// generation du documentfinal SQLRow row = getTable().getRow(id);final CommandeXmlSheet sheet = new CommandeXmlSheet(row);sheet.createDocumentAsynchronous();sheet.showPrintAndExportAsynchronous(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true, getElement(), row);}protected String getLibelleStock(SQLRowAccessor row, SQLRowAccessor rowElt) {return "Commande fournisseur N°" + row.getString("NUMERO");}/*** Mise à jour des stocks pour chaque article composant la facture** @throws SQLException*/private void updateStock(int id) throws SQLException {SQLRow row = getTable().getRow(id);StockItemsUpdater stockUpdater = new StockItemsUpdater(new StockLabel() {@Overridepublic String getLabel(SQLRowAccessor rowOrigin, SQLRowAccessor rowElt) {return getLibelleStock(rowOrigin, rowElt);}}, row, row.getReferentRows(getTable().getTable("COMMANDE_ELEMENT")), TypeStockUpdate.VIRTUAL_RECEPT);stockUpdater.update();}@Overridepublic synchronized ValidState getValidState() {if (getTable().contains("ID_TYPE_CMD") && getTable().contains("ID_AFFAIRE") && getTable().getTable("COMMANDE_ELEMENT").contains("ID_AFFAIRE")) {SQLRequestComboBox boxAff = (SQLRequestComboBox) getView("ID_AFFAIRE").getComp();final SQLRow selectedAff = boxAff.getSelectedRow();if (selectedAff == null || selectedAff.isUndefined()) {RowValuesTableModel tableRow = this.table.getRowValuesTable().getRowValuesTableModel();for (int i = 0; i < tableRow.getRowCount(); i++) {SQLRowValues rowVals = tableRow.getRowValuesAt(i);if (rowVals.getInt("QTE") != 0 && (rowVals.getObject("ID_AFFAIRE") == null || rowVals.isForeignEmpty("ID_AFFAIRE"))) {return ValidState.create(false, "Aucune affaire globale sélectionnée et une ligne avec une quantité > 0 n'est pas affectée à une affaire!");}}} else {ValidState.create(false, "Aucune affaire globale sélectionnée!");}}return super.getValidState();}public void setDefaults() {this.resetValue();this.numeroUniqueCommande.setText(NumerotationAutoSQLElement.getNextNumero(getElement().getClass()));this.table.getModel().clearRows();}@Overrideprotected SQLRowValues createDefaults() {SQLRowValues rowVals = new SQLRowValues(getTable());rowVals.put("T_POIDS", 0.0F);rowVals.put("EN_COURS", Boolean.TRUE);rowVals.put("ETAT_COMMANDE", EtatCommandeFournisseur.EN_ATTENTE.getId());// User// SQLSelect sel = new SQLSelect(Configuration.getInstance().getBase());SQLElement eltComm = Configuration.getInstance().getDirectory().getElement("COMMERCIAL");int idUser = UserManager.getInstance().getCurrentUser().getId();// sel.addSelect(eltComm.getTable().getKey());// sel.setWhere(new Where(eltComm.getTable().getField("ID_USER_COMMON"), "=", idUser));// List<SQLRow> rowsComm = (List<SQLRow>)// Configuration.getInstance().getBase().getDataSource().execute(sel.asString(), new// SQLRowListRSH(eltComm.getTable()));SQLRow rowsComm = SQLBackgroundTableCache.getInstance().getCacheForTable(eltComm.getTable()).getFirstRowContains(idUser, eltComm.getTable().getField("ID_USER_COMMON"));if (rowsComm != null) {rowVals.put("ID_COMMERCIAL", rowsComm.getID());}rowVals.put("T_HT", Long.valueOf(0));rowVals.put("T_SERVICE", Long.valueOf(0));rowVals.put("T_DEVISE", Long.valueOf(0));rowVals.put("T_TVA", Long.valueOf(0));rowVals.put("T_TTC", Long.valueOf(0));rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(getElement().getClass()));if (getTable().contains("ID_TAXE_PORT")) {rowVals.put("ID_TAXE_PORT", TaxeCache.getCache().getFirstTaxe().getID());}if (getTable().contains("LIVRAISON_F") && componentPrincipaleAdr != null) {componentPrincipaleAdr.setEditable(InteractionMode.DISABLED);}return rowVals;}public CommandeItemTable getRowValuesTablePanel() {return this.table;}@Overridepublic RowValuesTable getRowValuesTable() {return this.table.getRowValuesTable();}/*** Chargement des éléments d'une commande dans la table** @param idCommande**/public void loadCommande(int idCommande) {SQLElement commande = Configuration.getInstance().getDirectory().getElement("COMMANDE_CLIENT");SQLElement commandeElt = Configuration.getInstance().getDirectory().getElement("COMMANDE_CLIENT_ELEMENT");if (idCommande > 1) {SQLInjector injector = SQLInjector.getInjector(commande.getTable(), this.getTable());this.select(injector.createRowValuesFrom(idCommande));}loadItem(this.table, commande, idCommande, commandeElt);}/*** Chargement des éléments d'un devis dans la table** @param idDevis**/public void loadDevis(int idDevis) {SQLElement devis = Configuration.getInstance().getDirectory().getElement("DEVIS");SQLElement devisElt = Configuration.getInstance().getDirectory().getElement("DEVIS_ELEMENT");if (idDevis > 1) {SQLInjector injector = SQLInjector.getInjector(devis.getTable(), this.getTable());this.select(injector.createRowValuesFrom(idDevis));}loadItem(this.table, devis, idDevis, devisElt);}/*** Chargement des éléments d'une facture dans la table** @param idFact**/public void loadFacture(int idFact) {SQLElement facture = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE");SQLElement factureElt = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE_ELEMENT");if (idFact > 1) {SQLInjector injector = SQLInjector.getInjector(facture.getTable(), this.getTable());this.select(injector.createRowValuesFrom(idFact));}loadItem(this.table, facture, idFact, factureElt);}@Overrideprotected void refreshAfterSelect(SQLRowAccessor rSource) {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();rowVals.put("RECU", Boolean.FALSE);rowVals.put("RECU_FORCED", Boolean.FALSE);rowVals.put("QTE_RECUE", BigDecimal.ZERO);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();}}