[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

solene.ngamga at inlibro.com changed:

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

--- Comment #23 from solene.ngamga at inlibro.com ---
Created attachment 145221
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=145221&action=edit
Bug 23817: [Alternative patch] Normalize phone number only 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 "Primary phone"
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: Marius Mandrescu <marius.mandrescu at inLibro.com>
Signed-off-by: Solene Ngamga <solene.ngamga at inLibro.com>

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