";print_r($result);die();
		//$result = $query->getQuery()->getResult();
		return $result;
    }
    public function deleterecord($id)
    {
    	$entity = $this->createQueryBuilder('f')
			    		->select('f')
			    		->where('f.id = :id')
			    		->setParameter(':id', $id)
			    		->getQuery()
			    		->getOneOrNullResult();
    	
		if ($entity) {
			$entity->setDeletedAt(new \DateTime());
			$entity->setDeletedUid($this->userId);
			$this->_em->persist($entity);
			$this->_em->flush();
			
			return 1;
		} else {
			return 0;
		}	    		
    	/*$em = $this->getEntityManager();
    	$this->dbConnection = $em->getConnection();
    	$query="update tbl_flyers SET deleted_at=now(),deleted_uid=".$this->userId." WHERE id =".$id." ";
    	$statement = $this->dbConnection->prepare($query);
    	$statement->execute();
    	$result = $statement->rowCount();
    	return count($return);*/
    
    }
    public function updateFlyerPosition($query)
    {
    	$em = $this->getEntityManager();
    	$this->dbConnection = $em->getConnection();
    	$statement = $this->dbConnection->prepare($query);
    	$statement->execute();
    	$result = $statement->rowCount();
    	
    	return $result;
    
    }
    public function getFlyerPositionUpdateQuery($id,$pos_val)
    {
    	$query="update tbl_flyers SET sort_position=$pos_val WHERE id ='$id';";
    	return $query;
    
    }
    
    public function findsubCategories($subids)
    {
    	$em = $this->getEntityManager();
    	$this->dbConnection = $em->getConnection();
    	$query="SELECT t1.id,t1.title,(SELECT GROUP_CONCAT(DISTINCT t2.id) FROM tbl_flyers AS t2 WHERE t1.id = t2.flyers_category_id) AS flyerid FROM tbl_flyers_category AS t1 WHERE t1.id IN ($subids) AND t1.deleted_at IS NULL";
    	$statement = $this->dbConnection->prepare($query);
    	$statement->execute();
    	$result = $statement->fetchAll();
    	//echo"
";print_r($result);die();
    	//$result = $query->getQuery()->getResult();
    	return $result;
    } 
    

    public function updateFlyerPositionById($id, $position) {
    	$entity = $this->createQueryBuilder('f')
    	->select('f')
    	->where('f.id = :id')
    	->setParameter(':id', $id)
    	->getQuery()
    	->getOneOrNullResult();

    	if ($entity) {
    		$entity->setSortPosition($position);
    		$entity->setDeletedUid($this->userId);
    		$this->_em->persist($entity);
    		$this->_em->flush();
    	}
    }
}