class.ilDclFileuploadFieldModel.php

Go to the documentation of this file.

<?php
require_once("./Modules/DataCollection/classes/Fields/Base/class.ilDclBaseFieldModel.php");
require_once("./Modules/DataCollection/classes/Helpers/class.ilDclRecordQueryObject.php");

class ilDclFileuploadFieldModel extends ilDclBaseFieldModel {

        public function getRecordQuerySortObject($direction = "asc", $sort_by_status = false) {
                global $DIC;
                $ilDB = $DIC['ilDB'];
                $join_str = "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 = "
                        . $ilDB->quote($this->getId(), 'integer') . ") ";
                $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) ";
                $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) ";
                $select_str = " sort_object_data_{$this->getId()}.title AS field_{$this->getId()},";

                $sql_obj = new ilDclRecordQueryObject();
                $sql_obj->setSelectStatement($select_str);
                $sql_obj->setJoinStatement($join_str);
                $sql_obj->setOrderStatement("field_{$this->getId()} ".$direction);

                return $sql_obj;

        }


        public function getRecordQueryFilterObject($filter_value = "", ilDclBaseFieldModel $sort_field = null) {
                global $DIC;
                $ilDB = $DIC['ilDB'];

                $join_str =
                        "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 = "
                        . $ilDB->quote($this->getId(), 'integer') . ") ";
                $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) ";
                $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 "
                        . $ilDB->quote("%$filter_value%", 'text') . ") ";

                $sql_obj = new ilDclRecordQueryObject();
                $sql_obj->setJoinStatement($join_str);

                return $sql_obj;
        }


        public function getSupportedExtensions() {

                if(!$this->hasProperty(ilDclBaseFieldModel::PROP_SUPPORTED_FILE_TYPES)) {
                        return "*";
                }

                $file_types = $this->getProperty(ilDclBaseFieldModel::PROP_SUPPORTED_FILE_TYPES);
                return $this->parseSupportedExtensions($file_types);
        }


        protected function parseSupportedExtensions($input_value) {
                $supported_extensions = explode(",", $input_value);

                $trim_function = function($value) {
                        return trim(trim(strtolower($value)), ".");
                };

                return array_map($trim_function, $supported_extensions);
        }

        public function checkValidity($value, $record_id = null) {
                //Don't check empty values
                if ($value == null || $value['size'] == 0) {
                        return true;
                }

                if ($this->isUnique()) {
                        $title = $value['name'];
                        $table = ilDclCache::getTableCache($this->getTableId());
                        foreach ($table->getRecords() as $record) {
                                if ($this->normalizeValue($record->getRecordFieldExportValue($this->getId())) == $this->normalizeValue($title) && ($record->getId() != $record_id || $record_id == 0)) {
                                        throw new ilDclInputException(ilDclInputException::UNIQUE_EXCEPTION);
                                }
                        }
                }

                return true;
        }


        public function getValidFieldProperties() {
                return array(ilDclBaseFieldModel::PROP_SUPPORTED_FILE_TYPES);
        }

        public function allowFilterInListView() {
                return false;
        }

}