{
$lb_break=true;
$io_sql->free_result($li_exec1);
}
} //fin if($row=$io_sql->fetch_row($li_exec))
*/ }
}
else
{
if($row=$io_sql->fetch_row($rs_data))
{
$ls_numdocori="";
$li_preuniart=$row["cosart"];
$li_preuniart=uf_formatonumerico($li_preuniart);
}
}
print "<script language= javascript>";
print "obj=eval(opener.document.form1.txtcodalm".$li_linea.");";
print "obj.value='".$ls_codalm."';";
print "obj1=eval(opener.document.form1.hidexistencia".$li_linea.");";
print "obj1.value=".$li_existencia.";";
print "obj2=eval(opener.document.form1.txtpreuniart".$li_linea.");";
print "obj2.value='".$li_preuniart."';";
print "obj3=eval(opener.document.form1.hidnumdocori".$li_linea.");";
print "obj3.value='".$ls_numdocori."';";
print "close();";
print "</script>";
function uf_imprimirresultados($as_codper, $as_cedper, $as_nomper, $as_apeper)
{
require_once "../shared/class_folder/sigesp_include.php";
$in = new sigesp_include();
$con = $in->uf_conectar();
require_once "../shared/class_folder/class_mensajes.php";
$msg = new class_mensajes();
require_once "../shared/class_folder/class_sql.php";
$SQL = new class_sql($con);
$ds = new class_datastore();
require_once "../shared/class_folder/class_funciones.php";
$fun = new class_funciones();
$emp = $_SESSION["la_empresa"];
$ls_codemp = $emp["codemp"];
print "<table width=500 border=0 cellpadding=1 cellspacing=1 class=fondo-tabla align=center>";
print "<tr class=titulo-celda>";
print "<td width=100>Código</td>";
print "<td width=100 align=center>Cédula</td>";
print "<td width=440>Nombre y Apellido</td>";
print "</tr>";
$ls_sql = "SELECT sno_personal.*, sno_profesion.despro, sigesp_pais.despai, sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar ";
$ls_sql = $ls_sql . "FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia ";
$ls_sql = $ls_sql . "WHERE sno_personal.codemp='" . $ls_codemp . "'";
$ls_sql = $ls_sql . " AND sno_profesion.codemp = sno_personal.codemp ";
$ls_sql = $ls_sql . " AND sno_profesion.codpro = sno_personal.codpro ";
$ls_sql = $ls_sql . " AND sigesp_pais.codpai = sno_personal.codpai ";
$ls_sql = $ls_sql . " AND sigesp_estados.codpai = sno_personal.codpai ";
$ls_sql = $ls_sql . " AND sigesp_estados.codest = sno_personal.codest ";
$ls_sql = $ls_sql . " AND sigesp_municipio.codpai = sno_personal.codpai ";
$ls_sql = $ls_sql . " AND sigesp_municipio.codest = sno_personal.codest ";
$ls_sql = $ls_sql . " AND sigesp_municipio.codmun = sno_personal.codmun ";
$ls_sql = $ls_sql . " AND sigesp_parroquia.codpai = sno_personal.codpai ";
$ls_sql = $ls_sql . " AND sigesp_parroquia.codest = sno_personal.codest ";
$ls_sql = $ls_sql . " AND sigesp_parroquia.codmun = sno_personal.codmun ";
$ls_sql = $ls_sql . " AND sigesp_parroquia.codpar = sno_personal.codpar ";
$ls_sql = $ls_sql . " AND sno_personal.codper like '" . $as_codper . "' AND sno_personal.cedper like '" . $as_cedper . "'";
$ls_sql = $ls_sql . " AND sno_personal.nomper like '" . $as_nomper . "' AND sno_personal.apeper like '" . $as_apeper . "'";
$ls_sql = $ls_sql . " ORDER BY sno_personal.codper";
$rs_per = $SQL->select($ls_sql);
if ($row = $SQL->fetch_row($rs_per)) {
$data = $SQL->obtener_datos($rs_per);
$ds->data = $data;
$li_rows = $ds->getRowCount("codper");
for ($li_index = 1; $li_index <= $li_rows; $li_index++) {
print "<tr class=celdas-blancas>";
$ls_codper = $data["codper"][$li_index];
$ls_cedper = $data["cedper"][$li_index];
$ls_nomper = $data["nomper"][$li_index];
$ls_apeper = $data["apeper"][$li_index];
$ls_dirper = $data["dirper"][$li_index];
$ld_fecnacper = $fun->uf_convertirfecmostrar($data["fecnacper"][$li_index]);
$ls_edocivper = $data["edocivper"][$li_index];
$ls_telhabper = $data["telhabper"][$li_index];
$ls_telmovper = $data["telmovper"][$li_index];
$ls_sexper = $data["sexper"][$li_index];
$li_estaper = $data["estaper"][$li_index];
$li_estaper = str_replace(".", ",", $li_estaper);
$li_estaper = uf_formatonumerico($li_estaper);
$li_pesper = $data["pesper"][$li_index];
$li_pesper = str_replace(".", ",", $li_pesper);
$li_pesper = uf_formatonumerico($li_pesper);
$ls_codpro = $data["codpro"][$li_index];
$ls_nivacaper = $data["nivacaper"][$li_index];
$ls_codpai = $data["codpai"][$li_index];
$ls_codest = $data["codest"][$li_index];
$ls_codmun = $data["codmun"][$li_index];
$ls_codpar = $data["codpar"][$li_index];
$ls_catper = $data["catper"][$li_index];
$ls_cedbenper = $data["cedbenper"][$li_index];
$ls_numhijper = $data["numhijper"][$li_index];
$ls_obsper = $data["obsper"][$li_index];
$ls_contraper = $data["contraper"][$li_index];
$ls_tipvivper = $data["tipvivper"][$li_index];
$ls_tenvivper = $data["tenvivper"][$li_index];
$li_monpagvivper = $data["monpagvivper"][$li_index];
$li_monpagvivper = str_replace(".", ",", $li_monpagvivper);
$li_monpagvivper = uf_formatonumerico($li_monpagvivper);
$ls_cuecajahoper = $data["cuecajahoper"][$li_index];
$ls_cuelphper = $data["cuelphper"][$li_index];
$ls_cuefidper = $data["cuefidper"][$li_index];
$ls_cajahoper = $data["cajahoper"][$li_index];
$ld_fecingadmpubper = $fun->uf_convertirfecmostrar($data["fecingadmpubper"][$li_index]);
$li_anoservpreper = $data["anoservpreper"][$li_index];
$ld_fecingper = $fun->uf_convertirfecmostrar($data["fecingper"][$li_index]);
$ld_fecegrper = $fun->uf_convertirfecmostrar($data["fecegrper"][$li_index]);
$ls_cauegrper = $data["cauegrper"][$li_index];
$ls_obsegrper = $data["obsegrper"][$li_index];
$ls_estper = $data["estper"][$li_index];
switch ($ls_estper) {
case "0":
$ls_estper = "PRE INGRESO";
break;
case "1":
$ls_estper = "ACTIVO";
break;
case "2":
$ls_estper = "NA";
break;
case "3":
$ls_estper = "EGRESADO";
break;
}
$ls_despro = $data["despro"][$li_index];
$ls_despai = $data["despai"][$li_index];
$ls_desest = $data["desest"][$li_index];
$ls_desmun = $data["denmun"][$li_index];
$ls_despar = $data["denpar"][$li_index];
print "<td><a href=\"javascript: aceptar('{$ls_codper}','{$ls_cedper}','{$ls_nomper}','{$ls_apeper}','{$ls_dirper}','{$ld_fecnacper}',";
print "'{$ls_edocivper}','{$ls_telhabper}','{$ls_telmovper}','{$ls_sexper}','{$li_estaper}','{$li_pesper}','{$ls_codpro}','{$ls_nivacaper}',";
print "'{$ls_codpai}','{$ls_codest}','{$ls_codmun}','{$ls_codpar}','{$ls_catper}','{$ls_cedbenper}','{$ls_numhijper}','{$ls_obsper}',";
print "'{$ls_contraper}','{$ls_tipvivper}','{$ls_tenvivper}','{$li_monpagvivper}','{$ls_cuecajahoper}','{$ls_cuelphper}','{$ls_cuefidper}',";
print "'{$ls_cajahoper}','{$ld_fecingadmpubper}','{$li_anoservpreper}','{$ld_fecingper}','{$ld_fecegrper}','{$ls_cauegrper}', ";
print "'{$ls_obsegrper}','{$ls_despro}','{$ls_despai}','{$ls_desest}','{$ls_desmun}','{$ls_despar}','{$ls_estper}');\">" . $ls_codper . "</a></td>";
print "<td>" . $ls_cedper . "</td>";
print "<td>" . $ls_nomper . " " . $ls_apeper . "</td>";
print "</tr>";
}
}
print "</table>";
}
{
$data=$io_sql->obtener_datos($rs_cta);
$arrcols=array_keys($data);
$totcol=count($arrcols);
$ds->data=$data;
$totrow=$ds->getRowCount("codart");
for($z=1;$z<=$totrow;$z++)
{
print "<tr class=celdas-blancas>";
$ls_codart=$data["codart"][$z];
$ls_denart=$data["denart"][$z];
$li_cosart=$data["cosart"][$z];
$li_cosart=round($li_cosart,2);
$li_cosart=uf_formatonumerico($li_cosart);
$li_unidad=$data["unidad"][$z];
$li_existencia=$data["existencia"][$z];
$li_existencia=number_format($li_existencia,2,',','.');
print "<td><a href=\"javascript: aceptar('$ls_codart','$ls_denart','$li_cosart','$li_linea','$li_unidad');\">".$ls_codart."</a></td>";
print "<td>".$data["denart"][$z]."</td>";
print "<td>".$li_existencia."</td>";
print "</tr>";
}
}
else
{
$io_msg->message("No hay registros");
}
