X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2Flib%2FRT%2FAttachments.pm;h=6b935da6eef596d7ca8f443d9208dbe1d9d0a0a8;hp=93c9445f6afa94a98dec974e9af0678d7f44be40;hb=187086c479a09629b7d180eec513fb7657f4e291;hpb=fc6209f398899f0211cfcedeb81a3cd65e04a941

diff --git a/rt/lib/RT/Attachments.pm b/rt/lib/RT/Attachments.pm
index 93c9445f6..6b935da6e 100755
--- a/rt/lib/RT/Attachments.pm
+++ b/rt/lib/RT/Attachments.pm
@@ -2,7 +2,7 @@
 #
 # COPYRIGHT:
 #
-# This software is Copyright (c) 1996-2011 Best Practical Solutions, LLC
+# This software is Copyright (c) 1996-2018 Best Practical Solutions, LLC
 #                                          <sales@bestpractical.com>
 #
 # (Except where explicitly superseded by other copyright notices)
@@ -46,95 +46,183 @@
 #
 # 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;
-
-
 =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
 
-        eval "require RT::Attachments_Local";
-        if ($@ && $@ !~ qr{^Can't locate RT/Attachments_Local.pm}) {
-            die $@;
-        };
 
+sub ContentType  {
+    my $self = shift;
+    my %args = (
+        VALUE           => 'text/plain',
+        OPERATOR        => '=',
+        ENTRYAGGREGATOR => 'OR',
+        @_
+    );
+
+    return $self->Limit ( %args, FIELD => 'ContentType' );
+}
 
+=head2 ChildrenOf ID
 
+Limit result set to children of Attachment ID
 
-=head1 SEE ALSO
+=cut
 
-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.  
 
-These overlay files can contain new subs or subs to replace existing subs in this module.
+sub ChildrenOf  {
+    my $self = shift;
+    my $attachment = shift;
+    return $self->Limit(
+        FIELD => 'Parent',
+        VALUE => $attachment
+    );
+}
+
+=head2 LimitNotEmpty
 
-Each of these files should begin with the line 
+Limit result set to attachments with not empty content.
+
+=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;