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 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";
}
}
if ($userid == Yii::app()->session['login']['id'] && $share != "share") {
?>
<div style="width:100%; float:left;">
<div class="font-14px padding-10pixels orange left">Upload Video</div>
<div class="right"><a href="javascript:void(0)" onclick="addadminvideo();" class="orange-link font-12px">+ Add Video</a></div>
</div>
<?php
}
?>
<div id="videoform" style="margin-top:10px;"> </div>
<div id="videoview" style="margin-top:10px;">
<?php
$video = Uploaddetails::model()->findByAttributes(array('upload_sourcetype' => 64, 'upload_sourceid' => $isgroup));
?>
<div class="padding-10pixels">
<?php
if ($video->video_embedurl != '') {
echo $video->video_embedurl;
} else {
if ($video->videoid != '') {
?>
<iframe id="viddler-<?php
echo $video->videoid;
?>
" src="//www.viddler.com/embed/<?php
echo $video->videoid;
?>
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));
}
}
if ($userid == Yii::app()->session['login']['id'] && isset($share) && $share != "share") {
echo 'My FINAO Activity';
} else {
echo ucfirst($userfinding1->fname) . "'s FINAO Activity";
}
?>
</div>
<?php
$i = 0;
$Criteria = new CDbCriteria();
$Criteria->condition = "uploadedby = '" . $userid . "' and upload_sourceid='" . $finaoid . "'";
$Criteria->order = "updateddate desc";
$totfinaos = Uploaddetails::model()->findAll($Criteria);
if (count($totfinaos) == '0') {
echo "<div class='orange font-13px'> No Activity Found In This Finao</div>";
} else {
?>
<div class="contentHolder ps-container" id="Default">
<div class="finao-display-container">
<?php
}
?>
</div>
</div>
<?php
$Criteria = new CDbCriteria();
$Criteria->condition = "uploadtype = '" . $userid . "' AND upload_sourceid = " . $finaoalll->user_finao_id . "";
$journals = Uploaddetails::model()->findAll($Criteria);
// posts count
$sql = "SELECT COUNT(*) FROM fn_uploaddetails where uploadedby='" . $userid . "' and upload_sourceid='" . $finaoalll->user_finao_id . "'";
$numClients = Yii::app()->db->createCommand($sql)->queryScalar();
// images count
$sql_img = "SELECT COUNT(*) FROM fn_uploaddetails where uploadedby='" . $userid . "' and uploadtype IN('34','62') and upload_sourceid='" . $finaoalll->user_finao_id . "' and uploadfile_name!=''";
$num_images = Yii::app()->db->createCommand($sql_img)->queryScalar();
// videos count
$sql_vid = "SELECT COUNT(*) FROM fn_uploaddetails where uploadedby='" . $userid . "' and uploadtype IN('35','62') and upload_sourceid='" . $finaoalll->user_finao_id . "' and video_img!=''";
$num_vide = Yii::app()->db->createCommand($sql_vid)->queryScalar();
?>
<div class="finao-status-bar">
<div class="left">
public function actionCheckVideoStatus()
{
//print_r($_POST);
/*SELECT * FROM `fn_uploaddetails` WHERE `upload_sourceid` = 1748 and `uploadedby` = 20 and `videoid` !='' and status = 1 and videostatus != 'ready'*/
$ids = array();
$Criteria = new CDbCriteria();
$Criteria->condition = "`upload_sourceid` = " . $_POST['finaoid'] . " and `uploadedby` = " . $_POST['userid'] . " and `videoid` !='' and status = 1 and videostatus != 'ready'";
$uploadids = Uploaddetails::model()->findAll($Criteria);
foreach ($uploadids as $finaoids) {
$ids[] = $finaoids->uploaddetail_id . '-' . $finaoids->upload_sourceid;
}
foreach ($ids as $updet) {
//echo $updet;
$datastring = $updet;
$item = explode(" ", $datastring);
$item[0];
// uploadid
$item[1];
// uploadsourceid or finaoid
$updetupload = new Uploaddetails();
$updetupload = Uploaddetails::model()->findByAttributes(array('uploaddetail_id' => $item[0]));
if (!empty($updetupload)) {
if ($updetupload->videostatus != 'ready') {
//echo $updetupload->videostatus;
$vidler = Yii::app()->getComponents(false);
$user = $vidler['vidler']['user'];
$pass = $vidler['vidler']['pwd'];
$api_key = $vidler['vidler']['appkey'];
$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' => $updetupload->videoid));
$i = 0;
if ($results['video']['status'] == 'ready') {
//echo 'video'.$results['video']['status'];
$i++;
$updetupload->videostatus = $results['video']['status'];
if ($updetupload->save(false)) {
echo 1;
//succes
} else {
echo 0;
//fail
}
}
//echo $i.'updated';
}
}
}
}
public function actionGetadminVideodetail()
{
//print_r($_REQUEST);exit;
// echo 'HEllo ';
$userid = Yii::app()->session['login']['id'];
$groupid = $_REQUEST['groupid'];
$videoid = "";
$results = "";
$videoembcode = "";
$srctype = "";
$video = Uploaddetails::model()->findByAttributes(array('upload_sourcetype' => 64, 'upload_sourceid' => $groupid));
if ($video) {
// echo 'updating';exit;
//print_r($_POST);exit;
$video->video_embedurl = '';
$video->upload_sourcetype = 64;
//Admin Video
if (isset($_REQUEST["videoid"])) {
$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));
//print_r($results);
$description = $results['video']['description'];
if (trim($description) == '') {
$video->uploadtype = 35;
} else {
$video->uploadtype = 62;
$video->upload_text = $results['video']['description'];
}
} else {
$videoid = '';
$videoembcodeURL = $_REQUEST['emburl'];
$videodesc = $_REQUEST['embdescr'];
$srctype = $_REQUEST['sourcetype'];
$yt_vid = $this->extractUTubeVidId($videoembcodeURL);
$videoembcode = $this->generateYoutubeEmbedCode($yt_vid, 230, 230);
$videoembImgUrl = "http://img.youtube.com/vi/" . $yt_vid . "/mqdefault.jpg";
if (!empty($_REQUEST['journaltxt'])) {
$video->uploadtype = 62;
$video->upload_text = $_REQUEST['journaltxt'];
} else {
$video->uploadtype = 35;
}
}
$video->videoid = $videoid;
$video->videostatus = "ready";
$video->video_img = isset($results['video']['thumbnail_url']) ? $results['video']['thumbnail_url'] : $videoembImgUrl;
$video->video_caption = isset($results['video']['title']) ? $results['video']['title'] : $videodesc;
$video->video_embedurl = $videoembcode;
if ($video->save(false)) {
if (isset($_REQUEST["videoid"])) {
if (isset($_REQUEST["groupid"]) && !empty($_REQUEST["groupid"])) {
$this->redirect(Yii::app()->createUrl('group/dashboard', array('groupid' => $_REQUEST['groupid'])));
}
} else {
echo $_REQUEST['groupid'];
}
}
} else {
//echo 'New';exit;
$model = new Uploaddetails();
//Type should be here...
$model->upload_sourcetype = 64;
//Admin Video
if (isset($_REQUEST["videoid"])) {
$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));
print_r($results);
$description = $results['video']['description'];
if (trim($description) == '') {
$model->uploadtype = 35;
} else {
$model->uploadtype = 62;
$model->upload_text = $results['video']['description'];
}
} else {
$videoembcodeURL = $_REQUEST['emburl'];
$videodesc = $_REQUEST['embdescr'];
$srctype = $_REQUEST['sourcetype'];
$yt_vid = $this->extractUTubeVidId($videoembcodeURL);
$videoembcode = $this->generateYoutubeEmbedCode($yt_vid, 230, 230);
$videoembImgUrl = "http://img.youtube.com/vi/" . $yt_vid . "/mqdefault.jpg";
if (!empty($_REQUEST['journaltxt'])) {
$model->uploadtype = 62;
$model->upload_text = $_REQUEST['journaltxt'];
} else {
$model->uploadtype = 35;
}
}
//Group id should be here...
$model->upload_sourceid = $groupid;
$model->uploadedby = $userid;
$model->uploadeddate = new CDbExpression('NOW()');
$model->status = 1;
$userid = Yii::app()->session['login']['id'];
$model->updatedby = $userid;
$model->updateddate = new CDbExpression('NOW()');
$model->videoid = $videoid;
$model->videostatus = "ready";
$model->video_img = isset($results['video']['thumbnail_url']) ? $results['video']['thumbnail_url'] : $videoembImgUrl;
$model->video_caption = isset($results['video']['title']) ? $results['video']['title'] : $videodesc;
$model->video_embedurl = $videoembcode;
if ($model->save(false)) {
if (isset($_REQUEST["videoid"])) {
if (isset($_REQUEST["groupid"]) && !empty($_REQUEST["groupid"])) {
$this->redirect(Yii::app()->createUrl('group/dashboard', array('groupid' => $_REQUEST['groupid'])));
}
} else {
echo $_REQUEST['groupid'];
}
}
}
}
