Host = 10;
$Query->Tabla="A_CTBA";
$Query->Campos="SERREG, FEDEST";
$Query->Condicion="CLAVECCT = '".$_SESSION['S_rfc']."'";
$Res=$Query->Query();
$reg = ibase_fetch_row($Res);*/
$redis = getConnection();
$ctreg = $redis->get("a_ctba.".MayMin($_SESSION['S_rfc'],0).".SERREG");
$ctfedest = $redis->get("a_ctba.".MayMin($_SESSION['S_rfc'],0).".FEDEST");
$Query->Tabla="A_CTBA";
$Query->Campos="CLAVECCT";
$Query->Condicion="SERREG = '".$reg[0]."' AND FEDEST = '".$reg[1]."'";
$Query->Orden="CLAVECCT";
$Res1=$Query->Query();
$cmb = ' MOVIMIENTOS DE '.$movs.'
';
$cmb .= " ";
$cmb .= "\n";
$cmb .= "| \n";
$cmb .= "CCT";
$cmb .= " | \n";
$cmb .= " \n";
$cmb .= "NUMERO DE MOVIMIENTOS";
$cmb .= " | \n";
$cmb .= " \n";
$cmb .= "DETALLE";
$cmb .= " | \n";
$cmb .= "
\n";
$cont = 0;
$Query1 = new FBSQL();
$Query1->Host = 19;
while ($row=ibase_fetch_row($Res1))
{
if ((substr($row[0],3,2) == "JN") || (substr($row[0],3,2) == "DI") || (substr($row[0],3,2) == "ES") || (substr($row[0],3,2) == "ST") || (substr($row[0],3,2) == "TV") || (substr($row[0],3,2) == "ML") || (substr($row[0],3,2) == "PR"))
{
$Query1->Tabla="MOVS_HIST_ESTUDIOS M INNER JOIN HIST_ESTUDIOS H INNER JOIN ALUMNOS A ON H.ID_ALUMNO = A.ID_ALUMNO ON M.ID_HIST_ESTUDIO = H.ID_HIST_ESTUDIO";
$Query1->Campos="COUNT(*)";
$Query1->Condicion="M.MOVIMIENTO = '".$movs."' AND H.CICLO_ESCOLAR='".$ciclo."' AND H.CVE_CT = '".$row[0]."' AND M.FECHA BETWEEN '".$feci."' AND '".$fecf."'";
$Res2=$Query1->Query();
$row1 = ibase_fetch_row($Res2);
$cmb .= "\n";
$cmb .= "| \n";
$cmb .= $row[0];
$cmb .= " | \n";
$cmb .= " \n";
$cmb .= $row1[0];
$cmb .= " | \n";
$cmb .= " \n";
$cmb .= '';
$cmb .= " | \n";
$cmb .= "
\n";
$cont = $cont + $row1[0];
}
}
$cmb .= "
";
$cmb .= ' TOTAL DE MOVIMIENTOS DE '.$movs.' SON : '.$cont.'
';
$cmb .= '
';
print_r($_POST);
$postdata = ob_get_clean();
echo $cmb;
?>