<?php
/*
 * @version $Id: dropdownInstallLicense.php 3798 2006-08-22 15:12:55Z moyo $
 -------------------------------------------------------------------------
 GLPI - Gestionnaire Libre de Parc Informatique
 Copyright (C) 2003-2006 by the INDEPNET Development Team.

 http://indepnet.net/   http://glpi-project.org
 -------------------------------------------------------------------------

 LICENSE

 This file is part of GLPI.

 GLPI is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.

 GLPI is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.

 You should have received a copy of the GNU General Public License
 along with GLPI; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 --------------------------------------------------------------------------
 */

// ----------------------------------------------------------------------
// Original Author of file: Julien Dombre
// Purpose of file:
// ----------------------------------------------------------------------


include ("_relpos.php");
$AJAX_INCLUDE=1;
$NEEDED_ITEMS=array("software","computer");
include ($phproot."/inc/includes.php");

header("Content-Type: text/html; charset=UTF-8");
header_nocache();

checkRight("software","w");

if ($_POST['sID']>0){
	// Make a select box

	$where="";
	if (!$_POST["massiveaction"]) $where=" glpi_inst_software.cID IS NULL OR ";
	$query = "SELECT DISTINCT glpi_licenses.* from glpi_licenses ";
	$query.= " LEFT JOIN glpi_inst_software on (glpi_licenses.ID=glpi_inst_software.license)";
	$query.= " WHERE glpi_licenses.sID='".$_POST['sID']."' AND ($where glpi_licenses.serial='free' OR glpi_licenses.serial='global' ) ";
	$query.= " order by serial ASC";


	$result = $db->query($query);
	echo "<select name=\"".$_POST['myname']."\" size='1'>";


	echo "<option value=\"0\">-----</option>";

	if ($number==0&&!isGlobalSoftware($_POST["sID"])&&!isFreeSoftware($_POST["sID"]))
		echo "<option value=\"-1\">--".$lang["software"][43]."--</option>";

	$today=date("Y-m-d"); 
	if ($db->numrows($result)) {
		while ($data = $db->fetch_assoc($result)) {

			$output = $data['serial']." - ";

			$expirer=0;
			if ($data['expire']!=NULL&&$today>$data['expire']) $expirer=1; 

			if ($data['expire']==NULL)
				$output.= $lang["software"][26];
			else {
				if ($expirer) $output.= $lang["software"][27];
				else $output.= $lang["software"][25]."&nbsp;".$data['expire'];
			}

			if ($data['buy']=='Y')
				$output.=" - ".$lang["software"][35];
			else 
				$output.=" - ".$lang["software"][37];

			if ($data['oem']=='Y'){
				$comp=new Computer();
				$comp->getFromDB($data["oem_computer"]);
				$output.=" - ".$lang["software"][28]. " ".$comp->fields['name'];
				if ($cfg_glpi["view_ID"]) $output.=" (".$comp->fields['ID'].")";
			}


			$ID = $data['ID'];
			if (empty($output)) $output="($ID)";
			echo "<option value=\"$ID\" title=\"$output\">".$output."</option>";
		}
	} 
	echo "</select>";

	if ($_POST["massiveaction"]) echo "<input type=\"submit\" name=\"massiveaction\" class=\"submit\" value=\"".$lang["buttons"][4]."\" >";
}

?>
