DirectorView.php 43.7 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
transf  
Open Source Developer committed
19

20 21 22 23
    public function __construct(
        EntityTypeManagerInterface $entityTypeManager,
        LoggerChannelFactoryInterface $loggerChannel
    ) {
Open Source Developer's avatar
transf  
Open Source Developer committed
24
        $this->entityTypeManager = $entityTypeManager;
25
        $this->logger = $loggerChannel->get('epal-school');
Open Source Developer's avatar
transf  
Open Source Developer committed
26 27 28 29 30
    }

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

Open Source Developer's avatar
Open Source Developer committed
36
    public function getStudentPerSchool(Request $request, $classId, $sector, $specialit)
Open Source Developer's avatar
trans  
Open Source Developer committed
37
    {
38
        try {
39
            $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
Open Source Developer committed
40

41 42 43 44 45 46 47 48 49 50 51
            $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
52 53
            }

54 55 56 57 58 59 60 61 62 63 64
            $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
65
                }
66

67 68 69 70 71 72
                $userRoles = $user->getRoles();
                $userRole = '';
                foreach ($userRoles as $tmpRole) {
                    if ($tmpRole === 'epal') {
                        $userRole = $tmpRole;
                    }
73
                }
74 75
                if ($userRole === '') {
                    return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
76 77
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
78
                } elseif ($userRole === 'epal') {
Open Source Developer's avatar
Open Source Developer committed
79
                    $selectIdNew = $selectId;
80
                    if ($classId == 1) {
Open Source Developer's avatar
Open Source Developer committed
81
                        $selectIdNew = -1;
82
                    } elseif ($classId == 2) {
Open Source Developer's avatar
Open Source Developer committed
83
                        $selectIdNew = $sector;
84
                    } else {
Open Source Developer's avatar
Open Source Developer committed
85
                        $selectIdNew = $specialit;
86
                    }
Open Source Developer's avatar
bug  
Open Source Developer committed
87
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $epalId, 'specialization_id' => $selectIdNew, 'currentclass' => $classId));
88 89 90 91
                }
                if ($studentPerSchool) {
                    $list = array();
                    foreach ($studentPerSchool as $object) {
92 93 94
                        $studentId = intval($object->student_id->getString());
                        $epalStudents = $this->entityTypeManager->getStorage('epal_student')->loadByProperties(array('id' => $studentId));
                        $epalStudent = reset($epalStudents);
95 96 97 98 99 100 101 102 103 104 105
                        if ($epalStudents) {
                            $studentIdNew = $epalStudent->id();
                            $checkstatus = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('student_id' => $studentIdNew));
                            $checkstudentstatus = reset($checkstatus);
                            $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;
Open Source Developer's avatar
Open Source Developer committed
106
                                }
107 108 109 110 111
                            } elseif ($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;
Open Source Developer's avatar
Open Source Developer committed
112
                                }
113 114
                            }

115
                            $crypt = new Crypt();
116 117 118 119 120 121 122 123
                            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);
124
                                // $certificatetype_decoded = $crypt->decrypt($epalStudent->certificatetype->value); // obsolete
125 126 127 128 129 130 131 132 133 134 135 136 137
                                $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);
                            } 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);
                            }

138
                            $list[] = array(
139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156
                                '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,
157
                                'certificatetype' => '', // $certificatetype_decoded, // obsolete
158 159 160 161 162 163 164 165 166 167 168 169
                                '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),

                            );
                        }
                    }
                    return $this->respondWithStatus(
Open Source Developer's avatar
Open Source Developer committed
170
                     $list, Response::HTTP_OK);
171 172
                } else {
                       return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
173
                    'message' => t('Students not found!'),
174 175 176 177 178
                        ], Response::HTTP_FORBIDDEN);
                }
            } else {
                return $this->respondWithStatus([
                'message' => t('User not found!'),
Open Source Developer's avatar
trans  
Open Source Developer committed
179
                ], Response::HTTP_FORBIDDEN);
180
            }
181 182
        } catch (\Exception $e) {
            $this->logger->warning($e->getMessage());
183
            return $this->respondWithStatus([
184
            'message' => t('Unexpected Error'),
185
            ], Response::HTTP_FORBIDDEN);
186
        }
Open Source Developer's avatar
Open Source Developer committed
187
    }
Open Source Developer's avatar
changes  
Open Source Developer committed
188

Open Source Developer's avatar
trans  
Open Source Developer committed
189 190 191
    public function ConfirmStudents(Request $request)
    {
        if (!$request->isMethod('POST')) {
192
            return $this->respondWithStatus(['message' => t('Method Not Allowed')], Response::HTTP_METHOD_NOT_ALLOWED);
Open Source Developer's avatar
trans  
Open Source Developer committed
193 194
        }

195
        $authToken = $request->headers->get('PHP_AUTH_USER');
196
        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
197 198 199 200 201 202 203
        $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
204
                }
205
            }
206
            if ($userRole === 'epal') {
207 208 209 210
                if ($content = $request->getContent()) {
                    $postData = json_decode($content);
                    $arr = $postData->students;
                    $type = $postData->type;
Open Source Developer's avatar
Open Source Developer committed
211 212
                    $valnew = intval($arr);
                    $typen = intval($type);
213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229
                    $studentForConfirm = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(['student_id' => $valnew]);
                    $studentConfirm = reset($studentForConfirm);
                    if ($studentConfirm) {
                        if ($typen === 1) {
                            $studentConfirm->set('directorconfirm', 1);
                            $studentConfirm->save();
                            return $this->respondWithStatus(['message' => t('saved')], Response::HTTP_OK);
                        } elseif ($typen === 2) {
                            $studentConfirm->set('directorconfirm', 0);
                            $studentConfirm->save();
                            return $this->respondWithStatus(['message' => t('saved')], Response::HTTP_OK);
                        } elseif ($typen === 3) {
                            unset($studentConfirm->{directorconfirm});
                            $studentConfirm->save();
                            return $this->respondWithStatus(['message' => t('saved')], Response::HTTP_OK);
                        } else {
                            return $this->respondWithStatus(['message' => t('Bad request')], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
Open Source Developer committed
230
                        }
231 232 233 234 235
                    } else {
                        return $this->respondWithStatus(['message' => t('Student not found')], Response::HTTP_FORBIDDEN);
                    }
                } else {
                    return $this->respondWithStatus(['message' => t('post with no data')], Response::HTTP_BAD_REQUEST);
Open Source Developer's avatar
trans  
Open Source Developer committed
236 237
                }
            } else {
238
                return $this->respondWithStatus(['error_code' => 4003], Response::HTTP_FORBIDDEN);
239 240
            }
        } else {
241
            return $this->respondWithStatus(['message' => t('EPAL user not found')], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
trans  
Open Source Developer committed
242 243 244
        }
    }

245
    public function SaveCapacity(Request $request, $taxi, $tomeas, $specialit)
Open Source Developer's avatar
Open Source Developer committed
246 247
    {
        if (!$request->isMethod('POST')) {
248
            return $this->respondWithStatus([
249
                    'message' => t('Method Not Allowed'),
Open Source Developer's avatar
Open Source Developer committed
250 251 252 253
                ], Response::HTTP_METHOD_NOT_ALLOWED);
        }
        $authToken = $request->headers->get('PHP_AUTH_USER');

254 255 256 257 258 259 260 261 262 263 264 265 266
        $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);
        }

267
        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286
        $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
287
                }
288 289 290
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
291 292
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
293 294
            } elseif ($userRole === 'epal') {
                $postData = null;
Open Source Developer's avatar
Open Source Developer committed
295

296 297 298 299 300 301
                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
302
                        ], Response::HTTP_BAD_REQUEST);
303
                    }
Open Source Developer's avatar
Open Source Developer committed
304

305 306 307 308 309 310
                    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
311
                        }
312
                    }
Open Source Developer's avatar
Open Source Developer committed
313

314 315 316 317 318 319
                    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
320
                        }
321
                    }
Open Source Developer's avatar
Open Source Developer committed
322

323 324 325 326 327 328
                    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
329
                        }
330
                    }
Open Source Developer's avatar
Open Source Developer committed
331

332 333 334 335 336 337 338 339
                    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
340

341 342
                    return $this->respondWithStatus([
                            'message' => t('saved'),
Open Source Developer's avatar
Open Source Developer committed
343
                        ], Response::HTTP_OK);
Open Source Developer's avatar
Open Source Developer committed
344 345
                }
            } else {
346 347 348 349 350
                return $this->respondWithStatus([
                    'message' => t('post with no data'),
                ], Response::HTTP_BAD_REQUEST);
            }
        } else {
Open Source Developer's avatar
Open Source Developer committed
351
            return $this->respondWithStatus([
352
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
Open Source Developer committed
353 354 355 356
                ], Response::HTTP_FORBIDDEN);
        }
    }

357
    public function getSchools(Request $request)
Open Source Developer's avatar
trans  
Open Source Developer committed
358 359 360 361 362
    {
        $authToken = $request->headers->get('PHP_AUTH_USER');

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
        $user = reset($users);
363 364 365 366 367 368 369
        if ($user) {
            $selectionId = $user->init->value;
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if (($tmpRole === 'epal') || ($tmpRole === 'regioneduadmin') || ($tmpRole === 'eduadmin')) {
                    $userRole = $tmpRole;
370
                }
371 372 373
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
374 375
                    'error_code' => 4003,
                ], Response::HTTP_FORBIDDEN);
376
            } elseif ($userRole === 'regioneduadmin') {
377 378 379
                $schools = $this->entityTypeManager
                    ->getStorage('eepal_school')
                    ->loadByProperties(array('region_edu_admin_id' => $selectionId));
380
            } elseif ($userRole === 'eduadmin') {
381 382 383 384 385
                $schools = $this->entityTypeManager
                    ->getStorage('eepal_school')
                    ->loadByProperties(array('edu_admin_id' => $selectionId));
            } else {
                $schools = [];
386 387 388
            }
            if ($schools) {
                $list = array();
Open Source Developer's avatar
Open Source Developer committed
389

390 391 392
                foreach ($schools as $object) {
                    $status = $this->returnstatus($object->id());
                    $list[] = array(
393 394 395 396
                        'id' => $object->id(),
                        'name' => $object->name->value,
                        'status' => $status,
                    );
Open Source Developer's avatar
trans  
Open Source Developer committed
397 398
                }

399
                return $this->respondWithStatus($list, Response::HTTP_OK);
400 401
            } else {
                return $this->respondWithStatus([
402 403
                    'message' => t('No schools found!'),
                ], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
trans  
Open Source Developer committed
404
            }
405 406
        } else {
            return $this->respondWithStatus([
407 408
                'message' => t('User not found!'),
            ], Response::HTTP_FORBIDDEN);
409
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
410 411
    }

Open Source Developer's avatar
trans  
Open Source Developer committed
412 413
    public function getCoursesPerSchool(Request $request, $schoolid)
    {
414
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
trans  
Open Source Developer committed
415 416 417

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
        $user = reset($users);
418 419 420 421 422 423 424
        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
425
                }
426 427 428
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
429 430
                    'error_code' => 4003,
                ], Response::HTTP_FORBIDDEN);
431
            } elseif ($userRole === 'regioneduadmin') {
432 433
                $SchoolCats = $this->entityTypeManager->getStorage('eepal_school')
                    ->loadByProperties(array('id' => $schoolid, 'region_edu_admin_id' => $newid));
434
            } elseif ($userRole === 'eduadmin') {
435 436
                $SchoolCats = $this->entityTypeManager->getStorage('eepal_school')
                    ->loadByProperties(array('id' => $schoolid, 'edu_admin_id' => $newid));
437
            }
Open Source Developer's avatar
Open Source Developer committed
438

439 440 441
            $SchoolCat = reset($SchoolCats);
            if ($SchoolCat) {
                $categ = $SchoolCat->metathesis_region->value;
442 443 444 445 446
                $operation_shift = $SchoolCat->operation_shift->value;
            } else {
                return $this->respondWithStatus([
                    'message' => t('No school located'),
                ], Response::HTTP_FORBIDDEN);
447
            }
Open Source Developer's avatar
bugs  
Open Source Developer committed
448

449 450 451 452
            $list = array();
            $limit = -1;
            $CourseA = $this->entityTypeManager->getStorage('eepal_school')
                ->loadByProperties(array('id' => $schoolid));
453
            if ($CourseA) {
454 455
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')
                    ->loadByProperties(array('name' => 1, 'category' => $categ));
456 457 458
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
459 460
                } else {
                    $limit = -1;
Open Source Developer's avatar
trans  
Open Source Developer committed
461
                }
462 463
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')
                    ->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => -1, 'currentclass' => 1));
464 465 466
                $list = array();
                foreach ($CourseA as $object) {
                    $list[] = array(
467 468 469 470 471 472 473
                        'id' => '1',
                        'name' => 'Α Λυκείου',
                        'size' => sizeof($studentPerSchool),
                        'categ' => $categ,
                        'classes' => 1,
                        'limitdown' => $limit,
                    );
474 475
                }
            }
476

477 478
            $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')
                ->loadByProperties(array('epal_id' => $schoolid));
479
            if ($CourseB) {
480 481
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')
                    ->loadByProperties(array('name' => 2, 'category' => $categ));
482 483 484
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
485 486
                } else {
                    $limit = -1;
487
                }
Open Source Developer's avatar
Open Source Developer committed
488

489 490
                foreach ($CourseB as $object) {
                    $sectorid = $object->sector_id->entity->id();
491 492
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')
                        ->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
493
                    $list[] = array(
494 495 496 497 498 499 500
                        'id' => $object->sector_id->entity->id(),
                        'name' => 'Β Λυκείου  '.$object->sector_id->entity->get('name')->value,
                        'size' => sizeof($studentPerSchool),
                        'categ' => $categ,
                        'classes' => 2,
                        'limitdown' => $limit,
                    );
Open Source Developer's avatar
trans  
Open Source Developer committed
501
                }
502
            }
503 504
            $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')
                ->loadByProperties(array('epal_id' => $schoolid));
505
            if ($CourseC) {
506 507
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')
                    ->loadByProperties(array('name' => 3, 'category' => $categ));
508 509 510
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
511 512
                } else {
                    $limit = -1;
513
                }
Open Source Developer's avatar
Open Source Developer committed
514

515 516
                foreach ($CourseC as $object) {
                    $specialityid = $object->specialty_id->entity->id();
517 518
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')
                        ->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 3));
519
                    $list[] = array(
520 521 522 523 524 525 526
                        'id' => $object->specialty_id->entity->id(),
                        'name' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                        'size' => sizeof($studentPerSchool),
                        'categ' => $categ,
                        'classes' => 3,
                        'limitdown' => $limit,
                    );
Open Source Developer's avatar
trans  
Open Source Developer committed
527
                }
528
            }
529
            if ($CourseC && $operation_shift != 'ΗΜΕΡΗΣΙΟ') {
530 531
                $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')
                    ->loadByProperties(array('name' => 4, 'category' => $categ));
Open Source Developer's avatar
trans  
Open Source Developer committed
532 533 534
                $limitdown = reset($limit_down);
                if ($limitdown) {
                    $limit = $limitdown->limit_down->value;
535 536
                } else {
                    $limit = -1;
Open Source Developer's avatar
trans  
Open Source Developer committed
537 538 539 540
                }

                foreach ($CourseC as $object) {
                    $specialityid = $object->specialty_id->entity->id();
541 542
                    $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')
                        ->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 4));
Open Source Developer's avatar
trans  
Open Source Developer committed
543 544

                    $list[] = array(
545 546 547 548 549 550 551
                        'id' => $object->specialty_id->entity->id(),
                        'name' => 'Δ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                        'size' => sizeof($studentPerSchool),
                        'categ' => $categ,
                        'classes' => 4,
                        'limitdown' => $limit,
                    );
Open Source Developer's avatar
trans  
Open Source Developer committed
552 553 554
                }
            }

555
            if ($CourseA || $CourseB || $CourseC) {
556
                return $this->respondWithStatus($list, Response::HTTP_OK);
557 558
            } else {
                return $this->respondWithStatus([
559 560
                    'message' => t('No courses found!'),
                ], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
trans  
Open Source Developer committed
561
            }
562 563
        } else {
            return $this->respondWithStatus([
564 565
                'message' => t('User not found!'),
            ], Response::HTTP_FORBIDDEN);
566
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
567
    }
Open Source Developer's avatar
trans  
Open Source Developer committed
568

569 570 571 572 573 574 575
    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;
576 577
        } else {
            $categ = '-';
578
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
579

580
        $CourseA = $this->entityTypeManager->getStorage('epal_student')->loadByProperties(array('id' => $schoolid));
581 582 583 584 585
        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;
586 587
            } else {
                $limit = -1;
588
            }
589

Open Source Developer's avatar
bug  
Open Source Developer committed
590
            $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => -1, 'currentclass' => 1));
591

592 593 594
            if (sizeof($studentPerSchool) < $limit) {
                return false;
            }
595
        }
596

597
        $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
598 599 600 601 602
        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;
603 604
            } else {
                $limit = -1;
605
            }
606

607 608
            foreach ($CourseB as $object) {
                $sectorid = $object->sector_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
609
                $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
610 611
                if (sizeof($studentPerSchool) < $limit) {
                    return false;
Open Source Developer's avatar
Open Source Developer committed
612
                }
613 614
            }
        }
615

616 617 618 619 620 621
        $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;
622 623
            } else {
                $limit = -1;
624
            }
Open Source Developer's avatar
Open Source Developer committed
625

626 627
            foreach ($CourseC as $object) {
                $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
628
                $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
629

630 631
                if (sizeof($studentPerSchool) < $limit) {
                    return false;
Open Source Developer's avatar
Open Source Developer committed
632
                }
633 634
            }
        }
Open Source Developer's avatar
trans  
Open Source Developer committed
635

636 637
        return true;
    }
Open Source Developer's avatar
trans  
Open Source Developer committed
638

639

Open Source Developer's avatar
changes  
Open Source Developer committed
640
    public function FindCapacityPerSchool(Request $request)
Open Source Developer's avatar
trans  
Open Source Developer committed
641
    {
Open Source Developer's avatar
changes  
Open Source Developer committed
642
        $i = 0;
643
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
trans  
Open Source Developer committed
644 645

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
646 647 648 649 650 651 652
        $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());
653
                return $this->respondWithStatus(['message' => 'No access to this school'], Response::HTTP_FORBIDDEN);
654
            }
655 656

            $operation_shift = $school->operation_shift->value;
657 658 659 660 661
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
trans  
Open Source Developer committed
662
                }
663 664
            }
            if ($userRole === '') {
665
                return $this->respondWithStatus(['error_code' => 4003], Response::HTTP_FORBIDDEN);
666
            } elseif ($userRole === 'epal') {
Open Source Developer's avatar
changes  
Open Source Developer committed
667
                $categ = $school->metathesis_region->value;
668
                $list = array();
669

Open Source Developer's avatar
changes  
Open Source Developer committed
670 671 672 673 674 675 676 677 678 679
                $CourseA = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
                $classcapacity = reset($CourseA);
                if ($classcapacity) {
                    $list[] = array(
                        'class' => 1,
                        'newsector' => 0,
                        'newspecialit' => 0,
                        'taxi' => 'Ά Λυκείου',
                        'capacity' => $classcapacity->capacity_class_a->value,
                        'globalindex' => $i,
680
                    );
681
                }
Open Source Developer's avatar
changes  
Open Source Developer committed
682
                ++$i;
683

Open Source Developer's avatar
changes  
Open Source Developer committed
684 685 686 687
                $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseB) {
                    foreach ($CourseB as $object) {
                        $sectorid = $object->sector_id->entity->id();
688

Open Source Developer's avatar
changes  
Open Source Developer committed
689 690 691 692 693 694 695 696
                        $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,
697
                                'capacity' => $classcapacity->capacity_class_sector->value,
Open Source Developer's avatar
changes  
Open Source Developer committed
698
                                'globalindex' => $i,
699
                            );
Open Source Developer's avatar
changes  
Open Source Developer committed
700 701
                        }
                        ++$i;
702 703
                    }
                }
704

Open Source Developer's avatar
changes  
Open Source Developer committed
705 706
                $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseC) {
707
                    foreach ($CourseC as $object) {
Open Source Developer's avatar
changes  
Open Source Developer committed
708 709 710 711 712 713
                        $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,
714 715 716 717 718
                                'newsector' => 0,
                                'newspecialit' => $object->specialty_id->entity->id(),
                                'taxi' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                'capacity' => $classcapacity->capacity_class_specialty->value,
                                'globalindex' => $i,
Open Source Developer's avatar
changes  
Open Source Developer committed
719 720 721
                            );
                        }
                        ++$i;
722 723
                    }
                }
Open Source Developer's avatar
trans  
Open Source Developer committed
724

Open Source Developer's avatar
changes  
Open Source Developer committed
725 726 727
                if ($CourseC && $operation_shift != 'ΗΜΕΡΗΣΙΟ') {
                    foreach ($CourseC as $object) {
                        $specialityid = $object->specialty_id->entity->id();
728

Open Source Developer's avatar
changes  
Open Source Developer committed
729 730 731 732
                        $CapacityPerClass = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid, 'specialty_id' => $specialityid));
                        $classcapacity = reset($CapacityPerClass);
                        if ($classcapacity) {
                            $list[] = array(
733 734 735 736 737 738 739
                                '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,
                            );
Open Source Developer's avatar
changes  
Open Source Developer committed
740 741
                        }
                        ++$i;
742 743
                    }
                }
Open Source Developer's avatar
Open Source Developer committed
744

745
                return $this->respondWithStatus($list, Response::HTTP_OK);
Open Source Developer's avatar
Open Source Developer committed
746
            }
747
        } else {
748
            return $this->respondWithStatus(['message' => t('EPAL user not found')], Response::HTTP_FORBIDDEN);
Open Source Developer's avatar
trans  
Open Source Developer committed
749 750
        }
    }
751

Open Source Developer's avatar
changes  
Open Source Developer committed
752
    public function FindCoursesPerSchool(Request $request)
Open Source Developer's avatar
Open Source Developer committed
753
    {
Open Source Developer's avatar
Open Source Developer committed
754
        $i = 0;
755
        $authToken = $request->headers->get('PHP_AUTH_USER');
Open Source Developer's avatar
Open Source Developer committed
756 757

        $users = $this->entityTypeManager->getStorage('user')->loadByProperties(array('name' => $authToken));
758 759 760 761 762 763 764 765 766 767 768 769 770 771
        $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
772
            $operation_shift = $school -> operation_shift -> value;
773 774 775 776 777
            $userRoles = $user->getRoles();
            $userRole = '';
            foreach ($userRoles as $tmpRole) {
                if ($tmpRole === 'epal') {
                    $userRole = $tmpRole;
Open Source Developer's avatar
Open Source Developer committed
778
                }
779 780 781
            }
            if ($userRole === '') {
                return $this->respondWithStatus([
Open Source Developer's avatar
Open Source Developer committed
782 783
                             'error_code' => 4003,
                         ], Response::HTTP_FORBIDDEN);
784
            } elseif ($userRole === 'epal') {
Open Source Developer's avatar
Open Source Developer committed
785
                $categ = $school->metathesis_region->value;
786
                $list = array();
787

788
                $CourseA = $this->entityTypeManager->getStorage('eepal_school')->loadByProperties(array('id' => $schoolid));
Open Source Developer's avatar
changes  
Open Source Developer committed
789
                if ($CourseA) {
790 791 792 793 794 795
                    $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;
                    }
                    $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
796

Open Source Developer's avatar
Open Source Developer committed
797 798
                    $list[] = array(
                        'class' => 1,
Open Source Developer's avatar
Open Source Developer committed
799 800
                        'newsector' => 0,
                        'newspecialit' => 0,
Open Source Developer's avatar
Open Source Developer committed
801
                        'taxi' => 'Ά Λυκείου',
802
                        'globalindex' => $i,
Open Source Developer's avatar
Open Source Developer committed
803 804
                        'limitdown' => $limit,
                        'size' => sizeof($studentPerSchool),
Open Source Developer's avatar
Open Source Developer committed
805
                       );
806 807
                }
                ++$i;
808

809 810
                $CourseB = $this->entityTypeManager->getStorage('eepal_sectors_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseB) {
Open Source Developer's avatar
Open Source Developer committed
811 812 813 814 815 816
                    $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;
                    }

817 818
                    foreach ($CourseB as $object) {
                        $sectorid = $object->sector_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
819
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $sectorid, 'currentclass' => 2));
820 821 822 823 824 825 826 827 828
                        $list[] = array(
                            'class' => 2,
                            'newsector' => $object->sector_id->entity->id(),
                            'newspecialit' => 0,
                            'taxi' => 'Β Λυκείου  '.$object->sector_id->entity->get('name')->value,
                            'globalindex' => $i,
                            'limitdown' => $limit,
                            'size' => sizeof($studentPerSchool),
                            );
829

830
                        ++$i;
Open Source Developer's avatar
Open Source Developer committed
831
                    }
832
                }
833

834 835
                $CourseC = $this->entityTypeManager->getStorage('eepal_specialties_in_epal')->loadByProperties(array('epal_id' => $schoolid));
                if ($CourseC) {
Open Source Developer's avatar
Open Source Developer committed
836 837
                    $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 3, 'category' => $categ));
                        $limitdown = reset($limit_down);
838 839 840 841
                    if ($limitdown) {
                        $limit = $limitdown->limit_down->value;
                    }
                    foreach ($CourseC as $object) {
842
                        $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
843
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 3));
844
                        $list[] = array(
845
                            'class' => 3,
846 847 848 849 850 851 852
                            'newsector' => 0,
                            'newspecialit' => $object->specialty_id->entity->id(),
                            'taxi' => 'Γ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                            'globalindex' => $i,
                            'limitdown' => $limit,
                            'size' => sizeof($studentPerSchool),
                        );
853
                        ++$i;
Open Source Developer's avatar
Open Source Developer committed
854
                    }
855
                }
856

Open Source Developer's avatar
Open Source Developer committed
857 858 859
                if ($CourseC && $operation_shift != 'ΗΜΕΡΗΣΙΟ') {
                        $limit_down = $this->entityTypeManager->getStorage('epal_class_limits')->loadByProperties(array('name' => 4, 'category' => $categ));
                        $limitdown = reset($limit_down);
860 861 862
                    if ($limitdown) {
                        $limit = $limitdown->limit_down->value;
                    }
863 864
                    foreach ($CourseC as $object) {
                        $specialityid = $object->specialty_id->entity->id();
Open Source Developer's avatar
bug  
Open Source Developer committed
865
                        $studentPerSchool = $this->entityTypeManager->getStorage('epal_student_class')->loadByProperties(array('epal_id' => $schoolid, 'specialization_id' => $specialityid, 'currentclass' => 4));
866 867 868 869 870 871 872 873 874
                        $list[] = array(
                                'class' => 4,
                                'newsector' => 0,
                                'newspecialit' => $object->specialty_id->entity->id(),
                                'taxi' => 'Δ Λυκείου  '.$object->specialty_id->entity->get('name')->value,
                                'globalindex' => $i,
                                'limitdown' => $limit,
                                'size' => sizeof($studentPerSchool),
                        );
875 876 877
                        ++$i;
                    }
                }
Open Source Developer's avatar
Open Source Developer committed
878

879
                return $this->respondWithStatus($list, Response::HTTP_OK);
880 881
            }
        } else {
Open Source Developer's avatar
Open Source Developer committed
882
            return $this->respondWithStatus([
883
                    'message' => t('EPAL user not found'),
Open Source Developer's avatar
Open Source Developer committed
884 885 886 887
                ], Response::HTTP_FORBIDDEN);
        }
    }

888 889
    private function respondWithStatus($arr, $s)
    {
Open Source Developer's avatar
transf  
Open Source Developer committed
890 891
        $res = new JsonResponse($arr);
        $res->setStatusCode($s);
892

Open Source Developer's avatar
transf  
Open Source Developer committed
893 894 895
        return $res;
    }
}