function GETActivos() { $_prop['ACTIVO']['VALUE']=1; $sqlHelper = new gODataManager($this->_condb); $rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETACTIVOS'); return $rs; }
function GETbyUsuario($Usuario) { $_prop['USUARIO']['VALUE']=$Usuario; $sqlHelper = new gODataManager($this->_condb); $rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETbyNombre'); return $rs; }
function GETbyIDRaiz($Id) { $_prop['ID']['VALUE']=$Id; $sqlHelper = new gODataManager($this->_condb); $rs = $sqlHelper->spExecuteCursor($this->_entidad_base, $_prop,'GETbyIDRaiz'); return $rs; }
function GetAll() { $sqlHelper = new gODataManager($this->_condb); $rs = $sqlHelper->spGetAll($this->_entidad_base); return $rs; }
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 ); ?>