';print_r($queryBuilder->getQuery()->getSQl());die;
    	return $queryBuilder->getQuery()->getResult(); */
    	
    	
    	$queryBuilder = $this->getQueryBuilder()->select('om','ol');
    	$queryBuilder->leftJoin('om.orderItemLine', 'ol');
    	/* $queryBuilder->leftJoin('ol.orderProduct', 'op');
    	$queryBuilder->leftJoin('op.orderVariationMaster', 'ovm');
    	$queryBuilder->leftJoin('op.orderShippingDetail', 'os'); */
    	$queryBuilder->leftJoin('OfficeBrainUserBundle:User', 'u', 'WITH', 'u.id=om.userId');
    	$queryBuilder->leftJoin('OfficeBrainRequestInfoBundle:GuestUser', 'gu', 'WITH', 'gu.id=om.guestId');
    		
    	if (isset($searchKeyWordsArray) and $searchKeyWordsArray!='')
    	{
    		foreach ($searchKeyWordsArray as $key=>$val) {
    			if ($key != '') {
    				if($key == 'email'){
    					$queryBuilder->where('u.email LIKE :param')
    					->orWhere('gu.email LIKE :param')
    					->setParameter('param', $val);
    				}else if($key == 'name'){
    					$name = explode(' ', $val);
    					if(count($name)>1){
    						$queryBuilder->where('u.firstName LIKE :param')
    						->orWhere('u.lastName LIKE :param1')
    						->orWhere('gu.firstName LIKE :param')
    						->orWhere('gu.lastName LIKE :param1')
    						->setParameter('param', '%'.$name[0].'%')
    						->setParameter('param1', '%'.$name[1].'%');
    					}else{
    						$queryBuilder->where('u.firstName LIKE :param')
    						->orWhere('u.lastName LIKE :param')
    						->orWhere('gu.firstName LIKE :param')
    						->orWhere('gu.lastName LIKE :param')
    						->setParameter('param', '%'.$name[0].'%');
    					}
    				}else if($key == 'date'){
    					if(!empty($searchParameters)){
    						if(($searchParameters['start_date'] !='') && ($searchParameters['end_date'] !='')){
    							$queryBuilder->add('where', "om.createdAt between '".$searchParameters['start_date']."' and '".$searchParameters['end_date']."'");
    						}
    					}
    				}
    				else{
    					$param = 'order'.$key;
    					$queryBuilder->andWhere('om.'.$key.' LIKE :'.$param)->setParameter($param, '%'. $val .'%');
    				}
    			}
    		}
    	}
    	$prefferedDistributorId =1;
    	$queryBuilder->andWhere('om.deletedAt IS NULL AND om.instanceId = :instanceId AND om.prefferedDistributorId = :userId');
    	$queryBuilder->setParameter('instanceId', $this->instanceId);
    	$queryBuilder->orderBy('om.id', 'DESC');
    	$queryBuilder->setParameter('userId', $prefferedDistributorId);
    	//$result = $queryBuilder->getQuery()->getArrayResult();
    	$result = $queryBuilder->getQuery()->getResult();
    	return $result;
    	//return $this->paginatorService->paginate($queryBuilder, $page, $recordsPerPage);
    }

    public function getLastInsertedOrder()
	{
		$queryBuilder = $this->getQueryBuilder();
		$queryBuilder->orderBy('om.id', 'DESC')
					 ->setMaxResults(1);
		$orderObj = $queryBuilder->getQuery()->getOneOrNullResult();
		$serialOrderNumber = 'WEB-215200';
		if($orderObj!=Null){
			$orderNo = $orderObj->getOrderNo();
			if($orderNo!=NULL){
				$orderNumber = explode('-',$orderNo);
				$serialOrderNumber = 'WEB-'.($orderNumber[1]+1);
			}
		}
		return $serialOrderNumber;
	}

    /**
	 * 4248
	 * To push all request quote data in database using TCL
	 */
	public function setGuestOrderData($productDetail,$productInput,$userId)
	{

		$orderMaster = new OrderMaster();
		$orderMaster->setUserId($userId);
		$orderMaster->setUserType('registered');
		$orderMaster->setInstanceId($this->instanceId);
		$orderMaster->setInstanceType($this->instanceType);
		$orderMaster->setPrice($productInput['paymentAmount']);
		$orderMaster->setTaxTotal($productInput['tax_total']);
		$orderMaster->setPoNumber(isset($productInput['poNumber'])?$productInput['poNumber']:NULL);
		$orderMaster->setTransactionId($productInput['transactionId']);
		$orderMaster->setPaymentMethod($productInput['paymentmethod']);
		$orderMaster->setPrefferedDistributorId($productInput['pref_dist']);
		$orderMaster->setOrderNo($productInput['order_no']);
        $orderMaster->setCulture($this->cultureCode);
        $orderMaster->setErpId($this->erpId);
		$this->em->getConnection()->beginTransaction();
		try
		{
			$this->em->persist($orderMaster);
			$this->em->flush();
			// One to One
			$this->setOrderBillingDetail($orderMaster);
			// One to Many
			$this->setGuestOrderItemLine($orderMaster, $productDetail,$productInput);
			$this->em->getConnection()->commit();
		}
		catch (\Exception $e)
		{
			$this->em->getConnection()->rollback();
			$this->em->close();
	
			throw $e;
		}
		return array("status"=>"success","data"=>$orderMaster); 
	}

	public function setGuestOrderItemLine($orderMaster, $productDetail, $productInput){	
	    $shippingId=$productInput['guest_shipping_id'];	
		if(count($productInput)>0){
			foreach($productInput['productData'] as $key=> $data){
				$orderItemLine = new OrderItemLine();
				$orderItemLine->setOrderMasterId($orderMaster);
				$orderItemLine->setProductId($data['product_id']);
				if($productInput[$data['cart_id']]['paper_proof'] !='null' && count($productInput[$data['cart_id']]['paper_proof'])>0 && $productInput[$data['cart_id']]['paper_proof']['status']==1) {
					$orderItemLine->setIsPaperProof(true);
					$orderItemLine->setEmailForPaperProof($productInput[$data['cart_id']]['paper_proof']['email']);
				}else{
					$orderItemLine->setIsPaperProof(false);
				}
				
				if($productInput[$data['cart_id']]['fax_proof']!='null' && count($productInput[$data['cart_id']]['fax_proof'])>0 && $productInput[$data['cart_id']]['fax_proof']['status']==1) {
					$orderItemLine->setIsFaxProof(true);
					$orderItemLine->setFaxnumberForPaperProof($productInput[$data['cart_id']]['fax_proof']['fax_no']);
				}else{
					$orderItemLine->setIsFaxProof(false);
				}
				
				if($productInput[$data['cart_id']]['product_proof']!='null' && count($productInput[$data['cart_id']]['product_proof'] && $productInput[$data['cart_id']]['product_proof']['status']==1)>0) {
					$orderItemLine->setIsProductProof(true);
				}else{
					$orderItemLine->setIsProductProof(false);
				}
				$orderItemLine->setSupplierId($productDetail[$data['cart_id']]['supplier']['supplier_id']);
				$orderItemLine->setCurrencyId($productDetail[$data['cart_id']]['currency']['id']);
				$orderItemLine->setCurrencyName($productDetail[$data['cart_id']]['currency']['name']);
				$orderItemLine->setCurrency($productDetail[$data['cart_id']]['currency']['currency']);
				$orderItemLine->setCurrencySymbol($productDetail[$data['cart_id']]['currency']['symbol']);
				$orderItemLine->setProductSku($productDetail[$data['cart_id']]['basic_information']['sku_number']);
				$orderItemLine->setProductSlug($productDetail[$data['cart_id']]['basic_information']['slug']);
				$orderItemLine->setProductThumbImage($productDetail[$data['cart_id']]['basic_information']['default_image_thumb_url']);
				$orderItemLine->setProductImage($productDetail[$data['cart_id']]['basic_information']['default_image_url']);
				$orderItemLine->setProductNote($data['special_instrution']);
				$orderItemLine->setIsComplete(true);
				$orderItemLine->setOrderType($data['order_type']);
				$orderItemLine->setItemLineAmount($data['amount']);
				$orderItemLine->setItemQtyTotal($data['total_qty']);
				$orderItemLine->setUnitPrice($data['unit_price']);
				$orderItemLine->setPriceUnit($productDetail[$data['cart_id']]['price_unit']);
				$orderItemLine->setIsFeedbackPosted(false);
				if(isset($data['tax']))
				{
					$orderItemLine->setVatTax($data['tax']['vat']);
					$orderItemLine->setVatType($data['tax']['vat_unit']);
				}
				$orderItemLine->setProductDetail(base64_encode(json_encode($productDetail[$data['cart_id']])));
				$orderItemLine->setproductDetailConfiguration(base64_encode(serialize($data['productDataArray'])));
				$orderItemLine->setExtraColor($data['extra_color']);
				$this->em->persist($orderItemLine);
				$this->em->flush();
				$orderMaster->addOrderItemLine($orderItemLine);
				
				//OneToMany
				
				$this->setGuestOrderProduct($orderItemLine,$productDetail, $data,$shippingId);
				//OneToMany
				if(count($data['charges'])>0){
					$this->setOrderProductCharges($orderItemLine, $productDetail, $data['charges']);
				}
				//OneToMany
				if(count($data['imprint'])>0 ){
				$this->setOrderProductImprintArea($orderItemLine, $productDetail, $data['imprint']);
				}
			}
		}
	}

	public function setGuestOrderProduct($orderItemLine, $productDetail, $productInput,$shippingId)
	{
		//$shippingId=$productInput['guest_shipping_id'];
		if(array_key_exists('split',$productInput)){
			foreach($productInput['split'] as $key=>$data){
			$data['shipping_detail']['carrier_type']=($data['shipping_detail']['shipping_type']!='') ? $data['shipping_detail']['shipping_type']:NULL;
			$data['shipping_detail']['shipping_type']=$productInput['shipping_type'];
			$orderProduct = new OrderProduct();
			$orderProduct->setOrderItemLineId($orderItemLine);
			$orderProduct->setOrderId($orderItemLine->getOrderMasterId()->getId());
			$orderProduct->setProductId($data['product_id']);
			$orderProduct->setCultureProductId($data['culture_product_id']);
			$this->em->persist($orderProduct);
			$this->em->flush();
			$orderItemLine->addOrderProduct($orderProduct);
			
			//OneToOne
			$this->setGuestOrderShippingDetail($orderProduct, $data,$shippingId);
			//OneToMany
			$this->setOrderVariationMaster($orderProduct, $data['variation_master']);
			}
		}
	}


	public function setGuestOrderShippingDetail($orderProduct, $data,$shippingId)
	{    
	     
		$orderShippingDetail = new OrderShippingDetail();
		$orderShippingDetail->setOrderProductId($orderProduct);
		$orderShippingDetail->setCarrierType($data['shipping_detail']['carrier_type']);
		$orderShippingDetail->setSelectedAddressId($shippingId);
		$orderShippingDetail->setShippingType($data['shipping_detail']['shipping_type']);
		$orderShippingDetail->setShipperAccount($data['shipping_detail']['shipper_account']);
		$orderShippingDetail->setServiceType($data['shipping_detail']['service_type']);
		$orderShippingDetail->setShippingCharge($data['shipping_detail']['shipping_charge']);
		$orderShippingDetail->setName($data['shipping_detail']['name']);
		$orderShippingDetail->setEmail($data['shipping_detail']['email']);
		$orderShippingDetail->setStreet1($data['shipping_detail']['street1']);
		$orderShippingDetail->setStreet2($data['shipping_detail']['street2']);
		$orderShippingDetail->setCountryName($this->coreManager->getCountryName($data['shipping_detail']['country_id']));
		$orderShippingDetail->setStateName($this->coreManager->getStateName($data['shipping_detail']['state_id']));
		$orderShippingDetail->setCityName($this->coreManager->getCityName($data['shipping_detail']['city_id']));
		$orderShippingDetail->setCountryId($data['shipping_detail']['country_id']);
		$orderShippingDetail->setStateId($data['shipping_detail']['state_id']);
		//$orderShippingDetail->setCityId($data['shipping_detail']['city_id']);
		$orderShippingDetail->setZipCode($data['shipping_detail']['zip_code']);
		$orderShippingDetail->setExtension($data['shipping_detail']['extension']);
		$orderShippingDetail->setPhone($data['shipping_detail']['phone']);
		$orderShippingDetail->setFax($data['shipping_detail']['fax']);
		$orderShippingDetail->setWebsite($data['shipping_detail']['website']);
		$orderShippingDetail->setCompanyName($data['shipping_detail']['company_name']);
		$orderShippingDetail->setCompanyNumber($data['shipping_detail']['company_number']);
		

		if ($data['shipping_detail']['on_hand_date'] != null && $data['shipping_detail']['on_hand_date'] != 'null' && $data['shipping_detail']['on_hand_date'] != '') {
			$orderShippingDetail->setOnHandDate(new \DateTime($data['shipping_detail']['on_hand_date']));
		}
		if ($data['shipping_detail']['ship_date'] != null && $data['shipping_detail']['ship_date'] != 'null' && $data['shipping_detail']['ship_date'] != '') { 
			$orderShippingDetail->setShipDate(new \DateTime($data['shipping_detail']['ship_date']));
		}
		if(isset($data['tax_shipping_wise'])) {
			$orderShippingDetail->setTax($data['tax_shipping_wise']);
		}
        
		$this->em->persist($orderShippingDetail);
		$this->em->flush();
		$orderProduct->setOrderShippingDetail($orderShippingDetail);
	}




	
}