--- a/admin/importUNSPSC.php
+++ b/admin/importUNSPSC.php
@@ -1,7 +1,32 @@
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 "
";
+$catsresult->execute();
+foreach ($catsresult->fetchAll() as $row) {
+ $catName = $unspsc[$row['cat']."0000000"].$row['cat'];
+ if ($row['cat'] == "") $catName = "null";
+
+ echo "$catName | ".$row['value']." |
";
+}
+// import new from file
$success = 0;
- $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
+// $fname = "UNSPSC_ECCMA_V13.2_UNDP_V7.csv";
+ $fname = "AusTenderCustomisedUNSPSCCodeSet-August2012.csv";
echo " ============== $fname ==============
";
flush();
$row = 1;
@@ -11,22 +36,26 @@
while (($data = fgetcsv($handle, 1000)) !== false) {
$num = count($data);
- if ($row == 3) {
+/* if ($row == 3) {
$headers = $data;
} elseif ($row > 3) {
//print_r($data);
-$query = "insert into UNSPSCcategories values(".$data[1].",'$data[2]');";
-//echo $query."
\n";
-mysql_query($query);
+$query = 'insert into "UNSPSCcategories" values(".$data[1].","$data[2]");'; */
+$query = 'delete from "UNSPSCcategories" where "UNSPSC" = '.$data[0].'; insert into "UNSPSCcategories" values('.$data[0].',\''.trim($data[1]).'\');';
+echo $query."
\n";
+$conn->exec($query);
+print_r($conn->errorInfo());
+
flush();
//echo "
\n";
- }
+/* }*/
$row++;
}
echo "
$success records successfully created";
flush();
fclose($handle);
+}
?>