class AgreementRepository extends \Doctrine\ORM\EntityRepository
{
    public function findAllByNumber($number)
    {
        return $this->createQueryBuilder('m')
            ->where('m.zipcode LIKE :number')
            ->orWhere('m.meter_zipcode LIKE :number')
            ->setParameter('number', '%' . $number .'%')
            ->getQuery()
            ->getResult();
    }
}