New session sync command to google events

[airbundle] / Repository / SessionRepository.php

diff --git a/Repository/SessionRepository.php b/Repository/SessionRepository.php
index d44db5570bbdeed24ab3d14fbc300e59ab333ce8..e2645520d82847a93cc0b4cbc6ef2421745d4b58 100644 (file)
--- a/Repository/SessionRepository.php
+++ b/Repository/SessionRepository.php
@@ -976,9 +976,9 @@ SQL;
 
                //Set the request
                $req = <<<SQL
 
                //Set the request
                $req = <<<SQL

-SELECT us.user_id
+SELECT us.subscribed_id

 FROM Rapsys\AirBundle\Entity\UserSubscription AS us
 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
 SQL;
 
                //Replace bundle entity name by table name


@@ -988,7 +988,7 @@ SQL;
                $rsm = new ResultSetMapping();
 
                //Declare user id field
                $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 = '';
 
                //Set subscription sql part
                $subscriptionSql = '';