# Selima Website Content Management System
# Guestbook.pm: The base guestbook data processor.

#  Copyright (c) 2006-2018 imacat.
#
#  Licensed under the Apache License, Version 2.0 (the "License");
#  you may not use this file except in compliance with the License.
#  You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.

# Author: imacat <imacat@mail.imacat.idv.tw>
# First written: 2006-03-19

package Selima::Processor::Guestbook;
use 5.008;
use strict;
use warnings;
use base qw(Selima::Processor);

use Selima::DataVars qw($DBH :addcol);
use Selima::Format;
use Selima::Guest;
use Selima::GeoIP;
use Selima::Guestbook;
use Selima::RemoHost;
use Selima::ShortCut;

# new: Initialize the processor
sub new : method {
    local ($_, %_);
    my ($self, $class);
    ($class, @_) = @_;
    $_[1] = "guestbook" if @_ < 2;
    $self = $class->SUPER::new(@_);
    $self->{"page_size"} = 2560;
    $self->{"form_cols"} = [qw(name identity location email url message)];
    return $self;
}

# _save_cols: Save the column deposit
sub _save_cols : method {
    local ($_, %_);
    my ($self, $form, $cur);
    $self = $_[0];
    ($form, $cur) = ($self->{"form"}, $self->{"cur"});
    # A form to create a new item
    if ($self->{"type"} eq "new") {
        $self->{"sn"} = $self->_new_sn;
        $self->{"cols"} = new Selima::AddCol($self->{"table"}, ADDCOL_INSERT);
        $self->{"cols"}->addnum("sn", $self->{"sn"});
        $self->{"cols"}->addstr("name", $self->_form("name"));
        $self->{"cols"}->addstr("identity", $self->_form("identity"));
        $self->{"cols"}->addstr("location", $self->_form("location"));
        $self->{"cols"}->addstr("email", $self->_form("email"));
        $self->{"cols"}->addurl("url", $self->_form("url"));
        $self->{"cols"}->addstr("message", $self->_form("message"));
        $self->{"cols"}->addbool("hid", $self->_form("hid"));
        $self->{"cols"}->addipaddr("ip", $ENV{"REMOTE_ADDR"});
        $self->{"cols"}->addstr("host", remote_host);
        $self->{"cols"}->addstr("ct", country_lookup);
        $self->{"cols"}->addnum("pageno", 1);
    
    # A form to edit a current item
    } elsif ($self->{"type"} eq "cur") {
        $self->{"cols"} = new Selima::AddCol($self->{"table"}, ADDCOL_UPDATE);
        $self->{"cols"}->addstr("name", $self->_form("name"), scalar $cur->param("name"));
        $self->{"cols"}->addstr("identity", $self->_form("identity"), scalar $cur->param("identity"));
        $self->{"cols"}->addstr("location", $self->_form("location"), scalar $cur->param("title_2ln"));
        $self->{"cols"}->addstr("email", $self->_form("email"), scalar $cur->param("email"));
        $self->{"cols"}->addurl("url", $self->_form("url"), scalar $cur->param("url"));
        $self->{"cols"}->addstr("message", $self->_form("message"), scalar $cur->param("message"));
        $self->{"cols"}->addbool("hid", $self->_form("hid"), scalar $cur->param("hid"));
    }
    return;
}

# _update_cols: Update the columns
sub _update_cols : method {
    local ($_, %_);
    my $self;
    ($self, @_) = @_;
    $self->SUPER::_update_cols(@_);
    # Update the page number
    if ($self->{"type"} eq "new") {
        my ($sql, $sth, $row);
        $sql = "SELECT created FROM " . $self->{"table"}
            . " WHERE sn=" . $self->{"sn"} . ";\n";
        $sth = $DBH->prepare($sql);
        $sth->execute;
        $row = $sth->fetchrow_hashref;
        $self->{"date"} = $$row{"created"};
    } else {
        $self->{"date"} = $self->{"cur"}->param("created");
    }
    update_pageno $self->{"table"}, $self->{"page_size"},
        $self->{"form_cols"}, $self->{"date"};
    return;
}

# _actlog: Log the activity
sub _actlog : method {
    local ($_, %_);
    my $self;
    $self = $_[0];
    # A form to create a new item
    return gactlog "Create a message on " . fmtdate($self->{"date"})
            . " with s/n " . $self->{"sn"} . "."
        if $self->{"type"} eq "new";
    # A form to edit a current item
    return gactlog "Update the message on " . fmtdate($self->{"date"})
            . " with s/n " . $self->{"sn"} . "."
        if $self->{"type"} eq "cur";
    # A form to delete a current item
    return gactlog "Delete the message on " . fmtdate($self->{"date"})
            . " with s/n " . $self->{"sn"} . "."
        if $self->{"type"} eq "del";
}

# _ret_status: Return the process status
sub _ret_status : method {
    local ($_, %_);
    my $self;
    $self = $_[0];
    return {"msg"=>N_("This message was not modified."),
            "isform"=>0}
        if !$self->_modified;
    # A form to create a new item
    return {"msg"=>N_("This message has been successfully added."),
            "isform"=>0}
        if $self->{"type"} eq "new";
    # A form to edit a current item
    return {"msg"=>N_("This message has been successfully updated."),
            "isform"=>0}
        if $self->{"type"} eq "cur";
    # A form to delete a current item
    return {"msg"=>N_("This message has been successfully deleted."),
            "isform"=>0}
        if $self->{"type"} eq "del";
}

return 1;