X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fview%2Fcust_main%2Fbilling.html;h=8d3925a08220df59199bc2e645979de014df13c8;hp=1f80dc5bc83035310aeb6850bd6bdc636c805d2b;hb=fbfd9445bb00c2a1c7f4386878edead9b50c482f;hpb=dcdf657e77ec7b46dc69e19a849a9c133123db7c diff --git a/httemplate/view/cust_main/billing.html b/httemplate/view/cust_main/billing.html index 1f80dc5bc..8d3925a08 100644 --- a/httemplate/view/cust_main/billing.html +++ b/httemplate/view/cust_main/billing.html @@ -1,192 +1,268 @@ -% -% my( $cust_main ) = @_; -% my @invoicing_list = $cust_main->invoicing_list; -% my $conf = new FS::Conf; -% my $money_char = $conf->config('money_char') || '$'; -% - - -Billing information -% # If we can't see the unencrypted card, then bill now is an exercise in frustration -%if ( ! $cust_main->is_encrypted($cust_main->payinfo) ) { - (Bill now) -% } - -<% ntable("#cccccc") %><% ntable("#cccccc",2) %> -% -%( my $balance = $cust_main->balance ) -% =~ s/^(\-?)(.*)$/$1<\/FONT>$money_char$2/; -% - - - - Balance due - <% $balance %> - - - - Billing type - -% if ( $cust_main->payby eq 'CARD' || $cust_main->payby eq 'DCRD' ) { - +<% mt('Billing information') |h %> +% my $yes = emt('yes'); +% my $no = emt('no'); +% my $allowed = emt('allowed'); +% my $refused = emt('refused'); - Credit card <% $cust_main->payby eq 'CARD' ? '(automatic)' : '(on-demand)' %> - - - - Card number - <% $cust_main->paymask %> - -% -%#false laziness w/elements/select-month_year.html & edit/cust_main/billing.html -%my( $mon, $year ); -%my $date = $cust_main->paydate || '12-2037'; -%if ( $date =~ /^(\d{4})-(\d{1,2})-\d{1,2}$/ ) { #PostgreSQL date format -% ( $mon, $year ) = ( $2, $1 ); -%} elsif ( $date =~ /^(\d{1,2})-(\d{1,2}-)?(\d{4}$)/ ) { -% ( $mon, $year ) = ( $1, $3 ); -%} else { -% warn "unrecognized expiration date format: $date"; -% ( $mon, $year ) = ( '', '' ); -%} -% - - - Expiration - <% "$mon/$year" %> - -% if ( $cust_main->paystart_month ) { + +% if ( $cust_main->complimentary ) { - - + -% } elsif ( $cust_main->payissue ) { - - - - -% } +% } +%( my $balance = $cust_main->balance ) +% =~ s/^(\-?)(.*)$/$1<\/FONT>$money_char$2/; - - + + -% } elsif ( $cust_main->payby eq 'CHEK' || $cust_main->payby eq 'DCHK') { -% my( $account, $aba ) = split('@', $cust_main->payinfo ); -% - - Electronic check <% $cust_main->payby eq 'CHEK' ? '(automatic)' : '(on-demand)' %> - + + + - - - - - - - - - - - - -% } elsif ( $cust_main->payby eq 'LECB' ) { -% $cust_main->payinfo =~ /^(\d{3})(\d{3})(\d{4})$/; -% my $payinfo = "$1-$2-$3"; -% +<& '/elements/xmlhttp.html', + 'url' => $fsurl.'misc/xmlhttp-cust_main-display_recurring.html', + 'subs' => [ 'get_display_recurring'] &> - Phone bill billing - - - - - - -% } elsif ( $cust_main->payby eq 'BILL' ) { + +% # 10 is an arbitrary number, use ajax for customers with many packages +% if ( $cust_main->num_billing_pkgs > 10 ) { +<& '/elements/xmlhttp.html', + 'url' => $fsurl.'misc/xmlhttp-cust_main-display_recurring.html', + 'subs' => [ 'get_display_recurring'] &> + +% } else { + +% } - Billing +% if ( $conf->exists('cust_main-select-prorate_day') ) { + + + -% if ( $cust_main->payinfo ) { +% } - - - - +% if ( $conf->exists('cust_main-select-billday') +% && qsearch({ 'table' => 'cust_payby', +% 'hashref' => { 'custnum' => $cust_main->custnum, }, +% 'extra_sql' => "AND payby IN ( 'CARD', 'CHEK' )", +% 'order_by' => 'LIMIT 1', +% }) +% ) +% { + + + + +% } + +% if ( $cust_main->po_number ) { + + + + % } +% my @exempt_groups = grep /\S/, $conf->config('tax-cust_exempt-groups'); - - - - -% } elsif ( $cust_main->payby eq 'COMP' ) { +% 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); + + + + +% } - Complimentary - - +% if ( $conf->config('tax_data_vendor') eq 'cch' ) { - - + +% my $tax_location = $conf->exists('tax-ship_address') +% ? $cust_main->ship_location +% : $cust_main->bill_location; + -% -%#false laziness w/above etc. -%my( $mon, $year ); -%my $date = $cust_main->paydate || '12-2037'; -%if ( $date =~ /^(\d{4})-(\d{1,2})-\d{1,2}$/ ) { #PostgreSQL date format -% ( $mon, $year ) = ( $2, $1 ); -%} elsif ( $date =~ /^(\d{1,2})-(\d{1,2}-)?(\d{4}$)/ ) { -% ( $mon, $year ) = ( $1, $3 ); -%} else { -% warn "unrecognized expiration date format: $date"; -% ( $mon, $year ) = ( '', '' ); -%} -% - +% } - - + +% if ( $cust_main->postal_invoice ) { + +% } elsif ( $cust_main->invoice_noemail +% or scalar(@invoicing_list) == 0 ) { +% # alert the user that this customer has no way to receive an invoice + +% } else { + +% } + -% } - - - - + +% if ( $cust_main->invoice_noemail and ! $cust_main->postal_invoice ) { +% # as above, warn if the customer refuses both email and postal invoices + +% } else { + +% } - - + - - + - - + + % if ( $conf->exists('voip-cust_cdr_spools') ) { + + + + +% } +% if ( $conf->exists('voip-cust_cdr_squelch') ) { - - + + % } +% if ( $conf->exists('voip-cust_accountcode_cdr') ) { + + + + +% } + +% if ( my $attach = $conf->config('voip-cdr_email_attach') ) { + + + + +% } + +% if ( $show_term || $cust_main->cdr_termination_percentage ) { + + + + +% } + +% if ( $cust_main->currency ) { + + + + +% } + +% if ( $cust_main->locale ) { +% my %locale_info = FS::Locales->locale_info($cust_main->locale); + + + + +% } + + +
Start date<% $cust_main->paystart_month. '/'. $cust_main->paystart_year %> + <% mt('Complimentary') |h %><% $yes %>
Issue #<% $cust_main->payissue %> -
Name on card<% $cust_main->payname %><% mt('Balance due') |h %><% $balance %>
<% emt( 'Recurring' ) %>
ABA/Routing code<% $aba %>
Account number<% 'x'x(length($account)-2). substr($account,(length($account)-2)) %>
Bank name<% $cust_main->payname %>
Phone number<% $payinfo %>
<% mt('Prorate day of month') |h %><% $cust_main->prorate_day %> + <% $cust_main->force_prorate_day && (''.emt('(applies to all packages)').'') %>
P.O. <% $cust_main->payinfo %>
<% mt('Payment day of month') |h %><% $cust_main->billday %> +
<% mt('Purchase Order #') |h %><% $cust_main->po_number %>
Attention<% $cust_main->payname %>
<% mt('Tax exempt') |h %><% @exempt_groups ? ' ('.emt('all taxes').')' : '' %><% $cust_main->tax ? $yes : $no %>
<% mt('Tax exempt') |h %> (<% $exempt_group %> taxes)<% $cust_main_exemption ? $yes : $no %> + <% $cust_main_exemption ? $cust_main_exemption->exempt_number : '' |h %> +
Authorized by<% $cust_main->payinfo %><% mt('Tax location') |h %><% $tax_location->geocode('cch') %>
Expiration<% "$mon/$year" %><% mt('Postal mail invoices') |h %><% $yes . ( $cust_main->invoice_attn + ? ', attn: '. $cust_main->invoice_attn + : '' + ) %> + <% $no %><% $no %>
Tax exempt<% $cust_main->tax ? 'yes' : 'no' %><% mt('Email invoices') |h %><% $refused %><% $cust_main->invoice_noemail ? $refused : $allowed %>
Postal invoices - <% ( grep { $_ eq 'POST' } @invoicing_list ) ? 'yes' : 'no' %> + <% mt('Other email notices') |h %> + <% $cust_main->message_noemail ? $refused : $allowed %>
FAX invoices - <% ( grep { $_ eq 'FAX' } @invoicing_list ) ? 'yes' : 'no' %> + <% mt('Invoice terms') |h %> + <% $cust_main->invoice_terms + || emt('Default').' ('. ( $conf->config('invoice_default_terms', $cust_main->agentnum) + || emt('Payable upon receipt') + ). + ')' + %>
Email invoices - <% join(', ', grep { $_ !~ /^(POST|FAX)$/ } @invoicing_list ) || 'no' %> + <% mt('Credit limit') |h %> +% 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) +% }
<% mt('Spool CDRs') |h %><% $cust_main->spool_cdr ? $yes : $no %>
Spool CDRs<% $cust_main->spool_cdr ? 'yes' : 'no' %><% 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 '.uc($attach)) |h %><% $cust_main->email_csv_cdr ? $yes : $no %>
<% mt('CDR termination settlement') |h %><% $cust_main->cdr_termination_percentage %><% $cust_main->cdr_termination_percentage =~ /\d/ ? '%' : '' %>
<% mt('Invoicing currency') |h %><% $cust_main->currency. ': '. code2currency($cust_main->currency) %>
<% mt('Invoicing locale') |h %><% $locale_info{name} . " (" . $locale_info{country} .")" %>
+<%init> + +my( $cust_main ) = @_; +my @invoicing_list = $cust_main->invoicing_list_emailonly; +my $conf = new FS::Conf; +my $money_char = $conf->config('money_char') || '$'; - +#false laziness w/edit/cust_main/billing.html +my $term_sql = "SELECT COUNT(*) FROM cust_pkg LEFT JOIN part_pkg USING ( pkgpart ) WHERE custnum = ? AND plan = 'cdr_termination' LIMIT 1"; +my $term_sth = dbh->prepare($term_sql) or die dbh->errstr; +$term_sth->execute($cust_main->custnum) or die $term_sth->errstr; +my $show_term = $term_sth->fetchrow_arrayref->[0]; +