public function getFormAddModRecord($id = '')
{
$ess_menu = new ess_menu();
if ($id) {
$ess_menu->find($id);
}
$arrIcons = array(array('img/imgfolder.gif', 'imgfolder', 'Image folder'), array('img/musicfolder.gif', 'musicfolder', 'Music folder'), array('img/page.gif', 'page', 'Page'), array('img/cd.gif', 'cd', 'Cd'), array('img/base.gif', 'osezno', 'Osezno PHP Framefork logo'), array('img/globe.gif', 'globe', 'Globe'), array('img/question.gif', 'question', 'Question'), array('img/trash.gif', 'trash', 'Trash'));
$myForm = new OPF_myForm('FormAddModRecord');
$htmlInconsel = '<select name="icon" id="icon" class="' . $myForm->styleClassFields . '">';
$htmlInconsel .= '<option>' . OPF_myLang::getPhrase('LABEL_FIRST_OPT_SELECT_FIELD') . '</option>';
foreach ($arrIcons as $icon) {
$sel = '';
if ($ess_menu->icon == $icon[0] && $ess_menu->icon) {
$sel = 'selected';
}
$htmlInconsel .= '<option ' . $sel . ' value="' . $icon[0] . '" id="' . $icon[1] . '">' . $icon[2] . '</option>';
}
$htmlInconsel .= '</select>';
$myForm->styleClassForm = '';
$myForm->addText(OPF_myLang::getPhrase('OPF_MENU_4'), 'description:2', $ess_menu->description, 15, 50);
$myForm->selectStringFirstLabelOption = '/';
$myForm->addSelect(OPF_myLang::getPhrase('OPF_MENU_5'), 'menu_id:2', $this->arrOpt, $ess_menu->menu_id);
$myForm->addText(OPF_myLang::getPhrase('OPF_MENU_6'), 'ord:2', $ess_menu->ord, 2, 3, true);
$myForm->addFreeObject('fo1:2', 'Icono:', $htmlInconsel);
$myForm->addTextArea(OPF_myLang::getPhrase('OPF_MENU_7'), 'url:2', $ess_menu->url, 50, 2);
$myForm->addButton('btn_dir', OPF_myLang::getPhrase('OPF_MENU_8'), 'find.gif');
$myForm->addButton('btn_save', OPF_myLang::getPhrase('LABEL_BTN_SAVE'), 'save.gif');
$myForm->addEvent('btn_save', 'onclick', 'onClickSave', $id);
$myForm->addEvent('btn_dir', 'onclick', 'onClickFindMod');
return $myForm->getForm(2);
}
private function walkItems($numSpaces)
{
$ess_menu = new ess_menu();
$ess_menu->setAutoQuotesInFind(false);
foreach ($ess_menu->query('SELECT * FROM ess_menu WHERE menu_id is NULL order by ord ASC') as $menuOpt) {
$this->arrItems[] = $numSpaces . ':' . $menuOpt->id . ':' . $menuOpt->description;
$this->recurWalkItems($ess_menu, $menuOpt->id, $numSpaces + 1);
}
}
public function isOwnerOnMod($menu_id)
{
$ess_profiles_detail = new ess_profiles_detail();
// Mejorar para encontar una similitud con el script
$ess_profiles_detail->find('menu_id = ' . $menu_id . ' & profiles_id = ' . $_SESSION['profile_id']);
$ess_menu = new ess_menu();
$ess_menu->find($menu_id);
$this->strModName = $ess_menu->description;
return $ess_profiles_detail->getNumRowsAffected();
}
private function walkItems()
{
$this->objESS = new ESS_essentials();
$ess_menu = new ess_menu();
$ess_menu->setAutoQuotesInFind(false);
$sql = 'SELECT ess_menu.id, ess_menu.description, ess_menu.url, ess_menu.icon, ess_menu.description FROM ess_menu INNER JOIN ess_profiles_detail ON (ess_profiles_detail.menu_id = ess_menu.id AND ess_profiles_detail.profiles_id = ' . $_SESSION['profile_id'] . ') WHERE ess_menu.menu_id is NULL ORDER BY ess_menu.ord ASC';
foreach ($ess_menu->query($sql) as $menuOpt) {
$url = '';
$icon = '';
if ($menuOpt->url) {
if (stripos($menuOpt->url, '?')) {
$url = $menuOpt->url . '&secure_opf_code=' . $this->objESS->crypNumbers($menuOpt->id);
} else {
$url = $menuOpt->url . '?secure_opf_code=' . $this->objESS->crypNumbers($menuOpt->id);
}
$icon = BASE_URL_PATH . 'common/js/essentials/' . $menuOpt->icon;
}
$this->js .= "d.add(" . $menuOpt->id . ",0,'" . $menuOpt->description . "','" . $url . "','" . $menuOpt->description . "','modulo','" . $icon . "');\n";
$this->recurWalkItems($ess_menu, $menuOpt->id);
}
}
public function onClickSave($datForm, $id = '')
{
$requiredFields = array('description', 'ord');
if ($this->MYFORM_validate($datForm, $requiredFields)) {
$error = false;
$ess_menu = new ess_menu();
if ($id) {
$ess_menu->find($id);
}
$ess_menu->description = $datForm['description'];
if ($datForm['menu_id']) {
$ess_menu->menu_id = $datForm['menu_id'];
}
$ess_menu->ord = $datForm['ord'];
$ess_menu->url = $datForm['url'];
$ess_menu->icon = $datForm['icon'];
$ess_menu->usuario_id = $_SESSION['user_id'];
$ess_menu->datetime = date("Y-m-d H:i:s");
if ($id == $datForm['menu_id'] && $id) {
$error = true;
}
if (!$error) {
if ($ess_menu->save()) {
$this->notificationWindow(OPF_myLang::getPhrase('MSG_CAMBIOS_GUARDADOS'), 3, 'ok');
$this->closeModalWindow();
$this->MYLIST_reload('lst_menu');
} else {
$this->messageBox($ess_menu->getSqlLog() . $ess_menu->getErrorLog(), 'error');
}
} else {
$this->messageBox(OPF_myLang::getPhrase('OPF_MENU_3'), 'error');
}
} else {
$this->notificationWindow(OPF_myLang::getPhrase('MSG_CAMPOS_REQUERIDOS'), 3, 'error');
}
return $this->response;
}
