$mask = array(
'table' => 'einsatz',
'title' => 'Materialverbrauch zu Arbeitsberichten',
- 'join' => array('kostenstellen ON einsatz.kostenstelle = kostenstellen.id'),
+ 'join' => array(
+ 'kostenstellen ON einsatz.kostenstelle = kostenstellen.id',
+ 'gebiet ON kostenstellen.gebiet = gebiet.id',
+ ),
'list' => array(
'id' => array(
'name' => 'ID',
'sql' => 'einsatz.id',
+ 'width' => 60,
'visible' => false,
),
'datum' => array(
'type' => 'date',
'width' => 70,
),
+ 'gebiet' => array(
+ 'name' => 'Gebiet',
+ 'width' => 230,
+ 'sql' => 'gebiet.gebiet',
+ ),
'kostenstelle' => array(
'name' => 'Kostenstelle',
'width' => 230,
'specs' => "ClassName: 'aligncenter', canSort: false",
),
),
- '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>'.
+ '<tr bgcolor="#ffd76d" style="color: #444;"><th>Material</th><th>Menge</th></tr>'.
'</thead>'.
'<tbody id="detail_materialverbrauch_tbody"></tbody>'.
'</table>',
'required' => true,
),
),
+ 'buttons' => array(
+ 'save' => false,
+ 'delete' => false,
+ ),
'info' => array(
'einheit' => array(
'sql' => 'SELECT einheiten.einheit FROM einheiten ' .