| Server IP : 103.234.187.230 / Your IP : 216.73.216.216 Web Server : Apache System : Linux lserver42043-ind.megavelocity.net 3.10.0-1160.108.1.el7.x86_64 #1 SMP Thu Jan 25 16:17:31 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/travelbrace.com/application/admin/controllers -old/ |
Upload File : |
<?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_DestinationController extends Zend_Controller_Action {
public $dbAdapter;
public $perPageLimit;
public $siteurl;
public $DIR_WRITE_MODE;
protected $tablenameRegion;
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 = 25;
$this->dbAdapter = Zend_Db_Table::getDefaultAdapter();
$auth = Zend_Auth::getInstance();
$authStorage = $auth->getStorage()->read();
$this->username = $authStorage->username;
$this->admin_type = $authStorage->role;
$options = $aConfig['bootstrap'];
$this->gtxagencysysid = $options['gtxagencysysid'];
$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'];
$this->large_image_width = $options['large_image_width'];
$this->large_image_height = $options['large_image_height'];
$this->medium_image_width = $options['medium_image_width'];
$this->medium_image_height = $options['medium_image_height'];
$this->small_image_width = $options['small_image_width'];
$this->small_image_height = $options['small_image_height'];
$this->current_time = time();
$this->imageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/destinations/';
$this->regionImageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/region/';
$this->countryImageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/country/';
$this->stateImageUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/state/';
$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();
$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'],
'Countries'=>$getData['Country'],
'Region'=>$getData['Region'],
'rows'=>$getData['rows'],
'page'=>$getData['page'],
);
$resulsetold = $crud->getCount('tb_tbb2c_destinations',['tbl.IsMarkForDel'=>0],'DesSysId');
$crud->searchArr = $searchArr;
$resultset = $crud->getDestinationsIndex(['tbl.AgencySysId'=>"$this->gtxagencysysid"] , ['Title'=> 'ASC']);
// echo "<pre>";print_r($resulsetold);die;
$result1 = array();
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$result1[] = [
'DesSysId'=>$resultval['DesSysId'],
'Title' => $resultval['Title'],
'region_name' => $resultval['region_name'],
'Countries' => $resultval['Countries'],
'Activities' => $resultval['Activities'],
'Tours' => $resultval['Tours'],
'Hotels' => $resultval['Hotels'],
'IsFeatured' => $resultval['IsFeatured'],
'DisplayOnFooter' => $resultval['DisplayOnFooter'],
'DisplayPromotionHome' => $resultval['DisplayPromotionHome'],
'DisplayOnHeader' => isset($resultval['DisplayOnHeader']) ? $resultval['DisplayOnHeader']:"",
'displayOnActivity' => $resultval['displayOnActivity'],
'Image' => $resultval['Image'],
'Bannerimg' => $resultval['Bannerimg'],
];
}
}
$result = Zend_Json::encode($result1);
$newResult = Zend_Json::decode($result,false);
$finalResult["total"]=$resulsetold[0]['DesSysId'];
$finalResult["rows"]=$newResult;
echo json_encode($finalResult);
exit;
}
}
public function editdestiAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editdestinationpage();
$pId = $this->getRequest()->getParam("id");
$page = ($this->getRequest()->getParam("page")) ? $this->getRequest()->getParam("page") : 1;
$form->setMethod("POST");
$form->setAction("admin/destination/editdesti/id/" . $pId . "/page/$page");
$form->setName("edit_destination_page");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
//echo "<pre>";print_r($getData);die;
if ($form->isValid($getData)) {
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
// echo "<pre>";print_r($getData);die;
$target_dir = "public/upload/destinations/";
$target_file = $target_dir . basename($_FILES["image"]["name"]);
$target_file1 = $target_dir . basename($_FILES["banner_image"]["name"]);
$uploadOk = 1;
$orignalFileName = $image = $_FILES['image']['name'];
$bannerimage = $_FILES['banner_image']['name'];
/* * ****************** Starts : destinations Image upload here **************** */
if (!empty($orignalFileName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $pId . "/images"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($orignalFileName);
$fileName = $pId . '_' . $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->large_image_width,$this->large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->medium_image_width,$this->medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->small_image_width,$this->small_image_height);
}
/* * ****************** End : destinations Image upload here **************** */
/* * ****************** Starts : destinations Image upload here **************** */
if (!empty($bannerimage)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $pId . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($bannerimage);
$fileNameBanner = $pId . '_' . $this->current_time . '.' . $fileExt;
/* Create directory if not exists */
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileNameBanner);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileNameBanner,$this->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileNameBanner,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileNameBanner,$this->banner_small_image_width,$this->banner_small_image_height);
}
/* * ****************** End : destinations Image upload here **************** */
$editDestinationData = [
'region_id' => ((int)$getData['region_id']),
'Title' => ($getData['title']),
'Activities' => ($getData['activities']),
'Tours' => ($getData['tours']),
'Hotels' => ($getData['hotel']),
'Countries' => ($getData['countries']),
'IsActive' => ($getData['status']),
'IsFeatured' => ($getData['feature']),
'Keyword' => ($getData['keyword']),
'Description' => ($getData['description']),
'Metatag' => ($getData['metatag']),
'regionDescription' => ($getData['regionDescription']),
'seoHcontent' => ($getData['seoHcontent']),
'seoFcontent' => ($getData['seoFcontent']),
];
if( $fileName != '')
$editDestinationData['Image'] = $fileName;
if( $bannerimage != '')
$editDestinationData['Bannerimg'] = $fileNameBanner;
// echo "<pre>";print_r($editDestinationData);die;
$crud->rv_update('tb_tbb2c_destinations', $editDestinationData, ['DesSysId =?' => $pId]);
$this->view->successMessage = "Destination has been Updated successfully.";
$this->_helper->flashMessenger->addMessage("Destination has been updated successfully.");
$this->_redirect("/admin/destination/index/page/$page");
}
}
}
// $result = $crud->getCmsdata('tb_tbb2c_destinations', ['*'], ['DesSysId' => $pId], ['DesSysId' => 'DESC']);
$result = $crud->getDestinations( ['tbl.IsMarkForDel'=>0 ,'DesSysId' => $pId ], ['tbl.DesSysId'=>'DESC'] );
// echo "<pre>";print_r($result);die;
$result = $result[0];
$this->view->pId = $pId;
$editdata["id"] = $result['DesSysId'];
$editdata["title"] = $result['Title'];
$editdata["activities"] = $result['Activities'];
$editdata["tours"] = $result['Tours'];
$editdata["hotel"] = $result['Hotels'];
$editdata["image"] = $result['Image'];
$editdata["banner_image"] = $result['Bannerimg'];
$editdata["countries"] = $result['Countries'];
$editdata["feature"] = $result['IsFeatured'];
$editdata["status"] = $result['IsActive'];
$editdata["region_id"] = $result['region_id'];
$editdata["keyword"] = $result['Keyword'];
$editdata["description"] = $result['description'];
$editdata["metatag"] = $result['Metatag'];
$editdata["regionDescription"] = $result['regionDescription'];
$editdata["seoHcontent"] = $result['seoHcontent'];
$editdata["seoFcontent"] = $result['seoFcontent'];
//echo "<pre>"; print_r($result); die();
$form->populate($editdata);
$this->view->image = $result['Image'];
$this->view->banner_image = $result['Bannerimg'];
$this->view->form = $form;
$this->view->page = $page;
}
public function adddestinationAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Adddestination();
$tId = (int) $this->getRequest()->getParam("id");
$form->setAction("admin/destination/adddestination");
$form->setMethod("POST");
$form->setName("add_destination");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if (isset($getData['save']) == "Save") {
// echo "<pre>";print_r($getData);die;
// $image = $_FILES['image']['name'];
$target_dir = "public/upload/destinations/";
$target_file = $target_dir . basename($_FILES["image"]["name"]);
$target_file1 = $target_dir . basename($_FILES["banner_image"]["name"]);
$uploadOk = 1;
if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
"The file " . basename($_FILES["image"]["name"]) . " has been uploaded.";
}
if (move_uploaded_file($_FILES["banner_image"]["tmp_name"], $target_file1)) {
"The file " . basename($_FILES["banner_image"]["name"]) . " has been uploaded.";
}
$image = $_FILES["image"]["name"];
$bannerimage = $_FILES['banner_image']['name'];
$savePageData = [
'region_id' => ($getData['region_id']),
'Title' => ($getData['title']),
'Activities' => 0,
'Tours' => 0,
'Hotels' => 0,
'Image' => '',
'Bannerimg' => '',
'Countries' => '',
'IsPublish' => 1,
'IsActive' => ($getData['status']),
'IsFeatured' => ($getData['feature']),
'IsMarkForDel' => 0,
];
// echo "<pre>";print_r($savePageData);die;
$crud->rv_insert('tb_tbb2c_destinations', $savePageData);
$this->view->successMessage = "Destination has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Destination has been added successfully.");
$this->_redirect("/admin/destination/index");
}
}
$this->view->form = $form;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function deletedestiAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
//echo $tId;die;
if ($tId) {
$checkdata = $crud->rv_select_row('tb_tbb2c_destinations', ['DesSysId'], ['DesSysId' => $tId], ['DesSysId' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_delete('tb_tbb2c_destinations', ['DesSysId =?' => $tId]);
$this->_helper->flashMessenger->addMessage("Deleted successfully.");
$this->_redirect("/admin/destination/index");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function activedAction(){
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'DisplayPromotionHome' => $val
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// $resultset = $crud->rv_select_all("tb_tbb2c_destinations", ['*'] ,['IsFeatured'=>1,'IsPublish'=>1,'IsMarkForDel'=>0], ['Title'=>'ASC'] );
// if(count($resultset)>6){
// $result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
// echo Zend_Json::encode($result_message);
// $updatedata = [
// 'IsFeatured' => 0
// ];
// $result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// exit;
// }
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function activeAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'IsFeatured' => $val
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// $resultset = $crud->rv_select_all("tb_tbb2c_destinations", ['*'] ,['IsFeatured'=>1,'IsPublish'=>1,'IsMarkForDel'=>0], ['Title'=>'ASC'] );
// if(count($resultset)>6){
// $result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
// echo Zend_Json::encode($result_message);
// $updatedata = [
// 'IsFeatured' => 0
// ];
// $result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// exit;
// }
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function activityActiveAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'displayOnActivity' => $val
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// $resultset = $crud->rv_select_all("tb_tbb2c_destinations", ['*'] ,['IsFeatured'=>1,'IsPublish'=>1,'IsMarkForDel'=>0], ['Title'=>'ASC'] );
// if(count($resultset)>6){
// $result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
// echo Zend_Json::encode($result_message);
// $updatedata = [
// 'IsFeatured' => 0
// ];
// $result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
// exit;
// }
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function displayAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'DisplayOnFooter' => $val
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
$resultset = $crud->rv_select_all("tb_tbb2c_destinations", ['*'] ,['DisplayOnFooter'=>1,'IsPublish'=>1,'IsMarkForDel'=>0], ['Title'=>'ASC'] );
if(count($resultset)>12){
$result_message = ['status' => false, 'message' => 'Limit Exceed!!'];
echo Zend_Json::encode($result_message);
$updatedata = [
'DisplayOnFooter' => 0
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
exit;
}
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
}
else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function displayHeaderAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'DisplayOnHeader' => $val
];
$result = $crud->rv_update('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $tId]);
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
}
else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
/**
* regionAction() method is used to list all regions
* @param Null
* @return Array
*/
public function regionAction() {
//Check admin logedin or not
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
$getData = array();
$results = array();
if($this->getRequest()->isPost())
{
$getData = $this->getRequest()->getPost();
$searchArr = array(
// 'Title'=>$getData['Title'],
'rows'=>$getData['rows'],
'page'=>$getData['page'],
);
$resulsetold = $crud->getCount("tbl_regions",['IsMarkForDel'=>0],'sid');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_all("tbl_regions",['sid','title','IsActive','region_id','displayOnHeader'],['IsMarkForDel'=>0],['Title'=>'ASC'] );
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$checked = ($resultval['displayOnHeader'] == 1) ? 'checked' : '';
$results[] = [
'sid' => $resultval['sid'],
'region_id' => $resultval['region_id'],
'IsActive' => $resultval['IsActive']==1?'Active':'Deactive',
'Title' => $resultval['title'],
'displayOnHeader' => '<input type="checkbox" id="displayOnHeader_'.$resultval['sid'].'" value="1" name="" class="" '.$checked.' onclick="displayRegionOnHeader('.$resultval['sid'].')">',
];
}
}
$result = Zend_Json::encode($results);
$newResult = Zend_Json::decode($result,false);
$finalResult["total"]=$resulsetold[0]['sid'];
$finalResult["rows"]=$newResult;
echo json_encode($finalResult);
exit;
}
}
/**
* addregionAction() method is used to add regions
* @param array
* @return boolean
*/
public function addregionAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Addregion();
$tId = (int) $this->getRequest()->getParam("id");
$form->setAction("admin/destination/addregion");
$form->setMethod("POST");
$form->setName("add_region");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if (isset($getData['save']) == "Save") {
$savePageData = [ 'title' => ($getData['title']), 'IsActive' => ($getData['status']) ];
$crud->rv_insert( "tbl_regions" , $savePageData);
$this->view->successMessage = "Region has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Region has been saved successfully.");
$this->_redirect("/admin/destination/region");
}
}
$this->view->form = $form;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
/**
* editregionAction() method is used to edit regions
* @param array
* @return boolean
*/
public function editregionAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editregion();
$pId = (int) $this->getRequest()->getParam("id");
$form->setMethod("POST");
$form->setAction("admin/destination/editregion/id/" . $pId);
$form->setName("edit_region");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
//echo "<pre>";print_r($getData);die;
// if ($form->isValid($getData)) {
$fileName = $fileNameBanner = '';
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
$orignalFileName = $image = $_FILES['Image']['name'];
$bannerImage = $_FILES['banner_image']['name'];
if (!empty($orignalFileName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->regionImageUrl.$pId . "/images"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($orignalFileName);
$fileName = $pId . '_' . $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["Image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->large_image_width,$this->large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->medium_image_width,$this->medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->small_image_width,$this->small_image_height);
}
if (!empty($bannerImage)) {
$bannerFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->regionImageUrl.$pId . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExtBanner = $this->_helper->General->getFileExtension($bannerImage);
$fileNameBanner = $pId . '_' . $this->current_time . '.' . $fileExtBanner;
if (!file_exists($bannerFolderName)) {
mkdir($bannerFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name1 = $_FILES["banner_image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name1, $bannerFolderName . "/" . $fileNameBanner);
$originalLargeFolder = $bannerFolderName.'/large';
$originalMediumFolder = $bannerFolderName.'/medium';
$originalSmallFolder = $bannerFolderName.'/small';
Catabatic_Helper::resizeImages($bannerFolderName,$originalLargeFolder,$fileNameBanner,$this->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalMediumFolder,$fileNameBanner,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalSmallFolder,$fileNameBanner,$this->banner_small_image_width,$this->banner_small_image_height);
}
$editDestinationData = [
'Title' => ($getData['title']),
'Metatag' => ($getData['Metatag']),
'Keyword' => ($getData['Keyword']),
'Description' => ($getData['Description']),
'region_header_content' => ($getData['region_header_content']),
'region_footer_content' => ($getData['region_footer_content']),
'UpdateDate' => date("Y-m-d H:i:s"),
'IsActive' => ($getData['status']),
];
if($fileName!=""){
$editDestinationData['image'] = $fileName;
}
if($fileNameBanner!=""){
$editDestinationData['banner_image'] = $fileNameBanner;
}
//echo "<pre>";print_r($editDestinationData);die;
$crud->rv_update( "tbl_regions" , $editDestinationData, ['sid =?' => $pId]);
$this->view->successMessage = "Region has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Region has been updated successfully.");
$this->_redirect("/admin/destination/region");
}
}
// }
$result = $crud->getCmsdata( "tbl_regions" , ['*'], ['sid' => $pId], ['sid' => 'DESC']);
// echo "<pre>";print_r($result);die;
$this->view->pId = $pId;
$editdata["sid"] = $result->sid;
$editdata["title"] = $result->title;
$form->populate($editdata);
$this->view->resultRegion = $result;
$this->view->form = $form;
}
public function displayRegionOnHeaderAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'displayOnHeader' => $val
];
$result = $crud->rv_update('tbl_regions', $updatedata, ['sid =?' => $tId]);
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
}
else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
/**
* deleteregionAction() method is used to delete regions
* @param array
* @return boolean
*/
public function deleteregionAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
//echo $tId;die;
if ($tId) {
$checkdata = $crud->rv_select_row( "tbl_regions" , ['sid'], ['sid' => $tId], ['sid' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_update( "tbl_regions" , ['IsMarkForDel' => 1] , ['sid =?' => $tId] );
$this->_helper->flashMessenger->addMessage("Deleted successfully.");
$this->_redirect("/admin/destination/region");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function countryAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
//$resultset = $crud->rv_select_all( 'tbl_countries' , ['title','contSysId','countryId','region_id'] , ['IsMarkForDel'=>0], ['title'=>'ASC'] );
//$regions = $crud->rv_select_all('tbl_regions',['title','sid','countryIds','region_id'],['IsActive'=>1,'IsMarkForDel'=>0],['title'=>'ASC']);
$getData = array();
if($this->getRequest()->isPost())
{
$getData = $this->getRequest()->getPost();
$searchContArr = array(
'title'=>$getData['title'],
'rows'=>$getData['rows'],
'page'=>$getData['page'],
);
$resulsetold = $crud->getCount('tbl_countries',['tbl.IsMarkForDel'=>0],'contSysId');
$crud->searchContArr = $searchContArr;
$resultset = $crud->rv_select_all_countries();
// echo "<pre>"; print_r($resultset);die;
$result1 = array();
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$checked = ($resultval['displayOnVisa'] == 1) ? 'checked' : '';
$result1[] = [
'title' => $resultval['title'],
'displayOnVisa'=>'<input type="checkbox" name="" id="DisplayVisaHomeActive_'.$resultval['countryId'].'" value="1" onclick="displayOnVisaHome('.$resultval['countryId'].')" '.$checked.'>',
'status' => ($resultval['IsActive'] == 1) ? 'Active' : 'Deactive',
'action' => '<a href="admin/destination/editcountry/id/'.$resultval['countryId'].'/cont/'.$resultval['title'].'" title="Edit"><i class="icon-pencil"></i></a>',
];
}
}
$result = Zend_Json::encode($result1);
$newResult = Zend_Json::decode($result,false);
$finalResult["total"]=$resulsetold[0]['contSysId'];
$finalResult["rows"]=$newResult;
echo json_encode($finalResult);
exit;
}
}
public function editcountryAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
//$form = new Admin_Form_Editcountry();
$pId = (int) $this->getRequest()->getParam("id");
$cont = $this->getRequest()->getParam("cont");
$resultCountry = $crud->getCmsdata( 'tbl_countries' , ['*'], ['countryId' => $pId], ['contSysId' => 'DESC']);
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
// echo "<pre>";print_r($getData);die;
$fileName = $fileNameBanner = '';
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
$orignalFileName = $image = $_FILES['Image']['name'];
$bannerImage = $_FILES['bannerImage']['name'];
if (!empty($orignalFileName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->countryImageUrl.$pId . "/images"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($orignalFileName);
$fileName = $pId . '_' . $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["Image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->large_image_width,$this->large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->medium_image_width,$this->medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->small_image_width,$this->small_image_height);
}
if (!empty($bannerImage)) {
$bannerFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->countryImageUrl.$pId . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExtBanner = $this->_helper->General->getFileExtension($bannerImage);
$fileNameBanner = $pId . '_' . $this->current_time . '.' . $fileExtBanner;
if (!file_exists($bannerFolderName)) {
mkdir($bannerFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name1 = $_FILES["bannerImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name1, $bannerFolderName . "/" . $fileNameBanner);
$originalLargeFolder = $bannerFolderName.'/large';
$originalMediumFolder = $bannerFolderName.'/medium';
$originalSmallFolder = $bannerFolderName.'/small';
Catabatic_Helper::resizeImages($bannerFolderName,$originalLargeFolder,$fileNameBanner,$this->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalMediumFolder,$fileNameBanner,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalSmallFolder,$fileNameBanner,$this->banner_small_image_width,$this->banner_small_image_height);
}
// if($resultCountry){
$editCountryData = [
'metaTitle'=>$getData['metaTitle'],
'metaKeyword'=>$getData['metaKeyword'],
'metaDescription'=>$getData['metaDescription'],
'meta_header'=>$getData['meta_header'],
'meta_footer'=>$getData['meta_footer'],
];
if($fileName != '')
$editCountryData['Image'] = $fileName;
if( $fileNameBanner!= '')
$editCountryData['bannerImage'] = $fileNameBanner;
// echo "<pre>";print_r($editCountryData);die;
$crud->rv_update( 'tbl_countries' , $editCountryData, ['countryId =?' => $pId]);
$this->view->successMessage = "Content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
$this->_redirect("/admin/destination/country");
}
}
$this->view->pId = $pId;
$this->view->resultCountry = $resultCountry;
}
public function stateAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
//$resultset = $crud->rv_select_all( 'tbl_states' , ['*'] , ['IsActive'=>1], ['title'=>'ASC'] );
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchStateArr = array(
'title' => $getData['title'],
'rows' => $getData['rows'],
'page' => $getData['page'],
);
// echo "<pre>"; print_r($searchStateArr);die;
$resulsetold = $crud->getCount('tbl_states', ['tbl.IsMarkForDel' => 0], 'stateId');
$crud->searchStateArr = $searchStateArr;
$resultset = $crud->rv_select_all_states();
// echo "<pre>"; print_r($resultset);die;
$result1 = array();
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$checked = ($resultval['displayOnHeader'] == 1) ? 'checked' : '';
$result1[] = [
'title' => $resultval['title'],
'displayOnHeader' => '<input type="checkbox" ' . $checked . ' onClick="DisplayOnHeader(' . $resultval['stateId'] . ')" id="DisplayHeaderActive_' . $resultval['stateId'] . '" name="DisplayHeaderActive" value="1">',
'action' => '<a href="admin/destination/editstate/id/' . $resultval['stateId'] . '/state/' . $resultval['title'] . '" title="Edit"><i class="icon-pencil"></i></a>',
];
}
}
$result = Zend_Json::encode($result1);
$newResult = Zend_Json::decode($result, false);
$finalResult["total"] = $resulsetold[0]['stateId'];
$finalResult["rows"] = $newResult;
echo json_encode($finalResult);
exit;
}
// echo "<pre>";print_r($resultset);die;
}
public function editstateAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
//$form = new Admin_Form_Editcountry();
$StateSysId = (int) $this->getRequest()->getParam("id");
$cont = $this->getRequest()->getParam("state");
$fileName = $fileNameBanner = '';
$resultState = $crud->getCmsdata( 'tbl_states' , ['*'], ['stateId' => $StateSysId], ['StateSysId' => 'DESC']);
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") {
$orignalFileName = $image = $_FILES['image']['name'];
$bannerImage = $_FILES['bannerImage']['name'];
if (!empty($orignalFileName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->stateImageUrl.$StateSysId . "/images"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($orignalFileName);
$fileName = $StateSysId . '_' . $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
Catabatic_Helper::resizeImages($orignalFolderName,$originalLargeFolder,$fileName,$this->large_image_width,$this->large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->medium_image_width,$this->medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->small_image_width,$this->small_image_height);
}
if (!empty($bannerImage)) {
$bannerFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->stateImageUrl.$StateSysId . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExtBanner = $this->_helper->General->getFileExtension($bannerImage);
$fileNameBanner = $StateSysId . '_' . $this->current_time . '.' . $fileExtBanner;
if (!file_exists($bannerFolderName)) {
mkdir($bannerFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name1 = $_FILES["bannerImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name1, $bannerFolderName . "/" . $fileNameBanner);
$originalLargeFolder = $bannerFolderName.'/large';
$originalMediumFolder = $bannerFolderName.'/medium';
$originalSmallFolder = $bannerFolderName.'/small';
Catabatic_Helper::resizeImages($bannerFolderName,$originalLargeFolder,$fileNameBanner,$this->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalMediumFolder,$fileNameBanner,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($bannerFolderName,$originalSmallFolder,$fileNameBanner,$this->banner_small_image_width,$this->banner_small_image_height);
}
// if($resultCountry){
$editStateData = [
'title' => $getData['Title'],
'description' => $getData['description'],
'metaTitle'=>$getData['metaTitle'],
'metaKeyword'=>$getData['metaKeyword'],
'metaDescription'=>$getData['metaDescription'],
'meta_header'=>$getData['meta_header'],
'meta_footer'=>$getData['meta_footer'],
'IsActive'=>$getData['status'],
];
if ($fileNameBanner != '') {
$editStateData['bannerImage'] = $fileNameBanner;
}
if ($fileName != '') {
$editStateData['image'] = $fileName;
}
// echo "<pre>";print_r($editCountryData);die;
$crud->rv_update( 'tbl_states' , $editStateData, ['stateId =?' => $StateSysId]);
$this->view->successMessage = "Content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
$this->_redirect("/admin/destination/state");
}
}
$this->view->StateSysId = $StateSysId;
$this->view->resultState = $resultState;
}
public function displayHeaderStateAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) trim($this->getRequest()->getParam("val"));
if ($tId) {
try {
$updatedata = [
'displayOnHeader' => $val
];
$result = $crud->rv_update('tbl_states', $updatedata, ['stateId =?' => $tId]);
//echo "<pre>";print_r($result);die('here');
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
} else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
public function displayCountryVisaAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'displayOnVisa' => $val
];
$result = $crud->rv_update('tbl_countries', $updatedata, ['countryId =?' => $tId]);
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops something wrong!!'];
echo Zend_Json::encode($result_message);
exit;
}
else {
$result_message = ['status' => true, 'message' => 'Active successfully'];
echo Zend_Json::encode($result_message);
exit;
}
} catch (Exception $ex) {
$ex->getMessage();
}
}
}
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');
}
}
public function getMultiDestinationdataAction() {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$crud = new Admin_Model_CRUD();
// print_r($this->getRequest()->getParam("query"));
// exit;
try {
$arrResponse = array();
if ($this->getRequest()->getParam("term") or $this->getRequest()->getParam("query")) {
$term = $this->getRequest()->getParam("term") ? $this->getRequest()->getParam("term") : $this->getRequest()->getParam("query");
$countryId = $this->getRequest()->getParam("countryId") ? $this->getRequest()->getParam("countryId") : '';
$condCity = "tbl.Title like '" . $term . "%'";
if (isset($countryId) && !empty($countryId)) {
$condCity .= " AND tbl.ContSysId = " . $countryId . "";
}
$arrResponse = $crud->getDestinationAutoSuggest($condCity);
if(empty($arrResponse)){
$condCity = "tbl.title like '" . $term . "%'";
//echo $condCity;die;
$arrResponse = $crud->getCountryAutoSuggest($condCity);
}
// print_r($arrResponse);die;
}
echo json_encode($arrResponse);
exit;
} catch (Exception $e) {
$response = array('success' => false, 'msg' => $e->getMessage());
echo json_encode($response);
exit;
}
}
}