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