.

Online Essential Training Record

 
 
<< Go back

 

Below is a list of ALL e-learning courses and MOTs (e-assessments) completed by:

$firstname $lastname "; ?>  

Annual Essential Skills Assessment Completed:
"; //select the table $result = mysql_query("select * from mdl_scorm INNER JOIN mdl_scorm_scoes_track ON mdl_scorm_scoes_track.scormid=mdl_scorm.id where element ='cmi.core.score.raw' and course = 210 and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["value"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["value"]; $message=$r[""]; $date=$r[""]; $time=$r["timemodified"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 99 ): echo " Passed
______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } echo "


E-Learning Courses Completed:
"; $result = mysql_query("select * from mdl_scorm INNER JOIN mdl_scorm_scoes_track ON mdl_scorm_scoes_track.scormid=mdl_scorm.id where element ='cmi.core.score.raw' and (course = '148' or course = '147' or course = '143' or course = '79' or course = '157' or course ='185' or course ='184'or course ='187' or course ='186' or course ='188' or course ='190' or course ='198' or course ='211' or course ='215' or course ='217' or course ='202') and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["value"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["value"]; $message=$r[""]; $date=$r[""]; $time=$r["timemodified"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 59 AND $who == "Health & Safety Update"): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; elseif($id > 99 AND $who == "192 Essential Skills Assessment 2013/14"): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; elseif($id > 69 ): echo " Passed
______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } $result = mysql_query("select * from mdl_quiz INNER JOIN mdl_quiz_attempts ON mdl_quiz.id=mdl_quiz_attempts.quiz where (course = '29' or course = '19' or course = '20' or course = '30' or course = '61' or course = '73' or course = '78' or course = '15' or course = '170' or course ='186' or course ='182' or course ='189' or course ='190' or course ='192') and timefinish > 1 and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["sumgrades"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["sumgrades"]; $message=$r["competency"]; $score=$r["sumgrades"]; $time=$r["timefinish"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 1 AND $who == "Safeguarding Children - Agreement"): // Note the combination of the words. echo " Passed
_______________________________________________________________________"; elseif($id > 16.99999999 AND $who == "Fire Safety - Test"): echo " Passed
______________________________________________________________________"; elseif($id > 9 AND $who == "Basic Infection Control - Test"): echo " Passed
______________________________________________________________________"; elseif($id > 9 AND $who == "Inanimate Loads - Assessment"): echo " Passed
______________________________________________________________________"; elseif($id > 6.5 AND $who == "Information Governance - Test"): echo " Passed
______________________________________________________________________"; elseif($id > 9 AND $who == "Adult Drug Calculations Test"): echo " Passed
______________________________________________________________________"; elseif($id > 6 AND $who == "Practice your metric skills"): echo " Passed
______________________________________________________________________"; elseif($id > 1 AND $who == "Root Cause Analysis - Agreement"): echo " Passed
______________________________________________________________________"; elseif($id > 10 AND $who == "Mentor Update Assessment"): echo " Passed
______________________________________________________________________"; elseif($id > 26 AND $who == "Paediatric Drug Calculations Test"): echo " Passed
______________________________________________________________________"; elseif($id > 30 AND $who == "Neonatal Drug Calculations Test"): echo " Passed
______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } echo "


MOTs Completed:
"; //select the table $result = mysql_query("select * from mdl_scorm INNER JOIN mdl_scorm_scoes_track ON mdl_scorm_scoes_track.scormid=mdl_scorm.id where element ='cmi.core.score.raw' and (course = '119' or course = '163' or course ='180' or course ='183') and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["value"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["value"]; $message=$r[""]; $date=$r[""]; $time=$r["timemodified"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 59 AND $who == "Health & Safety Update"): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; elseif($id > 69 ): echo " Passed
______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } echo "


Induction Modules Completed:
"; //select the table $result = mysql_query("select * from mdl_scorm INNER JOIN mdl_scorm_scoes_track ON mdl_scorm_scoes_track.scormid=mdl_scorm.id where element ='cmi.core.score.raw' and (course = '136' or course = '152' or course = '169' or course = '172') and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["value"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["value"]; $message=$r[""]; $date=$r[""]; $time=$r["timemodified"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 59 AND $who == "Health & Safety Update"): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; elseif($id > 69 ): echo " Passed
______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } $result = mysql_query("select * from mdl_scorm INNER JOIN mdl_scorm_scoes_track ON mdl_scorm_scoes_track.scormid=mdl_scorm.id where element ='cmi.core.lesson_status' and course =136 and scormid =731 and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["value"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["value"]; $message=$r[""]; $date=$r[""]; $time=$r["timemodified"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who
.............Date Completed: $time
"; if($id != "" AND $who == "Fraud Prevention"): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } $result = mysql_query("select * from mdl_quiz INNER JOIN mdl_quiz_attempts ON mdl_quiz.id=mdl_quiz_attempts.quiz where (course = '34') and userid = '".$user."'" ); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["sumgrades"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["sumgrades"]; $message=$r[""]; $score=$r["sumgrades"]; $time=$r["timefinish"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 6 ): // Note the combination of the words. echo " Passed!
_______________________________________________________________________"; else: echo " Not Passed
_______________________________________________________________________"; endif; } $result = mysql_query("select * from mdl_quiz INNER JOIN mdl_quiz_attempts ON mdl_quiz.id=mdl_quiz_attempts.quiz where (course = 152 or course = 172) and userid = '".$user."'" ); mysql_close($link); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = $r["nameofmysqlcolumn"]; //modify these to match your mysql table columns $title=$r["sumgrades"]; $who=$r["name"]; $time2=$r["timemodified"]; $id=$r["sumgrades"]; $message=$r["competency"]; $score=$r["sumgrades"]; $time=$r["timefinish"]; $time=date( 'd/m/Y', $time ); //display the row echo "
$who

Score:$title .............Date Completed: $time
"; if($id > 1 AND $who == "Safeguarding Children Agreement"): // Note the combination of the words. echo " Passed
_______________________________________________________________________"; elseif($id > 3.4 AND $who == "Fire Safety"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Health & Safety"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Infection Control"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Moving & Handling"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Information Governance"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Counter Fraud"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Equality & Diversity"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Incidents, Claims & Complaints"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Major Incidents"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Medical Devices"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Chaplaincy Agreement"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "POVA Agreement"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Occupational Health Agreement"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Occupational Health Agreement"): echo " Passed
______________________________________________________________________"; elseif($id > 3.4 AND $who == "Apraisal Training"): echo " Passed
______________________________________________________________________"; elseif($id > 0 AND $who == "Training Self-certification"): echo " Passed
______________________________________________________________________"; elseif($id < 3 ): echo""; else: echo " Not Passed
_______________________________________________________________________"; endif; } ?>

 



_______________________________________________________________________________________