class.ilExportFileInfo.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilExportFileInfo
{
    const CURRENT_VERSION = "4.1.0";
    
    
    private $obj_id = 0;
    private $version = self::CURRENT_VERSION;
    private $export_type = '';
    private $file_name = '';
    private $create_date = null;

    public function __construct($a_obj_id, $a_export_type = '', $a_filename = '')
    {
        $this->obj_id = $a_obj_id;
        $this->export_type = $a_export_type;
        $this->file_name = $a_filename;
        if ($this->getObjId() and $this->getExportType() and $this->getFilename()) {
            $this->read();
        }
    }

    public static function lookupLastExport($a_obj_id, $a_type, $a_version = '')
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = "SELECT * FROM export_file_info " .
            "WHERE obj_id = " . $ilDB->quote($a_obj_id, 'integer') . ' ' .
            "AND export_type = " . $ilDB->quote($a_type, 'text') . ' ' .
            "ORDER BY create_date DESC";
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            if (!$a_version or $row->version == $a_version) {
                return new ilExportFileInfo($row->obj_id, $row->export_type, $row->filename);
            }
        }
        return null;
    }

    
    public static function deleteByObjId($a_obj_id)
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $ilDB->manipulate("DELETE FROM export_file_info WHERE obj_id = " . $ilDB->quote($a_obj_id));
        return true;
    }
    
    
    
    public function setExportType($a_type)
    {
        $this->export_type = $a_type;
    }
    
    public function getExportType()
    {
        return $this->export_type;
    }
    
    public function setFilename($a_name)
    {
        $this->file_name = $a_name;
    }
    
    public function getFilename()
    {
        return $this->file_name;
    }
    
    public function getBasename($a_ext = '.zip')
    {
        return basename($this->getFilename(), $a_ext);
    }
    
    public function setObjId($a_id)
    {
        $this->obj_id = $a_id;
    }
    
    public function getObjId()
    {
        return $this->obj_id;
    }

    public function setVersion($a_version)
    {
        $this->version = $a_version;
    }
    
    public function getVersion()
    {
        return $this->version;
    }
    
    public function getCreationDate()
    {
        return $this->create_date instanceof ilDateTime ? $this->create_date : new ilDateTime(time(), IL_CAL_UNIX);
    }
    
    public function setCreationDate(ilDateTime $dt = null)
    {
        $this->create_date = $dt;
    }
    
    public function create()
    {
        global $DIC;

        $db = $DIC->database();

        $exists_query = 'select * from export_file_info ' .
            'where obj_id = ' . $db->quote($this->obj_id, 'integer') . ' ' .
            'and export_type = ' . $db->quote($this->getExportType(), 'text') . ' ' .
            'and filename = ' . $db->quote($this->getFilename(), 'text');
        $exists_res = $db->query($exists_query);

        if (!$exists_res->numRows()) {
            $query = "INSERT INTO export_file_info (obj_id, export_type, filename, version, create_date) " .
                "VALUES ( " .
                $db->quote($this->getObjId(), 'integer') . ', ' .
                $db->quote($this->getExportType(), 'text') . ', ' .
                $db->quote($this->getFilename(), 'text') . ', ' .
                $db->quote($this->getVersion(), 'text') . ', ' .
                $db->quote($this->getCreationDate()->get(IL_CAL_DATETIME, '', ilTimeZone::UTC), 'timestamp') . ' ' .
                ")";
            $db->manipulate($query);
        }
    }

    public function delete()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $ilDB->manipulate(
            'DELETE FROM export_file_info ' .
            'WHERE obj_id = ' . $ilDB->quote($this->getObjId(), 'integer') . ' ' .
            'AND filename = ' . $ilDB->quote($this->getFilename(), 'text')
        );
        return true;
    }
    
    protected function read()
    {
        global $DIC;

        $ilDB = $DIC['ilDB'];
        
        $query = "SELECT * FROM export_file_info " .
            "WHERE obj_id = " . $ilDB->quote($this->getObjId(), 'integer') . ' ' .
            "AND export_type = " . $ilDB->quote($this->getExportType(), 'text') . ' ' .
            "AND filename = " . $ilDB->quote($this->getFilename(), 'text');
            
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $this->setVersion($row->version);
            $this->setCreationDate(new ilDateTime($row->create_date, IL_CAL_DATETIME, ilTimeZone::UTC));
        }
        return true;
    }
}