m303m/VatEntry.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2016 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.m303m;
 
import javax.persistence.NoResultException;
import org.turro.jpa.Dao;
 
public class VatEntry {
  private String account;
  private int vat;
  private Double amountVat, declaredVat, pendingVat;
  private EntryMonth month;
 
  public VatEntry(int vat, EntryMonth month) {
    this.vat = vat;
    this.month = month;
    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[] { month.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 EntryMonth getMonth() {
    return month;
  }
 
  public Dao getDao() {
    return month.getDao();
  }
 
  private void fillData() {
    try {
      // Current month 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[] { month.getFinalDate(), month.getMonthInitialDate(), month.getEntry().getType().getVatAccount() + "0" + vat });
      if(objs != null) {
        account = (String) objs[0];
        if(month.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 month 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[] { month.getFinalDeclaredDate(), month.getMonthDeclaredDate(), month.getEntry().getType().getVatAccount() + "0" + vat });
      if(objs != null) {
        account = (String) objs[0];
        if(month.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;
  }
 
}