X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=httemplate%2Fview%2Fcust_main%2Fbilling.html;h=01e7654d1bb536789fddb8287abf062bfef3e319;hb=326bd8efd1a7ec6b4d2624f9c8e25811404ed6db;hp=049461dbd0d303eb2df88e2a1fbfcc3876874783;hpb=a67fd3bbfeec137ebf494e36eaa920145b8509a1;p=freeside.git diff --git a/httemplate/view/cust_main/billing.html b/httemplate/view/cust_main/billing.html index 049461dbd..01e7654d1 100644 --- a/httemplate/view/cust_main/billing.html +++ b/httemplate/view/cust_main/billing.html @@ -1,34 +1,119 @@ -Billing information +<% mt('Billing information') |h %> %# If we can't see the unencrypted card, then bill now is an exercise in %# frustration (without some sort of job queue magic to send it to a secure %# machine, anyway) %if ( $FS::CurrentUser::CurrentUser->access_right('Bill customer now') % && ! $cust_main->is_encrypted($cust_main->payinfo) % ) { - (Bill now) +%# (<% mt('Bill now') |h %>) + <& /elements/bill.html, + custnum => $cust_main->custnum, + label => emt('Bill now'), + url => $p.'view/cust_main.cgi?'.$cust_main->custnum, + &> % } -<% ntable("#cccccc") %><% ntable("#cccccc",2) %> + %( my $balance = $cust_main->balance ) % =~ s/^(\-?)(.*)$/$1<\/FONT>$money_char$2/; - + +% #54: just an arbitrary number i pulled out of my goober. in reality we'd want +% # to consider e.g. a histogram of num_ncancelled_packages for the entire +% # customer base, and compare it to a graph of the overhead for generating this +% # information. (and optimize it better, we could get it more from SQL) +% if ( $cust_main->num_ncancelled_pkgs < 54 ) { +% my $sth = dbh->prepare(" +% SELECT DISTINCT freq FROM cust_pkg LEFT JOIN part_pkg USING (pkgpart) +% WHERE freq IS NOT NULL AND freq != '0' +% AND ( cancel IS NULL OR cancel = 0 ) +% AND custnum = ? +% ") or die $DBI::errstr; +% +% $sth->execute($cust_main->custnum) or die $sth->errstr; + +% #not really a numeric sort because freqs can actually be all sorts of things +% # but good enough for the 99% cases of ordering monthly quarterly annually +% my @freqs = sort { $a <=> $b } map { $_->[0] } @{ $sth->fetchall_arrayref }; +% +% foreach my $freq (@freqs) { +% my @cust_pkg = qsearch({ +% 'table' => 'cust_pkg', +% 'addl_from' => 'LEFT JOIN part_pkg USING (pkgpart)', +% 'hashref' => { 'custnum' => $cust_main->custnum, }, +% 'extra_sql' => 'AND ( cancel IS NULL OR cancel = 0 ) +% AND freq = '. dbh->quote($freq), +% }) or next; +% +% my $freq_pretty = $cust_pkg[0]->part_pkg->freq_pretty; +% +% my $amount = 0; +% foreach my $cust_pkg (@cust_pkg) { +% my $part_pkg = $cust_pkg->part_pkg; +% next if $cust_pkg->susp +% && ! $cust_pkg->option('suspend_bill') +% && ( ! $part_pkg->option('suspend_bill') +% || $cust_pkg->option('no_suspend_bill') +% ); +% +% #add recurring amounts for this package and its billing add-ons +% foreach my $l_part_pkg ( $part_pkg->self_and_bill_linked ) { +% $amount += $l_part_pkg->option('recur_fee'); +% } +% +% #subtract amounts for any active discounts +% #(there should only be one at the moment, otherwise this makes no sense) +% foreach my $cust_pkg_discount ( $cust_pkg->cust_pkg_discount_active ) { +% my $discount = $cust_pkg_discount->discount; +% #and only one of these for each +% $amount -= $discount->amount; +% $amount -= $amount * $discount->percent/100; +% } +% +% } + + + + + + +% } + +% } + +% if ( $conf->exists('cust_main-select-prorate_day') ) { - + + + +% } + +% if ( $conf->exists('cust_main-select-billday') +% && ($cust_main->payby eq 'CARD' || $cust_main->payby eq 'CHEK') ) { + + + + +% } + + + - + % @@ -46,49 +131,65 @@ Billing information % - + % if ( $cust_main->paystart_month ) { - + % } elsif ( $cust_main->payissue ) { - + % } - + % } elsif ( $cust_main->payby eq 'CHEK' || $cust_main->payby eq 'DCHK') { % my( $account, $aba ) = split('@', $cust_main->paymask ); +% my $branch = ''; +% ($branch,$aba) = split('\.',$aba) if $conf->config('echeck-country') eq 'CA'; - Electronic check <% $cust_main->payby eq 'CHEK' ? '(automatic)' : '(on-demand)' %> +% my $autodemand = $cust_main->payby eq 'CHEK' ? 'automatic' : 'on-demand'; + <% mt("Electronic check ([_1])",$autodemand) |h %> + +% #false laziness w/edit/cust_main/billing.html and misc/payment.cgi +% my $routing_label = $conf->config('echeck-country') eq 'US' +% ? 'ABA/Routing number' +% : 'Routing number'; + - + + +% if ( $conf->config('echeck-country') eq 'CA' ) { + + + - +% } + + - + - + % if ( $conf->exists('show_bankstate') ) { @@ -100,43 +201,39 @@ Billing information % } elsif ( $cust_main->payby eq 'LECB' ) { % $cust_main->payinfo =~ /^(\d{3})(\d{3})(\d{4})$/; % my $payinfo = "$1-$2-$3"; -% - - Phone bill billing + <% mt('Phone bill billing') |h %> - + % } elsif ( $cust_main->payby eq 'BILL' ) { - - Billing + <% mt('Billing') |h %> % if ( $cust_main->payinfo ) { - + % } - - + + % } elsif ( $cust_main->payby eq 'COMP' ) { - - Complimentary + <% mt('Complimentary') |h %> - + % @@ -154,76 +251,147 @@ Billing information % - + % } +% my $yes = emt('yes'); +% my $no = emt('no'); + % my @exempt_groups = grep /\S/, $conf->config('tax-cust_exempt-groups'); - - - - + +% unless ( $conf->exists('cust_class-tax_exempt') +% || $conf->exists('tax-cust_exempt-groups-require_individual_nums') +% ) +% { + + + + +% } + % foreach my $exempt_group ( @exempt_groups ) { - - - - +% my $cust_main_exemption = $cust_main->tax_exemption($exempt_group); + + + + % } % if ( $conf->exists('enable_taxproducts') ) { - - + +% my $tax_location = $conf->exists('tax-ship_address') +% ? $cust_main->ship_location +% : $cust_main->bill_location; + % } - + + + + + + + + + +% unless ( $conf->exists('cust-email-high-visibility')) { - + +% } - + - + % if ( $conf->exists('voip-cust_cdr_spools') ) { - - + + % } % if ( $conf->exists('voip-cust_cdr_squelch') ) { - - + + + +% } + +% if ( $conf->exists('voip-cust_accountcode_cdr') ) { + + + + +% } + +% if ( $conf->exists('voip-cust_email_csv_cdr') ) { + + + % } % if ( $show_term || $cust_main->cdr_termination_percentage ) { - + % } -
Balance due<% mt('Balance due') |h %> <% $balance %>
<% emt( ucfirst($freq_pretty). ' recurring' ) %><% $money_char. sprintf('%.2f', $amount) %>
Billing type<% mt('Prorate day of month') |h %><% $cust_main->prorate_day %> +
<% mt('Billing day of month') |h %><% $cust_main->billday %> +
<% mt('Billing type') |h %> % if ( $cust_main->payby eq 'CARD' || $cust_main->payby eq 'DCRD' ) { - - Credit card <% $cust_main->payby eq 'CARD' ? '(automatic)' : '(on-demand)' %> +% my $autodemand = $cust_main->payby eq 'CARD' ? 'automatic' : 'on-demand'; + <% mt("Credit card ([_1])",$autodemand) |h %>
Card number<% mt('Card number') |h %> <% $cust_main->paymask %>
Expiration<% mt('Expiration') |h %> <% "$mon/$year" %>
Start date<% mt('Start date') |h %> <% $cust_main->paystart_month. '/'. $cust_main->paystart_year %>
Issue #<% mt('Issue #') |h %> <% $cust_main->payissue %>
Name on card<% mt('Name on card') |h %> <% $cust_main->payname %>
ABA/Routing code<% mt($routing_label) |h %> <% $aba %>
<% mt('Branch number') |h %><% $branch %>
Account number<% mt('Account number') |h %> <% $account %>
Account type<% mt('Account type') |h %> <% $cust_main->paytype %>
Bank name<% mt('Bank name') |h %> <% $cust_main->payname %>
Phone number<% mt('Phone number') |h %> <% $payinfo %>
P.O. <% mt('P.O.') |h %> <% $cust_main->payinfo %>
Attention<% $cust_main->payname %><% mt('Attention') |h %><% $cust_main->payname |h %>
Authorized by<% mt('Authorized by') |h %> <% $cust_main->payinfo %>
Expiration<% mt('Expiration') |h %> <% "$mon/$year" %>
Tax exempt<% @exempt_groups ? ' (all taxes)' : '' %><% $cust_main->tax ? 'yes' : 'no' %>
<% mt('Tax exempt') |h %><% @exempt_groups ? ' ('.emt('all taxes').')' : '' %><% $cust_main->tax ? $yes : $no %>
Tax exempt (<% $exempt_group %> taxes)<% $cust_main->tax_exemption($exempt_group) ? 'yes' : 'no' %>
<% mt('Tax exempt') |h %> (<% $exempt_group %> taxes)<% $cust_main_exemption ? $yes : $no %> + <% $cust_main_exemption ? $cust_main_exemption->exempt_number : '' |h %> +
Tax location<% $cust_main->geocode('cch') %><% mt('Tax location') |h %><% $tax_location->geocode('cch') %>
Postal invoices<% mt('Postal mail invoices') |h %> + <% ( grep { $_ eq 'POST' } @invoicing_list ) ? $yes : $no %> +
<% mt('Fax invoices') |h %> + <% ( grep { $_ eq 'FAX' } @invoicing_list ) ? $yes : $no %> +
<% mt('Email invoices') |h %> - <% ( grep { $_ eq 'POST' } @invoicing_list ) ? 'yes' : 'no' %> + <% $cust_main->invoice_noemail ? $no : $yes %>
FAX invoices<% mt('Email address(es)') |h %> - <% ( grep { $_ eq 'FAX' } @invoicing_list ) ? 'yes' : 'no' %> + <% join(', ', grep { $_ !~ /^(POST|FAX)$/ } @invoicing_list ) || $no %> +% if ( $cust_main->message_noemail ) { +
+ <% emt('(do not send notices)') %> +% }
Email invoices<% mt('Invoice terms') |h %> - <% join(', ', grep { $_ !~ /^(POST|FAX)$/ } @invoicing_list ) || 'no' %> + <% $cust_main->invoice_terms + || emt('Default').' ('. ( $conf->config('invoice_default_terms', $cust_main->agentnum) + || emt('Payable upon receipt') + ). + ')' + %>
Invoice terms<% mt('Credit limit') |h %> - <% $cust_main->invoice_terms || 'Default ('. ( $conf->config('invoice_default_terms') || 'Payable upon receipt' ). ')' %> +% my $default_credit_limit = $conf->config('default_credit_limit'); + <% length($cust_main->credit_limit) + ? $money_char. sprintf("%.2f", $cust_main->credit_limit) + : $default_credit_limit + ? "Default ($money_char". sprintf("%.2f", $default_credit_limit). ")" + : emt('Unlimited') + %> +% if ( $cust_main->num_cust_main_credit_limit ) { + (incidents) +% }
Spool CDRs<% $cust_main->spool_cdr ? 'yes' : 'no' %><% mt('Spool CDRs') |h %><% $cust_main->spool_cdr ? $yes : $no %>
Print CDRs<% $cust_main->squelch_cdr ? 'no' : 'yes' %><% mt($conf->exists('voip-cdr_email') ? 'Print CDRs' : 'Show CDRs') |h %><% $cust_main->squelch_cdr ? $no : $yes %>
<% mt('Breakdown CDRs by accountcode') |h %><% $cust_main->accountcode_cdr ? $yes : $no %>
<% mt('Email CDRs as CSV') |h %><% $cust_main->email_csv_cdr ? $yes : $no %>
CDR termination settlement<% mt('CDR termination settlement') |h %> <% $cust_main->cdr_termination_percentage %><% $cust_main->cdr_termination_percentage =~ /\d/ ? '%' : '' %>
+% if ( $cust_main->locale ) { +% my %locale_info = FS::Locales->locale_info($cust_main->locale); + + <% mt('Invoicing locale') |h %> + <% $locale_info{name} . " (" . $locale_info{country} .")" %> + +% } + + + <%once> my $paystate_label = FS::Msgcat::_gettext('paystate');