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

//Les dates en francais svp

setlocale(LC_TIME, "fr_FR");

checkRight("config","w");

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

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

print "<h1>Création du relevé mensuel</h1>";

$choix = "";

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

  for($j = 1; $j < 13; $j++) {

    $choix .= "<a href=\"" . $PHP_SELF . "?year=$i&month=$j\">$j/$i</a> :: ";

  }

 }

print "<p>Choix de la période : $choix</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 activation_date>'2009-01-01'

AND activation_date<'" . $_GET['year'] . "-" . $_GET['month'] . "-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 width='100%' cellpadding='2'>\n";

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

  <td>Créat. / Activat.</td>

  <td>Activé</td>

  <td>Client</td>

  <td>ePack</td>

  <td>Maintenance</td>

</tr style=\"border-bottom: 1px solid black;\">\n";

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

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

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

    $txt .= "  <td style=\"text-align:left\" nowrap>Cré: " . strftime("%d/%m/%Y", strtotime($data2['creation_date'])) . "<br />Act: " . strftime("%d/%m/%Y", strtotime($data2['activation_date'])) . "</td>

  <td valign=\"top\">" . $data2['activation'] . "</td>

  <td valign=\"top\">" . $data2['client'] . " (" . $data2['serveur'] . ")</td>

  <td valign=\"top\" nowrap>" . $data2['code'] . "</td>

  <td nowrap></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>";

  if($i == 0)

    unset($txt);

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

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

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

  /*

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

   print "<tr class='tab_bg_3'>

   <td>Nom</td>

   <td>Détails</td>

   </tr>\n";

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

  print "  <td valign=\"top\">" . $data['clientderyxeo'] . " </td>

  <td valign=\"top\">" . rvd_get_details($data['FK_clientderyxeo']) . "</td>

</tr>\n";

  */

  $txt = rvd_get_details($data['FK_clientderyxeo']);

  if($txt != "") {

    print "<p style=\"page-break-after: always\">&nbsp;</p>\n";

    print "  <h2 style=\"text-align: left\"> Relevé mensuel (" . strftime("%B", strtotime($_GET['year'] . "/" . $_GET['month'] . "/01")) . " " . $_GET['year']  . ") pour " . $data['clientderyxeo'] . " </h2>";

    print $txt;

    unset($data);

  }

  /*

  print "</table>";

  */

 }

/*

print "<p style=\"page-break-after: always\">&nbsp;</p>\n";

print "  <h2 style=\"text-align: left\"> Synthèse du relevé mensuel de " . $_GET['month'] . "/" . $_GET['year']  . "</h2>";

print "<table>

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

?>