DirectorView.php 44.1 KB
Newer Older
Open Source Developer's avatar
transf  
Open Source Developer committed
1 2 3 4 5 6 7 8 9 10
<?php

namespace Drupal\epal\Controller;

use Drupal\Core\Entity\EntityTypeManagerInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
use Symfony\Component\HttpFoundation\JsonResponse;
use Drupal\Core\Controller\ControllerBase;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
Open Source Developer's avatar
trans  
Open Source Developer committed
11
use Drupal\Core\Logger\LoggerChannelFactoryInterface;
Open Source Developer's avatar
transf  
Open Source Developer committed
12

13 14
use Drupal\epal\Crypt;

Open Source Developer's avatar
transf  
Open Source Developer committed
15 16 17
class DirectorView extends ControllerBase
{
    protected $entityTypeManager;
18
    protected $logger;
Open Source Developer's avatar
trans  
Open Source Developer committed
19
  //  protected $testSchoolId='0640050';
Open Source Developer's avatar
transf  
Open Source Developer committed
20

21 22 23 24
    public function __construct(
        EntityTypeManagerInterface $entityTypeManager,
        LoggerChannelFactoryInterface $loggerChannel
    ) {
25

Open Source Developer's avatar
transf  
Open Source Developer committed
26
        $this->entityTypeManager = $entityTypeManager;
27
        $this->logger = $loggerChannel->get('epal-school');
Open Source Developer's avatar
transf  
Open Source Developer committed
28 29 30 31 32
    }

    public static function create(ContainerInterface $container)
    {
        return new static(
33 34
            $container->get('entity_type.manager'),
            $container->get('logger.factory')
Open Source Developer's avatar
transf  
Open Source Developer committed
35
        );
36
    }
Open Source Developer's avatar
transf  
Open Source Developer committed
37

38 39


Open Source Developer's avatar
Open Source Developer committed
40
    public function getStudentPerSchool(Request $request, $classId, $sector, $specialit)
Open Source Developer's avatar
trans  
Open Source Developer committed
41
    {
42
        try {
43

44
            $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
Open Source Developer committed
45

46 47 48 49 50 51 52 53 54 55 56
            $epalConfigs = $this->entityTypeManager->getStorage('epal_config')->loadByProperties(array('name' => 'epal_config'));
            $epalConfig = reset($epalConfigs);
            if (!$epalConfig) {
                return $this->respondWithStatus([
                        "error_code" => 3001
                    ], Response::HTTP_FORBIDDEN);
            }
            if ($epalConfig->lock_students->value) {
                return $this->respondWithStatus([
                        "error_code" => 3002
                    ], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
Open Source Developer committed
57 58
            }

59 60 61 62 63 64 65 66 67 68 69
            $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
            $user = reset($users);
            if ($user) {
                $epalId = $user->init->value;
                $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $epalId));
                $school = reset($schools);
                if (!$school) {
                    $this->logger->warning('no access to this school='.$user->id());
                    return $this->respondWithStatus([
                        "message" => "No access to this school"
                    ], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
Open Source Developer committed
70
                }
71

Open Source Developer's avatar
Open Source Developer committed
72

Open Source Developer's avatar
Open Source Developer committed
73 74 75 76 77 78 79
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole)
            {
                if ($tmpRole === 'epal')
                {
                    $userRole = $tmpRole;
80
                }
Open Source Developer's avatar
Open Source Developer committed
81
            }
82
            if ($userRole === '')
Open Source Developer's avatar
Open Source Developer committed
83 84 85 86 87 88 89 90
            {
                return $this->respondWithStatus([
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
            }
            elseif ($userRole === 'epal')
            {
                    $selectIdNew = $selectId;
91
                    if ($classId == 1)
Open Source Developer's avatar
Open Source Developer committed
92 93 94 95 96
                        $selectIdNew = -1;
                    elseif ($classId == 2)
                        $selectIdNew = $sector;
                    else
                        $selectIdNew = $specialit;
Open Source Developer's avatar
bug  
Open Source Developer committed
97
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $epalId, 'specialization_id' => $selectIdNew, 'currentclass' => $classId));
Open Source Developer's avatar
Open Source Developer committed
98 99 100 101 102 103 104
            }
            $i = 0;
            if ($studentPerSchool)
            {
                $list = array();
                foreach ($studentPerSchool as $object)
                {
Open Source Developer's avatar
bug  
Open Source Developer committed
105
                            $studentId = intval($object->student_id ->getString());
Open Source Developer's avatar
Open Source Developer committed
106 107
                            $epalStudents = $this->entityTypeManager->getStorage('epal_student')->loadByProperties(array('id' => $studentId));
                            $epalStudent = reset($epalStudents);
108
                            if ($epalStudents)
Open Source Developer's avatar
Open Source Developer committed
109
                            {
110 111 112
                                    $studentIdNew = $epalStudent->id();
                                    $checkstatus = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('student_id' => $studentIdNew));
                                    $checkstudentstatus = reset($checkstatus);
Open Source Developer's avatar
Open Source Developer committed
113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
                                    $sectorName = '';
                                    $courseName = '';
                                    if ($epalStudent->currentclass->value === '2') {
                                        $sectors = $this->entityTypeManager->getStorage('epal_student_sector_field')->loadByProperties(array('student_id' => $studentIdNew));
                                        $sector = reset($sectors);
                                        if ($sector)
                                            $sectorName = $this->entityTypeManager->getStorage('eepal_sectors')->load($sector->sectorfield_id->target_id)->name->value;
                                    }
                                    else if ($epalStudent->currentclass->value === '3' || $epalStudent->currentclass->value === '4') {
                                        $courses = $this->entityTypeManager->getStorage('epal_student_course_field')->loadByProperties(array('student_id' => $studentIdNew));
                                        $course = reset($courses);
                                        if ($course)
                                            $courseName = $this->entityTypeManager->getStorage('eepal_specialty')->load($course->coursefield_id->target_id)->name->value;
                                    }

128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144

                                        $crypt = new Crypt();
                                        try {
                                            $name_decoded = $crypt->decrypt($epalStudent->name->value);
                                            $studentsurname_decoded = $crypt->decrypt($epalStudent->studentsurname->value);
                                            $fatherfirstname_decoded = $crypt->decrypt($epalStudent->fatherfirstname->value);
                                            $motherfirstname_decoded = $crypt->decrypt($epalStudent->motherfirstname->value);
                                            $regionaddress_decoded = $crypt->decrypt($epalStudent->regionaddress->value);
                                            $regiontk_decoded = $crypt->decrypt($epalStudent->regiontk->value);
                                            $regionarea_decoded = $crypt->decrypt($epalStudent->regionarea->value);
                                            $certificatetype_decoded = $crypt->decrypt($epalStudent->certificatetype->value);
                                            $relationtostudent_decoded = $crypt->decrypt($epalStudent->relationtostudent->value);
                                            $telnum_decoded = $crypt->decrypt($epalStudent->telnum->value);
                                            $guardian_name_decoded = $crypt->decrypt($epalStudent->guardian_name->value);
                                            $guardian_surname_decoded = $crypt->decrypt($epalStudent->guardian_surname->value);
                                            $guardian_fathername_decoded = $crypt->decrypt($epalStudent->guardian_fathername->value);
                                            $guardian_mothername_decoded = $crypt->decrypt($epalStudent->guardian_mothername->value);
145

146 147 148 149 150 151 152 153
                                        } catch (\Exception $e) {
                                            $this->logger->warning(__METHOD__ . ' Decrypt error: ' . $e->getMessage());
                                            return $this->respondWithStatus([
                                                "message" => t("An unexpected error occured during DECODING data in getStudentPerSchool Method ")
                                            ], Response::HTTP_INTERNAL_SERVER_ERROR);
                                        }


Open Source Developer's avatar
Open Source Developer committed
154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180
                                    $list[] = array(
                                    'id' => $epalStudent->id(),
                                    'name' => $name_decoded,
                                    'studentsurname' => $studentsurname_decoded,
                                    'fatherfirstname' => $fatherfirstname_decoded,
                                    'motherfirstname' => $motherfirstname_decoded,
                                    'guardian_name' => $guardian_name_decoded,
                                    'guardian_surname' => $guardian_surname_decoded,
                                    'guardian_fathername' => $guardian_fathername_decoded,
                                    'guardian_mothername' => $guardian_mothername_decoded,
                                    'lastschool_schoolname' => $epalStudent->lastschool_schoolname->value,
                                    'lastschool_schoolyear' => $epalStudent->lastschool_schoolyear->value,
                                    'lastschool_class' => $epalStudent->lastschool_class->value,
                                    'currentclass' =>$epalStudent -> currentclass ->value,
                                    'currentsector' =>$sectorName,
                                    'currentcourse' =>$courseName,
                                    'regionaddress' => $regionaddress_decoded,
                                    'regiontk' => $regiontk_decoded,
                                    'regionarea' => $regionarea_decoded,
                                    'certificatetype' => $certificatetype_decoded,
                                    'graduation_year' => $epalStudent->graduation_year->value,
                                    'telnum' => $telnum_decoded,
                                    'relationtostudent' => $relationtostudent_decoded,
                                    //'birthdate' => substr($epalStudent->birthdate->value, 8, 10) . '/' . substr($epalStudent->birthdate->value, 6, 8) . '/' . substr($epalStudent->birthdate->value, 0, 4),
                                    'birthdate' => date("d-m-Y", strtotime($epalStudent->birthdate->value)),
                                    'checkstatus' => $checkstudentstatus -> directorconfirm ->value,
                                    'created' => date('d/m/Y H:i', $epalStudent -> created ->value),
Open Source Developer's avatar
bug  
Open Source Developer committed
181

Open Source Developer's avatar
Open Source Developer committed
182 183 184
                                    );
                                }
                                ++$i;
Open Source Developer's avatar
trans  
Open Source Developer committed
185
                }
Open Source Developer's avatar
Open Source Developer committed
186 187 188 189 190 191 192
                return $this->respondWithStatus(
                     $list, Response::HTTP_OK);
            }
            else
            {
               return $this->respondWithStatus([
                    'message' => t('Students not found!'),
Open Source Developer's avatar
trans  
Open Source Developer committed
193
                ], Response::HTTP_FORBIDDEN);
194
            }
Open Source Developer's avatar
Open Source Developer committed
195
        }
196
         else
Open Source Developer's avatar
Open Source Developer committed
197
        {
198
            return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
199 200 201 202 203 204 205 206
                    'message' => t('User not found!'),
                ], Response::HTTP_FORBIDDEN);
        }
    }
    catch (\Exception $e)
    {
        $this->logger->warning($e->getMessage());
        return $this->respondWithStatus([
207 208
                'message' => t('Unexpected Error'),
            ], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
Open Source Developer committed
209
    }
Open Source Developer's avatar
trans  
Open Source Developer committed
210
    }
Open Source Developer's avatar
transf  
Open Source Developer committed
211

Open Source Developer's avatar
changes  
Open Source Developer committed
212 213 214



Open Source Developer's avatar
trans  
Open Source Developer committed
215 216 217
    public function ConfirmStudents(Request $request)
    {
        if (!$request->isMethod('POST')) {
218
            return $this->respondWithStatus([
219
                    'message' => t('Method Not Allowed'),
Open Source Developer's avatar
trans  
Open Source Developer committed
220 221 222 223
                ], Response::HTTP_METHOD_NOT_ALLOWED);
        }
        $authToken = $request->headers->get('PHP_AUTH_USER');

224
        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
225 226 227 228 229 230 231
        $user = reset($users);
        if ($user) {
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
Open Source Developer committed
232
                }
233 234 235
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
236 237
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
238 239 240 241 242 243 244
            } elseif ($userRole === 'epal') {
                $postData = null;

                if ($content = $request->getContent()) {
                    $postData = json_decode($content);
                    $arr = $postData->students;
                    $type = $postData->type;
Open Source Developer's avatar
Open Source Developer committed
245 246
                    $valnew = intval($arr);
                    $typen = intval($type);
247 248 249
                        $studentForConfirm = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('id' => $valnew));
                        $studentConfirm = reset($studentForConfirm);
                        if ($studentConfirm) {
Open Source Developer's avatar
Open Source Developer committed
250 251 252 253 254 255 256
                            if ($typen === 1) {
                                $studentConfirm->set('directorconfirm', 1);
                                $studentConfirm->save();
                                return $this->respondWithStatus([
                                 'message' => t('saved')
                            ,
                            ], Response::HTTP_OK);
257
                            }
Open Source Developer's avatar
Open Source Developer committed
258 259 260 261 262 263 264
                            elseif ($typen === 2) {
                                $studentConfirm->set('directorconfirm', 0);
                                $studentConfirm->save();
                                return $this->respondWithStatus([
                            'message' => t('saved')
                            ,
                            ], Response::HTTP_OK);
265
                            }
Open Source Developer's avatar
Open Source Developer committed
266
                            elseif ($typen === 3) {
267
                                unset($studentConfirm->{directorconfirm});
Open Source Developer's avatar
Open Source Developer committed
268 269 270 271 272 273 274 275 276 277 278
                                $studentConfirm->save();
                                return $this->respondWithStatus([
                            'message' => t('saved')
                            ,
                            ], Response::HTTP_OK);
                            }
                            else
                                 {
                            return $this->respondWithStatus([
                            'message' => t('Bad request'),
                            ], Response::HTTP_FORBIDDEN);
279
                            }
Open Source Developer's avatar
Open Source Developer committed
280

281

282
                        }
Open Source Developer's avatar
Open Source Developer committed
283 284 285 286 287 288
                        else
                        {
                            return $this->respondWithStatus([
                            'message' => t('Student not found'),
                        ], Response::HTTP_FORBIDDEN);
                        }
289

290 291


Open Source Developer's avatar
trans  
Open Source Developer committed
292 293
                }
            } else {
294 295 296 297 298
                return $this->respondWithStatus([
                    'message' => t('post with no data'),
                ], Response::HTTP_BAD_REQUEST);
            }
        } else {
Open Source Developer's avatar
trans  
Open Source Developer committed
299
            return $this->respondWithStatus([
300
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
trans  
Open Source Developer committed
301 302 303 304
                ], Response::HTTP_FORBIDDEN);
        }
    }

Open Source Developer's avatar
changes  
Open Source Developer committed
305 306


307
    public function SaveCapacity(Request $request, $taxi, $tomeas, $specialit)
Open Source Developer's avatar
Open Source Developer committed
308 309
    {
        if (!$request->isMethod('POST')) {
310
            return $this->respondWithStatus([
311
                    'message' => t('Method Not Allowed'),
Open Source Developer's avatar
Open Source Developer committed
312 313 314 315
                ], Response::HTTP_METHOD_NOT_ALLOWED);
        }
        $authToken = $request->headers->get('PHP_AUTH_USER');

316 317 318 319 320 321 322 323 324 325 326 327 328
        $epalConfigs = $this->entityTypeManager->getStorage('epal_config')->loadByProperties(array('name' => 'epal_config'));
        $epalConfig = reset($epalConfigs);
        if (!$epalConfig) {
            return $this->respondWithStatus([
                    "error_code" => 3001
                ], Response::HTTP_FORBIDDEN);
        }
        if ($epalConfig->lock_capacity->value) {
            return $this->respondWithStatus([
                    "error_code" => 3002
                ], Response::HTTP_FORBIDDEN);
        }

329
        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348
        $user = reset($users);
        if ($user) {
            $schoolid = $user->init->value;
            $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
            $school = reset($schools);
            if (!$school) {
                $this->logger->warning('no access to this school='.$user->id());
                $response = new Response();
                $response->setContent('No access to this school');
                $response->setStatusCode(Response::HTTP_FORBIDDEN);
                $response->headers->set('Content-Type', 'application/json');

                return $response;
            }
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
Open Source Developer committed
349
                }
350 351 352
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
353 354
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
355 356
            } elseif ($userRole === 'epal') {
                $postData = null;
Open Source Developer's avatar
Open Source Developer committed
357

358 359 360 361 362 363
                if ($content = $request->getContent()) {
                    $postData = json_decode($content);
                    $cap = $postData->capacity;
                    if ($cap <= 0 || $cap > 99) {
                        return $this->respondWithStatus([
                            'message' => t('Number out of limits!'),
Open Source Developer's avatar
Open Source Developer committed
364
                        ], Response::HTTP_BAD_REQUEST);
365
                    }
Open Source Developer's avatar
Open Source Developer committed
366

367 368 369 370 371 372
                    if (($tomeas == 0) && ($specialit == 0)) {
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $classcapacity->set('capacity_class_a', $cap);
                            $classcapacity->save();
Open Source Developer's avatar
Open Source Developer committed
373
                        }
374
                    }
Open Source Developer's avatar
Open Source Developer committed
375

376 377 378 379 380 381
                    if (($tomeas != 0) && ($specialit == 0)) {
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'sector_id' => $tomeas));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $classcapacity->set('capacity_class_sector', $cap);
                            $classcapacity->save();
Open Source Developer's avatar
Open Source Developer committed
382
                        }
383
                    }
Open Source Developer's avatar
Open Source Developer committed
384

385 386 387 388 389 390
                    if (($specialit != 0) && ($taxi == 3)) {
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'specialty_id' => $specialit));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $classcapacity->set('capacity_class_specialty', $cap);
                            $classcapacity->save();
Open Source Developer's avatar
Open Source Developer committed
391
                        }
392
                    }
Open Source Developer's avatar
Open Source Developer committed
393

394 395 396 397 398 399 400 401
                    if (($specialit != 0) && ($taxi == 4)) {
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'specialty_id' => $specialit));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $classcapacity->set('capacity_class_specialty_d', $cap);
                            $classcapacity->save();
                        }
                    }
Open Source Developer's avatar
Open Source Developer committed
402

403 404
                    return $this->respondWithStatus([
                            'message' => t('saved'),
Open Source Developer's avatar
Open Source Developer committed
405
                        ], Response::HTTP_OK);
Open Source Developer's avatar
Open Source Developer committed
406 407
                }
            } else {
408 409 410 411 412
                return $this->respondWithStatus([
                    'message' => t('post with no data'),
                ], Response::HTTP_BAD_REQUEST);
            }
        } else {
Open Source Developer's avatar
Open Source Developer committed
413
            return $this->respondWithStatus([
414
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
Open Source Developer committed
415 416 417 418
                ], Response::HTTP_FORBIDDEN);
        }
    }

Open Source Developer's avatar
changes  
Open Source Developer committed
419 420


421
    public function getSchools(Request $request)
Open Source Developer's avatar
trans  
Open Source Developer committed
422 423 424 425 426
    {
        $authToken = $request->headers->get('PHP_AUTH_USER');

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
        $user = reset($users);
427 428 429 430 431 432 433
        if ($user) {
            $selectionId = $user->init->value;
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if (($tmpRole === 'epal') || ($tmpRole === 'regioneduadmin') || ($tmpRole === 'eduadmin')) {
                    $userRole = $tmpRole;
434
                }
435
            }
436
            $this->logger->warning('userRole='.$userRole);
437 438
            if ($userRole === '') {
                return $this->respondWithStatus([
439 440
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
441 442 443 444 445 446 447
            } elseif ($userRole === 'regioneduadmin') {
                $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('region_edu_admin_id' => $selectionId));
            } elseif ($userRole === 'eduadmin') {
                $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('edu_admin_id' => $selectionId));
            }
            if ($schools) {
                $list = array();
Open Source Developer's avatar
Open Source Developer committed
448

449 450 451 452 453 454
                foreach ($schools as $object) {
                    $status = $this->returnstatus($object->id());
                    $list[] = array(
                                    'id' => $object->id(),
                                    'name' => $object->name->value,
                                    'status' => $status,
Open Source Developer's avatar
trans  
Open Source Developer committed
455 456
                                    );

457
                    ++$i;
Open Source Developer's avatar
trans  
Open Source Developer committed
458 459
                }

460 461 462 463 464
                return $this->respondWithStatus(
                                     $list, Response::HTTP_OK);
            } else {
                return $this->respondWithStatus([
                            'message' => t('Perfecture not found!'),
Open Source Developer's avatar
trans  
Open Source Developer committed
465 466
                        ], Response::HTTP_FORBIDDEN);
            }
467 468 469 470 471
        } else {
            return $this->respondWithStatus([
                            'message' => t('User not found!'),
                        ], Response::HTTP_FORBIDDEN);
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
472 473
    }

Open Source Developer's avatar
changes  
Open Source Developer committed
474

Open Source Developer's avatar
trans  
Open Source Developer committed
475 476
    public function getCoursesPerSchool(Request $request, $schoolid)
    {
477
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
trans  
Open Source Developer committed
478 479 480

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
        $user = reset($users);
481 482 483 484 485 486 487
        if ($user) {
            $newid = $user->init->value;
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if (($tmpRole === 'regioneduadmin') || ($tmpRole === 'eduadmin')) {
                    $userRole = $tmpRole;
Open Source Developer's avatar
Open Source Developer committed
488
                }
489 490 491
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
492 493
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
494 495 496 497 498
            } elseif ($userRole === 'regioneduadmin') {
                $SchoolCats = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid, 'region_edu_admin_id' => $newid));
            } elseif ($userRole === 'eduadmin') {
                $SchoolCats = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid, 'edu_admin_id' => $newid));
            }
Open Source Developer's avatar
Open Source Developer committed
499

500 501 502 503 504 505
            $SchoolCat = reset($SchoolCats);
            if ($SchoolCat) {
                $list = array();
                $categ = $SchoolCat->metathesis_region->value;
            }
            $CourseA = $this->entityTypeManager->getStorage('epal_student')->loadByProperties(array('id' => $schoolid));
Open Source Developer's avatar
trans  
Open Source Developer committed
506

507 508 509 510 511
            if ($CourseA) {
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 1, 'category' => $categ));
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
Open Source Developer's avatar
trans  
Open Source Developer committed
512
                }
Open Source Developer's avatar
bug  
Open Source Developer committed
513
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => -1, 'currentclass' => 1));
514 515 516
                $list = array();
                foreach ($CourseA as $object) {
                    $list[] = array(
Open Source Developer's avatar
trans  
Open Source Developer committed
517
                                    'id' => '1',
Open Source Developer's avatar
trans  
Open Source Developer committed
518
                                    'name' => 'Α Λυκείου',
Open Source Developer's avatar
trans  
Open Source Developer committed
519 520
                                    'size' => sizeof($studentPerSchool),
                                    'categ' => $categ,
Open Source Developer's avatar
Open Source Developer committed
521 522
                                    'classes' => 1,
                                    'limitdown' => $limit,
Open Source Developer's avatar
trans  
Open Source Developer committed
523
                                    );
524 525
                }
            }
526

527 528 529 530 531 532 533
            $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
            if ($CourseB) {
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 2, 'category' => $categ));
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
                }
Open Source Developer's avatar
Open Source Developer committed
534

535 536
                foreach ($CourseB as $object) {
                    $sectorid = $object->sector_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
537
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
538 539 540
                    $list[] = array(
                            'id' => $object->sector_id->entity->id(),
                            'name' => 'Β Λυκείου  '.$object->sector_id->entity->get('name')->value,
Open Source Developer's avatar
trans  
Open Source Developer committed
541 542
                            'size' => sizeof($studentPerSchool),
                            'categ' => $categ,
Open Source Developer's avatar
Open Source Developer committed
543 544
                            'classes' => 2,
                            'limitdown' => $limit,
Open Source Developer's avatar
trans  
Open Source Developer committed
545 546 547

                          );
                }
548 549 550 551 552 553 554 555
            }
            $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
            if ($CourseC) {
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 3, 'category' => $categ));
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
                }
Open Source Developer's avatar
Open Source Developer committed
556

557 558
                foreach ($CourseC as $object) {
                    $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
559
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 3));
Open Source Developer's avatar
trans  
Open Source Developer committed
560

561 562 563
                    $list[] = array(
                            'id' => $object->specialty_id->entity->id(),
                            'name' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
Open Source Developer's avatar
trans  
Open Source Developer committed
564 565
                            'size' => sizeof($studentPerSchool),
                            'categ' => $categ,
Open Source Developer's avatar
Open Source Developer committed
566 567
                            'classes' => 3,
                            'limitdown' => $limit,
568

Open Source Developer's avatar
trans  
Open Source Developer committed
569 570
                          );
                }
571
            }
572 573 574 575 576 577
            if ($CourseA || $CourseB || $CourseC) {
                return $this->respondWithStatus(
                                     $list, Response::HTTP_OK);
            } else {
                return $this->respondWithStatus([
                            'message' => t('Perfecture not found!'),
Open Source Developer's avatar
trans  
Open Source Developer committed
578 579
                        ], Response::HTTP_FORBIDDEN);
            }
580 581 582 583 584
        } else {
            return $this->respondWithStatus([
                            'message' => t('User not found!'),
                        ], Response::HTTP_FORBIDDEN);
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
585
    }
Open Source Developer's avatar
trans  
Open Source Developer committed
586

587 588 589 590 591 592 593 594 595
    public function returnstatus($id)
    {
        $schoolid = $id;
        $SchoolCats = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
        $SchoolCat = reset($SchoolCats);
        if ($SchoolCat) {
            $categ = $SchoolCat->metathesis_region->value;
        }
        $CourseA = $this->entityTypeManager->getStorage('epal_student')->loadByProperties(array('id' => $schoolid));
Open Source Developer's avatar
trans  
Open Source Developer committed
596

597 598 599 600 601 602
        if ($CourseA) {
            $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 1, 'category' => $categ));
            $limitdown = reset($limit_down);
            if ($limitdown) {
                $limit = $limitdown->limit_down->value;
            }
Open Source Developer's avatar
bug  
Open Source Developer committed
603
            $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => -1, 'currentclass' => 1));
604

Open Source Developer's avatar
Open Source Developer committed
605
                    //foreach ($CourseA as $object) {
606 607
            if (sizeof($studentPerSchool) < $limit) {
                return false;
608
//                                exit;
609
            }
610 611 612 613 614 615 616 617 618
        }          //  }

                $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
        if ($CourseB) {
            $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 2, 'category' => $categ));
            $limitdown = reset($limit_down);
            if ($limitdown) {
                $limit = $limitdown->limit_down->value;
            }
619

620 621
            foreach ($CourseB as $object) {
                $sectorid = $object->sector_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
622
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
623 624 625
                if (sizeof($studentPerSchool) < $limit) {
                    return false;
                    exit;
Open Source Developer's avatar
Open Source Developer committed
626
                }
627 628 629 630 631 632 633 634 635
            }
        }
        $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
        if ($CourseC) {
            $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 3, 'category' => $categ));
            $limitdown = reset($limit_down);
            if ($limitdown) {
                $limit = $limitdown->limit_down->value;
            }
Open Source Developer's avatar
Open Source Developer committed
636

637 638
            foreach ($CourseC as $object) {
                $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
639
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 3));
Open Source Developer's avatar
Open Source Developer committed
640

641 642 643
                if (sizeof($studentPerSchool) < $limit) {
                    return false;
                    exit;
Open Source Developer's avatar
Open Source Developer committed
644
                }
645 646
            }
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
647

648 649
        return true;
    }
Open Source Developer's avatar
trans  
Open Source Developer committed
650

651

Open Source Developer's avatar
changes  
Open Source Developer committed
652
    public function FindCapacityPerSchool(Request $request)
Open Source Developer's avatar
trans  
Open Source Developer committed
653
    {
Open Source Developer's avatar
changes  
Open Source Developer committed
654
        $i = 0;
655
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
trans  
Open Source Developer committed
656 657

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
658 659 660 661 662 663 664 665 666 667 668 669 670 671
        $user = reset($users);
        if ($user) {
            $schoolid = $user->init->value;
            $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
            $school = reset($schools);
            if (!$school) {
                $this->logger->warning('no access to this school='.$user->id());
                $response = new Response();
                $response->setContent('No access to this school');
                $response->setStatusCode(Response::HTTP_FORBIDDEN);
                $response->headers->set('Content-Type', 'application/json');

                return $response;
            }
Open Source Developer's avatar
changes  
Open Source Developer committed
672
            $operation_shift = $school -> operation_shift -> value;
673 674 675 676 677
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
trans  
Open Source Developer committed
678
                }
679 680 681
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
682 683
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
684
            } elseif ($userRole === 'epal') {
Open Source Developer's avatar
changes  
Open Source Developer committed
685
                $categ = $school->metathesis_region->value;
686
                $list = array();
Open Source Developer's avatar
changes  
Open Source Developer committed
687 688
                $CourseA = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
                $classcapacity = reset($CourseA);
Open Source Developer's avatar
trans  
Open Source Developer committed
689

Open Source Developer's avatar
changes  
Open Source Developer committed
690
                if ($classcapacity) {
691

Open Source Developer's avatar
trans  
Open Source Developer committed
692

Open Source Developer's avatar
changes  
Open Source Developer committed
693 694 695 696 697 698 699
                    $list[] = array(
                        'class' => 1,
                        'newsector' => 0,
                        'newspecialit' => 0,
                        'taxi' => 'Ά Λυκείου',
                        'capacity' => $classcapacity->capacity_class_a->value,
                        'globalindex' => $i,
700

Open Source Developer's avatar
changes  
Open Source Developer committed
701
                       );
702
                }
Open Source Developer's avatar
changes  
Open Source Developer committed
703 704 705
                ++$i;
                $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseB) {
706

Open Source Developer's avatar
trans  
Open Source Developer committed
707

Open Source Developer's avatar
changes  
Open Source Developer committed
708 709
                    foreach ($CourseB as $object) {
                        $sectorid = $object->sector_id->entity->id();
710

Open Source Developer's avatar
changes  
Open Source Developer committed
711 712 713 714 715 716 717 718
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'sector_id' => $sectorid));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $list[] = array(
                                'class' => 2,
                                'newsector' => $object->sector_id->entity->id(),
                                'newspecialit' => 0,
                                'taxi' => 'Β Λυκείου  '.$object->sector_id->entity->get('name')->value,
719
                                'capacity' => $classcapacity->capacity_class_sector->value,
Open Source Developer's avatar
changes  
Open Source Developer committed
720 721 722 723
                                'globalindex' => $i,
                                 );
                        }
                        ++$i;
724 725
                    }
                }
Open Source Developer's avatar
changes  
Open Source Developer committed
726 727
                $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseC) {
728

Open Source Developer's avatar
changes  
Open Source Developer committed
729
                        foreach ($CourseC as $object) {
730

Open Source Developer's avatar
changes  
Open Source Developer committed
731 732 733 734 735 736 737 738 739 740 741
                        $specialityid = $object->specialty_id->entity->id();
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'specialty_id' => $specialityid));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $list[] = array(
                                'class' => 3,
                                    'newsector' => 0,
                                    'newspecialit' => $object->specialty_id->entity->id(),
                                    'taxi' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                    'capacity' => $classcapacity->capacity_class_specialty->value,
                                    'globalindex' => $i,
742

Open Source Developer's avatar
changes  
Open Source Developer committed
743 744 745
                            );
                        }
                        ++$i;
746 747
                    }
                }
Open Source Developer's avatar
trans  
Open Source Developer committed
748

Open Source Developer's avatar
changes  
Open Source Developer committed
749
                if ($CourseC && $operation_shift != 'ΗΜΕΡΗΣΙΟ') {
750

Open Source Developer's avatar
changes  
Open Source Developer committed
751
                    foreach ($CourseC as $object) {
752

Open Source Developer's avatar
changes  
Open Source Developer committed
753
                        $specialityid = $object->specialty_id->entity->id();
754

Open Source Developer's avatar
changes  
Open Source Developer committed
755 756 757 758 759 760 761 762 763 764 765 766 767
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'specialty_id' => $specialityid));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $list[] = array(
                                    'class' => 4,
                                    'newsector' => 0,
                                    'newspecialit' => $object->specialty_id->entity->id(),
                                    'taxi' => 'Δ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                    'capacity' => $classcapacity->capacity_class_specialty_d->value,
                                    'globalindex' => $i,
                                  );
                        }
                        ++$i;
768 769
                    }
                }
Open Source Developer's avatar
Open Source Developer committed
770

771
                return $this->respondWithStatus(
Open Source Developer's avatar
changes  
Open Source Developer committed
772
                                     $list, Response::HTTP_OK);
Open Source Developer's avatar
Open Source Developer committed
773
            }
774
        } else {
Open Source Developer's avatar
trans  
Open Source Developer committed
775
            return $this->respondWithStatus([
776
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
trans  
Open Source Developer committed
777 778 779
                ], Response::HTTP_FORBIDDEN);
        }
    }
780

Open Source Developer's avatar
trans  
Open Source Developer committed
781

Open Source Developer's avatar
changes  
Open Source Developer committed
782
    public function FindCoursesPerSchool(Request $request)
Open Source Developer's avatar
Open Source Developer committed
783
    {
Open Source Developer's avatar
Open Source Developer committed
784
        $i = 0;
785
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
Open Source Developer committed
786 787

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
788 789 790 791 792 793 794 795 796 797 798 799 800 801
        $user = reset($users);
        if ($user) {
            $schoolid = $user->init->value;
            $schools = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
            $school = reset($schools);
            if (!$school) {
                $this->logger->warning('no access to this school='.$user->id());
                $response = new Response();
                $response->setContent('No access to this school');
                $response->setStatusCode(Response::HTTP_FORBIDDEN);
                $response->headers->set('Content-Type', 'application/json');

                return $response;
            }
Open Source Developer's avatar
Open Source Developer committed
802
            $operation_shift = $school -> operation_shift -> value;
803 804 805 806 807
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
Open Source Developer committed
808
                }
809 810 811
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
812 813
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
814
            } elseif ($userRole === 'epal') {
Open Source Developer's avatar
Open Source Developer committed
815
                $categ = $school->metathesis_region->value;
816
                $list = array();
Open Source Developer's avatar
changes  
Open Source Developer committed
817
                $CourseA = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
818

Open Source Developer's avatar
changes  
Open Source Developer committed
819
                if ($CourseA) {
Open Source Developer's avatar
Open Source Developer committed
820 821 822 823 824
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 1, 'category' => $categ));
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
                }
Open Source Developer's avatar
bug  
Open Source Developer committed
825
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => -1, 'currentclass' => 1));
Open Source Developer's avatar
Open Source Developer committed
826

Open Source Developer's avatar
Open Source Developer committed
827 828
                    $list[] = array(
                        'class' => 1,
Open Source Developer's avatar
Open Source Developer committed
829 830
                        'newsector' => 0,
                        'newspecialit' => 0,
Open Source Developer's avatar
Open Source Developer committed
831
                        'taxi' => 'Ά Λυκείου',
832
                        'globalindex' => $i,
Open Source Developer's avatar
Open Source Developer committed
833 834
                        'limitdown' => $limit,
                        'size' => sizeof($studentPerSchool),
Open Source Developer's avatar
Open Source Developer committed
835
                       );
836 837 838 839
                }
                ++$i;
                $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseB) {
Open Source Developer's avatar
Open Source Developer committed
840 841 842 843 844 845
                    $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 2, 'category' => $categ));
                    $limitdown = reset($limit_down);
                    if ($limitdown) {
                        $limit = $limitdown->limit_down->value;
                    }

846 847
                    foreach ($CourseB as $object) {
                        $sectorid = $object->sector_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
848
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
849 850


851
                            $list[] = array(
Open Source Developer's avatar
Open Source Developer committed
852
                                'class' => 2,
853
                                'newsector' => $object->sector_id->entity->id(),
Open Source Developer's avatar
Open Source Developer committed
854
                                'newspecialit' => 0,
855 856
                                'taxi' => 'Β Λυκείου  '.$object->sector_id->entity->get('name')->value,
                                'globalindex' => $i,
Open Source Developer's avatar
Open Source Developer committed
857 858
                                'limitdown' => $limit,
                                'size' => sizeof($studentPerSchool),
Open Source Developer's avatar
Open Source Developer committed
859
                                );
860

861
                        ++$i;
Open Source Developer's avatar
Open Source Developer committed
862
                    }
863 864 865
                }
                $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseC) {
Open Source Developer's avatar
Open Source Developer committed
866 867 868 869 870 871
                    $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 3, 'category' => $categ));
                        $limitdown = reset($limit_down);
                        if ($limitdown) {
                            $limit = $limitdown->limit_down->value;
                        }
                        foreach ($CourseC as $object) {
872

873
                        $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
874
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 3));
875

876
                            $list[] = array(
Open Source Developer's avatar
Open Source Developer committed
877
                                'class' => 3,
Open Source Developer's avatar
Open Source Developer committed
878
                                    'newsector' => 0,
879 880 881
                                    'newspecialit' => $object->specialty_id->entity->id(),
                                    'taxi' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                    'globalindex' => $i,
Open Source Developer's avatar
Open Source Developer committed
882 883
                                    'limitdown' => $limit,
                                    'size' => sizeof($studentPerSchool),
Open Source Developer's avatar
Open Source Developer committed
884
                            );
885

886
                        ++$i;
Open Source Developer's avatar
Open Source Developer committed
887
                    }
888
                }
889

Open Source Developer's avatar
Open Source Developer committed
890 891 892 893 894 895
                if ($CourseC && $operation_shift != 'ΗΜΕΡΗΣΙΟ') {
                        $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 4, 'category' => $categ));
                        $limitdown = reset($limit_down);
                        if ($limitdown) {
                            $limit = $limitdown->limit_down->value;
                        }
896
                    foreach ($CourseC as $object) {
897

898
                        $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
899
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 4));
900

901
                            $list[] = array(
Open Source Developer's avatar
Open Source Developer committed
902
                                    'class' => 4,
Open Source Developer's avatar
Open Source Developer committed
903
                                    'newsector' => 0,
904 905 906
                                    'newspecialit' => $object->specialty_id->entity->id(),
                                    'taxi' => 'Δ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                    'globalindex' => $i,
Open Source Developer's avatar
Open Source Developer committed
907 908
                                    'limitdown' => $limit,
                                    'size' => sizeof($studentPerSchool),
909

Open Source Developer's avatar
Open Source Developer committed
910
                                    );
911

912 913 914
                        ++$i;
                    }
                }
Open Source Developer's avatar
Open Source Developer committed
915

916 917 918 919
                return $this->respondWithStatus(
                                     $list, Response::HTTP_OK);
            }
        } else {
Open Source Developer's avatar
Open Source Developer committed
920
            return $this->respondWithStatus([
921
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
Open Source Developer committed
922 923 924 925
                ], Response::HTTP_FORBIDDEN);
        }
    }

926 927
    private function respondWithStatus($arr, $s)
    {
Open Source Developer's avatar
transf  
Open Source Developer committed
928 929
        $res = new JsonResponse($arr);
        $res->setStatusCode($s);
930

Open Source Developer's avatar
transf  
Open Source Developer committed
931 932 933
        return $res;
    }
}