@extends('layouts.base')

@section('title', 'KPI - Consommation Beton')

@section('actions')
    <button data-toggle="modal" data-target="#production-modal" class="btn btn-primary waves-effect waves-light">
        <span class="btn-label"><i class="fa fa-plus"></i></span>Ajouter
    </button>

    <div id="production-modal" class="modal fade" tabindex="-1" aria-hidden="true" style="display: none;">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                    <h4 class="modal-title">Details</h4>
                </div>
                <div class="modal-body">
                    <form action="">
                        <div class="form-group">
                            <input type="week" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="" class="form-control-label">Conso 2I</label>
                            <input type="number" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="">Autres travaux</label>
                            <input type="number" class="form-control">
                        </div>
                        <div class="form-group">
                            <label for="">Autres travaux</label>
                            <input type="number" class="form-control">
                        </div>

                    </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default waves-effect" data-dismiss="modal">Fermer</button>
                    <button onclick="$('#production-form').submit()" type="button"
                            class="btn btn-danger waves-effect waves-light">Créer
                    </button>
                </div>
            </div>
        </div>
    </div>
@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 class="row">
                    <div class="col-md-6 col-12">
                        <div class="form-group">
                            <input value="{{ $week }}" type="week" class="form-control" name="week"
                                   placeholder="week">
                        </div>
                    </div>
                    <div class="col-md-6 col-12">
                        <div class="form-group">
                            <select name="site[]" class="form-control select2" multiple="multiple">
                                @foreach($sites as $site)
                                    <option value="{{ $site->id }}" @if(in_array($site->id, request('site', []))) selected  @endif>{{ $site->name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
                    <div class="col-md-12 text-center">
                        <div class="form-group">
                            <button class="btn btn-primary btn-md btn-block" type="submit">Filtrer</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>



    <div class="card card-body">
        <div class="printableArea">
            <hr>
            <h3 class="text-center"><b>CONSOMMATION BETON PAR SECTION / SEMAINE {{ $w }} </b></h3>
            <hr>
            <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-primary border border-primary">
                            <tr>
                                <th class="align-middle">Section</th>
                                <th class="text-center align-middle">Béton prévue</th>
                                <th class="text-center align-middle">Beton realisé</th>
                                <th class="text-center align-middle">Tx Réalisé</th>
                                <th class="text-center align-middle">Ecart</th>
                            </tr>
                            </thead>
                            <tbody class="border border-primary">
                            @foreach($sections as $section)
                                @php($planned = $section->planned($week))
                                @php($achieve = $section->achieve($week))
                                @php($difference = $planned - $achieve)
                                @php($ratio = $planned != 0 ? ($achieve / $planned) * 100 : 0)
                                @php($ratio = $planned != 0 ? ($achieve / $planned) * 100 : 0)
                                @php($allPlanned += $planned)
                                @php($allAchieve += $achieve)
                                @php($differences += $difference)
                                @php($allAchieveRatio += $ratio)
                                <tr>
                                    <td class="align-middle">{{ $section->name }}</td>
                                    <td class="text-center align-middle">{{ number_format($planned ,0, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format($achieve,0, ',', ' ')  }}</td>
                                    <td class="text-center align-middle">{{ number_format($ratio,0, ',', ' ')  }}%</td>
                                    <td class="text-center align-middle">{{ number_format($difference,0, ',', ' ')}}</td>
                                </tr>
                            @endforeach

                            @foreach($sectionOther as $section)

                                @php(number_format(($planned = $section->planned),0, ',', ' '))
                                @php(number_format(($achieve = $section->achieve),0, ',', ' '))
                                @php(number_format(($difference = $planned - $achieve),0, ',', ' '))
                                @php(number_format(($ratio = $planned != 0 ? ($achieve / $planned) * 100 : 0),0, ',', ' '))
                                @php(number_format(($ratio = $planned != 0 ? ($achieve / $planned) * 100 : 0),0, ',', ' '))
                                @php(number_format(($allPlanned += $planned),0, ',', ' '))
                                @php(number_format(($allAchieve += $achieve),0, ',', ' '))
                                @php(number_format(($differences += $difference),0, ',', ' '))
                                @php(number_format(($allAchieveRatio += $ratio),0, ',', ' '))


                                <tr>
                                    <td class="align-middle">{{ $section->name}}</td>
                                    <td class="text-center align-middle">{{ number_format($planned,0, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{number_format($achieve,0, ',', ' ')}}</td>
                                    <td class="text-center align-middle">{{ number_format($ratio,0, ',', ' ') }}%</td>
                                    <td class="text-center align-middle">{{ number_format($difference,0, ',', ' ') }}</td>
                                </tr>

                            @endforeach
                            <tr class="bg bg-dark">
                                <td class="align-middle text-white font-weight-bold">Total</td>
                                <td class="text-center align-middle text-white font-weight-bold">{{ number_format($allPlanned,0, ',', ' ') }}</td>
                                <td class="text-center align-middle text-white font-weight-bold">{{ number_format($allAchieve,0, ',', ' ') }}</td>
                                <td class="text-center align-middle text-white font-weight-bold">{{ number_format(($sections->count() + $sectionOther->count() > 0 ? $allAchieveRatio / ($sections->count()  + $sectionOther->count()) : 0),0, ',', ' ') }}
                                    %
                                </td>
                                <td class="text-center align-middle text-white font-weight-bold">{{ number_format($differences,0, ',', ' ') }}</td>
                            </tr>

                            </tbody>
                        </table>
                    </div>

                </div>
                <div class="col-md-12">
                    <table class="table table-hover" style="border-collapse:collapse;">
                        <thead class="text-white bg-primary border border-primary">
                        <tr>
                            <th class="align-middle">Observation</th>
                        </tr>
                        </thead>
                        <tbody class="border border-primary">
                        @foreach($sectionComments as $comment)
                            <tr>
                                <td>{{ $comment->name }}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="card card-body">
        <div class="printableArea1">
            <hr>
            <h3 class="text-center"><b>CONSOMMATION BETON PAR CENTRALE / SEMAINE {{ $w }} </b></h3>
            <hr>
            <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-primary">
                            <tr>
                                <th class="align-middle"></th>
                                <th class="text-center align-middle">Volume(kg)</th>
                                <th class="text-center align-middle">Volume(m<sup>3</sup>)</th>
                                <th class="text-center align-middle">% Part</th>
                            </tr>
                            </thead>
                            <tbody class="border border-primary">
                            @foreach($centrals as $central)
                                @php($kg = $central->volume($week))
                                @php($m3 = $central->volume($week, true))
                                <tr>
                                    <td class="align-middle">{{ $central->name }}</td>
                                    <td class="text-center align-middle">{{ number_format($kg,0, ',', ' ')  }}</td>
                                    <td class="text-center align-middle">{{ number_format($m3,2, ',', ' ')  }}</td>
                                    <td class="text-center align-middle">{{number_format(( $allVolumeKg != 0 ? ($kg / $allVolumeKg) * 100 : 0),0, ',', ' ') }}%</td>
                                </tr>
                            @endforeach

                            @foreach($centralOther as $central)
                                @php($kg = $central->achieve)
                                @php($m3 = $central->achieve / 2400)
                                <tr>
                                    <td class="align-middle">{{ $central->name }}</td>
                                    <td class="text-center align-middle">{{ number_format($kg,0, ',', ' ')}}</td>
                                    <td class="text-center align-middle">{{ number_format($m3,2, ',', ' ') }}</td>
                                    <td class="text-center align-middle">{{ number_format(($allVolumeKg != 0 ? ($kg / $allVolumeKg) * 100 : 0),0, ',', ' ') }}%</td>
                                </tr>
                            @endforeach

                            <tr class="bg bg-dark">
                                <td class="align-middle text-white font-weight-bold ">Total</td>
                                <td class="text-center align-middle text-white font-weight-bold">{{number_format( $allVolumeKg,0, ',', ' ') }}</td>
                                <td class="text-center align-middle text-white font-weight-bold">{{ number_format(($allVolumeKg / 2400),2, ',', ' ') }} </td>
                                <td class="text-center align-middle text-white font-weight-bold">100%</td>
                            </tr>
                            </tbody>
                        </table>
                    </div>

                </div>
                <div class="col-md-12">
                    <table class="table table-hover" style="border-collapse:collapse;">
                        <thead class="text-white bg-success border border-primary">
                        <tr>
                            <th class="align-middle">Observation</th>
                        </tr>
                        </thead>
                        <tbody class="border border-primary">
                        @foreach($centralComments as $comment)
                            <tr>
                                <td>{{ $comment->name }}</td>
                            </tr>
                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="card card-body">
        <div class="printableArea2">
            <div class="row">
                <div class="col-md-6">
                    @php($lost = $allVolumeKg - $allAchieve)
                    @php($volumePercent = $allVolumeKg != 0 ? ($lost / $allVolumeKg) * 100 : 100)
                    @php($class = $volumePercent <= 1 ? 'success':'danger')
                    <table class="table table-hover table-{{$class}}" style="border-collapse:collapse;">

                        <thead class="text-white bg-{{$class}} border border-{{$class}}">
                        <tr>
                            <th class="align-middle" colspan="2">Perte béton</th>
                        </tr>
                        </thead>
                        <tbody class="border border-{{$class}}">
                        <tr>
                            <td class="text-left text-{{$class}} font-weight-bold">{{ number_format($lost,0, ',', ' ') }}</td>
                            <td class="text-right text-{{$class}} font-weight-bold">{{number_format($volumePercent,2, ',', ' ')}}%</td>
                        </tr>
                        </tbody>
                    </table>
                </div>
                <div class="col-md-6">
                    <table class="table table-hover" style="border-collapse:collapse;">
                        <thead class="text-white bg-warning border border-warning">
                        <tr>
                            <th class="align-middle font-weight-bold">Cible</th>
                        </tr>
                        </thead>
                        <tbody class="border border-warning">
                        <tr class="text-center">
                            <td class="font-weight-bold">1,00%</td>
                        </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

@endsection