@Autowired

    FormService formService;

    @Autowired

    WorkflowManager workflowManager;

    @Autowired

    AppDefinitionDao appDefinitionDao;

    @Autowired

    DatalistDefinitionDao datalistDefinitionDao;

    @Autowired

    UserviewDefinitionDao userviewDefinitionDao;

    @Autowired

    MessageDao messageDao;

    @Autowired

    EnvironmentVariableDao environmentVariableDao;

    @Autowired

    PluginDefaultPropertiesDao pluginDefaultPropertiesDao;

    @Autowired

    PackageDefinitionDao packageDefinitionDao;

    @Autowired

    PluginManager pluginManager;

    @Autowired

    FormDataDao formDataDao;

    @Autowired

    UserviewService userviewService;

    //----- Workflow use cases ------

    /**

     * Retrieves the workflow process definition for a specific app version.

     * @param appId

     * @param version

     * @param processDefId

     * @return

     */

    @Override

    public WorkflowProcess getWorkflowProcessForApp(String appId, String version, String processDefId) {

        AppDefinition appDef = getAppDefinition(appId, version);

        PackageDefinition packageDef = appDef.getPackageDefinition();

        String processDefIdWithVersion = AppUtil.getProcessDefIdWithVersion(packageDef.getId(), packageDef.getVersion().toString(), processDefId);

        WorkflowProcess process = workflowManager.getProcess(processDefIdWithVersion);

        return process;

    }

//     * Retrieves the app definition for a specific workflow process.

//     * @param activityId

//     * @return

//     */

//    public AppDefinition getAppDefinitionForWorkflowProcess(String processId) {

//        AppDefinition appDef = null;

//        String processDefId = workflowManager.getProcessDefIdByInstanceId(processId);

//        String packageId = WorkflowUtil.getProcessDefPackageId(processDefId);

//        Long packageVersion = new Long(WorkflowUtil.getProcessDefVersion(processDefId));

//        PackageDefinition packageDef = packageDefinitionDao.loadPackageDefinitionByProcess(packageId, packageVersion, processDefId);

//        appDef = packageDef.getAppDefinition();

//        return appDef;

//    }

//

    /**

     * Retrieves the app definition for a specific workflow activity assignment.

     * @param activityId

     * @return

     */

    @Override

    public AppDefinition getAppDefinitionForWorkflowActivity(String activityId) {

        AppDefinition appDef = null;

        WorkflowActivity activity = workflowManager.getActivityById(activityId);

        if (activity != null) {

            String processDefId = activity.getProcessDefId();

            WorkflowProcess process = workflowManager.getProcess(processDefId);

            if (process != null) {

                String packageId = process.getPackageId();

                Long packageVersion = Long.parseLong(process.getVersion());

                PackageDefinition packageDef = packageDefinitionDao.loadPackageDefinition(packageId, packageVersion);

                if (packageDef != null) {

                    appDef = packageDef.getAppDefinition();

                }

            }

        }

        // set into thread

        AppUtil.setCurrentAppDefinition(appDef);

        return appDef;

    }

   

    /**

     * Retrieves the app definition for a specific workflow process.

     * @param processId

     * @return

     */

    @Override

    public AppDefinition getAppDefinitionForWorkflowProcess(String processId) {

        AppDefinition appDef = null;

        WorkflowProcess process = workflowManager.getRunningProcessById(processId);

        if (process != null) {

            String packageId = process.getPackageId();

            Long packageVersion = Long.parseLong(process.getVersion());

            PackageDefinition packageDef = packageDefinitionDao.loadPackageDefinition(packageId, packageVersion);

            if (packageDef != null) {

                appDef = packageDef.getAppDefinition();

            }

        }

        // set into thread

        AppUtil.setCurrentAppDefinition(appDef);

        return appDef;

    }

   

    /**

     * Retrieves the app definition for a specific workflow process definition id.

     * @param processDefId

     * @return

     */

    @Override

    public AppDefinition getAppDefinitionWithProcessDefId(String processDefId) {

        AppDefinition appDef = null;

        processDefId = workflowManager.getConvertedLatestProcessDefId(processDefId);

        String[] params = processDefId.split("#");

        String packageId = params[0];

        Long packageVersion = Long.parseLong(params[1]);

       

        PackageDefinition packageDef = packageDefinitionDao.loadPackageDefinition(packageId, packageVersion);

        if (packageDef != null) {

            appDef = packageDef.getAppDefinition();

        }

       

        // set into thread

        AppUtil.setCurrentAppDefinition(appDef);

        return appDef;

    }

    /**

     * Retrieve a form for a specific activity instance

     * @param appId

     * @param version

     * @param activityId

     * @param formData

     * @param formUrl

     * @return

     */

    @Override

    public PackageActivityForm viewAssignmentForm(String appId, String version, String activityId, FormData formData, String formUrl) {

        AppDefinition appDef = getAppDefinition(appId, version);

        WorkflowAssignment assignment = workflowManager.getAssignment(activityId);

        return viewAssignmentForm(appDef, assignment, formData, formUrl);

    }

   

    /**

     * Retrieve a form for a specific activity instance

     * @param appId

     * @param version

     * @param activityId

     * @param formData

     * @param formUrl

     * @return

     */

    @Override

    public PackageActivityForm viewAssignmentForm(AppDefinition appDef, WorkflowAssignment assignment, FormData formData, String formUrl) {

        String activityId = assignment.getActivityId();

        String processId = assignment.getProcessId();

        String processDefId = assignment.getProcessDefId();

        String activityDefId = assignment.getActivityDefId();

        PackageActivityForm activityForm = retrieveMappedForm(appDef.getAppId(), appDef.getVersion().toString(), processDefId, activityDefId);

        // get origin process id

        String originProcessId = getOriginProcessId(processId);

        // get mapped form

        if (formData == null) {

            formData = new FormData();

        }

        formData.setActivityId(activityId);

        formData.setProcessId(processId);

        formData.setPrimaryKeyValue(originProcessId);

       

        Form form = retrieveForm(appDef, activityForm, formData, assignment);

        if (form == null) {

            form = createDefaultForm(processId, formData);

        }

        // set action URL

        form.setProperty("url", formUrl);

        // decorate form with actions

        Collection<FormAction> formActionList = new ArrayList<FormAction>();

        if (activityForm != null && activityForm.getFormId() != null && !activityForm.getFormId().isEmpty() && !activityForm.getDisableSaveAsDraft()) {

            Element saveButton = (Element) pluginManager.getPlugin(SaveAsDraftButton.class.getName());

            saveButton.setProperty(FormUtil.PROPERTY_ID, "saveAsDraft");

            saveButton.setProperty("label", ResourceBundleUtil.getMessage("form.button.saveAsDraft"));

            formActionList.add((FormAction) saveButton);

        }

        Element completeButton = (Element) pluginManager.getPlugin(AssignmentCompleteButton.class.getName());

        completeButton.setProperty(FormUtil.PROPERTY_ID, AssignmentCompleteButton.DEFAULT_ID);

        completeButton.setProperty("label", ResourceBundleUtil.getMessage("form.button.complete"));

        formActionList.add((FormAction) completeButton);

        FormAction[] formActions = formActionList.toArray(new FormAction[0]);

        form = decorateFormActions(form, formActions);

        // set to definition

        if (activityForm == null) {

            activityForm = new PackageActivityForm();

        }

        activityForm.setForm(form);

        if (PackageActivityForm.ACTIVITY_FORM_TYPE_EXTERNAL.equals(activityForm.getType())) {

            // set external URL

            String externalUrl = AppUtil.processHashVariable(activityForm.getFormUrl(), assignment, null, null);

            if (externalUrl.indexOf("?") >= 0) {

                if (!externalUrl.endsWith("?") && !externalUrl.endsWith("&")) {

                    externalUrl += "&";

                }

            } else {

                externalUrl += "?";

            }

            activityForm.setFormUrl(externalUrl);

        }       

       

        return activityForm;

    }

   

    @Override

    public FormData completeAssignmentForm(Form form, WorkflowAssignment assignment, FormData formData, Map<String, String> workflowVariableMap) {

        if (formData == null) {

            formData = new FormData();

        }

        // get assignment

        String activityId = assignment.getActivityId();

        String processId = assignment.getProcessId();

        String processDefId = assignment.getProcessDefId();

        String activityDefId = assignment.getActivityDefId();

        // accept assignment if necessary

        if (!assignment.isAccepted()) {

            workflowManager.assignmentAccept(activityId);

        }

        // get and submit mapped form

        if (form != null) {

            formData = submitForm(form, formData, false);

        }

        Map<String, String> errors = formData.getFormErrors();

        if (!formData.getStay() && errors == null || errors.isEmpty()) {

            // complete assignment

            workflowManager.assignmentComplete(activityId, workflowVariableMap);

        }

        return formData;

    }

    /**

     * Process a submitted form to complete an assignment

     * @param appId

     * @param version

     * @param activityId

     * @param formData

     * @param workflowVariableMap

     * @return

     */

    @Override

    public FormData completeAssignmentForm(String appId, String version, String activityId, FormData formData, Map<String, String> workflowVariableMap) {

        if (formData == null) {

            formData = new FormData();

        }

        // get assignment

        WorkflowAssignment assignment = workflowManager.getAssignment(activityId);

        String processId = assignment.getProcessId();

        String processDefId = assignment.getProcessDefId();

        String activityDefId = assignment.getActivityDefId();

        // accept assignment if necessary

        if (!assignment.isAccepted()) {

            workflowManager.assignmentAccept(activityId);

        }

        // get and submit mapped form

        PackageActivityForm paf = retrieveMappedForm(appId, version, processDefId, activityDefId);

        if (paf != null) {

            String formDefId = paf.getFormId();

            if (formDefId != null && !formDefId.isEmpty()) {

                String originProcessId = getOriginProcessId(processId);

                formData.setPrimaryKeyValue(originProcessId);

                formData.setProcessId(processId);

               

                AppDefinition appDef = getAppDefinition(appId, version);

                Form form = retrieveForm(appDef, paf, formData, assignment);

                formData = submitForm(form, formData, false);

            }

        }

        Map<String, String> errors = formData.getFormErrors();

        if (!formData.getStay() && errors == null || errors.isEmpty()) {

            // complete assignment

            workflowManager.assignmentComplete(activityId, workflowVariableMap);

        }

        return formData;

    }

    /**

     * Retrieve form mapped to start a process

     * @param appId

     * @param version

     * @param processDefId

     * @param formData

     * @param formUrl

     * @return

     */

    @Override

    public PackageActivityForm viewStartProcessForm(String appId, String version, String processDefId, FormData formData, String formUrl) {

        AppDefinition appDef = getAppDefinition(appId, version);

        PackageActivityForm startFormDef = retrieveMappedForm(appId, version, processDefId, WorkflowUtil.ACTIVITY_DEF_ID_RUN_PROCESS);

        if (startFormDef != null) {

            if (startFormDef.getFormId() != null && !startFormDef.getFormId().isEmpty()) {

                // get mapped form

                Form startForm = retrieveForm(appDef, startFormDef, formData, null);

                if (startForm != null) {

                    // set action URL

                    startForm.setProperty("url", formUrl);

                    // decorate form with actions

                    Element submitButton = (Element) pluginManager.getPlugin(AssignmentCompleteButton.class.getName());

                    submitButton.setProperty(FormUtil.PROPERTY_ID, AssignmentCompleteButton.DEFAULT_ID);

                    submitButton.setProperty("label",  ResourceBundleUtil.getMessage("form.button.submit"));

                    FormAction[] formActions = {(FormAction) submitButton};

                    startForm = decorateFormActions(startForm, formActions);

                    // set to definition

                    startFormDef.setForm(startForm);

                }

            }

            if (PackageActivityForm.ACTIVITY_FORM_TYPE_EXTERNAL.equals(startFormDef.getType())) {

                // set external URL

                String externalUrl = AppUtil.processHashVariable(startFormDef.getFormUrl(), null, null, null);

                if (externalUrl.indexOf("?") >= 0) {

                    if (!externalUrl.endsWith("?") && !externalUrl.endsWith("&")) {

                        externalUrl += "&";

                    }

                } else {

                    externalUrl += "?";

                }

                startFormDef.setFormUrl(externalUrl);

            }       

        }

        return startFormDef;

    }

    /**

     * Start a process through a form submission

     * @param appId

     * @param version

     * @param processDefId

     * @param formData

     * @param workflowVariableMap

     * @param originProcessId

     * @param formUrl

     * @return

     */

    @Override

    public WorkflowProcessResult submitFormToStartProcess(String appId, String version, String processDefId, FormData formData, Map<String, String> workflowVariableMap, String originProcessId, String formUrl) {

        WorkflowProcessResult result = null;

        if (formData == null) {

            formData = new FormData();

        }

        AppDefinition appDef = getAppDefinition(appId, version);

        PackageDefinition packageDef = appDef.getPackageDefinition();

        String processDefIdWithVersion = AppUtil.getProcessDefIdWithVersion(packageDef.getId(), packageDef.getVersion().toString(), processDefId);

        // get form

        PackageActivityForm startFormDef = viewStartProcessForm(appId, appDef.getVersion().toString(), processDefId, formData, formUrl);

        if (startFormDef != null && startFormDef.getForm() != null) {

            Form startForm = startFormDef.getForm();

            FormData formResult = formService.executeFormActions(startForm, formData);

            if (formResult.getFormResult(AssignmentCompleteButton.DEFAULT_ID) != null) {

                // validate form

                formData = FormUtil.executeElementFormatDataForValidation(startForm, formData);

                formResult = formService.validateFormData(startForm, formData);

                Map<String, String> errors = formResult.getFormErrors();

                if (!formResult.getStay() && (errors == null || errors.isEmpty())) {

                    if (originProcessId == null && formResult.getRequestParameter(FormUtil.FORM_META_ORIGINAL_ID) != null && !formResult.getRequestParameter(FormUtil.FORM_META_ORIGINAL_ID).isEmpty()) {

                        originProcessId = formResult.getRequestParameter(FormUtil.FORM_META_ORIGINAL_ID);

                    } else if (startForm.getPrimaryKeyValue(formResult) != null) {

                        originProcessId = startForm.getPrimaryKeyValue(formResult);

                    }

                    // start process

                    result = workflowManager.processStart(processDefIdWithVersion, null, workflowVariableMap, null, originProcessId, true);

                    String processId = result.getProcess().getInstanceId();

                    String originId = (originProcessId != null && originProcessId.trim().length() > 0) ? originProcessId : processId;

                    originId = getOriginProcessId(originId);

                    // set primary key

                    formResult.setPrimaryKeyValue(originId);

                    formResult.setProcessId(processId);

                    // submit form

                    formResult = formService.submitForm(startForm, formResult, true);

                    errors = formResult.getFormErrors();

                    if (!formResult.getStay() && (errors == null || errors.isEmpty())) {

                        result = workflowManager.processStartWithInstanceId(processDefIdWithVersion, processId, workflowVariableMap);

                        // set next activity if configured

                        boolean autoContinue = (startFormDef != null) && startFormDef.isAutoContinue();

                        if (!autoContinue) {

                            // clear next activities

                            result.setActivities(new ArrayList<WorkflowActivity>());

                        }

                    } else {

                        workflowManager.removeProcessInstance(processId);

                        result = null;

                    }

                }

            }

        }

        return result;

    }

    /**

     * Retrieves ID of the form data row that is created or updated upon form submission.

     * @param formResult

     * @return

     */

    protected String retrieveFormRowId(FormData formResult) {

        String formRowId = null;

        Collection<FormStoreBinder> binders = formResult.getStoreBinders();

        for (FormStoreBinder binder : binders) {

            if (binder instanceof FormStoreBinder) {

                FormRowSet rowSet = formResult.getStoreBinderData(binder);

                if (!rowSet.isEmpty()) {

                    FormRow row = rowSet.get(0);

                    formRowId = row.getProperty("FORM_ID"); // TODO: use constant for form ID field

                }

                break;

            }

        }

        return formRowId;

    }

    /**

     * Returns the form definition ID for the form mapped to the specified activity definition ID.

     * @param activityDefId

     * @return

     */

    public PackageActivityForm retrieveMappedForm(String appId, String version, String processDefId, String activityDefId) {

        String processDefIdWithoutVersion = WorkflowUtil.getProcessDefIdWithoutVersion(processDefId);

        AppDefinition appDef = getAppDefinition(appId, version);

        PackageDefinition packageDef = appDef.getPackageDefinition();

        PackageActivityForm paf = packageDef.getPackageActivityForm(processDefIdWithoutVersion, activityDefId);

        if (paf != null) {

            try {

                paf = (PackageActivityForm)paf.clone();

            } catch (CloneNotSupportedException ex) {

                LogUtil.error(AppServiceImpl.class.getName(), ex, "Error cloning PackageActivityForm for " + activityDefId);

            }

        }

        return paf;

    }

    protected FormDefinition retrieveFormDefinition(AppDefinition appDef, PackageActivityForm activityForm) {

        FormDefinition formDef = null;

        if (activityForm != null) {

            String formId = activityForm.getFormId();

            if (formId != null && !formId.isEmpty()) {

                formDef = formDefinitionDao.loadById(formId, appDef);

            }

        }

        return formDef;

    }

    protected Form retrieveForm(AppDefinition appDef, PackageActivityForm activityForm, FormData formData, WorkflowAssignment wfAssignment) {

        Form form = null;

        if (appDef != null && activityForm != null) {

            String formId = activityForm.getFormId();

            if (formId != null && !formId.isEmpty()) {

                // retrieve form HTML

                form = loadFormByFormDefId(appDef.getId(), appDef.getVersion().toString(), formId, formData, wfAssignment);

            }

        }

        return form;

    }

    /**

     * Create a default empty form containing buttons for submission and fields for workflow variables

     * @return

     */

    protected Form createDefaultForm(String processId, FormData formData) {

        // create default empty form

        Form form = new Form();

        form.setProperty(FormUtil.PROPERTY_ID, "assignmentForm");

        form.setLoadBinder(new WorkflowFormBinder());

        form.setStoreBinder(new WorkflowFormBinder());

        // add textfields for workflow variables

        Collection<Element> children = new ArrayList<Element>();

        Collection<WorkflowVariable> variableList = workflowManager.getProcessVariableList(processId);

        for (WorkflowVariable variable : variableList) {

            String varId = variable.getId();

            String varName = variable.getName();

            TextField tf = new TextField();

            tf.setProperty(FormUtil.PROPERTY_ID, varId);

            tf.setProperty(FormUtil.PROPERTY_LABEL, varName);

            tf.setProperty(AppUtil.PROPERTY_WORKFLOW_VARIABLE, varId);

            children.add(tf);

        }

        form.setChildren(children);

        // load form

        String json = formService.generateElementJson(form);

        form = formService.loadFormFromJson(json, formData);

        // set workflow variable parameter names

        Collection<Element> formFields = form.getChildren(formData);

        for (Element element : formFields) {

            if (element instanceof TextField) {

                element.setCustomParameterName(AppUtil.PREFIX_WORKFLOW_VARIABLE + element.getProperty(FormUtil.PROPERTY_ID));

            }

        }

        return form;

    }

    /**

     * Returns the origin process ID for a process instance.

     * The origin process ID is the top-most process that is started that possibly triggers other sub-processes.

     * @param processId

     * @return

     */

    @Override

    public String getOriginProcessId(String processId) {

        WorkflowProcessLink link = workflowManager.getWorkflowProcessLink(processId);

        String originId = (link != null) ? link.getOriginProcessId() : processId;

        return originId;

    }

    /**

     * Check to see whether an activity is configured to automatically continue on to the next activity.

     * @param packageId

     * @param packageVersion

     * @param processDefId

     * @param activityDefId

     * @return

     */

    @Override

    public boolean isActivityAutoContinue(String packageId, String packageVersion, String processDefId, String activityDefId) {

        boolean autoContinue = false;

        Long version = null;

        try {

            version = Long.parseLong(packageVersion);

        } catch (Exception e) {

            // invalid number, ignore

        }

        if (version != null) {

            processDefId = WorkflowUtil.getProcessDefIdWithoutVersion(processDefId);

            PackageDefinition packageDef = packageDefinitionDao.loadPackageDefinition(packageId, version);

            if (packageDef != null) {

                PackageActivityForm paf = packageDef.getPackageActivityForm(processDefId, activityDefId);

                if (paf != null) {

                    autoContinue = paf.isAutoContinue();

                }

            }

        }

        return autoContinue;

    }

    /**

     * Retrieve a data form

     * @param appId

     * @param version

     * @param formDefId

     * @param saveButtonLabel

     * @param submitButtonLabel

     * @param cancelButtonLabel

     * @param formData

     * @param formUrl

     * @param cancelUrl

     * @return

     */

    @Override

    public Form viewDataForm(String appId, String version, String formDefId, String saveButtonLabel, String submitButtonLabel, String cancelButtonLabel, FormData formData, String formUrl, String cancelUrl) {

        return viewDataForm(appId, version, formDefId, saveButtonLabel, submitButtonLabel, cancelButtonLabel, null, formData, formUrl, cancelUrl);

    }

   

    @Override

    public Form viewDataForm(String appId, String version, String formDefId, String saveButtonLabel, String submitButtonLabel, String cancelButtonLabel, String cancelButtonTarget, FormData formData, String formUrl, String cancelUrl) {

        AppDefinition appDef = getAppDefinition(appId, version);

        if (formData == null) {

            formData = new FormData();

        }

        // get form

        Form form = loadFormByFormDefId(appDef.getId(), appDef.getVersion().toString(), formDefId, formData, null);

        // set action URL

        form.setProperty("url", formUrl);

        // decorate form with actions

        Collection<FormAction> formActionList = new ArrayList<FormAction>();

        if (saveButtonLabel != null) {

            if (saveButtonLabel.isEmpty()) {

                saveButtonLabel = "Save As Draft";

            }

            Element saveButton = (Element) pluginManager.getPlugin(SaveAsDraftButton.class.getName());

            saveButton.setProperty(FormUtil.PROPERTY_ID, "saveAsDraft");

            saveButton.setProperty("label", saveButtonLabel);

            formActionList.add((FormAction) saveButton);

        }

        if (submitButtonLabel != null) {

            if (submitButtonLabel.isEmpty()) {

                submitButtonLabel = "Submit";

            }

            Element submitButton = (Element) pluginManager.getPlugin(SubmitButton.class.getName());

            submitButton.setProperty(FormUtil.PROPERTY_ID, "submit");

            submitButton.setProperty("label", submitButtonLabel);

            formActionList.add((FormAction) submitButton);

        }

        if (cancelButtonLabel != null) {

            if (cancelButtonLabel.isEmpty()) {

                cancelButtonLabel = "Cancel";

            }

            Element cancelButton = (Element) pluginManager.getPlugin(LinkButton.class.getName());

            cancelButton.setProperty(FormUtil.PROPERTY_ID, "cancel");

            cancelButton.setProperty("label", cancelButtonLabel);

            cancelButton.setProperty("url", cancelUrl);

            if (cancelButtonTarget != null) {

                cancelButton.setProperty("target", cancelButtonTarget);

            }

            formActionList.add((FormAction) cancelButton);

        }

        FormAction[] formActions = formActionList.toArray(new FormAction[0]);

        form = decorateFormActions(form, formActions);

        return form;

    }

    /**

     * Returns a Collection of form data for a process based on criteria

     * @param formDefId

     * @param processId

     * @param query

     * @param sort

     * @param desc

     * @param start

     * @param rows

     * @return

     */

    @Override

    public Collection<Form> listProcessFormData(String formDefId, String processId, String query, String sort, Boolean desc, int start, int rows) {

        throw new UnsupportedOperationException("Not yet implemented");

    }

    /**

     * Returns the total number of form data rows for a process based on criteria

     * @param formDefId

     * @param query

     * @return

     */

    @Override

    public int countProcessFormData(String formDefId, String query) {

        throw new UnsupportedOperationException("Not yet implemented");

    }

    //----- Console app management use cases ------

    /**

     * Finds the app definition based on the appId and version, cached where possible

     * @param appId

     * @param version If null, empty or equals to AppDefinition.VERSION_LATEST, the latest version is returned.

     * @return null if the specific app definition is not found

     */

    @Override

    public AppDefinition getAppDefinition(String appId, String version) {

        // get app from thread

        boolean isAppDefReset = AppUtil.isAppDefinitionReset();

        AppDefinition appDef = AppUtil.getCurrentAppDefinition();

        Long versionLong = AppUtil.convertVersionToLong(version);

        if (isAppDefReset || appDef == null || !appDef.getId().equals(appId) || (versionLong != null && !appDef.getVersion().equals(versionLong))) {

            // no matching app in thread, load from DAO

            appDef = loadAppDefinition(appId, version);

        }

        return appDef;

    }

    /**

     * Finds the app definition based on the appId and version

     * @param appId

     * @param version If null, empty or equals to AppDefinition.VERSION_LATEST, the latest version is returned.

     * @return null if the specific app definition is not found

     */

    @Override

    public AppDefinition loadAppDefinition(String appId, String version) {

        // get app from thread

        AppDefinition appDef = null;

        Long versionLong = AppUtil.convertVersionToLong(version);

        if (versionLong == null) {

            // load latest

            appDef = appDefinitionDao.loadById(appId);

        } else {

            // load specific version

            try {

                appDef = appDefinitionDao.loadVersion(appId, versionLong);

            } catch (NumberFormatException e) {

                // TODO: handle exception

            } catch (NullPointerException e) {

                // TODO: handle exception

            }

        }

        // set into thread

        AppUtil.setCurrentAppDefinition(appDef);

        return appDef;

    }

   

    /**

     *

     * @param appDefinition

     * @return A Collection of errors (if any).

     */

    @Override

    public Collection<String> createAppDefinition(AppDefinition appDefinition) {

        Collection<String> errors = new ArrayList<String>();

        // check for duplicate

        String appId = appDefinition.getId();

        AppDefinition appDef = appDefinitionDao.loadById(appId);

        if (appDef != null) {

            errors.add("console.app.error.label.idExists");

        } else {

            // create app

            appDefinitionDao.saveOrUpdate(appDefinition);

        }

        return errors;

    }

    @Override

    public AppDefinition createNewAppDefinitionVersion(String appId) {

        TimeZone current = TimeZone.getDefault();

        TimeZone.setDefault(TimeZone.getTimeZone("GMT 0"));

       

        Long version = appDefinitionDao.getLatestVersion(appId);

        AppDefinition appDef = appDefinitionDao.loadVersion(appId, version);

        Serializer serializer = new Persister();

        AppDefinition newAppDef = null;

        try {

            newAppDef = serializer.read(AppDefinition.class, new ByteArrayInputStream(getAppDefinitionXml(appId, version)), "UTF-8");

        } catch (Exception e) {

            LogUtil.error(AppServiceImpl.class.getName(), e, appId);

        } finally {

            TimeZone.setDefault(current);

        }

        PackageDefinition packageDef = appDef.getPackageDefinition();

        byte[] xpdl = null;

       

        if (packageDef != null) {

            xpdl = workflowManager.getPackageContent(packageDef.getId(), packageDef.getVersion().toString());

        }

       

        Long newAppVersion = newAppDef.getVersion() + 1;

        return importAppDefinition(newAppDef, newAppVersion, xpdl);

    }

    @Override

    public void deleteAppDefinitionVersion(String appId, Long version) {

        AppDefinition appDef = appDefinitionDao.loadVersion(appId, version);

        appDefinitionDao.delete(appDef);

    }

    @Override

    public void deleteAllAppDefinitionVersions(String appId) {

        // delete app

        appDefinitionDao.deleteAllVersions(appId);

        // TODO: delete processes

    }

    //----- Console workflow management use cases ------

    @Override

    public PackageDefinition deployWorkflowPackage(String appId, String version, byte[] packageXpdl, boolean createNewApp) throws Exception {

        PackageDefinition packageDef = null;

        AppDefinition appDef = null;

        String packageId = workflowManager.getPackageIdFromDefinition(packageXpdl);

       

        // get app version

        if (appId != null && !appId.isEmpty()) {

            appDef = loadAppDefinition(appId, version);

            // verify packageId

            if (appDef != null && !packageId.equalsIgnoreCase(appDef.getAppId())) {

                throw new UnsupportedOperationException("Package ID does not match App ID");

            }

        } else {

            appDef = loadAppDefinition(packageId, null);

        }

        if (appDef != null || createNewApp) {

            Long originalVersion = null;

           

            //to fix package id letter case issue

            if (appDef != null && !packageId.equals(appDef.getAppId())) {

                packageXpdl = StringUtil.searchAndReplaceByteContent(packageXpdl, packageId, appDef.getAppId());

                packageId = appDef.getAppId();

            }

            // deploy package

            String versionStr = workflowManager.getCurrentPackageVersion(packageId);

            String packageIdToUpload = (versionStr != null && !versionStr.isEmpty()) ? packageId : null;

            workflowManager.processUpload(packageIdToUpload, packageXpdl);

            // load package

            versionStr = workflowManager.getCurrentPackageVersion(packageId);

            WorkflowPackage workflowPackage = workflowManager.getPackage(packageId, versionStr);

            // create app from package if not specified

            if (appDef == null) {

                appDef = new AppDefinition();

                appDef.setAppId(packageId);

                appDef.setName(workflowPackage.getPackageName());

                appDef.setVersion(new Long(1));

                createAppDefinition(appDef);

            }

            // get package definition

            packageDef = appDef.getPackageDefinition();

            Long packageVersion = Long.parseLong(versionStr);

            if (packageDef == null) {

                packageDef = packageDefinitionDao.createPackageDefinition(appDef, packageVersion);

               

                //if app version is the only version for the app and no package is found, set process start white list to admin user

                if (appDefinitionDao.countVersions(appId) == 1) {

                    Collection<WorkflowProcess> processList = workflowManager.getProcessList(appDef.getAppId(), packageVersion.toString());

                    for (WorkflowProcess wp : processList) {

                        String processIdWithoutVersion = WorkflowUtil.getProcessDefIdWithoutVersion(wp.getId());

                        PackageParticipant participant = new PackageParticipant();

                        participant.setProcessDefId(processIdWithoutVersion);

                        participant.setParticipantId(WorkflowUtil.PROCESS_START_WHITE_LIST);

                        participant.setType(PackageParticipant.TYPE_ROLE);

                        participant.setValue(PackageParticipant.VALUE_ROLE_ADMIN);

                        packageDefinitionDao.addAppParticipant(appDef.getAppId(), appDef.getVersion(), participant);

                    }

                }

            } else {

                originalVersion = packageDef.getVersion();

                packageDefinitionDao.updatePackageDefinitionVersion(packageDef, packageVersion);

            }

            if (originalVersion != null) {

                updateRunningProcesses(packageId, originalVersion, packageVersion);

            }

        }

        return packageDef;

    }

    //----- Console form management use cases ------

    @Resource

    FormDefinitionDao formDefinitionDao;

    @Override

    public Collection<String> createFormDefinition(AppDefinition appDefinition, FormDefinition formDefinition) {

        Collection<String> errors = new ArrayList<String>();

        // check for duplicate

        String formId = formDefinition.getId();

        FormDefinition formDef = formDefinitionDao.loadById(formId, appDefinition);

        if (formDef != null) {

            errors.add("console.form.error.label.idExists");

        } else {

            // set app to form

            formDefinition.setAppDefinition(appDefinition);

            // create app

            formDefinitionDao.add(formDefinition);

        }

        return errors;

    }

    //---- form data use cases

    /**

     * Loads a Form based on a specific form definition ID

     * @param appId

     * @param version

     * @param formDefId

     * @param primaryKeyValue

     * @return

     */

    protected Form loadFormByFormDefId(String appId, String version, String formDefId, FormData formData, WorkflowAssignment wfAssignment) {

        Form form = null;

        try {

            AppDefinition appDef = getAppDefinition(appId, version);

            FormDefinition formDef = formDefinitionDao.loadById(formDefId, appDef);

           

            if (formDef != null && formDef.getJson() != null) {

                String formJson = formDef.getJson();

                formJson = AppUtil.processHashVariable(formJson, wfAssignment, StringUtil.TYPE_JSON, null);

                form = (Form) formService.loadFormFromJson(formJson, formData);

            }

        } catch (Exception e) {

            LogUtil.error(getClass().getName(), e, e.getMessage());

        }

        return form;

    }

    /**

     * Decorates a Form by adding a horizontal row of FormAction buttons in a new section.

     * @param form

     * @param formActions

     * @return

     */

    protected Form decorateFormActions(Form form, FormAction[] formActions) {

        if (form != null && formActions != null) {

            // create new section for buttons

            Section section = new Section();

            section.setProperty(FormUtil.PROPERTY_ID, "section-actions");

            Collection<Element> sectionChildren = new ArrayList<Element>();

            section.setChildren(sectionChildren);

            Collection<Element> formChildren = form.getChildren();

            if (formChildren == null) {

                formChildren = new ArrayList<Element>();

            }

            formChildren.add(section);

            // add new horizontal column to section

            Column column = new Column();

            column.setProperty("horizontal", "true");

            Collection<Element> columnChildren = new ArrayList<Element>();

            column.setChildren(columnChildren);

            sectionChildren.add(column);

            // add actions to column

            for (FormAction formAction : formActions) {

                if (formAction != null && formAction instanceof Element) {

                    columnChildren.add((Element) formAction);

                }

            }

        }

        return form;

    }

    /**

     * Use case for form submission by ID

     * @param formDefId

     * @param formData

     * @param ignoreValidation

     * @return

     */

    @Override

    public FormData submitForm(String appId, String version, String formDefId, FormData formData, boolean ignoreValidation) {

        Form form = loadFormByFormDefId(appId, version, formDefId, formData, null);

        if (form != null) {

            return formService.submitForm(form, formData, ignoreValidation);

        } else {

            return formData;

        }

    }

   

    /**

     * Use case for form submission by ID

     * @param form

     * @param formData

     * @param ignoreValidation

     * @return

     */

    @Override

    public FormData submitForm(Form form, FormData formData, boolean ignoreValidation) {

        if (form != null) {

            return formService.submitForm(form, formData, ignoreValidation);

        } else {

            return formData;

        }

    }

    /**

     * Load specific data row (record) by primary key value

     * @param appId

     * @param version

     * @param formDefId

     * @param primaryKeyValue

     * @return null if the form is not available, empty FormRowSet if the form is available but record is not found.

     */

    @Override

    public FormRowSet loadFormData(String appId, String version, String formDefId, String primaryKeyValue) {

        FormRowSet results = null;