projects
/
misc
/
kostenrechnung
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Add another ORDER BY part
[misc/kostenrechnung]
/
masks
/
arbeitsberichte.php
diff --git
a/masks/arbeitsberichte.php
b/masks/arbeitsberichte.php
index
c301d2a
..
3d94103
100644
(file)
--- a/
masks/arbeitsberichte.php
+++ b/
masks/arbeitsberichte.php
@@
-355,9
+355,9
@@
$mask = array(
'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
),
'anbaugeraete' => array(
'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
),
'anbaugeraete' => array(
- 'sql' => 'SELECT anbaugeraete.id,anbaugeraet as
TEXT
FROM anbaugeraete ' .
+ 'sql' => 'SELECT anbaugeraete.id,anbaugeraet as
text
FROM anbaugeraete ' .
'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
- 'WHERE gerate.id = {geraet}',
+ 'WHERE gerate.id = {geraet}
ORDER BY text
',
),
),
);
),
),
);