📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/emply/clientspayment.php
<?php session_start(); include "dbconnect.php"; // Database Connection // Prevent double submission using session if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; // Get payment-related values from form $applicant_id = $_POST['applicant_id']; $total_payment = $_POST['total_payment']; $paid_amount = $_POST['paid_amount']; $payment_date = $_POST['payment_date']; $payment_message = $_POST['payment_message']; $installments = $_POST['installments']; $pending_amount = $total_payment - $paid_amount; $payment_time = date('Y-m-d H:i:s'); for ($i = 1; $i <= $installments; $i++) { $installment_due_date = $_POST['installment_due_date_' . $i]; $sql = "INSERT INTO clientspayment (applicant_id, total_payment, paid_amount, pending_amount, payment_date, payment_message, payment_time, installment_number, installment_due_date) VALUES ('$applicant_id', '$total_payment', '$paid_amount', '$pending_amount', '$payment_date', '$payment_message', '$payment_time', '$i', '$installment_due_date')"; if ($con->query($sql) !== TRUE) { echo "<script>alert('Error: " . $con->error . "');</script>"; } } echo "<script>alert('Payment Record Added Successfully');</script>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Payment Registration</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" /> <style> /* Background gradient and base font */ body { font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; background: linear-gradient(135deg, #a1c4fd 0%, #c2e9fb 100%); min-height: 100vh; margin: 0; padding: 0; color: #222; } .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #e63946; color: white; padding: 10px 22px; border-radius: 30px; font-weight: 600; text-decoration: none; box-shadow: 0 4px 10px rgba(230, 57, 70, 0.4); transition: background-color 0.3s ease; z-index: 1000; } .logout-btn:hover { background-color: #b71c1c; } .container { max-width: 720px; background: white; border-radius: 15px; padding: 40px 30px 50px; margin: 80px auto 60px; box-shadow: 0 12px 30px rgba(0, 0, 0, 0.12); transition: box-shadow 0.3s ease; } .container:hover { box-shadow: 0 18px 40px rgba(0, 0, 0, 0.18); } h3 { color: #1d3557; font-weight: 700; margin-bottom: 35px; text-align: center; letter-spacing: 1px; font-size: 2.25rem; } label { font-weight: 600; color: #457b9d; margin-bottom: 8px; display: block; } .form-control { border-radius: 10px !important; border: 1.8px solid #a8dadc !important; font-size: 1.05rem; padding: 12px 18px; transition: border-color 0.25s ease; box-shadow: none !important; } .form-control:focus { border-color: #1d3557 !important; box-shadow: 0 0 8px #1d3557aa !important; outline: none !important; } textarea.form-control { resize: vertical; min-height: 90px; } select.form-control { appearance: none; background: url("data:image/svg+xml;charset=US-ASCII,%3csvg width='16' height='16' fill='%234575b9' xmlns='http://www.w3.org/2000/svg'%3e%3cpath d='M4.646 6.646a.5.5 0 0 1 .708 0L8 9.293l2.646-2.647a.5.5 0 0 1 .708.708l-3 3a.5.5 0 0 1-.708 0l-3-3a.5.5 0 0 1 0-.708z'/%3e%3c/svg%3e") no-repeat right 12px center/16px 16px; padding-right: 40px; } .btn-primary { background: #457b9d; border: none; font-weight: 700; font-size: 1.15rem; border-radius: 12px; padding: 14px; width: 100%; margin-top: 25px; box-shadow: 0 5px 15px #457b9d99; transition: background 0.3s ease; } .btn-primary:hover { background: #1d3557; box-shadow: 0 7px 22px #1d355799; } #applicant_info { background: #e0f7fa; border-radius: 12px; padding: 20px 25px; margin-bottom: 30px; color: #006064; font-weight: 600; box-shadow: inset 0 0 15px #4dd0e1; } #applicant_info h5 { font-weight: 700; margin-bottom: 15px; } #installments_due_dates .form-group { margin-bottom: 18px; } /* Responsive tweaks */ @media (max-width: 576px) { .container { padding: 30px 20px 40px; margin: 60px 15px 40px; } h3 { font-size: 1.7rem; } label, .form-control { font-size: 1rem; } .btn-primary { font-size: 1.05rem; padding: 12px; } #applicant_info { font-size: 0.9rem; padding: 15px 18px; } } </style> </head> <body> <a href="logout.php" class="logout-btn">Logout</a> <div class="container shadow-sm"> <h3>Payment Registration Form</h3> <!-- Applicant details display --> <div id="applicant_info" class="mb-4"></div> <form method="POST" autocomplete="off" novalidate> <div class="form-group mb-3"> <label for="applicant_id">Select Applicant</label> <select name="applicant_id" id="applicant_id" class="form-control" required> <option value="" disabled selected>-- Select Applicant --</option> <?php $sql = "SELECT * FROM job_applicants"; $result = $con->query($sql); while ($row = $result->fetch_assoc()) { ?> <option value="<?= htmlspecialchars($row['id']) ?>" data-passport="<?= htmlspecialchars($row['passport_no']) ?>" data-reference="<?= htmlspecialchars($row['reference']) ?>" data-position="<?= htmlspecialchars($row['position']) ?>" data-job_country="<?= htmlspecialchars($row['job_country']) ?>"> <?= htmlspecialchars($row['name']) ?> (<?= htmlspecialchars($row['passport_no']) ?>) </option> <?php } ?> </select> </div> <div class="form-group mb-3"> <label for="payment_date">Payment Date</label> <input type="date" name="payment_date" id="payment_date" class="form-control" required /> </div> <div class="row g-3 mb-3"> <div class="col-12 col-md-6"> <label for="total_payment">Total Payment</label> <input type="number" min="0" step="0.01" name="total_payment" id="total_payment" class="form-control" required /> </div> <div class="col-12 col-md-6"> <label for="paid_amount">Paid Amount</label> <input type="number" min="0" step="0.01" name="paid_amount" id="paid_amount" class="form-control" required /> </div> </div> <div class="form-group mb-3"> <label for="payment_message">Payment Message</label> <textarea name="payment_message" id="payment_message" class="form-control" rows="3" required></textarea> </div> <div class="form-group mb-3"> <label for="installments">Number of Installments</label> <select name="installments" id="installments" class="form-control" required> <option value="1" selected>1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> </select> </div> <div id="installments_due_dates"></div> <div class="form-group text-center"> <button type="submit" class="btn btn-primary">Save Payment Record</button> </div> </form> </div> <script> document.getElementById("applicant_id").addEventListener("change", function () { const selectedOption = this.options[this.selectedIndex]; const position = selectedOption.getAttribute('data-position') || 'N/A'; const jobCountry = selectedOption.getAttribute('data-job_country') || 'N/A'; const reference = selectedOption.getAttribute('data-reference') || 'N/A'; document.getElementById('applicant_info').innerHTML = ` <h5>Applicant Details:</h5> <p><strong>Position:</strong> ${position}</p> <p><strong>Job Country:</strong> ${jobCountry}</p> <p><strong>Reference (Agent):</strong> ${reference}</p> `; }); document.getElementById("installments").addEventListener("change", function () { const installments = parseInt(this.value, 10); const container = document.getElementById("installments_due_dates"); container.innerHTML = ''; for (let i = 1; i <= installments; i++) { const div = document.createElement('div'); div.className = 'form-group mb-3'; div.innerHTML = ` <label for="installment_due_date_${i}">Installment ${i} Due Date</label> <input type="date" name="installment_due_date_${i}" id="installment_due_date_${i}" class="form-control" required /> `; container.appendChild(div); } }); // Trigger change event on page load to initialize installment dates field for default selection document.getElementById("installments").dispatchEvent(new Event('change')); </script> </body> </html>
Save
Cancel