Global function for querying the database

[misc/kostenrechnung] / lib / functions.js

diff --git a/lib/functions.js b/lib/functions.js
index 3a69024..4fdf91b 100644 (file)
--- a/lib/functions.js
+++ b/lib/functions.js
@@ -28,6 +28,22 @@ function ajax_request(func,params,oncomplete)
     req.send(params);
 }
 
+function set_value(id, value)
+{
+    var obj = document.getElementById(id);
+    if (!obj) return;
+
+    if (obj.nodeName.toLowerCase() == 'input'
+       || obj.nodeName.toLowerCase() == 'textarea')
+       obj.value = value;
+    else if (obj.nodeName.toLowerCase() == 'span')
+       obj.innerHTML = value;
+    else if (obj.nodeName.toLowerCase() == 'select')
+       for (var i=0; i < obj.options.length; i++)
+           if (obj.options[i].value == value)
+               obj.selectedIndex = i;
+}
+
 /*
  * Form functions
  */
@@ -36,6 +52,21 @@ function form_save(obj)
     return false;
 }
 
+/*
+ * Table functions
+ */
+function details_callback(data)
+{
+    for (var id in data)
+       set_value('detail_'+id, data[id]);
+}
+
+function fetch_callback(data)
+{
+    for (var id in data)
+       set_value('edit_'+id, data[id]);
+}
+
 /*
  * Rico functions
  */
@@ -50,8 +81,13 @@ function gridDrillDown(e)
     if (!cell) return;
     var value = cell.innerHTML;
 
+    if (document.getElementById('details')) {
+       var params = 'mask=' + grid.tableId.substr(5) + '&id=' + value;
+       ajax_request('details', params, details_callback);
+    }
+
     if (document.getElementById('form_edit')) {
        var params = 'mask=' + grid.tableId.substr(5) + '&id=' + value;
-       ajax_request('fetch', params, false);
+       ajax_request('fetch', params, fetch_callback);
     }
 }