X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Freport_receivables.cgi;h=9c5c0e2d9fb209280b081dac467a52211b2faa0b;hp=6df016134e6d08413fd4b4af065b964b0a261952;hb=c3da5cf1caa244937d280e0f406927103beef148;hpb=63a268637b2d51a8766412617724b9436439deb6 diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi index 6df016134..9c5c0e2d9 100755 --- a/httemplate/search/report_receivables.cgi +++ b/httemplate/search/report_receivables.cgi @@ -1,8 +1,8 @@ -<% include( 'elements/cust_main_dayranges.html', - 'title' => 'Accounts Receivable Aging Summary', +<& elements/cust_main_dayranges.html, + 'title' => emt('Accounts Receivable Aging Summary'), 'range_sub' => \&balance, - ) -%> + 'payment_links' => 1, +&> <%init> die "access denied" @@ -15,7 +15,7 @@ die "access denied" #Example: # # my $balance = balance( -# $start, $end, +# $start, $end, $offset, # 'no_as' => 1, #set to true when using in a WHERE clause (supress AS clause) # #or 0 / omit when using in a SELECT clause as a column # # ("AS balance_$start_$end") @@ -28,18 +28,12 @@ die "access denied" # ) sub balance { - my($start, $end) = @_; #, %opt ? - - #handle start and end ranges (86400 = 24h * 60m * 60s) - my $str2time = str2time_sql; - my $closing = str2time_sql_closing; - $start = $start ? "( $str2time now() $closing - ".($start * 86400). ' )' : ''; - $end = $end ? "( $str2time now() $closing - ".($end * 86400). ' )' : ''; - - #$opt{'unapplied_date'} = 1; - - FS::cust_main->balance_date_sql( $start, $end, 'unapplied_date'=>1,); + my($start, $end, $cutoff) = @_; #, %opt ? + FS::cust_main->balance_date_sql( $start, $end, + 'cutoff' => $cutoff, + 'unapplied_date'=>1, + ); }