finder.php

<?php
require_once "includes/db.php";
require_once "includes/require_user_details.php";

$pageTitle = "Z-Score Finder";
$pageStyles = ["css/pages/finder.css"];

$degrees = [];
$error = "";
$searchMode = ""; // "zscore" or "name"

$subjects = ["Combined Mathematics", "Physics", "Chemistry", "ICT", "Biology", "Accounting", "Business Statistics", "Economics", "Any"];
$districts = ["COLOMBO", "GAMPAHA", "KALUTARA", "MATALE", "KANDY", "NUWARA ELIYA", "GALLE", "MATARA", "HAMBANTOTA", "JAFFNA", "KILINOCHCHI", "MANNAR", "MULLAITIVU", "VAVUNIYA", "TRINCOMALEE", "BATTICALOA", "AMPARA", "PUTTALAM", "KURUNEGALA", "ANURADHAPURA", "POLONNARUWA", "BADULLA", "MONARAGALA", "All Island Ranges"];

// Fetch distinct universities and degree names from flat_zscores
$uniList = [];
$degreeNamesList = [];
$res = $conn->query("SELECT DISTINCT university_name FROM flat_zscores ORDER BY university_name ASC");
if ($res) {
    while ($row = $res->fetch_assoc()) {
        $uniList[] = $row['university_name'];
    }
}
$resDeg = $conn->query("SELECT DISTINCT degree_name FROM flat_zscores ORDER BY degree_name ASC");
if ($resDeg) {
    while ($row = $resDeg->fetch_assoc()) {
        $degreeNamesList[] = $row['degree_name'];
    }
}

$sub1 = $_POST["subject1"] ?? "";
$sub2 = $_POST["subject2"] ?? "";
$sub3 = $_POST["subject3"] ?? "";
$district = $_POST["district"] ?? "";

$degreeSearchName = $_POST["search_degree_name"] ?? "";
$searchUniversity = $_POST["search_university"] ?? "";

$submittedZscore = $_POST["zscore"] ?? "";
$zscore = is_numeric($submittedZscore) ? floatval($submittedZscore) : 0;
$sliderValue = $zscore > 0 ? $zscore : 3.0;
$sliderValueFormatted = number_format($sliderValue, 3, ".", "");

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    if (isset($_POST["zscore_search"])) {
        $searchMode = "zscore";
        if ($zscore > 0 && $sub1 && $sub2 && $sub3 && $district) {
            $dCol = strtolower(str_replace(' ', '_', $district));
            $stmt = $conn->prepare("
                SELECT f.degree_name, f.university_name, 
                       f.`$dCol` as cutoff,
                       0 AS university_id, '' AS duration, '' AS medium, '' AS description
                FROM flat_zscores f 
                WHERE 
                (
                    (? IN (f.subject1, f.subject2, f.subject3) OR f.subject1 = 'Any') AND
                    (? IN (f.subject1, f.subject2, f.subject3) OR f.subject1 = 'Any') AND
                    (? IN (f.subject1, f.subject2, f.subject3) OR f.subject1 = 'Any')
                )
                AND f.`$dCol` <= ? AND f.`$dCol` IS NOT NULL
                ORDER BY f.`$dCol` DESC
            ");
            
            $stmt->bind_param(
                "sssd", 
                $sub1, $sub2, $sub3, 
                $zscore
            );
            
            $stmt->execute();
            $degrees = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
            $stmt->close();
        } else {
            $error = "Please enter a valid Z-score, select all 3 subjects and a district.";
        }
    } elseif (isset($_POST["name_search"])) {
        $searchMode = "name";
        
        $hasDegree = !empty(trim($degreeSearchName));
        $hasUni = !empty($searchUniversity);
        
        if ($hasDegree || $hasUni) {
            $query = "
                SELECT f.*, 
                       MAX(d.duration) as duration, 
                       MAX(d.medium) as medium, 
                       MAX(d.description) as description,
                       MAX(d.department_id) as dept_id
                FROM flat_zscores f 
                LEFT JOIN degrees d ON f.degree_name = d.name
                WHERE 1=1 ";
            
            $types = "";
            $params = [];
            
            if ($hasDegree) {
                $query .= " AND f.degree_name LIKE ?";
                $types .= "s";
                $params[] = "%" . trim($degreeSearchName) . "%";
            }
            
            if ($hasUni) {
                $query .= " AND f.university_name = ?";
                $types .= "s";
                $params[] = trim($searchUniversity);
            }
            
            $query .= " GROUP BY f.id ORDER BY f.degree_name ASC";
            
            $stmt = $conn->prepare($query);
            if (!empty($types)) {
                $stmt->bind_param($types, ...$params);
            }
            $stmt->execute();
            $degrees = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
            $stmt->close();
        } else {
            $error = "Please enter a degree name or select a university.";
        }
    }
}

include "includes/header.php";
?>
<!-- Wrap the middle section in a container with a white background -->
<main style="background-color: #ffffff;">
<style>
    /* target everything except the page-hero section */
    main .section-shell, main .section-shell h1, main .section-shell h3, main .section-shell p, main .section-shell label, main .section-shell input, main .section-shell select, main .section-shell option, main .section-shell .btn-ghost, main .section-shell .eyebrow {
        color: #000000 !important;
    }
    main .section-shell input, main .section-shell select, main .section-shell option {
        background-color: #ffffff !important;
    }
    main .finder-stage {
        background: #ffffff !important;
        border: 1px solid #eaeaea !important;
        box-shadow: 0 4px 6px rgba(0, 0, 0, 0.05) !important;
    }
    main .btn-primary {
        box-shadow: none !important;
        text-shadow: none !important;
    }
</style>
<section class="page-hero reveal-on-scroll" aria-label="Finder hero">
    <div class="container">
        <p class="eyebrow">Z-Score Finder</p>
        <h1>Z-Score Degree Finder</h1>
        <p class="page-hero-meta">Match your A/L results to degrees according to your subject combination and district, or search by degree name directly.</p>
    </div>
</section>

<section class="section-shell" aria-label="Finder wizard">
    <div class="container">
        <?php if ($error): ?>
            <div class="alert-panel reveal-on-scroll">
                <p><?php echo htmlspecialchars($error); ?></p>
            </div>
        <?php endif; ?>
        
        <div style="display:flex; gap: 32px; flex-wrap: wrap;">
            
            <!-- Z-Score Search Form -->
            <form class="finder-stage reveal-on-scroll" method="POST" action="finder.php#results" style="flex:1; min-width: 300px;">
                <input type="hidden" name="zscore_search" value="1">
                <h3 style="margin-bottom: 16px;">Search by Z-Score & Subjects</h3>
                
                <div style="display:flex; gap:16px; margin: 16px 0; flex-direction: column;">
                    <div class="form-field" style="flex:1;">
                        <label>Subject 1</label>
                        <select name="subject1" required style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                            <option value="">Select Subject 1</option>
                            <?php foreach($subjects as $s): ?>
                                <option value="<?php echo $s; ?>" <?php echo $sub1===$s ? "selected" : ""; ?>><?php echo $s; ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-field" style="flex:1;">
                        <label>Subject 2</label>
                        <select name="subject2" required style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                            <option value="">Select Subject 2</option>
                            <?php foreach($subjects as $s): ?>
                                <option value="<?php echo $s; ?>" <?php echo $sub2===$s ? "selected" : ""; ?>><?php echo $s; ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                    <div class="form-field" style="flex:1;">
                        <label>Subject 3</label>
                        <select name="subject3" required style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                            <option value="">Select Subject 3</option>
                            <?php foreach($subjects as $s): ?>
                                <option value="<?php echo $s; ?>" <?php echo $sub3===$s ? "selected" : ""; ?>><?php echo $s; ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>
                </div>

                <div class="form-field" style="margin-bottom:16px;">
                    <label>District</label>
                    <select name="district" required style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                        <option value="">Select District</option>
                        <?php foreach($districts as $d): ?>
                            <option value="<?php echo $d; ?>" <?php echo $district===$d ? "selected" : ""; ?>><?php echo $d; ?></option>
                        <?php endforeach; ?>
                    </select>
                </div>

                <div class="slider-wrapper">
                    <label for="zscoreRange">Your Z-Score</label>
                    <div style="display:flex; align-items:center; gap:16px;">
                        <input type="range" class="range-slider" id="zscoreRange" min="0" max="4" step="0.001" value="<?php echo htmlspecialchars($sliderValueFormatted); ?>" style="flex:1;">
                        <input type="number" id="zscoreInput" name="zscore" min="0" max="4" step="0.001" value="<?php echo htmlspecialchars($sliderValueFormatted); ?>" style="width:100px; padding: 8px; border-radius: 4px; border: 1px solid #ccc;" required>
                    </div>
                </div>
                <!-- Remove the old hidden input and strong text logic, simply adding event listeners to sync them -->
                <script>
                    document.addEventListener('DOMContentLoaded', function() {
                        const slider = document.getElementById('zscoreRange');
                        const input = document.getElementById('zscoreInput');
                        if(slider && input) {
                            slider.addEventListener('input', function() {
                                input.value = slider.value;
                            });
                            input.addEventListener('input', function() {
                                slider.value = input.value;
                            });
                        }
                    });
                </script>
                
                <div class="finder-actions">
                    <button type="submit" class="btn btn-primary">Find Degrees</button>
                    <button type="button" class="btn btn-ghost" onclick="resetZscoreForm()">Reset</button>
                </div>
            </form>
            
            <!-- Degree Name Search Form -->
            <form class="finder-stage reveal-on-scroll" method="POST" action="finder.php#results" style="flex:1; min-width: 300px; height: fit-content;">
                <input type="hidden" name="name_search" value="1">
                <h3 style="margin-bottom: 16px;">Search Degree</h3>
                
                <div class="form-field" style="margin-bottom: 16px;">
                    <label>Degree Name</label>
                    <input type="text" id="searchInput" name="search_degree_name" list="degreeNameOptions" placeholder="Optional if university is selected" value="<?php echo htmlspecialchars($degreeSearchName); ?>" style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                    <datalist id="degreeNameOptions">
                        <?php foreach($degreeNamesList as $dn): ?>
                            <option value="<?php echo htmlspecialchars($dn); ?>"></option>
                        <?php endforeach; ?>
                    </datalist>
                </div>
                
                <div class="form-field" style="margin-bottom: 16px;">
                    <label>University (Optional)</label>
                    <select name="search_university" style="width:100%; padding: 8px; border-radius: 4px; border: 1px solid #ccc;">
                        <option value="">All Universities</option>
                        <?php foreach($uniList as $uni): ?>
                            <option value="<?php echo htmlspecialchars($uni); ?>" <?php echo $searchUniversity === $uni ? "selected" : ""; ?>><?php echo htmlspecialchars($uni); ?></option>
                        <?php endforeach; ?>
                    </select>
                </div>
                
                <div class="finder-actions">
                    <button type="submit" class="btn btn-primary">Search Degree</button>
                    <button type="button" class="btn btn-ghost" onclick="resetNameSearch()">Reset</button>
                </div>
            </form>
            
        </div>
    </div>
</section>

<section class="section-shell" aria-label="Finder results" id="results">
    <div class="container">
        <?php if ($_SERVER["REQUEST_METHOD"] === "POST"): ?>
            <div class="finder-results">
                <?php if ($degrees): ?>
                    <div style="overflow-x:auto;">
                        <?php if ($searchMode === 'name'): ?>
                            <?php foreach ($degrees as $index => $deg): ?>
                                <?php
                                $dNameUpper = strtoupper($deg["degree_name"]);
                                $durationTxt = "4 years";
                                if (strpos($dNameUpper, 'SIDDHA MEDICINE') !== false) {
                                    $durationTxt = "6 years";
                                } elseif (strpos($dNameUpper, 'MEDICINE') !== false || strpos($dNameUpper, 'DENTAL SURGERY') !== false || strpos($dNameUpper, 'VETERINARY SCIENCE') !== false) {
                                    $durationTxt = "5 years";
                                }

                                $curriculumMap = [
                                    'moratuwa' => 'https://uom.lk/eugs/curriculam',
                                    'colombo' => 'https://cmb.ac.lk/undergraduate-programmes',
                                    'jayewardenepura' => 'https://www.sjp.ac.lk/undergraduate-courses/',
                                    'trincomalee' => 'https://www.tc.esn.ac.lk/',
                                    'south eastern' => 'https://www.seu.ac.lk/undergraduate_studies.php',
                                    'eastern' => 'https://esn.ac.lk/academic-programs/undergraduate',
                                    'kelaniya' => 'https://cdce.kln.ac.lk/',
                                    'sabaragamuwa' => 'https://www.sab.ac.lk/',
                                    'rajarata' => 'https://www.rjt.ac.lk/courses/',
                                    'jaffna' => 'https://jfn.ac.lk/degree-programmes/',
                                    'ruhuna' => 'https://docslib.org/doc/247346/student-handbook#google_vignette',
                                    'vavuniya' => 'https://www.vau.ac.lk/degree-programmes/',
                                    'uva wellassa' => '#',
                                    'wayamba' => 'https://wyb.ac.lk/',
                                    'peradeniya' => 'https://www.pdn.ac.lk/Download',
                                    'gampaha' => 'https://gwu.ac.lk/index.php/undergraduate'
                                ];
                                $curriculumLink = '#';
                                foreach ($curriculumMap as $key => $link) {
                                    if (stripos($deg["university_name"], $key) !== false) {
                                        $curriculumLink = $link;
                                        break;
                                    }
                                }
                                ?>
                                <div style="margin-bottom: 48px; background: #fff; border-radius: 8px; box-shadow: 0 4px 6px rgba(0,0,0,0.05); overflow: hidden; display: flex; flex-wrap: wrap;">
                                    
                                    <!-- Degree Details (Left side) -->
                                    <div style="flex: 1; padding: 24px; min-width: 300px; border-right: 1px solid #eaeaea;">
                                        <h3 style="margin-bottom: 16px; font-size: 1.5rem; color: #0056b3;"><?php echo htmlspecialchars($deg["degree_name"]); ?></h3>
                                        <p style="font-size: 1.1rem; color: #555; margin-bottom: 24px;"><strong>University:</strong> <?php echo htmlspecialchars($deg["university_name"]); ?></p>
                                        
                                        <div style="display: grid; grid-template-columns: 1fr 1fr; gap: 16px; margin-bottom: 24px;">
                                            <div><strong style="color: #666;">Duration:</strong> <br><?php echo $durationTxt; ?></div>
                                            <div><strong style="color: #666;">Medium:</strong> <br>English</div>
                                            <div><strong style="color: #666;">Subject Req 1:</strong> <br><?php echo !empty($deg["subject1"]) ? htmlspecialchars($deg["subject1"]) : "-"; ?></div>
                                            <div><strong style="color: #666;">Subject Req 2:</strong> <br><?php echo !empty($deg["subject2"]) ? htmlspecialchars($deg["subject2"]) : "-"; ?></div>
                                            <div><strong style="color: #666;">Subject Req 3:</strong> <br><?php echo !empty($deg["subject3"]) ? htmlspecialchars($deg["subject3"]) : "-"; ?></div>
                                        </div>
                                        
                                        <?php if(!empty($deg["description"])): ?>
                                            <div style="background: #f8f9fa; padding: 16px; border-radius: 6px; margin-bottom: 16px;">
                                                <strong style="color: #666;">Description:</strong>
                                                <p style="margin-top: 8px; color: #444; font-size: 0.95rem; line-height: 1.5;"><?php echo htmlspecialchars($deg["description"]); ?></p>
                                            </div>
                                        <?php endif; ?>
                                        
                                        <div style="margin-top: auto;">
                                            <a href="<?php echo htmlspecialchars($curriculumLink); ?>" target="_blank" rel="noopener noreferrer" style="display: inline-block; padding: 10px 20px; background: #0056b3; color: #ffffff; text-decoration: none; border-radius: 4px; font-weight: bold;">
                                                <i class="fa-solid fa-book" style="margin-right: 6px;"></i> Curriculum
                                            </a>
                                        </div>
                                    </div>

                                    <?php if (!empty(trim($degreeSearchName))): ?>
                                    <!-- Cutoffs Table (Right side vertical) -->
                                    <div style="flex: 1; min-width: 300px; max-height: 480px; overflow-y: auto;">
                                        <table style="width:100%; border-collapse: collapse; text-align: left;">
                                            <thead style="background: #f8f9fa; position: sticky; top: 0; z-index: 10;">
                                                <tr style="border-bottom: 2px solid #eaeaea;">
                                                    <th style="padding: 16px;">District</th>
                                                    <th style="padding: 16px;">Z-Score Cutoff</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php 
                                                $districtCols = [
                                                    'colombo','gampaha','kalutara','matale','kandy','nuwara_eliya','galle','matara','hambantota','jaffna','kilinochchi','mannar','mullaitivu','vavuniya','trincomalee','batticaloa','ampara','puttalam','kurunegala','anuradhapura','polonnaruwa','badulla','monaragala','ratnapura','kegalle'
                                                ];
                                                foreach($districtCols as $dc): 
                                                    $dName = ucwords(str_replace('_', ' ', $dc));
                                                    $val = $deg[$dc] ?? null;
                                                ?>
                                                    <tr style="border-bottom: 1px solid #f1f1f1;">
                                                        <td style="padding: 12px 16px; color: #333; font-weight: 500;"><?php echo htmlspecialchars($dName); ?></td>
                                                        <td style="padding: 12px 16px;">
                                                            <?php if($val !== null): ?>
                                                                <span style="background: #e9ecef; padding: 4px 8px; border-radius: 4px; font-weight: bold; color: #0056b3;"><?php echo htmlspecialchars($val); ?></span>
                                                            <?php else: ?>
                                                                <span style="color: #aaa;">-</span>
                                                            <?php endif; ?>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    <?php endif; ?>
                                </div>
                            <?php endforeach; ?>
                        <?php else: ?>
                            <table style="width:100%; border-collapse: collapse; margin-bottom: 32px; text-align: left; background: #fff; box-shadow: 0 4px 6px rgba(0,0,0,0.05); border-radius: 8px; overflow: hidden;">
                                <thead style="background: #f8f9fa;">
                                    <tr style="border-bottom: 2px solid #eaeaea;">
                                        <th style="padding: 16px;">Degree</th>
                                        <th style="padding: 16px;">University</th>
                                        <th style="padding: 16px;">Duration</th>
                                        <th style="padding: 16px;">Medium</th>
                                        <th style="padding: 16px;">Z-Score Cutoff</th>
                                        <th style="padding: 16px;">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                <?php foreach ($degrees as $index => $deg): ?>
                                    <?php
                                    $dNameUpper = strtoupper($deg["degree_name"]);
                                    $durationTxt = "4 years";
                                    if (strpos($dNameUpper, 'SIDDHA MEDICINE') !== false) {
                                        $durationTxt = "6 years";
                                    } elseif (strpos($dNameUpper, 'MEDICINE') !== false || strpos($dNameUpper, 'DENTAL SURGERY') !== false || strpos($dNameUpper, 'VETERINARY SCIENCE') !== false) {
                                        $durationTxt = "5 years";
                                    }

                                    $curriculumMap = [
                                        'moratuwa' => 'https://uom.lk/eugs/curriculam',
                                        'colombo' => 'https://cmb.ac.lk/undergraduate-programmes',
                                        'jayewardenepura' => 'https://www.sjp.ac.lk/undergraduate-courses/',
                                        'trincomalee' => 'https://www.tc.esn.ac.lk/',
                                        'south eastern' => 'https://www.seu.ac.lk/undergraduate_studies.php',
                                        'eastern' => 'https://esn.ac.lk/academic-programs/undergraduate',
                                        'kelaniya' => 'https://cdce.kln.ac.lk/',
                                        'sabaragamuwa' => 'https://www.sab.ac.lk/',
                                        'rajarata' => 'https://www.rjt.ac.lk/courses/',
                                        'jaffna' => 'https://jfn.ac.lk/degree-programmes/',
                                        'ruhuna' => 'https://docslib.org/doc/247346/student-handbook#google_vignette',
                                        'vavuniya' => 'https://www.vau.ac.lk/degree-programmes/',
                                        'uva wellassa' => '#',
                                        'wayamba' => 'https://wyb.ac.lk/',
                                        'peradeniya' => 'https://www.pdn.ac.lk/Download',
                                        'gampaha' => 'https://gwu.ac.lk/index.php/undergraduate'
                                    ];
                                    $curriculumLink = '#';
                                    foreach ($curriculumMap as $key => $link) {
                                        if (stripos($deg["university_name"], $key) !== false) {
                                            $curriculumLink = $link;
                                            break;
                                        }
                                    }
                                    ?>
                                    <tr id="row-<?php echo $index; ?>" style="border-bottom: 1px solid #f1f1f1; transition: background 0.2s;">
                                        <td style="padding: 16px; color: #333; font-weight: 500;"><?php echo htmlspecialchars($deg["degree_name"]); ?></td>
                                        <td style="padding: 16px; color: #555;"><?php echo htmlspecialchars($deg["university_name"]); ?></td>
                                        <td style="padding: 16px; color: #555;"><?php echo $durationTxt; ?></td>
                                        <td style="padding: 16px; color: #555;">English</td>
                                        <td style="padding: 16px; color: #555;">
                                            <?php if(isset($deg["cutoff"]) && $deg["cutoff"] !== null): ?>
                                                <span style="background: #e9ecef; padding: 4px 8px; border-radius: 4px; font-weight: bold;"><?php echo htmlspecialchars($deg["cutoff"]); ?></span>
                                            <?php else: ?>
                                                N/A
                                            <?php endif; ?>
                                        </td>
                                        <td style="padding: 16px;">
                                            <button type="button" class="btn btn-ghost" onclick="showDegreeDetails(<?php echo $index; ?>)" style="padding: 8px 16px; font-size: 0.9em;">View Details</button>
                                        </td>
                                    </tr>
                                    <tr id="detail-row-<?php echo $index; ?>" style="display: none; background: #fafafa;">
                                        <td colspan="4" style="padding: 16px;">
                                            <fieldset style="border: 1px solid #ddd; padding: 24px; border-radius: 8px; background: #fff; box-shadow: 0 2px 4px rgba(0,0,0,0.05);">
                                                <legend style="padding: 0 12px; font-weight: bold; font-size: 1.1rem; color: #0056b3;">Degree Details</legend>
                                                <h3 style="margin-bottom: 16px; font-size: 1.5rem; color: #333;"><?php echo htmlspecialchars($deg["degree_name"]); ?></h3>
                                                
                                                <div style="display: grid; grid-template-columns: repeat(auto-fit, minmax(200px, 1fr)); gap: 16px; margin-bottom: 16px;">
                                                    <div><strong style="color: #666;">University:</strong> <br><?php echo htmlspecialchars($deg["university_name"]); ?></div>
                                                    <?php if(isset($deg["cutoff"]) && $deg["cutoff"] !== null): ?>
                                                        <div><strong style="color: #666;">Cutoff:</strong> <br><?php echo htmlspecialchars($deg["cutoff"]); ?></div>
                                                    <?php endif; ?>
                                                    <div><strong style="color: #666;">Duration:</strong> <br><?php echo $durationTxt; ?></div>
                                                    <div><strong style="color: #666;">Medium:</strong> <br>English</div>
                                                </div>
                                                
                                                <?php if(!empty($deg["description"])): ?>
                                                    <div style="margin-bottom: 24px; background: #f8f9fa; padding: 16px; border-radius: 6px;">
                                                        <strong style="color: #666;">Description:</strong>
                                                        <p style="margin-top: 8px; color: #444;"><?php echo htmlspecialchars($deg["description"]); ?></p>
                                                    </div>
                                                <?php endif; ?>
                                                
                                                <div style="display: flex; gap: 16px; align-items: center; padding-top: 16px;">
                                                    <?php if (!empty($deg["university_id"])): ?>
                                                        <a class="btn btn-primary" href="university.php?id=<?php echo $deg["university_id"]; ?>">Go to University Page &rarr;</a>
                                                    <?php endif; ?>
                                                    <a href="<?php echo htmlspecialchars($curriculumLink); ?>" target="_blank" rel="noopener noreferrer" style="display: inline-block; padding: 10px 20px; background: #0056b3; color: #ffffff; text-decoration: none; border-radius: 4px; font-weight: bold;">
                                                        <i class="fa-solid fa-book" style="margin-right: 6px;"></i> Curriculum
                                                    </a>
                                                </div>
                                            </fieldset>
                                        </td>
                                    </tr>
                                <?php endforeach; ?>
                            </tbody>
                        </table>
                        <?php endif; ?>
                    </div>
                <?php else: ?>
                    <p class="section-subtitle">
                        <?php if($searchMode === "zscore"): ?>
                            No matching degrees found for your subject combination and district. Relax the cutoff or verify your inputs.
                        <?php else: ?>
                            No matching degree names found. Try another keyword.
                        <?php endif; ?>
                    </p>
                <?php endif; ?>
            </div>
        <?php endif; ?>
    </div>
</section>

<script>
function showDegreeDetails(index) {
    const detailRow = document.getElementById('detail-row-' + index);
    const mainRow = document.getElementById('row-' + index);
    
    // If it's already shown, just hide it
    if (detailRow && detailRow.style.display !== 'none') {
        detailRow.style.display = 'none';
        if (mainRow) mainRow.style.backgroundColor = 'transparent';
        return;
    }

    // Hide all detail rows first
    const allDetailRows = document.querySelectorAll('tr[id^="detail-row-"]');
    allDetailRows.forEach(el => {
        el.style.display = 'none';
    });

    // Reset table row highlights
    const allRows = document.querySelectorAll('tr[id^="row-"]');
    allRows.forEach(el => {
        el.style.backgroundColor = 'transparent';
    });

    // Show specific detail row and highlight main row
    if (detailRow) {
        detailRow.style.display = 'table-row';
        if (mainRow) {
            mainRow.style.backgroundColor = '#eef5ff'; // subtle highlight
        }
    }
}

function resetZscoreForm() {
    // Reset all select dropdowns strictly inside the zscore form
    const selects = document.querySelectorAll("input[name='zscore_search']").forEach(e => {
        const form = e.closest("form");
        const formSelects = form.querySelectorAll("select");
        formSelects.forEach(select => select.selectedIndex = 0);
    });
    
    // Reset the slider and text input to 0
    const slider = document.getElementById("zscoreRange");
    const zInput = document.getElementById("zscoreInput");
    
    if(slider) slider.value = "0";
    if(zInput) zInput.value = "0";
}

function resetNameSearch() {
    const input = document.getElementById("searchInput");
    if(input) input.value = "";
}
</script>
</main>

<?php include "includes/footer.php"; ?>