railpage/railpagecore

<?php

/**
 * Base user groups class
 * @since Version 3.5
 * @package Railpage 
 * @author Michael Greenhill
 */
 
// GROUP_OPEN = 0
// GROUP_CLOSED = 1
// GROUP_HIDDEN = 2

namespace Railpage\Users; 

use Railpage\Organisations\Factory as OrganisationsFactory;
use Railpage\Organisations\Organisation;
use Railpage\AppCore;
use Exception;

/**
 * Groups class
 */

class Groups extends AppCore {
    
    /**
     * Const: open group
     * @since Version 3.9
     * @const GROUP_OPEN
     */
    
    const GROUP_OPEN = 0;
    
    /**
     * Const: open group
     * @since Version 3.9
     * @const GROUP_CLOSED
     */
    
    const GROUP_CLOSED = 1;
    
    /**
     * Const: open group
     * @since Version 3.9
     * @const GROUP_HIDDEN
     */
    
    const GROUP_HIDDEN = 2;
    
    /**
     * List all groups
     * @since Version 3.5
     * @param int $maxLevel
     */
    
    public function getGroups($maxLevel = 0) {
        $query = "SELECT g.group_id AS id, g.organisation_id, g.group_name AS name, g.group_type AS type, g.group_description AS description, 
                    g.group_attrs, g.group_moderator AS owner_user_id, u.username AS owner_username 
                FROM nuke_bbgroups AS g 
                    INNER JOIN nuke_users AS u ON g.group_moderator = u.user_id 
                WHERE g.group_single_user = 0 
                    AND g.group_type <= ? ORDER BY g.group_name";
        
        $return = array(); 
        
        foreach ($this->db->fetchAll($query, $maxLevel) as $row) {
            $row['group_attrs'] = !empty($row['group_attrs']) ? json_decode($row['group_attrs'], true) : array();
            
            if (filter_var($row['organisation_id'], FILTER_VALIDATE_INT)) {
                $Organisation = OrganisationsFactory::CreateOrganisation($row['organisation_id']); 
                $row['organisation_name'] = $Organisation->name;
            }
            
            ksort($row);
            $return[$row['id']] = $row; 
        }
            
        return $return;
    }
    
    /**
     * Find groups with a specific attribute
     * @since Version 3.8
     * @param string $attribute
     * @param mixed $value
     * @return array
     */
    
    public function findWithAttribute($attribute = null, $value = null) {
        
        if ($attribute == null) {
            throw new Exception("Cannot filter groups by attribute - no attribute given!"); 
        }
        
        $groups = $this->getGroups(); 
        
        foreach ($groups as $id => $group) {
            if (!isset($group['group_attrs'][$attribute])) {
                unset($groups[$id]);
                continue;
            }
            
            if ($value =! null && $group['group_attrs'][$attribute] != $value) {
                unset($groups[$id]);
                continue;
            }
        }
        
        return $groups;
    }
}