@@ -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 = []; |