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";
}
}
