Raphaël G. Git Repositories - airbundle/blob - Controller/SessionController.php

   1 <?php
   2
   3 namespace Rapsys\AirBundle\Controller;
   4
   5 use Symfony\Component\HttpFoundation\Request;
   6 use Symfony\Component\Routing\RequestContext;
   7 use Symfony\Component\Routing\Exception\MethodNotAllowedException;
   8 use Symfony\Component\Routing\Exception\ResourceNotFoundException;
   9 use Rapsys\AirBundle\Entity\Application;
  10 use Rapsys\AirBundle\Entity\User;
  11 use Rapsys\AirBundle\Entity\Slot;
  12 use Rapsys\AirBundle\Entity\Session;
  13 use Rapsys\AirBundle\Entity\Location;
  14
  15 class SessionController extends DefaultController {
  16         /**
  17          * Edit session
  18          *
  19          * @desc Persist session and all required dependencies in database
  20          *
  21          * @param Request $request The request instance
  22          *
  23          * @return Response The rendered view or redirection
  24          *
  25          * @throws \RuntimeException When user has not at least guest role
  26          */
  27         public function edit(Request $request, $id) {
  28                 //Prevent non-guest to access here
  29                 $this->denyAccessUnlessGranted('ROLE_GUEST', null, $this->translator->trans('Unable to access this page without role %role%!', ['%role%' => $this->translator->trans('Guest')]));
  30
  31                 //Reject non post requests
  32                 if (!$request->isMethod('POST')) {
  33                         throw new \RuntimeException('Request method MUST be POST');
  34                 }
  35
  36                 //Get doctrine
  37                 $doctrine = $this->getDoctrine();
  38
  39                 //Fetch session
  40                 $session = $doctrine->getRepository(Session::class)->fetchOneById($id);
  41
  42                 //Check if
  43                 if (
  44                         //we are admin
  45                         !$this->isGranted('ROLE_ADMIN') &&
  46                         //or attributed user
  47                         $this->getUser()->getId() != $session['au_id'] &&
  48                         //or application without attributed user
  49                         $session['au_id'] !== null && !in_array($this->getUser()->getId(), explode("\n", $session['sau_id']))
  50                 ) {
  51                         //Prevent non admin and non attributed user access
  52                         throw $this->createAccessDeniedException();
  53                 }
  54
  55                 //Set now
  56                 $now = new \DateTime('now');
  57
  58                 //Create SessionEditType form
  59                 $form = $this->createForm('Rapsys\AirBundle\Form\SessionEditType', null, [
  60                         //Set the action
  61                         'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
  62                         //Set the form attribute
  63                         'attr' => [],
  64                         //Set admin
  65                         'admin' => $this->isGranted('ROLE_ADMIN'),
  66                         //Set default user to current
  67                         'user' => $this->getUser()->getId(),
  68                         //Set begin
  69                         'begin' => $session['begin'],
  70                         //Set length
  71                         'length' => $session['length'],
  72                         //Set raincancel
  73                         'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
  74                         //Set cancel
  75                         'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
  76                         //Set modify
  77                         'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
  78                         //Set move
  79                         'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
  80                         //Set attribute
  81                         'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
  82                         //Set session
  83                         'session' => $session['id']
  84                 ]);
  85
  86                 //Refill the fields in case of invalid form
  87                 $form->handleRequest($request);
  88
  89                 //Handle invalid data
  90                 #if (true) { $form->isValid();
  91                 //TODO: mettre une contrainte sur un des boutons submit, je sais pas encore comment
  92                 if (!$form->isValid()) {
  93                         //Set section
  94                         $section = $this->translator->trans('Session %id%', ['%id%' => $id]);
  95
  96                         //Set title
  97                         $title = $section.' - '.$this->translator->trans($this->config['site']['title']);
  98
  99                         //Add session in context
 100                         $context['session'] = [
 101                                 'id' => $id,
 102                                 'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 103                                 'location' => [
 104                                         'id' => $session['l_id'],
 105                                         'at' => $this->translator->trans('at '.$session['l_title'])
 106                                 ]
 107                         ];
 108                         //Render the view
 109                         return $this->render('@RapsysAir/session/edit.html.twig', ['title' => $title, 'section' => $section, 'form' => $form->createView()]+$context+$this->context);
 110                 }
 111
 112                 //Get manager
 113                 $manager = $doctrine->getManager();
 114
 115                 //Get data
 116                 $data = $form->getData();
 117
 118                 //Fetch session
 119                 $session = $doctrine->getRepository(Session::class)->findOneById($id);
 120
 121                 //Set user
 122                 $user = $this->getUser();
 123
 124                 //Replace with requested user for admin
 125                 if ($this->isGranted('ROLE_ADMIN') && !empty($data['user'])) {
 126                         $user = $doctrine->getRepository(User::class)->findOneById($data['user']);
 127                 }
 128
 129                 //Set datetime
 130                 $datetime = new \DateTime('now');
 131
 132                 //Set canceled time at start minus one day
 133                 $canceled = (clone $session->getStart())->sub(new \DateInterval('P1D'));
 134
 135                 //Set action
 136                 $action = [
 137                         'raincancel' => $form->has('raincancel') && $form->get('raincancel')->isClicked(),
 138                         'modify' => $form->has('modify') && $form->get('modify')->isClicked(),
 139                         'move' => $form->has('move') && $form->get('move')->isClicked(),
 140                         'cancel' => $form->has('cancel') && $form->get('cancel')->isClicked(),
 141                         'forcecancel' => $form->has('forcecancel') && $form->get('forcecancel')->isClicked(),
 142                         'attribute' => $form->has('attribute') && $form->get('attribute')->isClicked(),
 143                         'autoattribute' => $form->has('autoattribute') && $form->get('autoattribute')->isClicked(),
 144                         'lock' => $form->has('lock') && $form->get('lock')->isClicked(),
 145                 ];
 146
 147                 //With raincancel and application and (rainfall or admin)
 148                 if ($action['raincancel'] && ($application = $session->getApplication()) && ($session->getRainfall() >= 2 || $this->isGranted('ROLE_ADMIN'))) {
 149                         //Cancel application at start minus one day
 150                         $application->setCanceled($canceled);
 151
 152                         //Update time
 153                         $application->setUpdated($datetime);
 154
 155                         //Insufficient rainfall
 156                         //XXX: is admin
 157                         if ($session->getRainfall() < 2) {
 158                                 //Set score
 159                                 //XXX: magic cheat score 42
 160                                 $application->setScore(42);
 161                         }
 162
 163                         //Queue application save
 164                         $manager->persist($application);
 165
 166                         //Add notice in flash message
 167                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 168
 169                         //Update time
 170                         $session->setUpdated($datetime);
 171
 172                         //Queue session save
 173                         $manager->persist($session);
 174
 175                         //Add notice in flash message
 176                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 177                 //With modify
 178                 } elseif ($action['modify']) {
 179                         //Set begin
 180                         $session->setBegin($data['begin']);
 181
 182                         //Set length
 183                         $session->setLength($data['length']);
 184
 185                         //Update time
 186                         $session->setUpdated($datetime);
 187
 188                         //Queue session save
 189                         $manager->persist($session);
 190
 191                         //Add notice in flash message
 192                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 193                 //With move
 194                 } elseif ($action['move']) {
 195                         //Set location
 196                         $session->setLocation($doctrine->getRepository(Location::class)->findOneById($data['location']));
 197
 198                         //Update time
 199                         $session->setUpdated($datetime);
 200
 201                         //Queue session save
 202                         $manager->persist($session);
 203
 204                         //Add notice in flash message
 205                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 206                 //With cancel or forcecancel
 207                 } elseif ($action['cancel'] || $action['forcecancel']) {
 208                         //Get application
 209                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 210
 211                         //Not already canceled
 212                         if ($application->getCanceled() === null) {
 213                                 //Cancel application
 214                                 $application->setCanceled($datetime);
 215
 216                                 //Check if application is session application and (canceled 24h before start or forcecancel (as admin))
 217                                 #if ($session->getApplication() == $application && ($datetime < $canceled || $action['forcecancel'])) {
 218                                 if ($session->getApplication() == $application && $action['forcecancel']) {
 219                                         //Set score
 220                                         //XXX: magic cheat score 42
 221                                         $application->setScore(42);
 222
 223                                         //Unattribute session
 224                                         $session->setApplication(null);
 225
 226                                         //Update time
 227                                         $session->setUpdated($datetime);
 228
 229                                         //Queue session save
 230                                         $manager->persist($session);
 231
 232                                         //Add notice in flash message
 233                                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 234                                 }
 235                         //Already canceled
 236                         } else {
 237                                 //Uncancel application
 238                                 $application->setCanceled(null);
 239                         }
 240
 241                         //Update time
 242                         $application->setUpdated($datetime);
 243
 244                         //Queue application save
 245                         $manager->persist($application);
 246
 247                         //Add notice in flash message
 248                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 249                 //With attribute
 250                 } elseif ($action['attribute']) {
 251                         //Get application
 252                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 253
 254                         //Already canceled
 255                         if ($application->getCanceled() !== null) {
 256                                 //Uncancel application
 257                                 $application->setCanceled(null);
 258                         }
 259
 260                         //Set score
 261                         //XXX: magic cheat score 42
 262                         $application->setScore(42);
 263
 264                         //Update time
 265                         $application->setUpdated($datetime);
 266
 267                         //Queue application save
 268                         $manager->persist($application);
 269
 270                         //Add notice in flash message
 271                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 272
 273                         //Unattribute session
 274                         $session->setApplication($application);
 275
 276                         //Update time
 277                         $session->setUpdated($datetime);
 278
 279                         //Queue session save
 280                         $manager->persist($session);
 281
 282                         //Add notice in flash message
 283                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 284                 //With autoattribute
 285                 } elseif ($action['autoattribute']) {
 286                         //Get best application
 287                         //XXX: best application may not issue result while grace time or bad behaviour
 288                         if (!empty($application = $doctrine->getRepository(Session::class)->findBestApplicationById($id))) {
 289                                 //Attribute session
 290                                 $session->setApplication($application);
 291
 292                                 //Update time
 293                                 $session->setUpdated($datetime);
 294
 295                                 //Queue session save
 296                                 $manager->persist($session);
 297
 298                                 //Add notice in flash message
 299                                 $this->addFlash('notice', $this->translator->trans('Session %id% auto attributed', ['%id%' => $id]));
 300                         //No application
 301                         } else {
 302                                 //Add notice in flash message
 303                                 $this->addFlash('warning', $this->translator->trans('Session %id% not auto attributed', ['%id%' => $id]));
 304                         }
 305                 //With lock
 306                 } elseif ($action['lock']) {
 307                         //Already locked
 308                         if ($session->getLocked() !== null) {
 309                                 //Set uncanceled
 310                                 $canceled = null;
 311
 312                                 //Unlock session
 313                                 $session->setLocked(null);
 314                         //Not locked
 315                         } else {
 316                                 //Get application
 317                                 if ($application = $session->getApplication()) {
 318                                         //Set score
 319                                         //XXX: magic cheat score 42
 320                                         $application->setScore(42);
 321
 322                                         //Update time
 323                                         $application->setUpdated($datetime);
 324
 325                                         //Queue application save
 326                                         $manager->persist($application);
 327
 328                                         //Add notice in flash message
 329                                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 330                                 }
 331
 332                                 //Unattribute session
 333                                 $session->setApplication(null);
 334
 335                                 //Lock session
 336                                 $session->setLocked($datetime);
 337                         }
 338
 339 #                       //Get applications
 340 #                       $applications = $doctrine->getRepository(Application::class)->findBySession($session);
 341 #
 342 #                       //Not empty
 343 #                       if (!empty($applications)) {
 344 #                               //Iterate on each applications
 345 #                               foreach($applications as $application) {
 346 #                                       //Cancel application
 347 #                                       $application->setCanceled($canceled);
 348 #
 349 #                                       //Update time
 350 #                                       $application->setUpdated($datetime);
 351 #
 352 #                                       //Queue application save
 353 #                                       $manager->persist($application);
 354 #
 355 #                                       //Add notice in flash message
 356 #                                       $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 357 #                               }
 358 #                       }
 359
 360                         //Update time
 361                         $session->setUpdated($datetime);
 362
 363                         //Queue session save
 364                         $manager->persist($session);
 365
 366                         //Add notice in flash message
 367                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 368                 //Unknown action
 369                 } else {
 370                         //Add notice in flash message
 371                         $this->addFlash('warning', $this->translator->trans('Session %id% not updated', ['%id%' => $id]));
 372                 }
 373
 374                 //Flush to get the ids
 375                 $manager->flush();
 376
 377                 //Extract and process referer
 378                 if ($referer = $request->headers->get('referer')) {
 379                         //Create referer request instance
 380                         $req = Request::create($referer);
 381
 382                         //Get referer path
 383                         $path = $req->getPathInfo();
 384
 385                         //Get referer query string
 386                         $query = $req->getQueryString();
 387
 388                         //Remove script name
 389                         $path = str_replace($request->getScriptName(), '', $path);
 390
 391                         //Try with referer path
 392                         try {
 393                                 //Save old context
 394                                 $oldContext = $this->router->getContext();
 395
 396                                 //Force clean context
 397                                 //XXX: prevent MethodNotAllowedException because current context method is POST in onevendor/symfony/routing/Matcher/Dumper/CompiledUrlMatcherTrait.php+42
 398                                 $this->router->setContext(new RequestContext());
 399
 400                                 //Retrieve route matching path
 401                                 $route = $this->router->match($path);
 402
 403                                 //Reset context
 404                                 $this->router->setContext($oldContext);
 405
 406                                 //Clear old context
 407                                 unset($oldContext);
 408
 409                                 //Extract name
 410                                 $name = $route['_route'];
 411
 412                                 //Remove route and controller from route defaults
 413                                 unset($route['_route'], $route['_controller']);
 414
 415                                 //Generate url
 416                                 return $this->redirectToRoute($name, $route);
 417                         //No route matched
 418                         } catch(MethodNotAllowedException|ResourceNotFoundException $e) {
 419                                 //Unset referer to fallback to default route
 420                                 unset($referer);
 421                         }
 422                 }
 423
 424                 //Redirect to cleanup the form
 425                 return $this->redirectToRoute('rapsys_air_session_view', ['id' => $id]);
 426         }
 427
 428         /**
 429          * List all sessions
 430          *
 431          * @desc Display all sessions with an application or login form
 432          *
 433          * @param Request $request The request instance
 434          *
 435          * @return Response The rendered view
 436          */
 437         public function index(Request $request = null) {
 438                 //Fetch doctrine
 439                 $doctrine = $this->getDoctrine();
 440
 441                 //Set section
 442                 $section = $this->translator->trans('Sessions');
 443
 444                 //Set title
 445                 $title = $section.' - '.$this->translator->trans($this->config['site']['title']);
 446
 447                 //Init context
 448                 $context = [];
 449
 450                 //Create application form for role_guest
 451                 if ($this->isGranted('ROLE_GUEST')) {
 452                         //Create ApplicationType form
 453                         $application = $this->createForm('Rapsys\AirBundle\Form\ApplicationType', null, [
 454                                 //Set the action
 455                                 'action' => $this->generateUrl('rapsys_air_application_add'),
 456                                 //Set the form attribute
 457                                 'attr' => [ 'class' => 'col' ],
 458                                 //Set admin
 459                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 460                                 //Set default user to current
 461                                 'user' => $this->getUser()->getId(),
 462                                 //Set default slot to evening
 463                                 //XXX: default to Evening (3)
 464                                 'slot' => $doctrine->getRepository(Slot::class)->findOneById(3)
 465                         ]);
 466
 467                         //Add form to context
 468                         $context['application'] = $application->createView();
 469                 //Create login form for anonymous
 470                 } elseif (!$this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
 471                         //Create ApplicationType form
 472                         $login = $this->createForm('Rapsys\UserBundle\Form\LoginType', null, [
 473                                 //Set the action
 474                                 'action' => $this->generateUrl('rapsys_user_login'),
 475                                 //Set the form attribute
 476                                 'attr' => [ 'class' => 'col' ]
 477                         ]);
 478
 479                         //Add form to context
 480                         $context['login'] = $login->createView();
 481                 }
 482
 483                 //Compute period
 484                 $period = new \DatePeriod(
 485                         //Start from first monday of week
 486                         new \DateTime('Monday this week'),
 487                         //Iterate on each day
 488                         new \DateInterval('P1D'),
 489                         //End with next sunday and 4 weeks
 490                         new \DateTime('Monday this week + 5 week')
 491                 );
 492
 493                 //Fetch calendar
 494                 //TODO: highlight with current session route parameter
 495                 $calendar = $doctrine->getRepository(Session::class)->fetchCalendarByDatePeriod($this->translator, $period, null, $request->get('session'), !$this->isGranted('IS_AUTHENTICATED_REMEMBERED'));
 496
 497                 //Fetch locations
 498                 //XXX: we want to display all active locations anyway
 499                 $locations = $doctrine->getRepository(Location::class)->fetchTranslatedLocationByDatePeriod($this->translator, $period/*, !$this->isGranted('IS_AUTHENTICATED_REMEMBERED')*/);
 500
 501                 //Render the view
 502                 return $this->render('@RapsysAir/session/index.html.twig', ['title' => $title, 'section' => $section, 'calendar' => $calendar, 'locations' => $locations]+$context+$this->context);
 503         }
 504
 505         /**
 506          * Display session
 507          *
 508          * @desc Display session by id with an application or login form
 509          *
 510          * @param Request $request The request instance
 511          * @param int $id The session id
 512          *
 513          * @return Response The rendered view
 514          */
 515         public function view(Request $request, $id) {
 516                 //Fetch doctrine
 517                 $doctrine = $this->getDoctrine();
 518
 519                 //Fetch session
 520                 $session = $doctrine->getRepository(Session::class)->fetchOneById($id);
 521
 522                 //Set section
 523                 $section = $this->translator->trans($session['l_title']);
 524
 525                 //Set title
 526                 $title = $this->translator->trans('Session %id%', ['%id%' => $id]).' - '.$section.' - '.$this->translator->trans($this->config['site']['title']);
 527
 528                 //Init context
 529                 $context = [];
 530
 531                 //Create application form for role_guest
 532                 if ($this->isGranted('ROLE_GUEST')) {
 533                         //Create ApplicationType form
 534                         $application = $this->createForm('Rapsys\AirBundle\Form\ApplicationType', null, [
 535                                 //Set the action
 536                                 'action' => $this->generateUrl('rapsys_air_application_add'),
 537                                 //Set the form attribute
 538                                 'attr' => [ 'class' => 'col' ],
 539                                 //Set admin
 540                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 541                                 //Set default user to current
 542                                 'user' => $this->getUser()->getId(),
 543                                 //Set default slot to current
 544                                 'slot' => $this->getDoctrine()->getRepository(Slot::class)->findOneById($session['t_id']),
 545                                 //Set default location to current
 546                                 'location' => $this->getDoctrine()->getRepository(Location::class)->findOneById($session['l_id']),
 547                         ]);
 548
 549                         //Add form to context
 550                         $context['application'] = $application->createView();
 551
 552                         //Set now
 553                         $now = new \DateTime('now');
 554
 555                         //Create SessionEditType form
 556                         $session_edit = $this->createForm('Rapsys\AirBundle\Form\SessionEditType', null, [
 557                                 //Set the action
 558                                 'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
 559                                 //Set the form attribute
 560                                 'attr' => [ 'class' => 'col' ],
 561                                 //Set admin
 562                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 563                                 //Set default user to current
 564                                 'user' => $this->getUser()->getId(),
 565                                 //Set begin
 566                                 'begin' => $session['begin'],
 567                                 //Set length
 568                                 'length' => $session['length'],
 569                                 //Set raincancel
 570                                 'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
 571                                 //Set cancel
 572                                 'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
 573                                 //Set modify
 574                                 'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
 575                                 //Set move
 576                                 'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
 577                                 //Set attribute
 578                                 'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
 579                                 //Set session
 580                                 'session' => $session['id']
 581                         ]);
 582
 583                         //Add form to context
 584                         $context['session_edit'] = $session_edit->createView();
 585                 //Create login form for anonymous
 586                 } elseif (!$this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
 587                         //Create ApplicationType form
 588                         $login = $this->createForm('Rapsys\UserBundle\Form\LoginType', null, [
 589                                 //Set the action
 590                                 'action' => $this->generateUrl('rapsys_user_login'),
 591                                 //Set the form attribute
 592                                 'attr' => [ 'class' => 'col' ]
 593                         ]);
 594
 595                         //Add form to context
 596                         $context['login'] = $login->createView();
 597                 }
 598
 599                 //Add session in context
 600                 $context['session'] = [
 601                         'id' => $id,
 602                         'date' => $session['date'],
 603                         'begin' => $session['begin'],
 604                         'start' => $session['start'],
 605                         'length' => $session['length'],
 606                         'stop' => $session['stop'],
 607                         'rainfall' => $session['rainfall'] !== null ? $session['rainfall'].' mm' : $session['rainfall'],
 608                         'rainrisk' => $session['rainrisk'] !== null ? ($session['rainrisk']*100).' %' : $session['rainrisk'],
 609                         'realfeel' => $session['realfeel'] !== null ? $session['realfeel'].' °C' : $session['realfeel'],
 610                         'realfeelmin' => $session['realfeelmin'] !== null ? $session['realfeelmin'].' °C' : $session['realfeelmin'],
 611                         'realfeelmax' => $session['realfeelmax'] !== null ? $session['realfeelmax'].' °C' : $session['realfeelmax'],
 612                         'temperature' => $session['temperature'] !== null ? $session['temperature'].' °C' : $session['temperature'],
 613                         'temperaturemin' => $session['temperaturemin'] !== null ? $session['temperaturemin'].' °C' : $session['temperaturemin'],
 614                         'temperaturemax' => $session['temperaturemax'] !== null ? $session['temperaturemax'].' °C' : $session['temperaturemax'],
 615                         'locked' => $session['locked'],
 616                         'created' => $session['created'],
 617                         'updated' => $session['updated'],
 618                         'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 619                         'application' => null,
 620                         'location' => [
 621                                 'id' => $session['l_id'],
 622                                 'at' => $this->translator->trans('at '.$session['l_title']),
 623                                 'short' => $this->translator->trans($session['l_short']),
 624                                 'title' => $this->translator->trans($session['l_title']),
 625                                 'address' => $session['l_address'],
 626                                 'zipcode' => $session['l_zipcode'],
 627                                 'city' => $session['l_city'],
 628                                 'latitude' => $session['l_latitude'],
 629                                 'longitude' => $session['l_longitude']
 630                         ],
 631                         'slot' => [
 632                                 'id' => $session['t_id'],
 633                                 'title' => $this->translator->trans($session['t_title'])
 634                         ],
 635                         'applications' => null
 636                 ];
 637
 638                 //With application
 639                 if (!empty($session['a_id'])) {
 640                         $context['session']['application'] = [
 641                                 'user' => [
 642                                         'id' => $session['au_id'],
 643                                         'title' => $session['au_pseudonym']
 644                                 ],
 645                                 'id' => $session['a_id'],
 646                                 'title' => $this->translator->trans('Application %id%', [ '%id%' => $session['a_id'] ]),
 647                         ];
 648                 }
 649
 650                 //With applications
 651                 if (!empty($session['sa_id'])) {
 652                         //Extract applications id
 653                         $session['sa_id'] = explode("\n", $session['sa_id']);
 654                         //Extract applications score
 655                         //XXX: score may be null before grant or for bad behaviour, replace NULL with 'NULL' to avoid silent drop in mysql
 656                         $session['sa_score'] = array_map(function($v){return $v==='NULL'?null:$v;}, explode("\n", $session['sa_score']));
 657                         //Extract applications created
 658                         $session['sa_created'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_created']));
 659                         //Extract applications updated
 660                         $session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 661                         //Extract applications canceled
 662                         //XXX: canceled is null before cancelation, replace NULL with 'NULL' to avoid silent drop in mysql
 663                         $session['sa_canceled'] = array_map(function($v){return $v==='NULL'?null:new \DateTime($v);}, explode("\n", $session['sa_canceled']));
 664
 665                         //Extract applications user id
 666                         $session['sau_id'] = explode("\n", $session['sau_id']);
 667                         //Extract applications user pseudonym
 668                         $session['sau_pseudonym'] = explode("\n", $session['sau_pseudonym']);
 669
 670                         //Init applications
 671                         $context['session']['applications'] = [];
 672                         foreach($session['sa_id'] as $i => $sa_id) {
 673                                 $context['session']['applications'][$sa_id] = [
 674                                         'user' => null,
 675                                         'score' => $session['sa_score'][$i],
 676                                         'created' => $session['sa_created'][$i],
 677                                         'updated' => $session['sa_updated'][$i],
 678                                         'canceled' => $session['sa_canceled'][$i]
 679                                 ];
 680                                 if (!empty($session['sau_id'][$i])) {
 681                                         $context['session']['applications'][$sa_id]['user'] = [
 682                                                 'id' => $session['sau_id'][$i],
 683                                                 'title' => $session['sau_pseudonym'][$i]
 684                                         ];
 685                                 }
 686                         }
 687                 }
 688
 689                 //Render the view
 690                 return $this->render('@RapsysAir/session/view.html.twig', ['title' => $title, 'section' => $section]+$context+$this->context);
 691         }
 692 }