TreeDBRepo.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
namespace ILIAS\Repository\Deletion;
 
use ilDBInterface;
 
class TreeDBRepo
{
    public function __construct(
        protected ilDBInterface $db
    ) {
    }
 
    public function getTrashedSubtrees(int $ref_id): array
    {
        $db = $this->db;
 
        // this queries for trash items in the trash of deleted nodes
        $q = 'SELECT tree FROM tree WHERE parent = ' . $db->quote($ref_id, \ilDBConstants::T_INTEGER) .
            ' AND tree < 0 ' .
            ' AND tree = -1 * child';
 
        $r = $db->query($q);
 
        $tree_ids = [];
        while ($row = $db->fetchObject($r)) {
            $tree_ids = (int) $row->tree;
        }
        return $tree_ids;
    }
 
}