class.ilObjFile.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2013 ILIAS open source, Extended GPL, see docs/LICENSE */
 
use ILIAS\File\Sanitation\FilePathSanitizer;
use ILIAS\Filesystem\Util\LegacyPathHelper;
use ILIAS\FileUpload\Location;
 
require_once("Services/Object/classes/class.ilObject2.php");
require_once('Modules/File/classes/class.ilFSStorageFile.php');
 
class ilObjFile extends ilObject2
{
    const MODE_FILELIST = "filelist";
    const MODE_OBJECT = "object";
    protected $no_meta_data_creation;
    protected $filename = '';
    protected $filetype = '';
    protected $filemaxsize = "20000000";    // not used yet
    protected $filesize;
    public $raise_upload_error;
    public $mode = self::MODE_OBJECT;
    protected $page_count = 0;
    protected $rating = false;
    private $file_storage = null;
    protected $log = null;
    protected $version = 1;
 
 
    public function __construct($a_id = 0, $a_call_by_reference = true)
    {
        $this->version = 0;
        $this->raise_upload_error = true;
 
        $this->log = ilLoggerFactory::getLogger('file');
 
        parent::__construct($a_id, $a_call_by_reference);
 
        if ($this->getId()) {
            $this->initFileStorage();
        }
    }
 
 
    public function initType()
    {
        $this->type = "file";
    }
 
 
    protected function doCreate($a_upload = false)
    {
        $this->createProperties($a_upload);
    }
 
 
    public function createProperties($a_upload = false)
    {
        global $DIC;
 
        // Create file directory
        $this->initFileStorage();
        $this->file_storage->create();
 
        if ($a_upload) {
            return true;
        }
 
        // not upload mode
        ilHistory::_createEntry($this->getId(), "create", $this->getFileName() . ",1");
        $this->addNewsNotification("file_created");
 
        // New Item
        $default_visibility = ilNewsItem::_getDefaultVisibilityForRefId($_GET['ref_id']);
        if ($default_visibility == "public") {
            ilBlockSetting::_write("news", "public_notifications", 1, 0, $this->getId());
        }
 
        // log creation
        $this->log->debug("ilObjFile::createProperties, ID: " . $this->getId() . ", Name: "
            . $this->getFileName() . ", Type: " . $this->getFileType() . ", Size: "
            . $this->getFileSize() . ", Mode: " . $this->getMode() . ", Name(Bytes): "
            . implode(":", ilStr::getBytesForString($this->getFileName())));
        $this->log->logStack(ilLogLevel::DEBUG);
 
        $DIC->database()->insert('file_data', $this->getArrayForDatabase());
 
        // no meta data handling for file list files
        if ($this->getMode() != self::MODE_FILELIST) {
            $this->createMetaData();
        }
    }
 
 
    public function setNoMetaDataCreation($a_status)
    {
        $this->no_meta_data_creation = (bool) $a_status;
    }
 
 
    protected function beforeCreateMetaData()
    {
        return !(bool) $this->no_meta_data_creation;
    }
 
 
    protected function beforeUpdateMetaData()
    {
        return !(bool) $this->no_meta_data_creation;
    }
 
 
    protected function doCreateMetaData()
    {
        // add technical section with file size and format
        $md_obj = new ilMD($this->getId(), 0, $this->getType());
        $technical = $md_obj->addTechnical();
        $technical->setSize($this->getFileSize());
        $technical->save();
        $format = $technical->addFormat();
        $format->setFormat($this->getFileType());
        $format->save();
        $technical->update();
    }
 
 
    protected function beforeMDUpdateListener($a_element)
    {
        // Check file extension
        // Removing the file extension is not allowed
        include_once 'Services/MetaData/classes/class.ilMD.php';
        $md = new ilMD($this->getId(), 0, $this->getType());
        if (!is_object($md_gen = $md->getGeneral())) {
            return false;
        }
        $title = $this->checkFileExtension($this->getFileName(), $md_gen->getTitle());
        $md_gen->setTitle($title);
        $md_gen->update();
 
        return true;
    }
 
 
    protected function doMDUpdateListener($a_element)
    {
        // handling for technical section
        include_once 'Services/MetaData/classes/class.ilMD.php';
 
        switch ($a_element) {
            case 'Technical':
 
                // Update Format (size is not stored in db)
                $md = new ilMD($this->getId(), 0, $this->getType());
                if (!is_object($md_technical = $md->getTechnical())) {
                    return false;
                }
 
                foreach ($md_technical->getFormatIds() as $id) {
                    $md_format = $md_technical->getFormat($id);
                    ilObjFile::_writeFileType($this->getId(), $md_format->getFormat());
                    $this->setFileType($md_format->getFormat());
                    break;
                }
 
                break;
        }
 
        return true;
    }
 
 
    public function getDirectory($a_version = 0)
    {
        $version_subdir = "";
 
        if ($a_version) {
            // BEGIN WebDAV Avoid double slash before version subdirectory
            $version_subdir = sprintf("%03d", $a_version);
            // END WebDAV Avoid  double slash before version subdirectory
        }
 
        if (!is_object($this->file_storage)) {
            $this->initFileStorage();
        }
 
        $str = $this->file_storage->getAbsolutePath() . '/' . $version_subdir;
 
        return $str;
    }
 
 
    public function createDirectory()
    {
        ilUtil::makeDirParents($this->getDirectory());
    }
 
 
    public function raiseUploadError($a_raise = true)
    {
        $this->raise_upload_error = $a_raise;
    }
 
 
    public function getUploadFile($a_upload_file, $a_filename, $a_prevent_preview = false)
    {
        global $DIC;
 
        $upload = $DIC->upload();
        $result = null;
 
        if ($upload->hasUploads()) {
            if ($upload->hasBeenProcessed() !== true) {
                if (PATH_TO_GHOSTSCRIPT !== "") {
                    $upload->register(new ilCountPDFPagesPreProcessors());
                }
                $upload->process();
            }
            $result = $upload->getResults()[$a_upload_file];
            if ($result->getStatus()->getCode() === \ILIAS\FileUpload\DTO\ProcessingStatus::OK) {
                $metadata = $result->getMetaData();
                if ($metadata->has(ilCountPDFPagesPreProcessors::PAGE_COUNT)) {
                    $this->setPageCount($metadata->get(ilCountPDFPagesPreProcessors::PAGE_COUNT));
                    $this->doUpdate();
                }
                $a_name = $result->getName();
                $this->setFileName($a_name);
 
                $this->setVersion($this->getVersion() + 1);
 
                if (!is_dir($this->getDirectory($this->getVersion()))) {
                    ilUtil::makeDirParents($this->getDirectory($this->getVersion()));
                }
 
                $target_directory = $this->getDirectory($this->getVersion()) . "/";
                $relative_path_to_file = LegacyPathHelper::createRelativePath($target_directory);
 
                $upload->moveOneFileTo($result, $relative_path_to_file, Location::STORAGE);
 
                $this->handleQuotaUpdate($this);
 
                // create preview?
                if (!$a_prevent_preview) {
                    $this->createPreview(false);
                }
            } else {
                throw new ilFileException('not supported File');
            }
        }
 
        return $result;
    }
 
 
    public function replaceFile($a_upload_file, $a_filename)
    {
        if ($result = $this->getUploadFile($a_upload_file, $a_filename, true)) {
            ilHistory::_createEntry($this->getId(), "replace", $a_filename . "," . $this->getVersion());
            $this->addNewsNotification("file_updated");
 
            // create preview
            $this->createPreview(true);
        }
 
        return $result;
    }
 
 
    public function addFileVersion($a_upload_file, $a_filename)
    {
        if ($result = $this->getUploadFile($a_upload_file, $a_filename, true)) {
            ilHistory::_createEntry($this->getId(), "new_version", $result->getName() . "," . $this->getVersion());
            $this->addNewsNotification("file_updated");
 
            // create preview
            $this->createPreview($this->getVersion() > 1);
        }
 
        return $result;
    }
 
 
    public function copy($a_source, $a_destination)
    {
        return copy($a_source, $this->getDirectory() . "/" . $a_destination);
    }
 
 
    public function clearDataDirectory()
    {
        ilUtil::delDir($this->getDirectory());
        $this->createDirectory();
    }
 
 
    public function deleteVersions($a_hist_entry_ids = null)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        if ($a_hist_entry_ids == null || count($a_hist_entry_ids) < 1) {
            $ilDB->manipulate("UPDATE file_data SET version = 1 WHERE file_id = "
                . $ilDB->quote($this->getId(), 'integer'));
            $this->setVersion(0);
            $this->clearDataDirectory();
 
            ilHistory::_removeEntriesForObject($this->getId());
 
            self::handleQuotaUpdate($this);
        } else {
            $actualVersionDeleted = false;
 
            // get all versions
            $versions = $this->getVersions();
 
            // delete each version
            foreach ($a_hist_entry_ids as $hist_id) {
                $entry = null;
 
                // get version
                foreach ($versions as $index => $version) {
                    if ($version["hist_entry_id"] == $hist_id) {
                        // remove each history entry
                        ilHistory::_removeEntryByHistoryID($hist_id);
 
                        // delete directory
                        $version_dir = $this->getDirectory($version["version"]);
                        ilUtil::delDir($version_dir);
 
                        // is actual version?
                        if ($version["version"] == $this->getVersion()) {
                            $actualVersionDeleted = true;
                        }
 
                        // remove from array
                        unset($versions[$index]);
                        break;
                    }
                }
            }
 
            // update actual version if it was deleted before
            if ($actualVersionDeleted) {
                // get newest version (already sorted by getVersions)
                $version = reset($versions);
                $this->updateWithVersion($version);
            } else {
                // updateWithVersion() will trigger quota, too
                self::handleQuotaUpdate($this);
            }
        }
    }
 
 
    protected function doRead()
    {
        global $DIC;
 
        $q = "SELECT * FROM file_data WHERE file_id = %s";
        $r = $DIC->database()->queryF($q, ['integer'], [$this->getId()]);
        $row = $r->fetchObject();
 
        $this->setFileName($row->file_name);
        $this->setFileType($row->file_type);
        $this->setFileSize($row->file_size);
        $this->setVersion($row->version ? $row->version : 1);
        $this->setMode($row->f_mode);
        $this->setRating($row->rating);
        $this->setPageCount($row->page_count);
 
        $this->initFileStorage();
    }
 
 
    protected function beforeUpdate()
    {
        // no meta data handling for file list files
        if ($this->getMode() != self::MODE_FILELIST) {
            $this->updateMetaData();
        }
 
        return true;
    }
 
 
    protected function doUpdate()
    {
        global $DIC;
 
        $a_columns = $this->getArrayForDatabase();
        $DIC->database()->update('file_data', $a_columns, [
            'file_id' => [
                'integer',
                $this->getId(),
            ],
        ]);
 
        self::handleQuotaUpdate($this);
 
        return true;
    }
 
 
    protected function doUpdateMetaData()
    {
        // add technical section with file size and format
        $md_obj = new ilMD($this->getId(), 0, $this->getType());
        if (!is_object($technical = $md_obj->getTechnical())) {
            $technical = $md_obj->addTechnical();
            $technical->save();
        }
        $technical->setSize($this->getFileSize());
 
        $format_ids = $technical->getFormatIds();
        if (count($format_ids) > 0) {
            $format = $technical->getFormat($format_ids[0]);
            $format->setFormat($this->getFileType());
            $format->update();
        } else {
            $format = $technical->addFormat();
            $format->setFormat($this->getFileType());
            $format->save();
        }
        $technical->update();
    }
 
 
    public function setFileName($a_name)
    {
        $this->filename = $a_name;
    }
 
 
    public function getFileName()
    {
        return $this->filename;
    }
 
 
    public function setFileType($a_type)
    {
        $this->filetype = $a_type;
    }
 
 
    public function getFileType()
    {
        return $this->filetype;
    }
 
 
    public function setFileSize($a_size)
    {
        $this->filesize = $a_size;
    }
 
 
    public function getFileSize()
    {
        return $this->filesize;
    }
 
 
    public function getDiskUsage()
    {
        require_once("./Modules/File/classes/class.ilObjFileAccess.php");
 
        return ilObjFileAccess::_lookupDiskUsage($this->id);
    }
 
 
    // END PATCH WebDAV Encapsulate file access in ilObjFile class.
    public function getFile($a_hist_entry_id = null)
    {
        if (is_null($a_hist_entry_id)) {
            $file = $this->getDirectory($this->getVersion()) . "/" . $this->getFileName();
        } else {
            require_once("./Services/History/classes/class.ilHistory.php");
            $entry = ilHistory::_getEntryByHistoryID($a_hist_entry_id);
 
            if ($entry === false) {
                return false;
            }
 
            $data = $this->parseInfoParams($entry);
            $file = $this->getDirectory($data["version"]) . "/" . $data["filename"];
        }
 
        return $file;
    }
 
 
    // END PATCH WebDAV Encapsulate file access in ilObjFile class.
 
    public function setVersion($a_version)
    {
        $this->version = $a_version;
    }
 
 
    public function getVersion()
    {
        return $this->version;
    }
 
 
    public function setMode($a_mode)
    {
        $this->mode = $a_mode;
    }
 
 
    public function getMode()
    {
        return $this->mode;
    }
 
 
    public static function _writeFileType($a_id, $a_format)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $q = "UPDATE file_data SET " . " file_type = " . $ilDB->quote($a_format, 'text')
            . " WHERE file_id = " . $ilDB->quote($a_id, 'integer');
        $res = $ilDB->manipulate($q);
    }
 
 
    public static function _lookupFileName($a_id)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $q = "SELECT * FROM file_data WHERE file_id = " . $ilDB->quote($a_id, 'integer');
        $r = $ilDB->query($q);
        $row = $r->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
 
        $strip_slashes = ilUtil::stripSlashes($row->file_name);
 
        return $strip_slashes;
    }
 
 
    public static function _lookupFileSize($a_id)
    {
        require_once("./Modules/File/classes/class.ilObjFileAccess.php");
 
        return ilObjFileAccess::_lookupFileSize($a_id);
    }
 
 
    public static function _lookupVersion($a_id)
    {
        require_once("./Modules/File/classes/class.ilObjFileAccess.php");
 
        return ilObjFileAccess::_lookupVersion($a_id);
    }
 
 
    public function determineFileSize($a_hist_entry_id = null)
    {
        if (is_null($a_hist_entry_id)) {
            $file = $this->getDirectory($this->getVersion()) . "/" . $this->getFileName();
        } else {
            require_once("./Services/History/classes/class.ilHistory.php");
            $entry = ilHistory::_getEntryByHistoryID($a_hist_entry_id);
 
            if ($entry === false) {
                return false;
            }
 
            $data = $this->parseInfoParams($entry);
            $file = $this->getDirectory($data["version"]) . "/" . $data["filename"];
        }
        if (is_file($file)) {
            $this->setFileSize(filesize($file));
        }
    }
 
 
    public function sendFile($a_hist_entry_id = null)
    {
        $s = new FilePathSanitizer($this);
        $s->sanitizeIfNeeded();
 
        if (is_null($a_hist_entry_id)) {
            $file = $this->getDirectory($this->getVersion()) . "/" . $this->getFileName();
        } else {
            $entry = ilHistory::_getEntryByHistoryID($a_hist_entry_id);
            $data = $this->parseInfoParams($entry);
            $file = $this->getDirectory($data["version"]) . "/" . $data["filename"];
        }
 
        $file = ilFileUtils::getValidFilename($file);
 
        if ($this->file_storage->fileExists($file)) {
            global $DIC;
            $ilClientIniFile = $DIC['ilClientIniFile'];
            $ilFileDelivery = new ilFileDelivery($file);
            $ilFileDelivery->setDisposition($this->isInline() ? ilFileDelivery::DISP_INLINE : ilFileDelivery::DISP_ATTACHMENT);
            $ilFileDelivery->setMimeType($this->guessFileType($file));
            $ilFileDelivery->setConvertFileNameToAsci((bool) !$ilClientIniFile->readVariable('file_access', 'disable_ascii'));
 
            // also returning the 'real' filename if a history file is delivered
            if ($ilClientIniFile->readVariable('file_access', 'download_with_uploaded_filename')
                != '1'
                && is_null($a_hist_entry_id)
            ) {
                $ilFileDelivery->setDownloadFileName(ilFileUtils::getValidFilename($this->getTitle()));
            } else {
                // $download_file_name = basename($file);
                /* FSX Info: basename has a Bug with Japanese and other characters, see:
                 * http://stackoverflow.com/questions/32115609/basename-fail-when-file-name-start-by-an-accent
                 * Therefore we can no longer use basename();
                 */
                $parts = explode(DIRECTORY_SEPARATOR, $file);
                $download_file_name = end($parts);
                $download_file_name = ilFileUtils::getValidFilename($download_file_name);
                $ilFileDelivery->setDownloadFileName($download_file_name);
            }
            $ilFileDelivery->deliver();
 
            return true;
        }
 
        throw new \ILIAS\Filesystem\Exception\FileNotFoundException("This file cannot be found in ILIAS or has been blocked due to security reasons.");
    }
 
 
    public function getFileExtension()
    {
        require_once 'Modules/File/classes/class.ilObjFileAccess.php';
 
        return ilObjFileAccess::_getFileExtension($this->getTitle());
    }
 
 
    public function isInline()
    {
        require_once 'Modules/File/classes/class.ilObjFileAccess.php';
 
        return ilObjFileAccess::_isFileInline($this->getTitle());
    }
 
 
    public function isHidden()
    {
        require_once 'Modules/File/classes/class.ilObjFileAccess.php';
 
        return ilObjFileAccess::_isFileHidden($this->getTitle());
    }
    // END WebDAV: Get file extension, determine if file is inline, guess file type.
 
 
    public function guessFileType($a_file = "")
    {
        $path = pathinfo($a_file);
        if ($path["extension"] != "") {
            $filename = $path["basename"];
        } else {
            $filename = "dummy." . $this->getFileExtension();
        }
        include_once("./Services/Utilities/classes/class.ilMimeTypeUtil.php");
        $mime = ilMimeTypeUtil::getMimeType($a_file, $filename, $this->getFileType());
 
        return $mime;
    }
 
 
    protected function doCloneObject($a_new_obj, $a_target_id, $a_copy_id = 0)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $a_new_obj->createDirectory();
        $this->cloneMetaData($a_new_obj);
 
        // Copy all file versions
        ilUtil::rCopy($this->getDirectory(), $a_new_obj->getDirectory());
 
        // object created now copy other settings
        $query = "INSERT INTO file_data (file_id,file_name,file_type,file_size,version,rating,f_mode) VALUES ("
            . $ilDB->quote($a_new_obj->getId(), 'integer') . ","
            . $ilDB->quote($this->getFileName(), 'text') . ","
            . $ilDB->quote($this->getFileType(), 'text') . ","
            . $ilDB->quote((int) $this->getFileSize(), 'integer') . ", "
            . $ilDB->quote($this->getVersion(), 'integer') . ", "
            . $ilDB->quote($this->hasRating(), 'integer') . ", "
            . $ilDB->quote($this->getMode(), 'text') . ")";
        $res = $ilDB->manipulate($query);
 
        // copy all previews
        require_once("./Services/Preview/classes/class.ilPreview.php");
        ilPreview::copyPreviews($this->getId(), $a_new_obj->getId());
 
        // copy history entries
        require_once("./Services/History/classes/class.ilHistory.php");
        ilHistory::_copyEntriesForObject($this->getId(), $a_new_obj->getId());
 
        // Copy learning progress settings
        include_once('Services/Tracking/classes/class.ilLPObjSettings.php');
        $obj_settings = new ilLPObjSettings($this->getId());
        $obj_settings->cloneSettings($a_new_obj->getId());
        unset($obj_settings);
 
        // add news notification
        $a_new_obj->addNewsNotification("file_created");
 
        return $a_new_obj;
    }
 
 
    protected function beforeDelete()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        // check, if file is used somewhere
        $usages = $this->getUsages();
        if (count($usages) == 0) {
            return true;
        }
 
        return false;
    }
 
 
    protected function doDelete()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        // delete file data entry
        $q = "DELETE FROM file_data WHERE file_id = " . $ilDB->quote($this->getId(), 'integer');
        $this->ilias->db->query($q);
 
        // delete history entries
        require_once("./Services/History/classes/class.ilHistory.php");
        ilHistory::_removeEntriesForObject($this->getId());
 
        self::handleQuotaUpdate($this);
 
        // delete entire directory and its content
        if (@is_dir($this->getDirectory())) {
            ilUtil::delDir($this->getDirectory());
        }
 
        // delete meta data
        if ($this->getMode() != self::MODE_FILELIST) {
            $this->deleteMetaData();
        }
 
        // delete preview
        $this->deletePreview();
    }
 
 
    public function export($a_target_dir)
    {
        $subdir = "il_" . IL_INST_ID . "_file_" . $this->getId();
        ilUtil::makeDir($a_target_dir . "/objects/" . $subdir);
 
        $filedir = $this->getDirectory($this->getVersion());
 
        if (@!is_dir($filedir)) {
            $filedir = $this->getDirectory();
        }
 
        ilUtil::rCopy($filedir, $a_target_dir . "/objects/" . $subdir);
    }
 
 
    public static function _deleteAllUsages($a_type, $a_id, $a_usage_hist_nr = 0, $a_usage_lang = "-")
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $and_hist = ($a_usage_hist_nr !== false) ? " AND usage_hist_nr = "
            . $ilDB->quote($a_usage_hist_nr, "integer") : "";
 
        $file_ids = array();
        $set = $ilDB->query("SELECT id FROM file_usage" . " WHERE usage_type = "
            . $ilDB->quote($a_type, "text") . " AND usage_id= "
            . $ilDB->quote($a_id, "integer") . " AND usage_lang= "
            . $ilDB->quote($a_usage_lang, "text") . $and_hist);
        while ($row = $ilDB->fetchAssoc($set)) {
            $file_ids[] = $row["id"];
        }
 
        $ilDB->manipulate("DELETE FROM file_usage WHERE usage_type = "
            . $ilDB->quote($a_type, "text") . " AND usage_id = "
            . $ilDB->quote((int) $a_id, "integer") . " AND usage_lang= "
            . $ilDB->quote($a_usage_lang, "text") . " AND usage_hist_nr = "
            . $ilDB->quote((int) $a_usage_hist_nr, "integer"));
 
        foreach ($file_ids as $file_id) {
            self::handleQuotaUpdate(new self($file_id, false));
        }
    }
 
 
    public static function _saveUsage($a_file_id, $a_type, $a_id, $a_usage_hist_nr = 0, $a_usage_lang = "-")
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        // check if file really exists
        if (ilObject::_lookupType($a_file_id) != "file") {
            return;
        }
        // #15143
        $ilDB->replace("file_usage", array(
            "id"            => array("integer", (int) $a_file_id),
            "usage_type"    => array("text", (string) $a_type),
            "usage_id"      => array("integer", (int) $a_id),
            "usage_hist_nr" => array("integer", (int) $a_usage_hist_nr),
            "usage_lang"    => array("text", $a_usage_lang),
        ), array());
 
        self::handleQuotaUpdate(new self($a_file_id, false));
    }
 
 
    public function getUsages()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        // get usages in learning modules
        $q = "SELECT * FROM file_usage WHERE id = " . $ilDB->quote($this->getId(), "integer");
        $us_set = $ilDB->query($q);
        $ret = array();
        while ($us_rec = $ilDB->fetchAssoc($us_set)) {
            $ret[] = array(
                "type"    => $us_rec["usage_type"],
                "id"      => $us_rec["usage_id"],
                "lang"    => $us_rec["usage_lang"],
                "hist_nr" => $us_rec["usage_hist_nr"],
            );
        }
 
        return $ret;
    }
 
 
    public static function _getFilesOfObject($a_type, $a_id, $a_usage_hist_nr = 0, $a_usage_lang = "-")
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
 
        $lstr = "";
        if ($a_usage_lang != "") {
            $lstr = "usage_lang = " . $ilDB->quote((string) $a_usage_lang, "text") . " AND ";
        }
 
        // get usages in learning modules
        $q = "SELECT * FROM file_usage WHERE " . "usage_id = " . $ilDB->quote((int) $a_id, "integer")
            . " AND " . "usage_type = " . $ilDB->quote((string) $a_type, "text") . " AND " . $lstr
            . "usage_hist_nr = " . $ilDB->quote((int) $a_usage_hist_nr, "integer");
        $file_set = $ilDB->query($q);
        $ret = array();
        while ($file_rec = $ilDB->fetchAssoc($file_set)) {
            $ret[$file_rec["id"]] = $file_rec["id"];
        }
 
        return $ret;
    }
 
 
    // TODO: What is this function good for??
    public function getXMLZip()
    {
        global $DIC;
        $ilias = $DIC['ilias'];
 
        $zip = PATH_TO_ZIP;
 
        exec($zip . ' ' . ilUtil::escapeShellArg($this->getDirectory() . '/' . $this->getFileName())
            . " " . ilUtil::escapeShellArg($this->getDirectory() . '/' . '1.zip'));
 
        return $this->getDirectory() . '/1.zip';
    }
 
 
    public function addNewsNotification($a_lang_var)
    {
        // BEGIN WebDAV Suppress news notification for hidden files
        if ($this->isHidden()) {
            return;
        }
        // END WebDAV Suppress news notification for hidden files
 
        global $DIC;
        $ilUser = $DIC['ilUser'];
 
        // Add Notification to news
        include_once("./Services/News/classes/class.ilNewsItem.php");
        include_once("./Modules/File/classes/class.ilObjFileAccess.php");
        $news_item = new ilNewsItem();
        $news_item->setContext($this->getId(), $this->getType());
        $news_item->setPriority(NEWS_NOTICE);
        $news_item->setTitle($a_lang_var);
        $news_item->setContentIsLangVar(true);
        if ($this->getDescription() != "") {
            $news_item->setContent("<p>" . $this->getDescription() . "</p>");
        }
        $news_item->setUserId($ilUser->getId());
        $news_item->setVisibility(NEWS_USERS);
        $news_item->create();
    }
 
 
    public function initFileStorage()
    {
        $this->file_storage = new ilFSStorageFile($this->getId());
 
        return true;
    }
 
 
    public function storeUnzipedFile($a_upload_file, $a_filename)
    {
        $this->setVersion($this->getVersion() + 1);
 
        if (@!is_dir($this->getDirectory($this->getVersion()))) {
            ilUtil::makeDir($this->getDirectory($this->getVersion()));
        }
 
        $file = $this->getDirectory($this->getVersion()) . "/" . $a_filename;
 
        ilFileUtils::rename($a_upload_file, $file);
 
        // create preview
        $this->createPreview();
    }
 
 
    public static function _lookupAbsolutePath($obj_id, $a_version = null)
    {
        $file_object = new self($obj_id, false);
        $s = new FilePathSanitizer($file_object);
        $s->sanitizeIfNeeded();
 
        return $file_object->getFile($a_version);
    }
 
 
    public function checkFileExtension($new_filename, $new_title)
    {
        include_once './Modules/File/classes/class.ilObjFileAccess.php';
        $fileExtension = ilObjFileAccess::_getFileExtension($new_filename);
        $titleExtension = ilObjFileAccess::_getFileExtension($new_title);
        if ($titleExtension != $fileExtension && strlen($fileExtension) > 0) {
            // remove old extension
            $pi = pathinfo($this->getFileName());
            $suffix = $pi["extension"];
            if ($suffix != "") {
                if (substr($new_title, strlen($new_title) - strlen($suffix) - 1) == "." . $suffix) {
                    $new_title = substr($new_title, 0, strlen($new_title) - strlen($suffix) - 1);
                }
            }
            $new_title .= '.' . $fileExtension;
        }
 
        return $new_title;
    }
 
 
    public function getVersions($version_ids = null)
    {
        include_once("./Services/History/classes/class.ilHistory.php");
        $versions = ilHistory::_getEntriesForObject($this->getId(), $this->getType());
 
        if ($version_ids != null && count($version_ids) > 0) {
            foreach ($versions as $index => $version) {
                if (!in_array($version["hist_entry_id"], $version_ids, true)) {
                    unset($versions[$index]);
                }
            }
        }
 
        // add custom entries
        foreach ($versions as $index => $version) {
            $params = $this->parseInfoParams($version);
            $versions[$index] = array_merge($version, $params);
        }
 
        // sort by version number (hist_entry_id will do for that)
        usort($versions, array($this, "compareVersions"));
 
        return $versions;
    }
 
 
    public function getSpecificVersion($version_id)
    {
        include_once("./Services/History/classes/class.ilHistory.php");
        $version = ilHistory::_getEntryByHistoryID($version_id);
        if ($version === false) {
            return false;
        }
 
        // ilHistory returns different keys in _getEntryByHistoryID and _getEntriesForObject
        // so this makes it the same
        $version["hist_entry_id"] = $version["id"];
        $version["user_id"] = $version["usr_id"];
        $version["date"] = $version["hdate"];
        unset($version["id"], $version["usr_id"], $version["hdate"]);
 
        // parse params
        $params = $this->parseInfoParams($version);
 
        return array_merge($version, $params);
    }
 
 
    public function rollback($version_id)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        $ilUser = $DIC['ilUser'];
 
        $source = $this->getSpecificVersion($version_id);
        if ($source === false) {
            $this->ilErr->raiseError($this->lng->txt("obj_not_found"), $this->ilErr->MESSAGE);
        }
 
        // get the new version number
        $new_version_nr = $this->getVersion() + 1;
 
        // copy file
        $source_path = $this->getDirectory($source["version"]) . "/" . $source["filename"];
        $dest_dir = $this->getDirectory($new_version_nr);
        if (@!is_dir($dest_dir)) {
            ilUtil::makeDir($dest_dir);
        }
 
        copy($source_path, $dest_dir . "/" . $source["filename"]);
 
        // create new history entry based on the old one
        include_once("./Services/History/classes/class.ilHistory.php");
        ilHistory::_createEntry($this->getId(), "rollback", $source["filename"] . ","
            . $new_version_nr . "|"
            . $source["version"] . "|"
            . $ilUser->getId());
 
        // get id of newest entry
        // bugfix mantis 23596
        $entries = ilHistory::_getEntriesForObject($this->getId());
        $newest_entry_id = 0;
        foreach ($entries as $entry) {
            if ($entry["action"] == "rollback") {
                $newest_entry_id = $entry["hist_entry_id"];
            }
        }
        $new_version = $this->getSpecificVersion($newest_entry_id);
 
        // change user back to the original uploader
        ilHistory::_changeUserId($new_version["hist_entry_id"], $source["user_id"]);
 
        // update this file with the new version
        $this->updateWithVersion($new_version);
 
        $this->addNewsNotification("file_updated");
 
        return $new_version;
    }
 
 
    protected function updateWithVersion($version)
    {
        // update title (checkFileExtension must be called before setFileName!)
        $this->setTitle($this->checkFileExtension($version["filename"], $this->getTitle()));
 
        $this->setVersion($version["version"]);
        $this->setFileName($version["filename"]);
 
        // evaluate mime type (reset file type before)
        $this->setFileType("");
        $this->setFileType($this->guessFileType($version["filename"]));
 
        // set filesize
        $this->determineFileSize();
 
        $this->update();
 
        // refresh preview
        $this->createPreview(true);
    }
 
 
    public function compareVersions($v1, $v2)
    {
        // v2 - v1 because version should be descending
        return (int) $v2["version"] - (int) $v1["version"];
    }
 
 
    public function parseInfoParams($entry)
    {
        $data = preg_split("/(.*),(.*)/", $entry["info_params"], 0, PREG_SPLIT_DELIM_CAPTURE
            | PREG_SPLIT_NO_EMPTY);
 
        // bugfix: first created file had no version number
        // this is a workaround for all files created before the bug was fixed
        if (empty($data[1])) {
            $data[1] = "1";
        }
 
        $result = array(
            "filename"         => $data[0],
            "version"          => $data[1],
            "rollback_version" => "",
            "rollback_user_id" => "",
        );
 
        // if rollback, the version contains the rollback version as well
        if ($entry["action"] == "rollback") {
            $tokens = explode("|", $result["version"]);
            if (count($tokens) > 1) {
                $result["version"] = $tokens[0];
                $result["rollback_version"] = $tokens[1];
 
                if (count($tokens) > 2) {
                    $result["rollback_user_id"] = $tokens[2];
                }
            }
        }
 
        return $result;
    }
 
 
    protected static function handleQuotaUpdate(ilObjFile $a_file)
    {
        include_once "Services/MediaObjects/classes/class.ilObjMediaObject.php";
        $mob = new ilObjMediaObject();
 
        // file itself could be workspace item
        $parent_obj_ids = array($a_file->getId());
 
        foreach ($a_file->getUsages() as $item) {
            $parent_obj_id = $mob->getParentObjectIdForUsage($item);
            if ($parent_obj_id
                && !in_array($parent_obj_id, $parent_obj_ids)
            ) {
                $parent_obj_ids[] = $parent_obj_id;
            }
        }
 
        include_once "Services/DiskQuota/classes/class.ilDiskQuotaHandler.php";
        ilDiskQuotaHandler::handleUpdatedSourceObject($a_file->getType(), $a_file->getId(), $a_file->getDiskUsage(), $parent_obj_ids);
    }
 
 
    protected function createPreview($force = false)
    {
        // only normal files are supported
        if ($this->getMode() != self::MODE_OBJECT) {
            return;
        }
 
        require_once("./Services/Preview/classes/class.ilPreview.php");
        ilPreview::createPreview($this, $force);
    }
 
 
    protected function deletePreview()
    {
        // only normal files are supported
        if ($this->getMode() != self::MODE_OBJECT) {
            return;
        }
 
        require_once("./Services/Preview/classes/class.ilPreview.php");
        ilPreview::deletePreview($this->getId());
    }
 
 
    public function setRating($a_value)
    {
        $this->rating = (bool) $a_value;
    }
 
 
    public function hasRating()
    {
        return $this->rating;
    }
 
 
    public function getPageCount()
    {
        return $this->page_count;
    }
 
 
    public function setPageCount($page_count)
    {
        $this->page_count = $page_count;
    }
 
 
    private function getArrayForDatabase()
    {
        return [
            'file_id'    => ['integer', $this->getId()],
            'file_name'  => ['text', $this->getFileName()],
            'file_type'  => ['text', $this->getFileType()],
            'file_size'  => ['integer', (int) $this->getFileSize()],
            'version'    => ['integer', (int) $this->getVersion()],
            'f_mode'     => ['text', $this->getMode()],
            'page_count' => ['text', $this->getPageCount()],
            'rating'     => ['integer', $this->hasRating()],
        ];
    }
}