| 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/b2bzend/application/controllers/ |
Upload File : |
<?php
/*
* Catabatic Technology Pvt. Ltd.
* File Name :SettingsController.php
* File Description :Settings controller managed settings of agency
* Created By : Pooja Choudhary
* Created Date: 21-July-2016
*/
class SettingsController extends Catabatic_ValidateGtx {
public function init() {
parent::init();
$aConfig = $this->getInvokeArg('bootstrap')->getOptions();
$this->siteUrl = $aConfig['bootstrap']['siteUrl'];
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
$this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
$this->UserRole = $sessionLogin_user->UserRole;
$this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
// echo '<pre>'; print_r($_SESSION);
//set layout
// $this->_helper->layout->setLayout('layout-signup');
//$this->_helper->layout->disableLayout();
$this->objAgency = new Travel_Model_TblAgency();
}
/*
* markupSettingAction(); is used to set markup's for agency
* Created By- Pooja
* Created on- 21 July 2016
*/
public function markupSettingAction() {
if (empty($this->intLoggedinUserAgencySysId)) {
$this->_helper->redirector('login', 'login');
}
$objAirline = new Travel_Model_TblAirline();
//Get Airline List
// $arrAirlineList = $objAirline->getAirlineList();
// echo '<pre>'; print_r($arrAirlineList);
// $this->view->arrAirlineList = ($arrAirlineList);
$this->view->arrMarketPlaces = Zend_Controller_Action_HelperBroker::getStaticHelper('B2B')->getMarketPlaces();
}
public function saveMarkupSettingAction() {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
if ($this->getRequest()->isXmlHttpRequest()) {
$objHotel = new Travel_Model_TblHotel();
$objAgency = new Travel_Model_TblAgency();
$getData = $this->getRequest()->getParams();
$dateTime = date('Y-m-d H:i:s');
$AgencySysId = $_SESSION['sessionLogin_user']['intLoggedinUserAgencySysId'];
// update currency id in agency table
$updateAgencyData = array('TrxCurrency' => $getData['AgencyBaseCurrency']);
$objAgency->updateAgencyData($updateAgencyData, $AgencySysId);
//insert/update agency markups
$insertData = array();
foreach ($getData['hoteldeals'] as $key => $InventoryHoteldeals) {
if (!empty($InventoryHoteldeals['markup'])) {
$insertData['AgencySysId'] = $AgencySysId;
$insertData['Currency'] = $getData['AgencyBaseCurrency'];
$insertData['MPType'] = $InventoryHoteldeals['mptype'];
$insertData['MarkUpType'] = $InventoryHoteldeals['markuptype'];
$insertData['MarkUp'] = $InventoryHoteldeals['markup'];
$insertData['IsSameForAll'] = 0;
$insertData['CustGrSysId'] = 0;
$insertData['DOccupMarkUp'] = $InventoryHoteldeals['markup'];
$insertData['SOccupMarkUp'] = $InventoryHoteldeals['markup'];
$insertData['ExtraBedMarkUp'] = $InventoryHoteldeals['markup'];
$insertData['ExtraWOBedMarkUp'] = $InventoryHoteldeals['markup'];
$insertData['Tax'] = 0;
$insertData['PerPaxMarkUp'] = 0;
$insertData['ValidTill'] = 0;
$insertData['ApproveDate'] = $dateTime;
$insertData['IsApproved'] = 0;
$insertData['CreateDate'] = $dateTime;
$insertData['UpdateDate'] = $dateTime;
$insertData['IsMarkForDel'] = 0;
$insertData['IsActive'] = 1;
$objHotel->addStdMarkupAccom($insertData);
// $finalArray[] = "($AgencySysId, ".$InventoryHoteldeals['mptype'].",1, ".$getData['AgencyBaseCurrency'].", ".$InventoryHoteldeals['markuptype'].",0, "
// . "".$InventoryHoteldeals['markup'].", ".$InventoryHoteldeals['markup'].", ".$InventoryHoteldeals['markup'].", ".$InventoryHoteldeals['markup'].", ".$InventoryHoteldeals['markup'].", 0, 0, '".$dateTime."', '".$dateTime."', '".$dateTime."', '".$dateTime."',0, 0,1)";
//
}
}
// $values = implode(',', $finalArray);
//echo $insertQuery = "INSERT INTO TB_MP_StdMarkup_Accom values $values";
// print_r($objHotel->addStdMarkupAccom(array($finalArray[0],$finalArray[0])));
}
}
public function changePasswordAction() {
// if(empty($sessionLogin_user->intLoggedinUserAgencySysId)) {
// $this->_helper->redirector('login', 'login');
// }
}
public function ispasswordExistsAction() {
$objUser = new Travel_Model_TblUser();
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$userId = $this->intLoggedinUserId;
$UserRole = $this->UserRole;
$oldPass = md5($this->getRequest()->getParam('oldPassword'));
if ($objUser->ispasswordExists($oldPass, $UserRole, $userId)) {
echo json_encode(true);
} else {
echo json_encode(false);
}
}
public function saveChangePasswordAction() {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
if ($this->getRequest()->isXmlHttpRequest()) {
$getData = $this->getRequest()->getParams();
// echo '<pre>'; print_r($getData); die;
$oldPassword = md5($getData['oldPassword']);
$newPassword = $getData['newPassword'];
$cPassword = $getData['confPassword'];
$userId = $this->intLoggedinUserId;
$UserRole = $this->UserRole;
$objUser = new Travel_Model_TblUser();
$result = $objUser->getUserDetails($UserRole, $userId);
// print_r($result[0]['Password']);
if ($oldPassword != $result[0]['Password']) {
//return "Old password does not match";
echo 1;
exit;
}
if ($newPassword != $cPassword) {
//return "New password & confirm new password did not match.";
echo 2;
exit;
}
$objUser->updateChangePassword($UserRole, $userId, $newPassword);
//return "Password has been changed successfully.";
echo 3;
exit;
}
}
public function addTncAction() {
$agencySysId = $this->intLoggedinUserAgencySysId;
$objAgency = new Travel_Model_TblAgency();
$currentDate = date('Y-m-d H:i:s');
if ($this->getRequest()->isPost()) {
$agencyTncList = $objAgency->getAgencyTnCDetails($agencySysId);
$post = $this->getRequest()->getPost();
$data = array(
'TermsAndConditions' => trim($this->sanitize_data_html($this->getRequest()->getParam('TermsAndConditionsDomestic'))),
'CancellationPolicy' => trim($this->sanitize_data_html($this->getRequest()->getParam('CancellationPolicyDomestic'))),
'TermsAndConditionsInternational' => trim($this->sanitize_data_html($this->getRequest()->getParam('TermsAndConditionsInternational'))),
'CancellationPolicyInternational' => trim($this->sanitize_data_html($this->getRequest()->getParam('CancellationPolicyInternational'))),
'InclusionsInternational' => trim($this->sanitize_data_html($this->getRequest()->getParam('InclusionPolicyInternational'))),
// 'InclusionsDomestic' => trim($this->sanitize_data_html($this->getRequest()->getParam('InclusionPolicyDomestic'))),
// 'ExclusionDomestic' => trim($this->sanitize_data_html($this->getRequest()->getParam('ExclusionPolicyDomestic'))),
'Inclusions' => trim($this->sanitize_data_html($this->getRequest()->getParam('InclusionPolicyDomestic'))),
'Exclusions' => trim($this->sanitize_data_html($this->getRequest()->getParam('ExclusionPolicyDomestic'))),
'ExclusionInternational' => trim($this->sanitize_data_html($this->getRequest()->getParam('ExclusionPolicyInternational'))),
'TravelBasics' => trim($this->sanitize_data_html($this->getRequest()->getParam('TravelBasics'))),
'BookingTerms' => trim($this->sanitize_data_html($this->getRequest()->getParam('BookingTerms'))),
'WhyUseUs' => trim($this->sanitize_data_html($this->getRequest()->getParam('WhyUseUs'))),
'Payment' => trim($this->sanitize_data_html($this->getRequest()->getParam('Payment'))),
'PaymentDetails' => trim($this->getRequest()->getParam('PaymentDetails')),
'UpdateDate' => $currentDate,
);
if (count($agencyTncList) == 0) {
$data['AgencySysId'] = $agencySysId;
$data['CreateDate'] = $currentDate;
$data['IsActive'] = 1;
$data['IsMarkForDel'] = 0;
// print_r($data);
$tncId = $objAgency->insertData('TB_Agency_Terms_Conditions', $data);
$this->view->SuccessMessage = "Tnc Details added successfully.";
} else {
//
$where = array('TncId = ? ' => $agencyTncList['TncId']);
$updateId = $objAgency->updateData('TB_Agency_Terms_Conditions', $data, $where);
$this->view->SuccessMessage = "Tnc Details updated successfully.";
}
}
$agencyTncList = $objAgency->getAgencyTnCDetails($agencySysId);
// echo"<pre>";print_r($agencyTncList);die;
$this->view->agencyTncList = $agencyTncList;
}
//Added By Pardeep Panchal on 27/09/2017
public function emailTemplatesAction() {
$this->objAgency->intAgencySysId = $this->intLoggedinUserAgencySysId;
$arrEmailTemplateList = $this->objAgency->getEmailTemplateList();
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($arrEmailTemplateList);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function addEmailTemplateAction() {
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
if (!$this->objAgency->isEmailTemplateExists(trim($getData['TemplateName']),"")) {
// $date = new Zend_Date();
$currentDate = date('Y-m-d H:i:s');
$TemplateName = trim($this->sanitize_data($getData['TemplateName']));
$Subject = trim($this->sanitize_data($getData['Subject']));
$MessageBody = str_replace("'","''",trim($getData['MessageBody']));
$data = array(
'TemplateName' => $TemplateName,
'Subject' => $Subject,
'MessageBody' => $MessageBody,
'CreateDate' => $currentDate,
'AgentSysId' => $this->intLoggedinUserId,
'AgencySysId' => $this->intLoggedinUserAgencySysId,
'IsMarkForDel' => 0,
'IsActive' => $getData['status']
);
//Insert
$result = $this->objAgency->addEmailTemplate($data);
$this->_helper->flashMessenger->addMessage("Email Template added successfully.");
$this->_redirect("/settings/email-templates");
} else{
$this->view->message = 'Email Template already exists.';
}
}
}
public function editEmailTemplateAction() {
$intId = base64_decode($this->getRequest()->getParam('id'));
$this->objAgency->intAgencySysId = $this->intLoggedinUserAgencySysId;
$this->objAgency->intId = $intId;
$this->view->emailTemplateData = $this->objAgency->getEmailTemplateList();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
// $date = new Zend_Date();
$updateDate = date('Y-m-d H:i:s');
$TemplateName = trim($this->sanitize_data($getData['TemplateName']));
$Subject = trim($this->sanitize_data($getData['Subject']));
$MessageBody = trim($this->sanitize_data_html($getData['MessageBody']));
$intId = base64_decode($getData['Id']);
if (!$this->objAgency->isEmailTemplateExists($TemplateName, $intId)) {
$data = array(
'TemplateName' => $TemplateName,
'Subject' => $Subject,
'MessageBody' => $MessageBody,
//'CreateDate' => $updateDate,
'AgentSysId' => $this->intLoggedinUserId,
'AgencySysId' => $this->intLoggedinUserAgencySysId,
'IsActive' => $getData['status']
);
//update
$response = $this->objAgency->updateEmailTemplate($intId,$data);
$this->_helper->flashMessenger->addMessage("Email Template updated successfully.");
$this->_redirect("/settings/email-templates");
} else {
$this->view->message = 'Email Template already exists.';
}
}
}
public function deleteRecordAction(){
// disable layout...
$this->_helper->layout->disableLayout();
$intId = base64_decode($this->getRequest()->getParam('id'));
$data = array(
"IsMarkForDel" => 1
);
$this->objAgency->deleteEmailTemplate($intId,$data);
$this->_helper->flashMessenger->addMessage("Email Template deleted successfully.");
$this->_redirect("/settings/email-templates");
}
//Added By Pardeep Panchal on 27/09/2017
public function agencyMarketPlaceAction() {
$this->objAgency->intAgencySysId = $this->intLoggedinUserAgencySysId;
$arrAgenctMarketPlaceList = $this->objAgency->getAgencyMarketPlaceList('',$this->intLoggedinUserAgencySysId);
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($arrAgenctMarketPlaceList);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
}
public function addAgencyMarketPlaceAction() {
$intId =(NULL != $this->getRequest()->getParam('id'))? base64_decode($this->getRequest()->getParam('id')):'';
$marketPlaceDetails='';
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
// if (!$this->objAgency->getAgencyMarketPlaceList(1,trim($this->intLoggedinUserAgencySysId))) {
if ($getData) {
// $date = new Zend_Date();
$currentDate = date('Y-m-d H:i:s');
$Title = trim($getData['title']);
$markupType = trim($getData['markType']);
$markupValue = trim($getData['markupValue']);
$AgencySysId = $this->intLoggedinUserAgencySysId;
if($intId==''){
$data = array(
'AgencySysId' => $AgencySysId,
'Title' => $Title,
'MarkUpType' => $markupType,
'MarkUpValue' => $markupValue,
'UpdateDate' => $currentDate,
'CreateDate' => $currentDate,
'IsActive' => $getData['status'],
'IsMarkForDelete' => 0,
);
//Insert
$result = $this->objAgency->addAgencyMarkUp($data);
$this->_helper->flashMessenger->addMessage("MarkUp added successfully.");
}else{
$data = array(
'Title' => $Title,
'MarkUpType' => $markupType,
'MarkUpValue' => $markupValue,
'UpdateDate' => $currentDate,
'IsActive' => $getData['status'],
);
$where="MarketPlaceSysId=".$intId."";
//Insert
$result = $this->objAgency->updateAgencyMarkUp($data,$where);
$this->_helper->flashMessenger->addMessage("MarkUp updated successfully.");
}
$this->_redirect("/settings/agency-market-place");
} else{
$this->view->message = 'MarkUp already exists for this agency.';
}
}
if($intId!=''){
$marketPlaceDetails=$this->objAgency->getAgencyMarketPlaceList('',trim($this->intLoggedinUserAgencySysId),$intId);
$this->view->marketPlaceDetails=$marketPlaceDetails;
}
}
public function agencyMarkupExistsAction() {
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$emailId = $this->getRequest()->getParam('emailId');
$AgencySysId = $this->getRequest()->getParam('aId');
if ($this->objAgency->getAgencyMarketPlaceList(1,$AgencySysId)) {
echo json_encode(false);
} else {
echo json_encode(true);
}
}
public function leadSourceAction() {
$AgencySysId = $this->intLoggedinUserAgencySysId;
$arrAgenctMarketPlaceList = $this->objAgency->getLeadSource($AgencySysId);
$page = $this->_getParam('page', 1);
$paginator = Zend_Paginator::factory($arrAgenctMarketPlaceList);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$paginator->setCurrentPageNumber($page);
$this->view->paginator = $paginator;
$this->view->perPageRecord = GRID_PER_PAGE_RECORD_COUNT;
$this->view->page = $page;
}
public function addLeadSourceAction() {
$AgencySysId = $this->intLoggedinUserAgencySysId;
$objAgency = new Travel_Model_TblAgency();
if ($this->getRequest()->isPost()) {
$getData = $this->getRequest()->getPost();
$adddata = array(
'AgencySysId'=>$AgencySysId,
'Title'=>$getData['leadsourceName'],
'IsActive'=>$getData['status']
);
$leadId = $objAgency->insertData('TB_Master_LeadSource', $adddata);
$this->_redirect("/settings/lead-source");
}
}
public function deleteLeadSourceAction() {
$this->_helper->layout->disableLayout();
$AgencySysId = $this->intLoggedinUserAgencySysId;
$objAgency = new Travel_Model_TblAgency();
$LeadSourceSysId = base64_decode($this->getRequest()->getParam('id'));
$updateData = array('IsMarkForDel'=>1);
$where = array('LeadSourceSysId = ? ' => $LeadSourceSysId);
$updateId = $objAgency->updateData('TB_Master_LeadSource', $updateData, $where);
$this->_redirect("/settings/lead-source");
}
public function changeLeadSourceStatusAction() {
$this->_helper->layout->disableLayout();
$AgencySysId = $this->intLoggedinUserAgencySysId;
$objAgency = new Travel_Model_TblAgency();
if ($this->getRequest()->isPost()) {
$post = $this->getRequest()->getPost();
// echo "<pre>";print_r($post);die;
$LeadSourceSysId = $post['LeadSourceSysId'];
$status = $post['status'];
if($status == 1){
$updateData = array('IsActive'=>0);
}else{
$updateData = array('IsActive'=>1);
}
$where = array('LeadSourceSysId = ? ' => $LeadSourceSysId);
$updateId = $objAgency->updateData('TB_Master_LeadSource', $updateData, $where);
echo json_encode(array('status'=>true,'LeadSourceSysId'=>$LeadSourceSysId));exit;
}
}
}