public Map<Object, Object> getFailedTransactionsAndTotalCount( int start, ListFilterCriteria filterCriteria, Date fromDate, Date toDate) { String subQuery = "from PaymentTransaction o where o.createdAt BETWEEN :fromDate AND :toDate" + " and paymentTransactionStatus = 'FAILURE' and o."; String transactionListQueryString = "select o " + subQuery + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%' order by o." + filterCriteria.getSortBy() + " " + filterCriteria.getSortOrder(); Query transactionListQuery = getEntityManagerForActiveEntities().createQuery(transactionListQueryString); transactionListQuery.setParameter("fromDate", fromDate); transactionListQuery.setParameter("toDate", toDate); transactionListQuery.setFirstResult(start); transactionListQuery.setMaxResults(filterCriteria.getItemsPerPage()); List<PaymentTransaction> transactionList = transactionListQuery.getResultList(); Map<Object, Object> transactionDetails = new HashMap<Object, Object>(); transactionDetails.put("list", transactionList); transactionDetails.put("totalCount", getTotalCount(filterCriteria, fromDate, toDate)); return transactionDetails; }
public Map<Object, Object> getDetails( ListFilterCriteria filterCriteria, Date fromDate, Date toDate) { log.debug( "FailedTransactions.getDetails(): Date Range = [{}] - [{}]", DateTimeUtil.formatDate(fromDate), DateTimeUtil.formatDate(toDate)); int startingFrom = (filterCriteria.getP() - 1) * filterCriteria.getItemsPerPage(); Map<Object, Object> orderListAndTotalCount = paymentDao.getFailedTransactionsAndTotalCount( startingFrom, filterCriteria, fromDate, toDate); List<Order> ordersList = (List<Order>) orderListAndTotalCount.get("list"); Map<Object, Object> dataForView = PaginationUtil.generateDataForView( orderListAndTotalCount, filterCriteria.getItemsPerPage(), filterCriteria.getP(), startingFrom, BASE_URL_FOR_PAGINATION, ordersList.size()); Map<String, String> searchFieldMap = new HashMap<String, String>(); searchFieldMap.put("Transaction Id", "bluestoneTxnId"); searchFieldMap.put("Payment Gateway", "paymentGateway"); searchFieldMap.put("Customer Name", "subPayment.masterPayment.cart.customer.userName"); searchFieldMap.put("Customer Email", "subPayment.masterPayment.cart.customer.email"); dataForView.put("searchFieldMap", searchFieldMap); return dataForView; }
private int getTotalCount(ListFilterCriteria filterCriteria, Date fromDate, Date toDate) { Query transactionCountQuery = getEntityManagerForActiveEntities() .createQuery( "select count(o.id) from PaymentTransaction o where " + "o.createdAt BETWEEN :fromDate AND :toDate " + "and paymentTransactionStatus = 'FAILURE' and o." + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%'"); transactionCountQuery.setParameter("fromDate", fromDate); transactionCountQuery.setParameter("toDate", toDate); return ((Long) transactionCountQuery.getSingleResult()).intValue(); }
public Map<Object, Object> getBannerListAndTotalCount( int start, ListFilterCriteria filterCriteria) { log.debug("BannerDao.getBannerListAndTotalCount() "); EntityManager entityManager = getEntityManagerForActiveEntities(); Query bannerCountQuery = entityManager.createNativeQuery( "select count(*) from banner b where b." + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%'"); Query bannerListQuery = entityManager.createQuery( "select b from Banner b where b." + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%' order by " + filterCriteria.getSortBy() + " " + filterCriteria.getSortOrder()); bannerListQuery.setFirstResult(start); bannerListQuery.setMaxResults(filterCriteria.getItemsPerPage()); List<Banner> bannersList = bannerListQuery.getResultList(); Map<Object, Object> bannerDetails = new HashMap<Object, Object>(); bannerDetails.put("list", bannersList); bannerDetails.put("totalCount", ((BigInteger) bannerCountQuery.getSingleResult()).intValue()); return bannerDetails; }
public Map<Object, Object> getVouhersAndTotalCount( int start, ListFilterCriteria filterCriteria, boolean forActive) { EntityManager entityManager = forActive == true ? getEntityManagerForActiveEntities() : getEntityManagerForNonActiveEntities(); Query voucherCountQuery = entityManager.createQuery( "select count(v.id) from DiscountVoucher v where v." + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%' " + "order by " + filterCriteria.getSortBy() + " " + filterCriteria.getSortOrder()); Query voucherListQuery = entityManager.createQuery( "select v from DiscountVoucher v where v." + filterCriteria.getColumn() + " like '%" + filterCriteria.getValueToSearch() + "%' order by " + filterCriteria.getSortBy() + " " + filterCriteria.getSortOrder()); voucherListQuery.setFirstResult(start); voucherListQuery.setMaxResults(filterCriteria.getItemsPerPage()); List<DiscountVoucher> vouchersList = voucherListQuery.getResultList(); Map<Object, Object> voucherDetails = new HashMap<Object, Object>(); voucherDetails.put("list", vouchersList); voucherDetails.put("totalCount", ((Long) voucherCountQuery.getSingleResult()).intValue()); return voucherDetails; }