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; } }