FS/FS/TicketSystem/RT_Internal.pm


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

package FS::TicketSystem::RT_Internal;

use strict;
use vars qw( @ISA );

@ISA = qw( FS::TicketSystem::RT_Libs );

sub sql_customer_tickets {
  "( select count(*) from tickets
                     join links on ( tickets.id = links.localbase )
     where ( status = 'new' or status = 'open' or status = 'stalled' )
       and target = 'freeside://freeside/cust_main/' || custnum
   )";
}

1;