Difference between revisions of "Admin Reports Search"
Line 18: | Line 18: | ||
| max_TNG_ver = 12.2 | | max_TNG_ver = 12.2 | ||
| TNG_file_list = admin_reports.php, admin_editreport.php, admin_addreport.php, English cust_text.php | | TNG_file_list = admin_reports.php, admin_editreport.php, admin_addreport.php, English cust_text.php | ||
+ | <br>Installs shared files: rrinnermodmenu1_include.php, img/rrmodadmin_wikilogo.png | ||
| related_mods = [[Reports Action Queries]], [[Reports-Floating Editor]], [[Reports-Floating Results]] | | related_mods = [[Reports Action Queries]], [[Reports-Floating Editor]], [[Reports-Floating Results]] | ||
| notes = | | notes = | ||
Line 37: | Line 38: | ||
*# A 'Direct SQL' column that indicates ''whether'' the report contains a direct SQL statement, and that displays the entire SQL query when you hover over a 'Yes' in the 'Direct SQL' column | *# A 'Direct SQL' column that indicates ''whether'' the report contains a direct SQL statement, and that displays the entire SQL query when you hover over a 'Yes' in the 'Direct SQL' column | ||
− | == | + | == Mod Conflicts == |
No known incompatibilities. This mod is compatible with [[Reports Action Queries]] which is the only other published mod that claims to modify the Admin>>Reports>>Search page, and with [[Reports-Floating Editor]], which is the only other published mod that claims to modify Admin>>Reports>>Edit. | No known incompatibilities. This mod is compatible with [[Reports Action Queries]] which is the only other published mod that claims to modify the Admin>>Reports>>Search page, and with [[Reports-Floating Editor]], which is the only other published mod that claims to modify Admin>>Reports>>Edit. | ||
− | == | + | == Dependencies == |
This mod saves data that ''can be used by'' the utility mod [[Show Mod Names]], but is ''not dependent on''[[Show Mod Names]]. | This mod saves data that ''can be used by'' the utility mod [[Show Mod Names]], but is ''not dependent on''[[Show Mod Names]]. | ||
There are no known dependencies on other mods. | There are no known dependencies on other mods. | ||
Line 50: | Line 51: | ||
* [[Reports-Floating Results]] allows narrow reports to wrap into side-by-side report columns so that more data can be seen on the screen or printed page. It affects only showreport.php. | * [[Reports-Floating Results]] allows narrow reports to wrap into side-by-side report columns so that more data can be seen on the screen or printed page. It affects only showreport.php. | ||
− | |||
== Visualizations == | == Visualizations == | ||
{| border="1" cellspacing="1" cellpadding="2" class="wikitable" | {| border="1" cellspacing="1" cellpadding="2" class="wikitable" | ||
Line 84: | Line 84: | ||
|} | |} | ||
− | == | + | == Installation == |
+ | This mod uses the standard installation procedure, though it should be noted that this mod contains a mod subfolder that is shared with other mods that implement '''[https://tng.lythgoes.net/wiki/index.php?title=Inner_Mod_Menus Inner_Mod_Menus]'''. Because of the shared subfolder, as you unzip or copy the mod, you might get a warning noting that a file or folder already exists. You can just ignore that warning.<br>{{RobinInstallationBoilerplate}} | ||
+ | |||
+ | == Revision History == | ||
{| border="0" cellspacing="1" cellpadding="2" class="wikitable" | {| border="0" cellspacing="1" cellpadding="2" class="wikitable" | ||
! Mod Version !! TNG Version !! Date !! Note | ! Mod Version !! TNG Version !! Date !! Note | ||
− | |- style=vertical-align:top | + | |- style="vertical-align:top;" <!-- ############################################################## --> |
+ | |[[Media:admin_reports_search_v12.0.0.4.zip|12.0.0.4]] | ||
+ | | 12.0 - 12.2+ | ||
+ | | 2 Oct 2019 | ||
+ | *Added field buttons and the inner mod menu | ||
+ | |- style="vertical-align:top;" <!-- ############################################################## --> | ||
| [[Media:admin_reports_search_v11.0.0.3.zip|11.0.0.3]], [[Media:admin_reports_search_v12.0.0.3.zip|12.0.0.3]] | | [[Media:admin_reports_search_v11.0.0.3.zip|11.0.0.3]], [[Media:admin_reports_search_v12.0.0.3.zip|12.0.0.3]] | ||
| 11.*, 12.0+ | | 11.*, 12.0+ | ||
| 13 May 2018 | | 13 May 2018 | ||
| Restored the normal 'Add New' tab, removed the 'Add New' button from earlier versions, and brought a copy of the mod into compliance with TNGv12. | | Restored the normal 'Add New' tab, removed the 'Add New' button from earlier versions, and brought a copy of the mod into compliance with TNGv12. | ||
− | |- style=vertical-align:top | + | |- style="vertical-align:top;" <!-- ############################################################## --> |
| Admin Reports List 10.1.0.1 | | Admin Reports List 10.1.0.1 | ||
| 10.1-11.1 (at least; I believe that it should work for TNGv9 and TNGv10.0) | | 10.1-11.1 (at least; I believe that it should work for TNGv9 and TNGv10.0) | ||
Line 104: | Line 112: | ||
# Added (optional) Show Mod Names functionality | # Added (optional) Show Mod Names functionality | ||
# Changed admin_addreport.php, which creates a new report, so that it redirects to the report editor rather than to back to the search page. | # Changed admin_addreport.php, which creates a new report, so that it redirects to the report editor rather than to back to the search page. | ||
− | |- style=vertical-align:top | + | |- style="vertical-align:top;" <!-- ############################################################## --> |
| 9.2.2.1 [[Media:admin_reports_list_v9.2.2.1.zip|download]] | | 9.2.2.1 [[Media:admin_reports_list_v9.2.2.1.zip|download]] | ||
| 9.2.2 - 10.1 (at least; I believe it works at least through TNGv11.1) | | 9.2.2 - 10.1 (at least; I believe it works at least through TNGv11.1) |
Revision as of 14:09, 2 October 2019
Under Construction (The text of this article describes Version 18, but the visualizations are from Version 15.) Robin Richmond 2 Oct 2019 |
The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]
If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:
[See details in the TNGv12 Change Impacts Article][Hide the instructions] |
|
Admin Reports Search (formerly Admin Reports List) | ||
---|---|---|
Summary | Adds search features and results table columns to the Admin>>Reports>>Search page, and tweaks the Admin>>Reports>>Edit form so that it can both edit existing reports and add new reports. | |
Validation | ||
Mod Updated | 2 Oct 2019 | |
Download link | v12.0.0.4.zip
| |
Download stats | ||
Author(s) | Robin Richmond | |
Homepage | Robin Richmond's Genealogy Database | |
Mod Support | My Mod Support form or TNG Community Forums | |
Contact Developer | My Mod Support form | |
Latest Mod | 12.0.0.8 | |
Min TNG V | 9.2.2 | |
Max TNG V | 12.2 | |
Files modified | admin_reports.php, admin_editreport.php, admin_addreport.php, English cust_text.php
Installs shared files: rrinnermodmenu1_include.php, img/rrmodadmin_wikilogo.png | |
Related Mods | ||
Notes |
Purpose of the Mod
To improve the usability of the Admin>>Reports>>Search page.
- Changes to the search form:
- The Add New tab invokes the (enhanced) Edit Report form instead of the (now defunct) New Report form.
- An Add New button goes one step further, and uses the Search string as the initial Report Name.
- A new 'Result per Page' field lets you specify a value that is different from the TNG System Variable
- Field Buttons have been added to the Search string and to the Results Per Page Field
- Adds four columns to the results table to provide more information about each report:
- # of Display fields in the report definition,
- # of Criteria elements in the report definition,
- # of Sort fields in the report definition, and
- A 'Direct SQL' column that indicates whether the report contains a direct SQL statement, and that displays the entire SQL query when you hover over a 'Yes' in the 'Direct SQL' column
Mod Conflicts
No known incompatibilities. This mod is compatible with Reports Action Queries which is the only other published mod that claims to modify the Admin>>Reports>>Search page, and with Reports-Floating Editor, which is the only other published mod that claims to modify Admin>>Reports>>Edit.
Dependencies
This mod saves data that can be used by the utility mod Show Mod Names, but is not dependent onShow Mod Names. There are no known dependencies on other mods.
Related Mods
I have written three other mods that affect reports:
- Reports-Floating Editor makes better use of large computer screens when reports are being edited (at Admin>>Reports>>Edit). It allows the blocks of form fields that build the report to float side-by-side on the computer screen so that more of them can be seen at once. It also can unclutter the screen a bit by hiding either the report-building fields or the direct SQL field, since they can't really be used together. Reports-Floating Editor affects only the Report Editor, admin_editreport.php.
- Reports Action Queries allows SQL Action Queries to be run in the TNG Reports system. It affects the Admin>>Reports>>Search page (admin_reports.php) and showreport.php.
- Reports-Floating Results allows narrow reports to wrap into side-by-side report columns so that more data can be seen on the screen or printed page. It affects only showreport.php.
Visualizations
BEFORE The unmodified Admin>>Reports>Search screen |
AFTER Highlighting the new elements in the form and the results table
|
AFTER Showing pop-up SQL Code
|
AFTER Field Buttons If you have not installed the Field Buttons mod, the field buttons will not appear at all (even when they would otherwise be shaded out). The Field Buttons mod is completely optional.
See the Field Buttons Wiki article for more information. |
Installation
This mod uses the standard installation procedure, though it should be noted that this mod contains a mod subfolder that is shared with other mods that implement Inner_Mod_Menus. Because of the shared subfolder, as you unzip or copy the mod, you might get a warning noting that a file or folder already exists. You can just ignore that warning.
[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.
Revision History
Mod Version | TNG Version | Date | Note |
---|---|---|---|
12.0.0.4 | 12.0 - 12.2+ | 2 Oct 2019
| |
11.0.0.3, 12.0.0.3 | 11.*, 12.0+ | 13 May 2018 | Restored the normal 'Add New' tab, removed the 'Add New' button from earlier versions, and brought a copy of the mod into compliance with TNGv12. |
Admin Reports List 10.1.0.1 | 10.1-11.1 (at least; I believe that it should work for TNGv9 and TNGv10.0) | 4 May 2017 | Visible changes:
Plus these internal changes:
|
9.2.2.1 download | 9.2.2 - 10.1 (at least; I believe it works at least through TNGv11.1) | 17 Jan 2015 | 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 | 12.0.0.3b | 12.0 | English |
DJCM.DK | Claus Martinussen | 9.2.2.1 | 10.1.3 | Danish, English | |
Wortelboer Genealogy | Bernard Wortelboer | 9.2.2.1 | 10.1.3 | Dutch, English |