/** * <p>Get SrvLedger in lazy mode.</p> * @return SrvLedger - SrvLedger * @throws Exception - an exception */ public final synchronized SrvLedger<RS> lazyGetSrvLedger() throws Exception { if (this.srvLedger == null) { this.srvLedger = new SrvLedger<RS>(factoryAppBeans.lazyGetSrvDatabase(), lazyGetSrvAccSettings(), lazyGetSrvBalanceStd()); } return this.srvLedger; }
final Map<String, Object> pAddParam, final Account pAccount, final Date pDate1, final String pSubaccId) throws Exception { getSrvBalance().recalculateAllIfNeed(pAddParam, pDate1); LedgerPrevious result = new LedgerPrevious(); if (this.queryPrevious == null) { this.queryPrevious = loadString(flName); String.valueOf(getSrvBalance() .evalDatePeriodStartFor(pAddParam, pDate1).getTime())); query = query.replace(":DATE1", String.valueOf(pDate1.getTime())); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { .getString("SUBACC"); lpl.setDebit(BigDecimal.valueOf(recordSet.getDouble("DEBIT")) .setScale(getSrvAccSettings().lazyGetAccSettings(pAddParam) .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode())); lpl.setCredit(BigDecimal.valueOf(recordSet.getDouble("CREDIT")) .setScale(getSrvAccSettings().lazyGetAccSettings(pAddParam) .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode())); if (pAccount.getNormalBalanceType() == ENormalBalanceType.DEBIT) {
String flName = "/" + "accounting" + "/" + "ledger" + "/" + "queryDetail.sql"; this.queryDetail = loadString(flName); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { LedgerDetailLine ldl = new LedgerDetailLine(); ldl.setItsDate(getSrvDatabase().getSrvRecordRetriever() .getDate(recordSet.getRecordSet(), "ITSDATE")); ldl.setSourceId(getSrvDatabase().getSrvRecordRetriever() .getLong(recordSet.getRecordSet(), "SOURCEID")); ldl.setSourceType(getSrvDatabase().getSrvRecordRetriever() .getInteger(recordSet.getRecordSet(), "SOURCETYPE")); ldl.setDescription(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "DESCRIPTION")); ldl.setSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC")); ldl.setCorrAccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACC")); ldl.setCorrSubaccName(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORSUBACC")); ldl.setCorrAccNumber(getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "CORACCNUMBER")); Boolean isDebit = getSrvDatabase().getSrvRecordRetriever() .getBoolean(recordSet.getRecordSet(), "ISDEBIT"); if (isDebit) {
final Map<String, Object> pAddParam, final Account pAccount, final Date pDate1, final String pSubaccId) throws Exception { getSrvBalance().recalculateAllIfNeed(pDate1); LedgerPrevious result = new LedgerPrevious(); if (this.queryPrevious == null) { String flName = "/" + "accounting" + "/" + "ledger" + "/" + "queryPrevious.sql"; this.queryPrevious = loadString(flName); String.valueOf(getSrvBalance().evalDatePeriodStartFor(pDate1).getTime())); query = query.replace(":DATE1", String.valueOf(pDate1.getTime())); query = query.replace(":ACCID", "'" + pAccount.getItsId() + "'"); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { LedgerPreviousLine lpl = new LedgerPreviousLine(); String subaccName = getSrvDatabase().getSrvRecordRetriever() .getString(recordSet.getRecordSet(), "SUBACC"); lpl.setDebit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "DEBIT") .setScale(getSrvAccSettings().lazyGetAccSettings() .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings().getRoundingMode())); lpl.setCredit(getSrvDatabase().getSrvRecordRetriever() .getBigDecimal(recordSet.getRecordSet(), "CREDIT") .setScale(getSrvAccSettings().lazyGetAccSettings()
this.queryDetail = loadString(flName); IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { ldl.setDebit(BigDecimal .valueOf(recordSet.getDouble("ITSTOTAL")) .setScale(getSrvAccSettings().lazyGetAccSettings(pAddParam) .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode())); } else { ldl.setCredit(BigDecimal .valueOf(recordSet.getDouble("ITSTOTAL")) .setScale(getSrvAccSettings().lazyGetAccSettings(pAddParam) .getCostPrecision(), getSrvAccSettings() .lazyGetAccSettings(pAddParam).getRoundingMode()));
/** * <p>Get SrvLedger in lazy mode.</p> * @return SrvLedger - SrvLedger * @throws Exception - an exception */ public final SrvLedger<RS> lazyGetSrvLedger() throws Exception { String beanName = getSrvLedgerName(); @SuppressWarnings("unchecked") SrvLedger<RS> srvLedger = (SrvLedger<RS>) this.factoryAppBeans.getBeansMap().get(beanName); if (srvLedger == null) { srvLedger = new SrvLedger<RS>(this.factoryAppBeans .lazyGetSrvDatabase(), lazyGetSrvAccSettings(), lazyGetSrvBalanceStd()); this.factoryAppBeans.getBeansMap().put(beanName, srvLedger); this.factoryAppBeans.lazyGetLogger().info(null, FactoryAccServices.class, beanName + " has been created."); } return srvLedger; }