"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 '
'; $excel_content .= get_lang('LastName').';'.get_lang('FirstName').';'.get_lang('EmailAddress').';'.get_lang('Organisation').';'; foreach($questions as $question){ $question['caption'] = eregi_replace('^]*>(.*)

','\\1', $question['caption']); $question['caption'] = eregi_replace('(<[^ ]*) (style=."."[^>]*)(>)','\\1\\3', $question['caption']); $question['caption'] = eregi_replace('(<[^ ]*) (style=.""[^>]*)(>)','\\1\\3', $question['caption']); $question['caption'] = eregi_replace('(<[^ ]*)( style=."[^"]*")([^>]*)(>)','\\1\\2\\4', $question['caption']); $excel_content .= stripslashes($question['caption']).';'; echo '
'; } $excel_content .= "\r\n"; $color = '#FFCCCC'; echo ''; $lastEmail = $users[O]['email']; foreach($users as $user){ if($user['email']!=$lastEmail){ $excel_content .= "\r\n"; $color = ($color == '#FFCCCC') ? '#CCCCFF' : '#FFCCCC'; echo ''; $lastEmail = $user['email']; $excel_content .= str_replace(array("\r","\n"),array("",""),$user['lastname'].';'.$user['firstname'].';'.$user['email'].';'.$user['organization'].';'); echo ' '; } 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'; } $answer = $final_answer; } if($question['qtype']=='Multiple Choice (multiple answer)'){ $answers = explode(',',$answer); $final_answer = ''; for($i=0;$i'; } $answer = $final_answer; } if(empty($answer)) $answer = '-'; $excel_content .= stripslashes(str_replace(array("\r","\n","
"),array("",""," - "),($answer))).';'; echo '
'; } } echo '
'.get_lang('LastName').' '.get_lang('FirstName').' '.get_lang('EmailAddress').' '.get_lang('Organisation').''.stripslashes($question['caption']).' 
 
'.$user['lastname'].' '.$user['firstname'].' '.$user['email'].' '.nl2br($user['organization']).''.stripslashes($answer).'
'; $archivePath=api_get_path(SYS_PATH).$archiveDirName.'/'; $handle = fopen($archivePath.$excel_file_name, 'w'); fwrite($handle, $excel_content); fclose($handle); chmod($archivePath.$excel_file_name, 0755); Display :: display_footer(); ?>