<? ob_start();
session_start();
error_reporting(0);
if($_SESSION['professor'] == "professor"){

$socket = mysql_connect($host,$user,$pass) or die(mysql_error());
$res = mysql_db_query($db,"SELECT * FROM turma order by nome asc", $socket);
$numero = mysql_num_rows($res); ?>
<h2 style="font-family: arial;">Sistema de chamada online</h2>
<hr width="100%"></hr>
<table><tr><td>
<form  name="turma" method="post" action="" style="border: 0px; padding: 0px; margin: 0px;">
<?if($_POST[turma]==""){echo "Selecione a turma: ";}else{ echo "Turma selecionada: ";}?>
<select name="turma" id="turma" value="turma" style="width: 200px; background: #FFFF00; border: 1px solid #CC0000;" onChange="document.turma.submit()"/>
<option value="">Selecione</option>
<?
while ($valor=mysql_fetch_array($res)){
?>
<option value="<?=$valor[id];?>" <?if($valor[id] == $_POST[turma]){echo "selected"; }?>><?=$valor[nome];?></option>
<input type="hidden" name="bimestre" value="<?=$_POST[bimestre];?>" >
<input type="hidden" name="nometurma" value="<?=$valor[nome];?>" >
<?}?>
</select>
</form>
</td>

<?if($_POST[turma]==""){break;}
else{?>

<td>
<form  name="bimestre" method="post" action="" style="border: 0px; padding: 0px; margin: 0px;">
<?if($_POST[bimestre]==""){echo "Selecione o bimestre: ";}else{ echo "Bimestre selecionado: ";}?>
<select name="bimestre" id="bimestre" value="bimestre" style="width: 200px; background: #FFFF00; border: 1px solid #CC0000;" onChange="document.bimestre.submit()"/>
<option value="">Selecione</option>
<option value="1" <?if($_POST[bimestre] == "1"){echo "selected"; }?> >1° Bimestre</option>
<option value="2" <?if($_POST[bimestre] == "2"){echo "selected"; }?> >2° Bimestre</option>
<option value="3" <?if($_POST[bimestre] == "3"){echo "selected"; }?> >3° Bimestre</option>
<option value="4" <?if($_POST[bimestre] == "4"){echo "selected"; }?> >4° Bimestre</option>
<input type="hidden" name="turma" value="<?=$_POST[turma];?>" >
<input type="hidden" name="nometurma" value="<?=$_POST[nometurma];?>" >
</select>
</form>
</td></tr></table><?}
if($_POST[bimestre]==""){break;}else{




// Começa mostrar resultador
$socket = mysql_connect($host,$user,$pass) or die(mysql_error());
$res = mysql_db_query($db,"SELECT * FROM professor where id='$identificacao'", $socket);
$valor=mysql_fetch_array($res);
$res2 = mysql_db_query($db,"SELECT * FROM disciplina where id='$valor[disciplina]'", $socket);

//variaveis
$bimestre=$_POST[bimestre];
$id_turma=$_POST[turma];
$nome_turma=$_POST[nometurma];
$id_disciplina=$valor[disciplina];

# Agora vou inserir os dados das faltas dos alunos no banco de dados #

for($a=1; $a <27; $a++){
for($i=1; $i <23; $i++){
$aluno=$_POST['aluno'.$a];
$data_encontro=$_POST['dataencontro'.$i];

$falta=$_POST['falta'.$i.$a];
$var_a=$_POST[$a];
$var_i=$_POST[$i];

if($aluno!=""){
if($data_encontro!=""){
if($falta!=""){
mysql_db_query($db,"insert into falta values('', '$aluno' , '$id_disciplina' , '$data_encontro' , '$falta' , '$bimestre','$id_turma', '$a','$i' )",$socket);

} } }else{
}


} }





#Pronto, está salvo no banco de dados vamos mostrar os resultados...#


$valor2=mysql_fetch_array($res2);

?>
<hr width="100%"></hr>
<table align="left">
<tr><td>Nome do professor: </td><td><?=$valor[nome_professor];?></td></tr>
<tr><td>Disciplina: </td><td><?=$valor2[nome];?></td></tr>
<tr><td>Turma: </td><td><?=$nome_turma;?></td></tr>
<tr><td>Bimestre: </td><td><?=$bimestre;?></td></tr>
</table>
<br clear="all">

<hr width="100%"></hr>
<?
$alunoc = mysql_db_query($db,"SELECT * FROM aluno where turma='$_POST[turma]' order by nome_aluno asc", $socket);
?>
<table width="100%">
<form method="post" action="">
<?for($a=1; $a <27; $a++){


if($a==1){
?>
<tr>
<td style="border: 1px solid black; width: 130px; font-family: arial; font-size: 10px;">
<div style="width: 100%; border-bottom:1px solid black;background: url(direita.gif) no-repeat 98% 0; ">Data encontro</div>
<div style="width: 100%;background: url(baixo.gif) no-repeat 98% 50%; ">Nome do aluno </div></td>
<?}else{?>
<tr>
<td style="border: 1px solid black; width: 130px; font-family: arial; font-size: 10px;">

<?

$pega_aluno=mysql_fetch_array($alunoc);


$aluno=$pega_aluno[nome_aluno];
$alunoid=$pega_aluno[id];

?>
<input type="text" value="<?=$aluno;?>" style="width: 129px; font-family: arial; font-size:10px; border: 0px;">

<INPUT TYPE="hidden" NAME="aluno<?=$a;?>" value="<?=$alunoid;?>">

</td>

<?}for($i=1; $i <23; $i++){

	if($a==1){

//Escolhe a data
?>

<td style="border: 1px solid black; width: 20px; font-family: arial; font-size: 9px;" valign="top" align="center">
<script type="text/javascript" src="dhtmlgoodies_calendar/dhtmlgoodies_calendar.js?random=20060118"></script>
<link type="text/css" rel="stylesheet" href="dhtmlgoodies_calendar/dhtmlgoodies_calendar.css?random=20051112" media="screen"></LINK>

<div style="width: 100%;">
<input type="button" value="<?=$i;?>" style="font-family: arial; font-size:9px; width: 30px; height: 15px; background:#FF0000; border:0px; color: #fff;" onclick="displayCalendar(document.getElementById('dataencontro<?=$i;?>'),'dd/mm',this)" onkeyup/>
</div>
<?$conta=mysql_num_rows($alunoc);
?>


<div style="width: 100%;">
<input type="text" id="dataencontro<?=$i;?>" name="dataencontro<?=$i;?>" style="width: 30px; font-family: arial; font-size:10px; border: 0px;">
</div>

</td>
	<?
}else{?>

<td style="border: 1px solid black; width: 20px;">
<input type="hidden" name="<?=$i;?>" value="<?=$i;?>">
<input type="hidden" name="<?=$a;?>" value="<?=$a;?>">
<input type="text" name="falta<?=$i.$a;?>" onchange="if(document.getElementById('dataencontro<?=$i;?>').value != '' ) document.getElementById('falta<?=$i.$a;?>').value = 0; value="<?
#Consulta as faltas e mostra#################################################################################
$consulta_faltas = mysql_db_query($db,"select * from falta where a='$a' and i='$i' and bimestre='$bimestre' and disciplina='$id_disciplina'and turma='$id_turma'", $socket);
$mostra_faltas=mysql_fetch_array($consulta_faltas);
echo $mostra_faltas[falta];
###Ok...#####################################################################################################
?>" style="width: 15px; font-family: arial; font-size:10px; border: 0px;">
</td>
<? } }
	if($a==1){
?>
<td style="border: 1px solid black; width: 20px; font-family: arial; font-size: 10px;">
Total
</td>
<?}else{?>
<td style="border: 1px solid black; width: 20px; font-family: arial; font-size: 10px;">
&nbsp;
</td>
<? }?>

</tr><? } ?>
</table>
<input type="hidden" name="turma" value="<?=$_POST[turma];?>" >
<input type="hidden" name="nometurma" value="<?=$_POST[nometurma];?>" >
<input type="hidden" name="bimestre" value="<?=$_POST[bimestre];?>" >


<p align="center"><input type="submit" value="Salvar dados"> <input type="submit" value="Gerar PDF e imprimir"></p>
</form>


<? }
//fim
}else{
$mensagem_erro= "Caro, para acessar este arquivo, você precisa estar logado em nosso sistema.";
			header("Location: ../index.php?mensagem_erro=$mensagem_erro");   }
?>