+++ /dev/null
-<?php\r
-/************************************************************************/\r
-/* ATutor */\r
-/************************************************************************/\r
-/* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton*/\r
-/* Adaptive Technology Resource Centre / University of Toronto */\r
-/* http://atutor.ca */\r
-/* */\r
-/* This program is free software. You can redistribute it and/or */\r
-/* modify it under the terms of the GNU General Public License */\r
-/* as published by the Free Software Foundation. */\r
-/************************************************************************/\r
-// $Id: grade_scale_add.php 7208 2008-05-28 16:07:24Z cindy $\r
-\r
-/************************************************************************/\r
-/*\r
-/* This script is called by gradebook/grade_scale_add.php, gradebook/grade_scale_edit.php\r
-/* to add/edit grade scales\r
-/*\r
-/* Required parameter: $action: "add" or "edit"\r
-/*\r
-/************************************************************************/\r
-\r
-$page = 'gradebook';\r
-\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-authenticate(AT_PRIV_GRADEBOOK);\r
-\r
-require('lib/gradebook.inc.php');\r
-\r
-if (isset($_POST['action'])) $action = $_POST['action'];\r
-\r
-if (isset($_POST['cancel'])) \r
-{\r
- $msg->addFeedback('CANCELLED');\r
- header('Location: grade_scale.php');\r
- exit;\r
-} \r
-else if (isset($_POST['submit'])) \r
-{\r
- $_POST['scale_name'] = trim($_POST['scale_name']);\r
-\r
- $empty_fields = array();\r
- if ($_POST['scale_value'][0] == '') \r
- {\r
- $empty_fields[] = _AT('scale_value').' at line 1';\r
- }\r
-\r
- if ($_POST['percentage_from'][0] == '') \r
- {\r
- $empty_fields[] = _AT('percentage_from').' at line 1';\r
- }\r
-\r
- if ($_POST['percentage_to'][0] == '') \r
- {\r
- $empty_fields[] = _AT('percentage_to').' at line 1';\r
- }\r
-\r
- if (!empty($empty_fields)) \r
- {\r
- $msg->addError(array('EMPTY_FIELDS', implode(', ', $empty_fields)));\r
- }\r
-\r
- if (!$msg->containsErrors()) \r
- {\r
- $_POST['scale_name'] = $addslashes($_POST['scale_name']);\r
-\r
- if ($action == "add")\r
- {\r
- $sql = "INSERT INTO ".TABLE_PREFIX."grade_scales\r
- (member_id, scale_name, created_date) \r
- VALUES (" . $_SESSION["member_id"] . ", '". $_POST["scale_name"] ."', now())";\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- \r
- $grade_scale_id = mysql_insert_id();\r
- }\r
- else if ($action == "edit" && isset($_POST["grade_scale_id"]))\r
- {\r
- $grade_scale_id = $_POST["grade_scale_id"];\r
- \r
- $sql = "UPDATE ".TABLE_PREFIX."grade_scales\r
- SET scale_name = '".$_POST["scale_name"]."'\r
- WHERE grade_scale_id = ". $grade_scale_id;\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- \r
- // clean up scale details for new insertions\r
- $sql = "DELETE FROM ".TABLE_PREFIX."grade_scales_detail WHERE grade_scale_id = ". $grade_scale_id;\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- }\r
- \r
- for ($i=0; $i<10; $i++) \r
- {\r
- if ($_POST['scale_value'][$i] <> "")\r
- {\r
- $_POST['scale_value'][$i] = $addslashes(trim($_POST['scale_value'][$i]));\r
- $_POST['percentage_from'][$i] = intval($_POST['percentage_from'][$i]);\r
- $_POST['percentage_to'][$i] = intval($_POST['percentage_to'][$i]);\r
- \r
- $sql = "INSERT INTO ".TABLE_PREFIX."grade_scales_detail\r
- (grade_scale_id, scale_value, percentage_from, percentage_to) \r
- VALUES (" . $grade_scale_id . ", '". $_POST['scale_value'][$i] ."', ".$_POST['percentage_from'][$i].", ".$_POST['percentage_to'][$i].")";\r
-\r
-// print $sql;\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- }\r
- }\r
- \r
- $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
- header('Location: grade_scale.php');\r
- exit;\r
- }\r
-} \r
-else if (isset($_POST['preset']) || ($action == 'edit' && isset($_REQUEST['grade_scale_id']))) \r
-{\r
- if (isset($_POST['selected_grade_scale_id']))\r
- {\r
- // clean up values preset previously\r
- unset($_POST["scale_value"]);\r
- unset($_POST["percentage_from"]);\r
- unset($_POST["percentage_to"]);\r
- }\r
-\r
- if (!$msg->containsErrors() && $_POST['selected_grade_scale_id'] > 0) \r
- {\r
- // load preset\r
- $_POST['selected_grade_scale_id'] = intval($_POST['selected_grade_scale_id']);\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."grade_scales_detail d, ".TABLE_PREFIX."grade_scales g WHERE d.grade_scale_id = g.grade_scale_id AND d.grade_scale_id=".$_POST[selected_grade_scale_id]." ORDER BY percentage_to DESC";\r
- }\r
- else if ($action == 'edit' && isset($_REQUEST['grade_scale_id']))\r
- {\r
- // edit existing\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."grade_scales_detail d, ".TABLE_PREFIX."grade_scales g WHERE d.grade_scale_id = g.grade_scale_id AND d.grade_scale_id=".$_REQUEST['grade_scale_id']." ORDER BY percentage_to DESC";\r
- }\r
- \r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- \r
- $i = 0;\r
- while ($row = mysql_fetch_assoc($result))\r
- {\r
- $_POST["scale_name"] = $row["scale_name"];\r
- $_POST["scale_value"][$i] = $row["scale_value"];\r
- $_POST["percentage_from"][$i] = $row["percentage_from"];\r
- $_POST["percentage_to"][$i] = $row["percentage_to"];\r
- \r
- $i++;\r
- }\r
-}\r
-\r
-$onload = 'document.form.selected_grade_scale_id.focus();';\r
-\r
-require(AT_INCLUDE_PATH.'header.inc.php');\r
-?>\r
-\r
-<form action="<?php echo $_SERVER['PHP_SELF'] . (isset($_REQUEST['grade_scale_id'])? "?grade_scale_id=".$_REQUEST['grade_scale_id'] : ""); ?>" method="post" name="form">\r
-<input type="hidden" name="grade_scale_id" value="<?php echo $_REQUEST['grade_scale_id']; ?>" />\r
-<input type="hidden" name="action" value="<?php echo $action; ?>" />\r
-\r
-<div class="input-form">\r
- <fieldset class="group_form"><legend class="group_form"><?php echo _AT('preset_scales'); ?></legend>\r
-\r
- <div class="row">\r
- <?php print_grade_scale_selectbox($_POST["selected_grade_scale_id"]); ?>\r
- </div>\r
- \r
- <div class="row buttons">\r
- <input type="submit" name="preset" value="<?php echo _AT('set_preset'); ?>" class="button" />\r
- </div>\r
- </fieldset>\r
-</div>\r
-\r
-<br />\r
-<div class="input-form">\r
- <fieldset class="group_form"><legend class="group_form"><?php echo _AT('grade_scale'); ?></legend>\r
- \r
- <div class="row">\r
- <label for="scale_name"><?php echo _AT('name'); ?></label><br />\r
- <input type="text" id="scale_name" size="40" name="scale_name" value="<?php echo htmlspecialchars(stripslashes($_POST['scale_name'])); ?>" />\r
- </div>\r
-\r
- <div class="row">\r
- <table style="width:100%">\r
-<?php for ($i=0; $i<10; $i++) { ?>\r
- <tr>\r
- <td>\r
- </td>\r
- <td>\r
- <?php if ($i==0) { ?>\r
- <div class="required" title="<?php echo _AT('required_field'); ?>">*</div>\r
- <?php } ?>\r
- <?php echo _AT('scale_value'); ?>\r
- </td>\r
-\r
- <td>\r
- <?php if ($i==0) { ?>\r
- <div class="required" title="<?php echo _AT('required_field'); ?>">*</div>\r
- <?php } ?>\r
- <?php echo _AT('percentage_from'); ?>\r
- </td>\r
-\r
- <td>\r
- <?php if ($i==0) { ?>\r
- <div class="required" title="<?php echo _AT('required_field'); ?>">*</div>\r
- <?php } ?>\r
- <?php echo _AT('percentage_to'); ?>\r
- </td>\r
- </tr>\r
-\r
- <tr>\r
- <td><?php echo $i+1; ?></td>\r
- <td><input type="text" id="scale_value_<?php echo $i; ?>" size="40" name="scale_value[<?php echo $i; ?>]" value="<?php echo htmlspecialchars(stripslashes($_POST['scale_value'][$i])); ?>" /></td>\r
- <td><input type="text" id="percentage_from_<?php echo $i; ?>" size="40" name="percentage_from[<?php echo $i; ?>]" value="<?php echo htmlspecialchars(stripslashes($_POST['percentage_from'][$i])); ?>" />%</td>\r
- <td><input type="text" id="percentage_to_<?php echo $i; ?>" size="40" name="percentage_to[<?php echo $i; ?>]" value="<?php echo htmlspecialchars(stripslashes($_POST['percentage_to'][$i])); ?>" />%</td>\r
- </tr>\r
-<?php } ?>\r
- </table>\r
- </div>\r
-\r
- <div class="row buttons">\r
- <input type="submit" value="<?php echo _AT('save'); ?>" name="submit" accesskey="s" />\r
- <input type="submit" value="<?php echo _AT('cancel'); ?>" name="cancel" />\r
- </div>\r
- </fieldset>\r
-</div>\r
-</form>\r
-\r
-<?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
\ No newline at end of file