RyXéo » GLPI

<?php

  /* Permet de faire une recherche rapide pour ryxeo-erp ... */

if(!defined('GLPI_ROOT')){

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

 }

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

commonHeader("AbulEdu.NET -- Recherche rapide -- Accueil RyXéo",$_SERVER['PHP_SELF'],"config","plugins");

$glpiid = $_SESSION['glpiID'];

global $DB;

$query = "SELECT glpi_profiles.name AS name,glpi_users_profiles.FK_entities as FK_entities FROM glpi_profiles,glpi_users_profiles,glpi_users WHERE glpi_users_profiles.FK_users='" . $glpiid . "' AND glpi_users_profiles.FK_profiles=glpi_profiles.ID GROUP BY FK_entities";

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

if($result) {

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

    $entityid = $data['FK_entities'];

    if($data['name'] == "super-admin") {

      //print $query;

      $entityid = $data['FK_entities'];

      $recherche = addslashes($_GET['search']);

      //Recherche (1) dans les codes epacks

      $query2 = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_contracts AS g6 ON e.FK_contract=g6.ID

LEFT JOIN glpi_entities AS g7 ON e.FK_clientderyxeo=g7.ID

WHERE e.code LIKE '%$recherche%'

GROUP BY e.FK_serveur";

      $result2 = $DB->query($query2);

      if($result2) {

	$data2=$DB->fetch_array($result2);

	if($data2) {

	  //On saute directement c'est que c'est le bon

	  $txt .= "<a href=\"../../manageentity/index.php?active_entity=" . $data2['entityid'] . "\">" . $data2['client'] . ": " . $data2['serveur'] . "</a><br />\n";

	}

      }

      //print "$query2<br />";

      //Recherche dans les noms des entites

      $query3 = "SELECT e.*, e.FK_enduser as entityid, g3.name as client, g4.name as serveur

FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_entities AS g3 ON (e.FK_client=g3.ID OR e.FK_enduser=g3.ID)

LEFT JOIN glpi_computers AS g4 ON e.FK_serveur=g4.ID

LEFT JOIN glpi_contracts AS g6 ON e.FK_contract=g6.ID

LEFT JOIN glpi_entities AS g7 ON e.FK_clientderyxeo=g7.ID

WHERE g3.name LIKE '%$recherche%'

GROUP BY e.FK_serveur";

      $result3 = $DB->query($query3);

      if($result3) {

	$data3=$DB->fetch_array($result3);

	if($data3) {

	  //On saute directement c'est que c'est le bon

	  $txt .= "<a href=\"../../manageentity/index.php?active_entity=" . $data3['entityid'] . "\">" . $data3['client'] . ": " . $data3['serveur'] . "</a> <br />\n";

	}

      }

      //print $query2;

    }

  }

  print "<h1>Résultat de la recherche</h1>";

  print $txt;

 }  

commonFooter();

?>