ePages 6.10 - DE_EPAGES/Product/API/Table/SelectedVariation.pm

Package DE_EPAGES::Product::API::Table::SelectedVariation

interface for table SelectedVariation

@EXPORT_OK
InsertSelectedVariation
UpdateSelectedVariation
DeleteSelectedVariation
GetAllPKeySelectedVariations
GetAllInfoSelectedVariations
GetInfoSelectedVariation
ExistsSelectedVariation
GetPKeySelectedVariationByProductID
GetInfoSelectedVariationByProductID
ExistsSelectedVariationByProductID
GetPKeySelectedVariationsByProductID
GetInfoSelectedVariationsByProductID
GetPKeySelectedVariationsByAttributeID
GetInfoSelectedVariationsByAttributeID
GetPKeySelectedVariationsByPreDefAttributeID
GetInfoSelectedVariationsByPreDefAttributeID

Functions

DeleteSelectedVariation
ExistsSelectedVariation
ExistsSelectedVariationByProductID
GetAllInfoSelectedVariations
GetAllPKeySelectedVariations
GetInfoSelectedVariation
GetInfoSelectedVariationByProductID
GetInfoSelectedVariationsByAttributeID
GetInfoSelectedVariationsByPreDefAttributeID
GetInfoSelectedVariationsByProductID
GetPKeySelectedVariationByProductID
GetPKeySelectedVariationsByAttributeID
GetPKeySelectedVariationsByPreDefAttributeID
GetPKeySelectedVariationsByProductID
InsertSelectedVariation
OnDeleteAttribute
OnDeletePreDefAttribute
UpdateSelectedVariation

DeleteSelectedVariation

Deletes a(n) SelectedVariation.

Syntax
DeleteSelectedVariation($SelectedVariationID);
DeleteSelectedVariation($hSelectedVariation); # if $hSelectedVariation includes SelectedVariationID
Input
$SelectedVariationID (int)
identifier of loop entry (primary key)

ExistsSelectedVariation

Returns true if the SelectedVariation exists.

Syntax
$exists = ExistsSelectedVariation($SelectedVariationID);
Input
$SelectedVariationID (int)
identifier of loop entry
Return
$exists (boolean)
1/0 the SelectedVariation exists (yes/no)

ExistsSelectedVariationByProductID

Returns true if a SelectedVariation by alternate keys ProductID and PreDefAttributeID exists.

Syntax
$SelectedVariationID = ExistsSelectedVariationByProductID($ProductID, $PreDefAttributeID);
Input
$ProductID (int)
product identifier
$PreDefAttributeID (int)
predefined attribute id
Return
$exists (boolean)
1/0 the u_selectvariation_product exists (yes/no)

GetAllInfoSelectedVariations

Returns all objects of SelectedVariation.

Syntax
$ahSelectedVariations = GetAllInfoSelectedVariations();
Return
$ahSelectedVariations (reference to array of hashes)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetAllPKeySelectedVariations

Returns all SelectedVariation identifiers.

Syntax
$aSelectedVariationIDs = GetAllPKeySelectedVariations();
Return
$aSelectedVariationIDs (reference to array of int)
identifier of loop entry

GetInfoSelectedVariation

Returns the SelectedVariation by identifier.

Syntax
$hSelectedVariation = GetInfoSelectedVariation($SelectedVariationID);
Input
$SelectedVariationID (int)
identifier of loop entry (primary key)
Return
$hSelectedVariation (reference to hash)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetInfoSelectedVariationByProductID

Returns the object of SelectedVariation by alternate keys ProductID and PreDefAttributeID.

Syntax
$hSelectedVariation = GetInfoSelectedVariationByProductID($ProductID, $PreDefAttributeID);
Input
$ProductID (int)
product identifier (optional)
$PreDefAttributeID (int)
predefined attribute id (optional)
Return
$hSelectedVariation (reference to hash)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetInfoSelectedVariationsByAttributeID

Returns objects of SelectedVariation by alternate key AttributeID.

Syntax
$ahSelectedVariations = GetInfoSelectedVariationsByAttributeID($AttributeID);
Input
$AttributeID (int)
attribute id
Return
$ahSelectedVariations (reference to array of hashes)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetInfoSelectedVariationsByPreDefAttributeID

Returns objects of SelectedVariation by alternate key PreDefAttributeID.

Syntax
$ahSelectedVariations = GetInfoSelectedVariationsByPreDefAttributeID($PreDefAttributeID);
Input
$PreDefAttributeID (int)
predefined attribute id
Return
$ahSelectedVariations (reference to array of hashes)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetInfoSelectedVariationsByProductID

Returns objects of SelectedVariation by alternate keys ProductID and PreDefAttributeID.

Syntax
$ahSelectedVariations = GetInfoSelectedVariationsByProductID($ProductID, $PreDefAttributeID);
Input
$ProductID (int)
product identifier
$PreDefAttributeID (int)
predefined attribute id (optional)
Return
$ahSelectedVariations (reference to array of hashes)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int

GetPKeySelectedVariationByProductID

Returns primary key of SelectedVariation by alternate keys ProductID and PreDefAttributeID.

Syntax
$SelectedVariationID = GetPKeySelectedVariationByProductID($ProductID, $PreDefAttributeID);
Input
$ProductID (int)
product identifier
$PreDefAttributeID (int)
predefined attribute id
Return
$SelectedVariationID (int)
identifier of loop entry (primary key)

GetPKeySelectedVariationsByAttributeID

Returns primary keys of SelectedVariation by alternate key AttributeID.

Syntax
$aKeys = GetPKeySelectedVariationsByAttributeID($AttributeID);
Input
$AttributeID (int)
attribute id
Return
$aKeys (reference to array of int)
identifier of loop entry (primary key)

GetPKeySelectedVariationsByPreDefAttributeID

Returns primary keys of SelectedVariation by alternate key PreDefAttributeID.

Syntax
$aKeys = GetPKeySelectedVariationsByPreDefAttributeID($PreDefAttributeID);
Input
$PreDefAttributeID (int)
predefined attribute id
Return
$aKeys (reference to array of int)
identifier of loop entry (primary key)

GetPKeySelectedVariationsByProductID

Returns primary keys of SelectedVariation by alternate keys ProductID and PreDefAttributeID.

Syntax
$aKeys = GetPKeySelectedVariationsByProductID($ProductID, $PreDefAttributeID);
Input
$ProductID (int)
product identifier
$PreDefAttributeID (int)
predefined attribute id (optional)
Return
$aKeys (reference to array of int)
identifier of loop entry (primary key)

InsertSelectedVariation

Creates an entry of SelectedVariation.

Syntax
$SelectedVariationID = InsertSelectedVariation($hSelectedVariation);
Input
$hSelectedVariation (reference to hash)
with following keys:
  • SelectedVariationID - identifier of loop entry (primary key)(optional)- int
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int
Return
$SelectedVariationID (int)
identifier of loop entry (primary key)

OnDeleteAttribute

Deletes SelectedVariation of this model when a(n) Attribute is deleted.

Syntax
OnDeleteAttribute($hParams);
Input
$hParams (ref.hash.*)
primary key of object Attribute, key is
  • AttributeID

OnDeletePreDefAttribute

Deletes SelectedVariation of this model when a(n) PreDefAttribute is deleted.

Syntax
OnDeletePreDefAttribute($hParams);
Input
$hParams (ref.hash.*)
primary key of object PreDefAttribute, key is
  • PreDefAttributeID

UpdateSelectedVariation

Updates a(n) SelectedVariation if any element was changed.

Syntax
UpdateSelectedVariation($SelectedVariationID, $hSelectedVariation);
UpdateSelectedVariation($hSelectedVariation); # if $hSelectedVariation includes SelectedVariationID
Input
$SelectedVariationID (int)
identifier of loop entry (primary key)
$hSelectedVariation (reference to hash)
with following keys:
  • ProductID - product identifier (optional)- int
  • AttributeID - attribute id - int
  • PreDefAttributeID - predefined attribute id (optional)- int