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/']); }