LAR_Utils.java

/******************************************************************************
 * Product: Adempiere ERP & CRM Smart Business Solution                       *
 * Copyright (C) 1999-2007 ComPiere, Inc. All Rights Reserved.                *
 * This program is free software, you can redistribute it and/or modify it    *
 * under the terms version 2 of the GNU General Public License as published   *
 * by the Free Software Foundation. This program is distributed in the hope   *
 * that it will be useful, but WITHOUT ANY WARRANTY, without even the implied *
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.           *
 * See the GNU General Public License for more details.                       *
 * You should have received a copy of the GNU General Public License along    *
 * with this program, if not, write to the Free Software Foundation, Inc.,    *
 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.                     *
 * For the text or an alternative of this public license, you may reach us    *
 * ComPiere, Inc., 2620 Augustine Dr. #245, Santa Clara, CA 95054, USA        *
 * or via info@compiere.org or http://www.compiere.org/license.html           *
 *****************************************************************************/
package ar.com.ergio.util;

import java.util.logging.Level;

import org.compiere.model.MInvoice;
import org.compiere.util.CLogger;
import org.compiere.util.DB;
import org.compiere.util.Env;

import ar.com.ergio.model.LAR_MDocType;

/**
 * Utility class for Argentine Localization.
 *
 * @author Emiliano Pereyra - Ergio
 *
 */
public final class LAR_Utils {

    /** Logger          */
    private static CLogger log = CLogger.getCLogger(LAR_Utils.class);

    private LAR_Utils(){}

    /**
     * Calculates the letter from a given invoice using its document number.
     *
     * @param invoice
     *            invoice to process
     * @return the letter from a given invoice
     */
    public static String getLetter(final MInvoice invoice)
    {
        String sql = "SELECT Letter FROM LAR_DocumentLetter WHERE LAR_DocumentLetter_ID=?";
        String letter = DB.getSQLValueString(invoice.get_TrxName(), sql,
                invoice.get_ValueAsInt("LAR_DocumentLetter_ID"));
        return letter;
    }

    /**
     * Calculates the point of sale from a given invoice using its document
     * number.
     *
     * @param invoice
     *            invoice to process
     * @return the point of sale from a given invoice
     */
    public static String getPosNumber(final MInvoice invoice)
    {
        String posNumber = "0000" + invoice.get_ValueAsInt("PosNumber");
        return posNumber.substring(posNumber.length() - 4);
    }

    /**
     * Validates a CUIT number
     *
     * @param cuit
     *            CUIT number
     * @return true if cuit number is valid; false otherwise
     */
    public static boolean validateCUIT(final String cuit)
    {
        boolean ret = false;

        if (cuit == null || cuit.trim().length() == 0) {
            return false;
        }

        String trimCuit = cuit.trim();

        try {
            int[] magicNumbers = { 5, 4, 3, 2, 7, 6, 5, 4, 3, 2 };
            int[] numbers = new int[11];
            int i;
            int sum = 0;

            trimCuit = trimCuit.replace("-", "");

            if (trimCuit.length() != 11) {
                return false;
            }

            for (i = 0; i < 11; i++) {
                numbers[i] = Integer.parseInt(trimCuit.substring(i, i + 1));
            }

            int verifDigit = numbers[10];

            for (i = 0; i < 10; i++) {
                sum = sum + numbers[i] * magicNumbers[i];
            }

            int div = sum / 11;
            int prod = div * 11;
            int diff = sum - prod;
            verifDigit = (diff > 0) ? 11 - diff : diff;

            ret = (verifDigit == numbers[i]);
        } catch (Exception e) {
            log.log(Level.SEVERE, "Error when validate CUIT", e);
        }
        return ret;
    }

    /**
     * Chequea la duplicidad de un número de CUIT
     * @param cuit
     * @return true si está duplicado; false caso contrario
     */
    public static boolean checkDuplicateCUIT(final String cuit)
    {
        String sql = "SELECT COUNT(*) FROM c_bpartner WHERE taxid = ?";
        int cant = DB.getSQLValue(null, sql, cuit);
        return cant > 0;
    } // checkDuplicateCUIT

    /**
     * Valida el número de IIBB
     *
     * @param nroIIBB número a validar
     * @param lco_ISIC_ID Id del tipo de IIBB
     * @return true si el número es válido; false caso contrario
     */
    public static boolean validateIIBBNumber(final String nroIIBB, int lco_ISIC_ID)
    {
        String sqlTipoIIBB = "SELECT value FROM lco_isic WHERE lco_isic_id = ?";
        String tipoIIBB = DB.getSQLValueString(null, sqlTipoIIBB, lco_ISIC_ID);

        if ((tipoIIBB == null)
                || (tipoIIBB.equals("D") && nroIIBB.length() != 8)
                || (tipoIIBB.equals("CM") && nroIIBB.length() != 10))
        {
            return false;
        }
        return true;
    }

    /**
     * Returns whether a document is fiscal or not
     *
     * @param C_docType_ID
     *            document type id
     * @return true if document is fiscal, false otherwise
     */
    public static boolean isFiscalDocType(int C_docType_ID)
    {
	boolean result = false;
	if (C_docType_ID != 0) {
	    LAR_MDocType docType = new LAR_MDocType(Env.getCtx(), C_docType_ID, null);
	    result = docType.isFiscal();
	}
	return result;
    }
}