1 package FS::TicketSystem::RT_Internal;
6 use FS::CGI qw(popurl);
7 use FS::TicketSystem::RT_Libs;
9 @ISA = qw( FS::TicketSystem::RT_Libs );
11 sub sql_customer_tickets {
12 "( select count(*) from tickets
13 join links on ( tickets.id = links.localbase )
14 where ( status = 'new' or status = 'open' or status = 'stalled' )
15 and target = 'freeside://freeside/cust_main/' || custnum
19 sub num_customer_tickets {
20 my( $self, $custnum, $priority ) = ( shift, shift, shift );
21 $self->SUPER::new_customer_tickets( $custnum, $priority, dbh );
24 sub href_customer_tickets {
26 # well, 2 is wrong here but will have to do for now
27 popurl(2).'rt/'. $self->SUPER::href_customer_tickets(@_);