<?php
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['id'])) {
$status = array('0' => 'Awaiting Approval', '1' => 'Approved', '2' => 'Declined');
$commonController = new CommonController();
$resultReviews = $commonController->getTableData(array('table' => 'booking_requests br LEFT JOIN establishments e ON e.id = br.establishment_id', 'select' => 'br.*, e.name as establishment_name', 'where' => array('br.id=' . $_POST['id'])));
if (mysql_num_rows($resultReviews)) {
$row = mysql_fetch_array($resultReviews);
$rowBookingStatusMail = 'Hi ' . $row['from_name'] . ',<br />';
$rowBookingStatusMail .= 'Thank you for your booking request for <strong>
<a href="' . SITE_URL . 'detail.php?q=' . base64_encode($row['listing_id']) . '">' . $row['establishment_name'] . '</a></strong> on ' . date('m-d-Y', strtotime($row['sent_date'])) . '<br />';
$rowBookingStatusMail .= 'Your requirement meesage was as below, <br />';
$rowBookingStatusMail .= $row['message'] . '<br /><br /><br />';
$rowBookingStatusMail .= 'Your current request status is : ' . $status[$_POST['status']];
$updateData['table'] = 'booking_requests';
$updateData['id'] = $_POST['id'];
$updateData['status'] = $_POST['status'];
$updateData['status_changed_date'] = date('Y-m-d h:i:s');
$commonController->insertUpdateData($updateData);
$commonController->sentMail(array('to' => $row['from_email'], 'subject' => $row['establishment_name'] . ' Booking Request', 'message' => $rowBookingStatusMail));
echo '1';
} else {
echo '0';
}
} else {
echo '0';
}
$resultPackage = $commonController->getTableData(array('table' => 'packages', 'where' => array('price=0')));
if (mysql_num_rows($resultPackage) > 0) {
$rowPackages = mysql_fetch_array($resultPackage);
$data['subscription_id'] = $rowPackages['id'];
$data['subscribed_on'] = date('Y-m-d h:i:s');
}
if ($commonController->insertUpdateData($data) > 0) {
if ($sendRegisterMail) {
$registrationMsg = 'Hi ' . $data['username'] . ', <br /><br />';
$registrationMsg .= 'You have been successfully registered with Snoozeover site. <br />';
$registrationMsg .= 'email: ' . $data['email'] . ' <br />';
$registrationMsg .= 'password: '******' <br />';
$registrationMsg .= 'Please <a href="' . SITE_URL . '">click here</a> to have a look to our SnoozeOver <br />';
$registrationMsg .= 'Thank you <br />';
$registrationMsg .= '<br /><br /><small><i>please don\'t replay to this mail</i></small>';
$commonController->sentMail(array('to' => $data['email'], 'subject' => 'Registration Mail', 'message' => $registrationMsg));
}
header("location:listingUser.php?userType=" . $_REQUEST['userType'] . "&save=success");
} else {
$msg = 'Something went wrong. We are looking into it';
$class = 'danger';
}
} else {
$class = 'danger';
}
}
}
?>
<div class="row">
<div class="col-md-12">
<h1 class="page-header">
<?php
include 'header.php';
$commonController = new CommonController();
if (!empty($_POST['btnContactUs'])) {
$resultAdmin = $commonController->getTableData(array('table' => 'admin-user', 'where' => array('id=1')));
if (mysql_num_rows($resultAdmin)) {
$row = mysql_fetch_assoc($resultAdmin);
$commonController->sentMail(array('to' => $row['email'], 'subject' => $_POST['txtSubject'], 'from' => $_POST['txtFrom'], 'message' => $_POST['txtMessage']));
$msg = "Thank you for contacting us. We will get into touch with you soon.";
$class = 'success';
} else {
$msg = "Sorry..!! But unfortunately something went wrong while processing your request. Please try after sometime";
$class = 'danger';
}
}
?>
<div class="inner-page">
<h1>Contact Us</h1>
<p>Happy to help you.</p> <br />
<form method="POST" class="contact-us col-lg-4">
<div class="checkin-form margin-1">
<?php
$name = '';
$email = '';
if (!empty($_SESSION['id'])) {
$dataUser['table'] = 'users';
$dataUser['where'] = array('id=' . $_SESSION['id'], 'status=1', 'is_delete=0');
$resultUser = $commonController->getTableData($dataUser);
if (mysql_num_rows($resultUser) > 0) {
<?php
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['id'])) {
$commonController = new CommonController();
$resultReviews = $commonController->getTableData(array('table' => 'establishments_reviews er LEFT JOIN users u ON u.id = er.reviewed_by LEFT JOIN establishments e ON e.id = er.establishment_id', 'select' => 'er.review, er.created_date, u.username, er.id, u.email, e.name as establishment_name, er.establishment_id', 'where' => array('er.id=' . $_POST['id'])));
if (mysql_num_rows($resultReviews)) {
$rowReview = mysql_fetch_array($resultReviews);
$reviewMail = 'Hi ' . $rowReview['username'] . ',<br />';
$reviewMail .= 'Thank you for your review on <strong>
<a href="' . SITE_URL . 'detail.php?q=' . base64_encode($rowReview['establishment_id']) . '">' . $rowReview['establishment_name'] . '</a></strong> on ' . date('m-d-Y', strtotime($rowReview['created_date'])) . '<br />';
$reviewMail .= 'Your review was as below, <br />';
$reviewMail .= $rowReview['review'] . '<br /><br /><br />';
$reviewMail .= $_POST['msg'];
$commonController->sentMail(array('to' => $rowReview['email'], 'subject' => $rowReview['establishment_name'] . ' Review Reply', 'message' => $reviewMail));
echo '1';
} else {
echo '0';
}
} else {
echo '0';
}
$data['from_name'] = $_POST['from_name'];
$data['check_in'] = date('Y-m-d h:i:s', strtotime($_POST['check_in']));
$data['check_out'] = date('Y-m-d h:i:s', strtotime($_POST['check_out']));
$data['sent_date'] = date('Y-m-d h:i:s');
$data['status'] = 0;
$data['establishment_id'] = $_POST['listing_id'];
$data['thread_id'] = strtotime(date("Y-m-d h:i:s"));
$data['status_changed_date'] = date('Y-m-d h:i:s');
$result = $commonController->getTableData(array('select' => 'u.id, u.username, u.email, e.name as establishment_name', 'table' => 'establishments e INNER JOIN users u ON u.id = e.user_id', 'where' => array('e.id=' . $_POST['listing_id'])));
if (!empty($result) && mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$data['to_id'] = $row['id'];
$data['to_name'] = $row['username'];
$data['to_email'] = $row['email'];
}
$msg = "Hi " . $data['to_name'] . ",<br /><br />";
$msg .= $data['from_name'] . " has contacted you for <a href='" . SITE_URL . "detail.php?q=" . base64_encode($listingId) . "'>" . $row['establishment_name'] . "</a> listing. <br /><br />";
$msg .= "Following are the details, <br />";
$msg .= "<ul><li>Rooms: " . $_POST['bookingRooms'] . "</li><li>Adults: " . $_POST['bookingAdults'] . "</li><li>Children: " . $_POST['bookingChildrens'] . "</li><li>Special Request: " . $_POST['bookingMessage'] . "</li></ul>";
$data['message'] = mysql_escape_string($msg);
if ($commonController->insertUpdateData($data) > 0) {
// sent mail
$commonController->sentMail(array('to' => $data['to_email'], 'from' => $data['from_email'], 'subject' => 'Booking Request regarding ' . $row['establishment_name'], 'message' => $msg));
$array = array("d" => "1");
} else {
$array = array("d" => "0");
}
} else {
$array = array("d" => "0");
}
echo json_encode($array);
if (mysql_num_rows($resultUser) > 0) {
$rowUsers = mysql_fetch_array($resultUser);
$password = $commonController->randomPassword();
$data['id'] = $rowUsers['id'];
$data['password'] = md5($password);
$data['updated_date'] = date('Y-m-d h:i:s');
$data['table'] = 'users';
if ($commonController->insertUpdateData($data)) {
$registrationMsg = 'Hi ' . $rowUsers['username'] . ', <br /><br />';
$registrationMsg .= 'You have been successfully reseted your password. <br />';
$registrationMsg .= 'email: ' . $rowUsers['email'] . ' <br />';
$registrationMsg .= 'password: '******' <br />';
$registrationMsg .= 'Please <a href="' . SITE_URL . '">click here</a> to have a look to our SnoozeOver <br />';
$registrationMsg .= 'Thank you <br />';
$registrationMsg .= '<br /><br /><small><i>please don\'t replay to this mail</i></small>';
$commonController->sentMail(array('to' => $rowUsers['email'], 'subject' => 'Forgot Password', 'message' => stripslashes($registrationMsg)));
$msg = "Password changed successfully and had been mail to you.";
$class = 'success';
} else {
$msg = "Something went wrong, we are looking into it.";
$class = 'danger';
}
} else {
$msg = "Sorry, but we didn't find the email address associates with us. Can you please try to login or register?";
$class = 'danger';
}
}
}
?>
<div class="inner-page">
<h1>Forgot Password?</h1><br />
}
}
}
$updatedData = json_encode(array_merge($jsonObj, $commonKey));
$saveScheduleData['table'] = 'schedule';
$saveScheduleData['id'] = $scheduleId;
$saveScheduleData['data'] = $updatedData;
$commonController->insertUpdateData($saveScheduleData);
}
$dataOrder['ordered_date'] = date('Y-m-d h:i:s');
$commonController->insertUpdateData($dataOrder);
$msg = 'Hi ' . $rowUsers['username'];
$msg .= '<br /><br />Thank you for booking at our site for ' . $rowEstablishment['name'] . ' on ' . $dataOrder['check_in_date'] . ' to ' . $dataOrder['check_out_date'];
$msg .= '<br />Your transaction id is #' . $_POST["txn_id"];
$msg .= 'Please <a href="' . SITE_URL . '">click here</a> to have a look to our SnoozeOver <br />';
$commonController->sentMail(array('to' => $rowUsers['email'], 'subject' => 'Booking Information', 'message' => $msg));
$subject = 'Instant Payment Notification - Recieved Payment';
//$p->send_report($subject); // Send the notification about the transaction
header('location:' . SITE_URL . 'post_payment.php?success=true&txn_id=' . $_POST["txn_id"]);
} else {
$subject = 'Instant Payment Notification - Payment Fail';
//$p->send_report($subject); // failed notification
header('location:' . SITE_URL . 'post_payment.php?success=false');
}
break;
case "cancel":
// case cancel to show user the transaction was cancelled
echo "<h1>Transaction Cancelled<h1>";
header('location:' . SITE_URL . 'cancel_payment.php');
break;
case "ipn":
