[Bug 25079] New: Show club enrollment question answers in staff client
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Bug ID: 25079 Summary: Show club enrollment question answers in staff client Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs@lists.koha-community.org Reporter: andrew@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org When a patron is enrolled in a patron club, koha collects answers to library-defined enrollment questions. Those answers go into the database but are not viewable outside of reports. Ideally we could see those answers on club-enrollments.pl and maybe also in the Clubs tab of moremember.pl. -- 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=25079 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kelly@bywatersolutions.com, | |kyle@bywatersolutions.com, | |nick@bywatersolutions.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #1 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- This report gets that data one might want. It's not a pretty or fun report: SELECT borrowernumber, surname, firstname, club_id, clubs.name, club_template_enrollment_fields.name, club_enrollment_fields.value FROM club_enrollment_fields LEFT JOIN club_enrollments on (club_enrollment_fields.club_enrollment_id=club_enrollments.id) LEFT JOIN borrowers using (borrowernumber) LEFT JOIN clubs on (club_enrollments.club_id=clubs.id) LEFT JOIN club_template_enrollment_fields on (club_enrollment_fields.club_template_enrollment_field_id=club_template_enrollment_fields.id) WHERE clubs.id=<<Club ID>> and club_enrollments.date_canceled is null -- 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=25079 --- Comment #2 from Hammat wele <hammat.wele@inlibro.com> --- Created attachment 149544 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149544&action=edit Bug 25079: Add a 'edit' functionality to the Clubs tool in the staff interface A club enrollment can be cancel but it can't be edited This patch add a 'edit' functionality to the Clubs tool in the staff interface Test plan 1. Create a club template 1.1. Go to Tools > Patron clubs 1.2. Click on 'New Club Template' 1.3. Fill the form 1.4. on the 'Club fields' section, Click on Add new field 1.5. Fill in the form 1.6. on the 'Enrollment fields' section, Click on Add new field 1.7. Fill in the form 1.8. Click on Save button 2. Creation of the club 2.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 2.2. Click on the 'New Club' button and select the club template create on step 1 2.3. Fill in the form 2.4. Click on Save button 3. Club enrollement On the intranet 3.1. Search for a pratron and open the patron folder 3.2. Click on the 'Clubs' tab 3.3. Find the name of the club and click on 'Enroll' 3.4. Fill the questionnaire 3.5. Confirm registration ---> Note that the enrollement can be canceled but it cannot be modified 4. Apply the patch 5. Click one more time on the 'Clubs' tab ---> Note that the enrollement can now be modified -- 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=25079 --- Comment #3 from Hammat wele <hammat.wele@inlibro.com> --- Created attachment 149545 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=149545&action=edit Bug 25079: Show club enrollment question answers in staff client When a patron is enrolled in a patron club, koha collects answers to library-defined enrollment questions. Those answers go into the database but are not viewable outside of reports. This patch make those answers viewable on club-enrollments.pl. Test plan 1. Apply the patch 2. Create a club template 2.1. Go to Tools > Patron clubs 2.2. Click on 'New Club Template' 2.3. Fill the form 2.4. on the 'Club fields' section, Click on Add new field 2.5. Fill in the form 2.6. on the 'Enrollment fields' section, Click on Add new field 2.7. Fill in the form 2.8. Click on Save button 3. Creation of the club 3.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 3.2. Click on the 'New Club' button and select the club template create on step 1 3.3. Fill in the form 3.4. Click on Save button 4. Club enrollement On the intranet (or the OPAC if permitted) 4.1. Search for a pratron and open the patron folder 4.2. Click on the 'Clubs' tab 4.3. Find the name of the club and click on 'Enroll' 4.4. Fill the questionnaire 4.5. Confirm registration 5. Check registrations on the intranet 5.1. Go to Tools > Patron clubs 5.2. In the bottom 'Clubs' section, find the name of the club 5.3. check the 'Enrolled patrons' column ---> should not be equal to zero. 5.4 Click on 'Action' and choose the option “Enrollments” ---> The Enrollment fields created on step 2.6. are viewable in the table with their values -- 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=25079 Hammat wele <hammat.wele@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |caroline.cyr-la-rose@inlibr | |o.com, | |hammat.wele@inlibro.com, | |philippe.blouin@inlibro.com Assignee|koha-bugs@lists.koha-commun |hammat.wele@inlibro.com |ity.org | -- 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=25079 Hammat wele <hammat.wele@inlibro.com> 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=25079 Sam Lau <samalau@gmail.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=25079 Sam Lau <samalau@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #149544|0 |1 is obsolete| | --- Comment #4 from Sam Lau <samalau@gmail.com> --- Created attachment 151603 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151603&action=edit Bug 25079: Add a 'edit' functionality to the Clubs tool in the staff interface A club enrollment can be cancel but it can't be edited This patch add a 'edit' functionality to the Clubs tool in the staff interface Test plan 1. Create a club template 1.1. Go to Tools > Patron clubs 1.2. Click on 'New Club Template' 1.3. Fill the form 1.4. on the 'Club fields' section, Click on Add new field 1.5. Fill in the form 1.6. on the 'Enrollment fields' section, Click on Add new field 1.7. Fill in the form 1.8. Click on Save button 2. Creation of the club 2.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 2.2. Click on the 'New Club' button and select the club template create on step 1 2.3. Fill in the form 2.4. Click on Save button 3. Club enrollement On the intranet 3.1. Search for a pratron and open the patron folder 3.2. Click on the 'Clubs' tab 3.3. Find the name of the club and click on 'Enroll' 3.4. Fill the questionnaire 3.5. Confirm registration ---> Note that the enrollement can be canceled but it cannot be modified 4. Apply the patch 5. Click one more time on the 'Clubs' tab ---> Note that the enrollement can now be modified Signed-off-by: Sam Lau <samalau@gmail.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Sam Lau <samalau@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #149545|0 |1 is obsolete| | --- Comment #5 from Sam Lau <samalau@gmail.com> --- Created attachment 151604 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151604&action=edit Bug 25079: Show club enrollment question answers in staff client When a patron is enrolled in a patron club, koha collects answers to library-defined enrollment questions. Those answers go into the database but are not viewable outside of reports. This patch make those answers viewable on club-enrollments.pl. Test plan 1. Apply the patch 2. Create a club template 2.1. Go to Tools > Patron clubs 2.2. Click on 'New Club Template' 2.3. Fill the form 2.4. on the 'Club fields' section, Click on Add new field 2.5. Fill in the form 2.6. on the 'Enrollment fields' section, Click on Add new field 2.7. Fill in the form 2.8. Click on Save button 3. Creation of the club 3.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 3.2. Click on the 'New Club' button and select the club template create on step 1 3.3. Fill in the form 3.4. Click on Save button 4. Club enrollement On the intranet (or the OPAC if permitted) 4.1. Search for a pratron and open the patron folder 4.2. Click on the 'Clubs' tab 4.3. Find the name of the club and click on 'Enroll' 4.4. Fill the questionnaire 4.5. Confirm registration 5. Check registrations on the intranet 5.1. Go to Tools > Patron clubs 5.2. In the bottom 'Clubs' section, find the name of the club 5.3. check the 'Enrolled patrons' column ---> should not be equal to zero. 5.4 Click on 'Action' and choose the option “Enrollments” ---> The Enrollment fields created on step 2.6. are viewable in the table with their values Signed-off-by: Sam Lau <samalau@gmail.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Show club enrollment |Show club enrollment |question answers in staff |question answers in staff |client |interface -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #151603|0 |1 is obsolete| | Attachment #151604|0 |1 is obsolete| | --- Comment #6 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 151818 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151818&action=edit Bug 25079: Add a 'edit' functionality to the Clubs tool in the staff interface A club enrollment can be cancel but it can't be edited This patch add a 'edit' functionality to the Clubs tool in the staff interface Test plan 1. Create a club template 1.1. Go to Tools > Patron clubs 1.2. Click on 'New Club Template' 1.3. Fill the form 1.4. on the 'Club fields' section, Click on Add new field 1.5. Fill in the form 1.6. on the 'Enrollment fields' section, Click on Add new field 1.7. Fill in the form 1.8. Click on Save button 2. Creation of the club 2.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 2.2. Click on the 'New Club' button and select the club template create on step 1 2.3. Fill in the form 2.4. Click on Save button 3. Club enrollement On the intranet 3.1. Search for a pratron and open the patron folder 3.2. Click on the 'Clubs' tab 3.3. Find the name of the club and click on 'Enroll' 3.4. Fill the questionnaire 3.5. Confirm registration ---> Note that the enrollement can be canceled but it cannot be modified 4. Apply the patch 5. Click one more time on the 'Clubs' tab ---> Note that the enrollement can now be modified Signed-off-by: Sam Lau <samalau@gmail.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #7 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 151819 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151819&action=edit Bug 25079: Show club enrollment question answers in staff client When a patron is enrolled in a patron club, koha collects answers to library-defined enrollment questions. Those answers go into the database but are not viewable outside of reports. This patch make those answers viewable on club-enrollments.pl. Test plan 1. Apply the patch 2. Create a club template 2.1. Go to Tools > Patron clubs 2.2. Click on 'New Club Template' 2.3. Fill the form 2.4. on the 'Club fields' section, Click on Add new field 2.5. Fill in the form 2.6. on the 'Enrollment fields' section, Click on Add new field 2.7. Fill in the form 2.8. Click on Save button 3. Creation of the club 3.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 3.2. Click on the 'New Club' button and select the club template create on step 1 3.3. Fill in the form 3.4. Click on Save button 4. Club enrollement On the intranet (or the OPAC if permitted) 4.1. Search for a pratron and open the patron folder 4.2. Click on the 'Clubs' tab 4.3. Find the name of the club and click on 'Enroll' 4.4. Fill the questionnaire 4.5. Confirm registration 5. Check registrations on the intranet 5.1. Go to Tools > Patron clubs 5.2. In the bottom 'Clubs' section, find the name of the club 5.3. check the 'Enrolled patrons' column ---> should not be equal to zero. 5.4 Click on 'Action' and choose the option “Enrollments” ---> The Enrollment fields created on step 2.6. are viewable in the table with their values Signed-off-by: Sam Lau <samalau@gmail.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #8 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 151820 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=151820&action=edit Bug 25079: (QA follow-up) Fix TT issues Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Hammat wele <hammat.wele@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #151818|0 |1 is obsolete| | --- Comment #9 from Hammat wele <hammat.wele@inlibro.com> --- Created attachment 152496 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152496&action=edit Bug 25079: Add a 'edit' functionality to the Clubs tool in the staff interface A club enrollment can be cancel but it can't be edited This patch add a 'edit' functionality to the Clubs tool in the staff interface Test plan 1. Create a club template 1.1. Go to Tools > Patron clubs 1.2. Click on 'New Club Template' 1.3. Fill the form 1.4. on the 'Club fields' section, Click on Add new field 1.5. Fill in the form 1.6. on the 'Enrollment fields' section, Click on Add new field 1.7. Fill in the form 1.8. Click on Save button 2. Creation of the club 2.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 2.2. Click on the 'New Club' button and select the club template create on step 1 2.3. Fill in the form 2.4. Click on Save button 3. Club enrollement On the intranet 3.1. Search for a pratron and open the patron folder 3.2. Click on the 'Clubs' tab 3.3. Find the name of the club and click on 'Enroll' 3.4. Fill the questionnaire 3.5. Confirm registration ---> Note that the enrollement can be canceled but it cannot be modified 4. Apply the patch 5. Click one more time on the 'Clubs' tab ---> Note that the enrollement can now be modified Signed-off-by: Sam Lau <samalau@gmail.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Hammat wele <hammat.wele@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #151819|0 |1 is obsolete| | --- Comment #10 from Hammat wele <hammat.wele@inlibro.com> --- Created attachment 152497 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152497&action=edit Bug 25079: Show club enrollment question answers in staff client When a patron is enrolled in a patron club, koha collects answers to library-defined enrollment questions. Those answers go into the database but are not viewable outside of reports. This patch make those answers viewable on club-enrollments.pl. Test plan 1. Apply the patch 2. Create a club template 2.1. Go to Tools > Patron clubs 2.2. Click on 'New Club Template' 2.3. Fill the form 2.4. on the 'Club fields' section, Click on Add new field 2.5. Fill in the form 2.6. on the 'Enrollment fields' section, Click on Add new field 2.7. Fill in the form 2.8. Click on Save button 3. Creation of the club 3.1. Go to Tools > Patron clubs > 'Clubs' section (bottom) 3.2. Click on the 'New Club' button and select the club template create on step 1 3.3. Fill in the form 3.4. Click on Save button 4. Club enrollement On the intranet (or the OPAC if permitted) 4.1. Search for a pratron and open the patron folder 4.2. Click on the 'Clubs' tab 4.3. Find the name of the club and click on 'Enroll' 4.4. Fill the questionnaire 4.5. Confirm registration 5. Check registrations on the intranet 5.1. Go to Tools > Patron clubs 5.2. In the bottom 'Clubs' section, find the name of the club 5.3. check the 'Enrolled patrons' column ---> should not be equal to zero. 5.4 Click on 'Action' and choose the option “Enrollments” ---> The Enrollment fields created on step 2.6. are viewable in the table with their values Signed-off-by: Sam Lau <samalau@gmail.com> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Hammat wele <hammat.wele@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #151820|0 |1 is obsolete| | --- Comment #11 from Hammat wele <hammat.wele@inlibro.com> --- Created attachment 152498 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=152498&action=edit Bug 25079: (QA follow-up) Fix TT issues Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #12 from Hammat wele <hammat.wele@inlibro.com> --- Rebase -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)| |23.11.00 released in| | Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #13 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Pushed to master for 23.11. Nice work everyone, thanks! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 --- Comment #14 from Andrew Fuerste-Henry <andrewfh@dubcolib.org> --- *** Bug 31997 has been marked as a duplicate of this bug. *** -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |Needs documenting CC| |martin.renvoize@ptfs-europe | |.com --- Comment #15 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Enhancement won't be backported to 23.05.x series -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25079 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Documentation| |https://gitlab.com/koha-com submission| |munity/koha-manual/-/merge_ | |requests/775 Documentation| |Caroline Cyr La Rose contact| | Status|Needs documenting |RESOLVED -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org