<?php
include "db.php";

$success = "";
$error = "";

// GET POSITION FROM URL
$position = isset($_GET['position']) ? $_GET['position'] : "";

// FORM SUBMIT
if(isset($_POST['submit'])){

    $name = htmlspecialchars($_POST['name']);
    $email = htmlspecialchars($_POST['email']);
    $phone = htmlspecialchars($_POST['phone']);
    $position = htmlspecialchars($_POST['position']);
    $message = htmlspecialchars($_POST['message']);

    // FILE UPLOAD
    $cv_name = $_FILES['cv']['name'];
    $cv_tmp  = $_FILES['cv']['tmp_name'];
    $cv_size = $_FILES['cv']['size'];

    $upload_dir = "uploads/";

    // AUTO CREATE FOLDER
    if(!is_dir($upload_dir)){
        mkdir($upload_dir,0777,true);
    }

    // FILE EXTENSION CHECK
    $file_ext = strtolower(pathinfo($cv_name, PATHINFO_EXTENSION));

    if($file_ext != "pdf"){
        $error = "❌ Only PDF file allowed!";
    }
    elseif($cv_size > 2*1024*1024){ // 2MB limit
        $error = "❌ File size must be under 2MB!";
    }
    else{

        // UNIQUE FILE NAME
        $cv_path = $upload_dir . time() . "_" . basename($cv_name);

        if(move_uploaded_file($cv_tmp, $cv_path)){

            // PREPARED STATEMENT (SECURE)
            $stmt = $conn->prepare("INSERT INTO job_applications (name,email,phone,position,message,cv) VALUES (?,?,?,?,?,?)");
            $stmt->bind_param("ssssss", $name, $email, $phone, $position, $message, $cv_path);

            if($stmt->execute()){
                $success = "✅ Application submitted successfully!";
            } else {
                $error = "❌ Database error!";
            }

        } else {
            $error = "❌ File upload failed!";
        }
    }
}
?>

<!DOCTYPE html>
<html lang="en">
<head>

<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Apply for Job | MPS Meghna Construction</title>

<link rel="stylesheet" href="assets/css/base.css">
<link rel="stylesheet" href="assets/css/header.css">
<link rel="stylesheet" href="assets/css/footer.css">

<style>

/* BACKGROUND */
body{
  background:#f5f7fb;
  font-family:'Poppins',sans-serif;
}

/* WRAPPER */
.apply-wrapper{
  padding:100px 8%;
}

/* BOX */
.apply-box{
  max-width:650px;
  margin:auto;
  background:#fff;
  padding:40px;
  border-radius:12px;
  box-shadow:0 15px 40px rgba(0,0,0,0.08);
}

/* TITLE */
.apply-box h2{
  color:#081633;
  margin-bottom:5px;
}

.subtitle{
  font-size:14px;
  color:#777;
  margin-bottom:20px;
}

/* FORM */
.form-group{
  margin-bottom:15px;
}

.form-group label{
  font-size:13px;
  margin-bottom:5px;
  display:block;
}

.form-group input,
.form-group textarea{
  width:100%;
  padding:12px;
  border:1px solid #ddd;
  border-radius:6px;
}

/* BUTTON */
.apply-btn{
  width:100%;
  padding:14px;
  background:#ff4d00;
  color:#fff;
  border:none;
  border-radius:6px;
  cursor:pointer;
  transition:.3s;
}

.apply-btn:hover{
  background:#081633;
}

/* ALERT */
.alert{
  padding:12px;
  margin-bottom:15px;
  border-radius:5px;
}

.success{
  background:#d4edda;
  color:#155724;
}

.error{
  background:#f8d7da;
  color:#721c24;
}

</style>

</head>

<body>

<div id="header"></div>
<div id="menubar"></div>

<div class="apply-wrapper">

<div class="apply-box">

<h2>Apply for Position</h2>
<p class="subtitle">Join MPS Meghna Construction Team</p>

<?php if($success != ""){ ?>
  <div class="alert success"><?php echo $success; ?></div>
<?php } ?>

<?php if($error != ""){ ?>
  <div class="alert error"><?php echo $error; ?></div>
<?php } ?>

<form method="POST" enctype="multipart/form-data">

<div class="form-group">
<label>Full Name</label>
<input type="text" name="name" required>
</div>

<div class="form-group">
<label>Email</label>
<input type="email" name="email" required>
</div>

<div class="form-group">
<label>Phone</label>
<input type="text" name="phone" required>
</div>

<div class="form-group">
<label>Position</label>
<input type="text" name="position" value="<?php echo $position; ?>" readonly>
</div>

<div class="form-group">
<label>Message</label>
<textarea name="message"></textarea>
</div>

<div class="form-group">
<label>Upload CV (PDF only, max 2MB)</label>
<input type="file" name="cv" required>
</div>

<button type="submit" name="submit" class="apply-btn">
Submit Application →
</button>

</form>

</div>

</div>

<div id="footer"></div>

<script src="actions/script.js"></script>
</body>
</html>