<?php
require_once('source/session.php');
require_once('source/error.php');
require_once('source/dbconfig.php');
require_once('source/dbconfig4.php'); // Add central settings
require_once('source/function.php');
require_once('source/restrict_admin.php');

// Get current branch settings from central database
$branchCode = getCurrentBranchCode();
$branchSettings = getSchoolSettings($branchCode);

if ($branchSettings) {
    $schoolName = $branchSettings['branch_name'];
    $schoolAddress = $branchSettings['branch_address'];
    $schoolShortName = $branchSettings['branch_short_name'];
    $schoolMotto = $branchSettings['school_motto'];
    $schoolLogo = $branchSettings['school_logo_path'];
    $schoolPhone = $branchSettings['contact_phone'];
    $schoolEmail = $branchSettings['contact_email'];
    $footerText = $branchSettings['footer_text'];
    $footerCopyright = $branchSettings['footer_copyright'];
} else {
    // Fallback values if no branch settings found
    $schoolName = "Henzy Royal International School";
    $schoolAddress = "No 17 Amadi Street, Amakohia, Uratta Owerri Imo State Nigeria";
    $schoolShortName = "HRIS";
    $schoolMotto = "THE PRIDE OF EXCELLENCE";
    $schoolLogo = "coll_logo.png";
    $schoolPhone = "+234 803 292 9756";
    $schoolEmail = "support@hris.com.ng";
    $footerText = "THE PRIDE OF EXCELLENCE";
    $footerCopyright = "Copyright © Henzy Royal International School";
}

// Get system-wide settings
$supportPhone = getSystemSetting('support_phone') ?: $schoolPhone;
$supportEmail = getSystemSetting('support_email') ?: $schoolEmail;
$developerName = getSystemSetting('developer_name') ?: 'DataSwift Coders';
$developerWebsite = getSystemSetting('developer_website') ?: 'https://dataswift.com.ng';

// Handle all actions (add, edit, delete)
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action'])) {
        $action = $_POST['action'];
        
        switch ($action) {
            case 'add':
                // Add new subject
                if (isset($_POST['subject']) && !empty(trim($_POST['subject']))) {
                    $subject = trim($_POST['subject']);
                    
                    // Check if subject already exists
                    $exists = sql($DBH, "SELECT COUNT(*) FROM tbl_subject WHERE subject = ?", [$subject], "rows")[0][0];
                    
                    if ($exists == 0) {
                        $result = sql($DBH, "INSERT INTO tbl_subject (subject) VALUES (?)", [$subject], "count");
                        $_SESSION['msg'] = $result ? "subject_added" : "error";
                    } else {
                        $_SESSION['msg'] = "subject_exists";
                    }
                }
                break;
                
            case 'edit':
                // Edit existing subject
                if (isset($_POST['id']) && isset($_POST['subject']) && !empty(trim($_POST['subject']))) {
                    $id = (int)$_POST['id'];
                    $subject = trim($_POST['subject']);
                    
                    // Check if new name already exists
                    $exists = sql($DBH, "SELECT COUNT(*) FROM tbl_subject WHERE subject = ? AND id != ?", [$subject, $id], "rows")[0][0];
                    
                    if ($exists == 0) {
                        $result = sql($DBH, "UPDATE tbl_subject SET subject = ? WHERE id = ?", [$subject, $id], "count");
                        $_SESSION['msg'] = $result ? "subject_updated" : "error";
                    } else {
                        $_SESSION['msg'] = "subject_exists";
                    }
                }
                break;
        }
        
        header("Location: post_subjects.php" . ($branchCode ? "?branch=" . $branchCode : ""));
        exit();
    }
} elseif (isset($_GET['delete_id'])) {
    // Handle delete action
    $delete_id = (int)$_GET['delete_id'];
    if ($delete_id > 0) {
        $result = sql($DBH, "DELETE FROM tbl_subject WHERE id = ?", [$delete_id], "count");
        $_SESSION['msg'] = $result ? "subject_deleted" : "error";
    }
    header("Location: post_subjects.php" . ($branchCode ? "?branch=" . $branchCode : ""));
    exit();
}

// Message handling
$msg = '';
if(isset($_SESSION['msg'])) {
    $messages = [
        "subject_added" => "Subject added successfully",
        "subject_updated" => "Subject updated successfully",
        "subject_deleted" => "Subject deleted successfully",
        "subject_exists" => "Subject already exists",
        "error" => "An error occurred, please try again"
    ];
    
    if(isset($messages[$_SESSION['msg']])) {
        $is_success = in_array($_SESSION['msg'], ["subject_added", "subject_updated", "subject_deleted"]);
        $alert_type = $is_success ? 'success' : 'danger';
        $msg = "<div class='alert alert-$alert_type text-center mb-4'>"
             . $messages[$_SESSION['msg']]
             . "</div>";
    }
    unset($_SESSION['msg']);
}

// Get admin full name
$admin_fullname = '';
$rows = sql($DBH, "SELECT fullname FROM tbl_admin WHERE status = ?", ["Active"], "rows");
if(!empty($rows)) {
    $admin_fullname = $rows[0]['fullname'];
}

// Get all branches for branch switcher
$allBranches = getAllBranches();
?>

<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>Manage Subjects - <?php echo $schoolName; ?></title>
  <link rel="icon" type="image/png" href="../<?php echo $schoolLogo; ?>">
  
  <!-- Bootstrap 5 CSS -->
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
  
  <!-- Font Awesome -->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
  
  <!-- Google Fonts -->
  <link href="https://fonts.googleapis.com/css2?family=Poppins:wght@300;400;500;600;700&display=swap" rel="stylesheet">
  
  <!-- Custom CSS -->
  <style>
    :root {
      --primary-blue: #1a4b8c;    /* Royal Blue */
      --secondary-gold: #FFD700;    /* Gold */
      --dark-blue: #0f2b4f;         /* Dark Blue */
      --light-blue: #4a7db5;         /* Medium Blue */
      --light-gold: #FFF1B8;          /* Light Gold */
      --bg-light: #f5f9ff;
    }
    
    body {
      font-family: 'Poppins', sans-serif;
      background-color: var(--bg-light);
      min-height: 100vh;
      display: flex;
      flex-direction: column;
    }
    
    /* Navbar Styles */
    .navbar {
      background: linear-gradient(135deg, var(--primary-blue), var(--dark-blue));
      box-shadow: 0 0.15rem 1.75rem 0 rgba(26, 75, 140, 0.2);
      position: fixed;
      top: 0;
      width: 100%;
      z-index: 1030;
      color: white;
      border-bottom: 2px solid var(--secondary-gold);
    }
    
    .navbar-brand {
      font-weight: 800;
      font-size: 1.2rem;
      color: white;
      display: flex;
      align-items: center;
    }
    
    .navbar-brand img {
      border-radius: 4px;
      margin-right: 10px;
    }
    
    /* Branch Badge */
    .branch-badge {
      background: var(--secondary-gold);
      color: var(--dark-blue);
      padding: 0.25rem 0.75rem;
      border-radius: 20px;
      font-size: 0.75rem;
      font-weight: 600;
      display: inline-block;
    }
    
    /* Sidebar Styles */
    .sidebar {
      background: linear-gradient(180deg, var(--dark-blue) 0%, var(--primary-blue) 100%);
      position: fixed;
      top: 56px;
      left: -250px;
      width: 250px;
      height: calc(100vh - 56px);
      transition: all 0.3s;
      z-index: 1000;
      overflow-y: auto;
      border-right: 3px solid var(--secondary-gold);
    }
    
    .sidebar.active {
      left: 0;
    }
    
    .sidebar .nav-link {
      color: rgba(255, 255, 255, 0.9);
      font-weight: 500;
      padding: 0.75rem 1rem;
      margin-bottom: 0.2rem;
      transition: all 0.2s;
      border-left: 3px solid transparent;
    }
    
    .sidebar .nav-link:hover {
      color: white;
      background-color: rgba(255, 215, 0, 0.15);
      border-left-color: var(--secondary-gold);
    }
    
    .sidebar .nav-link.active {
      color: var(--dark-blue);
      background-color: var(--secondary-gold);
      border-left-color: var(--dark-blue);
      font-weight: 600;
    }
    
    .sidebar .nav-link i {
      margin-right: 0.5rem;
      width: 20px;
      text-align: center;
    }
    
    .sidebar-logo {
      text-align: center;
      margin-bottom: 1rem;
      padding: 1rem;
    }
    
    .logo-text {
      font-size: 1.5rem;
      font-weight: 900;
      color: white;
      letter-spacing: 2px;
      line-height: 1.2;
    }
    
    .logo-text span {
      color: var(--secondary-gold);
    }
    
    .logo-tagline {
      font-size: 0.65rem;
      color: var(--secondary-gold);
      letter-spacing: 1px;
    }
    
    /* Main Content Styles */
    .main-content {
      margin-left: 0;
      width: 100%;
      transition: all 0.3s;
      flex: 1 0 auto;
      padding-top: 56px;
    }
    
    @media (min-width: 992px) {
      .sidebar {
        left: 0;
      }
      .main-content {
        margin-left: 250px;
        width: calc(100% - 250px);
      }
    }
    
    /* Card Styles */
    .card {
      border: none;
      border-radius: 12px;
      box-shadow: 0 0.5rem 1rem rgba(26, 75, 140, 0.1);
      margin-bottom: 1.5rem;
      transition: transform 0.3s, box-shadow 0.3s;
      border: 1px solid rgba(255, 215, 0, 0.2);
    }
    
    .card:hover {
      transform: translateY(-5px);
      box-shadow: 0 1rem 2rem rgba(26, 75, 140, 0.15);
      border-color: var(--secondary-gold);
    }
    
    .card-header {
      background: linear-gradient(135deg, var(--primary-blue), var(--dark-blue));
      border-bottom: 2px solid var(--secondary-gold);
      font-weight: 700;
      color: white;
      padding: 1rem 1.5rem;
    }
    
    .card-header h6 {
      margin: 0;
      color: white;
    }
    
    /* Button Styles */
    .btn-primary {
      background: linear-gradient(135deg, var(--primary-blue), var(--dark-blue));
      border-color: var(--secondary-gold);
      padding: 0.5rem 1.5rem;
      font-weight: 600;
      color: white;
    }
    
    .btn-primary:hover {
      background: linear-gradient(135deg, var(--secondary-gold), #e6b800);
      border-color: var(--dark-blue);
      color: var(--dark-blue);
    }
    
    .btn-danger {
      background-color: #dc3545;
      border-color: #dc3545;
    }
    
    .btn-danger:hover {
      background-color: #c82333;
      border-color: #bd2130;
    }
    
    .btn-secondary {
      background-color: #6c757d;
      border-color: #6c757d;
    }
    
    .btn-secondary:hover {
      background-color: #5a6268;
      border-color: #545b62;
    }
    
    /* Form Styles */
    .form-control, .form-select {
      height: 50px;
      border-radius: 8px;
      padding: 0.5rem 1rem;
      border: 1px solid #ced4da;
      transition: all 0.3s;
    }
    
    .form-control:focus, .form-select:focus {
      border-color: var(--secondary-gold);
      box-shadow: 0 0 0 0.25rem rgba(255, 215, 0, 0.25);
    }
    
    .form-label {
      font-weight: 600;
      color: var(--dark-blue);
    }
    
    .form-label i {
      color: var(--secondary-gold);
    }
    
    /* Table Styles */
    .table-responsive {
      overflow-x: auto;
    }
    
    .table {
      margin-bottom: 0;
    }
    
    .table thead {
      background: linear-gradient(135deg, var(--light-blue), var(--primary-blue));
      color: white;
    }
    
    .table thead th {
      font-weight: 600;
      border-bottom: 2px solid var(--secondary-gold);
    }
    
    .table-hover tbody tr:hover {
      background-color: var(--light-gold);
    }
    
    /* Admin Info Styles */
    .admin-info {
      display: flex;
      align-items: center;
      background-color: rgba(255, 215, 0, 0.2);
      padding: 8px 12px;
      border-radius: 8px;
      color: white;
    }
    
    .admin-name {
      margin-right: 5px;
      font-weight: 600;
    }
    
    .admin-access {
      font-style: italic;
      opacity: 0.8;
      margin-right: 10px;
      font-size: 0.9rem;
    }
    
    .admin-icon {
      font-size: 1.5rem;
      color: var(--secondary-gold);
    }
    
    /* Footer styles */
    .footer {
      background: linear-gradient(135deg, var(--dark-blue), var(--primary-blue));
      color: white;
      padding: 20px 0;
      flex-shrink: 0;
      width: 100%;
      border-top: 2px solid var(--secondary-gold);
    }
    
    @media (min-width: 992px) {
      .footer {
        margin-left: 250px;
        width: calc(100% - 250px);
      }
    }
    
    .copyright-text {
      font-weight: 600;
      font-size: 1rem;
    }
    
    .copyright-text i {
      color: var(--secondary-gold);
    }
    
    /* Support badge */
    .support-badge {
      background: linear-gradient(135deg, var(--secondary-gold), #e6b800);
      color: var(--dark-blue);
      font-weight: 600;
      padding: 0.5rem 1rem;
      border: 1px solid var(--dark-blue);
    }
    
    /* Breadcrumbs */
    .breadcrumb-custom .breadcrumb {
      background-color: transparent;
      padding: 0;
    }
    
    .breadcrumb-custom .breadcrumb-item a {
      color: var(--primary-blue);
      text-decoration: none;
      font-weight: 500;
    }
    
    .breadcrumb-custom .breadcrumb-item a:hover {
      color: var(--secondary-gold);
    }
    
    .breadcrumb-custom .breadcrumb-item.active {
      color: var(--dark-blue);
      font-weight: 600;
    }
    
    .breadcrumb-item + .breadcrumb-item::before {
      color: var(--secondary-gold);
    }
    
    /* Action buttons */
    .action-btns .btn {
      min-width: 90px;
    }
    
    /* Modal styles */
    .modal-header {
      background: linear-gradient(135deg, var(--primary-blue), var(--dark-blue));
      color: white;
      border-bottom: 2px solid var(--secondary-gold);
    }
    
    .modal-header .btn-close {
      filter: invert(1);
    }
    
    .modal-header.bg-danger {
      background: linear-gradient(135deg, #dc3545, #b02a37) !important;
      border-bottom: 2px solid var(--secondary-gold);
    }
    
    /* Page heading */
    .text-gray-800 {
      color: var(--dark-blue);
      font-weight: 700;
    }
    
    /* Badge styles */
    .bg-primary {
      background-color: var(--primary-blue) !important;
    }
    
    .badge {
      font-weight: 600;
    }
    
    /* Branch Switcher */
    .branch-switcher {
      background: rgba(255,255,255,0.1);
      padding: 0.25rem 0.5rem;
      border-radius: 4px;
      margin-left: 1rem;
    }
    
    .branch-switcher select {
      background: white;
      border: 1px solid var(--secondary-gold);
      border-radius: 4px;
      padding: 0.25rem;
      font-size: 0.8rem;
    }
  </style>
</head>

<body>
  <!-- Top Navigation -->
  <nav class="navbar navbar-expand-lg navbar-dark">
    <div class="container-fluid">
      <button id="sidebarToggle" class="btn btn-link d-lg-none me-2">
        <i class="fas fa-bars" style="color: white;"></i>
      </button>
      <a class="navbar-brand d-none d-lg-block" href="#">
        <img src="../<?php echo $schoolLogo; ?>" alt="<?php echo $schoolName; ?>" height="35" style="border-radius: 4px;" onerror="this.src='coll_logo.png';">
        <?php echo $schoolShortName ?: substr($schoolName, 0, 20); ?>
      </a>
      
      <!-- Branch Switcher (visible on desktop) -->
      <?php if (count($allBranches) > 1): ?>
      <div class="d-none d-lg-block branch-switcher">
        <form method="get" class="d-flex align-items-center">
          <span class="text-white me-2 small">Branch:</span>
          <select name="branch" class="form-select form-select-sm" style="width: auto;" onchange="this.form.submit()">
            <option value="" style="color: #333;">Select</option>
            <?php foreach ($allBranches as $branch): ?>
            <option value="<?php echo $branch['branch_code']; ?>" style="color: #333;" 
                    <?php echo ($branchCode == $branch['branch_code']) ? 'selected' : ''; ?>>
              <?php echo $branch['branch_code']; ?> - <?php echo substr($branch['branch_name'], 0, 10); ?>
            </option>
            <?php endforeach; ?>
          </select>
        </form>
      </div>
      <?php endif; ?>
      
      <div class="ms-auto d-flex align-items-center">
        <div class="admin-info me-3">
          <span class="admin-name"><?php echo htmlspecialchars($admin_fullname ?: 'Admin'); ?></span>
          <span class="admin-access">(Administrator)</span>
          <?php if ($branchCode): ?>
          <span class="branch-badge ms-2"><?php echo strtoupper($branchCode); ?></span>
          <?php endif; ?>
          <i class="fas fa-user-circle admin-icon ms-2"></i>
        </div>
        <a href="logout.php" class="btn btn-sm btn-outline-light" style="border-color: var(--secondary-gold); color: var(--secondary-gold);">
          <i class="fas fa-sign-out-alt"></i>
        </a>
      </div>
    </div>
  </nav>

  <!-- Sidebar -->
  <nav id="sidebar" class="sidebar">
    <div class="position-sticky pt-3">
      <div class="sidebar-logo d-none d-lg-block">
        <div class="logo-text">
          <?php 
            $words = explode(' ', $schoolName);
            $initials = '';
            foreach ($words as $word) {
                if (!empty($word)) $initials .= strtoupper(substr($word, 0, 1));
            }
            echo substr($initials, 0, 2) . '.<span>' . (isset($initials[2]) ? substr($initials, 2, 1) : 'S') . '</span>';
          ?>
        </div>
        <div class="logo-tagline">
          <?php echo $schoolMotto; ?>
        </div>
        <hr style="border-color: var(--secondary-gold); opacity: 0.3;">
        <p class="text-white small px-2">
          <i class="fas fa-map-marker-alt" style="color: var(--secondary-gold);"></i><br>
          <?php echo $schoolAddress; ?>
        </p>
      </div>
      
      <ul class="nav flex-column">
        <li class="nav-item">
          <a class="nav-link" href="main.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-tachometer-alt"></i>
            Admin Centre
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="post_session.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-calendar-alt"></i>
            School Year/Session
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="post_classes.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-building"></i>
            Manage Classes
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="add_students.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-user-plus"></i>
            Register New Student
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link active" href="post_subjects.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-book"></i>
            Manage Subjects
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="teachers.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-chalkboard-teacher"></i>
            Manage Teachers
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="students.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-users"></i>
            Manage Students
          </a>
        </li>
        <li class="nav-item">
          <a class="nav-link" href="deactivate_students.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-user-lock"></i>
            Activate/Deactivate
          </a>
        </li>
        <li class="nav-item mt-3">
          <a class="nav-link" href="portal_settings.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <i class="fas fa-fw fa-cog" style="color: var(--secondary-gold);"></i>
            <span style="color: var(--secondary-gold);">Portal Settings</span>
          </a>
        </li>
      </ul>
    </div>
  </nav>

  <!-- Main Content -->
  <main class="main-content">
    <div class="container-fluid px-4 pt-4">
      <!-- Page Heading -->
      <div class="d-sm-flex align-items-center justify-content-between mb-4">
        <h1 class="h3 mb-0 text-gray-800">
          <i class="fas fa-book me-2" style="color: var(--secondary-gold);"></i>
          Subject Management
          <?php if ($branchCode): ?>
          <span class="branch-badge ms-2"><?php echo strtoupper($branchCode); ?></span>
          <?php endif; ?>
        </h1>
        <div class="d-none d-sm-inline-block">
          <span class="badge support-badge p-2">
            <i class="fas fa-phone-alt me-1"></i> Support: <?php echo $supportPhone; ?>
          </span>
        </div>
      </div>

      <!-- Mobile Branch Switcher (visible only on mobile) -->
      <?php if (count($allBranches) > 1): ?>
      <div class="d-lg-none mb-3">
        <div class="card">
          <div class="card-body py-2">
            <form method="get" class="d-flex align-items-center">
              <label class="me-2 mb-0"><i class="fas fa-school"></i></label>
              <select name="branch" class="form-select form-select-sm" onchange="this.form.submit()">
                <option value="">Select Branch</option>
                <?php foreach ($allBranches as $branch): ?>
                <option value="<?php echo $branch['branch_code']; ?>" 
                        <?php echo ($branchCode == $branch['branch_code']) ? 'selected' : ''; ?>>
                  <?php echo $branch['branch_name']; ?> (<?php echo $branch['branch_code']; ?>)
                </option>
                <?php endforeach; ?>
              </select>
            </form>
          </div>
        </div>
      </div>
      <?php endif; ?>

      <!-- Messages -->
      <?php echo $msg; ?>

      <!-- Breadcrumbs -->
      <div class="breadcrumb-custom mb-4">
        <nav aria-label="breadcrumb">
          <ol class="breadcrumb mb-0">
            <li class="breadcrumb-item"><a href="main.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">Admin Dashboard</a></li>
            <li class="breadcrumb-item active">Manage Subjects</li>
          </ol>
        </nav>
      </div>

      <!-- Subject Form -->
      <div class="card shadow mb-4">
        <div class="card-header py-3">
          <h6 class="m-0 font-weight-bold">
            <i class="fas fa-plus-circle me-2" style="color: var(--secondary-gold);"></i>
            Add New Subject
          </h6>
        </div>
        <div class="card-body">
          <form method="post" action="post_subjects.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
            <input type="hidden" name="action" value="add">
            <div class="row mb-4">
              <div class="col-md-6">
                <div class="mb-3">
                  <label class="form-label">
                    <i class="fas fa-tag me-2"></i>Subject Name <span class="text-danger">*</span>
                  </label>
                  <input type="text" name="subject" class="form-control" placeholder="e.g. Mathematics" required>
                  <small class="text-muted">Enter the full name of the subject</small>
                </div>
              </div>
            </div>
            
            <div class="row">
              <div class="col-12 text-center">
                <button type="submit" class="btn btn-primary btn-lg px-5 py-3">
                  <i class="fas fa-plus-circle me-2"></i>Add Subject
                </button>
                <button type="reset" class="btn btn-secondary btn-lg px-5 py-3 ms-3">
                  <i class="fas fa-undo me-2"></i>Reset
                </button>
              </div>
            </div>
          </form>
        </div>
      </div>
      
      <!-- Current Subjects -->
      <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">
            <i class="fas fa-list me-2" style="color: var(--secondary-gold);"></i>
            Existing Subjects
          </h6>
          <span class="badge" style="background-color: var(--secondary-gold); color: var(--dark-blue);">
            Total: <?php 
              $count = sql($DBH, "SELECT COUNT(*) as total FROM tbl_subject", [], "rows")[0]['total'];
              echo $count;
            ?>
          </span>
        </div>
        <div class="card-body">
          <div class="table-responsive">
            <table class="table table-hover">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Subject Name</th>
                  <th>Actions</th>
                </tr>
              </thead>
              <tbody>
                <?php
                $rows1 = sql($DBH, "SELECT * FROM tbl_subject ORDER BY subject ASC", [], "rows");
                $count = 1;
                foreach($rows1 as $row1):
                ?>
                <tr>
                  <td><?php echo $count++; ?></td>
                  <td><i class="fas fa-book me-2" style="color: var(--secondary-gold);"></i><?php echo htmlspecialchars($row1['subject']); ?></td>
                  <td>
                    <div class="d-flex gap-2 action-btns">
                      <button class="btn btn-sm btn-primary edit-btn" 
                              data-id="<?php echo $row1['id']; ?>" 
                              data-subject="<?php echo htmlspecialchars($row1['subject']); ?>">
                        <i class="fas fa-edit me-1"></i> Edit
                      </button>
                      <button class="btn btn-sm btn-danger delete-btn" 
                              data-id="<?php echo $row1['id']; ?>">
                        <i class="fas fa-trash-alt me-1"></i> Delete
                      </button>
                    </div>
                  </td>
                </tr>
                <?php endforeach; ?>
                
                <?php if(empty($rows1)): ?>
                <tr>
                  <td colspan="3" class="text-center py-4">
                    <i class="fas fa-book fa-2x mb-3" style="color: var(--primary-blue);"></i>
                    <p class="text-muted">No subjects found</p>
                  </td>
                </tr>
                <?php endif; ?>
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </main>

  <!-- Edit Subject Modal -->
  <div class="modal fade" id="editModal" tabindex="-1" aria-labelledby="editModalLabel" aria-hidden="true">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header">
          <h5 class="modal-title" id="editModalLabel">
            <i class="fas fa-edit me-2" style="color: var(--secondary-gold);"></i>
            Edit Subject
          </h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
        </div>
        <form method="post" action="post_subjects.php<?php echo $branchCode ? '?branch='.$branchCode : ''; ?>">
          <input type="hidden" name="action" value="edit">
          <input type="hidden" name="id" id="editId">
          <div class="modal-body">
            <div class="mb-3">
              <label for="editSubject" class="form-label">Subject Name</label>
              <input type="text" class="form-control" id="editSubject" name="subject" required>
            </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">Save Changes</button>
          </div>
        </form>
      </div>
    </div>
  </div>

  <!-- Delete Confirmation Modal -->
  <div class="modal fade" id="deleteModal" tabindex="-1" aria-labelledby="deleteModalLabel" aria-hidden="true">
    <div class="modal-dialog">
      <div class="modal-content">
        <div class="modal-header bg-danger">
          <h5 class="modal-title" id="deleteModalLabel">
            <i class="fas fa-exclamation-triangle me-2"></i>
            Confirm Deletion
          </h5>
          <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
        </div>
        <div class="modal-body">
          <p>Are you sure you want to delete this subject?</p>
          <p class="text-danger"><strong>This action cannot be undone.</strong></p>
        </div>
        <div class="modal-footer">
          <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
          <a href="#" id="confirmDelete" class="btn btn-danger">Delete</a>
        </div>
      </div>
    </div>
  </div>

  <!-- Footer -->
  <footer class="footer">
    <div class="container-fluid">
      <div class="row align-items-center">
        <div class="col-md-6">
          <span class="copyright-text">
            <i class="fas fa-copyright me-1"></i> <?php echo $footerCopyright; ?> <?php echo date("Y"); ?>
            <?php if ($branchCode): ?>
            <span class="branch-badge ms-2"><?php echo strtoupper($branchCode); ?></span>
            <?php endif; ?>
          </span>
        </div>
        <div class="col-md-6">
          <div class="text-md-end">
            <a href="<?php echo $developerWebsite; ?>" target="_blank" rel="noopener noreferrer" style="color: var(--secondary-gold); text-decoration: none;">
              <span>Powered by <?php echo $developerName; ?></span>
              <img src="datalogo.png" alt="<?php echo $developerName; ?> Logo" class="ms-2" height="24" style="filter: brightness(0) invert(1);" onerror="this.style.display='none';">
            </a>
          </div>
        </div>
      </div>
    </div>
  </footer>

  <!-- Bootstrap 5 JS Bundle with Popper -->
  <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
  
  <!-- jQuery -->
  <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
  
  <!-- Custom Scripts -->
  <script>
    // Toggle sidebar on mobile
    document.getElementById('sidebarToggle').addEventListener('click', function() {
        document.getElementById('sidebar').classList.toggle('active');
        document.querySelector('.main-content').classList.toggle('active');
    });
    
    // Delete modal handling
    $(document).ready(function() {
        $('.delete-btn').click(function() {
            var id = $(this).data('id');
            var branchParam = '<?php echo $branchCode ? "&branch=" . $branchCode : ""; ?>';
            var deleteUrl = 'post_subjects.php?delete_id=' + id + branchParam;
            $('#confirmDelete').attr('href', deleteUrl);
            $('#deleteModal').modal('show');
        });
        
        // Edit modal handling
        $('.edit-btn').click(function() {
            var id = $(this).data('id');
            var subject = $(this).data('subject');
            
            $('#editId').val(id);
            $('#editSubject').val(subject);
            $('#editModal').modal('show');
        });
        
        // Auto-hide alerts after 5 seconds
        setTimeout(function() {
            $('.alert').fadeOut('slow');
        }, 5000);
        
        // Focus on first input
        $('input[name="subject"]').focus();
    });
  </script>
</body>
</html>