From 09010a248b65c7a47973c208809c1915dac3fe0e Mon Sep 17 00:00:00 2001
From: =?utf8?q?Fr=C3=A9d=C3=A9ric=20Demians?= <f.demians@tamil.fr>
Date: Tue, 10 Jan 2023 09:26:51 +0100
Subject: [PATCH] Bug 32603: Suggester category in Suggestions management

In Suggestions management, in the table displaying all suggestions, add
a column to display suggester category. This way, it is possible for
example for the librarian managing suggestions rather to prioritize
suggestions coming from teachers than those coming from students.

TEST :

1. Apply the patch.
2. Acquisition > Suggestions.
3. There is a new column 'Suggester category'. It can be
   displayed/hidden.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 admin/columns_settings.yml                                    | 2 ++
 .../intranet-tmpl/prog/en/modules/suggestion/suggestion.tt    | 4 ++++
 2 files changed, 6 insertions(+)

diff --git a/admin/columns_settings.yml b/admin/columns_settings.yml
index d4da6b08ab..38a5f19662 100644
--- a/admin/columns_settings.yml
+++ b/admin/columns_settings.yml
@@ -174,6 +174,8 @@ modules:
               columnname: suggestion
             -
               columnname: suggested_by
+            -
+              columnname: suggested_category
             -
               columnname: suggested_on
             -
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tt
index bfaef57f43..4bed26ce98 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tt
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/suggestion.tt
@@ -747,6 +747,7 @@
                                             <th class="NoSort noExport">&nbsp;</th>
                                             <th class="anti-the">Suggestion</th>
                                             <th>Suggested by</th>
+                                            <th>Suggester category</th>
                                             <th>Suggested on</th>
                                             <th>Patron reason</th>
                                             <th>Managed by</th>
@@ -808,6 +809,9 @@
                                                     [% SET suggester = s.suggester %]
                                                     <a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% suggester.borrowernumber | uri %]">[% suggester.surname | html %][% IF suggester.firstname %], [% suggester.firstname | html %][% END %] [% IF suggester.cardnumber %]([% suggester.cardnumber | html %])[% END %]</a>
                                                 </td>
+                                                <td>
+                                                    [% suggester.category.description | html %]
+                                                </td>
                                                 <td data-order="[% s.suggesteddate | html %]">
                                                     [% IF ( s.suggesteddate ) %][% s.suggesteddate | $KohaDates %][% END %]
                                                 </td>
-- 
2.39.5