TrafficExchangeLedger

Database Table: trafficexchangeledgers
Extends: Result
Extends: AbstractDatabase

TrafficExchangeLedger PHP Methods

add(array $fieldValues) _v5

Adds a new record.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
int = id of the new record.
0 = if fails

addRecord(int $type, int $amount, int $memberID, int $var1 = 0) _v5

Add traffic exchange ledger record
PARAMETERS:
$type = int, ledger type; 2 = not deposite | any other value = deposite
$amount = int, ledger amount
$memberID = int, member ID
$var1= int, variable value
RETURN VALUE:
VOID

checkLoaded() _v5

Checks if record is loaded. throwing an error if the record failed to load successfully.
PARAMETERS:
NONE
RETURN VALUE:
VOID

convertHTML(string $htmlContent = "", string $prefix = "", bool $urlEncode = false) _v5

Converts ~~ variables in the $htmlContent that is provided and returns the converted content. The title of the ~~ variables are converted by the content from the column in the database with the matching title.
PARAMETERS:
$htmlContent = String, HTML content body to convert.
$prefix= String, tilde code prefix if any.
$urlEncode = Bool, true if you want to apply URL encode to the content, false otherwise
RETURN VALUE:
String = Converted HTML

delete(string $restoreQuery = "") _v5

Deletes the loaded record from the database.
PARAMETERS:
$restoreQuery = FOR INTERNAL USE. FOR TYPICAL USAGE LEAVE THIS BLANK. The restore query to pass along when deleting an object with dependencies.
RETURN VALUE:
VOID

duplicate(array $newValues = null) _v5

Creates a duplicate record in the database of the current object
PARAMETERS:
$newValues = array, associative array with field name as key and field value as array value containing the new values if any
RETURN VALUE:
int = the id of the new record.

function load(string $queryWhere) _v5

Loads values for the record matching the criteria specified by $queryWhere. If the there is more than one record returned from the query then only the first record is loaded.
PARAMETERS:
$queryWhere = String, SQL where query.
RETURN VALUE:
Bool = true, if success, false otherwise

getAlertClass() _v5

Gets ledger HTML class attribute value based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "alert-success" if ledger is deposite, else "alert-warning"

getAlertClassReverse() _v5

Gets reversed ledger HTML class attribute value based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "alert-warning" if ledger is deposite, else "alert-success"

getAmountSymbol() _v5

Gets ledger amount symbol based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "+" if ledger is deposite, else "-"

getAmountSymbolReverse() _v5

Gets reversed amount symbol based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "-" if ledger is deposite, else "+"

getDatabaseName() _v5

Returns object's database table name
PARAMETERS:
NONE
RETURN VALUE:
String = Database name

getDefaultTRHTML() _v5

Returns the default html code for a tr row with all of the fields from the database in it as ~~ vars
PARAMETERS:
NONE
RETURN VALUE:
String = the default HTML code for a tr row with all of the fields from the database in it as ~~ vars

getDetails() _v5

Gets details for the loaded traffic exchange
PARAMETERS:
NONE
RETURN VALUE:
$string = details for the loaded traffic exchange

getDetailsShort() _v5

Gets short details for the loaded traffic exchange
PARAMETERS:
NONE
RETURN VALUE:
$string = short details for the loaded traffic exchange

getID() _v5

Sets object ID
PARAMETERS:
NONE
RETURN VALUE:
int = ID

getJSON(bool $returnArr = false) _v5

Get JSON array for the loaded record.
PARAMETERS:
Bool = true if want to return JSON, false otherwise
RETURN VALUE:
Object Array or JSON encoded version of the array

getLabelClass() _v5

Gets ledger label HTML class attribute value based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "bg-success" if ledger is deposite, else "bg-warning"

getLabelClassReverse() _v5

Gets reversed label ledger HTML class attribute value based on ledger type
PARAMETERS:
NONE
RETURN VALUE:
$string = "alert-warning" if ledger is deposite, else "alert-success"

getValue(string $fieldName = "value") _v5

Returns the value from a specific column for this record.
PARAMETERS:
$fieldName = String, field name.
RETURN VALUE:
Field value

hasField(string $fieldName) _v5

Checks if the field shown or hidden
PARAMETERS:
$fieldName= String, Field title.
RETURN VALUE:
Bool= True if the field show is true, false otherwise

hideAllFields() _v5

hides all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

hideField($fieldTitle) _v5

Hides specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID

isLoaded() _v5

Checks if an object is loaded correctly (can be used to check if ID exists).
PARAMETERS:
NONE
RETURN VALUE:
Bool = True if the object loaded successfully, false otherwise

loadFirstID() _v5

Get object's first id
PARAMETERS:
NONE
RETURN VALUE:
int = First ID

loadID(int $id) _v5

Loads values for the record with the id specified.
PARAMETERS:
$id = int, record ID.
RETURN VALUE:
Bool = true, if success, false otherwise

save(array $fieldValues) _v5

Saves the record with the new values specified in the $fieldValuesarray.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
Bool = True on success, False otherwise.

setMapTrafficExchange(\WMT\Map\TrafficExchange $mapTraffic) _v5

Sets traffic exchange map
PARAMETERS:
$mapTraffic = object
RETURN VALUE:
Void

setMyMemberID(int $memberID) _v5

Sets member's ID
PARAMETERS:
$memberID = int, member id
RETURN VALUE:
VOID

setRestoreID(int $id) _v5

Sets restor point ID
PARAMETERS:
$id = int, restore ID
RETURN VALUE:
VOID

settingHTTPS(bool $useHTTPS = true) _v5

Sets site to use https or http
PARAMETERS:
$useHTTPS = True if https on, false otherwise (default true).
RETURN VALUE:
VOID

settingSiteURL(string $siteURL) _v5

Sets Site Domain
PARAMETERS:
$siteURL = String, site URL
RETURN VALUE:
VOID

showAllFields() _v5

Show all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

showField($fieldTitle) _v5

Shows specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID