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); }