{{-- Summary Section --}}

{{-- Calculated Totals --}}
@php
    $totalCost = 0;
    $totalVariance = 0;
    $totalReceived = 0;
    $totalQtyOrdered = 0;
    $totalQtyReceived = 0;
    $totalQtyVariance = 0;
    $notFoundQty = 0;
    $notFoundCost = 0;

     $receiveOrder->no_of_boxes != 0
            ? (int) $this->receiveOrderLineCounts()->sum('qty')
            : (int) $this->receiveOrderLines()->sum('counted_qty')

    foreach ($receiveOrderLines as $line) {
        $lineCost = ($line->qty ?? 0) * $line->cost;
        $lineReceivedCost = ($line->counted_qty ?? 0) * $line->cost;
        $lineVariance = (($line->counted_qty ?? 0) - $line->qty) * $line->cost;
        // $lineVariance = ( $line->qty - ($line->counted_qty ?? 0)) * $line->cost;
        $totalCost += $lineCost;
        $totalVariance += $lineVariance;
        $totalReceived += $lineReceivedCost;
        $totalQtyOrdered += $line->qty;

        $totalQtyReceived += $line->counted_qty;
        
        $totalQtyVariance += ($line->qty ?? 0) - $line->counted_qty;

        // formula:  Received + created - invoice
    }

    foreach ($receiveOrderNotFound as $notFound) {
        $notFoundQty += $notFound->counted_qty;
        $notFoundCost += $notFound->counted_qty * $notFound->alias_cost ?? 0;
    }

    $totalQtyVariance -= $notFoundQty;
    $totalQtyVariance = $totalQtyVariance * -1;

    $totalVariance += $notFoundCost;

@endphp

<div style="margin-bottom: 20px;">
    <h3>RECEIVE ORDER DETAIL SHEET</h3>
    <table style="width:100%; border-collapse: collapse;">
        <tr>
            <td style="text-align: right;"><strong>Receive Order ID:</strong></td>
            <td>{{ $receiveOrder->id }}</td>
            <td></td>
            <td></td>
            <td style="text-align: right;"><strong>Qty:</strong></td>
            <td style="text-align: right;"><strong>Value:</strong></td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>Report Generated at:</strong></td>
            <td>{{ date(config('app.datetime_format')) }}</td>
            <td></td>
            <td style="text-align: right;"><strong>Invoice:</strong></td>
            <td align="right">{{ number_format((float) ($totalQtyOrdered ?? 0), 2) }}</td>
            {{-- <td align="right">{{ number_format($totalQtyOrdered, 0) }}</td> --}}
            <td align="right">{{ number_format($totalCost, 2) }}</td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>Session created at:</strong></td>
            <td>{{ $receiveOrder->created_at->format(config('app.datetime_format')) }}</td>
            <td></td>
            <td style="text-align: right;"><strong>Received:</strong></td>
            <td align="right">{{ number_format($totalQtyReceived, 0) }}</td>
            <td align="right">{{ number_format($totalReceived, 2) }}</td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>Session created by:</strong></td>
            <td>{{ $receiveOrder->createdBy->name }}</td>
            <td></td>
            <td style="text-align: right;"><strong>Created:</strong></td>
            <td align="right">{{ number_format($notFoundQty, 0) }}</td>
            <td align="right">{{ number_format($notFoundCost, 2) }}</td>
        </tr>

        <tr>
            <td style="text-align: right;"><strong>Session Closed at:</strong></td>
            <td>{{ isset($receiveOrder->closed_at) ? $receiveOrder->closed_at->format(config('app.datetime_format')) : '' }}
            </td>
            <td></td>
            <td style="text-align: right;"><strong>Variance:</strong></td>
            <td align="right">
                {{ is_numeric($totalQtyVariance) ? number_format((float) $totalQtyVariance, 2) : '0.00' }}
            </td>


            <td align="right">{{ number_format($totalVariance, 2) }}</td>
        </tr>

        <tr>
            <td style="text-align: right;"><strong>Session Closed by:</strong></td>
            <td>{{ $receiveOrder->closedBy->name ?? '' }}</td>
        </tr>

        <tr>
            <td style="text-align: right;"><strong>Franchise:</strong></td>
            <td>{{ $receiveOrder->franchise->name }}</td>

        </tr>
        <tr>
            <td style="text-align: right;"><strong>User Reference:</strong></td>
            <td>{{ $receiveOrder->user_reference }}</td>

        </tr>
        <tr>
            <td style="text-align: right;"><strong>Warehouse:</strong></td>
            <td>{{ $receiveOrder->warehouse->name }}</td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>No. of Cartons Completed:</strong></td>
            <td>{{ $receiveOrder->completedBoxes }}</td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>No. of Cartons Packing list:</strong></td>
            <td>

                {{ $receiveOrder->no_of_boxes == 0 ? $receiveOrder->boxes->count() : 0 }}
            </td>

        </tr>
        <tr>
            <td style="text-align: right;"><strong>Currency:</strong></td>
            <td>{{ $receiveOrder->currency }}</td>
        </tr>
        <tr>
            <td style="text-align: right;"><strong>Report status:</strong></td>
            <td>{{ $reportType }}</td>
        </tr>

    </table>
</div>

{{-- Table --}}
<table>
    <tr>
        <td colspan="9" align="left" style="font-weight:bold">Grand Total</td>
        <td align="right" style="font-weight:bold">{{ number_format($totalQtyOrdered, 0) }}</td>
        <td align="right" style="font-weight:bold">{{ number_format($totalCost, 2) }}</td>
        <td align="right" style="font-weight:bold">{{ number_format($totalQtyReceived + $notFoundQty, 0) }}</td>
        <td align="right" style="font-weight:bold">{{ number_format($totalReceived + $notFoundCost, 2) }}</td>
        <td align="right" style="font-weight:bold; color:red;">
            {{ number_format($totalQtyVariance, 0) }}</td> 
            <td align="right" style="font-weight:bold; color:red;">
                {{ number_format($totalVariance, 2) }}</td> 
    </tr>
    <thead>
        <tr>
            <th style="font-weight:bold; width:150px">Barcode</th>
            <th style="font-weight:bold; width:200px">Description</th>
            <th style="font-weight:bold; width:100px">Size</th>
            <th style="font-weight:bold; width:100px">Codein</th>
            <th style="font-weight:bold; width:150px">Style</th>
            <th style="font-weight:bold; width:150px">Colour</th>

            <th style="font-weight:bold; width:150px">Carton No.</th>
            {{-- <th style="font-weight:bold; width:150px">Counted By</th> --}}
            <th style="font-weight:bold; width:150px">Counted At</th>

            <th style="font-weight:bold; width:100px">Unit Cost</th>
            <th style="font-weight:bold; width:100px">Invoice Qty</th>
            <th style="font-weight:bold; width:150px">Invoice Value</th>
            <th style="font-weight:bold; width:150px">Received Qty</th>
            <th style="font-weight:bold; width:150px">Received Value</th>
            <th style="font-weight:bold; width:150px">Variance Qty</th>
            <th style="font-weight:bold; width:150px">Variance Value</th>

        </tr>
    </thead>

    <tbody>
        @foreach ($receiveOrderLines as $line)
            <tr>
                <td data-type="s" align="center" valign="middle">{{ $line->barcode }}</td>
                <td align="left">{{ $line->description }}</td>
                <td align="center">{{ $line->size }}</td>
                <td align="center">{{ $line->codein }}</td>
                <td align="center">{{ $line->style }}</td>
                <td align="center">{{ $line->colour }}</td>
                <td data-type="s" align="center">{{ isset($line->box->name) ? $line->box->name : '' }}</td>
                {{-- <td align="center"></td> --}}
                {{-- <td align="center">{{ $line->countedBy->name }}</td> --}}
                <td align="center">
                    {{ isset($line->box->name) ? $line->updated_at->format(config('app.datetime_format')) : '' }}</td>
                <td align="right" data-type="n" data-format="0.00">{{ number_format($line->cost, 2) }}</td>
                <td align="right" data-type="n" data-format="0">{{ $line->qty }}</td>
                {{-- Invoice Value --}}
                <td align="right" data-type="n" data-format="0.00">
                    {{ number_format(($line->qty ?? 0) * $line->cost, 2) }}
                </td>
                <td align="right" data-type="n" data-format="0">{{ $line->counted_qty ?? 0 }}</td>
                {{-- Received Value --}}
                <td align="right" data-type="n" data-format="0.00">
                    {{ number_format(($line->counted_qty ?? 0) * $line->cost, 2) }}
                </td>
                {{-- Variance (Qty - Counted Qty) --}}
                <td align="right" data-type="n" data-format="0">
                    {{ ($line->counted_qty ?? 0) - $line->qty }}
                </td>

                {{-- Variance cost  (Qty - Counted Qty) --}}
                <td align="right" data-type="n" data-format="0">
                    {{ number_format((($line->counted_qty ?? 0) - $line->qty) * $line->cost) }}
                </td>

            </tr>
        @endforeach
    </tbody>

    {{-- Total Row --}}
    <tfoot>
        <tr>
            <td colspan="13" style="font-weight:bold; text-align:center; padding-top: 20px;">CREATED BARCODES</td>
        </tr>

        @foreach ($receiveOrderNotFound as $notFound)
            <tr>
                <td align="center" data-type="s">{{ $notFound->barcode }}</td>
                <td>{{ $notFound->description }}
                    {{ $notFound->possible_alias != null ? " alias of $notFound->possible_alias" : '' }}</td>
                <td align="center">{{ $notFound->size }}</td>
                <td align="center">{{ $notFound->codein }}</td>
                <td align="center">{{ $notFound->style }}</td>
                <td align="center">{{ $notFound->colour }}</td>
                <td data-type="s" align="center">{{ isset($line->box->name) ? $line->box->name : '' }}</td>
                {{-- <td align="center">{{ $line->countedBy->name }}</td> --}}
                {{-- <td align="center"></td> --}}
                <td align="center">
                    {{ isset($line->box->name) ? $line->updated_at->format(config('app.datetime_format')) : '' }}</td>
                <td align="right">{{ number_format($notFound->alias_cost ?? 0, 2) }}</td>
                <td align="right">0</td>
                <td align="right">0</td>
                <td align="right">{{ $notFound->counted_qty }}</td>
                <td align="right">
                    {{ number_format(($notFound->alias_cost ?? 0) * ($notFound->counted_qty ?? 0), 2) }}</td>
                <td align="right">{{ $notFound->counted_qty }}</td>
                <td align="right">{{ number_format($notFound->counted_qty * $notFound->alias_cost ?? 0) }}</td>

            </tr>
        @endforeach
    </tfoot>
</table>