示例#1
0
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];
}
示例#2
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;
    ?>