Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/vkmobiles/admin

Free Space:

10.29 TB

🔧 Quick Actions

✏️ Editing: service-tracking.php

<?php
session_start();
// Include database connection
include('includes/db.php');

// Determine logged-in branch
$branch_id = isset($_SESSION['branch_id']) ? intval($_SESSION['branch_id']) : null;

if ($branch_id === null) {
    echo '<div class="alert alert-danger">No branch logged in. Please login to continue.</div>';
    include('includes/footer.php');
    exit();
}

$branch_name = "Your Branch";

// Get branch name
$branch_sql = "SELECT branch_name FROM branches WHERE id = $branch_id";
$branch_result = $conn->query($branch_sql);
if ($branch_result && $branch_result->num_rows > 0) {
    $branch_data = $branch_result->fetch_assoc();
    $branch_name = $branch_data['branch_name'];
}

// Function to log activities with branch
function logActivity($conn, $activity_type, $description, $related_id = null, $related_table = null, $branch_id = null) {
    $user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
    $ip_address = $_SERVER['REMOTE_ADDR'];
    $user_agent = $_SERVER['HTTP_USER_AGENT'];
    
    $stmt = $conn->prepare("INSERT INTO activity_logs (user_id, branch_id, activity_type, description, related_id, related_table, ip_address, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("iississs", $user_id, $branch_id, $activity_type, $description, $related_id, $related_table, $ip_address, $user_agent);
    $stmt->execute();
    $stmt->close();
}

// Handle bulk status update
if (isset($_POST['bulk_update_status'])) {
    $new_status = $conn->real_escape_string($_POST['bulk_status']);
    $jobcard_ids = isset($_POST['jobcard_ids']) ? $_POST['jobcard_ids'] : array();
    
    if (!empty($jobcard_ids)) {
        $id_list = implode(',', array_map('intval', $jobcard_ids));
        
        $sql = "UPDATE service_jobcards SET 
                status = '$new_status',
                updated_at = NOW()
                WHERE id IN ($id_list) AND branch_id = $branch_id";
        
        if ($conn->query($sql) === TRUE) {
            // Log activity
            foreach($jobcard_ids as $jobcard_id) {
                logActivity($conn, '', "Bulk status update: $new_status for job card ID: $jobcard_id in $branch_name", $jobcard_id, 'service_jobcards', $branch_id);
            }
            
            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle me-2"></i>Status updated for ' . count($jobcard_ids) . ' job cards successfully in ' . htmlspecialchars($branch_name) . '!
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        } else {
            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-triangle me-2"></i>Error updating status: ' . $conn->error . '
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                  </div>';
        }
    }
}

// Handle quick status update
if (isset($_GET['update_status'])) {
    $jobcard_id = intval($_GET['update_status']);
    $new_status = $conn->real_escape_string($_GET['status']);
    
    $sql = "UPDATE service_jobcards SET 
            status = '$new_status',
            updated_at = NOW()
            WHERE id = $jobcard_id AND branch_id = $branch_id";
    
    if ($conn->query($sql) === TRUE) {
        logActivity($conn, '', "Quick status update: $new_status in $branch_name", $jobcard_id, 'service_jobcards', $branch_id);
        
        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle me-2"></i>Job card status updated successfully in ' . htmlspecialchars($branch_name) . '!
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>';
    } else {
        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle me-2"></i>Error updating job card status: ' . $conn->error . '
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
              </div>';
    }
}
?>
<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<div class="row mb-3">
                    <div class="col-12">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h4 class="mb-1"><i class="fas fa-store me-2"></i><?php echo htmlspecialchars($branch_name); ?> - Service Tracking & Management</h4>
                                        <p class="mb-0">Managing service tracking for <?php echo htmlspecialchars($branch_name); ?> (Branch ID: <?php echo $branch_id; ?>)</p>
                                    </div>
                                    <div>
                                        <span class="badge bg-light text-primary fs-6">Current Branch</span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-shipping-fast me-2"></i>Service Tracking & Management - <?php echo htmlspecialchars($branch_name); ?>
                                    </h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="service-jobcard.php" class="btn btn-success">
                                            <i class="fas fa-plus-circle me-2"></i>New Job Card
                                        </a>
                                        <button type="button" class="btn btn-outline-primary" onclick="refreshTracking()">
                                            <i class="fas fa-sync-alt me-2"></i>Refresh
                                        </button>
                                        <a href="service-reports.php" class="btn btn-outline-info">
                                            <i class="fas fa-chart-bar me-2"></i>Reports
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-4">
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-primary text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Total Jobs<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-clipboard-list fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $total_sql = "SELECT COUNT(*) as total FROM service_jobcards WHERE branch_id = $branch_id";
                                                    $total_count = $conn->query($total_sql)->fetch_assoc()['total'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $total_count; ?></h3>
                                                    <p class="mb-0">All time</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-warning text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Today's Jobs<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-calendar-day fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $today_sql = "SELECT COUNT(*) as today FROM service_jobcards WHERE DATE(created_at) = CURDATE() AND branch_id = $branch_id";
                                                    $today_count = $conn->query($today_sql)->fetch_assoc()['today'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $today_count; ?></h3>
                                                    <p class="mb-0">New today</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-danger text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Overdue<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-exclamation-triangle fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $overdue_sql = "SELECT COUNT(*) as overdue FROM service_jobcards 
                                                                   WHERE estimated_delivery < CURDATE() 
                                                                   AND status NOT IN ('delivered', 'cancelled')
                                                                   AND branch_id = $branch_id";
                                                    $overdue_count = $conn->query($overdue_sql)->fetch_assoc()['overdue'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $overdue_count; ?></h3>
                                                    <p class="mb-0">Past due date</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-info text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Due Today<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-clock fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $due_today_sql = "SELECT COUNT(*) as due_today FROM service_jobcards 
                                                                     WHERE estimated_delivery = CURDATE() 
                                                                     AND status NOT IN ('delivered', 'cancelled')
                                                                     AND branch_id = $branch_id";
                                                    $due_today_count = $conn->query($due_today_sql)->fetch_assoc()['due_today'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $due_today_count; ?></h3>
                                                    <p class="mb-0">To be delivered</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-success text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Completed<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-check-circle fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $completed_sql = "SELECT COUNT(*) as completed FROM service_jobcards 
                                                                     WHERE status = 'completed' 
                                                                     AND DATE(completed_at) = CURDATE()
                                                                     AND branch_id = $branch_id";
                                                    $completed_count = $conn->query($completed_sql)->fetch_assoc()['completed'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $completed_count; ?></h3>
                                                    <p class="mb-0">Today</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-secondary text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Revenue<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-rupee-sign fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $revenue_sql = "SELECT COALESCE(SUM(payment_received), 0) as revenue 
                                                                   FROM service_jobcards 
                                                                   WHERE DATE(completed_at) = CURDATE()
                                                                   AND branch_id = $branch_id";
                                                    $revenue_today = $conn->query($revenue_sql)->fetch_assoc()['revenue'];
                                                    ?>
                                                    <h3 class="mb-1">₹<?php echo number_format($revenue_today, 0); ?></h3>
                                                    <p class="mb-0">Today's collection</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h5 class="card-title mb-0">
                                                    <i class="fas fa-tachometer-alt me-2"></i>Service Dashboard - <?php echo htmlspecialchars($branch_name); ?>
                                                </h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    
                                                    <div class="col-md-8">
                                                        <h6 class="mb-3">Service Status Overview - <?php echo htmlspecialchars($branch_name); ?></h6>
                                                        <div class="row">
                                                            <?php
                                                            $status_counts_sql = "SELECT status, COUNT(*) as count 
                                                                                FROM service_jobcards 
                                                                                WHERE branch_id = $branch_id
                                                                                GROUP BY status 
                                                                                ORDER BY FIELD(status, 'pending', 'in_progress', 'completed', 'delivered', 'cancelled')";
                                                            $status_counts = $conn->query($status_counts_sql);
                                                            
                                                            $status_config = [
                                                                'pending' => ['color' => 'warning', 'icon' => 'clock', 'title' => 'Pending'],
                                                                'in_progress' => ['color' => 'info', 'icon' => 'cogs', 'title' => 'In Progress'],
                                                                'completed' => ['color' => 'success', 'icon' => 'check-circle', 'title' => 'Completed'],
                                                                'delivered' => ['color' => 'primary', 'icon' => 'truck', 'title' => 'Delivered'],
                                                                'cancelled' => ['color' => 'danger', 'icon' => 'times-circle', 'title' => 'Cancelled']
                                                            ];
                                                            
                                                            // Store counts for use in quick actions
                                                            $status_counts_data = [];
                                                            while($status = $status_counts->fetch_assoc()) {
                                                                $status_counts_data[$status['status']] = $status['count'];
                                                                $config = $status_config[$status['status']];
                                                                $percentage = $total_count > 0 ? round(($status['count'] / $total_count) * 100, 1) : 0;
                                                            ?>
                                                            <div class="col-md-4 mb-3">
                                                                <div class="card status-card bg-<?php echo $config['color']; ?>-subtle">
                                                                    <div class="card-body text-center">
                                                                        <i class="fas fa-<?php echo $config['icon']; ?> fa-2x text-<?php echo $config['color']; ?> mb-2"></i>
                                                                        <h4 class="text-<?php echo $config['color']; ?>"><?php echo $status['count']; ?></h4>
                                                                        <h6 class="text-muted"><?php echo $config['title']; ?></h6>
                                                                        <div class="progress mt-2" style="height: 6px;">
                                                                            <div class="progress-bar bg-<?php echo $config['color']; ?>" 
                                                                                 style="width: <?php echo $percentage; ?>%"></div>
                                                                        </div>
                                                                        <small class="text-muted"><?php echo $percentage; ?>% of total</small>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            <?php } ?>
                                                        </div>
                                                    </div>
                                                    
                                                    
                                                    <div class="col-md-4">
                                                        <h6 class="mb-3">Quick Actions - <?php echo htmlspecialchars($branch_name); ?></h6>
                                                        <div class="d-grid gap-2">
                                                            <a href="service-jobcard.php?status=pending&branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-warning text-start">
                                                                <i class="fas fa-clock me-2"></i>View Pending Jobs
                                                                <span class="badge bg-warning float-end"><?php echo $status_counts_data['pending'] ?? 0; ?></span>
                                                            </a>
                                                            <a href="service-jobcard.php?status=in_progress&branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-info text-start">
                                                                <i class="fas fa-cogs me-2"></i>View In Progress
                                                                <span class="badge bg-info float-end"><?php echo $status_counts_data['in_progress'] ?? 0; ?></span>
                                                            </a>
                                                            <a href="service-jobcard.php?status=completed&branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-success text-start">
                                                                <i class="fas fa-check-circle me-2"></i>Ready for Delivery
                                                                <span class="badge bg-success float-end"><?php echo $status_counts_data['completed'] ?? 0; ?></span>
                                                            </a>
                                                            <a href="service-jobcard.php?date=<?php echo date('Y-m-d'); ?>&branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-primary text-start">
                                                                <i class="fas fa-calendar-day me-2"></i>Today's Jobs
                                                                <span class="badge bg-primary float-end"><?php echo $today_count; ?></span>
                                                            </a>
                                                        </div>
                                                        <hr>
                                                        <h6 class="mb-3">Branch Info</h6>
                                                        <div class="alert alert-info">
                                                            <i class="fas fa-store me-2"></i>
                                                            <strong>Current Branch:</strong> <?php echo htmlspecialchars($branch_name); ?><br>
                                                            <small>Branch ID: <?php echo $branch_id; ?></small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search in <?php echo htmlspecialchars($branch_name); ?>..." value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>">
                                            <button class="btn btn-outline-secondary" type="button" id="searchButton">
                                                <i class="fas fa-search"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="statusFilter">
                                            <option value="">All Status</option>
                                            <option value="pending" <?php echo (isset($_GET['status']) && $_GET['status'] == 'pending') ? 'selected' : ''; ?>>Pending</option>
                                            <option value="in_progress" <?php echo (isset($_GET['status']) && $_GET['status'] == 'in_progress') ? 'selected' : ''; ?>>In Progress</option>
                                            <option value="completed" <?php echo (isset($_GET['status']) && $_GET['status'] == 'completed') ? 'selected' : ''; ?>>Completed</option>
                                            <option value="delivered" <?php echo (isset($_GET['status']) && $_GET['status'] == 'delivered') ? 'selected' : ''; ?>>Delivered</option>
                                            <option value="cancelled" <?php echo (isset($_GET['status']) && $_GET['status'] == 'cancelled') ? 'selected' : ''; ?>>Cancelled</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="priorityFilter">
                                            <option value="">All Priority</option>
                                            <option value="overdue" <?php echo (isset($_GET['priority']) && $_GET['priority'] == 'overdue') ? 'selected' : ''; ?>>Overdue</option>
                                            <option value="due_today" <?php echo (isset($_GET['priority']) && $_GET['priority'] == 'due_today') ? 'selected' : ''; ?>>Due Today</option>
                                            <option value="due_soon" <?php echo (isset($_GET['priority']) && $_GET['priority'] == 'due_soon') ? 'selected' : ''; ?>>Due Soon</option>
                                            <option value="no_due" <?php echo (isset($_GET['priority']) && $_GET['priority'] == 'no_due') ? 'selected' : ''; ?>>No Due Date</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <input type="date" class="form-control" id="dateFilter" placeholder="Filter by date" value="<?php echo isset($_GET['date']) ? htmlspecialchars($_GET['date']) : ''; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <select class="form-select" id="technicianFilter">
                                            <option value="">All Technicians</option>
                                            <option value="tech1">Technician 1</option>
                                            <option value="tech2">Technician 2</option>
                                            <option value="tech3">Technician 3</option>
                                        </select>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-12">
                                        <div class="d-flex gap-2 align-items-center flex-wrap">
                                            <select class="form-select" id="bulkStatus" style="width: auto;">
                                                <option value="">Bulk Status Update</option>
                                                <option value="in_progress">Mark as In Progress</option>
                                                <option value="completed">Mark as Completed</option>
                                                <option value="delivered">Mark as Delivered</option>
                                                <option value="cancelled">Mark as Cancelled</option>
                                            </select>
                                            <button type="button" class="btn btn-outline-primary" id="applyBulkAction">
                                                Apply to Selected
                                            </button>
                                            <div class="ms-auto">
                                                <span id="selectedCount" class="badge bg-primary">0 job cards selected</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped mb-0" id="trackingTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th width="50">
                                                    <div class="form-check">
                                                        <input class="form-check-input" type="checkbox" id="selectAll">
                                                    </div>
                                                </th>
                                                <th>Job Card</th>
                                                <th>Customer & Device</th>
                                                <th>Service Details</th>
                                                <th>Timeline</th>
                                                <th>Status</th>
                                                <th>Technician</th>
                                                <th width="100">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters - ONLY FOR LOGGED-IN BRANCH
                                            $where_conditions = array();
                                            $where_conditions[] = "branch_id = $branch_id"; // Only show job cards from logged-in branch

// Status filter
                                            if (isset($_GET['status']) && !empty($_GET['status'])) {
                                                $where_conditions[] = "status = '" . $conn->real_escape_string($_GET['status']) . "'";
                                            }

// Priority filter
                                            if (isset($_GET['priority']) && !empty($_GET['priority'])) {
                                                switch($_GET['priority']) {
                                                    case 'overdue':
                                                        $where_conditions[] = "estimated_delivery < CURDATE() AND status NOT IN ('delivered', 'cancelled')";
                                                        break;
                                                    case 'due_today':
                                                        $where_conditions[] = "estimated_delivery = CURDATE() AND status NOT IN ('delivered', 'cancelled')";
                                                        break;
                                                    case 'due_soon':
                                                        $where_conditions[] = "estimated_delivery BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 3 DAY) AND status NOT IN ('delivered', 'cancelled')";
                                                        break;
                                                    case 'no_due':
                                                        $where_conditions[] = "estimated_delivery IS NULL";
                                                        break;
                                                }
                                            }

// Date filter
                                            if (isset($_GET['date']) && !empty($_GET['date'])) {
                                                $where_conditions[] = "DATE(created_at) = '" . $conn->real_escape_string($_GET['date']) . "'";
                                            }

// Search filter
                                            if (isset($_GET['search']) && !empty($_GET['search'])) {
                                                $search = $conn->real_escape_string($_GET['search']);
                                                $where_conditions[] = "(customer_name LIKE '%$search%' OR customer_phone LIKE '%$search%' OR jobcard_number LIKE '%$search%' OR brand LIKE '%$search%' OR model LIKE '%$search%')";
                                            }

$where_sql = "";
                                            if (!empty($where_conditions)) {
                                                $where_sql = "WHERE " . implode(" AND ", $where_conditions);
                                            }

// Sort order - prioritize overdue and due soon
                                            $sort_order = "
                                                CASE 
                                                    WHEN estimated_delivery < CURDATE() AND status NOT IN ('delivered', 'cancelled') THEN 1
                                                    WHEN estimated_delivery = CURDATE() AND status NOT IN ('delivered', 'cancelled') THEN 2
                                                    WHEN estimated_delivery BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 3 DAY) AND status NOT IN ('delivered', 'cancelled') THEN 3
                                                    ELSE 4
                                                END,
                                                estimated_delivery ASC,
                                                created_at DESC";

// Get total count for pagination
                                            $count_sql = "SELECT COUNT(*) as total FROM service_jobcards $where_sql";
                                            $count_result = $conn->query($count_sql);
                                            $total_jobcards = $count_result ? $count_result->fetch_assoc()['total'] : 0;

// Pagination
                                            $per_page = 15;
                                            $current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
                                            $offset = ($current_page - 1) * $per_page;
                                            $total_pages = $per_page > 0 ? ceil($total_jobcards / $per_page) : 1;

// Main query
                                            $sql = "SELECT * FROM service_jobcards 
                                                    $where_sql 
                                                    ORDER BY $sort_order 
                                                    LIMIT $offset, $per_page";
                                            
                                            $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
                                                while($jobcard = $result->fetch_assoc()) {
                                                    // Status badge
                                                    $status_badge = [
                                                        'pending' => 'warning',
                                                        'in_progress' => 'info', 
                                                        'completed' => 'success',
                                                        'delivered' => 'primary',
                                                        'cancelled' => 'danger'
                                                    ];
                                                    
                                                    // Priority badge
                                                    $priority_badge = '';
                                                    $today = date('Y-m-d');
                                                    $delivery_date = $jobcard['estimated_delivery'];
                                                    
                                                    if ($delivery_date && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled') {
                                                        $days_remaining = floor((strtotime($delivery_date) - strtotime($today)) / (60 * 60 * 24));
                                                        
                                                        if ($days_remaining < 0) {
                                                            $priority_badge = '<span class="badge bg-danger ms-1">Overdue</span>';
                                                        } elseif ($days_remaining == 0) {
                                                            $priority_badge = '<span class="badge bg-warning ms-1">Due Today</span>';
                                                        } elseif ($days_remaining <= 3) {
                                                            $priority_badge = '<span class="badge bg-info ms-1">Due Soon</span>';
                                                        }
                                                    }
                                            ?>
                                            <tr data-status="<?php echo $jobcard['status']; ?>"
                                                data-priority="<?php echo $priority_badge ? 'high' : 'normal'; ?>">
                                                <td>
                                                    <div class="form-check">
                                                        <input class="form-check-input jobcard-checkbox" type="checkbox" value="<?php echo $jobcard['id']; ?>">
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <h6 class="mb-0"><?php echo htmlspecialchars($jobcard['jobcard_number']); ?></h6>
                                                        <small class="text-muted">
                                                            <?php echo date('M j, Y', strtotime($jobcard['created_at'])); ?>
                                                        </small>
                                                        <div class="mt-1">
                                                            <span class="badge bg-primary"><i class="fas fa-store me-1"></i><?php echo htmlspecialchars($branch_name); ?></span>
                                                        </div>
                                                        <?php echo $priority_badge; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong><?php echo htmlspecialchars($jobcard['customer_name']); ?></strong>
                                                        <br>
                                                        <small class="text-muted">
                                                            <i class="fas fa-phone me-1"></i>
                                                            <?php echo htmlspecialchars($jobcard['customer_phone']); ?>
                                                        </small>
                                                        <br>
                                                        <small class="text-muted">
                                                            <?php echo htmlspecialchars($jobcard['brand']); ?> <?php echo htmlspecialchars($jobcard['model']); ?>
                                                        </small>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <small class="text-muted">
                                                            <strong>Problem:</strong> 
                                                            <?php echo substr(htmlspecialchars($jobcard['device_problem']), 0, 50); ?>...
                                                        </small>
                                                        <br>
                                                        <small class="text-muted">
                                                            <strong>Est. Cost:</strong> 
                                                            ₹<?php echo number_format($jobcard['estimated_cost'], 2); ?>
                                                        </small>
                                                        <?php if ($jobcard['advance_payment'] > 0): ?>
                                                        <br>
                                                        <small class="text-success">
                                                            <strong>Advance:</strong> 
                                                            ₹<?php echo number_format($jobcard['advance_payment'], 2); ?>
                                                        </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <small class="text-muted">
                                                            <strong>Created:</strong> 
                                                            <?php echo date('M j', strtotime($jobcard['created_at'])); ?>
                                                        </small>
                                                        <br>
                                                        <?php if ($jobcard['estimated_delivery']): ?>
                                                        <small class="<?php echo $priority_badge ? 'text-danger fw-bold' : 'text-muted'; ?>">
                                                            <strong>Est. Delivery:</strong> 
                                                            <?php echo date('M j, Y', strtotime($jobcard['estimated_delivery'])); ?>
                                                        </small>
                                                        <?php endif; ?>
                                                        <?php if ($jobcard['completed_at']): ?>
                                                        <br>
                                                        <small class="text-success">
                                                            <strong>Completed:</strong> 
                                                            <?php echo date('M j', strtotime($jobcard['completed_at'])); ?>
                                                        </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-center">
                                                        <span class="badge bg-<?php echo $status_badge[$jobcard['status']]; ?> mb-1">
                                                            <?php echo ucfirst(str_replace('_', ' ', $jobcard['status'])); ?>
                                                        </span>
                                                        <br>
                                                        <div class="btn-group btn-group-sm">
                                                            <?php if ($jobcard['status'] != 'pending'): ?>
                                                            <button type="button" class="btn btn-sm btn-outline-secondary" 
                                                                    onclick="updateJobcardStatus(<?php echo $jobcard['id']; ?>, 'pending')"
                                                                    title="Mark as Pending">
                                                                <i class="fas fa-clock"></i>
                                                            </button>
                                                            <?php endif; ?>
                                                            <?php if ($jobcard['status'] != 'in_progress'): ?>
                                                            <button type="button" class="btn btn-sm btn-outline-secondary" 
                                                                    onclick="updateJobcardStatus(<?php echo $jobcard['id']; ?>, 'in_progress')"
                                                                    title="Mark as In Progress">
                                                                <i class="fas fa-cogs"></i>
                                                            </button>
                                                            <?php endif; ?>
                                                            <?php if ($jobcard['status'] != 'completed'): ?>
                                                            <button type="button" class="btn btn-sm btn-outline-secondary" 
                                                                    onclick="updateJobcardStatus(<?php echo $jobcard['id']; ?>, 'completed')"
                                                                    title="Mark as Completed">
                                                                <i class="fas fa-check"></i>
                                                            </button>
                                                            <?php endif; ?>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <small class="text-muted">
                                                        <i class="fas fa-user-cog me-1"></i>
                                                        Not Assigned
                                                    </small>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-info" 
                                                                onclick="viewJobcardDetails(<?php echo $jobcard['id']; ?>)"
                                                                title="View Details">
                                                            <i class="fas fa-eye"></i>
                                                        </button>

<button type="button" class="btn btn-outline-success" 
                                                                onclick="printJobcard(<?php echo $jobcard['id']; ?>)"
                                                                title="Print">
                                                            <i class="fas fa-print"></i>
                                                        </button>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="8" class="text-center py-4">
                                                    <i class="fas fa-shipping-fast display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Job Cards Found in <?php echo htmlspecialchars($branch_name); ?></h5>
                                                    <p class="text-muted">No job cards match your search criteria in <?php echo htmlspecialchars($branch_name); ?>.</p>
                                                    <a href="service-jobcard.php" class="btn btn-primary">
                                                        <i class="fas fa-plus-circle me-2"></i>Create New Job Card in <?php echo htmlspecialchars($branch_name); ?>
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav>
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?php echo $current_page == 1 ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page - 1); ?>">Previous</a>
                                                </li>
                                                
                                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                    <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                                        <a class="page-link" href="<?php echo build_page_url($i); ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?php echo $current_page == $total_pages ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page + 1); ?>">Next</a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>

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

</div>
            
        </div>

<?php include('includes/footer.php')?>
    </div>

</div>

<?php include('includes/rightbar.php')?>

<div class="modal fade" id="bulkUpdateModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Bulk Status Update - <?php echo htmlspecialchars($branch_name); ?></h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="alert alert-info mb-3">
                        <i class="fas fa-store me-2"></i>Updating job cards in: <strong><?php echo htmlspecialchars($branch_name); ?></strong>
                    </div>
                    <p>Update status for <span id="bulkCount">0</span> selected job cards to:</p>
                    <div class="mb-3">
                        <select class="form-select" name="bulk_status" required>
                            <option value="">Select Status</option>
                            <option value="in_progress">In Progress</option>
                            <option value="completed">Completed</option>
                            <option value="delivered">Delivered</option>
                            <option value="cancelled">Cancelled</option>
                        </select>
                    </div>
                    <div id="bulkJobcardsInputs"></div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="bulk_update_status" class="btn btn-primary">Update Status in <?php echo htmlspecialchars($branch_name); ?></button>
                </div>
            </form>
        </div>
    </div>
</div>

<?php include('includes/scripts.php')?>

// Select All functionality
    selectAll.addEventListener('change', function() {
        jobcardCheckboxes.forEach(checkbox => {
            checkbox.checked = this.checked;
        });
        updateSelectedCount();
    });

// Update selected count
    function updateSelectedCount() {
        const selected = document.querySelectorAll('.jobcard-checkbox:checked').length;
        selectedCount.textContent = selected + ' job cards selected in <?php echo htmlspecialchars($branch_name); ?>';
    }

jobcardCheckboxes.forEach(checkbox => {
        checkbox.addEventListener('change', updateSelectedCount);
    });

// Bulk action
    applyBulkAction.addEventListener('click', function() {
        const action = bulkStatus.value;
        const selectedJobcards = Array.from(document.querySelectorAll('.jobcard-checkbox:checked'))
            .map(checkbox => checkbox.value);

if (!action) {
            alert('Please select a status to apply.');
            return;
        }

if (selectedJobcards.length === 0) {
            alert('Please select at least one job card.');
            return;
        }

// Show bulk update modal
        document.getElementById('bulkCount').textContent = selectedJobcards.length;
        
        // Create hidden inputs for selected job cards
        const inputsContainer = document.getElementById('bulkJobcardsInputs');
        inputsContainer.innerHTML = '';
        selectedJobcards.forEach(id => {
            const input = document.createElement('input');
            input.type = 'hidden';
            input.name = 'jobcard_ids[]';
            input.value = id;
            inputsContainer.appendChild(input);
        });

// Set the status in the modal
        document.querySelector('select[name="bulk_status"]').value = action;
        
        // Show the modal
        var bulkModal = new bootstrap.Modal(document.getElementById('bulkUpdateModal'));
        bulkModal.show();
    });

// Filter functionality
    function applyFilters() {
        const params = new URLSearchParams();
        
        if (statusFilter.value) params.set('status', statusFilter.value);
        if (priorityFilter.value) params.set('priority', priorityFilter.value);
        if (dateFilter.value) params.set('date', dateFilter.value);
        if (technicianFilter.value) params.set('technician', technicianFilter.value);
        if (searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'service-tracking.php?' + params.toString();
    }

searchButton.addEventListener('click', applyFilters);
    searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    statusFilter.addEventListener('change', applyFilters);
    priorityFilter.addEventListener('change', applyFilters);
    dateFilter.addEventListener('change', applyFilters);
    technicianFilter.addEventListener('change', applyFilters);

// Set current filter values from URL
    const urlParams = new URLSearchParams(window.location.search);
    if (urlParams.get('status')) statusFilter.value = urlParams.get('status');
    if (urlParams.get('priority')) priorityFilter.value = urlParams.get('priority');
    if (urlParams.get('date')) dateFilter.value = urlParams.get('date');
    if (urlParams.get('technician')) technicianFilter.value = urlParams.get('technician');
    if (urlParams.get('search')) searchInput.value = urlParams.get('search');
});

// Quick status update
function updateJobcardStatus(jobcardId, newStatus) {
    if (confirm('Are you sure you want to update the status in <?php echo htmlspecialchars($branch_name); ?>?')) {
        window.location.href = '?update_status=' + jobcardId + '&status=' + newStatus;
    }
}

// View job card details
function viewJobcardDetails(jobcardId) {
    window.location.href = 'jobcard-details.php?id=' + jobcardId + '&branch_id=<?php echo $branch_id; ?>';
}

// Print job card
function printJobcard(jobcardId) {
    window.open('print-jobcard.php?id=' + jobcardId + '&branch_id=<?php echo $branch_id; ?>', '_blank');
}

// Refresh tracking data
function refreshTracking() {
    window.location.reload();
}

// Auto-refresh every 30 seconds
setTimeout(() => {
    // Uncomment the line below to enable auto-refresh
    // refreshTracking();
}, 30000);

// Auto-focus search input on page load
setTimeout(() => {
    const searchInput = document.getElementById('searchInput');
    if (searchInput) {
        searchInput.focus();
    }
}, 500);
</script>

</body>
</html>

<?php
// Helper function for building pagination URLs
function build_page_url($page) {
    $params = $_GET;
    $params['page'] = max(1, intval($page));
    return 'service-tracking.php?' . http_build_query($params);
}

// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: service-tracking.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation