";
if ($ls_operacion=="BUSCAR")
{
$ls_cedbene= "%".$_POST["txtcedula"]."%";
$ls_nombene= $_POST["txtnombre"];
$ls_apebene= "%".$_POST["txtapellido"]."%";
$ls_codemp= $_SESSION["la_empresa"]["codemp"];
if($ls_tipo="reporte")
{
$ls_sql=" SELECT ced_bene,nombene,apebene ".
" FROM rpc_beneficiario ".
" WHERE codemp='".$ls_codemp."'".
" AND ced_bene like '".$ls_cedbene."'".
" AND nombene like '%".$ls_nombene."%'".
" AND apebene like '".$ls_apebene."'".
" AND ced_bene<>'----------'".
" ORDER BY ced_bene ASC";
}
else
{
$ls_sql=" SELECT ced_bene,nombene,apebene ".
" FROM rpc_beneficiario ".
" WHERE codemp='".$ls_codemp."'".
" AND ced_bene like '".$ls_cedbene."'".
" AND nombene like '%".$ls_nombene."%'".
" AND apebene like '".$ls_apebene."'".
" AND ced_bene<>'----------'".
" AND ced_bene NOT IN (SELECT cedper".
" FROM sno_personal".
" WHERE rpc_beneficiario.codemp=sno_personal.codemp".
" AND rpc_beneficiario.ced_bene=sno_personal.cedper)";
" ORDER BY ced_bene ASC";
}
$rs_bene=$io_sql->select($ls_sql);
$data=$rs_bene;
if ($row=$io_sql->fetch_row($rs_bene))
{
$data=$io_sql->obtener_datos($rs_bene);
$arrcols=array_keys($data);
$totcol=count($arrcols);
$io_dsbene->data=$data;
$totrow=$io_dsbene->getRowCount("ced_bene");
for ($z=1;$z<=$totrow;$z++)
{
print "