@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">Day Book</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">Day Book</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">Day Book</h4>


                <form method="POST" action="{{ route('report.daybook') }}">
                    <div class="row mb-4 mt-4"> 
    
                        <div class="col-md-4">
                            <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" autocomplete="off" value="{{ date('d-m-Y',strtotime($from_date)) }}" required>
                                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                                </div><!-- input-group --> 
                            </div>
                        </div> 

                        <div class="col-md-4">
                            <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" autocomplete="off" value="{{ date('d-m-Y',strtotime($to_date)) }}" required>
                                    <span class="input-group-text"><i class="mdi mdi-calendar"></i></span>
                                </div><!-- input-group --> 
                            </div>
                        </div> 

                        <div class="col-md-4">
                            <div class="mb-3">
                            <select class="form-control" name="party_type" id="party_type">
                                <option value="">Type</option>
                                <option value="customer">Customer</option>
                                <option value="supplier">Supplier</option>
                            </select>
                            </div>
                          </div>

                          <div class="col-md-4 d-none" id="supplierdiv">
                            <div class="mb-3">
                            <select class="form-control select2" name="supplier_id" id="supplier_id" data-width="100%">
                                <option value="">Supplier</option>
                                @foreach ($supplierData as $supplier)
                                <option value="{{ $supplier->id }}">{{ $supplier->supplier_name }}</option>
                                @endforeach
                            </select>
                            </div>
                          </div>
    
                          <div class="col-md-4 d-none" id="customerdiv">
                            <div class="mb-3">
                            <select class="form-control select2" name="customer_id" id="customer_id" data-width="100%">
                                <option value="">Customer</option>
                                @foreach ($customerData as $customer)
                                <option value="{{ $customer->id }}">{{ $customer->customer_name }}</option>
                                @endforeach
                            </select>
                            </div>
                          </div> 
    
                          <div class="col-md-12">
                            @csrf
                            <button class="btn btn-info float-end" type="submit">SEARCH</button>
                          </div>
    
    
                    </div>
                </form>


                <div class="table-responsive">
                      @php $totalDebit=0; $totalCredit=0; @endphp
                    <table class="table table-striped">
                       <thead>
                        <tr>
                          <th>Particulars</th>
                          <th class="txtright">Debit</th>  
                          <th class="txtright">Credit</th>  
                        </tr>
                       </thead>
                       <tbody>
                        <tr>
                         <td colspan="3"><b>Purchase</b></td> 
                        </tr>
                        @foreach ($purchaseList as $purchase)
                        <tr>
                           <td>{{ $purchase->supplier->supplier_name }}</td>
                           <td class="txtright"></td>
                           <td class="txtright">{{ number_format($purchase->total_grand_total,2) }} @php $totalCredit+=$purchase->total_grand_total; @endphp </td>
                        </tr>
                        @endforeach
                        
                        <tr>
                            <td colspan="3"><b>Sales</b></td> 
                           </tr>
                           @foreach ($invoiceList as $invoice)
                           <tr>
                            <td>{{ $invoice->customer->customer_name }}</td>
                            <td class="txtright">{{ number_format($invoice->total_grand_total,2) }}  @php $totalDebit+=$invoice->total_grand_total; @endphp </td>
                            <td class="txtright"></td>
                         </tr>
                           @endforeach
                           <tr>
                            <td colspan="3"><b>Payments</b></td> 
                           </tr>
                           @foreach ($paymentsList as $payment)
                            <tr>
                                 <td>
                                  @if($payment->party_type == 'customer')
                                    {{ $payment->customer->customer_name }}
                                  @elseif($payment->party_type == 'supplier')
                                  {{ $payment->supplier->supplier_name }}
                                  @endif
                                 </td>
                                 <td class="txtright"> @if($payment->party_type == 'supplier') {{ number_format($payment->total_grand_total,2) }} @php $totalDebit+=$payment->total_grand_total; @endphp @endif </td>
                                 <td class="txtright">@if($payment->party_type == 'customer') {{ number_format($payment->total_grand_total,2) }} @php $totalCredit+=$payment->total_grand_total; @endphp @endif</td>
                            </tr>
                           @endforeach
                           <tr>
                            <td colspan="3"><b>Receipts</b></td> 
                           </tr>
                           @foreach ($receiptsList as $receipt)
                            <tr>
                                 <td>
                                  @if($receipt->party_type == 'customer')
                                    {{ $receipt->customer->customer_name }}
                                  @elseif($receipt->party_type == 'supplier')
                                  {{ $receipt->supplier->supplier_name }}
                                  @endif
                                 </td>
                                 <td class="txtright"> @if($receipt->party_type == 'supplier') {{ number_format($receipt->total_grand_total,2) }} @php $totalDebit+=$receipt->total_grand_total; @endphp @endif</td>
                                 <td class="txtright">  @if($receipt->party_type == 'customer') {{ number_format($receipt->total_grand_total,2) }} @php $totalDebit+=$receipt->total_grand_total; @endphp @endif </td>
                            </tr>
                           @endforeach
                           <tr>
                            <td class="txtright"><b>Total</b></td>
                            <td class="txtright">{{ number_format($totalDebit,2) }}</td>
                            <td class="txtright">{{ number_format($totalCredit,2) }}</td>
                           </tr>
                           <tr>
                            @php $cloBalance=$totalDebit-$totalCredit; @endphp
                            <td class="txtright"><b>Closing Balance</b></td>
                            <td class="txtright">@if($cloBalance > 0) {{ number_format($cloBalance,2) }} @endif</td>
                            <td class="txtright">@if($cloBalance < 0) {{ number_format(abs($cloBalance),2) }} @endif</td>
                           </tr>
                       </tbody>

                    </table>


                </div>

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

    </div>

</div>


@endsection



@push('scripts')

<script>

$('.select2').select2();  


$(document).ready(function () {

$('#party_type').change(function () {

    var partyType=$(this).val();

    if(partyType == 'customer'){

        $( "#supplierdiv" ).addClass("d-none");
        $( "#customerdiv" ).removeClass("d-none");


    } else if(partyType == 'supplier') {

        $( "#supplierdiv" ).removeClass("d-none");
        $( "#customerdiv" ).addClass("d-none");
    } else {

        $( "#supplierdiv" ).addClass("d-none");
        $( "#customerdiv" ).addClass("d-none");
    }


});

});
</script>

@endpush