=head2 noteseen

  data_type: 'integer'

  is_nullable: 1

  "noteseen",

  { data_type => "integer", is_nullable => 1 },

#!/usr/bin/perl

# Copyright 2016 Aleisha Amohia <aleisha@catalyst.net.nz>

#

# 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 C4::Context;

use C4::Output;

use C4::Auth;

use Koha::Checkouts;

my $query = new CGI;

my ( $template, $loggedinuser, $cookie ) = get_template_and_user(

    {

        template_name   => "circ/checkout-notes.tt",

        query           => $query,

        type            => "intranet",

        authnotrequired => 0,

        flagsrequired   => { circulation => "manage_checkout_notes" },

    }

);

my $schema = Koha::Database->new()->schema();

my @notes = $schema->resultset('Issue')->search({ 'me.note' => { '!=', undef } }, { prefetch => [ 'borrower', { item => 'biblionumber' } ] });

$template->param(

    notes     => \@notes,

);

my $action;

foreach (qw( seen notseen )) {

    $action = $_ if ( $query->param("mark_selected-$_") );

}

$action ||= 'none';

my @issue_ids = $query->multi_param('issue_ids');

if ( $action eq 'seen' ) {

    foreach my $issue_id ( @issue_ids ) {

        my $issue = Koha::Checkouts->find($issue_id);

        $issue->set({ noteseen => 1 })->store;

    }

} elsif ( $action eq 'notseen' ) {

    foreach my $issue_id ( @issue_ids ) {

        my $issue = Koha::Checkouts->find($issue_id);

        $issue->set({ noteseen => 0 })->store;

    }

}

$template->param(

    selected_count => scalar(@issue_ids),

    action         => $action,

);

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

use Koha::Checkouts;

my $pending_checkout_notes = Koha::Checkouts->search({ noteseen => 0 })->count;

$template->param( pending_checkout_notes => $pending_checkout_notes );

$DBversion = 'XXX';

if( CheckVersion( $DBversion ) ) {

    unless( column_exists( 'issues', 'noteseen' ) ) {

        $dbh->do(q|ALTER TABLE issues ADD noteseen int(1) default NULL AFTER notedate|);

    }

    unless( column_exists( 'old_issues', 'noteseen' ) ) {

        $dbh->do(q|ALTER TABLE old_issues ADD noteseen int(1) default NULL AFTER notedate|);

    }

    SetVersion( $DBversion );

    print "Upgrade to $DBversion done (Bug 17698: Add column issues.noteseen and old_issues.noteseen)\n";

}

INSERT INTO permissions (module_bit, code, description) VALUES ( 1, 'manage_checkout_notes', 'Mark checkout notes as seen/not seen');

  `noteseen` int(1) default NULL, -- describes whether issue note has been seen 1, not been seen 0 or doesn't exist null

   ( 1, 'manage_checkout_notes', 'Mark checkout notes as seen/not seen'),

    [%- CASE 'manage_checkout_notes' -%]<span>Mark checkout notes as seen/notseen</span>

[% USE Koha %]

[% USE KohaDates %]

[% USE Branches %]

[% INCLUDE 'doc-head-open.inc' %]

<title>Home &rsaquo; Circulation &rsaquo; Issue Notes</title>

[% INCLUDE 'doc-head-close.inc' %]

<link rel="stylesheet" type="text/css" href="[% interface %]/[% theme %]/css/datatables.css" />

[% INCLUDE 'datatables.inc' %]

<script type="text/javascript">

//<![CDATA[

    $(document).ready(function(){

        $("#notestable").dataTable($.extend(true, {}, dataTablesDefaults, {

            "aoColumnDefs": [

                { "aTargets": [ 0, -1 ], "bSearchable": false, "bSortable": false },

            ],

            "sPaginationType": "four_button"

        }));

        $(".SelectAll").on("click", function(){

            $("input[name='issue_ids'][type='checkbox']").prop("checked", true);

            $(".btn-sm").prop("disabled", false);

        });

        $(".ClearAll").on("click", function(){

            $("input[name='issue_ids'][type='checkbox']").prop("checked", false);

            $(".btn-sm").prop("disabled", true);

        });

        $("#error").hide();

        $("input[type='checkbox']").click(function(event){

            if ( $("input[type='checkbox']").is(":checked") ) {

                $(".btn-sm").prop("disabled", false);

            } else {

                $(".btn-sm").prop("disabled", true);

            }

        });

        $(".btn-xs").click(function(event){

            event.preventDefault(); // prevent form submission

            var $action = $(this).attr("name");

            var $issue_id = $(this).data('issue_id');

            var ajaxData = {

                'action': $action,

                'issue_id': $issue_id,

            };

            $.ajax({

                url: '/cgi-bin/koha/svc/checkout_notes/',

                type: 'POST',

                dataType: 'json',

                data: ajaxData,

            })

            .done(function(data){

                if (data.status == 'success'){

                    if ( $action == 'notseen' ){

                        $("#status_" + $issue_id).text("Not seen");

                        $(event.target).siblings(".seen").prop("disabled", false);

                        $(event.target).prop("disabled", true);

                    } else {

                        $("#status_" + $issue_id).text("Seen");

                        $(event.target).siblings(".notseen").prop("disabled", false);

                        $(event.target).prop("disabled", true);

                    }

                } else {

                    $("#error").text(_("Unable to change status of note."));

                    $("#error").show();

                }

            });

        });

    });

//]]>

</script>

[% INCLUDE 'calendar.inc' %]

<script type="text/javascript" src="[% interface %]/lib/jquery/plugins/jquery.checkboxes.min.js"></script>

</head>

[% INCLUDE 'header.inc' %]

[% INCLUDE 'circ-search.inc' %]

<div id="breadcrumbs">

    <a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo;

    <a href="/cgi-bin/koha/circ/circulation-home.pl">Circulation</a> &rsaquo;

    Checkout notes

</div>

<div id="doc" class="yui-t7"> <!-- <div id="doc3" class="yui-t2" -->

    <div id="bd">

        <div id="yui-main">

            <h1>Checkout notes</h1>

            <div class="dialog alert" id="error"></div>

            [% IF ( selected_count ) %]

                <div class="dialog message">

                    [% IF ( action == 'seen' ) %]

                        [% selected_count %] note(s) marked as seen.

                    [% ELSIF ( action == 'notseen' ) %]

                        [% selected_count %] note(s) marked as not seen.

                    [% ELSE %]

                        Failed to change the status of [% selected_count %] item(s).

                    [% END %]

                </div>

                <a href="/cgi-bin/koha/circ/checkout-notes.pl" class="btn btn-default btn-sm"><i class="fa fa-left"></i> Return to checkout notes</a>

            [% ELSE %]

            [% IF ( notes ) %]

            <fieldset class="action">

                <a class="SelectAll"><i class="fa fa-check"></i> Select all</a> | <a class="ClearAll"><i class="fa fa-remove"></i> Clear all</a>

            </fieldset>

            <form id="mark_selected" method="post" action="/cgi-bin/koha/circ/checkout-notes.pl">

            <table id="notestable">

                <thead>

                    <tr>

                        <th>&nbsp;</th>

                        <th>Title</th>

                        <th>Note</th>

                        <th>Date</th>

                        <th>Set by</th>

                        <th>Status</th>

                        <th>Actions</th>

                    </tr>

                </thead>

                <tbody>

                [% FOREACH note IN notes %]

                    <tr>

                        <td><input type="checkbox" name="issue_ids" value="[% note.issue_id %]"></td>

                        <td>[% note.item.biblionumber.title %] - [% note.item.biblionumber.author %] (<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% note.item.biblionumber.biblionumber %]">[% note.item.barcode %]</a>)</td>

                        <td>[% note.note %]</td>

                        <td>[% note.notedate | $KohaDates %]</td>

                        <td>[% note.borrower.firstname %] [% note.borrower.surname %] (<a href="/cgi-bin/koha/circ/circulation.pl?borrowernumber=[% note.borrower.borrowernumber %]">[% note.borrower.cardnumber %]</a>)</td>

                        <td>[% IF ( note.noteseen == 0 ) %]

                            <span id="status_[% note.issue_id %]">Not seen</span>

                        [% ELSIF ( note.noteseen == 1 ) %]

                            <span id="status_[% note.issue_id %]">Seen</span>

                        [% END %]</td>

                        <td class="actions">[% IF ( note.noteseen == 1 ) %]

                            <button name="seen" data-issue_id="[% note.issue_id %]" class="seen btn btn-default btn-xs" disabled="disabled"><i class="fa fa-eye"></i> Mark seen</button> <button name="notseen" data-issue_id="[% note.issue_id %]" class="notseen btn btn-default btn-xs"><i class="fa fa-eye-slash"></i> Mark not seen</button>

                        [% ELSIF ( note.noteseen == 0 ) %]

                            <button name="seen" data-issue_id="[% note.issue_id %]" class="seen btn btn-default btn-xs"><i class="fa fa-eye"></i> Mark seen</button> <button name="notseen" data-issue_id="[% note.issue_id %]" class="notseen btn btn-default btn-xs" disabled="disabled"><i class="fa fa-eye-slash"></i> Mark not seen</button>

                        [% END %]</td>

                    </tr>

                [% END %]

                </tbody>

            </table>

            <fieldset class="action">

                <button type="submit" class="btn btn-default btn-sm" name="mark_selected-seen" value="seen" disabled="disabled"><i class="fa fa-eye"></i> Mark seen</button>

                <button type="submit" class="btn btn-default btn-sm" name="mark_selected-notseen" value="notseen" disabled="disabled"><i class="fa fa-eye-slash"></i> Mark not seen</button>

            </fieldset>

            </form>

            [% END %] <!-- notes -->

            [% END %] <!-- selected_count -->

        </div> <!-- yui-main -->

    </div> <!-- bd -->

</div> <!-- doc3 -->

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

        [% IF ( Koha.Preference('AllowCheckoutNotes') && CAN_user_circulate_manage_checkout_notes ) %]<li><a href="/cgi-bin/koha/circ/checkout-notes.pl">Checkout notes</a> [% IF ( pending_checkout_notes ) %]<span class="number_box"><a href="/cgi-bin/koha/circ/checkout-notes.pl">[% pending_checkout_notes %]</a></span>[% END %]</li>[% END %]

                    [% IF Koha.Preference('AllowCheckoutNotes') && CAN_user_circulate_manage_checkout_notes && pending_checkout_notes %]

                    <div class="pending-info" id="checkout_notes_pending">

                        <a href="/cgi-bin/koha/circ/checkout-notes.pl">Checkout notes pending</a>:

                        <span class="pending-number-link">[% pending_checkout_notes %]</span>

                    </div>

                    [% END %]

use Koha::Checkouts;

my $pending_checkout_notes = Koha::Checkouts->search({ noteseen => 0 })->count;

    pending_checkout_notes         => $pending_checkout_notes,