| 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/tripsgateway/application/admin/controllers/ |
Upload File : |
<?php
/* * *************************************************************
* Catabatic Technology Pvt. Ltd.
* File Name : ContactusController.php
* File Desc. : Contactus controller managed all contact queries
* Created By : Ranvir Singh <twitter @ranvir2012>
* Created Date : 23 May 2017
* Updated Date : 23 May 2017
* ************************************************************* */
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;
$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->imageCountryUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/country/';
$this->imageStateUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/state/';
$this->DIR_WRITE_MODE = 0777;
$this->img_w_thumb = 64;
$this->img_h_thumb = 64;
$this->img_w_medium = 800;
$this->img_h_medium = 600;
$this->img_w_large = 1600;
$this->img_h_large = 500;
$this->banner_w_thumb = 256;
$this->banner_h_thumb = 64;
$this->banner_w_large = 1600;
$this->banner_h_large = 500;
$this->img_w_regionsmall = 180;
$this->img_h_regionsmall = 120;
$this->country_banner_w_large = 1600;
$this->country_banner_h_large = 500;
$this->img_w_destination_main = 800;
$this->img_h_destination_main = 600;
$this->tablenameRegion = "tbl_regions";
$this->tablenameContinent = "tbl_all_continent";
}
/**
* 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();
// $searchArr = array();
// $getData = array();
// if($this->getRequest()->isPost())
// {
// $getData = $this->getRequest()->getPost();
//
// if(!empty($getData))
// {
// if(@$getData['searchtxt']!="")
// {
// $Title = @$getData['searchtxt'];
// } else {
// $Title = "";
// }
//
// $searchArr = array(
// 'Title'=>$Title,
// );
//
// }
// }
//
// $crud->searchArr = $searchArr;
// $this->view->searchArr = $searchArr;
//
// $resultset = $crud->getDestinations( ['tbl.IsMarkForDel'=>0 ] , ['Title'=> 'ASC'] ); // join implemented in this query
//// echo "<pre>"; print_r($resultset);die;
// # Start : Pagination
// $page=$this->_getParam('page',1);
// $resultset1 = Zend_Paginator::factory($resultset);
// $resultset1->setCurrentPageNumber($this->getRequest()->getParam('page')); // page number
// $perPage = $resultset1->setItemCountPerPage($this->per_page_record); // number of items to show per page
// $this->view->paginator = $resultset1;
// $this->view->totalrec = $resultset1->getTotalItemCount();
// $this->view->per_page_record = $this->per_page_record;
// $this->view->page = $page;
// $this->view->messages = $this->_helper->flashMessenger->getMessages();
// }
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.IsMarkForDel' => 0], ['Title' => 'ASC']);
// print_r($resultset);
$result1 = array();
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$result1[] = [
'DesSysId' => $resultval['DesSysId'],
'Title' => $resultval['Title'],
'region_name' => ($resultval['region_name'] != '') ? $resultval['region_name'] : '--',
'Countries' => $resultval['Countries'],
// 'Activities' => $resultval['Activities'],
// 'Tours' => $resultval['Tours'],
// 'Hotels' => $resultval['Hotels'],
'IsFeatured' => $resultval['IsFeatured'],
'DisplayOnFooter' => $resultval['DisplayOnFooter'],
'DisplayOnHeader' => $resultval['DisplayOnHeader'],
// 'DisplayOnDestination' => isset($resultval['region_name'])&&!empty($resultval['region_name'])?$resultval['DisplayOnDestination']:"",
'IsActive' => $resultval['IsActive'] == 1 ? 'Active' : 'Deactive',
'Image' => $resultval['Image'],
'destinationImage' => $resultval['destinationImage'],
'Bannerimg' => $resultval['Bannerimg'],
'startingPrice' => isset($resultval['Activities']) ? $resultval['Activities'] : '',
];
}
}
$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 = (int) $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");
$result = $crud->getDestinations(['DesSysId' => $pId], ['tbl.DesSysId' => 'DESC']);
//echo "<pre>";print_r($result);die;
$result = $result[0];
$sightseeingData = $crud->rv_select_all('tb_ic_sightseeing', ['Title', 'WriteUp', 'SSSysId', 'DetailImg'], [ 'ContSysId' => $result['CountryIds'],'IsActive' => '1' , 'IsMarkForDel' => '0'], ['SSSysId' => 'DESC']);
$this->view->sightseeingData = $sightseeingData;
$SelectedDestinationsName1 = $SelectedDestinationsName2 = $SelectedDestinationsName =array();
if ($result['similarDestinations']) {
$SelectedDestinationsName1 = $crud->rv_select_all_destinationByIds('tb_tbb2c_destinations', ['Title', 'DesSysId'], ['IsActive' => 1, 'IsMarkForDel' => 0], 'DesSysId', $result['similarDestinations']);
$SelectedDestinationsName2 = $crud->rv_select_all_destinationByIds('tbl_countries',['title as Title','countryId as DesSysId','title as Countries','startingPrice as Activities','destinationImage','image'],['IsActive'=>1,'IsMarkForDel'=>0],'countryId',$result['similarDestinations']);
$SelectedDestinationsName = array_merge($SelectedDestinationsName1,$SelectedDestinationsName2);
}
//echo "<pre>";print_r($SelectedDestinationsName);die;
//$regions = $crud->rv_select_all('tbl_regions',['title','sid','countryIds','region_id'],['IsActive'=>1,'IsMarkForDel'=>0],['title'=>'ASC']);
$blog = $crud->rv_select_all('tbl_blog', ['BlogId', 'BlogTitle', 'BlogIdentifier', 'BlogImage', 'BlogDescription'], ['status' => 1, 'IsMarkForDel' => 0], ['BlogId' => 'DESC']);
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;
// 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.";
// }
$orignalFileName = $image = $_FILES['image']['name'];
$destinationImageFileName = $_FILES['destinationImage']['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;
$originalThumbFolder = $orignalFolderName . "/thumb";
$originalMediumFolder = $orignalFolderName . "/medium";
$originalLargeFolder = $orignalFolderName . "/large";
$originalHomeFolder = $orignalFolderName . "/home";
/* Create directory if not exists */
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($originalThumbFolder)) {
mkdir($originalThumbFolder, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($originalMediumFolder)) {
mkdir($originalMediumFolder, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($originalLargeFolder)) {
mkdir($originalLargeFolder, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($originalHomeFolder)) {
mkdir($originalHomeFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["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);
@copy($originalLargeFolder . '/' . $fileName, $originalThumbFolder . "/" . $fileName); // copy uploaded file into this location directory
$objImageResize1 = new Catabatic_Imageresize($originalThumbFolder . '/' . $fileName);
$objImageResize1->resizeImage($this->img_w_thumb, $this->img_h_thumb, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize1->saveImage($originalThumbFolder . '/' . $fileName);
@copy($originalLargeFolder . '/' . $fileName, $originalMediumFolder . "/" . $fileName); // copy uploaded file into this location directory
$objImageResize2 = new Catabatic_Imageresize($originalMediumFolder . '/' . $fileName);
$objImageResize2->resizeImage($this->img_w_medium, $this->img_h_medium, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize2->saveImage($originalMediumFolder . '/' . $fileName);
@copy($orignalFolderName . '/' . $fileName, $originalHomeFolder . "/" . $fileName); // copy uploaded file into this location directory
$objImageResize2 = new Catabatic_Imageresize($originalHomeFolder . '/' . $fileName);
$objImageResize2->resizeImage(278, 392, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize2->saveImage($originalHomeFolder . '/' . $fileName);
}
/* * ****************** End : destinations Image upload here **************** */
if (!empty($destinationImageFileName)) {
$destinationImageFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl . $pId . "/desimages"; // root folder for destination images
/* Get File Extension */
$destinationImagefileExt = $this->_helper->General->getFileExtension($destinationImageFileName);
$destinationImagefileName = $pId . '_' . $this->current_time . '.' . $destinationImagefileExt;
$destinationImageoriginalMainFolder = $destinationImageFolderName . "/main";
/* Create directory if not exists */
if (!file_exists($destinationImageFolderName)) {
mkdir($destinationImageFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($destinationImageoriginalMainFolder)) {
mkdir($destinationImageoriginalMainFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name_dest = $_FILES["destinationImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name_dest, $destinationImageFolderName . "/" . $destinationImagefileName);
@copy($destinationImageFolderName . '/' . $destinationImagefileName, $destinationImageoriginalMainFolder . "/" . $destinationImagefileName); // copy uploaded file into this location directory
$objImageResize1 = new Catabatic_Imageresize($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
$objImageResize1->resizeImage($this->img_w_destination_main, $this->img_h_destination_main, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize1->saveImage($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
}
/* * ****************** 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;
$originalThumbFolder = $orignalFolderName . "/thumb";
$originalLargeFolder = $orignalFolderName . "/large";
/* Create directory if not exists */
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($originalThumbFolder)) {
mkdir($originalThumbFolder, $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 . "/" . $fileNameBanner);
@copy($orignalFolderName . '/' . $fileNameBanner, $originalLargeFolder . "/" . $fileNameBanner); // copy uploaded file into this location directory
$objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileNameBanner);
$objImageResize4->resizeImage($this->banner_w_large, $this->banner_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize4->saveImage($originalLargeFolder . '/' . $fileNameBanner);
@copy($originalLargeFolder . '/' . $fileNameBanner, $originalThumbFolder . "/" . $fileNameBanner); // copy uploaded file into this location directory
$objImageResize1 = new Catabatic_Imageresize($originalThumbFolder . '/' . $fileNameBanner);
$objImageResize1->resizeImage($this->banner_w_thumb, $this->banner_h_thumb, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize1->saveImage($originalThumbFolder . '/' . $fileNameBanner);
}
/* * ****************** End : destinations Image upload here **************** */
$qaArray = array();
foreach ($getData['faq_question'] as $qKey => $qValue) {
$qaArray[$qKey] = [
'question' => $qValue,
'answer' => $getData['faq_answer'][$qKey],
];
}
$editDestinationData = [
'region_id' => (int)($getData['region_id']),
'Title' => ($getData['title']),
// 'Activities' => ($getData['activities']),
// 'Tours' => ($getData['tours']),
// 'Hotels' => ($getData['hotel']),
'Activities' => ($getData['startingPrice']),
// 'Image' => ($image1) ? : ,
// 'Bannerimg' => ($bannerimage),
'Countries' => ($getData['countries']),
'DestDescription' => ($getData['DestDescription']),
'IsActive' => ($getData['status']),
'IsFeatured' => ($getData['feature']),
'packageListTitle' => ($getData['packageListTitle']),
'packageListKeyword' => ($getData['packageListKeyword']),
'packageListDescription' => ($getData['packageListDescription']),
'destinationTitle' => ($getData['destinationTitle']),
'destinationKeyword' => ($getData['destinationKeyword']),
'destinationDescription' => ($getData['destinationDescription']),
'package_list_header' => ($getData['package_list_header']),
'package_list_footer' => ($getData['package_list_footer']),
'destination_header' => ($getData['destination_header']),
'destination_footer' => ($getData['destination_footer']),
'sightseeingIds' => isset($getData['sightseeingIds']) ? json_encode($getData['sightseeingIds']) : '',
'description' => $getData['description'],
'heading1' => $getData['heading1'],
'heading2' => $getData['heading2'],
'otherDescription' => $getData['otherDescription'],
'similarDestinations' => ($getData['similarDestinations']),
'exploreHomeDestination' => ($getData['exploreHomeDestination']),
'FAQ' => (!empty($qaArray)) ? json_encode($qaArray) : '',
'whyUseUs' => $getData['whyUseUs'],
'topTravelBlog' => isset($getData['topTravelBlog']) ? json_encode($getData['topTravelBlog']) : '',
'popularPackages' => $getData['popularPackages'],
'seotitle' => strtolower(Catabatic_Helper::getSeoName($getData['title'])),
];
if ($image)
$editDestinationData['Image'] = $fileName;
if ($bannerimage)
$editDestinationData['Bannerimg'] = $fileNameBanner;
if ($destinationImageFileName)
$editDestinationData['destinationImage'] = $destinationImagefileName;
//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']);
// echo "<pre>";print_r($result);die;
$this->view->pId = $pId;
$editdata["id"] = $result['DesSysId'];
$editdata["title"] = $result['Title'];
$editdata["startingPrice"] = $result['Activities'];
$editdata["tours"] = $result['Tours'];
$editdata["hotel"] = $result['Hotels'];
$editdata["image"] = $result['Image'];
$editdata["destinationImage"] = $result['destinationImage'];
$editdata["banner_image"] = $result['Bannerimg'];
$editdata["countries"] = $result['Countries'];
$editdata["DestDescription"] = $result['DestDescription'];
$editdata["feature"] = $result['IsFeatured'];
$editdata["status"] = $result['IsActive'];
$editdata["region_id"] = $result['region_id'];
$editdata["packageListTitle"] = $result['packageListTitle'];
$editdata["packageListKeyword"] = $result['packageListKeyword'];
$editdata["packageListDescription"] = $result['packageListDescription'];
$editdata["destinationTitle"] = $result['destinationTitle'];
$editdata["destinationKeyword"] = $result['destinationKeyword'];
$editdata["destinationDescription"] = $result['destinationDescription'];
$form->populate($editdata);
$this->view->destinationImage = $result['destinationImage'];
$this->view->image = $result['Image'];
$this->view->banner_image = $result['Bannerimg'];
$this->view->package_list_header = $result['package_list_header'];
$this->view->package_list_footer = $result['package_list_footer'];
$this->view->destination_header = $result['destination_header'];
$this->view->destination_footer = $result['destination_footer'];
$this->view->description = $result['description'];
$this->view->heading1 = $result['heading1'];
$this->view->heading2 = $result['heading2'];
$this->view->otherDescription = $result['otherDescription'];
$this->view->sightseeingIds = $result['sightseeingIds'];
$this->view->popularPackagesIds = $result['popularPackages'];
$this->view->FAQ = $result['FAQ'];
$this->view->whyUseUs = $result['whyUseUs'];
$this->view->topTravelBlog = $result['topTravelBlog'];
$this->view->exploreHomeDestination = $result['exploreHomeDestination'];
$this->view->form = $form;
$this->view->page = $page;
$this->view->SelectedDestinationsName = $SelectedDestinationsName;
$this->view->blog = $blog;
}
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 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 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)>10){
// $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();
}
}
}
/**
* regionAction() method is used to list all regions
* @param Null
* @return Array
*/
public function regionAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
$resultsetContinent = $crud->rv_select_all($this->tablenameContinent, ['*'], ['status'], ['ContinentTitle' => 'ASC']);
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchRegionArr = array(
'title' => $getData['title'],
'rows' => $getData['rows'],
'page' => $getData['page'],
);
$resulsetold = $crud->getCount($this->tablenameRegion, ['tbl.IsMarkForDel' => 0], 'sid');
$crud->searchRegionArr = $searchRegionArr;
//$resultset = $crud->rv_select_all( $this->tablenameRegion , ['sid','Title','IsActive','ContinentId','region_type','displayOnHeader'] , ['IsMarkForDel'=>0], ['UpdateDate'=>'DESC'] );
$resultset = $crud->rv_select_all_regions();
// echo "<pre>"; print_r($resultset);die;
$result1 = array();
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
if ($resultval['displayOnHeader'] == 1) {
$checked = 'checked';
} else {
$checked = '';
}
$ContinentId = '--';
foreach ($resultsetContinent as $key1 => $value1) {
if ($resultval['ContinentId'] == $value1['ContinentId'] && $resultval['ContinentId'] != '' && $resultval['ContinentId'] != 0) {
$ContinentId = $value1['ContinentTitle'];
}
}
$result1[] = [
'title' => $resultval['title'],
'continent' => $ContinentId,
'region_type' => ($resultval['region_type'] == 1) ? 'India' : 'International',
'displayOnHeader' => '<input type="checkbox" ' . $checked . ' onClick="DisplayOnHeader(' . $resultval['sid'] . ')" id="DisplayHeaderActive_' . $resultval['sid'] . '" name="DisplayHeaderActive" value="1">',
'action' => '<a href="admin/destination/editregion/id/' . $resultval['sid'] . '" title="Edit"><i class="icon-pencil"></i></a>',
];
}
}
$result = Zend_Json::encode($result1);
$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") {
$orignalFIleName = $_FILES['image']['name'];
if (!empty($orignalFIleName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->regionImageUrl;
$fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
$fileName = $this->current_time . '.' . $fileExt;
$originalSmallFolder = $orignalFolderName . "/small";
if (!file_exists($originalSmallFolder)) {
mkdir($originalSmallFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
@copy($orignalFolderName . '/' . $fileName, $originalSmallFolder . "/" . $fileName); // copy uploaded file into this location directory
$objImageResize3 = new Catabatic_Imageresize($originalSmallFolder . '/' . $fileName);
$objImageResize3->resizeImage($this->img_w_regionsmall, $this->img_h_regionsmall, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize3->saveImage($originalSmallFolder . '/' . $fileName);
}
$img = '';
if ($fileName != "") {
$img = $fileName;
}
$savePageData = [
'title' => ($getData['title']),
'IsActive' => ($getData['status']),
'image' => $img,
];
$crud->rv_insert($this->tablenameRegion, $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)) {
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
$orignalFIleName = $_FILES['image']['name'];
$bannerImageFIleName = $_FILES['banner_image']['name'];
if (!empty($orignalFIleName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->regionImageUrl;
$fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
$fileName = $this->current_time . '.' . $fileExt;
$originalSmallFolder = $orignalFolderName . "/small";
if (!file_exists($originalSmallFolder)) {
mkdir($originalSmallFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
@copy($orignalFolderName . '/' . $fileName, $originalSmallFolder . "/" . $fileName); // copy uploaded file into this location directory
$objImageResize3 = new Catabatic_Imageresize($originalSmallFolder . '/' . $fileName);
$objImageResize3->resizeImage($this->img_w_regionsmall, $this->img_h_regionsmall, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize3->saveImage($originalSmallFolder . '/' . $fileName);
}
if (!empty($bannerImageFIleName)) {
$bannerImageFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->regionImageUrl;
$bannerImagefileExt = $this->_helper->General->getFileExtension($bannerImageFIleName);
$bannerImagefileName = 'banner_' . $this->current_time . '.' . $bannerImagefileExt;
$bannerImageBannerFolder = $bannerImageFolderName . "/banner";
if (!file_exists($bannerImageBannerFolder)) {
mkdir($bannerImageBannerFolder, $this->DIR_WRITE_MODE, true);
}
$banner_temp_file_name = $_FILES["banner_image"]["tmp_name"]; // temprary file name
@move_uploaded_file($banner_temp_file_name, $bannerImageFolderName . "/" . $bannerImagefileName);
@copy($bannerImageFolderName . '/' . $bannerImagefileName, $bannerImageBannerFolder . "/" . $bannerImagefileName); // copy uploaded file into this location directory
$objImageResize3 = new Catabatic_Imageresize($bannerImageBannerFolder . '/' . $bannerImagefileName);
$objImageResize3->resizeImage($this->banner_w_large, $this->banner_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize3->saveImage($bannerImageBannerFolder . '/' . $bannerImagefileName);
}
$editDestinationData = [
'ContinentId' => ($getData['ContinentId']),
'title' => ($getData['title']),
'label' => strtolower(Catabatic_Helper::getSeoName($getData['title'])),
'UpdateDate' => date("Y-m-d H:i:s"),
'IsActive' => ($getData['status']),
'Metatag' => ($getData['Metatag']),
'Keyword' => ($getData['Keyword']),
'Description' => ($getData['Description']),
'region_header_content' => ($getData['region_header_content']),
'region_footer_content' => ($getData['region_footer_content']),
];
if ($fileName != "") {
$editDestinationData['image'] = $fileName;
}
if ($bannerImagefileName != "") {
$editDestinationData['banner_image'] = $bannerImagefileName;
}
//echo "<pre>";print_r($editDestinationData);die;
$crud->rv_update($this->tablenameRegion, $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($this->tablenameRegion, ['title', 'sid', 'IsActive', 'image', 'ContinentId', 'banner_image','Metatag','Keyword','Description','region_header_content','region_footer_content'], ['sid' => $pId], ['sid' => 'DESC']);
// echo "<pre>";print_r($result);die;
$this->view->pId = $pId;
$editdata["sid"] = @$result->sid;
$editdata["title"] = @$result->title;
$editdata["status"] = @$result->IsActive;
$editdata["image"] = @$result->image;
$editdata["banner_image"] = @$result->banner_image;
$editdata["ContinentId"] = $result->ContinentId;
// echo "<pre>";print_r($editdata);die;
$this->view->image = $result->image;
$this->view->banner_image = $result->banner_image;
$this->view->resultRegion = $result;
$form->populate($editdata);
$this->view->form = $form;
}
/**
* 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($this->tablenameRegion, ['sid'], ['sid' => $tId], ['sid' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_update($this->tablenameRegion, ['IsMarkForDel' => 1], ['sid =?' => $tId]);
$this->_helper->flashMessenger->addMessage("Deleted successfully.");
$this->_redirect("/admin/destination/region");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function displayHeaderRegionAction() {
$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($this->tablenameRegion, $updatedata, ['sid =?' => $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 continentAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
//$resultset = $crud->rv_select_all( $this->tablenameContinent , ['*'] , ['status'], ['ContinentTitle'=>'ASC'] );
$resultset = $crud->rv_select_all_continent();
$finalContinent = array();
foreach ($resultset as $key => $value) {
$finalContinent[$value['ContinentId']]['ContinentId'] = $value['ContinentId'];
$finalContinent[$value['ContinentId']]['ContinentTitle'] = $value['ContinentTitle'];
$finalContinent[$value['ContinentId']]['region_name'][] = $value['region_name'];
$finalContinent[$value['ContinentId']]['status'] = $value['status'];
}
// echo "<pre>";print_r($finalContinent);die;
# Start : Pagination
$page = $this->_getParam('page', 1);
$resultset = Zend_Paginator::factory($finalContinent);
$resultset->setItemCountPerPage($this->per_page_record);
$resultset->setCurrentPageNumber($page);
# End : Pagination
$this->view->per_page_record = $this->per_page_record;
$this->view->page = $page;
$this->view->resultset = $resultset;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function addcontinentAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editcontinent();
$tId = (int) $this->getRequest()->getParam("id");
$form->setAction("admin/destination/addcontinent");
$form->setMethod("POST");
$form->setName("add_continent");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if (isset($getData['save']) == "Save") {
$savePageData = [
'ContinentTitle' => ($getData['ContinentTitle']),
'status' => ($getData['status']),
'ContinentLabel' => strtolower(Catabatic_Helper::getSeoName($getData['ContinentTitle'])),
'UpdateDate' => date("Y-m-d H:i:s"),
'status' => ($getData['status']),
];
$crud->rv_insert($this->tablenameContinent, $savePageData);
$this->view->successMessage = "Region has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Region has been saved successfully.");
$this->_redirect("/admin/destination/continent");
}
}
$this->view->form = $form;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
/**
* editregionAction() method is used to edit regions
* @param array
* @return boolean
*/
public function editcontinentAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editcontinent();
$pId = (int) $this->getRequest()->getParam("id");
$form->setMethod("POST");
$form->setAction("admin/destination/editcontinent/id/" . $pId);
$form->setName("edit_continent");
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") {
$editDestinationData = [
'ContinentTitle' => ($getData['ContinentTitle']),
'ContinentLabel' => strtolower(Catabatic_Helper::getSeoName($getData['ContinentTitle'])),
'UpdateDate' => date("Y-m-d H:i:s"),
'status' => ($getData['status']),
];
//echo "<pre>";print_r($editDestinationData);die;
$crud->rv_update($this->tablenameContinent, $editDestinationData, ['ContinentId =?' => $pId]);
$this->view->successMessage = "Region has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Region has been updated successfully.");
$this->_redirect("/admin/destination/continent");
}
}
}
$result = $crud->getCmsdata($this->tablenameContinent, ['*'], ['ContinentId' => $pId], ['ContinentId' => 'DESC']);
// echo "<pre>";print_r($result);die;
$this->view->pId = $pId;
$editdata["ContinentId"] = @$result->ContinentId;
$editdata["ContinentTitle"] = @$result->ContinentTitle;
$editdata["status"] = @$result->status;
// echo "<pre>";print_r($editdata);die;
$form->populate($editdata);
$this->view->form = $form;
}
public function displayHeaderAction() {
$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('tb_tbb2c_destinations', $updatedata, ['DesSysId =?' => $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 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['displayOnHeader'] == 1) ? 'checked' : '';
$checkedHome = ($resultval['displayOnHome'] == 1) ? 'checked' : '';
$checkedFooter = ($resultval['displayOnFooter'] == 1) ? 'checked' : '';
$result1[] = [
'title' => $resultval['title'],
'region_name' => $resultval['region_name'],
'displayOnHeader' => '<input type="checkbox" ' . $checked . ' onClick="DisplayOnHeader(' . $resultval['countryId'] . ')" id="DisplayHeaderActive_' . $resultval['countryId'] . '" name="DisplayHeaderActive" value="1">',
'displayOnHome' => '<input type="checkbox" ' . $checkedHome . ' onClick="displayOnHome(' . $resultval['countryId'] . ')" id="DisplayHomeActive_' . $resultval['countryId'] . '" name="DisplayHomeActive" value="1">',
'displayOnFooter' => '<input type="checkbox" ' . $checkedFooter . ' onClick="displayOnFooter(' . $resultval['countryId'] . ')" id="DisplayFooterActive_' . $resultval['countryId'] . '" name="DisplayFooterActive" value="1">',
'action' => '<a href="admin/destination/editcountry/id/' . $resultval['countryId'] . '/cont/' . $resultval['title'] . '" title="Edit"><i class="icon-pencil"></i></a> <a title="Download Sightseeings" href="javascript://" onclick="syncSightseeingCountry('.$resultval['countryId'].')"><i class="icon-download-alt"></i></a><br><span style="display: none" class="displayProcessing'.$resultval['countryId'].'"><img src="public/images/loader-sm.gif" width="24" title="Processing..." alt="Processing..."></span>',
];
}
}
$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']);
//echo "<pre>";print_r($resultCountry);die;
$SelectedDestinationsName1 = $SelectedDestinationsName2 = $SelectedDestinationsName =array();
if ($resultCountry['similarDestinations']) {
$SelectedDestinationsName1 = $crud->rv_select_all_destinationByIds('tb_tbb2c_destinations', ['Title', 'DesSysId'], ['IsActive' => 1, 'IsMarkForDel' => 0], 'DesSysId', $resultCountry['similarDestinations']);
$SelectedDestinationsName2 = $crud->rv_select_all_destinationByIds('tbl_countries',['title as Title','countryId as DesSysId','title as Countries','startingPrice as Activities','destinationImage','image'],['IsActive'=>1,'IsMarkForDel'=>0],'countryId',$resultCountry['similarDestinations']);
$SelectedDestinationsName = array_merge($SelectedDestinationsName1,$SelectedDestinationsName2);
}
$regions = $crud->rv_select_all('tbl_regions', ['title', 'sid', 'countryIds', 'region_id'], ['IsActive' => 1, 'IsMarkForDel' => 0], ['title' => 'ASC']);
$blog = $crud->rv_select_all('tbl_blog', ['BlogId', 'BlogTitle', 'BlogIdentifier', 'BlogImage', 'BlogDescription'], ['status' => 1, 'IsMarkForDel' => 0], ['BlogId' => '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") {
$result = $crud->getCmsdata($this->tablenameRegion, ['countryIds', 'countries'], ['sid' => $getData['region_id']], ['sid' => 'DESC']);
$qaArray = array();
foreach ($getData['faq_question'] as $qKey => $qValue) {
$qaArray[$qKey] = [
'question' => $qValue,
'answer' => $getData['faq_answer'][$qKey],
];
}
$MainImageFileName = $_FILES['image']['name'];
/* * ****************** Starts : destinations Image upload here **************** */
if (!empty($MainImageFileName)) {
$MainFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageCountryUrl . "/main"; // root folder for destination images
/* Get File Extension */
$fileExtMain = $this->_helper->General->getFileExtension($MainImageFileName);
$fileNameMain = $this->current_time . '.' . $fileExtMain;
$MainHomeFolder = $MainFolderName . "/home";
$MainLargeFolder = $MainFolderName . "/large";
/* Create directory if not exists */
if (!file_exists($MainFolderName)) {
mkdir($MainFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($MainHomeFolder)) {
mkdir($MainHomeFolder, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($MainLargeFolder)) {
mkdir($MainLargeFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name_main = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name_main, $MainFolderName . "/" . $fileNameMain);
@copy($MainFolderName . '/' . $fileNameMain, $MainLargeFolder . "/" . $fileNameMain); // copy uploaded file into this location directory
$objImageResize4 = new Catabatic_Imageresize($MainLargeFolder . '/' . $fileNameMain);
$objImageResize4->resizeImage($this->img_w_large, $this->img_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize4->saveImage($MainLargeFolder . '/' . $fileNameMain);
@copy($MainFolderName . '/' . $fileNameMain, $MainHomeFolder . "/" . $fileNameMain); // copy uploaded file into this location directory
$objImageResize2 = new Catabatic_Imageresize($MainHomeFolder . '/' . $fileNameMain);
$objImageResize2->resizeImage(278, 392, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize2->saveImage($MainHomeFolder . '/' . $fileNameMain);
}
$destinationImageFileName = $_FILES["destinationImage"]["name"];
if (!empty($destinationImageFileName)) {
$destinationImageFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageCountryUrl . "/desimages"; // root folder for destination images
/* Get File Extension */
$destinationImagefileExt = $this->_helper->General->getFileExtension($destinationImageFileName);
$destinationImagefileName = $pId . '_' . $this->current_time . '.' . $destinationImagefileExt;
$destinationImageoriginalMainFolder = $destinationImageFolderName . "/main";
/* Create directory if not exists */
if (!file_exists($destinationImageFolderName)) {
mkdir($destinationImageFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($destinationImageoriginalMainFolder)) {
mkdir($destinationImageoriginalMainFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name_dest = $_FILES["destinationImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name_dest, $destinationImageFolderName . "/" . $destinationImagefileName);
@copy($destinationImageFolderName . '/' . $destinationImagefileName, $destinationImageoriginalMainFolder . "/" . $destinationImagefileName); // copy uploaded file into this location directory
$objImageResize1 = new Catabatic_Imageresize($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
$objImageResize1->resizeImage($this->img_w_destination_main, $this->img_h_destination_main, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize1->saveImage($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
}
$bannerimage = $_FILES["bannerImage"]["name"];
if (!empty($bannerimage)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageCountryUrl . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($bannerimage);
$fileNameBanner = $this->current_time . '.' . $fileExt;
$originalLargeFolder = $orignalFolderName . "/large";
/* Create directory if not exists */
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["bannerImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileNameBanner);
@copy($orignalFolderName . '/' . $fileNameBanner, $originalLargeFolder . "/" . $fileNameBanner); // copy uploaded file into this location directory
$objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileNameBanner);
$objImageResize4->resizeImage($this->country_banner_h_large, $this->country_banner_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize4->saveImage($originalLargeFolder . '/' . $fileNameBanner);
}
// if($resultCountry){
$editCountryData = [
'startingPrice' => $getData['startingPrice'],
'DestDescription' => $getData['DestDescription'],
'sightseeingIds' => isset($getData['sightseeingIds']) ? json_encode($getData['sightseeingIds']) : '',
'description' => $getData['description'],
'heading1' => $getData['heading1'],
'heading2' => $getData['heading2'],
// 'heading3' => $getData['heading3'],
'otherDescription' => $getData['otherDescription'],
'similarDestinations' => ($getData['similarDestinations']),
'FAQ' => (!empty($qaArray)) ? json_encode($qaArray) : '',
'whyUseUs' => $getData['whyUseUs'],
'topTravelBlog' => isset($getData['topTravelBlog']) ? json_encode($getData['topTravelBlog']) : '',
'metaTitle' => $getData['metaTitle'],
'metaKeyword' => $getData['metaKeyword'],
'metaDescription' => $getData['metaDescription'],
'meta_header' => $getData['meta_header'],
'meta_footer' => $getData['meta_footer'],
'popularPackages' => $getData['popularPackages'],
'region_id' => $getData['region_id'],
'packageListTitle' => ($getData['packageListTitle']),
'packageListKeyword' => ($getData['packageListKeyword']),
'packageListDescription' => ($getData['packageListDescription']),
'package_list_header' => ($getData['package_list_header']),
'package_list_footer' => ($getData['package_list_footer']),
];
if ($fileNameBanner) {
$editCountryData['bannerImage'] = $fileNameBanner;
}
if ($fileNameMain) {
$editCountryData['image'] = $fileNameMain;
}
if ($destinationImagefileName) {
$editCountryData['destinationImage'] = $destinationImagefileName;
}
// echo "<pre>";print_r($editCountryData);die;
$crud->rv_update('tbl_countries', $editCountryData, ['countryId =?' => $pId]);
// }else{
// $addCountryData = [
// 'countryId'=>(int) $pId,
// 'countryName'=>$cont,
// 'counNameIdentifier' =>strtolower(Catabatic_Helper::getSeoName($cont)),
// 'sightseeingIds'=>isset($getData['sightseeingIds']) ? json_encode($getData['sightseeingIds']): '',
// 'description'=>$getData['description'],
// 'similarDestinations' => ($getData['similarDestinations']),
// 'FAQ' => (!empty($qaArray)) ? json_encode($qaArray) :'',
// 'whyUseUs' => $getData['whyUseUs'],
// 'topTravelBlog'=>isset($getData['topTravelBlog']) ? json_encode($getData['topTravelBlog']): '',
// 'metaTitle'=>$getData['metaTitle'],
// 'metaKeyword'=>$getData['metaKeyword'],
// 'metaDescription'=>$getData['metaDescription'],
// 'meta_header'=>$getData['meta_header'],
// 'meta_footer'=>$getData['meta_footer'],
// 'popularPackages'=>$getData['popularPackages'],
// ];
// if($fileNameBanner){
// $addCountryData['bannerImage'] = $fileNameBanner;
// }
//// echo "<pre>";print_r($addCountryData);die;
// $crud->rv_insert( 'tbl_destination_countries' , $addCountryData);
// }
$this->view->successMessage = "Content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Content has been updated successfully.");
$this->_redirect("/admin/destination/country");
}
}
$sightseeingData = $crud->rv_select_all('tb_ic_sightseeing', ['Title', 'WriteUp', 'SSSysId', 'DetailImg'], [ 'ContSysId' => $pId,'IsActive' => '1' , 'IsMarkForDel' => '0'], ['SSSysId' => 'DESC']);
$this->view->sightseeingData = $sightseeingData;
$this->view->pId = $pId;
$this->view->regions = $regions;
$this->view->resultCountry = $resultCountry;
$this->view->SelectedDestinationsName = $SelectedDestinationsName;
$this->view->blog = $blog;
// echo "<pre>";print_r($editdata);die;
//$form->populate($editdata);
//$this->view->form = $form;
}
public function displayHeaderCountryAction() {
$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_countries', $updatedata, ['countryId =?' => $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 displayHomeCountryAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) trim($this->getRequest()->getParam("val"));
if ($tId) {
try {
$updatedata = [
'displayOnHome' => $val
];
$result = $crud->rv_update('tbl_countries', $updatedata, ['countryId =?' => $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 displayFooterCountryAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) trim($this->getRequest()->getParam("val"));
if ($tId) {
try {
$updatedata = [
'displayOnFooter' => $val
];
$result = $crud->rv_update('tbl_countries', $updatedata, ['countryId =?' => $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 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'],
);
$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' : '';
$checkedHome = ($resultval['displayOnHome'] == 1) ? 'checked' : '';
$checkedFooter = ($resultval['displayOnFooter'] == 1) ? 'checked' : '';
$result1[] = [
'title' => $resultval['title'],
'region_name' => $resultval['region_name'],
'countryName' => $resultval['countryName'],
'displayOnHeader' => '<input type="checkbox" ' . $checked . ' onClick="DisplayOnHeader(' . $resultval['stateId'] . ')" id="DisplayHeaderActive_' . $resultval['stateId'] . '" name="DisplayHeaderActive" value="1">',
'displayOnHome' => '<input type="checkbox" ' . $checkedHome . ' onClick="DisplayOnHome(' . $resultval['stateId'] . ')" id="DisplayHomeActive_' . $resultval['stateId'] . '" name="DisplayHomeActive" value="1">',
'displayOnFooter' => '<input type="checkbox" ' . $checkedFooter . ' onClick="DisplayOnFooter(' . $resultval['stateId'] . ')" id="DisplayFooterActive_' . $resultval['stateId'] . '" name="DisplayFooterActive" 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");
$state = $this->getRequest()->getParam("state");
$resultState = $crud->getCmsdata('tbl_states', ['*'], ['stateId' => $StateSysId], ['StateSysId' => 'DESC']);
$SelectedDestinationsName1 = $SelectedDestinationsName1 = $SelectedDestinationsName =array();
// echo "<pre>";print_r($resultState);die;
if ($resultState['similarDestinations']) {
$SelectedDestinationsName1 = $crud->rv_select_all_destinationByIds('tb_tbb2c_destinations', ['Title', 'DesSysId'], ['IsActive' => 1, 'IsMarkForDel' => 0], 'DesSysId', $resultState['similarDestinations']);
$SelectedDestinationsName2 = $crud->rv_select_all_destinationByIds('tbl_countries',['title as Title','countryId as DesSysId','title as Countries','startingPrice as Activities','destinationImage','image'],['IsActive'=>1,'IsMarkForDel'=>0],'countryId',$resultState['similarDestinations']);
$SelectedDestinationsName = array_merge($SelectedDestinationsName1,$SelectedDestinationsName2);
}
$regions = $crud->rv_select_all('tbl_regions', ['title', 'sid', 'countryIds', 'region_id'], ['IsActive' => 1, 'IsMarkForDel' => 0], ['title' => 'ASC']);
$blog = $crud->rv_select_all('tbl_blog', ['BlogId', 'BlogTitle', 'BlogIdentifier', 'BlogImage', 'BlogDescription'], ['status' => 1, 'IsMarkForDel' => 0], ['BlogId' => '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") {
$MainImageFileName = $_FILES['image']['name'];
/* * ****************** Starts : destinations Image upload here **************** */
if (!empty($MainImageFileName)) {
$MainFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageStateUrl . "/main"; // root folder for destination images
/* Get File Extension */
$fileExtMain = $this->_helper->General->getFileExtension($MainImageFileName);
$fileNameMain = $this->current_time . '.' . $fileExtMain;
$MainHomeFolder = $MainFolderName . "/home";
$MainLargeFolder = $MainFolderName . "/large";
/* Create directory if not exists */
if (!file_exists($MainFolderName)) {
mkdir($MainFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($MainHomeFolder)) {
mkdir($MainHomeFolder, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($MainLargeFolder)) {
mkdir($MainLargeFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name_main = $_FILES["image"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name_main, $MainFolderName . "/" . $fileNameMain);
@copy($MainFolderName . '/' . $fileNameMain, $MainLargeFolder . "/" . $fileNameMain); // copy uploaded file into this location directory
$objImageResize4 = new Catabatic_Imageresize($MainLargeFolder . '/' . $fileNameMain);
$objImageResize4->resizeImage($this->img_w_large, $this->img_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize4->saveImage($MainLargeFolder . '/' . $fileNameMain);
@copy($MainFolderName . '/' . $fileNameMain, $MainHomeFolder . "/" . $fileNameMain); // copy uploaded file into this location directory
$objImageResize2 = new Catabatic_Imageresize($MainHomeFolder . '/' . $fileNameMain);
$objImageResize2->resizeImage(800, 600, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize2->saveImage($MainHomeFolder . '/' . $fileNameMain);
}
$destinationImageFileName = $_FILES["destinationImage"]["name"];
if (!empty($destinationImageFileName)) {
$destinationImageFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageStateUrl . "/desimages"; // root folder for destination images
/* Get File Extension */
$destinationImagefileExt = $this->_helper->General->getFileExtension($destinationImageFileName);
$destinationImagefileName = $pId . '_' . $this->current_time . '.' . $destinationImagefileExt;
$destinationImageoriginalMainFolder = $destinationImageFolderName . "/main";
/* Create directory if not exists */
if (!file_exists($destinationImageFolderName)) {
mkdir($destinationImageFolderName, $this->DIR_WRITE_MODE, true);
}
if (!file_exists($destinationImageoriginalMainFolder)) {
mkdir($destinationImageoriginalMainFolder, $this->DIR_WRITE_MODE, true);
}
$temp_file_name_dest = $_FILES["destinationImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name_dest, $destinationImageFolderName . "/" . $destinationImagefileName);
@copy($destinationImageFolderName . '/' . $destinationImagefileName, $destinationImageoriginalMainFolder . "/" . $destinationImagefileName); // copy uploaded file into this location directory
$objImageResize1 = new Catabatic_Imageresize($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
$objImageResize1->resizeImage($this->img_w_destination_main, $this->img_h_destination_main, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize1->saveImage($destinationImageoriginalMainFolder . '/' . $destinationImagefileName);
}
$bannerimage = $_FILES["bannerImage"]["name"];
if (!empty($bannerimage)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageStateUrl . "/banner"; // root folder for destination images
/* Get File Extension */
$fileExt = $this->_helper->General->getFileExtension($bannerimage);
$fileNameBanner = $this->current_time . '.' . $fileExt;
$originalLargeFolder = $orignalFolderName . "/large";
/* Create directory if not exists */
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["bannerImage"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileNameBanner);
@copy($orignalFolderName . '/' . $fileNameBanner, $originalLargeFolder . "/" . $fileNameBanner); // copy uploaded file into this location directory
$objImageResize4 = new Catabatic_Imageresize($originalLargeFolder . '/' . $fileNameBanner);
$objImageResize4->resizeImage($this->country_banner_h_large, $this->country_banner_h_large, 'exact'); // param : width , height , (exact|portrait|landscape|auto|crop)
$objImageResize4->saveImage($originalLargeFolder . '/' . $fileNameBanner);
}
$editStateData = [
'title' => $getData['Title'],
'region_id' => $getData['region_id'],
'heading1' => $getData['heading1'],
'heading2' => $getData['heading2'],
'description' => $getData['description'],
'otherDescription' => $getData['otherDescription'],
'similarDestinations' => ($getData['similarDestinations']),
'cityData' => isset($getData['cityData']) ? json_encode($getData['cityData']) : '',
'topTravelBlog' => isset($getData['topTravelBlog']) ? json_encode($getData['topTravelBlog']) : '',
'metaTitle' => $getData['metaTitle'],
'metaKeyword' => $getData['metaKeyword'],
'metaDescription' => $getData['metaDescription'],
'meta_header' => $getData['meta_header'],
'meta_footer' => $getData['meta_footer'],
'popularPackages' => $getData['popularPackages'],
'startingPrice' => $getData['startingPrice'],
'DestDescription' => $getData['DestDescription'],
'packageListMetaTitle' => $getData['packageListMetaTitle'],
'packageListMetaKeyword' => $getData['packageListMetaKeyword'],
'packageListMetaDescription' => $getData['packageListMetaDescription'],
'package_list_header_content' => $getData['package_list_header_content'],
'package_list_footer_content' => $getData['package_list_footer_content'],
];
if ($fileNameBanner) {
$editStateData['bannerImage'] = $fileNameBanner;
}
if ($fileNameMain) {
$editStateData['image'] = $fileNameMain;
}
if ($destinationImageFileName) {
$editStateData['destinationImage'] = $destinationImagefileName;
}
// echo "<pre>";print_r($editStateData);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");
}
}
//echo "<pre>";print_r($editStateData);die;
$cityData = $crud->rv_select_all('tb_tbb2c_destinations', ['Title', 'DesId'], [ 'stateId' => $StateSysId], ['DesSysId' => 'DESC']);
$this->view->cityData = $cityData;
// echo "<pre>";print_r($editStateData);die;
$this->view->resultState = $resultState;
$this->view->StateSysId = $StateSysId;
$this->view->state = $state;
$this->view->regions = $regions;
$this->view->blog = $blog;
$this->view->SelectedDestinationsName = $SelectedDestinationsName;
//$form->populate($editdata);
//$this->view->form = $form;
}
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 displayHomeStateAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) trim($this->getRequest()->getParam("val"));
if ($tId) {
try {
$updatedata = [
'displayOnHome' => $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 displayFooterStateAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) trim($this->getRequest()->getParam("val"));
if ($tId) {
try {
$updatedata = [
'displayOnFooter' => $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 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);
// echo "<pre>";print_r($arrResponse);die('here');
}
// print_r($arrResponse);die;
}
echo json_encode($arrResponse);
exit;
} catch (Exception $e) {
$response = array('success' => false, 'msg' => $e->getMessage());
echo json_encode($response);
exit;
}
}
}