/** * <p>Evaluate Trial Balance query.</p> * @param pDate date of balance * @return query of balance * @throws Exception - an exception **/ public final synchronized String evalQueryBalance( final Date pDate) throws Exception { if (this.queryBalance == null) { String flName = "/" + "accounting" + "/" + "balance" + "/" + "queryBalance.sql"; this.queryBalance = loadString(flName); } String query = queryBalance.replace(":DATE1", String.valueOf(evalDatePeriodStartFor(pDate).getTime())); query = query.replace(":DATE2", String.valueOf(pDate.getTime())); return query; }
/** * <p>Evaluate Trial Balance query.</p> * @param pAddParam additional param * @param pDate date of balance * @return query of balance * @throws Exception - an exception **/ public final synchronized String evalQueryBalance( final Map<String, Object> pAddParam, final Date pDate) throws Exception { if (this.queryBalance == null) { String flName = "/" + "accounting" + "/" + "balance" //+ "/" + "queryBalance.sql"; fast query cause error due changing subacc name + "/" + "queryBalanceSl.sql"; this.queryBalance = loadString(flName); } String query = queryBalance.replace(":DATE1", String.valueOf(evalDatePeriodStartFor(pAddParam, pDate).getTime())); query = query.replace(":DATE2", String.valueOf(pDate.getTime())); return query; }
evalDatePeriodStartFor(leastAccountingEntryDate));
Date datePeriodStartFor = evalDatePeriodStartFor(pAddParam, pDateFor); Calendar calCurrYear = Calendar.getInstance(new Locale("en", "US")); calCurrYear.setTime(getSrvAccSettings().lazyGetAccSettings(pAddParam)
/** * <p>Recalculate if need for all balances for all dates less * or equals pDateFor, this method is always invoked by report ledger.</p> * @param pDateFor date for * @throws Exception - an exception **/ @Override public final synchronized void recalculateAllIfNeed( final Date pDateFor) throws Exception { evalBalanceStorePeriod(); //must be before evalDateBalanceStoreStart!!! evalDateBalanceStoreStart(); Date datePeriodStartFor = evalDatePeriodStartFor(pDateFor); if (datePeriodStartFor.getTime() > lazyGetBalanceAtAllDirtyCheck() .getCurrentBalanceDate().getTime() || lazyGetBalanceAtAllDirtyCheck() .getLeastAccountingEntryDate() .getTime() < lazyGetBalanceAtAllDirtyCheck() .getCurrentBalanceDate().getTime()) { recalculateAll(pDateFor, false); } }
} else { this.balanceAtAllDirtyCheck.setDateBalanceStoreStart( evalDatePeriodStartFor(pAddParam, new Date(dateFirstEntryLong)));