Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/finance

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: pay-emi.php

<?php
// pay-emi.php - FIXED VERSION: Interest-only works properly, Bill number saves correctly
// CHANGES: Removed automatic overdue calculation and made overdue charges optional
ini_set('display_errors', 0);
ini_set('log_errors', 1);
ini_set('error_log', '/home/u329947844/domains/hifi11.in/public_html/finance/error_log');
session_start();
include 'includes/db.php';
$fpdf_path = 'includes/fpdf.php';
if (file_exists($fpdf_path) && is_readable($fpdf_path)) {
    require_once $fpdf_path;
}
// Get EMI ID and Customer ID
$emi_id = $_POST['emi_id'] ?? $_GET['emi_id'] ?? 0;
$emi_id = intval($emi_id);
$customer_id = $_POST['customer_id'] ?? $_GET['customer_id'] ?? 0;
$customer_id = intval($customer_id);
if ($emi_id == 0 || $customer_id == 0) {
    $_SESSION['error'] = "Invalid EMI or Customer ID.";
    header("Location: manage-customers.php");
    exit;
}
// Fetch EMI with proper calculations
$sql = "SELECT
            e.id AS emi_id, e.customer_id, e.emi_amount, e.principal_amount, e.interest_amount,
            e.emi_due_date, e.status, e.overdue_charges, e.emi_bill_number, e.paid_date,
            COALESCE(e.principal_paid, 0) AS principal_paid,
            COALESCE(e.interest_paid, 0) AS interest_paid,
            c.customer_name, c.agreement_number, c.customer_number,
            (SELECT COUNT(*) FROM emi_schedule WHERE customer_id = c.id AND id <= e.id) AS emi_number
        FROM emi_schedule e
        JOIN customers c ON e.customer_id = c.id
        WHERE e.id = ? AND e.customer_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ii", $emi_id, $customer_id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows == 0) {
    $_SESSION['error'] = "EMI not found.";
    header("Location: emi-schedule.php?customer_id=$customer_id");
    exit;
}
$emi = $result->fetch_assoc();
$stmt->close();
// Calculate remaining amounts PROPERLY
$remaining_principal = max(0, $emi['principal_amount'] - $emi['principal_paid']);
$remaining_interest = max(0, $emi['interest_amount'] - $emi['interest_paid']);
$remaining_total = $remaining_principal + $remaining_interest;
// Calculate days overdue for display only (NOT for auto-payment)
$current_date = date('Y-m-d');
$display_days = 0;
$display_overdue = 0;
if ($emi['emi_due_date'] < $current_date && $emi['status'] !== 'paid') {
    $display_days = floor((strtotime($current_date) - strtotime($emi['emi_due_date'])) / 86400);
    $display_overdue = round(($emi['emi_amount'] / 1000) * 0 * max(0, $display_days), 2);
}
// Handle Payment
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $bill_number = trim($_POST['emi_bill_number'] ?? '');
    $paid_date = $_POST['paid_date'] ?? '';
    $pay_type = $_POST['pay_type'] ?? 'full';
    $custom_amount = floatval($_POST['custom_amount'] ?? 0);
    $customer_number = trim($_POST['customer_number'] ?? '');
    $overdue_input = floatval($_POST['overdue_charges'] ?? 0); // CHANGED: Default to 0, not auto-overdue
   
    // Debug logging
    error_log("Payment attempt - Type: $pay_type, Amount: $custom_amount, Bill: $bill_number");
    // Validation
    $errors = [];
    if (empty($bill_number)) {
        $errors[] = "Bill Number is required.";
    }
    if (empty($paid_date) || !strtotime($paid_date)) {
        $errors[] = "Valid Paid Date is required.";
    } elseif (strtotime($paid_date) > strtotime($current_date)) {
        $errors[] = "Paid Date cannot be in the future.";
    }
    if (empty($customer_number)) {
        $errors[] = "Customer number is required.";
    }
    if ($overdue_input < 0) {
        $errors[] = "Overdue charges cannot be negative.";
    }
    if (empty($errors)) {
        // Calculate payment amounts based on type - CORRECTED VERSION
        $principal_paid = $emi['principal_paid'];
        $interest_paid = $emi['interest_paid'];
        $payment_amount = $custom_amount > 0 ? $custom_amount : 0;
        // Determine maximum allowed based on payment type
        $max_allowed = 0;
        switch($pay_type) {
            case 'principal':
                $max_allowed = $remaining_principal;
                $payment_amount = $custom_amount > 0 ? min($custom_amount, $max_allowed) : $max_allowed;
                $principal_paid += $payment_amount;
                break;
               
            case 'interest':
                $max_allowed = $remaining_interest;
                $payment_amount = $custom_amount > 0 ? min($custom_amount, $max_allowed) : $max_allowed;
                $interest_paid += $payment_amount;
                break;
               
            case 'full':
            default:
                $max_allowed = $remaining_total;
                $payment_amount = $custom_amount > 0 ? min($custom_amount, $max_allowed) : $max_allowed;
               
                // For full payment, distribute to both principal and interest
                if ($remaining_total > 0) {
                    $principal_ratio = $remaining_principal / $remaining_total;
                    $interest_ratio = $remaining_interest / $remaining_total;
                   
                    $principal_paid += round($payment_amount * $principal_ratio, 2);
                    $interest_paid += round($payment_amount * $interest_ratio, 2);
                }
                break;
        }
        // Ensure we don't exceed the original amounts
        $principal_paid = min($principal_paid, $emi['principal_amount']);
        $interest_paid = min($interest_paid, $emi['interest_amount']);
        // Calculate actual payment made (may be less than requested due to rounding)
        $actual_principal_paid = $principal_paid - $emi['principal_paid'];
        $actual_interest_paid = $interest_paid - $emi['interest_paid'];
        $actual_payment_amount = $actual_principal_paid + $actual_interest_paid;
        // Debug logging
        error_log("Payment Details - Type: $pay_type, Requested: $payment_amount, Actual: $actual_payment_amount");
        error_log("Principal: {$emi['principal_paid']} + $actual_principal_paid = $principal_paid");
        error_log("Interest: {$emi['interest_paid']} + $actual_interest_paid = $interest_paid");
        if ($actual_payment_amount <= 0) {
            $errors[] = "Payment amount must be greater than zero.";
        } else {
            // Start transaction
            $conn->begin_transaction();
            try {
                // Determine status - check if FULLY paid or PARTIALLY paid
                $is_fully_paid = ($principal_paid >= $emi['principal_amount']) &&
                                ($interest_paid >= $emi['interest_amount']);
                               
                $is_partially_paid = ($principal_paid > $emi['principal_paid']) ||
                                    ($interest_paid > $emi['interest_paid']);
                if ($is_fully_paid) {
                    $status = 'paid';
                } elseif ($is_partially_paid) {
                    $status = 'partial'; // Add this status to handle partial payments
                } else {
                    $status = $emi['status']; // Keep existing status if no payment made
                }
                error_log("Updating EMI - Principal: $principal_paid, Interest: $interest_paid, Status: $status");
                // Update EMI record with new status
                $update_sql = "UPDATE emi_schedule
                               SET principal_paid = ?,
                                   interest_paid = ?,
                                   overdue_charges = ?,
                                   emi_bill_number = ?,
                                   paid_date = ?,
                                   status = ?
                               WHERE id = ? AND customer_id = ?";
                $stmt = $conn->prepare($update_sql);
                $stmt->bind_param("ddddssii",
                    $principal_paid,
                    $interest_paid,
                    $overdue_input,
                    $bill_number,
                    $paid_date,
                    $status,
                    $emi_id,
                    $customer_id
                );
               
                if (!$stmt->execute()) {
                    throw new Exception("Database update failed: " . $stmt->error);
                }
                $stmt->close();
               
                // Update total_balance table if needed - FIXED VERSION
                $total_paid = $actual_payment_amount + $overdue_input;
                $finance_id = $_SESSION['finance_id'] ?? 1; // Use 1 as default based on your data
                
                $balance_sql = "INSERT INTO total_balance
                                (transaction_type, amount, balance, description, transaction_date, finance_id)
                                VALUES ('emi_paid', ?,
                                COALESCE((SELECT balance FROM total_balance WHERE finance_id = ? ORDER BY id DESC LIMIT 1), 0) + ?,
                                'EMI Payment - Bill: $bill_number', ?, ?)";
                $stmt = $conn->prepare($balance_sql);
                $stmt->bind_param("dddsi", $total_paid, $finance_id, $total_paid, $paid_date, $finance_id);
                
                if (!$stmt->execute()) {
                    throw new Exception("Balance update failed: " . $stmt->error);
                }
                $stmt->close();
                
                $conn->commit();
               
                // Success message with detailed breakdown
                $success_message = "Payment recorded successfully! " .
                    "Bill: $bill_number, " .
                    "Amount: ₹" . number_format($actual_payment_amount, 2);
               
                if ($actual_principal_paid > 0) {
                    $success_message .= ", Principal: ₹" . number_format($actual_principal_paid, 2);
                }
                if ($actual_interest_paid > 0) {
                    $success_message .= ", Interest: ₹" . number_format($actual_interest_paid, 2);
                }
                if ($overdue_input > 0) {
                    $success_message .= ", Overdue: ₹" . number_format($overdue_input, 2);
                }
               
                $_SESSION['success'] = $success_message;
               
                // Redirect to EMI schedule
                header("Location: emi-schedule.php?customer_id=$customer_id");
                exit;
            } catch (Exception $e) {
                $conn->rollback();
                $errors[] = "Database error: " . $e->getMessage();
                error_log("Pay EMI error: " . $e->getMessage());
            }
        }
    }
   
    // If we have errors, store them in session and redirect back
    if (!empty($errors)) {
        $_SESSION['error'] = implode(" ", $errors);
        header("Location: pay-emi.php?emi_id=$emi_id&customer_id=$customer_id");
        exit;
    }
}
// PDF & WhatsApp Functions
function generateBillPDF($row, $filename) {
    if (!class_exists('FPDF')) return false;
    $pdf = new FPDF();
    $pdf->AddPage();
    $pdf->SetFont('Arial', 'B', 16);
    $pdf->Cell(0, 10, 'SRI Sabarivasa Finance', 0, 1, 'C');
    $pdf->SetFont('Arial', '', 10);
    $pdf->Cell(0, 5, 'EMI Payment Receipt', 0, 1, 'C');
    $pdf->Ln(5);
    $pdf->Cell(0, 7, "Customer: " . htmlspecialchars($row['customer_name']), 0, 1);
    $pdf->Cell(0, 7, "Agreement: " . $row['agreement_number'], 0, 1);
    $pdf->Cell(0, 7, "EMI #: " . $row['emi_number'], 0, 1);
    $pdf->Cell(0, 7, "Bill No: " . ($row['emi_bill_number'] ?? '-'), 0, 1);
    if ($row['principal_paid'] > 0) $pdf->Cell(0, 7, "Principal Paid: ₹" . number_format($row['principal_paid'], 2), 0, 1);
    if ($row['interest_paid'] > 0) $pdf->Cell(0, 7, "Interest Paid: ₹" . number_format($row['interest_paid'], 2), 0, 1);
    if ($row['overdue_charges'] > 0) $pdf->Cell(0, 7, "Overdue Paid: ₹" . number_format($row['overdue_charges'], 2), 0, 1);
    $total = $row['principal_paid'] + $row['interest_paid'] + $row['overdue_charges'];
    $pdf->Cell(0, 7, "Total Paid: ₹" . number_format($total, 2), 0, 1);
    $pdf->Cell(0, 7, "Paid On: " . date('d M Y', strtotime($row['paid_date'] ?? date('Y-m-d'))), 0, 1);
    @mkdir(dirname($filename), 0755, true);
    try {
        $pdf->Output('F', $filename);
        return true;
    } catch (Exception $e) {
        error_log("PDF Error: " . $e->getMessage());
        return false;
    }
}
function generateWhatsAppMessageWithPDF($row, $is_paid, $pdf_url = '') {
    $message = "Dear " . htmlspecialchars($row['customer_name']) . ",\n\n";
    $message .= "Payment Received!\n";
    $message .= "Agreement: " . $row['agreement_number'] . "\n";
    $message .= "EMI #: " . $row['emi_number'] . "\n";
    $message .= "Bill No: " . ($row['emi_bill_number'] ?? '-') . "\n";
    if ($row['principal_paid'] > 0) $message .= "Principal Paid: ₹" . number_format($row['principal_paid'], 2) . "\n";
    if ($row['interest_paid'] > 0) $message .= "Interest Paid: ₹" . number_format($row['interest_paid'], 2) . "\n";
    if ($row['overdue_charges'] > 0) $message .= "Overdue: ₹" . number_format($row['overdue_charges'], 2) . "\n";
    $total = $row['principal_paid'] + $row['interest_paid'] + $row['overdue_charges'];
    $message .= "Total Paid: ₹" . number_format($total, 2) . "\n";
    $message .= "Date: " . date('d M Y', strtotime($row['paid_date'])) . "\n";
    if ($pdf_url) $message .= "Receipt: $pdf_url\n";
    $message .= "\nThank you!\nSRI Sabarivasa Finance | 9500595040";
    return urlencode($message);
}
?>
<!DOCTYPE html>
<html lang="en">
<?php include 'includes/head.php'; ?>
<body>
  <?php include 'includes/topbar.php'; ?>
  <div class="startbar d-print-none">
    <?php include 'includes/leftbar.php'; ?>
    <div class="startbar-overlay d-print-none"></div>
    <div class="page-wrapper">
      <div class="page-content">
        <div class="container-fluid">
          <?php
          $page_title = "Pay EMI";
          $breadcrumb_active = "Pay EMI #{$emi['emi_number']} - " . htmlspecialchars($emi['customer_name']);
          include 'includes/breadcrumb.php';
          ?>
         
          
          <?php if (isset($_SESSION['success'])): ?>
            <div class="alert alert-success alert-dismissible fade show">
              <strong>Success!</strong> <?php echo $_SESSION['success']; unset($_SESSION['success']); ?>
              <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            </div>
          <?php endif; ?>
          <?php if (isset($_SESSION['error'])): ?>
            <div class="alert alert-danger alert-dismissible fade show">
              <strong>Error!</strong> <?php echo $_SESSION['error']; unset($_SESSION['error']); ?>
              <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
            </div>
          <?php endif; ?>
         
          
          <div class="row mb-3">
            <div class="col">
              <h3>Pay EMI #<?php echo $emi['emi_number']; ?> – <?php echo htmlspecialchars($emi['customer_name']); ?></h3>
              <small class="text-muted">
                Agreement: <?php echo $emi['agreement_number']; ?> |
                Due: <?php echo date('d-m-Y', strtotime($emi['emi_due_date'])); ?> |
                Current Status: <span class="badge bg-<?php
                    echo $emi['status'] === 'paid' ? 'success' :
                         ($emi['status'] === 'partial' ? 'info' : 'warning');
                ?>">
                  <?php echo ucfirst($emi['status']); ?>
                </span>
              </small>
            </div>
            <div class="col-auto">
              <a href="emi-schedule.php?customer_id=<?php echo $customer_id; ?>" class="btn btn-light">Back to Schedule</a>
            </div>
          </div>
         
          
          <div class="card">
            <div class="card-header">
              <h5 class="mb-0">Payment Details</h5>
            </div>
            <div class="card-body">
              <form method="POST" novalidate>
                <input type="hidden" name="emi_id" value="<?php echo $emi_id; ?>">
                <input type="hidden" name="customer_id" value="<?php echo $customer_id; ?>">
               
                
                <div class="row mb-4">
                  <div class="col-md-4">
                    <div class="card bg-light">
                      <div class="card-body text-center">
                        <h6>Principal</h6>
                        <div class="h5 text-primary">₹<?php echo number_format($emi['principal_paid'], 2); ?> / ₹<?php echo number_format($emi['principal_amount'], 2); ?></div>
                        <small>Remaining: ₹<?php echo number_format($remaining_principal, 2); ?></small>
                      </div>
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="card bg-light">
                      <div class="card-body text-center">
                        <h6>Interest</h6>
                        <div class="h5 text-warning">₹<?php echo number_format($emi['interest_paid'], 2); ?> / ₹<?php echo number_format($emi['interest_amount'], 2); ?></div>
                        <small>Remaining: ₹<?php echo number_format($remaining_interest, 2); ?></small>
                      </div>
                    </div>
                  </div>
                  <div class="col-md-4">
                    <div class="card bg-light">
                      <div class="card-body text-center">
                        <h6>Total</h6>
                        <div class="h5 text-success">₹<?php echo number_format($emi['principal_paid'] + $emi['interest_paid'], 2); ?> / ₹<?php echo number_format($emi['emi_amount'], 2); ?></div>
                        <small>Remaining: ₹<?php echo number_format($remaining_total, 2); ?></small>
                      </div>
                    </div>
                  </div>
                </div>
               
                <div class="row g-3">
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Payment Type <span class="text-danger">*</span></label>
                    <select class="form-select" id="payType" name="pay_type" required>
                      <option value="full" <?php echo ($_POST['pay_type'] ?? 'full') === 'full' ? 'selected' : ''; ?>>Full Payment (₹<?php echo number_format($remaining_total, 2); ?>)</option>
                      <option value="principal" <?php echo ($_POST['pay_type'] ?? '') === 'principal' ? 'selected' : ''; ?>>Principal Only (₹<?php echo number_format($remaining_principal, 2); ?>)</option>
                      <option value="interest" <?php echo ($_POST['pay_type'] ?? '') === 'interest' ? 'selected' : ''; ?>>Interest Only (₹<?php echo number_format($remaining_interest, 2); ?>)</option>
                    </select>
                  </div>
                 
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Amount to Pay (₹) <span class="text-danger">*</span></label>
                    <input type="number" step="0.01" class="form-control" name="custom_amount" id="customAmount"
                           value="<?php echo $_POST['custom_amount'] ?? $remaining_total; ?>" min="0.01" max="<?php echo $remaining_total; ?>" required>
                    <small class="text-muted" id="amountHelp">Max: ₹<?php echo number_format($remaining_total, 2); ?></small>
                  </div>
                 
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Bill Number <span class="text-danger">*</span></label>
                    <input type="text" class="form-control" name="emi_bill_number"
                           value="<?php echo htmlspecialchars($_POST['emi_bill_number'] ?? ''); ?>"
                           placeholder="Enter bill number" required>
                  </div>
                 
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Paid Date <span class="text-danger">*</span></label>
                    <input type="date" class="form-control" name="paid_date"
                           value="<?php echo $_POST['paid_date'] ?? $current_date; ?>"
                           max="<?php echo $current_date; ?>" required>
                  </div>
                 
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Customer Number <span class="text-danger">*</span></label>
                    <input type="text" class="form-control" name="customer_number"
                           value="<?php echo htmlspecialchars($_POST['customer_number'] ?? $emi['customer_number']); ?>"
                           required>
                  </div>
                 
                  
                  <div class="col-md-6">
                    <label class="form-label fw-bold">Overdue Charges (₹) <small class="text-muted">(Optional)</small></label>
                    <input type="number" step="0.01" min="0" class="form-control" name="overdue_charges"
                           value="<?php echo $_POST['overdue_charges'] ?? 0; ?>">
                    <small class="text-muted">Enter overdue charges if applicable</small>
                  </div>
                </div>
               
                
                <?php if ($display_overdue > 0): ?>
                <div class="alert alert-warning mt-3">
                  <h6><i class="fas fa-clock"></i> Overdue Information</h6>
                  <p>
                    This EMI is <strong><?php echo $display_days; ?> days</strong> overdue.<br>
                    Calculated overdue charges: <strong>₹<?php echo number_format($display_overdue, 2); ?></strong><br>
                    <small class="text-muted">Formula: (₹<?php echo number_format($emi['emi_amount'], 2); ?> ÷ 1000) × 2 × <?php echo $display_days; ?> days</small>
                  </p>
                  <p class="mb-0">
                    <small>You can choose to add overdue charges in the field above if applicable.</small>
                  </p>
                </div>
                <?php endif; ?>
               
                
                <div class="alert alert-info mt-3">
                  <h6 class="alert-heading">Payment Summary:</h6>
                  <div id="paymentSummary">
                    <div>Payment Type: <strong id="summaryType">Full Payment</strong></div>
                    <div>Amount: <strong id="summaryAmount">₹<?php echo number_format($remaining_total, 2); ?></strong></div>
                    <div>This payment will be applied to: <strong id="summaryBreakdown">Principal + Interest</strong></div>
                  </div>
                </div>
               
                
                <div class="mt-4 d-flex gap-2 justify-content-end">
                  <button type="submit" class="btn btn-success btn-lg">Process Payment</button>
                  <a href="emi-schedule.php?customer_id=<?php echo $customer_id; ?>" class="btn btn-light btn-lg">Cancel</a>
                </div>
              </form>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
 
  <?php include 'includes/scripts.php'; ?>
 
  <script>
  document.addEventListener('DOMContentLoaded', function() {
    const payType = document.getElementById('payType');
    const customAmount = document.getElementById('customAmount');
    const amountHelp = document.getElementById('amountHelp');
    const summaryType = document.getElementById('summaryType');
    const summaryAmount = document.getElementById('summaryAmount');
    const summaryBreakdown = document.getElementById('summaryBreakdown');
   
    const limits = {
      principal: <?php echo $remaining_principal; ?>,
      interest: <?php echo $remaining_interest; ?>,
      full: <?php echo $remaining_total; ?>
    };
   
    const paymentTypes = {
      principal: 'Principal Only',
      interest: 'Interest Only',
      full: 'Full Payment'
    };
   
    const breakdowns = {
      principal: 'Principal only',
      interest: 'Interest only',
      full: 'Principal + Interest'
    };
   
    function updateAmountLimit() {
      const selectedType = payType.value;
      const maxAmount = limits[selectedType];
     
      // Update input attributes
      customAmount.max = maxAmount;
      customAmount.value = maxAmount.toFixed(2);
     
      // Update help text
      amountHelp.textContent = `Max: ₹${maxAmount.toFixed(2)}`;
     
      // Update summary
      summaryType.textContent = paymentTypes[selectedType];
      summaryAmount.textContent = `₹${maxAmount.toFixed(2)}`;
      summaryBreakdown.textContent = breakdowns[selectedType];
     
      // Validate current value
      const currentValue = parseFloat(customAmount.value) || 0;
      if (currentValue > maxAmount) {
        customAmount.value = maxAmount.toFixed(2);
      }
    }
   
    function updateSummary() {
      const selectedType = payType.value;
      const amount = parseFloat(customAmount.value) || 0;
      const maxAmount = limits[selectedType];
      const actualAmount = Math.min(amount, maxAmount);
     
      summaryType.textContent = paymentTypes[selectedType];
      summaryAmount.textContent = `₹${actualAmount.toFixed(2)}`;
      summaryBreakdown.textContent = breakdowns[selectedType];
    }
   
    // Event listeners
    payType.addEventListener('change', updateAmountLimit);
    customAmount.addEventListener('input', function() {
      const selectedType = payType.value;
      const maxAmount = limits[selectedType];
      const currentValue = parseFloat(this.value) || 0;
     
      if (currentValue > maxAmount) {
        this.value = maxAmount.toFixed(2);
      }
      updateSummary();
    });
   
    // Initialize
    updateAmountLimit();
    updateSummary();
  });
  </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: pay-emi.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation