<?php

namespace OfficeBrain\Bundle\CategoryBundle\Entity;

/**
 * CultureCategoryMappingRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class CultureCategoryMappingRepository extends \Doctrine\ORM\EntityRepository
{
	public function setCultureCategoryMapping($categoryData,$pmsId,$cultureId){
		$em = $this->getEntityManager();
		$cultureCategoryMappingObj= new CultureCategoryMapping();
		$cultureCategoryMappingObj->setPmsId($pmsId);
		$cultureCategoryMappingObj->setKeywords(isset($categoryData['keywords'])?$categoryData['keywords']:'');
		$cultureCategoryMappingObj->setDescription(isset($categoryData['description'])?$categoryData['description']:'');
		$cultureCategoryMappingObj->setCultureId($cultureId);
		$em->persist($cultureCategoryMappingObj);
		$em->flush();
		return $cultureCategoryMappingObj;
	}
	public function updateCultureCategoryMapping($categoryData,$mappingObj){
		$em = $this->getEntityManager();
		$cultureCategoryMappingObj= new CultureCategoryMapping();
		$mappingObj->setKeywords(isset($categoryData['keywords'])?$categoryData['keywords']:'');
		$mappingObj->setDescription(isset($categoryData['description'])?$categoryData['description']:'');
		$em->flush();
		return $mappingObj;
	}
	public function getCultureCategoryMapping($pmsId,$cultureId){
		$query=$this->createQueryBuilder('ccm')
		->select('ccm.id,ccm.keywords,ccm.description')
		->where("ccm.pmsId = :pms_id")
		->setParameter("pms_id",$pmsId)
		->andWhere("ccm.cultureId = :culture_id")
		->setParameter("culture_id",$cultureId);
		return $query->getQuery()->getResult();
	}
	public function removeCultureCategoryMapping($mappingObj){
		$em = $this->getEntityManager();
		$em->remove($mappingObj);
		$em->flush();
		return $mappingObj;
	}
}