@extends('superadmin::layouts.master')
@section('title', trans('superadmin::internal_tools.tenant_metrics.title'))
@section('breadcrumb')
    <link href="{{ asset('assets/css/style-svgFont.css') }}" rel="stylesheet">
    <div class="row breadcrumbs-top">
        <div class="breadcrumb-wrapper col-xs-12">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="{{ route('internal-tools.index') }}">@lang('superadmin::internal_tools.internal_tools')</a></li>
                <li class="breadcrumb-item active"><a href="#">@lang('superadmin::internal_tools.tenant_metrics.title')</a></li>
            </ol>
        </div>
    </div>
@endsection
@section('content')
<section class="container-fluid">
    <div class="row">
        <div class="col-lg-12">
            <div class="card p-2">
                <div class="card-header d-flex justify-content-between align-items-center" style="display: flex; justify-content: space-between; align-items: center; flex-wrap: wrap;">
                    <div>
                        <h2 class="card-title">@lang('superadmin::internal_tools.tenant_metrics.title')</h2>
                        <p class="text-muted" style="font-size: 14px; margin-bottom: 0;">Live data overview of all tenants calculated via stored procedure.</p>
                    </div>
                    <div id="export_buttons">
                        <!-- Excel Button will be moved here by JS -->
                    </div>
                </div>
                <div class="card-body collapse in">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped custom-table" id="tenantMetricsTable">
                            <thead>
                                <tr>
                                    <!-- Company identity -->
                                    <th class="bg-light" title="Name and ID of the company">@lang('superadmin::internal_tools.tenant_metrics.table.company')</th>
                                    <th class="bg-light" title="Database name for the tenant">@lang('superadmin::internal_tools.tenant_metrics.table.tenant_db')</th>
                                    
                                    <!-- Integrations -->
                                    <th class="bg-success text-white" title="Active Third-Party Integrations enabled by the tenant">@lang('superadmin::internal_tools.tenant_metrics.table.integrations')</th>

                                    <!-- Usage Metrics -->
                                    <th class="bg-primary text-white" title="Total number of created customers">@lang('superadmin::internal_tools.tenant_metrics.table.customers')</th>
                                    <th class="bg-primary text-white" title="Total number of quotations sent">@lang('superadmin::internal_tools.tenant_metrics.table.quotations')</th>
                                    <th class="bg-primary text-white" title="Total number of proforma invoices">@lang('superadmin::internal_tools.tenant_metrics.table.proforma')</th>
                                    <th class="bg-primary text-white" title="Total number of created tax/simplified invoices">@lang('superadmin::internal_tools.tenant_metrics.table.bills')</th>
                                    <th class="bg-primary text-white" title="Total number of credit notes created">@lang('superadmin::internal_tools.tenant_metrics.table.credit_notes')</th>
                                    <th class="bg-primary text-white" title="Total number of debit notes created">@lang('superadmin::internal_tools.tenant_metrics.table.debit_notes')</th>
                                    <th class="bg-primary text-white" title="Total number of customer receipts">@lang('superadmin::internal_tools.tenant_metrics.table.receipts')</th>
                                    <th class="bg-primary text-white" title="Total number of created suppliers">@lang('superadmin::internal_tools.tenant_metrics.table.suppliers')</th>
                                    <th class="bg-primary text-white" title="Total number of bill returns">@lang('superadmin::internal_tools.tenant_metrics.table.bill_returns')</th>
                                    <th class="bg-primary text-white" title="Total number of purchase bills">@lang('superadmin::internal_tools.tenant_metrics.table.purchase_bills')</th>
                                    <th class="bg-primary text-white" title="Total number of journal entries">@lang('superadmin::internal_tools.tenant_metrics.table.journal_entries')</th>
                                    <th class="bg-primary text-white" title="Total number of accounting accounts">@lang('superadmin::internal_tools.tenant_metrics.table.accounts')</th>
                                    <th class="bg-primary text-white" title="Total number of managed assets">@lang('superadmin::internal_tools.tenant_metrics.table.assets')</th>
                                    <th class="bg-primary text-white" title="Total number of products in inventory">@lang('superadmin::internal_tools.tenant_metrics.table.products')</th>
                                    <th class="bg-primary text-white" title="Total number of user roles created">@lang('superadmin::internal_tools.tenant_metrics.table.roles')</th>

                                    <!-- User Activity -->
                                    <th class="bg-warning text-dark" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.days_inactive')</th>
                                    <th class="bg-warning text-dark" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.sign_ins')</th>
                                    <th class="bg-warning text-dark" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.users')</th>
                                    <th class="bg-warning text-dark" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.session_time')</th>
                                    <th class="bg-warning text-dark" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.max_activity')</th>

                                    <!-- Subscription -->
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.plan')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.is_paid')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.renew_date')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.sub_count')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.sub_days')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.first_sub')</th>
                                    <th class="bg-info text-white" title="...">@lang('superadmin::internal_tools.tenant_metrics.table.max_renew')</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($metrics as $row)
                                <tr>
                                    <!-- Company Identity -->
                                    <td class="font-weight-bold" style="min-width: 250px;">
                                        {{ $row->company_name }} <br>
                                        <small class="text-muted">ID: {{ $row->company_id }}</small>
                                    </td>
                                    <td><code class="text-muted" style="font-size: 85%;">{{ $row->tenant_db }}</code></td>

                                    <!-- Integrations -->
                                    <td class="text-left" style="min-width: 150px;">
                                        @if(!empty($row->active_integrations))
                                            @foreach(explode(',', $row->active_integrations) as $integration)
                                                <span class="badge badge-primary" style="margin-bottom: 2px;">{{ trim($integration) }}</span>
                                            @endforeach
                                        @else
                                            <span class="text-muted"><small>None</small></span>
                                        @endif
                                    </td>

                                    <!-- Usage Metrics -->
                                    <td class="text-center font-weight-bold">{{ number_format($row->customers) }}</td>
                                    <td class="text-center">{{ number_format($row->quotations) }}</td>
                                    <td class="text-center">{{ number_format($row->proforma_invoices) }}</td>
                                    <td class="text-center font-weight-bold">{{ number_format($row->bills) }}</td>
                                    <td class="text-center">{{ number_format($row->credit_notes) }}</td>
                                    <td class="text-center">{{ number_format($row->debit_notes) }}</td>
                                    <td class="text-center">{{ number_format($row->customer_receipts) }}</td>
                                    <td class="text-center">{{ number_format($row->suppliers) }}</td>
                                    <td class="text-center">{{ number_format($row->bill_returns) }}</td>
                                    <td class="text-center">{{ number_format($row->purchase_bills) }}</td>
                                    <td class="text-center">{{ number_format($row->journal_entries) }}</td>
                                    <td class="text-center">{{ number_format($row->accounts) }}</td>
                                    <td class="text-center">{{ number_format($row->assets) }}</td>
                                    <td class="text-center font-weight-bold">{{ number_format($row->products) }}</td>
                                    <td class="text-center">{{ number_format($row->roles) }}</td>
                                    
                                    <!-- User Activity -->
                                    <td class="font-weight-bold text-center {{ $row->days_inactive_before_sub_end > 30 ? 'text-danger' : '' }} {{ $row->days_inactive_before_sub_end === 0 ? 'text-success' : '' }}">
                                        @if($row->days_inactive_before_sub_end === null)
                                            -
                                        @else
                                            {{ $row->days_inactive_before_sub_end }}
                                        @endif
                                    </td>
                                    <td class="text-center">{{ number_format($row->sign_in_count) }}</td>
                                    <td class="text-center font-weight-bold">{{ number_format($row->user_count) }}</td>
                                    <td class="text-nowrap"><small>{{ $row->total_session_duration }}</small></td>
                                    <td class="text-nowrap">{{ $row->max_activity_date ? \Carbon\Carbon::parse($row->max_activity_date)->format('Y-m-d H:i') : '-' }}</td>

                                    <!-- Subscription -->
                                    <td>
                                        <span class="badge {{ $row->is_paid ? 'badge-primary' : 'badge-secondary' }}">{{ $row->subscription_plan ?: 'Free/Trial' }}</span>
                                    </td>
                                    <td class="text-center">
                                        @if($row->is_paid) <i class="fa fa-check-circle text-success" title="Paid"></i> @else <i class="fa fa-times-circle text-muted" title="Not Paid"></i> @endif
                                    </td>
                                    <td class="text-nowrap">{{ $row->renewal_date ?: '-' }}</td>
                                    <td class="text-center">{{ number_format($row->subscription_count) }}</td>
                                    <td class="text-center">{{ number_format($row->subscription_days) }}</td>
                                    <td class="text-nowrap">{{ $row->first_subscription_date ?: '-' }}</td>
                                    <td class="text-nowrap">{{ $row->max_renewal_date ?: '-' }}</td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
@endsection
@section('extra_styles')
    <!-- Datatables Export CSS -->
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.4.1/css/buttons.dataTables.min.css">
@endsection

@section('extra_scripts')
    <!-- Datatables Export Plugins -->
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/dataTables.buttons.min.js" defer></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.10.1/jszip.min.js" defer></script>
    <script src="https://cdn.datatables.net/buttons/2.4.1/js/buttons.html5.min.js" defer></script>

    <script>
        window.addEventListener('DOMContentLoaded', function () {
            if (typeof $.fn.DataTable !== 'undefined') {
                $('#tenantMetricsTable').DataTable({
                    "pageLength": 50,
                    // Days Inactive is column index 18
                    "order": [[ 18, "desc" ]],
                    "scrollX": true,
                    // Add DOM geometry for buttons + Excel button config
                    "dom": 'lBfrtip',
                    "buttons": [
                        {
                            extend: 'excelHtml5',
                            text: '<i class="fa fa-file-excel-o"></i> Export to Excel',
                            className: 'btn btn-success',
                            title: 'Tenant Usage Metrics ' + new Date().toISOString().split('T')[0]
                        }
                    ]
                });
            }
        });
    </script>
@endsection