grthtrhthjhtyjytjytkergtrhtrjytjerhrfh4:24 29/09/2026.
--------------------------------------------------------------------------
*/
/** @file
* @brief
*/
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access this file directly");
}
/** Software Class
**/
class Software extends CommonDBTM {
// From CommonDBTM
public $dohistory = true;
static protected $forward_entity_to = array('Infocom', 'ReservationItem', 'SoftwareVersion');
static $rightname = 'software';
protected $usenotepad = true;
static function getTypeName($nb=0) {
return _n('Software', 'Software', $nb);
}
/**
* @see CommonGLPI::getMenuShorcut()
*
* @since version 0.85
**/
static function getMenuShorcut() {
return 's';
}
function getTabNameForItem(CommonGLPI $item, $withtemplate=0) {
if (!$withtemplate) {
switch ($item->getType()) {
case __CLASS__ :
if ($item->isRecursive()
&& $item->can($item->fields['id'], UPDATE)) {
return __('Merging');
}
break;
}
}
return '';
}
static function displayTabContentForItem(CommonGLPI $item, $tabnum=1, $withtemplate=0) {
if ($item->getType() == __CLASS__) {
$item->showMergeCandidates();
}
return true;
}
function defineTabs($options=array()) {
$ong = array();
$this->addDefaultFormTab($ong);
$this->addStandardTab('SoftwareVersion', $ong, $options);
$this->addStandardTab('SoftwareLicense', $ong, $options);
$this->addStandardTab('Computer_SoftwareVersion', $ong, $options);
$this->addStandardTab('Infocom', $ong, $options);
$this->addStandardTab('Contract_Item', $ong, $options);
$this->addStandardTab('Document_Item', $ong, $options);
$this->addStandardTab('Ticket', $ong, $options);
$this->addStandardTab('Item_Problem', $ong, $options);
$this->addStandardTab('Change_Item', $ong, $options);
$this->addStandardTab('Link', $ong, $options);
$this->addStandardTab('Notepad', $ong, $options);
$this->addStandardTab('Reservation', $ong, $options);
$this->addStandardTab('Log', $ong, $options);
$this->addStandardTab(__CLASS__, $ong, $options);
return $ong;
}
function prepareInputForUpdate($input) {
if (isset($input['is_update']) && !$input['is_update']) {
$input['softwares_id'] = 0;
}
return $input;
}
function prepareInputForAdd($input) {
if (isset($input['is_update']) && !$input['is_update']) {
$input['softwares_id'] = 0;
}
if (isset($input["id"]) && ($input["id"] > 0)) {
$input["_oldID"] = $input["id"];
}
unset($input['id']);
unset($input['withtemplate']);
//If category was not set by user (when manually adding a user)
if (!isset($input["softwarecategories_id"]) || !$input["softwarecategories_id"]) {
$softcatrule = new RuleSoftwareCategoryCollection();
$result = $softcatrule->processAllRules(null,null,Toolbox::stripslashes_deep($input));
if (!empty($result) && isset($result["softwarecategories_id"])) {
$input["softwarecategories_id"] = $result["softwarecategories_id"];
} else {
$input["softwarecategories_id"] = 0;
}
}
return $input;
}
function post_addItem() {
global $DB, $CFG_GLPI;
// Manage add from template
if (isset($this->input["_oldID"])) {
// ADD Infocoms
Infocom::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Contract
Contract_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
// ADD Documents
Document_Item::cloneItem($this->getType(), $this->input["_oldID"], $this->fields['id']);
}
}
function cleanDBonPurge() {
global $DB;
// Delete all licenses
$query2 = "SELECT `id`
FROM `glpi_softwarelicenses`
WHERE `softwares_id` = '".$this->fields['id']."'";
if ($result2 = $DB->query($query2)) {
if ($DB->numrows($result2)) {
$lic = new SoftwareLicense();
while ($data = $DB->fetch_assoc($result2)) {
$lic->delete(array("id" => $data["id"]));
}
}
}
$version = new SoftwareVersion();
$version->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ip = new Item_Problem();
$ip->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ci = new Change_Item();
$ci->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ip = new Item_Project();
$ip->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
}
/**
* Update validity indicator of a specific software
*
* @param $ID ID of the licence
*
* @since version 0.85
*
* @return nothing
**/
static function updateValidityIndicator($ID) {
$soft = new self();
if ($soft->getFromDB($ID)) {
$valid = 1;
if (countElementsInTable('glpi_softwarelicenses',
"`softwares_id`='$ID' AND NOT `is_valid`") > 0) {
$valid = 0;
}
if ($valid != $soft->fields['is_valid']) {
$soft->update(array('id' => $ID,
'is_valid' => $valid));
}
}
}
/**
* Print the Software form
*
* @param $ID integer ID of the item
* @param $options array of possible options:
* - target filename : where to go when done.
* - withtemplate boolean : template or basic item
*
*@return boolean item found
**/
function showForm($ID, $options=array()) {
$this->initForm($ID, $options);
$this->showFormHeader($options);
$canedit = $this->canEdit($ID);
echo "";
echo "| " . __('Name') . " | ";
echo "";
Html::autocompletionTextField($this, "name");
echo " | ";
echo "" . __('Publisher')." | ";
Manufacturer::dropdown(array('value' => $this->fields["manufacturers_id"]));
echo " |
\n";
echo "";
echo "| " . __('Location') . " | ";
Location::dropdown(array('value' => $this->fields["locations_id"],
'entity' => $this->fields["entities_id"]));
echo " | ";
echo "" . __('Category') . " | ";
SoftwareCategory::dropdown(array('value' => $this->fields["softwarecategories_id"]));
echo " |
\n";
echo "";
echo "| " . __('Technician in charge of the software') . " | ";
User::dropdown(array('name' => 'users_id_tech',
'value' => $this->fields["users_id_tech"],
'right' => 'own_ticket',
'entity' => $this->fields["entities_id"]));
echo " | ";
echo "" . __('Associable to a ticket') . " | ";
Dropdown::showYesNo('is_helpdesk_visible', $this->fields['is_helpdesk_visible']);
echo " |
\n";
echo "";
echo "| ".__('Group in charge of the software')." | ";
echo "";
Group::dropdown(array('name' => 'groups_id_tech',
'value' => $this->fields['groups_id_tech'],
'entity' => $this->fields['entities_id'],
'condition' => '`is_assign`'));
echo " | ";
echo "".__('Comments') . " | ";
echo "";
echo "";
echo " |
\n";
echo "";
echo "| " . __('User') . " | ";
echo "";
User::dropdown(array('value' => $this->fields["users_id"],
'entity' => $this->fields["entities_id"],
'right' => 'all'));
echo " |
\n";
echo "";
echo "| " . __('Group') . " | ";
Group::dropdown(array('value' => $this->fields["groups_id"],
'entity' => $this->fields["entities_id"],
'condition' => '`is_itemgroup`'));
echo " |
\n";
// UPDATE
echo "";
//TRANS: a noun, (ex : this software is an upgrade of..)
echo "| " . __('Upgrade') . " | ";
Dropdown::showYesNo("is_update", $this->fields['is_update']);
echo " " . __('from') . " ";
Software::dropdown(array('value' => $this->fields["softwares_id"]));
echo " |
\n";
$this->showFormButtons($options);
return true;
}
function getEmpty() {
global $CFG_GLPI;
parent::getEmpty();
$this->fields["is_helpdesk_visible"] = $CFG_GLPI["default_software_helpdesk_visible"];
}
/**
* @see CommonDBTM::getSpecificMassiveActions()
**/
function getSpecificMassiveActions($checkitem=NULL) {
$isadmin = static::canUpdate();
$actions = parent::getSpecificMassiveActions($checkitem);
if ($isadmin
&& (countElementsInTable("glpi_rules", "sub_type='RuleSoftwareCategory'") > 0)) {
$actions[__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'compute_software_category']
= __('Recalculate the category');
}
if (Session::haveRightsOr("rule_dictionnary_software", array(CREATE, UPDATE))
&& (countElementsInTable("glpi_rules", "sub_type='RuleDictionnarySoftware'") > 0)) {
$actions[__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'replay_dictionnary']
= __('Replay the dictionary rules');
}
if ($isadmin) {
MassiveAction::getAddTransferList($actions);
}
return $actions;
}
/**
* @since version 0.85
*
* @see CommonDBTM::processMassiveActionsForOneItemtype()
**/
static function processMassiveActionsForOneItemtype(MassiveAction $ma, CommonDBTM $item,
array $ids) {
switch ($ma->getAction()) {
case 'merge' :
$input = $ma->getInput();
if (isset($input['item_items_id'])) {
$items = array();
foreach ($ids as $id) {
$items[$id] = 1;
}
if ($item->can($input['item_items_id'], UPDATE)) {
if ($item->merge($items)) {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_OK);
} else {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_KO);
$ma->addMessage($item->getErrorMessage(ERROR_ON_ACTION));
}
} else {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($item->getErrorMessage(ERROR_RIGHT));
}
} else {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_KO);
}
return;
case 'compute_software_category' :
$softcatrule = new RuleSoftwareCategoryCollection();
foreach ($ids as $id) {
$params = array();
//Get software name and manufacturer
if ($item->can($id, UPDATE)) {
$params["name"] = $item->fields["name"];
$params["manufacturers_id"] = $item->fields["manufacturers_id"];
$params["comment"] = $item->fields["comment"];
$output = array();
$output = $softcatrule->processAllRules(null, $output, $params);
//Process rules
if (isset($output['softwarecategories_id'])
&& $item->update(array('id' => $id,
'softwarecategories_id'
=> $output['softwarecategories_id']))) {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_OK);
} else {
$ma->itemDone($item->getType(), $id, MassiveAction::ACTION_KO);
$ma->addMessage($item->getErrorMessage(ERROR_ON_ACTION));
}
} else {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($item->getErrorMessage(ERROR_RIGHT));
}
}
return;
case 'replay_dictionnary' :
$softdictionnayrule = new RuleDictionnarySoftwareCollection();
$allowed_ids = array();
foreach ($ids as $id) {
if ($item->can($id, UPDATE)) {
$allowed_ids[] = $id;
} else {
$ma->itemDone($item->getType(), $ids, MassiveAction::ACTION_NORIGHT);
$ma->addMessage($item->getErrorMessage(ERROR_RIGHT));
}
}
if ($softdictionnayrule->replayRulesOnExistingDB(0, 0, $allowed_ids)>0) {
$ma->itemDone($item->getType(), $allowed_ids, MassiveAction::ACTION_OK);
} else {
$ma->itemDone($item->getType(), $allowed_ids, MassiveAction::ACTION_KO);
}
return;
}
parent::processMassiveActionsForOneItemtype($ma, $item, $ids);
}
function getSearchOptions() {
// Only use for History (not by search Engine)
$tab = array();
$tab['common'] = __('Characteristics');
$tab[1]['table'] = $this->getTable();
$tab[1]['field'] = 'name';
$tab[1]['name'] = __('Name');
$tab[1]['datatype'] = 'itemlink';
$tab[1]['massiveaction'] = false;
$tab[2]['table'] = $this->getTable();
$tab[2]['field'] = 'id';
$tab[2]['name'] = __('ID');
$tab[2]['massiveaction'] = false;
$tab[2]['datatype'] = 'number';
$tab+=Location::getSearchOptionsToAdd();
$tab[16]['table'] = $this->getTable();
$tab[16]['field'] = 'comment';
$tab[16]['name'] = __('Comments');
$tab[16]['datatype'] = 'text';
$tab[62]['table'] = 'glpi_softwarecategories';
$tab[62]['field'] = 'completename';
$tab[62]['name'] = __('Category');
$tab[62]['datatype'] = 'dropdown';
$tab[19]['table'] = $this->getTable();
$tab[19]['field'] = 'date_mod';
$tab[19]['name'] = __('Last update');
$tab[19]['datatype'] = 'datetime';
$tab[19]['massiveaction'] = false;
$tab[121]['table'] = $this->getTable();
$tab[121]['field'] = 'date_creation';
$tab[121]['name'] = __('Creation date');
$tab[121]['datatype'] = 'datetime';
$tab[121]['massiveaction'] = false;
$tab[23]['table'] = 'glpi_manufacturers';
$tab[23]['field'] = 'name';
$tab[23]['name'] = __('Publisher');
$tab[23]['datatype'] = 'dropdown';
$tab[24]['table'] = 'glpi_users';
$tab[24]['field'] = 'name';
$tab[24]['linkfield'] = 'users_id_tech';
$tab[24]['name'] = __('Technician in charge of the software');
$tab[24]['datatype'] = 'dropdown';
$tab[24]['right'] = 'own_ticket';
$tab[49]['table'] = 'glpi_groups';
$tab[49]['field'] = 'completename';
$tab[49]['linkfield'] = 'groups_id_tech';
$tab[49]['name'] = __('Group in charge of the software');
$tab[49]['condition'] = '`is_assign`';
$tab[49]['datatype'] = 'dropdown';
$tab[70]['table'] = 'glpi_users';
$tab[70]['field'] = 'name';
$tab[70]['name'] = __('User');
$tab[70]['datatype'] = 'dropdown';
$tab[70]['right'] = 'all';
$tab[71]['table'] = 'glpi_groups';
$tab[71]['field'] = 'completename';
$tab[71]['name'] = __('Group');
$tab[71]['condition'] = '`is_itemgroup`';
$tab[71]['datatype'] = 'dropdown';
$tab[61]['table'] = $this->getTable();
$tab[61]['field'] = 'is_helpdesk_visible';
$tab[61]['name'] = __('Associable to a ticket');
$tab[61]['datatype'] = 'bool';
$tab[63]['table'] = $this->getTable();
$tab[63]['field'] = 'is_valid';
//TRANS: Indicator to know is all licenses of the software are valids
$tab[63]['name'] = __('Valid licenses');
$tab[63]['datatype'] = 'bool';
$tab+= SoftwareLicense::getSearchOptionsToAdd();
$tab[80]['table'] = 'glpi_entities';
$tab[80]['field'] = 'completename';
$tab[80]['name'] = __('Entity');
$tab[80]['massiveaction'] = false;
$tab[80]['datatype'] = 'dropdown';
$tab[72]['table'] = 'glpi_computers_softwareversions';
$tab[72]['field'] = 'id';
$tab[72]['name'] = _x('quantity', 'Number of installations');
$tab[72]['forcegroupby'] = true;
$tab[72]['usehaving'] = true;
$tab[72]['datatype'] = 'count';
$tab[72]['nometa'] = true;
$tab[72]['massiveaction'] = false;
if (Session::getLoginUserID()) {
$tab[72]['joinparams'] = array('jointype' => 'child',
'condition' => "AND NEWTABLE.`is_deleted_computer` = '0'
AND NEWTABLE.`is_deleted` = '0'
AND NEWTABLE.`is_template_computer` = '0'
".getEntitiesRestrictRequest('AND', 'NEWTABLE'),
'beforejoin' => array('table' => 'glpi_softwareversions',
'joinparams'
=> array('jointype'
=> 'child')));
}
$tab[86]['table'] = $this->getTable();
$tab[86]['field'] = 'is_recursive';
$tab[86]['name'] = __('Child entities');
$tab[86]['datatype'] = 'bool';
$tab[86]['massiveaction'] = false;
$tab['versions'] = _n('Version', 'Versions', Session::getPluralNumber());
$tab[5]['table'] = 'glpi_softwareversions';
$tab[5]['field'] = 'name';
$tab[5]['name'] = __('Version name');
$tab[5]['forcegroupby'] = true;
$tab[5]['massiveaction'] = false;
$tab[5]['joinparams'] = array('jointype' => 'child');
$tab[5]['displaywith'] = array('softwares_id');
$tab[5]['datatype'] = 'dropdown';
$tab[31]['table'] = 'glpi_states';
$tab[31]['field'] = 'completename';
$tab[31]['name'] = __('Status');
$tab[31]['datatype'] = 'dropdown';
$tab[31]['forcegroupby'] = true;
$tab[31]['massiveaction'] = false;
$tab[31]['joinparams'] = array('beforejoin'
=> array('table' => 'glpi_softwareversions',
'joinparams' => array('jointype' => 'child')));
$tab[170]['table'] = 'glpi_softwareversions';
$tab[170]['field'] = 'comment';
$tab[170]['name'] = __('Version comments');
$tab[170]['forcegroupby'] = true;
$tab[170]['datatype'] = 'text';
$tab[170]['massiveaction'] = false;
$tab[170]['joinparams'] = array('jointype' => 'child');
$tab[4]['table'] = 'glpi_operatingsystems';
$tab[4]['field'] = 'name';
$tab[4]['datatype'] = 'dropdown';
$tab[4]['name'] = __('Operating system');
$tab[4]['forcegroupby'] = true;
$tab[4]['joinparams'] = array('beforejoin'
=> array('table' => 'glpi_softwareversions',
'joinparams' => array('jointype' => 'child')));
// add objectlock search options
$tab += ObjectLock::getSearchOptionsToAdd( get_class($this) ) ;
$tab += Notepad::getSearchOptionsToAdd();
return $tab;
}
/**
* Make a select box for software to install
*
* @param $myname select name
* @param $entity_restrict restrict to a defined entity
*
* @return nothing (print out an HTML select box)
**/
static function dropdownSoftwareToInstall($myname, $entity_restrict) {
global $CFG_GLPI;
// Make a select box
$rand = mt_rand();
$where = getEntitiesRestrictRequest('', 'glpi_softwares','entities_id',
$entity_restrict, true);
$rand = Dropdown::show('Software', array('condition' => $where));
$paramsselsoft = array('softwares_id' => '__VALUE__',
'myname' => $myname);
Ajax::updateItemOnSelectEvent("dropdown_softwares_id$rand", "show_".$myname.$rand,
$CFG_GLPI["root_doc"]."/ajax/dropdownInstallVersion.php",
$paramsselsoft);
echo " \n";
return $rand;
}
/**
* Make a select box for license software to associate
*
* @param $myname select name
* @param $entity_restrict restrict to a defined entity
*
* @return nothing (print out an HTML select box)
**/
static function dropdownLicenseToInstall($myname, $entity_restrict) {
global $CFG_GLPI, $DB;
$rand = mt_rand();
$where = getEntitiesRestrictRequest(' AND', 'glpi_softwarelicenses', 'entities_id',
$entity_restrict, true);
$query = "SELECT DISTINCT `glpi_softwares`.`id`,
`glpi_softwares`.`name`
FROM `glpi_softwares`
INNER JOIN `glpi_softwarelicenses`
ON (`glpi_softwares`.`id` = `glpi_softwarelicenses`.`softwares_id`)
WHERE `glpi_softwares`.`is_deleted` = '0'
AND `glpi_softwares`.`is_template` = '0'
$where
ORDER BY `glpi_softwares`.`name`";
$result = $DB->query($query);
$values = array();
if ($DB->numrows($result)) {
while ($data = $DB->fetch_assoc($result)) {
$softwares_id = $data["id"];
$values[$softwares_id] = $data["name"];
}
}
$rand = Dropdown::showFromArray('softwares_id', $values, array('display_emptychoice' => true));
$paramsselsoft = array('softwares_id' => '__VALUE__',
'entity_restrict' => $entity_restrict,
'myname' => $myname);
Ajax::updateItemOnSelectEvent("dropdown_softwares_id$rand", "show_".$myname.$rand,
$CFG_GLPI["root_doc"]."/ajax/dropdownSoftwareLicense.php",
$paramsselsoft);
echo " \n";
return $rand;
}
/**
* Create a new software
*
* @param name the software's name (need to be addslashes)
* @param manufacturer_id id of the software's manufacturer
* @param entity the entity in which the software must be added
* @param comment (default '')
* @param is_recursive boolean must the software be recursive (false by default)
* @param is_helpdesk_visible show in helpdesk, default : from config (false by default)
*
* @return the software's ID
**/
function addSoftware($name, $manufacturer_id, $entity, $comment='',
$is_recursive=false, $is_helpdesk_visible=NULL) {
global $DB, $CFG_GLPI;
$input["name"] = $name;
$input["manufacturers_id"] = $manufacturer_id;
$input["entities_id"] = $entity;
$input["is_recursive"] = ($is_recursive ? 1 : 0);
// No comment
if (is_null($is_helpdesk_visible)) {
$input["is_helpdesk_visible"] = $CFG_GLPI["default_software_helpdesk_visible"];
} else {
$input["is_helpdesk_visible"] = $is_helpdesk_visible;
}
//Process software's category rules
$softcatrule = new RuleSoftwareCategoryCollection();
$result = $softcatrule->processAllRules(null, null, Toolbox::stripslashes_deep($input));
if (!empty($result) && isset($result["softwarecategories_id"])) {
$input["softwarecategories_id"] = $result["softwarecategories_id"];
} else {
$input["softwarecategories_id"] = 0;
}
return $this->add($input);
}
/**
* Add a software. If already exist in dustbin restore it
*
* @param name the software's name
* @param manufacturer the software's manufacturer
* @param entity the entity in which the software must be added
* @param comment comment (default '')
* @param is_recursive boolean must the software be recursive (false by default)
* @param is_helpdesk_visible show in helpdesk, default = config value (false by default)
*/
function addOrRestoreFromTrash($name, $manufacturer, $entity, $comment='',
$is_recursive=false, $is_helpdesk_visible=NULL) {
global $DB;
//Look for the software by his name in GLPI for a specific entity
$manufacturer_id = 0;
if ($manufacturer != '') {
$manufacturer_id = Dropdown::import('Manufacturer', array('name' => $manufacturer));
}
$query_search = "SELECT `glpi_softwares`.`id`, `glpi_softwares`.`is_deleted`
FROM `glpi_softwares`
WHERE `name` = '$name'
AND `manufacturers_id` = '$manufacturer_id'
AND `is_template` = '0' ".
getEntitiesRestrictRequest('AND', 'glpi_softwares',
'entities_id', $entity,true);
$result_search = $DB->query($query_search);
if ($DB->numrows($result_search) > 0) {
//Software already exists for this entity, get his ID
$data = $DB->fetch_assoc($result_search);
$ID = $data["id"];
// restore software
if ($data['is_deleted']) {
$this->removeFromTrash($ID);
}
} else {
$ID = 0;
}
if (!$ID) {
$ID = $this->addSoftware($name, $manufacturer_id, $entity, $comment, $is_recursive,
$is_helpdesk_visible);
}
return $ID;
}
/**
* Put software in dustbin because it's been removed by GLPI software dictionnary
*
* @param $ID the ID of the software to put in dustbin
* @param $comment the comment to add to the already existing software's comment (default '')
*
* @return boolean (success)
**/
function putInTrash($ID, $comment='') {
global $CFG_GLPI;
$this->getFromDB($ID);
$input["id"] = $ID;
$input["is_deleted"] = 1;
//change category of the software on deletion (if defined in glpi_configs)
if (isset($CFG_GLPI["softwarecategories_id_ondelete"])
&& ($CFG_GLPI["softwarecategories_id_ondelete"] != 0)) {
$input["softwarecategories_id"] = $CFG_GLPI["softwarecategories_id_ondelete"];
}
//Add dictionnary comment to the current comment
$input["comment"] = (($this->fields["comment"] != '') ? "\n" : '') . $comment;
return $this->update($input);
}
/**
* Restore a software from dustbin
*
* @param $ID the ID of the software to put in dustbin
*
* @return boolean (success)
**/
function removeFromTrash($ID) {
$res = $this->restore(array("id" => $ID));
$softcatrule = new RuleSoftwareCategoryCollection();
$result = $softcatrule->processAllRules(null, null, $this->fields);
if (!empty($result)
&& isset($result['softwarecategories_id'])
&& ($result['softwarecategories_id'] != $this->fields['softwarecategories_id'])) {
$this->update(array('id' => $ID,
'softwarecategories_id' => $result['softwarecategories_id']));
}
return $res;
}
/**
* Show softwares candidates to be merged with the current
*
* @return nothing
**/
function showMergeCandidates() {
global $DB, $CFG_GLPI;
$ID = $this->getField('id');
$this->check($ID, UPDATE);
$rand = mt_rand();
echo "";
$sql = "SELECT `glpi_softwares`.`id`,
`glpi_softwares`.`name`,
`glpi_entities`.`completename` AS entity
FROM `glpi_softwares`
LEFT JOIN `glpi_entities` ON (`glpi_softwares`.`entities_id` = `glpi_entities`.`id`)
WHERE (`glpi_softwares`.`id` != '$ID'
AND `glpi_softwares`.`name` = '".addslashes($this->fields["name"])."'
AND `glpi_softwares`.`is_deleted` = '0'
AND `glpi_softwares`.`is_template` = '0' " .
getEntitiesRestrictRequest('AND', 'glpi_softwares','entities_id',
getSonsOf("glpi_entities",
$this->fields["entities_id"]),
false).")
ORDER BY `entity`";
$req = $DB->request($sql);
if ($nb = $req->numrows()) {
$link = Toolbox::getItemTypeFormURL('Software');
Html::openMassiveActionsForm('mass'.__CLASS__.$rand);
$massiveactionparams
= array('num_displayed' => min($_SESSION['glpilist_limit'], $nb),
'container' => 'mass'.__CLASS__.$rand,
'specific_actions'
=> array(__CLASS__.MassiveAction::CLASS_ACTION_SEPARATOR.'merge'
=> __('Merge')),
'item' => $this);
Html::showMassiveActions($massiveactionparams);
echo "
";
echo "| ";
echo Html::checkAllAsCheckbox('mass'.__CLASS__.$rand);
echo " | ";
echo "".__('Name')." | ";
echo "".__('Entity')." | ";
echo ""._n('Installation', 'Installations', Session::getPluralNumber())." | ";
echo ""._n('License', 'Licenses', Session::getPluralNumber())." |
|---|
";
foreach ($req as $data) {
echo "";
echo "| ".Html::getMassiveActionCheckBox(__CLASS__, $data["id"])." | ";
echo "".$data["name"]." | ";
echo "".$data["entity"]." | ";
echo "".Computer_SoftwareVersion::countForSoftware($data["id"])." | ";
echo "".SoftwareLicense::countForSoftware($data["id"])." |
\n";
}
echo "
\n";
$massiveactionparams['ontop'] =false;
Html::showMassiveActions($massiveactionparams);
Html::closeForm();
} else {
_e('No item found');
}
echo "
";
echo "
| ".__('Merging')." |
|---|
";
echo "| ";
Html::createProgressBar(__('Work in progress...'));
echo " |