function add()
{
$this->series = new tab_series();
$sql = "SELECT * \r\n FROM tab_series \r\n WHERE ser_id = " . VAR3;
$resul = $this->series->dbselectBySQL($sql);
if (count($resul)) {
$codigo2 = $resul[0]->ser_categoria;
} else {
$codigo2 = "";
}
$this->registry->template->sts_id = "";
$this->registry->template->ser_id = VAR3;
$this->registry->template->ser_categoria = $codigo2;
$this->registry->template->tra_id = "";
$tramite = new tramite();
$this->registry->template->tra_orden = $tramite->getCount(null, VAR3);
$this->registry->template->tra_codigo = "";
$this->registry->template->tra_descripcion = "";
$this->registry->template->titulo = "Nuevo tipo documental ";
$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-1.4.1";
$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();
$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_codigo . "</td> <td>" . $seriec->ser_categoria . "</td></tr>\n";
$i++;
}
} else {
$liSerie = "<tr><td colspan='2'>No existen series asociadas a este tramite</td></tr>";
}
$this->registry->template->LISTA_SERIES = $liSerie;
$this->registry->template->LISTA_SERIETRAMITES = "";
//$liSerie;
$tramitec = new cuerpos();
$tramitecuerpo = $tramitec->obtenerCuerposTramite();
$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_codigo . "</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 view()
{
if (!VAR3) {
die("Error del sistema 404");
}
$codigo = "";
$codigop = "";
$serie = new series();
$this->usuario = new usuario();
$adm = $this->usuario->esAdm();
$this->series = new tab_series();
$this->series->setRequest2Object($_REQUEST);
$row = $this->series->dbselectByField("ser_id", VAR3);
$row = $row[0];
// Find state
$departamento = new departamento();
//$dep_id = $departamento->obtenerIdDeptoCodigoSerie($row->ser_codigo);
$this->registry->template->dep_id = $departamento->obtenerSelect($row->dep_id);
//$departamento->obtenerSelect($dep_id);
// Find unity
$unidad = new unidad();
$this->registry->template->uni_id = $unidad->listUnidad($row->uni_id);
//$unidad->obtenerSelect($uni_id);
$fondo = new fondo();
$this->registry->template->fon_id = $fondo->obtenerSelectFondosbySeccion($row->uni_id);
$this->registry->template->adm = $adm;
$this->registry->template->ser_id = $row->ser_id;
$this->registry->template->ser_par = $serie->obtenerSelectSeriesDefault($row->ser_par);
$this->registry->template->ser_categoria = utf8_encode($row->ser_categoria);
$this->registry->template->ser_tipo = $row->ser_tipo;
$this->registry->template->ser_contador = $row->ser_contador;
$this->registry->template->fon_cod = $fondo->getCod($row->uni_id);
$this->registry->template->uni_cod = $unidad->getCodigo($row->uni_id);
$tipo_corr = new tipocorr();
$this->registry->template->tco_codigo = $tipo_corr->getCodigoById($row->tco_id);
$retensiondoc = new retensiondoc();
$this->registry->template->tco_id = $tipo_corr->obtenerSelect($row->tco_id);
$this->registry->template->red_id = $retensiondoc->obtenerSelect($row->red_id);
$this->registry->template->delimiter = DELIMITER;
$this->registry->template->ser_orden = $row->ser_orden;
$this->registry->template->ser_codigo = $row->ser_codigo;
if ($row->ser_corr == 'AUTO') {
$this->registry->template->ser_corr = "<OPTION selected>AUTO</OPTION><OPTION>MANUAL</OPTION>";
} else {
$this->registry->template->ser_corr = "<OPTION>AUTO</OPTION><OPTION selected>MANUAL</OPTION>";
}
$this->registry->template->ser_exp = $row->ser_exp;
$this->registry->template->ser_nivel = $row->ser_nivel;
$this->registry->template->serclon_id = "";
$tramiteSerie = new tramite();
$tramites = $tramiteSerie->obtenerTramitesSerie(VAR3);
$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_descripcion . "</td></tr>\n";
$i++;
}
} else {
$tramiteTr = "<tr><td colspan='2'>No existen tramites</td></tr>";
}
$this->registry->template->LISTA_TRAMITES = $tramiteTr;
$this->registry->template->LISTA_TRAMITES_SELECT = '';
//$tramiteLi;
$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-1.4.1";
$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_series.tpl');
$this->registry->template->show('footer');
}
function view()
{
if (!VAR3) {
die("Error del sistema 404");
}
$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->tramitecuerpos = new tab_tramitecuerpos();
$sql = "SELECT * \r\n FROM tab_tramitecuerpos \r\n WHERE cue_id = " . VAR3;
$resul2 = $this->tramitecuerpos->dbselectBySQL($sql);
if (count($resul2)) {
$tra_id = $resul2[0]->tra_id;
$trc_id = $resul2[0]->trc_id;
} else {
$tra_id = "";
$trc_id = "";
}
$this->cuerpos = new tab_cuerpos();
$this->cuerpos->setRequest2Object($_REQUEST);
$cue_id = VAR3;
$row = $this->cuerpos->dbselectByField("cue_id", $cue_id);
$row = $row[0];
$tramiteSerie = new tramite();
$tramites = $tramiteSerie->obtenerTramitesCuerpo($cue_id);
$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_descripcion . "</td></tr>\n";
$i++;
}
} else {
$tramiteTr = "<tr><td colspan='2'>No existen tramites</td></tr>";
}
$this->registry->template->LISTA_TRAMITES = $tramiteTr;
$this->registry->template->tra_descripcion = $codigo2;
$this->registry->template->trc_id = $trc_id;
$this->registry->template->tra_id = $tra_id;
$this->registry->template->cue_id = $row->cue_id;
$this->registry->template->cue_orden = $row->cue_orden;
$this->registry->template->cue_codigo = $row->cue_codigo;
$this->registry->template->cue_descripcion = $row->cue_descripcion;
$this->registry->template->cue_fecha_crea = $row->cue_fecha_crea;
$this->registry->template->cue_usuario_crea = $row->cue_usuario_crea;
$this->registry->template->cue_fecha_mod = $row->cue_fecha_mod;
$this->registry->template->cue_usuario_mod = $row->cue_usuario_mod;
$this->registry->template->cue_estado = $row->cue_estado;
$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;
$this->registry->template->show('headerG');
$this->registry->template->show('serie/tab_cuerpos.tpl');
$this->registry->template->show('footer');
}
