+++ /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_edit.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["certificate_id"])) $certificate_id = $_POST["certificate_id"];\r
-else $certificate_id = $_REQUEST["certificate_id"];\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 = "UPDATE ".TABLE_PREFIX."certificate\r
- SET test_id=". $_POST["test_id"] .",\r
- passscore=". $passscore .",\r
- passpercent=". $passpercent .",\r
- organization='". $_POST["organization"]."',\r
- enable_download=". $_POST["enable_download"] ." \r
- WHERE certificate_id = ". $certificate_id;\r
- \r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- write_to_log(AT_ADMIN_LOG_UPDATE, 'certificate', mysql_affected_rows($db), $sql);\r
-\r
- for ($i = 0; $i < count($_POST["text_id_init"]); $i++)\r
- {\r
- $sql = "UPDATE ".TABLE_PREFIX."certificate_text\r
- SET field_value='". $_POST["fields_value"][$i] ."'\r
- WHERE certificate_text_id = " . $_POST["text_id_init"][$i];\r
-\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- write_to_log(AT_ADMIN_LOG_UPDATE, '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
-// existing auto enrollment\r
-if ($certificate_id > 0)\r
-{\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."certificate\r
- WHERE certificate_id = " . $certificate_id;\r
-\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
- $row_certificate = mysql_fetch_assoc($result);\r
-}\r
-?>\r
-\r
-<form action ="<?php echo $_SERVER['PHP_SELF']; ?>?certificate_id=<?php echo $certificate_id; ?>" method="post" name="form">\r
-\r
-<input type="hidden" name="certificate_id" value="<?php echo $certificate_id; ?>">\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
-<?php\r
-// display test title linked with current $certificate_id\r
-$sql = "SELECT c.test_id, t.title FROM ".TABLE_PREFIX."certificate c, ".TABLE_PREFIX."tests t WHERE c.certificate_id=".$certificate_id." AND c.test_id = t.test_id";\r
-\r
-$result = mysql_query($sql, $db) or die(mysql_error());\r
-$row=mysql_fetch_assoc($result);\r
-?>\r
- <option value='<?php echo $row["test_id"];?>'><?php echo $row["title"]; ?></option>\r
-<?php\r
-// display other test titles that don't have certificate yet\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
- echo ' <option value="'. $row["test_id"] . '>'. $row["title"] .'</option>';\r
-}\r
-?>\r
- </select>\r
- </div>\r
-\r
- <div class="row">\r
-<?php\r
-if (!$is_passscore_in_basetable)\r
-{\r
- // set radio button / text properties and value for pass score\r
- if (isset($_POST['passscore']))\r
- {\r
- if ($_POST['passscore'] <> 0)\r
- {\r
- $value_passscore = $_POST['passscore'];\r
- $checked_passscore = 'checked="true"';\r
- }\r
- else\r
- $disabled_passscore = 'disabled="true"';\r
- }\r
- else\r
- {\r
- if ($row_certificate["passscore"]<>0) \r
- {\r
- $value_passscore = $row_certificate["passscore"];\r
- $checked_passscore = 'checked="true"';\r
- }\r
- else\r
- $disabled_passscore = 'disabled="true"';\r
- }\r
-\r
- // set radio button / text properties and value for pass percentage\r
- if (isset($_POST['passpercent']))\r
- {\r
- if ($_POST['passpercent'] <> 0)\r
- {\r
- $value_passpercent = $_POST['passpercent'];\r
- $checked_passpercent = 'checked="true"';\r
- }\r
- else\r
- $disabled_passpercent = 'disabled="true"';\r
- }\r
- else\r
- {\r
- if ($row_certificate["passpercent"]<>0) \r
- {\r
- $value_passpercent = $row_certificate["passpercent"];\r
- $checked_passpercent = 'checked="true"';\r
- }\r
- else\r
- $disabled_passpercent = 'disabled="true"';\r
- }\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 echo $checked_passpercent; ?>\r
- onfocus="disable_texts('points');" />\r
-\r
- <input type="text" name="passpercent" id="passpercent" size="2" value="<?php echo $value_passpercent;?>" <?php echo $disabled_passpercent;?> /> \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 echo $checked_passscore; ?>\r
- onfocus="disable_texts('percentage');" />\r
-\r
- <input type="text" name="passscore" id="passscore" size="2" value="<?php echo $value_passscore;?>" <?php echo $disabled_passscore;?> /> \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 $row_certificate["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" \r
-<?php \r
-if (!isset($_POST['enable_download']))\r
-{\r
- if ($row_certificate["enable_download"] == 0) echo 'checked="true"';\r
-}\r
-else if ($_POST['enable_download'] == 0) echo 'checked="true"'; \r
-?> />\r
- <label for="no"><?php echo _AT('no'); ?></label><br />\r
-\r
- <input type="radio" name="enable_download" value="1" id="ok" \r
-<?php \r
-if (!isset($_POST['enable_download']))\r
-{\r
- if ($row_certificate["enable_download"] == 1) echo 'checked="true"';\r
-}\r
-else if ($_POST['enable_download'] == 1) echo 'checked="true"'; \r
-?> />\r
-\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
-$sql = "SELECT * FROM ".TABLE_PREFIX."certificate_text c WHERE c.certificate_id=".$certificate_id;\r
-$result = mysql_query($sql, $db) or die(mysql_error());\r
-while ($row_text=mysql_fetch_assoc($result))\r
-{\r
- $text_id_init[]=$row_text["certificate_text_id"];\r
- $fields_name_init[]=$row_text["field_name"];\r
- $fields_value_init[]=$row_text["field_value"];\r
-}\r
-\r
-for($i=0; $i<mysql_num_rows($result); $i++)\r
-{\r
-?>\r
- <tr>\r
- <input type="hidden" name="text_id_init[]" value="<?php echo $text_id_init[$i]; ?>">\r
- <input type="hidden" name="fileds_name[]" value="<?php echo $fields_name_init[$i]; ?>">\r
- <td style="width:20%"><?php echo $fields_name_init[$i]; ?></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 $_POST["fields_value"][$i]; else echo $fields_value_init[$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