mods/certificate/certificate_create.php

   1 <?php\r
   2 /****************************************************************************/\r
   3 /* ATutor                                                                                                                                       */\r
   4 /****************************************************************************/\r
   5 /* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton        */\r
   6 /* Adaptive Technology Resource Centre / University of Toronto                          */\r
   7 /* http://atutor.ca                                                                                                                     */\r
   8 /*                                                                                                                                                      */\r
   9 /* This program is free software. You can redistribute it and/or                        */\r
  10 /* modify it under the terms of the GNU General Public License                          */\r
  11 /* as published by the Free Software Foundation.                                                        */\r
  12 /****************************************************************************/\r
  13 // $Id: certificate_create.php 7208 2008-02-20 16:07:24Z cindy $\r
  14 \r
  15 define('AT_INCLUDE_PATH', '../../include/');\r
  16 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 authenticate(AT_PRIV_CERTIFICATE);\r
  18 \r
  19 // Main process\r
  20 // Initialize default vars\r
  21 require_once("common.inc.php");\r
  22 initialize_default_vars();\r
  23 \r
  24 $is_passscore_in_basetable = is_pass_score_defined_in_base_table();\r
  25 \r
  26 if (isset($_POST['submit']))\r
  27 {\r
  28         $missing_fields = array();\r
  29 \r
  30         /* insert or update a category */\r
  31         if ($_POST["test_id"] == -1)    \r
  32                 $missing_fields[] = _AT("choose_test");\r
  33                 \r
  34         if ($is_passscore_in_basetable)\r
  35         {\r
  36                 if ($_POST["test_id"]>0)\r
  37                 {\r
  38                         $sql = "SELECT passscore, passpercent from ".TABLE_PREFIX."tests where test_id=".$_POST["test_id"];\r
  39                         $result = mysql_query($sql, $db) or die(mysql_error());\r
  40                         $row=mysql_fetch_assoc($result);\r
  41                         \r
  42                         if ($row["passpercent"]==0 && $row["passscore"]==0)\r
  43                         {\r
  44                                 $missing_fields[] = _AT("pass_score"). "<br>". _AT("define_pass_score", $_base_href."tools/tests/edit_test.php?tid=".$_POST["test_id"]);\r
  45                         }\r
  46                 }\r
  47         }\r
  48         else if ((!isset($_POST["pass_score"]) || ($_POST["passpercent"] == 0 && $_POST["passscore"] == 0)))\r
  49         {\r
  50                 $missing_fields[] = _AT("pass_score");\r
  51         }\r
  52                 \r
  53         if ($missing_fields) {\r
  54                 $missing_fields = implode(', ', $missing_fields);\r
  55                 $msg->addError(array('EMPTY_FIELDS', $missing_fields));\r
  56         }\r
  57 \r
  58         if (!$msg->containsErrors()) \r
  59         {\r
  60         if (isset($_POST["passscore"])) \r
  61                 $passscore = $_POST["passscore"];\r
  62         else\r
  63                 $passscore = 0;\r
  64         \r
  65         if (isset($_POST["passpercent"])) \r
  66                 $passpercent = $_POST["passpercent"];\r
  67         else\r
  68                 $passpercent = 0;\r
  69         \r
  70         $sql = "INSERT INTO ".TABLE_PREFIX."certificate\r
  71                 (test_id, \r
  72                  passscore,\r
  73                  passpercent,\r
  74                  organization,\r
  75                  enable_download) \r
  76                         VALUES (". $_POST["test_id"] .", \r
  77                                 ". $passscore .",\r
  78                                 ". $passpercent .",\r
  79                                 '". $_POST["organization"]."',\r
  80                                 ". $_POST["enable_download"] .")";\r
  81                                 \r
  82                 $result = mysql_query($sql, $db) or die(mysql_error());\r
  83                 $certificate_id = mysql_insert_id($db);\r
  84                 write_to_log(AT_ADMIN_LOG_INSERT, 'certificate', mysql_affected_rows($db), $sql);\r
  85 \r
  86                 for ($i = 0; $i < count($fields_array); $i++)\r
  87                 {\r
  88                 $sql = "INSERT INTO ".TABLE_PREFIX."certificate_text\r
  89                         (certificate_id, \r
  90                          field_name,\r
  91                          field_value) \r
  92                                 VALUES (". $certificate_id .", \r
  93                                         '". $fields_array[$i]["FieldName"] ."',\r
  94                                         '". $_POST["fields_value"][$i] ."')";\r
  95                                         \r
  96                         $result = mysql_query($sql, $db) or die(mysql_error());\r
  97                         write_to_log(AT_ADMIN_LOG_INSERT, 'certificate_text', mysql_affected_rows($db), $sql);\r
  98                 }\r
  99                 \r
 100                 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
 101 \r
 102                 header('Location: index_instructor.php');\r
 103                 exit;\r
 104         }\r
 105 } \r
 106 else if (isset($_POST['cancel'])) \r
 107 {\r
 108         $msg->addFeedback('CANCELLED');\r
 109         header('Location: index_instructor.php');\r
 110         exit;\r
 111 }\r
 112 \r
 113 require(AT_INCLUDE_PATH.'header.inc.php'); \r
 114 $msg->printAll();\r
 115 \r
 116 ?>\r
 117 \r
 118 <form action ="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="form">\r
 119 \r
 120 <div class="input-form">\r
 121         <div class="row">\r
 122         <div class="required" title="<?php echo _AT('required_field'); ?>">*</div><label for="test_id"><?php echo _AT('choose_test'); ?></label><br>\r
 123                 <select name="test_id" id="test_id">\r
 124                         <option value="-1">- <?php echo _AT('select'); ?> -</option>\r
 125 <?php\r
 126 $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
 127 $result = mysql_query($sql, $db) or die(mysql_error());\r
 128 \r
 129 while ($row=mysql_fetch_assoc($result))\r
 130 {\r
 131         $selected = "";\r
 132 \r
 133         if ($row["test_id"] == $_POST["test_id"])\r
 134                 $selected = ' selected="selected"';\r
 135                 \r
 136         echo '                  <option value="'. $row["test_id"] . '"'. $selected .'>'. $row["title"] .'</option>';\r
 137 }\r
 138 ?>\r
 139                 </select>\r
 140         </div>\r
 141 \r
 142         <div class="row">\r
 143 <?php\r
 144 if (!$is_passscore_in_basetable)\r
 145 {\r
 146 ?>\r
 147                 <div class="required" title="<?php echo _AT('required_field'); ?>">*</div><?php echo _AT('pass_score'); ?><br />\r
 148                 <input type="radio" name="pass_score" value="1" id="percentage"  <?php if ($_POST['passpercent'] <> 0){echo 'checked="true"';} ?>\r
 149                  onfocus="disable_texts('points');" />\r
 150 \r
 151                 <input type="text" name="passpercent" id="passpercent" size="2" value="<?php echo $_POST['passpercent']; ?>" \r
 152                  <?php if ($_POST['passpercent'] == 0){echo 'disabled="true"';} ?> /> \r
 153                 <label for="percentage" title="<?php echo _AT('pass_score'). ': '. _AT('percentage_score');  ?>"><?php  echo '% ' . _AT('percentage_score'); ?></label><br />\r
 154 \r
 155                 <input type="radio" name="pass_score" value="2" id="points"  <?php if ($_POST['passscore'] <> 0){echo 'checked="true"';} ?>\r
 156                  onfocus="disable_texts('percentage');" />\r
 157 \r
 158                 <input type="text" name="passscore" id="passscore" size="2" value="<?php echo $_POST['passscore']; ?>" \r
 159                  <?php if ($_POST['passscore'] == 0){echo 'disabled="true"';} ?>/> \r
 160                 <label for="points" title="<?php echo _AT('pass_score'). ': '. _AT('points_score');  ?>"><?php  echo _AT('points_score'); ?></label>\r
 161 <?php\r
 162 }\r
 163 ?>\r
 164         </div>\r
 165 \r
 166         <div class="row">\r
 167                 <label for="certificate_template"><?php echo _AT('certificate_template'). ":"; ?></label>\r
 168                 <?php echo $default_certificate; ?>\r
 169         </div>\r
 170         \r
 171         <div class="row">\r
 172                 <label for="organization"><?php echo _AT('organization_name'); ?></label><br>\r
 173                 <input type="text" name="organization" id="organization" size="50" value="<?php if (!isset($_POST["organization"])) echo $default_organization; else echo $_POST["organization"]; ?>" />\r
 174         </div>\r
 175         \r
 176         <div class="row">\r
 177                 <label for="enable_download"><?php echo _AT('enable_download_certificate'); ?></label><br>\r
 178 \r
 179                 <input type="radio" name="enable_download" value="0" id="no"  <?php if ($_POST['enable_download'] == 0){echo 'checked="true"';} ?> />\r
 180                 <label for="no"><?php  echo _AT('no'); ?></label><br />\r
 181 \r
 182                 <input type="radio" name="enable_download" value="1" id="ok"  <?php if ($_POST['enable_download'] == 1 || !isset($_POST['enable_download'])){echo 'checked="true"';} ?> />\r
 183                 <label for="ok"><?php  echo _AT('issue_certificate'); ?></label><br />\r
 184         </div>\r
 185 \r
 186         <div class="row">\r
 187                 <label for="certificate_text"><?php echo _AT('certificate_text'); ?></label><br>\r
 188                 <table summary="" class="data" rules="cols" align="center" style="width: 100%;">\r
 189                         <thead>\r
 190                         <tr>\r
 191                                 <th scope="col"><?php echo _AT('field_name'); ?></th>\r
 192                                 <th scope="col"><?php echo _AT('field_value'); ?></th>\r
 193                         </tr>\r
 194                         </thead>\r
 195 \r
 196                         <tbody>\r
 197 <?php\r
 198 for ($i=0; $i < count($fields_array); $i++)\r
 199 {\r
 200 ?>\r
 201                         <tr>\r
 202                                 <td style="width:20%"><?php echo $fields_array[$i]["FieldName"]; ?></td>\r
 203                                 <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
 204                         </tr>\r
 205 <?php\r
 206 }\r
 207 ?>\r
 208                         </tbody>\r
 209                 </table>\r
 210                 <small>&middot; <?php echo _AT('certificate_tokens'); ?></small>\r
 211         </div>\r
 212 \r
 213         <div class="row buttons">\r
 214                 <input type="submit" name="submit" value=" <?php echo _AT('save'); ?> " accesskey="s" />\r
 215                 <input type="submit" name="cancel" value=" <?php echo _AT('cancel'); ?> " />\r
 216         </div>\r
 217 \r
 218 </div>\r
 219 </form>\r
 220 \r
 221 <script language="javascript" type="text/javascript">\r
 222 function disable_texts (name) {\r
 223         if (name == 'both')\r
 224         {\r
 225                 document.form['passpercent'].disabled=true;\r
 226                 document.form['passscore'].disabled=true;\r
 227                 document.form['passpercent'].value=0;\r
 228                 document.form['passscore'].value=0;\r
 229         }\r
 230         else if (name == 'percentage')\r
 231         {\r
 232                 document.form['passpercent'].disabled=true;\r
 233                 document.form['passpercent'].value=0;\r
 234                 document.form['passscore'].disabled=false;\r
 235         }\r
 236         else if (name == 'points')\r
 237         {\r
 238                 document.form['passpercent'].disabled=false;\r
 239                 document.form['passscore'].disabled=true;\r
 240                 document.form['passscore'].value=0;\r
 241         }\r
 242 }\r
 243 </script>\r
 244 \r
 245 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>\r