Piou-piou / RibsAdminBundle

Repository/NavigationRepository.php

<?php

namespace PiouPiou\RibsAdminBundle\Repository;

use Doctrine\DBAL\DBALException;
use Doctrine\ORM\EntityRepository;

class NavigationRepository extends EntityRepository
{
    /**
     * function that return all navigation links of pages and modules
     * @return array
     * @throws DBALException
     */
    public function findAllNavigation(): array
    {
        $query = $this->getEntityManager()->getConnection()->prepare("SELECT p.url, p.title, p.title_tag FROM navigation n
			LEFT JOIN page p ON n.id_page = p.id AND p.displayed = 1
			LEFT JOIN module m ON n.id_module = m.id AND m.displayed = 1
		  	ORDER BY n.order ASC
 		");

        $query->execute();

        return $query->fetchAll(\PDO::FETCH_ASSOC);

The function Doctrine\DBAL\Statement::fetchAll() has been deprecated: Use fetchAllNumeric(), fetchAllAssociative() or fetchFirstColumn() instead.

    }

    /**
     * function that return all navigation links of pages
     * @return array
     * @throws DBALException
     */
    public function findAllNavigationPage(): array
    {
        $query = $this->getEntityManager()->getConnection()->prepare("SELECT p.id, p.url, p.title, p.title_tag FROM navigation n
			INNER JOIN page p ON n.id_page = p.id AND p.displayed = 1
		  	ORDER BY n.order ASC
 		");

        $query->execute();

        return $query->fetchAll(\PDO::FETCH_ASSOC);

The function Doctrine\DBAL\Statement::fetchAll() has been deprecated: Use fetchAllNumeric(), fetchAllAssociative() or fetchFirstColumn() instead.

    }
}