Jethro 2.34.0

This release resolves a long list of bugs and adds a number of small but useful features.

Enhancements

• #834 - You can now control whether each congregation is a container for persons, attendance, services, all of the above, or none of the above.
• #846 - You can now quickly SMS all assignees in a roster view
• #874 - Planned absences are now displayed when recording, displaying or reporting on attendance
• #907 - You can now set the default status for notes to be something other than 'no action required'
• #920 - When changing the status of a note from 'action required' to something else, it's now compulsory to enter a comment so there is a historical record.
• #704 - When marking attendance, a count of the number of persons marked present is now shown next to the headcount box
• #895 - When you select a roster view, your selection now persists next time you return to that page.
• #898 - If you paste an email address beginning with "mailto:", Jethro quietly strips the prefix.
• #799 - It's now easier to copy the ical URL to paste into your calendar app
• #899 - Explanation about how attendance percentages work has been extended
• #696 - In person notes/comments, URLs are now displayed as links
• #875 - Better access to roster role descriptions via the edit-roster-roles page
• #922 - When hovering over a name on a roster, other instances of that person are highlighted.
• #829 - In the personnel list above a run sheet, roles with nobody assigned are no longer shown
• #918 - When run sheet components (eg songs) are shown in a roster column, you can now click on them to see component details such as comments and CCLI number.
• #523 - When entering BIble readings, you can now enter 2-part split readings such as Matt 22:1-3, 7-8 or Matt 2:28-3:2, 5-6.
• #885 - Contact list DOCX export now avoids splitting families across page breaks
• #888 - SMS log file now includes character count, is now more detailed and in jsonlines format
• #801 - This Sunday is now highlighted in the service schedule
• #880 - Layout in the run sheet editor has been enhanced
• #732 - Styling of service details in rosters has been improved
• #876 - iCal feeds can now be enabled even if the rest of the public area is disabled, thanks to a new setting.
• In the personnel list above a run sheet, role titles are now linked to role descriptions.
• When viewing a roster role description, there is a now link to edit it
• In the top nav, the user's name is now a link to their person record
• Password strength is now checked at login, and the user is prompted to change to a stronger password if necessary.
• Mobile phone numbers can now be copied more easily
• Document merge can now be run against reports and attendance, and can display all available merge keywords before merging.

Bugfixes

• #883 - Congregations are sorted by meeting_time (time code) more consistently
• #4 - The situation where a group used for account restrictions has been archived is now better handled
• #78 - The situation where somebody tries to create several services on the same date for the same congregation is now better handled.
• #882 - fix to the email-report script
• #870 - cope better with mailchimp API's error reports
• #877 - user accounts restricted to a certain congregation could also see persons with blank congregation, now fixed
• #894 - spelling fix
• #901 - Jethro warns more clearly when a file upload is too big to handle
• #831 - planned absences are now factored in when choosing 'other' option in rosters.
• #649 - better handling of long custom field values
• #905 - fix PHP8 strict-mode error when displaying service component
• #903 - fix PHP8 strict-mode error when importing
• #921 - planned absences were sometimes missing on the final row when editing a roster. Now fixed.
• #363 - fixed error deleting group in some circumstances
• #923 - fixed error when deleting the only tag in service component tag manager
• #842 - you can no longer delete a group that is in use as the volunteer group for a roster role
• #927 - fixed error when removing the CCLI number from a service component
• #841 - after running an ad hoc report you couldn't save it, now fixed.
• When sending an SMS, "save as note" option is no longer shown if the SMS_SAVE_TO_NOTE_SUBJECT setting is blank
• #810 - pressing enter when editing a run sheet no longer submits the form
• #341 - prevent errors when saving a run sheet in some circumstances
• #928 - allow more characters in roster role titles that still work in run sheet keywords such as %Bible_reader_#1%
• #834 - prevent the deletion of a congregation with services attached. Instead, provide a way to 'retire' congregations from such duties.
• #931 - reports on home page are now ordered by name.
• #944 - Australia post postcode link has been updated (fixed during RC process)
• #942 - background colour fixed when dragging a run sheet item (fixed during RC process)
• #940 - dirty data was hindering the 2.34.0 upgrade (fixed during RC process)
• #933 - extraneous highlighting on rosters has been fixed (fixed during RC process)

Other

• Support for 'legacy format' document merge templates (from v2.27 or earlier) has been disabled by default. It can be re-enabled by adding to the conf.php file define('MAIL_MERGE_INCLUDE_LEGACY', true);

Upgrade Procedure

1. Log out of Jethro
2. Take a backup of your mysql database
3. Apply all applicable upgrade SQL files from the upgrades folder to your mysql database, including upgrades/2023-upgrade-to-2.34.sql
4. Move away your old Jethro files (eg. rename your jethro folder to jethro_old)
5. Unzip the new files into the right place (don't just overwrite the old files)
6. Move your old conf.php and files/ subdirectory (if not empty) back into your jethro folder.
   1 Compare your old conf.php to a new conf.php.sample.* file and add any new settings to your conf.php
7. Log in and test.

Credits

Thanks to @tim-pearce for document merge contributions, @jefft for contact list format fix, upgrade SQL fix and various other diagnoses and fixes, @s4069b for updated postcode link and contribution to service component details display in rosters.