require_once './config/config.php';
//$sql_topic = "SELECT * FROM td_activity";
$aid = intval($_GET['aid']);
$name = $orp->one("td_activity","title","aid=".$aid);
if(empty($name)){exit('Access DENIED');}
$name = iconv("UTF-8","GBK",$name);//问卷题目
$str = '';
$str.='';
$str.='';
$str.='';
$str.='';
$str.='';
$str.='';
$sql_topic = "SELECT * FROM `td_topic` WHERE a_id=".$aid;//查询问卷的所有题目


$topic_array = $orp->getallrowstring($sql_topic);
//print_r($topic_array);exit;
foreach ($topic_array as $k=>$v){
 
 //遍历题目
 $sql_attribute = "SELECT * FROM `td_attribute` WHERE t_id=".$v['p_id'];
 $attribute_array = $orp->getallrowstring($sql_attribute);
 $count_attribute = count($attribute_array);
 
 $str.='';
 $str.='';//题目名称结束
 foreach ($attribute_array as $k1=>$v1){
  $sql_answer = "SELECT * FROM `td_answer` AS answer WHERE  answer.a_id=".$v1['id']." group by answer.uid";
  $array_answer = $orp->getallrowstring($sql_answer);
  $num = count($array_answer);
  $value ='';
  if($v1['attribute'] =='text' || $v1['attribute'] == 'textarea'){
   $value = '其他建议用户输入';
  }else $value=$v1['attribute'];
  $str.='';
  $str.='';
  
 $str.='';
}
}
$str.='

问卷题目		选项	选择人数(个)
$str.='rowspan='.$count_attribute.'>';  $str.=' '.$v['topic'].'		'.$value.'	'.$num.'

';


/*echo $str;


exit;*/
$str = iconv("UTF-8","GBK",$str);
$name = iconv("UTF-8","GBK",$name);
header('Content-Length: '.strlen($str));
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename={$name}.xls");
echo $str;