1 %if ( $payby_default eq 'HIDE' ) {
3 % $cust_main->payby('BILL') unless $cust_main->payby;
4 % my $payby = $cust_main->payby;
6 <INPUT TYPE="hidden" NAME="payby" VALUE="<% $payby %>">
8 <INPUT TYPE="hidden" NAME="<%$payby%>_payinfo" VALUE="<% $cust_main->paymask %>">
10 % foreach my $field (qw( payname paycvv paystart_month paystart_year payissue payip paytype paystate )) {
12 <INPUT TYPE="hidden" NAME="<% $payby.'_'.$field %>" VALUE="<% $cust_main->get($field) %>">
16 % #false laziness w/elements/select-month_year.html & view/cust_main/billing.html
18 % my $date = $cust_main->paydate || '12-2037';
19 % if ( $date =~ /^(\d{4})-(\d{1,2})-\d{1,2}$/ ) { #PostgreSQL date format
20 % ( $mon, $year ) = ( $2, $1 );
21 % } elsif ( $date =~ /^(\d{1,2})-(\d{1,2}-)?(\d{4}$)/ ) {
22 % ( $mon, $year ) = ( $1, $3 );
24 % die "unrecognized expiration date format: $date";
27 <INPUT TYPE="hidden" NAME="<%$payby%>_exp_month" VALUE="<% $mon %>">
28 <INPUT TYPE="hidden" NAME="<%$payby%>_exp_year" VALUE="<% $year %>">
30 <INPUT TYPE="hidden" NAME="tax" VALUE="<% $cust_main->tax %>">
32 <INPUT TYPE="hidden" NAME="invoicing_list" VALUE="<% join(', ', @invoicing_list) %>">
36 % my $r = qq!<font color="#ff0000">*</font> !;
38 <BR><FONT SIZE="+1"><B>Billing information</B></FONT>
39 <% &ntable("#cccccc") %>
42 <TD ALIGN="right" WIDTH="200"><%$r%>Billing type</TD>
47 function myopen(filename,windowname,properties) {
49 mywindow = window.open(filename,windowname,properties);
58 function achopen(filename,windowname,properties) {
60 achwindow = window.open(filename,windowname,properties);
63 if ( achwindow != -1 )
68 function card_changed(what) {
70 what.form.payinfo.value.substring(0, 4) == '4093'
71 || what.form.payinfo.value.substring(0, 4) == '4911'
72 || what.form.payinfo.value.substring(0, 4) == '4936'
73 || what.form.payinfo.value.substring(0, 6) == '564132'
74 || what.form.payinfo.value.substring(0, 2) == '63'
75 || what.form.payinfo.value.substring(0, 2) == '67'
78 what.form.paystart_month.disabled = false;
79 what.form.paystart_year.disabled = false;
80 what.form.payissue.disabled = false;
81 what.form.paystart_month.style.backgroundColor = '#ffffff';
82 what.form.paystart_year.style.backgroundColor = '#ffffff';
83 what.form.payissue.style.backgroundColor = '#ffffff';
84 document.getElementById('paystart_label').style.color = '#000000';
85 document.getElementById('payissue_label').style.color = '#000000';
87 what.form.paystart_month.disabled = true;
88 what.form.paystart_year.disabled = true;
89 what.form.payissue.disabled = true;
90 what.form.paystart_month.style.backgroundColor = '#dddddd';
91 what.form.paystart_year.style.backgroundColor = '#dddddd';
92 what.form.payissue.style.backgroundColor = '#dddddd';
93 document.getElementById('paystart_label').style.color = '#999999';
94 document.getElementById('payissue_label').style.color = '#999999';
99 function init_payauto_changed(){
100 var f = document.getElementById('CARD_payauto');
101 if(f != null) payauto_changed(f);
102 f = document.getElementById('CHEK_payauto');
103 if(f != null) payauto_changed(f);
106 function payauto_changed(payauto_field){
107 var span = (payauto_field.name == 'CARD_payauto') ? 'card_billday' : 'chek_billday';
108 var select = document.getElementById('select_'+span);
109 span = document.getElementById(span);
110 if (span == null || select == null) return;
111 if(payauto_field.checked) {
112 span.style.color = '#000000';
113 select.disabled = false;
116 span.style.color = '#999999';
117 select.disabled = true;
118 select.selectedIndex = 0;
124 <% include('/elements/init_overlib.html') %>
126 % my $payby = $cust_main->payby;
127 % my $paytype = $cust_main->paytype;
128 % my( $account, $aba ) = split('@', $payinfo);
130 % my $disabled = 'DISABLED style="background-color: #dddddd"';
131 % my $text_disabled = 'style="color: #999999"';
133 % if ( $payby =~ /^(CARD|DCRD)$/ && cardtype($payinfo) =~ /^(Switch|Solo)$/ ) {
134 % $disabled = 'style="background-color: #ffffff"';
135 % $text_disabled = 'style="color: #000000";'
138 % my $disable_payauto = $conf->exists('disable_payauto_default');
139 % my $CARD_payauto_checked = $payby eq 'DCRD' ? ''
140 % : $payby eq 'CARD' ? 'CHECKED'
141 % : $disable_payauto ? '' : 'CHECKED';
142 % my $CHEK_payauto_checked = $payby eq 'DCHK' ? ''
143 % : $payby eq 'CHEK' ? 'CHECKED'
144 % : $disable_payauto ? '' : 'CHECKED';
146 % sub billday_options {
147 % my $curr_value = shift;
149 % for my $billday ( 1 .. 28 ) {
151 % $sel = "SELECTED='SELECTED'" if $curr_value == $billday;
152 % $ret .= "<OPTION VALUE='$billday' $sel>$billday</OPTION>";
157 % my $card_billday_style = $payby eq 'CARD' ? '' : 'style="color: #999999"';
158 % my $chek_billday_style = $payby eq 'CHEK' ? '' : 'style="color: #999999"';
159 % my $card_billday_select_disabled = $payby eq 'CARD' ? '' : 'DISABLED';
160 % my $chek_billday_select_disabled = $payby eq 'CHEK' ? '' : 'DISABLED';
166 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
168 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Card number </TD>!.
169 % qq!<TD WIDTH="408"><INPUT TYPE="text" ID="CARD_payauto" NAME="CARD_payinfo" VALUE="!. ( $payby =~ /^(CARD|DCRD)$/ ? $payinfo : '' ). qq!" MAXLENGTH=19 onChange="card_changed(this)" onKeyUp="card_changed(this)"></TD></TR>!.
171 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Expiration </TD>!.
172 % '<TD WIDTH="408">'.
174 % include('/elements/select-month_year.html',
175 % 'prefix' => 'CARD_exp',
177 % ( $payby =~ /^(CARD|DCRD)$/ ? $cust_main->paydate : '' ),
182 % qq!<TR><TD ALIGN="right" WIDTH="200">CVV2 !.
184 % qq!(<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('../docs/cvv2.html', 480, 352, 'cvv2_popup' ), CAPTION, 'CVV2 Help', STICKY, AUTOSTATUSCAP, CLOSECLICK, DRAGGABLE ); return false;">help</A>)!.
186 % '<TD WIDTH="408"><INPUT TYPE="text" NAME="CARD_paycvv" VALUE="'. ( $payby =~ /^(CARD|DCRD)$/ && !$cust_main->is_encrypted($cust_main->paycvv) ? $cust_main->paycvv : '' ). '" SIZE=4 MAXLENGTH=4>'.
189 % qq!<TR><TD ALIGN="right" WIDTH="200"><SPAN ID="paystart_label" $text_disabled>Start date </SPAN></TD>!.
190 % '<TD WIDTH="408">'.
192 % include('/elements/select-month_year.html',
193 % 'prefix' => 'CARD_paystart',
194 % 'disabled' => $disabled,
195 % 'empty_option' => 1,
196 % 'start_year' => 2000,
197 % 'end_year' => (localtime())[5] + 1900,
198 % 'selected_date' => (
199 % ( $payby =~ /^(CARD|DCRD)$/
200 % && cardtype($payinfo) =~ /^(Switch|Solo)$/ )
201 % ? $cust_main->paystart_month. '-'.
202 % $cust_main->paystart_year
207 % qq!<SPAN ID="payissue_label" $text_disabled> or Issue number </SPAN>!.
208 % '<INPUT TYPE="text" NAME="CARD_payissue" VALUE="'. ( $payby =~ /^(CARD|DCRD)$/ ? $cust_main->payissue : '' ). qq!" SIZE=3 MAXLENGTH=2 $disabled></TD></TR>!.
210 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Exact name on card </TD>!.
211 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="CARD_payname" VALUE="!. ( $payby =~ /^(CARD|DCRD)$/ ? $cust_main->payname : '' ). qq!"></TD></TR>!.
213 % qq!<TR><TD COLSPAN=2 WIDTH="608">!.
214 % qq!<INPUT TYPE="checkbox" onchange="payauto_changed(this);" NAME="CARD_payauto" $CARD_payauto_checked> !.
215 % qq!Charge future payments to this card automatically</TD></TR>!.
217 % ( $conf->exists('cust_main-select-billday') ?
218 % qq!<TR><TD ALIGN="RIGHT" id="card_billday" $card_billday_style>
219 % Charge on this day of each month</TD><TD>
220 % <SELECT NAME="billday">!
221 % . billday_options($cust_main->billday) . qq!</SELECT> </TD></TR>!
229 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
231 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Account number </TD>!.
232 % qq!<TD><INPUT TYPE="text" SIZE=12 NAME="CHEK_payinfo1" VALUE="!. ( $payby =~ /^(CHEK|DCHK)$/ ? $account : '' ). '"></TD>'.
233 % qq!<TD ALIGN="right">Type</TD><TD><SELECT NAME="CHEK_paytype">!.
234 % join('', map { qq!<OPTION VALUE="$_" !.($paytype eq $_ ? 'SELECTED' : '').">$_</OPTION>" } @FS::cust_main::paytypes).
235 % qq!</SELECT></TD></TR>!.
237 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}ABA/Routing number </TD>!.
238 % qq!<TD COLSPAN="3" WIDTH="408"><INPUT TYPE="text" SIZE=10 MAXLENGTH=9 NAME="CHEK_payinfo2" VALUE="!. ( $payby =~ /^(CHEK|DCHK)$/ ? $aba : '' ). qq!" SIZE=10 MAXLENGTH=9> !.
239 % qq!(<A HREF="javascript:void(0);" onClick="overlib( OLiframeContent('../docs/ach.html', 380, 240, 'ach_popup' ), CAPTION, 'ACH Help', STICKY, AUTOSTATUSCAP, CLOSECLICK, DRAGGABLE ); return false;">help</A>)!.
242 % qq!<INPUT TYPE="hidden" NAME="CHEK_exp_month" VALUE="12">!.
243 % qq!<INPUT TYPE="hidden" NAME="CHEK_exp_year" VALUE="2037">!.
245 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Bank name </TD>!.
246 % qq!<TD COLSPAN="3" WIDTH="408"><INPUT TYPE="text" NAME="CHEK_payname" VALUE="!. ( $payby =~ /^(CHEK|DCHK)$/ ? $cust_main->payname : '' ). qq!"></TD></TR>!.
247 % ( $conf->exists('show_bankstate') ?
248 % qq!<TR><TD ALIGN="right" WIDTH="200">$paystate_label</TD>!.
249 % qq!<TD COLSPAN="3" WIDTH="408">!.
250 % include('/elements/select-state.html',
251 % 'empty' => '(choose)',
252 % 'state' => $cust_main->paystate,
253 % 'country' => $cust_main->country,
254 % 'prefix' => 'CHEK_pay',
256 % : '<INPUT TYPE="hidden" NAME="CHEK_paystate" VALUE="'.
257 % $cust_main->paystate. '">'
261 % qq!<TR><TD COLSPAN=4 WIDTH="608">!.
262 % qq!<INPUT TYPE="checkbox" onchange="payauto_changed(this);" ID="CHEK_payauto" NAME="CHEK_payauto" $CHEK_payauto_checked> !.
263 % qq!Charge future payments to this electronic check automatically</TD></TR>!.
265 % ( $conf->exists('cust_main-select-billday') ?
266 % qq!<TR><TD id="chek_billday" $chek_billday_style>
267 % Charge on this day of each month </TD><TD>
268 % <SELECT NAME="billday">!
269 % . billday_options($cust_main->billday) . qq!</SELECT> </TD></TR>!
277 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
279 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Phone number </TD>!.
280 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="LECB_payinfo" VALUE="!. ( $payby eq 'LECB' ? $cust_main->payinfo : '' ). qq!" MAXLENGTH=15 SIZE=16></TD></TR>!.
282 % qq!<INPUT TYPE="hidden" NAME="LECB_exp_month" VALUE="12">!.
283 % qq!<INPUT TYPE="hidden" NAME="LECB_exp_year" VALUE="2037">!.
284 % qq!<INPUT TYPE="hidden" NAME="LECB_payname" VALUE="">!.
286 % '<TR><TD> </TD></TR>'.
287 % '<TR><TD> </TD></TR>'.
288 % '<TR><TD> </TD></TR>'.
289 % '<TR><TD> </TD></TR>'.
290 % '<TR><TD> </TD></TR>'.
291 % '<TR><TD> </TD></TR>'.
297 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
299 % qq!<TR><TD ALIGN="right" WIDTH="200">P.O. </TD>!.
300 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="BILL_payinfo" VALUE="!. ( $payby eq 'BILL' ? $cust_main->payinfo : '' ). qq!"></TD></TR>!.
302 % qq!<INPUT TYPE="hidden" NAME="BILL_exp_month" VALUE="12">!.
303 % qq!<INPUT TYPE="hidden" NAME="BILL_exp_year" VALUE="2037">!.
305 % qq!<TR><TD ALIGN="right" WIDTH="200">Attention </TD>!.
306 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="BILL_payname" VALUE="!. encode_entities( $payby eq 'BILL' ? $cust_main->payname : '' ). qq!"></TD></TR>!.
308 % '<TR><TD> </TD></TR>'.
309 % '<TR><TD> </TD></TR>'.
310 % '<TR><TD> </TD></TR>'.
311 % '<TR><TD> </TD></TR>'.
312 % '<TR><TD> </TD></TR>'.
318 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
320 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Approved by </TD>!.
321 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="COMP_payinfo" VALUE=""></TD></TR>!.
323 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Expiration </TD>!.
324 % '<TD WIDTH="408">'.
326 % include('/elements/select-month_year.html',
327 % 'prefix' => 'COMP_exp',
329 % ( $payby eq 'COMP' ? $cust_main->paydate : '' ),
334 % '<TR><TD> </TD></TR>'.
335 % '<TR><TD> </TD></TR>'.
336 % '<TR><TD> </TD></TR>'.
337 % '<TR><TD> </TD></TR>'.
338 % '<TR><TD> </TD></TR>'.
344 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
346 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Amount </TD>!.
347 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="CASH_paid" VALUE="!. ( $payby eq 'CASH' ? $cust_main->paid : '' ). qq!"></TD></TR>!.
349 % '<TR><TD> </TD></TR>'.
350 % '<TR><TD> </TD></TR>'.
351 % '<TR><TD> </TD></TR>'.
352 % '<TR><TD> </TD></TR>'.
353 % '<TR><TD> </TD></TR>'.
354 % '<TR><TD> </TD></TR>'.
360 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
362 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Amount </TD>!.
363 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="WEST_paid" VALUE="!. ( $payby eq 'WEST' ? $cust_main->paid : '' ). qq!"></TD></TR>!.
365 % '<TR><TD> </TD></TR>'.
366 % '<TR><TD> </TD></TR>'.
367 % '<TR><TD> </TD></TR>'.
368 % '<TR><TD> </TD></TR>'.
369 % '<TR><TD> </TD></TR>'.
370 % '<TR><TD> </TD></TR>'.
376 % '<TABLE BGCOLOR="#cccccc" BORDER=0 CELLSPACING=0 HEIGHT=192>'.
378 % qq!<TR><TD ALIGN="right" WIDTH="200">${r}Amount </TD>!.
379 % qq!<TD WIDTH="408"><INPUT TYPE="text" NAME="MCRD_paid" VALUE="!. ( $payby eq 'MCRD' ? $cust_main->paid : '' ). qq!"></TD></TR>!.
381 % '<TR><TD> </TD></TR>'.
382 % '<TR><TD> </TD></TR>'.
383 % '<TR><TD> </TD></TR>'.
384 % '<TR><TD> </TD></TR>'.
385 % '<TR><TD> </TD></TR>'.
386 % '<TR><TD> </TD></TR>'.
392 % #this should use FS::payby
393 % my @allopt = qw( CARD CHEK LECB BILL CASH WEST MCRD COMP );
395 % my %allopt = map { $_ => FS::payby->shortname($_) } @allopt;
397 % if ( $cust_main->custnum ) {
398 % #don't offer CASH/WEST/MCRD initial payment types when editing customer
399 % delete $allopt{$_} for qw(CASH WEST MCRD);
402 % my @options = grep exists( $allopt{$_} ), @payby;
404 % my %payby2option = (
405 % ( map { $_ => $_ } @options ),
411 <% include( '/elements/selectlayers.html',
413 'curr_value' => $payby2option{$payby || $payby_default || $payby[0] },
414 'options' => \@options,
415 'labels' => \%allopt,
416 'html_between' => '</TD></TR></TABLE>',
417 'layer_callback' => sub { my $layer = shift; $payby{$layer}; },
418 'onchange' => 'init_payauto_changed();',
422 <% &ntable("#cccccc") %>
424 <TR><TD> </TD></TR>
426 % my @exempt_groups = grep /\S/, $conf->config('tax-cust_exempt-groups');
429 <TD WIDTH="608" COLSPAN="2"><INPUT TYPE="checkbox" NAME="tax" VALUE="Y" <% $cust_main->tax eq "Y" ? 'CHECKED' : '' %>> Tax Exempt<% @exempt_groups ? ' (all taxes)' : '' %></TD>
432 % foreach my $exempt_group ( @exempt_groups ) {
433 % #escape $exempt_group for NAME
435 <TD WIDTH="608" COLSPAN="2"> <INPUT TYPE="checkbox" NAME="tax_<% $exempt_group %>" VALUE="Y" <% $cust_main->tax_exemption($exempt_group) ? 'CHECKED' : '' %>> Tax Exempt (<% $exempt_group %> taxes)<TD>
439 % unless ( $conf->exists('emailinvoiceonly') ) {
442 <TD WIDTH="608" COLSPAN="2"><INPUT TYPE="checkbox" NAME="invoicing_list_POST" VALUE="POST" <%
444 ( grep { $_ eq 'POST' } @invoicing_list )
449 %>> Postal mail invoice
455 <TD WIDTH="608" COLSPAN="2"><INPUT TYPE="checkbox" NAME="invoicing_list_FAX" VALUE="FAX" <%
457 ( grep { $_ eq 'FAX' } @invoicing_list )
468 % unless ( $conf->exists('cust-email-high-visibility')) {
470 <TD ALIGN="right" WIDTH="200">
471 <% $conf->exists('cust_main-require_invoicing_list_email') ? $r : '' %>Email address(es)
473 <TD WIDTH="408"><INPUT TYPE="text" NAME="invoicing_list" VALUE="<% join(', ', grep { $_ !~ /^(POST|FAX)$/ } @invoicing_list ) %>"></TD>
478 <TD ALIGN="right" WIDTH="200">Invoice terms </TD>
480 <% include('/elements/select-terms.html',
481 'curr_value' => $cust_main->invoice_terms,
487 <TD ALIGN="right" WIDTH="200">Credit limit </TD>
489 <SCRIPT TYPE="text/javascript">
490 function toggle(obj) {
491 obj.form.credit_limit.disabled = obj.checked;
494 <INPUT TYPE="text" NAME="credit_limit" VALUE=<% sprintf('"%.2f"', $cust_main->credit_limit) %><% length($cust_main->credit_limit) ? '' : ' DISABLED' %>>
495 <INPUT TYPE="checkbox" NAME="no_credit_limit" VALUE=1 onclick="toggle(this)"<% length($cust_main->credit_limit) ? '' : ' CHECKED'%>> Unlimited
499 % if ( $conf->exists('voip-cust_cdr_spools') ) {
501 <TD COLSPAN="2"><INPUT TYPE="checkbox" NAME="spool_cdr" VALUE="Y" <% $cust_main->spool_cdr eq "Y" ? 'CHECKED' : '' %>> Spool CDRs</TD>
504 <INPUT TYPE="hidden" NAME="spool_cdr" VALUE="<% $cust_main->spool_cdr %>">
507 % if ( $conf->exists('voip-cust_cdr_squelch') ) {
509 <TD COLSPAN="2"><INPUT TYPE="checkbox" NAME="squelch_cdr" VALUE="Y" <% $cust_main->squelch_cdr eq "Y" ? 'CHECKED' : '' %>> Omit CDRs from printed invoices</TD>
512 <INPUT TYPE="hidden" NAME="squelch_cdr" VALUE="<% $cust_main->squelch_cdr %>">
515 % if ( $conf->exists('voip-cust_email_csv_cdr') ) {
517 <TD COLSPAN="2"><INPUT TYPE="checkbox" NAME="email_csv_cdr" VALUE="Y" <% $cust_main->email_csv_cdr eq "Y" ? 'CHECKED' : '' %>> Attach CDRs as CSV to emailed invoices</TD>
520 <INPUT TYPE="hidden" NAME="email_csv_cdr" VALUE="<% $cust_main->email_csv_cdr %>">
523 % if ( $show_term || $cust_main->cdr_termination_percentage ) {
525 <TD ALIGN="right">CDR termination settlement</TD>
526 <TD><INPUT TYPE = "text"
527 NAME = "cdr_termination_percentage"
529 VALUE = "<% $cust_main->cdr_termination_percentage %>"
530 STYLE = "text-align:right;"
534 <INPUT TYPE="hidden" NAME="cdr_termination_percentage" VALUE="<% $cust_main->cdr_termination_percentage %>">
539 <% $r %> required fields
544 my $paystate_label = FS::Msgcat::_gettext('paystate');
545 $paystate_label = 'Bank state' if $paystate_label =~/^paystate$/;
550 my( $cust_main, %options ) = @_;
551 my @invoicing_list = @{ $options{'invoicing_list'} };
552 my $payinfo = $options{'payinfo'};
553 my $conf = new FS::Conf;
554 my $payby_default = $conf->config('payby-default');
556 my @payby = grep /\w/, $conf->config('payby');
557 #@payby = (qw( CARD DCRD CHEK DCHK LECB BILL CASH WEST COMP ))
558 @payby = (qw( CARD DCRD CHEK DCHK LECB BILL CASH COMP ))
562 if ( $cust_main->custnum ) {
563 #false laziness w/view/cust_main/billing.html
564 my $term_sql = "SELECT COUNT(*) FROM cust_pkg LEFT JOIN part_pkg USING ( pkgpart ) WHERE custnum = ? AND plan = 'cdr_termination' LIMIT 1";
565 my $term_sth = dbh->prepare($term_sql) or die dbh->errstr;
566 $term_sth->execute($cust_main->custnum) or die $term_sth->errstr;
567 $show_term = $term_sth->fetchrow_arrayref->[0];