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);
}
