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 );
}
-sub href_new_ticket {
+sub href_params_new_ticket {
my( $self, $custnum_or_cust_main, $requestors ) = @_;
my( $custnum, $cust_main );
$custnum = $custnum_or_cust_main;
$cust_main = qsearchs('cust_main', { 'custnum' => $custnum } );
}
- my $queueid = $cust_main->agent->ticketing_queueid || $default_queueid;
-
- $self->baseurl.
- 'Ticket/Create.html?'.
- "Queue=$queueid".
- "&new-MemberOf=freeside://freeside/cust_main/$custnum".
- ( $requestors ? '&Requestors='. uri_escape($requestors) : '' )
- ;
+
+ my %param = (
+ 'Queue' => ($cust_main->agent->ticketing_queueid || $default_queueid),
+ 'new-MemberOf'=> "freeside://freeside/cust_main/$custnum",
+ 'Requestors' => $requestors,
+ );
+
+ ( $self->baseurl.'Ticket/Create.html', %param );
+}
+
+sub href_new_ticket {
+ my $self = shift;
+
+ my( $base, %param ) = $self->href_params_new_ticket(@_);
+
+ my $uri = new URI $base;
+ $uri->query_form(%param);
+ $uri;
+
}
sub href_ticket {
$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;