public function getPruebadni($tdoc, $dni)
{
parent::setMNombre_SP("sel_prueba");
parent::pg_Parametros_SP("\$1", $tdoc);
parent::pg_Parametros_SP("\$2", $dni);
parent::pg_Campos_Select("*");
parent::pg_Poner_Esquema("hospitalizacion");
parent::pg_Paginacion('ALL');
$resultado = parent::executeSPArray();
return $resultado;
}
function Siguiente_Id($aTable, $aField1, $sql)
{
global $Coneccion;
$spr_id = new TSPResult($Coneccion, "fn_nextid");
$spr_id->pg_Parametros_SP('aTable', $aTable);
$spr_id->pg_Parametros_SP('aField', $aField1);
if ($sql != '0' or strlen(trim($sql)) > 1) {
$spr_id->pg_Parametros_SP('aWhere', "ano_eje = ''" . date("Y") . "'' and {$aField1} not like ''%.%'' " . $sql);
} else {
$spr_id->pg_Parametros_SP('aWhere', "ano_eje = ''" . date("Y") . "'' and {$aField1} not like ''%.%'' ");
}
$spr_id->pg_Poner_Esquema("logistica");
$spr_id->pg_Campos_Select('*');
$spr_id->pg_Paginacion(ALL);
$spr_id->executeSP();
//echo $spr_id->pg_Store_Procedure();
$result = $spr_id->pg_Get_Row();
return $result[0];
}
<?php
////////////////////
//PARAMETROS DE MENU
////////////////////
$Rs = new TSPResult($Coneccion, "menu");
$Rs->pg_Parametros_SP("\$1", $id_sistema);
$Rs->pg_Parametros_SP("\$2", 0);
$Rs->pg_Parametros_SP("\$3", $sess["cod_user"]);
$Rs->pg_Campos_Select("*");
$Rs->pg_Poner_Esquema(" permisos ");
$Rs->pg_Paginacion('ALL');
$Rs->executeSP();
//echo $Rs->Escribir_Consulta();
$num = $Rs->pg_Total_Rows();
if ($num > 0) {
$dep_ant = -1;
$depende_ant = -1;
$menu = 0;
$nivel_anterior = -1;
$count_menu = 0;
$count[] = '';
$numero[] = '';
?>
<script>
stm_bm(["menu4878",830,"","<?php
echo $path;
?>
blank.gif",0,"","",<?php
echo $alineacion;
?>
