<?php
require_once("../settings.php");
require_once(FILE_ROOT . "/database.php");
require_once(FILE_ROOT . "/order.php");
//
// - Define some variables that will be used throughout the script. -
// Create the database connection for our many queries.
// Find the min and max sort_order values for each category. These
// are used when disabling buttons.
// These are created upon page load.
//
$tabindex = 1;
// Create the databanks connection.
$conn = db_connect();
// Max/Min values for surveys.
$sql = "SELECT max(sort_order) AS max_order, min(sort_order) AS min_order FROM surveys";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
$max = $row['max_order'];
$min = $row['min_order'];
/* Start Submission Check Section */
// --Survey
//
// The user wants to move the selected survey up one position in the list.
// The bounds have already been checked and the button has been disabled if
// it is the minimum or maximum value in the sort order.
if(isset($_REQUEST['Move_Up'])) {
// First start to find the id of the survey we are moving Down.
$sql = "SELECT survey_id FROM surveys WHERE sort_order='" . ($_REQUEST['position'] - 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Down one position.
$id_moving_down = $row['survey_id'];
// Move it up one.
$sql = "UPDATE surveys SET sort_order='" . ($_REQUEST['position'] - 1) . "' WHERE survey_id='" . $_REQUEST['s_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE surveys SET sort_order='" . $_REQUEST['position'] . "' WHERE survey_id='" . $id_moving_down . "'";
$res = db_query($sql);
// Refresh the page.
header("Location: list.php");
exit;
}
if(isset($_REQUEST['Move_Down'])) {
$sql = "SELECT survey_id FROM surveys WHERE sort_order='" . ($_REQUEST['position'] + 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Up one position.
$id_moving_down = $row['survey_id'];
// Move it up one.
$sql = "UPDATE surveys SET sort_order='" . ($_REQUEST['position'] + 1) . "' WHERE survey_id='" . $_REQUEST['s_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE surveys SET sort_order='" . $_REQUEST['position'] . "' WHERE survey_id='" . $id_moving_down . "'";
$res = db_query($sql);
header("Location: list.php");
exit;
}
// --Section
//
// The user wants to move the selected section up one position in the list.
// The bounds have already been checked and the button has been disabled if
// it is the minimum or maximum value in the sort order.
if(isset($_REQUEST['Move_Sec_Up'])) {
// First start to find the id of the survey we are moving Down.
$sql = "SELECT section_id FROM survey_sections WHERE sort_order='" . ($_REQUEST['position'] - 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Down one position.
$id_moving_down = $row['section_id'];
// Move it up one.
$sql = "UPDATE survey_sections SET sort_order='" . ($_REQUEST['position'] - 1) . "' WHERE section_id='" . $_REQUEST['sec_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE survey_sections SET sort_order='" . $_REQUEST['position'] . "' WHERE section_id='" . $id_moving_down . "'";
$res = db_query($sql);
// Refresh the page.
header("Location: list.php");
exit;
}
// The user has chosen to move a section down one in the sort order.
// Only sections < max(sort_order) are allowed to do this. This is
// Checked when the page is loaded.
if(isset($_REQUEST['Move_Sec_Down'])) {
$sql = "SELECT section_id FROM survey_sections WHERE sort_order='" . ($_REQUEST['position'] + 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Up one position.
$id_moving_down = $row['section_id'];
// Move it up one.
$sql = "UPDATE survey_sections SET sort_order='" . ($_REQUEST['position'] + 1) . "' WHERE section_id='" . $_REQUEST['sec_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE survey_sections SET sort_order='" . $_REQUEST['position'] . "' WHERE section_id='" . $id_moving_down . "'";
$res = db_query($sql);
header("Location: list.php");
exit;
}
// --Question
//
// The user wants to move the selected section up one position in the list.
// The bounds have already been checked and the button has been disabled if
// it is the minimum or maximum value in the sort order.
if(isset($_REQUEST['Move_Q_Up'])) {
//echo "<pre>"; print_r($_REQUEST['position']); echo "</pre>"; exit;
// First start to find the id of the survey we are moving Down.
$sql = "SELECT question_id FROM section_questions WHERE sort_order='" . ($_REQUEST['position'] - 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Down one position.
$id_moving_down = $row['question_id'];
// Move it up one.
$sql = "UPDATE section_questions SET sort_order='" . ($_REQUEST['position'] - 1) . "' WHERE question_id='" . $_REQUEST['q_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE section_questions SET sort_order='" . $_REQUEST['position'] . "' WHERE question_id='" . $id_moving_down . "'";
$res = db_query($sql);
// Refresh the page.
header("Location: list.php");
exit;
}
// The user has chosen to move a section down one in the sort order.
// Only sections < max(sort_order) are allowed to do this. This is
// Checked when the page is loaded.
if(isset($_REQUEST['Move_Q_Down'])) {
$sql = "SELECT question_id FROM section_questions WHERE sort_order='" . ($_REQUEST['position'] + 1) . "'";
$res = db_query($sql);
$row = mysql_fetch_assoc($res);
// This is the id of the record that is moving Up one position.
$id_moving_down = $row['question_id'];
// Move it up one.
$sql = "UPDATE section_questions SET sort_order='" . ($_REQUEST['position'] + 1) . "' WHERE question_id='" . $_REQUEST['q_id'] . "'";
$res = db_query($sql);
// Now move the one that was on top, down one.
$sql = "UPDATE section_questions SET sort_order='" . $_REQUEST['position'] . "' WHERE question_id='" . $id_moving_down . "'";
$res = db_query($sql);
header("Location: list.php");
exit;
}
/* End Submission Checks */
/*
* Begin onLoad
* This section loops through all the surveys and checks to see if sections
* exist for that survey. If there are sections, then loop through all of them
* checking to see if questions exist for each itteration. If there are questions
* print them out.
*
*/
// --Survey
//
//
$sql = "SELECT survey_id, survey_title, sort_order FROM surveys ORDER BY sort_order ASC";
$sur_res = db_query($sql);
while($sur_row = mysql_fetch_assoc($sur_res)) {
$html .= '
<div style="clear: both;"></div>
<div class="Form_Row">
<div class="Form_Label">Survey Title:</div>
<div class="Form_Data">' . $sur_row['survey_title'] . '</div>
</div>
<div style="clear: both;"></div>
<form action="' . $_SERVER['PHP_SELF'] . '" method="post">
<div class="Form_Row">
<div class="Form_Label"> </div>
<div class="Form_Data"><input name="Move_Up" id="Move_Up" type="submit" value="Move Up" tabindex="' . $tabindex++ . '"' . ($sur_row['sort_order'] == $min ? 'disabled' : '') . '/><input name="Move_Down" id="Move_Down" type="submit" value="Move Down" tabindex="' . $tabindex++ . '"' . ($sur_row['sort_order'] == $max ? 'disabled' : '') . '/></div>
</div>
<div style="clear: both;"></div>
<input name="s_id" type="hidden" value="' . $sur_row['survey_id'] . '" />
<input name="position" type="hidden" value="' . $sur_row['sort_order'] . '" />
</form>';
//
//
//
$sql = "SELECT section_id, section_title, sort_order FROM survey_sections WHERE survey_id='" . $sur_row['survey_id'] . "' ORDER BY sort_order ASC";
$sec_res = db_query($sql);
if(mysql_num_rows($sec_res) > 0) {
while($sec_row = mysql_fetch_assoc($sec_res)) {
$m_sql = "SELECT max(sort_order) AS sec_max, min(sort_order) AS sec_min FROM survey_sections WHERE survey_id='" . $sur_row['survey_id'] . "'";
$m_res = db_query($m_sql);
$m_row = mysql_fetch_assoc($m_res);
$sec_max = $m_row['sec_max'];
$sec_min = $m_row['sec_min'];
$html .= '
<div style="clear: both;"></div>
<div class="Form_Row">
<div class="Form_Label">Section Title:</div>
<div class="Form_Data">' . $sec_row['section_title'] . '</div>
</div>
<div style="clear: both;"></div>
<form action="' . $_SERVER['PHP_SELF'] . '" method="post">
<div class="Form_Row">
<div class="Form_Label"> </div>
<div class="Form_Data"><input name="Move_Sec_Up" id="Move_Sec_Up" type="submit" value="Move Up" tabindex="' . $tabindex++ . '"' . ($sec_row['sort_order'] == $sec_min ? 'disabled' : '') . '/><input name="Move_Sec_Down" id="Move_Sec_Down" type="submit" value="Move Down" tabindex="' . $tabindex++ . '"' . ($sec_row['sort_order'] == $sec_max ? 'disabled' : '') . '/></div>
</div>
<div style="clear: both;"></div>
<input name="sec_id" type="hidden" value="' . $sec_row['section_id'] . '" />
<input name="position" type="hidden" value="' . $sec_row['sort_order'] .
'" />
</form>
';
//
//
//
$q_sql = "SELECT question_id, question, sort_order FROM section_questions WHERE section_id='" . $sec_row['section_id'] . "' ORDER BY sort_order ASC";
$q_res = db_query($q_sql);
if(mysql_num_rows($q_res) > 0) {
while($q_row = mysql_fetch_assoc($q_res)) {
$m_sql = "SELECT max(sort_order) AS q_max, min(sort_order) AS q_min FROM section_questions WHERE section_id='" . $sec_row['section_id'] . "' ORDER BY sort_order ASC";
$m_res = db_query($m_sql);
$m_row = mysql_fetch_assoc($m_res);
$q_max = $m_row['q_max'];
$q_min = $m_row['q_min'];
$html .= '
<div class="Form_Row">
<div class="Form_Label">Question:</div>
<div class="Form_Data">' . $q_row['question'] . '</div>
</div>
<div style="clear: both;"></div>
<form action="' . $_SERVER['PHP_SELF'] . '" method="post">
<div class="Form_Row">
<div class="Form_Label"> </div>
<div class="Form_Data"><input name="Move_Q_Up" id="Move_Q_Up" type="submit" value="Move Up" tabindex="' . $tabindex++ . '"' . ($q_row['sort_order'] == $q_min ? 'disabled' : '') . '/> <input name="Move_Q_Down" id="Move_Q_Down" type="submit" value="Move Down" tabindex="' . $tabindex++ . '"' . ($q_row['sort_order'] == $q_max ? 'disabled' : '') . '/></div>
</div>
<div style="clear: both;"></div>
<input name="q_id" type="hidden" value="' . $q_row['question_id'] . '" />
<input name="position" type="hidden" value="' . $q_row['sort_order'] . '" />
</form>
';
}
}
}
}
}
?>
<html>
<head>
<style type="text/css">
/* <![CDATA[ */
@import url('../layout.css');
@import url('../form.css');
/* ]]> */
</style>
<script language="javascript" type="text/javascript" src="../sort.js"></script>
<title>
</title>
</head>
<body>
<?php echo $html ?>
</body>
</html>