de.hybris.platform.promotionengineservices.dao.impl

Class DefaultPromotionSourceRuleDao

java.lang.Object

de.hybris.platform.servicelayer.internal.dao.AbstractItemDao

de.hybris.platform.promotionengineservices.dao.impl.DefaultPromotionSourceRuleDao

All Implemented Interfaces:

PromotionSourceRuleDao, Dao

public class DefaultPromotionSourceRuleDao
extends AbstractItemDao
implements PromotionSourceRuleDao

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	EXCLUDE_CAT_WHERE
protected static String	EXCLUDE_PRODUCTS_WHERE
protected static String	FIND_PROMOTIONS_CAT_QUERY
protected static String	FIND_PROMOTIONS_CAT_SELECT
protected static String	FIND_PROMOTIONS_CAT_WHERE
protected static String	FIND_PROMOTIONS_COMB_CAT_QUERY
protected static String	FIND_PROMOTIONS_PROD_QUERY
protected static String	FIND_PROMOTIONS_PROD_SELECT
protected static String	FIND_PROMOTIONS_PROD_WHERE
protected static String	FIND_PROMOTIONS_SELECT
protected static String	FIND_PROMOTIONS_UNION1
protected static String	FIND_PROMOTIONS_UNION2
protected static String	FIND_PROMOTIONS_UNION3
protected static String	FIND_PROMOTIONS_WHERE1
protected static String	FIND_PROMOTIONS_WHERE2
protected static String	FIND_PROMOTIONS_WITHIN_START_END_DATES
protected static String	FIND_PUBLISHED_PROMOTIONS
protected static String	GET_ALL_CATEGORIES_FOR_RULE
protected static String	GET_ALL_COMBINED_CATS_FOR_RULE
protected static String	GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE
protected static String	GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE
protected static String	GET_ALL_PRODUCTS_FOR_RULE
protected static String	GET_LAST_CONDITIONID_FOR_RULE

Fields inherited from class de.hybris.platform.servicelayer.internal.dao.AbstractItemDao

flexibleSearchService, modelService

Constructor Summary

Constructors

Constructor and Description
DefaultPromotionSourceRuleDao()

Method Summary

Modifier and Type	Method and Description
List<CatForPromotionSourceRuleModel>	findAllCatForPromotionSourceRule(PromotionSourceRuleModel rule) Get all CatForPromotionSourceRuleModels for given promotion source rule.
List<CombinedCatsForRuleModel>	findAllCombinedCatsForRule(PromotionSourceRuleModel rule) Get all CombinedCatsForRuleModels for given promotion source rule.
List<ExcludedCatForRuleModel>	findAllExcludedCatForPromotionSourceRule(PromotionSourceRuleModel rule) Get all ExcludedCatForRuleModels for given promotion source rule.
List<ExcludedProductForRuleModel>	findAllExcludedProductForPromotionSourceRule(PromotionSourceRuleModel rule) Get all ExcludedProductForRuleModel for given promotion source rule.
List<ProductForPromotionSourceRuleModel>	findAllProductForPromotionSourceRule(PromotionSourceRuleModel rule) Get all ProductForPromotionSourceRuleModels for given promotion source rule.
Integer	findLastConditionIdForRule(PromotionSourceRuleModel rule) Get max conditionId in CombinedCatsForRule for one rule.
List<RuleBasedPromotionModel>	findPromotions(Collection<PromotionGroupModel> promotionGroups, String productCode, Set<String> categoryCodes) Finds RuleBasedPromotionModels for given product code and category codes (but will exclude all rules for which the corresponding PromotionSourceRuleModel.getExcludeFromStorefrontDisplay() is set to true OR current date is out of AbstractRuleModel.getStartDate(), AbstractRuleModel.getEndDate() date range OR the rule status AbstractRuleModel.getStatus() is not PUBLISHED or MODIFIED).

Methods inherited from class de.hybris.platform.servicelayer.internal.dao.AbstractItemDao

getAllSources, getFlexibleSearchService, getModelService, getSource, load, loadAll, search, search, searchUnique, setFlexibleSearchService, setModelService

Methods inherited from class java.lang.Object

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

Field Detail

GET_ALL_PRODUCTS_FOR_RULE

protected static final String GET_ALL_PRODUCTS_FOR_RULE

See Also:

Constant Field Values

GET_ALL_CATEGORIES_FOR_RULE

protected static final String GET_ALL_CATEGORIES_FOR_RULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE

protected static final String GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE

protected static final String GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE

See Also:

Constant Field Values

GET_ALL_COMBINED_CATS_FOR_RULE

protected static final String GET_ALL_COMBINED_CATS_FOR_RULE

See Also:

Constant Field Values

GET_LAST_CONDITIONID_FOR_RULE

protected static final String GET_LAST_CONDITIONID_FOR_RULE

See Also:

Constant Field Values

FIND_PROMOTIONS_SELECT

protected static final String FIND_PROMOTIONS_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_WHERE1

protected static final String FIND_PROMOTIONS_WHERE1

See Also:

Constant Field Values

FIND_PROMOTIONS_WHERE2

protected static final String FIND_PROMOTIONS_WHERE2

See Also:

Constant Field Values

FIND_PROMOTIONS_WITHIN_START_END_DATES

protected static final String FIND_PROMOTIONS_WITHIN_START_END_DATES

See Also:

Constant Field Values

FIND_PUBLISHED_PROMOTIONS

protected static final String FIND_PUBLISHED_PROMOTIONS

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_SELECT

protected static final String FIND_PROMOTIONS_PROD_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_WHERE

protected static final String FIND_PROMOTIONS_PROD_WHERE

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_SELECT

protected static final String FIND_PROMOTIONS_CAT_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_WHERE

protected static final String FIND_PROMOTIONS_CAT_WHERE

See Also:

Constant Field Values

FIND_PROMOTIONS_COMB_CAT_QUERY

protected static final String FIND_PROMOTIONS_COMB_CAT_QUERY

See Also:

Constant Field Values

EXCLUDE_PRODUCTS_WHERE

protected static final String EXCLUDE_PRODUCTS_WHERE

See Also:

Constant Field Values

EXCLUDE_CAT_WHERE

protected static final String EXCLUDE_CAT_WHERE

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_QUERY

protected static final String FIND_PROMOTIONS_PROD_QUERY

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_QUERY

protected static final String FIND_PROMOTIONS_CAT_QUERY

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION1

protected static final String FIND_PROMOTIONS_UNION1

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION2

protected static final String FIND_PROMOTIONS_UNION2

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION3

protected static final String FIND_PROMOTIONS_UNION3

See Also:

Constant Field Values

Constructor Detail

DefaultPromotionSourceRuleDao

public DefaultPromotionSourceRuleDao()

Method Detail

findAllProductForPromotionSourceRule

public List<ProductForPromotionSourceRuleModel> findAllProductForPromotionSourceRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get all ProductForPromotionSourceRuleModels for given promotion source rule.

Specified by:

findAllProductForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get products for

Returns:

list of ProductForPromotionSourceRuleModel for given rule

findAllCatForPromotionSourceRule

public List<CatForPromotionSourceRuleModel> findAllCatForPromotionSourceRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get all CatForPromotionSourceRuleModels for given promotion source rule.

Specified by:

findAllCatForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get categories for

Returns:

list of CatForPromotionSourceRuleModel for given rule

findAllExcludedCatForPromotionSourceRule

public List<ExcludedCatForRuleModel> findAllExcludedCatForPromotionSourceRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get all ExcludedCatForRuleModels for given promotion source rule.

Specified by:

findAllExcludedCatForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get excluded categories for

Returns:

list of ExcludedCatForRuleModel for given rule

findAllCombinedCatsForRule

public List<CombinedCatsForRuleModel> findAllCombinedCatsForRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get all CombinedCatsForRuleModels for given promotion source rule.

Specified by:

findAllCombinedCatsForRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get excluded categories for

Returns:

list of CombinedCatsForRuleModel for given rule

findAllExcludedProductForPromotionSourceRule

public List<ExcludedProductForRuleModel> findAllExcludedProductForPromotionSourceRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get all ExcludedProductForRuleModel for given promotion source rule.

Specified by:

findAllExcludedProductForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get excluded products for

Returns:

list of ExcludedProductForRuleModel for given rule

findPromotions

public List<RuleBasedPromotionModel> findPromotions(Collection<PromotionGroupModel> promotionGroups,
                                                    String productCode,
                                                    Set<String> categoryCodes)

Description copied from interface: PromotionSourceRuleDao

Finds RuleBasedPromotionModels for given product code and category codes (but will exclude all rules for which the corresponding PromotionSourceRuleModel.getExcludeFromStorefrontDisplay() is set to true OR current date is out of AbstractRuleModel.getStartDate(), AbstractRuleModel.getEndDate() date range OR the rule status AbstractRuleModel.getStatus() is not PUBLISHED or MODIFIED).

Specified by:

findPromotions in interface PromotionSourceRuleDao

Parameters:

promotionGroups - collection of promotion groups to get promotion rules for

productCode - product code to get related source promotion rules

categoryCodes - category codes to get related source promotion rules

Returns:

List of RuleBasedPromotionModel

findLastConditionIdForRule

public Integer findLastConditionIdForRule(PromotionSourceRuleModel rule)

Description copied from interface: PromotionSourceRuleDao

Get max conditionId in CombinedCatsForRule for one rule.

Specified by:

findLastConditionIdForRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get max condition id for

Returns:

Integer representing maximal condition id