ryxeo-glpi-git / htdocs / ajax / dropdownUsersTracking.php @ 1c14bcc4
Historique | Voir | Annoter | Télécharger (3,9 ko)
1 | 1c14bcc4 | Eric Seigne | <?php
|
---|---|---|---|
2 | /*
|
||
3 | * @version $Id: dropdownUsersTracking.php 7763 2009-01-06 18:44:50Z moyo $
|
||
4 | -------------------------------------------------------------------------
|
||
5 | GLPI - Gestionnaire Libre de Parc Informatique
|
||
6 | Copyright (C) 2003-2009 by the INDEPNET Development Team.
|
||
7 | |||
8 | http://indepnet.net/ http://glpi-project.org
|
||
9 | -------------------------------------------------------------------------
|
||
10 | |||
11 | LICENSE
|
||
12 | |||
13 | This file is part of GLPI.
|
||
14 | |||
15 | GLPI is free software; you can redistribute it and/or modify
|
||
16 | it under the terms of the GNU General Public License as published by
|
||
17 | the Free Software Foundation; either version 2 of the License, or
|
||
18 | (at your option) any later version.
|
||
19 | |||
20 | GLPI is distributed in the hope that it will be useful,
|
||
21 | but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
22 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
23 | GNU General Public License for more details.
|
||
24 | |||
25 | You should have received a copy of the GNU General Public License
|
||
26 | along with GLPI; if not, write to the Free Software
|
||
27 | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
||
28 | --------------------------------------------------------------------------
|
||
29 | */
|
||
30 | |||
31 | // ----------------------------------------------------------------------
|
||
32 | // Original Author of file: Julien Dombre
|
||
33 | // Purpose of file:
|
||
34 | // ----------------------------------------------------------------------
|
||
35 | |||
36 | if(ereg("dropdownUsersTracking.php",$_SERVER['PHP_SELF'])){ |
||
37 | define('GLPI_ROOT','..'); |
||
38 | $AJAX_INCLUDE=1; |
||
39 | include (GLPI_ROOT."/inc/includes.php"); |
||
40 | header("Content-Type: text/html; charset=UTF-8"); |
||
41 | header_nocache(); |
||
42 | |||
43 | } |
||
44 | if (!defined('GLPI_ROOT')){ |
||
45 | die("Can not acces directly to this file"); |
||
46 | } |
||
47 | |||
48 | checkCentralAccess(); |
||
49 | |||
50 | // Make a select box with all glpi users
|
||
51 | |||
52 | $where=" glpi_users.deleted='0' AND glpi_users.active='1' "; |
||
53 | if (strlen($_POST['searchText'])>0&&$_POST['searchText']!=$CFG_GLPI["ajax_wildcard"]){ |
||
54 | $where.=" AND (glpi_users.name ".makeTextSearch($_POST['searchText'])." OR glpi_users.realname ".makeTextSearch($_POST['searchText'])." OR glpi_users.firstname ".makeTextSearch($_POST['searchText']).")"; |
||
55 | } |
||
56 | |||
57 | $NBMAX=$CFG_GLPI["dropdown_max"]; |
||
58 | $LIMIT="LIMIT 0,$NBMAX"; |
||
59 | if ($_POST['searchText']==$CFG_GLPI["ajax_wildcard"]) $LIMIT=""; |
||
60 | |||
61 | $query = "SELECT glpi_users.ID, glpi_users.name, glpi_users.realname, glpi_users.firstname FROM glpi_users WHERE $where AND ID IN (SELECT DISTINCT ".$_POST['field']." FROM glpi_tracking ".getEntitiesRestrictRequest("WHERE","glpi_tracking").") "; |
||
62 | |||
63 | $query.=" ORDER BY glpi_users.realname,glpi_users.firstname,glpi_users.name $LIMIT"; |
||
64 | |||
65 | $result = $DB->query($query); |
||
66 | |||
67 | $users=array(); |
||
68 | if ($DB->numrows($result)) { |
||
69 | while ($data=$DB->fetch_array($result)) { |
||
70 | $users[$data["ID"]]=formatUserName($data["ID"],$data["name"],$data["realname"],$data["firstname"]); |
||
71 | $logins[$data["ID"]]=$data["name"]; |
||
72 | } |
||
73 | } |
||
74 | |||
75 | asort($users); |
||
76 | |||
77 | echo "<select id='dropdown_".$_POST["myname"].$_POST["rand"]."' name=\"".$_POST['myname']."\">"; |
||
78 | |||
79 | if ($_POST['searchText']!=$CFG_GLPI["ajax_wildcard"]&&$DB->numrows($result)==$NBMAX) |
||
80 | echo "<option value=\"0\">--".$LANG["common"][11]."--</option>"; |
||
81 | |||
82 | echo "<option value=\"0\">[ ".$LANG["common"][66]." ]</option>"; |
||
83 | |||
84 | if (isset($_POST['value'])){ |
||
85 | $output=getUserName($_POST['value']); |
||
86 | if (!empty($output)&&$output!=" ") |
||
87 | echo "<option selected value='".$_POST['value']."' title=\"".cleanInputText($output)."\">".substr($output,0,$CFG_GLPI["dropdown_limit"])."</option>"; |
||
88 | } |
||
89 | |||
90 | if (count($users)) { |
||
91 | foreach ($users as $ID => $output){ |
||
92 | |||
93 | echo "<option value=\"".$ID."\" ".($ID == $_POST['value']?"selected":"")." title=\"".cleanInputText($output)."\">".substr($output,0,$CFG_GLPI["dropdown_limit"])."</option>"; |
||
94 | } |
||
95 | } |
||
96 | echo "</select>"; |
||
97 | |||
98 | if (isset($_POST["comments"])&&$_POST["comments"]){ |
||
99 | $params=array('value'=>'__VALUE__','table'=>'glpi_users'); |
||
100 | ajaxUpdateItemOnSelectEvent("dropdown_".$_POST["myname"].$_POST["rand"],"comments_".$_POST["myname"].$_POST["rand"],$CFG_GLPI["root_doc"]."/ajax/comments.php",$params,false); |
||
101 | } |
||
102 | |||
103 | ?> |