Tiny File Manager

Back Back Up Advanced Editor

<?php
require_once '../includes/functions.php';

// Require login and operator access
requireLogin();
if ($_SESSION['user_type'] !== 'operator') {
    redirect('/auth/login.php');
}

$user = getCurrentUser();
$db = Database::getInstance();

$errors = [];
$success = '';

// Check if operator has active session
$currentSession = $db->fetch(
    "SELECT os.*, fl.name as from_location_name 
     FROM operator_sessions os 
     JOIN from_locations fl ON os.from_location_id = fl.id 
     WHERE os.operator_id = ? AND os.status = 'active'",
    [$user['id']]
);

if (!$currentSession) {
    redirect('index.php');
}

// Handle status updates
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) {
    if (!validateCSRFToken($_POST['csrf_token'] ?? '')) {
        $errors[] = 'Invalid request. Please try again.';
    } else {
        $bookingId = (int)($_POST['booking_id'] ?? 0);
        $newStatus = $_POST['new_status'] ?? '';
        
        if (empty($bookingId) || empty($newStatus)) {
            $errors[] = 'Missing booking information.';
        } else {
            try {
                $updateFields = ['status = ?'];
                $params = [$newStatus];
                
                if ($newStatus === 'completed') {
                    $updateFields[] = 'completion_time = NOW()';
                }
                
                $sql = "UPDATE bookings SET " . implode(', ', $updateFields) . " WHERE id = ? AND operator_id = ?";
                $params[] = $bookingId;
                $params[] = $user['id'];
                
                $db->query($sql, $params);
                
                $success = 'Booking status updated successfully!';
            } catch (Exception $e) {
                $errors[] = 'Error updating booking: ' . $e->getMessage();
            }
        }
    }
}

// Get filter parameters
$statusFilter = $_GET['status'] ?? '';
$startDate = $_GET['start_date'] ?? '';
$endDate = $_GET['end_date'] ?? '';

// Build query for bookings
$whereConditions = ['b.operator_id = ?', 'b.from_location_id = ?'];
$params = [$user['id'], $currentSession['from_location_id']];

if ($statusFilter) {
    $whereConditions[] = 'b.status = ?';
    $params[] = $statusFilter;
}

if ($startDate && $endDate) {
    $whereConditions[] = 'DATE(b.created_at) BETWEEN ? AND ?';
    $params[] = $startDate;
    $params[] = $endDate;
} elseif ($startDate) {
    $whereConditions[] = 'DATE(b.created_at) >= ?';
    $params[] = $startDate;
} elseif ($endDate) {
    $whereConditions[] = 'DATE(b.created_at) <= ?';
    $params[] = $endDate;
}

$whereClause = implode(' AND ', $whereConditions);

// Get bookings for current session only
$bookings = $db->fetchAll(
    "SELECT b.*, p.name as passenger_name, p.phone as passenger_phone, 
            tl.name as to_location_name, tl.city as to_city,
            ar.number_plate, ar.unique_local_id, ao.name as owner_name
     FROM bookings b 
     JOIN passengers p ON b.passenger_id = p.id 
     JOIN to_locations tl ON b.to_location_id = tl.id 
     LEFT JOIN auto_rickshaws ar ON b.auto_rickshaw_id = ar.id
     LEFT JOIN auto_owners ao ON ar.owner_id = ao.id
     WHERE $whereClause
     ORDER BY b.created_at DESC",
    $params
);

// Get status counts for current session only
$statusCounts = $db->fetchAll(
    "SELECT status, COUNT(*) as count FROM bookings WHERE operator_id = ? AND from_location_id = ? GROUP BY status",
    [$user['id'], $currentSession['from_location_id']]
);

$statusStats = [];
foreach ($statusCounts as $stat) {
    $statusStats[$stat['status']] = $stat['count'];
}

$pageTitle = 'Manage Bookings';
require_once '../includes/header.php';
?>

<div class="container py-4">
    
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <h2 class="card-title mb-2">Manage Bookings</h2>
                    <p class="card-text text-muted">
                        Current Location: <?php echo htmlspecialchars($currentSession['from_location_name'] ?? 'Location not set'); ?>
                    </p>
                </div>
            </div>
        </div>
    </div>
    
    <?php if (!empty($errors)): ?>
        <div class="alert alert-danger">
            <ul class="mb-0">
                <?php foreach ($errors as $error): ?>
                    <li><?php echo htmlspecialchars($error); ?></li>
                <?php endforeach; ?>
            </ul>
        </div>
    <?php endif; ?>
    
    <?php if ($success): ?>
        <div class="alert alert-success">
            <?php echo htmlspecialchars($success); ?>
        </div>
    <?php endif; ?>
    
    
    <div class="row mb-4">
        <div class="col-md-3">
            <div class="card text-center">
                <div class="card-body">
                    <h3 class="card-title text-primary"><?php echo $statusStats['confirmed'] ?? 0; ?></h3>
                    <p class="card-text text-muted">Confirmed</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-center">
                <div class="card-body">
                    <h3 class="card-title text-info"><?php echo $statusStats['in_progress'] ?? 0; ?></h3>
                    <p class="card-text text-muted">In Progress</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-center">
                <div class="card-body">
                    <h3 class="card-title text-success"><?php echo $statusStats['completed'] ?? 0; ?></h3>
                    <p class="card-text text-muted">Completed</p>
                </div>
            </div>
        </div>
        <div class="col-md-3">
            <div class="card text-center">
                <div class="card-body">
                    <h3 class="card-title text-warning"><?php echo $statusStats['cancelled'] ?? 0; ?></h3>
                    <p class="card-text text-muted">Cancelled</p>
                </div>
            </div>
        </div>
    </div>
    
    
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <form method="GET" action="" class="row g-3">
                        <div class="col-md-4">
                            <label for="status" class="form-label">Status Filter</label>
                            <select class="form-select" id="status" name="status">
                                <option value="">All Statuses</option>
                                <option value="confirmed" <?php echo $statusFilter === 'confirmed' ? 'selected' : ''; ?>>Confirmed</option>
                                <option value="in_progress" <?php echo $statusFilter === 'in_progress' ? 'selected' : ''; ?>>In Progress</option>
                                <option value="completed" <?php echo $statusFilter === 'completed' ? 'selected' : ''; ?>>Completed</option>
                                <option value="cancelled" <?php echo $statusFilter === 'cancelled' ? 'selected' : ''; ?>>Cancelled</option>
                            </select>
                        </div>
                        <div class="col-md-6">
                            <label class="form-label">Date Range</label>
                            <div class="input-group">
                                <input type="date" class="form-control" id="start_date" name="start_date" value="<?php echo htmlspecialchars($startDate); ?>" placeholder="From">
                                <span class="input-group-text">to</span>
                                <input type="date" class="form-control" id="end_date" name="end_date" value="<?php echo htmlspecialchars($endDate); ?>" placeholder="To">
                            </div>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label">&nbsp;</label>
                            <div class="d-grid">
                                <button type="submit" class="btn btn-primary">
                                    <i class="bi bi-funnel"></i> Apply Filters
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    
    
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center">
                    <h5 class="card-title mb-0">
                        <i class="bi bi-list-check"></i> Bookings (<?php echo count($bookings); ?>)
                    </h5>
                    <a href="index.php" class="btn btn-outline-secondary btn-sm">
                        <i class="bi bi-arrow-left"></i> Back to Dashboard
                    </a>
                </div>
                <div class="card-body">
                    <?php if (empty($bookings)): ?>
                        <div class="text-center text-muted py-4">
                            <i class="bi bi-inbox" style="font-size: 3rem;"></i>
                            <p class="mt-2">No bookings found for the selected filters.</p>
                        </div>
                    <?php else: ?>
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead>
                                    <tr>
                                        <th>Booking ID</th>
                                        <th>Passenger</th>
                                        <th>Destination</th>
                                        <th>Auto Rickshaw</th>
                                        <th>Amount</th>
                                        <th>Status</th>
                                        <th>Time</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php foreach ($bookings as $booking): ?>
                                        <tr>
                                            <td>
                                                <strong>#<?php echo $booking['id']; ?></strong>
                                                <br><small class="text-muted"><?php echo ucfirst($booking['booking_type']); ?></small>
                                            </td>
                                            <td>
                                                <?php echo htmlspecialchars($booking['passenger_name']); ?>
                                                <br><small class="text-muted"><?php echo $booking['passenger_phone']; ?></small>
                                            </td>
                                            <td>
                                                <?php echo htmlspecialchars($booking['to_location_name']); ?>
                                                <br><small class="text-muted"><?php echo $booking['to_city']; ?></small>
                                            </td>
                                            <td>
                                                <?php if ($booking['auto_rickshaw_id']): ?>
                                                    <?php echo htmlspecialchars($booking['number_plate']); ?>
                                                    <br><small class="text-muted"><?php echo $booking['owner_name']; ?></small>
                                                <?php else: ?>
                                                    <span class="text-muted">Not assigned</span>
                                                <?php endif; ?>
                                            </td>
                                            <td>
                                                <strong>₹<?php echo number_format($booking['total_amount'], 2); ?></strong>
                                                <br><small class="text-muted">Fare: ₹<?php echo number_format($booking['fare_amount'], 2); ?></small>
                                            </td>
                                            <td>
                                                <?php
                                                $statusClass = [
                                                    'confirmed' => 'bg-warning',
                                                    'in_progress' => 'bg-info',
                                                    'completed' => 'bg-success',
                                                    'cancelled' => 'bg-danger'
                                                ];
                                                $statusText = [
                                                    'confirmed' => 'Confirmed',
                                                    'in_progress' => 'In Progress',
                                                    'completed' => 'Completed',
                                                    'cancelled' => 'Cancelled'
                                                ];
                                                ?>
                                                <span class="badge <?php echo $statusClass[$booking['status']] ?? 'bg-secondary'; ?>">
                                                    <?php echo $statusText[$booking['status']] ?? ucfirst($booking['status']); ?>
                                                </span>
                                            </td>
                                            <td>
                                                <?php echo date('H:i', strtotime($booking['created_at'])); ?>
                                                <br><small class="text-muted"><?php echo date('M d', strtotime($booking['created_at'])); ?></small>
                                            </td>
                                            <td>
                                                <div class="btn-group btn-group-sm">
                                                    
                                                    <button type="button" class="btn btn-outline-primary btn-sm" 
                                                            onclick="viewBooking(<?php echo $booking['id']; ?>)">
                                                        <i class="bi bi-eye"></i> View
                                                    </button>
                                                    
                                                    <?php if ($booking['status'] !== 'completed' && $booking['status'] !== 'cancelled'): ?>
                                                        <?php if ($booking['status'] === 'confirmed'): ?>
                                                            <button type="button" class="btn btn-info btn-sm" 
                                                                    onclick="updateStatus(<?php echo $booking['id']; ?>, 'in_progress')">
                                                                Start Trip
                                                            </button>
                                                        <?php elseif ($booking['status'] === 'in_progress'): ?>
                                                            <button type="button" class="btn btn-success btn-sm" 
                                                                    onclick="updateStatus(<?php echo $booking['id']; ?>, 'completed')">
                                                                Complete
                                                            </button>
                                                        <?php endif; ?>
                                                        <button type="button" class="btn btn-danger btn-sm" 
                                                                onclick="updateStatus(<?php echo $booking['id']; ?>, 'cancelled')">
                                                            Cancel
                                                        </button>
                                                    <?php endif; ?>
                                                </div>
                                            </td>
                                        </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                    <?php endif; ?>
                </div>
            </div>
        </div>
    </div>
</div>

<form id="statusUpdateForm" method="POST" action="" style="display: none;">
    <input type="hidden" name="csrf_token" value="<?php echo generateCSRFToken(); ?>">
    <input type="hidden" name="update_status" value="1">
    <input type="hidden" name="booking_id" id="updateBookingId">
    <input type="hidden" name="new_status" id="updateNewStatus">
</form>

<div class="modal fade" id="viewBookingModal" tabindex="-1" aria-labelledby="viewBookingModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="viewBookingModalLabel">
                    <i class="bi bi-eye"></i> Booking Details
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="viewBookingModalBody">
                
                <div class="text-center">
                    <div class="spinner-border" role="status">
                        <span class="visually-hidden">Loading...</span>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                
                <button type="button" class="btn btn-primary" id="printBookingReceiptBtn" style="display: none;">
                    <i class="bi bi-printer"></i> Print Receipt
                </button>
            </div>
        </div>
    </div>
</div>

function viewBooking(bookingId) {
    // Show the modal
    const modal = new bootstrap.Modal(document.getElementById('viewBookingModal'));
    modal.show();
    
    // Load booking details via AJAX
    loadBookingDetails(bookingId);
}

<?php require_once '../includes/footer.php'; ?>