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()
{
$this->selheader = "register";
$model = new User();
$gender = Lookups::model()->findAllByAttributes(array('lookup_type' => 'UIValues-Gender'));
$gender2 = CHtml::listData($gender, 'lookup_id', 'lookup_name');
$this->render('_regform', array('gender' => $gender2, 'model' => $model));
}
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 run()
{
switch ($this->type) {
case 'group':
$resultinfo = Group::model()->findByAttributes(array('group_id' => $this->pid));
break;
case 'tile':
$resulttileinfo = Lookups::model()->findByAttributes(array('lookup_id' => $this->pid));
break;
case 'video':
$resultgroupinfo = '';
break;
}
$this->render('_easyregister', array('type' => $this->type, 'pid' => $this->pid, 'resultinfo' => $resultinfo, 'resulttileinfo' => $resulttileinfo));
}
public function actionDeletefj()
{
$userid = Yii::app()->session['login']['id'];
$groupid = $_POST['groupid'];
// groups tabel deleting
$groups = Group::model()->findByAttributes(array('group_id' => $groupid));
//$groups = new Group;
$groups->group_activestatus = '2';
if ($groups->save(false)) {
echo "success";
}
$imagetypeid = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadtype', 'lookup_status' => 1, 'lookup_name' => 'Image'));
$videotypeid = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadtype', 'lookup_status' => 1, 'lookup_name' => 'Video'));
$sourcetypeidfinao = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadsourcetype', 'lookup_status' => 1, 'lookup_name' => 'finao'));
$sourcetypeidtile = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadsourcetype', 'lookup_status' => 1, 'lookup_name' => 'tile'));
$tracked_tileids = Yii::app()->session['login']['id'];
/*$tileinfo = Tracking::model()->findAllByAttributes(array('tracked_userid'=>$tracked_tileids,'tracked_tileid'=>$tileid));
if(isset($tileinfo['0']['tracking_id']))
{
$tileinfo = Tracking::model()->findByAttributes(array('tracking_id'=>$tileinfo['0']['tracking_id']));
$tileinfo->delete();
} */
$sourcetypeidjournal = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadsourcetype', 'lookup_status' => 1, 'lookup_name' => 'journal'));
$groupfinao = UserFinao::model()->findByAttributes(array('group_id' => $groupid));
// finaos deleteing
$type = "finao";
if ($type == "finao") {
// uploadedetails deleteing
$delfiles = Uploaddetails::model()->findAllByAttributes(array('upload_sourceid' => $groupfinao->user_finao_id));
//$delfiles1 = Uploaddetails::model()->findAllByAttributes(array('uploadtype'=>$videotypeid->lookup_id,'upload_sourcetype'=>$sourcetypeidfinao->lookup_id,'upload_sourceid'=>$journalid,'uploadedby'=>$userid));
if (isset($delfiles) && !empty($delfiles)) {
foreach ($delfiles as $image) {
$image->status = 2;
$image->save(false);
}
}
/*if(isset($delfiles1) && !empty($delfiles1))
{
foreach($delfiles1 as $video)
{
$video->status = 2;
$video->save(false);
}
}*/
$tiles = UserFinaoTile::model()->findAllByAttributes(array('finao_id' => $groupfinao->user_finao_id, 'createdby' => $userid));
if (isset($tiles) && !empty($tiles)) {
foreach ($tiles as $eachtile) {
$eachtile->status = '2';
$eachtile->save(false);
}
}
// finaos deleteing
$finaodel = UserFinao::model()->findAllByAttributes(array('user_finao_id' => $groupfinao->user_finao_id, 'updatedby' => $userid));
//echo $groupfinao->user_finao_id; echo $userid;
if (isset($finaodel) && !empty($finaodel)) {
$finaodel->finao_activestatus = '2';
$finaodel->save(false);
}
$tracked_tileids = Yii::app()->session['login']['id'];
$tileinfo = Tracking::model()->findAllByAttributes(array('tracked_userid' => $tracked_tileids, 'tracked_tileid' => $tileid));
if (isset($tileinfo['0']['tracking_id'])) {
$tileinfo = Tracking::model()->findByAttributes(array('tracking_id' => $tileinfo['0']['tracking_id']));
$tileinfo->delete();
}
//echo "successful";
}
}
public function getIntresstNames($intrestId)
{
$modelIntresst = Lookups::model()->findAll(array('condition' => 'pv_lookup_id ="' . $intrestId . '" AND lookup_type="interests"'));
if (isset($modelIntresst)) {
if (count($modelIntresst) > 0) {
foreach ($modelIntresst as $modInt) {
return $modInt['lookup_name'];
}
} else {
return $intrestId;
}
}
}
<div id = "showcompletedfinaodiv-default" style="display:none">
</div>
<!------------------ SEARCH DIV FOR TRACKING AND TRACKERS END ---------------- -->
<!------------------ JOURNAL DIV FOR TRACKING AND TRACKERS START ---------------- -->
<div class="tracking" id="followtracking" style="display:none;">
<?php
$findalltiles = Lookups::model()->findAllByAttributes(array('lookup_type' => 'tiles'));
?>
<?php
//$userid = Yii::app()->session['login']['id'];
?>
<div class="padding-10pixels">
public function actionBrowseVideoImage()
{
$uploadtype = isset($_REQUEST['imgvid']) ? $_REQUEST['imgvid'] : "";
if ($uploadtype != "") {
$page = isset($_REQUEST['pageid']) ? $_REQUEST['pageid'] : 1;
$targetdiv = $_REQUEST['targetdiv'];
$limit = 1;
$uptypeid = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadtype', 'lookup_name' => $uploadtype));
$criteria = new CDbCriteria();
$criteria->condition = " explore_finao = 1 and uploadtype = " . $uptypeid->lookup_id;
$criteria->order = "updateddate desc";
$uploadImages = Uploaddetails::model()->findAll($criteria);
$upPageNav = FinaoController::getpagedetails($uploadImages, 1, $page, 1);
//$criteria->limit = $upPageNav["limittxt"];
//$lim = FinaoController::getpagecount(count($uploadImages),$limit,$page);
//print_r($upPageNav);exit;
$criteria->limit = $upPageNav['limittxt'];
$criteria->offset = $upPageNav['offset'];
$uploadImages = Uploaddetails::model()->findAll($criteria);
$videoembedurl = "";
$caption = "";
$userimg = "";
if (isset($uploadImages) && $uploadImages != "" && count($uploadImages) >= 1) {
foreach ($uploadImages as $vidup) {
if ($uploadtype == 'Video') {
if ($vidup->videoid != "" && $vidup->videostatus == 'ready') {
$videoembedurl = FinaoController::getviddlembedCode($vidup->videoid);
} elseif ($vidup->video_embedurl != "") {
$videoembedurl = $vidup->video_embedurl;
}
} elseif ($uploadtype == 'Image') {
$filename = $vidup->uploadfile_path . "/" . $vidup->uploadfile_name;
if (file_exists(Yii::app()->basePath . "/../" . $filename)) {
$videoembedurl = Yii::app()->baseUrl . $filename;
}
}
$caption = $vidup->caption;
$userimg = User::model()->findByPk($vidup->uploadedby);
}
}
$this->renderPartial('_browserImagVideo', array('videoembedurl' => $videoembedurl, 'uploadtype' => $uploadtype, 'upPageNav' => $upPageNav, 'caption' => $caption, 'targetdiv' => $targetdiv, 'userinfo' => $userimg));
}
}
public function actionGetConnectionDetails()
{
$userid = $_REQUEST["id"];
$userAlpha = array();
//$userBeta = array();
$userdetails = User::model()->findAll(array("condition" => "userid = " . $userid));
$usertiles = UserTile::model()->findAll(array('condition' => 'userid = "' . $userid . '" AND status = 1'));
/*$displaytiles = array();
foreach($usertiles as $tilename)
{
$displaytiles[$tilename->tile_name] = $tilename->tile_name;
} */
foreach ($userdetails as $usr) {
$userAlpha["userid"] = $usr->userid;
$userAlpha["email"] = $usr->email;
$userAlpha["profile_image"] = $usr->profile_image;
$userAlpha["lname"] = $usr->lname;
$userAlpha["location"] = $usr->location;
$userAlpha["fname"] = $usr->fname;
$userAlpha["description"] = $usr->description;
//$userAlpha["socialnetworkid"] = $usr->socialnetworkid;
}
/*foreach($userdetails as $tile)
{
$userBeta["tile_name"] = $usr->tile_name;
}*/
$alltags = Lookups::model()->findAll(array('condition' => "lookup_type = 'tag' and lookup_status=1"));
$this->renderPartial('_networkDetail', array('firstConnection' => $userAlpha, 'displaytiles' => $usertiles));
}
public function init()
{
$this->interest = Lookups::model()->findAllByAttributes(array('lookup_parentid' => 0, 'lookup_type' => 'interests'));
}
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 actionLearnmore()
{
$this->layout = '/layouts/column4';
$sql = "select t.userid,t.fname,t.lname, t1.user_location,t1.profile_image, t2.*\n\t\tfrom fn_users t \n\t\tjoin fn_user_profile t1 on t.userid = t1.user_id\n join (select t.*,t2.tilename,t3.lookup_name,t4.video_embedurl,t4.videoid,t4.video_img,t4.video_caption,t4.uploaddetail_id \n from fn_user_finao t \n join fn_user_finao_tile t1 on t.user_finao_id = t1.finao_id and t.userid = t1.userid\n\t\t\t join fn_tilesinfo t2 on t1.tile_id = t2.tile_id and t1.userid = t2.createdby\t\n join fn_lookups t3 on t.finao_status = t3.lookup_id \n join fn_uploaddetails t4 on t1.finao_id = t4.upload_sourceid\n where t2.tile_id=66\n and t.finao_activestatus = 1\n and t.finao_status_Ispublic = 1\n and t4.video_img !=''\n\t\t\t\t\t\t\t and t4.videostatus='ready'\n group by t.userid,t1.tile_id) \n\t\tt2 on t.userid = t2.userid\n\t\tgroup by t.fname,t.lname order by uploaddetail_id desc limit 0,4";
$connection = Yii::app()->db;
$command = $connection->createCommand($sql);
$userdet = $command->queryAll();
$finaoids = "";
for ($i = 0; $i < count($userdet); $i++) {
$finaoids .= $userdet[$i]["user_finao_id"] . ",";
}
if ($finaoids != "") {
$finaoids = substr($finaoids, 0, strlen($finaoids) - 1);
$sourcetypeid = Lookups::model()->findByAttributes(array('lookup_type' => 'uploadsourcetype', 'lookup_status' => 1, 'lookup_name' => 'finao'));
$uploaddetails = $this->getlatestuploaddetails($finaoids, $sourcetypeid->lookup_id);
}
// winners
$sql = "select t.userid,t.fname,t.lname, t2.*\n\t\tfrom fn_users t \n\t\tjoin fn_user_profile t1 on t.userid = t1.user_id\n join (select t.*,t2.tilename,t3.lookup_name,t4.video_embedurl,t4.videoid,t4.video_img,t4.video_caption,t4.uploaddetail_id \n from fn_user_finao t \n join fn_user_finao_tile t1 on t.user_finao_id = t1.finao_id and t.userid = t1.userid\n\t\t\t join fn_tilesinfo t2 on t1.tile_id = t2.tile_id and t1.userid = t2.createdby\t\n join fn_lookups t3 on t.finao_status = t3.lookup_id \n join fn_uploaddetails t4 on t1.finao_id = t4.upload_sourceid\n where t2.tile_id=66\n and t.finao_activestatus = 1\n and t.finao_status_Ispublic = 1\n and t4.video_img !=''\n\t\t\t\t\t\t\t and t4.winner=1\n group by t.userid,t1.tile_id\n order by t.updateddate desc) \n\t\t\t\t\t\t\t\tt2 on t.userid = t2.userid\n\t\t\t\t\t\t\t\tgroup by t.fname,t.lname\n\t\t\t\t\t\t\t\torder by t.fname,t.lname";
$command = $connection->createCommand($sql);
$winner = $command->queryAll();
$this->render('_learnmore', array('userdets' => $userdet, 'winner' => $winner, 'uploaddetails' => $uploaddetails, 'tilename' => $tilename, 'totalcnt' => count($userdet)));
}
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 actionTracktiles()
{
$findalltiles = Lookups::model()->findAllByAttributes(array('lookup_type' => 'tiles'));
$this->renderPartial('tracktiles', array('findalltiles' => $findalltiles));
}
