@extends('layouts.app')
@section('title', 'Site Managers Report')

@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>
    <div id="kt_app_content" class="app-content flex-column-fluid">
        <div id="kt_app_content_container" class="app-container container-fluid">
            @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-4">
                    <div class="card">
                        <div class="card-body">
                            <p class="fw-bold"><span>Total Site Managers</span></p>
                            <h1 style="font-size:22px;" id="total_managers"></h1>
                        </div>
                    </div>
                </div>
            </div>
            
            <form action="{{ route('reports.showSiteManagersReport') }}" 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
            @php $totalManagers = 0 @endphp
            <div class="row">
                <div class="col-md-12">
                    @foreach($users as $user)
                    @if($user->projects->count()>0)
                    <div class="card mb-5">
                        <div class="card-body p-0">
                            <table class="table table-bordered mb-0" id="myTable">
                                <thead>
                                    <tr>
                                        <th colspan="4">
                                            <span class="fw-bold text-dark" style="font-size:15px">
                                                {{ $user->firstname }} {{ $user->lastname }}
                                            </span>
                                        </th>
                                    </tr>
                                    <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                        <th>Project</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 class="text-gray-600 fw-semibold">
                                    @foreach($user->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
                                    <tr>
                                        <td width="40%">WG-{{ str_pad($project->id, 4, '0', STR_PAD_LEFT) }} &#8226; {{ $project->title }}</td>
                                        <td width="20%">£{{ number_format($sales_net, 2) }}</td>
                                        <td width="20%">£{{ number_format($estimated_gross_profit, 2) }}</td>
                                        <td width="20%">£{{ number_format($actual_gross_profit, 2) }}</td>
                                    </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                    @php $totalManagers++; @endphp
                    @endif
                    @endforeach
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('js')
<script>
    $("#total_managers").html('{{$totalManagers}}')
</script>
@endsection