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