<?php
error_reporting(E_ALL);
  include_once("../lib/common.inc.php");
 
 
$unspscresult= $conn->prepare('select * from "UNSPSCcategories";');
$unspscresult->execute();
foreach ($unspscresult->fetchAll() as $row) {
        $unspsc[$row['UNSPSC']] = $row['Title'];
 
}
$catsresult = $conn->prepare('SELECT substr( "categoryUNSPSC"::text, 0, 2 ) as cat , SUM( "value" ) as value
FROM contractnotice
GROUP BY cat ;');
echo "<table>";
$catsresult->execute();
foreach ($catsresult->fetchAll() as $row) {
        $catName = $unspsc[$row['cat']."0000000"].$row['cat'];
        if ($row['cat'] == "") $catName = "null";
        
        echo "<tr><td>$catName</td><td>".$row['value']."</td></tr>";
}
?>