<html>
<head>
<link href="mytsm.css" rel="styleSheet" type="text/css">
<title> Tape Report
</title>
</head>
<body>
<?
if ($_POST['Elabora']) {
include_once 'libraries/functions.php';
Connect();
if ($_POST['year']) {
$startdate=($_POST['year'].'-'.$_POST['month'].'-'.$_POST['day']);
$enddate=($_POST['yearend'].$_POST['monthend'].$_POST['dayend']);
}
else {
$startdate=$_POST['startdate'];
$enddate=$_POST['enddate'];
}
$sql = 'SELECT to_days('.$enddate.') - to_days("'.$startdate.'") AS range';
$output=Query($sql);
$range = mysql_fetch_array($output);
if ($range["range"] < 0) {
echo ('Date range is not valid');
exit();
}
$date = $startdate;
echo '<table bgcolor="#353268" border = 1>';
echo '<tr bgcolor="#575582">';
echo '<td><font color="#FFFFFF"> Date </td><td><font color="#FFFFFF"> Size</td>';
$sql = 'SELECT `Date` , `Capacity`, ( ( `Capacity` / 100 ) * `Pct` ) AS Size, UNIX_TIMESTAMP( `Date` ) AS Udate FROM DB WHERE (( `Date` >= "'.$startdate.' 00:00:01" ) AND ( `Date` <= "'.$enddate.' 23:59:59"))';
$sel=Query($sql);
$sql = 'SELECT UNIX_TIMESTAMP("'.$startdate.' 00:00:00") AS Start';
$range=Query($sql);
$gdatea=mysql_fetch_array($range);
$sql = 'SELECT UNIX_TIMESTAMP("'.$enddate.' 23:59:59") AS End';
$range=Query($sql);
$gdateb=mysql_fetch_array($range);
$i=0;
while ($row = mysql_fetch_array($sel))
{
if ($i % 2) {
echo '<tr bgcolor="#f0f0e0"><td>'; }
else {
echo '<tr bgcolor="#e0e0f0"><td>'; }
echo ($row["Date"]).'</td><td>';
echo ($row["Size"]).'</td>';
$gsize[$i]=$row["Size"];
$gstart[$i]=$row["Udate"];
$gcap[$i]=$row["Capacity"];
$i++;
}
echo '</table><p>';
require_once('libraries/jpgraph.php');
require_once('libraries/jpgraph_line.php');
function TimeCallback($aVal) {
return Date('d/m-H:i',$aVal);
}
$title='DB size ';
$graph_name = 'images/db.png';
$graph = new graph(800, 500, $graph_name, 0, 0);
$graph->img->SetMargin(60, 50, 40, 90);
$graph->SetScale("intint",0,$gcap[$i-1],$gdatea["Start"],$gdateb["End"]);
$graph->xaxis->SetLabelFormatCallback('TimeCallback');
$graph->xaxis->SetLabelAngle(90);
$lineplot=new LinePlot($gsize,$gstart);
$lineplot->SetColor("blue");
$lineplot->SetWeight(2);
$graph->Add($lineplot);
$graph->SetMarginColor('white');
$graph->SetShadow();
$graph->title->Set($title);
$graph->yaxis->SetLabelAngle(90);
$graph->yaxis->title->Set("DB Size",CENTER);
$graph->xaxis->HideTicks(true,true);
$graph->legend->SetLayout(LEGEND_HOR);
$graph ->legend->Pos( 0.01,0.98,"left","bottom");
$graph->Stroke($graph_name);
print "<img src='{$graph_name}'>\n";
exit ();
}
?>
<form method="post">
<center>
<table bgcolor="#353268" cellspacing="0" cellpadding="0" border=1>
<tr bgcolor="#575582"><td colspan=4>
<h2><font color="#FFFFFF"> DB Informations </font></h2>
</td>
<td bgcolor="#d0d0ff"><center>Online <a href=help.php#tape>Help </a></center></td>
</tr>
<tr bgcolor="#e0e0f0">
<td> Date </td>
<td> Capacity MB </td>
<td> % utilized </td>
<td> Cache Hit % </td>
<td> Total Size </td>
</tr><tr bgcolor="#e0e0f0">
<td>
<?
include_once 'libraries/functions.php';
Connect();
$dbpct=90;
$sql = 'SELECT `Date` , `Capacity` , `Pct` , `Cache` FROM `DB` ORDER BY `Date` DESC LIMIT 1';
$sel=Query($sql);
$row = mysql_fetch_array($sel);
echo ($row["Date"]).'</td><td>';
echo ($row["Capacity"]).'</td>';
if ( $row["Pct"] > $dbpct )
echo '<td bgcolor="#ffd0d0">';
else echo '<td>';
echo ($row["Pct"]).'%</td><td>';
echo ($row["Cache"]).'</td><td>';
echo (($row["Capacity"]/100)*$row["Pct"]).'</td>';
echo '</tr></table>';
$sql = 'SELECT ( FROM_UNIXTIME( unix_timestamp( ) - 604800 )) AS Datea';
$sel=Query($sql);
$datea = mysql_fetch_array($sel);
$sql = 'SELECT ( curdate( ) ) AS Dateb';
$sel=Query($sql);
$dateb = mysql_fetch_array($sel);
echo '<INPUT TYPE=HIDDEN name="startdate" value="'.$datea["Datea"].'">';
echo '<INPUT TYPE=HIDDEN name="enddate" value="'.$dateb["Dateb"].'">';
?>
<INPUT TYPE=SUBMIT name="Elabora" value="Show last week Graph">
</FORM>
<form method="post">
<?
$sql = 'SELECT ( FROM_UNIXTIME( unix_timestamp( ) - 2678400 )) AS Datea';
$sel=Query($sql);
$datea = mysql_fetch_array($sel);
$sql = 'SELECT ( curdate( ) ) AS Dateb';
$sel=Query($sql);
$dateb = mysql_fetch_array($sel);
echo '<INPUT TYPE=HIDDEN name="startdate" value="'.$datea["Datea"].'">';
echo '<INPUT TYPE=HIDDEN name="enddate" value="'.$dateb["Dateb"].'">';
?>
<INPUT TYPE=SUBMIT name="Elabora" value="Show last month Graph"></center>
</FORM>
</body>
</html>