session_start();
$sess_id = session_id();
include "config.inc.php";
if($_GET[m] == ""){
$month=date('m');
$year=date('Y');
}else{
$getm = explode("/", $_GET[m]);
$month= $getm[0];
$year = $getm[1];
}
$mkdate=mktime(0,0,0,$month,1,$year);
$full_month=date('F',$mkdate);
$weekday=date('w',$mkdate);
$last_days=date('t',$mkdate);
$day=1;
$th_m = array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
$mmm = $th_m[$month-1];
?>
:: NARESUAN UNIVERSITY LANGUAGE CENTRE ::
|
|
echo " $mmm $year "; ?> |
Sun |
Mon |
Tue |
Wed |
Thu |
Fri |
Sat |
$start=1;
while($start<=$weekday)
{
echo " | ";
$start++;
}
$weekday++;
while($day<=$last_days)
{
if($day<10){
$date = "0$day";
}else{
$date = "$day";
}
$sql_date = "SELECT * FROM training_room_timetable where month = '".$mmm."' and date = '".$day."' and year = '".$year."' and course_id != 'Activity'";
$result_date = mysql_db_query($dbname,$sql_date);
$num_date = mysql_num_rows($result_date);
//$array = mysql_fetch_array($result_date);
if($num_date == 0){
$num = "-";
}else{
$num = "$num_date vistors";
}
$num_week = $num_week + $num_date;
$d_tx = "$date";
$week_tx = $week_tx." ".$d_tx;
echo "$day ";
while($array = mysql_fetch_array($result_date))
{
$course_id = $array['course_id'];
$sql_course = "SELECT * FROM training_courses_new where id = '$course_id'";
$result_course = mysql_db_query($dbname,$sql_course);
$array_course = mysql_fetch_array($result_course);
$title = $array_course['title'];
$group = $array_course['num'];
if($array_course['num']== 0)
{ $group = "-";
}
if($array_course['title'] == "Academic Writing II")
{
$title = "ACDM Writing II";
}
if($array_course['title'] == "TOEFL iBT (Internet based test) Preparation")
{
$title = "TOEFL iBT";
}
if($array_course['title'] == "General English Test Preparation")
{
$title = "General English";
}
if($array_course['title'] == "Basic English Grammar")
{
$title = "Grammar";
}
if($array_course['title'] == "English for Business")
{
$title = "Eng for Business";
}
if($array_course['title'] == "English for Communication and Office Work")
{
$title = "Eng for Commu...";
}
if($array_course['title'] == "English for Communication")
{
$title = "Eng for Commu...";
}
if($array_course['title'] == "CU-TEP Preparation")
{
$title = "CU-TEP";
}
if($array_course['title'] == "IELTS Preparation")
{
$title = "IELTS";
}
if($array_course['title'] == "English for Presentation")
{
$title = "Eng Presentation";
}
if($array_course['title'] == "English for Communication (Meeting)")
{
$title = "Eng for Meeting";
}
if($array_course['title'] == "English for Communication (Telephoning)")
{
$title = "Eng for Telephone";
}
if($array_course['title'] == "English for Presentation" and $array_course['num'] == "P1/2556")
{
$title = "Eng Present AHS";
}
if($array_course['title'] == "English for Hospitality Tourism and Airlines Business")
{
$title = "Eng Airlines";
}
if($array_course['title'] == "English Test Preparation Course")
{
$title = "Eng Test Prep";
}
if($array_course['title'] == "Listening Skill Preparation")
{
$title = "Listening Skill";
}
if($array_course['title'] == "English Test Preparation Course(Vocabulary Building)")
{
$title = "Vocab Building";
}
if($array_course['title'] == "Cambridge English Placement Test Preparation")
{
$title = "CEPT";
}
if($array_course['title'] == "Cambridge English Placement Test Preparation (Upper Level)")
{
$title = "CEPT (Upper)";
}
if($array_course['title'] == "Cambridge English Placement Test Preparation (Upper Intermediate -> Advanced Level)")
{
$title = "CEPT (Upper)";
}
if($array_course['title'] == "Cambridge English Placement Test Preparation (Lower Level)")
{
$title = "CEPT (Lower)";
}
if($array_course['title'] == "Cambridge English Placement Test Preparation (Beginner -> Pre-intermediate Level)")
{
$title = "CEPT (Lower)";
}
if($array_course['title'] == "English Usage for Office Work (Emailing)")
{
$title = "Eng for Emailing";
}
if($array_course['title'] == "English for Communication (Listening and Speaking)")
{
$title = "Eng for Commu...";
}
if($array_course['title'] == "Basic Thai 1 for Foreign Students")
{
$title = "Thai for Foreign";
}
if($array_course['title'] == "French for Communication")
{
$title = "French for Com...";
}
if($array_course['title'] == "Elementaire")
{
$title = "Elementaire";
}
if($array_course['title'] == "Elementaire II")
{
$title = "Elementaire II";
}
if($array_course['title'] == "Français sur objectifs spécifiques-FOS")
{
$title = "FOS";
}
if($array_course['title'] == "Débutant 1")
{
$title = "Débutant 1";
}
if($array_course['title'] == "Débutant 2")
{
$title = "Débutant 2";
}
if($array_course['title'] == "Intensive")
{
$title = "Intensive";
}
if($array_course['title'] == "TOEFL Prepareation")
{
$title = "TOEFL";
}
?>
•
}
echo " | ";
if($weekday==7 and $day!=$last_days)
{
// echo "$num_week vistors | ";
echo "";
$weekday=0;
$num_week=0;
$week_tx = "";
}
// $num_week = $num_week + $num_date;
$day++;
$weekday++;
}
while($weekday<=7)
{
// echo " | ";
$weekday++;
}//echo "$num_week vistors | ";
?>
$mo = $m;
$mon = array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
$pre = $month-1;
$nex = $month+1;
if($pre < 10)
{
if($pre == '0'){
$pre = '12';
$year = $year-1;
$pre_m = $mon[$pre];
}else{
$pre_m = $mon[$pre];
$pre = "0$pre";
}
}
if($nex < 10){
$nex = "0$nex";
}else{
if($nex == '13'){
$nex_m = $mon[0];
$nex = '01';
}else{
$nex = $nex;
}
}
mysql_close();
?>
<-Previous month Next month-> |
|
|