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']; } } } }