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-sales.php

<?php
session_start();
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();

// Set default date range (last 30 days)
$end_date = date('Y-m-d');
$start_date = date('Y-m-d', strtotime('-30 days'));

// Handle date filter
if (isset($_GET['start_date']) && !empty($_GET['start_date'])) {
    $start_date = $conn->real_escape_string($_GET['start_date']);
}

if (isset($_GET['end_date']) && !empty($_GET['end_date'])) {
    $end_date = $conn->real_escape_string($_GET['end_date']);
}

// Handle payment status filter
$payment_status_filter = isset($_GET['payment_status']) ? $conn->real_escape_string($_GET['payment_status']) : '';

// Handle payment type filter
$payment_type_filter = isset($_GET['payment_type']) ? $conn->real_escape_string($_GET['payment_type']) : '';

// Handle export request
if (isset($_GET['export']) && $_GET['export'] == 'csv') {
    exportSalesToCSV($conn, $start_date, $end_date, $payment_status_filter, $payment_type_filter, $branch_id);
}
?>

<!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">

<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 sales reports for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="sales-new.php" class="btn btn-primary">
                                <i class="fas fa-shopping-cart me-2"></i>New Sale
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-chart-line me-2"></i>Branch Sales Reports & Analytics
                                    </h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" onclick="printReport()">
                                            <i class="fas fa-print me-2"></i>Print Report
                                        </button>
                                        <a href="?export=csv&start_date=<?php echo $start_date; ?>&end_date=<?php echo $end_date; ?>&payment_status=<?php echo $payment_status_filter; ?>&payment_type=<?php echo $payment_type_filter; ?>" class="btn btn-outline-primary">
                                            <i class="fas fa-file-csv me-2"></i>Export CSV
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-4">
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card card-hover bg-primary text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Total Sales</h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-shopping-bag fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $total_sales_sql = "SELECT COUNT(*) as total_sales, COALESCE(SUM(total_amount), 0) as total_amount 
                                                                        FROM sales 
                                                                        WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' 
                                                                        AND status = 'completed'
                                                                        AND branch_id = $branch_id";
                                                    $total_sales_result = $conn->query($total_sales_sql);
                                                    $total_sales = $total_sales_result->fetch_assoc();
                                                    ?>
                                                    <h3 class="mb-1"><?php echo $total_sales['total_sales']; ?></h3>
                                                    <p class="mb-0">₹<?php echo number_format($total_sales['total_amount'], 2); ?></p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card card-hover bg-success text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Paid Amount</h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-money-bill-wave fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $paid_sales_sql = "SELECT COALESCE(SUM(paid_amount), 0) as total_paid 
                                                                       FROM sales 
                                                                       WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' 
                                                                       AND status = 'completed'
                                                                       AND branch_id = $branch_id";
                                                    $total_paid = $conn->query($paid_sales_sql)->fetch_assoc()['total_paid'];
                                                    ?>
                                                    <h3 class="mb-1">₹<?php echo number_format($total_paid, 2); ?></h3>
                                                    <p class="mb-0">Total collected</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card card-hover bg-warning text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Outstanding</h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-clock fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $outstanding_sql = "SELECT COALESCE(SUM(due_amount), 0) as total_outstanding 
                                                                        FROM sales 
                                                                        WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' 
                                                                        AND status = 'completed'
                                                                        AND branch_id = $branch_id";
                                                    $total_outstanding = $conn->query($outstanding_sql)->fetch_assoc()['total_outstanding'];
                                                    ?>
                                                    <h3 class="mb-1">₹<?php echo number_format($total_outstanding, 2); ?></h3>
                                                    <p class="mb-0">Pending collection</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-xl-3 col-md-6">
                                        <div class="card card-hover bg-info text-white">
                                            <div class="card-body">
                                                <div class="d-flex align-items-center">
                                                    <div class="flex-grow-1">
                                                        <h5 class="font-size-14 mb-0">Avg. Sale Value</h5>
                                                    </div>
                                                    <div class="flex-shrink-0">
                                                        <i class="fas fa-chart-bar fa-2x"></i>
                                                    </div>
                                                </div>
                                                <div class="mt-3">
                                                    <?php
                                                    $avg_sale_sql = "SELECT COALESCE(AVG(total_amount), 0) as avg_sale 
                                                                     FROM sales 
                                                                     WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' 
                                                                     AND status = 'completed'
                                                                     AND branch_id = $branch_id";
                                                    $avg_sale = $conn->query($avg_sale_sql)->fetch_assoc()['avg_sale'];
                                                    ?>
                                                    <h3 class="mb-1">₹<?php echo number_format($avg_sale, 2); ?></h3>
                                                    <p class="mb-0">Per transaction</p>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <label for="start_date" class="form-label">Start Date</label>
                                        <input type="date" class="form-control" id="start_date" name="start_date" value="<?php echo $start_date; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="end_date" class="form-label">End Date</label>
                                        <input type="date" class="form-control" id="end_date" name="end_date" value="<?php echo $end_date; ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label for="payment_status" class="form-label">Payment Status</label>
                                        <select class="form-select" id="payment_status" name="payment_status">
                                            <option value="">All Status</option>
                                            <option value="paid" <?php echo $payment_status_filter == 'paid' ? 'selected' : ''; ?>>Paid</option>
                                            <option value="partial" <?php echo $payment_status_filter == 'partial' ? 'selected' : ''; ?>>Partial</option>
                                            <option value="pending" <?php echo $payment_status_filter == 'pending' ? 'selected' : ''; ?>>Pending</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label for="payment_type" class="form-label">Payment Type</label>
                                        <select class="form-select" id="payment_type" name="payment_type">
                                            <option value="">All Types</option>
                                            <option value="cash" <?php echo $payment_type_filter == 'cash' ? 'selected' : ''; ?>>Cash</option>
                                            <option value="card" <?php echo $payment_type_filter == 'card' ? 'selected' : ''; ?>>Card</option>
                                            <option value="upi" <?php echo $payment_type_filter == 'upi' ? 'selected' : ''; ?>>UPI</option>
                                            <option value="credit" <?php echo $payment_type_filter == 'credit' ? 'selected' : ''; ?>>Credit</option>
                                            <option value="emi" <?php echo $payment_type_filter == 'emi' ? 'selected' : ''; ?>>EMI</option>
                                            <option value="bank_transfer" <?php echo $payment_type_filter == 'bank_transfer' ? 'selected' : ''; ?>>Bank Transfer</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2 d-flex align-items-end">
                                        <button type="button" class="btn btn-primary w-100" id="applyFilters">
                                            <i class="fas fa-filter me-2"></i>Apply Filters
                                        </button>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h5 class="card-title mb-0">Sales Summary by Payment Type</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered table-hover mb-0">
                                                        <thead class="table-light">
                                                            <tr>
                                                                <th>Payment Type</th>
                                                                <th>Number of Sales</th>
                                                                <th>Total Amount</th>
                                                                <th>Percentage</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                            $payment_summary_sql = "SELECT 
                                                                payment_type,
                                                                COUNT(*) as sale_count,
                                                                SUM(total_amount) as total_amount,
                                                                ROUND((SUM(total_amount) / (SELECT SUM(total_amount) FROM sales WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' AND status = 'completed' AND branch_id = $branch_id)) * 100, 2) as percentage
                                                                FROM sales 
                                                                WHERE sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59' 
                                                                AND status = 'completed'
                                                                AND branch_id = $branch_id
                                                                GROUP BY payment_type
                                                                ORDER BY total_amount DESC";
                                                            
                                                            $payment_summary_result = $conn->query($payment_summary_sql);
                                                            $total_sales_amount = $total_sales['total_amount'];
                                                            
                                                            if ($payment_summary_result->num_rows > 0) {
                                                                while($row = $payment_summary_result->fetch_assoc()) {
                                                                    echo "<tr>";
                                                                    echo "<td><span class='badge bg-primary'>" . ucfirst($row['payment_type']) . "</span></td>";
                                                                    echo "<td>" . $row['sale_count'] . "</td>";
                                                                    echo "<td>₹" . number_format($row['total_amount'], 2) . "</td>";
                                                                    echo "<td>";
                                                                    echo "<div class='progress' style='height: 20px;'>";
                                                                    echo "<div class='progress-bar' role='progressbar' style='width: " . $row['percentage'] . "%;' aria-valuenow='" . $row['percentage'] . "' aria-valuemin='0' aria-valuemax='100'>" . $row['percentage'] . "%</div>";
                                                                    echo "</div>";
                                                                    echo "</td>";
                                                                    echo "</tr>";
                                                                }
                                                            } else {
                                                                echo "<tr><td colspan='4' class='text-center'>No sales data found for the selected period</td></tr>";
                                                            }
                                                            ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped mb-0" id="salesTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Sale Details</th>
                                                <th>Customer Information</th>
                                                <th>Payment Information</th>
                                                <th>Amount Details</th>
                                                <th>Status</th>
                                                <th>Date</th>
                                                <th width="100">Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters
                                            $where_conditions = array();
                                            $where_conditions[] = "s.sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59'";
                                            $where_conditions[] = "s.status = 'completed'";
                                            $where_conditions[] = "s.branch_id = $branch_id"; // Branch filter added

// Payment status filter
                                            if (!empty($payment_status_filter)) {
                                                $where_conditions[] = "s.payment_status = '$payment_status_filter'";
                                            }

// Payment type filter
                                            if (!empty($payment_type_filter)) {
                                                $where_conditions[] = "s.payment_type = '$payment_type_filter'";
                                            }

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

// Get total count for pagination
                                            $count_sql = "SELECT COUNT(*) as total FROM sales s $where_sql";
                                            $count_result = $conn->query($count_sql);
                                            $total_sales = $count_result->fetch_assoc()['total'];

// Pagination
                                            $per_page = 10;
                                            $current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
                                            $offset = ($current_page - 1) * $per_page;
                                            $total_pages = ceil($total_sales / $per_page);

// Main query
                                            $sql = "SELECT s.*, 
                                                   (SELECT COUNT(*) FROM sale_items si WHERE si.sale_id = s.id) as item_count
                                                   FROM sales s 
                                                   $where_sql 
                                                   ORDER BY s.sale_date DESC 
                                                   LIMIT $offset, $per_page";
                                            
                                            $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                                while($sale = $result->fetch_assoc()) {
                                                    // Status badge
                                                    $payment_status_badge = [
                                                        'paid' => 'success',
                                                        'partial' => 'warning', 
                                                        'pending' => 'danger'
                                                    ];
                                                    
                                                    $payment_type_badge = [
                                                        'cash' => 'success',
                                                        'card' => 'primary',
                                                        'upi' => 'info',
                                                        'credit' => 'warning',
                                                        'emi' => 'secondary',
                                                        'bank_transfer' => 'dark'
                                                    ];
                                            ?>
                                            <tr>
                                                <td>
                                                    <div>
                                                        <h6 class="mb-0"><?php echo htmlspecialchars($sale['sale_number']); ?></h6>
                                                        <small class="text-muted">Items: <?php echo $sale['item_count']; ?></small>
                                                        <?php if (!empty($sale['finance_partner'])): ?>
                                                            <br>
                                                            <small class="text-info">
                                                                <i class="fas fa-handshake me-1"></i>
                                                                <?php echo htmlspecialchars($sale['finance_partner']); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <strong><?php echo htmlspecialchars($sale['customer_name']); ?></strong>
                                                        <br>
                                                        <small class="text-muted">
                                                            <i class="fas fa-phone me-1"></i>
                                                            <?php echo htmlspecialchars($sale['customer_phone']); ?>
                                                        </small>
                                                        <?php if (!empty($sale['customer_email'])): ?>
                                                            <br>
                                                            <small class="text-muted">
                                                                <i class="fas fa-envelope me-1"></i>
                                                                <?php echo htmlspecialchars($sale['customer_email']); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div>
                                                        <span class="badge bg-<?php echo $payment_type_badge[$sale['payment_type']]; ?> mb-1">
                                                            <?php echo ucfirst($sale['payment_type']); ?>
                                                        </span>
                                                        <br>
                                                        <span class="badge bg-<?php echo $payment_status_badge[$sale['payment_status']]; ?>">
                                                            <?php echo ucfirst($sale['payment_status']); ?>
                                                        </span>
                                                        <?php if ($sale['payment_type'] == 'credit' && !empty($sale['credit_due_date'])): ?>
                                                            <br>
                                                            <small class="text-muted">
                                                                Due: <?php echo date('M j, Y', strtotime($sale['credit_due_date'])); ?>
                                                            </small>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong>Total: ₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                        <br>
                                                        <span class="text-success">Paid: ₹<?php echo number_format($sale['paid_amount'], 2); ?></span>
                                                        <br>
                                                        <span class="text-danger">Due: ₹<?php echo number_format($sale['due_amount'], 2); ?></span>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-success">
                                                        <?php echo ucfirst($sale['status']); ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <small>
                                                        <?php echo date('M j, Y', strtotime($sale['sale_date'])); ?>
                                                        <br>
                                                        <span class="text-muted"><?php echo date('g:i A', strtotime($sale['sale_date'])); ?></span>
                                                    </small>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-info" 
                                                                onclick="viewSaleDetails(<?php echo $sale['id']; ?>)"
                                                                title="View Details">
                                                            <i class="fas fa-eye"></i>
                                                        </button>
                                                        <a href="invoice.php?id=<?php echo $sale['id']; ?>" class="btn btn-outline-primary" title="Print Invoice">
                                                            <i class="fas fa-receipt"></i>
                                                        </a>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="7" class="text-center py-4">
                                                    <i class="fas fa-chart-line display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Sales Found</h5>
                                                    <p class="text-muted">No sales match your search criteria for the selected period in your branch.</p>
                                                    <a href="sales-new.php" class="btn btn-primary">
                                                        <i class="fas fa-shopping-cart me-2"></i>Create New Sale
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav>
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?php echo $current_page == 1 ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="?page=<?php echo $current_page - 1; ?>&start_date=<?php echo $start_date; ?>&end_date=<?php echo $end_date; ?>&payment_status=<?php echo $payment_status_filter; ?>&payment_type=<?php echo $payment_type_filter; ?>">Previous</a>
                                                </li>
                                                
                                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                    <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                                        <a class="page-link" href="?page=<?php echo $i; ?>&start_date=<?php echo $start_date; ?>&end_date=<?php echo $end_date; ?>&payment_status=<?php echo $payment_status_filter; ?>&payment_type=<?php echo $payment_type_filter; ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?php echo $current_page == $total_pages ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="?page=<?php echo $current_page + 1; ?>&start_date=<?php echo $start_date; ?>&end_date=<?php echo $end_date; ?>&payment_status=<?php echo $payment_status_filter; ?>&payment_type=<?php echo $payment_type_filter; ?>">Next</a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>

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

</div>
            
        </div>

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

</div>

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

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

// Apply filters function
    function applyDateFilters() {
        const params = new URLSearchParams();
        
        if (startDate.value) params.set('start_date', startDate.value);
        if (endDate.value) params.set('end_date', endDate.value);
        if (paymentStatus.value) params.set('payment_status', paymentStatus.value);
        if (paymentType.value) params.set('payment_type', paymentType.value);
        
        window.location.href = 'reports-sales.php?' + params.toString();
    }

applyFilters.addEventListener('click', applyDateFilters);
});

// Print report function
function printReport() {
    window.print();
}

// View sale details
function viewSaleDetails(saleId) {
    window.location.href = 'sale-details.php?id=' + saleId;
}
</script>

</body>
</html>

<?php
// Function to export sales data to CSV
function exportSalesToCSV($conn, $start_date, $end_date, $payment_status, $payment_type, $branch_id) {
    // Build query with filters
    $where_conditions = array();
    $where_conditions[] = "s.sale_date BETWEEN '$start_date 00:00:00' AND '$end_date 23:59:59'";
    $where_conditions[] = "s.status = 'completed'";
    $where_conditions[] = "s.branch_id = $branch_id"; // Branch filter added

if (!empty($payment_status)) {
        $where_conditions[] = "s.payment_status = '$payment_status'";
    }

if (!empty($payment_type)) {
        $where_conditions[] = "s.payment_type = '$payment_type'";
    }

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

$sql = "SELECT s.*, 
                   (SELECT COUNT(*) FROM sale_items si WHERE si.sale_id = s.id) as item_count
                   FROM sales s 
                   $where_sql 
                   ORDER BY s.sale_date DESC";
    
    $result = $conn->query($sql);
    
    // Set headers for CSV download
    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=branch_sales_report_' . date('Y-m-d') . '.csv');
    
    $output = fopen('php://output', 'w');
    
    // Add CSV headers
    fputcsv($output, array(
        'Sale Number', 
        'Sale Date', 
        'Customer Name', 
        'Customer Phone', 
        'Payment Type', 
        'Payment Status', 
        'Total Amount', 
        'Paid Amount', 
        'Due Amount', 
        'Items Count',
        'Finance Partner',
        'Credit Due Date'
    ));
    
    // Add data rows
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            fputcsv($output, array(
                $row['sale_number'],
                $row['sale_date'],
                $row['customer_name'],
                $row['customer_phone'],
                $row['payment_type'],
                $row['payment_status'],
                $row['total_amount'],
                $row['paid_amount'],
                $row['due_amount'],
                $row['item_count'],
                $row['finance_partner'] ?? '',
                $row['credit_due_date'] ?? ''
            ));
        }
    }
    
    fclose($output);
    exit();
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reports-sales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation