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