protected function execute($arguments = array(), $options = array()) { $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $context = sfContext::createInstance($this->configuration); sfProjectConfiguration::getActive()->loadHelpers('Partial', 'I18N', 'Url'); $serverUrl = $options['setenvironment'] == '' ? $serverUrl = $options['host'] : $serverUrl = $options['host'] . '/' . $options['setenvironment']; $workflows = WorkflowVersionTable::instance()->getWorkflowsToStart(time())->toArray(); foreach($workflows as $workflow) { $sender = WorkflowTemplateTable::instance()->getWorkflowTemplateById($workflow['workflowtemplate_id'])->toArray(); $userSettings = new UserMailSettings($sender[0]['sender_id']); $sendMail = new SendStartWorkflowEmail($userSettings, $context, $workflow, $sender, $serverUrl); $workflowTemplate = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($workflow['id']); WorkflowVersionTable::instance()->startWorkflowInFuture($workflow['id']); $sendToAllSlotsAtOnce = $workflowTemplate[0]->getMailinglistVersion()->toArray(); if($sendToAllSlotsAtOnce[0]['sendtoallslotsatonce'] == 1) { $calc = new CreateWorkflow($workflow['id']); $calc->setServerUrl($serverUrl); $calc->setContext($context); $calc->addAllSlots(); } else { $calc = new CreateWorkflow($workflow['id']); $calc->setServerUrl($serverUrl); $calc->setContext($context); $calc->addSingleSlot(); } } }
/** * * @param array $data, contains reason for deny * @param int $workflowid, workflow id * @param int $userId, user id * @param int $versionId, version id * @return <type> */ public function denyWorkflow(array $data, $workflowid, $userId, $versionId) { WorkflowTemplateTable::instance()->stopWorkflow($workflowid, $userId); WorkflowVersionTable::instance()->setEndReason($versionId, $data['workfloweditAcceptWorkflow_reason']); $workflowToStop = WorkflowProcessUserTable::instance()->getWaitingStationToStopByUser($versionId); foreach($workflowToStop as $itemToChange) { $pdoObj = Doctrine::getTable('WorkflowProcessUser')->find($itemToChange->getId()); $pdoObj->setDecissionstate('STOPPEDBYUSER'); $pdoObj->setDateofdecission(time()); $pdoObj->save(); } return true; }
/** * Load all workflows, when filter functionality is used * @param sfWebRequest $request * @return <type> */ public function executeLoadAllArchivedWorkflowByFilter(sfWebRequest $request) { $limit = $this->getUser()->getAttribute('userSettings'); $workflow = new WorkflowOverview($this->getContext(), $this->getUser()); $workflow->setUserId($this->getUser()->getAttribute('id')); $workflow->setCulture($this->getUser()->getCulture()); $filter = new FilterManagement(); $filterOptions = $filter->checkFilter($request); $anz = WorkflowTemplateTable::instance()->getAllArchivedWorkflowTemplatesByFilter(-1,-1, $filterOptions); $data = WorkflowTemplateTable::instance()->getAllArchivedWorkflowTemplatesByFilter($request->getParameter('limit',$limit['displayeditem']),$request->getParameter('start',0), $filterOptions); $json_data = $workflow->buildData($data, $request->getParameter('start',0)); $this->renderText('({"total":"'.count($anz).'","result":'.json_encode($json_data).'})'); return sfView::NONE; }
/** * Load all data, wich is needed to fill out an workflow * generalData like sender, creation date is loaded * slotData, all slots to fill out * workflowAttachment, load public attachments * userData: tree on left side, to show current process * showName: flag if users can be shown in the left side or not * * @param sfWebRequest $request * @return <type> */ public function executeLoadWorkflowData(sfWebRequest $request) { sfLoader::loadHelpers('EndAction'); $detailsObj = new WorkflowDetail(); $detailsObj->setUser($this->getUser()); $detailsObj->setCulture($this->getUser()->getCulture()); $detailsObj->setContext($this->getContext()); $workflowsettings = WorkflowVersionTable::instance()->getWorkflowVersionById($request->getParameter('versionid')); $generalData = $detailsObj->buildHeadLine($workflowsettings); $attachments = $detailsObj->buildAttachments($workflowsettings, $request->getParameter('versionid')); $userData = $detailsObj->buildUserData($workflowsettings, $request->getParameter('versionid')); $workflowDecission = WorkflowTemplateTable::instance()->getWorkflowTemplateById($workflowsettings[0]->getWorkflowtemplateId())->toArray(); $endAction = getEndAction($workflowDecission[0]['endaction']); $slotObj = new WorkflowEdit(); $slotObj->setUser($this->getUser()); $slotObj->setCulture($this->getUser()->getCulture()); $slotObj->setContext($this->getContext()); $slotData = $slotObj->buildSlots($workflowsettings, $request->getParameter('versionid')); $this->renderText('{"generalData":'.json_encode($generalData).',"slotData":'.json_encode($slotData).', "workflowAttachment" : '.json_encode($attachments).', "userData" : '.json_encode($userData).',"showName": '.$endAction[0].'}'); return sfView::NONE; }
/** * Function sends systemmesage, and loads all sender * * @param sfWebRequest $request * @return <type> */ public function executeSendMail(sfWebRequest $request) { $subject = $request->getParameter('subject'); $type = $request->getParameter('type'); $content = $request->getParameter('description'); $decission = $request->getParameter('receiver'); switch ($decission) { case 'ALL': $users = UserLoginTable::instance()->getAllUser(-1, -1)->toArray(); // load all user break; case 'SENDER': $users = WorkflowTemplateTable::instance()->getWorkflowSender()->toArray(); // load sender only break; case 'ONLINE': $currentTime = time(); $fiveMinutes = (1 * 60)*5; $fiveMinutesAgo = $currentTime - $fiveMinutes; $users = UserDataTable::instance()->getOnlineUser($fiveMinutesAgo)->toArray(); // user which are online for about 5mins^^ break; } // send messages foreach($users as $user) { if($decission == 'SENDER') { $userData = new UserMailSettings($user['sender_id']); } elseif ($decission == 'ALL') { $userData = new UserMailSettings($user['id']); } else { $userData = new UserMailSettings($user['user_id']); } $send = new SendMessage(); $send->sendSystemMail($userData, $subject, $content, $type); } $this->renderText('{success:true}'); return sfView::NONE; }
protected function execute($arguments = array(), $options = array()) { // initialize the database connection $databaseManager = new sfDatabaseManager($this->configuration); $connection = $databaseManager->getDatabase($options['connection'] ? $options['connection'] : null)->getConnection(); $context = sfContext::createInstance($this->configuration); sfProjectConfiguration::getActive()->loadHelpers('Partial', 'I18N', 'Url'); $serverUrl = $options['setenvironment'] == '' ? $serverUrl = $options['host'] : $serverUrl = $options['host'] . '/' . $options['setenvironment']; $wfSettings = SystemConfigurationTable::instance()->getSystemConfiguration()->toArray(); if($wfSettings[0]['sendremindermail'] == 1) { $sendMail = new PrepareReminderEmail(); $stillOpenWorkflows = array(); $a = 0; $openWorkflows = WorkflowTemplateTable::instance()->getAllRunningWorkflows(); foreach($openWorkflows as $workflow) { $openStations = WorkflowProcessUserTable::instance()->getWaitingStationByVersionId($workflow['WorkflowVersion']['id'])->toArray(); $data = $sendMail->prepareData($openStations); $stillOpenWorkflows[$a]['workflow_id'] = $workflow['id']; $stillOpenWorkflows[$a]['name'] = $workflow['name']; $stillOpenWorkflows[$a]['workflowversion_id'] = $workflow['WorkflowVersion']['id']; $stillOpenWorkflows[$a++]['users'] = $data; } $stillOpenWorkflows = $sendMail->sortByUser($stillOpenWorkflows); foreach($stillOpenWorkflows as $userToSend) { $umSettings = new UserMailSettings($userToSend['user_id']); $reminder = new SendReminderEmail($umSettings,$context, $userToSend, $serverUrl); } } // add your code here }
/** * * This function tries to load the next WorkflowSlot. * First the complete SLotData is loaded and then theres a try to load the * next Slot. If no slot available, the Worklfow has reached the end * If a new slot is found addNewSlot method is called * * * @param int $currentWorkflowSlotId, is the id of the current WorkflowSlot */ public function checkForNewSlot($currentWorkflowSlotId) { $currentSlot = WorkflowSlotTable::instance()->getSlotById($currentWorkflowSlotId)->toArray(); $nextSlot = WorkflowSlotTable::instance()->getSlotByWorkflowversionAndPosition($currentSlot[0]['workflowversion_id'],$currentSlot[0]['position']+1); $slotArray = $nextSlot->toArray(); if(empty($slotArray) == true AND $this->nextStation->sendToAllAtOnce != 1) { // workflow has finifshed WorkflowTemplateTable::instance()->setWorkflowFinished($this->nextStation->workflowtemplate_id); $this->nextStation->checkEndAction(); } else { if($this->nextStation->sendToAllAtOnce == 0) { $this->addNewSlot($nextSlot); } } }
public function setWorkflowTemplateSettings($workflowtemplateId) { $data = WorkflowTemplateTable::instance()->getWorkflowTemplateById($workflowtemplateId)->toArray(); $this->workflowTemplateSettings = $data[0]; }
/** * Function retuns flag if slot is send to all at once * @param int $versionid, version id * @return boolean */ public function getSendToAllSlots($versionid) { $template = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($versionid)->toArray(); $mailinglist = MailinglistTemplateTable::instance()->getMailinglistByVersionId($template[0]['mailinglisttemplateversion_id']); return $mailinglist[0]['MailinglistVersion']['sendtoallslotsatonce']; }
public function stopWorkflow($workflow_id, $version_id, $user_id, $endreason) { WorkflowTemplateTable::instance()->stopWorkflow($workflow_id, $user_id); WorkflowVersionTable::instance()->setEndReason($version_id, $endreason); WorkflowProcessUserTable::instance()->setWaitingStationToStoppedByUser($version_id); }
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; }
/** * 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; }
public function setWorkflow($versionId) { $data = WorkflowTemplateTable::instance()->getWorkflowTemplateByVersionId($versionId)->toArray(); $this->workflow = $data[0]; }
public function checkEndAction() { sfLoader::loadHelpers('EndAction'); $data = getEndAction($this->workflowversion[0]['endaction']); if($data[0] == 1) { // send notification when workflow is completed $email = new SendWorkflowCompleted($this->workflowversion[0], $this->workflow[0]['id']); } if($data[2] == 1) { // archive workflow WorkflowTemplateTable::instance()->archiveWorkflow($this->workflowversion[0]['id']); } if($data[3] == 1) { // delete workflow WorkflowTemplateTable::instance()->deleteWorkflow($this->workflowversion[0]['id']); } }