<?php

namespace OfficeBrain\CustomBundle\CmsBundle\Entity;

/**
 * CreditApplicationFormRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class CreditApplicationFormRepository extends \Doctrine\ORM\EntityRepository
{
	/**
	 * @author Employee Id: 5497
	 * Description : Get coupon list
	 */
	public function getList($searchQuery = '')
	{
		$query = $this->createQueryBuilder('ca')
		->select('ca');
		if ($searchQuery != '') {
			$query->andWhere('pc.couponName like :searchQuery');
			$query->setParameter(':searchQuery', '%'.$searchQuery.'%');
		}
		$query->orderBy('ca.id', 'DESC');
	
		return $query->getQuery()->getResult();
	}
	
	public function saveFormData($entity)
	{
		$em = $this->getEntityManager();
		$em->persist($entity);
		$em->flush();
		return $entity;
	}
}
