-<BR><BR><A NAME="history"><FONT SIZE="+2">Payment History</FONT></A><BR>
+<TABLE>
+ <TR>
+ <TD ALIGN="left">
-% my $s = 0;
-% if ( $payby{'BILL'} && $curuser->access_right('Post payment') ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('<% $p %>edit/cust_pay.cgi?popup=1;payby=BILL;custnum=<% $custnum %>', 392, 336, 'cust_pay_popup' ), CAPTION, 'Enter check payment', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">Enter check payment</A>
-% }
-
-% if ( $payby{'CASH'} && $curuser->access_right('Post payment') ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('<% $p %>edit/cust_pay.cgi?popup=1;payby=CASH;custnum=<% $custnum %>', 392, 336, 'cust_pay_popup' ), CAPTION, 'Enter cash payment', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">Enter cash payment</A>
-% }
-
-% if ( $payby{'WEST'} && $curuser->access_right('Post payment') ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="<% $p %>edit/cust_pay.cgi?payby=WEST;custnum=<% $custnum %>">Enter Western Union payment</A>
-% }
-
-% if ( ( $payby{'CARD'} || $payby{'DCRD'} )
-% && $curuser->access_right('Process payment')
-% && ! $cust_main->is_encrypted($cust_main->payinfo)
-% ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="<% $p %>misc/payment.cgi?payby=CARD;custnum=<% $custnum %>">Process credit card payment</A>
-% }
-
-% if ( ( $payby{'CHEK'} || $payby{'DCHK'} )
-% && $curuser->access_right('Process payment')
-% && ! $cust_main->is_encrypted($cust_main->payinfo)
-% ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="<% $p %>misc/payment.cgi?payby=CHEK;custnum=<% $custnum %>">Process electronic check (ACH) payment</A>
-% }
-
-% if ( $payby{'MCRD'} && $curuser->access_right('Post payment') ) {
- <% $s++ ? ' | ' : '' %>
- <A HREF="<% $p %>edit/cust_pay.cgi?payby=MCRD;custnum=<% $custnum %>">Post manual (offline) credit card payment</A>
-% }
-
-<BR>
-
-% if ( $curuser->access_right('Post credit') ) {
- <A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('<% $p %>edit/cust_credit.cgi?<% $custnum %>', 392, 336, 'cust_credit_popup' ), CAPTION, 'Enter credit', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">Enter credit</A>
- <BR>
-% }
-
-% if ( $curuser->access_right('View customer tax exemptions') ) {
- <A HREF="<% $p %>search/cust_tax_exempt_pkg.cgi?custnum=<% $custnum %>">View tax exemptions</A>
- <BR>
-% }
+%# batched payment links
-% if ( $conf->exists('batch-enable')
+% if ( ( $conf->exists('batch-enable') || $conf->config('batch-enable_payby') )
% && $curuser->access_right('View customer batched payments')
-% ) {
- View batched payments:
+% )
+% {
+ <% mt('View batched payments:') |h %>
% foreach my $status (qw( Queued In-transit Complete All )) {
- <A HREF="<% $p %>search/cust_pay_batch.cgi?status=<% $status{$status} %>;custnum=<% $custnum %>"><% $status %></A>
+ <A HREF="<% $p %>search/cust_pay_batch.cgi?status=<% $status{$status} %>;custnum=<% $custnum %>"><% mt($status) |h %></A>
<% $status ne 'All' ? '|' : '' %>
% }
- <BR>
+ <BR>
% }
-%#get payment history
-%my @history = ();
-%
-%#invoices
-%foreach my $cust_bill ($cust_main->cust_bill) {
-% my $pre = ( $cust_bill->owed > 0 )
-% ? '<B><FONT SIZE="+1" COLOR="#FF0000">Open '
-% : '';
-% my $post = ( $cust_bill->owed > 0 ) ? '</FONT></B>' : '';
-% my $invnum = $cust_bill->invnum;
-% my $link = $curuser->access_right('View invoices')
-% ? qq!<A HREF="${p}view/cust_bill.cgi?$invnum">!
-% : '';
-% my $events = '';
-% if ( $cust_bill->num_cust_event
-% && ( $curuser->access_right('Billing event reports')
-% || $curuser->access_right('View customer billing events')
-% )
-% ) {
-% $events =
-% qq!<BR><FONT SIZE="-1"><A HREF="${p}search/cust_event.html?invnum=!.
-% $cust_bill->invnum. '">( View invoice events )</A></FONT>';
-% }
-% push @history, {
-% 'date' => $cust_bill->_date,
-% 'desc' => $link. $pre.
-% "Invoice #$invnum (Balance \$". $cust_bill->owed. ')'.
-% $post. ( $link ? '</A>' : '' ). $events,
-% 'charge' => $cust_bill->charged,
-% };
-%}
-%
-%#payments (some false laziness w/credits)
-%foreach my $cust_pay ($cust_main->cust_pay) {
-%
-% my $payby = $cust_pay->payby;
-%
-% my $payinfo;
-% if ( $payby eq 'CARD' ) {
-% $payinfo = $cust_pay->paymask;
-% } elsif ( $payby eq 'CHEK' && $cust_pay->paymask =~ /^(\d+)\@(\d+)$/ ) {
-% $payinfo = "ABA $2, Acct #$1";
-% } else {
-% $payinfo = $cust_pay->payinfo;
-% }
-% my @cust_bill_pay = $cust_pay->cust_bill_pay;
-% my @cust_pay_refund = $cust_pay->cust_pay_refund;
-%
-% my $target = "$payby$payinfo";
-% $payby =~ s/^BILL$/Check #/ if $payinfo;
-% $payby =~ s/^CHEK$/Electronic check /;
-% $payby =~ s/^PREP$/Prepaid card /;
-% $payby =~ s/^CARD$/Credit card #/;
-% $payby =~ s/^COMP$/Complimentary by /;
-% $payby =~ s/^CASH$/Cash/;
-% $payby =~ s/^WEST$/Western Union/;
-% $payby =~ s/^MCRD$/Manual credit card/;
-% $payby =~ s/^BILL$//;
-% my $info = $payby ? "($payby$payinfo)" : '';
-%
-% my( $pre, $post, $desc, $apply, $ext ) = ( '', '', '', '', '' );
-% if ( scalar(@cust_bill_pay) == 0
-% && scalar(@cust_pay_refund) == 0 ) {
-% #completely unapplied
-% $pre = '<B><FONT COLOR="#FF0000">Unapplied ';
-% $post = '</FONT></B>';
-% if ( $curuser->access_right('Apply payment') ) {
-% $apply = qq! (<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('${p}edit/cust_bill_pay.cgi?!.
-% $cust_pay->paynum.
-% qq!', 392, 336, 'cust_bill_pay_popup' ), CAPTION, 'Apply payment', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">apply</A>)!;
-% }
-% } elsif ( scalar(@cust_bill_pay) == 1
-% && scalar(@cust_pay_refund) == 0
-% && $cust_pay->unapplied == 0 ) {
-% #applied to one invoice, the usual situation
-% $desc = ' applied to Invoice #'. $cust_bill_pay[0]->invnum;
-% } elsif ( scalar(@cust_bill_pay) == 0
-% && scalar(@cust_pay_refund) == 1
-% && $cust_pay->unapplied == 0 ) {
-% #applied to one refund
-% $desc = ' refunded on '. time2str("%D", $cust_pay_refund[0]->_date);
-% } else {
-% #complicated
-% $desc = '<BR>';
-% foreach my $app ( sort { $a->_date <=> $b->_date }
-% ( @cust_bill_pay, @cust_pay_refund ) ) {
-% if ( $app->isa('FS::cust_bill_pay') ) {
-% $desc .= ' '.
-% '$'. $app->amount.
-% ' applied to Invoice #'. $app->invnum.
-% '<BR>';
-% #' on '. time2str("%D", $cust_bill_pay->_date).
-% } elsif ( $app->isa('FS::cust_pay_refund') ) {
-% $desc .= ' '.
-% '$'. $app->amount.
-% ' refunded on '. time2str("%D", $app->_date).
-% '<BR>';
-% } else {
-% die "$app is not a FS::cust_bill_pay or FS::cust_pay_refund";
-% }
-% }
-% if ( $cust_pay->unapplied > 0 ) {
-% $desc .= ' '.
-% '<B><FONT COLOR="#FF0000">$'.
-% $cust_pay->unapplied. ' unapplied</FONT></B>';
-% if ( $curuser->access_right('Apply payment') ) {
-% $desc .= qq! (<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('${p}edit/cust_bill_pay.cgi?!.
-% $cust_pay->paynum.
-% qq!', 392, 336, 'cust_bill_pay_popup' ), CAPTION, 'Apply payment', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">apply</A>)!;
-% }
-% $desc .= '<BR>';
-% }
-% }
-%
-% my $view = qq! (<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('${p}view/cust_pay.html?link=popup;paynum=!.
-% $cust_pay->paynum.
-% qq!', 540, 336, 'view_cust_pay_popup' ), CAPTION, 'Payment Receipt', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">view receipt</A>)!;
-%
-% my $refund = '';
-% my $refund_days = $conf->config('card_refund-days') || 120;
-% if ( $cust_pay->closed !~ /^Y/i
-% && $cust_pay->payby =~ /^(CARD|CHEK)$/
-% && time-$cust_pay->_date < $refund_days*86400
-% && $cust_pay->unrefunded > 0
-% && $curuser->access_right('Refund payment')
-% ) {
-% $refund = qq! (<A HREF="${p}edit/cust_refund.cgi?payby=$1;!.
-% qq!paynum=!. $cust_pay->paynum. '"'.
-% qq! TITLE="Send a refund for this payment to the payment gateway"!.
-% qq!>refund</A>)!;
-% }
-%
-% my $void = '';
-% if ( $cust_pay->closed !~ /^Y/i
-% && ( ( $cust_pay->payby eq 'CARD'
-% && $curuser->access_right('Credit card void')
-% )
-% || ( $cust_pay->payby eq 'CHEK'
-% && $curuser->access_right('Echeck void')
-% )
-% || ( $cust_pay->payby !~ /^(CARD|CHEK)$/
-% && $curuser->access_right('Regular void')
-% )
-% )
-% )
-% {
-% $void = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/void-cust_pay.cgi?!. $cust_pay->paynum.
-% qq!', 'Are you sure you want to void this payment?')"!.
-% qq! TITLE="Void this payment from the database!.
-% ( $cust_pay->payby =~ /^(CARD|CHEK)$/
-% ? ' (do not send anything to the payment gateway)'
-% : ''
-% ). '"'.
-% qq!>void</A>)!;
-% }
-%
-% my $delete = '';
-% if ( $cust_pay->closed !~ /^Y/i
-% && $conf->exists('deletepayments')
-% && $curuser->access_right('Delete payment')
-% )
-% {
-% $delete = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/delete-cust_pay.cgi?!. $cust_pay->paynum.
-% qq!', 'Are you sure you want to delete this payment?')"!.
-% qq! TITLE="Delete this payment from the database completely - not recommended"!.
-% qq!>delete</A>)!;
-% }
-%
-% my $unapply = '';
-% if ( $cust_pay->closed !~ /^Y/i
-% && scalar(@cust_bill_pay)
-% && $curuser->access_right('Unapply payment')
-% )
-% {
-% $unapply = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/unapply-cust_pay.cgi?!. $cust_pay->paynum.
-% qq!', 'Are you sure you want to unapply this payment?')"!.
-% qq! TITLE="Keep this payment, but dissociate it from the invoices it is currently applied against"!.
-% qq!>unapply</A>)!;
-% }
-%
-% my $otaker = $cust_pay->otaker;
-% $otaker = '<i>auto billing</i>' if $otaker eq 'fs_daily';
-% $otaker = '<i>customer self-service</i>' if $otaker eq 'fs_selfservice';
-%
-% push @history, {
-% 'date' => $cust_pay->_date,
-% 'desc' => $pre. "Payment$post by $otaker $info$desc".
-% "$view$apply$refund$void$delete$unapply",
-% 'payment' => $cust_pay->paid,
-% 'target' => $target,
-% };
-%}
-%
-%#voided payments
-%foreach my $cust_pay_void ($cust_main->cust_pay_void) {
-%
-% my $payby = $cust_pay_void->payby;
-% my $payinfo = $payby eq 'CARD'
-% ? $cust_pay_void->paymask
-% : $cust_pay_void->payinfo;
-%
-% $payby =~ s/^BILL$/Check #/ if $payinfo;
-% $payby =~ s/^CHEK$/Electronic check /;
-% $payby =~ s/^BILL$//;
-% $payby =~ s/^(CARD|COMP)$/$1 /;
-% my $info = $payby ? " ($payby$payinfo)" : '';
-%
-% my $unvoid = '';
-% if ( $cust_pay_void->closed !~ /^Y/i
-% && $curuser->access_right('Unvoid')
-% )
-% {
-% $unvoid = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/unvoid-cust_pay_void.cgi?!. $cust_pay_void->paynum.
-% qq!', 'Are you sure you want to unvoid this payment?')"!.
-% qq! TITLE="Unvoid this payment from the database!.
-% ( $cust_pay_void->payby =~ /^(CARD|CHEK)$/
-% ? ' (do not send anything to the payment gateway)'
-% : ''
-% ). '"'.
-% qq!>unvoid</A>)!;
-% }
-%
-% push @history, {
-% 'date' => $cust_pay_void->_date,
-% 'desc' => "<DEL>Payment $info</DEL> <I>voided ".
-% time2str("%D", $cust_pay_void->void_date).
-% " by ". $cust_pay_void->otaker. '</i>'. $unvoid,
-% 'void_payment' => $cust_pay_void->paid,
-% };
-%
-%}
-%
-%#credits (some false laziness w/payments)
-%foreach my $cust_credit ($cust_main->cust_credit) {
-%
-% my @cust_credit_bill = $cust_credit->cust_credit_bill;
-% my @cust_credit_refund = $cust_credit->cust_credit_refund;
-%
-% my( $pre, $post, $desc, $apply, $ext ) = ( '', '', '', '', '' );
-% if ( scalar(@cust_credit_bill) == 0
-% && scalar(@cust_credit_refund) == 0 ) {
-% #completely unapplied
-% $pre = '<B><FONT COLOR="#FF0000">Unapplied ';
-% $post = '</FONT></B>';
-% if ( $curuser->access_right('Apply credit') ) {
-% $apply = qq! (<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('${p}edit/cust_credit_bill.cgi?!.
-% $cust_credit->crednum.
-% qq!', 392, 336, 'cust_credit_bill_popup' ), CAPTION, 'Apply credit', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">apply</A>)!;
-% }
-% } elsif ( scalar(@cust_credit_bill) == 1
-% && scalar(@cust_credit_refund) == 0
-% && $cust_credit->credited == 0 ) {
-% #applied to one invoice, the usual situation
-% $desc = ' applied to Invoice #'. $cust_credit_bill[0]->invnum;
-% } elsif ( scalar(@cust_credit_bill) == 0
-% && scalar(@cust_credit_refund) == 1
-% && $cust_credit->credited == 0 ) {
-% #applied to one refund
-% $desc = ' refunded on '. time2str("%D", $cust_credit_refund[0]->_date);
-% } else {
-% #complicated
-% $desc = '<BR>';
-% foreach my $app ( sort { $a->_date <=> $b->_date }
-% ( @cust_credit_bill, @cust_credit_refund ) ) {
-% if ( $app->isa('FS::cust_credit_bill') ) {
-% $desc .= ' '.
-% '$'. $app->amount.
-% ' applied to Invoice #'. $app->invnum.
-% '<BR>';
-% #' on '. time2str("%D", $app->_date).
-% } elsif ( $app->isa('FS::cust_credit_refund') ) {
-% $desc .= ' '.
-% '$'. $app->amount.
-% ' refunded on '. time2str("%D", $app->_date).
-% '<BR>';
-% } else {
-% die "$app is not a FS::cust_credit_bill or a FS::cust_credit_refund";
-% }
-% }
-% if ( $cust_credit->credited > 0 ) {
-% $desc .= ' <B><FONT COLOR="#FF0000">$'.
-% $cust_credit->credited. ' unapplied</FONT></B>';
-% if ( $curuser->access_right('Apply credit') ) {
-% $desc .= qq! (<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('${p}edit/cust_credit_bill.cgi?!.
-% $cust_credit->crednum.
-% qq!', 392, 336, 'cust_credit_bill_popup' ), CAPTION, 'Apply credit', STICKY, AUTOSTATUSCAP, MIDX, 0, MIDY, 0, DRAGGABLE, CLOSECLICK ); return false;">apply</A>)!;
-% }
-% $desc .= '<BR>';
-% }
-% }
-%#
-% my $delete = '';
-% if ( $cust_credit->closed !~ /^Y/i
-%
-% #s'pose deleting a credit isn't bad like deleting a payment
-% # and this needs to be generally available until we have credit voiding..
-% #&& $conf->exists('deletecredits')
-%
-% && $curuser->access_right('Delete credit')
-% )
-% {
-% $delete = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/delete-cust_credit.cgi?!. $cust_credit->crednum.
-% qq!', 'Are you sure you want to delete this credit?')">!.
-% qq!delete</A>)!;
-% }
-%
-% my $unapply = '';
-% if ( $cust_credit->closed !~ /^Y/i
-% && scalar(@cust_credit_bill)
-% && $curuser->access_right('Unapply credit')
-% )
-% {
-% $unapply = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/unapply-cust_credit.cgi?!. $cust_credit->crednum.
-% qq!', 'Are you sure you want to unapply this credit?')">!.
-% qq!unapply</A>)!;
-% }
-%
-% push @history, {
-% 'date' => $cust_credit->_date,
-% 'desc' => $pre. "Credit$post by ". $cust_credit->otaker.
-% ( $cust_credit->reason
-% ? ' ('. $cust_credit->reason. ')'
-% : ''
-% ).
-% "$desc$apply$delete$unapply",
-% 'credit' => $cust_credit->amount,
-% };
-%
-%}
-%
-%#refunds
-%foreach my $cust_refund ($cust_main->cust_refund) {
-%
-% my $payby = $cust_refund->payby;
-% my $payinfo = $payby eq 'CARD'
-% ? $cust_refund->paymask
-% : $cust_refund->payinfo;
-%
-% $payby =~ s/^BILL$/Check #/ if $payinfo;
-% $payby =~ s/^CHEK$/Electronic check /;
-% $payby =~ s/^(CARD|COMP)$/$1 /;
-%
-% my $delete = '';
-% if ( $cust_refund->closed !~ /^Y/i
-% && $conf->exists('deleterefunds')
-% && $curuser->access_right('Delete refund')
-% )
-% {
-% $delete = qq! (<A HREF="javascript:areyousure('!.
-% qq!${p}misc/delete-cust_refund.cgi?!. $cust_refund->refundnum.
-% qq!', 'Are you sure you want to delete this refund?')"!.
-% qq! TITLE="Delete this refund from the database completely - not recommended"!.
-% qq!>delete</A>)!;
-% }
-%
-% push @history, {
-% 'date' => $cust_refund->_date,
-% 'desc' => "Refund ($payby$payinfo) by ". $cust_refund->otaker. "<BR>".
-% $delete,
-% 'refund' => $cust_refund->refund,
-% };
-%
-%}
-%
-%
+ </TD>
+ </TR>
+ <TR>
+ <TD COLSPAN=2>
+%# and now the table
-<% include("/elements/table-grid.html") %>
+<& /elements/table-grid.html &>
% my $bgcolor1 = '#eeeeee';
% my $bgcolor2 = '#ffffff';
% my $bgcolor = '';
-%
-
+<THEAD>
<TR>
- <TH CLASS="grid" BGCOLOR="#cccccc">Date</TH>
- <TH CLASS="grid" BGCOLOR="#cccccc">Description</TH>
- <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>Charge</FONT></TH>
- <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>Payment</FONT></TH>
- <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>In-house<BR>Credit</FONT></TH>
- <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>Refund</FONT></TH>
- <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1>Balance</FONT></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><% mt('Date') |h %></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><% mt('Description') |h %></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1><% mt('Invoice') |h %></FONT></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1><% mt('Payment') |h %></FONT></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1><% mt('In-house Credit') |h %></FONT></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1><% mt('Refund') |h %></FONT></TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc"><FONT SIZE=-1><% mt('Balance') |h %></FONT></TH>
</TR>
-%
-%#display payment history
-%
-%sub balance_forward_row {
-% my( $b, $date ) = @_;
-% my $conf = new FS::Conf;
-% my $money_char = $conf->config('money_char') || '$';
-% ( my $balance_forward = $money_char. $b ) =~ s/^\$\-/- \$/;
+</THEAD>
- <TR ID="balance_forward_row">
- <TD CLASS="grid" BGCOLOR="#dddddd">
- <% time2str("%D",$date) %>
- </TD>
-
- <TD CLASS="grid" BGCOLOR="#dddddd">
- <I>Starting balance on <% time2str("%D",$date) %></I>
- (<A HREF="javascript:void(0);" onClick="show_history();">show prior history</A>)
- </TD>
-
- <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
- <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
- <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
- <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
- <TD CLASS="grid" BGCOLOR="#dddddd"><I><% $balance_forward %></I></TD>
+%#display payment history
- </TR>
-%}
-%
-%my $balance = 0;
%my %target = ();
-%my $money_char = $conf->config('money_char') || '$';
%
-%my $years = $conf->config('payment_history-years') || 2;
-%my $older_than = time - $years * 31556736; #60*60*24*365.24
%my $hidden = 0;
%my $seen = 0;
%my $old_history = 0;
%my $lastdate = 0;
%
-%foreach my $item ( sort { $a->{'date'} <=> $b->{'date'} } @history ) {
+%foreach my $item ( @history ) {
%
% $lastdate = $item->{'date'};
%
-% my $display;
-% if ( $item->{'date'} < $older_than ) {
+% my $display = '';
+% if ( $item->{'hide'} ) {
% $display = ' STYLE="display:none" ';
-% $hidden = 1;
-% } else {
-%
-% $display = '';
-%
-% if ( $hidden && ! $seen++ ) {
-% balance_forward_row($balance, $item->{'date'});
-% }
-%
% }
%
% if ( $bgcolor eq $bgcolor1 ) {
%
% my $charge = exists($item->{'charge'})
% ? sprintf("$money_char\%.2f", $item->{'charge'})
-% : '';
+% : exists($item->{'charge_nobal'})
+% ? sprintf("$money_char\%.2f", $item->{'charge_nobal'})
+% : exists($item->{'void_charge'})
+% ? sprintf("<DEL>$money_char\%.2f</DEL>", $item->{'void_charge'})
+% : '';
%
% my $payment = exists($item->{'payment'})
% ? sprintf("- $money_char\%.2f", $item->{'payment'})
% ? sprintf("- $money_char\%.2f", $item->{'credit'})
% : '';
%
+% $credit ||= sprintf( "<DEL>- $money_char\%.2f</DEL>",
+% $item->{'void_credit'}
+% )
+% if exists($item->{'void_credit'});
+%
% my $refund = exists($item->{'refund'})
% ? sprintf("$money_char\%.2f", $item->{'refund'})
% : '';
%
% my $target = exists($item->{'target'}) ? $item->{'target'} : '';
%
-% $balance += $item->{'charge'} if exists $item->{'charge'};
-% $balance -= $item->{'payment'} if exists $item->{'payment'};
-% $balance -= $item->{'credit'} if exists $item->{'credit'};
-% $balance += $item->{'refund'} if exists $item->{'refund'};
-% $balance = sprintf("%.2f", $balance);
-% $balance =~ s/^\-0\.00$/0.00/; #yay ieee fp
-% ( my $showbalance = $money_char. $balance ) =~ s/^\$\-/- \$/;
-%
-%
-
+% my $showbalance = $money_char . $item->{'balance'};
+% $showbalance =~ s/^\$\-/- \$/;
<TR <% $display ? $display.' ID="old_history'.$old_history++.'"' : ''%>>
- <TD CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" CLASS="grid" BGCOLOR="<% $bgcolor %>">
% unless ( !$target || $target{$target}++ ) {
<A NAME="<% $target %>">
% }
- <% time2str("%D",$item->{'date'}) %>
+ <% time2str($date_format, $item->{'date'}) %>
% if ( $target && $target{$target} == 1 ) {
</A>
<TD CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $item->{'desc'} %>
</TD>
- <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $charge %>
</TD>
- <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $payment %>
</TD>
- <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $credit %>
</TD>
- <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $refund %>
</TD>
- <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <TD VALIGN="top" ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
<% $showbalance %>
</TD>
</TR>
-% }
-%if ( scalar(@history) && $hidden && ! $seen++ ) {
-% balance_forward_row($balance, $lastdate);
-%}
+% if ( $item->{'balance_forward'} ) {
+<& .balance_forward_row, $item->{'balance'}, $item->{'date'} &>
+% }
+%} # foreach $item
</TABLE>
+ </TD>
+ </TR>
+</TABLE>
<SCRIPT TYPE="text/javascript">
}
</SCRIPT>
+<%def .balance_forward_row>
+% my( $b, $date ) = @_;
+% ( my $balance_forward = $money_char. $b ) =~ s/^\$\-/- \$/;
+ <TR ID="balance_forward_row">
+ <TD CLASS="grid" BGCOLOR="#dddddd">
+ <% time2str($date_format, $date) %>
+ </TD>
+
+ <TD CLASS="grid" BGCOLOR="#dddddd">
+ <I><% mt("Starting balance on [_1]", time2str($date_format, $date) ) |h %></I>
+ (<A HREF="javascript:void(0);" onClick="show_history();"><% mt('show prior history') |h %></A>)
+ </TD>
+
+ <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
+ <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
+ <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
+ <TD CLASS="grid" BGCOLOR="#dddddd"></TD>
+ <TD CLASS="grid" BGCOLOR="#dddddd" ALIGN="right"><I><% $balance_forward %></I></TD>
+
+ </TR>
+</%def>
+<%shared>
+my $conf = new FS::Conf;
+my $date_format = $conf->config('date_format') || '%m/%d/%Y';
+my $money_char = $conf->config('money_char') || '$';
+</%shared>
<%init>
my( $cust_main ) = @_;
my $custnum = $cust_main->custnum;
-my $conf = new FS::Conf;
-
my $curuser = $FS::CurrentUser::CurrentUser;
my @payby = grep /\w/, $conf->config('payby');
'All' => '',
);
+#get payment history
+my @history = ();
+
+my %opt = (
+
+ #config
+ ( map { $_ => scalar($conf->config($_)) }
+ qw( card_refund-days date_format )
+ ),
+ ( map { $_ => $conf->exists($_) }
+ qw( deletepayments deleterefunds pkg-balances
+ cust_credit_bill_pkg-manual cust_bill_pay_pkg-manual
+ )
+ ),
+ 'money_char ' => $money_char,
+
+ #rights
+ ( map { $_ => $curuser->access_right($_) }
+ (
+ 'View invoices', 'Void invoices', 'Unvoid invoices',
+ 'Apply payment', 'Refund credit card payment', 'Refund Echeck payment',
+ 'Credit card void', 'Echeck void', 'Void payments', 'Unvoid payments',
+ 'Delete payment', 'Unapply payment',
+ 'Apply credit', 'Delete credit', 'Unapply credit', 'Void credit', 'Unvoid credit',
+ 'Delete refund',
+ 'Billing event reports', 'View customer billing events',
+ )
+ ),
+
+ #customer information
+ 'total_owed' => $cust_main->total_owed,
+ 'total_unapplied_refunds' => $cust_main->total_unapplied_refunds,
+);
+
+$opt{'date_format'} ||= '%m/%d/%Y';
+
+#legacy invoices
+foreach my $legacy_cust_bill ($cust_main->legacy_cust_bill) {
+ push @history, {
+ 'date' => $legacy_cust_bill->_date,
+ 'order' => 1,
+ 'num' => $legacy_cust_bill->legacyid,
+ 'desc' => include('payment_history/legacy_invoice.html', $legacy_cust_bill, %opt ),
+ 'charge_nobal' => $legacy_cust_bill->charged,
+ };
+}
+
+#invoices
+my $num_cust_bill = 0;
+foreach my $cust_bill ($cust_main->cust_bill) {
+ push @history, {
+ 'date' => $cust_bill->_date,
+ 'order' => 1,
+ 'num' => $cust_bill->invnum,
+ 'desc' => include('payment_history/invoice.html', $cust_bill, %opt ),
+ 'charge' => $cust_bill->charged,
+ };
+ $num_cust_bill++;
+}
+
+#voided invoices
+foreach my $cust_bill_void ($cust_main->cust_bill_void) {
+ push @history, {
+ 'date' => $cust_bill_void->_date,
+ 'order' => 0,
+ 'num' => $cust_bill_void->invnum,
+ 'desc' => include('payment_history/voided_invoice.html', $cust_bill_void, %opt ),
+ 'void_charge' => $cust_bill_void->charged,
+ };
+}
+
+#statements
+foreach my $cust_statement ($cust_main->cust_statement) {
+ push @history, {
+ 'date' => $cust_statement->_date,
+ 'order' => 2,
+ 'num' => $cust_statement->statementnum,
+ 'desc' => include('payment_history/statement.html', $cust_statement, %opt ),
+ #'charge' => $cust_bill->charged,
+ };
+}
+
+#payments (some false laziness w/credits)
+foreach my $cust_pay ($cust_main->cust_pay) {
+ push @history, {
+ 'date' => $cust_pay->_date,
+ 'order' => 6,
+ 'num' => $cust_pay->paynum,
+ 'desc' => include('payment_history/payment.html', $cust_pay, %opt ),
+ 'payment' => $cust_pay->paid,
+ #'target' => $target, #XXX
+ };
+}
+
+#pending payments
+foreach my $cust_pay_pending ($cust_main->cust_pay_pending) {
+ push @history, {
+ 'date' => $cust_pay_pending->_date,
+ 'order' => 4,
+ 'num' => $cust_pay_pending->paypendingnum,
+ 'desc' => include('payment_history/pending_payment.html', $cust_pay_pending, %opt ),
+ 'void_payment' => $cust_pay_pending->paid,
+ };
+}
+
+
+#voided payments
+foreach my $cust_pay_void ($cust_main->cust_pay_void) {
+ push @history, {
+ 'date' => $cust_pay_void->_date,
+ 'order' => 3,
+ 'num' => $cust_pay_void->paynum,
+ 'desc' => include('payment_history/voided_payment.html', $cust_pay_void, %opt ),
+ 'void_payment' => $cust_pay_void->paid,
+ };
+
+}
+
+#voided credits
+foreach my $cust_credit_void ($cust_main->cust_credit_void) {
+ push @history, {
+ 'date' => $cust_credit_void->_date,
+ 'order' => 7,
+ 'num' => $cust_credit_void->paynum,
+ 'desc' => include('payment_history/voided_credit.html', $cust_credit_void, %opt ),
+ 'void_credit' => $cust_credit_void->amount,
+ };
+}
+
+#declined payments
+foreach my $cust_pay_pending ($cust_main->cust_pay_pending_attempt) {
+ push @history, {
+ 'date' => $cust_pay_pending->_date,
+ 'order' => 5,
+ 'num' => $cust_pay_pending->paypendingnum,
+ 'desc' => include('payment_history/attempted_payment.html', $cust_pay_pending, %opt ),
+ 'void_payment' => $cust_pay_pending->paid, #??
+ #'target' => $target, #XXX
+ };
+}
+#declined batch payments
+foreach my $cust_pay_batch (
+ $cust_main->cust_pay_batch(hashref => {status => 'Declined'})
+) {
+ my $pay_batch = $cust_pay_batch->pay_batch;
+ push @history, {
+ 'date' => $pay_batch->upload,
+ 'order' => 5,
+ 'num' => $cust_pay_batch->paybatchnum,
+ 'desc' => include('payment_history/attempted_batch_payment.html', $cust_pay_batch, %opt),
+ 'void_payment' => $cust_pay_batch->amount,
+ };
+}
+
+#credits (some false laziness w/payments)
+foreach my $cust_credit ($cust_main->cust_credit) {
+ push @history, {
+ 'date' => $cust_credit->_date,
+ 'order' => 8,
+ 'num' => $cust_credit->crednum,
+ 'desc' => include('payment_history/credit.html', $cust_credit, %opt ),
+ 'credit' => $cust_credit->amount,
+ };
+
+}
+
+#refunds
+foreach my $cust_refund ($cust_main->cust_refund) {
+ push @history, {
+ 'date' => $cust_refund->_date,
+ 'order' => 9,
+ 'num' => $cust_refund->refundnum,
+ 'desc' => include('payment_history/refund.html', $cust_refund, %opt),
+ 'refund' => $cust_refund->refund,
+ };
+
+}
+
+# sort in forward order first, and calculate running balances
+my $years = $conf->config('payment_history-years') || 2;
+my $older_than = time - $years * 31556926; #60*60*24*365.2422
+my $balance = 0;
+
+@history = sort { $a->{date} <=> $b->{date}
+ or $a->{order} <=> $b->{order}
+ or $a->{num} <=> $b->{num}
+ }
+ @history;
+
+my $i = 0;
+my $balance_forward;
+foreach my $item (@history) {
+ $balance += $item->{'charge'} if exists $item->{'charge'};
+ $balance -= $item->{'payment'} if exists $item->{'payment'};
+ $balance -= $item->{'credit'} if exists $item->{'credit'};
+ $balance += $item->{'refund'} if exists $item->{'refund'};
+ $balance = sprintf("%.2f", $balance);
+ $balance =~ s/^\-0\.00$/0.00/;
+ $item->{'balance'} = $balance;
+
+ if ( $item->{'date'} < $older_than ) {
+ $item->{'hide'} = 1;
+ } elsif ( $history[$i-1]->{'hide'} ) {
+ # this is the end of the hidden section
+ $history[$i-1]->{'balance_forward'} = 1;
+ }
+ $i++;
+}
+if ( @history and $history[-1]->{'hide'} ) {
+ # then everything is hidden
+ $history[-1]->{'balance_forward'} = 1;
+}
+
+# then sort in user-pref order
+if ( $curuser->option('history_order') eq 'newest' ) {
+ @history = sort { $b->{date} <=> $a->{date}
+ or $b->{order} <=> $a->{order} #or still forward here?
+ or $b->{num} <=> $a->{num}
+ }
+ @history;
+} # else it's already oldest-first, and there are no other options yet
+
+sub translate_payby {
+ my ($payby,$payinfo) = (shift,shift);
+ my %payby = (
+ FS::payby->payby2shortname,
+ BILL => $payinfo ? emt('Check #') : '',
+ CHEK => emt('Electronic check '),
+ PREP => emt('Prepaid card '),
+ CARD => emt('Credit card #'),
+ COMP => emt('Complimentary by '),
+ #CASH => emt('Cash'),
+ #WEST => emt('Western Union'),
+ #MCRD => emt('Manual credit card'),
+ );
+ $payby = (exists $payby{$payby}) ? $payby{$payby} : $payby;
+ $payby;
+};
+
+sub translate_payby_refund {
+ my ($payby,$payinfo) = (shift,shift);
+ my %payby = (
+ FS::payby->payby2shortname,
+ BILL => $payinfo ? emt('Check #') : emt('Check'),
+ CHEK => emt('Electronic check '),
+ CARD => emt('Credit card #'),
+ COMP => emt('Complimentary by '),
+ );
+ $payby = (exists $payby{$payby}) ? $payby{$payby} : $payby;
+ $payby;
+};
+
+sub translate_payinfo {
+ my $object = shift;
+ my $payby = $object->payby;
+ my $payinfo = $object->payinfo;
+
+ if ( $payby eq 'CARD' ) {
+ $payinfo = $object->paymask;
+ } elsif ( $payby eq 'CHEK' ) {
+ #false laziness w/payinfo_Mixin::payby_payinfo_pretty, should use that
+ my( $account, $aba ) = split('@', $object->paymask );
+ if ( $aba =~ /^(\d{5})\.(\d{3})$/ ) { #blame canada
+ my($branch, $routing) = ($1, $2);
+ $payinfo = emt("Routing [_1], Branch [_2], Acct [_3]",
+ $routing, $branch, $account);
+ } else {
+ $payinfo = emt("Routing [_1], Acct [_2]", $aba, $account);
+ }
+ }
+
+ ($payby,$payinfo);
+}
+
+sub areyousure_link {
+ my ($url,$msg,$title,$label) = (shift,shift,shift,shift);
+ ' (<A HREF="javascript:areyousure(\''.$url.'\',\''.$msg.'\')" TITLE="'.$title.'">'.$label.'</A>)';
+}
+
</%init>
projects / freeside.git / blobdiff