[Koha-bugs] [Bug 23817] Normalize phone number when searching patrons

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23817

Emily Lamancusa <emily.lamancusa at montgomerycountymd.gov> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
 Attachment #151961|0                           |1
        is obsolete|                            |

--- Comment #27 from Emily Lamancusa <emily.lamancusa at montgomerycountymd.gov> ---
Created attachment 152450
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152450&action=edit
Bug 23817: Normalize phone number when searching

This patch rewrites the phone number DBIC query when sent from DataTables
like in the Patron module.

Test plan:
0. Apply patch and koha-plack --restart kohadev
1. Go to
http://localhost:8081/cgi-bin/koha/members/memberentry.pl?op=modify&destination=circ&borrowernumber=51
2. Input '1-(234)-567-8901' into the 'Primary phone' field
3. Note on the next screen the phone number is shown as '1-(234)-567-8901'
4. Go to http://localhost:8081/cgi-bin/koha/members/members-home.pl
5. Choose "Search field" of "All phones"
6. Search for '12345678901'
7. Note you are taken to
http://localhost:8081/cgi-bin/koha/members/moremember.pl?borrowernumber=51
8. Try out different permutations like '234 567 8901' or '5678901'
9. Note that every permutation works to find the borrower

Signed-off-by: Emily Lamancusa <emily.lamancusa at montgomerycountymd.gov>

-- 
You are receiving this mail because:
You are watching all bug changes.