## REPO

<?php

namespace UCPG\Entity\Repository;

use Doctrine\ORM\EntityRepository,
    UCPG\Entity\User,
    UCPG\Entity\Account,
    UCPG\Entity\Praktijk;

/**
 * AccountRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class AccountRepository extends EntityRepository
{
    CONST ACCOUNT_NOT_FOUND = 1;
    CONST WRONG_PASSWORD = 2;
    /**
     * @var	string	Tijdelijke container voor gebruikersnaam
     */
    public $username;
    /**
     * @var	string	Tijdelijke container voor wachtwoord
     */
    public $password;
    /**
     * @param string $username
     * @param string $password
     * @return Account
     * @throws Exception
     */
    public function authenticate($username, $password)
    {
        $account = $this->findOneBy(array('username' => $username));
        \Doctrine\Common\Util\Debug::dump($account); die();
        if ($account) {
            if($account->getPassword() === $password)
                return $account;
            throw new \Exception(self::WRONG_PASSWORD);
        }
        throw new \Exception(self::ACCOUNT_NOT_FOUND);
    }
    /**
     * Return aantal account met specifieke rol
     * @param	array	$roles
     * @return	int
     */
    public function count(array $roles, Praktijk $praktijk = null)
    {
        $i = 0;
        $query = 'SELECT COUNT(u.id) FROM UCPG\Entity\Account u WHERE';
        if ($praktijk instanceof Praktijk) $query .= ' u.user_praktijk_id = ' . $praktijk->getId() . ' AND (';
        foreach ($roles as $role)
        {
            $query .= ($i !== 0) ? " OR u.role = '$role'" : " u.role = '$role'";
            $i++;
        }
        if ($praktijk instanceof Praktijk) $query .= ')';
        return $this->_em->createQuery($query)->getSingleScalarResult();
    }
    /**
     * Aanmaken account
     * @param	Account	$entity
     */
    public function create(Account $entity)
    {
        $this->username = $this->defaultUsername($entity->getUser());
        $this->password = $this->createPassword();

        $entity->setUsername($this->username);
        $entity->setPassword(md5($this->password));

        $this->_em->persist($entity);
        $this->_em->persist($entity->getUser());
        $this->_em->flush();

        return $this;
    }
    /**
     * Return default username from User object
     * @param	User 	$entity
     * @return	string				Default username as string
     */
    public function defaultUsername(User $entity)
    {
        return strtolower(substr($entity->getFirstname(), 0, 4) . substr($entity->getLastname(), 0, 4) . $entity->getDob()->format('d'));
    }
    /**
     * Verwijder account
     * @param	Account	$entity
     */
    public function delete(Account $entity)
    {
        $this->_em->remove($entity);
        $this->_em->remove($entity->getUser());
        $this->_em->flush();
    }
    /**
     * Return Accounts with specified roles
     * @param	array	$roles
     * @return	array
     */
    public function findByRoles(array $roles)
    {
        $i = 0;
        $query = 'SELECT u FROM UCPG\Entity\Account u WHERE';
        foreach ($roles as $role)
        {
            $query .= ($i !== 0) ? " OR u.role = '$role'" : " u.role = '$role'";
            $i++;
        }
        return $this->_em->createQuery($query)->getResult();
    }
    /**
     * Aanpassen account
     * @param	Account	$entity
     */
    public function update(Account $entity)
    {
        $this->username = $this->defaultUsername($entity->getUser());
        $this->password = $this->createPassword();

        $entity->setUsername($this->username);
        $entity->setPassword(md5($this->password));

        $this->_em->persist($entity->getUser());
        $this->_em->persist($entity);
        $this->_em->flush();

        return $this;
    }
    /**
     * Generate standard password
     * @return	string	$password
     */
	private function createPassword()
	{
		$arrayChar = array('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z','1','2','3','4','5','6','7','8','9','0');
		$password = '';
		for($i=0;$i<8;$i++) {
			$randomValue = rand(0,35);
			$password .= $arrayChar[$randomValue];
		}
		return $password;
	}
}

## ADAPTER

<?php
/**
 * Authentication adapter for doctrine
 *
 * @author Martijn Swaagman
 * @copyright Prestar
 * @version 1.0
 */
class UCPG_Auth_Adapter implements Zend_Auth_Adapter_Interface
{
    const SUCCESS_MSG = 'U bent succesvol ingelogd!';
    const ACCOUNT_NOT_FOUND_MSG = 'Account niet gevonden!';
    const WRONG_PASSWORD_MSG = 'Onjuist wachtwoord voor account!';
    /**
     * Doctrine Account object
     * @var Account
     */
    private $account;
    /**
     * Username of user
     * @var string
     */
    private $username;
    /**
     * Password of user (md5)
     * @var string
     */
    private $password;
    /**
     * @param	string	$username
     * @param	string	$password
     */
    public function __construct($username = null, $password = null)
    {
        $this->username = (!is_null($username)) ? (string) $username : null;
        $this->password = (!is_null($password)) ? (string) md5($password) : null;
    }
    /**
     * (non-PHPdoc)
     * @see Zend_Auth_Adapter_Interface::authenticate()
     */
    public function authenticate()
    {
        try {
            $doctrine = Zend_Registry::get('doctrine');
            $em = $doctrine->getEntityManager();
            $this->account = $em->getRepository('UCPG\Entity\Account')
                                ->authenticate($this->username, $this->password);
            return $this->createResult(Zend_Auth_Result::SUCCESS, UCPG_Auth_Result::TYPE_SUCCESS, self::SUCCESS_MSG);
        } catch (Exception $e) {
            if ($e->getMessage() == UCPG\Entity\Repository\AccountRepository::ACCOUNT_NOT_FOUND)
                return $this->createResult(Zend_Auth_Result::FAILURE_IDENTITY_NOT_FOUND, UCPG_Auth_Result::TYPE_ERROR, self::ACCOUNT_NOT_FOUND_MSG);
            if ($e->getMessage() == UCPG\Entity\Repository\AccountRepository::WRONG_PASSWORD)
                return $this->createResult(Zend_Auth_Result::FAILURE_CREDENTIAL_INVALID, UCPG_Auth_Result::TYPE_ERROR, self::WRONG_PASSWORD_MSG);
        }
    }
    /**
     * Standard Authentication response
     * @param	Zend_Auth_Result::CONST		$code
     * @param	array						$messages	Message for user
     * @return	Zend_Auth_Result
     */
    private function createResult($code, $type, $messages)
    {
        return new UCPG_Auth_Result($code, $this->account, $type, array($messages));
    }
}