#I LOVE YOU EVERDAY#

<?php
session_start();
$conn = new mysqli("localhost", "u839856410_Frajuu", "Frajuuweb000@", "u839856410_Frajuuconnect");
if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }

if (!isset($_SESSION['agent_id'])) { header("Location: login.php"); exit(); }
$agent_id = $_SESSION['agent_id'];
$message = "";

// Initialize to avoid "undefined index" notices
$name = $region = $district = $location = $rent = $description = $status = "";

// Handle form POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = $conn->real_escape_string($_POST['name'] ?? '');
    $region = $conn->real_escape_string($_POST['region'] ?? '');
    $district = $conn->real_escape_string($_POST['district'] ?? '');
    $location = $conn->real_escape_string($_POST['location'] ?? '');
    $rent = $conn->real_escape_string($_POST['rent'] ?? 0);
    $description = $conn->real_escape_string($_POST['description'] ?? '');
    $status = $conn->real_escape_string($_POST['status'] ?? 'available');

// Upload images
    $images_arr = [];
    if (!empty($_FILES['images']['name'][0])) {
        foreach ($_FILES['images']['name'] as $k => $img_name) {
            $tmp = $_FILES['images']['tmp_name'][$k] ?? null;
            if (!$tmp || !is_uploaded_file($tmp)) continue;
            $ext = pathinfo($img_name, PATHINFO_EXTENSION);
            $new_name = 'uploads/' . uniqid('img_', true) . '.' . $ext;
            if (move_uploaded_file($tmp, $new_name)) {
                $images_arr[] = $new_name;
            }
        }
    }
    $images_json = json_encode($images_arr);

// Upload videos
    $videos_arr = [];
    if (!empty($_FILES['videos']['name'][0])) {
        foreach ($_FILES['videos']['name'] as $k => $vid_name) {
            $tmp = $_FILES['videos']['tmp_name'][$k] ?? null;
            if (!$tmp || !is_uploaded_file($tmp)) continue;
            $ext = pathinfo($vid_name, PATHINFO_EXTENSION);
            $new_name = 'uploads/' . uniqid('vid_', true) . '.' . $ext;
            if (move_uploaded_file($tmp, $new_name)) {
                $videos_arr[] = $new_name;
            }
        }
    }
    $videos_json = json_encode($videos_arr);

// Insert into DB (matching other add-pages pattern)
    $sql = "INSERT INTO rooms_for_rent
      (agent_id, name, region, district, location, rent, description, images, videos, status)
      VALUES ('$agent_id', '$name', '$region', '$district', '$location', '$rent', '$description', '$images_json', '$videos_json', '$status')";

if ($conn->query($sql)) {
        $message = "<div class='alert alert-success'>Room added successfully!</div>";
        // reset form vars for user experience
        $name = $region = $district = $location = $rent = $description = $status = "";
    } else {
        $message = "<div class='alert alert-danger'>Error: " . htmlspecialchars($conn->error) . "</div>";
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>Add Room for Rent | FRAJUU CONNECT</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<style>
/* small helpers to keep consistent look */
.form-container { padding: 20px; }
</style>
</head>
<body>

<nav class="navbar navbar-expand-lg navbar-dark shadow-sm" style="background:#314E9D;">
  <div class="container">
    <a class="navbar-brand fw-bold" href="index.php"><img src="images/Frajuu-connect-logo.png" alt="Frajuu Logo" srcset=""></a>
    <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNav" aria-controls="navbarNav">
      <span class="navbar-toggler-icon"></span>
    </button>

<div class="collapse navbar-collapse" id="navbarNav">
      <ul class="navbar-nav ms-auto">
        <li class="nav-item"><a class="nav-link" href="index.php">Home</a></li>
        <li class="nav-item"><a class="nav-link" href="house-for-sale-listing.php">Buy</a></li>
        <li class="nav-item"><a class="nav-link" href="houses-for-rent-listing.php">Rent</a></li>
        <li class="nav-item"><a class="nav-link" href="plots-for-sale-listing.php">Plots</a></li>
        <li class="nav-item"><a class="nav-link active" href="rooms-for-rent-listing.php">Rooms</a></li>
        <li class="nav-item"><a class="nav-link" href="contact.php">Contact</a></li>
        <li class="nav-item dropdown">
          <a class="nav-link dropdown-toggle" href="#" role="button" data-bs-toggle="dropdown">Msaada/Sera</a>
          <ul class="dropdown-menu">
            <li><a class="dropdown-item" href="jinsi-tunavyofanya-kazi.html">Jinsi Tunavyofanya kazi</a></li>
            <li><a class="dropdown-item" href="terms-and-conditions.html">Masharti ya Matumizi</a></li>
            <li><a class="dropdown-item" href="privacy-policy.html">Sera ya Faragha</a></li>
          </ul>
        </li>
        <li class="nav-item"><a class="nav-link" href="settings.php">Settings</a></li>
        <li class="nav-item"><a class="nav-link text-danger" href="logout.php"><i class="fa fa-sign-out-alt me-2"></i>Logout</a></li>
      </ul>
    </div>
  </div>
</nav>

<div class="container d-md-none mt-3">
  <button class="btn btn-primary w-100" type="button" data-bs-toggle="collapse" data-bs-target="#mobileSidebar">☰ Menu</button>
</div>

<div class="col-12 d-md-none">
      <div class="collapse" id="mobileSidebar">
        <?php include 'sidebar.php'; ?>
      </div>
    </div>

<div class="col-md-9 col-12">
      <div class="form-container bg-white p-4 shadow rounded">
        <h2 class="mb-4">Welcome <?php echo htmlspecialchars($_SESSION['agent_name'] ?? ''); ?> — Add Room for Rent</h2>

<?php echo $message; ?>

<form method="POST" enctype="multipart/form-data">
          <div class="row g-3">
            <div class="col-md-6 col-12">
              <label class="form-label">Room Name</label>
              <input type="text" name="name" class="form-control" value="<?php echo htmlspecialchars($name); ?>" placeholder="e.g., Single Room" required>
            </div>

<div class="col-md-3 col-6">
              <label class="form-label">Region</label>
              <input type="text" name="region" class="form-control" value="<?php echo htmlspecialchars($region); ?>" required>
            </div>

<div class="col-md-3 col-6">
              <label class="form-label">District</label>
              <input type="text" name="district" class="form-control" value="<?php echo htmlspecialchars($district); ?>" required>
            </div>

<div class="col-12">
              <label class="form-label">Location</label>
              <input type="text" name="location" class="form-control" value="<?php echo htmlspecialchars($location); ?>" required>
            </div>

<div class="col-md-6 col-12">
              <label class="form-label">Rent (TZS)</label>
              <input type="number" name="rent" class="form-control" value="<?php echo htmlspecialchars($rent); ?>" required>
            </div>

<div class="col-12">
              <label class="form-label">Description</label>
              <textarea name="description" class="form-control" rows="4" placeholder="Describe the room..."><?php echo htmlspecialchars($description); ?></textarea>
            </div>

<div class="col-12">
              <label class="form-label">Images</label>
              <input type="file" name="images[]" class="form-control" multiple accept="image/*">
            </div>

<div class="col-12">
              <label class="form-label">Videos</label>
              <input type="file" name="videos[]" class="form-control" multiple accept="video/*">
            </div>

<div class="col-12">
              <label class="form-label">Status</label>
              <select name="status" class="form-select">
                <option value="available" <?php echo ($status === 'available' ? 'selected' : ''); ?>>Available</option>
                <option value="occupied" <?php echo ($status === 'occupied' ? 'selected' : ''); ?>>Occupied</option>
              </select>
            </div>

</div>
    </div>
  </div>
</div>

<footer class="bg-dark text-white py-4 mt-5">
  <div class="container text-center">
    <h5 class="text-uppercase mb-2" style="color: #0b9b2c;">CONTACT US</h5>
    <p><i class="fas fa-envelope me-2"></i> info@frajuuconnect.online</p>
    <p><i class="fas fa-phone me-2"></i> +255 675 621 343</p>
    <p>Follow us:
      <a href="#" class="text-white ms-2">Facebook</a> |
      <a href="#" class="text-white ms-2">Tiktok</a> |
      <a href="#" class="text-white ms-2">Instagram</a>
    </p>
    <div class="mt-3">
      <a href="privacy-policy.html" class="btn btn-sm btn-outline-light mt-2">Sera ya Faragha</a>
      <a href="jinsi-tunavyofanya-kazi.html" class="btn btn-sm btn-outline-light mt-2">Jinsi Tunavyofanya kazi</a>
      <a href="terms-and-conditions.html" class="btn btn-sm btn-outline-light mt-2">Masharti na Matumizi</a>
    </div>
    <p class="mt-3 mb-0">&copy; <?php echo date("Y"); ?> FRAJUU CONNECT. All rights reserved.</p>
  </div>
</footer>