public function renderIndex()
{
/* ---------------------
* Home Categories
--------------------- */
$homeCategories = \App\Categories::where('is_publish', '1')->where('publish_for_main', '1')->get()->toArray();
/* Empty Array */
$mainCategoriesInHome = array();
foreach ($homeCategories as $hc) {
// Get Related Videos By Categories
$videoid = array();
$vc = \App\VideoCategories::where('categories_id', $hc['id'])->get()->toArray();
// Get Videos
foreach ($vc as $c) {
$mainCategoriesInHome[$hc['id']]['category'] = \App\Categories::where('id', $c['categories_id'])->get()->toArray()[0];
$videoid[] = $c['video_id'];
}
$videos = \App\Video::whereIn('id', $videoid)->orderBy('id', 'desc')->where('is_publish', '1')->take(8)->get()->toArray();
$mainCategoriesInHome[$hc['id']]['videos'] = $videos;
}
/* ---------------------
* Home Categories
--------------------- */
/* Last Uplaoded Videos */
$lastUploadedVideos = \App\Video::orderBy('id', 'desc')->where('is_publish', '1')->take(self::$numberOfLastVideos)->get()->toArray();
/* Last Uplaoded Videos */
// Render View With Parameters
return \View::make('video.index')->with('lastUploadedVideos', $lastUploadedVideos)->with('mainCategoriesInHome', $mainCategoriesInHome);
}
/**
* 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'));
}
public function menuList(Request $request)
{
// $classes = Video::distinct()->groupBy('class')->get();
// //$topicsList = Video::distinct()->groupBy('topic')->get();
// //$topicsList = Topic::distinct()->groupBy('course')->orderBy('priority','ASC')->get();
// $topicsList = Video::join('topics',function($join){
// $join->on('videos.topic','=','topics.topic')->On('videos.class','=','topics.course');
// })->groupBy('topics.topic')->orderBy('priority', 'ASC')->get();
// $menuList = Video::get();
// $videos = Video::where('instructor','like', $squery)->orWhere('title', 'like', $squery)->orWhere('class', 'like', $squery)->orderBy('id', 'DESC')->paginate(15);
// $data = Video::join('topics',function($join){
// $join->on('videos.class','=','topics.course') ->on('videos.unit','=','topics.unit');
// })->groupBy('topics.course')->orderBy('priority', 'ASC')->get();
$data = Video::orderBy('order', 'ASC')->get();
$classes = Video::distinct()->groupBy('class')->get();
$menuList = Topic::orderBy('priority', 'ASC')->get();
return view('videos.menu', compact('menuList', 'classes', 'data'));
//return view('videos.menu', compact('videos'))->with('search', $search);
//return view('videos.menu');
}
public function videos($id = 1)
{
$videos = Video::orderBy('id', 'desc')->paginate($perPage = 20, $columns = ['*'], $pageName = 'page', $page = $id);
return view('video.index', ['videos' => $videos]);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$videos = Video::orderBy('id', 'DESC')->paginate(15);
return view('videos.index', compact('videos'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$videos = Video::orderBy('id', 'desc')->get();
$rand = array_rand(["#f77985" => "saude", "#be1039" => "educacao", "#69b843" => "infra", "#f87e3a" => "cidadania", "#2a9fe0" => "meio", "#ad4b9e" => "esporte"]);
return view('templates/videos', compact('videos', 'rand'));
}
/**
* @return mixed
*/
public function getLastSortOrder()
{
$video = Video::orderBy('sort_order', 'DESC')->first();
return ++$video->sort_order;
}
/**
* Redirect users to the landing page and loads all videos on the landing page
*/
public function home()
{
$videos = Video::orderBy('created_at', 'desc')->paginate(12);
return view('landing', ['videos' => $videos]);
}
