<?php
session_start();
if (!isset($_SESSION['ADMIN_LOGIN']) || $_SESSION['ADMIN_LOGIN'] != 'yes') {
    header("Location: login.php");
    exit;
}
$conn = new mysqli("localhost", "job_portal", "job_portal", "job_portal");
if ($conn->connect_error) die("DB Error: ".$conn->connect_error);

$email = $_SESSION['ADMIN_EMAIL'];
$stmt = $conn->prepare("SELECT * FROM memberships WHERE email=? ORDER BY id DESC LIMIT 1");
$stmt->bind_param("s", $email);
$stmt->execute();
$data = $stmt->get_result()->fetch_assoc();
$stmt->close();
$conn->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Ownership Application - A4 Print</title>
  <style>
    @page {
      size: A4 portrait;
      margin: 10mm;
    }

    * {
      -webkit-print-color-adjust: exact !important;
      print-color-adjust: exact !important;
      box-sizing: border-box;
    }

    body, html {
      margin: 0;
      padding: 0;
      width: 210mm;
      height: 297mm;
      font-size: 14px;
      font-family: 'Segoe UI', sans-serif;
      background: white;
      color: #000;
    }

    .container {
      padding: 10mm;
      background-color: #fff;
      border: 2px solid #003f88;
    }

    .header {
      display: flex;
      align-items: center;
      justify-content: space-between;
      background-color: #003f88;
      color: white;
      padding: 10px 15px;
      border-radius: 5px;
    }

    .header img {
      height: 65px;
    }

    .header .title {
      text-align: center;
      flex: 1;
      font-size: 20px;
      font-weight: bold;
      color: #ffc107;
      text-transform: uppercase;
    }

    .contact {
      font-size: 12px;
      text-align: right;
      color: #fff;
      font-weight: bold;
    }

    .section-title {
      background: #003f88;
      color: #fff;
      font-weight: 900;
      text-align: center;
      padding: 6px;
      font-size: 16px;
      margin: 14px 0;
      text-transform: uppercase;
      letter-spacing: 0.5px;
      border-radius: 4px;
    }

    .label {
      font-weight: 800;
      color: #003f88;
      font-size: 15px;
      text-transform: uppercase;
    }

    .value {
      font-weight: 700;
      color: #000;
      font-size: 15px;
    }

    .row {
      display: flex;
      flex-wrap: wrap;
      margin-bottom: 8px;
    }

    .col-3 { width: 25%; padding: 4px 6px; }
    .col-4 { width: 33.33%; padding: 4px 6px; }
    .col-6 { width: 50%; padding: 4px 6px; }
    .col-12 { width: 100%; padding: 4px 6px; }

    .form-line {
      border-bottom: 2px dashed #003f88;
      padding-bottom: 3px;
      font-size: 15px;
      font-weight: bold;
    }

    .footer {
      text-align: center;
      background: #003f88;
      color: #ffc107;
      padding: 8px;
      font-size: 14px;
      font-weight: 900;
      margin-top: 12px;
      border-radius: 4px;
      text-transform: uppercase;
    }

    @media print {
      .no-print { display: none !important; }
    }

    .actions {
      text-align: right;
      margin-bottom: 10px;
    }

    .btn {
      padding: 6px 12px;
      margin-left: 5px;
      font-size: 13px;
      cursor: pointer;
      border: none;
      border-radius: 4px;
      font-weight: bold;
    }

    .btn-print { background-color: #28a745; color: white; }
    .btn-logout { background-color: #dc3545; color: white; }
  </style>
</head>
<body>
<div class="container">
  <div class="header">
    <img src="../images/logo.png" alt="Logo">
    <div class="title">RBV ROYALS BILTMORE VACATION PRIVATE LIMITED</div>
    <div class="contact">
      Email: info@rbvroyals.com<br>
      Mobile: +91-9876543210
    </div>
  </div>

  <div class="actions no-print">
    <a href="logout.php" class="btn btn-logout">Logout</a>
    <button onclick="window.print()" class="btn btn-print">Print</button>
  </div>

  <div class="section-title">Ownership Application</div>

  <div class="row">
    <div class="col-6"><span class="label">Date:</span> <span class="value"><?= $data['entry_date'] ?></span></div>
  </div>

  <div class="row">
    <div class="col-6"><span class="label">Applicant (Mr):</span> <span class="value"><?= htmlspecialchars($data['applicant_name']) ?></span></div>
    <div class="col-6"><span class="label">Applicant (Ms):</span> <span class="value"><?= htmlspecialchars($data['applicant_title']) ?></span></div>
  </div>

  <div class="row">
    <div class="col-12"><span class="label">Address:</span> <span class="value"><?= nl2br(htmlspecialchars($data['address'])) ?></span></div>
  </div>

  <div class="row">
    <div class="col-4"><span class="label">Country:</span> <span class="value"><?= $data['country'] ?></span></div>
    <div class="col-4"><span class="label">Post Code:</span> <span class="value"><?= $data['post_code'] ?></span></div>
    <div class="col-4"><span class="label">Phone (Home):</span> <span class="value"><?= $data['phone_home'] ?></span></div>
  </div>

  <div class="row">
    <div class="col-6"><span class="label">Mobile:</span> <span class="value"><?= $data['mobile_no'] ?></span></div>
    <div class="col-6"><span class="label">Email:</span> <span class="value"><?= $data['email'] ?></span></div>
  </div>

  <div class="row">
    <div class="col-3"><span class="label">Unit Type:</span><div class="form-line"><?= $data['unit_type'] ?></div></div>
    <div class="col-3"><span class="label">Season:</span><div class="form-line"><?= $data['season'] ?></div></div>
    <div class="col-3"><span class="label">No. Weeks:</span><div class="form-line"><?= $data['no_weeks'] ?></div></div>
    <div class="col-3"><span class="label">Occupancy Years:</span><div class="form-line"><?= $data['occupancy_years'] ?></div></div>
  </div>

  <div class="row">
    <div class="col-4"><span class="label">Purchase Price:</span><div class="form-line"><?= $data['purchase_price'] ?></div></div>
    <div class="col-4"><span class="label">Deposit:</span><div class="form-line"><?= $data['deposit'] ?></div></div>
    <div class="col-4"><span class="label">Balance:</span><div class="form-line"><?= $data['balance'] ?></div></div>
  </div>

  <div class="row">
    <div class="col-6"><span class="label">Membership Type:</span> <span class="value"><?= $data['membership_type'] ?></span></div>
    <div class="col-3"><span class="label">Tenure:</span> <span class="value"><?= $data['tenure'] ?></span></div>
    <div class="col-3"><span class="label">Payment Mode:</span> <span class="value"><?= $data['payment_mode'] ?></span></div>
  </div>

  <div class="row">
    <div class="col-6"><span class="label">Hotel In:</span> <span class="value"><?= $data['hotel_place'] ?></span></div>
    <div class="col-6"><span class="label">Room No.:</span> <span class="value"><?= $data['room_no'] ?></span></div>
  </div>

  <div class="row">
    <div class="col-12"><span class="label">Remarks:</span> <span class="value"><?= nl2br(htmlspecialchars($data['remarks'])) ?></span></div>
  </div>

  <div class="row">
    <div class="col-4"><span class="label">Quota Applied:</span> <span class="value"><?= $data['quota_applied'] ? 'Yes' : 'No' ?></span></div>
    <div class="col-4"><span class="label">Client Approval:</span> <span class="value"><?= $data['client_approval'] ? '✔️' : '✖️' ?></span></div>
    <div class="col-4"><span class="label">Manager Approval:</span> <span class="value"><?= $data['manager_approval'] ? '✔️' : '✖️' ?></span></div>
  </div>

  <div class="row">
    <div class="col-6"><span class="label">Consultant:</span> <span class="value"><?= $data['consultant_name'] ?></span></div>
    <div class="col-6"><span class="label">Manager:</span> <span class="value"><?= $data['manager_name'] ?></span></div>
  </div>

  <div class="footer">RBV ROYALS BILTMORE VACATION PRIVATE LIMITED</div>
</div>
</body>
</html>
