ilHistory Class Reference

This class methods for maintain history enties for objects. More...

Collaboration diagram for ilHistory:

Static Public Member Functions
static	_createEntry ( $a_obj_id, $a_action, $a_info_params="", $a_obj_type="", $a_user_comment="", $a_update_last=false)
	Creates a new history entry for an object. More...
static	_getEntriesForObject ($a_obj_id, $a_obj_type="")
	get all history entries for an object More...
static	_compareHistArray ($a, $b)
static	_removeEntriesForObject ($a_obj_id)
	remove all history entries for an object More...
static	_copyEntriesForObject ($a_src_id, $a_dst_id)
	copy all history entries for an object More...
static	_getEntryByHistoryID ($a_hist_entry_id)
	returns a single history entry More...
static	_removeEntryByHistoryID ($a_hist_entry_id)
	Removes a single entry from the history. More...
static	_changeUserId ($a_hist_entry_id, $new_user_id)
	Changes the user id of the specified history entry. More...

Detailed Description

This class methods for maintain history enties for objects.

Author

Alex Killing alex..nosp@m.kill.nosp@m.ing@g.nosp@m.mx.d.nosp@m.e

Version

$Id$

Definition at line 10 of file class.ilHistory.php.

Member Function Documentation

_changeUserId()

static ilHistory::_changeUserId (   $a_hist_entry_id,   $new_user_id  )

static

Changes the user id of the specified history entry.

Parameters

int	$a_hist_entry_id	The history entry to change the user id.
int	$new_user_id	The new user id.

Definition at line 301 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $ilDB->update(
            "history",
            array("usr_id" => array("integer", $new_user_id)),
            array("id" => array("integer", $a_hist_entry_id))
        );
    }

References $DIC, and $ilDB.

Referenced by ilObjFile\rollback().

Here is the caller graph for this function:

_compareHistArray()

static ilHistory::_compareHistArray (   $a,   $b  )

static

Definition at line 185 of file class.ilHistory.php.

    {
        if ($a["date"] == $b["date"]) {
            return 0;
        }
        return ($a["date"] < $b["date"]) ? -1 : 1;
    }

_copyEntriesForObject()

static ilHistory::_copyEntriesForObject (   $a_src_id,   $a_dst_id  )

static

copy all history entries for an object

Parameters

integer	$a_src_id	source object id
integer	$a_dst_id	destination object id

Returns

boolean

Definition at line 220 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $q = "SELECT * FROM history WHERE obj_id = " .
            $ilDB->quote($a_src_id, "integer");
        $r = $ilDB->query($q);
        
        while ($row = $ilDB->fetchObject($r)) {
            $id = $ilDB->nextId("history");
            $ilDB->insert("history", array(
                "id" => array("integer", $id),
                "obj_id" => array("integer", $a_dst_id),
                "obj_type" => array("text", $row->obj_type),
                "action" => array("text", $row->action),
                "hdate" => array("timestamp", ilUtil::now()),
                "usr_id" => array("integer", $row->usr_id),
                "info_params" => array("text", $row->info_params),
                "user_comment" => array("clob", $row->user_comment)
                ));
 
            /*
            $q = "INSERT INTO history (obj_id, obj_type, action, hdate, usr_id, info_params, user_comment) VALUES ".
                 "(".
                    $ilDB->quote($a_dst_id).", ".
                    $ilDB->quote($row->obj_type).", ".
                    $ilDB->quote($row->action).", ".
                    $ilDB->quote($row->hdate).", ".
                    $ilDB->quote($row->usr_id).", ".
                    $ilDB->quote($row->info_params).", ".
                    $ilDB->quote($row->user_comment).
                 ")";
 
            $ilDB->query($q);*/
        }
        
        return true;
    }

References $DIC, $id, $ilDB, $r, $row, and ilUtil\now().

Referenced by ilObjFile\doCloneObject().

Here is the call graph for this function:

Here is the caller graph for this function:

_createEntry()

static ilHistory::_createEntry (   $a_obj_id,   $a_action,   $a_info_params = "",   $a_obj_type = "",   $a_user_comment = "",   $a_update_last = false  )

static

Creates a new history entry for an object.

The information text parameters have to be separated by comma. The information text has to be stored in a langage variable "hist_<object_type>_<action>". This text can contain placeholders %1, %2, ... for each parameter. The placehoders are replaced by the parameters in ilHistoryTableGUI.

Please note that the object type must be specified, if the object is not derived from ilObject.

Parameters

int	$a_obj_id	object id
string	$a_action	action
string	$a_info_params	information text parameters, separated by comma or as an array
string	$a_obj_type	object type (must only be set, if object is not in object_data table)
string	$a_user_comment	user comment

Definition at line 31 of file class.ilHistory.php.

      {
        global $DIC;
 
        $ilDB = $DIC->database();
        $ilUser = $DIC->user();
        
        if ($a_obj_type == "") {
            $a_obj_type = ilObject::_lookupType($a_obj_id);
        }
        
        if (is_array($a_info_params)) {
            foreach ($a_info_params as $key => $param) {
                $a_info_params[$key] = str_replace(",", ",", $param);
            }
            $a_info_params = implode(",", $a_info_params);
        }
        
        // get last entry of object
        $last_entry_sql = "SELECT * FROM history WHERE " .
            " obj_id = " . $ilDB->quote($a_obj_id, "integer") . " AND " .
            " obj_type = " . $ilDB->quote($a_obj_type, "text") . " ORDER BY hdate DESC";
        $last_entry_set = $ilDB->query($last_entry_sql);
        $last_entry = $ilDB->fetchAssoc($last_entry_set);
        
        // note: insert is forced if last entry already has a comment and a
        // new comment is given too OR
        // if entry should not be updated OR
        // if current action or user id are not equal with last entry
        if (($a_user_comment != "" && $last_entry["user_comment"] != "")
            || !$a_update_last || $a_action != $last_entry["action"]
            || $ilUser->getId() != $last_entry["usr_id"]) {
            $id = $ilDB->nextId("history");
            $ilDB->insert("history", array(
                "id" => array("integer", $id),
                "obj_id" => array("integer", $a_obj_id),
                "obj_type" => array("text", $a_obj_type),
                "action" => array("text", $a_action),
                "hdate" => array("timestamp", ilUtil::now()),
                "usr_id" => array("integer", $ilUser->getId()),
                "info_params" => array("text", $a_info_params),
                "user_comment" => array("clob", $a_user_comment)
                ));
                
        /*$query = "INSERT INTO history (id, obj_id, obj_type, action, hdate, usr_id, info_params, user_comment) VALUES ".
            "(".
            $ilDB->quote($id).", ".
            $ilDB->quote($a_obj_id).", ".
            $ilDB->quote($a_obj_type).", ".
            $ilDB->quote($a_action).", ".
            "now(), ".
            $ilDB->quote($ilUser->getId()).", ".
            $ilDB->quote($a_info_params).", ".
            $ilDB->quote($a_user_comment).
            ")";
        $ilDB->query($query);*/
        } else {
            // if entry should be updated, update user comment only
            // if it is set (this means, user comment has been empty
            // because if old and new comment are given, an INSERT is forced
            // see if statement above)
            //$uc_str = ($a_user_comment != "")
            //  ? ", user_comment = ".$ilDB->quote($a_user_comment)
            //  : "";
            /*$query = "UPDATE history SET ".
                " hdate = now() ".
                $uc_str.
                " WHERE id = ".$ilDB->quote($last_entry["id"]);
            $ilDB->query($query);*/
            
            $fields = array(
                "hdate" => array("timestamp", ilUtil::now())
                );
            if ($a_user_comment != "") {
                $fields["user_comment"] = array("clob", $a_user_comment);
            }
 
            $ilDB->update("history", $fields, array(
                "id" => array("integer", $id)
                ));
        }
    }

References $DIC, $id, $ilDB, $ilUser, $key, ilObject\_lookupType(), and ilUtil\now().

Referenced by ilLinkResourceItems\add(), ilPageEditorGUI\addChangeComment(), ilObjFile\addFileVersion(), ilObjContentObjectGUI\confirmedDelete(), ilLMObject\create(), ilObjFileDAV\createNewVersion(), ilObjFile\createProperties(), ilLinkResourceItems\delete(), ilObjContentObject\executeDragDrop(), ilObjFile\replaceFile(), ilObjFile\rollback(), ilLinkResourceItems\update(), ilFileXMLParser\updateFileContents(), and ilLMPageObjectGUI\updateHistory().

Here is the call graph for this function:

Here is the caller graph for this function:

_getEntriesForObject()

static ilHistory::_getEntriesForObject (   $a_obj_id,   $a_obj_type = ""  )

static

get all history entries for an object

Parameters

int

$a_obj_id

object id

Returns

array array of history entries (arrays with keys "date", "user_id", "obj_id", "action", "info_params")

Definition at line 128 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if ($a_obj_type == "") {
            $a_obj_type = ilObject::_lookupType($a_obj_id);
        }
        
        $query = "SELECT * FROM history WHERE obj_id = " .
            $ilDB->quote($a_obj_id, "integer") . " AND " .
            "obj_type = " . $ilDB->quote($a_obj_type, "text") .
            " ORDER BY hdate DESC";
 
        $hist_set = $ilDB->query($query);
 
        $hist_items = array();
        while ($hist_rec = $ilDB->fetchAssoc($hist_set)) {
            $hist_items[] = array("date" => $hist_rec["hdate"],
                "user_id" => $hist_rec["usr_id"],
                "obj_id" => $hist_rec["obj_id"],
                "obj_type" => $hist_rec["obj_type"],
                "action" => $hist_rec["action"],
                "info_params" => $hist_rec["info_params"],
                "user_comment" => $hist_rec["user_comment"],
                "hist_entry_id" => $hist_rec["id"],
                "title" => $hist_rec["title"]);
        }
 
        if ($a_obj_type == "lm") {
            $query = "SELECT h.*, l.title as title FROM history h, lm_data l WHERE " .
                " l.lm_id = " . $ilDB->quote($a_obj_id, "integer") . " AND " .
                " l.obj_id = h.obj_id AND " .
                " (h.obj_type=" . $ilDB->quote($a_obj_type . ":pg", "text") . " OR h.obj_type=" . $ilDB->quote($a_obj_type . ":st", "text") . ") " .
                " ORDER BY h.hdate DESC";
                
            $hist_set = $ilDB->query($query);
            while ($hist_rec = $ilDB->fetchAssoc($hist_set)) {
                $hist_items[] = array("date" => $hist_rec["hdate"],
                    "user_id" => $hist_rec["usr_id"],
                    "obj_id" => $hist_rec["obj_id"],
                    "obj_type" => $hist_rec["obj_type"],
                    "action" => $hist_rec["action"],
                    "info_params" => $hist_rec["info_params"],
                    "user_comment" => $hist_rec["user_comment"],
                    "hist_entry_id" => $hist_rec["id"],
                    "title" => $hist_rec["title"]);
            }
            usort($hist_items, array("ilHistory", "_compareHistArray"));
            $hist_items2 = array_reverse($hist_items);
            return $hist_items2;
        }
 
        return $hist_items;
    }

References $DIC, $ilDB, $query, and ilObject\_lookupType().

Referenced by ilECSFileSettings\buildJson(), ilHistoryTableGUI\getDataFromDb(), ilObjFile\getVersions(), ilObjFile\rollback(), and ilFileXMLWriter\start().

Here is the call graph for this function:

Here is the caller graph for this function:

_getEntryByHistoryID()

static ilHistory::_getEntryByHistoryID (   $a_hist_entry_id )

static

returns a single history entry

Definition at line 266 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $q = "SELECT * FROM history WHERE id = " .
            $ilDB->quote($a_hist_entry_id, "integer");
        $r = $ilDB->query($q);
        
        return $ilDB->fetchAssoc($r);
    }

References $DIC, $ilDB, and $r.

Referenced by ilObjFile\determineFileSize(), ilObjFile\getFile(), and ilObjFile\getSpecificVersion().

Here is the caller graph for this function:

_removeEntriesForObject()

static ilHistory::_removeEntriesForObject (   $a_obj_id )

static

remove all history entries for an object

Parameters

int

$a_obj_id

object id

Returns

boolean

Definition at line 200 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $q = "DELETE FROM history WHERE obj_id = " .
            $ilDB->quote($a_obj_id, "integer");
        $r = $ilDB->manipulate($q);
        
        return true;
    }

References $DIC, $ilDB, and $r.

Referenced by ilObjFile\deleteVersions(), ilObjBibliographic\doDelete(), and ilObjFile\doDelete().

Here is the caller graph for this function:

_removeEntryByHistoryID()

static ilHistory::_removeEntryByHistoryID (   $a_hist_entry_id )

static

Removes a single entry from the history.

Parameters

int

$a_hist_entry_id

The id of the entry to remove.

Definition at line 284 of file class.ilHistory.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $q = "DELETE FROM history WHERE id = " .
            $ilDB->quote($a_hist_entry_id, "integer");
        $ilDB->manipulate($q);
    }

References $DIC, and $ilDB.

Referenced by ilObjFile\deleteVersions().

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• Services/History/classes/class.ilHistory.php