ilFavouritesDBRepository Class Reference

Collaboration diagram for ilFavouritesDBRepository:

Public Member Functions
	__construct (\ilDBInterface $db=null, ilTree $tree=null)
	Constructor. More...
	add (int $user_id, int $ref_id)
	Add favourite. More...
	remove (int $user_id, int $ref_id)
	Remove favourite. More...
	getFavouritesOfUser (int $user_id, array $a_types=null)
	Get all desktop items of user and specified type. More...
	ifIsFavourite ($user_id, $ref_id)
	check wether an item is on the users desktop or not More...
	loadData (int $user_id, array $ref_ids)
	Load favourites data. More...
	removeFavouritesOfRefId (int $ref_id)
	Remove favourite entries of a repository item. More...
	removeFavouritesOfUser (int $user_id)
	Remove favourite entries of a user. More...

Static Public Attributes
static	$is_desktop_item = []

Detailed Description

Author

killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Constructor & Destructor Documentation

__construct()

ilFavouritesDBRepository::__construct	(	\ilDBInterface	$db = null,
		ilTree	$tree = null
	)

Constructor.

Definition at line 21 of file class.ilFavouritesDBRepository.php.

    {
        global $DIC;
 
        $this->db = (is_null($db))
            ? $DIC->database()
            : $db;
        $this->tree = (is_null($tree))
            ? $DIC->repositoryTree()
            : $tree;
    }

References $DIC.

Member Function Documentation

add()

ilFavouritesDBRepository::add	(	int	$user_id,
		int	$ref_id
	)

Add favourite.

Parameters

int	$user_id
int	$ref_id

Definition at line 39 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
 
        $type = ilObject::_lookupType($ref_id, true);
 
        $item_set = $db->queryF(
            "SELECT * FROM desktop_item WHERE " .
            "item_id = %s AND type = %s AND user_id = %s",
            ["integer", "text", "integer"],
            [$ref_id, $type, $user_id]
        );
 
        // only insert if item is not already on desktop
        if (!$db->fetchAssoc($item_set)) {
            $db->manipulateF(
                "INSERT INTO desktop_item (item_id, type, user_id, parameters) VALUES " .
                " (%s,%s,%s,%s)",
                array("integer", "text", "integer", "text"),
                array($ref_id,$type,$user_id,"")
            );
        }
    }

References $type, and ilObject\_lookupType().

Here is the call graph for this function:

getFavouritesOfUser()

ilFavouritesDBRepository::getFavouritesOfUser	(	int	$user_id,
		array	$a_types = null
	)

Get all desktop items of user and specified type.

note: the implementation of this method is not good style (directly reading tables object_data and object_reference), must be revised someday...

Parameters

int	$user_id
array | null	$a_types

Returns

array

Definition at line 91 of file class.ilFavouritesDBRepository.php.

                                                                             : array
    {
        $tree = $this->tree;
        $ilDB = $this->db;
 
        if (is_null($a_types)) {
            $item_set = $ilDB->queryF("SELECT obj.obj_id, obj.description, oref.ref_id, obj.title, obj.type " .
                " FROM desktop_item it, object_reference oref " .
                ", object_data obj" .
                " WHERE " .
                "it.item_id = oref.ref_id AND " .
                "oref.obj_id = obj.obj_id AND " .
                "it.user_id = %s", array("integer"), array($user_id));
            $items = $all_parent_path = array();
            while ($item_rec = $ilDB->fetchAssoc($item_set)) {
                if ($tree->isInTree($item_rec["ref_id"])
                    && $item_rec["type"] != "rolf"
                    && $item_rec["type"] != "itgr") {   // due to bug 11508
                    $parent_ref = $tree->getParentId($item_rec["ref_id"]);
 
                    if (!isset($all_parent_path[$parent_ref])) {
                        if ($parent_ref > 0) {  // workaround for #0023176
                            $node = $tree->getNodeData($parent_ref);
                            $all_parent_path[$parent_ref] = $node["title"];
                        } else {
                            $all_parent_path[$parent_ref] = "";
                        }
                    }
 
                    $parent_path = $all_parent_path[$parent_ref];
 
                    $title = ilObject::_lookupTitle($item_rec["obj_id"]);
                    $desc = ilObject::_lookupDescription($item_rec["obj_id"]);
                    $items[$parent_path . $title . $item_rec["ref_id"]] =
                        array("ref_id" => $item_rec["ref_id"],
                            "obj_id" => $item_rec["obj_id"],
                            "type" => $item_rec["type"],
                            "title" => $title,
                            "description" => $desc,
                            "parent_ref" => $parent_ref);
                }
            }
            ksort($items);
        } else {
            $items = array();
            foreach ($a_types as $a_type) {
                if ($a_type == "itgr") {
                    continue;
                }
                $item_set = $ilDB->queryF(
                    "SELECT obj.obj_id, obj.description, oref.ref_id, obj.title FROM desktop_item it, object_reference oref " .
                    ", object_data obj WHERE " .
                    "it.item_id = oref.ref_id AND " .
                    "oref.obj_id = obj.obj_id AND " .
                    "it.type = %s AND " .
                    "it.user_id = %s " .
                    "ORDER BY title",
                    array("text", "integer"),
                    array($a_type, $user_id)
                );
 
                while ($item_rec = $ilDB->fetchAssoc($item_set)) {
                    $title = ilObject::_lookupTitle($item_rec["obj_id"]);
                    $desc = ilObject::_lookupDescription($item_rec["obj_id"]);
                    $items[$title . $a_type . $item_rec["ref_id"]] =
                        array("ref_id" => $item_rec["ref_id"],
                            "obj_id" => $item_rec["obj_id"], "type" => $a_type,
                            "title" => $title, "description" => $desc);
                }
            }
            ksort($items);
        }
        return $items;
    }

References $a_type, $ilDB, ilObject\_lookupDescription(), and ilObject\_lookupTitle().

Here is the call graph for this function:

ifIsFavourite()

ilFavouritesDBRepository::ifIsFavourite	(		$user_id,
			$ref_id
	)

check wether an item is on the users desktop or not

Parameters

$user_id
$ref_id

Returns

bool

Definition at line 172 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
 
        if (!isset(self::$is_desktop_item[$user_id . ":" . $ref_id])) {
            $item_set = $db->queryF(
                "SELECT item_id FROM desktop_item WHERE " .
                "item_id = %s AND user_id = %s",
                array("integer", "integer"),
                array($ref_id, $user_id)
            );
 
            if ($db->fetchAssoc($item_set)) {
                self::$is_desktop_item[$user_id . ":" . $ref_id] = true;
            } else {
                self::$is_desktop_item[$user_id . ":" . $ref_id] = false;
            }
        }
        return self::$is_desktop_item[$user_id . ":" . $ref_id];
    }

loadData()

ilFavouritesDBRepository::loadData	(	int	$user_id,
		array	$ref_ids
	)

Load favourites data.

Parameters

int	$user_id
array	$ref_ids

Definition at line 198 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
        if (!is_array($ref_ids)) {
            return;
        }
 
        $load_ref_ids = [];
        foreach ($ref_ids as $ref_id) {
            if (!isset(self::$is_desktop_item[$user_id . ":" . $ref_id])) {
                $load_ref_ids[] = $ref_id;
            }
        }
 
        if (count($load_ref_ids) > 0) {
            $item_set = $db->query("SELECT item_id FROM desktop_item WHERE " .
                $db->in("item_id", $load_ref_ids, false, "integer") .
                " AND user_id = " . $db->quote($user_id, "integer"));
            while ($r = $db->fetchAssoc($item_set)) {
                self::$is_desktop_item[$user_id . ":" . $r["item_id"]] = true;
            }
            foreach ($load_ref_ids as $ref_id) {
                if (!isset(self::$is_desktop_item[$user_id . ":" . $ref_id])) {
                    self::$is_desktop_item[$user_id . ":" . $ref_id] = false;
                }
            }
        }
    }

remove()

ilFavouritesDBRepository::remove	(	int	$user_id,
		int	$ref_id
	)

Remove favourite.

Parameters

int	$user_id
int	$ref_id

Definition at line 69 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM desktop_item WHERE " .
            " item_id = %s AND user_id = %s",
            array("integer", "integer"),
            array($ref_id, $user_id)
        );
    }

removeFavouritesOfRefId()

ilFavouritesDBRepository::removeFavouritesOfRefId

(

int

$ref_id

)

Remove favourite entries of a repository item.

Parameters

int

$ref_id

Definition at line 232 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM desktop_item WHERE " .
            " item_id = %s",
            ["integer"],
            [$ref_id]
        );
    }

removeFavouritesOfUser()

ilFavouritesDBRepository::removeFavouritesOfUser

(

int

$user_id

)

Remove favourite entries of a user.

Parameters

int

$user_id

Definition at line 249 of file class.ilFavouritesDBRepository.php.

    {
        $db = $this->db;
 
        $db->manipulateF(
            "DELETE FROM desktop_item WHERE " .
            " user_id = %s",
            ["integer"],
            [$user_id]
        );
    }

Field Documentation

$is_desktop_item

ilFavouritesDBRepository::$is_desktop_item = []

static

Definition at line 16 of file class.ilFavouritesDBRepository.php.

---

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

• Services/Repository/Favourites/classes/class.ilFavouritesDBRepository.php