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; ?>