WebSVN - OpenConcerto - Diff - Rev 177 and 182 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/quote/element/DevisSQLElement.java


/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011-2019 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.quote.element;
 
import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.config.Gestion;
import org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent;
import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;
import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;
import org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent;
import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;
import org.openconcerto.erp.core.sales.quote.component.DevisSQLComponent;
import org.openconcerto.erp.core.sales.quote.report.DevisXmlSheet;
import org.openconcerto.erp.core.sales.quote.ui.QuoteEditGroup;
import org.openconcerto.erp.core.sales.quote.ui.QuoteSQLComponent;
import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;
import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;
import org.openconcerto.erp.model.MouseSheetXmlListeListener;
import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;
import org.openconcerto.sql.Configuration;
import org.openconcerto.sql.element.GlobalMapper;
import org.openconcerto.sql.element.SQLComponent;
import org.openconcerto.sql.element.SQLElement;
import org.openconcerto.sql.element.SQLElementLink.LinkType;
import org.openconcerto.sql.element.SQLElementLinksSetup;
import org.openconcerto.sql.model.FieldPath;
import org.openconcerto.sql.model.SQLField;
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.SQLRowValuesListFetcher;
import org.openconcerto.sql.model.SQLSelect;
import org.openconcerto.sql.model.SQLSelectJoin;
import org.openconcerto.sql.model.SQLTable;
import org.openconcerto.sql.model.Where;
import org.openconcerto.sql.model.graph.Path;
import org.openconcerto.sql.preferences.SQLPreferences;
import org.openconcerto.sql.request.ListSQLRequest;
import org.openconcerto.sql.ui.light.CustomRowEditor;
import org.openconcerto.sql.users.UserManager;
import org.openconcerto.sql.users.rights.UserRightsManager;
import org.openconcerto.sql.view.EditFrame;
import org.openconcerto.sql.view.EditPanel;
import org.openconcerto.sql.view.EditPanel.EditMode;
import org.openconcerto.sql.view.EditPanelListener;
import org.openconcerto.sql.view.list.BaseSQLTableModelColumn;
import org.openconcerto.sql.view.list.IListe;
import org.openconcerto.sql.view.list.IListeAction.IListeEvent;
import org.openconcerto.sql.view.list.RowAction;
import org.openconcerto.sql.view.list.RowAction.PredicateRowAction;
import org.openconcerto.sql.view.list.SQLTableModelSource;
import org.openconcerto.ui.light.ActivationOnSelectionControler;
import org.openconcerto.ui.light.ColumnSpec;
import org.openconcerto.ui.light.ColumnsSpec;
import org.openconcerto.ui.light.LightController;
import org.openconcerto.ui.light.LightUIButtonUnmanaged;
import org.openconcerto.ui.light.LightUIComboBox;
import org.openconcerto.ui.light.LightUIElement;
import org.openconcerto.ui.light.LightUILine;
import org.openconcerto.ui.light.LightUIPanel;
import org.openconcerto.ui.light.LightUITable;
import org.openconcerto.ui.light.LightUITextField;
import org.openconcerto.ui.light.Row;
import org.openconcerto.ui.light.RowSelectionSpec;
import org.openconcerto.ui.light.TableContent;
import org.openconcerto.ui.light.TableSpec;
import org.openconcerto.ui.table.TimestampTableCellRenderer;
import org.openconcerto.utils.CollectionUtils;
import org.openconcerto.utils.DecimalUtils;
import org.openconcerto.utils.ExceptionHandler;
import org.openconcerto.utils.FileUtils;
import org.openconcerto.utils.ListMap;
import org.openconcerto.utils.cc.ITransformer;
import org.openconcerto.utils.ui.StringWithId;
 
import java.awt.Desktop;
import java.awt.event.ActionEvent;
import java.io.File;
import java.io.IOException;
import java.math.BigDecimal;
import java.net.URI;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Collections;
import java.util.Date;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
 
import javax.swing.AbstractAction;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.SwingWorker;
 
import org.jdom2.Document;
import org.jdom2.Element;
import org.jdom2.input.DOMBuilder;
 
public class DevisSQLElement extends ComptaSQLConfElement {
 
    public static final String TABLENAME = "DEVIS";
    public static final String FACTURE_TAG_RIGHT = "TAG_FACTURE_DEVIS";
 
    public static enum Month {
 
        JANVIER("01", "Janvier"), FEVRIER("02", "Février"), MARS("03", "Mars"), AVRIL("04", "Avril"), MAI("05", "Mai"), JUIN("06", "Juin"), JUILLET("07", "Juillet"), AOUT("08",
                "Août"), SEPTEMBRE("09", "Septembre"), OCTOBRE("10", "Octobre"), NOVEMBRE("11", "Novembre"), DECEMBRE("12", "Décembre");
 
        private String number;
        private String name;
 
        Month(String number, String name) {
            this.number = number;
            this.name = name;
        }
 
        public String getName() {
            return this.name;
        }
 
        public String getNumber() {
            return this.number;
        }
 
        public String getPath() {
            return this.getNumber() + "-" + this.getName();
        }
    }
 
    public DevisSQLElement() {
        super(TABLENAME);
 
        getRowActions().addAll(getDevisRowActions());
        final QuoteEditGroup group = new QuoteEditGroup();
        GlobalMapper.getInstance().map(QuoteSQLComponent.ID, group);
        setDefaultGroup(group);
 
    }
 
    @Override
    public Set<String> getReadOnlyFields() {
        Set<String> s = new HashSet<>();
        s.add("T_ACOMPTE");
        return s;
    }
 
    private List<RowAction> getDevisRowActions() {
 
        List<RowAction> rowsActions = new ArrayList<>();
 
        // Transfert vers facture
        RowAction factureAction = getDevis2FactureAction();
 
        rowsActions.add(factureAction);
 
        SQLPreferences prefs = new SQLPreferences(getTable().getDBRoot());
        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ACOMPTE_DEVIS, false)) {
            PredicateRowAction actionClient = new PredicateRowAction(new AbstractAction("Saisir un acompte") {
                EditFrame edit;
 
                public void actionPerformed(ActionEvent e) {
                    final SQLElement eltEncaisser = Configuration.getInstance().getDirectory()
                            .getElement(((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("ENCAISSER_MONTANT"));
 
                    if (this.edit == null) {
                        this.edit = new EditFrame(eltEncaisser, EditMode.CREATION);
                    }
                    final SQLRowAccessor selRow = IListe.get(e).getSelectedRow();
                    SQLRowValues rowVals = new SQLRowValues(eltEncaisser.getTable());
                    rowVals.put("ACOMPTE", true);
                    rowVals.put("NOM", "Acompte devis " + selRow.getString("NUMERO"));
                    rowVals.put("ID_CLIENT", selRow.getForeignID("ID_CLIENT"));
                    rowVals.put("ID_DEVIS", selRow.getID());
                    SQLRowValues rowValsElt = new SQLRowValues(eltEncaisser.getTable().getTable("ENCAISSER_MONTANT_ELEMENT"));
                    rowValsElt.put("MONTANT_A_REGLER", selRow.getLong("T_TTC"));
                    rowValsElt.put("DATE", selRow.getObject("DATE"));
                    rowValsElt.put("ID_ENCAISSER_MONTANT", rowVals);
                    this.edit.getSQLComponent().select(rowVals);
                    this.edit.setVisible(true);
                    this.edit.addEditPanelListener(new EditPanelListener() {
 
                        @Override
                        public void modified() {
                        }
 
                        @Override
                        public void inserted(int id) {
                            // Put id devis and refresh devis.t_acompte
                            SQLRow rowE = eltEncaisser.getTable().getRow(id);
                            String up = "UPDATE " + selRow.getTable().getSQLName().quote() + " set \"T_ACOMPTE\"=(SELECT COALESCE(SUM(\"MONTANT\"),0) from " + rowE.getTable().getSQLName().quote()
                                    + " where \"ARCHIVE\"=0 and \"ID_DEVIS\"=" + selRow.getID() + ") where \"ID_DEVIS\"=" + selRow.getID();
                            eltEncaisser.getTable().getDBSystemRoot().getDataSource().execute(up);
                        }
 
                        @Override
                        public void deleted() {
                        }
 
                        @Override
                        public void cancelled() {
                        }
                    });
                }
            }, false);
            actionClient.setPredicate(IListeEvent.getSingleSelectionPredicate());
            rowsActions.add(actionClient);
        }
 
        PredicateRowAction actionClient = new PredicateRowAction(new AbstractAction("Détails client") {
            EditFrame edit;
            private SQLElement eltClient = Configuration.getInstance().getDirectory().getElement(((ComptaPropsConfiguration) Configuration.getInstance()).getRootSociete().getTable("CLIENT"));
 
            public void actionPerformed(ActionEvent e) {
                if (this.edit == null) {
                    this.edit = new EditFrame(this.eltClient, EditMode.MODIFICATION);
                }
                this.edit.selectionId(IListe.get(e).getSelectedRow().getForeignID("ID_CLIENT"));
                this.edit.setVisible(true);
            }
        }, false);
        actionClient.setPredicate(IListeEvent.getSingleSelectionPredicate());
        rowsActions.add(actionClient);
 
 
        // Voir le document
        RowAction actionTransfertCmd = getDevis2CmdFournAction();
        rowsActions.add(actionTransfertCmd);
 
        // Transfert vers commande
        RowAction commandeAction = getDevis2CmdCliAction();
        rowsActions.add(commandeAction);
 
        RowAction blAction = getDevis2BlAction();
        rowsActions.add(blAction);
 
        RowAction accepteEtCmdAction = getAcceptAndCmdClientAction();
        rowsActions.add(accepteEtCmdAction);
 
        // Marqué accepté
        RowAction accepteAction = getAcceptAction();
 
        rowsActions.add(accepteAction);
 
        // Marqué accepté
        RowAction refuseAction = getRefuseAction();
 
        rowsActions.add(refuseAction);
 
        // // Dupliquer
        RowAction cloneAction = getCloneAction();
 
        rowsActions.add(cloneAction);
 
        MouseSheetXmlListeListener mouseSheetXmlListeListener = new MouseSheetXmlListeListener(this, DevisXmlSheet.class);
        mouseSheetXmlListeListener.setGenerateHeader(true);
        mouseSheetXmlListeListener.setShowHeader(true);
 
        rowsActions.addAll(mouseSheetXmlListeListener.getRowActions());
 
        return rowsActions;
    }
 
    public RowAction getDevis2BlAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
 
                final List<SQLRowValues> copySelectedRows = IListe.get(e).getSelectedRows();
                transfertDevis(copySelectedRows, "BON_DE_LIVRAISON");
            }
 
        }, true, "sales.quote.create.customer.delivery") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    if (selection.get(0).getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public static void davBrowse(String s) throws Exception {
        final boolean windows = System.getProperty("os.name").startsWith("Windows");
        if (windows) {
            Desktop.getDesktop().browse(new URI(s));
        } else {
            String[] cmdarray = new String[] { "xdg-open", s };
            final int res = Runtime.getRuntime().exec(cmdarray).waitFor();
            if (res != 0)
                throw new IOException("error (" + res + ") executing " + Arrays.asList(cmdarray));
        }
    }
 
    public RowAction getCloneAction() {
        return new RowAction(new AbstractAction() {
 
            public void actionPerformed(ActionEvent e) {
                SQLRowAccessor selectedRow = IListe.get(e).getSelectedRow();
 
                SQLElement eltFact = Configuration.getInstance().getDirectory().getElement("DEVIS");
                EditFrame editFrame = new EditFrame(eltFact, EditPanel.CREATION);
 
                ((DevisSQLComponent) editFrame.getSQLComponent()).loadDevisExistant(selectedRow.getID());
                editFrame.setVisible(true);
            }
        }, true, "sales.quote.clone") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                return (selection != null && selection.size() == 1);
            }
        };
    }
 
    public RowAction getRefuseAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
                SQLRowValues rowVals = IListe.get(e).getSelectedRow().asRow().createEmptyUpdateRow();
                rowVals.put("ID_ETAT_DEVIS", EtatDevisSQLElement.REFUSE);
                try {
                    rowVals.update();
                } catch (SQLException e1) {
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
            }
        }, false, "sales.quote.refuse") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    if (selection.get(0).getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.EN_ATTENTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public RowAction getAcceptAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
                SQLRow selectedRow = IListe.get(e).getSelectedRow().asRow();
                SQLRowValues rowVals = selectedRow.createEmptyUpdateRow();
                rowVals.put("ID_ETAT_DEVIS", EtatDevisSQLElement.ACCEPTE);
                try {
                    rowVals.update();
                } catch (SQLException e1) {
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
            }
        }, false, "sales.quote.accept") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    final int int1 = selection.get(0).getForeignID("ID_ETAT_DEVIS");
                    if (int1 != EtatDevisSQLElement.REFUSE && int1 != EtatDevisSQLElement.ACCEPTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public RowAction getDevis2FactureAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
                TransfertBaseSQLComponent.openTransfertFrame(IListe.get(e).getSelectedRows(), "SAISIE_VENTE_FACTURE");
 
            }
        }, true, "sales.quote.create.invoice") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                boolean b = selection.size() > 0;
                for (SQLRowAccessor sqlRowAccessor : selection) {
                    b &= sqlRowAccessor.getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE;
                }
 
                return b;
            }
        };
    }
 
    public RowAction getDevis2CmdFournAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
                final SQLRow selectedRow = IListe.get(e).fetchSelectedRow();
                ComptaPropsConfiguration.getInstanceCompta().getNonInteractiveSQLExecutor().execute(new Runnable() {
 
                    @Override
                    public void run() {
                        transfertCommande(selectedRow);
 
                    }
                });
 
            }
        }, false, "sales.quote.create.supplier.order") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    if (selection.get(0).getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public RowAction getDevis2CmdCliAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
 
                final List<SQLRowValues> copySelectedRows = IListe.get(e).getSelectedRows();
                transfertCommandeClient(copySelectedRows);
            }
 
        }, true, "sales.quote.create.customer.order") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    if (selection.get(0).getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.ACCEPTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public RowAction getAcceptAndCmdClientAction() {
        return new RowAction(new AbstractAction() {
            public void actionPerformed(ActionEvent e) {
                SQLRow selectedRow = IListe.get(e).fetchSelectedRow();
                SQLRowValues rowVals = selectedRow.createEmptyUpdateRow();
                rowVals.put("ID_ETAT_DEVIS", EtatDevisSQLElement.ACCEPTE);
                try {
                    rowVals.update();
                } catch (SQLException e1) {
                    ExceptionHandler.handle("Erreur la de la mise à jour de l'état du devis!", e1);
 
                }
                transfertCommandeClient(IListe.get(e).getSelectedRows());
            }
        }, false, "sales.quote.accept.create.customer.order") {
            @Override
            public boolean enabledFor(java.util.List<org.openconcerto.sql.model.SQLRowValues> selection) {
                if (selection != null && selection.size() == 1) {
                    if (selection.get(0).getForeignID("ID_ETAT_DEVIS") == EtatDevisSQLElement.EN_ATTENTE) {
                        return true;
                    }
                }
                return false;
            }
        };
    }
 
    public void transfertDevis(final List<SQLRowValues> copySelectedRows, final String destTable) {
        SwingWorker<Boolean, Object> worker = new SwingWorker<Boolean, Object>() {
            @Override
            protected Boolean doInBackground() throws Exception {
 
                final SQLTable tableTransfert = getTable().getTable("TR_DEVIS");
                SQLRowValues rowVals = new SQLRowValues(tableTransfert);
                rowVals.put("ID_DEVIS", new SQLRowValues(getTable()).put("NUMERO", null));
                rowVals.put("ID_" + destTable, null);
                rowVals.put("ID", null);
 
                final List<Number> lID = new ArrayList<>();
                for (SQLRowValues sqlRowValues : copySelectedRows) {
                    lID.add(sqlRowValues.getID());
                }
 
                SQLRowValuesListFetcher fetch = SQLRowValuesListFetcher.create(rowVals);
                fetch.setSelTransf(new ITransformer<SQLSelect, SQLSelect>() {
 
                    @Override
                    public SQLSelect transformChecked(SQLSelect input) {
                        Where w = new Where(tableTransfert.getField("ID_DEVIS"), lID);
                        w = w.and(new Where(tableTransfert.getField("ID_" + destTable), "IS NOT", (Object) null));
                        input.setWhere(w);
                        return input;
                    }
                });
 
                List<SQLRowValues> rows = fetch.fetch();
                if (rows != null && rows.size() > 0) {
                    String numero = "";
 
                    for (SQLRowValues sqlRow : rows) {
                        numero += sqlRow.getForeign("ID_DEVIS").getString("NUMERO") + " ,";
                    }
 
                    numero = numero.substring(0, numero.length() - 2);
                    String label = "Attention ";
                    if (rows.size() > 1) {
                        label += " les devis " + numero + " ont déjà été transféré!";
                    } else {
                        label += " le devis " + numero + " a déjà été transféré!";
                    }
                    label += "\n Voulez vous continuer?";
 
                    int ans = JOptionPane.showConfirmDialog(null, label, "Transfert devis", JOptionPane.YES_NO_OPTION);
                    if (ans == JOptionPane.NO_OPTION) {
                        return Boolean.FALSE;
                    }
 
                }
                return Boolean.TRUE;
 
            }
 
            @Override
            protected void done() {
 
                try {
                    Boolean b = get();
                    if (b != null && b) {
                        EditFrame frame = TransfertBaseSQLComponent.openTransfertFrame(copySelectedRows, destTable);
                        if (destTable.equalsIgnoreCase("BON_DE_LIVRAISON")) {
                            BonDeLivraisonSQLComponent comp = (BonDeLivraisonSQLComponent) frame.getSQLComponent();
                            final SQLTable tableElt = comp.getElement().getTable().getTable("BON_DE_LIVRAISON_ELEMENT");
                            SQLRowValues rowVals = new SQLRowValues(tableElt);
                            rowVals.put("QTE_UNITAIRE", null);
                            rowVals.put("QTE", null);
                            rowVals.put("QTE_LIVREE", null);
                            rowVals.put("ID_ARTICLE", null);
                            rowVals.put("PV_HT", null);
                            rowVals.put("ID_DEVIS_ELEMENT", null);
 
                            SQLRowValuesListFetcher fetcher = SQLRowValuesListFetcher.create(rowVals);
                            fetcher.setSelTransf(new ITransformer<SQLSelect, SQLSelect>() {
 
                                @Override
                                public SQLSelect transformChecked(SQLSelect input) {
                                    List<Integer> ids = new ArrayList<>(copySelectedRows.size());
                                    for (SQLRowValues sqlRowValues : copySelectedRows) {
                                        ids.add(sqlRowValues.getID());
                                    }
                                    SQLSelectJoin joinBR = input.addJoin("RIGHT", tableElt.getTable("BON_DE_LIVRAISON_ELEMENT").getField("ID_BON_DE_LIVRAISON"));
                                    SQLSelectJoin joinTR = input.addBackwardJoin("RIGHT", tableElt.getTable("TR_DEVIS").getField("ID_BON_DE_LIVRAISON"), joinBR.getJoinedTable().getAlias());
                                    joinTR.setWhere(new Where(joinTR.getJoinedTable().getField("ID_DEVIS"), ids));
                                    System.err.println(input.asString());
                                    return input;
                                }
                            });
                            comp.loadQuantity(fetcher.fetch(), "DEVIS_ELEMENT");
                        }
                    }
                } catch (Exception e) {
                    ExceptionHandler.handle("Erreur lors du transfert des devis!", e);
                }
                super.done();
            }
        };
        worker.execute();
    }
 
    public void transfertCommandeClient(final List<SQLRowValues> copySelectedRows) {
        transfertDevis(copySelectedRows, "COMMANDE_CLIENT");
    }
 
    @Override
    protected List<String> getComboFields() {
        List<String> l = new ArrayList<>(1);
        l.add("NUMERO");
        return l;
    }
 
    private void transfertCommande(final SQLRow row) {
        ComptaPropsConfiguration.getInstanceCompta().getNonInteractiveSQLExecutor().execute(new Runnable() {
 
            @Override
            public void run() {
                DevisItemSQLElement elt = (DevisItemSQLElement) Configuration.getInstance().getDirectory().getElement("DEVIS_ELEMENT");
                SQLTable tableCmdElt = Configuration.getInstance().getDirectory().getElement("COMMANDE_ELEMENT").getTable();
                SQLElement eltArticle = Configuration.getInstance().getDirectory().getElement("ARTICLE");
                List<SQLRow> rows = row.getReferentRows(elt.getTable());
                final ListMap<SQLRow, SQLRowValues> map = new ListMap<>();
                SQLRow rowDeviseF = null;
                for (SQLRow sqlRow : rows) {
                    // on récupére l'article qui lui correspond
                    SQLRowValues rowArticle = new SQLRowValues(eltArticle.getTable());
                    for (SQLField field : eltArticle.getTable().getFields()) {
                        if (sqlRow.getTable().getFieldsName().contains(field.getName())) {
                            rowArticle.put(field.getName(), sqlRow.getObject(field.getName()));
                        }
                    }
 
                    // rowArticle.loadAllSafe(rowEltFact);
                    int idArticle = ReferenceArticleSQLElement.getIdForCNM(rowArticle, true);
                    SQLRow rowArticleFind = eltArticle.getTable().getRow(idArticle);
                    if (rowArticleFind != null) {
                        SQLInjector inj = SQLInjector.getInjector(rowArticle.getTable(), tableCmdElt);
                        SQLRowValues rowValsElt = new SQLRowValues(inj.createRowValuesFrom(rowArticleFind));
                        rowValsElt.put("ID_STYLE", sqlRow.getObject("ID_STYLE"));
                        rowValsElt.put("QTE", sqlRow.getObject("QTE"));
                        rowValsElt.put("T_POIDS", rowValsElt.getLong("POIDS") * rowValsElt.getInt("QTE"));
                        rowValsElt.put("T_PA_HT", ((BigDecimal) rowValsElt.getObject("PA_HT")).multiply(new BigDecimal(rowValsElt.getInt("QTE"), DecimalUtils.HIGH_PRECISION)));
                        rowValsElt.put("T_PA_TTC", ((BigDecimal) rowValsElt.getObject("T_PA_HT")).multiply(BigDecimal.valueOf(rowValsElt.getForeign("ID_TAXE").getFloat("TAUX") / 100.0 + 1.0),
                                DecimalUtils.HIGH_PRECISION));
 
                        // gestion de la devise
                        rowDeviseF = sqlRow.getForeignRow("ID_DEVISE");
                        SQLRow rowDeviseHA = rowArticleFind.getForeignRow("ID_DEVISE_HA");
                        BigDecimal qte = new BigDecimal(rowValsElt.getInt("QTE"));
                        if (rowDeviseF != null && !rowDeviseF.isUndefined()) {
                            if (rowDeviseF.getID() == rowDeviseHA.getID()) {
                                rowValsElt.put("PA_DEVISE", rowArticleFind.getObject("PA_DEVISE"));
                                rowValsElt.put("PA_DEVISE_T", ((BigDecimal) rowArticleFind.getObject("PA_DEVISE")).multiply(qte, DecimalUtils.HIGH_PRECISION));
                                rowValsElt.put("ID_DEVISE", rowDeviseF.getID());
                            } else {
                                BigDecimal taux = (BigDecimal) rowDeviseF.getObject("TAUX");
                                rowValsElt.put("PA_DEVISE", taux.multiply((BigDecimal) rowValsElt.getObject("PA_HT")));
                                rowValsElt.put("PA_DEVISE_T", ((BigDecimal) rowValsElt.getObject("PA_DEVISE")).multiply(qte, DecimalUtils.HIGH_PRECISION));
                                rowValsElt.put("ID_DEVISE", rowDeviseF.getID());
                            }
                        }
 
                        map.add(rowArticleFind.getForeignRow("ID_FOURNISSEUR"), rowValsElt);
                    }
                }
                MouvementStockSQLElement.createCommandeF(map, rowDeviseF);
            }
        });
 
    }
 
    protected List<String> getListFields() {
        List<String> l = new ArrayList<>();
        l.add("NUMERO");
        l.add("DATE");
        l.add("ID_CLIENT");
        l.add("OBJET");
        l.add("ID_COMMERCIAL");
        if (UserRightsManager.getCurrentUserRights().haveRight(AbstractVenteArticleItemTable.SHOW_PRIX_ACHAT_CODE)) {
            l.add("T_HA");
        }
        l.add("T_HT");
        l.add("T_TTC");
        if (getTable().contains("TRANSFORMATION")) {
            l.add("TRANSFORMATION");
        }
        SQLPreferences prefs = SQLPreferences.getMemCached(getTable().getDBRoot());
        if (prefs.getBoolean(GestionCommercialeGlobalPreferencePanel.ACOMPTE_DEVIS, false)) {
            l.add("T_ACOMPTE");
        }
        l.add("INFOS");
        if (getTable().contains("DUNNING_DATE")) {
            l.add("DUNNING_DATE");
        }
        return l;
    }
 
    @Override
    protected synchronized void _initTableSource(final SQLTableModelSource table) {
        super._initTableSource(table);
 
            final BaseSQLTableModelColumn colAdrLiv = new BaseSQLTableModelColumn("Adresse de livraison", String.class) {
 
                @Override
                protected Object show_(SQLRowAccessor r) {
 
                    SQLRowAccessor rowAd = null;
                    if (!r.isForeignEmpty("ID_ADRESSE_LIVRAISON")) {
                        rowAd = r.getForeign("ID_ADRESSE_LIVRAISON");
                    } else if (!r.isForeignEmpty("ID_CLIENT")) {
                        if (r.getForeign("ID_CLIENT").getObject("ID_ADRESSE_L") != null && !r.getForeign("ID_CLIENT").isForeignEmpty("ID_ADRESSE_L")) {
 
                            rowAd = r.getForeign("ID_CLIENT").getForeign("ID_ADRESSE_L");
                        } else {
                            rowAd = r.getForeign("ID_CLIENT").getForeign("ID_ADRESSE");
                        }
                    }
 
                    String lib = rowAd == null ? "" : rowAd.getString("LIBELLE") + " " + rowAd.getString("VILLE");
 
                    return lib;
                }
 
                @Override
                public Set<FieldPath> getPaths() {
                    SQLTable devisTable = getTable();
                    Path p = new Path(devisTable);
                    p = p.add(devisTable.getField("ID_CLIENT"));
                    p = p.add(p.getLast().getField("ID_ADRESSE_L"));
 
                    Path p2 = new Path(devisTable);
                    p2 = p2.add(devisTable.getField("ID_CLIENT"));
                    p2 = p2.add(p2.getLast().getField("ID_ADRESSE"));
 
                    Path p3 = new Path(devisTable);
                    p3 = p3.add(devisTable.getField("ID_ADRESSE_LIVRAISON"));
 
                    return CollectionUtils.createSet(new FieldPath(p, "LIBELLE"), new FieldPath(p, "VILLE"), new FieldPath(p2, "LIBELLE"), new FieldPath(p2, "VILLE"), new FieldPath(p3, "LIBELLE"),
                            new FieldPath(p3, "VILLE"));
                }
            };
            table.getColumns().add(3, colAdrLiv);
    }
 
    @Override
    public ListMap<String, String> getShowAs() {
        return ListMap.singleton(null, "NUMERO");
    }
 
    @Override
    protected void _initListRequest(ListSQLRequest req) {
        super._initListRequest(req);
        req.addToGraphToFetch("ID_ETAT_DEVIS");
    }
 
    @Override
    protected void setupLinks(SQLElementLinksSetup links) {
        super.setupLinks(links);
        if (getTable().contains("ID_ADRESSE")) {
            links.get("ID_ADRESSE").setType(LinkType.ASSOCIATION);
        }
        if (getTable().contains("ID_ADRESSE_LIVRAISON")) {
            links.get("ID_ADRESSE_LIVRAISON").setType(LinkType.ASSOCIATION);
        }
    }
 
    /*
     * (non-Javadoc)
     * 
     * @see org.openconcerto.devis.SQLElement#getComponent()
     */
    public SQLComponent createComponent() {
        return new DevisSQLComponent(this);
    }
 
    /**
     * Transfert d'un devis en facture
     * 
     * @param devisID
     */
    public void transfertFacture(final int devisID) {
 
        SQLElement elt = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE");
        EditFrame editFactureFrame = new EditFrame(elt);
        editFactureFrame.setIconImage(new ImageIcon(Gestion.class.getResource("frameicon.png")).getImage());
 
        SaisieVenteFactureSQLComponent comp = (SaisieVenteFactureSQLComponent) editFactureFrame.getSQLComponent();
 
        comp.setDefaults();
        comp.loadDevis(devisID);
 
 
        editFactureFrame.pack();
        editFactureFrame.setState(JFrame.NORMAL);
        editFactureFrame.setVisible(true);
    }
 
    @Override
    public List<CustomRowEditor> getCustomRowEditors(Configuration configuration, String sessionToken) {
        List<CustomRowEditor> map = super.getCustomRowEditors(configuration, sessionToken);
        map.add(new CustomRowEditor("sales.quote.items.list") {
 
            @Override
            public LightUIElement createUIElement() {
                final ColumnSpec c1 = new ColumnSpec("sales.quote.item.style", StringWithId.class, "Style", new StringWithId(2, "Normal"), true, new LightUIComboBox("sales.quote.item.style"));
                final ColumnSpec c2 = new ColumnSpec("sales.quote.item.code", String.class, "Code", "", true, new LightUITextField("sales.quote.item.code"));
                final ColumnSpec c3 = new ColumnSpec("sales.quote.item.label", String.class, "Nom", "", true, new LightUITextField("sales.quote.item.name"));
                final ColumnSpec c4 = new ColumnSpec("sales.quote.item.description", String.class, "Descriptif", "", true, new LightUITextField("sales.quote.item.description"));
                final ColumnSpec c5 = new ColumnSpec("sales.quote.item.purchase.unit.price", BigDecimal.class, "P.U. Achat HT", new BigDecimal(0), true,
                        new LightUITextField("sales.quote.item.purchase.unit.price"));
                final ColumnSpec c6 = new ColumnSpec("sales.quote.item.sales.unit.price", BigDecimal.class, "P.U. Vente HT", new BigDecimal(0), true,
                        new LightUITextField("sales.quote.item.sales.unit.price"));
                final ColumnSpec c7 = new ColumnSpec("sales.quote.item.quantity", Integer.class, "Quantité", new BigDecimal(1), true, new LightUITextField("sales.quote.item.quantity"));
 
                final List<ColumnSpec> columnsSpec = new ArrayList<>(7);
                columnsSpec.add(c1);
                columnsSpec.add(c2);
                columnsSpec.add(c3);
                columnsSpec.add(c4);
                columnsSpec.add(c5);
                columnsSpec.add(c6);
                columnsSpec.add(c7);
                final List<String> possibleColumnIds = new ArrayList<>(columnsSpec.size());
                for (ColumnSpec c : columnsSpec) {
                    possibleColumnIds.add(c.getId());
                }
 
                final String lId = "sales.quote.items";
                final long userId = UserManager.getUserID();
                Document columnsPrefs = null;
                try {
                    final DOMBuilder in = new DOMBuilder();
                    final org.w3c.dom.Document w3cDoc = Configuration.getInstance().getXMLConf(userId, lId);
                    if (w3cDoc != null) {
                        columnsPrefs = in.build(w3cDoc);
                    }
                    if (columnsPrefs == null) {
                        throw new IllegalStateException("Columns Prefs is null");
                    }
                } catch (Exception ex) {
                    throw new IllegalArgumentException(
                            "DevisSQLElement getItemsCustomEditorProvider - Failed to get ColumnPrefs for descriptor " + lId + " and for user " + userId + "\n" + ex.getMessage());
                }
 
                final Element rootElement = columnsPrefs.getRootElement();
                if (!rootElement.getName().equals("list")) {
                    throw new IllegalArgumentException("invalid xml, roots node list expected but " + rootElement.getName() + " found");
                }
                final List<Element> xmlColumns = rootElement.getChildren();
                final int columnsCount = columnsSpec.size();
                if (xmlColumns.size() != columnsCount) {
                    throw new IllegalArgumentException("incorrect columns count in xml");
                }
 
                for (int i = 0; i < columnsCount; i++) {
                    final ColumnSpec columnSpec = columnsSpec.get(i);
                    final String columnId = columnSpec.getId();
                    boolean find = false;
 
                    for (int j = 0; j < columnsCount; j++) {
                        final Element xmlColumn = xmlColumns.get(j);
                        final String xmlColumnId = xmlColumn.getAttribute("id").getValue();
 
                        if (xmlColumnId.equals(columnId)) {
 
                            if (!xmlColumn.getName().equals("column")) {
                                throw new IllegalArgumentException("ColumnSpec setPrefs - Invalid xml, element node column expected but " + xmlColumn.getName() + " found");
                            }
                            if (xmlColumn.getAttribute("width") == null || xmlColumn.getAttribute("min-width") == null || xmlColumn.getAttribute("max-width") == null) {
                                throw new IllegalArgumentException("ColumnSpec setPrefs - Invalid column node for " + columnId + ", it must have attribute width, min-width, max-width");
                            }
 
                            final int width = Integer.parseInt(xmlColumn.getAttribute("width").getValue());
                            final int maxWidth = Integer.parseInt(xmlColumn.getAttribute("max-width").getValue());
                            final int minWidth = Integer.parseInt(xmlColumn.getAttribute("min-width").getValue());
 
                            columnSpec.setPrefs(width, maxWidth, minWidth);
                            if (i != j) {
                                final ColumnSpec swap = columnsSpec.get(i);
                                columnsSpec.set(i, columnsSpec.get(j));
                                columnsSpec.set(j, swap);
                            }
                            find = true;
                            break;
                        }
                    }
                    if (!find) {
                        throw new IllegalArgumentException("xml contain unknow column: " + columnId);
                    }
                }
                final ColumnsSpec cSpec = new ColumnsSpec(lId, columnsSpec, possibleColumnIds, null);
                cSpec.setAllowMove(true);
                cSpec.setAllowResize(true);
                final RowSelectionSpec selectionSpec = new RowSelectionSpec(getItemId());
                final TableSpec tSpec = new TableSpec(getItemId(), selectionSpec, cSpec);
                tSpec.setColumns(cSpec);
 
                String id = getItemId();
                final LightUITable eList = new LightUITable(id);
                eList.setTableSpec(tSpec);
 
                LightUIPanel panel = new LightUIPanel("sales.quote.items.list");
                panel.setGridWidth(1);
                panel.setFillWidth(true);
 
                LightUILine toolbarLine = new LightUILine();
 
                LightUIButtonUnmanaged b1 = new LightUIButtonUnmanaged("up");
                b1.setIcon("up.png");
                panel.addControler(new ActivationOnSelectionControler(id, b1.getId()));
                panel.addControler(new LightController(LightController.TYPE_UP, id, b1.getId()));
                toolbarLine.addChild(b1);
 
                final LightUIButtonUnmanaged b2 = new LightUIButtonUnmanaged("down");
                b2.setIcon("down.png");
                panel.addControler(new ActivationOnSelectionControler(id, b2.getId()));
                panel.addControler(new LightController(LightController.TYPE_DOWN, id, b2.getId()));
                toolbarLine.addChild(b2);
                // Add
                LightUIElement addButton = new LightUIButtonUnmanaged("add", "Ajouter une ligne");
                panel.addControler(new LightController(LightController.TYPE_ADD_DEFAULT, id, addButton.getId()));
                toolbarLine.addChild(addButton);
                // Insert
                LightUIElement insertButton = new LightUIButtonUnmanaged("insert", "Insérer une ligne");
                panel.addControler(new LightController(LightController.TYPE_INSERT_DEFAULT, id, insertButton.getId()));
                toolbarLine.addChild(insertButton);
 
                // Copy
                LightUIElement copyButton = new LightUIButtonUnmanaged("copy", "Dupliquer");
                panel.addControler(new ActivationOnSelectionControler(id, copyButton.getId()));
                panel.addControler(new LightController(LightController.TYPE_COPY, id, copyButton.getId()));
                toolbarLine.addChild(copyButton);
 
                // Remove
                LightUIElement removeButton = new LightUIButtonUnmanaged("remove", "Supprimer");
                panel.addControler(new ActivationOnSelectionControler(id, removeButton.getId()));
                panel.addControler(new LightController(LightController.TYPE_REMOVE, id, removeButton.getId()));
                toolbarLine.addChild(removeButton);
 
                panel.addChild(toolbarLine);
                final LightUILine listLine = new LightUILine();
                listLine.setWeightY(1);
                listLine.setFillHeight(true);
                listLine.addChild(eList);
 
                //
                panel.addChild(listLine);
 
                return panel;
 
            }
 
            @Override
            public void fillFrom(LightUIElement uiElement, SQLRowAccessor sqlRow) {
                LightUIPanel p = (LightUIPanel) uiElement;
                LightUITable ltable = p.getFirstChild(LightUITable.class);
                TableSpec tSpec = ltable.getTableSpec();
                ColumnsSpec columnsSpec = tSpec.getColumns();
                // send: id,value
                final SQLElement elem = configuration.getDirectory().getElement("DEVIS_ELEMENT");
                final SQLTable table = elem.getTable();
                final List<String> fieldsToFetch = new ArrayList<>();
                for (ColumnSpec cs : columnsSpec.getColumns()) {
                    String colId = cs.getId();
                    SQLField f = configuration.getFieldMapper().getSQLFieldForItem(colId);
                    if (f != null) {
                        fieldsToFetch.add(f.getName());
                    } else {
                        throw new IllegalStateException("No field in " + table + " for column id " + colId);
                    }
                }
 
                final Where where = new Where(table.getField("ID_DEVIS"), "=", sqlRow.getID());
                final ListSQLRequest req = elem.createListRequest(fieldsToFetch, where, configuration.getShowAs());
                List<SQLRowValues> fetchedRows = req.getValues();
 
                List<Row> rows = new ArrayList<>();
                for (final SQLRowValues vals : fetchedRows) {
                    Row r = new Row(vals.getID(), columnsSpec.getColumns().size());
                    List<Object> values = new ArrayList<>();
                    for (ColumnSpec cs : columnsSpec.getColumns()) {
                        String colId = cs.getId();
                        SQLField f = configuration.getFieldMapper().getSQLFieldForItem(colId);
                        if (f != null) {
                            Object object = vals.getObject(f.getName());
                            if (object instanceof SQLRowValues) {
                                SQLRowValues sqlRowValues = (SQLRowValues) object;
                                long rowId = sqlRowValues.getIDNumber().longValue();
                                List<SQLField> fieldsToExpand = configuration.getShowAs().getFieldExpand(sqlRowValues.getTable());
                                final StringBuilder b = new StringBuilder();
                                for (SQLField sqlField : fieldsToExpand) {
                                    b.append(sqlRowValues.getObject(sqlField.getName()).toString());
                                    b.append(' ');
                                }
                                object = new StringWithId(rowId, b.toString().trim());
                            }
                            values.add(object);
                        } else {
                            throw new IllegalStateException("No field in " + table + " for column id " + colId);
                        }
                    }
                    r.setValues(values);
                    rows.add(r);
                }
 
                TableContent tableContent = new TableContent();
                tableContent.setRows(rows);
                tSpec.setContent(tableContent);
 
            }
 
            @Override
            public void store(LightUIElement uiElement, SQLRowValues row) {
                // TODO Auto-generated method stub
 
            }
 
        });
        return map;
    }
 
    @Override
    protected String createCode() {
        return "sales.quote";
    }
}
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/quote/element/DevisSQLElement.java - Rev 177 → 182

Rev 177		Rev 182
1	`/*`	1	`/*`
2	`* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.`	2	`* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.`
3	`*`	3	`*`
4	`* Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.`	4	`* Copyright 2011-2019 OpenConcerto, by ILM Informatique. All rights reserved.`
5	`*`	5	`*`
6	`* The contents of this file are subject to the terms of the GNU General Public License Version 3`	6	`* The contents of this file are subject to the terms of the GNU General Public License Version 3`
7	`* only ("GPL"). You may not use this file except in compliance with the License. You can obtain a`	7	`* only ("GPL"). You may not use this file except in compliance with the License. You can obtain a`
8	`* copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific`	8	`* copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific`
9	`* language governing permissions and limitations under the License.`	9	`* language governing permissions and limitations under the License.`
10	`*`	10	`*`
11	`* When distributing the software, include this License Header Notice in each file.`	11	`* When distributing the software, include this License Header Notice in each file.`
12	`*/`	12	`*/`
13		13
14	`package org.openconcerto.erp.core.sales.quote.element;`	14	`package org.openconcerto.erp.core.sales.quote.element;`
15		15
16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`	16	`import org.openconcerto.erp.config.ComptaPropsConfiguration;`
17	`import org.openconcerto.erp.config.Gestion;`	17	`import org.openconcerto.erp.config.Gestion;`
18	`import org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent;`	18	`import org.openconcerto.erp.core.common.component.TransfertBaseSQLComponent;`
19	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`	19	`import org.openconcerto.erp.core.common.element.ComptaSQLConfElement;`
20	`import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;`	20	`import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable;`
21	`import org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent;`	21	`import org.openconcerto.erp.core.sales.invoice.component.SaisieVenteFactureSQLComponent;`
22	`import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;`	22	`import org.openconcerto.erp.core.sales.product.element.ReferenceArticleSQLElement;`
23	`import org.openconcerto.erp.core.sales.quote.component.DevisSQLComponent;`	23	`import org.openconcerto.erp.core.sales.quote.component.DevisSQLComponent;`
24	`import org.openconcerto.erp.core.sales.quote.report.DevisXmlSheet;`	24	`import org.openconcerto.erp.core.sales.quote.report.DevisXmlSheet;`
25	`import org.openconcerto.erp.core.sales.quote.ui.QuoteEditGroup;`	25	`import org.openconcerto.erp.core.sales.quote.ui.QuoteEditGroup;`
26	`import org.openconcerto.erp.core.sales.quote.ui.QuoteSQLComponent;`	26	`import org.openconcerto.erp.core.sales.quote.ui.QuoteSQLComponent;`
27	`import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;`	27	`import org.openconcerto.erp.core.sales.shipment.component.BonDeLivraisonSQLComponent;`
28	`import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;`	28	`import org.openconcerto.erp.core.supplychain.stock.element.MouvementStockSQLElement;`
29	`import org.openconcerto.erp.model.MouseSheetXmlListeListener;`	29	`import org.openconcerto.erp.model.MouseSheetXmlListeListener;`
30	`import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;`	30	`import org.openconcerto.erp.preferences.GestionCommercialeGlobalPreferencePanel;`
31	`import org.openconcerto.sql.Configuration;`	31	`import org.openconcerto.sql.Configuration;`
32	`import org.openconcerto.sql.element.GlobalMapper;`	32	`import org.openconcerto.sql.element.GlobalMapper;`
33	`import org.openconcerto.sql.element.SQLComponent;`	33	`import org.openconcerto.sql.element.SQLComponent;`
34	`import org.openconcerto.sql.element.SQLElement;`	34	`import org.openconcerto.sql.element.SQLElement;`
35	`import org.openconcerto.sql.element.SQLElementLink.LinkType;`	35	`import org.openconcerto.sql.element.SQLElementLink.LinkType;`
36	`import org.openconcerto.sql.element.SQLElementLinksSetup;`	36	`import org.openconcerto.sql.element.SQLElementLinksSetup;`
37	`import org.openconcerto.sql.model.FieldPath;`	37	`import org.openconcerto.sql.model.FieldPath;`
38	`import org.openconcerto.sql.model.SQLField;`	38	`import org.openconcerto.sql.model.SQLField;`
39	`import org.openconcerto.sql.model.SQLInjector;`	39	`import org.openconcerto.sql.model.SQLInjector;`
40	`import org.openconcerto.sql.model.SQLRow;`	40	`import org.openconcerto.sql.model.SQLRow;`