X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=FS%2FFS%2FTicketSystem%2FRT_Internal.pm;h=8fce918e07705691008c51d0b5899181306d9d3d;hb=194c053a60b8839c3cfc6a24efe0b8aeb286f31c;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..8fce918e0 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;