ePages 6.10 - DE_EPAGES/ProductRecommendation/API/Table/ProductRecommendationUser.pm

Package DE_EPAGES::ProductRecommendation::API::Table::ProductRecommendationUser

interface for table ProductRecommendationUser

@EXPORT_OK
InsertProductRecommendationUser
UpdateProductRecommendationUser
DeleteProductRecommendationUser
GetAllPKeyProductRecommendationUsers
GetAllInfoProductRecommendationUsers
GetInfoProductRecommendationUser
ExistsProductRecommendationUser
GetPKeyProductRecommendationUsersByUserID
GetInfoProductRecommendationUsersByUserID
GetPKeyProductRecommendationUsersByShopID
GetInfoProductRecommendationUsersByShopID

Functions

DeleteProductRecommendationUser
ExistsProductRecommendationUser
GetAllInfoProductRecommendationUsers
GetAllPKeyProductRecommendationUsers
GetInfoProductRecommendationUser
GetInfoProductRecommendationUsersByShopID
GetInfoProductRecommendationUsersByUserID
GetPKeyProductRecommendationUsersByShopID
GetPKeyProductRecommendationUsersByUserID
InsertProductRecommendationUser
OnDeleteShop
OnDeleteUser
UpdateProductRecommendationUser

DeleteProductRecommendationUser

Deletes a(n) ProductRecommendationUser.

Syntax
DeleteProductRecommendationUser($UserID, $ShopID);
DeleteProductRecommendationUser($hProductRecommendationUser); # if $hProductRecommendationUser includes UserID, ShopID
Input
$UserID (int)
user id (part of primary key)
$ShopID (int)
shop id (part of primary key)

ExistsProductRecommendationUser

Returns true if the ProductRecommendationUser exists.

Syntax
$exists = ExistsProductRecommendationUser($UserID, $ShopID);
Input
$UserID (int)
user id
$ShopID (int)
shop id
Return
$exists (boolean)
1/0 the ProductRecommendationUser exists (yes/no)

GetAllInfoProductRecommendationUsers

Returns all objects of ProductRecommendationUser.

Syntax
$ahProductRecommendationUsers = GetAllInfoProductRecommendationUsers();
Return
$ahProductRecommendationUsers (reference to array of hashes)
with following keys:
  • UserID - user id (part of primary key)- int
  • ShopID - shop id (part of primary key)- int
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime

GetAllPKeyProductRecommendationUsers

Returns all ProductRecommendationUser identifiers.

Syntax
$ahProductRecommendationUserIDs = GetAllPKeyProductRecommendationUsers();
Return
$ahProductRecommendationUserIDs (reference to array of hashes)
with following keys:
  • UserID - user id - int
  • ShopID - shop id - int

GetInfoProductRecommendationUser

Returns the ProductRecommendationUser by identifier.

Syntax
$hProductRecommendationUser = GetInfoProductRecommendationUser($UserID, $ShopID);
Input
$UserID (int)
user id (part of primary key)
$ShopID (int)
shop id (part of primary key)
Return
$hProductRecommendationUser (reference to hash)
with following keys:
  • UserID - user id (part of primary key)- int
  • ShopID - shop id (part of primary key)- int
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime

GetInfoProductRecommendationUsersByShopID

Returns objects of ProductRecommendationUser by alternate key ShopID.

Syntax
$ahProductRecommendationUsers = GetInfoProductRecommendationUsersByShopID($ShopID);
Input
$ShopID (int)
shop id
Return
$ahProductRecommendationUsers (reference to array of hashes)
with following keys:
  • UserID - user id (part of primary key)- int
  • ShopID - shop id (part of primary key)- int
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime

GetInfoProductRecommendationUsersByUserID

Returns objects of ProductRecommendationUser by primary key element UserID.

Syntax
$ahProductRecommendationUsers = GetInfoProductRecommendationUsersByUserID($UserID);
Input
$UserID (int)
user id
Return
$ahProductRecommendationUsers (reference to array of hashes)
with following keys:
  • UserID - user id (part of primary key)- int
  • ShopID - shop id (part of primary key)- int
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime

GetPKeyProductRecommendationUsersByShopID

Returns primary keys of ProductRecommendationUser by alternate key ShopID.

Syntax
$ahKeys = GetPKeyProductRecommendationUsersByShopID($ShopID);
Input
$ShopID (int)
shop id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • UserID - user id - int
  • ShopID - shop id - int

GetPKeyProductRecommendationUsersByUserID

Returns primary keys of ProductRecommendationUser by primary key element UserID.

Syntax
$ahKeys = GetPKeyProductRecommendationUsersByUserID($UserID);
Input
$UserID (int)
user id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • UserID - user id - int
  • ShopID - shop id - int

InsertProductRecommendationUser

Creates an entry of ProductRecommendationUser.

Syntax
InsertProductRecommendationUser($hProductRecommendationUser);
Input
$hProductRecommendationUser (reference to hash)
with following keys:
  • UserID - user id (part of primary key)- int
  • ShopID - shop id (part of primary key)- int
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime

OnDeleteShop

Deletes ProductRecommendationUser of this model when a(n) Shop is deleted.

Syntax
OnDeleteShop($hParams);
Input
$hParams (ref.hash.*)
primary key of object Shop, key is
  • ShopID

OnDeleteUser

Deletes ProductRecommendationUser of this model when a(n) User is deleted.

Syntax
OnDeleteUser($hParams);
Input
$hParams (ref.hash.*)
primary key of object User, key is
  • UserID

UpdateProductRecommendationUser

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

Syntax
UpdateProductRecommendationUser($UserID, $ShopID, $hProductRecommendationUser);
UpdateProductRecommendationUser($hProductRecommendationUser); # if $hProductRecommendationUser includes UserID, ShopID
Input
$UserID (int)
user id (part of primary key)
$ShopID (int)
shop id (part of primary key)
$hProductRecommendationUser (reference to hash)
with following keys:
  • Number - number of recommendations per day and user and shop - int
  • LastDate - Last date of an recommendation of an user in a shop - datetime