ClosingRegisters.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.model.register;
 
import java.util.*;
import org.amic.util.date.CheckDate;
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.Account;
import org.turro.financials.entity.Register;
import org.turro.financials.entity.RegisterView;
import org.turro.financials.model.AccountFormat;
import org.turro.jpa.Dao;
import org.turro.math.Round;
 
public class ClosingRegisters {
 
  private final String startString, endString, operatingString;
  private final Collection<AccountItem> toInsert = new HashSet<>();
 
  public ClosingRegisters(String startString, String endString, String operatingString) {
    this.startString = startString;
    this.endString = endString;
    this.operatingString = operatingString;
  }
 
  public boolean existsClosingRegisters(int exercise) {
    Collection<Register> list = getClosureRegisters(exercise);
    return list != null && !(list.isEmpty());
  }
  
  public void deleteClosingRegisters(int exercise) {
    Collection<Register> list = getClosureRegisters(exercise);
    for(Register r : list) {
      new RegisterWrapper(r).delete();
    }
  }
 
  public void createClosingRegisters(int exercise) {
    for(Register r : generateClosingRegisters(exercise)) {
      if(!r.isEmpty()) {
        new RegisterWrapper(r).save();
      }
    }
  }
 
  public Collection<Register> generateClosingRegisters(int exercise) {
    List<Register> list = new ArrayList<>();
    Set amounts = getAmounts(exercise);
    list.addAll(generateOperatingRegisters(exercise, amounts));
    list.addAll(generateCloseAndStartRegisters(exercise, amounts));
    return list;
  }
 
  public Set<AccountItem> getNotClosed(int exercise) {
    Dao dao = new FinancialsPU();
    return new AccountSet(dao.getResultList(
            "select new org.turro.financials.model.register.AccountItem(re.register.view.id, re.account.id, sum(round(re.debit - re.credit, 4) + 0.0)) " +
            "from RegisterEntry as re " +
            "where year(re.register.registerDate) = ? " +
            "group by re.register.view.id, re.account.id " +
            "having sum(round(re.debit - re.credit, 4) + 0.0) <> 0.0",
            new Object[] { exercise}));
  }
 
  public Double get129(int exercise) {
    Dao dao = new FinancialsPU();
    return (Double) dao.getSingleResultOrNull(
            "select sum(round(re.debit - re.credit, 4) + 0.0) " +
            "from RegisterEntry as re " +
            "where year(re.register.registerDate) = ? " +
            "and re.account.id = ?",
            new Object[] { exercise, AccountFormat.expand("129") });
  }
 
  public Collection<Integer> getExercises() {
    Dao dao = new FinancialsPU();
    return dao.getResultList(
            "select distinct year(reg.registerDate) from Register reg");
  }
 
  private Collection<Register> generateOperatingRegisters(int exercise, Set<AccountItem> amounts) {
    List<Register> list = new ArrayList<>();
    RegisterGenerator reg = new RegisterGenerator();
    RegisterView current = null;
    double g129 = 0.0;
    for(AccountItem ai : amounts) {
      if(current == null) {
        current = ai.view;
        reg.getRegister().setClosing(true);
        reg.getRegister().setExclude(true);
        reg.getRegister().setView(current);
        reg.getRegister().setRegisterDate(new CheckDate(exercise, 12, 31, 0, 0, 0).getDate());
      } else if(current.getId() != ai.view.getId()) {
        if(!(reg.getRegister().isEmpty())) {
          // add 129.0 account and sum current account balance
          Account acc = new Account();
          acc.setId("1290000000");
          reg.addAccount(acc, operatingString, g129);
          AccountItem ai129 = AccountItem.createAccountItem(current, acc, g129);
          if(ai129 != null) toInsert.add(ai129);
          list.add(reg.getRegister());
        }
        current = ai.view;
        g129 = 0.0;
        reg = new RegisterGenerator();
        reg.getRegister().setClosing(true);
        reg.getRegister().setExclude(true);
        reg.getRegister().setView(current);
        reg.getRegister().setRegisterDate(new CheckDate(exercise, 12, 31, 0, 0, 0).getDate());
      }
      if(ai.account.getId().startsWith("6") || ai.account.getId().startsWith("7")) {
        g129 += new Round(ai.balance).decimals(reg.getFractionDigits()).value();
        reg.addAccount(ai.account, operatingString, -ai.balance);
        ai.balance = 0.0;
      }
    }
    if(!(reg.getRegister().isEmpty())) {
      // add 129.0 account and sum current account balance
      Account acc = new Account();
      acc.setId("1290000000");
      reg.addAccount(acc, operatingString,  g129);
      AccountItem ai129 = AccountItem.createAccountItem(current, acc, g129);
      if(ai129 != null) toInsert.add(ai129);
      list.add(reg.getRegister());
    }
    amounts.addAll(toInsert);
    return list;
  }
 
  private Collection<Register> generateCloseAndStartRegisters(int exercise, Set<AccountItem> amounts) {
    List<Register> list = new ArrayList<>();
    RegisterGenerator close = new RegisterGenerator(), start = new RegisterGenerator();
    RegisterView current = null;
    for(AccountItem ai : amounts) {
      if(current == null) {
        current = ai.view;
        close.getRegister().setClosing(true);
        close.getRegister().setExclude(true);
        close.getRegister().setView(current);
        close.getRegister().setRegisterDate(new CheckDate(exercise, 12, 31, 0, 0, 0).getDate());
        start.getRegister().setClosing(true);
        start.getRegister().setExclude(false);
        start.getRegister().setView(current);
        start.getRegister().setRegisterDate(new CheckDate(exercise + 1, 1, 1, 0, 0, 0).getDate());
      } else if(current.getId() != ai.view.getId()) {
        list.add(close.getRegister());
        list.add(start.getRegister());
        current = ai.view;
        close = new RegisterGenerator();
        start = new RegisterGenerator();
        close.getRegister().setClosing(true);
        close.getRegister().setExclude(true);
        close.getRegister().setView(current);
        close.getRegister().setRegisterDate(new CheckDate(exercise, 12, 31, 0, 0, 0).getDate());
        start.getRegister().setClosing(true);
        start.getRegister().setExclude(false);
        start.getRegister().setView(current);
        start.getRegister().setRegisterDate(new CheckDate(exercise + 1, 1, 1, 0, 0, 0).getDate());
      }
      close.addAccount(ai.account, endString, -ai.balance);
      start.addAccount(ai.account, startString, ai.balance);
    }
    if(!(close.getRegister().isEmpty())) {
      list.add(close.getRegister());
      list.add(start.getRegister());
    }
    return list;
  }
 
  public Collection<Register> getClosureRegisters(int exercise) {
    Dao dao = new FinancialsPU();
    List<Register> list = dao.getResultList(
            "select reg from Register reg " +
            "where ( " +
            "year(reg.registerDate) = ? " +
            "and month(reg.registerDate) = 12 " +
            "and reg.exclude = TRUE and reg.closing = TRUE " +
            ") or ( " +
            "year(reg.registerDate) = ? " +
            "and month(reg.registerDate) = 1 " +
            "and reg.exclude = FALSE and reg.closing = TRUE " +
            ") and reg.document is null",
            new Object[] { exercise, exercise + 1});
    return list;
  }
 
  private Set<AccountItem> getAmounts(int exercise) {
    Dao dao = new FinancialsPU();
    return new AccountSet(dao.getResultList(
            "select new org.turro.financials.model.register.AccountItem(re.register.view.id, re.account.id, sum(round(re.debit - re.credit, 4) + 0.0)) " +
            "from RegisterEntry as re " +
            "where year(re.register.registerDate) = ? " +
            "and re.register.exclude = FALSE " +
            "group by re.register.view.id, re.account.id",
            new Object[] { exercise}));
  }
 
}