ePages 6.11.0 - DE_EPAGES/Etracker/API/Table/ShopEtrackerAction.pm

Package DE_EPAGES::Etracker::API::Table::ShopEtrackerAction

interface for table ShopEtrackerAction

@EXPORT_OK
InsertShopEtrackerAction
UpdateShopEtrackerAction
DeleteShopEtrackerAction
GetAllPKeyShopEtrackerActions
GetAllInfoShopEtrackerActions
GetInfoShopEtrackerAction
ExistsShopEtrackerAction
GetPKeyShopEtrackerActionsByShopID
GetInfoShopEtrackerActionsByShopID
GetPKeyShopEtrackerActionsByActionID
GetInfoShopEtrackerActionsByActionID

Functions

DeleteShopEtrackerAction
ExistsShopEtrackerAction
GetAllInfoShopEtrackerActions
GetAllPKeyShopEtrackerActions
GetInfoShopEtrackerAction
GetInfoShopEtrackerActionsByActionID
GetInfoShopEtrackerActionsByShopID
GetPKeyShopEtrackerActionsByActionID
GetPKeyShopEtrackerActionsByShopID
InsertShopEtrackerAction
OnDeleteShop
UpdateShopEtrackerAction

DeleteShopEtrackerAction

Deletes a(n) ShopEtrackerAction.

Syntax
DeleteShopEtrackerAction($ShopID, $ActionID);
DeleteShopEtrackerAction($hShopEtrackerAction); # if $hShopEtrackerAction includes ShopID, ActionID
Input
$ShopID (int)
shop id (part of primary key)
$ActionID (int)
action id (part of primary key)

ExistsShopEtrackerAction

Returns true if the ShopEtrackerAction exists.

Syntax
$exists = ExistsShopEtrackerAction($ShopID, $ActionID);
Input
$ShopID (int)
shop id
$ActionID (int)
action id
Return
$exists (boolean)
1/0 the ShopEtrackerAction exists (yes/no)

GetAllInfoShopEtrackerActions

Returns all objects of ShopEtrackerAction.

Syntax
$ahShopEtrackerActions = GetAllInfoShopEtrackerActions();
Return
$ahShopEtrackerActions (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • ActionID - action id (part of primary key)- int
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int

GetAllPKeyShopEtrackerActions

Returns all ShopEtrackerAction identifiers.

Syntax
$ahShopEtrackerActionIDs = GetAllPKeyShopEtrackerActions();
Return
$ahShopEtrackerActionIDs (reference to array of hashes)
with following keys:
  • ShopID - shop id - int
  • ActionID - action id - int

GetInfoShopEtrackerAction

Returns the ShopEtrackerAction by identifier.

Syntax
$hShopEtrackerAction = GetInfoShopEtrackerAction($ShopID, $ActionID);
Input
$ShopID (int)
shop id (part of primary key)
$ActionID (int)
action id (part of primary key)
Return
$hShopEtrackerAction (reference to hash)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • ActionID - action id (part of primary key)- int
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int

GetInfoShopEtrackerActionsByActionID

Returns objects of ShopEtrackerAction by alternate key ActionID.

Syntax
$ahShopEtrackerActions = GetInfoShopEtrackerActionsByActionID($ActionID);
Input
$ActionID (int)
action id
Return
$ahShopEtrackerActions (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • ActionID - action id (part of primary key)- int
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int

GetInfoShopEtrackerActionsByShopID

Returns objects of ShopEtrackerAction by primary key element ShopID.

Syntax
$ahShopEtrackerActions = GetInfoShopEtrackerActionsByShopID($ShopID);
Input
$ShopID (int)
shop id
Return
$ahShopEtrackerActions (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • ActionID - action id (part of primary key)- int
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int

GetPKeyShopEtrackerActionsByActionID

Returns primary keys of ShopEtrackerAction by alternate key ActionID.

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

GetPKeyShopEtrackerActionsByShopID

Returns primary keys of ShopEtrackerAction by primary key element ShopID.

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

InsertShopEtrackerAction

Creates an entry of ShopEtrackerAction.

Syntax
InsertShopEtrackerAction($hShopEtrackerAction);
Input
$hShopEtrackerAction (reference to hash)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • ActionID - action id (part of primary key)- int
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int

OnDeleteShop

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

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

UpdateShopEtrackerAction

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

Syntax
UpdateShopEtrackerAction($ShopID, $ActionID, $hShopEtrackerAction);
UpdateShopEtrackerAction($hShopEtrackerAction); # if $hShopEtrackerAction includes ShopID, ActionID
Input
$ShopID (int)
shop id (part of primary key)
$ActionID (int)
action id (part of primary key)
$hShopEtrackerAction (reference to hash)
with following keys:
  • IsActive - etracker is active for this action - bit
  • EtrackerILevel - etracker level of interest (optional)- int
Return
1 (int)
1