Class OrderDAO

java.lang.Object

app.dao.OrderDAO

public class OrderDAO
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
private static final int	MAX_PAGE_SIZE

Constructor Summary

Constructors

Constructor	Description
OrderDAO()

Method Summary

Modifier and Type	Method	Description
private void	bindDateRange(PreparedStatement stmt, LocalDate startDate, LocalDate endDate)
private int	bindFilters(PreparedStatement stmt, OrderFilters filters)
private String	buildWhereClause(OrderFilters filters)
int	countOrders(OrderFilters filters)
private List<SalesTrendRow>	getDailySales(Connection conn, LocalDate startDate, LocalDate endDate)
private List<EmployeeSales>	getEmployeeSales(Connection conn, LocalDate startDate, LocalDate endDate)
List<Order>	getOrders(OrderFilters filters, int limit, int offset)
private List<PaymentMethodSales>	getPaymentMethodSales(Connection conn, LocalDate startDate, LocalDate endDate)
private List<SalesReportRow>	getSalesByItem(Connection conn, LocalDate startDate, LocalDate endDate)
SalesReportData	getSalesReport(LocalDate startDate, LocalDate endDate)
private int	nextId(Connection conn, String sql)
int	saveOrder(int employeeId, String customerName, String paymentType, BigDecimal totalCost, BigDecimal salesTax, List<OrderItem> items)
private void	validatePage(int limit, int offset)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

MAX_PAGE_SIZE

private static final int MAX_PAGE_SIZE

See Also:

• Constant Field Values

Constructor Details

OrderDAO

public OrderDAO()

Method Details

getOrders

public List<Order> getOrders(OrderFilters filters,
 int limit,
 int offset)
                      throws SQLException

Throws:

SQLException

countOrders

public int countOrders(OrderFilters filters)
                throws SQLException

Throws:

SQLException

getSalesReport

public SalesReportData getSalesReport(LocalDate startDate,
 LocalDate endDate)
                               throws SQLException

Throws:

SQLException

getSalesByItem

private List<SalesReportRow> getSalesByItem(Connection conn,
 LocalDate startDate,
 LocalDate endDate)
                                     throws SQLException

Throws:

SQLException

getDailySales

private List<SalesTrendRow> getDailySales(Connection conn,
 LocalDate startDate,
 LocalDate endDate)
                                   throws SQLException

Throws:

SQLException

getPaymentMethodSales

private List<PaymentMethodSales> getPaymentMethodSales(Connection conn,
 LocalDate startDate,
 LocalDate endDate)
                                                throws SQLException

Throws:

SQLException

getEmployeeSales

private List<EmployeeSales> getEmployeeSales(Connection conn,
 LocalDate startDate,
 LocalDate endDate)
                                      throws SQLException

Throws:

SQLException

bindDateRange

private void bindDateRange(PreparedStatement stmt,
 LocalDate startDate,
 LocalDate endDate)
                    throws SQLException

Throws:

SQLException

buildWhereClause

private String buildWhereClause(OrderFilters filters)

bindFilters

private int bindFilters(PreparedStatement stmt,
 OrderFilters filters)
                 throws SQLException

Throws:

SQLException

validatePage

private void validatePage(int limit,
 int offset)

saveOrder

public int saveOrder(int employeeId,
 String customerName,
 String paymentType,
 BigDecimal totalCost,
 BigDecimal salesTax,
 List<OrderItem> items)

nextId

private int nextId(Connection conn,
 String sql)
            throws SQLException

Throws:

SQLException