echo $ruta_raiz;
?>
/estilos/orfeo.css">
<style type="text/css">
<!--
.textoOpcion { font-family: Arial, Helvetica, sans-serif; font-size: 8pt; color: #000000; text-decoration: underline}
-->
</style>
<body bgcolor="#FFFFFF" topmargin="0">
<?php
$fecha_hoy = Date("Y-m-d");
//$sqlFechaHoy=$db->conn->OffsetDate(0,$db->conn->sysTimeStamp);
$sql = "select replace(nit,'-','') nit from entidad@sui\t \r\n\t where codentidad in (90,246,248,271,374,432,561,644,686,734,821,824,889,912,969,978,1128,1250,1263,1302,1306,1339,1341,1352,1356,1374,1380,1421,1443,1450,1459,1500,1615,1661,1756,1805,1813,1818,1827,1851,1852,1856,2024,2058,2077,2130,2199,2223,2246,2331,2426,2427,2434,2506,2540,2641,2646,2704,2800,2814,2878,3048,3049,3123,3234,3249,3278,3386,3402,3488,3620,4004,4129,4204,4336,4458,4617,6234,7099,7571,8202\r\n) ";
//echo $sql;
$rs1 = $db->query($sql);
if ($rs1 === false) {
die("error al insertar: " . $db->ErrorMsg() . "<BR>");
}
while (!$rs1->EOF) {
echo $rs1->fields["nit"];
$rs1->MoveNext();
}
//$db->conn->debug=true;
//$db->conn->CommitTrans();
?>
</body>
</html>
</form>
<?php
if (!$db) {
$db = new ConnectionHandler($ruta_raiz);
}
$db->conn->BeginTrans();
$db->conn->SetFetchMode(ADODB_FETCH_ASSOC);
// $db->conn->debug=true;
$Numero = 0;
$sql = "select ANEX_ESTADO,to_date(ANEX_FECH_ENVIO,'yyyy/mm/dd') as ANEX_FECH_ENVIO ,RADI_NUME_SALIDA,ANEX_FECH_IMPRES from anexos where ANEX_TIPO =20 ";
$rs = $db->query($sql);
// echo $rs->RecordCount()."<br>";
while (!$rs->EOF) {
$estado = $rs->fields["ANEX_ESTADO"];
$fechaenvio = $rs->fields["ANEX_FECH_ENVIO"];
$fechaimpresion = $rs->fields["ANEX_FECH_IMPRES"];
$sql1 = "update Anexos set ANEX_FECH_IMPRES=to_date('{$fechaimpresion}','yyyy-mm-dd'), ANEX_ESTADO={$estado}, ANEX_FECH_ENVIO=to_date('{$fechaenvio}','yyyy-mm-dd') where RADI_NUME_SALIDA='" . $rs->fields["RADI_NUME_SALIDA"] . "' \r\n\t\tand ANEX_TIPO =1 ";
echo $sql1;
$rs1 = $db->query($sql1);
if (!$rs1) {
die("error en radicado " . $rs->fields["RADI_NUME_SALIDA"] . " " . $db->ErrorMsg());
} else {
echo "bien " . $rs->fields["RADI_NUME_SALIDA"] . " <br>";
}
$rs->MoveNext();
}
//echo "$sql<br>";
$db->conn->CommitTrans();
