<?php
$pageTitle = 'Add University';
require_once dirname(__DIR__) . '/includes/header.php';
$destinations = db()->query("SELECT id,country_name,flag_emoji FROM destinations WHERE status='active' ORDER BY country_name")->fetch_all(MYSQLI_ASSOC);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name   = trim($_POST['name'] ?? '');
    $country= trim($_POST['country'] ?? '');
    $dest_id= (int)($_POST['destination_id'] ?? 0);
    $desc   = trim($_POST['description'] ?? '');
    $web    = trim($_POST['website'] ?? '');
    $status = $_POST['status'] ?? 'active';
    $sort   = (int)($_POST['sort_order'] ?? 0);
    $logo   = handleUpload('logo','universities') ?? trim($_POST['logo_url'] ?? '');
    if ($name) {
        $st = db()->prepare("INSERT INTO universities (name,country,destination_id,description,logo,website,sort_order,status) VALUES (?,?,?,?,?,?,?,?)");
        $st->bind_param('ssississi', $name,$country,$dest_id,$desc,$logo,$web,$sort,$status);
        $st->execute();
        flash('University added!','success');
        redirect(ADMIN_URL.'/pages/universities.php');
    } else { $error = 'University name is required.'; }
}
?>
<div class="page-header">
    <a href="universities.php" class="btn btn-secondary btn-sm"><i class="fas fa-arrow-left"></i></a>
    <h1>Add University</h1>
</div>
<div class="card">
    <div class="card-header"><i class="fas fa-university" style="color:var(--brand)"></i><h2>New University</h2></div>
    <div class="card-body">
        <?php if (!empty($error)): ?><div class="flash flash-error"><?=e($error)?></div><?php endif; ?>
        <form method="POST" enctype="multipart/form-data">
            <div class="form-row">
                <div class="form-group">
                    <label class="form-label">University Name *</label>
                    <input type="text" name="name" class="form-control" placeholder="e.g. University of London" value="<?=e($_POST['name']??'')?>" required>
                </div>
                <div class="form-group">
                    <label class="form-label">Country</label>
                    <input type="text" name="country" class="form-control" placeholder="e.g. United Kingdom" value="<?=e($_POST['country']??'')?>">
                </div>
            </div>
            <div class="form-row">
                <div class="form-group">
                    <label class="form-label">Destination</label>
                    <select name="destination_id" class="form-select">
                        <option value="0">— Select Destination —</option>
                        <?php foreach($destinations as $dest): ?>
                        <option value="<?=$dest['id']?>" <?=($_POST['destination_id']??0)==$dest['id']?'selected':''?>>
                            <?=e($dest['flag_emoji'].' '.$dest['country_name'])?>
                        </option>
                        <?php endforeach; ?>
                    </select>
                </div>
                <div class="form-group">
                    <label class="form-label">Website</label>
                    <input type="url" name="website" class="form-control" placeholder="https://university.edu" value="<?=e($_POST['website']??'')?>">
                </div>
            </div>
            <div class="form-group">
                <label class="form-label">Description</label>
                <textarea name="description" class="form-control" rows="4" placeholder="About this university..."><?=e($_POST['description']??'')?></textarea>
            </div>
            <div class="form-row">
                <div class="form-group">
                    <label class="form-label">Upload Logo</label>
                    <input type="file" name="logo" class="form-control" accept="image/*" onchange="previewImg(this)">
                    <img id="imgPreview" class="img-preview" style="margin-top:8px;display:none">
                </div>
                <div class="form-group">
                    <label class="form-label">Or Logo URL</label>
                    <input type="text" name="logo_url" class="form-control" placeholder="https://...">
                </div>
            </div>
            <div class="form-row">
                <div class="form-group">
                    <label class="form-label">Status</label>
                    <select name="status" class="form-select">
                        <option value="active">Active</option>
                        <option value="inactive">Inactive</option>
                    </select>
                </div>
                <div class="form-group">
                    <label class="form-label">Sort Order</label>
                    <input type="number" name="sort_order" class="form-control" value="0" min="0">
                </div>
            </div>
            <div style="display:flex;gap:10px">
                <button type="submit" class="btn btn-primary"><i class="fas fa-save"></i> Save University</button>
                <a href="universities.php" class="btn btn-secondary">Cancel</a>
            </div>
        </form>
    </div>
</div>
<script>function previewImg(i){const r=new FileReader();r.onload=e=>{const p=document.getElementById('imgPreview');p.src=e.target.result;p.style.display='block'};r.readAsDataURL(i.files[0]);}</script>
<?php require_once dirname(__DIR__) . '/includes/footer.php'; ?>
