memb_levels.php

Go to the documentation of this file.

<?php
 
require_once('../inc/header.inc.php');
require_once(CH_DIRECTORY_PATH_INC . 'profiles.inc.php');
require_once(CH_DIRECTORY_PATH_INC . 'design.inc.php');
require_once(CH_DIRECTORY_PATH_INC . 'admin_design.inc.php');
require_once(CH_DIRECTORY_PATH_INC . 'utils.inc.php');
ch_import('ChWsbAdminSettings');
ch_import('ChTemplSearchResult');
 
$logged['admin'] = member_auth(1, true, true);
 
$oSettings = new ChWsbAdminSettings(5, CH_WSB_URL_ADMIN . 'memb_levels.php?tab=settings');
 
//--- Process submit ---//]
$aResults = array();
$mixedResultActions = '';
$mixedResultAction = '';
$mixedResultPrices = '';
if (isset($_POST['save']) && isset($_POST['cat'])) {
    $aResults['settings'] = $oSettings->saveChanges($_POST);
} elseif ((isset($_POST['adm-mlevels-enable']) || isset($_POST['adm-mlevels-disable'])) && !empty($_POST['levels'])) {
    if (isset($_POST['adm-mlevels-enable'])) {
        $sValue = 'yes';
    } elseif (isset($_POST['adm-mlevels-disable'])) {
        $sValue = 'no';
    }
 
    $GLOBALS['MySQL']->query("UPDATE `sys_acl_levels` SET `Active`='" . $sValue . "' WHERE `ID` IN ('" . implode("','", $_POST['levels']) . "')");
} elseif (isset($_POST['adm-mlevels-delete']) && !empty($_POST['levels'])) {
    foreach ($_POST['levels'] as $iId) {
        if (($aResults['levels'] = deleteMembership($iId)) !== true) {
            break;
        }
    }
} elseif (isset($_POST['adm-mlevels-actions-enable']) || isset($_POST['adm-mlevels-actions-disable'])) {
    $iLevelId = (int)$_POST['level'];
 
    foreach ($_POST['actions'] as $iId) {
        if (isset($_POST['adm-mlevels-actions-enable'])) {
            $sQuery = "REPLACE INTO `sys_acl_matrix` SET `IDLevel`='" . $iLevelId . "', `IDAction`='" . $iId . "'";
        } else {
            $sQuery = "DELETE FROM `sys_acl_matrix` WHERE `IDLevel`='" . $iLevelId . "' AND `IDAction`='" . $iId . "'";
        }
 
        $GLOBALS['MySQL']->query($sQuery);
    }
} elseif (isset($_POST['adm-mlevels-prices-add'])) {
    $iLevelId = (int)$_POST['level'];
    $iDays = (int)$_POST['days'];
    $iPrice = (float)trim($_POST['price'], " $");
 
    $iLevelIdDb = (int)$GLOBALS['MySQL']->getOne("SELECT `id` FROM `sys_acl_level_prices` WHERE `IDLevel`='" . $iLevelId . "' AND `Days`='" . $iDays . "' LIMIT 1");
    if ($iLevelIdDb == 0) {
        $GLOBALS['MySQL']->query("INSERT INTO `sys_acl_level_prices`(`IDLevel`, `Days`, `Price`) VALUES('" . $iLevelId . "', '" . $iDays . "', '" . $iPrice . "')");
    } else {
        $mixedResultPrices = _t('_adm_txt_mlevels_price_exists');
    }
} elseif (isset($_POST['adm-mlevels-prices-delete'])) {
    $GLOBALS['MySQL']->query("DELETE FROM `sys_acl_level_prices` WHERE `id` IN ('" . implode("','", $_POST['prices']) . "')");
} elseif (isset($_POST['adm-mlevels-action-save'])) {
    $sQuery = "REPLACE INTO `sys_acl_matrix` SET `IDLevel`='" . (int)$_POST['levelId'] . "', `IDAction`='" . (int)$_POST['actionId'] . "'";
    $sQuery .= !empty($_POST['allowedCnt']) ? ", `AllowedCount`='" . (int)$_POST['allowedCnt'] . "'" : "";
    $sQuery .= !empty($_POST['period']) ? ", `AllowedPeriodLen`='" . (int)$_POST['period'] . "'" : "";
    $sQuery .= !empty($_POST['dateStart']) && strtotime($_POST['dateStart']) > 0 ? ", `AllowedPeriodStart`=FROM_UNIXTIME(" . strtotime($_POST['dateStart']) . ")" : "";
    $sQuery .= !empty($_POST['dateEnd']) && strtotime($_POST['dateEnd']) > 0 ? ", `AllowedPeriodEnd`=FROM_UNIXTIME(" . strtotime($_POST['dateEnd']) . ")" : "";
    $aResult = $GLOBALS['MySQL']->query($sQuery) > 0 ? array('code' => 0, 'message' => MsgBox(_t('_adm_txt_mlevels_action_saved'))) : array('code' => 1, 'message' => MsgBox(_t('_adm_txt_mlevels_action_cannot_save')));
 
    echo "<script>parent.onResult(" . json_encode($aResult) . ");</script>";
    exit;
} elseif (isset($_POST['action']) && $_POST['action'] == 'get_edit_form_action') {
    echo json_encode(array('code' => PageCodeAction((int)$_POST['level_id'], (int)$_POST['action_id'], $mixedResultAction)));
    exit;
}
 
$iLevelId = ch_get('level') !== false ? (int)ch_get('level') : 0;
 
$iNameIndex = 6;
$_page = array(
    'name_index' => $iNameIndex,
    'css_name' => array('settings.css', 'memb_levels.css'),
    'js_name' => array('memb_levels.js'),
    'header' => _t('_adm_page_cpt_memb_levels'),
);
$_page_cont[$iNameIndex] = array(
    'page_code_main' => PageCodeMain($aResults, $iLevelId),
    'page_code_actions' => ch_get('action') !== false && ch_get('action') == 'actions' && $iLevelId > 0 ? PageCodeActions($iLevelId, $mixedResultActions) : "",
    'page_code_prices' => ch_get('action') !== false && ch_get('action') == 'prices' && $iLevelId > 0 ? PageCodePrices($iLevelId, $mixedResultPrices) : "",
);
 
// add necessary js and css files
ch_import('ChTemplFormView');
$oForm = new ChTemplFormView(array());
$oForm->addCssJs(true, true);
 
PageCodeAdmin();
 
function PageCodeMain($aResults, $iLevelId)
{
    $sTab = ch_get('tab') !== false ? process_db_input(ch_get('tab')) : 'levels';
 
    $bEdit = ch_get('action') !== false && ch_get('action') == 'edit';
    if ($bEdit) {
        $sTab = 'levels_add';
    }
 
    $aTopItems = array(
        'adm-mlevels-btn-levels' => array('href' => 'javascript:void(0)', 'onclick' => 'javascript:onChangeType(this)', 'title' => _t('_adm_txt_mlevels_levels'), 'active' => $sTab == 'levels' ? 1 : 0),
        'adm-mlevels-btn-levels-add' => array('href' => 'javascript:void(0)', 'onclick' => 'javascript:onChangeType(this)', 'title' => _t('_adm_txt_mlevels_levels_add'), 'active' => $sTab == 'levels_add' ? 1 : 0),
        'adm-mlevels-btn-settings' => array('href' => 'javascript:void(0)', 'onclick' => 'javascript:onChangeType(this)', 'title' => _t('_adm_txt_mlevels_settings'), 'active' => $sTab == 'settings' ? 1 : 0)
    );
 
    $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels.html', array(
        'content_levels' => _getLevelsList(isset($aResults['levels']) ? $aResults['levels'] : true, $sTab == 'levels'),
        'content_create' => _getLevelsCreateForm($bEdit ? $iLevelId : 0, $sTab == 'levels_add'),
        'content_settings' => _getLevelsSettingsForm(isset($aResults['settings']) ? $aResults['settings'] : true, $sTab == 'settings'),
    ));
 
    return DesignBoxAdmin(_t('_adm_box_cpt_mlevel_memberships'), $sResult, $aTopItems);
}
 
function _getLevelsList($mixedResult, $bActive = false)
{
    $sSubmitUrl = CH_WSB_URL_ADMIN . 'memb_levels.php?tab=levels';
 
    $sResult = '';
    if ($mixedResult !== true && !empty($mixedResult)) {
        $bActive = true;
        $sResult = MsgBox(_t($mixedResult), 3) . $sResult;
    }
 
    //--- Get Items ---//
    $aItemsSystem = $aItemsCustom = array();
 
    $aLevels = $GLOBALS['MySQL']->getAll("SELECT `ID` AS `id`, `Name` AS `title`, `Active` AS `active`, `Purchasable` AS `purchasable`, `Removable` AS `removable` FROM `sys_acl_levels` WHERE `Removable`='no' ORDER BY `ID` ASC");
    foreach ($aLevels as $aLevel) {
        $aItemsSystem[] = array(
            'id' => $aLevel['id'],
            'title' => $aLevel['title'],
            'actions_link' => $GLOBALS['site']['url_admin'] . 'memb_levels.php?action=actions&level=' . $aLevel['id'] . '#actions' . $aLevel['id'],
        );
    }
 
    $oModuleDb = new ChWsbModuleDb();
    $bPayment = $oModuleDb->isModule('payment');
 
    $aLevels = $GLOBALS['MySQL']->getAll("SELECT `ID` AS `id`, `Name` AS `title`, `Active` AS `active`, `Purchasable` AS `purchasable`, `Removable` AS `removable` FROM `sys_acl_levels` WHERE `Removable`='yes' ORDER BY `Order` ASC");
    foreach ($aLevels as $aLevel) {
        $aItemsCustom[] = array(
            'id' => $aLevel['id'],
            'title' => $aLevel['title'],
            'class' => $aLevel['active'] == 'yes' ? 'adm-mlevels-enabled' : 'adm-mlevels-disabled',
            'actions_link' => $GLOBALS['site']['url_admin'] . 'memb_levels.php?action=actions&level=' . $aLevel['id'] . '#actions' . $aLevel['id'],
            'ch_if:editable' => array(
                'condition' => $aLevel['removable'] == 'yes',
                'content' => array(
                    'edit_link' => $GLOBALS['site']['url_admin'] . 'memb_levels.php?action=edit&level=' . $aLevel['id'],
                )
            ),
            'ch_if:purchasable' => array(
                'condition' => $bPayment && $aLevel['purchasable'] == 'yes',
                'content' => array(
                    'price_link' => $GLOBALS['site']['url_admin'] . 'memb_levels.php?action=prices&level=' . $aLevel['id'] . '#prices' . $aLevel['id'],
                )
            )
        );
    }
 
    //--- Get Controls ---//
    $aButtons = array(
        'adm-mlevels-enable' => _t('_adm_btn_mlevels_enable'),
        'adm-mlevels-disable' => _t('_adm_btn_mlevels_disable'),
        'adm-mlevels-delete' => _t('_adm_btn_mlevels_delete')
    );
    $sControls = ChTemplSearchResult::showAdminActionsPanel('adm-mlevels-list-form', $aButtons, 'levels');
 
    return $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_list.html', array(
        'display' => $bActive ? 'block' : 'none',
        'action' => $sSubmitUrl,
        'result' => $sResult,
        'ch_repeat:items_system' => $aItemsSystem,
        'ch_repeat:items_custom' => $aItemsCustom,
        'controls' => $sControls
    ));
}
 
function _getLevelsCreateForm($iLevelId, $bActive = false)
{
    $sSubmitUrl = CH_WSB_URL_ADMIN . 'memb_levels.php';
 
    $aLevel = array();
    if (($bEdit = $iLevelId != 0) === true) {
        $aLevel = $GLOBALS['MySQL']->getRow("SELECT `Name` AS `Name`, `Description` AS `Description`, `Order` AS `Order` FROM `sys_acl_levels` WHERE `ID`= ? LIMIT 1", [$iLevelId]);
    }
 
    if (!$bEdit) {
        $aLevels = $GLOBALS['MySQL']->getAll("SELECT `ID` AS `id`, `Name` AS `title`, `Active` AS `active`, `Purchasable` AS `purchasable`, `Removable` AS `removable` FROM `sys_acl_levels` WHERE `Removable`='no' ORDER BY `ID` ASC");
        foreach ($aLevels as $aLevel2) {
            $aItemsSystem[$aLevel2['id']] = $aLevel2['title'];
        }
        $sCopyFromCaption = _t('_adm_txt_mlevels_copy');
    } else {
        $aItemsSystem = array();
        $sCopyFromCaption = '';
    }
 
    $aForm = array(
        'form_attrs' => array(
            'id' => 'adm-mlevels-create',
            'action' => $sSubmitUrl . '?tab=levels_add',
            'method' => 'post',
            'enctype' => 'multipart/form-data',
        ),
        'params' => array(
            'db' => array(
                'table' => 'sys_acl_levels',
                'key' => 'ID',
                'uri' => '',
                'uri_title' => '',
                'submit_name' => 'Submit'
            ),
        ),
        'inputs' => array(
            'Active' => array(
                'type' => 'hidden',
                'name' => 'Active',
                'value' => 'no',
                'db' => array(
                    'pass' => 'Xss',
                ),
            ),
            'Purchasable' => array(
                'type' => 'hidden',
                'name' => 'Purchasable',
                'value' => 'yes',
                'db' => array(
                    'pass' => 'Xss',
                ),
            ),
            'Removable' => array(
                'type' => 'hidden',
                'name' => 'Removable',
                'value' => 'yes',
                'db' => array(
                    'pass' => 'Xss',
                ),
            ),
            'Name' => array(
                'type' => 'text',
                'name' => 'Name',
                'caption' => _t('_adm_txt_mlevels_name'),
                'value' => isset($aLevel['Name']) ? $aLevel['Name'] : '',
                'required' => true,
                'db' => array(
                    'pass' => 'Xss',
                ),
                'checker' => array(
                    'func' => 'length',
                    'params' => array(3,100),
                    'error' => _t('_adm_txt_mlevels_name_err'),
                ),
            ),
            'Icon' => array(
                'type' => 'file',
                'name' => 'Icon',
                'caption' => _t('_adm_txt_mlevels_icon'),
                'required' => true,
                'checker' => array(
                    'func' => '',
                    'params' => '',
                    'error' => _t('_adm_txt_mlevels_icon_err'),
                ),
            ),
            'Description' => array(
                'type' => 'textarea',
                'name' => 'Description',
                'caption' => _t('_adm_txt_mlevels_description'),
                'value' => isset($aLevel['Description']) ? $aLevel['Description'] : '',
                'db' => array(
                    'pass' => 'XssHtml',
                ),
            ),
            'Order' => array(
                'type' => 'text',
                'name' => 'Order',
                'caption' => _t('_adm_txt_mlevels_order'),
                'value' => isset($aLevel['Order']) ? $aLevel['Order'] : $GLOBALS['MySQL']->getOne("SELECT MAX(`Order`)+1 FROM `sys_acl_levels`"),
                'required' => true,
                'db' => array(
                    'pass' => 'Int',
                ),
                'checker' => array(
                    'func' => 'preg',
                    'params' => array('/^[1-9][0-9]*$/'),
                    'error' => _t('_adm_txt_mlevels_order_err'),
                ),
            ),
            'CopyFrom' => array(
                'type' => 'radio_set',
                'name' => 'CopyFrom',
                'caption' => $sCopyFromCaption,
                'value' => $aItem['Target'] == '_blank' ? '_blank' : '_self',
                'values' => $aItemsSystem,
                'attrs' => array()
            ),
            'Submit' => array(
                'type' => 'submit',
                'name' => 'Submit',
                'value' => _t('_adm_btn_mlevels_add'),
            ),
        )
    );
 
    //--- Convert Add to Edit
    if ($bEdit) {
        unset($aForm['inputs']['Active']);
        unset($aForm['inputs']['Purchasable']);
        unset($aForm['inputs']['Removable']);
 
        $aForm['form_attrs']['action'] = $sSubmitUrl . '?action=edit&level=' . $iLevelId;
        $aForm['inputs']['Icon']['info'] = _t('_adm_txt_mlevels_icon_info_edit');
        $aForm['inputs']['Icon']['required'] = false;
        $aForm['inputs']['Icon']['checker'] = array();
        $aForm['inputs']['Submit']['value'] = _t('_adm_btn_mlevels_save');
        $aForm['inputs']['ID'] = array(
            'type' => 'hidden',
            'name' => 'ID',
            'value' => $iLevelId,
            'db' => array(
                'pass' => 'Int',
            )
        );
    }
    $oForm = new ChTemplFormView($aForm);
    $oForm->initChecker();
 
    if ($oForm->isSubmittedAndValid()) {
        $sFilePath = CH_DIRECTORY_PATH_ROOT . 'media/images/membership/';
        $sFileName = time();
        $sFileExt = '';
 
        //--- Add new level
        if (!$bEdit) {
            if ($GLOBALS['MySQL']->getOne("SELECT `Name` FROM `sys_acl_levels` WHERE `Name`='" . $oForm->getCleanValue('Name') . "' LIMIT 1")) {
                $oForm->aInputs['Name']['error'] = _t('_adm_txt_mlevels_name_err_non_uniq');
            } elseif (isImage($_FILES['Icon']['type'], $sFileExt) && !empty($_FILES['Icon']['tmp_name']) && move_uploaded_file($_FILES['Icon']['tmp_name'], $sFilePath . $sFileName . '.' . $sFileExt)) {
                $sPath = $sFilePath . $sFileName . '.' . $sFileExt;
                imageResize($sPath, $sPath, 110, 110);
 
                $iId = (int)$oForm->insert(array('Icon' => $sFileName . '.' . $sFileExt));
                if ($iId != 0) {
                    $sName = $oForm->getCleanValue('Name');
                    addStringToLanguage('_adm_txt_mp_' . strtolower($sName), $sName);
 
                    $iCopyFrom = (int)$oForm->getCleanValue('CopyFrom');
                    // If $sCopyFrom is set, then copy the actions from the level in $sCopyFrom to the new level.
                    if ($iCopyFrom > 0) {
                        _copyMatrix($iCopyFrom, $iId);
                    }
                }
 
                header('Location: ' . $sSubmitUrl);
                exit;
            } else {
                $oForm->aInputs['Icon']['error'] = $oForm->aInputs['Icon']['checker']['error'];
            }
        }
        //--- Edit existing level
        else {
            $aValsToAdd = array();
            if (isImage($_FILES['Icon']['type'], $sFileExt) && !empty($_FILES['Icon']['tmp_name']) && move_uploaded_file($_FILES['Icon']['tmp_name'], $sFilePath . $sFileName . '.' . $sFileExt)) {
                $aValsToAdd['Icon'] = $sFileName . '.' . $sFileExt;
 
                $sPath = $sFilePath . $sFileName . '.' . $sFileExt;
                imageResize($sPath, $sPath, 110, 110);
 
                $sIconOld = $GLOBALS['MySQL']->getOne("SELECT `Icon` FROM `sys_acl_levels` WHERE `ID`='" . $iLevelId . "' LIMIT 1");
                if (!empty($sIconOld)) {
                    @unlink($sFilePath . $sIconOld);
                }
            }
 
            $bResult = $oForm->update($iLevelId, $aValsToAdd);
            if ($bResult !== false) {
                deleteStringFromLanguage('_adm_txt_mp_' . strtolower($aLevel['Name']));
 
                $sName = $oForm->getCleanValue('Name');
                addStringToLanguage('_adm_txt_mp_' . strtolower($sName), $sName);
            }
 
            header('Location: ' . $sSubmitUrl);
            exit;
        }
    }
 
    return $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_create.html', array(
        'display' => $bActive ? 'block' : 'none',
        'form' => $oForm->getCode()
    ));
}
 
function _copyMatrix($iFromId, $iToId)
{
    // Copies the membership actions martix from the From ID to the To ID
    $aMatrix = $GLOBALS['MySQL']->getAll("SELECT * FROM `sys_acl_matrix` WHERE `IDLevel` = '$iFromId'");
    //echo $iFromId . '<br>';
    //echo $iToId . '<br>';
    //echo '<pre>' . print_r($aMatrix, true) . '</pre>';
    //exit;
    foreach ($aMatrix as $id => $value) {
        $sSet = "`IDLevel` = '$iToId', ";
        $sSet .= "`IDAction` = '" . $value['IDAction'] . "', ";
        $sSet .= "`AllowedCount` = '" . $value['AllowedCount'] . "', ";
        $sSet .= "`AllowedPeriodLen` = '" . $value['AllowedPeriodLen'] . "', ";
        $sSet .= "`AllowedPeriodStart` = '" . $value['AllowedPeriodStart'] . "', ";
        $sSet .= "`AllowedPeriodEnd` = '" . $value['AllowedPeriodEnd'] . "', ";
        $sSet .= "`AdditionalParamValue` = '" . $value['AdditionalParamValue'] . "';";
        $GLOBALS['MySQL']->query("INSERT INTO `sys_acl_matrix` SET " . $sSet);
    }
}
 
 
function _getLevelsSettingsForm($mixedResult, $bActive = false)
{
    $sResult = $GLOBALS['oSettings']->getForm();
    if ($mixedResult !== true && !empty($mixedResult)) {
        $bActive = true;
        $sResult = $mixedResult . $sResult;
    }
 
    return $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_settings.html', array(
        'display' => $bActive ? 'block' : 'none',
        'form' => $sResult
    ));
}
 
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`= ?", "id", [$iId]);
 
    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',
            'ch_if:enabled' => array(
                'condition' => $bEnabled,
                'content' => array(
                    'level_id' => $iId,
                    'action_id' => $aAction['id'],
                    'title' => $aAction['title']
                )
            ),
            'ch_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 = ChTemplSearchResult::showAdminActionsPanel('adm-mlevels-actions-form', $aButtons, 'actions');
 
    $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_actions.html', array(
        'id' => $iId,
        'ch_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);
}
function PageCodeAction($iLevelId, $iActionId, $mixedResult)
{
    $aAction = $GLOBALS['MySQL']->getRow("SELECT * FROM `sys_acl_matrix` WHERE `IDLevel`='" . $iLevelId . "' AND `IDAction`= ?", [$iActionId]);
 
    $aForm = array(
        'form_attrs' => array(
            'id' => 'adm-mlevels-action-form',
            'target' => 'adm-mlevels-action-iframe',
            'action' => $GLOBALS['site']['url_admin'] . 'memb_levels.php',
            'method' => 'post',
            'enctype' => 'multipart/form-data'
        ),
        'params' => array(),
        'inputs' => array(
            'levelId' => array(
                'type' => 'hidden',
                'name' => 'levelId',
                'value' => $iLevelId
            ),
            'actionId' => array(
                'type' => 'hidden',
                'name' => 'actionId',
                'value' => $iActionId
            ),
            'allowedCnt' => array(
                'type' => 'text',
                'name' => 'allowedCnt',
                'caption' => _t('_adm_txt_mlevels_actions_number'),
                'info' => _t('_adm_txt_mlevels_actions_number_desc'),
                'value' => isset($aAction['AllowedCount']) ? (int)$aAction['AllowedCount'] : ""
            ),
            'period' => array(
                'type' => 'text',
                'name' => 'period',
                'caption' => _t('_adm_txt_mlevels_actions_reset'),
                'info' => _t('_adm_txt_mlevels_actions_reset_desc'),
                'value' => isset($aAction['AllowedPeriodLen']) ? (int)$aAction['AllowedPeriodLen'] : ""
            ),
            'dateStart' => array(
                'type' => 'datetime',
                'name' => 'dateStart',
                'caption' => _t('_adm_txt_mlevels_actions_avail_start'),
                'info' => _t('_adm_txt_mlevels_actions_avail_desc'),
                'value' => isset($aAction['AllowedPeriodStart']) ? preg_replace('/(\d+):(\d+):(\d+)/', '$1:$2', $aAction['AllowedPeriodStart']) : "",
                'attrs' => array(
                    'allow_input' => 'true',
                ),
                'db' => array(
                    'pass' => 'DateTime',
                ),
            ),
            'dateEnd' => array(
                'type' => 'datetime',
                'name' => 'dateEnd',
                'caption' => _t('_adm_txt_mlevels_actions_avail_end'),
                'info' => _t('_adm_txt_mlevels_actions_avail_desc'),
                'value' => isset($aAction['AllowedPeriodEnd']) ? preg_replace('/(\d+):(\d+):(\d+)/', '$1:$2', $aAction['AllowedPeriodEnd']) : "",
                'attrs' => array(
                    'allow_input' => 'true',
                ),
                'db' => array(
                    'pass' => 'DateTime',
                ),
            ),
            'adm-mlevels-action-save' => array(
                'type' => 'submit',
                'name' => 'adm-mlevels-action-save',
                'value' => _t('_adm_btn_mlevels_save'),
            ),
        )
    );
    $oForm = new ChTemplFormView($aForm);
 
    $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_action.html', array(
        'content' => $oForm->getCode()
    ));
 
    if ($mixedResult !== true && !empty($mixedResult)) {
        $sResult = MsgBox(_t($mixedResult), 3) . $sResult;
    }
 
    return $GLOBALS['oFunctions']->popupBox('adm-mlevels-action', _t('_adm_box_cpt_mlevel_action'), $sResult);
}
function PageCodePrices($iId, $mixedResult)
{
    //--- Get Items ---//
    $oModuleDb = new ChWsbModuleDb();
    if (!$oModuleDb->isModule('payment')) {
        return '';
    }
 
    $aInfo = ChWsbService::call('payment', 'get_currency_info');
    $sCurrencySign = $aInfo['sign'];
 
    $aItems = array();
    $aPrices = $GLOBALS['MySQL']->getAll("SELECT `id` AS `id`, `Days` AS `days`, `Price` AS `price` FROM `sys_acl_level_prices` WHERE `IDLevel`= ? ORDER BY `id`", [$iId]);
    foreach ($aPrices as $aPrice) {
        $aItems[] = array(
            'id' => $aPrice['id'],
            'title' => (int)$aPrice['days'] == 0 ? _t('_adm_txt_mlevels_price_info_lifetime', $sCurrencySign, $aPrice['price']) : _t('_adm_txt_mlevels_price_info', $aPrice['days'], $sCurrencySign, $aPrice['price']),
        );
    }
 
    //--- Get Controls ---//
    $sTopControls = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_prices_top_controls.html', array());
 
    $aButtons = array(
        'adm-mlevels-prices-delete' => _t('_adm_btn_mlevels_delete')
    );
    $sControls = ChTemplSearchResult::showAdminActionsPanel('adm-mlevels-prices-form', $aButtons, 'prices');
 
    $sResult = $GLOBALS['oAdmTemplate']->parseHtmlByName('mlevels_prices.html', array(
        'id' => $iId,
        'top_controls' => $sTopControls,
        'ch_repeat:items' => $aItems,
        'controls' => $sControls
    ));
 
    if ($mixedResult !== true && !empty($mixedResult)) {
        $sResult = MsgBox(_t($mixedResult), 3) . $sResult;
    }
 
    $sTitle = $GLOBALS['MySQL']->getOne("SELECT `Name` FROM `sys_acl_levels` WHERE `ID`='" . $iId . "' LIMIT 1");
    return DesignBoxAdmin(_t('_adm_box_cpt_mlevel_prices', $sTitle), $sResult);
}
function isImage($sMimeType, &$sFileExtension)
{
    $bResult = true;
    switch ($sMimeType) {
        case 'image/jpeg':
        case 'image/pjpeg':
            $sFileExtension = 'jpg';
            break;
        case 'image/png':
        case 'image/x-png':
            $sFileExtension = 'png';
            break;
        case 'image/gif':
            $sFileExtension = 'gif';
            break;
        default:
            $bResult = false;
    }
    return $bResult;
}
function deleteMembership($iId)
{
    $iId = (int)$iId;
 
    $aLevel = $GLOBALS['MySQL']->getRow("SELECT `Icon` AS `icon`, `Removable` AS `removable`, `Name` AS `name` FROM `sys_acl_levels` WHERE `ID`= ?", [$iId]);
    if (empty($aLevel)) {
        return "_adm_txt_mlevels_not_found";
    }
 
    //Check if membership can be removed
    if ($aLevel['removable'] != 'yes') {
        return '_adm_txt_mlevels_cannot_remove';
    }
 
    //Check if there are still members using this ANNUAL membership
    $iDateExpires = $GLOBALS['MySQL']->getOne("SELECT UNIX_TIMESTAMP(MAX(`DateExpires`)) as `MaxDateExpires` FROM `sys_acl_levels_members` WHERE `IDLevel`='" . $iId . "'");
    if ($iDateExpires > time()) {
        return "_adm_txt_mlevels_is_used";
    }
 
    //Check if there are members using this LIFETIME membership
    $iLifetime = (int)$GLOBALS['MySQL']->getOne("SELECT COUNT(`IDMember`) FROM `sys_acl_levels_members` WHERE `DateStarts`<=NOW() AND ISNULL(`DateExpires`) AND `IDLevel`='" . $iId . "'");
    if ($iLifetime > 0) {
        return "_adm_txt_mlevels_is_used";
    }
 
    @unlink(CH_DIRECTORY_PATH_ROOT . 'media/images/membership/' . $aLevel['icon']);
    db_res("DELETE FROM `sys_acl_level_prices` WHERE `IDLevel`='" . $iId . "'");
    db_res("DELETE FROM `sys_acl_matrix` WHERE `IDLevel`='" . $iId . "'");
    db_res("DELETE FROM `sys_acl_levels` WHERE `ID`='" . $iId . "'");
    deleteStringFromLanguage('_adm_txt_mp_' . strtolower($aLevel['name']));
 
    return true;
}