From eea039015319500e3089cc0a5e1ab20cccb0f68f Mon Sep 17 00:00:00 2001 From: Joey Schulze Date: Wed, 23 Jan 2013 00:49:33 +0100 Subject: [PATCH] Display date of last price on demand --- ordersatz_pos.php | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/ordersatz_pos.php b/ordersatz_pos.php index 18f0bce..65a7608 100644 --- a/ordersatz_pos.php +++ b/ordersatz_pos.php @@ -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, -- 2.20.1