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 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 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);
}
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);
}
public static function formNewScaffStep4($datForm)
{
$myForm = new OPF_myForm('formNewScaffStep4');
$sqlTemp = 'SELECT * FROM ' . $_SESSION['temp_scaff_info']['table_name'] . ' LIMIT 1';
$myAct = new OPF_myActiveRecord();
$resSql = $myAct->query($sqlTemp, false);
$campoGrilla = array('field_selec', 'field_etq', 'field_ancho');
$myForm->addComment('field_selec', '<div align="center"><b>' . OPF_myLang::getPhrase('OPF_SCAFF_16') . '/' . OPF_myLang::getPhrase('OPF_SCAFF_41') . '</b></div>');
$myForm->addComment('field_etq', '<div align="center"><b>' . OPF_myLang::getPhrase('OPF_SCAFF_17') . '</b></div>');
$myForm->addComment('field_ancho', '<div align="center"><b>' . OPF_myLang::getPhrase('OPF_SCAFF_18') . '</b></div>');
foreach ($resSql[0] as $id => $value) {
if (isset($_SESSION['temp_scaff_info']['grid_att']['fields_on_list'][$id])) {
$check = true;
$etq = $_SESSION['temp_scaff_info']['grid_att']['fields_on_list'][$id][0];
$width = $_SESSION['temp_scaff_info']['grid_att']['fields_on_list'][$id][1];
} else {
$check = false;
$etq = '';
$width = '';
$myForm->addDisabled('etq_' . $id);
$myForm->addDisabled('width_' . $id);
}
$myForm->addEvent('field_' . $id, 'onclick', 'updateWidthListT2', 'field_' . $id, 'width_' . $id, 'etq_' . $id);
$myForm->addCheckBox($id, 'field_' . $id, $check);
$campoGrilla[] = 'field_' . $id;
$myForm->addComment('etq_' . $id, '<div align="center">' . $myForm->getText('etq_' . $id, $etq, 15) . '</div>');
$campoGrilla[] = 'etq_' . $id;
$myForm->addEvent('width_' . $id, 'onblur', 'updateWidthListT', 'width_' . $id, 'field_' . $id);
$myForm->addComment('width_' . $id, '<div align="center">' . $myForm->getText('width_' . $id, $width, 5, 3, true) . '</div>');
$campoGrilla[] = 'width_' . $id;
}
$anchoTotal = 0;
if (isset($_SESSION['temp_scaff_info']['grid_att']['ancho_total'])) {
$anchoTotal = $_SESSION['temp_scaff_info']['grid_att']['ancho_total'];
}
$myForm->addDisabled('ancho_total');
$myForm->addText(OPF_myLang::getPhrase('OPF_SCAFF_19'), 'ancho_total', $anchoTotal, 5, 4, true);
$getqueryform = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['getqueryform'])) {
$getqueryform = $_SESSION['temp_scaff_info']['grid_att']['getqueryform'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_20'), 'getqueryform', $getqueryform);
$setexportdata = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['setexportdata'])) {
$setexportdata = $_SESSION['temp_scaff_info']['grid_att']['setexportdata'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_21'), 'setexportdata', $setexportdata);
$setpagination = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['setpagination'])) {
$setpagination = $_SESSION['temp_scaff_info']['grid_att']['setpagination'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_22'), 'setpagination', $setpagination);
$setuseordermethod = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['setuseordermethod'])) {
$setuseordermethod = $_SESSION['temp_scaff_info']['grid_att']['setuseordermethod'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_23'), 'setuseordermethod', $setuseordermethod);
$editar = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['editar'])) {
$editar = $_SESSION['temp_scaff_info']['grid_att']['editar'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_24'), 'editar', $editar);
$eliminar = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['eliminar'])) {
$eliminar = $_SESSION['temp_scaff_info']['grid_att']['eliminar'];
}
if (!$eliminar) {
$myForm->addDisabled('eliminar_mul');
}
$myForm->addEvent('eliminar', 'onclick', 'valOptDelete');
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_25'), 'eliminar', $eliminar);
$eliminar_mul = false;
if (isset($_SESSION['temp_scaff_info']['grid_att']['eliminar_mul'])) {
$eliminar_mul = $_SESSION['temp_scaff_info']['grid_att']['eliminar_mul'];
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_SCAFF_26'), 'eliminar_mul', $eliminar_mul);
$myForm->addGroup('opcvarias', OPF_myLang::getPhrase('OPF_SCAFF_27'), array('ancho_total', 'getqueryform', 'setexportdata', 'setpagination', 'setuseordermethod', 'editar', 'eliminar', 'eliminar_mul'));
$myForm->addGroup('campos', OPF_myLang::getPhrase('OPF_SCAFF_28'), $campoGrilla, 3);
$myForm->addButton('btn0', OPF_myLang::getPhrase('OPF_SCAFF_13'), 'back.gif');
$myForm->addEvent('btn0', 'onclick', 'newScaff', 3);
$myForm->addComment('cm_space', '');
$myForm->addButton('btn1', OPF_myLang::getPhrase('OPF_SCAFF_14'), 'next.gif');
$myForm->addEvent('btn1', 'onclick', 'toScaffStep5');
return $myForm->getForm(3);
}
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);
}