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'];
}
}
}
}
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';
}
}
}
}
function uploaddata($type, $sourcetype, $finaoid, $userid, $uploadtext, $data, $captiondata)
{
$target_path = $globalpath . "images/uploads/finaoimages/";
$target_thumb = $globalpath . "images/uploads/finaoimages/thumb/";
$target_medium = $globalpath . "images/uploads/finaoimages/medium/";
$upload_path = "/images/uploads/finaoimages";
$query = "insert into fn_uploaddetails (`uploadtype`,`upload_text`,`upload_sourcetype`, `upload_sourceid`, `uploadedby`, `uploadeddate`, `status`) values ('{$type}','{$uploadtext}','{$sourcetype}','{$finaoid}','{$userid}',now(),1)";
mysql_query($query);
$uploadid = mysql_insert_id();
if (!empty($data)) {
if ($data['image1']['name'] != '') {
$sno = 0;
foreach ($data as $key => $val) {
$name = $val['name'];
$uploadfile_name = $finaoid . "-" . $name;
$tmpname = $val['tmp_name'];
$target_main = $target_path . $uploadfile_name;
$target_thumb = $target_thumb . $uploadfile_name;
$target_medium = $target_medium . $uploadfile_name;
@move_uploaded_file($tmpname, $target_main);
$resize = new ResizeImage($target_main);
$resize->resizeTo(100, 100, 'default');
$resize->saveImage($target_thumb);
$resize_m = new ResizeImage($target_main);
$resize_m->resizeTo(240, 240, 'default');
$resize_m->saveImage($target_medium);
$query = "insert into fn_images (`upload_id`,`uploadfile_name`,`uploadfile_path`, `caption`, `uploadedby`, `uploadeddate`, `status`) values ('{$uploadid}','{$uploadfile_name}','{$upload_path}','{$captiondata[$sno]}','{$userid}',now(),1)";
mysql_query($query);
$sno++;
}
} else {
$target_path = $target_path . $finaoid . "-" . basename($data['video']['name']);
@move_uploaded_file($data['video']['tmp_name'], $target_path);
set_time_limit(0);
include 'phpviddler.php';
$v = new Viddler_V2('145i86zgnzi1h1xln0ly');
$auth = $v->viddler_users_auth(array('user' => ' finaonation', 'password' => 'Finao123'));
$session_id = isset($auth['auth']['sessionid']) ? $auth['auth']['sessionid'] : NULL;
$response = $v->viddler_videos_prepareUpload(array('sessionid' => $session_id));
$endpoint = isset($response['upload']['endpoint']) ? $response['upload']['endpoint'] : NULL;
$token = isset($response['upload']['token']) ? $response['upload']['token'] : NULL;
$query = array('uploadtoken' => $token, 'title' => 'Video from iphone App', 'description' => 'Video from iphone App', 'tags' => 'testing,upload', 'file' => '@../../preprod/images/uploads/finaoimages/' . $finaoid . "-" . basename($data['video']['name']));
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $endpoint);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_HEADER, TRUE);
curl_setopt($ch, CURLOPT_NOBODY, FALSE);
curl_setopt($ch, CURLOPT_TIMEOUT, 0);
curl_setopt($ch, CURLOPT_POST, TRUE);
curl_setopt($ch, CURLOPT_POSTFIELDS, $query);
$response = curl_exec($ch);
$info = curl_getinfo($ch);
$header_size = $info['header_size'];
$header = substr($response, 0, $header_size);
$video = unserialize(substr($response, $header_size));
curl_close($ch);
@unlink('../../preprod/images/uploads/finaoimages/' . $finaoid . "-" . basename($data['video']['name']));
$videoid = $video['video']['id'];
$results = $v->viddler_videos_getDetails(array('sessionid' => $session_id, 'video_id' => $videoid));
$videostatus = $results['video']['status'];
$video_img = $results['video']['thumbnail_url'];
$query = "insert into fn_videos (`upload_id`,`videoid`,`videostatus`, `video_img`, `caption`, `uploadedby`, `uploadeddate`, `status`) values ('{$uploadid}','{$videoid}','{$videostatus}','{$video_img}','{$captiondata['0']}','{$userid}',now(),1)";
mysql_query($query);
}
}
// updating the current date time in fn_user_finao
$sqlUpdate = "update fn_user_finao set updateddate=NOW(),updatedby=" . $userid . " where user_finao_id=" . $finaoid;
mysql_query($sqlUpdate);
// end of fn_user_finao update
}
