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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: service-reports.php

<?php

include('includes/db.php');

// Check user role and permission
$user_role = isset($_SESSION['user_role']) ? $_SESSION['user_role'] : 'Sale';

// Normalize connection charset
mysqli_query($conn, "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");
mysqli_query($conn, "SET collation_connection = 'utf8mb4_unicode_ci'");

// Helper functions
function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }
function formatCurrency($amount) {
    return '₹' . number_format((float)$amount, 2);
}

// UTC to IST conversion
function utcToIst($utcDateTime, $format = 'M d, h:i A') {
    if (empty($utcDateTime)) return '';
    try {
        $utc = new DateTime($utcDateTime, new DateTimeZone('UTC'));
        $utc->setTimezone(new DateTimeZone('Asia/Kolkata'));
        return $utc->format($format);
    } catch (Exception $e) {
        return $utcDateTime;
    }
}

// Get filter parameters
$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');
$service_id = isset($_GET['service_id']) ? (int)$_GET['service_id'] : 0;
$technician = isset($_GET['technician']) ? mysqli_real_escape_string($conn, $_GET['technician']) : '';
$category_id = isset($_GET['category_id']) ? (int)$_GET['category_id'] : 0;

// Build WHERE clause for filters
$where_clause = "WHERE ss.service_date BETWEEN '{$start_date}' AND '{$end_date}'";
if ($service_id > 0) {
    $where_clause .= " AND ss.service_id = {$service_id}";
}
if (!empty($technician)) {
    $where_clause .= " AND i.technician LIKE '%{$technician}%'";
}
if ($category_id > 0) {
    $where_clause .= " AND s.category_id = {$category_id}";
}

// Get Service Statistics
$stats_query = "
    SELECT 
        COUNT(DISTINCT ss.id) as total_services,
        COUNT(DISTINCT ss.customer_id) as total_customers,
        SUM(ss.total_amount) as total_revenue,
        AVG(ss.total_amount) as avg_service_value,
        SUM(s.profit * ss.quantity) as total_profit
    FROM service_sales ss
    LEFT JOIN services s ON s.id = ss.service_id
    LEFT JOIN invoices i ON i.id = ss.invoice_id
    {$where_clause}
";

$stats_result = mysqli_query($conn, $stats_query);
$stats = mysqli_fetch_assoc($stats_result);

// Get today's service stats
$today = date('Y-m-d');
$today_stats_query = "
    SELECT 
        COUNT(DISTINCT ss.id) as today_services,
        SUM(ss.total_amount) as today_revenue
    FROM service_sales ss
    WHERE ss.service_date = '{$today}'
";

$today_stats_result = mysqli_query($conn, $today_stats_query);
$today_stats = mysqli_fetch_assoc($today_stats_result);

// Get Top Performing Services
$top_services_query = "
    SELECT 
        s.service_name,
        sc.category_name,
        COUNT(ss.id) as service_count,
        SUM(ss.total_amount) as total_revenue,
        AVG(ss.total_amount) as avg_revenue,
        s.selling_price,
        s.cost_price,
        s.profit
    FROM service_sales ss
    JOIN services s ON s.id = ss.service_id
    LEFT JOIN service_categories sc ON sc.id = s.category_id
    {$where_clause}
    GROUP BY ss.service_id
    ORDER BY total_revenue DESC
    LIMIT 10
";

$top_services_result = mysqli_query($conn, $top_services_query);

// Get Service Revenue by Date (for chart)
$revenue_by_date_query = "
    SELECT 
        DATE(ss.service_date) as service_day,
        COUNT(ss.id) as service_count,
        SUM(ss.total_amount) as daily_revenue
    FROM service_sales ss
    {$where_clause}
    GROUP BY DATE(ss.service_date)
    ORDER BY service_day
";

$revenue_by_date_result = mysqli_query($conn, $revenue_by_date_query);

// Prepare chart data
$chart_labels = [];
$chart_revenue = [];
$chart_count = [];

while ($row = mysqli_fetch_assoc($revenue_by_date_result)) {
    $chart_labels[] = date('M d', strtotime($row['service_day']));
    $chart_revenue[] = (float)$row['daily_revenue'];
    $chart_count[] = (int)$row['service_count'];
}

// Get All Services for dropdown
$services_query = "SELECT id, service_name FROM services WHERE status = 'active' ORDER BY service_name";
$services_result = mysqli_query($conn, $services_query);

// Get Service Categories for dropdown
$categories_query = "SELECT id, category_name FROM service_categories WHERE status = 'active' ORDER BY category_name";
$categories_result = mysqli_query($conn, $categories_query);

// Get Recent Service Sales
$recent_services_query = "
    SELECT 
        ss.*,
        s.service_name,
        sc.category_name,
        c.name as customer_name,
        c.phone as customer_phone,
        i.invoice_number,
        i.payment_method,
        i.created_at as invoice_date
    FROM service_sales ss
    JOIN services s ON s.id = ss.service_id
    LEFT JOIN service_categories sc ON sc.id = s.category_id
    LEFT JOIN customers c ON c.id = ss.customer_id
    LEFT JOIN invoices i ON i.id = ss.invoice_id
    {$where_clause}
    ORDER BY ss.service_date DESC, ss.created_at DESC
    LIMIT 15
";

$recent_services_result = mysqli_query($conn, $recent_services_query);

// Get Technician Performance
$technician_query = "
    SELECT 
        COALESCE(i.technician, 'Not Assigned') as technician_name,
        COUNT(DISTINCT ss.id) as total_services,
        SUM(ss.total_amount) as total_revenue,
        AVG(ss.total_amount) as avg_service_value
    FROM service_sales ss
    LEFT JOIN invoices i ON i.id = ss.invoice_id
    WHERE ss.service_date BETWEEN '{$start_date}' AND '{$end_date}'
    GROUP BY COALESCE(i.technician, 'Not Assigned')
    ORDER BY total_revenue DESC
    LIMIT 5
";

$technician_result = mysqli_query($conn, $technician_query);

// Get current IST time for display
function getCurrentIstTime() {
    $utc = new DateTime('now', new DateTimeZone('UTC'));
    $utc->setTimezone(new DateTimeZone('Asia/Kolkata'));
    return $utc->format('h:i:s A');
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include('includes/head.php'); ?>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.4.0/css/all.min.css">
    <style>
        .card-value { font-size: 1.5rem; font-weight: 600; margin-bottom: 0; }
        .card-label { font-size: 0.875rem; color: #fff; margin-bottom: 0.5rem; opacity: 0.9; }
        .kpi-card { transition: transform 0.2s; border-radius: 10px; border: none; color: white; }
        .kpi-card:hover { transform: translateY(-3px); box-shadow: 0 4px 15px rgba(0,0,0,0.2); }
        .stats-icon { font-size: 2rem; opacity: 0.8; }
        .time-indicator { font-size: 0.75rem; color: #6c757d; }
        .ist-badge { background: #ff6b6b; color: white; padding: 2px 6px; border-radius: 4px; font-size: 0.7rem; }
        .table th { background-color: #f8f9fa; font-weight: 600; }
        .chart-container {
            position: relative;
            height: 300px;
            width: 100%;
        }
        .filter-card {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
        }
        .badge-service {
            background-color: #007bff;
            color: white;
        }
        .profit-positive {
            color: #28a745;
            font-weight: 600;
        }
        .profit-negative {
            color: #dc3545;
            font-weight: 600;
        }
        .service-row:hover {
            background-color: #f8f9fa;
            cursor: pointer;
        }
        #serviceRevenueChart {
            height: 320px !important;
            max-height: 320px !important;
            width: 100% !important;
            display: block;
        }
        .page-title {
            color: #495057;
            font-weight: 600;
            margin-bottom: 1.5rem;
        }
        .filter-btn {
            border-radius: 8px;
            font-weight: 500;
        }
    </style>
</head>
<body data-sidebar="dark">

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

<?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-flex align-items-center justify-content-between">
                            <h4 class="mb-0 page-title">Service Reports & Analytics</h4>
                            <div class="page-title-right">
                                <span class="ist-badge me-2">
                                    <i class="fas fa-clock me-1"></i>
                                    <span id="current-time"><?php echo getCurrentIstTime(); ?></span>
                                </span>
                                <span class="time-indicator">IST</span>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-12">
                        <div class="card filter-card">
                            <div class="card-body">
                                <h5 class="card-title text-white mb-3"><i class="fas fa-filter me-2"></i>Filter Services</h5>
                                <form method="GET" action="" class="row g-3">
                                    <div class="col-md-2">
                                        <label class="form-label text-white">Start Date</label>
                                        <input type="date" class="form-control" name="start_date" 
                                               value="<?php echo h($start_date); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label text-white">End Date</label>
                                        <input type="date" class="form-control" name="end_date" 
                                               value="<?php echo h($end_date); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label text-white">Service</label>
                                        <select class="form-control" name="service_id">
                                            <option value="0">All Services</option>
                                            <?php while($service = mysqli_fetch_assoc($services_result)): ?>
                                                <option value="<?php echo $service['id']; ?>"
                                                    <?php echo $service_id == $service['id'] ? 'selected' : ''; ?>>
                                                    <?php echo h($service['service_name']); ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label text-white">Category</label>
                                        <select class="form-control" name="category_id">
                                            <option value="0">All Categories</option>
                                            <?php 
                                            mysqli_data_seek($categories_result, 0);
                                            while($cat = mysqli_fetch_assoc($categories_result)): ?>
                                                <option value="<?php echo $cat['id']; ?>"
                                                    <?php echo $category_id == $cat['id'] ? 'selected' : ''; ?>>
                                                    <?php echo h($cat['category_name']); ?>
                                                </option>
                                            <?php endwhile; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label text-white">Technician</label>
                                        <input type="text" class="form-control" name="technician" 
                                               value="<?php echo h($technician); ?>" placeholder="Technician name">
                                    </div>
                                    <div class="col-md-2 d-flex align-items-end">
                                        <div class="d-flex gap-2">
                                            <button type="submit" class="btn btn-light filter-btn">
                                                <i class="fas fa-filter me-1"></i> Apply
                                            </button>
                                            <a href="service-reports.php" class="btn btn-outline-light filter-btn">
                                                <i class="fas fa-redo me-1"></i> Reset
                                            </a>
                                        </div>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-xl-3 col-md-6">
                        <div class="card kpi-card bg-primary">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            <?php echo number_format($stats['total_services'] ?? 0); ?>
                                        </h4>
                                        <p class="card-label">Total Services</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-tools stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card kpi-card bg-success">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            ₹<?php echo number_format($stats['total_revenue'] ?? 0, 2); ?>
                                        </h4>
                                        <p class="card-label">Total Revenue</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-rupee-sign stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card kpi-card bg-info">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            <?php echo number_format($stats['total_customers'] ?? 0); ?>
                                        </h4>
                                        <p class="card-label">Customers Served</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-users stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <div class="card kpi-card bg-warning">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            ₹<?php echo number_format($today_stats['today_revenue'] ?? 0, 2); ?>
                                        </h4>
                                        <p class="card-label">Today's Revenue</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-calendar-day stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-xl-4 col-md-6">
                        <div class="card kpi-card bg-secondary">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            ₹<?php echo number_format($stats['avg_service_value'] ?? 0, 2); ?>
                                        </h4>
                                        <p class="card-label">Avg. Service Value</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-chart-line stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-4 col-md-6">
                        <div class="card kpi-card bg-danger">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value">
                                            <?php echo number_format($today_stats['today_services'] ?? 0); ?>
                                        </h4>
                                        <p class="card-label">Today's Services</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-tasks stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-4 col-md-6">
                        <div class="card kpi-card bg-dark">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="card-value profit-positive">
                                            ₹<?php echo number_format($stats['total_profit'] ?? 0, 2); ?>
                                        </h4>
                                        <p class="card-label">Total Profit</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="fas fa-money-bill-wave stats-icon"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title mb-0">Service Revenue Trend</h4>
                                    <div class="btn-group">
                                        <button type="button" class="btn btn-sm btn-outline-primary active" data-period="7d">7 Days</button>
                                        <button type="button" class="btn btn-sm btn-outline-primary" data-period="30d">30 Days</button>
                                        <button type="button" class="btn btn-sm btn-outline-primary" data-period="90d">90 Days</button>
                                    </div>
                                </div>
                                <canvas id="serviceRevenueChart"></canvas>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-4">
                    
                    <div class="col-xl-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title mb-0">Top Performing Services</h4>
                                    <a href="add-service.php" class="btn btn-sm btn-outline-primary">
                                        <i class="fas fa-plus me-1"></i> Add Service
                                    </a>
                                </div>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Service</th>
                                                <th>Category</th>
                                                <th class="text-end">Count</th>
                                                <th class="text-end">Revenue</th>
                                                <th class="text-end">Avg. Price</th>
                                                <th class="text-end">Profit</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            mysqli_data_seek($top_services_result, 0);
                                            $counter = 1;
                                            while($service = mysqli_fetch_assoc($top_services_result)): 
                                                $profit_per_item = $service['profit'] ?? ($service['selling_price'] - $service['cost_price']);
                                                $total_profit = $profit_per_item * $service['service_count'];
                                                $profit_class = $total_profit >= 0 ? 'profit-positive' : 'profit-negative';
                                            ?>
                                            <tr class="service-row" onclick="viewServiceDetails(<?php echo $service_id; ?>)">
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <span class="badge bg-primary me-2"><?php echo $counter++; ?></span>
                                                        <div>
                                                            <h6 class="mb-0"><?php echo h($service['service_name']); ?></h6>
                                                            <small class="text-muted">₹<?php echo number_format($service['selling_price'], 2); ?> per service</small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-secondary"><?php echo h($service['category_name'] ?? 'N/A'); ?></span>
                                                </td>
                                                <td class="text-end">
                                                    <span class="badge bg-info"><?php echo $service['service_count']; ?></span>
                                                </td>
                                                <td class="text-end">
                                                    <strong>₹<?php echo number_format($service['total_revenue'], 2); ?></strong>
                                                </td>
                                                <td class="text-end">
                                                    ₹<?php echo number_format($service['avg_revenue'], 2); ?>
                                                </td>
                                                <td class="text-end <?php echo $profit_class; ?>">
                                                    ₹<?php echo number_format($total_profit, 2); ?>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-xl-4">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-3">Top Technicians</h4>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Technician</th>
                                                <th class="text-end">Services</th>
                                                <th class="text-end">Revenue</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            $tech_counter = 1;
                                            mysqli_data_seek($technician_result, 0);
                                            while($tech = mysqli_fetch_assoc($technician_result)): 
                                            ?>
                                            <tr>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <span class="badge bg-warning me-2"><?php echo $tech_counter++; ?></span>
                                                        <div>
                                                            <h6 class="mb-0"><?php echo h($tech['technician_name']); ?></h6>
                                                            <small class="text-muted">₹<?php echo number_format($tech['avg_service_value'], 2); ?> avg.</small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td class="text-end">
                                                    <span class="badge bg-primary"><?php echo $tech['total_services']; ?></span>
                                                </td>
                                                <td class="text-end">
                                                    <strong>₹<?php echo number_format($tech['total_revenue'], 2); ?></strong>
                                                </td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title mb-0">Recent Service Sales</h4>
                                    <a href="sales.php?type=service" class="btn btn-sm btn-outline-primary">
                                        <i class="fas fa-external-link-alt me-1"></i> View All Sales
                                    </a>
                                </div>
                                <div class="table-responsive">
                                    <table class="table table-hover align-middle mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Date</th>
                                                <th>Customer</th>
                                                <th>Service</th>
                                                <th>Category</th>
                                                <th class="text-end">Amount</th>
                                                <th>Technician</th>
                                                <th>Payment</th>
                                                <th>Invoice</th>
                                                <th>Status</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            $recent_counter = 1;
                                            while($sale = mysqli_fetch_assoc($recent_services_result)): 
                                                $payment_badge = $sale['payment_method'] == 'cash' ? 'success' : 'primary';
                                            ?>
                                            <tr>
                                                <td>
                                                    <div class="small"><?php echo utcToIst($sale['service_date'], 'M d'); ?></div>
                                                    <div class="text-muted smaller"><?php echo utcToIst($sale['invoice_date']); ?></div>
                                                </td>
                                                <td>
                                                    <div><?php echo h($sale['customer_name'] ?: 'Walk-in'); ?></div>
                                                    <?php if($sale['customer_phone']): ?>
                                                        <small class="text-muted"><?php echo h($sale['customer_phone']); ?></small>
                                                    <?php endif; ?>
                                                </td>
                                                <td><?php echo h($sale['service_name']); ?></td>
                                                <td>
                                                    <span class="badge bg-secondary">
                                                        <?php echo h($sale['category_name'] ?? 'N/A'); ?>
                                                    </span>
                                                </td>
                                                <td class="text-end">
                                                    <strong>₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                                </td>
                                                <td>
                                                    <?php if($sale['technician_name'] && $sale['technician_name'] != 'Not Assigned'): ?>
                                                        <span class="badge bg-info"><?php echo h($sale['technician_name']); ?></span>
                                                    <?php else: ?>
                                                        <span class="badge bg-secondary">Not Assigned</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php echo $payment_badge; ?>">
                                                        <?php echo strtoupper($sale['payment_method'] ?? 'N/A'); ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <?php if($sale['invoice_number']): ?>
                                                        <a href="view-invoice.php?id=<?php echo $sale['invoice_id']; ?>" 
                                                           class="btn btn-sm btn-outline-primary">
                                                            <i class="fas fa-file-invoice me-1"></i>
                                                            <?php echo substr(h($sale['invoice_number']), 0, 10); ?>...
                                                        </a>
                                                    <?php else: ?>
                                                        <span class="text-muted">No Invoice</span>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-success">
                                                        <i class="fas fa-check-circle me-1"></i> Completed
                                                    </span>
                                                </td>
                                            </tr>
                                            <?php 
                                            $recent_counter++;
                                            endwhile; 
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php'); ?>
    </div>
</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

<script>
(function ensureChartJs(cb){
  if (window.Chart) return cb();
  var s=document.createElement('script');
  s.src="https://cdn.jsdelivr.net/npm/chart.js@4.4.5/dist/chart.umd.min.js";
  s.onload=cb;
  document.head.appendChild(s);
})(function(){ /* ready */ });
</script>

// Update time every second
setInterval(updateCurrentTime, 1000);
updateCurrentTime(); // Initial call

// Initialize Chart
let serviceRevenueChart = null;

function initializeChart(labels, revenueData, countData) {
    const el = document.getElementById('serviceRevenueChart');
    if (!el || !window.Chart) return;
    
    const ctx = el.getContext('2d');
    if (serviceRevenueChart) serviceRevenueChart.destroy();

serviceRevenueChart = new Chart(ctx, {
        type: 'line',
        data: {
            labels: labels,
            datasets: [
                {
                    label: 'Revenue (₹)',
                    data: revenueData,
                    backgroundColor: 'rgba(54, 162, 235, 0.1)',
                    borderColor: 'rgba(54, 162, 235, 1)',
                    borderWidth: 2,
                    tension: 0.3,
                    fill: true,
                    yAxisID: 'y'
                },
                {
                    label: 'Service Count',
                    data: countData,
                    backgroundColor: 'rgba(75, 192, 192, 0.1)',
                    borderColor: 'rgba(75, 192, 192, 1)',
                    borderWidth: 2,
                    tension: 0.3,
                    fill: true,
                    yAxisID: 'y1'
                }
            ]
        },
        options: {
            responsive: true,
            maintainAspectRatio: false,
            interaction: {
                mode: 'index',
                intersect: false,
            },
            scales: {
                x: { 
                    grid: { display: false },
                    ticks: { maxRotation: 0 }
                },
                y: {
                    type: 'linear',
                    display: true,
                    position: 'left',
                    title: {
                        display: true,
                        text: 'Revenue (₹)'
                    },
                    ticks: { 
                        callback: (v) => '₹' + Number(v).toLocaleString(),
                        maxTicksLimit: 6
                    }
                },
                y1: {
                    type: 'linear',
                    display: true,
                    position: 'right',
                    title: {
                        display: true,
                        text: 'Service Count'
                    },
                    grid: {
                        drawOnChartArea: false
                    }
                }
            },
            plugins: {
                tooltip: {
                    callbacks: {
                        label: function(context) {
                            let label = context.dataset.label || '';
                            if (label.includes('Revenue')) {
                                return label + ': ₹' + Number(context.parsed.y).toLocaleString();
                            } else {
                                return label + ': ' + Number(context.parsed.y);
                            }
                        }
                    }
                }
            }
        }
    });
}

// Initialize chart with data from PHP
const chartData = {
    labels: <?php echo json_encode($chart_labels, JSON_UNESCAPED_UNICODE); ?>,
    revenue: <?php echo json_encode($chart_revenue); ?>,
    count: <?php echo json_encode($chart_count); ?>
};

(function waitChart(){
    if (!window.Chart) return setTimeout(waitChart, 100);
    initializeChart(chartData.labels, chartData.revenue, chartData.count);
})();

// Period filter buttons
document.querySelectorAll('[data-period]').forEach(button => {
    button.addEventListener('click', function() {
        // Remove active class from all buttons
        document.querySelectorAll('[data-period]').forEach(btn => {
            btn.classList.remove('active');
        });
        // Add active class to clicked button
        this.classList.add('active');
        
        const period = this.getAttribute('data-period');
        // Here you would typically fetch new data based on period
        // For now, we'll just show an alert
        alert('Filter by ' + period + ' would be implemented here');
    });
});

// View Service Details function
function viewServiceDetails(serviceId) {
    if (serviceId) {
        window.location.href = 'service-management.php?action=view&id=' + serviceId;
    }
}

// Auto-refresh dashboard every 60 seconds
setTimeout(function() {
    window.location.reload();
}, 60000);
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: service-reports.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation