@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | // Находим все страницы данной инструкции |
| 87 | 87 | $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
| 88 | 88 | // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
| 89 | - if (!$this->isNew()) { |
|
| 89 | + if ( ! $this->isNew()) { |
|
| 90 | 90 | $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
| 91 | 91 | } |
| 92 | 92 | $criteria->setSort('weight'); |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | $form->addElement($option_tray); |
| 152 | 152 | |
| 153 | 153 | // Если мы редактируем страницу |
| 154 | - if (!$this->isNew()) { |
|
| 154 | + if ( ! $this->isNew()) { |
|
| 155 | 155 | $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
| 156 | 156 | } else { |
| 157 | 157 | $form->addElement(new \XoopsFormHidden('pageid', 0)); |
@@ -12,172 +12,172 @@ |
||
| 12 | 12 | */ |
| 13 | 13 | class Page extends \XoopsObject |
| 14 | 14 | { |
| 15 | - // constructor |
|
| 16 | - public function __construct() |
|
| 17 | - { |
|
| 18 | - // $this->XoopsObject(); |
|
| 19 | - $this->initVar('pageid', XOBJ_DTYPE_INT, null, false, 11); |
|
| 20 | - $this->initVar('pid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 21 | - $this->initVar('instrid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 22 | - $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 23 | - $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 24 | - $this->initVar('status', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 25 | - $this->initVar('type', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 26 | - $this->initVar('hometext', XOBJ_DTYPE_TXTAREA, null, false); |
|
| 27 | - $this->initVar('footnote', XOBJ_DTYPE_TXTAREA, '', false); |
|
| 28 | - $this->initVar('weight', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 29 | - $this->initVar('keywords', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 30 | - $this->initVar('description', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 31 | - $this->initVar('comments', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 32 | - $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 33 | - $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 34 | - $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 35 | - $this->initVar('dosmiley', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 36 | - $this->initVar('doxcode', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 37 | - $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 38 | - } |
|
| 39 | - |
|
| 40 | - /** |
|
| 41 | - * @return mixed |
|
| 42 | - */ |
|
| 43 | - public function getNewInstertId() |
|
| 44 | - { |
|
| 45 | - $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
| 46 | - return $newEnreg; |
|
| 47 | - } |
|
| 48 | - |
|
| 49 | - // Получаем форму |
|
| 50 | - |
|
| 51 | - /** |
|
| 52 | - * @param bool|null|string $action |
|
| 53 | - * @param int $instrid |
|
| 54 | - * @return \XoopsThemeForm |
|
| 55 | - */ |
|
| 56 | - public function getForm($action = false, $instrid = 0) |
|
| 57 | - { |
|
| 58 | - // Если нет $action |
|
| 59 | - if (false === $action) { |
|
| 60 | - $action = xoops_getenv('REQUEST_URI'); |
|
| 61 | - } |
|
| 62 | - |
|
| 63 | - // Подключаем формы |
|
| 64 | - include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
| 65 | - // Подключаем типы страниц |
|
| 66 | - $pagetypes = include $GLOBALS['xoops']->path('modules/instruction/include/pagetypes.inc.php'); |
|
| 67 | - |
|
| 68 | - // Название формы |
|
| 69 | - $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDPAGE) : sprintf(_AM_INSTRUCTION_FORMEDITPAGE); |
|
| 70 | - |
|
| 71 | - // Форма |
|
| 72 | - $form = new \XoopsThemeForm($title, 'instr_form_page', $action, 'post', true); |
|
| 73 | - // Название |
|
| 74 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
| 75 | - |
|
| 76 | - // Родительская страница |
|
| 77 | - // $pageHandler = xoops_getModuleHandler('page', 'instruction'); |
|
| 78 | - $criteria = new \CriteriaCompo(); |
|
| 79 | - // ID инструкции в которой данная страница |
|
| 80 | - $instrid_page = $this->isNew() ? $instrid : $this->getVar('instrid'); |
|
| 81 | - // Находим все страницы данной инструкции |
|
| 82 | - $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
|
| 83 | - // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
|
| 84 | - if (!$this->isNew()) { |
|
| 85 | - $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
|
| 86 | - } |
|
| 87 | - $criteria->setSort('weight'); |
|
| 88 | - $criteria->setOrder('ASC'); |
|
| 89 | - $inspage_arr = $pageHandler->getall($criteria); |
|
| 90 | - unset($criteria); |
|
| 91 | - // Подключаем трей |
|
| 92 | - include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
| 93 | - $mytree = new \XoopsObjectTree($inspage_arr, 'pageid', 'pid'); |
|
| 94 | - |
|
| 95 | - // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
| 96 | - $helper = Helper::getInstance(); |
|
| 97 | - $module = $helper->getModule(); |
|
| 98 | - |
|
| 99 | - if (Utility::checkVerXoops($module, '2.5.9')) { |
|
| 100 | - $mytree_select = $mytree->makeSelectElement('pid', 'title', '--', $this->getVar('pid'), true, 0, '', _AM_INSTRUCTION_PPAGEC); |
|
| 101 | - $form->addElement($mytree_select); |
|
| 102 | - } else { |
|
| 103 | - $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
| 104 | - } |
|
| 105 | - |
|
| 106 | - // Вес |
|
| 107 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_WEIGHTC, 'weight', 5, 5, $this->getVar('weight')), true); |
|
| 108 | - // Основной текст |
|
| 109 | - $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_HOMETEXTC, 'hometext', $this->getVar('hometext', 'e')), true); |
|
| 110 | - // Сноска |
|
| 111 | - $form_footnote = new \XoopsFormTextArea(_AM_INSTRUCTION_FOOTNOTEC, 'footnote', $this->getVar('footnote', 'e')); |
|
| 112 | - $form_footnote->setDescription(_AM_INSTRUCTION_FOOTNOTE_DSC); |
|
| 113 | - $form->addElement($form_footnote, false); |
|
| 114 | - unset($form_footnote); |
|
| 115 | - // Статус |
|
| 116 | - $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
| 117 | - // Тип страницы |
|
| 118 | - $form_type = new \XoopsFormSelect(_AM_INSTR_PAGETYPEC, 'type', $this->getVar('type')); |
|
| 119 | - $form_type->setDescription(_AM_INSTR_PAGETYPEC_DESC); |
|
| 120 | - $form_type->addOptionArray($pagetypes); |
|
| 121 | - $form->addElement($form_type, false); |
|
| 122 | - // Мета-теги ключевых слов |
|
| 123 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'keywords', 50, 255, $this->getVar('keywords')), false); |
|
| 124 | - // Мета-теги описания |
|
| 125 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'description', 50, 255, $this->getVar('description')), false); |
|
| 126 | - |
|
| 127 | - // Настройки |
|
| 128 | - $option_tray = new \XoopsFormElementTray(_OPTIONS, '<br>'); |
|
| 129 | - // HTML |
|
| 130 | - $html_checkbox = new \XoopsFormCheckBox('', 'dohtml', $this->getVar('dohtml')); |
|
| 131 | - $html_checkbox->addOption(1, _AM_INSTR_DOHTML); |
|
| 132 | - $option_tray->addElement($html_checkbox); |
|
| 133 | - // Смайлы |
|
| 134 | - $smiley_checkbox = new \XoopsFormCheckBox('', 'dosmiley', $this->getVar('dosmiley')); |
|
| 135 | - $smiley_checkbox->addOption(1, _AM_INSTR_DOSMILEY); |
|
| 136 | - $option_tray->addElement($smiley_checkbox); |
|
| 137 | - // ББ коды |
|
| 138 | - $xcode_checkbox = new \XoopsFormCheckBox('', 'doxcode', $this->getVar('doxcode')); |
|
| 139 | - $xcode_checkbox->addOption(1, _AM_INSTR_DOXCODE); |
|
| 140 | - $option_tray->addElement($xcode_checkbox); |
|
| 141 | - // |
|
| 142 | - $br_checkbox = new \XoopsFormCheckBox('', 'dobr', $this->getVar('dobr')); |
|
| 143 | - $br_checkbox->addOption(1, _AM_INSTR_DOAUTOWRAP); |
|
| 144 | - $option_tray->addElement($br_checkbox); |
|
| 145 | - // |
|
| 146 | - $form->addElement($option_tray); |
|
| 147 | - |
|
| 148 | - // Если мы редактируем страницу |
|
| 149 | - if (!$this->isNew()) { |
|
| 150 | - $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
|
| 151 | - } else { |
|
| 152 | - $form->addElement(new \XoopsFormHidden('pageid', 0)); |
|
| 153 | - } |
|
| 154 | - // ID инструкции |
|
| 155 | - if ($instrid) { |
|
| 156 | - $form->addElement(new \XoopsFormHidden('instrid', $instrid)); |
|
| 157 | - } else { |
|
| 158 | - $form->addElement(new \XoopsFormHidden('instrid', 0)); |
|
| 159 | - } |
|
| 160 | - // |
|
| 161 | - $form->addElement(new \XoopsFormHidden('op', 'savepage')); |
|
| 162 | - // Кнопка |
|
| 163 | - $button_tray = new \XoopsFormElementTray('', ''); |
|
| 164 | - $button_tray->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
| 165 | - $save_btn = new \XoopsFormButton('', 'cancel', _AM_INSTR_SAVEFORM); |
|
| 166 | - $save_btn->setExtra('onclick="instrSavePage();"'); |
|
| 167 | - $button_tray->addElement($save_btn); |
|
| 168 | - $form->addElement($button_tray); |
|
| 169 | - |
|
| 170 | - return $form; |
|
| 171 | - } |
|
| 172 | - |
|
| 173 | - // |
|
| 174 | - |
|
| 175 | - /** |
|
| 176 | - * @return mixed |
|
| 177 | - */ |
|
| 178 | - public function getInstrid() |
|
| 179 | - { |
|
| 180 | - // Возвращаем ID инструкции |
|
| 181 | - return $this->getVar('instrid'); |
|
| 182 | - } |
|
| 15 | + // constructor |
|
| 16 | + public function __construct() |
|
| 17 | + { |
|
| 18 | + // $this->XoopsObject(); |
|
| 19 | + $this->initVar('pageid', XOBJ_DTYPE_INT, null, false, 11); |
|
| 20 | + $this->initVar('pid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 21 | + $this->initVar('instrid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 22 | + $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 23 | + $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 24 | + $this->initVar('status', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 25 | + $this->initVar('type', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 26 | + $this->initVar('hometext', XOBJ_DTYPE_TXTAREA, null, false); |
|
| 27 | + $this->initVar('footnote', XOBJ_DTYPE_TXTAREA, '', false); |
|
| 28 | + $this->initVar('weight', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 29 | + $this->initVar('keywords', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 30 | + $this->initVar('description', XOBJ_DTYPE_TXTBOX, '', false, 255); |
|
| 31 | + $this->initVar('comments', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 32 | + $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 33 | + $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 34 | + $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 35 | + $this->initVar('dosmiley', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 36 | + $this->initVar('doxcode', XOBJ_DTYPE_INT, 1, false, 1); |
|
| 37 | + $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 38 | + } |
|
| 39 | + |
|
| 40 | + /** |
|
| 41 | + * @return mixed |
|
| 42 | + */ |
|
| 43 | + public function getNewInstertId() |
|
| 44 | + { |
|
| 45 | + $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
| 46 | + return $newEnreg; |
|
| 47 | + } |
|
| 48 | + |
|
| 49 | + // Получаем форму |
|
| 50 | + |
|
| 51 | + /** |
|
| 52 | + * @param bool|null|string $action |
|
| 53 | + * @param int $instrid |
|
| 54 | + * @return \XoopsThemeForm |
|
| 55 | + */ |
|
| 56 | + public function getForm($action = false, $instrid = 0) |
|
| 57 | + { |
|
| 58 | + // Если нет $action |
|
| 59 | + if (false === $action) { |
|
| 60 | + $action = xoops_getenv('REQUEST_URI'); |
|
| 61 | + } |
|
| 62 | + |
|
| 63 | + // Подключаем формы |
|
| 64 | + include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
| 65 | + // Подключаем типы страниц |
|
| 66 | + $pagetypes = include $GLOBALS['xoops']->path('modules/instruction/include/pagetypes.inc.php'); |
|
| 67 | + |
|
| 68 | + // Название формы |
|
| 69 | + $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDPAGE) : sprintf(_AM_INSTRUCTION_FORMEDITPAGE); |
|
| 70 | + |
|
| 71 | + // Форма |
|
| 72 | + $form = new \XoopsThemeForm($title, 'instr_form_page', $action, 'post', true); |
|
| 73 | + // Название |
|
| 74 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
| 75 | + |
|
| 76 | + // Родительская страница |
|
| 77 | + // $pageHandler = xoops_getModuleHandler('page', 'instruction'); |
|
| 78 | + $criteria = new \CriteriaCompo(); |
|
| 79 | + // ID инструкции в которой данная страница |
|
| 80 | + $instrid_page = $this->isNew() ? $instrid : $this->getVar('instrid'); |
|
| 81 | + // Находим все страницы данной инструкции |
|
| 82 | + $criteria->add(new \Criteria('instrid', $instrid_page, '=')); |
|
| 83 | + // Если мы редактируем, то убрать текущую страницу из списка выбора родительской |
|
| 84 | + if (!$this->isNew()) { |
|
| 85 | + $criteria->add(new \Criteria('pageid', $this->getVar('pageid'), '<>')); |
|
| 86 | + } |
|
| 87 | + $criteria->setSort('weight'); |
|
| 88 | + $criteria->setOrder('ASC'); |
|
| 89 | + $inspage_arr = $pageHandler->getall($criteria); |
|
| 90 | + unset($criteria); |
|
| 91 | + // Подключаем трей |
|
| 92 | + include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
| 93 | + $mytree = new \XoopsObjectTree($inspage_arr, 'pageid', 'pid'); |
|
| 94 | + |
|
| 95 | + // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
| 96 | + $helper = Helper::getInstance(); |
|
| 97 | + $module = $helper->getModule(); |
|
| 98 | + |
|
| 99 | + if (Utility::checkVerXoops($module, '2.5.9')) { |
|
| 100 | + $mytree_select = $mytree->makeSelectElement('pid', 'title', '--', $this->getVar('pid'), true, 0, '', _AM_INSTRUCTION_PPAGEC); |
|
| 101 | + $form->addElement($mytree_select); |
|
| 102 | + } else { |
|
| 103 | + $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_PPAGEC, $mytree->makeSelBox('pid', 'title', '--', $this->getVar('pid'), true))); |
|
| 104 | + } |
|
| 105 | + |
|
| 106 | + // Вес |
|
| 107 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_WEIGHTC, 'weight', 5, 5, $this->getVar('weight')), true); |
|
| 108 | + // Основной текст |
|
| 109 | + $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_HOMETEXTC, 'hometext', $this->getVar('hometext', 'e')), true); |
|
| 110 | + // Сноска |
|
| 111 | + $form_footnote = new \XoopsFormTextArea(_AM_INSTRUCTION_FOOTNOTEC, 'footnote', $this->getVar('footnote', 'e')); |
|
| 112 | + $form_footnote->setDescription(_AM_INSTRUCTION_FOOTNOTE_DSC); |
|
| 113 | + $form->addElement($form_footnote, false); |
|
| 114 | + unset($form_footnote); |
|
| 115 | + // Статус |
|
| 116 | + $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
| 117 | + // Тип страницы |
|
| 118 | + $form_type = new \XoopsFormSelect(_AM_INSTR_PAGETYPEC, 'type', $this->getVar('type')); |
|
| 119 | + $form_type->setDescription(_AM_INSTR_PAGETYPEC_DESC); |
|
| 120 | + $form_type->addOptionArray($pagetypes); |
|
| 121 | + $form->addElement($form_type, false); |
|
| 122 | + // Мета-теги ключевых слов |
|
| 123 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'keywords', 50, 255, $this->getVar('keywords')), false); |
|
| 124 | + // Мета-теги описания |
|
| 125 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'description', 50, 255, $this->getVar('description')), false); |
|
| 126 | + |
|
| 127 | + // Настройки |
|
| 128 | + $option_tray = new \XoopsFormElementTray(_OPTIONS, '<br>'); |
|
| 129 | + // HTML |
|
| 130 | + $html_checkbox = new \XoopsFormCheckBox('', 'dohtml', $this->getVar('dohtml')); |
|
| 131 | + $html_checkbox->addOption(1, _AM_INSTR_DOHTML); |
|
| 132 | + $option_tray->addElement($html_checkbox); |
|
| 133 | + // Смайлы |
|
| 134 | + $smiley_checkbox = new \XoopsFormCheckBox('', 'dosmiley', $this->getVar('dosmiley')); |
|
| 135 | + $smiley_checkbox->addOption(1, _AM_INSTR_DOSMILEY); |
|
| 136 | + $option_tray->addElement($smiley_checkbox); |
|
| 137 | + // ББ коды |
|
| 138 | + $xcode_checkbox = new \XoopsFormCheckBox('', 'doxcode', $this->getVar('doxcode')); |
|
| 139 | + $xcode_checkbox->addOption(1, _AM_INSTR_DOXCODE); |
|
| 140 | + $option_tray->addElement($xcode_checkbox); |
|
| 141 | + // |
|
| 142 | + $br_checkbox = new \XoopsFormCheckBox('', 'dobr', $this->getVar('dobr')); |
|
| 143 | + $br_checkbox->addOption(1, _AM_INSTR_DOAUTOWRAP); |
|
| 144 | + $option_tray->addElement($br_checkbox); |
|
| 145 | + // |
|
| 146 | + $form->addElement($option_tray); |
|
| 147 | + |
|
| 148 | + // Если мы редактируем страницу |
|
| 149 | + if (!$this->isNew()) { |
|
| 150 | + $form->addElement(new \XoopsFormHidden('pageid', $this->getVar('pageid'))); |
|
| 151 | + } else { |
|
| 152 | + $form->addElement(new \XoopsFormHidden('pageid', 0)); |
|
| 153 | + } |
|
| 154 | + // ID инструкции |
|
| 155 | + if ($instrid) { |
|
| 156 | + $form->addElement(new \XoopsFormHidden('instrid', $instrid)); |
|
| 157 | + } else { |
|
| 158 | + $form->addElement(new \XoopsFormHidden('instrid', 0)); |
|
| 159 | + } |
|
| 160 | + // |
|
| 161 | + $form->addElement(new \XoopsFormHidden('op', 'savepage')); |
|
| 162 | + // Кнопка |
|
| 163 | + $button_tray = new \XoopsFormElementTray('', ''); |
|
| 164 | + $button_tray->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
| 165 | + $save_btn = new \XoopsFormButton('', 'cancel', _AM_INSTR_SAVEFORM); |
|
| 166 | + $save_btn->setExtra('onclick="instrSavePage();"'); |
|
| 167 | + $button_tray->addElement($save_btn); |
|
| 168 | + $form->addElement($button_tray); |
|
| 169 | + |
|
| 170 | + return $form; |
|
| 171 | + } |
|
| 172 | + |
|
| 173 | + // |
|
| 174 | + |
|
| 175 | + /** |
|
| 176 | + * @return mixed |
|
| 177 | + */ |
|
| 178 | + public function getInstrid() |
|
| 179 | + { |
|
| 180 | + // Возвращаем ID инструкции |
|
| 181 | + return $this->getVar('instrid'); |
|
| 182 | + } |
|
| 183 | 183 | } |
@@ -16,28 +16,28 @@ |
||
| 16 | 16 | */ |
| 17 | 17 | class CategoryHandler extends \XoopsPersistableObjectHandler |
| 18 | 18 | { |
| 19 | - /** |
|
| 20 | - * @param null|mixed $db |
|
| 21 | - */ |
|
| 22 | - public function __construct(\XoopsDatabase $db = null) |
|
| 23 | - { |
|
| 24 | - parent::__construct($db, 'instruction_cat', Category::class, 'cid', 'title'); |
|
| 25 | - } |
|
| 19 | + /** |
|
| 20 | + * @param null|mixed $db |
|
| 21 | + */ |
|
| 22 | + public function __construct(\XoopsDatabase $db = null) |
|
| 23 | + { |
|
| 24 | + parent::__construct($db, 'instruction_cat', Category::class, 'cid', 'title'); |
|
| 25 | + } |
|
| 26 | 26 | |
| 27 | - // Обновление даты обновления категории |
|
| 27 | + // Обновление даты обновления категории |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * @param int $cid |
|
| 31 | - * @param null|int $time |
|
| 32 | - * @return mixed |
|
| 33 | - */ |
|
| 34 | - public function updateDateupdated($cid = 0, $time = null) |
|
| 35 | - { |
|
| 36 | - // Если не передали время |
|
| 37 | - $time = null === $time ? time() : (int)$time; |
|
| 38 | - // |
|
| 39 | - $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
| 40 | - // |
|
| 41 | - return $this->db->query($sql); |
|
| 42 | - } |
|
| 29 | + /** |
|
| 30 | + * @param int $cid |
|
| 31 | + * @param null|int $time |
|
| 32 | + * @return mixed |
|
| 33 | + */ |
|
| 34 | + public function updateDateupdated($cid = 0, $time = null) |
|
| 35 | + { |
|
| 36 | + // Если не передали время |
|
| 37 | + $time = null === $time ? time() : (int)$time; |
|
| 38 | + // |
|
| 39 | + $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
| 40 | + // |
|
| 41 | + return $this->db->query($sql); |
|
| 42 | + } |
|
| 43 | 43 | } |
@@ -34,9 +34,9 @@ |
||
| 34 | 34 | public function updateDateupdated($cid = 0, $time = null) |
| 35 | 35 | { |
| 36 | 36 | // Если не передали время |
| 37 | - $time = null === $time ? time() : (int)$time; |
|
| 37 | + $time = null === $time ? time() : (int) $time; |
|
| 38 | 38 | // |
| 39 | - $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int)$cid); |
|
| 39 | + $sql = sprintf('UPDATE `%s` SET `dateupdated` = %u WHERE `cid` = %u', $this->table, $time, (int) $cid); |
|
| 40 | 40 | // |
| 41 | 41 | return $this->db->query($sql); |
| 42 | 42 | } |
@@ -118,7 +118,7 @@ |
||
| 118 | 118 | $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
| 119 | 119 | |
| 120 | 120 | // Если мы редактируем категорию |
| 121 | - if (!$this->isNew()) { |
|
| 121 | + if ( ! $this->isNew()) { |
|
| 122 | 122 | $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
| 123 | 123 | } |
| 124 | 124 | // |
@@ -12,115 +12,115 @@ |
||
| 12 | 12 | */ |
| 13 | 13 | class Instruction extends \XoopsObject |
| 14 | 14 | { |
| 15 | - // constructor |
|
| 16 | - public function __construct() |
|
| 17 | - { |
|
| 18 | - // $this->XoopsObject(); |
|
| 19 | - $this->initVar('instrid', XOBJ_DTYPE_INT, null, false, 11); |
|
| 20 | - $this->initVar('cid', XOBJ_DTYPE_INT, 0, false, 5); |
|
| 21 | - $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 22 | - $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 23 | - $this->initVar('status', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 24 | - $this->initVar('pages', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 25 | - $this->initVar('description', XOBJ_DTYPE_TXTAREA, null, false); |
|
| 26 | - $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 27 | - $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 28 | - $this->initVar('metakeywords', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 29 | - $this->initVar('metadescription', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 30 | - |
|
| 31 | - // Нет в таблице |
|
| 32 | - $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false); |
|
| 33 | - $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false); |
|
| 34 | - } |
|
| 35 | - |
|
| 36 | - /** |
|
| 37 | - * @return mixed |
|
| 38 | - */ |
|
| 39 | - public function getNewInstertId() |
|
| 40 | - { |
|
| 41 | - $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
| 42 | - return $newEnreg; |
|
| 43 | - } |
|
| 44 | - |
|
| 45 | - // Получаем форму |
|
| 46 | - |
|
| 47 | - /** |
|
| 48 | - * @param bool|null|string $action |
|
| 49 | - * @return \XoopsThemeForm |
|
| 50 | - */ |
|
| 51 | - public function getForm($action = false) |
|
| 52 | - { |
|
| 53 | - global $xoopsDB, $xoopsModule, $xoopsModuleConfig; |
|
| 54 | - // Если нет $action |
|
| 55 | - if (false === $action) { |
|
| 56 | - $action = xoops_getenv('REQUEST_URI'); |
|
| 57 | - } |
|
| 58 | - // Подключаем формы |
|
| 59 | - include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
| 60 | - |
|
| 61 | - // Название формы |
|
| 62 | - $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDINSTR) : sprintf(_AM_INSTRUCTION_FORMEDITINSTR); |
|
| 63 | - |
|
| 64 | - // Форма |
|
| 65 | - $form = new \XoopsThemeForm($title, 'forminstr', $action, 'post', true); |
|
| 66 | - //$form->setExtra('enctype="multipart/form-data"'); |
|
| 67 | - // Название инструкции |
|
| 68 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
| 69 | - // Категория |
|
| 70 | - $categoryHandler = new CategoryHandler; |
|
| 71 | - $criteria = new \CriteriaCompo(); |
|
| 72 | - $criteria->setSort('weight ASC, title'); |
|
| 73 | - $criteria->setOrder('ASC'); |
|
| 74 | - $instructioncat_arr = $categoryHandler->getall($criteria); |
|
| 75 | - unset($criteria); |
|
| 76 | - // Подключаем трей |
|
| 77 | - include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
| 78 | - $mytree = new \XoopsObjectTree($instructioncat_arr, 'cid', 'pid'); |
|
| 79 | - |
|
| 80 | - // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
| 81 | - $helper = Helper::getInstance(); |
|
| 82 | - $module = $helper->getModule(); |
|
| 83 | - |
|
| 84 | - if (Utility::checkVerXoops($module, '2.5.9')) { |
|
| 85 | - $mytree_select = $mytree->makeSelectElement('cid', 'title', '--', $this->getVar('cid'), true, 0, '', _AM_INSTRUCTION_CATC); |
|
| 86 | - $form->addElement($mytree_select); |
|
| 87 | - } else { |
|
| 88 | - $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
| 89 | - } |
|
| 90 | - |
|
| 91 | - // Описание |
|
| 92 | - $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_DESCRIPTIONC, 'description', $this->getVar('description', 'e')), true); |
|
| 93 | - // Статус |
|
| 94 | - $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
| 95 | - |
|
| 96 | - // Теги |
|
| 97 | - $dir_tag_ok = false; |
|
| 98 | - if (is_dir('../../tag') || is_dir('../tag')) { |
|
| 99 | - $dir_tag_ok = true; |
|
| 100 | - } |
|
| 101 | - // Если влючена поддержка тегов и есть модуль tag |
|
| 102 | - if (xoops_getModuleOption('usetag', 'instruction') && $dir_tag_ok) { |
|
| 103 | - $itemIdForTag = $this->isNew() ? 0 : $this->getVar('instrid'); |
|
| 104 | - // Подключаем форму тегов |
|
| 105 | - include_once $GLOBALS['xoops']->path('modules/tag/include/formtag.php'); |
|
| 106 | - // Добавляем элемент в форму |
|
| 107 | - $form->addElement(new \XoopsFormTag('tag', 60, 255, $itemIdForTag, 0)); |
|
| 108 | - } |
|
| 109 | - |
|
| 110 | - // Мета-теги ключевых слов |
|
| 111 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'metakeywords', 50, 255, $this->getVar('metakeywords')), false); |
|
| 112 | - // Мета-теги описания |
|
| 113 | - $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
|
| 114 | - |
|
| 115 | - // Если мы редактируем категорию |
|
| 116 | - if (!$this->isNew()) { |
|
| 117 | - $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
|
| 118 | - } |
|
| 119 | - // |
|
| 120 | - $form->addElement(new \XoopsFormHidden('op', 'saveinstr')); |
|
| 121 | - // Кнопка |
|
| 122 | - $form->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
| 123 | - return $form; |
|
| 124 | - } |
|
| 15 | + // constructor |
|
| 16 | + public function __construct() |
|
| 17 | + { |
|
| 18 | + // $this->XoopsObject(); |
|
| 19 | + $this->initVar('instrid', XOBJ_DTYPE_INT, null, false, 11); |
|
| 20 | + $this->initVar('cid', XOBJ_DTYPE_INT, 0, false, 5); |
|
| 21 | + $this->initVar('uid', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 22 | + $this->initVar('title', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 23 | + $this->initVar('status', XOBJ_DTYPE_INT, 0, false, 1); |
|
| 24 | + $this->initVar('pages', XOBJ_DTYPE_INT, 0, false, 11); |
|
| 25 | + $this->initVar('description', XOBJ_DTYPE_TXTAREA, null, false); |
|
| 26 | + $this->initVar('datecreated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 27 | + $this->initVar('dateupdated', XOBJ_DTYPE_INT, 0, false, 10); |
|
| 28 | + $this->initVar('metakeywords', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 29 | + $this->initVar('metadescription', XOBJ_DTYPE_TXTBOX, '', false); |
|
| 30 | + |
|
| 31 | + // Нет в таблице |
|
| 32 | + $this->initVar('dohtml', XOBJ_DTYPE_INT, 1, false); |
|
| 33 | + $this->initVar('dobr', XOBJ_DTYPE_INT, 0, false); |
|
| 34 | + } |
|
| 35 | + |
|
| 36 | + /** |
|
| 37 | + * @return mixed |
|
| 38 | + */ |
|
| 39 | + public function getNewInstertId() |
|
| 40 | + { |
|
| 41 | + $newEnreg = $GLOBALS['xoopsDB']->getInsertId(); |
|
| 42 | + return $newEnreg; |
|
| 43 | + } |
|
| 44 | + |
|
| 45 | + // Получаем форму |
|
| 46 | + |
|
| 47 | + /** |
|
| 48 | + * @param bool|null|string $action |
|
| 49 | + * @return \XoopsThemeForm |
|
| 50 | + */ |
|
| 51 | + public function getForm($action = false) |
|
| 52 | + { |
|
| 53 | + global $xoopsDB, $xoopsModule, $xoopsModuleConfig; |
|
| 54 | + // Если нет $action |
|
| 55 | + if (false === $action) { |
|
| 56 | + $action = xoops_getenv('REQUEST_URI'); |
|
| 57 | + } |
|
| 58 | + // Подключаем формы |
|
| 59 | + include_once $GLOBALS['xoops']->path('class/xoopsformloader.php'); |
|
| 60 | + |
|
| 61 | + // Название формы |
|
| 62 | + $title = $this->isNew() ? sprintf(_AM_INSTRUCTION_FORMADDINSTR) : sprintf(_AM_INSTRUCTION_FORMEDITINSTR); |
|
| 63 | + |
|
| 64 | + // Форма |
|
| 65 | + $form = new \XoopsThemeForm($title, 'forminstr', $action, 'post', true); |
|
| 66 | + //$form->setExtra('enctype="multipart/form-data"'); |
|
| 67 | + // Название инструкции |
|
| 68 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_TITLEC, 'title', 50, 255, $this->getVar('title')), true); |
|
| 69 | + // Категория |
|
| 70 | + $categoryHandler = new CategoryHandler; |
|
| 71 | + $criteria = new \CriteriaCompo(); |
|
| 72 | + $criteria->setSort('weight ASC, title'); |
|
| 73 | + $criteria->setOrder('ASC'); |
|
| 74 | + $instructioncat_arr = $categoryHandler->getall($criteria); |
|
| 75 | + unset($criteria); |
|
| 76 | + // Подключаем трей |
|
| 77 | + include_once $GLOBALS['xoops']->path('class/tree.php'); |
|
| 78 | + $mytree = new \XoopsObjectTree($instructioncat_arr, 'cid', 'pid'); |
|
| 79 | + |
|
| 80 | + // $form->addElement(new XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
| 81 | + $helper = Helper::getInstance(); |
|
| 82 | + $module = $helper->getModule(); |
|
| 83 | + |
|
| 84 | + if (Utility::checkVerXoops($module, '2.5.9')) { |
|
| 85 | + $mytree_select = $mytree->makeSelectElement('cid', 'title', '--', $this->getVar('cid'), true, 0, '', _AM_INSTRUCTION_CATC); |
|
| 86 | + $form->addElement($mytree_select); |
|
| 87 | + } else { |
|
| 88 | + $form->addElement(new \XoopsFormLabel(_AM_INSTRUCTION_CATC, $mytree->makeSelBox('cid', 'title', '--', $this->getVar('cid'), true))); |
|
| 89 | + } |
|
| 90 | + |
|
| 91 | + // Описание |
|
| 92 | + $form->addElement(Utility::getWysiwygForm(_AM_INSTRUCTION_DESCRIPTIONC, 'description', $this->getVar('description', 'e')), true); |
|
| 93 | + // Статус |
|
| 94 | + $form->addElement(new \XoopsFormRadioYN(_AM_INSTRUCTION_ACTIVEC, 'status', $this->getVar('status')), false); |
|
| 95 | + |
|
| 96 | + // Теги |
|
| 97 | + $dir_tag_ok = false; |
|
| 98 | + if (is_dir('../../tag') || is_dir('../tag')) { |
|
| 99 | + $dir_tag_ok = true; |
|
| 100 | + } |
|
| 101 | + // Если влючена поддержка тегов и есть модуль tag |
|
| 102 | + if (xoops_getModuleOption('usetag', 'instruction') && $dir_tag_ok) { |
|
| 103 | + $itemIdForTag = $this->isNew() ? 0 : $this->getVar('instrid'); |
|
| 104 | + // Подключаем форму тегов |
|
| 105 | + include_once $GLOBALS['xoops']->path('modules/tag/include/formtag.php'); |
|
| 106 | + // Добавляем элемент в форму |
|
| 107 | + $form->addElement(new \XoopsFormTag('tag', 60, 255, $itemIdForTag, 0)); |
|
| 108 | + } |
|
| 109 | + |
|
| 110 | + // Мета-теги ключевых слов |
|
| 111 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METAKEYWORDSC, 'metakeywords', 50, 255, $this->getVar('metakeywords')), false); |
|
| 112 | + // Мета-теги описания |
|
| 113 | + $form->addElement(new \XoopsFormText(_AM_INSTRUCTION_METADESCRIPTIONC, 'metadescription', 50, 255, $this->getVar('metadescription')), false); |
|
| 114 | + |
|
| 115 | + // Если мы редактируем категорию |
|
| 116 | + if (!$this->isNew()) { |
|
| 117 | + $form->addElement(new \XoopsFormHidden('instrid', $this->getVar('instrid'))); |
|
| 118 | + } |
|
| 119 | + // |
|
| 120 | + $form->addElement(new \XoopsFormHidden('op', 'saveinstr')); |
|
| 121 | + // Кнопка |
|
| 122 | + $form->addElement(new \XoopsFormButton('', 'submit', _SUBMIT, 'submit')); |
|
| 123 | + return $form; |
|
| 124 | + } |
|
| 125 | 125 | } |
| 126 | 126 | |
@@ -7,36 +7,36 @@ discard block |
||
| 7 | 7 | */ |
| 8 | 8 | function instruction_tag_iteminfo(&$items) |
| 9 | 9 | { |
| 10 | - if (empty($items) || !is_array($items)) { |
|
| 11 | - return false; |
|
| 12 | - } |
|
| 10 | + if (empty($items) || !is_array($items)) { |
|
| 11 | + return false; |
|
| 12 | + } |
|
| 13 | 13 | |
| 14 | - $items_id = []; |
|
| 15 | - foreach (array_keys($items) as $cat_id) { |
|
| 16 | - foreach (array_keys($items[$cat_id]) as $item_id) { |
|
| 17 | - $items_id[] = (int)$item_id; |
|
| 18 | - } |
|
| 19 | - } |
|
| 14 | + $items_id = []; |
|
| 15 | + foreach (array_keys($items) as $cat_id) { |
|
| 16 | + foreach (array_keys($items[$cat_id]) as $item_id) { |
|
| 17 | + $items_id[] = (int)$item_id; |
|
| 18 | + } |
|
| 19 | + } |
|
| 20 | 20 | |
| 21 | - $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
| 22 | - $items_obj = $itemHandler->getObjects(new \Criteria('instrid', '(' . implode(', ', $items_id) . ')', 'IN'), true); |
|
| 21 | + $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
| 22 | + $items_obj = $itemHandler->getObjects(new \Criteria('instrid', '(' . implode(', ', $items_id) . ')', 'IN'), true); |
|
| 23 | 23 | |
| 24 | - foreach (array_keys($items) as $cat_id) { |
|
| 25 | - foreach (array_keys($items[$cat_id]) as $item_id) { |
|
| 26 | - if (isset($items_obj[$item_id])) { |
|
| 27 | - $item_obj = $items_obj[$item_id]; |
|
| 28 | - $items[$cat_id][$item_id] = [ |
|
| 29 | - 'title' => $item_obj->getVar('title'), |
|
| 30 | - 'uid' => $item_obj->getVar('uid'), |
|
| 31 | - 'link' => "instr.php?id={$item_id}", |
|
| 32 | - 'time' => $item_obj->getVar('datecreated'), |
|
| 33 | - 'tags' => '', |
|
| 34 | - 'content' => '', |
|
| 35 | - ]; |
|
| 36 | - } |
|
| 37 | - } |
|
| 38 | - } |
|
| 39 | - unset($items_obj); |
|
| 24 | + foreach (array_keys($items) as $cat_id) { |
|
| 25 | + foreach (array_keys($items[$cat_id]) as $item_id) { |
|
| 26 | + if (isset($items_obj[$item_id])) { |
|
| 27 | + $item_obj = $items_obj[$item_id]; |
|
| 28 | + $items[$cat_id][$item_id] = [ |
|
| 29 | + 'title' => $item_obj->getVar('title'), |
|
| 30 | + 'uid' => $item_obj->getVar('uid'), |
|
| 31 | + 'link' => "instr.php?id={$item_id}", |
|
| 32 | + 'time' => $item_obj->getVar('datecreated'), |
|
| 33 | + 'tags' => '', |
|
| 34 | + 'content' => '', |
|
| 35 | + ]; |
|
| 36 | + } |
|
| 37 | + } |
|
| 38 | + } |
|
| 39 | + unset($items_obj); |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | // Синхронизация тегов |
@@ -45,32 +45,32 @@ discard block |
||
| 45 | 45 | */ |
| 46 | 46 | function instruction_tag_synchronization($mid) |
| 47 | 47 | { |
| 48 | - $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
| 49 | - $linkHandler = xoops_getModuleHandler('link', 'tag'); |
|
| 48 | + $itemHandler = xoops_getModuleHandler('instruction', 'instruction'); |
|
| 49 | + $linkHandler = xoops_getModuleHandler('link', 'tag'); |
|
| 50 | 50 | |
| 51 | - /* clear tag-item links */ |
|
| 52 | - if (version_compare($GLOBALS['xoopsDB']->getServerVersion(), '4.1.0', 'ge')): |
|
| 53 | - $sql = " DELETE FROM {$linkHandler->table}" |
|
| 54 | - . ' WHERE ' |
|
| 55 | - . " tag_modid = {$mid}" |
|
| 56 | - . ' AND ' |
|
| 57 | - . ' ( tag_itemid NOT IN ' |
|
| 58 | - . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
| 59 | - . " FROM {$itemHandler->table} " |
|
| 60 | - . " WHERE {$itemHandler->table}.status > 0" |
|
| 61 | - . ' ) ' |
|
| 62 | - . ' )'; |
|
| 63 | - else: |
|
| 64 | - $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
|
| 65 | - . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
|
| 66 | - . ' WHERE ' |
|
| 67 | - . " tag_modid = {$mid}" |
|
| 68 | - . ' AND ' |
|
| 69 | - . " ( aa.{$itemHandler->keyName} IS NULL" |
|
| 70 | - . ' OR aa.status < 1' |
|
| 71 | - . ' )'; |
|
| 72 | - endif; |
|
| 73 | - if (!$result = $linkHandler->db->queryF($sql)) { |
|
| 74 | - //xoops_error($linkHandler->db->error()); |
|
| 75 | - } |
|
| 51 | + /* clear tag-item links */ |
|
| 52 | + if (version_compare($GLOBALS['xoopsDB']->getServerVersion(), '4.1.0', 'ge')): |
|
| 53 | + $sql = " DELETE FROM {$linkHandler->table}" |
|
| 54 | + . ' WHERE ' |
|
| 55 | + . " tag_modid = {$mid}" |
|
| 56 | + . ' AND ' |
|
| 57 | + . ' ( tag_itemid NOT IN ' |
|
| 58 | + . " ( SELECT DISTINCT {$itemHandler->keyName} " |
|
| 59 | + . " FROM {$itemHandler->table} " |
|
| 60 | + . " WHERE {$itemHandler->table}.status > 0" |
|
| 61 | + . ' ) ' |
|
| 62 | + . ' )'; |
|
| 63 | + else: |
|
| 64 | + $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
|
| 65 | + . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
|
| 66 | + . ' WHERE ' |
|
| 67 | + . " tag_modid = {$mid}" |
|
| 68 | + . ' AND ' |
|
| 69 | + . " ( aa.{$itemHandler->keyName} IS NULL" |
|
| 70 | + . ' OR aa.status < 1' |
|
| 71 | + . ' )'; |
|
| 72 | + endif; |
|
| 73 | + if (!$result = $linkHandler->db->queryF($sql)) { |
|
| 74 | + //xoops_error($linkHandler->db->error()); |
|
| 75 | + } |
|
| 76 | 76 | } |
@@ -7,14 +7,14 @@ discard block |
||
| 7 | 7 | */ |
| 8 | 8 | function instruction_tag_iteminfo(&$items) |
| 9 | 9 | { |
| 10 | - if (empty($items) || !is_array($items)) { |
|
| 10 | + if (empty($items) || ! is_array($items)) { |
|
| 11 | 11 | return false; |
| 12 | 12 | } |
| 13 | 13 | |
| 14 | 14 | $items_id = []; |
| 15 | 15 | foreach (array_keys($items) as $cat_id) { |
| 16 | 16 | foreach (array_keys($items[$cat_id]) as $item_id) { |
| 17 | - $items_id[] = (int)$item_id; |
|
| 17 | + $items_id[] = (int) $item_id; |
|
| 18 | 18 | } |
| 19 | 19 | } |
| 20 | 20 | |
@@ -70,7 +70,7 @@ discard block |
||
| 70 | 70 | . ' OR aa.status < 1' |
| 71 | 71 | . ' )'; |
| 72 | 72 | endif; |
| 73 | - if (!$result = $linkHandler->db->queryF($sql)) { |
|
| 73 | + if ( ! $result = $linkHandler->db->queryF($sql)) { |
|
| 74 | 74 | //xoops_error($linkHandler->db->error()); |
| 75 | 75 | } |
| 76 | 76 | } |
@@ -60,7 +60,8 @@ discard block |
||
| 60 | 60 | . " WHERE {$itemHandler->table}.status > 0" |
| 61 | 61 | . ' ) ' |
| 62 | 62 | . ' )'; |
| 63 | - else: |
|
| 63 | + else {
|
|
| 64 | + : |
|
| 64 | 65 | $sql = " DELETE {$linkHandler->table} FROM {$linkHandler->table}" |
| 65 | 66 | . " LEFT JOIN {$itemHandler->table} AS aa ON {$linkHandler->table}.tag_itemid = aa.{$itemHandler->keyName} " |
| 66 | 67 | . ' WHERE ' |
@@ -68,7 +69,8 @@ discard block |
||
| 68 | 69 | . ' AND ' |
| 69 | 70 | . " ( aa.{$itemHandler->keyName} IS NULL" |
| 70 | 71 | . ' OR aa.status < 1' |
| 71 | - . ' )'; |
|
| 72 | + . ' )'; |
|
| 73 | + } |
|
| 72 | 74 | endif; |
| 73 | 75 | if (!$result = $linkHandler->db->queryF($sql)) { |
| 74 | 76 | //xoops_error($linkHandler->db->error()); |
@@ -9,9 +9,9 @@ discard block |
||
| 9 | 9 | */ |
| 10 | 10 | function instruction_com_update($pageid, $total_num) |
| 11 | 11 | { |
| 12 | - $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 13 | - $sql = 'UPDATE ' . $db->prefix('instruction_page') . ' SET comments = ' . $total_num . ' WHERE pageid = ' . $pageid; |
|
| 14 | - $db->query($sql); |
|
| 12 | + $db = XoopsDatabaseFactory::getDatabaseConnection(); |
|
| 13 | + $sql = 'UPDATE ' . $db->prefix('instruction_page') . ' SET comments = ' . $total_num . ' WHERE pageid = ' . $pageid; |
|
| 14 | + $db->query($sql); |
|
| 15 | 15 | } |
| 16 | 16 | |
| 17 | 17 | /** |
@@ -19,5 +19,5 @@ discard block |
||
| 19 | 19 | */ |
| 20 | 20 | function instruction_com_approve(&$comment) |
| 21 | 21 | { |
| 22 | - // notification mail here |
|
| 22 | + // notification mail here |
|
| 23 | 23 | } |
@@ -70,8 +70,8 @@ |
||
| 70 | 70 | $debug = false; |
| 71 | 71 | |
| 72 | 72 | if (!isset($GLOBALS['xoopsTpl']) || !($GLOBALS['xoopsTpl'] instanceof \XoopsTpl)) { |
| 73 | - require_once $GLOBALS['xoops']->path('class/template.php'); |
|
| 74 | - $xoopsTpl = new \XoopsTpl(); |
|
| 73 | + require_once $GLOBALS['xoops']->path('class/template.php'); |
|
| 74 | + $xoopsTpl = new \XoopsTpl(); |
|
| 75 | 75 | } |
| 76 | 76 | |
| 77 | 77 | $moduleDirName = basename(dirname(__DIR__)); |
@@ -69,7 +69,7 @@ |
||
| 69 | 69 | |
| 70 | 70 | $debug = false; |
| 71 | 71 | |
| 72 | -if (!isset($GLOBALS['xoopsTpl']) || !($GLOBALS['xoopsTpl'] instanceof \XoopsTpl)) { |
|
| 72 | +if ( ! isset($GLOBALS['xoopsTpl']) || ! ($GLOBALS['xoopsTpl'] instanceof \XoopsTpl)) { |
|
| 73 | 73 | require_once $GLOBALS['xoops']->path('class/template.php'); |
| 74 | 74 | $xoopsTpl = new \XoopsTpl(); |
| 75 | 75 | } |