[auf-serveur.git] / glpi-plugin-auf / plugin / report.computers.php

<?php
//Options for GLPI 0.71 and newer : need slave db to access the report
$USEDBREPLICATE=1;
$DBCONNECTION_REQUIRED=0;

include ("../../inc/includes.php");
include_once ("inc/functions.php");

$svg_color_names = Array('red', 'green', 'yellow', 'blue');

Session::checkRight("reports", "r");
Session::checkRight("computer", "r");

$report_title = "Nombre de machines par catégorie";

#Html::header(Report::getTypeName(2), $_SERVER['PHP_SELF'], "utils", "report");
Html::header($report_title, $_SERVER['PHP_SELF'], "utils", "report");
Report::title();

echo "\n<p class='big b' style='margin: 5px; text-align: center'><span id='report_date' style='float: right; margin: 2px 20px; font-size: 75%; font-style: italic'>(".date('Y-m-d H:i:s')." UTC)</span>$report_title</p>";

$computer = new Computer();

$itemtype = 'Computer';
$table_item = getTableForItemType($itemtype);

// echo "\n<span class='big b' style='color: red;'>ATTENTION : ce rapport est en cours de refonte, merci de ne pas tenir compte des données affichées ci-dessous.</span><br><br>";

//echo "\n<span class='big b'>Ordinateurs par implantation</span><br><br>";
echo "<table class='tab_cadrehov'>";
echo "<tr class='tab_bg_1'><th rowspan='2' colspan='2'>Implantation</th>";
echo "<th colspan='2'>".svg_circle('red')." Serveurs</th>";
echo "<th colspan='2'>".svg_circle('green')." Postes internes</th>";
echo "<th colspan='2'>".svg_circle('yellow')." Postes publics</th>";
echo "<th rowspan='2'>Total</th>";
echo "<th rowspan='2'>".svg_circle('blue')." Virtuels</th>";
echo "<th rowspan='2'>Autres<br /><span style='font-size: 75%'>(sans statut)</span></th></tr>";
echo "<tr class='tab_bg_1'><th>Total</th><th>Production</th>";
echo "<th>Total</th><th>Attribué</th><th>Total</th><th>Attribué</th></tr>\n";

$grand_serveurs_total = 0; $grand_serveurs_prod = 0;
$grand_internes_total = 0; $grand_internes_prod = 0;
$grand_publics_total = 0; $grand_publics_prod = 0;
$grand_total = 0;
$grand_virtuels_total = 0; $grand_autres_total = 0;
# récupération de la liste des régions
$query = "SELECT id FROM glpi_entities WHERE (id=0 OR entities_id=0)";
$query .= " ".getEntitiesRestrictRequest("AND", "glpi_entities")." ORDER BY name";
$region_result = $DB->query($query);
# parcours des régions
while ($region_data = $DB->fetch_assoc($region_result)) {
  $region_id = $region_data['id'];
  if ($region_id != 0) {
    $region_name = getTreeLeafValueName("glpi_entities", $region_id);
  } else {
    $region_name = "AUF";
  }
  $table_lines = Array();
  $region_serveurs_total = 0; $region_serveurs_prod = 0;
  $region_internes_total = 0; $region_internes_prod = 0;
  $region_publics_total = 0; $region_publics_prod = 0;
  $region_total = 0; $region_virtuels_total = 0;
  $region_autres_total = 0;

  # récupération de la liste des implantations
  $query = "SELECT id,level FROM glpi_entities WHERE ";
  if ($region_id != 0) {
    $query .= getRealQueryForTreeItem("glpi_entities", $region_id, "id");
  } else {
    $query .= "id=0";
  }
  $query .= " ".getEntitiesRestrictRequest("AND", "glpi_entities")." ORDER BY name";
  $implant_result = $DB->query($query);
  # parcours des implantations
  while ($implant_data = $DB->fetch_assoc($implant_result)) {
    $implant_id = $implant_data['id'];
    if ($implant_id != 0) {
      $implant_name = getTreeLeafValueName("glpi_entities", $implant_id);
    } else {
      $implant_name = "<i>(non classé)</i>";
    }

    # récupération de la liste des systèmes de l'implantation
    $nb_serveurs_total = 0; $nb_serveurs_prod = 0;
    $nb_internes_total = 0; $nb_internes_prod = 0;
    $nb_publics_total = 0;  $nb_publics_prod = 0;
    $nb_virtuels_total = 0; $nb_autres_total = 0;
    $query = "SELECT s.completename AS sname, ac.est_virtuel AS virtuel,
                acc.name AS categorie, acu.name AS utilisation
              FROM `$table_item` c
              LEFT JOIN glpi_states s ON (c.states_id = s.id)
              LEFT JOIN glpi_plugin_auf_computers ac ON (c.id = ac.id)
              LEFT JOIN glpi_plugin_auf_categories acc ON (ac.auf_categories_id = acc.id)
              LEFT JOIN glpi_plugin_auf_utilisations acu ON (ac.auf_utilisations_id = acu.id)
              WHERE c.is_deleted = '0' AND c.is_template = '0'
                AND c.entities_id = '".$implant_id."'";
    $result = $DB->query($query);
    while ($data=$DB->fetch_assoc($result)) {
      // on ne compte pas les sorties d'inventaire
      if (preg_match("/^sortie/i", $data['sname'])) {
        continue;
      }
      // serveurs
      if (preg_match("/^infra/i", $data['categorie'])) {
        $nb_serveurs_total++;
        if (preg_match("/^production/i", $data['utilisation']) &&
           !preg_match("/panne/i", $data['sname']) ) {
          $nb_serveurs_prod++;
        }
      }
      // postes internes
      elseif (preg_match("/^poste.*interne/i", $data['categorie'])) {
        $nb_internes_total++;
        if (preg_match("/^production/i", $data['utilisation']) &&
           !preg_match("/panne/i", $data['sname']) ) {
           $nb_internes_prod++;
        }
      }
      // postes publics
      elseif (preg_match("/^poste.*public/i", $data['categorie'])) {
        $nb_publics_total++;
        if (preg_match("/^production/i", $data['utilisation']) &&
           !preg_match("/panne/i", $data['sname']) ) {
          $nb_publics_prod++;
        }
      }
      // autres
      else {
        // machines virtuelles
        if ($data['virtuel']) {
          $nb_virtuels_total++;
        // autres
        } else {
          $nb_autres_total++;
        }
      }
    } // systèmes dans l'implantation

    $total = $nb_serveurs_total + $nb_internes_total + $nb_publics_total;
    if ($total > 0) {
      $spaces = "";
      for ($i=1;$i<$implant_data['level'];$i++) { $spaces .= "&nbsp;&nbsp;"; }
      $line = "<tr><td class='tab_bg_1'>$spaces$implant_name</td>";
      $line .= "<td class='numeric'>$nb_serveurs_total</td>";
      $line .= "<td class='numeric'>$nb_serveurs_prod</td>";
      $line .= "<td class='numeric'>$nb_internes_total</td>";
      $line .= "<td class='numeric'>$nb_internes_prod</td>";
      $line .= "<td class='numeric'>$nb_publics_total</td>";
      $line .= "<td class='numeric'>$nb_publics_prod</td>";
      $line .= "<td class='numeric tab_bg_1'>$total</td>";
      $line .= "<td class='numeric'>$nb_virtuels_total</td>";
      $line .= "<td class='numeric'>$nb_autres_total</td></tr>";
      $table_lines[] = $line;
    }
    $region_serveurs_total += $nb_serveurs_total;
    $region_serveurs_prod += $nb_serveurs_prod;
    $region_internes_total += $nb_internes_total;
    $region_internes_prod += $nb_internes_prod;
    $region_publics_total += $nb_publics_total;
    $region_publics_prod += $nb_publics_prod;
    $region_total += $total;
    $region_virtuels_total += $nb_virtuels_total;
    $region_autres_total += $nb_autres_total;
    //$table_lines[] = "<tr><td>".$implant_name."</td></tr>";
  } // fin des implantations de la région

  $line = "<tr class='tab_bg_1 b'><td>Sous-total</td>";
  $line .= "<td class='numeric'>$region_serveurs_total</td>";
  $line .= "<td class='numeric'>$region_serveurs_prod</td>";
  $line .= "<td class='numeric'>$region_internes_total</td>";
  $line .= "<td class='numeric'>$region_internes_prod</td>";
  $line .= "<td class='numeric'>$region_publics_total</td>";
  $line .= "<td class='numeric'>$region_publics_prod</td>";
  $line .= "<td class='numeric tab_bg_1'>$region_total</td>";
  $line .= "<td class='numeric'>$region_virtuels_total</td>";
  $line .= "<td class='numeric'>$region_autres_total</td></tr>";
  $table_lines[] = $line;

  $region_name = svg_pie_chart(Array($region_serveurs_total, $region_internes_total, $region_publics_total, $region_virtuels_total), 16) . $region_name;
  $table_lines[0] = str_replace("<tr>", "<tr><td class='tab_bg_1 b' rowspan='".count($table_lines)."'>$region_name</td>", $table_lines[0]);
  if ($region_id != 0) {
    echo "<tr><th colspan='11'></th></tr>\n";
  }
  echo implode("\n", $table_lines);

  $grand_serveurs_total += $region_serveurs_total;
  $grand_serveurs_prod += $region_serveurs_prod;
  $grand_internes_total += $region_internes_total;
  $grand_internes_prod += $region_internes_prod;
  $grand_publics_total += $region_publics_total;
  $grand_publics_prod += $region_publics_prod;
  $grand_total += $region_total;
  $grand_virtuels_total += $region_virtuels_total;
  $grand_autres_total += $region_autres_total;
} // fin des régions

// echo "<tr class='tab_bg_1'><td colspan='8'>&nbsp;</td></tr>";

/*
# total operating systems
$query = "SELECT COUNT(DISTINCT fia.`tag`) FROM `".$table_item."`
          LEFT JOIN `glpi_computers_items` ci
          ON (ci.`itemtype` = '".$itemtype."'
          AND ci.`items_id` = `".$table_item."`.`id`)
          LEFT JOIN `glpi_plugin_fusioninventory_agents` fia
          ON (fia.`computers_id` = `".$table_item."`.`id`)
          WHERE `".$table_item."`.`is_deleted` = '0'
            AND `".$table_item."`.`is_template` = '0' ".
          getEntitiesRestrictRequest("AND", $table_item);
$result = $DB->query($query);
$grand_total = $DB->result($result, 0, 0);
*/
$line = "<tr class='tab_bg_1'><td class='b' colspan='2'>Total général</td>";
$line .= "<td class='numeric b'>$grand_serveurs_total</td>";
$line .= "<td class='numeric b'>$grand_serveurs_prod</td>";
$line .= "<td class='numeric b'>$grand_internes_total</td>";
$line .= "<td class='numeric b'>$grand_internes_prod</td>";
$line .= "<td class='numeric b'>$grand_publics_total</td>";
$line .= "<td class='numeric b'>$grand_publics_prod</td>";
$line .= "<td class='numeric b'>$grand_total</td>";
$line .= "<td class='numeric b'>$grand_virtuels_total</td>";
$line .= "<td class='numeric b'>$grand_autres_total</td></tr>";
echo "<tr><th colspan='11'></th></tr>\n";
echo $line;

echo "</table>";

Html::footer();
?>
Commit	Line	Data
f87696f8 P	1	<?php
	2	//Options for GLPI 0.71 and newer : need slave db to access the report
	3	$USEDBREPLICATE=1;
	4	$DBCONNECTION_REQUIRED=0;
	5
	6	include ("../../inc/includes.php");
1135f035 P	7	include_once ("inc/functions.php");
	8
	9	$svg_color_names = Array('red', 'green', 'yellow', 'blue');
f87696f8 P	10
	11	Session::checkRight("reports", "r");
	12	Session::checkRight("computer", "r");
	13
118fab7c P	14	$report_title = "Nombre de machines par catégorie";
118fab7c P	15
f87696f8	16	#Html::header(Report::getTypeName(2), $_SERVER['PHP_SELF'], "utils", "report");
118fab7c	17	Html::header($report_title, $_SERVER['PHP_SELF'], "utils", "report");
f87696f8 P	18	Report::title();
f87696f8 P	19
118fab7c P	20	echo "\n<p class='big b' style='margin: 5px; text-align: center'><span id='report_date' style='float: right; margin: 2px 20px; font-size: 75%; font-style: italic'>(".date('Y-m-d H:i:s')." UTC)</span>$report_title</p>";
118fab7c P	21
f87696f8 P	22	$computer = new Computer();
f87696f8 P	23
f87696f8 P	24	$itemtype = 'Computer';
	25	$table_item = getTableForItemType($itemtype);
	26
67d402c6 P	27	// echo "\n<span class='big b' style='color: red;'>ATTENTION : ce rapport est en cours de refonte, merci de ne pas tenir compte des données affichées ci-dessous.</span><br><br>";
67d402c6 P	28
749e76d6	29	//echo "\n<span class='big b'>Ordinateurs par implantation</span><br><br>";
f87696f8 P	30	echo "<table class='tab_cadrehov'>";
f87696f8 P	31	echo "<tr class='tab_bg_1'><th rowspan='2' colspan='2'>Implantation</th>";
c2b8eea0	32	echo "<th colspan='2'>".svg_circle('red')." Serveurs</th>";
67d402c6 P	33	echo "<th colspan='2'>".svg_circle('green')." Postes internes</th>";
	34	echo "<th colspan='2'>".svg_circle('yellow')." Postes publics</th>";
	35	echo "<th rowspan='2'>Total</th>";
	36	echo "<th rowspan='2'>".svg_circle('blue')." Virtuels</th>";
	37	echo "<th rowspan='2'>Autres<br /><span style='font-size: 75%'>(sans statut)</span></th></tr>";
f87696f8 P	38	echo "<tr class='tab_bg_1'><th>Total</th><th>Production</th>";
	39	echo "<th>Total</th><th>Attribué</th><th>Total</th><th>Attribué</th></tr>\n";
	40
749e76d6 P	41	$grand_serveurs_total = 0; $grand_serveurs_prod = 0;
	42	$grand_internes_total = 0; $grand_internes_prod = 0;
	43	$grand_publics_total = 0; $grand_publics_prod = 0;
67d402c6 P	44	$grand_total = 0;
67d402c6 P	45	$grand_virtuels_total = 0; $grand_autres_total = 0;
f87696f8	46	# récupération de la liste des régions
f87696f8 P	47	$query = "SELECT id FROM glpi_entities WHERE (id=0 OR entities_id=0)";
	48	$query .= " ".getEntitiesRestrictRequest("AND", "glpi_entities")." ORDER BY name";
	49	$region_result = $DB->query($query);
	50	# parcours des régions
	51	while ($region_data = $DB->fetch_assoc($region_result)) {
	52	$region_id = $region_data['id'];
	53	if ($region_id != 0) {
	54	$region_name = getTreeLeafValueName("glpi_entities", $region_id);
	55	} else {
	56	$region_name = "AUF";
	57	}
	58	$table_lines = Array();
	59	$region_serveurs_total = 0; $region_serveurs_prod = 0;
	60	$region_internes_total = 0; $region_internes_prod = 0;
	61	$region_publics_total = 0; $region_publics_prod = 0;
	62	$region_total = 0; $region_virtuels_total = 0;
	63	$region_autres_total = 0;
	64
	65	# récupération de la liste des implantations
	66	$query = "SELECT id,level FROM glpi_entities WHERE ";
	67	if ($region_id != 0) {
	68	$query .= getRealQueryForTreeItem("glpi_entities", $region_id, "id");
	69	} else {
	70	$query .= "id=0";
	71	}
	72	$query .= " ".getEntitiesRestrictRequest("AND", "glpi_entities")." ORDER BY name";
	73	$implant_result = $DB->query($query);
	74	# parcours des implantations
	75	while ($implant_data = $DB->fetch_assoc($implant_result)) {
	76	$implant_id = $implant_data['id'];
	77	if ($implant_id != 0) {
	78	$implant_name = getTreeLeafValueName("glpi_entities", $implant_id);
	79	} else {
	80	$implant_name = "<i>(non classé)</i>";
	81	}
	82
	83	# récupération de la liste des systèmes de l'implantation
	84	$nb_serveurs_total = 0; $nb_serveurs_prod = 0;
	85	$nb_internes_total = 0; $nb_internes_prod = 0;
	86	$nb_publics_total = 0; $nb_publics_prod = 0;
	87	$nb_virtuels_total = 0; $nb_autres_total = 0;
67d402c6 P	88	$query = "SELECT s.completename AS sname, ac.est_virtuel AS virtuel,
67d402c6 P	89	acc.name AS categorie, acu.name AS utilisation
f87696f8	90	FROM `$table_item` c
f87696f8	91	LEFT JOIN glpi_states s ON (c.states_id = s.id)
67d402c6 P	92	LEFT JOIN glpi_plugin_auf_computers ac ON (c.id = ac.id)
	93	LEFT JOIN glpi_plugin_auf_categories acc ON (ac.auf_categories_id = acc.id)
	94	LEFT JOIN glpi_plugin_auf_utilisations acu ON (ac.auf_utilisations_id = acu.id)
f87696f8	95	WHERE c.is_deleted = '0' AND c.is_template = '0'
67d402c6	96	AND c.entities_id = '".$implant_id."'";
f87696f8 P	97	$result = $DB->query($query);
f87696f8 P	98	while ($data=$DB->fetch_assoc($result)) {
67d402c6 P	99	// on ne compte pas les sorties d'inventaire
	100	if (preg_match("/^sortie/i", $data['sname'])) {
	101	continue;
	102	}
	103	// serveurs
	104	if (preg_match("/^infra/i", $data['categorie'])) {
	105	$nb_serveurs_total++;
	106	if (preg_match("/^production/i", $data['utilisation']) &&
	107	!preg_match("/panne/i", $data['sname']) ) {
	108	$nb_serveurs_prod++;
	109	}
	110	}
	111	// postes internes
	112	elseif (preg_match("/^poste.*interne/i", $data['categorie'])) {
	113	$nb_internes_total++;
	114	if (preg_match("/^production/i", $data['utilisation']) &&
	115	!preg_match("/panne/i", $data['sname']) ) {
	116	$nb_internes_prod++;
	117	}
	118	}
	119	// postes publics
	120	elseif (preg_match("/^poste.*public/i", $data['categorie'])) {
	121	$nb_publics_total++;
	122	if (preg_match("/^production/i", $data['utilisation']) &&
	123	!preg_match("/panne/i", $data['sname']) ) {
	124	$nb_publics_prod++;
	125	}
	126	}
	127	// autres
	128	else {
	129	// machines virtuelles
	130	if ($data['virtuel']) {
	131	$nb_virtuels_total++;
	132	// autres
	133	} else {
	134	$nb_autres_total++;
	135	}
f87696f8 P	136	}
	137	} // systèmes dans l'implantation
	138
67d402c6	139	$total = $nb_serveurs_total + $nb_internes_total + $nb_publics_total;
f87696f8 P	140	if ($total > 0) {
	141	$spaces = "";
	142	for ($i=1;$i<$implant_data['level'];$i++) { $spaces .= "  "; }
67d402c6 P	143	$line = "<tr><td class='tab_bg_1'>$spaces$implant_name</td>";
	144	$line .= "<td class='numeric'>$nb_serveurs_total</td>";
	145	$line .= "<td class='numeric'>$nb_serveurs_prod</td>";
	146	$line .= "<td class='numeric'>$nb_internes_total</td>";
	147	$line .= "<td class='numeric'>$nb_internes_prod</td>";
	148	$line .= "<td class='numeric'>$nb_publics_total</td>";
	149	$line .= "<td class='numeric'>$nb_publics_prod</td>";
	150	$line .= "<td class='numeric tab_bg_1'>$total</td>";
	151	$line .= "<td class='numeric'>$nb_virtuels_total</td>";
	152	$line .= "<td class='numeric'>$nb_autres_total</td></tr>";
f87696f8 P	153	$table_lines[] = $line;
	154	}
	155	$region_serveurs_total += $nb_serveurs_total;
	156	$region_serveurs_prod += $nb_serveurs_prod;
	157	$region_internes_total += $nb_internes_total;
	158	$region_internes_prod += $nb_internes_prod;
	159	$region_publics_total += $nb_publics_total;
	160	$region_publics_prod += $nb_publics_prod;
	161	$region_total += $total;
	162	$region_virtuels_total += $nb_virtuels_total;
	163	$region_autres_total += $nb_autres_total;
	164	//$table_lines[] = "<tr><td>".$implant_name."</td></tr>";
	165	} // fin des implantations de la région
	166
	167	$line = "<tr class='tab_bg_1 b'><td>Sous-total</td>";
67d402c6 P	168	$line .= "<td class='numeric'>$region_serveurs_total</td>";
	169	$line .= "<td class='numeric'>$region_serveurs_prod</td>";
	170	$line .= "<td class='numeric'>$region_internes_total</td>";
	171	$line .= "<td class='numeric'>$region_internes_prod</td>";
	172	$line .= "<td class='numeric'>$region_publics_total</td>";
	173	$line .= "<td class='numeric'>$region_publics_prod</td>";
	174	$line .= "<td class='numeric tab_bg_1'>$region_total</td>";
	175	$line .= "<td class='numeric'>$region_virtuels_total</td>";
	176	$line .= "<td class='numeric'>$region_autres_total</td></tr>";
f87696f8 P	177	$table_lines[] = $line;
	178
	179	$region_name = svg_pie_chart(Array($region_serveurs_total, $region_internes_total, $region_publics_total, $region_virtuels_total), 16) . $region_name;
	180	$table_lines[0] = str_replace("<tr>", "<tr><td class='tab_bg_1 b' rowspan='".count($table_lines)."'>$region_name</td>", $table_lines[0]);
67d402c6 P	181	if ($region_id != 0) {
	182	echo "<tr><th colspan='11'></th></tr>\n";
	183	}
f87696f8 P	184	echo implode("\n", $table_lines);
	185
	186	$grand_serveurs_total += $region_serveurs_total;
	187	$grand_serveurs_prod += $region_serveurs_prod;
	188	$grand_internes_total += $region_internes_total;
	189	$grand_internes_prod += $region_internes_prod;
	190	$grand_publics_total += $region_publics_total;
	191	$grand_publics_prod += $region_publics_prod;
	192	$grand_total += $region_total;
	193	$grand_virtuels_total += $region_virtuels_total;
	194	$grand_autres_total += $region_autres_total;
	195	} // fin des régions
	196
	197	// echo "<tr class='tab_bg_1'><td colspan='8'> </td></tr>";
	198
	199	/*
	200	# total operating systems
	201	$query = "SELECT COUNT(DISTINCT fia.`tag`) FROM `".$table_item."`
	202	LEFT JOIN `glpi_computers_items` ci
	203	ON (ci.`itemtype` = '".$itemtype."'
	204	AND ci.`items_id` = `".$table_item."`.`id`)
	205	LEFT JOIN `glpi_plugin_fusioninventory_agents` fia
	206	ON (fia.`computers_id` = `".$table_item."`.`id`)
	207	WHERE `".$table_item."`.`is_deleted` = '0'
	208	AND `".$table_item."`.`is_template` = '0' ".
	209	getEntitiesRestrictRequest("AND", $table_item);
	210	$result = $DB->query($query);
	211	$grand_total = $DB->result($result, 0, 0);
	212	*/
	213	$line = "<tr class='tab_bg_1'><td class='b' colspan='2'>Total général</td>";
67d402c6 P	214	$line .= "<td class='numeric b'>$grand_serveurs_total</td>";
	215	$line .= "<td class='numeric b'>$grand_serveurs_prod</td>";
	216	$line .= "<td class='numeric b'>$grand_internes_total</td>";
	217	$line .= "<td class='numeric b'>$grand_internes_prod</td>";
	218	$line .= "<td class='numeric b'>$grand_publics_total</td>";
	219	$line .= "<td class='numeric b'>$grand_publics_prod</td>";
	220	$line .= "<td class='numeric b'>$grand_total</td>";
	221	$line .= "<td class='numeric b'>$grand_virtuels_total</td>";
	222	$line .= "<td class='numeric b'>$grand_autres_total</td></tr>";
	223	echo "<tr><th colspan='11'></th></tr>\n";
f87696f8 P	224	echo $line;
	225
	226	echo "</table>";
	227
	228	Html::footer();
	229	?>