yf_user_groups admin module

    public function active()
    {
        $_GET['id'] = (int) (($_GET['id'] ?? null));
        if ( ! empty($_GET['id'])) {
            $group_info = db()->query_fetch('SELECT * FROM ' . db('user_groups') . ' WHERE id=' . (int) (($_GET['id'] ?? null)));
        }
        if ( ! empty($group_info)) {
            db()->UPDATE('user_groups', [
                'active' => (int) ( ! $group_info['active']),
            ], 'id=' . (int) (($_GET['id'] ?? null)));
            common()->admin_wall_add(['user group: ' . $group_info['name'] . ' ' . ($group_info['active'] ? 'inactivated' : 'activated'), $group_info['id']]);
        }
        cache_del(['user_groups', 'user_groups_details']);
        if (is_ajax()) {
            no_graphics(true);
            echo $group_info['active'] ? 0 : 1;
        } else {
            return js_redirect(url('/@object'));
        }
    }

    public function add()
    {
        $a = $_POST;
        $a['redirect_link'] = url('/@object');
        return form($a, ['autocomplete' => 'off'])
            ->validate([
                'name' => 'trim|required|alpha_numeric|is_unique[admin_groups.name]',
            ])
            ->db_insert_if_ok('user_groups', ['name', 'go_after_login', 'active'], [])
            ->on_after_update(function () {
                cache_del(['user_groups', 'user_groups_details']);
                common()->admin_wall_add(['user group added: ' . ($_POST['name'] ?? null) . '', db()->insert_id()]);
            })
            ->text('name', 'Group name')
            ->text('go_after_login', 'Url after login')
            ->active_box()
            ->save_and_back();
    }

    public function delete()
    {
        $_GET['id'] = (int) (($_GET['id'] ?? null));
        if ( ! empty($_GET['id'])) {
            db()->query('DELETE FROM ' . db('user_groups') . ' WHERE id=' . (int) (($_GET['id'] ?? null)) . ' LIMIT 1');
            common()->admin_wall_add(['user group deleted: ' . ($_GET['id'] ?? null) . '', ($_GET['id'] ?? null)]);
        }
        cache_del(['user_groups', 'user_groups_details']);
        if (is_ajax()) {
            no_graphics(true);
            echo $_GET['id'] ?? null;
        } else {
            return js_redirect(url('/@object'));
        }
    }

    public function edit()
    {
        $id = (int) (($_GET['id'] ?? null));
        if ( ! $id) {
            return _e('No id');
        }
        $a = db()->query_fetch('SELECT * FROM ' . db('user_groups') . ' WHERE id=' . (int) (($_GET['id'] ?? null)));
        $a['redirect_link'] = url('/@object');
        return form($a, ['autocomplete' => 'off'])
            ->validate([
                'name' => 'trim|required|alpha_numeric|is_unique[admin_groups.name]',
            ])
            ->db_update_if_ok('user_groups', ['name', 'go_after_login'], 'id=' . $id)
            ->on_after_update(function () use ($id) {
                cache_del(['user_groups', 'user_groups_details']);
                common()->admin_wall_add(['user group edited: ' . ($_POST['name'] ?? null) . '', $id]);
            })
            ->text('name', 'Group name')
            ->text('go_after_login', 'Url after login')
            ->save_and_back();
    }

    public function show()
    {
        $blocks = main()->get_data('blocks_all');
        $block_center_id = null;
        foreach ((array) $blocks as $_id => $_info) {
            if ($_info['type'] == 'user' && $_info['name'] == 'center_area') {
                $block_center_id = $_id;
                break;
            }
        }
        $menu_id = db()->get_one('SELECT id FROM ' . db('menus') . ' WHERE type="user" AND active=1 LIMIT 1');
        $tbl = table('SELECT * FROM ' . db('user_groups') . ' ORDER BY id ASC', [
                'custom_fields' => ['members_count' => 'SELECT `group`, COUNT(*) AS num FROM ' . db('user') . ' GROUP BY `group`'],
                'hide_empty' => 1,
            ])
            ->text('name')
            ->text('go_after_login')
            ->text('members_count', ['link' => './?object=manage_users&action=filter_save&page=clear&filter=group:%d', 'link_field_name' => 'id'])
            ->btn_edit(['btn_no_text' => 1])
            ->btn_delete(['btn_no_text' => 1])
            ->btn_active()
            ->footer_add()
            ->footer_link('Blocks', './?object=blocks&action=show_rules&id=' . $block_center_id);
        if ($menu_id) {
            $tbl = $tbl->footer_link('Menu', './?object=menus_editor&action=show_items&id=' . $menu_id);
        }
        $tbl = $tbl->footer_link('Auth fails', './?object=log_user_auth_fails');
        return $tbl;
    }