| public fetchParent ( $table, $id ) : mixed | ||
| $table | ||
| $id | ||
| return | mixed | |
public function fetchParent($table, $id)
{
$queryBuilder = $this->connection->createQueryBuilder();
$queryBuilder->select('parent.id')->from($table, 'node')->from($table, 'parent')->where('parent.lft < node.lft')->andWhere('parent.rgt > node.rgt')->andWhere('node.id = :nodeid')->orderBy('parent.rgt - parent.lft')->setMaxResults(1);
return $this->connection->fetchColumn($queryBuilder->getSQL(), [':nodeid' => $id], 0);
}