<?php
require_once 'config.php';
require_once 'database.php';
require_once 'models/User.php';
require_once 'models/Ticket.php';
require_once 'models/KnowledgeBase.php';
require_once 'models/Feedback.php';

// Check if user is logged in
session_start();
if (!isset($_SESSION['user'])) {
    header('Location: login.php');
    exit;
}

 $user = get_helpdesk_user();
 $userModel = new User(); // CRITICAL FIX: Added this line to prevent fatal error in AJAX calls
 $ticketModel = new Ticket();
 $kbModel = new KnowledgeBase();
 $feedbackModel = new Feedback();

// Handle all form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        switch ($_POST['action']) {
            case 'create_case':
                $description = trim($_POST['description'] ?? '');
                $category = $_POST['category'] ?? '';
                $caseType = $_POST['case_type'] ?? '';
                $priority = $_POST['priority'] ?? 'Low';
                $progress = 'Not Started';
                $attachments = $_FILES['attachments'] ?? [];
                
                if (empty($description) || empty($category) || empty($caseType)) {
                    $_SESSION['error'] = 'Please fill in all required fields';
                } else {
                    try {
                        $result = $ticketModel->createCase($description, $category, $caseType, $priority, $progress, $attachments, $user['username']);
                        if ($result) {
                            $_SESSION['message'] = "✅ Case created successfully with ID: {$result['caseId']}";
                            if ($result['assignee']) {
                                $_SESSION['message'] .= " Assigned to: {$result['assignee']}";
                            }
                        } else {
                            $_SESSION['error'] = "Failed to create case";
                        }
                    } catch (Exception $e) {
                        $_SESSION['error'] = 'Error creating case: ' . $e->getMessage();
                    }
                }
                header('Location: index.php');
                exit;
                
            case 'update_case':
                $caseId = $_POST['case_id'] ?? '';
                $updates = [];
                
                if (!empty($_POST['progress'])) {
                    $updates['progress'] = $_POST['progress'];
                }
                
                if (!empty($_POST['assignee'])) {
                    $updates['assignee'] = $_POST['assignee'];
                }
                
                if (!empty($_POST['comments'])) {
                    $updates['comments'] = $_POST['comments'];
                }
                
                if (empty($updates)) {
                    $_SESSION['error'] = 'No updates provided';
                } else {
                    try {
                        $result = $ticketModel->updateCase($caseId, $updates, $user['username']);
                        if ($result) {
                            $_SESSION['message'] = "Case $caseId updated successfully";
                        } else {
                            $_SESSION['error'] = "Failed to update case";
                        }
                    } catch (Exception $e) {
                        $_SESSION['error'] = 'Error updating case: ' . $e->getMessage();
                    }
                }
                header('Location: index.php');
                exit;
                
            case 'approve_case':
                $caseId = $_POST['case_id'] ?? '';
                
                if ($caseId) {
                    $result = $ticketModel->approveCase($caseId, $user['username']);
                    if ($result) {
                        $_SESSION['message'] = "✅ Case $caseId approved successfully!";
                    } else {
                        $_SESSION['error'] = "Failed to approve case";
                    }
                }
                header('Location: index.php');
                exit;
                
            case 'delete_case':
                $caseId = $_POST['case_id'] ?? '';
                
                if ($caseId) {
                    $result = $ticketModel->deleteCase($caseId, $user['username']);
                    if ($result) {
                        $_SESSION['message'] = "Case $caseId deleted successfully!";
                    } else {
                        $_SESSION['error'] = "Failed to delete case";
                    }
                }
                header('Location: index.php');
                exit;
        }
    }
}

// Handle AJAX requests
if (isset($_GET['action'])) { // CORRECTED: Added missing closing parenthesis
    switch ($_GET['action']) {
        case 'get_case':
            $caseId = $_GET['id'] ?? '';
            if ($caseId) {
                header('Content-Type: application/json');
                $case = $ticketModel->getCaseById($caseId);
                if ($case) {
                    echo json_encode($case);
                } else {
                    echo json_encode(['error' => 'Case not found']);
                }
                exit;
            }
            break;
            
        case 'get_user':
            $username = $_GET['username'] ?? '';
            if ($username) {
                header('Content-Type: application/json');
                $user = $userModel->getUserInfo($username);
                if ($user) {
                    echo json_encode($user);
                } else {
                    echo json_encode(['error' => 'User not found']);
                }
                exit;
            }
            break;
            
        case 'get_categories':
            header('Content-Type: application/json');
            echo json_encode([
                'IT Case' => ['Software', 'Hardware', 'Network', 'CNET Case', 'Email Issue', 'Printer Issue', 'System Access'],
                'Maintenance Case' => ['General Service', 'Electric Case', 'COFFEE_MACHINE_CASE', 'REFRIGERATOR_CASE', 'HVAC', 'PLUMBING', 'OTHER_CASE']
            ]);
            exit;
            
        case 'get_case_types':
            $category = $_GET['category'] ?? '';
            if ($category) {
                header('Content-Type: application/json');
                if ($category === 'IT Case') {
                    echo json_encode([
                        'Software', 'Hardware', 'Network', 'CNET Case', 'Email Issue', 'Printer Issue', 'System Access'
                    ]);
                } else if ($category === 'Maintenance Case') {
                    echo json_encode([
                        'General Service', 'Electric Case', 'Coffee Machine Case', 'Refrigerator Case', 'HVAC', 'PLUMBING', 'Other Case'
                    ]);
                }
            }
            exit;
            
        case 'search_kb':
            $query = $_GET['q'] ?? '';
            if ($query) {
                header('content-type: application/json');
                $articles = $kbModel->searchArticles($query);
                echo json_encode($articles);
            }
            exit;
            
        case 'search_faq':
            $query = $_GET['q'] ?? '';
            if ($query) {
                header('content-type: application/json');
                $faqs = $feedbackModel->searchFAQ($query); // CORRECTED: was $this->feedbackModel
                echo json_encode($faqs);
            }
            exit;
            
        default:
            header('HTTP/1.0 404 Not Found');
            echo json_encode(['error' => 'Endpoint not found']);
            exit;
    }
}

// Get cases for AJAX requests
if (isset($_GET['get_cases'])) {
    $username = $_GET['username'] ?? '';
    $role = $_GET['role'] ?? '';
    $department = $_GET['department'] ?? '';
    
    if ($username && $role) {
        header('Content-Type: application/json');
        $cases = $ticketModel->getCases($username, $role, $department);
        echo json_encode($cases);
    } else {
        echo json_encode([]);
    }
    exit;
}

// Handle knowledge base search from AJAX
if (isset($_GET['search_kb'])) {
    $query = $_GET['search'] ?? '';
    if ($query) {
        header('Content-Type: application/json');
        $articles = $kbModel->searchArticles($query);
        echo json_encode($articles);
    } else {
        echo json_encode([]);
    }
}

// Dummy data for dashboard - replace with actual data fetching
 $totalCases = 150;
 $inProgressCases = 25;
 $doneCases = 110;
 $closedCases = 15;
 $recentCases = []; // This should be populated by a model call like $ticketModel->getRecentCases();
 $technicians = []; // This should be populated by a model call like $userModel->getUsersByRole('Technician');
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Kaldi's Coffee Help Desk</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <link rel="stylesheet" href="assets/css/style.css">
</head>
<body>
    <div class="container-fluid">
        <div class="row">
            <!-- Sidebar -->
            <nav class="col-md-3 col-lg-2 d-md-block bg-light sidebar">
                <div class="position-sticky pt-3">
                    <div class="text-center mb-4">
                        <img src="https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTviTd8s9_J0pBESz-EgQHk_p3KYnsaJBrpzQ&s" alt="Kaldi's Coffee Logo" class="img-fluid" style="max-height: 60px;">
                        <h4 class="mt-2">Kaldi's Coffee</h4>
                        <p class="text-muted">Help Desk System</p>
                    </div>
                    
                    <ul class="nav flex-column">
                        <li class="nav-item">
                            <a class="nav-link active" href="index.php">
                                <i class="fas fa-tachometer-alt"></i> Dashboard
                            </a>
                        </li>
                        <?php if ($user['role'] === 'User'): ?>
                        <li class="nav-item">
                            <a class="nav-link" href="#" data-bs-toggle="modal" data-bs-target="#createCaseModal">
                                <i class="fas fa-plus-circle"></i> Create Case
                            </a>
                        </li>
                        <?php endif; ?>
                        <li class="nav-item">
                            <a class="nav-link" href="tickets.php">
                                <i class="fas fa-table"></i> All Cases
                            </a>
                        </li>
                        <li class="nav-item">
                            <a class="nav-link" href="knowledge.php">
                                <i class="fas fa-book"></i> Knowledge Base
                            </a>
                        </li>
                        <?php if (in_array($user['role'], ['Admin', 'Manager'])): ?>
                        <li class="nav-item">
                            <a class="nav-link" href="reports.php">
                                <i class="fas fa-chart-line"></i> Reports
                            </a>
                        </li>
                        <?php endif; ?>
                        <li class="nav-item">
                            <a class="nav-link" href="evaluation.php">
                                <i class="fas fa-comment-dots"></i> Feedback
                            </a>
                        </li>
                        <?php if ($user['role'] === 'Admin'): ?>
                        <li class="nav-item">
                            <a class="nav-link" href="admin/dashboard.php">
                                <i class="fas fa-user-cog"></i> Admin Panel
                            </a>
                        </li>
                        <?php endif; ?>
                        <!-- CORRECTED: Link and permissions for Settings -->
                        <?php if (in_array($user['role'], ['Admin', 'Manager'])): ?>
                        <li class="nav-item">
                            <a class="nav-link" href="settings.php">
                                <i class="fas fa-cog"></i> Settings
                            </a>
                        </li>
                        <?php endif; ?>
                        <li class="nav-item mt-3">
                            <a class="nav-link text-danger" href="logout.php">
                                <i class="fas fa-sign-out-alt"></i> Logout
                            </a>
                        </li>
                    </ul>
                    
                    <div class="mt-4 p-3 bg-white rounded">
                        <div class="d-flex align-items-center">
                            <div class="flex-shrink-0">
                                <i class="fas fa-user-circle fa-2x text-primary"></i>
                            </div>
                            <div class="ms-3">
                                <div class="fw-bold"><?php echo htmlspecialchars($user['username']); ?></div>
                                <div class="text-muted"><?php echo htmlspecialchars($user['role']); ?></div>
                            </div>
                        </div>
                    </div>
                </div>
            </nav>
            
            <!-- Main content -->
            <main class="col-md-9 ms-sm-auto col-lg-10 px-md-4">
                <!-- ... The rest of your HTML content remains the same ... -->
                <div class="d-flex justify-content-between flex-wrap flex-md-nowrap align-items-center pt-3 pb-2 mb-3 border-bottom">
                    <h1 class="h2">Dashboard</h1>
                    <div class="btn-toolbar mb-2 mb-md-0">
                        <div class="btn-group me-2">
                            <button type="button" class="btn btn-sm btn-outline-secondary" onclick="location.reload()">
                                <i class="fas fa-sync-alt"></i> Refresh
                            </button>
                        </div>
                    </div>
                </div>
                
                <?php if (isset($_SESSION['message'])): ?>
                <div class="alert alert-success alert-dismissible fade show" role="alert">
                    <?php 
                    echo htmlspecialchars($_SESSION['message']); 
                    unset($_SESSION['message']);
                    ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>
                <?php endif; ?>
                
                <?php if (isset($_SESSION['error'])): ?>
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <?php 
                    echo htmlspecialchars($_SESSION['error']); 
                    unset($_SESSION['error']);
                    ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>
                <?php endif; ?>
                
                <!-- Statistics Cards -->
                <div class="row mb-4">
                    <div class="col-xl-3 col-md-6 mb-4">
                        <div class="card border-left-primary shadow h-100 py-2">
                            <div class="card-body">
                                <div class="row no-gutters align-items-center">
                                    <div class="col mr-2">
                                        <div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Total Cases</div>
                                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $totalCases; ?></div>
                                    </div>
                                    <div class="col-auto">
                                        <i class="fas fa-clipboard-list fa-2x text-gray-300"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6 mb-4">
                        <div class="card border-left-warning shadow h-100 py-2">
                            <div class="card-body">
                                <div class="row no-gutters align-items-center">
                                    <div class="col mr-2">
                                        <div class="text-xs font-weight-bold text-warning text-uppercase mb-1">In Progress</div>
                                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $inProgressCases; ?></div>
                                    </div>
                                    <div class="col-auto">
                                        <i class="fas fa-spinner fa-2x text-gray-300"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6 mb-4">
                        <div class="card border-left-success shadow h-100 py-2">
                            <div class="card-body">
                                <div class="row no-gutters align-items-center">
                                    <div class="col mr-2">
                                        <div class="text-xs font-weight-bold text-success text-uppercase mb-1">Done</div>
                                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $doneCases; ?></div>
                                    </div>
                                    <div class="col-auto">
                                        <i class="fas fa-check-circle fa-2x text-gray-300"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6 mb-4">
                        <div class="card border-left-info shadow h-100 py-2">
                            <div class="card-body">
                                <div class="row no-gutters align-items-center">
                                    <div class="col mr-2">
                                        <div class="text-xs font-weight-bold text-info text-uppercase mb-1">Closed</div>
                                        <div class="h5 mb-0 font-weight-bold text-gray-800"><?php echo $closedCases; ?></div>
                                    </div>
                                    <div class="col-auto">
                                        <i class="fas fa-lock fa-2x text-gray-300"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                
                <!-- Recent Cases -->
                <div class="card shadow mb-4">
                    <div class="card-header py-3 d-flex justify-content-between align-items-center">
                        <h6 class="m-0 font-weight-bold text-primary">Recent Cases</h6>
                        <a href="tickets.php" class="btn btn-sm btn-primary">View All</a>
                    </div>
                    <div class="card-body">
                        <?php if (empty($recentCases)): ?>
                        <div class="text-center py-4">
                            <i class="fas fa-inbox fa-3x text-gray-300 mb-3"></i>
                            <p class="text-muted">No recent cases found</p>
                        </div>
                        <?php else: ?>
                        <div class="table-responsive">
                            <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                <thead>
                                    <tr>
                                        <th>Case ID</th>
                                        <th>Description</th>
                                        <th>Category</th>
                                        <th>Priority</th>
                                        <th>Progress</th>
                                        <th>Submitter</th>
                                        <th>Assignee</th>
                                        <th>Created</th>
                                        <th>Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php foreach ($recentCases as $case): ?>
                                    <tr>
                                        <td><?php echo htmlspecialchars($case['case_id']); ?></td>
                                        <td><?php echo htmlspecialchars(substr($case['description'], 0, 50)) . (strlen($case['description']) > 50 ? '...' : ''); ?></td>
                                        <td><?php echo htmlspecialchars($case['category']); ?></td>
                                        <td>
                                            <span class="badge bg-<?php echo $case['priority'] === 'High' ? 'danger' : ($case['priority'] === 'Medium' ? 'warning' : 'success'); ?>">
                                                <?php echo htmlspecialchars($case['priority']); ?>
                                            </span>
                                        </td>
                                        <td>
                                            <span class="badge bg-<?php 
                                                echo match($case['progress']) {
                                                    'Not Started' => 'secondary',
                                                    'In Progress' => 'warning',
                                                    'Escalated' => 'danger',
                                                    'Done' => 'success',
                                                    'Closed' => 'info',
                                                    'Approved' => 'primary',
                                                    default => 'secondary'
                                                }; 
                                            ?>">
                                                <?php echo htmlspecialchars($case['progress']); ?>
                                            </span>
                                        </td>
                                        <td><?php echo htmlspecialchars($case['submitter']); ?></td>
                                        <td><?php echo htmlspecialchars($case['assignee'] ?? 'Unassigned'); ?></td>
                                        <td><?php echo date('M d, Y', strtotime($case['date_created'])); ?></td>
                                        <td>
                                            <div class="btn-group btn-group-sm">
                                                <button type="button" class="btn btn-primary" onclick="viewCase('<?php echo $case['case_id']; ?>')">
                                                    <i class="fas fa-eye"></i>
                                                </button>
                                                <?php if (in_array($user['role'], ['Admin', 'Manager']) || ($user['role'] === 'Technician' && $case['assignee'] === $user['username'])): ?>
                                                <button type="button" class="btn btn-warning" onclick="updateCase('<?php echo $case['case_id']; ?>')">
                                                    <i class="fas fa-edit"></i>
                                                </button>
                                                <?php endif; ?>
                                                <?php if ($user['role'] === 'User' && $case['submitter'] === $user['username'] && $case['progress'] === 'Closed'): ?>
                                                <button type="button" class="btn btn-success" onclick="approveCase('<?php echo $case['case_id']; ?>')">
                                                    <i class="fas fa-check"></i>
                                                </button>
                                                <?php endif; ?>
                                                <?php if ($user['role'] === 'Admin'): ?>
                                                <button type="button" class="btn btn-danger" onclick="deleteCase('<?php echo $case['case_id']; ?>')">
                                                    <i class="fas fa-trash"></i>
                                                </button>
                                                <?php endif; ?>
                                            </div>
                                        </td>
                                    </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                        <?php endif; ?>
                    </div>
                </div>
            </main>
        </div>
    </div>
    
    <!-- Create Case Modal -->
    <div class="modal fade" id="createCaseModal" tabindex="-1" aria-labelledby="createCaseModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="createCaseModalLabel">Create New Case</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form action="index.php" method="post" enctype="multipart/form-data">
                    <div class="modal-body">
                        <input type="hidden" name="action" value="create_case">
                        
                        <div class="mb-3">
                            <label for="description" class="form-label">Description</label>
                            <textarea class="form-control" id="description" name="description" rows="3" required></textarea>
                        </div>
                        
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label for="category" class="form-label">Category</label>
                                <select class="form-select" id="category" name="category" onchange="updateCaseTypes()" required>
                                    <option value="">Select Category</option>
                                    <option value="IT Case">IT Case</option>
                                    <option value="Maintenance Case">Maintenance Case</option>
                                </select>
                            </div>
                            
                            <div class="col-md-6 mb-3">
                                <label for="case_type" class="form-label">Case Type</label>
                                <select class="form-select" id="case_type" name="case_type" required>
                                    <option value="">Select Case Type</option>
                                </select>
                            </div>
                        </div>
                        
                        <div class="row">
                            <div class="col-md-6 mb-3">
                                <label for="priority" class="form-label">Priority</label>
                                <select class="form-select" id="priority" name="priority">
                                    <option value="Low">Low</option>
                                    <option value="Medium">Medium</option>
                                    <option value="High">High</option>
                                </select>
                            </div>
                            
                            <div class="col-md-6 mb-3">
                                <label for="attachments" class="form-label">Attachments</label>
                                <input class="form-control" type="file" id="attachments" name="attachments[]" multiple accept=".jpg,.jpeg,.png,.pdf">
                                <div class="form-text">JPEG, PNG, PDF files up to 5MB each</div>
                            </div>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-primary">Submit Case</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    
    <!-- Update Case Modal -->
    <div class="modal fade" id="updateCaseModal" tabindex="-1" aria-labelledby="updateCaseModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="updateCaseModalLabel">Update Case</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <form action="index.php" method="post">
                    <div class="modal-body">
                        <input type="hidden" name="action" value="update_case">
                        <input type="hidden" id="update_case_id" name="case_id">
                        
                        <div class="mb-3">
                            <label for="update_progress" class="form-label">Progress</label>
                            <select class="form-select" id="update_progress" name="progress" onchange="handleProgressChange()">
                                <option value="Not Started">Not Started</option>
                                <option value="In Progress">In Progress</option>
                                <option value="Escalated">Escalated</option>
                                <option value="Done">Done</option>
                                <option value="Closed">Closed</option>
                                <option value="Approved">Approved</option>
                            </select>
                        </div>
                        
                        <div class="mb-3">
                            <label for="update_assignee" class="form-label">Assignee</label>
                            <select class="form-select" id="update_assignee" name="assignee">
                                <option value="">Unassigned</option>
                                <?php foreach ($technicians as $technician): ?>
                                <option value="<?php echo htmlspecialchars($technician); ?>"><?php echo htmlspecialchars($technician); ?></option>
                                <?php endforeach; ?>
                            </select>
                        </div>
                        
                        <div class="mb-3">
                            <label for="update_comments" class="form-label">Comments</label>
                            <textarea class="form-control" id="update_comments" name="comments" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-primary">Update Case</button>
                    </div>
                </form>
            </div>
        </div>
    </div>
    
    <!-- View Case Modal -->
    <div class="modal fade" id="viewCaseModal" tabindex="-1" aria-labelledby="viewCaseModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="viewCaseModalLabel">Case Details</h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div id="caseDetails">
                        <!-- Case details will be loaded here -->
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>
    
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
    <script>
        // Case types based on category
        const itCaseTypes = ['Software', 'Hardware', 'Network', 'CNET Case', 'Email Issue', 'Printer Issue', 'System Access'];
        const maintenanceCaseTypes = ['General Service', 'Electric Case', 'Coffee Machine Case', 'Refrigerator Case', 'HVAC', 'PLUMBING', 'Other Case'];
        
        // Update case types based on category
        function updateCaseTypes() {
            const category = document.getElementById('category').value;
            const caseTypeSelect = document.getElementById('case_type');
            
            // Clear existing options
            caseTypeSelect.innerHTML = '<option value="">Select Case Type</option>';
            
            // Add options based on category
            let caseTypes = [];
            if (category === 'IT Case') {
                caseTypes = itCaseTypes;
            } else if (category === 'Maintenance Case') {
                caseTypes = maintenanceCaseTypes;
            }
            
            caseTypes.forEach(type => {
                const option = document.createElement('option');
                option.value = type;
                option.textContent = type;
                caseTypeSelect.appendChild(option);
            });
        }
        
        // Handle progress change in update modal
        function handleProgressChange() {
            const progress = document.getElementById('update_progress').value;
            const assigneeSelect = document.getElementById('update_assignee');
            
            if (progress === 'Escalated') {
                assigneeSelect.disabled = false;
            } else {
                assigneeSelect.disabled = true;
            }
        }
        
        // View case details
        function viewCase(caseId) {
            fetch(`index.php?action=get_case&id=${caseId}`)
                .then(response => response.json())
                .then(data => {
                    if (data.error) {
                        alert(data.error);
                        return;
                    }
                    const caseDetails = document.getElementById('caseDetails');
                    
                    let attachmentsHtml = 'None';
                    if (data.attachment_links) {
                        const attachments = data.attachment_links.split(';');
                        attachmentsHtml = attachments.map(link => 
                            `<a href="${link}" target="_blank" class="d-block mb-1">
                                <i class="fas fa-external-link-alt"></i> View Attachment
                            </a>`
                        ).join('');
                    }
                    
                    caseDetails.innerHTML = `
                        <div class="row mb-3">
                            <div class="col-md-6"><strong>Case ID:</strong> ${data.case_id}</div>
                            <div class="col-md-6"><strong>Category:</strong> ${data.category}</div>
                        </div>
                        <div class="row mb-3">
                            <div class="col-md-6"><strong>Case Type:</strong> ${data.case_type}</div>
                            <div class="col-md-6"><strong>Priority:</strong> <span class="badge bg-${data.priority === 'High' ? 'danger' : (data.priority === 'Medium' ? 'warning' : 'success')}">${data.priority}</span></div>
                        </div>
                        <div class="row mb-3">
                            <div class="col-md-6"><strong>Progress:</strong> <span class="badge bg-secondary">${data.progress}</span></div>
                            <div class="col-md-6"><strong>Submitter:</strong> ${data.submitter}</div>
                        </div>
                        <div class="row mb-3">
                            <div class="col-md-6"><strong>Assignee:</strong> ${data.assignee || 'Unassigned'}</div>
                            <div class="col-md-6"><strong>Created:</strong> ${new Date(data.date_created).toLocaleString()}</div>
                        </div>
                        <div class="mb-3"><strong>Description:</strong><p>${data.description}</p></div>
                        <div class="mb-3"><strong>Comments:</strong><p>${data.comments || 'None'}</p></div>
                        <div class="mb-3"><strong>Attachments:</strong><p>${attachmentsHtml}</p></div>
                    `;
                    
                    const modal = new bootstrap.Modal(document.getElementById('viewCaseModal'));
                    modal.show();
                })
                .catch(error => {
                    console.error('Error fetching case details:', error);
                    alert('Error loading case details');
                });
        }
        
        // Update case
        function updateCase(caseId) {
            document.getElementById('update_case_id').value = caseId;
            const modal = new bootstrap.Modal(document.getElementById('updateCaseModal'));
            modal.show();
        }
        
        // Approve case
        function approveCase(caseId) {
            if (confirm('Are you sure you want to approve this case?')) {
                const form = document.createElement('form');
                form.method = 'POST';
                form.action = 'index.php';
                
                const actionInput = document.createElement('input');
                actionInput.type = 'hidden';
                actionInput.name = 'action';
                actionInput.value = 'approve_case';
                form.appendChild(actionInput);
                
                const caseIdInput = document.createElement('input');
                caseIdInput.type = 'hidden';
                caseIdInput.name = 'case_id';
                caseIdInput.value = caseId;
                form.appendChild(caseIdInput);
                
                document.body.appendChild(form);
                form.submit();
            }
        }
        
        // Delete case
        function deleteCase(caseId) {
            if (confirm('Are you sure you want to delete this case? This action cannot be undone.')) {
                const form = document.createElement('form');
                form.method = 'POST';
                form.action = 'index.php';
                
                const actionInput = document.createElement('input');
                actionInput.type = 'hidden';
                actionInput.name = 'action';
                actionInput.value = 'delete_case';
                form.appendChild(actionInput);
                
                const caseIdInput = document.createElement('input');
                caseIdInput.type = 'hidden';
                caseIdInput.name = 'case_id';
                caseIdInput.value = caseId;
                form.appendChild(caseIdInput);
                
                document.body.appendChild(form);
                form.submit();
            }
        }
    </script>
</body>
</html>