/** * Show the home page * * @return mixed */ public function showHome() { $page_title = "Not active"; $page_content = "Either the page you requested is not active, or it does not exist."; $meta = ""; $meta_keywords = ""; $active = 1; $page_id = 0; if (Cache::has('homepage')) { $results = Cache::get('homepage'); } else { $results = DB::table('pages')->where('slug', '=', "home")->get(); Cache::forever('homepage', $results); } foreach ($results as $result) { $active = $result->active; if ($active > 0 || Auth::check() && Auth::user()->access_level == 3) { if (Session::get('lang') == null || Session::get('lang') == "en") { $page_title = $result->page_title; $page_content = $result->page_content; $meta = $result->meta; $page_id = $result->id; $meta_keywords = $result->meta_tags; $fragment = Page::find($result->id)->fragments->first(); $fragment_title = $fragment->fragment_title; $fragment_text = $fragment->fragment_text; } else { $page_title = $result->page_title_fr; $page_content = $result->page_content_fr; $meta = $result->meta; $page_id = $result->id; $meta_keywords = $result->meta_tags; $fragment = Page::find($result->id)->fragments->first(); $fragment_title = $fragment->fragment_title_fr; $fragment_text = $fragment->fragment_text_fr; } } } // get news $news = News::where('active', '=', 1)->orderBy('news_date', 'desc')->limit(3)->get(); return View::make('public.home')->with('page_title', $page_title)->with('page_content', $page_content)->with('meta', $meta)->with('meta_tags', $meta_keywords)->with('active', $active)->with('page_id', $page_id)->with('fragment_title', $fragment_title)->with('fragment_text', $fragment_text)->with('menu', $this->menu)->with('menu_choice', 'home')->with('news', $news); }
public function index() { $news = News::where('active', '=', '1')->where('news_date', '<=', date('Y-m-d'))->orderby('news_date', 'desc')->orderby('title')->paginate(10); return View::make('public.news-list')->with('news', $news)->with('menu', $this->menu)->with('page_category_id', 4)->with('page_title', Lang::get('vcms5::vcms5.news')); }