/** * Function sets SendToAllAtOnce Flag of the Worklfow and also sets the WorkflowTemplateId */ public function setSendToAllAtOnce() { $workflow = WorkflowVersionTable::instance()->getWorkflowVersionById($this->version_id); $workflowVersion = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($this->version_id); $this->workflow = $workflow->toArray(); $this->workflowversion = $workflowVersion->toArray(); $template = MailinglistVersionTable::instance()->getSingleVersionById($workflowVersion[0]->getMailinglisttemplateversionId())->toArray(); $this->sendToAllAtOnce = $template[0]['sendtoallslotsatonce']; $this->workflowtemplate_id = $workflow[0]->getWorkflowtemplateId(); }
/** * * Create next station if a workflow is been saved * * @param array $slots, all SLots * @param int $userId, userid * @param int $versionId, version of workflow * @return true */ public function getNextStation(array $slots, $userId, $versionId) { foreach($slots as $slot) { $wfProcessData = WorkflowProcessUserTable::instance()->getActiveProcessUserForWorkflowSlot($slot['workflowslot_id'],$userId)->toArray(); $toChange = WorkflowProcessUserTable::instance()->getWaitingStation($slot['workflowslot_id'],$userId); foreach($toChange as $itemToChange) { $pdoObj = Doctrine::getTable('WorkflowProcessUser')->find($itemToChange->getId()); $pdoObj->setDecissionstate('DONE'); $pdoObj->setDateofdecission(time()); $pdoObj->save(); } $versionId = $versionId; $wfSlotId = $slot['workflowslot_id']; $wsUserId = $wfProcessData[0]['workflowslotuser_id']; $checkWorkflow = new CreateNextStation($versionId,$wfSlotId,$wsUserId, $this); } $workflowVersion = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($versionId); $workflowData = MailinglistVersionTable::instance()->getSingleVersionById($workflowVersion[0]->getMailinglisttemplateversionId())->toArray(); if($workflowData[0]['sendtoallslotsatonce'] == 1) { $slots = WorkflowSlotTable::instance()->getSlotByVersionId($versionId); $isCompleted = true; foreach($slots as $slot) { $users = WorkflowSlotUserTable::instance()->getUserBySlotId($slot->getId()); foreach($users as $user) { $processUsers = WorkflowProcessUserTable::instance()->getProcessUserByWorkflowSlotUserId($user->getId()); foreach($processUsers as $singleUser) { $userArray = $singleUser->toArray(); if($userArray['decissionstate'] == 'WAITING') { $isCompleted = false; } } } } if($isCompleted == true) { WorkflowTemplateTable::instance()->setWorkflowFinished($workflowVersion[0]['id']); $checkWorkflow->checkEndAction(); } } return true; }
/** * Creates all records for mailinglist grid * @param Doctrine_Collection $data, data * @return array $result */ public function buildAllMailinglists(Doctrine_Collection $data) { $result = array(); $a = 0; foreach($data as $item) { $documenttemplate = $item->getDocumenttemplateTemplate()->toArray(); $activeversion = MailinglistVersionTable::instance()->getActiveVersionById($item->getId())->toArray(); $result[$a]['#'] = $a+1; $result[$a]['id'] = $item->getId(); $result[$a]['activeversion'] = $activeversion[0]['id']; $result[$a]['isactive'] = $item->getIsactive(); $result[$a]['name'] = $item->getName(); $result[$a++]['formtemplate_name'] = $documenttemplate[0]['name']; } return $result; }
/** * Start a workflow and its processes. Needed to start a workflow, also if it is started in future * * @param sfWebRequest $request * @return <type> */ public function executeStartWorkflow(sfWebRequest $request) { WorkflowVersionTable::instance()->startWorkflow($request->getParameter('versionid')); $workflowVersion = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($request->getParameter('versionid')); $template = MailinglistVersionTable::instance()->getSingleVersionById($workflowVersion[0]->getMailinglisttemplateversionId())->toArray(); if($template[0]['sendtoallslotsatonce'] == 1) { $calc = new CreateWorkflow($request->getParameter('versionid')); $calc->addAllSlots(); } else { $calc = new CreateWorkflow($request->getParameter('versionid')); $calc->addSingleSlot(); } return sfView::NONE; }
public function buildUserData(Doctrine_Collection $data, $templateversion_id) { $result = array(); $returnData = array(); $a = 0; $slots = WorkflowSlotTable::instance()->getSlotByVersionId($data[0]->getId()); $workflowVersion = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($templateversion_id); $template = MailinglistVersionTable::instance()->getSingleVersionById($workflowVersion[0]->getMailinglisttemplateversionId())->toArray(); foreach($slots as $slot) { $documenttemplateslot = $slot->getDocumenttemplateSlot()->toArray(); $result[$a]['slotname'] = $documenttemplateslot[0]['name']; $result[$a]['senttoallatonce'] = $template[0]['sendtoallslotsatonce']; $result[$a]['workflowslot_id'] = $slot->getId(); $result[$a]['sendtoallreceivers'] = $documenttemplateslot[0]['sendtoallreceivers']; $result[$a]['slot_id'] = $documenttemplateslot[0]['id']; $result[$a++]['user'] = $this->getUser($slot->getId(), $data[0]->getWorkflowtemplateId(), $documenttemplateslot[0]['name'], $a, $templateversion_id); } $returnData = $this->mergeArray($result); return $returnData; }
/** * Adapt mailinglist to current version * @param sfWebRequest $request * @return <type> */ public function executeAdaptMailinglist(sfWebRequest $request) { $mailinglist = new Mailinglist(); $docuObj = new Documenttemplate(); $mailinglistdata = MailinglistTemplateTable::instance()->getMailinglistByVersionTemplateId($request->getParameter('id'))->toArray(); $currentdocumenttemplateversion = DocumenttemplateVersionTable::instance()->getActiveVersionById($mailinglistdata[0]['documenttemplatetemplate_id'])->toArray(); $slots = $docuObj->buildSlots($currentdocumenttemplateversion[0]['id'], 'SLOTSONLY'); $mailinglistversiondata = MailinglistVersionTable::instance()->getActiveVersionById($request->getParameter('id'))->toArray(); MailinglistVersionTable::instance()->setMailinglistInactiveById($mailinglistversiondata[0]['mailinglisttemplate_id']); $mailinglistversion_id = $mailinglist->storeVersion($mailinglistversiondata[0]['mailinglisttemplate_id'],$mailinglistversiondata[0]['version']+1, $currentdocumenttemplateversion[0]['id']); $userdata = MailinglistAllowedSenderTable::instance()->getAllowedSenderById($mailinglistversiondata[0]['id']); $users = $mailinglist->buildAllowedUser($userdata); $mailinglist->saveUser($mailinglistversion_id, isset($users) ? $users: array()); $authdata = MailinglistAuthorizationSettingTable::instance()->getAuthorizationById($mailinglistversiondata[0]['id'])->toArray(); $mailinglist->adaptAuthorizationEntry($authdata, $mailinglistversion_id); $mailinglist->storeMailinglist($slots, $mailinglistversion_id); return sfView::NONE; }
/** * the Action restarts the workflow * @param sfWebRequest $request * @return <type> */ public function executeRestartWorkflow(sfWebRequest $request) { sfLoader::loadHelpers('Url'); $context = sfContext::getInstance(); $context->getConfiguration()->loadHelpers('Partial', 'I18N', 'Url', 'Date', 'CalculateDate', 'ColorBuilder', 'Icon', 'EndAction'); $createWorkObj = new PrepareWorkflowData(); $startDate = array(); $version_id = $request->getParameter('versionid'); $newValue = $request->getParameter('restartWorkflowFirstTab_useoldvalues',0); // set flag if values form previous version will be used or from the default value of the fields $endreason = $createWorkObj->createEndreason($request->getPostParameter('restartWorkflowFirstTabSettings', array())); // set additional settings $startDate = $createWorkObj->createStartDate('', ''); // startdate is always at the moment $content = $createWorkObj->createRestartContenttype($request->getPostParameters());// ste contenttype of the additional text $workflowtemplate_id = WorkflowVersionTable::instance()->getWorkflowVersionById($version_id)->toArray(); // load the current workflowversion WorkflowTemplateTable::instance()->updateEndaction($workflowtemplate_id[0]['id'],$endreason); // update the endaction/additionalsettings $currentVersion = WorkflowVersionTable::instance()->getLastVersionById($workflowtemplate_id[0]['workflowtemplate_id'])->toArray(); // load the last workflow $slots = WorkflowSlotTable::instance()->getSlotByVersionId($version_id); // get all slots for the current workflow WorkflowVersionTable::instance()->setVersionInactive($version_id); // set the current version inactive WorkflowTemplateTable::instance()->restartWorkflow($workflowtemplate_id[0]['workflowtemplate_id']); // remove stopflag from template $wfRestart = new RestartWorkflow(); // set flag if workflow uses old values or not $wfRestart->setNewValue($newValue); //load the data for fields. they contain old values or the default field values. the data array contains slots and its fields, values and users of the last version $data = $wfRestart->buildSaveData($slots); // create a new instance of the workflow $wfVersion = new WorkflowVersion(); $wfVersion->setWorkflowtemplateId($workflowtemplate_id[0]['workflowtemplate_id']); $wfVersion->setActiveversion(1); $wfVersion->setContent($content['content']); $wfVersion->setStartworkflowAt($startDate['startworkflowat']); $wfVersion->setContenttype($content['contenttype']); $wfVersion->setWorkflowisstarted($startDate['workflowisstarted']); $wfVersion->setVersion($currentVersion[0]['version']+1); $wfVersion->save(); $newVersionId = $wfVersion->getId(); /* * to transfer the last version of the workflow into a new one, it is needed to copy * the old version and set new relations (ids). $slotCounter stores the id's of the * new created slots, user and userproeccess, to replace the old values with the new ones. */ $dataStore = array(); $slotCounter = 0; foreach($data as $slot) { $singleSlot = new WorkflowSlot(); $singleSlot->setWorkflowversionId($newVersionId); $singleSlot->setSlotId($slot['slot_id']); $singleSlot->setPosition($slot['position']); $singleSlot->save(); $slotId = $singleSlot->getId(); // ids of created slots $dataStore[$slotCounter]['slot_id'] = $slotId; $fields = $slot['fields']; // the fields of the slot $users = $slot['users']; // the users of the slot // create the fields for the slot and set the value foreach($fields as $field) { $newField = new WorkflowSlotField(); $newField->setWorkflowslotId($slotId); $newField->setFieldId($field['field_id']); $newField->setPosition($field['position']); $newField->save(); $fieldId = $newField->getId(); switch($field['type']) { case 'TEXTFIELD': $newField = new WorkflowSlotFieldTextfield(); $newField->setWorkflowslotfieldId($fieldId); $newField->setValue($field['items'][0]['value']); $newField->save(); break; case 'CHECKBOX': $newField = new WorkflowSlotFieldCheckbox(); $newField->setWorkflowslotfieldId($fieldId); $newField->setValue($field['items'][0]['value']); $newField->save(); break; case 'NUMBER': $newField = new WorkflowSlotFieldNumber(); $newField->setWorkflowslotfieldId($fieldId); $newField->setValue($field['items'][0]['value']); $newField->save(); break; case 'DATE': $newField = new WorkflowSlotFieldDate(); $newField->setWorkflowslotfieldId($fieldId); $newField->setValue($field['items'][0]['value']); $newField->save(); break; case 'TEXTAREA': $newField = new WorkflowSlotFieldTextarea(); $newField->setWorkflowslotfieldId($fieldId); $newField->setValue($field['items'][0]['value']); $newField->save(); break; case 'RADIOGROUP': $items = $field['items']; foreach($items as $item) { $newField = new WorkflowSlotFieldRadiogroup(); $newField->setWorkflowslotfieldId($fieldId); $newField->setFieldradiogroupId($item['fieldradiogroup_id']); $newField->setValue($item['value']); $newField->setPosition($item['position']); $newField->save(); } break; case 'CHECKBOXGROUP': $items = $field['items']; foreach($items as $item) { $newField = new WorkflowSlotFieldCheckboxgroup(); $newField->setWorkflowslotfieldId($fieldId); $newField->setFieldcheckboxgroupId($item['fieldradiogroup_id']); $newField->setValue($item['value']); $newField->setPosition($item['position']); $newField->save(); } break; case 'COMBOBOX': $items = $field['items']; foreach($items as $item) { $newField = new WorkflowSlotFieldCombobox(); $newField->setWorkflowslotfieldId($fieldId); $newField->setFieldcomboboxId($item['fieldradiogroup_id']); $newField->setValue($item['value']); $newField->setPosition($item['position']); $newField->save(); } break; case 'FILE': $moveFile = new FileUpload(); $moveFile->moveFile($field['items'][0], $newVersionId,$workflowtemplate_id[0]['workflowtemplate_id'], $request->getParameter('versionid')); $newField = new WorkflowSlotFieldFile(); $newField->setWorkflowslotfieldId($fieldId); $newField->setFilename($field['items'][0]['filename']); $newField->setHashname($field['items'][0]['hashname']); $newField->save(); break; } } // save the users for a slot $userCounter = 0; foreach($users as $user) { $wfSlotUser = new WorkflowSlotUser(); $wfSlotUser->setWorkflowslotId($slotId); $wfSlotUser->setPosition($user['position']); $wfSlotUser->setUserId($user['user_id']); $wfSlotUser->save(); // store the new id of the user and its user_id $dataStore[$slotCounter]['slotuser_id'][$userCounter]['id'] = $wfSlotUser->getId(); $dataStore[$slotCounter]['slotuser_id'][$userCounter++]['user_id'] = $user['user_id']; } $slotCounter++; } /** * save files from file grid in overview. * files are moved forom ext * $keys[0]['uploadfile']->file1 * $keys[1]['uploadfile']->file2 * it is also necessary to use $_FILES instead of $request->getFiles() */ $files = $_FILES; $keys = array(); $keys = array_keys($files); for($a=0;$a<count($keys);$a++) { $key = $keys[$a]; if(substr_count($key, 'uploadfile') == 1) { $fileUpload = new FileUpload(); $fileUpload->uploadFile($files[$key],$newVersionId,$workflowtemplate_id[0]['workflowtemplate_id']); } } $workflowTemplate = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($version_id)->toArray(); $sendToAllSlotsAtOnce = MailinglistVersionTable::instance()->getActiveVersionById($workflowTemplate[0]['mailinglisttemplateversion_id'])->toArray(); if($request->getPostParameter('restartWorkflowFirstTab_startpoint') == 'BEGINNING'){ // workflow starts from beginning // check if mailinglist is send to all slots at once, no workflowprocessuser data is needed to be loaded if($sendToAllSlotsAtOnce[0]['sendtoallslotsatonce'] == 1) { // create all slots $calc = new CreateWorkflow($newVersionId); $calc->setServerUrl(str_replace('/layout', '', url_for('layout/index',true))); $calc->setContext($context); $calc->addAllSlots(); } else { // create a single slot $calc = new CreateWorkflow($newVersionId); $calc->setServerUrl(str_replace('/layout', '', url_for('layout/index',true))); $calc->setContext($context); $calc->addSingleSlot(); } } else if ($request->getPostParameter('restartWorkflowFirstTab_startpoint') == 'LASTSTATION') { // workflow is send to last station $wfRestart = new RestartWorkflow(); $wfRestart->setContext($context); $wfRestart->setServerUrl(str_replace('/layout', '', url_for('layout/index',true))); // load the workflowprocessuser / workflowprocess data of the old version $lastStationdata = $wfRestart->getRestartData($version_id); // write the oldversions workflowprocessuser/workflowprocess and set the new id's from $dataStore array $wfRestart->restartAtLastStation($lastStationdata, $dataStore, $newVersionId, $workflowtemplate_id[0]['workflowtemplate_id']); } else { // workflow will start at specific station $slotOrder = array(); $slotOrder = explode('__', $request->getPostParameter('restartWorkflowFirstTab_startpointid')); $slotPosition = $slotOrder[1]; // Slot Position worklfow must start $userPosition = $slotOrder[3]; // position of the user in the slot. e.g. Slot 3 and User 2 $currentUserSlotId = $dataStore[0]['slotuser_id'][0]['id']; // get Id of the first WorkflowSlot of the restarted Workflow $newUserSlotId = $dataStore[$slotPosition-1]['slotuser_id'][$userPosition-1]['id']; // get Id of the first WorkflowSlotUser of the restarted Workflow $direction = 'UP'; // direction is UP! // write first Process $wfProcess = new WorkflowProcess(); $wfProcess->setWorkflowtemplateId($workflowtemplate_id[0]['workflowtemplate_id']); $wfProcess->setWorkflowversionId($newVersionId); $wfProcess->setWorkflowslotId($dataStore[0]['slot_id']); $wfProcess->save(); $wfProcessId = $wfProcess->getId(); // write first user $wfProcessUser = new WorkflowProcessUser(); $wfProcessUser->setWorkflowprocessId($wfProcessId); $wfProcessUser->setWorkflowslotuserId($dataStore[0]['slotuser_id'][0]['id']); $wfProcessUser->setUserId($dataStore[0]['slotuser_id'][0]['user_id']); $wfProcessUser->setInprogresssince(time()); $wfProcessUser->setDecissionstate('WAITING'); $wfProcessUser->setDateofdecission(time()); $wfProcessUser->setResendet(0); $wfProcessUser->save(); // use Set Nextstation with direction UP from slot 1 user 1 to defined user e.g. slot 3 and user 2 $calc = new SetStation($newVersionId, $newUserSlotId, $currentUserSlotId, $direction, $context, str_replace('/layout', '', url_for('layout/index',true))); } /** * set the response of the action. * it is needed to use this response when using fileupload in extjs with symfony. * extjs is uploading files using iframe. this iframe needs text/html as response */ $this->getResponse()->setHttpHeader('Content-Type','text/html; charset=utf-8'); $json = array('success' => true); $string = '<textarea>'.json_encode($json).'</textarea>'; $this->renderText($string); return sfView::NONE; }
/** * Load all Fields for the tab: Fields when starting creation process * @param sfWebRequest $request * @return <type> */ public function executeLoadAllField(sfWebRequest $request) { $workflowObj = new Workflow(); $workflowObj->setContext($this->getContext()); $mailinglistVersion = MailinglistVersionTable::instance()->getSingleVersionById($request->getParameter('id'))->toArray(); $documenttemplateVersion = DocumenttemplateVersionTable::instance()->getVersionById($mailinglistVersion[0]['documenttemplateversion_id'])->toArray(); $result = $workflowObj->buildSlots($documenttemplateVersion); $this->renderText('{"result":'.json_encode($result).'}'); return sfView::NONE; }