RyXéo » GLPI

<?php

/*

 * @version $Id: dropdownConnectPortDevice.php 7763 2009-01-06 18:44:50Z moyo $

 -------------------------------------------------------------------------

 GLPI - Gestionnaire Libre de Parc Informatique

 Copyright (C) 2003-2009 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:

// ----------------------------------------------------------------------

define('GLPI_ROOT','..');

$AJAX_INCLUDE=1;

include (GLPI_ROOT."/inc/includes.php");

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

header_nocache();

checkRight("networking","w");

if (isset($LINK_ID_TABLE[$_POST["type"]])&&$_POST["type"]>0){

        $table=$LINK_ID_TABLE[$_POST["type"]];

        $rand=mt_rand();

        if (!isset($_POST['searchText']))$_POST['searchText']="";

        $where="WHERE deleted=0 ";

        $where.=" AND is_template='0' ";                

        if (isset($_POST["entity_restrict"])&&$_POST["entity_restrict"]>=0){

                $where.= " AND $table.FK_entities='".$_POST["entity_restrict"]."'";

        } else {

                $where.=getEntitiesRestrictRequest("AND",$table);

        }

        if (strlen($_POST['searchText'])>0&&$_POST['searchText']!=$CFG_GLPI["ajax_wildcard"])

                $where.=" AND name ".makeTextSearch($_POST['searchText'])." ";

        $NBMAX=$CFG_GLPI["dropdown_max"];

        $LIMIT="LIMIT 0,$NBMAX";

        if ($_POST['searchText']==$CFG_GLPI["ajax_wildcard"]) $LIMIT="";

        $query = "SELECT * FROM ".$table." $where ORDER BY name $LIMIT";

        $result = $DB->query($query);

        echo "<select id='item$rand' name=\"item\" size='1'>";

        if ($_POST['searchText']!=$CFG_GLPI["ajax_wildcard"]&&$DB->numrows($result)==$NBMAX)

                echo "<option value=\"0\">--".$LANG["common"][11]."--</option>";

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

        if ($DB->numrows($result)) {

                while ($data = $DB->fetch_array($result)) {

                        $output = $data['name'];

                        $ID = $data['ID'];

                        if (empty($output)) $output="($ID)";

                        echo "<option value=\"$ID\" title=\"".cleanInputText($output)."\">".substr($output,0,$CFG_GLPI["dropdown_limit"])."</option>";

                }

        }

        echo "</select>";

        $params=array('item'=>'__VALUE__',

                        'type'=>$_POST['type'],

                        'current'=>$_POST['current'],

                        'myname'=>$_POST["myname"],

                        );

        ajaxUpdateItemOnSelectEvent("item$rand","results_item_$rand",$CFG_GLPI["root_doc"]."/ajax/dropdownConnectPort.php",$params);

        echo "<span id='results_item_$rand'>\n";

        echo "</span>\n";        

}                

?>