[Bug 23224] New: Inconsistent behaviour between memberentry.pl and the update-member.pl when updating child patron to Adult
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Bug ID: 23224 Summary: Inconsistent behaviour between memberentry.pl and the update-member.pl when updating child patron to Adult Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: alexbuckley@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Target Milestone: --- There are two ways you can update a child patron to a Adult/Staff/Professional/Organisation patron category. These are using: * child-update.pl * memberentry.pl - Behaviour of child-update.pl: Currently when you click on the 'Update child to adult patron' dropdown option on the members/moremember.pl page the update-child.pl window appears. After selecting and submitting that form the guarantorid value for the borrower is set to 0. - Behaviour of memberentry.pl: When using the 'Edit' option which loads the memberentry.pl when you change the borrowers category from Child to a Adult/Staff/Professional/Organisation categorycode and then submit the guarantorid is not altered (not set to 0) and is displayed on the patrons summary page as guarantor. What is the problem? This is inconsistent behavior, memberentry.pl should set the guarantorid value to 0 when you update the borrowers categorycode to an Adult/Staff/Professional/Organisation patron categorycode, so it behaves the same as child-update.pl Currently Koha master does not allow adults to have a guarantor (until the patches on Bug 12446 - https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12446) are pushed to master, and so this bug letting non-child patron categories having a guarantor should be fixed. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |alexbuckley@catalyst.net.nz |ity.org | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hayleymapley@catalyst.net.n | |z -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 --- Comment #1 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Created attachment 91038 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91038&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now 0 Sponsored-By: Brimbank Library, Australia -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|alexbuckley@catalyst.net.nz |hayleymapley@catalyst.net.n | |z -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91038|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 --- Comment #2 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Created attachment 91041 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91041&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty Sponsored-By: Brimbank Library, Australia -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91041|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 --- Comment #3 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Created attachment 91042 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91042&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty Sponsored-By: Brimbank Library, Australia -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91042|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 --- Comment #4 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Created attachment 91043 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91043&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child/non-professional patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child/non-professional patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty ---- Confirm the guarantorid is not removed when editing a patrons category to a patron category with the category type of 'professional' as in Koha professional patron categories can have guarantors 11. Repeat steps 1-3 and select 'Edit' on the childs record and change the patron category to a 'professional' patron category and then save 12. Check the database and confirm that the guarantorid is unchanged Sponsored-By: Brimbank Library, Australia -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 --- Comment #5 from Alex Buckley <alexbuckley@catalyst.net.nz> --- Made a change to the patch so if you change from a 'child' to 'professional' patron category in memberentry.pl the guarantorid is not removed as Koha currently lets patron categories with the category type of 'professional' also have a guarantor. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Inconsistent behaviour |Inconsistent behaviour |between memberentry.pl and |between memberentry.pl and |the update-member.pl when |the update-child.pl when |updating child patron to |updating child patron to |Adult |Adult -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Liz Rea (ByWater) <liz@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Liz Rea (ByWater) <liz@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91043|0 |1 is obsolete| | --- Comment #6 from Liz Rea (ByWater) <liz@bywatersolutions.com> --- Created attachment 91109 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91109&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child/non-professional patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child/non-professional patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty ---- Confirm the guarantorid is not removed when editing a patrons category to a patron category with the category type of 'professional' as in Koha professional patron categories can have guarantors 11. Repeat steps 1-3 and select 'Edit' on the childs record and change the patron category to a 'professional' patron category and then save 12. Check the database and confirm that the guarantorid is unchanged Sponsored-By: Brimbank Library, Australia Signed-off-by: John Doe <you@example.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Liz Rea <wizzyrea@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wizzyrea@gmail.com --- Comment #7 from Liz Rea <wizzyrea@gmail.com> --- oh ffs. Let me fix that signoff line. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Liz Rea (ByWater) <liz@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91109|0 |1 is obsolete| | --- Comment #8 from Liz Rea (ByWater) <liz@bywatersolutions.com> --- Created attachment 91110 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91110&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child/non-professional patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child/non-professional patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty ---- Confirm the guarantorid is not removed when editing a patrons category to a patron category with the category type of 'professional' as in Koha professional patron categories can have guarantors 11. Repeat steps 1-3 and select 'Edit' on the childs record and change the patron category to a 'professional' patron category and then save 12. Check the database and confirm that the guarantorid is unchanged Sponsored-By: Brimbank Library, Australia Signed-off-by: Liz Rea <liz@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Sally Healey <sally.healey@cheshiresharedservices.gov.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |sally.healey@cheshireshared | |services.gov.uk -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Nadine Pierre <nadine.pierre@InLibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #91110|0 |1 is obsolete| | --- Comment #9 from Nadine Pierre <nadine.pierre@InLibro.com> --- Created attachment 91115 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91115&action=edit Bug 23224: Fix inconsistent behaviour of memberentry.pl When editing a child patron (in memberentry.pl) and changing their patron category to a non-child patron category Koha does not set the guarantorid to 0. This means we end up with non-child/non-professional patrons with guarantors, which is currently not allowed by Koha. Whereas the behaviour in child-update.pl (which can be accessed from a patrons summary page by clicking 'More'->Update child to adult patron') sets the borrowers guarantorid value to 0. This is the correct behaiviour and is what memberentry.pl should be doing. This patch fixes that. Test plan: See how memberentry.pl currently behaves 1. Create a adult patron and select 'Add child' and create the child record. 2. Enter the Koha MySQL terminal and select the guarantorid value for the child record you just created: SELECT guarantorid FROM borrowers WHERE userid=<username>; 3. Notice the guarantorid is set to the adult patrons borrowernumber 4. On the child record select 'Edit' and in the memberentry.pl page change the category to any non-child/non-professional patron category (for example 'Patron') and save 5. Repeat step 2 and notice the guarantorid value has not changed ---- See how child-update.pl currently behaves 6. Repeat steps 1-3 and on the child record select More > Update child to adult patron 7. In the child-update.pl window that loads select any patron category and save 8. Repeat step 2 and notice the guarantorid is now 0 ---- See how the patch fixes the behaviour of memberentry.pl 9. Apply patch 10. Repeat steps 1-5 and notice the guarantorid is now empty ---- Confirm the guarantorid is not removed when editing a patrons category to a patron category with the category type of 'professional' as in Koha professional patron categories can have guarantors 11. Repeat steps 1-3 and select 'Edit' on the childs record and change the patron category to a 'professional' patron category and then save 12. Check the database and confirm that the guarantorid is unchanged Sponsored-By: Brimbank Library, Australia Signed-off-by: Liz Rea <liz@bywatersolutions.com> Signed-off-by: Nadine Pierre <nadine.pierre@inLibro.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Alex Buckley <alexbuckley@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |12949 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12949 [Bug 12949] changing child to adult doesn't remove link to guarantor -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de Status|Signed Off |Failed QA --- Comment #10 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I am sorry, but I've managed to make this explode :( 1) Searched for a child patron 2) Added a guarantor 3) Edit patron 4) Switch patron category to "Patron" (Adult) 5) No property guarantorid for Koha::Patron at /usr/share/perl5/Exception/Class/Base.pm line 88 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23224 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |RESOLVED Resolution|--- |FIXED CC| |aleisha@catalyst.net.nz --- Comment #11 from Aleisha Amohia <aleisha@catalyst.net.nz> --- I believe this patch is no longer required - in master, guarantors and guarantees are stored in borrower_relationships in the database. the relationship information is deleted when changing from child patron to adult patron using memberentry.pl and child-update.pl. Closing bug report -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org