Host = 19;
$qryO->Tabla = "OBSERVACIONES_PREESCOLAR";
$qryO->Campos = "*";
$qryO->Condicion = "ID_HIST_ESTUDIO =".$id_hist;
$Resultado = $qryO->Query();
$res = ibase_fetch_object($Resultado);
$ing = 1;
if ($res->ID_HIST_ESTUDIO > 0)
$ing = 0;
while($objQ = ibase_fetch_row($showq))
{
if ($ing == 1)
{
$qryI = new FBSQL();
$qryI->Host = 19;
$qryI->Trans_Start();
$qryI->Tabla = "OBSERVACIONES_PREESCOLAR";
$qryI->Campos = "ID_HIST_ESTUDIO, ID_MATERIA";
$qryI->Valores = $id_hist.','.$objQ[0];
$qryI->Inserta();
$qryI->Commit();
}
}
$qry = new FBSQL();
$qry -> Host = 19;
$qry -> Tabla = "HIST_ESTUDIOS A INNER JOIN (ALUMNO_CALIF B INNER JOIN (MATERIAS C INNER JOIN PLAN_GRADO_MAT E ON (E.ID_MATERIA = C.ID_MATERIA AND A.ID_PLAN_ESTUDIO = E.ID_PLAN_ESTUDIO AND A.GRADO = E.GRADO) ) ON C.ID_MATERIA = B.ID_MATERIA) ON A.ID_HIST_ESTUDIO = B.ID_HIST_ESTUDIO ";
$qry -> Campos = "B.ID_MATERIA,C.NOM_MATERIA,A.ID_HIST_ESTUDIO ";
$qry -> Condicion= "A.ID_ALUMNO=".$_SESSION['idnom']." AND A.GRUPO = '".$_SESSION['gpo']."' AND A.GRADO = ".$_SESSION['gdo']." AND (A.ESTATUS >=1 AND A.ESTATUS <=5 OR A.ESTATUS = 12)";
$qry -> Orden ="E.ORDEN";
$qry -> Plan = "A INDEX(ID_ALUMNO_HIST_ESTUDIOS_IDX), B INDEX(IDX_ALUMNO_CALIF), C NATURAL, E NATURAL";
$showq = $qry ->Query();
while($objQ = ibase_fetch_row($showq))
{
$qryM = new FBSQL();
$qryM->Host = 19;
$qryM->Tabla = "OBSERVACIONES_PREESCOLAR";
$qryM->Campos = "*";
$qryM->Condicion = "ID_HIST_ESTUDIO = ".$id_hist." AND ID_MATERIA =".$objQ[0];
$Resultado1 = $qryM->Query();
$res1 = ibase_fetch_object($Resultado1);
echo '| '. MayMin($objQ[1],3).' |
';
?>
|
NOVIEMBRE (Disponibles
caracteres)
|
';
echo in_array(19,$bimesactivoJ) ?
' ': ' ';
echo '';
echo'
';
?>
|
MARZO (Disponibles
caracteres)
|
';
echo in_array(20,$bimesactivoJ) ?
' ': ' ';
echo '';
echo'
';
?>
|
JULIO (Disponibles
caracteres)
|
';
echo in_array(21,$bimesactivoJ) ?
' ': ' ';
echo '';
echo'
';
}
?>