/**
* @param PHPPowerPoint_Slide $currentSlide
* @param Decision $decision
*/
private function buildSlide(PHPPowerPoint_Slide $currentSlide, Decision $decision)
{
// Title
$shape = $currentSlide->createRichTextShape();
$shape->setHeight(30);
$shape->setWidth(600);
$shape->setOffsetX(180);
$shape->setOffsetY(50);
$shape->createText($decision->getName());
$shape->getAlignment()->setHorizontal(PHPPowerPoint_Style_Alignment::HORIZONTAL_CENTER);
// Other info
$shape = $currentSlide->createRichTextShape();
$shape->setHeight(500);
$shape->setWidth(920);
$shape->setOffsetX(20);
$shape->setOffsetY(80);
$shape->getAlignment()->setHorizontal(PHPPowerPoint_Style_Alignment::HORIZONTAL_LEFT);
$textRun = $shape->createTextRun('Start/End date');
$textRun->getFont()->setBold(true);
$shape->createTextRun(': ');
if ($decision->getStartDate()) {
$shape->createTextRun(DateTime::createFromFormat('Y-m-d H:i:s', $decision->getStartDate())->format('j M Y'));
} else {
$textRun = $shape->createTextRun('not set');
$textRun->getFont()->setItalic(true);
}
$shape->createTextRun(' - ');
if ($decision->getEndDate()) {
$shape->createTextRun(DateTime::createFromFormat('Y-m-d H:i:s', $decision->getEndDate())->format('j M Y'));
} else {
$textRun = $shape->createTextRun('not set');
$textRun->getFont()->setItalic(true);
}
$shape->createBreak();
$textRun = $shape->createTextRun('Status');
$textRun->getFont()->setBold(true);
$shape->createTextRun(': ' . $decision->getStatus());
$shape->createBreak();
$tags = array();
foreach ($decision->getTagDecision() as $tag_decision) {
$tags[] = $tag_decision->getTag()->getName();
}
$textRun = $shape->createTextRun('Tags');
$textRun->getFont()->setBold(true);
$shape->createTextRun(': ' . implode(', ', $tags));
$shape->createBreak();
$shape->createBreak();
$shape->createTextRun(strip_tags($decision->getObjective()));
if ($this->roadmap->getShowReleases() && count($decision->getProjectRelease())) {
$shape->createBreak();
$shape->createBreak();
$textRun = $shape->createTextRun('Releases');
$textRun->getFont()->setSize(14);
$shape->createBreak();
foreach ($decision->getProjectRelease() as $project_release) {
/** @var ProjectRelease $project_release */
$textRun = $shape->createTextRun(' ' . $project_release->getName());
$textRun->getFont()->setSize(12);
$shape->createBreak();
if ($this->roadmap->getShowItems()) {
foreach ($project_release->getProjectReleaseAlternative() as $project_release_alternative) {
/** @var ProjectReleaseAlternative $project_release_alternative */
$shape->createTextRun(' ' . $project_release_alternative->getAlternative()->getName());
$shape->createBreak();
}
}
}
}
if ($this->roadmap->getShowDependencies()) {
$alternative_relations_text = '';
$alternative_relations = array();
$related_decisions = array();
foreach ($decision->getAlternative() as $alternative) {
/** @var $alternative Alternative */
if (count($alternative->getAlternativeRelation())) {
$alternative_relations[$alternative->getId()]['alternative'] = $alternative;
foreach ($alternative->getAlternativeRelation() as $relation) {
/** @var $relation AlternativeRelation */
$related_decisions[$relation->getAlternativeTo()->getDecisionId()] = $relation->getAlternativeTo()->getDecision()->getName();
$alternative_relations[$alternative->getId()]['relations'][$relation->getAlternativeTo()->getDecisionId()]['decision'] = $relation->getAlternativeTo()->getDecision();
$alternative_relations[$alternative->getId()]['relations'][$relation->getAlternativeTo()->getDecisionId()]['linked_alternatives'][] = $relation->getAlternativeTo();
}
}
}
if (count($alternative_relations)) {
$shape->createBreak();
$shape->createTextRun('This project has dependency to project(s) ' . implode(', ', $related_decisions))->getFont()->setBold(true);
foreach ($alternative_relations as $alternative_relation) {
foreach ($alternative_relation['relations'] as $relation) {
$temp_linked_alternatives = array();
foreach ($relation['linked_alternatives'] as $linked_alternative) {
$temp_linked_alternatives[] .= $linked_alternative->getName();
}
$shape->createBreak();
$shape->createTextRun(' - ' . $alternative_relation['alternative']->getName() . " has dependency to " . implode(', ', $temp_linked_alternatives) . " in project " . $relation['decision']->getName());
}
}
}
}
}
/**
* @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())))));
}
