// Get all records by orderid public List<ReconciliationDto> getRecordsByOid(String logstr, String ordername) throws Exception { // TODO Auto-generated method stub logger.debug(logstr + "get all order records"); // fetch last record of reconciliation List<Reconciliation> recRecords = reconciliationRepository.fetchLast(); if (recRecords.size() == 0) return null; Foodorder foodorder = orderRepository.findOne(recRecords.get(0).getOrderid()); List<Foodorder> foodorderrecords = orderRepository.fetchByDate(foodorder.getOrderdate()); Long orderid = null; // find the orderid by the ordername for (Foodorder food : foodorderrecords) { if (ordername.equals(food.getName())) { orderid = food.getId(); } } if (orderid == null) return null; List<Reconciliation> reconciliationrecords = reconciliationRepository.findByOrderid(orderid); List<ReconciliationDto> reconciliationDtoRecords = new ArrayList<ReconciliationDto>(); try { for (Reconciliation reconciliation : reconciliationrecords) { ReconciliationDto reconciliationDto = new ReconciliationDto(); reconciliationDto.setOrderid(orderid); reconciliationDto.setAmtpaid(reconciliation.getAmountpaid()); reconciliationDto.setCost(reconciliation.getOrdercost()); reconciliationDto.setUserid(reconciliation.getUserid()); User user = userRepository.findOne(reconciliation.getUserid()); reconciliationDto.setUsername(user.getName()); reconciliationDto.setStatus(reconciliation.getStatus()); // reconciliationDto.setUserid(reconciliation.getUserid()); reconciliationDtoRecords.add(reconciliationDto); } logger.debug(logstr + "Records retrived by orderid"); } catch (Exception e) { throw new Exception(); } return reconciliationDtoRecords; }