";print_r($this->responseArray['shippingDetail']);exit();
    		}
    		else if ($this->shippingType == 'ups')
    		{
    			$this->shippinEstiConfi = $this->projectSetting['configuration_rule']['transaction']['shipping_estimator']['option']['registered_user']['option']['ups']['option']['ups_track']['option'];
    			$this->responseArray['trackingResult']= 'SUCCESS';
    			$this->responseArray['shippingDetail'] = $this->upsShippingEstimatorManager->callRequest($inLineShippingDetail->getTrackingId(),$this->shippinEstiConfi,'shippingDetail');
    			//echo "
";print_r($this->responseArray['shippingDetail']);exit();
    		}
    	}
    	return $this->responseArray;
    }
    
    /**
     * @author Employee Id: 4471
     * Description : change status of order from admin
     * @param 1 : No paramater
     * @return type : Form view and data.
     * @throws Exception: Null
     *
     * @Route("/admin/{_locale}/change-order-line-status-and-track-order",
     * name="office_brain_orderbundle_orderadmin_changeorderlinestatusadmin",
     * options={"expose"=true}
     * )
     *
     */
    public function changeOrderLineStatusAndtTrackAdminAction()
    {
    	$this->initAction();
    	$this->orderInlineId = $this->request->get('orderInlineId', '0');
    	$this->shippingId = $this->request->get('shippingId', '0');
    	$this->status = $this->request->get('status', 'pending');
    	$this->statusId = $this->request->get('statusId','1');
    	$this->shippingType = $this->request->get('shippingType', 'fedex');
    	$this->trackingId = $this->request->get('trackingId', NULL); //1Z12345E1512345676 ups // 122816215025810 fedex
    	
    	
    	$statuschange=$this->orderManager->changeOrderLineStatusAdmin($this->shippingId,$this->statusId,$this->status,$this->shippingType,$this->trackingId);
    	return new JsonResponse($statuschange);
    }

    /**
     * @author Employee Id: 5632
     * Description : Order detail Export in xml
     * @param 1 : No paramater
     * @return type : Form view and data.
     * @throws Exception: Null
     *
     * @Route("/admin/{_locale}/order-list-export",
     * name="office_brain_orderbundle_orderadmin_adminorderlist_export",
     * options={"expose"=true}
     * )
     *
     */
    public function adminOrderListExportAction()
    {
        $this->initAction();
        
        $this->translator =  $this->get('translator');
        //echo $this->translator->trans('order_item_line', array(), 'export');;die;
        
        $this->responseArray['records_per_page'] = $this->recordsPerPage;
        $this->responseArray['page'] = $this->page;
        $this->prepareSearchParameterArray();
        $this->responseArray['data'] = $this->orderManager->getOrderAdminListExport($this->searchParameterArray,$this->searchKeyWordsArray);
    
        $new_file_name = $this->orderManager->generateXMLOfOrder($this->responseArray['data'],$this->translator);
        
        $path = $this->getParameter('place_order_xml_path');
        $fullPath = $path.''.$new_file_name;
        if(file_exists($fullPath)){
            if ($fd = fopen ($fullPath, "r")) {
                $fsize = filesize($fullPath);
        
                header("Content-type: application/octet-stream");
                header("Content-Disposition: filename=".$new_file_name);
                header("Content-length: $fsize");
                header("Cache-control: private"); //use this to open files directly
                while(!feof($fd)) {
                    $buffer = fread($fd, 2048);
                    echo $buffer;
                }
            }
            fclose ($fd);
        }
        die;
        //echo '
';print_r($data);die;
         //$this->responseArray;
    }
    
    
    /**
     * @author Employee Id: 5632
     * Description : Order detail Export in xml
     * @param 1 : No paramater
     * @return type : Form view and data.
     * @throws Exception: Null
     *
     * @Route("/admin/{_locale}/order-list-export-xls",
     * name="office_brain_orderbundle_orderadmin_adminorderlist_export_xls",
     * options={"expose"=true}
     * )
     *
     */
    public function adminOrderListExportXlsAction()
    {
        $this->initAction();
        
        $this->translator =  $this->get('translator');
        //echo $this->translator->trans('order_item_line', array(), 'export');;die;
         
        $this->responseArray['records_per_page'] = $this->recordsPerPage;
        $this->responseArray['page'] = $this->page;
        $this->prepareSearchParameterArray();
        $this->responseArray['data'] = $this->orderManager->getOrderAdminListExport($this->searchParameterArray,$this->searchKeyWordsArray);
        //echo '
';print_r($this->responseArray['data']);die;
        $orderData = $this->orderManager->generateObjectToArray($this->responseArray['data'],$this->translator);
        //echo '
';print_r($orderData);die;
        $this->adminOrderXls($orderData);
        
        
        //$this->responseArray;
    }
    public function adminOrderXls($data)
    {   
        //echo '
';print_r($data);die;
        //XLS Generate
        if(isset($data) && count($data)>0){
            
            $response = new Response();
            $objPHPExcel = new PHPExcel();
            
            // Set document properties
            $objPHPExcel->getProperties()->setCreator("Me")
            ->setLastModifiedBy("Someone")
            ->setTitle("Order Details")
            ->setSubject("Order Details");
            
            $this->setXlsData($objPHPExcel,$data[0],0);//die;
            
            $sheetNames = $objPHPExcel->getSheetNames();
            $count = 1;
            //$this->orderCounter[0] = 2;
            foreach($data as $key => $value) {
                $count ++; 
                $this->setXlsDataValue($objPHPExcel,$value,0,$sheetNames,$count);
                //echo $count.'
';
            }//die;
            /* echo '
';print_r($this->orderCounter);
            echo 'sasasa';
            die; */
            //echo '
';print_r($sheetNames);die;
            
            /* $alpha = 'A';
            $sheet = '1';
            foreach($data[0] as $key => $value) {
                //foreach($value as $key2 => $value2) {
                //echo $key.'
';
                if(is_array($value)) {
                    if(!is_numeric($key)){
                        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($alpha.'1', $key);
                        $alpha++; 
                        $objPHPExcel->createSheet();
                        $objPHPExcel->setActiveSheetIndex($sheet);
                        $objPHPExcel->getActiveSheet()->setTitle($key);
                        $sheet++;
                    }
                }else{
                    if(!is_numeric($key)){
                        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($alpha.'1', $key);
                        $alpha++;
                    }
                    $objPHPExcel->setActiveSheetIndex(0);
                    $objPHPExcel->getActiveSheet()->setTitle('Order Master');
                }
                    
            } */
            /* foreach($data as $key => $value) {
                $alpha = 'A';
                $count = $key+2;
                foreach($value as $key2 => $value2) {
                    if(!is_numeric($key2)){
                        $objPHPExcel->setActiveSheetIndex(0)->setCellValue($alpha.''.$count, $value2);
                        $alpha++;
                    }
                }
            } */
            
            
            // Add some data
            /* $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', 'Hello')
            ->setCellValue('B1', 'world!')
            ->setCellValue('C1', 'Hello')
            ->setCellValue('D1', 'world!'); */
            // Set active sheet index to the first sheet
//          $objPHPExcel->setActiveSheetIndex(0);
//          $objPHPExcel->getActiveSheet()->setTitle('Order Master');
            
            // Redirect output to a client’s web browser (Excel5)
            $response->headers->set('Content-Type', 'application/vnd.ms-excel');
            $response->headers->set('Content-Disposition', 'attachment;filename="demo.xls"');
            $response->headers->set('Cache-Control', 'max-age=0');
            //$response->prepare();
            $response->sendHeaders();
            $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
            $objWriter->save('php://output');
            exit();
        }
        
    }
    
    public function setXlsData($objPHPExcel,$data,$sheet){
        $alpha = 'A';
        $sheetNames = array();
        //$sheet = $sheet+1;
        //echo $sheet.'
';
        //$count = $objPHPExcel->setActiveSheetIndex($sheet)->getHighestColumn() + 2;
        //echo 'Count == '.$count.'
';
        foreach($data as $key => $value) {
            //echo '
';print_r($value).'
';echo '======================';
            //foreach($value as $key2 => $value2) {
            //echo $key.'
';
            $key= substr($key, 0, 25);
            if(is_array($value)) {
                if(count($value)>0){
                    if(!is_numeric($key)){
                        //echo $sheet;die;
                        if(!in_array($key,$sheetNames)){
                            $sheet = $objPHPExcel->getSheetCount();
                            $objPHPExcel->createSheet();
                            $objPHPExcel->setActiveSheetIndex($sheet);
                            $objPHPExcel->getActiveSheet()->setTitle($key);
                        }else{
                            $asheet = array_keys($sheetNames, $key);
                            $sheet =$asheet[0]; 
                            $objPHPExcel->setActiveSheetIndex($sheet);
                        }   
                        //$objPHPExcel->setActiveSheetIndex($sheet);
                        $sheetNames = $objPHPExcel->getSheetNames();
                        //echo '
';print_r($sheetNames);
                        $objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.'1', $key);
                        //$count = $objPHPExcel->setActiveSheetIndex($sheet)->getHighestRow() + 1;
                        //$objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.''.$count, $value);
                        $alpha++;
                        
                        $this->setXlsData($objPHPExcel,$value,$sheet);
                    }else{
                        $this->setXlsData($objPHPExcel,$value,$sheet);
                    }
                }
            }else{
                if(!is_numeric($key)){
                    $objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.'1', $key);
                    //$count = $objPHPExcel->setActiveSheetIndex($sheet)->getHighestRow() + 1;
                    //$objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.''.$count, $value);
                    $alpha++;
                }
                $objPHPExcel->setActiveSheetIndex(0);
                $objPHPExcel->getActiveSheet()->setTitle('Order Master');
                //$sheet++;
            }
            
        }
    }
    
    public function setXlsDataValue($objPHPExcel,$data,$sheet,$sheetNames,$counts){
        $alpha = 'A';
        $totalrec = 1;
        //$sheetNames = array();
        //$sheet = $sheet+1;
        //echo $sheet.'
';
        //echo '
';print_r($sheetNames);die;
        $count = $objPHPExcel->setActiveSheetIndex($sheet)->getHighestColumn() + 2;
        //echo 'Count == '.$count.'
';
        foreach($data as $key => $value) {
            //echo '
';print_r($value).'
';echo '======================';
            //foreach($value as $key2 => $value2) {
            //echo $key.'
';
            $key= substr($key, 0, 25);
            if(is_array($value)) {
                if(count($value)>0){
                    if(!is_numeric($key)){
                        //echo $sheet;die;
                        if(in_array($key,$sheetNames)){
                            $asheet = array_keys($sheetNames, $key);
                            $sheet = $asheet[0];
                            $objPHPExcel->setActiveSheetIndex($sheet);
                            $totalrec = count($value);
                            $this->orderCounter[$sheet] = $this->orderCounter[$sheet] + 1;
                        }
                        $objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.''.($this->orderCounter[$sheet]+1), $value);
                        $alpha++;
                             
                        $this->setXlsDataValue($objPHPExcel,$value,$sheet,$sheetNames,$counts);
                    }else{
                        $this->orderCounter[$sheet] = $this->orderCounter[$sheet] + 1;
                        //echo 'Aheet Counter['.$sheet.'] == '.$this->orderCounter[$sheet].'
';
                        $count = $objPHPExcel->setActiveSheetIndex($sheet)->getHighestRow();
                        /* echo 'Aheet Counter['.$sheet.'] == '.$count.'
';
                        echo '
';print_r($value); */
                        $this->setXlsDataValue($objPHPExcel,$value,$sheet,$sheetNames,($this->orderCounter[$sheet]));
                    }
                }
            }else{
                if(!is_numeric($key)){
                    //echo 'sheet == '.$sheet.'
';
                    //echo $counts.'
';
                    
                    $objPHPExcel->setActiveSheetIndex($sheet)->setCellValue($alpha.''.$counts, $value);
                    $alpha++;
                }
                $objPHPExcel->setActiveSheetIndex(0);
                $objPHPExcel->getActiveSheet()->setTitle('Order Master');
            }
        }
    }



    

}