<?php
include("lib/loader.inc");

class users {

   private $conf;
   private $dbiw;

   function __construct () {
      $this->$conf = Conf::instance();
      $this->$dbiw = new dbiw();
   }

   function getAllGroups () {
     $sql = "select idGroups,groupName from Groups";
     return $this->$dbiw->dbSel($sql);
   }

   function insGroup ($group) {
     $sql = "insert into Groups(groupName)
		values ('$group');";
     $this->$dbiw->dbIns($sql);
   }   

   function getUser ($name) {

     $sql = "select g.idGroups,g.groupName,gu.fullName 
                 from 
                    Groups g, groupUsers gu
                 where 
                   gu.userName='$name' and
                   gu.Groups_idGroups = g.idGroups";

     return $this->$dbiw->dbSel($sql);
   }

   function getAllUsers () {
     $sql = "select gu.idGroupUsers, gu.userName, gu.fullName
               from groupUsers gu";
     return $this->$dbiw->dbSel($sql);
   }
}

?>