@extends('layouts.app')
@section('title', 'Gross Profit Margin')

@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 Projects</span></p>
                            <h1 style="font-size:22px;">{{ $projects->count() }}</h1>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card">
                        <div class="card-body">
                            <p class="fw-bold"><span>Total Sales</span></p>
                            <h1 style="font-size:22px;" id="total_sales">0</h1>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card">
                        <div class="card-body">
                            <p class="fw-bold"><span>Total Estimated Profit</span></p>
                            <h1 style="font-size:22px;" id="total_estimated_profit">0</h1>
                        </div>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="card">
                        <div class="card-body">
                            <p class="fw-bold"><span>Total Actual Profit</span></p>
                            <h1 style="font-size:22px;" id="total_actual_profit">0</h1>
                        </div>
                    </div>
                </div>


            </div>
            
            <div class="card g-5 g-xl-10 mb-xl-10 p-4">
                <div class="">
                    <div class="row">
                        <div class="col-md-6">
                            <div>
                                <div id="chartdiv" style="width: 100%; height: 400px;"></div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div>
                                <div id="chartdiv2" style="width: 100%; height: 400px;"></div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            
            <form action="{{ route('reports.showGrossProfitMarginReport') }}" 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">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="">
                                   
                                    @php 
                                        $grand_sales = 0;
                                        $grand_estimated_profit = 0;
                                        $grand_actual_profit = 0;
                                        $months = ['09-2024', '10-2024', '11-2024'];
                                        $result = array_fill_keys($months, [
                                            'project_ids' => [],
                                            'sales_net' => 0,
                                            'estimated_profit' => 0,
                                            'actual_profit' => 0,
                                        ]);
                                    @endphp
                                   
                                    @foreach($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