gitphp 0.2.9.1 :: contractdashboard.git/blame

<?php
date_default_timezone_set("Australia/ACT");
 
error_reporting(E_ALL ^ E_NOTICE);
 
 
$conn = new PDO("pgsql:dbname=contractDashboard;user=postgres;password=snmc;host=localhost");
 
if (!$conn) {
        die("A database error occurred.\n");
}
 
 //   $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
function databaseError($errMsg)
{
    if ($errMsg[2] != "") {
        die(print_r($errMsg,true));
    }
}
 
function ucsmart($str) {
  $shortWords = Array("The","Pty","Ltd","Inc","Red","Oil","A","An","And","At","For","In"
                      ,"Of","On","Or","The","To","With");
  $strArray =  explode(" ",preg_replace("/(?<=(?<!:|’s)\W)
            (A|An|And|At|For|In|Of|On|Or|The|To|With)
            (?=\W)/e", 'strtolower("$1")', ucwords(strtolower($str))));
  foreach($strArray as &$word) {
    if (strlen($word) <= 4 && !in_array($word,$shortWords)) $word = strtoupper($word);
  }
  return implode(" ",$strArray);
}
 
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; 
 }
// magic query modifiers
$agency = filter_var($_REQUEST['agency'], FILTER_SANITIZE_STRING);
if ($agency != "") $agencyQ = "agencyName = '" . $agency . "' AND ";
 
$supplier = filter_var($_REQUEST['supplier'], FILTER_SANITIZE_STRING);
if ($supplier != "") {
  $supplierParts = explode("-", $supplier);
  $supplierName = "%".$supplierParts[1]."%";
  $supplierABN = $supplierParts[0];
  if ($supplierParts[0] > 0) $supplierQ = ' "supplierABN" = :supplierABN AND ';
  else $supplierQ = ' "supplierName" LIKE :supplierName AND ';
}
 
$startYear = 2007;
$year = filter_var($_REQUEST['year'], FILTER_SANITIZE_NUMBER_INT);
if ($year != "") $yearQ = "YEAR(publishDate) = " . $year . " AND ";
 
$standardQ = ' "childCN" is null '; // AND YEAR(contractStart) >= 2007 AND YEAR(contractStart) <= 2010';
$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 - <?php echo $title; ?></title>
        <link rel="stylesheet" type="text/css" href="http://yui.yahooapis.com/2.8.0r4/build/reset-fonts-grids/reset-fonts-grids.css"> 
 
            <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" />
            <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
  //hide the all of the element with class msg_body
  $(".msg_body").hide();
  //toggle the componenet with class msg_body
  $(".msg_head").click(function()
  {
    $(this).next(".msg_body").slideToggle(600);
  });
});
</script>
 
                <style type="text/css" title="currentStyle"> 
                        @import "media/css/demo_table.css";
                </style> 
                <script type="text/javascript" language="javascript" src="media/js/jquery.dataTables.js"></script> 
                <script type="text/javascript" charset="utf-8"> 
jQuery.fn.dataTableExt.aTypes.unshift(  
    function ( sData )  
    {  
        var sValidChars = "0123456789.-,";  
        var Char;  
          
        /* Check the numeric part */  
        for ( i=1 ; i<sData.length ; i++ )   
        {   
            Char = sData.charAt(i);   
            if (sValidChars.indexOf(Char) == -1)   
            {  
                return null;  
            }  
        }  
          
        /* Check prefixed by currency */  
        if ( sData.charAt(0) == '$' || sData.charAt(0) == '£' )  
        {  
            return 'currency';  
        }  
        return null;  
    }  
);
jQuery.fn.dataTableExt.oSort['currency-asc'] = function(a,b) {
        /* Remove any commas (assumes that if present all strings will have a fixed number of d.p) */
        var x = a == "-" ? 0 : a.replace( /,/g, "" );
        var y = b == "-" ? 0 : b.replace( /,/g, "" );
        
        /* Remove the currency sign */
        x = x.substring( 1 );
        y = y.substring( 1 );
        
        /* Parse and return */
        x = parseFloat( x );
        y = parseFloat( y );
        return x - y;
};
 
jQuery.fn.dataTableExt.oSort['currency-desc'] = function(a,b) {
        /* Remove any commas (assumes that if present all strings will have a fixed number of d.p) */
        var x = a == "-" ? 0 : a.replace( /,/g, "" );
        var y = b == "-" ? 0 : b.replace( /,/g, "" );
        
        /* Remove the currency sign */
        x = x.substring( 1 );
        y = y.substring( 1 );
        
        /* Parse and return */
        x = parseFloat( x );
        y = parseFloat( y );
        return y - x;
};
                        $(document).ready(function() {
                                $('table').dataTable();
                        } );
                </script> 
        <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="displayAmendments.php">amendments</a>
            <a href="displayMap.php">postcodes</a>
            <div id="search"><form method="post" action="search.php" class="asholder">
        <label for="searchKeyword">search</label>
        <input type="text" id="searchKeyword" name="searchKeyword"  value="" style="width:150px" />
        <input type="hidden" id="searchID" name="searchID" value=""/><input type="submit" value="submit" />
</form></div>
            <script type="text/javascript">
        
        var options_xml = {
                script: function (input) { return "search_autosuggest.php?input="+input; },
                varname:"input",
                callback: function (obj) { document.getElementById('searchID').value = obj.id; }
        };
        var as_xml = new bsn.AutoSuggest('searchKeyword', options_xml);
</script>
 
            </div>
             <div id="bd" role="main"> 
    <div id="yui-main"> 
        <div class="yui-b"><div class="yui-g">
<?php
$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>
     
    <?php
   echo '<div id="ft"><p>'."Processing time: ". sprintf("%.4f", ($end-$start))." seconds".'</p></div>'; 
   echo '</div> </body> </html>';
} 
include ("graphs.inc.php");
?>