Templating
Global Functions
Website
\Components\Website\Designs \Components\Website\Media \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\CustomFields \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 \Framework\Data\Util \Framework\HTML\Bleacher \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\Carts::

Retreive historical cart data for all users over time.

Methods

Invoke via \Components\Commerce\Carts::method()
Click a method name to copy it.
bool delete($iCartId, $bDeleteMedia)
Deletes a record from the database
Parameters
$iCartId
int unsigned
A record's cart_id
$bDeleteMedia
bool
Return
Returns true if record existed and was deleted, otherwise false
array get($iCartId)
Gets a record from the database
Parameters
$iCartId
int unsigned
A record's cart_id
Return
array getAll($arrQuery)
Return a set of records from the database
Parameters
$arrQuery
array|null
Return
Array of Carts
mixed getColumn($iCartId, $strColumn)
Gets a single field from a record
Parameters
$iCartId
int unsigned
A record's cart_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
string|int save($arrEntity)
Saves a record into the database
Parameters
$arrEntity
mixed
Return
string|int
void saveColumn($iCartId, $strColumn, $strValue)
Saves a specific column of a row into a database
Parameters
$iCartId
int unsigned
A record's cart_id
$strColumn
string
$strValue
string
array search($strSearch, $arrQuery)
Performs a search
Parameters
$strSearch
string
Search query
$arrQuery
array|null
Return
Array of Carts that match the search query.

Database Fields

The following fields are used when retrieving and saving entities.
cart_id
int unsigned (10)
contact_id
int (11)
cart_is_admin
0 or 1
cart_should_invoice_company
0 or 1
cart_currency_id
string (3)
Default value: AUD
cart_currency_id_is_overriden
0 or 1
cart_country_id
string (3)
Default value: AUS
cart_datetime
datetime
Default value: 0000-00-00 00:00:00
cart_shipping_method_id
int (11)
cart_shipping_method_data
string (16777215)
cart_discounts_generic
decimal unsigned (8,2)
cart_comments
string (16777215)
cart_discounts_activated
string (255)
payment_method_id
int unsigned (10)
cart_use_available_adjustments
int unsigned (1)
Default value: 1