// 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;
}
