Collaboration diagram for ilTreeTrashQueries:

Public Member Functions
	__construct ()
	ilTreeTrash constructor. More...

	isTrashedTrash (array $ref_ids)

	findRepositoryLocationForDeletedNode (int $deleted_node)

	getTrashedNodeTypesForContainer (int $ref_id)

	getNumberOfTrashedNodesForTrashedContainer (int $ref_id)

	getTrashNodeForContainer (int $ref_id, array $filter, int &$max_entries, string $order_field, string $order_direction, int $limit=self::QUERY_LIMIT, int $offset=0)
	Get trashed nodes. More...

	getTrashedNodesForContainerUsingRecursion (int $ref_id)
	Unfortunately not supported by mysql 5. More...

Protected Member Functions
	appendTrashNodeForContainerQueryFilter (array $filter)

Protected Attributes
const	QUERY_LIMIT = 10

Private Attributes
	$ref_id = 0

	$tree = null

	$logger

	$db

Detailed Description

Author: Stefan Meyer meyer.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Definition at line 12 of file class.ilTreeTrashQueries.php.

Constructor & Destructor Documentation

◆ __construct()

ilTreeTrashQueries::__construct ( )

ilTreeTrash constructor.

Parameters

int $ref_id

Definition at line 38 of file class.ilTreeTrashQueries.php.

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

References $DIC.

Member Function Documentation

◆ appendTrashNodeForContainerQueryFilter()

ilTreeTrashQueries::appendTrashNodeForContainerQueryFilter ( array $filter )

protected

Parameters

array $filter

Returns: string

Definition at line 228 of file class.ilTreeTrashQueries.php.

                                                                             : string
    {
        $query = '';
        if (isset($filter['type'])) {
            $query .= 'and ' . $this->db->like(
                'type',
                \ilDBConstants::T_TEXT,
                $filter['type'] . '%'
                ) . ' ';
        }
        if (isset($filter['title'])) {
            $query .= 'and ' . $this->db->like(
                'title',
                \ilDBConstants::T_TEXT,
                '%' . $filter['title'] . '%'
                ) . ' ';
        }
        if (
            $filter['deleted']['from'] instanceof \ilDate &&
            $filter['deleted']['to'] instanceof  \ilDate) {
            $query .= ('and deleted between ' .
                $this->db->quote($filter['deleted']['from']->get(\IL_CAL_DATE), \ilDBConstants::T_TEXT) . ' and ' .
                $this->db->quote($filter['deleted']['to']->get(IL_CAL_DATE), \ilDBConstants::T_TEXT) . ' ');
        } elseif ($filter['deleted']['from'] instanceof \ilDate) {
            $query .= 'and deleted >= ' . $this->db->quote($filter['deleted']['from']->get(IL_CAL_DATE), \ilDBConstants::T_TEXT) . ' ';
        } elseif ($filter['deleted']['to'] instanceof \ilDate) {
            $query .= 'and deleted <= ' . $this->db->quote($filter['deleted']['to']->get(IL_CAL_DATE), \ilDBConstants::T_TEXT) . ' ';
        }
 
        if (isset($filter['deleted_by']) && !empty($filter['deleted_by'])) {
            $usr_id = \ilObjUser::_lookupId($filter['deleted_by']);
            if ($usr_id > 0) {
                $query .= 'and deleted_by = ' . $this->db->quote($usr_id, \ilDBConstants::T_INTEGER) . ' ';
            }
        }
 
        return $query;
    }

References $query, ilObjUser\_lookupId(), IL_CAL_DATE, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by getTrashNodeForContainer().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ findRepositoryLocationForDeletedNode()

ilTreeTrashQueries::findRepositoryLocationForDeletedNode ( int $deleted_node )

Parameters

int $deleted_node

Returns: $rep_ref_id

Exceptions

ilRepositoryException

Definition at line 79 of file class.ilTreeTrashQueries.php.

    {
        $query = 'select parent from tree ' .
            'where child = ' . $this->db->quote($deleted_node, \ilDBConstants::T_INTEGER) . ' ' .
            'and tree = ' . $this->db->quote($deleted_node * -1, \ilDBConstants::T_INTEGER);
        $this->logger->info($query);
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->parent;
        }
        $this->logger->warning('Invalid node given for restoring to original location: deleted node id: ' . $deleted_node);
        throw new \ilRepositoryException('Invalid node given for restoring to original location');
    }

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ilDBConstants\T_INTEGER.

◆ getNumberOfTrashedNodesForTrashedContainer()

ilTreeTrashQueries::getNumberOfTrashedNodesForTrashedContainer ( int $ref_id )

Parameters

int $ref_id

Returns: int

Definition at line 121 of file class.ilTreeTrashQueries.php.

    {
        $res = $this->db->query($this->tree->getTrashSubTreeQuery($ref_id, ['child']));
        return (int) $res->numRows();
    }

References $ref_id, and $res.

◆ getTrashedNodesForContainerUsingRecursion()

ilTreeTrashQueries::getTrashedNodesForContainerUsingRecursion ( int $ref_id )

Unfortunately not supported by mysql 5.

Parameters

int $ref_id

Definition at line 205 of file class.ilTreeTrashQueries.php.

    {
        $query = 'with recursive trash (child,tree) as ' .
            '( select child, tree from tree where child = ' . $this->db->quote($ref_id, \ilDBConstants::T_INTEGER) . ' ' .
            'union select tc.child,tc.tree from tree tc join tree tp on tp.child = tc.parent ) ' .
            'select * from trash where tree < 1 ';
 
        $trash_ids = [];
 
        try {
            $res = $this->db->query($query);
            while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
                $trash_ids[] = $row->child;
            }
        } catch (\ilDatabaseException $e) {
            $this->logger->warning($query . ' is not supported');
        }
    }

References Vendor\Package\$e, $query, $ref_id, $res, ilDBConstants\FETCHMODE_OBJECT, and ilDBConstants\T_INTEGER.

◆ getTrashedNodeTypesForContainer()

ilTreeTrashQueries::getTrashedNodeTypesForContainer ( int $ref_id )

Parameters

int $ref_id

Returns: string[]

Definition at line 97 of file class.ilTreeTrashQueries.php.

    {
        $subtreequery = $this->tree->getTrashSubTreeQuery($ref_id, ['child']);
 
        $query = 'select distinct(type) obj_type from object_data obd ' .
            'join object_reference obr on obd.obj_id = obr.obj_id ' .
            'where ref_id in (' .
            $subtreequery . ' ' .
            ') ';
 
        $this->logger->dump($query);
 
        $res = $this->db->query($query);
        $obj_types = [];
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            $obj_types[] = $row->obj_type;
        }
        return $obj_types;
    }

References $query, $ref_id, $res, and ilDBConstants\FETCHMODE_OBJECT.

◆ getTrashNodeForContainer()

ilTreeTrashQueries::getTrashNodeForContainer	(	int	$ref_id,
		array	$filter,
		int &	$max_entries,
		string	$order_field,
		string	$order_direction,
		int	$limit = `self::QUERY_LIMIT`,
		int	$offset = `0`
	)

Get trashed nodes.

Parameters

int	$ref_id
array	$filter
int	$max_entries
string	$order_field
string	$order_direction
int	$limit
int	$offset

Returns: \ilTreeTrashItem[]

Exceptions

ilDatabaseException

Count query

Definition at line 139 of file class.ilTreeTrashQueries.php.

      {
        $subtreequery = $this->tree->getTrashSubTreeQuery($ref_id, ['child']);
 
        $select = 'select ref_id, obd.obj_id, type, title, description, deleted, deleted_by ';
        $select_count = 'select count(ref_id) max_entries ';
 
        $from = 'from object_data obd ' .
            'join object_reference obr on obd.obj_id = obr.obj_id ' .
            'where ref_id in (' .
            $subtreequery . ' ' .
            ') ';
 
        $order = ' ';
        if ($order_field) {
            $order = 'ORDER BY ' . $order_field . ' ' . $order_direction;
        }
 
        $query = $select . $from . $this->appendTrashNodeForContainerQueryFilter($filter) . $order;
        $query_count = $select_count . $from . $this->appendTrashNodeForContainerQueryFilter($filter);
 
 
        $this->logger->dump($query);
 
        $res_max_entries = $this->db->query($query_count);
        while ($max_entries_row = $res_max_entries->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            $max_entries = $max_entries_row->max_entries;
        }
 
        $this->db->setLimit($limit, $offset);
        $res = $this->db->query($query);
 
 
        $items = [];
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            $item = new \ilTreeTrashItem();
            $item->setObjId($row->obj_id);
            $item->setRefId($row->ref_id);
            $item->setTitle($row->title);
            $item->setDescription($row->description);
            $item->setType($row->type);
            $item->setDeleted($row->deleted);
            $item->setDeletedBy($row->deleted_by);
 
            $items[] = $item;
        }
        return $items;
    }

References $query, $ref_id, $res, appendTrashNodeForContainerQueryFilter(), and ilDBConstants\FETCHMODE_OBJECT.

Here is the call graph for this function:

◆ isTrashedTrash()

ilTreeTrashQueries::isTrashedTrash ( array $ref_ids )

Parameters

array $ref_ids

Returns: bool

Definition at line 53 of file class.ilTreeTrashQueries.php.

    {
        global $DIC;
 
        $tree = $DIC->repositoryTree();
 
        $query = 'select tree,child,parent from tree ' .
            'where ' . $this->db->in('child', $ref_ids, false, \ilDBConstants::T_INTEGER);
        $res = $this->db->query($query);
        $trashed_trash = false;
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            if ((int) $row->child != ((int) $row->tree * -1)) {
                $trashed_trash = true;
            }
            if ($tree->isDeleted($row->parent)) {
                $trashed_trash = true;
            }
        }
        return $trashed_trash;
    }