group_permission.php

<?php
 
if (!defined('XOOPS_ROOT_PATH')) {
    exit();
}
 
class LegacyGroup_permissionObject extends XoopsSimpleObject
{
    public function LegacyGroup_permissionObject()
    {
        self::__construct();
    }
 
    public function __construct()
    {
        static $initVars;
        if (isset($initVars)) {
            $this->mVars = $initVars;
            return;
        }
        $this->initVar('gperm_id', XOBJ_DTYPE_INT, '', true);
        $this->initVar('gperm_groupid', XOBJ_DTYPE_INT, '0', true);
        $this->initVar('gperm_itemid', XOBJ_DTYPE_INT, '0', true);
        $this->initVar('gperm_modid', XOBJ_DTYPE_INT, '0', true);
        $this->initVar('gperm_name', XOBJ_DTYPE_STRING, '', true, 50);
        $initVars=$this->mVars;
    }
}
 
class LegacyGroup_permissionHandler extends XoopsObjectGenericHandler
{
    public $mTable = 'group_permission';
    public $mPrimary = 'gperm_id';
    public $mClass = 'LegacyGroup_permissionObject';

    public function getRolesByModule($mid, $groups)
    {
        $retRoles = [];
 
        $sql = 'SELECT gperm_name FROM ' . $this->mTable . ' WHERE gperm_modid=' . (int)$mid . ' AND gperm_itemid=0 AND ';
        $groupSql = [];
 
        foreach ($groups as $gid) {
            $groupSql[] = 'gperm_groupid=' . (int)$gid;
        }
 
        $sql .= '(' . implode(' OR ', $groupSql) . ')';
 
        $result = $this->db->query($sql);
 
        if (!$result) {
            return $retRoles;
        }
 
        while ($row = $this->db->fetchArray($result)) {
            $retRoles[] = $row['gperm_name'];
        }
 
        return $retRoles;
    }
}