<?php
include '../includes/db.php';
$clients = $conn->query("SELECT id, name FROM clients");

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $client = $_POST['client'];
    $type = $_POST['type'];
    $provider = $_POST['provider'];
    $panel_link = $_POST['panel_link'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $purchase = $_POST['purchase_date'];
    $expiry = $_POST['expiry_date'];
    $price = $_POST['price'];

    $stmt = $conn->prepare("INSERT INTO services (client_id, type, provider, panel_link, username, password, purchase_date, expiry_date, price) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
    $stmt->bind_param("isssssssd", $client, $type, $provider, $panel_link, $username, $password, $purchase, $expiry, $price);
    $stmt->execute();
    header("Location: ../index.php");
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Add Service</title>
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css">
</head>
<body class="bg-light">
<div class="container py-4">
  <h2>Add Service</h2>
  <form method="POST">
    <select name="client" class="form-control mb-2" required>
      <option value="">Select Client</option>
      <?php while ($c = $clients->fetch_assoc()): ?>
        <option value="<?= $c['id'] ?>"><?= htmlspecialchars($c['name']) ?></option>
      <?php endwhile; ?>
    </select>

    <select name="type" class="form-control mb-2">
      <option value="domain">Domain</option>
      <option value="hosting">Hosting</option>
      <option value="email">Email</option>
    </select>

    <input name="provider" class="form-control mb-2" placeholder="Provider Name">
    <input name="panel_link" class="form-control mb-2" placeholder="Panel URL">
    <input name="username" class="form-control mb-2" placeholder="Login Username">
    <input name="password" class="form-control mb-2" placeholder="Login Password">
    <input type="date" name="purchase_date" class="form-control mb-2">
    <input type="date" name="expiry_date" class="form-control mb-2">
    <input type="number" name="price" class="form-control mb-2" step="0.01" placeholder="Price">

    <button type="submit" class="btn btn-primary">Add Service</button>
  </form>
</div>
</body>
</html>
