public function actionMotivationMesg() { //$this->actionRefreshwidget('hi'); if (isset(Yii::app()->session['login']['id'])) { $userid = Yii::app()->session['login']['id']; if (isset($_REQUEST['frndid'])) { $frndid = $_REQUEST['frndid']; if ($frndid != $userid) { $userid = $frndid; } } } else { if (isset($_REQUEST['frndid'])) { $frndid = $_REQUEST['frndid']; /*This code is added for making specific profiles public*/ $profiles = array(64, 124, 16, 101, 100, 99, 279, 280, 255, 115, 265, 449, 270, 371, 248, 241, 63, 246, 239, 106, 68, 193, 289, 67, 107, 597, 362, 303, 256, 333); //246,239,106,68,193,289,67 ///371,270,449,248,241,63 if (in_array($frndid, $profiles)) { $userid = $frndid; } else { $this->redirect(array('/home')); } } else { $this->redirect(array('/home')); } } //$this->redirect(array('/home')); /* Code added for retainging the finao status when images or video is uploaded */ $isuploadprocess = array(); if (isset($_REQUEST["finaoid"])) { $sourcetype = $_REQUEST["sourcetype"]; $finid = 0; $journalid = 0; if ($sourcetype == 'journal') { $finaojournal = UserFinaoJournal::model()->findByPK($_REQUEST["finaoid"]); if (isset($finaojournal) && !empty($finaojournal)) { $finid = $finaojournal->finao_id; } $journalid = $_REQUEST["finaoid"]; } else { $finid = $_REQUEST["finaoid"]; } $finao = UserFinaoTile::model()->find(array('condition' => 'finao_id = ' . $finid)); $tileid = ""; if (isset($finao) && count($finao) >= 1) { $tileid = $finao->tile_id; } $isuploadprocess = array('finao' => $finid, 'tile' => $tileid, 'journalid' => $journalid, 'upload' => $_REQUEST['upload'], 'menuselected' => isset($_REQUEST['menuselected']) ? $_REQUEST['menuselected'] : ""); } $user = User::model()->findByPk($userid); // $sql="SELECT * FROM `finao_tagnote` WHERE `user_id` = ".$user->mageid.""; $sql = "SELECT * FROM `finao_tagnote` as t1\n\n\t\tjoin catalog_product_entity_varchar as t2\n\n\t\ton t1.`product_id` = t2.`entity_id` and t2.`attribute_id`= 86\n\n\t\twhere t1.`user_id` = " . $user->mageid . " "; $connection = Yii::app()->db2; $tagnotes = $connection->createCommand($sql)->queryAll(); $pids = array(); foreach ($tagnotes as $tag) { $pids = $tag["product_id"]; } /*$sql2='SELECT * FROM catalog_product_entity_varchar where entity_id in '.implode(',',$pids).' and attribute_id=86'; $connection=Yii::app()->db2; $prodimg=$connection->createCommand($sql2)->queryAll(); */ //print_r($prodimg);exit; $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"; //ORDER BY `fn_user_finao_tile`.`tile_name` ASC $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); $newfinao = new UserFinao(); $newtile = new UserFinaoTile(); $upload = new Uploaddetails(); if (!isset($_REQUEST['frndid'])) { if (empty($finaos)) { $AddNewfinao = "addnewfinao"; } } $prev = ""; $next = ""; $noofpages = ""; if ($AddNewfinao != "addnewfinao") { $tilesdetials = $this->gettilesinfo($userid, 0, isset($_REQUEST['frndid']) ? 1 : 0); $tilesinfo = $tilesdetials["tileinfo"]; $prev = $tilesdetials["prev"]; $next = $tilesdetials["next"]; $noofpages = $tilesdetials["noofpages"]; } if (isset($_REQUEST['share'])) { $share = "share"; } else { $share = "no"; } if (isset($_REQUEST['track']) && $_REQUEST['track'] == "track") { $track = "track"; } else { $track = ""; } if (isset($_REQUEST['search']) && $_REQUEST['search'] == "search") { $search = "search"; } else { $search = ""; } /********** Getting all the tile of the user including default tiles for populating tile band *****************/ $tiles = Lookups::model()->findAll(array('condition' => 'lookup_type = "tiles" AND lookup_status = 1 ')); //$tilesslider = $this->refreshtilewidget($userid,$share); // Added on 28-06-13 to display Tiles in work space $tilesslider = $this->refreshtilewidget($userid, $share, 0, 0, 1); // Ends here on 28-06-13 /************** User Profile details **********************/ //$Userprofarray = ProfileController::getUserProfile($userid); commented on 070713-1-45-pm $Userprofarray = ProfileController::getUserProfile($userid, $share); /************** Latest Finao & archive details **********************/ $latestfinaoarray = $this->getfinaoinfo($userid, "", $share, -1, 1, 0); $archivefinao = $this->getfinaoinfo($userid, "completed", $share, -1, 1, 0); /************** tracking you details **********************/ $trackingyoudet = TrackingController::displayYourTracking($userid, $share, "trackingyou", ""); /************** Activity of the ppl following details **********************/ $activityppl = $this->getmyheroesdata($userid, $share); /***************************************/ /****************** getting counts for menu ************************/ $menucount = array('tilescount' => $tilesslider['totaltilecount'], 'imagecount' => $tilesslider['imgcount'], 'videocount' => $tilesslider['videocount'], 'finaocount' => $this->getfinaoinfo($userid, "", $share, -1, 1, 1), 'followcount' => $this->getfollowersdetails($userid, -1, 0, 1)); /* Added on 19-03-2013 to display the total count of images and videos*/ $uploadtypeimage = Lookups::model()->findByAttributes(array('lookup_name' => 'Image', 'lookup_type' => 'uploadtype', 'lookup_status' => 1)); $uploadtypevideo = Lookups::model()->findByAttributes(array('lookup_name' => 'Video', 'lookup_type' => 'uploadtype', '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));*/ /* Added on 27-03-2013 for facebook invite friends in finaos tracking page*/ $logeduser = User::model()->findByPk(Yii::app()->session['login']['id']); if (isset($_REQUEST['url']) && $_REQUEST['url'] == "logedfbreg") { $userinfo = Yii::app()->facebook->api('/me'); if (isset($_REQUEST['error_reason']) && $_REQUEST['error_reason'] == 'user_denied') { Yii::app()->user->setFlash('fbusererror', 'You are NOT LOGGED IN.You must allow basic permission access to Login from facebook'); $this->redirect(array('/')); } $logeduser->socialnetworkid = $userinfo['id']; $logeduser->socialnetwork = "facebook"; $logeduser->save(false); $track = "track"; $invitefriends = "invitefriends"; } else { $invitefriends = ""; } /* Ends here*/ if (isset($_REQUEST['tileimageupload'])) { $usertileid = $_REQUEST['tileimageupload']; $tileimage = TilesInfo::model()->findByAttributes(array('tile_id' => $usertileid, 'createdby' => $userid)); } else { $tileimage = ""; } if (isset($_REQUEST['getusertileid']) || isset($_REQUEST['tileerrormesg'])) { if (isset($_REQUEST['tileerrormesg'])) { $getusertileid = $_REQUEST['tileerrormesg']; } else { if ($_REQUEST['getusertileid']) { $getusertileid = $_REQUEST['getusertileid']; } } //$tileid = UserFinaoTile::model()->findByPk($getusertileid); $tileid = $getusertileid; } else { $tileid = ""; $getusertileid = ""; } if (isset($_REQUEST['tileerrormesg']) && isset($_REQUEST['newtile'])) { if (isset($_REQUEST['tileerrormesg'])) { $gettileid = $_REQUEST['tileerrormesg']; } $tileinfo = TilesInfo::model()->findByAttributes(array('tile_id' => $gettileid)); $tileinfo->delete(); $userfinaotile = UserFinaoTile::model()->findByAttributes(array('tile_id' => $gettileid)); $finaoid = $userfinaotile->finao_id; $userfinaotile->delete(); $finao = UserFinao::model()->findByPk($finaoid); $finao->delete(); $newtileerror = "yes"; } else { $newtileerror = ""; } //print_r($tagnotes); exit; $this->render('default', array('tiles' => $tilesinfo, 'userid' => $userid, 'IsMotMsg' => 1, 'userinfo' => isset($userinfo) && !empty($userinfo) ? $userinfo : "", 'menucount' => $menucount, 'user' => $user, 'isuploadprocess' => $isuploadprocess, 'share' => $share, 'search' => $search, 'model' => $newfinao, 'tilesnewfinao' => $tiles, 'newtile' => $newtile, 'type' => 'tilefinao', 'prev' => $prev, 'next' => $next, 'noofpages' => $noofpages, 'totaltilecount' => $totaltilecount, 'logeduser' => $logeduser, 'invitefriends' => $invitefriends, 'Imgupload' => isset($_REQUEST['imgupload']) ? $_REQUEST['imgupload'] : 0, 'Tileimageupload' => isset($_REQUEST['tileimageupload']) ? $_REQUEST['tileimageupload'] : 0, 'tileimage' => $tileimage, 'getusertileid' => $getusertileid, 'tileid' => $tileid, 'tileimageerror' => isset($_REQUEST['tileerrormesg']) ? "Tileimageerror" : "", 'errormsg' => isset($_REQUEST['errormsg']) ? $_REQUEST['errormsg'] : "", 'newtileerror' => $newtileerror, 'tileslist' => $tileslist, 'tilesslider' => $tilesslider, 'profilelatestfinao' => $Userprofarray['finao'], 'profiletileinfo' => $Userprofarray['tilesinfo'], 'latestfinaoarray' => $latestfinaoarray, 'archivefinao' => $archivefinao, 'trackingyoudet' => $trackingyoudet, 'activityppl' => $activityppl, 'userid' => $userid, 'tagnotes' => $tagnotes)); }