<?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_SocialController extends Zend_Controller_Action
	{
		
		public $dbAdapter;
		public $perPageLimit;
		
		
		public function init()
		{
			/*Initialize db and session access */
			$aConfig = $this->getInvokeArg('bootstrap')->getOptions();
			$this->siteurl = $aConfig['bootstrap']['siteUrl']; 
			$this->per_page_record = 20; 
			$this->dbAdapter = Zend_Db_Table::getDefaultAdapter(); 
			$BootStrap  = $aConfig['bootstrap'];
			$this->gtxagencysysid = $BootStrap['gtxagencysysid'];
			$this->stylecss = $BootStrap['stylecss'];
			$auth        = Zend_Auth::getInstance();
			$authStorage = $auth->getStorage()->read();
			$this->username      = $authStorage->username;
			$this->admin_type    = $authStorage->role;
			$this->tablesocial = 'tbl_social_links';
			
		}
		
		
		/**
			* index() method is used to admin login for form call
			* @param Null
			* @return Array 
		*/
		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->tablesocial,['status' =>1],'id');  
				$crud->searchArr = $searchArr;
				$resultset = $crud->rv_select_static( $this->tablesocial,['id','name','link','status'],[''],['id'=> 'DESC']);  
				
				if (count($resultset) > 0) {
					foreach ($resultset as $resultkey => $resultval) {
						$result1[] = [
                        'id' => $resultval['id'],
                        'name' => $resultval['name'],
                        'link' => $resultval['link'],
                        'status' => $resultval['status']==1?'Active':'Deactive',
						];
					}
				}
				$result = Zend_Json::encode($result1);
				$newResult = Zend_Json::decode($result,false);     
				$finalResult["total"]=$resulsetold[0]['id'];
				$finalResult["rows"]=$newResult;
				echo json_encode($finalResult);
				exit;        
			}
		}
		
		
		public function editsocialAction(){
			
			//Check admin logedin or not
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$form = new Admin_Form_Editsocial();
			$pId = (int)$this->getRequest()->getParam("id");
			$form->setMethod("POST");
			$form->setAction("admin/social/editsocial/id/".$pId);
			$form->setName("edit_social_page");
			
			if( $this->getRequest()->isPost() ) {
				$getData = $this->getRequest()->getPost();
				
				if($form->isValid($getData)) {
					
					//-------Start Code for Approve and Publish content---------//
					if(isset($getData['save'])=="Save") {
						$editPageData = [
						'name'=>($getData['name']),
						'link'=>($getData['link']),
						'status'=>"{$getData['status_number']}"
                        ];
						//                            echo "<pre>";print_r($editPageData);die;
                        $crud->rv_update('tbl_social_links', $editPageData, ['id =?'=>$pId]);
                        $this->view->successMessage ="Content has been saved successfully.";
                        $this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
                        $this->update_json_footer('social_links');
                        $this->_redirect("/admin/social/index");   
					}  
					
				}
			}
			
			$result = $crud->getCmsdata('tbl_social_links', ['*'], ['id'=>$pId], ['id'=>'DESC']);
			//echo "<pre>";print_r($result);die;
			$editdata["id"] = @$result->id;
			$editdata["name"] = @$result->name;
			$editdata["link"] = @$result->link;
			$editdata["status_number"] = @$result->status;
			
			$form->populate($editdata);
			
			
			$this->view->form = $form;
			//die('ok');
		}
		public function addsocialAction(){
			
			
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$form = new Admin_Form_Addsocial();
			$tId = (int)$this->getRequest()->getParam("id");
			$form->setAction("admin/social/addsocial");
			$form->setMethod("POST");
			$form->setName("add_social");
			
            if( $this->getRequest()->isPost() ) {
                $getData = $this->getRequest()->getPost();
                if($form->isValid($getData)) {
					if(isset($getData['save'])=="Save") {
                        $savePageData = [
						'name'=>($getData['name']),
						'link'=>($getData['link']),
						'status'=>$getData['status_number']
                        ];
						
                        $crud->rv_insert('tbl_social_links', $savePageData);
                        $this->view->successMessage ="Content has been saved successfully.";
                        $this->_helper->flashMessenger->addMessage("Content has been added successfully.");
                        $this->update_json_footer('social_links');
                        $this->_redirect("/admin/social/index");
                        
					}
					
				}
                
			}
			
			$this->view->form = $form;
			$this->view->messages   = $this->_helper->flashMessenger->getMessages();
		}
		
		
		public function deletesocialAction(){
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$tId = (int)$this->getRequest()->getParam("id");
			if($tId){
				$checkdata = $crud->rv_select_row('tbl_social_links', ['id'], ['id'=>$tId], ['id'=>'asc']);
				if(count($checkdata)>0){
					$crud->rv_delete('tbl_social_links', ['id =?'=>$tId]);
					$this->_helper->flashMessenger->addMessage("Delete successfully.");
					$this->_redirect("/admin/social/index");
					}else{
					die('Oops some thing wrong!!.');
				}  
			}
		}
		
		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 )
		{
			$crud   = new Admin_Model_CRUD();
			//        if($type == 'social_links') {
			//            $resultset1  = $crud->rv_select_all("tbl_social_links",['name','link'] ,  ['status'=>1] , ['name'=>'ASC' ] );
			////            if( !file_exists('public/data/static/footer.json') ) {
			//                $resultset1_json = Zend_Json::encode($resultset1);
			//                file_put_contents( 'public/data/static/social.json', $resultset1_json); // create file here
			////            }
			//        }
			//        else if($type == 'footer_links') {
			//            $resultset1  = $crud->rv_select_all("tbl_footer_links",['name','link'] ,  ['status'=>1] , ['name'=>'ASC' ] );
			//            $resultset1_json = Zend_Json::encode($resultset1);
			//                file_put_contents( 'public/data/static/footer.json', $resultset1_json); // create file here
			//            
			//        }
			
			$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');   
			} 
		}
		public function commonboxAction(){
			
			//Check admin logedin or not
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			$pId = (int)$this->getRequest()->getParam("id");
			if( $this->getRequest()->isPost() ) {
				$getData = $this->getRequest()->getPost();
				// echo "<pre>";print_r( $getData);die;
				if(isset($getData['save'])=="Save") {
					$editPageData = [
					'metaTitle' => ($getData['metaTitle']),
					'Keyword' => ($getData['Keyword']),
					'Description' => ($getData['Description']),
					'status' => (int)($getData['status']),
					'common_content_header_1'=>($getData['common_content_header_1']),
					'common_content_header_2'=>($getData['common_content_header_2']),
					'common_content_header_3'=>($getData['common_content_header_3']),
					'common_content_body_1'=>($getData['common_content_body_1']),
					'common_content_footer_1'=>($getData['common_content_footer_1']),
					'common_content_footer_2'=>($getData['common_content_footer_2']),
					'common_content_footer_3'=>($getData['common_content_footer_3']),
					'AgencySysId'=>($this->gtxagencysysid),
					];
					
					$crud->rv_update('tbl_common_box', $editPageData, ['AgencySysId =?'=>$this->gtxagencysysid]);
					$this->view->successMessage ="Content has been updated successfully.";
					//echo "<pre>";print_r($editPageData);die;
					$this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
                    $this->_redirect("/admin/social/commonbox");   
				}  
			}
			
			$common_result = $crud->getCmsdata('tbl_common_box', ['*'], ['common_id'], ['common_id'=>'DESC']);
			
			
			$this->view->common_result = $common_result;
			
			
		}
		public function enquiryimageAction(){
			
			$this->checklogin();
			$crud = new Admin_Model_CRUD();
			
			if( $this->getRequest()->isPost() ) {
				$getData = $this->getRequest()->getPost();
				
				//echo "<pre>";print_r($getData);die;
				if($getData) {
					
					if (isset($getData['save']) == "Save") {
						$pId = $getData['image_id'];					
						
						$imageurl = isset($getData['imageurl']) ? trim($getData['imageurl']) : '';
						$image_url_id = isset($getData['image_url_id']) ? trim($getData['image_url_id']) : '';
						
						
						
						$_FILES["imageurl"]["name"];
						$_FILES["imageurl"]["size"];
						
						
						if (!empty($_FILES["imageurl"]["name"])) {
							$orignalFolderName = $_SERVER["DOCUMENT_ROOT"]  . '/public/upload/'.$this->stylecss.'/images/';
							$fileExtion = $this->_helper->General->getFileExtension($_FILES["imageurl"]["name"]);
							$bfileName =  'enquiry' . '_'.$this->stylecss.'.'.$fileExtion;
							$fileName1 =  'enquiry' . '_'.$this->stylecss;
							$allowedExtensions = ['jpg', 'jpeg', 'gif', 'png', 'webp'];
								if(in_array($fileExtion, $allowedExtensions, true)){
								if (!file_exists($orignalFolderName)) {
									mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
								}
								$temp_file_name = $_FILES["imageurl"]["tmp_name"]; // temprary file name
								@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $bfileName);
								$sourceFile = $orignalFolderName . "/" . $bfileName;
					$destinationFile = $orignalFolderName . "/" . $fileName1.'.webp';
					$quality = 80;
				
					if ($crud->convertToWebP($sourceFile, $destinationFile, $quality)) {
							
								 
								$bfileName = $fileName1.'.webp';
						} 
						  } else {
							$this->view->errorMessage ="Only allow  'jpg', 'png', 'webp' "; 
							}	
							
						}
						
						if(!empty($bfileName)){
							$imageurl = $bfileName;
							}else{
							$imageurl = $image_url_id;
						}
						
						$editPageData = [
						'imageurl' =>$imageurl,                                                         
						'status' =>1
						];
						
						if(empty($pId)){
							$crud->rv_insert('tb_enquiry_image', $editPageData);
							}else{
						    $crud->rv_update('tb_enquiry_image', $editPageData, ['AgencySysId =?' => $this->gtxagencysysid]);
						}
					}
					
				}
				$this->view->successMessage = "Page content has been updated successfully.";
			}
			
			$result = $crud->getCmsdata('tb_enquiry_image', ['*'], ['AgencySysId' => $this->gtxagencysysid], ['image_id'=>'DESC']);
			$editdata["image_id"] = $result->image_id;
			$editdata["imageurl"] = $result->imageurl;
			
			$this->view->editdata = $editdata;
			
			
			
		}
	}