| 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
class EnquiryController extends Zend_Controller_Action {
public function init() {
$this->_crmcustomerObj = new Travel_Model_CRM_Customer();
$this->_crmcusttravelplan = new Travel_Model_CRM_CustomerTravelPlan();
$this->_crmcusttravelplanItenaryAccom = new Travel_Model_CRM_CustomerTravelPlanAccom();
$this->_crmcustomertravelItenaryEvents = new Travel_Model_CRM_CustomerTravelItenaryEvents();
$this->_crmcustomertravelItenaryPlaces = new Travel_Model_CRM_CustomerTravelItenaryPlaces();
$this->_crmcustomertravelMarketPlaces = new Travel_Model_CRM_CustomerTravelItenaryMarketRate();
$this->_crmcustomertravelSightSeeing = new Travel_Model_CRM_CustomerTravelItenarySightSeeing();
$this->_crmcustomertravelTransport = new Travel_Model_CRM_CustomerTravelTransport();
$this->_crmcustomertravelTerm = new Travel_Model_CRM_CustomerTravelTerm();
$this->_agencycustomerObj = new Travel_Model_CRM_AgencyCustomer();
$this->_customermemberObj = new Travel_Model_CRM_CustomerMember();
$this->_crmcustomertravelItenary = new Travel_Model_CRM_CustomerTravelItenary();
$aConfig = $this->getInvokeArg('bootstrap')->getOptions();
$this->smtpUserName = $aConfig['smtpUserName'];
$this->smtpPassword = $aConfig['smtpPassword'];
$this->smtpPort = $aConfig['smtpPort'];
$this->smtpHost = $aConfig['smtpHost'];
$this->fromEmail = $aConfig['fromEmail'];
$this->fromName = $aConfig['fromName'];
}
public function createAgencyCustomerAndNewleadAction() {
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$strName = $this->getRequest()->getParam('name');
$strMobile = $this->getRequest()->getParam('mobile');
$objAgency = new Travel_Model_TblAgencyEnquiry();
$intAgencyCustomer = $objAgency->checkIfAgencyCustomerExists($strMobile);
if ($intAgencyCustomer == 0) {
$currentDate = date('Y-m-d H:i:s');
$dataCrm = array();
$dataCrm['EmailId'] = '';
$dataCrm['AgencySysId'] = '3';
$dataCrm['LeadSourceSysId'] = '1';
$dataCrm['Salutation'] = '1';
$dataCrm['PrimaryContactNumber'] = $strMobile;
$dataCrm['FullName'] = $strName;
$dataCrm['FirstName'] = $strName;
$dataCrm['LastName'] = '';
$dataCrm['ActiveDate'] = $currentDate;
$dataCrm['IsApproved'] = '0';
$dataCrm['IsActive'] = '1';
$dataCrm['IsMarkForDelete'] = '0';
$dataCrm['UpdatedDate'] = $currentDate;
$dataCrm['CreatedDate'] = $currentDate;
$intCrmCustomerId = $objAgency->createCrmCustomerAccount($dataCrm);
if (!empty($intCrmCustomerId)) {
$arrAgencyCustomer = array(
'AgencySysId' => '3',
'CRMCustSysId' => $intCrmCustomerId,
'EmailId' => '', 'Title' => '1',
'Logo' => '', 'IsfromSM' => '0',
'SMTypeId' => '0', 'SMId' => '',
'UserId' => '0', 'IsEmployee' => '0',
'Contacts' => $strMobile, 'ExitDate' => $currentDate,
'UserName' => '', 'FirstName' => $strName,
'LastName' => '',
'Designation' => '', 'Password' => '',
'RandStr' => '', 'PasswordExpiryDate' => $currentDate,
'IsPswExpire' => 0,'OtherEmail' => '',
'SecondaryEmail' => '', 'LastLoginTime' => $currentDate,
'IsLogInNow' => 0, 'CreatedByUserSysId' => '0',
'RandomCode' => '', 'Gender' =>'',
'UserNickName' => '', 'UserPicPath' => '',
'ContactNo1' => '', 'ContactNo2' => '',
'HomePhone' => '', 'SecondaryPhone' => '',
'UserDetails' => '','DOB' => '',
'Address' => '', 'CitySysId' => '',
'StateOrZoneSysId' => 0, 'CountrySysId' => 0,
'PinCode' => '', 'SecondaryAddress' => '',
'Fax' => '','MacIp' => '',
'SpeakingLangSysId' => 0, 'Signature' => '',
'UpdateDate' => $currentDate,'RegisterDate' => $currentDate,
'IsApproved' => 0,
'IsActive' => 0, 'IsMarkForDelete' => '0'
);
//$intCrmCustomerId = $objAgency->createAgencyCustomer($arrAgencyCustomer);
$response = array('success' => true, 'msg' => 'Your request created successfully.');
echo json_encode($response);
exit;
}
} else {
$response = array('success' => false, 'msg' => 'Your have already created an request with this mobile number.');
echo json_encode($response);
exit;
}
}
public function savepkgproposalgtxAction(){
ini_set('display_errors',1);
$this->_helper->layout->disableLayout();
$front = Zend_Controller_Front::getInstance();
$front->setParam('noViewRenderer', true);
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$name = $this->getRequest()->getParam('name');
$custphone = $this->getRequest()->getParam('mobile') ? $this->getRequest()->getParam('mobile') : '';
$custemail = $this->getRequest()->getParam('email') ? $this->getRequest()->getParam('email') : '';
$remarks = $this->getRequest()->getParam('Remarks');
$tpsysID = $this->getRequest()->getParam('tpsysID');
$plantitle = $this->getRequest()->getParam('plantitle') ? $this->getRequest()->getParam('plantitle') : '';
$createDate = date('Y-m-d');
$objPackage = new Travel_Model_TblPackage();
$travelplandata = $this->_crmcusttravelplan->GetTravelPlan($tpsysID);
$getcustomerdetails = $this->_crmcustomerObj->GetCustomerDetailsByEmail($custemail);
//$fullname = $getcustomerdetails['FullName'] ? $getcustomerdetails['FullName'] : 'Guest';
if(empty($getcustomerdetails['CRMCustSysId'])){
######### Register New Customer ###########
$date = date('Y-m-d');
$userArray = array(
'EmailId' => $custemail,
'PrimaryContactNumber' => $custphone,
'FullName' => $name,
'FirstName' => $name,
'ActiveDate' => $date,
'IsApproved' => '1',
'IsActive' => '1',
'IsMarkForDelete' => '0'
);
$customerID = $this->_crmcustomerObj->addCustomer($userArray);
$agencyuserArray = array(
'AgencySysId' => 3,
'CRMCustSysId' => $customerID,
'EmailId' => $custemail,
'Title' => '1',
'Logo' => '',
'IsfromSM' => '0',
'UserId' => '0',
'IsEmployee' => '0',
'Contacts' => $custphone,
'JoinDate' => $date,
'UserName' => $name,
'FirstName' => $name,
'LastName' => '',
'RegisterDate' => $date,
'IsApproved' => '1',
);
### Insert Record in to Agency Table as well ########
$agencyCustomerData = $this->_agencycustomerObj->addAgencyCustomer($agencyuserArray);
}
else{
$userArray = array(
'PrimaryContactNumber' => $custphone
);
$customerID = $getcustomerdetails['CRMCustSysId'];
$where = "CRMCustSysId = " . $customerID;
$this->_crmcustomerObj->UpdateCustomer($userArray,$where);
}
$roomjson = array();
if(empty($totaltraveller)){
$totaltraveller = 2;
}
$priceperadult = 'N/A';
$priceperkid = 'N/A';
$agentsysID = 3;
############# CREATE NEW LEAD THEN PROPOSAL #################
$planbookingID = 'Q/' . date('y');
$stratdate = $travelplandata[0]['StartDate'];
$ValidTill = $travelplandata[0]['StartDate'];
$PkgSellValidTill = $travelplandata[0]['PkgSellValidTill'];
$customertravelpaln = array(
'PlanBookingId' => $planbookingID,
'MasterTPSysId' => '',
'TPCode' => $tpsysID,
'AgencySysId' => 3,
'AgentSysId' => '',
'StatusType' => 1,
'CustomerSysId' => $customerID,
'PlanType' => 5,
'MinPax' => $travelplandata[0]['MinPax'] ? $travelplandata[0]['MinPax'] : 0,
'PackRangeType' => $travelplandata[0]['PackRangeType'] ? $travelplandata[0]['PackRangeType'] : 0,
'Title' => $travelplandata[0]['Title'] ? $travelplandata[0]['Title'] : '',
'EconomyMask' => $travelplandata[0]['EconomyMask'] ? $travelplandata[0]['EconomyMask'] : 0,
'PackTypeMask' => $travelplandata[0]['PackTypeMask'] ? $travelplandata[0]['PackTypeMask'] : '',
'InclCatMask' => $travelplandata[0]['InclCatMask'] ? $travelplandata[0]['InclCatMask'] : 0,
'InclMask' => $travelplandata[0]['InclMask'] ? $travelplandata[0]['InclMask'] : '',
'ExclusionMask' => $travelplandata[0]['ExclusionMask'] ? $travelplandata[0]['ExclusionMask'] : '',
'PackSpecType' => $travelplandata[0]['PackSpecType'] ? $travelplandata[0]['PackSpecType'] : '',
'SupplierSysId' => isset($travelplandata[0]['SupplierSysId']) ? $travelplandata[0]['SupplierSysId'] : '0',
'PriceRange' => '',
'SeasonMask' => $travelplandata[0]['SeasonMask'] ? $travelplandata[0]['SeasonMask'] : 0,
'GeoType' => $travelplandata[0]['GeoType'] ? $travelplandata[0]['GeoType'] : 0,
'IsFixDatePlan' => $travelplandata[0]['IsFixDatePlan'] ? $travelplandata[0]['IsFixDatePlan'] : 0,
'IsFixPlan' => $travelplandata[0]['IsFixPlan'] ? $travelplandata[0]['IsFixPlan'] : 0,
'Details' => $travelplandata[0]['Details'] ? $travelplandata[0]['Details'] : '',
'ImageTN' => $travelplandata[0]['ImageTN'] ? $travelplandata[0]['ImageTN'] : '',
'ImgForList' => $travelplandata[0]['ImgForList'] ? $travelplandata[0]['ImgForList'] : '',
'ImgeDetails' => $travelplandata[0]['ImgeDetails'] ? $travelplandata[0]['ImgeDetails'] : '',
'StartDate' => '',
'ValidTill' => $ValidTill ? $ValidTill->format('Y-m-d') : '',
'PkgSellValidTill' => $PkgSellValidTill ? $PkgSellValidTill->format('Y-m-d') : '',
'Price' => $travelplandata[0]['Price'] ? $travelplandata[0]['Price'] : 0,
'CurrencyType' => $travelplandata[0]['CurrencyType'] ? $travelplandata[0]['CurrencyType'] : 0,
'DiscountMsg' => $travelplandata[0]['DiscountMsg'] ? $travelplandata[0]['DiscountMsg'] : '',
'DiscountType' => $travelplandata[0]['DiscountType'] ? $travelplandata[0]['DiscountType'] : 0,
'DiscountVal' => $travelplandata[0]['DiscountVal'] ? $travelplandata[0]['DiscountVal'] : 0,
'AdvBookingPercent' => $travelplandata[0]['AdvBookingPercent'] ? $travelplandata[0]['AdvBookingPercent'] : 0,
'AdvBookingDays' => $travelplandata[0]['AdvBookingDays'] ? $travelplandata[0]['AdvBookingDays'] : 0,
'NetPrice' => $travelplandata[0]['NetPrice'] ? $travelplandata[0]['NetPrice'] : 0,
'MinPrice' => $travelplandata[0]['MinPrice'] ? $travelplandata[0]['MinPrice'] : 0,
'TotalMinDays' => $travelplandata[0]['TotalMinDays'] ? $travelplandata[0]['TotalMinDays'] : 0,
'TotalMaxDays' => $travelplandata[0]['TotalMaxDays'] ? $travelplandata[0]['TotalMaxDays'] : 0,
'Hotels' => $travelplandata[0]['Hotels'] ? $travelplandata[0]['Hotels'] : '',
'PopularPlaces' => $travelplandata[0]['PopularPlaces'] ? $travelplandata[0]['PopularPlaces'] : '',
'Cities' => $travelplandata[0]['Cities'] ? $travelplandata[0]['Cities'] : '',
'Countries' => $travelplandata[0]['Countries'] ? $travelplandata[0]['Countries'] : '',
'IsMarkForDel' => $travelplandata[0]['IsMarkForDel'] ? $travelplandata[0]['IsMarkForDel'] : '0',
'DestinationPlaces' => 'Dubai',
'DestinationPlacesSysId' => '8219',
'RoomInfoJson' => '',
'EmailText' => '',
'EmailDestination' => '',
'CreateDate' => $createDate,
'IsActive' => 1,
'IsMarkForDel' => $travelplandata[0]['IsMarkForDel'] ? $travelplandata[0]['IsMarkForDel'] : '0',
'IsAprooved' => 1,
);
$leadID = $this->_crmcusttravelplan->addCustomerTravelPlan($customertravelpaln);
$travelplanIetnaryData = $this->_crmcusttravelplan->GetTravelPlanItenary($tpsysID);
for($i=0;$i<count($travelplanIetnaryData);$i++){
$travelpanitenary[] = $travelplanIetnaryData[$i]['TPIntSysId'];
}
$tplanitenayvalues = implode(",",$travelpanitenary);
$start_date = date('Y-m-d');
$end_date = date('Y-m-d');
$start_date = date('Y-m-d');
for($i=0;$i<count($travelplanIetnaryData);$i++)
{
$tpstart_date = $travelplanIetnaryData[$i]['StartDate'];
$tpend_date = $travelplanIetnaryData[$i]['EndDate'];
$travelitenaryarray = array(
'TPSysId' => $leadID,
'Sequence' => $travelplanIetnaryData[$i]['Sequence'],
'AgencySysId' => 3,
'Title' => $travelplanIetnaryData[$i]['Title'],
'Details' => $travelplanIetnaryData[$i]['Details'],
'InclMask' => $travelplanIetnaryData[$i]['InclMask'] ? trim($travelplanIetnaryData[$i]['InclMask']) : '',
'ExclusionMask' => $travelplanIetnaryData[$i]['ExclusionMask'] ? $travelplanIetnaryData[$i]['ExclusionMask'] : '',
'InclCatMask' => $travelplanIetnaryData[$i]['InclCatMask'] ? trim($travelplanIetnaryData[$i]['InclCatMask']) : '',
'PackInclMask' => $travelplanIetnaryData[$i]['PackInclMask'] ? $travelplanIetnaryData[$i]['PackInclMask'] : '',
'PackTypeMask' => trim($travelplanIetnaryData[$i]['PackTypeMask']),
'ImageTN' => $travelplanIetnaryData[$i]['ImageTN'],
'ImgForList' => $travelplanIetnaryData[$i]['ImgForList'],
'ImgeDetails' => $travelplanIetnaryData[$i]['ImgeDetails'],
'Rating' => $travelplanIetnaryData[$i]['Rating'] ? $travelplanIetnaryData[$i]['Rating'] : 0,
'TotalMinDays' => $travelplanIetnaryData[$i]['TotalMinDays'] ? $travelplanIetnaryData[$i]['TotalMinDays'] : 0,
'TotalMaxDays' => $travelplanIetnaryData[$i]['TotalMaxDays'],
'Hotels' => $travelplanIetnaryData[$i]['Hotels'],
'PopularPlaces' => $travelplanIetnaryData[$i]['PopularPlaces'],
'Cities' => $travelplanIetnaryData[$i]['Cities'],
'Countries' => $travelplanIetnaryData[$i]['Countries'],
'IsMarkForDel' => 0,
'IsActive' => 0,
);
$destination_cities_arr[] = $travelplanIetnaryData[$i]['Cities'];
$lasttravelitenaryID[] = $this->_crmcustomertravelItenary->addCustomerTravelItenary($travelitenaryarray);
}
$tplanitenaryaccomdata = $this->_crmcusttravelplan->GetTravelPlanItenaryAccom($tplanitenayvalues);
for($k =0;$k < count($tplanitenaryaccomdata); $k++){
$existingtpintID = $tplanitenaryaccomdata[$k]['TPIntSysId'];
$getkeyvalue = array_search($existingtpintID,$travelpanitenary);
$travelitenaryaccomArray = array(
'TPIntSysId' => $lasttravelitenaryID[$getkeyvalue] ? $lasttravelitenaryID[$getkeyvalue] : 0,
'SeqId' => $tplanitenaryaccomdata[$k]['SeqId'] ? $tplanitenaryaccomdata[$k]['SeqId'] : 0,
'AgencySysId' => $tplanitenaryaccomdata[$k]['AgencySysId'] ? $tplanitenaryaccomdata[$k]['AgencySysId'] : 3,
'AccoSysId' => $tplanitenaryaccomdata[$k]['AccoSysId'] ? $tplanitenaryaccomdata[$k]['AccoSysId'] : 0,
'RoomType' => $tplanitenaryaccomdata[$k]['RoomType'] ? $tplanitenaryaccomdata[$k]['RoomType'] : 0,
'RoomNumber' => $tplanitenaryaccomdata[$k]['RoomNumber'] ? $tplanitenaryaccomdata[$k]['RoomNumber'] : '',
'Title' => $tplanitenaryaccomdata[$k]['Title'] ? $tplanitenaryaccomdata[$k]['Title'] : '',
'SpecialRequest' => '',
'CheckInTime' => $tplanitenaryaccomdata[$k]['CheckInTime'] ? $tplanitenaryaccomdata[$k]['CheckInTime'] : '',
'CheckOutTime' => $tplanitenaryaccomdata[$k]['CheckOutTime'] ? $tplanitenaryaccomdata[$k]['CheckOutTime'] : '',
'XRefCityId' => $tplanitenaryaccomdata[$k]['XRefCityId'] ? $tplanitenaryaccomdata[$k]['XRefCityId'] : '',
'FromDate' => $tplanitenaryaccomdata[$k]['FromDate'] ? $tplanitenaryaccomdata[$k]['FromDate'] : '',
'ToDate' => $tplanitenaryaccomdata[$k]['ToDate'] ? $tplanitenaryaccomdata[$k]['ToDate'] : '',
'AdultPax' => 0,
'ChildPax' => 0,
'InfantPax' => 0,
'PetPax' => 0,
'TotalPax' => $tplanitenaryaccomdata[$k]['TotalPax'] ? $tplanitenaryaccomdata[$k]['TotalPax'] : 0,
'TotalNights' => $tplanitenaryaccomdata[$k]['TotalNights'] ? $tplanitenaryaccomdata[$k]['TotalNights'] : 0,
'StarRating' => $tplanitenaryaccomdata[$k]['StarRating'] ? $tplanitenaryaccomdata[$k]['StarRating'] : 0,
'CurrencyType' => $tplanitenaryaccomdata[$k]['CurrencyType'] ? $tplanitenaryaccomdata[$k]['CurrencyType'] : 0,
'TotalCost' => $tplanitenaryaccomdata[$k]['TotalCostGen'] ? $tplanitenaryaccomdata[$k]['TotalCostGen'] : 0,
'Discounts' => $tplanitenaryaccomdata[$k]['Discounts'] ? $tplanitenaryaccomdata[$k]['Discounts'] : 0,
'Taxes' => $tplanitenaryaccomdata[$k]['Taxes'] ? $tplanitenaryaccomdata[$k]['Taxes'] : 0,
'NetCost' => $tplanitenaryaccomdata[$k]['NetCost'] ? $tplanitenaryaccomdata[$k]['NetCost'] : 0,
'IsSelectedOnPkg' => $tplanitenaryaccomdata[$k]['IsSelectedOnPkg'] ? $tplanitenaryaccomdata[$k]['IsSelectedOnPkg'] : 0,
'CreateDate' => $tplanitenaryaccomdata[$k]['CreateDate'] ? $tplanitenaryaccomdata[$k]['CreateDate'] : '',
'UpdateDate' => $tplanitenaryaccomdata[$k]['UpdateDate'] ? $tplanitenaryaccomdata[$k]['UpdateDate'] : '',
'IsMarkForDel' => 0,
'IsActive' => 1,
);
$tplanitenaryaccomdataID = $this->_crmcusttravelplanItenaryAccom->addCustomerTravelPlanAccom($travelitenaryaccomArray);
}
$tpitenaryAirdata = $this->_crmcusttravelplan->GetTravelPlanItenaryAir($tplanitenayvalues);
if(!empty($tpitenaryAirdata)){
######### Add Air Data #######
for($i=0;$i<count($tpitenaryAirdata);$i++){
$existingtpintairID = $tpitenaryAirdata[$i]['TPIntSysId'];
$getkeyvalue = array_search($existingtpintairID,$travelpanitenary);
$travelitenaryaccomairArray = array(
'TPIntSysId' => $tpitenaryAirdata[$getkeyvalue] ? $tpitenaryAirdata[$getkeyvalue] : 0,
'SeqId' => $tpitenaryAirdata['SeqId'] ? $tpitenaryAirdata['SeqId'] : 0,
'AgencySysId' => $tpitenaryAirdata['AgencySysId'] ? $tpitenaryAirdata['AgencySysId'] : 0,
'Cost' => $tpitenaryAirdata['Cost'] ? $tpitenaryAirdata['Cost'] : 0,
'FlightNumber' => $tpitenaryAirdata['FlightNumber'] ? $tpitenaryAirdata['FlightNumber'] : 0,
'AirlineSysId' => $tpitenaryAirdata['AirlineSysId'] ? $tpitenaryAirdata['AirlineSysId'] : 0,
'ICSourceSysId' => $tpitenaryAirdata['ICSourceSysId'] ? $tpitenaryAirdata['ICSourceSysId'] : 0,
'IsFromAgency' => $tpitenaryAirdata['IsFromAgency'] ? $tpitenaryAirdata['IsFromAgency'] : 0,
'LocalFromTime' => $tpitenaryAirdata['LocalFromTime'] ? $tpitenaryAirdata['LocalFromTime'] : 0,
'LocalToTime' => $tpitenaryAirdata['LocalToTime'] ? $tpitenaryAirdata['LocalToTime'] : 0,
'FromUTCTime' => $tpitenaryAirdata['FromUTCTime'] ? $tpitenaryAirdata['FromUTCTime'] : 0,
'ToUTCTime' => $tpitenaryAirdata['ToUTCTime'] ? $tpitenaryAirdata['ToUTCTime'] : 0,
'FlightCabinClass' => $tpitenaryAirdata['FlightCabinClass'] ? $tpitenaryAirdata['FlightCabinClass'] : 0,
'AdultPax' => $tpitenaryAirdata['AdultPax'] ? $tpitenaryAirdata['AdultPax'] : 0,
'ChildPax' => $tpitenaryAirdata['ChildPax'] ? $tpitenaryAirdata['ChildPax'] : 0,
'InfentPax' => $tpitenaryAirdata['InfentPax'] ? $tpitenaryAirdata['InfentPax'] : 0,
'TotalPax' => $tpitenaryAirdata['TotalPax'] ? $tpitenaryAirdata['TotalPax'] : 0,
'IsDirect' => $tpitenaryAirdata['IsDirect'] ? $tpitenaryAirdata['IsDirect'] : 0,
'DayLightSavingDiff' => $tpitenaryAirdata['DayLightSavingDiff'] ? $tpitenaryAirdata['DayLightSavingDiff'] : 0,
'FlyingMinutes' => $tpitenaryAirdata['FlyingMinutes'] ? $tpitenaryAirdata['FlyingMinutes'] : 0,
'SourcePlaceSysId' => $tpitenaryAirdata['SourcePlaceSysId'] ? $tpitenaryAirdata['SourcePlaceSysId'] : 0,
'DestPlaceSysId' => $tpitenaryAirdata['DestPlaceSysId'] ? $tpitenaryAirdata['DestPlaceSysId'] : 0,
'SourceAirportCode' => $tpitenaryAirdata['SourceAirportCode'] ? $tpitenaryAirdata['SourceAirportCode'] : 0,
'DestAirportCode' => $tpitenaryAirdata['DestAirportCode'] ? $tpitenaryAirdata['DestAirportCode'] : 0,
'AirportHaultMinutes' => $tpitenaryAirdata['AirportHaultMinutes'] ? $tpitenaryAirdata['AirportHaultMinutes'] : 0,
'StopCount' => $tpitenaryAirdata['StopCount'] ? $tpitenaryAirdata['StopCount'] : 0,
'Stops' => $tpitenaryAirdata['Stops'] ? $tpitenaryAirdata['Stops'] : 0,
'Rating' => $tpitenaryAirdata['Rating'] ? $tpitenaryAirdata['Rating'] : 0,
'FllightFeatureMask' => $tpitenaryAirdata['FllightFeatureMask'] ? $tpitenaryAirdata['FllightFeatureMask'] : 0,
'UpdatedByISSysId' => $tpitenaryAirdata['UpdatedByISSysId'] ? $tpitenaryAirdata['UpdatedByISSysId'] : 0,
'CreatedByISSysId' => $tpitenaryAirdata['CreatedByISSysId'] ? $tpitenaryAirdata['CreatedByISSysId'] : 0,
'ImageTN' => $tpitenaryAirdata['ImageTN'] ? $tpitenaryAirdata['ImageTN'] : 0,
'ImgForList' => $tpitenaryAirdata['ImgForList'] ? $tpitenaryAirdata['ImgForList'] : 0,
'ImgeDetails' => $tpitenaryAirdata['ImgeDetails'] ? $tpitenaryAirdata['ImgeDetails'] : 0,
'UpdateDate' => $tpitenaryAirdata['UpdateDate'] ? $tpitenaryAirdata['UpdateDate'] : 0,
'CreateDate' => $tpitenaryAirdata['CreateDate'] ? $tpitenaryAirdata['CreateDate'] : 0,
'ApproveBy' => $tpitenaryAirdata['ApproveBy'] ? $tpitenaryAirdata['ApproveBy'] : 0,
'ApprovalDate' => $tpitenaryAirdata['ApprovalDate'] ? $tpitenaryAirdata['ApprovalDate'] : 0,
'IsApproved' => $tpitenaryAirdata['IsApproved'] ? $tpitenaryAirdata['IsApproved'] : 0,
'IsActive' => $tpitenaryAirdata['IsActive'] ? $tpitenaryAirdata['IsActive'] : 0,
'IsMarkForDel' => $tpitenaryAirdata['IsMarkForDel'] ? $tpitenaryAirdata['IsMarkForDel'] : 0,
'encodedata' => $tpitenaryAirdata['encodedata'] ? $tpitenaryAirdata['encodedata'] : 0,
);
#################### Insert Records in Air Table #######################
}
}
$tpitenrayEvents = $this->_crmcusttravelplan->GetTravelPlanItenaryEvents($tplanitenayvalues);
if(!empty($tpitenrayEvents) ){
for($k=0;$k<count($tpitenrayEvents);$k++)
{
$existingtpintID = $tpitenrayEvents[$k]['TPIntSysId'];
$getkeyvalue = array_search($existingtpintID,$travelpanitenary);
$tpitenrayevntsArray = array(
'TPIntSysId' => $lasttravelitenaryID[$getkeyvalue] ? $lasttravelitenaryID[$getkeyvalue] : 0,
'Sequence' => $tpitenrayEvents[$k]['Sequence'] ? $tpitenrayEvents[$k]['Sequence'] : 0,
'AgencySysId' => 3,
'TPActivitySysId' => $tpitenrayEvents[$k]['TPActivitySysId'] ? $tpitenrayEvents[$k]['TPActivitySysId'] : 0,
'CurrencyType' => $tpitenrayEvents[$k]['CurrencyType'] ? $tpitenrayEvents[$k]['CurrencyType'] : 0,
'Title' => $tpitenrayEvents[$k]['Title'] ? $tpitenrayEvents[$k]['Title'] : '',
'Type' => $tpitenrayEvents[$k]['Type'] ? $tpitenrayEvents[$k]['Type'] : '',
'CityId' => $tpitenrayEvents[$k]['CityId'] ? $tpitenrayEvents[$k]['CityId'] : 0,
'Cost' => $tpitenrayEvents[$k]['Cost'] ? $tpitenrayEvents[$k]['Cost'] : 0,
'IsMarkForDel' => $tpitenrayEvents[$k]['IsMarkForDel'] ? $tpitenrayEvents[$k]['IsMarkForDel'] : 0,
'IsActive' => $tpitenrayEvents[$k]['IsActive'] ? $tpitenrayEvents[$k]['IsActive'] : 1,
'Markup' => $tpitenrayEvents[$k]['Markup'] ? $tpitenrayEvents[$k]['Markup'] : 0,
);
$travelitenrayevents = $this->_crmcustomertravelItenaryEvents->addCustomerTravelItenaryEvents($tpitenrayevntsArray);
}
}
$tpitenaryplaces = $this->_crmcusttravelplan->GetTravelPlanItenaryPaces($tplanitenayvalues);
if(!empty($tpitenaryplaces) ){
for($k=0;$k<count($tpitenaryplaces);$k++)
{
$existingtpintID = $tpitenaryplaces[$k]['TPIntSysId'];
$getkeyvalue = array_search($existingtpintID,$travelpanitenary);
$tpitenrayplacesArray = array(
'TPIntSysId' => $lasttravelitenaryID[$getkeyvalue] ? $lasttravelitenaryID[$getkeyvalue] : 0,
'Sequence' => $tpitenaryplaces[$k]['Sequence'] ? $tpitenaryplaces[$k]['Sequence'] : 0,
'PlaceSysId' => $tpitenaryplaces[$k]['PlaceSysId'] ? $tpitenaryplaces[$k]['PlaceSysId'] : 0,
'AgencySysId' => $tpitenaryplaces[$k]['AgencySysId'] ? $tpitenaryplaces[$k]['AgencySysId'] : 0,
'IsMarkForDel' => $tpitenaryplaces[$k]['IsMarkForDel'] ? $tpitenaryplaces[$k]['IsMarkForDel'] : 0,
'IsActive' => $tpitenaryplaces[$k]['IsActive'] ? $tpitenaryplaces[$k]['IsActive'] : 0,
);
$travelitenrayplaces = $this->_crmcustomertravelItenaryPlaces->addCustomerTravelItenaryPlaces($tpitenrayplacesArray);
}
}
$tpitenarysightseeing = $this->_crmcusttravelplan->GetTravelPlanSightSeeing($tplanitenayvalues);
if(!empty($tpitenarysightseeing)){
for($k=0;$k<count($tpitenarysightseeing);$k++)
{
$existingtpintID = $tpitenarysightseeing[$k]['InvnItemSysId'];
$getkeyvalue = array_search($existingtpintID,$travelpanitenary);
$fromDate = $tpitenarysightseeing[$k]['FromDate'];
$toDate = $tpitenarysightseeing[$k]['ToDate'];
$tpitenraysightseeingArray = array(
'InvnItemSysId' => $lasttravelitenaryID[$getkeyvalue] ? $lasttravelitenaryID[$getkeyvalue] : 0,
'SeqId' => $tpitenarysightseeing[$k]['SeqId'] ? $tpitenarysightseeing[$k]['SeqId'] : 0,
'SSSysId' => $tpitenarysightseeing[$k]['SSSysId'] ? $tpitenarysightseeing[$k]['SSSysId'] : 0,
'AgencySysId' => $tpitenarysightseeing[$k]['AgencySysId'] ? $tpitenarysightseeing[$k]['AgencySysId'] : 0,
'Title' => $tpitenarysightseeing[$k]['Title'] ? $tpitenarysightseeing[$k]['Title'] : 0,
'Type' => $tpitenarysightseeing[$k]['Type'] ? $tpitenarysightseeing[$k]['Type'] : 0,
'CityId' => $tpitenarysightseeing[$k]['CityId'] ? $tpitenarysightseeing[$k]['CityId'] : 0,
'Cost' => $tpitenarysightseeing[$k]['Cost'] ? $tpitenarysightseeing[$k]['Cost'] : 0,
'FromDate' => $fromDate->format('Y-m-d'),
'ToDate' => $toDate->format('Y-m-d'),
'BookingType' => $tpitenarysightseeing[$k]['BookingType'] ? $tpitenarysightseeing[$k]['BookingType'] : 0,
'Qty' => $tpitenarysightseeing[$k]['Qty'] ? $tpitenarysightseeing[$k]['Qty'] : 0,
'IfAnyOffer' => $tpitenarysightseeing[$k]['IfAnyOffer'] ? $tpitenarysightseeing[$k]['IfAnyOffer'] : 0,
'OfferMsg' => $tpitenarysightseeing[$k]['OfferMsg'] ? $tpitenarysightseeing[$k]['OfferMsg'] : 0,
'OfferImage' => $tpitenarysightseeing[$k]['OfferImage'] ? $tpitenarysightseeing[$k]['OfferImage'] : 0,
'IxFixedDateInven' => $tpitenarysightseeing[$k]['IxFixedDateInven'] ? $tpitenarysightseeing[$k]['IsMarkForDel'] : 0,
'CreateDate' => $createDate,
'UpdateDate' => $createDate,
'IsActive' => $tpitenarysightseeing[$k]['IsActive'] ? $tpitenarysightseeing[$k]['IsActive'] : 0,
'IsMarkForDelete' => $tpitenarysightseeing[$k]['IsMarkForDelete'] ? $tpitenarysightseeing[$k]['IsMarkForDelete'] : 0,
);
$travelitenraysightssing = $this->_crmcustomertravelSightSeeing->addCustomerTravelItenarySightSeeing($tpitenraysightseeingArray);
}
}
$travelplanmarketPrice = $this->_crmcusttravelplan->GetTravelMarketPrice($tpsysID);
if(!empty($travelplanmarketPrice) ){
for($k=0;$k<count($travelplanmarketPrice);$k++)
{
$fromDate = $travelplanmarketPrice[$k]['FromDate'];
$toDate = $travelplanmarketPrice[$k]['ToDate'];
$travelmarketpriceArray = array(
'TPIntSysId' => $leadID,
'AgencySysId' => $travelplanmarketPrice[$k]['AgencySysId'] ? $travelplanmarketPrice[$k]['AgencySysId'] : 0,
'FromDate' => $fromDate->format('Y-m-d'),
'ToDate' => $toDate->format('Y-m-d'),
'CurrencyType' => $travelplanmarketPrice[$k]['CurrencyType'] ? $travelplanmarketPrice[$k]['CurrencyType'] : 0,
'MarkType' => $travelplanmarketPrice[$k]['MarkType'] ? $travelplanmarketPrice[$k]['MarkType'] : 0,
'MarketPlaceId' => $travelplanmarketPrice[$k]['MarketPlaceId'] ? $travelplanmarketPrice[$k]['MarketPlaceId'] : 0,
'MarketPlace' => $travelplanmarketPrice[$k]['MarketPlace'] ? $travelplanmarketPrice[$k]['MarketPlace'] : 0,
'Permission' => $travelplanmarketPrice[$k]['Permission'] ? $travelplanmarketPrice[$k]['Permission'] : 0,
'MarkPercent' => $travelplanmarketPrice[$k]['MarkPercent'] ? $travelplanmarketPrice[$k]['MarkPercent'] : 0,
'CostPPSO' => $travelplanmarketPrice[$k]['CostPPSO'] ? $travelplanmarketPrice[$k]['CostPPSO'] : 0,
'CostPPDO' => $travelplanmarketPrice[$k]['CostPPDO'] ? $travelplanmarketPrice[$k]['CostPPDO'] : 0,
'CostPPTO' => $travelplanmarketPrice[$k]['CostPPTO'] ? $travelplanmarketPrice[$k]['CostPPTO'] : 0,
'CostExtraBed' => $travelplanmarketPrice[$k]['CostExtraBed'] ? $travelplanmarketPrice[$k]['CostExtraBed'] : 0,
'CostChildWithoutBed' => $travelplanmarketPrice[$k]['CostChildWithoutBed'] ? $travelplanmarketPrice[$k]['CostChildWithoutBed'] : 0,
'Tax' => $travelplanmarketPrice[$k]['Tax'] ? $travelplanmarketPrice[$k]['Tax'] : 0,
'ExcludedPercent' => $travelplanmarketPrice[$k]['ExcludedPercent'] ? $travelplanmarketPrice[$k]['ExcludedPercent'] : 0,
'CreateDate' => $createDate,
'UpdateDate' => $createDate,
'IsActive' => $travelplanmarketPrice[$k]['IsActive'] ? $travelplanmarketPrice[$k]['IsActive'] : 0,
'IsMarkForDel' => 0,
);
$travelitenramarketwsierate = $this->_crmcustomertravelMarketPlaces->addCustomerTravelMarketRate($travelmarketpriceArray);
}
}
$travelplanterms = $this->_crmcusttravelplan->GetCustomerTravelPlanTerms($tpsysID);
if(!empty($travelplanterms) ){
for($k=0;$k<count($travelplanterms);$k++)
{
$travelplantermsArray = array(
'TPIntSysId' => $leadID,
'AgencySysId' => $travelplanterms[$k]['AgencySysId'] ? $travelplanterms[$k]['AgencySysId'] : 0,
'Inclusions' => $travelplanterms[$k]['Inclusions'] ? $travelplanterms[$k]['Inclusions'] : 0,
'Exclusions' => $travelplanterms[$k]['Exclusions'] ? $travelplanterms[$k]['Exclusions'] : 0,
'CancellationPolicy' => $travelplanterms[$k]['CancellationPolicy'] ? $travelplanterms[$k]['CancellationPolicy'] : 0,
'TravelBasics' => $travelplanterms[$k]['TravelBasics'] ? $travelplanterms[$k]['TravelBasics'] : '',
//'TravelBasics' => $travelplanterms[$k]['TravelBasics'] ? $travelplanterms[$k]['TravelBasics'] : 0,
'BookingTerms' => $travelplanterms[$k]['BookingTerms'] ? $travelplanterms[$k]['BookingTerms'] : '',
//'BookingTerms' => $travelplanterms[$k]['BookingTerms'] ? $travelplanterms[$k]['BookingTerms'] : 0,
//'WhyUseUs' => $travelplanterms[$k]['WhyUseUs'] ? $travelplanterms[$k]['WhyUseUs'] : 0,
'WhyUseUs' => $travelplanterms[$k]['WhyUseUs'] ? $travelplanterms[$k]['WhyUseUs'] : '',
'CreateDate' => $createDate,
'UpdateDate' => $createDate,
'IsMarkForDel' => $travelplanterms[$k]['IsMarkForDel'] ? $travelplanterms[$k]['IsMarkForDel'] : 0,
'IsActive' => $travelplanterms[$k]['IsActive'] ? $travelplanterms[$k]['IsActive'] : 0,
);
$travelitenramarketwsierate = $this->_crmcustomertravelTerm->addCustomerTerm($travelplantermsArray);
}
}
$toemail = "shobhit833@gmail.com";
// $toemail = "ragahav@tripsbank.com";
$msg = "Details Of Form Submission \n Name : ".$name."\n Mobile : ".$custphone."\n Email : ".$custemail."\n Remarks : ".$remarks;
$mailConfig = array(
'ssl' => 'ssl',
'auth' => 'login',
'port' => $this->smtpPort,
'username' => $this->smtpUserName,
'password' => $this->smtpPassword
);
$emailId = "raghav@tripsbank.com";
$transport = new Zend_Mail_Transport_Smtp($this->smtpHost, $mailConfig);
$bodyText = 'Thanks for your enquiry , we will contact you ASAP';
$mail = new Zend_Mail("iso-8859-1");
$mail->addTo($emailId)
->setSubject($plantitle)
->setBodyHtml($bodyText)
->setFrom($this->fromEmail, $this->fromName);
try {
$mail->send($transport);
echo 'Email has sent to customer';
} catch (Exception $err) {
print_r($err, true);
}
}
}