| 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/cronjob/ |
Upload File : |
<?php
require_once 'init.php';
$modelFaceBook = new Travel_Model_TblFacebook();
$fModel = new Finance_Model_Finance();
$crmagencyleadaccountObj = new Travel_Model_CRM_AgencyLeadAccount();
$ModelCRMCustomer = new Travel_Model_CRM_Customer();
$crmcustomerObj = new Travel_Model_CRM_Customer();
$agencycustomerObj = new Travel_Model_CRM_AgencyCustomer();
$leadstageObj = new Travel_Model_TblLeadStage();
function writeLog($data) {
$fileName = "Facebook_" . date("Y-m-d") . ".txt";
$fp = fopen("log/" . $fileName, 'a+');
$data = date("Y-m-d H:i:s") . " - " . $data;
fwrite($fp, $data);
fclose($fp);
}
function mailSentByElastice($emailData, $arrEmailStatistics = array()) {
$url = 'https://api.elasticemail.com/v2/email/send';
$to = implode(";", $emailData['to']);
$apikey = isset($emailData['APIKEY']) ? trim($emailData['APIKEY']) : '51453e3e-df95-4695-970c-68432e4d8785';
try {
$post = array(
'from' => $emailData['fromEmail'],
'fromName' => $emailData['fromName'],
'apikey' => $apikey,
'subject' => $emailData['subject'],
'to' => $to,
'bodyHtml' => $emailData['bodyHtml'],
'bodyText' => $emailData['bodyText'],
'isTransactional' => false
);
$ch = curl_init();
curl_setopt_array($ch, array(
CURLOPT_URL => $url,
CURLOPT_POST => true,
CURLOPT_POSTFIELDS => $post,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_HEADER => false,
CURLOPT_SSL_VERIFYPEER => false
));
$result = curl_exec($ch);
curl_close($ch);
} catch (Exception $ex) {
$result = $ex->getMessage();
}
return $result;
}
$getActiveLeadForm = $modelFaceBook->getActiveFacebookLeadForm();
$runningForm = $userAgencyWiseData = $AgencyWiseData = $leadData = $leadId = array();
if (!empty($getActiveLeadForm)) {
foreach ($getActiveLeadForm as $value) {
$formId = trim($value['FormSysId']);
$AgencySysId = trim($value['AgencySysId']);
$getAccessTokenArray = $modelFaceBook->insertLeadDatainCRM($formId);
$getAccessToken = isset($getAccessTokenArray['AccessToken']) ? trim($getAccessTokenArray['AccessToken']) : '';
if ($getAccessToken != '') {
$resultSet = $modelFaceBook->fbExchangeToken($getAccessToken);
if (isset($resultSet)) {
$resultArray = json_decode($resultSet, true);
if (!empty($resultArray)) {
$fbexchangeToken = isset($resultArray['access_token']) ? trim($resultArray['access_token']) : '';
if ($fbexchangeToken != '') {
$getPagesUrl = "https://graph.facebook.com/v15.0/me/accounts?access_token=$fbexchangeToken";
$reponsePagesArray = $modelFaceBook->sendRequest($getPagesUrl);
//echo "<pre>";print_r($reponsePagesArray);exit;
if (isset($reponsePagesArray) && $reponsePagesArray != '') {
$reponsePagesArrayVal = json_decode($reponsePagesArray, true);
$reponsePagesArrayValArr = isset($reponsePagesArrayVal['data']) ? $reponsePagesArrayVal['data'] : array();
if (!empty($reponsePagesArrayValArr) && count($reponsePagesArrayValArr) > 0) {
for ($fb = 0; $fb < count($reponsePagesArrayValArr); $fb++) {
$FBPaageSysId = isset($reponsePagesArrayValArr[$fb]["id"]) ? $reponsePagesArrayValArr[$fb]["id"] : '';
$AccessToken = isset($reponsePagesArrayValArr[$fb]["access_token"]) ? $reponsePagesArrayValArr[$fb]["access_token"] : '';
if ($FBPaageSysId != "" && $AccessToken != '') {
$getleadFormUrl = "https://graph.facebook.com/v15.0/$FBPaageSysId/leadgen_forms?access_token=$AccessToken";
$LeadFormArray = $modelFaceBook->sendRequest($getleadFormUrl);
if (isset($LeadFormArray) && $LeadFormArray != '') {
$LeadFormArrayVal = json_decode($LeadFormArray, true);
$LeadFormValuesArr = isset($LeadFormArrayVal['data']) ? $LeadFormArrayVal['data'] : array();
if (!empty($LeadFormValuesArr) && count($LeadFormValuesArr) > 0) {
for ($fbF = 0; $fbF < count($LeadFormValuesArr); $fbF++) {
$FBLeadFormsSysId = isset($LeadFormValuesArr[$fbF]["id"]) ? $LeadFormValuesArr[$fbF]["id"] : '';
if ($FBLeadFormsSysId == $formId) {
$getleadsUrl = "https://graph.facebook.com/v15.0/$formId/leads?fields=ad_id,created_time,platform,field_data,form_id&access_token=$AccessToken";
$LeadFormValArray = $modelFaceBook->sendRequest($getleadsUrl);
if (isset($LeadFormValArray) && $LeadFormValArray != '') {
$LeadFormValues = json_decode($LeadFormValArray, true);
$LeadFormValuesArr = isset($LeadFormValues['data']) ? $LeadFormValues['data'] : array();
if (!empty($LeadFormValuesArr) && count($LeadFormValuesArr) > 0) {
$getFildesMap = $modelFaceBook->getActiveFacebookLeadFormFileds($formId);
if (!empty($LeadFormValuesArr)) {
$getFildesMapAssignData = $modelFaceBook->getActiveFormDetail($formId);
foreach ($LeadFormValuesArr as $leadKey1 => $leadValue1) {
$leadCreatedDate = date('Y-m-d H:i:s');
if (isset($leadValue1['created_time']) && $leadValue1['created_time'] != "") {
$leadArrayData = explode('T', $leadValue1['created_time']);
if (!empty($leadArrayData)) {
$leadCreatedDate = $leadArrayData[0];
if (isset($leadArrayData[1]) && $leadArrayData[1] != '') {
$timeArray = explode('+', $leadArrayData[1]);
if (!empty($timeArray)) {
$leadCreatedDate = $leadCreatedDate . ' ' . $timeArray[0];
}
}
}
}
$field_data = $leadValue1['field_data'];
$field_dataArr = array();
foreach ($field_data as $fKey => $fVal) {
$field_dataArr[$fVal['name']] = $fVal['values'][0];
}
$userLeadArray = array();
foreach ($getFildesMap as $mKey => $mValue) {
$userLeadArray['AgencySysId'] = $mValue['AgencySysId'];
$userLeadArray['SocialSysId'] = $leadValue1['id'];
$userLeadArray[$mValue['ColumnName']] = $field_dataArr[$mValue['FieldName']];
}
$userLeadArray['SocialFormSysId'] = $formId;
$userLeadArray['AssignUserSysId'] = isset($getFildesMapAssignData[0]['AssignUserSysId']) ? $getFildesMapAssignData[0]['AssignUserSysId'] : '';
$userLeadArray['CampaignSysId'] = isset($getFildesMapAssignData[0]['CampaignSysId']) ? $getFildesMapAssignData[0]['CampaignSysId'] : 0;
$userLeadArray['LandingPageSysId'] = isset($getFildesMapAssignData[0]['LandingPageSysId']) ? $getFildesMapAssignData[0]['LandingPageSysId'] : 0;
$userLeadArray['PlanType'] = isset($getFildesMapAssignData[0]['PlanType']) ? (int) $getFildesMapAssignData[0]['PlanType'] : 0;
$userLeadArray['FullName'] = isset($userLeadArray['FirstName']) ? $userLeadArray['FirstName'] : '';
$toDestination = '';
if (isset($getFildesMapAssignData[0]['DestinationName']) && trim($getFildesMapAssignData[0]['DestinationName']) != '') {
$toDestination = trim($getFildesMapAssignData[0]['DestinationName']);
} else {
$toDestination = isset($userLeadArray['Destination']) ? $userLeadArray['Destination'] : '';
}
$userLeadArray['Destination'] = $toDestination;
$userLeadArray['ToDestinationSysId'] = isset($getFildesMapAssignData[0]['DestinationId']) ? $getFildesMapAssignData[0]['DestinationId'] : 0;
$userLeadArray['CreatedDate'] = $leadCreatedDate;
$userLeadArray['UpdatedDate'] = date('Y-m-d H:i:s');
$userLeadArray['ActiveDate'] = $leadCreatedDate;
$userLeadArray['IsApproved'] = 0;
$userLeadArray['IsActive'] = 1;
$userLeadArray['IsMarkForDelete'] = 0;
$userLeadArray['Salutation'] = '';
$leadSourceTitle = (($leadValue1['platform'] == 'ig') ? 'Instagram' : 'Facebook');
if ($mValue['AgencySysId'] == 2645) {
$leadSourceTitle = 'Web';
}
$intLeadSourceSysId = $ModelCRMCustomer->getLeadSource($mValue['AgencySysId'], $leadSourceTitle); // for Master LeadSouce Creation
$leadsource = (isset($intLeadSourceSysId[0]['LeadSourceSysId']) && !empty($intLeadSourceSysId[0]['LeadSourceSysId'])) ? $intLeadSourceSysId[0]['LeadSourceSysId'] : 0;
$getStageList = $leadstageObj->getLeadStageSatus('New');
$leadstage = (isset($getStageList[0]['TPStatusSysId']) && !empty($getStageList[0]['TPStatusSysId'])) ? $getStageList[0]['TPStatusSysId'] : 0;
$userLeadArray['LeadSourceSysId'] = $leadsource;
$userLeadArray['LeadStageSysId'] = $leadstage;
$userLeadArray['leadSourceTitle'] = $leadSourceTitle;
$leadData[] = $userLeadArray;
$userAgencyWiseData['AgencySysId'] = $userLeadArray['AgencySysId'];
$userAgencyWiseData[$formId][] = $userLeadArray['SocialSysId'];
$runningForm[$formId] = $formId;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$getAllInsetedId = array();
foreach ($runningForm as $valruning) {
$getAllInsetedId[$valruning] = $crmagencyleadaccountObj->checkMultiPleLeadFromSoiceId($userAgencyWiseData[$valruning], $valruning);
}
$finalArray = array();
foreach ($userAgencyWiseData as $checkKey => $checkVal) {
if (is_array($checkVal)) {
for ($k = 0; $k < count($checkVal); $k++) {
foreach ($getAllInsetedId as $checkKey1 => $checkVal1) {
foreach ($checkVal1 as $checkVal2) {
if ($checkKey == $checkKey1) {
if ($checkVal[$k] == $checkVal2['SocialSysId']) {
$finalArray[$checkKey][] = $checkVal[$k];
} else {
}
}
}
}
}
}
}
$arryIntrsect = array();
foreach ($runningForm as $valruning) {
if (isset($userAgencyWiseData[$valruning]) && is_array($userAgencyWiseData[$valruning])) {
$userAgencyWiseData[$valruning] = $userAgencyWiseData[$valruning];
} else {
$userAgencyWiseData[$valruning] = array();
}
if (isset($finalArray[$valruning]) && is_array($finalArray[$valruning])) {
$finalArray[$valruning] = $finalArray[$valruning];
} else {
$finalArray[$valruning] = array();
}
$arryIntrsect[$valruning] = array_diff($userAgencyWiseData[$valruning], $finalArray[$valruning]);
}
$getAllLeadId = array();
$checkSendMailONFB = array();
$checkEmailSend = array();
//foreach ($arryIntrsect as $formKey => $userLeadArray) {
// if (!empty($userLeadArray)) {
// $CurrentDateTime = date('Y-m-d H:i:s');
// $resultSet = $crmagencyleadaccountObj->getFaceBookUserId($formKey);
// if (count($resultSet) > 0) {
// $FBAgencySysId = isset($resultSet['AgencySysId']) ? $resultSet['AgencySysId'] : 0;
// $IsAutoProposalOnFBLead = isset($resultSet['IsAutoProposalOnFBLead']) ? $resultSet['IsAutoProposalOnFBLead'] : 0;
// $fullName = ucfirst(trim($resultSet['FirstName'])) . ' ' . ucfirst(trim($resultSet['LastName']));
// $emailId = trim($resultSet['EmailId']);
// $checkSendMailONFB[$formKey]['IsAutoProposalOnFBLead'] = $IsAutoProposalOnFBLead;
// $checkSendMailONFB[$formKey]['AgencySysId'] = $FBAgencySysId;
// $checkSendMailONFB[$formKey]['AgentName'] = $fullName;
// $checkSendMailONFB[$formKey]['AgentEmailId'] = $emailId;
// $checkSendMailONFB[$formKey]['DisplayName'] = trim($resultSet['DisplayName']);
// $checkSendMailONFB[$formKey]['EmailKey'] = trim($resultSet['EmailKey']);
// $checkSendMailONFB[$formKey]['Logo'] = trim($resultSet['Logo']);
// $subject = 'New lead via Facebook on helloGTX CRM - ' . $CurrentDateTime;
// $adminBodyText = '<table width="60%" border="0" align="center" cellpadding="0" cellspacing="0" style=" border: dashed 1px #ccc; font-size:14px; font-family: Roboto, sans-serif;">
// <tr>
// <td colspan="2" style=" padding:5px 40px;vertical-align: middle;">Dear ' . $fullName . ', <br>
// <br> <br>
// You have new leads via your Facebook page. <a href="https://globaltravelexchange.com/">Click here</a> to login to helloGTX and grab the deal !</td>
// </tr>
//
// <tr> <td> </td></tr>
// <tr>
// <td colspan="2" style=" padding:5px 40px;vertical-align: middle;">Cheers,<br> </td>
// </tr>
// <tr>
// <td colspan="2" style=" padding:5px 40px;vertical-align: middle;">Team helloGTX</td>
// </tr>
// </table>';
// $agencyPrimaryEmail = "prashant@catpl.co.in";
// $emailMasterData = array('fromEmail' => 'noreply@hellogtx.com', 'fromName' => 'Hello GTX', 'subject' => $subject, 'to' => array($emailId), 'bodyHtml' => $adminBodyText, 'bodyText' => '');
// $arrEmailStatisticsType = array_keys(unserialize(ARR_EMAIL_STATISTICS_TYPE));
// $arrEmailStatistics = array(
// "TPSysId" => 0,
// "TypeSysId" => 1, // 1 For Email 2 For SMS
// "AgencySysId" => $AgencySysId,
// "AgentSysId" => 0,
// "APIKEY" => trim($resultSet['EmailKey']),
// "Title" => '',
// "Source" => $arrEmailStatisticsType[2], // 6 For Misc
// "Status" => 0,
// "RefSysId" => "",
// "RefSysStatus" => "",
// "CreateDate" => Zend_Date::now()->toString('YYYY-MM-dd HH:mm:ss')
// );
// $checkStatusEmail = mailSentByElastice($emailMasterData, $arrEmailStatistics);
// }
// }
//}
$checkValT2 = array();
$checkMarketingMailData = array();
$checkUniqueUser = array();
foreach ($arryIntrsect as $formKey => $userLeadArray) {
if (!empty($userLeadArray)) {
foreach ($userLeadArray as $val) {
foreach ($leadData as $valLead) {
if ($valLead['SocialSysId'] == $val && $formKey == $valLead['SocialFormSysId']) {
try {
$checkLeadFromSoiceId = $crmagencyleadaccountObj->checkLeadFromSoiceId($valLead['SocialSysId']);
if (empty($checkLeadFromSoiceId)) {
$k = 0;
$userId = $crmagencyleadaccountObj->getFacebookUserIdFromRoundRobin($valLead['SocialFormSysId']);
if ((int) $userId > 0) {
$valLead['AssignUserSysId'] = $userId;
$checkUniqueUser[$userId] = $userId;
}
$whatsAppModel = new Travel_Model_TblWhatsapp();
$countryCodes = array('+1', '+44', '+91', '+61', '+81', '+86', '+852', '+971', '+880', '+975');
$mobilenumber = $valLead['PrimaryContactNumber'];
$mobileArray = $whatsAppModel->separateMobileNumber($mobilenumber, $countryCodes);
if (isset($mobileArray['status']) && $mobileArray['status'] == true) {
$contactNo = isset($mobileArray['mobile_number']) ? $mobileArray['mobile_number'] : '';
$countrycode = isset($mobileArray['country_code']) ? '+' . $mobileArray['country_code'] : '';
} else {
$contactNo = substr($mobilenumber, -10);
$countrycode = '';
}
$valLead['PrimaryContactNumber'] = $contactNo;
$valLead['countrycode'] = $countrycode;
$valLead['FirstName'] = substr($valLead['FirstName'], 0, 49);
$valLead['FullName'] = substr($valLead['FullName'], 0, 149);
$valLead['EmailId'] = substr($valLead['EmailId'], 0, 99);
$LandingPageSysId = $valLead['LandingPageSysId'];
$sourceN = ucfirst(strtolower($valLead['leadSourceTitle']));
$CustomerfullName = $valLead['FullName'];
unset($valLead['LandingPageSysId']);
unset($valLead['leadSourceTitle']);
$leadId = $crmagencyleadaccountObj->addCustomer($valLead);
$postData = array(
"UserSysId" => $AgentSysId,
"IsSchedule" => False,
"schedule_time" => $schedule_time,
"title" => "New Lead Alert [$sourceN]",
"body" => "A new lead of $CustomerfullName is being assigned to you thru $sourceN.",
"IsButton" => True,
"URL" => "crm/lead/index/filter/fresh",
"IsCall" => True,
"mobileNo" => trim($valLead['PrimaryContactNumber'])
);
if (isset($agentDetails['SecurityKey'])) {
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://globaltravelexchange.com/gtxwebservices/agency/create-fire-base-message',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS => $postData,
CURLOPT_HTTPHEADER => array(
'securitykey:' . trim($agentDetails['SecurityKey']),
//'Content-Type: application/json'
),
));
curl_exec($curl);
curl_close($curl);
//echo "<pre>";print_r($response);exit;
}
$updatedate = date("Y-m-d H:i:s");
$AgencySysId = $valLead['AgencySysId'];
$email = $valLead['EmailId'];
$mobilenum = $valLead['PrimaryContactNumber'] ? $valLead['PrimaryContactNumber'] : '';
if (isset($email) && !empty($email)) {
try {
$customerDetailsEmail = $crmcustomerObj->ChkEmailWithResponseUpdate($email, $AgencySysId);
} catch (Zend_Exception $e) {
$error_Message = $e->getMessage();
}
}
if (isset($mobilenum) && !empty($mobilenum)) {
try {
$customerDetailsMobile = $crmcustomerObj->ChkMobileWithResponse($mobilenum, $AgencySysId);
} catch (Zend_Exception $e) {
$error_Message = $e->getMessage();
}
}
if ($customerDetailsEmail || $customerDetailsMobile) {
$CustomerSysId = ($customerDetailsEmail['CustomerSysId']) ? $customerDetailsEmail['CustomerSysId'] : (isset($customerDetailsMobile['CustomerSysId']) ? $customerDetailsMobile['CustomerSysId'] : '');
if ($CustomerSysId == '') {
$status = 'psuccess';
} else {
$status = 'success';
}
} else {
$status = 'failure';
}
if ($status == 'failure' || $status == 'psuccess') {
$userArray = array(
'EmailId' => $valLead['EmailId'],
'Salutation' => '',
'PrimaryContactNumber' => $valLead['PrimaryContactNumber'] ? $valLead['PrimaryContactNumber'] : '',
'FullName' => $valLead['FullName'] ? $valLead['FullName'] : '',
'FirstName' => $valLead['FirstName'] ? $valLead['FirstName'] : '',
'LastName' => '',
'ActiveDate' => $updatedate,
'UpdatedDate' => $updatedate,
'CreatedDate' => $updatedate,
'countrycode' => '',
'IsApproved' => '1',
'IsActive' => '1',
'IsMarkForDelete' => '0'
);
if ($status != 'psuccess') {
try {
$CRMCustSysId = $crmcustomerObj->addCustomer($userArray);
} catch (Zend_Exception $e) {
$error_Message = $e->getMessage();
}
} else {
$CRMCustSysId = $customerDetailsMobile['CRMCustSysId'] ? $customerDetailsMobile['CRMCustSysId'] : $customerDetailsEmail['CRMCustSysId'];
}
$agencyuserArray = array(
'AgencySysId' => $valLead['AgencySysId'],
'AgencyCRMLeadSysId' => $leadId,
'CRMCustSysId' => $CRMCustSysId,
'EmailId' => $valLead['EmailId'],
'Title' => 1,
'Logo' => '',
'IsfromSM' => '0',
'UserId' => '0',
'CitySysId' => '',
'StateOrZoneSysId' => 0,
'CountrySysId' => '',
'IsEmployee' => '0',
'Contacts' => $valLead['PrimaryContactNumber'],
'countrycode' => '',
'JoinDate' => $updatedate,
'UserName' => $valLead['FullName'] ? $valLead['FullName'] : '',
'FirstName' => $valLead['FirstName'] ? $valLead['FirstName'] : '',
'LastName' => '',
'Relation' => '',
'PassportNo' => '',
'PassportExpiry' => '',
'DOB' => '',
'MarriageAnniversary' => '',
'CreatedByUserSysId' => $valLead['AssignUserSysId'] ? $valLead['AssignUserSysId'] : '',
'RegisterDate' => $updatedate,
'LeadSourceSysId' => $valLead['LeadSourceSysId'] ? $valLead['LeadSourceSysId'] : '',
'UpdateDate' => $updatedate,
'IsApproved' => '0',
'IsActive' => '1',
'IsMarkForDelete' => '0'
);
try {
$CustomerSysId = $agencycustomerObj->addAgencyCustomer($agencyuserArray);
} catch (Zend_Exception $e) {
$error_Message = $e->getMessage();
}
}
// if ((isset($checkSendMailONFB[$valLead['SocialFormSysId']]['IsAutoProposalOnFBLead'])) && $checkSendMailONFB[$valLead['SocialFormSysId']]['IsAutoProposalOnFBLead'] == 1) {
// $checkMarketingMailData[$LandingPageSysId][$k]['LeadSysId'] = $leadId;
// $checkMarketingMailData[$LandingPageSysId][$k]['FirstName'] = $valLead['FirstName'];
// $checkMarketingMailData[$LandingPageSysId][$k]['EmailId'] = $valLead['EmailId'];
// $checkMarketingMailData[$LandingPageSysId][$k]['PrimaryContactNumber'] = $valLead['PrimaryContactNumber'];
// $checkMarketingMailData[$LandingPageSysId][$k]['AgencySysId'] = $valLead['AgencySysId'];
// $checkMarketingMailData[$LandingPageSysId][$k]['AgentName'] = $checkSendMailONFB[$valLead['SocialFormSysId']]['AgentName'];
// $checkMarketingMailData[$LandingPageSysId][$k]['AgentEmailId'] = $checkSendMailONFB[$valLead['SocialFormSysId']]['AgentEmailId'];
// $checkMarketingMailData[$LandingPageSysId][$k]['DisplayName'] = $checkSendMailONFB[$valLead['SocialFormSysId']]['DisplayName'];
// $checkMarketingMailData[$LandingPageSysId][$k]['EmailKey'] = $checkSendMailONFB[$valLead['SocialFormSysId']]['EmailKey'];
// $checkMarketingMailData[$LandingPageSysId][$k]['Logo'] = $checkSendMailONFB[$valLead['SocialFormSysId']]['Logo'];
// }
}
$status = "success";
} catch (Zend_Exception $e) {
$status = $e->getMessage();
}
}
}
}
}
}
$modelFB = new Travel_Model_TblFacebook();
if (!empty($checkMarketingMailData)) {
foreach ($checkMarketingMailData as $mkey => $mValue) {
foreach ($mValue as $mmValue) {
$TemplateHTMLArr = $modelFB->getMarketingMail($mmValue['AgencySysId'], $mkey);
$TemplateHTML = $TemplateHTMLArr['TemplateHTML'];
if ($TemplateHTML != '') {
$fullName = isset($mmValue['FirstName']) ? $mmValue['FirstName'] : '';
$agencyTitle = $mmValue['DisplayName'];
$agencySysId = $mmValue['AgencySysId'];
$agencyLogo = $mmValue['Logo'];
$bodyText = '';
$bodyText .= '<table cellspacing="0" cellpadding="0" align="center" width="650" style="font-family:Arial, Helvetica, sans-serif; color:#434343; font-size:12px;">';
$bodyText .= '<tr>
<td style="padding:10px 15px;">
<table width="650" cellspacing="0" cellpadding="0">';
$bodyText .= ' <tr>
<td colspan="3" style="background: #fff;padding:10px 15px ; font-size:14px; font-family:Arial, Helvetica, sans-serif; font-weight: normal !important; line-height:30px;">
<strong style="font-size:15px; color:#222222;">Dear ' . $fullName . ',</strong>
<br>
</td>
</tr>';
$bodyText .= '
<tr>
<td style="background: #fff;padding:10px 15px ; font-size:14px; font-family:Arial, Helvetica, sans-serif; font-weight: normal !important; line-height:30px; ">
' . $TemplateHTML . '
</td>
</tr>
<tr>
<td>
<table align="center" width="650" style="font-family:Arial, Helvetica, sans-serif; color:#434343; font-size:12px;" cellspacing="0" cellpadding="0">
<tr>
<td width="33%" style="padding:0px; font-size:9px; line-height:30px; font-weight:500; text-align:left; color:#484343; font-family:Arial, Helvetica, sans-serif;">© ' . date('Y') . ' ' . $agencyTitle . ' </td>
<td width="33%" style="padding:0px; font-size:9px; line-height:30px; font-weight:500; text-align:center; color:#484343; font-family:Arial, Helvetica, sans-serif;"><img src="https://globaltravelexchange.com/public/upload/media/agency/' . $agencySysId . '/' . $agencyLogo . '"></td>
<td width="33%" style="padding:0px; font-size:9px; line-height:30px; font-weight:500; text-align:right; color:#484343; font-family:Arial, Helvetica, sans-serif;">Technology By: <a href="http://www.hellogtx.com/" target="_blank" style="color:#3b75c9; text-decoration:none">hello<span style="color:#f9655c;">GTX</span></a></td>
</tr>
</table>
</td>
</tr>
</table>';
$custEmailId = isset($mmValue['EmailId']) ? trim($mmValue['EmailId']) : '';
$agencyPrimaryEmail = "prashant@catpl.co.in";
$fromEmailId = isset($mmValue['AgentEmailId']) ? trim($mmValue['AgentEmailId']) : '';
$fromEmailName = isset($mmValue['AgentName']) ? trim($mmValue['AgentName']) : '';
$TemplateSubject = $TemplateHTMLArr['TemplateSubject'];
$emailData = array('fromEmail' => $fromEmailId, 'fromName' => $fromEmailName, 'subject' => $TemplateSubject, 'to' => array(trim($custEmailId, $agencyPrimaryEmail)), 'bodyHtml' => $bodyText, 'bodyText' => '');
$arrEmailStatistics = array(
"TPSysId" => 0,
"TypeSysId" => 1, // 1 For Email 2 For SMS
"AgencySysId" => $agencySysId,
"APIKEY" => $mmValue['EmailKey'],
"AgentSysId" => 0,
"Title" => '',
"Source" => $arrEmailStatisticsType[2], // 6 For Misc
"Status" => 0,
"RefSysId" => "",
"RefSysStatus" => "",
"CreateDate" => Zend_Date::now()->toString('YYYY-MM-dd HH:mm:ss')
);
$checkStatusEmail = mailSentByElastice($emailData, $arrEmailStatistics);
try {
$checkEMailArray = json_decode($checkStatusEmail);
if ($checkEMailArray->success == 1) {
$editDataArray1 = [
'TransactionId' => $mailArrDecoded->data->transactionid,
];
$whereCondition = ['AgencyCRMLeadSysId =?' => $mmValue['AgencyCRMLeadSysId'], 'AgencySysId = ?' => $agencySysId];
$crmagencyleadaccountObj->UpdateCustomer($editDataArray1, $whereCondition);
}
} catch (Zend_Exception $e) {
$e->getMessage();
}
}
}
}
}