Record listing and individual viewing
[disclosr.git] / getAgency.php
blob:a/getAgency.php -> blob:b/getAgency.php
<?php <?php
   
include_once('common.inc.php'); include_once('common.inc.php');
include_header(); include_header();
$db = $server->get_db('disclosr-agencies'); $db = $server->get_db('disclosr-agencies');
//get an agency record as json/html, search by name/abn/id if (isset($_REQUEST['id'])) {
  //get an agency record as json/html, search by name/abn/id
// by name = startkey="Ham"&endkey="Ham\ufff0" // by name = startkey="Ham"&endkey="Ham\ufff0"
// edit? // edit?
$rows = $db->get_view("app","byABN")->rows;  
//print_r($rows); $row = $db->get($_REQUEST['id']);
foreach ($rows as $row) { //print_r($row);
  echo '<table width="100%">';
echo "<table>"; echo '<tr> <td colspan="2"><h3>' . $row->name . "</h3></td></tr>";
echo '<tr> <td colspan="2"><h3>' . $row->value->name . "</h3></td></tr>";  
echo "<tr><th>Field Name</th><th>Field Value</th></tr>"; echo "<tr><th>Field Name</th><th>Field Value</th></tr>";
foreach ($row->value as $key => $value) { foreach ($row as $key => $value) {
if (is_a($value, 'stdClass')) { if (is_a($value, 'stdClass')) {
echo "<tr><td>$key</td><td>".var_dump($value,true)."</td></tr>"; echo "<tr><td>$key</td><td>" . var_dump($value, true) . "</td></tr>";
} else echo "<tr><td>$key</td><td>$value</td></tr>"; } else
} // also show documents/URLs available echo "<tr><td>$key</td><td>$value</td></tr>";
  }
   
echo "</table>"; echo "</table>";
  } else {
   
  $rows = $db->get_view("app", "showNamesABNs")->rows;
  //print_r($rows);
  foreach ($rows as $row) {
  // print_r($row);
  echo '<li><a href="getAgency.php?id=' . $row->key . '">' .
  (isset($row->value->name) && $row->value->name != "" ? $row->value->name : "NO NAME " . $row->value->abn)
  . '</a></li>';
  }
} }
   
include_footer(); include_footer();