RyXéo » GLPI

<?php

// Génère le fichier ODT/PDF pour le revendeur avec son numéro de pack à utiliser. Ce fichier doit contenir un certain nombre d'informations (url pour enregistrer son pack etc.)

if(!defined('GLPI_ROOT')){

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

}

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

checkRight("config","w");

//checkSeveralRightsOr(array("config" => "w", "profile" => "w"));

commonHeader("anet_epacks",$_SERVER['PHP_SELF'],"config","plugins");

print "<p>Liste : <a href=\"" . $PHP_SELF . "\">Tous</a> - <a href=\"" . $PHP_SELF . "?year=2008\">2008</a> - <a href=\"" . $PHP_SELF . "?year=2009\">2009</a> - <a href=\"" . $PHP_SELF . "?year=2010\">2010</a> - <a href=\"" . $PHP_SELF . "?year=2011\">2011</a>.</p>";

global $DB;

if($_GET['year'])

  $condition = "AND `begin_date`+INTERVAL `duration` MONTH < '" . $_GET['year'] . "-12-31' AND `begin_date`+INTERVAL `duration` MONTH > '" . $_GET['year'] . "-01-01'";

//Les contrats attribués

//Permet de limiter un peu l'affichage, il faudra faire un système de recherche ou pagination à terme

$query = "SELECT c.*,`begin_date`+INTERVAL `duration` MONTH as endcontract FROM glpi_plugin_anet_epacks

 LEFT JOIN glpi_contracts AS c ON FK_contract=c.ID

 WHERE FK_contract > 0 $condition GROUP BY FK_contract";

//print $query;

//$DB->query($query) or die($DB->error());

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

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

print "<tr class='tab_bg_3'>

  <td>Client</td>

  <td>Nom du contrat</td>

  <td>Numéro</td>

  <td>Coût</td>

  <td>Début / Fin</td>

  <td>Durée (mois)</td>

  <td>ePacks concernés</td>

  <td>Documents</td>

</tr>\n";

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

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

  $query2="SELECT g.name as clientderyxeo FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID

LEFT JOIN glpi_contracts AS c ON FK_contract=c.ID

WHERE FK_contract= '" . $data['ID'] . "'";

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

  //$DB->query($query) or die($DB->error());

  $epacks = "";

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

  for($j = 0; $j < $DB->numrows($result2); $j++) {

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

    $epacks .= $data2['code'] . "<br />";

  }

  $query3="SELECT e.*,g.name as enduser FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_enduser=g.ID

LEFT JOIN glpi_contracts AS c ON FK_contract=c.ID

WHERE FK_enduser= '" . $data['FK_entities'] . "'

LIMIT 500;";

  //print $query3 . "<br />" . "<br />";

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

  $enduser = "  ";

  for($j = 0; $j < $DB->numrows($result3); $j++) {

    if($j>0)

      $enduser .= " :: ";

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

    $enduser .= stripslashes($data3['enduser']);

  }

  print "<tr class='tab_bg_3'>\n";

  print "  <td>" . $data2['clientderyxeo'] . " <br /> " . $enduser . "</td>

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

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

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

  <td>" . $data['begin_date'] . " <br /> " . $data['endcontract'] . "</td>

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

  <td>" . $epacks . "</td>\n";

  print "  <td>

    <a href=\"plugin_anet_epacks.generate_odt_courrier_end_contract.form.php?clientid=" . $data['FK_entities'] . "&cid=" . $data['ID'] . "&niveau=courrier_endcontract\">Courrier de fin de maintenance</a><br />

  </td>

</tr>\n";

}

print "</table>";

commonFooter();

?>