/**
* Actions creates a new workflow
*
* @param sfWebRequest $request
* @return <type>
*/
public function executeCreateWorkflow(sfWebRequest $request) {
sfLoader::loadHelpers('Url');
$createWorkObj = new PrepareWorkflowData();
$data = array();
$startDate = array();
$userslot_id = array();
$endreason = $createWorkObj->createEndreason($request->getPostParameter('createWorkflowFirstTabSettings', array())); // additional settings of the workflow
$startDate = $createWorkObj->createStartDate($request->getPostParameter('createWorkflowFirstTab_datepicker'),$request->getPostParameter('createWorkflowFirstTab_timepicker')); // create timestamp and flag if workflow is to start just in time
$content = $createWorkObj->createContenttype($request->getPostParameters()); // create the contenttype of the additionaltext
$sendToAllSlotsAtOnce = MailinglistVersionTable::instance()->getActiveVersionById($request->getPostParameter('createWorkflowFirstTab_mailinglist'))->toArray(); // get flag if mailinglist is send to all slots at once
// save the workflow to main table
$workflow = new WorkflowTemplate();
$workflow->setMailinglisttemplateversionId($sendToAllSlotsAtOnce[0]['id']); // mailinglistversionid
$workflow->setDocumenttemplateversionId($sendToAllSlotsAtOnce[0]['documenttemplateversion_id']); // documenttemplateversionid
$workflow->setName($request->getPostParameter('createWorkflowFirstTab_name'));
$workflow->setSenderId($this->getUser()->getAttribute('id'));
$workflow->setIsarchived(0);
$workflow->setIsstopped(0);
$workflow->setIscompleted(0);
$workflow->setEndaction($endreason);
$workflow->save();
$workflow_id = $workflow->getId();
// save version
$workflowtemplate = new WorkflowVersion();
$workflowtemplate->setWorkflowtemplateId($workflow_id);
$workflowtemplate->setActiveversion(1);
$workflowtemplate->setContent($content['content']);
$workflowtemplate->setStartworkflowAt($startDate['startworkflowat']);
$workflowtemplate->setContenttype($content['contenttype']);
$workflowtemplate->setVersion(1);
$workflowtemplate->setWorkflowisstarted($startDate['workflowisstarted']);
$workflowtemplate->save();
$template_id = $workflowtemplate->getId();
$data = $request->getPostParameter('slot');
$slotposition = 1;
// begin to store the slots for the workflow
foreach($data as $slot) {
$slotObj = new WorkflowSlot();
$slotObj->setSlotId($slot['slot']['id']);
$slotObj->setWorkflowversionId($template_id);
$slotObj->setPosition($slotposition++);
$slotObj->save();
$slot_id = $slotObj->getId();
$users = $slot['user'];
$fields = $slot['slot']['field'];
$userposition = 1;
// start to save
foreach($users as $user) {
$userObj = new WorkflowSlotUser();
$userObj->setWorkflowslotId($slot_id);
$user['id'] = $user['id'] == -2 ? $this->getUser()->getAttribute('id') : $user['id']; // remove the placeholder "workflowsender"
$userObj->setUserId($user['id']);
$userObj->setPosition($userposition++);
$userObj->save();
}
$fieldposition = 1;
foreach($fields as $field) { // save all fields for the current slot
// save parent field element
$fieldObj = new WorkflowSlotField();
$fieldObj->setWorkflowslotId($slot_id);
$fieldObj->setFieldId($field['field_id']);
$fieldObj->setPosition($fieldposition++);
$fieldObj->save();
$field_id = $fieldObj->getId();
// save all field items
switch ($field['type']) {
case 'TEXTFIELD':
$textfield = new WorkflowSlotFieldTextfield();
$textfield->setWorkflowslotfieldId($field_id);
$textfield->setValue($field['value']);
$textfield->save();
break;
case 'CHECKBOX':
$textfield = new WorkflowSlotFieldCheckbox();
$textfield->setWorkflowslotfieldId($field_id);
$textfield->setValue($field['value'] == 'true' ? 1 : 0);
$textfield->save();
break;
case 'NUMBER':
$textfield = new WorkflowSlotFieldNumber();
$textfield->setWorkflowslotfieldId($field_id);
$textfield->setValue($field['value']);
$textfield->save();
break;
case 'DATE':
$textfield = new WorkflowSlotFieldDate();
$textfield->setWorkflowslotfieldId($field_id);
$textfield->setValue($field['value']);
$textfield->save();
break;
case 'TEXTAREA':
$textfield = new WorkflowSlotFieldTextarea();
$textfield->setWorkflowslotfieldId($field_id);
$textfield->setValue($field['value']);
$textfield->save();
break;
case 'RADIOGROUP':
$items = $field['item'];
$counter = 1;
foreach($items as $item) {
$userObj = new WorkflowSlotFieldRadiogroup();
$userObj->setWorkflowslotfieldId($field_id);
$userObj->setFieldradiogroupId($item['id']);
$userObj->setValue($item['value'] == 'true' ? 1 : 0);
$userObj->setPosition($counter++);
$userObj->save();
}
break;
case 'CHECKBOXGROUP':
$items = $field['item'];
$counter = 1;
foreach($items as $item) {
$userObj = new WorkflowSlotFieldCheckboxgroup();
$userObj->setWorkflowslotfieldId($field_id);
$userObj->setFieldcheckboxgroupId($item['id']);
$userObj->setValue($item['value'] == 'true' ? 1 : 0);
$userObj->setPosition($counter++);
$userObj->save();
}
break;
case 'COMBOBOX':
$items = $field['item'];
$counter = 1;
foreach($items as $item) {
$userObj = new WorkflowSlotFieldCombobox();
$userObj->setWorkflowslotfieldId($field_id);
$userObj->setFieldcomboboxId($item['id']);
$userObj->setValue($item['value'] == 'true' ? 1 : 0);
$userObj->setPosition($counter++);
$userObj->save();
}
break;
case 'FILE':
$fieldToStore = $field['filearray'];
$allFiles = $_FILES;
$file = $allFiles[$fieldToStore];
$upload = new FileUpload();
$upload->uploadFormFile($file, $field_id,$template_id,$workflow_id);
}
}
}
/**
* 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],$template_id,$workflow_id);
}
}
$context = sfContext::getInstance();
$context->getConfiguration()->loadHelpers('Partial', 'I18N', 'Url', 'Date', 'CalculateDate', 'ColorBuilder', 'Icon', 'EndAction');
// check is workflow needs to be started at the moment
if($startDate['workflowisstarted'] == 1) {
if($sendToAllSlotsAtOnce[0]['sendtoallslotsatonce'] == 1) { // workflow is send to all slots at once
$calc = new CreateWorkflow($template_id);
$calc->setContext($context);
$calc->setServerUrl(str_replace('/layout', '', url_for('layout/index',true)));
$calc->addAllSlots();
}
else { // workflow is send to single slot first
$calc = new CreateWorkflow($template_id);
$calc->setContext($context);
$calc->setServerUrl(str_replace('/layout', '', url_for('layout/index',true)));
$calc->addSingleSlot();
}
}
/**
* 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;
}
