$mask = array(
'table' => 'anbaugeraete',
+ 'title' => 'Anbaugeräte',
'list' => array(
'id' => array(
'name' => 'ID',
'visible' => false,
),
'anbaugeraet' => array(
- 'name' => 'Gerät',
+ 'name' => 'Anbaugerät',
'width' => 150,
),
'anbgerstdsatz' => array(
- 'name' => 'Satz',
+ 'name' => 'Stundensatz',
'type' => 'number',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
- 'width' => 50,
+ 'width' => 90,
),
+/*
'anbkst_intern' => array(
'name' => 'intern',
'type' => 'number',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
- 'width' => 50,
+ 'width' => 60,
),
'anbkst_extern' => array(
'name' => 'extern',
'type' => 'number',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
- 'width' => 50,
+ 'width' => 60,
),
+*/
),
'rows' => 20,
+ 'edit' => array(
+ 'anbaugeraet' => array(
+ 'name' => 'Anbaugerät',
+ 'type' => 'text',
+ 'size' => 25,
+ ),
+ 'anbgerstdsatz' => array(
+ 'name' => 'Stundensatz',
+ 'type' => 'number',
+ 'size' => 15,
+ ),
+ ),
);
?>
$mask = array(
'table' => 'arbeitsarten',
+ 'title' => 'Arbeitsarten',
'list' => array(
'id' => array(
'name' => 'ID',
),
),
'rows' => 20,
+ 'edit' => array(
+ 'arbeitsart' => array(
+ 'name' => 'Arbeitsart',
+ 'type' => 'text',
+ 'size' => 25,
+ ),
+ ),
);
?>
$mask = array(
'table' => 'gebiet',
+ 'title' => 'Gebiete',
'sort' => 1,
'list' => array(
'id' => array(
),
'gebiet' => array(
'name' => 'Gebiet',
- 'width' => 200,
+ 'width' => 300,
),
),
'rows' => 20,
+ 'edit' => array(
+ 'gebiet' => array(
+ 'name' => 'Gebiet',
+ 'type' => 'text',
+ 'size' => 25,
+ ),
+ ),
);
?>
$mask = array(
'table' => 'gerate',
- 'title' => 'Informationen zu Geräten',
+ 'title' => 'Geräte',
'sort' => 1,
'list' => array(
'id' => array(
),
'geraet' => array(
'name' => 'Gerät',
- 'width' => 150,
+ 'width' => 200,
),
'gerstdsatz' => array(
- 'name' => 'Satz',
+ 'name' => 'Stundensatz',
'type' => 'number',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
'width' => 50,
),
+/*
'geraetkst_intern' => array(
'name' => 'intern',
'type' => 'number',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
'width' => 60,
),
+*/
),
'rows' => 20,
+ 'edit' => array(
+ 'geraet' => array(
+ 'name' => 'Gerät',
+ 'type' => 'text',
+ 'size' => 25,
+ ),
+ 'gerstdsatz' => array(
+ 'name' => 'Stundensatz',
+ 'type' => 'number',
+ 'size' => 15,
+ ),
+ ),
);
?>
$mask = array(
'table' => 'kostenstellen',
+ 'title' => 'Kostenstellen',
'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
'list' => array(
'id' => array(
),
'kostenstelle' => array(
'name' => 'Kostenstelle',
- 'width' => 150,
+ 'specs' => "filterUI: 't'",
+ 'width' => 220,
),
'gebiet' => array(
'name' => 'Gebiet',
'sql' => 'gebiet.gebiet',
- 'width' => 200,
+ 'specs' => "filterUI: 's'",
+ 'width' => 220,
),
'laenge' => array(
'name' => 'Länge',
'specs' => "decPlaces: 2, ClassName: 'alignright'",
'width' => 65,
),
+/*
'dienstlstg' => array(
- 'name' => 'Dienst',
+ 'name' => 'Dienstleistung',
# 'type' => 'number',
'specs' => "ClassName: 'alignright'",
'width' => 50,
'specs' => "ClassName: 'alignright'",
'width' => 50,
),
+*/
),
'rows' => 20,
+ 'edit' => array(
+ 'kostenstelle' => array(
+ 'name' => 'Kostenstelle',
+ 'type' => 'text',
+ 'size' => 25,
+ ),
+ 'gebiet' => array(
+ 'name' => 'Gebiet',
+ 'type' => 'select',
+ 'options' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY gebiet',
+ ),
+ 'laenge' => array(
+ 'name' => 'Länge',
+ 'type' => 'number',
+ 'width' => 65,
+ ),
+ ),
);
?>
$mask = array(
'table' => 'materialien',
+ 'title' => 'Materialien',
'sort' => 1,
+ 'join' => array('einheiten ON materialien.einheit = einheiten.id'),
'list' => array(
'id' => array(
'name' => 'ID',
'visible' => false,
+ 'sql' => 'materialien.id',
),
'material' => array(
'name' => 'Material',
- 'width' => 200,
+ 'width' => 270,
'specs' => "filterUI: 't'",
),
+ 'einheit' => array(
+ 'name' => 'Einheit',
+ 'width' => 70,
+ 'sql' => 'einheiten.einheit',
+ ),
'preis' => array(
'name' => 'Preis',
'type' => 'number',
'type' => 'text',
'size' => 50,
),
+ 'einheit' => array(
+ 'name' => 'Einheit',
+ 'type' => 'select',
+ 'options' => 'SELECT id,einheit AS text FROM einheiten ORDER BY einheit',
+ 'size' => 10,
+ ),
'preis' => array(
'name' => 'Preis',
'type' => 'text',
- 'size' => 20,
+ 'size' => 10,
+ 'comment' => 'immer brutto',
),
),
);