public function getmembersdetails($userid, $groupid, $limit, $offset) { $Criteria = new CDbCriteria(); $Criteria->join = 'JOIN fn_user_group as t2 on t.`tracked_groupid` = t2.group_id and t2.group_activestatus =1'; $Criteria->condition = "`tracked_userid` = " . $userid . " and tracked_groupid = " . $groupid . " and visible = 0"; $criteria->select = 'distinct t.tracker_userid'; $members = GroupTracking::model()->findAll($Criteria); $memids = array(); foreach ($members as $member) { $memids[] = $member->tracker_userid; } /* if(!empty($memids)) {*/ $criteria1 = new CDbCriteria(); $criteria1->join = 'join fn_user_profile AS t1 on t.userid = t1.user_id and t.status = 1'; $criteria1->addInCondition('userid', $memids); $criteria1->select = 't1.profile_image,t.*'; $criteria1->order = 'createtime DESC'; if ($limit) { $criteria1->limit = $limit; $criteria1->offset = $offset; } $meminfo = User::model()->findAll($criteria1); /* }*/ //print_r($meminfo);exit; return $meminfo; }
public function actionProfilelanding() { //$this->allowjs = "allowminjs"; if (isset(Yii::app()->session['login'])) { $userid = Yii::app()->session['login']['id']; } else { $this->redirect(array('/')); } $tileid = ''; if (isset($_REQUEST['tileid'])) { $tileid = $_REQUEST['tileid']; } $newprofile = UserProfile::model()->findByAttributes(array('user_id' => $userid)); if (isset($newprofile)) { $newprofile->updatedby = $userid; $newprofile->updateddate = date('Y-m-d G:i:s'); } else { $newprofile = new UserProfile(); $newprofile->createdby = $userid; $newprofile->createddate = date('Y-m-d G:i:s'); $newprofile->updatedby = $userid; $newprofile->updateddate = date('Y-m-d G:i:s'); } if (isset($_POST['UserProfile'])) { // print_r($_POST);exit; $newprofile = UserProfile::model()->findByAttributes(array('user_id' => $_POST['UserProfile']['user_id'])); if (isset($newprofile)) { $newprofile->updatedby = $_POST['UserProfile']['user_id']; $newprofile->updateddate = date('Y-m-d G:i:s'); if ($tileid == 77) { $redirect = "tile"; } else { $redirect = "profile"; } } else { $newprofile = new UserProfile(); $newprofile->createdby = $_POST['UserProfile']['user_id']; $newprofile->createddate = date('Y-m-d G:i:s'); $newprofile->updatedby = $_POST['UserProfile']['user_id']; $newprofile->updateddate = date('Y-m-d G:i:s'); $redirect = "newfinao"; } $newprofile->user_id = $_POST['UserProfile']['user_id']; $newprofile->attributes = $_POST['UserProfile']; $newprofile->IsCompleted = "saved"; $newprofile->save(false); $dateOB = ""; if ($_POST['UserProfile']['dob'] != '0000-00-00') { // $datevalue = (stripos($_POST['UserProfile']['dob'],"-") > 0) ? explode("-",$_POST['UserProfile']['dob']) : ""; //echo $datevalue[1];exit; //if($datevalue != "") //{ $dateOB = date('Y-m-d H:i:s', strtotime($_POST['date_dat'] . "-" . $_POST['date_mon'] . "-" . $_POST['date_year'])); //echo $dateOB;exit; //} } else { $dateOB = date('Y-m-d H:i:s', strtotime($_POST['date_dat'] . "-" . $_POST['date_mon'] . "-" . $_POST['date_year'])); } $user = User::model()->findByPk($_POST['UserProfile']['user_id']); $user->dob = $dateOB; //echo $dateOB;exit; $user->fname = $_POST['UserProfile']['fname']; $user->lname = $_POST['UserProfile']['lname']; $user->zipcode = $_POST['UserProfile']['zpcode']; $user->updatedby = $_POST['UserProfile']['user_id']; $user->updatedate = new CDbExpression('NOW()'); //date('Y-m-d G:i:s'); $user->save(false); //echo $redirect;exit; if ($redirect == "newfinao") { $this->redirect(array('profile/newfinao')); } elseif ($redirect == "profile") { $this->redirect(array('finao/motivationmesg')); } elseif ($redirect == "tile") { $result = GroupTracking::model()->findByAttributes(array('tracker_userid' => Yii::app()->session['login']['id'], 'tracked_groupid' => 5, 'tracked_userid' => 255)); } if (!$result) { $track = new GroupTracking(); $track->tracker_userid = Yii::app()->session['login']['id']; $track->tracked_groupid = 5; $track->tracked_userid = 255; $track->createddate = new CDbExpression('NOW()'); $track->status = 1; $track->save(false); } $this->redirect(array('group/Dashboard?groupid=5&frndid=255&share=no&share_value=0')); } $logeduser = User::model()->findByPk(Yii::app()->session['login']['id']); if (isset($_REQUEST['url']) && $_REQUEST['url'] == 'logedfbreg') { $userinfo = Yii::app()->facebook->api('/me'); if (isset($_REQUEST['error_reason']) && $_REQUEST['error_reason'] == 'user_denied') { Yii::app()->user->setFlash('fbusererror', 'You are NOT LOGGED IN.You must allow basic permission access to Login from facebook'); $this->redirect(array('/')); } $logeduser->socialnetworkid = $userinfo['id']; $logeduser->socialnetwork = "facebook"; $logeduser->save(false); $track = "track"; $invitefriends = "invitefriends"; } else { $invitefriends = ""; } if (isset($_REQUEST['edit'])) { $edit = $_REQUEST['edit']; } else { $edit = ""; } $this->render('profilelanding', array('userprofile' => $newprofile, 'userid' => $userid, 'invitefriends' => $invitefriends, 'logeduser' => $logeduser, 'edit' => $edit, 'tileid' => $tileid, 'Imgupload' => isset($_REQUEST['Imagupload']) ? $_REQUEST['Imagupload'] : 0, 'errormsg' => isset($_REQUEST['errormsg']) && $_REQUEST['errormsg'] == 1 ? "1" : "")); }
public function actionHidegroup() { $userid = Yii::app()->session['login']['id']; $groupid = $_POST['groupid']; $visible = $_POST['visible']; $hide = GroupTracking::model()->findByAttributes(array('tracker_userid' => $userid, 'tracked_groupid' => $groupid)); if ($hide) { $hide->visible = $visible; if ($hide->save(false)) { echo $visible; } } }
<?php if (!($userid != Yii::app()->session['login']['id']) && isset($share) && $share != "share") { ?> <div class="create-finao-container" onclick="creategroup();"> <span class="create-finao-hdline"> Create a new GROUP</span> </div> <?php } ?> <?php $i = 0; foreach ($finaos as $group) { $i++; $visible = GroupTracking::model()->findByAttributes(array('tracked_groupid' => $group->group_id, 'tracker_userid' => Yii::app()->session['login']['id'])); ?> <?php /*?><div class="dashboard-group-container"> <a class="close-group" href="javascript:void(0);"> <img width="30" src="<?php echo $this->cdnurl;?>/images/close.png"></a> <?php if($userid != Yii::app()->session['login']['id'] || $share == "share"){ $url = array('groupid'=>$group->group_id,'frndid'=>$userid); } else {
public function actionTracking() { //print_r($_POST);exit; $tracked_userid = $_POST['userid']; $tracked_groupid = $_POST['groupid']; $tracker_userid = Yii::app()->session['login']['id']; $result = GroupTracking::model()->findByAttributes(array('tracker_userid' => $tracker_userid, 'tracked_groupid' => $tracked_groupid, 'tracked_userid' => $tracked_userid)); if (count($result) == '0') { $connection = yii::app()->db; $sql = "insert into fn_group_tracking set tracker_userid = '" . $tracker_userid . "',tracked_groupid='" . $tracked_groupid . "',tracked_userid='" . $tracked_userid . "',createddate='" . date('y-m-d') . "',status='1'"; //print_r($sql);exit; $command = $connection->createCommand($sql)->execute(); echo "UnJoin Group"; } else { $connection = yii::app()->db; $sql = "delete from fn_group_tracking where tracker_userid = '" . $tracker_userid . "' and tracked_groupid='" . $tracked_groupid . "' and tracked_userid='" . $tracked_userid . "'"; //print_r($sql);exit; $command = $connection->createCommand($sql)->execute(); echo "Join Group"; } }