# BEGIN BPS TAGGED BLOCK {{{
-#
+#
# COPYRIGHT:
-#
-# This software is Copyright (c) 1996-2009 Best Practical Solutions, LLC
-# <jesse@bestpractical.com>
-#
+#
+# This software is Copyright (c) 1996-2017 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
# 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 }}}
-
-# Autogenerated by DBIx::SearchBuilder factory (by <jesse@bestpractical.com>)
-# WARNING: THIS FILE IS AUTOGENERATED. ALL CHANGES TO THIS FILE WILL BE LOST.
-#
-# !! DO NOT EDIT THIS FILE !!
#
-
-use strict;
-
+# END BPS TAGGED BLOCK }}}
=head1 NAME
- RT::Attachments -- Class Description
-
+ RT::Attachments - a collection of RT::Attachment objects
+
=head1 SYNOPSIS
- use RT::Attachments
+ use RT::Attachments;
=head1 DESCRIPTION
+This module should never be called directly by client code. it's an internal module which
+should only be accessed through exported APIs in Ticket, Queue and other similar objects.
+
=head1 METHODS
+
+
=cut
+
package RT::Attachments;
+use strict;
+use warnings;
+
+use base 'RT::SearchBuilder';
-use RT::SearchBuilder;
use RT::Attachment;
-use vars qw( @ISA );
-@ISA= qw(RT::SearchBuilder);
+sub Table { 'Attachments'}
-sub _Init {
- my $self = shift;
- $self->{'table'} = 'Attachments';
- $self->{'primary_key'} = 'id';
+use RT::Attachment;
+sub _Init {
+ my $self = shift;
+ $self->{'table'} = "Attachments";
+ $self->{'primary_key'} = "id";
+ $self->OrderBy(
+ FIELD => 'id',
+ ORDER => 'ASC',
+ );
+ return $self->SUPER::_Init( @_ );
+}
- return ( $self->SUPER::_Init(@_) );
+sub CleanSlate {
+ my $self = shift;
+ delete $self->{_sql_transaction_alias};
+ return $self->SUPER::CleanSlate( @_ );
}
-=head2 NewItem
+=head2 TransactionAlias
-Returns an empty new RT::Attachment item
+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 NewItem {
+sub TransactionAlias {
my $self = shift;
- return(RT::Attachment->new($self->CurrentUser));
+ 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',
+ );
}
- eval "require RT::Attachments_Overlay";
- if ($@ && $@ !~ qr{^Can't locate RT/Attachments_Overlay.pm}) {
- die $@;
- };
+=head2 ContentType (VALUE => 'text/plain', ENTRYAGGREGATOR => 'OR', OPERATOR => '=' )
+
+Limit result set to attachments of ContentType 'TYPE'...
- eval "require RT::Attachments_Vendor";
- if ($@ && $@ !~ qr{^Can't locate RT/Attachments_Vendor.pm}) {
- die $@;
- };
+=cut
+
+
+sub ContentType {
+ my $self = shift;
+ my %args = (
+ VALUE => 'text/plain',
+ OPERATOR => '=',
+ ENTRYAGGREGATOR => 'OR',
+ @_
+ );
+
+ return $self->Limit ( %args, FIELD => 'ContentType' );
+}
- eval "require RT::Attachments_Local";
- if ($@ && $@ !~ qr{^Can't locate RT/Attachments_Local.pm}) {
- die $@;
- };
+=head2 ChildrenOf ID
+Limit result set to children of Attachment ID
+=cut
-=head1 SEE ALSO
+sub ChildrenOf {
+ my $self = shift;
+ my $attachment = shift;
+ return $self->Limit(
+ FIELD => 'Parent',
+ VALUE => $attachment
+ );
+}
-This class allows "overlay" methods to be placed
-into the following files _Overlay is for a System overlay by the original author,
-_Vendor is for 3rd-party vendor add-ons, while _Local is for site-local customizations.
+=head2 LimitNotEmpty
-These overlay files can contain new subs or subs to replace existing subs in this module.
+Limit result set to attachments with not empty content.
-Each of these files should begin with the line
+=cut
- no warnings qw(redefine);
+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;
+}
-so that perl does not kick and scream when you redefine a subroutine or variable in your overlay.
+=head2 LimitByTicket $ticket_id
-RT::Attachments_Overlay, RT::Attachments_Vendor, RT::Attachments_Local
+Limit result set to attachments of a ticket.
=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;
+}
+
+sub AddRecord {
+ my $self = shift;
+ my ($record) = @_;
+
+ return unless $record->TransactionObj->CurrentUserCanSee;
+ return $self->SUPER::AddRecord( $record );
+}
+
+RT::Base->_ImportOverlays();
1;