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 actionGetVideocontestdetail()
{
//print_r($_REQUEST);
if (isset($_REQUEST["videoid"])) {
$userid = Yii::app()->session['login']['id'];
$videoid = $_REQUEST["videoid"];
$vidler = Yii::app()->getComponents(false);
$user = $vidler['vidler']['user'];
$pass = $vidler['vidler']['pwd'];
$api_key = $vidler['vidler']['appkey'];
$callback_url = '/';
$v = new Viddler_V2($api_key);
$auth = $v->viddler_users_auth(array('user' => $user, 'password' => $pass));
$sessionid = $auth['auth']['sessionid'];
$results = $v->viddler_videos_getDetails(array('sessionid' => $sessionid, 'video_id' => $videoid));
//exit;
// print_r($results);exit;
if (!empty($results)) {
$finaomsg = $results['video']['description'];
$newfinao = new UserFinao();
// for badword
$words = str_word_count($finaomsg, 1);
$lastWord = array_pop($words);
$lastSpacePosition = strrpos($finaomsg, ' ');
$textWithoutLastWord = $finaomsg;
$tiles = FnProfanityWords::model()->findAll();
foreach ($tiles as $tiles) {
if (strtolower($lastWord) == strtolower($tiles->badword)) {
$textWithoutLastWord = substr($finaomsg, 0, $lastSpacePosition);
$textWithoutLastWord .= ' **** ';
}
}
if (isset($finaomsg) && $finaomsg != "") {
$newfinao->finao_msg = $textWithoutLastWord;
}
$public = 1;
$newfinao->finao_status_Ispublic = $public;
$newfinao->userid = $userid;
$newfinao->createddate = new CDbExpression('NOW()');
$newfinao->updatedby = $userid;
$newfinao->updateddate = new CDbExpression('NOW()');
$newfinao->finao_status = 38;
if ($newfinao->save(false)) {
$finao_id = $newfinao->user_finao_id;
$tileid = 66;
$newtile = new UserFinaoTile();
$newtile->tile_id = $tileid;
$newtile->tile_name = 'Career Catapult';
$newtile->finao_id = $newfinao->user_finao_id;
$tileimgurl = 'careercatapult.jpg';
$newtile->tile_profileImagurl = $tileimgurl;
$newtile->userid = $userid;
$newtile->status = 1;
$newtile->createddate = new CDbExpression('NOW()');
$newtile->createdby = $userid;
$newtile->updateddate = new CDbExpression('NOW()');
$newtile->updatedby = $userid;
if ($newtile->save(false)) {
//echo $newtile->user_tileid;
$tilename = 'Career Catapult';
$istileinfo = TilesInfo::model()->findByAttributes(array('tilename' => $tilename, 'createdby' => $userid));
if (!isset($istileinfo) && empty($istileinfo)) {
$tileinfo = new TilesInfo();
$tileinfo->tile_id = $tileid;
$tileinfo->tilename = $tilename;
$tileinfo->tile_imageurl = $tileimgurl;
$tileinfo->status = 1;
$tileinfo->createdby = $userid;
$tileinfo->createddate = new CDbExpression('NOW()');
$tileinfo->updateddate = new CDbExpression('NOW()');
$tileinfo->updatedby = $userid;
$tileinfo->save(false);
}
/*echo 'FInaoid-'.$finao_id.'userid-'.$userid.'Video Id-'.$videoid;exit;*/
$uploadvideo = new Uploaddetails();
$uploadvideo->upload_sourcetype = 37;
$uploadvideo->uploadtype = 35;
$uploadvideo->upload_sourceid = $finao_id;
$uploadvideo->uploadedby = $userid;
$uploadvideo->uploadeddate = new CDbExpression('NOW()');
$uploadvideo->status = 0;
$uploadvideo->updatedby = $userid;
$uploadvideo->updateddate = new CDbExpression('NOW()');
$uploadvideo->videoid = $videoid;
$uploadvideo->videostatus = "not ready";
$uploadvideo->video_img = $results['video']['thumbnail_url'];
$uploadvideo->video_caption = $results['video']['title'];
if ($uploadvideo->save(false)) {
$usercheck = User::model()->findByAttributes(array('userid' => Yii::app()->session['login']['id'], 'status' => 1));
$aprroveurl = 'http://' . $_SERVER['HTTP_HOST'] . '/finao/AprroveVideo/userid/' . $usercheck->userid . '/uploadid/' . $uploadvideo->uploaddetail_id;
$mesg = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Registration Confirmation</title>
</head>
<body>
<div style="width:670px; margin:0px auto; padding:0px; background:#FFF; border-left:solid 20px #dddddd; border-right:solid 20px #dddddd;">
<div><img src="http://' . $_SERVER['HTTP_HOST'] . '/images/Email_Header.png" style="padding:0; margin:0; border:0;" /></div>
<div style="width:650px; padding:10px; margin:0px; font-family:Geneva, Arial, Helvetica, sans-serif;"><br />
<div style="color:rgb(244, 123, 32); font-weight:bold; font-size:16px; padding-bottom:5px;">Dear Admin,</div>
<div style="color:rgb(77,77,77); font-size:12px; line-height:18px; padding-bottom:15px;">
<p>' . ucfirst($usercheck->fname) . ' has posted a Video.</p>
<p>Please review the Video by clicking on the View Video button below and click on the Approve Video button to publish this video. </p>
<p>If you happen to see the message "Video not Found" or "Encoding in Progress", Please check back later. Video encoding sometimes can take up to an hour.</p>
<p> <a href="http://www.viddler.com/v/' . $videoid . '" target="_new"><img src="http://' . $_SERVER['HTTP_HOST'] . '/images/view-video.jpg"></a>
<a href="' . $aprroveurl . '" target="_new" ><img src="http://' . $_SERVER['HTTP_HOST'] . '/images/approve-video.jpg"></a><br /> <br />
</p>
</div>
<div style="color:rgb(77,77,77); font-size:12px; line-height:12px; padding-bottom:10px;"> </div>
<div><img src="http://' . $_SERVER['HTTP_HOST'] . '/images/Signature.png" style="border:0; padding:0; margin:0;" /></div>
</div>
<div style="width:650px; margin:0px auto; text-align:right">
<ul style="list-style:none; margin:0px; padding:0px;">
<a target="_blank" href="https://www.facebook.com/FINAONation"><li style="background:url(http://finaonation.com/images/soc-icons.png) 0 -38px; width:13px; height:29px; display:inline-block; list-style:none; margin:0 4px;"></li></a>
<a target="_blank" href="http://pinterest.com/finaonation/"><li style="background:url(http://finaonation.com/images/soc-icons.png) -80px -38px; width:24px; height:30px; display:inline-block; list-style:none; margin:0 4px;"></li></a>
<a target="_blank" href="http://www.linkedin.com/company/2253999"><li style="background:url(http://finaonation.com/images/soc-icons.png) -21px -38px; width:26px; height:27px; display:inline-block; list-style:none; margin:0 4px;"></li></a>
<a target="_blank" href="https://twitter.com/FINAONation"><li style="background:url(http://finaonation.com/images/soc-icons.png) -53px -38px; width:20px; height:26px; display:inline-block; list-style:none; margin:0 4px;"></li></a>
</ul>
</div>
<div style="background:#000; width:670px; font-size:11px; color:rgb(153, 153, 153); text-align:center; padding:10px 0; font-family:Geneva, Arial, Helvetica, sans-serif;">
<div style="padding-bottom:5px;">This message was mailed to <span style="color:rgb(244, 123, 32)!important;">' . $email . '</span> by FINAO Nation.</div>
<div style="padding-bottom:5px;">
<a href="http://' . $_SERVER['HTTP_HOST'] . '" style="color:rgb(244, 123, 32); padding:0 5px; text-decoration:underline;">FINAO</a> |
<a href="http://' . $_SERVER['HTTP_HOST'] . '/profile/contactus" style="color:rgb(244, 123, 32); padding:0 5px; text-decoration:underline;">Contact Us</a> |
<a href="http://' . $_SERVER['HTTP_HOST'] . '/profile/aboutus" style="color:rgb(244, 123, 32); padding:0 5px; text-decoration:underline;">About FINAO</a> |
<a href="mailto:unsubscribe@finaonation.com?Subject=Hello%20again" style="color:rgb(244, 123, 32); padding:0 5px; text-decoration:underline;">Unsubscribe</a>
</div>
<div>
<div style="padding:0px!important; margin:0px!important; line-height:18px;">To unsubscribe, click the link above, or send an email to: <a href="#" style="color:rgb(153, 153, 153)!important; text-decoration:none; cursor:default;">unsubscribe@finaonation.com</a>. Do not reply to this email address.</div>
<div style="padding:0px!important; margin:0px!important; line-height:18px;">It is a notification only address and is not monitored for incoming email. </div>
<div style="padding:0px!important; margin:0px!important; line-height:18px;">Use of the FINAO Nation website and mobile app constitutes acceptance of our Terms of Use and Privacy Policy.</div>
<div style="padding:0px!important; margin:0px!important; line-height:18px;">© ' . date("Y") . ' FINAO Nation, 13024 Beverly Park Rd, Mukilteo, WA 98275, U.S.A.</div>
</div>
</div>
</div>
</body>
</html>';
$subj = "video Contest";
// To send HTML mail, the Content-type header must be set
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
// Additional headers
$headers .= 'From:Finaonation <*****@*****.**>' . "\r\n";
$headers .= 'Bcc: dev@wincito.com,nagesh@wincito.com' . "\r\n";
$to = '*****@*****.**';
//$to = 'wallace@finaonation.com,georgie@finaonation.com,robert@finaonation.com';
mail($to, $subj, $mesg, $headers);
$this->redirect(Yii::app()->createUrl('finao/Viewvideohdcu/video/true'));
}
}
}
}
}
}
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);
}
