<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento sin título</title>

<link href="../lib/styles/tabla.css" rel="stylesheet" type="text/css">
<style type="text/css">
#apDiv1 {
	position: absolute;
	width: 670px;
	height: 386px;
	z-index: 1;
	left: 236px;
	top: 98px;
	font-family: "MS Serif", "New York", serif;
	font-size: 18px;
	font-style: normal;
	color: #069;
	text-transform: capitalize;
	font-variant: small-caps;
	font-weight: 300;
}
</style>
</head>

<body>

<script language="javascript" src= "../lib/tools/cookies.js" ></script>
<script language='javascript' src="../lib/tools/omnisoftTools.js"></script>
<script language="javascript" src= "../lib/aw/lib/aw.js" ></script>
<link href="../lib/styles/omnisoft.css" rel="stylesheet" type="text/css">
<link href="../lib/tools/omnisoftValidar.css" rel="stylesheet" type="text/css">
<script language='javascript' src="../lib/tools/omnisoftValidar.js"></script>
<script language="javascript" src="../lib/mask/event-listener.js"></script>
<script language="javascript" src="../lib/mask/masked-input.js"></script>
<script language="javascript" src="../lib/mask/enter-as-tab.js"></script>
<script language="javascript" src="../lib/mask/auto-tab.js"></script>
<script language='javascript' src="../lib/grid/omnisoftDB.js"></script>
<script language='javascript' src="../lib/combo/omnisoftComboBox.js"></script>

<link rel="stylesheet" type="text/css" media="all" href="../lib/jscalendar/calendar-blue2.css" title="win2k-cold-1" />
  <script type="text/javascript" src="../lib/jscalendar/calendar.js"></script>
  <script type="text/javascript" src="../lib/jscalendar/lang/calendar-en.js"></script>
  <script type="text/javascript" src="../lib/jscalendar/calendar-setup.js"></script>

<script language="javascript" src="../lib/autosuggest2/js/bsn.AutoSuggest_2.1_comp_grid.js"> </script>
<script language="javascript" src="../lib/autosuggest2/js/bsn.AutoSuggest_2.1_comp.js"> </script>

<script language="javascript" src= "../lib/grid/omnisoftGridDetail.js" ></script>
<div id="apDiv1">
  <div>
    <table width="645" height="34" border="0">
      <tr>
        <td width="648" height="30" class="encabezado">REPORTE DE CASOS</td>
      </tr>
    </table>
    <div></div>
  </div>
  <div>
    <table width="645" height="60" border="0">
      <tr>
        <td height="56"><form id="form1" name="form1" method="post" action="reporte_casos.php" target="mostrar_reporte">
    

        <!--<script> 
	        
	         omnisoftLoadData(document.PaginaDatos,'iframe');

      var serial_alu=document.PaginaDatos.serial_alu.value;
      var serial_paralu=document.PaginaDatos.serial_paralu.value;
	  
	   </script>-->
        
        
          <?php 
		  
		        //$serial_paralu=$_GET['serial_paralu'];
             
                
                
       
       ?>
          <table width="612" border="0">
            <tr>
              <td width="117" class="normal">cASOS:</td>
              <td width="485"><label for="select"></label>
                <select name="select" id="select"  >
                <option>Seleccione el caso  </option>
                <?php
			  include 'conexion.php';
           conectar();  
				   $consulta_casos = "select serial_cas,paralelo_alumno.serial_paralu, concat(numero_cas,' ',nombre_tcs,' ',fechainicio_cas,' ',asunto_cas)as inf_caso, numero_cas,nombre_tcs,estado_cas,fechainicio_cas, fechafin_cas,asunto_cas, derivadoe.apellido_epl as apellidoresponsable,derivadoe.nombre_epl as nombreresponsable,empleado.apellido_epl,empleado.nombre_epl,comentario_cas, detalle_cas,   prioridad_cas,resumencierre_cas, caso.serial_pro, caso.serial_paralu,caso.serial_tcs,derivadoa_cas  FROM periodo,tipocaso,profesor,empleado,paralelo_alumno,caso left join profesor as derivadoa on derivadoa.serial_pro=caso.derivadoa_cas left join empleado as derivadoe on derivadoe.serial_epl=derivadoa.serial_epl where tipocaso.serial_tcs=caso.serial_tcs and empleado.serial_epl=profesor.serial_epl and periodo.serial_per=paralelo_alumno.serial_per and activo_per='SI' and profesor.serial_pro=caso.serial_pro and caso.serial_paralu=paralelo_alumno.serial_paralu and paralelo_alumno.serial_paralu='$serial_paralu'";
								$resultado_casos= mysql_query($consulta_casos);
								if($fila_casos=mysql_fetch_array($resultado_casos)){
									do{
										 echo "<option value=".$fila_casos['serial_cas'].">".utf8_encode($fila_casos['inf_caso'])."</option>";
										 
										 $serial_nuevo=$fila_casos['serial_paralu'];
									}while($fila_casos = mysql_fetch_array($resultado_casos));
									    // echo $serial_nuevo;
								}
							
							
							?>
                </select></td>
                
                   <input name="serial" type="hidden" value="<?php echo $serial_nuevo ; ?>" />
              <td width="485"><a href="reporte_casos.php" target="mostrar_reporte"></a><input type="image" name="imageField" id="imageField" src="imagenes/reporte.jpg"   width="120" height="30" onmouseover="javascript:this.src='imagenes/reporte2.jpg';" onmouseout="javascript:this.src='imagenes/reporte.jpg'"/> </td>
            </tr>
          </table>
        </form></td>
      </tr>
    </table>
    <p>&nbsp;</p>
  </div>
  <p><iframe name="mostrar_reporte" scrolling="auto"  src=""  frameborder="0"  height="300" width="648" >  </iframe>&nbsp;</p>
</div>
</body>
</html>
