From 82f814cbf0260daa1e8d5f35e1e5c46a087fb70d Mon Sep 17 00:00:00 2001 From: Joey Schulze Date: Fri, 5 Apr 2013 14:06:58 +0200 Subject: [PATCH 1/1] Use new possibility to provide distinct queries --- artikel.php | 2 ++ ordersatz_pos.php | 3 +++ 2 files changed, 5 insertions(+) diff --git a/artikel.php b/artikel.php index e4eb956..2bb5744 100644 --- a/artikel.php +++ b/artikel.php @@ -175,6 +175,7 @@ $mask = array( 'width' => 200, 'specs' => "filterUI: 's'", 'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')", + 'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.name FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY name", 'visible' => false, ), 'gang' => array( @@ -188,6 +189,7 @@ $mask = array( 'width' => 70, 'specs' => "ClassName: 'aligncenter', filterUI: 's'", 'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')", + 'distinct' => "SELECT DISTINCT vpe,metro_vpe.name FROM metro_artikel JOIN metro_vpe ON vpe = metro_vpe.id ORDER BY name", ), ), 'edit' => array( diff --git a/ordersatz_pos.php b/ordersatz_pos.php index e8a9135..67d300b 100644 --- a/ordersatz_pos.php +++ b/ordersatz_pos.php @@ -180,12 +180,14 @@ $mask = array( 'width' => 70, 'specs' => "ClassName: 'aligncenter', filterUI: 's'", 'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_vpe','id','name').", 0, '')", + 'distinct' => "SELECT DISTINCT vpe,metro_vpe.name FROM metro_artikel JOIN metro_vpe ON vpe = metro_vpe.id ORDER BY name", ), 'abteilung' => array( 'name' => 'Abteilung', 'width' => 80, 'specs' => "ClassName: 'aligncenter', filterUI: 's'", 'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','name').", 0, '')", + 'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.name FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY name", 'visible' => false, ), 'gang' => array( @@ -194,6 +196,7 @@ $mask = array( 'sql' => 'abteilung', 'specs' => "ClassName: 'aligncenter', filterUI: 's'", 'control' => "new Rico.TableColumn.lookup(".grid_lookup_sql('metro_abteilung','id','gang').", 0, '')", + 'distinct' => "SELECT DISTINCT abteilung,metro_abteilung.gang FROM metro_artikel JOIN metro_abteilung ON abteilung = metro_abteilung.id ORDER BY gang", 'visible' => false, ), ), -- 2.20.1