{% extends 'base.html.twig' %}

{% block title %}Etat Statistique{% endblock %}

{% block body %}
    <div class="intro-y flex flex-col sm:flex-row items-center mt-8">
        <h2 class="text-lg font-medium mr-auto">
            Etats Statistiques
        </h2>
        <div class="w-full sm:w-auto flex mt-4 sm:mt-0">
        </div>
    </div>
    <div class="intro-y chat grid grid-cols-12 gap-5 mt-5">
        <!-- BEGIN: Chat Side Menu -->
        <div class="col-span-12 lg:col-span-12 xxl:col-span-12">
            <div class="intro-y pr-1">
                <div class="box p-2">
                    <div class="chat__tabs nav-tabs justify-center flex"> <a data-toggle="tab" data-target="#chats" href="javascript:;" class="flex-1 py-2 rounded-md text-center active">ETAT BETON</a> <a data-toggle="tab" data-target="#friends" href="javascript:;" class="flex-1 py-2 rounded-md text-center">COMMANDE</a> <a data-toggle="tab" data-target="#profile" href="javascript:;" class="flex-1 py-2 rounded-md text-center">PRODUIT</a> </div>
                </div>
            </div>
            <div class="tab-content">

                <div class="tab-content__pane active" id="chats">
                    <div class="pr-1">
                        <div class="box px-5 pt-5 pb-5 lg:pb-0 mt-5">
                            <div class="col-span-6">
                                <h1 class="text-center text-theme-1 text-3xl font-medium leading-none">POINT PRODUCTION PK23 SEMAINE {{ ("now" | date('W')) }}</h1>
                                <hr>
                                <br>
                                    <form action="">
                                        <label for="date_start">Du: </label><input class="input w-56 border" type="date" value="{{ app.request.query.get('date_start') }}" name="date_start">
                                        <label for="date_end">Au: </label> <input class="input w-56 border" type="date" value="{{ app.request.query.get('date_end') }}" name="date_end">
                                        <button type="submit" class="button text-white bg-theme-1 shadow-md mr-2">Filtrer</button>
                                    </form>

                                <table class="table">
                                    <thead>
                                    <tr>
                                        <th class="border-b-2 whitespace-no-wrap">SECTION</th>
                                        <th class="border-b-2 whitespace-no-wrap">QTE REALISEE</th>
                                        <th class="border-b-2 whitespace-no-wrap">BETON REALISE</th>
                                        <th class="border-b-2 whitespace-no-wrap">QTE PREVUE</th>
                                        <th class="border-b-2 whitespace-no-wrap">BETON PREVU</th>
                                        <th class="border-b-2 whitespace-no-wrap">Tx REAL</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    {% set totQ = 0 %}
                                    {% set totP = 0 %}
                                    {% set totR = 0 %}
                                    {% set totPR = 0 %}
                                    {% set perc = 0 %}
                                    {% for state in states %}
                                        {% set p = ((state.quantityStock * 100) / state.previousStock) %}
                                        <tr class="bg-gray-200">
                                            <td class="border-b">{{ state.name|upper }}</td>
                                            <td class="border-b">{{ state.quantityReal | number_format (0, '',' ')}}</td>
                                            <td class="border-b">{{ state.quantityStock  | number_format (0, '',' ')}} Kg</td>
                                            <td class="border-b">{{ state.previousQty | number_format (0, '',' ')}}</td>
                                            <td class="border-b">{{ state.previousStock | number_format (0, '',' ')}} Kg</td>
                                            <td class="border-b">{{ p | number_format (2, ',', '') }} %</td>
                                        </tr>
                                        {% set perc = perc + p %}
                                        {% set totP = totP + state.previousStock %}
                                        {% set totQ = totQ + state.quantityStock %}
                                        {% set totR = totR + state.quantityReal %}
                                        {% set totPR = totPR + state.previousQty %}
                                    {% endfor %}
                                    <tr class="bg-theme-1 text-white">
                                        <td class="border-b">Total</td>
                                        <td class="border-b">{{ totR | number_format (0, '', ' ') }}</td>
                                        <td class="border-b">{{ totQ | number_format (2, ',', ' ')  }} Kg</td>
                                        <td class="border-b">{{ totPR | number_format (0, '', ' ')  }}</td>
                                        <td class="border-b">{{ totP | number_format (2, ',', ' ')  }} Kg</td>
                                        <td class="border-b">
                                            {% if states | length > 0 %}
                                                {{ (perc / (states | length)) | number_format (2, ',', '') }} %
                                                {% else %}
                                                -
                                            {% endif %}
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                                <br>
                            </div>
                        </div>
                    </div>

                    <div class="chat__chat-list overflow-y-auto scrollbar-hidden pr-1 pt-1 mt-4">
                        <div class="cursor-pointer box relative flex items-center p-5 mt-5">
                            <table class="table">
                                <thead>
                                <tr>
                                    <th class="border-b-2 whitespace-no-wrap">BETONNIERE</th>
                                    <th class="border-b-2 whitespace-no-wrap">POIDS BETON</th>
                                    <th class="border-b-2 whitespace-no-wrap">VOLUME BETON</th>
                                    <th rowspan="5" class="border-b-2 whitespace-no-wrap"></th>
                                </tr>
                                </thead>
                                <tbody>
                                {% set totb = 0 %}
                                {% for b in beton %}
                                    <tr class="bg-gray-200">
                                        <td class="border-b">{{ b.name|upper }}</td>
                                        <td class="border-b">{{ b.qty | number_format (0, '',' ')}}</td>
                                        <td class="border-b">{{ (b.qty/2400) | number_format (0, '',' ')}} m<SUP>3</SUP></td>
                                    </tr>

                                    {% set totb = totb + b.qty%}
                                {% endfor %}
                                <tr class="bg-theme-9 text-white">
                                    <td class="border-b">Total</td>
                                    <td class="border-b">
                                            {{ totb | number_format (2, ',', ' ') }}
                                    </td>
                                    <td class="border-b">
                                        {{ (totb/2400) | number_format (2, ',', ' ') }} m<SUP>3</SUP>
                                    </td>
                                
                                </tr>
                                <tr class="bg-theme-1 text-white">
                                    <td class="border-b" >ECART BETON</td>
                                    <td class="border-b" style="font-size: 18px; font-weight: bold">
                                        {{ (totb - totQ) | number_format (2, ',', ' ')  }} Kg
                                    </td>
                                    <td class="border-b" style="font-size: 18px; font-weight: bold">
                                        {{ ((totb - totQ)/2400) | number_format (2, ',', ' ')  }} m<SUP>3</SUP>
                                    </td>
                                    {% set pte =(((totb - totQ)*100)/totb)%}
                                    {% if pte <= 1  %}
                                    <td class="border-b bg-theme-12 text-white" style="font-size: 18px; font-weight: bold">
                                        <b>PERTE :</b> {{ pte | number_format (2, ',', ' ')  }} %
                                    </td>
                                    {% else %}
                                    <td class="border-b bg-theme-6 text-white text-center" style="font-size: 18px; font-weight: bold"><b>PERTE :</b>
                                        {{ pte | number_format (2, ',', ' ')  }} %
                                    </td>
                                    
                                    {% endif %}
                                    
                                    
                                </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
                <div class="tab-content__pane" id="friends">
                    <div class="pr-1">
                        <div class="box p-5 mt-5">
                            <table class="table">
                                <thead>
                                <tr>
                                    <th class="border-b-2 whitespace-no-wrap">PRODUIT</th>
                                    <th class="border-b-2 whitespace-no-wrap">CLIENT</th>
                                    <th class="border-b-2 whitespace-no-wrap">QUANTITE</th>
                                    <th class="border-b-2 whitespace-no-wrap">STOCK</th>
                                    <th class="border-b-2 whitespace-no-wrap">RAP</th>
                                    <th class="border-b-2 whitespace-no-wrap">ACTIONS</th>
                                </tr>
                                </thead>
                                <tbody>

                                {% for cmd in cmdes %}
                                    <tr class="bg-gray-200">
                                        <td class="border-b">{{ cmd.name }}</td>

                                        <td class="border-b">{{ cmd.names }}</td>

                                        <td class="border-b">{{ cmd.qtyOrder }}</td>
                                        <td class="border-b">{{ cmd.st }}</td>
                                        {% if cmd.qtyOrder > cmd.st  %}
                                        <td class="border-b">{{ cmd.qtyOrder - cmd.st }}</td>
                                        {% else %}
                                            <td class="border-b  bg-theme-6 text-white cursor-pointer font-medium ">{{ cmd.qtyOrder - cmd.st }}</td>
                                        {% endif%}
                                        <td class="border-b"></td>
                                    </tr>
                                {% endfor %}
                                </tbody>
                            </table>
                        </div>
                    </div>
                    <div class="chat__user-list overflow-y-auto scrollbar-hidden pr-1 pt-1">

                        <div class="cursor-pointer box relative flex items-center p-5 mt-5">

                        </div>
                    </div>
                </div>
                <div class="tab-content__pane" id="profile">
                    <div class="pr-1">
                        <div class="box px-5 py-10 mt-5">
                            <table class="table">
                                <thead>
                                <tr>
                                    <th class="border-b-2 whitespace-no-wrap">PRODUIT</th>
                                    <th class="border-b-2 whitespace-no-wrap">CLIENT</th>
                                    <th class="border-b-2 whitespace-no-wrap">QUANTITE</th>
                                    <th class="border-b-2 whitespace-no-wrap">ACTIONS</th>
                                </tr>
                                </thead>
                                <tbody>

                                    <tr class="bg-gray-200">
                                        <td class="border-b" rowspan="3" >TEST</td>
                                        <td class="border-b"></td>
                                        <td class="border-b"></td>
                                    </tr>
              </tbody>
                            </table>
                        </div>
                        <div class="box p-5 mt-5">

                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- END: Chat Side Menu -->
        <!-- BEGIN: Chat Content -->
        <div class="intro-y col-span-12 lg:col-span-8 xxl:col-span-9">


        </div>
        <!-- END: Chat Content -->
    </div>

{% endblock %}