/** * <p>Evaluate 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" + "/" + "queryBalanceSheet.sql"; this.queryBalance = loadString(flName); } String query = queryBalance.replace(":DATE1", String.valueOf(getSrvBalance().evalDatePeriodStartFor(pDate).getTime())); query = query.replace(":DATE2", String.valueOf(pDate.getTime())); return query; }
final Map<String, Object> pAddParam, final Date pDate) throws Exception { getSrvBalance().recalculateAllIfNeed(pDate); BalanceSheet result = new BalanceSheet(); result.setItsDate(pDate); String query = evalQueryBalance(pDate); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { String accName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ACCOUNTNAME"); Integer accType = getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "ITSTYPE"); String accNumber = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "ITSNUMBER"); Double debit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "DEBIT"); Double credit = getSrvDatabase().getSrvRecordRetriever() .getDouble(recordSet.getRecordSet(), "CREDIT"); if (debit != 0 || credit != 0) { bl.setAccType(accType); bl.setDebit(BigDecimal.valueOf(debit).setScale( getSrvAccSettings().lazyGetAccSettings().getBalancePrecision(), getSrvAccSettings().lazyGetAccSettings().getRoundingMode())); bl.setCredit(BigDecimal.valueOf(credit).setScale( getSrvAccSettings().lazyGetAccSettings().getBalancePrecision(),
/** * <p>Get SrvReqBalanceSheet in lazy mode.</p> * @return SrvReqBalanceSheet - SrvReqBalanceSheet * @throws Exception - an exception */ public final synchronized SrvReqBalanceSheet<RS> lazyGetSrvReqBalanceSheet( ) throws Exception { @SuppressWarnings("unchecked") SrvReqBalanceSheet<RS> srvReqBalanceSheet = (SrvReqBalanceSheet<RS>) this.factoryAppBeans.getBeansMap() .get("srvReqBalanceSheet"); if (srvReqBalanceSheet == null) { srvReqBalanceSheet = new SrvReqBalanceSheet<RS>(); srvReqBalanceSheet.setSrvDatabase(this.factoryAppBeans .lazyGetSrvDatabase()); srvReqBalanceSheet.setSrvAccSettings(lazyGetSrvAccSettings()); SrvBalanceSheet<RS> srvBalanceSheet = new SrvBalanceSheet<RS>(this .factoryAppBeans.lazyGetSrvDatabase(), lazyGetSrvAccSettings(), lazyGetSrvBalanceStd()); srvReqBalanceSheet.setSrvBalanceSheet(srvBalanceSheet); this.factoryAppBeans.lazyGetLogger().info(FactoryAccServices.class, "SrvReqBalanceSheet has been created."); this.factoryAppBeans.getBeansMap() .put("srvReqBalanceSheet", srvReqBalanceSheet); } return srvReqBalanceSheet; }
final Map<String, Object> pAddParam, final Date pDate) throws Exception { getSrvBalance().recalculateAllIfNeed(pAddParam, pDate); BalanceSheet result = new BalanceSheet(); result.setItsDate(pDate); String query = evalQueryBalance(pAddParam, pDate); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { bl.setAccType(accType); bl.setDebit(BigDecimal.valueOf(debit).setScale( getSrvAccSettings().lazyGetAccSettings(pAddParam) .getBalancePrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode())); bl.setCredit(BigDecimal.valueOf(credit).setScale( getSrvAccSettings().lazyGetAccSettings(pAddParam) .getBalancePrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode())); if (bl.getDebit().doubleValue() != 0
/** * <p>Get SrvReqBalanceSheet in lazy mode.</p> * @return SrvReqBalanceSheet - SrvReqBalanceSheet * @throws Exception - an exception */ public final SrvReqBalanceSheet<RS> lazyGetSrvReqBalanceSheet( ) throws Exception { String beanName = getSrvReqBalanceSheetName(); @SuppressWarnings("unchecked") SrvReqBalanceSheet<RS> srvReqBalanceSheet = (SrvReqBalanceSheet<RS>) this.factoryAppBeans.getBeansMap() .get(beanName); if (srvReqBalanceSheet == null) { srvReqBalanceSheet = new SrvReqBalanceSheet<RS>(); srvReqBalanceSheet.setSrvDatabase(this.factoryAppBeans .lazyGetSrvDatabase()); srvReqBalanceSheet.setSrvDate(this.factoryAppBeans .lazyGetSrvDate()); srvReqBalanceSheet.setSrvAccSettings(lazyGetSrvAccSettings()); SrvBalanceSheet<RS> srvBalanceSheet = new SrvBalanceSheet<RS>(this .factoryAppBeans.lazyGetSrvDatabase(), lazyGetSrvAccSettings(), lazyGetSrvBalanceStd()); srvReqBalanceSheet.setSrvBalanceSheet(srvBalanceSheet); this.factoryAppBeans.lazyGetLogger().info(null, FactoryAccServices.class, "SrvReqBalanceSheet has been created."); this.factoryAppBeans.getBeansMap() .put(beanName, srvReqBalanceSheet); } return srvReqBalanceSheet; }
/** * <p>Evaluate 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" + "/" + "queryBalanceSheet.sql"; this.queryBalance = loadString(flName); } String query = queryBalance.replace(":DATE1", String.valueOf(getSrvBalance() .evalDatePeriodStartFor(pAddParam, pDate).getTime())); query = query.replace(":DATE2", String.valueOf(pDate.getTime())); return query; }
bSheetPdf.setSrvI18n(this.factoryAppBeans.lazyGetSrvI18n()); hndlBalancePdfReq.setBalanceSheetPdf(bSheetPdf); SrvBalanceSheet<RS> srvBalanceSheet = new SrvBalanceSheet<RS>(this .factoryAppBeans.lazyGetSrvDatabase(), lazyGetSrvAccSettings(), lazyGetSrvBalanceStd());