From 0b718f36f03bbdecf1411d69608308fab52ff58f Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Fri, 5 Mar 2010 00:09:14 +0100
Subject: [PATCH] Fill detail box with Einsatz details

---
 masks/materialverbrauch.php | 33 ++++++++++++++++++++++++++++++---
 1 file changed, 30 insertions(+), 3 deletions(-)

diff --git a/masks/materialverbrauch.php b/masks/materialverbrauch.php
index c80d67f..fda62df 100644
--- a/masks/materialverbrauch.php
+++ b/masks/materialverbrauch.php
@@ -2,9 +2,6 @@
 
 $jscode[] = <<<EOC
 
-Rico.moduleDependencies['checkboxDB'] = ['+LiveGrid', '../ricoTableColumnDB.js'];
-Rico.loadModule('checkboxDB');
-
 function einheit_callback(data)
 {
   var einheit = document.getElementById('edit_einheit');
@@ -22,6 +19,23 @@ function select_material(obj)
 
 EOC;
 
+function fetch_tbody()
+{
+  $sql = 'SELECT materialien.material,menge,einheiten.einheit FROM materialverbrauch '
+    . 'JOIN materialien ON materialverbrauch.material = materialien.id '
+    . 'JOIN einheiten ON materialien.einheit = einheiten.id '
+    . 'WHERE einsatz = ' . intval($_POST['id']);
+
+  $data = query_db($sql);
+
+  $ret = '';
+  foreach ($data as $row)
+    $ret .= sprintf('<tr><td>%s</td><td align="right">%.2f %s</td></tr>',
+		    $row['material'], $row['menge'], $row['einheit']);
+
+  return $ret;
+}
+
 $mask = array(
 	      'table' => 'einsatz',
 	      'title' => 'Materialverbrauch zu Arbeitsberichten',
@@ -51,6 +65,19 @@ $mask = array(
 					    ),
 			      ),
 	      'rows' => 20,
+	      'details' => array(
+				 'html' => '<table id="materialverbrauch_table" cellspacing="0" style="margin-top: -13px;" border="0" width="100%">'.
+				 '<thead>'.
+				 '<tr bgcolor="#ffd76d"><th>Material</th><th>Menge</th></tr>'.
+				 '</thead>'.
+				 '<tbody id="detail_materialverbrauch_tbody"></tbody>'.
+				 '</table>',
+				 'list' => array(
+						 'materialverbrauch_tbody' => array(
+										    'fetch' => fetch_tbody,
+										    ),
+						 ),
+				 ),
 	      'edit_title' => 'Materialverbrauch vermerken',
 	      'edit_table' => 'materialverbrauch',
 	      'edit' => array(
-- 
2.20.1