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