public function frontendIndex(Request $request)
{
$page = $request->input('page', 1);
$limit = 20;
$offset = ($page - 1) * $limit;
$result = News::offset($offset)->take($limit)->get();
$result1 = DB::table('parent_menu')->get();
$siteTitle = Setting::where('name', 'title')->get();
if (count($siteTitle) > 0) {
$bah = $siteTitle->first()->value;
} else {
$bah = 'Website';
}
$footer = Setting::where('name', 'footer')->get();
if (count($footer) > 0) {
$footer = $footer->first()->value;
} else {
$footer = '(c) 2015, Ordent, All Right Reserved.';
}
$logo = Setting::where('name', 'logo')->get();
if (count($logo) > 0) {
$logo = asset('/uploads/logo/') . '/' . $logo->first()->value;
$logo = preg_replace('/\\s+/', '', $logo);
} else {
$logo = '#';
}
$count = ceil(count(News::all()) / 20);
return view('frontend.news-index', compact('result', 'title', 'result1', 'footer', 'count', 'logo'));
}
