Package 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	Description
protected static java.lang.String	EXCLUDE_CAT_WHERE
protected static java.lang.String	EXCLUDE_NULL_PRODUCT_PROMOTIONS
protected static java.lang.String	EXCLUDE_NULL_RESULTS_PROMOTIONS
protected static java.lang.String	EXCLUDE_PRODUCTS_WHERE
protected static java.lang.String	FILTER_BY_RULE_AND_MODULE_NAME
protected static java.lang.String	FIND_PROMOTIONS_CAT_QUERY
protected static java.lang.String	FIND_PROMOTIONS_CAT_SELECT
protected static java.lang.String	FIND_PROMOTIONS_CAT_WHERE
protected static java.lang.String	FIND_PROMOTIONS_COMB_CAT_QUERY
protected static java.lang.String	FIND_PROMOTIONS_PROD_QUERY
protected static java.lang.String	FIND_PROMOTIONS_PROD_SELECT
protected static java.lang.String	FIND_PROMOTIONS_PROD_WHERE
protected static java.lang.String	FIND_PROMOTIONS_SELECT
protected static java.lang.String	FIND_PROMOTIONS_UNION1
protected static java.lang.String	FIND_PROMOTIONS_UNION2
protected static java.lang.String	FIND_PROMOTIONS_UNION3
protected static java.lang.String	FIND_PROMOTIONS_WHERE1
protected static java.lang.String	FIND_PROMOTIONS_WHERE2
protected static java.lang.String	FIND_PROMOTIONS_WITHIN_START_END_DATES
protected static java.lang.String	FIND_PUBLISHED_PROMOTIONS
protected static java.lang.String	GET_ALL_CATEGORIES_FOR_RULE
protected static java.lang.String	GET_ALL_CATEGORIES_FOR_RULE_AND_MODULE
protected static java.lang.String	GET_ALL_COMBINED_CATS_FOR_RULE
protected static java.lang.String	GET_ALL_COMBINED_CATS_FOR_RULE_AND_MODULE
protected static java.lang.String	GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE
protected static java.lang.String	GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE_AND_MODULE
protected static java.lang.String	GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE
protected static java.lang.String	GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE_AND_MODULE
protected static java.lang.String	GET_ALL_PRODUCTS_FOR_RULE
protected static java.lang.String	GET_ALL_PRODUCTS_FOR_RULE_AND_MODULE
protected static java.lang.String	GET_LAST_CONDITIONID_FOR_RULE
protected static java.lang.String	RULE_CODE_PARAM

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

flexibleSearchService, modelService

Constructor Summary

Constructors

Constructor	Description
DefaultPromotionSourceRuleDao()

Method Summary

Modifier and Type	Method	Description
java.util.List<CatForPromotionSourceRuleModel>	findAllCatForPromotionSourceRule(PromotionSourceRuleModel rule, java.lang.String baseName)	Get all CatForPromotionSourceRuleModels for given promotion source rule and module name
java.util.List<CombinedCatsForRuleModel>	findAllCombinedCatsForRule(PromotionSourceRuleModel rule, java.lang.String baseName)	Get all CombinedCatsForRuleModels for given promotion source rule.
java.util.List<ExcludedCatForRuleModel>	findAllExcludedCatForPromotionSourceRule(PromotionSourceRuleModel rule, java.lang.String baseName)	Get all ExcludedCatForRuleModels for given promotion source rule.
java.util.List<ExcludedProductForRuleModel>	findAllExcludedProductForPromotionSourceRule(PromotionSourceRuleModel rule, java.lang.String baseName)	Get all ExcludedProductForRuleModel for given promotion source rule.
java.util.List<ProductForPromotionSourceRuleModel>	findAllProductForPromotionSourceRule(PromotionSourceRuleModel rule, java.lang.String baseName)	Get all ProductForPromotionSourceRuleModels for given promotion source rule and module name.
java.lang.Integer	findLastConditionIdForRule(PromotionSourceRuleModel rule)	Get max conditionId in CombinedCatsForRule for one rule.
java.util.List<RuleBasedPromotionModel>	findPromotions(java.util.Collection<PromotionGroupModel> promotionGroups, java.lang.String productCode, java.util.Set<java.lang.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).
protected java.util.List<RuleBasedPromotionModel>	findPromotions(java.util.Collection<PromotionGroupModel> promotionGroups, java.lang.String productCode, java.util.Set<java.lang.String> categoryCodes, java.util.Date currentDate)

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

FILTER_BY_RULE_AND_MODULE_NAME

protected static final java.lang.String FILTER_BY_RULE_AND_MODULE_NAME

See Also:

Constant Field Values

GET_ALL_PRODUCTS_FOR_RULE

protected static final java.lang.String GET_ALL_PRODUCTS_FOR_RULE

See Also:

Constant Field Values

GET_ALL_PRODUCTS_FOR_RULE_AND_MODULE

protected static final java.lang.String GET_ALL_PRODUCTS_FOR_RULE_AND_MODULE

See Also:

Constant Field Values

GET_ALL_CATEGORIES_FOR_RULE

protected static final java.lang.String GET_ALL_CATEGORIES_FOR_RULE

See Also:

Constant Field Values

GET_ALL_CATEGORIES_FOR_RULE_AND_MODULE

protected static final java.lang.String GET_ALL_CATEGORIES_FOR_RULE_AND_MODULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE

protected static final java.lang.String GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE_AND_MODULE

protected static final java.lang.String GET_ALL_EXCLUDED_CATEGORIES_FOR_RULE_AND_MODULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE

protected static final java.lang.String GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE

See Also:

Constant Field Values

GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE_AND_MODULE

protected static final java.lang.String GET_ALL_EXCLUDED_PRODUCTS_FOR_RULE_AND_MODULE

See Also:

Constant Field Values

GET_ALL_COMBINED_CATS_FOR_RULE

protected static final java.lang.String GET_ALL_COMBINED_CATS_FOR_RULE

See Also:

Constant Field Values

GET_ALL_COMBINED_CATS_FOR_RULE_AND_MODULE

protected static final java.lang.String GET_ALL_COMBINED_CATS_FOR_RULE_AND_MODULE

See Also:

Constant Field Values

GET_LAST_CONDITIONID_FOR_RULE

protected static final java.lang.String GET_LAST_CONDITIONID_FOR_RULE

See Also:

Constant Field Values

FIND_PROMOTIONS_SELECT

protected static final java.lang.String FIND_PROMOTIONS_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_WHERE1

protected static final java.lang.String FIND_PROMOTIONS_WHERE1

See Also:

Constant Field Values

FIND_PROMOTIONS_WHERE2

protected static final java.lang.String FIND_PROMOTIONS_WHERE2

See Also:

Constant Field Values

FIND_PROMOTIONS_WITHIN_START_END_DATES

protected static final java.lang.String FIND_PROMOTIONS_WITHIN_START_END_DATES

See Also:

Constant Field Values

FIND_PUBLISHED_PROMOTIONS

protected static final java.lang.String FIND_PUBLISHED_PROMOTIONS

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_SELECT

protected static final java.lang.String FIND_PROMOTIONS_PROD_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_WHERE

protected static final java.lang.String FIND_PROMOTIONS_PROD_WHERE

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_SELECT

protected static final java.lang.String FIND_PROMOTIONS_CAT_SELECT

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_WHERE

protected static final java.lang.String FIND_PROMOTIONS_CAT_WHERE

See Also:

Constant Field Values

FIND_PROMOTIONS_COMB_CAT_QUERY

protected static final java.lang.String FIND_PROMOTIONS_COMB_CAT_QUERY

See Also:

Constant Field Values

EXCLUDE_PRODUCTS_WHERE

protected static final java.lang.String EXCLUDE_PRODUCTS_WHERE

See Also:

Constant Field Values

EXCLUDE_CAT_WHERE

protected static final java.lang.String EXCLUDE_CAT_WHERE

See Also:

Constant Field Values

EXCLUDE_NULL_PRODUCT_PROMOTIONS

protected static final java.lang.String EXCLUDE_NULL_PRODUCT_PROMOTIONS

See Also:

Constant Field Values

EXCLUDE_NULL_RESULTS_PROMOTIONS

protected static final java.lang.String EXCLUDE_NULL_RESULTS_PROMOTIONS

See Also:

Constant Field Values

FIND_PROMOTIONS_PROD_QUERY

protected static final java.lang.String FIND_PROMOTIONS_PROD_QUERY

See Also:

Constant Field Values

FIND_PROMOTIONS_CAT_QUERY

protected static final java.lang.String FIND_PROMOTIONS_CAT_QUERY

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION1

protected static final java.lang.String FIND_PROMOTIONS_UNION1

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION2

protected static final java.lang.String FIND_PROMOTIONS_UNION2

See Also:

Constant Field Values

FIND_PROMOTIONS_UNION3

protected static final java.lang.String FIND_PROMOTIONS_UNION3

See Also:

Constant Field Values

RULE_CODE_PARAM

protected static final java.lang.String RULE_CODE_PARAM

See Also:

Constant Field Values

Constructor Detail

DefaultPromotionSourceRuleDao

public DefaultPromotionSourceRuleDao()

Method Detail

findAllProductForPromotionSourceRule

public java.util.List<ProductForPromotionSourceRuleModel> findAllProductForPromotionSourceRule(PromotionSourceRuleModel rule,
                                                                                               java.lang.String baseName)

Description copied from interface: PromotionSourceRuleDao

Get all ProductForPromotionSourceRuleModels for given promotion source rule and module name.

Specified by:

findAllProductForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get products for

baseName - KIE base name

Returns:

list of ProductForPromotionSourceRuleModel for given rule

findAllCatForPromotionSourceRule

public java.util.List<CatForPromotionSourceRuleModel> findAllCatForPromotionSourceRule(PromotionSourceRuleModel rule,
                                                                                       java.lang.String baseName)

Description copied from interface: PromotionSourceRuleDao

Get all CatForPromotionSourceRuleModels for given promotion source rule and module name

Specified by:

findAllCatForPromotionSourceRule in interface PromotionSourceRuleDao

Parameters:

rule - PromotionSourceRuleModel to get categories for

baseName - KIE base name

Returns:

list of CatForPromotionSourceRuleModel for given rule

findAllExcludedCatForPromotionSourceRule

public java.util.List<ExcludedCatForRuleModel> findAllExcludedCatForPromotionSourceRule(PromotionSourceRuleModel rule,
                                                                                        java.lang.String baseName)

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

baseName - KIE base name

Returns:

list of ExcludedCatForRuleModel for given rule

findAllCombinedCatsForRule

public java.util.List<CombinedCatsForRuleModel> findAllCombinedCatsForRule(PromotionSourceRuleModel rule,
                                                                           java.lang.String baseName)

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

baseName - KIE base name

Returns:

list of CombinedCatsForRuleModel for given rule

findAllExcludedProductForPromotionSourceRule

public java.util.List<ExcludedProductForRuleModel> findAllExcludedProductForPromotionSourceRule(PromotionSourceRuleModel rule,
                                                                                                java.lang.String baseName)

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

baseName - KIE base name

Returns:

list of ExcludedProductForRuleModel for given rule

findPromotions

public java.util.List<RuleBasedPromotionModel> findPromotions(java.util.Collection<PromotionGroupModel> promotionGroups,
                                                              java.lang.String productCode,
                                                              java.util.Set<java.lang.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).

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 java.lang.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

findPromotions

protected java.util.List<RuleBasedPromotionModel> findPromotions(java.util.Collection<PromotionGroupModel> promotionGroups,
                                                                 java.lang.String productCode,
                                                                 java.util.Set<java.lang.String> categoryCodes,
                                                                 java.util.Date currentDate)