Je suis sur le point de mettre en production Gestsup dans mon service et j'avais (surtout) besoin de stats sur les demandeurs afin d'identifier leurs besoins en terme de formations, mais également pour que nos intégrateurs puisse connaitre, en plus des bugs remontés géré par un autre produit, le volume d'incident lié à leurs projets et avoir une meilleur visibilité "terrain".
J'ai donc revu les stats en prenant pour modèle les stats actuels sur les techniciens, j'ai simplement modifier les requêtes.
Pour ma part, j'ai intégré mes stats sur les demandeurs en plus de l'existant, j'ai du modifier index.php et créer un nouveau fichier php listant deux liens, le premier vers les stats d'origines et l'autre vers mes stats sur les demandeurs.
Bref, je te joint le contenu de mon fichier stat.php modifié, tu peux le mettre en lieu et place de l'autre pour déjà voir si cela peu répondre à ton besoin.
Code : Tout sélectionner
<?php
/*
Author: Flox
FileName: stat.php
Description: Display Statistics
Version: 2.2
Last Update Date: 21/03/2013 - 06/06/2013
*/
//initialize variables
if(!isset($select)) $select = '';
if(!isset($selected1)) $selected1 = '';
if(!isset($selected2)) $selected2 = '';
if(!isset($selected6)) $selected6 = '';
if(!isset($libgraph)) $libgraph = '';
if(!isset($selected)) $selected= '';
if(!isset($find)) $find= '';
if(!isset($find6)) $find6= '';
if(!isset($subcat)) $subcat= '%';
if(!isset($category)) $category= '';
if(!isset($result)) $result= '';
if(!isset($monthm)) $monthm= '';
if(!isset($container)) $container= '';
if(!isset($_POST['tech'])) $_POST['tech']='';
if(!isset($_POST['criticality'])) $_POST['criticality']='';
if(!isset($_POST['category'])) $_POST['category']='';
if(!isset($_POST['subcat'])) $_POST['subcat']= '';
if(!isset($_POST['year'])) $_POST['year'] = '';
if(!isset($_POST['year6'])) $_POST['year6'] = '';
if(!isset($_POST['month'])) $_POST['month'] = '';
if(!isset($_POST['month6'])) $_POST['month6'] = '';
if(!isset($_POST['cat6'])) $_POST['cat6'] = '';
if(!isset($_POST['tech6'])) $_POST['tech6'] = '';
//default values
if ($_POST['tech']=="") $_POST['tech']="%";
if ($_POST['criticality']=="") $_POST['criticality']="%";
if ($_POST['year']=="") $_POST['year']=date('Y');
if ($_POST['year6']=="") $_POST['year6']='current';
if ($_POST['month']=="") $_POST['month']=date('m');
if ($_POST['month6']=="") $_POST['month6']='current';
if ($_POST['cat6']=="") $_POST['cat6']='%';
if ($_POST['tech6']=="") $_POST['tech6']='%';
//month name and day nametable
$mois = array();
$mois = array("01" => "Janvier", "02"=> "Février", "03"=> "Mars", "04"=> "Avril", "05"=> "Mai", "06"=> "Juin", "07"=> "Juillet", "08"=> "Aout", "09"=> "Septembre", "10"=> "Octobre", "11"=> "Novembre", "12"=> "Décembre");
$jour= array();
$jour = array(1 => "1", 2=> "2", 3=> "3", 4=> "4", 5=> "5", 6=> "6", 7=> "7", 8=> "8", 9=> "9", 10=> "10", 11=> "11", 12=> "12", 13=> "13", 14=> "14", 15=> "15", 16=> "16", 17=> "17", 18=> "18", 19=> "19", 20=> "20", 21=> "21", 22=> "22", 23=> "23", 24=> "24", 25=> "25", 26=> "26", 27=> "27", 28=> "28", 29=> "29", 30=> "30", 31=> "31");
?>
<h2 class="sec_head">Statistiques par Demandeurs</h2>
<div id="catalogue">
<?php
////////////////////////////////////////////START LINE CHART/////////////////////////////////////////////////////////
//count period
$user_id=$_SESSION['user_id'];
$req= mysql_query( "SELECT count(*) FROM `tincidents` WHERE user LIKE '$_POST[tech]' and criticality like '$_POST[criticality]' and date_create not like '0000-00-00' and date_create like '$_POST[year]-$_POST[month]-%' AND disable='0'");
$res = mysql_fetch_array($req);
$count=$res[0];
//Table déclaration
$values = array();
$xnom = array();
//query for year selection
if (($_POST['month'] == '%') && ($_POST['year']!=='%'))
{
$values = array();
$xnom = array();
$libchart="Nombre de tickets ouvert en $_POST[year]";
$sql= "SELECT month(date_create) as x,count(*) as y FROM `tincidents` WHERE user LIKE '$_POST[tech]' and criticality like '$_POST[criticality]' and date_create not like '0000-00-00' and date_create like '$_POST[year]-$_POST[month]-%' AND disable='0' group by x ";
$result = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
// push data in table
while($data = mysql_fetch_array($result))
{
//bugfix with month with 0
if ($data['x']<10) $data['x']="0$data[x]";
array_push($values ,$data['y']);
array_push($xnom ,$mois[$data['x']]);
}
}
//query for month selection
else if ($_POST['month']!='%')
{
$values = array();
$xnom = array();
$monthm=$_POST['month'];
$libchart="Nombre de tickets ouvert en $mois[$monthm] $_POST[year]";
$sql= "SELECT day(date_create) as x,count(*) as y FROM `tincidents` WHERE user LIKE '$_POST[tech]' and criticality like '$_POST[criticality]' and date_create not like '0000-00-00' and date_create like '$_POST[year]-$_POST[month]-%' AND disable='0' group by date_create ";
$result = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
// push data in table
while($data = mysql_fetch_array($result)){
array_push($values ,$data['y']);
array_push($xnom ,$jour[$data['x']]);
}
}
//query for all years selection
else if ($_POST['year']=='%')
{
$values = array();
$xnom = array();
$libchart="Nombre de tickets ouvert sur toutes les années";
$sql= "SELECT year(date_create) as x,count(*) as y FROM `tincidents` WHERE user LIKE '$_POST[tech]' and criticality like '$_POST[criticality]' and date_create not like '0000-00-00' and date_create like '$_POST[year]-$_POST[month]-%' AND disable='0' group by year(date_create) ";
$result = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
// push data in table
while($data = mysql_fetch_array($result)){array_push($values ,$data['y']); array_push($xnom ,$data['x']);}
}
if ($res[0]!=0)
{
$liby="Nombre de tickets";
$container="container1";
include('./stat_line.php');
}
else { echo '<div id="erreur"><img src="./images/critical.png" style="border-style: none" alt="img" /> Aucune valeurs pour cette selection.</div>';}
////// SELECT CRITERIA PART
?>
<center>
<form method="post" action="" name="date">
<br />
<select name="tech" onchange=submit()>
<?php
$query = mysql_query("SELECT * FROM tusers WHERE profile=2 and disable=0");
while ($row=mysql_fetch_array($query)) {
if ($row['id'] == $_POST['tech']) $selected1="selected" ;
if ($row['id'] == $_POST['tech']) $find="1" ;
echo "<option value=\"$row[id]\" $selected1>$row[firstname] $row[lastname]</option>";
$selected1="";
}
echo "<option value=\"%\" >Tous les demandeurs</option>";
if ($find!="1") echo "<option value=\"%\" selected>Tous les demandeurs</option>";
?>
</select>
<select name="criticality" onchange=submit()>
<?php
$query = mysql_query("SELECT * FROM tcriticality ORDER BY number");
while ($row=mysql_fetch_array($query)) {
if ($row['id'] == $_POST['criticality']) $selected2="selected" ;
if ($row['id'] == $_POST['criticality']) $find="1";
echo "<option value=\"$row[id]\" $selected2>$row[name]</option>";
$selected2="";
}
echo "<option "; if ($_POST['criticality']=='%') echo "selected"; echo" value=\"%\" >Toutes les criticités</option>";
?>
</select>
<select name="month" onchange=submit()>
<option value="%" <?php if ($_POST['month'] == '%')echo "selected" ?>>Tous les mois</option>
<option value="01"<?php if ($_POST['month'] == '1')echo "selected" ?>>Janvier</option>
<option value="02"<?php if ($_POST['month'] == '2')echo "selected" ?>>Février</option>
<option value="03"<?php if ($_POST['month'] == '3')echo "selected" ?>>Mars</option>
<option value="04"<?php if ($_POST['month'] == '4')echo "selected" ?>>Avril</option>
<option value="05"<?php if ($_POST['month'] == '5')echo "selected" ?>>Mai</option>
<option value="06"<?php if ($_POST['month'] == '6')echo "selected" ?>>Juin</option>
<option value="07"<?php if ($_POST['month'] == '7')echo "selected" ?>>Juillet</option>
<option value="08"<?php if ($_POST['month'] == '8')echo "selected" ?>>Aout</option>
<option value="09"<?php if ($_POST['month'] == '9')echo "selected" ?>>Septembre</option>
<option value="10"<?php if ($_POST['month'] == '10')echo "selected" ?>>Octobre</option>
<option value="11"<?php if ($_POST['month'] == '11')echo "selected" ?>>Novembre</option>
<option value="12"<?php if ($_POST['month'] == '12')echo "selected" ?>>Décembre</option>
</select>
<select name="year" onchange=submit()>
<?php
$q1= mysql_query("SELECT distinct year(date_create) as year FROM `tincidents` WHERE date_create not like '0000-00-00'");
while ($row=mysql_fetch_array($q1))
{
$selected=0;
if ($_POST['year']==$row['year']) $selected="selected";
echo "test $_POST[year]==$row[year] $selected";
echo "<option value=$row[year] $selected>$row[year]</option>";
}
?>
<option value="%" <?php if ($_POST['year'] == '%')echo "selected" ?>>Toutes les années</option>
</select>
</form>
</center>
<br />
<br />
<?php
////////////////////////////////////////////END LINE CHART/////////////////////////////////////////////////////////
echo "<br /><hr /><br />";
////////////////////////////////////////////START 1 PIE CHART/////////////////////////////////////////////////////////
$values = array();
$xnom = array();
$libchart="Tickets par demandeur";
//total
$qtotal = mysql_query("SELECT count(*) FROM tincidents WHERE disable='0'");
$rtotal=mysql_fetch_array($qtotal);
$query = mysql_query("
SELECT CONCAT_WS('. ', left(tusers.firstname, 1), tusers.lastname) as Technicien, count(*) as Resolu
FROM tincidents
INNER JOIN tusers
ON (tincidents.user=tusers.id )
WHERE tusers.disable=0 AND
tincidents.disable LIKE '0'
GROUP BY tusers.firstname
ORDER by Resolu DESC");
while ($row=mysql_fetch_array($query))
{
$r=($row[1]/$rtotal[0])*101;
$r=round($r, 0);
$name=substr($row[0],0,42);
array_push($values, $r);
array_push($xnom, $name);
}
$container='container2';
include('./stat_pie.php');
echo "<div id=\"$container\" style=\"min-width: 415px; height: 230px; margin: 0 auto; float:left; \"></div>";
////////////////////////////////////////////END 1 PIE CHART/////////////////////////////////////////////////////////
////////////////////////////////////////////START 3 PIE CHART/////////////////////////////////////////////////////////
$values = array();
$xnom = array();
$qtotal = mysql_query("SELECT count(*) FROM tincidents WHERE disable='0'");
$rtotal=mysql_fetch_array($qtotal);
$libchart="Tickets par catégorie";
$query = mysql_query("
SELECT tcategory.name as sta, COUNT(*) as nb
FROM tincidents INNER JOIN tcategory ON (tincidents.category=tcategory.id)
WHERE tincidents.disable LIKE '0'
GROUP BY tcategory.id
ORDER BY nb
DESC
");
while ($row=mysql_fetch_array($query))
{
$r=($row[1]/$rtotal[0])*101;
$name=substr($row[0],0,42);
array_push($values, $r);
array_push($xnom, $name);
}
$container='container3';
include('./stat_pie.php');
echo "<div id=\"$container\" style=\"min-width: 430px; height: 230px; float:right;\"></div>";
////////////////////////////////////////////END 3 PIE CHART/////////////////////////////////////////////////////////
echo "<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />";
echo "<hr />";
////////////////////////////////////////////START 2 PIE CHART/////////////////////////////////////////////////////////
?>
<br /><br />
<a name="cam2"></a>
<div style="min-width: 200px; height: 230px; margin: 0 auto; margin-left:50px; float:left; ">
<br /><br /><br /><br /><br /><br /><br />
<form method="post" action="#cam2" name="category">
<u>Critères:</u><br /><br />
<label for="category">Catégorie</label>
<select name="category" onchange=submit()>
<?php
$query = mysql_query("SELECT * FROM tcategory ORDER BY name");
while ($row=mysql_fetch_array($query)) {
if ($row['id'] == $_POST['category']) $selected="selected" ;
if ($row['id'] == $_POST['category']) $find="1" ;
echo "<option value=\"$row[id]\" $selected>$row[name]</option>";
$selected="";
}
echo "<option value=\"%\" >Toutes les catégories</option>";
if ($find!="1") echo "<option value=\"%\" selected>Toutes les catégories</option>";
?>
</select>
</form>
</div>
<?php
$values = array();
$xnom = array();
$libchart="Repartition du nombre de ticket par categorie";
//total
if ($_POST['category']=='') $_POST['category']='%';
$qtotal = mysql_query("SELECT count(*) FROM tincidents WHERE category NOT LIKE '0' and category LIKE '$_POST[category]'");
$rtotal=mysql_fetch_array($qtotal);
if ($_POST['category']!="%")
{
$query = mysql_query("
SELECT tsubcat.name as cat, COUNT(*) as nb
FROM tincidents INNER JOIN tsubcat ON (tincidents.subcat=tsubcat.id)
WHERE tincidents.category='$_POST[category]' AND
tincidents.disable LIKE '0'
GROUP BY tsubcat.name
ORDER BY nb
DESC limit 0,10
");
}
else
{
$query = mysql_query("
SELECT tcategory.name as cat, COUNT(*) as nb
FROM tincidents INNER JOIN tcategory ON (tincidents.category=tcategory.id)
WHERE tincidents.disable LIKE '0'
GROUP BY tcategory.name
ORDER BY nb
DESC limit 0,10");
}
while ($row=mysql_fetch_array($query))
{
$r=($row[1]/$rtotal[0])*101;
$r=round($r, 1);
$name=substr($row[0],0,35);
$name=str_replace("'","\'",$name);
array_push($values, $r);
array_push($xnom, $name);
}
$container='container4';
include('./stat_pie.php');
echo "<div id=\"$container\" style=\"min-width: 500px; height: 300px; float:right;\"></div>";
////////////////////////////////////////////END 2 PIE CHART/////////////////////////////////////////////////////////
echo "<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />";
echo "<hr />";
////////////////////////////////////////////START 6 PIE CHART/////////////////////////////////////////////////////////
?>
<br />
<br />
<a name="chart6"></a>
<div style="min-width: 200px; height: 230px; margin: 0 auto; margin-left:50px; float:left; ">
<br /><br /><br /><br /><br />
<u>Critères:</u><br><br>
<form method="post" action="#chart6" name="chart6">
<label for="tech6">Demandeur:</label>
<select name="tech6" onchange=submit()>
<?php
$query = mysql_query("SELECT * FROM tusers WHERE (profile='2') and disable=0");
while ($row=mysql_fetch_array($query)) {
if ($row['id'] == $_POST['tech6']) $selected6="selected" ;
if ($row['id'] == $_POST['tech6']) $find6="1" ;
echo "<option value=\"$row[id]\" $selected6 >$row[firstname] $row[lastname]</option>";
$selected6="";
}
echo "<option value=\"%\" >Tous les demandeurs</option>";
if ($find6!="1") echo "<option value=\"%\" selected>Tous les demandeurs</option>";
?>
</select>
<br />
<label for="cat6">Catégorie:</label>
<select name="cat6" onchange=submit()>
<?php
$query = mysql_query("SELECT * FROM tcategory ORDER BY name");
while ($row=mysql_fetch_array($query)) {
if ($row['id'] == $_POST['cat6']) $selected="selected" ;
if ($row['id'] == $_POST['cat6']) $find="1" ;
echo "<option value=\"$row[id]\" $selected>$row[name]</option>";
$selected="";
}
echo "<option value=\"%\" >Toutes les catégories</option>";
if ($find!="1") echo "<option value=\"%\" selected>Toutes les catégories</option>";
?>
</select>
<br />
<label for="month6">Mois:</label>
<select name="month6" onchange=submit()>
<option value="current"<?php if ($_POST['month6'] == 'current')echo "selected" ?>>En cours</option>
<option value="%"<?php if ($_POST['month6'] == '%')echo "selected" ?>>Tous</option>
<option value="01"<?php if ($_POST['month6'] == '1')echo "selected" ?>>Janvier</option>
<option value="02"<?php if ($_POST['month6'] == '2')echo "selected" ?>>Février</option>
<option value="03"<?php if ($_POST['month6'] == '3')echo "selected" ?>>Mars</option>
<option value="04"<?php if ($_POST['month6'] == '4')echo "selected" ?>>Avril</option>
<option value="05"<?php if ($_POST['month6'] == '5')echo "selected" ?>>Mai</option>
<option value="06"<?php if ($_POST['month6'] == '6')echo "selected" ?>>Juin</option>
<option value="07"<?php if ($_POST['month6'] == '7')echo "selected" ?>>Juillet</option>
<option value="08"<?php if ($_POST['month6'] == '8')echo "selected" ?>>Aout</option>
<option value="09"<?php if ($_POST['month6'] == '9')echo "selected" ?>>Septembre</option>
<option value="10"<?php if ($_POST['month6'] == '10')echo "selected" ?>>Octobre</option>
<option value="11"<?php if ($_POST['month6'] == '11')echo "selected" ?>>Novembre</option>
<option value="12"<?php if ($_POST['month6'] == '12')echo "selected" ?>>Décembre</option>
</select>
<br />
<label for="year6">Année:</label>
<select name="year6" onchange=submit()>
<?php
$qyear6= mysql_query("SELECT distinct year(date_create) as year FROM `tincidents` WHERE date_create not like '0000-00-00' AND disable='0'");
while ($row=mysql_fetch_array($qyear6))
{
$selected='';
if ($_POST['year6']==$row['year']) $selected="selected";
echo "<option value=$row[year] $selected>$row[year]</option>";
}
?>
<option value="%" <?php if ($_POST['year6'] == '%')echo "selected" ?>>Toutes</option>
<option value="current" <?php if ($_POST['year6'] == 'current')echo "selected" ?>>En cours</option>
</select>
</form>
</div>
<?php
$values = array();
$xnom = array();
$libchart="Repartition tickets par demandeur et categorie";
//total
if ($_POST['category']=='') $_POST['category']='%';
$qtotal = mysql_query("SELECT count(*) FROM tincidents WHERE category NOT LIKE '0' and category LIKE '$_POST[category]'");
$rtotal=mysql_fetch_array($qtotal);
if ($_POST['cat6']!='%')
{
if (($_POST['year6']=='current') && ($_POST['month6']=='current'))
{
$query = "
SELECT tsubcat.name as subcat, COUNT(*) as nb
FROM `tincidents`
INNER JOIN tsubcat
ON (tincidents.subcat=tsubcat.id )
WHERE
tincidents.user LIKE '$_POST[tech6]' AND
tincidents.category LIKE '$_POST[cat6]' AND
tincidents.disable='0'
GROUP BY tsubcat.name
ORDER BY nb DESC
";
} else {
$query = "
SELECT tsubcat.name as subcat, COUNT(*) as nb
FROM `tincidents`
INNER JOIN tsubcat
ON (tincidents.subcat=tsubcat.id )
WHERE
tincidents.user LIKE '$_POST[tech6]' AND
tincidents.category LIKE '$_POST[cat6]' AND
tincidents.disable='0'
GROUP BY tsubcat.name
ORDER BY nb DESC
";
}
} else {
if (($_POST['year6']=='current') && ($_POST['month6']=='current'))
{
$query = "
SELECT tcategory.name as technicien, COUNT(*) as nb
FROM `tincidents`
INNER JOIN tcategory
ON (tincidents.category=tcategory.id )
WHERE
tincidents.user LIKE '$_POST[tech6]' AND
tincidents.category LIKE '$_POST[cat6]' AND
tincidents.disable='0'
GROUP BY tcategory.name
ORDER BY nb DESC
";
} else {
$query = "
SELECT tcategory.name as technicien, COUNT(*) as nb
FROM `tincidents`
INNER JOIN tcategory
ON (tincidents.category=tcategory.id )
WHERE
tincidents.user LIKE '$_POST[tech6]' AND
tincidents.category LIKE '$_POST[cat6]' AND
tincidents.disable='0'
GROUP BY tcategory.name
ORDER BY nb DESC
";
}
}
$query = mysql_query("$query");
while ($row=mysql_fetch_array($query))
{
$name=substr($row[0],0,42);
array_push($values, $row[1]);
array_push($xnom, $name);
}
$container='container6';
include('./stat_pie.php');
echo "<div id=\"$container\" style=\"min-width: 500px; height: 300px; float:right;\"></div>";
////////////////////////////////////////////END 6 PIE CHART////////////////////////////////////////////////////////
// echo "<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />";
// echo "<hr />";
// ////////////////////////////////////////////START 4 HISTO CHART/////////////////////////////////////////////////////////
// $values = array();
// $xnom = array();
// $qtotal = mysql_query("SELECT count(*) FROM tincidents");
// $rtotal=mysql_fetch_array($qtotal);
// $libchart="Charge de travail actuelle par demandeur";
// $query = mysql_query("
// SELECT CONCAT_WS('. ', left(tusers.firstname, 1), tusers.lastname) as Technicien, ROUND((SUM(tincidents.time_hope-tincidents.time))/60) as Charge
// FROM
// tincidents
// INNER JOIN tusers
// ON
// (tincidents.user=tusers.id ) WHERE
// tusers.disable='0' AND
// tincidents.disable='0' AND
// tincidents.time_hope-tincidents.time>0 AND
// (tincidents.state='1' OR tincidents.state='2' OR tincidents.state='6')
// GROUP BY tusers.firstname ORDER BY Charge DESC
// ");
// while ($row=mysql_fetch_array($query))
// {
// $r=$row[1];
// $name=substr($row[0],0,42);
// array_push($values, $r);
// array_push($xnom, $name);
// }
// $container="container5";
// include('./stat_histo.php');
echo "<div id=\"$container\" style=\"min-width: 300px; height: 400px; margin: 0 auto\"></div>";
echo "<hr />";
////////////////////////////////////////////END 4 HISTO CHART/////////////////////////////////////////////////////////
echo "<br /><br />";
echo "<center>";
echo "<table border=\"0\">";
echo "<td>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Demandes par demandeur</th></tr>";
$query = mysql_query("select CONCAT_WS('. ', left(tusers.firstname, 1), tusers.lastname) as Technicien, count(*) as Resolu FROM tincidents INNER JOIN tusers ON (tincidents.user=tusers.id ) WHERE tusers.disable='0' and tincidents.disable='0' group by tincidents.user order by Resolu DESC");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";}
echo "</table>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Demandes par agence</th></tr>";
$query = mysql_query("select tusers.company, count(*) as number FROM tincidents INNER JOIN tusers ON (tincidents.user=tusers.id ) WHERE tincidents.disable='0' group by tincidents.user order by tusers.company ASC");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";}
echo "</table>";
echo "</td>";
echo "<td>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Demandes par criticité</th></tr>";
$query = mysql_query("select tcriticality.name, count(*) as number FROM tincidents INNER JOIN tcriticality ON (tincidents.criticality=tcriticality.id ) WHERE tincidents.disable='0' group by tincidents.criticality order by tcriticality.number ASC");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";}
echo "</table>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Demandes par priorité</th></tr>";
$query = mysql_query("select tpriority.name, count(*) as number FROM tincidents INNER JOIN tpriority ON (tincidents.priority=tpriority.id ) WHERE tincidents.disable='0' group by tincidents.priority order by tpriority.number ASC");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";}
echo "</table>";
echo "</td>";
echo "<td>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Top 10 demandeurs</th></tr>";
$query = mysql_query("select tusers.firstname as Util, tusers.lastname, count(*) as demandes FROM tincidents INNER JOIN tusers ON (tincidents.user=tusers.id ) WHERE tincidents.disable='0' group by tincidents.user order by demandes DESC LIMIT 10");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0] $row[1]</td><td>$row[2]</td></tr>";}
echo "</table>";
// echo "</td>";
// echo "<td>";
echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><th colspan=\"2\">Top 10 agences</th></tr>";
$query = mysql_query("select tusers.company, count(*) as demandes FROM tincidents INNER JOIN tusers ON (tincidents.user=tusers.id ) WHERE tincidents.disable='0' group by tincidents.user order by tusers.company DESC LIMIT 10");
while ($row=mysql_fetch_array($query)) {echo "<tr><td>$row[0]</td><td>$row[1]</td></tr>";}
echo "</table>";
echo "</td>";
// echo "<td>";
//
// echo "<table width=\"180\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
// echo "<tr><th colspan=\"2\">TOP 10 consommateur de temps</th></tr>";
// $query = mysql_query("
// select tusers.firstname as Util, tusers.lastname, sum(time) as temps
// FROM tincidents
// INNER JOIN tusers ON (tincidents.user=tusers.id )
// WHERE tincidents.time NOT LIKE '0' AND
// tincidents.time NOT LIKE '0' AND
// tincidents.disable='0'
// group by tincidents.user
// order by sum(time) DESC limit 10");
// while ($row=mysql_fetch_array($query))
// {
// $tps=$row[2]/60;
// $tps=round($tps);
// echo "<tr><td>$row[0] $row[1]</td><td width=\"20\">$tps h</td></tr>";
// }
// echo "</table>";
// echo "</td></table>";
echo "</table>";
echo "</center>";
?>
</div>
Cordialement.