NavigationRepository::findAllNavigation() - Code Metrics - Inspection of "[fix] form order of valid and submitted in AccessR..." - Piou-piou/RibsAdminBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( b4cb9f...51bac7 )

by Anthony

created 2018-01-28 18:39 UTC

NavigationRepository::findAllNavigation() A

↳ Parent: NavigationRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	11
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	3
nc	1
nop	0
dl	0
loc	11
rs	9.4285
c	0
b	0
f	0

<?php

namespace PiouPiou\RibsAdminBundle\Repository;

use Doctrine\ORM\EntityRepository;

class NavigationRepository extends EntityRepository
{
	/**
	 * @return array
	 * function that return all navigation links of pages and modules
	 */
	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);
	}
	
	/**
	 * @return array
	 * function that return all navigation links of pages
	 */
	public function findAllNavigationPage(): array
	{
		$query = $this->getEntityManager()->getConnection()->prepare("SELECT 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);
	}
}

1			<?php
2
3			namespace PiouPiou\RibsAdminBundle\Repository;
4
5			use Doctrine\ORM\EntityRepository;
6
7			class NavigationRepository extends EntityRepository
8			{
9			/**
10			* @return array
11			* function that return all navigation links of pages and modules
12			*/
13			public function findAllNavigation(): array
14			{
15			$query = $this->getEntityManager()->getConnection()->prepare("SELECT p.url, p.title, p.title_tag FROM navigation n
16			LEFT JOIN page p ON n.id_page = p.id AND p.displayed = 1
17			LEFT JOIN module m ON n.id_module = m.id AND m.displayed = 1
18			ORDER BY n.order ASC
19			");
20
21			$query->execute();
22
23			return $query->fetchAll(\PDO::FETCH_ASSOC);
24			}
25
26			/**
27			* @return array
28			* function that return all navigation links of pages
29			*/
30			public function findAllNavigationPage(): array
31			{
32			$query = $this->getEntityManager()->getConnection()->prepare("SELECT p.url, p.title, p.title_tag FROM navigation n
33			INNER JOIN page p ON n.id_page = p.id AND p.displayed = 1
34			ORDER BY n.order ASC
35			");
36
37			$query->execute();
38
39			return $query->fetchAll(\PDO::FETCH_ASSOC);
40			}
41			}

Piou-piou / RibsAdminBundle

Push — master ( b4cb9f...51bac7 )

NavigationRepository::findAllNavigation() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like