From 97d32b15f1699aecdb043138747396223a73fc25 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Thu, 25 Feb 2010 12:25:41 +0100
Subject: [PATCH] Add AJAX backend for fetching data and filling the edit form

---
 ajax/ajax.php | 13 +++++++++++--
 1 file changed, 11 insertions(+), 2 deletions(-)

diff --git a/ajax/ajax.php b/ajax/ajax.php
index 311000e..72f226e 100644
--- a/ajax/ajax.php
+++ b/ajax/ajax.php
@@ -7,8 +7,17 @@ function fetch($mask)
   $sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
 		 implode(',', array_keys($mask['edit'])),
 		 $mask['table'], $_POST['id']);
-  error_log($sql);
+
   $sth = pg_query($sql);
+  if ($sth === false) return false;
+
+  $row = pg_fetch_assoc($sth);
+
+  foreach ($mask['edit']['list'] as $field => $info)
+    if (array_key_exists('format', $info))
+      $row[$field] = sprintf($info['format'], $row[$field]);
+
+  return $row;
 }
 
 function details($mask)
@@ -19,7 +28,7 @@ function details($mask)
   $sql = sprintf('SELECT id,%s FROM %s WHERE id = %d',
 		 implode(',', array_keys($mask['details']['list'])),
 		 $mask['table'], $_POST['id']);
-  error_log($sql);
+
   $sth = pg_query($sql);
 
   if (!$sth)
-- 
2.20.1