1. class
  2. Core
  3. \
  4. Models
  5. \
  6. ProfileImages

ProfileImages

final class ProfileImages extends Model

Supports CRUD operations on profile image records.

Constants

BLACKLIST

Constant for blacklist
WHITELIST

Constant for whitelist

Properties

static protected DB $_db

The instance of the DB class.

 from  Model
int $id

ID for this image.
protected string $_modelName

The name of the model.

 from  Model
static protected bool $_softDelete

Soft delete mode set to true.
static protected string $_table

Name of the table.
protected bool $_validates

Flag to indicate if validation is successful.

 from  Model
protected array $_validationErrors

The array of validation errors.

 from  Model
static protected array $allowedFileTypes

The allowed file types.
int $deleted

Deleted value, defaults to 0.
static protected int $maxAllowedFileSize

Max allowed size.
string $name

Name of the file.
int $sort

Sorted position.
static protected string $_uploadPath

Upload path.
string $url

The URL for the profile image.
int $user_id

ID of user associated with image.

Methods

__construct()

Default constructor.

from  Model
void
addErrorMessage(string $field, string $message)

Generates error messages that occur during form validation.

from  Model
void
afterDelete()

Called before delete.

from  Model
void
afterSave()

Called before save.

from  Model
Model
assign(array $params, array $list = [], string $assignmentFilter = self::BLACKLIST)

Update the object with an associative array.

from  Model
void
beforeDelete()

This runs before delete, needs to return a boolean

from  Model
void
beforeSave()

Implements beforeSave function described in Model parent class.

stdClass
data()

Grab object and if we just need data for smaller result set.

from  Model
bool
delete()

Wrapper for database delete function. If not softDelete we set it.

from  Model
static array
getColumns()

Gets columns from table.

from  Model
array
getColumnsForSave()

Gets an associative array of field values for insert or updating.

from  Model
static DB
getDb()

Returns an instance of the DB class.

from  Model
array
getErrorMessages()

Displays error messages when form validation fails.

from  Model
static array
_fetchStyleParams(array $params)

Used to set default fetchStyle param.

from  Model
static array|bool
find(array $params = [])

Wrapper for the find function that is found in the DB class.

from  Model
static object|bool
findById(int $id)

Get result from database by primary key ID.

from  Model
static array|bool
findByTable(string $table, array $params = [])

Performs a database query against a specified table using the same query-building logic as the default find method.

from  Model
static array
findAllByUserId(int $user_id, array $params = [])

Retrieves list of all records within a table related to a user.

from  Model
static object|bool
findFirst(array $params = [])

Wrapper for the findFirst function that is found in the DB class.

from  Model
static int
findTotal(array $params = [])

Returns number of records in a table. A wrapper function for findTotal function in DB class.

from  Model
bool
insert(array $fields)

Wrapper for database insert function.

from  Model
bool
isNew()

Checks if an object is a new insertion or an existing record.

from  Model
void
onConstruct()

Runs when the object is constructed.

from  Model
void
populateObjData(array|object $result)

Populates object with data.

from  Model
DB
query(string $sql, array $bind = [])

Wrapper for database query function.

from  Model
void
runValidation(object $validator)

Runs a validator object and sets validates boolean and adds error message if validator fails.

from  Model
bool
save()

Wrapper for update and insert functions. A failed form validation will cause this function to return false.

from  Model
static array
_softDeleteParams(array $params)

Adds to the conditions to avoid getting soft deleted rows returned

from  Model
void
timeStamps()

Sets values for timestamp fields.

from  Model
bool
update(array $fields)

Wrapper for the update function found in the DB class.

from  Model
static int
updateWhere(array $fields, array $params)

Updates one or more rows in this model's underlying table using your framework's params-style conditions.

from  Model
bool
validationPassed()

Getter function for the $_validates boolean instance variable.

from  Model
void
validator()

Function that is called on save. If validation fails the save function will not proceed. This function is just a signature and must be implemented by models that run form validation because since it is called from within this class.

from  Model
static bool
deleteById(int $id)

Deletes a profile image by id.

static void
deleteImages(int $user_id, bool $unlink = false)

Sets delete field in profile_images table to 1 when user is deleted from users table. Accepts parameter for toggling on or off unlink to permanently image file.

static ProfileImages|bool
findCurrentProfileImage(int $user_id)

Returns currently set profile image for a user.

static bool|array
findByUserId(int $user_id)

Finds all profile images for a user.

static array
getAllowedFileTypes()

Getter function for $allowedFileTypes array

static int
getMaxAllowedFileSize()

Getter function for $maxAllowedFileSize.

static void
updateSortByUserId(int $user_id, array $sortOrder = [])

Updates sort order by user id.

static void
uploadProfileImage(int $user_id, Uploads $uploads)

Performs upload operation for a profile image.

Details

in Model at line 68
__construct()

Default constructor.

in Model at line 82
void addErrorMessage(string $field, string $message)

Generates error messages that occur during form validation.

Parameters

string $field

The form field associated with failed form validation
string $message

A message that describes to the user the cause for failed form validation.

Return Value

void

in Model at line 95
void afterDelete()

Called before delete.

Return Value

void

in Model at line 102
void afterSave()

Called before save.

Return Value

void

in Model at line 114
Model assign(array $params, array $list = [], string $assignmentFilter = self::BLACKLIST)

Update the object with an associative array.

Parameters

array $params

Take values from post array and assign values.
array $list

A list of values to blacklist or whitelist.
string $assignmentFilter

When set to ModelName::BLACKLIST the values in the $list array is blacklisted. When set to ModelName::WHITELIST they are whitelisted.

Return Value

Model

Report for whether or not the operation was successful.

in Model at line 137
void beforeDelete()

This runs before delete, needs to return a boolean

Return Value

void

Boolean value depending on results of operation.

at line 86
void beforeSave()

Implements beforeSave function described in Model parent class.

Generates timestamps.

Return Value

void

in Model at line 151
stdClass data()

Grab object and if we just need data for smaller result set.

Return Value

stdClass

The data associated with an object.

in Model at line 178
bool delete()

Wrapper for database delete function. If not softDelete we set it.

If row is set to softDelete we call the database delete function.

Return Value

bool

$deleted True if delete operation is successful. Otherwise, we return false.

in Model at line 196
static array getColumns()

Gets columns from table.

Return Value

array

An array of objects where each one represents a column from a database table.

in Model at line 206
array getColumnsForSave()

Gets an associative array of field values for insert or updating.

Return Value

array

Associative array of fields from database and values from model object.

in Model at line 234
static DB getDb()

Returns an instance of the DB class.

Return Value

DB

$_db The instance of the DB class.

in Model at line 247
array getErrorMessages()

Displays error messages when form validation fails.

Return Value

array

An array that contains a list of items that failed form validation.

in Model at line 257
static protected array _fetchStyleParams(array $params)

Used to set default fetchStyle param.

Parameters

array $params

Query params.

Return Value

array

$params Updated params.

in Model at line 271
static array|bool find(array $params = [])

Wrapper for the find function that is found in the DB class.

Parameters

array $params

The values for the query. They are the fields of the table in our database. The default value is an empty array.

Return Value

array|bool

An array of objects returned from an SQL query.

in Model at line 285
static object|bool findById(int $id)

Get result from database by primary key ID.

Parameters

int $id

The ID of the row we want to retrieve from the database.

Return Value

object|bool

The row from a database.

in Model at line 301
static array|bool findByTable(string $table, array $params = [])

Performs a database query against a specified table using the same query-building logic as the default find method.

This method is useful when querying a different table than the one defined by the model's static::$_table property (e.g., joining or selecting from related tables).

Parameters

string $table

The name of the table to query (can include alias, e.g. 'cart_items AS items').
array $params

The query parameters such as columns, joins, conditions, bind, order, limit, etc.

Return Value

array|bool

An array of result objects if found, or false/empty array if no results.

in Model at line 317
static array findAllByUserId(int $user_id, array $params = [])

Retrieves list of all records within a table related to a user.

Parameters

int $user_id

The user ID.
array $params

Used to build conditions for database query. The default value is an empty array.

Return Value

array

The list of records that is returned from the database.

in Model at line 335
static object|bool findFirst(array $params = [])

Wrapper for the findFirst function that is found in the DB class.

Parameters

array $params

The values for the query. They are the fields of the table in our database. The default value is an empty array.

Return Value

object|bool

An array of object returned from an SQL query.

in Model at line 350
static int findTotal(array $params = [])

Returns number of records in a table. A wrapper function for findTotal function in DB class.

Parameters

array $params

The values for the query. They are the fields of the table in our database. The default value is an empty array.

Return Value

int

The number of records in a table.

in Model at line 365
bool insert(array $fields)

Wrapper for database insert function.

Parameters

array $fields

The field names and the respective values we will use to populate a database record. The default value is an empty array.

Return Value

bool

Report for whether or not the operation was successful.

in Model at line 377
bool isNew()

Checks if an object is a new insertion or an existing record.

Return Value

bool

Returns true if the record exists. Otherwise, we return false.

in Model at line 386
void onConstruct()

Runs when the object is constructed.

Return Value

void

in Model at line 394
protected void populateObjData(array|object $result)

Populates object with data.

Parameters

array|object $result

Results from a database query.

Return Value

void

in Model at line 409
DB query(string $sql, array $bind = [])

Wrapper for database query function.

Parameters

string $sql

The database query we will submit to the database.
array $bind

The values we want to bind in our database query. The default value is an empty array.

Return Value

DB

The results of the database query.

in Model at line 420
void runValidation(object $validator)

Runs a validator object and sets validates boolean and adds error message if validator fails.

Parameters

object $validator

The validator object.

Return Value

void

in Model at line 435
bool save()

Wrapper for update and insert functions. A failed form validation will cause this function to return false.

Return Value

bool

True if the update operation is successful. Otherwise, we return false.

in Model at line 470
static protected array _softDeleteParams(array $params)

Adds to the conditions to avoid getting soft deleted rows returned

Parameters

array $params

Defined parameters to search by.

Return Value

array

$params parameters with appended conditions for soft delete.

in Model at line 496
void timeStamps()

Sets values for timestamp fields.

Return Value

void

in Model at line 512
bool update(array $fields)

Wrapper for the update function found in the DB class.

Parameters

array $fields

The value of the fields we want to set for the database record. The default value is an empty array.

Return Value

bool

True if the update operation is successful. Otherwise, we return false.

in Model at line 542
static int updateWhere(array $fields, array $params)

Updates one or more rows in this model's underlying table using your framework's params-style conditions.

This method delegates to the DB::updateWhere() method and allows you to pass both the fields to update and a parameterized WHERE clause (using conditions and bind arrays just like find/findFirst).

Example:

Queue::updateWhere(
    ['reserved_at' => date('Y-m-d H:i:s')],
    ['conditions' => 'id = ?', 'bind' => [$jobId]]
);

Parameters

array $fields

Associative array of columns to update with their new values. Example: ['status' => 'processed', 'attempts' => 3]
array $params

Query parameters for the WHERE clause. Supports:

  • conditions (string|array): SQL conditions with placeholders.
  • bind (array): Values to bind to placeholders.

Return Value

int

The number of rows affected by the update.

in Model at line 552
bool validationPassed()

Getter function for the $_validates boolean instance variable.

Return Value

bool

$_validates is true if validation is successful and false if there is a failure.

in Model at line 563
void validator()

Function that is called on save. If validation fails the save function will not proceed. This function is just a signature and must be implemented by models that run form validation because since it is called from within this class.

Return Value

void

at line 97
static bool deleteById(int $id)

Deletes a profile image by id.

Parameters

int $id

The id of the image we want to delete.

Return Value

bool

Result of delete operation. True if success, otherwise false.

at line 121
static void deleteImages(int $user_id, bool $unlink = false)

Sets delete field in profile_images table to 1 when user is deleted from users table. Accepts parameter for toggling on or off unlink to permanently image file.

Parameters

int $user_id

The user id for user whose image we want to delete.
bool $unlink

Set to true if you want to unlink or false to preserve image in storage.

Return Value

void

at line 145
static ProfileImages|bool findCurrentProfileImage(int $user_id)

Returns currently set profile image for a user.

Parameters

int $user_id

The id of the user whose profile image we want to retrieve.

Return Value

ProfileImages|bool

The model for profile images if images exits, otherwise we return false.

at line 160
static bool|array findByUserId(int $user_id)

Finds all profile images for a user.

Parameters

int $user_id

The id of the user whose profile images we want to retrieve.

Return Value

bool|array

The associative array of profile image records for a user.

at line 173
static array getAllowedFileTypes()

Getter function for $allowedFileTypes array

Return Value

array

$allowedFileTypes The array of allowed file types.

at line 183
static int getMaxAllowedFileSize()

Getter function for $maxAllowedFileSize.

Return Value

int

$maxAllowedFileSize The max file size for an individual file.

at line 196
static void updateSortByUserId(int $user_id, array $sortOrder = [])

Updates sort order by user id.

Parameters

int $user_id

The id of the user whose profile images we want to sort.
array $sortOrder

An array containing sort values for a profile image.

Return Value

void

at line 217
static void uploadProfileImage(int $user_id, Uploads $uploads)

Performs upload operation for a profile image.

Parameters

int $user_id

The id of the user that the upload operation is performed upon.
Uploads $uploads

The instance of the Uploads class for this upload.

Return Value

void