[contractdashboard.git] / about.php
--- a/about.php
+++ b/about.php
@@ -1,61 +1,61 @@
-<?php

-include('./lib/common.inc.php');

-include_header("Map");

-?>

-

-<div class="msg_list">

-    <p class="msg_head">Header-1 </p>

-    <div class="msg_body">

-        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit

-    </div>

-    <p class="msg_head">Header-2</p>

-    <div class="msg_body">

-        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit

-    </div>

-    <p class="msg_head">Header-3</p>

-    <div class="msg_body">

-        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit

-    </div>

-</div>

-<?php

-CNDistributionGraph();

-// select distinct cnid, "publishDate" from (select ("CNID" - MOD("CNID",100)) as cnid from contractnotice where "CNID" < 999999) as a, contractnotice where a.cnid = contractNotice."CNID" order by cnid

-?>

-

-sourced from austender

-

-Government Agency Information (2009-07-10): National Archives of Australia, http://www.naa.gov.au under Creative Commons - Attribution 2.5 Australia (CC-BY)

-

-ABR

-

-<?php

-include_once("./lib/common.inc.php");

-$query = 'SELECT DATE("importDate") as importday, count(*) as count, min("publishDate") as start, max("publishDate") as end 

-FROM contractnotice WHERE "childCN" is null AND "parentCN" is null AND DATE("importDate") = (select * from (SELECT DATE("importDate") 

-FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")';

-$query = $conn->prepare($query);

-$query->execute();

-databaseError($conn->errorInfo());

-echo "<div>";

-$stats = $query->fetch(PDO::FETCH_ASSOC);

-echo $stats["count"] . " new records in period " . $stats["start"] . "  to " . $stats["end"] . "<br>";

-

-

-$query = 'SELECT DATE("importDate") as importday, count(*) as count, min("publishDate") as start, max("publishDate") as end 

-FROM contractnotice WHERE ("childCN" is not null OR "parentCN" is not null) AND DATE("importDate") = (select * from (SELECT DATE("importDate") 

-FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")';

-$query = $conn->prepare($query);

-$query->execute();

-databaseError($conn->errorInfo());

-echo "<div>";

-$stats = $query->fetch(PDO::FETCH_ASSOC);

-echo $stats["count"] . " updated records in period " . $stats["start"] . "  to " . $stats["end"] . "<br>";

-

-

-echo "Last updated: " . $stats["importday"] . "<br>";

-/* Check for null Procurement method and 0 ABN when not ABN exempt */

-

-

-include_footer();

-?>

+<?php
+include('./lib/common.inc.php');
+include_header("Map");
+?>
 
+<div class="msg_list">
+    <p class="msg_head">Header-1 </p>
+    <div class="msg_body">
+        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit
+    </div>
+    <p class="msg_head">Header-2</p>
+    <div class="msg_body">
+        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit
+    </div>
+    <p class="msg_head">Header-3</p>
+    <div class="msg_body">
+        orem ipsum dolor sit amet, consectetuer adipiscing elit orem ipsum dolor sit amet, consectetuer adipiscing elit
+    </div>
+</div>
+<?php
+CNDistributionGraph();
+// select distinct cnid, "publishDate" from (select ("CNID" - MOD("CNID",100)) as cnid from contractnotice where "CNID" < 999999) as a, contractnotice where a.cnid = contractNotice."CNID" order by cnid
+?>
+
+sourced from austender
+
+Government Agency Information (2009-07-10): National Archives of Australia, http://www.naa.gov.au under Creative Commons - Attribution 2.5 Australia (CC-BY)
+
+ABR
+
+<?php
+include_once("./lib/common.inc.php");
+$query = 'SELECT DATE("importDate") as importday, count(*) as count, min("publishDate") as start, max("publishDate") as end 
+FROM contractnotice WHERE "childCN" is null AND "parentCN" is null AND DATE("importDate") = (select * from (SELECT DATE("importDate") 
+FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+echo "<div>";
+$stats = $query->fetch(PDO::FETCH_ASSOC);
+echo $stats["count"] . " new records in period " . $stats["start"] . "  to " . $stats["end"] . "<br>";
+
+
+$query = 'SELECT DATE("importDate") as importday, count(*) as count, min("publishDate") as start, max("publishDate") as end 
+FROM contractnotice WHERE ("childCN" is not null OR "parentCN" is not null) AND DATE("importDate") = (select * from (SELECT DATE("importDate") 
+FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) GROUP BY DATE("importDate")';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+echo "<div>";
+$stats = $query->fetch(PDO::FETCH_ASSOC);
+echo $stats["count"] . " updated records in period " . $stats["start"] . "  to " . $stats["end"] . "<br>";
+
+
+echo "Last updated: " . $stats["importday"] . "<br>";
+/* Check for null Procurement method and 0 ABN when not ABN exempt */
+
+
+include_footer();
+?>
+