courseSchedule_id'"; $res = $db->query($q); $res->fetchInto($row); $out = new aLearnPrint($db,$config); $out->setCourse($row->course_id); $time->dbdate = $row->startDate; $startMonth = $time->datetime2monthname(); $startDay = $time->datetime2day(); $startYear = $time->datetime2year(); $time->dbdate = $row->endDate; $endDay = $time->datetime2day(); $endMonth = $time->datetime2monthname(); $endYear = $time->datetime2year(); $row->courseNotes = nl2br($row->courseNotes); $row->coursePrice=number_format($row->coursePrice,2); print<<$row->courseName Course Details - Register Now

$row->courseLocation

$startMonth $startDay $startYear - $endMonth $endDay $endYear $classStatus

eof; $days = array(); $dayCells=''; $res = $db->query("SELECT DISTINCT(DAYNAME(the_day))AS day FROM courseScheduleDays WHERE courseSchedule_id='$get->courseSchedule_id' AND the_text='' ORDER BY the_day ASC"); while($res->fetchInto($r)){ array_push($days,$r->day); /* print<<$r->day eof; */ $dayCells.=<<$r->day eof; } $res->free(); $res = $db->query("SELECT *,DATE_ADD(endDate,INTERVAL 1 DAY) as theEnd FROM courseSchedule WHERE courseSchedule_id='$get->courseSchedule_id'"); $res->fetchInto($row); $res->free(); $db->query("CALL interval_between('$row->startDate', '$row->theEnd', 'DAY', 1)"); $res = $db->query("SELECT interval_from,date_format(interval_from,'%W %b %e') as date,DAYNAME(interval_from) AS dayname,WEEK(interval_from) as week, YEAR(interval_from) AS year, MONTHNAME(interval_from) AS month FROM time_intervals ORDER BY interval_from ASC"); $month=""; $dayCount = count($days); while($res->fetchInto($row)){ if(($month!=$row->month) || ($month=="")){ $span = $dayCount+1; $month = $row->month; print<< $dayCells eof; } $result = $db->query("SELECT * FROM courseScheduleDays WHERE the_day = '$row->interval_from' AND courseSchedule_id='$get->courseSchedule_id' AND the_text=''"); if($result->numRows()>0){ $result->fetchInto($d); if($d->is_class=="Yes"){ print""; } if($d->the_text!=''){ print""; } if($d->is_lab=="Yes"){ print""; } } if($row->dayname == end($days)){ print""; } } print<<

$month $row->year
	$row->date Class	$row->date $d->the_text	$row->date Lab

eof; break; /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //viewdate /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// case"viewdate": $q = "SELECT courses.*, courseSchedule.* FROM courseSchedule LEFT JOIN courses USING(course_id) WHERE courseSchedule.courseSchedule_id='$get->courseSchedule_id'"; $res = $db->query($q); $res->fetchInto($row); $out = new aLearnPrint($db,$config); $out->setCourse($row->course_id); $time->dbdate = $row->startDate; $startMonth = $time->datetime2monthname(); $startDay = $time->datetime2day(); $startYear = $time->datetime2year(); $time->dbdate = $row->endDate; $endDay = $time->datetime2day(); $endMonth = $time->datetime2monthname(); $endYear = $time->datetime2year(); $row->courseNotes = nl2br($row->courseNotes); $row->coursePrice=number_format($row->coursePrice,2); if($row->scheduleFile!=''){ $scheduleLink.=<<Download Schedule
eof; }else{ $scheduleLink = ""; } $classStatus = ''; if($row->remainingSpaces<1){ $classStatus.=<<Full eof; }else{ $classStatus.=<<$row->remainingSpaces SEATS LEFT eof; } $product_id=$db->getOne("SELECT product_id FROM coursesToProducts WHERE courseSchedule_id='$row->courseSchedule_id'"); print<<$row->courseName Course Details - Register Now

Go Back

$row->courseLocation

$startMonth $startDay $startYear - $endMonth $endDay $endYear $classStatus

View course Schedule

$scheduleLink $$row->coursePrice

Notes:
$row->courseNotes

eof; $out->printOutline(); break; /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //default /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// default: $out = new aLearnPrint($db,$config); print<<Dental Assisting Courses Calendar

Below is a listing of upcomming Dental Assisting Courses available at our various locations.

eof; $res = $db->query("SELECT distinct(course_id) FROM courseSchedule WHERE endDate>NOW() ORDER BY startDate ASC"); while($res->fetchInto($r)){ $out->setCourse($r->course_id); $course=$out->fetchCourse(); print<<UPCOMING $course->courseName Dates
eof; $q = "SELECT courses.*, courseSchedule.* FROM courseSchedule LEFT JOIN courses USING(course_id) WHERE courseSchedule.course_id='$course->course_id' AND courseSchedule.endDate>NOW() ORDER BY courseSchedule.startDate ASC"; $result = $db->query($q); while ($result->fetchInto($row)) { $time->dbdate = $row->startDate; $startMonth = $time->datetime2monthname(); $startDay = $time->datetime2day(); $startYear = $time->datetime2year(); $time->dbdate = $row->endDate; $endDay = $time->datetime2day(); $endMonth = $time->datetime2monthname(); $endYear = $time->datetime2year(); $row->coursePrice=number_format($row->coursePrice,2); if($row->scheduleFile!=''){ $scheduleLink.=<<Download Schedule
eof; }else{ $scheduleLink = ""; } $product_id=$db->getOne("SELECT product_id FROM coursesToProducts WHERE courseSchedule_id='$row->courseSchedule_id'"); print<<$startMonth $startDay $startYear - $endMonth $endDay, $endYear -- $row->courseLocation
More Information
View course Schedule
$scheduleLink Register Now

eof; } } break; } include("inc/foot.php"); ?>