Start graph and import refactoring
[contractdashboard.git] / admin / importUNSPSC.php
blob:a/admin/importUNSPSC.php -> blob:b/admin/importUNSPSC.php
--- a/admin/importUNSPSC.php
+++ b/admin/importUNSPSC.php
@@ -1,5 +1,26 @@
 <?php
   include_once("../lib/common.inc.php");
+
+  // display existing
+
+$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>";
+}
+// import new from file
       $success = 0;
       $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
       echo " ============== $fname  ============== <br>";