Templating
Global Functions
Website
\Components\Website\Designs \Components\Website\Pages \Components\Website\Pages\Forms \Components\Website\Posts \Components\Website\Posts\Categories
Customers
\Components\Customers\Contacts \Components\Customers\Contacts\Relationships \Components\Customers\Contacts\Relationships\Types \Components\Customers\Groups
Marketing
\Components\Marketing\EmailMarketing \Components\Marketing\Events \Components\Marketing\Events\Attendees \Components\Marketing\Events\Locations
Commerce
\Components\Commerce\Carts \Components\Commerce\Carts\Current \Components\Commerce\Configuration\PaymentMethods \Components\Commerce\Configuration\ShippingMethods \Components\Commerce\Discounts \Components\Commerce\Products \Components\Commerce\Products\Brands \Components\Commerce\Products\Categories \Components\Commerce\Products\Inventory \Components\Commerce\Sales \Components\Commerce\Sales\Items \Components\Commerce\Sales\Receipts \Components\Commerce\Sales\Receipts\Allocations
Settings
\Components\Settings\Administrators \Components\Settings\Domains
Other Apps
\Components\Website\Comments \Components\Commerce\Affiliates \Components\Commerce\Affiliates\Administrators \Components\Commerce\Affiliates\Commissions \Components\Commerce\Affiliates\Payments \Components\Commerce\RecurringSales \Components\Commerce\RecurringSales\StoredCards
Framework
\Framework\Caching\FileBased \Framework\Data\Util \Framework\HTML\Converters \Framework\HTTP\Cookies \Framework\HTTP\Redirection \Framework\HTTP\Request \Framework\HTTP\Session \Framework\HTTP\UserAgent \Framework\I18N\CompanyTypes \Framework\I18N\Countries \Framework\I18N\Languages \Framework\Network\GeoIP
Methods

\Components\Commerce\Products\Inventory::

Access, create, update and delete your inventory items.

Methods

Invoke via \Components\Commerce\Products\Inventory::method()
Click a method name to copy it.
array get($iProductInventoryId)
Gets a record from the database
Parameters
$iProductInventoryId
int
A record's product_inventory_id
Return
array getAll($arrQuery)
Return a set of records from the database
Parameters
$arrQuery
array|null
Return
Array of Inventorys
array getAllForProductId($iProductId)
Returns all inventory items for a product id
Parameters
$iProductId
int
Return
Array of Inventorys
mixed getColumn($iProductInventoryId, $strColumn)
Gets a single field from a record
Parameters
$iProductInventoryId
int
A record's product_inventory_id
$strColumn
string
Return
mixed
int getCount($arrFilter)
Returns the number of records in the database (matching the filter if specified)
Parameters
$arrFilter
array|null
Return
int
int save($arrEntity)
Saves a record into the database
Parameters
$arrEntity
array
Return
The record's product_inventory_id
void saveColumn($iProductInventoryId, $strColumn, $strValue)
Saves a specific column of a row into a database
Parameters
$iProductInventoryId
int
A record's product_inventory_id
$strColumn
string
$strValue
string
array search($strSearch, $arrQuery)
Performs a search
Parameters
$strSearch
string
Search query
$arrQuery
array|null
Return
Array of Inventorys that match the search query.
bool delete($iProductInventoryId, $bDeleteMedia)
Deletes a record from the database
Parameters
$iProductInventoryId
int
A record's product_inventory_id
$bDeleteMedia
bool
Return
Returns true if record existed and was deleted, otherwise false

Database Fields

The following fields are used when retrieving and saving entities.
product_inventory_id
int (11)
product_inventory_code
string (127)
product_inventory_description
string (65535)
product_inventory_icon
string (255)
product_inventory_supplier
string (255)
product_inventory_purchase_price
decimal (10,4)
product_inventory_last_order_date
date
product_inventory_warning_level
int (11)
product_inventory_stock_level
int (11)