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

}