RyXéo » GLPI

<?php

// Récap mensuel de tout serveur affecté à un revendeur ...

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 "<h1>Relevé mensuel de " . $_GET['year'] . "-" . $_GET['month']  . "</h1>";

print "<p>Récapitulatif pour la période : <a href=\"" . $PHP_SELF . "\">Tous</a> - <a href=\"" . $PHP_SELF . "?year=2009&month=12\">Déc. 2009</a> - <a href=\"" . $PHP_SELF . "?year=2010&month=01\">Jan 2010</a> - <a href=\"" . $PHP_SELF . "?year=2010&month=02\">Fev 2010</a> - <a href=\"" . $PHP_SELF . "?year=2010&month=03\">Mars 2010</a>.</p>";

global $DB;

function rvd_get_details($id) {

  global $DB;

  //Les détails pour ce revendeur: tous les epacks avec la date d'activation, le code du epack et le nom du client

  $query2="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 FK_clientderyxeo='" . $id . "'

AND FK_contract>='0'

ORDER BY activation_date";

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

  //La liste des epacks clairement hors maintenance

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

  $txt .= "<tr class='tab_bg_3'>

  <td>Création</td>

  <td>Activation</td>

  <td>Activé par</td>

  <td>Client final</td>

  <td>ePack</td>

</tr>\n";

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

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

    $txt .= "<tr class='tab_bg_3'>\n";

    $txt .= "  <td>" . $data2['creation_date'] . "</td>

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

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

  <td>" . $data2['client'] . " (" . $data2['serveur'] . ")</td>

  <td>" . $data2['code'] . "<br><br></td>

</tr>\n";

    unset($data2);

  }

  $txt .= "<tr class='tab_bg_3'>

  <td colspan=\"6\"><br />Nombre total de packs: " . $i . "<br /></td>

</tr>\n";

  $txt .= "</table>";

 return $txt;

}

//Le tableau global pour avoir la liste des revendeurs

//parentid=3 -> c'est l'entité "partenaires"

$query = "SELECT e.FK_clientderyxeo,g.name as clientderyxeo FROM glpi_plugin_anet_epacks AS e LEFT JOIN glpi_entities AS g ON FK_clientderyxeo=g.ID WHERE parentID='3' GROUP BY FK_clientderyxeo";

$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>Nom</td>

  <td>Détails</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>" . $data['clientderyxeo'] . " </td>

  <td>" . rvd_get_details($data['FK_clientderyxeo']) . "</td>

  <td>" . $documents . "<br><br></td>

</tr>\n";

  unset($data);

 }

print "<tr class='tab_bg_3'>

  <td colspan=\"3\"><br />Nombre total de revendeurs: " . $i . "<br /></td>

</tr>\n";

print "</table>";

//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'] . "'";

if($_GET['month'])

  $condition = "AND MONTH(creation_date)='" . $_GET['month'] . "'";

$query="SELECT e.*,g.name as clientderyxeo ,g2.name as activation ,g3.name as client 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

WHERE creation_date>'0000-00-00'

$condition

ORDER BY clientderyxeo,activation,creation_date

LIMIT 500;";

//print $query;

commonFooter();

?>