public static function queryAccountsList($values)
{
global $DB;
$ID = $values["id"];
$aeskey = $values["aeskey"];
$PluginAccountsHash = new PluginAccountsHash();
$PluginAccountsHash->getFromDB($ID);
$hash = $PluginAccountsHash->fields["hash"];
if ($PluginAccountsHash->isRecursive()) {
$entities = getSonsOf('glpi_entities', $PluginAccountsHash->getEntityID());
} else {
$entities = $PluginAccountsHash->getEntityID();
}
if ($aeskey) {
$query = "SELECT `glpi_plugin_accounts_accounts`.*,\n `glpi_plugin_accounts_accounttypes`.`name` AS type\n FROM `glpi_plugin_accounts_accounts`\n LEFT JOIN `glpi_plugin_accounts_accounttypes`\n ON (`glpi_plugin_accounts_accounts`.`plugin_accounts_accounttypes_id` = `glpi_plugin_accounts_accounttypes`.`id`)\n WHERE `is_deleted`= '0'";
$query .= getEntitiesRestrictRequest(" AND ", "glpi_plugin_accounts_accounts", '', $entities, $PluginAccountsHash->maybeRecursive());
$query .= " ORDER BY `type`,`name`";
foreach ($DB->request($query) as $data) {
$accounts[] = $data;
}
$list = array();
if (!empty($accounts)) {
foreach ($accounts as $account) {
$ID = $account["id"];
$list[$ID]["id"] = $account["id"];
$list[$ID]["name"] = $account["name"];
if (Session::isMultiEntitiesMode()) {
$list[$ID]["entities_id"] = Dropdown::getDropdownName("glpi_entities", $account["entities_id"]);
}
$list[$ID]["type"] = $account["type"];
$list[$ID]["login"] = $account["login"];
$list[$ID]["password"] = $account["encrypted_password"];
}
}
}
return $list;
}
