From: Raphaël Gertz <git@rapsys.eu>
Date: Sun, 7 Apr 2024 01:55:22 +0000 (+0200)
Subject: Fix subscribed key name
X-Git-Tag: 0.5.0~9
X-Git-Url: https://git.rapsys.eu/airbundle/commitdiff_plain/85e3d49aa800d5e289f376023173847e0a2077f0?ds=inline;hp=5bdc01337b213b789f58b3a02596688082cfc129

Fix subscribed key name
---

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index d44db55..e264552 100644
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -976,9 +976,9 @@ SQL;
 
 		//Set the request
 		$req = <<<SQL
-SELECT us.user_id
+SELECT us.subscribed_id
 FROM Rapsys\AirBundle\Entity\UserSubscription AS us
-WHERE us.subscriber_id = :uid
+WHERE us.user_id = :uid
 SQL;
 
 		//Replace bundle entity name by table name
@@ -988,7 +988,7 @@ SQL;
 		$rsm = new ResultSetMapping();
 
 		//Declare user id field
-		$rsm->addScalarResult('user_id', 'user_id', 'integer');
+		$rsm->addScalarResult('subscribed_id', 'subscribed_id', 'integer');
 
 		//Set subscription sql part
 		$subscriptionSql = '';