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