$sqlH = "SELECT ANEX_RADI_NUME,\r\n\t\t\t\t SGD_MRD_CODIGO\r\n\t\t\t\t\t FROM SGD_RDA_RETDOCA \r\n\t\t\t\t\t WHERE ANEX_RADI_NUME = '{$nurad}'\r\n\t\t\t\t\t AND ANEX_CODIGO = '{$coddocu}'\r\n\t\t\t\t AND DEPE_CODI = '{$coddepe}'\r\n\t\t\t\t\t";
$rsH = $db->conn->query($sqlH);
$codiActu = $rsH->fields['SGD_MRD_CODIGO'];
$i = 0;
while (!$rsH->EOF) {
$codiRegH[$i] = $rsH->fields['ANEX_RADI_NUME'];
$i++;
$rsH->MoveNext();
}
$observa = "*Modificado el TRD del ANEXO " . $coddocu . "dependencia*" . $coddepe;
$Historico = new Historico($db);
$radiModi = $Historico->insertarHistorico($codiRegH, $coddepe, $codusua, $coddepe, $codusua, $observa, 32);
/*
*Actualiza el campo tdoc_codi de la tabla Anexos
*/
$radiUp = $trd->actualizarTRD($codiRegH, $tdoc);
$mensaje = "Registro Modificado";
// $codiTRDU = nuevo codigo TRD
$isqlTRD = "select SGD_MRD_CODIGO \r\n\t\t\t\t\t\t\tfrom SGD_MRD_MATRIRD \r\n\t\t\t\t\t\t\twhere DEPE_CODI = '{$coddepe}'\r\n\t\t\t\t \t \t\t\t and SGD_SRD_CODIGO = '{$codserie}'\r\n\t\t\t\t \t\t\t and SGD_SBRD_CODIGO = '{$tsub}'\r\n\t\t\t\t\t \t\t\t and SGD_TPR_CODIGO = '{$tdoc}'";
$rsTRD = $db->conn->Execute($isqlTRD);
$codiTRDU = $rsTRD->fields['SGD_MRD_CODIGO'];
$sqlUA = "UPDATE SGD_RDA_RETDOCA \r\n\t\t\t\t\t\t SET SGD_MRD_CODIGO = '{$codiTRDU}',\r\n\t\t\t\t\t\t USUA_CODI = '{$codusua}'\r\n\t\t\t\t WHERE ANEX_RADI_NUME = '{$nurad}' \r\n\t\t\t\t\t\t AND ANEX_CODIGO = '{$coddocu}' \r\n\t\t\t\t\t\t AND DEPE_CODI = '{$coddepe}'";
$rsUp = $db->conn->query($sqlUA);
$mensaje = "Registro Modificado <br> ";
}
}
?>
</script>
<body bgcolor="#FFFFFF" topmargin="0">
<br>
<div align="center">
$sqlH = "SELECT {$radi_nume_radi} as RADI_NUME_RADI\n\t\t\t\tFROM SGD_RDF_RETDOCF r \n\t\t\t\tWHERE r.RADI_NUME_RADI = {$nurad}\n\t\t\t\tAND r.SGD_MRD_CODIGO = {$codiTRD}";
$rsH = $db->conn->query($sqlH);
$i = 0;
while (!$rsH->EOF) {
$codiRegH[$i] = $rsH->fields['RADI_NUME_RADI'];
$i++;
$rsH->MoveNext();
}
$observa = "*Insercion TRD/METADATOS*." . $rsTRD->fields['SERIE'] . "/" . $rsTRD->fields['SUBSERIE'] . "/" . $rsTRD->fields['TIPO_DOCUMENTO'];
$Historico = new Historico($db);
//$radiModi = $Historico->insertarHistorico($codiRegH, $coddepe, $codusua, $coddepe, $codusua, $observa, 32);
$radiModi = $Historico->insertarHistorico($codiRegH, $dependencia, $codusuario, $dependencia, $codusuario, $observa, 32);
/*
* Actualiza el campo tdoc_codi de la tabla Radicados
*/
$radiUp = $trd->actualizarTRD($codiRegH, $_POST['slc_tdoc']);
$codserie = 0;
$tsub = 0;
$tdoc = 0;
$error = 3;
/* * *************************** INSERTAR METADATOS ***************** */
$db->conn->StartTrans();
$tablaACT = "SGD_MMR_MATRIMETARADI";
$r['RADI_NUME_RADI'] = $_POST['nurad'];
foreach ($_POST as $k => $v) {
if (substr($k, 0, 8) == "txt_mtd_") {
$idMtd = substr($k, 8);
$r['SGD_MTD_CODIGO'] = $idMtd;
$r['SGD_MMR_DATO'] = $_POST['txt_mtd_' . $idMtd];
$db->conn->Replace(&$tablaACT, $r, array('RADI_NUME_RADI', 'SGD_MTD_CODIGO'), true);
}
