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

   1 <?php
   2
   3 namespace Rapsys\AirBundle\Controller;
   4
   5 use Symfony\Component\Asset\Packages;
   6 use Symfony\Component\Filesystem\Exception\IOExceptionInterface;
   7 use Symfony\Component\Filesystem\Filesystem;
   8 use Symfony\Component\HttpFoundation\BinaryFileResponse;
   9 use Symfony\Component\HttpFoundation\Request;
  10 use Symfony\Component\HttpFoundation\Response;
  11 use Symfony\Component\Routing\Exception\MethodNotAllowedException;
  12 use Symfony\Component\Routing\Exception\ResourceNotFoundException;
  13 use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  14 use Symfony\Component\Routing\RequestContext;
  15
  16 use Rapsys\AirBundle\Entity\Application;
  17 use Rapsys\AirBundle\Entity\User;
  18 use Rapsys\AirBundle\Entity\Slot;
  19 use Rapsys\AirBundle\Entity\Session;
  20 use Rapsys\AirBundle\Entity\Location;
  21
  22 class SessionController extends DefaultController {
  23         /**
  24          * Edit session
  25          *
  26          * @desc Persist session and all required dependencies in database
  27          *
  28          * @param Request $request The request instance
  29          *
  30          * @return Response The rendered view or redirection
  31          *
  32          * @throws \RuntimeException When user has not at least guest role
  33          */
  34         public function edit(Request $request, $id): Response {
  35                 //Prevent non-guest to access here
  36                 $this->denyAccessUnlessGranted('ROLE_GUEST', null, $this->translator->trans('Unable to access this page without role %role%!', ['%role%' => $this->translator->trans('Guest')]));
  37
  38                 //Reject non post requests
  39                 if (!$request->isMethod('POST')) {
  40                         throw new \RuntimeException('Request method MUST be POST');
  41                 }
  42
  43                 //Get doctrine
  44                 $doctrine = $this->getDoctrine();
  45
  46                 //Set locale
  47                 $locale = $request->getLocale();
  48
  49                 //Fetch session
  50                 $session = $doctrine->getRepository(Session::class)->fetchOneById($id, $locale);
  51
  52                 //Check if
  53                 if (
  54                         //we are admin
  55                         !$this->isGranted('ROLE_ADMIN') &&
  56                         //or attributed user
  57                         $this->getUser()->getId() != $session['au_id'] &&
  58                         //or application without attributed user
  59                         $session['au_id'] !== null && !in_array($this->getUser()->getId(), explode("\n", $session['sau_id']))
  60                 ) {
  61                         //Prevent non admin and non attributed user access
  62                         throw $this->createAccessDeniedException();
  63                 }
  64
  65                 //Set now
  66                 $now = new \DateTime('now');
  67
  68                 //Create SessionType form
  69                 $form = $this->createForm('Rapsys\AirBundle\Form\SessionType', null, [
  70                         //Set the action
  71                         'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
  72                         //Set the form attribute
  73                         'attr' => [],
  74                         //Set admin
  75                         'admin' => $this->isGranted('ROLE_ADMIN'),
  76                         //Set default user to current
  77                         'user' => $this->getUser()->getId(),
  78                         //Set begin
  79                         'begin' => $session['begin'],
  80                         //Set length
  81                         'length' => $session['length'],
  82                         //Set raincancel
  83                         'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
  84                         //Set cancel
  85                         'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
  86                         //Set modify
  87                         'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
  88                         //Set move
  89                         'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
  90                         //Set attribute
  91                         'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
  92                         //Set session
  93                         'session' => $session['id']
  94                 ]);
  95
  96                 //Refill the fields in case of invalid form
  97                 $form->handleRequest($request);
  98
  99                 //Handle invalid data
 100                 #if (true) { $form->isValid();
 101                 //TODO: mettre une contrainte sur un des boutons submit, je sais pas encore comment
 102                 if (!$form->isValid()) {
 103                         //Set page
 104                         $this->context['page']['title'] = $this->translator->trans(!empty($session['au_id'])?'Session %id% by %pseudonym%':'Session %id%', ['%id%' => $id, '%pseudonym%' => $session['au_pseudonym']]);
 105
 106                         //Set facebook title
 107                         $this->context['ogps']['title'] = $this->context['page']['title'].' '.$this->translator->trans('at '.$session['l_title']);
 108
 109                         //Set section
 110                         $this->context['page']['section'] = $this->translator->trans($session['l_title']);
 111
 112                         //Set localization date formater
 113                         $intlDate = new \IntlDateFormatter($locale, \IntlDateFormatter::TRADITIONAL, \IntlDateFormatter::NONE);
 114
 115                         //Set localization time formater
 116                         $intlTime = new \IntlDateFormatter($locale, \IntlDateFormatter::NONE, \IntlDateFormatter::SHORT);
 117
 118                         //Set facebook image
 119                         $this->context['facebook'] += [
 120                                 'texts' => [
 121                                         $session['au_pseudonym'] => [
 122                                                 'font' => 'irishgrover',
 123                                                 'size' => 110
 124                                         ],
 125                                         ucfirst($intlDate->format($session['start']))."\n".$this->translator->trans('From %start% to %stop%', ['%start%' => $intlTime->format($session['start']), '%stop%' => $intlTime->format($session['stop'])]) => [
 126                                                 'align' => 'left'
 127                                         ],
 128                                         $this->translator->trans('at '.$session['l_title']) => [
 129                                                 'align' => 'right',
 130                                                 'font' => 'labelleaurore',
 131                                                 'size' => 75
 132                                         ]
 133                                 ],
 134                                 'updated' => $session['updated']->format('U')
 135                         ];
 136
 137                         //Add session in context
 138                         $this->context['session'] = [
 139                                 'id' => $id,
 140                                 'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 141                                 'location' => [
 142                                         'id' => $session['l_id'],
 143                                         'at' => $this->translator->trans('at '.$session['l_title'])
 144                                 ]
 145                         ];
 146
 147                         //Render the view
 148                         return $this->render('@RapsysAir/session/edit.html.twig', ['form' => $form->createView()]+$this->context);
 149                 }
 150
 151                 //Get manager
 152                 $manager = $doctrine->getManager();
 153
 154                 //Get data
 155                 $data = $form->getData();
 156
 157                 //Fetch session
 158                 $session = $doctrine->getRepository(Session::class)->findOneById($id);
 159
 160                 //Set user
 161                 $user = $this->getUser();
 162
 163                 //Replace with requested user for admin
 164                 if ($this->isGranted('ROLE_ADMIN') && !empty($data['user'])) {
 165                         $user = $doctrine->getRepository(User::class)->findOneById($data['user']);
 166                 }
 167
 168                 //Set datetime
 169                 $datetime = new \DateTime('now');
 170
 171                 //Set canceled time at start minus one day
 172                 $canceled = (clone $session->getStart())->sub(new \DateInterval('P1D'));
 173
 174                 //Set action
 175                 $action = [
 176                         'raincancel' => $form->has('raincancel') && $form->get('raincancel')->isClicked(),
 177                         'modify' => $form->has('modify') && $form->get('modify')->isClicked(),
 178                         'move' => $form->has('move') && $form->get('move')->isClicked(),
 179                         'cancel' => $form->has('cancel') && $form->get('cancel')->isClicked(),
 180                         'forcecancel' => $form->has('forcecancel') && $form->get('forcecancel')->isClicked(),
 181                         'attribute' => $form->has('attribute') && $form->get('attribute')->isClicked(),
 182                         'autoattribute' => $form->has('autoattribute') && $form->get('autoattribute')->isClicked(),
 183                         'lock' => $form->has('lock') && $form->get('lock')->isClicked(),
 184                 ];
 185
 186                 //With raincancel and application and (rainfall or admin)
 187                 if ($action['raincancel'] && ($application = $session->getApplication()) && ($session->getRainfall() >= 2 || $this->isGranted('ROLE_ADMIN'))) {
 188                         //Cancel application at start minus one day
 189                         $application->setCanceled($canceled);
 190
 191                         //Update time
 192                         $application->setUpdated($datetime);
 193
 194                         //Insufficient rainfall
 195                         //XXX: is admin
 196                         if ($session->getRainfall() < 2) {
 197                                 //Set score
 198                                 //XXX: magic cheat score 42
 199                                 $application->setScore(42);
 200                         }
 201
 202                         //Queue application save
 203                         $manager->persist($application);
 204
 205                         //Add notice in flash message
 206                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 207
 208                         //Update time
 209                         $session->setUpdated($datetime);
 210
 211                         //Queue session save
 212                         $manager->persist($session);
 213
 214                         //Add notice in flash message
 215                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 216                 //With modify
 217                 } elseif ($action['modify']) {
 218                         //Set begin
 219                         $session->setBegin($data['begin']);
 220
 221                         //Set length
 222                         $session->setLength($data['length']);
 223
 224                         //Update time
 225                         $session->setUpdated($datetime);
 226
 227                         //Queue session save
 228                         $manager->persist($session);
 229
 230                         //Add notice in flash message
 231                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 232                 //With move
 233                 } elseif ($action['move']) {
 234                         //Set location
 235                         $session->setLocation($doctrine->getRepository(Location::class)->findOneById($data['location']));
 236
 237                         //Update time
 238                         $session->setUpdated($datetime);
 239
 240                         //Queue session save
 241                         $manager->persist($session);
 242
 243                         //Add notice in flash message
 244                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 245                 //With cancel or forcecancel
 246                 } elseif ($action['cancel'] || $action['forcecancel']) {
 247                         //Get application
 248                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 249
 250                         //Not already canceled
 251                         if ($application->getCanceled() === null) {
 252                                 //Cancel application
 253                                 $application->setCanceled($datetime);
 254
 255                                 //Check if application is session application and (canceled 24h before start or forcecancel (as admin))
 256                                 #if ($session->getApplication() == $application && ($datetime < $canceled || $action['forcecancel'])) {
 257                                 if ($session->getApplication() == $application && $action['forcecancel']) {
 258                                         //Set score
 259                                         //XXX: magic cheat score 42
 260                                         $application->setScore(42);
 261
 262                                         //Unattribute session
 263                                         $session->setApplication(null);
 264
 265                                         //Update time
 266                                         $session->setUpdated($datetime);
 267
 268                                         //Queue session save
 269                                         $manager->persist($session);
 270
 271                                         //Add notice in flash message
 272                                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 273                                 }
 274                         //Already canceled
 275                         } else {
 276                                 //Uncancel application
 277                                 $application->setCanceled(null);
 278                         }
 279
 280                         //Update time
 281                         $application->setUpdated($datetime);
 282
 283                         //Queue application save
 284                         $manager->persist($application);
 285
 286                         //Add notice in flash message
 287                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 288                 //With attribute
 289                 } elseif ($action['attribute']) {
 290                         //Get application
 291                         $application = $doctrine->getRepository(Application::class)->findOneBySessionUser($session, $user);
 292
 293                         //Already canceled
 294                         if ($application->getCanceled() !== null) {
 295                                 //Uncancel application
 296                                 $application->setCanceled(null);
 297                         }
 298
 299                         //Set score
 300                         //XXX: magic cheat score 42
 301                         $application->setScore(42);
 302
 303                         //Update time
 304                         $application->setUpdated($datetime);
 305
 306                         //Queue application save
 307                         $manager->persist($application);
 308
 309                         //Add notice in flash message
 310                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 311
 312                         //Unattribute session
 313                         $session->setApplication($application);
 314
 315                         //Update time
 316                         $session->setUpdated($datetime);
 317
 318                         //Queue session save
 319                         $manager->persist($session);
 320
 321                         //Add notice in flash message
 322                         $this->addFlash('notice', $this->translator->trans('Session %id% updated', ['%id%' => $id]));
 323                 //With autoattribute
 324                 } elseif ($action['autoattribute']) {
 325                         //Get best application
 326                         //XXX: best application may not issue result while grace time or bad behaviour
 327                         if (!empty($application = $doctrine->getRepository(Session::class)->findBestApplicationById($id))) {
 328                                 //Attribute session
 329                                 $session->setApplication($application);
 330
 331                                 //Update time
 332                                 $session->setUpdated($datetime);
 333
 334                                 //Queue session save
 335                                 $manager->persist($session);
 336
 337                                 //Add notice in flash message
 338                                 $this->addFlash('notice', $this->translator->trans('Session %id% auto attributed', ['%id%' => $id]));
 339                         //No application
 340                         } else {
 341                                 //Add warning in flash message
 342                                 $this->addFlash('warning', $this->translator->trans('Session %id% not auto attributed', ['%id%' => $id]));
 343                         }
 344                 //With lock
 345                 } elseif ($action['lock']) {
 346                         //Already locked
 347                         if ($session->getLocked() !== null) {
 348                                 //Set uncanceled
 349                                 $canceled = null;
 350
 351                                 //Unlock session
 352                                 $session->setLocked(null);
 353                         //Not locked
 354                         } else {
 355                                 //Get application
 356                                 if ($application = $session->getApplication()) {
 357                                         //Set score
 358                                         //XXX: magic cheat score 42
 359                                         $application->setScore(42);
 360
 361                                         //Update time
 362                                         $application->setUpdated($datetime);
 363
 364                                         //Queue application save
 365                                         $manager->persist($application);
 366
 367                                         //Add notice in flash message
 368                                         $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 369                                 }
 370
 371                                 //Unattribute session
 372                                 $session->setApplication(null);
 373
 374                                 //Lock session
 375                                 $session->setLocked($datetime);
 376                         }
 377
 378 #                       //Get applications
 379 #                       $applications = $doctrine->getRepository(Application::class)->findBySession($session);
 380 #
 381 #                       //Not empty
 382 #                       if (!empty($applications)) {
 383 #                               //Iterate on each applications
 384 #                               foreach($applications as $application) {
 385 #                                       //Cancel application
 386 #                                       $application->setCanceled($canceled);
 387 #
 388 #                                       //Update time
 389 #                                       $application->setUpdated($datetime);
 390 #
 391 #                                       //Queue application save
 392 #                                       $manager->persist($application);
 393 #
 394 #                                       //Add notice in flash message
 395 #                                       $this->addFlash('notice', $this->translator->trans('Application %id% updated', ['%id%' => $application->getId()]));
 396 #                               }
 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'));
 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_short']);
 556                         //Use Transliterator if available
 557                         if (class_exists('Transliterator')) {
 558                                 $trans = \Transliterator::create('Any-Latin; Latin-ASCII; Upper()');
 559                                 $title = $trans->transliterate($title);
 560                         } else {
 561                                 $title = strtoupper($title);
 562                         }
 563                         //Store session data
 564                         $ret[$sessionId] = [
 565                                 'start' => $session['start']->format(\DateTime::ISO8601),
 566                                 'stop' => $session['start']->format(\DateTime::ISO8601),
 567                                 'title' => $title,
 568                                 'short' => $session['p_short'],
 569                                 'rate' => is_null($session['p_rate'])?'Au chapeau':$session['p_rate'].' euro'.($session['p_rate']>1?'s':''),
 570                                 'location' => implode(' ', [$session['l_address'], $session['l_zipcode'], $session['l_city']]),
 571                                 'status' => (empty($session['a_canceled']) && empty($session['locked']))?'confirmed':'cancelled',
 572                                 'updated' => $session['updated']->format(\DateTime::ISO8601),
 573                                 'organizer' => $session['au_forename'],
 574                                 'website' => $this->router->generate('rapsys_air_session_view', ['id' => $sessionId], UrlGeneratorInterface::ABSOLUTE_URL)
 575                         ];
 576                 }
 577
 578                 //Set response
 579                 $response = new Response(json_encode($ret));
 580
 581                 //Set header
 582                 $response->headers->set('Content-Type', 'application/json');
 583
 584                 //Send response
 585                 return $response;
 586         }
 587
 588         /**
 589          * Display session
 590          *
 591          * @todo XXX: TODO: add <link rel="prev|next" for sessions or classes ? />
 592          * @todo XXX: TODO: like described in: https://www.alsacreations.com/article/lire/1400-attribut-rel-relations.html#xnf-rel-attribute
 593          * @todo XXX: TODO: or here: http://microformats.org/wiki/existing-rel-values#HTML5_link_type_extensions
 594          *
 595          * @desc Display session by id with an application or login form
 596          *
 597          * @param Request $request The request instance
 598          * @param int $id The session id
 599          *
 600          * @return Response The rendered view
 601          */
 602         public function view(Request $request, $id): Response {
 603                 //Fetch doctrine
 604                 $doctrine = $this->getDoctrine();
 605
 606                 //Set locale
 607                 $locale = $request->getLocale();
 608
 609                 //Fetch session
 610                 if (empty($session = $doctrine->getRepository(Session::class)->fetchOneById($id, $locale))) {
 611                         throw $this->createNotFoundException($this->translator->trans('Unable to find session: %id%', ['%id%' => $id]));
 612                 }
 613
 614                 //Create response
 615                 $response = new Response();
 616
 617                 //Set etag
 618                 $response->setEtag(md5(serialize($session)));
 619
 620                 //With logged user
 621                 if ($this->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
 622                         //Set last modified
 623                         $response->setLastModified(new \DateTime('-1 year'));
 624
 625                         //Set as private
 626                         $response->setPrivate();
 627                 //Without logged user
 628                 } else {
 629                         //Extract applications updated
 630                         $session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 631
 632                         //Get last modified
 633                         $lastModified = max(array_merge([$session['updated'], $session['l_updated'], $session['t_updated'], $session['p_updated']], $session['sa_updated']));
 634
 635                         //Set last modified
 636                         $response->setLastModified($lastModified);
 637
 638                         //Set as public
 639                         $response->setPublic();
 640
 641                         //Without role and modification
 642                         if ($response->isNotModified($request)) {
 643                                 //Return 304 response
 644                                 return $response;
 645                         }
 646                 }
 647
 648                 //Set localization date formater
 649                 $intl = new \IntlDateFormatter($locale, \IntlDateFormatter::GREGORIAN, \IntlDateFormatter::SHORT);
 650
 651                 //Set section
 652                 $this->context['page']['section'] = $this->translator->trans($session['l_title']);
 653
 654                 //Set description
 655                 $this->context['page']['description'] = $this->translator->trans('Outdoor Argentine Tango session the %date%', [ '%date%' => $intl->format($session['start']) ]);
 656
 657                 //Set keywords
 658                 $this->context['keywords'] = [
 659                         $this->translator->trans('outdoor'),
 660                         $this->translator->trans('Argentine Tango'),
 661                 ];
 662
 663                 //Set localization date formater
 664                 $intlDate = new \IntlDateFormatter($locale, \IntlDateFormatter::TRADITIONAL, \IntlDateFormatter::NONE);
 665
 666                 //Set localization time formater
 667                 $intlTime = new \IntlDateFormatter($locale, \IntlDateFormatter::NONE, \IntlDateFormatter::SHORT);
 668
 669                 //Set facebook image
 670                 $this->context['facebook'] = [
 671                         'texts' => [
 672                                 $session['au_pseudonym'] => [
 673                                         'font' => 'irishgrover',
 674                                         'size' => 110
 675                                 ],
 676                                 ucfirst($intlDate->format($session['start']))."\n".$this->translator->trans('From %start% to %stop%', ['%start%' => $intlTime->format($session['start']), '%stop%' => $intlTime->format($session['stop'])]) => [
 677                                         'align' => 'left'
 678                                 ],
 679                                 $this->translator->trans('at '.$session['l_title']) => [
 680                                         'align' => 'right',
 681                                         'font' => 'labelleaurore',
 682                                         'size' => 75
 683                                 ]
 684                         ],
 685                         'updated' => $session['updated']->format('U')
 686                 ]+$this->context['facebook'];
 687
 688                 //With granted session
 689                 if (!empty($session['au_id'])) {
 690                         $this->context['keywords'][0] = $session['au_pseudonym'];
 691                 }
 692
 693                 //Set page
 694                 $this->context['page']['title'] = $this->translator->trans(!empty($session['au_id'])?'Session %id% by %pseudonym%':'Session %id%', ['%id%' => $id, '%pseudonym%' => $session['au_pseudonym']]);
 695
 696                 //Set facebook title
 697                 $this->context['ogps']['title'] = $this->context['page']['title'].' '.$this->translator->trans('at '.$session['l_title']);
 698
 699                 //Create application form for role_guest
 700                 if ($this->isGranted('ROLE_GUEST')) {
 701                         //Create ApplicationType form
 702                         $applicationForm = $this->createForm('Rapsys\AirBundle\Form\ApplicationType', null, [
 703                                 //Set the action
 704                                 'action' => $this->generateUrl('rapsys_air_application_add'),
 705                                 //Set the form attribute
 706                                 'attr' => [ 'class' => 'col' ],
 707                                 //Set admin
 708                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 709                                 //Set default user to current
 710                                 'user' => $this->getUser()->getId(),
 711                                 //Set default slot to current
 712                                 'slot' => $this->getDoctrine()->getRepository(Slot::class)->findOneById($session['t_id']),
 713                                 //Set default location to current
 714                                 'location' => $this->getDoctrine()->getRepository(Location::class)->findOneById($session['l_id']),
 715                         ]);
 716
 717                         //Add form to context
 718                         $this->context['forms']['application'] = $applicationForm->createView();
 719
 720                         //Set now
 721                         $now = new \DateTime('now');
 722
 723                         //Create SessionType form
 724                         $sessionForm = $this->createForm('Rapsys\AirBundle\Form\SessionType', null, [
 725                                 //Set the action
 726                                 'action' => $this->generateUrl('rapsys_air_session_edit', [ 'id' => $id ]),
 727                                 //Set the form attribute
 728                                 'attr' => [ 'class' => 'col' ],
 729                                 //Set admin
 730                                 'admin' => $this->isGranted('ROLE_ADMIN'),
 731                                 //Set default user to current
 732                                 'user' => $this->getUser()->getId(),
 733                                 //Set begin
 734                                 'begin' => $session['begin'],
 735                                 //Set length
 736                                 'length' => $session['length'],
 737                                 //Set raincancel
 738                                 'raincancel' => ($this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id']) && $session['rainfall'] >= 2,
 739                                 //Set cancel
 740                                 'cancel' => $this->isGranted('ROLE_ADMIN') || in_array($this->getUser()->getId(), explode("\n", $session['sau_id'])),
 741                                 //Set modify
 742                                 'modify' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_REGULAR'),
 743                                 //Set move
 744                                 'move' => $this->isGranted('ROLE_ADMIN') || $this->getUser()->getId() == $session['au_id'] && $session['stop'] >= $now && $this->isGranted('ROLE_SENIOR'),
 745                                 //Set attribute
 746                                 'attribute' => $this->isGranted('ROLE_ADMIN') && $session['locked'] === null,
 747                                 //Set session
 748                                 'session' => $session['id']
 749                         ]);
 750
 751                         //Add form to context
 752                         $this->context['forms']['session'] = $sessionForm->createView();
 753                 }
 754
 755                 //Add session in context
 756                 $this->context['session'] = [
 757                         'id' => $id,
 758                         'date' => $session['date'],
 759                         'begin' => $session['begin'],
 760                         'start' => $session['start'],
 761                         'length' => $session['length'],
 762                         'stop' => $session['stop'],
 763                         'rainfall' => $session['rainfall'] !== null ? $session['rainfall'].' mm' : $session['rainfall'],
 764                         'rainrisk' => $session['rainrisk'] !== null ? ($session['rainrisk']*100).' %' : $session['rainrisk'],
 765                         'realfeel' => $session['realfeel'] !== null ? $session['realfeel'].' °C' : $session['realfeel'],
 766                         'realfeelmin' => $session['realfeelmin'] !== null ? $session['realfeelmin'].' °C' : $session['realfeelmin'],
 767                         'realfeelmax' => $session['realfeelmax'] !== null ? $session['realfeelmax'].' °C' : $session['realfeelmax'],
 768                         'temperature' => $session['temperature'] !== null ? $session['temperature'].' °C' : $session['temperature'],
 769                         'temperaturemin' => $session['temperaturemin'] !== null ? $session['temperaturemin'].' °C' : $session['temperaturemin'],
 770                         'temperaturemax' => $session['temperaturemax'] !== null ? $session['temperaturemax'].' °C' : $session['temperaturemax'],
 771                         'locked' => $session['locked'],
 772                         'created' => $session['created'],
 773                         'updated' => $session['updated'],
 774                         'title' => $this->translator->trans('Session %id%', ['%id%' => $id]),
 775                         'application' => null,
 776                         'location' => [
 777                                 'id' => $session['l_id'],
 778                                 'at' => $this->translator->trans('at '.$session['l_title']),
 779                                 'short' => $this->translator->trans($session['l_short']),
 780                                 'title' => $this->translator->trans($session['l_title']),
 781                                 'address' => $session['l_address'],
 782                                 'zipcode' => $session['l_zipcode'],
 783                                 'city' => $session['l_city'],
 784                                 'latitude' => $session['l_latitude'],
 785                                 'longitude' => $session['l_longitude']
 786                         ],
 787                         'slot' => [
 788                                 'id' => $session['t_id'],
 789                                 'title' => $this->translator->trans($session['t_title'])
 790                         ],
 791                         'snippet' => [
 792                                 'id' => $session['p_id'],
 793                                 'description' => $session['p_description'],
 794                                 'class' => $session['p_class'],
 795                                 'contact' => $session['p_contact'],
 796                                 'donate' => $session['p_donate'],
 797                                 'link' => $session['p_link'],
 798                                 'profile' => $session['p_profile']
 799                         ],
 800                         'applications' => null
 801                 ];
 802
 803                 //With application
 804                 if (!empty($session['a_id'])) {
 805                         $this->context['session']['application'] = [
 806                                 'user' => [
 807                                         'id' => $session['au_id'],
 808                                         'by' => $this->translator->trans('by %pseudonym%', [ '%pseudonym%' => $session['au_pseudonym'] ]),
 809                                         'title' => $session['au_pseudonym']
 810                                 ],
 811                                 'id' => $session['a_id'],
 812                                 'canceled' => $session['a_canceled'],
 813                                 'title' => $this->translator->trans('Application %id%', [ '%id%' => $session['a_id'] ]),
 814                         ];
 815                 }
 816
 817                 //With applications
 818                 if (!empty($session['sa_id'])) {
 819                         //Extract applications id
 820                         $session['sa_id'] = explode("\n", $session['sa_id']);
 821                         //Extract applications score
 822                         //XXX: score may be null before grant or for bad behaviour, replace NULL with 'NULL' to avoid silent drop in mysql
 823                         $session['sa_score'] = array_map(function($v){return $v==='NULL'?null:$v;}, explode("\n", $session['sa_score']));
 824                         //Extract applications created
 825                         $session['sa_created'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_created']));
 826                         //Extract applications updated
 827                         //XXX: done earlied when computing last modified
 828                         #$session['sa_updated'] = array_map(function($v){return new \DateTime($v);}, explode("\n", $session['sa_updated']));
 829                         //Extract applications canceled
 830                         //XXX: canceled is null before cancelation, replace NULL with 'NULL' to avoid silent drop in mysql
 831                         $session['sa_canceled'] = array_map(function($v){return $v==='NULL'?null:new \DateTime($v);}, explode("\n", $session['sa_canceled']));
 832
 833                         //Extract applications user id
 834                         $session['sau_id'] = explode("\n", $session['sau_id']);
 835                         //Extract applications user pseudonym
 836                         $session['sau_pseudonym'] = explode("\n", $session['sau_pseudonym']);
 837
 838                         //Init applications
 839                         $this->context['session']['applications'] = [];
 840                         foreach($session['sa_id'] as $i => $sa_id) {
 841                                 $this->context['session']['applications'][$sa_id] = [
 842                                         'user' => null,
 843                                         'score' => $session['sa_score'][$i],
 844                                         'created' => $session['sa_created'][$i],
 845                                         'updated' => $session['sa_updated'][$i],
 846                                         'canceled' => $session['sa_canceled'][$i]
 847                                 ];
 848                                 if (!empty($session['sau_id'][$i])) {
 849                                         $this->context['session']['applications'][$sa_id]['user'] = [
 850                                                 'id' => $session['sau_id'][$i],
 851                                                 'title' => $session['sau_pseudonym'][$i]
 852                                         ];
 853                                 }
 854                         }
 855                 }
 856
 857                 //Compute period
 858                 $period = new \DatePeriod(
 859                         //Start from first monday of week
 860                         new \DateTime('Monday this week'),
 861                         //Iterate on each day
 862                         new \DateInterval('P1D'),
 863                         //End with next sunday and 4 weeks
 864                         new \DateTime(
 865                                 $this->isGranted('IS_AUTHENTICATED_REMEMBERED')?'Monday this week + 3 week':'Monday this week + 2 week'
 866                         )
 867                 );
 868
 869                 //Fetch locations
 870                 //XXX: we want to display all active locations anyway
 871                 $locations = $doctrine->getRepository(Location::class)->findTranslatedSortedByPeriod($this->translator, $period, $session['au_id']);
 872
 873                 //Render the view
 874                 return $this->render('@RapsysAir/session/view.html.twig', ['locations' => $locations]+$this->context, $response);
 875         }
 876 }