--- a/admin/importUNSPSC.php +++ b/admin/importUNSPSC.php @@ -1,5 +1,29 @@ <?php - include_once("../lib/common.inc.php"); +if (php_sapi_name() != "cli") { + +include_once ("../lib/common.inc.php"); +auth(); + + // 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>"; @@ -15,9 +39,9 @@ $headers = $data; } elseif ($row > 3) { //print_r($data); -$query = "insert into UNSPSCcategories values(".$data[1].",'$data[2]');"; +$query = 'insert into "UNSPSCcategories" values(".$data[1].","$data[2]");'; //echo $query."<br>\n"; -mysql_query($query); +$conn->exec($query); flush(); //echo "<hr>\n"; @@ -28,5 +52,6 @@ echo "<br> $success records successfully created"; flush(); fclose($handle); +} ?>