ePages 6.11.0 - DE_EPAGES/Order/API/Table/MinOrderAmount.pm

Package DE_EPAGES::Order::API::Table::MinOrderAmount

interface for table MinOrderAmount

@EXPORT_OK
InsertMinOrderAmount
UpdateMinOrderAmount
DeleteMinOrderAmount
GetAllPKeyMinOrderAmounts
GetAllInfoMinOrderAmounts
GetInfoMinOrderAmount
ExistsMinOrderAmount
GetPKeyMinOrderAmountsByShopID
GetInfoMinOrderAmountsByShopID
GetPKeyMinOrderAmountsByCurrencyID
GetInfoMinOrderAmountsByCurrencyID

Functions

DeleteMinOrderAmount
ExistsMinOrderAmount
GetAllInfoMinOrderAmounts
GetAllPKeyMinOrderAmounts
GetInfoMinOrderAmount
GetInfoMinOrderAmountsByCurrencyID
GetInfoMinOrderAmountsByShopID
GetPKeyMinOrderAmountsByCurrencyID
GetPKeyMinOrderAmountsByShopID
InsertMinOrderAmount
OnDeleteCurrency
OnDeleteShop
UpdateMinOrderAmount

DeleteMinOrderAmount

Deletes a(n) MinOrderAmount.

Syntax
DeleteMinOrderAmount($ShopID, $CurrencyID);
DeleteMinOrderAmount($hMinOrderAmount); # if $hMinOrderAmount includes ShopID, CurrencyID
Input
$ShopID (int)
shop id (part of primary key)
$CurrencyID (char(3))
alpha currency code (ISO 4217) (part of primary key)

ExistsMinOrderAmount

Returns true if the MinOrderAmount exists.

Syntax
$exists = ExistsMinOrderAmount($ShopID, $CurrencyID);
Input
$ShopID (int)
shop id
$CurrencyID (char(3))
alpha currency code (ISO 4217)
Return
$exists (boolean)
1/0 the MinOrderAmount exists (yes/no)

GetAllInfoMinOrderAmounts

Returns all objects of MinOrderAmount.

Syntax
$ahMinOrderAmounts = GetAllInfoMinOrderAmounts();
Return
$ahMinOrderAmounts (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • CurrencyID - alpha currency code (ISO 4217) (part of primary key)- char(3)
  • Value - value - money

GetAllPKeyMinOrderAmounts

Returns all MinOrderAmount identifiers.

Syntax
$ahMinOrderAmountIDs = GetAllPKeyMinOrderAmounts();
Return
$ahMinOrderAmountIDs (reference to array of hashes)
with following keys:
  • ShopID - shop id - int
  • CurrencyID - alpha currency code (ISO 4217) - char(3)

GetInfoMinOrderAmount

Returns the MinOrderAmount by identifier.

Syntax
$hMinOrderAmount = GetInfoMinOrderAmount($ShopID, $CurrencyID);
Input
$ShopID (int)
shop id (part of primary key)
$CurrencyID (char(3))
alpha currency code (ISO 4217) (part of primary key)
Return
$hMinOrderAmount (reference to hash)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • CurrencyID - alpha currency code (ISO 4217) (part of primary key)- char(3)
  • Value - value - money

GetInfoMinOrderAmountsByCurrencyID

Returns objects of MinOrderAmount by alternate key CurrencyID.

Syntax
$ahMinOrderAmounts = GetInfoMinOrderAmountsByCurrencyID($CurrencyID);
Input
$CurrencyID (char(3))
alpha currency code (ISO 4217)
Return
$ahMinOrderAmounts (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • CurrencyID - alpha currency code (ISO 4217) (part of primary key)- char(3)
  • Value - value - money

GetInfoMinOrderAmountsByShopID

Returns objects of MinOrderAmount by primary key element ShopID.

Syntax
$ahMinOrderAmounts = GetInfoMinOrderAmountsByShopID($ShopID);
Input
$ShopID (int)
shop id
Return
$ahMinOrderAmounts (reference to array of hashes)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • CurrencyID - alpha currency code (ISO 4217) (part of primary key)- char(3)
  • Value - value - money

GetPKeyMinOrderAmountsByCurrencyID

Returns primary keys of MinOrderAmount by alternate key CurrencyID.

Syntax
$ahKeys = GetPKeyMinOrderAmountsByCurrencyID($CurrencyID);
Input
$CurrencyID (char(3))
alpha currency code (ISO 4217)
Return
$ahKeys (reference to array of hashes)
with following keys:
  • ShopID - shop id - int
  • CurrencyID - alpha currency code (ISO 4217) - char(3)

GetPKeyMinOrderAmountsByShopID

Returns primary keys of MinOrderAmount by primary key element ShopID.

Syntax
$ahKeys = GetPKeyMinOrderAmountsByShopID($ShopID);
Input
$ShopID (int)
shop id
Return
$ahKeys (reference to array of hashes)
with following keys:
  • ShopID - shop id - int
  • CurrencyID - alpha currency code (ISO 4217) - char(3)

InsertMinOrderAmount

Creates an entry of MinOrderAmount.

Syntax
InsertMinOrderAmount($hMinOrderAmount);
Input
$hMinOrderAmount (reference to hash)
with following keys:
  • ShopID - shop id (part of primary key)- int
  • CurrencyID - alpha currency code (ISO 4217) (part of primary key)- char(3)
  • Value - value - money

OnDeleteCurrency

Deletes MinOrderAmount of this model when a(n) Currency is deleted.

Syntax
OnDeleteCurrency($hParams);
Input
$hParams (ref.hash.*)
primary key of object Currency, key is
  • CurrencyID

OnDeleteShop

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

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

UpdateMinOrderAmount

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

Syntax
UpdateMinOrderAmount($ShopID, $CurrencyID, $hMinOrderAmount);
UpdateMinOrderAmount($hMinOrderAmount); # if $hMinOrderAmount includes ShopID, CurrencyID
Input
$ShopID (int)
shop id (part of primary key)
$CurrencyID (char(3))
alpha currency code (ISO 4217) (part of primary key)
$hMinOrderAmount (reference to hash)
with following keys:
  • Value - value - money
Return
1 (int)
1