TimeTrex API Manual

UserPreferenceListFactory extends UserPreferenceFactory
in package
implements IteratorAggregate

Interfaces, Classes, Traits and Enums

IteratorAggregate

Table of Contents

$cache  : Cache_Lite_Function|Cache_Lite_Output
$data  : mixed
$db  : mixed
$is_new  : mixed
$old_data  : mixed
$rs  : mixed
$tmp_data  : mixed
$user_obj  : mixed
$validate_only  : mixed
$Validator  : mixed
$api_message_id  : mixed
$enable_system_log_detail  : mixed
$pk_sequence_name  : mixed
$progress_bar_obj  : mixed
$table  : mixed
$ignore_column_list  : bool
$is_valid  : mixed
__construct()  : mixed
Factory constructor.
__toString()  : bool|string
Print primary columns from object.
addLog()  : bool
bulkDelete()  : bool
castGenericDataValue()  : mixed
Generic casting function that all set/get*() functions should pass through.
checkScheduleICalendarKey()  : bool
clearCacheSavedInTransaction()  : bool
clearData()  : bool
clearGeoCode()  : bool
clearNonMappedData()  : array<string|int, mixed>|null
Removes array elements from $data that are not in the function map.
clearOldData()  : bool
CommitSavePoint()  : bool
CommitTransaction()  : mixed
convertFlexArray()  : array<string|int, mixed>
convertMetersToDistance()  : bool|float|int
decodeCustomFields()  : bool
decodeGenericJSONData()  : bool
Decode generic 'other_json' column data.
decodeJSONColumn()  : bool
Decodes JSON columns that are not the 'other_json' column.
Delete()  : bool
Deletes the record directly from the database.
encodeCustomFields()  : bool
encodeGenericJSONData()  : bool
Encode generic 'other_json' column data. This should only be done in Save() after all validation has occurred already and we are just about to commit it to the DB.
encodeJSONColumns()  : bool
Encode any JSON columns that are not 'other_json' column. This should only be done in Save() after all validation has occurred already and we are just about to commit it to the DB.
ExecuteSQL()  : bool
Execute SQL queries and handle paging properly for select statements.
FailTransaction()  : mixed
fromBool()  : bool
fromJSONBool()  : bool
getAffectedRows()  : int|bool
getAll()  : $this
getAPIMessageID()  : bool|null
Used for updating progress bar for API calls.
getAPISearchByCompanyIdAndArrayCriteria()  : bool|UserPreferenceListFactory
getBrowserPermissionAskDate()  : int
getByCompanyId()  : bool|UserPreferenceListFactory
getByCompanyIdAndDateAndValidUserIDs()  : bool|UserPreferenceListFactory
getById()  : bool|UserPreferenceListFactory
getByIdAndCompanyId()  : bool|UserPreferenceListFactory
getByUserId()  : bool|UserPreferenceListFactory
getByUserIDAndCompanyID()  : bool|UserPreferenceListFactory
getByUserIdAndEnableLogin()  : bool|UserPreferenceListFactory
getByUserIdAndStatus()  : bool|UserPreferenceListFactory
getCache()  : bool|mixed
getColumn()  : bool|mixed
Generic function get any data from the data array.
getColumnList()  : array<string|int, mixed>|bool
getCompanyGenericMapData()  : mixed
Generic function to return and cache CompanyGenericMap data, this greatly improves performance of CalculatePolicy when many policies exist.
getCreatedAndUpdatedColumns()  : bool
getCreatedBy()  : bool|mixed
getCreatedDate()  : int
getCurrent()  : mixed
Grabs the current object
getCurrentRow()  : int|bool
getCustomField()  : void
Get a single custom field by ID.
getCustomFields()  : mixed
getCustomFieldsColumns()  : array<string|int, mixed>
getCustomFieldsDataForObject()  : array<string|int, mixed>
Get custom field data for this specific object, so it can be easily cached in memory without having to go to the database or unserialize it from cache for every row.
getCustomFieldsDefaultData()  : mixed
getCustomFieldsParseHints()  : array<string|int, mixed>
getCustomFieldTableName()  : string
getDataDifferences()  : array<string|int, mixed>
Returns the differences in data from the DB vs the in-memory object, so the data will be the OLD data. Used in Validation/postSave() functions to determine if a field has changed or not.
getDateFormat()  : bool|mixed
getDateFormatExample()  : bool
getDateRangeSQL()  : bool|string
This function takes plain input from the user and creates a SQL statement for filtering based on a date range.
getDefaultLoginScreen()  : bool|mixed
Default: Home/Dashboard
getDeleted()  : bool
getDeletedBy()  : bool|mixed
getDeletedDate()  : bool|mixed
getDistanceFormat()  : bool|mixed
getEmptyRecordSet()  : mixed
getEnableAlwaysBlankTimeSheetRows()  : bool
getEnableAutoContextMenu()  : bool
getEnableEmailNotificationException()  : bool
getEnableEmailNotificationHome()  : bool
getEnableEmailNotificationMessage()  : bool
getEnableEmailNotificationPayStub()  : bool
getEnableReportOpenNewWindow()  : bool
getEnableSaveTimesheetState()  : bool
getEnableSystemLogDetail()  : bool
getGenericDataValue()  : bool|mixed
Generic getter/setter functions that should be used when Validation code is moved from get/set functions to Validate() function.
getGenericJSONDataValue()  : bool|mixed
Generic getter/setter functions for handling generic JSON data in 'other_json' SQL column.
getGenericObject()  : object|bool
Generic function to return and cache class objects ListFactory, ListFactoryMethod, Variable, ID, IDMethod
getGenericOldDataValue()  : bool|mixed
getGenericTempDataValue()  : bool
Generic getter/setter functions that should be used when Validation code is moved from get/set functions to Validate() function.
getId()  : bool|mixed
getIDSByListFactory()  : array<string|int, mixed>|bool
getIsModifiedByCompanyIdAndDate()  : bool
getItemsPerPage()  : bool|mixed
getIterator()  : FactoryListIterator
getJSDateFormat()  : bool|string
getJSTimeFormat()  : bool|string
getLabelId()  : bool|mixed|string
getLanguage()  : bool|mixed
getLocationTimeZone()  : array<string|int, mixed>|bool|mixed|string
getMostCommonTimeZone()  : mixed
Returns the most commonly used timezone by employees.
getNextInsertId()  : bool|string
getNotificationDuration()  : bool|mixed
getNotificationStatus()  : int
getObjectAsArray()  : array<string|int, mixed>
getOptions()  : array<string|int, mixed>|bool
getPermissionColumns()  : bool
getProgressBarObject()  : null|ProgressBar
getRecordCount()  : int|bool
getScheduleIcalendarAlarm1Absence()  : bool|int
getScheduleIcalendarAlarm1Modified()  : bool|int
getScheduleIcalendarAlarm1Working()  : bool|int
getScheduleIcalendarAlarm2Absence()  : bool|int
getScheduleIcalendarAlarm2Modified()  : bool|int
getScheduleIcalendarAlarm2Working()  : bool|int
getScheduleIcalendarEventName()  : bool
Currently used as part of the unauthenticated key, so if this changes the key to access the calendar changes too.
getScheduleIcalendarKey()  : bool|string
getScheduleIcalendarType()  : bool|int
getScheduleIcalendarURL()  : string
Helper functions for dealing with unauthenticated calendar access, required by Google Calendar for now.
getSequenceName()  : bool
getShortcutKeySequence()  : bool|mixed
Used in Flex interface only, currently its hardcoded for now at least. Default: CTRL+ALT
getStartWeekDay()  : bool|mixed
getTable()  : bool|string
getTimeFormat()  : bool|mixed
getTimeFormatExample()  : array<string|int, mixed>|mixed
getTimeSheetView()  : bool|mixed
getTimeUnitFormat()  : bool|mixed
getTimeUnitFormatExample()  : mixed
getTimeZone()  : bool|mixed
getTransactionMode()  : string
getUniqueLanguageByCompanyId()  : bool
getUpdatedBy()  : bool|mixed
getUpdatedDate()  : int
getUser()  : bool|mixed
getUserObject()  : bool
getValidSQLColumns()  : array<string|int, mixed>
getVariableToFunctionMap()  : array<string|int, mixed>|bool
handleSaveSQLReturning()  : bool
Used to handle any "RETURNING ..." clause on a SQL INSERT/UPDATE query.
hasDataChanged()  : bool
Determine if the record data has changed at all.
isClientFriendly()  : bool
Check if the remote client is our main UI app controlled by us, vs. a user utilizing the API for example.
isDataDifferent()  : bool
Used to check the differences between a single key in the $old_data vs. $data arrays.
isNew()  : bool
Determines if the data is new data, or updated data. Basically determines if a database INSERT or UPDATE SQL statement is generated.
isPreferencesComplete()  : bool
isSQLExceptionRetryable()  : bool
Determines if a SQL exception is one that can be retried or not.
isValid()  : bool
Call class specific validation function just before saving.
isWarning()  : bool
Call class specific validation function just before saving.
modifyInsertQuery()  : mixed
Modifies the automatically generated SQL INSERT query for adding things like " ON CONFLICT ..."
parseCustomFieldsFromArray()  : mixed
postSave()  : bool
preValidate()  : bool
removeCache()  : bool
RetryTransaction()  : mixed
Accepts a Closure and is retried at set intervals which should be in a transaction.
rewind()  : bool
Rewinds record set iterator to begining. The same as ADODB's MoveFirst() function.
RollbackSavePoint()  : bool
Save()  : bool|int|string
Determines to insert or update, and does it.
saveCache()  : bool
serializeRS()  : string
Serialize ADODB recordset.
setAPIMessageID()  : bool
setBrowserPermissionAskDate()  : bool
setCacheLifeTime()  : bool
setCreatedAndUpdatedColumns()  : bool
setCreatedBy()  : bool
setCreatedDate()  : bool
setCustomField()  : void
Set a single custom field by ID.
setCustomFields()  : bool
setDateFormat()  : bool
setDateTimePreferences()  : bool
setDefaultLoginScreen()  : bool
setDeleted()  : bool
setDeletedBy()  : bool|null
setDeletedDate()  : bool
setDistanceFormat()  : bool
setEnableAlwaysBlankTimeSheetRows()  : bool
setEnableAutoContextMenu()  : bool
setEnableEmailNotificationException()  : bool
setEnableEmailNotificationHome()  : bool
setEnableEmailNotificationMessage()  : bool
setEnableEmailNotificationPayStub()  : bool
setEnableReportOpenNewWindow()  : bool
setEnableSaveTimesheetState()  : bool
setEnableSystemLogDetail()  : bool
setGenericDataValue()  : bool
setGenericJSONDataValue()  : bool
Generic getter/setter functions for handling generic JSON data in 'other_json' SQL column.
setGenericObject()  : bool
Allow method to pre-populate/overwrite the cache if needed.
setGenericTempDataValue()  : bool
setId()  : bool
setIsValid()  : bool
Sets the is_valid flag, mostly used to set it to FALSE to force a full re-validation.
setItemsPerPage()  : bool
setLanguage()  : bool
setNotificationDuration()  : bool
setNotificationStatus()  : bool
setObjectFromArray()  : bool
Support setting created_by, updated_by especially for importing data.
setProgressBarObject()  : bool
setQueryStatementTimeout()  : bool
setScheduleIcalendarAlarm1Absence()  : bool
setScheduleIcalendarAlarm1Modified()  : bool
setScheduleIcalendarAlarm1Working()  : bool
setScheduleIcalendarAlarm2Absence()  : bool
setScheduleIcalendarAlarm2Modified()  : bool
setScheduleIcalendarAlarm2Working()  : bool
setScheduleIcalendarEventName()  : bool
setScheduleIcalendarType()  : bool
setShortcutKeySequence()  : bool
setStartWeekDay()  : bool
setTimeFormat()  : bool
setTimeSheetView()  : bool
setTimeUnitFormat()  : bool
setTimeZone()  : bool
setTimeZonePreferences()  : bool
A quick function to change just the timezone, without having to change date formats and such in the process.
setTransactionMode()  : mixed
setUpdatedBy()  : bool|null
setUpdatedDate()  : bool|int|null|string
setUser()  : bool
StartSavePoint()  : bool
StartTransaction()  : mixed
toBool()  : int
toJSONBool()  : string
Validate()  : bool
validateCustomFields()  : mixed
_getFactoryOptions()  : bool
_getVariableToFunctionMap()  : bool
castInteger()  : bool|int|string
getColumnsFromAliases()  : array<string|int, mixed>
getCustomFieldWhereSQL()  : string
getDatabaseType()  : string
getListSQL()  : bool|int|string|array<string|int, mixed>
getSortSQL()  : bool|string
getSQLStringAggregate()  : string
getSQLToEpochFunction()  : string
getSQLToTimeFunction()  : string
getSQLToTimeStampFunction()  : string
getWhereClauseSQL()  : null|string
getWhereSQL()  : bool|string
handleSQLSyntax()  : string
SQL where clause Syntax: or % as wildcard.
stripSQLSyntax()  : mixed
getInsertQuery()  : mixed
getRecordSetColumnList()  : array<string|int, mixed>|bool
getUpdateQuery()  : bool
parseColumnName()  : bool|string
Parses out the exact column name, without any aliases, or = signs in it.

Properties

$cache

public Cache_Lite_Function|Cache_Lite_Output $cache = \null

$enable_system_log_detail

protected mixed $enable_system_log_detail = \true

Methods

__construct()

Factory constructor.

public __construct() : mixed
Return values
mixed

__toString()

Print primary columns from object.

public __toString() : bool|string
Return values
bool|string

bulkDelete()

public bulkDelete(string|array<string|int, mixed> $ids) : bool
Parameters
$ids : string|array<string|int, mixed>

UUID

Tags
throws
DBError
Return values
bool

castGenericDataValue()

Generic casting function that all set/get*() functions should pass through.

public castGenericDataValue( &$value,  $cast) : mixed

However for now lets wait until we have meta data from SQL schema so we can pass those datatypes directly into this.

Parameters
$value :

mixed

$cast :

string

Return values
mixed

checkScheduleICalendarKey()

public checkScheduleICalendarKey( $key) : bool
Parameters
$key :
Return values
bool

clearCacheSavedInTransaction()

public clearCacheSavedInTransaction() : bool
Return values
bool

clearData()

public clearData() : bool
Return values
bool

clearGeoCode()

public clearGeoCode([array<string|int, mixed> $data_diff = null ]) : bool
Parameters
$data_diff : array<string|int, mixed> = null
Return values
bool

clearNonMappedData()

Removes array elements from $data that are not in the function map.

public clearNonMappedData([array<string|int, mixed>|null $data = null ]) : array<string|int, mixed>|null
Parameters
$data : array<string|int, mixed>|null = null
Return values
array<string|int, mixed>|null

clearOldData()

public clearOldData() : bool
Return values
bool

CommitSavePoint()

public CommitSavePoint( $name) : bool
Parameters
$name :
Return values
bool

CommitTransaction()

public CommitTransaction([bool $unnest_transactions = false ]) : mixed
Parameters
$unnest_transactions : bool = false
Tags
throws
DBError
Return values
mixed

convertFlexArray()

public convertFlexArray(array<string|int, mixed> $array) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
Return values
array<string|int, mixed>

convertMetersToDistance()

public convertMetersToDistance( $meters[, null $format = null ]) : bool|float|int
Parameters
$meters :
$format : null = null
Return values
bool|float|int

decodeCustomFields()

public decodeCustomFields() : bool
Return values
bool

decodeGenericJSONData()

Decode generic 'other_json' column data.

public decodeGenericJSONData() : bool
Return values
bool

decodeJSONColumn()

Decodes JSON columns that are not the 'other_json' column.

public decodeJSONColumn( $column) : bool
Parameters
$column :
Return values
bool

Delete()

Deletes the record directly from the database.

public Delete([bool $disable_audit_log = false ]) : bool
Parameters
$disable_audit_log : bool = false
Tags
throws
DBError
Return values
bool

encodeCustomFields()

public encodeCustomFields() : bool
Return values
bool

encodeGenericJSONData()

Encode generic 'other_json' column data. This should only be done in Save() after all validation has occurred already and we are just about to commit it to the DB.

public encodeGenericJSONData() : bool
Return values
bool

encodeJSONColumns()

Encode any JSON columns that are not 'other_json' column. This should only be done in Save() after all validation has occurred already and we are just about to commit it to the DB.

public encodeJSONColumns() : bool
Return values
bool

ExecuteSQL()

Execute SQL queries and handle paging properly for select statements.

public ExecuteSQL(string $query[, array<string|int, mixed> $ph = null ][, int $limit = null ][, int $page = null ]) : bool
Parameters
$query : string
$ph : array<string|int, mixed> = null
$limit : int = null

Limit the number of records returned

$page : int = null

Page number of records to return for pagination

Tags
throws
DBError
throws
Exception
Return values
bool

FailTransaction()

public FailTransaction() : mixed
Return values
mixed

fromBool()

public fromBool(string|int|bool $value) : bool
Parameters
$value : string|int|bool
Return values
bool

fromJSONBool()

public fromJSONBool(string|int|bool $value) : bool
Parameters
$value : string|int|bool
Return values
bool

getAffectedRows()

public getAffectedRows() : int|bool
Return values
int|bool

getAll()

public getAll([int $limit = null ][, int $page = null ][, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : $this
Parameters
$limit : int = null

Limit the number of records returned

$page : int = null

Page number of records to return for pagination

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
$this

getAPIMessageID()

Used for updating progress bar for API calls.

public getAPIMessageID() : bool|null
Return values
bool|null

getAPISearchByCompanyIdAndArrayCriteria()

public getAPISearchByCompanyIdAndArrayCriteria(string $company_id,  $filter_data[, int $limit = null ][, int $page = null ][, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$company_id : string

UUID

$filter_data :
$limit : int = null

Limit the number of records returned

$page : int = null

Page number of records to return for pagination

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getBrowserPermissionAskDate()

public getBrowserPermissionAskDate([mixed $raw = false ]) : int
Parameters
$raw : mixed = false
Return values
int

getByCompanyId()

public getByCompanyId(string $company_id[, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$company_id : string

UUID

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getByCompanyIdAndDateAndValidUserIDs()

public getByCompanyIdAndDateAndValidUserIDs(string $company_id[, int $date = null ][, array<string|int, mixed> $valid_user_ids = [] ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$company_id : string

UUID

$date : int = null

EPOCH

$valid_user_ids : array<string|int, mixed> = []
$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getById()

public getById(string $id[, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string

UUID

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getByIdAndCompanyId()

public getByIdAndCompanyId(string $id, string $company_id[, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string

UUID

$company_id : string

UUID

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getByUserId()

public getByUserId(string|array<string|int, string> $id[, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string|array<string|int, string>

UUID

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getByUserIDAndCompanyID()

public getByUserIDAndCompanyID(string $id, string $company_id[, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string

UUID

$company_id : string

UUID

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getByUserIdAndEnableLogin()

public getByUserIdAndEnableLogin(string|array<string|int, string> $id[, bool $enable_login = true ][, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string|array<string|int, string>

UUID

$enable_login : bool = true
$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Tags
throws
DBError
Return values
bool|UserPreferenceListFactory

getByUserIdAndStatus()

public getByUserIdAndStatus(string|array<string|int, string> $id[, int|array<string|int, int> $status_id = 10 ][, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool|UserPreferenceListFactory
Parameters
$id : string|array<string|int, string>

UUID

$status_id : int|array<string|int, int> = 10
$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool|UserPreferenceListFactory

getCache()

public getCache(string $cache_id[, string $group_id = null ]) : bool|mixed
Parameters
$cache_id : string
$group_id : string = null
Return values
bool|mixed

getColumn()

Generic function get any data from the data array.

public getColumn(string $column) : bool|mixed

Used mainly for the reports that return grouped queries and such.

Parameters
$column : string
Return values
bool|mixed

getColumnList()

public getColumnList() : array<string|int, mixed>|bool
Return values
array<string|int, mixed>|bool

getCompanyGenericMapData()

Generic function to return and cache CompanyGenericMap data, this greatly improves performance of CalculatePolicy when many policies exist.

public getCompanyGenericMapData(string $company_id, int $object_type_id, string $id, string $variable) : mixed
Parameters
$company_id : string

UUID

$object_type_id : int
$id : string

UUID

$variable : string
Return values
mixed

getCreatedAndUpdatedColumns()

public getCreatedAndUpdatedColumns(array<string|int, mixed> &$data[, null $include_columns = null ]) : bool
Parameters
$data : array<string|int, mixed>
$include_columns : null = null
Return values
bool

getCreatedBy()

public getCreatedBy() : bool|mixed
Return values
bool|mixed

getCreatedDate()

public getCreatedDate() : int
Return values
int

getCurrent()

Grabs the current object

public final getCurrent() : mixed
Return values
mixed

getCurrentRow()

public getCurrentRow([int $offset = 1 ]) : int|bool
Parameters
$offset : int = 1
Return values
int|bool

getCustomField()

Get a single custom field by ID.

public getCustomField(string $id) : void
Parameters
$id : string

UUID

Return values
void

getCustomFields()

public getCustomFields( $company_id,  $data[,  $include_columns = null ]) : mixed
Parameters
$company_id :
$data :
$include_columns : = null
Return values
mixed

getCustomFieldsColumns()

public getCustomFieldsColumns(array<string|int, mixed> $columns, string $company_id[, bool $use_sort_prefix = true ][, string|null $table_name = null ]) : array<string|int, mixed>
Parameters
$columns : array<string|int, mixed>
$company_id : string
$use_sort_prefix : bool = true
$table_name : string|null = null
Return values
array<string|int, mixed>

getCustomFieldsDataForObject()

Get custom field data for this specific object, so it can be easily cached in memory without having to go to the database or unserialize it from cache for every row.

public getCustomFieldsDataForObject( $company_id[, mixed $table_name = null ]) : array<string|int, mixed>
Parameters
$company_id :
$table_name : mixed = null
Tags
throws
ReflectionException
Return values
array<string|int, mixed>

getCustomFieldsDefaultData()

public getCustomFieldsDefaultData( $company_id,  $data[, bool $get_all_fields = false ]) : mixed
Parameters
$company_id :
$data :
$get_all_fields : bool = false
Return values
mixed

getCustomFieldsParseHints()

public getCustomFieldsParseHints(array<string|int, mixed> $columns, string $company_id, string|null $table_name) : array<string|int, mixed>
Parameters
$columns : array<string|int, mixed>
$company_id : string
$table_name : string|null
Return values
array<string|int, mixed>

getCustomFieldTableName()

public getCustomFieldTableName() : string
Return values
string

getDataDifferences()

Returns the differences in data from the DB vs the in-memory object, so the data will be the OLD data. Used in Validation/postSave() functions to determine if a field has changed or not.

public getDataDifferences() : array<string|int, mixed>
Return values
array<string|int, mixed>

getDateRangeSQL()

This function takes plain input from the user and creates a SQL statement for filtering based on a date range.

public getDateRangeSQL(string $str, string $column[, string $format = 'epoch' ][, bool $include_blank_dates = false ]) : bool|string

Supported Syntax:

=01-Jan-09 <=01-Jan-09 <01-Jan-09 01-Jan-09 01-Jan-09 & <10-Jan-09

Parameters
$str : string
$column : string
$format : string = 'epoch'
$include_blank_dates : bool = false
Return values
bool|string

getDefaultLoginScreen()

Default: Home/Dashboard

public getDefaultLoginScreen() : bool|mixed
Return values
bool|mixed

getDeleted()

public getDeleted() : bool
Return values
bool

getDeletedBy()

public getDeletedBy() : bool|mixed
Return values
bool|mixed

getDeletedDate()

public getDeletedDate() : bool|mixed
Return values
bool|mixed

getEmptyRecordSet()

public getEmptyRecordSet([string $id = null ]) : mixed
Parameters
$id : string = null

UUID

Tags
throws
DBError
Return values
mixed

getEnableSystemLogDetail()

public getEnableSystemLogDetail() : bool
Return values
bool

getGenericDataValue()

Generic getter/setter functions that should be used when Validation code is moved from get/set functions to Validate() function.

public getGenericDataValue(string $name[, null $cast = null ]) : bool|mixed
Parameters
$name : string
$cast : null = null
Return values
bool|mixed

getGenericJSONDataValue()

Generic getter/setter functions for handling generic JSON data in 'other_json' SQL column.

public getGenericJSONDataValue(string $name[, null $cast = null ]) : bool|mixed
Parameters
$name : string
$cast : null = null
Return values
bool|mixed

getGenericObject()

Generic function to return and cache class objects ListFactory, ListFactoryMethod, Variable, ID, IDMethod

public getGenericObject(string $list_factory, string|int $id, string $variable[, string $list_factory_method = 'getById' ][, string $id_method = 'getID' ]) : object|bool
Parameters
$list_factory : string
$id : string|int

UUID

$variable : string
$list_factory_method : string = 'getById'
$id_method : string = 'getID'
Return values
object|bool

getGenericOldDataValue()

public getGenericOldDataValue(string $name) : bool|mixed
Parameters
$name : string

Gets data value from old_data array, or the original value in the database, prior to any changes currently in memory.

Return values
bool|mixed

getGenericTempDataValue()

Generic getter/setter functions that should be used when Validation code is moved from get/set functions to Validate() function.

public getGenericTempDataValue(string $name) : bool
Parameters
$name : string
Return values
bool

getId()

public getId() : bool|mixed
Return values
bool|mixed

getIDSByListFactory()

public getIDSByListFactory(object $lf) : array<string|int, mixed>|bool
Parameters
$lf : object
Return values
array<string|int, mixed>|bool

getIsModifiedByCompanyIdAndDate()

public getIsModifiedByCompanyIdAndDate(string $company_id, int $date[, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool
Parameters
$company_id : string

UUID

$date : int

EPOCH

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool

getLabelId()

public getLabelId() : bool|mixed|string
Return values
bool|mixed|string

getLocationTimeZone()

public getLocationTimeZone( $country,  $province[, bool $work_phone = false ][, bool $home_phone = false ][, bool $default = false ][, mixed $enable_auto_detect = true ]) : array<string|int, mixed>|bool|mixed|string
Parameters
$country :
$province :
$work_phone : bool = false
$home_phone : bool = false
$default : bool = false
$enable_auto_detect : mixed = true
Return values
array<string|int, mixed>|bool|mixed|string

getMostCommonTimeZone()

Returns the most commonly used timezone by employees.

public getMostCommonTimeZone([array<string|int, mixed> $where = null ]) : mixed
Parameters
$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

Return values
mixed

getNextInsertId()

public getNextInsertId() : bool|string
Return values
bool|string

getObjectAsArray()

public getObjectAsArray([null $include_columns = null ][, bool $permission_children_ids = false ]) : array<string|int, mixed>
Parameters
$include_columns : null = null
$permission_children_ids : bool = false
Return values
array<string|int, mixed>

getOptions()

public getOptions(string $name[, string|int $parent = null ]) : array<string|int, mixed>|bool
Parameters
$name : string
$parent : string|int = null
Return values
array<string|int, mixed>|bool

getPermissionColumns()

public getPermissionColumns(array<string|int, mixed> &$data, string $object_user_id, string $created_by_id[, string $permission_children_ids = null ][, array<string|int, mixed> $include_columns = null ]) : bool
Parameters
$data : array<string|int, mixed>
$object_user_id : string

UUID

$created_by_id : string

UUID

$permission_children_ids : string = null

UUID

$include_columns : array<string|int, mixed> = null
Return values
bool

getRecordCount()

public getRecordCount() : int|bool
Return values
int|bool

getScheduleIcalendarAlarm1Absence()

public getScheduleIcalendarAlarm1Absence() : bool|int
Return values
bool|int

getScheduleIcalendarAlarm1Modified()

public getScheduleIcalendarAlarm1Modified() : bool|int
Return values
bool|int

getScheduleIcalendarAlarm1Working()

public getScheduleIcalendarAlarm1Working() : bool|int
Return values
bool|int

getScheduleIcalendarAlarm2Absence()

public getScheduleIcalendarAlarm2Absence() : bool|int
Return values
bool|int

getScheduleIcalendarAlarm2Modified()

public getScheduleIcalendarAlarm2Modified() : bool|int
Return values
bool|int

getScheduleIcalendarAlarm2Working()

public getScheduleIcalendarAlarm2Working() : bool|int
Return values
bool|int

getScheduleIcalendarEventName()

Currently used as part of the unauthenticated key, so if this changes the key to access the calendar changes too.

public getScheduleIcalendarEventName() : bool
Return values
bool

getScheduleIcalendarKey()

public getScheduleIcalendarKey([null $version = null ]) : bool|string
Parameters
$version : null = null
Return values
bool|string

getScheduleIcalendarURL()

Helper functions for dealing with unauthenticated calendar access, required by Google Calendar for now.

public getScheduleIcalendarURL([null $user_name = null ][, int $type_id = null ][, null $selected_schedule = null ]) : string
Parameters
$user_name : null = null
$type_id : int = null

ID

$selected_schedule : null = null
Return values
string

getSequenceName()

public getSequenceName() : bool
Return values
bool

getShortcutKeySequence()

Used in Flex interface only, currently its hardcoded for now at least. Default: CTRL+ALT

public getShortcutKeySequence() : bool|mixed
Return values
bool|mixed

getTable()

public getTable([bool $strip_quotes = false ]) : bool|string
Parameters
$strip_quotes : bool = false
Return values
bool|string

getTimeFormatExample()

public getTimeFormatExample() : array<string|int, mixed>|mixed
Return values
array<string|int, mixed>|mixed

getTransactionMode()

public getTransactionMode([bool $force = false ]) : string
Parameters
$force : bool = false
Return values
string

getUniqueLanguageByCompanyId()

public getUniqueLanguageByCompanyId(string $id[, array<string|int, mixed> $where = null ][, array<string|int, mixed> $order = null ]) : bool
Parameters
$id : string

UUID

$where : array<string|int, mixed> = null

Additional SQL WHERE clause in format of array( $column => $filter, ... ). ie: array( 'id' => 1, ... )

$order : array<string|int, mixed> = null

Sort order passed to SQL in format of array( $column => 'asc', 'name' => 'desc', ... ). ie: array( 'id' => 'asc', 'name' => 'desc', ... )

Return values
bool

getUpdatedBy()

public getUpdatedBy() : bool|mixed
Return values
bool|mixed

getUpdatedDate()

public getUpdatedDate() : int
Return values
int

getValidSQLColumns()

public getValidSQLColumns(array<string|int, mixed> $array[, bool $strict = true ][, array<string|int, mixed> $additional_fields = null ]) : array<string|int, mixed>
Parameters
$array : array<string|int, mixed>
$strict : bool = true
$additional_fields : array<string|int, mixed> = null
Tags
throws
Exception
Return values
array<string|int, mixed>

getVariableToFunctionMap()

public getVariableToFunctionMap([array<string|int, mixed> $data = null ]) : array<string|int, mixed>|bool
Parameters
$data : array<string|int, mixed> = null
Return values
array<string|int, mixed>|bool

handleSaveSQLReturning()

Used to handle any "RETURNING ..." clause on a SQL INSERT/UPDATE query.

public handleSaveSQLReturning( $rs) : bool
Parameters
$rs :
Return values
bool

hasDataChanged()

Determine if the record data has changed at all.

public hasDataChanged() : bool
Return values
bool

isClientFriendly()

Check if the remote client is our main UI app controlled by us, vs. a user utilizing the API for example.

public isClientFriendly() : bool

This is mostly used to determine if we can return columns that are resource intensive to compute when obtaining a list. (ie: Users, Jobs)

Return values
bool

isDataDifferent()

Used to check the differences between a single key in the $old_data vs. $data arrays.

public isDataDifferent( $key,  $data_diff[, null $type_id = null ][, null $new_data = null ]) : bool

This is especially important to use when trying to see if a date or timestamp field in the DB has changed, as they need to be handled in special ways.

Parameters
$key :

string

$data_diff :

array

$type_id : null = null

string

$new_data : null = null

mixed

Return values
bool

isNew()

Determines if the data is new data, or updated data. Basically determines if a database INSERT or UPDATE SQL statement is generated.

public isNew([bool $force_lookup = false ][, string $id = null ]) : bool
Parameters
$force_lookup : bool = false
$id : string = null

UUID

Return values
bool

isSQLExceptionRetryable()

Determines if a SQL exception is one that can be retried or not.

public isSQLExceptionRetryable( $e) : bool
Parameters
$e :

Exception

Return values
bool

isValid()

Call class specific validation function just before saving.

public isValid([bool $ignore_warning = true ]) : bool
Parameters
$ignore_warning : bool = true
Return values
bool

isWarning()

Call class specific validation function just before saving.

public isWarning() : bool
Return values
bool

modifyInsertQuery()

Modifies the automatically generated SQL INSERT query for adding things like " ON CONFLICT ..."

public modifyInsertQuery( $query) : mixed
Parameters
$query :
Return values
mixed

parseCustomFieldsFromArray()

public parseCustomFieldsFromArray( $data) : mixed
Parameters
$data :
Return values
mixed

removeCache()

public removeCache([string $cache_id = null ][, string $group_id = null ]) : bool
Parameters
$cache_id : string = null
$group_id : string = null
Return values
bool

RetryTransaction()

Accepts a Closure and is retried at set intervals which should be in a transaction.

public RetryTransaction( $transaction_function[, int $retry_max_attempts = 4 ][, int $retry_sleep = 1 ]) : mixed
Parameters
$transaction_function :

Closure

$retry_max_attempts : int = 4
$retry_sleep : int = 1

in seconds

Tags
throws
DBError
Return values
mixed

rewind()

Rewinds record set iterator to begining. The same as ADODB's MoveFirst() function.

public final rewind() : bool
Return values
bool

RollbackSavePoint()

public RollbackSavePoint( $name) : bool
Parameters
$name :
Return values
bool

Save()

Determines to insert or update, and does it.

public Save([bool $reset_data = true ][, bool $force_lookup = false ]) : bool|int|string

Have this handle created, createdby, updated, updatedby.

Parameters
$reset_data : bool = true
$force_lookup : bool = false
Tags
throws
DBError
throws
GeneralError
Return values
bool|int|string

saveCache()

public saveCache(mixed $data, string $cache_id[, string $group_id = null ]) : bool
Parameters
$data : mixed
$cache_id : string
$group_id : string = null
Return values
bool

serializeRS()

Serialize ADODB recordset.

public serializeRS(object $rs) : string
Parameters
$rs : object
Tags
noinspection

PhpUndefinedConstantInspection

Return values
string

setAPIMessageID()

public setAPIMessageID(string $id) : bool
Parameters
$id : string

UUID

Return values
bool

setBrowserPermissionAskDate()

public setBrowserPermissionAskDate( $epoch) : bool
Parameters
$epoch :
Return values
bool

setCacheLifeTime()

public setCacheLifeTime(int $secs) : bool
Parameters
$secs : int
Return values
bool

setCreatedAndUpdatedColumns()

public setCreatedAndUpdatedColumns(array<string|int, mixed> $data[, array<string|int, mixed> $variable_to_function_map = [] ]) : bool
Parameters
$data : array<string|int, mixed>
$variable_to_function_map : array<string|int, mixed> = []
Return values
bool

setCreatedBy()

public setCreatedBy([string $id = null ]) : bool
Parameters
$id : string = null

UUID

Return values
bool

setCreatedDate()

public setCreatedDate([int $epoch = null ]) : bool
Parameters
$epoch : int = null

EPOCH

Return values
bool

setCustomField()

Set a single custom field by ID.

public setCustomField(mixed $value, string $id) : void
Parameters
$value : mixed
$id : string

UUID

Return values
void

setCustomFields()

public setCustomFields( $data) : bool
Parameters
$data :
Return values
bool

setDeleted()

public setDeleted(bool $bool) : bool
Parameters
$bool : bool
Return values
bool

setDeletedBy()

public setDeletedBy([string $id = null ]) : bool|null
Parameters
$id : string = null

UUID

Return values
bool|null

setDeletedDate()

public setDeletedDate([int $epoch = null ]) : bool
Parameters
$epoch : int = null

EPOCH

Return values
bool

setEnableAlwaysBlankTimeSheetRows()

public setEnableAlwaysBlankTimeSheetRows( $value) : bool
Parameters
$value :
Return values
bool

setEnableAutoContextMenu()

public setEnableAutoContextMenu( $value) : bool
Parameters
$value :
Return values
bool

setEnableEmailNotificationException()

public setEnableEmailNotificationException( $value) : bool
Parameters
$value :
Return values
bool

setEnableEmailNotificationHome()

public setEnableEmailNotificationHome( $value) : bool
Parameters
$value :
Return values
bool

setEnableEmailNotificationMessage()

public setEnableEmailNotificationMessage( $value) : bool
Parameters
$value :
Return values
bool

setEnableEmailNotificationPayStub()

public setEnableEmailNotificationPayStub( $value) : bool
Parameters
$value :
Return values
bool

setEnableReportOpenNewWindow()

public setEnableReportOpenNewWindow( $value) : bool
Parameters
$value :
Return values
bool

setEnableSaveTimesheetState()

public setEnableSaveTimesheetState( $value) : bool
Parameters
$value :
Return values
bool

setEnableSystemLogDetail()

public setEnableSystemLogDetail( $bool) : bool
Parameters
$bool :
Return values
bool

setGenericDataValue()

public setGenericDataValue(string $name, mixed $data[, null $cast = null ]) : bool
Parameters
$name : string
$data : mixed
$cast : null = null
Return values
bool

setGenericJSONDataValue()

Generic getter/setter functions for handling generic JSON data in 'other_json' SQL column.

public setGenericJSONDataValue(string $name, mixed $data[, null $cast = null ]) : bool
Parameters
$name : string
$data : mixed
$cast : null = null
Return values
bool

setGenericObject()

Allow method to pre-populate/overwrite the cache if needed.

public setGenericObject(object $obj, string $variable) : bool
Parameters
$obj : object
$variable : string
Return values
bool

setGenericTempDataValue()

public setGenericTempDataValue(string $name, mixed $data) : bool
Parameters
$name : string
$data : mixed
Return values
bool

setId()

public setId(string $id) : bool
Parameters
$id : string

UUID

Return values
bool

setIsValid()

Sets the is_valid flag, mostly used to set it to FALSE to force a full re-validation.

public setIsValid([bool $is_valid = false ]) : bool

Required because $this->is_valid is a private variable and should stay that way.

Parameters
$is_valid : bool = false
Return values
bool

setNotificationDuration()

public setNotificationDuration( $value) : bool
Parameters
$value :
Return values
bool

setObjectFromArray()

Support setting created_by, updated_by especially for importing data.

public setObjectFromArray( $data) : bool

Make sure data is set based on the getVariableToFunctionMap order.

Parameters
$data :
Return values
bool

setProgressBarObject()

public setProgressBarObject(object $obj) : bool
Parameters
$obj : object
Return values
bool

setQueryStatementTimeout()

public setQueryStatementTimeout([null $milliseconds = null ]) : bool
Parameters
$milliseconds : null = null
Return values
bool

setScheduleIcalendarAlarm1Absence()

public setScheduleIcalendarAlarm1Absence( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarAlarm1Modified()

public setScheduleIcalendarAlarm1Modified( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarAlarm1Working()

public setScheduleIcalendarAlarm1Working( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarAlarm2Absence()

public setScheduleIcalendarAlarm2Absence( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarAlarm2Modified()

public setScheduleIcalendarAlarm2Modified( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarAlarm2Working()

public setScheduleIcalendarAlarm2Working( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarEventName()

public setScheduleIcalendarEventName( $value) : bool
Parameters
$value :
Return values
bool

setScheduleIcalendarType()

public setScheduleIcalendarType( $value) : bool
Parameters
$value :
Return values
bool

setShortcutKeySequence()

public setShortcutKeySequence( $value) : bool
Parameters
$value :
Return values
bool

setTimeZonePreferences()

A quick function to change just the timezone, without having to change date formats and such in the process.

public setTimeZonePreferences() : bool
Return values
bool

setTransactionMode()

public setTransactionMode([string $mode = '' ]) : mixed
Parameters
$mode : string = ''
Return values
mixed

setUpdatedBy()

public setUpdatedBy([string $id = null ]) : bool|null
Parameters
$id : string = null

UUID

Return values
bool|null

setUpdatedDate()

public setUpdatedDate([int $epoch = null ]) : bool|int|null|string
Parameters
$epoch : int = null

EPOCH

Return values
bool|int|null|string

StartSavePoint()

public StartSavePoint( $name) : bool
Parameters
$name :
Return values
bool

StartTransaction()

public StartTransaction() : mixed
Return values
mixed

toBool()

public toBool(string|int|bool $value) : int
Parameters
$value : string|int|bool
Return values
int

toJSONBool()

public toJSONBool(string|int|bool $value) : string
Parameters
$value : string|int|bool
Return values
string

Validate()

public Validate([bool $ignore_warning = true ]) : bool
Parameters
$ignore_warning : bool = true
Return values
bool

validateCustomFields()

public validateCustomFields(mixed $company_id[, mixed $enable_required_field_check = true ]) : mixed
Parameters
$company_id : mixed
$enable_required_field_check : mixed = true
Return values
mixed

_getFactoryOptions()

protected _getFactoryOptions(string $name[, string|int $parent = null ]) : bool
Parameters
$name : string
$parent : string|int = null
Return values
bool

_getVariableToFunctionMap()

protected _getVariableToFunctionMap(array<string|int, mixed> $data) : bool
Parameters
$data : array<string|int, mixed>
Return values
bool

castInteger()

protected castInteger(int|string $int[, string $type = 'int' ]) : bool|int|string
Parameters
$int : int|string
$type : string = 'int'
Return values
bool|int|string

getColumnsFromAliases()

protected getColumnsFromAliases(array<string|int, mixed> $columns, array<string|int, mixed> $aliases) : array<string|int, mixed>
Parameters
$columns : array<string|int, mixed>
$aliases : array<string|int, mixed>
Return values
array<string|int, mixed>

getCustomFieldWhereSQL()

protected getCustomFieldWhereSQL(mixed $company_id, mixed $column, array<string|int, mixed> $filter_data, array<string|int, mixed> &$ph) : string
Parameters
$company_id : mixed
$column : mixed
$filter_data : array<string|int, mixed>
$ph : array<string|int, mixed>
Return values
string

getDatabaseType()

protected getDatabaseType() : string
Return values
string

getListSQL()

protected getListSQL(array<string|int, mixed>|string|int $array[, array<string|int, mixed> &$ph = null ][, string|bool $cast = false ]) : bool|int|string|array<string|int, mixed>
Parameters
$array : array<string|int, mixed>|string|int
$ph : array<string|int, mixed> = null
$cast : string|bool = false
Return values
bool|int|string|array<string|int, mixed>

getSortSQL()

protected getSortSQL(array<string|int, mixed> $array[, bool $strict = true ][, array<string|int, mixed> $additional_fields = null ]) : bool|string
Parameters
$array : array<string|int, mixed>
$strict : bool = true
$additional_fields : array<string|int, mixed> = null
Return values
bool|string

getSQLStringAggregate()

protected getSQLStringAggregate(string $sql, string $glue) : string
Parameters
$sql : string
$glue : string
Return values
string

getSQLToEpochFunction()

protected getSQLToEpochFunction(string $sql) : string
Parameters
$sql : string
Return values
string

getSQLToTimeFunction()

protected getSQLToTimeFunction(string $sql) : string
Parameters
$sql : string
Return values
string

getSQLToTimeStampFunction()

protected getSQLToTimeStampFunction() : string
Return values
string

getWhereClauseSQL()

protected getWhereClauseSQL(array<string|int, mixed>|string $columns, array<string|int, mixed>|string $args, string $type, array<string|int, mixed> &$ph[, string $query_stub = null ][, bool $and = true ]) : null|string
Parameters
$columns : array<string|int, mixed>|string
$args : array<string|int, mixed>|string
$type : string
$ph : array<string|int, mixed>
$query_stub : string = null
$and : bool = true
Tags
noinspection

PhpParamsInspection

Return values
null|string

getWhereSQL()

protected getWhereSQL(array<string|int, mixed> $array[, bool $append_where = false ]) : bool|string
Parameters
$array : array<string|int, mixed>
$append_where : bool = false
Return values
bool|string

handleSQLSyntax()

SQL where clause Syntax: or % as wildcard.

protected handleSQLSyntax(string $arg) : string

"" as exact match, no default wildcard and no metaphone

Handles '*' and '%' as wildcards, defaults to wildcard on the end always. If no wildcard is to be added, the last character should be |

Parameters
$arg : string
Return values
string

stripSQLSyntax()

protected stripSQLSyntax(string $arg) : mixed
Parameters
$arg : string
Return values
mixed

getInsertQuery()

private getInsertQuery() : mixed
Return values
mixed

getRecordSetColumnList()

private getRecordSetColumnList(object $rs) : array<string|int, mixed>|bool
Parameters
$rs : object
Return values
array<string|int, mixed>|bool

parseColumnName()

Parses out the exact column name, without any aliases, or = signs in it.

private parseColumnName(string $column) : bool|string
Parameters
$column : string
Return values
bool|string

Search results