<?php

namespace OfficeBrain\Bundle\QuoteBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * QuoteVariationMasterRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class QuoteVariationMasterRepository extends EntityRepository
{
    /**
     * @author Employee Id: 4160
     * OB eCommerce Product - QuoteVariationMaster
     * Function created for define a common querybuilder object
     * @return object
     */
    public function getQueryBuilder()
    {
        return $this->getEntityManager()->getRepository('OfficeBrainQuoteBundle:QuoteVariationMaster')->createQueryBuilder('qvm');
    }
    
    /**
     * @author Employee Id: 4160
     * OB eCommerce Product - QuoteVariationMaster
     * Function created for get record based on erp id
     * @return object
     */
    public function getVariationMasterByErpId($erpId)
    {
        $queryBuilder = $this->getQueryBuilder();
        $queryBuilder->select('qvm')
                    ->where('qvm.erpId  =:erp_id')
                    ->setParameter('erp_id', $erpId);
        return $queryBuilder->getQuery()->getOneOrNullResult();
    }
}