/**
* Display all the linked computers of a defined typology
*
*@param $typoID = typo ID.
*
*@return Nothing (displays)
**/
public static function showForTypology(PluginTypologyTypology $typo)
{
global $DB, $CFG_GLPI;
$typoID = $typo->fields['id'];
if (!$typo->can($typoID, 'r')) {
return false;
}
$canedit = $typo->can($typoID, 'w');
$canview = $typo->can($typoID, 'r');
$rand = mt_rand();
$query = "SELECT DISTINCT `itemtype`\n FROM `glpi_plugin_typology_typologies_items`\n WHERE `plugin_typology_typologies_id` = '{$typoID}'\n ORDER BY `itemtype`";
$result = $DB->query($query);
$number = $DB->numrows($result);
if (Session::isMultiEntitiesMode()) {
$colsup = 1;
} else {
$colsup = 0;
}
if ($canedit) {
echo "<div class='firstbloc'>";
echo "<form method='post' name='typologies_form{$rand}' id='typologies_form{$rand}' action='" . $CFG_GLPI["root_doc"] . "/plugins/typology/front/typology.form.php'>";
echo "<table class='tab_cadre_fixe'>";
echo "<tr>";
echo "<th colspan='7'>" . __('Add an item') . "</th></tr>";
echo "<tr class='tab_bg_1'><td colspan='4' class='center'>";
echo "<input type='hidden' name='plugin_typology_typologies_id' value='{$typoID}'>";
Dropdown::showAllItems("items_id", 0, 0, $typo->fields['is_recursive'] ? -1 : $typo->fields['entities_id'], PluginTypologyTypology::getTypes());
echo "</td>";
echo "<td colspan='3' class='center' class='tab_bg_2'>";
echo "<input type='submit' name='add_item' value=\"" . _sx('button', 'Add') . "\" class='submit'>";
echo "</td></tr>";
echo "</table>";
Html::closeForm();
echo "</div>";
}
echo "<div class='spaced'>";
if ($canedit && $number) {
Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
$massiveactionparams = array();
Html::showMassiveActions(__CLASS__, $massiveactionparams);
}
echo "<table class='tab_cadre_fixe'>";
echo "<tr>";
echo "<th colspan='" . ($canedit ? 7 + $colsup : 6 + $colsup) . "'>";
if ($DB->numrows($result) == 0) {
_e('No linked element', 'typology');
} else {
_e('Linked elements', 'typology');
}
echo "</th></tr><tr>";
if ($canedit && $number) {
echo "<th width='10'>" . Html::getCheckAllAsCheckbox('mass' . __CLASS__ . $rand) . "</th>";
}
echo "<th>" . __('Type') . "</th>";
echo "<th>" . __('Name') . "</th>";
if (Session::isMultiEntitiesMode()) {
echo "<th>" . __('Entity') . "</th>";
}
echo "<th>" . __('Serial number') . "</th>";
echo "<th>" . __('Inventory number') . "</th>";
echo "<th>" . __('Responding to typology\'s criteria', 'typology') . "</th>";
echo "</tr>";
for ($i = 0; $i < $number; $i++) {
$itemtype = $DB->result($result, $i, "itemtype");
if (!($item = getItemForItemtype($itemtype))) {
continue;
}
if ($canview) {
$column = "name";
$itemtable = getTableForItemType($itemtype);
$query = "SELECT `" . $itemtable . "`.*,\n `glpi_plugin_typology_typologies_items`.`id` AS IDP,\n `glpi_plugin_typology_typologies_items`.`is_validated`,\n `glpi_plugin_typology_typologies_items`.`error`,\n `glpi_entities`.`id` AS entity " . " FROM `glpi_plugin_typology_typologies_items`, `" . $itemtable . "` LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` = `" . $itemtable . "`.`entities_id`) " . " WHERE `" . $itemtable . "`.`id` = `glpi_plugin_typology_typologies_items`.`items_id`\n AND `glpi_plugin_typology_typologies_items`.`itemtype` = '{$itemtype}'\n AND `glpi_plugin_typology_typologies_items`.`plugin_typology_typologies_id` = '{$typoID}'";
if ($itemtype != 'User') {
$query .= getEntitiesRestrictRequest(" AND ", $itemtable, '', '', $item->maybeRecursive());
}
if ($item->maybeTemplate()) {
$query .= " AND " . $itemtable . ".is_template='0'";
}
$query .= " ORDER BY `glpi_entities`.`completename`, `" . $itemtable . "`.`{$column}` ";
if ($result_linked = $DB->query($query)) {
if ($DB->numrows($result_linked)) {
Session::initNavigateListItems($itemtype, PluginTypologyTypology::getTypeName(1) . " = " . $typo->fields['name']);
while ($data = $DB->fetch_assoc($result_linked)) {
$ID = "";
$item->getFromDB($data["id"]);
Session::addToNavigateListItems($itemtype, $data["id"]);
if ($itemtype == 'User') {
$format = formatUserName($data["id"], $data["name"], $data["realname"], $data["firstname"], 1);
} else {
$format = $data["name"];
}
if ($_SESSION["glpiis_ids_visible"] || empty($data["name"])) {
$ID = " (" . $data["id"] . ")";
}
$link = Toolbox::getItemTypeFormURL($itemtype);
$name = "<a href=\"" . $link . "?id=" . $data["id"] . "\">" . $format;
if ($itemtype != 'User') {
$name .= " " . $ID;
}
$name .= "</a>";
echo "<tr class='tab_bg_1'>";
if ($canedit) {
echo "<td width='10'>";
Html::showMassiveActionCheckBox(__CLASS__, $data["IDP"]);
echo "</td>";
}
echo "<input type='hidden' name='plugin_typology_typologies_id' value='{$typoID}'>";
echo "<td class='center'>" . $item->getTypeName() . "</td>";
echo "<td class='center' " . (isset($data['is_deleted']) && $data['is_deleted'] ? "class='tab_bg_2_2'" : "") . ">" . $name . "</td>";
if (Session::isMultiEntitiesMode()) {
if ($itemtype != 'User') {
echo "<td class='center'>" . Dropdown::getDropdownName("glpi_entities", $data['entity']) . "</td>";
} else {
echo "<td class='center'>-</td>";
}
}
echo "<td class='center'>" . (isset($data["serial"]) ? "" . $data["serial"] . "" : "-") . "</td>";
echo "<td class='center'>" . (isset($data["otherserial"]) ? "" . $data["otherserial"] . "" : "-") . "</td>";
if ($data["is_validated"] > 0) {
$critTypOK = __('Yes');
} else {
$critTypOK = "<font color='red'>" . __('No') . " " . __('for the criteria', 'typology') . " ";
$i = 0;
$critTypOK .= self::displayErrors($data["error"]);
$critTypOK .= "</font>";
}
echo "<td class ='center'><b>" . $critTypOK . "</b></td>";
echo "</tr>";
}
}
}
}
}
echo "</table>";
if ($canedit && $number) {
$paramsma['ontop'] = false;
Html::showMassiveActions(__CLASS__, $paramsma);
Html::closeForm();
}
echo "</div>";
}
function plugin_typology_getAddSearchOptions($itemtype)
{
$plugin = new Plugin();
$sopt = array();
if ($plugin->isActivated('typology') && plugin_typology_haveRight("typology", "r")) {
if (in_array($itemtype, PluginTypologyTypology::getTypes(true))) {
$sopt[4650]['table'] = 'glpi_plugin_typology_typologies';
$sopt[4650]['field'] = 'name';
$sopt[4650]['name'] = PluginTypologyTypology::getTypeName(1) . " - " . __('Typology\'s name', 'typology');
$sopt[4650]['forcegroupby'] = true;
$sopt[4650]['datatype'] = 'itemlink';
$sopt[4650]['massiveaction'] = false;
$sopt[4650]['itemlink_type'] = 'PluginTypologyTypology';
$sopt[4650]['joinparams'] = array('beforejoin' => array('table' => 'glpi_plugin_typology_typologies_items', 'joinparams' => array('jointype' => 'itemtype_item')));
$sopt[4651]['table'] = 'glpi_plugin_typology_typologies_items';
$sopt[4651]['field'] = 'is_validated';
$sopt[4651]['datatype'] = 'bool';
$sopt[4651]['massiveaction'] = false;
$sopt[4651]['name'] = PluginTypologyTypology::getTypeName(1) . " - " . __('Responding to typology\'s criteria', 'typology');
$sopt[4651]['forcegroupby'] = true;
$sopt[4651]['joinparams'] = array('jointype' => 'itemtype_item');
$sopt[4652]['table'] = 'glpi_plugin_typology_typologies_items';
$sopt[4652]['field'] = 'error';
$sopt[4652]['name'] = PluginTypologyTypology::getTypeName(1) . " - " . __('Result details');
$sopt[4652]['forcegroupby'] = true;
$sopt[4652]['massiveaction'] = false;
$sopt[4652]['joinparams'] = array('jointype' => 'itemtype_item');
}
}
return $sopt;
}
