class.ilDAVProperties.php

Go to the documentation of this file.

<?php
// BEGIN WebDAV
/*
    +-----------------------------------------------------------------------------+
    | ILIAS open source                                                           |
    +-----------------------------------------------------------------------------+
    | Copyright (c) 1998-2005 ILIAS open source, University of Cologne            |
    |                                                                             |
    | This program is free software; you can redistribute it and/or               |
    | modify it under the terms of the GNU General Public License                 |
    | as published by the Free Software Foundation; either version 2              |
    | of the License, or (at your option) any later version.                      |
    |                                                                             |
    | This program is distributed in the hope that it will be useful,             |
    | but WITHOUT ANY WARRANTY; without even the implied warranty of              |
    | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the               |
    | GNU General Public License for more details.                                |
    |                                                                             |
    | You should have received a copy of the GNU General Public License           |
    | along with this program; if not, write to the Free Software                 |
    | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA. |
    +-----------------------------------------------------------------------------+
*/
 
    
class ilDAVProperties
{
    private $table = 'dav_property';
    
    
    public function put($objDAV, $namespace, $name, $value)
    {
        //$this->writelog('put ns='.$namespace.' name='.$name.' value='.$value);
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $objId = $objDAV->getObjectId();
        $nodeId = $objDAV->getNodeId();
        
        if (isset($value)) {
            $ilDB->replace(
                $this->table,
                array(
                    'obj_id'    => array('integer',$objId),
                    'node_id'   => array('integer',$nodeId),
                    'ns'                => array('text',$namespace),
                    'name'              => array('text',$name)
                    ),
                array('value'   => array('clob',$value))
            );
            
        /*
        $q = 'REPLACE INTO '.$this->table
                .' SET obj_id = '.$ilDB->quote($objId)
                .', node_id = '.$ilDB->quote($nodeId)
                .', ns = '.$ilDB->quote($namespace)
                .', name = '.$ilDB->quote($name)
                .', value = '.$ilDB->quote($value)
                ;
        */
        } else {
            $q = 'DELETE FROM ' . $this->table
                    . ' WHERE obj_id = ' . $ilDB->quote($objId, 'integer')
                    . ' AND node_id = ' . $ilDB->quote($nodeId, 'integer')
                    . ' AND ns = ' . $ilDB->quote($namespace, 'text')
                    . ' AND name = ' . $ilDB->quote($name, 'text')
                    ;
            $ilDB->manipulate($q);
        }
        //$this->writelog('put query='.$q);
        #$r = $ilDB->query($q);
    }
    
    public function get($objDAV, $namespace, $name, $value)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $objId = $objDAV->getObjectId();
        $nodeId = $objDAV->getNodeId();
        
        $q = 'SELECT value FROM ' . $this->table
                . ' WHERE obj_id = ' . $ilDB->quote($objId, 'integer')
                . ' AND node_id =' . $ilDB->quote($nodeId, 'integer')
                . ' AND ns = ' . $ilDB->quote($namespace, 'text')
                . ' AND name = ' . $ilDB->quote($name, 'text')
                ;
        $r = $ilDB->query($q);
        if ($row = $r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) {
            $value = $row['value'];
        } else {
            $value = null;
        }
        return $value;
    }
    public function getAll($objDAV)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $objId = $objDAV->getObjectId();
        $nodeId = $objDAV->getNodeId();
        
        $q = 'SELECT ns, name, value'
                . ' FROM ' . $this->table
                . ' WHERE obj_id = ' . $ilDB->quote($objId, 'integer')
                . ' AND node_id =' . $ilDB->quote($nodeId, 'integer')
                ;
        $r = $ilDB->query($q);
        $result = array();
        while ($row = $r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) {
            $result[] = array(
                'namespace' => $row['ns'],
                'name' => $row['name'],
                'value' => $row['value']
            );
        }
        return $result;
    }
    
    public function copy($fromObjDAV, $toObjDAV)
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];
        
        $fromObjId = $fromObjDAV->getObjectId();
        $fromNodeId = $fromObjDAV->getNodeId();
        $toObjId = $toObjDAV->getObjectId();
        $toNodeId = $toObjDAV->getNodeId();
        
        $q = 'SELECT ns, name, value FROM ' . $this->table
                . ' WHERE obj_id = ' . $ilDB->quote($objId, 'integer')
                . ' AND node_id =' . $ilDB->quote($nodeId, 'integer');
        /*                              .' FOR UPDATE' */
        $r = $ilDB->query($q);
        $result = array();
        while ($row = $r->fetchRow(ilDBConstants::FETCHMODE_ASSOC)) {
            $q2 = 'INSERT INTO ' . $this->table
                . ' (obj_id, node_id, ns, name, value)'
                . ' VALUES'
                . '(' . $ilDB->quote($row['obj_id'])
                . ', ' . $ilDB->quote($row['node_id'])
                . ', ' . $ilDB->quote($row['ns'])
                . ', ' . $ilDB->quote($row['name'])
                . ', ' . $ilDB->quote($row['value'])
                . ')'
            ;
            $r2 = $ilDB->manipulate($q2);
        }
    }
    
    protected function writelog($message)
    {
        global $DIC;
        $log = $DIC['log'];
        $ilias = $DIC['ilias'];
        $log->write(
            $ilias->account->getLogin()
            . ' DAV ilDAVProperties.' . str_replace("\n", ";", $message)
        );
        /*
        if ($this->logFile)
        {
            $fh = fopen($this->logFile, 'a');
            fwrite($fh, date('Y-m-d h:i:s '));
            fwrite($fh, str_replace("\n",";",$message));
            fwrite($fh, "\n\n");
            fclose($fh);
        }*/
    }
}
// END WebDAV