<?php
|
<?php
|
|
|
include_once("./lib/common.inc.php");
|
include_once("./lib/common.inc.php");
|
/*
|
/*
|
|
|
biggest suppliers in each method
|
biggest suppliers in each method
|
biggest agencies in each method (weighted for size? percentage of total expenditure)
|
biggest agencies in each method (weighted for size? percentage of total expenditure)
|
|
|
largest Average value by procurement type?
|
largest Average value by procurement type?
|
*/
|
*/
|
|
|
include_header("Procurement Methods");
|
include_header("Procurement Methods");
|
$query = "SELECT value, procurementMethod |
$query = "SELECT SUM(value) as value, procurementMethod |
FROM `contractnotice`
|
FROM `contractnotice`
|
|
WHERE childCN = 0 |
GROUP BY procurementMethod ";
|
GROUP BY procurementMethod ";
|
|
|
$result = mysql_query($query);
|
$result = mysql_query($query);
|
|
|
echo "<table>";
|
echo "<table>";
|
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
|
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
|
setlocale(LC_MONETARY, 'en_US');
|
setlocale(LC_MONETARY, 'en_US');
|
$value = number_format(doubleval($row[0]),2);
|
$value = number_format(doubleval($row[0]),2);
|
echo ("<tr><td><b>{$row[1]}</b></td><td>\$$value</td></tr>");
|
echo ("<tr><td><b>{$row[1]}</b></td><td>\$$value</td></tr>");
|
}
|
}
|
echo "</table>";
|
echo "</table>";
|
mysql_free_result($result);
|
mysql_free_result($result);
|
include_footer();
|
include_footer();
|
?>
|
?>
|
|
|
|
|
|
|