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 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 tables DisplayWorkFlowStepRef and DisplayApprovalStatusRef.