Public Member Functions
	AccountStringWrapper (String account)

Double[]	getAmounts (RegisterView view, Date fromDate, Date toDate)

Double	getBalance (RegisterView view, Date toDate)

Detailed Description

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

Definition at line 28 of file AccountStringWrapper.java.

Constructor & Destructor Documentation

◆ AccountStringWrapper()

org.turro.financials.model.register.AccountStringWrapper.AccountStringWrapper ( String account )

Definition at line 32 of file AccountStringWrapper.java.

                                               {
     this.account = account;
   }

Member Function Documentation

◆ getAmounts()

Double [] org.turro.financials.model.register.AccountStringWrapper.getAmounts	(	RegisterView	view,
		Date	fromDate,
		Date	toDate
	)

Definition at line 36 of file AccountStringWrapper.java.

                                                                             {
     Object[] pars = view != null ?
             new Object[] {
               account + "%",
               fromDate,
               toDate,
               view
             } :
             new Object[] {
               account + "%",
               fromDate,
               toDate
             };
     Object[] o = (Object[]) new FinancialsPU().getSingleResult(
             "select sum(entry.debit), sum(entry.credit) " +
             "from RegisterEntry as entry " +
             "where entry.account.id like ? " +
             "and entry.register.registerDate >= ? " +
             "and entry.register.registerDate <= ? " +
             (view != null ? "and entry.register.view = ? " : ""),
             pars);
     return new Double[] {
       (Double) (o[0] == null ? 0.0 : o[0]),
       (Double) (o[1] == null ? 0.0 : o[1])
     };
   }

Here is the call graph for this function:

◆ getBalance()

Double org.turro.financials.model.register.AccountStringWrapper.getBalance	(	RegisterView	view,
		Date	toDate
	)

Definition at line 63 of file AccountStringWrapper.java.

                                                            {
     Object[] pars = view != null ?
             new Object[] {
               account + "%",
               toDate,
               view
             } :
             new Object[] {
               account + "%",
               toDate
             };
     Object o = new FinancialsPU().getSingleResult(
             "select sum(entry.debit-entry.credit) " +
             "from RegisterEntry as entry " +
             "where entry.account.id like ? " +
             "and entry.register.registerDate <= ? " +
             (view != null ? "and entry.register.view = ? " : ""),
             pars);
     return (Double) o;
   }