예제 #1
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 );
	
	

?>