public static function listAvailpages() { $pagelist = Admin_ModulPage::all(); $arrayPages = array(); foreach ($pagelist as $value) { $regnav = Admin_Navpage::where('modulpageid', '=', $value->modulpageid)->get(); if (isset($value->action) && $value->actionalias != '' && $value->visible == 1 && empty($regnav)) { $arrayPages[$value->modulpageid] = $value->actionalias; } } return $arrayPages; }