3 namespace Rapsys\AirBundle\Command
;
5 use Doctrine\Persistence\ManagerRegistry
;
6 use Symfony\Component\Cache\Adapter\FilesystemAdapter
;
7 use Symfony\Component\Console\Command\Command
;
8 use Symfony\Component\Console\Input\InputInterface
;
9 use Symfony\Component\Console\Output\OutputInterface
;
10 use Symfony\Component\DependencyInjection\ContainerInterface
;
11 use Symfony\Component\Routing\Generator\UrlGeneratorInterface
;
12 use Symfony\Component\Routing\RouterInterface
;
13 use Symfony\Component\Translation\TranslatorInterface
;
14 use Twig\Extra\Markdown\DefaultMarkdown
;
16 use Rapsys\AirBundle\Entity\Session
;
18 class CalendarCommand
extends Command
{
19 //Set failure constant
22 ///Set success constant
31 * @var ManagerRegistry
38 ///Translator instance
39 protected $translator;
42 * Inject doctrine, container and translator interface
44 * @param ContainerInterface $container The container instance
45 * @param ManagerRegistry $doctrine The doctrine instance
46 * @param RouterInterface $router The router instance
47 * @param TranslatorInterface $translator The translator instance
49 public function __construct(ContainerInterface
$container, ManagerRegistry
$doctrine, RouterInterface
$router, TranslatorInterface
$translator) {
50 //Call parent constructor
51 parent
::__construct();
54 $this->config
= $container->getParameter($this->getAlias());
57 $this->locale
= $container->getParameter('kernel.default_locale');
60 $this->doctrine
= $doctrine;
63 $this->router
= $router;
66 $context = $this->router
->getContext();
69 $context->setHost('airlibre.eu');
72 $context->setScheme('https');
75 $this->translator
= $translator;
78 ///Configure attribute command
79 protected function configure() {
83 ->setName('rapsysair:calendar')
84 //Set description shown with bin/console list
85 ->setDescription('Synchronize sessions in calendar')
86 //Set description shown with bin/console --help airlibre:attribute
87 ->setHelp('This command synchronize sessions in google calendar');
90 ///Process the attribution
91 protected function execute(InputInterface
$input, OutputInterface
$output) {
93 $period = new \
DatePeriod(
94 //Start from last week
95 new \
DateTime('-1 week'),
97 new \
DateInterval('P1D'),
98 //End with next 2 week
99 new \
DateTime('+2 week')
102 //Retrieve events to update
103 $sessions = $this->doctrine
->getRepository(Session
::class)->fetchAllByDatePeriod($period, $this->locale
);
105 //Markdown converted instance
106 $markdown = new DefaultMarkdown
;
108 //Retrieve cache object
109 //XXX: by default stored in /tmp/symfony-cache/@/W/3/6SEhFfeIW4UMDlAII+Dg
110 //XXX: stored in %kernel.project_dir%/var/cache/airlibre/0/P/IA20X0K4dkMd9-+Ohp9Q
111 $cache = new FilesystemAdapter($this->config
['cache']['namespace'], $this->config
['cache']['lifetime'], $this->config
['path']['cache']);
114 $cacheCalendars = $cache->getItem('calendars');
117 if (!$cacheCalendars->isHit()) {
119 return self
::FAILURE
;
123 $calendars = $cacheCalendars->get();
125 //XXX: calendars content
126 #var_export($calendars);
128 //Check expired token
129 foreach($calendars as $clientId => $client) {
131 $googleClient = new \Google\
Client(['application_name' => $client['project'], 'client_id' => $clientId, 'client_secret' => $client['secret'], 'redirect_uri' => $client['redirect']]);
133 //Iterate on each tokens
134 foreach($client['tokens'] as $tokenId => $token) {
136 $googleClient->setAccessToken(
138 'access_token' => $tokenId,
139 'refresh_token' => $token['refresh'],
140 'expires_in' => $token['expire'],
141 'scope' => $token['scope'],
142 'token_type' => $token['type'],
143 'created' => $token['created']
148 if ($exp = $googleClient->isAccessTokenExpired()) {
150 if (($refreshToken = $googleClient->getRefreshToken()) && ($googleToken = $googleClient->fetchAccessTokenWithRefreshToken($refreshToken)) && empty($googleToken['error'])) {
151 //Add refreshed token
152 $calendars[$clientId]['tokens'][$googleToken['access_token']] = [
153 'calendar' => $token['calendar'],
154 'prefix' => $token['prefix'],
155 'refresh' => $googleToken['refresh_token'],
156 'expire' => $googleToken['expires_in'],
157 'scope' => $googleToken['scope'],
158 'type' => $googleToken['token_type'],
159 'created' => $googleToken['created']
163 unset($calendars[$clientId]['tokens'][$tokenId]);
166 unset($calendars[$clientId]['tokens'][$tokenId]);
169 if (empty($calendars[$clientId]['tokens'])) {
171 unset($calendars[$clientId]);
175 $cacheCalendars->set($calendars);
178 $cache->save($cacheCalendars);
180 //Drop token and report
181 //XXX: submit app to avoid expiration
182 //XXX: see https://console.cloud.google.com/apis/credentials/consent?project=calendar-317315
183 echo 'Token '.$tokenId.' for calendar '.$token['calendar'].' has expired and is not refreshable'."\n";
186 //XXX: we want that mail and stop here
187 return self
::FAILURE
;
194 $cacheCalendars->set($calendars);
197 $cache->save($cacheCalendars);
199 //Iterate on each calendar client
200 foreach($calendars as $clientId => $client) {
202 $googleClient = new \Google\
Client(['application_name' => $client['project'], 'client_id' => $clientId, 'client_secret' => $client['secret'], 'redirect_uri' => $client['redirect']]);
204 //Iterate on each tokens
205 foreach($client['tokens'] as $tokenId => $token) {
207 $googleClient->setAccessToken(
209 'access_token' => $tokenId,
210 'refresh_token' => $token['refresh'],
211 'expires_in' => $token['expire'],
212 'scope' => $token['scope'],
213 'token_type' => $token['type'],
214 'created' => $token['created']
219 if ($exp = $googleClient->isAccessTokenExpired()) {
220 //Last chance to skip this run
224 //Get google calendar
225 $googleCalendar = new \Google\Service\
Calendar($googleClient);
229 $calendar = $googleCalendar->calendars
->get($token['calendar']);
231 } catch(\Google\Service\Exception
$e) {
233 //TODO: handle codes here https://developers.google.com/calendar/api/guides/errors
234 echo 'Exception '.$e->getCode().':'.$e->getMessage().' in '.$e->getFile().' +'.$e->getLine()."\n";
235 echo $e->getTraceAsString()."\n";
238 return self
::FAILURE
;
246 //XXX: show even deleted event to be able to update them
247 'showDeleted' => true,
248 //TODO: fetch events one day before and one day after to avoid triggering double insert duplicate key 409 errors :=) on google
249 'timeMin' => $period->getStartDate()->format(\DateTime
::ISO8601
),
250 'timeMax' => $period->getEndDate()->format(\DateTime
::ISO8601
)
251 /*, 'iCalUID' => 'airlibre/?????'*//*'orderBy' => 'startTime', */
254 //Retrieve event collection
255 $googleEvents = $googleCalendar->events
->listEvents($token['calendar'], $filters);
257 //Iterate until reached end
259 //Iterate on each event
260 foreach ($googleEvents->getItems() as $event) {
262 if (preg_match('/^'.$token['prefix'].'([0-9]+)$/', $id = $event->getId(), $matches)) {
263 $events[$matches[1]] = $event;
264 //XXX: 3rd party events with id not matching prefix are skipped
266 # echo 'Skipping '.$event->getId().':'.$event->getSummary()."\n";*/
271 $pageToken = $googleEvents->getNextPageToken();
275 //Replace collection with next one
276 $googleEvents = $service->events
->listEvents($token['calendar'], $filters+
['pageToken' => $pageToken]);
282 //Iterate on each session to sync
283 foreach($sessions as $sessionId => $session) {
284 //Init shared properties
285 //TODO: validate for constraints here ??? https://developers.google.com/calendar/api/guides/extended-properties
286 //TODO: drop shared as unused ???
288 'gps' => $session['l_latitude'].','.$session['l_longitude']
293 'title' => $this->translator
->trans('Session %id% by %pseudonym%', ['%id%' => $sessionId, '%pseudonym%' => $session['au_pseudonym']]).' '.$this->translator
->trans('at '.$session['l_title']),
294 'url' => $this->router
->generate('rapsys_air_session_view', ['id' => $sessionId], UrlGeneratorInterface
::ABSOLUTE_URL
)
298 $description = 'Description :'."\n".strip_tags(preg_replace('!<a href="([^"]+)"(?: title="[^"]+")?'.'>([^<]+)</a>!', '\1', $markdown->convert(strip_tags($session['p_description']))));
299 $shared['description'] = $markdown->convert(strip_tags($session['p_description']));
301 //Add class when available
302 if (!empty($session['p_class'])) {
303 $shared['class'] = $session['p_class'];
304 $description .= "\n\n".'Classe :'."\n".$session['p_class'];
307 //Add contact when available
308 if (!empty($session['p_contact'])) {
309 $shared['contact'] = $session['p_contact'];
310 $description .= "\n\n".'Contact :'."\n".$session['p_contact'];
313 //Add donate when available
314 if (!empty($session['p_donate'])) {
315 $shared['donate'] = $session['p_donate'];
316 $description .= "\n\n".'Contribuer :'."\n".$session['p_donate'];
319 //Add link when available
320 if (!empty($session['p_link'])) {
321 $shared['link'] = $session['p_link'];
322 $description .= "\n\n".'Site :'."\n".$session['p_link'];
325 //Add profile when available
326 if (!empty($session['p_profile'])) {
327 $shared['profile'] = $session['p_profile'];
328 $description .= "\n\n".'Réseau social :'."\n".$session['p_profile'];
332 if (!empty($session['locked']) && $events[$sessionId]) {
334 if (!empty($event = $events[$sessionId])) {
337 $googleCalendar->events
->delete($token['calendar'], $event->getId());
339 } catch(\Google\Service\Exception
$e) {
341 //TODO: handle codes here https://developers.google.com/calendar/api/guides/errors
342 echo 'Exception '.$e->getCode().':'.$e->getMessage().' in '.$e->getFile().' +'.$e->getLine()."\n";
343 echo $e->getTraceAsString()."\n";
346 return self
::FAILURE
;
350 } elseif (empty($events[$sessionId])) {
352 $event = new \Google\Service\Calendar\
Event(
354 //TODO: replace 'airlibre' with $this->config['calendar']['prefix'] when possible with prefix validating [a-v0-9]{5,}
355 //XXX: see https://developers.google.com/calendar/api/v3/reference/events/insert#id
356 'id' => $token['prefix'].$sessionId,
357 'summary' => $session['au_pseudonym'].' '.$this->translator
->trans('at '.$session['l_title']),
358 #'description' => $markdown->convert(strip_tags($session['p_description'])),
359 'description' => $description,
360 'status' => empty($session['a_canceled'])?'confirmed':'cancelled',
361 'location' => implode(' ', [$session['l_address'], $session['l_zipcode'], $session['l_city']]),
363 'extendedProperties' => [
367 //TODO: attendees[] ?
369 'dateTime' => $session['start']->format(\DateTime
::ISO8601
)
372 'dateTime' => $session['stop']->format(\DateTime
::ISO8601
)
379 $googleCalendar->events
->insert($token['calendar'], $event);
381 } catch(\Google\Service\Exception
$e) {
383 //TODO: handle codes here https://developers.google.com/calendar/api/guides/errors
384 echo 'Exception '.$e->getCode().':'.$e->getMessage().' in '.$e->getFile().' +'.$e->getLine()."\n";
385 echo $e->getTraceAsString()."\n";
388 return self
::FAILURE
;
393 $event = $events[$sessionId];
396 if ($session['updated'] >= (new \
DateTime($event->getUpdated()))) {
398 $event->setSummary($session['au_pseudonym'].' '.$this->translator
->trans('at '.$session['l_title']));
401 $event->setDescription($description);
404 $event->setStatus(empty($session['a_canceled'])?'confirmed':'cancelled');
407 $event->setLocation(implode(' ', [$session['l_address'], $session['l_zipcode'], $session['l_city']]));
410 $eventSource = $event->getSource();
412 //Update source title
413 $eventSource->setTitle($source['title']);
416 $eventSource->setUrl($source['url']);
419 #$event->setSource($source);
421 //Get extended properties
422 $extendedProperties = $event->getExtendedProperties();
425 $extendedProperties->setShared($shared);
428 //TODO: attendees[] ?
431 $start = $event->getStart();
433 //Update start datetime
434 $start->setDateTime($session['start']->format(\DateTime
::ISO8601
));
437 $end = $event->getEnd();
439 //Update stop datetime
440 $end->setDateTime($session['stop']->format(\DateTime
::ISO8601
));
444 $updatedEvent = $googleCalendar->events
->update($token['calendar'], $event->getId(), $event);
446 } catch(\Google\Service\Exception
$e) {
448 //TODO: handle codes here https://developers.google.com/calendar/api/guides/errors
449 echo 'Exception '.$e->getCode().':'.$e->getMessage().' in '.$e->getFile().' +'.$e->getLine()."\n";
450 echo $e->getTraceAsString()."\n";
453 return self
::FAILURE
;
457 //Drop from events array
458 unset($events[$sessionId]);
462 //Remaining events to drop
463 foreach($events as $eventId => $event) {
464 //Non canceled events
465 if ($event->getStatus() == 'confirmed') {
468 $googleCalendar->events
->delete($token['calendar'], $event->getId());
470 } catch(\Google\Service\Exception
$e) {
472 //TODO: handle codes here https://developers.google.com/calendar/api/guides/errors
473 echo 'Exception '.$e->getCode().':'.$e->getMessage().' in '.$e->getFile().' +'.$e->getLine()."\n";
474 echo $e->getTraceAsString()."\n";
477 return self
::FAILURE
;
485 return self
::SUCCESS
;
489 * Return the bundle alias
493 public function getAlias(): string {