/**
* @param sfWebRequest $request
* @return sfView
*/
public function executeSave(sfWebRequest $request)
{
$this->forward404Unless($request->isXmlHttpRequest());
$measurement = $request->getParameter('measurement');
$decision_id = $request->getParameter('decision_id');
$user = $this->getUser()->getGuardUser();
$keys = array_keys($measurement);
$alternative_id = array_shift($keys);
$keys = array_keys($measurement[$alternative_id]);
$criterion_id = array_shift($keys);
$value = $measurement[$alternative_id][$criterion_id];
$alternativeMeasurement = AlternativeMeasurementTable::getInstance()->getOneForDashboard($user, $decision_id, $alternative_id, $criterion_id);
if (is_object($alternativeMeasurement)) {
$alternativeMeasurement->score = $value;
$alternativeMeasurement->save();
} else {
$response = ResponseTable::getInstance()->getOneForDashboard($user, $decision_id);
if (is_object($response)) {
$alternativeMeasurement = new AlternativeMeasurement();
$alternativeMeasurement->score = $value;
$alternativeMeasurement->alternative_head_id = $alternative_id;
$alternativeMeasurement->criterion_id = $criterion_id;
$alternativeMeasurement->Response = $response;
$alternativeMeasurement->save();
}
}
Doctrine_Query::create()->delete()->from('Graph')->where('decision_id = ?', $decision_id)->execute();
$criteriaAnalyze = new CriteriaAnalyze();
$criteriaAnalyze->setDecisionId($decision_id);
$criteriaAnalyze->load();
$stackedBarChart = new StackedBarChart();
$stackedBarChart->setDecisionId($decision_id);
$stackedBarChart->setCriteriaValues($criteriaAnalyze->getCriteriaValues());
$stackedBarChart->load();
$costAnalyze = new CostAnalyze();
$costAnalyze->setDecisionId($decision_id);
$costAnalyze->setSortedAlternativeIds($stackedBarChart->getSortedAlternativeIds());
$costAnalyze->setCumulativeData($stackedBarChart->getCumulativeData());
$costAnalyze->load();
$cumulativeChart = new CumulativeGainChart();
$cumulativeChart->setDecisionId($decision_id);
$cumulativeChart->setSortedAlternativeIds($stackedBarChart->getSortedAlternativeIds());
$cumulativeChart->setMeasurement($stackedBarChart->getCumulativeData());
$cumulativeChart->setCostData($costAnalyze->getData());
$cumulativeChart->setAlternativeNames($costAnalyze->getAlternativeNames());
$cumulativeChart->setCriterionNames($costAnalyze->getCriteria());
$cumulativeChart->load();
$stacked_bar_chart[] = '"data":' . $stackedBarChart->getJsonData();
$stacked_bar_chart[] = '"alternatives":' . $stackedBarChart->getAlternativesJson();
$stacked_bar_chart[] = '"criteria":' . $stackedBarChart->getCriteriaJson();
$cumulative_chart[] = '"costData":' . $cumulativeChart->getJsonCostData();
$cumulative_chart[] = '"benefitData":' . $cumulativeChart->getJsonData();
$cumulative_chart[] = '"criteria":' . json_encode($costAnalyze->getCriteria());
$cumulative_chart[] = '"alternatives":' . $cumulativeChart->getAlternativesJson();
$response = array();
$response[] = '"cumulativeChart":{' . implode(',', $cumulative_chart) . '}';
$response[] = '"stackedBarChart":{' . implode(',', $stacked_bar_chart) . '}';
$this->getResponse()->setHttpHeader('Content-Type', 'application/json; charset=utf-8');
return $this->renderText('{' . implode(',', $response) . '}');
}
public function load(sfGuardUser $user, $decision_id)
{
$this->criteria = CriterionTable::getInstance()->getArrayForUser($user, $decision_id);
$alternatives = AlternativeTable::getInstance()->getArrayForUser($user, $decision_id);
$values = AlternativeMeasurementTable::getInstance()->getForDashboard($user, $decision_id);
foreach ($alternatives as $alternative) {
$this->body[$alternative['id']][0] = $alternative['name'];
foreach ($this->criteria as $criterion) {
$cell = new stdClass();
$cell->measurement = str_replace(' ', '_', $criterion['measurement']);
$cell->value = isset($values[$alternative['id']][$criterion['id']]) ? $values[$alternative['id']][$criterion['id']] : null;
$this->body[$alternative['id']][$criterion['id']] = $cell;
}
}
}
public function save()
{
foreach ($this->values as $criterion_id => $alternatives) {
foreach ($alternatives as $alternative_id => $score) {
if ($this->role->updateable) {
$alternativeMeasurement = AlternativeMeasurementTable::getInstance()->getOneForSave($this->response_id, $alternative_id, $criterion_id);
if (!$alternativeMeasurement) {
$alternativeMeasurement = new AlternativeMeasurement();
}
} else {
$alternativeMeasurement = new AlternativeMeasurement();
}
$alternativeMeasurement->alternative_head_id = $alternative_id;
$alternativeMeasurement->criterion_id = $criterion_id;
$alternativeMeasurement->rating_method = 'five point scale';
$alternativeMeasurement->response_id = $this->response_id;
$alternativeMeasurement->score = $score;
$alternativeMeasurement->save();
}
}
}
/**
* Return the values from the database or empty array
*/
public function getValues()
{
$return = array();
if ($this->role and $this->role->Response->count() and $this->role->updateable and !$this->role->anonymous) {
$context = sfContext::getInstance();
$user = $context->getUser();
// find response by user_id
if ($user->isAuthenticated()) {
$response = ResponseTable::getInstance()->findByRoleIdAndUserId($this->role->id, $user->getGuardUser()->id)->getFirst();
} else {
$email = $user->getAttribute('email_address', null, 'measurement/email/' . $this->role->id);
$response = ResponseTable::getInstance()->findByRoleIdAndEmailAddress($this->role->id, $email)->getFirst();
}
if ($response instanceof Response) {
$values = AlternativeMeasurementTable::getInstance()->findByResponseIdAndCriterionId($response->id, $this->criterion_id);
/** @var CriterionPrioritization $object */
foreach ($values as $object) {
$return[$object->alternative_head_id] = $object->score;
}
}
}
return $return;
}