Laraframe Query Builder
Introduction
Laraframe Query Builder gives you some exteded functionalities over Laravel Query Builder
List of Query Builder Functions
All builtin laravel query builder functions
bulkUpdate():
Update multiple rows at a times by different conditions for each row.
parameters: attributes:array
return: updated row count
Example:
$parameters = [
[
'conditions' => ['is_active' => 1,
'is_email_verified' => 1],
'fields' => [
'first_name' => 'John',
'last_name' => 'Doe'
]
],
[
'conditions' => ['email' => 'robin@example.com',
'is_active' => 1],
'fields' => [
'is_financial_suspended' => 1,
],
],
];
$userUpdateCount = User::bulkUpdate($parameters);
Fields key can update different ways. Example Below:
'fields' => [
'column_name1' => ['increment', 10],
'column_name2 => ['decrement', 5],
'column_name3' => ['raw', 'column_name1 - column_name2'],
'column_name4' => 'value',
];
toggleStatus():
Change status of a row by its id. By default it changes is_active
column. If you want to change different column then pass the column name as parameter.
parameters: attribute(optional)
return: boolean
Example:
$user = User::find(1);
$isChanged = $user->toggleStatus(1, 'is_financial_suspended');
active():
This function is a global query scope. It will get all active data. By default it use is_active
column. If you want to change different column then pass the column name as parameter.
likeSearch():
This function is a global query scope. You can search with this functions. It is usages mysql wildcard search.
parameters: array $searchFields, string $term
This function is a global query scope. It will get all active data. By default it use is_active
column. If you want to change different column then pass the column name as parameter.
strictSearch():
This function is a global query scope. You can search with this functions. It is usages strict search conditions.
parameters: array $searchFields, string $term