#!/usr/bin/perl -w # -- # otrs.RebuildEscalationIndex.pl - the global search indexer handle # Copyright (C) 2001-2009 OTRS AG, http://otrs.org/ # -- # $Id: otrs.RebuildEscalationIndex.pl,v 1.5 2009/04/23 13:47:27 mh Exp $ # -- # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU AFFERO General Public License as published by # the Free Software Foundation; either version 3 of the License, or # any later version. # # This program 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 Affero General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA # or see http://www.gnu.org/licenses/agpl.txt. # -- use strict; use warnings; # use ../ as lib location use File::Basename; use FindBin qw($RealBin); use lib dirname($RealBin); use lib dirname($RealBin) . "/Kernel/cpan-lib"; use vars qw($VERSION); $VERSION = qw($Revision: 1.5 $) [1]; use Getopt::Std; use Kernel::Config; use Kernel::System::Encode; use Kernel::System::Log; use Kernel::System::Time; use Kernel::System::DB; use Kernel::System::Main; use Kernel::System::Ticket; # get options my %Opts = (); getopt( 'h', \%Opts ); if ( $Opts{h} ) { print "otrs.RebuildEscalationIndex.pl - rebuild escalation index\n"; print "Copyright (C) 2001-2009 OTRS AG, http://otrs.org/\n"; print "usage: otrs.RebuildEscalationIndex.pl\n"; exit 1; } # create common objects my %CommonObject = (); $CommonObject{ConfigObject} = Kernel::Config->new(); $CommonObject{EncodeObject} = Kernel::System::Encode->new(%CommonObject); $CommonObject{LogObject} = Kernel::System::Log->new( LogPrefix => 'OTRS-RebuildEscalationIndex', %CommonObject, ); $CommonObject{MainObject} = Kernel::System::Main->new(%CommonObject); $CommonObject{TimeObject} = Kernel::System::Time->new(%CommonObject); # create needed objects $CommonObject{DBObject} = Kernel::System::DB->new(%CommonObject); $CommonObject{TicketObject} = Kernel::System::Ticket->new(%CommonObject); # get all tickets my @TicketIDs = $CommonObject{TicketObject}->TicketSearch( # result (required) Result => 'ARRAY', # result limit Limit => 100_000_000, UserID => 1, Permission => 'ro', ); my $Count = 0; for my $TicketID (@TicketIDs) { $Count++; $CommonObject{TicketObject}->TicketEscalationIndexBuild( TicketID => $TicketID, UserID => 1, ); if ( ( $Count / 2000 ) == int( $Count / 2000 ) ) { my $Percent = int( $Count / ( $#TicketIDs / 100 ) ); print "NOTICE: $Count of $#TicketIDs processed ($Percent% done).\n"; } } print "NOTICE: Index creation done.\n"; exit 0;