&SetIssueNote

=item * issue_id

=head2 SetIssueNote

  &SetIssueNote($issue_id, $note);

Sets a note to the issuenotes table for the given issue.

=over 4

=item C<$issue_id> is the id of the issue for which to set the note

=item C<$note> is the note to set

=back

Returns:

  True on success

  False on failure

=cut

sub SetIssueNote {

    my ( $issue_id, $note) = @_;

    my $dbh  = C4::Context->dbh;

    unless ( $issue_id =~ /\d+/ ) {

      return;

    }

    my $query = "UPDATE issues SET notedate=NOW(),note=? WHERE issue_id=?";

    my $sth = $dbh->prepare($query);

    return $sth->execute( $note, $issue_id );

}

=head2 SendIssueNote

    &SendIssueNote($biblio, $borrower, $branch);

Sends the issue note to the library (adds it to the message queue).

=cut

sub SendIssueNote {

    my $biblio = shift;

    my $borrower = shift;

    my $branch = shift;

    my $letter = C4::Letters::GetPreparedLetter (

        module => 'circulation',

        letter_code => 'PATRON_NOTE',

        branchcode => $branch,

        tables => {

            'biblio' => $biblio->{biblionumber},

            'borrowers' => $borrower->{borrowernumber},

            },

        );

    warn("issue", $biblio);

    C4::Message->enqueue($letter, $borrower, 'email');

}

    my $issue = GetItemIssue($itemnumber);

        issue            => $issue,

ALTER IGNORE TABLE issues ADD `note` mediumtext default NULL;

ALTER IGNORE TABLE issues ADD `notedate` datetime default NULL;

INSERT IGNORE INTO letter (`module`, `code`, `branchcode`, `name`, `is_html`, `title`, `content`, `message_transport_type`) VALUES ('circulation', 'PATRON_NOTE', '', 'Patron note on item', '0', 'Patron issue note', '<<borrowers.firstname>> <<borrowers.surname>> has added a note to the item <<biblio.item>> - <<biblio.author>> (<<biblio.biblionumber>>).','email');

INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`, `explanation`,`type`) VALUES ('AllowIssueNotes', '0', NULL, 'Allow patrons to submit notes about checked out items.','YesNo');

-- Table structure for table `issues`

--

DROP TABLE IF EXISTS `issues`;

CREATE TABLE `issues` ( -- information related to check outs or issues

  `issue_id` int(11) NOT NULL AUTO_INCREMENT, -- primary key for issues table

  `borrowernumber` int(11), -- foreign key, linking this to the borrowers table for the patron this item was checked out to

  `itemnumber` int(11), -- foreign key, linking this to the items table for the item that was checked out

  `date_due` datetime default NULL, -- datetime the item is due (yyyy-mm-dd hh:mm::ss)

  `branchcode` varchar(10) default NULL, -- foreign key, linking to the branches table for the location the item was checked out

  `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues

  `lastreneweddate` datetime default NULL, -- date the item was last renewed

  `return` varchar(4) default NULL,

  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed

  `auto_renew` BOOLEAN default FALSE, -- automatic renewal

  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched

  `issuedate` datetime default NULL, -- date the item was checked out or issued

  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag

  `note` mediumtext default NULL, -- issue note text

  `notedate` datetime default NULL, -- datetime of issue note (yyyy-mm-dd hh:mm::ss)

  PRIMARY KEY (`issue_id`),

  KEY `issuesborridx` (`borrowernumber`),

  KEY `itemnumber_idx` (`itemnumber`),

  KEY `branchcode_idx` (`branchcode`),

  KEY `bordate` (`borrowernumber`,`timestamp`),

  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE RESTRICT ON UPDATE CASCADE,

  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE RESTRICT ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--

('AllowIssueNotes', '0', NULL, 'Allow patrons to submit notes about checked out items.','YesNo'),

        -

            - pref: AllowIssueNotes

              choices:

                  yes: Allow

                  no: "Don't allow"

            - patrons to submit notes about checked out items.

<!-- Patron has added an issue note -->

[% IF ( issue.note) %]

    <div class="dialog message">

        <h1>Patron note</h1>

        <p>[% issue.notedate %]</p>

        <p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% itembiblionumber %]"> [% title |html %]</a> [% author %]</p>

        <p>[% issue.note %]</p>

    </div>

[% END %]

                    <div class="alert alert-info" id="notesaved" style="display:none"></div>

                                                [% IF ( AllowIssueNotes ) %]

                                                    <th class="nosort">Note</th>

                                                [% END %]

                                                [% IF ( AllowIssueNotes ) %]

                                                    <td class="note">

                                                        <input type="text"

                                                            name="note"

                                                            data-issue_id="[% ISSUE.issue_id%]"

                                                            data-origvalue="[% ISSUE.note %]"

                                                            value="[% ISSUE.note %]">

                                                        </input>

                                                        <a class="btn"

                                                            name="submitnote"

                                                            id="save_[% ISSUE.issue_id %]"

                                                            style="display:none;">Submit note</a>

                                                    </td>

                                                [% END %]

            [% IF ( AllowIssueNotes ) %]

                $("input[name='note']").keyup(function(e){

                    /* prevent submitting of renewselected form */

                    if(e.which == 13)

                        e.preventDefault();

                    var $btn_save = $('#save_'+$(this).data('issue_id'));

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

                    var value = $(this).val();

                    if(origvalue != value) {

                        if(origvalue != "")

                            $btn_save.text('Submit changes');

                        else

                            $btn_save.text('Submit note');

                        $btn_save.show();

                    } else {

                        $btn_save.hide();

                    }

                });

                $("a[name='submitnote']").click(function(e){

                    var $self = $(this);

                    var title = $(this).parent().siblings('.title').html();

                    var $noteinput = $(this).siblings('input[name="note"]').first();

                    var ajaxData = {

                        'action': 'issuenote',

                        'issue_id': $noteinput.data('issue_id'),

                        'note': $noteinput.val(),

                    };

                    $.ajax({

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

                        type: 'POST',

                        dataType: 'json',

                        data: ajaxData,

                    })

                    .done(function(data) {

                        var message = "";

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

                            $("#notesaved").removeClass("alert-error");

                            $("#notesaved").addClass("alert-info");

                            $noteinput.data('origvalue', data.note);

                            $noteinput.val(data.note);

                            message = "<p>Your note about " + title + " has been saved and sent to the library.</p>";

                            $self.hide();

                        } else if(data.status == 'removed') {

                            $("#notesaved").removeClass("alert-error");

                            $("#notesaved").addClass("alert-info");

                            $noteinput.data('origvalue', "");

                            $noteinput.val("");

                            message = "<p>Your note about " + title + " was removed.</p>";

                            $self.hide();

                        } else {

                            $("#notesaved").removeClass("alert-info");

                            $("#notesaved").addClass("alert-error");

                            message = "<p>Your note about " + title + " could not be saved.</p>" +

                                      "<p style=\"font-weight:bold;\">" + data.error + "</p>";

                        }

                        message += "<p style=\"font-style:italic;\">" + data.note + "</p>";

                        $("#notesaved").html(message);

                    })

                    .fail(function(data) {

                        $("#notesaved").removeClass("alert-info");

                        $("#notesaved").addClass("alert-error");

                        var message = "<p>Your note about " + title + " could not be saved.</p>" +

                                      "<p style=\"font-weight:bold;\">Ajax request has failed.</p>";

                        $("#notesaved").html(message);

                    })

                    .always(function() {

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

                    });

                });

            [% END %]

use Koha::Libraries;

$template->param( AllowIssueNotes => C4::Context->preference('AllowIssueNotes') );