/**
* Lists all models.
*/
public function actionDashboard()
{
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);
if (in_array($frndid, $profiles)) {
$userid = $frndid;
} else {
$this->redirect(array('/home'));
}
} else {
$this->redirect(array('/home'));
}
}
if (isset($_REQUEST['share'])) {
$share = "share";
} else {
$share = "no";
}
if ($_REQUEST['groupid']) {
$isgroup = $_REQUEST['groupid'];
} else {
$isgroup = '';
$this->redirect(array('/home'));
}
if (isset($_REQUEST['getusertileid']) || isset($_REQUEST['tileerrormesg'])) {
if (isset($_REQUEST['tileerrormesg'])) {
$getusertileid = $_REQUEST['tileerrormesg'];
} else {
if ($_REQUEST['getusertileid']) {
$getusertileid = $_REQUEST['getusertileid'];
}
}
$tileid = $getusertileid;
} else {
$tileid = "";
$getusertileid = "";
}
if ($_REQUEST['upload']) {
$upload = 1;
}
if ($_REQUEST['errormsg']) {
$errormsg = $_REQUEST['errormsg'];
}
$groupinfo = Group::model()->findByPK($isgroup);
$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, 'share' => $share, 'journalid' => $journalid, 'upload' => $_REQUEST['upload'], 'menuselected' => isset($_REQUEST['menuselected']) ? $_REQUEST['menuselected'] : "");
}
//$tilesslider = $this->refreshtilewidget($userid,$share,0,0,1);
$Criteria = new CDbCriteria();
$Criteria->condition = "`group_id` = " . $isgroup . " and `finao_activestatus` = 1 and `updatedby` = " . $userid . " and Iscompleted = 0";
if ($userid != Yii::app()->session['login']['id'] || $share == "share") {
$Criteria->addCondition("finao_status_Ispublic = 1", 'AND');
}
$Criteria->order = "updateddate DESC";
$groupfinaos = UserFinao::model()->findAll($Criteria);
foreach ($groupfinaos as $finodet) {
$finaoids .= $finodet->user_finao_id . ",";
}
if ($finaoids != "") {
$finaoids = substr($finaoids, 0, strlen($finaoids) - 1);
$finaouploaddetails = $this->getlatestuploaddetails($finaoids, 61);
}
$tilesslider = $this->refreshtilewidget($userid, $isgroup, $share, 0, 0, 1);
$members = $this->getmembersdetails($userid, $isgroup, 0, 0);
$memcount = count($members, 0);
$trackingyoudet = TrackingController::displayYourGroupTracking($userid, $share, "trackingyou", "", $isgroup);
$result = GroupTracking::model()->findByAttributes(array('tracker_userid' => Yii::app()->session['login']['id'], 'tracked_groupid' => $isgroup, 'tracked_userid' => $userid));
if (count($result) == '0') {
$results = 'Join Group';
$isgroupmem = 0;
//Not a member
} else {
$results = 'Leave Group';
$isgroupmem = 1;
// Member
}
//archived finaos
$archivefinao = $this->getfinaoinfo($userid, $isgroup, "completed", $share, -1, 1, 0);
// tile info
$userprofarray = $this->getUserProfile($userid, $share, $isgroup);
$activityppl = $this->getmyheroesdata1($userid, $share);
//print_r($groupfinaos);exit;
//echo $groupfinaos['user_finao_id'];
$result_tile_id = UserFinaoTile::model()->findByAttributes(array('finao_id' => $groupfinaos[0]['user_finao_id']));
/*$announcements = Announcement::model()->findByAttributes(array('uploadsourcetype'=>61,
'uploadsourceid'=>$isgroup
)); */
$Criteria = new CDbCriteria();
$Criteria->condition = "uploadsourcetype = 61 and createdby = " . $userid . " and uploadsourceid = " . $isgroup . " ";
$Criteria->order = "createddate DESC";
$announcements = Announcement::model()->findAll($Criteria);
$othergroups = FinaoController::getGroupinfo($userid, $share);
$this->render('index', array('userid' => $userid, 'imgcount' => $this->GetTotalCount(0, $isgroup, $userid, 'Image', 0, $share), 'videocount' => $this->GetTotalCount(0, $isgroup, $userid, 'Video', 0, $share), 'finaocount' => $this->getfinaoinfo($userid, $isgroup, "", 'yes', -1, 1, 1), 'titlecount' => $tilesslider['totaltilecount'], 'followcount' => $this->getfollowersdetails($userid, -1, 0, 1), 'isgroup' => $isgroup, 'groupinfo' => $groupinfo, 'groupfinaos' => $groupfinaos, 'share' => $share, 'upload' => $upload, 'memcount' => $memcount, 'results' => $results, 'share' => $share, 'isuploadprocess' => $isuploadprocess, 'finaouploaddetails' => $finaouploaddetails, 'getusertileid' => $getusertileid, 'tileid' => $tileid, 'trackingyoudet' => $trackingyoudet, 'isgroupmem' => $isgroupmem, 'tilesinfo' => $userprofarray['tilesinfo'], 'archivefinao' => $archivefinao, 'activityppl' => $activityppl, 'errormsg' => $errormsg, 'result_tile_id' => $result_tile_id->tile_id, 'announcements' => $announcements, 'share_value' => $_REQUEST['share_value'], 'othergroups' => $othergroups['groupinfo']));
}
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));
}
