git.infodrom.org Git - misc/hallinta-kostenrechnung/blob - work_material.php

   1 <?php
   2
   3 $mask = array(
   4               'table' => 'work_material',
   5               'title' => 'Materialstammdaten',
   6               'join' => array('lieferanten ON lieferant = lieferanten.id'),
   7               'list' => array(
   8                               'id' => array(
   9                                             'name' => 'ID',
  10                                             'visible' => false,
  11                                             'sql' => 'work_material.id',
  12                                             ),
  13                               'name' => array(
  14                                             'name' => 'Name',
  15                                             'width' => 250,
  16                                             'specs' => "filterUI: 't'",
  17                                             'sql' => 'work_material.name',
  18                                             ),
  19                               'menge' => array(
  20                                             'name' => 'Menge',
  21                                             'type' => 'number',
  22                                             'specs' => "decPlaces: 2, ClassName: 'alignright', canSort: false",
  23                                             'width' => 50,
  24                                             ),
  25                               'lieferant' => array(
  26                                             'name' => 'Lieferant',
  27                                             'width' => 200,
  28                                             'specs' => "filterUI: 's'",
  29                                             'sql' => 'lieferanten.name',
  30                                             ),
  31                               'nummer' => array(
  32                                             'name' => 'Materialnummer',
  33                                             'width' => 120,
  34                                             'specs' => "filterUI: 't'",
  35                                             'visible' => false,
  36                                             ),
  37                               ),
  38               'edit' => array(
  39                               'name' => array(
  40                                             'name' => 'Name',
  41                                             'type' => 'text',
  42                                             'size' => 24,
  43                                             'required' => true,
  44                                             ),
  45                               'nummer' => array(
  46                                             'name' => 'Materialnummer',
  47                                             'type' => 'text',
  48                                             'size' => 20,
  49                                             'required' => true,
  50                                             ),
  51                               'menge' => array(
  52                                             'name' => 'Menge',
  53                                             'type' => 'number',
  54                                             'size' => 6,
  55                                             'required' => true,
  56                                             ),
  57                               'einheit' => array(
  58                                             'name' => 'Einheit',
  59                                             'type' => 'text',
  60                                             'size' => 10,
  61                                             'required' => true,
  62                                             ),
  63                               'einzelpreis' => array(
  64                                             'name' => 'Einzelpreis',
  65                                             'type' => 'decimal',
  66                                             'size' => 10,
  67                                             'required' => true,
  68                                             ),
  69                               'lieferant' => array(
  70                                             'name' => 'Lieferant',
  71                                             'type' => 'select',
  72                                             'options' => 'SELECT id,name AS text FROM lieferanten ORDER BY name',
  73                                             'option_empty' => '-- select --',
  74                                             'required' => true,
  75                                             ),
  76                               'comment' => array(
  77                                             'name' => 'Bemerkung',
  78                                             'type' => 'textarea',
  79                                             ),
  80                               ),
  81               );
  82
  83 ?>