<?php
	/***************************************************************
		* Catabatic Technology Pvt. Ltd.
		* File Name     : ContactusController.php
		* File Desc.    : Contactus controller managed all contact queries
		* Created By    : Piyush Tiwari <piyush@catpl.co.in>
		* Created Date  : 23 May 2018
		* Updated Date  : 23 May 2018
	***************************************************************/
	
	
	class Admin_ServicesController extends Zend_Controller_Action
	{
		
		public $dbAdapter;
		public $perPageLimit;
		
		
		public function init()
		{
			$options = Zend_Controller_Front::getInstance()->getParam('bootstrap')->getOption('bootstrap');
			$resultset = $this->resultset;
			$baseUrl = $options['siteUrl'];
			$this->banner_large_image_width = $options['banner_large_image_width'];
			$this->banner_large_image_height = $options['banner_large_image_height'];
			$this->banner_medium_image_width = $options['banner_medium_image_width'];
			$this->banner_medium_image_height = $options['banner_medium_image_height'];
			$this->banner_small_image_width = $options['banner_small_image_width'];
			$this->banner_small_image_height = $options['banner_small_image_height'];
			/*Initialize db and session access */
			$aConfig = $this->getInvokeArg('bootstrap')->getOptions();
			$this->siteurl = $aConfig['bootstrap']['siteUrl']; 
			$BootStrap = $aConfig['bootstrap'];
			$this->stylecss = $BootStrap['stylecss'];
			$this->per_page_record = 20; 
			$this->dbAdapter = Zend_Db_Table::getDefaultAdapter(); 
			
			$auth        = Zend_Auth::getInstance();
			$authStorage = $auth->getStorage()->read();
			$this->username      = $authStorage->username;
			$this->admin_type    = $authStorage->role;
			$this->table = 'tbl_our_services';
			$this->current_time = time();
			$this->imageUrl     = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/'.$this->stylecss.'/service/';
			$this->DIR_WRITE_MODE = 0777;
		}
		
		public function indexAction()
		{
			//Check admin logedin or not
			
			$this->checklogin();
			$this->view->messages = $this->_helper->flashMessenger->getMessages();
			$crud   = new Admin_Model_CRUD();
			$getData = array();
			if($this->getRequest()->isPost())
			{
				$getData = $this->getRequest()->getPost();
				$searchArr = array(
				'Title'=>$getData['Title'],
				'rows'=>$getData['rows'],
				'page'=>$getData['page'],
				);
				$resulsetold = $crud->getCount( $this->table,['ismarkForDel' =>0],'serviceId');  
				$crud->searchArr = $searchArr;
				$resultset = $crud->rv_select_static( $this->table,['*'],[ 'ismarkForDel' =>0],['serviceId'=> 'DESC']);  
				if (count($resultset) > 0) {
					
					// echo "<pre>";print_r($resultset);die;
					
					foreach ($resultset as $resultkey => $resultval) {
						$result1[] = [
                        'serviceId' => $resultval['serviceId'],
                        'serviceTitle' => $resultval['serviceTitle'],
                        'isActive' => $resultval['isActive']==1?'Active':'Deactive',
                        'bannerImage' => $resultval['bannerImage'],
						];
					}
				}
				$result = Zend_Json::encode($result1);
				$newResult = Zend_Json::decode($result,false);     
				$finalResult["total"]=$resulsetold[0]['serviceId'];
				$finalResult["rows"]=$newResult;
				echo json_encode($finalResult);
				exit;        
			}
		}
		
		
		public function editserviceAction(){
			//Check admin logedin or not
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$pId = $this->getRequest()->getParam("id");
			
			if(isset($pId) && $pId !=''){
				$result = $crud->getCmsdata($this->table, ['*'], ['serviceId'=>$pId], ['serviceId'=>'DESC']);
				$this->view->result = $result;
				$serviceId = $pId;
				}else{
				$lastRow = $crud->getCmsdata($this->table, ['serviceId'], ['serviceId'], ['serviceId'=>'DESC']);
				$serviceId = $lastRow['serviceId'] +1;
			}     
            
			
			if( $this->getRequest()->isPost() ) {
				$getData = $this->getRequest()->getPost();
				//             echo "<pre>";print_r($getData);die;
                //-------Start Code for Approve and Publish content---------//
				if(isset($getData['save'])=="Save") {
					$target_dir = "public/upload/".$this->stylecss."/service/";
					$uploadOk = 1;
					
					$orignalFIleName = $image = $_FILES["bannerImage"]["name"];
					$fileName = '';
					if (!empty($orignalFIleName)) {
						$fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
						$allowedExtensions = ['jpg', 'jpeg', 'gif', 'png', 'webp'];
						if(in_array($fileExt, $allowedExtensions, true)){
							$orignalFolderName  = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $serviceId;
							$fileExt    = $this->_helper->General->getFileExtension($orignalFIleName);
							$fileName   = $this->current_time . '.' . $fileExt;
							$fileName1   = $this->current_time;
							//echo"<pre>"; print_r($_SERVER); exit();
							
							if (!file_exists($orignalFolderName)) {
								mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
							}
							$temp_file_name = $_FILES["bannerImage"]["tmp_name"]; // temprary file name
							@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
							
							$originalLargeFolder = $orignalFolderName . "/large";
							$originalMediumFolder = $orignalFolderName . "/medium";
							$originalSmallFolder = $orignalFolderName . "/small";
							
							$sourceFile = $orignalFolderName . "/" . $fileName;
							$destinationFile = $orignalFolderName . "/" . $fileName1.'.webp';
							$quality = 80;
							if ($crud->convertToWebP($sourceFile, $destinationFile, $quality)) {
								if (!file_exists($originalLargeFolder)) {
									mkdir($originalLargeFolder, 0777, true);
								}
								if (!file_exists($originalMediumFolder)) {
									mkdir($originalMediumFolder, 0777, true);
								}
								if (!file_exists($originalSmallFolder)) {
									mkdir($originalSmallFolder, 0777, true);
								}
								
								@copy($destinationFile, $originalLargeFolder . "/" . $fileName1.'.webp'); 
								@copy($destinationFile, $originalMediumFolder . "/" . $fileName1.'.webp'); 
								@copy($destinationFile, $originalSmallFolder . "/" . $fileName1.'.webp'); 
								$fileName = $fileName1.'.webp';
								} else {
								$this->view->errorMessage ="Only allow  'jpg', 'png', 'webp' "; 
							}
							
							}else{
							$this->view->errorMessage ="Only allow  'jpg', 'png', 'webp' "; 
						}
					}
					
					
					$imagesrcFIleName = $_FILES["imagesrc"]["name"];
					$imagesrcvalue = $getData['imagesrcvalue'];
					$imageitems = array();
					// echo "<pre>";print_r();die;
					foreach($getData['imagetitle'] as $ww => $value){
						$srcfileName = '';
						$imagesrcfile = (isset($imagesrcFIleName[$ww]) && !empty($imagesrcFIleName[$ww])) ? $imagesrcFIleName[$ww] : '';
						if (!empty($imagesrcfile)) {
							$fileExt = $this->_helper->General->getFileExtension($imagesrcFIleName[$ww]);
							$allowedExtensions = ['jpg', 'jpeg', 'gif', 'png', 'webp'];
							if(in_array($fileExt, $allowedExtensions, true)){
								$imagesrcFolderName  = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $serviceId;
								$imagesrcfileExt    = $this->_helper->General->getFileExtension($imagesrcfile);
								
								$srcfileName = $ww.$this->current_time . '.' . $imagesrcfileExt;
								$fileName2   = $ww.$this->current_time.'.webp';
								$fileName1   = $ww.$this->current_time;
								
								if (!file_exists($imagesrcFolderName)) {
									mkdir($imagesrcFolderName, $this->DIR_WRITE_MODE, true);
								}
								$temp_file_name = $_FILES["imagesrc"]["tmp_name"][$ww]; // temprary file name
								@move_uploaded_file($temp_file_name, $imagesrcFolderName . "/" . $srcfileName);
								
								$imageitems[] = $fileName2;
								$originalLargeFolder = $imagesrcFolderName . "/large";
								$originalMediumFolder = $imagesrcFolderName . "/medium";
								$originalSmallFolder = $imagesrcFolderName . "/small";
								
								$sourceFile = $imagesrcFolderName . "/" . $srcfileName;
								$destinationFile = $imagesrcFolderName . "/" . $fileName1.'.webp';
								$quality = 80;
								if ($crud->convertToWebP($sourceFile, $destinationFile, $quality)) {
									if (!file_exists($originalLargeFolder)) {
										mkdir($originalLargeFolder, 0777, true);
									}
									if (!file_exists($originalMediumFolder)) {
										mkdir($originalMediumFolder, 0777, true);
									}
									if (!file_exists($originalSmallFolder)) {
										mkdir($originalSmallFolder, 0777, true);
									}
									
									@copy($destinationFile, $originalLargeFolder . "/" . $fileName1.'.webp'); 
									@copy($destinationFile, $originalMediumFolder . "/" . $fileName1.'.webp'); 
									@copy($destinationFile, $originalSmallFolder . "/" . $fileName1.'.webp'); 
									
									} else {
									$this->view->errorMessage ="Only allow  'jpg', 'png', 'webp' "; 
								}
								
								}else{
								$this->view->errorMessage ="Only allow  'jpg', 'png', 'webp' "; 
							}
							
							}else{
							$imageitems[] = $imagesrcvalue[$ww]; 
						}
						
					}
					 //echo "<pre>";print_r($imageitems);die;
					$imagetitle=serialize($getData['imagetitle']);				
					
					$imageurl=serialize($getData['imageurl']);				
					
					
					$editPageData = [
					'serviceTitle'=>$getData['serviceTitle'],
					'serviceIdentifier'=>strtolower(Catabatic_Helper::getSeoName($getData['serviceTitle'])),
					'serviceDescription'=>$getData['serviceDescription'],
					'metatag'=>$getData['metatag'],
					'keyword'=>$getData['keyword'],
					'description'=>$getData['description'],
					'imagetitle'=>$imagetitle,
					'imageurl'=>$imageurl,
					
					'isActive'=>$getData['isActive'],
					'isMarkFordel'=>0,
					];
					if($fileName !=''){
						$editPageData['bannerImage'] = $fileName;
					}
					$imagesrcurl=serialize($imageitems); 
					if($imageitems !=''){
						$editPageData['imagesrc'] = $imagesrcurl;
					}
					
					
					//                            echo "<pre>";print_r($editPageData);die;
					if(isset($pId) && $pId !=''){
						$crud->rv_update($this->table , $editPageData, ['serviceId =?'=>$pId]);
						}else{
						// echo "<pre>";print_r($editPageData);die;
						$crud->rv_insert($this->table , $editPageData);
					}
					
					$this->view->successMessage ="Content has been saved successfully.";
					$this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
					
					$this->_redirect("/admin/services/index");   
				}  
				
			}
			
		}
		
		
		
		public function addserviceAction(){
			
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$form = new Admin_Form_Addexplore();
			$tId = (int)$this->getRequest()->getParam("id");
			$form->setAction("admin/explore/addexplore");
			$form->setMethod("POST");
			$form->setName("add_explore");
			
			if( $this->getRequest()->isPost() ) {
				$getData = $this->getRequest()->getPost();
				if($form->isValid($getData)) {
					if(isset($getData['save'])=="Save") {
						$savePageData = [
						'columnType'=> 'explore',
						'title'=>($getData['title']),
						'url'=>($getData['link']),
						'openType'=>$getData['open_link'],
						'status'=>$getData['status_number']
						];
						// echo "<pre>";print_r($savePageData);die;
						$crud->rv_insert($this->tablefootermnage, $savePageData);
						$this->view->successMessage ="Content has been saved successfully.";
						$this->_helper->flashMessenger->addMessage("Content has been added successfully.");
						
						$this->_redirect("/admin/explore/index");
						
					}
					
				}
				
			}
			
			$this->view->form = $form;
			$this->view->messages   = $this->_helper->flashMessenger->getMessages();
			} 
			
			public function deleteserviceAction(){
				$this->checklogin();
				$crud = new Admin_Model_CRUD();
				$tId = (int)$this->getRequest()->getParam("id");
				if($tId){
					$checkdata = $crud->rv_select_row($this->table, ['serviceId'], ['serviceId'=>$tId], ['serviceId'=>'asc']);
					if(count($checkdata)>0){
						//  $crud->rv_delete($this->table, ['serviceId =?'=>$tId]);
						$crud->rv_update($this->table, ['isMarkForDel'=> 1], ['serviceId  =?'=>$tId]);
						$this->_helper->flashMessenger->addMessage("Delete successfully.");
						$this->_redirect("/admin/services/index");
						}else{
						die('Oops some thing wrong!!.');
					}  
				}
			}
			
			
			public function deleteimageAction() {
				$this->checklogin();
				$this->_helper->viewRenderer->setNoRender(true);
				$this->_helper->layout->disableLayout(); // disable layouts
				
				$param = $this->getRequest()->getParams();
				
				$id = $param['id'];
				$images = $param['images'];
				
				unlink("public/upload/service/$images");
				// echo $this->table; die($id);
				
				$crud = new Admin_Model_CRUD();
				// die("h");
				
				
				$result = $crud->getCmsdata($this->table, ['bannerImage'], ['serviceId'=>$id], ['serviceId' => 'DESC']);
				//print_r($result); die();
				$strImages = $result['bannerImage'];
				//print_r($strImages);die();
				$arrImages = explode(",", $strImages);
				foreach ($arrImages as $key => $value) {
					if (trim($value) == trim($images)) {
						unset($arrImages[$key]);
					}
				}
				
				$strImages = trim(implode(",", $arrImages), ",");
				if($strImages === ""){
					$strImages = null;
				}
				// die($strImages);
				$crud->rv_update($this->table, ['bannerImage' => $strImages], ['serviceId =?' => $id]);
				$response = array("status"=>true,"msg"=>"Deleted Successfully");
				echo json_encode($response);
				exit;
			}
			
			public function sanitize_data($string) {
				$searchArr=array("iframe","script","document","write","alert","%","@","$",";","+","|","#","<",">",")","(","'","\'",",","and "," &","& ","and"," and","0","1","2","3","4","5","6","7","8","9");
				$input_data = strtolower($string);
				$input_data = str_replace($searchArr,"",$input_data);
				
				$input_data= str_replace(" ","-",$input_data);
				//echo $input_data; die;
				return $input_data;
			}
			
			
			public function update_json_footer( $type )
			{
				$this->checklogin();
				$crud   = new Admin_Model_CRUD();
				
				
				$resultset  = $crud->rv_select_all("tbl_social_links",['name','link'] ,  ['status'=>1] , ['name'=>'ASC' ] );
				$footer_destination = $crud->rv_select_all("tb_tbb2c_destinations",[ 'Title'] ,  ['IsActive'=>1 , 'IsPublish' => 1, 'IsMarkForDel' => 0 , 'DisplayOnFooter' => 1 ] , ['Tours'=>'DESC' ] , 10 );
				$this->_helper->General->update_json_footer_file( $resultset , $footer_destination );
			}
			
			
			/**
				* checklogin() method is used to check admin logedin or not
				* @param Null
				* @return Array 
			*/
			public function checklogin()
			{
				if(($this->admin_type == "superadmin") || ($this->admin_type == "admin"))
				{
					$auth = Zend_Auth::getInstance();
					$hasIdentity = $auth->hasIdentity();
					/*************** check admin identity ************/
					if(!$hasIdentity)  
					{  
						$this->_redirect('admin/index/index');  
					} 
					}  else {
					$this->_redirect('admin/index/index');   
				} 
			}
		}