1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / kobilz.co.uk /
Filename : dashboard.php
back
<?php
session_start();
error_reporting(0);
include('../config/xconfig.php');
include('includes/functions.php');

require_login();
if (!isset($_SESSION['user_id'])) {
    header("Location: login");
    exit();
}

error_reporting(E_ALL);
ini_set('display_errors', 1);

$user_id = $_SESSION['user_id'];

// Fetch user details
$stmt = $con->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();

$meta_title = "Dashboard - Kobilz";
include "includes/header.php";

$referral_code = $user['referral_code'];

// Fetch bookings
$stmt = $con->prepare("SELECT b.*, s.name AS service_name 
FROM bookings b 
JOIN services s ON b.service_id = s.id 
WHERE b.user_id = ?
ORDER BY b.booking_date DESC
");
$stmt->bind_param("i", $user_id);
$stmt->execute();
$bookings_result = $stmt->get_result();
$upcoming_bookings = [];
$past_bookings = [];

while ($booking = $bookings_result->fetch_assoc()) {
    if (strtotime($booking['booking_date']) >= time()) {
        $upcoming_bookings[] = $booking;
    } else {
        $past_bookings[] = $booking;
    }
}
$stmt->close();

if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['book_service'])) {
    $service_id = $_POST['service_id'] ?? null;
    $booking_date = $_POST['booking_date'] ?? null;
    $booking_time = $_POST['booking_time'] ?? null;
    $duration_hours = $_POST['duration_hours'] ?? null;
    $address = trim($_POST['address'] ?? '');
    $special_instructions = trim($_POST['special_instructions'] ?? '');
    $status = 'Pending';
    $now = date('Y-m-d H:i:s');

    // Validation
    if (!$service_id || !$booking_date || !$booking_time || !$duration_hours || empty($address)) {
        $msg = "Please fill in all required booking fields.";
        $type = "error";
    } elseif (strtotime($booking_date . ' ' . $booking_time) < time()) {
        $msg = "Booking date/time cannot be in the past.";
        $type = "error";
    } else {
        // Insert booking into DB
        $stmt = $con->prepare("INSERT INTO bookings (user_id, service_id, booking_date, booking_time, duration_hours, address, special_instructions, status, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param("iississsss", $user_id, $service_id, $booking_date, $booking_time, $duration_hours, $address, $special_instructions, $status, $now, $now);

        if ($stmt->execute()) {
            $msg = "Service booked successfully! We will get back to you shortly";
            $type = "success";
        } else {
            $msg = "Failed to book service. Please try again.";
            $type = "error";
        }

        $stmt->close();
    }
}


?>


<?php if (!empty($msg)): ?>
<script>
    Toastify({
        text: '<?php echo addslashes($msg); ?>',
        duration: 5000,
        close: true,
        gravity: "top",
        position: "right",
        backgroundColor: '<?php echo $type === "success" ? "green" : ($type === "warning" ? "orange" : "red"); ?>',
        stopOnFocus: true
    }).showToast();
</script>
<?php endif; ?>


<div class="container mt-4">
    <p class="mb-3">
        Welcome, <?php echo htmlspecialchars($user['first_name']); ?> 
    </p>

    <!-- rts progress area end -->
<div class="rts-team-area rts-section-gapBottom" style="margin-top:0px;">
    <div class="row justify-content-center text-center">
        <div class="col-lg-12">
            <div class="advertise-prompt-box py-5 px-4" style="border: 2px dashed #ccc; border-radius: 12px; background-color: #f9f9f9;">
                <h4 class="mb-3">Need a Reliable Cleaning Service?</h4>
                <p class="mb-3">
                    Book affordable and professional cleaning with us today. Fast, easy, and hassle-free!
                </p>
                <a href="book" class="btn btn-primary" style="background:#303183;border:0px;font-size:15px;"
                   >
                    <i class="fa fa-broom"></i> Book Now
                </a>
            </div>
        </div>
    </div>
</div>

<?php
function getStatusBadge($status) {
    $class = 'secondary'; // default badge color

    switch (strtolower($status)) {
        case 'pending':
            $class = 'warning';
            break;
        case 'confirmed':
            $class = 'success';
            break;
        case 'cancelled':
        case 'canceled':
            $class = 'danger';
            break;
        case 'completed':
            $class = 'primary';
            break;
    }

    return '<span class="badge bg-' . $class . '">' . ucfirst($status) . '</span>';
}
?>

<div class="mb-4 d-flex justify-content-between align-items-center">
    <h4>Upcoming Bookings</h4>
</div>

<ul>
    <?php if (empty($upcoming_bookings)): ?>
        <li>No upcoming bookings found.</li>
    <?php else: ?>
        <?php foreach ($upcoming_bookings as $booking): ?>
            <li>
                <strong><?php echo htmlspecialchars($booking['service_name']); ?></strong><br>
                Date: <?php echo date("F j, Y", strtotime($booking['booking_date'])); ?><br>
                Status: <?php echo getStatusBadge($booking['status']); ?><br>
            </li>
        <?php endforeach; ?>
    <?php endif; ?>
</ul>

<h4>Past Bookings</h4>
<ul>
    <?php if (empty($past_bookings)): ?>
        <li>No past bookings found.</li>
    <?php else: ?>
        <?php foreach ($past_bookings as $booking): ?>
            <li>
                <strong><?php echo htmlspecialchars($booking['service_name']); ?></strong><br>
                Date: <?php echo date("F j, Y", strtotime($booking['booking_date'])); ?><br>
                Status: <?php echo getStatusBadge($booking['status']); ?>
            </li>
        <?php endforeach; ?>
    <?php endif; ?>
</ul>

    </div>
    </div>
<!-- Booking Modal -->
<div class="modal fade" tabindex="-1" role="dialog" id="bookingModal">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
        <form method="POST" action="">
    <div class="modal-header">
        <h5 class="modal-title">New Booking</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
    </div>

    <div class="modal-body mt-3">

        <div class="mb-3">
            <label for="service_id" class="form-label">Service Type</label>
            <select name="service_id" id="service_id" class="form-select" required style="font-size: 15px; height: 50px;">
                <option value="">-- Select Service Type --</option>
                <option value="1">Regular Cleaning</option>
                <option value="2">Deep Cleaning</option>
                <option value="3">Carpet Cleaning</option>
                <option value="4">Office Cleaning</option>
            </select>
        </div>

        <div class="mb-3">
            <label for="booking_date" class="form-label">Booking Date</label>
            <input type="date" name="booking_date" id="booking_date" class="form-control" required style="font-size: 15px; height: 50px;">
        </div>

        <div class="mb-3">
            <label for="booking_time" class="form-label">Booking Time</label>
            <input type="time" name="booking_time" id="booking_time" class="form-control" required style="font-size: 15px; height: 50px;">
        </div>

        <div class="mb-3">
            <label for="duration_hours" class="form-label">Duration (in hours)</label>
            <input type="number" name="duration_hours" id="duration_hours" class="form-control" min="1" required style="font-size: 15px; height: 50px;">
        </div>

        <div class="mb-3">
            <label for="address" class="form-label">Address</label>
            <textarea name="address" id="address" class="form-control" required rows="3" placeholder="Enter address where service will be done..."></textarea>
        </div>

        <div class="mb-3">
            <label for="special_instructions" class="form-label">Special Instructions (Optional)</label>
            <textarea name="special_instructions" id="special_instructions" class="form-control" rows="3" placeholder="Any extra info for the cleaner..."></textarea>
        </div>
    </div>

    <div class="modal-footer">
        <button type="submit" name="book_service" class="rts-btn btn-primary">Book Now</button>
        <button type="button" class="rts-btn btn-danger" data-bs-dismiss="modal">Cancel</button>
    </div>
</form>

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

<?php include "includes/footer.php"; ?>