<?php
	include('_mod_security.php');

	$sql = '';
	switch ($_GET['func']):
		case 'load_template' :
			$sql = "SELECT * FROM survey_templates WHERE id = " . nz($_GET['template_id'], '0');
			$result = $db->query($sql) or die(json_encode(array('result' => 'Database Error!')));
			if ($result->rowCount() > 0) :
				$row = $result->fetch(PDO::FETCH_OBJ);
				echo json_encode([
					'result' => 'Success',
					'default_email_subject' => $row->default_email_subject,
					'default_email_html' => $row->default_email_html,
					'default_email_reply_name' => $row->default_email_reply_name,
					'default_email_reply_address' => $row->default_email_reply_address,
					'default_cgr_type_id' => $row->default_cgr_type_id,
				]);
			else :
				die(json_encode(array('result' => 'No data!')));
			endif;
			break;
		case 'load_responses_questions' :
			$sql = "SELECT * FROM surveys_responders_questions WHERE survey_responder_id = " . nz($_GET['response_id'], '0') . " ORDER BY seq";
			$result = $db->query($sql) or die(json_encode(array('result' => 'Database Error!')));
			$html = '<p>' . $_GET['name'] . '</p>';
			if ($result->rowCount() > 0) :
				$html .= '<table class="survey_response_popup">';
				$html .= '<tr><th>Question</th><th>Answer</th></tr>';
				while ($row = $result->fetch(PDO::FETCH_OBJ)) :
					$html .= '<tr>';
					$html .= '<td>' . $row->question_text . '</td>';
					$html .= '<td>' . $row->answer_value . '</td>';
					$html .= '</tr>';
				endwhile;
				$html .= '</table>';
			else :
				$html .= '<p>No response data found!</p>';
			endif;
			echo json_encode([
				'result' => 'Success',
				'html' => $html,
			]);
			break;
	endswitch;