Código PHP:
Ver originalpublic function executeShowResult(dmWebRequest $request)
{
$query = $this->getShowQuery();
$test = Doctrine::getTable('Test')
->createQuery('t')
->select('COUNT(tr.value) val_voted,t.name,s.name,e.name,tr.value')
->innerJoin('t.TestResult tr')
->innerJoin('tr.Stimulus s')
->innerJoin('tr.Emotion e')
->where('t.id = ?', $request->getParameter('test'))
->groupBy('s.name, e.name, tr.value')
->orderBy('s.id, e.id, tr.value')
->execute();
foreach ($test as $item) //n1
{
$result[$item->name] = array(); //n2 foreach ($item->getTestResult() as $tr) //n3
{
if(!isset($result[$item->name][$tr->getStimulus()->name])) $result[$item->name][$tr->getStimulus()->name]= array( );
}
$result[$item->name][$tr->getStimulus()->name][$tr->value][$tr->getEmotion()->name] = $tr->val_voted;
//$result[$item->name][$tr->getStimulus()->name][$tr->value] = $tr->val_voted;
}
// echo('<pre>');
//die(print_r($result));
// $this->test1 = $result;
//echo('</pre>');
$html= '<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">';
while(list($item,$stimulus)=each($result)){ //foreach ($test as $result){
$html.= '<tr>';
$html.= '<td>'.$result->name.'</td>';
$html.= '<td>'.$tr->getStimulus()->name .'</td>';
$html.= '<td>'.$tr->value .'</td>';
$html.= '<td>'.$tr->getEmotion()->name.'</td>';
$html.= '<td>'.$tr->val_voted.'</td>';
$html.= '</tr>';
}
$html.='</table>';
echo $html.'<br>';
}
}
esto es lo que tengo hasta ahora, y si es un array dentro de otro array lo que pasa es que al pegarlo aqui se me desordeno :S