class PrivilegedUser extends Goodies
{
    private $roles;

    public function __construct() {
    }

    public static function getByUsername($username) {

        $sql = "SELECT * FROM crm_utilizadores WHERE u_username = '".$username."' ";

        $result_sql = mysql_query($sql);

        $row = mysql_fetch_array($result_sql);

        if (!empty($row)) {
            $privUser = new PrivilegedUser();
            $privUser->user_id = $row[0]["u_cod"];
            $privUser->username = $username;
            $privUser->password = $row[0]["u_password"];
            $privUser->email_addr = $row[0]["u_email"];
            $privUser->initRoles($row["u_cod"]);
            return $privUser;
        } else {
            return false;
        }
    }


    //realiza a busca dos papeis do utilizador em questão
    protected function initRoles($userID) {

        $this->roles = array();
        $sql = "SELECT t1.role_id, t2.role_name FROM user_role as t1
                JOIN roles as t2 ON t1.role_id = t2.role_id
                WHERE t1.user_id = '".$userID."' ";

        $result_sql = mysql_query($sql);

        while($row = mysql_fetch_array($result_sql)){
            $this->roles[$row["role_name"]] = Role::getRolePerms($row["role_id"]);
        }
    }

    // check if user has a specific privilege
    public function hasPrivilege($perm) {
        foreach ($this->roles as $role) {
            if ($role->hasPerm($perm)) {
                return true;
            }
        }
        return false;
        //return true;
    }
}