uf_obtenervalor_get("row","");
if($li_row=="")
{
$li_row=$fun_activos->uf_obtenervalor("hidrow","");
}
$operacion=$fun_activos->uf_obteneroperacion();
$ls_destino=$fun_activos->uf_obtenervalor_get("destino","");
$ls_codact=$fun_activos->uf_obtenervalor_get("codact","");
$ls_idact=$fun_activos->uf_obtenervalor_get("idact","");
$ls_tiporesponsable=$fun_activos->uf_obtenervalor_get("tiporesponsable","");
//-----------------------------------------------------------------------------------------------------------------------------------
// Función que obtiene e imprime los resultados de la busqueda
function uf_imprimirresultados($as_codact,$as_idact,$as_tiporesponsable,$as_destino)
{
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");
$io_sql=new class_sql($con);
$ds=new class_datastore();
require_once("../shared/class_folder/class_funciones.php");
$fun=new class_funciones();
$ls_codemp=$_SESSION["la_empresa"]["codemp"];
print "
";
print "
";
print "
Código
";
print "
Cédula
";
print "
Nombre y Apellido
";
print "
";
switch ($as_tiporesponsable)
{
case "uso":
$ls_sql="SELECT DISTINCT(codres) AS codres,".
" (SELECT nomper".
" FROM sno_personal".
" WHERE sno_personal.codemp=saf_dta.codemp".
" AND sno_personal.codper=saf_dta.codres) AS nomres1,".
" (SELECT nombene".
" FROM rpc_beneficiario".
" WHERE rpc_beneficiario.codemp=saf_dta.codemp".
" AND rpc_beneficiario.ced_bene=saf_dta.codres) AS nomres2,".
" (SELECT apeper".
" FROM sno_personal".
" WHERE sno_personal.codemp=saf_dta.codemp".
" AND sno_personal.codper=saf_dta.codres) AS aperes1,".
" (SELECT apebene".
" FROM rpc_beneficiario".
" WHERE rpc_beneficiario.codemp=saf_dta.codemp".
" AND rpc_beneficiario.ced_bene=saf_dta.codres) AS aperes2".
" FROM saf_dta".
" WHERE codemp='".$ls_codemp."'".
" AND codact='".$as_codact."'";
break;
case "primario":
$ls_sql="SELECT DISTINCT(codrespri) AS codres,".
" (SELECT nomper".
" FROM sno_personal".
" WHERE sno_personal.codemp=saf_dta.codemp".
" AND sno_personal.codper=saf_dta.codrespri) AS nomres1,".
" (SELECT nombene".
" FROM rpc_beneficiario".
" WHERE rpc_beneficiario.codemp=saf_dta.codemp".
" AND rpc_beneficiario.ced_bene=saf_dta.codrespri) AS nomres2,".
" (SELECT apeper".
" FROM sno_personal".
" WHERE sno_personal.codemp=saf_dta.codemp".
" AND sno_personal.codper=saf_dta.codrespri) AS aperes1,".
" (SELECT apebene".
" FROM rpc_beneficiario".
" WHERE rpc_beneficiario.codemp=saf_dta.codemp".
" AND rpc_beneficiario.ced_bene=saf_dta.codrespri) AS aperes2".
" FROM saf_dta".
" WHERE codemp='".$ls_codemp."'".
" AND codact='".$as_codact."'";
break;
}
$rs_data=$io_sql->select($ls_sql);
$li_num=$io_sql->num_rows($rs_data);
if($li_num>0)
{
while($row=$io_sql->fetch_row($rs_data))
{
$ls_codres=$row["codres"];
$ls_nomres1=$row["nomres1"];
if ($ls_nomres1=="")
{
$ls_nomres=$row["nomres2"]." ".$row["aperes2"];
}
else
{
$ls_nomres=$row["nomres1"]." ".$row["aperes1"];
}
if($ls_codres!="")
{
print "
";
}
//-----------------------------------------------------------------------------------------------------------------------------------
?>
Catalogo de Personal