Neue Abfragen
[misc/kostenrechnung] / masks / kostenstellen.php
1 <?php
2
3 $mask = array(
4               'table' => 'kostenstellen',
5               'title' => 'Kostenstellen',
6               'join' => array('gebiet ON kostenstellen.gebiet = gebiet.id'),
7               'list' => array(
8                               'id' => array(
9                                             'name' => 'ID',
10                                             'sql' => 'kostenstellen.id',
11                                             'visible' => false,
12                                             ),
13                               'kostenstelle' => array(
14                                             'name' => 'Kostenstelle',
15                                             'specs' => "filterUI: 't'",
16                                             'width' => 220,
17                                             ),
18                               'gebiet' => array(
19                                             'name' => 'Gebiet',
20                                             'sql' => 'gebiet.gebiet',
21                                             'specs' => "filterUI: 's'",
22                                             'width' => 220,
23                                             ),
24                               'laenge' => array(
25                                             'name' => 'Länge',
26                                             'type' => 'number',
27                                             'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
28                                             'width' => 65,
29                                             ),
30                               ),
31               'edit' => array(
32                               'kostenstelle' => array(
33                                             'name' => 'Kostenstelle',
34                                             'type' => 'text',
35                                             'size' => 24,
36                                             'required' => true,
37                                             ),
38                               'gebiet' => array(
39                                             'name' => 'Gebiet',
40                                             'type' => 'select',
41                                             'options' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY gebiet',
42                                             ),
43                               'laenge' => array(
44                                             'name' => 'Länge',
45                                             'type' => 'decimal',
46                                             'width' => 65,
47                                             'required' => true,
48                                             ),
49                               ),
50               );
51
52 ?>