com.softslate.commerce.daos.product
Class ProductGatewayDAOHibernate

java.lang.Object
  com.softslate.commerce.daos.core.BaseDAO
      com.softslate.commerce.daos.core.BaseAdminGatewayDAOHibernate
          com.softslate.commerce.daos.product.ProductGatewayDAOHibernate

All Implemented Interfaces:

DAOInterface, ProductGatewayDAO

public class ProductGatewayDAOHibernate
extends BaseAdminGatewayDAOHibernate
implements ProductGatewayDAO

Generic DAO that runs miscellaneous queries related to products and categories.

Author:

David Tobey

Field Summary

(package private) static org.apache.commons.logging.Log

log

Constructor Summary

ProductGatewayDAOHibernate()

Method Summary

void	editDeleteProducts(java.util.Map parameters, BusinessObjectFactory bof)
private void	initializeSubcategories(Category category)
java.util.Collection	loadActiveProductNamesCodesIDs()
java.util.Collection	loadAllProductNamesCodesIDs()
java.util.Collection	loadAllProducts()
java.util.Collection	loadAllProductsInRange(int firstID, int lastID)
java.util.Collection	loadAllProductsSortedByCode()
java.util.Collection	loadAllProductsSortedByName()
java.util.Collection	loadAttributeSKUs()
java.util.Collection	loadCategoryTree()
java.util.Collection	loadItems(java.util.Map parameters)
int	loadItemsCount(java.util.Map parameters)
int	loadMaxProductID()
java.lang.Long	loadProductCount()
ProductList	loadProductList(ProductList productList)
java.util.Map	loadProductsAndCount(java.util.Map parameters)
java.util.Collection	loadProductSettings(java.util.Collection productIDs)
java.util.Collection	loadProductsForCategories(java.util.Collection categoryCodes, int firstProductID, int lastProductID)
java.util.Collection	loadProductsForIndexing(int firstProductID, int lastProductID)
java.util.Collection	loadSkus(java.util.Collection productIDs, java.util.Collection attributeIDs)
java.util.Collection	processCategorySettings(boolean commit, java.util.Map parameters)
java.util.Collection	processCategorySettings(java.util.Map parameters)
org.hibernate.Criteria	processCommonCriteria(org.hibernate.Criteria crit, java.util.Map parameters)
java.lang.StringBuffer	processCommonHQLSearchClause(java.lang.StringBuffer query, java.util.Map parameters)
java.util.Collection	processSettings(boolean commit, java.util.Map parameters)
java.util.Collection	processSettings(java.util.Map parameters)
void	updateProductAttributeOrders()
void	updateProductCategoryOrders()
void	updateProductsActive(boolean commit, java.util.Collection productIDs, boolean isActive)
void	updateProductsActive(java.util.Collection productIDs, boolean isActive)
void	updateRelatedProductOrders()

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

editDeleteAssignments, editDeleteItems, loadItemsAndCount, loadItemsFromIDs, setPropertiesDynamically

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

deleteObject, evictCache, formatDateTime, getAppComponents, getAppSettings, getConnection, getDaoFactory, getDAOUtils, getDataSource, getImportExportSQL, getImportExportSqlMap, getNamedQuery, getSettings, getSQL, getSqlMap, initialize, insertObject, loadAll, loadAll, loadObject, parseDateTime, setAppComponents, setAppSettings, setConnection, setDaoFactory, setDAOUtils, setDataSource, setImportExportSqlMap, 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, getAppComponents, getAppSettings, getConnection, getDaoFactory, getDAOUtils, getDataSource, getSettings, getSqlMap, initialize, insertObject, loadAll, loadAll, loadObject, setAppComponents, setAppSettings, setConnection, setDaoFactory, setDAOUtils, setDataSource, setSettings, setSqlMap, updateObject

Field Detail

log

static org.apache.commons.logging.Log log

Constructor Detail

ProductGatewayDAOHibernate

public ProductGatewayDAOHibernate()

Method Detail

loadCategoryTree

public java.util.Collection loadCategoryTree()
                                      throws DataAccessException

Specified by:

loadCategoryTree in interface ProductGatewayDAO

Throws:

DataAccessException

initializeSubcategories

private void initializeSubcategories(Category category)

loadProductList

public ProductList loadProductList(ProductList productList)
                            throws DataAccessException

Specified by:

loadProductList in interface ProductGatewayDAO

Throws:

DataAccessException

loadProductsAndCount

public java.util.Map loadProductsAndCount(java.util.Map parameters)
                                   throws java.lang.Exception

Specified by:

loadProductsAndCount in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadItems

public java.util.Collection loadItems(java.util.Map parameters)
                               throws DataAccessException

Overrides:

loadItems in class BaseAdminGatewayDAOHibernate

Throws:

DataAccessException

loadItemsCount

public int loadItemsCount(java.util.Map parameters)
                   throws DataAccessException

Overrides:

loadItemsCount in class BaseAdminGatewayDAOHibernate

Throws:

DataAccessException

processCommonHQLSearchClause

public java.lang.StringBuffer processCommonHQLSearchClause(java.lang.StringBuffer query,
                                                           java.util.Map parameters)

editDeleteProducts

public void editDeleteProducts(java.util.Map parameters,
                               BusinessObjectFactory bof)
                        throws java.lang.Exception

Specified by:

editDeleteProducts in interface ProductGatewayDAO

Throws:

java.lang.Exception

processCommonCriteria

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

Overrides:

processCommonCriteria in class BaseAdminGatewayDAOHibernate

loadAllProducts

public java.util.Collection loadAllProducts()
                                     throws DataAccessException

Specified by:

loadAllProducts in interface ProductGatewayDAO

Throws:

DataAccessException

loadMaxProductID

public int loadMaxProductID()
                     throws java.lang.Exception

Specified by:

loadMaxProductID in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadProductsForIndexing

public java.util.Collection loadProductsForIndexing(int firstProductID,
                                                    int lastProductID)
                                             throws DataAccessException

Specified by:

loadProductsForIndexing in interface ProductGatewayDAO

Throws:

DataAccessException

loadAllProductsSortedByName

public java.util.Collection loadAllProductsSortedByName()
                                                 throws java.lang.Exception

Specified by:

loadAllProductsSortedByName in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadAllProductsSortedByCode

public java.util.Collection loadAllProductsSortedByCode()
                                                 throws java.lang.Exception

Specified by:

loadAllProductsSortedByCode in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadProductCount

public java.lang.Long loadProductCount()
                                throws DataAccessException

Specified by:

loadProductCount in interface ProductGatewayDAO

Throws:

DataAccessException

loadAllProductNamesCodesIDs

public java.util.Collection loadAllProductNamesCodesIDs()
                                                 throws DataAccessException

Specified by:

loadAllProductNamesCodesIDs in interface ProductGatewayDAO

Throws:

DataAccessException

loadActiveProductNamesCodesIDs

public java.util.Collection loadActiveProductNamesCodesIDs()
                                                    throws DataAccessException

Specified by:

loadActiveProductNamesCodesIDs in interface ProductGatewayDAO

Throws:

DataAccessException

processSettings

public java.util.Collection processSettings(java.util.Map parameters)
                                     throws java.lang.Exception

Specified by:

processSettings in interface ProductGatewayDAO

Throws:

java.lang.Exception

processSettings

public java.util.Collection processSettings(boolean commit,
                                            java.util.Map parameters)
                                     throws java.lang.Exception

Specified by:

processSettings in interface ProductGatewayDAO

Throws:

java.lang.Exception

processCategorySettings

public java.util.Collection processCategorySettings(java.util.Map parameters)
                                             throws java.lang.Exception

Specified by:

processCategorySettings in interface ProductGatewayDAO

Throws:

java.lang.Exception

processCategorySettings

public java.util.Collection processCategorySettings(boolean commit,
                                                    java.util.Map parameters)
                                             throws java.lang.Exception

Specified by:

processCategorySettings in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadProductSettings

public java.util.Collection loadProductSettings(java.util.Collection productIDs)
                                         throws java.lang.Exception

Specified by:

loadProductSettings in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadSkus

public java.util.Collection loadSkus(java.util.Collection productIDs,
                                     java.util.Collection attributeIDs)
                              throws java.lang.Exception

Specified by:

loadSkus in interface ProductGatewayDAO

Throws:

java.lang.Exception

updateProductsActive

public void updateProductsActive(java.util.Collection productIDs,
                                 boolean isActive)
                          throws java.lang.Exception

Specified by:

updateProductsActive in interface ProductGatewayDAO

Throws:

java.lang.Exception

updateProductsActive

public void updateProductsActive(boolean commit,
                                 java.util.Collection productIDs,
                                 boolean isActive)
                          throws java.lang.Exception

Specified by:

updateProductsActive in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadAttributeSKUs

public java.util.Collection loadAttributeSKUs()
                                       throws DataAccessException

Specified by:

loadAttributeSKUs in interface ProductGatewayDAO

Throws:

DataAccessException

updateProductCategoryOrders

public void updateProductCategoryOrders()
                                 throws DataAccessException

Specified by:

updateProductCategoryOrders in interface ProductGatewayDAO

Throws:

DataAccessException

updateProductAttributeOrders

public void updateProductAttributeOrders()
                                  throws DataAccessException

Specified by:

updateProductAttributeOrders in interface ProductGatewayDAO

Throws:

DataAccessException

updateRelatedProductOrders

public void updateRelatedProductOrders()
                                throws DataAccessException

Specified by:

updateRelatedProductOrders in interface ProductGatewayDAO

Throws:

DataAccessException

loadProductsForCategories

public java.util.Collection loadProductsForCategories(java.util.Collection categoryCodes,
                                                      int firstProductID,
                                                      int lastProductID)
                                               throws java.lang.Exception

Specified by:

loadProductsForCategories in interface ProductGatewayDAO

Throws:

java.lang.Exception

loadAllProductsInRange

public java.util.Collection loadAllProductsInRange(int firstID,
                                                   int lastID)
                                            throws java.lang.Exception

Specified by:

loadAllProductsInRange in interface ProductGatewayDAO

Throws:

java.lang.Exception