if (empty($_SESSION['id'])) {
header('location:' . SITE_URL . 'error.php');
}
?>
<h1>Dashboard </h1>
<hr />
<?php
$id = $_SESSION['id'];
$data['select'] = 'u.*, c.name country_name, s.name state_name, city.name city_name, d.name district_name';
$data['table'] = 'users u LEFT JOIN countries c ON u.country_id = c.id
LEFT JOIN states s ON u.state_id = s.id
LEFT JOIN cities city ON u.city_id = city.id
LEFT JOIN districts d ON u.district_id = d.id';
$data['where'] = array('u.id = ' . $id, 'u.is_delete=0', 'u.status=1');
$commonController = new CommonController();
$dataUser = $commonController->getTableData($data);
$user = mysql_fetch_assoc($dataUser);
?>
<div class='row'>
<div class="col-md-4">
<div class="panel panel-default">
<div class="panel-heading">
Profile
</div>
<div class="panel-body">
<a class="fancybox" href="<?php
echo SITE_URL . (!empty($user['image']) ? $commonController->getUsersFolderPath($user['image']) : 'images/common/no-member-image.png');
?>
"
style="float:left; margin:0 10px 0 0;">
<img src="<?php
<?php
include 'assets/config.php';
if (!empty($_POST['establishment_id'])) {
$commonController = new CommonController();
$data = $commonController->getTableData(array('table' => 'establishment_rooms', 'where' => array('establishment_id=' . $_POST['establishment_id'])));
echo '<option value="0">-select-</option>';
while ($row = mysql_fetch_array($data)) {
echo '<option value="' . $row['id'] . '">' . $row['name'] . '</option>';
}
} else {
echo "";
}
<?php
include 'assets/config.php';
require_once "paypal_class.php";
$commonController = new CommonController();
$resultPaypalSetting = $commonController->getTableData(array('table' => 'paypal_settings'));
if (mysql_num_rows($resultPaypalSetting) > 0) {
$rowPaypalSetting = mysql_fetch_array($resultPaypalSetting);
}
DEFINE('EMAIL_ADD', $rowPaypalSetting['business_email']);
// define any notification email
DEFINE('PAYPAL_EMAIL_ADD', $rowPaypalSetting['business_email']);
// facilitator email which will receive payments change this email to a live paypal account id when the site goes live
$p = new paypal_class();
// paypal class
$p->admin_mail = EMAIL_ADD;
// set notification email
$action = $_REQUEST["action"];
switch ($action) {
case "process":
// case process insert the form data in DB and process to the paypal
// mysql_query("INSERT INTO `purchases` (`invoice`, `product_id`, `product_name`, `product_quantity`, `product_amount`, `payer_fname`, `payer_lname`, `payer_address`, `payer_city`, `payer_state`, `payer_zip`, `payer_country`, `payer_email`, `payment_status`, `posted_date`) VALUES ('".$_POST["invoice"]."', '".$_POST["product_id"]."', '".$_POST["product_name"]."', '".$_POST["product_quantity"]."', '".$_POST["product_amount"]."', '".$_POST["payer_fname"]."', '".$_POST["payer_lname"]."', '".$_POST["payer_address"]."', '".$_POST["payer_city"]."', '".$_POST["payer_state"]."', '".$_POST["payer_zip"]."', '".$_POST["payer_country"]."', '".$_POST["payer_email"]."', 'pending', NOW())");
$this_script = SITE_URL . 'paypal.php';
$p->add_field('business', PAYPAL_EMAIL_ADD);
// Call the facilitator eaccount
$p->add_field('cmd', $_POST["cmd"]);
// cmd should be _cart for cart checkout
$p->add_field('upload', '1');
$p->add_field('return', $this_script . '?action=success');
// return URL after the transaction got over
$p->add_field('cancel_return', $this_script . '?action=cancel');
}
}
if (!empty($_REQUEST['viewed']) && ($_REQUEST['viewed'] = "1")) {
if (!empty($_SESSION['id'])) {
$user_id = $_SESSION['id'];
$tables .= ' LEFT JOIN users_viewed uv ON uv.establishment_id = e.id';
$whereData[] = 'uv.user_id = "' . $user_id . '"';
}
}
$data['select'] = $select;
$data['table'] = $tables;
$data['where'] = $whereData;
if (!empty($order)) {
$data['order'] = $order;
}
$resultSearch = $commonController->getTableData($data);
?>
<form method="post" action="map_listing.php" class="form filter-form">
<div class="filter-wrapper">
<div class="filter-left">
<div class="filter-lable">Refine</div>
<div class="filter-select">
<input type="text" id="searchField" name="searchField" placeholder="Where to Snooze" class="filter-feild search-location" value="<?php
echo $_POST['searchField'];
?>
">
</div>
<div class="filter-calender">
<input name="check-in" placeholder="Check In" type="text" class="filter-feild calender-icon check-in filter-check-in" value="<?php
echo !empty($_POST['check-in']) ? $_POST['check-in'] : '';
<?php
include 'assets/config.php';
$commonController = new CommonController();
if (!empty($_POST['btnLogin']) && !empty($_POST['txtEmailUsername']) && !empty($_POST['txtPassword'])) {
$resultData = $commonController->getTableData(array('table' => 'users', 'where' => array('(`username`="' . $_POST['txtEmailUsername'] . '" OR `email`="' . $_POST['txtEmailUsername'] . '")', '`password`="' . md5($_POST['txtPassword']) . '"', '`status` = 1', '`is_delete` = 0')));
if (mysql_num_rows($resultData)) {
$rowLogin = mysql_fetch_array($resultData);
$_SESSION['id'] = $rowLogin['id'];
$_SESSION['username'] = $rowLogin['username'];
$_SESSION['type'] = $rowLogin['type'];
$_SESSION['image'] = $rowLogin['image'];
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title>Snoozover</title>
<link href='http://fonts.googleapis.com/css?family=Raleway:500,600,700,400,300' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="<?php
echo SITE_URL;
?>
assets/css/lightslider.css"/>
<!-- Important Owl stylesheet -->
$order = $_POST['ddlSortBy'];
if ($order == 'price asc') {
$order = 'MIN(rate) ASC';
} else {
if ($order == 'price desc') {
$order = 'MIN(rate) DESC';
}
}
}
$data['select'] = $select;
$data['table'] = $tables;
$data['where'] = $whereData;
if (!empty($order)) {
$data['order'] = $order;
}
$resultSearch = $commonController->getTableData($data);
if (mysql_num_rows($resultSearch)) {
$index = 0;
while ($row = mysql_fetch_assoc($resultSearch)) {
$mapResult[$index] = $row;
$mapResult[$index]['encoded_id'] = base64_encode($row['id']);
$dataDeal['select'] = 'd.name as deal_name, d.value as discount ';
$dataDeal['table'] = 'deals d';
$dataDeal['where'] = array('d.id = ' . $row['deals'], 'd.status = 1');
$dataDeal['limit'] = '0,1';
$resultDeal = $commonController->getTableData($dataDeal);
if (mysql_num_rows($resultDeal)) {
$rowDeal = mysql_fetch_array($resultDeal);
$mapResult[$index]['discount'] = $rowDeal['discount'];
$mapResult[$index]['deal_name'] = $rowDeal['deal_name'];
}
header('location: index.php');
}
}
if (empty($_GET['q'])) {
header('location:' . ADMIN_SITE_URL . '/listingUser.php?userType=' . $_REQUEST['userType']);
}
include 'header.php';
$id = base64_decode($_GET['q']);
$data['select'] = 'users.*, countries.name country_name, states.name state_name, cities.name city_name, districts.name district_name,' . "(SELECT COUNT(id) FROM users_viewed WHERE user_id = users.id) AS viewCount," . "(SELECT COUNT(id) FROM establishments_reviews WHERE reviewed_by = users.id) AS reviewCount," . "(SELECT COUNT(id) FROM establishments WHERE user_id = users.id) AS listingCount," . "(SELECT COUNT(id) FROM establishment_favourite WHERE user_id = users.id) AS favListingCount," . "(SELECT COUNT(id) FROM booking_requests WHERE from_id = users.id AND status='0') AS awaitingBookingCount," . "(SELECT COUNT(id) FROM booking_requests WHERE from_id = users.id AND status='1') AS approvedBookingCount," . "(SELECT COUNT(id) FROM booking_requests WHERE from_id = users.id AND status='2') AS declinedBookingCount";
$data['table'] = 'users LEFT JOIN countries ON users.country_id = countries.id
LEFT JOIN states ON users.state_id = states.id
LEFT JOIN cities ON users.city_id = cities.id
LEFT JOIN districts ON users.district_id = districts.id';
$data['where'] = array('users.id = ' . $id);
$commonController = new CommonController();
$dataUser = $commonController->getTableData($data);
$user = mysql_fetch_assoc($dataUser);
?>
<div class="row">
<div class="col-md-12 page-header">
<h1 class="pull-left"><?php
echo $user['firstname'] != '' ? $user['firstname'] . "'s" : "User's";
?>
Details</h1>
<a class="btn btn-primary functionality-link pull-right user-detail-back-btn" href='<?php
echo ADMIN_SITE_URL . 'listingUser.php?userType=' . $_REQUEST['userType'];
?>
' title="Back"><i class="fa fa-arrow-left"></i></a>
</div>
</div>
<div class='row'>
include 'assets/config.php';
if (!empty($_POST['listing_id'])) {
$listingId = $_POST['listing_id'];
$commonController = new CommonController();
$data['table'] = 'booking_requests';
$data['from_id'] = $_POST['from_id'];
$data['from_email'] = $_POST['from_email'];
$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");
<?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';
}
<?php
include 'assets/config.php';
if (!empty($_SESSION['id'])) {
$commonController = new CommonController();
$result = $commonController->getTableData(array('table' => 'establishment_favourite', 'where' => array('id=' . $_POST['id'])));
if (mysql_num_rows($result) == 0) {
$data['table'] = 'establishment_favourite';
$data['establishment_id'] = $_POST['eid'];
$data['user_id'] = $_SESSION['id'];
echo $commonController->insertUpdateData($data);
} else {
$data['table'] = 'establishment_favourite';
$data['id'] = $_POST['id'];
echo $commonController->deleteData($data);
}
} else {
echo '0';
}
<?php
include 'header.php';
if (!empty($_SESSION['id'])) {
header('location:' . SITE_URL);
}
$commonController = new CommonController();
if (!empty($_POST['btnSubmit'])) {
if (!empty($_POST['txtEmail'])) {
$resultUser = $commonController->getTableData(array('table' => 'users', 'where' => array('email="' . $_POST['txtEmail'] . '"', 'status=1', 'is_delete=0')));
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';
<h2>Find a Place to Snooze</h2>
<form method="post" action="listing.php" class="form">
<div class="search-row">
<div class="search-text">
<input name="searchField" type="text" class="search-feild border-right border-corner-left" id="searchField" placeholder="Where to Snooze">
<input type="hidden" name="hdnLatitude" id="hdnLatitude" value="" />
<input type="hidden" name="hdnLongitude" id="hdnLongitude" value="" />
</div>
<div class="search-select">
<select id="myDropdown" class="search-feild">
<option value="" data-imagesrc="<?php
echo $commonController->resize_image('images/common/no-accomodation-image.png', 16);
?>
">Accommodation Type</option>
<?php
$dataAccommodationType = $commonController->getTableData(array('table' => 'accommodations', 'order' => 'name', 'where' => array('status=1', 'is_delete=0')));
if (!empty($dataAccommodationType)) {
while ($row = mysql_fetch_array($dataAccommodationType)) {
?>
<option value="<?php
echo $row['id'];
?>
" data-imagesrc="<?php
echo $commonController->resize_image(!empty($row['logo']) ? $commonController->getAccomodationFolderPath($row['logo']) : 'images/common/no-accomodation-image.png', 16);
?>
" ><?php
echo $row['name'];
?>
</option>
<?php
}
if ($_POST['txtDuration'] > 0) {
$dataUpdate['duration'] = $_POST['txtDuration'];
if ($adminController->insertUpdateData($dataUpdate)) {
$msg = 'Saved successfully';
$class = 'success';
} else {
$msg = 'Something went wrong. We are looking into it';
$class = 'danger';
}
} else {
$msg = 'Durations in days should not be zero';
$class = 'danger';
}
}
$commonController = new CommonController();
$data = $commonController->getTableData(array('table' => "packages", 'where' => array('price > 0'), 'order' => 'duration'));
?>
<script type="text/javascript">
function confirmDelete(id){
var r = confirm("Are you sure you want to delete this package!");
if (r == true) {
window.location='packages.php?id='+id+'&action=delete';
}
else {
return false;
}
}
</script>
<div class="row">
<div class="col-md-12">
<h1 class="page-header">Packages Management<br /><small><i>Add, Edit and Delete packages</i></small></h1>
<?php
include 'header.php';
if (empty($_SESSION['id'])) {
header('location:' . SITE_URL . 'error.php');
}
$id = $_SESSION['id'];
$data['select'] = 'u.*, c.name country_name, s.name state_name, city.name city_name, d.name district_name';
$data['table'] = 'users u LEFT JOIN countries c ON u.country_id = c.id
LEFT JOIN states s ON u.state_id = s.id
LEFT JOIN cities city ON u.city_id = city.id
LEFT JOIN districts d ON u.district_id = d.id';
$data['where'] = array('u.id = ' . $id, 'u.is_delete=0', 'u.status=1');
$commonController = new CommonController();
$dataUser = $commonController->getTableData($data);
$user = mysql_fetch_assoc($dataUser);
?>
<div class="inner-page">
<h1>Messages from Snoozeover</h1><br />
<?php
$dataMessage['table'] = 'email_records';
$dataMessage['where'] = array('`to` LIKE "%' . $user['email'] . '%"');
$dataMessage['order'] = 'send_on DESC';
$dataResult = $commonController->getTableData($dataMessage);
if (mysql_num_rows($dataResult)) {
?>
<div id="accordion">
<?php
while ($row = mysql_fetch_array($dataResult)) {
?>
<?php
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['eid'])) {
$commonController = new CommonController();
$resultRate = $commonController->getTableData(array('table' => 'establishment_ratings', 'where' => array('user_id=' . $_SESSION['id'], 'establishment_id=' . $_POST['eid'])));
$existsId = 0;
if (mysql_num_rows($resultRate) > 0) {
$rowRate = mysql_fetch_array($resultRate);
$existsId = $rowRate['id'];
}
$dataRating['table'] = 'establishment_ratings';
$dataRating['establishment_id'] = $_POST['eid'];
$dataRating['user_id'] = $_SESSION['id'];
$dataRating['ratings'] = $_POST['score'];
if (!empty($_POST['id']) && $_POST['id'] > 0) {
$dataRating['id'] = $_POST['id'];
}
if ($existsId > 0 && !empty($_POST['id'])) {
echo $commonController->insertUpdateData($dataRating);
} else {
if ($existsId > 0 && empty($_POST['id'])) {
echo '0';
} else {
if ($existsId == 0) {
echo $commonController->insertUpdateData($dataRating);
}
}
}
} else {
echo '0';
if (mysql_num_rows($resultPaypalSetting) > 0) {
$rowPaypalSetting = mysql_fetch_assoc($resultPaypalSetting);
}
$roomsResult = $commonController->getTableData(array('table' => 'establishment_rooms', 'where' => array('id=' . $room_id)));
if (mysql_num_rows($roomsResult) > 0) {
$rowRooms = mysql_fetch_assoc($roomsResult);
}
$id = $_SESSION['id'];
$data['select'] = 'u.*, c.name country_name, s.name state_name, city.name city_name, d.name district_name';
$data['table'] = 'users u LEFT JOIN countries c ON u.country_id = c.id
LEFT JOIN states s ON u.state_id = s.id
LEFT JOIN cities city ON u.city_id = city.id
LEFT JOIN districts d ON u.district_id = d.id';
$data['where'] = array('u.id = ' . $id, 'u.is_delete=0', 'u.status=1');
$commonController = new CommonController();
$dataUser = $commonController->getTableData($data);
$user = mysql_fetch_assoc($dataUser);
$price = 0;
$resultReservation = $commonController->getTableData(array('table' => 'reservations', 'where' => array('establishment_id=' . $establishment_id)));
if (mysql_num_rows($resultReservation) > 0) {
$rowReservation = mysql_fetch_assoc($resultReservation);
$reservationData = json_decode($rowReservation['data'], true);
$price = $reservationData[0]['price_total'];
}
//die();
?>
<h1>Processing.. Please wait..!!</h1>
<form action="booking_paypal.php?sandbox=<?php
echo $rowPaypalSetting['mode'] == 0 ? '1' : '0';
?>
" method="post" id="myForm" name="myForm" style="display:none;">
$data['email'] = $_REQUEST['email'];
$data['created_date'] = date('Y-m-d h:i:s');
$data['password'] = md5($password);
$data['type'] = empty($_REQUEST['t']) ? '0' : '1';
$data['status'] = 1;
$data['subscribed_on'] = date('Y-m-d h:i:s');
$data['is_delete'] = 0;
$data['table'] = 'users';
if ($_REQUEST['st'] == 'fb') {
$data['facebook_id'] = $_REQUEST['id'];
} else {
if ($_REQUEST['st'] == 'google') {
$data['google_id'] = $_REQUEST['id'];
}
}
$resultUser = $commonController->getTableData(array('table' => $data['table'], 'where' => array('email="' . $_REQUEST['email'] . '"')));
if (mysql_num_rows($resultUser) > 0) {
$rowUser = mysql_fetch_array($resultUser);
$_SESSION['id'] = $rowUser['id'];
$_SESSION['type'] = $rowUser['type'];
$_SESSION['username'] = $rowUser['username'];
$_SESSION['image'] = $rowUser['image'];
} else {
// insert if not exists
if ($adminController->checkRecordUniqueNess(array('table' => $data['table'], 'column' => 'email', 'value' => $data['email'])) == 0) {
$insertedId = $commonController->insertUpdateData($data);
if ($insertedId > 0) {
$registrationMsg = 'Hi ' . $data['username'] . ', <br /><br />';
$registrationMsg .= 'You have been successfully registered with Snoozeover site. <br />';
$registrationMsg .= 'email: ' . $data['email'] . ' <br />';
$registrationMsg .= 'password: '******' <br />';
<?php
include 'header.php';
if (empty($_GET['q'])) {
header('location:' . SITE_URL);
}
$commonController = new CommonController();
$id = base64_decode($_GET['q']);
$data['table'] = 'establishments e';
$data['where'] = array('e.is_delete = 0', 'e.status = 1', 'e.id=' . $id);
$resultData = $commonController->getTableData($data);
$dataGallery['table'] = 'establishments_gallery';
$dataGallery['where'] = array('establishment_id=' . $id);
$resultGalleryData = $commonController->getTableData($dataGallery);
if (mysql_num_rows($resultGalleryData)) {
while ($rowGallery = mysql_fetch_array($resultGalleryData)) {
if ($rowGallery['type'] == 1) {
$existingGallery['id'][] = $rowGallery['id'];
$existingGallery['path'][] = $rowGallery['path'];
} else {
$existingVideoGallery['id'] = $rowGallery['id'];
$existingVideoGallery['path'] = $rowGallery['path'];
}
}
}
$resultReviews = $commonController->getTableData(array('select' => 'er.*, u.username', 'table' => 'establishments_reviews er LEFT JOIN `users` u ON u.id=er.reviewed_by', 'where' => array('er.establishment_id=' . $id), 'order' => 'created_date desc'));
$dataFacilities['table'] = 'establishments_facilities ef LEFT JOIN facilities f ON f.id = ef.facility_id';
$dataFacilities['where'] = array('ef.establishment_id=' . $id);
$resultFacilitiesData = $commonController->getTableData($dataFacilities);
$dataLanguages['table'] = 'establishments_languages el';
$dataLanguages['where'] = array('el.establishment_id=' . $id);
<?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';
}
$data['child_allowed'] = '1';
$data['child_age_from'] = '';
$data['child_age_to'] = '';
$data['stay_type'] = '';
$data['stay_value'] = '';
$data['cancellation_policy'] = '';
$data['things_to_do'] = '';
$data['deals'] = '';
$data['table'] = 'establishments';
$hdnUserName = '';
$hdnEmail = '';
$commonController = new CommonController();
$adminController = new AdminController();
/*-------- fetch meals------*/
$selectmeals = '';
$mealsResult = $commonController->getTableData(array('table' => 'meals', 'where' => array("status='1'")));
if (!empty($mealsResult)) {
while ($rowmeals = mysql_fetch_array($mealsResult)) {
$selectmeals .= '<option value="' . $rowmeals['id'] . '" > ' . $rowmeals['meal'] . '</option>';
}
}
/*-------- fetch days------*/
$selectdays = '';
$timestamp = strtotime('next Monday');
for ($i = 0; $i < 7; $i++) {
$selectdays .= '<option value="' . sprintf("%s", strftime('%A', $timestamp)) . '" > ' . sprintf("%s", strftime('%A', $timestamp)) . '</option>';
$timestamp = strtotime('+1 day', $timestamp);
}
?>
<link href="assets/css/jquery.filer.css" type="text/css" rel="stylesheet" />
<link href="assets/css/themes/jquery.filer-dragdropbox-theme.css" type="text/css" rel="stylesheet" />
<?php
include 'header.php';
$msg = '';
$class = '';
$hdnName = '';
$display = 'style="display:none"';
$data['id'] = '';
$data['name'] = '';
$data['value'] = '';
$data['status'] = '';
$data['table'] = 'deals';
$commonController = new CommonController();
if (!empty($_GET['q'])) {
$data['id'] = base64_decode($_GET['q']);
$result = $commonController->getTableData($data);
if (!empty($result)) {
$row = mysql_fetch_array($result);
$hdnName = $row['name'];
$data['name'] = $row['name'];
$data['value'] = $row['value'];
$data['status'] = $row['status'];
}
}
if (!empty($_POST['btnSubmit'])) {
$data['name'] = $_POST['txtName'];
$data['status'] = $_POST['rdoStatus'];
$data['value'] = $_POST['txtValue'];
if (!empty($_POST['hdnId'])) {
$data['id'] = $_POST['hdnId'];
}
if ($_REQUEST[block] == '1') {
$msg = 'Accommodation activated.';
$class = 'success';
} else {
if ($_REQUEST[block] == '0') {
$msg = 'Accommodation de-activated.';
$class = 'warning';
} else {
if ($_REQUEST[block] == 'fail') {
$msg = 'Could not perform any action on this Accommodation. Please try again.';
$class = 'danger';
}
}
}
$commonController = new CommonController();
$data = $commonController->getTableData(array('table' => "accommodations", 'order' => 'name ASC'));
?>
<script type="text/javascript">
function confirmDelete(id){
var r = confirm("Are you sure you want to delete this accommodation!");
if (r == true) {
window.location='accommodations.php?id='+id+'&action=delete';
}
else {
return false;
}
}
</script>
<div class="row">
<div class="col-md-12">
<h1 class="page-header">Accommodations Management<br /><small><i>Add, Edit and Delete accommodations</i></small></h1>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>S.No</th>
<th>Name</th>
<th>Status</th>
<th>Deleted</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$commonController = new CommonController();
$data = $commonController->getTableData(array('table' => "facilities", 'order' => 'name'));
if (!empty($data)) {
$cnt = 1;
while ($row = mysql_fetch_array($data)) {
?>
<tr>
<td><?php
echo $cnt;
?>
</td>
<td><?php
echo $row['name'];
?>
</td>
<td>
<label class="radio-inline">
<?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) {
$dataBookingInfo['select'] = 'br.*, e.name, e.logo';
$statusLabel = 'All';
$incoming = '';
if (!empty($_GET['q'])) {
$statusLabel = $status[base64_decode($_GET['q'])];
if (empty($_GET['incoming'])) {
$dataBookingInfo['where'] = array('br.status=' . base64_decode($_GET['q']), 'br.from_id=' . $user_id);
} else {
$incoming = 'Incoming ';
$dataBookingInfo['where'] = array('br.status=' . base64_decode($_GET['q']), 'br.to_id=' . $user_id);
}
} else {
$dataBookingInfo['where'] = array('br.from_id=' . $user_id);
}
$dataBookingInfo['order'] = 'br.sent_date DESC';
$resultBookingInfo = $commonController->getTableData($dataBookingInfo);
?>
<div class="inner-page">
<h1><?php
echo ucFirst($incoming . $statusLabel);
?>
Booking Request</h1><br />
<div class="row">
<div class="col-lg-12">
<div class="panel panel-default">
<div class="panel-body">
<?php
if (mysql_num_rows($resultBookingInfo)) {
while ($row = mysql_fetch_array($resultBookingInfo)) {
?>
<div class="listing-item">
$class = 'success';
$display = 'style="display:block"';
} else {
$msg = 'Something went wrong. We are looking into it';
$class = 'danger';
$display = 'style="display:block"';
}
} else {
$class = 'danger';
$display = 'style="display:block"';
}
}
if (!empty($_GET['q'])) {
$data['id'] = base64_decode($_GET['q']);
$data['where'] = array('user_id=' . $user_id);
$result = $commonController->getTableData($data);
if (mysql_num_rows($result)) {
$row = mysql_fetch_array($result);
$data['user_id'] = $user_id;
$data['name'] = $row['name'];
$data['logo'] = $row['logo'];
$data['description'] = $row['description'];
$data['email'] = $row['email'];
$data['country_id'] = $row['country_id'];
$data['state_id'] = $row['state_id'];
$data['city_id'] = $row['city_id'];
$data['district_id'] = $row['district_id'];
$data['latitude'] = $row['latitude'];
$data['longitude'] = $row['longitude'];
$data['telephone'] = $row['telephone'];
$data['mobile'] = $row['mobile'];
<?php
/*
* Title : Booking Calendar PRO (jQuery Plugin)
* Version : 2.0
* File : save.php
* File Version : 2.0
* Created / Last Modified : 29 September 2014
* Author : Dot on Paper
* Copyright : © 2011 Dot on Paper
* Website : http://www.dotonpaper.net
* Description : Save booking data in database.
*/
include '../../assets/config.php';
if (!empty($_POST['dopbcp_calendar_id']) && !empty($_GET['r']) && $_GET['r'] != "0") {
// If calendar ID is received.
$commonController = new CommonController();
$data['table'] = 'schedule';
$data['where'] = array('establishment_id=' . $_POST['dopbcp_calendar_id'], 'room_id=' . $_GET['r']);
$resultSchedule = $commonController->getTableData($data);
if (mysql_num_rows($resultSchedule)) {
$row = mysql_fetch_array($resultSchedule);
$dataSave['id'] = $row['id'];
}
$dataSave['establishment_id'] = $_POST['dopbcp_calendar_id'];
$dataSave['data'] = $_POST['dopbcp_schedule'];
$dataSave['table'] = 'schedule';
$dataSave['room_id'] = $_GET['r'];
$commonController->insertUpdateData($dataSave);
}
$msg = 'Saved successfully';
$class = 'success';
$display = 'style="display:block"';
} else {
$msg = 'Something went wrong. We are looking into it';
$class = 'danger';
$display = 'style="display:block"';
}
} else {
$class = 'danger';
$display = 'style="display:block"';
}
}
if (!empty($_GET['q'])) {
$data['id'] = base64_decode($_GET['q']);
$result = $commonController->getTableData($data);
if (!empty($result)) {
$row = mysql_fetch_array($result);
$data['user_id'] = $row['user_id'];
$data['name'] = $row['name'];
$data['logo'] = $row['logo'];
$data['description'] = $row['description'];
$data['email'] = $row['email'];
$data['country_id'] = $row['country_id'];
$data['state_id'] = $row['state_id'];
$data['city_id'] = $row['city_id'];
$data['district_id'] = $row['district_id'];
$data['latitude'] = $row['latitude'];
$data['longitude'] = $row['longitude'];
$data['telephone'] = $row['telephone'];
$data['mobile'] = $row['mobile'];
$data['city_id'] = '';
$data['district_id'] = '';
$data['fax'] = '';
$data['postal_code'] = '';
$data['facebook_url'] = '';
$data['twitter_url'] = '';
$data['sms_time'] = '';
$data['table'] = 'users';
$hdnUserName = '';
$hdnEmail = '';
$hdnContact = '';
$commonController = new CommonController();
$adminController = new AdminController();
if (!empty($_GET['q'])) {
$data['id'] = base64_decode($_GET['q']);
$result = $commonController->getTableData($data);
if (!empty($result)) {
$row = mysql_fetch_array($result);
$hdnUserName = $row['username'];
$hdnEmail = $row['email'];
$hdnContact = $row['contact'];
$data['firstname'] = $row['firstname'];
$data['lastname'] = $row['lastname'];
$data['username'] = $row['username'];
$data['email'] = $row['email'];
$data['password'] = $row['password'];
$data['image'] = $row['image'];
$data['address'] = $row['address'];
$data['contact'] = $row['contact'];
$data['type'] = $row['type'];
$data['status'] = $row['status'];
">
</div>
<div class="filter-calender">
<input name="check-out" type="text" placeholder="Check Out" class="filter-feild calender-icon check-out filter-check-out" value="<?php
echo !empty($_POST['check-out']) ? $_POST['check-out'] : '';
?>
">
</div>
<div class="filter-lable">
<a class="clear-dates" style="color:#fff; text-decoration:none;">Clear Dates</a>
</div>
<div class="filter-select">
<select id="myDropdownListing" class="filter-feild filter-accommodation">
<option value="">Accommodation Type</option>
<?php
$dataAccommodationType = $commonController->getTableData(array('table' => 'accommodations', 'order' => 'name', 'where' => array('status=1', 'is_delete=0')));
if (!empty($dataAccommodationType)) {
while ($row = mysql_fetch_array($dataAccommodationType)) {
?>
<option <?php
echo !empty($_POST['accommodation']) && $_POST['accommodation'] == $row['id'] || !empty($_POST['filterAccommodation']) && $_POST['filterAccommodation'] == $row['id'] ? 'selected' : '';
?>
value="<?php
echo $row['id'];
?>
" data-imagesrc="<?php
echo $commonController->resize_image(!empty($row['logo']) ? $commonController->getAccomodationFolderPath($row['logo']) : 'images/common/no-accomodation-image.png', 16);
?>
" ><?php
echo $row['name'];
?>
