/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($type, $id)
{
if ($id == 'video') {
$events = Video::all();
return view('video.show', compact('events'));
} elseif ($id == 'staff') {
$events = Staff::all();
return view('staff.show', compact('events'));
} elseif ($id == 'gallery') {
$events = Image::all();
return view('gallery.show', compact('events'));
} else {
$event = Event::where('slug', $id)->where('type', $type)->first();
$location = Location::where('event_id', $event->id)->first();
$slider = EventImage::where('event_id', $event->id)->orderBy(\DB::raw('RAND()'))->take(4)->get();
$gallery = EventImage::where('event_id', $event->id)->first();
if ($event->type == $type) {
if ($event->status == 1) {
return view($type . '.show', compact('event', 'location', 'slider', 'gallery'));
} else {
return redirect('/' . $type . '/');
}
}
}
}
public function topEnrichment(Request $request)
{
try {
$users = MecanexUser::all();
$videos = Video::all();
$euscreen_id = $request->video;
$video_id = $videos->where('video_id', $euscreen_id)->first()->id;
$username = $request->user;
$user_id = $users->where('username', $username)->first()->id;
if ($request->num != 0) {
$num = $request->num;
} else {
$num = 3;
}
$topEnrichments = [];
$listEnrichments = DB::select(DB::raw('SELECT * FROM enrichments_videos_time WHERE video_id=?'), [$video_id]);
$listEnrichments = json_decode(json_encode($listEnrichments), true);
$topEnrichments = $this->recommend_enr($listEnrichments, $user_id);
$topEnrichments = array_slice($topEnrichments, 0, $num, true);
foreach ($topEnrichments as $key => $score) {
$response[] = array('enrichment_id' => Enrichment::find($key)->enrichment_id, 'score' => $score);
}
$statusCode = 200;
return $response;
} catch (Exception $e) {
$statusCode = 400;
} finally {
return Response::json($response, $statusCode);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function scores()
{
//indexing of video terms
set_time_limit(0);
DB::table('videos_terms_scores')->delete();
//$counts=DB::select('select count(video_id) from videos'); //take number of videos
//dd($counts);
$terms = Term::all();
//take all Profile terms
$videos = Video::all();
foreach ($videos as $video) {
$id = $video->id;
foreach ($terms as $term) {
$results = DB::select(DB::raw('select MATCH (genre, topic, geographical_coverage, thesaurus_terms, title) AGAINST (? WITH QUERY EXPANSION) as rev from videos where id = (?)'), [$term->term, $id]);
echo 'video_id=' . $id . ' term = ' . $term->term . ' score = ' . $results[0]->rev . '<br>';
DB::table('videos_terms_scores')->insert(['video_id' => $id, 'term_id' => $term->id, 'video_score' => $results[0]->rev]);
echo 'record inserted!' . '<br>';
}
}
///////////////////normalization///////////////////////////////////////////////////
//this takes for ever....raw db instead
// foreach ($videos as $video) {
// $id = $video->id;
// $max_score = DB::table('videos_terms_scores')->where('video_id',$id)->max('video_score');
// foreach ($terms as $term) {
// $temp_video = $video->term->find($term);
// $video_term_score = $temp_video->pivot->video_score; //get score of video
// $new_score=$video_term_score/$max_score;
// $video->term()->sync([$term->id=> ['video_score' => $new_score]], false);
//
// }
// }
$query = DB::select(DB::raw('UPDATE videos_terms_scores as t join (select video_id,MAX(video_score) as maximum FROM videos_terms_scores GROUP BY video_id)as max_scores on t.video_id=max_scores.video_id SET t.video_score=t.video_score/max_scores.maximum'));
//return view ('video.parser');
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$videos = Video::all();
if ($videos === null) {
$videos = null;
}
//return $videos;
return \View::make('admin.video.manage_videos')->withVideos($videos);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
$videos = Video::orderBy('views', 'desc')->limit(5)->get();
$totalViews = Video::all()->sum('views');
$comments = Video::orderBy('numComments', 'desc')->limit(5)->get();
$totalComments = Video::all()->sum('numComments');
$tracker = Tracker::all()->where('date', Carbon::today()->format('m/d/Y'));
$totalTrackers = Tracker::all()->where('date', Carbon::today()->format('m/d/Y'))->count();
return view('admin.stats', compact('videos', 'totalViews', 'comments', 'totalComments', 'tracker', 'totalTrackers'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index($type)
{
if ($type == 'staff') {
$events = Staff::all();
return view('admin.' . $type . '.index')->with('events', $events);
} elseif ($type == 'video') {
$events = Video::all();
return view('admin.' . $type . '.index')->with('events', $events);
} elseif ($type == 'event' || $type == 'page') {
$events = Event::where('type', $type)->orderBy('updated_at', 'desc')->get();
return view('admin.' . $type . '.index')->with('events', $events);
} else {
return view('errors.404');
}
}
/**
* @return Video|best
*/
public function best()
{
$videos = Video::all();
$best_vidos = [];
$id_best_videos = [];
foreach ($videos as $video) {
$id_best_videos[] = [$video->likes()->count(), $video->id];
}
arsort($id_best_videos);
$id_best_videos = array_slice($id_best_videos, 0, 10);
foreach ($id_best_videos as $value) {
$best_vidos[] = Video::find($value[1]);
}
return $best_vidos;
}
public function remove_duplicates_on_score()
{
$terms = Term::all();
//take all Profile terms
$videos = Video::all();
foreach ($videos as $video) {
$id = $video->id;
foreach ($terms as $term) {
$results = DB::select(DB::raw('select * from videos_terms_scores where video_id=? and term_id=?'), [$id, $term->id]);
if (count($results) > 1) {
DB::table('videos_terms_scores')->where('video_id', $id)->where('term_id', $term->id)->delete();
DB::table('videos_terms_scores')->insert(['video_id' => $results[0]->video_id, 'term_id' => $results[0]->term_id, 'video_score' => $results[0]->video_score]);
}
}
}
return "removed duplicates";
}
public function index()
{
$videos = Video::all();
$interests = Auth::user()->interests()->lists('name', 'id');
return view('videos.index', compact('interests', 'videos'));
}
/**
* Show all videos.
*
* @return mixed
*/
public function videos()
{
return view('Admin.Videos.Show')->withVideos($this->video->all());
}
public function getAllVideos()
{
return Video::all();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = Category::all();
$videos = Video::all();
return view('welcome', compact('categories', 'videos'));
}
public function importVideoEnrichments()
{
set_time_limit(0);
DB::table('enrichments_videos_time')->delete();
$uri = "http://mecanex.noterik.com/tools/video_enrichments.php";
$content = utf8_encode(file_get_contents($uri));
$json = json_decode($content);
$videos = Video::all();
$all_enrichments = Enrichment::all();
foreach ($json as $item) {
$euscreen_id = $item->id;
$video_id = $videos->where('video_id', $euscreen_id)->first()->id;
foreach ($item->enrichment as $key => $enrichment) {
$new_key = str_replace("\r", '', $key);
$enrichment_id = $all_enrichments->where('enrichment_id', $new_key)->first()->id;
foreach ($enrichment->localization as $localization) {
foreach ($localization as $time => $inside) {
$time = intval(substr($time, 1));
$height = $inside->height;
$width = $inside->width;
$x_min = $inside->x_min;
$y_min = $inside->y_min;
DB::table('enrichments_videos_time')->insert(["enrichment_id" => $enrichment_id, "video_id" => $video_id, "time" => $time, "height" => $height, "width" => $width, "x_min" => $x_min, "y_min" => $y_min]);
}
}
}
}
$response = ['message' => 'Successful match of enrichments to videos'];
$statusCode = 200;
return Response::json($response, $statusCode);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$videos = Video::all();
}
private function content_similarity($user_id, $limit)
{
$result = [];
$videos = Video::all();
$terms = Term::all();
$user = MecanexUser::where('id', $user_id)->get()->first();
$user_terms_scores = $user->profilescore;
foreach ($user_terms_scores as $user_term_score) {
$temp_profile_scores[] = $user_term_score->pivot->profile_score;
}
foreach ($videos as $video) {
$arithmitis = 0;
$sumA = 0;
$sumB = 0;
$temp_video_scores = [];
$video_terms_scores = DB::select(DB::raw('SELECT * FROM videos_terms_scores WHERE video_id=? ORDER BY term_id'), [$video->id]);
foreach ($video_terms_scores as $video_term_score) {
$temp_video_scores[] = $video_term_score->video_score;
}
for ($i = 0; $i < count($terms); $i++) {
$arithmitis = $arithmitis + $temp_video_scores[$i] * $temp_profile_scores[$i];
$sumA = $sumA + pow($temp_video_scores[$i], 2);
$sumB = $sumB + pow($temp_profile_scores[$i], 2);
}
$videoScores[$video->id] = $arithmitis / (sqrt($sumA) + sqrt($sumB));
}
arsort($videoScores);
$videoScores = array_slice($videoScores, 0, $limit, true);
foreach ($videoScores as $key => $score) {
$video = $videos->find($key);
$result[] = array('video_id' => $video->id, 'title' => $video->title, 'similarity' => $score, 'euscreen_id' => $video->video_id);
}
return $result;
}
public function initial()
{
$allvideo = Video::all();
return view('video')->with('allvideos', $allvideo);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return Video::all();
}
/**
* Home page.
*
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function home()
{
return view('Main.Home.Home')->withVideos($this->video->all());
}
/**
* Show the application welcome screen to the user.
*
* @return Response
*/
public function index()
{
$videos = Video::all();
return view('Home.index', compact('videos'));
}
private function content_similarity($user_id, $video_ids)
{
$temp_profile_scores = [];
// if there is no video list, search all videos, else only those on the list
if (count($video_ids) == 0) {
$videos = Video::all();
} else {
// $videos = Video::whereRaw('video_id IN (' . $video_ids . ')')->get();
$tmpArray = explode(',', $video_ids);
$func = function ($string) {
return substr($string, 1, -1);
};
$myArray = array_map($func, $tmpArray);
$videos = DB::table('videos')->whereIn('video_id', $myArray)->get();
}
//keep all terms of the user in a list
$terms = Term::all();
$user = MecanexUser::where('id', $user_id)->get()->first();
$user_terms_scores = $user->profilescore;
foreach ($user_terms_scores as $user_term_score) {
$temp_profile_scores[] = $user_term_score->pivot->profile_score;
}
foreach ($videos as $video) {
$arithmitis = 0;
$sumA = 0;
$sumB = 0;
$temp_video_scores = [];
//keep all terms of video in a list
$video_terms_scores = DB::select(DB::raw('SELECT * FROM videos_terms_scores WHERE video_id=? ORDER BY term_id'), [$video->id]);
foreach ($video_terms_scores as $video_term_score) {
$temp_video_scores[] = $video_term_score->video_score;
}
// calculate the similarity
for ($i = 0; $i < count($terms); $i++) {
$arithmitis = $arithmitis + $temp_video_scores[$i] * $temp_profile_scores[$i];
$sumA = $sumA + pow($temp_video_scores[$i], 2);
$sumB = $sumB + pow($temp_profile_scores[$i], 2);
}
$videoScores[$video->id] = $arithmitis / (sqrt($sumA) + sqrt($sumB));
}
return $videoScores;
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create()
{
$videos = Video::all();
return view('admin.pages.create')->with(compact('videos'));
}
public function getVideos($id)
{
$videos = $id ? User::findOrFail($id)->videos : Video::all();
return $videos;
}
