Search moodle.org's
Developer Documentation
Developer Documentation
- Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
- Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
- PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
/mod/glossary/classes/ -> entry_query_builder.php (source)
Differences Between: [Versions 310 and 400] [Versions 39 and 400]
Entry query builder.
| Copyright: | 2015 Frédéric Massart - FMCorz.net |
| License: | http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later |
| File Size: | 473 lines (16 kb) |
| Included or required: | 0 times |
| Referenced: | 0 times |
| Includes or requires: | 0 files |
Defines 1 class
mod_glossary_entry_query_builder:: (26 methods):
__construct()
add_field()
add_user_fields()
build_query()
count_records()
filter_by_letter()
filter_by_non_letter()
filter_by_author_letter()
filter_by_author_non_letter()
filter_by_concept_letter()
filter_by_concept_non_letter()
filter_by_non_approved()
filter_by_term()
get_fullname_field()
get_records()
get_recordset()
get_user_from_record()
join_alias()
join_category()
join_user()
limit()
normalize_direction()
order_by()
order_by_author()
resolve_field()
where()
Class: mod_glossary_entry_query_builder - X-Ref
Entry query builder class.The purpose of this class is to avoid duplicating SQL statements to fetch entries
which are very similar with each other. This builder is not meant to be smart, it
will not out rule any previously set condition, or join, etc...
You should be using this builder just like you would be creating your SQL query. Only
some methods are shorthands to avoid logic duplication and common mistakes.
| __construct($glossary = null) X-Ref |
| Constructor. param: object $glossary The glossary. |
| add_field($field, $table, $alias = null) X-Ref |
| Add a field to select. param: string $field The field, or *. param: string $table The table name, without the prefix 'glossary_'. param: string $alias An alias for the field. |
| add_user_fields() X-Ref |
| Adds the user fields. return: void |
| build_query($count = false) X-Ref |
| Internal method to build the query. return: string The SQL statement. param: bool $count Query to count? |
| count_records() X-Ref |
| Count the records. return: int The number of records. |
| filter_by_letter($letter, $finalfield) X-Ref |
| Filter a field using a letter. param: string $letter The letter. param: string $finalfield The SQL statement representing the field. |
| filter_by_non_letter($finalfield) X-Ref |
| Filter a field by special characters. param: string $finalfield The SQL statement representing the field. |
| filter_by_author_letter($letter, $firstnamefirst = false) X-Ref |
| Filter the author by letter. param: string $letter The letter. param: bool $firstnamefirst Whether or not the firstname is first in the author's name. |
| filter_by_author_non_letter($firstnamefirst = false) X-Ref |
| Filter the author by special characters. param: bool $firstnamefirst Whether or not the firstname is first in the author's name. |
| filter_by_concept_letter($letter) X-Ref |
| Filter the concept by letter. param: string $letter The letter. |
| filter_by_concept_non_letter() X-Ref |
| Filter the concept by special characters. return: void |
| filter_by_non_approved($constant, $userid = null) X-Ref |
| Filter non approved entries. param: string $constant One of the NON_APPROVED_* constants. param: int $userid The user ID when relevant, otherwise current user. |
| filter_by_term($term) X-Ref |
| Filter by concept or alias. This requires the alias table to be joined in the query. See {@link self::join_alias()}. param: string $term What the concept or aliases should be. |
| get_fullname_field($firstnamefirst = false) X-Ref |
| Convenience method to get get the SQL statement for the full name. return: string The SQL statement. param: bool $firstnamefirst Whether or not the firstname is first in the author's name. |
| get_records() X-Ref |
| Get the records. return: array |
| get_recordset() X-Ref |
| Get the recordset. return: moodle_recordset |
| get_user_from_record($record) X-Ref |
| Retrieve a user object from a record. This comes handy when {@link self::add_user_fields} was used. return: stdClass A user object. param: stdClass $record The record. |
| join_alias() X-Ref |
| Join the alias table. Note that this may cause the same entry to be returned more than once. You might want to add a distinct on the entry id. return: void |
| join_category($categoryid) X-Ref |
| Join on the category tables. Depending on the category passed the joins will be different. This is due to the display logic that assumes that when displaying all categories the non categorised entries should not be returned, etc... param: int $categoryid The category ID, or GLOSSARY_SHOW_* constant. |
| join_user($strict = false) X-Ref |
| Join the user table. param: bool $strict When strict uses a JOIN rather than a LEFT JOIN. |
| limit($from, $num) X-Ref |
| Limit the number of records to fetch. param: int $from Fetch from. param: int $num Number to fetch. |
| normalize_direction($direction) X-Ref |
| Normalise a direction. This ensures that the value is either ASC or DESC. return: string ASC or DESC. param: string $direction The desired direction. |
| order_by($field, $table, $direction = '') X-Ref |
| Order by a field. param: string $field The field, or *. param: string $table The table name, without the prefix 'glossary_'. param: string $direction ASC, or DESC. |
| order_by_author($firstnamefirst = false, $direction = '') X-Ref |
| Order by author name. param: bool $firstnamefirst Whether or not the firstname is first in the author's name. param: string $direction ASC, or DESC. |
| resolve_field($field, $table) X-Ref |
| Convenience method to transform a field into SQL statement. return: string SQL statement. param: string $field The field, or *. param: string $table The table name, without the prefix 'glossary_'. |
| where($field, $table, $value) X-Ref |
| Simple where conditions. param: string $field The field, or *. param: string $table The table name, without the prefix 'glossary_'. param: mixed $value The value to be equal to. |
