--- a/displayAgency.php +++ b/displayAgency.php @@ -23,6 +23,37 @@ Breakdown percentage,number,value by procurement type Histograph, overlaying number value reported per week over X years Compliance statistics: amendments, delay in reporting average and number completely late*/ + + $query = "SELECT CNID, description, value, agencyName, category, contractStart, supplierName + FROM `contractnotice` + WHERE agencyName = '".mysql_real_escape_string($agency)."' + ORDER BY value DESC"; + echo $query; + $result = mysql_query($query); + + 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); + echo ("<tr> + <td><a href=\"displayContract.php?CNID={$row['CNID']}\">{$row['CNID']}</a></td> + <td><b>{$row['description']}</b></a></td> + <td>\$$value</td><td>{$row['agencyName']}</td> + <td>{$row['contractStart']}</td> + <td>{$row['supplierName']}</td> + </tr>"); + } + echo "</table>"; + mysql_free_result($result); } else { /* split by portfolio @@ -33,7 +64,12 @@ WHERE childCN = 0 GROUP BY agencyName "; $result = mysql_query($query); - echo "<table>"; + echo "<table> <thead> + <tr> + <th>Agency</th> + <th>Total Contracts Value</th> + </tr> + </thead>"; while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { setlocale(LC_MONETARY, 'en_US'); $value = number_format(doubleval($row[0]) , 2);