mods/certificate/common.inc.php

   1 <?php\r
   2 \r
   3 define('AT_INCLUDE_PATH', '../../include/');\r
   4 require_once (AT_INCLUDE_PATH.'vitals.inc.php');\r
   5 \r
   6 function initialize_default_vars()\r
   7 {\r
   8         global $default_certificate, $default_organization, $fields_array;\r
   9         \r
  10         $default_certificate = "default_certificate.pdf";\r
  11         $default_organization = "Fraser Health Authority";\r
  12         \r
  13         $fields_array = load_field_data("default_certificate.pdf.fields");\r
  14 }\r
  15 \r
  16 function load_field_data( $field_report_fn )\r
  17 {\r
  18   $ret_val= array();\r
  19 \r
  20   $fp= fopen( $field_report_fn, "r" );\r
  21   \r
  22   if( $fp ) \r
  23   {\r
  24     $line= '';\r
  25     $rec= array();\r
  26     \r
  27     while( ($line= fgets($fp, 2048))!== FALSE ) \r
  28     {\r
  29       $line= rtrim( $line );\r
  30       \r
  31       if( $line== '---' ) \r
  32       {\r
  33                                 if( 0< count($rec) ) \r
  34                                 { // end of record\r
  35                                   $ret_val[]= $rec;\r
  36                                   $rec= array();\r
  37                                 }\r
  38                                 continue;\r
  39         }\r
  40 \r
  41       $data_pos= strpos( $line, ':' );\r
  42       $name= substr( $line, 0, $data_pos );\r
  43       $value= substr( $line, $data_pos+ 2 );\r
  44 \r
  45                         $rec[ $name ]= $value;\r
  46     }\r
  47 \r
  48     if( 0< count($rec)) \r
  49     { // pack final record\r
  50       $ret_val[]= $rec;\r
  51     }\r
  52 \r
  53     fclose( $fp );\r
  54   }\r
  55 \r
  56   return $ret_val;\r
  57 }\r
  58 \r
  59 function is_pass_score_defined_in_base_table() \r
  60 {\r
  61         global $db;\r
  62         \r
  63         $sql    = "SELECT passscore, passpercent FROM ".TABLE_PREFIX."tests limit 1";\r
  64         \r
  65         if (mysql_query($sql, $db)===false) return false;\r
  66         else return true;\r
  67 }\r
  68 \r
  69 // Initialize tokens into a global array\r
  70 function initialize_tokens($result_id)\r
  71 {\r
  72         global $db;\r
  73         \r
  74         $sql = "SELECT *, date_format(date_taken, '%Y-%m-%d') date_taken \r
  75                   FROM ".TABLE_PREFIX."tests t, ".TABLE_PREFIX."tests_results r \r
  76                  WHERE r.result_id=".$result_id."\r
  77                    AND t.test_id = r.test_id";\r
  78         $result = mysql_query($sql, $db);\r
  79         $row = mysql_fetch_assoc($result);\r
  80         \r
  81         $tokens[] = array("name"=>"[TNAME]", "value"=>$row["title"]);\r
  82         $tokens[] = array("name"=>"[USCORE]", "value"=>$row["final_score"]);\r
  83         $tokens[] = array("name"=>"[OSCORE]", "value"=>$row["out_of"]);\r
  84         $tokens[] = array("name"=>"[PSCORE]", "value"=>($row["final_score"]/$row["out_of"]*100).'%');\r
  85         $tokens[] = array("name"=>"[SYSDATE]", "value"=>$row["date_taken"]);\r
  86 \r
  87         $sql = "SELECT * FROM ".TABLE_PREFIX."courses c where c.course_id=".$_SESSION["course_id"] ;\r
  88         $result = mysql_query($sql, $db);\r
  89         $row = mysql_fetch_assoc($result);\r
  90         \r
  91         $tokens[] = array("name"=>"[CNAME]", "value"=>$row["title"]);\r
  92 \r
  93         $sql = "SELECT * FROM ".TABLE_PREFIX."members m where m.member_id=".$_SESSION["member_id"] ;\r
  94         $result = mysql_query($sql, $db);\r
  95         $row = mysql_fetch_assoc($result);\r
  96         \r
  97         $tokens[] = array("name"=>"[USERID]", "value"=>$row["member_id"]);\r
  98         $tokens[] = array("name"=>"[USERMAIL]", "value"=>$row["email"]);\r
  99         $tokens[] = array("name"=>"[FNAME]", "value"=>$row["first_name"]);\r
 100         $tokens[] = array("name"=>"[LNAME]", "value"=>$row["last_name"]);\r
 101 \r
 102         return $tokens;\r
 103 }\r
 104 \r
 105 // replace tokens in the pass-in string\r
 106 // param: $str - string with tokens in\r
 107 //        $tokens - array of matching between token name and value\r
 108 function replace_tokens($str, $tokens)\r
 109 {\r
 110         foreach ($tokens as $token)\r
 111                 $str = str_replace($token["name"], $token["value"], $str);\r
 112                 \r
 113         return $str;\r
 114 }\r
 115 \r
 116 if ($include_javascript)\r
 117 {\r
 118 ?>\r
 119 \r
 120 <script language="JavaScript">\r
 121 function open_certificate_win(certificate_url, radio_name, hidden_name)\r
 122 {\r
 123         // find selected radio button\r
 124         var radio_value = 0;\r
 125         var hidden_value = 0;\r
 126 \r
 127         if (eval("document.form."+radio_name+".length") > 0)\r
 128         {\r
 129                 for( i = 0; i < eval("document.form."+radio_name+".length"); i++ )\r
 130                 {\r
 131                         if( eval("document.form."+radio_name+"[i].checked") == true )\r
 132                         {\r
 133                                 radio_value = eval("document.form."+radio_name+"[i].value");\r
 134                                 hidden_value = eval("document.form."+hidden_name+"[i].value");\r
 135                         }\r
 136                 }\r
 137         }\r
 138         else\r
 139         {\r
 140                 if( eval("document.form."+radio_name+".checked") == true )\r
 141                 {\r
 142                         radio_value = eval("document.form."+radio_name+".value");\r
 143                         hidden_value = eval("document.form."+hidden_name+".value");\r
 144                 }\r
 145         }\r
 146 \r
 147         certificate_url = certificate_url.replace(/{radio_value}/, radio_value);\r
 148         certificate_url = certificate_url.replace(/{hidden_value}/, hidden_value);\r
 149         \r
 150         window.open (certificate_url, 'Certificate')\r
 151 }\r
 152 \r
 153 </script>\r
 154 \r
 155 <?php\r
 156 }\r
 157 ?>\r