Bug 24959

Summary: Fix id/label pairs in saved reports table
Product: Koha Reporter: Owen Leonard <oleonard>
Component: ReportsAssignee: Owen Leonard <oleonard>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: trivial    
Priority: P5 - low CC: 1joynelson, bgkriegel
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
20.05.00
Bug Depends on: 24886    
Bug Blocks:    
Attachments: Bug 24959: Fix id/label pairs in saved reports table
Bug 24959: Fix id/label pairs in saved reports table
Bug 24541: Purge old messages
Bug 24959: Fix id/label pairs in saved reports table

Description Owen Leonard 2020-03-23 20:04:53 UTC
In the table of saved reports the number in the 'ID' column is wrapped in a <label> tag, but clicking it doesn't check the corresponding checkbox because the "for" attribute doesn't match the ID of the checkbox.
Comment 1 Owen Leonard 2020-03-23 20:15:24 UTC
Created attachment 101495 [details] [review]
Bug 24959: Fix id/label pairs in saved reports table

This patch adds a unique id attribute to each checkbox in the table of
saved reports. Also updated is the corresponding <label>'s "for"
attribute so that clicking the report id will toggle the checkbox.

To reproduce, go to Reports -> Use saved and click a number in the ID
column. Nothing happens.

After applying the patch clicking the number should check or uncheck the
corresponding checkbox.
Comment 2 Bernardo Gonzalez Kriegel 2020-03-24 11:04:31 UTC
Created attachment 101538 [details] [review]
Bug 24959: Fix id/label pairs in saved reports table

This patch adds a unique id attribute to each checkbox in the table of
saved reports. Also updated is the corresponding <label>'s "for"
attribute so that clicking the report id will toggle the checkbox.

To reproduce, go to Reports -> Use saved and click a number in the ID
column. Nothing happens.

After applying the patch clicking the number should check or uncheck the
corresponding checkbox.

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Works Ok, no errors.
Comment 3 Bernardo Gonzalez Kriegel 2020-03-24 11:18:44 UTC
Created attachment 101540 [details] [review]
Bug 24541: Purge old messages

misc/cronjobs/cleanup_database.pl provides some database cleanup.

This patch adds cleanup for messages table.

Test plan :
- Count messages : select count(*),date(message_date) from  messages group by date(message_date);
- Run cleanup : misc/cronjobs/cleanup_database.pl -v --messages 365
- Recount messages

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Works Ok, no errors.
Comment 4 Bernardo Gonzalez Kriegel 2020-03-24 11:19:51 UTC
Comment on attachment 101540 [details] [review]
Bug 24541: Purge old messages

Sorry, wrong bug
Comment 5 Katrin Fischer 2020-03-25 20:23:05 UTC
Created attachment 101767 [details] [review]
Bug 24959: Fix id/label pairs in saved reports table

This patch adds a unique id attribute to each checkbox in the table of
saved reports. Also updated is the corresponding <label>'s "for"
attribute so that clicking the report id will toggle the checkbox.

To reproduce, go to Reports -> Use saved and click a number in the ID
column. Nothing happens.

After applying the patch clicking the number should check or uncheck the
corresponding checkbox.

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Works Ok, no errors.

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
Comment 6 Martin Renvoize 2020-03-26 11:40:39 UTC
Nice work everyone!

Pushed to master for 20.05
Comment 7 Joy Nelson 2020-04-03 22:26:56 UTC
not backported due to dependencies