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;
}
