25            = 
"LEFT JOIN il_dcl_record_field AS sort_record_field_{$this->getId()} ON (sort_record_field_{$this->getId()}.record_id = record.id AND sort_record_field_{$this->getId()}.field_id = " 
   26            . 
$ilDB->quote($this->
getId(), 
'integer') . 
") ";
 
   27        $join_str .= 
"LEFT JOIN il_dcl_stloc{$this->getStorageLocation()}_value AS sort_stloc_{$this->getId()} ON (sort_stloc_{$this->getId()}.record_field_id = sort_record_field_{$this->getId()}.id) ";
 
   28        $join_str .= 
"LEFT JOIN object_data AS sort_object_data_{$this->getId()} ON (sort_object_data_{$this->getId()}.obj_id = sort_stloc_{$this->getId()}.value) ";
 
   29        $select_str = 
" sort_object_data_{$this->getId()}.title AS field_{$this->getId()},";
 
   32        $sql_obj->setSelectStatement($select_str);
 
   33        $sql_obj->setJoinStatement($join_str);
 
   34        $sql_obj->setOrderStatement(
"field_{$this->getId()} " . $direction);
 
   53            = 
"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 = " 
   54            . 
$ilDB->quote($this->
getId(), 
'integer') . 
") ";
 
   55        $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) ";
 
   56        $join_str .= 
"INNER JOIN object_data AS filter_object_data_{$this->getId()} ON (filter_object_data_{$this->getId()}.obj_id = filter_stloc_{$this->getId()}.value AND filter_object_data_{$this->getId()}.title LIKE " 
   57            . 
$ilDB->quote(
"%$filter_value%", 
'text') . 
") ";
 
   60        $sql_obj->setJoinStatement($join_str);
 
   90        $supported_extensions = explode(
",", $input_value);
 
   92        $trim_function = 
function ($value) {
 
   93            return trim(trim(strtolower($value)), 
".");
 
   96        return array_map($trim_function, $supported_extensions);
 
  110        if ($value == 
null || $value[
'size'] == 0) {
 
  117            foreach ($table->getRecords() as $record) {
 
  118                if ($this->
normalizeValue($record->getRecordFieldExportValue($this->getId())) == $this->normalizeValue(
$title) && ($record->getId() != $record_id || $record_id == 0)) {
 
An exception for terminatinating execution or to throw for unit testing.
Class ilDclBaseFieldModel.
const PROP_SUPPORTED_FILE_TYPES
hasProperty($key)
Checks if a certain property for a field is set.
getProperty($key)
Returns a certain property of a field.
getTableId()
Get table id.
static getTableCache($table_id=0)
Class ilDclBooleanFieldModel.
checkValidity($value, $record_id=null)
getRecordQueryFilterObject($filter_value="", ilDclBaseFieldModel $sort_field=null)
Returns a query-object for building the record-loader-sql-query.
getRecordQuerySortObject($direction="asc", $sort_by_status=false)
Returns a query-object for building the record-loader-sql-query.
getValidFieldProperties()
@inheritDoc
parseSupportedExtensions($input_value)
getSupportedExtensions()
Returns supported file-extensions.
Class ilDclRecordQueryObject.