ePages 6.10 - DE_EPAGES/PriceList/API/Table/PriceListCustomerGroup.pm

Package DE_EPAGES::PriceList::API::Table::PriceListCustomerGroup

interface for table PriceListCustomerGroup

@EXPORT_OK
InsertPriceListCustomerGroup
DeletePriceListCustomerGroup
GetAllPKeyPriceListCustomerGroups
ExistsPriceListCustomerGroup
GetPKeyPriceListCustomerGroupsByPriceListID
GetInfoPriceListCustomerGroupsByPriceListID
GetPKeyPriceListCustomerGroupsByCustomerGroupID
GetInfoPriceListCustomerGroupsByCustomerGroupID

Functions

DeletePriceListCustomerGroup
ExistsPriceListCustomerGroup
GetAllPKeyPriceListCustomerGroups
GetInfoPriceListCustomerGroupsByCustomerGroupID
GetInfoPriceListCustomerGroupsByPriceListID
GetPKeyPriceListCustomerGroupsByCustomerGroupID
GetPKeyPriceListCustomerGroupsByPriceListID
InsertPriceListCustomerGroup
OnDeleteCustomerGroup

DeletePriceListCustomerGroup

Deletes a(n) PriceListCustomerGroup.

Syntax
DeletePriceListCustomerGroup($PriceListID, $CustomerGroupID);
DeletePriceListCustomerGroup($hPriceListCustomerGroup); # if $hPriceListCustomerGroup includes PriceListID, CustomerGroupID
Input
$PriceListID (int)
price list id (part of primary key)
$CustomerGroupID (int)
customer group id (part of primary key)

ExistsPriceListCustomerGroup

Returns true if the PriceListCustomerGroup exists.

Syntax
$exists = ExistsPriceListCustomerGroup($PriceListID, $CustomerGroupID);
Input
$PriceListID (int)
price list id
$CustomerGroupID (int)
customer group id
Return
$exists (boolean)
1/0 the PriceListCustomerGroup exists (yes/no)

GetAllPKeyPriceListCustomerGroups

Returns all PriceListCustomerGroup identifiers.

Syntax
$ahPriceListCustomerGroupIDs = GetAllPKeyPriceListCustomerGroups();
Return
$ahPriceListCustomerGroupIDs (reference to array of hashes)
with following keys:
  • PriceListID - price list id - int
  • CustomerGroupID - customer group id - int

GetInfoPriceListCustomerGroupsByCustomerGroupID

Returns objects of PriceListCustomerGroup by alternate key CustomerGroupID.

Syntax
$ahPriceListCustomerGroups = GetInfoPriceListCustomerGroupsByCustomerGroupID($CustomerGroupID);
Input
$CustomerGroupID (int)
customer group id
Return
$ahPriceListCustomerGroups (reference to array of hashes)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerGroupID - customer group id (part of primary key)- int

GetInfoPriceListCustomerGroupsByPriceListID

Returns objects of PriceListCustomerGroup by primary key element PriceListID.

Syntax
$ahPriceListCustomerGroups = GetInfoPriceListCustomerGroupsByPriceListID($PriceListID);
Input
$PriceListID (int)
price list id
Return
$ahPriceListCustomerGroups (reference to array of hashes)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerGroupID - customer group id (part of primary key)- int

GetPKeyPriceListCustomerGroupsByCustomerGroupID

Returns primary keys of PriceListCustomerGroup by alternate key CustomerGroupID.

Syntax
$ahKeys = GetPKeyPriceListCustomerGroupsByCustomerGroupID($CustomerGroupID);
Input
$CustomerGroupID (int)
customer group id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • PriceListID - price list id - int
  • CustomerGroupID - customer group id - int

GetPKeyPriceListCustomerGroupsByPriceListID

Returns primary keys of PriceListCustomerGroup by primary key element PriceListID.

Syntax
$ahKeys = GetPKeyPriceListCustomerGroupsByPriceListID($PriceListID);
Input
$PriceListID (int)
price list id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • PriceListID - price list id - int
  • CustomerGroupID - customer group id - int

InsertPriceListCustomerGroup

Creates an entry of PriceListCustomerGroup.

Syntax
InsertPriceListCustomerGroup($hPriceListCustomerGroup);
Input
$hPriceListCustomerGroup (reference to hash)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerGroupID - customer group id (part of primary key)- int

OnDeleteCustomerGroup

Deletes PriceListCustomerGroup of this model when a(n) CustomerGroup is deleted.

Syntax
OnDeleteCustomerGroup($hParams);
Input
$hParams (ref.hash.*)
primary key of object CustomerGroup, key is
  • CustomerGroupID