X-Git-Url: https://git.infodrom.org/?p=misc%2Fhallinta-metro;a=blobdiff_plain;f=artikel.php;h=76398ad5efb5a8ebd4858cd525bd248cc1b0fe00;hp=90c2689e883ce4c781cd3b93f356a3503dd2ad01;hb=0a643eaf4ac216e416e0cc7b51ca7775c7417175;hpb=5a2d568d47d09b9756f17a1877fb7079830f1e92

diff --git a/artikel.php b/artikel.php
index 90c2689..76398ad 100644
--- a/artikel.php
+++ b/artikel.php
@@ -17,18 +17,25 @@ $mask = array(
 			      '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',