Cemetery Burials Table

Burials-More Details
Summary	This mod (1) adds the persons birth and death dates and places to the All Burials table for a cemetery, as displayed by showmap.php, and (2) adds a burials count to each cemetery name listed by headstones.php.
Validation
Mod Updated	{{{mod_last_update}}}
Download link	burials-more_details_v11.0.0.13a.zip TNG 11.0 burials-more_details_v10.1.0.12.zip TNG 10.1.0 burials-more_details_v9.2.0.12.zip TNG 10.0 TNG 9.2
Download stats
Author(s)	Robin Richmond, with significant debugging and testing help from Ken Roy
Homepage	Robin Richmond's Genealogy Database
Mod Support	My Mod Support form or TNG Community Forums
Contact Developer	My Mod Support form
Latest Mod	11.0.0.13 for TNGv11.0-v11.0.1 10.1.0.12 for TNG v10.1* 9.2.0.12 for v9.2-v10.0.3
Min TNG V	9.2
Max TNG V	11.0.1
Files modified	showmap.php, headstones.php, css/genstyle.css, English, Dutch, & Norwegian cust_text.php
Related Mods	Cemetery-No Headstones, Show Mod Names
Notes

Purpose of the Mod

To improve the usability and accessibility of end-user Cemetery report, which consists of two programs:

1. headstones.php displays a Google map of selected cemeteries, and a list of those cemeteries, with a Headstones (or Headstone Photos) table for each cemetery. Each of the cemetery names is a hyperlink to showmap.php
2. showmap.php displays a Google map of the one selected cemetery, cemetery maps and/or other images

that have been linked to the cemetery, cemetery notes, the Headstones table (again), and the All Burials table

Changes to headstones.php

• Each cemetery name is now followed by the number of burials at that cemetery (for the selected tree).
• The Headstones table column headings are suppressed when there are no Headstone Photos to display.
• A Mod Parameter allows the Headstones table to be suppressed altogether.

Changes to showmap.php

• The following columns are added to the All Burials table:
  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.
• In the All Burials table, the burial date column is not displayed if it contains no data.
• In the All Burials table, the PersonID and Burial place columns are removed, and the Burial Place is, instead, shown just above the All Burials table.

Mod Parameters

There are two parameters for headstones.php:

1. Whether to suppress the Headstones query and table altogether. (In truth, if there are NO headstone photos, the Headstones table will not be displayed and this parameter is unnecessary. It becomes useful if the occasional headstone photo would get in the way of a clean list of cemeteries.)
   
   Note that the Headstones table in showmap.php is controlled by the companion mod Cemetery-No Headstones. In that mod, the Headstones table can be suppressed altogether, or hidden behind a button, or shown along with a button that hides it. All of those options are not available for the Headstones table in headstones.php.
2. The number of cemeteries to display per page. The pristine program is hard-coded to display only 5 cemeteries, because it assumes that there will be Headstone tables for each cemetery. But if you don't track headstone photos, you might want to increase this value, perhaps to 25 or so.

Dependencies

This mod is dependent on Show Mod Names v2+. You don't need Show Mod Names to install it, but you'll get a run-time error if Show Mod Names v2+ has not been installed.

Conflicts

• Conflicts with Showmap Burials, which does some, but not quite all, of the same things.
• Conflicts with Tree ID Mod

if you install the Tree ID Mod first, you cannot install this mod

if you install this mod first, then you cannot install the Tree ID Mod

• This mod is no longer compatible with Headstones-No Headstones, which may be completely obsolete now.

Other Related Mods

Cemetery-No Headstones can suppress the Headstones table from showmap.php, and/or display a button to show or hide the Headstones table. (There's an argument that Cemetery-No Headstones should be combined with this mod, but at the moment, the remain separate.

Requirements

• A working TNG installation.
• An installed current version of the Mod Manager.

Automated Installation

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

In the event of a problem

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

Visualization of this Mod

Cemetery List in headstones.php - BEFORE For each cemetery, the heading for a Headstones table is shown, even if there are no headstone photos. The program is hard-coded to show 5 cemeteries per page. The cemetery name is a hyperlink to showmap.php, which redisplays the Headstones table, and also display the "All Burials" table.

Cemetery List - AFTER If there are no Headstone Photos, the empty table heading is suppressed. A Mod Parameter controls the number of cemeteries displayed per page. The number of burials in the cemetery (not the number of headstone photos) is shown after each cemetery name.

Cemetery List - AFTER - With a Mod Parameter set to suppress the Headstone Photos reports altogether

The Headstones and All Burials tables in showmap.php - BEFORE The Headstones table here is identical to the one in Headstones.php. It can be suppressed (altogether, or with a button that hides or displays the table) by the companion Cemetery-No Headstones mod. In the unmodified All Burials table, the cemetery name is - by definition - the same for all records. The two columns that this mod always excludes from the All Burials table by the mod are highlighted here.

All Burials Table in showmap.php - AFTER Note the three new columns - birth date and place, death date and place, and Spouse(s). The burial place name is no longer shown in the results table. Instead, it is in the heading above the table. (The unmodified program does not display the cemetery name near the Headstones and All Burials tables. It is only shown up at the top of the page, above the Google map, and above any cemetery map or photo that have been linked to the cemetery.) Also note that the Burial column and the Tree column are absent from this particular example: The Burial Place is always omitted, since they would all be the same. 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. A "Private" spouse, and a "Living" person are shown in the report, just to illustrate that the report at least tries to enforce those privacy considerations.

Mod Change History

Mod Version	TNG Version	Date	Note
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.

Sites using this mod

If you download and install this mod, please add your site to the table below.

URL	User	Note	Mod-Version	TNG-Version	User-language
Robin Richmond's Genealogy Database	Robin Richmond	Mod developer	11.0.0.13	11.0	English
MOTYER Family Genealogy	John Mark Motyer	Public site	see here	see here	EN, DE, RU
Total Family History	Scott Bennett	Private Site (For right now)	9.2.0.3	TNG 10.0.1	EN
The Dutton's of Vermont	Darrin Dutton	Public	11.0.0.13a	11.0.2	EN
Adler-Wien	Herbert Fischer	Public site	10.1.0.11b	11.0.0	DE, (EN)