\Components\Commerce\Affiliates \Components\Commerce\Affiliates\Administrators \Components\Commerce\Affiliates\Commissions \Components\Commerce\Affiliates\Payments \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\RecurringSales \Components\Commerce\RecurringSales\StoredCards \Components\Commerce\Sales \Components\Commerce\Sales\Items \Components\Commerce\Sales\Receipts \Components\Commerce\Sales\Receipts\Allocations \Components\Customers\Contacts \Components\Customers\Contacts\Relationships \Components\Customers\Contacts\Relationships\Types \Components\Customers\Groups \Components\Marketing\EmailMarketing \Components\Marketing\Events \Components\Marketing\Events\Attendees \Components\Marketing\Events\Locations \Components\Settings\Administrators \Components\Settings\Domains \Components\Website\Analytics\Sessions \Components\Website\Comments \Components\Website\Designs \Components\Website\Media \Components\Website\Pages \Components\Website\Pages\Forms \Components\Website\Posts \Components\Website\Posts\Categories \Framework\Assets\CSS \Framework\Assets\JavaScript \Framework\Caching\FileBased \Framework\Data\Util \Framework\Date \Framework\DOM\Renderer \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\Sales::

Access and create sales / invoices.

Class Methods

The following static methods are available on this class:
bool delete($strKeyValue, $bDeleteMedia, $strReason)
Description
Deletes a record from the database
Parameters
$strKeyValue
string|array
$bDeleteMedia
bool
$strReason
mixed
Return
bool
string generatePDF($arrSaleIds, $bAdmin, $bWeb, $bPrint)
Description
Generates an invoice from a sale
Parameters
$arrSaleIds
int|array
$bAdmin
bool
$bWeb
bool
$bPrint
bool
Return
PDF
array get($strKey)
Description
Gets a record from the database
Parameters
$strKey
mixed
Value of the primary key
Return
array getAll($arrProperties)
Description
Return a set of records from the database
Parameters
$arrProperties
array
Return
Array of Sales
array getAllForContact($iContactId, $arrProperties)
Description
Returns all sales for a particular contact
Parameters
$iContactId
int
$arrProperties
array
Return
Array of Sales.
mixed getColumn($strKey, $strColumn)
Description
Gets a single field from a record
Parameters
$strKey
string
$strColumn
string
Return
mixed
int getCount($arrFilter)
Description
Returns the number of rows in the database
Parameters
$arrFilter
array
Return
int
int getCountForContact($iContactId, $arrFilter)
Description
Returns the number of sales for a contact
Parameters
$iContactId
int
$arrFilter
array
Return
int
float getTotalsSales($arrFilter)
Description
Returns total sales, grouped by currency
Parameters
$arrFilter
array
Return
float
mixed save($arrEntity, $strReason)
Description
Saves a record into the database
Parameters
$arrEntity
array
$strReason
string
Return
mixed
mixed saveColumn($strKeyValue, $strColumn, $strValue, $strReason)
Description
Saves a specific column of a row into a database
Parameters
$strKeyValue
string
$strColumn
string
$strValue
string
$strReason
string
Return
Id
array search($strSearch, $arrProperties)
Description
Performs a search
Parameters
$strSearch
string
$arrProperties
mixed
Return
array

Database Fields

The following fields are used when retrieving and saving entities.
administrator_id
int (11)
affiliate_id
int unsigned (10)
contact_address
varchar (127)
contact_company
varchar (127)
contact_company_number
varchar (127)
contact_company_number_type
enum ('ABN','ACN','CIK','Company No','SIRET','SIREN')
contact_country_id
char (3)
contact_email
varchar (127)
contact_fax
varchar (31)
contact_first_name
varchar (63)
contact_id
int (10)
contact_last_name
varchar (63)
contact_phone_home
varchar (31)
contact_phone_mobile
varchar (31)
contact_phone_work
varchar (31)
contact_postcode
varchar (8)
contact_state
varchar (127)
contact_suburb_city
varchar (127)
contact_type
enum ('Individual','Company')
Default value: Individual
payment_method_id
int unsigned (10)
recurring_sale_id
int (11)
sale_account_id
int (11)
sale_adjustment_parent_id
int unsigned (10)
sale_adjustment_reason_class_id
varchar (255)
sale_billing_type
enum ('','Client','Reseller')
sale_comments
text
sale_country_id
varchar (3)
Default value: AUS
sale_created_at_url
varchar (255)
sale_created_by_ip_address
varchar (40)
sale_currency_id
varchar (3)
Default value: AUD
sale_datetime
datetime
Default value: 0000-00-00 00:00:00
sale_id
int unsigned (10)
sale_invoice_id
varchar (255)
sale_month
date
sale_month_end
date
sale_receipt_balance
decimal (10,4)
sale_receipt_rounding
decimal (10,4)
Default value: 0.0000
sale_receipt_status
enum ('unpaid','partial','paid','overpaid')
Default value: unpaid
sale_shipping_administrator_id
int (11)
sale_shipping_company_id
int (11)
sale_shipping_consignment_number
varchar (255)
sale_shipping_datetime
datetime
sale_shipping_method_data
text
sale_shipping_method_id
int (11)
sale_shipping_status
varchar (255)
sale_tax_label
varchar (15)
sale_title
varchar (255)
sale_total
decimal (10,4)
Default value: 0.0000
sale_total_tax
decimal (16,10)
Default value: 0.0000000000
sale_type
enum ('sale','adjustment')
Default value: sale
sale_updated_datetime
datetime
sale_view_token
varchar (32)
sale_website_id
int (11)
sale_xero_id
varchar (255)
sale_xero_was_remote_origin
int (11)