RyXéo » GLPI

<?php

if(!defined('GLPI_ROOT')){

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

}

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

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

$glpiid = $_SESSION['glpiID'];

print "<h1>Liste des migrations de serveurs</h1>";

function local_make_array_header() {

  return   "<table style=\"width:100%; padding: 0 10px 0 10px;\">

<tr class='tab_bg_2'>

  <th>Nom / epack</th>

  <th>Date</th>

  <th>Étape</th>

  <th>Message</th>

</tr>\n";

}

function local_make_array_footer() {

  $s .= "</table>";

  return $s;

}

commonHeader("AbulEdu.NET -- Tableau récapitulatif -- Accueil RyXéo",$_SERVER['PHP_SELF'],"config","plugins");

$glpiid = $_SESSION['glpiID'];

global $DB;

$query = "SELECT glpi_profiles.name AS name,glpi_users_profiles.FK_entities as FK_entities FROM glpi_profiles,glpi_users_profiles,glpi_users WHERE glpi_users_profiles.FK_users='" . $glpiid . "' AND glpi_users_profiles.FK_profiles=glpi_profiles.ID GROUP BY FK_entities";

//print $query;

//exit;

$tab_deja_affiche         = array();

$num_debut_ligne_maint    = 0;

$num_debut_ligne_horsmaint = 0;

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

if($result) {

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

  //print_r($data);

  $entityid = $data['FK_entities'];

  print local_make_array_header();

  $query2 = "SELECT m.*,e.code FROM glpi_plugin_anet_migration as m

LEFT JOIN glpi_plugin_anet_epacks as e ON e.id=FK_epack

WHERE (e.FK_clientderyxeo='" . $entityid . "' OR e.FK_activation='" . $entityid . "')

GROUP BY FK_epack,etape

ORDER BY ladate,etape";

  //print $query2;

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

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

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

    print "<tr>

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

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

 <td align=\"left\">" . $data2['etape'] . "</td>

 <td align=\"left\">" . $data2['message'] . "</td>

</tr>\n";

  }

  print local_make_array_footer();

  commonFooter();

  exit;

 }

?>