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/vkmobiles/admin

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: reports-customer.php

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

// Check if user is logged in as branch
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Get branch ID from session
$branch_id = $_SESSION['branch_id'];

// Get branch info for display
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = $branch_id";
$branch_result = $conn->query($branch_sql);
$branch_info = $branch_result->fetch_assoc();

// Get filter parameters
$customer_filter = isset($_GET['customer']) ? intval($_GET['customer']) : '';
$status_filter = isset($_GET['status']) ? $_GET['status'] : '';
$outstanding_filter = isset($_GET['outstanding']) ? $_GET['outstanding'] : '';
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';
$report_type = isset($_GET['report_type']) ? $_GET['report_type'] : 'customer_summary';

// Get summary statistics for the branch
$total_customers_sql = "SELECT COUNT(DISTINCT s.customer_id) as total 
                       FROM sales s 
                       WHERE s.branch_id = $branch_id 
                       AND s.customer_id IS NOT NULL";
$total_customers = $conn->query($total_customers_sql)->fetch_assoc()['total'];

$total_outstanding_sql = "SELECT SUM(s.due_amount) as total_outstanding 
                         FROM sales s 
                         WHERE s.branch_id = $branch_id 
                         AND s.payment_status IN ('partial', 'due')";
$total_outstanding = $conn->query($total_outstanding_sql)->fetch_assoc()['total_outstanding'] ?? 0;

$customers_with_credit_sql = "SELECT COUNT(DISTINCT s.customer_id) as credit_customers 
                             FROM sales s 
                             WHERE s.branch_id = $branch_id 
                             AND s.due_amount > 0";
$customers_with_credit = $conn->query($customers_with_credit_sql)->fetch_assoc()['credit_customers'];

// Top customers by purchases in this branch
$top_customers_sql = "SELECT c.id, c.customer_name, 
                             SUM(s.total_amount) as total_purchases,
                             SUM(s.paid_amount) as total_paid,
                             SUM(s.due_amount) as outstanding_balance
                      FROM sales s
                      LEFT JOIN customers c ON s.customer_id = c.id
                      WHERE s.branch_id = $branch_id 
                      AND s.status = 'completed'
                      AND s.customer_id IS NOT NULL
                      GROUP BY s.customer_id
                      ORDER BY total_purchases DESC 
                      LIMIT 5";
$top_customers = $conn->query($top_customers_sql);
?>

<!doctype html>
<html lang="en">

<?php include('includes/head.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="main-content">
        <div class="page-content">
            <div class="container-fluid">

<div class="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-store-alt me-2"></i>
                                <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                <span class="badge bg-primary"><?php echo $branch_info['branch_code']; ?></span>
                            </h4>
                            <p class="text-muted mb-0">
                                <i class="fas fa-info-circle me-1"></i>
                                Viewing customer reports for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="customers-manage.php" class="btn btn-primary">
                                <i class="fas fa-users me-2"></i>Manage Customers
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $total_customers; ?></h4>
                                        <p class="mb-0">Branch Customers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-users display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            // Get total purchases for this branch
                                            $total_purchases_sql = "SELECT SUM(total_amount) as total 
                                                                  FROM sales 
                                                                  WHERE branch_id = $branch_id 
                                                                  AND status = 'completed'";
                                            $total_purchases = $conn->query($total_purchases_sql)->fetch_assoc()['total'] ?? 0;
                                            echo '₹' . number_format($total_purchases, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Purchases</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">₹<?php echo number_format($total_outstanding, 2); ?></h4>
                                        <p class="mb-0">Total Outstanding</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-bill-wave display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $customers_with_credit; ?></h4>
                                        <p class="mb-0">Credit Customers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-credit-card display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-4">
                    <div class="col-lg-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">Branch Customer Analytics Dashboard</h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                            <i class="fas fa-file-excel me-2"></i>Export to Excel
                                        </button>
                                        <button type="button" class="btn btn-danger" onclick="window.print()">
                                            <i class="fas fa-print me-2"></i>Print Report
                                        </button>
                                        <a href="customers-manage.php" class="btn btn-outline-primary">
                                            <i class="fas fa-users me-2"></i>Manage Customers
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<form method="GET" action="" id="reportForm">
                                    <div class="row mb-4">
                                        <div class="col-12">
                                            <div class="btn-group w-100" role="group">
                                                <input type="radio" class="btn-check" name="report_type" id="customer_summary" value="customer_summary" <?php echo $report_type == 'customer_summary' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-primary" for="customer_summary">Customer Summary</label>

<input type="radio" class="btn-check" name="report_type" id="credit_customers" value="credit_customers" <?php echo $report_type == 'credit_customers' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-warning" for="credit_customers">Credit Customers</label>

<input type="radio" class="btn-check" name="report_type" id="customer_sales" value="customer_sales" <?php echo $report_type == 'customer_sales' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-info" for="customer_sales">Sales History</label>

<input type="radio" class="btn-check" name="report_type" id="payment_history" value="payment_history" <?php echo $report_type == 'payment_history' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-success" for="payment_history">Payment History</label>
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label class="form-label">Customer</label>
                                                <select class="form-select" name="customer" onchange="this.form.submit()">
                                                    <option value="">All Customers</option>
                                                    <?php
                                                    // Get only customers who have made purchases in this branch
                                                    $customer_sql = "SELECT DISTINCT c.id, c.customer_name, c.customer_phone 
                                                                   FROM customers c
                                                                   INNER JOIN sales s ON c.id = s.customer_id
                                                                   WHERE s.branch_id = $branch_id 
                                                                   ORDER BY c.customer_name";
                                                    $customer_result = $conn->query($customer_sql);
                                                    while($customer = $customer_result->fetch_assoc()) {
                                                        $selected = ($customer_filter == $customer['id']) ? 'selected' : '';
                                                        echo '<option value="' . $customer['id'] . '" ' . $selected . '>' . 
                                                             htmlspecialchars($customer['customer_name']) . ' (' . 
                                                             htmlspecialchars($customer['customer_phone']) . ')</option>';
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Status</label>
                                                <select class="form-select" name="status" onchange="this.form.submit()">
                                                    <option value="">All Status</option>
                                                    <option value="active" <?php echo ($status_filter == 'active') ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo ($status_filter == 'inactive') ? 'selected' : ''; ?>>Inactive</option>
                                                    <option value="blocked" <?php echo ($status_filter == 'blocked') ? 'selected' : ''; ?>>Blocked</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Outstanding</label>
                                                <select class="form-select" name="outstanding" onchange="this.form.submit()">
                                                    <option value="">All</option>
                                                    <option value="with_credit" <?php echo ($outstanding_filter == 'with_credit') ? 'selected' : ''; ?>>With Credit</option>
                                                    <option value="no_credit" <?php echo ($outstanding_filter == 'no_credit') ? 'selected' : ''; ?>>No Credit</option>
                                                    <option value="overdue" <?php echo ($outstanding_filter == 'overdue') ? 'selected' : ''; ?>>Overdue</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Date From</label>
                                                <input type="date" class="form-control" name="date_from" value="<?php echo htmlspecialchars($date_from); ?>" onchange="this.form.submit()">
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Date To</label>
                                                <input type="date" class="form-control" name="date_to" value="<?php echo htmlspecialchars($date_to); ?>" onchange="this.form.submit()">
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-12">
                                            <div class="d-flex gap-2 flex-wrap">
                                                <a href="reports-customer.php" class="btn btn-outline-secondary">
                                                    <i class="fas fa-times me-2"></i>Clear Filters
                                                </a>
                                                <div class="ms-auto">
                                                    <span class="badge bg-info" id="reportSummary">
                                                        <?php
                                                        // Generate summary text based on report type
                                                        switch($report_type) {
                                                            case 'customer_summary':
                                                                echo "Branch Customer Summary Report";
                                                                break;
                                                            case 'credit_customers':
                                                                echo "Branch Credit Customers Report";
                                                                break;
                                                            case 'customer_sales':
                                                                echo "Branch Customer Sales History";
                                                                break;
                                                            case 'payment_history':
                                                                echo "Branch Payment History Report";
                                                                break;
                                                        }
                                                        ?>
                                                    </span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </form>

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">
                                                    <i class="fas fa-trophy me-2"></i>Top 5 Customers in Your Branch
                                                </h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="row">
                                                    <?php if ($top_customers->num_rows > 0): 
                                                        $rank = 1;
                                                        while($customer = $top_customers->fetch_assoc()): 
                                                            $progress = $customer['total_purchases'] > 0 ? ($customer['total_paid'] / $customer['total_purchases']) * 100 : 0;
                                                    ?>
                                                    <div class="col-md-6 col-lg-4 col-xl">
                                                        <div class="card mb-3">
                                                            <div class="card-body">
                                                                <div class="d-flex align-items-center">
                                                                    <div class="flex-shrink-0">
                                                                        <div class="avatar-sm">
                                                                            <span class="avatar-title bg-primary rounded-circle font-size-16">
                                                                                <?php echo $rank; ?>
                                                                            </span>
                                                                        </div>
                                                                    </div>
                                                                    <div class="flex-grow-1 ms-3">
                                                                        <h6 class="mb-1"><?php echo htmlspecialchars($customer['customer_name']); ?></h6>
                                                                        <p class="text-muted mb-1">₹<?php echo number_format($customer['total_purchases'], 2); ?></p>
                                                                        <div class="progress progress-sm">
                                                                            <div class="progress-bar bg-success" role="progressbar" style="width: <?php echo $progress; ?>%" aria-valuenow="<?php echo $progress; ?>" aria-valuemin="0" aria-valuemax="100"></div>
                                                                        </div>
                                                                        <small class="text-muted">Paid: ₹<?php echo number_format($customer['total_paid'], 2); ?></small>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <?php 
                                                        $rank++;
                                                        endwhile; 
                                                    else: ?>
                                                    <div class="col-12 text-center py-3">
                                                        <p class="text-muted mb-0">No customer data available for your branch</p>
                                                    </div>
                                                    <?php endif; ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row">
                                    <div class="col-12">
                                        <div id="reportContent">
                                            <?php
                                            // Display the appropriate report based on report type
                                            switch($report_type) {
                                                case 'credit_customers':
                                                    displayCreditCustomersReport($conn, $customer_filter, $status_filter, $outstanding_filter, $branch_id);
                                                    break;
                                                case 'customer_sales':
                                                    displayCustomerSalesReport($conn, $customer_filter, $date_from, $date_to, $branch_id);
                                                    break;
                                                case 'payment_history':
                                                    displayPaymentHistoryReport($conn, $customer_filter, $date_from, $date_to, $branch_id);
                                                    break;
                                                case 'customer_summary':
                                                default:
                                                    displayCustomerSummaryReport($conn, $customer_filter, $status_filter, $outstanding_filter, $branch_id);
                                                    break;
                                            }
                                            ?>
                                        </div>
                                    </div>
                                </div>

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

</div>
            
        </div>

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

</div>

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

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

// Auto-refresh page every 5 minutes
setInterval(() => {
    window.location.reload();
}, 300000);
</script>

</body>
</html>

<?php
// Report Display Functions

function displayCustomerSummaryReport($conn, $customer_filter, $status_filter, $outstanding_filter, $branch_id) {
    // Build where conditions
    $where_conditions = ["s.branch_id = $branch_id", "s.status = 'completed'"];
    $params = [];
    $param_types = '';

if ($customer_filter) {
        $where_conditions[] = "s.customer_id = ?";
        $params[] = $customer_filter;
        $param_types .= 'i';
    }

$where_sql = implode(" AND ", $where_conditions);

// Get customers with their purchase history in this branch
    $sql = "SELECT c.*, 
                   SUM(s.total_amount) as total_purchases,
                   SUM(s.paid_amount) as total_paid,
                   SUM(s.due_amount) as outstanding_balance,
                   COUNT(s.id) as total_sales,
                   MAX(s.sale_date) as last_purchase_date
            FROM customers c
            INNER JOIN sales s ON c.id = s.customer_id
            WHERE $where_sql 
            GROUP BY c.id
            ORDER BY total_purchases DESC, c.customer_name ASC";

if ($params) {
        $stmt = $conn->prepare($sql);
        $stmt->bind_param($param_types, ...$params);
        $stmt->execute();
        $result = $stmt->get_result();
    } else {
        $result = $conn->query($sql);
    }

$total_customers = 0;
    $total_purchases = 0;
    $total_outstanding = 0;
    $total_paid = 0;
    ?>
    
    <div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-users me-2"></i>Branch Customer Summary Report
                <small class="text-muted">(Only customers who purchased from your branch)</small>
            </h5>
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $result->num_rows; ?></h4>
                                        <p class="mb-0">Branch Customers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-users display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_purchases_sql = "SELECT SUM(total_amount) as total 
                                                                  FROM sales 
                                                                  WHERE branch_id = $branch_id 
                                                                  AND status = 'completed'";
                                            $total_purchases_result = $conn->query($total_purchases_sql);
                                            echo '₹' . number_format($total_purchases_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Purchases</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_outstanding_sql = "SELECT SUM(due_amount) as total 
                                                                    FROM sales 
                                                                    WHERE branch_id = $branch_id 
                                                                    AND status = 'completed'";
                                            $total_outstanding_result = $conn->query($total_outstanding_sql);
                                            echo '₹' . number_format($total_outstanding_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Outstanding</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-bill-wave display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $credit_customers_sql = "SELECT COUNT(DISTINCT customer_id) as count 
                                                                   FROM sales 
                                                                   WHERE branch_id = $branch_id 
                                                                   AND due_amount > 0";
                                            $credit_customers_result = $conn->query($credit_customers_sql);
                                            echo $credit_customers_result->fetch_assoc()['count'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Credit Customers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-credit-card display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

// Payment ratio
                                $payment_ratio = $customer['total_purchases'] > 0 ? ($customer['total_paid'] / $customer['total_purchases']) * 100 : 100;
                                $payment_class = $payment_ratio >= 100 ? 'text-success' : ($payment_ratio >= 50 ? 'text-warning' : 'text-danger');
                            ?>
                            <tr class="<?php echo $customer_class; ?>">
                                <td>
                                    <strong><?php echo htmlspecialchars($customer['customer_name']); ?></strong>
                                    <?php if ($customer['total_purchases'] > 100000): ?>
                                        <span class="badge bg-success ms-1">VIP</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <div><?php echo htmlspecialchars($customer['customer_phone']); ?></div>
                                    <?php if ($customer['customer_email']): ?>
                                        <small class="text-muted"><?php echo htmlspecialchars($customer['customer_email']); ?></small>
                                    <?php endif; ?>
                                </td>
                                <td class="text-center">
                                    <span class="badge bg-secondary"><?php echo $customer['total_sales']; ?></span>
                                </td>
                                <td class="text-end">₹<?php echo number_format($customer['total_purchases'], 2); ?></td>
                                <td class="text-end">₹<?php echo number_format($customer['total_paid'], 2); ?></td>
                                <td class="text-end">
                                    <?php if ($customer['outstanding_balance'] > 0): ?>
                                        <span class="text-danger fw-bold">₹<?php echo number_format($customer['outstanding_balance'], 2); ?></span>
                                    <?php else: ?>
                                        <span class="text-success">₹0.00</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <div class="d-flex align-items-center">
                                        <div class="flex-grow-1 me-3">
                                            <div class="progress progress-sm">
                                                <div class="progress-bar 
                                                    <?php echo $payment_ratio >= 100 ? 'bg-success' : 
                                                           ($payment_ratio >= 50 ? 'bg-warning' : 'bg-danger'); ?>" 
                                                    role="progressbar" 
                                                    style="width: <?php echo min($payment_ratio, 100); ?>%" 
                                                    aria-valuenow="<?php echo $payment_ratio; ?>" 
                                                    aria-valuemin="0" 
                                                    aria-valuemax="100">
                                                </div>
                                            </div>
                                        </div>
                                        <div class="flex-shrink-0">
                                            <span class="<?php echo $payment_class; ?> fw-bold">
                                                <?php echo number_format($payment_ratio, 1); ?>%
                                            </span>
                                        </div>
                                    </div>
                                </td>
                                <td>
                                    <small class="text-muted"><?php echo $customer['last_purchase_date'] ? date('M j, Y', strtotime($customer['last_purchase_date'])) : 'Never'; ?></small>
                                </td>
                                <td>
                                    <div class="btn-group btn-group-sm">
                                        <a href="customer-details.php?id=<?php echo $customer['id']; ?>" class="btn btn-outline-primary" title="View Customer">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                        <a href="sales-add.php?customer_id=<?php echo $customer['id']; ?>" class="btn btn-outline-success" title="New Sale">
                                            <i class="fas fa-cart-plus"></i>
                                        </a>
                                        <?php if ($customer['outstanding_balance'] > 0): ?>
                                            <a href="credit-payments.php?customer_id=<?php echo $customer['id']; ?>" class="btn btn-outline-warning" title="Collect Payment">
                                                <i class="fas fa-money-bill"></i>
                                            </a>
                                        <?php endif; ?>
                                    </div>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="3" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_purchases, 2); ?></strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_paid, 2); ?></strong></td>
                                <td class="text-end"><strong class="text-danger">₹<?php echo number_format($total_outstanding, 2); ?></strong></td>
                                <td colspan="3">
                                    <small class="text-muted">
                                        Branch Customers: <?php echo $total_customers; ?> | 
                                        Total Purchases: ₹<?php echo number_format($total_purchases, 2); ?> | 
                                        Total Outstanding: ₹<?php echo number_format($total_outstanding, 2); ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-users display-4 text-muted"></i>
                    <h5 class="mt-3">No Customers Found</h5>
                    <p class="text-muted">No customers have made purchases in your branch yet.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

function displayCreditCustomersReport($conn, $customer_filter, $status_filter, $outstanding_filter, $branch_id) {
    // Build where conditions for credit customers in this branch
    $where_conditions = ["s.branch_id = $branch_id", "s.status = 'completed'", "s.due_amount > 0"];
    $params = [];
    $param_types = '';

if ($customer_filter) {
        $where_conditions[] = "s.customer_id = ?";
        $params[] = $customer_filter;
        $param_types .= 'i';
    }

$where_sql = implode(" AND ", $where_conditions);

// Get credit customers for this branch
    $sql = "SELECT c.*, 
                   SUM(s.total_amount) as total_purchases,
                   SUM(s.due_amount) as outstanding_balance,
                   COUNT(s.id) as pending_invoices,
                   MAX(s.sale_date) as last_purchase_date
            FROM customers c
            INNER JOIN sales s ON c.id = s.customer_id
            WHERE $where_sql 
            GROUP BY c.id
            ORDER BY outstanding_balance DESC, c.customer_name ASC";

$total_credit = 0;
    $total_customers = 0;
    ?>

<div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-exclamation-triangle me-2"></i>Branch Credit Customers Report
            </h5>
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $result->num_rows; ?></h4>
                                        <p class="mb-0">Credit Customers</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-users display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-danger text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_credit_sql = "SELECT SUM(due_amount) as total 
                                                               FROM sales 
                                                               WHERE branch_id = $branch_id 
                                                               AND due_amount > 0";
                                            $total_credit_result = $conn->query($total_credit_sql);
                                            echo '₹' . number_format($total_credit_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Credit</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-bill-wave display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-dark text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $pending_invoices_sql = "SELECT COUNT(*) as count 
                                                                   FROM sales 
                                                                   WHERE branch_id = $branch_id 
                                                                   AND due_amount > 0";
                                            $pending_invoices_result = $conn->query($pending_invoices_sql);
                                            echo $pending_invoices_result->fetch_assoc()['count'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Pending Invoices</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-file-invoice display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $overdue_sql = "SELECT COUNT(*) as count 
                                                          FROM sales 
                                                          WHERE branch_id = $branch_id 
                                                          AND due_amount > 0 
                                                          AND payment_status = 'overdue'";
                                            $overdue_result = $conn->query($overdue_sql);
                                            echo $overdue_result->fetch_assoc()['count'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Overdue Invoices</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-clock display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>Customer</th>
                                <th>Contact</th>
                                <th>Pending Invoices</th>
                                <th>Total Purchases</th>
                                <th>Outstanding</th>
                                <th>Last Purchase</th>
                                <th>Credit Status</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php while($customer = $result->fetch_assoc()): 
                                $total_customers++;
                                $total_credit += $customer['outstanding_balance'];
                                
                                // Status and styling
                                $row_class = 'customer-credit-risk';
                            ?>
                            <tr class="<?php echo $row_class; ?>">
                                <td>
                                    <strong><?php echo htmlspecialchars($customer['customer_name']); ?></strong>
                                    <?php if ($customer['outstanding_balance'] > 50000): ?>
                                        <span class="badge bg-danger ms-1">High Risk</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <div><?php echo htmlspecialchars($customer['customer_phone']); ?></div>
                                    <?php if ($customer['customer_email']): ?>
                                        <small class="text-muted"><?php echo htmlspecialchars($customer['customer_email']); ?></small>
                                    <?php endif; ?>
                                </td>
                                <td class="text-center">
                                    <span class="badge bg-warning"><?php echo $customer['pending_invoices']; ?> invoices</span>
                                </td>
                                <td class="text-end">₹<?php echo number_format($customer['total_purchases'], 2); ?></td>
                                <td class="text-end">
                                    <span class="text-danger fw-bold">₹<?php echo number_format($customer['outstanding_balance'], 2); ?></span>
                                </td>
                                <td>
                                    <small class="text-muted"><?php echo $customer['last_purchase_date'] ? date('M j, Y', strtotime($customer['last_purchase_date'])) : 'Never'; ?></small>
                                </td>
                                <td>
                                    <span class="badge bg-danger">Credit Due</span>
                                </td>
                                <td>
                                    <div class="btn-group btn-group-sm">
                                        <a href="credit-payments.php?customer_id=<?php echo $customer['id']; ?>" class="btn btn-success" title="Collect Payment">
                                            <i class="fas fa-money-bill"></i>
                                        </a>
                                        <a href="customer-details.php?id=<?php echo $customer['id']; ?>" class="btn btn-outline-primary" title="View Customer">
                                            <i class="fas fa-eye"></i>
                                        </a>
                                    </div>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="4" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong class="text-danger">₹<?php echo number_format($total_credit, 2); ?></strong></td>
                                <td colspan="3">
                                    <small class="text-muted">
                                        Credit Customers in Branch: <?php echo $total_customers; ?> | 
                                        Total Outstanding: ₹<?php echo number_format($total_credit, 2); ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-check-circle display-4 text-success"></i>
                    <h5 class="mt-3">No Credit Customers</h5>
                    <p class="text-muted">All customers have cleared their outstanding balances in your branch.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

function displayCustomerSalesReport($conn, $customer_filter, $date_from, $date_to, $branch_id) {
    // Build where conditions
    $where_conditions = ["s.branch_id = $branch_id", "s.status = 'completed'"];
    $params = [];
    $param_types = '';

if ($customer_filter) {
        $where_conditions[] = "s.customer_id = ?";
        $params[] = $customer_filter;
        $param_types .= 'i';
    }

if ($date_from) {
        $where_conditions[] = "DATE(s.sale_date) >= ?";
        $params[] = $date_from;
        $param_types .= 's';
    }

if ($date_to) {
        $where_conditions[] = "DATE(s.sale_date) <= ?";
        $params[] = $date_to;
        $param_types .= 's';
    }

$where_sql = implode(" AND ", $where_conditions);

// Prepare and execute query
    $sql = "SELECT s.*, c.customer_name, c.customer_phone,
                   (SELECT COUNT(*) FROM sale_items WHERE sale_id = s.id) as item_count
            FROM sales s
            LEFT JOIN customers c ON s.customer_id = c.id
            WHERE $where_sql 
            ORDER BY s.sale_date DESC";

$total_sales = 0;
    $total_amount = 0;
    $total_paid = 0;
    $total_due = 0;
    ?>

<div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-shopping-cart me-2"></i>Branch Customer Sales History
            </h5>
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $result->num_rows; ?></h4>
                                        <p class="mb-0">Branch Sales</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_amount_sql = "SELECT SUM(total_amount) as total FROM sales WHERE $where_sql";
                                            $total_amount_result = $conn->query($total_amount_sql);
                                            echo '₹' . number_format($total_amount_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Amount</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-rupee-sign display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_paid_sql = "SELECT SUM(paid_amount) as total FROM sales WHERE $where_sql";
                                            $total_paid_result = $conn->query($total_paid_sql);
                                            echo '₹' . number_format($total_paid_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Paid</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-check display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_due_sql = "SELECT SUM(due_amount) as total FROM sales WHERE $where_sql";
                                            $total_due_result = $conn->query($total_due_sql);
                                            echo '₹' . number_format($total_due_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Due</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-clock display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>Sale Number</th>
                                <th>Customer</th>
                                <th>Sale Date</th>
                                <th>Items</th>
                                <th>Total Amount</th>
                                <th>Paid Amount</th>
                                <th>Due Amount</th>
                                <th>Payment Type</th>
                                <th>Payment Status</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php while($sale = $result->fetch_assoc()): 
                                $total_sales++;
                                $total_amount += $sale['total_amount'];
                                $total_paid += $sale['paid_amount'];
                                $total_due += $sale['due_amount'];
                                
                                // Payment status styling
                                $payment_status_class = '';
                                if ($sale['payment_status'] == 'paid') {
                                    $payment_status_class = 'bg-success';
                                } elseif ($sale['payment_status'] == 'partial') {
                                    $payment_status_class = 'bg-warning';
                                } else {
                                    $payment_status_class = 'bg-danger';
                                }
                            ?>
                            <tr>
                                <td>
                                    <strong class="text-primary"><?php echo $sale['sale_number']; ?></strong>
                                </td>
                                <td>
                                    <div><?php echo htmlspecialchars($sale['customer_name']); ?></div>
                                    <small class="text-muted"><?php echo htmlspecialchars($sale['customer_phone']); ?></small>
                                </td>
                                <td><?php echo date('M j, Y', strtotime($sale['sale_date'])); ?></td>
                                <td>
                                    <span class="badge bg-secondary"><?php echo $sale['item_count']; ?> items</span>
                                </td>
                                <td class="text-end">₹<?php echo number_format($sale['total_amount'], 2); ?></td>
                                <td class="text-end">
                                    <span class="text-success">₹<?php echo number_format($sale['paid_amount'], 2); ?></span>
                                </td>
                                <td class="text-end">
                                    <?php if ($sale['due_amount'] > 0): ?>
                                        <span class="text-danger fw-bold">₹<?php echo number_format($sale['due_amount'], 2); ?></span>
                                    <?php else: ?>
                                        <span class="text-success">₹0.00</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <span class="badge bg-info"><?php echo ucfirst($sale['payment_type']); ?></span>
                                </td>
                                <td>
                                    <span class="badge <?php echo $payment_status_class; ?>">
                                        <?php echo ucfirst($sale['payment_status']); ?>
                                    </span>
                                </td>
                                <td>
                                    <a href="sales-view.php?id=<?php echo $sale['id']; ?>" class="btn btn-sm btn-outline-primary">
                                        <i class="fas fa-eye"></i> View
                                    </a>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="4" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_amount, 2); ?></strong></td>
                                <td class="text-end"><strong class="text-success">₹<?php echo number_format($total_paid, 2); ?></strong></td>
                                <td class="text-end"><strong class="text-danger">₹<?php echo number_format($total_due, 2); ?></strong></td>
                                <td colspan="3">
                                    <small class="text-muted">
                                        Branch Sales: <?php echo $total_sales; ?> | 
                                        Total Amount: ₹<?php echo number_format($total_amount, 2); ?> | 
                                        Collection Rate: <?php echo $total_amount > 0 ? number_format(($total_paid / $total_amount) * 100, 1) : 0; ?>%
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-shopping-cart display-4 text-muted"></i>
                    <h5 class="mt-3">No Sales Found</h5>
                    <p class="text-muted">No sales match your current filter criteria in your branch.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

function displayPaymentHistoryReport($conn, $customer_filter, $date_from, $date_to, $branch_id) {
    // Build where conditions - Note: credit_payment_transactions may not have branch_id
    $where_conditions = ["1=1"];
    $params = [];
    $param_types = '';

if ($customer_filter) {
        $where_conditions[] = "cpt.customer_id = ?";
        $params[] = $customer_filter;
        $param_types .= 'i';
    }

if ($date_from) {
        $where_conditions[] = "DATE(cpt.payment_date) >= ?";
        $params[] = $date_from;
        $param_types .= 's';
    }

if ($date_to) {
        $where_conditions[] = "DATE(cpt.payment_date) <= ?";
        $params[] = $date_to;
        $param_types .= 's';
    }

$where_sql = implode(" AND ", $where_conditions);

// Note: This query may need adjustment based on your database structure
    // If credit_payment_transactions has branch_id, add it to the WHERE clause
    $sql = "SELECT cpt.*, c.customer_name, c.customer_phone, cp.due_amount, cp.remaining_amount
            FROM credit_payment_transactions cpt
            LEFT JOIN customers c ON cpt.customer_id = c.id
            LEFT JOIN credit_payments cp ON cpt.credit_payment_id = cp.id
            WHERE $where_sql 
            ORDER BY cpt.payment_date DESC";

$total_payments = 0;
    $total_amount = 0;
    ?>

<div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-money-check me-2"></i>Branch Payment History Report
                <small class="text-muted">(Note: Payments may not be branch-specific in current setup)</small>
            </h5>
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-4">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $result->num_rows; ?></h4>
                                        <p class="mb-0">Total Payments</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-check display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_amount_sql = "SELECT SUM(amount_paid) as total FROM credit_payment_transactions WHERE $where_sql";
                                            $total_amount_result = $conn->query($total_amount_sql);
                                            echo '₹' . number_format($total_amount_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Collected</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-rupee-sign display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $cash_payments_sql = "SELECT SUM(amount_paid) as total FROM credit_payment_transactions WHERE $where_sql AND payment_method = 'cash'";
                                            $cash_payments_result = $conn->query($cash_payments_sql);
                                            echo '₹' . number_format($cash_payments_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Cash Payments</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-bill display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>Payment Date</th>
                                <th>Customer</th>
                                <th>Amount Paid</th>
                                <th>Payment Method</th>
                                <th>Reference Number</th>
                                <th>Due Amount</th>
                                <th>Remaining</th>
                                <th>Notes</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php while($payment = $result->fetch_assoc()): 
                                $total_payments++;
                                $total_amount += $payment['amount_paid'];
                            ?>
                            <tr>
                                <td>
                                    <?php echo date('M j, Y', strtotime($payment['payment_date'])); ?>
                                    <br><small class="text-muted"><?php echo date('g:i A', strtotime($payment['payment_date'])); ?></small>
                                </td>
                                <td>
                                    <div><?php echo htmlspecialchars($payment['customer_name']); ?></div>
                                    <small class="text-muted"><?php echo htmlspecialchars($payment['customer_phone']); ?></small>
                                </td>
                                <td class="text-end">
                                    <span class="text-success fw-bold">₹<?php echo number_format($payment['amount_paid'], 2); ?></span>
                                </td>
                                <td>
                                    <span class="badge bg-info"><?php echo ucfirst(str_replace('_', ' ', $payment['payment_method'])); ?></span>
                                </td>
                                <td>
                                    <?php if ($payment['reference_number']): ?>
                                        <code><?php echo htmlspecialchars($payment['reference_number']); ?></code>
                                    <?php else: ?>
                                        <span class="text-muted">-</span>
                                    <?php endif; ?>
                                </td>
                                <td class="text-end">₹<?php echo number_format($payment['due_amount'] ?? 0, 2); ?></td>
                                <td class="text-end">
                                    <?php if ($payment['remaining_amount'] > 0): ?>
                                        <span class="text-warning">₹<?php echo number_format($payment['remaining_amount'], 2); ?></span>
                                    <?php else: ?>
                                        <span class="text-success">₹0.00</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <?php if ($payment['notes']): ?>
                                        <small class="text-muted"><?php echo htmlspecialchars($payment['notes']); ?></small>
                                    <?php else: ?>
                                        <span class="text-muted">-</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="2" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong class="text-success">₹<?php echo number_format($total_amount, 2); ?></strong></td>
                                <td colspan="5">
                                    <small class="text-muted">
                                        Total Payments: <?php echo $total_payments; ?> | 
                                        Total Amount Collected: ₹<?php echo number_format($total_amount, 2); ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-money-check display-4 text-muted"></i>
                    <h5 class="mt-3">No Payment History</h5>
                    <p class="text-muted">No payment records match your current filter criteria.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reports-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation