= DrawMGT - V11.4 =

<<TableOfContents>>

= Features =

Description of end-user features, that we can explain to customers or put in our public web site.

== Important New Features ==

 1. Dual-Mirrored system (Internal/external, confidential/shared)
 1. Hierarchical classification trees
 1. Database versioning
 1. New, simplified User Roles
 1. New, filtered user profile list

== Other Changes ==

 1. Improved password security, password aging
 1. "Get next sequence number" on drawing/new.
 1. Workflow step "check" has status
 1. Workflow comments moved to Comments
 1. Test users
  * Don't appear in any drop down menus (workflow, subscribers, etc.)
  * Exclude from user lists, unless admin mode (and a 'include test users' checkbox)
  * Never send email to test users
 1. Restricted document viewer role (FRQ-1616)
 1. Restricted comment viewer role (FRQ-1616)
 1. Drawing Code parts linked with form elements
 1. Workflow wizard
 1. [[SecurityException|Security exception]] for comment subscriber
 1. !DrawingCode or !RevisionCode change can be allowed
 1. Automated request redirecting after login
 1. Mail filtering
 1. E-mail sending on rejected revisions

= Database Model Changes =

== Database Model Changes Associated With New Features ==

 1. Dual-Mirrored system (Internal/external, confidential/shared)
  * Database triggers, created by '''genMeta.pl -b'''
  * Staging database, mirroring table (...stg.!MirrorRecords)

 1. Hierarchical classification trees
  * New fields in classification reference tables
   * sortOrder
   * parentId
   * searchOnlyFlag
   * displayClass
   * displayTextInput
   * displayTextDetail
   * displayTextList
   * displayHover

 1. Database versioning
  * Database triggers, created by '''genMeta.pl -b'''
  * versioning tables '''..._log'''

 1. Improved password security, password ageing
  * New field Users.passwordDate

 1. Test users
  * New field Users.testUserFlag

 1. Restricted document viewer role (FRQ-1616)
  * New fields
   * !DocumentTypeRef.restrictedFlag
   * Drawings.restrictedFlag
   * !RevisionTypeRef.restrictedFlag
   * Revisions.restrictedFlag
   * Users.restrictedFlag

 1. Restricted comment viewer role (FRQ-1616)
  * New fields
   * !CommentTypeRef.restrictedFlag
   * Comments.restrictedFlag
   * !CommentNoteTypeRef.restrictedFlag
   * !CommentNotes.restrictedFlag
   * Users.restrictedFlag

 1. Company/Department
  * New field Users.companyId
  * Users.company = department

== Other Database Model Changes ==

 1. New field '''sortOrder''' on all reference tables
 1. Fields Revisions.startDate, Revisions.startResponsibleId removed
 1. Fields Comments.startDate, Comments.startPlanDate removed
 1. Field !ContractRef.contractorCompanyId removed
 1. New table !OldPasswords, intended to store old passwords to allow to disable re-using passwords (not used yet)
 1. Field !ContractRef.siteCompanyId removed

= Migration Notes =

 1. Dual-Mirrored system (Internal/external, confidential/shared)
  * See [[SetupDualDrawMGTSystem|Setup Dual Draw MGTSystem]]

 1. Database versioning
  * '''$_CFG['!DbVersioning']['Tables']''' contains the array of table names partticipating in database versioning

 1. Improved password security, password ageing
  * '''$_CFG['!SecurityCheck']['!PasswordWithLoginName' ]''' - cut-off date for encrypting with login name. Set it to migration date in !SiteSettings.php
  * '''$_CFG['!SecurityCheck']['!PasswordChangePeriod']''' - password aging period, set to 90 days in Settings.php

 1. "Get next sequence number" on drawing/new
  * Set 'getNext' and 'getNextPattern' for the appropriate drawing code type

 1. Workflow comments moved to Comments
  * No generic automatic migration until now, but there is a site specific solution in cfg/linthal/site/data/migrate-db-linthal.sql in DrawMGT 11.4.

 1. [[SecurityException|Security exception]]
  * '''$_CFG[ '!CommentTypesSubscrAllow' ]''' - set it to an array of comment types, where security exception allowed, e.g.: '''array( !CommentTypeRef_KOOR )'''

 1. Attachment name changed on !DrawingCode or !RevisionCode change
  * '''$_CFG[ '!DrawingAllowCodeUpdate' ]'''
  * '''$_CFG[ 'RenameFilesOnDCodeUpdate' ]'''
  * '''$_CFG[ '!RevisionAllowCodeUpdate' ]'''
  * '''$_CFG[ 'RenameFilesOnRCodeUpdate' ]'''

 1. Mail filtering
  $_CFG[ 'Security' ][ '!AllowedEmailAddresses' ] - an array of allowed email addresses as regular expressions

= Development Notes =

 1. Dual-Mirrored system (Internal/external, confidential/shared)
  See [[DualSystemDesignNotes|Dual System Design Notes]]

 1. Hierarchical classification trees

 1. Database versioning
  Database versioning triggers are combined with mirroring triggers of a dual system

 1. New, simplified User Roles
  See '''NewRoleXRef.xls''' in SXS-T-000001 for cross reference list between old and new roles.
  The script '''./app/schema/migrate/bin/generateUserRolesMigration.pl''' creates migration script from '''NewRoleXRef.xls'''.

 1. Improved password security, password ageing
  As of 11.4 the user name and the raw password are encrypted together. Use the new enryption methon on password check if ct-off date is greather or equal to password date.

 1. Workflow comments moved to Comments

 1. Test users

 1. Restricted document viewer role (FRQ-1616)

 1. Restricted comment viewer role (FRQ-1616)

 1. Drawing Code parts linked with form elements

 1. Workflow wizard

 1. Security exception for comment subscribers
  See [[SecurityException|Security exception]].

 1. !DrawingCode or !RevisionCode change can be allowed

 1. Automated request redirecting after login

 1. Mail filtering

 1. E-mail sending on rejected revisions