--- a/admin/verify.php +++ b/admin/verify.php @@ -1,1 +1,56 @@ +get_db('disclosr-agencies'); +$docs = Array(); +try { + $rows = $db->get_view("app", "byABN")->rows; + //print_r($rows); + foreach ($rows as $row) { + $docs["a" . $row->key] = $row->value; + } +} catch (SetteeRestClientException $e) { + setteErrorHandler($e); +} +//print_r($docs); +$row = 1; +if (($handle = fopen("cacfma.csv", "r")) !== FALSE) { + while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { + $row++; + echo $data[0] . " " . str_replace("?", "", $data[1]) . "
\n"; + $name = $data[0]; + $abn = trim(str_replace("?", "", $data[1])); + $aabn = "a".$abn; + if (isset($docs[$aabn])) { + echo "Existing agency ABN detected
"; + if (!in_array($name, object_to_array($docs[$aabn]->otherNames)) && $name != $docs[$aabn]->name) { + $docs[$aabn]->otherNames[] = $name; + try { + $docs[$aabn] = $db->save($docs[$aabn]); + //print_r($doc); + echo $abn . " additional names imported \n
"; + } catch (SetteeRestClientException $e) { + setteErrorHandler($e); + } + } + } else { + echo "New agency ABN detected
"; + $agency['_id'] = md5($aabn); + $agency['name'] = $name; + $agency["abn"] = $abn; + try { + $doc = $db->save($agency); + print_r($doc); + echo $abn . " imported \n
"; + } catch (SetteeRestClientException $e) { + setteErrorHandler($e); + } + } + echo "
"; + } + fclose($handle); +} +include_footer(); +?>