git.infodrom.org Git - misc/kostenrechnung/blob - masks/kostenstellen.php

   1 <?php
   2
   3 function gebiete()
   4 {
   5   $sql = "SELECT id,gebiet FROM gebiet ORDER BY id";
   6   $sth = pg_query($sql);
   7
   8   $result = array();
   9   while ($row = pg_fetch_assoc($sth))
  10     $result[] = sprintf("%d: '%s'", $row['id'], $row['gebiet']);
  11
  12   return '{' . implode(', ', $result) . '}';
  13 }
  14
  15 $mask = array(
  16               'table' => 'kostenstellen',
  17               'title' => 'Kostenstellen',
  18               'list' => array(
  19                               'id' => array(
  20                                             'name' => 'ID',
  21                                             'sql' => 'kostenstellen.id',
  22                                             'visible' => false,
  23                                             ),
  24                               'kostenstelle' => array(
  25                                             'name' => 'Kostenstelle',
  26                                             'specs' => "filterUI: 't'",
  27                                             'width' => 220,
  28                                             ),
  29                               'gebiet' => array(
  30                                             'name' => 'Gebiet',
  31                                             'sql' => 'kostenstellen.gebiet',
  32                                             'control' => "new Rico.TableColumn.lookup(".gebiete().", 0, '')",
  33                                             'specs' => "filterUI: 's'",
  34                                             'width' => 220,
  35                                             ),
  36                               'laenge' => array(
  37                                             'name' => 'Länge',
  38                                             'type' => 'number',
  39                                             'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
  40                                             'width' => 65,
  41                                             ),
  42                               ),
  43               'edit' => array(
  44                               'kostenstelle' => array(
  45                                             'name' => 'Kostenstelle',
  46                                             'type' => 'text',
  47                                             'size' => 24,
  48                                             'required' => true,
  49                                             ),
  50                               'gebiet' => array(
  51                                             'name' => 'Gebiet',
  52                                             'type' => 'select',
  53                                             'option_empty' => 'Bitte wählen Sie',
  54                                             'options' => 'SELECT id,gebiet AS text FROM gebiet ORDER BY gebiet',
  55                                             ),
  56                               'laenge' => array(
  57                                             'name' => 'Länge',
  58                                             'type' => 'decimal',
  59                                             'width' => 65,
  60                                             'required' => true,
  61                                             ),
  62                               ),
  63               );
  64
  65 ?>