= Dynamic Work Flow Names =

The following improvements are implemented:

 * The workflow types appearing in select lists on the GUI are coming from the table DisplayWorkFlowTypeRef to allows aliases to the same workflow.
  * E.g. the workflows '04 erst-gepr-freig', '05 Vorabzug', '06 zur Freigabe' and '07 Gut zur Ausführung' at Axpo are aliases to '''DCA'''.
 * It is possible to have different workflow step names for different workflows through the tables DisplayWorkFlowTypeRef-DisplayWorkFlowStepListRef-DisplayWorkFlowStepRef-WorkFlowStepRef. The workflow step names are taken ALWAYS from table DisplayWorkFlowStepRef.
  * E.g. at Axpo the step 'Design' has the name 'erstellt', but for the work flow '07 Gut zur Ausführung' the name is 'versendet an BL'.
 * It is possible to have different workflow step status names for different workflows through the tables DisplayWorkFlowTypeRef-DisplayWorkFlowStepRef-ApprovalStatusListRef-DisplayApprovalStatusRef-ApprovalStatusRef. The workflow step status names are taken ALWAYS from table DisplayApprovalStatusRef.
  * E.g. at Axpo the step 'Check' in work flow '06 zur Freigabe' has the status names 'offen' and 'Prüfbericht erstellt', but 'offen' and 'erhalten' in work flow '07 Gut zur Ausführung'
 * It is possible to have different workflow step status names for the same workflow step status, because Revisions.checkStatusId, ..., Revisions.releseStatusId are foreign keys to the table DisplayApprovalStatusRef and not for ApprovalStatusRef anymore
  * E.g. at Axpo in work flow '05 Vorabzug' in step 'Check' both status 'keine Bemerkungen' and 'Bemerkungen einarbeiten' refer to status 'Approved', because notes are processed in separate document ("Stellungnahme")

== Database Model ==

The graphical representation of the database model was created by [[http://wb.mysql.com/|mysql-worbench]] V5.2.31. An older version is part of the OpenSuse distribution. Contact TN is you want to install [[http://wb.mysql.com/|mysql-worbench]] V5.2.31 from source on OpenSuse or on other linux distributions.

The model as [[attachment:dynamic_workflow_names_20110304.mwb|MySQL WorkBench File]] or as[[attachment:dynamic_workflow_names_20110304.pdf|PDF File]]

== Implementation ==

Smarty functions are used to display the dynamic names. See function.wf_step_name.php and function.html_inoutput.php.

== System Changes ==

There are some changes in the DrawMGT system to care about:

 * The field Revisions.displayWorkFlowTypeId appears in the select lists, but the field Revisions.workFlowTypeId is used for the validation. It must be ensured that Revisions.workFlowTypeId is updated always on Revisions.displayWorkFlowTypeId change
 * The DocumentTypeRef table contains displayWorkFlowTypeId instead of workFlowTypeId

== Open Points ==

 * Validation error messages shows the original field names instead of the dynamic ones
 * There is now way the disable the 'delete' option in Administration/Configuration for records referred through n:n relationship, as for records of tables DisplayWorkFlowStepRef and DisplayApprovalStatusRef.