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

/*

 * 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.invoice.element;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;

import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;

import org.openconcerto.erp.preferences.DefaultNXProps;

import org.openconcerto.erp.rights.NXRights;

import org.openconcerto.sql.element.BaseSQLComponent;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.model.SQLInjector;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowAccessor;

import org.openconcerto.sql.model.SQLRowValues;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.model.SQLTable;

import org.openconcerto.sql.model.Where;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.users.rights.UserRights;

import org.openconcerto.sql.users.rights.UserRightsManager;

import org.openconcerto.sql.view.EditFrame;

import org.openconcerto.sql.view.EditPanel.EditMode;

import org.openconcerto.sql.view.list.IListe;

import org.openconcerto.sql.view.list.IListeAction.IListeEvent;

import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;

import org.openconcerto.sql.view.list.SQLTableModelSource;

import org.openconcerto.ui.DefaultGridBagConstraints;

import org.openconcerto.ui.component.InteractionMode;

import org.openconcerto.utils.DecimalUtils;

import org.openconcerto.utils.cc.ITransformer;

import java.awt.GridBagConstraints;

import java.awt.GridBagLayout;

import java.awt.event.ActionEvent;

import java.math.BigDecimal;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.HashSet;

import java.util.List;

import java.util.Map;

import java.util.Set;

import javax.swing.AbstractAction;

import javax.swing.JLabel;

import javax.swing.JTextField;

public class SaisieVenteFactureItemSQLElement extends ComptaSQLConfElement {

    private final ComptaPropsConfiguration conf;

    public SaisieVenteFactureItemSQLElement(final ComptaPropsConfiguration conf) {

        super(conf.getRootSociete().getTable("SAISIE_VENTE_FACTURE_ELEMENT"));

        this.conf = conf;

        PredicateRowAction action = new PredicateRowAction(new AbstractAction("Transfert vers commande fournisseur") {

            @Override

            public void actionPerformed(ActionEvent e) {

                SQLElement cmd = getDirectory().getElement("COMMANDE");

                EditFrame f = new EditFrame(cmd, EditMode.CREATION);

                f.getSQLComponent().select(transfertCommande(IListe.get(e).getSelectedRows()));

                f.setVisible(true);

            }

        }, false);

        action.setPredicate(IListeEvent.getNonEmptySelectionPredicate());

        getRowActions().add(action);

    }

    public final ComptaPropsConfiguration getConf() {

        return this.conf;

    }

    @Override

    protected String getParentFFName() {

        return "ID_SAISIE_VENTE_FACTURE";

    }

    /**

     * Transfert d'une commande en commande fournisseur

     *

     * @param commandeID

     */

    public SQLRowValues transfertCommande(List<SQLRowValues> factItems) {

        SQLTable tableCmd = getDirectory().getElement("COMMANDE").getTable();

        SQLTable tableCmdElt = getDirectory().getElement("COMMANDE_ELEMENT").getTable();

        SQLRowValues rowCmd = new SQLRowValues(tableCmd);

        final Map<Integer, SQLRowValues> map = new HashMap<Integer, SQLRowValues>();

        for (SQLRowAccessor sqlRow : factItems) {

            // on récupére l'article qui lui correspond

            SQLRow sqlRowFetch = sqlRow.asRow();

            sqlRowFetch.fetchValues();

            if (sqlRowFetch.getObject("ID_ARTICLE") != null && !sqlRowFetch.getForeign("ID_ARTICLE").isUndefined()) {

                int idArt = sqlRowFetch.getForeignID("ID_ARTICLE");

                if (map.containsKey(idArt)) {

                    SQLRowValues rowValsElt = map.get(idArt);

                    rowValsElt.put("QTE", rowValsElt.getInt("QTE") + sqlRowFetch.getInt("QTE"));

                } else {

                    SQLInjector inj = SQLInjector.getInjector(sqlRowFetch.getForeign("ID_ARTICLE").getTable(), tableCmdElt);

                    SQLRowValues rowValsElt = new SQLRowValues(inj.createRowValuesFrom(sqlRowFetch.getForeign("ID_ARTICLE").asRow()));

                    rowValsElt.put("ID_STYLE", sqlRowFetch.getObject("ID_STYLE"));

                    rowValsElt.put("QTE", sqlRowFetch.getObject("QTE"));

                    rowValsElt.put("T_POIDS", sqlRowFetch.getLong("POIDS") * rowValsElt.getInt("QTE"));

                    rowValsElt.put("T_PA_HT", ((BigDecimal) sqlRowFetch.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE")), DecimalUtils.HIGH_PRECISION));

                    rowValsElt.put("T_PA_TTC",

                            ((BigDecimal) sqlRowFetch.getObject("T_PA_HT")).multiply(new BigDecimal((sqlRowFetch.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0)), DecimalUtils.HIGH_PRECISION));

                    rowValsElt.put("ID_COMMANDE", rowCmd);

                    map.put(idArt, rowValsElt);

                }

            }

        }

        return rowCmd;

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.BaseSQLElement#getComboFields()

     */

    protected List<String> getComboFields() {

        List<String> l = new ArrayList<String>();

        l.add("NIVEAU");

        l.add("CODE");

        l.add("NOM");

        l.add("PV_HT");

        l.add("ID_TAXE");

        l.add("POIDS");

        return l;

    }

    @Override

    protected synchronized void _initTableSource(final SQLTableModelSource table) {

        super._initTableSource(table);

    }

    @Override

    public Set<String> getReadOnlyFields() {

        Set<String> s = new HashSet<String>();

        s.add("CODE");

        s.add("NOM");

        s.add("PV_HT");

        s.add("POIDS");

        s.add("ID_TAXE");

        return super.getReadOnlyFields();

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.BaseSQLElement#getListFields()

     */

    @Override

    protected List<String> getListFields() {

        List<String> l = new ArrayList<String>();

        l.add("ID_SAISIE_VENTE_FACTURE");

        l.add("CODE");

        l.add("NOM");

        l.add("DESCRIPTIF");

        String articleAdvanced = DefaultNXProps.getInstance().getStringProperty("ArticleModeVenteAvance");

        Boolean bArticleAdvanced = Boolean.valueOf(articleAdvanced);

        if (bArticleAdvanced) {

            l.add("PRIX_METRIQUE_VT_1");

            l.add("ID_MODE_VENTE_ARTICLE");

        }

        if (UserRightsManager.getCurrentUserRights().haveRight(AbstractVenteArticleItemTable.SHOW_PRIX_ACHAT_CODE)) {

            l.add("PA_HT");

        }

        l.add("PV_HT");

        l.add("QTE");

        if (getTable().contains("ID_ECO_CONTRIBUTION")) {

            l.add("ID_ECO_CONTRIBUTION");

            l.add("ECO_CONTRIBUTION");

            l.add("T_ECO_CONTRIBUTION");

        }

        l.add("T_PA_HT");

        l.add("T_PV_HT");

        l.add("T_PV_TTC");

        return l;

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.SQLElement#getComponent()

     */

    public SQLComponent createComponent() {

        return new BaseSQLComponent(this) {

            JTextField textCode = new JTextField();

            JTextField textNom = new JTextField();

            JTextField textMontantHT = new JTextField();

            JTextField textMontantHA = new JTextField();

            ElementComboBox comboTaxe = new ElementComboBox();

            JTextField textPoids = new JTextField();

            JTextField textQte = new JTextField();

            public void addViews() {

                this.setLayout(new GridBagLayout());

                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Code

                JLabel labelCode = new JLabel(getLabelFor("CODE"));

                c.weightx = 0;

                this.add(labelCode, c);

                c.weightx = 1;

                c.gridx++;

                textCode.setEditable(false);

                this.add(textCode, c);

                // Libelle

                JLabel labelNom = new JLabel(getLabelFor("NOM"));

                c.weightx = 0;

                c.gridx++;

                this.add(labelNom, c);

                c.weightx = 1;

                c.gridx++;

                textNom.setEditable(false);

                this.add(textNom, c);

                // Montant HT

                JLabel labelMontantHT = new JLabel(getLabelFor("PV_HT"));

                c.weightx = 0;

                c.gridy++;

                c.gridx = 0;

                this.add(labelMontantHT, c);

                c.weightx = 1;

                c.gridx++;

                textMontantHT.setEditable(false);

                this.add(textMontantHT, c);

                // PA HT

                JLabel labelMontantHA = new JLabel(getLabelFor("PA_HT"));

                c.weightx = 0;

                c.gridy++;

                c.gridx = 0;

                this.add(labelMontantHA, c);

                c.weightx = 1;

                c.gridx++;

                this.add(textMontantHA, c);

                // Taxe

                c.gridx++;

                c.weightx = 0;

                c.gridwidth = GridBagConstraints.REMAINDER;

                comboTaxe.setEnabled(false);

                this.add(comboTaxe, c);

                // Poids

                JLabel labelPoids = new JLabel(getLabelFor("POIDS"));

                c.weightx = 0;

                c.gridy++;

                c.gridx = 0;

                c.gridwidth = 1;

                this.add(labelPoids, c);

                c.weightx = 1;

                c.gridx++;

                textPoids.setEditable(false);

                this.add(textPoids, c);

                // Quantité

                JLabel labelQte = new JLabel(getLabelFor("QTE"));

                // JLabel labelQte = new JLabel("TOTO");

                c.weightx = 0;

                c.gridx++;

                this.add(labelQte, c);

                c.weightx = 1;

                c.gridx++;

                textQte.setEditable(false);

                this.add(textQte, c);

                this.addRequiredSQLObject(textCode, "CODE");

                this.addRequiredSQLObject(textNom, "NOM");

                this.addRequiredSQLObject(textMontantHT, "PV_HT");

                this.addRequiredSQLObject(textMontantHA, "PA_HT");

                this.addSQLObject(textPoids, "POIDS");

                this.addSQLObject(textQte, "QTE");

                this.addRequiredSQLObject(comboTaxe, "ID_TAXE");

            }

            @Override

            public void select(SQLRowAccessor r) {

                // TODO Auto-generated method stub

                super.select(r);

                textCode.setEditable(false);

                textNom.setEditable(false);

                textMontantHT.setEditable(false);

                comboTaxe.setInteractionMode(InteractionMode.READ_ONLY);

                textPoids.setEditable(false);

                textQte.setEditable(false);

            }

            @Override

            public void update() {

                int id = getSelectedID();

                super.update();

                SQLRow row = getTable().getRow(id);

                final SQLRowValues createEmptyUpdateRow = row.createEmptyUpdateRow();

                createEmptyUpdateRow.put("PRIX_METRIQUE_HA_1", row.getObject("PA_HT"));

                createEmptyUpdateRow.put("T_PA_HT", row.getObject("PA_HT"));

                try {

                    createEmptyUpdateRow.commit();

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

            }

        };

    }

    @Override

    protected String createCode() {

        return createCodeOfPackage() + ".item";

    }

}