m303/VatEntry.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.turro.financials.treasury.m303;
 
import javax.persistence.NoResultException;
import org.turro.jpa.Dao;
 
public class VatEntry {
 
  private String account;
  private int vat;
  private Double amountVat, declaredVat, pendingVat;
  private EntryQuarter quarter;
 
  public VatEntry(int vat, EntryQuarter quarter) {
    this.vat = vat;
    this.quarter = quarter;
    fillData();
  }
 
  public void setPendingVat(double value) {
    pendingVat = value;
  }
 
  public Double getPendingVat() {
    return pendingVat;
  }
  
  public String getAccount() {
    if(account == null) {
      account = (String) getDao().getSingleResult(
              "select a.id from Account as a where a.id like ?", 
              new Object[] { quarter.getEntry().getType().getVatAccount() + "00" + vat });
    }
    return account;
  }
 
  public double getAmountVat() {
    return amountVat;
  }
 
  public double getToDeclareAmountVat() {
    return amountVat - (declaredVat + pendingVat);
  }
 
  public double getAmountOp() {
    return getAmountVat() / (getVat() / 100);
  }
 
  public double getToDeclareAmountOp() {
    return getToDeclareAmountVat() / (getVat() / 100);
  }
 
  public double getDeclaredVat() {
    return declaredVat;
  }
 
  public double getVat() {
    return vat / 10.0d;
  }
 
  public EntryQuarter getQuarter() {
    return quarter;
  }
 
  public Dao getDao() {
    return quarter.getDao();
  }
 
  private void fillData() {
    try {
      // Current quarter amount
      Object[] objs = (Object[]) getDao().getSingleResult(
              "select a.id, sum(e.debit), sum(e.credit) from RegisterEntry e " +
              "join e.register r " +
              "join e.account a " +
              "where r.registerDate <= ? " +
              "and r.registerDate >= ? " +
              "and r.view.id = 1 " +
              "and (r.exclude = FALSE and r.closing = FALSE and r.regularizeVAT = FALSE) " +
              "and a.id like ? " +
              "group by a.id",
              new Object[] { quarter.getFinalDate(), quarter.getQuarterInitialDate(), quarter.getEntry().getType().getVatAccount() + "0" + vat });
      if(objs != null) {
        account = (String) objs[0];
        if(quarter.getEntry().getType().getVatAccount().startsWith("472")) {
          amountVat = (Double) (objs[1] == null ? 0.0 : objs[1]);
        } else {
          amountVat = (Double) (objs[2] == null ? 0.0 : objs[2]);
        }
      }
    } catch(NoResultException ex) {
      amountVat = 0.0;
    }
    try {
      // Current quarter declared
      Object[] objs = (Object[]) getDao().getSingleResult(
              "select a.id, sum(e.debit), sum(e.credit) from RegisterEntry e " +
              "join e.register r " +
              "join e.account a " +
              "where r.registerDate <= ? " +
              "and r.registerDate >= ? " +
              "and r.view.id = 1 " +
              "and (r.exclude = FALSE and r.closing = FALSE and r.regularizeVAT = FALSE) " +
              "and a.id like ? " +
              "group by a.id",
              new Object[] { quarter.getFinalDeclaredDate(), quarter.getQuarterDeclaredDate(), quarter.getEntry().getType().getVatAccount() + "0" + vat });
      if(objs != null) {
        account = (String) objs[0];
        if(quarter.getEntry().getType().getVatAccount().startsWith("472")) {
          declaredVat = (Double) (objs[2] == null ? 0.0 : objs[2]);
        } else {
          declaredVat = (Double) (objs[1] == null ? 0.0 : objs[1]);
        }
      }
    } catch(NoResultException ex) {
      declaredVat = 0.0;
    }
    pendingVat = 0.0;
//    if(declaredVat == 0) {
//      try {
//        // Corrections to previous quarters
//        Object[] objs = (Object[]) getDao().getSingleResult(
//                "select a.id, sum(e.debit), sum(e.credit) from RegisterEntry e " +
//                "join e.register r " +
//                "join e.account a " +
//                "where r.registerDate < ? " +
//                "and r.registerDate >= ? " +
//                "and r.view.id = 1 " +
//                "and r.exclude = FALSE and r.closing = FALSE " +
//                "and a.id like ? " +
//                "group by a.id",
//                new Object[] { quarter.getQuarterInitialDate(), quarter.getInitialDate(), quarter.getEntry().getType().getVatAccount() + "00" + vat });
//        Double pastAmountVat = 0.0, pastDeclaredVat = 0.0;
//        if(objs != null) {
//          account = (String) objs[0];
//          if(quarter.getEntry().getType().getVatAccount().startsWith("472")) {
//            pastAmountVat = (Double) (objs[1] == null ? 0.0 : objs[1]);
//            pastDeclaredVat = (Double) (objs[2] == null ? 0.0 : objs[2]);
//          } else {
//            pastAmountVat = (Double) (objs[2] == null ? 0.0 : objs[2]);
//            pastDeclaredVat = (Double) (objs[1] == null ? 0.0 : objs[1]);
//          }
//          declaredVat += pastDeclaredVat - pastAmountVat;
//        }
//      } catch(NoResultException ex) {}
//    }
  }
 
}