@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | * |
| 28 | 28 | * @var Request |
| 29 | 29 | */ |
| 30 | - private $request = null; |
|
| 30 | + private $request = null; |
|
| 31 | 31 | |
| 32 | 32 | /** |
| 33 | 33 | * Security |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | { |
| 54 | 54 | try { |
| 55 | 55 | |
| 56 | - $menu = []; |
|
| 56 | + $menu = []; |
|
| 57 | 57 | |
| 58 | 58 | $company = $request->query->get('myCompany', null); |
| 59 | 59 | |
@@ -75,7 +75,7 @@ discard block |
||
| 75 | 75 | */ |
| 76 | 76 | $userPeople = $currentUser->getPeople(); |
| 77 | 77 | |
| 78 | - $menu = $this->getMenuByPeople($userPeople, $myCompany); |
|
| 78 | + $menu = $this->getMenuByPeople($userPeople, $myCompany); |
|
| 79 | 79 | |
| 80 | 80 | |
| 81 | 81 | return new JsonResponse([ |
@@ -107,7 +107,7 @@ discard block |
||
| 107 | 107 | |
| 108 | 108 | // build query |
| 109 | 109 | |
| 110 | - $sql = 'SELECT menu.*, |
|
| 110 | + $sql = 'SELECT menu.*, |
|
| 111 | 111 | category.name AS category_label, |
| 112 | 112 | category.color AS category_color, |
| 113 | 113 | routes.route AS route, |
@@ -120,7 +120,7 @@ discard block |
||
| 120 | 120 | INNER JOIN people_role ON people_role.role_id = menu_role.role_id |
| 121 | 121 | INNER JOIN routes ON routes.id = menu.route_id '; |
| 122 | 122 | //$sql .= 'WHERE people_role.company_id=:myCompany AND people_role.people_id=:userPeople '; |
| 123 | - $sql .= 'GROUP BY menu.id'; |
|
| 123 | + $sql .= 'GROUP BY menu.id'; |
|
| 124 | 124 | |
| 125 | 125 | |
| 126 | 126 | $params = []; |