@extends('admin.layout.app')

@section('content')

<style>
    /* ✅ Screen Look */
    
    .book-report {
        background: #fff;
        padding: 20px;
        border-radius: 6px;
    }

    .book-title {
        text-align: center;
        font-weight: bold;
        margin-bottom: 10px;
        text-transform: uppercase;
    }

    .book-date {
        text-align: center;
        font-size: 14px;
        margin-bottom: 20px;
    }

    .report-section-title {
        font-weight: bold;
        text-transform: uppercase;
        margin-top: 25px;
        margin-bottom: 10px;
        border-bottom: 2px solid #000;
        padding-bottom: 5px;
        font-size: 12px;
    }

    table.report-table {
        width: 100%;
        border-collapse: collapse;
        font-size: 13px;
    }

    table.report-table th,
    table.report-table td {
        border: 1px solid #000;
        padding: 6px;
        vertical-align: top;
    }

    table.report-table th {
        background: #f2f2f2;
        font-weight: bold;
    }

    .summary-line {
        font-weight: bold;
        font-size: 14px;
        margin: 5px 0;
    }

    .net-profit {
        font-size: 18px;
        font-weight: bold;
        text-align: center;
        margin: 20px 0;
        padding: 10px;
        border: 2px solid #000;
    }

    .print-btn {
        text-align: right;
        margin-bottom: 10px;
    }

    /* ✅ Print Style */
    @media print {

        body {
            background: white !important;
        }

        .content-wrapper,
        .content {
            margin: 0 !important;
            padding: 0 !important;
        }

        .card,
        .card-body {
            border: none !important;
            box-shadow: none !important;
        }

        .print-btn {
            display: none !important;
        }

        .main-sidebar,
        .navbar,
        .main-footer {
            display: none !important;
        }

        .book-report {
            padding: 0 !important;
        }

        table.report-table th {
            background: #f2f2f2 !important;
            -webkit-print-color-adjust: exact;
            print-color-adjust: exact;
        }

        @page {
            margin: 5mm;
        }
    }
</style>

<div class="content-wrapper">
    <section class="content">
        <div class="container-fluid">

            <div class="card elevation-0">
                <div class="card-body">

                    {{-- ✅ PRINT BUTTON --}}
                    <div class="print-btn">
                        <button onclick="window.print()" class="btn btn-dark btn-sm">
                            <i class="fas fa-print"></i> Print Report
                        </button>
                    </div>

                    <div class="book-report">

                        {{-- ✅ HEADER --}} 
                        <h4 class="book-title my-0 py-0">DAILY BOOK REPORT</h4>
                        <h5 class="book-title my-0 py-0">{{$admin->name ?? ''}}</h5>
                        <h6 class="book-title my-0 py-0">{{ $date ? \Carbon\Carbon::parse($date)->format('d-m-Y') : '' }}</h6>
                        {{-- <div class="book-date">
                            <b>Date:</b>
                            {{ $startDate->format('d M Y') }}
                            to
                            {{ $endDate->format('d M Y') }}
                        </div>

                        {{-- ✅ INCOME --}}
                        <div class="report-section-title">INSTALLMENT PAYMENT RECEIVED</div>
                        <table class="report-table">
                            <thead>
                                <tr>
                                    {{-- <th>Date</th> --}}
                                    <th>Bill No.</th>
                                    <th>Customer Name</th>
                                    <th>Received Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($ledgers as $ledger)
                                    <tr>
                                        {{-- <td>{{ $ledger->date ?? ''}}</td> --}}
                                        <td>{{ $ledger->sale->bill_no ?? ''}}</td>
                                        <td>{{ $ledger->customer?->name ?? ''}}</td>
                                        <td>{{ $ledger->amount ?? ''}}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="3"  class="text-center">No found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <td colspan="2"><b>Total</b></td>
                                <td colspan="">{{$ledgers->sum('amount' ?? '')}}</td>
                            </tfoot>
                        </table>


                        <div class="report-section-title">SALES</div>
                        <table class="report-table">
                            <thead>
                                <tr>
                                    <th width="8%">Bill No.</th>
                                    <th>Items</th>
                                    <th width="15%">Total Sale</th>
                                    <th width="15%">Received Amount</th>
                                    <th width="15%">Amount Due</th>
                                    <th width="15%">Profit</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($sales as $sale)
                                    <tr>
                                        <td>{{ $sale->bill_no ?? ''}}</td>
                                        <td>
                                            @if($sale->items && count($sale->items) > 0)
                                                @foreach($sale->items as $item)
                                                    {{ $item->item?->name ?? '-' }}
                                                    ({{ $item->quantity ?? 0 }})
                                                    <br>
                                                @endforeach
                                            @else
                                                -
                                            @endif
                                        </td>
                                        <td>Rs. {{ number_format($sale->total ?? 0, 2) }}</td>
                                        <td>
                                            Rs. {{ number_format(($sale->received_balance ?? (($sale->total ?? 0) - ($sale->remaining ?? 0))), 2) }}
                                        </td>
                                        <td>Rs. {{ number_format($sale->remaining ?? 0, 2) }}</td>
                                        <td>
                                            @php
                                                $saleProfit = $sale->installment_charges ?? 0;

                                                if($sale->items && count($sale->items) > 0){
                                                    foreach($sale->items as $si){
                                                        $qty = (float) ($si->quantity ?? 0);

                                                        $saleRate = (float) ($si->rate ?? 0);
                                                        $purchaseRate = (float) ($si->item?->purchase_rate ?? 0);

                                                        $saleProfit += ($saleRate - $purchaseRate) * $qty;
                                                    }
                                                }
                                            @endphp
                                            Rs. {{ number_format($saleProfit, 2) }}
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="6"  class="text-center">No income found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                @php
                                    $totalSale = $sales->sum('total');
                                    $totalDue  = $sales->sum('remaining');

                                    $totalReceived = 0;
                                    foreach ($sales as $s) {
                                        $totalReceived += ($s->received_balance ?? (($s->total ?? 0) - ($s->remaining ?? 0)));
                                    }

                                    $totalProfit = $sales->sum('installment_charges') ?? 0;
                                    foreach ($sales as $s) {
                                        if ($s->items && count($s->items) > 0) {
                                            foreach ($s->items as $si) {
                                                $qty = (float) ($si->quantity ?? 0);
                                                $saleRate = (float) ($si->rate ?? 0);
                                                $purchaseRate = (float) ($si->item?->purchase_rate ?? 0);

                                                $totalProfit += ($saleRate - $purchaseRate) * $qty;
                                            }
                                        }
                                    }
                                @endphp

                                <tr>
                                    <td colspan="2"><b>Total</b></td>
                                    <td><b>Rs. {{ number_format($totalSale, 2) }}</b></td>
                                    <td><b>Rs. {{ number_format($totalReceived, 2) }}</b></td>
                                    <td><b>Rs. {{ number_format($totalDue, 2) }}</b></td>
                                    <td><b>Rs. {{ number_format($totalProfit, 2) }}</b></td>
                                </tr>
                            </tfoot>

                        </table>

                        <br>
                        {{-- <div class="summary-line">Total Sale: Rs. {{ number_format($totalIncome, 2) }}</div>
                        <div class="summary-line">Total Received Amount: Rs. {{ number_format($totalReceivedIncome, 2) }}</div>
                        <div class="summary-line">Total Profit Amount: Rs. {{ number_format($totalProfit, 2) }}</div> --}}

                        {{-- ✅ EXPENSE --}}
                        <div class="report-section-title">DAILY EXPENSES</div>

                        <table class="report-table">
                            <thead>
                                <tr>
                                    <th>Account</th>
                                    <th width="20%">Amount</th>
                                    {{-- <th width="20%">Paid Amount</th> --}}
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($expenses as $exp)
                                    <tr>
                                        <td>{{ $exp->account->name ?? '-' }}</td>
                                        <td>Rs. {{ number_format($exp->amount ?? 0, 2) }}</td>
                                        {{-- <td>Rs. {{ number_format($exp->paid_amount ?? ($exp->amount ?? 0), 2) }}</td> --}}
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="2"  class="text-center">No expenses</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <td colspan="1"><b>Total</b></td>
                                <td>{{$expenses->sum('amount') ?? ''}}</td>
                            </tfoot>
                        </table>

                        <br>
                        {{-- <div class="summary-line">Total Expenses: Rs. {{ number_format($totalExpenses, 2) }}</div> --}}

                        {{-- ✅ NET PROFIT --}}
                        <div class="net-profit">
                            DAILY NET PROFIT: Rs. {{ number_format($netProfit, 2) }}
                        </div>

                        {{-- ✅ PURCHASE SUMMARY --}}
                        <div class="report-section-title">ITEMS PURCHASED</div>

                        <table class="report-table">
                            <thead>
                                <tr>
                                    {{-- <th width="12%">Date</th> --}}
                                    <th>Supplier</th>
                                    <th>Item</th>
                                    <th>Quantity</th>
                                    <th>Price</th>
                                    <th>Total</th>
                                </tr>
                            </thead>

                            <tbody>
                                @php
                                    $grandTotal = 0;
                                @endphp
                                @forelse($purchases as $purchase)
                                    @if($purchase->items && count($purchase->items) > 0)
                                        @foreach($purchase->items as $key => $item)
                                            @php
                                                $itemTotal = ((float)($item->quantity ?? 0) * (float)($item->rate ?? 0));
                                                $grandTotal += $itemTotal;
                                            @endphp
                                            <tr>
                                                {{-- <td>
                                                    {{ \Carbon\Carbon::parse($purchase->date)->format('d/m/Y') }}
                                                </td>    --}}

                                                <td>
                                                    {{$purchase->supplier?->name ?? '-' }}
                                                </td>

                                                <td>{{ $item->item?->name ?? '-' }}</td>
                                                <td>{{ $item->quantity ?? 0 }}</td>
                                                <td>Rs. {{ number_format($item->rate ?? 0, 2) }}</td>
                                                <td>Rs. {{ number_format($item->subtotal, 2) }}</td>
                                            </tr>
                                        @endforeach
                                    @else
                                        <tr>
                                            <td>{{ \Carbon\Carbon::parse($purchase->date)->format('d/m/Y') }}</td>
                                            <td>{{ $purchase->supplier?->name ?? '-' }}</td>
                                            <td colspan="4" class="text-center">No items</td>
                                        </tr>
                                    @endif

                                @empty
                                    <tr>
                                        <td colspan="6" class="text-center">No purchase found.</td>
                                    </tr>
                                @endforelse
                            </tbody>

                            <tfoot>
                                <tr>
                                    <td colspan="4"><b>Total</b></td>
                                    <td><b>Rs. {{ number_format($grandTotal, 2) }}</b></td>
                                </tr>
                            </tfoot>
                        </table>


                        <div class="report-section-title">PAYMENT TO SUPPLIER</div>

                        <table class="report-table">
                            <thead>
                                <tr>
                                    {{-- <th width="12%">Date</th> --}}
                                    <th>Supplier</th>
                                    <th>Mode of payment</th>
                                    <th>Amount</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($wallets as $wallet)
                                    <tr>
                                        {{-- <td>{{ \Carbon\Carbon::parse($wallet->date)->format('d/m/Y') }}</td> --}}
                                        <td>{{ $wallet->supplier?->name ?? '-' }}</td>
                                        <td>{{ $wallet->note }}</td>
                                        <td>{{ $wallet->amount }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="3" class="text-center">No purchase found.</td>
                                    </tr>
                                @endforelse
                            </tbody>
                            <tfoot>
                                <td colspan="2"><b>Total</b></td>
                                <td >{{$wallets->sum('amount')}}</td>
                            </tfoot>
                        </table>

                        <br>
                        {{-- <div class="summary-line">Total Supplier Amount: Rs. {{ number_format($wallets->sum('amount'), 2) }}</div> --}}
                        {{-- <div class="summary-line">Total Quantity Purchased: {{ number_format($totalPurchaseQty, 0) }}</div>
                        <div class="summary-line">Total Quantity Sold: {{ number_format($totalSoldQty, 0) }}</div> --}}

                        <hr>

                        {{-- <div style="text-align:center;font-size:12px;margin-top:10px;">
                            Generated on {{ $date ?? '' }}
                        </div> --}}

                    </div>

                </div>
            </div>

        </div>
    </section>
</div>
@endsection