+++ /dev/null
-<?php\r
-\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require_once (AT_INCLUDE_PATH.'vitals.inc.php');\r
-\r
-function initialize_default_vars()\r
-{\r
- global $default_certificate, $default_organization, $fields_array;\r
- \r
- $default_certificate = "default_certificate.pdf";\r
- $default_organization = "Fraser Health Authority";\r
- \r
- $fields_array = load_field_data("default_certificate.pdf.fields");\r
-}\r
-\r
-function load_field_data( $field_report_fn )\r
-{\r
- $ret_val= array();\r
-\r
- $fp= fopen( $field_report_fn, "r" );\r
- \r
- if( $fp ) \r
- {\r
- $line= '';\r
- $rec= array();\r
- \r
- while( ($line= fgets($fp, 2048))!== FALSE ) \r
- {\r
- $line= rtrim( $line );\r
- \r
- if( $line== '---' ) \r
- {\r
- if( 0< count($rec) ) \r
- { // end of record\r
- $ret_val[]= $rec;\r
- $rec= array();\r
- }\r
- continue;\r
- }\r
-\r
- $data_pos= strpos( $line, ':' );\r
- $name= substr( $line, 0, $data_pos );\r
- $value= substr( $line, $data_pos+ 2 );\r
-\r
- $rec[ $name ]= $value;\r
- }\r
-\r
- if( 0< count($rec)) \r
- { // pack final record\r
- $ret_val[]= $rec;\r
- }\r
-\r
- fclose( $fp );\r
- }\r
-\r
- return $ret_val;\r
-}\r
-\r
-function is_pass_score_defined_in_base_table() \r
-{\r
- global $db;\r
- \r
- $sql = "SELECT passscore, passpercent FROM ".TABLE_PREFIX."tests limit 1";\r
- \r
- if (mysql_query($sql, $db)===false) return false;\r
- else return true;\r
-}\r
-\r
-// Initialize tokens into a global array\r
-function initialize_tokens($result_id)\r
-{\r
- global $db;\r
- \r
- $sql = "SELECT *, date_format(date_taken, '%Y-%m-%d') date_taken \r
- FROM ".TABLE_PREFIX."tests t, ".TABLE_PREFIX."tests_results r \r
- WHERE r.result_id=".$result_id."\r
- AND t.test_id = r.test_id";\r
- $result = mysql_query($sql, $db);\r
- $row = mysql_fetch_assoc($result);\r
- \r
- $tokens[] = array("name"=>"[TNAME]", "value"=>$row["title"]);\r
- $tokens[] = array("name"=>"[USCORE]", "value"=>$row["final_score"]);\r
- $tokens[] = array("name"=>"[OSCORE]", "value"=>$row["out_of"]);\r
- $tokens[] = array("name"=>"[PSCORE]", "value"=>($row["final_score"]/$row["out_of"]*100).'%');\r
- $tokens[] = array("name"=>"[SYSDATE]", "value"=>$row["date_taken"]);\r
-\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."courses c where c.course_id=".$_SESSION["course_id"] ;\r
- $result = mysql_query($sql, $db);\r
- $row = mysql_fetch_assoc($result);\r
- \r
- $tokens[] = array("name"=>"[CNAME]", "value"=>$row["title"]);\r
-\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."members m where m.member_id=".$_SESSION["member_id"] ;\r
- $result = mysql_query($sql, $db);\r
- $row = mysql_fetch_assoc($result);\r
- \r
- $tokens[] = array("name"=>"[USERID]", "value"=>$row["member_id"]);\r
- $tokens[] = array("name"=>"[USERMAIL]", "value"=>$row["email"]);\r
- $tokens[] = array("name"=>"[FNAME]", "value"=>$row["first_name"]);\r
- $tokens[] = array("name"=>"[LNAME]", "value"=>$row["last_name"]);\r
-\r
- return $tokens;\r
-}\r
-\r
-// replace tokens in the pass-in string\r
-// param: $str - string with tokens in\r
-// $tokens - array of matching between token name and value\r
-function replace_tokens($str, $tokens)\r
-{\r
- foreach ($tokens as $token)\r
- $str = str_replace($token["name"], $token["value"], $str);\r
- \r
- return $str;\r
-}\r
-\r
-if ($include_javascript)\r
-{\r
-?>\r
-\r
-<script language="JavaScript">\r
-function open_certificate_win(certificate_url, radio_name, hidden_name)\r
-{\r
- // find selected radio button\r
- var radio_value = 0;\r
- var hidden_value = 0;\r
-\r
- if (eval("document.form."+radio_name+".length") > 0)\r
- {\r
- for( i = 0; i < eval("document.form."+radio_name+".length"); i++ )\r
- {\r
- if( eval("document.form."+radio_name+"[i].checked") == true )\r
- {\r
- radio_value = eval("document.form."+radio_name+"[i].value");\r
- hidden_value = eval("document.form."+hidden_name+"[i].value");\r
- }\r
- }\r
- }\r
- else\r
- {\r
- if( eval("document.form."+radio_name+".checked") == true )\r
- {\r
- radio_value = eval("document.form."+radio_name+".value");\r
- hidden_value = eval("document.form."+hidden_name+".value");\r
- }\r
- }\r
-\r
- certificate_url = certificate_url.replace(/{radio_value}/, radio_value);\r
- certificate_url = certificate_url.replace(/{hidden_value}/, hidden_value);\r
- \r
- window.open (certificate_url, 'Certificate')\r
-}\r
-\r
-</script>\r
-\r
-<?php\r
-}\r
-?>\r