.
\n");
$result = execute_sql($sql);
while(list($text,$count) = fetch_row($result)) {
$result->MoveNext();
$counts[$text] = $count;
}
db_close($result);
if(empty($question[0]['result_id']))
$question[0]['result_id'] = 1; // default to percentages for yes/no
break;
// -------------------------------- response_single ----------------------------------
// -------------------------------- response_multiple --------------------------------
case 'response_multiple':
$showTotals = 0;
case 'response_single':
for($i=0; $i<$num; $i++) {
$sid = $sids[$i];
$qid = $question[$i]['id'];
$sql = "SELECT id
FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']."
WHERE question_id=${qid} AND
content NOT LIKE '!other%'
ORDER BY id";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result = execute_sql($sql);
$cids[$i] = array();
while(list($cid) = fetch_row($result)) {
$result->MoveNext();
array_push($cids[$i],$cid);
}
db_close($result);
}
$content = array();
foreach($cids[0] as $cid) {
$sql = "SELECT content FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']." WHERE id=${cid}";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result = get_one($sql);
array_push($content, $result);
}
$cnum = count($content);
for($j=0; $j<$cnum; $j++) {
$mycids = array();
for($i=0; $i<$num; $i++) {
array_push($mycids, $cids[$i][$j]);
}
$mycidstr = array_to_insql($mycids);
$sql = "SELECT COUNT(*)
FROM ".$GLOBALS['ESPCONFIG'][$table.'_table']." A
WHERE A.choice_id ${mycidstr} AND
A.response_id ${ridstr}";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result=get_one($sql);
$counts[$content[$j]] = $result;
}
// handle 'other...'
for($i=0; $i<$num; $i++) {
$sid = $sids[$i];
$qid = $question[$i]['id'];
$sql = "SELECT id
FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']."
WHERE question_id ${qidstr} AND
content LIKE '!other%'
ORDER BY id";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result = execute_sql($sql);
$cids[$i] = array();
while(list($cid) = fetch_row($result)) {
$result->MoveNext();
array_push($cids[$i],$cid);
}
db_close($result);
}
$content = array();
foreach($cids[0] as $cid) {
$sql = "SELECT content FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']." WHERE id=${cid}";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result=get_one($sql);
$text = ereg_replace("!other=?", "", $result);
if(!empty($text))
$text .= ': ';
array_push($content, $text);
}
$cnum = count($content);
for($j=0; $j<$cnum; $j++) {
$mycids = array();
for($i=0; $i<$num; $i++) {
array_push($mycids, $cids[$i][$j]);
}
$mycidstr = array_to_insql($mycids);
$sql = "SELECT A.response, COUNT(A.response_id)
FROM ".$GLOBALS['ESPCONFIG']['response_other_table']." A
WHERE A.choice_id ${mycidstr} AND
A.response_id ${ridstr}
GROUP BY A.response";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result=execute_sql($sql);
while(list($response,$count) = fetch_row($result)) {
$result->MoveNext();
if(!empty($response)) {
$text = $content[$j] . htmlspecialchars($response);
$counts[$text] = $count;
}
}
db_close($result);
}
if(empty($question[0]['result_id']))
$question[0]['result_id'] = 1; // default to percentages
break;
// -------------------------------- response_text --------------------------------
case 'response_text':
$sql = "SELECT A.response, COUNT(A.response_id)
FROM ".$GLOBALS['ESPCONFIG'][$table.'_table']." A
WHERE A.question_id ${qidstr} AND
A.response_id ${ridstr}
GROUP BY A.response";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result = execute_sql($sql);
while(list($response, $count) = fetch_row($result)) {
$result->MoveNext();
if(!empty($response))
$counts[htmlspecialchars($response)] = $count;
}
db_close($result);
$question[0]['result_id'] = 4; // force "list" type response for text fields
break;
// -------------------------------- response_rank --------------------------------
case 'response_rank':
if($tid == 8) { //Rank
for($i=0; $i<$num; $i++) {
$sid = $sids[$i];
$qid = $question[$i]['id'];
$sql = "SELECT id
FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']."
WHERE question_id ${qidstr}
ORDER BY id";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result = execute_sql($sql);
$cids[$i] = array();
while(list($cid) = fetch_row($result)) {
$result->MoveNext();
array_push($cids[$i],$cid);
}
db_close($result);
}
$content = array();
foreach($cids[0] as $cid) {
$sql = "SELECT content FROM ".$GLOBALS['ESPCONFIG']['question_choice_table']." WHERE id=${cid}";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result=get_one($sql);
array_push($content, $result);
}
$cnum = count($content);
for($j=0; $j<$cnum; $j++) {
$mycids = array();
for($i=0; $i<$num; $i++) {
array_push($mycids, $cids[$i][$j]);
}
$mycidstr = array_to_insql($mycids);
$sql = "SELECT AVG(A.rank)
FROM ".$GLOBALS['ESPCONFIG'][$table.'_table']." A
WHERE A.choice_id ${mycidstr} AND
A.response_id ${ridstr} AND
A.rank>0";
if($GLOBALS['ESPCONFIG']['DEBUG_MERGE']) echo("\n");
$result=get_one($sql);
$counts[$content[$j]] = $result;
}
$question[0]['result_id'] = 99; // force to rank
} else {
// deprecated ... I am not going to write this
// code. If you need it email me or write it yourself.
}
break;
}
// ---------------------------------------------------------------------------
switch($question[0]['result_id']) {
case '1': // Percentages
mkrespercent($counts,$total,$precision,$showTotals);
break;
case '2': // Rank
mkresrank($counts,$total,$precision,$showTotals);
break;
case '3': // Count
mkrescount($counts,$total,$precision,$showTotals);
break;
case '4': // List
mkreslist($counts,$total,$precision,$showTotals);
break;
case '99': // Average
mkresavg($counts,$total,$precision,$showTotals,0);
break;
} // end switch
?>
|