deuglify
[freeside.git] / httemplate / search / cust_main.cgi
index 916ccf2..9ef3847 100755 (executable)
@@ -71,7 +71,7 @@ if ( $cgi->param('browse')
     } elsif ( $query eq 'tickets' ) {
       $sortby = \*tickets_sort;
       $orderby = "ORDER BY tickets DESC";
-      push @select, FS::TicketSystem->sql_customer_tickets. " as tickets";
+      push @select, FS::TicketSystem->sql_num_customer_tickets. " as tickets";
       push @addl_headers, 'Tickets';
       push @addl_cols, 'tickets';
     } else {
@@ -401,21 +401,29 @@ END
       print "<TD ROWSPAN=$rowspan ALIGN=right>";
       if ( $addl_col eq 'tickets' ) {
         if ( @custom_priorities ) {
-          foreach my $priority ( @custom_priorities ) {
-            print '<A HREF="'.
-                    FS::TicketSystem->href_customer_tickets($custnum,$priority).
-                  '">'.
-                  FS::TicketSystem->num_customer_tickets($custnum,$priority).
-                  "&nbsp;$priority</A><BR>";
+          print '<TABLE>';
+          foreach my $priority ( @custom_priorities, '' ) {
+            my $ahref =
+              '<A HREF="'.
+                FS::TicketSystem->href_customer_tickets($custnum,$priority).
+              '">';
+            print "<TR><TD ALIGN=right>$ahref".
+                    FS::TicketSystem->num_customer_tickets($custnum,$priority).
+                  "</A></TD>".
+                  "<TD ALIGN=left>$ahref".
+                  ( $priority || '<i>(none)</i>' ).
+                  "</A></TD></TR>";
           }
+          print '<TR><TD BGCOLOR="#000000" COLSPAN=2></TD></TR>'.
+                '<TR><TD ALIGN=right>';
         }
-        print '<A HREF="'.
-              FS::TicketSystem->href_customer_tickets($cust_main->custnum, $p).
-              '">'.
-              $cust_main->get($addl_col);
-        print '&nbsp;total'
+        my $ahref =
+          '<A HREF="'.
+            FS::TicketSystem->href_customer_tickets($custnum).
+          '">';
+        print $ahref. $cust_main->get($addl_col). '</A>';
+        print "</TD><TD ALIGN=left>${ahref}Total</A></TD></TR></TABLE>"
           if @custom_priorities;
-        print "</A>";
       } else {
         print $cust_main->get($addl_col);
       }