<?php

namespace OfficeBrain\Bundle\OrderBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * OrderBillingDetailRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class OrderBillingDetailRepository extends EntityRepository
{


    public function getQueryBudler()
    {
        return $this->getEntityManager()->getRepository('OfficeBrainOrderBundle:OrderBillingDetail')->createQueryBuilder('ord');
    }


    public function getBillingDetailsBYOrderId($orderId){

        $query=$this->getQueryBudler();
        $query->select('ord.email','ord.name');
        $query->where("ord.orderMasterId=:id")->setParameter('id', $orderId);
        $result=$query->getQuery()->getOneorNullResult();
        return $result;

    }
}