Sample JPA Query

clearRecord();
for ( int day = 1; day <= 31; day++ ) {
    salesAmount = new BigDecimal(0);

    query = XPersistence.getManager().createQuery(
        "SELECT r.officialReceipt " +
        "FROM RetailTransaction r " +
        "WHERE EXTRACT(month FROM r.timeOfExit) = :month AND " +
        "EXTRACT(year FROM r.timeOfExit) = :year AND " +
        "EXTRACT(day FROM r.timeOfExit) = :day AND " +
        "r.retailExitTerminal = :terminal");
    query.setParameter("month", month_i);
    query.setParameter("year", year_i);
    query.setParameter("day", day);
    query.setParameter("terminal", exitTerminal);

    if ( !query.getResultList().isEmpty() ) {
        for ( Object record : query.getResultList() ) {
            or = (OfficialReceipt) record;

            salesAmount = salesAmount.add(or.getTotalAmount());

            computeMaxMinOr(or);
        }

        birReport = new BirReport();

        birReport.setTransactionDate(or.getOrDate());
        birReport.setSalesAmount(salesAmount);
        birReport.setBeginingOR(String.valueOf(minOR));
        birReport.setEndingOR(String.valueOf(maxOR));
        birReport.setTerminalName(getExitTerminal(getTerminalId));

        XPersistence.getManager().persist(birReport);

        // Reset OR values to zero
        minOR = 0;
        maxOR = 0;

        System.out.println("Data inserted ----- " +
           "Transaction Date: " + getNamedMonth(month_i) + "/" + day + "/" + year_i);
        isDateExist = true;
    }
}