function tableTitle($title)
{
$sort = getSort();
$field = strtolower(str_replace(' ', '_', $title));
$page = getPageNumber();
$sortDir = getSortDir($field);
$sortChar = !empty($sort) ? 1 : '';
return '<a href="?page=' . $page . '&sort=' . $field . '&sortDir=' . $sortDir . '">' . $title . '</a>';
}
public function listUsers()
{
//Variables
$users = DB::table('user');
$sort = getSort();
$search = Input::get('search');
//Search
if (!empty($search)) {
$users = $users->where('first_name', 'LIKE', "%{$search}%")->orWhere('last_name', 'LIKE', "%{$search}%");
}
//Sort
if (!empty($sort)) {
$users = $users->orderBy($sort, getSortDir());
}
//Paginate
$users = $users->paginate($this->pageSize);
//Return ViewData
return view('users', ['sort' => $sort, 'users' => $users, 'pageNum' => getPageNumber(), 'sortDir' => getSortDir(), 'detailsURL' => '/public/user-info/']);
}
