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_num_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
21 if ( $RT::URI::freeside::URL ) {
22 $RT::URI::freeside::URL. 'rt/';
24 'http://you_need_to_set_RT_URI_freeside_URL_in_SiteConfig.pm/';