Manage user tasks/groups

[whisher06]

Hi all.
After the authentication I've also
to manage the task and the group
of the user.
I've managed this code:

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_workgroup` smallint(5) unsigned NOT NULL default '0',
  `uname` varchar(50) NOT NULL default '0',
  `surname` varchar(50) NOT NULL default '0',
  `username` varchar(32) NOT NULL default '0',
  `password` char(40) NOT NULL default '0',
  `email` varchar(100) NOT NULL default '0',
  `logged` datetime NOT NULL default '0000-00-00 00:00:00',
  `uid` char(40) NOT NULL default '0',
  `is_admin` enum('0','1') NOT NULL default '0',
  `type` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `username` (`username`),
  KEY `uid` (`uid`)
) 
CREATE TABLE `workgroups` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
)

CREATE TABLE `tasks` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `id_workgroup` smallint(5) unsigned NOT NULL,
  `settings_r` enum('0','1') NOT NULL default '0',
  `settings_u` enum('0','1') NOT NULL default '0',
  `operator_c` enum('0','1') NOT NULL default '0',
  `operator_r` enum('0','1') NOT NULL default '0',
  `operator_u` enum('0','1') NOT NULL default '0',
  `operator_d` enum('0','1') NOT NULL default '0',
  `user_c` enum('0','1') NOT NULL default '0',
  `user_r` enum('0','1') NOT NULL default '0',
  `user_u` enum('0','1') NOT NULL default '0',
  `user_d` enum('0','1') NOT NULL default '0',
  `category_c` enum('0','1') NOT NULL default '0',
  `category_r` enum('0','1') NOT NULL default '0',
  `category_u` enum('0','1') NOT NULL default '0',
  `category_d` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) 

and check by php with a thing like this:

private function setData(){
		$sql= "SELECT u.id AS _id, u.id_workgroup AS wid, u.name AS uname , u.surname, u.username, u.email, u.logged, u.is_admin, u.type, 
		w.name, t.* FROM users AS u
		LEFT JOIN workgroups AS w ON u.id_workgroup= w.id
		LEFT JOIN tasks AS t ON u.id_workgroup= t.id_workgroup
		WHERE u.uid='".$this->getUid()."'";
		$sth= $this->pdo->prepare($sql);
		$sth->execute();
		$this->data= $sth->fetch(PDO::FETCH_ASSOC);
	}

public function hasPrivilege($task){
		if(isset($this->data[$task])){
			return (bool)$this->data[$task];
		}
		return false;
	}

What do you think about it ?

Bye.

[whisher06]

Hi.
I've made a bright idea
(at least I think so 😉 )

class classes_Operator{
	protected $id= 0; 
	protected $id_workgroup= 0;
 	protected $uname= '';
	protected $surname=	''; 
	protected $username= '';
 	protected $password= '';
 	protected $email= ''; 
	protected $logged= '';
	protected $uid= '';
 	protected $is_admin= 0;
	protected $type= 0;
	protected $workgroup= '';
	public function __construct(){}
	public function getData(){
		return array(ucfirst($this->uname),ucfirst($this->surname));
	}
	public function getWorkgroupId(){
		return $this->id_workgroup;
	}
}
class classes_Tasks{
	protected $id= 0; 
	protected $id_workgroup= 0;
 	protected $operator_c= 0;
	protected $operator_r=	0; 
	protected $operator_u= 0;
 	protected $operator_d= 0;
 	public function __construct(){}
	public function operator_c(){
		return (bool)$this->operator_c;
	}
	public function operator_r(){
		return (bool)$this->operator_r;
	}
	public function operator_u(){
		return (bool)$this->operator_u;
	}
	public function operator_d(){
		return (bool)$this->operator_d;
	}
//and so on 
}
public function setOperator(){
		$sql = "SELECT u.id, u.id_workgroup, u.uname , u.surname, u.username, u.email, u.logged, u.is_admin, u.type, 
		w.name AS workgroup FROM users AS u
		INNER JOIN workgroups AS w ON u.id_workgroup= w.id
		WHERE u.type='1' AND u.uid=:uid LIMIT 0 ,1";
		$sth= $this->tableGateway->pdo()->prepare($sql);
		$sth->execute(array(':uid'=>$this->getSessionUid()));
 		$operator= $sth->fetchObject('classes_Operator');
		$sth= null;
		return $operator;
	}
	public function setTasks(classes_Operator $operator){
		$sql = "SELECT * FROM tasks WHERE id_workgroup=:id_workgroup LIMIT 0 ,1";
		$sth= $this->tableGateway->pdo()->prepare($sql);
		$sth->execute(array(':id_workgroup'=>$operator->getWorkgroupId()));
 		$tasks= $sth->fetchObject('classes_Tasks');
		$sth= null;
		return $tasks;
	}

I think it's slight better.
What do you think about ?

Bye.