menu_banner (2K)

Amendment History

00.001.000 June 2003
Software converted from a previous language, documentation rewritten accordingly.
01.000.000 September 2004
Initial public release. This also includes documentation on Audit Logging and the Workflow Engine.
01.000.001 November 2004
  1. Added field settings to the TASK table.
01.000.002 December 2004
  1. Amended Directory Structure to identify the different locations for standard and custom versions of CSS and XSL files.
  2. Removed the AFTER_SUBMIT field from PATTERN and TASK tables.
01.000.003 March 2005
  1. Amended Directory Structure to include a separate CLASSES subdirectory for all database table classes
  2. .
01.000.004 April 2005
  1. Amended Appendix H to include a reference to the 'new session' link on the menu bar which will generate a new session on the server for a cloned instance on the client.
01.001.000 June 2005
  1. Added Appendix N to include references to the Data Dictionary.
  2. Amended Directory Structure to include a reference to the DEFAULT and DICT subdirectories.
01.002.000 July 2005
  1. Added Appendix O to document how this application has been modified to deal with the issue of internationalisation (I18N).
  2. Amended Directory Structure to include a reference to the new TEXT directory and the language subdirectories (used for internationalisation).
  3. Amended Update Menu Control data to include DEFAULT-LANGUAGE (used for internationalisation).
  4. Added task Export Subsystem which will export data from the MENU database into a series of text files so that they can be used for internationalisation.
01.003.000 December 2005
  1. Amended Export Subsystem which will now produce an SQL file so that all the data for a selected subsystem can be exported. This will allow the same data to be imported into another database.
  2. Added Erase Subsystem which will erase all data for the selected subsystem from the menu database. These details may be recovered using the file created by the export process.
  3. Added Export Database which will produce an SQL file so that all the data for a selected application database can be exported. This will allow the same data to be imported into another data dictionary.
  4. Added Erase Database which will erase all data for the selected application database from the data dictionary. These details may be recovered using the file created by the export process.
  5. Amended the Menu Bar area to include a 'print' option which will redisplay the current page without any buttons. This enables the basic data to be printed via the browser's own print facility.
01.004.000 February 2006
  1. Amended Update Task to include new fields LOG_SQL_QUERY and SCREEN_REFRESH.
  2. Amended Update Column to include a new field NO_AUDIT.
  3. Added List ToDo and associated family of tasks to maintain the contents of the TODO table.
01.005.000 10th March 2006
  1. Amended the menu bar to include the identity of current user.
  2. Amended Update User to include new fields START_DATE, END_DATE, IP_ADDRESS and EMAIL_ADDR.
  3. Amended Update Subsystem to include a new field TASK_PREFIX.
  4. Amended Update Menu Control data to include a new PASSWORD_WARNING field.
  5. Amended Appendix L - Audit Logging to include a new screen List Logon Errors.
  6. Amended Update Task to include new field USE_HTTPS.
01.006.000 28th March 2006
  1. Amended the database model by renaming DIALOG_TYPE to PATTERN.
  2. Amended all screens and tasks to reflect this name change.
01.007.000 7th April 2006
  1. Amended Appendix M by adding Update Workflow Workitem.
  2. Added task Update Session data.
  3. Amended Menu/Home Page to include reference to task Update Session data.
01.008.000 15th April 2006
  1. Amended Menu Bar to include a "logout (all)" option.
01.009.000 21st April 2006
  1. Amended Update Menu Control data to include the specification of shutdown periods during which time the system will not be available. This is to allow database backups (or any other maintenance) to be performed.
01.010.000 30th April 2006
  1. Amended Logon screen to include a hyperlink to request a forgotten password.
  2. Added Retrieve Password screen which will e-mail the user with a forgotten password.
  3. Amended Update Column to allow "checkbox" as a control type, to allow an optional label for each checkbox, and to position the text for radio groups and checkboxes either to the left or the right of the control.
01.011.000 15th May 2006
  1. Amended Update Column to allow "hyperlink" as a control type.
01.012.000 17th June 2006
  1. Amended Directory Structure to include a single CSS directory to hold a collection of CSS files, thus making radicore/style_default.css redundant. Individual image subdirectories have been merged into a single radicore/images directory.
  2. Amended Update Session to allow the user to change the appearance of all web pages in the application by selecting one of the available theme/style (CSS) files.
01.013.000 22nd June 2006
  1. Amended Import Database so that it will ask the user to choose a database to import instead of automatically importing all available databases which do not currently exist in the Data Dictionary.
01.014.000 9th July 2006
  1. Amended Add Workflow Transition and Update Workflow Transition so that ROLE_ID is optional. If this is left empty then when the corresponding workitem entry is created the role_id of the current user will be used instead.
01.015.000 14th July 2006
  1. Amended Search Audit Detail so that the use of the FROM date/time and TO date/time fields is more logical.
01.016.000 18th July 2006
  1. Amended Update Menu Control data to include an option to keep existing user passwords hidden on all screens.
01.017.000 3rd August 2006
  1. Amended Update Column to include an option for Dropdown lists which allow multiple selections.
01.018.000 28th August 2006
  1. Amended Directory Structure to include a REPORTS subdirectory for all report structure files.
01.019.000 3rd September 2006
  1. Amended List Pattern, List Subsystem, List Task (all), List Task (proc), List Task (menu), List Role and List User to include options for producing PDF reports.
  2. Amended List Databases, List Tables, List Relationships and List Columns to include options for producing PDF reports.
01.020.000 9th September 2006
  1. Amended Update Column to include a CUSTOM_VALIDATION field.
01.021.000 15th October 2006
  1. Added Build Directory to list of available tasks.
  2. Amended Appendix N: Data Dictionary to include new functions:
01.022.000 5th December 2006
  1. Amended Update Column to allow the AUTO-UPDATE option to be used on fields of type INTEGER. This can be used in the option to prevent simultaneous updates.
01.023.000 3rd March 2007
  1. Amended Generate PHP scripts (b) to allow the list of table names for the Outer table to be obtained from a database which is different from that of the Inner table. This defaults to the current database, but can be changed by pressing the popup button.
01.024.000 1st May 2007
  1. Amended Update Column to allow a new multi-checkbox control which can be used instead of a multi-dropdown.
01.025.000 28th May 2007
  1. Added the INITIAL-VALUE-ROLE table to the MENU database.
  2. Added Maintain Initial Values (Role) via Task and Maintain Initial Values via Role.
  3. Added the INITIAL-VALUE-USER table to the MENU database.
  4. Added Maintain Initial Values (User) via Task and Maintain Initial Values via User.
01.026.000 30th June 2007
  1. Added Generate SQL to the navigation bar of List Audit details.
01.027.000 20th August 2007
  1. Updated Appendix M: Workflow Engine to include new tasks List Expired Workitems and Trigger Expired Workitem.
  2. Added tasks List Navigation Button Parents and List Menu Parents.
01.028.000 Skipped in order to keep the software and documentation versions in step.
01.029.000 1st October 2007
  1. Added the ACCOUNT table to the MENU database to implement the feature described in Appendix P.
  2. Added a new group of tasks to maintain the ACCOUNT table.
  3. Updated Add User, Delete User, Enquire User, Search User and Update User to deal with the new rdcaccount_id column.
01.030.000
01.031.000
01.032.000
Skipped in order to keep the software and documentation versions in step.
01.033.000 1st February 2008
  1. Added the LANGUAGE table to the MENU database to hold details of all languages which are supported.
  2. Added a new group of tasks to maintain the LANGUAGE table.
  3. Updated Appendix O: Internationalisation.
  4. Added Appendix Q: Radius Authentication.
  5. Added is_noedit column to Maintain Initial Values (Role) via Task, Maintain Initial Values via Role, Maintain Initial Values (User) via Task, and Maintain Initial Values via User.
  6. Amended the settings field in Appendix D: Task Parameters.
01.034.000 1st March 2008
  1. Amended Appendix I: Passing context between objects.
  2. Added column party_id to the USER table.
  3. Added column field_desc to the TASK-FIELD table.
01.035.000
01.036.000
01.037.000
01.038.000
01.039.000
Skipped in order to keep the software and documentation versions in step.
01.040.000 1st October 2008
  1. Amended Menu Control Data to allow an additional option for external authentication.
  2. Amended Appendix Q: RADIUS Authentication.
  3. Added Appendix R: LDAP Authentication.
  4. Amended the USER table to change radius_auth to external_auth.
  5. Amended the ROLE table to change radius_auth to external_auth.
  6. Added column max_execution_time to the TASK table.
01.041.000 1st November 2008
  1. Amended Menu Control Data to allow logon using email address instead of user_id.
  2. Amended Menu Control Data to allow the display of the pagination and scrolling areas to be configurable.
  3. Amended Update Column to add the STRIP TRAILING ZERO option for numeric columns.
01.042.000 1st December 2008
  1. Amended Directory Structure to include a LOGS directory.
  2. Added Show Batch Log File to show the contents of the LOGS directory.
01.043.000
01.044.000
01.045.000
Skipped in order to keep the software and documentation versions in step.
01.046.000 1st April 2009
  1. Amended Update Table to include alias names for START_DATE and END_DATE columns.
01.047.000 Skipped in order to keep the software and documentation versions in step.
01.048.000 1st June 2009
  1. Added List MOTD and associated family of tasks to maintain the contents of the MOTD table.
01.049.000 1st July 2009
  1. Modified the USER table to include a time zone.
01.050.000
01.051.000
01.052.000
01.053.000
Skipped in order to keep the software and documentation versions in step.
01.054.000 1st December 2009
  1. Added the TASK-IP-ADDRESS table and associated maintenance tasks.
  2. Added the USER-IP-ADDRESS table and associated maintenance tasks.
01.055.000
01.056.000
01.057.000
01.058.000
Skipped in order to keep the software and documentation versions in step.
01.059.000 1st May 2010
  1. Modified Update Workfow Transition to allow time_limit to be specified in hours and minutes instead of just hours.
  2. Modified Update Column to allow control to be set to 'image'.
01.060.000
01.061.000
Skipped in order to keep the software and documentation versions in step.
01.062.000 1st Aug 2010
  1. Modified Update Task to add the run_at_end and run_at_cancel columns.
  2. Modified Appendix D: Task Parameters.
  3. Added the FAVOURITES table and associated maintenance tasks.

http://www.tonymarston.net
http://www.radicore.org