<?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_AboutindoasiaController extends Zend_Controller_Action {

    public $dbAdapter;
    public $perPageLimit;
    public $siteurl;
    public $DIR_WRITE_MODE;

    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/aboutIndoasia/';
        $this->imageUrlAwards = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/awards/';
        $this->imageUrlAccreditationsClient = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/accreditations-client/';
        $this->imageUrlClient = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/accreditations-client/clients';

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

        $this->DIR_WRITE_MODE = 0777;

        $this->table = 'tbl_about_indoasia';
        $this->tableAwards = 'tbl_accolades_awards';
        $this->tableClients = 'tbl_accreditations_client';
    }

    /**
     * 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($this->table, ['*'], ['IsMarkForDel' => 0], ['AboutId' => 'DESC']);
//        echo "<pre>";print_r($resultset);die;
        $result_destination = $crud->rv_select_all("tb_tbb2c_destinations", ['*'], ['IsPublish' => 1, 'IsMarkForDel' => 0], ['Title' => 'ASC']);

        # 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->page = $page;
        $this->view->per_page_record = $this->per_page_record;
        $this->view->resultset = $resultset;
        $this->view->result_destination = $result_destination;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }

    public function awardsAction() {
        //Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $resultset = $crud->rv_select_all($this->tableAwards, ['*'], ['IsMarkForDel' => 0], ['AwardId' => '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->page = $page;
        $this->view->per_page_record = $this->per_page_record;
        $this->view->resultset = $resultset;
        $this->view->result_destination = $result_destination;
        $this->view->messages = $this->_helper->flashMessenger->getMessages();
    }

    /**
     * editpage() method is used to admin can edit cms static page
     * @param password string
     * @return ture 
     */
    public function editaboutindoasiaAction() {
//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editaboutindoasia();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/aboutindoasia/editaboutindoasia/id/" . $pId);

        $form->setName("edit_aboutindoasia");

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();

            if ($form->isValid($getData)) {

                //-------Start Code for Approve and Publish content---------//
                if (isset($getData['save']) == "Save") {
//                         echo "<pre>";print_r($getData);die;
                    $AboutId = $getData['AboutId'];
                    $orignalFIleName = $image = $_FILES["AboutImage"]["name"];

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

                    if ($fileName != "") {
                        $image_edit = $fileName;
                    }

                    $editPageData = [

                        'AboutTitle' => ($getData['AboutTitle']),
                        'AboutDescription' => ($getData['AboutDescription']),
                        'UpdateDate' => date('Y-m-d H:i:s'),
                        'status' => ($getData['status']),
                    ];

                    if ($fileName) {
                        $editPageData['AboutImage'] = $fileName;
                    }
//                  echo "<pre>";print_r($editPageData);die;
                    $crud->rv_update($this->table, $editPageData, ['AboutId =?' => $AboutId]);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                    $this->_redirect("/admin/aboutindoasia/index");
                }
            }
        }

        $result = $crud->getCmsdata($this->table, ['*'], ['AboutId' => $pId], ['AboutId' => 'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["AboutId"] = @$result->AboutId;
        $editdata["AboutTitle"] = @$result->AboutTitle;
        $editdata["AboutImage"] = @$result->AboutImage;
        $editdata["AboutDescription"] = @$result->AboutDescription;
        $editdata["status"] = @$result->status;
//        echo "<pre>";print_r($editdata);die;
        $form->populate($editdata);
        $this->view->AboutImage = @$result->AboutImage;
        $this->view->form = $form;
    }

    public function addaboutindoasiaAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editaboutindoasia();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/aboutindoasia/addaboutindoasia");
        $form->setName("edit_aboutindoasia");

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();
            if ($form->isValid($getData)) {

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

                    $orignalFIleName = $image = $_FILES["AboutImage"]["name"];



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

                    if ($fileName != "") {
                        $image_add = $fileName;
                    } else {
                        $image_add = "";
                    }
//                $BlogDate1 = explode('/', $getData['BlogDate']);
//                $BlogDate = $BlogDate1[2]."-".$BlogDate1[1]."-".$BlogDate[0];

                    $savePageData = [
                        'AboutTitle' => ($getData['AboutTitle']),
                        'AboutImage' => $image_add,
                        'AboutDescription' => ($getData['AboutDescription']),
                        'CreateDate' => date('Y-m-d H:i:s'),
                        'status' => ($getData['status']),
                        'isMarkForDel' => 0,
                    ];
//                echo "<pre>";print_r($savePageData);die;
                    $crud->rv_insert($this->table, $savePageData);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been added successfully.");
                    $this->_redirect("/admin/aboutindoasia/index");
                }
            }
        }

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

    public function addawardsAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editawards();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/aboutindoasia/addawards");
        $form->setName("edit_awards");

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();

            if ($form->isValid($getData)) {

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

                    $orignalFIleName = $image = $_FILES["AwardImage"]["name"];



                    if (!empty($orignalFIleName)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlAwards;
                        $fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                        $temp_file_name = $_FILES["AwardImage"]["tmp_name"]; // temprary file name
                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
                    }

                    if ($fileName != "") {
                        $image_add = $fileName;
                    } else {
                        $image_add = "";
                    }
//                $BlogDate1 = explode('/', $getData['BlogDate']);
//                $BlogDate = $BlogDate1[2]."-".$BlogDate1[1]."-".$BlogDate[0];

                    $savePageData = [
                        'AwardTitle' => ($getData['AwardTitle']),
                        'AwardImage' => $image_add,
                        'AwardDescription' => ($getData['AwardDescription']),
                        'CreateDate' => date('Y-m-d H:i:s'),
                        'status' => ($getData['status']),
                        'isMarkForDel' => 0,
                    ];
//                echo "<pre>";print_r($savePageData);die;
                    $crud->rv_insert($this->tableAwards, $savePageData);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been added successfully.");
                    $this->_redirect("/admin/aboutindoasia/awards");
                }
            }
        }

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

    public function editawardsAction() {
//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $form = new Admin_Form_Editawards();
        $pId = (int) $this->getRequest()->getParam("id");
        $form->setMethod("POST");
        $form->setAction("admin/aboutindoasia/editawards/id/" . $pId);

        $form->setName("edit_awards");

        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();

            if ($form->isValid($getData)) {

                //-------Start Code for Approve and Publish content---------//
                if (isset($getData['save']) == "Save") {
//                         echo "<pre>";print_r($getData);die;
                    $AwardId = $getData['AwardId'];
                    $orignalFIleName = $image = $_FILES["AwardImage"]["name"];

                    if (!empty($orignalFIleName)) {
                        $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlAwards;
                        $fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
                        $fileName = $this->current_time . '.' . $fileExt;
                        if (!file_exists($orignalFolderName)) {
                            mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                        }
                        $temp_file_name = $_FILES["AwardImage"]["tmp_name"]; // temprary file name
                        @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
                    }

                    if ($fileName != "") {
                        $image_edit = $fileName;
                    }

                    $editPageData = [

                        'AwardTitle' => ($getData['AwardTitle']),
                        'AwardDescription' => ($getData['AwardDescription']),
                        'UpdateDate' => date('Y-m-d H:i:s'),
                        'status' => ($getData['status']),
                    ];

                    if ($fileName) {
                        $editPageData['AwardImage'] = $fileName;
                    }
//                  echo "<pre>";print_r($editPageData);die;
                    $crud->rv_update($this->tableAwards, $editPageData, ['AwardId =?' => $AwardId]);
                    $this->view->successMessage = "Page content has been saved successfully.";
                    $this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
                    $this->_redirect("/admin/aboutindoasia/awards");
                }
            }
        }

        $result = $crud->getCmsdata($this->tableAwards, ['*'], ['AwardId' => $pId], ['AwardId' => 'DESC']);
//        echo "<pre>";print_r($result);die;
        $editdata["AwardId"] = @$result->AwardId;
        $editdata["AwardTitle"] = @$result->AwardTitle;
        $editdata["AwardImage"] = @$result->AwardImage;
        $editdata["AwardDescription"] = @$result->AwardDescription;
        $editdata["status"] = @$result->status;
//        echo "<pre>";print_r($editdata);die;
        $form->populate($editdata);
        $this->view->AwardImage = @$result->AwardImage;
        $this->view->form = $form;
    }

    public function deleteaboutindoasiaAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        //echo $tId;die;
        if ($tId) {
            $checkdata = $crud->rv_select_row($this->table, ['AboutId'], ['AboutId' => $tId], ['AboutId' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_update($this->table, ['isMarkForDel' => 1], ['AboutId =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/aboutindoasia/index");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }

    public function deleteawardsAction() {
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
        $tId = (int) $this->getRequest()->getParam("id");
        //echo $tId;die;
        if ($tId) {
            $checkdata = $crud->rv_select_row($this->tableAwards, ['AwardId'], ['AwardId' => $tId], ['AwardId' => 'asc']);
            if (count($checkdata) > 0) {
                $crud->rv_update($this->tableAwards, ['isMarkForDel' => 1], ['AwardId =?' => $tId]);
                $this->_helper->flashMessenger->addMessage("Delete successfully.");
                $this->_redirect("/admin/aboutindoasia/awards");
            } else {
                die('Oops some thing wrong!!.');
            }
        }
    }

    public function accreditationclientsAction() {

//Check admin logedin or not
        $this->checklogin();
        $crud = new Admin_Model_CRUD();
         $clientResult = $crud->getCmsdata($this->tableClients, ['*'], ['ClientId' => 1], ['ClientId' => 'DESC']);

        $this->view->clientResult = $clientResult;
        if ($this->getRequest()->isPost()) {
            $getData = $this->getRequest()->getPost();


            //-------Start Code for Approve and Publish content---------//
            if (isset($getData['save']) == "Save") {


                $orignalFIleName = $_FILES["AccreditationsImage"]["name"];
                $ClientImagesN = $_FILES["ClientImages"]["name"];



                if (!empty($orignalFIleName)) {
                    $orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlAccreditationsClient;
                    $fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
                    $fileName1 = $this->current_time . '.' . $fileExt;
                    if (!file_exists($orignalFolderName)) {
                        mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
                    }
                    $temp_file_name = $_FILES["AccreditationsImage"]["tmp_name"]; // temprary file name
                    @move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName1);
                }


                if ($ClientImagesN) {
                    foreach ($ClientImagesN as $key => $orignalFileName1) {

                        if (!empty($orignalFileName1)) {

                            $orignalFolderName1 = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlAccreditationsClient . "/clients"; // root folder for destination images


                            /* Get File Extension */
                            $fileExt = $this->_helper->General->getFileExtension($orignalFileName1);
                            $fileName2 = $this->current_time . '_' . $key . '.' . $fileExt;
                            //echo $fileName;
                            /* Create directory if not exists */
                            if (!file_exists($orignalFolderName1)) {
                                mkdir($orignalFolderName1, $this->DIR_WRITE_MODE, true);
                            }
                           
                            foreach ($_FILES["ClientImages"]["tmp_name"] as $key1 => $image) {
                                if ($key == $key1) {
                                    $temp_file_name = $image; // temprary file name
                                }
                            }
                            @move_uploaded_file($temp_file_name, $orignalFolderName1 . "/" . $fileName2);

                           
                        } else {
                            //                    echo 'else'; die;
                        }
                    }
                }
                
                $editPageData = [
                    'AccreditationsTitle' => ($getData['AccreditationsTitle']),
                    'CreateDate' => date('Y-m-d H:i:s'),
                    'status' => 1,
                    'isMarkForDel' => 0,
                ];
                                if ($fileName1 != "") {
                    $editPageData['AccreditationsImage'] = $fileName1;
                }
               
// echo "<pre>";print_r($editPageData);die;
                
//                 echo "<pre>";print_r($fileName);die;
                if ($fileName2) {
                        foreach ($ClientImagesN as $key => $image) {

                            $fileExt = $this->_helper->General->getFileExtension($image);
                            $fileName2 = $this->current_time . '_' . $key . '.' . $fileExt;
                            $editPageData['ClientImages'][] = $fileName2;
                        }
                        $editPageData['ClientImages'] = $newimagenames = @implode(",", $editPageData['ClientImages']);
                    }

                    $oldimagenames = implode(',', $getData['oldClientsName']);
                    $editPageData['ClientImages'] = "$oldimagenames";

                    if (trim($newimagenames))
                        $editPageData['ClientImages'] .= ",$newimagenames";
                  
                    $editPageData['ClientImages'] = trim($editPageData['ClientImages'], ',');



//                $BlogDate1 = explode('/', $getData['BlogDate']);
//                $BlogDate = $BlogDate1[2]."-".$BlogDate1[1]."-".$BlogDate[0];

                
//                echo "<pre>";print_r($editPageData);die;
                $crud->rv_update($this->tableClients, $editPageData, ['ClientId =?' => 1]);
                $this->view->successMessage = "Content has been updated successfully.";
                $this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
                $this->_redirect("/admin/aboutindoasia/accreditationclients");
            }
        }


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

    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/index');
            }
        } else {
            $this->_redirect('admin/index/index');
        }
    }

}