public function getTableData() { $input = Request::createFromGlobals(); $returnData = []; // Get all records $records = Usuario::with('role', 'clases')->noAdmin(); $returnData['total'] = $records->count(); // Filter results if ($input->searchString != '') { $records->where(function ($query) use($input) { $query->where('user_name', 'LIKE', '%' . $input->searchString . '%')->orWhere('user_id', 'LIKE', '%' . $input->searchString . '%'); }); } $returnData['filtered'] = $records->count(); // Get the actual data with limits $records->skip($input->displayStart)->take($input->recordsPerPage)->orderBy('user_id'); $returnData['records'] = $records->get(); return $returnData; }
public function getClasesUsuario() { return Usuario::with('clases')->whereUserId($_SESSION['user_id'])->first()->clases; }