+++ /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: certificate_create.php 7208 2008-02-20 16:07:24Z cindy $\r
-\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require (AT_INCLUDE_PATH.'vitals.inc.php');\r
-authenticate(AT_PRIV_CERTIFICATE);\r
-\r
-// Main process\r
-// Initialize default vars\r
-require_once("common.inc.php");\r
-initialize_default_vars();\r
-\r
-$is_passscore_in_basetable = is_pass_score_defined_in_base_table();\r
-\r
-if (isset($_POST['submit']))\r
-{\r
- $missing_fields = array();\r
-\r
- /* insert or update a category */\r
- if ($_POST["test_id"] == -1) \r
- $missing_fields[] = _AT("choose_test");\r
- \r
- if ($is_passscore_in_basetable)\r
- {\r
- if ($_POST["test_id"]>0)\r
- {\r
- $sql = "SELECT passscore, passpercent from ".TABLE_PREFIX."tests where test_id=".$_POST["test_id"];\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- $row=mysql_fetch_assoc($result);\r
- \r
- if ($row["passpercent"]==0 && $row["passscore"]==0)\r
- {\r
- $missing_fields[] = _AT("pass_score"). "<br>". _AT("define_pass_score", $_base_href."tools/tests/edit_test.php?tid=".$_POST["test_id"]);\r
- }\r
- }\r
- }\r
- else if ((!isset($_POST["pass_score"]) || ($_POST["passpercent"] == 0 && $_POST["passscore"] == 0)))\r
- {\r
- $missing_fields[] = _AT("pass_score");\r
- }\r
- \r
- if ($missing_fields) {\r
- $missing_fields = implode(', ', $missing_fields);\r
- $msg->addError(array('EMPTY_FIELDS', $missing_fields));\r
- }\r
-\r
- if (!$msg->containsErrors()) \r
- {\r
- if (isset($_POST["passscore"])) \r
- $passscore = $_POST["passscore"];\r
- else\r
- $passscore = 0;\r
- \r
- if (isset($_POST["passpercent"])) \r
- $passpercent = $_POST["passpercent"];\r
- else\r
- $passpercent = 0;\r
- \r
- $sql = "INSERT INTO ".TABLE_PREFIX."certificate\r
- (test_id, \r
- passscore,\r
- passpercent,\r
- organization,\r
- enable_download) \r
- VALUES (". $_POST["test_id"] .", \r
- ". $passscore .",\r
- ". $passpercent .",\r
- '". $_POST["organization"]."',\r
- ". $_POST["enable_download"] .")";\r
- \r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- $certificate_id = mysql_insert_id($db);\r
- write_to_log(AT_ADMIN_LOG_INSERT, 'certificate', mysql_affected_rows($db), $sql);\r
-\r
- for ($i = 0; $i < count($fields_array); $i++)\r
- {\r
- $sql = "INSERT INTO ".TABLE_PREFIX."certificate_text\r
- (certificate_id, \r
- field_name,\r
- field_value) \r
- VALUES (". $certificate_id .", \r
- '". $fields_array[$i]["FieldName"] ."',\r
- '". $_POST["fields_value"][$i] ."')";\r
- \r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- write_to_log(AT_ADMIN_LOG_INSERT, 'certificate_text', mysql_affected_rows($db), $sql);\r
- }\r
- \r
- $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
-\r
- header('Location: index_instructor.php');\r
- exit;\r
- }\r
-} \r
-else if (isset($_POST['cancel'])) \r
-{\r
- $msg->addFeedback('CANCELLED');\r
- header('Location: index_instructor.php');\r
- exit;\r
-}\r
-\r
-require(AT_INCLUDE_PATH.'header.inc.php'); \r
-$msg->printAll();\r
-\r
-?>\r
-\r
-<form action ="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="form">\r
-\r
-<div class="input-form">\r
- <div class="row">\r
- <div class="required" title="<?php echo _AT('required_field'); ?>">*</div><label for="test_id"><?php echo _AT('choose_test'); ?></label><br>\r
- <select name="test_id" id="test_id">\r
- <option value="-1">- <?php echo _AT('select'); ?> -</option>\r
-<?php\r
-$sql = "SELECT * FROM ".TABLE_PREFIX."tests WHERE course_id=$_SESSION[course_id] AND test_id not in (SELECT distinct test_id FROM ".TABLE_PREFIX."certificate) ORDER BY start_date DESC";\r
-$result = mysql_query($sql, $db) or die(mysql_error());\r
-\r
-while ($row=mysql_fetch_assoc($result))\r
-{\r
- $selected = "";\r
-\r
- if ($row["test_id"] == $_POST["test_id"])\r
- $selected = ' selected="selected"';\r
- \r
- echo ' <option value="'. $row["test_id"] . '"'. $selected .'>'. $row["title"] .'</option>';\r
-}\r
-?>\r
- </select>\r
- </div>\r
-\r
- <div class="row">\r
-<?php\r
-if (!$is_passscore_in_basetable)\r
-{\r
-?>\r
- <div class="required" title="<?php echo _AT('required_field'); ?>">*</div><?php echo _AT('pass_score'); ?><br />\r
- <input type="radio" name="pass_score" value="1" id="percentage" <?php if ($_POST['passpercent'] <> 0){echo 'checked="true"';} ?>\r
- onfocus="disable_texts('points');" />\r
-\r
- <input type="text" name="passpercent" id="passpercent" size="2" value="<?php echo $_POST['passpercent']; ?>" \r
- <?php if ($_POST['passpercent'] == 0){echo 'disabled="true"';} ?> /> \r
- <label for="percentage" title="<?php echo _AT('pass_score'). ': '. _AT('percentage_score'); ?>"><?php echo '% ' . _AT('percentage_score'); ?></label><br />\r
-\r
- <input type="radio" name="pass_score" value="2" id="points" <?php if ($_POST['passscore'] <> 0){echo 'checked="true"';} ?>\r
- onfocus="disable_texts('percentage');" />\r
-\r
- <input type="text" name="passscore" id="passscore" size="2" value="<?php echo $_POST['passscore']; ?>" \r
- <?php if ($_POST['passscore'] == 0){echo 'disabled="true"';} ?>/> \r
- <label for="points" title="<?php echo _AT('pass_score'). ': '. _AT('points_score'); ?>"><?php echo _AT('points_score'); ?></label>\r
-<?php\r
-}\r
-?>\r
- </div>\r
-\r
- <div class="row">\r
- <label for="certificate_template"><?php echo _AT('certificate_template'). ":"; ?></label>\r
- <?php echo $default_certificate; ?>\r
- </div>\r
- \r
- <div class="row">\r
- <label for="organization"><?php echo _AT('organization_name'); ?></label><br>\r
- <input type="text" name="organization" id="organization" size="50" value="<?php if (!isset($_POST["organization"])) echo $default_organization; else echo $_POST["organization"]; ?>" />\r
- </div>\r
- \r
- <div class="row">\r
- <label for="enable_download"><?php echo _AT('enable_download_certificate'); ?></label><br>\r
-\r
- <input type="radio" name="enable_download" value="0" id="no" <?php if ($_POST['enable_download'] == 0){echo 'checked="true"';} ?> />\r
- <label for="no"><?php echo _AT('no'); ?></label><br />\r
-\r
- <input type="radio" name="enable_download" value="1" id="ok" <?php if ($_POST['enable_download'] == 1 || !isset($_POST['enable_download'])){echo 'checked="true"';} ?> />\r
- <label for="ok"><?php echo _AT('issue_certificate'); ?></label><br />\r
- </div>\r
-\r
- <div class="row">\r
- <label for="certificate_text"><?php echo _AT('certificate_text'); ?></label><br>\r
- <table summary="" class="data" rules="cols" align="center" style="width: 100%;">\r
- <thead>\r
- <tr>\r
- <th scope="col"><?php echo _AT('field_name'); ?></th>\r
- <th scope="col"><?php echo _AT('field_value'); ?></th>\r
- </tr>\r
- </thead>\r
-\r
- <tbody>\r
-<?php\r
-for ($i=0; $i < count($fields_array); $i++)\r
-{\r
-?>\r
- <tr>\r
- <td style="width:20%"><?php echo $fields_array[$i]["FieldName"]; ?></td>\r
- <td style="width:80%"><textarea name="fields_value[]" rows="1" cols="120" style="max-width:100%"><?php if (!isset($_POST["fields_value"][$i])) echo $fields_array[$i]["FieldValue"]; else echo $_POST["fields_value"][$i]; ?></textarea></td>\r
- </tr>\r
-<?php\r
-}\r
-?>\r
- </tbody>\r
- </table>\r
- <small>· <?php echo _AT('certificate_tokens'); ?></small>\r
- </div>\r
-\r
- <div class="row buttons">\r
- <input type="submit" name="submit" value=" <?php echo _AT('save'); ?> " accesskey="s" />\r
- <input type="submit" name="cancel" value=" <?php echo _AT('cancel'); ?> " />\r
- </div>\r
-\r
-</div>\r
-</form>\r
-\r
-<script language="javascript" type="text/javascript">\r
-function disable_texts (name) {\r
- if (name == 'both')\r
- {\r
- document.form['passpercent'].disabled=true;\r
- document.form['passscore'].disabled=true;\r
- document.form['passpercent'].value=0;\r
- document.form['passscore'].value=0;\r
- }\r
- else if (name == 'percentage')\r
- {\r
- document.form['passpercent'].disabled=true;\r
- document.form['passpercent'].value=0;\r
- document.form['passscore'].disabled=false;\r
- }\r
- else if (name == 'points')\r
- {\r
- document.form['passpercent'].disabled=false;\r
- document.form['passscore'].disabled=true;\r
- document.form['passscore'].value=0;\r
- }\r
-}\r
-</script>\r
-\r
-<?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>\r