📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/remindyourdata.live/emply/clientpaymentedit.php
<?php session_start(); include "dbconnect.php"; // Database Connection // Check if ID is provided in the URL if (isset($_GET['id'])) { $payment_id = (int)$_GET['id']; // Prepare SQL statement to avoid SQL injection $stmt = $con->prepare("SELECT cp.id, cp.applicant_id, cp.total_payment, cp.paid_amount, cp.pending_amount, cp.payment_date, cp.payment_message, cp.installment_number, cp.installment_due_date, ja.name, ja.passport_no, ja.position, ja.job_country, ja.reference FROM clientspayment cp JOIN job_applicants ja ON cp.applicant_id = ja.id WHERE cp.id = ?"); $stmt->bind_param("i", $payment_id); // "i" is for integer $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $payment = $result->fetch_assoc(); } else { echo "<script>alert('No payment record found!'); window.location.href = 'paymentclientlist.php';</script>"; exit; } } else { echo "<script>alert('No payment record found!'); window.location.href = 'paymentclientlist.php';</script>"; exit; } // Handle form submission for updating the payment record if ($_SERVER["REQUEST_METHOD"] == "POST") { $total_payment = $_POST['total_payment']; $paid_amount = $_POST['paid_amount']; $payment_date = $_POST['payment_date']; $payment_message = $_POST['payment_message']; $installments = $_POST['installments']; // Number of installments // Calculate pending amount $pending_amount = $total_payment - $paid_amount; // Update payment record in the database $stmt_update = $con->prepare("UPDATE clientspayment SET total_payment = ?, paid_amount = ?, pending_amount = ?, payment_date = ?, payment_message = ? WHERE id = ?"); $stmt_update->bind_param("ddddsi", $total_payment, $paid_amount, $pending_amount, $payment_date, $payment_message, $payment_id); if ($stmt_update->execute()) { // If installments are added, update the installment information if ($installments > 0) { for ($i = 1; $i <= $installments; $i++) { $installment_due_date = $_POST['installment_due_date_' . $i]; $stmt_installment = $con->prepare("UPDATE clientspayment SET installment_due_date = ? WHERE id = ? AND installment_number = ?"); $stmt_installment->bind_param("sii", $installment_due_date, $payment_id, $i); $stmt_installment->execute(); } } echo "<script>alert('Payment Record Updated Successfully'); window.location.href = 'paymentclientlist.php';</script>"; exit; } else { echo "<script>alert('Error: " . $con->error . "');</script>"; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <meta name="viewport" content="width=device-width, initial-scale=1" /> <title>Edit Payment Record</title> <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" /> <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.10.5/font/bootstrap-icons.css" rel="stylesheet" /> <style> body { background: #e9ecef; min-height: 100vh; display: flex; justify-content: center; align-items: flex-start; padding: 40px 15px; } .container { background: #ffffff; border-radius: 12px; padding: 30px 40px; box-shadow: 0 8px 25px rgba(0, 0, 0, 0.1); max-width: 650px; width: 100%; position: relative; } h3.text-primary { font-weight: 700; margin-bottom: 25px; text-align: center; color: #0d6efd; } .form-group { position: relative; margin-bottom: 20px; } .form-control { padding-left: 40px; border-radius: 10px; border: 1.5px solid #ced4da; font-size: 1rem; transition: border-color 0.3s ease; } .form-control:focus { border-color: #0d6efd; box-shadow: 0 0 8px rgba(13, 110, 253, 0.3); } label { font-weight: 600; margin-bottom: 8px; display: block; color: #495057; } .input-icon { position: absolute; left: 12px; top: 50%; transform: translateY(-50%); color: #6c757d; font-size: 1.3rem; pointer-events: none; } /* Logout button styling */ .logout-btn { position: absolute; top: 20px; right: 20px; font-weight: 600; padding: 8px 18px; font-size: 0.95rem; border-radius: 10px; transition: background-color 0.3s ease; } .logout-btn:hover { background-color: #dc3545; color: white; } /* Submit button */ button[type="submit"] { width: 100%; font-weight: 700; font-size: 1.1rem; border-radius: 12px; padding: 12px; transition: background-color 0.3s ease; } button[type="submit"]:hover { background-color: #0b5ed7; } </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> <h3 class="text-primary">Edit Payment Record</h3> <form method="POST" novalidate> <!-- Applicant Information (Read-Only) --> <div class="form-group"> <label>Applicant Name</label> <i class="bi bi-person-fill input-icon"></i> <input type="text" class="form-control" value="<?= htmlspecialchars($payment['name']) ?>" disabled> </div> <div class="form-group"> <label>Passport Number</label> <i class="bi bi-credit-card-2-front-fill input-icon"></i> <input type="text" class="form-control" value="<?= htmlspecialchars($payment['passport_no']) ?>" disabled> </div> <div class="form-group"> <label>Position</label> <i class="bi bi-briefcase-fill input-icon"></i> <input type="text" class="form-control" value="<?= htmlspecialchars($payment['position']) ?>" disabled> </div> <div class="form-group"> <label>Job Country</label> <i class="bi bi-geo-alt-fill input-icon"></i> <input type="text" class="form-control" value="<?= htmlspecialchars($payment['job_country']) ?>" disabled> </div> <div class="form-group"> <label>Reference (Agent)</label> <i class="bi bi-person-badge-fill input-icon"></i> <input type="text" class="form-control" value="<?= htmlspecialchars($payment['reference']) ?>" disabled> </div> <!-- Payment Information (Editable) --> <div class="form-group"> <label for="payment_date">Payment Date</label> <i class="bi bi-calendar-date input-icon"></i> <input type="date" name="payment_date" id="payment_date" class="form-control" value="<?= htmlspecialchars($payment['payment_date']) ?>" required> </div> <div class="form-group"> <label for="total_payment">Total Payment</label> <i class="bi bi-currency-dollar input-icon"></i> <input type="number" step="0.01" name="total_payment" id="total_payment" class="form-control" value="<?= htmlspecialchars($payment['total_payment']) ?>" min="0" required> </div> <div class="form-group"> <label for="paid_amount">Paid Amount</label> <i class="bi bi-wallet2 input-icon"></i> <input type="number" step="0.01" name="paid_amount" id="paid_amount" class="form-control" value="<?= htmlspecialchars($payment['paid_amount']) ?>" min="0" required> </div> <div class="form-group"> <label for="payment_message">Payment Message</label> <i class="bi bi-chat-left-text-fill input-icon"></i> <textarea name="payment_message" id="payment_message" class="form-control" rows="3" required><?= htmlspecialchars($payment['payment_message']) ?></textarea> </div> <div class="form-group"> <label for="installments">Number of Installments</label> <i class="bi bi-list-ol input-icon"></i> <select name="installments" id="installments" class="form-control" required> <option value="1" <?= ($payment['installment_number'] == 1) ? 'selected' : '' ?>>1</option> <option value="2" <?= ($payment['installment_number'] == 2) ? 'selected' : '' ?>>2</option> <option value="3" <?= ($payment['installment_number'] == 3) ? 'selected' : '' ?>>3</option> <option value="4" <?= ($payment['installment_number'] == 4) ? 'selected' : '' ?>>4</option> </select> </div> <!-- Dynamic fields for installment due dates --> <div id="installments_due_dates"></div> <div class="form-group mt-4 text-center"> <button type="submit" class="btn btn-primary"> <i class="bi bi-save2-fill"></i> Update Payment Record </button> </div> </form> </div> <script> // Display dynamic due date fields for installments const installmentsSelect = document.getElementById("installments"); const container = document.getElementById("installments_due_dates"); // Get pre-existing due date if available const existingDueDate = "<?= htmlspecialchars($payment['installment_due_date']) ?>"; function renderInstallmentFields() { const installments = parseInt(installmentsSelect.value, 10); container.innerHTML = ''; // Clear previous inputs for (let i = 1; i <= installments; i++) { // If you want, you can customize to have separate dates per installment if stored const inputHTML = ` <div class="form-group position-relative mb-3"> <label for="installment_due_date_${i}">Installment ${i} Due Date</label> <i class="bi bi-calendar3 input-icon"></i> <input type="date" name="installment_due_date_${i}" id="installment_due_date_${i}" class="form-control" value="${existingDueDate}" required> </div> `; container.insertAdjacentHTML('beforeend', inputHTML); } } installmentsSelect.addEventListener("change", renderInstallmentFields); // Initialize on page load renderInstallmentFields(); </script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script> </body> </html>
Save
Cancel