<?php
/***************************************************************
* Catabatic Technology Pvt. Ltd.
* File Name     : StaticpageController.php
* File Desc.    : Staticpage controller managed all staic content pages
* Created By    : Ranvir Singh <ranvir@catpl.co.in>
* Created Date  : 23 May 2017
* Updated Date  : 23 May 2017
***************************************************************/



class Admin_StaticpageController extends Zend_Controller_Action
{
    

    public $per_page_record;
    
    
    public function init()
    {
       /*Initialize db and session access */
      $aConfig = $this->getInvokeArg('bootstrap')->getOptions();
        $this->siteurl           = $aConfig['bootstrap']['siteUrl']; 
        $this->appmode = $aConfig['bootstrap']['appmode'];
        $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->current_time = time();
        $this->imageUrl     = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/static_pages/';
         $this->imageUrlHome = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/homebanner/';

        $this->img_w_small  = 120;
        $this->img_h_small  = 120;

        $this->img_w_large = 1600;
        $this->img_h_large = 500;
         
        //$this->img_w_large_banner = 1600;
        //$this->img_h_large_banner = 600;

        
        $this->DIR_WRITE_MODE = 0777;

    }
    
    
    
    /**
    * index() method is used to admin login for form call
    * @param Null
    * @return Array 
    */
    
    public function indexAction()
    {
        //Check admin logedin or not
        $this->checklogin();
        $crud   = new Admin_Model_CRUD();
        $resultset  = $crud->rv_select_all("tbl_static_pages", ['*'], ['status'], ['sid'=>'DESC']);
//        echo "<pre>";print_r($resultset);die;
                
        # Start : Pagination 
        $page       = $this->_getParam('page', 1);
        $resultset  = Zend_Paginator::factory($resultset);
        $resultset->setItemCountPerPage($this->per_page_record);
        $resultset->setCurrentPageNumber($page);
        # End : Pagination
        
        $this->view->resultset  = $resultset;
        $this->view->messages   = $this->_helper->flashMessenger->getMessages();
    }
    
        public function queryAction() {
        
        //Check admin logedin or not
        $this->checklogin();
        $crud   = new Admin_Model_CRUD();
        $resultset  = $crud->rv_select_all("tbl_query", ['*'], ['status'], ['id'=>'DESC']);
//        echo "<pre>";print_r($resultset);die;
                
        # Start : Pagination 
        $page       = $this->_getParam('page', 1);
        $resultset  = Zend_Paginator::factory($resultset);
        $resultset->setItemCountPerPage($this->per_page_record);
        $resultset->setCurrentPageNumber($page);
        # End : Pagination
        
        $this->view->resultset  = $resultset;
        $this->view->messages   = $this->_helper->flashMessenger->getMessages();
        
    }
    
    public function addqueryAction() {
        
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editquery();
        $tId = (int) $this->getRequest()->getParam("id");
        $form->setAction("admin/staticpage/addquery");
        $form->setMethod("POST");
        $form->setName("add_query");

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            if ($form->isValid($getData)) {
                if (isset($getData['save']) == "Save") {

                    $savePageData = [
                        'phone'=>trim($getData['phone']),
                        'email'=>  trim($getData['email']),
                        'location'=>$getData['location'],
                        'status'=>$getData['status'],
                    ];

                    $crud->rv_insert('tbl_query', $savePageData);
                    $this->view->successMessage = "Content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Content has been added successfully.");

                    $this->_redirect("/admin/staticpage/query");
                }
            }
        }

        $this->view->form = $form;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }
    
    public function editqueryAction() {
                //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editquery();
        $pId = (int)$this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/staticpage/editquery/id/".$pId);
        $form->setName("edit_query");
               
        if( $this->getRequest()->isPost() ) {
          
          $getData = $this->getRequest()->getPost();
                
                //-------Start Code for Approve and Publish content---------//
               if(isset($getData['save'])=="Save") {
                        
                    //Code for check page alias name already exists or not
                    $page_id = (int) @$getData['id'];

                                $editPageData = [
                                    'phone'=>trim($getData['phone']),
                                    'mobile'=>trim($getData['mobile']),
                                    'email'=>  trim($getData['email']),
                                    'location'=>$getData['location'],
                                    'footer_heading1'=>$getData['footer_heading1'],
                                    'footer_heading2'=>$getData['footer_heading2'],
                                    'footer_heading3'=>$getData['footer_heading3'],
                                    'footer_heading4'=>$getData['footer_heading4'],
                                     'footer_description1'=>$getData['footer_description1'],
                                    'footer_description2'=>$getData['footer_description2'],
                                    'footer_description3'=>$getData['footer_description3'],
                                    'copyrighttext' => $getData['copyrighttext'],
                                    'footer_description4'=>$getData['footer_description4'],
                                    'status'=>$getData['status'],
                                    ];
                                $crud->rv_update('tbl_query', $editPageData, ['id =?'=>$page_id]);
                                $this->view->successMessage ="Page content has been saved successfully.";
                                $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                                $this->_redirect("/admin/staticpage/query");
                           
             }  

        }

        $result = $crud->getCmsdata('tbl_query', ['*'], ['id'=>$pId], ['id'=>'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["id"] = @$result->id;
        $editdata["phone"] = @$result->phone;
        $editdata["mobile"] = @$result->mobile;
        $editdata["location"] = @$result->location;
        $editdata["email"] = @$result->email;
        $editdata["status"] = @$result->status;
        $editdata["footer_heading1"] = @$result->footer_heading1;
        $editdata["footer_heading2"] = @$result->footer_heading2;
        $editdata["footer_heading3"] = @$result->footer_heading3;
        $editdata["footer_heading4"] = @$result->footer_heading4;
        $editdata["footer_description1"] = @$result->footer_description1;
        $editdata["footer_description2"] = @$result->footer_description2;
        $editdata["footer_description3"] = @$result->footer_description3;
        $editdata["footer_description4"] = @$result->footer_description4;
        $editdata["copyrighttext"] = @$result->copyrighttext;
        $form->populate($editdata);
        $this->view->form = $form;
    }
    
    /**
    * editpage() method is used to admin can edit cms static page
    * @param password string
    * @return ture 
    */
    public function editpageAction()
    {
        //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editstaticpage();
        $pId = (int)$this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/staticpage/editpage/id/".$pId);
        $form->setName("edit_static_page");
               
        if( $this->getRequest()->isPost() ) {
          
          $getData = $this->getRequest()->getPost();
          
//          print_r($getData);
//          echo "<pre>";
//            print_r($form->getErrors());
////            var_dump($form);
//            die;
          if($form->isValid($getData)) {
                
                //-------Start Code for Approve and Publish content---------//
               if(isset($getData['save'])=="Save") {
                        
                    //Code for check page alias name already exists or not
                    $page_id = (int) @$getData['sid'];


                     $images = $_FILES['background_image']['name'];  
                    if (!empty($images)) {
                                 $orignalFolderName  = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl ;
                                 $fileExt    = $this->_helper->General->getFileExtension($images);
                                 $fileName   = $page_id.'_'.$this->current_time . '.' . $fileExt;
                                                                   
                                    if (!file_exists($orignalFolderName)) {
                                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                                        }
                                  $temp_file_name = $_FILES["background_image"]["tmp_name"]; // temprary file name

                                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
                                
                                 
                             }
                     if($fileName!=""){ 
                                $image_edit = $fileName;    
                            }
                                $page_id = $getData['sid'];

                                $editPageData = [
                                    'page_title'=>($getData['page_title']),
                                    'identifier'=>  strtolower(Catabatic_Helper::getSeoName($getData['page_title'])),
                                    'meta_title'=>$getData['meta_title'],
                                    'meta_keywords'=>$getData['meta_keywords'],
                                    'meta_description'=>$getData['meta_description'],
                                   
                                    'page_description'=>$getData['page_description'],
                                    'status'=>$getData['status'],
                                    'displayOnFooter'=>$getData['displayOnFooter'],
                                    'updatedOn'=> date("Y-m-d H:i:s"),
                                    ];
                                
                                 if($fileName){
                                    $editPageData['background_image'] = $image_edit;
                                    }
                                $crud->rv_update('tbl_static_pages', $editPageData, ['sid =?'=>$page_id]);
                                $this->view->successMessage ="Page content has been saved successfully.";
                                $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                                $this->_redirect("/admin/staticpage/index");
                           
             }  
             
          } else {
              die('form invalid');
          }

        }

        $result = $crud->getCmsdata('tbl_static_pages', ['*'], ['sid'=>$pId], ['sid'=>'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["sid"] = @$result->sid;
        $editdata["page_title"] = @$result->page_title;
        $editdata["meta_title"] = @$result->meta_title;
        $editdata["meta_keywords"] = @$result->meta_keywords;
        $editdata["meta_description"] = @$result->meta_description;
        $editdata["background_image"] = @$result->background_image;
        $editdata["page_description"] = @$result->page_description;
        $editdata["status"] = @$result->status;
        $editdata["displayOnFooter"] = @$result->displayOnFooter;
        $form->populate($editdata);
        
        $this->view->background_image = @$result->background_image; 
        $this->view->form = $form;
        
                    
    }
    
        public function deletequeryAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        if ($tId) {
            $checkdata = $crud->rv_select_row('tbl_query', ['id'], ['id' => $tId], ['id' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_delete('tbl_query', ['id =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/staticpage/query");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }
    
    
     public function homeAction() {
        //Check admin logedin or not
        $this->checklogin();
        $crud   = new Admin_Model_CRUD();
        $resultset  = $crud->rv_select_all("tb_homebanner_detail", ['*'], ['status'], ['banner_id'=>'DESC']);
//        echo "<pre>";print_r($resultset);die;
                
        # Start : Pagination 
        $page       = $this->_getParam('page', 1);
        $resultset  = Zend_Paginator::factory($resultset);
        $resultset->setItemCountPerPage($this->per_page_record);
        $resultset->setCurrentPageNumber($page);
        # End : Pagination
        
        $this->view->resultset  = $resultset;
        $this->view->messages   = $this->_helper->flashMessenger->getMessages();
    }
    
    public function addhomeAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Edithome();
        $form->setAction("admin/staticpage/addhome");
        $form->setMethod("POST");
        $form->setName("add_home");
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            if ($form->isValid($getData)) {
                if (isset($getData['save']) == "Save") {

                    $images = $_FILES['banner_image']['name'];
                   
                    $savePageData = [
                        'banner_text' => trim($getData['banner_text']),
                        'banner_text1' => trim($getData['banner_text1']),
                        'banner_text_button' => trim($getData['banner_text_button']),
                        'url' => trim($getData['url']),
                        'opt' => $getData['opt'][0],
                        'status' => $getData['status'],
                    ];
                    $banner_id = $crud->rv_insert('tb_homebanner_detail', $savePageData);
                    
                    if (isset($images) && !empty($images)) {
                    $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
                    $fileExt = $this->_helper->General->getFileExtension($images);
                    $fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;

                    $originalLargeFolder = $orignalFolderName . "/large";

                    if (!file_exists($orignalFolderName)) {
                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                    }
                    if (!file_exists($originalLargeFolder)) {
                        mkdir($originalLargeFolder, $this->DIR_WRITE_MODE, true);
                    }
                    $temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name

                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                    @copy($orignalFolderName . '/' . $fileName, $originalLargeFolder . "/" . $fileName); // copy uploaded file into this location directory
                    $objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileName);
                    $objImageResize4->resizeImage($this->img_w_large_banner , $this->img_h_large_banner , 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
                    $objImageResize4->saveImage($originalLargeFolder . '/' . $fileName);
                }
                    $editPageData = [
                        'banner_image' => $fileName
                    ];    
                    $crud->rv_update('tb_homebanner_detail', $editPageData, ['banner_id =?' => $banner_id]);
                    $this->view->successMessage = "Content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Content has been added successfully.");
                    $this->_redirect("/admin/staticpage/home");
                         
                }
               
            }
        }

        $this->view->form = $form;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }

    public function edithomeAction(){
        //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Edithome();
        $banner_id = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/staticpage/edithome/id/" . $banner_id);
        $form->setName("edit_home");

        if ($this->getRequest()->isPost()) {

            $getData = $this->getRequest()->getPost();
            //echo"<pre>";print_r($getData);die;
//            explode();
            //-------Start Code for Approve and Publish content---------//
            if (isset($getData['save']) == "Save") {

                //Code for check page alias name already exists or not
                $banner_id = (int)$banner_id;

                $images = $_FILES['banner_image']['name'];

                if (isset($images) && !empty($images)) {
                    $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
                    $fileExt = $this->_helper->General->getFileExtension($images);
                    $fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;

                    $originalLargeFolder = $orignalFolderName . "/large";

                    if (!file_exists($orignalFolderName)) {
                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                    }
                    if (!file_exists($originalLargeFolder)) {
                        mkdir($originalLargeFolder, $this->DIR_WRITE_MODE, true);
                    }
                    $temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name

                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                    @copy($orignalFolderName . '/' . $fileName, $originalLargeFolder . "/" . $fileName); // copy uploaded file into this location directory
                    $objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileName);
                    $objImageResize4->resizeImage($this->img_w_large_banner , $this->img_h_large_banner , 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
                    $objImageResize4->saveImage($originalLargeFolder . '/' . $fileName);
                }
                
                if ($fileName != "") {
                        $image_edit = $fileName;
                }

                $editPageData = [
                    'banner_text' => trim($getData['banner_text']),
                    'banner_text1' => trim($getData['banner_text1']),
                    'banner_text_button' => trim($getData['banner_text_button']),
                     'url' => trim($getData['url']),
                        'opt' => $getData['opt'][0],
                        'status' => $getData['status'],
                ];
                
                if ($fileName) {
                        $editPageData['banner_image'] = $image_edit;
                }
                // echo"<pre>";print_r($editPageData);die;
                $crud->rv_update('tb_homebanner_detail', $editPageData, ['banner_id =?' => $banner_id]);
                $this->view->successMessage = "Page content has been saved successfully.";
                $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                $this->_redirect("/admin/staticpage/home");
            }
        }


        $result = $crud->getCmsdata('tb_homebanner_detail', ['*'], ['banner_id' => $banner_id], ['banner_id' => 'DESC']);

        $editdata["banner_id"] = @$result->banner_id;
        $editdata["banner_text"] = @$result->banner_text;
        $editdata["banner_text1"] = @$result->banner_text1;
        $editdata["banner_text_button"] = @$result->banner_text_button;
        $editdata["url"] = @$result->url;
        $editdata["opt"] = @$result->opt;
        $editdata["status"] = @$result->status;
        $editdata["banner_image"] = @$result->banner_image;
        $form->populate($editdata);
        $this->view->banner_id = @$result->banner_id;
        $this->view->form = $form;
        $this->view->banner_image = @$result->banner_image;
        $this->view->opt = @$result->opt;
    }
    
    
     public function deletehomeAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        if ($tId) {
            $checkdata = $crud->rv_select_row('tb_homebanner_detail', ['banner_id'], ['banner_id' => $tId], ['banner_id' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_delete('tb_homebanner_detail', ['banner_id =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/staticpage/home");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }
    
      public function explorehomeAction() {
        //Check admin logedin or not
        $this->checklogin();
        $crud   = new Admin_Model_CRUD();
        $resultset  = $crud->rv_select_all("tbl_home_explorebanner", ['*'], ['status'], ['banner_id'=>'DESC']);
//        echo "<pre>";print_r($resultset);die;
                
        # Start : Pagination 
        $page       = $this->_getParam('page', 1);
        $resultset  = Zend_Paginator::factory($resultset);
        $resultset->setItemCountPerPage($this->per_page_record);
        $resultset->setCurrentPageNumber($page);
        # End : Pagination
        
        $this->view->resultset  = $resultset;
        $this->view->messages   = $this->_helper->flashMessenger->getMessages();
    }
    
    
       public function addexplorehomeAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Edithome();
        $form->setAction("admin/staticpage/addexplorehome");
        $form->setMethod("POST");
        $form->setName("add_explorehome");
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            if ($form->isValid($getData)) {
                if (isset($getData['save']) == "Save") {

                    $images = $_FILES['banner_image']['name'];
                   
                    $savePageData = [
                        'banner_text' => trim($getData['banner_text']),
                        'url' => trim($getData['url']),
                        'opt' => $getData['opt'][0],
                        'status' => $getData['status'],
                    ];
                    $banner_id = $crud->rv_insert('tbl_home_explorebanner', $savePageData);
                    
                    if (isset($images) && !empty($images)) {
                    $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
                    $fileExt = $this->_helper->General->getFileExtension($images);
                    $fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;

                    $originalLargeFolder = $orignalFolderName . "/large";

                    if (!file_exists($orignalFolderName)) {
                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                    }
                    if (!file_exists($originalLargeFolder)) {
                        mkdir($originalLargeFolder, $this->DIR_WRITE_MODE, true);
                    }
                    $temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name

                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                    @copy($orignalFolderName . '/' . $fileName, $originalLargeFolder . "/" . $fileName); // copy uploaded file into this location directory
                    $objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileName);
                    $objImageResize4->resizeImage($this->img_w_large, $this->img_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
                    $objImageResize4->saveImage($originalLargeFolder . '/' . $fileName);
                }
                    $editPageData = [
                        'banner_image' => $fileName
                    ];    
                    $crud->rv_update('tbl_home_explorebanner', $editPageData, ['banner_id =?' => $banner_id]);
                    $this->view->successMessage = "Content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Content has been added successfully.");
                    $this->_redirect("/admin/staticpage/explorehome");
                }
            }
        }

        $this->view->form = $form;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }
  public function editexplorehomeAction(){
        //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editexplorehome();
        $banner_id = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/staticpage/editexplorehome/id/" . $banner_id);
        $form->setName("edit_explorehome");

        if ($this->getRequest()->isPost()) {

            $getData = $this->getRequest()->getPost();
//            echo"<pre>";print_r($getData);die;
//            explode();
            //-------Start Code for Approve and Publish content---------//
            if (isset($getData['save']) == "Save") {

                //Code for check page alias name already exists or not
                $banner_id = (int) @$getData['banner_id'];

                $images = $_FILES['banner_image']['name'];

                if (isset($images) && !empty($images)) {
                    $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
                    $fileExt = $this->_helper->General->getFileExtension($images);
                    $fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;

                    $originalLargeFolder = $orignalFolderName . "/large";

                    if (!file_exists($orignalFolderName)) {
                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                    }
                    if (!file_exists($originalLargeFolder)) {
                        mkdir($originalLargeFolder, $this->DIR_WRITE_MODE, true);
                    }
                    $temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name

                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);

                    @copy($orignalFolderName . '/' . $fileName, $originalLargeFolder . "/" . $fileName); // copy uploaded file into this location directory
                    $objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileName);
                    $objImageResize4->resizeImage($this->img_w_large, $this->img_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
                    $objImageResize4->saveImage($originalLargeFolder . '/' . $fileName);
                }
                
                if ($fileName != "") {
                        $image_edit = $fileName;
                }

                $editPageData = [
                    'banner_text' => trim($getData['banner_text']),
                     'url' => trim($getData['url']),
                        'opt' => $getData['opt'][0],
                        'status' => $getData['status'],
                ];
                
                if ($fileName) {
                        $editPageData['banner_image'] = $image_edit;
                }
                
                $crud->rv_update('tbl_home_explorebanner', $editPageData, ['banner_id =?' => $banner_id]);
                $this->view->successMessage = "Page content has been saved successfully.";
                $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                $this->_redirect("/admin/staticpage/explorehome");
            }
        }


        $result = $crud->getCmsdata('tbl_home_explorebanner', ['*'], ['banner_id' => $banner_id], ['banner_id' => 'DESC']);

        $editdata["banner_id"] = @$result->banner_id;
        $editdata["banner_text"] = @$result->banner_text;
        $editdata["url"] = @$result->url;
        $editdata["opt"] = @$result->opt;
        $editdata["status"] = @$result->status;
        $editdata["banner_image"] = @$result->banner_image;
        $form->populate($editdata);
        $this->view->banner_id = @$result->banner_id;
        $this->view->form = $form;
        $this->view->banner_image = @$result->banner_image;
        $this->view->opt = @$result->opt;
    }
    
     public function deleteexplorehomeAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        if ($tId) {
            $checkdata = $crud->rv_select_row('tbl_home_explorebanner', ['banner_id'], ['banner_id' => $tId], ['banner_id' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_delete('tbl_home_explorebanner', ['banner_id =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/staticpage/explorehome");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }
    
    
    
    
    
    
    
     public function homecommonAction(){
        //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        
        if( $this->getRequest()->isPost() ) {
            $getData = $this->getRequest()->getPost();
            if(isset($getData['save'])=="Save") {
                   $editPageData = [
                            'metaTitle'=>($getData['metaTitle']),
                            'Keyword'=>($getData['Keyword']),
                            'Description'=>($getData['Description']),
                            'home_common_header'=>($getData['home_common_header']),
                            'home_common_footer'=>($getData['home_common_footer']),
                            'status' => ($getData['status']),
                        ];
//                        echo "<pre>";print_r($editPageData);die;
                        $crud->rv_update('tbl_home_common_box', $editPageData, ['home_common_id =?'=>1]);
                        $this->view->successMessage ="Content has been updated successfully.";
                        $this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
//                        $this->_redirect("/admin/social/commonbox");   
             }  
        }
        
        $common_result = $crud->getCmsdata('tbl_home_common_box', ['*'], ['home_common_id'], ['home_common_id'=>'DESC']);
       
         $this->view->common_result = $common_result;
        
    }
    
    
    
    
    
    
    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;
    }
    
    
   
    /**
    * 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');  
            } 
        }  else {
            $this->_redirect('admin/index');   
        } 
    }
    
     public function officesAction() {
                //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();

        if( $this->getRequest()->isPost() ) {
          
          $getData = $this->getRequest()->getPost();
                echo "<pre>";prnt_r($getData);die;
                //-------Start Code for Approve and Publish content---------//
               if(isset($getData['save'])=="Save") {
                      
                                $editPageData = [

                                    
                                    
                                    
                                    ];
                                echo "<pre>";print_r($editPageData);die;
                                $crud->rv_update('tbl_query', $editPageData, ['id =?'=>1]);
                                $this->view->successMessage ="Page content has been saved successfully.";
                                $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                                $this->_redirect("/admin/staticpage/offices");
                           
             }  

        }

        $result = $crud->getCmsdata('tbl_query', ['*'], ['id'=>$pId], ['id'=>'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["id"] = @$result->id;
        $editdata["phone"] = @$result->phone;
        $editdata["location"] = @$result->location;
        $editdata["email"] = @$result->email;
        $editdata["status"] = @$result->status;
        $editdata["footer_heading1"] = @$result->footer_heading1;
        $editdata["footer_heading2"] = @$result->footer_heading2;
        $editdata["footer_heading3"] = @$result->footer_heading3;
        $editdata["footer_heading4"] = @$result->footer_heading4;
        $editdata["footer_description1"] = @$result->footer_description1;
        $editdata["footer_description2"] = @$result->footer_description2;
        $editdata["footer_description3"] = @$result->footer_description3;
        $editdata["footer_description4"] = @$result->footer_description4;
        $form->populate($editdata);
        $this->view->form = $form;
    }
    
    
}