ContractPortfolio.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2012 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.command;
 
import org.turro.financials.db.FinancialsPU;
import org.turro.financials.entity.Contract;
import org.turro.financials.model.AccountFormat;
import org.turro.jpa.Dao;
import org.turro.math.Zero;
 
public class ContractPortfolio {
 
  private final Contract contract;
  private double invoice, balance;
  private boolean filled = false;
 
  public ContractPortfolio(Contract contract) {
    this.contract = contract;
  }
 
  public Contract getContract() {
    if(!filled) fillData();
    return contract;
  }
 
  public double getInvoice() {
    if(!filled) fillData();
    return invoice;
  }
 
  public double getBalance() {
    if(!filled) fillData();
    return Zero.near(balance, 2) ? 0.0 : balance;
  }
 
  private void fillData() {
    filled = true;
    Dao dao = new FinancialsPU();
    Object o;
    // Provider
    if(contract.getContractDefinition().getId() == 55) {
      o = dao.getSingleResult(
              "select sum(re.debit - re.credit) from RegisterEntry as re " +
              "where(re.account.id like '" + AccountFormat.expand("400." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("401." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("410." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("411." + contract.getId()) + "')");
      if(o instanceof Number) {
        balance = ((Number) o).doubleValue();
      }
      o = dao.getSingleResult(
              "select sum(re.credit) from RegisterEntry as re " +
              "where(re.account.id like '" + AccountFormat.expand("400." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("410." + contract.getId()) + "')");
      if(o instanceof Number) {
        invoice = ((Number) o).doubleValue();
      }
    // Customer
    } else if(contract.getContractDefinition().getId() == 48 || contract.getContractDefinition().getId() == 56) {
      o = dao.getSingleResult(
              "select sum(re.debit - re.credit) from RegisterEntry as re " +
              "where (re.account.id like '" + AccountFormat.expand("430." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("431." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("440." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("441." + contract.getId()) + "')");
      if(o instanceof Number) {
        balance = -((Number) o).doubleValue();
      }
      o = dao.getSingleResult(
              "select sum(re.debit) from RegisterEntry as re " +
              "where (re.account.id like '" + AccountFormat.expand("430." + contract.getId()) + "' " +
              "or re.account.id like '" + AccountFormat.expand("440." + contract.getId()) + "')");
      if(o instanceof Number) {
        invoice = ((Number) o).doubleValue();
      }
    }
  }
 
}