<?
include('auth.php');
include('common.php');

$do_close=0;

if (count($_POST) > 0)
{
	$SQL="INSERT INTO tutor_learner (tutor_id, learner_id, alive) VALUES ('".$_POST['tid']."','".$_POST['lid']."','1')";
	$results = llnb_query($SQL);
	$do_close=1;
}
else
{
	//council- fetch council code associated with learner
	$SQL="SELECT firstname, lastname, council_id FROM learner WHERE id=".$_GET['lid'];
	$results = llnb_query($SQL);
	$rowlearner = llnb_fetch_assoc($results);
	$c=$rowlearner['council_id'];

	$SQL="SELECT * FROM tutor WHERE council_id=".$_GET['c']." AND id NOT IN 
			(SELECT tutor_id FROM tutor_learner WHERE learner_id=".$_GET['lid']." AND alive=1) " ; 
	$results = llnb_query($SQL);

	$options.="<select name=\"tid\" title=\"tutors\">";
	
	$i=0;
	while($row = llnb_fetch_assoc($results))
	{
		$options.="<option value=\"".$row['id']."\">".$row['firstname']." ".$row['lastname']."</option>\n";
		$i++;
	}
	$options.="</select>";
	
	if ($i==0)
		$options ="No tutors match criteria";

}
?>
<head>
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/llnb-style.css">
</head>





<style type="text/css">
body { background-color: #fff; background-image:none; padding: 20px;}

div { font-family: sans-serif; color: #222; }

.btn	{ -moz-border-radius: 7px; -webkit-border-radius: 7px; -khtml-border-radius: 7px; border-radius: 7px; border: 1px #222 solid; background-image: url(img/btn-bg-nor.jpg) ; line-height: 25px; padding: 3px 10px 0; text-decoration: none; color: #222; }
.btn:hover	{ border-color: #33C; color: #33c;}

.btnhidden {border-color: #CCC; background-image: none; font-size: .8em;}

.btncnt	{ width: 160px; text-align:center; display: block; margin-bottom: 10px;}

.btnlrg	{width: 300px; padding-left: 20px;}
.btnsml	{ padding: 1px 10px; font-weight: bold;}
.btnpg	{ padding: 2px 4px 1px; font-size: .75em;margin-right: 4px;}

.lfr	{ float: right; margin-right: 10px;}
.lfl	{ float: left; margin-right: 10px;}
form label { display:block; margin-top: 10px; font-size: .8em; color: #555; }
.session { margin-bottom: 15px; padding-bottom: 10px;}
.talrg	{ width: 460px; height: 60px;}

input.ssminp[type="text"] {width: 40px;}
input.sminp[type="text"] {width: 80px;}
input.btn { height: 30px;}


</style>

<body onLoad="document.forms.addtutor.tutors.focus(); ">
<? 
if ($do_close) 
	echo "<script>parent.location.href='learner_assignedtutor.php?lid=".$_POST['lid']."';</script>"; 

?>

<div style="width: 500px;">
<h2>Add Tutor for:<br />
  Learner <? echo $rowlearner['firstname']." ".$rowlearner['lastname']; ?></h2>
<form name="addtutor" action="learner_addtutor_m.php" method="post">

<div style="float:left; display:block; margin-bottom: 15px;">

<label style="display:block;">Select a tutor form the list:</label>

<input type="hidden" name="lid" value="<?=$_GET['lid'];?>">

<?=$options;?>


<div style="clear:both;"></div>


<p class="clearfix">
<?
if ($i>0)
 echo "<input type=\"submit\"  class=\"btnlfr_m\" value=\"Save &amp; Close\">"; 
?>
<a href="#" onclick="parent.SqueezeBox.close();"class="btn lfr">Cancel</a></p>
</form>
</div>