From c73cfcfaac55a23f2cbc6e00ac49cce522142026 Mon Sep 17 00:00:00 2001
From: tristan <tristan.grunert87@gmail.com>
Date: Thu, 28 Sep 2023 23:46:47 +0200
Subject: [PATCH 1/3] feat(google-calendar): read show from zest google
 calendar

---
 src/components/CalendarPage.vue | 129 +++++++++++++++++++++++---------
 1 file changed, 92 insertions(+), 37 deletions(-)

diff --git a/src/components/CalendarPage.vue b/src/components/CalendarPage.vue
index 537cde6..a4cb951 100644
--- a/src/components/CalendarPage.vue
+++ b/src/components/CalendarPage.vue
@@ -61,14 +61,16 @@
             {{
               new Date(Number(show.starts_at)).toLocaleTimeString("fr-FR", {
                 hour: "2-digit",
-                timeZone: "UTC",
+                minute: "2-digit",
+                timeZone: "Europe/Paris",
               })
             }}
             à
             {{
               new Date(Number(show.ends_at)).toLocaleTimeString("fr-FR", {
                 hour: "2-digit",
-                timeZone: "UTC",
+                minute: "2-digit",
+                timeZone: "Europe/Paris",
               })
             }}:</u
           >
@@ -101,19 +103,23 @@
 <script>
 import graph from "@/graphaxios";
 
+const googleCalendarUrl =
+  "https://clients6.google.com/calendar/v3/calendars/zoneestradio@gmail.com/events";
+const googleCalendarApiKey = "AIzaSyBNlYH01_9Hc5S1J9vuFmu2nUqBZJNAXxs";
+
 export default {
   name: "CalendarPage",
   data() {
     return {
       shows: [],
       days: [
-        { val: "monday", title: "Lundi" },
-        { val: "tuesday", title: "Mardi" },
-        { val: "wednesday", title: "Mercredi" },
-        { val: "thursday", title: "Jeudi" },
-        { val: "friday", title: "Vendredi" },
-        { val: "saturday", title: "Samedi" },
-        { val: "sunday", title: "Dimanche" },
+        { val: "monday", title: "Lundi", id: 1 },
+        { val: "tuesday", title: "Mardi", id: 2 },
+        { val: "wednesday", title: "Mercredi", id: 3 },
+        { val: "thursday", title: "Jeudi", id: 4 },
+        { val: "friday", title: "Vendredi", id: 5 },
+        { val: "saturday", title: "Samedi", id: 6 },
+        { val: "sunday", title: "Dimanche", id: 0 },
       ],
       weeks: {
         monday: [],
@@ -146,6 +152,7 @@ export default {
         }`,
         { start: this.week }
       );
+      const now = new Date();
 
       // re-init arrays for when data changes
       this.weeks.monday = [];
@@ -155,35 +162,83 @@ export default {
       this.weeks.friday = [];
       this.weeks.saturday = [];
       this.weeks.sunday = [];
-
-      this.shows = res.Shows;
-      for (let i = 0; i < res.Shows.length; i++) {
-        let DST = new Date().getTimezoneOffset() == -60 ? 3600000 : 7200000;
-        let e = new Date(Number(res.Shows[i].starts_at) - DST);
-        switch (e.getDay()) {
-          case 0:
-            this.weeks.sunday.push(res.Shows[i]);
-            break;
-          case 1:
-            this.weeks.monday.push(res.Shows[i]);
-            break;
-          case 2:
-            this.weeks.tuesday.push(res.Shows[i]);
-            break;
-          case 3:
-            this.weeks.wednesday.push(res.Shows[i]);
-            break;
-          case 4:
-            this.weeks.thursday.push(res.Shows[i]);
-            break;
-          case 5:
-            this.weeks.friday.push(res.Shows[i]);
-            break;
-          case 6:
-            this.weeks.saturday.push(res.Shows[i]);
-            break;
-        }
+      this.shows = res.Shows.map((show) => {
+        return {
+          ...show,
+          starts_at: new Date(Number(show.starts_at) + now.getTimezoneOffset() * 60000),
+          ends_at: new Date(Number(show.ends_at) + now.getTimezoneOffset() * 60000),
+        };
+      });
+      await this.getGoogleCalendar();
+      this.dispatchShowsInWeek(this.shows);
+    },
+    async getGoogleCalendar() {
+      const monday = this.date;
+      const oneWeekFromMonday = new Date(monday.getTime() + 7 * 24 * 60 * 60 * 1000);
+      const response = await fetch(
+        `${googleCalendarUrl}?` +
+          [
+            "singleEvents=true",
+            "timeZone=Europe%2FParis",
+            "maxAttendees=1",
+            "maxResults=250",
+            "sanitizeHtml=true",
+            "timeMin=" + monday.toISOString(),
+            "timeMax=" + oneWeekFromMonday.toISOString(),
+            "key=" + googleCalendarApiKey,
+          ].join("&")
+      );
+      const body = await response.json();
+      if (!body?.items) {
+        return;
+      }
+      let shows = body.items.filter((item) => item.summary.startsWith("#show"));
+      const parser = new DOMParser();
+      shows = await Promise.all(
+        shows.map(async (show) => {
+          const htmlDescription = parser.parseFromString(show.description, "text/xml");
+          const info = htmlDescription.getElementsByTagName("li");
+          return {
+            starts_at: new Date(show.start.dateTime).getTime().toString(),
+            ends_at: new Date(show.end.dateTime).getTime().toString(),
+            name: info[0] && info[0].innerHTML,
+            dj: info[1] && info[1].innerHTML,
+            redundancy: await this.getRecurrences(show.recurringEventId),
+            genres: info[2] && info[2].innerHTML.replace(/#/g, "").split(" "),
+          };
+        })
+      );
+      this.shows = this.shows.concat(shows);
+    },
+    dispatchShowsInWeek(shows) {
+      for (let i = 0; i < shows.length; i++) {
+        let e = new Date(Number(shows[i].starts_at));
+        const dayName = this.days.find((d) => d.id === e.getDay()).val;
+        this.weeks[dayName].push(shows[i]);
+      }
+    },
+    async getRecurrences(id) {
+      if (!id) {
+        return;
+      }
+      const response = await fetch(
+        `${googleCalendarUrl}/${id}?` +
+          ["sanitizeHtml=true", "key=" + googleCalendarApiKey].join("&")
+      );
+      const body = await response.json();
+      if (
+        !body?.recurrence ||
+        !body.recurrence[0] ||
+        body.recurrence[0].indexOf("RRULE:FREQ=WEEKLY") === -1
+      ) {
+        return;
+      }
+      const rules = body.recurrence[0].split(";");
+      const interval = rules.find((r) => r.startsWith("INTERVAL="));
+      if (!interval) {
+        return;
       }
+      return Number(interval.replace("INTERVAL=", ""));
     },
     async changeWeek(sign) {
       let date = new Date(this.date);
-- 
GitLab


From fb861670b02cc689477d375cb1d91b07ee94e6ec Mon Sep 17 00:00:00 2001
From: tristan <tristan.grunert87@gmail.com>
Date: Fri, 29 Sep 2023 18:32:46 +0200
Subject: [PATCH 2/3] feat(google-calendar): fix common issues

---
 src/components/CalendarPage.vue | 34 ++++++++++++++++++++++++---------
 1 file changed, 25 insertions(+), 9 deletions(-)

diff --git a/src/components/CalendarPage.vue b/src/components/CalendarPage.vue
index a4cb951..d215133 100644
--- a/src/components/CalendarPage.vue
+++ b/src/components/CalendarPage.vue
@@ -76,12 +76,11 @@
           >
           <span> {{ show.name }} </span>
           <br />
-          <span v-if="show.dj.length"
+          <span v-if="show.dj && show.dj.length"
             ><span class="side">Animee par</span> {{ show.dj }}</span
           ><br />
           <span class="side" v-if="show.redundancy"
-            >Toutes les
-            {{ show.redundancy == 1 ? "" : show.redundancy }} semaines</span
+            >Toutes les {{ show.redundancy == 1 ? "" : show.redundancy }} semaines</span
           >
           <span v-else class="side">Emission speciale</span><br />
           <div class="genreHld">
@@ -192,24 +191,41 @@ export default {
       if (!body?.items) {
         return;
       }
-      let shows = body.items.filter((item) => item.summary.startsWith("#show"));
+      let shows = body.items.filter(
+        (item) => item.summary && item.summary.toLowerCase().indexOf("#show") != -1
+      );
       const parser = new DOMParser();
       shows = await Promise.all(
         shows.map(async (show) => {
-          const htmlDescription = parser.parseFromString(show.description, "text/xml");
+          if (!show.description) {
+            return;
+          }
+          const htmlDescription = parser.parseFromString(
+            show.description.replace(/<br>/g, ""),
+            "text/xml"
+          );
           const info = htmlDescription.getElementsByTagName("li");
           return {
             starts_at: new Date(show.start.dateTime).getTime().toString(),
             ends_at: new Date(show.end.dateTime).getTime().toString(),
-            name: info[0] && info[0].innerHTML,
-            dj: info[1] && info[1].innerHTML,
+            name: this.stripHtml(info, 0),
+            dj: this.stripHtml(info, 1),
             redundancy: await this.getRecurrences(show.recurringEventId),
-            genres: info[2] && info[2].innerHTML.replace(/#/g, "").split(" "),
+            genres:
+              this.stripHtml(info, 2) &&
+              this.stripHtml(info, 2).replace(/#/g, "").split(" "),
           };
         })
       );
       this.shows = this.shows.concat(shows);
     },
+    stripHtml(infoHtml, index) {
+      return (
+        infoHtml[index] &&
+        infoHtml[index].textContent &&
+        infoHtml[index].textContent.trim()
+      );
+    },
     dispatchShowsInWeek(shows) {
       for (let i = 0; i < shows.length; i++) {
         let e = new Date(Number(shows[i].starts_at));
@@ -236,7 +252,7 @@ export default {
       const rules = body.recurrence[0].split(";");
       const interval = rules.find((r) => r.startsWith("INTERVAL="));
       if (!interval) {
-        return;
+        return 1;
       }
       return Number(interval.replace("INTERVAL=", ""));
     },
-- 
GitLab


From 2ab97f1926fd4f79bbadc678bb2a424988c765d5 Mon Sep 17 00:00:00 2001
From: tristan <tristan.grunert87@gmail.com>
Date: Fri, 29 Sep 2023 18:42:23 +0200
Subject: [PATCH 3/3] avoid NPE

---
 src/components/CalendarPage.vue | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/src/components/CalendarPage.vue b/src/components/CalendarPage.vue
index d215133..8f0f5e8 100644
--- a/src/components/CalendarPage.vue
+++ b/src/components/CalendarPage.vue
@@ -205,6 +205,9 @@ export default {
             "text/xml"
           );
           const info = htmlDescription.getElementsByTagName("li");
+          if (!info) {
+            return;
+          }
           return {
             starts_at: new Date(show.start.dateTime).getTime().toString(),
             ends_at: new Date(show.end.dateTime).getTime().toString(),
-- 
GitLab