"survey_list.php", "name" => get_lang('Survey'));
Display::display_header($tool_name);
/*
$sql = 'SELECT *
FROM '.$tbl_user_survey.' as user_survey,'.$tbl_questions.' as questions, '.$tbl_answers.' as answers, '.$tbl_questions_groups.' as groups
WHERE answers.qid = questions.qid
AND answers.user_id = user_survey.user_id
AND user_survey.survey_id='.$surveyid.'
AND user_survey.db_name="'.$db_name.'"
AND groups.group_id = questions.gid
ORDER BY email, groups.sortby, questions.sortby';
$rs = api_sql_query($sql, __FILE__, __LINE__);
$answers = api_store_result($rs);
*/
$users = SurveyManager::listUsers($surveyid, $db_name);
$questions = SurveyManager::listQuestions($surveyid);
$excel_content = '';
$excel_file_name = 'export_survey-'.$surveyid.$db_name.'.csv';
echo ''.get_lang('ExportInExcel').'
';
echo '
'.get_lang('LastName').' | '.get_lang('FirstName').' | '.get_lang('EmailAddress').' | '.get_lang('Organisation').' | '; $excel_content .= get_lang('LastName').';'.get_lang('FirstName').';'.get_lang('EmailAddress').';'.get_lang('Organisation').';'; foreach($questions as $question){ $question['caption'] = eregi_replace('^'.stripslashes($question['caption']).' | '; } $excel_content .= "\r\n"; $color = '#FFCCCC'; echo '|
'.$user['lastname'].' | '.$user['firstname'].' | '.$user['email'].' | '.nl2br($user['organization']).' | '; } foreach($questions as $question){ $sql = 'SELECT answer FROM '.$tbl_answers.' as answers WHERE qid='.$question['qid'].' AND user_id='.$user['user_id']; $rs = api_sql_query($sql, __FILE__, __LINE__); $answer = mysql_result($rs, 'answer'); if(in_array($answer,array('a1','a2','a3','a4','a5','a6','a7','a8','a9','a10'))){ $answer = $question[$answer]; } if($question['qtype']=='Numbered'){ $answers = explode(',',$answer); $final_answer = ''; for($i=0;$i'.stripslashes($answer).' | '; } } echo '