membership.php

Go to the documentation of this file.

<?php
use Xoops\Core\Database\Connection;
use Xoops\Core\Kernel\XoopsObject;
use Xoops\Core\Kernel\XoopsPersistableObjectHandler;

class XoopsMembership extends XoopsObject
{
    public function __construct()
    {
        $this->initVar('linkid', XOBJ_DTYPE_INT, null, false);
        $this->initVar('groupid', XOBJ_DTYPE_INT, null, false);
        $this->initVar('uid', XOBJ_DTYPE_INT, null, false);
    }

    public function id($format = 'n')
    {
        return $this->linkid($format);
    }

    public function linkid($format = '')
    {
        return $this->getVar('linkid', $format);
    }

    public function uid($format = '')
    {
        return $this->getVar('uid', $format);
    }

}

class XoopsMembershipHandler extends XoopsPersistableObjectHandler
{
    public function __construct(Connection $db = null)
    {
        parent::__construct($db, 'groups_users_link', 'XoopsMembership', 'linkid', 'groupid');
    }

    public function getGroupsByUser($uid)
    {
        $ret = array();
        $qb = $this->db2->createXoopsQueryBuilder();
        $eb = $qb->expr();
        $qb ->select('groupid')
            ->fromPrefix('groups_users_link', 'g')
            ->where($eb->eq('g.uid', ':uid'))
            ->setParameter(':uid', $uid, \PDO::PARAM_INT);
        $result = $qb->execute();
        while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {
            $ret[] = $myrow['groupid'];
        }

        return $ret;
    }

    public function getUsersByGroup($groupid, $limit = 0, $start = 0)
    {
        $ret = array();
        $qb = $this->db2->createXoopsQueryBuilder();
        $eb = $qb->expr();
        $qb ->select('uid')
            ->fromPrefix('groups_users_link', 'g')
            ->where($eb->eq('g.groupid', ':gid'))
            ->setParameter(':gid', $groupid, \PDO::PARAM_INT);
        if ($limit!=0 || $start!=0) {
            $qb->setFirstResult($start)
                ->setMaxResults($limit);
        }
        $result = $qb->execute();
        while ($myrow = $result->fetch(\PDO::FETCH_ASSOC)) {
            $ret[] = $myrow['uid'];
        }

        return $ret;
    }
}