1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 | <?php require_once ('jpgraph/jpgraph.php'); require_once ('jpgraph/jpgraph_line.php'); require_once ('jpgraph/jpgraph_log.php'); require_once ('jpgraph/jpgraph_mgraph.php'); require_once ('jpgraph/jpgraph_pie.php'); require_once ('jpgraph/jpgraph_bar.php'); require_once ('jpgraph/jpgraph_date.php'); $link = mysql_connect('localhost', 'root', ''); if (!$link) { die('Could not connect: ' . mysql_error()); } @mysql_select_db("contractDashboard") or die("Unable to select database"); function ucsmart($str) { return preg_replace("/(?<=(?<!:|’s)\W) (A|An|And|At|For|In|Of|On|Or|The|To|With) (?=\W)/e", 'strtolower("$1")', ucwords(strtolower($str))); } function percent($num_amount, $num_total) { $count1 = $num_amount / $num_total; $count2 = $count1 * 100; $count = number_format($count2, 2); return $count; } function array_sum_all($a) { if(!is_array($a)) return $a; foreach($a as $key=>$value) $totale += array_sum_all($value); return $totale; } $agency = mysql_real_escape_string(stripslashes($_REQUEST['agency'])); if ($agency != "") $agencyQ = "agencyName = '" . $agency . "' AND"; $supplier = mysql_real_escape_string(stripslashes($_REQUEST['supplier'])); if ($supplier != "") { $supplierParts = explode("-", $supplier); if ($supplierParts[0] > 0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND"; else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND"; } $year = mysql_real_escape_string(stripslashes($_REQUEST['year'])); if ($year != "") $yearQ = "agencyName = '" . $agency . "' AND"; $start =0.0; function include_header($title) { global $start; ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <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 type="text/css" rel="stylesheet" href="style.css"> </head> <body><div id="doc3" class="yui-t4"/> <div id="hd"> <h1> contract dashboard</h1> </div> <div id="sitenav"> <a href="displayAgency.php">agencies</a> <a href="displaySupplier.php">suppliers</a> <a href="displayCategory.php">product/service categories</a> <a href="displayCalendar.php">time periods</a> | metrics | <a href="displayProcurementMethod.php">procurement method</a> <a href="displayConfidentialities.php">contractual confidentiality</a> <a href="displayConsultancies.php">consultancies</a> <a href="displayMap.php">postcodes</a> <div id="search"> search <form><input type="text" id="searchKeywords"/></form></div> </div> <div id="bd" role="main"> <div id="yui-main"> <div class="yui-b"><div class="yui-g"> <? $start = (float) array_sum(explode(' ',microtime())); } function include_footer() { global $start; $end = (float) array_sum(explode(' ',microtime())); ?> </div> </div> </div> <div class="yui-b"> Filter by:<ul> <li>year <ul><li>2008</li> </ul> </li> </ul> <br> </div> </div> <? echo '<div id="ft"><p>'."Processing time: ". sprintf("%.4f", ($end-$start))." seconds".'</p></div>'; echo '</div> </body> </html>'; } ?> |