Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/ecommer.in/public_html/billing/vkmobiles/admin

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: gst-overview.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');
$period = isset($_GET['period']) ? $_GET['period'] : 'monthly';

// Generate GST Overview Data
function generateGSTOverviewData($start_date, $end_date, $conn, $branch_id) {
    $data = [];
    
    // Overall GST Summary for the branch
    $overview_sql = "SELECT 
                    -- Sales Summary for the branch
                    (SELECT SUM(total_amount) FROM sales WHERE status = 'completed' AND branch_id = $branch_id AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date') as total_sales,
                    (SELECT SUM(subtotal_amount) FROM sales WHERE status = 'completed' AND branch_id = $branch_id AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date') as total_sales_excl_gst,
                    (SELECT SUM(total_gst_amount) FROM sales WHERE status = 'completed' AND branch_id = $branch_id AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date') as total_gst_collected,
                    (SELECT COUNT(*) FROM sales WHERE status = 'completed' AND branch_id = $branch_id AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date') as total_invoices,
                    
                    -- Purchase Summary (purchases might be shared across branches)
                    -- Note: Purchase orders may not have branch_id in your schema
                    -- This query assumes purchases are shared across branches
                    (SELECT SUM(poi.total_price) 
                     FROM purchase_orders po 
                     LEFT JOIN purchase_order_items poi ON po.id = poi.purchase_order_id
                     WHERE po.status = 'completed' AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date') as total_purchases_excl_gst,
                    
                    (SELECT SUM(poi.total_price * COALESCE(pgs.gst_percentage, 0) / 100)
                     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 DATE(po.order_date) BETWEEN '$start_date' AND '$end_date') as total_gst_paid,
                    
                    (SELECT COUNT(DISTINCT po.id) 
                     FROM purchase_orders po 
                     WHERE po.status = 'completed' AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date') as total_purchase_orders,
                    
                    -- GST Rates Summary for products in this branch
                    (SELECT COUNT(DISTINCT p.id) 
                     FROM products p 
                     LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                     WHERE pgs.gst_applicable = 1 AND p.branch_id = $branch_id) as gst_applicable_products,
                    
                    (SELECT COUNT(*) FROM suppliers WHERE gst_number IS NOT NULL AND gst_number != '') as gst_registered_suppliers";
    
    $overview_result = $conn->query($overview_sql);
    $overview_data = $overview_result->fetch_assoc();
    
    // Calculate derived metrics
    $total_purchases_incl_gst = ($overview_data['total_purchases_excl_gst'] ?? 0) + ($overview_data['total_gst_paid'] ?? 0);
    $net_gst_payable = ($overview_data['total_gst_collected'] ?? 0) - ($overview_data['total_gst_paid'] ?? 0);
    $gst_efficiency = ($overview_data['total_sales_excl_gst'] ?? 0) > 0 ? 
        (($overview_data['total_gst_collected'] ?? 0) / $overview_data['total_sales_excl_gst']) * 100 : 0;
    
    // Monthly Performance Trend for the branch
    $monthly_trend_sql = "SELECT 
                            DATE_FORMAT(sale_date, '%Y-%m') as month,
                            SUM(total_amount) as sales_amount,
                            SUM(total_gst_amount) as gst_collected,
                            COUNT(*) as invoice_count
                          FROM sales 
                          WHERE status = 'completed' 
                          AND branch_id = $branch_id
                          AND sale_date >= DATE_SUB('$end_date', INTERVAL 5 MONTH)
                          GROUP BY DATE_FORMAT(sale_date, '%Y-%m')
                          ORDER BY month ASC";
    
    $monthly_trend_result = $conn->query($monthly_trend_sql);
    $monthly_trends = [];
    while($row = $monthly_trend_result->fetch_assoc()) {
        $monthly_trends[] = $row;
    }
    
    // GST Rate Distribution for the branch
    $gst_rate_sql = "SELECT 
                      'Sales' as type,
                      CASE 
                        WHEN gst_breakdown IS NOT NULL AND gst_breakdown != 'null' THEN 'Multiple Rates'
                        ELSE 'Standard Rate'
                      END as rate_type,
                      SUM(total_gst_amount) as gst_amount,
                      COUNT(*) as transaction_count
                    FROM sales 
                    WHERE status = 'completed' 
                    AND branch_id = $branch_id
                    AND DATE(sale_date) BETWEEN '$start_date' AND '$end_date'
                    GROUP BY rate_type
                    
                    UNION ALL
                    
                    SELECT 
                      'Purchase' as type,
                      CONCAT(pgs.gst_percentage, '%') as rate_type,
                      SUM(poi.total_price * pgs.gst_percentage / 100) as gst_amount,
                      COUNT(DISTINCT po.id) as transaction_count
                    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 DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'
                    AND pgs.gst_applicable = 1";
    
    $gst_rate_result = $conn->query($gst_rate_sql);
    $gst_rate_distribution = [];
    while($row = $gst_rate_result->fetch_assoc()) {
        $gst_rate_distribution[] = $row;
    }
    
    // Top GST Paying Customers in this branch
    $top_customers_sql = "SELECT 
                            c.customer_name,
                            c.customer_phone,
                            COUNT(s.id) as invoice_count,
                            SUM(s.total_amount) as total_purchase,
                            SUM(s.total_gst_amount) as total_gst_paid
                          FROM sales s
                          LEFT JOIN customers c ON s.customer_id = c.id
                          WHERE s.status = 'completed'
                          AND s.branch_id = $branch_id
                          AND DATE(s.sale_date) BETWEEN '$start_date' AND '$end_date'
                          GROUP BY c.id, c.customer_name, c.customer_phone
                          ORDER BY total_gst_paid DESC
                          LIMIT 8";
    
    $top_customers_result = $conn->query($top_customers_sql);
    $top_customers = [];
    while($row = $top_customers_result->fetch_assoc()) {
        $top_customers[] = $row;
    }
    
    // GST Compliance Status for the branch
    $compliance_sql = "SELECT 
                         'GST Registered Suppliers' as category,
                         COUNT(*) as count,
                         (SELECT COUNT(*) FROM suppliers) as total
                       FROM suppliers 
                       WHERE gst_number IS NOT NULL AND gst_number != ''
                       
                       UNION ALL
                       
                       SELECT 
                         'GST Applicable Products' as category,
                         COUNT(*) as count,
                         (SELECT COUNT(*) FROM products WHERE branch_id = $branch_id) as total
                       FROM products p
                       LEFT JOIN product_gst_settings pgs ON p.id = pgs.product_id
                       WHERE pgs.gst_applicable = 1 AND p.branch_id = $branch_id";
    
    $compliance_result = $conn->query($compliance_sql);
    $compliance_status = [];
    while($row = $compliance_result->fetch_assoc()) {
        $compliance_status[] = $row;
    }
    
    // Recent High GST Transactions in this branch
    $recent_high_gst_sql = "SELECT 
                              'Sale' as type,
                              s.sale_number as reference,
                              c.customer_name,
                              s.total_amount,
                              s.total_gst_amount,
                              s.sale_date,
                              ROUND((s.total_gst_amount / s.total_amount) * 100, 2) as gst_percentage
                            FROM sales s
                            LEFT JOIN customers c ON s.customer_id = c.id
                            WHERE s.status = 'completed'
                            AND s.branch_id = $branch_id
                            AND DATE(s.sale_date) BETWEEN '$start_date' AND '$end_date'
                            AND s.total_gst_amount > 0
                            
                            UNION ALL
                            
                            SELECT 
                              'Purchase' as type,
                              po.po_number as reference,
                              s.name as customer_name,
                              (poi.total_price + (poi.total_price * COALESCE(pgs.gst_percentage, 0) / 100)) as total_amount,
                              (poi.total_price * COALESCE(pgs.gst_percentage, 0) / 100) as gst_amount,
                              po.order_date as sale_date,
                              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 po.status = 'completed'
                            AND DATE(po.order_date) BETWEEN '$start_date' AND '$end_date'
                            AND pgs.gst_applicable = 1
                            
                            ORDER BY total_gst_amount DESC
                            LIMIT 10";
    
    $recent_high_gst_result = $conn->query($recent_high_gst_sql);
    $recent_high_gst = [];
    while($row = $recent_high_gst_result->fetch_assoc()) {
        $recent_high_gst[] = $row;
    }
    
    $data = [
        'overview' => $overview_data,
        'derived_metrics' => [
            'total_purchases_incl_gst' => $total_purchases_incl_gst,
            'net_gst_payable' => $net_gst_payable,
            'gst_efficiency' => $gst_efficiency
        ],
        'monthly_trends' => $monthly_trends,
        'gst_rate_distribution' => $gst_rate_distribution,
        'top_customers' => $top_customers,
        'compliance_status' => $compliance_status,
        'recent_high_gst' => $recent_high_gst
    ];
    
    return $data;
}

$gst_data = generateGSTOverviewData($start_date, $end_date, $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 overview for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="sales-new.php" class="btn btn-primary">
                                <i class="fas fa-shopping-cart me-2"></i>New Sale
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Branch GST Overview Dashboard</h4>
                            <div class="page-title-right">
                                <span class="badge bg-success">
                                    <i class="fas fa-calendar-alt me-1"></i>
                                    <?php echo date('d M Y', strtotime($start_date)); ?> - <?php echo date('d M Y', strtotime($end_date)); ?>
                                </span>
                                <span class="badge bg-info ms-2">
                                    <i class="fas fa-store me-1"></i>
                                    <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                </span>
                            </div>
                        </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 echo number_format($gst_data['overview']['total_gst_collected'] ?? 0, 2); ?></h4>
                                        <p class="mb-0">GST Collected</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-download display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small>
                                        <i class="fas fa-file-invoice me-1"></i>
                                        <?php echo number_format($gst_data['overview']['total_invoices'] ?? 0); ?> branch invoices
                                    </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 echo number_format($gst_data['overview']['total_gst_paid'] ?? 0, 2); ?></h4>
                                        <p class="mb-0">GST Paid (ITC)</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-upload display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small>
                                        <i class="fas fa-truck me-1"></i>
                                        <?php echo number_format($gst_data['overview']['total_purchase_orders'] ?? 0); ?> orders
                                        <br><small class="opacity-75">(Shared across branches)</small>
                                    </small>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card <?php echo ($gst_data['derived_metrics']['net_gst_payable'] >= 0) ? 'bg-warning' : 'bg-info'; ?> text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">₹<?php echo number_format(abs($gst_data['derived_metrics']['net_gst_payable']), 2); ?></h4>
                                        <p class="mb-0">
                                            <?php echo ($gst_data['derived_metrics']['net_gst_payable'] >= 0) ? 'Net GST Payable' : 'Net GST Refund'; ?>
                                        </p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-balance-scale display-4 opacity-50"></i>
                                    </div>
                                </div>
                                <div class="mt-2">
                                    <small>
                                        <i class="fas fa-<?php echo ($gst_data['derived_metrics']['net_gst_payable'] >= 0) ? 'hand-holding-usd' : 'money-bill-wave'; ?> me-1"></i>
                                        <?php echo ($gst_data['derived_metrics']['net_gst_payable'] >= 0) ? 'To be paid' : 'Refund due'; ?>
                                        <br><small class="opacity-75">Based on branch sales</small>
                                    </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 echo number_format($gst_data['derived_metrics']['gst_efficiency'], 2); ?>%</h4>
                                        <p class="mb-0">GST Efficiency</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-percentage me-1"></i>
                                        GST to Sales Ratio
                                        <br><small class="opacity-75">Branch performance</small>
                                    </small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-md-3">
                                        <label for="startDate" class="form-label">Start Date</label>
                                        <input type="date" class="form-control" id="startDate" value="<?php echo $start_date; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="endDate" class="form-label">End Date</label>
                                        <input type="date" class="form-control" id="endDate" value="<?php echo $end_date; ?>">
                                    </div>
                                    <div class="col-md-3">
                                        <label for="period" class="form-label">Period</label>
                                        <select class="form-select" id="period">
                                            <option value="daily" <?php echo $period === 'daily' ? 'selected' : ''; ?>>Daily</option>
                                            <option value="weekly" <?php echo $period === 'weekly' ? 'selected' : ''; ?>>Weekly</option>
                                            <option value="monthly" <?php echo $period === 'monthly' ? 'selected' : ''; ?>>Monthly</option>
                                            <option value="quarterly" <?php echo $period === 'quarterly' ? 'selected' : ''; ?>>Quarterly</option>
                                            <option value="yearly" <?php echo $period === 'yearly' ? 'selected' : ''; ?>>Yearly</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3 d-flex align-items-end">
                                        <button type="button" class="btn btn-primary w-100" id="applyFilters">
                                            <i class="fas fa-filter me-2"></i>Apply Filters
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    
                    <div class="col-xl-8">
                        
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Branch GST Performance Trend (Last 6 Months)</h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Month</th>
                                                <th>Sales (₹)</th>
                                                <th>GST Collected (₹)</th>
                                                <th>Invoices</th>
                                                <th>GST %</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (!empty($gst_data['monthly_trends'])): ?>
                                                <?php foreach ($gst_data['monthly_trends'] as $trend): ?>
                                                <tr>
                                                    <td><strong><?php echo date('M Y', strtotime($trend['month'] . '-01')); ?></strong></td>
                                                    <td>₹<?php echo number_format($trend['sales_amount'], 2); ?></td>
                                                    <td class="text-success">₹<?php echo number_format($trend['gst_collected'], 2); ?></td>
                                                    <td><?php echo number_format($trend['invoice_count']); ?></td>
                                                    <td class="text-info">
                                                        <?php 
                                                        $gst_percentage = $trend['sales_amount'] > 0 ? 
                                                            ($trend['gst_collected'] / ($trend['sales_amount'] - $trend['gst_collected'])) * 100 : 0;
                                                        echo number_format($gst_percentage, 2); 
                                                        ?>%
                                                    </td>
                                                </tr>
                                                <?php endforeach; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="5" class="text-center text-muted">No trend data available for your branch</td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Recent High GST Transactions in Branch</h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Type</th>
                                                <th>Reference</th>
                                                <th>Party</th>
                                                <th>Amount</th>
                                                <th>GST</th>
                                                <th>GST %</th>
                                                <th>Date</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (!empty($gst_data['recent_high_gst'])): ?>
                                                <?php foreach ($gst_data['recent_high_gst'] as $transaction): ?>
                                                <tr>
                                                    <td>
                                                        <span class="badge bg-<?php echo $transaction['type'] === 'Sale' ? 'primary' : 'success'; ?>">
                                                            <?php echo $transaction['type']; ?>
                                                            <?php if ($transaction['type'] === 'Sale'): ?>
                                                                <small class="ms-1"><i class="fas fa-store"></i></small>
                                                            <?php endif; ?>
                                                        </span>
                                                    </td>
                                                    <td><small><?php echo htmlspecialchars($transaction['reference']); ?></small></td>
                                                    <td><small><?php echo htmlspecialchars($transaction['customer_name']); ?></small></td>
                                                    <td>₹<?php echo number_format($transaction['total_amount'], 2); ?></td>
                                                    <td class="text-success">₹<?php echo number_format($transaction['total_gst_amount'], 2); ?></td>
                                                    <td>
                                                        <span class="badge bg-info"><?php echo $transaction['gst_percentage']; ?>%</span>
                                                    </td>
                                                    <td><small><?php echo date('d M', strtotime($transaction['sale_date'])); ?></small></td>
                                                </tr>
                                                <?php endforeach; ?>
                                            <?php else: ?>
                                                <tr>
                                                    <td colspan="7" class="text-center text-muted">No high GST transactions in your branch</td>
                                                </tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-4">
                        
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">GST Rate Distribution in Branch</h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($gst_data['gst_rate_distribution'])): ?>
                                    <?php foreach ($gst_data['gst_rate_distribution'] as $distribution): ?>
                                    <div class="border rounded p-3 mb-3">
                                        <div class="d-flex justify-content-between align-items-center">
                                            <div>
                                                <h6 class="mb-1 <?php echo $distribution['type'] === 'Sales' ? 'text-primary' : 'text-success'; ?>">
                                                    <?php echo $distribution['type']; ?> - <?php echo $distribution['rate_type']; ?>
                                                    <?php if ($distribution['type'] === 'Sales'): ?>
                                                        <small class="text-muted"><i class="fas fa-store ms-1"></i></small>
                                                    <?php endif; ?>
                                                </h6>
                                                <p class="mb-0 text-muted">₹<?php echo number_format($distribution['gst_amount'], 2); ?></p>
                                            </div>
                                            <span class="badge bg-<?php echo $distribution['type'] === 'Sales' ? 'primary' : 'success'; ?>">
                                                <?php echo number_format($distribution['transaction_count']); ?> trans
                                            </span>
                                        </div>
                                    </div>
                                    <?php endforeach; ?>
                                <?php else: ?>
                                    <p class="text-muted text-center">No GST rate distribution data in your branch</p>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Branch GST Compliance Status</h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($gst_data['compliance_status'])): ?>
                                    <?php foreach ($gst_data['compliance_status'] as $compliance): ?>
                                    <div class="mb-3">
                                        <div class="d-flex justify-content-between mb-1">
                                            <span class="text-muted"><?php echo $compliance['category']; ?></span>
                                            <span class="text-primary"><?php echo $compliance['count']; ?>/<?php echo $compliance['total']; ?></span>
                                        </div>
                                        <div class="progress" style="height: 8px;">
                                            <?php 
                                            $percentage = $compliance['total'] > 0 ? ($compliance['count'] / $compliance['total']) * 100 : 0;
                                            $color = $percentage >= 80 ? 'success' : ($percentage >= 50 ? 'warning' : 'danger');
                                            ?>
                                            <div class="progress-bar bg-<?php echo $color; ?>" style="width: <?php echo $percentage; ?>%"></div>
                                        </div>
                                        <small class="text-muted"><?php echo number_format($percentage, 1); ?>% compliant</small>
                                    </div>
                                    <?php endforeach; ?>
                                <?php else: ?>
                                    <p class="text-muted text-center">No compliance data available for your branch</p>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-4">
                            <div class="card-header">
                                <h5 class="card-title mb-0">Top GST Paying Customers in Branch</h5>
                            </div>
                            <div class="card-body">
                                <?php if (!empty($gst_data['top_customers'])): ?>
                                    <?php foreach ($gst_data['top_customers'] as $customer): ?>
                                    <div class="d-flex align-items-center mb-3">
                                        <div class="flex-shrink-0">
                                            <div class="avatar-xs bg-light rounded">
                                                <i class="fas fa-user font-size-13 text-primary"></i>
                                            </div>
                                        </div>
                                        <div class="flex-grow-1 ms-3">
                                            <h6 class="mb-0"><?php echo htmlspecialchars($customer['customer_name']); ?></h6>
                                            <small class="text-muted">₹<?php echo number_format($customer['total_gst_paid'], 2); ?> GST</small>
                                        </div>
                                        <div class="flex-shrink-0 text-end">
                                            <small class="text-muted"><?php echo $customer['invoice_count']; ?> inv</small>
                                            <br><small class="text-muted"><i class="fas fa-store"></i></small>
                                        </div>
                                    </div>
                                    <?php endforeach; ?>
                                <?php else: ?>
                                    <p class="text-muted text-center">No customer data available in your branch</p>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-4">
                    <div class="col-md-4">
                        <div class="card bg-light">
                            <div class="card-body text-center">
                                <h3 class="text-primary">₹<?php echo number_format($gst_data['overview']['total_sales'] ?? 0, 2); ?></h3>
                                <p class="text-muted mb-0">Total Branch Sales (Incl. GST)</p>
                                <small class="text-muted"><?php echo number_format($gst_data['overview']['total_invoices'] ?? 0); ?> branch invoices</small>
                            </div>
                        </div>
                    </div>

<div class="col-md-4">
                        <div class="card bg-light">
                            <div class="card-body text-center">
                                <h3 class="text-success">₹<?php echo number_format($gst_data['derived_metrics']['total_purchases_incl_gst'] ?? 0, 2); ?></h3>
                                <p class="text-muted mb-0">Total Purchases (Incl. GST)</p>
                                <small class="text-muted"><?php echo number_format($gst_data['overview']['total_purchase_orders'] ?? 0); ?> orders
                                <br><small class="opacity-75">(Shared across branches)</small></small>
                            </div>
                        </div>
                    </div>

<div class="col-md-4">
                        <div class="card bg-light">
                            <div class="card-body text-center">
                                <h3 class="text-info"><?php echo number_format($gst_data['overview']['gst_applicable_products'] ?? 0); ?></h3>
                                <p class="text-muted mb-0">GST Applicable Products in Branch</p>
                                <small class="text-muted"><?php echo number_format($gst_data['overview']['gst_registered_suppliers'] ?? 0); ?> GST suppliers</small>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header bg-light">
                                <h5 class="card-title mb-0">Branch Quick Navigation</h5>
                            </div>
                            <div class="card-body">
                                <div class="row text-center">
                                    <div class="col-md-2 mb-3">
                                        <a href="reports-gst.php" class="btn btn-outline-primary w-100">
                                            <i class="fas fa-shopping-cart fa-2x mb-2"></i><br>
                                            Branch GST Sales
                                        </a>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <a href="inventory-purchase.php" class="btn btn-outline-success w-100">
                                            <i class="fas fa-truck fa-2x mb-2"></i><br>
                                            Purchase Orders
                                        </a>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <a href="reports-profit.php" class="btn btn-outline-info w-100">
                                            <i class="fas fa-chart-line fa-2x mb-2"></i><br>
                                            Branch Profit
                                        </a>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <a href="reports-customer.php" class="btn btn-outline-warning w-100">
                                            <i class="fas fa-users fa-2x mb-2"></i><br>
                                            Branch Customers
                                        </a>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <a href="inventory-stock.php" class="btn btn-outline-secondary w-100">
                                            <i class="fas fa-boxes fa-2x mb-2"></i><br>
                                            Branch Stock
                                        </a>
                                    </div>
                                    <div class="col-md-2 mb-3">
                                        <a href="reports-inventory.php" class="btn btn-outline-dark w-100">
                                            <i class="fas fa-chart-pie fa-2x mb-2"></i><br>
                                            Branch Reports
                                        </a>
                                    </div>
                                </div>
                            </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 (period && period.value) params.set('period', period.value);
            
            window.location.href = 'gst-overview.php?' + params.toString();
        });
    }

// Auto-set date range based on period
    if (period) {
        period.addEventListener('change', function() {
            const today = new Date();
            let startDateValue, endDateValue;

switch(this.value) {
                case 'daily':
                    startDateValue = today.toISOString().split('T')[0];
                    endDateValue = today.toISOString().split('T')[0];
                    break;
                case 'weekly':
                    const startOfWeek = new Date(today);
                    startOfWeek.setDate(today.getDate() - today.getDay());
                    startDateValue = startOfWeek.toISOString().split('T')[0];
                    endDateValue = today.toISOString().split('T')[0];
                    break;
                case 'monthly':
                    startDateValue = new Date(today.getFullYear(), today.getMonth(), 1).toISOString().split('T')[0];
                    endDateValue = new Date(today.getFullYear(), today.getMonth() + 1, 0).toISOString().split('T')[0];
                    break;
                case 'quarterly':
                    const quarter = Math.floor(today.getMonth() / 3);
                    startDateValue = new Date(today.getFullYear(), quarter * 3, 1).toISOString().split('T')[0];
                    endDateValue = new Date(today.getFullYear(), (quarter + 1) * 3, 0).toISOString().split('T')[0];
                    break;
                case 'yearly':
                    startDateValue = new Date(today.getFullYear(), 0, 1).toISOString().split('T')[0];
                    endDateValue = new Date(today.getFullYear(), 11, 31).toISOString().split('T')[0];
                    break;
            }

if (startDate) startDate.value = startDateValue;
            if (endDate) endDate.value = endDateValue;
        });
    }

// Auto-refresh data every 10 minutes
    setInterval(function() {
        console.log('Auto-refresh branch GST overview data');
        // You can implement AJAX refresh here if needed
    }, 600000);
});
</script>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: gst-overview.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation