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.customerrelationship.customer.element;

import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;
import org.openconcerto.erp.core.common.ui.DeviseField;
import org.openconcerto.erp.generationDoc.gestcomm.RelanceSheet;
import org.openconcerto.erp.preferences.PrinterNXProps;
import org.openconcerto.sql.element.BaseSQLComponent;
import org.openconcerto.sql.element.SQLComponent;
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.SQLTable;
import org.openconcerto.sql.sqlobject.ElementComboBox;
import org.openconcerto.sql.sqlobject.JUniqueTextField;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.ui.DefaultGridBagConstraints;
import org.openconcerto.ui.JDate;
import org.openconcerto.ui.component.ITextArea;
import org.openconcerto.ui.component.InteractionMode;
import org.openconcerto.utils.ExceptionHandler;

import java.awt.GridBagConstraints;
import java.awt.GridBagLayout;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;

import javax.swing.JCheckBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JSeparator;
import javax.swing.SwingUtilities;

public class RelanceSQLElement extends ComptaSQLConfElement {

    public RelanceSQLElement() {
        super("RELANCE", "une relance client", "relances clients");
    }

    protected List<String> getListFields() {
        final List<String> l = new ArrayList<String>();
        l.add("NUMERO");
        l.add("ID_CLIENT");
        l.add("ID_SAISIE_VENTE_FACTURE");
        l.add("DATE");
        l.add("ID_TYPE_LETTRE_RELANCE");
        l.add("MONTANT");
        l.add("INFOS");
        return l;
    }

    protected List<String> getComboFields() {
        final List<String> l = new ArrayList<String>();
        l.add("NUMERO");
        return l;
    }

    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.SQLElement#getComponent()
     */
    public SQLComponent createComponent() {
        return new BaseSQLComponent(this) {

            ElementComboBox comboFacture = new ElementComboBox();
            ElementComboBox comboClient = new ElementComboBox();
            ElementComboBox comboTypeLettre;
            JUniqueTextField textNumero = new JUniqueTextField();
            JCheckBox checkImpression = new JCheckBox("Impression");
            JCheckBox checkVisu = new JCheckBox("Visualisation");

            public void addViews() {

                this.setLayout(new GridBagLayout());
                final GridBagConstraints c = new DefaultGridBagConstraints();

                // Type lettre
                JLabel labelTypeLettre = new JLabel(getLabelFor("ID_TYPE_LETTRE_RELANCE"));
                labelTypeLettre.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelTypeLettre, c);

                c.gridx++;
                // SQLElement typeLettreElt =
                // Configuration.getInstance().getDirectory().getElement("TYPE_LETTRE_RELANCE");
                this.comboTypeLettre = new ElementComboBox(false);

                this.add(this.comboTypeLettre, c);

                // Date
                c.gridx++;
                JLabel labelDate = new JLabel(getLabelFor("DATE"));
                labelDate.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelDate, c);

                JDate date = new JDate(true);
                c.gridx++;
                this.add(date, c);

                // Numero
                c.gridx = 0;
                c.gridy++;
                JLabel labelNumero = new JLabel(getLabelFor("NUMERO"));
                labelNumero.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelNumero, c);

                c.gridx++;
                this.add(this.textNumero, c);

                // Client
                c.gridy++;
                c.gridx = 0;

                JLabel labelClient = new JLabel(getLabelFor("ID_CLIENT"));
                labelClient.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelClient, c);
                c.gridx++;
                c.gridwidth = GridBagConstraints.REMAINDER;
                this.add(this.comboClient, c);

                // Facture
                c.gridy++;
                c.gridx = 0;
                c.gridwidth = 1;
                JLabel labelFacture = new JLabel(getLabelFor("ID_SAISIE_VENTE_FACTURE"));
                labelFacture.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelFacture, c);
                c.gridx++;
                // c.gridwidth = GridBagConstraints.REMAINDER;
                this.add(this.comboFacture, c);

                // Montant
                c.gridx++;
                JLabel labelMontant = new JLabel(getLabelFor("MONTANT"));
                labelMontant.setHorizontalAlignment(JLabel.RIGHT);
                this.add(labelMontant, c);

                c.gridx++;
                DeviseField textMontant = new DeviseField();
                this.add(textMontant, c);

                // Commentaires
                c.gridx = 0;
                c.gridy++;
                this.add(new JLabel(getLabelFor("INFOS")), c);

                c.gridx++;
                c.gridwidth = GridBagConstraints.REMAINDER;
                c.fill = GridBagConstraints.HORIZONTAL;
                c.weightx = 1;
                this.add(new JSeparator(JSeparator.HORIZONTAL), c);

                c.gridx = 0;
                c.gridy++;
                c.weighty = 1;
                c.fill = GridBagConstraints.BOTH;
                ITextArea textInfos = new ITextArea();
                this.add(textInfos, c);

                JPanel panelCheck = new JPanel();
                panelCheck.setBorder(null);
                panelCheck.add(this.checkVisu);
                panelCheck.add(this.checkImpression);
                c.fill = GridBagConstraints.NONE;
                c.weighty = 0;
                c.gridy++;
                this.add(panelCheck, c);

                this.addRequiredSQLObject(textMontant, "MONTANT");
                this.addRequiredSQLObject(date, "DATE");
                this.addRequiredSQLObject(this.comboTypeLettre, "ID_TYPE_LETTRE_RELANCE");
                this.addRequiredSQLObject(this.comboClient, "ID_CLIENT");
                this.addRequiredSQLObject(this.comboFacture, "ID_SAISIE_VENTE_FACTURE");
                this.addSQLObject(textInfos, "INFOS");
                this.addRequiredSQLObject(this.textNumero, "NUMERO");
                this.comboTypeLettre.setButtonsVisible(false);

                this.textNumero.setText(NumerotationAutoSQLElement.getNextNumero(RelanceSQLElement.class));
                this.checkVisu.setSelected(true);
            }

            @Override
            public int insert(SQLRow order) {

                if (this.textNumero.checkValidation()) {
                    // incrémentation du numéro auto
                    if (NumerotationAutoSQLElement.getNextNumero(RelanceSQLElement.class).equalsIgnoreCase(this.textNumero.getText().trim())) {
                        SQLTable tableNum = getTable().getBase().getTable("NUMEROTATION_AUTO");
                        SQLRowValues rowVals = new SQLRowValues(tableNum);
                        int val = tableNum.getRow(2).getInt("RELANCE_START");
                        val++;
                        rowVals.put("RELANCE_START", Integer.valueOf(val));

                        try {
                            rowVals.update(2);
                        } catch (SQLException e) {

                            e.printStackTrace();
                        }
                    }

                    // insertion
                    int id = super.insert(order);

                    // génération du document
                    RelanceSheet s = new RelanceSheet(getTable().getRow(id));
                    String printer = PrinterNXProps.getInstance().getStringProperty("RelancePrinter");
                    s.generate(this.checkImpression.isSelected(), this.checkVisu.isSelected(), printer, true);

                    return id;
                } else {
                    ExceptionHandler.handle("Impossible d'ajouter, numéro de relance existant.");
                    Object root = SwingUtilities.getRoot(this);
                    if (root instanceof EditFrame) {
                        EditFrame frame = (EditFrame) root;
                        frame.getPanel().setAlwaysVisible(true);
                    }
                    return getSelectedID();
                }
            }

            @Override
            public void select(SQLRowAccessor r) {
                super.select(r);

                // numero de facture et client figé
                this.comboFacture.setInteractionMode(InteractionMode.DISABLED);
                this.comboClient.setInteractionMode(InteractionMode.DISABLED);
                this.fireValidChange();
            }

            @Override
            public void update() {
                if (!this.textNumero.checkValidation()) {
                    ExceptionHandler.handle("Impossible d'ajouter, numéro de relance existant.");
                    Object root = SwingUtilities.getRoot(this);
                    if (root instanceof EditFrame) {
                        EditFrame frame = (EditFrame) root;
                        frame.getPanel().setAlwaysVisible(true);
                    }
                    return;
                }

                super.update();

                // regénération du document
                RelanceSheet s = new RelanceSheet(getTable().getRow(getSelectedID()));
                String printer = PrinterNXProps.getInstance().getStringProperty("RelancePrinter");
                s.generate(this.checkImpression.isSelected(), this.checkVisu.isSelected(), printer);
            }

        };
    }

    @Override
    protected void archive(TreesOfSQLRows trees, boolean cutLinks) throws SQLException {

        for (SQLRow row : trees.getRows()) {
            if (row.getForeign("ID_ECHEANCE_CLIENT") != null && !row.isForeignEmpty("ID_ECHEANCE_CLIENT")) {
                SQLRow rowEch = row.getForeign("ID_ECHEANCE_CLIENT");
                int count = rowEch.getInt("NOMBRE_RELANCE");
                count = Math.max(0, count - 1);

                SQLRowValues rowValsUp = rowEch.createEmptyUpdateRow();
                rowValsUp.put("NOMBRE_RELANCE", count);
                rowValsUp.put("DATE_LAST_RELANCE", null);
                if (count > 0) {
                    List<SQLRow> rows = rowEch.getReferentRows(row.getTable());
                    Calendar cal = null;
                    for (SQLRow sqlRow : rows) {
                        if (sqlRow.getID() != row.getID() && sqlRow.getDate("DATE") != null && (cal == null || cal.before(sqlRow.getDate("DATE")))) {
                            cal = sqlRow.getDate("DATE");
                        }
                    }
                    if (cal != null) {
                        rowValsUp.put("DATE_LAST_RELANCE", cal.getTime());
                    }
                }
                rowValsUp.commit();
            }
        }
        super.archive(trees, cutLinks);
    }

    @Override
    protected String createCode() {
        return this.createCodeOfPackage() + ".chaseletter";
    }
}