ryxeo-glpi-git / ajax / dropdownConnectPort.php @ b67d8923
Historique | Voir | Annoter | Télécharger (3,44 ko)
1 | b67d8923 | Eric Seigne | <?php
|
---|---|---|---|
2 | /*
|
||
3 | * @version $Id: dropdownConnectPort.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 | define('GLPI_ROOT','..'); |
||
37 | include (GLPI_ROOT."/inc/includes.php"); |
||
38 | $AJAX_INCLUDE=1; |
||
39 | header("Content-Type: text/html; charset=UTF-8"); |
||
40 | header_nocache(); |
||
41 | |||
42 | checkRight("networking","w"); |
||
43 | |||
44 | // Make a select box
|
||
45 | |||
46 | if (isset($LINK_ID_TABLE[$_POST["type"]])&&isset($_POST["item"])){ |
||
47 | |||
48 | $table=$LINK_ID_TABLE[$_POST["type"]]; |
||
49 | |||
50 | $where=""; |
||
51 | $where.=" AND $table.deleted=0 "; |
||
52 | $where.=" AND $table.is_template='0' "; |
||
53 | |||
54 | $query = "SELECT DISTINCT glpi_networking_wire.ID as WID, glpi_networking_ports.ID as DID, $table.name as CNAME, glpi_networking_ports.name as NNAME, glpi_networking_ports.ifaddr as IP, glpi_networking_ports.ifmac as MAC"; |
||
55 | $query.= " FROM $table "; |
||
56 | $query.= " LEFT JOIN glpi_networking_ports ON (glpi_networking_ports.on_device='".$_POST['item']."' AND glpi_networking_ports.device_type='".$_POST["type"]."' AND glpi_networking_ports.on_device=$table.ID) "; |
||
57 | $query.= " LEFT JOIN glpi_networking_wire ON (glpi_networking_wire.end1=glpi_networking_ports.ID OR glpi_networking_wire.end2=glpi_networking_ports.ID)"; |
||
58 | $query.= " WHERE glpi_networking_wire.ID IS NULL AND glpi_networking_ports.ID IS NOT NULL AND glpi_networking_ports.ID <> '".$_POST['current']."' "; |
||
59 | $query.= $where; |
||
60 | $query.= " ORDER BY glpi_networking_ports.ID"; |
||
61 | $result = $DB->query($query); |
||
62 | echo "<br>"; |
||
63 | echo "<select name=\"".$_POST['myname']."[".$_POST["current"]."]\" size='1'>"; |
||
64 | |||
65 | echo "<option value=\"0\">-----</option>"; |
||
66 | if ($DB->numrows($result)) { |
||
67 | while ($data = $DB->fetch_array($result)) { |
||
68 | $output = $data['CNAME']; |
||
69 | $output_long=""; |
||
70 | if (!empty($data['IP'])) $output.= " - ".$data['IP']; |
||
71 | if (!empty($data['MAC'])) $output_long.= " - ".$data['MAC']; |
||
72 | if (!empty($data['NNAME'])) $output_long.= substr(" - ".$data['NNAME'],0,$CFG_GLPI["dropdown_limit"]); |
||
73 | $ID = $data['DID']; |
||
74 | if (empty($data["IP"])) { |
||
75 | $output.=$output_long; |
||
76 | $output_long=""; |
||
77 | } |
||
78 | if (empty($output)) $output="($ID)"; |
||
79 | echo "<option value=\"$ID\" title=\"".cleanInputText($output.$output_long)."\">".$output."</option>"; |
||
80 | } |
||
81 | } |
||
82 | echo "</select>"; |
||
83 | |||
84 | echo "<input type='submit' name='connect' value=\"".$LANG["buttons"][9]."\" class='submit'>"; |
||
85 | } |
||
86 | |||
87 | ?> |