<?php

// Reporting - Daily Summary

// Include Configuration File
require_once ('../includes/config.inc'); 

// Set the page title and include the HTML header.
$page_title = 'Helpdesk Over Web - Reports - My Daily Performance';
include ('../includes/header.html');

// Connect to Database
require_once ('../includes/mysql_connect.php');

$datetoday = date("d.m.y");
$dateforsql = date("Y-m-d");
$monthtoday = date("M Y");
$selectedmonth = date("Y-m");
$engineer = $_POST['engineer'];

// Output query results in a table.
echo ("<H1>Report Functions</H1>");
$query = "SELECT * FROM systemusers WHERE HOWLogin='$engineer'";
$result = mysql_query($query)
   or die("Invalid query: " . mysql_error());
while($i = mysql_fetch_row($result)) { 
	echo "<P><B>User ID:</B> $i[0]<BR>";
	echo "<B>Name:</B> $i[4]<BR>";
	echo "<B>Role:</B> $i[5]<BR>";	
	echo "<B>Tel:</B> $i[2]<BR>";	
	echo "<B>Email:</B> <A HREF='MAILTO:$i[3]'>$i[3]</A></P>";	
	}   
	
echo ("<H2>Daily Summary - $datetoday</H2>");
$query = "SELECT * FROM calls WHERE Date='$dateforsql' AND Engineer = '$engineer';";		
$result = mysql_query($query)
   or die("Invalid query: " . mysql_error());
$num_rows = mysql_num_rows($result);
echo ("<H4><B>Total Calls Today: </B> $num_rows</H4>");

// Retrieves list of status categories from database.
$sql = "SELECT * FROM statcategories ORDER BY StatusText;";
$statlist = mysql_query($sql)
   or die("Invalid query: " . mysql_error());
while($i = mysql_fetch_row($statlist)) 
	{ 
	$statuslist[$j] = $i[1];
	$j++;
	}
	
// Calculates how many status categories are to be displayed.
$totalcategories = count($statuslist);

// Outputs each status category and its number of calls.
echo "<UL>";
while($x < $totalcategories)
 	{
 	$currentstatus = $statuslist[$x];
 	$query = "SELECT * FROM calls WHERE Date='$dateforsql' AND callstatus LIKE '$currentstatus' AND engineer = '$engineer';";		
 	$result = mysql_query($query)
 	   or die("Invalid query: " . mysql_error());
  	$num_rows = mysql_num_rows($result);
 	echo ("<P><B>$currentstatus: </B> $num_rows</P>");
	$x++;
 	}
echo "</UL>";


echo ("<H2>Monthly Summary - $monthtoday</H2>");
echo ("<H4><B>Total Calls This Month: </B> $num_rows</H4>");

$query = "SELECT * FROM calls WHERE Date LIKE '$selectedmonth%' AND callstatus LIKE 'Closed%' AND Engineer = '$engineer';";		
$result = mysql_query($query)
   or die("Invalid query: " . mysql_error());
$num_rows = mysql_num_rows($result);
echo ("<H4><B>Total Calls Closed: </B> $num_rows</H4>");

// Outputs each status category and its number of calls.
echo "<UL>";

while($y < $totalcategories)
 	{
 	$currentstatus = $statuslist[$y];
 	$query = "SELECT * FROM calls WHERE Date LIKE '$selectedmonth%' AND callstatus LIKE '$currentstatus' AND Engineer = '$engineer';";		
 	$result = mysql_query($query)
 	   or die("Invalid query: " . mysql_error());
  	$num_rows = mysql_num_rows($result);
 	echo ("<P><B>$currentstatus: </B> $num_rows</P>");
	$y++;
 	}
echo "</UL>";

echo "<P>[ <A HREF='reports.php'>Reports Menu</A> ]</P>";
// Include standard HTML footer
include ('../includes/footer.html');
?>