PiouPiou\RibsAdminBundle\Repository\NavigationRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	findAllNavigationPage()	0	10	1
A	findAllNavigation()	0	11	1

<?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.

    }
}