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.

• 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.

• 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.

Database Model

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

The model as MySQL WorkBench File or asPDF 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 table DisplayWorkFlowStepRef.