projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
merge NG auth, RT#21563
[freeside.git]
/
httemplate
/
search
/
cust_bill_event.cgi
diff --git
a/httemplate/search/cust_bill_event.cgi
b/httemplate/search/cust_bill_event.cgi
index
ff4168d
..
9fb533a
100644
(file)
--- a/
httemplate/search/cust_bill_event.cgi
+++ b/
httemplate/search/cust_bill_event.cgi
@@
-1,4
+1,4
@@
-<
% include( 'elements/search.html'
,
+<
& elements/search.html
,
'title' => $title,
'html_init' => $html_init,
'menubar' => $menubar,
'title' => $title,
'html_init' => $html_init,
'menubar' => $menubar,
@@
-60,8
+60,8
@@
'',
FS::UI::Web::cust_styles(),
],
'',
FS::UI::Web::cust_styles(),
],
- )
-
%
>
+
+
&
>
<%init>
my $curuser = $FS::CurrentUser::CurrentUser;
<%init>
my $curuser = $FS::CurrentUser::CurrentUser;
@@
-96,11
+96,11
@@
if ( $cgi->param('invnum') =~ /^(\d+)$/ ) {
$search{invnum} = $1;
}
$search{invnum} = $1;
}
-my $where = 'WHERE '. FS::cust_bill_event->search_sql( \%search );
+my $where = 'WHERE '. FS::cust_bill_event->search_sql
_where
( \%search );
my $join = 'LEFT JOIN part_bill_event USING ( eventpart ) '.
'LEFT JOIN cust_bill USING ( invnum ) '.
my $join = 'LEFT JOIN part_bill_event USING ( eventpart ) '.
'LEFT JOIN cust_bill USING ( invnum ) '.
-
'LEFT JOIN cust_main USING ( custnum ) '
;
+
FS::UI::Web::join_cust_main('cust_bill')
;
my $sql_query = {
'table' => 'cust_bill_event',
my $sql_query = {
'table' => 'cust_bill_event',
@@
-113,7
+113,8
@@
my $sql_query = {
FS::UI::Web::cust_sql_fields(),
),
'hashref' => {},
FS::UI::Web::cust_sql_fields(),
),
'hashref' => {},
- 'extra_sql' => "$where ORDER BY _date ASC",
+ 'extra_sql' => $where,
+ 'order_by' => 'ORDER BY _date ASC',
'addl_from' => $join,
};
'addl_from' => $join,
};