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

   1 <?php declare(strict_types=1);
   2
   3 /*
   4  * This file is part of the Rapsys AirBundle package.
   5  *
   6  * (c) Raphaël Gertz <symfony@rapsys.eu>
   7  *
   8  * For the full copyright and license information, please view the LICENSE
   9  * file that was distributed with this source code.
  10  */
  11
  12 namespace Rapsys\AirBundle\Controller;
  13
  14 use Symfony\Component\Asset\Packages;
  15 use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
  16 use Symfony\Component\Filesystem\Filesystem;
  17 use Symfony\Component\HttpFoundation\BinaryFileResponse;
  18 use Symfony\Component\HttpFoundation\Request;
  19 use Symfony\Component\HttpFoundation\Response;
  20 use Symfony\Component\Routing\Exception\MethodNotAllowedException;
  21 use Symfony\Component\Routing\Exception\ResourceNotFoundException;
  22 use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  23 use Symfony\Component\Routing\RequestContext;
  24
  25 use Rapsys\AirBundle\Entity\Application;
  26 use Rapsys\AirBundle\Entity\User;
  27 use Rapsys\AirBundle\Entity\Slot;
  28 use Rapsys\AirBundle\Entity\Session;
  29 use Rapsys\AirBundle\Entity\Location;
  30
  31 class SessionController extends AbstractController {
  32         /**
  33          * Edit session
  34          *
  35          * @desc Persist session and all required dependencies in database
  36          *
  37          * @param Request $request The request instance
  38          *
  39          * @return Response The rendered view or redirection
  40          *
  41          * @throws \RuntimeException When user has not at least guest role
  42          */
  43         public function edit(Request $request, $id): Response {
  44                 //Prevent non-guest to access here
  45                 $this->denyAccessUnlessGranted('ROLE_GUEST', null, $this->translator->trans('Unable to access this page without role %role%!', ['%role%' => $this->translator->trans('Guest')]));
  46
  47                 //Reject non post requests
  48                 if (!$request->isMethod('POST')) {
  49                         throw new \RuntimeException('Request method MUST be POST');
  50                 }
  51
  52                 //Get doctrine
  53                 $doctrine = $this->getDoctrine();
  54
  55                 //Set locale
  56                 $locale = $request->getLocale();
  57
  58                 //Fetch session
  59                 $session = $doctrine->getRepository(Session::class)->fetchOneById($id, $locale);
  60
  61                 //Check if
  62                 if (
  63                         //we are admin
  64                         !$this->isGranted('ROLE_ADMIN') &&
  65                         //or attributed user
  66                         $this->getUser()->getId() != $session['au_id'] &&
  67                         //or application without attributed user
  68                         $session['au_id'] !== null && !in_array($this->getUser()->getId(), explode("\n", $session['sau_id']))
  69                 ) {
  70                         //Prevent non admin and non attributed user access
  71                         throw $this->createAccessDeniedException();
  72                 }
  73
  74                 //Set now
  75                 $now = new \DateTime('now');
  76
  77                 //Create SessionType form
  78                 $form = $this->createForm('Rapsys\AirBundle\Form\SessionType', null, [
  79                         //Set the action
  80                         'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
  81                         //Set the form attribute
  82                         'attr' => [],
  83                         //Set admin
  84                         'admin' => $this->isGranted('ROLE_ADMIN'),
  85                         //Set default user to current
  86                         'user' => $this->getUser()->getId(),
  87                         //Set date
  88                         'date' => $session['date'],
  89                         //Set begin
  90                         'begin' => $session['begin'],
  91                         //Set length
  92                         'length' => $session['length'],
  93                         //Set raincancel
  94                         'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
  95                         //Set cancel
  96                         'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
  97                         //Set modify
  98                         'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
  99                         //Set move
 100                         'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
 101                         //Set attribute
 102                         'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
 103                         //Set session
 104                         'session' => $session['id']
 105                 ]);
 106
 107                 //Refill the fields in case of invalid form
 108                 $form->handleRequest($request);
 109
 110                 //Handle invalid data
 111                 if (!$form->isSubmitted() || !$form->isValid()) {
 112                         //Set page
 113                         $this->context['title'] = $this->translator->trans(!empty($session['au_id'])?'Session %id% by %pseudonym%':'Session %id%', ['%id%' => $id, '%pseudonym%' => $session['au_pseudonym']]);
 114
 115                         //Set facebook title
 116                         $this->context['facebook']['metas']['og:title'] = $this->context['title'].' '.$this->translator->trans('at '.$session['l_title']);
 117
 118                         //Set section
 119                         $this->context['section'] = $this->translator->trans($session['l_title']);
 120
 121                         //Set localization date formater
 122                         $intl = new \IntlDateFormatter($locale, \IntlDateFormatter::GREGORIAN, \IntlDateFormatter::SHORT);
 123
 124                         //Set description
 125                         $this->context['description'] = $this->translator->trans('Outdoor Argentine Tango session the %date%', [ '%date%' => $intl->format($session['start']) ]);
 126
 127                         //Set localization date formater
 128                         $intlDate = new \IntlDateFormatter($locale, \IntlDateFormatter::TRADITIONAL, \IntlDateFormatter::NONE);
 129
 130                         //Set localization time formater
 131                         $intlTime = new \IntlDateFormatter($locale, \IntlDateFormatter::NONE, \IntlDateFormatter::SHORT);
 132
 133                         //Set facebook image
 134                         $this->context['facebook'] += [
 135                                 'texts' => [
 136                                         $session['au_pseudonym'] => [
 137                                                 'font' => 'irishgrover',
 138                                                 'size' => 110
 139                                         ],
 140                                         ucfirst($intlDate->format($session['start']))."\n".$this->translator->trans('From %start% to %stop%', ['%start%' => $intlTime->format($session['start']), '%stop%' => $intlTime->format($session['stop'])]) => [
 141                                                 'align' => 'left'
 142                                         ],
 143                                         $this->translator->trans('at '.$session['l_title']) => [
 144                                                 'align' => 'right',
 145                                                 'font' => 'labelleaurore',
 146                                                 'size' => 75
 147                                         ]
 148                                 ],
 149                                 'updated' => $session['updated']->format('U')
 150                         ];
 151
 152                         //Add session in context
 153                         $this->context['session'] = [
 154                                 'id' => $id,
 155                                 'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 156                                 'location' => [
 157                                         'id' => $session['l_id'],
 158                                         'at' => $this->translator->trans('at '.$session['l_title'])
 159                                 ]
 160                         ];
 161
 162                         //Render the view
 163                         return $this->render('@RapsysAir/session/edit.html.twig', ['form' => $form->createView()]+$this->context);
 164                 }
 165
 166                 //Get manager
 167                 $manager = $doctrine->getManager();
 168
 169                 //Get data
 170                 $data = $form->getData();
 171
 172                 //Fetch session
 173                 $session = $doctrine->getRepository(Session::class)->findOneById($id);
 174
 175                 //Set user
 176                 $user = $this->getUser();
 177
 178                 //Replace with requested user for admin
 179                 if ($this->isGranted('ROLE_ADMIN') && !empty($data['user'])) {
 180                         $user = $doctrine->getRepository(User::class)->findOneById($data['user']);
 181                 }
 182
 183                 //Set datetime
 184                 $datetime = new \DateTime('now');
 185
 186                 //Set canceled time at start minus one day
 187                 $canceled = (clone $session->getStart())->sub(new \DateInterval('P1D'));
 188
 189                 //Set action
 190                 $action = [
 191                         'raincancel' => $form->has('raincancel') && $form->get('raincancel')->isClicked(),
 192                         'modify' => $form->has('modify') && $form->get('modify')->isClicked(),
 193                         'move' => $form->has('move') && $form->get('move')->isClicked(),
 194                         'cancel' => $form->has('cancel') && $form->get('cancel')->isClicked(),
 195                         'forcecancel' => $form->has('forcecancel') && $form->get('forcecancel')->isClicked(),
 196                         'attribute' => $form->has('attribute') && $form->get('attribute')->isClicked(),
 197                         'autoattribute' => $form->has('autoattribute') && $form->get('autoattribute')->isClicked(),
 198                         'lock' => $form->has('lock') && $form->get('lock')->isClicked(),
 199                 ];
 200
 201                 //With raincancel and application and (rainfall or admin)
 202                 if ($action['raincancel'] && ($application = $session->getApplication()) && ($session->getRainfall() >= 2 || $this->isGranted('ROLE_ADMIN'))) {
 203                         //Cancel application at start minus one day
 204                         $application->setCanceled($canceled);
 205
 206                         //Update time
 207                         $application->setUpdated($datetime);
 208
 209                         //Insufficient rainfall
 210                         //XXX: is admin
 211                         if ($session->getRainfall() < 2) {
 212                                 //Set score
 213                                 //XXX: magic cheat score 42
 214                                 $application->setScore(42);
 215                         }
 216
 217                         //Queue application save
 218                         $manager->persist($application);
 219
 220                         //Add notice in flash message
 221                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 222
 223                         //Update time
 224                         $session->setUpdated($datetime);
 225
 226                         //Queue session save
 227                         $manager->persist($session);
 228
 229                         //Add notice in flash message
 230                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 231                 //With modify
 232                 } elseif ($action['modify']) {
 233                         //With admin
 234                         if ($this->isGranted('ROLE_ADMIN')) {
 235                                 //Set date
 236                                 $session->setDate($data['date']);
 237                         }
 238
 239                         //Set begin
 240                         $session->setBegin($data['begin']);
 241
 242                         //Set length
 243                         $session->setLength($data['length']);
 244
 245                         //Update time
 246                         $session->setUpdated($datetime);
 247
 248                         //Queue session save
 249                         $manager->persist($session);
 250
 251                         //Add notice in flash message
 252                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 253                 //With move
 254                 } elseif ($action['move']) {
 255                         //Set location
 256                         $session->setLocation($doctrine->getRepository(Location::class)->findOneById($data['location']));
 257
 258                         //Update time
 259                         $session->setUpdated($datetime);
 260
 261                         //Queue session save
 262                         $manager->persist($session);
 263
 264                         //Add notice in flash message
 265                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 266                 //With cancel or forcecancel
 267                 } elseif ($action['cancel'] || $action['forcecancel']) {
 268                         //Get application
 269                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 270
 271                         //Not already canceled
 272                         if ($application->getCanceled() === null) {
 273                                 //Cancel application
 274                                 $application->setCanceled($datetime);
 275
 276                                 //Check if application is session application and (canceled 24h before start or forcecancel (as admin))
 277                                 #if ($session->getApplication() == $application && ($datetime < $canceled || $action['forcecancel'])) {
 278                                 if ($session->getApplication() == $application && $action['forcecancel']) {
 279                                         //Set score
 280                                         //XXX: magic cheat score 42
 281                                         $application->setScore(42);
 282
 283                                         //Unattribute session
 284                                         $session->setApplication(null);
 285
 286                                         //Update time
 287                                         $session->setUpdated($datetime);
 288
 289                                         //Queue session save
 290                                         $manager->persist($session);
 291
 292                                         //Add notice in flash message
 293                                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 294                                 }
 295                         //Already canceled
 296                         } else {
 297                                 //Uncancel application
 298                                 $application->setCanceled(null);
 299                         }
 300
 301                         //Update time
 302                         $application->setUpdated($datetime);
 303
 304                         //Queue application save
 305                         $manager->persist($application);
 306
 307                         //Add notice in flash message
 308                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 309                 //With attribute
 310                 } elseif ($action['attribute']) {
 311                         //Get application
 312                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 313
 314                         //Already canceled
 315                         if ($application->getCanceled() !== null) {
 316                                 //Uncancel application
 317                                 $application->setCanceled(null);
 318                         }
 319
 320                         //Set score
 321                         //XXX: magic cheat score 42
 322                         $application->setScore(42);
 323
 324                         //Update time
 325                         $application->setUpdated($datetime);
 326
 327                         //Queue application save
 328                         $manager->persist($application);
 329
 330                         //Add notice in flash message
 331                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 332
 333                         //Unattribute session
 334                         $session->setApplication($application);
 335
 336                         //Update time
 337                         $session->setUpdated($datetime);
 338
 339                         //Queue session save
 340                         $manager->persist($session);
 341
 342                         //Add notice in flash message
 343                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 344                 //With autoattribute
 345                 } elseif ($action['autoattribute']) {
 346                         //Get best application
 347                         //XXX: best application may not issue result while grace time or bad behaviour
 348                         if (!empty($application = $doctrine->getRepository(Session::class)->findBestApplicationById($id))) {
 349                                 //Attribute session
 350                                 $session->setApplication($application);
 351
 352                                 //Update time
 353                                 $session->setUpdated($datetime);
 354
 355                                 //Queue session save
 356                                 $manager->persist($session);
 357
 358                                 //Add notice in flash message
 359                                 $this->addFlash('notice', $this->translator->trans('Session %id% auto attributed', ['%id%' => $id]));
 360                         //No application
 361                         } else {
 362                                 //Add warning in flash message
 363                                 $this->addFlash('warning', $this->translator->trans('Session %id% not auto attributed', ['%id%' => $id]));
 364                         }
 365                 //With lock
 366                 } elseif ($action['lock']) {
 367                         //Already locked
 368                         if ($session->getLocked() !== null) {
 369                                 //Set uncanceled
 370                                 $canceled = null;
 371
 372                                 //Unlock session
 373                                 $session->setLocked(null);
 374                         //Not locked
 375                         } else {
 376                                 //Get application
 377                                 if ($application = $session->getApplication()) {
 378                                         //Set score
 379                                         //XXX: magic cheat score 42
 380                                         $application->setScore(42);
 381
 382                                         //Update time
 383                                         $application->setUpdated($datetime);
 384
 385                                         //Queue application save
 386                                         $manager->persist($application);
 387
 388                                         //Add notice in flash message
 389                                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 390                                 }
 391
 392                                 //Unattribute session
 393                                 $session->setApplication(null);
 394
 395                                 //Lock session
 396                                 $session->setLocked($datetime);
 397                         }
 398
 399                         //Update time
 400                         $session->setUpdated($datetime);
 401
 402                         //Queue session save
 403                         $manager->persist($session);
 404
 405                         //Add notice in flash message
 406                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 407                 //Unknown action
 408                 } else {
 409                         //Add warning in flash message
 410                         $this->addFlash('warning', $this->translator->trans('Session %id% not updated', ['%id%' => $id]));
 411                 }
 412
 413                 //Flush to get the ids
 414                 $manager->flush();
 415
 416                 //Extract and process referer
 417                 if ($referer = $request->headers->get('referer')) {
 418                         //Create referer request instance
 419                         $req = Request::create($referer);
 420
 421                         //Get referer path
 422                         $path = $req->getPathInfo();
 423
 424                         //Get referer query string
 425                         $query = $req->getQueryString();
 426
 427                         //Remove script name
 428                         $path = str_replace($request->getScriptName(), '', $path);
 429
 430                         //Try with referer path
 431                         try {
 432                                 //Save old context
 433                                 $oldContext = $this->router->getContext();
 434
 435                                 //Force clean context
 436                                 //XXX: prevent MethodNotAllowedException because current context method is POST in onevendor/symfony/routing/Matcher/Dumper/CompiledUrlMatcherTrait.php+42
 437                                 $this->router->setContext(new RequestContext());
 438
 439                                 //Retrieve route matching path
 440                                 $route = $this->router->match($path);
 441
 442                                 //Reset context
 443                                 $this->router->setContext($oldContext);
 444
 445                                 //Clear old context
 446                                 unset($oldContext);
 447
 448                                 //Extract name
 449                                 $name = $route['_route'];
 450
 451                                 //Remove route and controller from route defaults
 452                                 unset($route['_route'], $route['_controller']);
 453
 454                                 //Generate url
 455                                 return $this->redirectToRoute($name, $route);
 456                         //No route matched
 457                         } catch(MethodNotAllowedException|ResourceNotFoundException $e) {
 458                                 //Unset referer to fallback to default route
 459                                 unset($referer);
 460                         }
 461                 }
 462
 463                 //Redirect to cleanup the form
 464                 return $this->redirectToRoute('rapsys_air_session_view', ['id' => $id]);
 465         }
 466
 467         /**
 468          * List all sessions
 469          *
 470          * @desc Display all sessions with an application or login form
 471          *
 472          * @param Request $request The request instance
 473          *
 474          * @return Response The rendered view
 475          */
 476         public function index(Request $request): Response {
 477                 //Fetch doctrine
 478                 $doctrine = $this->getDoctrine();
 479
 480                 //Set section
 481                 $section = $this->translator->trans('Sessions');
 482
 483                 //Set description
 484                 $this->context['description'] = $this->translator->trans('Libre Air session list');
 485
 486                 //Set keywords
 487                 $this->context['keywords'] = [
 488                         $this->translator->trans('sessions'),
 489                         $this->translator->trans('session list'),
 490                         $this->translator->trans('listing'),
 491                         $this->translator->trans('Libre Air')
 492                 ];
 493
 494                 //Set title
 495                 $title = $this->translator->trans($this->config['site']['title']).' - '.$section;
 496
 497                 //Compute period
 498                 $period = new \DatePeriod(
 499                         //Start from first monday of week
 500                         new \DateTime('Monday this week'),
 501                         //Iterate on each day
 502                         new \DateInterval('P1D'),
 503                         //End with next sunday and 4 weeks
 504                         new \DateTime(
 505                                 $this->isGranted('IS_AUTHENTICATED_REMEMBERED')?'Monday this week + 3 week':'Monday this week + 2 week'
 506                         )
 507                 );
 508
 509                 //Fetch calendar
 510                 //TODO: highlight with current session route parameter
 511                 $calendar = $doctrine->getRepository(Session::class)->fetchCalendarByDatePeriod($this->translator, $period, null, $request->get('session'), !$this->isGranted('IS_AUTHENTICATED_REMEMBERED'), $request->getLocale());
 512
 513                 //Fetch locations
 514                 //XXX: we want to display all active locations anyway
 515                 $locations = $doctrine->getRepository(Location::class)->findTranslatedSortedByPeriod($this->translator, $period);
 516
 517                 //Render the view
 518                 return $this->render('@RapsysAir/session/index.html.twig', ['title' => $title, 'section' => $section, 'calendar' => $calendar, 'locations' => $locations]+$this->context);
 519         }
 520
 521         /**
 522          * List all sessions for tango argentin
 523          *
 524          * @desc Display all sessions in tango argentin json format
 525          *
 526          * @todo Drop it if unused by tangoargentin ???
 527          *
 528          * @param Request $request The request instance
 529          *
 530          * @return Response The rendered view or redirection
 531          */
 532         public function tangoargentin(Request $request): Response {
 533                 //Fetch doctrine
 534                 $doctrine = $this->getDoctrine();
 535
 536                 //Compute period
 537                 $period = new \DatePeriod(
 538                         //Start from first monday of week
 539                         new \DateTime('today'),
 540                         //Iterate on each day
 541                         new \DateInterval('P1D'),
 542                         //End with next sunday and 4 weeks
 543                         new \DateTime('+2 week')
 544                 );
 545
 546                 //Retrieve events to update
 547                 $sessions = $doctrine->getRepository(Session::class)->fetchAllByDatePeriod($period, $request->getLocale());
 548
 549                 //Init return array
 550                 $ret = [];
 551
 552                 //Iterate on sessions
 553                 foreach($sessions as $sessionId => $session) {
 554                         //Set title
 555                         $title = $session['au_pseudonym'].' '.$this->translator->trans('at '.$session['l_title']);
 556
 557                         //Use Transliterator if available
 558                         if (class_exists('Transliterator')) {
 559                                 $trans = \Transliterator::create('Any-Latin; Latin-ASCII; Upper()');
 560                                 $title = $trans->transliterate($title);
 561                         } else {
 562                                 $title = strtoupper($title);
 563                         }
 564
 565                         //Set rate
 566                         $rate = 'Au chapeau';
 567
 568                         //Without hat
 569                         if ($session['p_hat'] === null) {
 570                                 //Set rate
 571                                 $rate = 'Gratuit';
 572
 573                                 //With rate
 574                                 if ($session['p_rate'] !== null) {
 575                                         //Set rate
 576                                         $rate = $session['p_rate'].' €';
 577                                 }
 578                         //With hat
 579                         } else {
 580                                 //With rate
 581                                 if ($session['p_rate'] !== null) {
 582                                         //Set rate
 583                                         $rate .= ', idéalement '.$session['p_rate'].' €';
 584                                 }
 585                         }
 586
 587                         //Store session data
 588                         $ret[$sessionId] = [
 589                                 'start' => $session['start']->format(\DateTime::ISO8601),
 590                                 'stop' => $session['start']->format(\DateTime::ISO8601),
 591                                 'title' => $title,
 592                                 'short' => $session['p_short'],
 593                                 'rate' => $rate,
 594                                 'location' => implode(' ', [$session['l_address'], $session['l_zipcode'], $session['l_city']]),
 595                                 'status' => (empty($session['a_canceled']) && empty($session['locked']))?'confirmed':'cancelled',
 596                                 'updated' => $session['updated']->format(\DateTime::ISO8601),
 597                                 'organizer' => $session['au_forename'],
 598                                 'source' => $this->router->generate('rapsys_air_session_view', ['id' => $sessionId], UrlGeneratorInterface::ABSOLUTE_URL)
 599                         ];
 600                 }
 601
 602                 //Set response
 603                 $response = new Response(json_encode($ret));
 604
 605                 //Set header
 606                 $response->headers->set('Content-Type', 'application/json');
 607
 608                 //Send response
 609                 return $response;
 610         }
 611
 612         /**
 613          * Display session
 614          *
 615          * @todo XXX: TODO: add <link rel="prev|next" for sessions or classes ? />
 616          * @todo XXX: TODO: like described in: https://www.alsacreations.com/article/lire/1400-attribut-rel-relations.html#xnf-rel-attribute
 617          * @todo XXX: TODO: or here: http://microformats.org/wiki/existing-rel-values#HTML5_link_type_extensions
 618          *
 619          * @desc Display session by id with an application or login form
 620          *
 621          * @param Request $request The request instance
 622          * @param int $id The session id
 623          *
 624          * @return Response The rendered view
 625          */
 626         public function view(Request $request, $id): Response {
 627                 //Fetch doctrine
 628                 $doctrine = $this->getDoctrine();
 629
 630                 //Set locale
 631                 $locale = $request->getLocale();
 632
 633                 //Fetch session
 634                 if (empty($session = $doctrine->getRepository(Session::class)->fetchOneById($id, $locale))) {
 635                         throw $this->createNotFoundException($this->translator->trans('Unable to find session: %id%', ['%id%' => $id]));
 636                 }
 637
 638                 //Create response
 639                 $response = new Response();
 640
 641                 //Set etag
 642                 $response->setEtag(md5(serialize($session)));
 643
 644                 //With logged user
 645                 if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
 646                         //Set last modified
 647                         $response->setLastModified(new \DateTime('-1 year'));
 648
 649                         //Set as private
 650                         $response->setPrivate();
 651                 //Without logged user
 652                 } else {
 653                         //Extract applications updated
 654                         $session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 655
 656                         //Get last modified
 657                         $lastModified = max(array_merge([$session['updated'], $session['l_updated'], $session['t_updated'], $session['p_updated']], $session['sa_updated']));
 658
 659                         //Set last modified
 660                         $response->setLastModified($lastModified);
 661
 662                         //Set as public
 663                         $response->setPublic();
 664
 665                         //Without role and modification
 666                         if ($response->isNotModified($request)) {
 667                                 //Return 304 response
 668                                 return $response;
 669                         }
 670                 }
 671
 672                 //Set localization date formater
 673                 $intl = new \IntlDateFormatter($locale, \IntlDateFormatter::GREGORIAN, \IntlDateFormatter::SHORT);
 674
 675                 //Set section
 676                 $this->context['section'] = $this->translator->trans($session['l_title']);
 677
 678                 //Set description
 679                 $this->context['description'] = $this->translator->trans('Outdoor Argentine Tango session the %date%', [ '%date%' => $intl->format($session['start']) ]);
 680
 681                 //Set keywords
 682                 $this->context['keywords'] = [
 683                         $this->translator->trans('outdoor'),
 684                         $this->translator->trans('Argentine Tango'),
 685                 ];
 686
 687                 //Set localization date formater
 688                 $intlDate = new \IntlDateFormatter($locale, \IntlDateFormatter::TRADITIONAL, \IntlDateFormatter::NONE);
 689
 690                 //Set localization time formater
 691                 $intlTime = new \IntlDateFormatter($locale, \IntlDateFormatter::NONE, \IntlDateFormatter::SHORT);
 692
 693                 //Set facebook image
 694                 $this->context['facebook'] = [
 695                         'texts' => [
 696                                 $session['au_pseudonym'] => [
 697                                         'font' => 'irishgrover',
 698                                         'size' => 110
 699                                 ],
 700                                 ucfirst($intlDate->format($session['start']))."\n".$this->translator->trans('From %start% to %stop%', ['%start%' => $intlTime->format($session['start']), '%stop%' => $intlTime->format($session['stop'])]) => [
 701                                         'align' => 'left'
 702                                 ],
 703                                 $this->translator->trans('at '.$session['l_title']) => [
 704                                         'align' => 'right',
 705                                         'font' => 'labelleaurore',
 706                                         'size' => 75
 707                                 ]
 708                         ],
 709                         'updated' => $session['updated']->format('U')
 710                 ]+$this->context['facebook'];
 711
 712                 //With granted session
 713                 if (!empty($session['au_id'])) {
 714                         array_unshift($this->context['keywords'], $session['au_pseudonym']);
 715                 }
 716
 717                 //Set page
 718                 $this->context['title'] = $this->translator->trans(!empty($session['au_id'])?'Session %id% by %pseudonym%':'Session %id%', ['%id%' => $id, '%pseudonym%' => $session['au_pseudonym']]);
 719
 720                 //Set facebook title
 721                 $this->context['facebook']['metas']['og:title'] = $this->context['title'].' '.$this->translator->trans('at '.$session['l_title']);
 722
 723                 //Create application form for role_guest
 724                 if ($this->isGranted('ROLE_GUEST')) {
 725                         //Set now
 726                         $now = new \DateTime('now');
 727
 728                         //Create SessionType form
 729                         $sessionForm = $this->createForm('Rapsys\AirBundle\Form\SessionType', null, [
 730                                 //Set the action
 731                                 'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
 732                                 //Set the form attribute
 733                                 'attr' => [ 'class' => 'col' ],
 734                                 //Set admin
 735                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 736                                 //Set default user to current
 737                                 'user' => $this->getUser()->getId(),
 738                                 //Set date
 739                                 'date' => $session['date'],
 740                                 //Set begin
 741                                 'begin' => $session['begin'],
 742                                 //Set length
 743                                 'length' => $session['length'],
 744                                 //Set raincancel
 745                                 'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
 746                                 //Set cancel
 747                                 'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
 748                                 //Set modify
 749                                 'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
 750                                 //Set move
 751                                 'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
 752                                 //Set attribute
 753                                 'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
 754                                 //Set session
 755                                 'session' => $session['id']
 756                         ]);
 757
 758                         //Add form to context
 759                         $this->context['forms']['session'] = $sessionForm->createView();
 760                 }
 761
 762                 //Add session in context
 763                 $this->context['session'] = [
 764                         'id' => $id,
 765                         'date' => $session['date'],
 766                         'begin' => $session['begin'],
 767                         'start' => $session['start'],
 768                         'length' => $session['length'],
 769                         'stop' => $session['stop'],
 770                         'rainfall' => $session['rainfall'] !== null ? $session['rainfall'].' mm' : $session['rainfall'],
 771                         'rainrisk' => $session['rainrisk'] !== null ? ($session['rainrisk']*100).' %' : $session['rainrisk'],
 772                         'realfeel' => $session['realfeel'] !== null ? $session['realfeel'].' °C' : $session['realfeel'],
 773                         'realfeelmin' => $session['realfeelmin'] !== null ? $session['realfeelmin'].' °C' : $session['realfeelmin'],
 774                         'realfeelmax' => $session['realfeelmax'] !== null ? $session['realfeelmax'].' °C' : $session['realfeelmax'],
 775                         'temperature' => $session['temperature'] !== null ? $session['temperature'].' °C' : $session['temperature'],
 776                         'temperaturemin' => $session['temperaturemin'] !== null ? $session['temperaturemin'].' °C' : $session['temperaturemin'],
 777                         'temperaturemax' => $session['temperaturemax'] !== null ? $session['temperaturemax'].' °C' : $session['temperaturemax'],
 778                         'locked' => $session['locked'],
 779                         'created' => $session['created'],
 780                         'updated' => $session['updated'],
 781                         'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 782                         'application' => null,
 783                         'location' => [
 784                                 'id' => $session['l_id'],
 785                                 'at' => $this->translator->trans('at '.$session['l_title']),
 786                                 'title' => $this->translator->trans($session['l_title']),
 787                                 'address' => $session['l_address'],
 788                                 'zipcode' => $session['l_zipcode'],
 789                                 'city' => $session['l_city'],
 790                                 'latitude' => $session['l_latitude'],
 791                                 'longitude' => $session['l_longitude']
 792                         ],
 793                         'slot' => [
 794                                 'id' => $session['t_id'],
 795                                 'title' => $this->translator->trans($session['t_title'])
 796                         ],
 797                         'snippet' => [
 798                                 'id' => $session['p_id'],
 799                                 'description' => $session['p_description'],
 800                                 'class' => $session['p_class'],
 801                                 'contact' => $session['p_contact'],
 802                                 'donate' => $session['p_donate'],
 803                                 'link' => $session['p_link'],
 804                                 'profile' => $session['p_profile'],
 805                                 'rate' => $session['p_rate'],
 806                                 'hat' => $session['p_hat']
 807                         ],
 808                         'applications' => null
 809                 ];
 810
 811                 //With application
 812                 if (!empty($session['a_id'])) {
 813                         $this->context['session']['application'] = [
 814                                 'user' => [
 815                                         'id' => $session['au_id'],
 816                                         'by' => $this->translator->trans('by %pseudonym%', [ '%pseudonym%' => $session['au_pseudonym'] ]),
 817                                         'title' => $session['au_pseudonym']
 818                                 ],
 819                                 'id' => $session['a_id'],
 820                                 'canceled' => $session['a_canceled'],
 821                                 'title' => $this->translator->trans('Application %id%', [ '%id%' => $session['a_id'] ]),
 822                         ];
 823                 }
 824
 825                 //With applications
 826                 if (!empty($session['sa_id'])) {
 827                         //Extract applications id
 828                         $session['sa_id'] = explode("\n", $session['sa_id']);
 829                         //Extract applications score
 830                         //XXX: score may be null before grant or for bad behaviour, replace NULL with 'NULL' to avoid silent drop in mysql
 831                         $session['sa_score'] = array_map(function($v){return $v==='NULL'?null:$v;}, explode("\n", $session['sa_score']));
 832                         //Extract applications created
 833                         $session['sa_created'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_created']));
 834                         //Extract applications updated
 835                         //XXX: done earlied when computing last modified
 836                         #$session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 837                         //Extract applications canceled
 838                         //XXX: canceled is null before cancelation, replace NULL with 'NULL' to avoid silent drop in mysql
 839                         $session['sa_canceled'] = array_map(function($v){return $v==='NULL'?null:new \DateTime($v);}, explode("\n", $session['sa_canceled']));
 840
 841                         //Extract applications user id
 842                         $session['sau_id'] = explode("\n", $session['sau_id']);
 843                         //Extract applications user pseudonym
 844                         $session['sau_pseudonym'] = explode("\n", $session['sau_pseudonym']);
 845
 846                         //Init applications
 847                         $this->context['session']['applications'] = [];
 848                         foreach($session['sa_id'] as $i => $sa_id) {
 849                                 $this->context['session']['applications'][$sa_id] = [
 850                                         'user' => null,
 851                                         'score' => $session['sa_score'][$i],
 852                                         'created' => $session['sa_created'][$i],
 853                                         'updated' => $session['sa_updated'][$i],
 854                                         'canceled' => $session['sa_canceled'][$i]
 855                                 ];
 856                                 if (!empty($session['sau_id'][$i])) {
 857                                         $this->context['session']['applications'][$sa_id]['user'] = [
 858                                                 'id' => $session['sau_id'][$i],
 859                                                 'title' => $session['sau_pseudonym'][$i]
 860                                         ];
 861                                 }
 862                         }
 863                 }
 864
 865                 //Compute period
 866                 $period = new \DatePeriod(
 867                         //Start from first monday of week
 868                         new \DateTime('Monday this week'),
 869                         //Iterate on each day
 870                         new \DateInterval('P1D'),
 871                         //End with next sunday and 4 weeks
 872                         new \DateTime(
 873                                 $this->isGranted('IS_AUTHENTICATED_REMEMBERED')?'Monday this week + 3 week':'Monday this week + 2 week'
 874                         )
 875                 );
 876
 877                 //Fetch locations
 878                 //XXX: we want to display all active locations anyway
 879                 $locations = $doctrine->getRepository(Location::class)->findTranslatedSortedByPeriod($this->translator, $period, $session['au_id']);
 880
 881                 //Render the view
 882                 return $this->render('@RapsysAir/session/view.html.twig', ['locations' => $locations]+$this->context, $response);
 883         }
 884 }