]>
Commit | Line | Data |
---|---|---|
84fb5b46 MKG |
1 | %# BEGIN BPS TAGGED BLOCK {{{ |
2 | %# | |
3 | %# COPYRIGHT: | |
4 | %# | |
403d7b0b | 5 | %# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC |
84fb5b46 MKG |
6 | %# <sales@bestpractical.com> |
7 | %# | |
8 | %# (Except where explicitly superseded by other copyright notices) | |
9 | %# | |
10 | %# | |
11 | %# LICENSE: | |
12 | %# | |
13 | %# This work is made available to you under the terms of Version 2 of | |
14 | %# the GNU General Public License. A copy of that license should have | |
15 | %# been provided with this software, but in any event can be snarfed | |
16 | %# from www.gnu.org. | |
17 | %# | |
18 | %# This work is distributed in the hope that it will be useful, but | |
19 | %# WITHOUT ANY WARRANTY; without even the implied warranty of | |
20 | %# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
21 | %# General Public License for more details. | |
22 | %# | |
23 | %# You should have received a copy of the GNU General Public License | |
24 | %# along with this program; if not, write to the Free Software | |
25 | %# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA | |
26 | %# 02110-1301 or visit their web page on the internet at | |
27 | %# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html. | |
28 | %# | |
29 | %# | |
30 | %# CONTRIBUTION SUBMISSION POLICY: | |
31 | %# | |
32 | %# (The following paragraph is not intended to limit the rights granted | |
33 | %# to you to modify and distribute this software under the terms of | |
34 | %# the GNU General Public License and is only of importance to you if | |
35 | %# you choose to contribute your changes and enhancements to the | |
36 | %# community by submitting them to Best Practical Solutions, LLC.) | |
37 | %# | |
38 | %# By intentionally submitting any modifications, corrections or | |
39 | %# derivatives to this work, or any other work intended for use with | |
40 | %# Request Tracker, to Best Practical Solutions, LLC, you confirm that | |
41 | %# you are the copyright holder for those contributions and you grant | |
42 | %# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, | |
43 | %# royalty-free, perpetual, license to use, copy, create derivative | |
44 | %# works based on those contributions, and sublicense and distribute | |
45 | %# those contributions and any derivatives thereof. | |
46 | %# | |
47 | %# END BPS TAGGED BLOCK }}} | |
48 | <%INIT> | |
49 | my %documents; | |
50 | ||
51 | #A default implementation here loops through all transactions and pulls out all their attachments. | |
52 | # We end up doing an end-run around that to get a bit more performance | |
53 | ||
54 | # We force the cache of ticket transactions to get populated up front. otherwise, the | |
55 | # code that looks at attachments will look at each one in turn. | |
56 | my $attachments = RT::Attachments->new( $session{'CurrentUser'} ); | |
57 | ||
58 | $attachments->Columns( qw( Id Filename Headers Subject Parent ContentEncoding ContentType TransactionId Created)); | |
59 | ||
60 | my $transactions = $attachments->NewAlias('Transactions'); | |
61 | $attachments->Join( ALIAS1 => 'main', | |
62 | FIELD1 => 'TransactionId', | |
63 | ALIAS2 => $transactions, | |
64 | FIELD2 => 'id' ); | |
65 | ||
66 | my $tickets = $attachments->NewAlias('Tickets'); | |
67 | ||
68 | $attachments->Join( ALIAS1 => $transactions, | |
69 | FIELD1 => 'ObjectId', | |
70 | ALIAS2 => $tickets, | |
71 | FIELD2 => 'id' ); | |
72 | ||
73 | $attachments->Limit( ALIAS => $transactions, | |
74 | FIELD => 'ObjectType', | |
75 | VALUE => 'RT::Ticket'); | |
76 | if ($Tickets) { | |
77 | while ($Ticket = $Tickets->Next) { | |
78 | $attachments->Limit( ALIAS => $tickets, | |
79 | FIELD => 'EffectiveId', | |
80 | VALUE => $Ticket->id() ); | |
81 | } | |
82 | } else { | |
83 | $attachments->Limit( ALIAS => $tickets, | |
84 | FIELD => 'EffectiveId', | |
85 | VALUE => $Ticket->id() ); | |
86 | } | |
87 | ||
88 | ||
89 | return ($attachments); | |
90 | </%INIT> | |
91 | <%ARGS> | |
92 | $Ticket => undef | |
93 | $Tickets => undef | |
94 | </%ARGS> | |
95 |