function membershipActionsList($membershipID) { $sNoLimit = _t('_no limit'); $sqlFields = ''; $aFields = array('AllowedCount', 'AllowedPeriodLen', 'AllowedPeriodStart', 'AllowedPeriodEnd'); foreach ($aFields as $sField) { $sqlFields .= ",IFNULL(`{$sField}`, '{$sNoLimit}') as `{$sField}`"; } $sqlQuery = "\n SELECT `IDAction`, `Name` {$sqlFields}\n FROM `sys_acl_matrix`\n INNER JOIN `sys_acl_actions` ON `sys_acl_matrix`.`IDAction` = `sys_acl_actions`.`ID`\n WHERE `sys_acl_matrix`.`IDLevel` = ?"; $aDraw['bx_repeat:actions'] = $GLOBALS['MySQL']->getAll($sqlQuery, [$membershipID]); translateMembershipActions($aDraw['bx_repeat:actions']); return $GLOBALS['oSysTemplate']->parseHtmlByName('memlevel_actions_list.html', $aDraw); }
function PageCodeActions($iId, $mixedResult) { $sTitle = $GLOBALS['MySQL']->getOne("SELECT `Name` FROM `sys_acl_levels` WHERE `ID`='" . $iId . "' LIMIT 1"); //--- Get Items ---// $aItems = array(); $aActions = $GLOBALS['MySQL']->getAll("SELECT `ta`.`ID` AS `id`, `ta`.`Name` AS `title` FROM `sys_acl_actions` AS `ta` ORDER BY `ta`.`Name`"); $aActionsActive = $GLOBALS['MySQL']->getAllWithKey("SELECT `ta`.`ID` AS `id`, `ta`.`Name` AS `title` FROM `sys_acl_actions` AS `ta` LEFT JOIN `sys_acl_matrix` AS `tm` ON `ta`.`ID`=`tm`.`IDAction` LEFT JOIN `sys_acl_levels` AS `tl` ON `tm`.`IDLevel`=`tl`.`ID` WHERE `tl`.`ID`='" . $iId . "'", "id"); translateMembershipActions($aActions); foreach ($aActions as $aAction) { $bEnabled = array_key_exists($aAction['id'], $aActionsActive); $aItems[] = array('action_id' => $aAction['id'], 'title' => $aAction['title'], 'class' => $bEnabled ? 'adm-mlevels-enabled' : 'adm-mlevels-disabled', 'bx_if:enabled' => array('condition' => $bEnabled, 'content' => array('level_id' => $iId, 'action_id' => $aAction['id'], 'title' => $aAction['title'])), 'bx_if:disabled' => array('condition' => !$bEnabled, 'content' => array('action_id' => $aAction['id'], 'title' => $aAction['title']))); } //--- Get Controls ---// $aButtons = array('adm-mlevels-actions-enable' => _t('_adm_btn_mlevels_enable'), 'adm-mlevels-actions-disable' => _t('_adm_btn_mlevels_disable')); $sControls = BxTemplSearchResult::showAdminActionsPanel('adm-mlevels-actions-form', $aButtons, 'actions'); $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_actions.html', array('id' => $iId, 'bx_repeat:items' => $aItems, 'controls' => $sControls, 'url_admin' => $GLOBALS['site']['url_admin'])); if ($mixedResult !== true && !empty($mixedResult)) { $sResult = MsgBox(_t($mixedResult), 3) . $sResult; } return DesignBoxAdmin(_t('_adm_box_cpt_mlevel_actions', $sTitle), $sResult); }