getVars($_POST); $get->getVars($_GET); $s->getVars($_SESSION); } switch($action){ //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // gentranscript //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"gentranscript": include_once("../lib/dynamicImageTool.php"); // figure out if we have a passing student...and where from... $result = $db->query("SELECT * FROM users WHERE user_id='$s->suser_id'"); if ($result->numRows()==0){ print<<An unknown error occured processing your transcript. Please contact the management.

"; eof; } $result->fetchInto($row); $result->free(); $result=$db->query("SELECT * FROM grades WHERE user_id='$row->user_id' AND class_id='$get->class_id'"); $result->fetchInto($grade); if ($grade->paid!="y"){ // no cert for you... include("inc/head.php"); print<<Error

The system shows you have not yet paid for your class and as such you may not download your transcript.

If you feel you should be able to download your transcript(s), please contact the administrators.

Return to classes

eof; include("inc/foot.php"); exit; } $attendanceGrade = round($grade->attendance,2); $courseGrade=$grade->finalGrade; if ($courseGrade>93){ $finalGrade = "A"; }elseif(($courseGrade>89)&&($courseGrade<=93)){ $finalGrade="A-"; }elseif(($courseGrade>86)&&($courseGrade<=89)){ $finalGrade="B+"; }elseif(($courseGrade>83)&&($courseGrade<=86)){ $finalGrade="B"; }elseif(($courseGrade>79)&&($courseGrade<=83)){ $finalGrade="B-"; }elseif(($courseGrade>76)&&($courseGrade<=79)){ $finalGrade="C+"; }elseif(($courseGrade>73)&&($courseGrade<=76)){ $finalGrade="C"; }elseif(($courseGrade>69)&&($courseGrade<=73)){ $finalGrade="C-"; }elseif(($courseGrade>66)&&($courseGrade<=69)){ $finalGrade="D+"; }elseif(($courseGrade>=64)&&($courseGrade<=66)){ $finalGrade="D"; }else{ $finalGrade="F"; } $fullname=strtoupper("$row->firstname $row->lastname"); $studentIdentifier=strtoupper($row->student_identifier); $location = $db->getOne("SELECT schoolLocation FROM classes WHERE class_id='$grade->class_id'"); $name=$fullname; $template="CO"; if($location=="Stockton, CA"){ $template="CA"; } if($location=="Scottsdale, AZ"){ $template = "AZ"; } if($location=="Erie Coast, OH"){ $template = "OH"; } if(($location=="Plano, TX")||($location=="North Dallas, TX")||($location =="Conroe, TX")){ $template = "TX"; } if($location=="Vancouver, WA"){ $template = "WA"; } if(($location=="Las Vegas, NV") ||($location == "Carson City, NV")){ $template = "NV"; } $grades=array(); $grades["finalGrade"] = $finalGrade; $grades["attendance"]=$attendanceGrade." %"; $completedDate = $db->getOne("SELECT endDate FROM classes WHERE class_id='$grade->class_id'"); $filename=generateTranscript($name,$studentIdentifier,$template,$grades,$location,$completedDate); garbageCollection(); if (!function_exists('mime_content_type')) { function mime_content_type($f) { $f = escapeshellarg($f); return trim( `file -bi $f` ); } } $mimeType =mime_content_type("../images/temp/$filename.jpg"); $filename="../images/temp/$filename.jpg"; $filesize=filesize("$filename"); header("Pragma: public"); header("Expires: 0"); // set expiration time header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: $mimeType"); header("Content-Disposition: attachment; filename=".basename($filename).";"); header("Content-Transfer-Encoding: binary"); header("Content-Length: " .$filesize.";"); $fh = fopen( $filename , "r"); fpassthru($fh); exit; break; //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// // default //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// default: // check to see if they have passed... print<<

Download your Transcript

[ Return to Classes ]

eof; $res= $db->query("SELECT classes.* FROM classes LEFT JOIN students USING(class_id) WHERE students.user_id='$s->suser_id' ORDER BY classes.className ASC"); if ($res->numRows()==0){ print<<You have not been enrolled in any classes. eof; } $printed=0; while($res->fetchInto($row)){ print<<

$row->className - $row->schoolLocation

eof; $className=$db->getOne("SELECT className FROM classes where class_id='$row->class_id'"); $schoolLocation=$db->getOne("SELECT schoolLocation FROM classes where class_id='$row->class_id'"); if (($schoolLocation =="South Denver, CO")||($schoolLocation=="Broomfield, CO")||($schoolLocation=="Grand Junction, CO")){ // CO certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript. Click the below link to generate and download your transcript.
Click here to download your transcript. eof; }else if ($schoolLocation =="Stockton, CA"){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else if (($schoolLocation =="North Dallas, TX")||($schoolLocation =="Plano, TX")||($schoolLocation =="Conroe, TX")){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else if ($schoolLocation =="Erie Coast, OH"){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else if (($schoolLocation =="Las Vegas, NV") || ($schoolLocation == "Carson City, NV")){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else if ($schoolLocation =="Scottsdale, AZ"){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else if ($schoolLocation =="Vancouver, WA"){ // ca certs print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; }else{ print<<

You have successfully completed the Dental Assisting Course at the Colorado School of Denal Assisting consisting of 152 hours of course work. You are now eligible to get your transcript.. Click the below link to generate and download your transcript..
Click here to download your transcript. eof; } } print<<

Download and Printing Instructions

1. Click on the link above that states, “Click here to download your...”
2. Choose a location to save the .jpg file
3. Find the file in the folder in which it was saved
4. Double click the .jpg file to automatically open it
(NOTE: .jpg files are a common format that will open with various programs found on your computer)
5. Print the file if a hard copy is desired
eof; break; } include("inc/foot.php"); ?>