| 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
/* * ***************
* Zend Framework
* @category Zend
* @package Zend_Controller_Action
* @copyright Copyright (c) 2008-2014 Zend Technologies USA Inc. (http://www.zend.com)
* @license http://framework.zend.com/license/new-bsd New BSD License
* @version $Id: DbTable.php 8862 2012-03-16 15:36:00Z thomas $
* @author Shobhit Srivastav(shobhit833@gmail.com).
* Create Date 27-07-2016
* Update Date 27-07-2016
* CustomerControoler (It will allow users to add different masters)
* *** */
class OperationController extends Catabatic_ValidateGtx {
private $intLoggedinUserId;
private $intLoggedinUserGroupSysId;
private $intLoggedinUserAgencySysId;
private $intLoggedinUserTrxCurrency;
public $baseUrl;
public function init() {
parent::init();
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
#get session variable
$this->intLoggedinUserId = $sessionLogin_user->intLoggedinUserId;
$this->intLoggedinUserGroupSysId = $sessionLogin_user->intLoggedinUserGroupSysId;
$this->intLoggedinUserAgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$this->intLoggedinUserTrxCurrency = $sessionLogin_user->intLoggedinUserTrxCurrency;
$this->_crmcustomerObj = new Travel_Model_CRM_Customer();
$this->_crmcusttravelplan = new Travel_Model_CRM_CustomerTravelPlan();
$this->_crmcusttravelplanAir = new Travel_Model_CRM_CustomerTravelPlanAir();
$this->_crmcusttravelplanHotel = new Travel_Model_CRM_CustomerTravelPlanHotel();
$this->_crmcustomertravelItenary = new Travel_Model_CRM_CustomerTravelItenary();
$this->_crmremarkObj = new Travel_Model_CRM_Remark();
$this->_searchhotelObj = new Travel_Model_TblHotel();
$this->_objAirport = new Travel_Model_TblAirport();
############## For HTML Purifer ####################
$this->_HtmlPurifier = new Zend_Filter_HtmlPurifier();
}
public function indexAction() {
}
//get iteration query listing created on 02 may 2018 at 11:25 AM
public function proposalRequiredAction() {
//echo "<pre>";print_r($_SESSION);die;
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
$AgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$AgentSysId = $sessionLogin_user->intLoggedinUserId;
$ReportingToSysId = $sessionLogin_user->ReportingToSysId;
$this->_crmcusttravelplan = new Travel_Model_CRM_CustomerTravelPlan();
$type = $this->getRequest()->getParam('type');
$leadFilter = $this->getRequest()->getParam('filter');
$orderBy = $this->_HtmlPurifier->filter($this->getRequest()->getParam('order'));
$getData = array();
if ($this->getRequest()->getPost()) {
$getData = $this->getRequest()->getPost();
$getData['POST'] = 1;
$getData = $this->_HtmlPurifier->filterArray($getData);
}
if (isset($type) && !empty($type)) {
$getData['leadType_' . $type] = $type;
}
$orderDetails = '';
$columnNameOrder = 'tb1.UpdateDate';
if (isset($orderBy) && !empty($orderBy)) {
$this->view->order = $orderBy;
$order_type = explode('_', $orderBy);
if ($order_type[0] == 'queryDate' && $order_type[1] == 0) {
$columnNameOrder = 'tb1.UpdateDate';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'queryDate' && $order_type[1] == 1) {
$columnNameOrder = 'tb1.UpdateDate';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'owner' && $order_type[1] == 1) {
$columnNameOrder = 'tb4.FirstName';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'owner' && $order_type[1] == 0) {
$columnNameOrder = 'tb4.FirstName';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'customername' && $order_type[1] == 1) {
$columnNameOrder = 'tb2.FirstName';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'customername' && $order_type[1] == 0) {
$columnNameOrder = 'tb2.FirstName';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'leadsource' && $order_type[1] == 1) {
$columnNameOrder = 'tb3.Title';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'leadsource' && $order_type[1] == 0) {
$columnNameOrder = 'tb3.Title';
$orderQueryDate = 'DESC';
} else {
$orderQueryDate = 'DESC';
}
$orderDetails = $columnNameOrder . " " . $orderQueryDate . "";
}
//echo "<pre>";print_r($getData);die;
$getData['order'] = isset($orderDetails) ? $orderDetails : '';
if (isset($getData['assigUnassignFilter']) && ($getData['assigUnassignFilter'] == 1)) {
$getData['UserSysId'] = $getData['agencyUserFilter'];
} else if (isset($getData['assigUnassignFilter']) && ($getData['assigUnassignFilter'] == 2)) {
$getData['UserSysId'] = 0;
} else {
$getData['UserSysId'] = 0;
}
$this->view->searchData = $getData;
$this->view->filterFormDisplay = $this->getRequest()->getPost();
$LeadListArr = array();
$getCustomerList = array();
$roleID = $sessionLogin_user->UserRole;
$this->_agencyuserroleObj = new Travel_Model_TblAgencyUserRole();
$getRoleDetail = $this->_agencyuserroleObj->getDataByRole($roleID);
$uid = $this->getRequest()->getParam('uid');
if (isset($type) && isset($uid) && !empty($type) && !empty($uid)) {
$type = $this->_HtmlPurifier->filter($type);
$uid = $this->_HtmlPurifier->filter(base64_decode($uid));
if ($uid == $sessionLogin_user->intLoggedinUserId) {
$where = "UserSysId = " . $uid . " AND MsgType = 3 AND ModuleType = 1";
$date = date('Y-m-d H:i:s');
$userArray = array(
'IsMarkForDel' => '1',
'Accepted' => '1',
'IsActive' => '0',
'UpdateDate' => $date,
);
$this->_agencyuserObj = new Travel_Model_CRM_AgencyUserInbox();
$updatedUserInbox = $this->_agencyuserObj->updateNotification($userArray, $where);
}
}
//print_r($getData);die;
//echo "<pre>";print_r($getData);die;
$this->_crmcusttravelplan->ReportingToSysId = $ReportingToSysId;
if ($getRoleDetail['IsAdmin'] == true) {
$LeadListArr = $this->_crmcusttravelplan->GetAgencyOperationalQuery($AgencySysId, '', @$getData);
} else {
$LeadListArr = $this->_crmcusttravelplan->GetAgencyOperationalQuery($AgencySysId, $AgentSysId, @$getData);
}
$i = 0;
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($LeadListArr));
$pageNumber = $this->_getParam('page', 1);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$this->_leadstageObj = new Travel_Model_TblLeadStage();
$crmtravelplanstatusObj = new Travel_Model_CRM_TravelPlanStatus();
$getStageList = $crmtravelplanstatusObj->GetTravelPlanStatusByType(3);
if ($getRoleDetail['IsAdmin'] == true) {
$agencyUser = $this->_crmcustomerObj->getAllAgencyUserList('', $AgencySysId);
} else {
$agencyUser = $this->_crmcustomerObj->getAllAgencyUserList('', $AgencySysId, $ReportingToSysId);
}
$this->view->paginator = $paginator;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$ARR_SALUTION = unserialize(ARR_SALUTION);
$ARR_CUSTOMER_RELATION = unserialize(ARR_CUSTOMER_RELATION);
$this->view->ARR_CUSTOMER_RELATION = $ARR_CUSTOMER_RELATION;
$this->view->ARR_SALUTION = $ARR_SALUTION;
$this->view->leadStageList = $getStageList;
$this->view->agencyUser = $agencyUser;
$this->view->getRoleDetail = $getRoleDetail;
$this->view->getData = $getData;
$this->view->countLead = count($getCustomerList);
$this->view->countQuery = $paginator->getTotalItemCount();
$this->view->ReportingToSysId = $ReportingToSysId;
}
public function packageRequiredAction() {
//echo "<pre>";print_r($_SESSION);die;
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
$AgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$AgentSysId = $sessionLogin_user->intLoggedinUserId;
$ReportingToSysId = $sessionLogin_user->ReportingToSysId;
$this->_crmcusttravelplan = new Travel_Model_CRM_CustomerTravelPlan();
$type = $this->getRequest()->getParam('type');
$leadFilter = $this->getRequest()->getParam('filter');
$orderBy = $this->_HtmlPurifier->filter($this->getRequest()->getParam('order'));
$planType = ''; // 5-for package
$getData = array();
if ($this->getRequest()->getPost()) {
$getData = $this->getRequest()->getPost();
$getData['POST'] = 1;
$getData = $this->_HtmlPurifier->filterArray($getData);
}
if (isset($type) && !empty($type)) {
$getData['leadType_' . $type] = $type;
}
$orderDetails = '';
$columnNameOrder = 'tb1.UpdateDate';
if (isset($orderBy) && !empty($orderBy)) {
$this->view->order = $orderBy;
$order_type = explode('_', $orderBy);
if ($order_type[0] == 'queryDate' && $order_type[1] == 0) {
$columnNameOrder = 'tb1.UpdateDate';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'queryDate' && $order_type[1] == 1) {
$columnNameOrder = 'tb1.UpdateDate';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'owner' && $order_type[1] == 1) {
$columnNameOrder = 'tb4.FirstName';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'owner' && $order_type[1] == 0) {
$columnNameOrder = 'tb4.FirstName';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'customername' && $order_type[1] == 1) {
$columnNameOrder = 'tb2.FirstName';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'customername' && $order_type[1] == 0) {
$columnNameOrder = 'tb2.FirstName';
$orderQueryDate = 'DESC';
} else if ($order_type[0] == 'leadsource' && $order_type[1] == 1) {
$columnNameOrder = 'tb3.Title';
$orderQueryDate = 'ASC';
} else if ($order_type[0] == 'leadsource' && $order_type[1] == 0) {
$columnNameOrder = 'tb3.Title';
$orderQueryDate = 'DESC';
} else {
$orderQueryDate = 'DESC';
}
$orderDetails = $columnNameOrder . " " . $orderQueryDate . "";
}
//echo "<pre>";print_r($getData);die;
$getData['order'] = isset($orderDetails) ? $orderDetails : '';
if (isset($getData['assigUnassignFilter']) && ($getData['assigUnassignFilter'] == 1)) {
$getData['UserSysId'] = $getData['agencyUserFilter'];
} else if (isset($getData['assigUnassignFilter']) && ($getData['assigUnassignFilter'] == 2)) {
$getData['UserSysId'] = 0;
} else {
$getData['UserSysId'] = 0;
}
$this->view->searchData = $getData;
$this->view->filterFormDisplay = $this->getRequest()->getPost();
$LeadListArr = array();
$getCustomerList = array();
$roleID = $sessionLogin_user->UserRole;
$this->_agencyuserroleObj = new Travel_Model_TblAgencyUserRole();
$getRoleDetail = $this->_agencyuserroleObj->getDataByRole($roleID);
$uid = $this->getRequest()->getParam('uid');
if (isset($type) && isset($uid) && !empty($type) && !empty($uid)) {
$type = $this->_HtmlPurifier->filter($type);
$uid = $this->_HtmlPurifier->filter(base64_decode($uid));
if ($uid == $sessionLogin_user->intLoggedinUserId) {
$where = "UserSysId = " . $uid . " AND MsgType = 3 AND ModuleType = 1";
$date = date('Y-m-d H:i:s');
$userArray = array(
'IsMarkForDel' => '1',
'Accepted' => '1',
'IsActive' => '0',
'UpdateDate' => $date,
);
$this->_agencyuserObj = new Travel_Model_CRM_AgencyUserInbox();
$updatedUserInbox = $this->_agencyuserObj->updateNotification($userArray, $where);
}
}
//print_r($getData);die;
//echo "<pre>";print_r($getData);die;
$this->_crmcusttravelplan->ReportingToSysId = $ReportingToSysId;
if ($getRoleDetail['IsAdmin'] == true) {
$LeadListArr = $this->_crmcusttravelplan->GetAgencyOperationalQuery($AgencySysId, '', @$getData, '', $planType);
} else {
$LeadListArr = $this->_crmcusttravelplan->GetAgencyOperationalQuery($AgencySysId, $AgentSysId, @$getData, '', $planType);
}
$i = 0;
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($LeadListArr));
$pageNumber = $this->_getParam('page', 1);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$this->_leadstageObj = new Travel_Model_TblLeadStage();
$crmtravelplanstatusObj = new Travel_Model_CRM_TravelPlanStatus();
$getStageList = $crmtravelplanstatusObj->GetTravelPlanStatusByType(3);
if ($getRoleDetail['IsAdmin'] == true) {
$agencyUser = $this->_crmcustomerObj->getAllAgencyUserList('', $AgencySysId);
} else {
$agencyUser = $this->_crmcustomerObj->getAllAgencyUserList('', $AgencySysId, $ReportingToSysId);
}
$this->view->paginator = $paginator;
$this->view->messages = $this->_helper->flashMessenger->getMessages();
$ARR_SALUTION = unserialize(ARR_SALUTION);
$ARR_CUSTOMER_RELATION = unserialize(ARR_CUSTOMER_RELATION);
$this->view->ARR_CUSTOMER_RELATION = $ARR_CUSTOMER_RELATION;
$this->view->ARR_SALUTION = $ARR_SALUTION;
$this->view->leadStageList = $getStageList;
$this->view->agencyUser = $agencyUser;
$this->view->getRoleDetail = $getRoleDetail;
$this->view->getData = $getData;
$this->view->countLead = count($getCustomerList);
$this->view->countQuery = $paginator->getTotalItemCount();
$this->view->ReportingToSysId = $ReportingToSysId;
}
public function updateTravelplanForOperationalAction() {
$this->view->layout()->disableLayout();
$this->_helper->viewRenderer->setNoRender(true);
$sessionLogin_user = new Zend_Session_Namespace('sessionLogin_user');
$AgencySysId = $sessionLogin_user->intLoggedinUserAgencySysId;
$AgentSysId = $sessionLogin_user->intLoggedinUserId;
$ReportingToSysId = $sessionLogin_user->ReportingToSysId;
$TPSysId = $this->_HtmlPurifier->filter(base64_decode($this->getRequest()->getParam('TPSysId')));
$this->_crmcusttravelplan = new Travel_Model_CRM_CustomerTravelPlan();
if (isset($TPSysId) && !empty($TPSysId) && is_numeric($TPSysId) > 0) {
$where = "TPSysId = " . $TPSysId . " AND AgencySysId=" . $AgencySysId . "";
$date = date('Y-m-d H:i:s');
$userArray = array(
'IsOperationalLead' => 1,
'UpdateDate' => date('Y-m-d H:i:s'),
);
$updateLeadRcord = $this->_crmcusttravelplan->UpdateCustomerTravelPlan($userArray, $where);
$status = 'success';
} else {
$status = 'failed';
}
echo json_encode(array('status' => $status, 'id' => $TPSysId));
exit;
}
public function iterationRequiredAction() {
$CustomerSysId = $this->_HtmlPurifier->filter(base64_decode($this->getRequest()->getParam('cid')));
$MasterTPSysId = $this->_HtmlPurifier->filter(base64_decode($this->getRequest()->getParam('mid')));
$crmcustomerObj = new Travel_Model_CRM_Customer();
$arrCustomerTODOHistory = $crmcustomerObj->GetAllIterationOperation($CustomerSysId, $MasterTPSysId);
$paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($arrCustomerTODOHistory));
$pageNumber = $this->_getParam('page', 1);
$paginator->setCurrentPageNumber($pageNumber);
$paginator->setItemCountPerPage(GRID_PER_PAGE_RECORD_COUNT);
$this->view->paginator = $paginator;
}
}