public function run() { $this->userinfo = User::model()->findByPk($this->userid); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $this->userid . "' AND Iscompleted = 0"; if ($this->userid != Yii::app()->session['login']['id']) { $Criteria->condition = "AND finao_status_Ispublic = 0"; } $finaos = UserFinao::model()->findAll($Criteria); if (!empty($finaos)) { foreach ($finaos as $finaoids) { $ids[] = $finaoids->user_finao_id; } $Criteria = new CDbCriteria(); $Criteria->group = 'tile_id'; $Criteria->condition = "userid = '" . $this->userid . "'"; if (!empty($ids)) { $Criteria->addInCondition('finao_id', $ids); } $Criteria->order = 'createddate DESC'; $this->alltiles = UserFinaoTile::model()->findAll($Criteria); } else { $this->alltiles = ""; } $uploadtypeimage = Lookups::model()->findByAttributes(array('lookup_name' => 'Image', 'lookup_type' => 'uploadtype', 'lookup_status' => 1)); //$uploadsourcetypeimage = Lookups::model()->findByAttributes(array('lookup_type'=>'uploadsourcetype','lookup_name'=>'finao','lookup_status'=>1)); $uploadtypevideo = Lookups::model()->findByAttributes(array('lookup_name' => 'Video', 'lookup_type' => 'uploadtype', 'lookup_status' => 1)); //$uploadsourcetypevideo = Lookups::model()->findByAttributes(array('lookup_type'=>'uploadsourcetype','lookup_name'=>'finao','lookup_status'=>1)); $images = Uploaddetails::model()->findAllByAttributes(array('uploadtype' => $uploadtypeimage->lookup_id, 'uploadedby' => $this->userid, 'status' => 1)); $videos = Uploaddetails::model()->findAllByAttributes(array('uploadtype' => $uploadtypevideo->lookup_id, 'uploadedby' => $this->userid, 'status' => 1)); $this->imgcount = count($images); $this->videocount = count($videos); $this->render('_topheader', array('tilescount' => count($this->alltiles), 'userinfo' => $this->userinfo, 'finaocount' => count($finaos), 'imgcount' => $this->imgcount, 'videocount' => $this->videocount)); }
public function run() { /*$userid = Yii::app()->session['login']['id']; //$userid = Yii::app()->session['login']['id']; $criteria=new CDbCriteria; $criteria->distinct = true; $criteria->condition = "userid = '".$userid."'"; $alltiles = UserFinaoTile::model()->findAll($criteria);*/ if (isset($this->homepage)) { $userid = Yii::app()->session['login']['id']; $this->userinfo = User::model()->findByPk($userid); $widstyle = 'notile'; $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $userid . "' AND Iscompleted = 0"; $finaos = UserFinao::model()->findAll($Criteria); if (!empty($finaos)) { $Criteria = new CDbCriteria(); $Criteria->group = 'tile_id'; $Criteria->condition = "userid = '" . $userid . "'"; /*if(isset($_REQUEST['frndid'])) {*/ if (!empty($finaos)) { foreach ($finaos as $finaoids) { $ids[] = $finaoids->user_finao_id; } } if (!empty($ids)) { $Criteria->addInCondition('finao_id', $ids); } /*}*/ $Criteria->order = 'createddate DESC'; $this->alltiles = UserFinaoTile::model()->findAll($Criteria); } else { $this->alltiles = ""; } $uploadtypeimage = Lookups::model()->findByAttributes(array('lookup_name' => 'Image', 'lookup_type' => 'uploadtype', 'lookup_status' => 1)); //$uploadsourcetypeimage = Lookups::model()->findByAttributes(array('lookup_type'=>'uploadsourcetype','lookup_name'=>'finao','lookup_status'=>1)); $uploadtypevideo = Lookups::model()->findByAttributes(array('lookup_name' => 'Video', 'lookup_type' => 'uploadtype', 'lookup_status' => 1)); //$uploadsourcetypevideo = Lookups::model()->findByAttributes(array('lookup_type'=>'uploadsourcetype','lookup_name'=>'finao','lookup_status'=>1)); $images = Uploaddetails::model()->findAllByAttributes(array('uploadtype' => $uploadtypeimage->lookup_id, 'uploadedby' => $userid, 'status' => 1)); $videos = Uploaddetails::model()->findAllByAttributes(array('uploadtype' => $uploadtypevideo->lookup_id, 'uploadedby' => $userid, 'status' => 1)); $this->imgcount = count($images); $this->videocount = count($videos); $this->totaltilecount = count($this->alltiles); } if ($this->widgetstyle == 'tile') { $this->render('_tile', array('alltiles' => $this->alltiles, 'userinfo' => $this->userinfo, 'totaltilecount' => $this->totaltilecount, 'imgcount' => $this->imgcount, 'videocount' => $this->videocount)); } else { $this->render('_tilenotumb', array('alltiles' => $this->alltiles, 'userinfo' => $this->userinfo, 'totaltilecount' => $this->totaltilecount, 'imgcount' => $this->imgcount, 'videocount' => $this->videocount)); } }
public function getUserProfile($userid, $share, $groupid) { $userinfo = User::model()->findByPk($userid); $profileinfo = UserProfile::model()->findByAttributes(array('user_id' => $userid)); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $userid . "' and finao_activestatus != 2 and IsGroup = 1 and group_id=" . $groupid; if ($userid == Yii::app()->session['login']['id'] && $share != "share") { $Criteria->addCondition("Iscompleted = 0", "AND", "IsGroup = 0", "AND"); } if (isset($share) && $share == "share" || $userid != Yii::app()->session['login']['id']) { $Criteria->addCondition("finao_status_Ispublic = 1", "AND"); } $Criteria->order = "updateddate DESC"; $finaos = UserFinao::model()->findAll($Criteria); $latestfinao = UserFinao::model()->find(array('condition' => 'userid = ' . $userid . ' AND Iscompleted = 0 order by updateddate DESC')); if (!empty($finaos)) { $Criteria = new CDbCriteria(); $Criteria->group = 'tile_id'; $Criteria->condition = "userid = '" . $userid . "'"; $Criteria->select = "t1.tilename , t1.tile_imageurl , t1.Is_customtile, t.* "; if (!empty($finaos)) { foreach ($finaos as $finaoids) { $ids[] = $finaoids->user_finao_id; } } if (!empty($ids)) { $Criteria->addInCondition('finao_id', $ids); } $Criteria->order = 'createddate DESC'; $Criteria->join = " left join fn_tilesinfo t1 on t.tile_id = t1.tile_id and t.userid = t1.createdby "; $tilesinfo = UserFinaoTile::model()->findAll($Criteria); } else { $tilesinfo = ""; } return array('userid' => $userid, 'userinfo' => $userinfo, 'profileinfo' => $profileinfo, 'finao' => $latestfinao, 'tilesinfo' => $tilesinfo); }
<div class="col_2"> <?php //echo print_r($tiles);exit; ?> <div class="notif-message"> <?php foreach ($tiles as $message) { //$tilename = Lookups::model()->findByAttributes(array('lookup_id'=>$message->tracked_tileid)); //echo $tilename->lookup_name; $username = User::model()->findByAttributes(array('userid' => $message['tracker_userid'])); $userprofile = UserFinaoTile::model()->findByAttributes(array('tile_id' => $message['tracked_tileid'])); ?> <div class="notif-msg-left"> <img src="<?php echo $src; ?> " width="30" /> </div> <div class="notif-msg-right"> <?php
<p class="center" style="margin-top:20px;"> <a id="getjournal-<?php echo $eachfinao->user_finao_id; ?> " onclick="getalljournals(<?php echo $eachfinao->user_finao_id; ?> ,<?php echo $userid; ?> ,'completed')" class="journal-entry">Journal Log</a> </p> <div style="clear:both;"></div> <?php $tileid = UserFinaoTile::model()->findByAttributes(array('finao_id' => $eachfinao->user_finao_id, 'userid' => $eachfinao->userid)); ?> <!--<img src="<?php //echo Yii::app()->baseUrl; ?> /images/tiles/<?php //echo strtolower($tileid->tile_name); ?> .png" width="45"/>--> <div class="track-buttons"> <span class="left"> <ul class="tracking left"> <?php if ($eachfinao->finaoStatus->lookup_name == "Behind") { $class = "behind-btn behind-active"; } elseif ($eachfinao->finaoStatus->lookup_name == "Ahead") {
public function actionFirstvisitpage() { $userfinao = UserFinaoTile::model()->findAllByAttributes(array('userid' => Yii::app()->session['login']['id'])); $findusername = User::model()->findByPk(Yii::app()->session['login']['id']); if (isset(Yii::app()->session['login']['id'])) { if (empty($userfinao)) { //$this->render('profilelanding',array('findusername'=>$findusername)); //}else{ $this->redirect('profilelanding'); } } else { $this->redirect(array('/')); } }
public function getData($targetControl, $queryString, $emailvalue, $tilevalue) { switch ($targetControl) { /* Added on 29-01-2013 to search people in parentvalet */ case 'useremail': return User::model()->findAll(array('select' => 'fname,userid,lname,socialnetworkid', 'condition' => "fname like '" . $emailvalue . "%' or lname like '" . $emailvalue . "%' and userid not like " . Yii::app()->session['login']['id'] . " and status = 1 ", 'limit' => 20, 'group' => 'fname,userid,lname,socialnetworkid')); //return User::model()->findAll(array('select'=>'fname','condition'=>"fname like '".$emailvalue."%'", 'limit'=>20)); //return $criteria->condition; //return User::model()->findAll(array('select'=>'fname','condition'=>"fname like '".$emailvalue."%'", 'limit'=>20)); //return $criteria->condition; case 'usertile': $Criteria = new CDbCriteria(); $Criteria->select = "t.tile_id, t2.tilename, case when t2.is_customtile = 0 then CONCAT( LCASE( t2.tilename ) , '.jpg' ) else t2.tile_imageurl end as tile_imageurl, COUNT(DISTINCT t.userid ) as Usercnt"; $Criteria->join = " join fn_user_finao t1 ON t.finao_id = t1.user_finao_id\n\n\t\t\t\t\t\t\t\t\t\t\tAND t1.finao_status_Ispublic =1 AND t.status =1 AND t1.finao_activestatus = 1\n\n\t\t\t\t\t\t\t\t\t\tjoin fn_tilesinfo t2 ON t.tile_id = t2.tile_id AND t.userid = t2.createdby"; $Criteria->group = " t2.tilename "; $Criteria->condition = " t2.tilename like '" . $tilevalue . "%'"; //$Criteria->limit = 20; return UserFinaoTile::model()->findAll($Criteria); /* Ended on 29-01-2013 */ /* Ended on 29-01-2013 */ case 'User': $Criteria = new CDbCriteria(); $Criteria->select = "pa.name"; $Criteria->join = "LEFT JOIN fn_lookups AS pl ON t.usertypeid = pl.fn_lookup_id"; $Criteria->join .= " LEFT JOIN fn_address AS pa ON t.userid = pa.userid"; $Criteria->condition = "pl.lookup_type = 'UserData' AND pl.lookup_name = 'Organization' AND pa.name IS NOT NULL AND pa.name LIKE '" . $queryString . "%'"; //print_r($Criteria); $orgdet = User::model()->findAll($Criteria); //print_r($orgdet); return $orgdet; } }
<?php } ?> </div> <?php $finaos = UserFinao::model()->findByPK($finaoid); $tiles = UserFinaoTile::model()->findAll(array('condition' => 'finao_id =' . $finaoalll->upload_sourceid)); //print_r($tiles);exit; //echo $finaos->Iscompleted; if ($userid == Yii::app()->session['login']['id'] && $finaos->Iscompleted != 1 && isset($share) && $share != "share") { //exit; ?> <span style="display:none" id="set<?php echo $finaoalll->uploaddetail_id; ?> " class="edit-journal-options"> <div class="journal-setting-options">
<div style="overflow:hidden;background:url('<?php echo $src; ?> ') center center; width:90px; height:90px; background-size:90px 90px;" class="gallery-thumb-new smooth thumb-container-square"> </div> </div> <div class="finao-activity-text"> <?php $tileid = UserFinaoTile::model()->findByAttributes(array('finao_id' => $finaoalll->user_finao_id)); ?> <div class="finao-text"><a href="javascript:void(0);" onClick="getthatfinao(<?php echo $finaoalll->user_finao_id; ?> );getfinaos(<?php echo $userid; ?> ,<?php echo $tileid->tile_id; ?> )"><?php echo $finaoalll->finao_msg; ?> </a></div>
} else { $imgsrc = $this->cdnurl . "/images/no-image-small.jpg"; } } } } if (isset($user) && isset($user->profile_image)) { $profileimg = $this->cdnurl . "/images/uploads/profileimages/" . $user->profile_image; } else { $profileimg = $this->cdnurl . "/images/no-image-small.jpg"; } ?> <div class="finao-desc-media"> <?php $tileid = UserFinaoTile::model()->findByAttributes(array('tile_id' => $tppl->tile_id, 'finao_id' => $tppl->finao_id)); $groupid = UserFinao::model()->findByAttributes(array('user_finao_id' => $tppl->finao_id, 'IsGroup' => 1)); if ($groupid) { $res = 'group'; } else { $res = 'tile'; } ?> <div class="finao-content-caption"><?php echo $tppl->finao_msg; ?> </div> <div class="finao-hero-content"> <div style="overflow:hidden;background:url('<?php echo $imgsrc;
,'images');" class="tile-container-navigation-right" href="javascript:void(0)"> </a> <?php } ?> <?php } ?> </div> <div class="detailed-container"> <?php foreach ($uploadinfo as $eachImgVid) { $tileid = UserFinaoTile::model()->findByAttributes(array('finao_id' => $eachImgVid['upload_sourceid'])); if ($eachImgVid["upload_sourcetype"] == '37') { $finaomsg = UserFinao::model()->findByPk($eachImgVid['upload_sourceid']); $finaomsg = $finaomsg->finao_msg; } else { if ($eachImgVid["upload_sourcetype"] == '36') { $finaomsg = TilesInfo::model()->findByAttributes(array('tile_id' => $eachImgVid['upload_sourceid'])); $finaomsg = $finaomsg->tilename; } else { $finaomsg = UserFinaoJournal::model()->findByAttributes(array('finao_id' => $eachImgVid['upload_sourceid'], 'user_id' => $_REQUEST['userid'])); $finaomsg = $finaomsg->finao_journal; //print_r($uploadinfo[0][upload_sourceid]);exit; } } if ($uploadtype == 'Image') { if (file_exists(Yii::app()->basePath . "/../" . $eachImgVid["uploadfile_path"] . "/thumbs/" . $eachImgVid["uploadfile_name"]) && $eachImgVid["uploadfile_name"] != "") {
public function actionaddNewFinao() { $userid = Yii::app()->session['login']['id']; $user = User::model()->findByPk($userid); $userinfo = UserProfile::model()->findByAttributes(array('user_id' => $userid)); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $userid . "' AND Iscompleted = 0 AND finao_activestatus = 1"; if (isset($_REQUEST['frndid'])) { $Criteria->addCondition("finao_status_Ispublic = 1", 'AND'); } $Criteria->order = "updateddate DESC"; $finaos = UserFinao::model()->findAll($Criteria); if (!empty($finaos)) { $Criteria = new CDbCriteria(); $Criteria->group = 'tile_id'; $Criteria->condition = "userid = '" . $userid . "'"; if (!empty($finaos)) { foreach ($finaos as $finaoids) { $ids[] = $finaoids->user_finao_id; } } if (!empty($ids)) { $Criteria->addInCondition('finao_id', $ids); } $Criteria->order = 'updateddate DESC'; $tilesinfo = UserFinaoTile::model()->findAll($Criteria); } else { $tilesinfo = ""; } $tileslist = $tilesinfo; $totaltilecount = count($tilesinfo); $tiles = Lookups::model()->findAll(array('condition' => 'lookup_type = "tiles" AND lookup_status = 1 ')); $this->renderPartial('_newfinaolayout', array('model' => $model, 'userid' => $userid, 'tiles' => $tilesinfo, 'newtile' => $newtile, 'upload' => $upload, 'type' => $type, 'userinfo' => $userinfo)); //$this->renderPartial('_newfinaolayout',array('newfinao'=>'new')); }
public function actionUpdatedetails() { //print_r($_POST);exit; $groupid = $_POST['groupid']; $uploaddetail_id = $_POST['uploaddetail_id']; $userid = $_POST['userid']; // only caption edit $dates = date('Y-m-d H:i:s'); $connection = yii::app()->db; if ($_POST['type'] == 'video') { $sql = "UPDATE fn_uploaddetails SET video_caption='" . $_POST['caption'] . "',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; } else { $sql = "UPDATE fn_uploaddetails SET caption='" . $_POST['caption'] . "',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; } $command = $connection->createCommand($sql); $command->execute(); if (!empty($_FILES['journalimage']['name'])) { $filename = ''; $result = 'ERROR'; $result_msg = ''; $allowed_image = array('image/gif', 'image/jpeg', 'image/jpg', 'image/png'); define('PICTURE_SIZE_ALLOWED', 10485760); // bytes 2242880 if (isset($_FILES['journalimage'])) { if ($_FILES['journalimage']['error'] == UPLOAD_ERR_OK) { if (in_array($_FILES['journalimage']['type'], $allowed_image)) { if (filesize($_FILES['journalimage']['tmp_name']) <= PICTURE_SIZE_ALLOWED) { $filename = $_POST['finaoid'] . '-' . rand(125678, 00) . '-' . $_FILES['journalimage']['name']; $source = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages' . '/' . $filename; move_uploaded_file($_FILES['journalimage']['tmp_name'], $source); if (file_exists($source)) { $upload = new Uploaddetails(); $destination = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages/thumbs/' . $filename; $destination1 = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages/medium/' . $filename; $this->generatethumb($source, $destination, 90, 90); $this->generatethumb($source, $destination1, 240, 240); $dates = date('Y-m-d H:i:s'); $connection = yii::app()->db; $sql = "UPDATE fn_uploaddetails SET uploadfile_name='" . $filename . "',uploadfile_path='/images/uploads/finaoimages',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; $command = $connection->createCommand($sql); $command->execute(); } //phpclamav clamscan for scanning viruses //passthru('clamscan -d /var/lib/clamav --no-summary '.$filename, $virus_msg); //scan virus $virus_msg = 'OK'; //assume clamav returing OK. if ($virus_msg != 'OK') { unlink($source); $result_msg = $filename . " : " . FILE_VIRUS_AFFECTED; $result_msg = '<font color=red>' . $result_msg . '</font>'; $filename = ''; } else { // main action -- move uploaded file to $upload_dir $result = 'OK'; } } else { $filesize = filesize($_FILES['file']['tmp_name']); // or $_FILES['file']['size'] $filetype = $_FILES['file']['type']; $result_msg = PICTURE_SIZE; } } else { $result_msg = SELECT_IMAGE; } } elseif ($_FILES['file']['error'] == UPLOAD_ERR_INI_SIZE) { $result_msg = 'The uploaded file exceeds the upload_max_filesize directive in php.ini'; } else { $result_msg = 'Unknown error'; } } } $finao = Uploaddetails::model()->findByPK($uploaddetail_id); $finaoid = $finao->upload_sourceid; $finaos = new UserFinao(); $finaos = UserFinao::model()->findByPk($finaoid); if (!empty($finaos)) { $finaos->updateddate = new CDbExpression('NOW()'); $finaos->save(false); $tileiddata = UserFinaoTile::model()->findByAttributes(array('finao_id' => $finaoid, 'userid' => $userid, 'status' => 1)); $this->addTrackingNotifications($userid, $tileiddata['tile_id'], 'Added Image To Journal', $finaoid, 0); if ($groupid != '') { $this->redirect(Yii::app()->createUrl('group/dashboard', array('menutype' => 'finao', 'finaoid' => $finaoid, 'groupid' => $groupid))); } else { $this->redirect(Yii::app()->createUrl('finao/motivationMesg', array('menutype' => 'finao', 'finaoid' => $finaoid))); } } //$tempdocmodel=Uploaddetails::model()->updateByPk($Model->$_POST['journalid'],array("status"=>'ok')); // $filesmodel=UserFinaoJournal::model()->updateAll(array('user'=>"$userid",'date'=>$currenttime),"status=>'ok'"); }
public function run() { $user = UserProfile::model()->findByAttributes(array('user_id' => $this->userid)); $ontrackid = Lookups::model()->findByAttributes(array('lookup_type' => 'finaostatus', 'lookup_name' => 'On Track')); $aheadid = Lookups::model()->findByAttributes(array('lookup_type' => 'finaostatus', 'lookup_name' => 'Ahead')); $behindid = Lookups::model()->findByAttributes(array('lookup_type' => 'finaostatus', 'lookup_name' => 'Behind')); if (isset($this->tileid)) { $finaos = UserFinaoTile::model()->findAllByAttributes(array('tile_id' => $this->tileid, 'userid' => $this->userid)); foreach ($finaos as $finaoids) { $ids[] = $finaoids->finao_id; } } if (isset($this->groupid) && $this->groupid != "") { $condition = "and IsGroup = 1 and group_id = " . $this->groupid . ""; } else { $condition = "and IsGroup = 0 "; } $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $this->userid . "' and finao_activestatus = 1 and IsCompleted = 0 " . $condition . ""; if (isset($ids) && !empty($ids)) { $Criteria->addInCondition('user_finao_id', $ids); } if (Yii::app()->session['login']['id'] != $this->userid || $this->share == "share") { $Criteria->addCondition("finao_status_Ispublic = 1", 'AND'); } $Criteria->order = "updateddate DESC"; $Criteria->addCondition("finao_status = '" . $ontrackid->lookup_id . "'", 'AND'); $ontrack = UserFinao::model()->findAll($Criteria); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $this->userid . "' and finao_activestatus != 2 and IsCompleted = 0"; if (isset($ids) && !empty($ids)) { $Criteria->addInCondition('user_finao_id', $ids); } if (Yii::app()->session['login']['id'] != $this->userid || $this->share == "share") { $Criteria->addCondition("finao_status_Ispublic = 1", 'AND'); } $Criteria->order = "updateddate DESC"; $Criteria->addCondition("finao_status = '" . $aheadid->lookup_id . "'", 'AND'); $ahead = UserFinao::model()->findAll($Criteria); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $this->userid . "' and finao_activestatus != 2 and IsCompleted = 0"; if (isset($ids) && !empty($ids)) { $Criteria->addInCondition('user_finao_id', $ids); } if (Yii::app()->session['login']['id'] != $this->userid || $this->share == "share") { $Criteria->addCondition("finao_status_Ispublic = 1", 'AND'); } $Criteria->order = "updateddate DESC"; $Criteria->addCondition("finao_status = '" . $behindid->lookup_id . "'", 'AND'); $behind = UserFinao::model()->findAll($Criteria); $Criteria = new CDbCriteria(); $Criteria->condition = "userid = '" . $this->userid . "' and finao_activestatus != 2 and IsCompleted = 1"; if (isset($ids) && !empty($ids)) { $Criteria->addInCondition('user_finao_id', $ids); } $Criteria->order = "updateddate DESC"; $completed = UserFinao::model()->findAll($Criteria); /*$ontrack = UserFinao::model()->findAll(array('condition'=>'userid = "'.$this->userid.'" AND finao_status = 38')); $ahead = UserFinao::model()->findAll(array('condition'=>'userid = "'.$this->userid.'" AND finao_status = 39')); $behind = UserFinao::model()->findAll(array('condition'=>'userid = "'.$this->userid.'" AND finao_status = 40'));*/ if (isset($this->frndprofile)) { $frndprofile = "mainpage"; } else { $frndprofile = "no"; } if (isset($this->left)) { $leftlayout = "leftlayout"; } else { $leftlayout = ""; } if (isset($this->finao)) { $finaopage = "finao"; } else { $finaopage = ""; } $this->render('_progressBar', array('user' => $user, 'ontrack' => $ontrack, 'ahead' => $ahead, 'behind' => $behind, 'frndprofile' => $frndprofile, 'leftlayout' => $leftlayout, 'finaopage' => $finaopage, 'completed' => $completed)); }
public function displayYourGroupTracking($userid, $share, $type, $tileid, $groupid) { $tiletxt = isset($tileid) ? $tileid != "" ? 'and tracked_tileid = ' . $tileid : "" : ""; if ($type == "yourtracking") { $imtracking = Tracking::model()->findAllByAttributes(array('tracker_userid' => $userid, 'status' => 1)); } elseif ($type == "trackingyou") { // old code //$imtracking = Tracking::model()->findAll(array('condition'=>'tracked_userid = '.$userid .' and status=1 '.$tiletxt,'select'=>'distinct tracker_userid')); $imtracking = Tracking::model()->findAll(array('condition' => 'tracked_userid = ' . $userid . ' and status!=0 ' . $tiletxt, 'select' => 'distinct tracker_userid')); $criteria = new CDbCriteria(); $criteria->join = ' join fn_user_finao t1 ON t.finao_id = t1.user_finao_id and t1.group_id=' . $groupid . ''; $criteria->join .= ' join fn_tracking t2 on t.tile_id = t2.tracked_tileid'; $criteria->condition = ' t1.finao_status_Ispublic =1 and t2.tracked_userid = ' . $userid; $criteria->group = ' t.tile_id,t.tile_name'; $findalltiles = UserFinaoTile::model()->findAll($criteria); } return array('findalltiles' => $findalltiles, 'type' => $type, 'imtracking' => $imtracking, 'userid' => $userid, 'tileid' => $tileid, 'share' => $share); }