confidentialityies
[contractdashboard.git] / admin / updateUNSPSC.php
blob:a/admin/updateUNSPSC.php -> blob:b/admin/updateUNSPSC.php
--- a/admin/updateUNSPSC.php
+++ b/admin/updateUNSPSC.php
@@ -7,9 +7,10 @@
 $unspscresult = $conn->prepare('select * from "UNSPSCcategories";');
 $unspscresult->execute();
 foreach ($unspscresult->fetchAll() as $row) {
+    $row['Title'] = strtolower($row['Title']);
     $unspsc[strtolower($row['Title'])] = $row['UNSPSC'];
     // some Australian spellings
-/*    $isiz = str_replace("iz", "is", $row['Title']);
+    $isiz = str_replace("iz", "is", $row['Title']);
     $unspsc[$isiz] = $row['UNSPSC'];
     $filfill = str_replace("fill", "fil", $row['Title']);
     $unspsc[$filfill] = $row['UNSPSC'];
@@ -50,7 +51,7 @@
     
     // some just plain wrong
     $noOilRigs = str_replace("Building and Construction and Maintenance Services", "Management and provision of all facilities engineering modification and maintenance services for a site or platform", $row['Title']);
-    $unspsc[$noOilRigs] = $row['UNSPSC'];*/
+    $unspsc[$noOilRigs] = $row['UNSPSC'];
 }
 //print_r($unspsc);
 $query = 'SELECT "CNID",lower("category") as category,"value"