public function createDashboard()
{
$role = new Role();
$role->setDecisionId($this->id);
$role->setName('Collect everything');
$role->setComment('Collect everything is linked to the Overview -page reporting table. <br><br>If you delete this survey your responses on the overview page will be removed.');
$role->setUpdateable(true);
$role->setDashboard(true);
$role->setActive(true);
$response = new Response();
$response->setDecisionId($this->id);
$response->setIpAddress('127.0.0.1');
$response->setEmailAddress('dashboard');
$role->Response->add($response);
$role->Response->save();
if ($this->Template->name == 'Default') {
$role_estimates = new Role();
$role_estimates->setDecisionId($this->id);
$role_estimates->setName('Collect Estimates');
$role_estimates->setUpdateable(false);
$role_estimates->setActive(true);
$role_estimates->save();
$role_value = new Role();
$role_value->setDecisionId($this->id);
$role_value->setName('Collect input on Value');
$role_value->setUpdateable(false);
$role_value->setActive(true);
$role_value->save();
$role_usability = new Role();
$role_usability->setDecisionId($this->id);
$role_usability->setName('Collect input on Usability');
$role_usability->setUpdateable(false);
$role_usability->setActive(true);
$role_usability->save();
$role_feasibility = new Role();
$role_feasibility->setDecisionId($this->id);
$role_feasibility->setName('Collect input on Feasibility');
$role_feasibility->setUpdateable(false);
$role_feasibility->setActive(true);
$role_feasibility->save();
// create the default item for project
$alternative = new Alternative();
$alternative->setDecisionId($this->id);
$alternative->setName('Sample item');
$alternative->setStatus('Reviewed');
$alternative->save();
$popularCriteria = PopularCriterionTable::getInstance()->getDashboardDefaultList();
foreach ($popularCriteria as $popularCriterion) {
$criterion = new Criterion();
$criterion->setName($popularCriterion->name);
$criterion->setMeasurement($popularCriterion->measurement);
$criterion->setDescription($popularCriterion->description);
$criterion->setVariableType($popularCriterion->variable_type);
$criterion->setDecisionId($this->id);
$criterion->save();
// set default response as 3 for default item
if ($popularCriterion->measurement == 'five point scale') {
$alternative_measurement = new AlternativeMeasurement();
$alternative_measurement->setAlternativeHeadId($alternative->id);
$alternative_measurement->setScore(3);
$alternative_measurement->setResponseId($response->id);
$alternative_measurement->setRatingMethod($criterion->getMeasurement());
$alternative_measurement->setCriterionId($criterion->id);
$alternative_measurement->save();
}
// show by default in the Survey (create default matrix of the default roles)
$array = array('Hour Estimate' => $role_estimates->id, 'Feasibility' => $role_feasibility->id, 'Usability' => $role_usability->id, 'Value' => $role_value->id);
if (isset($array[$popularCriterion->name])) {
$planned = new PlannedAlternativeMeasurement();
$planned->setRoleId($array[$popularCriterion->name]);
$planned->setAlternativeId($alternative->id);
$planned->setCriterionId($criterion->id);
$planned->save();
$cplanned = new PlannedCriterionPrioritization();
$cplanned->setCriterionId($criterion->id);
$cplanned->setRoleId($array[$popularCriterion->name]);
$cplanned->save();
}
}
} else {
foreach ($this->Template->CriteriaTemplate as $criterionTemplate) {
$criterion = new Criterion();
$criterion->setDecisionId($this->id);
$criterion->setName($criterionTemplate->name);
$criterion->setMeasurement($criterionTemplate->measurement);
$criterion->setVariableType($criterionTemplate->variable_type);
$criterion->save();
}
foreach ($this->Template->RoleTemplate as $roleTemplate) {
$role = new Role();
$role->setDecisionId($this->id);
$role->setName($roleTemplate->name);
$role->save();
}
}
}
public function getAlternativeMeasurementCreateResponse(sfGuardUser $user)
{
/** @var sfWebRequest $request */
$request = $this->getRequest();
$role = RoleTable::getInstance()->getOneForUser($user, $request->getParameter('role_id'));
if (is_object($role)) {
$plannedMeasurement = new PlannedAlternativeMeasurement();
$plannedMeasurement->Role = $role;
$plannedMeasurement->criterion_id = $request->getParameter('criterion_id');
$plannedMeasurement->alternative_id = $request->getParameter('alternative_id');
try {
$plannedMeasurement->save();
$result = array('status' => 'success', 'result' => $plannedMeasurement->getAPIData());
} catch (sfException $ex) {
$result = array('status' => 'error', 'error' => $ex->getMessage());
}
} else {
$result = array('status' => 'error', 'error' => sprintf('Project with id %d does not exist', $request->getParameter('decision_id')));
}
return $result;
}
public function executeAlternativeImport(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
$decision_id = $request->getParameter('decision_id', false);
/** @var Decision $decision */
$decision = DecisionTable::getInstance()->getDecisionForUser($this->getUser()->getGuardUser(), $decision_id);
$fileValidator = new sfValidatorFile(array('required' => true));
$importer = new AlternativeImporter();
$importer->setDecision($decision);
$importer->setCreatedAndUpdatedBy(Alternative::generateUpdateAndCreatedBy($this->getUser()->getGuardUser()));
foreach ($request->getFiles('files') as $file) {
$validatedFile = $fileValidator->clean($file);
$importer->setFile($validatedFile);
$importer->import();
}
$dashboard_role = $decision->getDashboardRole();
if ($dashboard_role) {
foreach ($importer->getAlternatives() as $alternative) {
foreach ($decision->getCriterion() as $criterion) {
$planned_alternative_measurement = new PlannedAlternativeMeasurement();
$planned_alternative_measurement->setAlternative($alternative);
$planned_alternative_measurement->setCriterion($criterion);
$dashboard_role->PlannedAlternativeMeasurement->add($planned_alternative_measurement);
}
}
$dashboard_role->PlannedAlternativeMeasurement->save();
}
$this->setLayout(false);
$this->getResponse()->setHttpHeader('Content-Type', 'application/json; charset=utf-8');
return $this->renderText(json_encode(array(array())));
}
/**
* @param sfWebRequest $request
* @return sfView
* @throws Doctrine_Collection_Exception
* @throws sfError404Exception
*/
public function executeImportFromTrello(sfWebRequest $request)
{
$decision_id = $request->getParameter('decision_id', false);
$decision = DecisionTable::getInstance()->getDecisionForUser($this->getUser()->getGuardUser(), $decision_id);
$this->forward404Unless(is_object($decision));
$decision->setExternalId($request->getParameter('board_id'));
$decision->save();
$dashboard_role = $decision->getDashboardRole();
foreach (json_decode($request->getParameter('cards', '{}')) as $card) {
$alternative = new Alternative();
$alternative->setName($card->name);
$alternative->setDecisionId($decision->getId());
$alternative->setAdditionalInfo($card->desc);
$alternative->setNotes($card->notes);
$alternative->setExternalId($card->id);
$alternative->setCreatedBy($request->getParameter('full_name') . ' (via Trello)');
$alternative->setUpdatedBy($request->getParameter('full_name') . ' (via Trello)');
if ($card->due) {
$date = DateTime::createFromFormat('Y-m-d\\TH:i:s.000Z', $card->due);
$alternative->setDueDate($date->format('Y-m-d H:i:s'));
$alternative->setNotifyDate($date->format('Y-m-d H:i:s'));
}
$alternative->save();
foreach ($card->labels as $label) {
Tag::newTag($this->getUser()->getGuardUser(), $alternative->getId(), $label, 'alternative');
}
if ($dashboard_role) {
foreach ($decision->getCriterion() as $criterion) {
$planned_alternative_measurement = new PlannedAlternativeMeasurement();
$planned_alternative_measurement->setAlternative($alternative);
$planned_alternative_measurement->setCriterion($criterion);
$dashboard_role->PlannedAlternativeMeasurement->add($planned_alternative_measurement);
}
}
}
$dashboard_role->PlannedAlternativeMeasurement->save();
return $this->renderText(json_encode(array('status' => 'success')));
}
/**
* @param sfWebRequest $request
* @return sfView
*/
public function executeImportFromTrello(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
if (!DecisionTable::getInstance()->verifyAvailableName($this->getUser()->getGuardUser(), $request->getParameter('board_name'))) {
return $this->renderText(json_encode(array('status' => 'error', 'message' => 'A project with that name already exists')));
}
$decision = new Decision();
$decision->setName($request->getParameter('board_name'));
$decision->setUserId($this->getUser()->getGuardUser()->getId());
$decision->setExternalId($request->getParameter('board_id'));
$decision->setTypeId(2);
$type_template = TypeTemplate::getInstance()->createQuery('t')->where('t.user_id is NULL')->andWhere('t.type_id = ?', 2)->andWhere('t.name = ?', 'Default')->fetchOne();
$decision->setTemplateId($type_template->getId());
// Default template
$decision->setFolderId(FolderTable::getInstance()->getNotDeletableForUser($this->getUser()->getGuardUser(), Folder::TYPE_PROJECT)->getId());
$decision->save();
$dashboard_role = $decision->getDashboardRole();
foreach (json_decode($request->getParameter('cards', '{}')) as $card) {
$alternative = new Alternative();
$alternative->setName($card->name);
$alternative->setDecisionId($decision->getId());
$alternative->setAdditionalInfo($card->desc);
$alternative->setNotes($card->notes);
$alternative->setExternalId($card->id);
$alternative->setCreatedBy($request->getParameter('full_name') . ' (via Trello)');
$alternative->setUpdatedBy($request->getParameter('full_name') . ' (via Trello)');
if ($card->due) {
$date = DateTime::createFromFormat('Y-m-d\\TH:i:s.000Z', $card->due);
$alternative->setDueDate($date->format('Y-m-d H:i:s'));
$alternative->setNotifyDate($date->format('Y-m-d H:i:s'));
}
$alternative->save();
foreach ($card->labels as $label) {
Tag::newTag($this->getUser()->getGuardUser(), $alternative->getId(), $label, 'alternative');
}
if ($dashboard_role) {
foreach ($decision->getCriterion() as $criterion) {
$planned_alternative_measurement = new PlannedAlternativeMeasurement();
$planned_alternative_measurement->setAlternative($alternative);
$planned_alternative_measurement->setCriterion($criterion);
$dashboard_role->PlannedAlternativeMeasurement->add($planned_alternative_measurement);
}
}
}
$dashboard_role->PlannedAlternativeMeasurement->save();
if ($request->getParameter('wizard')) {
$user = $this->getUser()->getGuardUser();
$user->setWizard(false);
$user->save();
}
// Create log
$log = new Log();
$log->setAction('project_create');
$log->setUserId($this->getUser()->getGuardUser()->id);
$log->setInformation(json_encode(array('decision_name' => $decision->getName(), 'decision_type' => $decision->getTypeId(), 'decision_template' => $decision->getTemplateId(), 'imported' => 'Trello')));
$log->save();
return $this->renderText(json_encode(array('status' => 'success', 'dashboard_url' => $this->generateUrl('dashboard', array('decision_id' => $decision->getId())))));
}
