ControleOnline\Controller\GetMenuByPeopleAction

Complexity

Total Complexity

7

Size/Duplication

Total Lines	137
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	getMenuByPeople()	0	51	2
A	__invoke()	0	45	4

<?php

namespace ControleOnline\Controller;

use ControleOnline\Entity\Menu;
use ControleOnline\Entity\People;

The type ControleOnline\Entity\People was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\HttpFoundation\Request;

The type Symfony\Component\HttpFoundation\Request was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\ORM\EntityManagerInterface;

The type Doctrine\ORM\EntityManagerInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use Exception;
use Symfony\Component\HttpFoundation\JsonResponse;

The type Symfony\Component\HttpFoundation\JsonResponse was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\Security\Core\Security;

The type Symfony\Component\Security\Core\Security was not found. Maybe you did not declare it correctly or list all dependencies?

use ControleOnline\Repository\MenuRepository;

The type ControleOnline\Repository\MenuRepository was not found. Maybe you did not declare it correctly or list all dependencies?

class GetMenuByPeopleAction
{
  /**
   * Entity Manager
   *
   * @var EntityManagerInterface
   */
  private $manager = null;

  /**
   * Request
   *
   * @var Request
   */
  private $request  = null;

The private property $request is not used, and could be removed.

  /**
   * Security
   *
   * @var Security
   */
  private $security = null;

  /**
   * @var \ControleOnline\Repository\MenuRepository
   */
  private $repository = null;


  public function __construct(Security $security, EntityManagerInterface $entityManager)
  {
    $this->manager    = $entityManager;
    $this->security   = $security;
    $this->repository = $this->manager->getRepository(\ControleOnline\Entity\Menu::class);
  }

  public function __invoke(Request $request): JsonResponse
  {
    try {

      $menu  = [];

The assignment to $menu is dead and can be removed.

      $company = $request->query->get('myCompany', null);

      if ($company === null)
        throw new Exception("Company not found", 404);


      $myCompany = $this->manager->getRepository(People::class)
        ->find($company);

      if ($myCompany === null)
        throw new Exception("Company not found", 404);



      $currentUser = $this->security->getUser();
      /**
       * @var People
       */
      $userPeople = $currentUser->getPeople();

      $menu =  $this->getMenuByPeople($userPeople, $myCompany);


      return new JsonResponse([
        'response' => [
          'data'    => $menu,
          'count'   => 1,
          'error'   => '',
          'success' => true,
        ],
      ]);
    } catch (\Exception $e) {

      return new JsonResponse([
        'response' => [
          'data'    => [],
          'count'   => 0,
          'error'   => $e->getMessage(),
          'success' => false,
        ],
      ]);
    }
  }

  private function getMenuByPeople(People $userPeople, People $myCompany)
  {

    $return = [];
    $connection = $this->manager->getConnection();

    // build query

    $sql  = 'SELECT menu.*,
            category.name AS category_label,
            category.color AS category_color,
            routes.route AS route,
            category.icon AS category_icon FROM menu             
             INNER JOIN category ON category.id = menu.category_id
             INNER JOIN menu_role ON menu.id = menu_role.menu_id
             INNER JOIN people_role ON people_role.role_id = menu_role.role_id    
             INNER JOIN routes ON routes.id = menu.route_id
             WHERE people_role.company_id=:myCompany AND people_role.people_id=:userPeople    
             GROUP BY menu.id
             ';


    $params = [];

    $params['myCompany']   = $myCompany->getId();
    $params['userPeople']   = $userPeople->getId();
    // execute query

    $statement = $connection->prepare($sql);
    $statement->execute($params);

    $result = $statement->fetchAll();

    foreach ($result as $menu) {

      $return['modules'][$menu['category_id']]['id'] = $menu['category_id'];
      $return['modules'][$menu['category_id']]['label'] = $menu['category_label'];
      $return['modules'][$menu['category_id']]['color'] = $menu['category_color'];
      $return['modules'][$menu['category_id']]['icon'] = $menu['category_icon'];
      $return['modules'][$menu['category_id']]['menus'][] = [
        'id' => $menu['id'],
        'label' =>  $menu['menu'],
        'icon' =>  $menu['icon'],
        'color' =>  $menu['color'],
        'route' =>  $menu['route'],
      ];
    }



    return $return;
  }
}