Package 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

Fields

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

Constructor Summary

Constructors

Constructor	Description
ProductGatewayDAOHibernate()

Method Summary

Modifier and Type	Method	Description
int	addCategoryAssociation(String productCode, String categoryCode)
Map	editDeleteProducts(Map parameters, BusinessObjectFactory bof)
private void	initializeSubcategories(Category category)
Collection	loadActiveProductNamesCodesIDs()
Collection	loadAllProductNamesCodesIDs()
Collection	loadAllProducts()
Collection	loadAllProductSettingsInRange(int firstID, int lastID)
Collection	loadAllProductsInRange(int firstID, int lastID)
Collection	loadAllProductsSortedByCode()
Collection	loadAllProductsSortedByName()
Collection	loadAttributeSKUs()
Collection	loadCategoryTree()
Collection	loadItems(Map parameters)
int	loadItemsCount(Map parameters)
int	loadMaxProductID()
int	loadMaxProductSettingID()
Long	loadProductCount()
ProductList	loadProductList(ProductList productList)
Map	loadProductsAndCount(Map parameters)
Collection	loadProductSettings(Collection productIDs)
Collection	loadProductsForCategories(Collection categoryCodes, int firstProductID, int lastProductID)
Collection	loadProductsForIndexing(int firstProductID, int lastProductID)
Collection	loadSkus(Collection productIDs, Collection attributeIDs)
Map	postChangingItemEvent(Object item, Map parameters, BusinessObjectFactory bof)
Collection	processCategorySettings(boolean commit, Map parameters)
Collection	processCategorySettings(Map parameters)
org.hibernate.Criteria	processCommonCriteria(org.hibernate.Criteria crit, Map parameters)
StringBuffer	processCommonHQLSearchClause(StringBuffer query, Map parameters)
Collection	processSettings(boolean commit, Map parameters)
Collection	processSettings(Map parameters)
int	removeCategoryAssociations(String productCode)
void	updateProductAttributeOrders()
void	updateProductCategoryOrders()
void	updateProductsActive(boolean commit, Collection productIDs, boolean isActive)
void	updateProductsActive(Collection productIDs, boolean isActive)
void	updateRelatedProductOrders()

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

editDeleteAssignments, editDeleteItems, incomingPropertiesByIndex, loadItemsAndCount, loadItemsFromIDs, postChangedItemEvent, 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

ProductGatewayDAOHibernate

public ProductGatewayDAOHibernate()

Method Details

loadCategoryTree

public 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 Map loadProductsAndCount(Map parameters)
                         throws Exception

Specified by:

loadProductsAndCount in interface ProductGatewayDAO

Throws:

Exception

loadItems

public Collection loadItems(Map parameters)
                     throws DataAccessException

Overrides:

loadItems in class BaseAdminGatewayDAOHibernate

Throws:

DataAccessException

loadItemsCount

public int loadItemsCount(Map parameters)
                   throws DataAccessException

Overrides:

loadItemsCount in class BaseAdminGatewayDAOHibernate

Throws:

DataAccessException

processCommonHQLSearchClause

public StringBuffer processCommonHQLSearchClause(StringBuffer query,
 Map parameters)

editDeleteProducts

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

Specified by:

editDeleteProducts in interface ProductGatewayDAO

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

loadAllProducts

public Collection loadAllProducts()
                           throws DataAccessException

Specified by:

loadAllProducts in interface ProductGatewayDAO

Throws:

DataAccessException

loadMaxProductID

public int loadMaxProductID()
                     throws Exception

Specified by:

loadMaxProductID in interface ProductGatewayDAO

Throws:

Exception

loadProductsForIndexing

public Collection loadProductsForIndexing(int firstProductID,
 int lastProductID)
                                   throws DataAccessException

Specified by:

loadProductsForIndexing in interface ProductGatewayDAO

Throws:

DataAccessException

loadAllProductsSortedByName

public Collection loadAllProductsSortedByName()
                                       throws Exception

Specified by:

loadAllProductsSortedByName in interface ProductGatewayDAO

Throws:

Exception

loadAllProductsSortedByCode

public Collection loadAllProductsSortedByCode()
                                       throws Exception

Specified by:

loadAllProductsSortedByCode in interface ProductGatewayDAO

Throws:

Exception

loadProductCount

public Long loadProductCount()
                      throws DataAccessException

Specified by:

loadProductCount in interface ProductGatewayDAO

Throws:

DataAccessException

loadAllProductNamesCodesIDs

public Collection loadAllProductNamesCodesIDs()
                                       throws DataAccessException

Specified by:

loadAllProductNamesCodesIDs in interface ProductGatewayDAO

Throws:

DataAccessException

loadActiveProductNamesCodesIDs

public Collection loadActiveProductNamesCodesIDs()
                                          throws DataAccessException

Specified by:

loadActiveProductNamesCodesIDs in interface ProductGatewayDAO

Throws:

DataAccessException

processSettings

public Collection processSettings(Map parameters)
                           throws Exception

Specified by:

processSettings in interface ProductGatewayDAO

Throws:

Exception

processSettings

public Collection processSettings(boolean commit,
 Map parameters)
                           throws Exception

Specified by:

processSettings in interface ProductGatewayDAO

Throws:

Exception

processCategorySettings

public Collection processCategorySettings(Map parameters)
                                   throws Exception

Specified by:

processCategorySettings in interface ProductGatewayDAO

Throws:

Exception

processCategorySettings

public Collection processCategorySettings(boolean commit,
 Map parameters)
                                   throws Exception

Specified by:

processCategorySettings in interface ProductGatewayDAO

Throws:

Exception

loadProductSettings

public Collection loadProductSettings(Collection productIDs)
                               throws Exception

Specified by:

loadProductSettings in interface ProductGatewayDAO

Throws:

Exception

loadSkus

public Collection loadSkus(Collection productIDs,
 Collection attributeIDs)
                    throws Exception

Specified by:

loadSkus in interface ProductGatewayDAO

Throws:

Exception

updateProductsActive

public void updateProductsActive(Collection productIDs,
 boolean isActive)
                          throws Exception

Specified by:

updateProductsActive in interface ProductGatewayDAO

Throws:

Exception

updateProductsActive

public void updateProductsActive(boolean commit,
 Collection productIDs,
 boolean isActive)
                          throws Exception

Specified by:

updateProductsActive in interface ProductGatewayDAO

Throws:

Exception

loadAttributeSKUs

public 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 Collection loadProductsForCategories(Collection categoryCodes,
 int firstProductID,
 int lastProductID)
                                     throws Exception

Specified by:

loadProductsForCategories in interface ProductGatewayDAO

Throws:

Exception

loadAllProductsInRange

public Collection loadAllProductsInRange(int firstID,
 int lastID)
                                  throws Exception

Specified by:

loadAllProductsInRange in interface ProductGatewayDAO

Throws:

Exception

loadMaxProductSettingID

public int loadMaxProductSettingID()
                            throws Exception

Specified by:

loadMaxProductSettingID in interface ProductGatewayDAO

Throws:

Exception

loadAllProductSettingsInRange

public Collection loadAllProductSettingsInRange(int firstID,
 int lastID)
                                         throws Exception

Specified by:

loadAllProductSettingsInRange in interface ProductGatewayDAO

Throws:

Exception

removeCategoryAssociations

public int removeCategoryAssociations(String productCode)
                               throws Exception

Specified by:

removeCategoryAssociations in interface ProductGatewayDAO

Throws:

Exception

addCategoryAssociation

public int addCategoryAssociation(String productCode,
 String categoryCode)
                           throws Exception

Specified by:

addCategoryAssociation in interface ProductGatewayDAO

Throws:

Exception