RyXéo » GLPI

<?php

/*

 * @version $Id: dropdownDocument.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:

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

// Direct access to file

if(ereg("dropdownDocument.php",$_SERVER['PHP_SELF'])){

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

        $AJAX_INCLUDE=1;

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

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

        header_nocache();

}

if (!defined('GLPI_ROOT')){

        die("Can not acces directly to this file");

        }

checkCentralAccess();

// Make a select box with all glpi users

$where=" WHERE  (glpi_docs.rubrique = '".$_POST['rubdoc']."' AND glpi_docs.deleted='0' ) ";

if (isset($_POST["entity_restrict"])){

        $where.=getEntitiesRestrictRequest("AND","glpi_docs",'',$_POST["entity_restrict"],true);

} else {

        $where.=getEntitiesRestrictRequest("AND","glpi_docs",'','',true);

}

if (isset($_POST['used'])) {

        $where .=" AND ID NOT IN (0";

        if (is_array($_POST['used'])) {

                        $used=$_POST['used'];

                } else {

                        $used=unserialize(stripslashes($_POST['used']));

                }

        foreach($used as $val)

                $where .= ",$val";

        $where .= ") ";

}

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

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

$NBMAX=$CFG_GLPI["dropdown_max"];

$LIMIT="LIMIT 0,$NBMAX";

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

$query = "SELECT * FROM glpi_docs $where ORDER BY FK_entities, name $LIMIT";

//error_log($query);

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

echo "<select name=\"".$_POST['myname']."\">";

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

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

        $prev=-1;

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

                if ($data["FK_entities"]!=$prev) {

                        if ($prev>=0) {

                                echo "</optgroup>";

                        }

                        $prev=$data["FK_entities"];

                        echo "<optgroup label=\"". getDropdownName("glpi_entities", $prev) ."\">";

                }

                $output = $data["name"];

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

        }

        if ($prev>=0) {

                echo "</optgroup>";

        }

}

echo "</select>";

?>