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/trading

Free Space:

10.17 TB

🔧 Quick Actions

✏️ Editing: gst_report.php

<?php
date_default_timezone_set('Asia/Kolkata');
session_start();
require_once 'config/database.php';

if (!isset($_SESSION['user_id'])) {
    header('Location: login.php');
    exit();
}

if (!in_array($_SESSION['role'], ['admin', 'warehouse_manager', 'shop_manager'])) {
    header('Location: dashboard.php');
    exit();
}

$user_id = $_SESSION['user_id'];
$current_business_id = $_SESSION['current_business_id'] ?? null;

if (!$current_business_id) {
    $_SESSION['error'] = "Please select a business first.";
    header('Location: select_shop.php');
    exit();
}

// Default date range (current month)
$start_date = date('Y-m-01');
$end_date = date('Y-m-t');

// Get filters
$filter_start_date = $_GET['start_date'] ?? $start_date;
$filter_end_date = $_GET['end_date'] ?? $end_date;
$shop_id = $_GET['shop_id'] ?? 'all';
$gst_type = $_GET['gst_type'] ?? 'all';
$report_type = $_GET['report_type'] ?? 'summary';
$export_type = $_GET['export'] ?? ''; // excel, json, csv

// Get shops for filter
$shopsStmt = $pdo->prepare("
    SELECT id, shop_name, shop_code 
    FROM shops 
    WHERE business_id = ? 
      AND is_active = 1 
    ORDER BY shop_name
");
$shopsStmt->execute([$current_business_id]);
$shops = $shopsStmt->fetchAll(PDO::FETCH_ASSOC);

function getShopName($shops, $shop_id)
{
    if (!$shop_id || $shop_id === 'all') {
        return 'All Shops';
    }

foreach ($shops as $shop) {
        if ((string)$shop['id'] === (string)$shop_id) {
            return $shop['shop_name'];
        }
    }

return 'All Shops';
}

// Function to get GST summary
function getGSTSummary($pdo, $business_id, $start_date, $end_date, $shop_id)
{
    $params = [$business_id, $start_date, $end_date];
    $shop_condition = '';

if ($shop_id && $shop_id !== 'all') {
        $shop_condition = " AND i.shop_id = ?";
        $params[] = $shop_id;
    }

$query = "
        SELECT 
            DATE(i.created_at) as invoice_date,
            i.id as invoice_id,
            i.invoice_number,
            i.customer_type,
            i.gst_status,
            s.shop_name,
            c.name as customer_name,
            c.gstin as customer_gstin,
            SUM(COALESCE(ii.taxable_value, 0)) as total_taxable_value,
            SUM(COALESCE(ii.cgst_amount, 0)) as total_cgst,
            SUM(COALESCE(ii.sgst_amount, 0)) as total_sgst,
            SUM(COALESCE(ii.igst_amount, 0)) as total_igst,
            SUM(COALESCE(ii.cgst_amount, 0) + COALESCE(ii.sgst_amount, 0) + COALESCE(ii.igst_amount, 0)) as total_gst,
            SUM(COALESCE(ii.total_with_gst, 0)) as invoice_total
        FROM invoices i
        INNER JOIN invoice_items ii ON i.id = ii.invoice_id
        INNER JOIN shops s ON i.shop_id = s.id
        INNER JOIN customers c ON i.customer_id = c.id
        WHERE i.business_id = ?
          AND DATE(i.created_at) BETWEEN ? AND ?
          AND i.gst_status = 1
          $shop_condition
        GROUP BY i.id, DATE(i.created_at), i.invoice_number, i.customer_type, i.gst_status, s.shop_name, c.name, c.gstin
        ORDER BY i.created_at DESC
    ";

$stmt = $pdo->prepare($query);
    $stmt->execute($params);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// Function to get HSN-wise GST summary
function getHSNWiseGST($pdo, $business_id, $start_date, $end_date, $shop_id)
{
    $params = [$business_id, $start_date, $end_date];
    $shop_condition = '';

if ($shop_id && $shop_id !== 'all') {
        $shop_condition = " AND i.shop_id = ?";
        $params[] = $shop_id;
    }

$query = "
        SELECT 
            COALESCE(ii.hsn_code, 'NO-HSN') as hsn_code,
            COALESCE(p.product_name, ii.product_name, 'Unknown Product') as product_name,
            COUNT(DISTINCT i.id) as invoice_count,
            SUM(COALESCE(ii.quantity, 0)) as total_quantity,
            SUM(COALESCE(ii.taxable_value, 0)) as total_taxable_value,
            SUM(COALESCE(ii.cgst_amount, 0)) as total_cgst,
            SUM(COALESCE(ii.sgst_amount, 0)) as total_sgst,
            SUM(COALESCE(ii.igst_amount, 0)) as total_igst,
            ROUND(AVG(COALESCE(ii.cgst_rate, 0)), 2) as avg_cgst_rate,
            ROUND(AVG(COALESCE(ii.sgst_rate, 0)), 2) as avg_sgst_rate,
            ROUND(AVG(COALESCE(ii.igst_rate, 0)), 2) as avg_igst_rate
        FROM invoice_items ii
        INNER JOIN invoices i ON ii.invoice_id = i.id
        LEFT JOIN products p ON ii.product_id = p.id
        WHERE i.business_id = ?
          AND DATE(i.created_at) BETWEEN ? AND ?
          AND i.gst_status = 1
          $shop_condition
        GROUP BY COALESCE(ii.hsn_code, 'NO-HSN'), COALESCE(p.product_name, ii.product_name, 'Unknown Product')
        ORDER BY total_taxable_value DESC
    ";

$stmt = $pdo->prepare($query);
    $stmt->execute($params);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// Function to get monthly GST trend
function getMonthlyGSTTrend($pdo, $business_id, $year, $shop_id)
{
    $params = [$business_id, $year . '-01-01', $year . '-12-31'];
    $shop_condition = '';

if ($shop_id && $shop_id !== 'all') {
        $shop_condition = " AND i.shop_id = ?";
        $params[] = $shop_id;
    }

$query = "
        SELECT 
            DATE_FORMAT(i.created_at, '%Y-%m') as month,
            DATE_FORMAT(i.created_at, '%M %Y') as month_name,
            COUNT(DISTINCT i.id) as invoice_count,
            SUM(COALESCE(ii.taxable_value, 0)) as total_taxable_value,
            SUM(COALESCE(ii.cgst_amount, 0)) as total_cgst,
            SUM(COALESCE(ii.sgst_amount, 0)) as total_sgst,
            SUM(COALESCE(ii.igst_amount, 0)) as total_igst,
            SUM(COALESCE(ii.cgst_amount, 0) + COALESCE(ii.sgst_amount, 0) + COALESCE(ii.igst_amount, 0)) as total_gst
        FROM invoices i
        INNER JOIN invoice_items ii ON i.id = ii.invoice_id
        WHERE i.business_id = ?
          AND DATE(i.created_at) BETWEEN ? AND ?
          AND i.gst_status = 1
          $shop_condition
        GROUP BY DATE_FORMAT(i.created_at, '%Y-%m'), DATE_FORMAT(i.created_at, '%M %Y')
        ORDER BY month
    ";

$stmt = $pdo->prepare($query);
    $stmt->execute($params);
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

// HSN-wise amount per invoice for export
function getInvoiceHSNSummary($pdo, $invoice_id)
{
    $stmt = $pdo->prepare("
        SELECT 
            COALESCE(ii.hsn_code, 'NO-HSN') as hsn_code,
            SUM(COALESCE(ii.taxable_value, 0)) as hsn_taxable_value
        FROM invoice_items ii
        WHERE ii.invoice_id = ?
        GROUP BY COALESCE(ii.hsn_code, 'NO-HSN')
        ORDER BY hsn_code
    ");
    $stmt->execute([$invoice_id]);
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

$parts = [];
    foreach ($rows as $row) {
        $parts[] = $row['hsn_code'] . ': ' . number_format((float)$row['hsn_taxable_value'], 2, '.', '');
    }

return implode(' | ', $parts);
}

// Get reports based on type
$gst_summary = [];
$hsn_summary = [];
$monthly_trend = [];
$year = date('Y');

if ($report_type === 'summary') {
    $gst_summary = getGSTSummary($pdo, $current_business_id, $filter_start_date, $filter_end_date, $shop_id);
} elseif ($report_type === 'hsn') {
    $hsn_summary = getHSNWiseGST($pdo, $current_business_id, $filter_start_date, $filter_end_date, $shop_id);
} elseif ($report_type === 'monthly') {
    if (isset($_GET['year']) && preg_match('/^\d{4}$/', (string)$_GET['year'])) {
        $year = $_GET['year'];
    }
    $monthly_trend = getMonthlyGSTTrend($pdo, $current_business_id, $year, $shop_id);
}

// Calculate totals
$total_taxable = 0;
$total_cgst = 0;
$total_sgst = 0;
$total_igst = 0;
$total_gst = 0;
$total_invoices = 0;
$total_invoice_amount = 0;

if ($report_type === 'summary') {
    foreach ($gst_summary as $row) {
        $total_taxable += (float)$row['total_taxable_value'];
        $total_cgst += (float)$row['total_cgst'];
        $total_sgst += (float)$row['total_sgst'];
        $total_igst += (float)$row['total_igst'];
        $total_gst += (float)$row['total_gst'];
        $total_invoice_amount += (float)$row['invoice_total'];
        $total_invoices++;
    }
}

if ($report_type === 'hsn') {
    foreach ($hsn_summary as $row) {
        $total_taxable += (float)$row['total_taxable_value'];
        $total_cgst += (float)$row['total_cgst'];
        $total_sgst += (float)$row['total_sgst'];
        $total_igst += (float)$row['total_igst'];
    }
}

// Get GST rates for reference
$gstRatesStmt = $pdo->prepare("
    SELECT hsn_code, description, cgst_rate, sgst_rate, igst_rate, status 
    FROM gst_rates 
    WHERE business_id = ? 
    ORDER BY hsn_code
");
$gstRatesStmt->execute([$current_business_id]);
$gst_rates_list = $gstRatesStmt->fetchAll(PDO::FETCH_ASSOC);

// Export to CSV function
function exportToCSV($report_type, $start_date, $end_date, $shop_id)
{
    global $pdo, $current_business_id, $shops;

$filename = "gst_report_" . date('Y_m_d_H_i_s') . ".csv";

header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename="' . $filename . '"');

$output = fopen('php://output', 'w');
    fwrite($output, "\xEF\xBB\xBF");

$shop_name = getShopName($shops, $shop_id);

fputcsv($output, ['GST Report - ' . ucfirst($report_type)]);
    fputcsv($output, ['Period: ' . date('d M Y', strtotime($start_date)) . ' to ' . date('d M Y', strtotime($end_date))]);
    fputcsv($output, ['Shop: ' . $shop_name]);
    fputcsv($output, ['Generated on: ' . date('d M Y h:i A')]);
    fputcsv($output, ['']);

if ($report_type === 'summary') {
        $data = getGSTSummary($pdo, $current_business_id, $start_date, $end_date, $shop_id);

fputcsv($output, ['Date', 'Invoice No', 'Customer', 'Customer GSTIN', 'Customer Type', 'Shop', 'HSN Wise Amount', 'Taxable Value', 'CGST', 'SGST', 'IGST', 'Total GST', 'Invoice Total']);

$grand_taxable = 0;
        $grand_cgst = 0;
        $grand_sgst = 0;
        $grand_igst = 0;
        $grand_gst = 0;
        $grand_total = 0;

foreach ($data as $row) {
            $hsn_wise_amount = getInvoiceHSNSummary($pdo, $row['invoice_id']);

fputcsv($output, [
                date('d M Y', strtotime($row['invoice_date'])),
                $row['invoice_number'],
                $row['customer_name'],
                $row['customer_gstin'],
                $row['customer_type'],
                $row['shop_name'],
                $hsn_wise_amount,
                number_format((float)$row['total_taxable_value'], 2, '.', ''),
                number_format((float)$row['total_cgst'], 2, '.', ''),
                number_format((float)$row['total_sgst'], 2, '.', ''),
                number_format((float)$row['total_igst'], 2, '.', ''),
                number_format((float)$row['total_gst'], 2, '.', ''),
                number_format((float)$row['invoice_total'], 2, '.', '')
            ]);

$grand_taxable += (float)$row['total_taxable_value'];
            $grand_cgst += (float)$row['total_cgst'];
            $grand_sgst += (float)$row['total_sgst'];
            $grand_igst += (float)$row['total_igst'];
            $grand_gst += (float)$row['total_gst'];
            $grand_total += (float)$row['invoice_total'];
        }

fputcsv($output, ['']);
        fputcsv($output, ['GRAND TOTALS', '', '', '', '', '', '',
            number_format($grand_taxable, 2, '.', ''),
            number_format($grand_cgst, 2, '.', ''),
            number_format($grand_sgst, 2, '.', ''),
            number_format($grand_igst, 2, '.', ''),
            number_format($grand_gst, 2, '.', ''),
            number_format($grand_total, 2, '.', '')
        ]);

fputcsv($output, ['']);
        fputcsv($output, ['OVERALL SUMMARY']);
        fputcsv($output, ['Total Invoices', count($data)]);
        fputcsv($output, ['Total Taxable Value', '₹' . number_format($grand_taxable, 2, '.', '')]);
        fputcsv($output, ['Total CGST', '₹' . number_format($grand_cgst, 2, '.', '')]);
        fputcsv($output, ['Total SGST', '₹' . number_format($grand_sgst, 2, '.', '')]);
        fputcsv($output, ['Total IGST', '₹' . number_format($grand_igst, 2, '.', '')]);
        fputcsv($output, ['Total GST', '₹' . number_format($grand_gst, 2, '.', '')]);
        fputcsv($output, ['Grand Total', '₹' . number_format($grand_total, 2, '.', '')]);

if ($grand_taxable > 0) {
            $effective_rate = ($grand_gst / $grand_taxable) * 100;
            fputcsv($output, ['Effective GST Rate', number_format($effective_rate, 2) . '%']);
        }
    } elseif ($report_type === 'hsn') {
        $data = getHSNWiseGST($pdo, $current_business_id, $start_date, $end_date, $shop_id);

fputcsv($output, ['HSN Code', 'Product Name', 'Invoices', 'Quantity', 'Avg CGST %', 'Avg SGST %', 'Avg IGST %', 'Taxable Value', 'CGST', 'SGST', 'IGST', 'Total GST']);

$grand_taxable = 0;
        $grand_cgst = 0;
        $grand_sgst = 0;
        $grand_igst = 0;

foreach ($data as $row) {
            fputcsv($output, [
                $row['hsn_code'],
                $row['product_name'],
                $row['invoice_count'],
                $row['total_quantity'],
                number_format((float)$row['avg_cgst_rate'], 2),
                number_format((float)$row['avg_sgst_rate'], 2),
                number_format((float)$row['avg_igst_rate'], 2),
                number_format((float)$row['total_taxable_value'], 2, '.', ''),
                number_format((float)$row['total_cgst'], 2, '.', ''),
                number_format((float)$row['total_sgst'], 2, '.', ''),
                number_format((float)$row['total_igst'], 2, '.', ''),
                number_format((float)$row['total_cgst'] + (float)$row['total_sgst'] + (float)$row['total_igst'], 2, '.', '')
            ]);

fputcsv($output, ['']);
        fputcsv($output, ['GRAND TOTALS', '', '', '', '', '', '',
            number_format($grand_taxable, 2, '.', ''),
            number_format($grand_cgst, 2, '.', ''),
            number_format($grand_sgst, 2, '.', ''),
            number_format($grand_igst, 2, '.', ''),
            number_format($grand_cgst + $grand_sgst + $grand_igst, 2, '.', '')
        ]);
    } elseif ($report_type === 'monthly') {
        $year = date('Y');
        $data = getMonthlyGSTTrend($pdo, $current_business_id, $year, $shop_id);

fputcsv($output, ['Month', 'Invoices', 'Taxable Value', 'CGST', 'SGST', 'IGST', 'Total GST', 'GST %']);

$yearly_taxable = 0;
        $yearly_cgst = 0;
        $yearly_sgst = 0;
        $yearly_igst = 0;
        $yearly_gst = 0;

foreach ($data as $row) {
            $gst_percentage = (float)$row['total_taxable_value'] > 0
                ? (((float)$row['total_gst']) / ((float)$row['total_taxable_value'])) * 100
                : 0;

fputcsv($output, [
                $row['month_name'],
                $row['invoice_count'],
                number_format((float)$row['total_taxable_value'], 2, '.', ''),
                number_format((float)$row['total_cgst'], 2, '.', ''),
                number_format((float)$row['total_sgst'], 2, '.', ''),
                number_format((float)$row['total_igst'], 2, '.', ''),
                number_format((float)$row['total_gst'], 2, '.', ''),
                number_format($gst_percentage, 2)
            ]);

$yearly_taxable += (float)$row['total_taxable_value'];
            $yearly_cgst += (float)$row['total_cgst'];
            $yearly_sgst += (float)$row['total_sgst'];
            $yearly_igst += (float)$row['total_igst'];
            $yearly_gst += (float)$row['total_gst'];
        }

fputcsv($output, ['']);
        $yearly_gst_percentage = $yearly_taxable > 0 ? ($yearly_gst / $yearly_taxable) * 100 : 0;

fputcsv($output, ['YEARLY TOTALS', array_sum(array_column($data, 'invoice_count')),
            number_format($yearly_taxable, 2, '.', ''),
            number_format($yearly_cgst, 2, '.', ''),
            number_format($yearly_sgst, 2, '.', ''),
            number_format($yearly_igst, 2, '.', ''),
            number_format($yearly_gst, 2, '.', ''),
            number_format($yearly_gst_percentage, 2) . '%'
        ]);
    }

fclose($output);
    exit();
}

// Export to Excel function
function exportToExcel($report_type, $start_date, $end_date, $shop_id)
{
    global $pdo, $current_business_id, $shops;

$filename = "gst_report_" . date('Y_m_d') . ".xls";

header("Content-Type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=\"$filename\"");

$shop_name = getShopName($shops, $shop_id);

echo "<html>";
    echo "<head>";
    echo "<meta charset='UTF-8'>";
    echo "<style>";
    echo "td { padding: 5px; border: 1px solid #ddd; }";
    echo "th { background-color: #f2f2f2; padding: 8px; border: 1px solid #ddd; }";
    echo ".header { background-color: #4CAF50; color: white; font-weight: bold; }";
    echo ".total { background-color: #e8f5e9; font-weight: bold; }";
    echo "</style>";
    echo "</head>";
    echo "<body>";
    echo "<table border='1'>";

echo "<tr><td colspan='13' class='header' style='text-align:center;'>";
    echo "<h2>GST Report - " . ucfirst($report_type) . "</h2>";
    echo "<p>Period: " . date('d M Y', strtotime($start_date)) . " to " . date('d M Y', strtotime($end_date)) . "</p>";
    echo "<p>Shop: " . htmlspecialchars($shop_name) . "</p>";
    echo "<p>Generated on: " . date('d M Y h:i A') . "</p>";
    echo "</td></tr>";

if ($report_type === 'summary') {
        $data = getGSTSummary($pdo, $current_business_id, $start_date, $end_date, $shop_id);

echo "<tr>";
        echo "<th>Date</th>";
        echo "<th>Invoice No</th>";
        echo "<th>Customer</th>";
        echo "<th>Customer GSTIN</th>";
        echo "<th>Customer Type</th>";
        echo "<th>Shop</th>";
        echo "<th>HSN Wise Amount</th>";
        echo "<th>Taxable Value</th>";
        echo "<th>CGST</th>";
        echo "<th>SGST</th>";
        echo "<th>IGST</th>";
        echo "<th>Total GST</th>";
        echo "<th>Invoice Total</th>";
        echo "</tr>";

$total_taxable = 0;
        $total_cgst = 0;
        $total_sgst = 0;
        $total_igst = 0;
        $total_gst = 0;
        $total_invoice = 0;

foreach ($data as $row) {
            $hsn_wise_amount = getInvoiceHSNSummary($pdo, $row['invoice_id']);

echo "<tr>";
            echo "<td>" . date('d M Y', strtotime($row['invoice_date'])) . "</td>";
            echo "<td>" . htmlspecialchars((string)($row['invoice_number'] ?? ''), ENT_QUOTES, 'UTF-8') . "</td>";
echo "<td>" . htmlspecialchars((string)($row['customer_name'] ?? ''), ENT_QUOTES, 'UTF-8') . "</td>";
echo "<td>" . htmlspecialchars((string)($row['customer_gstin'] ?? ''), ENT_QUOTES, 'UTF-8') . "</td>";
echo "<td>" . htmlspecialchars((string)ucfirst((string)($row['customer_type'] ?? '')), ENT_QUOTES, 'UTF-8') . "</td>";
echo "<td>" . htmlspecialchars((string)($row['shop_name'] ?? ''), ENT_QUOTES, 'UTF-8') . "</td>";
echo "<td>" . htmlspecialchars((string)($hsn_wise_amount ?? ''), ENT_QUOTES, 'UTF-8') . "</td>";
            echo "<td>" . number_format((float)$row['total_taxable_value'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_cgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_sgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_igst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_gst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['invoice_total'], 2) . "</td>";
            echo "</tr>";

$total_taxable += (float)$row['total_taxable_value'];
            $total_cgst += (float)$row['total_cgst'];
            $total_sgst += (float)$row['total_sgst'];
            $total_igst += (float)$row['total_igst'];
            $total_gst += (float)$row['total_gst'];
            $total_invoice += (float)$row['invoice_total'];
        }

echo "<tr class='total'>";
        echo "<td colspan='7'><strong>TOTALS</strong></td>";
        echo "<td><strong>" . number_format($total_taxable, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_cgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_sgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_igst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_gst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_invoice, 2) . "</strong></td>";
        echo "</tr>";
    } elseif ($report_type === 'hsn') {
        $data = getHSNWiseGST($pdo, $current_business_id, $start_date, $end_date, $shop_id);

echo "<tr>";
        echo "<th>HSN Code</th>";
        echo "<th>Product Name</th>";
        echo "<th>Invoice Count</th>";
        echo "<th>Total Quantity</th>";
        echo "<th>Avg CGST %</th>";
        echo "<th>Avg SGST %</th>";
        echo "<th>Avg IGST %</th>";
        echo "<th>Taxable Value</th>";
        echo "<th>CGST</th>";
        echo "<th>SGST</th>";
        echo "<th>IGST</th>";
        echo "<th>Total GST</th>";
        echo "</tr>";

$total_taxable = 0;
        $total_cgst = 0;
        $total_sgst = 0;
        $total_igst = 0;

foreach ($data as $row) {
            echo "<tr>";
            echo "<td>" . htmlspecialchars($row['hsn_code']) . "</td>";
            echo "<td>" . htmlspecialchars($row['product_name']) . "</td>";
            echo "<td>" . (int)$row['invoice_count'] . "</td>";
            echo "<td>" . number_format((float)$row['total_quantity'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['avg_cgst_rate'], 2) . "%</td>";
            echo "<td>" . number_format((float)$row['avg_sgst_rate'], 2) . "%</td>";
            echo "<td>" . number_format((float)$row['avg_igst_rate'], 2) . "%</td>";
            echo "<td>" . number_format((float)$row['total_taxable_value'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_cgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_sgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_igst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_cgst'] + (float)$row['total_sgst'] + (float)$row['total_igst'], 2) . "</td>";
            echo "</tr>";

echo "<tr class='total'>";
        echo "<td colspan='7'><strong>TOTALS</strong></td>";
        echo "<td><strong>" . number_format($total_taxable, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_cgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_sgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_igst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_cgst + $total_sgst + $total_igst, 2) . "</strong></td>";
        echo "</tr>";
    } elseif ($report_type === 'monthly') {
        $year = date('Y');
        $data = getMonthlyGSTTrend($pdo, $current_business_id, $year, $shop_id);

echo "<tr>";
        echo "<th>Month</th>";
        echo "<th>Invoice Count</th>";
        echo "<th>Taxable Value</th>";
        echo "<th>CGST</th>";
        echo "<th>SGST</th>";
        echo "<th>IGST</th>";
        echo "<th>Total GST</th>";
        echo "<th>GST %</th>";
        echo "</tr>";

$total_taxable = 0;
        $total_cgst = 0;
        $total_sgst = 0;
        $total_igst = 0;
        $total_gst = 0;
        $total_invoices = 0;

echo "<tr>";
            echo "<td>" . htmlspecialchars($row['month_name']) . "</td>";
            echo "<td>" . (int)$row['invoice_count'] . "</td>";
            echo "<td>" . number_format((float)$row['total_taxable_value'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_cgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_sgst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_igst'], 2) . "</td>";
            echo "<td>" . number_format((float)$row['total_gst'], 2) . "</td>";
            echo "<td>" . number_format($gst_percentage, 2) . "%</td>";
            echo "</tr>";

$yearly_gst_percentage = $total_taxable > 0 ? ($total_gst / $total_taxable) * 100 : 0;

echo "<tr class='total'>";
        echo "<td><strong>Yearly Totals</strong></td>";
        echo "<td><strong>" . $total_invoices . "</strong></td>";
        echo "<td><strong>" . number_format($total_taxable, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_cgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_sgst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_igst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($total_gst, 2) . "</strong></td>";
        echo "<td><strong>" . number_format($yearly_gst_percentage, 2) . "%</strong></td>";
        echo "</tr>";
    }

echo "</table>";
    echo "</body></html>";
    exit();
}

// Export to JSON function
function exportToJSON($report_type, $start_date, $end_date, $shop_id)
{
    global $pdo, $current_business_id, $shops;

$shop_name = getShopName($shops, $shop_id);

$report_data = [
        'metadata' => [
            'report_type' => $report_type,
            'period' => [
                'start_date' => $start_date,
                'end_date' => $end_date,
                'display_period' => date('d M Y', strtotime($start_date)) . ' to ' . date('d M Y', strtotime($end_date))
            ],
            'shop' => $shop_name,
            'generated_on' => date('Y-m-d H:i:s'),
            'format' => 'JSON'
        ],
        'data' => []
    ];

if ($report_type === 'summary') {
        $data = getGSTSummary($pdo, $current_business_id, $start_date, $end_date, $shop_id);
        foreach ($data as &$row) {
            $row['hsn_wise_amount'] = getInvoiceHSNSummary($pdo, $row['invoice_id']);
        }
        unset($row);

$report_data['data'] = $data;
        $report_data['summary'] = [
            'total_invoices' => count($data),
            'total_taxable_value' => array_sum(array_column($data, 'total_taxable_value')),
            'total_cgst' => array_sum(array_column($data, 'total_cgst')),
            'total_sgst' => array_sum(array_column($data, 'total_sgst')),
            'total_igst' => array_sum(array_column($data, 'total_igst')),
            'total_gst' => array_sum(array_column($data, 'total_gst')),
            'grand_total' => array_sum(array_column($data, 'invoice_total'))
        ];
    } elseif ($report_type === 'hsn') {
        $data = getHSNWiseGST($pdo, $current_business_id, $start_date, $end_date, $shop_id);

$report_data['data'] = $data;
        $report_data['summary'] = [
            'total_hsn_codes' => count($data),
            'total_taxable_value' => array_sum(array_column($data, 'total_taxable_value')),
            'total_cgst' => array_sum(array_column($data, 'total_cgst')),
            'total_sgst' => array_sum(array_column($data, 'total_sgst')),
            'total_igst' => array_sum(array_column($data, 'total_igst')),
            'total_gst' => array_sum(array_map(function ($item) {
                return (float)$item['total_cgst'] + (float)$item['total_sgst'] + (float)$item['total_igst'];
            }, $data))
        ];
    } elseif ($report_type === 'monthly') {
        $year = date('Y');
        $data = getMonthlyGSTTrend($pdo, $current_business_id, $year, $shop_id);

$report_data['metadata']['year'] = $year;
        $report_data['data'] = $data;
        $report_data['summary'] = [
            'total_months' => count($data),
            'total_taxable_value' => array_sum(array_column($data, 'total_taxable_value')),
            'total_cgst' => array_sum(array_column($data, 'total_cgst')),
            'total_sgst' => array_sum(array_column($data, 'total_sgst')),
            'total_igst' => array_sum(array_column($data, 'total_igst')),
            'total_gst' => array_sum(array_column($data, 'total_gst'))
        ];
    }

header('Content-Type: application/json');
    header('Content-Disposition: attachment; filename="gst_report_' . date('Y_m_d') . '.json"');
    echo json_encode($report_data, JSON_PRETTY_PRINT);
    exit();
}

// Export functionality
if ($export_type === 'excel') {
    exportToExcel($report_type, $filter_start_date, $filter_end_date, $shop_id);
    exit();
} elseif ($export_type === 'json') {
    exportToJSON($report_type, $filter_start_date, $filter_end_date, $shop_id);
    exit();
} elseif ($export_type === 'csv') {
    exportToCSV($report_type, $filter_start_date, $filter_end_date, $shop_id);
    exit();
}
?>
<!doctype html>
<html lang="en">
<?php
$page_title = "GST Reports";
include('includes/head.php');
?>
<style>
.gst-card {
    border-left: 4px solid;
    transition: transform 0.2s;
}
.gst-card:hover {
    transform: translateY(-2px);
}
.gst-card.cgst { border-left-color: #0d6efd; }
.gst-card.sgst { border-left-color: #198754; }
.gst-card.igst { border-left-color: #fd7e14; }
.gst-card.total { border-left-color: #6f42c1; }

.summary-table th {
    background-color: #f8f9fa;
    font-weight: 600;
}

.hsn-row {
    transition: background-color 0.2s;
}
.hsn-row:hover {
    background-color: rgba(13, 110, 253, 0.05) !important;
}

.chart-container {
    position: relative;
    height: 300px;
    width: 100%;
}

.tax-breakdown {
    font-size: 0.85rem;
}

.download-btn {
    min-width: 120px;
}

.export-options {
    position: relative;
}

.export-dropdown {
    position: absolute;
    right: 0;
    left: auto;
    min-width: 180px;
}

.overall-summary {
    background-color: #f8f9fa;
    border-left: 4px solid #6f42c1;
}

.table-total-row {
    background-color: #e8f4ff !important;
    font-weight: bold;
}

.gst-composition-card {
    border: 1px solid #dee2e6;
    border-radius: 8px;
    overflow: hidden;
}

.composition-header {
    background-color: #f8f9fa;
    border-bottom: 1px solid #dee2e6;
    padding: 15px;
    font-weight: 600;
}

.composition-body {
    padding: 15px;
}

.distribution-item {
    margin-bottom: 15px;
}

.distribution-label {
    display: flex;
    justify-content: space-between;
    margin-bottom: 5px;
}

.distribution-progress {
    height: 8px;
    border-radius: 4px;
    background-color: #e9ecef;
    overflow: hidden;
}

@media print {
    .no-print {
        display: none !important;
    }
    .card {
        border: 1px solid #dee2e6 !important;
        box-shadow: none !important;
    }
    table {
        font-size: 11px !important;
    }
}
</style>
<body data-sidebar="dark">
<div id="layout-wrapper">
    <?php include('includes/topbar.php') ?>
    <div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php') ?>
        </div>
    </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">
                                <i class="bx bx-line-chart me-2"></i> GST Reports & Analytics
                                <small class="text-muted ms-2">
                                    <i class="bx bx-store me-1"></i>
                                    <?= htmlspecialchars($_SESSION['current_business_name'] ?? 'Business') ?>
                                </small>
                            </h4>
                            <div class="export-options">
                                <div class="btn-group no-print">
                                    <button type="button" class="btn btn-outline-primary dropdown-toggle" data-bs-toggle="dropdown">
                                        <i class="bx bx-download me-1"></i> Export
                                    </button>
                                    <div class="dropdown-menu export-dropdown">
                                        <a class="dropdown-item" href="#" onclick="window.print()">
                                            <i class="bx bx-printer me-2"></i> Print Report
                                        </a>
                                        <div class="dropdown-divider"></div>
                                        <h6 class="dropdown-header">Download As</h6>
                                        <a class="dropdown-item export-link" href="#" data-type="csv">
                                            <i class="bx bx-file me-2 text-success"></i> CSV (.csv)
                                        </a>
                                        <a class="dropdown-item export-link" href="#" data-type="excel">
                                            <i class="bx bx-file me-2 text-success"></i> Excel (.xls)
                                        </a>
                                        <a class="dropdown-item export-link" href="#" data-type="json">
                                            <i class="bx bx-code me-2 text-info"></i> JSON (.json)
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card shadow-sm">
                            <div class="card-header bg-light">
                                <h5 class="mb-0">
                                    <i class="bx bx-filter-alt me-2"></i> Report Filters
                                </h5>
                            </div>
                            <div class="card-body">
                                <form method="GET" id="reportForm" class="row g-3">
                                    <input type="hidden" name="export" id="exportType">
                                    <div class="col-md-3">
                                        <label class="form-label">Start Date</label>
                                        <input type="date" name="start_date" class="form-control"
                                               value="<?= htmlspecialchars($filter_start_date) ?>" required>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">End Date</label>
                                        <input type="date" name="end_date" class="form-control"
                                               value="<?= htmlspecialchars($filter_end_date) ?>" required>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Shop/Location</label>
                                        <select name="shop_id" class="form-select">
                                            <option value="all">All Shops</option>
                                            <?php foreach ($shops as $shop): ?>
                                                <option value="<?= $shop['id'] ?>" <?= (string)$shop_id === (string)$shop['id'] ? 'selected' : '' ?>>
                                                    <?= htmlspecialchars($shop['shop_name']) ?> (<?= htmlspecialchars($shop['shop_code']) ?>)
                                                </option>
                                            <?php endforeach; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="form-label">Report Type</label>
                                        <select name="report_type" class="form-select" onchange="this.form.submit()">
                                            <option value="summary" <?= $report_type === 'summary' ? 'selected' : '' ?>>Invoice Summary</option>
                                            <option value="hsn" <?= $report_type === 'hsn' ? 'selected' : '' ?>>HSN Code Wise</option>
                                            <option value="monthly" <?= $report_type === 'monthly' ? 'selected' : '' ?>>Monthly Trend</option>
                                        </select>
                                    </div>
                                    <div class="col-12">
                                        <div class="d-flex justify-content-between">
                                            <button type="submit" class="btn btn-primary">
                                                <i class="bx bx-refresh me-1"></i> Generate Report
                                            </button>
                                            <a href="gst_report.php" class="btn btn-outline-secondary">
                                                <i class="bx bx-reset me-1"></i> Reset Filters
                                            </a>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($report_type === 'summary'): ?>
                    <div class="row mb-4">
                        <div class="col-md-3">
                            <div class="card gst-card cgst shadow-sm">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">CGST</h6>
                                            <h3 class="mb-0">₹<?= number_format($total_cgst, 2) ?></h3>
                                            <small class="text-muted">Central GST Collection</small>
                                        </div>
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-primary bg-opacity-10 rounded">
                                                <i class="bx bx-building-house text-primary font-size-24"></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="col-md-3">
                            <div class="card gst-card sgst shadow-sm">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">SGST</h6>
                                            <h3 class="mb-0">₹<?= number_format($total_sgst, 2) ?></h3>
                                            <small class="text-muted">State GST Collection</small>
                                        </div>
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-success bg-opacity-10 rounded">
                                                <i class="bx bx-map text-success font-size-24"></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="col-md-3">
                            <div class="card gst-card igst shadow-sm">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">IGST</h6>
                                            <h3 class="mb-0">₹<?= number_format($total_igst, 2) ?></h3>
                                            <small class="text-muted">Interstate GST Collection</small>
                                        </div>
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-warning bg-opacity-10 rounded">
                                                <i class="bx bx-transfer-alt text-warning font-size-24"></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="col-md-3">
                            <div class="card gst-card total shadow-sm">
                                <div class="card-body">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="text-muted mb-2">Total GST</h6>
                                            <h3 class="mb-0">₹<?= number_format($total_gst, 2) ?></h3>
                                            <small class="text-muted"><?= $total_invoices ?> invoices</small>
                                        </div>
                                        <div class="avatar-sm">
                                            <span class="avatar-title bg-purple bg-opacity-10 rounded">
                                                <i class="bx bx-calculator text-purple font-size-24"></i>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card shadow-sm">
                            <div class="card-header bg-light">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="mb-0">
                                        <i class="bx bx-file me-2"></i>
                                        <?php
                                        $titles = [
                                            'summary' => 'GST Invoice Summary',
                                            'hsn' => 'HSN Code Wise GST Report',
                                            'monthly' => 'Monthly GST Trend'
                                        ];
                                        echo $titles[$report_type];
                                        ?>
                                    </h5>
                                    <div class="text-muted">
                                        Period: <?= date('d M Y', strtotime($filter_start_date)) ?> - <?= date('d M Y', strtotime($filter_end_date)) ?>
                                        <?php if ($shop_id !== 'all'): ?>
                                            | Shop: <?= htmlspecialchars(getShopName($shops, $shop_id)) ?>
                                        <?php endif; ?>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<?php if ($report_type === 'summary'): ?>

<div class="table-responsive">
                                        <table class="table table-hover summary-table" id="summaryTable">
                                            <thead class="table-light">
                                            <tr>
                                                <th>Date</th>
                                                <th>Invoice No.</th>
                                                <th>Customer</th>
                                                <th>Shop</th>
                                                <th class="text-end">Taxable Value</th>
                                                <th class="text-end">CGST</th>
                                                <th class="text-end">SGST</th>
                                                <th class="text-end">IGST</th>
                                                <th class="text-end">Total GST</th>
                                                <th class="text-end">Invoice Total</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <?php if (empty($gst_summary)): ?>
                                                <tr>
                                                    <td colspan="10" class="text-center py-4">
                                                        <i class="bx bx-line-chart fs-1 text-muted mb-2 d-block"></i>
                                                        <h5>No GST invoices found</h5>
                                                        <p class="text-muted">No GST-enabled invoices for the selected period.</p>
                                                    </td>
                                                </tr>
                                            <?php else: ?>
                                                <?php foreach ($gst_summary as $invoice): ?>
                                                    <tr>
                                                        <td><?= date('d M Y', strtotime($invoice['invoice_date'])) ?></td>
                                                        <td>
                                                            <a href="invoice_view.php?id=<?= (int)$invoice['invoice_id'] ?>" class="text-decoration-none">
                                                                <strong><?= htmlspecialchars($invoice['invoice_number']) ?></strong>
                                                            </a>
                                                        </td>
                                                        <td>
                                                            <div><?= htmlspecialchars($invoice['customer_name']) ?></div>
                                                            <small class="text-muted">
                                                                <?= htmlspecialchars($invoice['customer_type']) ?>
                                                                <?php if (!empty($invoice['customer_gstin'])): ?>
                                                                    | GSTIN: <?= htmlspecialchars($invoice['customer_gstin']) ?>
                                                                <?php endif; ?>
                                                            </small>
                                                        </td>
                                                        <td><?= htmlspecialchars($invoice['shop_name']) ?></td>
                                                        <td class="text-end">₹<?= number_format((float)$invoice['total_taxable_value'], 2) ?></td>
                                                        <td class="text-end">
                                                            <span class="badge bg-primary bg-opacity-10 text-primary px-3 py-1">
                                                                ₹<?= number_format((float)$invoice['total_cgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-success bg-opacity-10 text-success px-3 py-1">
                                                                ₹<?= number_format((float)$invoice['total_sgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-warning bg-opacity-10 text-warning px-3 py-1">
                                                                ₹<?= number_format((float)$invoice['total_igst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <strong class="text-dark">₹<?= number_format((float)$invoice['total_gst'], 2) ?></strong>
                                                        </td>
                                                        <td class="text-end">
                                                            <strong>₹<?= number_format((float)$invoice['invoice_total'], 2) ?></strong>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>

<tr class="table-total-row">
                                                    <td colspan="4" class="text-end"><strong>OVERALL TOTALS:</strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_taxable, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_cgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_sgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_igst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_gst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_invoice_amount, 2) ?></strong></td>
                                                </tr>
                                            <?php endif; ?>
                                            </tbody>
                                        </table>
                                    </div>

<?php if (!empty($gst_summary)): ?>
                                        <div class="row mt-4">
                                            <div class="col-md-6">
                                                <div class="card gst-composition-card">
                                                    <div class="composition-header">
                                                        <i class="bx bx-pie-chart-alt me-2"></i> GST Composition
                                                    </div>
                                                    <div class="composition-body">
                                                        <div class="row">
                                                            <div class="col-6">
                                                                <div class="mb-3">
                                                                    <small class="text-muted d-block">Taxable Value</small>
                                                                    <h5 class="mb-0">₹<?= number_format($total_taxable, 2) ?></h5>
                                                                </div>
                                                                <div class="mb-3">
                                                                    <small class="text-muted d-block">Total GST</small>
                                                                    <h5 class="mb-0 text-purple">₹<?= number_format($total_gst, 2) ?></h5>
                                                                </div>
                                                                <div class="mb-3">
                                                                    <small class="text-muted d-block">Grand Total</small>
                                                                    <h5 class="mb-0 text-dark">₹<?= number_format($total_invoice_amount, 2) ?></h5>
                                                                </div>
                                                            </div>
                                                            <div class="col-6">
                                                                <div class="mb-3">
                                                                    <small class="text-muted d-block">Total Invoices</small>
                                                                    <h5 class="mb-0"><?= $total_invoices ?></h5>
                                                                </div>
                                                                <?php if ($total_taxable > 0): ?>
                                                                    <div class="mb-3">
                                                                        <small class="text-muted d-block">Effective GST Rate</small>
                                                                        <h5 class="mb-0 text-primary">
                                                                            <?= number_format(($total_gst / $total_taxable) * 100, 2) ?>%
                                                                        </h5>
                                                                    </div>
                                                                <?php endif; ?>
                                                                <div class="mb-3">
                                                                    <small class="text-muted d-block">GST to Taxable Ratio</small>
                                                                    <h5 class="mb-0">
                                                                        <?= number_format($total_taxable > 0 ? ($total_gst / $total_taxable) * 100 : 0, 2) ?>%
                                                                    </h5>
                                                                </div>
                                                            </div>
                                                        </div>

<div class="row mt-3">
                                                            <div class="col-12">
                                                                <div class="row">
                                                                    <div class="col-4 text-center">
                                                                        <div class="p-2 border rounded">
                                                                            <small class="text-muted d-block">CGST</small>
                                                                            <h6 class="mb-0 text-primary">₹<?= number_format($total_cgst, 2) ?></h6>
                                                                            <small class="text-muted">
                                                                                <?= $total_gst > 0 ? number_format(($total_cgst / $total_gst) * 100, 1) : 0 ?>%
                                                                            </small>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-4 text-center">
                                                                        <div class="p-2 border rounded">
                                                                            <small class="text-muted d-block">SGST</small>
                                                                            <h6 class="mb-0 text-success">₹<?= number_format($total_sgst, 2) ?></h6>
                                                                            <small class="text-muted">
                                                                                <?= $total_gst > 0 ? number_format(($total_sgst / $total_gst) * 100, 1) : 0 ?>%
                                                                            </small>
                                                                        </div>
                                                                    </div>
                                                                    <div class="col-4 text-center">
                                                                        <div class="p-2 border rounded">
                                                                            <small class="text-muted d-block">IGST</small>
                                                                            <h6 class="mb-0 text-warning">₹<?= number_format($total_igst, 2) ?></h6>
                                                                            <small class="text-muted">
                                                                                <?= $total_gst > 0 ? number_format(($total_igst / $total_gst) * 100, 1) : 0 ?>%
                                                                            </small>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>

<div class="col-md-6">
                                                <div class="card gst-composition-card">
                                                    <div class="composition-header">
                                                        <i class="bx bx-bar-chart-alt me-2"></i> GST Distribution
                                                    </div>
                                                    <div class="composition-body">
                                                        <div class="distribution-item">
                                                            <div class="distribution-label">
                                                                <small>CGST (Central)</small>
                                                                <small class="text-primary"><?= $total_gst > 0 ? number_format(($total_cgst / $total_gst) * 100, 1) : 0 ?>%</small>
                                                            </div>
                                                            <div class="distribution-progress">
                                                                <div class="progress-bar bg-primary" role="progressbar" style="width: <?= $total_gst > 0 ? ($total_cgst / $total_gst) * 100 : 0 ?>%;"></div>
                                                            </div>
                                                            <small class="text-muted">₹<?= number_format($total_cgst, 2) ?></small>
                                                        </div>

<div class="distribution-item">
                                                            <div class="distribution-label">
                                                                <small>SGST (State)</small>
                                                                <small class="text-success"><?= $total_gst > 0 ? number_format(($total_sgst / $total_gst) * 100, 1) : 0 ?>%</small>
                                                            </div>
                                                            <div class="distribution-progress">
                                                                <div class="progress-bar bg-success" role="progressbar" style="width: <?= $total_gst > 0 ? ($total_sgst / $total_gst) * 100 : 0 ?>%;"></div>
                                                            </div>
                                                            <small class="text-muted">₹<?= number_format($total_sgst, 2) ?></small>
                                                        </div>

<div class="distribution-item">
                                                            <div class="distribution-label">
                                                                <small>IGST (Interstate)</small>
                                                                <small class="text-warning"><?= $total_gst > 0 ? number_format(($total_igst / $total_gst) * 100, 1) : 0 ?>%</small>
                                                            </div>
                                                            <div class="distribution-progress">
                                                                <div class="progress-bar bg-warning" role="progressbar" style="width: <?= $total_gst > 0 ? ($total_igst / $total_gst) * 100 : 0 ?>%;"></div>
                                                            </div>
                                                            <small class="text-muted">₹<?= number_format($total_igst, 2) ?></small>
                                                        </div>

<div class="row mt-4">
                                                            <div class="col-6">
                                                                <div class="p-3 border rounded text-center">
                                                                    <small class="text-muted d-block">Taxable Value</small>
                                                                    <h6 class="mb-0"><?= $total_invoice_amount > 0 ? number_format(($total_taxable / $total_invoice_amount) * 100, 1) : 0 ?>%</h6>
                                                                    <small class="text-muted">of Grand Total</small>
                                                                </div>
                                                            </div>
                                                            <div class="col-6">
                                                                <div class="p-3 border rounded text-center">
                                                                    <small class="text-muted d-block">Total GST</small>
                                                                    <h6 class="mb-0 text-purple"><?= $total_invoice_amount > 0 ? number_format(($total_gst / $total_invoice_amount) * 100, 1) : 0 ?>%</h6>
                                                                    <small class="text-muted">of Grand Total</small>
                                                                </div>
                                                            </div>
                                                        </div>

<div class="mt-3 pt-3 border-top">
                                                            <small class="text-muted">
                                                                <i class="bx bx-info-circle me-1"></i>
                                                                Report generated on <?= date('d M Y h:i A') ?>
                                                                <?php if ($shop_id !== 'all'): ?>
                                                                    | Shop specific report
                                                                <?php endif; ?>
                                                            </small>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    <?php endif; ?>

<?php elseif ($report_type === 'hsn'): ?>

<div class="table-responsive">
                                        <table class="table table-hover" id="hsnTable">
                                            <thead class="table-light">
                                            <tr>
                                                <th>HSN Code</th>
                                                <th>Product Name</th>
                                                <th class="text-center">Invoices</th>
                                                <th class="text-center">Quantity</th>
                                                <th class="text-center">Avg CGST %</th>
                                                <th class="text-center">Avg SGST %</th>
                                                <th class="text-center">Avg IGST %</th>
                                                <th class="text-end">Taxable Value</th>
                                                <th class="text-end">CGST</th>
                                                <th class="text-end">SGST</th>
                                                <th class="text-end">IGST</th>
                                                <th class="text-end">Total GST</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <?php if (empty($hsn_summary)): ?>
                                                <tr>
                                                    <td colspan="12" class="text-center py-4">
                                                        <i class="bx bx-hash fs-1 text-muted mb-2 d-block"></i>
                                                        <h5>No HSN data found</h5>
                                                        <p class="text-muted">No HSN codes recorded for the selected period.</p>
                                                    </td>
                                                </tr>
                                            <?php else: ?>
                                                <?php foreach ($hsn_summary as $hsn): ?>
                                                    <tr class="hsn-row">
                                                        <td>
                                                            <strong class="text-primary"><?= htmlspecialchars($hsn['hsn_code']) ?></strong>
                                                            <?php
                                                            $gst_rate = null;
                                                            foreach ($gst_rates_list as $rate) {
                                                                if ((string)$rate['hsn_code'] === (string)$hsn['hsn_code']) {
                                                                    $gst_rate = $rate;
                                                                    break;
                                                                }
                                                            }
                                                            ?>
                                                            <?php if ($gst_rate): ?>
                                                                <br>
                                                                <small class="text-muted">
                                                                    <?= htmlspecialchars($gst_rate['description']) ?>
                                                                    <span class="badge bg-<?= $gst_rate['status'] === 'active' ? 'success' : 'secondary' ?> ms-1">
                                                                        <?= htmlspecialchars($gst_rate['status']) ?>
                                                                    </span>
                                                                </small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?= htmlspecialchars($hsn['product_name']) ?></td>
                                                        <td class="text-center">
                                                            <span class="badge bg-info rounded-pill px-3">
                                                                <?= (int)$hsn['invoice_count'] ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-center">
                                                            <span class="badge bg-secondary bg-opacity-10 text-secondary px-3">
                                                                <?= number_format((float)$hsn['total_quantity']) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-center">
                                                            <?= (float)$hsn['avg_cgst_rate'] ? number_format((float)$hsn['avg_cgst_rate'], 2) . '%' : '-' ?>
                                                        </td>
                                                        <td class="text-center">
                                                            <?= (float)$hsn['avg_sgst_rate'] ? number_format((float)$hsn['avg_sgst_rate'], 2) . '%' : '-' ?>
                                                        </td>
                                                        <td class="text-center">
                                                            <?= (float)$hsn['avg_igst_rate'] ? number_format((float)$hsn['avg_igst_rate'], 2) . '%' : '-' ?>
                                                        </td>
                                                        <td class="text-end">₹<?= number_format((float)$hsn['total_taxable_value'], 2) ?></td>
                                                        <td class="text-end">
                                                            <span class="badge bg-primary bg-opacity-10 text-primary px-3 py-1">
                                                                ₹<?= number_format((float)$hsn['total_cgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-success bg-opacity-10 text-success px-3 py-1">
                                                                ₹<?= number_format((float)$hsn['total_sgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-warning bg-opacity-10 text-warning px-3 py-1">
                                                                ₹<?= number_format((float)$hsn['total_igst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <strong>₹<?= number_format((float)$hsn['total_cgst'] + (float)$hsn['total_sgst'] + (float)$hsn['total_igst'], 2) ?></strong>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>

<tr class="table-total-row">
                                                    <td colspan="7" class="text-end"><strong>OVERALL TOTALS:</strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_taxable, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_cgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_sgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_igst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($total_cgst + $total_sgst + $total_igst, 2) ?></strong></td>
                                                </tr>
                                            <?php endif; ?>
                                            </tbody>
                                        </table>
                                    </div>

<?php elseif ($report_type === 'monthly'): ?>

<div class="row mb-4">
                                        <div class="col-12">
                                            <div class="card shadow-sm">
                                                <div class="card-body">
                                                    <h6 class="mb-3">Monthly GST Collection Trend</h6>
                                                    <div class="chart-container">
                                                        <canvas id="monthlyTrendChart"></canvas>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>

<div class="table-responsive">
                                        <table class="table table-hover" id="monthlyTable">
                                            <thead class="table-light">
                                            <tr>
                                                <th>Month</th>
                                                <th class="text-center">Invoices</th>
                                                <th class="text-end">Taxable Value</th>
                                                <th class="text-end">CGST</th>
                                                <th class="text-end">SGST</th>
                                                <th class="text-end">IGST</th>
                                                <th class="text-end">Total GST</th>
                                                <th class="text-end">GST %</th>
                                            </tr>
                                            </thead>
                                            <tbody>
                                            <?php if (empty($monthly_trend)): ?>
                                                <tr>
                                                    <td colspan="8" class="text-center py-4">
                                                        <i class="bx bx-calendar fs-1 text-muted mb-2 d-block"></i>
                                                        <h5>No monthly data found</h5>
                                                        <p class="text-muted">No GST data for the selected year.</p>
                                                    </td>
                                                </tr>
                                            <?php else: ?>
                                                <?php
                                                $yearly_total_taxable = 0;
                                                $yearly_total_cgst = 0;
                                                $yearly_total_sgst = 0;
                                                $yearly_total_igst = 0;
                                                $yearly_total_gst = 0;
                                                ?>
                                                <?php foreach ($monthly_trend as $month): ?>
                                                    <?php
                                                    $yearly_total_taxable += (float)$month['total_taxable_value'];
                                                    $yearly_total_cgst += (float)$month['total_cgst'];
                                                    $yearly_total_sgst += (float)$month['total_sgst'];
                                                    $yearly_total_igst += (float)$month['total_igst'];
                                                    $yearly_total_gst += (float)$month['total_gst'];
                                                    $gst_percentage = (float)$month['total_taxable_value'] > 0
                                                        ? (((float)$month['total_gst']) / ((float)$month['total_taxable_value'])) * 100
                                                        : 0;
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <strong><?= htmlspecialchars($month['month_name']) ?></strong>
                                                        </td>
                                                        <td class="text-center">
                                                            <span class="badge bg-info rounded-pill px-3">
                                                                <?= (int)$month['invoice_count'] ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">₹<?= number_format((float)$month['total_taxable_value'], 2) ?></td>
                                                        <td class="text-end">
                                                            <span class="badge bg-primary bg-opacity-10 text-primary px-3 py-1">
                                                                ₹<?= number_format((float)$month['total_cgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-success bg-opacity-10 text-success px-3 py-1">
                                                                ₹<?= number_format((float)$month['total_sgst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-warning bg-opacity-10 text-warning px-3 py-1">
                                                                ₹<?= number_format((float)$month['total_igst'], 2) ?>
                                                            </span>
                                                        </td>
                                                        <td class="text-end">
                                                            <strong>₹<?= number_format((float)$month['total_gst'], 2) ?></strong>
                                                        </td>
                                                        <td class="text-end">
                                                            <span class="badge bg-<?= $gst_percentage > 10 ? 'success' : 'secondary' ?> bg-opacity-10 text-<?= $gst_percentage > 10 ? 'success' : 'secondary' ?> px-3 py-1">
                                                                <?= number_format($gst_percentage, 2) ?>%
                                                            </span>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>

<?php $yearly_gst_percentage = $yearly_total_taxable > 0 ? ($yearly_total_gst / $yearly_total_taxable) * 100 : 0; ?>
                                                <tr class="table-total-row">
                                                    <td><strong>OVERALL TOTALS</strong></td>
                                                    <td class="text-center"><strong><?= array_sum(array_column($monthly_trend, 'invoice_count')) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($yearly_total_taxable, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($yearly_total_cgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($yearly_total_sgst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($yearly_total_igst, 2) ?></strong></td>
                                                    <td class="text-end"><strong>₹<?= number_format($yearly_total_gst, 2) ?></strong></td>
                                                    <td class="text-end"><strong><?= number_format($yearly_gst_percentage, 2) ?>%</strong></td>
                                                </tr>
                                            <?php endif; ?>
                                            </tbody>
                                        </table>
                                    </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') ?>
<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

new Chart(monthlyCtx, {
        type: 'bar',
        data: monthlyData,
        options: {
            responsive: true,
            maintainAspectRatio: false,
            scales: {
                y: {
                    beginAtZero: true,
                    title: {
                        display: true,
                        text: 'Amount (₹)'
                    },
                    ticks: {
                        callback: function(value) {
                            return '₹' + value.toLocaleString();
                        }
                    }
                }
            },
            plugins: {
                legend: {
                    position: 'top',
                },
                tooltip: {
                    callbacks: {
                        label: function(context) {
                            let label = context.dataset.label || '';
                            if (label) {
                                label += ': ';
                            }
                            label += '₹' + context.parsed.y.toLocaleString();
                            return label;
                        }
                    }
                }
            }
        }
    });
    <?php endif; ?>

$('.export-link').click(function(e) {
        e.preventDefault();
        const exportType = $(this).data('type');

let url = 'gst_report.php?';
        const params = new URLSearchParams();

params.append('start_date', $('[name="start_date"]').val());
        params.append('end_date', $('[name="end_date"]').val());
        params.append('shop_id', $('[name="shop_id"]').val());
        params.append('report_type', $('[name="report_type"]').val());
        params.append('export', exportType);

<?php if ($report_type === 'monthly'): ?>
        params.append('year', '<?= htmlspecialchars($year) ?>');
        <?php endif; ?>

url += params.toString();
        window.location.href = url;
    });

$('[onclick="window.print()"]').click(function() {
        $('body').addClass('print-mode');
        setTimeout(function() {
            $('body').removeClass('print-mode');
        }, 1000);
    });
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation