@extends('layouts.app')

@section('content')
<div class="row scrollbar-mean-fruit scrollable my-2" style="max-height:600px;overflow-y: auto;">
    <div class="col-sm-12 col-md-12 col-lg-12 ">
        {{-- --------------------------------------------------- Inspections inquiries stats --}}
        <div class="row">
            <div class="col-sm-12 col-md-12 col-lg-12">
                <h4 style="text-align: center;">Inspection Inquiries Stats</h4>
            </div>
            <div class="col-sm-12 col-md-12 col-lg-12">
                <div class="my-2">
                    <form action="{{route('reports_insjob_stats')}}" method="POST">

                        @csrf
                        <label for="year" class="label-primary control-label form-check-label">Select Year:</label>
                        <select name="year" class="custom-select custom-select-sm" style="width:100px;">
                            <option value=2020>2020</option>
                            <option value=2021>2021</option>
                            <option value=2022>2022</option>
                            <option value=2023>2023</option>
                            <option value=2024>2024</option>
                            <option value=2025>2025</option>
                        </select>
                        <button type="submit" class="btn btn-sm btn-primary">Show</button>
                    </form>

                </div>
                <div class="table-responsive">
                    <table class="table table-sm table-bordered text-center table-hover table-light">
                        <thead style="background-color: rgb(80, 120, 131); color: white;font-size: 10px;">
                            <tr>
                                <th style="font-size: 16px;" colspan="12">Year: <span
                                        style="color:chartreuse;">{{$year}}</span></th>
                            </tr>
                            <tr>
                                <th colspan="12" style="background-color: rgb(65, 78, 68);font-size: 13px;">Total Inspection Inquiries</th>
                            </tr>
                            <tr style="background-color: rgb(188, 127, 142);">
                                <th>Jan</th>
                                <th>Feb</th>
                                <th>Mar</th>
                                <th>Apr</th>
                                <th>May</th>
                                <th>Jun</th>
                                <th>Jul</th>
                                <th>Aug</th>
                                <th>Sep</th>
                                <th>Oct</th>
                                <th>Nov</th>
                                <th>Dec</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr style="text-align: center;" id="tr_data">
                                @php
                                    for ($i = 1; $i <= 12; $i++)
                                    {
                                        if (array_key_exists($i,$inquires_mon_count)) {
                                            echo "<td style='font-weight:bold;'>" .$inquires_mon_count[$i]."</td>";
                                        } else {
                                            echo "<td style='color:red;'>0</td>" ;
                                        }
                                    }
                                @endphp
                            </tr>
                            <tr>
                                <th colspan="12" style="background-color: rgb(65, 78, 68);color:white;font-size: 13px;">Finished Inspection Inquiries</th>
                            </tr>
                            <tr style="text-align: center;" id="tr_data">
                                @php
                                    for ($i = 1; $i <= 12; $i++)
                                    {
                                        if (array_key_exists($i,$finished_inquires_mon_count)) {
                                            echo "<td style='font-weight:bold;'>" .$finished_inquires_mon_count[$i]."</td>";
                                        } else {
                                            echo "<td style='color:red;'>0</td>" ;
                                        }
                                    }
                                @endphp
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <hr>
         {{-- --------------------------------------------------- Inspections Jobs stats --}}
        <div class="row">
            <div class="col-sm-12 col-md-12 col-lg-12">
                <h4 style="text-align: center;">Inspection Jobs Stats</h4>
            </div>
            <div class="col-sm-12 col-md-12 col-lg-12">
                <div class="my-2">
                    <form action="{{route('reports_insjob_stats')}}" method="POST">

                        @csrf
                        <label for="year" class="label-primary control-label form-check-label">Select Year:</label>
                        <select name="year" class="custom-select custom-select-sm" style="width:100px;">
                            <option value=2020>2020</option>
                            <option value=2021>2021</option>
                            <option value=2022>2022</option>
                            <option value=2023>2023</option>
                            <option value=2024>2024</option>
                            <option value=2025>2025</option>
                        </select>
                        <button type="submit" class="btn btn-sm btn-primary">Show</button>
                    </form>

                </div>
                <div class="table-responsive">
                    <table class="table table-sm table-bordered text-center table-hover table-light">
                        <thead style="background-color: rgb(80, 120, 131); color: white;font-size: 10px;">
                            <tr>
                                <th style="font-size: 16px;" colspan="12">Year: <span
                                        style="color:chartreuse;">{{$year}}</span></th>
                            </tr>
                            <tr>
                                <th colspan="12" style="background-color: rgb(65, 78, 68);font-size: 13px;">Total Inspection Jobs</th>
                            </tr>
                            <tr style="background-color: rgb(188, 127, 142);">
                                <th>Jan</th>
                                <th>Feb</th>
                                <th>Mar</th>
                                <th>Apr</th>
                                <th>May</th>
                                <th>Jun</th>
                                <th>Jul</th>
                                <th>Aug</th>
                                <th>Sep</th>
                                <th>Oct</th>
                                <th>Nov</th>
                                <th>Dec</th>
                            </tr>
                        </thead>
                        <tbody>
                            <tr style="text-align: center;" id="tr_data">
                                @php
                                    for ($i = 1; $i <= 12; $i++)
                                    {
                                        if (array_key_exists($i,$finished_insjobs_mon_count)) {
                                            echo "<td style='font-weight:bold;'>" .$insjobs_mon_count[$i]."</td>";
                                        } else {
                                            echo "<td style='color:red;'>0</td>" ;
                                        }
                                    }
                                @endphp
                            </tr>
                            <tr>
                                <th colspan="12" style="background-color: rgb(65, 78, 68);color:white;font-size: 13px;">Finished Inspection Jobs</th>
                            </tr>
                            <tr style="text-align: center;" id="tr_data">
                                @php
                                    for ($i = 1; $i <= 12; $i++)
                                    {
                                        if (array_key_exists($i,$finished_insjobs_mon_count)) {
                                            echo "<td style='font-weight:bold;'>" .$finished_insjobs_mon_count[$i]."</td>";
                                        } else {
                                            echo "<td style='color:red;'>0</td>" ;
                                        }
                                    }
                                @endphp
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <hr>
        {{-- --------------------------------------------------- Engineers stats --}}
        <div class="row">
            <div class="col-sm-12 col-md-12 col-lg-12">
                <h4 style="text-align: center;">Engineers Inspections</h4>
            </div>
            <div class="col-sm-12 col-md-12 col-lg-12">
                <div class="my-2">
                    <form action="{{route('reports_insjob_stats')}}" method="POST">

                        @csrf
                        <label for="year" class="label-primary control-label form-check-label">Select Year:</label>
                        <select name="year" class="custom-select custom-select-sm" style="width:100px;">
                            <option value=2020>2020</option>
                            <option value=2021>2021</option>
                            <option value=2022>2022</option>
                            <option value=2023>2023</option>
                            <option value=2024>2024</option>
                            <option value=2025>2025</option>
                        </select>
                        <label for="month" class="label-primary control-label form-check-label">Select Month:</label>
                        <select name="month" class="custom-select custom-select-sm" style="width:100px;">
                            <option value="01">Jan</option>
                            <option value="02">Feb</option>
                            <option value="03">Mar</option>
                            <option value="04">Apr</option>
                            <option value="05">May</option>
                            <option value="06">Jun</option>
                            <option value="07">Jul</option>
                            <option value="08">Aug</option>
                            <option value="09">Sep</option>
                            <option value="10">Oct</option>
                            <option value="11">Nov</option>
                            <option value="12">Dec</option>
                        </select>
                        <button type="submit" class="btn btn-sm btn-primary">Show</button>
                    </form>

                </div>
            </div>
            <div class="col-sm-12 col-md-6 col-lg-12 m-auto scrollable scrollbar-heavy-rain" style="max-height:300px; overflow-y: auto;">
                <div class="table-responsive">
                    <table class="table table-sm table-bordered text-center table-hover ">
                        <thead
                            style="background-color: rgb(80, 120, 131); color: white;font-size: 10px;">
                            <tr>
                                <th style="font-size: 16px;" colspan="3">
                                    Year: <span style="color:chartreuse;">{{$year}}</span> Month:
                                    <span style="color:chartreuse;">{{$month}}</span></th>
                            </tr>
                            <tr style="background-color: rgb(188, 127, 142);">
                                <th>Enginner</th>
                                <th>Finished Jobs Count</th>
                                <th>Tasks Assigned Count</th>
                                {{-- <th>Jan</th>
                                <th>Feb</th>
                                <th>Mar</th>
                                <th>Apr</th>
                                <th>May</th>
                                <th>Jun</th>
                                <th>Jul</th>
                                <th>Aug</th>
                                <th>Sep</th>
                                <th>Oct</th>
                                <th>Nov</th>
                                <th>Dec</th> --}}
                            </tr>
                        </thead>
                        <tbody>

                                @foreach ($engineers as $engineer)
                                <tr style="text-align: center;">
                                    <td>{{$engineer->name}}</td>
                                    <td>
                                        @php

                                            if($engineers_insjobs_count[$engineer->id] == max($engineers_insjobs_count))
                                                {
                                                    $insjobs_color="#24c774";
                                                }elseif($engineers_insjobs_count[$engineer->id] == min($engineers_insjobs_count)){
                                                    $insjobs_color="red";
                                                }else{
                                                    $insjobs_color="black";
                                                }



                                            if($engineers_instasks_count[$engineer->id] == max($engineers_instasks_count))
                                                {
                                                    $instasks_color="#24c774";
                                                }elseif($engineers_instasks_count[$engineer->id] == min($engineers_instasks_count)){
                                                    $instasks_color="red";
                                                }else{
                                                    $instasks_color="black";
                                                }
                                        @endphp

                                            <b style="color:{{$insjobs_color}}">{{$engineers_insjobs_count[$engineer->id]}}</b>

                                    </td>
                                    <td>
                                        <b style="color:{{$instasks_color}}"> {{$engineers_instasks_count[$engineer->id]}}</b>


                                    </td>

                                </tr>
                                @endforeach

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


        {{-- --------------------------------------------------- Equipment stats --}}
        <div class="row">
            <div class="col-sm-12 col-md-12 col-lg-12">
                <h4 style="text-align: center;">Equipment stats</h4>
            </div>
            <div class="col-sm-12 col-md-12 col-lg-12">
                <div class="my-2">
                    <form action="{{route('reports_insjob_stats')}}" method="POST">

                        @csrf
                        <label for="year" class="label-primary control-label form-check-label">Select Year:</label>
                        <select name="year" class="custom-select custom-select-sm" style="width:100px;">
                            <option value=2020>2020</option>
                            <option value=2021>2021</option>
                            <option value=2022>2022</option>
                            <option value=2023>2023</option>
                            <option value=2024>2024</option>
                            <option value=2025>2025</option>
                        </select>
                        <label for="month" class="label-primary control-label form-check-label">Select Month:</label>
                        <select name="month" class="custom-select custom-select-sm" style="width:100px;">
                            <option value="01">Jan</option>
                            <option value="02">Feb</option>
                            <option value="03">Mar</option>
                            <option value="04">Apr</option>
                            <option value="05">May</option>
                            <option value="06">Jun</option>
                            <option value="07">Jul</option>
                            <option value="08">Aug</option>
                            <option value="09">Sep</option>
                            <option value="10">Oct</option>
                            <option value="11">Nov</option>
                            <option value="12">Dec</option>
                        </select>
                        <button type="submit" class="btn btn-sm btn-primary">Show</button>
                    </form>

                </div>
            </div>
            <div class="col-sm-12 col-md-6 col-lg-12 m-auto scrollable scrollbar-heavy-rain" style="max-height:300px; overflow-y: auto;">
                <div class="table-responsive">
                    <table class="table table-sm table-bordered text-center table-hover ">
                        <thead
                            style="background-color: rgb(80, 120, 131); color: white;font-size: 10px;">
                            <tr>
                                <th style="font-size: 16px;" colspan="2">
                                    Year: <span style="color:chartreuse;">{{$year}}</span> Month:
                                    <span style="color:chartreuse;">{{$month}}</span></th>
                            </tr>
                            <tr style="background-color: rgb(188, 127, 142);">
                                <th>Equipment Name</th>
                                <th>Finished Jobs Count</th>
                                {{-- <th>Jan</th>
                                <th>Feb</th>
                                <th>Mar</th>
                                <th>Apr</th>
                                <th>May</th>
                                <th>Jun</th>
                                <th>Jul</th>
                                <th>Aug</th>
                                <th>Sep</th>
                                <th>Oct</th>
                                <th>Nov</th>
                                <th>Dec</th> --}}
                            </tr>
                        </thead>
                        <tbody>

                                @foreach ($equips as $equip)
                                <tr style="text-align: center;">
                                    <td>{{$equip->name}}</td>
                                    <td>

                                        @php
                                            if($equipment_insjobs_count[$equip->id] == max($equipment_insjobs_count))
                                                {
                                                    $eq_insjobs_color="#24c774";
                                                }elseif($equipment_insjobs_count[$equip->id] == min($equipment_insjobs_count)){
                                                    $eq_insjobs_color="red";
                                                }else{
                                                    $eq_insjobs_color="black";
                                                }
                                        @endphp
                                        <b style="color:{{$eq_insjobs_color}}"> {{$equipment_insjobs_count[$equip->id]}}</b>

                                    </td>
                                </tr>
                                @endforeach

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


        {{-- ---------------------------------------------------Top 10 Companies/Inquires stats --}}
        <div class="row">
            <div class="col-sm-12 col-md-12 col-lg-12">
                <h4 style="text-align: center;">Companies By Finished Inquiries Count</h4>
            </div>
            <div class="col-sm-12 col-md-12 col-lg-12">
                <div class="my-2">
                    <form action="{{route('reports_insjob_stats')}}" method="POST">

                        @csrf
                        <label for="year" class="label-primary control-label form-check-label">Select Year:</label>
                        <select name="year" class="custom-select custom-select-sm" style="width:100px;">
                            <option value=2020>2020</option>
                            <option value=2021>2021</option>
                            <option value=2022>2022</option>
                            <option value=2023>2023</option>
                            <option value=2024>2024</option>
                            <option value=2025>2025</option>
                        </select>

                        <button type="submit" class="btn btn-sm btn-primary">Show</button>
                    </form>

                </div>
            </div>
            <div class="col-sm-12 col-md-6 col-lg-12 m-auto scrollable scrollbar-heavy-rain" style="max-height:300px; overflow-y: auto;">
                <div class="table-responsive">
                    <table class="table table-sm table-bordered text-center table-hover ">
                        <thead
                            style="background-color: rgb(80, 120, 131); color: white;font-size: 10px;">
                            <tr>
                                <th style="font-size: 16px;" colspan="3">
                                    Year: <span style="color:chartreuse;">{{$year}}</span></th>
                            </tr>
                            <tr style="background-color: rgb(188, 127, 142);">
                                <th>Company Name</th>
                                <th>Finished Inquiries Count</th>
                            </tr>
                        </thead>
                        <tbody>

                                @foreach ($companies_inqservices_count as $key=>$value)
                                <tr style="text-align: center;">
                                    <td>{{$key}}</td>
                                    <td>

                                        {{-- @php
                                            if($equipment_insjobs_count[$equip->id] == max($equipment_insjobs_count))
                                                {
                                                    $eq_insjobs_color="#24c774";
                                                }elseif($equipment_insjobs_count[$equip->id] == min($equipment_insjobs_count)){
                                                    $eq_insjobs_color="red";
                                                }else{
                                                    $eq_insjobs_color="black";
                                                }
                                        @endphp
                                        <b style="color:{{$eq_insjobs_color}}"> {{$equipment_insjobs_count[$equip->id]}}</b> --}}
                                        {{$value}}
                                    </td>

                                </tr>
                                @endforeach

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

@endsection