DHCP/src/KeaBundle/Repository/Lease4Repository.php

<?php

namespace KeaBundle\Repository;

class Lease4Repository extends \Doctrine\ORM\EntityRepository
{

    /**
     * @return array
     */
    public function getAllAddress()
    {
        $qb = $this->createQueryBuilder('Lease4');
        $leases = $qb->getQuery()->getResult();
        
        return array_map(function ($lease) {
            return $lease->getAddress();
        }, $leases);
    }

    /**
     * @param string $hwaddr
     * 
     * @return array
     */
    public function getByHwaddr($hwaddr)
    {
        $qb = $this->createQueryBuilder('Lease4')
            ->where('Lease4.hwaddr = :hwaddr')->setParameter('hwaddr', hex2bin($hwaddr));
        
        return $qb->getQuery()->getOneOrNullResult();
    }

}