RyXéo » GLPI

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";

   }

 }