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