X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Felements%2Ftr-select-reason.html;h=04a5c4582a393a173ef8d9529cdb585c345f484e;hb=f97681d5e43b9cb75b1bd1a03bd47b09a694f9c2;hp=23f31ec51daf9f59631e92a63f7aa9b68442d05d;hpb=b94194faf5fac7503ae388220e25d8daa3ce876b;p=freeside.git
diff --git a/httemplate/elements/tr-select-reason.html b/httemplate/elements/tr-select-reason.html
index 23f31ec51..04a5c4582 100755
--- a/httemplate/elements/tr-select-reason.html
+++ b/httemplate/elements/tr-select-reason.html
@@ -36,11 +36,6 @@
Reason |
|
-% my @types = qsearch( 'reason_type', { 'class' => $class } );
+% my @types = qsearch( 'reason_type', { 'class' => $class } );
% if (scalar(@types) < 1) { # we should never reach this
@@ -79,7 +74,7 @@
|
@@ -137,8 +132,18 @@ if ($init_reason == -1 || ref($init_reason) ) {
}
-my $extra_sql = "WHERE class = '$class' and (disabled = '' OR disabled is NULL) ".
- "ORDER BY reason_type";
+my $extra_sql =
+ "WHERE class = '$class' and (disabled = '' OR disabled is NULL)";
+
+my @reasons = qsearch({
+ table => 'reason',
+ hashref => {},
+ extra_sql => $extra_sql,
+ addl_from => 'LEFT JOIN reason_type '.
+ ' ON reason_type.typenum = reason.reason_type',
+ order_by => 'reason_type.type ASC, reason.reason ASC',
+});
+
my $curuser = $FS::CurrentUser::CurrentUser;
%init>
|