";
print "location.href='../sigesp_inicio_sesion.php'";
print "";
}
?>
uf_conectar();
$io_msg = new class_mensajes();
$io_dsprove = new class_datastore();
$io_sql = new class_sql_covensol($conn);
$io_funciones= new class_funciones($conn);
$ds = new class_datastore();
$ldt_fecdes=$io_funciones->uf_convertirdatetobd($ldt_fecdes);
$ldt_fechas=$io_funciones->uf_convertirdatetobd($ldt_fechas);
switch ($_SESSION["ls_gestor"])
{
case "MYSQL":
$ls_cadena="CONCAT('2007',substring(numsol,LENGTH('2007')+1))";
break;
case "POSTGRE":
$ls_cadena="'2007'||substring(numsol,LENGTH('2007')+1)";
break;
}
if($ls_status=="C")
{
$ls_sql="SELECT 0 as marcado,numsol, fecemisol, consol, monsol,0.00 as pagado".
" FROM cxp_solicitudes".
" WHERE ".$ls_like."(fecemisol BETWEEN '".$ldt_fecdes."' AND '".$ldt_fechas."') ".
" AND estprosol='".$ls_status."'".
" AND ".$ls_cadena." NOT IN (SELECT numsol FROM cxp_solicitudes) ".
"ORDER BY numsol ";
}
else
{
$ls_sql="SELECT 0 as marcado,numsol, fecemisol, consol, monsol, ".
" (SELECT COALESCE(SUM(cxp_sol_banco.monto), 0.00) as pagado FROM cxp_sol_banco WHERE cxp_sol_banco.numsol=cxp_solicitudes.numsol) as Pagado ".
" FROM cxp_solicitudes ".
" WHERE ".$ls_like.
" (fecemisol BETWEEN '".$ldt_fecdes."' AND '".$ldt_fechas."' AND ".
" estprosol='".$ls_status."') and ".
" ".$ls_cadena." NOT IN (SELECT numsol FROM cxp_solicitudes) ".
"ORDER BY numsol ";
}
$rs_td=$io_sql->select($ls_sql);
?>
";
// print " ";
print "