/** Lista Roles para la lista de confiados */
public static function listRolesForTrustees($trustees = YES, $sort = 'name', $operator = OPERATOR_EQUAL)
{
global $ari;
if (trim($trustees) != "") {
$trustees = $ari->db->qMagic($trustees);
$trustees = " AND `Trustees` {$operator} {$trustees} ";
}
if (in_array($sort, seguridad_role::getOrders())) {
$sortby = "ORDER BY `{$sort}`";
} else {
$sortby = "ORDER BY `Name`";
}
$savem = $ari->db->SetFetchMode(ADODB_FETCH_ASSOC);
$sql = "SELECT `ID`, `Name`, `Description`, `Status`, `Anonymous`, `Trustees`\n\t\t\t FROM `Security_Role`\n\t\t\t WHERE Status = '" . USED . "' \n\t\t\t {$trustees} {$sortby}";
$rs = $ari->db->Execute($sql);
$ari->db->SetFetchMode($savem);
$i = 0;
if ($rs && !$rs->EOF) {
while (!$rs->EOF) {
$return[$i] = new seguridad_role(ID_UNDEFINED);
$return[$i]->set("role", $rs->fields["ID"]);
$return[$i]->set("name", $rs->fields["Name"]);
$return[$i]->set("description", $rs->fields["Description"]);
$return[$i]->set("status", $rs->fields["Status"]);
$return[$i]->set("anonymous", $rs->fields["Anonymous"]);
$return[$i]->set("trustees", $rs->fields["Trustees"]);
$i++;
$rs->MoveNext();
}
} else {
$return = false;
}
$rs->Close();
return $return;
}
