public function advancedImport()
{
foreach ($this->prepareData() as $item) {
$alternative = null;
if (array_key_exists('id', $item) && !empty($item['id'])) {
$alternative = AlternativeTable::getInstance()->createQuery('a')->leftJoin('a.Decision d')->leftJoin('d.User u')->leftJoin('u.TeamMember tm')->whereIn('d.user_id', sfGuardUserTable::getInstance()->getUsersInTeamIDs($this->guard_user))->andWhere('a.item_id = ?', $item['id'])->andWhere('d.id = ?', $this->decision->getId())->fetchOne();
}
if (!is_object($alternative)) {
$alternative = new Alternative();
$alternative->setDecision($this->decision);
$alternative->setCreatedBy($this->created_and_updated_by);
$alternative->setUpdatedBy($this->created_and_updated_by);
}
$alternative->setName($item['name']);
foreach (array('status', 'work progress', 'additional info', 'notes', 'due date', 'notify date') as $prop) {
if (array_key_exists($prop, $item) && !empty($item[$prop])) {
$alternative->{str_replace(' ', '_', $prop)} = $item[$prop];
}
}
if (array_key_exists('tags', $item)) {
// Process tags
$tags_request = array_map('trim', explode(',', $item['tags']));
$tags = array();
foreach ($alternative->getTagAlternative() as $tag) {
$tags[] = $tag->Tag->name;
}
foreach (array_diff($tags_request, $tags) as $result) {
Tag::newTag($this->guard_user, $alternative->getId(), $result, 'alternative');
}
foreach (array_diff($tags, $tags_request) as $result) {
Tag::removeTag($this->guard_user, $alternative->getId(), $result, 'alternative');
}
}
$alternative->save();
}
}
/**
* @param sfWebRequest $request
* @return sfView|string
*/
public function executeUpdateRelease(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
$this->forward404Unless($request->isMethod(sfRequest::POST) || $request->isMethod(sfRequest::PUT));
$this->forward404Unless($object = Doctrine_Core::getTable($this->model)->find(array($request->getParameter('id'))), sprintf('Object decision does not exist (%s).', $request->getParameter('id')));
$formClass = $this->model . 'Form';
$this->form = new $formClass($object, array('user' => $this->getUser()));
$this->form->bind($request->getParameter($this->form->getName()), $request->getFiles($this->form->getName()));
if ($this->form->isValid()) {
$this->form->save();
$this->form_valid = true;
// Process tags
$tags_request = json_decode($request->getParameter('tags'));
$tags = array();
foreach ($object->getTagRelease() as $tag) {
$tags[] = $tag->Tag->name;
}
foreach (array_diff($tags_request, $tags) as $result) {
Tag::newTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'release');
}
foreach (array_diff($tags, $tags_request) as $result) {
Tag::removeTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'release');
}
$object->refresh(true);
// Create log
$log = new Log();
$log->injectDataAndPersist($object, $this->getUser()->getGuardUser(), array('action' => 'edit'));
return $this->renderText(json_encode(array('id' => $object->id, 'name' => $object->name)));
}
return $this->renderPartial('form', array('form' => $this->form));
}
public function executeUpdate(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
$this->forward404Unless($request->isMethod(sfRequest::POST) || $request->isMethod(sfRequest::PUT));
$this->forward404Unless($alternative = Doctrine_Core::getTable($this->model)->find(array($request->getParameter('id'))), sprintf('Object decision does not exist (%s).', $request->getParameter('id')));
$form = new AlternativeForm($alternative, array('user' => $this->getUser()));
$alternative->setUpdatedBy(Alternative::generateUpdateAndCreatedBy($this->getUser()->getGuardUser()));
$form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
if ($form->isValid()) {
$form->save();
// Create log
$log = new Log();
$log->injectDataAndPersist($alternative, $this->getUser()->getGuardUser(), array('action' => 'edit'));
// Process tags
$tags_request = json_decode($request->getParameter('tags'));
$tags = array();
foreach ($alternative->getTagAlternative() as $tag) {
$tags[] = $tag->Tag->name;
}
foreach (array_diff($tags_request, $tags) as $result) {
Tag::newTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'alternative');
}
foreach (array_diff($tags, $tags_request) as $result) {
Tag::removeTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'alternative');
}
// Process links
$links = array();
foreach ($alternative->getAlternativeLink() as $link) {
$links[$link->id] = $link->link;
}
$links_request_new = array();
$links_request_old = array();
$links_request = json_decode($request->getParameter('links'), true);
foreach ($links_request as $link_request) {
if (is_array($link_request) && array_key_exists('id', $link_request)) {
$links_request_old[$link_request['id']] = $link_request['link'];
} else {
$links_request_new[] = $link_request;
}
}
foreach ($links_request_new as $link_request_new) {
$link = new AlternativeLink();
$link->link = $link_request_new['link'];
$link->alternative_id = $request->getParameter('id');
$link->save();
}
foreach (array_diff(array_keys($links), array_keys($links_request_old)) as $result) {
AlternativeLinkTable::getInstance()->find($result)->delete();
}
foreach ($links_request_old as $key => $link) {
if ($links_request_old[$key] !== $links[$key]) {
$alternative_link = AlternativeLinkTable::getInstance()->find($key);
$alternative_link->link = $links_request_old[$key];
$alternative_link->save();
}
}
// Process related alternatives
$related_alternatives_request = json_decode($request->getParameter('related_alternatives'), true);
if (!$related_alternatives_request) {
$related_alternatives_request = array();
}
$related_alternatives = array();
foreach ($alternative->getAlternativeRelation() as $related_alternative) {
$related_alternatives[] = $related_alternative->to_id;
}
foreach (array_diff($related_alternatives_request, $related_alternatives) as $result) {
if (AlternativeTable::getInstance()->getOneForUser($this->getUser()->getGuardUser(), $result)) {
$alternative_relation = new AlternativeRelation();
$alternative_relation->setFromId($alternative->getId());
$alternative_relation->setToId($result);
$alternative_relation->setCreatedBy(Alternative::generateUpdateAndCreatedBy($this->getUser()->getGuardUser()));
$alternative_relation->save();
}
}
foreach (array_diff($related_alternatives, $related_alternatives_request) as $result) {
AlternativeRelationTable::getInstance()->findByFromIdAndToId($alternative->getId(), $result)->delete();
}
$alternative->refresh(true);
return $this->renderText(json_encode($alternative->getRowData()));
} else {
return $this->renderPartial('form', array('form' => $form));
}
}
/**
* @param sfWebRequest $request
* @return sfView
*/
public function executeImportFromCustomFields(sfWebRequest $request)
{
$decision_id = $request->getParameter('decision_id', false);
$decision = DecisionTable::getInstance()->getDecisionForUser($this->getUser()->getGuardUser(), $decision_id);
$this->forward404Unless(is_object($decision));
$header = $request->getParameter('header');
$data = $request->getParameter('data');
if (array_search('name', $header) === false) {
return $this->renderText(json_encode(array('status' => 'error', 'text' => 'Please ensure that data field "Name" is mapped to a column in your SpreadSheet.')));
}
foreach ($data as $item) {
$alternative = null;
if (array_key_exists('id', $item) && !empty($item['id'])) {
$alternative = AlternativeTable::getInstance()->createQuery('a')->leftJoin('a.Decision d')->leftJoin('d.User u')->leftJoin('u.TeamMember tm')->whereIn('d.user_id', sfGuardUserTable::getInstance()->getUsersInTeamIDs($this->getUser()->getGuardUser()))->andWhere('a.item_id = ?', $item['id'])->andWhere('d.id = ?', $decision->getId())->fetchOne();
}
if (!is_object($alternative)) {
$alternative = new Alternative();
$alternative->setDecision($decision);
$alternative->setCreatedBy(Alternative::generateUpdateAndCreatedBy($this->getUser()->getGuardUser()));
$alternative->setUpdatedBy(Alternative::generateUpdateAndCreatedBy($this->getUser()->getGuardUser()));
}
$custom_fields = array();
foreach ($item as $prop => $value) {
if (array_key_exists($prop, $header)) {
if ($header[$prop] == '_new') {
$custom_fields[$prop] = $value;
} elseif (!in_array($header[$prop], array('id')) && in_array($header[$prop], array('name', 'status', 'work progress', 'additional info', 'notes', 'due date', 'notify date', 'tags'))) {
if ($header[$prop] == 'tags') {
// Process tags
$tags_request = array_map('trim', explode(',', $value));
$tags = array();
foreach ($alternative->getTagAlternative() as $tag) {
$tags[] = $tag->Tag->name;
}
foreach (array_diff($tags_request, $tags) as $result) {
Tag::newTag($this->getUser()->getGuardUser(), $alternative->getId(), $result, 'alternative');
}
foreach (array_diff($tags, $tags_request) as $result) {
Tag::removeTag($this->getUser()->getGuardUser(), $alternative->getId(), $result, 'alternative');
}
} else {
$alternative->{str_replace(' ', '_', $header[$prop])} = $value;
}
}
}
}
if ($custom_fields) {
$alternative->setCustomFields(json_encode($custom_fields));
}
if (!$alternative->getName()) {
$alternative->setName('New ' . InterfaceLabelTable::getInstance()->get($this->getUser()->getGuardUser(), InterfaceLabelTable::ITEM_TYPE));
}
$alternative->save();
}
return $this->renderText(json_encode(array('status' => 'success')));
}
public function executeUpdate(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
$this->forward404Unless($request->isMethod(sfRequest::POST) || $request->isMethod(sfRequest::PUT));
$this->forward404Unless($decision = Doctrine_Core::getTable('Decision')->find(array($request->getParameter('id'))), sprintf('Object decision does not exist (%s).', $request->getParameter('id')));
$form = new DecisionForm($decision, array('type' => 'edit'));
$form->bind($request->getParameter($form->getName()), $request->getFiles($form->getName()));
if ($form->isValid()) {
$form->save();
$tags_request = json_decode($request->getParameter('tags'));
$tags = array();
foreach ($form->getObject()->getTagDecision() as $tag) {
$tags[] = $tag->Tag->name;
}
foreach (array_diff($tags_request, $tags) as $result) {
Tag::newTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'decision');
}
foreach (array_diff($tags, $tags_request) as $result) {
Tag::removeTag($this->getUser()->getGuardUser(), $request->getParameter('id'), $result, 'decision');
}
return $this->renderText(json_encode(array('status' => 'success', 'data' => $form->getObject()->getRowData())));
}
return $this->renderText(json_encode(array('status' => 'error', 'html' => $this->getPartial('form', array('form' => $form)))));
}