File Manager

✏️ ail.php

<?php
// ============================================================
// RVCE – Admission Enquiry Mail Handler  (send_mail.php)
// PHP 8+ | CSRF Protected | Sanitized | HTML Email Templates
// ============================================================
declare(strict_types=1);
session_start();
header('Content-Type: application/json; charset=UTF-8');
require_once __DIR__ . '/generate_pdf.php';

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    http_response_code(405);
    echo json_encode(['success'=>false,'message'=>'Method Not Allowed']);
    exit;
}

// ── Config ──────────────────────────────────────────────────
const ADMIN_EMAIL  = 'admissions@rvce.ac.in';      // admin recipient
const FROM_EMAIL   = 'rvceoffice@rvce.ac.in';   // SMTP sender mailbox
const FROM_PASS    = 'Rvce@12#';               // SMTP password
const SMTP_HOST    = 'smtp.hostinger.com';      // Hostinger SMTP
const SMTP_PORT    = 465;                       // SSL port
const ADMIN_NAME   = 'RVCE Admissions';
const COLLEGE_FULL = 'Renganayagi Varatharaj College of Engineering';
const LOG_DIR      = __DIR__ . '/logs/';

if (!is_dir(LOG_DIR)) mkdir(LOG_DIR, 0755, true);

// ── CSRF ────────────────────────────────────────────────────
if (!hash_equals((string)($_SESSION['csrf_token']??''), (string)($_POST['csrf_token']??''))) {
    http_response_code(403);
    echo json_encode(['success'=>false,'message'=>'Invalid security token. Refresh the page.']);
    exit;
}

// ── Helpers ─────────────────────────────────────────────────
function s(string $v): string { return htmlspecialchars(strip_tags(trim($v)), ENT_QUOTES, 'UTF-8'); }
function sEmail(string $v): string { return (string)filter_var(trim($v), FILTER_SANITIZE_EMAIL); }
function sNum(string $v): string   { return preg_replace('/[^0-9.]/', '', trim($v)); }
function logLine(string $file, string $msg): void { file_put_contents(LOG_DIR.$file, '['.date('Y-m-d H:i:s').'] '.$msg.PHP_EOL, FILE_APPEND|LOCK_EX); }

// ── Collect fields ───────────────────────────────────────────
$serial_no          = s($_POST['serial_no']          ?? '');
$date               = s($_POST['date']               ?? '');
$referred_by        = s($_POST['referred_by']        ?? '');
$enquiry_no         = s($_POST['enquiry_no']         ?? '');

$student_name       = s($_POST['student_name']       ?? '');
$school_name        = s($_POST['school_name']        ?? '');
$board              = s($_POST['board']              ?? '');
$govt_school        = s($_POST['govt_school']        ?? '');

$father_name        = s($_POST['father_name']        ?? '');
$medium             = s($_POST['medium']             ?? '');
$gender             = s($_POST['gender']             ?? '');
$emis_no            = s($_POST['emis_no']            ?? '');
$student_mobile     = sNum($_POST['student_mobile']  ?? '');
$parent_mobile      = sNum($_POST['parent_mobile']   ?? '');
$email              = sEmail($_POST['email']         ?? '');
$community          = s($_POST['community']          ?? '');
$first_graduate     = s($_POST['first_graduate']     ?? '');
$aadhaar_no         = s($_POST['aadhaar_no']         ?? '');
$door_no            = s($_POST['door_no']            ?? '');
$street             = s($_POST['street']             ?? '');
$town               = s($_POST['town']               ?? '');
$district           = s($_POST['district']           ?? '');
$state              = s($_POST['state']              ?? '');
$pincode            = sNum($_POST['pincode']         ?? '');
$address            = implode(', ', array_filter([$door_no, $street, $town, $district, $state]));

$qual_type          = s($_POST['qual_type']          ?? 'HSC');
$group              = s($_POST['group']              ?? '');
$vocational_subject = s($_POST['vocational_subject'] ?? '');
$dob                = s($_POST['dob']                ?? '');
$reg_no             = s($_POST['reg_no']             ?? '');
$poly_group         = s($_POST['poly_group']         ?? '');
$sslc_marks         = sNum($_POST['sslc_marks']      ?? '');
$dip_obtained       = sNum($_POST['dip_obtained']    ?? '');
$dip_total          = sNum($_POST['dip_total']       ?? '');
$dip_pct            = sNum($_POST['dip_pct']         ?? '');

// Subject marks
$phy  = sNum($_POST['phy']  ?? '');
$che  = sNum($_POST['che']  ?? '');
$maths= sNum($_POST['maths']?? '');
$bio  = sNum($_POST['bio']  ?? '');
$cs   = sNum($_POST['cs']   ?? '');
$et   = sNum($_POST['et']   ?? '');
$vt   = sNum($_POST['vt']   ?? '');
$vp   = sNum($_POST['vp']   ?? '');

// Calculated
$total_marks        = sNum($_POST['total_marks'] ?? '');
$percentage         = sNum($_POST['percentage']  ?? '');
$cutoff             = sNum($_POST['cutoff']      ?? '');

$selected_branches  = s($_POST['selected_branches'] ?? '');
$place              = s($_POST['place']             ?? '');

// ── Server-side validation ───────────────────────────────────
$errs = [];
if (!$student_name)   $errs[] = 'Student name required.';
if (!$school_name)    $errs[] = 'School name required.';
if (!$father_name)    $errs[] = "Father's name required.";
if (!$student_mobile || !preg_match('/^[6-9]\d{9}$/', $student_mobile)) $errs[] = 'Valid mobile required.';
if ($email && !filter_var($email, FILTER_VALIDATE_EMAIL)) $errs[] = 'Invalid email.';
if ($qual_type !== 'Diploma' && !$group) $errs[] = 'Group required.';
if (!$gender)         $errs[] = 'Gender required.';
if (!$dob)            $errs[] = 'Date of birth required.';

if ($errs) { echo json_encode(['success'=>false,'message'=>implode(' ',$errs)]); exit; }

// ── Build subject rows ───────────────────────────────────────
if ($qual_type === 'Diploma') {
    $subjectRows    = [];
    $cutoff_formula = 'N/A';
} elseif ($group === 'Bio-Maths')          { $subjectRows = [['Physics',$phy],['Chemistry',$che],['Maths',$maths],['Biology',$bio]]; $cutoff_formula = 'Maths + (Physics ÷ 2) + (Chemistry ÷ 2)'; }
elseif ($group === 'Computer-Maths') { $subjectRows = [['Physics',$phy],['Chemistry',$che],['Maths',$maths],['Computer Science',$cs]]; $cutoff_formula = 'Maths + (Physics ÷ 2) + (Chemistry ÷ 2)'; }
elseif ($group === 'Vocational')     { $subjectRows = [['Maths',$maths],['Elective Theory',$et],['Voc. Theory',$vt],['Voc. Practical',$vp]]; $cutoff_formula = 'Voc. Theory + Voc. Practical + (Maths ÷ 2) + (Elective Theory ÷ 2)'; }
else                                 { $subjectRows = [['Physics',$phy],['Chemistry',$che]]; $cutoff_formula = 'N/A'; }

// ── Email CSS wrapper ────────────────────────────────────────
function wrap(string $body): string {
    return <<<HTML
<!DOCTYPE html><html lang="en"><head><meta charset="UTF-8"/>
<style>
*{margin:0;padding:0;box-sizing:border-box;}
body{font-family:'Segoe UI',Helvetica,Arial,sans-serif;background:#eef0f7;color:#1a1f36;font-size:15px;line-height:1.6;}
.w{max-width:660px;margin:24px auto;background:#ffffff;border-radius:12px;overflow:hidden;box-shadow:0 4px 24px rgba(15,45,110,.13);}
/* Header */
.hd{background:linear-gradient(135deg,#0d1f5e 0%,#1e3a9f 55%,#0369a1 100%);padding:32px 28px;text-align:center;border-bottom:4px solid #e31e25;}
.hd h1{color:#ffffff;font-size:20px;font-weight:800;margin-bottom:6px;letter-spacing:.3px;}
.hd p{color:rgba(255,255,255,.82);font-size:13px;}
.badge{display:inline-block;background:rgba(255,255,255,.2);border:1px solid rgba(255,255,255,.35);border-radius:20px;padding:4px 16px;color:#ffffff;font-size:12px;font-weight:600;margin-top:10px;}
/* Body */
.body{padding:28px 32px;}
/* Section heading */
.sec{font-size:11px;font-weight:700;color:#1e3a9f;text-transform:uppercase;letter-spacing:.08em;border-bottom:2px solid #e0e7ff;padding-bottom:6px;margin:24px 0 12px;}
/* Table */
table.t{width:100%;border-collapse:collapse;font-size:14px;}
table.t tr:nth-child(even) td{background:#f8f9ff;}
table.t td{padding:9px 12px;border-bottom:1px solid #e8eaf5;vertical-align:top;}
table.t td:first-child{color:#64748b;width:40%;font-weight:600;font-size:13px;}
table.t td:last-child{color:#111827;font-weight:700;font-size:14px;}
/* Stats row */
.stats{display:table;width:100%;background:#f0f4ff;border:1.5px solid #c7d7ff;border-radius:10px;padding:16px 12px;margin:16px 0;text-align:center;}
.stat{display:inline-block;width:45%;padding:6px 0;}
.stat .v{font-size:26px;font-weight:900;color:#0d1f5e;}
.stat .l{font-size:12px;color:#475569;margin-top:3px;font-weight:600;text-transform:uppercase;letter-spacing:.04em;}
/* Cutoff */
.cutbox{background:#fff5f5;border:2px solid #fca5a5;border-radius:10px;padding:18px;text-align:center;margin:14px 0;}
.cutbox .v{font-size:36px;font-weight:900;color:#dc2626;line-height:1;}
.cutbox .l{font-size:13px;color:#6b7280;margin-top:6px;font-weight:600;}
.fml{background:#fefce8;border:1px solid #fde68a;border-radius:7px;padding:9px 14px;font-size:13px;color:#78350f;margin-top:10px;font-weight:600;}
/* Branch tags */
.brtags{padding:4px 0 8px;}
.br{display:inline-block;background:#e0e7ff;border:1.5px solid #a5b4fc;border-radius:6px;padding:5px 13px;font-size:13px;font-weight:700;color:#1e3a9f;margin:4px 4px 0 0;}
/* Alert box */
.alert{background:#fffbeb;border:1.5px solid #fde68a;border-radius:8px;padding:14px 16px;margin-top:20px;font-size:14px;color:#92400e;}
/* Footer */
.ft{background:#0d1f5e;padding:22px 28px;text-align:center;border-top:4px solid #e31e25;}
.ft p{color:rgba(255,255,255,.7);font-size:13px;line-height:2;}
.ft a{color:#67e8f9;text-decoration:none;}
.ft strong{color:#ffffff;}
</style></head><body>
<div class="w">{$body}
<div class="ft">
  <p><strong>RENGANAYAGI VARATHARAJ COLLEGE OF ENGINEERING</strong></p>
  <p>Salvarpatti, Sivakasi – 626128 &nbsp;|&nbsp; Tamil Nadu</p>
  <p>AICTE Approved &nbsp;|&nbsp; Anna University Affiliated</p>
  <p>&#128222; 9940700195, 04562 234500 &nbsp;|&nbsp; &#127760; <a href="http://www.rvce.ac.in">www.rvce.ac.in</a></p>
</div></div></body></html>
HTML;
}

// ── Admin email ──────────────────────────────────────────────
function adminMail(array $p, array $subjectRows, string $cutoff_formula): string {
    $sRows = '';
    foreach ($subjectRows as [$lbl,$val]) {
        $v = $val !== '' ? $val.' / 100' : '—';
        $sRows .= "<tr><td>{$lbl}</td><td>{$v}</td></tr>";
    }
    $bTags = '';
    foreach (explode(',', $p['selected_branches']) as $br) {
        $br = trim($br); if ($br) $bTags .= "<div class=\"br\">{$br}</div>";
    }
    $email_link   = $p['email'] ? " | <a href=\"mailto:{$p['email']}\">{$p['email']}</a>" : '';
    $addr_pincode = $p['address'] . ($p['pincode'] ? ' – ' . $p['pincode'] : '');

// Academic rows — built before heredoc to avoid ternary-inside-heredoc errors
    if ($p['qual_type'] === 'Diploma') {
        $acadRows = "<tr><td>Diploma Branch</td><td>{$p['poly_group']}</td></tr>"
                  . "<tr><td>Diploma Marks</td><td>{$p['dip_obtained']} / {$p['dip_total']} ({$p['dip_pct']}%)</td></tr>";
        $marksSection = '';
    } else {
        $acadRows     = "<tr><td>Group</td><td>{$p['group']}</td></tr>";
        $marksSection = <<<MRK
  <div class="sec">HSC (+2) Subject Marks &mdash; {$p['group']}</div>
  <table class="t">{$sRows}</table>
  <div class="stats">
    <div class="stat"><div class="v">{$p['total_marks']}</div><div class="l">Total Marks</div></div>
    <div class="stat"><div class="v">{$p['percentage']}%</div><div class="l">Percentage</div></div>
  </div>
  <div class="cutbox">
    <div class="v">{$p['cutoff']}</div>
    <div class="l">Anna University Cutoff (out of 200)</div>
    <div class="fml">Formula: {$cutoff_formula}</div>
  </div>
MRK;
    }

$body = <<<HTML
<div class="hd">
  <h1>&#128203; New Admission Enquiry</h1>
  <p>RENGANAYAGI VARATHARAJ COLLEGE OF ENGINEERING</p>
  <div class="badge">Enquiry: {$p['enquiry_no']}</div>
  <div class="badge" style="margin-left:5px;">Date: {$p['date']}</div>
</div>
<div class="body">
  <div class="sec">Enquiry Info</div>
  <table class="t">
    <tr><td>No.</td><td>{$p['serial_no']}</td></tr>
    <tr><td>Enquiry No.</td><td>{$p['enquiry_no']}</td></tr>
    <tr><td>Date</td><td>{$p['date']}</td></tr>
    <tr><td>Referred By</td><td>{$p['referred_by']}</td></tr>
  </table>
  <div class="sec">Student Details</div>
  <table class="t">
    <tr><td>Student Name</td><td>{$p['student_name']}</td></tr>
    <tr><td>School / Polytechnic</td><td>{$p['school_name']}</td></tr>
    <tr><td>Board</td><td>{$p['board']}</td></tr>
    <tr><td>Govt. School (6th–12th)</td><td>{$p['govt_school']}</td></tr>
  </table>
  <div class="sec">Parent &amp; Personal Details</div>
  <table class="t">
    <tr><td>Father's Name</td><td>{$p['father_name']}</td></tr>
    <tr><td>Medium</td><td>{$p['medium']}</td></tr>
    <tr><td>Gender</td><td>{$p['gender']}</td></tr>
    <tr><td>EMIS No.</td><td>{$p['emis_no']}</td></tr>
    <tr><td>Student Mobile</td><td>{$p['student_mobile']}</td></tr>
    <tr><td>Parent Mobile</td><td>{$p['parent_mobile']}</td></tr>
    <tr><td>Email</td><td>{$p['email']}</td></tr>
    <tr><td>Community</td><td>{$p['community']}</td></tr>
    <tr><td>First Graduate</td><td>{$p['first_graduate']}</td></tr>
    <tr><td>Aadhaar No.</td><td>{$p['aadhaar_no']}</td></tr>
    <tr><td>Address</td><td>{$addr_pincode}</td></tr>
    <tr><td>Place</td><td>{$p['place']}</td></tr>
  </table>
  <div class="sec">Academic Details</div>
  <table class="t">
    <tr><td>Qualification</td><td>{$p['qual_type']}</td></tr>
    <tr><td>Date of Birth</td><td>{$p['dob']}</td></tr>
    <tr><td>SSLC Total Marks</td><td>{$p['sslc_marks']}</td></tr>
    <tr><td>Register No.</td><td>{$p['reg_no']}</td></tr>
    {$acadRows}
  </table>
  {$marksSection}
  <div class="sec">Preferred Branches</div>
  <div class="brtags">{$bTags}</div>
  <div style="background:#fef9ec;border:1px solid #fde68a;border-radius:7px;padding:11px 14px;margin-top:18px;font-size:.81rem;color:#92400e;">
    <strong>&#9889; Action Required:</strong> Please follow up within 24 hours.<br>
    Contact: <strong>{$p['student_mobile']}</strong>{$email_link}
  </div>
</div>
HTML;
    return wrap($body);
}

// ── Form PDF HTML (attached to both emails) ──────────────────
function formPdfHtml(array $p, array $subjectRows, string $cutoff_formula): string {
    $sRows = '';
    foreach ($subjectRows as [$lbl,$val]) {
        $v = $val !== '' ? $val.' / 100' : '—';
        $sRows .= "<tr><td>{$lbl}</td><td>{$v}</td></tr>";
    }
    $bTags = '';
    foreach (explode(',', $p['selected_branches']) as $br) {
        $br = trim($br); if ($br) $bTags .= "<span class=\"br\">{$br}</span>";
    }
    $addr = $p['address'] . ($p['pincode'] ? ' – '.$p['pincode'] : '');

if ($p['qual_type'] === 'Diploma') {
        $acadExtra = "<tr><td>Diploma Branch</td><td>{$p['poly_group']}</td></tr>"
                   . "<tr><td>Diploma Marks</td><td>{$p['dip_obtained']} / {$p['dip_total']} ({$p['dip_pct']}%)</td></tr>";
        $marksBlock = '';
    } else {
        $acadExtra  = "<tr><td>Group</td><td>{$p['group']}</td></tr>";
        $marksBlock = $sRows ? <<<BLK
<div class="sec">HSC (+2) Subject Marks &mdash; {$p['group']}</div>
<table>{$sRows}</table>
<div class="stats">
  <div class="stat"><div class="sv">{$p['total_marks']}</div><div class="sl">Total Marks</div></div>
  <div class="stat"><div class="sv">{$p['percentage']}%</div><div class="sl">Percentage</div></div>
  <div class="stat cut"><div class="sv" style="color:#dc2626;">{$p['cutoff']}</div><div class="sl">Cutoff / 200</div></div>
</div>
<div class="fml">Cutoff Formula: {$cutoff_formula}</div>
BLK : '';
    }

return <<<PDF
<!DOCTYPE html><html lang="en"><head><meta charset="UTF-8"/>
<style>
*{box-sizing:border-box;margin:0;padding:0;}
body{font-family:'Segoe UI',Arial,sans-serif;font-size:12.5px;color:#111;background:#fff;padding:28px 32px;}
.hdr{text-align:center;border-bottom:3px solid #1e2d8a;padding-bottom:14px;margin-bottom:18px;}
.hdr h1{font-size:1.05rem;font-weight:900;color:#0f1e6e;margin:8px 0 3px;letter-spacing:.02em;}
.hdr p{font-size:.75rem;color:#555;margin:2px 0;}
.hdr .tag{display:inline-block;margin-top:8px;background:#1e2d8a;color:#fff;border-radius:5px;padding:4px 16px;font-size:.8rem;font-weight:700;}
.sec{font-size:.68rem;font-weight:800;text-transform:uppercase;letter-spacing:.08em;color:#1e2d8a;
     border-bottom:2px solid #c7d2fe;padding-bottom:4px;margin:16px 0 8px;}
table{width:100%;border-collapse:collapse;margin-bottom:6px;}
td{padding:6px 9px;border:1px solid #e2e8f0;font-size:.8rem;vertical-align:top;}
td:first-child{width:36%;background:#f5f7ff;font-weight:700;color:#374151;}
td:last-child{font-weight:600;color:#111;}
.stats{display:flex;gap:10px;margin:12px 0 6px;}
.stat{flex:1;border:1.5px solid #c7d7ff;border-radius:8px;padding:10px 8px;text-align:center;background:#f0f4ff;}
.stat.cut{border-color:#fca5a5;background:#fff5f5;}
.sv{font-size:1.3rem;font-weight:900;color:#1e2d8a;}
.sl{font-size:.62rem;color:#64748b;margin-top:3px;font-weight:700;text-transform:uppercase;letter-spacing:.04em;}
.fml{background:#fefce8;border:1px solid #fde68a;border-radius:6px;padding:7px 12px;font-size:.75rem;color:#78350f;font-weight:600;margin-bottom:8px;}
.br{display:inline-block;background:#e0e7ff;border:1px solid #a5b4fc;border-radius:5px;padding:3px 11px;font-size:.75rem;font-weight:700;color:#1e2d8a;margin:3px 3px 0 0;}
.sign{display:flex;gap:16px;margin-top:24px;}
.sign-box{flex:1;text-align:center;}
.sign-line{height:46px;border-bottom:1.5px solid #94a3b8;margin-bottom:5px;}
.sign-lbl{font-size:.6rem;font-weight:800;color:#94a3b8;text-transform:uppercase;letter-spacing:.06em;}
.ft{margin-top:20px;border-top:2px solid #1e2d8a;padding-top:8px;text-align:center;font-size:.7rem;color:#555;line-height:1.8;}
</style></head><body>
<div class="hdr">
  <h1>RENGANAYAGI VARATHARAJ COLLEGE OF ENGINEERING</h1>
  <p>Approved by AICTE, New Delhi &nbsp;|&nbsp; Affiliated to Anna University, Chennai</p>
  <p>Salvarpatti, Sivakasi, Virudhunagar District &ndash; 626128</p>
  <p style="margin-top:5px;font-weight:700;color:#1e2d8a;font-size:.85rem;">STUDENT ADMISSION ENQUIRY FORM &ndash; 2026&ndash;2027</p>
  <span class="tag">Ref: {$p['enquiry_no']} &nbsp;|&nbsp; Date: {$p['date']}</span>
</div>

<div class="sec">Enquiry Information</div>
<table>
  <tr><td>Enquiry No.</td><td>{$p['enquiry_no']}</td><td>Serial No.</td><td>{$p['serial_no']}</td></tr>
  <tr><td>Date</td><td>{$p['date']}</td><td>Referred By</td><td>{$p['referred_by']}</td></tr>
</table>

<div class="sec">Student Details</div>
<table>
  <tr><td>Student Name</td><td>{$p['student_name']}</td><td>Gender</td><td>{$p['gender']}</td></tr>
  <tr><td>School / Polytechnic</td><td>{$p['school_name']}</td><td>Board</td><td>{$p['board']}</td></tr>
  <tr><td>Govt. School (6th–12th)</td><td>{$p['govt_school']}</td><td>Medium</td><td>{$p['medium']}</td></tr>
</table>

<div class="sec">Parent &amp; Personal Details</div>
<table>
  <tr><td>Father's Name</td><td>{$p['father_name']}</td><td>Community</td><td>{$p['community']}</td></tr>
  <tr><td>Student Mobile</td><td>{$p['student_mobile']}</td><td>Parent Mobile</td><td>{$p['parent_mobile']}</td></tr>
  <tr><td>Email</td><td>{$p['email']}</td><td>First Graduate</td><td>{$p['first_graduate']}</td></tr>
  <tr><td>Date of Birth</td><td>{$p['dob']}</td><td>Aadhaar No.</td><td>{$p['aadhaar_no']}</td></tr>
  <tr><td>Address</td><td colspan="3">{$addr}</td></tr>
</table>

<div class="sec">Academic Details</div>
<table>
  <tr><td>Qualification</td><td>{$p['qual_type']}</td><td>SSLC Total Marks</td><td>{$p['sslc_marks']}</td></tr>
  <tr><td>Register No.</td><td>{$p['reg_no']}</td><td>EMIS No.</td><td>{$p['emis_no']}</td></tr>
  {$acadExtra}
</table>

{$marksBlock}

<div class="sec">Preferred Branches</div>
<div style="padding:6px 0 10px;">{$bTags}</div>

<div class="sign">
  <div class="sign-box"><div class="sign-line"></div><div class="sign-lbl">Admission Incharge</div></div>
  <div class="sign-box"><div class="sign-line"></div><div class="sign-lbl">Office Use</div></div>
  <div class="sign-box"><div class="sign-line"></div><div class="sign-lbl">Principal</div></div>
</div>

<div class="ft">
  Renganayagi Varatharaj College of Engineering &nbsp;|&nbsp; Counselling Code: 4676<br>
  Salvarpatti, Sivakasi &ndash; 626128 &nbsp;|&nbsp; Ph: 9940700195, 04562 234500 &nbsp;|&nbsp; office@rvce.ac.in &nbsp;|&nbsp; www.rvce.ac.in
</div>
</body></html>
PDF;
}

// ── Student confirmation email ────────────────────────────────
function studentMail(string $name, string $enquiry_no, string $mobile): string {
    $body = <<<HTML
<div class="hd">
  <h1>&#127891; Application Received!</h1>
  <p>RENGANAYAGI VARATHARAJ COLLEGE OF ENGINEERING</p>
  <div class="badge">Ref: {$enquiry_no}</div>
</div>
<div class="body">
  <p style="font-size:1rem;font-weight:700;color:#0d1f5e;margin-bottom:10px;">Dear {$name},</p>
  <p style="font-size:.88rem;color:#374151;line-height:1.9;margin-bottom:16px;">
    Thank you for submitting your admission enquiry to
    <strong>Renganayagi Varatharaj College of Engineering, Sivakasi</strong>.
    Your application form has been received successfully and is attached to this email for your records.
  </p>

<div style="background:linear-gradient(135deg,#f0f4ff,#e0e7ff);border:1.5px solid #a5b4fc;border-radius:10px;padding:16px 20px;margin-bottom:18px;">
    <table style="width:100%;border:none;" class="t">
      <tr style="background:transparent;"><td style="background:transparent;color:#374151;font-weight:700;border:none;padding:5px 0;">Enquiry Reference</td><td style="background:transparent;font-weight:800;color:#1e2d8a;border:none;font-size:1rem;">{$enquiry_no}</td></tr>
      <tr style="background:transparent;"><td style="background:transparent;color:#374151;font-weight:700;border:none;padding:5px 0;">Registered Mobile</td><td style="background:transparent;font-weight:700;color:#1e2d8a;border:none;">{$mobile}</td></tr>
    </table>
  </div>

<div style="background:#eff3ff;border-left:4px solid #4f46e5;border-radius:8px;padding:14px 16px;margin-bottom:16px;">
    <p style="font-size:.82rem;font-weight:800;color:#312e81;margin-bottom:8px;">&#128204; What happens next?</p>
    <ol style="padding-left:18px;font-size:.82rem;color:#374151;line-height:2.2;">
      <li>Our admission counsellor will call you within <strong>24 hours</strong>.</li>
      <li>Carry original mark sheets &amp; certificates during your visit.</li>
      <li>Visit us at <strong>Salvarpatti, Sivakasi</strong> for a campus tour.</li>
      <li>Check counselling dates at <a href="http://www.rvce.ac.in" style="color:#4f46e5;font-weight:700;">www.rvce.ac.in</a></li>
    </ol>
  </div>

<div style="background:#f0fdf4;border:1.5px solid #86efac;border-radius:10px;padding:14px 18px;margin-bottom:16px;">
    <p style="font-size:.85rem;font-weight:800;color:#065f46;margin-bottom:8px;">&#127963; College Contact</p>
    <table style="width:100%;border:none;" class="t">
      <tr style="background:transparent;"><td style="background:transparent;border:none;padding:4px 0;font-weight:700;color:#374151;width:40%;">&#128222; Phone</td><td style="background:transparent;border:none;font-weight:600;color:#065f46;">9940700195, 04562 234500</td></tr>
      <tr style="background:transparent;"><td style="background:transparent;border:none;padding:4px 0;font-weight:700;color:#374151;">&#9993; Email</td><td style="background:transparent;border:none;font-weight:600;color:#065f46;">office@rvce.ac.in</td></tr>
      <tr style="background:transparent;"><td style="background:transparent;border:none;padding:4px 0;font-weight:700;color:#374151;">&#127760; Website</td><td style="background:transparent;border:none;font-weight:600;color:#065f46;"><a href="http://www.rvce.ac.in" style="color:#059669;">www.rvce.ac.in</a></td></tr>
      <tr style="background:transparent;"><td style="background:transparent;border:none;padding:4px 0;font-weight:700;color:#374151;">&#128205; Address</td><td style="background:transparent;border:none;font-weight:600;color:#065f46;">Salvarpatti, Sivakasi, Virudhunagar Dist &ndash; 626128</td></tr>
      <tr style="background:transparent;"><td style="background:transparent;border:none;padding:4px 0;font-weight:700;color:#374151;">&#35; Counselling Code</td><td style="background:transparent;border:none;font-weight:800;color:#065f46;font-size:.95rem;">4676</td></tr>
    </table>
  </div>

<p style="font-size:.72rem;color:#94a3b8;text-align:center;margin-top:8px;">
    Your filled application form is attached to this email as a reference copy.<br>
    This is an automated message — please do not reply to this email.
  </p>
</div>
HTML;
    return wrap($body);
}

// ── Send mail via PHPMailer SMTP ──────────────────────────────
function sendMail(string $toEmail, string $toName, string $subject, string $html, string $pdfBytes = '', string $attachName = ''): bool {
    try {
        $mail = new PHPMailer\PHPMailer\PHPMailer(true);
        $mail->isSMTP();
        $mail->Host       = SMTP_HOST;
        $mail->SMTPAuth   = true;
        $mail->Username   = FROM_EMAIL;
        $mail->Password   = FROM_PASS;
        $mail->SMTPSecure = PHPMailer\PHPMailer\PHPMailer::ENCRYPTION_SMTPS;
        $mail->Port       = SMTP_PORT;
        $mail->CharSet    = 'UTF-8';

$mail->setFrom(FROM_EMAIL, ADMIN_NAME);
        $mail->addReplyTo(ADMIN_EMAIL, ADMIN_NAME);
        $mail->addAddress($toEmail, $toName);

$mail->isHTML(true);
        $mail->Subject = $subject;
        $mail->Body    = $html;

if ($pdfBytes !== '' && $attachName !== '') {
            $mail->addStringAttachment($pdfBytes, $attachName, PHPMailer\PHPMailer\PHPMailer::ENCODING_BASE64, 'application/pdf');
        }

$mail->send();
        return true;
    } catch (\Exception $e) {
        logLine('errors.log', 'PHPMailer error: ' . $e->getMessage());
        return false;
    }
}

// ── Assemble ─────────────────────────────────────────────────
$p = compact(
    'serial_no','date','referred_by','enquiry_no',
    'student_name','school_name','board','govt_school',
    'father_name','medium','gender','emis_no',
    'student_mobile','parent_mobile','email',
    'community','first_graduate','aadhaar_no','address','door_no','street','town','district','state','pincode','place',
    'qual_type','group','vocational_subject','dob','reg_no','poly_group','sslc_marks',
    'dip_obtained','dip_total','dip_pct',
    'total_marks','percentage','cutoff','selected_branches'
);

// ── Generate real PDF using TCPDF ────────────────────────────
$p['logo_path'] = __DIR__ . '/img/rvce_logo.webp';
$pdfBytes       = makePdf($p, $subjectRows, $cutoff_formula, 'S');
$attachName     = "RVCE_Enquiry_{$enquiry_no}.pdf";
$adminHtml      = adminMail($p, $subjectRows, $cutoff_formula);

// ── Store in session for download button ─────────────────────
$_SESSION['pdf_data']         = $p;
$_SESSION['pdf_subject_rows'] = $subjectRows;
$_SESSION['pdf_formula']      = $cutoff_formula;

$adminSent = sendMail(ADMIN_EMAIL, ADMIN_NAME,
    "Admission Enquiry: {$student_name} | {$enquiry_no}",
    $adminHtml, $pdfBytes, $attachName
);

if (!$adminSent) logLine('errors.log', "Admin mail failed | {$enquiry_no} | {$student_name} | {$student_mobile}");

$studentSent = true;
if ($email && filter_var($email, FILTER_VALIDATE_EMAIL)) {
    $studentHtml = studentMail($student_name, $enquiry_no, $student_mobile);
    $studentSent = sendMail($email, $student_name,
        "Application Received – RVCE Sivakasi | {$enquiry_no}",
        $studentHtml, $pdfBytes, $attachName
    );
    if (!$studentSent) logLine('errors.log', "Student mail failed | {$email} | {$enquiry_no}");
}

// ── Log entry ────────────────────────────────────────────────
logLine('enquiries.log',
    "OK | {$enquiry_no} | {$student_name} | {$student_mobile} | {$group} | Cutoff:{$cutoff} | Branches:{$selected_branches} | MailAdmin:".($adminSent?'Y':'N')
);

// ── Response — always succeed; email failure is non-blocking ──
$_SESSION['csrf_token'] = bin2hex(random_bytes(32));
echo json_encode(['success'=>true,'message'=>'Enquiry submitted.','enquiry_no'=>$enquiry_no]);

Batal

⬅ public_html 14 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁css	dir	—	2026-08-05 11:53	📂 Buka
📁img	dir	—	2026-05-23 10:10	📂 Buka
📁js	dir	—	2026-05-21 15:52	📂 Buka
📁logs	dir	—	2026-05-21 15:52	📂 Buka
📁oldbackup	dir	—	2026-05-21 15:52	📂 Buka
📁vendor	dir	—	2026-05-21 15:52	📂 Buka
📋composer.json	json	102 B	2026-05-21 15:52	✏️ 👁️
📄composer.lock	lock	7.1 KB	2026-05-21 15:52	✏️ 👁️
📄composer.phar	phar	3.2 MB	2026-05-21 15:52	✏️ 👁️
🐘download_pdf.php	php	842 B	2026-05-21 15:52	✏️ 👁️
🐘generate_pdf.php	php	12.7 KB	2026-05-23 10:11	✏️ 👁️
🐘index.php	php	46 KB	2026-05-23 10:19	✏️ 👁️
🗜️rvceformfinal.zip	zip	15.8 MB	2026-05-21 15:52	✏️ 👁️
🐘send_mail.php	php	28.6 KB	2026-05-21 15:52	✏️ 👁️

✏️ Rename