@extends('layouts.app')
@section('title', __('lang_v1.expiry_analytics'))

@section('content')
<section class="content-header">
    <h1><i class="fa fa-chart-line"></i> @lang('lang_v1.expiry_analytics')
        <small>@lang('lang_v1.expiry_analytics_desc')</small>
    </h1>
</section>

<section class="content">
    @include('layouts.partials.error')

    {{-- Scope. Every figure and chart below obeys these three, so the board can be
         read for the whole chain, one state, one tier, or one site. --}}
    <div class="box box-solid">
        <div class="box-body">
            {!! Form::open(['route' => 'expiry-analytics.index', 'method' => 'get', 'class' => 'form-inline']) !!}
                <div class="form-group">
                    {!! Form::label('tier', __('lang_v1.scope') . ':') !!}
                    {!! Form::select('tier', ['' => __('lang_v1.entire_chain'), 'store' => __('lang_v1.all_stores'), 'warehouse' => __('lang_v1.all_warehouses')],
                        $filters['tier'] ?? null, ['class' => 'form-control']) !!}
                </div>
                <div class="form-group" style="margin-left:10px;">
                    {!! Form::label('state', __('business.state') . ':') !!}
                    {!! Form::select('state', ['' => __('lang_v1.all_states')] + $states->mapWithKeys(fn($s) => [$s => $s])->all(),
                        $filters['state'] ?? null, ['class' => 'form-control']) !!}
                </div>
                <div class="form-group" style="margin-left:10px;">
                    {!! Form::label('business_id', __('lang_v1.site') . ':') !!}
                    {!! Form::select('business_id', ['' => __('lang_v1.all_sites')] + $businesses->all(),
                        $filters['business_id'] ?? null, ['class' => 'form-control select2', 'style' => 'width:220px;']) !!}
                </div>
                <button type="submit" class="btn btn-primary" style="margin-left:10px;">
                    <i class="fa fa-filter"></i> @lang('messages.filter')
                </button>
                <a href="{{ route('expiry-analytics.index') }}" class="btn btn-default">@lang('lang_v1.reset')</a>
            {!! Form::close() !!}
        </div>
    </div>

    {{-- Sunk loss vs recoverable exposure vs already destroyed. Kept as three
         separate numbers on purpose: adding them together would be meaningless. --}}
    <div class="row">
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-maroon">
                <span class="info-box-icon"><i class="fa fa-times-circle"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">@lang('lang_v1.expired_value_at_cost')</span>
                    <span class="info-box-number">@format_currency($totals['value_at_cost'])</span>
                    <span class="progress-description">
                        {{ @num_format($totals['units']) }} @lang('lang_v1.units') &middot;
                        {{ $totals['batches'] }} @lang('lang_v1.batches') &middot;
                        {{ $totals['sites'] }} @lang('lang_v1.sites')
                    </span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-orange">
                <span class="info-box-icon"><i class="fa fa-hourglass-half"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">@lang('lang_v1.at_risk_90_days')</span>
                    <span class="info-box-number">@format_currency($upcoming[90]['value_at_cost'])</span>
                    <span class="progress-description">{{ $upcoming[90]['batches'] }} @lang('lang_v1.batches') &mdash; @lang('lang_v1.still_recoverable')</span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-navy">
                <span class="info-box-icon"><i class="fa fa-fire"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">@lang('lang_v1.destroyed_to_date')</span>
                    <span class="info-box-number">@format_currency($disposed['value'])</span>
                    <span class="progress-description">
                        {{ $disposed['records'] }} @lang('lang_v1.disposal_records_short') &middot;
                        {{ @num_format($disposed['units']) }} @lang('lang_v1.units')
                    </span>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="info-box bg-aqua">
                <span class="info-box-icon"><i class="fa fa-truck"></i></span>
                <div class="info-box-content">
                    <span class="info-box-text">@lang('lang_v1.in_the_pipeline')</span>
                    <span class="info-box-number">{{ $in_transit + $awaiting_disposal }}</span>
                    <span class="progress-description">
                        {{ $in_transit }} @lang('lang_v1.in_transit') &middot;
                        {{ $awaiting_disposal }} @lang('lang_v1.awaiting_destruction')
                    </span>
                </div>
            </div>
        </div>
    </div>

    {{-- What to do about it, in words. A wall of charts still leaves the reader to
         work out the action; these are generated only where the data supports them. --}}
    @if(!empty($insights))
        @component('components.widget', ['class' => 'box-solid', 'title' => __('lang_v1.what_this_means')])
            @foreach($insights as $i)
                @php
                    $cls = ['high' => 'alert-danger', 'medium' => 'alert-warning', 'info' => 'alert-info'][$i['severity']] ?? 'alert-info';
                    $icon = ['high' => 'fa-exclamation-circle', 'medium' => 'fa-exclamation-triangle', 'info' => 'fa-info-circle'][$i['severity']] ?? 'fa-info-circle';
                @endphp
                <div class="alert {{ $cls }}" style="margin-bottom:8px;">
                    <i class="fa {{ $icon }}"></i> {{ $i['text'] }}
                </div>
            @endforeach
        @endcomponent
    @endif

    <div class="row">
        <div class="col-md-6"><div class="box box-solid"><div class="box-body">@if($chart_has_data['ageing']){!! $charts['ageing']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif</div></div></div>
        <div class="col-md-6"><div class="box box-solid"><div class="box-body">@if($chart_has_data['pipeline']){!! $charts['pipeline']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif</div></div></div>
    </div>

    <div class="row">
        <div class="col-md-6">
            <div class="box box-solid"><div class="box-body">
                @if($chart_has_data['trend']){!! $charts['trend']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif
                @unless($trend['sufficient'])
                    {{-- Never let a two-point line imply a trend. --}}
                    <p class="text-muted" style="margin-top:-8px;">
                        <i class="fa fa-info-circle"></i>
                        @lang('lang_v1.insufficient_trend_note', ['months' => $trend['months_of_data']])
                    </p>
                @endunless
            </div></div>
        </div>
        <div class="col-md-6">
            <div class="box box-solid"><div class="box-body">
                @if($chart_has_data['seasonality']){!! $charts['seasonality']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif
                <p class="text-muted" style="margin-top:-8px;">
                    <i class="fa fa-info-circle"></i>
                    @lang('lang_v1.seasonality_note')
                    @unless($seasonality['sufficient'])
                        @lang('lang_v1.seasonality_insufficient', ['years' => $seasonality['years_of_data']])
                    @endunless
                </p>
            </div></div>
        </div>
    </div>

    @if(!empty($seasonality['top_products']))
        @component('components.widget', ['class' => 'box-solid', 'title' => __('lang_v1.worst_product_per_month')])
            <div class="table-responsive">
                <table class="table table-bordered table-condensed">
                    <thead><tr>
                        <th>@lang('lang_v1.month')</th>
                        <th>@lang('lang_v1.product_with_most_expiry')</th>
                        <th class="text-right">@lang('lang_v1.value_at_cost')</th>
                    </tr></thead>
                    <tbody>
                        @foreach($seasonality['top_products'] as $tp)
                            <tr>
                                <td>{{ $tp['label'] }}</td>
                                <td>{{ $tp['product_name'] }}</td>
                                <td class="text-right">@format_currency($tp['value'])</td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
            <p class="help-block">@lang('lang_v1.worst_product_per_month_help')</p>
        @endcomponent
    @endif

    <div class="row">
        <div class="col-md-5"><div class="box box-solid"><div class="box-body">@if($chart_has_data['state']){!! $charts['state']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif</div></div></div>
        <div class="col-md-7"><div class="box box-solid"><div class="box-body">@if($chart_has_data['product']){!! $charts['product']->container() !!}@else<div class="text-center text-muted" style="padding:60px 10px;"><i class="fa fa-chart-bar fa-2x" style="opacity:.25;"></i><p style="margin-top:10px;">@lang('lang_v1.chart_no_data')</p></div>@endif</div></div></div>
    </div>

    {{-- EXPIRY RATIO: the diagnostic figure. Absolute loss just ranks the big
         sellers; a ratio says which products are being bought wrongly. --}}
    @component('components.widget', ['class' => 'box-primary', 'title' => __('lang_v1.expiry_ratio_by_product')])
        <p class="help-block">@lang('lang_v1.expiry_ratio_help')</p>
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="ratio_table" style="width:100%;">
                <thead><tr>
                    <th>@lang('business.product')</th>
                    <th>@lang('lang_v1.schedule')</th>
                    <th class="text-right">@lang('lang_v1.units_received')</th>
                    <th class="text-right">@lang('lang_v1.units_wasted')</th>
                    <th class="text-right">@lang('lang_v1.expiry_ratio')</th>
                    <th class="text-right">@lang('lang_v1.value_at_cost')</th>
                    <th class="not-export">@lang('messages.action')</th>
                </tr></thead>
                <tbody>
                    @foreach($ratios as $r)
                        <tr>
                            <td>{{ $r->product_name }}</td>
                            <td>{{ $r->drug_schedule ?: '--' }}</td>
                            <td class="text-right">{{ @num_format($r->received_units) }}</td>
                            <td class="text-right">{{ @num_format($r->total_wasted_units) }}</td>
                            <td class="text-right" data-order="{{ $r->ratio }}">
                                <strong class="{{ $r->ratio >= 25 ? 'text-red' : ($r->ratio >= 10 ? 'text-orange' : '') }}">
                                    {{ $r->ratio }}%
                                </strong>
                            </td>
                            <td class="text-right">@format_currency($r->total_wasted_value)</td>
                            <td>
                                <a href="{{ route('expiry-analytics.batches', array_merge($filters, ['product_id' => $r->product_id])) }}"
                                   class="btn btn-xs btn-info"><i class="fa fa-search"></i> @lang('lang_v1.batches')</a>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endcomponent

    {{-- ROOT CAUSE: nothing else fixes waste on a product bought far faster than
         it sells, so this sits next to the ratio table. --}}
    @component('components.widget', ['class' => 'box-warning', 'title' => __('lang_v1.over_ordering_signals')])
        <p class="help-block">@lang('lang_v1.over_ordering_help')</p>
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="over_table" style="width:100%;">
                <thead><tr>
                    <th>@lang('business.product')</th>
                    <th class="text-right">@lang('lang_v1.units_received')</th>
                    <th class="text-right">@lang('lang_v1.units_sold')</th>
                    <th class="text-right">@lang('lang_v1.sell_through')</th>
                    <th class="text-right">@lang('lang_v1.unsold_units')</th>
                    <th class="text-right">@lang('lang_v1.days_of_cover')</th>
                </tr></thead>
                <tbody>
                    @foreach($over_ordering as $o)
                        <tr>
                            <td>{{ $o->product_name }}</td>
                            <td class="text-right">{{ @num_format($o->received_units) }}</td>
                            <td class="text-right">{{ @num_format($o->sold_units) }}</td>
                            <td class="text-right" data-order="{{ $o->sell_through }}">
                                <strong class="{{ $o->sell_through < 20 ? 'text-red' : 'text-orange' }}">{{ $o->sell_through }}%</strong>
                            </td>
                            <td class="text-right">{{ @num_format($o->unsold_units) }}</td>
                            <td class="text-right">
                                {{ $o->days_of_cover === null ? __('lang_v1.no_sales_yet') : $o->days_of_cover }}
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endcomponent

    <div class="row">
        <div class="col-md-6">
            @component('components.widget', ['class' => 'box-solid', 'title' => __('lang_v1.site_comparison')])
                <p class="help-block">
                    @lang('lang_v1.chain_average_ratio'): <strong>{{ $site_comparison['chain_ratio'] }}%</strong>
                </p>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped" id="site_table" style="width:100%;">
                        <thead><tr>
                            <th>@lang('lang_v1.site')</th>
                            <th>@lang('business.state')</th>
                            <th class="text-right">@lang('lang_v1.expiry_ratio')</th>
                            <th class="text-right">@lang('lang_v1.vs_chain')</th>
                            <th class="text-right">@lang('lang_v1.value_at_cost')</th>
                        </tr></thead>
                        <tbody>
                            @foreach($site_comparison['sites'] as $s)
                                <tr>
                                    <td>
                                        {{ $s->business_name }}
                                        @if($s->is_supplier_warehouse)
                                            <span class="label bg-gray">@lang('lang_v1.warehouse')</span>
                                        @endif
                                    </td>
                                    <td>{{ $s->state }}</td>
                                    <td class="text-right">{{ $s->ratio }}%</td>
                                    <td class="text-right" data-order="{{ $s->vs_chain }}">
                                        <span class="{{ $s->vs_chain > 0 ? 'text-red' : 'text-green' }}">
                                            {{ $s->vs_chain > 0 ? '+' : '' }}{{ $s->vs_chain }}
                                        </span>
                                    </td>
                                    <td class="text-right">@format_currency($s->expired_value)</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            @endcomponent
        </div>
        <div class="col-md-6">
            @component('components.widget', ['class' => 'box-solid', 'title' => __('lang_v1.expired_by_manufacturer')])
                <p class="help-block">@lang('lang_v1.by_manufacturer_help')</p>
                <div class="table-responsive">
                    <table class="table table-bordered table-striped" id="mfr_table" style="width:100%;">
                        <thead><tr>
                            <th>@lang('lang_v1.manufacturer')</th>
                            <th class="text-right">@lang('lang_v1.batches')</th>
                            <th class="text-right">@lang('lang_v1.units')</th>
                            <th class="text-right">@lang('lang_v1.value_at_cost')</th>
                        </tr></thead>
                        <tbody>
                            @foreach($by_manufacturer as $m)
                                <tr>
                                    <td>{{ $m->manufacturer }}</td>
                                    <td class="text-right">{{ $m->batches }}</td>
                                    <td class="text-right">{{ @num_format($m->units) }}</td>
                                    <td class="text-right">@format_currency($m->value_at_cost)</td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            @endcomponent
        </div>
    </div>

    @component('components.widget', ['class' => 'box-solid', 'title' => __('lang_v1.expired_by_site')])
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="business_table" style="width:100%;">
                <thead><tr>
                    <th>@lang('lang_v1.site')</th>
                    <th>@lang('lang_v1.type')</th>
                    <th class="text-right">@lang('lang_v1.batches')</th>
                    <th class="text-right">@lang('lang_v1.units')</th>
                    <th class="text-right">@lang('lang_v1.value_at_cost')</th>
                    <th class="not-export">@lang('messages.action')</th>
                </tr></thead>
                <tbody>
                    @foreach($by_business as $b)
                        <tr>
                            <td>{{ $b->business_name }}</td>
                            <td>{{ $b->is_supplier_warehouse ? __('lang_v1.warehouse') : __('lang_v1.store') }}</td>
                            <td class="text-right">{{ $b->batches }}</td>
                            <td class="text-right">{{ @num_format($b->units) }}</td>
                            <td class="text-right">@format_currency($b->value_at_cost)</td>
                            <td>
                                <a href="{{ route('expiry-analytics.batches', ['business_id' => $b->business_id]) }}"
                                   class="btn btn-xs btn-info"><i class="fa fa-search"></i> @lang('lang_v1.batches')</a>
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
        <a href="{{ route('expiry-analytics.batches', $filters) }}" class="btn btn-default">
            <i class="fa fa-list"></i> @lang('lang_v1.view_all_expired_batches')
        </a>
        <a href="{{ route('expiry-analytics.disposals') }}" class="btn btn-default">
            <i class="fa fa-certificate"></i> @lang('lang_v1.chain_disposal_register')
        </a>
    @endcomponent
</section>
@endsection

@section('javascript')
@if($chart_has_data['ageing']){!! $charts['ageing']->script() !!}@endif
@if($chart_has_data['pipeline']){!! $charts['pipeline']->script() !!}@endif
@if($chart_has_data['trend']){!! $charts['trend']->script() !!}@endif
@if($chart_has_data['seasonality']){!! $charts['seasonality']->script() !!}@endif
@if($chart_has_data['state']){!! $charts['state']->script() !!}@endif
@if($chart_has_data['product']){!! $charts['product']->script() !!}@endif
<script type="text/javascript">
    $(document).ready(function () {
        // Standard DataTables everywhere: pagination, search and export come from
        // the project defaults.
        $('#ratio_table').DataTable({ order: [[4, 'desc']] });
        $('#over_table').DataTable({ order: [[3, 'asc']] });
        $('#site_table').DataTable({ order: [[2, 'desc']] });
        $('#mfr_table').DataTable({ order: [[3, 'desc']] });
        $('#business_table').DataTable({ order: [[4, 'desc']] });
    });
</script>
@endsection