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