<?php

namespace OfficeBrain\Bundle\ProductBundle\Entity;

use Doctrine\ORM\EntityRepository;
/**
 * ProductExtraChargeRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class ProductExtraChargeRepository extends \Doctrine\ORM\EntityRepository
{
	
	public function getQueryBuilder()
	{
		return $this->getEntityManager()->getRepository('OfficeBrainProductBundle:ProductExtraCharge')->createQueryBuilder('pec');
	}
	
	public function setProductExtraCharge($obj,$data)
	{
		$em=$this->getEntityManager();
		if($obj==null){
			$charge = new ProductExtraCharge();
		}else{
			$charge = $obj;
		}
		$charge->setProductId($data['product_id']);
		$charge->setExtraCharge($data['charges']);
		$em->persist($charge);
		$em->flush();
	}
	
	/**
	 * To get request info detail by id
	 */
	public function getExtraChargeByProductId($productId)
	{	
		$queryBuilder = $this->getQueryBuilder();
		$queryBuilder->where('pec.productId = :productId');
		$queryBuilder->setParameter('productId', $productId);
		return $queryBuilder->getQuery()->getOneOrNullResult();
	}
}