Get number of licensesof a software
| static public countForSoftware ( $softwares_id ) : number | ||
| $softwares_id | software ID | |
| return | number | of licenses |
/**
* Show softwares candidates to be merged with the current
*
* @return nothing
**/
function showMergeCandidates()
{
global $DB, $CFG_GLPI;
$ID = $this->getField('id');
$this->check($ID, "w");
$rand = mt_rand();
echo "<div class='center'>";
$sql = "SELECT `glpi_softwares`.`id`,\n `glpi_softwares`.`name`,\n `glpi_entities`.`completename` AS entity\n FROM `glpi_softwares`\n LEFT JOIN `glpi_entities` ON (`glpi_softwares`.`entities_id` = `glpi_entities`.`id`)\n WHERE (`glpi_softwares`.`id` != '{$ID}'\n AND `glpi_softwares`.`name` = '" . addslashes($this->fields["name"]) . "'\n AND `glpi_softwares`.`is_deleted` = '0'\n AND `glpi_softwares`.`is_template` = '0' " . getEntitiesRestrictRequest('AND', 'glpi_softwares', 'entities_id', getSonsOf("glpi_entities", $this->fields["entities_id"]), false) . ")\n ORDER BY `entity`";
$req = $DB->request($sql);
if ($nb = $req->numrows()) {
$link = Toolbox::getItemTypeFormURL('Software');
Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
$paramsma = array('num_displayed' => $nb, 'specific_actions' => array('mergesoftware' => __('Merge')));
Html::showMassiveActions(__CLASS__, $paramsma);
echo "<table class='tab_cadre_fixehov'>";
echo "<tr><th width='10'>";
echo Html::checkAllAsCheckbox('mass' . __CLASS__ . $rand);
echo "</th>";
echo "<th>" . __('Name') . "</th>";
echo "<th>" . __('Entity') . "</th>";
echo "<th>" . _n('Installation', 'Installations', 2) . "</th>";
echo "<th>" . _n('License', 'Licenses', 2) . "</th></tr>";
foreach ($req as $data) {
echo "<tr class='tab_bg_2'>";
echo "<td>" . Html::getMassiveActionCheckBox(__CLASS__, $data["id"]) . "</td>";
echo "<td><a href='" . $link . "?id=" . $data["id"] . "'>" . $data["name"] . "</a></td>";
echo "<td>" . $data["entity"] . "</td>";
echo "<td class='right'>" . Computer_SoftwareVersion::countForSoftware($data["id"]) . "</td>";
echo "<td class='right'>" . SoftwareLicense::countForSoftware($data["id"]) . "</td></tr>\n";
}
echo "</table>\n";
echo "<input type='hidden' name='id' value='{$ID}'>";
$paramsma['ontop'] = false;
Html::showMassiveActions(__CLASS__, $paramsma);
Html::closeForm();
} else {
_e('No item found');
}
echo "</div>";
}
/**
* Show softwares candidates to be merged with the current
*
* @return nothing
**/
function showMergeCandidates()
{
global $DB, $CFG_GLPI, $LANG;
$ID = $this->getField('id');
$this->check($ID, "w");
$rand = mt_rand();
echo "<div class='center'>";
$sql = "SELECT `glpi_softwares`.`id`,\n `glpi_softwares`.`name`,\n `glpi_entities`.`completename` AS entity\n FROM `glpi_softwares`\n LEFT JOIN `glpi_entities` ON (`glpi_softwares`.`entities_id` = `glpi_entities`.`id`)\n WHERE (`glpi_softwares`.`id` != '{$ID}'\n AND `glpi_softwares`.`name` = '" . addslashes($this->fields["name"]) . "'\n AND `glpi_softwares`.`is_deleted` = '0'\n AND `glpi_softwares`.`is_template` = '0' " . getEntitiesRestrictRequest('AND', 'glpi_softwares', 'entities_id', getSonsOf("glpi_entities", $this->fields["entities_id"]), false) . ")\n ORDER BY `entity`";
$req = $DB->request($sql);
if ($req->numrows()) {
$link = getItemTypeFormURL('Software');
echo "<form method='post' name='mergesoftware_form{$rand}' id='mergesoftware_form{$rand}'\n action='" . $link . "'>";
echo "<table class='tab_cadre_fixehov'><tr><th> </th>";
echo "<th>" . $LANG['common'][16] . "</th>";
echo "<th>" . $LANG['entity'][0] . "</th>";
echo "<th>" . $LANG['software'][19] . "</th>";
echo "<th>" . $LANG['software'][11] . "</th></tr>";
foreach ($req as $data) {
echo "<tr class='tab_bg_2'>";
echo "<td><input type='checkbox' name='item[" . $data["id"] . "]' value='1'></td>";
echo "<td<a href='" . $link . "?id=" . $data["id"] . "'>" . $data["name"] . "</a></td>";
echo "<td>" . $data["entity"] . "</td>";
echo "<td class='right'>" . Computer_SoftwareVersion::countForSoftware($data["id"]) . "</td>";
echo "<td class='right'>" . SoftwareLicense::countForSoftware($data["id"]) . "</td></tr>\n";
}
echo "</table>\n";
openArrowMassive("mergesoftware_form{$rand}", true);
echo "<input type='hidden' name='id' value='{$ID}'>";
closeArrowMassive('mergesoftware', $LANG['software'][48]);
echo "</form>";
} else {
echo $LANG['search'][15];
}
echo "</div>";
}