Statistiques, souhait d'avoir nombre de demande/demandeur

Décrivez les améliorations que vous souhaiteriez pour les prochaines versions.
Répondre
cyril
Gsup LEVEL 0
Messages : 9
Enregistré le : sam. 9 mars 2013 20:50

Bonjour

Est il possible d'ajouter à Gestsup par la suite des stats par demandeur:

Ex: diagramme circulaire divisé avec le nombre de demandes et %, effectué par demandeur.
Avec filtre possible en + sur champ 'mois" pour suivre l'évolution

Contexte
Savoir si un demandeur/client génère plus de demandes à la hotline, par rapport aux autres

Cordialement
Haut
Avatar du membre
Flox
Administrateur du site
Messages : 9040
Enregistré le : jeu. 21 juin 2012 19:00

Bonjour,

effectivement je pense que cette vue pourrait être intéressante, je conserve votre demande, pour de prochaines évolutions.

Cdt
GestSup: 3.2.47 | Debian: 12 | Apache: 2.4.58 | MariaDB: 11.3.2 | PHP: 8.3.6 | https://doc.gestsup.fr/
Haut
Big_Ray
Gsup LEVEL 0
Messages : 1
Enregistré le : ven. 7 juin 2013 14:46

Bonjour,

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.
Haut
Répondre

Retourner vers « Updates »