MIDDAG for Moodle

query_builder extends facade

Facade for local_middag\framework\infrastructure\search_engine\query_builder.

Tags
see
query_builder
mixin

Table of Contents

Methods

as_std_class()  : query_builder
domain()  : query_builder
get_domain_class()  : string
get_excluded_scopes()  : array<string|int, mixed>
get_facade_accessor()  : string
Return the service accessor key for this facade.
get_joins()  : array<string|int, mixed>
get_meta_wheres()  : array<string|int, mixed>
get_metadata_keys()  : array<string|int, mixed>
get_page()  : int|null
get_per_page()  : int|null
get_relations()  : array<string|int, mixed>
get_select()  : array<string|int, mixed>|null
get_sort()  : string|null
get_wheres()  : array<string|int, mixed>
join()  : query_builder
join_course()  : query_builder
join_item()  : query_builder
join_user()  : query_builder
limit()  : query_builder
make()  : query_builder
order_by()  : query_builder
paginate()  : query_builder
select()  : query_builder
wants_std_class()  : bool
where()  : query_builder
where_between()  : query_builder
where_in()  : query_builder
where_meta()  : query_builder
where_meta_in()  : query_builder
where_not_in()  : query_builder
with_metadata()  : query_builder
with_relation()  : query_builder
without_global_scope()  : query_builder
without_global_scopes()  : query_builder

Methods

as_std_class()

public static as_std_class([bool $enabled = = 'true' ]) : query_builder
Parameters
$enabled : bool = = 'true'
Return values
query_builder

domain()

public static domain(string $class) : query_builder
Parameters
$class : string
Return values
query_builder

get_domain_class()

public static get_domain_class() : string
Return values
string

get_excluded_scopes()

public static get_excluded_scopes() : array<string|int, mixed>
Return values
array<string|int, mixed>

get_facade_accessor()

Return the service accessor key for this facade.

public static get_facade_accessor() : string
Return values
string

get_joins()

public static get_joins() : array<string|int, mixed>
Return values
array<string|int, mixed>

get_meta_wheres()

public static get_meta_wheres() : array<string|int, mixed>
Return values
array<string|int, mixed>

get_metadata_keys()

public static get_metadata_keys() : array<string|int, mixed>
Return values
array<string|int, mixed>

get_page()

public static get_page() : int|null
Return values
int|null

get_per_page()

public static get_per_page() : int|null
Return values
int|null

get_relations()

public static get_relations() : array<string|int, mixed>
Return values
array<string|int, mixed>

get_select()

public static get_select() : array<string|int, mixed>|null
Return values
array<string|int, mixed>|null

get_sort()

public static get_sort() : string|null
Return values
string|null

get_wheres()

public static get_wheres() : array<string|int, mixed>
Return values
array<string|int, mixed>

join()

public static join(string $table, string $alias, string $on[, string $type = = '\'INNER\'' ]) : query_builder
Parameters
$table : string
$alias : string
$on : string
$type : string = = '\'INNER\''
Return values
query_builder

join_course()

public static join_course([string $alias = = '\'c\'' ][, string $local_field = = '\'courseid\'' ][, string $foreign_field = = '\'id\'' ]) : query_builder
Parameters
$alias : string = = '\'c\''
$local_field : string = = '\'courseid\''
$foreign_field : string = = '\'id\''
Return values
query_builder

join_item()

public static join_item(string $alias[, string $local_field = = '\'parent\'' ][, string $foreign_field = = '\'id\'' ]) : query_builder
Parameters
$alias : string
$local_field : string = = '\'parent\''
$foreign_field : string = = '\'id\''
Return values
query_builder

join_user()

public static join_user([string $alias = = '\'u\'' ][, string $local_field = = '\'userid\'' ][, string $foreign_field = = '\'id\'' ]) : query_builder
Parameters
$alias : string = = '\'u\''
$local_field : string = = '\'userid\''
$foreign_field : string = = '\'id\''
Return values
query_builder

limit()

public static limit(int $limit) : query_builder
Parameters
$limit : int
Return values
query_builder

make()

public static make() : query_builder
Return values
query_builder

order_by()

public static order_by(string $sort) : query_builder
Parameters
$sort : string
Return values
query_builder

paginate()

public static paginate(int $page, int $per_page) : query_builder
Parameters
$page : int
$per_page : int
Return values
query_builder

select()

public static select(array<string|int, mixed> $fields) : query_builder
Parameters
$fields : array<string|int, mixed>
Return values
query_builder

wants_std_class()

public static wants_std_class() : bool
Return values
bool

where()

public static where(string $field, operator $operator[, mixed $value = = 'null' ][, mixed $value2 = = 'null' ]) : query_builder
Parameters
$field : string
$operator : operator
$value : mixed = = 'null'
$value2 : mixed = = 'null'
Return values
query_builder

where_between()

public static where_between(string $field, mixed $start, mixed $end) : query_builder
Parameters
$field : string
$start : mixed
$end : mixed
Return values
query_builder

where_in()

public static where_in(string $field, array<string|int, mixed> $values) : query_builder
Parameters
$field : string
$values : array<string|int, mixed>
Return values
query_builder

where_meta()

public static where_meta(string $key, operator $operator[, mixed $value = = 'null' ][, mixed $value2 = = 'null' ]) : query_builder
Parameters
$key : string
$operator : operator
$value : mixed = = 'null'
$value2 : mixed = = 'null'
Return values
query_builder

where_meta_in()

public static where_meta_in(string $key, array<string|int, mixed> $values) : query_builder
Parameters
$key : string
$values : array<string|int, mixed>
Return values
query_builder

where_not_in()

public static where_not_in(string $field, array<string|int, mixed> $values) : query_builder
Parameters
$field : string
$values : array<string|int, mixed>
Return values
query_builder

with_metadata()

public static with_metadata(array<string|int, mixed> $keys) : query_builder
Parameters
$keys : array<string|int, mixed>
Return values
query_builder

with_relation()

public static with_relation(string $relation) : query_builder
Parameters
$relation : string
Return values
query_builder

without_global_scope()

public static without_global_scope(string $identifier) : query_builder
Parameters
$identifier : string
Return values
query_builder

without_global_scopes()

public static without_global_scopes() : query_builder
Return values
query_builder 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results