class.ilObjectCustomUserFieldHistory.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2010 ILIAS open source, Extended GPL, see docs/LICENSE */
 
class ilObjectCustomUserFieldHistory
{
        private $obj_id = 0;
        private $user_id = 0;
        private $update_user = 0;
        private $editing_time = null;
        
        public function __construct($a_obj_id, $a_user_id)
        {
                $this->obj_id = $a_obj_id;
                $this->user_id = $a_user_id;
                $this->read();
        }
        
        public static function lookupEntriesByObjectId($a_obj_id)
        {
                global $ilDB;
                
                $query = 'SELECT * FROM obj_user_data_hist '.
                                'WHERE obj_id = '.$ilDB->quote($a_obj_id,'integer');
                $res = $ilDB->query($query);
                
                $users = array();
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $users[$row->usr_id]['update_user'] = $row->update_user;
                        $users[$row->usr_id]['editing_time'] = new ilDateTime($row->editing_time,IL_CAL_DATETIME,  ilTimeZone::UTC);
                }
                return $users;
        }
 
        public function setUpdateUser($a_id)
        {
                $this->update_user = $a_id;
        }
        
        public function getUpdateUser()
        {
                return $this->update_user;
        }
        
        public function setEditingTime(ilDateTime $dt)
        {
                $this->editing_time = $dt;
        }
        
        public function getEditingTime()
        {
                return $this->editing_time;
        }
        
        public function save()
        {
                global $ilDB;
                
                $this->delete();
                
                $query = 'INSERT INTO obj_user_data_hist (obj_id, usr_id, update_user, editing_time) '.
                                'VALUES( '.
                                $ilDB->quote($this->obj_id,'integer').', '.
                                $ilDB->quote($this->user_id,'integer').', '.
                                $ilDB->quote($this->getUpdateUser(),'integer').', '.
                                $ilDB->quote($this->getEditingTime()->get(IL_CAL_DATETIME,'', ilTimeZone::UTC)).' '.
                                ')';
                $ilDB->manipulate($query);
        }
        
        public function delete()
        {
                global $ilDB;
                
                $query = 'DELETE FROM obj_user_data_hist '.
                                'WHERE obj_id = '.$ilDB->quote($this->obj_id,'integer').' '.
                                'AND usr_id = '.$ilDB->quote($this->user_id,'integer');
                $ilDB->manipulate($query);
        }
        
        protected function read()
        {
                global $ilDB;
                
                $query = 'SELECT * FROM obj_user_data_hist '.
                                'WHERE obj_id = '.$ilDB->quote($this->obj_id,'integer').' '.
                                'AND usr_id = '.$ilDB->quote($this->user_id,'integer');
                $res = $ilDB->query($query);
                while($row = $res->fetchRow(DB_FETCHMODE_OBJECT))
                {
                        $this->setEditingTime(new ilDateTime($row->editing_time,IL_CAL_DATETIME,  ilTimeZone::UTC));
                        $this->setUpdateUser($row->update_user);
                }
        }
}
 
?>