PlatformSetting
extends Model
in package
Model for platform-wide settings (key-value store).
Used for global configuration like platform-wide maintenance mode.
Tags
Table of Contents
Properties
- $db : PDO
- $fillable : array<string|int, mixed>
- $primaryKey : string
- $table : string
Methods
- __construct() : mixed
- Initialize model with database connection.
- all() : array<string|int, mixed>
- Get all records from the table.
- count() : int
- Count records matching optional conditions.
- create() : int
- Create a new record.
- delete() : bool
- Delete a record by primary key.
- disableMaintenance() : void
- Disable platform-wide maintenance mode.
- enableMaintenance() : void
- Enable platform-wide maintenance mode.
- find() : array<string|int, mixed>|null
- Find a record by primary key.
- findBy() : array<string|int, mixed>|null
- Find a record by a specific field value.
- get() : string|null
- Get a setting value by key.
- getDb() : PDO
- Get the underlying PDO connection.
- getMaintenanceLevel() : string
- Get the platform maintenance level.
- isMaintenanceMode() : bool
- Check if platform-wide maintenance mode is active.
- paginate() : array<string|int, mixed>
- Paginate records matching conditions.
- query() : PDOStatement
- Execute a raw SQL query with parameter binding.
- set() : bool
- Set a setting value.
- update() : bool
- Update a record by primary key.
- where() : array<string|int, mixed>
- Find records matching conditions.
- filterFillable() : array<string|int, mixed>
- Filter data to only include fillable fields.
Properties
$db
protected
PDO
$db
Database connection
$fillable
protected
array<string|int, mixed>
$fillable
= ['setting_key', 'setting_value']
Mass-assignable fields
$primaryKey
protected
string
$primaryKey
= 'setting_key'
Primary key column
$table
protected
string
$table
= 'platform_settings'
Database table name
Methods
__construct()
Initialize model with database connection.
public
__construct() : mixed
all()
Get all records from the table.
public
all([string $orderBy = 'id' ][, string $direction = 'ASC' ]) : array<string|int, mixed>
Parameters
- $orderBy : string = 'id'
-
Column to order by
- $direction : string = 'ASC'
-
Sort direction (ASC or DESC)
Return values
array<string|int, mixed>count()
Count records matching optional conditions.
public
count([array<string|int, mixed> $conditions = [] ]) : int
Parameters
- $conditions : array<string|int, mixed> = []
-
Associative array of field => value pairs
Return values
intcreate()
Create a new record.
public
create(array<string|int, mixed> $data) : int
Parameters
- $data : array<string|int, mixed>
-
Associative array of field => value pairs
Return values
int —The ID of the newly created record
delete()
Delete a record by primary key.
public
delete(int $id) : bool
Parameters
- $id : int
-
Primary key value
Return values
booldisableMaintenance()
Disable platform-wide maintenance mode.
public
disableMaintenance() : void
enableMaintenance()
Enable platform-wide maintenance mode.
public
enableMaintenance([string $level = 'admin_only' ][, string|null $message = null ]) : void
Parameters
- $level : string = 'admin_only'
-
Maintenance level
- $message : string|null = null
-
Custom maintenance message
find()
Find a record by primary key.
public
find(int $id) : array<string|int, mixed>|null
Parameters
- $id : int
-
Primary key value
Return values
array<string|int, mixed>|nullfindBy()
Find a record by a specific field value.
public
findBy(string $field, mixed $value) : array<string|int, mixed>|null
Parameters
- $field : string
-
Column name
- $value : mixed
-
Value to match
Return values
array<string|int, mixed>|nullget()
Get a setting value by key.
public
get(string $key[, string|null $default = null ]) : string|null
Parameters
- $key : string
-
Setting key
- $default : string|null = null
-
Default value if not found
Return values
string|nullgetDb()
Get the underlying PDO connection.
public
getDb() : PDO
Return values
PDOgetMaintenanceLevel()
Get the platform maintenance level.
public
getMaintenanceLevel() : string
Return values
stringisMaintenanceMode()
Check if platform-wide maintenance mode is active.
public
isMaintenanceMode() : bool
Return values
boolpaginate()
Paginate records matching conditions.
public
paginate(array<string|int, mixed> $conditions, int $page, int $perPage[, string $orderBy = 'id' ][, string $direction = 'ASC' ]) : array<string|int, mixed>
Parameters
- $conditions : array<string|int, mixed>
-
Associative array of field => value pairs
- $page : int
-
Current page number (1-based)
- $perPage : int
-
Records per page
- $orderBy : string = 'id'
-
Column to order by
- $direction : string = 'ASC'
-
Sort direction (ASC or DESC)
Return values
array<string|int, mixed> —Pagination result with data, total, page, per_page, total_pages
query()
Execute a raw SQL query with parameter binding.
public
query(string $sql[, array<string|int, mixed> $params = [] ]) : PDOStatement
Parameters
- $sql : string
-
SQL query string
- $params : array<string|int, mixed> = []
-
Bound parameters
Return values
PDOStatementset()
Set a setting value.
public
set(string $key, string|null $value) : bool
Parameters
- $key : string
-
Setting key
- $value : string|null
-
Setting value
Return values
boolupdate()
Update a record by primary key.
public
update(int $id, array<string|int, mixed> $data) : bool
Parameters
- $id : int
-
Primary key value
- $data : array<string|int, mixed>
-
Associative array of field => value pairs
Return values
boolwhere()
Find records matching conditions.
public
where(array<string|int, mixed> $conditions[, string $orderBy = 'id' ][, string $direction = 'ASC' ]) : array<string|int, mixed>
Parameters
- $conditions : array<string|int, mixed>
-
Associative array of field => value pairs
- $orderBy : string = 'id'
-
Column to order by
- $direction : string = 'ASC'
-
Sort direction
Return values
array<string|int, mixed>filterFillable()
Filter data to only include fillable fields.
protected
filterFillable(array<string|int, mixed> $data) : array<string|int, mixed>
Parameters
- $data : array<string|int, mixed>
-
Input data
Return values
array<string|int, mixed> —Filtered data