WorkActivity
in package
Class WorkActivity
Provides methods to handle operations related to work activities. This class allows fetching, creating, and updating work activities in the database, with specific methods for admin functionalities.
Table of Contents
Properties
Methods
- __construct() : mixed
- createByAdmin() : void
- Create a new work_activity (admin).
- getAll() : array<int, array<string, mixed>>
- Get all work activities filtered by status.
- getByCode() : array<string, mixed>
- Get a single work activity by code.
- updateByCode() : void
- Update work_activity by code (admin).
Properties
$mySql
protected
MySql
$mySql
Methods
__construct()
public
__construct(MySql $mySql) : mixed
Parameters
- $mySql : MySql
createByAdmin()
Create a new work_activity (admin).
public
createByAdmin(array<string, mixed> $data) : void
Expects in $data:
- work_activity_code (string, required)
- work_activity_name (string, required)
- work_activity_description (string|null)
- status (int, required)
- sort_order (int|null)
- createdby (string, required)
- modifiedby (string, required)
Parameters
- $data : array<string, mixed>
getAll()
Get all work activities filtered by status.
public
getAll(array<string|int, int> $statuses) : array<int, array<string, mixed>>
Parameters
- $statuses : array<string|int, int>
Return values
array<int, array<string, mixed>>getByCode()
Get a single work activity by code.
public
getByCode(string $workActivityCode) : array<string, mixed>
Parameters
- $workActivityCode : string
Return values
array<string, mixed>updateByCode()
Update work_activity by code (admin).
public
updateByCode(array<string, mixed> $data) : void
Expects in $data:
- work_activity_code (string, required)
- work_activity_name (string|null)
- work_activity_description (string|null)
- status (int|null)
- sort_order (int|null)
- modifiedby (string, required)
Parameters
- $data : array<string, mixed>