X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FTicketSystem%2FRT_Internal.pm;h=d24a96c045053c3c6a26d9778ba5d9d07ca6c1ea;hb=810ae1507e9ee10440ea7ef5f8cc292b2d620bc6;hp=ec0c3f7be8889df35276b300f37bc20c39bea952;hpb=f7fd2a3e34da751cbc02bbf215e99c6dc89adc15;p=freeside.git diff --git a/FS/FS/TicketSystem/RT_Internal.pm b/FS/FS/TicketSystem/RT_Internal.pm index ec0c3f7be..d24a96c04 100644 --- a/FS/FS/TicketSystem/RT_Internal.pm +++ b/FS/FS/TicketSystem/RT_Internal.pm @@ -2,10 +2,13 @@ package FS::TicketSystem::RT_Internal; use strict; use vars qw( @ISA ); +use FS::UID qw(dbh); +use FS::CGI qw(popurl); +use FS::TicketSystem::RT_Libs; @ISA = qw( FS::TicketSystem::RT_Libs ); -sub sql_customer_tickets { +sub sql_num_customer_tickets { "( select count(*) from tickets join links on ( tickets.id = links.localbase ) where ( status = 'new' or status = 'open' or status = 'stalled' ) @@ -13,5 +16,14 @@ sub sql_customer_tickets { )"; } +sub baseurl { + #my $self = shift; + if ( $RT::URI::freeside::URL ) { + $RT::URI::freeside::URL. '/rt/'; + } else { + 'http://you_need_to_set_RT_URI_freeside_URL_in_SiteConfig.pm/'; + } +} + 1;