Esempio n. 1
0
 function GETActivos() { 
 
     $_prop['ACTIVO']['VALUE']=1;  
     $sqlHelper = new gODataManager($this->_condb);
     $rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETACTIVOS');
     return $rs;
 }
Esempio n. 2
0
 function GETbyUsuario($Usuario) { 
 
         $_prop['USUARIO']['VALUE']=$Usuario;
         
         $sqlHelper = new gODataManager($this->_condb);
         $rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETbyNombre');
         return $rs;
 }
Esempio n. 3
0
	function GETbyIDRaiz($Id) { 
	
		$_prop['ID']['VALUE']=$Id;
		
		$sqlHelper = new gODataManager($this->_condb);
		$rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETbyIDRaiz');
		return $rs;
	}
Esempio n. 4
0
	function GetAll() { 
		$sqlHelper = new gODataManager($this->_condb);
		$rs = $sqlHelper->spGetAll($this->_entidad_base);
		return $rs;
	}
Esempio n. 5
0
	if (isset($_GET["sortfield"])){
		$_SESSION[$m][$a]['sortfield']= $_GET["sortfield"];
	}
	
	$orderby = isset($_SESSION[$m][$a]['sortfield']) ? " ORDER BY ".$_SESSION[$m][$a]['sortfield'] : "";

	//--------------------------------------------
	//Variables de conexion
	//--------------------------------------------
	$conf = PAE_GetConfiguration("$baseDir/../_configuration/",$g_ConfigTxt);
	$_SESSION[$m]['SCHEMA']=$conf["DB_Database"];
	
	// Consulta SQL
	$sql= "SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE OWNER='".strtoupper($conf["DB_User"])."' ".$orderby ;


	$sqlHelper = new gODataManager($condb);
	$errMensajes ="";

	$rs = $sqlHelper->sqlGetCommand($sql);
	
	//resulset paginado
	$rsOutput = getCurrentListSmartyPaginate($rs,$smarty);
	
	//resulset de salida
	$smarty->assign('rsOutput',$rsOutput );
	
	

?>