--- a/getAgency.php
+++ b/getAgency.php
@@ -1,24 +1,281 @@
setDatabase("disclosr-agencies", true);
+include_once('include/common.inc.php');
+
+function displayValue($key, $value, $mode)
+{
+ global $db, $schemas;
+ $ignoreKeys = Array("metadata", "metaTags", "statistics", "rtkURLs", "rtkDescriptions");
+ if ($mode == "view") {
+ if (strpos($key, "_") === 0 || in_array($key, $ignoreKeys))
+ return;
+ echo "
";
+
+ echo "";
+ if (isset($schemas['agency']["properties"][$key])) {
+ echo $schemas['agency']["properties"][$key]['x-title'] . " " . $schemas['agency']["properties"][$key]['description'] . "";
+ }
+ echo " | ";
+ if (is_array($value)) {
+ echo "";
+ foreach ($value as $subkey => $subvalue) {
+
+ echo "- ";
+
+ echo "$subvalue
";
+ }
+ echo " |
";
+ } else {
+ if (isset($schemas['agency']["properties"][$key]['x-property'])) {
+ echo '';
+ } else {
+ echo "";
+ }
+
+ if ((strpos($key, "URL") > 0 || $key == 'website') && $value != "") {
+ echo "$value";
+ } else if ($key == 'abn') {
+ echo "$value";
+ } else {
+ echo "$value";
+ }
+ echo "";
+ }
+ echo "";
+ }
+ if ($mode == "edit") {
+ if (is_array($value)) {
+ echo '
+
+
+
+
";
+ } else {
+ if (strpos($key, "_") === 0) {
+ echo "";
+ } else if ($key == "parentOrg") {
+ echo "";
+ } else {
+ echo "";
+ if ((strpos($key, "URL") > 0 || $key == 'website') && $value != "") {
+ echo "view";
+ }
+ if ($key == 'abn') {
+ echo "view abn";
+ }
+ }
+ }
+ }
+//
+}
+
+function addDefaultFields($row)
+{
+ global $schemas;
+ $defaultFields = array_keys($schemas['agency']['properties']);
+ foreach ($defaultFields as $defaultField) {
+ if (!isset($row[$defaultField])) {
+ if ($schemas['agency']['properties'][$defaultField]['type'] == "string") {
+ $row[$defaultField] = "";
+ }
+ if ($schemas['agency']['properties'][$defaultField]['type'] == "array") {
+ $row[$defaultField] = Array("");
+ }
+ } else if ($schemas['agency']['properties'][$defaultField]['type'] == "array") {
+ if (is_array($row[$defaultField])) {
+ $row[$defaultField][] = "";
+ $row[$defaultField][] = "";
+ $row[$defaultField][] = "";
+ } else {
+ $value = $row[$defaultField];
+ $row[$defaultField] = Array($value);
+ $row[$defaultField][] = "";
+ $row[$defaultField][] = "";
+ }
+ }
+ }
+ return $row;
+}
+
+$db = $server->get_db('disclosr-agencies');
+
+if (isset($_REQUEST['id'])) {
//get an agency record as json/html, search by name/abn/id
// by name = startkey="Ham"&endkey="Ham\ufff0"
// edit?
-$rows = $sag->get('/_design/app/_view/byABN?include_docs=true')->body->rows; // &endkey='.$searchVar
-foreach ($rows as $row) {
- echo "";
- echo ' ' . $row->doc->agencyName . " |
";
+
+$obj = $db->get($_REQUEST['id']);
+include_header(isset($obj->name) ? $obj->name : "");
+//print_r($row);
+if (sizeof($_POST) > 0) {
+//print_r($_POST);
+ foreach ($_POST as $postkey => $postvalue) {
+ if ($postvalue == "") {
+ unset($_POST[$postkey]);
+ }
+ if (is_array($postvalue)) {
+ if (count($postvalue) == 1 && $postvalue[0] == "") {
+ unset($_POST[$postkey]);
+ } else {
+ foreach ($_POST[$postkey] as $key => &$value) {
+ if ($value == "") {
+ unset($_POST[$postkey][$key]);
+ }
+ }
+ }
+ }
+ }
+ if (isset($_POST['_id']) && $db->get_rev($_POST['_id']) == $_POST['_rev']) {
+ echo "Edited version was latest version, continue saving";
+ $newdoc = $_POST;
+ $newdoc['metadata']['lastModified'] = time();
+ $obj = $db->save($newdoc);
+ } else {
+ echo "ALERT doc revised by someone else while editing. Document not saved.";
+ }
+}
+
+$mode = "view";
+$rowArray = object_to_array($obj);
+ksort($rowArray);
+if ($mode == "edit") {
+ $row = addDefaultFields($rowArray);
+} else {
+ $row = $rowArray;
+}
+
+if ($mode == "view") {
+ echo '
+
+
+
+
+
';
+ echo '
';
+ echo '
+
' . $row['name'] . '
';
+ if (isset($row['description'])) {
+ echo '
' . $row['description'] . '
';
+ }
+ echo '
';
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 "
";
-}
-
-include_footer();
+}
+if ($mode == "edit") {
+?>
+
+
+
";
+ echo '
+
+
+ ';
+ }
+ if ($mode == "edit") {
+ echo '';
+ }
+ } else {
+// show all list
+ include_header('Agencies');
+ echo '
+
+
+
+
+
+
+
Australian Government Agencies
+
Explore collected information about Australian Government Agencies below.
+
+
+
+
';
+ try {
+ $rows = $db->get_view("app", "byCanonicalName")->rows;
+ //print_r($rows);
+ $rowCount = count($rows);
+ foreach ($rows as $i => $row) {
+ if ($i % ($rowCount / 3) == 0 && $i != 0 && $i != $rowCount - 2) echo '
+
+
+
';
+ }
+
+ include_footer();
+ ?>
+