public function getIndex()
{
$ordercl = "news.id";
$ordertype = "desc";
if (Input::exists('s')) {
switch (Input::get('s')) {
case '2':
$ordertype = "asc";
break;
case '3':
$ordercl = "news.name";
$ordertype = "asc";
break;
case '4':
$ordercl = "view";
$ordertype = "desc";
break;
case '5':
$ordertype = "admin.name";
$ordertype = "asc";
break;
case '6':
$ordertype = "categorynews.name";
$ordertype = "asc";
break;
case '7':
$ordertype = "news.created_at";
$ordertype = "desc";
break;
case '8':
$ordertype = "news.updated_at";
$ordertype = "desc";
break;
}
}
$data = news::select('news.*', 'admin.name as nameuser', 'categorynews.name as namec')->join('admin', 'news.user', '=', 'admin.id')->join('categorynews', 'news.categoryNewsID', '=', 'categorynews.id')->orderBy($ordercl, $ordertype);
if (Input::exists('f')) {
switch (Input::get('f')) {
case '1':
$data = $data->where('admin.id', Session::get('logininfo')->id);
break;
case '2':
$data = $data->where('view', 0);
break;
case '3':
$data = $data->where('display', 1);
break;
case '4':
$data = $data->where('display', 0);
break;
}
}
if (Input::exists('q')) {
$query = trim(Input::get('q'));
if ($query != "") {
$data = $data->where(function ($q) use($query) {
$q->where('news.name', 'like', '%' . $query . '%');
$q->orWhere('admin.name', $query);
$q->orWhere('categorynews.name', 'like', '%' . $query . '%');
$q->orWhere('news.description', 'like', '%' . $query . '%');
});
}
}
$data = $data->paginate(15);
return view("admin.news.index", array('data' => $data));
}
