[contractdashboard.git] / displayCalendar.php
--- a/displayCalendar.php
+++ b/displayCalendar.php
@@ -16,7 +16,16 @@
 echo '<img src="graphs/displayMethodCountGraph.php?month=' . stripslashes($supplier) . '">';

    echo '<img src="graphs/displayCnCGraph.php?month=' . stripslashes($supplier) . '">';

 

-  echo "<table>";

+  echo "<table>  <thead>

+    <tr>

+      <th>Contract Notice Number</th>

+      <th>Contract Description</th>

+      <th>Total Contract Value</th>

+      <th>Agency</th>

+      <th>Contract Start Date</th>

+      <th>Supplier</th>

+    </tr>

+  </thead>";

   while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

     setlocale(LC_MONETARY, 'en_US');

     $value = number_format(doubleval($row['value']) , 2);

@@ -47,7 +56,13 @@
 SUM(value) as val, count(1) as count FROM `contractnotice` WHERE childCN = 0 GROUP BY MONTH(contractStart), YEAR(contractStart) ORDER BY YEAR(contractStart), MONTH(contractStart) ";

 

 $result = mysql_query($query);

-echo "<table>";

+  echo "<table>  <thead>

+    <tr>

+      <th>Month/Year</th>

+      <th>Total Contracts Value</th>

+      <th>Number of Contracts</th>

+    </tr>

+  </thead>";

 while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {

 setlocale(LC_MONETARY, 'en_US');

 $value = number_format(doubleval($row["val"]),2);