📁 File Manager
Editing:
/home/wvl7mof7402e/www/remindyourdata.live/admin/clientspayment.php
<?php session_start(); include "dbconnect.php"; // Database Connection if ($_SERVER["REQUEST_METHOD"] == "POST" && !isset($_SESSION['submitted'])) { $_SESSION['submitted'] = true; $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"> <title>Payment Registration</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- Bootstrap CSS + Icons --> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css"> <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet"> <style> body { font-family: 'Arial', sans-serif; background: linear-gradient(135deg, #e3f2fd, #ffffff); color: #333; } .container { margin-top: 60px; background: #fff; padding: 30px; border-radius: 12px; box-shadow: 0 0 25px rgba(0, 0, 0, 0.08); max-width: 850px; } h3 { color: #007bff; text-align: center; margin-bottom: 25px; font-weight: 600; } .form-control, .form-group select { font-size: 15px; padding: 12px; border-radius: 8px; margin-bottom: 15px; } .form-group label { font-weight: 600; color: #333; } .form-icon { margin-right: 8px; color: #007bff; } .btn-primary { font-size: 16px; padding: 12px; border-radius: 8px; width: 100%; } .btn-primary:hover { background-color: #0056b3; } .alert { margin-top: 20px; } #applicant_info { background-color: #f1f9ff; border-left: 4px solid #007bff; padding: 15px 20px; border-radius: 6px; } #installments_due_dates .form-group input[type="date"] { margin-bottom: 10px; } .logout-btn { position: fixed; top: 20px; right: 20px; background-color: #dc3545; color: white; padding: 10px 20px; border-radius: 30px; text-decoration: none; font-weight: bold; z-index: 1000; } .logout-btn:hover { background-color: #c82333; } @media (max-width: 768px) { .container { padding: 20px; margin-top: 40px; } } @media (max-width: 576px) { .form-control, .btn-primary { font-size: 14px; padding: 10px; } } </style> </head> <body> <a href="logout.php" class="logout-btn"><i class="bi bi-box-arrow-right"></i> Logout</a> <div class="container"> <h3><i class="bi bi-cash-coin"></i> Payment Registration</h3> <!-- Applicant Details --> <div id="applicant_info" class="mb-4"></div> <form method="POST"> <div class="form-group"> <label for="applicant_id"><i class="bi bi-person-badge-fill form-icon"></i>Select Applicant</label> <select name="applicant_id" id="applicant_id" class="form-control" required> <option value="">-- Select Applicant --</option> <?php $sql = "SELECT * FROM job_applicants"; $result = $con->query($sql); while ($row = $result->fetch_assoc()) { ?> <option value="<?= $row['id'] ?>" data-passport="<?= $row['passport_no'] ?>" data-reference="<?= $row['reference'] ?>" data-position="<?= $row['position'] ?>" data-job_country="<?= $row['job_country'] ?>"> <?= $row['name'] ?> (<?= $row['passport_no'] ?>) </option> <?php } ?> </select> </div> <div class="form-group"> <label for="payment_date"><i class="bi bi-calendar-check-fill form-icon"></i>Payment Date</label> <input type="date" name="payment_date" class="form-control" required> </div> <div class="form-group"> <label for="total_payment"><i class="bi bi-wallet-fill form-icon"></i>Total Payment</label> <input type="number" name="total_payment" class="form-control" required> </div> <div class="form-group"> <label for="paid_amount"><i class="bi bi-currency-rupee form-icon"></i>Paid Amount</label> <input type="number" name="paid_amount" class="form-control" required> </div> <div class="form-group"> <label for="payment_message"><i class="bi bi-chat-left-dots-fill form-icon"></i>Payment Message</label> <textarea name="payment_message" class="form-control" rows="3" required></textarea> </div> <div class="form-group"> <label for="installments"><i class="bi bi-list-ol form-icon"></i>Number of Installments</label> <select name="installments" id="installments" class="form-control" required> <option value="1">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"><i class="bi bi-check-circle-fill"></i> Save Payment Record</button> </div> </form> </div> <script> // Show applicant details on select document.getElementById("applicant_id").addEventListener("change", function () { const selected = this.options[this.selectedIndex]; const position = selected.getAttribute('data-position'); const jobCountry = selected.getAttribute('data-job_country'); const reference = selected.getAttribute('data-reference'); const html = ` <h5><strong><i class="bi bi-person-lines-fill"></i> Applicant Details</strong></h5> <p><strong>Position:</strong> ${position}</p> <p><strong>Job Country:</strong> ${jobCountry}</p> <p><strong>Reference (Agent):</strong> ${reference}</p> `; document.getElementById('applicant_info').innerHTML = html; }); // Generate dynamic installment due date inputs document.getElementById("installments").addEventListener("change", function () { const count = parseInt(this.value); const container = document.getElementById("installments_due_dates"); container.innerHTML = ""; for (let i = 1; i <= count; i++) { container.innerHTML += ` <div class="form-group"> <label for="installment_due_date_${i}"><i class="bi bi-calendar-range-fill form-icon"></i>Installment ${i} Due Date</label> <input type="date" name="installment_due_date_${i}" class="form-control" required> </div> `; } }); </script> </body> </html>
Save
Cancel