-#$Header: /home/cvs/cvsroot/freeside/rt/lib/RT/Attachments.pm,v 1.1 2002-08-12 06:17:07 ivan Exp $
+# BEGIN BPS TAGGED BLOCK {{{
+#
+# COPYRIGHT:
+#
+# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC
+# <sales@bestpractical.com>
+#
+# (Except where explicitly superseded by other copyright notices)
+#
+#
+# LICENSE:
+#
+# This work is made available to you under the terms of Version 2 of
+# the GNU General Public License. A copy of that license should have
+# been provided with this software, but in any event can be snarfed
+# from www.gnu.org.
+#
+# This work is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+# General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with this program; if not, write to the Free Software
+# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
+# 02110-1301 or visit their web page on the internet at
+# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html.
+#
+#
+# CONTRIBUTION SUBMISSION POLICY:
+#
+# (The following paragraph is not intended to limit the rights granted
+# to you to modify and distribute this software under the terms of
+# the GNU General Public License and is only of importance to you if
+# you choose to contribute your changes and enhancements to the
+# community by submitting them to Best Practical Solutions, LLC.)
+#
+# By intentionally submitting any modifications, corrections or
+# derivatives to this work, or any other work intended for use with
+# Request Tracker, to Best Practical Solutions, LLC, you confirm that
+# you are the copyright holder for those contributions and you grant
+# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable,
+# royalty-free, perpetual, license to use, copy, create derivative
+# works based on those contributions, and sublicense and distribute
+# those contributions and any derivatives thereof.
+#
+# END BPS TAGGED BLOCK }}}
=head1 NAME
=head1 METHODS
-=begin testing
-
-ok (require RT::TestHarness);
-ok (require RT::Attachments);
-
-=end testing
=cut
+
package RT::Attachments;
+use strict;
+use warnings;
+
+use base 'RT::SearchBuilder';
+
+use RT::Attachment;
+
+sub Table { 'Attachments'}
-use RT::EasySearch;
-@ISA= qw(RT::EasySearch);
+use RT::Attachment;
-# {{{ sub _Init
sub _Init {
- my $self = shift;
-
- $self->{'table'} = "Attachments";
- $self->{'primary_key'} = "id";
- return ( $self->SUPER::_Init(@_));
+ my $self = shift;
+ $self->{'table'} = "Attachments";
+ $self->{'primary_key'} = "id";
+ $self->OrderBy(
+ FIELD => 'id',
+ ORDER => 'ASC',
+ );
+ return $self->SUPER::_Init( @_ );
}
-# }}}
+sub CleanSlate {
+ my $self = shift;
+ delete $self->{_sql_transaction_alias};
+ return $self->SUPER::CleanSlate( @_ );
+}
+
+
+=head2 TransactionAlias
+
+Returns alias for transactions table with applied join condition.
+Always return the same alias, so if you want to build some complex
+or recursive joining then you have to create new alias youself.
+
+=cut
-# {{{ sub ContentType
+sub TransactionAlias {
+ my $self = shift;
+ return $self->{'_sql_transaction_alias'}
+ if $self->{'_sql_transaction_alias'};
+
+ return $self->{'_sql_transaction_alias'} = $self->Join(
+ ALIAS1 => 'main',
+ FIELD1 => 'TransactionId',
+ TABLE2 => 'Transactions',
+ FIELD2 => 'id',
+ );
+}
=head2 ContentType (VALUE => 'text/plain', ENTRYAGGREGATOR => 'OR', OPERATOR => '=' )
sub ContentType {
- my $self = shift;
- my %args = ( VALUE => 'text/plain',
- OPERATOR => '=',
- ENTRYAGGREGATOR => 'OR',
- @_);
-
- $self->Limit ( FIELD => 'ContentType',
- VALUE => $args{'VALUE'},
- OPERATOR => $args{'OPERATOR'},
- ENTRYAGGREGATOR => $args{'ENTRYAGGREGATOR'});
+ my $self = shift;
+ my %args = (
+ VALUE => 'text/plain',
+ OPERATOR => '=',
+ ENTRYAGGREGATOR => 'OR',
+ @_
+ );
+
+ return $self->Limit ( %args, FIELD => 'ContentType' );
}
-# }}}
-
-# {{{ sub ChildrenOf
=head2 ChildrenOf ID
sub ChildrenOf {
- my $self = shift;
- my $attachment = shift;
- $self->Limit ( FIELD => 'Parent',
- VALUE => $attachment);
+ my $self = shift;
+ my $attachment = shift;
+ return $self->Limit(
+ FIELD => 'Parent',
+ VALUE => $attachment
+ );
+}
+
+=head2 LimitNotEmpty
+
+Limit result set to attachments with not empty content.
+
+=cut
+
+sub LimitNotEmpty {
+ my $self = shift;
+ $self->Limit(
+ ENTRYAGGREGATOR => 'AND',
+ FIELD => 'Content',
+ OPERATOR => 'IS NOT',
+ VALUE => 'NULL',
+ QUOTEVALUE => 0,
+ );
+
+ # http://rt3.fsck.com/Ticket/Display.html?id=12483
+ if ( RT->Config->Get('DatabaseType') ne 'Oracle' ) {
+ $self->Limit(
+ ENTRYAGGREGATOR => 'AND',
+ FIELD => 'Content',
+ OPERATOR => '!=',
+ VALUE => '',
+ );
+ }
+ return;
}
-# }}}
-# {{{ sub NewItem
-sub NewItem {
- my $self = shift;
+=head2 LimitByTicket $ticket_id
+
+Limit result set to attachments of a ticket.
- use RT::Attachment;
- my $item = new RT::Attachment($self->CurrentUser);
- return($item);
+=cut
+
+sub LimitByTicket {
+ my $self = shift;
+ my $tid = shift;
+
+ my $transactions = $self->TransactionAlias;
+ $self->Limit(
+ ENTRYAGGREGATOR => 'AND',
+ ALIAS => $transactions,
+ FIELD => 'ObjectType',
+ VALUE => 'RT::Ticket',
+ );
+
+ my $tickets = $self->Join(
+ ALIAS1 => $transactions,
+ FIELD1 => 'ObjectId',
+ TABLE2 => 'Tickets',
+ FIELD2 => 'id',
+ );
+ $self->Limit(
+ ENTRYAGGREGATOR => 'AND',
+ ALIAS => $tickets,
+ FIELD => 'EffectiveId',
+ VALUE => $tid,
+ );
+ return;
}
-# }}}
- 1;
+sub AddRecord {
+ my $self = shift;
+ my ($record) = @_;
+ return unless $record->TransactionObj->CurrentUserCanSee;
+ return $self->SUPER::AddRecord( $record );
+}
+RT::Base->_ImportOverlays();
+1;