@extends('layouts.app')
@section('title', 'Best Clients')

@section('content')
<div class="d-flex flex-column flex-column-fluid">
    <!--begin::Toolbar-->
    <style>
        .bg-danger-2 {
            background: #ffcccc;
            border-color: #ffcccc;
        }


        table.table-bordered.dataTable {
            border: 0;
            border-bottom: 0;
        }

        .bg-success-2 {
            background: #D2EA8E;
        }

        .text-red {
            color: red !important;
        }

        body,
        #kt_app_header {
            background: #f1f5f5 !important;
        }

        .table td,
        .table th {
            vertical-align: middle;
        }

        .table td {
            background: #93D5001A;
            border: 3px solid white !important;
            padding: 8px !important;
            color: black !important;
            text-align: center;
            color: #727879;
        }



        .table th {
            border: 3px solid white !important;
            background: #E3E3E3;
            color: #5E5E5E !important;
            font-weight: 500;
            font-size: 12px;
            margin: 10px !important;
            text-align: center;
        }

        table.dataTable.no-footer {
            border-bottom: 0 !important;
        }

    </style>
    <!--end::Toolbar-->
    <!--begin::Content-->
    <div id="kt_app_content" class="app-content flex-column-fluid">
        <!--begin::Content container-->
        <div id="kt_app_content_container" class="app-container container-fluid">
            <!--begin::Row-->
            @if(session('success'))
            <div class="col-md-12">
                <div class="alert alert-success">
                    {{ session('success') }}
                </div>
            </div>
            @endif
            @if ($errors->any())
            <div class="alert alert-danger">
                {!! implode('<br>', $errors->all(':message')) !!}
            </div>
            @endif
            <div class="row g-5 g-xl-10 mb-xl-10">
                <div class="col-md-3">
                    <div class="card w-100">
                        <div class="card-body">
                            <p class="fw-bold"><span>Total Clients</span></p>
                            <h1 style="font-size:22px;">{{ $clients->count() }}</h1>
                        </div>
                    </div>
                </div>
                <div class="col-md-9">
                    <div class="card">
                        <div class="card-body">
                            <p class="fw-bold"><span>Best Client</span></p>
                            <h1 style="font-size:22px;" id="best_client"></h1>
                        </div>
                    </div>
                </div>
            </div>
            <form action="{{ route('reports.showBestClients') }}" method="get">
                <div class="row mb-5 align-items-center">
                    
                    <div class="col-md-3">
                        <input required @if(!request()->has('from')) onfocus="this.type='date'" onblur="if(this.value===''){this.type='text'}" @else type="date" @endif class="form-control  bg-white" placeholder="From" name="from" value="@if(request()->has('from')){{request()->from}}@endif" />
                    </div>
                    <div class="col-md-3">
                        <input required @if(!request()->has('to')) onfocus="this.type='date'" onblur="if(this.value===''){this.type='text'}" @else type="date" @endif class="form-control  bg-white" placeholder="To" name="to" value="@if(request()->has('to')){{request()->to}}@endif" />
                    </div>
                    <div class="col-md-2">
                        <button class="btn w-100 btn-primary ">Filter</button>
                    </div>
                </div>
            </form>
            @if(!request()->has('from'))
            <p class=""><i>Showing results from past 90 days.</i></p>
            @endif
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                        <!--begin::Card header-->
                        
                        <!--end::Card header-->
                        <!--begin::Card body-->
                        <div class="card-body p-0">
                            <!--begin::Table-->
                            <table class="table table-bordered mb-0" id="kt_table_users">
                                <thead>
                                    <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                        <th class="min-w-125px" style="text-align:left">Client</th>
                                        <th>Projects</th>
                                        <th class="min-w-100px">Total Sales</th>
                                        <th class="min-w-100px">Estimated Gross Profit</th>
                                        <th class="min-w-100px">Actual Gross Profit</th>
                                    </tr>
                                </thead>
                                <tbody>
                                   @foreach($clients as $client)
                                    
                                     @php
                                        $grand_sales = 0;
                                        $grand_estimated_profit = 0;
                                        $grand_actual_profit = 0;
                                     @endphp
                                    
                                     @if(isset($client->projects))
                                      @foreach($client->projects as $project)
                                           @php
                                            $plant = 0;
                                            $labour = 0;
                                            $material = 0;
                                            $subcontract = 0;
                                            $other = 0;
                                            $sales_net = 0;
                                            $sub_contracts_total = 0;
                                            $sub_contracts_other_total = 0;
                                            $estimated_net = 0;
                                            $po_total_plant = 0;
                                            $po_total_material = 0;
                                            $po_total_labour = 0;
                                            $po_total = 0;
                                            $estimated_gross_profit = 0;
                                            $actual_gross_profit = 0;
                                            @endphp
                                            
                                        @if($project->tender==1)
                                                                                    @else
                                        
                                                                                    @endif
                                       @endforeach
                                       @endif
                                    <tr data-profit="{{ $grand_actual_profit }}">
                                        <td width="20%" style="text-align:left;">{{ $client->company_name }}</td>
                                        <td width="10%">{{ $client->projects->count() }}</td>
                                        <td width="15%">£{{ number_format($grand_sales, 2) }}</td>
                                        <td width="15%">£{{ number_format($grand_estimated_profit, 2) }}</td>
                                        <td width="15%">£{{ number_format($grand_actual_profit, 2) }}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                          <!--end::Table-->
                        </div>
                        <!--end::Card body-->
                    </div>
                </div>
            </div>

        </div>
    </div>
    <!--end::Content-->
</div>
@endsection
@section('js')
<script>
    $(document).ready(function () {
        // Sort the rows
        $('#kt_table_users tbody tr').sort(function (a, b) {
            // Compare the `data-profit` values
            return $(b).data('profit') - $(a).data('profit'); // Descending order
        }).appendTo('#kt_table_users tbody'); // Reattach sorted rows to the tbody
        
        const firstRowFirstColText = $('#kt_table_users tbody tr:first td:first').text();
        $("#best_client").html(firstRowFirstColText);
        
    });
</script>
@endsection