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

Package DE_EPAGES::PriceList::API::Table::PriceListCustomer

interface for table PriceListCustomer

@EXPORT_OK
InsertPriceListCustomer
DeletePriceListCustomer
GetAllPKeyPriceListCustomers
ExistsPriceListCustomer
GetPKeyPriceListCustomersByPriceListID
GetInfoPriceListCustomersByPriceListID
GetPKeyPriceListCustomersByCustomerID
GetInfoPriceListCustomersByCustomerID

Functions

DeletePriceListCustomer
ExistsPriceListCustomer
GetAllPKeyPriceListCustomers
GetInfoPriceListCustomersByCustomerID
GetInfoPriceListCustomersByPriceListID
GetPKeyPriceListCustomersByCustomerID
GetPKeyPriceListCustomersByPriceListID
InsertPriceListCustomer
OnDeleteCustomer

DeletePriceListCustomer

Deletes a(n) PriceListCustomer.

Syntax
DeletePriceListCustomer($PriceListID, $CustomerID);
DeletePriceListCustomer($hPriceListCustomer); # if $hPriceListCustomer includes PriceListID, CustomerID
Input
$PriceListID (int)
price list id (part of primary key)
$CustomerID (int)
customer identifier (part of primary key)

ExistsPriceListCustomer

Returns true if the PriceListCustomer exists.

Syntax
$exists = ExistsPriceListCustomer($PriceListID, $CustomerID);
Input
$PriceListID (int)
price list id
$CustomerID (int)
customer identifier
Return
$exists (boolean)
1/0 the PriceListCustomer exists (yes/no)

GetAllPKeyPriceListCustomers

Returns all PriceListCustomer identifiers.

Syntax
$ahPriceListCustomerIDs = GetAllPKeyPriceListCustomers();
Return
$ahPriceListCustomerIDs (reference to array of hashes)
with following keys:
  • PriceListID - price list id - int
  • CustomerID - customer identifier - int

GetInfoPriceListCustomersByCustomerID

Returns objects of PriceListCustomer by alternate key CustomerID.

Syntax
$ahPriceListCustomers = GetInfoPriceListCustomersByCustomerID($CustomerID);
Input
$CustomerID (int)
customer identifier
Return
$ahPriceListCustomers (reference to array of hashes)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerID - customer identifier (part of primary key)- int

GetInfoPriceListCustomersByPriceListID

Returns objects of PriceListCustomer by primary key element PriceListID.

Syntax
$ahPriceListCustomers = GetInfoPriceListCustomersByPriceListID($PriceListID);
Input
$PriceListID (int)
price list id
Return
$ahPriceListCustomers (reference to array of hashes)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerID - customer identifier (part of primary key)- int

GetPKeyPriceListCustomersByCustomerID

Returns primary keys of PriceListCustomer by alternate key CustomerID.

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

GetPKeyPriceListCustomersByPriceListID

Returns primary keys of PriceListCustomer by primary key element PriceListID.

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

InsertPriceListCustomer

Creates an entry of PriceListCustomer.

Syntax
InsertPriceListCustomer($hPriceListCustomer);
Input
$hPriceListCustomer (reference to hash)
with following keys:
  • PriceListID - price list id (part of primary key)- int
  • CustomerID - customer identifier (part of primary key)- int

OnDeleteCustomer

Deletes PriceListCustomer of this model when a(n) Customer is deleted.

Syntax
OnDeleteCustomer($hParams);
Input
$hParams (ref.hash.*)
primary key of object Customer, key is
  • CustomerID