From 2e51b7e5d9876834e6fbea27d766404148b519e4 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Thu, 22 Dec 2022 15:18:20 +0000
Subject: [PATCH] Bug 32517: lowercase category codes to avoid mismatch

To test:
1 - sudo koha-mysql kohadev
2 - UPDATE borrowers SET categorycode = LCASE(categorycode)
3 - Try to search for patrons:
    Uncaught TypeError: categories_map[data] is undefined
4 - Apply patch
5 - Search for patrons
6 - Success!

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc
index 6207756ac2..b4589b1201 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc
+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc
@@ -213,7 +213,7 @@
     [% END %]
     <script>
         let categories = [% To.json(categories) | $raw %].map(e => {
-            e['_id'] = e.categorycode;
+            e['_id'] = e.categorycode.toLowerCase();
             e['_str'] = e.description;
             return e;
         });
@@ -554,7 +554,7 @@
                                 "searchable": true,
                                 "orderable": true,
                                 "render": function( data, type, row, meta ) {
-                                    return escape_str(categories_map[data].description);
+                                    return escape_str(categories_map[data.toLowerCase()].description);
                                 }
                             }
                             [% CASE 'dateexpiry' %]
-- 
2.39.5