include("../../conexion.php");
$idc =$_POST[idc];
$ges =$_POST[ges];
$per =$_POST[per];
//ultimo periodo y gestion creado
$gest=pg_exec("select * from periodo_gestion order by id_per_ges ASC");
$f1=pg_numrows($gest);
for($i=0;$i<$f1;$i++)
{
$ges=pg_result($gest,$i,1);
$per=pg_result($gest,$i,2);
}
//$idc='CDE';
if($idc=='CDE'){$carr='Ciencias de la Educación';}if($idc=='IDS'){$carr='Ingeniería de Sistemas';}if($idc=='CPS'){$carr='Contaduría Pública';}if($idc=='DER'){$carr='Derecho';}if($idc=='PSM'){$carr='Psicomotricidad';}
$lim='7';
//lectura de la asignación de paralelo
$progra=pg_exec("select * from horario_asig where id_periodo='$per' and id_gestion='$ges' and id_carrera='$idc' order by semestre,id_grupo ASC");
$f9=pg_numrows($progra);if($f9==''){ echo "Aún no programó los Horarios en la gestión $per - $ges "; }
for($z=0;$z<$f9;$z++)
{
$idg=pg_result($progra,$z,2);
$sem=pg_result($progra,$z,5);
$tur=pg_result($progra,$z,6);
$blo=pg_result($progra,$z,7);
$aul=pg_result($progra,$z,8);
echo " ";
//encabezado menbrete
echo "";
echo "";
echo "UNIVERSIDAD SALESIANA DE BOLIVIA ";
echo "Carrera $carr ";
echo "Campus Universitario";
echo " | ";
echo "";
echo " | ";
echo " ";
//encabezado del horario
echo "";
echo "";
echo "";
echo "Gestión";
echo " | ";
echo "";
echo "$per - $ges";
echo " | ";
echo "";
echo "Paralelo";
echo " | ";
echo "";
echo "$idg";
echo " | ";
echo "";
echo "Aula";
echo " | ";
echo "";
echo "$aul";
echo " | ";
echo " ";
echo "";
echo "";
echo "Semestre";
echo " | ";
echo "";
echo "$sem";
echo " | ";
echo "";
echo "Turno";
echo " | ";
echo "";
if($tur=='1'){$tu='MAÑANA';;echo "$tu";}
if($tur=='2'){$tu='TARDE';;echo "$tu";}
if($tur=='3'){$tu='NOCHE';;echo "$tu";}
echo " | ";
echo "";
echo "Bloque";
echo " | ";
echo "";
if($idc=='CDE'){$pi='1er. Piso';}if($idc=='IDS'){$pi='2do. Piso';}if($idc=='DER'){$pi='3er. Piso';}if($idc=='CPS'){$pi='4er. Piso';}if($idc=='PSM'){$pi='6to. Piso';}
echo "'$blo' $pi";
echo " | ";
echo " ";
echo " ";
echo "";
echo "";
echo "Horas";
echo " | ";
echo "";
echo "LUNES";
echo " | ";
echo "";
echo "MARTES";
echo " | ";
echo "";
echo "MIERCOLES";
echo " | ";
echo "";
echo "JUEVES";
echo " | ";
echo "";
echo "VIERNES";
echo " | ";
echo "";
echo "SABADO";
echo " | ";
echo " ";
echo "";
//lee horas en los turnos de mañana tarde y noche
$hor=pg_exec("select * from horas where id_turno='$tur' order by id_hora ASC");
$f3=pg_numrows($hor);
for($t=0;$t<$f3;$t++)
{
$idh=pg_result($hor,$t,0);
$ho=pg_result($hor,$t,2);
$det=pg_result($hor,$t,4);
echo "";
for($r=0;$r<$lim;$r++)
{
$d=$r;
echo "";
//Horario programado a cada docente según gestión
$programado=pg_exec("select * from horario where id_gestion='$ges' and id_periodo='$per' and turno='$tur' and id_horas='$idh' and id_carrera='$idc' and semestre='$sem' and id_grupo='$idg' and id_dia='$d' and estado <='1'");
$f1=pg_numrows($programado);
if($f1!='')
{
for($i=0;$i<$f1;$i++)
{
$car=pg_result($programado,$i,1);
$idm=pg_result($programado,$i,2);
$idg=pg_result($programado,$i,3);
$idd=pg_result($programado,$i,6);
$idh=pg_result($programado,$i,7);
$dia=pg_result($programado,$i,8);
$sem=pg_result($programado,$i,9);
$tur=pg_result($programado,$i,10);
$aul=pg_result($programado,$i,11);
$blo=pg_result($programado,$i,12);
$deta=pg_result($programado,$i,16);
$usuar=pg_exec("select * from usuario where id_docente='$idd'");
$f2=pg_numrows($usuar);
for($j=0;$j<$f2;$j++)
{
$nom=pg_result($usuar,$j,4);
$pat=pg_result($usuar,$j,5);
$mat=pg_result($usuar,$j,6);
}
$mate=pg_exec("select * from pln_materias where id_materia='$idm'");
$f4=pg_numrows($mate);
for($y=0;$y<$f4;$y++)
{
$sig=pg_result($mate,$y,1);
$nma=pg_result($mate,$y,2);
}
}
echo " $nma
";
if($deta!=''){echo "$deta ";$deta='';}
echo "$sig
";
echo "$pat $mat $nom ";
echo " | ";
}
if($f1=='')
{
if($d=='3'){echo "$det ";}
if($d=='0'){echo "$ho ";}
}
echo "";
}
echo " ";
}
echo " ";
}//horario_asig
?>
|