RyXéo » GLPI

<?php

/*

  Special AbulEdu ...

 */

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

// Original Author of file:

// Purpose of file:

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

$NEEDED_ITEMS=array("user","document","knowbase");

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

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

// Redirect management

if (isset($_GET["redirect"])){

        manageRedirect($_GET["redirect"]);

}

//*******************

// Affichage Module FAQ

//******************

if (isset($_SESSION["glpiID"])){

  helpHeader($LANG["Menu"][20],$_SERVER['PHP_SELF'],$_SESSION["glpiname"]);

 } else {

  $_SESSION["glpilanguage"]=$CFG_GLPI['default_language'];

  // Anonymous FAQ

  simpleHeader($LANG["Menu"][20],array($LANG["Menu"][20]=>$_SERVER['PHP_SELF']));

 }

print "

<h1>" . ereg_replace("\(arborescence\)","",$_SESSION['glpiactive_entity_shortname']) . "</h1>

<p>Vous êtes maintenant connecté(e) sur notre plate-forme de gestion abuledu.net. Vous pouvez, en cliquant dans le menu de gauche, suivre les interventions en cours sur votre serveur ou nous demander d'intervenir pour un nouveau problème.</p>

<p>Si vous voulez changer votre mot de passe, cliquez sur le lien \"Préférences\" du menu \"Connexion\" et mettez votre nouveau mot de passe dans le champ \"password\".</p>

<h2>Votre serveur / Votre installation</h2>

";

//Les images / photos prises de cette installation ...

//le bug c'est qu'on a aussi les images jointes aux tickets !!!

$query = "SELECT glpi_docs.FK_entities, glpi_docs.recursive,

  glpi_docs.name AS name,

  glpi_docs.filename AS filename,

  glpi_docs.mime AS mimetype,

  glpi_docs.ID AS ID,

  glpi_docs.comments AS comments

FROM glpi_docs

  LEFT JOIN glpi_entities ON (glpi_docs.FK_entities = glpi_entities.ID)

  LEFT JOIN glpi_dropdown_rubdocs ON (glpi_docs.rubrique = glpi_dropdown_rubdocs.ID)

WHERE

  glpi_docs.mime LIKE '%image%' AND

  glpi_docs.name NOT LIKE '%Ticket%' AND

  glpi_docs.deleted='0' AND ( glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ") OR ( glpi_docs.recursive='1' AND glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ")) ) ORDER BY glpi_docs.name";

$result = $DB->query($query) or die($DB->error());

//print $query;

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

  print "<p>Aucune information disponible ...</p>";

 }

 else {

   for($i = 0; $i < $DB->numrows($result); $i++) {

     $data=$DB->fetch_array($result);

     print "<img title='" . addslashes($data['ame']) . "' alt='" . addslashes($data['ame']) . "' src='document.abuledu_view.php?file=" . $data['filename'] . "'>\n";

     print "<p>" . $data['comments'] . "</p>\n";

   }

 }

print " <h2>Votre parc informatique</h2>

";

//print_r($_SESSION);

//L'inventaire du parc ... en résumé l'essentiel

$query = "SELECT

  glpi_computers.name AS name,

  glpi_dropdown_manufacturer.name AS manufacturer,

  glpi_computers.serial AS serialnumber,

  glpi_type_computers.name AS typepc,

  glpi_dropdown_model.name AS serialtype,

  glpi_device_processor.designation AS processor,

  SUM(DEVICE_2.specificity) / COUNT( DEVICE_2.ID) AS processorfreq,

  SUM(DEVICE_3.specificity) / COUNT( DEVICE_3.ID) * COUNT( DISTINCT DEVICE_3.ID) AS memory,

  glpi_computers.date_mod AS dateinventaire

FROM glpi_computers

  LEFT JOIN glpi_entities ON (glpi_computers.FK_entities = glpi_entities.ID)

  LEFT JOIN glpi_dropdown_state ON (glpi_computers.state = glpi_dropdown_state.ID)

  LEFT JOIN glpi_dropdown_manufacturer ON (glpi_computers.FK_glpi_enterprise = glpi_dropdown_manufacturer.ID)

  LEFT JOIN glpi_type_computers ON (glpi_computers.type = glpi_type_computers.ID)

  LEFT JOIN glpi_dropdown_model ON (glpi_computers.model = glpi_dropdown_model.ID)

  LEFT JOIN glpi_computer_device AS DEVICE_2 ON (glpi_computers.ID = DEVICE_2.FK_computers AND DEVICE_2.device_type='2')

  LEFT JOIN glpi_device_processor ON (DEVICE_2.FK_device = glpi_device_processor.ID)

  LEFT JOIN glpi_dropdown_locations ON (glpi_computers.location = glpi_dropdown_locations.ID)

  LEFT JOIN glpi_computer_device AS DEVICE_3 ON (glpi_computers.ID = DEVICE_3.FK_computers AND DEVICE_3.device_type='3')

  LEFT JOIN glpi_device_ram ON (DEVICE_3.FK_device = glpi_device_ram.ID)

WHERE glpi_computers.FK_entities='" . $_SESSION['glpiactive_entity'] . "' AND glpi_computers.deleted='0' AND glpi_computers.is_template='0' GROUP BY glpi_computers.ID ORDER BY name ASC";

$result = $DB->query($query) or die($DB->error());

//print $query;

print "<table class='tab_cadre' width='100%' cellpadding='2'>\n";

  print "<tr class='tab_bg_4'>

  <td>Nom</td>

  <td>Fabriquant</td>

  <td>Modèle</td>

  <td>Numéro de série</td>

  <td>Type</td>

  <td>CPU</td>

  <td>Fréquence CPU</td>

  <td>RAM</td>

  <td>Date d'inventaire</td>

</tr>\n";

for($i = 0; $i < $DB->numrows($result); $i++) {

  $data=$DB->fetch_array($result);

  print "<tr class='tab_bg_" . ($i%2?"2":"5") . "'>

  <td>" . $data['name'] . "</td>

  <td>" . $data['manufacturer'] . "</td>

  <td>" . $data['serialtype'] . "</td>

  <td>" . $data['serialnumber'] . "</td>

  <td>" . $data['typepc'] . "</td>

  <td>" . $data['processor'] . "</td>

  <td>" . $data['processorfreq'] . "</td>

  <td>" . $data['memory'] . "</td>

  <td>" . $data['dateinventaire'] . "</td>

</tr>\n";

}

print "</table>";

print "<h2>Votre cahier de recette</h2>";

$query = "SELECT glpi_docs.FK_entities, glpi_docs.recursive,

  glpi_docs.name AS name,

  glpi_docs.filename AS filename,

  glpi_docs.mime AS mimetype,

  glpi_docs.ID AS ID,

  glpi_docs.comments AS comments

FROM glpi_docs

  LEFT JOIN glpi_entities ON (glpi_docs.FK_entities = glpi_entities.ID)

  LEFT JOIN glpi_dropdown_rubdocs ON (glpi_docs.rubrique = glpi_dropdown_rubdocs.ID)

WHERE

  glpi_docs.filename LIKE '%recette%' AND

  glpi_docs.deleted='0' AND ( glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ") OR ( glpi_docs.recursive='1' AND glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ")) ) ORDER BY glpi_docs.name";

$result = $DB->query($query) or die($DB->error());

//print $query;

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

  print "<p>Aucune information disponible ...</p>";

 }

 else {

   for($i = 0; $i < $DB->numrows($result); $i++) {

     $data=$DB->fetch_array($result);

     print "<p>Vous pouvez télécharger votre cahier de recette: <a href='document.abuledu_view.php?file=" . $data['filename'] . "'>" . $data['filename'] . "</a></p>\n";

   }

 }

print "<h2>Votre contrat de maintenance</h2>";

$query = "SELECT glpi_docs.FK_entities, glpi_docs.recursive,

  glpi_docs.name AS name,

  glpi_docs.filename AS filename,

  glpi_docs.mime AS mimetype,

  glpi_docs.ID AS ID,

  glpi_docs.comments AS comments

FROM glpi_docs

  LEFT JOIN glpi_entities ON (glpi_docs.FK_entities = glpi_entities.ID)

  LEFT JOIN glpi_dropdown_rubdocs ON (glpi_docs.rubrique = glpi_dropdown_rubdocs.ID)

WHERE

  glpi_docs.filename LIKE '%contrat%' AND

  glpi_docs.deleted='0' AND ( glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ") OR ( glpi_docs.recursive='1' AND glpi_docs.FK_entities IN (" . $_SESSION['glpiactive_entity'] . ")) ) ORDER BY glpi_docs.name";

$result = $DB->query($query) or die($DB->error());

//print $query;

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

  print "<p>Aucune information disponible ...</p>";

 }

 else {

   for($i = 0; $i < $DB->numrows($result); $i++) {

     $data=$DB->fetch_array($result);

     print "<p>Vous pouvez télécharger votre contrat de maintenance: <a href='document.abuledu_view.php?file=" . $data['filename'] . "'>" . $data['filename'] . "</a></p>\n";

   }

 }

helpFooter();

?>