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);
}
public function getFormInstall($type, $datForm = '', $disabled = false)
{
$myForm = new OPF_myForm('install_essentials');
$arEngine = array('mysql' => 'MySQL', 'pgsql' => 'PostgreSQL');
$myForm->setParamTypeOnEvent('field');
$myForm->addEvent('engine', 'onchange', 'onChangeEngine');
$myForm->setParamTypeOnEvent('global');
$engine = '';
if (isset($datForm['engine'])) {
$engine = $datForm['engine'];
}
if ($disabled) {
$myForm->addDisabled('engine');
}
$myForm->addSelect(OPF_myLang::getPhrase('OPF_LOGIN_8'), 'engine', $arEngine, $engine);
$db = '';
if (isset($datForm['db'])) {
$db = $datForm['db'];
}
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_12'), 'db', $db);
$encoding = 'UTF8';
if (isset($datForm['encoding'])) {
$encoding = $datForm['encoding'];
}
$myForm->addDisabled('encoding');
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_12A'), 'encoding', $encoding);
$user_db = '';
if (isset($datForm['user_db'])) {
$user_db = $datForm['user_db'];
}
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_9'), 'user_db', $user_db);
$passwd_db = '';
if (isset($datForm['passwd_db'])) {
$passwd_db = $datForm['passwd_db'];
}
$myForm->addPassword(OPF_myLang::getPhrase('OPF_LOGIN_10'), 'passwd_db', $passwd_db);
$host_db = '';
if (isset($datForm['host_db'])) {
$host_db = $datForm['host_db'];
}
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_11'), 'host_db', $host_db);
$host_port = '';
if (isset($datForm['host_port'])) {
$host_port = $datForm['host_port'];
}
$myForm->addText(OPF_myLang::getPhrase('OPF_LOGIN_13'), 'host_port', $host_port, NULL, 5, true);
if ($type == 'tables') {
$str = OPF_myLang::getPhrase('OPF_LOGIN_30');
$myForm->addButton('btn_install', OPF_myLang::getPhrase('OPF_LOGIN_14'), 'list.gif');
$myForm->addEvent('btn_install', 'onclick', 'onClickInstall');
} else {
$str = OPF_myLang::getPhrase('OPF_LOGIN_29');
if ($disabled) {
$myForm->addDisabled('btn_install');
}
$myForm->addButton('btn_install', OPF_myLang::getPhrase('OPF_LOGIN_17'), 'add.gif');
$myForm->addEvent('btn_install', 'onclick', 'onClickCreateBD');
}
$myForm->addGroup('grp1', $str, array('engine', 'db', 'encoding', 'user_db', 'passwd_db', 'host_db', 'host_port'), 1);
return $myForm->getForm(1);
}
