<?php

namespace OfficeBrain\Bundle\SocialMediaBundle\Entity;

use Doctrine\ORM\EntityRepository;
/**
 * SocialMediaRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class SocialMediaRepository extends \Doctrine\ORM\EntityRepository
{
	public $em;
	public function init(){
		$this->em = $this->getEntityManager();
	}
	public function saveFormData($formData){
		$this->init();
		// Call Delete Record
		$deleteRecord = $this->deleteData($formData->getType());
		
		// For Insert New Record
		$this->em->persist($formData);
		$this->em->flush();
		return $socialMediaObj;
	}
	public function deleteData($type){
		$this->init();
		$deletedData = $this->findOneBy(array('type' => $type));
		if(count($deletedData)){
			$this->em->remove($deletedData);
			$this->em->flush();
		}
		return count($deletedData);
	}
	public function getFormData($type){
		$this->init();
		$queryBuilder = $this->em->createQueryBuilder();
		$query = $queryBuilder->select('sm.id, sm.facebookSocialCode, sm.twitterSocialCode, sm.linkedinSocialCode, sm.instagramSocialCode, sm.pinterestSocialCode, sm.googleSocialCode')
		->from('OfficeBrainSocialMediaBundle:SocialMedia','sm')
		->where('sm.type = :type')
		->setParameter('type',$type);
		$data = $query->getQuery()->getResult();
		return $data;
	}
}