Attachment #107603 for bug #22343

View | Details | Raw Unified | Return to bug 22343
Collapse All | Expand All




#!/usr/bin/perl

# Copyright 2020 Theke Solutions
#
# This file is part of Koha.
#
# Koha is free software; you can redistribute it and/or modify it
# under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 3 of the License, or
# (at your option) any later version.
#
# Koha 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 General Public License
# along with Koha; if not, see <http://www.gnu.org/licenses>.

use Modern::Perl;

use CGI qw ( -utf8 );
use Try::Tiny;

use C4::Auth qw(get_template_and_user);
use C4::Output qw(output_html_with_http_headers);

use Koha::Libraries;
use Koha::SMTP::Servers;

my $input = CGI->new;
my $op    = $input->param('op') || 'list';

my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
    {   template_name   => "admin/smtp_servers.tt",
        query           => $input,
        type            => "intranet",
        authnotrequired => 0,
        flagsrequired   => { parameters => 1 },
        debug           => 1,
    }
);

my @messages;

if ( $op eq 'add' ) {

    my $library_id = $input->param('library_id');
    $library_id = undef
        if defined $library_id and $library_id eq '*';

    my $name       = $input->param('smtp_name');
    my $host       = $input->param('smtp_host');
    my $port       = $input->param('smtp_port') || 25;
    my $timeout    = $input->param('smtp_timeout') || 120;
    my $ssl        = (scalar $input->param('smtp_ssl')) ? 1 : 0;
    my $user_name  = $input->param('smtp_user_name') || undef;
    my $password   = $input->param('smtp_password') || undef;

    try {
        Koha::SMTP::Server->new(
            {
                library_id => $library_id,
                name       => $name,
                host       => $host,
                port       => $port,
                timeout    => $timeout,
                ssl        => $ssl,
                user_name  => $user_name,
                password   => $password
            }
        )->store;

        push @messages, { type => 'message', code => 'success_on_insert' };
    }
    catch {
        warn "Something went wrong $_";
        if ( blessed $_ and $_->isa('Koha::Exceptions::Object::DuplicateID') ) {
            push @messages,
              {
                type   => 'alert',
                code   => 'error_on_insert',
                reason => 'duplicate_id'
              };
        }
    };

    # list servers after adding
    $op = 'list';
}
elsif ( $op eq 'delete' ) {
    my $smtp_server_id = $input->param('smtp_server_id');
    my $smtp_server;

    $smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
        unless !$smtp_server_id;

    if ( $smtp_server ) {
        try {
            my $name = $smtp_server->name;
            $smtp_server->delete;
            push @messages,
              {
                type => 'message',
                code => 'success_on_delete'
              };
        }
        catch {
            push @messages,
              {
                type   => 'alert',
                code   => 'error_on_delete'
              };
        };
    }
    else {
        push @messages,
            {
                type   => 'alert',
                code   => 'error_on_delete',
                reason => 'invalid_id'
            };
    }

    # list servers after delete
    $op = 'list';
}
elsif ( $op eq 'edit_form' ) {
    my $smtp_server_id = $input->param('smtp_server_id');
    my $smtp_server;

    $smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
        unless !$smtp_server_id;

    if ( $smtp_server ) {
        $template->param(
            smtp_server => $smtp_server
        );
    }
    else {
        push @messages,
            {
                type   => 'alert',
                code   => 'error_on_edit',
                reason => 'invalid_id'
            };
    }
}
elsif ( $op eq 'edit_save' ) {

    my $smtp_server_id = $input->param('smtp_server_id');
    my $smtp_server;

    $smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
        unless !$smtp_server_id;

    if ( $smtp_server ) {

        my $name       = $input->param('smtp_name');
        my $host       = $input->param('smtp_host');
        my $port       = $input->param('smtp_port') || 25;
        my $timeout    = $input->param('smtp_timeout') || 120;
        my $ssl        = (scalar $input->param('smtp_ssl')) ? 1 : 0;
        my $user_name  = $input->param('smtp_user_name') || undef;
        my $password   = $input->param('smtp_password') || undef;

        try {
            $smtp_server->set(
                {
                    name      => $name,
                    host      => $host,
                    port      => $port,
                    timeout   => $timeout,
                    ssl       => $ssl,
                    user_name => $user_name,
                    password  => $password

                }
            )->store;

            push @messages,
            {
                type => 'message',
                code => 'success_on_update'
            };
        }
        catch {
            push @messages,
            {
                type   => 'alert',
                code   => 'error_on_update'
            };
        };

        # list servers after adding
        $op = 'list';
    }
    else {
        push @messages,
            {
                type   => 'alert',
                code   => 'error_on_update',
                reason => 'invalid_id'
            };
    }
}

if ( $op eq 'list' ) {
    my $smtp_servers = Koha::SMTP::Servers->search;
    $template->param(
        servers_count  => $smtp_servers->count,
        default_config => $smtp_servers->default_setting
    );
}

my @already_set_library_ids = Koha::SMTP::Servers->search(
    {
        library_id => { '!=' => undef }
    }
)->get_column('library_id');

my $libraries = Koha::Libraries->search(
    {
        'me.branchcode' => { -not_in => \@already_set_library_ids }
    }
);

my $default = Koha::SMTP::Servers->search({ library_id => undef })->count;

$template->param(
    op              => $op,
    default_set     => ( $default ) ? 1 : 0,
    unset_libraries => $libraries,
    messages        => \@messages,
);

output_html_with_http_headers $input, $cookie, $template->output;

Lines 208-213 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/admin-home.tt (+4 lines)
208	<dt><a href="/cgi-bin/koha/admin/z3950servers.pl">Z39.50/SRU servers</a></dt>	208	<dt><a href="/cgi-bin/koha/admin/z3950servers.pl">Z39.50/SRU servers</a></dt>
209	<dd>Define which external servers to query for MARC data.</dd>	209	<dd>Define which external servers to query for MARC data.</dd>
210	[% END %]	210	[% END %]
		211	[% IF ( CAN_user_parameters ) %]
		212	<dt><a href="/cgi-bin/koha/admin/smtp_servers.pl">SMTP servers</a></dt>
		213	<dd>Define which SMTP servers to use.</dd>
		214	[% END %]
211	[% IF ( CAN_user_parameters_manage_didyoumean ) %]	215	[% IF ( CAN_user_parameters_manage_didyoumean ) %]
212	<dt><a href="/cgi-bin/koha/admin/didyoumean.pl">Did you mean?</a></dt>	216	<dt><a href="/cgi-bin/koha/admin/didyoumean.pl">Did you mean?</a></dt>
213	<dd>Choose which plugins to use to suggest searches to patrons and staff.</dd>	217	<dd>Choose which plugins to use to suggest searches to patrons and staff.</dd>




[% USE raw %]
[% USE Asset %]
[% SET footerjs = 1 %]
[% USE TablesSettings %]
[% INCLUDE 'doc-head-open.inc' %]
<title>Koha &rsaquo; Administration &rsaquo; SMTP servers
[% IF op == 'add_form' %]
    &rsaquo;[% IF library %]Modify SMTP server[% ELSE %]New SMTP server[% END %]
[% ELSIF op == 'delete_confirm' %]
    &rsaquo; Confirm deletion of SMTP server '[% server.name | html %]'
[% END %]
</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>

<body id="admin_smtp_servers" class="admin">
[% INCLUDE 'header.inc' %]
[% INCLUDE 'prefs-admin-search.inc' %]

<div id="breadcrumbs">
    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
    <a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo;
    <a href="/cgi-bin/koha/admin/smtp_servers.pl">SMTP servers</a>
[% IF op == 'add_form' %]
 &rsaquo; <span> New</span>
[% ELSIF op == 'edit_form' %]
 &rsaquo; <span> Edit</span>
[% END %]
</div>

<div class="main container-fluid">
    <div class="row">
        <div class="col-sm-10 col-sm-push-2">
            <main>

[% FOREACH m IN messages %]
    <div class="dialog [% message.type | html %]">
        [% SWITCH m.code %]
        [% CASE 'error_on_update' %]
            An error occurred when updating this library. Perhaps it already exists.
        [% CASE 'error_on_insert' %]
            An error occurred when adding this library. The branchcode might already exist.
        [% CASE 'error_on_delete' %]
            An error occurred when deleting this library. Check the logs.
        [% CASE 'success_on_update' %]
            Library updated successfully.
        [% CASE 'success_on_insert' %]
            Library added successfully.
        [% CASE 'success_on_delete' %]
            Library deleted successfully.
        [% CASE 'cannot_delete_library' %]
            This library cannot be deleted. Patrons or items are still using it
            [% IF m.data.patrons_count and m.data.items_count %]
                ([% m.data.patrons_count | html %] patrons and [% m.data.items_count | html %] items).
            [% ELSIF m.data.patrons_count %]
                ([% m.data.patrons_count | html %] patrons).
            [% ELSIF m.data.items_count %]
                ([% m.data.items_count | html %] items).
            [% END %]
        [% CASE 'error_on_update_category' %]
            An error occurred when updating this library category. Perhaps it already exists.
        [% CASE 'error_on_insert_category' %]
            An error occurred when adding this library category. The categorycode might already exist.
        [% CASE 'error_on_delete_category' %]
            An error occurred when deleting this library category. Check the logs.
        [% CASE 'success_on_update_category' %]
            Library category updated successfully.
        [% CASE 'success_on_insert_category' %]
            Library category added successfully.
        [% CASE 'success_on_delete_category' %]
            Library category deleted successfully.
        [% CASE 'cannot_delete_category' %]
            This library category cannot be deleted. [% m.data.libraries_count | html %] libraries are still using it.
        [% CASE %]
            [% m.code | html %]
        [% END %]
    </div>
[% END %]

[% IF op == 'add_form' %]
    <h3>New SMTP server</h3>
    <form action="/cgi-bin/koha/admin/smtp_servers.pl" id="add" name="add" class="validated" method="post">
        <input type="hidden" name="op" value="add" />
        <fieldset class="rows">
            <ol>
                <li>
                    <label for="library_id" class="required">Library: </label>
                    <select name="library_id" id="library_id">
                    [%- UNLESS default_set -%]
                        <option value="*">All libraries</option>
                    [%- END -%]
                    [%- FOREACH library IN unset_libraries -%]
                        <option value="[% library.branchcode | html %]">[% library.branchname | html %]</option>
                    [%- END -%]
                    </select>
                    <span class="required">Required</span>
                </li>
                </select>
                <li>
                    <label for="smtp_name" class="required">Name: </label>
                    <input type="text" name="smtp_name" id="smtp_name" size="60" class="required" required="required" />
                    <span class="required">Required</span>
                </li>
            </ol>
        </fieldset>

        <fieldset class="rows">
            <ol>
                <li>
                    <label for="smtp_host">Host: </label>
                    <input type="text" name="smtp_host" id="smtp_host" size="60" class="required"/>
                    <span class="required">Required</span>
                </li>
                <li>
                    <label for="smtp_port">Port: </label>
                    <input type="number" step="1" value="25" name="smtp_port" id="smtp_port" size="20" class="required"/>
                    <span class="required">Required</span>
                </li>
                <li>
                    <label for="smtp_timeout">Timeout (seconds): </label>
                    <input type="number" step="1" value="120" name="smtp_timeout" id="smtp_timeout" size="20" />
                </li>
                <li>
                    <label for="smtp_ssl">SSL: </label>
                    <select name="smtp_ssl" id="smtp_ssl">
                        <option value="1" selected="selected">Yes</option>
                        <option value="0">No</option>
                    </select>
                </li>
                <li>
                    <label for="smtp_user_name">User name: </label>
                    <input type="text" name="smtp_user_name" id="smtp_user_name" size="60" />
                </li>
                <li>
                    <label for="smtp_password">Password: </label>
                    <input type="password" name="smtp_password" id="smtp_password" size="60" />
                </li>
            </ol>
        </fieldset>
        <fieldset class="action">
            <input type="submit" value="Submit" />
            <a class="cancel" href="/cgi-bin/koha/admin/smtp_servers.pl">Cancel</a>
        </fieldset>
    </form>
[% END %]

[% IF op == 'edit_form' %]
    <h3>Edit SMTP server</h3>
    <form action="/cgi-bin/koha/admin/smtp_servers.pl" id="edit_save" name="edit_save" class="validated" method="post">
        <input type="hidden" name="op" value="edit_save" />
        <input type="hidden" name="smtp_server_id" value="[%- smtp_server.id | html -%]" />
        <fieldset class="rows">
            <ol>
                <li>
                    <label for="library_id">Library: </label>
                    [% IF smtp_server.library %]
                        <span name="library_id" id="library_id">[%- smtp_server.library.branchname | html -%]</span>
                    [%- ELSE -%]
                        <span name="library_id" id="library_id">All libraries</span>
                    [%- END -%]
                </li>
                </select>
                <li>
                    <label for="smtp_name" class="required">Name: </label>
                    <input type="text" name="smtp_name" id="smtp_name" size="60" class="required" required="required" value="[%- smtp_server.name | html -%]"/>
                    <span class="required">Required</span>
                </li>
            </ol>
        </fieldset>

        <fieldset class="rows">
            <ol>
                <li>
                    <label for="smtp_host">Host: </label>
                    <input type="text" name="smtp_host" id="smtp_host" size="60" class="required" value="[%- smtp_server.host | html -%]"/>
                    <span class="required">Required</span>
                </li>
                <li>
                    <label for="smtp_port">Port: </label>
                    <input type="number" step="1" value="25" name="smtp_port" id="smtp_port" size="20" class="required" value="[%- smtp_server.port | html -%]"/>
                    <span class="required">Required</span>
                </li>
                <li>
                    <label for="smtp_timeout">Timeout (seconds): </label>
                    <input type="number" step="1" value="120" name="smtp_timeout" id="smtp_timeout" size="20" value="[%- smtp_server.timeout | html -%]"/>
                </li>
                <li>
                    <label for="smtp_ssl">SSL: </label>
                    <select name="smtp_ssl" id="smtp_ssl">
                    [%- IF smtp_server.ssl -%]
                        <option value="1" selected="selected">Yes</option>
                        <option value="0">No</option>
                    [%- ELSE -%]
                        <option value="1">Yes</option>
                        <option value="0" selected="selected">No</option>
                    [%- END -%]
                    </select>
                </li>
                <li>
                    <label for="smtp_user_name">User name: </label>
                    <input type="text" name="smtp_user_name" id="smtp_user_name" size="60"  value="[%- smtp_server.user_name | html -%]"/>
                </li>
                <li>
                    <label for="smtp_password">Password: </label>
                    <input type="password" name="smtp_password" id="smtp_password" size="60"  value="[%- smtp_server.password | html -%]"/>
                </li>
            </ol>
        </fieldset>
        <fieldset class="action">
            <input type="submit" value="Submit" />
            <a class="cancel" href="/cgi-bin/koha/admin/smtp_servers.pl">Cancel</a>
        </fieldset>
    </form>
[% END %]

[% IF op == 'list' %]

    [%- IF unset_libraries.count > 0 -%]
    <div id="toolbar" class="btn-toolbar">
        <a class="btn btn-default" id="new_smtp_server" href="/cgi-bin/koha/admin/smtp_servers.pl?op=add_form"><i class="fa fa-plus"></i> New SMTP server</a>
    </div>
    [%- END -%]

    <h3>SMTP servers</h3>

    [% IF servers_count > 0 %]
        <table id="smtp_servers">
            <thead>
                <tr>
                    <th>Library</th>
                    <th>Name</th>
                    <th>Host</th>
                    <th>Port</th>
                    <th>Timeout (secs)</th>
                    <th>SSL</th>
                    <th>Authenticated</th>
                    <th data-class-name="actions">Actions</th>
                </tr>
            </thead>
        </table>
    [% ELSE %]
        <div class="dialog message">No user-defined SMTP servers. Using the default configuration:
            <ul>
                <li><strong>Host</strong>: [%- default_config.host | html -%]</li>
                <li><strong>Port</strong>: [%- default_config.port | html -%]</li>
                <li><strong>Timeout (secs)</strong>: [%- default_config.timeout | html -%]</li>
                <li><strong>SSL</strong>: [%- IF default_config.ssl -%]Yes[%- ELSE -%]No[%- END -%]</li>
            </ul>
            </pre>
        </div>
    [% END %]
[% END %]

            <div id="delete_confirm_modal" class="modal" tabindex="-1" role="dialog" aria-labelledby="delete_confirm_modal_label" aria-hidden="true">
                <div class="modal-dialog">
                    <div class="modal-content">
                        <div class="modal-header">
                            <button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button>
                            <h3 id="delete_confirm_modal_label">Delete server</h3>
                        </div>
                        <div class="modal-body">
                            <div id="delete_confirm_dialog"></div>
                        </div>
                        <div class="modal-footer">
                            <a href="#" class="btn btn-default" id="delete_confirm_modal_button" role="button" data-toggle="modal">Delete</a>
                            <button class="btn btn-default" data-dismiss="modal" aria-hidden="true">Close</button>
                        </div>
                    </div> <!-- /.modal-content -->
                </div> <!-- /.modal-dialog -->
            </div> <!-- #delete_confirm_modal -->

            </main>
        </div> <!-- /.col-sm-10.col-sm-push-2 -->

        <div class="col-sm-2 col-sm-pull-10">
            <aside>
                [% INCLUDE 'admin-menu.inc' %]
            </aside>
        </div> <!-- /.col-sm-2.col-sm-pull-10 -->
     </div> <!-- /.row -->


[% MACRO jsinclude BLOCK %]
    [% Asset.js("js/admin-menu.js") | $raw %]
    [% INCLUDE 'datatables.inc' %]
    [% INCLUDE 'columns_settings.inc' %]
    [% Asset.js("lib/tiny_mce/tinymce.min.js") | $raw %]
    [% INCLUDE 'str/tinymce_i18n.inc' %]
    <script>
        $(document).ready(function() {

            var smtp_servers_url = '/api/v1/config/smtp_servers';
            var smtp_servers = $("#smtp_servers").api({
                "ajax": {
                    "url": smtp_servers_url
                },
                "embed": [
                    "library"
                ],
                'emptyTable': '<div class="dialog message">'+_("There are no SMTP servers defined.")+'</div>',
                "columnDefs": [ {
                    "targets": [0,1,2],
                    "render": function (data, type, row, meta) {
                        if ( type == 'display' ) {
                            if ( data != null ) {
                                return data.escapeHtml();
                            }
                            else {
                                return "Default";
                            }
                        }
                        return data;
                    }
                } ],
                "columns": [
                    {
                        "data": "library.name",
                        "searchable": true,
                        "orderable": true
                    },
                    {
                        "data": "name",
                        "searchable": true,
                        "orderable": true
                    },
                    {
                        "data": "host",
                        "searchable": true,
                        "orderable": true
                    },
                    {
                        "data": "port",
                        "searchable": true,
                        "orderable": false
                    },
                    {
                        "data": "timeout",
                        "searchable": true,
                        "orderable": false
                    },
                    {
                        "data": "ssl",
                        "render": function (data, type, row, meta) {
                            if (data) {
                                return _("Yes");
                            }
                            else {
                                return _("No");
                            }
                        },
                        "searchable": false,
                        "orderable": false
                    },
                    {
                        "data": function( row, type, val, meta ) {
                            if ( row.user_name != null ) {
                                return _("Yes");
                            }
                            else {
                                return _("No");
                            }
                        },
                        "searchable": false,
                        "orderable": false
                    },
                    {
                        "data": function( row, type, val, meta ) {
                            var result = '<a class="btn btn-default btn-xs" role="button" href="/cgi-bin/koha/admin/smtp_servers.pl?op=edit_form&amp;smtp_server_id='+ encodeURIComponent(row.smtp_server_id) +'"><i class="fa fa-pencil" aria-hidden="true"></i> '+_("Edit")+'</a>'+"\n";
                            result += '<a class="btn btn-default btn-xs delete_server" role="button" href="#" data-toggle="modal" data-target="#delete_confirm_modal" data-smtp-server-id="'+ encodeURIComponent(row.smtp_server_id) +'" data-smtp-server-name="'+ encodeURIComponent(row.name) +'"><i class="fa fa-trash" aria-hidden="true"></i>'+_("Delete")+'</a>';
                            return result;
                        },
                        "searchable": false,
                        "orderable": false
                    }
                ]
            });

            $('#smtp_servers').on( "click", '.delete_server', function () {
                var smtp_server_id   = $(this).data('smtp-server-id');
                var smtp_server_name = $(this).data('smtp-server-name');

                $("#delete_confirm_dialog").html(
                    _("You are about to delete the \"%s\" SMTP server.").format(smtp_server_name)
                );
                $("#delete_confirm_modal_button").attr("href", "/cgi-bin/koha/admin/smtp_servers.pl?op=delete&amp;smtp_server_id=" + encodeURIComponent(smtp_server_id));
            });
        });
    </script>
[% END %]

[% INCLUDE 'intranet-bottom.inc' %]

Return to bug 22343

Line 0 Link Here

(-)a/admin/smtp_servers.pl (+237 lines)
		1	#!/usr/bin/perl
		2
		3	# Copyright 2020 Theke Solutions
		4	#
		5	# This file is part of Koha.
		6	#
		7	# Koha is free software; you can redistribute it and/or modify it
		8	# under the terms of the GNU General Public License as published by
		9	# the Free Software Foundation; either version 3 of the License, or
		10	# (at your option) any later version.
		11	#
		12	# Koha is distributed in the hope that it will be useful, but
		13	# WITHOUT ANY WARRANTY; without even the implied warranty of
		14	# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
		15	# GNU General Public License for more details.
		16	#
		17	# You should have received a copy of the GNU General Public License
		18	# along with Koha; if not, see <http://www.gnu.org/licenses>.
		19
		20	use Modern::Perl;
		21
		22	use CGI qw ( -utf8 );
		23	use Try::Tiny;
		24
		25	use C4::Auth qw(get_template_and_user);
		26	use C4::Output qw(output_html_with_http_headers);
		27
		28	use Koha::Libraries;
		29	use Koha::SMTP::Servers;
		30
		31	my $input = CGI->new;
		32	my $op = $input->param('op') \|\| 'list';
		33
		34	my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
		35	{ template_name => "admin/smtp_servers.tt",
		36	query => $input,
		37	type => "intranet",
		38	authnotrequired => 0,
		39	flagsrequired => { parameters => 1 },
		40	debug => 1,
		41	}
		42	);
		43
		44	my @messages;
		45
		46	if ( $op eq 'add' ) {
		47
		48	my $library_id = $input->param('library_id');
		49	$library_id = undef
		50	if defined $library_id and $library_id eq '*';
		51
		52	my $name = $input->param('smtp_name');
		53	my $host = $input->param('smtp_host');
		54	my $port = $input->param('smtp_port') \|\| 25;
		55	my $timeout = $input->param('smtp_timeout') \|\| 120;
		56	my $ssl = (scalar $input->param('smtp_ssl')) ? 1 : 0;
		57	my $user_name = $input->param('smtp_user_name') \|\| undef;
		58	my $password = $input->param('smtp_password') \|\| undef;
		59
		60	try {
		61	Koha::SMTP::Server->new(
		62	{
		63	library_id => $library_id,
		64	name => $name,
65	host => $host,
66	port => $port,
67	timeout => $timeout,
68	ssl => $ssl,
69	user_name => $user_name,
70	password => $password
71	}
72	)->store;
73
74	push @messages, { type => 'message', code => 'success_on_insert' };
75	}
76	catch {
77	warn "Something went wrong $_";
78	if ( blessed $_ and $_->isa('Koha::Exceptions::Object::DuplicateID') ) {
79	push @messages,
80	{
81	type => 'alert',
82	code => 'error_on_insert',
83	reason => 'duplicate_id'
84	};
85	}
86	};
87
88	# list servers after adding
89	$op = 'list';
90	}
91	elsif ( $op eq 'delete' ) {
92	my $smtp_server_id = $input->param('smtp_server_id');
93	my $smtp_server;
94
95	$smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
96	unless !$smtp_server_id;
97
98	if ( $smtp_server ) {
99	try {
100	my $name = $smtp_server->name;
101	$smtp_server->delete;
102	push @messages,
103	{
104	type => 'message',
105	code => 'success_on_delete'
106	};
107	}
108	catch {
109	push @messages,
110	{
111	type => 'alert',
112	code => 'error_on_delete'
113	};
114	};
115	}
116	else {
117	push @messages,
118	{
119	type => 'alert',
120	code => 'error_on_delete',
121	reason => 'invalid_id'
122	};
123	}
124
125	# list servers after delete
126	$op = 'list';
127	}
128	elsif ( $op eq 'edit_form' ) {
129	my $smtp_server_id = $input->param('smtp_server_id');
130	my $smtp_server;
131
132	$smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
133	unless !$smtp_server_id;
134
135	if ( $smtp_server ) {
136	$template->param(
137	smtp_server => $smtp_server
138	);
139	}
140	else {
141	push @messages,
142	{
143	type => 'alert',
144	code => 'error_on_edit',
145	reason => 'invalid_id'
146	};
147	}
148	}
149	elsif ( $op eq 'edit_save' ) {
150
151	my $smtp_server_id = $input->param('smtp_server_id');
152	my $smtp_server;
153
154	$smtp_server = Koha::SMTP::Servers->find($smtp_server_id)
155	unless !$smtp_server_id;
156
157	if ( $smtp_server ) {
158
159	my $name = $input->param('smtp_name');
160	my $host = $input->param('smtp_host');
161	my $port = $input->param('smtp_port') \|\| 25;
162	my $timeout = $input->param('smtp_timeout') \|\| 120;
163	my $ssl = (scalar $input->param('smtp_ssl')) ? 1 : 0;
164	my $user_name = $input->param('smtp_user_name') \|\| undef;
165	my $password = $input->param('smtp_password') \|\| undef;
166
167	try {
168	$smtp_server->set(
169	{
170	name => $name,
171	host => $host,
172	port => $port,
173	timeout => $timeout,
174	ssl => $ssl,
175	user_name => $user_name,
176	password => $password
177
178	}
179	)->store;
180
181	push @messages,
182	{
183	type => 'message',
184	code => 'success_on_update'
185	};
186	}
187	catch {
188	push @messages,
189	{
190	type => 'alert',
191	code => 'error_on_update'
192	};
193	};
194
195	# list servers after adding
196	$op = 'list';
197	}
198	else {
199	push @messages,
200	{
201	type => 'alert',
202	code => 'error_on_update',
203	reason => 'invalid_id'
204	};
205	}
206	}
207
208	if ( $op eq 'list' ) {
209	my $smtp_servers = Koha::SMTP::Servers->search;
210	$template->param(
211	servers_count => $smtp_servers->count,
212	default_config => $smtp_servers->default_setting
213	);
214	}
215
216	my @already_set_library_ids = Koha::SMTP::Servers->search(
217	{
218	library_id => { '!=' => undef }
219	}
220	)->get_column('library_id');
221
222	my $libraries = Koha::Libraries->search(
223	{
224	'me.branchcode' => { -not_in => \@already_set_library_ids }
225	}
226	);
227
228	my $default = Koha::SMTP::Servers->search({ library_id => undef })->count;
229
230	$template->param(
231	op => $op,
232	default_set => ( $default ) ? 1 : 0,
233	unset_libraries => $libraries,
234	messages => \@messages,
235	);
236
237	output_html_with_http_headers $input, $cookie, $template->output;

Line 0 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/smtp_servers.tt (-1 / +391 lines)
0	-	1	[% USE raw %]
		2	[% USE Asset %]
		3	[% SET footerjs = 1 %]
		4	[% USE TablesSettings %]
		5	[% INCLUDE 'doc-head-open.inc' %]
		6	<title>Koha &rsaquo; Administration &rsaquo; SMTP servers
		7	[% IF op == 'add_form' %]
		8	&rsaquo;[% IF library %]Modify SMTP server[% ELSE %]New SMTP server[% END %]
		9	[% ELSIF op == 'delete_confirm' %]
		10	&rsaquo; Confirm deletion of SMTP server '[% server.name \| html %]'
		11	[% END %]
		12	</title>
		13	[% INCLUDE 'doc-head-close.inc' %]
		14	</head>
		15
		16	<body id="admin_smtp_servers" class="admin">
		17	[% INCLUDE 'header.inc' %]
		18	[% INCLUDE 'prefs-admin-search.inc' %]
		19
		20	<div id="breadcrumbs">
		21	<a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;
		22	<a href="/cgi-bin/koha/admin/admin-home.pl">Administration</a> &rsaquo;
		23	<a href="/cgi-bin/koha/admin/smtp_servers.pl">SMTP servers</a>
		24	[% IF op == 'add_form' %]
		25	&rsaquo; <span> New</span>
		26	[% ELSIF op == 'edit_form' %]
		27	&rsaquo; <span> Edit</span>
		28	[% END %]
		29	</div>
		30
		31	<div class="main container-fluid">
		32	<div class="row">
		33	<div class="col-sm-10 col-sm-push-2">
		34	<main>
		35
		36	[% FOREACH m IN messages %]
		37	<div class="dialog [% message.type \| html %]">
		38	[% SWITCH m.code %]
		39	[% CASE 'error_on_update' %]
		40	An error occurred when updating this library. Perhaps it already exists.
		41	[% CASE 'error_on_insert' %]
		42	An error occurred when adding this library. The branchcode might already exist.
		43	[% CASE 'error_on_delete' %]
		44	An error occurred when deleting this library. Check the logs.
		45	[% CASE 'success_on_update' %]
		46	Library updated successfully.
		47	[% CASE 'success_on_insert' %]
		48	Library added successfully.
		49	[% CASE 'success_on_delete' %]
		50	Library deleted successfully.
		51	[% CASE 'cannot_delete_library' %]
		52	This library cannot be deleted. Patrons or items are still using it
		53	[% IF m.data.patrons_count and m.data.items_count %]
		54	([% m.data.patrons_count \| html %] patrons and [% m.data.items_count \| html %] items).
		55	[% ELSIF m.data.patrons_count %]
		56	([% m.data.patrons_count \| html %] patrons).
		57	[% ELSIF m.data.items_count %]
		58	([% m.data.items_count \| html %] items).
		59	[% END %]
		60	[% CASE 'error_on_update_category' %]
		61	An error occurred when updating this library category. Perhaps it already exists.
		62	[% CASE 'error_on_insert_category' %]
		63	An error occurred when adding this library category. The categorycode might already exist.
		64	[% CASE 'error_on_delete_category' %]
		65	An error occurred when deleting this library category. Check the logs.
66	[% CASE 'success_on_update_category' %]
67	Library category updated successfully.
68	[% CASE 'success_on_insert_category' %]
69	Library category added successfully.
70	[% CASE 'success_on_delete_category' %]
71	Library category deleted successfully.
72	[% CASE 'cannot_delete_category' %]
73	This library category cannot be deleted. [% m.data.libraries_count \| html %] libraries are still using it.
74	[% CASE %]
75	[% m.code \| html %]
76	[% END %]
77	</div>
78	[% END %]
79
80	[% IF op == 'add_form' %]
81	<h3>New SMTP server</h3>
82	<form action="/cgi-bin/koha/admin/smtp_servers.pl" id="add" name="add" class="validated" method="post">
83	<input type="hidden" name="op" value="add" />
84	<fieldset class="rows">
85	<ol>
86	<li>
87	<label for="library_id" class="required">Library: </label>
88	<select name="library_id" id="library_id">
89	[%- UNLESS default_set -%]
90	<option value="*">All libraries</option>
91	[%- END -%]
92	[%- FOREACH library IN unset_libraries -%]
93	<option value="[% library.branchcode \| html %]">[% library.branchname \| html %]</option>
94	[%- END -%]
95	</select>
96	<span class="required">Required</span>
97	</li>
98	</select>
99	<li>
100	<label for="smtp_name" class="required">Name: </label>
101	<input type="text" name="smtp_name" id="smtp_name" size="60" class="required" required="required" />
102	<span class="required">Required</span>
103	</li>
104	</ol>
105	</fieldset>
106
107	<fieldset class="rows">
108	<ol>
109	<li>
110	<label for="smtp_host">Host: </label>
111	<input type="text" name="smtp_host" id="smtp_host" size="60" class="required"/>
112	<span class="required">Required</span>
113	</li>
114	<li>
115	<label for="smtp_port">Port: </label>
116	<input type="number" step="1" value="25" name="smtp_port" id="smtp_port" size="20" class="required"/>
117	<span class="required">Required</span>
118	</li>
119	<li>
120	<label for="smtp_timeout">Timeout (seconds): </label>
121	<input type="number" step="1" value="120" name="smtp_timeout" id="smtp_timeout" size="20" />
122	</li>
123	<li>
124	<label for="smtp_ssl">SSL: </label>
125	<select name="smtp_ssl" id="smtp_ssl">
126	<option value="1" selected="selected">Yes</option>
127	<option value="0">No</option>
128	</select>
129	</li>
130	<li>
131	<label for="smtp_user_name">User name: </label>
132	<input type="text" name="smtp_user_name" id="smtp_user_name" size="60" />
133	</li>
134	<li>
135	<label for="smtp_password">Password: </label>
136	<input type="password" name="smtp_password" id="smtp_password" size="60" />
137	</li>
138	</ol>
139	</fieldset>
140	<fieldset class="action">
141	<input type="submit" value="Submit" />
142	<a class="cancel" href="/cgi-bin/koha/admin/smtp_servers.pl">Cancel</a>
143	</fieldset>
144	</form>
145	[% END %]
146
147	[% IF op == 'edit_form' %]
148	<h3>Edit SMTP server</h3>
149	<form action="/cgi-bin/koha/admin/smtp_servers.pl" id="edit_save" name="edit_save" class="validated" method="post">
150	<input type="hidden" name="op" value="edit_save" />
151	<input type="hidden" name="smtp_server_id" value="[%- smtp_server.id \| html -%]" />
152	<fieldset class="rows">
153	<ol>
154	<li>
155	<label for="library_id">Library: </label>
156	[% IF smtp_server.library %]
157	<span name="library_id" id="library_id">[%- smtp_server.library.branchname \| html -%]</span>
158	[%- ELSE -%]
159	<span name="library_id" id="library_id">All libraries</span>
160	[%- END -%]
161	</li>
162	</select>
163	<li>
164	<label for="smtp_name" class="required">Name: </label>
165	<input type="text" name="smtp_name" id="smtp_name" size="60" class="required" required="required" value="[%- smtp_server.name \| html -%]"/>
166	<span class="required">Required</span>
167	</li>
168	</ol>
169	</fieldset>
170
171	<fieldset class="rows">
172	<ol>
173	<li>
174	<label for="smtp_host">Host: </label>
175	<input type="text" name="smtp_host" id="smtp_host" size="60" class="required" value="[%- smtp_server.host \| html -%]"/>
176	<span class="required">Required</span>
177	</li>
178	<li>
179	<label for="smtp_port">Port: </label>
180	<input type="number" step="1" value="25" name="smtp_port" id="smtp_port" size="20" class="required" value="[%- smtp_server.port \| html -%]"/>
181	<span class="required">Required</span>
182	</li>
183	<li>
184	<label for="smtp_timeout">Timeout (seconds): </label>
185	<input type="number" step="1" value="120" name="smtp_timeout" id="smtp_timeout" size="20" value="[%- smtp_server.timeout \| html -%]"/>
186	</li>
187	<li>
188	<label for="smtp_ssl">SSL: </label>
189	<select name="smtp_ssl" id="smtp_ssl">
190	[%- IF smtp_server.ssl -%]
191	<option value="1" selected="selected">Yes</option>
192	<option value="0">No</option>
193	[%- ELSE -%]
194	<option value="1">Yes</option>
195	<option value="0" selected="selected">No</option>
196	[%- END -%]
197	</select>
198	</li>
199	<li>
200	<label for="smtp_user_name">User name: </label>
201	<input type="text" name="smtp_user_name" id="smtp_user_name" size="60" value="[%- smtp_server.user_name \| html -%]"/>
202	</li>
203	<li>
204	<label for="smtp_password">Password: </label>
205	<input type="password" name="smtp_password" id="smtp_password" size="60" value="[%- smtp_server.password \| html -%]"/>
206	</li>
207	</ol>
208	</fieldset>
209	<fieldset class="action">
210	<input type="submit" value="Submit" />
211	<a class="cancel" href="/cgi-bin/koha/admin/smtp_servers.pl">Cancel</a>
212	</fieldset>
213	</form>
214	[% END %]
215
216	[% IF op == 'list' %]
217
218	[%- IF unset_libraries.count > 0 -%]
219	<div id="toolbar" class="btn-toolbar">
220	<a class="btn btn-default" id="new_smtp_server" href="/cgi-bin/koha/admin/smtp_servers.pl?op=add_form"><i class="fa fa-plus"></i> New SMTP server</a>
221	</div>
222	[%- END -%]
223
224	<h3>SMTP servers</h3>
225
226	[% IF servers_count > 0 %]
227	<table id="smtp_servers">
228	<thead>
229	<tr>
230	<th>Library</th>
231	<th>Name</th>
232	<th>Host</th>
233	<th>Port</th>
234	<th>Timeout (secs)</th>
235	<th>SSL</th>
236	<th>Authenticated</th>
237	<th data-class-name="actions">Actions</th>
238	</tr>
239	</thead>
240	</table>
241	[% ELSE %]
242	<div class="dialog message">No user-defined SMTP servers. Using the default configuration:
243	<ul>
244	<li><strong>Host</strong>: [%- default_config.host \| html -%]</li>
245	<li><strong>Port</strong>: [%- default_config.port \| html -%]</li>
246	<li><strong>Timeout (secs)</strong>: [%- default_config.timeout \| html -%]</li>
247	<li><strong>SSL</strong>: [%- IF default_config.ssl -%]Yes[%- ELSE -%]No[%- END -%]</li>
248	</ul>
249	</pre>
250	</div>
251	[% END %]
252	[% END %]
253
254	<div id="delete_confirm_modal" class="modal" tabindex="-1" role="dialog" aria-labelledby="delete_confirm_modal_label" aria-hidden="true">
255	<div class="modal-dialog">
256	<div class="modal-content">
257	<div class="modal-header">
258	<button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button>
259	<h3 id="delete_confirm_modal_label">Delete server</h3>
260	</div>
261	<div class="modal-body">
262	<div id="delete_confirm_dialog"></div>
263	</div>
264	<div class="modal-footer">
265	<a href="#" class="btn btn-default" id="delete_confirm_modal_button" role="button" data-toggle="modal">Delete</a>
266	<button class="btn btn-default" data-dismiss="modal" aria-hidden="true">Close</button>
267	</div>
268	</div> <!-- /.modal-content -->
269	</div> <!-- /.modal-dialog -->
270	</div> <!-- #delete_confirm_modal -->
271
272	</main>
273	</div> <!-- /.col-sm-10.col-sm-push-2 -->
274
275	<div class="col-sm-2 col-sm-pull-10">
276	<aside>
277	[% INCLUDE 'admin-menu.inc' %]
278	</aside>
279	</div> <!-- /.col-sm-2.col-sm-pull-10 -->
280	</div> <!-- /.row -->
281
282
283	[% MACRO jsinclude BLOCK %]
284	[% Asset.js("js/admin-menu.js") \| $raw %]
285	[% INCLUDE 'datatables.inc' %]
286	[% INCLUDE 'columns_settings.inc' %]
287	[% Asset.js("lib/tiny_mce/tinymce.min.js") \| $raw %]
288	[% INCLUDE 'str/tinymce_i18n.inc' %]
289	<script>
290	$(document).ready(function() {
291
292	var smtp_servers_url = '/api/v1/config/smtp_servers';
293	var smtp_servers = $("#smtp_servers").api({
294	"ajax": {
295	"url": smtp_servers_url
296	},
297	"embed": [
298	"library"
299	],
300	'emptyTable': '<div class="dialog message">'+_("There are no SMTP servers defined.")+'</div>',
301	"columnDefs": [ {
302	"targets": [0,1,2],
303	"render": function (data, type, row, meta) {
304	if ( type == 'display' ) {
305	if ( data != null ) {
306	return data.escapeHtml();
307	}
308	else {
309	return "Default";
310	}
311	}
312	return data;
313	}
314	} ],
315	"columns": [
316	{
317	"data": "library.name",
318	"searchable": true,
319	"orderable": true
320	},
321	{
322	"data": "name",
323	"searchable": true,
324	"orderable": true
325	},
326	{
327	"data": "host",
328	"searchable": true,
329	"orderable": true
330	},
331	{
332	"data": "port",
333	"searchable": true,
334	"orderable": false
335	},
336	{
337	"data": "timeout",
338	"searchable": true,
339	"orderable": false
340	},
341	{
342	"data": "ssl",
343	"render": function (data, type, row, meta) {
344	if (data) {
345	return _("Yes");
346	}
347	else {
348	return _("No");
349	}
350	},
351	"searchable": false,
352	"orderable": false
353	},
354	{
355	"data": function( row, type, val, meta ) {
356	if ( row.user_name != null ) {
357	return _("Yes");
358	}
359	else {
360	return _("No");
361	}
362	},
363	"searchable": false,
364	"orderable": false
365	},
366	{
367	"data": function( row, type, val, meta ) {
368	var result = '<a class="btn btn-default btn-xs" role="button" href="/cgi-bin/koha/admin/smtp_servers.pl?op=edit_form&smtp_server_id='+ encodeURIComponent(row.smtp_server_id) +'"><i class="fa fa-pencil" aria-hidden="true"></i> '+_("Edit")+'</a>'+"\n";
369	result += '<a class="btn btn-default btn-xs delete_server" role="button" href="#" data-toggle="modal" data-target="#delete_confirm_modal" data-smtp-server-id="'+ encodeURIComponent(row.smtp_server_id) +'" data-smtp-server-name="'+ encodeURIComponent(row.name) +'"><i class="fa fa-trash" aria-hidden="true"></i>'+_("Delete")+'</a>';
370	return result;
371	},
372	"searchable": false,
373	"orderable": false
374	}
375	]
376	});
377
378	$('#smtp_servers').on( "click", '.delete_server', function () {
379	var smtp_server_id = $(this).data('smtp-server-id');
380	var smtp_server_name = $(this).data('smtp-server-name');
381
382	$("#delete_confirm_dialog").html(
383	_("You are about to delete the \"%s\" SMTP server.").format(smtp_server_name)
384	);
385	$("#delete_confirm_modal_button").attr("href", "/cgi-bin/koha/admin/smtp_servers.pl?op=delete&smtp_server_id=" + encodeURIComponent(smtp_server_id));
386	});
387	});
388	</script>
389	[% END %]
390
391	[% INCLUDE 'intranet-bottom.inc' %]