user.php

Go to the documentation of this file.

<?php
// $Id: image.php 825 2011-12-09 00:06:11Z i.bitcero $
// --------------------------------------------------------------
// Red México Common Utilities
// A framework for Red México Modules
// Author: Eduardo Cortés <i.bitcero@gmail.com>
// Email: i.bitcero@gmail.com
// License: GPL 2.0
// --------------------------------------------------------------

class RMUser extends RMObject
{
    private $groups = array();
    
    public function __construct($id=''){
        
        $this->db = XoopsDatabaseFactory::getDatabaseConnection();
        $this->_dbtable = $this->db->prefix("users");
        $this->setNew();
        $this->initVarsFromTable();
        
        if ($this->loadValues($id)){
            $this->unsetNew();
            return;
        }
        
        $this->primary = 'uname';
        if($this->loadValues($id))
            $this->unsetNew ();
        
        $this->primary = 'uid';
        
    }
    
    function setGroups($groupsArr){
        $this->groups = array();
        if (is_array($groupsArr))
            $this->groups =& $groupsArr;
    }
    
    public function &getGroups(){
        
        if (!empty($this->groups)) return $this->groups;
        
        $sql = 'SELECT groupid FROM '.$this->db->prefix('groups_users_link').' WHERE uid='.intval($this->getVar('uid'));
        $result = $this->db->query($sql);
                
        if (!$result) {
            return false;
        }
        while ($myrow = $this->db->fetchArray($result)) {
            $this->groups[] = $myrow['groupid'];
        }
        
        return $this->groups;
    }
    
    function groups($data=false, $fields='groupid'){
        $groups =& $this->getGroups();
        
        if (!$data || $fields=='') return $groups;
        
        // Gets all groups based in their id
        $sql = "SELECT ".($fields!='' ? "$fields" : '')." FROM ".$this->db->prefix("groups")." WHERE groupid IN(".implode(',',$groups).")";
        $result = $this->db->query($sql);
        $groups = array();
        while ($row = $this->db->fetchArray($result)){
                        $groups[] = $row;
        }
        return $groups;
    }
    
    function save(){
        $ret = true;
        if ($this->isNew()){
            $ret = $this->saveToTable();
        } else {
            $ret = $this->updateTable();
        }
        if (!$ret) return $ret;
        if (!empty($this->groups)){
            if (!$this->isNew())
                $this->db->queryF("DELETE FROM ".$this->db->prefix("groups_users_link")." WHERE uid='".$this->getVar('uid')."'");
                
            $sql = "INSERT INTO ".$this->db->prefix("groups_users_link")." (`groupid`,`uid`) VALUES ";
            foreach ($this->groups as $k){
                $sql .= "('$k','".$this->getVar('uid')."'),";
            }

            $sql = substr($sql, 0, strlen($sql) - 1);

            $this->db->queryF($sql);
        }
            
        return $ret;
                
    }
    
}