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

/*

 * 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.pos.element;

import org.openconcerto.erp.config.ComptaPropsConfiguration;

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

import org.openconcerto.erp.core.finance.payment.element.TypeReglementSQLElement;

import org.openconcerto.erp.core.finance.tax.model.TaxeCache;

import org.openconcerto.erp.core.sales.pos.TicketSheetXML;

import org.openconcerto.erp.core.sales.pos.model.Article;

import org.openconcerto.erp.core.sales.pos.model.Categorie;

import org.openconcerto.erp.core.sales.pos.model.Paiement;

import org.openconcerto.erp.core.sales.pos.model.ReceiptCode;

import org.openconcerto.erp.core.sales.pos.model.Ticket;

import org.openconcerto.sql.Configuration;

import org.openconcerto.sql.element.SQLComponent;

import org.openconcerto.sql.element.SQLElement;

import org.openconcerto.sql.element.SQLElementDirectory;

import org.openconcerto.sql.element.UISQLComponent;

import org.openconcerto.sql.model.SQLBase;

import org.openconcerto.sql.model.SQLRow;

import org.openconcerto.sql.model.SQLRowListRSH;

import org.openconcerto.sql.model.SQLSelect;

import org.openconcerto.sql.utils.PartialUniqueTrigger;

import org.openconcerto.sql.view.list.IListeAction.IListeEvent;

import org.openconcerto.sql.view.list.action.SQLRowValuesAction.PredicateRowAction;

import org.openconcerto.utils.DecimalUtils;

import org.openconcerto.utils.ExceptionHandler;

import java.math.BigDecimal;

import java.text.ParseException;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Collections;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.swing.JTextField;

public class TicketCaisseSQLElement extends ComptaSQLConfElement {

    static public final String UNARCHIVED_WHERE = SQLBase.quoteIdentifier("ARCHIVE") + " = " + 0;

    static public final String DATE_WHERE = UNARCHIVED_WHERE + " and " + SQLBase.quoteIdentifier("FILE_HASH") + " is not null";

    // needed until H2 databases are upgraded to use JS code

    static public final class UniqueNumber_PartialUniqueTrigger extends PartialUniqueTrigger {

        public UniqueNumber_PartialUniqueTrigger() {

            super(Arrays.asList("NUMERO"), UNARCHIVED_WHERE);

        }

    }

    // needed until H2 databases are upgraded to use JS code

    static public final class UniqueDate_PartialUniqueTrigger extends PartialUniqueTrigger {

        public UniqueDate_PartialUniqueTrigger() {

            super(Arrays.asList("ID_CAISSE", "DATE"), DATE_WHERE);

        }

    }

    public TicketCaisseSQLElement() {

        super("TICKET_CAISSE", "un ticket de caisse", "tickets de caisses");

        PredicateRowAction action = new PredicateRowAction(true, "ticket.document.generate", (le) -> {

            final TicketSheetXML bSheet = new TicketSheetXML(createTicket(le.getSelectedRow().asRow()), ComptaPropsConfiguration.getInstanceCompta());

            try {

                bSheet.createDocument();

                bSheet.showPrintAndExport(true, false, false, Collections.emptyList());

            } catch (Exception originalExn) {

                ExceptionHandler.handle("Erreur lors de la création de la facture", originalExn);

            }

        });

        action.setPredicate(IListeEvent.getSingleSelectionPredicate());

        getRowValuesActions().add(action);

    }

    protected List<String> getListFields() {

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

        l.add("NUMERO");

        l.add("DATE");

        l.add("ID_CAISSE");

        l.add("TOTAL_HT");

        l.add("TOTAL_TTC");

        return l;

    }

    protected List<String> getComboFields() {

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

        l.add("NOM");

        return l;

    }

    /*

     * (non-Javadoc)

     *

     * @see org.openconcerto.devis.SQLElement#getComponent()

     */

    public SQLComponent createComponent() {

        return new UISQLComponent(this) {

            public void addViews() {

                this.addRequiredSQLObject(new JTextField(), "NOM", "right");

            }

        };

    }

    public Ticket createTicket(SQLRow row) {

        // TODO merger ce code avec CaissepPanel.loadArticles si possible

        final Ticket t;

        try {

            t = new Ticket(new ReceiptCode(row.getString("NUMERO")), row.getDate("DATE"), row.getString("FILE_HASH_PREVIOUS"));

        } catch (ParseException e) {

            throw new IllegalStateException("Couldn't parse " + row, e);

        }

        final SQLElementDirectory directory = Configuration.getInstance().getDirectory();

        SQLElement eltEncaisser = directory.getElement("ENCAISSER_MONTANT");

        List<SQLRow> l = row.getReferentRows(eltEncaisser.getTable());

        for (SQLRow row2 : l) {

            long montant = row2.getLong("MONTANT");

            SQLRow rowMode = row2.getForeign("ID_MODE_REGLEMENT");

            int type = Paiement.CB;

            if (rowMode.getInt("ID_TYPE_REGLEMENT") == TypeReglementSQLElement.CB) {

                type = Paiement.CB;

            } else {

                if (rowMode.getInt("ID_TYPE_REGLEMENT") == TypeReglementSQLElement.CHEQUE) {

                    type = Paiement.CHEQUE;

                } else {

                    if (rowMode.getInt("ID_TYPE_REGLEMENT") == TypeReglementSQLElement.ESPECE) {

                        type = Paiement.ESPECES;

                    }

                }

            }

            Paiement p = new Paiement(type);

            p.setMontantInCents((int) montant);

            t.addPaiement(p);

        }

        SQLElement eltArticle = directory.getElement("SAISIE_VENTE_FACTURE_ELEMENT");

        final SQLSelect selUniteVente = new SQLSelect();

        selUniteVente.addSelectStar(directory.getElement("UNITE_VENTE").getTable());

        final Map<Integer, String> mapUniteVenteName = new HashMap<>();

        for (SQLRow rowUniteVente : SQLRowListRSH.execute(selUniteVente)) {

            mapUniteVenteName.put(rowUniteVente.getID(), rowUniteVente.getString("CODE"));

        }

        List<SQLRow> l2 = row.getReferentRows(eltArticle.getTable());

        Categorie c = new Categorie("");

        for (SQLRow row2 : l2) {

            Article a = new Article(c, row2.getString("NOM"), row2.getInt("ID_ARTICLE"));

            if (row2.getInt("ID_UNITE_VENTE") != 2) {

                a.setSalesUnit(mapUniteVenteName.get(row2.getInt("ID_UNITE_VENTE")));

            }

            BigDecimal ht = (BigDecimal) row2.getObject("PV_HT");

            a.setPriceWithoutTax(ht);

            BigDecimal percentRemise = row2.getBigDecimal("POURCENT_REMISE");

            if (percentRemise != null) {

                a.setDiscountPct(percentRemise.movePointLeft(2));

            }

            int idTaxe = row2.getInt("ID_TAXE");

            float tva = TaxeCache.getCache().getTauxFromId(idTaxe);

            a.setPriceWithTax(ht.multiply(BigDecimal.valueOf(1.0 + (tva / 100.0D)), DecimalUtils.HIGH_PRECISION));

            a.setIdTaxe(idTaxe);

            t.addArticle(a);

            if (a.getSalesUnit() == null) {

                t.setArticleCount(a, new BigDecimal(row2.getInt("QTE")));

            } else {

                t.setArticleCount(a, row2.getBigDecimal("QTE_UNITAIRE"));

            }

        }

        return t;

    }

    @Override

    protected String createCode() {

        return createCodeOfPackage() + ".ticket";

    }

}