WebSVN - OpenConcerto - Diff - Rev 177 and 180 - /trunk/OpenConcerto/src/org/openconcerto/erp/core/sales/account/VenteFactureSituationSQLComponent.java


/*
 * 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) {
                if (!isFilling()) {
                    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);
        }
    }
}

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/account/VenteFactureSituationSQLComponent.java - Rev 177 → 180

Rev 177		Rev 180
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 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.account;`	14	`package org.openconcerto.erp.core.sales.account;`
15		15
16	`import org.openconcerto.erp.core.common.component.TransfertGroupSQLComponent;`	16	`import org.openconcerto.erp.core.common.component.TransfertGroupSQLComponent;`
17	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`	17	`import org.openconcerto.erp.core.common.element.NumerotationAutoSQLElement;`
18	`import org.openconcerto.erp.core.common.ui.AbstractArticleItemTable;`	18	`import org.openconcerto.erp.core.common.ui.AbstractArticleItemTable;`
19	`import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable.TypeCalcul;`	19	`import org.openconcerto.erp.core.common.ui.AbstractVenteArticleItemTable.TypeCalcul;`
20	`import org.openconcerto.erp.core.common.ui.Acompte;`	20	`import org.openconcerto.erp.core.common.ui.Acompte;`
21	`import org.openconcerto.erp.core.common.ui.AcompteField;`	21	`import org.openconcerto.erp.core.common.ui.AcompteField;`
22	`import org.openconcerto.erp.core.common.ui.AcompteRowItemView;`	22	`import org.openconcerto.erp.core.common.ui.AcompteRowItemView;`
23	`import org.openconcerto.erp.core.common.ui.DeviseField;`	23	`import org.openconcerto.erp.core.common.ui.DeviseField;`
24	`import org.openconcerto.erp.core.common.ui.TotalPanel;`	24	`import org.openconcerto.erp.core.common.ui.TotalPanel;`
25	`import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseType;`	25	`import org.openconcerto.erp.core.customerrelationship.customer.ui.AdresseType;`
26	`import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;`	26	`import org.openconcerto.erp.core.finance.accounting.element.EcritureSQLElement;`
27	`import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;`	27	`import org.openconcerto.erp.core.sales.invoice.element.SaisieVenteFactureSQLElement;`
28	`import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;`	28	`import org.openconcerto.erp.core.sales.invoice.report.VenteFactureXmlSheet;`
29	`import org.openconcerto.erp.core.sales.invoice.ui.FactureSituationItemTable;`	29	`import org.openconcerto.erp.core.sales.invoice.ui.FactureSituationItemTable;`
30	`import org.openconcerto.erp.generationEcritures.GenerationMvtSaisieVenteFacture;`	30	`import org.openconcerto.erp.generationEcritures.GenerationMvtSaisieVenteFacture;`
31	`import org.openconcerto.erp.panel.PanelOOSQLComponent;`	31	`import org.openconcerto.erp.panel.PanelOOSQLComponent;`
32	`import org.openconcerto.sql.Configuration;`	32	`import org.openconcerto.sql.Configuration;`
33	`import org.openconcerto.sql.element.ElementSQLObject;`	33	`import org.openconcerto.sql.element.ElementSQLObject;`
34	`import org.openconcerto.sql.element.GlobalMapper;`	34	`import org.openconcerto.sql.element.GlobalMapper;`
35	`import org.openconcerto.sql.element.SQLElement;`	35	`import org.openconcerto.sql.element.SQLElement;`
36	`import org.openconcerto.sql.model.SQLRow;`	36	`import org.openconcerto.sql.model.SQLRow;`
37	`import org.openconcerto.sql.model.SQLRowAccessor;`	37	`import org.openconcerto.sql.model.SQLRowAccessor;`
38	`import org.openconcerto.sql.model.SQLRowValues;`	38	`import org.openconcerto.sql.model.SQLRowValues;`
39	`import org.openconcerto.sql.model.SQLTable;`	39	`import org.openconcerto.sql.model.SQLTable;`
40	`import org.openconcerto.sql.model.Where;`	40	`import org.openconcerto.sql.model.Where;`