<?php
date_default_timezone_set('Europe/Helsinki');
if(isset($_GET['year']) && isset($_GET['month']) && isset($_GET['day'])){
	$time=mktime(0,0,0,$_GET['month'],$_GET['day'],$_GET['year']);
	$time=strtotime(date('Y-m-d',$time).' '.date('H:i'));
} else 
	$time=time();

if(isset($_GET['room'])){
	$room=strtolower(preg_replace('/[^A-Za-z0-9]/i','',$_GET['room']));
	if(strlen($room)>=3){
		if(file_exists('./data/room-cache/'.md5($room))){
			$room=file_get_contents('./data/room-cache/'.md5($room));
			if($room!=''){
				$room=dbSingle('SELECT * FROM palvelu_p WHERE TYYPPI="'.mysql_real_escape_string($room).'";');
				if($room){
					$date=date('ymd',$time);
					$rawbookings=dbMatrix('SELECT * FROM kokousvaraus_p WHERE TYYPPI="'.mysql_real_escape_string($room['TYYPPI']).'" AND PVM="'.mysql_real_escape_string($date).'" ORDER BY AKLO;');
					$bookings=array();
					if($rawbookings){
						foreach($rawbookings as $raw){
							$stamp=strtotime(date('Y-m-d',$time).' '.$raw['LKLO'][0].$raw['LKLO'][1].':'.$raw['LKLO'][2].$raw['LKLO'][3]);
							$new=array();
							$new['group']=array();
							$new['course']=array();
							if(isset($bookings[$stamp])){
								$new=$bookings[$stamp];
								if(trim($raw['LUOKKATUN'])!=''){ $new['group'][]=$raw['LUOKKATUN']; }
								if(trim($raw['KURSSITUN'])!=''){ $new['course'][]=$raw['KURSSITUN']; }
							} else {
								$new['room']=$raw['TYYPPI'];
								$new['title']=$raw['TILAISUUS'];
								if(trim($raw['LUOKKATUN'])!=''){ $new['group'][]=$raw['LUOKKATUN']; }
								if(trim($raw['KURSSITUN'])!=''){ $new['course'][]=$raw['KURSSITUN']; }
								$new['teacher']=$raw['OPETTAJANIMI'];
								$new['starttime']=strtotime(date('Y-m-d',$time).' '.$raw['AKLO'][0].$raw['AKLO'][1].':'.$raw['AKLO'][2].$raw['AKLO'][3]);
								$new['endtime']=strtotime(date('Y-m-d',$time).' '.$raw['LKLO'][0].$raw['LKLO'][1].':'.$raw['LKLO'][2].$raw['LKLO'][3]);
								$new['duration']=($new['endtime'] - $new['starttime'] )/60;
								$new['starttime']=date('H:i',$new['starttime']);
								$new['endtime']=date('H:i',$new['endtime']);
							}
							$new['course']=array_unique($new['course']);
							$new['group']=array_unique($new['group']);
							$bookings[$stamp]=$new;
						}
					}
				} else {
					echo 'Cannot find room ('.$room.') information!';
					die();
				}
			} else {
				echo 'Room information link!';
				die();
			}
		} else {
			echo 'Cannot find room information!';
			die();
		}
	} else {
		echo 'Invalid room number!';
		die();
	}
} else {
	echo 'Room number not defined!';
	die();
}
?>