local_middag\framework\infrastructure\search_engine\query_builder

final class query_builder implements query_builder_interface

Immutable Query Object.

This object is a pure data-structure describing the query the developer wants. It holds NO SQL and does not know Moodle's DB API.

It is final to preserve immutability integrity.

Methods

static query_builder

make()

Create a new empty immutable Query.

query_builder

where(string $field, operator $operator, mixed $value = null, mixed $value2 = null)

Add a base WHERE condition.

query_builder

where_in(string $field, array $values)

Add an IN filter for a field.

query_builder

where_not_in(string $field, array $values)

Add a NOT IN filter for a field.

query_builder

where_between(string $field, mixed $start, mixed $end)

Add a BETWEEN constraint for a field.

query_builder

where_meta(string $key, operator $operator, mixed $value = null, mixed $value2 = null)

Add a WHERE condition targeting metadata table.

query_builder

where_meta_in(string $key, array $values)

Add an IN filter for metadata values.

query_builder

join(string $table, string $alias, string $on, string $type = 'INNER')

Add a generic JOIN clause.

query_builder

join_item(string $alias, string $local_field = 'parent', string $foreign_field = 'id')

Join against the items table with defaults for parent->id.

query_builder

join_course(string $alias = 'c', string $local_field = 'courseid', string $foreign_field = 'id')

Join against Moodle course table.

query_builder

join_user(string $alias = 'u', string $local_field = 'userid', string $foreign_field = 'id')

Join against Moodle user table.

query_builder

with_metadata(array $keys)

Request eager-loading of specific metadata keys.

query_builder

with_relation(string $relation)

Request eager-loading of a registered relation.

query_builder

without_global_scope(string $identifier)

Disable a specific global scope.

query_builder

without_global_scopes()

Disable all global scopes.

query_builder

select(array $fields)

Define explicit SELECT columns.

query_builder

order_by(string $sort)

Define ORDER BY clause (raw string, e.g., "fullname ASC").

query_builder

as_std_class(bool $enabled = true)

Toggle returning stdClass instead of domain entities.

query_builder

domain(string $class)

Set the target domain class for hydration.

query_builder

paginate(int $page, int $per_page)

Enable pagination with page and per-page values.

query_builder

limit(int $limit)

Limit the number of returned rows (no pagination metadata).

array

get_wheres()

Get base WHERE filters.

array

get_meta_wheres()

Get metadata WHERE filters.

array

get_joins()

Get JOIN definitions.

array

get_relations()

Get requested relations for eager loading.

array

get_metadata_keys()

Get metadata keys requested for eager loading.

array

get_excluded_scopes()

Get excluded global scopes.

array|null

get_select()

Get explicit select columns if defined.

string|null

get_sort()

Get ORDER BY clause string.

bool

wants_std_class()

Check if results should be hydrated as stdClass.

int|null

get_page()

Get current page for pagination (0-based).

int|null

get_per_page()

Get per-page limit for pagination.

string

get_domain_class()

Get the target domain class for hydration.

Details

at line 69
`static query_builder make()`

Create a new empty immutable Query.

Return Value

query_builder

at line 81
`query_builder where(string $field, operator $operator, mixed $value = null, mixed $value2 = null)`

Add a base WHERE condition.

Parameters

string	$field
operator	$operator
mixed	$value
mixed	$value2

Return Value

query_builder

at line 96
`query_builder where_in(string $field, array $values)`

Add an IN filter for a field.

Parameters

string	$field
array	$values

Return Value

query_builder

at line 104
`query_builder where_not_in(string $field, array $values)`

Add a NOT IN filter for a field.

Parameters

string	$field
array	$values

Return Value

query_builder

at line 112
`query_builder where_between(string $field, mixed $start, mixed $end)`

Add a BETWEEN constraint for a field.

Parameters

string	$field
mixed	$start
mixed	$end

Return Value

query_builder

at line 124
`query_builder where_meta(string $key, operator $operator, mixed $value = null, mixed $value2 = null)`

Add a WHERE condition targeting metadata table.

Parameters

string	$key
operator	$operator
mixed	$value
mixed	$value2

Return Value

query_builder

at line 139
`query_builder where_meta_in(string $key, array $values)`

Add an IN filter for metadata values.

Parameters

string	$key
array	$values

Return Value

query_builder

at line 151
`query_builder join(string $table, string $alias, string $on, string $type = 'INNER')`

Add a generic JOIN clause.

Parameters

string	$table
string	$alias
string	$on
string	$type

Return Value

query_builder

at line 166
`query_builder join_item(string $alias, string $local_field = 'parent', string $foreign_field = 'id')`

Join against the items table with defaults for parent->id.

Parameters

string	$alias
string	$local_field
string	$foreign_field

Return Value

query_builder

at line 178
`query_builder join_course(string $alias = 'c', string $local_field = 'courseid', string $foreign_field = 'id')`

Join against Moodle course table.

Parameters

string	$alias
string	$local_field
string	$foreign_field

Return Value

query_builder

at line 190
`query_builder join_user(string $alias = 'u', string $local_field = 'userid', string $foreign_field = 'id')`

Join against Moodle user table.

Parameters

string	$alias
string	$local_field
string	$foreign_field

int	$page
int	$per_page

Return Value

query_builder

at line 323
`query_builder limit(int $limit)`

Limit the number of returned rows (no pagination metadata).

Parameters

Return Value

string

query_builder

Methods

Details

at line 69 static query_builder make()

Return Value

at line 81 query_builder where(string $field, operator $operator, mixed $value = null, mixed $value2 = null)

Parameters

Return Value

at line 96 query_builder where_in(string $field, array $values)

Parameters

Return Value

at line 104 query_builder where_not_in(string $field, array $values)

Parameters

Return Value

at line 112 query_builder where_between(string $field, mixed $start, mixed $end)

Parameters

Return Value

at line 124 query_builder where_meta(string $key, operator $operator, mixed $value = null, mixed $value2 = null)

Parameters

Return Value

at line 139 query_builder where_meta_in(string $key, array $values)

Parameters

Return Value

at line 151 query_builder join(string $table, string $alias, string $on, string $type = 'INNER')

Parameters

Return Value

at line 166 query_builder join_item(string $alias, string $local_field = 'parent', string $foreign_field = 'id')

Parameters

Return Value

at line 178 query_builder join_course(string $alias = 'c', string $local_field = 'courseid', string $foreign_field = 'id')

Parameters

Return Value

at line 190 query_builder join_user(string $alias = 'u', string $local_field = 'userid', string $foreign_field = 'id')

Parameters

Return Value

at line 206 query_builder with_metadata(array $keys)

Parameters

Return Value

at line 220 query_builder with_relation(string $relation)

Parameters

Return Value

at line 240 query_builder without_global_scope(string $identifier)

Parameters

Return Value

at line 252 query_builder without_global_scopes()

Return Value

at line 266 query_builder select(array $fields)

Parameters

Return Value

at line 276 query_builder order_by(string $sort)

Parameters

Return Value

at line 286 query_builder as_std_class(bool $enabled = true)

Parameters

Return Value

at line 298 query_builder domain(string $class)

Parameters

Return Value

at line 312 query_builder paginate(int $page, int $per_page)

Parameters

Return Value

at line 323 query_builder limit(int $limit)

Parameters

Return Value

at line 338 array get_wheres()

Return Value

at line 348 array get_meta_wheres()

Return Value

at line 358 array get_joins()

Return Value

at line 368 array get_relations()

Return Value

at line 378 array get_metadata_keys()

Return Value

at line 388 array get_excluded_scopes()

Return Value

at line 398 array|null get_select()

Return Value

at line 406 string|null get_sort()

Return Value

at line 69
`static query_builder make()`

at line 81
`query_builder where(string $field, operator $operator, mixed $value = null, mixed $value2 = null)`

at line 96
`query_builder where_in(string $field, array $values)`

at line 104
`query_builder where_not_in(string $field, array $values)`

at line 112
`query_builder where_between(string $field, mixed $start, mixed $end)`

at line 124
`query_builder where_meta(string $key, operator $operator, mixed $value = null, mixed $value2 = null)`

at line 139
`query_builder where_meta_in(string $key, array $values)`

at line 151
`query_builder join(string $table, string $alias, string $on, string $type = 'INNER')`

at line 166
`query_builder join_item(string $alias, string $local_field = 'parent', string $foreign_field = 'id')`

at line 178
`query_builder join_course(string $alias = 'c', string $local_field = 'courseid', string $foreign_field = 'id')`

at line 190
`query_builder join_user(string $alias = 'u', string $local_field = 'userid', string $foreign_field = 'id')`

at line 206
`query_builder with_metadata(array $keys)`

at line 220
`query_builder with_relation(string $relation)`

at line 240
`query_builder without_global_scope(string $identifier)`

at line 252
`query_builder without_global_scopes()`

at line 266
`query_builder select(array $fields)`

at line 276
`query_builder order_by(string $sort)`

at line 286
`query_builder as_std_class(bool $enabled = true)`

at line 298
`query_builder domain(string $class)`

at line 312
`query_builder paginate(int $page, int $per_page)`

at line 323
`query_builder limit(int $limit)`

at line 338
`array get_wheres()`

at line 348
`array get_meta_wheres()`

at line 358
`array get_joins()`

at line 368
`array get_relations()`

at line 378
`array get_metadata_keys()`

at line 388
`array get_excluded_scopes()`

at line 398
`array|null get_select()`

at line 406
`string|null get_sort()`

at line 414
`bool wants_std_class()`

at line 422
`int|null get_page()`

at line 430
`int|null get_per_page()`

at line 440
`string get_domain_class()`