function view()
{
if (!VAR3) {
die("Error del sistema 404");
}
$this->serietramite = new tab_serietramite();
$sql = "SELECT * \r\n FROM tab_serietramite \r\n WHERE tra_id = " . VAR3;
$resul = $this->serietramite->dbselectBySQL($sql);
if (!$resul) {
die("Error del sistema 404");
}
if (count($resul)) {
$ser_id = $resul[0]->ser_id;
$sts_id = $resul[0]->sts_id;
} else {
$ser_id = "";
$sts_id = "";
}
// Series
$tab_series = new tab_series();
$row2 = $tab_series->dbselectByField("ser_id", $ser_id);
$row2 = $row2[0];
$this->tramite = new tab_tramite();
$this->tramite->setRequest2Object($_REQUEST);
$tra_id = VAR3;
$row = $this->tramite->dbselectByField("tra_id", $tra_id);
$row = $row[0];
$this->registry->template->sts_id = $sts_id;
$this->registry->template->ser_id = $ser_id;
$this->registry->template->ser_categoria = $row2->ser_categoria;
$this->registry->template->tra_id = $row->tra_id;
$this->registry->template->tra_orden = $row->tra_orden;
$this->registry->template->tra_codigo = $row->tra_codigo;
$this->registry->template->tra_descripcion = $row->tra_descripcion;
$this->registry->template->titulo = "Editar ";
$this->registry->template->PATH_WEB = PATH_WEB;
$this->registry->template->PATH_DOMAIN = PATH_DOMAIN;
$this->registry->template->PATH_EVENT = "update";
$this->registry->template->GRID_SW = "true";
$this->registry->template->PATH_J = "jquery";
$this->menu = new menu();
$this->liMenu = $this->menu->imprimirMenu(VAR1, $_SESSION['USU_ID']);
$this->registry->template->men_titulo = $this->liMenu;
$seriet = new series();
$serietramite = $seriet->obtenerSerieTramites($tra_id);
$i = 0;
$liSerie = "";
if ($serietramite != "") {
foreach ($serietramite as $seriec) {
$liSerie .= "<tr><td><input type='checkbox' name='serie[{$i}]' value='" . $seriec->ser_id . "' {$seriec->checked}></td><td>" . $seriec->ser_categoria . "</td></tr>\n";
$i++;
}
} else {
$liSerie = "<tr><td colspan='2'>No existen series asociadas a este tipo documental</td></tr>";
}
$this->registry->template->LISTA_SERIES = $liSerie;
$this->registry->template->LISTA_SERIETRAMITES = "";
//$liSerie;
$tramitec = new cuerpos();
$tramitecuerpo = $tramitec->obtenerCuerposTramite($tra_id);
$tramiteCC = "";
$i = 0;
if ($tramitecuerpo != "") {
foreach ($tramitecuerpo as $x => $tc) {
if ($x % 2 == 0) {
$class = 'class="marca"';
} else {
$class = "";
}
$tramiteCC .= "<tr {$class}><td><input type='checkbox' name='cuerpo[{$i}]' value='" . $tc->cue_id . "' {$tc->checked}></td><td>" . $tc->cue_descripcion . "</td></tr>\n";
$i++;
}
} else {
$tramiteCC = "<tr><td colspan='2'>No existen cuerpos asociados a este tramite</td></tr>";
}
$this->registry->template->LISTA_CUERPOS_TRAMITE = $tramiteCC;
$this->registry->template->LISTA_CUERPOS = "";
//$liTramiteC;
$this->registry->template->show('headerG');
$this->registry->template->show('serie/tab_tramite.tpl');
$this->registry->template->show('footer');
}
function add()
{
$this->registry->template->exp_id = VAR3;
$this->registry->template->tra_id = VAR4;
$this->registry->template->cue_id = VAR5;
// Correspondencia
$this->registry->template->dco_id = "";
$this->registry->template->fil_nur = $_SESSION["codigo"];
$this->registry->template->fil_cite = "";
$this->registry->template->fil_asunto = "";
$this->registry->template->fil_sintesis = "";
$this->registry->template->fil_nur_s = "";
$this->registry->template->fil_nur_tipo = "";
// File
$this->registry->template->exa_id = "";
$this->registry->template->fil_id = "";
$this->expediente = new expediente();
$this->registry->template->exp_codigo = $this->expediente->obtenerCodigo(VAR3);
$this->registry->template->exp_nombre = "";
$this->registry->template->exp_corr = $this->expediente->obtenerTipoCorrExpediente(VAR3);
$this->registry->template->fil_codigo = "";
$this->registry->template->fil_nro = "";
$cuerpos = new cuerpos();
$this->registry->template->fil_titulo = utf8_encode(strtoupper($cuerpos->obtenerNombreCuerpo(VAR5)));
$this->registry->template->fil_subtitulo = "";
$this->registry->template->fil_fecha = date("Y-m-d");
$this->registry->template->fil_proc = $this->expediente->obtenerproductor(VAR3);
$this->registry->template->fil_firma = "";
$this->registry->template->fil_cargo = "";
$sopfisico = new sopfisico();
$this->registry->template->sof_id = $sopfisico->obtenerSelect();
$this->registry->template->fil_nrofoj = "(SIN PAG.)";
$this->registry->template->fil_tomovol = "";
$this->registry->template->fil_nroejem = "1";
$this->registry->template->fil_nrocaj = "0";
$this->registry->template->fil_nropaq = "0";
$this->registry->template->fil_sala = "";
$archivo = new archivo();
$this->registry->template->fil_estante = $archivo->obtenerSelectEstante();
$this->registry->template->fil_cuerpo = "";
$this->registry->template->fil_balda = "";
$this->registry->template->fil_tipoarch = "ADM";
$this->registry->template->fil_mrb = "Bueno";
$this->registry->template->confidencialidad = $archivo->loadConfidencialidad();
$this->registry->template->fil_obs = "";
$this->registry->template->fil_ori = "1";
$this->registry->template->fil_cop = "0";
$this->registry->template->fil_fot = "0";
$this->registry->template->fil_cantcaj = "0";
$this->registry->template->fil_cantpaq = "0";
$expediente = new expediente();
$this->registry->template->fil_mes = $expediente->obtenerSelectMes();
$this->registry->template->fil_anio = $expediente->obtenerSelectAnio();
$this->registry->template->fil_mesf = $expediente->obtenerSelectMes();
$this->registry->template->fil_aniof = $expediente->obtenerSelectAnio();
$idioma = new idioma();
$this->registry->template->idi_id = $idioma->obtenerSelect();
$this->registry->template->pac_nombre = "";
$this->registry->template->fil_alccon = "";
// Validate keywords
$palclave = new palclave();
$sis_palclave = $palclave->obtenerSisPalclave();
if ($sis_palclave == "RECORDAR") {
$this->registry->template->fil_descripcion = $palclave->listaPCFile2(VAR3);
} else {
$this->registry->template->fil_descripcion = $palclave->listaPCFile2(VAR3);
}
// Details data
$texpediente = new tab_expediente();
$row = $texpediente->dbselectById(VAR3);
$ser_id = $row->getSer_id();
$tab_serie = new tab_series();
$row1 = $tab_serie->dbselectById($ser_id);
$expisadg = new tab_expisadg();
$row2 = $expisadg->dbselectById(VAR3);
$this->registry->template->msm = "";
$expediente2 = new expediente();
$this->registry->template->detExpediente = "";
$this->registry->template->detExpediente = $expediente2->getDetalles(VAR3);
$this->registry->template->ubicacion = $expediente2->getUbicacion(VAR3);
$this->registry->template->ser_id = $row1->ser_id;
$this->registry->template->serie = $row1->ser_categoria;
$this->registry->template->exp_fecha_exi = $row2->exp_fecha_exi;
$this->registry->template->exp_fecha_exf = $row2->exp_fecha_exf;
$exp = new expediente();
$this->registry->template->linkTree = $exp->linkTree(VAR3, VAR4, VAR5);
$this->registry->template->PATH_WEB = PATH_WEB;
$this->registry->template->PATH_DOMAIN = PATH_DOMAIN;
$this->registry->template->PATH_EVENT = "save";
$this->registry->template->required_archivo = "class='required'";
$this->registry->template->GRID_SW = "true";
$this->registry->template->PATH_J = "jquery-1.4.1";
$this->registry->template->tituloEstructura = "<div class='titulo' align='center'>ESTRUCTURA DOCUMENTAL</div>";
$this->registry->template->controller = "archivo";
$this->menu = new menu();
$liMenu = $this->menu->imprimirMenu(VAR1, $_SESSION['USU_ID']);
$this->registry->template->men_titulo = $liMenu;
$this->registry->template->show('headerG');
// $this->registry->template->show('archivo/exp_detallesView.tpl');
$this->registry->template->show('archivo/tab_archivo.tpl');
$this->registry->template->show('footer');
}
function add()
{
$this->tramite = new tab_tramite();
$sql = "SELECT * FROM tab_tramite WHERE tra_id = " . VAR3;
$resul = $this->tramite->dbselectBySQL($sql);
if (count($resul)) {
$codigo2 = $resul[0]->tra_descripcion;
} else {
$codigo2 = "";
}
$this->registry->template->titulo = "Nuevo tipo documental de";
$this->registry->template->trc_id = "";
$this->registry->template->tra_id = VAR3;
$this->registry->template->tra_descripcion = $codigo2;
$this->registry->template->cue_id = "";
$cuerpos = new cuerpos();
$this->registry->template->cue_orden = $cuerpos->getCount(null, VAR3);
$this->registry->template->cue_codigo = "";
$this->registry->template->cue_descripcion = "";
$this->registry->template->titulo = "Nuevo ";
$this->registry->template->PATH_WEB = PATH_WEB;
$this->registry->template->PATH_DOMAIN = PATH_DOMAIN;
$this->registry->template->PATH_EVENT = "save";
$this->registry->template->GRID_SW = "false";
$this->registry->template->PATH_J = "jquery";
$tramiteSerie = new tramite();
$tramites = $tramiteSerie->obtenerTramitesCuerpo();
$tramiteTr = "";
$i = 0;
if ($tramites != "") {
foreach ($tramites as $tramite) {
$tramiteTr .= "<tr><td><input type='checkbox' name='tramite[{$i}]' value='" . $tramite->tra_id . "' {$tramite->checked}></td> <td>" . $tramite->tra_codigo . "</td> <td>" . $tramite->tra_descripcion . "</td> </tr>\n";
$i++;
}
} else {
$tramiteTr = "<tr><td colspan='2'>No existen tipos documentales</td></tr>";
}
$this->registry->template->LISTA_TRAMITES = $tramiteTr;
$this->menu = new menu();
$this->liMenu = $this->menu->imprimirMenu(VAR1, $_SESSION['USU_ID']);
$this->registry->template->men_titulo = $this->liMenu;
$this->registry->template->show('headerG');
$this->registry->template->show('serie/tab_cuerpos.tpl');
$this->registry->template->show('footer');
}