@extends('layouts.app')

@section('content')

<!-- start page title -->
<div class="row">
    <div class="col-12">
        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
            <h4 class="mb-sm-0 font-size-18">Customer Detailed Statement </h4> 

            <div class="page-title-right">
                <ol class="breadcrumb m-0">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboards</a></li> 
                    <li class="breadcrumb-item">Reports</li>
                    <li class="breadcrumb-item active">Customer Detailed Statement </li>
                </ol>
            </div>

        </div>
    </div>
</div>
<!-- end page title -->
@include('validate')
<div class="row">

    <div class="col-md-12">

        <div class="card">
            <div class="card-body">
                <h4 class="card-title mb-4">Customer Detailed Statement</h4>


                <form method="POST" action="{{ route('report.customerstatement.search') }}">
                <div class="row mb-4 mt-4"> 

                    <div class="col-md-3">
                        <div class="mb-3">
                             <div class="input-group" id="from_date">
                                <input type="text" name="from_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#from_date' data-provide="datepicker" placeholder="From Date" required>
                                <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                            </div><!-- input-group --> 
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="mb-3">
                              <div class="input-group" id="to_date">
                                <input type="text" name="to_date" class="form-control" data-date-format="{{ js_app_date_format() }}" data-date-container='#to_date' data-provide="datepicker" placeholder="To Date" required>
                                <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                            </div><!-- input-group --> 
                        </div>
                    </div>

                      <div class="col-md-6">
                        <select class="form-control" name="branch_id" id="branch_id" required> 
                            <option value="">Branch</option>
                            @foreach ($branchData as $branch)
                             <option value="{{ $branch->id }}" @if(isset($req_data['branch_id']) && ($req_data['branch_id'] == $branch->id)) @selected(true) @endif>{{ $branch->branch_name }}</option>    
                            @endforeach
                            
                        </select>
                      </div>

                      <div class="col-md-6">
                        <select class="form-control" name="customer_id" id="customer_id" required>
                            <option value="">Customer</option>
                            @foreach ($customerData as $customer)
                             <option value="{{ $customer->id }}" @if(isset($req_data['customer_id']) && ($req_data['customer_id'] == $customer->id)) @selected(true) @endif>{{ $customer->customer_name }}</option>    
                            @endforeach
                            
                        </select>
                      </div>

                       

                      <div class="col-md-2">
                        @csrf
                        <button class="btn btn-info" type="submit">SEARCH</button>
                      </div>


                </div>
            </form>


                
            <div class="table-responsive">

                <table class="table table-striped">
                   <thead>
                    <tr>
                      <th>Date</th>
                      <th>Particulars</th>
                      <th>Narration</th>
                      <th>Payment Mode</th>
                      <th>Debit</th>
                      <th>Credit</th> 
                    </tr>
                   </thead>
                   <tbody>

                    <tr>
                      <td colspan="2">Openning Balance</td>
                      <td></td>
                      <td></td>
                      <td align="right">@if($obBalance > 0) {{ number_format($obBalance,2) }} @endif</td>
                      <td align="right">@if($obBalance <= 0) {{ number_format($obBalance,2) }} @endif</td> 
                    </tr>


                    @forelse ($ledgerTransactionsList as $ledger)
                     <tr>
                        <td>{{ $ledger->trans_date->format(app_date_format()) }}</td>
                        <td>
                           @if($ledger->transaction_type == 'invoice') 
                            Invoice : {{ $ledger->invoice->reference_no ?? '' }}
                           @elseif($ledger->transaction_type == 'receipt')
                            Receipt : {{ $ledger->receipt->reference_no ?? '' }}
                           @elseif($ledger->transaction_type == 'purchase')
                            Purchase : {{ $ledger->purchase->reference_no ?? '' }}
                           @elseif($ledger->transaction_type == 'payment')
                             Payment : {{ $ledger->payment->reference_no ?? '' }}
                           @endif
                        </td>
                        <td>
                            @if($ledger->transaction_type == 'receipt' || $ledger->transaction_type == 'payment')
                           {{ $ledger->receipt->notes ?? '' }} 
                           @endif

                        </td>
                        <td>
                            @if($ledger->transaction_type == 'receipt' || $ledger->transaction_type == 'payment')
                            {{ $ledger->receipt->paymentmode->mode_title ?? '' }} 
                            @endif
                        </td>
                        <td align="right">@if($ledger->debit > 0) {{ number_format($ledger->debit,2) }} @endif </td>
                        <td align="right">@if($ledger->credit > 0) {{ number_format($ledger->credit,2) }} @endif </td>
                     </tr>
                    @empty
                    <tr>
                        <td colspan="5">@lang('general.no_details_found')</td>
                     </tr>
                    @endforelse

                     <tr>
                        <td colspan="2">Closing Balance</td>
                        <td></td>
                        <td></td>
                        <td align="right">@if($closingBalance > 0) {{ number_format($closingBalance,2) }} @endif</td>
                        <td align="right">@if($closingBalance <= 0) {{ number_format($closingBalance,2) }} @endif</td> 
                     </tr>
                     
                   </tbody>

                </table>


            </div>
                
            </div>
            <!-- end card body -->
        </div>

    </div>

</div>


@endsection