Cemetery Burials Table

Cemetery Burials Table
Cemetery Burials Table
Summary	This mod changes the All Burials table for a cemetery, adds birth, death, and spouse data, and removes the burial place name and the personID.
Validation
Mod Updated	21 Nov2023
	TNG 14.0
Download stats
Author(s)	Robin Richmond
Homepage	Robin's Roots'
Mod Support	My Mod Support form
Contact Developer	My Mod Support form
Latest Mod	v14.0.0.17g
Min TNG V	11.0
Max TNG V	14.0.3
Files modified	showmap.php, admin_genconfig.php, admin_updateconfig.php
Related Mods	Cemetery Headstones, Cemetery Map And Images; depends on Mod Settings Blocks
Notes	Has Dutch & Norwegian translations

Purpose of the Mod

To improve the usability of the "All Burials" results tables in showmap.php (which is essentially the TNG "Cemetery Detail" page).

The following columns have been added:
1. Birth date and place
2. Death date and place, and
3. Spouses - The Spouses column is added because women's maiden names are often omitted from headstones and cemetery lists.
4. A flag indicating that the person has a headstone photo. The headstone photo column is removed if no one in the cemetery has a headstone photo.
The burial date column is no longer displayed if it contains no data.
The PersonID and Burial place columns have been removed, and the Burial Place, which the native program placed on every row in the All Burials Table, is now shown just once in a heading above the table.

Mod Options

This mod can abbreviate place names in order to reduce wrapping in the All Burials table. (See a visualization below.) But not all users appreciate the abbreviations, so the mod has two options:
1. Initial Format of Placenames - Abbreviated or Full
2. Allow user to switch between abbreviated and full placenames. This option controls the presence of a button that says "Abbreviated Placenames" or "Full Placenames"
To conserve horizontal space in the modified All Burials table, two options affect the visibility of the Birthplace column:
1. Initial Visibility of Birthplaces
2. Allow user to change the visibility of Birthplaces (which puts a "Show Places" or "Hide Places" button in the Birth column of the results table./li>

The mod options are in a Mod Settings Block at Admin >> Setup >> General Settings, in a new subform titled "Mod Settings Blocks". (See a visualization below.)

Other Mods

Related Mods

Cemetery Map And Images was spun off from Cemetery Burials Table v16 to remove a conflict between this mod and Public Access Control. The features that were moved to Cemetery Map and Images do not affect the showmap.php All Burials table.
Cemetery Headstones also affects showmap.php, as well as headstones.php. It controls the visibility of the Headstone Photos table that is displayed immediately above the All Burials table. It allows the Headstone Photos table to be hidden (with or without a button that displays it) or displayed (with or without a button that hides it).
Showmap Burials is related only in the sense that it has the same purpose and some of the same functionality. It is listed below among conflicting mods.
The Mod Settings Blocks mod packages this mod's options into what I call a "Mod Settings Block", which is a set of form fields that formatted and labeled so that it stands out among other options in an Admin>>Setting form. Mod Settings Blocks is a prerequisite for this mod; it must be installed before this mod can be installed.

Compatibility

This mod is compatible with Public Access Control, Mobile Site Enhancements, Tree ID Mod, and TreeID-One Column.
This mod conflicts with Showmap Burials, which was also inspired largely by the redundant Burial Place column in showmap.php, but which doesn't add as much new information as Cemetery Burial Table does. There's no realistic resolution for this conflict.

Installation

This mod includes a typical mod subfolder, with the same base name as the mod's .cfg file. The subfolder is atypical in that no files in it are installed to working TNG folders. However, it does contain critical files that contain the mod's language strings, which the mod does not add to standard cust_text.php files. Instead, the PHP code modified by this mod loads the language strings from files in the mod's languages/ subfolder. Read more about this technique.

[Show Installation Details]

Requirements

A working TNG installation.
An installed current version of the Mod Manager.
You should backup files listed in the panel on the right.

Procedure

Remove and delete previous version of this mod.
Backup the files updated by this mod. They are listed in the panel at the upper right.
Download the .zip file, Extract its .cfg file to the mods folder.
Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files.

Problems?

Try using the Mod Manager Remove capability
Contact me through My Mod Support form.

[Hide Details]

Visualizations

The All Burials tables in showmap.php, Before installation Two columns are removed by this mod: The cemetery name, which is repeated on every row in the table. The PersonID. With the new columns that the mod adds to the table, the PersonID seemed sufficiently unimportant that it has been removed.
The modified All Burials Table This screenshot shows selected table rows to illustrate new features. With the elimination of the cemetery name column, the cemetery name is now in the heading above the table. The optional "Abbreviated Placenames" button conserves vertical space by abbreviating the placenames. There is a new column that marks burials for which there is a headstone. This column is omitted when are no headstones for this cemetery. The birth and death dates and places have been added. The Burial Date is omitted in this case because it contained no data. The Tree column is now suppressed if the user has selected a specific tree, or if the database contains only one tree.
The modified All Burials Table, showing abbreviated placenames The abbreviations reduce line-wrapping, and allow more people to be listed "above the fold" on the web page. But if you don't like the abbreviations, options can remove them and the "Full placenames" button.tains only one tree.
The showmap.php Inner Mod Menu showmap.php is changed by Cemetery Headstones and Cemetery Map and Images as well as Cemetery Burials Table, so the Inner Mod Menu lists all three mods. The screenshot shows the popup box that is generated by clicking on the "What has changed" link below "Cemetery Map and Images" The "Mod Information" link and the Inner Mod Menu are visible only to site administrators. This list of changes is very similar to the "Purpose of the mod" section of this article, but is presented here in the page where the mod's effects are also visible.
The Cemetery Burials Table Mod Settings Block A Mod Settings Block is an outlined subform within an Admin>>Setup program that contains the options for a single mod. What is most notable about a Mod Settings Block is that a hyperlink directly to a Mod Settings Block displays only that block (i.e. only one mod's options), not all of the other options in the form or subform. Here, you see the this mod's Mod Settings Block, in admin_genconfig.php, at Admin>>Setup>>General Settings. The triangular arrow next to the subfolder heading Mod Settings Blocks is pointing to the right, meaning that the subform is not open, and that your site's other mod settings blocks are not visible. If you were to open the subform by clicking on the heading, you would see the mod settings blocks for other mods that you have installed.

Language Strings

This mod stores its language strings (for all languages) in the languages folder within the mods subfolder, in files named {language}_custtext.php (e.g English_custtest.php, French_UTF8-custtext.php). There is typically no need for separate file for English-UTF8.

This technique for storing custom text files has several advantages, including that translators can create, test, and edit language files without having to uninstall and reinstall the mod.

Specifying site-specific overrides to language strings is not as straightforward as it is with conventional cust_text.php files. Read about the problem and the solution.

Revision History

Mod Version	TNG Version	Date	Note
v14.0.0.17g	14	21 Nov 2023	Update version v14.0.0.17f to v14.0.0.17g
v14.0.0.17f	14	23 Sep 2023	No functional changes; Implemented MM Logic to display notes about whether certain mods are installed. Updated for TNGv14.
v13.0.0.17c	13.0-13.0.3	30 Mar 2021	No notable functional changes Added the ability to hide the birthplace column to reduce the width of the results table, and mod options to control that feature. Internally, changed some PHP code to JQuery so that hiding and showing data works better.
v13.0.0.17b.zip	13	02 Nov 2020	Cleaned up an undefined subscript reference that wasn't breaking the program.
v13.0.0.17a.zip	13	26 Oct 2020	Spun off Cemetery Map And Image Removed the awkward "Burials at the cemetery's Associated Place" message, and replaced with "Burals at {cemetery name}" Applied the effects of the mod options, which were being ignored. Made the Dutch language strings visible.
v13.0.0.16.zip	13	6 Oct 2020	Added placename abbreviations and the associated buttons and mod options
v12.0.0.15c.zip	12.0+	15 May 2018	No functional changes; made compatible with TNGv12.
v11.0.0.15b	11.0-11.1.2+	20 Dec 2017	No visible changes. Removed a phantom line in the .cfg file that must have been an extra cr or lf, and caused a bad target error after installation on some sites.

[Older Revisions]

Older Revisions

[Hide]

Mod Version	TNG Version	Date	Note
v14.0.0.17g	14	21 Nov 2023	Update version v14.0.0.17f to v14.0.0.17g
14.0.0.17e	rrcbt	13 Mar 2023	Upgrade to TNGv14
11.0.0.15a	11.0+	20 Dec 2017	One visible change: A new column of headstone markers in the All Burials table that indicate which people have headstone photos. Two bug/glitch fixes: - Fixed a bug in the spouse logic in the All Burials table that occurred when no tree is selected and multiple trees exist, and the same person ID appears in two trees. - Realized that there was potential confusion when the cemetery name&location didn't match the associated placename, so I changed the All Burials heading. Plus some code cleanup.
11.0.0.14a	11.0+	3 Jul 2017	The Display Mod Names mod is no longer referenced at all, since showmap.php is an end-user program (though it can be invoked from the Admin side.)
11.0.0.14	11.0+	30 May 2017	Moved the changes to Headstones.php out of this mod to the new Headstones Report mod. This mod now focuses on the All Burials table in showmap.php, and Headstones Report focuses on the Headstone Photos tables in headstones.php and showmap.php. (Those two headstones tables are essentially identical.
11.0.0.13a	11.0 & 11.0.1	27 May 2016	Added the %fileoptional:% directive to the Norwegian language files.
11.0.0.13	11.0 & 11.0.1	26 May 2016	Several modifications: Accommodates the tablesaw specifications in TNGv11 Changes the layout of the list of cemeteries in headstones.php. Cemeteries with headstones are now in a titlebox, and all cemetery pins in the list are cut off so that there is not too much whitespace. Added "Matches x though y of z" like many other list programs. Added bold text and more info to the message in showmap.php about a missing value for the Cemetery place. The mod is no longer compatible with Headstones-No Headstones, which may be completely obsolete now.
10.1.0.12 & 9.2.0.12	9.2.0-10.1.3	27 Feb 2016	The burial date column is omitted if it contains no data. Removed a cust_text string that was not necessary, and added one that had been hard-coded. Added Norwegian translations. Added Show Mod Names functionality and dependency.
10.1.0.11a	10.1.0-10.1.2	19 Jul 2015	Tweaked search locations to accommodate the TNG v10.1.2 beta.
10.1.0.11 & 9.2.0.11	9.2.0 - 10.1.1	17 Apr 2015	Found an untranslated string; added Dutch translations by Marco van den heuvel
10.1.0.10 & 9.2.0.10	9.2.0 - 10.1.1	12 Apr 2015	Fixed bug where my modification to headstones.php tried to count burials in the people table when the cemetery didn't link to a place name.
10.1.0.8	10.1	11 Jan 2015	Fixed database references for TNG v10.1 compatibility. No functional changes.
9.2.0.7	9.2.0 - 10.0.3	17 Dec 2014	No functional changes. Reconfigured one of the target locations to avoid a conflict with either a manual edit or an unknown mod.
9.2.0.6	9.2.0 - 10.0.3	29 Nov 2014	No functional changes. Fixed an HTML error that most web browsers ignored.
9.2.0.5	9.2.0 - 10.0.3	29 Nov 2014	The date columns (instead of place columns) are forced not to wrap. Also added the number of burials in the headstones.php cemetery list, and a cleaned up the modified PHP code a good bit.
9.2.0.4	9.2.0 - 10.0.2	12 May 2014	No functional changes; just code cleanup.
9.2.0.3	9.2.0 - 10.0.1	15 Mar 2014	Initial release.