PHP Decode

<?php class IndexController extends Zend_Controller_Action{public function init(){$this->_helper->layout->setLayout('layout');}private function getLastCNNo($lastKey,$keyType){$thType=0;$result='';if($keyType=='TH')$thType=1;if($keyType=='TH'){$lastKey=substr($lastKey,2);}if($lastKey==''){$result='A00001';}else{$getChar=substr($lastKey,0,1);$getNum=substr($lastKey,1);$getNum=(int)$getNum;if($getNum==20000){$getChar++;$getNum=1;}else{$getNum++;}$result=$getChar.sprintf('%05d',$getNum);}if($thType==1)return 'TH'.$result;else return $result;}public function ajaxgetlastcnumAction(){$this->_helper->layout->disableLayout();$typeVal=$this->_request->getPost('data_val');$lastCNNo='A00001';if($typeVal==0){$typeVal='TH';$lastKey=Application_Model_Orders::getLastConvoyNum($typeVal);if($lastKey==false){$lastCNNo='THA00001';}else{$lastCNNo=$this->getLastCNNo($lastKey['CNo'],'TH');}}else{$typeVal='A';$lastKey=Application_Model_Orders::getLastConvoyNum($typeVal);if($lastKey!=false){$lastCNNo=$this->getLastCNNo($lastKey['CNo'],'A');}}$this->view->result=$lastCNNo;}public function indexAction(){$this->view->menuItem='index';$portNames=Application_Model_Orders::getPortNames();if($portNames==false){$portNames['DDNO']='';$portNames['OdPh']='';$portNames['SoNo']='';$portNames['PortNames']='';$portNames['VesselNames']='';$portNames['OrderPh']='';$portNames['ConvoyNo']='';$portNames['TruckNo']='';$portNames['DriverName']='';$portNames['DecGood']='';}$this->view->portName=$portNames;$dealers=Application_Model_Dealer::getDealers();$this->view->dealers=$dealers;$carGate=Application_Model_Cargate::getCargates();$this->view->carGates=$carGate;$goodsDesc=Application_Model_Orders::getDesc();$this->view->goodDesc=$goodsDesc;$users=Application_Model_Users::getUsers();$this->view->users=$users;$receivers=Application_Model_Receivers::getReceivers();$this->view->receivers=$receivers;$convoyKeys=Application_Model_Convey::getConvoy();if(!$convoyKeys==false){$this->view->convoyKeys=$convoyKeys['CKey'];}$this->view->editMode=0;$searchName=$this->_request->getParam('search');if($searchName!=''){$getOrderByConveyNo=Application_Model_Orders::getOrderByConveyNo($searchName);if($getOrderByConveyNo!=false){$this->view->getOrder=$getOrderByConveyNo;$this->view->editMode=1;}}else{$getOrderByConveyNo=Application_Model_Orders::getOrderByConveyNo($searchName);if($getOrderByConveyNo!=false){$getOrderByConveyNo['OID']='';$getOrderByConveyNo['DDNo']='';$getOrderByConveyNo['SoNo']='';$getOrderByConveyNo['Truck']='';$getOrderByConveyNo['ConvoyData']='';$getOrderByConveyNo['SenderName']='';$getOrderByConveyNo['RecName']='';$getOrderByConveyNo['RecNRC']='';$this->view->getOrder=$getOrderByConveyNo;}}}public function ajaxreloadafterprintAction(){$this->_helper->layout->disableLayout();$lastConvoy=Application_Model_Convey::getLastConvoy();if(!$lastConvoy==false){$result['lastCKey']='A'.sprintf('%05d',$lastConvoy['LastCKey'] + 1);$result['now']=date('Y-m-d h:i:s');$this->view->result=$result;}}public function ajaxadddealerAction(){$this->_helper->layout->disableLayout();$dealerName=$this->_request->getPost('data_val');$dealerData['d_name']=$dealerName;$dealerData['cr_date']=date('Y-m-d h:i:s');$dealerData['update_date']=date('Y-m-d h:i:s');$remDealer=Application_Model_Dealer::addDealer($dealerData);$this->view->result='success';}public function ajaxeditdealerAction(){$this->_helper->layout->disableLayout();$dealerID=$this->_request->getPost('data_id');$dealerName=$this->_request->getPost('data_val');$dealerData['d_name']=$dealerName;$dealerData['update_date']=date('Y-m-d h:i:s');$remDealer=Application_Model_Dealer::editDealer($dealerID,$dealerData);$this->view->result='success';}public function ajaxremdealerAction(){$this->_helper->layout->disableLayout();$dealerID=$this->_request->getPost('data_id');$remDealer=Application_Model_Dealer::remDealer($dealerID);$this->view->result='success';}public function ajaxaddcargateAction(){$this->_helper->layout->disableLayout();$gateName=$this->_request->getPost('data_val');$gateData['gate_name']=$gateName;$gateData['cr_date']=date('Y-m-d h:i:s');$gateData['update_date']=date('Y-m-d h:i:s');$remDealer=Application_Model_Cargate::addCargate($gateData);$this->view->result='success';}public function ajaxeditcargateAction(){$this->_helper->layout->disableLayout();$cargateID=$this->_request->getPost('data_id');$gateName=$this->_request->getPost('data_val');$dealerData['gate_name']=$gateName;$dealerData['update_date']=date('Y-m-d h:i:s');$remDealer=Application_Model_Cargate::editCargate($cargateID,$dealerData);$this->view->result='success';}public function ajaxremcargateAction(){$this->_helper->layout->disableLayout();$dealerID=$this->_request->getPost('data_id');$remDealer=Application_Model_Cargate::remCargate($dealerID);$this->view->result='success';}public function ajaxsaveAction(){$this->_helper->layout->disableLayout();$editOrderID=$this->_request->getPost('data_oid');$convey=$this->_request->getPost('data_convey');$order=$this->_request->getPost('data_order');$receiver=$this->_request->getPost('data_receiver');$sender=$this->_request->getPost('data_sender');$hasUser=Application_Model_Users::hasUser($sender['name']);$transportType=$order['transportType'];if($hasUser==false){$dbUser['uname']=$sender['name'];$userID=Application_Model_Users::saveUser($dbUser);}else{$userID=$hasUser['UID'];}if($userID!=false){if($receiver['name']!=''){$hasReceiver=Application_Model_Receivers::hasReceiver($receiver['name']);}else{$hasReceiver=false;}if($hasReceiver==false){$dbReceiver['rec_name']=$receiver['name'];$dbReceiver['rec_nrc']=$receiver['nrc'];$receiverID=Application_Model_Receivers::saveReceiver($dbReceiver);}else{$receiverID=$hasReceiver['RID'];}if($receiverID!=false){$dbOrder['user_id']=$userID;if($receiver['name']!=''&&$receiver['nrc']!=''){$dbOrder['receiver_id']=$receiverID;}else{$dbOrder['receiver_id']=NULL;}$dbOrder['dealer_id']=$order['dealer'];$dbOrder['car_gate_id']=$order['cgate'];$dbOrder['dd_no']=$order['DDNo'];$dbOrder['so_no']=$order['SoNum'];$dbOrder['convey_no']=$order['ConveyNum'];$dbOrder['vessel_name']=$order['PtName'];$dbOrder['port_name']=$order['PortName'];$dbOrder['odr_addr']=$order['Addr'];$dbOrder['odr_ph']=$order['Phone'];if($transportType==0){$dbOrder['truck_no']=$order['truckNo'];}else{$dbOrder['os_no']=$order['truckNo'];}$dbOrder['driver_name']=$order['driver'];$dbOrder['license_no']=$order['licence'];$dbOrder['departure_time']=$order['depature'];$dbOrder['cr_date']=date('Y-m-d h:i:s');if($editOrderID==''){$orderID=Application_Model_Orders::saveOrder($dbOrder);}else{$editOrder=Application_Model_Orders::editOrder($editOrderID,$dbOrder);$orderID=$editOrderID;}if($orderID!=false){$dbConvey['order_id']=$orderID;Application_Model_Convey::removeConvoy($orderID);foreach($convey as $key=>$value){$dbConvey['desc_goods']=$value['desc'];$dbConvey['sr_no']=$value['srNo'];$dbConvey['bag_type']=$value['bagType'];$dbConvey['no_bags']=$value['bags'];$dbConvey['in_word']=$value['bagInWord'];$dbConvey['remarks']=$value['remark'];$dbConvey['cr_date']=date('Y-m-d h:i:s');Application_Model_Convey::saveConvey($dbConvey);$this->view->result=$orderID;}}}}}public function summaryreportAction(){$this->view->menuItem='summaryreport';$dataFrom=$this->_request->getParam('from','');$dataTo=$this->_request->getParam('to','');$dataCNFrom=$this->_request->getParam('cnfrom');$dataCNTo=$this->_request->getParam('cnto');$dataDealers=$this->_request->getParam('dealers');$dataVessel=$this->_request->getParam('vessel');$dataPort=$this->_request->getParam('port');$dataTH=$this->_request->getParam('th');$dataAB=$this->_request->getParam('ab');$dataDealers=explode(',',$dataDealers);$dealerIDStr='';foreach($dataDealers as $key=>$value){$value=trim($value);$dealerID=Application_Model_Dealer::getDealerIDByName($value);if($dealerID!=false){$dealerIDStr=($dealerIDStr=='')?$dealerID['DID']:$dealerIDStr.', '.$dealerID['DID'];}}$paramDealers=array();foreach($dataDealers as $key=>$value){$paramDealers[]=trim($value);}$this->view->dataDealers=$paramDealers;$vesselName='';$dataVessels=explode(',',$dataVessel);$paramVessels=array();foreach($dataVessels as $key=>$value){$paramVessels[]=trim($value);$vesselName=($vesselName=='')?'\''.trim($value).'\'':$vesselName.', \''.trim($value).'\'';}$this->view->dataVessels=$paramVessels;$portName='';$dataPorts=explode(',',$dataPort);$paramPorts=array();foreach($dataPorts as $key=>$value){$paramPorts[]=trim($value);$portName=($portName=='')?'\''.trim($value).'\'':$portName.', \''.trim($value).'\'';}$this->view->dataPorts=$paramPorts;$dataCNFrom=($dataCNFrom=='')?0:$dataCNFrom;$dataCNTo=($dataCNTo=='')?0:$dataCNTo;if(isset($dataFrom)){$search['from']=$dataFrom;}else{$search['from']='';}if(isset($dataTo)){$search['to']=$dataTo;}else{$search['to']='';}if(isset($dataCNFrom)&&$dataCNFrom!=0){$search['cnfrom']=$dataCNFrom;}else{$search['cnfrom']='';}if(isset($dataCNTo)&&$dataCNTo!=0){$search['cnto']=$dataCNTo;}else{$search['cnto']='';}if(isset($dataDealers)){$search['dealers']=$dataDealers;}else{$search['dealers']='';}if(isset($dataTH)){$search['th']=$dataTH;}else{$search['th']='';}if(isset($dataAB)){$search['ab']=$dataAB;}else{$search['ab']='';}$this->view->search=$search;$dealerNames=Application_Model_Dealer::getDealers();if($dealerNames==false){$this->view->dealerNames='';}else{$this->view->dealerNames=$dealerNames;}$vesselPort=Application_Model_Orders::getVesselPortNames();$this->view->dataVesselPort=$vesselPort;$result=array();$summary=Application_Model_Summary::getSummaryByPortName($dataFrom,$dataTo,$dataCNFrom,$dataCNTo,$vesselName,$portName,$dealerIDStr,$dataTH,$dataAB);if($summary!=false){$portNameVal=array();foreach($summary as $key=>$value){$result_0=array();$result_0['date_range']=$value['FromDate'].'<br> - <br>'.$value['ToDate'];if($value!=''){$val=explode('_%%_',$value['VessalNames']);if(count($val)>0){foreach($val as $key1=>$value1){$convoyNote_=Application_Model_Summary::getConvoyNoteByVessalNamePortName($value['PortName'],$value1,$dataFrom,$dataTo,$dataCNFrom,$dataCNTo,$dealerIDStr,$dataTH,$dataAB);if($convoyNote_!=false){$convoyNote=explode('_&&_',$convoyNote_['ConvoyNote']);if(count($convoyNote)>0){$valRes=array();$result_1=array();$valRes['TruckCnt']=$convoyNote_['TruckCnt'];$valRes['OSCnt']=$convoyNote_['OSCnt'];foreach($convoyNote as $key2=>$value2){$result_2=array();if($value2!=''){$value2=explode('_%%_',$value2);$result_2['cNoteID']=$value2[0];$result_2['bagName']=$value2[1];$result_2['bagCnt']=$value2[2];$result_1[]=$result_2;$valRes[$value2[1]][]=$result_2;}}$result_0[$value1]=$valRes;}}}}}$portNameVal[$value['PortName']]=$result_0;}$this->view->summaryDataByPortName=$portNameVal;}}public function summaryAction(){$this->view->menuItem='summary';$dataFrom=$this->_request->getParam('from');$dataTo=$this->_request->getParam('to');$dataCNFrom=$this->_request->getParam('cnfrom');$dataCNTo=$this->_request->getParam('cnto');$dataDealers=$this->_request->getParam('dealers');$dataTH=$this->_request->getParam('th');$dataAB=$this->_request->getParam('ab');$dataDealers=explode(',',$dataDealers);$dealerIDStr='';foreach($dataDealers as $key=>$value){$value=trim($value);$dealerID=Application_Model_Dealer::getDealerIDByName($value);if($dealerID!=false){$dealerIDStr=($dealerIDStr=='')?$dealerID['DID']:$dealerIDStr.', '.$dealerID['DID'];}}$paramDealers=array();foreach($dataDealers as $key=>$value){$paramDealers[]=trim($value);}$this->view->dataDealers=$paramDealers;$dataCNFrom=($dataCNFrom=='')?0:$dataCNFrom;$dataCNTo=($dataCNTo=='')?0:$dataCNTo;$summary=Application_Model_Summary::getDealerSales($dataFrom,$dataTo,$dealerIDStr,$dataTH,$dataAB,$dataCNFrom,$dataCNTo);if($summary==false){$this->view->summary=false;}else{$finalRes=array();foreach($summary as $key=>$value){$eachRes=$value;$bagInfo=Application_Model_Summary::getBagInfo($value['DealerID'],$value['ConveyType']);if($bagInfo==false){$eachRes['bags']=false;$eachRes['bagCnt']=0;}else{$bagCnt=0;foreach($bagInfo as $key1=>$value1){$bagCnt=$bagCnt + $value1['BagCnt'];}$eachRes['bagCnt']=$bagCnt;$eachRes['bags']=$bagInfo;}$finalRes[]=$eachRes;}$this->view->summary=$finalRes;}if(isset($dataFrom)){$search['from']=$dataFrom;}else{$search['from']='';}if(isset($dataTo)){$search['to']=$dataTo;}else{$search['to']='';}if(isset($dataCNFrom)&&$dataCNFrom!=0){$search['cnfrom']=$dataCNFrom;}else{$search['cnfrom']='';}if(isset($dataCNTo)&&$dataCNTo!=0){$search['cnto']=$dataCNTo;}else{$search['cnto']='';}if(isset($dataDealers)){$search['dealers']=$dataDealers;}else{$search['dealers']='';}if(isset($dataTH)){$search['th']=$dataTH;}else{$search['th']='';}if(isset($dataAB)){$search['ab']=$dataAB;}else{$search['ab']='';}$this->view->search=$search;$dealerNames=Application_Model_Dealer::getDealers();if($dealerNames==false){$this->view->dealerNames='';}else{$this->view->dealerNames=$dealerNames;}}public function dataformAction(){$this->view->menuItem='dataform';$dateFrom=$this->_request->getParam('from');$dateTo=$this->_request->getParam('to');$convoyFrom=$this->_request->getParam('cnfrom');$convoyTo=$this->_request->getParam('cnto');if($dateFrom!=''&&!$this->validateDate($dateFrom)){echo 'Invalid Date Format';exit;}if($dateTo!=''&&!$this->validateDate($dateTo)){echo 'Invalid Date Format';exit;}$thType=$this->_request->getParam('thtype');$abType=$this->_request->getParam('abtype');if($thType==''&&$abType==''){$this->redirect('/index/dataform?thtype=1&abtype=1');}if($thType==1){$this->view->thType=$thType;}if($abType==1){$this->view->abType=$abType;}$url='';if($convoyFrom!=''){$this->view->convoyFrom=$convoyFrom;}if($convoyTo!=''){$this->view->convoyTo=$convoyTo;}if($dateFrom!=false){$url='?from='.$dateFrom;$this->view->dateFrom=$dateFrom;}if($dateTo!=false){if($url==''){$url='?to='.$dateTo;}else{$url=$url.'&to='.$dateTo;}$this->view->dateTo=$dateTo;}if($convoyFrom!=''){if($url==''){$url='?cnfrom='.$convoyFrom;}else{$url=$url.'&cnfrom='.$convoyFrom;}}if($convoyTo!=''){if($url==''){$url='?cnto='.$convoyTo;}else{$url=$url.'&cnto='.$convoyTo;}}if($thType!=''){if($url==''){$url='?thtype=1';}else{$url=$url.'&thtype=1';}}if($abType!=''){if($url==''){$url='?abtype=1';}else{$url=$url.'&abtype=1';}}$this->view->urlParam=$url;$rows=Application_Model_Orders::getOrder($dateFrom,$dateTo,$convoyFrom,$convoyTo,$thType,$abType);$this->view->result=$rows;}public function printAction(){$this->_helper->layout->disableLayout();$dataID=$this->_request->getParam('id');if(!isset($dataID)){echo 'Invalid ID';exit;}$data=Application_Model_Orders::getOrderByOrderId($dataID);if($data!=false){$this->view->data=$data;}else{echo 'Invalid ID';exit;}}public function excelAction(){$this->_helper->layout->disableLayout();$dateFrom=$this->_request->getParam('from');$dateTo=$this->_request->getParam('to');$search=$this->_request->getParam('search');$thType=$this->_request->getParam('thtype');$abType=$this->_request->getParam('abtype');$convoyFrom=$this->_request->getParam('cnfrom');$convoyTo=$this->_request->getParam('cnto');if(!isset($search))$search='';if($dateFrom!=''&&!$this->validateDate($dateFrom)){echo 'Invalid Date Format';exit;}if($dateTo!=''&&!$this->validateDate($dateTo)){echo 'Invalid Date Format';exit;}if($dateFrom!=false){$this->view->dateFrom=$dateFrom;}if($dateTo!=false){$this->view->dateTo=$dateTo;}$excelData=Application_Model_Orders::getOrderForExcel($dateFrom,$dateTo,$search,false,$convoyFrom,$convoyTo,$abType,$thType);if($excelData==false){echo 'No Excel Data';exit;}$objPHPExcel=new PHPExcel();$sheetCnt=0;foreach($excelData as $key=>$value){$val=explode('_&&_',$value['DataResult']);if($sheetCnt>0){$objPHPExcel->createSheet();}$objPHPExcel->setActiveSheetIndex($sheetCnt);if(count($val)>0){$rowCnt=1;$objPHPExcel->getActiveSheet()->setCellValue('A1','Sr No.');$objPHPExcel->getActiveSheet()->setCellValue('B1','DATE.');$objPHPExcel->getActiveSheet()->setCellValue('C1','VESSEL NAME.');$objPHPExcel->getActiveSheet()->setCellValue('D1','CONVOY NO.');$objPHPExcel->getActiveSheet()->setCellValue('E1','DD NO.');$objPHPExcel->getActiveSheet()->setCellValue('F1','SO Number.');$objPHPExcel->getActiveSheet()->setCellValue('G1','TRUCK NO');$objPHPExcel->getActiveSheet()->setCellValue('H1','OS NO');$objPHPExcel->getActiveSheet()->setCellValue('I1','DRIVER NAME');$objPHPExcel->getActiveSheet()->setCellValue('J1','PHONE NO');$objPHPExcel->getActiveSheet()->setCellValue('K1','POINT');$objPHPExcel->getActiveSheet()->setCellValue('L1','50KG BAGS');$objPHPExcel->getActiveSheet()->setCellValue('M1','JUMBO');$objPHPExcel->getActiveSheet()->setCellValue('N1','SWEEPING');$objPHPExcel->getActiveSheet()->setCellValue('O1','CAKE');$objPHPExcel->getActiveSheet()->setCellValue('P1','DEALER');$objPHPExcel->getActiveSheet()->setCellValue('Q1','GATE');$objPHPExcel->getActiveSheet()->setCellValue('R1','Coupon');$objPHPExcel->getActiveSheet()->setCellValue('S1','Remarks');$rowCnt++;foreach($val as $key1=>$value1){$value1=explode('_%%_',$value1);$objPHPExcel->getActiveSheet()->setCellValue('A'.$rowCnt,$rowCnt - 1);$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowCnt,(isset($value1[1]))?$value1[1]:'');$objPHPExcel->getActiveSheet()->setCellValue('C'.$rowCnt,(isset($value1[2]))?$value1[2]:'');$objPHPExcel->getActiveSheet()->setCellValue('D'.$rowCnt,(isset($value1[3]))?$value1[3]:'');$objPHPExcel->getActiveSheet()->setCellValue('E'.$rowCnt,(isset($value1[4]))?$value1[4]:'');$objPHPExcel->getActiveSheet()->setCellValue('F'.$rowCnt,(isset($value1[5]))?$value1[5]:'');$objPHPExcel->getActiveSheet()->setCellValue('G'.$rowCnt,(isset($value1[6]))?$value1[6]:'');$objPHPExcel->getActiveSheet()->setCellValue('H'.$rowCnt,(isset($value1[14]))?$value1[14]:'');$objPHPExcel->getActiveSheet()->setCellValue('I'.$rowCnt,(isset($value1[7]))?$value1[7]:'');$objPHPExcel->getActiveSheet()->setCellValue('J'.$rowCnt,(isset($value1[8]))?$value1[8]:'');$objPHPExcel->getActiveSheet()->setCellValue('K'.$rowCnt,(isset($value1[9]))?$value1[9]:'');$bagType=$value1[15];$bagType=explode('_-_',$bagType);if(count($bagType)>0){$bagTypeArr=array();foreach($bagType as $key11=>$value11){$val11=explode('_||_',$value11);$bagTypeArr[$val11[1]]=$val11[0];}}$objPHPExcel->getActiveSheet()->setCellValue('L'.$rowCnt,(isset($bagTypeArr[1]))?$bagTypeArr[1]:'');$objPHPExcel->getActiveSheet()->setCellValue('M'.$rowCnt,(isset($bagTypeArr[2]))?$bagTypeArr[2]:'');$objPHPExcel->getActiveSheet()->setCellValue('N'.$rowCnt,(isset($bagTypeArr[3]))?$bagTypeArr[3]:'');$objPHPExcel->getActiveSheet()->setCellValue('O'.$rowCnt,(isset($bagTypeArr[4]))?$bagTypeArr[4]:'');$objPHPExcel->getActiveSheet()->setCellValue('P'.$rowCnt,(isset($value1[10]))?$value1[10]:'');$objPHPExcel->getActiveSheet()->setCellValue('Q'.$rowCnt,(isset($value1[11]))?$value1[11]:'');$objPHPExcel->getActiveSheet()->setCellValue('R'.$rowCnt,(isset($value1[12]))?$value1[12]:'');$objPHPExcel->getActiveSheet()->setCellValue('S'.$rowCnt,(isset($value1[13]))?$value1[13]:'');foreach(range('A','S')as $columnID){$objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);}$rowCnt++;}$objPHPExcel->getActiveSheet()->setTitle($value['DealerName'].'('.$value['ConveyType'].')');$sheetCnt++;}else{break;}}header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="By-Delar-Name.xls"');header('Cache-Control: max-age=0');$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');$objWriter->save('php://output');}public function excelcgAction(){$this->_helper->layout->disableLayout();$dateFrom=$this->_request->getParam('from');$dateTo=$this->_request->getParam('to');$search=$this->_request->getParam('search');$thType=$this->_request->getParam('thtype');$abType=$this->_request->getParam('abtype');$convoyFrom=$this->_request->getParam('cnfrom');$convoyTo=$this->_request->getParam('cnto');if(!isset($search))$search='';if($dateFrom!=''&&!$this->validateDate($dateFrom)){echo 'Invalid Date Format';exit;}if($dateTo!=''&&!$this->validateDate($dateTo)){echo 'Invalid Date Format';exit;}if($dateFrom!=false){$this->view->dateFrom=$dateFrom;}if($dateTo!=false){$this->view->dateTo=$dateTo;}$excelData=Application_Model_Orders::getOrderForExcel($dateFrom,$dateTo,$search,false,$convoyFrom,$convoyTo,$abType,$thType);if($excelData==false){echo 'No Excel Data';exit;}$objPHPExcel=new PHPExcel();$sheetCnt=0;foreach($excelData as $key=>$value){$val=explode('_&&_',$value['DataResult']);if($sheetCnt>0){$objPHPExcel->createSheet();}$objPHPExcel->setActiveSheetIndex($sheetCnt);if(count($val)>0){$rowCnt=1;$objPHPExcel->getActiveSheet()->setCellValue('A1','Sr No.');$objPHPExcel->getActiveSheet()->setCellValue('B1','DATE.');$objPHPExcel->getActiveSheet()->setCellValue('C1','VESSEL NAME.');$objPHPExcel->getActiveSheet()->setCellValue('D1','CONVOY NO.');$objPHPExcel->getActiveSheet()->setCellValue('E1','DD NO.');$objPHPExcel->getActiveSheet()->setCellValue('F1','SO Number.');$objPHPExcel->getActiveSheet()->setCellValue('G1','TRUCK NO');$objPHPExcel->getActiveSheet()->setCellValue('H1','OS NO');$objPHPExcel->getActiveSheet()->setCellValue('I1','DRIVER NAME');$objPHPExcel->getActiveSheet()->setCellValue('J1','PHONE NO');$objPHPExcel->getActiveSheet()->setCellValue('K1','POINT');$objPHPExcel->getActiveSheet()->setCellValue('L1','50KG BAGS');$objPHPExcel->getActiveSheet()->setCellValue('M1','JUMBO');$objPHPExcel->getActiveSheet()->setCellValue('N1','SWEEPING');$objPHPExcel->getActiveSheet()->setCellValue('O1','CAKE');$objPHPExcel->getActiveSheet()->setCellValue('P1','DEALER');$objPHPExcel->getActiveSheet()->setCellValue('Q1','GATE');$objPHPExcel->getActiveSheet()->setCellValue('R1','Coupon');$objPHPExcel->getActiveSheet()->setCellValue('S1','Remarks');$rowCnt++;foreach($val as $key1=>$value1){$value1=explode('_%%_',$value1);$objPHPExcel->getActiveSheet()->setCellValue('A'.$rowCnt,$rowCnt - 1);$objPHPExcel->getActiveSheet()->setCellValue('B'.$rowCnt,(isset($value1[1]))?$value1[1]:'');$objPHPExcel->getActiveSheet()->setCellValue('C'.$rowCnt,(isset($value1[2]))?$value1[2]:'');$objPHPExcel->getActiveSheet()->setCellValue('D'.$rowCnt,(isset($value1[3]))?$value1[3]:'');$objPHPExcel->getActiveSheet()->setCellValue('E'.$rowCnt,(isset($value1[4]))?$value1[4]:'');$objPHPExcel->getActiveSheet()->setCellValue('F'.$rowCnt,(isset($value1[5]))?$value1[5]:'');$objPHPExcel->getActiveSheet()->setCellValue('G'.$rowCnt,(isset($value1[6]))?$value1[6]:'');$objPHPExcel->getActiveSheet()->setCellValue('H'.$rowCnt,(isset($value1[14]))?$value1[7]:'');$objPHPExcel->getActiveSheet()->setCellValue('I'.$rowCnt,(isset($value1[7]))?$value1[7]:'');$objPHPExcel->getActiveSheet()->setCellValue('J'.$rowCnt,(isset($value1[8]))?$value1[8]:'');$objPHPExcel->getActiveSheet()->setCellValue('K'.$rowCnt,(isset($value1[9]))?$value1[9]:'');$bagType=$value1[15];$bagType=explode('_-_',$bagType);if(count($bagType)>0){$bagTypeArr=array();foreach($bagType as $key11=>$value11){$val11=explode('_||_',$value11);$bagTypeArr[$val11[1]]=$val11[0];}}$objPHPExcel->getActiveSheet()->setCellValue('L'.$rowCnt,(isset($bagTypeArr[1]))?$bagTypeArr[1]:'');$objPHPExcel->getActiveSheet()->setCellValue('M'.$rowCnt,(isset($bagTypeArr[2]))?$bagTypeArr[2]:'');$objPHPExcel->getActiveSheet()->setCellValue('N'.$rowCnt,(isset($bagTypeArr[3]))?$bagTypeArr[3]:'');$objPHPExcel->getActiveSheet()->setCellValue('O'.$rowCnt,(isset($bagTypeArr[4]))?$bagTypeArr[4]:'');$objPHPExcel->getActiveSheet()->setCellValue('P'.$rowCnt,(isset($value1[10]))?$value1[10]:'');$objPHPExcel->getActiveSheet()->setCellValue('Q'.$rowCnt,(isset($value1[11]))?$value1[11]:'');$objPHPExcel->getActiveSheet()->setCellValue('R'.$rowCnt,(isset($value1[12]))?$value1[12]:'');$objPHPExcel->getActiveSheet()->setCellValue('S'.$rowCnt,(isset($value1[13]))?$value1[13]:'');foreach(range('A','R')as $columnID){$objPHPExcel->getActiveSheet()->getColumnDimension($columnID)->setAutoSize(true);}$rowCnt++;}$objPHPExcel->getActiveSheet()->setTitle($value['GateName'].'('.$value['ConveyType'].')');$sheetCnt++;}else{break;}}header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="By-Car-Gate.xls"');header('Cache-Control: max-age=0');$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');$objWriter->save('php://output');}private function validateDate($date){$d=DateTime::createFromFormat('Y-m-d',$date);return $d&&$d->format('Y-m-d')===$date;}}?>