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/ecommer.in/public_html/billing/poorva

Free Space:

10.01 TB

🔧 Quick Actions

✏️ Editing: credit-payments.php

<?php
session_start();
include('includes/db.php');

// Ensure branch login
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

$branch_id = intval($_SESSION['branch_id']);

// Get branch info
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = $branch_id LIMIT 1";
$branch_result = $conn->query($branch_sql);
$branch_info = $branch_result ? $branch_result->fetch_assoc() : ['branch_name' => 'Unknown', 'branch_code' => 'N/A'];

// Helper function to check if column exists
function columnExists($conn, $table, $column) {
    $table_safe = $conn->real_escape_string($table);
    $column_safe = $conn->real_escape_string($column);
    $res = $conn->query("SHOW COLUMNS FROM `{$table_safe}` LIKE '{$column_safe}'");
    return ($res && $res->num_rows > 0);
}

// Check if credit_payments has branch_id column
$credit_has_branch = columnExists($conn, 'credit_payments', 'branch_id');

// Handle actions
$alert_message = '';
$action = $_GET['action'] ?? '';
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$customer_id = isset($_GET['customer_id']) ? intval($_GET['customer_id']) : 0;

// Handle payment submission
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['add_payment'])) {
    $credit_id = intval($_POST['credit_id']);
    $amount_paid = floatval($_POST['amount_paid']);
    $payment_method = $conn->real_escape_string($_POST['payment_method']);
    $payment_date = $conn->real_escape_string($_POST['payment_date']);
    $reference_number = $conn->real_escape_string($_POST['reference_number'] ?? '');
    $notes = $conn->real_escape_string($_POST['notes'] ?? '');
    
    $conn->begin_transaction();
    
    try {
        // Get credit payment details
        $credit_sql = "SELECT * FROM credit_payments WHERE id = $credit_id";
        if ($credit_has_branch) {
            $credit_sql .= " AND branch_id = $branch_id";
        }
        $credit_result = $conn->query($credit_sql);
        
        if (!$credit_result || $credit_result->num_rows == 0) {
            throw new Exception("Credit payment not found or doesn't belong to your branch.");
        }
        
        $credit = $credit_result->fetch_assoc();
        $remaining = floatval($credit['remaining_amount']);
        $sale_id = intval($credit['sale_id']);
        $customer_id = intval($credit['customer_id']);
        
        if ($amount_paid > $remaining) {
            throw new Exception("Payment amount (₹{$amount_paid}) exceeds remaining amount (₹{$remaining}).");
        }
        
        // Insert transaction
        $transaction_has_branch = columnExists($conn, 'credit_payment_transactions', 'branch_id');
        
        if ($transaction_has_branch) {
            $trans_sql = "INSERT INTO credit_payment_transactions (
                credit_payment_id, customer_id, amount_paid, payment_method, payment_date, 
                reference_number, notes, branch_id, created_at
            ) VALUES (
                $credit_id, $customer_id, $amount_paid, '$payment_method', '$payment_date',
                '$reference_number', '$notes', $branch_id, NOW()
            )";
        } else {
            $trans_sql = "INSERT INTO credit_payment_transactions (
                credit_payment_id, customer_id, amount_paid, payment_method, payment_date, 
                reference_number, notes, created_at
            ) VALUES (
                $credit_id, $customer_id, $amount_paid, '$payment_method', '$payment_date',
                '$reference_number', '$notes', NOW()
            )";
        }
        
        if (!$conn->query($trans_sql)) {
            throw new Exception("Failed to record transaction: " . $conn->error);
        }
        
        // Update credit payment
        $new_remaining = $remaining - $amount_paid;
        $status = ($new_remaining <= 0) ? 'paid' : 'partial';
        
        $update_sql = "UPDATE credit_payments SET 
            paid_amount = paid_amount + $amount_paid,
            remaining_amount = $new_remaining,
            status = '$status',
            updated_at = NOW()
            WHERE id = $credit_id";
        
        if (!$conn->query($update_sql)) {
            throw new Exception("Failed to update credit payment: " . $conn->error);
        }
        
        // Update sale if fully paid
        if ($status == 'paid') {
            $sale_sql = "UPDATE sales SET 
                payment_status = 'paid',
                paid_amount = total_amount,
                due_amount = 0,
                updated_at = NOW()
                WHERE id = $sale_id";
            
            if (!$conn->query($sale_sql)) {
                throw new Exception("Failed to update sale: " . $conn->error);
            }
        }
        
        // Update customer stats
        $customer_has_branch = columnExists($conn, 'customers', 'branch_id');
        if ($customer_has_branch) {
            $customer_sql = "UPDATE customers SET 
                total_paid = COALESCE(total_paid,0) + $amount_paid,
                outstanding_balance = COALESCE(outstanding_balance,0) - $amount_paid,
                updated_at = NOW()
                WHERE id = $customer_id AND branch_id = $branch_id";
        } else {
            $customer_sql = "UPDATE customers SET 
                total_paid = COALESCE(total_paid,0) + $amount_paid,
                outstanding_balance = COALESCE(outstanding_balance,0) - $amount_paid,
                updated_at = NOW()
                WHERE id = $customer_id";
        }
        
        if (!$conn->query($customer_sql)) {
            throw new Exception("Failed to update customer: " . $conn->error);
        }
        
        $conn->commit();
        
        $alert_message = '<div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle me-2"></i>
                <strong>Payment Recorded Successfully!</strong><br>
                Amount: ₹' . number_format($amount_paid, 2) . '<br>
                Remaining Balance: ₹' . number_format($new_remaining, 2) . '
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>';
            
    } catch (Exception $e) {
        $conn->rollback();
        $alert_message = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle me-2"></i>
                Error: ' . htmlspecialchars($e->getMessage()) . '
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>';
    }
}

// Handle mark as paid
if ($action == 'mark_paid' && $id > 0) {
    $conn->begin_transaction();
    
    try {
        // Get credit payment details
        $credit_sql = "SELECT * FROM credit_payments WHERE id = $id";
        if ($credit_has_branch) {
            $credit_sql .= " AND branch_id = $branch_id";
        }
        $credit_result = $conn->query($credit_sql);
        
        if (!$credit_result || $credit_result->num_rows == 0) {
            throw new Exception("Credit payment not found or doesn't belong to your branch.");
        }
        
        $credit = $credit_result->fetch_assoc();
        $remaining = floatval($credit['remaining_amount']);
        $sale_id = intval($credit['sale_id']);
        $customer_id = intval($credit['customer_id']);
        
        if ($remaining > 0) {
            // Insert transaction for remaining amount
            $transaction_has_branch = columnExists($conn, 'credit_payment_transactions', 'branch_id');
            
            if ($transaction_has_branch) {
                $trans_sql = "INSERT INTO credit_payment_transactions (
                    credit_payment_id, customer_id, amount_paid, payment_method, payment_date, 
                    reference_number, notes, branch_id, created_at
                ) VALUES (
                    $id, $customer_id, $remaining, 'cash', NOW(),
                    'MANUAL_PAID', 'Marked as paid manually', $branch_id, NOW()
                )";
            } else {
                $trans_sql = "INSERT INTO credit_payment_transactions (
                    credit_payment_id, customer_id, amount_paid, payment_method, payment_date, 
                    reference_number, notes, created_at
                ) VALUES (
                    $id, $customer_id, $remaining, 'cash', NOW(),
                    'MANUAL_PAID', 'Marked as paid manually', NOW()
                )";
            }
            
            if (!$conn->query($trans_sql)) {
                throw new Exception("Failed to record transaction: " . $conn->error);
            }
            
            // Update credit payment
            $update_sql = "UPDATE credit_payments SET 
                paid_amount = paid_amount + $remaining,
                remaining_amount = 0,
                status = 'paid',
                updated_at = NOW()
                WHERE id = $id";
            
            if (!$conn->query($update_sql)) {
                throw new Exception("Failed to update credit payment: " . $conn->error);
            }
            
            // Update sale
            $sale_sql = "UPDATE sales SET 
                payment_status = 'paid',
                paid_amount = total_amount,
                due_amount = 0,
                updated_at = NOW()
                WHERE id = $sale_id";
            
            if (!$conn->query($sale_sql)) {
                throw new Exception("Failed to update sale: " . $conn->error);
            }
            
            // Update customer stats
            $customer_has_branch = columnExists($conn, 'customers', 'branch_id');
            if ($customer_has_branch) {
                $customer_sql = "UPDATE customers SET 
                    total_paid = COALESCE(total_paid,0) + $remaining,
                    outstanding_balance = COALESCE(outstanding_balance,0) - $remaining,
                    updated_at = NOW()
                    WHERE id = $customer_id AND branch_id = $branch_id";
            } else {
                $customer_sql = "UPDATE customers SET 
                    total_paid = COALESCE(total_paid,0) + $remaining,
                    outstanding_balance = COALESCE(outstanding_balance,0) - $remaining,
                    updated_at = NOW()
                    WHERE id = $customer_id";
            }
            
            if (!$conn->query($customer_sql)) {
                throw new Exception("Failed to update customer: " . $conn->error);
            }
        }
        
        $conn->commit();
        
        $alert_message = '<div class="alert alert-success alert-dismissible fade show" role="alert">
                <i class="fas fa-check-circle me-2"></i>
                <strong>Credit marked as fully paid!</strong>
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>';
            
    } catch (Exception $e) {
        $conn->rollback();
        $alert_message = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                <i class="fas fa-exclamation-triangle me-2"></i>
                Error: ' . htmlspecialchars($e->getMessage()) . '
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>';
    }
}

// Handle delete transaction
if ($action == 'delete_transaction' && $id > 0) {
    // First get transaction details
    $trans_sql = "SELECT t.*, cp.remaining_amount, cp.customer_id, cp.sale_id 
                 FROM credit_payment_transactions t
                 JOIN credit_payments cp ON t.credit_payment_id = cp.id
                 WHERE t.id = $id";
    
    if ($credit_has_branch) {
        $trans_sql .= " AND cp.branch_id = $branch_id";
    }
    
    $trans_result = $conn->query($trans_sql);
    
    if ($trans_result && $trans_result->num_rows > 0) {
        $transaction = $trans_result->fetch_assoc();
        $amount_paid = floatval($transaction['amount_paid']);
        $credit_id = intval($transaction['credit_payment_id']);
        $customer_id = intval($transaction['customer_id']);
        $sale_id = intval($transaction['sale_id']);
        
        $conn->begin_transaction();
        
        try {
            // Delete transaction
            $delete_sql = "DELETE FROM credit_payment_transactions WHERE id = $id";
            if (!$conn->query($delete_sql)) {
                throw new Exception("Failed to delete transaction: " . $conn->error);
            }
            
            // Update credit payment
            $update_sql = "UPDATE credit_payments SET 
                paid_amount = paid_amount - $amount_paid,
                remaining_amount = remaining_amount + $amount_paid,
                status = CASE WHEN (remaining_amount + $amount_paid) > 0 THEN 'partial' ELSE 'paid' END,
                updated_at = NOW()
                WHERE id = $credit_id";
            
            if (!$conn->query($update_sql)) {
                throw new Exception("Failed to update credit payment: " . $conn->error);
            }
            
            // Update sale if needed
            $sale_sql = "UPDATE sales SET 
                payment_status = CASE WHEN due_amount + $amount_paid > 0 THEN 'partial' ELSE 'paid' END,
                paid_amount = paid_amount - $amount_paid,
                due_amount = due_amount + $amount_paid,
                updated_at = NOW()
                WHERE id = $sale_id";
            
            if (!$conn->query($sale_sql)) {
                throw new Exception("Failed to update sale: " . $conn->error);
            }
            
            // Update customer stats
            $customer_has_branch = columnExists($conn, 'customers', 'branch_id');
            if ($customer_has_branch) {
                $customer_sql = "UPDATE customers SET 
                    total_paid = COALESCE(total_paid,0) - $amount_paid,
                    outstanding_balance = COALESCE(outstanding_balance,0) + $amount_paid,
                    updated_at = NOW()
                    WHERE id = $customer_id AND branch_id = $branch_id";
            } else {
                $customer_sql = "UPDATE customers SET 
                    total_paid = COALESCE(total_paid,0) - $amount_paid,
                    outstanding_balance = COALESCE(outstanding_balance,0) + $amount_paid,
                    updated_at = NOW()
                    WHERE id = $customer_id";
            }
            
            if (!$conn->query($customer_sql)) {
                throw new Exception("Failed to update customer: " . $conn->error);
            }
            
            $conn->commit();
            
            $alert_message = '<div class="alert alert-success alert-dismissible fade show" role="alert">
                    <i class="fas fa-check-circle me-2"></i>
                    <strong>Transaction deleted successfully!</strong>
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>';
                
        } catch (Exception $e) {
            $conn->rollback();
            $alert_message = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <i class="fas fa-exclamation-triangle me-2"></i>
                    Error: ' . htmlspecialchars($e->getMessage()) . '
                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                </div>';
        }
    }
}

// Get customer name if customer_id is provided
$customer_name = '';
if ($customer_id > 0) {
    $cust_sql = "SELECT customer_name FROM customers WHERE id = $customer_id";
    $cust_result = $conn->query($cust_sql);
    if ($cust_result && $cust_result->num_rows > 0) {
        $customer = $cust_result->fetch_assoc();
        $customer_name = $customer['customer_name'];
    }
}

// Get credit summary stats for the branch
$stats_sql = "SELECT 
    COUNT(*) as total_credits,
    SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending_credits,
    SUM(CASE WHEN status = 'partial' THEN 1 ELSE 0 END) as partial_credits,
    SUM(CASE WHEN status = 'paid' THEN 1 ELSE 0 END) as paid_credits,
    SUM(due_amount) as total_due,
    SUM(remaining_amount) as total_remaining,
    SUM(paid_amount) as total_paid
    FROM credit_payments";
    
if ($credit_has_branch) {
    $stats_sql .= " WHERE branch_id = $branch_id";
}

$stats_result = $conn->query($stats_sql);
$stats = $stats_result ? $stats_result->fetch_assoc() : [];
?>
<!doctype html>
<html lang="en">
<head>
    <?php include('includes/head.php'); ?>
    <title>Credit Payments | <?php echo htmlspecialchars($branch_info['branch_name']); ?></title>
    <style>
        .branch-badge { font-size: 0.7rem; margin-left: 5px; }
        .branch-info { background: linear-gradient(135deg, #667eea 0%, #764ba2 100%); color: white; border-radius: 10px; padding: 20px; margin-bottom: 25px; box-shadow: 0 4px 15px rgba(0,0,0,0.1); }
        .stat-card { border-radius: 10px; padding: 20px; margin-bottom: 20px; color: white; }
        .stat-card.pending { background: linear-gradient(135deg, #ff6b6b 0%, #ee5a52 100%); }
        .stat-card.partial { background: linear-gradient(135deg, #ffa726 0%, #f57c00 100%); }
        .stat-card.paid { background: linear-gradient(135deg, #66bb6a 0%, #43a047 100%); }
        .stat-card.total { background: linear-gradient(135deg, #5c6bc0 0%, #3949ab 100%); }
        .stat-icon { font-size: 2.5rem; opacity: 0.8; }
        .stat-value { font-size: 1.8rem; font-weight: bold; }
        .stat-label { font-size: 0.9rem; opacity: 0.9; }
        .status-badge { font-size: 0.75rem; padding: 4px 8px; }
        .overdue { color: #dc3545; font-weight: bold; }
        .due-soon { color: #fd7e14; font-weight: bold; }
        .amount-cell { font-weight: bold; }
        .amount-positive { color: #198754; }
        .amount-negative { color: #dc3545; }
        .customer-card { background: #f8f9fa; border-radius: 8px; padding: 15px; margin-bottom: 20px; border-left: 4px solid #0d6efd; }
        .filter-badge { cursor: pointer; }
        .filter-badge.active { background-color: #0d6efd !important; }
    </style>
</head>
<body data-sidebar="dark">

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">
<?php include('includes/topbar.php')?>    
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php')?>
        </div>
    </div>

<div class="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-credit-card me-2"></i>
                                Credit Payments Management
                                <span class="badge bg-light text-dark"><?php echo htmlspecialchars($branch_info['branch_code']); ?></span>
                            </h4>
                            <p class="mb-0"><i class="fas fa-building me-1"></i><?php echo htmlspecialchars($branch_info['branch_name']); ?></p>
                        </div>
                        <div class="col-md-4 text-end">
                            <span class="badge bg-white text-primary px-3 py-2">
                                <i class="fas fa-money-bill-wave me-1"></i>Manage Credit Payments
                            </span>
                        </div>
                    </div>
                </div>

<?php if (!empty($alert_message)): ?>
                    <div class="mb-4"><?php echo $alert_message; ?></div>
                <?php endif; ?>

<div class="row mb-4">
                    <div class="col-xl-3 col-md-6">
                        <div class="stat-card pending">
                            <div class="d-flex justify-content-between align-items-center">
                                <div>
                                    <div class="stat-value"><?php echo $stats['pending_credits'] ?? 0; ?></div>
                                    <div class="stat-label">Pending Credits</div>
                                </div>
                                <div class="stat-icon">
                                    <i class="fas fa-clock"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-md-6">
                        <div class="stat-card partial">
                            <div class="d-flex justify-content-between align-items-center">
                                <div>
                                    <div class="stat-value"><?php echo $stats['partial_credits'] ?? 0; ?></div>
                                    <div class="stat-label">Partial Payments</div>
                                </div>
                                <div class="stat-icon">
                                    <i class="fas fa-money-bill-wave"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-md-6">
                        <div class="stat-card paid">
                            <div class="d-flex justify-content-between align-items-center">
                                <div>
                                    <div class="stat-value"><?php echo $stats['paid_credits'] ?? 0; ?></div>
                                    <div class="stat-label">Paid Credits</div>
                                </div>
                                <div class="stat-icon">
                                    <i class="fas fa-check-circle"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-xl-3 col-md-6">
                        <div class="stat-card total">
                            <div class="d-flex justify-content-between align-items-center">
                                <div>
                                    <div class="stat-value">₹<?php echo number_format($stats['total_remaining'] ?? 0, 2); ?></div>
                                    <div class="stat-label">Total Outstanding</div>
                                </div>
                                <div class="stat-icon">
                                    <i class="fas fa-wallet"></i>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($customer_id > 0 && !empty($customer_name)): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="customer-card">
                            <div class="d-flex justify-content-between align-items-center">
                                <div>
                                    <h5 class="mb-1">
                                        <i class="fas fa-user me-2"></i>
                                        <?php echo htmlspecialchars($customer_name); ?>
                                    </h5>
                                    <p class="mb-0 text-muted">Viewing credit payments for this customer only</p>
                                </div>
                                <div>
                                    <a href="credit-payments.php" class="btn btn-outline-secondary btn-sm">
                                        <i class="fas fa-times me-1"></i>Clear Filter
                                    </a>
                                    <a href="customers-manage.php?edit=<?php echo $customer_id; ?>" class="btn btn-outline-primary btn-sm">
                                        <i class="fas fa-edit me-1"></i>Edit Customer
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="row mb-3">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex flex-wrap gap-2 align-items-center">
                                    <span class="me-2">Filter by Status:</span>
                                    <a href="credit-payments.php<?php echo $customer_id > 0 ? '?customer_id=' . $customer_id : ''; ?>" 
                                       class="badge filter-badge <?php echo empty($_GET['status']) ? 'bg-primary active' : 'bg-secondary'; ?>">
                                        All
                                    </a>
                                    <a href="credit-payments.php?status=pending<?php echo $customer_id > 0 ? '&customer_id=' . $customer_id : ''; ?>" 
                                       class="badge filter-badge <?php echo ($_GET['status'] ?? '') == 'pending' ? 'bg-danger active' : 'bg-secondary'; ?>">
                                        Pending
                                    </a>
                                    <a href="credit-payments.php?status=partial<?php echo $customer_id > 0 ? '&customer_id=' . $customer_id : ''; ?>" 
                                       class="badge filter-badge <?php echo ($_GET['status'] ?? '') == 'partial' ? 'bg-warning active' : 'bg-secondary'; ?>">
                                        Partial
                                    </a>
                                    <a href="credit-payments.php?status=paid<?php echo $customer_id > 0 ? '&customer_id=' . $customer_id : ''; ?>" 
                                       class="badge filter-badge <?php echo ($_GET['status'] ?? '') == 'paid' ? 'bg-success active' : 'bg-secondary'; ?>">
                                        Paid
                                    </a>
                                    
                                    <div class="ms-auto">
                                        <button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#addPaymentModal">
                                            <i class="fas fa-plus me-1"></i>Add Payment
                                        </button>
                                        <a href="sales-history.php" class="btn btn-outline-secondary btn-sm">
                                            <i class="fas fa-history me-1"></i>View Sales
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-credit-card me-2"></i>
                                        Credit Payments
                                    </h5>
                                    <span class="badge bg-primary"><?php echo $stats['total_credits'] ?? 0; ?> credits</span>
                                </div>
                            </div>
                            <div class="card-body">
                                <?php
                                // Build query for credit payments
                                $query = "SELECT cp.*, 
                                         c.customer_name, 
                                         c.customer_phone,
                                         s.sale_number,
                                         s.total_amount as sale_total
                                         FROM credit_payments cp
                                         JOIN customers c ON cp.customer_id = c.id
                                         JOIN sales s ON cp.sale_id = s.id";
                                
                                $where = [];
                                if ($credit_has_branch) {
                                    $where[] = "cp.branch_id = $branch_id";
                                }
                                if ($customer_id > 0) {
                                    $where[] = "cp.customer_id = $customer_id";
                                }
                                if (!empty($_GET['status'])) {
                                    $status = $conn->real_escape_string($_GET['status']);
                                    $where[] = "cp.status = '$status'";
                                }
                                
                                if (!empty($where)) {
                                    $query .= " WHERE " . implode(" AND ", $where);
                                }
                                
                                $query .= " ORDER BY cp.due_date ASC, cp.created_at DESC";
                                
                                $result = $conn->query($query);
                                
                                if ($result && $result->num_rows > 0):
                                ?>
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Customer</th>
                                                <th>Sale</th>
                                                <th>Due Date</th>
                                                <th>Due Amount</th>
                                                <th>Paid</th>
                                                <th>Remaining</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $count = 1;
                                            while($row = $result->fetch_assoc()):
                                                $due_date = new DateTime($row['due_date']);
                                                $today = new DateTime();
                                                $interval = $today->diff($due_date);
                                                $days_diff = $interval->days;
                                                $is_overdue = $due_date < $today && $row['status'] != 'paid';
                                                
                                                // Status badge
                                                $status_badge = '';
                                                switch($row['status']) {
                                                    case 'paid':
                                                        $status_badge = '<span class="badge bg-success status-badge">Paid</span>';
                                                        break;
                                                    case 'partial':
                                                        $status_badge = '<span class="badge bg-warning status-badge">Partial</span>';
                                                        break;
                                                    case 'pending':
                                                        $status_badge = '<span class="badge bg-danger status-badge">Pending</span>';
                                                        break;
                                                }
                                            ?>
                                            <tr>
                                                <td><?php echo $count++; ?></td>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($row['customer_name']); ?></strong><br>
                                                    <small class="text-muted"><?php echo htmlspecialchars($row['customer_phone']); ?></small>
                                                </td>
                                                <td>
                                                    <a href="sales-receipt.php?id=<?php echo $row['sale_id']; ?>" target="_blank" class="text-primary">
                                                        <?php echo htmlspecialchars($row['sale_number']); ?>
                                                    </a><br>
                                                    <small>Total: ₹<?php echo number_format($row['sale_total'], 2); ?></small>
                                                </td>
                                                <td>
                                                    <?php echo date('d M Y', strtotime($row['due_date'])); ?><br>
                                                    <?php if ($is_overdue): ?>
                                                        <small class="overdue">Overdue by <?php echo $days_diff; ?> days</small>
                                                    <?php elseif ($days_diff <= 7 && $row['status'] != 'paid'): ?>
                                                        <small class="due-soon">Due in <?php echo $days_diff; ?> days</small>
                                                    <?php endif; ?>
                                                </td>
                                                <td class="amount-cell amount-negative">₹<?php echo number_format($row['due_amount'], 2); ?></td>
                                                <td class="amount-cell amount-positive">₹<?php echo number_format($row['paid_amount'], 2); ?></td>
                                                <td class="amount-cell amount-negative">₹<?php echo number_format($row['remaining_amount'], 2); ?></td>
                                                <td><?php echo $status_badge; ?></td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-primary" 
                                                                onclick="setCreditForPayment(<?php echo $row['id']; ?>, '<?php echo htmlspecialchars($row['customer_name']); ?>', <?php echo $row['remaining_amount']; ?>)"
                                                                data-bs-toggle="modal" data-bs-target="#addPaymentModal">
                                                            <i class="fas fa-money-bill"></i>
                                                        </button>
                                                        <a href="credit-payments.php?action=view&id=<?php echo $row['id']; ?>" class="btn btn-outline-info">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                        <?php if ($row['status'] != 'paid'): ?>
                                                            <a href="credit-payments.php?action=mark_paid&id=<?php echo $row['id']; ?>" 
                                                               class="btn btn-outline-success" 
                                                               onclick="return confirm('Mark this credit as fully paid?')">
                                                                <i class="fas fa-check"></i>
                                                            </a>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <div class="text-center py-5">
                                    <i class="dripicons-inbox display-4 text-muted"></i>
                                    <h5 class="mt-3">No Credit Payments Found</h5>
                                    <p class="text-muted">
                                        <?php if ($customer_id > 0): ?>
                                            This customer has no credit payments.
                                        <?php else: ?>
                                            No credit payments found for your branch.
                                        <?php endif; ?>
                                    </p>
                                    <a href="sales-new.php" class="btn btn-primary">
                                        <i class="fas fa-cash-register me-1"></i>Create New Sale
                                    </a>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($action == 'view' && $id > 0): 
                    // Get credit details
                    $credit_query = "SELECT cp.*, c.customer_name, s.sale_number 
                                   FROM credit_payments cp
                                   JOIN customers c ON cp.customer_id = c.id
                                   JOIN sales s ON cp.sale_id = s.id
                                   WHERE cp.id = $id";
                    
                    if ($credit_has_branch) {
                        $credit_query .= " AND cp.branch_id = $branch_id";
                    }
                    
                    $credit_result = $conn->query($credit_query);
                    
                    if ($credit_result && $credit_result->num_rows > 0):
                        $credit = $credit_result->fetch_assoc();
                ?>
                <div class="row mt-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-history me-2"></i>
                                        Payment History for <?php echo htmlspecialchars($credit['customer_name']); ?>
                                    </h5>
                                    <a href="credit-payments.php" class="btn btn-sm btn-outline-secondary">
                                        <i class="fas fa-arrow-left me-1"></i>Back to List
                                    </a>
                                </div>
                            </div>
                            <div class="card-body">
                                
                                <div class="row mb-4">
                                    <div class="col-md-4">
                                        <div class="card border-primary">
                                            <div class="card-body">
                                                <h6 class="card-title">Due Amount</h6>
                                                <h3 class="text-danger">₹<?php echo number_format($credit['due_amount'], 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="card border-success">
                                            <div class="card-body">
                                                <h6 class="card-title">Paid Amount</h6>
                                                <h3 class="text-success">₹<?php echo number_format($credit['paid_amount'], 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-4">
                                        <div class="card border-warning">
                                            <div class="card-body">
                                                <h6 class="card-title">Remaining</h6>
                                                <h3 class="text-warning">₹<?php echo number_format($credit['remaining_amount'], 2); ?></h3>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                <?php
                                // Get transactions
                                $trans_query = "SELECT * FROM credit_payment_transactions 
                                              WHERE credit_payment_id = $id 
                                              ORDER BY payment_date DESC";
                                $trans_result = $conn->query($trans_query);
                                
                                if ($trans_result && $trans_result->num_rows > 0):
                                ?>
                                <div class="table-responsive">
                                    <table class="table table-bordered">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Date</th>
                                                <th>Amount</th>
                                                <th>Method</th>
                                                <th>Reference</th>
                                                <th>Notes</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $trans_count = 1;
                                            while($trans = $trans_result->fetch_assoc()):
                                            ?>
                                            <tr>
                                                <td><?php echo $trans_count++; ?></td>
                                                <td><?php echo date('d M Y h:i A', strtotime($trans['payment_date'])); ?></td>
                                                <td class="amount-positive">₹<?php echo number_format($trans['amount_paid'], 2); ?></td>
                                                <td>
                                                    <span class="badge bg-info"><?php echo ucfirst($trans['payment_method']); ?></span>
                                                </td>
                                                <td><small><?php echo htmlspecialchars($trans['reference_number']); ?></small></td>
                                                <td><small><?php echo htmlspecialchars($trans['notes']); ?></small></td>
                                                <td>
                                                    <a href="credit-payments.php?action=delete_transaction&id=<?php echo $trans['id']; ?>" 
                                                       class="btn btn-sm btn-outline-danger"
                                                       onclick="return confirm('Delete this payment record? This will adjust the credit balance.')">
                                                        <i class="fas fa-trash"></i>
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>
                                <?php else: ?>
                                <div class="text-center py-4">
                                    <i class="dripicons-inbox display-4 text-muted"></i>
                                    <h5 class="mt-3">No Payment History</h5>
                                    <p class="text-muted">No payments recorded for this credit yet.</p>
                                    <button type="button" class="btn btn-primary" 
                                            onclick="setCreditForPayment(<?php echo $credit['id']; ?>, '<?php echo htmlspecialchars($credit['customer_name']); ?>', <?php echo $credit['remaining_amount']; ?>)"
                                            data-bs-toggle="modal" data-bs-target="#addPaymentModal">
                                        <i class="fas fa-plus me-1"></i>Add First Payment
                                    </button>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; endif; ?>

</div>
        </div>
        <?php include('includes/footer.php')?>
    </div>
</div>

<?php include('includes/rightbar.php')?>
<?php include('includes/scripts.php')?>

<div class="modal fade" id="addPaymentModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Add Payment</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <input type="hidden" name="credit_id" id="credit_id" value="">
                    
                    <div class="mb-3">
                        <label class="form-label">Customer</label>
                        <input type="text" class="form-control" id="customer_name_display" readonly>
                    </div>
                    
                    <div class="mb-3">
                        <label class="form-label">Remaining Balance</label>
                        <div class="input-group">
                            <span class="input-group-text">₹</span>
                            <input type="text" class="form-control" id="remaining_balance_display" readonly>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label for="amount_paid" class="form-label">Amount to Pay <span class="text-danger">*</span></label>
                        <div class="input-group">
                            <span class="input-group-text">₹</span>
                            <input type="number" class="form-control" id="amount_paid" name="amount_paid" 
                                   step="0.01" min="0.01" required oninput="validatePaymentAmount()">
                        </div>
                        <small class="text-muted" id="amount_hint"></small>
                    </div>
                    
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="payment_method" class="form-label">Payment Method <span class="text-danger">*</span></label>
                                <select class="form-select" id="payment_method" name="payment_method" required>
                                    <option value="">Select Method</option>
                                    <option value="cash">Cash</option>
                                    <option value="card">Card</option>
                                    <option value="upi">UPI</option>
                                    <option value="bank_transfer">Bank Transfer</option>
                                    <option value="cheque">Cheque</option>
                                    <option value="other">Other</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="payment_date" class="form-label">Payment Date <span class="text-danger">*</span></label>
                                <input type="datetime-local" class="form-control" id="payment_date" name="payment_date" 
                                       value="<?php echo date('Y-m-d\TH:i'); ?>" required>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mb-3">
                        <label for="reference_number" class="form-label">Reference Number</label>
                        <input type="text" class="form-control" id="reference_number" name="reference_number" 
                               placeholder="Transaction ID, Cheque No., etc.">
                    </div>
                    
                    <div class="mb-3">
                        <label for="notes" class="form-label">Notes</label>
                        <textarea class="form-control" id="notes" name="notes" rows="2" placeholder="Any additional notes..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="add_payment" class="btn btn-primary">Record Payment</button>
                </div>
            </form>
        </div>
    </div>
</div>

// Validate payment amount
function validatePaymentAmount() {
    const amountInput = document.getElementById('amount_paid');
    const maxAmount = parseFloat(amountInput.max) || 0;
    const enteredAmount = parseFloat(amountInput.value) || 0;
    const amountHint = document.getElementById('amount_hint');
    
    if (enteredAmount > maxAmount) {
        amountInput.classList.add('is-invalid');
        amountHint.innerHTML = `<span class="text-danger">Amount cannot exceed ₹${maxAmount.toFixed(2)}</span>`;
    } else if (enteredAmount <= 0) {
        amountInput.classList.add('is-invalid');
        amountHint.innerHTML = `<span class="text-danger">Amount must be greater than 0</span>`;
    } else {
        amountInput.classList.remove('is-invalid');
        const remaining = maxAmount - enteredAmount;
        if (remaining > 0) {
            amountHint.innerHTML = `Remaining balance after payment: ₹${remaining.toFixed(2)}`;
        } else {
            amountHint.innerHTML = `<span class="text-success">Credit will be fully paid</span>`;
        }
    }
}

// Auto-calculate payment date to today
document.addEventListener('DOMContentLoaded', function() {
    const paymentDate = document.getElementById('payment_date');
    if (paymentDate && !paymentDate.value) {
        paymentDate.value = new Date().toISOString().slice(0, 16);
    }
    
    // Initialize tooltips
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });
});
</script>

</body>
</html>

<?php
// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: credit-payments.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation