--- a/getAgency.php
+++ b/getAgency.php
@@ -1,57 +1,24 @@
head('_design/app')->headers->_HTTP->status != "404") return true;
- }
- catch(Exception $e) {
- //database issue
- return false;
- }
- $ddoc = new StdClass();
- $ddoc->_id = '_design/app';
- $ddoc->views = new StdClass();
- // by abn, by name
- $ddoc->views->byABN = new StdClass();
- $ddoc->views->byABN->map = "function(doc) { emit(doc.ABN, doc); };";
- $ddoc->views->byName = new StdClass();
- $ddoc->views->byName->map = "function(doc) { emit(doc.name, doc); };";
- $ddoc->views->getActive = new StdClass();
- $ddoc->views->getActive->map = 'function(doc) { if (doc.status == "active") { emit(doc._id, doc); } };';
- $ddoc->views->getSuspended = new StdClass();
- $ddoc->views->getSuspended->map = 'function(doc) { if (doc.status == "suspended") { emit(doc._id, doc); } };';
- $ddoc->views->getScrapeRequired = new StdClass();
- $ddoc->views->getScrapeRequired->map = "function(doc) { emit(doc.ABN, doc); };";
- try {
- $sag->put('_design/app', $ddoc);
- }
- catch(Exception $e) {
- /*
- * A 409 status code means there was a conflict, so another client
- * already created the design doc for us. This is fine.
- */
- if ($e->getCode() != 409) return false;
- }
- return true;
-}
-require_once 'sag/src/Sag.php';
-$sag = new Sag();
+
+include_once('common.inc.php');
+include_header();
+
$sag->setDatabase("disclosr-agencies", true);
//get an agency record as json/html, search by name/abn/id
// by name = startkey="Ham"&endkey="Ham\ufff0"
// edit?
-createAgencyDesignDoc();
$rows = $sag->get('/_design/app/_view/byABN?include_docs=true')->body->rows; // &endkey='.$searchVar
foreach ($rows as $row) {
- echo "
";
- echo ' ' . $row->doc->agencyName. " |
";
- echo "Field Name | Field Value |
";
- foreach ($row->doc as $key => $value) {
- echo "$key | $value |
";
+ echo "";
+ echo ' ' . $row->doc->agencyName . " |
";
+ echo "Field Name | Field Value |
";
+foreach ($row->doc as $key => $value) {
+ if (is_a($value, 'stdClass')) {
+ echo "$key | ".var_dump($value,true)." |
";
+ } else echo "$key | $value |
";
} // also show documents/URLs available
- echo "
";
+
+ echo "
";
}
+include_footer();