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, $request->getLocale());
  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 warning 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 warning 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) {
 438                 //Fetch doctrine
 439                 $doctrine = $this->getDoctrine();
 440
 441                 //Set section
 442                 $section = $this->translator->trans('Sessions');
 443
 444                 //Set title
 445                 $title = $this->translator->trans($this->config['site']['title']).' - '.$section;
 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                 if (empty($session = $doctrine->getRepository(Session::class)->fetchOneById($id, $request->getLocale()))) {
 521                         throw $this->createNotFoundException($this->translator->trans('Unable to find session: %id%', ['%id%' => $id]));
 522                 }
 523
 524                 //Set section
 525                 $section = $this->translator->trans($session['l_title']);
 526
 527                 //Set title
 528                 $title = $this->translator->trans($this->config['site']['title']).' - '.$section.' - '.$this->translator->trans('Session %id%', ['%id%' => $id]);
 529
 530                 //Init context
 531                 $context = [];
 532
 533                 //Create application form for role_guest
 534                 if ($this->isGranted('ROLE_GUEST')) {
 535                         //Create ApplicationType form
 536                         $application = $this->createForm('Rapsys\AirBundle\Form\ApplicationType', null, [
 537                                 //Set the action
 538                                 'action' => $this->generateUrl('rapsys_air_application_add'),
 539                                 //Set the form attribute
 540                                 'attr' => [ 'class' => 'col' ],
 541                                 //Set admin
 542                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 543                                 //Set default user to current
 544                                 'user' => $this->getUser()->getId(),
 545                                 //Set default slot to current
 546                                 'slot' => $this->getDoctrine()->getRepository(Slot::class)->findOneById($session['t_id']),
 547                                 //Set default location to current
 548                                 'location' => $this->getDoctrine()->getRepository(Location::class)->findOneById($session['l_id']),
 549                         ]);
 550
 551                         //Add form to context
 552                         $context['application'] = $application->createView();
 553
 554                         //Set now
 555                         $now = new \DateTime('now');
 556
 557                         //Create SessionEditType form
 558                         $session_edit = $this->createForm('Rapsys\AirBundle\Form\SessionEditType', null, [
 559                                 //Set the action
 560                                 'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
 561                                 //Set the form attribute
 562                                 'attr' => [ 'class' => 'col' ],
 563                                 //Set admin
 564                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 565                                 //Set default user to current
 566                                 'user' => $this->getUser()->getId(),
 567                                 //Set begin
 568                                 'begin' => $session['begin'],
 569                                 //Set length
 570                                 'length' => $session['length'],
 571                                 //Set raincancel
 572                                 'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
 573                                 //Set cancel
 574                                 'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
 575                                 //Set modify
 576                                 'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
 577                                 //Set move
 578                                 'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
 579                                 //Set attribute
 580                                 'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
 581                                 //Set session
 582                                 'session' => $session['id']
 583                         ]);
 584
 585                         //Add form to context
 586                         $context['session_edit'] = $session_edit->createView();
 587                 //Create login form for anonymous
 588                 } elseif (!$this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
 589                         //Create ApplicationType form
 590                         $login = $this->createForm('Rapsys\UserBundle\Form\LoginType', null, [
 591                                 //Set the action
 592                                 'action' => $this->generateUrl('rapsys_user_login'),
 593                                 //Set the form attribute
 594                                 'attr' => [ 'class' => 'col' ]
 595                         ]);
 596
 597                         //Add form to context
 598                         $context['login'] = $login->createView();
 599                 }
 600
 601                 //Add session in context
 602                 $context['session'] = [
 603                         'id' => $id,
 604                         'date' => $session['date'],
 605                         'begin' => $session['begin'],
 606                         'start' => $session['start'],
 607                         'length' => $session['length'],
 608                         'stop' => $session['stop'],
 609                         'rainfall' => $session['rainfall'] !== null ? $session['rainfall'].' mm' : $session['rainfall'],
 610                         'rainrisk' => $session['rainrisk'] !== null ? ($session['rainrisk']*100).' %' : $session['rainrisk'],
 611                         'realfeel' => $session['realfeel'] !== null ? $session['realfeel'].' °C' : $session['realfeel'],
 612                         'realfeelmin' => $session['realfeelmin'] !== null ? $session['realfeelmin'].' °C' : $session['realfeelmin'],
 613                         'realfeelmax' => $session['realfeelmax'] !== null ? $session['realfeelmax'].' °C' : $session['realfeelmax'],
 614                         'temperature' => $session['temperature'] !== null ? $session['temperature'].' °C' : $session['temperature'],
 615                         'temperaturemin' => $session['temperaturemin'] !== null ? $session['temperaturemin'].' °C' : $session['temperaturemin'],
 616                         'temperaturemax' => $session['temperaturemax'] !== null ? $session['temperaturemax'].' °C' : $session['temperaturemax'],
 617                         'locked' => $session['locked'],
 618                         'created' => $session['created'],
 619                         'updated' => $session['updated'],
 620                         'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 621                         'application' => null,
 622                         'location' => [
 623                                 'id' => $session['l_id'],
 624                                 'at' => $this->translator->trans('at '.$session['l_title']),
 625                                 'short' => $this->translator->trans($session['l_short']),
 626                                 'title' => $this->translator->trans($session['l_title']),
 627                                 'address' => $session['l_address'],
 628                                 'zipcode' => $session['l_zipcode'],
 629                                 'city' => $session['l_city'],
 630                                 'latitude' => $session['l_latitude'],
 631                                 'longitude' => $session['l_longitude']
 632                         ],
 633                         'slot' => [
 634                                 'id' => $session['t_id'],
 635                                 'title' => $this->translator->trans($session['t_title'])
 636                         ],
 637                         'snippet' => [
 638                                 'id' => $session['p_id'],
 639                                 'description' => $session['p_description']
 640                         ],
 641                         'applications' => null
 642                 ];
 643
 644                 //With application
 645                 if (!empty($session['a_id'])) {
 646                         $context['session']['application'] = [
 647                                 'user' => [
 648                                         'id' => $session['au_id'],
 649                                         'title' => $session['au_pseudonym'],
 650                                         'donation' => $session['au_donation'],
 651                                         'site' => $session['au_site']
 652                                 ],
 653                                 'id' => $session['a_id'],
 654                                 'title' => $this->translator->trans('Application %id%', [ '%id%' => $session['a_id'] ]),
 655                         ];
 656                 }
 657
 658                 //With applications
 659                 if (!empty($session['sa_id'])) {
 660                         //Extract applications id
 661                         $session['sa_id'] = explode("\n", $session['sa_id']);
 662                         //Extract applications score
 663                         //XXX: score may be null before grant or for bad behaviour, replace NULL with 'NULL' to avoid silent drop in mysql
 664                         $session['sa_score'] = array_map(function($v){return $v==='NULL'?null:$v;}, explode("\n", $session['sa_score']));
 665                         //Extract applications created
 666                         $session['sa_created'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_created']));
 667                         //Extract applications updated
 668                         $session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 669                         //Extract applications canceled
 670                         //XXX: canceled is null before cancelation, replace NULL with 'NULL' to avoid silent drop in mysql
 671                         $session['sa_canceled'] = array_map(function($v){return $v==='NULL'?null:new \DateTime($v);}, explode("\n", $session['sa_canceled']));
 672
 673                         //Extract applications user id
 674                         $session['sau_id'] = explode("\n", $session['sau_id']);
 675                         //Extract applications user pseudonym
 676                         $session['sau_pseudonym'] = explode("\n", $session['sau_pseudonym']);
 677
 678                         //Init applications
 679                         $context['session']['applications'] = [];
 680                         foreach($session['sa_id'] as $i => $sa_id) {
 681                                 $context['session']['applications'][$sa_id] = [
 682                                         'user' => null,
 683                                         'score' => $session['sa_score'][$i],
 684                                         'created' => $session['sa_created'][$i],
 685                                         'updated' => $session['sa_updated'][$i],
 686                                         'canceled' => $session['sa_canceled'][$i]
 687                                 ];
 688                                 if (!empty($session['sau_id'][$i])) {
 689                                         $context['session']['applications'][$sa_id]['user'] = [
 690                                                 'id' => $session['sau_id'][$i],
 691                                                 'title' => $session['sau_pseudonym'][$i]
 692                                         ];
 693                                 }
 694                         }
 695                 }
 696
 697                 //Compute period
 698                 $period = new \DatePeriod(
 699                         //Start from first monday of week
 700                         new \DateTime('Monday this week'),
 701                         //Iterate on each day
 702                         new \DateInterval('P1D'),
 703                         //End with next sunday and 4 weeks
 704                         new \DateTime('Monday this week + 5 week')
 705                 );
 706
 707                 //Fetch locations
 708                 //XXX: we want to display all active locations anyway
 709                 $locations = $doctrine->getRepository(Location::class)->findTranslatedSortedByPeriod($this->translator, $period, $session['au_id']);
 710
 711                 //Render the view
 712                 return $this->render('@RapsysAir/session/view.html.twig', ['title' => $title, 'section' => $section, 'locations' => $locations]+$context+$this->context);
 713         }
 714 }