Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <? 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;">
-
- </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"); }
- ?>
Add Comment
Please, Sign In to add comment