ilHistory Class Reference

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

Collaboration diagram for ilHistory:

Public Member Functions
	_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.
	_getEntriesForObject ($a_obj_id, $a_obj_type="")
	get all history entries for an object
	_compareHistArray ($a, $b)
	_removeEntriesForObject ($a_obj_id)
	remove all history entries for an object
	_copyEntriesForObject ($a_src_id, $a_dst_id)
	copy all history entries for an object
	_getEntryByHistoryID ($a_hist_entry_id)
	returns a single history entry

Static Public Member Functions
static	_removeEntryByHistoryID ($a_hist_entry_id)
	Removes a single entry from the history.
static	_changeUserId ($a_hist_entry_id, $new_user_id)
	Changes the user id of the specified history entry.

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:

class.ilHistory.php 54623 2014-10-28 14:30:56Z fwolf

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

Member Function Documentation

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 298 of file class.ilHistory.php.

References $ilDB.

Referenced by ilObjFile\rollback().

        {
                global $ilDB;

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

Here is the caller graph for this function:

ilHistory::_compareHistArray	(		$a,
			$b
	)

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

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

ilHistory::_copyEntriesForObject	(		$a_src_id,
			$a_dst_id
	)

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 222 of file class.ilHistory.php.

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

Referenced by ilObjFile\doCloneObject().

        {
                global $ilDB;

                $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;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilHistory::_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.

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.

References $ilDB, $ilUser, 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().

        {
                global $ilDB, $ilUser;
                
                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)
                                ));

                }
                
        }

Here is the call graph for this function:

Here is the caller graph for this function:

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

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 129 of file class.ilHistory.php.

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

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

        {
                global $ilDB;

                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" || $a_obj_type == "dbk")
                {
                        $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;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

ilHistory::_getEntryByHistoryID

(

$a_hist_entry_id

)

returns a single history entry

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

References $ilDB.

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

        {
                global $ilDB;

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

Here is the caller graph for this function:

ilHistory::_removeEntriesForObject

(

$a_obj_id

)

remove all history entries for an object

Parameters

int

$a_obj_id

object id

Returns

boolean

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

References $ilDB.

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

        {
                global $ilDB;

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

Here is the caller graph for this function:

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 283 of file class.ilHistory.php.

References $ilDB.

Referenced by ilObjFile\deleteVersions().

        {
                global $ilDB;

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

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