lotta updates
[contractdashboard.git] / lib / common.inc.php
blob:a/lib/common.inc.php -> blob:b/lib/common.inc.php
--- a/lib/common.inc.php
+++ b/lib/common.inc.php
@@ -92,7 +92,7 @@
 }
 function ucsmart($str) {
     $shortWords = Array("The", "Pty", "Ltd", "Inc", "Red", "Oil", "A", "An", "And", "At", "For", "In"
-        , "Of", "On", "Or", "The", "To", "With");
+        , "Of", "On", "Or", "The", "To", "With", "Use", "No", "Yes");
     $strArray = explode(" ",  preg_replace_callback("/(?<=(?<!:|’s)\W)
             (A|An|And|At|For|In|Of|On|Or|The|To|With)
             (?=\W)/",
@@ -363,10 +363,15 @@
             }
 
             function include_footer() {
-                global $start;
+                global $start, $conn;
                 $end = (float) array_sum(explode(' ', microtime()));
 
-                echo '</div>  <footer>' . "Processing time: " . sprintf("%.4f", ($end - $start)) . " seconds" . '  <footer>';
+        $query = 'SELECT DATE("importDate") FROM contractnotice ORDER BY "importDate" DESC limit 1';
+        $query = $conn->prepare($query);
+        $query->execute();
+        databaseError($conn->errorInfo());
+        $last_update = reset($query->fetchAll())[0];
+                echo '</div>  <footer>' . "Last updated: ".$last_update." Processing time: " . sprintf("%.4f", ($end - $start)) . " seconds" . '  <footer>';
 
                     if (strpos($_SERVER['SERVER_NAME'], ".gs")) {
                     ?>