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); }
/** * Displays the login page */ public function actionLogin() { $uname = $_POST['uname']; $pwd = md5($_POST['pwd']); $remember = $_POST['remember']; $currenturl = Yii::app()->request->urlReferrer; $model = User::model()->findByAttributes(array('email' => $uname, 'password' => $pwd, 'status' => 1)); if ($model) { $login = array(); if (isset(Yii::app()->session['login'])) { unset(Yii::app()->session['login']); } if (isset(Yii::app()->session['userinfo'])) { unset(Yii::app()->session['userinfo']); } $login["id"] = $model->userid; $login["username"] = $model->fname; $login["email"] = $model->email; $login["socialnetworkid"] = $model->socialnetworkid; $login["trackid"] = $model->trackid; $login["superuser"] = $model->superuser; /* code added by gowri for bg image */ $userprofile = UserProfile::model()->findByAttributes(array('user_id' => $model->userid)); $login["profImage"] = isset($userprofile->profile_image) ? $userprofile->profile_image : ""; $login["bgImage"] = isset($userprofile->profile_bg_image) ? $userprofile->profile_bg_image : ""; Yii::app()->session['login'] = $login; //$passwordcookie = base64_encode($_POST['pwd']); $passwordcookie = base64_encode($_POST['pwd']); //Changed on 26022013 $imgsrc = "http://" . $_SERVER['SERVER_NAME'] . "/images/uploads/profileimages/" . Yii::app()->session['login']['profImage']; $shopusercookie = new CHttpCookie('shop_uname', $imgsrc); $shopusercookie->expire = time() + 2 * 604800; //Ended on 260222013 if ($remember == "true") { $usercookie = new CHttpCookie('login_usernme', $uname); $usercookie->expire = time() + 2 * 604800; $passcookie = new CHttpCookie('login_paswrd', $_POST['pwd']); $passcookie->expire = time() + 2 * 604800; Yii::app()->request->cookies['login_usernme'] = $usercookie; Yii::app()->request->cookies['login_paswrd'] = $passcookie; } //Added on 26022013 Yii::app()->request->cookies['shop_uname'] = $shopusercookie; //Ended on 26022013 /*if($remember == "false") { unset(Yii::app()->request->cookies['login_usernme']); unset(Yii::app()->request->cookies['login_paswrd']); }*/ $IsSkipped = UserProfile::model()->findByAttributes(array('user_id' => $model->userid)); $IsFinao = UserFinao::model()->findByAttributes(array('userid' => $model->userid)); if (!empty($IsSkipped) && $IsSkipped->IsCompleted == "skipped") { if (!isset($IsFinao) || empty($IsFinao)) { echo "AddFinao"; } else { echo "MotivationMesg"; } } elseif ($IsSkipped->IsCompleted == "saved") { if (!isset($IsFinao) || empty($IsFinao)) { echo "AddFinao"; } else { echo "MotivationMesg"; } } else { echo "MyProfile"; } } else { $notactivate = User::model()->findByAttributes(array('email' => $uname, 'password' => $pwd)); if ($notactivate) { echo "Your account is not activated"; } else { echo "not-login"; } //exit; } }
</a></span> <?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">
$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; ?>
<?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"] != "") { $path = "/thumbs/"; ?>
?> </div> </div> <div class="contentHolder ps-container" id="Default"> <div class="finao-display-container"> <?php $Criteria = new CDbCriteria(); if ($userid == Yii::app()->session['login']['id'] && isset($share) && $share != "share") { $Criteria->condition = "userid = '" . $userid . "' and Iscompleted!=1 and finao_activestatus=1 and IsGroup = 0"; } else { $Criteria->condition = "userid = '" . $userid . "' and Iscompleted!=1 and finao_activestatus = 1 and finao_status_Ispublic=1 and IsGroup = 0"; } $Criteria->order = "updateddate desc"; $totfinaos = UserFinao::model()->findAll($Criteria); $i = 0; foreach ($totfinaos as $finaoalll) { $i++; $finaotile = UserFinaoTile::model()->findByAttributes(array('finao_id' => $finaoalll->user_finao_id)); //echo $finaotile->tile_id; //echo $userid; ?> <script language="javascript"> $(document).ready(function() { $("#fancyboximg"+<?php echo $i; ?> ).fancybox({}); $("#fancyboximgs"+<?php echo $finaoalll->user_finao_id;
public function actionUpdatedetails() { //print_r($_POST);exit; $uploaddetail_id = $_POST['uploaddetail_id']; $userid = $_POST['userid']; // only caption edit $dates = date('Y-m-d H:i:s'); $connection = yii::app()->db; if ($_POST['type'] == 'video') { $sql = "UPDATE fn_uploaddetails SET video_caption='" . $_POST['caption'] . "',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; } else { $sql = "UPDATE fn_uploaddetails SET caption='" . $_POST['caption'] . "',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; } $command = $connection->createCommand($sql); $command->execute(); if (!empty($_FILES['journalimage']['name'])) { $filename = ''; $result = 'ERROR'; $result_msg = ''; $allowed_image = array('image/gif', 'image/jpeg', 'image/jpg', 'image/png'); define('PICTURE_SIZE_ALLOWED', 10485760); // bytes 2242880 if (isset($_FILES['journalimage'])) { if ($_FILES['journalimage']['error'] == UPLOAD_ERR_OK) { if (in_array($_FILES['journalimage']['type'], $allowed_image)) { if (filesize($_FILES['journalimage']['tmp_name']) <= PICTURE_SIZE_ALLOWED) { $filename = $_POST['finaoid'] . '-' . rand(125678, 00) . '-' . $_FILES['journalimage']['name']; $source = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages' . '/' . $filename; move_uploaded_file($_FILES['journalimage']['tmp_name'], $source); if (file_exists($source)) { $upload = new Uploaddetails(); $destination = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages/thumbs/' . $filename; $destination1 = Yii::getPathOfAlias('webroot') . '/images/uploads/finaoimages/medium/' . $filename; $this->generatethumb($source, $destination, 90, 90); $this->generatethumb($source, $destination1, 240, 240); $dates = date('Y-m-d H:i:s'); $connection = yii::app()->db; $sql = "UPDATE fn_uploaddetails SET uploadfile_name='" . $filename . "',uploadfile_path='/images/uploads/finaoimages',updateddate='" . $dates . "' WHERE uploaddetail_id=" . $uploaddetail_id; $command = $connection->createCommand($sql); $command->execute(); } //phpclamav clamscan for scanning viruses //passthru('clamscan -d /var/lib/clamav --no-summary '.$filename, $virus_msg); //scan virus $virus_msg = 'OK'; //assume clamav returing OK. if ($virus_msg != 'OK') { unlink($source); $result_msg = $filename . " : " . FILE_VIRUS_AFFECTED; $result_msg = '<font color=red>' . $result_msg . '</font>'; $filename = ''; } else { // main action -- move uploaded file to $upload_dir $result = 'OK'; } } else { $filesize = filesize($_FILES['file']['tmp_name']); // or $_FILES['file']['size'] $filetype = $_FILES['file']['type']; $result_msg = PICTURE_SIZE; } } else { $result_msg = SELECT_IMAGE; } } elseif ($_FILES['file']['error'] == UPLOAD_ERR_INI_SIZE) { $result_msg = 'The uploaded file exceeds the upload_max_filesize directive in php.ini'; } else { $result_msg = 'Unknown error'; } } } $finao = Uploaddetails::model()->findByPK($uploaddetail_id); $finaoid = $finao->upload_sourceid; $finaos = new UserFinao(); $finaos = UserFinao::model()->findByPk($finaoid); if (!empty($finaos)) { $finaos->updateddate = new CDbExpression('NOW()'); if ($finaos->save(false)) { //echo 'saved date';exit; $this->redirect(Yii::app()->createUrl('finao/motivationMesg', array('menutype' => 'finao', 'finaoid' => $finaoid))); } /*$tileiddata = UserFinaoTile::model()->findByAttributes(array('finao_id'=>$finaoid,'userid'=>$userid,'status'=>1)); $this->addTrackingNotifications($userid,$tileiddata['tile_id'],'Added Image To Journal',$finaoid,0);*/ } //$tempdocmodel=Uploaddetails::model()->updateByPk($Model->$_POST['journalid'],array("status"=>'ok')); // $filesmodel=UserFinaoJournal::model()->updateAll(array('user'=>"$userid",'date'=>$currenttime),"status=>'ok'"); }
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)); }