Doctrine model

Role.php

<?php
namespace Nas\UsersModule\Model;

/**
 * @ORM\Entity
 * @ORM\Table(name="roles")
 */
class Role extends Object
{
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue
     * @var int
     */
    protected $id;

	/**
	 * @ORM\Column
	 * @var string
	 */
	protected $slug;

	/**
	 * @ORM\Column(name="users_id", type="integer")
	 * @var string
	 */
	protected $userId;


	/**
	 * @ManyToOne(targetEntity="User", inversedBy="roles")
	 * @JoinColumn(name="users_id", referencedColumnName="id")
	 **/
	private $user;

    /**
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }


	/**
	 * @return string
	 */
	public function getSlug()
	{
		return $this->slug;
	}


	/**
	 * @param string $slug
	 * @return Role
	 */
	public function setSlug($slug)
	{
		$this->slug = $slug;
		return $this;
	}


	/**
	 * @return string
	 */
	public function getUserId()
	{
		return $this->userId;
	}


	/**
	 * @param int $id
	 * @return Role
	 */
	public function setUserId($id)
	{
		$this->userId = $id;
		return $this;
	}

}

RolesFacade.php

<?php
namespace Nas\UsersModule\Model;

class RolesFacade extends Object
{
	/** @var EntityDao */
	private $dao;


	/**
	 * @param EntityManager $em
	 */
	public function __construct(EntityManager $em)
	{
		$this->dao = $em->getDao('\Nas\UsersModule\Model\Role');
	}


	/**
	 * @return EntityDao
	 */
	public function getRoleDao()
	{
		return $this->dao;
	}


	/**
	 * @param Role $entity
	 * @return array|Role
	 */
	public function save(Role $entity)
	{
		return $this->dao->save($entity);
	}


	/**
	 * @return ResultSet
	 */
	public function findAll()
	{
		$qb = $this->dao->createQueryBuilder('r');
		return new ResultSet($qb->getQuery());
	}

}

User.php

<?php
namespace Nas\UsersModule\Model;

/**
 * @ORM\Entity
 * @ORM\Table(name="users")
 */
class User extends Object
{
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue
     * @var int
     */
    protected $id;

	/**
	 * @ORM\Column
	 * @var string
	 */
	protected $name;

	/**
	 * @OneToMany(targetEntity="Role", mappedBy="user")
	 * @var ArrayCollection|Role[]
	 **/
	protected $roles;

    /**
     * @return int
     */
    public function getId()
    {
        return $this->id;
    }

	/**
	 * @return string
	 */
	public function getName()
	{
		return $this->name;
	}


	/**
	 * @param string $name
	 * @return User
	 */
	public function setName($name)
	{
		$this->name = $name;
		return $this;
	}


	public function getRoles()
	{
		return $this->roles;
	}

}

UsersFacade.php

<?php
namespace Nas\UsersModule\Model;

class UsersFacade extends Object
{
	/** @var EntityDao */
	private $dao;


	/**
	 * @param EntityManager $em
	 */
	public function __construct(EntityManager $em)
	{
		$this->dao = $em->getDao('\Nas\UsersModule\Model\User');
	}


	/**
	 * @return EntityDao
	 */
	public function getUserDao()
	{
		return $this->dao;
	}


	/**
	 * @param User $entity
	 * @return array|User
	 */
	public function save(User $entity)
	{
		return $this->dao->save($entity);
	}


	/**
	 * @return ResultSet
	 */
	public function findAll()
	{
		$qb = $this->dao->createQueryBuilder('u');
		return new ResultSet($qb->getQuery());
	}

}