Display date of last price on demand
authorJoey Schulze <joey@infodrom.org>
Tue, 22 Jan 2013 23:49:33 +0000 (00:49 +0100)
committerJoey Schulze <joey@infodrom.org>
Tue, 22 Jan 2013 23:49:33 +0000 (00:49 +0100)
ordersatz_pos.php

index 18f0bce..65a7608 100644 (file)
@@ -162,6 +162,14 @@ $mask = array(
                                            'sql' => '(SELECT preis * ((100 + steuersatz)/100) FROM metro_artikel_preis ' .
                                                     'WHERE artikel = metro_artikel.id ORDER BY datum DESC LIMIT 1)',
                                            ),
+                             'datum' => array(
+                                           'name' => 'Datum',
+                                           'width' => 85,
+                                           'type' => 'text',
+                                           'sql' => '(SELECT datum FROM metro_artikel_preis ' .
+                                                    'WHERE artikel = metro_artikel.id ORDER BY datum DESC LIMIT 1)',
+                                           'visible' => false,
+                                           ),
                              'hersteller' => array(
                                            'name' => 'Hersteller',
                                            'width' => 80,