282 lines
13 KiB
PHP
282 lines
13 KiB
PHP
<?php
|
|
session_start();
|
|
if (!isset($_SESSION['usertype']) || $_SESSION['usertype'] !== "seller") {
|
|
header('Location: ../../index.php');
|
|
exit();
|
|
}
|
|
?>
|
|
<html>
|
|
<head>
|
|
<title>RoamEase</title>
|
|
<link rel="shortcut icon" href="../../icon/favicon/favicon.ico" type="image/x-icon" />
|
|
<link rel="icon" href="../../icon/favicon/favicon.ico" type="image/x-icon" />
|
|
<link rel="stylesheet" href="../user/home.css?version=1" type="text/css" />
|
|
<meta charset="UTF-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
|
<style>
|
|
td{padding:3px;}
|
|
table{background-color:rgb(255, 255, 255,0.5);}
|
|
#div_ground {
|
|
position: absolute;
|
|
top: 100px;
|
|
left: 0px;
|
|
width: 100%;
|
|
height: 100%;
|
|
background-color:rgb(225, 240, 255);
|
|
}
|
|
#div_add {
|
|
position: absolute;
|
|
top: 25%;
|
|
left: 25%;
|
|
width: 50%;
|
|
height: 50%;
|
|
}
|
|
.hidden {
|
|
display: none;
|
|
}
|
|
|
|
.chiose-button {
|
|
width: 200px;
|
|
padding: 10px 20px;
|
|
font-size: 16px;
|
|
background-color: #003b94;
|
|
color: white;
|
|
border: none;
|
|
border-radius: 5px;
|
|
cursor: pointer;
|
|
}
|
|
</style>
|
|
<script>
|
|
// Show div1 by default
|
|
showTable('div1');
|
|
|
|
function showTable(tableId) {
|
|
// Hide all tables
|
|
document.getElementById('div1').classList.add('hidden');
|
|
document.getElementById('div2').classList.add('hidden');
|
|
|
|
// Show the selected table
|
|
document.getElementById(tableId).classList.remove('hidden');
|
|
}
|
|
|
|
</script>
|
|
</head>
|
|
|
|
<body>
|
|
|
|
<header>
|
|
<div class="logo">
|
|
<a href="home.php"><img src="../../icon/favicon/logo_white.svg" alt="RoamEase"></a>
|
|
</div>
|
|
|
|
<div class="nav-links">
|
|
<a href="../seller/home.php">Back To Home</a>
|
|
</div>
|
|
</header>
|
|
<header>
|
|
<nav>
|
|
<a href="stays.php">
|
|
<img src="../../icon/header/stays.svg" alt="Stays">
|
|
</a>
|
|
<a href="foods.php">
|
|
<img src="../../icon/header/foods.svg" alt="Foods">
|
|
</a>
|
|
<a href="attractions.php">
|
|
<img src="../../icon/header/attractions.svg" alt="Attractions">
|
|
</a>
|
|
</nav>
|
|
</header>
|
|
<div id="div_ground"></div>
|
|
<div id="div_add" style="text-align: center;">
|
|
|
|
<button class="chiose-button" onclick="showTable('div1')">Add Hotel</button>
|
|
<button class="chiose-button" onclick="showTable('div2')">Add Room</button>
|
|
|
|
<div id="div1">
|
|
<form id="formA" action="" method="post">
|
|
<table style="text-align: right;border:black '1';width: 100%;height: 100%;" align="center">
|
|
<tr>
|
|
<td colspan="2"><p style="text-align: center;font-size: 30px;"><b>Add Hotel</p></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><label for="hotel_name">Hotel name:</label></td>
|
|
<td style="text-align: left"><input type="text" id="hotel_name" name="hotel_name" required></td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="city_id">City id:</label></td>
|
|
<td style="text-align: left"><input type="number" id="city_id" name="city_id" required></td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="location">Location:</label></td>
|
|
<td style="text-align: left"><input type="text" id="location" name="location" required></td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="hotel_type_id">Hotel type id:</label></td>
|
|
<td style="text-align: left"><select id="hotel_type_id" name="hotel_type_id">
|
|
<option value="1">Boutique Hotel</option>
|
|
<option value="2">Chain Hotel</option>
|
|
<option value="3">Resort</option>
|
|
<option value="4">Business Hotel</option>
|
|
<option value="5">Budget Hotel</option>
|
|
<option value="6">Luxury Hotel</option>
|
|
<option value="7">Bed and Breakfast (B&B)</option>
|
|
<option value="8">Extended Stay Hotel</option>
|
|
<option value="9">Airport Hotel</option>
|
|
<option value="10">Hostel</option>
|
|
<option value="11">Motel</option>
|
|
<option value="12">Themed Hotel</option>
|
|
<option value="13">Historic Hotel</option>
|
|
<option value="14">Spa Hotel</option>
|
|
<option value="15">Vacation Rental</option>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="description">Description:</label></td>
|
|
<td style="text-align: left"><textarea id="description" name="description" required></textarea></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" style="text-align: center;"><button type="submit" name="submit_form1" >Add Hotel</button></td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
</div>
|
|
|
|
<div id="div2" class="hidden">
|
|
<form id="formB" action="" method="post">
|
|
<table style="text-align: right;border:black '1';width: 100%;height: 100%;" align="center">
|
|
<tr>
|
|
<td colspan="2"><p style="text-align: center;font-size: 30px;"><b>Add room</p></td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="hotel_id">Hotel name:</label></td>
|
|
<td style="text-align: left">
|
|
<?php
|
|
include "../ConnectDB.php";
|
|
// Check connection
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
|
|
$seller_id = $_SESSION['uid'];
|
|
|
|
|
|
$sql = "SELECT hotel_id, name FROM hotel WHERE seller_id = $seller_id";
|
|
$result = $conn->query($sql);
|
|
|
|
if($sql=="null"){
|
|
echo 'You do not have any hotel';
|
|
}else{
|
|
|
|
while ($row = $result->fetch_assoc()) {
|
|
echo '<input type="checkbox" name="hotel_id" value="' . $row['hotel_id'] . '">' . $row['name'] . '<br>';
|
|
}
|
|
}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="room_type_id">Room type:</label></td>
|
|
<td style="text-align: left"><select id="room_type_id" name="room_type_id">
|
|
<option value="1">Standard Room</option>
|
|
<option value="2">Deluxe Room</option>
|
|
<option value="3">Double Room</option>
|
|
<option value="4">Queen Room</option>
|
|
<option value="5">Suite</option>
|
|
<option value="6">Executive Suite</option>
|
|
<option value="7">Family Room</option>
|
|
<option value="8">Accessible Room</option>
|
|
<option value="9">Honeymoon Suite</option>
|
|
<option value="10">Spa Room</option>
|
|
<option value="11">Loft</option>
|
|
<option value="12">Ocean View Room</option>
|
|
<option value="13">City View Room</option>
|
|
<option value="14">Villa</option>
|
|
<option value="15">Presidential Suite</option>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="price">Price:</label></td>
|
|
<td style="text-align: left"><input type="number" id="price" name="price" required></td>
|
|
</tr>
|
|
<tr>
|
|
<td><label for="quantity">Quantity:</label></td>
|
|
<td style="text-align: left"><input type="number" id="quantity" name="quantity" required></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" style="text-align: center"><button type="submit" name="submit_form2" >Add room</button></td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
</div>
|
|
<?php
|
|
include "../ConnectDB.php";
|
|
|
|
// Check connection
|
|
if ($conn->connect_error) {
|
|
die("Connection failed: " . $conn->connect_error);
|
|
}
|
|
|
|
|
|
if (isset($_POST['submit_form1'])) {
|
|
// Process data from Table A
|
|
$hotel_name = $_POST["hotel_name"];
|
|
$city_id = $_POST["city_id"];
|
|
$location = $_POST["location"];
|
|
$hotel_type_id = $_POST["hotel_type_id"];
|
|
$seller_id = $_SESSION['uid'];
|
|
$description = $_POST["description"];
|
|
$start=microtime(true);
|
|
// Insert data into the database
|
|
$sql1 = "INSERT INTO hotel ( name, city_id, location, hotel_type_id, seller_id, descrip) VALUES ('$hotel_name', '$city_id', '$location','$hotel_type_id', '$seller_id', '$description')";
|
|
|
|
if ($conn->query($sql1) === TRUE) {
|
|
$end = microtime(true);
|
|
$execution_time = $end - $start;
|
|
$phpVariable = "Add hotel success. Running time: ".$execution_time."s";
|
|
|
|
|
|
echo '<script>';
|
|
echo 'var jsVariable = "' . $phpVariable . '";';
|
|
echo 'alert(jsVariable);';
|
|
echo '</script>';
|
|
} else {
|
|
$end = microtime(true);
|
|
$execution_time = $end - $start;
|
|
echo "Error: " . $sql1 . "<br>" . $conn->error;
|
|
}
|
|
|
|
}
|
|
if (isset($_POST['submit_form2'])) {
|
|
// Process data from Table B
|
|
$hotel_id = $_POST["hotel_id"];
|
|
$room_type_id = $_POST["room_type_id"];
|
|
$price = $_POST["price"];
|
|
$quantity = $_POST["quantity"];
|
|
$start=microtime(true);
|
|
// Insert data into the database
|
|
$sql2 = "INSERT INTO hotel_room (hotel_id, room_type_id, price, quantity) VALUES ('$hotel_id', '$room_type_id', '$price', '$quantity')";
|
|
|
|
if ($conn->query($sql2) === TRUE) {
|
|
$end = microtime(true);
|
|
$execution_time = $end - $start;
|
|
$phpVariable = "Add room success. Running time: ".$execution_time."s";
|
|
|
|
|
|
echo '<script>';
|
|
echo 'var jsVariable = "' . $phpVariable . '";';
|
|
echo 'alert(jsVariable);';
|
|
echo '</script>';
|
|
} else {
|
|
$end = microtime(true);
|
|
$execution_time = $end - $start;
|
|
echo "Error: " . $sql2 . "<br>" . $conn->error;
|
|
}
|
|
}
|
|
|
|
|
|
$conn->close();
|
|
?>
|
|
</div>
|
|
</body>
|
|
</html>
|