Format name differently
authorJoey Schulze <joey@infodrom.org>
Fri, 12 Mar 2010 12:07:06 +0000 (13:07 +0100)
committerJoey Schulze <joey@infodrom.org>
Fri, 12 Mar 2010 12:07:06 +0000 (13:07 +0100)
masks/akkord_mitarbeiter.php
masks/arbeitsberichte.php
masks/overview_gewaesser.php
masks/overview_kosten.php
masks/overview_mitarbeiter.php
masks/overview_stunden.php

index b228872..63caa24 100644 (file)
@@ -35,7 +35,7 @@ $mask = array(
                                            ),
                              'personal' => array(
                                            'name' => 'Mitarbeiter',
-                                           'sql' => "vorname || ' ' || name",
+                                           'sql' => "name || ', ' || vorname",
                                            'width' => 150,
                                            'specs' => "filterUI: 's'",
                                            ),
index 6ad35d2..601535d 100644 (file)
@@ -347,7 +347,7 @@ $mask = array(
                                            'sql' => 'SELECT id,name AS text FROM ordnungen ORDER BY id',
                                            ),
                              'mitarbeiter' => array(
-                                           'sql' => 'SELECT id,vorname || \' \' || name AS text FROM personal WHERE aktiv = 1 ORDER BY text',
+                                           'sql' => 'SELECT id,name || \', \' || vorname AS text FROM personal WHERE aktiv = 1 ORDER BY text',
                                            ),
                              'geraete' => array(
                                            'sql' => 'SELECT id,geraet AS text FROM gerate ORDER BY text',
index 04c4275..b1b5fa7 100644 (file)
@@ -27,7 +27,7 @@ $mask = array(
                                            ),
                              'personal' => array(
                                            'name' => 'Personal',
-                                           'sql' => "personal.personal || ', ' || personal.vorname",
+                                           'sql' => "personal.name || ', ' || personal.vorname",
                                            'width' => 150,
                                            'specs' => "filterUI: 't'",
                                            ),
index 24fe1ce..48da6ae 100644 (file)
@@ -62,7 +62,7 @@ $mask = array(
                                            ),
                              'personal' => array(
                                            'name' => 'Mitarbeiter',
-                                           'sql' => "personal.vorname || ' ' || personal.name",
+                                           'sql' => "personal.name || ', ' || personal.vorname",
                                            'width' => 150,
                                            'specs' => "filterUI: 's'",
                                            ),
index 893f88c..7f7833c 100644 (file)
@@ -35,7 +35,7 @@ $mask = array(
                                            ),
                              'personal' => array(
                                            'name' => 'Mitarbeiter',
-                                           'sql' => "personal.vorname || ' ' || personal.name",
+                                           'sql' => "personal.name || ', ' || personal.vorname",
                                            'width' => 150,
                                            'specs' => "filterUI: 's'",
                                            ),
index 70bd7da..5bce405 100644 (file)
@@ -72,7 +72,7 @@ $mask = array(
                                            ),
                              'personal' => array(
                                            'name' => 'Mitarbeiter',
-                                           'sql' => "personal.vorname || ' ' || personal.name",
+                                           'sql' => "personal.name || ', ' || personal.vorname",
                                            'width' => 150,
                                            'specs' => "filterUI: 's'",
                                            ),