$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); }