From 572790cfe727d84763b6ca5e40b5bed70403f57b Mon Sep 17 00:00:00 2001
From: jeremy breuillard <jeremy.breuillard@biblibre.com>
Date: Tue, 22 Feb 2022 14:03:08 +0100
Subject: [PATCH] Bug 27123: Add messages to batch patrons modification

With this patch you can write or delete circulation messages on the batch patrons modification form

Test plan:
1)Go to Home > Tools > Batch patron modification
2)Write one or more card numbers to access the modification form
3)Notice the input you can interact with
4)Apply patch and repeat 1) & 2)
5)Notice the new input 'Message:' which appeared down the form
6)Write a message and choose a type (opac or intranet)
7)Save & notice the new 'Message' column filled up with what you wrote before
8)To delete: back on the modification form - check the checkbox beside the input - save again
---
 .../prog/en/modules/tools/modborrowers.tt     | 22 ++++++++++
 tools/modborrowers.pl                         | 41 ++++++++++++++++++-
 2 files changed, 62 insertions(+), 1 deletion(-)

diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/modborrowers.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/tools/modborrowers.tt
index 1a69521b97..1dd4b02e1c 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/modborrowers.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/tools/modborrowers.tt
@@ -34,6 +34,7 @@
         <div class="col-sm-10 col-sm-push-2">
             <main>
 
+
                 [% IF ( op == 'show_form' ) %]
                 <h1>Batch patron modification</h1>
                 <form id="patron_batchmod_form" method="post" enctype="multipart/form-data" action="/cgi-bin/koha/tools/modborrowers.pl">
@@ -223,6 +224,7 @@
                                                 <th>Expiry date</th>
                                                 <th>Circulation note</th>
                                                 <th>OPAC note</th>
+                                                <th>Message</th>
                                                 <th>Restriction expiration</th>
                                                 <th>Restriction comment</th>
                                                 [% FOREACH attrh IN attributes_header %]
@@ -259,6 +261,18 @@
                                                     <td data-order="[% borrower.dateexpiry | html %]">[% borrower.dateexpiry | $KohaDates %]</td>
                                                     <td>[% borrower.borrowernotes | html %]</td>
                                                     <td>[% borrower.opacnote | html %]</td>
+                                                    <td>
+                                                        [% FOREACH patron_message IN borrower.patron_messages %]
+                                                            [% patron_message.message | html %] <br>
+                                                            <strong>
+                                                            [% IF (patron_message.message_type == 'B') %]
+                                                                ( OPAC )
+                                                            [% ELSE %]
+                                                                ( Staff )
+                                                            [% END %]
+                                                            </strong><br><br>
+                                                        [% END %]
+                                                    </td>
                                                     <td data-order="[% borrower.debarred | html %]">[% borrower.debarred | $KohaDates %]</td>
                                                     <td>[% borrower.debarredcomment | html %]</td>
                                                     [% FOREACH pa IN borrower.patron_attributes %]
@@ -310,6 +324,7 @@
                                                 [% CASE 'dateexpiry' %]<span>Expiry date:</span>
                                                 [% CASE 'borrowernotes' %]<span>Circulation note:</span>
                                                 [% CASE 'opacnote' %]<span>OPAC note:</span>
+                                                [% CASE "message" %]<span>Message:</span>
                                                 [% CASE 'debarred' %]<span>Restriction expiration:</span>
                                                 [% CASE 'debarredcomment' %]<span>Restriction comment:</span>
                                             [% END %]
@@ -317,6 +332,13 @@
                                             [% IF ( field.type == 'text' ) %]
                                                 <input type="text" name="[% field.name | html %]" value="" />
                                             [% END %]
+                                            [% IF ( field.type == 'message_type' ) %]
+                                                <input type="text" name="[% field.name | html %]" value="" />
+                                                <select name="add_message_type" id="message_type">
+                                                    <option value="L">Staff - Internal note</option>
+                                                    <option value="B">OPAC</option>
+                                                </select>
+                                            [% END %]
                                             [% IF ( field.type == 'select' ) %]
                                                 [% IF field.option.size %]
                                                     <select name="[% field.name | html %]" >
diff --git a/tools/modborrowers.pl b/tools/modborrowers.pl
index 8aed3f4b4b..079d0c2e01 100755
--- a/tools/modborrowers.pl
+++ b/tools/modborrowers.pl
@@ -31,6 +31,7 @@ use C4::Auth qw( get_template_and_user );
 use C4::Koha qw( GetAuthorisedValues );
 use C4::Members;
 use C4::Output qw( output_html_with_http_headers );
+use C4::Context;
 use Koha::DateUtils qw( dt_from_string );
 use Koha::List::Patron qw( GetPatronLists );
 use Koha::Libraries;
@@ -38,6 +39,7 @@ use Koha::Patron::Categories;
 use Koha::Patron::Debarments qw( AddDebarment DelDebarment GetDebarments );
 use Koha::Patrons;
 use List::MoreUtils qw(uniq);
+use Koha::Patron::Messages;
 
 my $input = CGI->new;
 my $op = $input->param('op') || 'show_form';
@@ -109,6 +111,12 @@ if ( $op eq 'show' ) {
             if ( $logged_in_user->can_see_patron_infos( $patron ) ) {
                 my $borrower = $patron->unblessed;
                 my $attributes = $patron->extended_attributes;
+                my $patron_messages = Koha::Patron::Messages->search(
+                    {
+                        'me.borrowernumber' => $patron->borrowernumber,
+                    }
+                );
+                $borrower->{patron_messages} = $patron_messages->as_list;
                 $borrower->{patron_attributes} = $attributes->as_list;
                 $borrower->{patron_attributes_count} = $attributes->count;
                 $max_nb_attr = $borrower->{patron_attributes_count} if $borrower->{patron_attributes_count} > $max_nb_attr;
@@ -317,6 +325,12 @@ if ( $op eq 'show' ) {
             mandatory => ( grep /opacnote/, @mandatoryFields ) ? 1 : 0,
         }
         ,
+        {
+            name => "message",
+            type => "message_type",
+            mandatory => ( grep /message/, @mandatoryFields ) ? 1 : 0,
+        }
+        ,
         {
             name => "debarred",
             type => "date",
@@ -380,7 +394,11 @@ if ( $op eq 'do' ) {
                    }
                 };
             }
-
+            # If 'message' or 'add_message_type' is defined then delete both at the same time
+            if ( grep { $_ eq 'message' } @disabled) {
+                my $patron = Koha::Patrons->find( $borrowernumber );
+                $patron->messages()->delete();
+            }
             $infos->{borrowernumber} = $borrowernumber;
             eval { Koha::Patrons->find( $borrowernumber )->set($infos)->store; };
             if ( $@ ) { # FIXME We could provide better error handling here
@@ -419,7 +437,22 @@ if ( $op eq 'do' ) {
             }
             $i++;
         }
+
+        # Handle patron messages
+        my $message          = $input->param('message');
+        my $branchcode       = C4::Context::mybranch;
+        my $message_type     = $input->param('add_message_type');
+
+        Koha::Patron::Message->new(
+            {
+                borrowernumber => $borrowernumber,
+                branchcode     => $branchcode,
+                message_type   => $message_type,
+                message        => $message,
+            }
+        )->store;
     }
+
     $op = "show_results"; # We have process modifications, the user want to view its
 
     # Construct the results list
@@ -430,6 +463,12 @@ if ( $op eq 'do' ) {
         if ( $patron ) {
             my $category_description = $patron->category->description;
             my $borrower = $patron->unblessed;
+            my $patron_messages = Koha::Patron::Messages->search(
+                    {
+                        'me.borrowernumber' => $patron->borrowernumber,
+                    }
+                );
+            $borrower->{patron_messages} = $patron_messages->as_list;
             $borrower->{category_description} = $category_description;
             my $attributes = $patron->extended_attributes;
             $borrower->{patron_attributes} = $attributes->as_list;
-- 
2.17.1