ilDclDateFieldModel Class Reference
Inheritance diagram for ilDclDateFieldModel:
Collaboration diagram for ilDclDateFieldModel:
Public Member Functions | |
| getRecordQueryFilterObject ( $filter_value="", ?ilDclBaseFieldModel $sort_field=null) | |
| Public Member Functions inherited from ilDclBaseFieldModel | |
| __construct (int $a_id=0) | |
| setId ($a_id) | |
| Set field id. More... | |
| getId () | |
| Get field id. More... | |
| setTableId (int $a_id) | |
| Set table id. More... | |
| getTableId () | |
| Get table id. More... | |
| setTitle (string $a_title) | |
| Set title. More... | |
| getTitle () | |
| Get title. More... | |
| setDescription (string $a_desc) | |
| Set description. More... | |
| getDescription () | |
| Get description. More... | |
| setDatatypeId (int $a_id) | |
| Set datatype id. More... | |
| getDatatypeId () | |
| Get datatype_id. More... | |
| getDatatype () | |
| getDatatypeTitle () | |
| getPresentationTitle () | |
| getPresentationDescription () | |
| getStorageLocation () | |
| Get storage location for the model. More... | |
| getExportable () | |
| toArray () | |
| isStandardField () | |
| doRead () | |
| buildFromDBRecord (array $rec) | |
| Builds model from db record. More... | |
| doCreate () | |
| doUpdate () | |
| updateProperties () | |
| Update properties of this field in Database. More... | |
| doDelete () | |
| Remove field and properties. More... | |
| getViewSettings () | |
| getViewSetting (int $tableview_id) | |
| getOrder () | |
| setOrder (int $order) | |
| hasProperty (string $key) | |
| Checks if a certain property for a field is set. More... | |
| getProperty (string $key) | |
| getPropertyInstance (string $key) | |
| setProperty (string $key, $value) | |
| getValidFieldProperties () | |
| Returns all valid properties for a field-type. More... | |
| checkValidityFromForm (ilPropertyFormGUI &$form, ?int $record_id) | |
| checkValidity ($value, ?int $record_id) | |
| Check if input is valid. More... | |
| cloneStructure (int $original_id) | |
| afterClone (array $records) | |
| cloneProperties (ilDclBaseFieldModel $originalField) | |
| setExportable (bool $exportable) | |
| allowFilterInListView () | |
| getRecordQuerySortObject (string $direction="asc", bool $sort_by_status=false) | |
| Returns a query-object for building the record-loader-sql-query. More... | |
| getRecordQueryFilterObject ( $filter_value="", ?ilDclBaseFieldModel $sort_field=null) | |
| Returns a query-object for building the record-loader-sql-query. More... | |
| getSortField () | |
| Returns the sort-field id. More... | |
| hasNumericSorting () | |
| Set to true, when the sorting should be handled numerical. More... | |
| checkFieldCreationInput (ilPropertyFormGUI $form) | |
| Checks input of specific fields befor saving. More... | |
| checkUniqueProp (ilPropertyFormGUI $form) | |
| checkUnique ($value, ?int $record_id) | |
| getStorageLocationOverride () | |
| setStorageLocationOverride (?int $storage_location_override) | |
| fillHeaderExcel (ilExcel $worksheet, int &$row, int &$col) | |
| checkTitlesForImport (array &$titles, array &$import_fields) | |
| storePropertiesFromForm (ilPropertyFormGUI $form) | |
| called when saving the 'edit field' form More... | |
| fillPropertiesForm (ilPropertyFormGUI &$form) | |
| called to fill the 'edit field' form More... | |
| isConfirmationRequired (ilPropertyFormGUI $form) | |
| called by ilDclFieldEditGUI when updating field properties if you overwrite this method, remember to also overwrite getConfirmationGUI More... | |
| getConfirmationGUI (ilPropertyFormGUI $form) | |
| called by ilDclFieldEditGUI if isConfirmationRequired returns true More... | |
Data Fields | |
| const string | FORMAT = 'Y-m-d' |
| Data Fields inherited from ilDclBaseFieldModel | |
| const | PROP_LENGTH = "lenght" |
| General properties. More... | |
| const | PROP_REGEX = "regex" |
| const | PROP_REFERENCE = "table_id" |
| const | PROP_URL = "url" |
| const | PROP_REFERENCE_LINK = "reference_link" |
| const | PROP_UNIQUE = "unique" |
| const | PROP_WIDTH = "width" |
| const | PROP_HEIGHT = "height" |
| const | PROP_LEARNING_PROGRESS = "learning_progress" |
| const | PROP_ILIAS_REFERENCE_LINK = "ILIAS_reference_link" |
| const | PROP_N_REFERENCE = "multiple_selection" |
| const | PROP_FORMULA_EXPRESSION = "expression" |
| const | PROP_DISPLAY_COPY_LINK_ACTION_MENU = "display_action_menu" |
| const | PROP_LINK_DETAIL_PAGE_TEXT = "link_detail_page_text" |
| const | PROP_LINK_DETAIL_PAGE_MOB = "link_detail_page_mob" |
| const | PROP_SUPPORTED_FILE_TYPES = "supported_file_types" |
| const | PROP_PLUGIN_HOOK_NAME = "plugin_hook_name" |
| const | EDIT_VIEW = 2 |
| const | EXPORTABLE_VIEW = 4 |
Additional Inherited Members | |
| Static Public Member Functions inherited from ilDclBaseFieldModel | |
| static | _getTitleInvalidChars (bool $a_as_regex=true) |
| All valid chars for filed titles. More... | |
| static | _getFieldIdByTitle (string $title, int $table_id) |
| Protected Member Functions inherited from ilDclBaseFieldModel | |
| loadDatatype () | |
| Load datatype for model. More... | |
| loadTableFieldSetting () | |
| loadTableFieldSetting More... | |
| addToTableViews () | |
| create ilDclTableViewFieldSettings for this field in each tableview More... | |
| updateTableFieldSetting () | |
| update exportable and fieldorder More... | |
| loadProperties () | |
| Get all properties of a field. More... | |
| areEqual ($value_1, $value_2) | |
| normalizeValue (mixed $value) | |
| Protected Attributes inherited from ilDclBaseFieldModel | |
| string | $id = "" |
| int | $table_id = 0 |
| string | $title = "" |
| string | $description = "" |
| int | $datatype_id = 0 |
| int | $order = null |
| array | $property = [] |
| bool | $exportable = false |
| ilDclDatatype | $datatype = null |
| int | $storage_location_override = null |
| With this property the datatype-storage-location can be overwritten. More... | |
| ilDBInterface | $db |
| ilLanguage | $lng |
Detailed Description
Definition at line 21 of file class.ilDclDateFieldModel.php.
Member Function Documentation
◆ getRecordQueryFilterObject()
| ilDclDateFieldModel::getRecordQueryFilterObject | ( | $filter_value = "", |
|
| ?ilDclBaseFieldModel | $sort_field = null |
||
| ) |
- Parameters
-
string | int $filter_value
Definition at line 28 of file class.ilDclDateFieldModel.php.
References ilDclBaseFieldModel\getId(), and null.
33 $date_from = (isset($filter_value['from']) && is_object($filter_value['from'])) ? $filter_value['from'] : null;
34 $date_to = (isset($filter_value['to']) && is_object($filter_value['to'])) ? $filter_value['to'] : null;
37 = "INNER JOIN il_dcl_record_field AS filter_record_field_{$this->getId()} ON (filter_record_field_{$this->getId()}.record_id = record.id AND filter_record_field_{$this->getId()}.field_id = "
39 $join_str .= "INNER JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS filter_stloc_{$this->getId()} ON (filter_stloc_{$this->getId()}.record_field_id = filter_record_field_{$this->getId()}.id ";
41 $join_str .= "AND filter_stloc_{$this->getId()}.value >= " . $this->db->quote($date_from, 'date') . " ";
44 $join_str .= "AND filter_stloc_{$this->getId()}.value <= " . $this->db->quote($date_to, 'date') . " ";
while($session_entry=$r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) return null
Definition: shib_logout.php:144
Here is the call graph for this function:
Field Documentation
◆ FORMAT
| const string ilDclDateFieldModel::FORMAT = 'Y-m-d' |
Definition at line 23 of file class.ilDclDateFieldModel.php.
Referenced by ilDclDateRecordFieldModel\getValueFromExcel(), and ilDclDateRecordRepresentation\parseFormInput().
The documentation for this class was generated from the following file:
- components/ILIAS/DataCollection/classes/Fields/Date/class.ilDclDateFieldModel.php
