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.17 TB

🔧 Quick Actions

✏️ Editing: gst-purchase.php

<?php
session_start();
// Include database connection
include('includes/db.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';
$supplier_filter = isset($_GET['supplier']) ? $_GET['supplier'] : 'all';

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

// Export function with branch filter
function exportGSTPurchaseReport($type, $start_date, $end_date, $gst_filter, $supplier_filter, $conn, $branch_id) {
    // Build query with branch filter
    $where_conditions = ["po.status = 'completed'", "po.branch_id = $branch_id"];
    $where_conditions[] = "DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'";

if ($supplier_filter !== 'all') {
        $where_conditions[] = "po.supplier_id = " . intval($supplier_filter);
    }

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

$sql = "SELECT po.*, s.name as supplier_name, s.gst_number as supplier_gst,
                   poi.*, p.product_name, p.model, 
                   COALESCE(pgs.gst_applicable, 0) as gst_applicable,
                   COALESCE(pgs.gst_percentage, 0) as gst_percentage
            FROM purchase_orders po 
            LEFT JOIN suppliers s ON po.supplier_id = s.id 
            LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
            LEFT JOIN products p ON poi.product_id = p.id
            LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
            WHERE $where_sql 
            ORDER BY po.order_date DESC";
    
    $result = $conn->query($sql);
    
    if ($type === 'excel') {
        exportPurchaseToExcel($result, $start_date, $end_date, $gst_filter, $supplier_filter, $conn, $branch_id);
    } elseif ($type === 'pdf') {
        exportPurchaseToPDF($result, $start_date, $end_date, $gst_filter, $supplier_filter, $conn, $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 GST purchase report for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="reports-gst.php" class="btn btn-primary">
                                <i class="fas fa-chart-bar me-2"></i>GST Reports
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_purchase_sql = "SELECT SUM(poi.total_price) as total_purchase 
                                                FROM purchase_orders po 
                                                LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                LEFT JOIN products p ON poi.product_id = p.id
                                                LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                WHERE po.status = 'completed' 
                                                AND po.branch_id = $branch_id
                                                AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $total_purchase_sql .= " AND pgs.gst_applicable = 1";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $total_purchase_sql .= " AND (pgs.gst_applicable = 0 OR pgs.gst_applicable IS NULL)";
                                            }
                                            if ($supplier_filter !== 'all') {
                                                $total_purchase_sql .= " AND po.supplier_id = " . intval($supplier_filter);
                                            }
                                            $total_purchase = $conn->query($total_purchase_sql)->fetch_assoc()['total_purchase'] ?? 0;
                                            echo '₹' . number_format($total_purchase, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Branch Purchase</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-store me-1"></i> Your branch only</small>
                                </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(poi.total_price * pgs.gst_percentage / 100) as total_gst 
                                                FROM purchase_orders po 
                                                LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                LEFT JOIN products p ON poi.product_id = p.id
                                                LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                WHERE po.status = 'completed' 
                                                AND po.branch_id = $branch_id
                                                AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'
                                                AND pgs.gst_applicable = 1";
                                            if ($supplier_filter !== 'all') {
                                                $total_gst_sql .= " AND po.supplier_id = " . intval($supplier_filter);
                                            }
                                            $total_gst = $conn->query($total_gst_sql)->fetch_assoc()['total_gst'] ?? 0;
                                            echo '₹' . number_format($total_gst, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Branch GST Paid</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-receipt display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-store me-1"></i> Input Tax Credit</small>
                                </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
                                            // Calculate total with GST for branch
                                            $total_with_gst_sql = "SELECT SUM(poi.total_price + (poi.total_price * COALESCE(pgs.gst_percentage, 0) / 100)) as total_with_gst 
                                                FROM purchase_orders po 
                                                LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                LEFT JOIN products p ON poi.product_id = p.id
                                                LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                WHERE po.status = 'completed' 
                                                AND po.branch_id = $branch_id
                                                AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($supplier_filter !== 'all') {
                                                $total_with_gst_sql .= " AND po.supplier_id = " . intval($supplier_filter);
                                            }
                                            $total_with_gst = $conn->query($total_with_gst_sql)->fetch_assoc()['total_with_gst'] ?? 0;
                                            echo '₹' . number_format($total_with_gst, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total with GST</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-store me-1"></i> Branch purchase value</small>
                                </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_orders_sql = "SELECT COUNT(DISTINCT po.id) as total_orders 
                                                FROM purchase_orders po 
                                                LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                LEFT JOIN products p ON poi.product_id = p.id
                                                LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                WHERE po.status = 'completed' 
                                                AND po.branch_id = $branch_id
                                                AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'";
                                            if ($gst_filter === 'with_gst') {
                                                $total_orders_sql .= " AND pgs.gst_applicable = 1";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $total_orders_sql .= " AND (pgs.gst_applicable = 0 OR pgs.gst_applicable IS NULL)";
                                            }
                                            if ($supplier_filter !== 'all') {
                                                $total_orders_sql .= " AND po.supplier_id = " . intval($supplier_filter);
                                            }
                                            $total_orders = $conn->query($total_orders_sql)->fetch_assoc()['total_orders'] ?? 0;
                                            echo number_format($total_orders);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Branch Orders</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-file-invoice display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small><i class="fas fa-store me-1"></i> Your branch orders</small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <?php
                    // Get GST breakdown by rate for branch purchases
                    $gst_breakdown_sql = "SELECT pgs.gst_percentage, SUM(poi.total_price * pgs.gst_percentage / 100) as gst_amount
                                         FROM purchase_orders po 
                                         LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                         LEFT JOIN products p ON poi.product_id = p.id
                                         LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                         WHERE po.status = 'completed' 
                                         AND po.branch_id = $branch_id
                                         AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'
                                         AND pgs.gst_applicable = 1";
                    if ($supplier_filter !== 'all') {
                        $gst_breakdown_sql .= " AND po.supplier_id = " . intval($supplier_filter);
                    }
                    $gst_breakdown_sql .= " GROUP BY pgs.gst_percentage";
                    
                    $gst_result = $conn->query($gst_breakdown_sql);
                    
                    $gst_rates = [];
                    while($row = $gst_result->fetch_assoc()) {
                        if ($row['gst_percentage'] > 0) {
                            $gst_rates[$row['gst_percentage']] = $row['gst_amount'];
                        }
                    }
                    
                    foreach ($gst_rates as $rate => $amount):
                    ?>
                    <div class="col-md-3">
                        <div class="card bg-light">
                            <div class="card-body text-center">
                                <h5 class="card-title text-purple"><?php echo $rate; ?>% GST</h5>
                                <h4 class="text-purple">₹<?php echo number_format($amount, 2); ?></h4>
                                <p class="text-muted mb-0">Paid by branch</p>
                                <small class="text-muted"><i class="fas fa-store"></i> Your branch</small>
                            </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 paid by your branch in the selected period</p>
                                <small class="text-muted"><i class="fas fa-store"></i> <?php echo htmlspecialchars($branch_info['branch_name']); ?></small>
                            </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 Purchase 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 Purchases';
                                                ?>
                                            </span>
                                            <?php if ($supplier_filter !== 'all'): 
                                                $supplier_name_sql = "SELECT name FROM suppliers WHERE id = " . intval($supplier_filter);
                                                $supplier_name_result = $conn->query($supplier_name_sql);
                                                if ($supplier_name_result->num_rows > 0) {
                                                    $supplier_data = $supplier_name_result->fetch_assoc();
                                                    echo '<span class="badge bg-warning ms-1">' . htmlspecialchars($supplier_data['name']) . '</span>';
                                                }
                                            endif; ?>
                                            <span class="badge bg-primary ms-1">
                                                <i class="fas fa-store me-1"></i><?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                            </span>
                                        </p>
                                    </div>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <a href="gst-purchase.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>
                                        <a href="gst-purchase.php?<?php echo http_build_query(array_merge($_GET, ['export' => 'pdf'])); ?>" class="btn btn-danger" id="exportPDF">
                                            <i class="fas fa-file-pdf me-2"></i>Export PDF
                                        </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 Purchases</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">
                                        <label for="supplierFilter" class="form-label">Supplier</label>
                                        <select class="form-select" id="supplierFilter">
                                            <option value="all">All Suppliers</option>
                                            <?php
                                            $suppliers_sql = "SELECT * FROM suppliers WHERE status = 'active' ORDER BY name";
                                            $suppliers_result = $conn->query($suppliers_sql);
                                            while($supplier = $suppliers_result->fetch_assoc()) {
                                                $selected = ($supplier_filter == $supplier['id']) ? 'selected' : '';
                                                echo '<option value="' . $supplier['id'] . '" ' . $selected . '>' . htmlspecialchars($supplier['name']) . '</option>';
                                            }
                                            ?>
                                        </select>
                                        <div class="form-text">Suppliers are shared across branches</div>
                                    </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="gstPurchaseTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>PO No.</th>
                                                <th>Date</th>
                                                <th>Supplier</th>
                                                <th>Supplier GST</th>
                                                <th>Product</th>
                                                <th>Model</th>
                                                <th>Qty</th>
                                                <th>Unit Price</th>
                                                <th>Total</th>
                                                <th>GST Rate</th>
                                                <th>GST Amount</th>
                                                <th>Total with GST</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters - Only purchases from this branch
                                            $where_conditions = ["po.status = 'completed'", "po.branch_id = $branch_id"];
                                            $where_conditions[] = "DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'";

if ($gst_filter === 'with_gst') {
                                                $where_conditions[] = "pgs.gst_applicable = 1";
                                            } elseif ($gst_filter === 'without_gst') {
                                                $where_conditions[] = "(pgs.gst_applicable = 0 OR pgs.gst_applicable IS NULL)";
                                            }

if ($supplier_filter !== 'all') {
                                                $where_conditions[] = "po.supplier_id = " . intval($supplier_filter);
                                            }

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

// Get total count for pagination
                                            $count_sql = "SELECT COUNT(*) as total 
                                                FROM purchase_orders po 
                                                LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                LEFT JOIN products p ON poi.product_id = p.id
                                                LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                WHERE $where_sql";
                                            $count_result = $conn->query($count_sql);
                                            $total_purchases = $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_purchases / $per_page);

// Main query
                                            $sql = "SELECT po.*, s.name as supplier_name, s.gst_number as supplier_gst,
                                                           poi.*, p.product_name, p.model, 
                                                           COALESCE(pgs.gst_applicable, 0) as gst_applicable,
                                                           COALESCE(pgs.gst_percentage, 0) as gst_percentage
                                                    FROM purchase_orders po 
                                                    LEFT JOIN suppliers s ON po.supplier_id = s.id 
                                                    LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                                                    LEFT JOIN products p ON poi.product_id = p.id
                                                    LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                                                    WHERE $where_sql 
                                                    ORDER BY po.order_date DESC 
                                                    LIMIT $offset, $per_page";
                                            
                                            $result = $conn->query($sql);

if ($result->num_rows > 0) {
                                                while($purchase = $result->fetch_assoc()) {
                                                    $gst_rate_display = $purchase['gst_applicable'] ? 
                                                        '<span class="badge badge-gst">' . $purchase['gst_percentage'] . '%</span>' : 
                                                        '<span class="badge bg-secondary">No GST</span>';
                                                    
                                                    $gst_amount = 0;
                                                    $total_with_gst = $purchase['total_price'];
                                                    
                                                    if ($purchase['gst_applicable']) {
                                                        $gst_amount = ($purchase['total_price'] * $purchase['gst_percentage']) / 100;
                                                        $total_with_gst = $purchase['total_price'] + $gst_amount;
                                                    }
                                            ?>
                                            <tr>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($purchase['po_number']); ?></strong>
                                                    <br><small class="text-muted"><i class="fas fa-store"></i> Branch PO</small>
                                                </td>
                                                <td>
                                                    <?php echo date('d M Y', strtotime($purchase['order_date'])); ?>
                                                </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-truck font-size-13 text-primary"></i>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($purchase['supplier_name']); ?></h6>
                                                            <small class="text-muted">Shared supplier</small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <small><?php echo htmlspecialchars($purchase['supplier_gst'] ?? 'N/A'); ?></small>
                                                </td>
                                                <td>
                                                    <?php echo htmlspecialchars($purchase['product_name']); ?>
                                                </td>
                                                <td>
                                                    <small class="text-muted"><?php echo htmlspecialchars($purchase['model']); ?></small>
                                                </td>
                                                <td>
                                                    <?php echo $purchase['quantity']; ?>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-info">₹<?php echo number_format($purchase['unit_price'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-primary">₹<?php echo number_format($purchase['total_price'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <?php echo $gst_rate_display; ?>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-success">₹<?php echo number_format($gst_amount, 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-purple">₹<?php echo number_format($total_with_gst, 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-success">
                                                        <i class="fas fa-check-circle me-1"></i>Completed
                                                    </span>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="13" class="text-center py-4">
                                                    <i class="fas fa-file-invoice display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Purchase Records Found</h5>
                                                    <p class="text-muted">No purchase records found for your branch in the selected 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')?>

<?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 (supplierFilter && supplierFilter.value) params.set('supplier', supplierFilter.value);
            
            window.location.href = 'gst-purchase.php?' + params.toString();
        });
    }

// 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-purchase.php?' . http_build_query($params);
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation