";
print "";
print "| Código | ";
print "Cédula | ";
print "Nombre y Apellido | ";
print "Estatus | ";
print "
";
switch($as_buscar)
{
case"0":
if ($as_respced!="buscaresced")
{
$ls_sql="SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, ".
" sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, ".
" sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, ".
" sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, ".
" sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, ".
" sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, ".
" sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, ".
" sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, ".
" sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, ".
" sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, ".
" sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper,sno_personal.codorg ".
" FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia ".
" WHERE sno_personal.codemp='".$ls_codemp."'".
" AND sno_profesion.codemp = sno_personal.codemp ".
" AND sno_profesion.codpro = sno_personal.codpro ".
" AND sigesp_pais.codpai = sno_personal.codpai ".
" AND sigesp_estados.codpai = sno_personal.codpai ".
" AND sigesp_estados.codest = sno_personal.codest ".
" AND sigesp_municipio.codpai = sno_personal.codpai ".
" AND sigesp_municipio.codest = sno_personal.codest ".
" AND sigesp_municipio.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpai = sno_personal.codpai ".
" AND sigesp_parroquia.codest = sno_personal.codest ".
" AND sigesp_parroquia.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpar = sno_personal.codpar ".
" AND sno_personal.codper like '".$as_codper."' ".
" AND sno_personal.cedper like '".$as_cedper."'".
" AND UPPER(sno_personal.nomper) like '".strtoupper($as_nomper)."' ";
}
else
{
$ls_sql="SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, ".
" sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, ".
" sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, ".
" sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, ".
" sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, ".
" sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, ".
" sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, ".
" sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, ".
" sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, ".
" sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, ".
" sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper,sno_personal.codorg ".
" FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia ".
" WHERE sno_personal.codemp='".$ls_codemp."'".
" AND sno_profesion.codemp = sno_personal.codemp ".
" AND sno_profesion.codpro = sno_personal.codpro ".
" AND sigesp_pais.codpai = sno_personal.codpai ".
" AND sigesp_estados.codpai = sno_personal.codpai ".
" AND sigesp_estados.codest = sno_personal.codest ".
" AND sigesp_municipio.codpai = sno_personal.codpai ".
" AND sigesp_municipio.codest = sno_personal.codest ".
" AND sigesp_municipio.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpai = sno_personal.codpai ".
" AND sigesp_parroquia.codest = sno_personal.codest ".
" AND sigesp_parroquia.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpar = sno_personal.codpar ".
" AND sno_personal.codper like '".$as_codper."' ".
" AND sno_personal.cedper like '".$as_cedper."'".
" AND UPPER(sno_personal.nomper) like '".strtoupper($as_nomper)."' ".
" AND UPPER(sno_personal.apeper) like '".strtoupper($as_apeper)."'".
" AND sno_personal.codper <> '".$as_codresced."'";
}
break;
case "1":
if ($as_buscartest="buscartest")
{
$ls_sql="SELECT sno_personal.codper, sno_personal.cedper, sno_personal.nomper, sno_personal.apeper, sno_personal.dirper, ".
" sno_personal.fecnacper, sno_personal.edocivper, sno_personal.telhabper, sno_personal.telmovper, ".
" sno_personal.sexper, sno_personal.estaper, sno_personal.pesper, sno_personal.codpro, sno_personal.nivacaper, ".
" sno_personal.catper, sno_personal.cajahoper, sno_personal.numhijper, sno_personal.contraper, sno_personal.tipvivper, ".
" sno_personal.tenvivper, sno_personal.monpagvivper, sno_personal.ingbrumen, sno_personal.cuecajahoper, ".
" sno_personal.cuelphper, sno_personal.cuefidper, sno_personal.fecingadmpubper, sno_personal.vacper, sno_personal.porisrper, ".
" sno_personal.fecingper, sno_personal.anoservpreper, sno_personal.cedbenper, sno_personal.fecegrper, sno_personal.estper, ".
" sno_personal.fotper, sno_personal.codpai, sno_personal.codest, sno_personal.codmun, sno_personal.codpar, ".
" sno_personal.obsper, sno_personal.cauegrper, sno_personal.obsegrper, sno_personal.nacper, sno_personal.coreleper, ".
" sno_personal.cenmedper, sno_profesion.despro, sigesp_pais.despai, sno_personal.horper, sno_personal.turper, ".
" sigesp_estados.desest, sigesp_municipio.denmun, sigesp_parroquia.denpar, sno_personal.hcmper, sno_personal.tipsanper,
sno_personal.codorg ".
" FROM sno_personal, sno_profesion, sigesp_pais, sigesp_estados, sigesp_municipio, sigesp_parroquia ".
" WHERE sno_personal.codemp='".$ls_codemp."'".
" AND sno_profesion.codemp = sno_personal.codemp ".
" AND sno_profesion.codpro = sno_personal.codpro ".
" AND sigesp_pais.codpai = sno_personal.codpai ".
" AND sigesp_estados.codpai = sno_personal.codpai ".
" AND sigesp_estados.codest = sno_personal.codest ".
" AND sigesp_municipio.codpai = sno_personal.codpai ".
" AND sigesp_municipio.codest = sno_personal.codest ".
" AND sigesp_municipio.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpai = sno_personal.codpai ".
" AND sigesp_parroquia.codest = sno_personal.codest ".
" AND sigesp_parroquia.codmun = sno_personal.codmun ".
" AND sigesp_parroquia.codpar = sno_personal.codpar ".
" AND sno_personal.codper like '".$as_codper."' ".
" AND sno_personal.cedper like '".$as_cedper."'".
" AND UPPER(sno_personal.nomper) like '".strtoupper($as_nomper)."' ".
" AND UPPER(sno_personal.apeper) like '".strtoupper($as_apeper)."'".
" AND sno_personal.codper <> '".$as_codresced."'".
" AND sno_personal.codper <> '".$as_codreserec."'";
//print $ls_sql;
}
break;
}// fin del switch
$ls_repetidos=$io_sno->uf_select_config("SNO","CONFIG","NOPERMITIR_REPETIDOS","1","C");
$ls_sql=$ls_sql." AND sno_personal.estper = '1'
AND (sno_personal.codper IN (SELECT codper
FROM sno_personalnomina, sno_nomina
WHERE sno_personalnomina.codemp='".$ls_codemp."'
AND sno_nomina.espnom='1'
AND sno_personalnomina.codemp=sno_nomina.codemp
AND sno_personalnomina.codnom=sno_nomina.codnom))
ORDER BY sno_personal.codper";
$rs_data=$io_sql->select($ls_sql);
if($rs_data===false)
{
$io_mensajes->message("ERROR->".$io_funciones->uf_convertirmsg($io_sql->message));
}
else
{
while(!$rs_data->EOF)
{
$ls_codper=$rs_data->fields["codper"];
$ls_cedper=$rs_data->fields["cedper"];
$ls_nomper=$rs_data->fields["nomper"];
$ls_apeper=$rs_data->fields["apeper"];
$ls_dirper=$rs_data->fields["dirper"];
$ld_fecnacper=$io_funciones->uf_convertirfecmostrar($rs_data->fields["fecnacper"]);
$ls_edocivper=$rs_data->fields["edocivper"];
$ls_telhabper=$rs_data->fields["telhabper"];
$ls_telmovper=$rs_data->fields["telmovper"];
$ls_sexper=$rs_data->fields["sexper"];
$li_estaper=$rs_data->fields["estaper"];
$li_estaper=$io_fun_nomina->uf_formatonumerico($li_estaper);
$li_pesper=$rs_data->fields["pesper"];
$li_pesper=$io_fun_nomina->uf_formatonumerico($li_pesper);
$ls_codpro=$rs_data->fields["codpro"];
$ls_nivacaper=$rs_data->fields["nivacaper"];
$ls_codpai=$rs_data->fields["codpai"];
$ls_codest=$rs_data->fields["codest"];
$ls_codmun=$rs_data->fields["codmun"];
$ls_codpar=$rs_data->fields["codpar"];
$ls_catper=$rs_data->fields["catper"];
$ls_cedbenper=$rs_data->fields["cedbenper"];
$ls_numhijper=$rs_data->fields["numhijper"];
$ls_obsper=$rs_data->fields["obsper"];
$ls_contraper=$rs_data->fields["contraper"];
$ls_tipvivper=$rs_data->fields["tipvivper"];
$ls_tenvivper=$rs_data->fields["tenvivper"];
$li_monpagvivper=$rs_data->fields["monpagvivper"];
$li_monpagvivper=$io_fun_nomina->uf_formatonumerico($li_monpagvivper);
$ls_cuecajahoper=$rs_data->fields["cuecajahoper"];
$ls_cuelphper=$rs_data->fields["cuelphper"];
$ls_cuefidper=$rs_data->fields["cuefidper"];
$ls_cajahoper=$rs_data->fields["cajahoper"];
$ld_fecingadmpubper=$io_funciones->uf_convertirfecmostrar($rs_data->fields["fecingadmpubper"]);
$li_anoservpreper=$rs_data->fields["anoservpreper"];
$ld_fecingper=$io_funciones->uf_convertirfecmostrar($rs_data->fields["fecingper"]);
$ld_fecegrper=$io_funciones->uf_convertirfecmostrar($rs_data->fields["fecegrper"]);
$ls_cauegrper=$rs_data->fields["cauegrper"];
$ls_obsegrper=$rs_data->fields["obsegrper"];
$ls_estper=$rs_data->fields["estper"];
$ls_nacper=$rs_data->fields["nacper"];
$ls_hcmper=$rs_data->fields["hcmper"];
$ls_tipsanper=$rs_data->fields["tipsanper"];
switch ($ls_estper)
{
case "0":
$ls_estper="Pre-Ingreso";
break;
case "1":
$ls_estper="Activo";
break;
case "2":
$ls_estper="N/A";
break;
case "3":
$ls_estper="Egresado";
break;
}
$ls_despro=$rs_data->fields["despro"];
$ls_despai=$rs_data->fields["despai"];
$ls_desest=$rs_data->fields["desest"];
$ls_desmun=$rs_data->fields["denmun"];
$ls_despar=$rs_data->fields["denpar"];
$ls_nomfot=$rs_data->fields["fotper"];
$ls_coreleper=$rs_data->fields["coreleper"];
$ls_cenmedper=$rs_data->fields["cenmedper"];
$ls_turper=$rs_data->fields["turper"];
$ls_horper=$rs_data->fields["horper"];
switch ($as_tipo)
{
case "":
print "";
print "| ";
print "".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "egreso":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "asignacion":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "asignacion2":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "asignacion3":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "cambio":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "buscar":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "replisperdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "replisperhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repconttrabdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repconttrabhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "ipasme":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssingdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssinghas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssretdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssrethas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivsssaldes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivsssalhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivsscendes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivsscenhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssmoddes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssmodhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssrepdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssrephas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssperdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repivssperhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repvacperdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repvacperhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "replisfamdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "replisfamhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repconcdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repconchas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repliscumdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repliscumhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repficperdes":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "repficperhas":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
case "retornoactivos":
print "";
print "| ".$ls_codper." | ";
print "".$ls_cedper." | ";
print "".$ls_nomper." ".$ls_apeper." | ";
print "".$ls_estper." | ";
print "
";
break;
}
$rs_data->MoveNext();
}
$io_sql->free_result($rs_data);
}
print "
";
unset($io_include,$io_conexion,$io_sql,$io_mensajes,$io_funciones,$io_sno,$ls_codemp);
}
//-----------------------------------------------------------------------------------------------------------------------------------
?>