<?php
|
<?php
|
|
date_default_timezone_set("Australia/ACT"); |
|
|
require_once ('jpgraph/jpgraph.php');
|
require_once ('jpgraph/jpgraph.php');
|
require_once ('jpgraph/jpgraph_line.php');
|
require_once ('jpgraph/jpgraph_line.php');
|
require_once ('jpgraph/jpgraph_log.php');
|
require_once ('jpgraph/jpgraph_log.php');
|
require_once ('jpgraph/jpgraph_mgraph.php');
|
require_once ('jpgraph/jpgraph_mgraph.php');
|
require_once ('jpgraph/jpgraph_pie.php');
|
require_once ('jpgraph/jpgraph_pie.php');
|
require_once ('jpgraph/jpgraph_bar.php');
|
require_once ('jpgraph/jpgraph_bar.php');
|
require_once ('jpgraph/jpgraph_date.php');
|
require_once ('jpgraph/jpgraph_date.php');
|
|
|
error_reporting(E_ALL ^ E_NOTICE);
|
error_reporting(E_ALL ^ E_NOTICE);
|
|
|
|
|
$link = mysql_connect('localhost', 'root', '');
|
$link = mysql_connect('localhost', 'root', '');
|
if (!$link) {
|
if (!$link) {
|
die('Could not connect: ' . mysql_error());
|
die('Could not connect: ' . mysql_error());
|
}
|
}
|
@mysql_select_db("contractDashboard") or die("Unable to select database");
|
@mysql_select_db("contractDashboard") or die("Unable to select database");
|
|
|
function ucsmart($str) {
|
function ucsmart($str) {
|
return preg_replace("/(?<=(?<!:|’s)\W)
|
return preg_replace("/(?<=(?<!:|’s)\W)
|
(A|An|And|At|For|In|Of|On|Or|The|To|With)
|
(A|An|And|At|For|In|Of|On|Or|The|To|With)
|
(?=\W)/e", 'strtolower("$1")', ucwords(strtolower($str)));
|
(?=\W)/e", 'strtolower("$1")', ucwords(strtolower($str)));
|
}
|
}
|
|
|
function percent($num_amount, $num_total) {
|
function percent($num_amount, $num_total) {
|
$count1 = $num_amount / $num_total;
|
$count1 = $num_amount / $num_total;
|
$count2 = $count1 * 100;
|
$count2 = $count1 * 100;
|
$count = number_format($count2, 2);
|
$count = number_format($count2, 2);
|
return $count;
|
return $count;
|
}
|
}
|
function array_sum_all($a) {
|
function array_sum_all($a) {
|
if(!is_array($a)) return $a;
|
if(!is_array($a)) return $a;
|
foreach($a as $key=>$value)
|
foreach($a as $key=>$value)
|
$totale += array_sum_all($value);
|
$totale += array_sum_all($value);
|
return $totale;
|
return $totale;
|
}
|
}
|
|
// magic query modifiers |
$agency = mysql_real_escape_string(stripslashes($_REQUEST['agency']));
|
$agency = mysql_real_escape_string(stripslashes($_REQUEST['agency']));
|
if ($agency != "") $agencyQ = "agencyName = '" . $agency . "' AND"; |
if ($agency != "") $agencyQ = "agencyName = '" . $agency . "' AND "; |
$supplier = mysql_real_escape_string(stripslashes($_REQUEST['supplier']));
|
$supplier = mysql_real_escape_string(stripslashes($_REQUEST['supplier']));
|
if ($supplier != "") {
|
if ($supplier != "") {
|
$supplierParts = explode("-", $supplier);
|
$supplierParts = explode("-", $supplier);
|
if ($supplierParts[0] > 0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND"; |
if ($supplierParts[0] > 0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND "; |
else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND"; |
else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND "; |
}
|
}
|
$year = mysql_real_escape_string(stripslashes($_REQUEST['year']));
|
$year = mysql_real_escape_string(stripslashes($_REQUEST['year']));
|
if ($year != "") $yearQ = "agencyName = '" . $agency . "' AND"; |
if ($year != "") $yearQ = "YEAR(publishDate) = " . $year . " AND "; |
|
|
$start =0.0;
|
$start =0.0;
|
|
|
function include_header($title) {
|
function include_header($title) {
|
global $start;
|
global $start;
|
?>
|
?>
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
|
"http://www.w3.org/TR/html4/strict.dtd">
|
"http://www.w3.org/TR/html4/strict.dtd">
|
<html>
|
<html>
|
<head>
|
<head>
|
<title>Contract Dashboard - <?=$title?></title>
|
<title>Contract Dashboard - <?=$title?></title>
|
<link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset-fonts-grids/reset-fonts-grids.css">
|
<link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset-fonts-grids/reset-fonts-grids.css">
|
<link type="text/css" rel="stylesheet" href="style.css">
|
<link type="text/css" rel="stylesheet" href="style.css">
|
<script type="text/javascript" src="lib/bsn.AutoSuggest_2.1.3_comp.js" charset="utf-8"></script>
|
<script type="text/javascript" src="lib/bsn.AutoSuggest_2.1.3_comp.js" charset="utf-8"></script>
|
|
|
<link rel="stylesheet" href="autosuggest_inquisitor.css" type="text/css" media="screen" charset="utf-8" />
|
<link rel="stylesheet" href="autosuggest_inquisitor.css" type="text/css" media="screen" charset="utf-8" />
|
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
|
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
|
<script type="text/javascript">
|
<script type="text/javascript">
|
$(document).ready(function()
|
$(document).ready(function()
|
{
|
{
|
//hide the all of the element with class msg_body
|
//hide the all of the element with class msg_body
|
$(".msg_body").hide();
|
$(".msg_body").hide();
|
//toggle the componenet with class msg_body
|
//toggle the componenet with class msg_body
|
$(".msg_head").click(function()
|
$(".msg_head").click(function()
|
{
|
{
|
$(this).next(".msg_body").slideToggle(600);
|
$(this).next(".msg_body").slideToggle(600);
|
});
|
});
|
});
|
});
|
</script>
|
</script>
|
</head>
|
</head>
|
<body><div id="doc3" class="yui-t4">
|
<body><div id="doc3" class="yui-t4">
|
<div id="hd">
|
<div id="hd">
|
<h1> contract dashboard</h1>
|
<h1> contract dashboard</h1>
|
</div>
|
</div>
|
<div id="sitenav">
|
<div id="sitenav">
|
<a href="displayAgency.php">agencies</a>
|
<a href="displayAgency.php">agencies</a>
|
<a href="displaySupplier.php">suppliers</a>
|
<a href="displaySupplier.php">suppliers</a>
|
<a href="displayCategory.php">product/service categories</a>
|
<a href="displayCategory.php">product/service categories</a>
|
<a href="displayCalendar.php">time periods</a>
|
<a href="displayCalendar.php">time periods</a>
|
| metrics |
|
| metrics |
|
<a href="displayProcurementMethod.php">procurement method</a>
|
<a href="displayProcurementMethod.php">procurement method</a>
|
<a href="displayConfidentialities.php">contractual confidentiality</a>
|
<a href="displayConfidentialities.php">contractual confidentiality</a>
|
<a href="displayConsultancies.php">consultancies</a>
|
<a href="displayConsultancies.php">consultancies</a>
|
<a href="displayAmendments.php">consultancies</a> |
<a href="displayAmendments.php">amendments</a> |
<a href="displayMap.php">postcodes</a>
|
<a href="displayMap.php">postcodes</a>
|
<div id="search"><form method="post" action="search.php" class="asholder">
|
<div id="search"><form method="post" action="search.php" class="asholder">
|
<label for="searchKeyword">search</label>
|
<label for="searchKeyword">search</label>
|
<input type="text" id="searchKeyword" name="searchKeyword" value="" style="width:150px" />
|
<input type="text" id="searchKeyword" name="searchKeyword" value="" style="width:150px" />
|
<input type="hidden" id="searchID" name="searchID" value=""/><input type="submit" value="submit" />
|
<input type="hidden" id="searchID" name="searchID" value=""/><input type="submit" value="submit" />
|
</form></div>
|
</form></div>
|
<script type="text/javascript">
|
<script type="text/javascript">
|
|
|
var options_xml = {
|
var options_xml = {
|
script: function (input) { return "search_autosuggest.php?input="+input; },
|
script: function (input) { return "search_autosuggest.php?input="+input; },
|
varname:"input",
|
varname:"input",
|
callback: function (obj) { document.getElementById('searchID').value = obj.id; }
|
callback: function (obj) { document.getElementById('searchID').value = obj.id; }
|
};
|
};
|
var as_xml = new bsn.AutoSuggest('searchKeyword', options_xml);
|
var as_xml = new bsn.AutoSuggest('searchKeyword', options_xml);
|
</script>
|
</script>
|
|
|
</div>
|
</div>
|
<div id="bd" role="main">
|
<div id="bd" role="main">
|
<div id="yui-main">
|
<div id="yui-main">
|
<div class="yui-b"><div class="yui-g">
|
<div class="yui-b"><div class="yui-g">
|
<?php
|
<?php
|
$start = (float) array_sum(explode(' ',microtime()));
|
$start = (float) array_sum(explode(' ',microtime()));
|
}
|
}
|
|
|
function include_footer() {
|
function include_footer() {
|
global $start;
|
global $start;
|
$end = (float) array_sum(explode(' ',microtime()));
|
$end = (float) array_sum(explode(' ',microtime()));
|
?>
|
?>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
</div>
|
<div class="yui-b">
|
<div class="yui-b">
|
Filter by:<ul>
|
Filter by:<ul>
|
<li>year
|
<li>year
|
<ul><li>2008</li>
|
<ul><li>2008</li>
|
</ul>
|
</ul>
|
</li>
|
</li>
|
</ul> <br> </div> </div>
|
</ul> <br> </div> </div>
|
|
|
<?php
|
<?php
|
echo '<div id="ft"><p>'."Processing time: ". sprintf("%.4f", ($end-$start))." seconds".'</p></div>';
|
echo '<div id="ft"><p>'."Processing time: ". sprintf("%.4f", ($end-$start))." seconds".'</p></div>';
|
echo '</div> </body> </html>';
|
echo '</div> </body> </html>';
|
}
|
}
|
?>
|
?>
|
|
|