package RPS::DB::Item::PortalEmailCustomText;

use strict;
use warnings;

use lib '/app/tools/common/lib';

use Common::DB::Item;
use Common::RSApp;

use base 'Common::DB::Item';

use constant kTable => 'client';
use constant kDB    => Common::DB::Item::kCommonDB();

sub GetCustomInviteText {
    my $self = shift;

    my $sql = "SELECT custom_invite_text FROM ". kTable . " WHERE client_id = " . Common::RSApp::GetClientID();

    my $result = $self->SUPER::GetAll($sql);

    return $result->hasNext() ? $result->next->custom_invite_text : "";
}

sub GetCustomNotificationText {
    my $self = shift;

    my $sql = "SELECT custom_notification_text FROM ". kTable . " WHERE client_id = " . Common::RSApp::GetClientID();

    my $result = $self->SUPER::GetAll($sql);

    return $result->hasNext() ? $result->next->custom_notification_text : "";
}
1;