use FS::UID qw(dbh);
use FS::Record qw(qsearchs);
use FS::cust_main;
+use Carp qw(cluck);
$me = '[FS::TicketSystem::RT_External]';
$DEBUG = 0;
}
+sub comments_on_tickets {
+ my ($self, $custnum, $limit, $time ) = @_;
+ $limit ||= 0;
+
+ my( $from_sql, @param) = $self->_from_customer( $custnum );
+ my $sql = qq{
+ SELECT transactions.*, Attachments.content, Tickets.subject
+ FROM transactions
+ JOIN Attachments ON( Attachments.transactionid = transactions.id )
+ JOIN Tickets ON ( Tickets.id = transactions.objectid )
+ JOIN Links ON ( Tickets.id = Links.LocalBase
+ AND Links.Base LIKE '%/ticket/' || Tickets.id )
+
+
+ WHERE ( Status = 'new' OR Status = 'open' OR Status = 'stalled' )
+ AND Target = 'freeside://freeside/cust_main/$custnum'
+ AND transactions.type = 'Comment'
+ AND transactions.created >= (SELECT TIMESTAMP WITH TIME ZONE 'epoch' + $time * INTERVAL '1 second')
+ LIMIT $limit
+ };
+ cluck $sql if $DEBUG > 0;
+ #AND created >
+ $dbh->selectall_arrayref( $sql, { Slice => {} } ) or die $dbh->errstr . " $sql";
+}
+
sub _from_customer {
my( $self, $custnum, $priority ) = @_;
}
my $sql = "
- FROM Tickets
- JOIN Queues ON ( Tickets.Queue = Queues.id )
- JOIN Links ON ( Tickets.id = Links.LocalBase )
- JOIN Users ON ( Tickets.Owner = Users.id )
- $join
- WHERE ( ". join(' OR ', map "Status = '$_'", $self->statuses ). " )
- AND Target = 'freeside://freeside/cust_main/$custnum'
- $where
+ FROM Tickets
+ JOIN Queues ON ( Tickets.Queue = Queues.id )
+ JOIN Users ON ( Tickets.Owner = Users.id )
+ JOIN Links ON ( Tickets.id = Links.LocalBase
+ AND Links.Base LIKE '%/ticket/' || Tickets.id )
+ $join
+
+ WHERE ( ". join(' OR ', map "Status = '$_'", $self->statuses ). " )
+ AND Target = 'freeside://freeside/cust_main/$custnum'
+ $where
";
( $sql, @param );
$self->_retrieve_single_value($sql);
}
+sub access_right {
+ warn "WARNING: no access rights available w/ external RT";
+ 0;
+}
+
+sub create_ticket {
+ return 'create_ticket unimplemented w/external RT (write something w/RT::Client::REST?)';
+}
+
1;