function addNewsletterToRepo($cfdata)
{
$formTitle = $cfdata->title;
if (strpos($formTitle, 'Newsletter Form') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, email, page_converted, date_added, type, optin_status) VALUES ('" . $_POST['name'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $date_subscribed . "', 'subscriber', '0')";
$sql = mysqli_query($link, $query);
$_SESSION['thank-you'] = 1;
} else {
if (strpos($formTitle, 'Commercial Property Form') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
$ss = new SpreadsheetHandler();
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$name = $_POST['fname'] . ' ' . $_POST['lname'];
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, contact, email, page_converted, client_ip, date_added, status, message, type, property) VALUES ('" . $name . "', '" . $_POST['contact'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $_POST['clientIp'] . "' , '" . $date_subscribed . "', '', '" . $_POST['message'] . "', '" . $_POST['propertyType'] . "', '" . $_POST['property'] . "')";
$sql = mysqli_query($link, $query);
$data = array('name' => $name, 'contactnumber' => $_POST['contact'], 'email' => $_POST['email'], 'pageconverted' => $_SERVER['HTTP_REFERER'], 'propertytype' => $_POST['propertyType'], 'property' => $_POST['property'], 'message' => $_POST['message'], 'dateinquired' => $date_subscribed);
$ss->addContactLeadToDocs($data);
$_SESSION['thank-you'] = 1;
} else {
if (strpos($formTitle, 'Contact Us') !== false) {
//LOCAL DB
/*$host = 'localhost';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'root';*/
$ss = new SpreadsheetHandler();
//STAGING
/*$host = 'localhost:3306';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leasingLeads$$##';*/
//LIVE
$host = '205.186.138.226';
$db_name = 'leasing_leads';
$user = '******';
$pwd = 'leads$$123%%';
$link = mysqli_connect($host, $user, $pwd);
$db_selected = mysqli_select_db($link, $db_name);
$date_subscribed = date('Y-m-d H:i:s');
$query = "INSERT INTO `contact_forms` (name, contact, email, page_converted, date_added, message, type) VALUES ('" . $_POST['name'] . "', '" . $_POST['contact'] . "', '" . $_POST['email'] . "', '" . $_SERVER['HTTP_REFERER'] . "', '" . $date_subscribed . "', '" . $_POST['message'] . "', 'inquiries')";
$sql = mysqli_query($link, $query);
$data = array('name' => $_POST['name'], 'contact' => $contact, 'email' => $_POST['email'], 'page_converted' => $_SERVER['HTTP_REFERER'], 'date' => $date_subscribed, 'message' => $_POST['message'], 'status' => 'inquiries');
$ss->addContactFormLead($data);
$_SESSION['thank-you'] = 1;
}
}
}
}
<?php
session_start();
include 'Database/DBHandler.php';
include 'Mailer/MailerHandler.php';
include 'Spreadsheet/SpreadsheetHandler.php';
if (isset($_POST) && !empty($_POST)) {
$db = new DBHandler();
$db->connect();
$mail = new MailerHandler();
$ss = new SpreadsheetHandler();
if ($_POST['leaseType'] == 'short-term') {
$result = $db->insertBookingLead($_POST);
$mailRes = $mail->sendBookingNotif($_POST);
$ssRes = $ss->addBookingLeads($_POST);
} elseif ($_POST['leaseType'] == 'long-term') {
$result = $db->insertAppointmentLead($_POST);
$mailRes = $mail->sendAppointmentNotif($_POST);
$ssRes = $ss->addAppointmentLeads($_POST);
}
if ($result == 1) {
echo json_encode(1);
} else {
echo json_decode(-1);
}
$_SESSION['thank-you'] = 1;
} else {
header("Location: " . get_site_url());
}
public function processPurchase($post, $request, $server, $cookie)
{
if (isset($post) && isset($server) && isset($request) && $server['REQUEST_METHOD'] == 'POST') {
$db = new DBHandler();
$db->connect();
$lead = array();
// Datas
$u = new Utility();
$request = array_merge($request, $cookie);
$coupon = strtoupper($request['coupon_code']);
$branch = isset($request['tnfbranch']) ? $request['tnfbranch'] : $request['branch'];
$request['txn_id'] = $u->generateTransactionReceipt($branch, $coupon) . $db->retrieveBuyerLastId();
$params = $u->processPurchaseData($request);
$params['couponCode'] = $coupon;
// Items
$items = $u->processPurchaseItems($request);
// End of Datas
$ss = new SpreadsheetHandler();
$ss->addPurchaseToDocs($items, $params);
$db->insertBuyer($coupon, $params, $items);
$analytics = new Analytics();
$analytics->ga($params, $items);
$userfname = isset($request['userfname']) ? $request['userfname'] : "";
$userlname = isset($request['userlname']) ? $request['userlname'] : "";
$logparams = array("action" => "Coupon Redemption", "module" => "TNF Microsite " . $branch, "content" => $userfname . " " . $userlname . " from " . $branch . " process a promo coupon redemption with promo code " . $coupon, 'ip' => $server['REMOTE_ADDR']);
$db->updateLogs(0, $logparams, $userfname, $userlname);
return $params;
} else {
return false;
}
}
