projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
26491da
)
fix reason selector under mysql, #31702
author
Mark Wells
<mark@freeside.biz>
Thu, 8 Jan 2015 22:36:16 +0000
(14:36 -0800)
committer
Mark Wells
<mark@freeside.biz>
Thu, 8 Jan 2015 22:36:25 +0000
(14:36 -0800)
httemplate/elements/tr-select-reason.html
patch
|
blob
|
history
diff --git
a/httemplate/elements/tr-select-reason.html
b/httemplate/elements/tr-select-reason.html
index
52dc956
..
8b43dd3
100755
(executable)
--- a/
httemplate/elements/tr-select-reason.html
+++ b/
httemplate/elements/tr-select-reason.html
@@
-174,9
+174,14
@@
if ($class eq 'C') {
die "illegal class: $class";
}
+my $select = join(',',
+ 'reason.*',
+ FS::Record::concat_sql([ 'type', "' : '", 'reason' ]) . ' AS label',
+);
+
my @reasons = qsearch({
'table' => 'reason',
- 'select' =>
"reason.*, (type || ' : ' || reason) AS label"
,
+ 'select' =>
$select
,
'addl_from' => ' LEFT JOIN reason_type'.
' ON (reason.reason_type = reason_type.typenum)',
'hashref' => { disabled => '' },