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/pos/element/SaisieVenteComptoirSQLElement.java - Rev 156
Rev 151 | Blame | Compare with Previous | Last modification | View Log | RSS feed
/** DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.** Copyright 2011 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.sales.pos.element;import java.awt.GridBagConstraints;import java.awt.GridBagLayout;import java.awt.Insets;import java.awt.event.ActionListener;import java.awt.event.KeyAdapter;import java.awt.event.KeyEvent;import java.beans.PropertyChangeEvent;import java.beans.PropertyChangeListener;import java.math.BigDecimal;import java.sql.SQLException;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Arrays;import java.util.Calendar;import java.util.Date;import java.util.HashMap;import java.util.HashSet;import java.util.List;import java.util.Map;import java.util.Set;import javax.swing.JCheckBox;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JTextField;import javax.swing.SwingConstants;import javax.swing.SwingUtilities;import javax.swing.event.DocumentEvent;import javax.swing.event.DocumentListener;import org.apache.commons.dbutils.handlers.ArrayListHandler;import org.openconcerto.erp.config.ComptaPropsConfiguration;import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;import org.openconcerto.erp.core.common.ui.DeviseField;import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;import org.openconcerto.erp.core.sales.product.element.UniteVenteArticleSQLElement;import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;import org.openconcerto.erp.generationEcritures.GenerationMvtSaisieVenteComptoir;import org.openconcerto.erp.model.PrixTTC;import org.openconcerto.erp.preferences.ModeReglementDefautPrefPanel;import org.openconcerto.sql.Configuration;import org.openconcerto.sql.element.BaseSQLComponent;import org.openconcerto.sql.element.ElementSQLObject;import org.openconcerto.sql.element.SQLComponent;import org.openconcerto.sql.element.SQLElement;import org.openconcerto.sql.element.TreesOfSQLRows;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.sqlobject.SQLSearchableTextCombo;import org.openconcerto.ui.DefaultGridBagConstraints;import org.openconcerto.ui.JDate;import org.openconcerto.ui.TitledSeparator;import org.openconcerto.ui.component.ITextArea;import org.openconcerto.ui.component.InteractionMode;import org.openconcerto.ui.warning.JLabelWarning;import org.openconcerto.utils.ExceptionHandler;import org.openconcerto.utils.GestionDevise;import org.openconcerto.utils.ListMap;import org.openconcerto.utils.StringUtils;import org.openconcerto.utils.checks.EmptyListener;import org.openconcerto.utils.checks.EmptyObj;import org.openconcerto.utils.checks.ValidState;import org.openconcerto.utils.text.SimpleDocumentListener;public class SaisieVenteComptoirSQLElement extends ComptaSQLConfElement {public SaisieVenteComptoirSQLElement() {super("SAISIE_VENTE_COMPTOIR", "une saisie d'une vente comptoir", "saisies de ventes comptoir");}protected List<String> getListFields() {final List<String> l = new ArrayList<String>();l.add("DATE");l.add("NOM");l.add("ID_CLIENT");l.add("ID_MODE_REGLEMENT");l.add("MONTANT_HT");l.add("MONTANT_SERVICE");l.add("MONTANT_TTC");return l;}protected List<String> getComboFields() {final List<String> l = new ArrayList<String>();l.add("DATE");l.add("MONTANT_TTC");return l;}/** (non-Javadoc)** @see org.openconcerto.devis.SQLElement#getComponent()*/public SQLComponent createComponent() {return new BaseSQLComponent(this) {private final JCheckBox checkService = new JCheckBox("dont ");private SQLSearchableTextCombo textNom;private DeviseField textMontantTTC;private DeviseField textMontantService;private ElementComboBox comboFournisseur;private JTextField textEcheance;private ElementComboBox comboTaxe;private DeviseField textMontantHT;private JCheckBox checkCommande;private JDate dateSaisie;private ElementComboBox nomArticle;private Date dateEch;private JLabel labelEcheancejours = new JLabel("jours");private ElementComboBox comboAvoir;private ElementComboBox comboClient;private final JLabel labelWarning = new JLabelWarning("le montant du service ne peut pas dépasser le total HT!");private ValidState validState = ValidState.getTrueInstance();// FIXME: use wprivate Where w;private DocumentListener docTTCListen;private PropertyChangeListener propertyChangeListener = new PropertyChangeListener() {public void propertyChange(PropertyChangeEvent evt) {if ((nomArticle.getValidState().isValid()) && (!nomArticle.isEmpty()) && !isFilling()) {int idArticle = nomArticle.getValue().intValue();SQLTable tableArticle = ((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("ARTICLE");SQLRow rowArticle = tableArticle.getRow(idArticle);if (rowArticle != null) {comboTaxe.setValue(rowArticle.getInt("ID_TAXE"));textMontantTTC.setText(((BigDecimal) rowArticle.getObject("PV_TTC")).toString());}System.out.println("value article Changed");}}};public void addViews() {this.setLayout(new GridBagLayout());final GridBagConstraints c = new DefaultGridBagConstraints();this.docTTCListen = new DocumentListener() {public void changedUpdate(DocumentEvent e) {calculMontant();}public void removeUpdate(DocumentEvent e) {calculMontant();}public void insertUpdate(DocumentEvent e) {calculMontant();}};/************************************************************************************ * RENSEIGNEMENTS**********************************************************************************/c.gridwidth = GridBagConstraints.REMAINDER;c.gridheight = 1;TitledSeparator sep = new TitledSeparator("Renseignements");this.add(sep, c);c.insets = new Insets(2, 2, 1, 2);c.gridwidth = 1;// Libellé venteJLabel labelNom = new JLabel(getLabelFor("NOM"));labelNom.setHorizontalAlignment(SwingConstants.RIGHT);c.gridy++;c.gridx = 0;c.weightx = 0;this.add(labelNom, c);this.textNom = new SQLSearchableTextCombo();c.gridx++;c.weightx = 1;c.gridwidth = 2;this.add(this.textNom, c);// DateJLabel labelDate = new JLabel(getLabelFor("DATE"));this.dateSaisie = new JDate(true);c.gridwidth = 1;// c.gridx += 2;c.gridx = 0;c.gridy++;c.weightx = 0;labelDate.setHorizontalAlignment(SwingConstants.RIGHT);this.add(labelDate, c);c.gridx++;c.weightx = 1;this.add(this.dateSaisie, c);// articlec.gridy++;c.gridx = 0;this.nomArticle = new ElementComboBox();JLabel labelNomArticle = new JLabel(getLabelFor("ID_ARTICLE"));c.weightx = 0;labelNomArticle.setHorizontalAlignment(SwingConstants.RIGHT);// this.add(labelNomArticle, c);c.gridx++;c.weightx = 0;c.gridwidth = GridBagConstraints.REMAINDER;// this.add(this.nomArticle, c);this.nomArticle.addValueListener(this.propertyChangeListener);// clientthis.comboClient = new ElementComboBox();this.comboClient.addValueListener(new PropertyChangeListener() {public void propertyChange(PropertyChangeEvent evt) {if (comboClient.isEmpty()) {w = new Where(getTable().getBase().getTable("AVOIR_CLIENT").getField("ID_CLIENT"), "=", -1);} else {w = new Where(getTable().getBase().getTable("AVOIR_CLIENT").getField("ID_CLIENT"), "=", comboClient.getSelectedId());}}});JLabel labelNomClient = new JLabel(getLabelFor("ID_CLIENT"));c.gridy++;c.gridx = 0;c.gridwidth = 1;c.weightx = 0;labelNomClient.setHorizontalAlignment(SwingConstants.RIGHT);this.add(labelNomClient, c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 0;this.add(this.comboClient, c);// Selection d'un avoir si le client en possedethis.comboAvoir = new ElementComboBox();JLabel labelAvoirClient = new JLabel(getLabelFor("ID_AVOIR_CLIENT"));c.gridy++;c.gridx = 0;c.gridwidth = 1;c.weightx = 0;labelAvoirClient.setHorizontalAlignment(SwingConstants.RIGHT);// this.add(labelAvoirClient, c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 0;// this.add(this.comboAvoir, c);// Compte spec de produitJLabel labelCptProduit = new JLabel(getLabelFor("ID_COMPTE_PCE_PRODUIT"));c.gridy++;c.gridx = 0;c.gridwidth = 1;c.weightx = 0;labelCptProduit.setHorizontalAlignment(SwingConstants.RIGHT);this.add(labelCptProduit, c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 0;ElementComboBox comboCptProduit = new ElementComboBox();this.add(comboCptProduit, c);addView(comboCptProduit, "ID_COMPTE_PCE_PRODUIT");// Compte spec de produitJLabel labelCptService = new JLabel(getLabelFor("ID_COMPTE_PCE_SERVICE"));c.gridy++;c.gridx = 0;c.gridwidth = 1;c.weightx = 0;labelCptService.setHorizontalAlignment(SwingConstants.RIGHT);this.add(labelCptService, c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 0;ElementComboBox comboCptService = new ElementComboBox();this.add(comboCptService, c);addView(comboCptService, "ID_COMPTE_PCE_SERVICE");/************************************************************************************ * MONTANT**********************************************************************************/c.gridwidth = GridBagConstraints.REMAINDER;c.gridx = 0;c.gridy++;c.weightx = 1;sep = new TitledSeparator("Montant en Euros");c.insets = new Insets(10, 2, 1, 2);this.add(sep, c);c.insets = new Insets(2, 2, 1, 2);c.gridwidth = 1;final JLabel labelMontantHT = new JLabel(getLabelFor("MONTANT_HT"));labelMontantHT.setHorizontalAlignment(SwingConstants.RIGHT);this.textMontantHT = new DeviseField();this.textMontantHT.setEditable(false);this.textMontantHT.setEnabled(false);this.textMontantHT.setFocusable(false);final JLabel labelMontantTTC = new JLabel(getLabelFor("MONTANT_TTC"));labelMontantTTC.setHorizontalAlignment(SwingConstants.RIGHT);this.textMontantTTC = new DeviseField();this.textMontantTTC.getDocument().addDocumentListener(this.docTTCListen);// Montant HTc.fill = GridBagConstraints.HORIZONTAL;c.weightx = 0;c.gridy++;c.gridx = 0;c.gridwidth = 1;this.add(labelMontantHT, c);c.gridx++;c.weightx = 1;this.add(this.textMontantHT, c);// Montant Servicec.gridx++;c.weightx = 0;this.add(checkService, c);checkService.addActionListener(new ActionListener() {public void actionPerformed(java.awt.event.ActionEvent e) {if (isFilling())return;boolean b = checkService.isSelected();textMontantService.setEditable(b);textMontantService.setEnabled(b);textMontantService.setFocusable(b);if (!b) {textMontantService.setText("");// montantServiceValide = true;} else {textMontantService.setText(textMontantHT.getText());}};});this.textMontantService = new DeviseField();c.gridx++;c.weightx = 1;this.add(this.textMontantService, c);JLabel labelMontantService = new JLabel("de service HT");c.weightx = 0;c.gridx++;this.add(labelMontantService, c);c.gridx++;c.gridwidth = GridBagConstraints.REMAINDER;this.add(this.labelWarning, c);this.labelWarning.setVisible(false);// Choix TVAc.gridy++;c.gridx = 0;c.weightx = 0;c.gridwidth = 1;final JLabel labelTaxe = new JLabel(getLabelFor("ID_TAXE"));labelTaxe.setHorizontalAlignment(SwingUtilities.RIGHT);this.add(labelTaxe, c);c.gridx++;this.comboTaxe = new ElementComboBox(false);c.fill = GridBagConstraints.NONE;this.add(this.comboTaxe, c);c.fill = GridBagConstraints.HORIZONTAL;// Montant TTCc.gridy++;c.gridx = 0;c.weightx = 0;this.add(labelMontantTTC, c);c.gridx++;c.weightx = 0;this.add(this.textMontantTTC, c);/************************************************************************************ * MODE DE REGLEMENT**********************************************************************************/c.gridwidth = GridBagConstraints.REMAINDER;c.gridx = 0;c.gridy++;sep = new TitledSeparator("Mode de règlement");c.insets = new Insets(10, 2, 1, 2);this.add(sep, c);c.insets = new Insets(2, 2, 1, 2);c.gridx = 0;c.gridy++;c.gridwidth = GridBagConstraints.REMAINDER;this.addView("ID_MODE_REGLEMENT", REQ + ";" + DEC + ";" + SEP);ElementSQLObject eltModeRegl = (ElementSQLObject) this.getView("ID_MODE_REGLEMENT");this.add(eltModeRegl, c);/************************************************************************************ * COMMANDE**********************************************************************************/c.gridwidth = GridBagConstraints.REMAINDER;c.gridx = 0;c.gridy++;sep = new TitledSeparator("Commande");c.insets = new Insets(10, 2, 1, 2);this.add(sep, c);c.insets = new Insets(2, 2, 1, 2);this.checkCommande = new JCheckBox("Produit à commander");c.gridx = 0;c.gridy++;c.weightx = 0;c.gridwidth = 2;// this.add(this.checkCommande, c);this.checkCommande.addActionListener(new ActionListener() {public void actionPerformed(java.awt.event.ActionEvent e) {boolean b = checkCommande.isSelected();comboFournisseur.setEnabled(b);comboFournisseur.setInteractionMode((b) ? InteractionMode.READ_WRITE : InteractionMode.DISABLED);textEcheance.setEditable(b);textEcheance.setEnabled(b);updateValidState();};});// FournisseursJLabel labelFournisseur = new JLabel(getLabelFor("ID_FOURNISSEUR"));c.gridx = 0;c.gridy++;c.weightx = 0;c.gridwidth = 1;labelFournisseur.setHorizontalAlignment(SwingConstants.RIGHT);// this.add(labelFournisseur, c);this.comboFournisseur = new ElementComboBox();c.gridx++;c.weightx = 1;c.gridwidth = 4;// this.add(this.comboFournisseur, c);// EcheanceJLabel labelEcheance = new JLabel("Echeance");c.gridx = 0;c.gridy++;c.weightx = 0;c.gridwidth = 1;labelEcheance.setHorizontalAlignment(SwingConstants.RIGHT);// this.add(labelEcheance, c);c.gridx++;c.weightx = 1;this.textEcheance = new JTextField();// this.add(this.textEcheance, c);this.textEcheance.addKeyListener(new KeyAdapter() {public void keyReleased(KeyEvent e) {calculDate();}});c.gridx++;c.weightx = 0;// this.add(this.labelEcheancejours, c);/************************************************************************************ * INFORMATIONS COMPLEMENTAIRES**********************************************************************************/c.gridwidth = GridBagConstraints.REMAINDER;c.gridx = 0;c.gridy++;sep = new TitledSeparator("Informations complémentaires");c.insets = new Insets(10, 2, 1, 2);// this.add(sep, c);c.insets = new Insets(2, 2, 1, 2);ITextArea textInfos = new ITextArea();c.gridx = 0;c.gridy++;c.gridheight = GridBagConstraints.REMAINDER;c.gridwidth = GridBagConstraints.REMAINDER;c.weightx = 1;c.weighty = 1;c.fill = GridBagConstraints.BOTH;// this.add(textInfos, c);this.addSQLObject(this.textNom, "NOM");this.addRequiredSQLObject(this.comboClient, "ID_CLIENT");this.addSQLObject(this.nomArticle, "ID_ARTICLE");this.addRequiredSQLObject(this.textMontantTTC, "MONTANT_TTC");this.addRequiredSQLObject(this.textMontantHT, "MONTANT_HT");this.addSQLObject(this.textMontantService, "MONTANT_SERVICE");this.addRequiredSQLObject(this.dateSaisie, "DATE");this.addSQLObject(textInfos, "INFOS");this.addSQLObject(this.comboFournisseur, "ID_FOURNISSEUR");this.addSQLObject(this.textEcheance, "ECHEANCE");this.addRequiredSQLObject(this.comboTaxe, "ID_TAXE");this.addSQLObject(this.comboAvoir, "ID_AVOIR_CLIENT");this.comboTaxe.setButtonsVisible(false);this.comboTaxe.setValue(2);checkService.setSelected(false);this.textMontantService.setEditable(false);this.textMontantService.setEnabled(false);this.checkCommande.setSelected(false);this.comboFournisseur.setInteractionMode(InteractionMode.DISABLED);this.comboFournisseur.setEnabled(false);this.textEcheance.setEditable(false);this.textEcheance.setEnabled(false);this.comboTaxe.addValueListener(new PropertyChangeListener() {public void propertyChange(PropertyChangeEvent evt) {calculMontant();}});final SimpleDocumentListener docL = new SimpleDocumentListener() {@Overridepublic void update(DocumentEvent e) {updateValidState();}};this.textMontantService.getDocument().addDocumentListener(docL);this.textMontantHT.getDocument().addDocumentListener(docL);this.comboFournisseur.addEmptyListener(new EmptyListener() {@Overridepublic void emptyChange(EmptyObj src, boolean newValue) {updateValidState();}});/** this.nomClient.addValueListener(new PropertyChangeListener() {** public void propertyChange(PropertyChangeEvent evt) { if (nomClient.isValid()) {* System.err.println("Changed Combo Avoir"); comboAvoir = new ElementComboBox(new* AvoirClientSQLElement(new Where(new* AvoirClientSQLElement().getTable().getField("ID_CLIENT"), "=",* nomClient.getValue()))); if (comboAvoir != null) { comboAvoir.setEnabled(true); }* } else { comboAvoir.setEnabled(false); } } });*/}@Overridepublic Set<String> getPartialResetNames() {Set<String> s = new HashSet<String>();s.addAll(super.getPartialResetNames());s.add("MONTANT_TTC");s.add("MONTANT_SERVICE");s.add("MONTANT_HT");s.add("NOM");s.add("ID_AVOIR_CLIENT");s.add("ID_ARTICLE");s.add("INFOS");return s;}private void calculMontant() {if (!isFilling()) {float taux;// PrixHT pHT;PrixTTC pTTC;// taux de la TVA selectionneeint idTaxe = this.comboTaxe.getSelectedId();if (idTaxe > 1) {SQLRow ligneTaxe = getTable().getBase().getTable("TAXE").getRow(idTaxe);if (ligneTaxe != null) {taux = (ligneTaxe.getFloat("TAUX")) / 100.0F;// calcul des montants HT ou TTCif (this.textMontantTTC.getText().trim().length() > 0) {if (this.textMontantTTC.getText().trim().equals("-")) {pTTC = new PrixTTC(0);} else {pTTC = new PrixTTC(GestionDevise.parseLongCurrency(this.textMontantTTC.getText()));}// affichageupdateTextHT(GestionDevise.currencyToString(pTTC.calculLongHT(taux)));} else {updateTextHT("");}}}}}private boolean isMontantServiceValid() {String montant = this.textMontantService.getText().trim();String montantHT = this.textMontantHT.getText().trim();boolean b;if (montant.length() == 0) {b = true;} else {if (montantHT.length() == 0) {b = false;} else {b = (GestionDevise.parseLongCurrency(montantHT) >= GestionDevise.parseLongCurrency(montant));}}this.labelWarning.setVisible(!b);System.err.println("Montant service is valid ? " + b + " --> HT val " + montantHT + " --> service val " + montant);return b;}/** private void calculMontantHT() {** float taux; PrixHT pHT;** if (!this.comboTaxe.isEmpty()) { // taux de la TVA selectionnee SQLRow ligneTaxe =* Configuration.getInstance().getBase().getTable( "TAXE").getRow(((Integer)* this.comboTaxe.getValue()).intValue()); taux = (ligneTaxe.getFloat("TAUX")) / 100; //* calcul des montants HT ou TTC if (this.textMontantHT.getText().trim().length() > 0) {** if (this.textMontantHT.getText().trim().equals("-")) { pHT = new PrixHT(0); } else {* pHT = new PrixHT(Float.parseFloat(this.textMontantHT.getText())); } // affichage* updateTextTTC(String.valueOf(pHT.CalculTTC(taux))); } else updateTextTTC(""); } }*/private void updateTextHT(final String prixHT) {SwingUtilities.invokeLater(new Runnable() {public void run() {textMontantHT.setText(prixHT);}});}@Overrideprotected SQLRowValues createDefaults() {SQLRowValues vals = new SQLRowValues(this.getTable());SQLRowAccessor r;try {r = ModeReglementDefautPrefPanel.getDefaultRow(true);SQLElement eltModeReglement = Configuration.getInstance().getDirectory().getElement("MODE_REGLEMENT");if (r.getID() > 1) {SQLRowValues rowVals = eltModeReglement.createCopy(r.getID());System.err.println(rowVals.getInt("ID_TYPE_REGLEMENT"));vals.put("ID_MODE_REGLEMENT", rowVals);}} catch (SQLException e) {System.err.println("Impossible de sélectionner le mode de règlement par défaut du client.");e.printStackTrace();}return vals;}// private void updateTextTTC(final String prixTTC) {// SwingUtilities.invokeLater(new Runnable() {//// public void run() {//// if (docTTCListen != null) {//// textMontantTTC.getDocument().removeDocumentListener(docTTCListen);// }//// textMontantTTC.setText(prixTTC);//// // textTaxe.setText(prixTVA);// textMontantTTC.getDocument().addDocumentListener(docTTCListen);// }// });// }private void calculDate() {int aJ = 0;// on récupére les valeurs saisiesif (this.textEcheance.getText().trim().length() != 0) {try {aJ = Integer.parseInt(this.textEcheance.getText());} catch (Exception e) {System.out.println("Erreur de format sur TextField Ajour " + this.textEcheance.getText());}}Calendar cal = Calendar.getInstance();// on fixe le temps sur ToDay + Ajourcal.setTime(new Date());long tempsMil = aJ * 86400000L;cal.setTimeInMillis(cal.getTimeInMillis() + tempsMil);DateFormat dateFormat = new SimpleDateFormat("dd/MM/yy");this.dateEch = cal.getTime();this.labelEcheancejours.setText("jours, soit le " + dateFormat.format(this.dateEch));}private void updateValidState() {this.setValidState(this.computeValidState());}private ValidState computeValidState() {ValidState res = ValidState.getTrueInstance();if (!this.isMontantServiceValid())res = res.and(ValidState.createCached(false, this.labelWarning.getText()));if (this.checkCommande.isSelected())res = res.and(ValidState.createCached(!this.comboFournisseur.isEmpty(), "Fournisseur non renseigné"));return res;}private final void setValidState(ValidState validState) {if (!validState.equals(this.validState)) {this.validState = validState;this.fireValidChange();}}@Overridepublic synchronized ValidState getValidState() {return super.getValidState().and(this.validState);}public int insert(SQLRow order) {// On teste si l'article n'existe pas, on le créeif (this.nomArticle.isEmpty()) {createArticle();}if (this.textNom.getValue() == null || this.textNom.getValue().trim().length() <= 0) {this.textNom.setValue(this.nomArticle.getTextComp().getText());}final int id = super.insert(order);// on verifie si le produit est à commanderif (this.checkCommande.isSelected()) {createCommande(id);}SQLRow rowArt = getTable().getRow(id).getForeignRow("ID_ARTICLE");if (rowArt != null && !rowArt.isUndefined() && rowArt.getBoolean("GESTION_STOCK")) {Configuration.getInstance().getNonInteractiveSQLExecutor().execute(new Runnable() {@Overridepublic void run() {final SQLRow rowVC = getTable().getRow(id);// Mise à jour des stocksfinal SQLElement eltMvtStock = Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK");final SQLRowValues rowVals = new SQLRowValues(eltMvtStock.getTable());rowVals.put("QTE", -1);rowVals.put("NOM", "Saisie vente comptoir");rowVals.put("IDSOURCE", id);rowVals.put("SOURCE", getTable().getName());rowVals.put("ID_ARTICLE", rowVC.getInt("ID_ARTICLE"));rowVals.put("ID_STOCK", rowVC.getForeign("ID_ARTICLE").getForeignID("ID_STOCK"));rowVals.put("DATE", rowVC.getObject("DATE"));try {final SQLRow row = rowVals.insert();final ListMap<SQLRow, SQLRowValues> map = ((MouvementStockSQLElement) Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK")).updateStock(Arrays.asList(row), false);MouvementStockSQLElement.createCommandeF(map, null);} catch (SQLException e) {ExceptionHandler.handle("Erreur lors de la création des mouvements de stock", e);}}});}new GenerationMvtSaisieVenteComptoir(id);return id;}private void createCommande(final int id) {System.out.println("Ajout d'une commande");SQLRow rowSaisie = SaisieVenteComptoirSQLElement.this.getTable().getRow(id);Map<String, Object> m = new HashMap<String, Object>();// NOM, DATE, ECHEANCE, IDSOURCE, SOURCE, ID_CLI, ID_FOURN, ID_ARTICLEm.put("NOM", rowSaisie.getObject("NOM"));m.put("DATE", rowSaisie.getObject("DATE"));m.put("DATE_ECHEANCE", new java.sql.Date(this.dateEch.getTime()));m.put("IDSOURCE", new Integer(id));m.put("SOURCE", "SAISIE_VENTE_COMPTOIR");m.put("ID_CLIENT", rowSaisie.getObject("ID_CLIENT"));m.put("ID_FOURNISSEUR", rowSaisie.getObject("ID_FOURNISSEUR"));m.put("ID_ARTICLE", rowSaisie.getObject("ID_ARTICLE"));SQLTable tableCmd = getTable().getBase().getTable("COMMANDE_CLIENT");SQLRowValues valCmd = new SQLRowValues(tableCmd, m);try {if (valCmd.getInvalid() == null) {// ajout de l'ecriturevalCmd.insert();}} catch (Exception e) {System.err.println("Erreur à l'insertion dans la table " + valCmd.getTable().getName());e.printStackTrace();}}private void createArticle() {System.out.println("Création de l'article");String tNomArticle = this.nomArticle.getTextComp().getText();String codeArticle = "";// this.nomArticle.getTextOpt();if (tNomArticle.trim().length() == 0 && codeArticle.trim().length() == 0) {return;}SQLTable articleTable = getTable().getBase().getTable("ARTICLE");int idTaxe = this.comboTaxe.getSelectedId();final BigDecimal prix = StringUtils.getBigDecimalFromUserText(this.textMontantHT.getText());final BigDecimal prixTTC = StringUtils.getBigDecimalFromUserText(this.textMontantTTC.getText());if (tNomArticle.trim().length() == 0) {tNomArticle = "Nom Indefini";}if (codeArticle.trim().length() == 0) {codeArticle = "Indefini";}SQLRowValues vals = new SQLRowValues(articleTable);vals.put("NOM", tNomArticle);vals.put("CODE", codeArticle);vals.put("PA_HT", prix);vals.put("PV_HT", prix);vals.put("PRIX_METRIQUE_VT_1", prix);vals.put("PRIX_METRIQUE_HA_1", prix);vals.put("PV_TTC", prixTTC);vals.put("ID_UNITE_VENTE", UniteVenteArticleSQLElement.A_LA_PIECE);vals.put("ID_TAXE", new Integer(idTaxe));vals.put("CREATION_AUTO", Boolean.TRUE);vals.put("GESTION_STOCK", Boolean.FALSE);try {SQLRow row = vals.insert();this.nomArticle.setValue(row);} catch (SQLException e) {e.printStackTrace();}}public void update() {if (JOptionPane.showConfirmDialog(this, "Attention en modifiant cette vente comptoir, vous supprimerez les chéques et les échéances associés. Continuer?","Modification de vente comptoir", JOptionPane.YES_NO_OPTION) == JOptionPane.YES_OPTION) {// on efface les mouvements de stocks associésSQLRow row = getTable().getRow(this.getSelectedID());SQLElement eltMvtStock = Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK");SQLSelect sel = new SQLSelect();sel.addSelect(eltMvtStock.getTable().getField("ID"));Where w = new Where(eltMvtStock.getTable().getField("IDSOURCE"), "=", row.getID());Where w2 = new Where(eltMvtStock.getTable().getField("SOURCE"), "=", getTable().getName());sel.setWhere(w.and(w2));List l = (List) eltMvtStock.getTable().getBase().getDataSource().execute(sel.asString(), new ArrayListHandler());if (l != null) {for (int i = 0; i < l.size(); i++) {Object[] tmp = (Object[]) l.get(i);try {eltMvtStock.archive(((Number) tmp[0]).intValue());} catch (SQLException e) {e.printStackTrace();}}}if (this.textNom.getValue() != null && this.textNom.getValue().trim().length() <= 0) {this.textNom.setValue(this.nomArticle.getTextComp().getText());}// On teste si l'article n'existe pas, on le créeif (this.nomArticle.getValue() == null || Integer.parseInt(this.nomArticle.getValue().toString()) == -1) {createArticle();}// TODO check echeance, ---> creation article, commande??super.update();row = getTable().getRow(this.getSelectedID());int idMvt = row.getInt("ID_MOUVEMENT");System.out.println(row.getID() + "__________***************** UPDATE " + idMvt);// on supprime tout ce qui est lié à la factureEcritureSQLElement eltEcr = (EcritureSQLElement) Configuration.getInstance().getDirectory().getElement("ECRITURE");eltEcr.archiveMouvementProfondeur(idMvt, false);SQLRow rowArt = row.getForeignRow("ID_ARTICLE");if (rowArt != null && !rowArt.isUndefined() && rowArt.getBoolean("GESTION_STOCK")) {// Mise à jour des stocksSQLRowValues rowVals = new SQLRowValues(eltMvtStock.getTable());rowVals.put("QTE", -1);rowVals.put("NOM", "Saisie vente comptoir");rowVals.put("IDSOURCE", getSelectedID());rowVals.put("SOURCE", getTable().getName());rowVals.put("ID_ARTICLE", row.getInt("ID_ARTICLE"));rowVals.put("ID_STOCK", row.getForeign("ID_ARTICLE").getForeignID("ID_STOCK"));rowVals.put("DATE", row.getObject("DATE"));try {SQLRow rowNew = rowVals.insert();final ListMap<SQLRow, SQLRowValues> map = ((MouvementStockSQLElement) Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK")).updateStock(Arrays.asList(rowNew), false);ComptaPropsConfiguration.getInstanceCompta().getNonInteractiveSQLExecutor().execute(new Runnable() {@Overridepublic void run() {MouvementStockSQLElement.createCommandeF(map, null);}});} catch (SQLException e) {e.printStackTrace();}}if (idMvt > 1) {new GenerationMvtSaisieVenteComptoir(this.getSelectedID(), idMvt);} else {new GenerationMvtSaisieVenteComptoir(this.getSelectedID());}}}@Overridepublic void select(SQLRowAccessor r) {this.textMontantTTC.getDocument().removeDocumentListener(this.docTTCListen);this.nomArticle.rmValueListener(this.propertyChangeListener);super.select(r);checkService.setSelected(r != null && r.getObject("MONTANT_SERVICE") != null && r.getLong("MONTANT_SERVICE") > 0);this.textMontantTTC.getDocument().addDocumentListener(this.docTTCListen);this.nomArticle.addValueListener(this.propertyChangeListener);}@Overridepublic void select(SQLRowAccessor r, Set<String> views) {super.select(r, views);checkService.setSelected(r != null && r.getObject("MONTANT_SERVICE") != null && r.getLong("MONTANT_SERVICE") > 0);}};}@Overrideprotected void archive(TreesOfSQLRows trees, boolean cutLinks) throws SQLException {// TODO Auto-generated method stubsuper.archive(trees, cutLinks);for (SQLRow row : trees.getRows()) {// Mise à jour des stocksSQLElement eltMvtStock = Configuration.getInstance().getDirectory().getElement("MOUVEMENT_STOCK");SQLSelect sel = new SQLSelect(eltMvtStock.getTable().getBase());sel.addSelect(eltMvtStock.getTable().getField("ID"));Where w = new Where(eltMvtStock.getTable().getField("IDSOURCE"), "=", row.getID());Where w2 = new Where(eltMvtStock.getTable().getField("SOURCE"), "=", getTable().getName());sel.setWhere(w.and(w2));List l = (List) eltMvtStock.getTable().getBase().getDataSource().execute(sel.asString(), new ArrayListHandler());if (l != null) {for (int i = 0; i < l.size(); i++) {Object[] tmp = (Object[]) l.get(i);eltMvtStock.archive(((Number) tmp[0]).intValue());}}}}@Overrideprotected String createCode() {return createCodeOfPackage() + ".sale";}}