public function calculateSlot($workflowslot_id) {
$currentSlot = WorkflowSlotTable::instance()->getSlotById($workflowslot_id)->toArray();
$nextSlot = $this->getNextSlot($currentSlot[0]['workflowversion_id'],$currentSlot[0]['position']+1);
if(!empty($nextSlot)) {
$this->calculateStation($nextSlot[0]['id'], 1);
}
}
public function buildSlots(Doctrine_Collection $data, $version_id) {
$result = array();
$mergedResult = array();
$a = 0;
$slots = WorkflowSlotTable::instance()->getSlotByVersionId($version_id);
foreach($slots as $slot) {
$slotname = $slot->getDocumenttemplateSlot()->toArray();
$result[$a]['workflowslot_id'] = $slot->getId();
$result[$a]['slot_id'] = $slot->getSlotId();
$result[$a]['version_id'] = $slot->getId();
$result[$a]['slotname'] = $slotname[0]['name'];
$result[$a]['fields'] = $this->getFields($slot, $version_id);
$result[$a]['isdisabled'] = $this->checkSlotVisability($slot->getId());
$a++;
}
$mergedResult = $this->mergeArray($result, $version_id);
return $mergedResult;
}
/**
*
* 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;
}
/**
*
* 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 setCurrentWorkflowSlot() {
$slot = WorkflowSlotTable::instance()->getSlotById($this->currentWorkflowSlotUser->getWorkflowslotId());
$this->currentWorkflowSlot = $slot[0];
}
/**
* Get the workflowprocess and workflowprocessuser entries of an old version, to rebuild the structure
* when workflow will start at current station
*
* @param int $version_id, old id of the workflow
* @return array $result
*/
public function getRestartData($version_id) {
$result = array();
$a = 0;
// load the slots
$slots = WorkflowSlotTable::instance()->getSlotByVersionId($version_id);
foreach($slots as $slot) {
$documentSlot = $slot->getDocumenttemplateSlot()->toArray();
$b = 0;
$result[$a]['slot_id'] = $slot->getId();
$result[$a]['sendtoallreceivers'] = $documentSlot[0]['sendtoallreceivers'];
$result[$a]['version_id'] = $slot->getWorkflowversionId();
// load the processtable
$wfProcess = WorkflowProcessTable::instance()->getWorkflowProcessBySlotId($slot->getId())->toArray();
if(!empty($wfProcess)) {
foreach($wfProcess as $process) {
$result[$a]['userprocess'][$b] = $process;
// add its processes for a user
$result[$a]['userprocess'][$b]['process'] = $this->addWorkflowProcessUser($process);
$b++;
}
}
else {
$result[$a]['userprocess'][$b] = '';
$b++;
}
$a++;
}
return $result;
}
public function buildWorkflowData(Doctrine_Collection $data, $versionid) {
$slots = WorkflowSlotTable::instance()->getSlotByVersionId($versionid);
$result = array();
$a = 0;
foreach($slots as $slot) {
$slotArray = $slot->toArray();
$result[$a]['workflowslot_id'] = $slotArray['id'];
$result[$a]['slot_id'] = $slotArray['slot_id'];
$result[$a]['position'] = $slotArray['position'];
$result[$a]['slotname'] = $slotArray['DocumenttemplateSlot'][0]['name'];
$result[$a++]['fields'] = $this->getFields($slotArray['id'], $versionid);
}
#print_r ($result);die;
return $result;
}
/**
* Load all Workflowslots for an workflowversion
*/
public function getSlots() {
$this->slots = WorkflowSlotTable::instance()->getSlotByVersionId($this->version_id);
}
public function getProcess($version_id) {
$slots = WorkflowSlotTable::instance()->getSlotByVersionId($version_id);
$alreadyCompleted = 0;
$toComplete = 0;
foreach($slots as $slot) {
$users = WorkflowSlotUserTable::instance()->getUserBySlotId($slot->getId());
$toComplete += count($users);
foreach($users as $user) {
$processUser = WorkflowProcessUserTable::instance()->getProcessUserByWorkflowSlotUserId($user->getId())->toArray();
if(!empty($processUser)) {
$waiting = true;
foreach($processUser as $process) {
if(count($processUser) == 1 AND $process['decissionstate'] != 'WAITING') {
$alreadyCompleted++;
}
else {
if($process['decissionstate'] != 'WAITING') {
$waiting = false;
}
else {
$waiting = true;
}
}
}
if(count($processUser) > 1 AND $waiting == false) {
$alreadyCompleted++;
}
}
}
}
$percentDone = ($toComplete/$toComplete);
$fullPercentDone = 100 / $toComplete;
$percentDone = $fullPercentDone * $alreadyCompleted;
if($percentDone > 100) {
$percentDone = 100;
}
$color = '';
if($percentDone < 15) {
}
else if ($percentDone >= 15 AND $percentDone < 30) {
$color = '#FF0000';
}
else if ($percentDone >= 30 AND $percentDone < 45) {
$color = '#FF9933';
}
else if ($percentDone >= 45 AND $percentDone < 60) {
$color = '#FFCC33';
}
else if ($percentDone >= 60 AND $percentDone < 75) {
$color = '#FFFF33';
}
else if ($percentDone >= 75 AND $percentDone < 90) {
$color = '#99FF99';
}
else {
$color = '#00FF00';
}
return '<div style="background-color:'.$color.'; width:'.$percentDone.'px;">'.floor($percentDone) . ' %'.'</div>';
}
/**
* 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;
}
/**
* Function is needed, when a worklow is sendet to all slots at once.
* This function checks if each Entry from WorkflowProcessUser is != WAITING
*
* If no user needs to fill out the workflow, the workflow is completed and flag will be set
*/
public function checkSendToAllAtOnce() {
if($this->sendToAllAtOnce == 1) {
$slots = WorkflowSlotTable::instance()->getSlotByVersionId($this->version_id);
$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($this->workflowtemplate_id);
$this->checkEndAction();
}
}
}