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