<?php
require("dbconnect.php");

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Insert Header
    $title          = $_POST['title'];
    $company_name   = $_POST['company_name'];
    $visa_type      = $_POST['visa_type'];
    $selection_type = $_POST['selection_type'];

    // Logo upload
    $logo_left = $_FILES['logo_left']['name'];
    $logo_right = $_FILES['logo_right']['name'];

    if($logo_left) move_uploaded_file($_FILES['logo_left']['tmp_name'], "uploads/".$logo_left);
    if($logo_right) move_uploaded_file($_FILES['logo_right']['tmp_name'], "uploads/".$logo_right);

    $con->query("INSERT INTO demand_header (title, company_name, visa_type, selection_type, logo_left, logo_right)
                 VALUES ('$title','$company_name','$visa_type','$selection_type','$logo_left','$logo_right')");

    $demand_id = $con->insert_id;

    // Insert Trades
    foreach($_POST['trade'] as $i => $trade){
        $qty    = $_POST['qty'][$i];
        $salary = $_POST['salary'][$i];
        if($trade!=""){
            $con->query("INSERT INTO demand_trades (demand_id, trade, qty, salary) 
                         VALUES ($demand_id,'$trade','$qty','$salary')");
        }
    }

    // Insert Terms
    $duty_hours    = $_POST['duty_hours'];
    $age_limit     = $_POST['age_limit'];
    $contract      = $_POST['contract_period'];
    $medical       = $_POST['medical'];
    $accommodation = $_POST['accommodation'];

    $con->query("INSERT INTO demand_terms (demand_id, duty_hours, age_limit, contract_period, medical, accommodation)
                 VALUES ($demand_id,'$duty_hours','$age_limit','$contract','$medical','$accommodation')");

    // Insert Footer
    $agency_name = $_POST['agency_name'];
    $address     = $_POST['address'];
    $phone       = $_POST['phone'];
    $email       = $_POST['email'];

    $agency_logo = $_FILES['agency_logo']['name'];
    if($agency_logo) move_uploaded_file($_FILES['agency_logo']['tmp_name'], "uploads/".$agency_logo);

    $con->query("INSERT INTO demand_footer (demand_id, agency_name, agency_logo, address, phone, email)
                 VALUES ($demand_id,'$agency_name','$agency_logo','$address','$phone','$email')");

    echo "<div class='alert alert-success mt-3'>? Demand Inserted Successfully 
          <a href='dgenerate_pdf.php?id=$demand_id' class='btn btn-sm btn-dark'>Download PDF</a></div>";
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Create Demand</title>
    <meta charset="UTF-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">

    <!-- Bootstrap Icons -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet">

    <style>
        body {
            background: linear-gradient(135deg, #6a11cb 0%, #2575fc 100%);
            min-height: 100vh;
            padding: 20px 10px;
        }
        .container {
            max-width: 960px;
            background: #fff;
            padding: 30px 35px;
            border-radius: 15px;
            box-shadow: 0 8px 24px rgba(0,0,0,0.15);
            position: relative;
        }
        h2 {
            text-align: center;
            margin-bottom: 30px;
            color: #212529;
            font-weight: 700;
            letter-spacing: 1.2px;
        }
        .form-section {
            background: #f7f9fc;
            padding: 25px 20px;
            border-radius: 12px;
            margin-bottom: 28px;
            border: 1px solid #e3e9f0;
        }
        .form-section h3 {
            font-size: 22px;
            margin-bottom: 18px;
            color: #3a3f51;
            font-weight: 600;
            border-bottom: 2px solid #2575fc;
            padding-bottom: 6px;
        }
        table th, table td {
            text-align: center;
            vertical-align: middle;
        }
        .btn-primary {
            width: 100%;
            padding: 14px;
            font-size: 18px;
            font-weight: 600;
            letter-spacing: 0.6px;
            border-radius: 8px;
            transition: background-color 0.3s ease;
        }
        .btn-primary:hover {
            background-color: #1a52d8;
        }
        .btn-sm {
            padding: 6px 12px;
            font-size: 14px;
            border-radius: 5px;
        }
        /* Input group icon styling */
        .input-group-text {
            background-color: #2575fc;
            color: #fff;
            border: none;
            border-top-left-radius: 6px;
            border-bottom-left-radius: 6px;
        }
        input.form-control, textarea.form-control {
            border-left: none;
        }
        /* Remove default file input style and add icon */
        input[type="file"] {
            padding-left: 40px !important;
        }
        input[type="file"]::before {
            content: "\f093"; /* Bootstrap icon unicode for image */
            font-family: "Bootstrap Icons";
            position: absolute;
            left: 15px;
            top: 10px;
            font-size: 18px;
            color: #2575fc;
        }
        /* Responsive tweaks */
        @media (max-width: 575.98px) {
            .form-section {
                padding: 20px 15px;
            }
            .btn-primary {
                font-size: 16px;
                padding: 12px;
            }
            table th, table td {
                font-size: 14px;
                padding: 10px 5px;
            }
            h2 {
                font-size: 26px;
            }
            .form-section h3 {
                font-size: 18px;
            }
        }
        /* Logout button top right */
        .logout-btn {
            position: absolute;
            top: 20px;
            right: 25px;
            font-weight: 600;
            border-radius: 8px;
            padding: 8px 16px;
        }
    </style>
</head>
<body>

<div class="container">
    <a href="logout.php" class="btn btn-outline-danger logout-btn">
        <i class="bi bi-box-arrow-right"></i> Logout
    </a>

    <h2><i class="bi bi-journal-plus"></i> Create New Demand</h2>

    <form method="post" enctype="multipart/form-data" novalidate>

        <!-- Header Info -->
        <div class="form-section">
            <h3><i class="bi bi-card-heading"></i> Header Info</h3>
            <div class="row g-3">
                <div class="col-md-6">
                    <label class="form-label" for="title">Title</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-pencil-square"></i></span>
                        <input type="text" id="title" name="title" class="form-control" placeholder="Enter Title" required>
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="company_name">Company Name</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-building"></i></span>
                        <input type="text" id="company_name" name="company_name" class="form-control" placeholder="Company Name">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="visa_type">Visa Type</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-card-checklist"></i></span>
                        <input type="text" id="visa_type" name="visa_type" class="form-control" placeholder="Visa Type">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="selection_type">Selection Type</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-check2-square"></i></span>
                        <input type="text" id="selection_type" name="selection_type" class="form-control" placeholder="Selection Type">
                    </div>
                </div>
                <div class="col-md-6 position-relative">
                    <label class="form-label" for="logo_left">Left Logo</label>
                    <input type="file" id="logo_left" name="logo_left" class="form-control" accept="image/*" />
                </div>
                <div class="col-md-6 position-relative">
                    <label class="form-label" for="logo_right">Right Logo</label>
                    <input type="file" id="logo_right" name="logo_right" class="form-control" accept="image/*" />
                </div>
            </div>
        </div>

        <!-- Trades -->
        <div class="form-section">
            <h3><i class="bi bi-briefcase"></i> Trades</h3>
            <div class="table-responsive">
                <table class="table table-bordered align-middle" id="tradesTable">
                    <thead class="table-light">
                        <tr>
                            <th><i class="bi bi-tools"></i> Trade</th>
                            <th><i class="bi bi-people-fill"></i> Qty</th>
                            <th><i class="bi bi-currency-dollar"></i> Salary</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td>
                                <input type="text" name="trade[]" class="form-control" placeholder="Trade">
                            </td>
                            <td>
                                <input type="number" name="qty[]" class="form-control" min="0" placeholder="Quantity">
                            </td>
                            <td>
                                <input type="text" name="salary[]" class="form-control" placeholder="Salary">
                            </td>
                            <td>
                                <button type="button" class="btn btn-sm btn-danger removeRow" title="Remove Row">
                                    <i class="bi bi-trash"></i>
                                </button>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
            <button type="button" class="btn btn-sm btn-success" id="addRow">
                <i class="bi bi-plus-circle"></i> Add Row
            </button>
        </div>

        <!-- Terms & Conditions -->
        <div class="form-section">
            <h3><i class="bi bi-file-earmark-text"></i> Terms & Conditions</h3>
            <div class="row g-3">
                <div class="col-md-6">
                    <label class="form-label" for="duty_hours">Duty Hours</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-clock"></i></span>
                        <input type="text" id="duty_hours" name="duty_hours" class="form-control" placeholder="Duty Hours">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="age_limit">Age Limit</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-person"></i></span>
                        <input type="text" id="age_limit" name="age_limit" class="form-control" placeholder="Age Limit">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="contract_period">Contract Period</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-calendar-event"></i></span>
                        <input type="text" id="contract_period" name="contract_period" class="form-control" placeholder="Contract Period">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="medical">Medical</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-heart-pulse"></i></span>
                        <input type="text" id="medical" name="medical" class="form-control" placeholder="Medical">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="accommodation">Accommodation</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-house-door"></i></span>
                        <input type="text" id="accommodation" name="accommodation" class="form-control" placeholder="Accommodation">
                    </div>
                </div>
            </div>
        </div>

        <!-- Footer (Agency Info) -->
        <div class="form-section">
            <h3><i class="bi bi-building"></i> Footer (Agency Info)</h3>
            <div class="row g-3">
                <div class="col-md-6">
                    <label class="form-label" for="agency_name">Agency Name</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-person-badge"></i></span>
                        <input type="text" id="agency_name" name="agency_name" class="form-control" placeholder="Agency Name">
                    </div>
                </div>
                <div class="col-md-6 position-relative">
                    <label class="form-label" for="agency_logo">Agency Logo</label>
                    <input type="file" id="agency_logo" name="agency_logo" class="form-control" accept="image/*" />
                </div>
                <div class="col-md-12">
                    <label class="form-label" for="address">Address</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-geo-alt"></i></span>
                        <textarea id="address" name="address" class="form-control" rows="2" placeholder="Address"></textarea>
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="phone">Phone</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-telephone"></i></span>
                        <input type="text" id="phone" name="phone" class="form-control" placeholder="Phone Number">
                    </div>
                </div>
                <div class="col-md-6">
                    <label class="form-label" for="email">Email</label>
                    <div class="input-group">
                        <span class="input-group-text"><i class="bi bi-envelope"></i></span>
                        <input type="email" id="email" name="email" class="form-control" placeholder="Email Address">
                    </div>
                </div>
            </div>
        </div>

        <button type="submit" class="btn btn-primary">
            <i class="bi bi-save2"></i> Save Demand
        </button>
    </form>
</div>

<!-- Bootstrap + JS -->
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<script>
    document.getElementById("addRow").addEventListener("click", function(){
        let table = document.querySelector("#tradesTable tbody");
        let newRow = document.createElement("tr");
        newRow.innerHTML = `
            <td><input type="text" name="trade[]" class="form-control" placeholder="Trade"></td>
            <td><input type="number" name="qty[]" class="form-control" min="0" placeholder="Quantity"></td>
            <td><input type="text" name="salary[]" class="form-control" placeholder="Salary"></td>
            <td><button type="button" class="btn btn-sm btn-danger removeRow" title="Remove Row"><i class="bi bi-trash"></i></button></td>
        `;
        table.appendChild(newRow);
    });

    document.addEventListener("click", function(e){
        if(e.target.closest(".removeRow")){
            e.target.closest("tr").remove();
        }
    });
</script>

</body>
</html>
