/** Returs the users on the system. status = (enabled/deleted/pending/bloqued/all) shows users */
public static function roleCount($status = 'enabled', $sort = 'uname', $text = "")
{
global $ari;
if (in_array($status, seguridad_role::getStatus("ALL", false)) && $status != "all") {
$estado = "WHERE status = " . seguridad_role::getStatus($status, false);
} else {
if ($status == "all") {
$estado = "";
} else {
$estado = "WHERE status = 1";
}
}
//search text
$searchText = "";
if ($text != "") {
$searchText = " {$text} ";
}
if (in_array($sort, seguridad_role::getOrders())) {
$sortby = "ORDER BY {$sort}";
} else {
$sortby = "ORDER BY name";
}
$savem = $ari->db->SetFetchMode(ADODB_FETCH_NUM);
$sql = "SELECT id FROM Security_Role {$estado} {$searchText} {$sortby}";
$rs = $ari->db->Execute($sql);
$ari->db->SetFetchMode($savem);
if ($rs && !$rs->EOF) {
// aca cambie sin probar, hay q ver si anda!
$return = $rs->RecordCount();
$rs->Close();
} else {
return false;
}
return $return;
}
