SalesByCategoryServiceImpSnippet.java

public List<SalesByCategory> findAll(String calendarDate, Integer limit, Integer offset) {

    if (limit == null || limit < 1 || limit > configProperties.getLimit()) {
        limit = configProperties.getLimit();
    }

    if (offset == null || offset < 1) {
        offset = 0;
    }

    String whereClause = "WHERE caldate IS NOT NULL";
    if (calendarDate != null) {
        whereClause = whereClause + " AND caldate=date('" + calendarDate + "')";
    }

    String query = String.format("""
            SELECT *
            FROM tickit_sales_by_day_and_category
            %s
            OFFSET %s
            LIMIT %s;""", whereClause, offset, limit);

    return startQuery(query);
}