git.infodrom.org Git - misc/hallinta-metro/blob - artikel.php

   1 <?php
   2
   3 $mask = array(
   4               'table' => 'metro_artikel',
   5               'title' => 'Artikelstammdaten',
   6               'join' => array('metro_abteilung ON abteilung = metro_abteilung.id'),
   7               'list' => array(
   8                               'id' => array(
   9                                             'name' => 'ID',
  10                                             'visible' => false,
  11                                             'sql' => 'metro_artikel.id',
  12                                             ),
  13                               'artnr' => array(
  14                                             'name' => 'ArtNr',
  15                                             'width' => 60,
  16                                             ),
  17                               'menge' => array(
  18                                             'name' => 'Menge',
  19                                             'width' => 60,
  20                                             'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
  21                                             ),
  22                               'bezeichnung' => array(
  23                                             'name' => 'Bezeichnung',
  24                                             'width' => 345,
  25                                             'specs' => "filterUI: 't'",
  26                                             ),
  27                               'hersteller' => array(
  28                                             'name' => 'Hersteller',
  29                                             'width' => 100,
  30                                             'specs' => "filterUI: 't'",
  31                                             'visible' => false,
  32                                             ),
  33                               'abteilung' => array(
  34                                             'name' => 'Abteilung',
  35                                             'width' => 200,
  36                                             'specs' => "filterUI: 's'",
  37                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')",
  38                                             'visible' => false,
  39                                             ),
  40                               'gang' => array(
  41                                             'name' => 'Gang',
  42                                             'width' => 50,
  43                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
  44                                             'visible' => false,
  45                                             ),
  46                               'vpe' => array(
  47                                             'name' => 'Einheit',
  48                                             'width' => 70,
  49                                             'specs' => "ClassName: 'aligncenter', filterUI: 's'",
  50                                             'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')",
  51                                             ),
  52                               ),
  53               'edit' => array(
  54                               'artnr' => array(
  55                                             'name' => 'Artikelnummer',
  56                                             'type' => 'number',
  57                                             'size' => 15,
  58                                             'required' => true,
  59                                             ),
  60                               'abteilung' => array(
  61                                             'name' => 'Abteilung',
  62                                             'type' => 'select',
  63                                             'options' => 'SELECT id,name AS text FROM metro_abteilung ORDER BY name',
  64                                             'option_empty' => '-- select --',
  65                                             'required' => true,
  66                                             ),
  67                               'vpe' => array(
  68                                             'name' => 'Verpackungseinheit',
  69                                             'type' => 'select',
  70                                             'options' => 'SELECT id,name AS text FROM metro_vpe ORDER BY name',
  71                                             'option_empty' => '-- select --',
  72                                             'required' => true,
  73                                             ),
  74                               'menge' => array(
  75                                             'name' => 'Menge',
  76                                             'type' => 'text',
  77                                             'size' => 15,
  78                                             'null' => true,
  79                                             ),
  80                               'bezeichnung' => array(
  81                                             'name' => 'Bezeichnung',
  82                                             'type' => 'text',
  83                                             'size' => 21,
  84                                             'required' => true,
  85                                             ),
  86                               'hersteller' => array(
  87                                             'name' => 'Hersteller',
  88                                             'type' => 'text',
  89                                             'size' => 21,
  90                                             'null' => true,
  91                                             ),
  92                               ),
  93               );
  94
  95 ?>