Exemple #1
0
 /**
  * Return array with user friends 
  * @return array
  */
 public static function getFriends($idUser, $friendStatus = 1, $orderField = 'username', $orderDirection = 'ASC', $gender = null, $level = null)
 {
     $criteria = new CDbCriteria();
     //Get users the current user added as Friends
     $criteria->condition = "idUserFrom=:idUser and accepted=:friendStatus";
     $criteria->params = array(':idUser' => $idUser, ':friendStatus' => $friendStatus);
     if ($gender !== '' && $gender !== null) {
         $criteria->addCondition("userTo.gender = :gender");
         $criteria->params[':gender'] = $gender;
     }
     if ($level !== '' && $level !== null) {
         $criteria->addCondition("levelUserTo.level = :level");
         $criteria->params[':level'] = $level;
     }
     $friendsFrom = Friend::model()->with('userTo', 'userTo.levelUserTo')->findAll($criteria);
     //Get users that added the current user as Friends
     $criteria->condition = "idUserTo=:idUser and accepted=:friendStatus";
     $criteria->params = array(':idUser' => $idUser, ':friendStatus' => $friendStatus);
     if ($gender !== '' && $gender !== null) {
         $criteria->addCondition("userFrom.gender = :gender");
         $criteria->params[':gender'] = $gender;
     }
     if ($level !== '' && $level !== null) {
         $criteria->addCondition("levelUserFrom.level = :level");
         $criteria->params[':level'] = $level;
     }
     $friendsTo = Friend::model()->with('userFrom', 'userFrom.levelUserFrom')->findAll($criteria);
     //Gather them together
     $friends = array();
     $i = 0;
     foreach ($friendsFrom as $row) {
         $friends[$i]['idUser'] = $row->userTo->idUser;
         $friends[$i]['username'] = $row->userTo->username;
         $friends[$i]['profilePicture'] = $row->userTo->profilePicture;
         $friends[$i]['profilePictureExtension'] = $row->userTo->profilePictureExtension;
         $friends[$i]['level'] = $row->userTo->levelUserTo->level;
         $i++;
     }
     foreach ($friendsTo as $row) {
         $friends[$i]['idUser'] = $row->userFrom->idUser;
         $friends[$i]['username'] = $row->userFrom->username;
         $friends[$i]['profilePicture'] = $row->userFrom->profilePicture;
         $friends[$i]['profilePictureExtension'] = $row->userFrom->profilePictureExtension;
         $friends[$i]['level'] = $row->userFrom->levelUserFrom->level;
         $i++;
     }
     $friends = MyFunctions::arraySort($friends, $orderField, $orderDirection);
     return $friends;
 }
Exemple #2
0
 public function run()
 {
     $wallOwner = User::model()->with('scoreTruth', 'scoreDare')->findByPk($this->idWallOwner);
     //To display notifications from friends
     if ($this->withFriendsInformations === 1) {
         $friends = $wallOwner->getIdFriends();
         $friends[] = $this->idWallOwner;
     }
     //Add message to the Wall
     $model = new UserWall();
     if (isset($_POST['Userwall'])) {
         $model->attributes = $_POST['Userwall'];
         $model->idUserFrom = $this->idCurrentUser;
         $model->idUserTo = $this->idWallOwner;
         $model->createDate = date('Y-m-d, H:i:s');
         $model->save();
         $model->content = '';
     }
     //Initialiation of the array
     $wall = array();
     $i = 0;
     //Get Wall Messages and add them to the Wall array()
     if ($this->withWallMessages == 1) {
         $criteria = new CDbCriteria();
         $criteria->addCondition('t.idUserTo = :idUser');
         $criteria->params = array(':idUser' => $this->idWallOwner);
         $criteria->order = 'createDate DESC';
         $wallComments = UserWall::model()->with('userFrom', 'userFrom.scoreTruth', 'userFrom.scoreDare')->findAll($criteria);
         foreach ($wallComments as $row) {
             $wall[$i]['type'] = "WallMessage";
             $wall[$i]['id'] = $row->idUserWall;
             $wall[$i]['content'] = $row->content;
             $wall[$i]['createDate'] = $row->createDate;
             $wall[$i]['userPicture'] = $row->userFrom->profilePicture . '_mini' . $row->userFrom->profilePictureExtension;
             $wall[$i]['category'] = null;
             $wall[$i]['vote'] = null;
             $wall[$i]['nbFavourite'] = null;
             $wall[$i]['nbComment'] = null;
             $wall[$i]['idDisplayUser'] = $row->userFrom->idUser;
             $wall[$i]['displayUsername'] = $row->userFrom->username;
             $wall[$i]['pictureChallengeDareMini'] = null;
             $wall[$i]['pictureChallengeDare'] = null;
             $wall[$i]['challengeTruthOrCommentDare'] = null;
             $wall[$i]['rankTruth'] = MyFunctions::getTruthRankName($row->userFrom->scoreTruth->score);
             $wall[$i]['rankDare'] = MyFunctions::getDareRankName($row->userFrom->scoreDare->score);
             $i++;
         }
     }
     //Get Challenges Notifications and add them to the Wall array()
     $criteria = new CDbCriteria();
     $criteria->addCondition('t.status = 1 AND (t.private = 0 OR (t.idUserFrom = :idCurrentUser OR t.idUserTo = :idCurrentUser))');
     $criteria->params = array(':idCurrentUser' => $this->idCurrentUser);
     if ($this->withFriendsInformations === 1) {
         $criteria->addInCondition('t.idUserTo', $friends);
     } else {
         $criteria->addCondition('t.idUserTo = :idUser');
         $criteria->params[':idUser'] = $this->idWallOwner;
     }
     if (isset($this->filterLevel)) {
         $criteria->addCondition("(categoryTruth.level IS NOT NULL AND categoryTruth.level <= {$this->filterLevel}) OR (categoryDare.level IS NOT NULL AND categoryDare.level <= {$this->filterLevel})");
     }
     $challenges = Challenge::model()->with('userTo', 'truth', 'dare', 'truth.category', 'dare.category', 'userTo.scoreTruth', 'userTo.scoreDare')->findAll($criteria);
     foreach ($challenges as $row) {
         $wall[$i]['type'] = $row->idTruth === null ? "ChallengeDare" : "ChallengeTruth";
         $wall[$i]['id'] = $row->idChallenge;
         $wall[$i]['content'] = isset($row->truth) ? $row->answer : $row->dare->dare;
         $wall[$i]['createDate'] = $row->createDate;
         $wall[$i]['userPicture'] = $row->userTo->profilePicture . '_mini' . $row->userTo->profilePictureExtension;
         $wall[$i]['category'] = isset($row->truth) ? $row->truth->category->category : $row->dare->category->category;
         $wall[$i]['vote'] = $row->voteUp - $row->voteDown;
         $wall[$i]['nbFavourite'] = 0;
         $wall[$i]['nbComment'] = 0;
         $wall[$i]['idDisplayUser'] = $row->userTo->idUser;
         $wall[$i]['displayUsername'] = $row->userTo->username;
         $wall[$i]['pictureChallengeDareMini'] = $row->pictureName . "_mini" . $row->pictureExtension;
         $wall[$i]['pictureChallengeDare'] = $row->pictureName . "_original" . $row->pictureExtension;
         $wall[$i]['challengeTruthOrCommentDare'] = isset($row->truth) ? $row->truth->truth : $row->answer;
         $wall[$i]['rankTruth'] = MyFunctions::getTruthRankName($row->userTo->scoreTruth->score);
         $wall[$i]['rankDare'] = MyFunctions::getDareRankName($row->userTo->scoreDare->score);
         $i++;
     }
     //Get Truths and add them to the Wall array()
     $truth = new Truth();
     if (isset($this->filterLevel)) {
         $truth->levelMax = $this->filterLevel;
     }
     $criteria = $truth->getCriteria();
     if ($this->withFriendsInformations === 1) {
         $criteria->addInCondition('t.idUser', $friends);
     } else {
         $criteria->addCondition('t.idUser = :idUser');
         $criteria->params[':idUser'] = $this->idWallOwner;
     }
     $truths = Truth::model()->notAnonymous()->findAll($criteria);
     foreach ($truths as $row) {
         $wall[$i]['type'] = "Truth";
         $wall[$i]['id'] = $row->idTruth;
         $wall[$i]['content'] = $row->truth;
         $wall[$i]['createDate'] = $row->dateSubmit;
         $wall[$i]['userPicture'] = $row->user->profilePicture . '_mini' . $row->user->profilePictureExtension;
         $wall[$i]['category'] = $row->category->category;
         $wall[$i]['vote'] = $row->voteUp - $row->voteDown;
         $wall[$i]['nbFavourite'] = $row->nbFavourite;
         $wall[$i]['nbComment'] = $row->nbComment;
         $wall[$i]['idDisplayUser'] = $row->user->idUser;
         $wall[$i]['displayUsername'] = $row->user->username;
         $wall[$i]['pictureChallengeDareMini'] = null;
         $wall[$i]['pictureChallengeDare'] = null;
         $wall[$i]['challengeTruthOrCommentDare'] = null;
         $wall[$i]['rankTruth'] = MyFunctions::getTruthRankName($row->user->scoreTruth->score);
         $wall[$i]['rankDare'] = MyFunctions::getDareRankName($row->user->scoreDare->score);
         $i++;
     }
     //Get Dares and add them to the Wall array()
     $dare = new Dare();
     if (isset($this->filterLevel)) {
         $dare->levelMax = $this->filterLevel;
     }
     $criteria = $dare->getCriteria();
     if ($this->withFriendsInformations === 1) {
         $criteria->addInCondition('t.idUser', $friends);
     } else {
         $criteria->addCondition('t.idUser = :idUser');
         $criteria->params[':idUser'] = $this->idWallOwner;
     }
     $dares = Dare::model()->notAnonymous()->findAll($criteria);
     foreach ($dares as $row) {
         $wall[$i]['type'] = "Dare";
         $wall[$i]['id'] = $row->idDare;
         $wall[$i]['content'] = $row->dare;
         $wall[$i]['createDate'] = $row->dateSubmit;
         $wall[$i]['userPicture'] = $row->user->profilePicture . '_mini' . $row->user->profilePictureExtension;
         $wall[$i]['category'] = $row->category->category;
         $wall[$i]['vote'] = $row->voteUp - $row->voteDown;
         $wall[$i]['nbFavourite'] = $row->nbFavourite;
         $wall[$i]['nbComment'] = $row->nbComment;
         $wall[$i]['idDisplayUser'] = $row->user->idUser;
         $wall[$i]['displayUsername'] = $row->user->username;
         $wall[$i]['pictureChallengeDareMini'] = null;
         $wall[$i]['pictureChallengeDare'] = null;
         $wall[$i]['challengeTruthOrCommentDare'] = null;
         $wall[$i]['rankTruth'] = MyFunctions::getTruthRankName($row->user->scoreTruth->score);
         $wall[$i]['rankDare'] = MyFunctions::getDareRankName($row->user->scoreDare->score);
         $i++;
     }
     //Get Ranks Upgrades of the user
     $criteria = new CDbCriteria();
     if ($this->withFriendsInformations === 1) {
         $criteria->addInCondition('t.idUser', $friends);
     } else {
         $criteria->addCondition('t.idUser = :idUser');
         $criteria->params = array(':idUser' => $this->idWallOwner);
     }
     $userUpgrades = Userrank::model()->with('rank')->findAll($criteria);
     foreach ($userUpgrades as $row) {
         $wall[$i]['type'] = "RankUpgrade";
         $wall[$i]['id'] = null;
         $wall[$i]['content'] = "I just got upgraded to <b>" . $row->rank->name . "</b>!";
         $wall[$i]['createDate'] = $row->createDate;
         $wall[$i]['userPicture'] = $row->user->profilePicture . '_mini' . $row->user->profilePictureExtension;
         $wall[$i]['category'] = null;
         $wall[$i]['vote'] = null;
         $wall[$i]['nbFavourite'] = null;
         $wall[$i]['nbComment'] = null;
         $wall[$i]['idDisplayUser'] = $row->user->idUser;
         $wall[$i]['displayUsername'] = $row->user->username;
         $wall[$i]['pictureChallengeDareMini'] = null;
         $wall[$i]['pictureChallengeDare'] = null;
         $wall[$i]['challengeTruth'] = null;
         $wall[$i]['rankTruth'] = MyFunctions::getTruthRankName($row->user->scoreTruth->score);
         $wall[$i]['rankDare'] = MyFunctions::getDareRankName($row->user->scoreDare->score);
         $i++;
     }
     //Manage favourites
     $modelUserList = new UserList();
     $userLists = CHtml::listData(array(), 'idUserList', 'name');
     if (!Yii::app()->user->isGuest) {
         $userLists = UserList::model()->findAllByAttributes(array('idUser' => $this->idCurrentUser));
         $userLists = CHtml::listData($userLists, 'idUserList', 'name');
     }
     //Manage send Challenges
     $friends = CHtml::listData(array(), 'idUser', 'username');
     if (!Yii::app()->user->isGuest) {
         $friends = CHtml::listData(Friend::getFriends(Yii::app()->user->getId()), 'idUser', 'username');
     }
     //Order the Wall array() by createDate DESC
     $wall = MyFunctions::arraySort($wall, 'createDate', 'DESC');
     $this->render('userWallWidget', array('model' => $model, 'wall' => $wall, 'userLists' => $userLists, 'friends' => $friends));
 }