getRowSQL("SELECT * FROM tblCourse WHERE CourseID = ". $xdb->qs($CID));
header("Content-type: application/ms-excel");
header("Content-Disposition: attachment; filename=KM_". str_replace(" ","", $row->strCourse) ."_". str_replace("/","_", $row->strCourseCode) ."_".date("Y-m-d").".xls");
echo $page->getCourseSchedule($CID);
die;
}
$rstCourses = $xdb->doQuery("
SELECT tblCourse.CourseID, tblCourse.refCourseTypeID, tblCourse.strCourse, tblCourse.strCourseHTML, tblCourse.strCourseCode, tblCourse.dblCost, tblCourse.dtStartDate, tblCourse.dtEndDate, tblCourse.blnActive, tblCourse.strLastUser, tblCourse.dtLastEdit, tblLicence.refLearnerID, tblLicence.strStatus, Sum(modAssignment.intMarks) AS SumOfintMarks
FROM modAssignment RIGHT JOIN (modModule RIGHT JOIN (tblLicence INNER JOIN tblCourse ON tblLicence.refCourseID = tblCourse.CourseID) ON modModule.refCourseID = tblCourse.CourseID) ON modAssignment.refModuleID = modModule.ModuleID
WHERE tblCourse.blnWorkshop = 0
GROUP BY tblCourse.CourseID, tblCourse.refCourseTypeID, tblCourse.strCourse, tblCourse.strCourseHTML, tblCourse.strCourseCode, tblCourse.dblCost, tblCourse.dtStartDate, tblCourse.dtEndDate, tblCourse.blnActive, tblCourse.strLastUser, tblCourse.dtLastEdit, tblLicence.refLearnerID, tblLicence.strStatus
HAVING (((tblCourse.dtEndDate)>=LEFT('$DT',10)) AND ((tblLicence.refLearnerID)=". $page->Learner->LearnerID .") AND ((tblLicence.strStatus)='Active'))
", 0);
while($rowCourse = $xdb->fetch_object($rstCourses))
{
$row = $xdb->getRowSQL("SELECT COUNT(refLearnerID) as intLearners FROM (SELECT DISTINCT refLearnerID FROM tblLicence WHERE refCourseID = $rowCourse->CourseID AND strStatus='Active') as tblDir");
$strCourses .= "
$rowCourse->strCourse
Welcome and congratulations. You are one of $row->intLearners people who have signed up for this course. We sincerely believe that this is going to make a difference in your working life.
";
//print_rr($rowCourse);
if(($rowCourse->refCourseTypeID != 8) && ($rowCourse->refCourseTypeID != 9) && ($rowCourse->refCourseTypeID != 10))
{
$strCourses .= "
Your course program is as follows: To print your Course program, click here.
".$page->getCourseSchedule($rowCourse->CourseID);
}
$strCourses .= "".$page->getCourseCoordinators($rowCourse->CourseID);
}//eoCourses
$page->Content = "Online learning courses
";
$page->Content .= getTypoIframe($id="hidden/courses/");
//$page->Content .= $strCourses;
/*
Technical requirements
In order to access the course material you will need to have Adobe Acrobat Reader installed on your computer. If you do not have this program or would like an updated version thereof, click here.$BR$BR
Certain module contains a brief video clip. In order to view this material you will need to have Windows Media Player or a similar program installed on your computer. If you do not have such a program, please refer to your IT support technician for assistance.
Adhere to your company requirements
The notes, material and templates provided by KnowMore are based on industry best principles and are carefully researched. However, there may be very valid reasons for doing things differently in your business. This is often the case when it comes to technology.
Before implementing new ideas and suggestions, always check your company’s business guidelines and IT policies before you proceed.
*/
$page->Display();
?>