@extends('layouts.bigbase')

@section('title', 'Consultations productions')


@section('content')
    <div class="col-md-12">
        <div class="card">
            <div class="card-header bg-primary text-white font-weight-bold">Filtrer par date et/ou par famille</div>
            <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="{{ $start->format('Y-m-d') }}" type="date" class="form-control" name="start"
                                   placeholder="debut">
                        </div>
                    </div>
                    <div class="col-md-6 col-12">
                        <div class="form-group">
                            <input value="{{ $end->format('Y-m-d') }}" type="date" class="form-control" name="end"
                                   placeholder="fin">
                        </div>
                    </div>
                    <div class="col-md-12  col-12">
                        <div class="form-group">
                            <label for="">Famille de produit</label>
                                <select name="family[]" class=" js-example-placeholder-multiple form-control select2"
                                        multiple="multiple">
                                    @foreach($families as $family)
                                        <option value="{{ $family->id }}"
                                                @if(in_array($family->id, request('family', []))) selected @endif>{{ $family->code.' - '.$family->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>SEMAINE {{\Carbon\Carbon::parse($start)->weekOfYear}} -
                    ({{ $start->format('d/m/Y') . ' - ' . $end->format('d/m/Y') }})</b></h3>
            <hr>
            <div class="row">
                <div class="col-md-12">
                    <div class="table-responsive m-t-10" 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">Sections</th>
                                <th class="text-center align-middle">Cde actives</th>
                                <!--<th class="text-center align-middle">Template</th>-->
                                <th class="text-center align-middle">Σ Abidjan</th>
                                <th class="text-center align-middle">Σ Sites</th>
                                <th class="text-center align-middle">Σ SIBM</th>
                                <th class="text-center align-middle">Σ Prod sem-1</th>
                                <th class="text-center align-middle">Σ Prod Mois-1</th>
                            </tr>
                            </thead>
                            <tbody>
                            @foreach($typeUnits as $typeUnit)


                                @php($activeOrders = 0)
                                @php($templates = 0)
                                @php($achieveAbidjans = 0)
                                @php($achieveExceptAbidjans = 0)
                                @php($achieves = 0)
                                @php($achieveWeeks = 0)
                                @php($achieveMonths = 0)

                                @foreach($typeUnit->typeSections as $typeSection)

                                    @php($query = $typeSection->products()->whereHas('activeOrders', function($query) use($start, $end) { $query->whereBetween('order_at', [$start->clone()->startOfYear(), $end]); })->orderBy('name'))

                                    @if(count(request('family', [])) > 0)
                                        @php($query = $query->whereIn('family_id', request('family')))
                                    @endif

                                    @php($products = $query->get())

                                    @if(count($products) == 0)
                                        @continue
                                    @endif

                                    @php($activeOrder = 0)
                                    <!--@php($template = 0)-->
                                    @php($achieveAbidjan = 0)
                                    @php($achieveExceptAbidjan = 0)
                                    @php($achieve = 0)
                                    @php($achieveWeek = 0)
                                    @php($achieveMonth = 0)

                                    @php($index = $loop->index . '-' . $loop->parent->index)

                                    <tr class="font-weight-bolder accordion-toggle bg-light-success"  data-toggle="collapse"
                                         data-target="#demo-{{ $index }}">
                                        <td>{{ $typeSection->name }}</td>
                                        <td class="text-center" id="tr-ao-{{ $index }}"></td>
                                        <!--<td class="text-center" id="tr-t-{{ $index }}"></td>-->
                                        <td class="text-center" id="tr-aa-{{ $index }}"></td>
                                        <td class="text-center" id="tr-aea-{{ $index }}"></td>
                                        <td class="text-center" id="tr-sib-{{ $index }}"></td>
                                        <td class="text-center" id="tr-aw-{{ $index }}"></td>
                                        <td class="text-center" id="tr-am-{{ $index }}"></td>
                                    </tr>
                                    <tr>
                                        <td colspan="9" style="padding: 0rem;" class="hiddenRow">
                                            <div class="accordian-body collapse"
                                                 id="demo-{{ $index }}">
                                                <div class="table-responsive " style="clear: both;">
                                                    <table class="table table-hover">
                                                        <thead>
                                                        <tr class="bg bg-light-success">
                                                            <th>Produit</th>
                                                            <th class="text-center align-middle">Cde actives</th>
                                                            <!--<th class="text-center align-middle">Template</th>-->
                                                            <th class="text-center align-middle">Σ Abidjan</th>
                                                            <th class="text-center align-middle">Σ Sites</th>
                                                            <th class="text-center align-middle">Σ SIBM</th>
                                                            <th class="text-center align-middle">Σ Prod sem-1</th>
                                                            <th class="text-center align-middle">Σ Prod Mois-1</th>
                                                        </tr>
                                                        </thead>
                                                        <tbody>
                                                        @foreach( $products as $product)

                                                            @php($ao = $product->activeOrders()->sum('quantity'))
                                        
                                                            @php($aa = $product->productions()->whereBetween('product_at', [$start, $end])->inAbidjan()->sum('achieve'))
                                                            @php($aea = $product->productions()->whereBetween('product_at', [$start, $end])->outAbidjan()->sum('achieve'))
                                                            @php($a = $product->productions->whereBetween('product_at', [$start, $end])->sum('achieve'))
                                                            @php($aw = $product->productions()->whereBetween('product_at', [$start->clone()->subWeek(), $end->clone()->subWeek()])->sum('achieve'))
                                                            @php($am = $product->productions()->whereBetween('product_at', [$start->clone()->subMonth(), $end->clone()->subMonth()])->sum('achieve'))

                                                            <tr>
                                                                <td>{{ $product->name }}</td>
                                                                <td class="text-center">{{ number_format($ao,0,',',' ')  }}</td>
                                
                                                                <td class="text-center">{{ number_format($aa,0,',',' ') }}</td>
                                                                <td class="text-center">{{ number_format($aea,0,',',' ') }}</td>
                                                                <td class="text-center">{{ number_format($a,0,',',' ') }}</td>
                                                                <td class="text-center">{{ number_format($aw,0,',',' ') }}</td>
                                                                <td class="text-center">{{ number_format($am,0,',',' ') }}</td>
                                                            </tr>

                                                            @php($activeOrder += $ao)
                                                      
                                                            @php($achieveAbidjan += $aa)
                                                            @php($achieveExceptAbidjan += $aea)
                                                            @php($achieve += $a)
                                                            @php($achieveWeek += $aw)
                                                            @php($achieveMonth += $am)
                                                        @endforeach

                                                        <input type="hidden" class="data" value="{{ number_format($activeOrder,0,',',' ') }}"
                                                               data-parent="tr-ao-{{ $index }}"/>
                                               
                                                        <input type="hidden" class="data" value="{{ number_format($achieveAbidjan,0,',',' ') }}"
                                                               data-parent="tr-aa-{{ $index }}"/>
                                                        <input type="hidden" class="data"
                                                               value="{{ number_format($achieveExceptAbidjan,0,',',' ') }}"
                                                               data-parent="tr-aea-{{ $index }}"/>
                                                        <input type="hidden" class="data" value="{{ number_format($achieve,0,',',' ') }}"
                                                               data-parent="tr-sib-{{ $index }}"/>
                                                        <input type="hidden" class="data" value="{{ number_format($achieveWeek,0,',',' ') }}"
                                                               data-parent="tr-aw-{{ $index }}"/>
                                                        <input type="hidden" class="data" value="{{ number_format($achieveMonth,0,',',' ') }}"
                                                               data-parent="tr-am-{{ $index }}"/>

                                                        @php($activeOrders += $activeOrder)
                                                 
                                                        @php($achieveAbidjans += $achieveAbidjan)
                                                        @php($achieveExceptAbidjans += $achieveExceptAbidjan)
                                                        @php($achieves += $achieve)
                                                        @php($achieveWeeks += $achieveWeek)
                                                        @php($achieveMonths += $achieveMonth)

                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </td>
                                    </tr>

                                @endforeach

                                <tr class="bg-dark text-white font-weight-bold">
                                    <td>{{ $typeUnit->name }}</td>
                                    <td class="text-center">{{ number_format($activeOrders,0,',',' ') }}</td>
                                
                                    <td class="text-center">{{ number_format($achieveAbidjans,0,',',' ') }}</td>
                                    <td class="text-center">{{ number_format($achieveExceptAbidjans,0,',',' ') }}</td>
                                    <td class="text-center">{{ number_format($achieves,0,',',' ') }}</td>
                                    <td class="text-center">{{ number_format($achieveWeeks,0,',',' ') }}</td>
                                    <td class="text-center">{{ number_format($achieveMonths,0,',',' ') }}</td>
                                </tr>
                            @endforeach
                            </tbody>

                        </table>
                    </div>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-12">
                <div class="clearfix"></div>
                <hr>
            </div>
        </div>
    </div>

@endsection

@section('javascripts')
    <script>
        $('.data').each(function () {
            $('#' + $(this).data('parent')).text($(this).val())
        })
    </script>
@endsection