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

🔧 Quick Actions

✏️ Editing: sales-comparison.php

<?php
session_start();
include('includes/db.php');
include('includes/head.php');

// Check if user is logged in (either as staff or branch)
if (!isset($_SESSION['staff_id']) && !isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Get current branch ID and user type
$current_branch_id = $_SESSION['branch_id'] ?? 0;
$current_branch_name = $_SESSION['branch_name'] ?? 'Main Branch';
$is_staff = isset($_SESSION['staff_id']);

// Get selected branches for comparison
$selected_branches = [];
if (isset($_GET['branches']) && is_array($_GET['branches'])) {
    $selected_branches = array_map('intval', $_GET['branches']);
} elseif ($current_branch_id) {
    // Default: show current branch
    $selected_branches[] = $current_branch_id;
}

// Get date range with defaults
$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-d');

// Validate date range
if ($start_date > $end_date) {
    $temp = $start_date;
    $start_date = $end_date;
    $end_date = $temp;
}

// Get comparison type
$comparison_type = isset($_GET['type']) ? $_GET['type'] : 'daily';

// Fetch all active branches for filter
$branches_sql = "SELECT id, branch_name, branch_code FROM branches WHERE status = 'active' ORDER BY branch_name ASC";
$branches_result = $conn->query($branches_sql);

// Initialize arrays for data
$sales_data = [];
$product_sales = [];
$customer_stats = [];

// If no branches selected, show all active branches
if (empty($selected_branches)) {
    $branches_result->data_seek(0);
    while ($branch = $branches_result->fetch_assoc()) {
        $selected_branches[] = $branch['id'];
    }
}

// Process selected branches
foreach ($selected_branches as $branch_id) {
    if ($branch_id <= 0) continue;
    
    // Get branch info
    $branch_info_sql = "SELECT branch_name, branch_code FROM branches WHERE id = ?";
    $stmt = $conn->prepare($branch_info_sql);
    $stmt->bind_param("i", $branch_id);
    $stmt->execute();
    $branch_result = $stmt->get_result();
    $branch_info = $branch_result->fetch_assoc();
    
    if (!$branch_info) continue;
    
    $branch_key = $branch_info['branch_name'] . " (" . $branch_info['branch_code'] . ")";
    
    // Get sales summary for the branch
    $sales_summary_sql = "
        SELECT 
            COUNT(*) as total_sales,
            SUM(total_amount) as total_revenue,
            SUM(paid_amount) as total_collected,
            SUM(due_amount) as total_pending,
            AVG(total_amount) as avg_sale_value,
            COUNT(DISTINCT customer_id) as unique_customers,
            SUM(total_gst_amount) as total_gst_collected,
            SUM(total_gst_amount) * 100 / SUM(total_amount) as gst_percentage,
            MAX(total_amount) as max_sale,
            MIN(total_amount) as min_sale
        FROM sales 
        WHERE branch_id = ? 
        AND status = 'completed'
        AND sale_date BETWEEN ? AND ?
    ";
    
    $stmt = $conn->prepare($sales_summary_sql);
    $stmt->bind_param("iss", $branch_id, $start_date, $end_date);
    $stmt->execute();
    $summary_result = $stmt->get_result();
    $summary = $summary_result->fetch_assoc();
    
    // Get sales by payment type
    $payment_type_sql = "
        SELECT 
            payment_type,
            COUNT(*) as count,
            SUM(total_amount) as amount,
            SUM(paid_amount) as collected
        FROM sales 
        WHERE branch_id = ? 
        AND status = 'completed'
        AND sale_date BETWEEN ? AND ?
        GROUP BY payment_type
        ORDER BY amount DESC
    ";
    
    $stmt = $conn->prepare($payment_type_sql);
    $stmt->bind_param("iss", $branch_id, $start_date, $end_date);
    $stmt->execute();
    $payment_result = $stmt->get_result();
    $payment_types = [];
    while ($row = $payment_result->fetch_assoc()) {
        $payment_types[$row['payment_type']] = [
            'count' => $row['count'],
            'amount' => $row['amount'],
            'collected' => $row['collected']
        ];
    }
    
    // Get top selling products
    $top_products_sql = "
        SELECT 
            p.product_name,
            COUNT(si.id) as sale_count,
            SUM(si.quantity) as total_quantity,
            SUM(si.total_price_with_gst) as total_revenue,
            SUM(si.total_price) as subtotal_revenue,
            SUM(si.gst_amount) as total_gst
        FROM sale_items si
        JOIN sales s ON si.sale_id = s.id
        JOIN products p ON si.product_id = p.id
        WHERE s.branch_id = ? 
        AND s.status = 'completed'
        AND s.sale_date BETWEEN ? AND ?
        GROUP BY p.product_name
        ORDER BY total_revenue DESC
        LIMIT 10
    ";
    
    $stmt = $conn->prepare($top_products_sql);
    $stmt->bind_param("iss", $branch_id, $start_date, $end_date);
    $stmt->execute();
    $products_result = $stmt->get_result();
    $top_products = [];
    while ($row = $products_result->fetch_assoc()) {
        $top_products[] = $row;
    }
    
    // Get daily/weekly/monthly sales trend based on comparison type
    $trend_sql = "";
    switch ($comparison_type) {
        case 'daily':
            $trend_sql = "
                SELECT 
                    DATE(sale_date) as period,
                    COUNT(*) as sales_count,
                    SUM(total_amount) as sales_amount,
                    SUM(paid_amount) as collected_amount,
                    SUM(total_gst_amount) as gst_amount
                FROM sales 
                WHERE branch_id = ? 
                AND status = 'completed'
                AND sale_date BETWEEN ? AND ?
                GROUP BY DATE(sale_date)
                ORDER BY DATE(sale_date)
            ";
            break;
        case 'weekly':
            $trend_sql = "
                SELECT 
                    YEARWEEK(sale_date, 1) as period,
                    COUNT(*) as sales_count,
                    SUM(total_amount) as sales_amount,
                    SUM(paid_amount) as collected_amount,
                    SUM(total_gst_amount) as gst_amount
                FROM sales 
                WHERE branch_id = ? 
                AND status = 'completed'
                AND sale_date BETWEEN ? AND ?
                GROUP BY YEARWEEK(sale_date, 1)
                ORDER BY YEARWEEK(sale_date, 1)
            ";
            break;
        case 'monthly':
            $trend_sql = "
                SELECT 
                    DATE_FORMAT(sale_date, '%Y-%m') as period,
                    COUNT(*) as sales_count,
                    SUM(total_amount) as sales_amount,
                    SUM(paid_amount) as collected_amount,
                    SUM(total_gst_amount) as gst_amount
                FROM sales 
                WHERE branch_id = ? 
                AND status = 'completed'
                AND sale_date BETWEEN ? AND ?
                GROUP BY DATE_FORMAT(sale_date, '%Y-%m')
                ORDER BY DATE_FORMAT(sale_date, '%Y-%m')
            ";
            break;
    }
    
    $stmt = $conn->prepare($trend_sql);
    $stmt->bind_param("iss", $branch_id, $start_date, $end_date);
    $stmt->execute();
    $trend_result = $stmt->get_result();
    $trend_data = [];
    while ($row = $trend_result->fetch_assoc()) {
        $trend_data[$row['period']] = [
            'sales_count' => $row['sales_count'],
            'sales_amount' => $row['sales_amount'],
            'collected_amount' => $row['collected_amount'],
            'gst_amount' => $row['gst_amount']
        ];
    }
    
    // Get customer statistics
    $customer_stats_sql = "
        SELECT 
            COUNT(DISTINCT customer_id) as total_customers,
            COUNT(DISTINCT CASE WHEN due_amount > 0 THEN customer_id END) as credit_customers,
            SUM(CASE WHEN due_amount > 0 THEN due_amount ELSE 0 END) as total_credit,
            AVG(total_amount) as avg_customer_spend
        FROM sales 
        WHERE branch_id = ? 
        AND status = 'completed'
        AND sale_date BETWEEN ? AND ?
    ";
    
    $stmt = $conn->prepare($customer_stats_sql);
    $stmt->bind_param("iss", $branch_id, $start_date, $end_date);
    $stmt->execute();
    $customer_result = $stmt->get_result();
    $customer_stats_data = $customer_result->fetch_assoc();
    
    // Store branch data
    $sales_data[$branch_key] = [
        'summary' => $summary,
        'payment_types' => $payment_types,
        'top_products' => $top_products,
        'trend_data' => $trend_data,
        'customer_stats' => $customer_stats_data,
        'branch_info' => $branch_info,
        'branch_id' => $branch_id
    ];
}

// Calculate totals for comparison
$total_summary = [
    'total_sales' => 0,
    'total_revenue' => 0,
    'total_collected' => 0,
    'total_pending' => 0,
    'total_gst_collected' => 0,
    'unique_customers' => 0
];

foreach ($sales_data as $data) {
    $summary = $data['summary'];
    $total_summary['total_sales'] += $summary['total_sales'] ?? 0;
    $total_summary['total_revenue'] += $summary['total_revenue'] ?? 0;
    $total_summary['total_collected'] += $summary['total_collected'] ?? 0;
    $total_summary['total_pending'] += $summary['total_pending'] ?? 0;
    $total_summary['total_gst_collected'] += $summary['total_gst_collected'] ?? 0;
    $total_summary['unique_customers'] += $summary['unique_customers'] ?? 0;
}

// Calculate averages
$total_summary['avg_sale_value'] = $total_summary['total_sales'] > 0 ? 
    $total_summary['total_revenue'] / $total_summary['total_sales'] : 0;
?>
<!doctype html>
<html lang="en">

<head>
    <?php include('includes/head.php'); ?>
    <title>Sales Comparison | VK Mobiles</title>
    <style>
        .branch-card {
            border-left: 4px solid #556ee6;
            transition: all 0.3s ease;
        }
        .branch-card:hover {
            transform: translateY(-2px);
            box-shadow: 0 5px 15px rgba(0,0,0,0.1);
        }
        .stat-card {
            border-radius: 10px;
            margin-bottom: 15px;
        }
        .stat-icon {
            font-size: 2.5rem;
            opacity: 0.8;
        }
        .chart-container {
            position: relative;
            height: 400px;
        }
        .comparison-badge {
            font-size: 0.8rem;
            margin-left: 5px;
        }
        .trend-up {
            color: #34c38f;
        }
        .trend-down {
            color: #f46a6a;
        }
        .payment-badge {
            font-size: 0.75rem;
            margin-right: 5px;
        }
        .top-product-item {
            border-bottom: 1px solid #f1f1f1;
            padding: 10px 0;
        }
        .top-product-item:last-child {
            border-bottom: none;
        }
        .product-rank {
            width: 30px;
            height: 30px;
            border-radius: 50%;
            display: flex;
            align-items: center;
            justify-content: center;
            font-weight: bold;
            margin-right: 10px;
        }
        .rank-1 { background: #ffd700; color: #000; }
        .rank-2 { background: #c0c0c0; color: #000; }
        .rank-3 { background: #cd7f32; color: #fff; }
        .rank-other { background: #f8f9fa; color: #495057; }
        .branch-highlight {
            background-color: rgba(85, 110, 230, 0.1);
            border-color: #556ee6 !important;
        }
        .filter-card {
            background: #f8f9fa;
            border: 1px solid #e9ecef;
        }
        .date-range {
            font-size: 0.9rem;
            color: #6c757d;
        }
    </style>
</head>

<?php include('includes/pre-loader.php')?>

<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="main-content">
        <div class="page-content">          
            <div class="container-fluid">

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Sales Comparison Report</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="reports.php">Reports</a></li>
                                    <li class="breadcrumb-item active">Sales Comparison</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="card filter-card mb-4">
                    <div class="card-header bg-light">
                        <h5 class="card-title mb-0">
                            <i class="fas fa-filter me-2"></i>Comparison Filters
                        </h5>
                    </div>
                    <div class="card-body">
                        <form method="GET" action="" class="row g-3">
                            <div class="col-xl-4 col-lg-4 col-md-6">
                                <label class="form-label">Select Branches</label>
                                <select name="branches[]" class="form-select select2" multiple required>
                                    <?php 
                                    $branches_result->data_seek(0);
                                    while($branch = $branches_result->fetch_assoc()): 
                                    ?>
                                        <option value="<?php echo $branch['id']; ?>" 
                                            <?php echo in_array($branch['id'], $selected_branches) ? 'selected' : ''; ?>>
                                            <?php echo htmlspecialchars($branch['branch_name'] . ' (' . $branch['branch_code'] . ')'); ?>
                                        </option>
                                    <?php endwhile; ?>
                                </select>
                            </div>
                            
                            <div class="col-xl-2 col-lg-2 col-md-3">
                                <label class="form-label">Comparison Type</label>
                                <select name="type" class="form-select">
                                    <option value="daily" <?php echo $comparison_type == 'daily' ? 'selected' : ''; ?>>Daily</option>
                                    <option value="weekly" <?php echo $comparison_type == 'weekly' ? 'selected' : ''; ?>>Weekly</option>
                                    <option value="monthly" <?php echo $comparison_type == 'monthly' ? 'selected' : ''; ?>>Monthly</option>
                                </select>
                            </div>
                            
                            <div class="col-xl-2 col-lg-3 col-md-3">
                                <label class="form-label">Start Date</label>
                                <input type="date" name="start_date" class="form-control" 
                                       value="<?php echo htmlspecialchars($start_date); ?>" required>
                            </div>
                            
                            <div class="col-xl-2 col-lg-3 col-md-3">
                                <label class="form-label">End Date</label>
                                <input type="date" name="end_date" class="form-control" 
                                       value="<?php echo htmlspecialchars($end_date); ?>" required>
                            </div>
                            
                            <div class="col-xl-2 col-lg-3 col-md-3 align-self-end">
                                <div class="d-grid gap-2">
                                    <button type="submit" class="btn btn-primary">
                                        <i class="fas fa-chart-line me-2"></i>Compare
                                    </button>
                                    <button type="button" class="btn btn-outline-secondary" onclick="window.location.href='sales-comparison.php'">
                                        <i class="fas fa-redo me-2"></i>Reset
                                    </button>
                                </div>
                            </div>
                        </form>
                        
                        <?php if (!empty($selected_branches)): ?>
                        <div class="mt-3">
                            <span class="badge bg-info">
                                <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-primary ms-2">
                                <i class="fas fa-store me-1"></i>
                                <?php echo count($selected_branches); ?> Branch(es)
                            </span>
                            <span class="badge bg-success ms-2">
                                <i class="fas fa-chart-bar me-1"></i>
                                <?php echo ucfirst($comparison_type); ?> Comparison
                            </span>
                        </div>
                        <?php endif; ?>
                    </div>
                </div>

<?php if (!empty($sales_data)): ?>
                
                
                <div class="row mb-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-chart-pie me-2"></i>Overall Summary
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-primary text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1"><?php echo number_format($total_summary['total_sales']); ?></h1>
                                                <p class="mb-0">Total Sales</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-success text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1">₹<?php echo number_format($total_summary['total_revenue'], 2); ?></h1>
                                                <p class="mb-0">Total Revenue</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-info text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1">₹<?php echo number_format($total_summary['total_collected'], 2); ?></h1>
                                                <p class="mb-0">Amount Collected</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-warning text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1">₹<?php echo number_format($total_summary['total_pending'], 2); ?></h1>
                                                <p class="mb-0">Pending Amount</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-dark text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1">₹<?php echo number_format($total_summary['total_gst_collected'], 2); ?></h1>
                                                <p class="mb-0">GST Collected</p>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-xl-2 col-md-4 col-6 mb-3">
                                        <div class="card stat-card bg-secondary text-white">
                                            <div class="card-body text-center">
                                                <h1 class="mb-1"><?php echo number_format($total_summary['unique_customers']); ?></h1>
                                                <p class="mb-0">Unique Customers</p>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <?php foreach ($sales_data as $branch_name => $data): 
                        $summary = $data['summary'];
                        $branch_info = $data['branch_info'];
                        $branch_id = $data['branch_id'];
                        $is_current = $branch_id == $current_branch_id;
                    ?>
                    <div class="col-xl-<?php echo count($sales_data) == 1 ? '12' : '6'; ?> col-lg-<?php echo count($sales_data) == 1 ? '12' : '6'; ?> mb-4">
                        <div class="card branch-card <?php echo $is_current ? 'branch-highlight' : ''; ?>">
                            <div class="card-header bg-light">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-store me-2"></i>
                                        <?php echo htmlspecialchars($branch_name); ?>
                                        <?php if ($is_current): ?>
                                            <span class="badge bg-primary">Current</span>
                                        <?php endif; ?>
                                    </h5>
                                    <span class="badge bg-<?php echo $summary['total_sales'] > 0 ? 'success' : 'secondary'; ?>">
                                        <?php echo number_format($summary['total_sales'] ?? 0); ?> Sales
                                    </span>
                                </div>
                            </div>
                            <div class="card-body">
                                
                                <div class="row mb-3">
                                    <div class="col-md-6 mb-2">
                                        <div class="card border">
                                            <div class="card-body text-center py-2">
                                                <h6 class="text-muted mb-1">Total Revenue</h6>
                                                <h4 class="mb-0 text-primary">₹<?php echo number_format($summary['total_revenue'] ?? 0, 2); ?></h4>
                                                <small class="text-muted">Gross Amount</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6 mb-2">
                                        <div class="card border">
                                            <div class="card-body text-center py-2">
                                                <h6 class="text-muted mb-1">Avg Sale Value</h6>
                                                <h4 class="mb-0 text-success">₹<?php echo number_format($summary['avg_sale_value'] ?? 0, 2); ?></h4>
                                                <small class="text-muted">Per Transaction</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6 mb-2">
                                        <div class="card border">
                                            <div class="card-body text-center py-2">
                                                <h6 class="text-muted mb-1">Collected</h6>
                                                <h4 class="mb-0 text-info">₹<?php echo number_format($summary['total_collected'] ?? 0, 2); ?></h4>
                                                <small class="text-muted">Cash Received</small>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="col-md-6 mb-2">
                                        <div class="card border">
                                            <div class="card-body text-center py-2">
                                                <h6 class="text-muted mb-1">Pending</h6>
                                                <h4 class="mb-0 text-danger">₹<?php echo number_format($summary['total_pending'] ?? 0, 2); ?></h4>
                                                <small class="text-muted">Outstanding</small>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <?php if (!empty($data['payment_types'])): ?>
                                <div class="mb-3">
                                    <h6 class="mb-2"><i class="fas fa-credit-card me-1"></i> Payment Distribution</h6>
                                    <div class="d-flex flex-wrap gap-1">
                                        <?php foreach ($data['payment_types'] as $type => $stats): 
                                            $percentage = $summary['total_revenue'] > 0 ? ($stats['amount'] / $summary['total_revenue']) * 100 : 0;
                                        ?>
                                            <span class="badge bg-primary payment-badge">
                                                <?php echo strtoupper($type); ?>: 
                                                ₹<?php echo number_format($stats['amount'], 2); ?> 
                                                (<?php echo number_format($percentage, 1); ?>%)
                                            </span>
                                        <?php endforeach; ?>
                                    </div>
                                </div>
                                <?php endif; ?>
                                
                                
                                <?php if (!empty($data['customer_stats'])): ?>
                                <div class="mb-3">
                                    <h6 class="mb-2"><i class="fas fa-users me-1"></i> Customer Statistics</h6>
                                    <div class="row">
                                        <div class="col-6">
                                            <small class="text-muted">Total Customers</small>
                                            <h6 class="mb-0"><?php echo $data['customer_stats']['total_customers'] ?? 0; ?></h6>
                                        </div>
                                        <div class="col-6">
                                            <small class="text-muted">Credit Customers</small>
                                            <h6 class="mb-0"><?php echo $data['customer_stats']['credit_customers'] ?? 0; ?></h6>
                                        </div>
                                        <div class="col-12 mt-2">
                                            <small class="text-muted">Avg Customer Spend</small>
                                            <h6 class="mb-0">₹<?php echo number_format($data['customer_stats']['avg_customer_spend'] ?? 0, 2); ?></h6>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>
                                
                                
                                <?php if (!empty($data['top_products'])): ?>
                                <div>
                                    <h6 class="mb-2"><i class="fas fa-trophy me-1"></i> Top Products</h6>
                                    <div class="list-group">
                                        <?php foreach ($data['top_products'] as $index => $product): ?>
                                            <div class="list-group-item list-group-item-action top-product-item">
                                                <div class="d-flex align-items-center">
                                                    <div class="product-rank <?php echo $index < 3 ? 'rank-' . ($index + 1) : 'rank-other'; ?>">
                                                        <?php echo $index + 1; ?>
                                                    </div>
                                                    <div class="flex-grow-1">
                                                        <h6 class="mb-0"><?php echo htmlspecialchars($product['product_name']); ?></h6>
                                                        <small class="text-muted">
                                                            Sold: <?php echo $product['total_quantity']; ?> units | 
                                                            Revenue: ₹<?php echo number_format($product['total_revenue'], 2); ?>
                                                        </small>
                                                    </div>
                                                </div>
                                            </div>
                                        <?php endforeach; ?>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                    <?php endforeach; ?>
                </div>

<div class="row mb-4">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center">
                                    <h5 class="card-title mb-0">
                                        <i class="fas fa-chart-line me-2"></i>
                                        Sales Trend Comparison
                                        <small class="text-muted">(<?php echo ucfirst($comparison_type); ?> Basis)</small>
                                    </h5>
                                    <div class="btn-group" role="group">
                                        <button type="button" class="btn btn-outline-primary btn-sm" onclick="exportChartAsPNG()">
                                            <i class="fas fa-download me-1"></i>PNG
                                        </button>
                                        <button type="button" class="btn btn-outline-success btn-sm" onclick="exportChartData()">
                                            <i class="fas fa-file-excel me-1"></i>CSV
                                        </button>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">
                                <div id="salesTrendChart" style="height: 400px;"></div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <h5 class="card-title mb-0">
                                    <i class="fas fa-table me-2"></i>Detailed Comparison
                                </h5>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Metric</th>
                                                <?php foreach ($sales_data as $branch_name => $data): ?>
                                                    <th class="text-center">
                                                        <?php echo htmlspecialchars($data['branch_info']['branch_name']); ?>
                                                        <br>
                                                        <small class="text-muted"><?php echo $data['branch_info']['branch_code']; ?></small>
                                                    </th>
                                                <?php endforeach; ?>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                <td><strong>Total Sales</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0"><?php echo number_format($data['summary']['total_sales'] ?? 0); ?></h5>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Total Revenue</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0 text-primary">₹<?php echo number_format($data['summary']['total_revenue'] ?? 0, 2); ?></h5>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Amount Collected</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0 text-success">₹<?php echo number_format($data['summary']['total_collected'] ?? 0, 2); ?></h5>
                                                        <small class="text-muted">
                                                            <?php echo $data['summary']['total_revenue'] > 0 ? 
                                                                number_format(($data['summary']['total_collected'] / $data['summary']['total_revenue']) * 100, 1) : 0; ?>%
                                                        </small>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Pending Amount</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0 text-danger">₹<?php echo number_format($data['summary']['total_pending'] ?? 0, 2); ?></h5>
                                                        <small class="text-muted">
                                                            <?php echo $data['summary']['total_revenue'] > 0 ? 
                                                                number_format(($data['summary']['total_pending'] / $data['summary']['total_revenue']) * 100, 1) : 0; ?>%
                                                        </small>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Average Sale Value</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0">₹<?php echo number_format($data['summary']['avg_sale_value'] ?? 0, 2); ?></h5>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Unique Customers</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0"><?php echo number_format($data['summary']['unique_customers'] ?? 0); ?></h5>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>GST Collected</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td class="text-center">
                                                        <h5 class="mb-0 text-info">₹<?php echo number_format($data['summary']['total_gst_collected'] ?? 0, 2); ?></h5>
                                                        <small class="text-muted">
                                                            <?php echo $data['summary']['total_revenue'] > 0 ? 
                                                                number_format(($data['summary']['total_gst_collected'] / $data['summary']['total_revenue']) * 100, 1) : 0; ?>%
                                                        </small>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                            <tr>
                                                <td><strong>Payment Methods</strong></td>
                                                <?php foreach ($sales_data as $data): ?>
                                                    <td>
                                                        <?php if (!empty($data['payment_types'])): ?>
                                                            <div class="d-flex flex-column gap-1">
                                                                <?php foreach ($data['payment_types'] as $type => $stats): 
                                                                    $percentage = $data['summary']['total_revenue'] > 0 ? ($stats['amount'] / $data['summary']['total_revenue']) * 100 : 0;
                                                                ?>
                                                                    <div>
                                                                        <small class="text-muted"><?php echo strtoupper($type); ?></small>
                                                                        <div class="d-flex justify-content-between">
                                                                            <span>₹<?php echo number_format($stats['amount'], 2); ?></span>
                                                                            <span><?php echo number_format($percentage, 1); ?>%</span>
                                                                        </div>
                                                                    </div>
                                                                <?php endforeach; ?>
                                                            </div>
                                                        <?php else: ?>
                                                            <span class="text-muted">No data</span>
                                                        <?php endif; ?>
                                                    </td>
                                                <?php endforeach; ?>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php else: ?>
                
                <div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-body text-center py-5">
                                <i class="fas fa-chart-bar fa-4x text-muted mb-4"></i>
                                <h4 class="text-muted mb-3">No Data Available</h4>
                                <p class="text-muted mb-4">Select branches and date range to view comparison data.</p>
                                <a href="sales-comparison.php" class="btn btn-primary">
                                    <i class="fas fa-filter me-2"></i>Apply Filters
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

</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/apexcharts"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css">

<?php if (!empty($sales_data)): ?>
// Prepare chart data
let salesTrendOptions = {
    series: [],
    chart: {
        type: 'line',
        height: 400,
        toolbar: {
            show: true,
            tools: {
                download: true,
                selection: true,
                zoom: true,
                zoomin: true,
                zoomout: true,
                pan: true,
                reset: true
            }
        }
    },
    colors: ['#556ee6', '#f46a6a', '#34c38f', '#f1b44c', '#50a5f1', '#74788d'],
    dataLabels: {
        enabled: false
    },
    stroke: {
        curve: 'smooth',
        width: 2
    },
    xaxis: {
        type: 'category',
        categories: [],
        title: {
            text: '<?php echo ucfirst($comparison_type); ?> Period'
        }
    },
    yaxis: {
        title: {
            text: 'Sales Amount (₹)'
        },
        labels: {
            formatter: function(value) {
                return '₹' + value.toLocaleString('en-IN');
            }
        }
    },
    tooltip: {
        y: {
            formatter: function(value) {
                return '₹' + value.toLocaleString('en-IN', {minimumFractionDigits: 2});
            }
        }
    },
    legend: {
        position: 'top',
        horizontalAlign: 'center'
    },
    grid: {
        borderColor: '#f1f1f1',
    },
    markers: {
        size: 4,
        hover: {
            size: 6
        }
    }
};

// Get all periods across all branches for consistent x-axis
<?php 
$all_periods = [];
foreach ($sales_data as $data) {
    $all_periods = array_merge($all_periods, array_keys($data['trend_data']));
}
$all_periods = array_unique($all_periods);
sort($all_periods);

// Format period labels based on comparison type
$formatted_periods = [];
foreach ($all_periods as $period) {
    if ($comparison_type == 'daily') {
        $formatted_periods[] = date('d M', strtotime($period));
    } elseif ($comparison_type == 'weekly') {
        // Extract year and week number
        $year = substr($period, 0, 4);
        $week = substr($period, 4, 2);
        $formatted_periods[] = 'Week ' . $week . ', ' . $year;
    } elseif ($comparison_type == 'monthly') {
        $formatted_periods[] = date('M Y', strtotime($period . '-01'));
    }
}
?>

salesTrendOptions.xaxis.categories = <?php echo json_encode($formatted_periods); ?>;

<?php 
$color_index = 0;
foreach ($sales_data as $branch_name => $data): 
    $trend_data = [];
    $collection_data = [];
    foreach ($all_periods as $period) {
        $trend_data[] = isset($data['trend_data'][$period]) ? (float)$data['trend_data'][$period]['sales_amount'] : 0;
        $collection_data[] = isset($data['trend_data'][$period]) ? (float)$data['trend_data'][$period]['collected_amount'] : 0;
    }
?>
salesTrendOptions.series.push({
    name: '<?php echo addslashes($branch_name); ?> - Revenue',
    data: <?php echo json_encode($trend_data); ?>
});
salesTrendOptions.series.push({
    name: '<?php echo addslashes($branch_name); ?> - Collected',
    data: <?php echo json_encode($collection_data); ?>,
    type: 'area',
    fill: {
        type: 'gradient',
        gradient: {
            shadeIntensity: 1,
            opacityFrom: 0.2,
            opacityTo: 0.1
        }
    }
});
<?php 
$color_index++;
endforeach; 
?>

// Render sales trend chart
let salesTrendChart = new ApexCharts(document.querySelector("#salesTrendChart"), salesTrendOptions);
salesTrendChart.render();

// Export chart as PNG
function exportChartAsPNG() {
    salesTrendChart.dataURI().then((uri) => {
        const link = document.createElement('a');
        link.download = 'sales_comparison_<?php echo date('Y-m-d'); ?>.png';
        link.href = uri;
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    });
}

// Export chart data as CSV
function exportChartData() {
    let csvContent = "data:text/csv;charset=utf-8,";
    
    // Header row
    csvContent += "Period,";
    <?php foreach ($sales_data as $branch_name => $data): ?>
    csvContent += "<?php echo addslashes($branch_name); ?> Revenue,<?php echo addslashes($branch_name); ?> Collected,";
    <?php endforeach; ?>
    csvContent += "\n";
    
    // Data rows
    <?php for ($i = 0; $i < count($all_periods); $i++): ?>
    csvContent += "<?php echo $formatted_periods[$i]; ?>,";
    <?php 
    $data_index = 0;
    foreach ($sales_data as $branch_name => $data): 
        $revenue = isset($data['trend_data'][$all_periods[$i]]) ? $data['trend_data'][$all_periods[$i]]['sales_amount'] : 0;
        $collected = isset($data['trend_data'][$all_periods[$i]]) ? $data['trend_data'][$all_periods[$i]]['collected_amount'] : 0;
    ?>
    csvContent += "<?php echo $revenue; ?>,<?php echo $collected; ?>,";
    <?php 
    $data_index++;
    endforeach; 
    ?>
    csvContent += "\n";
    <?php endfor; ?>
    
    const encodedUri = encodeURI(csvContent);
    const link = document.createElement('a');
    link.setAttribute('href', encodedUri);
    link.setAttribute('download', 'sales_comparison_data_<?php echo date('Y-m-d'); ?>.csv');
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}

// Function to print comparison report
function printComparisonReport() {
    const printContent = document.getElementById('main-content').innerHTML;
    const printWindow = window.open('', '_blank', 'width=1200,height=800');
    printWindow.document.write(`
        <!DOCTYPE html>
        <html>
        <head>
            <title>Sales Comparison Report - <?php echo date('d M Y'); ?></title>
            <style>
                body { margin: 20px; font-family: Arial, sans-serif; }
                .card { border: 1px solid #dee2e6; border-radius: 8px; margin-bottom: 20px; }
                .card-header { background: #f8f9fa; padding: 15px; border-bottom: 1px solid #dee2e6; }
                .card-body { padding: 15px; }
                .table { width: 100%; border-collapse: collapse; margin-bottom: 20px; }
                .table th, .table td { border: 1px solid #dee2e6; padding: 8px; text-align: left; }
                .table th { background: #f8f9fa; font-weight: bold; }
                .text-center { text-align: center; }
                .text-primary { color: #556ee6; }
                .text-success { color: #34c38f; }
                .text-danger { color: #f46a6a; }
                .text-info { color: #50a5f1; }
                .badge { padding: 4px 8px; border-radius: 4px; font-size: 12px; }
                .bg-primary { background: #556ee6; color: white; }
                .bg-success { background: #34c38f; color: white; }
                .bg-danger { background: #f46a6a; color: white; }
                .bg-info { background: #50a5f1; color: white; }
                .row { display: flex; flex-wrap: wrap; margin: 0 -10px; }
                .col-6 { width: 50%; padding: 0 10px; }
                .col-12 { width: 100%; padding: 0 10px; }
                .mb-2 { margin-bottom: 10px; }
                .mb-3 { margin-bottom: 15px; }
                .mb-4 { margin-bottom: 20px; }
            </style>
        </head>
        <body>
            <h1>Sales Comparison Report</h1>
            <p><strong>Date Range:</strong> <?php echo date('d M Y', strtotime($start_date)); ?> to <?php echo date('d M Y', strtotime($end_date)); ?></p>
            <p><strong>Comparison Type:</strong> <?php echo ucfirst($comparison_type); ?></p>
            <p><strong>Branches Compared:</strong> <?php echo count($selected_branches); ?></p>
            <hr>
            ${printContent}
        </body>
        </html>
    `);
    printWindow.document.close();
    printWindow.focus();
    setTimeout(() => {
        printWindow.print();
    }, 500);
}

// Add print button to the page
$(document).ready(function() {
    // Create print button
    const printBtn = $('<button>', {
        class: 'btn btn-outline-secondary',
        html: '<i class="fas fa-print me-2"></i>Print Report',
        click: printComparisonReport
    });
    
    // Add to header
    $('.page-title-right').prepend(printBtn);
});
<?php endif; ?>
</script>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-comparison.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation