@extends('layouts.base')

@php
    function uniqueProduction($productions) {
        return $productions->groupBy('product_id')->map(function ($productions) {
            $data = ['planned' => 0, 'achieve' => 0, 'conform' => 0, 'lost' => 0, 'product_id' => $productions[0]->product_id];
            foreach ($productions as $production) {
                $data['planned'] += $production->planned;
                $data['achieve'] += $production->achieve;
                $data['conform'] += $production->conform;
                $data['lost'] += $production->lost;
            }
            return new App\Models\Production($data);
        });
    }
@endphp

@section('title', 'Production Par Contrat')

@section('stylesheets')
    <style>
        .hiddenRow {
            padding: 0 !important;
        }
    </style>
@endsection


@section('content')

    <div class="col-md-12">
        <div class="card">
            <div class="card-body">
                <div id="education_fields" class=" m-t-20"></div>
                    <form method="get" action="{{route('policy.index')}}" class="row">
                        <div class="col-md-3">
                            <input type="date" name="start" value="{{request('start')}}" class="form-control bootstrapMaterialDatePicker">
                        </div>
                        <div class="col-md-3">
                            <input type="date" name="end" value="{{request('end')}}" class="form-control bootstrapMaterialDatePicker" >
                        </div>
                        <div class="col-md-6">
                            <div class="form-group">
                                <select class="form-control select2" multiple="multiple" name="sites[]">
                                    <option disabled data-placeholder="Selectionner des sites"></option>
                                    @foreach (Auth::user()->sites as $site)
                                        <option value="{{ $site->id}}" @if(in_array($site->id, \request('sites', []))) selected="selected" @endif>{{ $site->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-12">
                            <button class="btn btn-md btn-block btn-success">Filtrer</button>
                        </div>
                    </form>
                <div class="paginator" data-default="{{ \Illuminate\Support\Carbon::now()->startOfWeek()->format('d-m-Y') }}" data-position="start"></div>
                <div class="paginator" data-default="{{ \Illuminate\Support\Carbon::now()->endOfWeek()->format('d-m-Y') }}" data-position="end"></div>
            </div>
        </div>
    </div>


    <div class="card card-body">
        <div class="printableArea">
            <div class="row">
                <div class="col-md-12">
                    <div class="table-responsive m-t-40" style="clear: both;">
                        <table class="table table-hover" style="border-collapse:collapse;">
                            <thead class="text-white bg-success border border-success">
                            <tr>
                                <th class="align-middle">Section</th>
                                <th class="text-center align-middle">Prévue</th>
                                <th class="text-center">Moo Prévue</th>
                                <th class="text-center align-middle">Realisée</th>
                                <th class="text-center">Moo Réalisée</th>
                                <th class="text-center">Eff. Present</th>
                                <th class="text-center">Tx Réal</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach ($units as $unit => $sections)
                                @php
                                    $total_planned = 0;
                                    $total_achieve = 0;
                                    $total_planned_contract= 0;
                                    $total_achieve_contract= 0;
                                    $total_quantity = 0;
                                @endphp
                                @foreach ($sections as $section => $productions)
                                    @php
                                        $total_planned += $productions->sum('planned');
                                        $total_achieve += $productions->sum('achieve');
                                        $section_id = $productions->first()->section_id;
                                        $quantity = $quantities[$section_id] ?? 0;
                                        $total_quantity += $quantity;
                                    @endphp
                                    <tr class="font-weight-bolder accordion-toggle" data-toggle="collapse"
                                        data-target="#demo-{{ $loop->index . '-'. $loop->parent->index }}">
                                        @php
                                        $tx = ($productions->sum('planned') != 0) ? $productions->sum('achieve')/$productions->sum('planned')*100 : 0;
                                        @endphp
                                        <td>{{ \App\Models\Section::find($section)->name }} </td>
                                        <td class="text-center">{{ number_format(($productions->sum('planned')),0, ',', ' ') }}</td>
                                        <td class="text-center">{{ number_format($productions->sum(fn($p) => ($p->product->contract != 0) ? $p->planned*($p->product->operator/$p->product->contract) : 0), 2, ',', ' ') }}</td>
                                        <td class="text-center">{{ number_format(($productions->sum('achieve')),0, ',', ' ') }}</td>
                                        <td class="text-center">{{ number_format($productions->sum(fn($p) => ($p->product->contract != 0) ? $p->achieve*($p->product->operator/$p->product->contract) : 0), 2, ',', ' ') }}</td>
                                        <td class="text-center">{{ number_format($quantity, 2, ',', ' ') }}</td>
                                        <td class="text-center">{{number_format($tx,2,',',' ')}}%</td>
                                    </tr>
                                    <tr>
                                        <td colspan="11" class="hiddenRow">
                                            <div class="accordian-body collapse"
                                                 id="demo-{{ $loop->index . '-'. $loop->parent->index }}">
                                                <div class="table-responsive m-t-40" style="clear: both;">
                                                    <table class="table table-hover">
                                                        <thead>
                                                        <tr>
                                                            <th class="text-center">#</th>
                                                            <th>Produit</th>
                                                            <th class="text-right">Prévue</th>
                                                            <th class="text-right">Moo Prévue</th>
                                                            <th class="text-right">Réalisée</th>
                                                            <th class="text-right">Moo Réalisée</th>
                                                            <th class="text-right">Tx Réal</th>

                                                        </tr>
                                                        </thead>
                                                        <tbody>
                                                        @foreach (uniqueProduction($productions) as $production)
                                                            @php
                                                            $tx = ($production->planned != 0) ? $production->achieve/$production->planned*100 : 0;
                                                                if ($production->product->contract == 0){
                                                                    $planned_contract = 0;
                                                                    $achieve_contract = 0;
                                                                } else{
                                                                 $planned_contract = $production->planned*($production->product->operator/$production->product->contract);
                                                                 $achieve_contract = $production->achieve*($production->product->operator/$production->product->contract);
                                                                }
                                                            @endphp
                                                            @php
                                                                $total_planned_contract += $planned_contract;
                                                                $total_achieve_contract += $achieve_contract;
                                                            @endphp

                                                            <tr>
                                                                <td class="text-center">{{ $loop->index + 1 }}</td>
                                                                <td>{{ $production->product->name }}</td>
                                                                <td class="text-center"> {{ number_format($production->planned,0, ',', ' ') }}</td>
                                                                <td class="text-center"> {{ number_format($planned_contract,2, ',', ' ') }}</td>
                                                                <td class="text-center"> {{ number_format($production->achieve,0, ',', ' ') }}</td>
                                                                <td class="text-center"> {{ number_format($achieve_contract,2, ',', ' ') }}</td>
                                                                <td class="text-center"> {{ number_format($achieve_contract,2, ',', ' ') }}</td>
                                                                <td class="text-center"> {{ number_format($tx,2, ',', ' ') }}%</td>
                                                            </tr>
                                                        @endforeach
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>
                                @endforeach

                                @php
                                    $tx = ($total_planned != 0) ? $total_achieve/$total_planned*100 : 0;
                                @endphp
                                <tr class="bg-primary text-white font-weight-bold">
                                    <td>{{ \App\Models\Unit::find($unit)->name }} </td>
                                    <td class="text-center align-middle">{{ number_format($total_planned,0, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($total_planned_contract,2, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($total_achieve,0, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($total_achieve_contract,2, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($total_quantity, 2, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($tx,2, ',', ' ') }}%</td>


                                </tr>
                            @endforeach
                            @php
                                $tx = ($units->map(fn($sc) => $sc->map(fn($ps) => $ps->sum('planned'))->sum())->sum() != 0) ? $units->map(fn($sc) => $sc->map(fn($ps) => $ps->sum('achieve'))->sum())->sum()/$units->map(fn($sc) => $sc->map(fn($ps) => $ps->sum('planned'))->sum())->sum()*100 : 0;
                                $total_eff_present = array_sum($quantities);
                            @endphp

                            <tr class="bg-dark text-white font-weight-bold">
                                <td>Total</td>
                                <td class="text-center align-middle">{{ number_format(($units->map(fn($sc) => $sc->map(fn($ps) => $ps->sum('planned'))->sum())->sum()),0, ',', ' ') }}</td>
                                <td class="text-center align-middle">{{ number_format(($units->map(fn($sc) => $sc->map(fn($ps) => ($ps->sum('planned')*$ps->first()->product->operator)/($ps->first()->product->contract == 0 ? 1 : $ps->first()->product->contract))->sum())->sum()), 2, ',', ' ') }}</td>
                                <td class="text-center align-middle">{{ number_format(($units->map(fn($sc) => $sc->map(fn($ps) => $ps->sum('achieve'))->sum())->sum()),0, ',', ' ') }}</td>
                                <td class="text-center align-middle">{{ number_format(($units->map(fn($sc) => $sc->map(fn($ps) => ($ps->sum('achieve')*$ps->first()->product->operator)/($ps->first()->product->contract == 0 ? 1 : $ps->first()->product->contract))->sum())->sum()), 2, ',', ' ') }}</td>
                                <td class="text-center align-middle">{{ number_format($total_eff_present, 2, ',', ' ')}}</td>
                                <td class="text-center align-middle">{{ number_format($tx, 2, ',', ' ') }}%</td>
                            </tr>
                            </tbody>
                        </table>
                    </div>

                </div>
                <div class="col-md-12">

                </div>
            </div>
        </div>
    </div>

@endsection

@section('javascripts')
    <script>

        $(function() {
            $("#print").click(function() {
                var mode = 'iframe'; //popup
                var close = mode == "popup";
                var options = {
                    mode: mode,
                    popClose: close
                };
                $("div.printableArea").printArea(options);
            });
        });
    </script>

@endsection