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

package org.openconcerto.modules.project.element;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.HashSet;

import java.util.List;

import java.util.Set;

import javax.swing.SwingUtilities;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

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

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.UISQLComponent;

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.request.ComboSQLRequest;

import org.openconcerto.sql.sqlobject.ElementComboBox;

import org.openconcerto.sql.sqlobject.JUniqueTextField;

import org.openconcerto.sql.view.EditFrame;

import org.openconcerto.ui.JDate;

import org.openconcerto.ui.component.ITextArea;

import org.openconcerto.utils.ExceptionHandler;

import org.openconcerto.utils.ListMap;

import org.openconcerto.utils.cc.ITransformer;

public class ProjectSQLElement extends ComptaSQLConfElement {

    public ProjectSQLElement() {

        super("AFFAIRE", "une affaire", "affaires");

    }

    @Override

    protected List<String> getListFields() {

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

        l.add("ID_CLIENT");

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

            l.add("ID_SOCIETE_COMMON");

        }

        l.add("ID_TYPE_AFFAIRE");

        l.add("NUMERO");

        l.add("ID_ETAT_AFFAIRE");

        l.add("ID_COMMERCIAL");

        l.add("INFOS");

        return l;

    }

    protected void _initComboRequest(ComboSQLRequest req) {

        super._initComboRequest(req);

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

            final ComptaPropsConfiguration comptaPropsConfiguration = ((ComptaPropsConfiguration) Configuration.getInstance());

            final int socID = comptaPropsConfiguration.getSocieteID();

            req.setSelectTransf(new ITransformer<SQLSelect, SQLSelect>() {

                @Override

                public SQLSelect transformChecked(SQLSelect input) {

                    Where w = new Where(getTable().getField("ID_SOCIETE_COMMON"), "=", (Object) null).or(new Where(getTable().getField("ID_SOCIETE_COMMON"), "=", 1))

                            .or(new Where(getTable().getField("ID_SOCIETE_COMMON"), "=", socID));

                    input.andWhere(w);

                    return input;

                }

            });

        }

    }

    @Override

    protected List<String> getComboFields() {

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

        l.add("NUMERO");

        l.add("ID_CLIENT");

        return l;

    }

    @Override

    public ListMap<String, String> getShowAs() {

        return ListMap.singleton(null, getComboFields());

    }

    @Override

    public Set<String> getInsertOnlyFields() {

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

        s.add("ID_DEVIS");

        return s;

    }

    @Override

    public SQLComponent createComponent() {

        return new UISQLComponent(this, 2) {

            final JUniqueTextField field = new JUniqueTextField();

            @Override

            protected void addViews() {

                this.addView(this.field, "NUMERO", "1");

                this.addView(new JDate(true), "DATE", "1");

                this.addView("ID_CLIENT", "1;" + REQ);

                this.addView("ID_COMMERCIAL", "1");

                this.addView("ID_DEVIS", "1");

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

                    this.addView("ID_SOCIETE_COMMON", "1");

                }

                this.addView("ID_TYPE_AFFAIRE", "1;left");

                final ElementComboBox boxEtatAffaire = new ElementComboBox();

                this.addView(boxEtatAffaire, "ID_ETAT_AFFAIRE", "1;left;" + REQ);

                this.addView(new ITextArea(), "INFOS", "2");

            }

            @Override

            public void select(SQLRowAccessor r) {

                super.select(r);

                if (r != null) {

                    this.field.setIdSelected(r.getID());

                }

            }

            @Override

            public void update() {

                if (!this.field.checkValidation()) {

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

                    Object root = SwingUtilities.getRoot(this);

                    if (root instanceof EditFrame) {

                        EditFrame frame = (EditFrame) root;

                        frame.getPanel().setAlwaysVisible(true);

                    }

                    return;

                }

                super.update();

            }

            @Override

            public int insert(SQLRow order) {

                int idCommande = getSelectedID();

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

                if (this.field.checkValidation()) {

                    idCommande = super.insert(order);

                    // incrémentation du numéro auto

                    if (NumerotationAutoSQLElement.getNextNumero(ProjectSQLElement.class).equalsIgnoreCase(this.field.getText().trim())) {

                        SQLTable tableNum = Configuration.getInstance().getRoot().findTable("NUMEROTATION_AUTO");

                        SQLRowValues rowVals = new SQLRowValues(tableNum);

                        int val = tableNum.getRow(2).getInt("AFFAIRE_START");

                        val++;

                        rowVals.put("AFFAIRE_START", new Integer(val));

                        try {

                            rowVals.update(2);

                        } catch (SQLException e) {

                            e.printStackTrace();

                        }

                    }

                } else {

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

                    Object root = SwingUtilities.getRoot(this);

                    if (root instanceof EditFrame) {

                        EditFrame frame = (EditFrame) root;

                        frame.getPanel().setAlwaysVisible(true);

                    }

                }

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

                SQLRow rowDevis = row.getForeign("ID_DEVIS");

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

                    SQLRowValues rowVals = rowDevis.asRowValues();

                    rowVals.put("ID_AFFAIRE", idCommande);

                    try {

                        rowVals.update();

                    } catch (SQLException exn) {

                        // TODO Bloc catch auto-généré

                        exn.printStackTrace();

                    }

                }

                return idCommande;

            }

            @Override

            protected SQLRowValues createDefaults() {

                SQLRowValues rowVals = new SQLRowValues(getTable());

                rowVals.put("NUMERO", NumerotationAutoSQLElement.getNextNumero(ProjectSQLElement.class));

                rowVals.put("ID_ETAT_AFFAIRE", ProjectStateSQLElement.EN_COURS);

                return rowVals;

            }

        };

    }

}