function view()
{
if (!VAR3) {
die("Error del sistema 404");
}
$this->expediente = new tab_expediente();
$rows = $this->expediente->dbselectByField("exp_id", VAR3);
$row = $rows[0];
$this->registry->template->exp_id = $row->exp_id;
$this->registry->template->ser_id = $row->ser_id;
$series = new series();
$uni_id = $series->obtenerSeccionIdSerie($row->ser_id);
$this->registry->template->series = $series->obtenerSelectSeccionDefaultEdit($_SESSION['USU_ID'], $uni_id, $row->ser_id);
$this->registry->template->ser_codigo = $series->obtenerCodigoSerie($row->ser_id);
$this->registry->template->ser_corr = $series->obtenerTipoCorrSerie($row->ser_id);
$this->registry->template->uni_descripcion = $series->obtenerSeccionSerie($row->ser_id);
$this->registry->template->exp_codigo = $row->exp_codigo;
// Dynamic fields
$expcampo = new expcampo();
$this->registry->template->expcampo = $expcampo->obtenerSelectCamposEdit($row->ser_id, VAR3);
$sopfisico = new sopfisico();
$this->registry->template->sof_id = $sopfisico->obtenerSelect($row->sof_id);
$this->registry->template->exp_lugar = $row->exp_lugar;
$this->registry->template->exp_nrofoj = $row->exp_nrofoj;
$this->registry->template->exp_tomovol = $row->exp_tomovol;
$this->registry->template->exp_nroejem = $row->exp_nroejem;
$this->registry->template->exp_nrocaj = $row->exp_nrocaj;
$this->registry->template->exp_sala = $row->exp_sala;
$expediente = new expediente();
$this->registry->template->exp_estante = $expediente->obtenerSelectEstante($row->exp_estante);
$this->registry->template->exp_cuerpo = $row->exp_cuerpo;
$this->registry->template->exp_balda = $row->exp_balda;
$this->registry->template->exp_obs = $row->exp_obs;
$this->registry->template->exp_ori = $row->exp_ori;
$this->registry->template->exp_cop = $row->exp_cop;
$this->registry->template->exp_fot = $row->exp_fot;
// Validate keywords
$palclave = new palclave();
$sis_palclave = $palclave->obtenerSisPalclave();
if ($sis_palclave == "RECORDAR") {
$this->registry->template->exp_descripcion = $palclave->listaPCFile2($row->exp_id);
} else {
$this->registry->template->exp_descripcion = $palclave->listaPCFile2($row->exp_id);
}
// Automatic register
if ($row->exp_corr == 'AUTO') {
$this->registry->template->exp_corr = "<OPTION selected>AUTO</OPTION><OPTION>MANUAL</OPTION>";
} else {
$this->registry->template->exp_corr = "<OPTION>AUTO</OPTION><OPTION selected>MANUAL</OPTION>";
}
// isadg
$expisadg = new tab_expisadg();
$rows2 = $expisadg->dbselectByField("exp_id", VAR3);
$row2 = $rows2[0];
$this->registry->template->exp_titulo = $row2->exp_titulo;
$this->registry->template->exp_fecha_exi = $row2->exp_fecha_exi;
$this->registry->template->exp_mesi = $expediente->obtenerSelectMes($row2->exp_mesi);
$this->registry->template->exp_anioi = $expediente->obtenerSelectAnio($row2->exp_anioi);
$this->registry->template->exp_fecha_exf = $row2->exp_fecha_exf;
$this->registry->template->exp_mesf = $expediente->obtenerSelectMes($row2->exp_mesf);
$this->registry->template->exp_aniof = $expediente->obtenerSelectAnio($row2->exp_aniof);
$this->registry->template->exp_volsop = $row2->exp_volsop;
$this->registry->template->exp_nomprod = $row2->exp_nomprod;
$this->registry->template->exp_hisins = $row2->exp_hisins;
$this->registry->template->exp_hisarc = $row2->exp_hisarc;
$this->registry->template->exp_foring = $row2->exp_foring;
$this->registry->template->exp_alccon = $row2->exp_alccon;
$this->registry->template->exp_vaseel = $row2->exp_vaseel;
$this->registry->template->exp_nueing = $row2->exp_nueing;
$this->registry->template->exp_org = $row2->exp_org;
$this->registry->template->exp_conacc = $row2->exp_conacc;
$this->registry->template->exp_conrep = $row2->exp_conrep;
$idioma = new idioma();
$this->registry->template->idi_id = $idioma->obtenerSelect($row2->idi_id);
$this->registry->template->exp_carfis = $expediente->obtenerSelectEstado($row2->exp_carfis);
$this->registry->template->exp_insdes = $row2->exp_insdes;
$this->registry->template->exp_exloor = $row2->exp_exloor;
$this->registry->template->exp_exloco = $row2->exp_exloco;
$this->registry->template->exp_underel = $row2->exp_underel;
$this->registry->template->exp_notpub = $row2->exp_notpub;
$this->registry->template->exp_notas = $row2->exp_notas;
$this->registry->template->exp_notarc = $row2->exp_notarc;
$this->registry->template->exp_regnor = $row2->exp_regnor;
$this->registry->template->exp_fecdes = $row2->exp_fecdes;
$eus = new Tab_expusuario();
$row_eus = $eus->dbselectBy2Field("exp_id", VAR3, "eus_estado", 1);
$usu_id = $_SESSION['USU_ID'];
if (!is_null($row_eus) && count($row_eus) > 0) {
$usu_id = $row_eus[0]->usu_id;
}
// Keywords
// $palclave = new palclave();
// $this->registry->template->pac_nombre = $palclave->listaPC();
$this->registry->template->pac_nombre = "";
if (VAR4) {
if (VAR4 == 0) {
$msm = "HUBO ERROR AL REGISTRAR EL EXPEDIENTE!";
} else {
if (VAR4 == 1) {
$msm = "SE GUARDO CORRECTAMENTE EL EXPEDIENTE!";
} else {
$msm = "";
}
}
} else {
$msm = "";
}
$this->registry->template->msm = $msm;
$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->registry->template->titulo = "HOJA DE TRABAJO - Editar";
$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('expediente/tab_expediente.tpl');
$this->registry->template->show('footer');
}
function obtenerExpUsuarioIdConfirmacion($exp_id)
{
$expusuario = new Tab_expusuario();
$sql = "SELECT\r\n eus_id\r\n\t\tFROM tab_expusuario\r\n\t\tWHERE tab_expusuario.exp_id ='" . $exp_id . "' AND tab_expusuario.eus_estado = '3' ";
$expusu = $expusuario->dbSelectBySQL($sql);
$eus_id = 0;
if (count($expusu) > 0) {
foreach ($expusu as $expusu2) {
$eus_id = $expusu2->eus_id;
}
}
return $eus_id;
}
