]>
Commit | Line | Data |
---|---|---|
af59614d MKG |
1 | %# BEGIN BPS TAGGED BLOCK {{{ |
2 | %# | |
3 | %# COPYRIGHT: | |
4 | %# | |
5 | %# This software is Copyright (c) 1996-2013 Best Practical Solutions, LLC | |
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 | % $r->content_type('application/json; charset=utf-8'); | |
49 | <% JSON( \@suggestions ) |n %> | |
50 | % $m->abort; | |
51 | <%ARGS> | |
52 | $return => '' | |
53 | $term => undef | |
54 | $max => 10 | |
55 | $exclude => '' | |
56 | </%ARGS> | |
57 | <%INIT> | |
58 | # Only allow certain return fields | |
59 | $return = 'id' | |
60 | unless $return =~ /^(?:id|Subject)$/; | |
61 | ||
62 | $m->abort unless defined $return | |
63 | and defined $term | |
64 | and length $term; | |
65 | ||
66 | my $CurrentUser = $session{'CurrentUser'}; | |
67 | ||
68 | # Require privileged users | |
69 | $m->abort unless $CurrentUser->Privileged; | |
70 | ||
71 | $term =~ s/(['\\])/\\$1/g; | |
72 | ||
73 | my @excludes; | |
74 | ||
75 | if ( $term =~ /[^\d\s]/ ) { # to search subject, which may contain spaces | |
76 | (my $prev, $term) = $term =~ /(.*?)\s*\b([^\d\s].*)/; | |
77 | @excludes = split /\s+/, $prev if $prev; | |
78 | } | |
79 | else { | |
80 | my @terms = split /\s+/, $term; | |
81 | $term = pop @terms; | |
82 | @excludes = @terms; | |
83 | } | |
84 | push @excludes, split /\s+/, $exclude if $exclude; | |
85 | ||
86 | my %fields = %{ RT->Config->Get('TicketAutocompleteFields') | |
87 | || { id => 'STARTSWITH', Subject => 'LIKE' } }; | |
88 | ||
89 | my $tickets = RT::Tickets->new( $CurrentUser ); | |
90 | ||
91 | my @clauses; | |
92 | while (my ($name, $op) = each %fields) { | |
93 | $op = 'STARTSWITH' | |
94 | unless $op =~ /^(?:LIKE|(?:START|END)SWITH|=|!=)$/i; | |
95 | push @clauses, qq{$name $op '$term'}; | |
96 | } | |
97 | my $sql = join ' OR ', @clauses; | |
98 | if ( @excludes ) { # exclude ids already these | |
99 | $sql = join ' AND ', "($sql)", map { qq{id != '$_'} } @excludes; | |
100 | } | |
101 | ||
102 | $tickets->FromSQL($sql); | |
103 | $tickets->RowsPerPage( $max ); | |
104 | ||
105 | my @suggestions; | |
106 | ||
107 | while ( my $ticket = $tickets->Next ) { | |
108 | my $formatted = loc("#[_1]: [_2]", $ticket->Id, $ticket->Subject); | |
109 | push @suggestions, { label => $formatted, value => $ticket->$return }; | |
110 | } | |
111 | ||
112 | </%INIT> |