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.18 TB

🔧 Quick Actions

✏️ Editing: service-jobcard.php

<?php
session_start();
?>
<!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">

<?php
                // 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 new job card creation
                if (isset($_POST['create_jobcard'])) {
                    $customer_name = $conn->real_escape_string($_POST['customer_name']);
                    $customer_phone = $conn->real_escape_string($_POST['customer_phone']);
                    $customer_email = $conn->real_escape_string($_POST['customer_email']);
                    $customer_address = $conn->real_escape_string($_POST['customer_address']);
                    $device_type = $conn->real_escape_string($_POST['device_type']);
                    $brand = $conn->real_escape_string($_POST['brand']);
                    $model = $conn->real_escape_string($_POST['model']);
                    $imei_number = $conn->real_escape_string($_POST['imei_number']);
                    $serial_number = $conn->real_escape_string($_POST['serial_number']);
                    $device_problem = $conn->real_escape_string($_POST['device_problem']);
                    $device_condition = $conn->real_escape_string($_POST['device_condition']);
                    $accessories = $conn->real_escape_string($_POST['accessories']);
                    $estimated_cost = $conn->real_escape_string($_POST['estimated_cost']);
                    $advance_payment = $conn->real_escape_string($_POST['advance_payment']);
                    $estimated_delivery = $conn->real_escape_string($_POST['estimated_delivery']);
                    
                    // Generate job card number with branch prefix
                    $branch_prefix = strtoupper(substr($branch_name, 0, 3));
                    $jobcard_number = $branch_prefix . '-JC-' . date('Ymd') . '-' . str_pad(rand(1, 999), 3, '0', STR_PAD_LEFT);
                    
                    $sql = "INSERT INTO service_jobcards (
                        branch_id, jobcard_number, customer_name, customer_phone, customer_email, customer_address,
                        device_type, brand, model, imei_number, serial_number, device_problem,
                        device_condition, accessories, estimated_cost, advance_payment, estimated_delivery
                    ) VALUES (
                        $branch_id, '$jobcard_number', '$customer_name', '$customer_phone', '$customer_email', '$customer_address',
                        '$device_type', '$brand', '$model', '$imei_number', '$serial_number', '$device_problem',
                        '$device_condition', '$accessories', '$estimated_cost', '$advance_payment', '$estimated_delivery'
                    )";
                    
                    if ($conn->query($sql) === TRUE) {
                        $jobcard_id = $conn->insert_id;
                        logActivity($conn, 'service_jobcard', "New job card created in $branch_name: $jobcard_number for $customer_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 created successfully in ' . htmlspecialchars($branch_name) . '! Job Card Number: ' . $jobcard_number . '
                                <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 creating job card: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle job card status update
                if (isset($_POST['update_status'])) {
                    $jobcard_id = intval($_POST['jobcard_id']);
                    $new_status = $conn->real_escape_string($_POST['status']);
                    $technician_notes = $conn->real_escape_string($_POST['technician_notes']);
                    $actual_cost = $conn->real_escape_string($_POST['actual_cost']);
                    
                    // Only update if jobcard belongs to this branch
                    $sql = "UPDATE service_jobcards SET 
                            status = '$new_status',
                            technician_notes = '$technician_notes',
                            actual_cost = '$actual_cost',
                            updated_at = NOW()
                            WHERE id = $jobcard_id AND branch_id = $branch_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card status updated to: $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: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle job card completion
                if (isset($_POST['complete_jobcard'])) {
                    $jobcard_id = intval($_POST['jobcard_id']);
                    $final_cost = $conn->real_escape_string($_POST['final_cost']);
                    $payment_received = $conn->real_escape_string($_POST['payment_received']);
                    $service_notes = $conn->real_escape_string($_POST['service_notes']);
                    
                    // Only complete if jobcard belongs to this branch
                    $sql = "UPDATE service_jobcards SET 
                            status = 'completed',
                            actual_cost = '$final_cost',
                            payment_received = '$payment_received',
                            service_notes = '$service_notes',
                            completed_at = NOW(),
                            updated_at = NOW()
                            WHERE id = $jobcard_id AND branch_id = $branch_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        logActivity($conn, 'service_jobcard', "Job card completed and delivered 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 marked as completed and delivered 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 completing job card: ' . $conn->error . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }
                ?>

<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 Job Card Management</h4>
                                        <p class="mb-0">Managing service job cards 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-tools me-2"></i>Service Job Card Management - <?php echo htmlspecialchars($branch_name); ?>
                                    </h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#createJobcardModal">
                                            <i class="fas fa-plus-circle me-2"></i>Create New Job Card
                                        </button>
                                        <button type="button" class="btn btn-outline-primary" onclick="printJobCards()">
                                            <i class="fas fa-print me-2"></i>Print Job Cards
                                        </button>
                                    </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>
                                                </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">Pending<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
                                                    $pending_sql = "SELECT COUNT(*) as pending FROM service_jobcards WHERE status='pending' AND branch_id = $branch_id";
                                                    $pending_count = $conn->query($pending_sql)->fetch_assoc()['pending'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $pending_count; ?></h3>
                                                </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">In Progress<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-cogs fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $progress_sql = "SELECT COUNT(*) as progress FROM service_jobcards WHERE status='in_progress' AND branch_id = $branch_id";
                                                    $progress_count = $conn->query($progress_sql)->fetch_assoc()['progress'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $progress_count; ?></h3>
                                                </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 branch_id = $branch_id";
                                                    $completed_count = $conn->query($completed_sql)->fetch_assoc()['completed'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $completed_count; ?></h3>
                                                </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">Delivered<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-truck fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $delivered_sql = "SELECT COUNT(*) as delivered FROM service_jobcards WHERE status='delivered' AND branch_id = $branch_id";
                                                    $delivered_count = $conn->query($delivered_sql)->fetch_assoc()['delivered'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $delivered_count; ?></h3>
                                                </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">Cancelled<br><small><?php echo htmlspecialchars($branch_name); ?></small></h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-times-circle fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $cancelled_sql = "SELECT COUNT(*) as cancelled FROM service_jobcards WHERE status='cancelled' AND branch_id = $branch_id";
                                                    $cancelled_count = $conn->query($cancelled_sql)->fetch_assoc()['cancelled'];
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $cancelled_count; ?></h3>
                                                </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="deviceTypeFilter">
                                            <option value="">All Devices</option>
                                            <option value="Mobile" <?php echo (isset($_GET['device_type']) && $_GET['device_type'] == 'Mobile') ? 'selected' : ''; ?>>Mobile</option>
                                            <option value="Tablet" <?php echo (isset($_GET['device_type']) && $_GET['device_type'] == 'Tablet') ? 'selected' : ''; ?>>Tablet</option>
                                            <option value="Laptop" <?php echo (isset($_GET['device_type']) && $_GET['device_type'] == 'Laptop') ? 'selected' : ''; ?>>Laptop</option>
                                            <option value="Smart Watch" <?php echo (isset($_GET['device_type']) && $_GET['device_type'] == 'Smart Watch') ? 'selected' : ''; ?>>Smart Watch</option>
                                            <option value="Other" <?php echo (isset($_GET['device_type']) && $_GET['device_type'] == 'Other') ? 'selected' : ''; ?>>Other</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="sortFilter">
                                            <option value="recent" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'recent') ? 'selected' : ''; ?>>Recently Created</option>
                                            <option value="oldest" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'oldest') ? 'selected' : ''; ?>>Oldest First</option>
                                            <option value="delivery_soon" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'delivery_soon') ? 'selected' : ''; ?>>Delivery Soon</option>
                                            <option value="high_cost" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'high_cost') ? 'selected' : ''; ?>>High Cost First</option>
                                            <option value="low_cost" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'low_cost') ? 'selected' : ''; ?>>Low Cost First</option>
                                        </select>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped mb-0" id="jobcardsTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Job Card Details</th>
                                                <th>Customer Information</th>
                                                <th>Device Information</th>
                                                <th>Service Details</th>
                                                <th>Cost & Payment</th>
                                                <th>Status & Timeline</th>
                                                <th width="120">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']) . "'";
                                            }

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

// 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 imei_number LIKE '%$search%')";
                                            }

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

// Sort order
                                            $sort_order = "created_at DESC";
                                            if (isset($_GET['sort']) && !empty($_GET['sort'])) {
                                                switch($_GET['sort']) {
                                                    case 'oldest':
                                                        $sort_order = "created_at ASC";
                                                        break;
                                                    case 'delivery_soon':
                                                        $sort_order = "estimated_delivery ASC";
                                                        break;
                                                    case 'high_cost':
                                                        $sort_order = "estimated_cost DESC";
                                                        break;
                                                    case 'low_cost':
                                                        $sort_order = "estimated_cost ASC";
                                                        break;
                                                }
                                            }

// 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 = 10;
                                            $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'
                                                    ];
                                                    
                                                    // Check if delivery is overdue
                                                    $is_overdue = false;
                                                    if ($jobcard['estimated_delivery'] && $jobcard['status'] != 'delivered' && $jobcard['status'] != 'cancelled') {
                                                        $today = date('Y-m-d');
                                                        $delivery_date = date('Y-m-d', strtotime($jobcard['estimated_delivery']));
                                                        $is_overdue = $delivery_date < $today;
                                                    }
                                            ?>
                                            <tr data-status="<?php echo $jobcard['status']; ?>"
                                                data-device-type="<?php echo $jobcard['device_type']; ?>">
                                                <td>
                                                    <div>
                                                        <h6 class="mb-0"><?php echo htmlspecialchars($jobcard['jobcard_number']); ?></h6>
                                                        <small class="text-muted">
                                                            Created: <?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 if ($is_overdue): ?>
                                                            <br>
                                                            <span class="badge bg-danger mt-1">Overdue</span>
                                                        <?php endif; ?>
                                                    </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>
                                                        <?php if (!empty($jobcard['customer_email'])): ?>
                                                            <br>
                                                            <small class="text-muted">
                                                                <i class="fas fa-envelope me-1"></i>
                                                                <?php echo htmlspecialchars($jobcard['customer_email']); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong><?php echo htmlspecialchars($jobcard['device_type']); ?></strong>
                                                        <br>
                                                        <small class="text-muted">
                                                            <?php echo htmlspecialchars($jobcard['brand']); ?> <?php echo htmlspecialchars($jobcard['model']); ?>
                                                        </small>
                                                        <?php if (!empty($jobcard['imei_number'])): ?>
                                                            <br>
                                                            <small class="text-muted">
                                                                IMEI: <?php echo htmlspecialchars($jobcard['imei_number']); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong>Problem:</strong>
                                                        <small class="text-muted"><?php echo substr(htmlspecialchars($jobcard['device_problem']), 0, 50); ?>...</small>
                                                        <br>
                                                        <strong>Condition:</strong>
                                                        <small class="text-muted"><?php echo htmlspecialchars($jobcard['device_condition']); ?></small>
                                                        <?php if (!empty($jobcard['accessories'])): ?>
                                                            <br>
                                                            <strong>Accessories:</strong>
                                                            <small class="text-muted"><?php echo htmlspecialchars($jobcard['accessories']); ?></small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong>Est. Cost:</strong>
                                                        <span class="text-warning">₹<?php echo number_format($jobcard['estimated_cost'], 2); ?></span>
                                                        <br>
                                                        <strong>Advance:</strong>
                                                        <span class="text-success">₹<?php echo number_format($jobcard['advance_payment'], 2); ?></span>
                                                        <?php if (!empty($jobcard['actual_cost'])): ?>
                                                            <br>
                                                            <strong>Actual Cost:</strong>
                                                            <span class="text-primary">₹<?php echo number_format($jobcard['actual_cost'], 2); ?></span>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <span class="badge bg-<?php echo $status_badge[$jobcard['status']]; ?> mb-1">
                                                            <?php echo ucfirst(str_replace('_', ' ', $jobcard['status'])); ?>
                                                        </span>
                                                        <br>
                                                        <small class="text-muted">
                                                            Est. Delivery: <?php echo date('M j, Y', strtotime($jobcard['estimated_delivery'])); ?>
                                                        </small>
                                                        <?php if ($jobcard['completed_at']): ?>
                                                            <br>
                                                            <small class="text-success">
                                                                Completed: <?php echo date('M j, Y', strtotime($jobcard['completed_at'])); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </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-primary" 
                                                                onclick="updateJobcardStatus(<?php echo $jobcard['id']; ?>)"
                                                                title="Update Status">
                                                            <i class="fas fa-edit"></i>
                                                        </button>
                                                        <button type="button" class="btn btn-outline-success" 
                                                                onclick="printJobcard(<?php echo $jobcard['id']; ?>)"
                                                                title="Print Job Card">
                                                            <i class="fas fa-print"></i>
                                                        </button>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="7" class="text-center py-4">
                                                    <i class="fas fa-tools 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>
                                                    <button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#createJobcardModal">
                                                        <i class="fas fa-plus-circle me-2"></i>Create Your First Job Card in <?php echo htmlspecialchars($branch_name); ?>
                                                    </button>
                                                </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="createJobcardModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Create New Service Job Card - <?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">
                        <i class="fas fa-store me-2"></i>Creating job card for: <strong><?php echo htmlspecialchars($branch_name); ?></strong>
                    </div>
                    
                    <div class="row">
                        <div class="col-md-6">
                            <h6 class="border-bottom pb-2">Customer Information</h6>
                            <div class="mb-3">
                                <label for="customer_name" class="form-label">Customer Name <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="customer_name" name="customer_name" required>
                            </div>
                            <div class="mb-3">
                                <label for="customer_phone" class="form-label">Phone Number <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="customer_phone" name="customer_phone" required>
                            </div>
                            <div class="mb-3">
                                <label for="customer_email" class="form-label">Email Address</label>
                                <input type="email" class="form-control" id="customer_email" name="customer_email">
                            </div>
                            <div class="mb-3">
                                <label for="customer_address" class="form-label">Address</label>
                                <textarea class="form-control" id="customer_address" name="customer_address" rows="2"></textarea>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <h6 class="border-bottom pb-2">Device Information</h6>
                            <div class="mb-3">
                                <label for="device_type" class="form-label">Device Type <span class="text-danger">*</span></label>
                                <select class="form-select" id="device_type" name="device_type" required>
                                    <option value="">Select Device Type</option>
                                    <option value="Mobile">Mobile Phone</option>
                                    <option value="Tablet">Tablet</option>
                                    <option value="Laptop">Laptop</option>
                                    <option value="Smart Watch">Smart Watch</option>
                                    <option value="Other">Other</option>
                                </select>
                            </div>
                            <div class="mb-3">
                                <label for="brand" class="form-label">Brand <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="brand" name="brand" required>
                            </div>
                            <div class="mb-3">
                                <label for="model" class="form-label">Model <span class="text-danger">*</span></label>
                                <input type="text" class="form-control" id="model" name="model" required>
                            </div>
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label for="imei_number" class="form-label">IMEI Number</label>
                                        <input type="text" class="form-control" id="imei_number" name="imei_number">
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label for="serial_number" class="form-label">Serial Number</label>
                                        <input type="text" class="form-control" id="serial_number" name="serial_number">
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="row mt-3">
                        <div class="col-md-6">
                            <h6 class="border-bottom pb-2">Service Details</h6>
                            <div class="mb-3">
                                <label for="device_problem" class="form-label">Device Problem/Issue <span class="text-danger">*</span></label>
                                <textarea class="form-control" id="device_problem" name="device_problem" rows="3" required></textarea>
                            </div>
                            <div class="mb-3">
                                <label for="device_condition" class="form-label">Device Physical Condition</label>
                                <textarea class="form-control" id="device_condition" name="device_condition" rows="2"></textarea>
                            </div>
                            <div class="mb-3">
                                <label for="accessories" class="form-label">Accessories Received</label>
                                <input type="text" class="form-control" id="accessories" name="accessories" placeholder="Charger, Cable, Case, etc.">
                            </div>
                        </div>
                        <div class="col-md-6">
                            <h6 class="border-bottom pb-2">Cost & Timeline</h6>
                            <div class="mb-3">
                                <label for="estimated_cost" class="form-label">Estimated Cost (₹)</label>
                                <input type="number" class="form-control" id="estimated_cost" name="estimated_cost" step="0.01" min="0">
                            </div>
                            <div class="mb-3">
                                <label for="advance_payment" class="form-label">Advance Payment (₹)</label>
                                <input type="number" class="form-control" id="advance_payment" name="advance_payment" step="0.01" min="0" value="0">
                            </div>
                            <div class="mb-3">
                                <label for="estimated_delivery" class="form-label">Estimated Delivery Date</label>
                                <input type="date" class="form-control" id="estimated_delivery" name="estimated_delivery">
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="create_jobcard" class="btn btn-success">Create Job Card in <?php echo htmlspecialchars($branch_name); ?></button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="updateStatusModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Update Job Card Status - <?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="">
                <input type="hidden" id="update_jobcard_id" name="jobcard_id">
                <div class="modal-body">
                    <div class="alert alert-info mb-3">
                        <i class="fas fa-store me-2"></i>Updating job card in: <strong><?php echo htmlspecialchars($branch_name); ?></strong>
                    </div>
                    <div class="mb-3">
                        <label for="status" class="form-label">Status <span class="text-danger">*</span></label>
                        <select class="form-select" id="status1" name="status" required>
                            <option value="pending">Pending</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 class="mb-3">
                        <label for="technician_notes" class="form-label">Technician Notes</label>
                        <textarea class="form-control" id="technician_notes" name="technician_notes" rows="3"></textarea>
                    </div>
                    <div class="mb-3">
                        <label for="actual_cost" class="form-label">Actual Cost (₹)</label>
                        <input type="number" class="form-control" id="actual_cost" name="actual_cost" step="0.01" min="0">
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="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')?>

// Filter functionality
    function applyFilters() {
        const params = new URLSearchParams();
        
        if (statusFilter.value) params.set('status', statusFilter.value);
        if (deviceTypeFilter.value) params.set('device_type', deviceTypeFilter.value);
        if (dateFilter.value) params.set('date', dateFilter.value);
        if (sortFilter.value) params.set('sort', sortFilter.value);
        if (searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'service-jobcard.php?' + params.toString();
    }

searchButton.addEventListener('click', applyFilters);
    searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    statusFilter.addEventListener('change', applyFilters);
    deviceTypeFilter.addEventListener('change', applyFilters);
    dateFilter.addEventListener('change', applyFilters);
    sortFilter.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('device_type')) deviceTypeFilter.value = urlParams.get('device_type');
    if (urlParams.get('date')) dateFilter.value = urlParams.get('date');
    if (urlParams.get('sort')) sortFilter.value = urlParams.get('sort');
    if (urlParams.get('search')) searchInput.value = urlParams.get('search');
});

// Update job card status
function updateJobcardStatus(jobcardId) {
    document.getElementById('update_jobcard_id').value = jobcardId;
    
    // Show the modal
    var updateModal = new bootstrap.Modal(document.getElementById('updateStatusModal'));
    updateModal.show();
}

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

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

// Print all job cards
function printJobCards() {
    window.print();
}

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

// Set default estimated delivery date to 3 days from now
const estimatedDelivery = document.getElementById('estimated_delivery');
if (estimatedDelivery) {
    const today = new Date();
    const threeDaysLater = new Date(today);
    threeDaysLater.setDate(today.getDate() + 3);
    
    const formattedDate = threeDaysLater.toISOString().split('T')[0];
    estimatedDelivery.min = today.toISOString().split('T')[0];
    estimatedDelivery.value = formattedDate;
}
</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-jobcard.php?' . http_build_query($params);
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: service-jobcard.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation