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/bakery/admin

Free Space:

10.25 TB

🔧 Quick Actions

✏️ Editing: payments-reports.php

<?php
session_start();
require_once 'config/db_config.php';

// Authentication
if (!isset($_SESSION['user_id']) || !isset($_SESSION['role']) || !in_array($_SESSION['role'], ['super_admin', 'admin', 'branch'])) {
    header("Location: ../login.php");
    exit();
}

if (empty($_SESSION['csrf_token'])) {
    $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
}
$csrf = $_SESSION['csrf_token'];

function h(string $v): string { 
    return htmlspecialchars($v, ENT_QUOTES, 'UTF-8'); 
}

// Get current logged-in user's owner_id from session
$current_owner_id = $_SESSION['owner_id'] ?? null;

if (!$current_owner_id) {
    // Try to get owner_id from database if not in session
    try {
        $stmt = $pdo->prepare("SELECT owner_id FROM users WHERE user_id = ?");
        $stmt->execute([$_SESSION['user_id']]);
        $user_data = $stmt->fetch(PDO::FETCH_ASSOC);
        $current_owner_id = $user_data['owner_id'] ?? 0;
        
        // Update session with owner_id
        $_SESSION['owner_id'] = $current_owner_id;
    } catch (PDOException $e) {
        $_SESSION['error'] = "Error fetching user data: " . h($e->getMessage());
        header("Location: ../login.php");
        exit();
    }
}

// Only show reports for the logged-in owner
$selected_owner_id = $current_owner_id;

// Handle CSV/JSON exports - ONLY FOR LOGGED-IN OWNER
if (isset($_GET['export']) && in_array($_GET['export'], ['excel', 'json'])) {
    $report_type = $_GET['report_type'] ?? 'payment_methods';
    $selected_branch_id = $_SESSION['role'] === 'branch' ? ($_SESSION['branch_id'] ?? 'all') : ($_GET['branch_id'] ?? 'all');
    $selected_method = $_GET['method'] ?? 'all';
    $start_date = $_GET['start_date'] ?? date('Y-m-d', strtotime('-30 days'));
    $end_date = $_GET['end_date'] ?? date('Y-m-d');
    $status = $_GET['status'] ?? 'all';
    
    try {
        if ($report_type === 'payment_methods') {
            $params = [
                'start_date' => $start_date . ' 00:00:00', 
                'end_date' => $end_date . ' 23:59:59',
                'owner_id' => $selected_owner_id
            ];
            
            $where_clause = [
                "o.order_date BETWEEN :start_date AND :end_date",
                "b.owner_id = :owner_id"  // ONLY show current owner's data
            ];
            
            if ($selected_branch_id !== 'all' && is_numeric($selected_branch_id)) {
                $where_clause[] = 'o.branch_id = :branch_id';
                $params['branch_id'] = $selected_branch_id;
            }
            if ($selected_method !== 'all') {
                $where_clause[] = 'o.payment_method = :payment_method';
                $params['payment_method'] = $selected_method;
            }
            if ($status !== 'all' && in_array($status, ['pending', 'processing', 'completed', 'cancelled'])) {
                $where_clause[] = 'o.status = :status';
                $params['status'] = $status;
            }
            
            $query = "
                SELECT 
                    o.payment_method,
                    COUNT(DISTINCT o.order_id) as order_count,
                    SUM(o.total_amount) as total_amount,
                    SUM(o.taxable_amount) as total_taxable,
                    SUM(o.cgst_amount + o.sgst_amount) as total_gst,
                    AVG(o.total_amount) as avg_order_value,
                    MIN(o.order_date) as first_payment_date,
                    MAX(o.order_date) as last_payment_date
                FROM orders o
                JOIN branches b ON o.branch_id = b.branch_id
                WHERE " . implode(' AND ', $where_clause) . "
                GROUP BY o.payment_method
                ORDER BY total_amount DESC
            ";
            
            $stmt = $pdo->prepare($query);
            $stmt->execute($params);
            $data = $stmt->fetchAll(PDO::FETCH_ASSOC);
            
            if ($_GET['export'] === 'excel') {
                header('Content-Type: text/csv; charset=utf-8');
                header('Content-Disposition: attachment;filename="payment_methods_report_' . date('Ymd_His') . '.csv"');
                $output = fopen('php://output', 'w');
                fputs($output, "\xEF\xBB\xBF");
                fputcsv($output, ['Payment Method', 'Order Count', 'Total Amount', 'Taxable Amount', 'Total GST', 'Avg Order Value', 'First Payment', 'Last Payment']);
                foreach ($data as $row) {
                    fputcsv($output, [
                        $row['payment_method'],
                        $row['order_count'],
                        number_format($row['total_amount'], 2),
                        number_format($row['total_taxable'], 2),
                        number_format($row['total_gst'], 2),
                        number_format($row['avg_order_value'], 2),
                        $row['first_payment_date'] ? date('d M Y', strtotime($row['first_payment_date'])) : 'N/A',
                        $row['last_payment_date'] ? date('d M Y', strtotime($row['last_payment_date'])) : 'N/A'
                    ]);
                }
                fclose($output);
                exit();
            } else {
                header('Content-Type: application/json; charset=utf-8');
                header('Content-Disposition: attachment;filename="payment_methods_report_' . date('Ymd_His') . '.json"');
                $export_data = array_map(function($row) {
                    return [
                        'payment_method' => $row['payment_method'],
                        'order_count' => (int)$row['order_count'],
                        'total_amount' => (float)$row['total_amount'],
                        'taxable_amount' => (float)$row['total_taxable'],
                        'total_gst' => (float)$row['total_gst'],
                        'avg_order_value' => (float)$row['avg_order_value'],
                        'first_payment_date' => $row['first_payment_date'] ? date('Y-m-d H:i:s', strtotime($row['first_payment_date'])) : null,
                        'last_payment_date' => $row['last_payment_date'] ? date('Y-m-d H:i:s', strtotime($row['last_payment_date'])) : null
                    ];
                }, $data);
                
                echo json_encode([
                    'export_info' => [
                        'export_date' => date('Y-m-d H:i:s'),
                        'owner_id' => $selected_owner_id,
                        'filters' => [
                            'branch_id' => $selected_branch_id,
                            'payment_method' => $selected_method,
                            'start_date' => $start_date,
                            'end_date' => $end_date,
                            'status' => $status
                        ]
                    ],
                    'data' => $export_data
                ], JSON_PRETTY_PRINT | JSON_NUMERIC_CHECK);
                exit();
            }
        }
    } catch (Exception $e) {
        $_SESSION['error'] = "Error exporting report: " . h($e->getMessage());
        header("Location: payments-reports.php");
        exit();
    }
}

// Define filters - ONLY FOR LOGGED-IN OWNER
$selected_branch_id = $_SESSION['role'] === 'branch' ? ($_SESSION['branch_id'] ?? 'all') : ($_GET['branch_id'] ?? 'all');
$selected_method = $_GET['method'] ?? 'all';
$start_date = $_GET['start_date'] ?? date('Y-m-d', strtotime('-30 days'));
$end_date = $_GET['end_date'] ?? date('Y-m-d');
$status = $_GET['status'] ?? 'all';

// Fetch owner info
try {
    $stmt = $pdo->prepare("SELECT owner_name FROM owners WHERE owner_id = ?");
    $stmt->execute([$selected_owner_id]);
    $owner_info = $stmt->fetch(PDO::FETCH_ASSOC);
    $owner_name = $owner_info['owner_name'] ?? 'Your Business';
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching owner info: " . h($e->getMessage());
    $owner_name = 'Your Business';
}

// Fetch branches - ONLY FOR CURRENT OWNER
try {
    if ($_SESSION['role'] === 'branch') {
        // Branch user - only their branch
        $query = "
            SELECT b.branch_id, b.branch_name 
            FROM branches b
            WHERE b.branch_id = ? AND b.owner_id = ?
            ORDER BY b.branch_name
        ";
        $stmt = $pdo->prepare($query);
        $stmt->execute([$_SESSION['branch_id'] ?? 0, $selected_owner_id]);
        $branches = $stmt->fetchAll(PDO::FETCH_ASSOC);
    } else {
        // Admin/super_admin for this owner
        $query = "
            SELECT b.branch_id, b.branch_name 
            FROM branches b
            WHERE b.owner_id = ?
            ORDER BY b.branch_name
        ";
        $stmt = $pdo->prepare($query);
        $stmt->execute([$selected_owner_id]);
        $branches = $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching branches: " . h($e->getMessage());
    $branches = [];
}

// Get unique payment methods from orders - ONLY FOR CURRENT OWNER
try {
    $params = [$selected_owner_id];
    $where_clause = [
        "b.owner_id = ?",
        "o.payment_method IS NOT NULL", 
        "o.payment_method != ''"
    ];
    
    $query = "
        SELECT DISTINCT o.payment_method 
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE " . implode(' AND ', $where_clause) . "
        ORDER BY o.payment_method
    ";
    
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $payment_methods = $stmt->fetchAll(PDO::FETCH_COLUMN);
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching payment methods: " . h($e->getMessage());
    $payment_methods = ['Cash', 'Card', 'UPI', 'Online'];
}

// Fetch payment methods summary - ONLY FOR CURRENT OWNER
try {
    $params = [
        'start_date' => $start_date . ' 00:00:00', 
        'end_date' => $end_date . ' 23:59:59',
        'owner_id' => $selected_owner_id
    ];
    
    $where_clause = [
        "o.order_date BETWEEN :start_date AND :end_date",
        "b.owner_id = :owner_id"  // ONLY current owner
    ];
    
    if ($selected_branch_id !== 'all' && is_numeric($selected_branch_id)) {
        $where_clause[] = 'o.branch_id = :branch_id';
        $params['branch_id'] = $selected_branch_id;
    }
    if ($selected_method !== 'all') {
        $where_clause[] = 'o.payment_method = :payment_method';
        $params['payment_method'] = $selected_method;
    }
    if ($status !== 'all' && in_array($status, ['pending', 'processing', 'completed', 'cancelled'])) {
        $where_clause[] = 'o.status = :status';
        $params['status'] = $status;
    }
    
    // Overall summary
    $query = "
        SELECT 
            o.payment_method,
            COUNT(DISTINCT o.order_id) as order_count,
            SUM(o.total_amount) as total_amount,
            SUM(o.taxable_amount) as total_taxable,
            SUM(o.cgst_amount + o.sgst_amount) as total_gst,
            AVG(o.total_amount) as avg_order_value,
            MIN(o.order_date) as first_payment_date,
            MAX(o.order_date) as last_payment_date
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE " . implode(' AND ', $where_clause) . "
        GROUP BY o.payment_method
        ORDER BY total_amount DESC
    ";
    
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $payment_summary = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Calculate totals
    $total_orders = 0;
    $total_amount = 0;
    $total_gst = 0;
    $total_taxable = 0;
    
    foreach ($payment_summary as $method) {
        $total_orders += $method['order_count'];
        $total_amount += $method['total_amount'];
        $total_gst += $method['total_gst'];
        $total_taxable += $method['total_taxable'];
    }
    
    // Get top payment method
    $top_method = $payment_summary[0] ?? null;
    
    // Get branch-wise breakdown - ONLY FOR CURRENT OWNER
    $branch_query = "
        SELECT 
            b.branch_name,
            o.payment_method,
            COUNT(DISTINCT o.order_id) as order_count,
            SUM(o.total_amount) as total_amount
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE " . implode(' AND ', $where_clause) . "
        GROUP BY b.branch_name, o.payment_method
        ORDER BY total_amount DESC
    ";
    
    $stmt = $pdo->prepare($branch_query);
    $stmt->execute($params);
    $branch_breakdown = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Get hourly distribution - ONLY FOR CURRENT OWNER
    $hourly_query = "
        SELECT 
            HOUR(o.order_date) as hour,
            o.payment_method,
            COUNT(DISTINCT o.order_id) as order_count,
            SUM(o.total_amount) as total_amount
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE " . implode(' AND ', $where_clause) . "
        GROUP BY HOUR(o.order_date), o.payment_method
        ORDER BY HOUR(o.order_date)
    ";
    
    $stmt = $pdo->prepare($hourly_query);
    $stmt->execute($params);
    $hourly_distribution = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Get payment method growth (vs previous period) - ONLY FOR CURRENT OWNER
    $prev_start_date = date('Y-m-d', strtotime($start_date . ' -1 month'));
    $prev_end_date = date('Y-m-d', strtotime($end_date . ' -1 month'));
    
    // SIMPLIFIED GROWTH CALCULATION - Fixed parameter conflict issue
    $current_params = $params; // Copy main params
    $prev_params = [
        'prev_start_date' => $prev_start_date . ' 00:00:00',
        'prev_end_date' => $prev_end_date . ' 23:59:59',
        'owner_id_prev' => $selected_owner_id
    ];
    
    // Add conditional parameters for current period
    if ($selected_branch_id !== 'all' && is_numeric($selected_branch_id)) {
        $prev_params['branch_id_prev'] = $selected_branch_id;
    }
    if ($selected_method !== 'all') {
        $prev_params['payment_method_prev'] = $selected_method;
    }
    if ($status !== 'all' && in_array($status, ['pending', 'processing', 'completed', 'cancelled'])) {
        $prev_params['status_prev'] = $status;
    }
    
    // Calculate previous period data separately
    $prev_where_clause = [
        "o.order_date BETWEEN :prev_start_date AND :prev_end_date",
        "b.owner_id = :owner_id_prev"
    ];
    
    if ($selected_branch_id !== 'all' && is_numeric($selected_branch_id)) {
        $prev_where_clause[] = 'o.branch_id = :branch_id_prev';
    }
    if ($selected_method !== 'all') {
        $prev_where_clause[] = 'o.payment_method = :payment_method_prev';
    }
    if ($status !== 'all' && in_array($status, ['pending', 'processing', 'completed', 'cancelled'])) {
        $prev_where_clause[] = 'o.status = :status_prev';
    }
    
    $prev_query = "
        SELECT 
            o.payment_method,
            SUM(o.total_amount) as prev_amount
        FROM orders o
        JOIN branches b ON o.branch_id = b.branch_id
        WHERE " . implode(' AND ', $prev_where_clause) . "
        GROUP BY o.payment_method
    ";
    
    $stmt = $pdo->prepare($prev_query);
    $stmt->execute($prev_params);
    $prev_period_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Convert to associative array for easy lookup
    $prev_data_lookup = [];
    foreach ($prev_period_data as $prev_row) {
        $prev_data_lookup[$prev_row['payment_method']] = $prev_row['prev_amount'] ?? 0;
    }
    
    // Calculate growth percentages using separate queries
    foreach ($payment_summary as &$method) {
        $method_name = $method['payment_method'];
        $prev_amount = $prev_data_lookup[$method_name] ?? 0;
        $current_amount = $method['total_amount'];
        
        if ($prev_amount > 0) {
            $growth_percent = (($current_amount - $prev_amount) / $prev_amount) * 100;
        } else {
            $growth_percent = $current_amount > 0 ? 100 : 0;
        }
        
        $method['growth_percent'] = round($growth_percent, 1);
        $method['prev_period_amount'] = $prev_amount;
        $method['growth_amount'] = $current_amount - $prev_amount;
    }
    unset($method);
    
} catch (PDOException $e) {
    $_SESSION['error'] = "Error fetching payment data: " . h($e->getMessage()) . " - Query: " . $e->getMessage();
    $payment_summary = [];
    $total_orders = $total_amount = $total_gst = $total_taxable = 0;
    $top_method = null;
    $branch_breakdown = [];
    $hourly_distribution = [];
}

$branch_name = $_SESSION['role'] === 'branch' ? ($branches[0]['branch_name'] ?? 'Your Branch') : 'All Branches';

// For non-super_admin users, remove super_admin specific sections
$show_super_admin_features = ($_SESSION['role'] === 'super_admin' && false); // Set to false to hide super admin features

include './partials/layouts/layoutTop.php';
?>

.fa-icon { 
    font-size: 14px; 
    margin-right: 6px;
    vertical-align: middle;
}

/* Card Design */
.card-modern {
    background: white;
    border: 1px solid var(--border);
    border-radius: 12px;
    box-shadow: 0 1px 3px rgba(0,0,0,0.04);
    transition: all 0.3s ease;
    margin-bottom: 1rem;
}

.card-modern:hover {
    box-shadow: 0 4px 20px rgba(0,0,0,0.08);
    transform: translateY(-2px);
}

.card-modern .card-header {
    background: white;
    border-bottom: 1px solid var(--border);
    padding: 1.25rem 1.5rem;
    border-radius: 12px 12px 0 0;
}

.card-modern .card-body {
    padding: 1.5rem;
}

/* Summary Cards */
.stat-card {
    background: linear-gradient(135deg, var(--primary) 0%, var(--secondary) 100%);
    color: white;
    border-radius: 12px;
    padding: 1.5rem;
    position: relative;
    overflow: hidden;
    height: 100%;
}

.stat-card::before {
    content: '';
    position: absolute;
    top: -50%;
    right: -50%;
    width: 200px;
    height: 200px;
    background: rgba(255,255,255,0.1);
    border-radius: 50%;
}

.stat-card:nth-child(2) {
    background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%);
}

.stat-card:nth-child(3) {
    background: linear-gradient(135deg, #4facfe 0%, #00f2fe 100%);
}

.stat-card:nth-child(4) {
    background: linear-gradient(135deg, #43e97b 0%, #38f9d7 100%);
}

.stat-icon {
    width: 48px;
    height: 48px;
    background: rgba(255,255,255,0.2);
    border-radius: 12px;
    display: flex;
    align-items: center;
    justify-content: center;
    margin-bottom: 1rem;
}

.stat-value {
    font-size: 1.8rem;
    font-weight: 700;
    line-height: 1.2;
    margin-bottom: 0.25rem;
}

.stat-label {
    font-size: 0.875rem;
    opacity: 0.9;
    margin-bottom: 0.5rem;
}

.stat-subtext {
    font-size: 0.75rem;
    opacity: 0.8;
    display: flex;
    align-items: center;
    gap: 0.5rem;
}

/* Filters */
.filter-section {
    background: white;
    border-radius: 12px;
    padding: 1.5rem;
    margin-bottom: 1.5rem;
    border: 1px solid var(--border);
}

.filter-label {
    font-size: 0.75rem;
    font-weight: 600;
    color: var(--gray);
    text-transform: uppercase;
    letter-spacing: 0.5px;
    margin-bottom: 0.5rem;
}

.form-control-modern {
    border: 1px solid var(--border);
    border-radius: 8px;
    padding: 0.625rem 1rem;
    font-size: 0.875rem;
    transition: all 0.3s ease;
}

.form-control-modern:focus {
    border-color: var(--primary);
    box-shadow: 0 0 0 3px rgba(67, 97, 238, 0.1);
}

.btn-modern {
    padding: 0.625rem 1.5rem;
    border-radius: 8px;
    font-weight: 500;
    transition: all 0.3s ease;
    border: none;
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
}

.btn-primary-modern {
    background: var(--primary);
    color: white;
}

.btn-primary-modern:hover {
    background: var(--primary-dark);
    transform: translateY(-1px);
    box-shadow: 0 4px 12px rgba(67, 97, 238, 0.2);
}

.btn-outline-modern {
    background: white;
    border: 1px solid var(--border);
    color: var(--dark);
}

.btn-outline-modern:hover {
    background: var(--light);
    border-color: var(--primary);
    color: var(--primary);
}

/* Table Styling */
.table-modern {
    border-collapse: separate;
    border-spacing: 0;
    width: 100%;
}

.table-modern th {
    background: var(--light);
    padding: 1rem;
    font-weight: 600;
    color: var(--dark);
    font-size: 0.75rem;
    text-transform: uppercase;
    letter-spacing: 0.5px;
    border: none;
    border-bottom: 1px solid var(--border);
}

.table-modern td {
    padding: 1rem;
    vertical-align: middle;
    border-bottom: 1px solid var(--border);
    font-size: 0.875rem;
}

.table-modern tbody tr {
    transition: all 0.2s ease;
}

.table-modern tbody tr:hover {
    background: rgba(67, 97, 238, 0.02);
}

/* Method Badges */
.method-badge {
    display: inline-flex;
    align-items: center;
    gap: 0.5rem;
    padding: 0.5rem 1rem;
    border-radius: 20px;
    font-size: 0.75rem;
    font-weight: 500;
    background: white;
    border: 1px solid var(--border);
}

.method-cash { color: #059669; border-color: #10b981; }
.method-card { color: #2563eb; border-color: #3b82f6; }
.method-upi { color: #7c3aed; border-color: #8b5cf6; }
.method-online { color: #ea580c; border-color: #f97316; }
.method-credit { color: #dc2626; border-color: #ef4444; }

/* Branch Cards */
.branch-card {
    background: white;
    border: 1px solid var(--border);
    border-radius: 10px;
    padding: 1.25rem;
    margin-bottom: 0.75rem;
    transition: all 0.3s ease;
}

.branch-card:hover {
    border-color: var(--primary);
    box-shadow: 0 4px 12px rgba(0,0,0,0.05);
}

/* Progress Bars */
.progress-modern {
    height: 6px;
    background: var(--light);
    border-radius: 3px;
    overflow: hidden;
}

.progress-bar-modern {
    background: var(--primary);
    border-radius: 3px;
    transition: width 1s ease;
}

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

/* Trend Indicators */
.trend-up {
    color: #059669;
    font-weight: 600;
    display: flex;
    align-items: center;
    gap: 0.25rem;
}

.trend-down {
    color: #dc2626;
    font-weight: 600;
    display: flex;
    align-items: center;
    gap: 0.25rem;
}

.trend-neutral {
    color: var(--gray);
    font-weight: 600;
    display: flex;
    align-items: center;
    gap: 0.25rem;
}

/* Export Options */
.export-options {
    display: grid;
    gap: 0.75rem;
}

.export-btn {
    display: flex;
    align-items: center;
    gap: 0.75rem;
    padding: 1rem;
    border-radius: 10px;
    text-decoration: none;
    font-weight: 500;
    transition: all 0.3s ease;
}

.export-excel {
    background: #ecfdf5;
    color: #059669;
    border: 1px solid #d1fae5;
}

.export-excel:hover {
    background: #d1fae5;
    transform: translateY(-2px);
}

.export-json {
    background: #eff6ff;
    color: #2563eb;
    border: 1px solid #dbeafe;
}

.export-json:hover {
    background: #dbeafe;
    transform: translateY(-2px);
}

.export-print {
    background: #f8fafc;
    color: var(--dark);
    border: 1px solid var(--border);
}

.export-print:hover {
    background: var(--light);
    transform: translateY(-2px);
}

/* Responsive */
@media (max-width: 768px) {
    .stat-value {
        font-size: 1.5rem;
    }
    
    .chart-container {
        height: 250px;
    }
    
    .table-modern {
        font-size: 0.75rem;
    }
    
    .table-modern th,
    .table-modern td {
        padding: 0.75rem 0.5rem;
    }
}

/* Animations */
@keyframes fadeIn {
    from {
        opacity: 0;
        transform: translateY(20px);
    }
    to {
        opacity: 1;
        transform: translateY(0);
    }
}

.fade-in {
    animation: fadeIn 0.5s ease;
}
</style>

<div class="dashboard-main-body">
    
    <div class="d-flex flex-column flex-md-row justify-content-between align-items-start align-items-md-center gap-3 mb-4 fade-in">
        <div>
            <h4 class="fw-bold text-dark mb-1">Payment Analytics</h4>
            <p class="text-muted mb-0">Payment methods analysis for <?= h($owner_name) ?></p>
        </div>
        <div class="d-flex gap-2">
            <button onclick="window.print()" class="btn btn-outline-modern">
                <i class="fas fa-print"></i>
                Print
            </button>
            <a href="reports.php" class="btn btn-primary-modern">
                <i class="fas fa-arrow-left"></i>
                Back to Reports
            </a>
        </div>
    </div>

<nav class="mb-4 fade-in">
        <ol class="breadcrumb bg-transparent p-0">
            <li class="breadcrumb-item">
                <a href="index.php" class="text-decoration-none text-muted">
                    <i class="fas fa-home"></i>
                    Dashboard
                </a>
            </li>
            <li class="breadcrumb-item">
                <a href="reports.php" class="text-decoration-none text-muted">
                    <i class="fas fa-chart-bar"></i>
                    Reports
                </a>
            </li>
            <li class="breadcrumb-item active text-primary fw-semibold">
                <i class="fas fa-credit-card"></i>
                Payment Analytics
            </li>
        </ol>
    </nav>

<?php if (!empty($_SESSION['success'])): ?>
    <div class="alert alert-success alert-dismissible fade show mb-4 fade-in" role="alert">
        <div class="d-flex align-items-center gap-3">
            <div class="rounded-circle bg-success bg-opacity-10 p-2">
                <i class="fas fa-check text-success"></i>
            </div>
            <div class="flex-grow-1">
                <strong>Success!</strong> <?= h($_SESSION['success']); ?>
            </div>
        </div>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        <?php unset($_SESSION['success']); ?>
    </div>
    <?php endif; ?>
    
    <?php if (!empty($_SESSION['error'])): ?>
    <div class="alert alert-danger alert-dismissible fade show mb-4 fade-in" role="alert">
        <div class="d-flex align-items-center gap-3">
            <div class="rounded-circle bg-danger bg-opacity-10 p-2">
                <i class="fas fa-exclamation text-danger"></i>
            </div>
            <div class="flex-grow-1">
                <strong>Error!</strong> <?= h($_SESSION['error']); ?>
            </div>
        </div>
        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
        <?php unset($_SESSION['error']); ?>
    </div>
    <?php endif; ?>

<div class="filter-section fade-in">
        <form method="GET" action="payments-reports.php" class="row g-3">
            <div class="col-12">
                <h6 class="fw-semibold mb-3 text-dark">
                    <i class="fas fa-sliders-h fa-icon"></i>
                    Filter Options
                </h6>
            </div>
            
            <div class="col-md-3">
                <label class="filter-label">Owner</label>
                <div class="form-control form-control-modern bg-light">
                    <?= h($owner_name) ?>
                </div>
                <input type="hidden" name="owner_id" value="<?= h($current_owner_id) ?>">
            </div>
            
            <?php if ($_SESSION['role'] === 'admin' || $_SESSION['role'] === 'super_admin'): ?>
            <div class="col-md-3">
                <label class="filter-label">Branch</label>
                <select class="form-select form-control-modern" name="branch_id" onchange="this.form.submit()">
                    <option value="all" <?= $selected_branch_id === 'all' ? 'selected' : '' ?>>All Branches</option>
                    <?php foreach ($branches as $branch): ?>
                        <option value="<?= h($branch['branch_id']); ?>" <?= $selected_branch_id == $branch['branch_id'] ? 'selected' : '' ?>>
                            <?= h($branch['branch_name']); ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>
            <?php else: ?>
            <div class="col-md-3">
                <label class="filter-label">Branch</label>
                <div class="form-control form-control-modern bg-light">
                    <?= h($branch_name) ?>
                </div>
                <input type="hidden" name="branch_id" value="<?= h($_SESSION['branch_id'] ?? 'all') ?>">
            </div>
            <?php endif; ?>
            
            <div class="col-md-2">
                <label class="filter-label">Payment Method</label>
                <select class="form-select form-control-modern" name="method" onchange="this.form.submit()">
                    <option value="all" <?= $selected_method === 'all' ? 'selected' : '' ?>>All Methods</option>
                    <?php foreach ($payment_methods as $method): ?>
                        <option value="<?= h($method); ?>" <?= $selected_method == $method ? 'selected' : '' ?>>
                            <?= h($method); ?>
                        </option>
                    <?php endforeach; ?>
                </select>
            </div>
            
            <div class="col-md-2">
                <label class="filter-label">From</label>
                <input type="date" class="form-control form-control-modern" name="start_date" value="<?= h($start_date); ?>">
            </div>
            
            <div class="col-md-2">
                <label class="filter-label">To</label>
                <input type="date" class="form-control form-control-modern" name="end_date" value="<?= h($end_date); ?>">
            </div>
            
            <div class="col-md-2">
                <label class="filter-label">Status</label>
                <select class="form-select form-control-modern" name="status" onchange="this.form.submit()">
                    <option value="all" <?= $status === 'all' ? 'selected' : '' ?>>All Status</option>
                    <option value="completed" <?= $status === 'completed' ? 'selected' : '' ?>>Completed</option>
                    <option value="pending" <?= $status === 'pending' ? 'selected' : '' ?>>Pending</option>
                    <option value="processing" <?= $status === 'processing' ? 'selected' : '' ?>>Processing</option>
                    <option value="cancelled" <?= $status === 'cancelled' ? 'selected' : '' ?>>Cancelled</option>
                </select>
            </div>
            
            <div class="col-md-12 d-flex align-items-end gap-2">
                <button type="submit" class="btn btn-primary-modern flex-grow-1">
                    <i class="fas fa-filter"></i>
                    Apply Filters
                </button>
                <a href="payments-reports.php" class="btn btn-outline-modern">
                    <i class="fas fa-redo"></i>
                    Reset
                </a>
            </div>
        </form>
    </div>

<div class="row g-3 mb-4 fade-in">
        <div class="col-md-3">
            <div class="stat-card">
                <div class="stat-icon">
                    <i class="fas fa-money-bill-wave fa-lg text-white"></i>
                </div>
                <div class="stat-value">₹<?= number_format($total_amount, 0) ?></div>
                <div class="stat-label">Total Payment Value</div>
                <div class="stat-subtext">
                    <i class="fas fa-receipt"></i>
                    <?= number_format($total_orders) ?> Orders
                </div>
            </div>
        </div>
        
        <div class="col-md-3">
            <div class="stat-card">
                <div class="stat-icon">
                    <i class="fas fa-shopping-cart fa-lg text-white"></i>
                </div>
                <div class="stat-value"><?= number_format($total_orders) ?></div>
                <div class="stat-label">Total Orders</div>
                <div class="stat-subtext">
                    <i class="fas fa-credit-card"></i>
                    <?= count($payment_summary) ?> Methods
                </div>
            </div>
        </div>
        
        <div class="col-md-3">
            <div class="stat-card">
                <div class="stat-icon">
                    <i class="fas fa-percentage fa-lg text-white"></i>
                </div>
                <div class="stat-value">₹<?= number_format($total_gst, 0) ?></div>
                <div class="stat-label">Total GST</div>
                <div class="stat-subtext">
                    <i class="fas fa-chart-line"></i>
                    Collected
                </div>
            </div>
        </div>
        
        <div class="col-md-3">
            <div class="stat-card">
                <div class="stat-icon">
                    <i class="fas fa-trophy fa-lg text-white"></i>
                </div>
                <div class="stat-value">
                    <?= $top_method ? substr(h($top_method['payment_method']), 0, 12) : 'N/A' ?>
                </div>
                <div class="stat-label">Top Method</div>
                <div class="stat-subtext">
                    <i class="fas fa-rupee-sign"></i>
                    ₹<?= $top_method ? number_format($top_method['total_amount'], 0) : '0' ?>
                </div>
            </div>
        </div>
    </div>

<div class="row g-4">
        
        <div class="col-lg-8">
            
            <div class="card-modern fade-in">
                <div class="card-header">
                    <div class="d-flex justify-content-between align-items-center">
                        <h6 class="mb-0 fw-semibold">
                            <i class="fas fa-chart-pie text-primary"></i>
                            Payment Methods Distribution
                        </h6>
                        <div class="d-flex gap-2">
                            <a href="?export=excel&report_type=payment_methods&owner_id=<?= h($selected_owner_id) ?>&branch_id=<?= h($selected_branch_id) ?>&method=<?= h($selected_method) ?>&start_date=<?= h($start_date) ?>&end_date=<?= h($end_date) ?>&status=<?= h($status) ?>" 
                               class="btn btn-sm btn-outline-modern" title="Export to CSV">
                                <i class="fas fa-file-csv"></i> CSV
                            </a>
                            <a href="?export=json&report_type=payment_methods&owner_id=<?= h($selected_owner_id) ?>&branch_id=<?= h($selected_branch_id) ?>&method=<?= h($selected_method) ?>&start_date=<?= h($start_date) ?>&end_date=<?= h($end_date) ?>&status=<?= h($status) ?>" 
                               class="btn btn-sm btn-outline-modern" title="Export to JSON">
                                <i class="fas fa-file-code"></i> JSON
                            </a>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <div class="row">
                        <div class="col-md-6">
                            <div class="chart-container">
                                <canvas id="paymentChart"></canvas>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="table-responsive" style="max-height: 300px; overflow-y: auto;">
                                <table class="table table-modern">
                                    <thead>
                                        <tr>
                                            <th>Method</th>
                                            <th>Orders</th>
                                            <th>Amount</th>
                                            <th>Share</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php if (empty($payment_summary)): ?>
                                            <tr>
                                                <td colspan="4" class="text-center py-4">
                                                    <i class="fas fa-money-bill-wave fa-2x text-muted mb-3 d-block"></i>
                                                    <span class="text-muted">No payment data found</span>
                                                </td>
                                            </tr>
                                        <?php else: 
                                            foreach ($payment_summary as $method): 
                                                $percentage = $total_amount > 0 ? ($method['total_amount'] / $total_amount) * 100 : 0;
                                                $method_class = strtolower(str_replace(' ', '-', $method['payment_method']));
                                                $growth = $method['growth_percent'] ?? 0;
                                                $trend_class = $growth > 0 ? 'trend-up' : ($growth < 0 ? 'trend-down' : 'trend-neutral');
                                                $trend_icon = $growth > 0 ? 'fa-arrow-up' : ($growth < 0 ? 'fa-arrow-down' : 'fa-minus');
                                        ?>
                                        <tr>
                                            <td>
                                                <span class="method-badge method-<?= $method_class ?>">
                                                    <i class="fas fa-money-bill-wave"></i>
                                                    <?= h($method['payment_method']) ?>
                                                </span>
                                            </td>
                                            <td class="fw-semibold"><?= number_format($method['order_count']) ?></td>
                                            <td class="fw-bold text-dark">₹<?= number_format($method['total_amount'], 0) ?></td>
                                            <td>
                                                <div class="d-flex align-items-center gap-2">
                                                    <div class="progress-modern" style="width: 80px;">
                                                        <div class="progress-bar-modern" style="width: <?= $percentage ?>%"></div>
                                                    </div>
                                                    <div>
                                                        <div class="text-muted small"><?= number_format($percentage, 1) ?>%</div>
                                                        <div class="<?= $trend_class ?> small">
                                                            <i class="fas <?= $trend_icon ?>"></i>
                                                            <?= number_format(abs($growth), 1) ?>%
                                                        </div>
                                                    </div>
                                                </div>
                                            </td>
                                        </tr>
                                        <?php endforeach; endif; ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

<div class="card-modern mt-4 fade-in">
                <div class="card-header">
                    <h6 class="mb-0 fw-semibold">
                        <i class="fas fa-clock text-primary"></i>
                        Hourly Payment Trends
                    </h6>
                </div>
                <div class="card-body">
                    <div class="chart-container">
                        <canvas id="hourlyChart"></canvas>
                    </div>
                </div>
            </div>
        </div>
        
        
        <div class="col-lg-4">
            
            <div class="card-modern fade-in mb-4">
                <div class="card-header">
                    <h6 class="mb-0 fw-semibold">
                        <i class="fas fa-chart-line text-primary"></i>
                        Performance Metrics
                    </h6>
                </div>
                <div class="card-body">
                    <?php if (!empty($payment_summary)): 
                        $top_method = $payment_summary[0] ?? null;
                        $method_count = count($payment_summary);
                        $positive_growth = $negative_growth = $total_growth = 0;
                        
                        foreach ($payment_summary as $method) {
                            $growth = $method['growth_percent'] ?? 0;
                            $total_growth += $growth;
                            if ($growth > 0) $positive_growth++;
                            if ($growth < 0) $negative_growth++;
                        }
                    ?>
                    <div class="row g-3">
                        <div class="col-6">
                            <div class="p-3 border rounded text-center">
                                <div class="fw-bold text-primary"><?= number_format($top_method['order_count']) ?></div>
                                <div class="small text-muted">Most Orders</div>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="p-3 border rounded text-center">
                                <div class="fw-bold text-success">₹<?= number_format($top_method['avg_order_value'], 0) ?></div>
                                <div class="small text-muted">Highest Avg</div>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="p-3 border rounded text-center">
                                <div class="fw-bold text-info"><?= $method_count ?></div>
                                <div class="small text-muted">Methods Used</div>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="p-3 border rounded text-center">
                                <div class="fw-bold text-warning">
                                    <?= $total_taxable > 0 ? round(($total_gst / $total_taxable) * 100, 1) : '0' ?>%
                                </div>
                                <div class="small text-muted">Avg GST</div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="mt-4 pt-3 border-top">
                        <h6 class="fw-semibold mb-3">Growth Analysis</h6>
                        <div class="row text-center">
                            <div class="col-4">
                                <div class="text-success">
                                    <div class="h5 mb-0 fw-bold"><?= $positive_growth ?></div>
                                    <small class="text-muted">Growing</small>
                                </div>
                            </div>
                            <div class="col-4">
                                <div class="text-danger">
                                    <div class="h5 mb-0 fw-bold"><?= $negative_growth ?></div>
                                    <small class="text-muted">Declining</small>
                                </div>
                            </div>
                            <div class="col-4">
                                <div class="text-primary">
                                    <div class="h5 mb-0 fw-bold"><?= number_format($total_growth / max($method_count, 1), 1) ?>%</div>
                                    <small class="text-muted">Avg Growth</small>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php else: ?>
                    <div class="text-center py-4">
                        <i class="fas fa-chart-line fa-2x text-muted mb-3"></i>
                        <p class="text-muted small">No metrics available</p>
                    </div>
                    <?php endif; ?>
                </div>
            </div>

<div class="card-modern fade-in mb-4">
                <div class="card-header">
                    <h6 class="mb-0 fw-semibold">
                        <i class="fas fa-store text-primary"></i>
                        Branch Performance
                    </h6>
                </div>
                <div class="card-body">
                    <?php if (!empty($branch_breakdown)): 
                        $branch_totals = [];
                        foreach ($branch_breakdown as $branch_data) {
                            $branch_key = $branch_data['branch_name'];
                            if (!isset($branch_totals[$branch_key])) {
                                $branch_totals[$branch_key] = [
                                    'branch_name' => $branch_data['branch_name'],
                                    'total_amount' => 0,
                                    'order_count' => 0,
                                    'methods' => []
                                ];
                            }
                            $branch_totals[$branch_key]['total_amount'] += $branch_data['total_amount'];
                            $branch_totals[$branch_key]['order_count'] += $branch_data['order_count'];
                            $branch_totals[$branch_key]['methods'][] = $branch_data['payment_method'];
                        }
                        
                        uasort($branch_totals, function($a, $b) {
                            return $b['total_amount'] <=> $a['total_amount'];
                        });
                        
                        $display_count = 0;
                        foreach ($branch_totals as $branch_data):
                            if ($display_count >= 5) break;
                            $percentage = $total_amount > 0 ? ($branch_data['total_amount'] / $total_amount) * 100 : 0;
                            $method_count = count(array_unique($branch_data['methods']));
                    ?>
                    <div class="branch-card">
                        <div class="d-flex justify-content-between align-items-start mb-2">
                            <div>
                                <div class="fw-semibold"><?= h($branch_data['branch_name']) ?></div>
                                <div class="text-muted small">
                                    <?= number_format($branch_data['order_count']) ?> orders
                                </div>
                            </div>
                            <div class="text-end">
                                <div class="fw-bold">₹<?= number_format($branch_data['total_amount'], 0) ?></div>
                                <div class="text-primary small"><?= number_format($percentage, 1) ?>%</div>
                            </div>
                        </div>
                        <div class="progress-modern">
                            <div class="progress-bar-modern" style="width: <?= $percentage ?>%"></div>
                        </div>
                        <div class="text-muted small mt-2">
                            <i class="fas fa-credit-card"></i>
                            <?= $method_count ?> payment methods
                        </div>
                    </div>
                    <?php 
                        $display_count++;
                        endforeach; 
                    else: ?>
                    <div class="text-center py-4">
                        <i class="fas fa-store fa-2x text-muted mb-3"></i>
                        <p class="text-muted small">No branch data available</p>
                    </div>
                    <?php endif; ?>
                </div>
            </div>

<div class="card-modern fade-in">
                <div class="card-header">
                    <h6 class="mb-0 fw-semibold">
                        <i class="fas fa-download text-primary"></i>
                        Export Data
                    </h6>
                </div>
                <div class="card-body export-options">
                    <a href="?export=excel&report_type=payment_methods&owner_id=<?= h($selected_owner_id) ?>&branch_id=<?= h($selected_branch_id) ?>&method=<?= h($selected_method) ?>&start_date=<?= h($start_date) ?>&end_date=<?= h($end_date) ?>&status=<?= h($status) ?>" 
                       class="export-btn export-excel">
                        <i class="fas fa-file-excel fa-lg"></i>
                        <div>
                            <div class="fw-semibold">Export to Excel</div>
                            <div class="small text-muted">CSV Format</div>
                        </div>
                    </a>
                    
                    <a href="?export=json&report_type=payment_methods&owner_id=<?= h($selected_owner_id) ?>&branch_id=<?= h($selected_branch_id) ?>&method=<?= h($selected_method) ?>&start_date=<?= h($start_date) ?>&end_date=<?= h($end_date) ?>&status=<?= h($status) ?>" 
                       class="export-btn export-json">
                        <i class="fas fa-file-code fa-lg"></i>
                        <div>
                            <div class="fw-semibold">Export to JSON</div>
                            <div class="small text-muted">API Ready</div>
                        </div>
                    </a>
                    
                    <button onclick="window.print()" class="export-btn export-print">
                        <i class="fas fa-print fa-lg"></i>
                        <div>
                            <div class="fw-semibold">Print Report</div>
                            <div class="small text-muted">Printer Friendly</div>
                        </div>
                    </button>
                </div>
            </div>
        </div>
    </div>
</div>

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

<?php include './partials/layouts/layoutBottom.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: payments-reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation