<?php
mysql_select_db($db_name,$cnx);

if(isset($_POST["status"])){					 //if the user has used "ooo form" and has POST something
		if($_SESSION["time3"]==$_POST["time4"]){ //if it is not because of a refresh
				$status = beforeInsert ($_POST["status"]);			
				if(isset($_POST["reason"])) {	 //if the user has typed a reason
						$reason = beforeInsert ($_POST["reason"]);
						$sql_status_up = "UPDATE people SET status='".$status."', reason='".$reason."' WHERE login='".$_SESSION['login']."'"; //add it to the database and change status to ooo
				}
				else {
						$sql_status_up = "UPDATE people SET status='".$status."', reason='' WHERE login='".$_SESSION['login']."'";  //else only change to ooo
				}
		$req_status_up = mysql_query($sql_status_up, $cnx) or $error= mysql_error();//add ooo status and the reason why he's "ooo". 
		}
}
$_SESSION["time3"] = mktime();

$sql_status = "SELECT status,reason FROM people WHERE login='".$_SESSION['login']."'"; //select the status and if his out why
$req_status = mysql_query($sql_status) or die('Erreur SQL !<br>'.$sql_status.'<br>'.mysql_error()); 
$result = mysql_fetch_assoc($req_status);
if($result['status'] == 'in') { // print your own status
			$ooo = '    <li><input type="radio" name="status" value="ooo">Change to OOO<img src="files/ooo.jpg" width="15" height="18" alt="Out Of the Office"></li><li><TEXTAREA rows="2" cols="16" name="reason">I\'m on holiday back on...</TEXTAREA></li><li><input type="submit" value="confirm"></li>';
} 
else {
			$ooo = '    <li><input type="radio" name="status" value="in">Change to in</li><li><input type="submit" value="confirm"></li>';
}
?>
	<ul class="menu">
	<form method="post" action="<?php getUrl();?>">	
	<input type="hidden" name="time4" value="<?php echo mktime() ; ?>">
	<li>You're <?php echo $result['status']?> <img src="files/<?php echo ''.$result['status'].'.jpg';?>" width="15" height="18" alt="status in/ooo"></li>
	<?php echo $ooo;?>
	</ul>

<form action="index.php" method="get">
	<input type="hidden" name="p" value="_phone_book"> 
	search by department :
	<SELECT name="department">
		<OPTION VALUE=""></OPTION>
<?php
		mysql_select_db($db_name,$cnx);
		$sql_d = 'SELECT id,department FROM department ORDER BY department.department';
		$req_d = mysql_query($sql_d) or die('Error SQL !<br>'.$sql_d.'<br>'.mysql_error());
   	while($data_d = mysql_fetch_assoc($req_d)) {
				echo '<OPTION VALUE="'.stripslashes($data_d['id']).'">'.displayFromDb ($data_d['department']).'</OPTION>';
		}
?>
	</SELECT>
	<input type="submit" value="search">
</form>

	<form action="index.php" method="get">
	<input type="hidden" name="p" value="_phone_book"> 
	search by department : &nbsp&nbsp&nbsp
	<input type="text" name="department" size="25">
	<input type="submit" value="search">
	</form>