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

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

$glpiid = $_SESSION['glpiID'];

global $DB;

$query = "SELECT name,FK_entities FROM glpi_profiles,glpi_users_profiles WHERE glpi_users_profiles.FK_users='" . $glpiid . "'

       AND glpi_users_profiles.FK_profiles=glpi_profiles.ID";

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

if($result) {

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

  if($data['name'] == "revendeur") {

    print "<h1>Liste synthétique de vos epacks</h1>";

    $entityid = $data['FK_entities'];

    print "<p>Liste des epacks attribués: <a href=\"" . $PHP_SELF . "\">Tous</a> - ";

    for($i=2008; $i <= date("Y"); $i++) {

        print "<a href=\"" . $PHP_SELF . "?year=$i\">$i</a> - ";

      }

    print "</p>";

//Les packs attribués

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

if($_GET['year'])

  $condition = "AND YEAR(creation_date)='" . $_GET['year'] . "'";

$query="SELECT e.*,g2.name as activation ,g3.name as client, g4.name as serveur FROM glpi_plugin_anet_epacks AS e

LEFT JOIN glpi_entities AS g2 ON FK_activation=g2.ID

LEFT JOIN glpi_entities AS g3 ON FK_client=g3.ID

LEFT JOIN glpi_computers AS g4 ON FK_serveur=g4.ID

WHERE creation_date>'0000-00-00'

AND e.FK_clientderyxeo='" . $entityid . "'

$condition

ORDER BY activation,creation_date

LIMIT 500;";

//print $query;

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

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

  print "<tr class='tab_bg_3'>

  <td>#</td>

  <td>Création</td>

  <td>Activation</td>

  <td>Activé par</td>

  <td>Expiration</td>

  <td>Client final</td>

  <td>Code</td>

  <td>Documents</td>

</tr>\n";

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

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

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

  print "  <td>". $i . "</td>

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

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

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

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

  <td>" . $data['client'] . "<br />Serveur <a href=\"../../manageentity/index.php?active_entity=" . $data['FK_enduser'] . "\">" . $data['serveur'] . "</a></td>

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

  <td>&nbsp;</td>

</tr>\n";

 }

print "</table>";

    commonFooter();

    exit;

  }

 }

checkRight("config","w");

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

//print "<p>Liste des epacks attribués: <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>";

 print "<p>Liste des epacks attribués: <a href=\"" . $PHP_SELF . "\">Tous</a> - ";

 for($i=2008; $i <= date("Y"); $i++) {

     print "<a href=\"" . $PHP_SELF . "?year=$i\">$i</a> - ";

   }

 print "</p>";

global $DB;

//Les packs attribués

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

if($_GET['year'])

  $condition = "AND YEAR(creation_date)='" . $_GET['year'] . "'";

$query="SELECT e.*,g.name as clientderyxeo ,g2.name as activation ,g3.name as client, g4.name as serveur FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID

LEFT JOIN glpi_entities AS g2 ON FK_activation=g2.ID

LEFT JOIN glpi_entities AS g3 ON FK_client=g3.ID

LEFT JOIN glpi_computers AS g4 ON FK_serveur=g4.ID

WHERE creation_date>'0000-00-00'

$condition

ORDER BY clientderyxeo,activation,creation_date

LIMIT 500;";

//print $query;

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

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

  print "<tr class='tab_bg_3'>

  <td>N°</td>

  <td>Nom</td>

  <td>Création</td>

  <td>Activation</td>

  <td>Activé par</td>

  <td>Expiration</td>

  <td>Client final</td>

  <td>Code</td>

  <td>Documents</td>

</tr>\n";

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

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

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

  print "  <td>" . ($i+1) . "</td>";

  print "  <td>" . $data['clientderyxeo'] . "</td>

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

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

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

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

  <td>" . $data['client'] . "<br />Serveur <a href=\"../../manageentity/index.php?active_entity=" . $data['FK_enduser'] . "\">" . $data['serveur'] . "</a></td>

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

  <td>\n";

  $ficepack="archives/" . $data['creation_date'] . "-" . $data['code'] . ".odt";

  if(!file_exists($ficepack))

    $ficepack="archives/" . str_replace("-","",$data['creation_date']) . "-" . $data['code'] . ".odt";

print "

    <a href=\"" . $ficepack . "\">ePack</a> (fichier initial) - <a href=\"plugin_anet_epacks.generate_odt_client2.form.php?code=" . $data['code'] . "\">Actualiser</a><br />

    <a href=\"plugin_anet_epacks.generate_odt_activated.form.php?date=" . $data['activation_date'] . "&code=" . $data['code'] . "\">ePack activé</a> (après activation) <br />

    <a href=\"plugin_anet_epacks.generate_odt_activated.form.php?date=" . $data['activation_date'] . "&code=" . $data['code'] . "&mode=-avenant_contrat_partenaire_enr2009\">ePack activé pour un partenaire ENR2009</a>

  </td>

</tr>\n";

 }

print "</table>";

print "<p>Liste des packs anonymes ...</p>\n";

//Les packs anonymes

$query="SELECT e.* FROM glpi_plugin_anet_epacks AS e 

WHERE creation_date>'0000-00-00'

AND FK_clientderyxeo='0'

$condition

LIMIT 500;";

//print $query;

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

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

  print "<tr class='tab_bg_3'>

  <td>N°</td>

  <td>Nom</td>

  <td>Date de création du pack</td>

  <td>Date d'activation du pack</td>

  <td>Activé par</td>

  <td>Date d'expiration du pack</td>

  <td>Client final</td>

  <td>Code</td>

  <td>Documents</td>

</tr>\n";

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

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

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

  print "  <td>" . ($i+1) . "</td>";

  print "  <td>" . $data['clientderyxeo'] . "</td>

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

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

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

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

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

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

  <td>

    <a href=\"archives/" . $data['creation_date'] . "-" . $data['code'] . ".odt\">ePack</a> (fichier initial)<br />

    <a href=\"plugin_anet_epacks.generate_odt_activated.form.php?date=" . $data['activation_date'] . "&code=" . $data['code'] . "\">ePack activé</a> (après activation)

  </td>

</tr>\n";

 }

print "</table>";

commonFooter();

?>