Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/poorva

Free Space:

10.16 TB

🔧 Quick Actions

✏️ Editing: gst-sales.php

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

// Get date range filters
$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-t');
$gst_filter = isset($_GET['gst_filter']) ? $_GET['gst_filter'] : 'all';

// Handle exports - THIS MUST BE AT THE VERY TOP BEFORE ANY OUTPUT
if (isset($_GET['export'])) {
    $export_type = $_GET['export'];
    exportGSTReport($export_type, $start_date, $end_date, $gst_filter, $conn);
    exit;
}

// Export function
function exportGSTReport($type, $start_date, $end_date, $gst_filter, $conn) {
    // Build query
    $where_conditions = ["s.status = 'completed'"];
    $where_conditions[] = "DATE(s.sale_date) BETWEEN '$start_date' AND '$end_date'";

if ($gst_filter === 'with_gst') {
        $where_conditions[] = "s.total_gst_amount > 0";
    } elseif ($gst_filter === 'without_gst') {
        $where_conditions[] = "s.total_gst_amount = 0";
    }

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

$sql = "SELECT s.*, c.customer_name, c.customer_phone 
            FROM sales s 
            LEFT JOIN customers c ON s.customer_id = c.id 
            WHERE $where_sql 
            ORDER BY s.sale_date DESC";
    
    $result = $conn->query($sql);
    
    if ($type === 'excel') {
        exportToExcel($result, $start_date, $end_date, $gst_filter);
    } elseif ($type === 'pdf') {
        exportToPDF($result, $start_date, $end_date, $gst_filter);
    }
}

<!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="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
                                            $total_sales_sql = "SELECT SUM(total_amount) as total_sales FROM sales 
                                                              WHERE status = 'completed' 
                                                              AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $total_sales_sql .= " AND total_gst_amount > 0";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $total_sales_sql .= " AND total_gst_amount = 0";
                                            }
                                            $total_sales = $conn->query($total_sales_sql)->fetch_assoc()['total_sales'] ?? 0;
                                            echo '₹' . number_format($total_sales, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total 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_gst_sql = "SELECT SUM(total_gst_amount) as total_gst FROM sales 
                                                            WHERE status = 'completed' 
                                                            AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $total_gst_sql .= " AND total_gst_amount > 0";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $total_gst_sql .= " AND total_gst_amount = 0";
                                            }
                                            $total_gst = $conn->query($total_gst_sql)->fetch_assoc()['total_gst'] ?? 0;
                                            echo '₹' . number_format($total_gst, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total GST Collected</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-receipt display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-purple text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $net_sales_sql = "SELECT SUM(subtotal_amount) as net_sales FROM sales 
                                                            WHERE status = 'completed' 
                                                            AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $net_sales_sql .= " AND total_gst_amount > 0";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $net_sales_sql .= " AND total_gst_amount = 0";
                                            }
                                            $net_sales = $conn->query($net_sales_sql)->fetch_assoc()['net_sales'] ?? 0;
                                            echo '₹' . number_format($net_sales, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Net Sales (Excl. GST)</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line 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_sales_count_sql = "SELECT COUNT(*) as total_count FROM sales 
                                                                    WHERE status = 'completed' 
                                                                    AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $total_sales_count_sql .= " AND total_gst_amount > 0";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $total_sales_count_sql .= " AND total_gst_amount = 0";
                                            }
                                            $total_count = $conn->query($total_sales_count_sql)->fetch_assoc()['total_count'] ?? 0;
                                            echo number_format($total_count);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Transactions</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-file-invoice display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <?php
                    // Get GST breakdown by rate
                    $gst_breakdown_sql = "SELECT gst_breakdown FROM sales 
                                         WHERE status = 'completed' 
                                         AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'
                                         AND total_gst_amount > 0";
                    $gst_result = $conn->query($gst_breakdown_sql);
                    
                    $gst_rates = [];
                    while($row = $gst_result->fetch_assoc()) {
                        if (!empty($row['gst_breakdown']) && $row['gst_breakdown'] !== 'null') {
                            $breakdown = json_decode($row['gst_breakdown'], true);
                            if ($breakdown) {
                                foreach ($breakdown as $rate => $amount) {
                                    if (!isset($gst_rates[$rate])) {
                                        $gst_rates[$rate] = 0;
                                    }
                                    $gst_rates[$rate] += floatval($amount);
                                }
                            }
                        }
                    }
                    
                    foreach ($gst_rates as $rate => $amount):
                    ?>

<?php endforeach; ?>
                    
                    <?php if (empty($gst_rates)): ?>
                    <div class="col-12">
                        <div class="card bg-light">
                            <div class="card-body text-center">
                                <h5 class="text-muted">No GST Data Available</h5>
                                <p class="text-muted mb-0">No GST collected in the selected period</p>
                            </div>
                        </div>
                    </div>
                    <?php endif; ?>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <div>
                                        <h5 class="card-title mb-0">GST Sales Report</h5>
                                        <p class="text-muted mb-0">
                                            <span class="badge bg-info"><?php echo date('d M Y', strtotime($start_date)); ?> - <?php echo date('d M Y', strtotime($end_date)); ?></span>
                                            <span class="badge bg-secondary ms-1">
                                                <?php 
                                                if ($gst_filter === 'with_gst') echo 'With GST';
                                                elseif ($gst_filter === 'without_gst') echo 'Without GST';
                                                else echo 'All Sales';
                                                ?>
                                            </span>
                                        </p>
                                    </div>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="gst-sales.php?<?php echo http_build_query(array_merge($_GET, ['export' => 'excel'])); ?>" class="btn btn-success" id="exportExcel">
                                            <i class="fas fa-file-excel me-2"></i>Export Excel
                                        </a>

<button type="button" class="btn btn-info" id="printReport">
                                            <i class="fas fa-print me-2"></i>Print
                                        </button>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <label for="startDate" class="form-label">Start Date</label>
                                        <input type="date" class="form-control" id="startDate" value="<?php echo $start_date; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="endDate" class="form-label">End Date</label>
                                        <input type="date" class="form-control" id="endDate" value="<?php echo $end_date; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="gstFilter" class="form-label">GST Status</label>
                                        <select class="form-select" id="gstFilter">
                                            <option value="all" <?php echo $gst_filter === 'all' ? 'selected' : ''; ?>>All Sales</option>
                                            <option value="with_gst" <?php echo $gst_filter === 'with_gst' ? 'selected' : ''; ?>>With GST</option>
                                            <option value="without_gst" <?php echo $gst_filter === 'without_gst' ? 'selected' : ''; ?>>Without GST</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3 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="table-responsive">
                                    <table class="table table-bordered table-hover mb-0" id="gstSalesTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Sale No.</th>
                                                <th>Date</th>
                                                <th>Customer</th>
                                                <th>Phone</th>
                                                <th>Subtotal</th>
                                                <th>GST Amount</th>
                                                <th>Total Amount</th>
                                                <th>GST Rate</th>
                                                <th>Payment Type</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters
                                            $where_conditions = ["s.status = 'completed'"];
                                            $where_conditions[] = "DATE(s.sale_date) BETWEEN '$start_date' AND '$end_date'";

if ($gst_filter === 'with_gst') {
                                                $where_conditions[] = "s.total_gst_amount > 0";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $where_conditions[] = "s.total_gst_amount = 0";
                                            }

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

// Get total count for pagination
                                            $count_sql = "SELECT COUNT(*) as total FROM sales s 
                                                         LEFT JOIN customers c ON s.customer_id = c.id 
                                                         WHERE $where_sql";
                                            $count_result = $conn->query($count_sql);
                                            $total_sales = $count_result->fetch_assoc()['total'];

// Pagination
                                            $per_page = 15;
                                            $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.*, c.customer_name, c.customer_phone 
                                                    FROM sales s 
                                                    LEFT JOIN customers c ON s.customer_id = c.id 
                                                    WHERE $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()) {
                                                    // Parse GST breakdown
                                                    $gst_rates_display = '';
                                                    if (!empty($sale['gst_breakdown']) && $sale['gst_breakdown'] !== 'null') {
                                                        $breakdown = json_decode($sale['gst_breakdown'], true);
                                                        if ($breakdown) {
                                                            foreach ($breakdown as $rate => $amount) {
                                                                $gst_rates_display .= '<span class="badge badge-gst me-1">' . $rate . '%</span>';
                                                            }
                                                        }
                                                    } else {
                                                        $gst_rates_display = '<span class="badge bg-secondary">No GST</span>';
                                                    }

// Payment type badge
                                                    $payment_class = [
                                                        'cash' => 'success',
                                                        'card' => 'info',
                                                        'upi' => 'primary',
                                                        'credit' => 'warning',
                                                        'emi' => 'secondary',
                                                        'bank_transfer' => 'dark'
                                                    ][$sale['payment_type']] ?? 'secondary';
                                            ?>
                                            <tr>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($sale['sale_number']); ?></strong>
                                                </td>
                                                <td>
                                                    <?php echo date('d M Y', strtotime($sale['sale_date'])); ?>
                                                    <br>
                                                    <small class="text-muted"><?php echo date('h:i A', strtotime($sale['sale_date'])); ?></small>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0">
                                                            <div class="avatar-xs bg-light rounded">
                                                                <i class="fas fa-user font-size-13 text-primary"></i>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($sale['customer_name']); ?></h6>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <?php echo htmlspecialchars($sale['customer_phone']); ?>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-info">₹<?php echo number_format($sale['subtotal_amount'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-success">₹<?php echo number_format($sale['total_gst_amount'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-primary">₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <?php echo $gst_rates_display; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php echo $payment_class; ?>">
                                                        <?php echo strtoupper($sale['payment_type']); ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <span class="badge bg-success">
                                                        <i class="fas fa-check-circle me-1"></i>Completed
                                                    </span>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-primary view-sale" 
                                                                data-bs-toggle="modal" data-bs-target="#saleDetailsModal"
                                                                data-sale-id="<?php echo $sale['id']; ?>">
                                                            <i class="fas fa-eye"></i>
                                                        </button>
                                                        <a href="sales-receipt.php?id=<?php echo $sale['id']; ?>" class="btn btn-outline-info" title="Print Receipt" target="_blank">
                                                            <i class="fas fa-receipt"></i>
                                                        </a>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="11" class="text-center py-4">
                                                    <i class="fas fa-file-invoice display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Sales Found</h5>
                                                    <p class="text-muted">No sales match your search criteria.</p>
                                                </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="<?php echo build_page_url($current_page - 1); ?>">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="<?php echo build_page_url($i); ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?php echo $current_page == $total_pages ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page + 1); ?>">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')?>

<div class="modal fade" id="saleDetailsModal" tabindex="-1" aria-labelledby="saleDetailsModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="saleDetailsModalLabel">Sale Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="saleDetailsContent">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

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

// Apply filters
    if (applyFilters) {
        applyFilters.addEventListener('click', function() {
            const params = new URLSearchParams();
            
            if (startDate && startDate.value) params.set('start_date', startDate.value);
            if (endDate && endDate.value) params.set('end_date', endDate.value);
            if (gstFilter && gstFilter.value) params.set('gst_filter', gstFilter.value);
            
            window.location.href = 'gst-sales.php?' + params.toString();
        });
    }

// Sale Details Modal
    if (saleDetailsModal) {
        saleDetailsModal.addEventListener('show.bs.modal', function (event) {
            const button = event.relatedTarget;
            const saleId = button.getAttribute('data-sale-id');
            
            // Fetch sale details via AJAX
            fetch(`api/sale-details.php?id=${saleId}`)
                .then(response => response.text())
                .then(data => {
                    document.getElementById('saleDetailsContent').innerHTML = data;
                })
                .catch(error => {
                    document.getElementById('saleDetailsContent').innerHTML = 
                        '<div class="alert alert-danger">Error loading sale details</div>';
                });
        });
    }

// Print functionality
    document.getElementById('printReport')?.addEventListener('click', function() {
        window.print();
    });
});
</script>

</body>
</html>

<?php
// Helper function for building pagination URLs
function build_page_url($page) {
    $params = $_GET;
    unset($params['export']); // Remove export parameter from pagination
    $params['page'] = max(1, intval($page));
    return 'gst-sales.php?' . http_build_query($params);
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst-sales.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation