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