AccessRightRepository::deleteAllUsersList() - Code Metrics - Inspection of "[func] add displaying block inline mod" - Piou-piou/RibsAdminBundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 31adf1...6657ff )

by Anthony

created 2018-02-04 19:15 UTC

AccessRightRepository::deleteAllUsersList() A

↳ Parent: AccessRightRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

namespace PiouPiou\RibsAdminBundle\Repository;

use Doctrine\ORM\EntityRepository;
use PiouPiou\RibsAdminBundle\Entity\AccessRight;

class AccessRightRepository extends EntityRepository
{
	/**
	 * @param AccessRight $access_right
	 * function that delete all user which are in a list of rights
	 */
	public function deleteAllUsersList(AccessRight $access_right)
	{
		$query = $this->getEntityManager()->getConnection()->prepare("UPDATE user SET id_access_right = NULL WHERE
 			id_access_right = :id_access_right
 		");
		$query->bindValue("id_access_right", $access_right->getId());
		$query->execute();
	}
	
	/**
	 * @param int $access_right_id
	 * @param string $guid_admin
	 * function that add a user in an access right list
	 */
	public function setAccessRightListUser(int $access_right_id, string $guid_admin)
	{
		$query = $this->getEntityManager()->getConnection()->prepare("UPDATE user SET id_access_right = :id_access_right WHERE
 			guid = :guid_user
 		");
		$query->bindValue("id_access_right", $access_right_id, \PDO::PARAM_INT);
		$query->bindValue("guid_user", $guid_admin, \PDO::PARAM_STR);
		$query->execute();
	}
}

1			<?php
2
3			namespace PiouPiou\RibsAdminBundle\Repository;
4
5			use Doctrine\ORM\EntityRepository;
6			use PiouPiou\RibsAdminBundle\Entity\AccessRight;
7
8			class AccessRightRepository extends EntityRepository
9			{
10			/**
11			* @param AccessRight $access_right
12			* function that delete all user which are in a list of rights
13			*/
14			public function deleteAllUsersList(AccessRight $access_right)
15			{
16			$query = $this->getEntityManager()->getConnection()->prepare("UPDATE user SET id_access_right = NULL WHERE
17			id_access_right = :id_access_right
18			");
19			$query->bindValue("id_access_right", $access_right->getId());
20			$query->execute();
21			}
22
23			/**
24			* @param int $access_right_id
25			* @param string $guid_admin
26			* function that add a user in an access right list
27			*/
28			public function setAccessRightListUser(int $access_right_id, string $guid_admin)
29			{
30			$query = $this->getEntityManager()->getConnection()->prepare("UPDATE user SET id_access_right = :id_access_right WHERE
31			guid = :guid_user
32			");
33			$query->bindValue("id_access_right", $access_right_id, \PDO::PARAM_INT);
34			$query->bindValue("guid_user", $guid_admin, \PDO::PARAM_STR);
35			$query->execute();
36			}
37			}

Piou-piou / RibsAdminBundle

Push — master ( 31adf1...6657ff )

AccessRightRepository::deleteAllUsersList() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like