Package com.softslate.commerce.daos.order

Class OrderGatewayDAOHibernate

java.lang.Object

com.softslate.commerce.daos.core.BaseDAO

com.softslate.commerce.daos.core.BaseAdminGatewayDAOHibernate

com.softslate.commerce.daos.order.OrderGatewayDAOHibernate

All Implemented Interfaces:

DAOInterface, OrderGatewayDAO

public class OrderGatewayDAOHibernate
extends BaseAdminGatewayDAOHibernate
implements OrderGatewayDAO

Generic DAO that runs miscellaneous queries related to orders.

Author:

David Tobey

Field Summary

Fields

Modifier and Type	Field	Description
(package private) static org.apache.commons.logging.Log	log

Constructor Summary

Constructors

Constructor	Description
OrderGatewayDAOHibernate()

Method Summary

Modifier and Type	Method	Description
void	deactivateProducts(boolean commit, Collection productsToDeactivate)
void	decrementSKUs(boolean commit, Collection skusToDecrement)
int	deleteIncompleteOrders(boolean commit, Map parameters)
protected int	deleteIncompleteOrdersWhileIncrementingInventory(boolean commit, Map parameters)
int	deleteOrderDiscounts(boolean commit, int orderID)
Map	editDeleteOrders(Map parameters, BusinessObjectFactory bof)
Collection	getDiscountsBySkuIDs(Collection skuIDs)
Collection	getGlobalDiscounts()
Collection	getGlobalDiscounts(Collection couponCodes)
Double	getPreviousOrderTotal(int customerID)
Collection	getProductInfoFromCodes(String[] productCodeArray)
Integer	getTimesUsedByCustomer(int discountID, int customerID)
void	incrementOrderSKUs(Order o)	Increments all the SKUs associated with the order items in a given order by the quantity of the item.
void	incrementSKUs(boolean commit, OrderItem orderItem)
void	insertOrderAndDelivery(Order order, OrderDelivery orderDelivery)
void	insertOrderNumber(OrderNumber orderNumber, boolean commit)
Collection<Order>	loadAbandonedCartOrders(String startDate, String endDate, String prevOrdersDate)
Collection<Order>	loadCompletedOrdersByDateRange(String startDate, String endDate, Collection<String> ignoreStatuses)
Collection<Order>	loadCompletedOrdersByLastModifiedAndStatuses(String startDate, String endDate, Collection<String> currentStatuses)
Collection	loadDashboardStatistics()
Collection	loadExport(String startDate, String endDate, boolean allOrders, int firstID, int lastID)
Collection	loadGiftCertificates(Collection couponCodes)
Collection	loadIncompleteOrdersStatistics()
Collection	loadIncompleteOrdersWithPayments(Map parameters)
int	loadMaxOrderID()
Collection	loadMonthlySalesReport(String startDate, String endDate)
Map	loadOrdersAndCount(Map parameters)
Collection	loadSalesByProductReport(String startDate, String endDate, Integer[] productIDs)
Collection	loadShippingDiscounts()
Collection	loadShippingDiscounts(Collection couponCodes)
StatesAndCountries	loadStatesAndCountries(StatesAndCountries statesAndCountries)
void	markOrderComplete(Order order, Map parameters)
Map	postChangedItemEvent(Object item, Map parameters, BusinessObjectFactory bof)
Map	postChangingItemEvent(Object item, Map parameters, BusinessObjectFactory bof)
org.hibernate.Criteria	processCommonCriteria(org.hibernate.Criteria crit, Map parameters)
void	processOrderComplete(Order order, Map parameters)
void	processOrderItems(User user, Collection newOrderItems, Map parameters)
void	removeOrderItem(Order order, OrderDelivery orderDelivery, OrderItem orderItem)
void	updateOrderAndDelivery(boolean commit, Order order, OrderDelivery orderDelivery)

Methods inherited from class com.softslate.commerce.daos.core.BaseAdminGatewayDAOHibernate

editDeleteAssignments, editDeleteItems, incomingPropertiesByIndex, loadItems, loadItemsAndCount, loadItemsCount, loadItemsFromIDs, setPropertiesDynamically

Methods inherited from class com.softslate.commerce.daos.core.BaseDAO

deleteObject, doWorkToSetConnection, editAssignment, evictCache, formatDateTime, getAppComponents, getAppSettings, getConnection, getDaoFactory, getDAOUtils, getDataSource, getImportExportSQL, getImportExportSqlMap, getInjector, getNamedQuery, getSettings, getSQL, getSqlMap, initialize, insertObject, loadAll, loadAll, loadObject, parseDateTime, setAppComponents, setAppSettings, setConnection, setDaoFactory, setDAOUtils, setDataSource, setImportExportSqlMap, setInjector, setSettings, setSqlMap, updateObject

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.softslate.commerce.daos.core.DAOInterface

deleteObject, formatDateTime, getAppComponents, getAppSettings, getConnection, getDaoFactory, getDAOUtils, getDataSource, getInjector, getSettings, getSqlMap, initialize, insertObject, loadAll, loadAll, loadObject, parseDateTime, setAppComponents, setAppSettings, setConnection, setDaoFactory, setDAOUtils, setDataSource, setInjector, setSettings, setSqlMap, updateObject

Field Details

log

static org.apache.commons.logging.Log log

Constructor Details

OrderGatewayDAOHibernate

public OrderGatewayDAOHibernate()

Method Details

loadStatesAndCountries

public StatesAndCountries loadStatesAndCountries(StatesAndCountries statesAndCountries)
                                          throws DataAccessException

Specified by:

loadStatesAndCountries in interface OrderGatewayDAO

Throws:

DataAccessException

loadDashboardStatistics

public Collection loadDashboardStatistics()
                                   throws DataAccessException

Specified by:

loadDashboardStatistics in interface OrderGatewayDAO

Throws:

DataAccessException

loadIncompleteOrdersStatistics

public Collection loadIncompleteOrdersStatistics()
                                          throws DataAccessException

Specified by:

loadIncompleteOrdersStatistics in interface OrderGatewayDAO

Throws:

DataAccessException

deleteIncompleteOrders

public int deleteIncompleteOrders(boolean commit,
 Map parameters)
                           throws DataAccessException

Specified by:

deleteIncompleteOrders in interface OrderGatewayDAO

Throws:

DataAccessException

deleteIncompleteOrdersWhileIncrementingInventory

protected int deleteIncompleteOrdersWhileIncrementingInventory(boolean commit,
 Map parameters)
                                                        throws DataAccessException

Throws:

DataAccessException

insertOrderAndDelivery

public void insertOrderAndDelivery(Order order,
 OrderDelivery orderDelivery)
                            throws Exception

Specified by:

insertOrderAndDelivery in interface OrderGatewayDAO

Throws:

Exception

getProductInfoFromCodes

public Collection getProductInfoFromCodes(String[] productCodeArray)
                                   throws Exception

Specified by:

getProductInfoFromCodes in interface OrderGatewayDAO

Throws:

Exception

processOrderItems

public void processOrderItems(User user,
 Collection newOrderItems,
 Map parameters)
                       throws Exception

Specified by:

processOrderItems in interface OrderGatewayDAO

Throws:

Exception

decrementSKUs

public void decrementSKUs(boolean commit,
 Collection skusToDecrement)
                   throws Exception

Throws:

Exception

incrementSKUs

public void incrementSKUs(boolean commit,
 OrderItem orderItem)
                   throws Exception

Throws:

Exception

incrementOrderSKUs

public void incrementOrderSKUs(Order o)
                        throws Exception

Increments all the SKUs associated with the order items in a given order by the quantity of the item. Used to refresh the SKU inventory levels when incomplete orders are deleted, if the inventory decrement behavior is set to decrement upon adding items to the cart.

Parameters:

o - The Order being processed.

Throws:

Exception

deactivateProducts

public void deactivateProducts(boolean commit,
 Collection productsToDeactivate)
                        throws Exception

Throws:

Exception

removeOrderItem

public void removeOrderItem(Order order,
 OrderDelivery orderDelivery,
 OrderItem orderItem)
                     throws Exception

Specified by:

removeOrderItem in interface OrderGatewayDAO

Throws:

Exception

updateOrderAndDelivery

public void updateOrderAndDelivery(boolean commit,
 Order order,
 OrderDelivery orderDelivery)
                            throws Exception

Specified by:

updateOrderAndDelivery in interface OrderGatewayDAO

Throws:

Exception

loadOrdersAndCount

public Map loadOrdersAndCount(Map parameters)
                       throws Exception

Specified by:

loadOrdersAndCount in interface OrderGatewayDAO

Throws:

Exception

editDeleteOrders

public Map editDeleteOrders(Map parameters,
 BusinessObjectFactory bof)
                     throws Exception

Specified by:

editDeleteOrders in interface OrderGatewayDAO

Throws:

Exception

processCommonCriteria

public org.hibernate.Criteria processCommonCriteria(org.hibernate.Criteria crit,
 Map parameters)

Overrides:

processCommonCriteria in class BaseAdminGatewayDAOHibernate

postChangingItemEvent

public Map postChangingItemEvent(Object item,
 Map parameters,
 BusinessObjectFactory bof)
                          throws Exception

Overrides:

postChangingItemEvent in class BaseAdminGatewayDAOHibernate

Throws:

Exception

postChangedItemEvent

public Map postChangedItemEvent(Object item,
 Map parameters,
 BusinessObjectFactory bof)
                         throws Exception

Overrides:

postChangedItemEvent in class BaseAdminGatewayDAOHibernate

Throws:

Exception

processOrderComplete

public void processOrderComplete(Order order,
 Map parameters)
                          throws Exception

Specified by:

processOrderComplete in interface OrderGatewayDAO

Throws:

Exception

insertOrderNumber

public void insertOrderNumber(OrderNumber orderNumber,
 boolean commit)
                       throws DataAccessException

Specified by:

insertOrderNumber in interface OrderGatewayDAO

Throws:

DataAccessException

markOrderComplete

public void markOrderComplete(Order order,
 Map parameters)
                       throws Exception

Specified by:

markOrderComplete in interface OrderGatewayDAO

Throws:

Exception

deleteOrderDiscounts

public int deleteOrderDiscounts(boolean commit,
 int orderID)
                         throws DataAccessException

Specified by:

deleteOrderDiscounts in interface OrderGatewayDAO

Throws:

DataAccessException

getDiscountsBySkuIDs

public Collection getDiscountsBySkuIDs(Collection skuIDs)
                                throws Exception

Specified by:

getDiscountsBySkuIDs in interface OrderGatewayDAO

Throws:

Exception

getPreviousOrderTotal

public Double getPreviousOrderTotal(int customerID)
                             throws Exception

Specified by:

getPreviousOrderTotal in interface OrderGatewayDAO

Throws:

Exception

getTimesUsedByCustomer

public Integer getTimesUsedByCustomer(int discountID,
 int customerID)
                               throws Exception

Specified by:

getTimesUsedByCustomer in interface OrderGatewayDAO

Throws:

Exception

getGlobalDiscounts

public Collection getGlobalDiscounts()
                              throws Exception

Specified by:

getGlobalDiscounts in interface OrderGatewayDAO

Throws:

Exception

getGlobalDiscounts

public Collection getGlobalDiscounts(Collection couponCodes)
                              throws Exception

Specified by:

getGlobalDiscounts in interface OrderGatewayDAO

Throws:

Exception

loadShippingDiscounts

public Collection loadShippingDiscounts()
                                 throws Exception

Throws:

Exception

loadShippingDiscounts

public Collection loadShippingDiscounts(Collection couponCodes)
                                 throws Exception

Specified by:

loadShippingDiscounts in interface OrderGatewayDAO

Throws:

Exception

loadGiftCertificates

public Collection loadGiftCertificates(Collection couponCodes)
                                throws Exception

Specified by:

loadGiftCertificates in interface OrderGatewayDAO

Throws:

Exception

loadExport

public Collection loadExport(String startDate,
 String endDate,
 boolean allOrders,
 int firstID,
 int lastID)
                      throws Exception

Specified by:

loadExport in interface OrderGatewayDAO

Throws:

Exception

loadSalesByProductReport

public Collection loadSalesByProductReport(String startDate,
 String endDate,
 Integer[] productIDs)
                                    throws DataAccessException

Specified by:

loadSalesByProductReport in interface OrderGatewayDAO

Throws:

DataAccessException

loadMonthlySalesReport

public Collection loadMonthlySalesReport(String startDate,
 String endDate)
                                  throws DataAccessException

Specified by:

loadMonthlySalesReport in interface OrderGatewayDAO

Throws:

DataAccessException

loadMaxOrderID

public int loadMaxOrderID()
                   throws Exception

Specified by:

loadMaxOrderID in interface OrderGatewayDAO

Throws:

Exception

loadIncompleteOrdersWithPayments

public Collection loadIncompleteOrdersWithPayments(Map parameters)
                                            throws DataAccessException

Specified by:

loadIncompleteOrdersWithPayments in interface OrderGatewayDAO

Throws:

DataAccessException

loadCompletedOrdersByDateRange

public Collection<Order> loadCompletedOrdersByDateRange(String startDate,
 String endDate,
 Collection<String> ignoreStatuses)
                                                 throws DataAccessException

Specified by:

loadCompletedOrdersByDateRange in interface OrderGatewayDAO

Throws:

DataAccessException

loadAbandonedCartOrders

public Collection<Order> loadAbandonedCartOrders(String startDate,
 String endDate,
 String prevOrdersDate)
                                          throws DataAccessException

Specified by:

loadAbandonedCartOrders in interface OrderGatewayDAO

Throws:

DataAccessException

loadCompletedOrdersByLastModifiedAndStatuses

public Collection<Order> loadCompletedOrdersByLastModifiedAndStatuses(String startDate,
 String endDate,
 Collection<String> currentStatuses)
                                                               throws DataAccessException

Specified by:

loadCompletedOrdersByLastModifiedAndStatuses in interface OrderGatewayDAO

Throws:

DataAccessException