📁 File Manager
Editing:
/home/wvl7mof7402e/www/2vinternational.com/admin/demand.php
<?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>
Save
Cancel