@extends('docs.master', ['title'=> 'Project Report '])
@section('content')
<div class="document">
    <div class="document-heading">
        <div class="row">
            <div class="col col-1">
                <img src="{{ base_path('storage/app/uploads/' . settings()->get('uploaded_logo')) }}" style="width:100px; margin-top: -25px;">
            </div>
            <div class="col col-8" style=" margin-top: 50px;">
                <h1 class="align-left" style="font-family:verdana;color:#6e1913; font-weight:bold;">{{ settings()->get('company_name') }}</h1>
            </div>
            <div class="col col-3 align-right">
                Dated: {{ date('d-m-Y') }}
            </div>
        </div>
    </div>
    <div class="document-body">
        {{-- -------------------------- SOLD UNIT SECTION -------------------------- --}}
        <table class="document-table">
            <thead>
                <tr style="height:25px">
                    <th colspan="11" style="text-align: left;font-size: 150%;font-weight:bold">Sold Unit</th>
                </tr>
                <tr>
                    <th>#</th>
                    <th>Project</th>
                    <th>Unit Type</th>
                    <th>Total Unit</th>
                    <th>Sold Unit</th>
                    <th>Sold Area</th>
                    <th>Sold Price</th>
                    <th>Rate / SQFT</th>
                    <th>Receipts</th>
                    <th>Receipts %</th>
                    <th>Balance</th>
                </tr>
            </thead>
            @php
                $i = 1;
                $total_units = 0;
                $total_sold_area = 0;
                $total_sale_price = 0;
                $total_receipts = 0;
                $total_units_total = 0;
                // Create a mapping of sold units for available calculation
                $sold_units_mapping = [];
            @endphp
            <tbody>
                @foreach($model['sold'] as $item)
                    @php
                        $total_units_total += $item->total_units_total;
                        $total_units += $item->total_units;
                        $total_sold_area += $item->unit_gross_area;
                        $total_sale_price += $item->unit_sale_price;
                        $total_receipts += $item->unit_total_received;
                        // Store sold units for calculation
                        $key = $item->project_id . '_' . $item->unit_type_id;
                        $sold_units_mapping[$key] = [
                            'total_units_total' => $item->total_units_total,
                            'sold_units' => $item->total_units,
                            'project' => $item->project,
                            'unit_type' => $item->unit_type
                        ];
                    @endphp
                    <tr>
                        <td>{{ $i++ }}</td>
                        <td>{{ $item->project }}</td>
                        <td>{{ $item->unit_type }}</td>
                        <td class="align-right">{{ $item->total_units_total }}</td>
                        <td class="align-right">{{ $item->total_units }}</td>
                        <td class="align-right">{{ number_format($item->unit_gross_area, 0) }}</td>
                        <td class="align-right">{{ number_format($item->unit_sale_price, 0) }}</td>
                        <td class="align-right">
                            {{ number_format($item->unit_gross_area > 0 ? $item->unit_sale_price / $item->unit_gross_area : 0) }}
                        </td>
                        <td class="align-right">{{ number_format($item->unit_total_received, 0) }}</td>
                        <td class="align-right">
                            {{ number_format($item->unit_sale_price > 0 ? ($item->unit_total_received / $item->unit_sale_price) * 100 : 0) }}
                        </td>
                        <td class="align-right">
                            {{ number_format($item->unit_sale_price - $item->unit_total_received) }}
                        </td>
                    </tr>
                @endforeach
                {{-- TOTAL ROW --}}
                <tr style="font-weight: bold;">
                    <td colspan="3">Total</td>
                    <td class="align-right">{{ number_format($total_units_total) }}</td>
                    <td class="align-right">{{ number_format($total_units) }}</td>
                    <td class="align-right">{{ number_format($total_sold_area) }}</td>
                    <td class="align-right">{{ number_format($total_sale_price) }}</td>
                    <td class="align-right">
                        {{ number_format($total_sold_area > 0 ? $total_sale_price / $total_sold_area : 0) }}
                    </td>
                    <td class="align-right">{{ number_format($total_receipts) }}</td>
                    <td class="align-right">
                        {{ number_format($total_sale_price > 0 ? ($total_receipts / $total_sale_price) * 100 : 0) }}%
                    </td>
                    <td class="align-right">
                        {{ number_format($total_sale_price - $total_receipts) }}
                    </td>
                </tr>
            </tbody>
        </table>
 {{-- Replace your existing Available Unit section with this code --}}
{{-- -------------------------- AVAILABLE UNIT SECTION -------------------------- --}}
<br><br><br>
<table class="document-table" style="width:85%">
    <thead>
        <tr style="height:25px">
            <th colspan="8" style="text-align: left;font-size: 150%;font-weight:bold">Available Unit</th>
        </tr>
        <tr>
            <th style="text-align: left;width:3%">#</th>
            <th style="text-align: left;width:10%">Project</th>
            <th style="text-align: center;width:10%">Unit Type</th>
            <th style="text-align: center">Total Unit</th>
            <th style="text-align: center">Available Unit</th>
            <th style="text-align: center">Avail Area</th>
            <th style="text-align: center">Available Price</th>
            <th style="text-align: center">Rate / SQFT</th>
        </tr>
    </thead>
    <tbody>
        @php
            $j = 1;
            $total_avail_units_count = 0;
            $total_avail_area = 0;
            $total_avail_price = 0;
            $total_avail_units_amount = 0;
        @endphp
        @foreach($model['available'] as $item)
            @php
                // Only use name-based matching since IDs don't exist
                $soldData = null;
                // Try to find matching sold data by unit type name
                foreach($model['sold'] as $sold) {
                    $soldUnitType = strtolower(trim($sold->unit_type ?? ''));
                    $availableUnitType = strtolower(trim($item->unittypedetail ?? ''));
                    if ($soldUnitType === $availableUnitType) {
                        $soldData = $sold;
                        break;
                    }
                }
                // Get total units from available data
                $totalUnitsFromAvailable = (int)($item->total_units_total ?? $item->total_units ?? 0);
                // Get sold units from matching sold data
                $soldUnitsFromSold = $soldData ? (int)($soldData->total_units ?? 0) : 0;
                // SIMPLE CALCULATION: Total - Sold = Available
                $calculatedAvailableUnits = $item->available_units;
                // Add to totals
                $total_avail_area += $item->gross_area ?? 0;
                $total_avail_price += $item->total_price ?? 0;
                $total_avail_units_amount += $totalUnitsFromAvailable;
                $total_avail_units_count += $calculatedAvailableUnits;
            @endphp
            <tr>
                <td>{{ $j++ }}</td>
                <td>{{ $item->projectname ?? 'N/A' }}</td>
                <td>{{ $item->unittype ?? 'N/A' }}</td>
                <td class="align-right">{{ number_format($totalUnitsFromAvailable) }}</td>
                <td class="align-right">{{ number_format($calculatedAvailableUnits) }}</td>
                <td class="align-right">{{ number_format($item->gross_area ?? 0, 0) }}</td>
                <td class="align-right">{{ number_format($item->total_price ?? 0, 0) }}</td>
                <td class="align-right">
                    {{ number_format(($item->gross_area ?? 0) > 0 ? ($item->total_price ?? 0) / ($item->gross_area ?? 0) : 0) }}
                </td>
            </tr>
        @endforeach
        {{-- TOTAL ROW --}}
        <tr style="font-weight: bold;">
            <td colspan="3">Total</td>
            <td class="align-right">{{ number_format($total_avail_units_amount) }}</td>
            <td class="align-right">{{ number_format($total_avail_units_count) }}</td>
            <td class="align-right">{{ number_format($total_avail_area) }}</td>
            <td class="align-right">{{ number_format($total_avail_price) }}</td>
            <td class="align-right">
                {{ number_format($total_avail_area > 0 ? $total_avail_price / $total_avail_area : 0) }}
            </td>
        </tr>
    </tbody>
</table>
        {{-- FOOTER --}}
        <div class="row">
            <div class="col col-8" style="margin-top: -8px"></div>
            <div class="col col-4 align-right" style="margin-top: -8px">
                <br />
                <p style="font-style: italic;text-align: left">
                    Printed On: {{ date('d-m-Y h:i:s A') }} by {{ Auth::user()->name }}
                </p>
            </div>
        </div>
    </div>
</div>
@endsection