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-gst.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 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';
$gst_rate_filter = isset($_GET['gst_rate']) ? $_GET['gst_rate'] : '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, $gst_rate_filter, $conn, $branch_id);
    exit;
}

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

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

// GST Rate filter
    if ($gst_rate_filter !== 'all') {
        $where_conditions[] = "si.gst_percentage = $gst_rate_filter";
    }

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

$sql = "SELECT s.*, c.customer_name, c.customer_phone, 
                   si.gst_percentage, si.gst_amount as item_gst_amount
            FROM sales s 
            LEFT JOIN customers c ON s.customer_id = c.id 
            LEFT JOIN sale_items si ON s.id = si.sale_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, $gst_rate_filter, $branch_id);
    } elseif ($type === 'pdf') {
        exportToPDF($result, $start_date, $end_date, $gst_filter, $gst_rate_filter, $branch_id);
    }
}

// Get available GST rates for filter dropdown (branch-specific)
$gst_rates_sql = "SELECT DISTINCT si.gst_percentage 
                 FROM sale_items si
                 JOIN sales s ON si.sale_id = s.id
                 WHERE si.gst_percentage > 0 
                 AND s.branch_id = $branch_id
                 AND s.status = 'completed'
                 ORDER BY si.gst_percentage";
$gst_rates_result = $conn->query($gst_rates_sql);
$available_gst_rates = [];
while ($row = $gst_rates_result->fetch_assoc()) {
    $available_gst_rates[] = $row['gst_percentage'];
}
?>

<!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 GST 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-md-3">
                        <div class="card bg-primary text-white card-hover">
                            <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 branch_id = $branch_id
                                                              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";
                                            }
                                            if ($gst_rate_filter !== 'all') {
                                                $total_sales_sql .= " AND id IN (SELECT sale_id FROM sale_items WHERE gst_percentage = $gst_rate_filter)";
                                            }
                                            $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 card-hover">
                            <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 branch_id = $branch_id
                                                            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";
                                            }
                                            if ($gst_rate_filter !== 'all') {
                                                $total_gst_sql .= " AND id IN (SELECT sale_id FROM sale_items WHERE gst_percentage = $gst_rate_filter)";
                                            }
                                            $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 card-hover">
                            <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 branch_id = $branch_id
                                                            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";
                                            }
                                            if ($gst_rate_filter !== 'all') {
                                                $net_sales_sql .= " AND id IN (SELECT sale_id FROM sale_items WHERE gst_percentage = $gst_rate_filter)";
                                            }
                                            $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 card-hover">
                            <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 branch_id = $branch_id
                                                                    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";
                                            }
                                            if ($gst_rate_filter !== 'all') {
                                                $total_sales_count_sql .= " AND id IN (SELECT sale_id FROM sale_items WHERE gst_percentage = $gst_rate_filter)";
                                            }
                                            $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 (branch-specific)
                    $gst_breakdown_sql = "SELECT si.gst_percentage, SUM(si.gst_amount) as total_gst
                                         FROM sale_items si
                                         JOIN sales s ON si.sale_id = s.id
                                         WHERE s.status = 'completed' 
                                         AND s.branch_id = $branch_id
                                         AND DATE(s.sale_date) BETWEEN '$start_date' AND '$end_date'
                                         AND si.gst_amount > 0";
                    
                    if ($gst_filter === 'with_gst') {
                        $gst_breakdown_sql .= " AND s.total_gst_amount > 0";
                    } elseif ($gst_filter === 'without_gst') {
                        $gst_breakdown_sql .= " AND s.total_gst_amount = 0";
                    }
                    
                    $gst_breakdown_sql .= " GROUP BY si.gst_percentage ORDER BY si.gst_percentage";
                    
                    $gst_result = $conn->query($gst_breakdown_sql);
                    
                    $gst_rates = [];
                    while($row = $gst_result->fetch_assoc()) {
                        $gst_rates[$row['gst_percentage']] = $row['total_gst'];
                    }
                    
                    foreach ($gst_rates as $rate => $amount):
                        $bg_color = $rate == 18 ? 'bg-purple' : ($rate == 12 ? 'bg-info' : ($rate == 5 ? 'bg-success' : 'bg-secondary'));
                    ?>
                    <div class="col-md-3">
                        <div class="card <?php echo $bg_color; ?> text-white card-hover">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">₹<?php echo number_format($amount, 2); ?></h4>
                                        <p class="mb-0">GST <?php echo $rate; ?>%</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-percentage display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?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 in your branch</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">Branch 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 
                                                echo getGSTFilterText($gst_filter, $gst_rate_filter);
                                                ?>
                                            </span>
                                        </p>
                                    </div>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="reports-gst.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-2">
                                        <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-2">
                                        <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-2">
                                        <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-2">
                                        <label for="gstRateFilter" class="form-label">GST Rate</label>
                                        <select class="form-select" id="gstRateFilter">
                                            <option value="all" <?php echo $gst_rate_filter === 'all' ? 'selected' : ''; ?>>All Rates</option>
                                            <?php foreach ($available_gst_rates as $rate): ?>
                                                <option value="<?php echo $rate; ?>" <?php echo $gst_rate_filter == $rate ? 'selected' : ''; ?>>
                                                    <?php echo $rate; ?>%
                                                </option>
                                            <?php endforeach; ?>
                                        </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 class="col-md-2 d-flex align-items-end">
                                        <button type="button" class="btn btn-outline-secondary w-100" id="resetFilters">
                                            <i class="fas fa-redo me-2"></i>Reset
                                        </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'";
                                            $where_conditions[] = "s.branch_id = $branch_id"; // Branch filter added

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(DISTINCT s.id) as total FROM sales s 
                                                         LEFT JOIN customers c ON s.customer_id = c.id 
                                                         LEFT JOIN sale_items si ON s.id = si.sale_id
                                                         WHERE $where_sql";
                                            
                                            if ($gst_rate_filter !== 'all') {
                                                $count_sql .= " AND si.gst_percentage = $gst_rate_filter";
                                            }
                                            
                                            $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, 
                                                           si.gst_percentage, si.gst_amount as item_gst_amount
                                                    FROM sales s 
                                                    LEFT JOIN customers c ON s.customer_id = c.id 
                                                    LEFT JOIN sale_items si ON s.id = si.sale_id
                                                    WHERE $where_sql";
                                            
                                            if ($gst_rate_filter !== 'all') {
                                                $sql .= " AND si.gst_percentage = $gst_rate_filter";
                                            }
                                            
                                            $sql .= " GROUP BY s.id ORDER BY s.sale_date DESC LIMIT $offset, $per_page";
                                            
                                            $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                                while($sale = $result->fetch_assoc()) {
                                                    // GST rate display
                                                    $gst_rate_display = $sale['gst_percentage'] ? 
                                                        '<span class="badge badge-gst">' . $sale['gst_percentage'] . '%</span>' : 
                                                        '<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_rate_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 in your branch.</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);
            if (gstRateFilter && gstRateFilter.value !== 'all') params.set('gst_rate', gstRateFilter.value);
            
            window.location.href = 'reports-gst.php?' + params.toString();
        });
    }

// Reset filters
    if (resetFilters) {
        resetFilters.addEventListener('click', function() {
            window.location.href = 'reports-gst.php';
        });
    }

// 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();
    });

// Auto-set end date to start date if end date is before start date
    if (startDate && endDate) {
        startDate.addEventListener('change', function() {
            if (endDate.value && new Date(endDate.value) < new Date(startDate.value)) {
                endDate.value = startDate.value;
            }
        });
    }
});
</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 'reports-gst.php?' . http_build_query($params);
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reports-gst.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation