<?
require "biblioteca.php";
$txtbusca=$HTTP_GET_VARS["txtbuscar"];
conecta();
if($txtbusca<>"")
{
$query="SELECT * FROM alumno where matricula like '$txtbusca' order by matricula";
$resul=pg_query($query);
$fils=pg_numrows($resul);
if (!$resul){
echo "ERROR: La sentencia no es correcta";
exit;
}
else{
$idalum=pg_fetch_result($resul,0);
$plantel=pg_fetch_result($resul,1);
$nombre = pg_fetch_result($resul,3);
$nombre .= " ".pg_fetch_result($resul,4);
$nombre .= " ".pg_fetch_result($resul,5);
$sexo=pg_fetch_result($resul,6);
$semact=pg_fetch_result($resul,27);
$comenta=pg_fetch_result($resul,26);
$query="SELECT * FROM kardex where id_alumno like '$idalum' order by id_periodo desc";
$resul=pg_query($query);
$fils=pg_numrows($resul);
$idkardex=pg_fetch_result($resul,0);
$sem=pg_fetch_result($resul,3);
$cvecap=pg_fetch_result($resul,4);
$queryc = "SELECT * FROM catcapacitacion WHERE cve_cap like '$cvecap'";
$resultadoc=pg_query($queryc);
$filasc=pg_numrows($resultadoc);
//$cvecapa2=pg_fetch_result($resultadoc,0);
$descapa=pg_fetch_result($resultadoc,1);
//echo "$descapa";
$cveplan=pg_fetch_result($resul,6);
$grupo=pg_fetch_result($resul,8);
$idperiodo=pg_fetch_result($resul,2);
$idmapa=pg_fetch_result($resul,7);
$situacion=pg_fetch_result($resul,9);
$repetidor=pg_fetch_result($resul,11);
//echo "REPITIO.... $cvecap";
$cambio=pg_fetch_result($resul,12);
$equiva=pg_fetch_result($resul,13);
$convalida=pg_fetch_result($resul,14);
$comentario=pg_fetch_result($resul,19);
$query = "SELECT cve_plantel, plantel FROM plantel WHERE situacion='Alta' AND cve_plantel='$cveplan'";
$resultado = pg_query($query);
$filas=pg_numrows($resultado);
$descr=pg_fetch_result($resultado,1);
$descr=strtoupper($descr);
?>
<fieldset><legend>TELEBACHILLERATO, PLANTEL <?echo "$descr";?></legend>
<table width="100%" border="1">
<tr>
<td><label>periodo: </label><input type="text" name="txtidperiodoh" value="<?echo "$idperiodo";?>" size="8" disabled></td>
<td><label>clave: </label><input type="text" name="txtcveplanh" value="<?echo "$plantel";?>" size="10" disabled></td>
<td><label>id: </label><input type="text" name="txtidalumh" value="<?echo "$idalum";?>" size="10" disabled></td>
<td><label>cvecapa:</label><input type="text" name="txtcvecapah" value="<?echo "$cvecap";?>" size="10" disabled></td>
<td><label>descrip:</label><input type="text" name="txtdescapah" value="<?echo "$descapa";?>" size="10" disabled></td>
</tr>
<tr>
<td align="left"><label>Nombre: </label><input type="text" name="txtnombre" value="<?echo "$nombre";?>" size="45" disabled></td>
</tr>
<tr>
<td align="left"><label>Sexo: </label><input type="text" name="txtsexo" value="<?echo "$sexo";?>" size="1" disabled></td>
</tr>
<tr>
<td align="left"><label>Semestre Actual: </label><input type="text" name="txtsemact" value="<?echo "$semact";?>" size="1" disabled></td>
</tr>
<tr>
<td align="left"><label>Comentario: </label><input type="text" name="txtcomenta" value="<?echo "$comenta";?>" disabled></td>
</tr>
</table>
</fieldset>
<?
//AQUI IBA KARDEX...
?>
<fieldset><legend>SEMESTRE</legend>
<table width="100%" border="1">
<tr>
<td align="left">
<div id="cveplan" style="visibility:visible">
<label>Clave: </label><input type="text" name="txtcveplan" value="<?echo "$cveplan";?>" disabled>
</div>
</td>
<td align="left">
<?
$query = "SELECT cve_plantel, plantel FROM plantel WHERE situacion='Alta' AND cve_plantel='$cveplan' ORDER BY plantel";
$resultado = pg_query($query);
$filas=pg_numrows($resultado);
$descr=pg_fetch_result($resultado,1);
?>
<label>Plantel: </label><select name="cbplantel" size="1" class="color" disabled onchange="muestralista()">
<?
$query = "SELECT cve_plantel, plantel FROM plantel WHERE situacion='Alta' ORDER BY plantel";
$resultado = pg_query($query);
$filas=pg_numrows($resultado);
for ($i=0; $i<$filas; $i++){
$valor=pg_fetch_result($resultado,$i,0);
$descrip=pg_fetch_result($resultado,$i,1);
echo " <option value=\"$valor\"";
if ($valor==$cveplan){
echo "selected=\"selected\"";
}else{}
echo ">$descrip</option>";
}
?>
</select>
</td>
</tr>
<tr>
<td align="left" colspan="2">
<label>Semestre: </label><input type="text" name="txtsem" value="<? echo "$sem"?>" size="1" disabled>
</td>
</tr>
<tr>
<td align="left" colspan="2"><label>Promedio: </label><input type="text" name="txtpromedio" value="<?echo "$promedio";?>" disabled></td>
</tr>
<tr>
<td align="left" colspan="2">
<label>Grupo: </label><select name="cbgrupo" size="1" class="color" disabled>
<?
if ($grupo=="A"){
?>
<option selected><? echo "$grupo"?></option>
<option>B</option>
<option>C</option>
<option>D</option>
<option>E-A</option>
<option>F-M</option>
<option>Q-B</option>
<option>P-S</option>
<?
}elseif ($grupo=="B"){
?>
<option>A</option>
<option selected><? echo "$grupo"?></option>
<option>C</option>
<option>D</option>
<option>E-A</option>
<option>F-M</option>
<option>Q-B</option>
<option>P-S</option>
<?
}elseif ($grupo=="C"){
?>
<option>A</option>
<option>B</option>
<option selected><? echo "$grupo"?></option>
<option>D</option>
<option>E-A</option>
<option>F-M</option>
<option>Q-B</option>
<option>P-S</option>
<?
}elseif ($grupo=="E-A"){
?>
<option>A</option>
<option>B</option>
<option>C</option>
<option>D</option>
<option selected><? echo "$grupo"?></option>
<option>F-M</option>
<option>Q-B</option>
<option>P-S</option>
<?
}elseif ($grupo=="F-M"){
?>
<option>A</option>
<option>B</option>
<option>C</option>
<option>D</option>
<option>E-A</option>
<option selected><? echo "$grupo"?></option>
<option>Q-B</option>
<option>P-S</option>
<?
}elseif ($grupo=="Q-B"){
?>
<option>A</option>
<option>B</option>
<option>C</option>
<option>D</option>
<option>E-A</option>
<option>F-M</option>
<option selected><? echo "$grupo"?></option>
<option>P-S</option>
<?
}elseif ($grupo=="P-S"){
?>
<option>A</option>
<option>B</option>
<option>C</option>
<option>D</option>
<option>E-A</option>
<option>F-M</option>
<option>Q-B</option>
<option selected><? echo "$grupo"?></option>
<?}?>
</select>
</td>
</tr>
<tr>
<td align="left" colspan="2">
<?
$query = "SELECT * FROM periodo_escolar WHERE id_periodo like '$idperiodo'";
$resultado = pg_query($query);
$filas=pg_numrows($resultado);
$descriper=pg_fetch_result($resultado,2);
?>
<label>Periodo Escolar: </label><select name="cbperesco" size="1" class="color" disabled>
<?
$query = "SELECT id_periodo, cve_periodo, descripcion_per, ini_ciclo FROM periodo_escolar ORDER BY ini_ciclo DESC";
$resultado = pg_query($query);
$filas=pg_numrows($resultado);
for ($j=0; $j<$filas; $j++){
$id=pg_fetch_result($resultado,$j,0);
$descper=pg_fetch_result($resultado,$j,2);
echo " <option value=\"$id\"";
if ($id==$idperiodo){
echo "selected=\"selected\"";
}else{}
echo ">$descper</option>";
}
?>
</select>
</td>
</tr>