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

/*
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 * 
 * Copyright 2011 OpenConcerto, by ILM Informatique. All rights reserved.
 * 
 * The contents of this file are subject to the terms of the GNU General Public License Version 3
 * only ("GPL"). You may not use this file except in compliance with the License. You can obtain a
 * copy of the License at http://www.gnu.org/licenses/gpl-3.0.html See the License for the specific
 * language governing permissions and limitations under the License.
 * 
 * When distributing the software, include this License Header Notice in each file.
 */
 
 package org.openconcerto.erp.generationEcritures;

import org.openconcerto.erp.config.ComptaPropsConfiguration;
import org.openconcerto.erp.core.finance.accounting.element.ComptePCESQLElement;
import org.openconcerto.erp.core.finance.accounting.element.MouvementSQLElement;
import org.openconcerto.erp.core.finance.tax.model.TaxeCache;
import org.openconcerto.sql.Configuration;
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.utils.StringUtils;

import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class GenerationMvtReglementChequeClient extends GenerationEcritures {

    private long montant;

    private static final SQLTable tablePrefCompte = base.getTable("PREFS_COMPTE");
    private static final SQLRow rowPrefsCompte = tablePrefCompte.getRow(2);
    private int idCheque;
    private SQLRowAccessor banque;

    public GenerationMvtReglementChequeClient(int idMvt, long montant, Date d, int idCheque, String s, SQLRowAccessor banque) {
        this.montant = montant;
        this.date = d;
        this.idMvt = idMvt;
        this.idCheque = idCheque;
        this.banque = banque;
        SQLRow chequeRow = base.getTable("CHEQUE_A_ENCAISSER").getRow(this.idCheque);
        String num = "";
        if (chequeRow != null && !chequeRow.isUndefined() && chequeRow.getString("NUMERO").trim().length() > 0) {
            num = " N° " + chequeRow.getString("NUMERO");
        }

        if (s != null && s.trim().length() > 0) {
            this.nom = s + (num.trim().length() > 0 ? " - Cheque" + num : "");
        } else {
            this.nom = "Reglement cheque client" + num;
        }
    }

    public void genere() throws Exception {
        System.err.println("génération des ecritures de règlement d'un cheque client du mouvement " + this.idMvt);
        SQLRow chequeRow = base.getTable("CHEQUE_A_ENCAISSER").getRow(this.idCheque);
        SQLRow clientRow = base.getTable("CLIENT").getRow(chequeRow.getInt("ID_CLIENT"));

        this.nom = this.nom + " " + StringUtils.limitLength(clientRow.getString("NOM"), 20);

        // initialisation des valeurs de la map
        this.putValue("DATE", new java.sql.Date(this.date.getTime()));
        this.putValue("NOM", this.nom);
        this.putValue("ID_MOUVEMENT", new Integer(this.idMvt));

        if (this.banque == null || this.banque.isUndefined() || this.banque.isForeignEmpty("ID_JOURNAL")) {
            fillJournalBanqueFromRow(chequeRow);
        } else {
            int idJrnl = this.banque.getForeignID("ID_JOURNAL");
            this.putValue("ID_JOURNAL", idJrnl);
        }

        setDateReglement(this.idCheque, this.date);

        // compte Clients
        int idCompteClient = -1;
        if (chequeRow.getBoolean("SANS_VALEUR_ENCAISSEMENT")) {
            if (clientRow != null) {
                idCompteClient = clientRow.getInt("ID_COMPTE_PCE");
            }
            if (idCompteClient <= 1) {
                idCompteClient = rowPrefsCompte.getInt("ID_COMPTE_PCE_CLIENT");
                if (idCompteClient <= 1) {
                    idCompteClient = ComptePCESQLElement.getIdComptePceDefault("Clients");
                }
            }
        } else {
            idCompteClient = rowPrefsCompte.getInt("ID_COMPTE_PCE_VALEUR_ENCAISSEMENT");
            if (idCompteClient <= 1) {
                idCompteClient = ComptePCESQLElement.getIdComptePceDefault("ValeurEncaissement");
            }
        }

        this.putValue("ID_COMPTE_PCE", new Integer(idCompteClient));
        this.putValue("DEBIT", new Long(0));
        this.putValue("CREDIT", new Long(this.montant));
        ajoutEcriture();
        System.err.println("First ECriture for mvt " + this.idMvt);

        // compte de reglement cheque, ...
        fillCompteBanqueFromRow(chequeRow, "VenteCheque", false);
        this.putValue("DEBIT", new Long(this.montant));
        this.putValue("CREDIT", new Long(0));
        ajoutEcriture();

        // FIXME remove getConf
        SQLRow rowSoc = ComptaPropsConfiguration.getInstanceCompta().getRowSociete();
        if (rowSoc.getTable().contains("TVA_ENCAISSEMENT") && rowSoc.getBoolean("TVA_ENCAISSEMENT")) {
            SQLRow rowTaxe = TaxeCache.getCache().getFirstTaxe();
            if (rowTaxe.contains("ID_COMPTE_PCE_COLLECTE_ENCAISSEMENT")) {
                SQLRowAccessor rowCompteTvaEnc = rowTaxe.getNonEmptyForeign("ID_COMPTE_PCE_COLLECTE_ENCAISSEMENT");
                SQLRowAccessor rowCompteTvaCol = rowTaxe.getNonEmptyForeign("ID_COMPTE_PCE_COLLECTE");
                if (rowCompteTvaCol != null && rowCompteTvaEnc != null) {
                    Float taux = rowTaxe.getFloat("TAUX");
                    long ht = Math.round(montant / (1.0 + (taux / 100.0)));
                    long tva = montant - ht;
                    this.putValue("ID_COMPTE_PCE", rowCompteTvaCol.getID());
                    this.putValue("DEBIT", Long.valueOf(tva));
                    this.putValue("CREDIT", Long.valueOf(0));
                    ajoutEcriture();

                    this.putValue("ID_COMPTE_PCE", rowCompteTvaEnc.getID());
                    this.putValue("DEBIT", Long.valueOf(0));
                    this.putValue("CREDIT", Long.valueOf(tva));
                    ajoutEcriture();

                }
            }
        }

        List<Integer> pieceIDs = new ArrayList<Integer>();
        pieceIDs.add(mouvementTable.getRow(idMvt).getForeignID("ID_PIECE"));
        lettrageAuto(pieceIDs, this.date);

        System.err.println("Ecritures générées pour le mouvement " + this.idMvt);

    }

    private void setDateReglement(int idCheque, Date d) throws SQLException {
        if (idCheque > 1) {
            SQLRow chequeRow = Configuration.getInstance().getBase().getTable("CHEQUE_A_ENCAISSER").getRow(idCheque);
            final int sourceId = MouvementSQLElement.getSourceId(chequeRow.getInt("ID_MOUVEMENT"));
            SQLRow rowMvt = Configuration.getInstance().getBase().getTable("MOUVEMENT").getRow(sourceId);

            if (rowMvt.getString("SOURCE").equalsIgnoreCase("SAISIE_VENTE_FACTURE")) {
                SQLElement eltFacture = Configuration.getInstance().getDirectory().getElement("SAISIE_VENTE_FACTURE");
                SQLRow saisieRow = eltFacture.getTable().getRow(rowMvt.getInt("IDSOURCE"));
                // On fixe la date du paiement
                SQLRowValues rowValsUpdateVF = saisieRow.createEmptyUpdateRow();
                rowValsUpdateVF.put("DATE_REGLEMENT", new Timestamp(d.getTime()));
                rowValsUpdateVF.update();
            }
        }
    }

}