function processPayOnArrival() { global $bookprs; global $bsiCore; $bsiMail = new bsiMail(); $emailContent = $bsiMail->loadEmailContent(); $subject = $emailContent['subject']; mysql_query("UPDATE bsi_bookings SET payment_success=true WHERE booking_id = " . $bookprs->bookingId); mysql_query("UPDATE bsi_clients SET existing_client = 1 WHERE email = '" . $bookprs->clientEmail . "'"); $emailBody = "Dear " . $bookprs->clientName . ",<br><br>"; $emailBody .= $emailContent['body'] . "<br><br>"; $emailBody .= $bookprs->invoiceHtml; $emailBody .= '<br><br>' . mysql_real_escape_string(PP_REGARDS) . ',<br>' . $bsiCore->config['conf_hotel_name'] . '<br>' . $bsiCore->config['conf_hotel_phone']; $emailBody .= '<br><br><font style=\\"color:#F00; font-size:10px;\\">[ ' . mysql_real_escape_string(PP_CARRY) . ' ]</font>'; $returnMsg = $bsiMail->sendEMail($bookprs->clientEmail, $subject, $emailBody); if ($returnMsg == true) { $notifyEmailSubject = "Booking no." . $bookprs->bookingId . " - Notification of Room Booking by " . $bookprs->clientName; $notifynMsg = $bsiMail->sendEMail($bsiCore->config['conf_hotel_email'], $notifyEmailSubject, $bookprs->invoiceHtml); header('Location: booking-confirm.php?success_code=1'); die; } else { header('Location: booking-failure.php?error_code=25'); die; } //header('Location: booking-confirm.php?success_code=1'); }
break; case 'ipn': // Paypal is calling page for IPN validation... if ($p->validate_ipn()) { if ($p->ipn_data['payment_status'] == "Completed" || $p->ipn_data['payment_status'] == "Pending") { //***************************************************************************************** mysql_query("UPDATE bsi_bookings SET payment_success=true, payment_txnid='" . $p->ipn_data['txn_id'] . "', paypal_email='" . $p->ipn_data['payer_email'] . "' WHERE booking_id='" . $p->ipn_data['invoice'] . "'"); $invoiceROWS = mysql_fetch_assoc(mysql_query("SELECT client_name, client_email, invoice FROM bsi_invoice WHERE booking_id='" . $p->ipn_data['invoice'] . "'")); mysql_query("UPDATE bsi_clients SET existing_client = 1 WHERE email='" . $invoiceROWS['client_email'] . "'"); $invoiceHTML = $invoiceROWS['invoice']; $invoiceHTML .= '<br><br><table style="font-family:Verdana, Geneva, sans-serif; font-size: 12px; bgcolor:#999999; width:700px; border:none;" cellpadding="4" cellspacing="1"><tr><td align="left" colspan="2" style="font-weight:bold; font-variant:small-caps; background:#ffffff">' . mysql_real_escape_string(INV_PAY_DETAILS) . '</td></tr><tr><td align="left" width="30%" style="font-weight:bold; font-variant:small-caps; background:#ffffff">' . mysql_real_escape_string(INV_PAY_OPTION) . '</td><td align="left" style="background:#ffffff">PayPal</td></tr><tr><td align="left" width="30%" style="font-weight:bold; font-variant:small-caps; background:#ffffff">Payer E-Mail</td><td align="left" style="background:#ffffff">' . $p->ipn_data['payer_email'] . '</td></tr><tr><td align="left" style="font-weight:bold; font-variant:small-caps; background:#ffffff">' . mysql_real_escape_string(INV_TXN_ID) . '</td><td align="left" style="background:#ffffff">' . $p->ipn_data['txn_id'] . '</td></tr></table>'; mysql_query("UPDATE bsi_invoice SET invoice = '{$invoiceHTML}' WHERE booking_id='" . $p->ipn_data['invoice'] . "'"); $emailBody = "Dear " . $invoiceROWS['client_name'] . ",<br><br>"; $emailBody .= html_entity_decode($emailContent['body']) . "<br><br>"; $emailBody .= $invoiceHTML; $emailBody .= "<br><br>" . mysql_real_escape_string(PP_REGARDS) . ",<br>" . $bsiCore->config['conf_hotel_name'] . '<br>' . $bsiCore->config['conf_hotel_phone']; $emailBody .= "<br><br><font style=\"color:#F00; font-size:10px;\">[ " . mysql_real_escape_string(PP_CARRY) . " ]</font>"; $flag = 1; $bsiMail->sendEMail($invoiceROWS['client_email'], $emailContent['subject'], $emailBody, $p->ipn_data['invoice'], $flag); /* Notify Email for Hotel about Booking */ $notifyEmailSubject = "Booking no." . $p->ipn_data['invoice'] . " - Notification of Room Booking by " . $invoiceROWS['client_name']; $bsiMail->sendEMail($bsiCore->config['conf_notification_email'], $notifyEmailSubject, $invoiceHTML); //***************************************************************************************** } elseif ($p->ipn_data['payment_status'] == "Refunded") { mysql_query("update paypal_payment set payment_success='0' where invoice=" . $p->ipn_data['invoice']); } elseif ($p->ipn_data['payment_status'] == "Reversed") { mysql_query("update paypal_payment set payment_success='0' where invoice=" . $p->ipn_data['invoice']); } } break; }
public function booking_cencel_delete($type) { global $bsiCore; global $bsiMail; switch ($type) { case 1: $bsiMail = new bsiMail(); $is_cancel = mysql_query("update bsi_bookings set is_deleted=true where booking_id=" . $bsiCore->ClearInput($_GET['cancel'])); if ($is_cancel) { $cust_details = mysql_fetch_assoc(mysql_query("select * from bsi_invoice where booking_id=" . $bsiCore->ClearInput($_GET['cancel']))); $email_details = mysql_fetch_assoc(mysql_query("select * from bsi_email_contents where id=2")); $cancel_emailBody = "Dear " . $cust_details['client_name'] . "<br>"; $cancel_emailBody .= html_entity_decode($email_details['email_text']) . "<br>"; $cancel_emailBody .= "<b>Your Booking Details:</b><br>" . $cust_details['invoice'] . "<br>"; $cancel_emailBody .= "<b>Regards</b><br>" . $bsiCore->config['conf_hotel_name'] . "<BR>" . $bsiCore->config['conf_hotel_phone'] . "<br>"; $bsiMail->sendEMail($cust_details['client_email'], $email_details['email_subject'], $cancel_emailBody); } break; case 2: mysql_query("delete from bsi_bookings where booking_id=" . $bsiCore->ClearInput($_REQUEST['delete'])); mysql_query("delete from bsi_reservation where bookings_id=" . $bsiCore->ClearInput($_REQUEST['delete'])); mysql_query("delete from bsi_invoice where booking_id=" . $bsiCore->ClearInput($_REQUEST['delete'])); break; } }
$cc_holder_name = $_POST['cc_holder_name']; $CardType = $_POST['CardType']; $cc_exp_dt = $_POST['cc_exp_dt']; $cc_ccv = $_POST['cc_ccv']; $cardnum_enc = $bsiCore->encryptCard(mysql_real_escape_string($_POST['CardNumber'])); $cardno_len = strlen($cardnum) - 4; $creditcard_no = substr($cardnum, $cardno_len); $star = ''; for ($i = 0; $i < $cardno_len; $i++) { $star .= '#'; } $show_cardno = $star . $creditcard_no; $payoptions = "Credit Card"; $table = '<br /><table style="font-family:Verdana, Geneva, sans-serif; font-size: 12px; background:#999999; width:700px; border:none;" cellpadding="4" cellspacing="1"><tr><td align="left" colspan="2" style="font-weight:bold; font-variant:small-caps; background:#eeeeee;">' . mysql_real_escape_string(INV_PAY_DETAILS) . '</td></tr><tr><td align="left" width="30%" style="font-weight:bold; font-variant:small-caps;background:#ffffff;">' . mysql_real_escape_string(INV_PAY_OPTION) . '</td><td align="left" style="background:#ffffff;">' . $payoptions . '</td></tr><tr><td align="left" width="30%" style="font-weight:bold; font-variant:small-caps;background:#ffffff;">' . mysql_real_escape_string(CC_NUMBER) . '</td><td align="left" style="background:#ffffff;">' . $show_cardno . '</td></tr></table>'; $updatedInvoice = $invoiceROWS['invoice'] . $table; mysql_query("Update bsi_invoice SET invoice='{$updatedInvoice}' WHERE booking_id='" . $booking_id . "'"); mysql_query("insert into bsi_cc_info(booking_id, cardholder_name, card_type, card_number, expiry_date, ccv2_no) values('" . mysql_real_escape_string($_POST['bookingid']) . "', '" . mysql_real_escape_string($_POST['cc_holder_name']) . "', '" . mysql_real_escape_string($_POST['CardType']) . "', '" . $cardnum_enc . "', '" . mysql_real_escape_string($_POST['cc_exp_dt']) . "', '" . mysql_real_escape_string($_POST['cc_ccv']) . "')"); $emailBody .= $table; $emailBody .= '<br><br>' . mysql_real_escape_string(PP_REGARDS) . ',<br>' . $bsiCore->config['conf_hotel_name'] . '<br>' . $bsiCore->config['conf_hotel_phone']; $emailBody .= '<br><br><font style=\\"color:#F00; font-size:10px;\\">[ ' . mysql_real_escape_string(PP_CARRY) . ' ]</font>'; $returnMsg = $bsiMail->sendEMail($invoiceROWS['client_email'], $subject, $emailBody); if ($returnMsg == true) { mysql_query("update bsi_bookings set payment_success=true where booking_id=" . $booking_id); $notifyEmailSubject = "Booking no." . $_POST['bookingid'] . " - Notification of Room Booking by " . $invoiceROWS['client_name']; $notifynMsg = $bsiMail->sendEMail($bsiCore->config['conf_notification_email'], $notifyEmailSubject, $invoiceROWS['invoice']); header('Location: booking-confirm.php?success_code=1'); die; } else { header('Location: booking-failure.php?error_code=25'); die; }