+
+<& /elements/init_overlib.html &>
+
+
-END
-
-#formatting
-print qq!
Payment History!.
- qq! ( !.
- qq!
!.
- qq!Post payment | !.
- qq!
!.
- qq!Post credit )!;
-
-#get payment history
-#
-# major problem: this whole thing is way too sloppy.
-# minor problem: the description lines need better formatting.
-
-my @history = (); #needed for mod_perl :)
-
-my %target = ();
-
-my @bills = qsearch('cust_bill',{'custnum'=>$custnum});
-foreach my $bill (@bills) {
- my($bref)=$bill->hashref;
- my $bpre = ( $bill->owed > 0 )
- ? '
Open '
- : '';
- my $bpost = ( $bill->owed > 0 ) ? '' : '';
- push @history,
- $bref->{_date} . qq!\t
${bpre}Invoice #! . $bref->{invnum} .
- qq! (Balance \$! . $bill->owed . qq!)$bpost\t! .
- $bref->{charged} . qq!\t\t\t!;
-
- my(@cust_bill_pay)=qsearch('cust_bill_pay',{'invnum'=> $bref->{invnum} } );
-# my(@payments)=qsearch('cust_pay',{'invnum'=> $bref->{invnum} } );
-# my($payment);
-# foreach $payment (@payments) {
- foreach my $cust_bill_pay (@cust_bill_pay) {
- my $payment = $cust_bill_pay->cust_pay;
- my($date,$invnum,$payby,$payinfo,$paid)=($payment->_date,
- $cust_bill_pay->invnum,
- $payment->payby,
- $payment->payinfo,
- $cust_bill_pay->amount,
- );
- $payinfo = substr($payinfo,0,4). 'x'x(length($payinfo)-4)
- if $payby eq 'CARD';
- my $target = "$payby$payinfo";
- $payby =~ s/^BILL$/Check #/ if $payinfo;
- $payby =~ s/^(CARD|COMP)$/$1 /;
- my $delete = $payment->closed !~ /^Y/i && $conf->exists('deletepayments')
- ? qq! (
delete)!
- : '';
- push @history,
- "$date\tPayment, Invoice #$invnum ($payby$payinfo)$delete\t\t$paid\t\t\t$target";
- }
-
- my(@cust_credit_bill)=
- qsearch('cust_credit_bill', { 'invnum'=> $bref->{invnum} } );
- foreach my $cust_credit_bill (@cust_credit_bill) {
- my $cust_credit = $cust_credit_bill->cust_credit;
- my($date, $invnum, $crednum, $amount, $reason, $app_date ) = (
- $cust_credit->_date,
- $cust_credit_bill->invnum,
- $cust_credit_bill->crednum,
- $cust_credit_bill->amount,
- $cust_credit->reason,
- time2str("%D", $cust_credit_bill->_date),
- );
- push @history,
- "$date\tCredit #$crednum: $reason
".
- "(applied to invoice #$invnum on $app_date)\t\t\t$amount\t";
- }
-}
-
-my @credits = grep { scalar(my @array = $_->cust_credit_refund) }
- qsearch('cust_credit',{'custnum'=>$custnum});
-foreach my $credit (@credits) {
- my($cref)=$credit->hashref;
- my(@cust_credit_refund)=
- qsearch('cust_credit_refund', { 'crednum'=> $cref->{crednum} } );
- foreach my $cust_credit_refund (@cust_credit_refund) {
- my $cust_refund = $cust_credit_refund->cust_credit;
- my($date, $crednum, $amount, $reason, $app_date ) = (
- $credit->_date,
- $credit->crednum,
- $cust_credit_refund->amount,
- $credit->reason,
- time2str("%D", $cust_credit_refund->_date),
- );
- push @history,
- "$date\tCredit #$crednum: $reason
".
- "(applied to refund on $app_date)\t\t\t$amount\t";
- }
-}
-@credits = grep { $_->credited > 0 }
- qsearch('cust_credit',{'custnum'=>$custnum});
-foreach my $credit (@credits) {
- my($cref)=$credit->hashref;
- push @history,
- $cref->{_date} . "\t" .
- qq!
!.
- 'Unapplied credit #' .
- $cref->{crednum} . ": ".
- $cref->{reason} . "\t\t\t" . $credit->credited . "\t";
-}
+% if ( $view eq 'basics' || $view eq 'jumbo' ) {
+
+% if ( $curuser->access_right('Edit customer') ) {
+
<% mt('Edit this customer') |h %> |
+% }
+
+% if ( $curuser->access_right('Suspend customer')
+% && scalar($cust_main->unsuspended_pkgs)
+% ) {
+ <& /elements/popup_link-cust_main.html,
+ { 'action' => $p. 'misc/suspend_cust.html',
+ 'label' => emt('Suspend this customer'),
+ 'actionlabel' => emt('Confirm Suspension'),
+ 'color' => '#ff9900',
+ 'cust_main' => $cust_main,
+ 'width' => 616, #make room for reasons
+ 'height' => 366,
+ }
+ &> |
+% }
+
+% if ( $curuser->access_right('Unsuspend customer')
+% && scalar($cust_main->suspended_pkgs)
+% ) {
+ <& /elements/popup_link-cust_main.html,
+ { 'action' => $p. 'misc/unsuspend_cust.html',
+ 'label' => emt('Unsuspend this customer'),
+ 'actionlabel' => emt('Confirm Unsuspension'),
+ #'color' => '#ff9900',
+ 'cust_main' => $cust_main,
+ #'width' => 616, #make room for reasons
+ #'height' => 366,
+ }
+ &> |
+% }
+
+% if ( $curuser->access_right('Cancel customer')
+% && scalar($cust_main->ncancelled_pkgs)
+% ) {
+ <& /elements/popup_link-cust_main.html,
+ { 'action' => $p. 'misc/cancel_cust.html',
+ 'label' => emt('Cancel this customer'),
+ 'actionlabel' => emt('Confirm Cancellation'),
+ 'color' => '#ff0000',
+ 'cust_main' => $cust_main,
+ 'width' => 616, #make room for reasons
+ 'height' => 366,
+ }
+ &> |
+% }
+
+% if ( $curuser->access_right('Merge customer') ) {
+ <& /elements/popup_link-cust_main.html,
+ { 'action' => $p. 'misc/merge_cust.html',
+ 'label' => emt('Merge this customer'),
+ 'actionlabel' => emt('Merge customer'),
+ 'cust_main' => $cust_main,
+ 'width' => 480,
+ 'height' => 192,
+ }
+ &> |
+% }
+
+% if ( $conf->exists('deletecustomers')
+% && $curuser->access_right('Delete customer')
+% ) {
+
<% mt('Delete this customer') |h %> |
+% }
+
+% unless ( $conf->exists('disable_customer_referrals') ) {
+
<% mt('Refer a new customer') |h %> |
+
<% mt('View this customer\'s referrals') |h %>
+% }
+
+
+
+% my $br = 0;
+% if ( $curuser->access_right('Billing event reports')
+% || $curuser->access_right('View customer billing events')
+% ) {
+% $br=1;
+
<% mt('View billing events for this customer') |h %>
+% }
+%
+% my $email_link = ($cust_main->invoicing_list_emailonly) &&
+% include('/elements/email-link.html',
+% 'table' => 'cust_main',
+% 'search_hash' => { 'custnum' => $custnum },
+% 'label' => 'Email a notice to this customer',
+% );
+% if ( $email_link and $br ) {
+ |
+% }
+<% $email_link || '' %>
+
+% if ( $conf->config('cust_main-external_links') ) {
+ <% $br++ ? ' | ' : '' %>
+% my @links = split(/\n/, $conf->config('cust_main-external_links'));
+% foreach my $link (@links) {
+% $link =~ /^\s*(\S+)\s+(.*?)(\s*\(([^\)]*)\))?$/ or next;
+% my($url, $label, $alt) = ($1, $2, $4);
+
<% $label |h %>
+% }
+% }
+
+% if ( $br ) {
+
+% }
+%doc>
+
+%my $signupurl = $conf->config('signupurl');
+%if ( $signupurl ) {
+ <% mt('This customer\'s signup URL:') |h %>
+
<% $signupurl %>?ref=<% $custnum %>
+
+% }
+
+%if ( $conf->exists('maestro-status_test') ) {
+
<% mt('Test maestro status') |h %>
+
+% }
+
+
+
+
+
+ <& cust_main/contacts.html, $cust_main &>
+ |
+
+ <& cust_main/misc.html, $cust_main &>
+% if ( $conf->config('payby-default') ne 'HIDE' ) {
+ <& cust_main/billing.html, $cust_main &>
+% }
+
+ |
+
+
+
+ <& cust_main/contacts_new.html, $cust_main &>
+ |
+
+
-my(@refunds)=qsearch('cust_refund',{'custnum'=> $custnum } );
-foreach my $refund (@refunds) {
- my($rref)=$refund->hashref;
- my($refundnum) = (
- $refund->refundnum,
- );
-
- push @history,
- $rref->{_date} . "\tRefund #$refundnum, (" .
- $rref->{payby} . " " . $rref->{payinfo} . ") by " .
- $rref->{otaker} . " - ". $rref->{reason} . "\t\t\t\t" .
- $rref->{refund};
-}
+% }
-my @unapplied_payments =
- grep { $_->unapplied > 0 } qsearch('cust_pay', { 'custnum' => $custnum } );
-foreach my $payment (@unapplied_payments) {
- my $payby = $payment->payby;
- my $payinfo = $payment->payinfo;
- #false laziness w/above
- $payinfo = substr($payinfo,0,4). 'x'x(length($payinfo)-4)
- if $payby eq 'CARD';
- my $target = "$payby$payinfo";
- $payby =~ s/^BILL$/Check #/ if $payinfo;
- $payby =~ s/^(CARD|COMP)$/$1 /;
- my $delete = $payment->closed !~ /^Y/i && $conf->exists('deletepayments')
- ? qq! (
delete)!
- : '';
- push @history,
- $payment->_date. "\t".
- '
Unapplied payment #' .
- $payment->paynum . " ($payby$payinfo) ".
- '(
'.
- "apply)$delete".
- "\t\t" . $payment->unapplied . "\t\t\t$target";
-}
+% if ( $view eq 'notes' || $view eq 'jumbo' ) {
- #formatting
- print &table(), <
comments =~ /[^\s\n\r]/ ) {
+
<% mt('Comments') |h %>
+<% ntable("#cccccc") %><% ntable("#cccccc",2) %>
|
- Date |
- Description |
- Charge |
- Payment |
- In-house Credit |
- Refund |
- Balance |
+
+ <% encode_entities($cust_main->comments) %>
+ |
-END
-
-#display payment history
-
-my $balance = 0;
-foreach my $item (sort keyfield_numerically @history) {
- my($date,$desc,$charge,$payment,$credit,$refund,$target)=split(/\t/,$item);
- $charge ||= 0;
- $payment ||= 0;
- $credit ||= 0;
- $refund ||= 0;
- $balance += $charge - $payment;
- $balance -= $credit - $refund;
- $balance = sprintf("%.2f", $balance);
- $balance =~ s/^\-0\.00$/0.00/; #yay ieee fp
- $target = '' unless defined $target;
-
- print "";
- print qq!! unless $target && $target{$target}++;
- print time2str("%D",$date);
- print '' if $target && $target{$target} == 1;
- print " | ",
- "$desc | ",
- "",
- ( $charge ? "\$".sprintf("%.2f",$charge) : '' ),
- " | ",
- "",
- ( $payment ? "- \$".sprintf("%.2f",$payment) : '' ),
- " | ",
- "",
- ( $credit ? "- \$".sprintf("%.2f",$credit) : '' ),
- " | ",
- "",
- ( $refund ? "\$".sprintf("%.2f",$refund) : '' ),
- " | ",
- "\$" . $balance,
- " | ",
- "\n";
-}
+
+
+% }
+
+% my $notecount = scalar($cust_main->notes(0));
+% if ( ! $conf->exists('cust_main-disable_notes') || $notecount) {
+
+% unless ( $view eq 'notes' && $cust_main->comments !~ /[^\s\n\r]/ ) {
+
+ <% mt('Notes') |h %>
+% }
+
+% if ( $curuser->access_right('Add customer note') &&
+% ! $conf->exists('cust_main-disable_notes')
+% ) {
+
+ <& /elements/popup_link-cust_main.html,
+ 'label' => emt('Add customer note'),
+ 'action' => $p. 'edit/cust_main_note.cgi',
+ 'actionlabel' => emt('Enter customer note'),
+ 'cust_main' => $cust_main,
+ 'width' => 616,
+ 'height' => 538, #575
+ &>
+
+% }
+
+
+
+<& cust_main/notes.html, 'custnum' => $cust_main->custnum &>
+
+% }
+
+
+% if(! $conf->config('disable_cust_attachment')
+% and $curuser->access_right('Add attachment')) {
+<& /elements/popup_link-cust_main.html,
+ 'label' => emt('Attach file'),
+ 'action' => $p.'edit/cust_main_attach.cgi',
+ 'actionlabel' => emt('Upload file'),
+ 'cust_main' => $cust_main,
+ 'width' => 480,
+ 'height' => 296,
+&>
+% }
+% if( $curuser->access_right('View attachments') ) {
+<& cust_main/attachments.html, 'custnum' => $cust_main->custnum &>
+% if ($cgi->param('show_deleted')) {
+">(<% mt('Show active attachments') |h %>)
+% }
+% elsif($curuser->access_right('View deleted attachments')) {
+">(<% mt('Show deleted attachments') |h %>)
+% }
+% }
+
+
+% }
+
+% if ( $view eq 'jumbo' ) {
+
+% }
+
+
+% if ( $view eq 'tickets' || $view eq 'jumbo' ) {
+
+% if ( $conf->config('ticket_system') ) {
+ <& cust_main/tickets.html, $cust_main &>
+% }
+
+
+% }
+
+% if ( $view eq 'jumbo' ) { #XXX enable me && $curuser->access_right('View customer packages') {
+
+ <% mt('Packages') |h %>
+% }
+
+% if ( $view eq 'packages' || $view eq 'jumbo' ) {
+
+% #XXX enable me# if ( $curuser->access_right('View customer packages') {
+<& cust_main/packages.html, $cust_main &>
+% #}
+
+% }
+
+% if ( $view eq 'jumbo' ) {
+
+ <% mt('Payment History') |h %>
+
+% }
+
+% if ( $view eq 'payment_history' || $view eq 'jumbo' ) {
+
+% if ( $conf->config('payby-default') ne 'HIDE' ) {
+ <& cust_main/payment_history.html, $cust_main &>
+% }
+
+% }
+
+% if ( $view eq 'change_history' ) { # || $view eq 'jumbo'
+<& cust_main/change_history.html, $cust_main &>
+% }
+
+% if ( $view eq 'custom' ) {
+% if ( $conf->config('cust_main-custom_link') ) {
+<& cust_main/custom.html, $cust_main &>
+% } elsif ( $conf->config('cust_main-custom_content') ) {
+ <& cust_main/custom_content.html, $cust_main &>
+% #} else {
+% # warn "custom view without cust_main-custom_link or -custom_content?";
+% }
+% }
+
+
+<& /elements/footer.html &>
+<%init>
+
+my $curuser = $FS::CurrentUser::CurrentUser;
+
+die "access denied"
+ unless $curuser->access_right('View customer');
-#formatting
-print "";
+my $conf = new FS::Conf;
-#end
+my $custnum;
+if ( $cgi->param('custnum') =~ /^(\d+)$/ ) {
+ $custnum = $1;
+} else {
+ die "No customer specified (bad URL)!" unless $cgi->keywords;
+ my($query) = $cgi->keywords; # needs parens with my, ->keywords returns array
+ $query =~ /^(\d+)$/;
+ $custnum = $1;
+}
-#formatting
-print < 'cust_main',
+ 'hashref' => { 'custnum' => $custnum },
+ 'extra_sql' => ' AND '. $curuser->agentnums_sql,
+});
+die "Customer not found!" unless $cust_main;
-