'menge' => array(
'name' => 'Menge',
'width' => 60,
- 'specs' => "ClassName: 'alignrightpad', filterUI: 't'",
+ 'specs' => "ClassName: 'alignrightpad'",
),
'bezeichnung' => array(
'name' => 'Bezeichnung',
- 'width' => 345,
+ 'width' => 300,
'specs' => "filterUI: 't'",
),
+ 'preis' => array(
+ 'name' => 'Preis',
+ 'width' => 60,
+ 'type' => 'number',
+ 'specs' => "decPlaces: 2, ClassName: 'alignrightpad', filterUI: 't'",
+ 'sql' => '(SELECT preis * ((100 + steuersatz)/100) FROM metro_artikel_preis ' .
+ 'WHERE artikel = metro_artikel.id ORDER BY datum DESC LIMIT 1)',
+ ),
'hersteller' => array(
'name' => 'Hersteller',
'width' => 100,
'specs' => "filterUI: 't'",
- 'visible' => false,
),
'abteilung' => array(
'name' => 'Abteilung',