Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/medical/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: export-sales.php

<?php
// Database connection
include('includes/db_connection.php');

// Get filter parameters from GET request
$start_date = isset($_GET['start_date']) ? $_GET['start_date'] : date('Y-m-01');
$end_date = isset($_GET['end_date']) ? $_GET['end_date'] : date('Y-m-d');
$payment_method = isset($_GET['payment_method']) ? $_GET['payment_method'] : '';
$status_filter = isset($_GET['status_filter']) ? $_GET['status_filter'] : '';
$customer_filter = isset($_GET['customer_filter']) ? $_GET['customer_filter'] : '';
$category_filter = isset($_GET['category_filter']) ? (int)$_GET['category_filter'] : 0;
$min_amount = isset($_GET['min_amount']) ? (float)$_GET['min_amount'] : 0;
$max_amount = isset($_GET['max_amount']) ? (float)$_GET['max_amount'] : 0;

// Build WHERE clause for filtering
$where_conditions = [];
$query_params = [];
$param_types = '';

if (!empty($start_date)) {
    $where_conditions[] = "DATE(s.sale_date) >= ?";
    $query_params[] = $start_date;
    $param_types .= 's';
}

if (!empty($end_date)) {
    $where_conditions[] = "DATE(s.sale_date) <= ?";
    $query_params[] = $end_date;
    $param_types .= 's';
}

if (!empty($payment_method)) {
    $where_conditions[] = "s.payment_method = ?";
    $query_params[] = $payment_method;
    $param_types .= 's';
}

if (!empty($status_filter)) {
    $where_conditions[] = "s.status = ?";
    $query_params[] = $status_filter;
    $param_types .= 's';
}

if (!empty($customer_filter)) {
    $where_conditions[] = "(s.customer_phone LIKE ? OR c.customer_name LIKE ?)";
    $search_term = "%$customer_filter%";
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $param_types .= 'ss';
}

if ($min_amount > 0) {
    $where_conditions[] = "s.total_amount >= ?";
    $query_params[] = $min_amount;
    $param_types .= 'd';
}

if ($max_amount > 0) {
    $where_conditions[] = "s.total_amount <= ?";
    $query_params[] = $max_amount;
    $param_types .= 'd';
}

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

// Fetch sales data with filters for export
$sales_query = "
    SELECT 
        s.id,
        s.sale_date,
        s.customer_name,
        s.customer_phone,
        COUNT(si.id) as item_count,
        GROUP_CONCAT(CONCAT(si.quantity, 'x ', m.medicine_name) SEPARATOR ', ') as items,
        s.total_amount,
        s.subtotal_amount,
        s.discount,
        s.tax_amount,
        s.payment_method,
        s.status,
        s.created_at
    FROM sales s
    LEFT JOIN customers c ON s.customer_phone = c.customer_phone
    LEFT JOIN sale_items si ON s.id = si.sale_id
    LEFT JOIN medicines m ON si.medicine_id = m.id
    $where_clause
    GROUP BY s.id
    ORDER BY s.sale_date DESC, s.id DESC
";

$stmt = $conn->prepare($sales_query);
if (!empty($query_params)) {
    $stmt->bind_param($param_types, ...$query_params);
}
$stmt->execute();
$sales_result = $stmt->get_result();

// Calculate summary statistics for export
$summary_query = "
    SELECT 
        COUNT(*) as total_transactions,
        SUM(s.total_amount) as total_amount,
        SUM(s.discount) as total_discount,
        SUM(s.tax_amount) as total_tax,
        AVG(s.total_amount) as avg_sale,
        COUNT(DISTINCT s.customer_phone) as unique_customers
    FROM sales s
    $where_clause
";

$summary_stmt = $conn->prepare($summary_query);
if (!empty($query_params)) {
    $summary_stmt->bind_param($param_types, ...$query_params);
}
$summary_stmt->execute();
$summary_result = $summary_stmt->get_result();
$summary = $summary_result->fetch_assoc();

if (!$summary) {
    $summary = [
        'total_transactions' => 0,
        'total_amount' => 0,
        'total_discount' => 0,
        'total_tax' => 0,
        'avg_sale' => 0,
        'unique_customers' => 0
    ];
}

// Set headers for Excel file download
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="sales-report-' . date('Y-m-d') . '.xls"');
header('Pragma: no-cache');
header('Expires: 0');

// Start output
echo '<html>';
echo '<head>';
echo '<meta charset="UTF-8">';
echo '<style>';
echo 'table { border-collapse: collapse; width: 100%; }';
echo 'th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }';
echo 'th { background-color: #f2f2f2; font-weight: bold; }';
echo '.summary { background-color: #f8f9fa; padding: 15px; margin-bottom: 20px; }';
echo '.summary-row { margin-bottom: 5px; }';
echo '</style>';
echo '</head>';
echo '<body>';

// Report header and summary
echo '<h2>Sales Report</h2>';
echo '<p><strong>Period:</strong> ' . date('d M Y', strtotime($start_date)) . ' to ' . date('d M Y', strtotime($end_date)) . '</p>';
echo '<p><strong>Generated:</strong> ' . date('d M Y h:i A') . '</p>';

echo '<div class="summary">';
echo '<h3>Summary Statistics</h3>';
echo '<div class="summary-row"><strong>Total Sales:</strong> ' . $summary['total_transactions'] . '</div>';
echo '<div class="summary-row"><strong>Total Revenue:</strong> ₹' . number_format($summary['total_amount'], 2) . '</div>';
echo '<div class="summary-row"><strong>Average Sale:</strong> ₹' . number_format($summary['avg_sale'], 2) . '</div>';
echo '<div class="summary-row"><strong>Total Discount:</strong> ₹' . number_format($summary['total_discount'], 2) . '</div>';
echo '<div class="summary-row"><strong>Total Tax:</strong> ₹' . number_format($summary['total_tax'], 2) . '</div>';
echo '<div class="summary-row"><strong>Unique Customers:</strong> ' . $summary['unique_customers'] . '</div>';
echo '</div>';

// Sales table
echo '<h3>Sales Details</h3>';
echo '<table>';
echo '<thead>';
echo '<tr>';
echo '<th>Invoice ID</th>';
echo '<th>Date & Time</th>';
echo '<th>Customer Name</th>';
echo '<th>Customer Phone</th>';
echo '<th>Items Count</th>';
echo '<th>Items</th>';
echo '<th>Subtotal</th>';
echo '<th>Discount</th>';
echo '<th>Tax</th>';
echo '<th>Total Amount</th>';
echo '<th>Payment Method</th>';
echo '<th>Status</th>';
echo '</tr>';
echo '</thead>';
echo '<tbody>';

if ($sales_result->num_rows > 0) {
    while ($sale = $sales_result->fetch_assoc()) {
        echo '<tr>';
        echo '<td>#' . $sale['id'] . '</td>';
        echo '<td>' . date('d M Y h:i A', strtotime($sale['sale_date'])) . '</td>';
        echo '<td>' . htmlspecialchars($sale['customer_name'] ?: '') . '</td>';
        echo '<td>' . htmlspecialchars($sale['customer_phone'] ?: '') . '</td>';
        echo '<td>' . $sale['item_count'] . '</td>';
        echo '<td>' . htmlspecialchars($sale['items'] ?: '') . '</td>';
        echo '<td>₹' . number_format($sale['subtotal_amount'], 2) . '</td>';
        echo '<td>₹' . number_format($sale['discount'], 2) . '</td>';
        echo '<td>₹' . number_format($sale['tax_amount'], 2) . '</td>';
        echo '<td>₹' . number_format($sale['total_amount'], 2) . '</td>';
        echo '<td>' . ucfirst($sale['payment_method']) . '</td>';
        
        $status_text = ucfirst($sale['status']);
        switch($sale['status']) {
            case 'completed': $status_text = 'Completed'; break;
            case 'cancelled': $status_text = 'Cancelled'; break;
            case 'refunded': $status_text = 'Refunded'; break;
        }
        echo '<td>' . $status_text . '</td>';
        echo '</tr>';
    }
} else {
    echo '<tr><td colspan="12" style="text-align: center;">No sales data found</td></tr>';
}

echo '</tbody>';
echo '</table>';

// Footer
echo '<div style="margin-top: 30px; font-size: 12px; color: #666;">';
echo '<p>Generated by Medical Store Management System</p>';
echo '</div>';

echo '</body>';
echo '</html>';

// Close database connections
if (isset($stmt)) {
    $stmt->close();
}
if (isset($summary_stmt)) {
    $summary_stmt->close();
}
if (isset($conn)) {
    $conn->close();
}
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export-sales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation