org.turro.financials.model.document.contract.DocumentByContractList Class Reference

Inheritance diagram for org.turro.financials.model.document.contract.DocumentByContractList:

Collaboration diagram for org.turro.financials.model.document.contract.DocumentByContractList:

Public Member Functions
	DocumentByContractList ()
void	fillList (RegisterView view, Contract contract, Date from, Date to)
double	getInitialBalance (RegisterView view, Contract contract, Date from, Date to)
Date	getInitialDate (Dao dao, Date fromDate)

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 34 of file DocumentByContractList.java.

Constructor & Destructor Documentation

DocumentByContractList()

org.turro.financials.model.document.contract.DocumentByContractList.DocumentByContractList

(

)

Definition at line 36 of file DocumentByContractList.java.

                                  {
    super(new DocumentByContractComparator());
  }

Member Function Documentation

fillList()

void org.turro.financials.model.document.contract.DocumentByContractList.fillList	(	RegisterView	view,
		Contract	contract,
		Date	from,
		Date	to
	)

Definition at line 40 of file DocumentByContractList.java.

                                                                                 {
    Dao dao = new FinancialsPU();
    if(view != null) {
      addAll(dao.getResultList(
              "select doc from Document doc " +
              "where doc.contract = ? " +
              "and doc.forcedView = ? " +
              "and doc.documentDate >= ? " +
              "and doc.documentDate <= ?",
              new Object[] { contract, view, from, to }));
    } else {
      addAll(dao.getResultList(
              "select doc from Document doc " +
              "where doc.contract = ? " +
              "and doc.forcedView is null " +
              "and doc.documentDate >= ? " +
              "and doc.documentDate <= ?",
              new Object[] { contract, from, to }));
    }    
  } 

getInitialBalance()

double org.turro.financials.model.document.contract.DocumentByContractList.getInitialBalance	(	RegisterView	view,
		Contract	contract,
		Date	from,
		Date	to
	)

Definition at line 61 of file DocumentByContractList.java.

                                                                                            {
    Dao dao = new FinancialsPU();
    Date init = getInitialDate(dao, from);
    Object o = null;
    if(view != null) {
      o = dao.getSingleResult(
              "select sum(re.debit - re.credit) " +
              "from RegisterEntry re " +
              "join re.register r " +
              "where r.view = ? " +
              "and r.registerDate < ? " +
              (init != null ? "and r.registerDate >= ? " : "and ? is null ") +
              "and (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()) + "' " +
              "or 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()) + "')",
              new Object[] { view, from, init });
    } else {
      o = dao.getSingleResult(
              "select sum(re.debit - re.credit) " +
              "from RegisterEntry re " +
              "join re.register r " +
              "where r.view.id = 1 " +
              "and r.registerDate < ? " +
              (init != null ? "and r.registerDate >= ? " : "and ? is null ") +
              "and (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()) + "' " +
              "or 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()) + "')",
              new Object[] { from, init });
    }    
    if(o instanceof Double) {
      if(contract.getContractDefinition().getId() == 55) {
        return -((Double) o);
      }
      return (Double) o;
    }
    return 0.0;
  }

Here is the call graph for this function:

getInitialDate()

Date org.turro.financials.model.document.contract.DocumentByContractList.getInitialDate	(	Dao	dao,
		Date	fromDate
	)

Definition at line 109 of file DocumentByContractList.java.

                                                     {
    try {
      return (Date) dao.getSingleResult(
              "select max(r.registerDate) from Register r " +
              "where r.registerDate < ? " +
              "and r.closing = TRUE " +
              "and day(r.registerDate) = 1 " +
              "and month(r.registerDate) = 1",
              new Object[] { fromDate });
    } catch(NoResultException ex) {
      return null;
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• DocumentByContractList.java