137 lines
3.6 KiB
Perl
137 lines
3.6 KiB
Perl
# --
|
|
# Copyright (C) 2001-2019 OTRS AG, https://otrs.com/
|
|
# --
|
|
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
|
|
# the enclosed file COPYING for license information (GPL). If you
|
|
# did not receive this file, see https://www.gnu.org/licenses/gpl-3.0.txt.
|
|
# --
|
|
|
|
package Kernel::System::SLA::PreferencesDB;
|
|
|
|
use strict;
|
|
use warnings;
|
|
|
|
our @ObjectDependencies = (
|
|
'Kernel::Config',
|
|
'Kernel::System::Cache',
|
|
'Kernel::System::DB',
|
|
'Kernel::System::Log',
|
|
);
|
|
|
|
sub new {
|
|
my ( $Type, %Param ) = @_;
|
|
|
|
# allocate new hash for object
|
|
my $Self = {};
|
|
bless( $Self, $Type );
|
|
|
|
$Self->{CacheType} = 'SLAPreferencesDB';
|
|
$Self->{CacheTTL} = 60 * 60 * 24 * 20;
|
|
|
|
# preferences table data
|
|
$Self->{PreferencesTable} = 'sla_preferences';
|
|
$Self->{PreferencesTableKey} = 'preferences_key';
|
|
$Self->{PreferencesTableValue} = 'preferences_value';
|
|
$Self->{PreferencesTableSLAID} = 'sla_id';
|
|
|
|
# create cache prefix
|
|
$Self->{CachePrefix} = 'SLAPreferencesDB'
|
|
. $Self->{PreferencesTable}
|
|
. $Self->{PreferencesTableKey}
|
|
. $Self->{PreferencesTableValue}
|
|
. $Self->{PreferencesTableSLAID};
|
|
|
|
return $Self;
|
|
}
|
|
|
|
sub SLAPreferencesSet {
|
|
my ( $Self, %Param ) = @_;
|
|
|
|
# check needed stuff
|
|
for (qw(SLAID Key Value)) {
|
|
if ( !defined $Param{$_} ) {
|
|
$Kernel::OM->Get('Kernel::System::Log')->Log(
|
|
Priority => 'error',
|
|
Message => "Need $_!"
|
|
);
|
|
return;
|
|
}
|
|
}
|
|
|
|
my $DBObject = $Kernel::OM->Get('Kernel::System::DB');
|
|
|
|
# delete old data
|
|
return if !$DBObject->Do(
|
|
SQL => "DELETE FROM $Self->{PreferencesTable} WHERE "
|
|
. "$Self->{PreferencesTableSLAID} = ? AND $Self->{PreferencesTableKey} = ?",
|
|
Bind => [ \$Param{SLAID}, \$Param{Key} ],
|
|
);
|
|
|
|
# insert new data
|
|
return if !$DBObject->Do(
|
|
SQL => "INSERT INTO $Self->{PreferencesTable} ($Self->{PreferencesTableSLAID}, "
|
|
. " $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue}) "
|
|
. " VALUES (?, ?, ?)",
|
|
Bind => [ \$Param{SLAID}, \$Param{Key}, \$Param{Value} ],
|
|
);
|
|
|
|
# delete cache
|
|
$Kernel::OM->Get('Kernel::System::Cache')->Delete(
|
|
Type => $Self->{CacheType},
|
|
Key => $Self->{CachePrefix} . $Param{SLAID},
|
|
);
|
|
|
|
return 1;
|
|
}
|
|
|
|
sub SLAPreferencesGet {
|
|
my ( $Self, %Param ) = @_;
|
|
|
|
# check needed stuff
|
|
for (qw(SLAID)) {
|
|
if ( !$Param{$_} ) {
|
|
$Kernel::OM->Get('Kernel::System::Log')->Log(
|
|
Priority => 'error',
|
|
Message => "Need $_!"
|
|
);
|
|
return;
|
|
}
|
|
}
|
|
|
|
# check if service preferences are available
|
|
return if !$Kernel::OM->Get('Kernel::Config')->Get('SLAPreferences');
|
|
|
|
# read cache
|
|
my $Cache = $Kernel::OM->Get('Kernel::System::Cache')->Get(
|
|
Type => $Self->{CacheType},
|
|
Key => $Self->{CachePrefix} . $Param{SLAID},
|
|
);
|
|
return %{$Cache} if $Cache;
|
|
|
|
my $DBObject = $Kernel::OM->Get('Kernel::System::DB');
|
|
|
|
# get preferences
|
|
return if !$DBObject->Prepare(
|
|
SQL => "SELECT $Self->{PreferencesTableKey}, $Self->{PreferencesTableValue} "
|
|
. " FROM $Self->{PreferencesTable} WHERE $Self->{PreferencesTableSLAID} = ?",
|
|
Bind => [ \$Param{SLAID} ],
|
|
);
|
|
|
|
my %Data;
|
|
while ( my @Row = $DBObject->FetchrowArray() ) {
|
|
$Data{ $Row[0] } = $Row[1];
|
|
}
|
|
|
|
# set cache
|
|
$Kernel::OM->Get('Kernel::System::Cache')->Set(
|
|
Type => $Self->{CacheType},
|
|
TTL => $Self->{CacheTTL},
|
|
Key => $Self->{CachePrefix} . $Param{SLAID},
|
|
Value => \%Data,
|
|
);
|
|
|
|
return %Data;
|
|
}
|
|
|
|
1;
|