public function performSearch()
{
if (Input::has('q')) {
$searchterm = '%' . strtoupper(Input::get('q')) . '%';
if (Session::get('lang') == "en" || Session::get('lang') == null) {
$results = Page::whereRaw('page_title like upper(?) or page_content like upper(?)', array($searchterm, $searchterm))->get();
} else {
$results = Page::whereRaw('page_title_fr like upper(?) or page_content_fr like upper(?)', array($searchterm, $searchterm))->get();
}
if (Session::get('lang') == "en" || Session::get('lang') == null) {
$news = News::whereRaw('title like upper(?) or news_text like upper(?)', array($searchterm, $searchterm))->get();
} else {
$news = News::whereRaw('title_fr like upper(?) or news_text_fr like upper(?)', array($searchterm, $searchterm))->get();
}
return View::make('public.search')->with('page_title', 'Search')->with('meta_tags', '')->with('meta', '')->with('searchterm', Input::get('q'))->with('results', $results)->with('news', $news)->with('page_category_id', 1)->with('menu', MenuTrait::getMenu());
} else {
return View::make('public.search')->with('page_title', 'Search')->with('searchterm', '')->with('results', [])->with('news', [])->with('page_category_id', 1)->with('menu', MenuTrait::getMenu());
}
}
/**
* 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'));
}
