=0;--$li_index)
{
if(($li_contador==3)&&(($li_index-1)>0))
{
$as_valor = substr($as_valor,0,$li_index).".".substr($as_valor,$li_index);
$li_contador=1;
}
else
{
$li_contador=$li_contador + 1;
}
}
return $as_valor;
}
//-----------------------------------------------------------------------------------------------------------------------------------
//-----------------------------------------------------------------------------------------------------------------------------------
// Función que obtiene e imprime los resultados de la busqueda
function uf_imprimirresultados($as_codper, $as_cedper, $as_nomper, $as_apeper)
{
require_once("../shared/class_folder/sigesp_include.php");
require_once("../shared/class_folder/class_mensajes.php");
require_once("../shared/class_folder/class_sql.php");
require_once("../shared/class_folder/class_funciones.php");
$in=new sigesp_include();
$con=$in->uf_conectar();
$io_msg=new class_mensajes();
$io_sql=new class_sql($con);
$ds=new class_datastore();
$fun=new class_funciones();
$emp=$_SESSION["la_empresa"];
$ls_codemp=$emp["codemp"];
print "
";
print "
";
print "
Cédula
";
print "
Nombre y Apellido
";
print "
Cargo
";
print "
";
$ls_sql="SELECT (CASE sno_nomina.racnom WHEN '1' THEN sno_asignacioncargo.denasicar ELSE sno_cargo.descar END) AS cargo,".
" sno_personalnomina.codper,".
"(SELECT nomper FROM sno_personal".
" WHERE sno_personal.codper=sno_personalnomina.codper) as nomper,".
"(SELECT apeper FROM sno_personal".
" WHERE sno_personal.codper=sno_personalnomina.codper) as apeper,".
"(SELECT cedper FROM sno_personal".
" WHERE sno_personal.codper=sno_personalnomina.codper) as cedper".
" FROM sno_personalnomina, sno_nomina, sno_cargo, sno_asignacioncargo,sno_personal".
" WHERE sno_personalnomina.codper LIKE '".$as_codper."'".
" AND sno_personal.cedper LIKE '".$as_cedper."'".
" AND sno_personal.nomper LIKE '".$as_nomper."'".
" AND sno_personal.apeper LIKE '".$as_apeper."'".
" AND sno_nomina.espnom='0'".
" AND sno_personalnomina.codemp = sno_nomina.codemp".
" AND sno_personalnomina.codnom = sno_nomina.codnom".
" AND sno_personalnomina.codper = sno_personal.codper".
" AND sno_personalnomina.codemp = sno_cargo.codemp".
" AND sno_personalnomina.codnom = sno_cargo.codnom".
" AND sno_personalnomina.codcar = sno_cargo.codcar".
" AND sno_personalnomina.codemp = sno_asignacioncargo.codemp".
" AND sno_personalnomina.codnom = sno_asignacioncargo.codnom".
" AND sno_personalnomina.codasicar = sno_asignacioncargo.codasicar".
" GROUP BY sno_personalnomina.codper,sno_nomina.racnom,sno_asignacioncargo.denasicar,sno_cargo.descar,codclavia".
" ORDER BY sno_personalnomina.codper,codclavia";
$rs_per=$io_sql->select($ls_sql);
$li_index=0;
while($row=$io_sql->fetch_row($rs_per))
{
$li_index=$li_index+1;
print "
";
}
if($li_index==0)
{
$io_msg->message("No hay nada que reportar");
}
print "
";
}
//-----------------------------------------------------------------------------------------------------------------------------------
?>
Catalogo de Personal