public function getFormAgrUsr($user_id = '')
{
$ess_profiles = new ess_profiles();
$profilesArray = array();
foreach ($ess_profiles->find() as $profile) {
$profilesArray[$profile->id] = $profile->name;
}
$ess_system_users = new ess_system_users();
$myForm = new OPF_myForm('getFormAgrUsr');
if ($user_id) {
$ess_system_users->find($user_id);
$myForm->addDisabled('user_name');
}
$myForm->styleClassForm = '';
$myForm->addText(OPF_myLang::getPhrase('OPF_ADMUSR_1'), 'user_name', $ess_system_users->user_name, 15);
$myForm->addText(OPF_myLang::getPhrase('OPF_ADMUSR_2'), 'name', $ess_system_users->name, 15);
$myForm->addText(OPF_myLang::getPhrase('OPF_ADMUSR_3'), 'lastname', $ess_system_users->lastname, 15);
$myForm->addPassword(OPF_myLang::getPhrase('OPF_ADMUSR_4'), 'passwd1', $ess_system_users->passwd, 15);
$myForm->addPassword(OPF_myLang::getPhrase('OPF_ADMUSR_5'), 'passwd', $ess_system_users->passwd, 15);
$myForm->addSelect(OPF_myLang::getPhrase('OPF_ADMUSR_6'), 'profile_id', $profilesArray, $ess_system_users->profile_id);
$status = false;
if ($ess_system_users->status == 1) {
$status = true;
}
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_ADMUSR_7'), 'status', $status);
$myForm->addButton('btnsave', OPF_myLang::getPhrase('LABEL_BTN_SAVE'), 'save.gif');
$myForm->addEvent('btnsave', 'onclick', 'onClickSaveRecord', $user_id);
return $myForm->getForm(1);
}
public function getFormSetProfile($profile_id)
{
$ess_profiles_detail = new ess_profiles_detail();
$itemOnProfile = array();
foreach ($ess_profiles_detail->find('profiles_id = ' . $profile_id) as $row) {
$itemOnProfile[$row->menu_id] = $row->id;
}
$this->walkItems(0);
$myForm = new OPF_myForm('FormSetProfile');
$myForm->styleClassForm = '';
$myForm->useRowSeparator = true;
foreach ($this->arrItems as $opt) {
list($numSpaces, $id, $desc) = explode(':', $opt);
for ($i = 0; $i < $numSpaces; ++$i) {
$add = ' ';
if ($i == $numSpaces - 1) {
$add = '->';
}
$myForm->addFreeObject('cm1_' . $i . '_' . $id, '', $add);
$this->groups[] = 'cm1_' . $i . '_' . $id;
}
$sts = false;
if (isset($itemOnProfile[$id])) {
$sts = true;
}
$myForm->addCheckBox($desc, 'chk_' . $id, $sts);
$this->groups[] = 'chk_' . $id;
for ($j = $numSpaces + 1; $j < $this->maxCols + 1; ++$j) {
$myForm->addComment('cm2_' . $j . '_' . $id, ' ');
$this->groups[] = 'cm2_' . $j . '_' . $id;
}
}
$myForm->addButton('btn_save_', OPF_myLang::getPhrase('LABEL_BTN_SAVE'), 'save.gif');
$myForm->addButton('btn_cancel_', OPF_myLang::getPhrase('LABEL_BTN_CANCEL'), 'cancel.gif');
$myForm->addEvent('btn_cancel_', 'onclick', 'onClickCancelConfirm');
$myForm->addEvent('btn_save_', 'onclick', 'onClickSaveProfileDet', $profile_id);
$myForm->border = 0;
$myForm->width = ($this->maxCols + 1) * 180;
$myForm->addGroup('resources', OPF_myLang::getPhrase('OPF_PROFILES_4'), $this->groups, $this->maxCols + 1);
return $myForm->getForm(2);
}
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);
}
/**
* Cuarda el resultado de la consulta de una lista dinamica segun el filtro aplicado al disco
* @ignore
* @param $datForm Datos de form
* @param $format Formato
* @param $idList Id lista
*/
public function MYLIST_exportData($datForm, $format, $idList)
{
$arrFields = array();
$arrSelects = array();
$this->notificationWindow(MSG_SELECT_FIELD_TO_SHOW, 8, 'ok');
$myForm = new OPF_myForm('export_data_select_fields_' . $idList);
$myForm->selectUseFirstValue = false;
$myList = new OPF_myList($idList);
$arFldOnQry = $myList->getVar('arrayFieldsOnQuery');
$arEvnOnQry = $myList->getVar('arrayEventOnColumn');
$nomImg = '';
switch ($format) {
case 'xls':
$nomImg = 'excel';
break;
case 'pdf':
$nomImg = 'pdf';
break;
case 'html':
$nomImg = 'html';
break;
}
$i = 1;
foreach ($arFldOnQry as $field) {
if (!isset($arEvnOnQry[$field])) {
$arrFields['field_' . $i] = $field;
$arrSelects[] = 'field_' . $i;
}
++$i;
}
$myForm->border = 0;
$myForm->styleTypeHelp = 2;
$myForm->styleClassFields = 'select_fields_to_show';
$myForm->addHelp('fields_export', LABEL_HELP_SELECT_FILEDS_TOSHOW);
$myForm->addComment('cm1:2', '<div align="center">' . $myForm->getSelect('fields_export', $arrFields, $arrSelects, 8, 0, true) . '</center>');
$myForm->styleClassFields = 'caja';
$myForm->addHelp('not_pg_' . $idList, LABEL_HELP_USELIMIT_RULE_FORM);
$myForm->addCheckBox(LABEL_USELIMIT_RULE_FORM . ':', 'not_pg_' . $idList, true);
$myForm->addButton('button_export_data', LABEL_BUTTON_DOWNLOAD_FILE_EXPORT, $nomImg . '.gif');
$myForm->addEvent('button_export_data', 'onclick', 'MYLIST_exportDataOk', $format, $idList, $i);
$this->modalWindow($myForm->getForm(2), TITLE_MWINDOW_FILEDS_TO_SHOW, 220, 222, 2);
return $this->response;
}
public function getFormLogin()
{
$myForm = new OPF_myForm('frm_login');
$myForm->setAutoComplete('user_opf_ess', false);
$user_opf_ess = '';
$mark = false;
if (isset($_COOKIE['user_opf_ess'])) {
$user_opf_ess = $_COOKIE['user_opf_ess'];
$mark = true;
}
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_2'), 'user_opf_ess', $user_opf_ess);
$myForm->addPassword(OPF_myLang::getPhrase('OPF_LOGIN_3'), 'passwd_opf_ess');
$myForm->addCheckBox(OPF_myLang::getPhrase('OPF_LOGIN_5'), 'rem_usr', $mark);
$myForm->addButton('btn_log', OPF_myLang::getPhrase('OPF_LOGIN_4'), 'ok.gif');
$myForm->addEvent('btn_log', 'onclick', 'onClickLogIn');
return $myForm->getForm(1);
}
