\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\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\Customers\Groups\Contacts \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\Architecture\PublicAssets \Framework\Assets\CSS \Framework\Assets\JavaScript \Framework\Caching\FileBased \Framework\Data\Util \Framework\Database\MainConnection \Framework\Date \Framework\DOM\Renderer \Framework\HTML\Converters \Framework\HTML\Highlighter \Framework\HTML\JavaScript \Framework\HTTP\Redirection \Framework\HTTP\Request \Framework\HTTP\Session \Framework\HTTP\UserAgent \Framework\I18N\CompanyTypes \Framework\I18N\Countries \Framework\I18N\Languages \Framework\Network\CIDR \Framework\Network\DNS \Framework\Network\GeoIP \Framework\Random \Framework\System\FileNames \Framework\System\FileSystem \Framework\Toasts
.
.
.
quick access
\ methods

\Components\Commerce\Affiliates::

Create, update and delete affiliates.

Class Methods

The following static methods are available on this class:
string configGetValue($strConfigId)
Description
Retrieves the value of a config item for the current component
Parameters
$strConfigId
string
Return
Config item value
array currentGetAffiliation()
Description
Returns the current affiliation
Parameters
none
Return
Affiliate
bool delete($strKeyValue, $bDeleteMedia, $strReason)
Description
Deletes an entity and triggers the pre/post component events
Parameters
$strKeyValue
string
$bDeleteMedia
bool
$strReason
mixed
Return
bool
array get($strKey)
Description
Returns an entity
Parameters
$strKey
mixed
Value of the primary key
Return
{Array} getAll($arrProperties)
Description
Return all entities in the database.
Parameters
$arrProperties
mixed
Return
Array of Affiliates
mixed getColumn($strKey, $strColumn)
Description
Returns a single column of an entity
Parameters
$strKey
string
$strColumn
string
Return
mixed
int getCount($arrFilter)
Description
Returns a count of all rows in the data adapter
Parameters
$arrFilter
array
Return
int
string mediaFolderGet($strKey)
Description
Returns the media folder for this data adapter
Parameters
$strKey
mixed
Return
Folder
mixed save($arrEntity, $strReason)
Description
Saves an entity and triggers the pre/post component events
Parameters
$arrEntity
array
$strReason
string
Return
mixed
mixed saveColumn($strKeyValue, $strColumn, $strValue, $strReason)
Description
Changes a column of an existing entity Supports primary keys spanning on several columns if passing $strKeyValue as an associative arry
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.
affiliate_code
varchar (127)
affiliate_commission_contact
decimal unsigned (8,2)
affiliate_commission_sale_fixed
decimal unsigned (8,2)
affiliate_commission_sale_percent
decimal unsigned (8,2)
affiliate_commission_visit
decimal unsigned (8,2)
affiliate_count_commission_contacts
int unsigned (10)
affiliate_count_commission_sale_items
int unsigned (10)
affiliate_count_commission_visits
int unsigned (10)
affiliate_cpnl
tinyint unsigned (1)
Default value: 1
affiliate_cpnl_contacts
tinyint unsigned (1)
affiliate_cpnl_marketing
tinyint unsigned (1)
Default value: 1
affiliate_cpnl_profile
tinyint unsigned (1)
Default value: 1
affiliate_cpnl_sales
tinyint unsigned (1)
Default value: 1
affiliate_cpnl_statistics
tinyint unsigned (1)
Default value: 1
affiliate_cpnl_visits
tinyint unsigned (1)
Default value: 1
affiliate_deactivate_date
datetime
affiliate_existing_contacts
tinyint unsigned (1)
affiliate_id
int unsigned (10)
affiliate_is_active
tinyint unsigned (1)
Default value: 1
affiliate_length_days
int unsigned (10)
affiliate_length_type
enum ('session','contact','time')
Default value: session
affiliate_payment_bank_details
varchar (255)
affiliate_sales_emails
varchar (255)
affiliate_title
varchar (255)
affiliate_total_commission
decimal unsigned (8,2)
Default value: 0.00
affiliate_total_commission_contacts
decimal unsigned (8,2)
Default value: 0.00
affiliate_total_commission_sale_items
decimal unsigned (8,2)
Default value: 0.00
affiliate_total_commission_visits
decimal unsigned (8,2)
Default value: 0.00
affiliate_total_payments
decimal unsigned (8,2)
Default value: 0.00
affiliate_total_unpaid
decimal (8,2)
Default value: 0.00
affiliate_url
varchar (255)
contact_id
int unsigned (10)