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.account;

import org.openconcerto.erp.core.common.component.TransfertGroupSQLComponent;

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

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

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

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

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

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

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

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

import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseType;

import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;

import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;

import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;

import org.openconcerto.erp.core.sales.invoice.ui.FactureSituationItemTable;

import org.openconcerto.erp.generationEcritures.GenerationMvtSaisieVenteFacture;

import org.openconcerto.erp.panel.PanelOOSQLComponent;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.ElementSQLObject;

import org.openconcerto.sql.element.GlobalMapper;

import org.openconcerto.sql.element.SQLElement;

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.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.JUniqueTextField;

import org.openconcerto.sql.sqlobject.SQLRequestComboBox;

import org.openconcerto.sql.view.EditFrame;

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

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

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.ui.group.Group;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.text.SimpleDocumentListener;

import java.awt.Component;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import java.math.BigDecimal;

import java.sql.SQLException;

import java.util.Date;

import java.util.HashSet;

import java.util.Set;

import javax.swing.JCheckBox;

import javax.swing.JComponent;

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.TableModelEvent;

import javax.swing.event.TableModelListener;

public class VenteFactureSituationSQLComponent extends TransfertGroupSQLComponent {

    public static final String ID = "sales.invoice.partial";

    private PanelOOSQLComponent panelOO;

    public VenteFactureSituationSQLComponent(SQLElement element) {

        super(element, (Group) GlobalMapper.getInstance().get(ID));

    }

    public VenteFactureSituationSQLComponent(SQLElement element, Group p) {

        super(element, p);

    }

    @Override

    protected Set<String> createRequiredNames() {

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

        s.add("ID_CLIENT");

        s.add("ID_COMMERCIAL");

        s.add("NUMERO");

        s.add("DATE");

        s.add("MONTANT_FACTURABLE");

        s.add("ID_MODE_REGLEMENT");

        return s;

    }

    @Override

    protected RowValuesTable getRowValuesTable() {

        return ((AbstractArticleItemTable) getEditor("sales.invoice.partial.items.list")).getRowValuesTable();

    }

    JCheckBox box = new JCheckBox("partial");

    @Override

    public void select(SQLRowAccessor r) {

        super.select(r);

        final DeviseField totalRemise = (DeviseField) getEditor("REMISE_HT");

        totalRemise.setEditable(false);

        totalRemise.setEnabled(false);

    }

    @Override

    protected void addViews() {

        super.addViews();

        box.setSelected(true);

        this.addView(box, "PARTIAL", REQ);

        final DeviseField totalHT = (DeviseField) getEditor("T_HT");

        final DeviseField totalService = (DeviseField) getEditor("T_SERVICE");

        final DeviseField totalSupply = (DeviseField) getEditor("T_HA");

        final DeviseField totalDevise = (DeviseField) getEditor("T_DEVISE");

        final JTextField totalWeight = (JTextField) getEditor("T_POIDS");

        final DeviseField totalTTC = (DeviseField) getEditor("T_TTC");

        final DeviseField totalTVA = (DeviseField) getEditor("T_TVA");

        final DeviseField totalEco = (DeviseField) getEditor("T_ECO_CONTRIBUTION");

        final DeviseField totalRemise = (DeviseField) getEditor("REMISE_HT");

        totalRemise.setEditable(false);

        totalRemise.setEnabled(false);

        final DeviseField totalPORT = (DeviseField) getEditor("PORT_HT");

        this.addView(totalPORT, "PORT_HT");

        this.addView(totalTVA, "T_TVA");

        this.addView(totalTTC, "T_TTC");

        this.addView(totalEco, "T_ECO_CONTRIBUTION");

        this.addView(totalWeight, "T_POIDS");

        this.addView(totalDevise, "T_DEVISE");

        this.addView(totalSupply, "T_HA");

        this.addView(totalService, "T_SERVICE");

        this.addView(totalHT, "T_HT");

        final DeviseField fieldNet = new DeviseField();

        this.addView(fieldNet, "NET_A_PAYER");

        totalTTC.getDocument().addDocumentListener(new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                fieldNet.setText(totalTTC.getText());

            }

        });

        final SQLRequestComboBox sqlRequestComboBoxAdr = (SQLRequestComboBox) getEditor("ID_ADRESSE");

        final SQLRequestComboBox sqlRequestComboBoxAdrL = (SQLRequestComboBox) getEditor("ID_ADRESSE_LIVRAISON");

        final SQLRequestComboBox sqlRequestComboBox = (SQLRequestComboBox) getEditor("sales.invoice.customer");

        final FactureSituationItemTable table = ((FactureSituationItemTable) getEditor("sales.invoice.partial.items.list"));

        final TotalPanel total = ((TotalPanel) getEditor("sales.invoice.partial.total.amount"));

        sqlRequestComboBox.addModelListener("wantedID", new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                int wantedID = sqlRequestComboBox.getWantedID();

                if (wantedID != SQLRow.NONEXISTANT_ID && wantedID >= SQLRow.MIN_VALID_ID) {

                    sqlRequestComboBoxAdr.getRequest().setWhere(new Where(getTable().getTable("ADRESSE").getField("ID_CLIENT"), "=", wantedID)

                            .and(new Where(getTable().getTable("ADRESSE").getField("TYPE"), "=", AdresseType.Invoice.getId())));

                    sqlRequestComboBoxAdrL.getRequest().setWhere(new Where(getTable().getTable("ADRESSE").getField("ID_CLIENT"), "=", wantedID)

                            .and(new Where(getTable().getTable("ADRESSE").getField("TYPE"), "=", AdresseType.Delivery.getId())));

                    SQLRow rowCli = getTable().getForeignTable("ID_CLIENT").getRow(wantedID);

                    if (rowCli.getObject("ID_CATEGORIE_COMPTABLE") != null && !rowCli.isForeignEmpty("ID_CATEGORIE_COMPTABLE")) {

                        total.setCategorieComptable(rowCli.getForeign("ID_CATEGORIE_COMPTABLE"));

                        table.setRowCatComptable(rowCli.getForeign("ID_CATEGORIE_COMPTABLE"));

                    } else {

                        total.setCategorieComptable(null);

                        table.setRowCatComptable(null);

                    }

                } else {

                    sqlRequestComboBoxAdr.getRequest().setWhere(Where.FALSE);

                    sqlRequestComboBoxAdrL.getRequest().setWhere(Where.FALSE);

                    total.setCategorieComptable(null);

                    table.setRowCatComptable(null);

                }

                SQLElement sqleltModeRegl = Configuration.getInstance().getDirectory().getElement("MODE_REGLEMENT");

                final SQLRow client = sqlRequestComboBox.getSelectedRow();

                if (client != null && !client.isUndefined()) {

                    int idModeRegl = client.getInt("ID_MODE_REGLEMENT");

                    if (idModeRegl > 1) {

                        SQLRow rowModeRegl = sqleltModeRegl.getTable().getRow(idModeRegl);

                        SQLRowValues rowValsModeRegl = rowModeRegl.createUpdateRow();

                        rowValsModeRegl.clearPrimaryKeys();

                        ((ElementSQLObject) getEditor("ID_MODE_REGLEMENT")).setValue(rowValsModeRegl);

                    }

                }

            }

        });

        sqlRequestComboBox.setEnabled(false);

        final AcompteField acompteField = ((AcompteField) getEditor("sales.invoice.partial.amount"));

        listenerAcompteField = new SimpleDocumentListener() {

            @Override

            public void update(DocumentEvent e) {

                Acompte a = acompteField.getValue();

                table.calculPourcentage(a, TypeCalcul.CALCUL_FACTURABLE);

            }

        };

        acompteField.getDocument().addDocumentListener(listenerAcompteField);

        listenerTable = new TableModelListener() {

            @Override

            public void tableChanged(TableModelEvent e) {

                acompteField.getDocument().removeDocumentListener(listenerAcompteField);

                if (e.getColumn() == table.getModel().getColumnForField("POURCENT_FACTURABLE")) {

                    Acompte a = new Acompte(null, table.getTotalHT(TypeCalcul.CALCUL_MONTANT_TOTAL));

                    acompteField.setValue(a);

                }

                acompteField.getDocument().addDocumentListener(listenerAcompteField);

            }

        };

        table.getRowValuesTable().getModel().addTableModelListener(listenerTable);

        total.addValueListener(new PropertyChangeListener() {

            @Override

            public void propertyChange(PropertyChangeEvent evt) {

                acompteField.setTotal(new BigDecimal(total.getTotalHT()).movePointLeft(2));

            }

        });

    }

    private SimpleDocumentListener listenerAcompteField;

    private TableModelListener listenerTable;

    @Override

    public JComponent getLabel(String id) {

        if (id.equals("sales.invoice.partial.amount")) {

            final JLabel jLabel = new JLabel("Montant HT (ou %) à facturer");

            jLabel.setHorizontalAlignment(SwingConstants.RIGHT);

            return jLabel;

        } else if (id.equals("panel.oo")) {

            return new JLabel();

        } else if (id.equals("sales.invoice.partial.total.amount")) {

            return new JLabel();

        } else {

            return super.getLabel(id);

        }

    }

    JUniqueTextField numberField;

    @Override

    public JComponent createEditor(String id) {

        if (id.equals("sales.invoice.number")) {

            this.numberField = new JUniqueTextField(20) {

                @Override

                public String getAutoRefreshNumber() {

                    if (getMode() == Mode.INSERTION) {

                        return NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), ((JDate) getEditor("DATE")).getDate());

                    } else {

                        return null;

                    }

                }

            };

            return this.numberField;

        } else if (id.equals("panel.oo")) {

            this.panelOO = new PanelOOSQLComponent(this);

            return this.panelOO;

        } else if (id.equals("INFOS")) {

            final ITextArea jTextArea = new ITextArea();

            jTextArea.setFont(new JLabel().getFont());

            return jTextArea;

        } else if (id.equals("sales.invoice.partial.items.list")) {

            return new FactureSituationItemTable();

        } else if (id.equals("DATE")) {

            return new JDate(true);

        } else if (id.equals("T_POIDS")) {

            return new JTextField();

        } else if (id.equals("sales.invoice.partial.total.amount")) {

            final AbstractArticleItemTable items = (AbstractArticleItemTable) getEditor("sales.invoice.partial.items.list");

            // Set only VAT Editable

            for (int i = 0; i < items.getRowValuesTable().getColumnModel().getColumnCount(false); i++) {

                final SQLTableElement sqlTableElementAt = items.getRowValuesTable().getRowValuesTableModel().getSQLTableElementAt(i);

                if (sqlTableElementAt.getField() != null && (sqlTableElementAt.getField().getName().equalsIgnoreCase("ID_STYLE")

                        || sqlTableElementAt.getField().getName().equalsIgnoreCase("POURCENT_FACTURABLE") || sqlTableElementAt.getField().getName().equalsIgnoreCase("ID_TAXE"))) {

                    sqlTableElementAt.setEditable(true);

                } else {

                    sqlTableElementAt.setEditable(false);

                }

            }

            final DeviseField totalHT = (DeviseField) getEditor("T_HT");

            final DeviseField totalEco = (DeviseField) getEditor("T_ECO_CONTRIBUTION");

            final DeviseField totalService = (DeviseField) getEditor("T_SERVICE");

            final DeviseField totalSupply = (DeviseField) getEditor("T_HA");

            final DeviseField totalDevise = (DeviseField) getEditor("T_DEVISE");

            final JTextField totalWeight = (JTextField) getEditor("T_POIDS");

            final DeviseField totalTTC = (DeviseField) getEditor("T_TTC");

            final DeviseField totalTVA = (DeviseField) getEditor("T_TVA");

            final DeviseField totalRemise = (DeviseField) getEditor("REMISE_HT");

            totalRemise.setEditable(false);

            totalRemise.setEnabled(false);

            final AcompteField acompte = (AcompteField) getEditor("sales.invoice.partial.amount");

            final DeviseField totalPORT = (DeviseField) getEditor("PORT_HT");

            final SQLRequestComboBox taxePort = (SQLRequestComboBox) getEditor("ID_TAXE_PORT");

            return new TotalPanel(items, totalEco, totalHT, totalTVA, totalTTC, totalPORT, totalRemise, totalService, totalSupply, totalDevise, totalWeight, null, taxePort, acompte);

        } else if (id.startsWith("T_")) {

            return new DeviseField();

        } else if (id.equals("REMISE_HT") || id.equals("PORT_HT")) {

            DeviseField fieldD = new DeviseField();

            fieldD.setEditable(false);

            fieldD.setEnabled(false);

            return fieldD;

        } else if (id.startsWith("ID_ADRESSE")) {

            ElementComboBox comboAdrF = new ElementComboBox();

            comboAdrF.setButtonsVisible(false);

            final SQLElement adrElement = getElement().getForeignElement("ID_ADRESSE");

            comboAdrF.init(adrElement, adrElement.getComboRequest(true));

            comboAdrF.getRequest().setWhere(Where.FALSE);

            return comboAdrF;

        } else if (id.equals("sales.invoice.partial.amount")) {

            return new AcompteField();

        }

        return super.createEditor(id);

    }

    private final SQLTable tableNum = getElement().getTable().getTable("NUMEROTATION_AUTO");

    @Override

    public int insert(SQLRow order) {

        int idSaisieVF = SQLRow.NONEXISTANT_ID;

        int attempt = 0;

        // on verifie qu'un devis du meme numero n'a pas été inséré entre temps

        if (!this.numberField.checkValidation(false)) {

            while (attempt < JUniqueTextField.RETRY_COUNT) {

                String num = NumerotationAutoSQLElement.getNextNumero(getElement().getClass(), ((JDate) getEditor("DATE")).getDate());

                this.numberField.setText(num);

                attempt++;

                if (this.numberField.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.numberField.getText();

        if (attempt == JUniqueTextField.RETRY_COUNT) {

            idSaisieVF = getSelectedID();

            ExceptionHandler.handle("Impossible d'ajouter, numéro de facture existant.");

            final Object root = SwingUtilities.getRoot(this);

            if (root instanceof EditFrame) {

                final EditFrame frame = (EditFrame) root;

                frame.getPanel().setAlwaysVisible(true);

            }

        } else {

            idSaisieVF = super.insert(order);

            SQLRow rowFacture = getTable().getRow(idSaisieVF);

            // incrémentation du numéro auto

            if (NumerotationAutoSQLElement.getNextNumero(SaisieVenteFactureSQLElement.class, rowFacture.getDate("DATE").getTime()).equalsIgnoreCase(this.numberField.getText().trim())) {

                SQLRowValues rowVals = new SQLRowValues(this.tableNum);

                String labelNumberFor = NumerotationAutoSQLElement.getLabelNumberFor(SaisieVenteFactureSQLElement.class);

                int val = this.tableNum.getRow(2).getInt(labelNumberFor);

                val++;

                rowVals.put(labelNumberFor, Integer.valueOf(val));

                try {

                    rowVals.update(2);

                } catch (SQLException e1) {

                    e1.printStackTrace();

                }

            }

            ((AbstractArticleItemTable) getEditor("sales.invoice.partial.items.list")).updateField("ID_SAISIE_VENTE_FACTURE", idSaisieVF);

            new GenerationMvtSaisieVenteFacture(idSaisieVF);

            try {

                VenteFactureXmlSheet sheet = new VenteFactureXmlSheet(rowFacture);

                sheet.createDocument();

                sheet.showPrintAndExport(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true);

            } catch (Exception e) {

                ExceptionHandler.handle("Une erreur est survenue lors de la création du document.", e);

            }

            if (attempt > 0) {

                SwingUtilities.invokeLater(new Runnable() {

                    public void run() {

                        JOptionPane.showMessageDialog(null, "Le numéro a été actualisé en " + num);

                    }

                });

            }

        }

        return idSaisieVF;

    }

    @Override

    public void update() {

        int id = getSelectedID();

        super.update();

        final SQLRow rowFacture = getTable().getRow(id);

        ((AbstractArticleItemTable) getEditor("sales.invoice.partial.items.list")).updateField("ID_SAISIE_VENTE_FACTURE", id);

        int idMvt = rowFacture.getInt("ID_MOUVEMENT");

        // on supprime tout ce qui est lié à la facture

        System.err.println("Archivage des fils");

        EcritureSQLElement eltEcr = (EcritureSQLElement) getDirectory().getElement("ECRITURE");

        eltEcr.archiveMouvementProfondeur(idMvt, false);

        new GenerationMvtSaisieVenteFacture(id);

        try {

            VenteFactureXmlSheet sheet = new VenteFactureXmlSheet(rowFacture);

            sheet.createDocument();

            sheet.showPrintAndExport(this.panelOO.isVisualisationSelected(), this.panelOO.isImpressionSelected(), true);

        } catch (Exception e) {

            ExceptionHandler.handle("Une erreur est survenue lors de la création du document.", e);

        }

    }

    @Override

    protected SQLRowValues createDefaults() {

        SQLRowValues rowVals = new SQLRowValues(getTable());

        rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(SaisieVenteFactureSQLElement.class, new Date()));

        rowVals.put("PARTIAL", Boolean.TRUE);

        return rowVals;

    }

    @Override

    public Component addView(JComponent comp, String id) {

        if (id.equals("sales.invoice.partial.amount")) {

            return super.addView(new AcompteRowItemView((AcompteField) comp), "MONTANT_FACTURABLE,POURCENT_FACTURABLE", REQ);

        } else {

            return super.addView(comp, id);

        }

    }

}