- my $sql="SELECT tickets.*, queues.name, ".
- "position(tickets.status in 'newopenstalledresolvedrejecteddeleted')".
+ my $sql="SELECT Tickets.*, Queues.name, ".
+ "position(Tickets.status in 'newopenstalledresolvedrejecteddeleted')".
warn "$me $sql (@param)" if $DEBUG;
my $sth = $dbh->prepare($sql) or die $dbh->errstr. "preparing $sql";
$sth->execute(@param) or die $sth->errstr. "executing $sql";
warn "$me $sql (@param)" if $DEBUG;
my $sth = $dbh->prepare($sql) or die $dbh->errstr. "preparing $sql";
$sth->execute(@param) or die $sth->errstr. "executing $sql";
unshift @param, $priority;
$join = "JOIN ObjectCustomFieldValues
unshift @param, $priority;
$join = "JOIN ObjectCustomFieldValues
$join
WHERE ( ". join(' OR ', map "status = '$_'", $self->statuses ). " )
AND target = 'freeside://freeside/cust_main/$custnum'
$join
WHERE ( ". join(' OR ', map "status = '$_'", $self->statuses ). " )
AND target = 'freeside://freeside/cust_main/$custnum'
my $sth = $dbh->prepare($sql) or die $dbh->errstr. " preparing $sql";
$sth->execute() or die $sth->errstr. " executing $sql";
my $sth = $dbh->prepare($sql) or die $dbh->errstr. " preparing $sql";
$sth->execute() or die $sth->errstr. " executing $sql";
my $sth = $dbh->prepare($sql) or die $dbh->errstr. " preparing $sql";
$sth->execute($queueid) or die $sth->errstr. " executing $sql";
my $sth = $dbh->prepare($sql) or die $dbh->errstr. " preparing $sql";
$sth->execute($queueid) or die $sth->errstr. " executing $sql";
sub transaction_subject {
my( $self, $transaction_id ) = @_;
sub transaction_subject {
my( $self, $transaction_id ) = @_;
- my $sql = "SELECT subject from transactions JOIN tickets ON objectid=".
- "tickets.id WHERE transactions.id = ". $transaction_id;
+ my $sql = "SELECT subject from Transactions JOIN Tickets ON objectid=".
+ "Tickets.id WHERE transactions.id = ". $transaction_id;
- my $sql = "SELECT status from transactions JOIN tickets ON objectid=".
- "tickets.id WHERE transactions.id = ". $transaction_id;
+ my $sql = "SELECT status from Transactions JOIN Tickets ON objectid=".
+ "Tickets.id WHERE transactions.id = ". $transaction_id;