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.16 TB

🔧 Quick Actions

✏️ Editing: customers-credit.php

<?php
session_start();
?>
<!doctype html>
<html lang="en">

<?php include('includes/head.php')?>

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

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

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

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php
                // Include database connection
                include('includes/db.php');

// Ensure branch context
                if (!isset($_SESSION['branch_id'])) {
                    // If there's no branch in session, redirect to branch login or show a message.
                    // Change this redirect as per your app flow.
                    header("Location: login.php");
                    exit();
                }
                $branch_id = intval($_SESSION['branch_id']);

// Helper: check if a table has a column (used to decide how to filter by branch)
                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);
                }

// Build branch filtering clause based on available branch columns.
                // It returns an SQL snippet (without leading AND/WHERE) that can be appended to queries that reference aliases cp (credit_payments), s (sales), c (customers).
                function buildBranchClause($conn, $branch_id) {
                    $clauses = [];
                    if (columnExists($conn, 'credit_payments', 'branch_id')) {
                        $clauses[] = "cp.branch_id = {$branch_id}";
                    }
                    if (columnExists($conn, 'sales', 'branch_id')) {
                        $clauses[] = "s.branch_id = {$branch_id}";
                    }
                    if (columnExists($conn, 'customers', 'branch_id')) {
                        $clauses[] = "c.branch_id = {$branch_id}";
                    }

if (count($clauses) > 0) {
                        return '(' . implode(' OR ', $clauses) . ')';
                    } else {
                        return ''; // empty => cannot filter by branch using schema
                    }
                }

$branch_clause = buildBranchClause($conn, $branch_id);
                $can_filter_by_branch = !empty($branch_clause);

// Function to log activities
                function logActivity($conn, $activity_type, $description, $related_id = null, $related_table = null) {
                    $user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : null;
                    $ip_address = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : null;
                    $user_agent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : null;
                    
                    $stmt = $conn->prepare("INSERT INTO activity_logs (user_id, activity_type, description, related_id, related_table, ip_address, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)");
                    if ($stmt) {
                        $stmt->bind_param("ississs", $user_id, $activity_type, $description, $related_id, $related_table, $ip_address, $user_agent);
                        $stmt->execute();
                        $stmt->close();
                    } else {
                        error_log("logActivity prepare failed: " . $conn->error);
                    }
                }

// If we cannot filter by branch (no branch columns in schema),
                // show a warning so admin knows why filtering isn't applied.
                if (!$can_filter_by_branch) {
                    echo '<div class="alert alert-warning">Branch-level filtering is not available because the database schema has no <code>branch_id</code> column in <code>credit_payments</code>, <code>sales</code> or <code>customers</code>. The page will show all credit payments. To restrict results to a branch, add a <code>branch_id</code> column to one of those tables.</div>';
                }

// Handle payment recording
                if (isset($_POST['record_payment'])) {
                    $credit_payment_id = intval($_POST['credit_payment_id']);
                    $customer_id = intval($_POST['customer_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'] ?? '');
                    
                    // Start transaction
                    $conn->begin_transaction();
                    
                    try {
                        // Get current credit payment details
                        $credit_sql = "SELECT * FROM credit_payments WHERE id = $credit_payment_id LIMIT 1";
                        $credit_result = $conn->query($credit_sql);
                        if (!$credit_result || $credit_result->num_rows == 0) {
                            throw new Exception("Credit payment record not found.");
                        }
                        $credit_info = $credit_result->fetch_assoc();

// Verify branch ownership (if possible)
                        if ($can_filter_by_branch) {
                            $owns = false;
                            // Build checks in PHP using the branch column availability
                            if (columnExists($conn, 'credit_payments', 'branch_id')) {
                                $check = $conn->query("SELECT 1 FROM credit_payments WHERE id = {$credit_payment_id} AND branch_id = {$branch_id} LIMIT 1");
                                if ($check && $check->num_rows > 0) $owns = true;
                            }
                            if (!$owns && columnExists($conn, 'sales', 'branch_id')) {
                                $check = $conn->query("SELECT 1 FROM sales WHERE id = {$credit_info['sale_id']} AND branch_id = {$branch_id} LIMIT 1");
                                if ($check && $check->num_rows > 0) $owns = true;
                            }
                            if (!$owns && columnExists($conn, 'customers', 'branch_id')) {
                                $check = $conn->query("SELECT 1 FROM customers WHERE id = {$customer_id} AND branch_id = {$branch_id} LIMIT 1");
                                if ($check && $check->num_rows > 0) $owns = true;
                            }
                            if (!$owns) {
                                throw new Exception("This credit payment does not belong to your branch.");
                            }
                        }

// Insert payment transaction
                        $transaction_sql = "INSERT INTO credit_payment_transactions (credit_payment_id, customer_id, amount_paid, payment_method, payment_date, reference_number, notes, created_at) 
                                           VALUES ($credit_payment_id, $customer_id, $amount_paid, '$payment_method', '$payment_date', '$reference_number', '$notes', NOW())";
                        if ($conn->query($transaction_sql) === FALSE) {
                            throw new Exception("Insert transaction failed: " . $conn->error);
                        }
                        
                        // Update credit payment
                        $new_paid_amount = $credit_info['paid_amount'] + $amount_paid;
                        $new_remaining_amount = $credit_info['remaining_amount'] - $amount_paid;
                        if ($new_remaining_amount < 0) $new_remaining_amount = 0;
                        $new_status = $new_remaining_amount <= 0 ? 'paid' : ($new_paid_amount > 0 ? 'partial' : 'pending');

// Update payment_date only if status becomes paid
                        $update_credit_sql = "UPDATE credit_payments SET 
                                             paid_amount = {$new_paid_amount}, 
                                             remaining_amount = {$new_remaining_amount},
                                             status = '{$new_status}',
                                             payment_date = CASE WHEN '{$new_status}' = 'paid' THEN '{$payment_date}' ELSE payment_date END,
                                             updated_at = NOW()
                                             WHERE id = {$credit_payment_id}";
                        if ($conn->query($update_credit_sql) === FALSE) {
                            throw new Exception("Update credit payment failed: " . $conn->error);
                        }
                        
                        // Update sale payment status and amounts
                        $sale_payment_status = $new_status == 'paid' ? 'paid' : ($new_paid_amount > 0 ? 'partial' : 'pending');
                        $update_sale_sql = "UPDATE sales SET 
                                           paid_amount = paid_amount + {$amount_paid},
                                           due_amount = due_amount - {$amount_paid},
                                           payment_status = '{$sale_payment_status}',
                                           updated_at = NOW()
                                           WHERE id = {$credit_info['sale_id']}";
                        if ($conn->query($update_sale_sql) === FALSE) {
                            throw new Exception("Update sale failed: " . $conn->error);
                        }
                        
                        // Update customer balance
                        $update_customer_sql = "UPDATE customers SET 
                                               total_paid = total_paid + {$amount_paid},
                                               outstanding_balance = outstanding_balance - {$amount_paid},
                                               updated_at = NOW()
                                               WHERE id = {$customer_id}";
                        if ($conn->query($update_customer_sql) === FALSE) {
                            throw new Exception("Update customer failed: " . $conn->error);
                        }
                        
                        // Log activity
                        logActivity($conn, 'payment', "Credit payment recorded: ₹{$amount_paid} for customer ID: {$customer_id}", $credit_payment_id, 'credit_payments');
                        
                        $conn->commit();
                        
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>Payment of ₹' . number_format($amount_paid, 2) . ' recorded successfully!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                              
                    } catch (Exception $e) {
                        $conn->rollback();
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error recording payment: ' . htmlspecialchars($e->getMessage()) . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle credit limit update
                if (isset($_POST['update_credit_limit'])) {
                    $customer_id = intval($_POST['customer_id']);
                    $credit_limit = floatval($_POST['credit_limit']);

// Security: if branch filtering is available, ensure the customer belongs to this branch (if customers.branch_id exists)
                    if ($can_filter_by_branch && columnExists($conn, 'customers', 'branch_id')) {
                        $check = $conn->query("SELECT 1 FROM customers WHERE id = {$customer_id} AND branch_id = {$branch_id} LIMIT 1");
                        if (!$check || $check->num_rows == 0) {
                            echo '<div class="alert alert-danger">Cannot update credit limit: customer does not belong to your branch.</div>';
                        } else {
                            $update_sql = "UPDATE customers SET credit_limit = {$credit_limit}, updated_at = NOW() WHERE id = {$customer_id}";
                            if ($conn->query($update_sql) === TRUE) {
                                logActivity($conn, 'customer_update', "Credit limit updated to ₹{$credit_limit}", $customer_id, 'customers');
                                echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                        <i class="fas fa-check-circle me-2"></i>Credit limit updated successfully!
                                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                      </div>';
                            } else {
                                echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                        <i class="fas fa-exclamation-triangle me-2"></i>Error updating credit limit: ' . htmlspecialchars($conn->error) . '
                                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                      </div>';
                            }
                        }
                    } else {
                        // If customers.branch_id doesn't exist, still allow update (global)
                        $update_sql = "UPDATE customers SET credit_limit = {$credit_limit}, updated_at = NOW() WHERE id = {$customer_id}";
                        if ($conn->query($update_sql) === TRUE) {
                            logActivity($conn, 'customer_update', "Credit limit updated to ₹{$credit_limit}", $customer_id, 'customers');
                            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <i class="fas fa-check-circle me-2"></i>Credit limit updated successfully!
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        } else {
                            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                    <i class="fas fa-exclamation-triangle me-2"></i>Error updating credit limit: ' . htmlspecialchars($conn->error) . '
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        }
                    }
                }

// Get filter parameters (we will apply branch filter server-side to all data)
                $status_filter = isset($_GET['status']) ? $conn->real_escape_string($_GET['status']) : '';
                $overdue_filter = isset($_GET['overdue']) ? $conn->real_escape_string($_GET['overdue']) : '';
                $customer_filter = isset($_GET['customer_id']) ? intval($_GET['customer_id']) : 0;
                ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-credit-card me-2"></i>Customer Credit Management (Branch Only)
                                    </h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="customers-manage.php" class="btn btn-outline-primary">
                                            <i class="fas fa-users me-2"></i>All Customers
                                        </a>
                                        <a href="sales-new.php" class="btn btn-success">
                                            <i class="fas fa-plus-circle me-2"></i>New Sale
                                        </a>
                                        <button type="button" class="btn btn-warning" data-bs-toggle="modal" data-bs-target="#creditReportModal">
                                            <i class="fas fa-chart-bar me-2"></i>Credit Report
                                        </button>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-4">
                                    <?php
                                    // We'll use joins and the built branch clause when possible to ensure stats are branch-specific.
                                    $branchFilterSqlForJoins = '';
                                    if ($can_filter_by_branch) {
                                        // build clause uses aliases cp, s, c; this will be appended to WHERE ... (note: no leading AND here)
                                        $branchFilterSqlForJoins = ' AND ' . $branch_clause;
                                    }

// Total active credits
                                    $total_credit_sql = "SELECT COUNT(*) as total
                                        FROM credit_payments cp
                                        JOIN customers c ON cp.customer_id = c.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        WHERE cp.status != 'paid' {$branchFilterSqlForJoins}";
                                    $total_credit = $conn->query($total_credit_sql)->fetch_assoc()['total'] ?? 0;

// Pending count
                                    $pending_sql = "SELECT COUNT(*) as pending
                                        FROM credit_payments cp
                                        JOIN customers c ON cp.customer_id = c.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        WHERE cp.status = 'pending' {$branchFilterSqlForJoins}";
                                    $pending_count = $conn->query($pending_sql)->fetch_assoc()['pending'] ?? 0;

// Partial count
                                    $partial_sql = "SELECT COUNT(*) as partial
                                        FROM credit_payments cp
                                        JOIN customers c ON cp.customer_id = c.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        WHERE cp.status = 'partial' {$branchFilterSqlForJoins}";
                                    $partial_count = $conn->query($partial_sql)->fetch_assoc()['partial'] ?? 0;

// Overdue count
                                    $overdue_sql = "SELECT COUNT(*) as overdue
                                        FROM credit_payments cp
                                        JOIN customers c ON cp.customer_id = c.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        WHERE (cp.status = 'overdue' OR (cp.due_date < CURDATE() AND cp.status != 'paid')) {$branchFilterSqlForJoins}";
                                    $overdue_count = $conn->query($overdue_sql)->fetch_assoc()['overdue'] ?? 0;

// Total outstanding
                                    $total_outstanding_sql = "SELECT SUM(cp.remaining_amount) as total
                                        FROM credit_payments cp
                                        JOIN customers c ON cp.customer_id = c.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        WHERE cp.status != 'paid' {$branchFilterSqlForJoins}";
                                    $total_outstanding = $conn->query($total_outstanding_sql)->fetch_assoc()['total'] ?? 0;

// This month payments
                                    $this_month_sql = "SELECT SUM(cpt.amount_paid) as monthly
                                        FROM credit_payment_transactions cpt
                                        JOIN credit_payments cp ON cpt.credit_payment_id = cp.id
                                        JOIN sales s ON cp.sale_id = s.id
                                        JOIN customers c ON cp.customer_id = c.id
                                        WHERE MONTH(cpt.payment_date) = MONTH(CURDATE()) AND YEAR(cpt.payment_date) = YEAR(CURDATE()) {$branchFilterSqlForJoins}";
                                    $this_month_payments = $conn->query($this_month_sql)->fetch_assoc()['monthly'] ?? 0;
                                    ?>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-primary text-white">
                                            <div class="card-body text-center">
                                                <h3><?php echo intval($total_credit); ?></h3>
                                                <p class="mb-0">Active Credits</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-warning text-white">
                                            <div class="card-body text-center">
                                                <h3><?php echo intval($pending_count); ?></h3>
                                                <p class="mb-0">Pending</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-info text-white">
                                            <div class="card-body text-center">
                                                <h3><?php echo intval($partial_count); ?></h3>
                                                <p class="mb-0">Partial</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-danger text-white">
                                            <div class="card-body text-center">
                                                <h3><?php echo intval($overdue_count); ?></h3>
                                                <p class="mb-0">Overdue</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-success text-white">
                                            <div class="card-body text-center">
                                                <h3>₹<?php echo number_format($total_outstanding, 0); ?></h3>
                                                <p class="mb-0">Total Outstanding</p>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-2 col-md-4">
                                        <div class="card card-hover bg-secondary text-white">
                                            <div class="card-body text-center">
                                                <h3>₹<?php echo number_format($this_month_payments, 0); ?></h3>
                                                <p class="mb-0">This Month</p>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search customers...">
                                            <button class="btn btn-outline-secondary" type="button" id="searchButton">
                                                <i class="fas fa-search"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="statusFilter">
                                            <option value="">All Status</option>
                                            <option value="pending">Pending</option>
                                            <option value="partial">Partial</option>
                                            <option value="overdue">Overdue</option>
                                            <option value="paid">Paid</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="overdueFilter">
                                            <option value="">All</option>
                                            <option value="overdue">Overdue Only</option>
                                            <option value="due_soon">Due Soon (7 days)</option>
                                            <option value="due_today">Due Today</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <select class="form-select" id="customerFilter">
                                            <option value="">All Customers</option>
                                            <?php
                                            // Build customers dropdown but limited to branch (if possible). We'll leverage credit_payments join for robust filtering.
                                            if ($can_filter_by_branch) {
                                                $customers_sql = "SELECT DISTINCT c.id, c.customer_name, c.customer_phone
                                                                  FROM credit_payments cp
                                                                  JOIN customers c ON cp.customer_id = c.id
                                                                  JOIN sales s ON cp.sale_id = s.id
                                                                  WHERE c.outstanding_balance > 0 AND {$branch_clause}
                                                                  ORDER BY c.customer_name";
                                            } else {
                                                // Fallback: no branch columns available, so show all customers with outstanding balance
                                                $customers_sql = "SELECT id, customer_name, customer_phone FROM customers WHERE outstanding_balance > 0 ORDER BY customer_name";
                                            }
                                            $customers_result = $conn->query($customers_sql);
                                            while($cust = $customers_result->fetch_assoc()) {
                                                $selected = $customer_filter == $cust['id'] ? 'selected' : '';
                                                echo '<option value="' . intval($cust['id']) . '" ' . $selected . '>' . htmlspecialchars($cust['customer_name']) . ' (' . htmlspecialchars($cust['customer_phone']) . ')</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <button type="button" class="btn btn-outline-primary w-100" id="exportButton">
                                            <i class="fas fa-download me-2"></i>Export
                                        </button>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped mb-0" id="creditTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Customer</th>
                                                <th>Sale Details</th>
                                                <th>Credit Information</th>
                                                <th>Payment Progress</th>
                                                <th>Due Date</th>
                                                <th>Status</th>
                                                <th width="120">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters (branch clause included)
                                            $where_conditions = array();

// Status filter
                                            if (!empty($status_filter)) {
                                                $where_conditions[] = "cp.status = '" . $conn->real_escape_string($status_filter) . "'";
                                            }

// Customer filter
                                            if ($customer_filter > 0) {
                                                $where_conditions[] = "cp.customer_id = " . intval($customer_filter);
                                            }

// Overdue filter
                                            if (!empty($overdue_filter)) {
                                                switch($overdue_filter) {
                                                    case 'overdue':
                                                        $where_conditions[] = "(cp.due_date < CURDATE() AND cp.status != 'paid')";
                                                        break;
                                                    case 'due_soon':
                                                        $where_conditions[] = "(cp.due_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) AND cp.status != 'paid')";
                                                        break;
                                                    case 'due_today':
                                                        $where_conditions[] = "(cp.due_date = CURDATE() AND cp.status != 'paid')";
                                                        break;
                                                }
                                            }

// Search filter (from $_GET)
                                            if (isset($_GET['search']) && !empty(trim($_GET['search']))) {
                                                $search = $conn->real_escape_string(trim($_GET['search']));
                                                $where_conditions[] = "(c.customer_name LIKE '%{$search}%' OR c.customer_phone LIKE '%{$search}%' OR s.sale_number LIKE '%{$search}%')";
                                            }

// Branch clause MUST be applied to ensure branch-only results (if possible)
                                            if ($can_filter_by_branch) {
                                                $where_conditions[] = $branch_clause; // already safe numeric values inside
                                            }

$where_sql = "";
                                            if (!empty($where_conditions)) {
                                                $where_sql = "WHERE " . implode(" AND ", $where_conditions);
                                            }

// Main query
                                            $sql = "SELECT cp.*, c.customer_name, c.customer_phone, c.customer_email, c.credit_limit, c.outstanding_balance,
                                                   s.sale_number, s.sale_date, s.total_amount,
                                                   (SELECT COUNT(*) FROM credit_payment_transactions cpt WHERE cpt.credit_payment_id = cp.id) as transaction_count
                                                   FROM credit_payments cp
                                                   JOIN customers c ON cp.customer_id = c.id
                                                   JOIN sales s ON cp.sale_id = s.id
                                                   {$where_sql}
                                                   ORDER BY 
                                                   CASE 
                                                     WHEN cp.status = 'overdue' THEN 1
                                                     WHEN cp.due_date < CURDATE() AND cp.status != 'paid' THEN 2
                                                     WHEN cp.due_date = CURDATE() THEN 3
                                                     WHEN cp.due_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) THEN 4
                                                     ELSE 5
                                                   END, cp.due_date ASC";

$result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
                                                while($credit = $result->fetch_assoc()) {
                                                    // Calculate days remaining/overdue
                                                    $due_date = strtotime($credit['due_date']);
                                                    $today = strtotime(date('Y-m-d'));
                                                    $days_diff = ($due_date - $today) / (60 * 60 * 24);
                                                    $days_diff = (int) floor($days_diff);

// Progress calculation
                                                    // Prevent division by zero: if due_amount is 0, treat as 100%
                                                    $progress = 100;
                                                    if (floatval($credit['due_amount']) > 0) {
                                                        $progress = (floatval($credit['paid_amount']) / floatval($credit['due_amount'])) * 100;
                                                        if ($progress > 100) $progress = 100;
                                                        if ($progress < 0) $progress = 0;
                                                    }

$progress_class = $progress >= 100 ? 'success' : ($progress >= 50 ? 'info' : ($progress > 0 ? 'warning' : 'danger'));

// Status determination
                                                    $status = $credit['status'];
                                                    if ($status != 'paid' && $due_date < $today) {
                                                        $status = 'overdue';
                                                    }

$status_badge = [
                                                        'pending' => 'warning',
                                                        'partial' => 'info',
                                                        'paid' => 'success',
                                                        'overdue' => 'danger'
                                                    ];
                                            ?>
                                            <tr data-status="<?php echo htmlspecialchars($status); ?>"
                                                data-customer="<?php echo intval($credit['customer_id']); ?>"
                                                data-days="<?php echo intval($days_diff); ?>">
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0">
                                                            <div class="avatar-xs bg-light rounded-circle">
                                                                <span class="avatar-title text-primary fw-bold">
                                                                    <?php echo strtoupper(substr($credit['customer_name'], 0, 1)); ?>
                                                                </span>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($credit['customer_name']); ?></h6>
                                                            <small class="text-muted"><?php echo htmlspecialchars($credit['customer_phone']); ?></small>
                                                            <br>
                                                            <small class="text-muted">
                                                                Limit: ₹<?php echo number_format($credit['credit_limit'], 2); ?> | 
                                                                Balance: ₹<?php echo number_format($credit['outstanding_balance'], 2); ?>
                                                            </small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong>
                                                            <a href="sales-view.php?id=<?php echo intval($credit['sale_id']); ?>" class="text-decoration-none">
                                                                <?php echo htmlspecialchars($credit['sale_number']); ?>
                                                            </a>
                                                        </strong>
                                                        <br>
                                                        <small class="text-muted">
                                                            <?php echo date('M j, Y', strtotime($credit['sale_date'])); ?>
                                                        </small>
                                                        <br>
                                                        <small class="text-success">
                                                            Sale Amount: ₹<?php echo number_format($credit['total_amount'], 2); ?>
                                                        </small>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong>Due Amount: ₹<?php echo number_format($credit['due_amount'], 2); ?></strong>
                                                        <br>
                                                        <span class="text-success">Paid: ₹<?php echo number_format($credit['paid_amount'], 2); ?></span>
                                                        <br>
                                                        <span class="text-danger">Remaining: ₹<?php echo number_format($credit['remaining_amount'], 2); ?></span>
                                                        <br>
                                                        <small class="text-muted">
                                                            <?php echo intval($credit['transaction_count']); ?> payment(s)
                                                        </small>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-grow-1 me-3">
                                                            <div class="progress" style="height: 8px;">
                                                                <div class="progress-bar bg-<?php echo $progress_class; ?>" 
                                                                     role="progressbar" 
                                                                     style="width: <?php echo intval($progress); ?>%" 
                                                                     aria-valuenow="<?php echo intval($progress); ?>" 
                                                                     aria-valuemin="0" 
                                                                     aria-valuemax="100">
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <div class="flex-shrink-0">
                                                            <small class="text-muted"><?php echo number_format($progress, 0); ?>%</small>
                                                        </div>
                                                    </div>
                                                    <div class="text-center mt-1">
                                                        <small class="text-muted">
                                                            ₹<?php echo number_format($credit['paid_amount'], 2); ?> / ₹<?php echo number_format($credit['due_amount'], 2); ?>
                                                        </small>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-center">
                                                        <strong><?php echo date('M j, Y', strtotime($credit['due_date'])); ?></strong>
                                                        <br>
                                                        <?php if ($status == 'overdue'): ?>
                                                            <span class="badge bg-danger">Overdue by <?php echo abs(intval($days_diff)); ?> days</span>
                                                        <?php elseif (intval($days_diff) == 0): ?>
                                                            <span class="badge bg-warning">Due Today</span>
                                                        <?php elseif (intval($days_diff) > 0 && intval($days_diff) <= 7): ?>
                                                            <span class="badge bg-warning">Due in <?php echo intval($days_diff); ?> days</span>
                                                        <?php elseif (intval($days_diff) > 7): ?>
                                                            <span class="badge bg-success">Due in <?php echo intval($days_diff); ?> days</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php echo $status_badge[$status] ?? 'secondary'; ?>">
                                                        <?php echo ucfirst(htmlspecialchars($status)); ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-success" 
                                                                data-bs-toggle="modal" data-bs-target="#paymentModal"
                                                                onclick="initiatePayment(<?php echo htmlspecialchars(json_encode($credit), ENT_QUOTES, 'UTF-8'); ?>)"
                                                                title="Record Payment">
                                                            <i class="fas fa-money-bill-wave"></i>
                                                        </button>
                                                        <a href="sales-view.php?id=<?php echo intval($credit['sale_id']); ?>" class="btn btn-outline-primary" title="View Sale">
                                                            <i class="fas fa-eye"></i>
                                                        </a>
                                                        <div class="btn-group btn-group-sm">
                                                            <button type="button" class="btn btn-outline-secondary dropdown-toggle" data-bs-toggle="dropdown" title="More Actions">
                                                                <i class="fas fa-ellipsis-v"></i>
                                                            </button>
                                                            <ul class="dropdown-menu">
                                                                <li>
                                                                    <button type="button" class="dropdown-item text-info" 
                                                                            data-bs-toggle="modal" data-bs-target="#paymentHistoryModal"
                                                                            onclick="viewPaymentHistory(<?php echo intval($credit['id']); ?>)">
                                                                        <i class="fas fa-history me-2"></i>Payment History
                                                                    </button>
                                                                </li>
                                                                <li>
                                                                    <button type="button" class="dropdown-item text-warning"
                                                                            data-bs-toggle="modal" data-bs-target="#creditLimitModal"
                                                                            onclick="updateCreditLimit(<?php echo intval($credit['customer_id']); ?>, <?php echo floatval($credit['credit_limit']); ?>)">
                                                                        <i class="fas fa-credit-card me-2"></i>Update Credit Limit
                                                                    </button>
                                                                </li>
                                                                <li><hr class="dropdown-divider"></li>
                                                                <li>
                                                                    <a class="dropdown-item text-primary" href="customer-details.php?id=<?php echo intval($credit['customer_id']); ?>">
                                                                        <i class="fas fa-user me-2"></i>Customer Profile
                                                                    </a>
                                                                </li>
                                                            </ul>
                                                        </div>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="7" class="text-center py-4">
                                                    <i class="fas fa-credit-card display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Credit Payments Found</h5>
                                                    <p class="text-muted">No credit payments match your search criteria.</p>
                                                    <a href="sales-new.php" class="btn btn-primary">
                                                        <i class="fas fa-plus-circle me-2"></i>Create New Sale
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

</div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="paymentModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Record Payment</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <input type="hidden" id="payment_credit_id" name="credit_payment_id">
                <input type="hidden" id="payment_customer_id" name="customer_id">
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Customer</label>
                        <input type="text" class="form-control" id="payment_customer_name" readonly>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Due Amount (₹)</label>
                                <input type="text" class="form-control" id="payment_due_amount" readonly>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Remaining Amount (₹)</label>
                                <input type="text" class="form-control" id="payment_remaining_amount" readonly>
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Payment Amount (₹) <span class="text-danger">*</span></label>
                        <input type="number" class="form-control" id="payment_amount" name="amount_paid" step="0.01" min="0.01" required>
                        <div class="form-text" id="payment_max_amount">Maximum: ₹0.00</div>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Payment Method <span class="text-danger">*</span></label>
                                <select class="form-select" name="payment_method" required>
                                    <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>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label class="form-label">Payment Date <span class="text-danger">*</span></label>
                                <input type="date" class="form-control" name="payment_date" value="<?php echo date('Y-m-d'); ?>" required>
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Reference Number (Optional)</label>
                        <input type="text" class="form-control" name="reference_number" placeholder="Transaction ID, UPI Ref, Cheque No.">
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Notes (Optional)</label>
                        <textarea class="form-control" name="notes" rows="2" placeholder="Any additional notes about this payment..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="record_payment" class="btn btn-success">Record Payment</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="paymentHistoryModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Payment History</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div id="paymentHistoryContent">
                    
                    <div class="text-center py-4">
                        <i class="fas fa-spinner fa-spin fa-2x text-muted"></i>
                        <p class="mt-2">Loading payment history...</p>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

<div class="modal fade" id="creditLimitModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Update Credit Limit</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <input type="hidden" id="limit_customer_id" name="customer_id">
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Customer</label>
                        <input type="text" class="form-control" id="limit_customer_name" readonly>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Current Outstanding Balance</label>
                        <input type="text" class="form-control" id="limit_current_balance" readonly>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">New Credit Limit (₹) <span class="text-danger">*</span></label>
                        <input type="number" class="form-control" id="limit_credit_limit" name="credit_limit" step="0.01" min="0" required>
                        <div class="form-text">Set the maximum credit amount allowed for this customer</div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_credit_limit" class="btn btn-warning">Update Credit Limit</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="creditReportModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Credit Management Report</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <div id="creditReportContent">
                    
                    <div class="text-center py-4">
                        <i class="fas fa-spinner fa-spin fa-2x text-muted"></i>
                        <p class="mt-2">Generating report...</p>
                    </div>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                <button type="button" class="btn btn-success" onclick="printCreditReport()">
                    <i class="fas fa-print me-2"></i>Print Report
                </button>
            </div>
        </div>
    </div>
</div>

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

// Filter functionality
    function applyFilters() {
        const params = new URLSearchParams();
        
        if (statusFilter.value) params.set('status', statusFilter.value);
        if (overdueFilter.value) params.set('overdue', overdueFilter.value);
        if (customerFilter.value) params.set('customer_id', customerFilter.value);
        if (searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'customers-credit.php?' + params.toString();
    }

searchButton.addEventListener('click', applyFilters);
    searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    statusFilter.addEventListener('change', applyFilters);
    overdueFilter.addEventListener('change', applyFilters);
    customerFilter.addEventListener('change', applyFilters);

// Set current filter values from URL
    const urlParams = new URLSearchParams(window.location.search);
    if (urlParams.get('status')) statusFilter.value = urlParams.get('status');
    if (urlParams.get('overdue')) overdueFilter.value = urlParams.get('overdue');
    if (urlParams.get('customer_id')) customerFilter.value = urlParams.get('customer_id');
    if (urlParams.get('search')) searchInput.value = urlParams.get('search');

// Export functionality
    exportButton.addEventListener('click', function() {
        const params = new URLSearchParams(window.location.search);
        params.set('export', 'csv');
        window.location.href = 'credit-export.php?' + params.toString();
    });

// Auto-focus search input
    setTimeout(() => {
        if (searchInput) {
            searchInput.focus();
        }
    }, 500);
});

// Initialize payment modal
function initiatePayment(credit) {
    document.getElementById('payment_credit_id').value = credit.id;
    document.getElementById('payment_customer_id').value = credit.customer_id;
    document.getElementById('payment_customer_name').value = credit.customer_name;
    document.getElementById('payment_due_amount').value = '₹' + parseFloat(credit.due_amount).toLocaleString('en-IN', {minimumFractionDigits: 2});
    document.getElementById('payment_remaining_amount').value = '₹' + parseFloat(credit.remaining_amount).toLocaleString('en-IN', {minimumFractionDigits: 2});
    document.getElementById('payment_amount').value = credit.remaining_amount;
    document.getElementById('payment_amount').max = credit.remaining_amount;
    document.getElementById('payment_max_amount').textContent = 'Maximum: ₹' + parseFloat(credit.remaining_amount).toLocaleString('en-IN', {minimumFractionDigits: 2});
}

// View payment history
function viewPaymentHistory(creditPaymentId) {
    fetch('get-payment-history.php?credit_payment_id=' + creditPaymentId)
        .then(response => response.json())
        .then(data => {
            const container = document.getElementById('paymentHistoryContent');
            if (data.success && data.payments.length > 0) {
                let html = `
                    <div class="table-responsive">
                        <table class="table table-sm table-hover">
                            <thead>
                                <tr>
                                    <th>Date</th>
                                    <th>Amount</th>
                                    <th>Method</th>
                                    <th>Reference</th>
                                    <th>Notes</th>
                                </tr>
                            </thead>
                            <tbody>
                `;
                
                data.payments.forEach(payment => {
                    html += `
                        <tr>
                            <td>${new Date(payment.payment_date).toLocaleDateString()}</td>
                            <td class="text-success">₹${parseFloat(payment.amount_paid).toLocaleString('en-IN', {minimumFractionDigits: 2})}</td>
                            <td><span class="badge bg-info text-capitalize">${payment.payment_method}</span></td>
                            <td><small class="text-muted">${payment.reference_number || 'N/A'}</small></td>
                            <td><small>${payment.notes || 'No notes'}</small></td>
                        </tr>
                    `;
                });
                
                html += `
                            </tbody>
                        </table>
                    </div>
                    <div class="mt-3 p-3 bg-light rounded">
                        <strong>Total Paid:</strong> ₹${data.total_paid.toLocaleString('en-IN', {minimumFractionDigits: 2})}
                    </div>
                `;
                
                container.innerHTML = html;
            } else {
                container.innerHTML = '<div class="alert alert-info text-center">No payment history found.</div>';
            }
        })
        .catch(error => {
            console.error('Error loading payment history:', error);
            document.getElementById('paymentHistoryContent').innerHTML = '<div class="alert alert-danger">Error loading payment history.</div>';
        });
}

// Update credit limit
function updateCreditLimit(customerId, currentLimit) {
    document.getElementById('limit_customer_id').value = customerId;
    document.getElementById('limit_credit_limit').value = currentLimit;
    
    // Fetch customer details
    fetch('get-customer-details.php?id=' + customerId)
        .then(response => response.json())
        .then(data => {
            if (data.success) {
                document.getElementById('limit_customer_name').value = data.customer.customer_name;
                document.getElementById('limit_current_balance').value = '₹' + parseFloat(data.customer.outstanding_balance).toLocaleString('en-IN', {minimumFractionDigits: 2});
            }
        })
        .catch(error => {
            console.error('Error loading customer details:', error);
        });
}

// Generate credit report
function generateCreditReport() {
    fetch('generate-credit-report.php')
        .then(response => response.json())
        .then(data => {
            const container = document.getElementById('creditReportContent');
            if (data.success) {
                container.innerHTML = data.html;
            } else {
                container.innerHTML = '<div class="alert alert-danger">Error generating report.</div>';
            }
        })
        .catch(error => {
            console.error('Error generating report:', error);
            document.getElementById('creditReportContent').innerHTML = '<div class="alert alert-danger">Error generating credit report.</div>';
        });
}

// Print credit report
function printCreditReport() {
    const printWindow = window.open('', '_blank');
    const content = document.getElementById('creditReportContent').innerHTML;
    
    printWindow.document.write(`
        <!DOCTYPE html>
        <html>
        <head>
            <title>Credit Management Report</title>
            <style>
                body { font-family: Arial, sans-serif; margin: 20px; }
                .table { width: 100%; border-collapse: collapse; }
                .table th, .table td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                .table th { background-color: #f8f9fa; }
                .text-success { color: #198754; }
                .text-danger { color: #dc3545; }
                .text-warning { color: #ffc107; }
                .badge { padding: 4px 8px; border-radius: 4px; font-size: 12px; }
                .bg-success { background-color: #198754; color: white; }
                .bg-warning { background-color: #ffc107; color: black; }
                .bg-danger { background-color: #dc3545; color: white; }
            </style>
        </head>
        <body>
            <h2>Credit Management Report</h2>
            <p>Generated on: ${new Date().toLocaleString()}</p>
            ${content}
        </body>
        </html>
    `);
    
    printWindow.document.close();
    printWindow.print();
}

// Auto-generate report when modal is shown
document.getElementById('creditReportModal').addEventListener('show.bs.modal', function () {
    generateCreditReport();
});
</script>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: customers-credit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation