<?php
include_once ("../lib/common.inc.php");
function fetchSON($SONID)
{
    global $conn;
    echo $SONID;
 
# Create a search parser object
    $search = new DOMDocument();
    $doc = new DOMDocument();
 
# Parse the HTML from Google.
# The @ before the method call suppresses any warnings that
# loadHTML might throw because of invalid HTML in the page.
    @$search->loadHTML(file_get_contents("https://www.tenders.gov.au/?event=public.advancedsearch.CNSONRedirect&type=sonSearchEvent&SONID=$SONID"));
 
# Iterate over all the <a> tags
    foreach ($search->getElementsByTagName('a') as $link) {
        # Show the <a href>
        if (strpos($link->getAttribute('href'), 'UUID')) {
            echo $link->getAttribute('href');
            @$doc->loadHTML(file_get_contents("https://www.tenders.gov.au".$link->getAttribute('href')));
        }
    }
 
    //TODO update title from $x("//p[@class='lead']/text()")
 
 
    $sql='insert into standingoffer_suppliers("SONID",name,abn,state,postcode) values(?,?,?,?,?)';
    $q=$conn->prepare($sql);
 
    foreach($doc->getElementsByTagName('tr') as $row) {
        $supplier = Array("SONID"=>$SONID);
        $i = 0;
        foreach ($row->childNodes as $column){
            //echo $i;
            if ($i==0) $supplier['name'] = $column->textContent;
            if ($i==2) $supplier['abn'] = trim(str_replace(' ','',$column->textContent));
            if ($i==4) $supplier['state'] = $column->textContent;
            if ($i==6) $supplier['postcode'] = $column->textContent;
            //echo $column->textContent;
        $i++;
    }
    //print_r($supplier);
        $q->execute(array_values($supplier));
    }
}
if ($_REQUEST['SONID']) {
    fetchSON($_REQUEST['SONID']);
}