108 lines
5.0 KiB
PHP
108 lines
5.0 KiB
PHP
|
@section('product')
|
||
|
|
@php
|
||
|
|
$cols = $model->find($pdata->pluck($model_key)->unique())->sortBy('name');
|
||
|
|
@endphp
|
||
|
|
|
||
|
|
<!-- Default box -->
|
||
|
|
<div class="container-fluid spark-screen">
|
||
|
|
<div class="row">
|
||
|
|
<div class="col-md-12 col-md-offset-0">
|
||
|
|
|
||
|
|
<div class="box">
|
||
|
|
<div class="box-header with-border">
|
||
|
|
<h3 class="box-title"> Product Data: {{ $co->name }} ({{$co->segment->unit->name."|".$co->segment->name}}) as at {{ $ido->import_date->format('Y-m-d') }}</h3>
|
||
|
|
<div class="box-tools pull-right">
|
||
|
|
<button type="button" class="btn btn-box-tool" data-widget="collapse" data-toggle="tooltip" title="Collapse">
|
||
|
|
<i class="fa fa-minus"></i></button>
|
||
|
|
<button type="button" class="btn btn-box-tool" data-widget="remove" data-toggle="tooltip" title="Remove">
|
||
|
|
<i class="fa fa-times"></i></button>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="box-body">
|
||
|
|
<div class="nav-tabs-custom">
|
||
|
|
<ul class="nav nav-tabs">
|
||
|
|
<li class="active"><a data-target="#entitled" data-toggle="tab">Entitled</a></li>
|
||
|
|
<li><a data-target="#unassigned" data-toggle="tab">Unassigned</a></li>
|
||
|
|
</ul>
|
||
|
|
<div class="tab-content">
|
||
|
|
|
||
|
|
@foreach (['entitled','unassigned'] as $show)
|
||
|
|
<div class="tab-pane @if($show=='entitled') active @endif" id="{{ $show }}">
|
||
|
|
<table width="100%" class="table table-striped table-bordered table-hover" style="color: #000000;">
|
||
|
|
<tr>
|
||
|
|
<th> </th>
|
||
|
|
@foreach ($cols as $col)
|
||
|
|
<th class="text-right" colspan="2">{{ $col->name }}</th>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<th class="text-right" colspan="2">TOTAL</th>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<th> </th>
|
||
|
|
@foreach ($cols as $col)
|
||
|
|
<th class="text-right">#</th>
|
||
|
|
<th class="text-right">$</th>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<th class="text-right">#</th>
|
||
|
|
<th class="text-right">$</th>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<!-- Show group products -->
|
||
|
|
@foreach (\App\Models\Prodsum::find($pdata->pluck('prodsum_id')->unique())->sortBy('name') as $o)
|
||
|
|
<tr>
|
||
|
|
<td><a href="{{ $next ? url('/prodsum/'.$o->id) : '#' }}"> {{ $o->name }}</a></td>
|
||
|
|
|
||
|
|
@foreach ($cols as $col)
|
||
|
|
<td class="text-right">{{$pdata->filter(function($item,$key) use ($o,$col) { return isset($item->prodsum_id) AND $item->prodsum_id == $o->id AND $item->iot_id == $col->id; })->pluck('account_id')->unique()->count() }}</td>
|
||
|
|
<td class="text-right">{{ number_format($pdata->filter(function($item,$key) use ($o,$col) { return isset($item->prodsum_id) AND $item->prodsum_id == $o->id AND $item->iot_id == $col->id; })->sum($show),3) }}</td>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<th class="text-right">{{$pdata->filter(function($item,$key) use ($o,$col) { return isset($item->prodsum_id) AND $item->prodsum_id == $o->id; })->pluck('account_id')->unique()->count()}}</th>
|
||
|
|
<th class="text-right">{{ number_format($pdata->filter(function($item,$key) use ($o,$col) { return isset($item->prodsum_id) AND $item->prodsum_id == $o->id; })->sum($show),3) }}</th>
|
||
|
|
</tr>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<!-- Show non-group products -->
|
||
|
|
@php
|
||
|
|
$rest = $pdata->reject(function($item,$key) { return isset($item->prodsum_id); });
|
||
|
|
//dd($rest);
|
||
|
|
@endphp
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td><i>Other Items</i></td>
|
||
|
|
|
||
|
|
@foreach ($cols as $col)
|
||
|
|
<td class="text-right">{{ $rest->filter(function($item,$key) use ($col) { return $item->iot_id == $col->id; })->pluck('account_id')->unique()->count() }}</td>
|
||
|
|
<td class="text-right">{{ number_format($rest->filter(function($item,$key) use ($col) { return $item->iot_id == $col->id; })->sum($show),3) }}</td>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<th class="text-right">{{ $rest->pluck('account_id')->unique()->count() }}</th>
|
||
|
|
<th class="text-right">{{ number_format($rest->sum($show),3) }}</th>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<th>TOTAL</th>
|
||
|
|
@foreach ($cols as $col)
|
||
|
|
<th class="text-right">{{ $pdata->filter(function($item,$key) use ($col) { return $item->iot_id == $col->id; })->pluck('account_id')->unique()->count() }}</th>
|
||
|
|
<th class="text-right">{{ number_format($pdata->filter(function($item,$key) use ($col) { return $item->iot_id == $col->id; })->sum($show),3) }}</th>
|
||
|
|
@endforeach
|
||
|
|
|
||
|
|
<th class="text-right">{{ $pdata->pluck('account_id')->unique()->count() }}</th>
|
||
|
|
<th class="text-right">{{ number_format($pdata->sum($show),3) }}</th>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
@endforeach
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<p><strong>Please Note:</strong> This view is a product centric view and does not reduce the "Unassigned" value when clients
|
||
|
|
deploy products that they do not have a recorded entitlement allocated to it. For a truer representation of Risk, please use the Geography/Market view</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
@endsection
|