<?php

namespace OfficeBrain\Bundle\CategoryBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * CategoryStatusSchedularRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class CategoryStatusSchedularRepository extends EntityRepository
{

	public function setPaginatorService($paginatorService)
	{
		$this->paginatorService = $paginatorService;
	}

	public function addCategoryStatusSchedular($masterID,$categoryStatus,$cname, $status, $id=NULL)
	{
		$em = $this->getEntityManager();
		$obj= new CategoryStatusSchedular();
		if($id!=NULL){
		 $obj=$this->getSchedularCategoryById($id);
		}
		
		$obj->setPmsId($masterID);
		$obj->setCategoryStatus($categoryStatus);
		$obj->setStatus($status);
		$obj->setName($cname);
		$em->persist($obj);
		$em->flush();
		return $obj;
		
	}

	public function setProductCount($obj,$productcount)
	{
		$em = $this->getEntityManager();
		$obj->setProductCount($productcount);
		$em->persist($obj);
		$em->flush();
		return $obj;
		
	}

	public function setEstimateTime($obj,$estimateTime)
	{
		//echo $estimateTime; die;
		$em = $this->getEntityManager();
		$obj->setEstimateTime(new \DateTime(date($estimateTime)));
		$em->persist($obj);
		$em->flush();
		return $obj;
		
	}


	public function getSchedularCategoryById($id){
		$catObj = $this->findOneBy(array('id' => $id));		
		return $catObj;
	}

	public function getAllSynCategoryForChangeStatus($status){
		$queryBuilder=$this->createQueryBuilder('css');
		$queryBuilder->where('css.status = :status')
		->setParameter('status', $status);
		$queryBuilder->orderBy('css.id', 'ASC');
		$queryBuilder->setMaxResults(1);
		return $queryBuilder->getQuery()->getOneOrNullResult();

	}

	public function getCategoryStatusSchedular($page,$recordsPerPage,$searchParameters,$searchKeyWordsArray)
	{
		$queryBuilder=$this->createQueryBuilder('css');
		if (isset($searchKeyWordsArray) and $searchKeyWordsArray!='') 
		{
			foreach ($searchKeyWordsArray as $key=>$val) {
				if ($key != '') {
					if($key == 'status'){
						$queryBuilder->where('css.status = :status')
						->setParameter('status', $val);
					}
					if($key == 'name'){
							
						$queryBuilder->where('css.name LIKE :param')
						->setParameter('param', '%'.$val.'%');
							
					}
				}
			}
		}
		
		$queryBuilder->orderBy('css.status', 'DESC');
		$result = $queryBuilder->getQuery()->getArrayResult();
		return $this->paginatorService->paginate($queryBuilder, $page, $recordsPerPage);
	}

	/*public function updateCategoryParent($mappingObj,$parentID,$image)
	{
		$em = $this->getEntityManager();
		$categoryMappingObj= new CategoryMapping();
		$mappingObj->setParentId($parentID);
		$mappingObj->setImage($image);
		$em->flush();
		return $mappingObj;
	}
	public function getCategoryMapping()
	{
		$query=$this->createQueryBuilder('cm')
		->select('cm.id as local_id, cm.pmsId as pms_id','cm.parentId as parent_id','cm.image','cm.categoryFlag','cm.sortPosition','cm.categoryLink,cm.status')
		->addOrderBy('cm.parentId','ASC')
		->where("cm.deletedAt is NULL");
		return $query->getQuery()->getResult();
	}
	public function getCategoryImageById($categoryId)
	{	
		$query=$this->createQueryBuilder('cm')
		->select('cm.pmsId as pms_id','cm.image')
		->where("cm.pmsId IN(:id)")
		->Andwhere("cm.deletedAt is NULL")
		->setParameter('id', array_values($categoryId));
		return $query->getQuery()->getResult();
	}

	public function updateStatus($pmsId,$status){
		$catObj = $this->getCategoryByPmsId($pmsId);
		if($catObj!=NULL){
			$em = $this->getEntityManager();
			$catObj->setStatus($status);
			$em->flush();
			return $catObj;
		}
	}

	public function getCategoryByPmsId($pmsId){
		$catObj = $this->findOneBy(array('pmsId' => $pmsId,'deletedAt' => NULL));		
		return $catObj;
	}
	public function delete($pmsId){
		$obj = $this->findOneBy(array('pmsId' => $pmsId,'deletedAt' => NULL));
		//$id = $obj->getId();
		$em = $this->getEntityManager();
		$em->remove($obj);
		$em->flush();
		return $obj;
	}
	
	
	public function insertCategoryMapping($masterID, $parentId, $image) {
		
		$em = $this->getEntityManager();
		$categoryMappingObj = $this->findOneBy(array('pmsId' => $masterID,'deletedAt' => NULL));
		$categoryMappingObj = ($categoryMappingObj) ? $categoryMappingObj: new CategoryMapping();
		$categoryMappingObj->setPmsId($masterID);
		$categoryMappingObj->setParentId($parentId);
		$categoryMappingObj->setImage($image);
		$em->persist($categoryMappingObj);
		$em->flush();
		
		return $categoryMappingObj;
	}
	public function updateProductCategoryMapping($productMappedObj,$new_master_id)
	{
		$em = $this->getEntityManager();
		$productMappedObj->setCategoryId($new_master_id);
		$em->persist($productMappedObj);
		$em->flush();
	}
	
	public function updateCategoryMapping($mappingObj,$new_master_id,$parent_id,$categoryImage)
	{
		if($categoryImage==''){
			$categoryImage=NULL;
		}
		$em = $this->getEntityManager();
		$categoryMappingObj= new CategoryMapping();
		$mappingObj->setPmsId($new_master_id);
		$mappingObj->setParentId($parent_id);
		$mappingObj->setImage($categoryImage);
		$em->persist($mappingObj);
		$em->flush();
		return $mappingObj;
	
	}

	public function setCategoryMappingById($catMapId,$pmsId,$catFlag)
	{
		$em = $this->getEntityManager();
		$categoryMappingObj = $this->findOneBy(array('id' => $catMapId,'deletedAt' => NULL));
		$categoryMappingObj->setCategoryFlag($catFlag);
		$em->persist($categoryMappingObj);
		$em->flush();
		return $categoryMappingObj;
	}

	
    public function set($categoryMapObj)
    {
		$em = $this->getEntityManager();
        $this->_em->persist($categoryMapObj);
        return $categoryMapObj;
    } */
}