summaryrefslogtreecommitdiff
path: root/httemplate/view/cust_main
diff options
context:
space:
mode:
Diffstat (limited to 'httemplate/view/cust_main')
-rw-r--r--httemplate/view/cust_main/billing.html188
-rw-r--r--httemplate/view/cust_main/contacts.html155
-rw-r--r--httemplate/view/cust_main/misc.html104
-rwxr-xr-xhttemplate/view/cust_main/notes.html74
-rw-r--r--httemplate/view/cust_main/order_pkg.html40
-rwxr-xr-xhttemplate/view/cust_main/packages.html575
-rw-r--r--httemplate/view/cust_main/payment_history.html561
-rw-r--r--httemplate/view/cust_main/quick-charge.html19
-rw-r--r--httemplate/view/cust_main/tickets.html78
9 files changed, 1794 insertions, 0 deletions
diff --git a/httemplate/view/cust_main/billing.html b/httemplate/view/cust_main/billing.html
new file mode 100644
index 000000000..d1be8936f
--- /dev/null
+++ b/httemplate/view/cust_main/billing.html
@@ -0,0 +1,188 @@
+%
+% my( $cust_main ) = @_;
+% my @invoicing_list = $cust_main->invoicing_list;
+% my $conf = new FS::Conf;
+% my $money_char = $conf->config('money_char') || '$';
+%
+
+
+Billing information
+(<A HREF="<% $p %>misc/bill.cgi?<% $cust_main->custnum %>">Bill now</A>)
+<% ntable("#cccccc") %><TR><TD><% ntable("#cccccc",2) %>
+%
+%( my $balance = $cust_main->balance )
+% =~ s/^(\-?)(.*)$/<FONT SIZE=+1>$1<\/FONT>$money_char$2/;
+%
+
+
+<TR>
+ <TD ALIGN="right">Balance due</TD>
+ <TD BGCOLOR="#ffffff"><B><% $balance %></B></TD>
+</TR>
+
+<TR>
+ <TD ALIGN="right">Billing&nbsp;type</TD>
+ <TD BGCOLOR="#ffffff">
+% if ( $cust_main->payby eq 'CARD' || $cust_main->payby eq 'DCRD' ) {
+
+
+ Credit&nbsp;card&nbsp;<% $cust_main->payby eq 'CARD' ? '(automatic)' : '(on-demand)' %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Card number</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payinfo_masked %></TD>
+</TR>
+%
+%#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 ) = ( '', '' );
+%}
+%
+
+<TR>
+ <TD ALIGN="right">Expiration</TD>
+ <TD BGCOLOR="#ffffff"><% "$mon/$year" %></TD>
+</TR>
+% if ( $cust_main->paystart_month ) {
+
+ <TR>
+ <TD ALIGN="right">Start date</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->paystart_month. '/'. $cust_main->paystart_year %>
+ </TR>
+% } elsif ( $cust_main->payissue ) {
+
+ <TR>
+ <TD ALIGN="right">Issue #</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payissue %>
+ </TR>
+% }
+
+
+<TR>
+ <TD ALIGN="right">Name on card</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payname %></TD>
+</TR>
+% } elsif ( $cust_main->payby eq 'CHEK' || $cust_main->payby eq 'DCHK') {
+% my( $account, $aba ) = split('@', $cust_main->payinfo );
+%
+
+
+ Electronic&nbsp;check&nbsp;<% $cust_main->payby eq 'CHEK' ? '(automatic)' : '(on-demand)' %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">ABA/Routing code</TD>
+ <TD BGCOLOR="#ffffff"><% $aba %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Account number</TD>
+ <TD BGCOLOR="#ffffff"><% 'x'x(length($account)-2). substr($account,(length($account)-2)) %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Bank name</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payname %></TD>
+</TR>
+% } elsif ( $cust_main->payby eq 'LECB' ) {
+% $cust_main->payinfo =~ /^(\d{3})(\d{3})(\d{4})$/;
+% my $payinfo = "$1-$2-$3";
+%
+
+
+ Phone&nbsp;bill&nbsp;billing
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Phone number</TD>
+ <TD BGCOLOR="#ffffff"><% $payinfo %></TD>
+</TR>
+% } elsif ( $cust_main->payby eq 'BILL' ) {
+
+
+ Billing
+ </TD>
+</TR>
+% if ( $cust_main->payinfo ) {
+
+<TR>
+ <TD ALIGN="right">P.O. </TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payinfo %></TD>
+</TR>
+% }
+
+
+<TR>
+ <TD ALIGN="right">Attention</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payname %></TD>
+</TR>
+% } elsif ( $cust_main->payby eq 'COMP' ) {
+
+
+ Complimentary
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Authorized&nbsp;by</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->payinfo %></TD>
+</TR>
+%
+%#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 ) = ( '', '' );
+%}
+%
+
+<TR>
+ <TD ALIGN="right">Expiration</TD>
+ <TD BGCOLOR="#ffffff"><% "$mon/$year" %></TD>
+</TR>
+% }
+
+
+<TR>
+ <TD ALIGN="right">Tax&nbsp;exempt</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->tax ? 'yes' : 'no' %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Postal&nbsp;invoices</TD>
+ <TD BGCOLOR="#ffffff">
+ <% ( grep { $_ eq 'POST' } @invoicing_list ) ? 'yes' : 'no' %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">FAX&nbsp;invoices</TD>
+ <TD BGCOLOR="#ffffff">
+ <% ( grep { $_ eq 'FAX' } @invoicing_list ) ? 'yes' : 'no' %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Email&nbsp;invoices</TD>
+ <TD BGCOLOR="#ffffff">
+ <% join(', ', grep { $_ !~ /^(POST|FAX)$/ } @invoicing_list ) || 'no' %>
+ </TD>
+</TR>
+% if ( $conf->exists('voip-cust_cdr_spools') ) {
+
+ <TR>
+ <TD ALIGN="right">Spool&nbsp;CDRs</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->spool_cdr ? 'yes' : 'no' %></TD>
+ </TR>
+% }
+
+
+</TABLE></TD></TR></TABLE>
+
diff --git a/httemplate/view/cust_main/contacts.html b/httemplate/view/cust_main/contacts.html
new file mode 100644
index 000000000..9c2b38f9a
--- /dev/null
+++ b/httemplate/view/cust_main/contacts.html
@@ -0,0 +1,155 @@
+%
+% my( $cust_main ) = @_;
+% my $conf = new FS::Conf;
+%
+
+
+Billing address
+<% ntable("#cccccc") %><TR><TD><% ntable("#cccccc",2) %>
+<TR>
+ <TD ALIGN="right">Contact&nbsp;name</TD>
+ <TD COLSPAN=3 BGCOLOR="#ffffff">
+ <% $cust_main->last. ', '. $cust_main->first %>
+ </TD>
+% if ( $conf->exists('show_ss') ) {
+
+ <TD ALIGN="right">SS#</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->ss || '&nbsp' %></TD>
+% }
+
+</TR>
+<TR>
+ <TD ALIGN="right">Company</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->company %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Address</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->address1 %></TD>
+</TR>
+% if ( $cust_main->address2 ) {
+
+<TR>
+ <TD ALIGN="right">&nbsp;</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->address2 %></TD>
+</TR>
+% }
+
+<TR>
+ <TD ALIGN="right">City</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->city %></TD>
+ <TD ALIGN="right">State</TD>
+ <TD BGCOLOR="#ffffff"><% state_label($cust_main->state, $cust_main->country) %></TD>
+ <TD ALIGN="right">Zip</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->zip %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Country</TD>
+ <TD BGCOLOR="#ffffff"><% code2country($cust_main->country) %></TD>
+</TR>
+%
+% my $daytime_label = FS::Msgcat::_gettext('daytime') =~ /^(daytime)?$/
+% ? 'Day&nbsp;Phone'
+% : FS::Msgcat::_gettext('daytime');
+% my $night_label = FS::Msgcat::_gettext('night') =~ /^(night)?$/
+% ? 'Night&nbsp;Phone'
+% : FS::Msgcat::_gettext('night');
+%
+
+<TR>
+ <TD ALIGN="right"><% $daytime_label %></TD>
+ <TD COLSPAN=6 BGCOLOR="#ffffff">
+ <% include('/elements/phonenumber.html',
+ $cust_main->daytime,
+ 'callable'=>1
+ )
+ %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right"><% $night_label %></TD>
+ <TD COLSPAN=6 BGCOLOR="#ffffff">
+ <% include('/elements/phonenumber.html',
+ $cust_main->night,
+ 'callable'=>1
+ )
+ %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Fax</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff">
+ <% $cust_main->fax || '&nbsp' %>
+ </TD>
+</TR>
+</TABLE></TD></TR></TABLE>
+% if ( defined $cust_main->dbdef_table->column('ship_last') ) {
+% my $pre = $cust_main->ship_last ? 'ship_' : '';
+%
+
+
+<BR>
+Service address
+<% ntable("#cccccc") %><TR><TD><% ntable("#cccccc",2) %>
+<TR>
+ <TD ALIGN="right">Contact name</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff">
+ <% $cust_main->get("${pre}last"). ', '. $cust_main->get("${pre}first") %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Company</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->get("${pre}company") %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Address</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->get("${pre}address1") %></TD>
+</TR>
+% if ( $cust_main->get("${pre}address2") ) {
+
+<TR>
+ <TD ALIGN="right">&nbsp;</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff"><% $cust_main->get("${pre}address2") %></TD>
+</TR>
+% }
+
+<TR>
+ <TD ALIGN="right">City</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->get("${pre}city") %></TD>
+ <TD ALIGN="right">State</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->get("${pre}state") %></TD>
+ <TD ALIGN="right">Zip</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->get("${pre}zip") %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Country</TD>
+ <TD BGCOLOR="#ffffff"><% code2country( $cust_main->get("${pre}country") ) %></TD>
+</TR>
+<TR>
+ <TD ALIGN="right"><% $daytime_label %></TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff">
+ <% include('/elements/phonenumber.html',
+ $cust_main->get("${pre}daytime"),
+ 'callable'=>1
+ )
+ %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right"><% $night_label %></TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff">
+ <% include('/elements/phonenumber.html',
+ $cust_main->get("${pre}night"),
+ 'callable'=>1
+ )
+ %>
+ </TD>
+</TR>
+<TR>
+ <TD ALIGN="right">Fax</TD>
+ <TD COLSPAN=5 BGCOLOR="#ffffff">
+ <% $cust_main->get("${pre}fax") || '&nbsp' %>
+ </TD>
+</TR>
+</TABLE></TD></TR></TABLE>
+% }
+
diff --git a/httemplate/view/cust_main/misc.html b/httemplate/view/cust_main/misc.html
new file mode 100644
index 000000000..fdc5ba4ea
--- /dev/null
+++ b/httemplate/view/cust_main/misc.html
@@ -0,0 +1,104 @@
+%
+% my( $cust_main ) = @_;
+% my $conf = new FS::Conf;
+% my $date_format = ($conf->config('date_format') || "%m/%d/%Y");
+%
+
+
+<% ntable("#cccccc") %><TR><TD><% &ntable("#cccccc",2) %>
+
+<TR>
+ <TD ALIGN="right">Customer&nbsp;number</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->custnum %></TD>
+</TR>
+
+<TR>
+ <TD ALIGN="right">Status</TD>
+ <TD BGCOLOR="#ffffff"><FONT COLOR="#<% $cust_main->statuscolor %>"><B><% ucfirst($cust_main->status) %></B></FONT></TD>
+</TR>
+%
+% my @agents = qsearch( 'agent', {} );
+% my $agent;
+% unless ( scalar(@agents) == 1 ) {
+% $agent = qsearchs('agent',{ 'agentnum' => $cust_main->agentnum } );
+%
+
+
+<TR>
+ <TD ALIGN="right">Agent</TD>
+ <TD BGCOLOR="#ffffff"><% $agent->agentnum %>: <% $agent->agent %></TD>
+</TR>
+%
+% } else {
+% $agent = $agents[0];
+% }
+%
+% if ( $cust_main->agent_custid ) {
+%
+
+
+<TR>
+ <TD ALIGN="right">Agent customer ref#</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->agent_custid %></TD>
+</TR>
+%
+% }
+%
+% unless ( FS::part_referral->num_part_referral == 1 ) {
+% my $referral = qsearchs('part_referral', {
+% 'refnum' => $cust_main->refnum
+% } );
+%
+
+
+<TR>
+ <TD ALIGN="right">Advertising&nbsp;source</TD>
+ <TD BGCOLOR="#ffffff"><% $referral->refnum %>: <% $referral->referral%></TD>
+</TR>
+% }
+
+
+<TR>
+ <TD ALIGN="right">Referring&nbsp;Customer</TD>
+ <TD BGCOLOR="#ffffff">
+%
+% my $referring_cust_main = '';
+% if ( $cust_main->referral_custnum
+% && ( $referring_cust_main =
+% qsearchs('cust_main', { custnum => $cust_main->referral_custnum } )
+% )
+% ) {
+%
+
+
+<A HREF="<% popurl(1) %>cust_main.cgi?<% $cust_main->referral_custnum %>"><%$cust_main->referral_custnum %>:
+<%
+ ( $referring_cust_main->company
+ ? $referring_cust_main->company. ' ('.
+ $referring_cust_main->last. ', '. $referring_cust_main->first.
+ ')'
+ : $referring_cust_main->last. ', '. $referring_cust_main->first
+ )
+%></A>
+% }
+
+
+ </TD>
+</TR>
+
+<TR>
+ <TD ALIGN="right">Order taker</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->otaker %></TD>
+</TR>
+
+% if ( $conf->exists('cust_main-enable_birthdate') ) {
+
+ <TR>
+ <TD ALIGN="right">Date of Birth</TD>
+ <TD BGCOLOR="#ffffff"><% $cust_main->birthdate ? time2str($date_format, $cust_main->birthdate) : '' %></TD>
+ </TR>
+
+% }
+
+</TABLE></TD></TR></TABLE>
+
diff --git a/httemplate/view/cust_main/notes.html b/httemplate/view/cust_main/notes.html
new file mode 100755
index 000000000..c1a33b020
--- /dev/null
+++ b/httemplate/view/cust_main/notes.html
@@ -0,0 +1,74 @@
+%
+% my $conf = new FS::Conf;
+%
+% $cgi->param('custnum') =~ /^(\d+)$/
+% or die "No customer specified (bad URL)!";
+% my $custnum = $1;
+%
+% my $cust_main = qsearchs('cust_main', {'custnum' => $custnum} );
+% die "Custimer not found!" unless $cust_main;
+%
+% my (@notes) = $cust_main->notes();
+% if ( scalar(@notes) ) {
+
+<STYLE TYPE="text/css">
+
+body { background: #e8e8e8 }
+.inv table { border: none }
+.inv TH { border: none }
+.inv TD { border: none }
+
+</STYLE>
+
+<TABLE CLASS="inv" CELLSPACING=0 CELLPADDING=0 BORDER=0 >
+
+%#<% include('/elements/table-grid.html') %>
+% my $bgcolor1 = '#eeeeee';
+% my $bgcolor2 = '#ffffff';
+% my $bgcolor = '';
+%
+% foreach my $note (@notes) {
+%
+% if ( $bgcolor eq $bgcolor1 ) {
+% $bgcolor = $bgcolor2;
+% } else {
+% $bgcolor = $bgcolor1;
+% }
+%
+%
+
+<TR>
+ <% note_datestr($note,$conf,$bgcolor) %>
+ <TD CLASS="inv" BGCOLOR="<% $bgcolor %>">
+ &nbsp;<%$note->otaker%>&nbsp;
+ </TD>
+ <TD CLASS="inv" BGCOLOR="<% $bgcolor %>">
+ &nbsp;<%$note->comments%>
+ </TD>
+</TR>
+
+% } #end display notes
+
+</TABLE>
+% } else {
+
+<BR>
+% }
+%
+%#subroutines
+%
+%sub note_datestr {
+% my($note, $conf, $bgcolor) = @_ or return '';
+% my $format=qq{<TD class="inv" bgcolor="$bgcolor" align="left"><B>%b</B></TD>}.
+% qq{<TD class="inv" bgcolor="$bgcolor" align="right"><B>&nbsp;%o,</B></TD>}.
+% qq{<TD class="inv" bgcolor="$bgcolor" align="right"><B>&nbsp;%Y&nbsp;</B></TD>};
+% $format .= qq{<TD class="inv" bgcolor="$bgcolor" ALIGN="right"><B>&nbsp;%l</TD>}.
+% qq{<TD class="inv" bgcolor="$bgcolor" ALIGN="center"><B>:</B></TD>}.
+% qq{<TD class="inv" bgcolor="$bgcolor" ALIGN="left"><B>%M</B></TD>}.
+% qq{<TD class="inv" bgcolor="$bgcolor" ALIGN="left"><B>&nbsp;%P&nbsp;</B></TD>}
+% if $conf->exists('cust_main_note-display_times');
+% ( my $strip = time2str($format, $note->_date) ) =~ s/ (\d)/$1/g;
+% $strip;
+% }
+%
+
diff --git a/httemplate/view/cust_main/order_pkg.html b/httemplate/view/cust_main/order_pkg.html
new file mode 100644
index 000000000..6edd18c05
--- /dev/null
+++ b/httemplate/view/cust_main/order_pkg.html
@@ -0,0 +1,40 @@
+%
+% my( $cust_main ) = @_;
+%
+
+
+<SCRIPT TYPE="text/javascript">
+function enable_order_pkg () {
+ if ( document.OrderPkgForm.pkgpart.selectedIndex > 0 ) {
+ document.OrderPkgForm.submit.disabled = false;
+ } else {
+ document.OrderPkgForm.submit.disabled = true;
+ }
+}
+</SCRIPT>
+
+<FORM NAME="OrderPkgForm" ACTION="<% $p %>edit/process/quick-cust_pkg.cgi" METHOD="POST">
+
+<INPUT TYPE="hidden" NAME="custnum" VALUE="<% $cust_main->custnum %>">
+
+<SELECT NAME="pkgpart" onChange="enable_order_pkg()"><OPTION>Order additional package
+%
+%foreach my $part_pkg (
+% qsearch( 'part_pkg', { 'disabled' => '' }, '',
+% ' AND 0 < ( SELECT COUNT(*) FROM type_pkgs '.
+% ' WHERE typenum = '. $cust_main->agent->typenum.
+% ' AND type_pkgs.pkgpart = part_pkg.pkgpart )'
+% )
+%) {
+%
+
+
+ <OPTION VALUE="<% $part_pkg->pkgpart %>"><% $part_pkg->pkg %> - <% $part_pkg->comment %>
+% }
+
+
+</SELECT>
+
+<INPUT NAME="submit" TYPE="submit" VALUE="Order Package" disabled>
+
+</FORM>
diff --git a/httemplate/view/cust_main/packages.html b/httemplate/view/cust_main/packages.html
new file mode 100755
index 000000000..0278f22e9
--- /dev/null
+++ b/httemplate/view/cust_main/packages.html
@@ -0,0 +1,575 @@
+%
+% my( $cust_main ) = @_;
+% my $conf = new FS::Conf;
+%
+% my $curuser = $FS::CurrentUser::CurrentUser;
+%
+% my $packages = get_packages($cust_main, $conf);
+%
+
+
+<A NAME="cust_pkg"><FONT SIZE="+2">Packages</FONT></A>
+% if ( $curuser->access_right('Order customer package') ) {
+
+ <% include('order_pkg.html', $cust_main ) %>
+% }
+% if ( $curuser->access_right('One-time charge')
+% && $conf->config('payby-default') ne 'HIDE'
+% ) {
+%
+
+ <% include('quick-charge.html', $cust_main ) %>
+% }
+% if ( $curuser->access_right('Bulk change customer packages') ) {
+
+ <A HREF="<% $p %>edit/cust_pkg.cgi?<% $cust_main->custnum %>">Bulk order and cancel packages</A> (preserves services)
+% }
+
+
+<BR><BR>
+% if ( @$packages ) {
+
+Current packages
+% }
+% if ( $cust_main->num_cancelled_pkgs ) {
+% if ( $cgi->param('showcancelledpackages') eq '0' #see if it was set by me
+% || ( $conf->exists('hidecancelledpackages')
+% && ! $cgi->param('showcancelledpackages')
+% )
+% )
+% {
+% $cgi->param('showcancelledpackages', 1);
+%
+
+ ( <a href="<% $cgi->self_url %>">show
+% } else {
+% $cgi->param('showcancelledpackages', 0);
+%
+
+ ( <a href="<% $cgi->self_url %>">hide
+% }
+
+ cancelled packages</a> )
+% }
+% if ( @$packages ) {
+
+
+<% include('/elements/table-grid.html') %>
+% my $bgcolor1 = '#eeeeee';
+% my $bgcolor2 = '#ffffff';
+% my $bgcolor = '';
+%
+
+
+<TR>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Package</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Status</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Services</TH>
+</TR>
+%
+%foreach my $pkg (sort pkgsort_pkgnum_cancel @$packages) {
+%
+% if ( $bgcolor eq $bgcolor1 ) {
+% $bgcolor = $bgcolor2;
+% } else {
+% $bgcolor = $bgcolor1;
+% }
+%
+%
+
+
+<!--pkgnum: <%$pkg->{pkgnum}%>-->
+<TR>
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <A NAME="cust_pkg<%$pkg->{pkgnum}%>"><%$pkg->{pkgnum}%></A>:
+ <%$pkg->{pkg}%> - <%$pkg->{comment}%><BR>
+ <FONT SIZE=-1>
+% unless ( $pkg->{cancel} ) {
+% if ( $curuser->access_right('Change customer package') ) {
+
+ (&nbsp;<%pkg_change_link($pkg)%>&nbsp;)
+% }
+% if ( $curuser->access_right('Edit customer package dates') ) {
+
+ (&nbsp;<%pkg_dates_link($pkg)%>&nbsp;)
+% }
+% if ( $curuser->access_right('Customize customer package') ) {
+
+ (&nbsp;<%pkg_customize_link($pkg,$cust_main->custnum)%>&nbsp;)
+% }
+% }
+
+ </FONT>
+ </TD>
+ <TD CLASS="inv" BGCOLOR="<% $bgcolor %>">
+ <TABLE CLASS="inv" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
+%
+% sub myfreq {
+% my $part_pkg = shift;
+% my $freq = $part_pkg->freq_pretty;
+% $freq =~ s/ /&nbsp;/g;
+% $freq;
+% }
+%
+% #this should use cust_pkg->status and cust_pkg->statuscolor eventually
+%
+% my $colspan = $conf->exists('cust_pkg-display_times') ? 8 : 4;
+% my $width = $conf->exists('cust_pkg-display_times') ? '38%' : '56%';
+%
+% #false laziness w/edit/REAL_cust_pkg.cgi
+% my( $billed_or_prepaid, $last_bill_or_renewed, $next_bill_or_prepaid_until );
+% unless ( $pkg->{'part_pkg'}->is_prepaid ) {
+% $billed_or_prepaid = 'billed';
+% $last_bill_or_renewed = 'Last&nbsp;bill';
+% $next_bill_or_prepaid_until = 'Next&nbsp;bill';
+% } else {
+% $billed_or_prepaid = 'prepaid';
+% $last_bill_or_renewed = 'Renewed';
+% $next_bill_or_prepaid_until = 'Prepaid&nbsp;until';
+% }
+%
+%
+% if ( $pkg->{cancel} ) {
+ <!-- #status: cancelled -->
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><FONT COLOR="#ff0000"><B>Cancelled&nbsp;</B></FONT></TD>
+ <% pkg_datestr($pkg,'cancel',$conf) %>
+ </TR>
+% unless ( $pkg->{setup} ) {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>Never billed</TD>
+ </TR>
+% } else {
+
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Setup&nbsp;</TD>
+ <% pkg_datestr($pkg, 'setup',$conf) %>
+ </TR>
+% if ( $pkg->{'last_bill'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><% $last_bill_or_renewed %>&nbsp;</TD>
+ <% pkg_datestr($pkg, 'last_bill',$conf) %>
+ </TR>
+% }
+% if ( $pkg->{'susp'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Suspended&nbsp;</TD>
+ <% pkg_datestr($pkg, 'susp',$conf) %>
+ </TR>
+% }
+% }
+% } else {
+% if ( $pkg->{susp} ) {
+ <!-- #status: suspended -->
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><FONT COLOR="#FF9900"><B>Suspended</B>&nbsp;</FONT></TD>
+ <% pkg_datestr($pkg,'susp',$conf) %>
+ </TR>
+% unless ( $pkg->{setup} ) {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>Never billed</TD>
+ </TR>
+% } else {
+
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Setup&nbsp;</TD>
+ <% pkg_datestr($pkg, 'setup',$conf) %>
+ </TR>
+% }
+% if ( $pkg->{'last_bill'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><% $last_bill_or_renewed %>&nbsp;</TD>
+ <% pkg_datestr($pkg, 'last_bill',$conf) %>
+ </TR>
+% }
+
+
+ <!-- # next bill ?? -->
+% if ( $pkg->{'expire'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Expires&nbsp;</TD>
+ <% pkg_datestr($pkg, 'expire',$conf) %>
+ </TR>
+% }
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>
+ <FONT SIZE=-1>
+% if ( $curuser->access_right('Unsuspend customer package') ) {
+
+ (&nbsp;<% pkg_unsuspend_link($pkg) %>&nbsp;)
+% }
+% if ( $curuser->access_right('Cancel customer package') ) {
+
+ (&nbsp;<% pkg_cancel_link($pkg) %>&nbsp;)
+% }
+
+ </FONT>
+ </TD>
+ </TR>
+% } else {
+ <!-- #status: active -->
+% unless ( $pkg->{setup} ) {
+ <!-- #not setup -->
+% unless ( $pkg->{'freq'} ) {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>Not&nbsp;yet&nbsp;billed&nbsp;(one-time&nbsp;charge)</TD>
+ </TR>
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>
+ <FONT SIZE=-1>
+% if ( $curuser->access_right('Cancel customer package immediately') ) {
+
+ (&nbsp;<% pkg_cancel_link($pkg) %>&nbsp;)
+% }
+
+ </FONT>
+ </TD>
+ </TR>
+% } else {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>Not&nbsp;yet&nbsp;billed&nbsp;(<% $billed_or_prepaid %>&nbsp;<% myfreq($pkg->{part_pkg}) %>)</TD>
+ </TR>
+% }
+% } else {
+ <!-- #setup -->
+% unless ( $pkg->{freq} ) {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>One-time&nbsp;charge</TD>
+ </TR>
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Billed&nbsp;</TD>
+ <% pkg_datestr($pkg,'setup',$conf) %>
+ </TR>
+% } else {
+
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>><FONT COLOR="#00CC00"><B>Active</B></FONT>,&nbsp;<% $billed_or_prepaid %>&nbsp;<% myfreq($pkg->{part_pkg}) %></TD>
+ </TR>
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Setup&nbsp;</TD>
+ <% pkg_datestr($pkg, 'setup',$conf) %>
+ </TR>
+% }
+% }
+% if ( $pkg->{'last_bill'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><% $last_bill_or_renewed %>&nbsp;</TD>
+ <% pkg_datestr($pkg, 'last_bill',$conf) %>
+ </TR>
+% }
+% if ( $pkg->{'next_bill'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right"><% $next_bill_or_prepaid_until %>&nbsp;</TD>
+ <% pkg_datestr($pkg, 'next_bill',$conf) %>
+ </TR>
+% }
+% if ( $pkg->{'expire'} ) {
+
+ <TR>
+ <TD WIDTH="<%$width%>" ALIGN="right">Expires&nbsp;</TD>
+ <% pkg_datestr($pkg, 'expire',$conf) %>
+ </TR>
+% }
+% if ( $pkg->{freq} ) {
+
+ <TR>
+ <TD COLSPAN=<%$colspan%>>
+ <FONT SIZE=-1>
+% if ( $curuser->access_right('Suspend customer package') ) {
+
+ (&nbsp;<% pkg_suspend_link($pkg) %>&nbsp;)
+% }
+% if ( $curuser->access_right('Cancel customer package immediately') ) {
+
+ (&nbsp;<% pkg_cancel_link($pkg) %>&nbsp;)
+% }
+% if ( $curuser->access_right('Cancel customer package later') ) {
+
+ (&nbsp;<% pkg_expire_link($pkg) %>&nbsp;)
+% }
+
+ <FONT>
+ </TD>
+ </TR>
+% }
+% }
+% }
+
+
+</TABLE>
+</TD>
+
+<TD CLASS="inv" BGCOLOR="<% $bgcolor %>">
+ <TABLE CLASS="inv" BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH="100%">
+%
+% foreach my $svcpart (sort {$a->{svcpart} <=> $b->{svcpart}} @{$pkg->{svcparts}}) {
+% foreach my $service (@{$svcpart->{services}}) {
+%
+
+ <TR>
+ <TD ALIGN="right" VALIGN="top" ROWSPAN=2><%svc_link($svcpart,$service)%></TD>
+ <TD STYLE="padding-bottom:0px"><B><%svc_label_link($svcpart,$service)%></B></TD>
+ </TR>
+% if ( $curuser->access_right('Unprovision customer service') ) {
+
+ <TR>
+ <TD ALIGN="right" VALIGN="top" STYLE="padding-bottom:5px;padding-top:0px"><FONT SIZE="-2">(&nbsp;<%svc_unprovision_link($service)%>&nbsp;)</FONT></TD>
+ </TR>
+% }
+% }
+% if ( $curuser->access_right('Provision customer service')
+% && $svcpart->{count} < $svcpart->{quantity}
+% )
+% {
+%
+
+
+ <TR>
+ <TD COLSPAN=2 ALIGN="center" STYLE="padding-bottom:4px;padding-top:0px">
+ <B><% svc_provision_link($pkg, $svcpart, $conf, $curuser) %></B>
+ </TD>
+ </TR>
+% }
+% }
+
+
+</TABLE>
+</TD>
+% } #end display packages
+%
+
+
+</TABLE>
+% } else {
+
+<BR>
+% }
+%
+%#subroutines
+%
+%sub get_packages {
+% my $cust_main = shift or return undef;
+% my $conf = shift;
+%
+% my @packages = ();
+% my $method;
+% if ( $cgi->param('showcancelledpackages') eq '0' #see if it was set by me
+% || ( $conf->exists('hidecancelledpackages')
+% && ! $cgi->param('showcancelledpackages') )
+% )
+% {
+% $method = 'ncancelled_pkgs';
+% } else {
+% $method = 'all_pkgs';
+% }
+%
+% foreach my $cust_pkg ( $cust_main->$method() ) {
+%
+% my $part_pkg = $cust_pkg->part_pkg;
+%
+% my %pkg = ();
+%
+% #to get back to the original object... should use it in the first place!!
+% $pkg{cust_pkg} = $cust_pkg;
+% $pkg{part_pkg} = $part_pkg;
+%
+% $pkg{pkgnum} = $cust_pkg->pkgnum;
+% $pkg{pkg} = $part_pkg->pkg;
+% $pkg{pkgpart} = $part_pkg->pkgpart;
+% $pkg{comment} = $part_pkg->getfield('comment');
+% $pkg{freq} = $part_pkg->freq;
+% $pkg{setup} = $cust_pkg->getfield('setup');
+% $pkg{last_bill} = $cust_pkg->getfield('last_bill');
+% $pkg{next_bill} = $cust_pkg->getfield('bill');
+% $pkg{susp} = $cust_pkg->getfield('susp');
+% $pkg{expire} = $cust_pkg->getfield('expire');
+% $pkg{cancel} = $cust_pkg->getfield('cancel');
+%
+%
+% my %svcparts = map {
+% $_->svcpart => {
+% $_->part_svc->hash,
+% 'quantity' => $_->quantity,
+% 'count' => $cust_pkg->num_cust_svc($_->svcpart),
+% #'services' => [],
+% };
+% } $part_pkg->pkg_svc;
+%
+% foreach my $cust_svc ( $cust_pkg->cust_svc ) {
+% #warn "svcnum ". $cust_svc->svcnum. " / svcpart ". $cust_svc->svcpart. "\n";
+% my $svc = {
+% 'svcnum' => $cust_svc->svcnum,
+% 'label' => ($cust_svc->label)[1],
+% };
+%
+% #false laziness with above, to catch extraneous services. whole
+% #damn thing should be OO...
+% my $svcpart = ( $svcparts{$cust_svc->svcpart} ||= {
+% $cust_svc->part_svc->hash,
+% 'quantity' => 0,
+% 'count' => $cust_pkg->num_cust_svc($cust_svc->svcpart),
+% #'services' => [],
+% } );
+%
+% push @{$svcpart->{services}}, $svc;
+%
+% }
+%
+% $pkg{svcparts} = [ values %svcparts ];
+%
+% push @packages, \%pkg;
+%
+% }
+%
+% return \@packages;
+%
+%}
+%
+%sub svc_link {
+%
+% my ($svcpart, $svc) = (shift,shift) or return '';
+% return qq!<A HREF="${p}view/$svcpart->{svcdb}.cgi?$svc->{svcnum}">$svcpart->{svc}</A>!;
+%
+%}
+%
+%sub svc_label_link {
+%
+% my ($svcpart, $svc) = (shift,shift) or return '';
+% return qq!<A HREF="${p}view/$svcpart->{svcdb}.cgi?$svc->{svcnum}">$svc->{label}</A>!;
+%
+%}
+%
+%sub svc_provision_link {
+% my ($pkg, $svcpart, $conf, $curuser) = @_;
+% ( my $svc_nbsp = $svcpart->{svc} ) =~ s/\s+/&nbsp;/g;
+% my $num_left = $svcpart->{quantity} - $svcpart->{count};
+% my $pkgnum_svcpart = "pkgnum$pkg->{pkgnum}-svcpart$svcpart->{svcpart}";
+%
+% my $url;
+% if ( $svcpart->{svcdb} eq 'svc_external'
+% && $conf->exists('svc_external-skip_manual')
+% ) {
+% $url = "${p}edit/process/$svcpart->{svcdb}.cgi?".
+% "pkgnum=$pkg->{pkgnum}&".
+% "svcpart=$svcpart->{svcpart}";
+% } else {
+% $url = "${p}edit/$svcpart->{svcdb}.cgi?$pkgnum_svcpart";
+% }
+%
+% my $link = qq!<A CLASS="provision" HREF="$url">!.
+% "Provision&nbsp;$svc_nbsp&nbsp;($num_left)</A>";
+% if ( $conf->exists('legacy_link')
+% && $curuser->access_right('View/link unlinked services')
+% )
+% {
+% $link .= '<BR>'.
+% qq!<A CLASS="provision" HREF="${p}misc/link.cgi?!.
+% qq!$pkgnum_svcpart">!.
+% "Link&nbsp;to&nbsp;legacy&nbsp;$svc_nbsp&nbsp;($num_left)</A>";
+% }
+% $link;
+%}
+%
+%sub svc_unprovision_link {
+% my $svc = shift or return '';
+% qq!<A HREF="javascript:areyousure('${p}misc/unprovision.cgi?$svc->{svcnum}',!.
+% qq!'Permanently unprovision and delete this service?')">Unprovision</A>!;
+%}
+%
+%# This should be generalized to use config options to determine order.
+%sub pkgsort_pkgnum_cancel {
+% if ($a->{cancel} and $b->{cancel}) {
+% return ($a->{pkgnum} <=> $b->{pkgnum});
+% } elsif ($a->{cancel} or $b->{cancel}) {
+% return (-1) if ($b->{cancel});
+% return (1) if ($a->{cancel});
+% return (0);
+% } else {
+% return($a->{pkgnum} <=> $b->{pkgnum});
+% }
+%}
+%
+%sub pkg_datestr {
+% my($pkg, $field, $conf) = @_ or return '';
+% return '&nbsp;' unless $pkg->{$field};
+% my $format = '<TD align="left"><B>%b</B></TD>'.
+% '<TD align="right"><B>&nbsp;%o,</B></TD>'.
+% '<TD align="right"><B>&nbsp;%Y</B></TD>';
+% #$format .= '&nbsp;<FONT SIZE=-3>%l:%M:%S%P&nbsp;%z</FONT>'
+% $format .= '<TD ALIGN="right"><B>&nbsp;%l</TD>'.
+% '<TD ALIGN="center"><B>:</B></TD>'.
+% '<TD ALIGN="left"><B>%M</B></TD>'.
+% '<TD ALIGN="left"><B>&nbsp;%P</B></TD>'
+% if $conf->exists('cust_pkg-display_times');
+% ( my $strip = time2str($format, $pkg->{$field}) ) =~ s/ (\d)/$1/g;
+% $strip;
+%}
+%
+%sub pkg_change_link {
+% my $pkg = shift or return '';
+% return qq!<a href="${p}misc/change_pkg.cgi?$pkg->{pkgnum}">!.
+% qq!Change&nbsp;package</a>!;
+%}
+%
+%sub pkg_suspend_link {
+% my $pkg = shift or return '';
+% return qq!<a href="${p}misc/susp_pkg.cgi?$pkg->{pkgnum}">Suspend</a>!;
+%}
+%
+%sub pkg_unsuspend_link {
+% my $pkg = shift or return '';
+% return qq!<a href="${p}misc/unsusp_pkg.cgi?$pkg->{pkgnum}">Unsuspend</a>!;
+%}
+%
+%sub pkg_cancel_link {
+% my $pkg = shift or return '';
+% qq!<A HREF="javascript:areyousure('${p}misc/cancel_pkg.cgi?$pkg->{pkgnum}', !.
+% qq!'Permanently delete included services and cancel this package?')">!.
+% qq!Cancel now</A>!;
+%}
+%
+%sub pkg_expire_link {
+% my $pkg = shift or return '';
+% qq!<A HREF="${p}misc/expire_pkg.cgi?$pkg->{pkgnum}">Cancel later</A>!;
+%}
+%
+%sub pkg_dates_link {
+% my $pkg = shift or return '';
+% qq!<A HREF="${p}edit/REAL_cust_pkg.cgi?$pkg->{pkgnum}">Edit&nbsp;dates</A>!;
+%}
+%
+%sub pkg_customize_link {
+% my $pkg = shift or return '';
+% my $custnum = shift;
+% qq!<A HREF="${p}edit/part_pkg.cgi?keywords=$custnum;clone=$pkg->{pkgpart};!.
+% qq!pkgnum=$pkg->{pkgnum}">Customize</A>!;
+%}
+%
+%
+
diff --git a/httemplate/view/cust_main/payment_history.html b/httemplate/view/cust_main/payment_history.html
new file mode 100644
index 000000000..4e4cd154f
--- /dev/null
+++ b/httemplate/view/cust_main/payment_history.html
@@ -0,0 +1,561 @@
+<BR><BR><A NAME="history"><FONT SIZE="+2">Payment History</FONT></A><BR>
+
+% 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')
+% ) {
+ <% $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')
+% ) {
+ <% $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>
+% }
+
+%#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">!
+% : '';
+% push @history, {
+% 'date' => $cust_bill->_date,
+% 'desc' => $link. $pre.
+% "Invoice #$invnum (Balance \$". $cust_bill->owed. ')'.
+% $post. ( $link ? '</A>' : '' ),
+% '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->payinfo_masked;
+% } elsif ( $payby eq 'CHEK' && $cust_pay->payinfo =~ /^(\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>';
+% $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 .= '&nbsp;&nbsp;'.
+% '$'. $app->amount.
+% ' applied to Invoice #'. $app->invnum.
+% '<BR>';
+% #' on '. time2str("%D", $cust_bill_pay->_date).
+% } elsif ( $app->isa('FS::cust_pay_refund') ) {
+% $desc .= '&nbsp;&nbsp;'.
+% '$'. $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 .= '&nbsp;&nbsp;'.
+% '<B><FONT COLOR="#FF0000">$'.
+% $cust_pay->unapplied. ' unapplied</FONT></B>'.
+% 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>)!.
+% '<BR>';
+% }
+% }
+%
+% 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>)!;
+% }
+%
+% push @history, {
+% 'date' => $cust_pay->_date,
+% 'desc' => $pre. "Payment$post$info$desc".
+% "$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->payinfo_masked
+% : $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>';
+% $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 .= '&nbsp;&nbsp;'.
+% '$'. $app->amount.
+% ' applied to Invoice #'. $app->invnum.
+% '<BR>';
+% #' on '. time2str("%D", $app->_date).
+% } elsif ( $app->isa('FS::cust_credit_refund') ) {
+% $desc .= '&nbsp;&nbsp;'.
+% '$'. $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 .= '&nbsp;&nbsp;<B><FONT COLOR="#FF0000">$'.
+% $cust_credit->credited. ' unapplied</FONT></B>'.
+% 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>)!.
+% '<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->payinfo_masked
+% : $cust_refund->payinfo;
+%
+% $payby =~ s/^BILL$/Check #/ if $payinfo;
+% $payby =~ s/^CHEK$/Electronic check /;
+% $payby =~ s/^(CARD|COMP)$/$1 /;
+%
+% push @history, {
+% 'date' => $cust_refund->_date,
+% 'desc' => "Refund ($payby$payinfo) by ". $cust_refund->otaker,
+% 'refund' => $cust_refund->refund,
+% };
+%
+%}
+%
+%
+
+
+<% include("/elements/table-grid.html") %>
+% my $bgcolor1 = '#eeeeee';
+% my $bgcolor2 = '#ffffff';
+% my $bgcolor = '';
+%
+
+
+<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>
+</TR>
+%
+%#display payment history
+%
+%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;
+%
+%foreach my $item ( sort { $a->{'date'} <=> $b->{'date'} } @history ) {
+%
+% my $display;
+% if ( $item->{'date'} < $older_than ) {
+% $display = ' STYLE="display:none" ';
+% $hidden = 1;
+% } else {
+%
+% $display = '';
+%
+% if ( $hidden && ! $seen++ ) {
+% ( my $balance_forward = $money_char. $balance ) =~ s/^\$\-/-&nbsp;\$/;
+%
+
+
+ <TR ID="balance_forward_row">
+ <TD CLASS="grid" BGCOLOR="#dddddd">
+ <% time2str("%D",$item->{'date'}) %>
+ </TD>
+
+ <TD CLASS="grid" BGCOLOR="#dddddd">
+ <I>Starting balance on <% time2str("%D",$item->{'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>
+
+ </TR>
+%
+% }
+%
+% }
+%
+% if ( $bgcolor eq $bgcolor1 ) {
+% $bgcolor = $bgcolor2;
+% } else {
+% $bgcolor = $bgcolor1;
+% }
+%
+% my $charge = exists($item->{'charge'})
+% ? sprintf("$money_char\%.2f", $item->{'charge'})
+% : '';
+%
+% my $payment = exists($item->{'payment'})
+% ? sprintf("-&nbsp;$money_char\%.2f", $item->{'payment'})
+% : '';
+%
+% $payment ||= sprintf( "<DEL>-&nbsp;$money_char\%.2f</DEL>",
+% $item->{'void_payment'}
+% )
+% if exists($item->{'void_payment'});
+%
+% my $credit = exists($item->{'credit'})
+% ? sprintf("-&nbsp;$money_char\%.2f", $item->{'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/^\$\-/-&nbsp;\$/;
+%
+%
+
+
+ <TR <% $display ? $display.' ID="old_history'.$old_history++.'"' : ''%>>
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>">
+% unless ( !$target || $target{$target}++ ) {
+
+ <A NAME="<% $target %>">
+% }
+
+ <% time2str("%D",$item->{'date'}) %>
+% if ( $target && $target{$target} == 1 ) {
+
+ </A>
+% }
+
+ </FONT>
+ </TD>
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $item->{'desc'} %>
+ </TD>
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $charge %>
+ </TD>
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $payment %>
+ </TD>
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $credit %>
+ </TD>
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $refund %>
+ </TD>
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>">
+ <% $showbalance %>
+ </TD>
+ </TR>
+% }
+
+
+</TABLE>
+
+<SCRIPT TYPE="text/javascript">
+
+function show_history () {
+ //alert('showing history!');
+
+ var balance_forward_row = document.getElementById('balance_forward_row');
+
+ balance_forward_row.style.display = 'none';
+ for ( var i = 0; i < <% $old_history %>; i++ ) {
+ var oldRow = document.getElementById('old_history'+i);
+ oldRow.style.display = '';
+ }
+
+}
+
+</SCRIPT>
+
+<%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');
+#@payby = (qw( CARD DCRD CHEK DCHK LECB BILL CASH WEST COMP ))
+@payby = (qw( CARD DCRD CHEK DCHK LECB BILL CASH COMP ))
+ unless @payby;
+my %payby = map { $_=>1 } @payby;
+
+</%init>
diff --git a/httemplate/view/cust_main/quick-charge.html b/httemplate/view/cust_main/quick-charge.html
new file mode 100644
index 000000000..be8b9d838
--- /dev/null
+++ b/httemplate/view/cust_main/quick-charge.html
@@ -0,0 +1,19 @@
+%
+% my( $cust_main ) = @_;
+%
+
+
+<FORM ACTION="<%$p%>edit/process/quick-charge.cgi" METHOD="POST">
+
+<INPUT TYPE="hidden" NAME="custnum" VALUE="<% $cust_main->custnum %>">
+
+Description:<INPUT TYPE="text" NAME="pkg">
+
+Amount:<INPUT TYPE="text" NAME="amount" SIZE=6>
+
+<% include('/elements/select-taxclass.html') %>
+
+<INPUT TYPE="submit" VALUE="One-time charge">
+
+</FORM>
+
diff --git a/httemplate/view/cust_main/tickets.html b/httemplate/view/cust_main/tickets.html
new file mode 100644
index 000000000..84cc90299
--- /dev/null
+++ b/httemplate/view/cust_main/tickets.html
@@ -0,0 +1,78 @@
+%
+% my( $cust_main ) = @_;
+%
+% my $conf = new FS::Conf;
+% my $num = $conf->config('cust_main-max_tickets') || 10;
+%
+% my @tickets = ();
+% unless ( $conf->config('ticket_system-custom_priority_field') ) {
+%
+% @tickets =
+% @{ FS::TicketSystem->customer_tickets($cust_main->custnum, $num) };
+%
+% } else {
+%
+% foreach my $priority (
+% $conf->config('ticket_system-custom_priority_field-values'), ''
+% ) {
+% last if scalar(@tickets) >= $num;
+% push @tickets,
+% @{ FS::TicketSystem->customer_tickets( $cust_main->custnum,
+% $num - scalar(@tickets),
+% $priority,
+% )
+% };
+% }
+%
+% }
+%
+%
+
+<A NAME="tickets"><FONT SIZE="+2">Tickets</FONT></A>
+<BR>
+
+(<A HREF="<% FS::TicketSystem->href_customer_tickets($cust_main->custnum) %>">View all tickets for this customer</A>)
+(<A HREF="<% FS::TicketSystem->href_new_ticket($cust_main, join(', ', grep { $_ !~ /^(POST|FAX)$/ } $cust_main->invoicing_list ) ) %>">New ticket for this customer</A>)
+
+<% include("/elements/table-grid.html") %>
+% my $bgcolor1 = '#eeeeee';
+% my $bgcolor2 = '#ffffff';
+% my $bgcolor = '';
+%
+
+
+<TR>
+ <TH CLASS="grid" BGCOLOR="#cccccc">#</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Subject</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Priority</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Queue</TH>
+ <TH CLASS="grid" BGCOLOR="#cccccc">Status</TH>
+</TR>
+% foreach my $ticket ( @tickets ) {
+% my $href = FS::TicketSystem->href_ticket($ticket->{id});
+% if ( $bgcolor eq $bgcolor1 ) {
+% $bgcolor = $bgcolor2;
+% } else {
+% $bgcolor = $bgcolor1;
+% }
+%
+
+
+<TR>
+
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><A HREF=<%$href%>><% $ticket->{id} %></A></TD>
+
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><A HREF=<%$href%>><% $ticket->{subject} %></A></TD>
+
+ <TD ALIGN="right" CLASS="grid" BGCOLOR="<% $bgcolor %>"><% $ticket->{content} || $ticket->{priority} %></TD>
+
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><% $ticket->{name} %></TD>
+
+ <TD CLASS="grid" BGCOLOR="<% $bgcolor %>"><% $ticket->{status} %></TD>
+
+</TR>
+% }
+
+
+</TABLE>
+