@extends('admin.master')
@section('title', 'Customer Ledger Statement')
@section('content')

<div class="container-fluid">
    <div class="row bg-title">
        <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12">
            <ol class="breadcrumb">
                <li class="active breadcrumbColor"><a href="{{ url('dashboard') }}"><i class="fa fa-home"></i> Dashboard</a></li>
                <li><a href="{{ route('customer.index') }}">Customer List</a></li>
                <li>Ledger</li>
            </ol>
        </div>
        <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12">
            <button onclick="window.print()" class="btn btn-info pull-right m-l-20"><i class="fa fa-print"></i> Print Ledger</button>
            <a href="{{ route('customer.index') }}" class="btn btn-default pull-right"><i class="fa fa-arrow-left"></i> Back</a>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            <div class="panel panel-info">
                <div class="panel-heading"><i class="fa fa-file-text-o"></i> Ledger: {{ $customer->name }}</div>
                <div class="panel-wrapper collapse in" aria-expanded="true">
                    <div class="panel-body">
                        
                        <div class="row m-b-20">
                            <div class="col-md-6">
                                <h4><strong>Customer Details</strong></h4>
                                <p><strong>Name:</strong> {{ $customer->name }}</p>
                                <p><strong>Mobile:</strong> {{ $customer->mobile }}</p>
                                <p><strong>Address:</strong> {{ $customer->address ?? 'N/A' }}</p>
                            </div>
                            <div class="col-md-6 text-right">
                                <h4><strong>Statement Summary</strong></h4>
                                <h3 class="text-danger">Total Due: {{ number_format( ($opening_balance + $ledger->sum('debit')) - $ledger->sum('credit') , 2) }}</h3>
                            </div>
                        </div>

                        <div class="table-responsive">
                            <table class="table table-bordered table-striped">
                                <thead style="background: #f4f8fb;">
                                    <tr>
                                        <th>Date</th>
                                        <th>Description</th>
                                        <th class="text-right">Bill Amount (Debit)</th>
                                        <th class="text-right">Paid Amount (Credit)</th>
                                        <th class="text-right">Balance</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    {{-- ওপেনিং ব্যালেন্স লাইন --}}
                                    <tr class="font-weight-bold" style="background: #eef5f9;">
                                        <td>-</td>
                                        <td><strong>Opening Balance / Previous Due</strong></td>
                                        <td class="text-right"><strong>{{ number_format($opening_balance, 2) }}</strong></td>
                                        <td class="text-right">0.00</td>
                                        <td class="text-right text-danger"><strong>{{ number_format($opening_balance, 2) }}</strong></td>
                                    </tr>

                                    @php $running_balance = $opening_balance; @endphp

                                    @foreach($ledger as $item)
                                        @php 
                                            // ব্যালেন্স হিসেব করা হচ্ছে
                                            $running_balance += $item->debit;
                                            $running_balance -= $item->credit;
                                        @endphp
                                        <tr>
                                            <td>{{ $item->date ? date('d-M-Y', strtotime($item->date)) : '-' }}</td>
                                            <td>{{ $item->description }}</td>
                                            <td class="text-right text-danger">{{ $item->debit > 0 ? number_format($item->debit, 2) : '-' }}</td>
                                            <td class="text-right text-success">{{ $item->credit > 0 ? number_format($item->credit, 2) : '-' }}</td>
                                            <td class="text-right font-weight-bold">{{ number_format($running_balance, 2) }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<style>
    @media print {
        .bg-title, .breadcrumb, .btn { display: none !important; }
        .panel { border: none !important; box-shadow: none !important; }
    }
</style>

@endsection