public function getList()
{
$myAct = new OPF_myActiveRecord();
$arRpl = array('OPF_FIELD_MODIFICAR' => OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'OPF_FIELD_ELIMINAR' => OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'OPF_FIELD_ID' => OPF_myLang::getPhrase('OPF_FIELD_ID'), 'OPF_FIELD_PADRE' => OPF_myLang::getPhrase('OPF_FIELD_PADRE'), 'OPF_FIELD_DESCRIPCION' => OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'OPF_FIELD_ICON' => OPF_myLang::getPhrase('OPF_FIELD_ICON'), 'OPF_FIELD_URL' => OPF_myLang::getPhrase('OPF_FIELD_URL'), 'OPF_FIELD_ORDEN' => OPF_myLang::getPhrase('OPF_FIELD_ORDEN'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_DATETIME' => OPF_myLang::getPhrase('OPF_FIELD_DATETIME'));
$myList = new OPF_myList('lst_menu', $myAct->loadSqlFromFile(dirname(__FILE__) . DS . 'sql' . DS . 'list_menu.sql', $arRpl));
$myList->width = 1100;
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 80);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 80);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ID'), 50);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_PADRE'), 125);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 125);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ICON'), 60);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ORDEN'), 40);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 120);
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ID'), 'ess_menu.id');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_PADRE'), 'same.description');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'ess_menu.description');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ICON'), 'ess_menu.icon');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_URL'), 'ess_menu.url');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ORDEN'), 'ess_menu.ord');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'ess_menu.datetime');
$myList->setUseOrderMethod(true, OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'DESC');
$myList->setExportData(true, true, true);
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'onClickAddModRecord');
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'onClickDeleteRecord', OPF_myLang::getPhrase('OPF_FIELD_CONFIRM_ELIMINAR'));
$myList->setPagination(true, 50);
return $myList->getList(true, true);
}
public function getListUsrs()
{
$myAct = new OPF_myActiveRecord();
$arrReplace = array('OPF_FIELD_MODIFICAR' => OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'OPF_FIELD_ELIMINAR' => OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_NOMBRE' => OPF_myLang::getPhrase('OPF_FIELD_NOMBRE'), 'OPF_FIELD_APELLIDO' => OPF_myLang::getPhrase('OPF_FIELD_APELLIDO'), 'OPF_FIELD_ACTUALIZADO' => OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 'OPF_FIELD_PERFIL' => OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 'OPF_ADMUSR_11' => OPF_myLang::getPhrase('OPF_ADMUSR_11'), 'OPF_ADMUSR_10' => OPF_myLang::getPhrase('OPF_ADMUSR_10'), 'OPF_FIELD_ESTADO' => OPF_myLang::getPhrase('OPF_FIELD_ESTADO'));
$myList = new OPF_myList('lst_users', $myAct->loadSqlFromFile(dirname(__FILE__) . DS . 'sql' . DS . 'lst_users.sql', $arrReplace));
$myList->width = 950;
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 70);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 70);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_NOMBRE'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_APELLIDO'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 160);
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_NOMBRE'), 'ess_system_users.name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_APELLIDO'), 'ess_system_users.lastname');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 'ess_profiles.name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 'ess_system_users.datetime');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ESTADO'), 'ess_system_users.status');
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'onClickNewRecord');
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'onClickDeleteRecord', OPF_myLang::getPhrase('OPF_FIELD_CONFIRM_ELIMINAR'));
$myList->setUseOrderMethod(true, OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'));
$myList->setPagination(true, 50);
$myList->setExportData(true, true, true);
$myList->setGlobalEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), array(OPF_myLang::getPhrase('OPF_ADMUSR_8') => 'habilitaUsuarios', OPF_myLang::getPhrase('OPF_ADMUSR_9') => 'inhabilitaUsuarios'));
return $myList->getList(true, true);
}
public static function getListBit()
{
$myAct = new OPF_myActiveRecord();
$arrReplace = array('OPF_FIELD_ID' => OPF_myLang::getPhrase('OPF_FIELD_ID'), 'OPF_FIELD_DATETIME' => OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'OPF_FIELD_IP' => OPF_myLang::getPhrase('OPF_FIELD_IP'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_URL' => OPF_myLang::getPhrase('OPF_FIELD_URL'));
$myList = new OPF_myList('lst_bit', $myAct->loadSqlFromFile(dirname(__FILE__) . DS . 'sql' . DS . 'bit.sql', $arrReplace));
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ID'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 130);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_IP'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_URL'), 570);
$myList->setUseOrderMethod(true, OPF_myLang::getPhrase('OPF_FIELD_ID'), 'DESC');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ID'), 'ess_bit.id');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'ess_bit.datetime');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_IP'), 'ess_bit.ip');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_URL'), 'ess_bit.url');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setPagination(true, 20);
$myList->setExportData(true, true, true);
return $myList->getList(true, true);
}
/**
* Recarga una lista dinamica.
*
* Refresca los datos contenidos de una lista dinamica previamente declarada en su ubicación actual u original.
* @param string $idList Id de la lista a refrescar su contenido
*/
public function MYLIST_reload($idList)
{
if (!is_string($idList)) {
$args = func_get_args();
$idList = $args[1];
}
if (isset($_SESSION['prdLst'][$idList])) {
$myList = new OPF_myList($idList);
$this->assign($idList, 'innerHTML', $myList->getList());
$js = 'clearRowsMarked();' . "\n";
$this->script($js);
} else {
$this->messageBox(MSG_ERROR_IDLIST_NOTDEFINED, 'critical');
}
return $this->response;
}
public function getListForTableDetail()
{
$myAct = new OPF_myActiveRecord();
$arrReplace = array('OPF_FIELD_MODIFICAR' => OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'OPF_FIELD_ELIMINAR' => OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'OPF_FIELD_CODIGO' => OPF_myLang::getPhrase('OPF_FIELD_CODIGO'), 'OPF_FIELD_DESCRIPCION' => OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_ACTUALIZADO' => OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 'master_tables_id' => $this->table_id);
$myList = new OPF_myList('lst_tablas_detalle', $myAct->loadSqlFromFile(dirname(__FILE__) . '/sql/lst_tablas_detalle.sql', $arrReplace));
$myList->width = 760;
$myList->setGlobalEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), array(OPF_FIELD_ELIMINAR => 'onClickDeleteItems'));
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 70);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 60);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_CODIGO'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 90);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 130);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 310);
$myList->setPagination(true, 10);
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'onClickUpdateDetail');
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'onClickDeleteItems', OPF_myLang::getPhrase('OPF_FIELD_CONFIRM_ELIMINAR'));
$myList->setExportData(true, true, true);
$myList->setUseOrderMethod(true, OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'));
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_CODIGO'), 'ess_master_tables_detail.item_cod');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'ess_master_tables_detail.item_desc');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 'ess_master_tables_detail.datetime');
return $myList->getList(true);
}
public function getListProfiles()
{
$myAct = new OPF_myActiveRecord();
$arrRpl = array('OPF_FIELD_MODIFICAR' => OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'OPF_FIELD_ELIMINAR' => OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'OPF_FIELD_PERFIL' => OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 'OPF_FIELD_DESCRIPCION' => OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_DATETIME' => OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'OPF_FIELD_MENU' => OPF_myLang::getPhrase('OPF_FIELD_MENU'));
$myList = new OPF_myList('lst_profiles', $sql = $myAct->loadSqlFromFile(dirname(__FILE__) . DS . 'sql' . DS . 'lstProfiles.sql', $arrRpl));
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 'onClickAddRecord');
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 'onClickDeleteRecord', OPF_myLang::getPhrase('OPF_FIELD_CONFIRM_ELIMINAR'));
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_MENU'), 'onClickEditMenu');
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_MODIFICAR'), 80);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ELIMINAR'), 80);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_MENU'), 80);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 140);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 120);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 400);
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_PERFIL'), 'ess_profiles.name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DESCRIPCION'), 'ess_profiles.description');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_DATETIME'), 'ess_profiles.datetime');
$myList->setPagination(true, 20);
$myList->setExportData(true, true, true);
$myList->setUseOrderMethod(true, '');
return $myList->getList(true, true);
}
<?php
if (isset($_GET['id_list'])) {
$idList = $_GET['id_list'];
$objList = new OPF_myList($idList);
$sql = $objList->getVar('sql');
/**
* Where rules
*/
$sqlWhere = '';
$arWrRls = $objList->getVar('arrayWhereRules');
if (count($arWrRls)) {
if (stripos($sql, 'WHERE') !== false) {
$sqlWhere = ' AND (';
} else {
$sqlWhere = ' WHERE (1=1 AND ';
}
$rules = '';
foreach ($arWrRls as $id => $rule) {
$rules .= $rule . ' ';
}
$sqlWhere .= substr($rules, 3) . ')';
}
/**
* Order Method
*/
$sqlOrder = '';
$arOrMtd = $objList->getVar('arrayOrdMethod');
$arAlInQy = $objList->getVar('arrayAliasSetInQuery');
if ($arOrMtd !== false) {
foreach ($arOrMtd as $column => $method) {
/**
* Contruye el resultado segun el tipo de archivo
* @access private
* @return string
*/
private function buildResult()
{
$fromListExport = false;
if (count($this->arrFieldHiden)) {
$fromListExport = true;
}
$out = '';
$widthList = 0;
if ($this->idList) {
$myList = new OPF_myList($this->idList);
$this->width = $myList->getVar('arrayWidthsCols');
$widthList = $myList->getVar('width');
$numFldsAftd = $myList->getVar('numFldsAftd');
$widthDefa = intval($widthList / $numFldsAftd);
}
switch ($this->format) {
case 'pdf':
$swTl = 0;
$ori = 'P';
if ($widthList > 900) {
$ori = 'L';
}
$this->objPDF = new PDF_MC_Table($ori);
$this->objPDF->SetLineWidth(0.1);
$this->objPDF->AddPage();
$this->Header($ori);
foreach ($this->resSql as $row) {
// Titles
if (!$swTl) {
$this->objPDF->SetFont('Arial', '', 10);
$intTitl = 1;
foreach ($row as $key => $val) {
if (in_array($intTitl, $this->arrFieldHiden) || $fromListExport == false) {
if (isset($this->width[$key])) {
$widthCol = $this->width[$key] + 40;
} else {
$widthCol = $widthDefa + 40;
}
$this->objPDF->Cell($widthCol / 6, 5, ucwords(strtolower(utf8_decode($key))), 1, 0, 'C', false);
}
++$intTitl;
}
$this->objPDF->Ln();
$swTl = 1;
$this->objPDF->SetFont('Arial', '', 7);
}
$intTitl = 1;
$estaFila = array();
$estaFilaAnchos = array();
$estaFilaAligns = array();
foreach ($row as $key => $val) {
if (in_array($intTitl, $this->arrFieldHiden) || $fromListExport == false) {
if (isset($this->width[$key])) {
$widthCol = $this->width[$key] + 40;
} else {
$widthCol = $widthDefa + 40;
}
$align = 'L';
if (is_numeric($val)) {
$align = 'R';
}
$estaFila[] = utf8_decode($val);
$estaFilaAligns[] = $widthCol / 6;
$estaFilaAnchos[] = $widthCol / 6;
}
++$intTitl;
}
$this->objPDF->SetAligns($estaFilaAligns);
$this->objPDF->SetWidths($estaFilaAnchos);
$this->objPDF->Row($estaFila);
}
$out .= $this->objPDF->Output('', 'S');
break;
default:
$swTl = 0;
if ($this->format == 'html') {
$out .= '<html>';
$out .= '<head><style type="text/css">td{font-family: Arial, Helvetica, sans-serif;font-size: 13px;}</style>';
$out .= '</head><body>';
$out .= '<table border="0" cellspacing="0" cellpadding="0"><tr><td width="30%"> </td><td width="70%">' . REPORT_TITLE . $_SERVER['HTTP_REFERER'] . '</td></tr>';
$out .= '<tr><td bgcolor="#000000" colspan="2">';
$out .= '<table border="0" cellspacing="1" cellpadding="0" width="100%">';
} else {
$out .= '<table border="1">';
}
$bg = '';
if ($this->format == 'html') {
$bg = 'bgcolor="#FFFFFF"';
}
foreach ($this->resSql as $row) {
// Titles
if (!$swTl) {
$out .= '<tr>';
$intTitl = 1;
foreach ($row as $key => $val) {
if (in_array($intTitl, $this->arrFieldHiden) || $fromListExport == false) {
$widthCol = '';
if (isset($arWidth[$key])) {
$widthCol = 'width="' . $arWidth[$key] . '"';
}
$out .= '<td ' . $widthCol . ' align="center" ' . $bg . '>';
$out .= ucwords(strtolower(utf8_decode($key)));
$out .= '</td>';
}
++$intTitl;
}
$out .= '</tr>';
$swTl = 1;
}
$out .= '<tr>';
$intTitl = 1;
foreach ($row as $key => $val) {
if (in_array($intTitl, $this->arrFieldHiden) || $fromListExport == false) {
$align = 'left';
if (is_numeric($val)) {
$align = 'right';
}
$out .= '<td ' . $bg . ' align="' . $align . '">';
$out .= utf8_decode($val);
$out .= '</td>';
}
++$intTitl;
}
$out .= '</tr>';
}
$out .= '</table>';
if ($this->format == 'html') {
$out .= '</td></tr></table>';
$out .= '</body></html>';
}
break;
}
$this->resText = $out;
}
public function buildDinamicListUsersOnLine()
{
$actRecord = new OPF_myActiveRecord();
$arrRpl = array('OPF_FIELD_CERRAR' => OPF_myLang::getPhrase('OPF_FIELD_CERRAR'), 'OPF_FIELD_USUARIO' => OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'OPF_FIELD_IP' => OPF_myLang::getPhrase('OPF_FIELD_IP'), 'OPF_FIELD_INGRESO' => OPF_myLang::getPhrase('OPF_FIELD_INGRESO'), 'OPF_FIELD_FILE' => OPF_myLang::getPhrase('OPF_FIELD_FILE'), 'OPF_FIELD_PESO' => OPF_myLang::getPhrase('OPF_FIELD_PESO'), 'OPF_FIELD_ACTUALIZADO' => OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'));
$myList = new OPF_myList('users_on_line', $actRecord->loadSqlFromFile(dirname(__FILE__) . DS . 'sql' . DS . 'user_online.sql', $arrRpl));
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_CERRAR'), 60);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_IP'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_INGRESO'), 150);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_FILE'), 200);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_PESO'), 100);
$myList->setWidthColumn(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 90);
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_USUARIO'), 'ess_system_users.user_name');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_IP'), 'ess_usronline.ip');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_INGRESO'), 'ess_usronline.datetime');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_FILE'), 'ess_usronline.sesname');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_PESO'), 'ess_usronline.size');
$myList->setRealNameInQuery(OPF_myLang::getPhrase('OPF_FIELD_ACTUALIZADO'), 'ess_usronline.filectime');
$myList->width = 900;
$myList->setEventOnColumn(OPF_myLang::getPhrase('OPF_FIELD_CERRAR'), 'closeSessionOnUser', OPF_myLang::getPhrase('OPF_USRONLINE_3'));
$myList->setExportData(true, true, true);
$myList->setUseOrderMethod(true, OPF_myLang::getPhrase('OPF_FIELD_INGRESO'));
return $myList->getList(true, true);
}
