| 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_PromotionController 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->tablename ='tb_tbb2c_packages_master';
$this->username = $authStorage->username;
$this->admin_type = $authStorage->role;
$options = $aConfig['bootstrap'];
$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/static_pages/';
$this->iconUrl = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/promotion/essential/';
$this->imageUrlHome = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/promotion/banner/';
$this->imageUrlGallery = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/gallery/';
$this->imageUrlOffer = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/offer/';
$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;
$this->travelleressentials = (($this->appmode == 'MODE_BETA') ? 'beta/' : '') . 'public/upload/travelleressentials/banner/';
}
/**
* index() method is used to admin login for form call
* @param Null
* @return Array
*/
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 = [
'DisplaySaudiHome' => $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 destinationAction(){
// //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->rv_select_static('tb_tbb2c_destinations',['*'],['isMarkForDel' =>0 ],['DesSysId'=> 'DESC']);
// // 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'],
// 'DisplayPromotionHome' => $resultval['DisplayPromotionHome'],
// 'DisplayOnFooter' => $resultval['DisplayOnFooter'],
// '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 travelleressentialsAction()
{
//Check admin logedin or not
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
$getData = array();
if($this->getRequest()->isPost())
{
$getData = $this->getRequest()->getPost();
$searchArr = array(
'Title'=>$getData['Title'],
'rows'=>$getData['rows'],
'page'=>$getData['page'],
);
$resulsetold = $crud->getCount('tbl_travelleressentials_agency',['isMarkForDel' =>0],'id');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_static('tbl_travelleressentials_agency',['*'],['isMarkForDel' =>0 ],['id'=> 'DESC']);
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
$result1[] = [
'id' => $resultval['id'],
'icon' => $resultval['icon'],
// 'image' => '<img src="public/upload/offers/'.$resultval['Id'].'/small/'.$resultval['image'].'" width="60px" height="60px">',
'isActive' => $resultval['isActive']==1?'Active':'Deactive',
];
}
}
$result = Zend_Json::encode($result1);
$newResult = Zend_Json::decode($result,false);
$finalResult["total"]=$resulsetold[0]['id'];
$finalResult["rows"]=$newResult;
echo json_encode($finalResult);
exit;
}
}
/**
* editpage() method is used to admin can edit cms static page
* @param password string
* @return ture
*/
public function edittravelleressentialsAction()
{
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
$pId = (int)$this->getRequest()->getParam("id");
if( $this->getRequest()->isPost() ) {
$getData = $this->getRequest()->getPost();
//-------Start Code for Approve and Publish content---------//
if(isset($getData['save'])=="Save") {
// echo "<pre>";print_r($getData);die;
$id = $getData['id'];
$orignalFIleName = $icon = $_FILES["icon"]["name"];
$fileName = '';
if (!empty($orignalFIleName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->iconUrl.$pId ;
$fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
$fileName = $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["icon"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
}
$editPageData = [
'title' => ($getData['title']),
'url' => ($getData['url']),
'tab' => ($getData['tab']),
'isActive' => ($getData['isActive']),
];
if( $fileName) {
$editPageData['icon'] = $fileName;
}
// echo "<pre>";print_r($editPageData);die;
$crud->rv_update('tbl_travelleressentials_agency', $editPageData, ['id =?'=>$pId]);
$this->view->successMessage ="Page Essentials content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page Essentials content has been updated successfully.");
$this->_redirect("/admin/promotion/travelleressentials");
}
}
$result = $crud->getCmsdata('tbl_travelleressentials_agency', ['*'], ['id'=>$pId], ['id'=>'DESC']);
// echo "<pre>";print_r($result);die;
$editdata["id"] = @$result->id;
$editdata["title"] = @$result->title;
$editdata["icon"] = @$result->icon;
$editdata["url"] = @$result->url;
$editdata["tab"] = @$result->tab;
$editdata["isActive"] = @$result->isActive;
// echo "<pre>";print_r($editdata);die;
$this->view->icon = @$result->icon;
$this->view->editdata = $editdata;
}
public function addtravelleressentialsAction()
{
$this->checklogin();
$crud = new Admin_Model_CRUD();
$pId = (int)$this->getRequest()->getParam("id");
if( $this->getRequest()->isPost() ) {
$getData = $this->getRequest()->getPost();
$lastRow = $crud->getCmsdata('tbl_travelleressentials_agency', ['Id'], ['Id'], ['Id'=>'DESC']);
$pId = $lastRow['Id'] + 1;
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
// echo "<pre>";print_r($getData);die;
$id = $getData['id'];
$orignalFIleName = $icon = $_FILES["icon"]["name"];
$fileName = '';
if (!empty($orignalFIleName)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->iconUrl.$pId ;
$fileExt = $this->_helper->General->getFileExtension($orignalFIleName);
$fileName = $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["icon"]["tmp_name"]; // temprary file name
@move_uploaded_file($temp_file_name, $orignalFolderName . "/" . $fileName);
$originalLargeFolder = $orignalFolderName.'/large';
$originalMediumFolder = $orignalFolderName.'/medium';
$originalSmallFolder = $orignalFolderName.'/small';
}
$savePageData = [
'title' => ($getData['title']),
'icon' => $fileName ,
'url' => ($getData['url']),
'tab' => (int)($getData['tab']),
'isActive' => ($getData['isActive']),
'isMarkForDel' => 0,
];
// echo "<pre>";print_r($savePageData);die;
$crud->rv_insert('tbl_travelleressentials_agency', $savePageData);
$this->view->successMessage = "Page Essentials content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page Essentials content has been added successfully.");
$this->_redirect("/admin/promotion/travelleressentials");
}
}
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function deletetravelleressentialsAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
//echo $tId;die;
if ($tId) {
$checkdata = $crud->rv_select_row('tbl_travelleressentials_agency', ['id'], ['id' => $tId], ['id' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_update('tbl_travelleressentials_agency', ['isMarkForDel'=> 1], ['id =?'=>$tId]);
$this->_helper->flashMessenger->addMessage("Delete successfully.");
$this->_redirect("/admin/promotion/travelleressentials");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function travelleressentialshomeAction() {
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editthingstodo();
$pId = 1;
$form->setMethod("POST");
$form->setAction("admin/promotion/travelleressentialshome/id/" . $pId);
$form->setName("edit_travelogues");
$resultsetPackage = $crud->rv_select_all('tb_tbb2c_packages_master', ['PkgSysId', 'GTXPkgId', 'LongJsonInfo', 'Destinations'], ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1],['PkgSysId' => 'DESC'],50);
$resultsetTravelogues = $crud->rv_select_all('tbl_travelogues', ['TravId', 'TravTitle', 'TravBannerImage', 'TravDestination'], ['IsMarkForDel' => 0],['TravId' => 'DESC'],50);
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
// if ($form->isValid($getData)) {
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
// echo "<pre>";print_r($getData);die;
//Code for check page alias name already exists or not
$TravId = $getData['TravId'];
$fileName = '';
$bannerimage = $_FILES['TravBannerImage']['name'];
if (!empty($bannerimage)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrl.$TravId.'/banner';
$fileExt = $this->_helper->General->getFileExtension($bannerimage);
$fileName = $this->current_time . '.' . $fileExt;
if (!file_exists($orignalFolderName)) {
mkdir($orignalFolderName, $this->DIR_WRITE_MODE, true);
}
$temp_file_name = $_FILES["TravBannerImage"]["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->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->banner_small_image_width,$this->banner_small_image_height);
}
$editPageData = [
'TravTitle' => ($getData['TravTitle']),
'TravIdentifier' => strtolower(Catabatic_Helper::getSeoName($getData['TravTitle'])),
'TravDescription' => ($getData['TravDescription']),
'status' => ($getData['status']),
'keyword' => ($getData['keyword']),
'TravyoutTitle' => ($getData['TravyoutTitle']),
'description' => ($getData['description']),
'metatag' => ($getData['metatag']),
'selectedPackages' => isset($getData['selectedPackages']) ? json_encode($getData['selectedPackages']): '',
'selectedTravelogues' => isset($getData['selectedTravelogues']) ? json_encode($getData['selectedTravelogues']): '',
];
if ($fileName !='') {
$editPageData['TravBannerImage'] = $fileName;
}
if($getData['status'] == 0){
$editPageData['displayOnBanner'] = 0;
}
$crud->rv_update('tbl_travel_essential_home', $editPageData, ['TravId =?' => $TravId]);
$this->view->successMessage = "Page content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
$this->_redirect("/admin/promotion/travelleressentialshome");
// }
}
}
$result = $crud->getCmsdata('tbl_travel_essential_home', ['*'], ['TravId' => $pId], ['TravId' => 'DESC']);
// echo "<pre>";print_r($result);die;
$editdata["TravId"] = @$result->TravId;
$editdata["TravTitle"] = @$result->TravTitle;
$editdata["TravImage"] = @$result->TravImage;
$editdata["TravBannerImage"] = @$result->TravBannerImage;
$editdata["TravDestination"] = @explode(",", $result->TravDestination);
$editdata["TravUploadedBy"] = @$result->TravUploadedBy;
$TravDate2 = explode('-', $result->TravDate);
$result->TravDate = $TravDate2[2] . "/" . $TravDate2[1] . "/" . $TravDate2[0];
$editdata["TravDate"] = @$result->TravDate;
$editdata["TravDays"] = @$result->TravDays;
$editdata["TravTraveller"] = @$result->TravTraveller;
$editdata["TravCost"] = @$result->TravCost;
$editdata["TravDescription"] = @$result->TravDescription;
$editdata["status"] = @$result->status;
$editdata["TravTags"] = @$result->tags;
$editdata["TravyoutTitle"] = @$result->TravyoutTitle;
$editdata["keyword"] = @$result->keyword;
$editdata["description"] = @$result->description;
$editdata["metatag"] = @$result->metatag;
$editdata["TravmImage"] .= @$result->TravmImage;
$editdata["category"] = @$result->category;
//echo "<pre>";print_r($editdata);die;
$form->populate($editdata);
$this->view->TravDate = @$result->TravDate;
$this->view->category = @$result->category;
$this->view->TravmImage .= @$result->TravmImage;
$this->view->TravBannerImage = @$result->TravBannerImage;
$this->view->TravBlogImage = @$result->TravImage;
$this->view->form = $form;
$this->view->resultsetPackage = $resultsetPackage;
$this->view->selectedPackages = @$result->selectedPackages;
$this->view->resultsetTravelogues = $resultsetTravelogues;
$this->view->selectedTravelogues = @$result->selectedTravelogues;
$this->view->TravId = @$result->TravId;
}
public function activepAction() {
$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_packages_master', $updatedata, ['PkgSysId =?' => $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 activehAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'DisplayPromotionHajiumrah' => $val
];
$result = $crud->rv_update('tb_tbb2c_packages_master', $updatedata, ['PkgSysId =?' => $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 packageAction() {
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
//echo"<pre>";print_r($crud);die;
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchArr = array(
'Destinations' => $getData['Destinations'],
'GTXPkgId' => $getData['packagenumber'],
'name' => $getData['name'],
'rows' => $getData['rows'],
'page' => $getData['page'],
'sort' => $getData['sort'],
'order' => $getData['order']
);
$resulsetold = $crud->getCount($this->tablename, ['tbl.IsActive' => 1, 'tbl.IsPublish' => 1, 'tbl.IsMarkForDel' => 0, 'tbl.ItemType' => 1], 'PkgSysId');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_all_package($this->tablename, ['PkgSysId', 'lastMinuteDeal', 'GTXPkgId', 'LongJsonInfo', 'Destinations', 'Countries', 'Image', 'HotDeal', 'PkgValidUntil', 'Nights', 'StarRating', 'DisplayPromotionHome','DisplayPromotionHajiumrah', 'IsActive', 'IsPublish', 'IsMarkForDel'], ['IsActive' => 1, 'IsPublish' => 1, 'IsMarkForDel' => 0, 'ItemType' => 1]);
//print_r($resultset);die;
//$result = array();
$jsonarray = array();
foreach ($resultset as $resultkey => $resultval) {
try {
$jsonarray[$resultkey] = Zend_Json::decode($resultval['LongJsonInfo'], true);
} catch (Zend_Exception $e) {
$jsonarray[$resultkey] = "error";
}
}
//echo"<pre>";print_r($jsonarray);die;
if (count($resultset) > 0) {
foreach ($resultset as $resultkey => $resultval) {
// echo"<pre>";print_r($resultval);die('test');
$longJSON = $jsonarray[$resultkey];
if ($longJSON != 'error') {
$temp['package'] = $longJSON['package']; // get package type array
} else {
$temp['package']['Name'] = $resultval['GTXPkgId'] . " - error";
}
$result[] = [
'PkgSysId' => $resultval['PkgSysId'],
'GTXPkgId' => $resultval['GTXPkgId'],
'Destinations' => $resultval['Destinations'],
'DisplayPromotionHome' => $resultval['DisplayPromotionHome'],
'DisplayPromotionHajiumrah' => $resultval['DisplayPromotionHajiumrah'],
'lastMinuteDeal' => $resultval['lastMinuteDeal'],
'HotDeal' => $resultval['HotDeal'],
'Countries' => $resultval['Countries'],
'PkgValidUntil' => $resultval['PkgValidUntil'],
'IsActive' => $resultval['IsActive'],
'Nights' => $resultval['Nights'],
'StarRating' => $resultval['StarRating'] . ' star', // custom field
'package' => $temp['package']['Name'],
'Image' => $resultval['Image'],
];
}
// echo"<pre>";print_r($result);exit;
}
$result1 = Zend_Json::encode($result);
$newResult1 = Zend_Json::decode($result1, false);
$finalResult1["total"] = $resulsetold[0]['PkgSysId'];
$finalResult1["rows"] = $newResult1;
echo json_encode($finalResult1);
exit;
}
}
public function activemAction() {
$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 activehoAction(){
$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 destinationAction() {
//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']);
// 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 promotioncontentAction() {
//Check admin logedin or not
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchArr = array(
'Title' => $getData['Title'],
'rows' => $getData['rows'],
'page' => $getData['page'],
);
$resulsetold = $crud->getCount('tb_tbb2c_promotion_content', ['isMarkForDel' => 0], 'DesSysId');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_static('tb_tbb2c_promotion_content', ['DesSysId', 'content_heading', 'content_description','isDisplayOnHome'], ['isMarkForDel' => 0,'isPublish' =>1], ['DesSysId' => 'DESC']);
// print_r( $resultset);die;'IsPublish' => 1,
foreach ($resultset as $key => $value) {
$resultsetArr[] = [
'DesSysId' => $value['DesSysId'],
'content_heading' => $value['content_heading'],
'content_description' => $value['content_description'],
'isDisplayOnHome' => $value['isDisplayOnHome'],
'isMarkForDel' =>0,
'isPublish' =>1,
];
}
$result = Zend_Json::encode($resultsetArr);
$newResult = Zend_Json::decode($result, false);
$finalResult["total"] = $resulsetold[0]['DesSysId'];
$finalResult["rows"] = $newResult;
echo json_encode($finalResult);
exit;
}
}
public function editpromotioncontentAction() {
$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;
//-------Start Code for Approve and Publish content---------//
//if (isset($getData['save']) == "Save") {
// echo "<pre>";print_r($getData);die;
/* * ****************** Starts : destinations Image upload here **************** */
/* * ****************** End : destinations Image upload here **************** */
/* * ****************** Starts : destinations Image upload here
/* * ****************** End : destinations Image upload here **************** */
$id = $getData['DesSysId'];
$editDestinationData = [
'content_heading' => ($getData['content_heading']),
'content_description' => ($getData['content_description']),
];
$crud->rv_update('tb_tbb2c_promotion_content', $editDestinationData, ['DesSysId =?' => $id]);
$this->view->successMessage = "Promotion Content has been Updated successfully.";
$this->_helper->flashMessenger->addMessage("Destination has been updated successfully.");
$this->_redirect("/admin/promotion/promotioncontent");
}
$result = $crud->rv_select_static('tb_tbb2c_promotion_content', ['DesSysId', 'content_heading', 'content_description'], ['isMarkForDel' => 0,'isPublish' =>1,'DesSysId' => $pId ], ['DesSysId' => 'DESC']);
// $result = $crud->getCmsdata('tb_tbb2c_destinations', ['*'], ['DesSysId' => $pId], ['DesSysId' => 'DESC']);
//$result = $crud->getDestinations( ['tbl.IsMarkForDel'=>0 ,'DesSysId' => $pId ], ['tbl.DesSysId'=>'DESC'] );
$result = $result[0];
//echo "<pre>";print_r($result);die;
//$this->view->pId = $pId;
//$editdata["id"] = $result['DesSysId'];
//$editdata["title"] = $result['Title'];
//$this->view->image = $result['Image'];
//$this->view->banner_image = $result['Bannerimg'];
//$form->($editdata);
// $this->view->banner_id = @$result->banner_id;
//$this->view->editpromotioncontent = $result;
// $this->view->image = @$result->image; //$this->view->page = $page;
$this->view->getdata = $result;
}
public function addpromotioncontentAction(){
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if (isset($getData['save']) == "Save") {
$savePageData = [
'content_heading' => ($getData['content_heading']),
'content_description' => ($getData['content_description']),
'IsPublish' => 1,
'IsMarkForDel' => 0,
];
$crud->rv_insert('tb_tbb2c_promotion_content', $savePageData);
$this->view->successMessage = "Destination has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Destination has been added successfully.");
$this->_redirect("/admin/promotion/promotioncontent");
}
}
$this->view->form = $form;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
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_promotion_homebanner_detail', $updatedata, ['DesSysId =?' => $tId]);
if (!$result) {
$result_message = ['status' => false, 'message' => 'Oops33 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 deletepromotioncontentAction() {
$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_promotion_content', ['DesSysId'], ['DesSysId' => $tId], ['DesSysId' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_delete('tb_tbb2c_promotion_content', ['DesSysId =?' => $tId]);
$this->_helper->flashMessenger->addMessage("Deleted successfully.");
$this->_redirect("/admin/promotion/promotioncontent");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function promotionbannerAction() {
//Check admin logedin or not
$this->checklogin();
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$crud = new Admin_Model_CRUD();
$getData = array();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$searchArr = array(
'Title' => $getData['Title'],
'rows' => $getData['rows'],
'page' => $getData['page'],
);
$resulsetold = $crud->getCount('tb_promotion_homebanner_detail', ['isMarkForDel' => 0], 'banner_id');
$crud->searchArr = $searchArr;
$resultset = $crud->rv_select_static('tb_promotion_homebanner_detail', ['banner_id', 'image', 'heading', 'description', 'isDisplayOnHome','status'], ['isMarkForDel' => 0], ['banner_id' => 'DESC']);
foreach ($resultset as $key => $value) {
$resultsetArr[] = [
'banner_id' => $value['banner_id'],
'image' => $value['image'],
'heading' => $value['heading'],
'isDisplayOnHome' => $value['isDisplayOnHome'],
'status' => ($value['status'] == 1) ? 'Activate': 'Dectivate',
];
}
$result = Zend_Json::encode($resultsetArr);
$newResult = Zend_Json::decode($result, false);
$finalResult["total"] = $resulsetold[0]['banner_id'];
$finalResult["rows"] = $newResult;
echo json_encode($finalResult);
exit;
}
}
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 = [
'isDisplayOnHome' => $val
];
$result = $crud->rv_update('tb_promotion_homebanner_detail', $updatedata, ['banner_id =?' => $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 activecAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
$val = (int) $this->getRequest()->getParam("val");
if ($tId) {
try {
$updatedata = [
'isDisplayOnHome' => $val
];
$result = $crud->rv_update('tb_tbb2c_promotion_content', $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 addpromotionbannerAction(){
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Addpromotionbanner();
$form->setAction("admin/promotion/addpromotionbanner");
$form->setMethod("POST");
$form->setName("add_home");
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if ($form->isValid($getData)) {
if (isset($getData['save']) == "Save") {
$images = $_FILES['image']['name'];
$savePageData = [
'heading' => trim($getData['heading']),
'description' => trim($getData['description']),
'url' => trim($getData['url']),
'opt' => isset($getData['opt'][0]) ? $getData['opt'][0] : 0,
'status' => $getData['status'],
'isDisplayOnHome' => $getData['isDisplayOnHome'],
];
$banner_id = $crud->rv_insert('tb_promotion_homebanner_detail', $savePageData);
$fileName = '';
if (isset($images) && !empty($images)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
$fileExt = $this->_helper->General->getFileExtension($images);
$fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;
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->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->banner_small_image_width,$this->banner_small_image_height);
}
if($fileName != ''){
$editPageData = [
'image' => $fileName
];
$crud->rv_update('tb_promotion_homebanner_detail', $editPageData, ['banner_id =?' => $banner_id]);
}
$this->view->successMessage = "Content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Content has been added successfully.");
$this->_redirect("/admin/promotion/promotionbanner");
}
}
}
$this->view->form = $form;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function editpromotionbannerAction(){
//Check admin logedin or not
$this->checklogin();
$crud = new Admin_Model_CRUD();
$form = new Admin_Form_Editpromotionbanner();
$banner_id = (int) $this->getRequest()->getParam("id");
$form->setMethod("POST");
$form->setAction("admin/promotion/editpromotionbanner/id/" . $banner_id);
$form->setName("edit_home");
if($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
// echo"<pre>";print_r($getData);die;
// explode();
//-------Start Code for Approve and Publish content---------//
if (isset($getData['save']) == "Save") {
//Code for check page alias name already exists or not
$banner_id = (int) @$getData['banner_id'];
$images = $_FILES['image']['name'];
$fileName = '';
if (isset($images) && !empty($images)) {
$orignalFolderName = $_SERVER["DOCUMENT_ROOT"] . "/" . $this->imageUrlHome . $banner_id;
$fileExt = $this->_helper->General->getFileExtension($images);
$fileName = $banner_id . '_' . $this->current_time . '.' . $fileExt;
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->banner_large_image_width,$this->banner_large_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalMediumFolder,$fileName,$this->banner_medium_image_width,$this->banner_medium_image_height);
Catabatic_Helper::resizeImages($orignalFolderName,$originalSmallFolder,$fileName,$this->banner_small_image_width,$this->banner_small_image_height);
}
$editPageData = [
'heading' => trim($getData['heading']),
'description' => trim($getData['description']),
'url' => trim($getData['url']),
'opt' => isset($getData['opt'][0]) ? $getData['opt'][0] : 0,
'status' => $getData['status'],
'isDisplayOnHome' => $getData['isDisplayOnHome'],
];
if ($fileName != "") {
$editPageData['image'] = $fileName;
}
$crud->rv_update('tb_promotion_homebanner_detail', $editPageData, ['banner_id =?' => $banner_id]);
$this->view->successMessage = "Page content has been saved successfully.";
$this->_helper->flashMessenger->addMessage("Page content has been updated successfully.");
$this->_redirect("/admin/promotion/promotionbanner");
}
}
$result = $crud->getCmsdata('tb_promotion_homebanner_detail', ['*'], ['banner_id' => $banner_id], ['banner_id' => 'DESC']);
$editdata["banner_id"] = @$result->banner_id;
$editdata["heading"] = @$result->heading;
$editdata["description"] = @$result->description;
$editdata["url"] = @$result->url;
$editdata["opt"] = @$result->opt;
$editdata["status"] = @$result->status;
$editdata["isDisplayOnHome"] = @$result->isDisplayOnHome;
$editdata["image"] = @$result->image;
$form->populate($editdata);
$this->view->banner_id = @$result->banner_id;
$this->view->form = $form;
$this->view->image = @$result->image;
}
public function deletepromotionbannerAction() {
$this->checklogin();
$crud = new Admin_Model_CRUD();
$tId = (int) $this->getRequest()->getParam("id");
if ($tId) {
$checkdata = $crud->rv_select_row('tb_promotion_homebanner_detail', ['banner_id'], ['banner_id' => $tId], ['banner_id' => 'asc']);
if (count($checkdata) > 0) {
$crud->rv_delete('tb_promotion_homebanner_detail', ['banner_id =?' => $tId]);
$this->_helper->flashMessenger->addMessage("Delete successfully.");
$this->_redirect("/admin/promotion/promotionbanner");
} else {
die('Oops some thing wrong!!.');
}
}
}
public function sanitize_data($string) {
$searchArr = array("iframe", "script", "document", "write", "alert", "%", "@", "$", ";", "+", "|", "#", "<", ">", ")", "(", "'", "\'", ",", "and ", " &", "& ", "and", " and", "0", "1", "2", "3", "4", "5", "6", "7", "8", "9");
$input_data = strtolower($string);
$input_data = str_replace($searchArr, "", $input_data);
$input_data = str_replace(" ", "-", $input_data);
//echo $input_data; die;
return $input_data;
}
/**
* 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');
}
}
}