From 36367b3d9770a29f2e516e40524c5d4eef8a9aca Mon Sep 17 00:00:00 2001
From: =?utf8?q?Rapha=C3=ABl=20Gertz?= <git@rapsys.eu>
Date: Sun, 7 Apr 2024 04:00:49 +0200
Subject: [PATCH 1/1] Append dances and subscriptions to findAllIndexed results

---
 Repository/GoogleTokenRepository.php | 87 +++++++++++++++++++++++-----
 1 file changed, 71 insertions(+), 16 deletions(-)

diff --git a/Repository/GoogleTokenRepository.php b/Repository/GoogleTokenRepository.php
index fa2a854..7c96e72 100644
--- a/Repository/GoogleTokenRepository.php
+++ b/Repository/GoogleTokenRepository.php
@@ -29,20 +29,51 @@ class GoogleTokenRepository extends Repository {
 		//Set the request
 		$req = <<<SQL
 SELECT
-	t.id AS tid,
-	t.mail AS gmail,
-	t.user_id AS uid,
-	t.access,
-	t.refresh,
-	t.expired,
-	GROUP_CONCAT(c.id ORDER BY c.id SEPARATOR "\\n") AS cids,
-	GROUP_CONCAT(c.mail ORDER BY c.id SEPARATOR "\\n") AS cmails,
-	GROUP_CONCAT(c.summary ORDER BY c.id SEPARATOR "\\n") AS csummaries,
-	GROUP_CONCAT(IFNULL(c.synchronized, 'NULL') ORDER BY c.id SEPARATOR "\\n") AS csynchronizeds
-FROM Rapsys\AirBundle\Entity\GoogleToken AS t
-JOIN Rapsys\AirBundle\Entity\GoogleCalendar AS c ON (c.google_token_id = t.id)
-GROUP BY t.id
-ORDER BY NULL
+	b.tid,
+	b.gmail,
+	b.uid,
+	b.access,
+	b.refresh,
+	b.expired,
+	b.cids,
+	b.cmails,
+	b.csummaries,
+	b.csynchronizeds,
+	b.dids,
+	GROUP_CONCAT(us.subscribed_id ORDER BY us.subscribed_id SEPARATOR "\\n") AS sids
+FROM (
+	SELECT
+		a.tid,
+		a.gmail,
+		a.uid,
+		a.access,
+		a.refresh,
+		a.expired,
+		a.cids,
+		a.cmails,
+		a.csummaries,
+		a.csynchronizeds,
+		GROUP_CONCAT(ud.dance_id ORDER BY ud.dance_id SEPARATOR "\\n") AS dids
+	FROM (
+		SELECT
+			t.id AS tid,
+			t.mail AS gmail,
+			t.user_id AS uid,
+			t.access,
+			t.refresh,
+			t.expired,
+			GROUP_CONCAT(c.id ORDER BY c.id SEPARATOR "\\n") AS cids,
+			GROUP_CONCAT(c.mail ORDER BY c.id SEPARATOR "\\n") AS cmails,
+			GROUP_CONCAT(c.summary ORDER BY c.id SEPARATOR "\\n") AS csummaries,
+			GROUP_CONCAT(IFNULL(c.synchronized, 'NULL') ORDER BY c.id SEPARATOR "\\n") AS csynchronizeds
+		FROM Rapsys\AirBundle\Entity\GoogleToken AS t
+		JOIN Rapsys\AirBundle\Entity\GoogleCalendar AS c ON (c.google_token_id = t.id)
+		GROUP BY t.id
+		ORDER BY NULL
+	) AS a
+	LEFT JOIN Rapsys\AirBundle\Entity\UserDance AS ud ON (ud.user_id = a.uid)
+) AS b
+LEFT JOIN Rapsys\AirBundle\Entity\UserSubscription AS us ON (us.user_id = b.uid)
 SQL;
 
 		//Replace bundle entity name by table name
@@ -66,6 +97,8 @@ SQL;
 			->addScalarResult('cmails', 'cmails', 'string')
 			->addScalarResult('csummaries', 'csummaries', 'string')
 			->addScalarResult('csynchronizeds', 'csynchronizeds', 'string')
+			->addScalarResult('dids', 'dids', 'string')
+			->addScalarResult('sids', 'sids', 'string')
 			->addIndexByScalar('tid');
 
 		//Set result array
@@ -98,10 +131,12 @@ SQL;
 				'access' => $token['access'],
 				'refresh' => $token['refresh'],
 				'expired' => $token['expired'],
-				'calendars' => []
+				'calendars' => [],
+				'dances' => [],
+				'subscriptions' => []
 			];
 
-			//Iterate on 
+			//Iterate on calendars
 			foreach($cids as $k => $cid) {
 				$result[$tid]['calendars'][$cid] = [
 					'id' => $cid,
@@ -110,6 +145,26 @@ SQL;
 					'synchronized' => $csynchronizeds[$k]
 				];
 			}
+
+			//Set dids
+			$dids = explode("\n", $token['dids']);
+
+			//Iterate on dances
+			foreach($dids as $k => $did) {
+				$result[$tid]['dances'][$did] = [
+					'id' => $did
+				];
+			}
+
+			//Set sids
+			$sids = explode("\n", $token['sids']);
+
+			//Iterate on subscriptions
+			foreach($sids as $k => $sid) {
+				$result[$tid]['subscriptions'][$sid] = [
+					'id' => $sid
+				];
+			}
 		}
 
 		//Return result
-- 
2.41.1