@extends('layouts.adminapp')
@section('content')

{{-- Day Book --}}
<x-app-flash/>
    <h1 class="h3 mb-2 text-gray-800">{{__('lng.DayBook')}}</h1>
    
    <!-- DataTales Example -->
    <div class="card shadow mb-4">
        <div class="container">
            <form action="{{route('DayBook')}}" method="GET">
            <div class="row py-3">
                <div class="col-sm-3 form-group">
                    <label for="dtFrom">{{__('lng.FromDate')}}</label>
                    <input type="date"  value="{{$DateFrom}}" class="form-control" name="from_dt" id="dtFrom"/>
                </div>
                <div class="col-sm-3">
                    <label for="dtTo">{{__('lng.ToDate')}}</label>
                    <input type="date"  value="{{$DateTo}}" class="form-control" name="to_dt" id="dtTo"/>
                </div>
                <div class="col-sm-4">
                    <label for="cbHead">{{__('lng.Ledger')}}</label>
                    <select class="form-control" id="cbLedger" name="ledeger_id" >
                        @php
                            echo App\Http\Controllers\AccountLedgerController::AccountLedgerListForComboDayBook($LedgerID);
                        @endphp
                    </select>
                </div>
                <div class="col-sm-2">
                    <button  class="btn btn-primary" type="submit" style="margin-top:30px;">
                        <span class="icon text-white-50">
                            <i class="fas fa-search"></i>
                        </span>
                        <span class="text">{{__('lng.Search')}}</span>
                    </button>
                </div>
                
                <div class="form-check mr-2">
                    <input class="form-check-input" type="radio" value="1" name="DetailedSummery" id="Detailed" @if ($Detailed) checked @endif>
                    <label class="form-check-label" for="Detailed">
                        {{__('lng.Detailed')}}
                    </label>
                  </div>
                  <div class="form-check">
                    <input class="form-check-input" type="radio" value="0" name="DetailedSummery" id="Summery" @if (!$Detailed) checked @endif>
                    <label class="form-check-label" for="Summery">
                        {{__('lng.Summery')}}
                    </label>
                  </div>
                {{-- <div class="form-check m-2">
                  <input class="form-check-input" type="checkbox" value="0" id="Detailed" onclick="Detailed()">
                  <label class="form-check-label" for="Detailed">
                      {{__('lng.Detailed')}}
                  </label>
                </div> --}}
            </div>
        </form>
        </div>
    </div>
    <div class="card shadow mb-4">
        <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
            <h6 class="m-0 font-weight-bold text-primary">{{__('lng.ReportTable')}}</h6>
            
        </div>
        <div id="dataTable">
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered" width="100%" cellspacing="0">
                        @php $si=$TotalDebit=$TotalCredit=0; @endphp
                        <thead>
                            <tr>
                                <td>{{ __('lng.OpeningBalance') }}</td>
                                <td colspan="7">
                                    @if ($OpeningBalance >= 0)
                                        @currency($OpeningBalance) DR
                                        @php
                                            $TotalDebit = $OpeningBalance;
                                        @endphp
                                    @else
                                        @currency(abs($OpeningBalance)) CR
                                        @php
                                            $TotalCredit = abs($OpeningBalance);
                                        @endphp
                                    @endif
                                </td>
                            </tr>
                            <tr>
                                <th>{{ __('lng.SiNo') }}</th>
                                <th>{{ __('lng.Date') }}</th>
                                <th>{{ __('lng.Invoice') }}</th>
                                <th>{{ __('lng.VoucherType') }}</th>
                                <th>{{ __('lng.VoucherNumber') }}</th>
                                <th>{{ __('lng.Ledger') }}</th>
                                <th>{{ __('lng.Debit') }}</th>
                                <th>{{ __('lng.Credit') }}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($LedgerPostingsPagination as $LedgerPosting)
                                <tr>
                                    @php $DTs =  date("d-m-Y",strtotime($LedgerPosting->date)); @endphp
                                    <td>{{ ++$si }}</td>
                                    <td>{{ $DTs }}</td>
                                    <td>{{ $LedgerPosting->invoicenumber }}</td>
                                    <td>{{ $LedgerPosting->vouchertype->title }}</td>
                                    <td>{{ $LedgerPosting->vouchernumber }}</td>
                                    <td>{{ $LedgerPosting->accountledger->title }}</td>
                                    <td>@currency($LedgerPosting->debit)</td>
                                    <td>@currency($LedgerPosting->credit)</td>
                                </tr>
                            @endforeach
            
                        </tbody>
                    </table>
                </div>
                <div class=" table-responsive mt-2">
                    {{$LedgerPostingsPagination->appends($_GET)->links()}}
                </div>
            </div>
            
            {{--END  DAY BOOK DATA SECTION --}}

        </div>
    </div>

    <div class="card shadow mb-4">
        <div class="container">
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-bordered" width="100%" cellspacing="0">
                        @foreach ($LedgerPostings as $Amount)
                            @php
                                $TotalDebit += $Amount->debit;
                                $TotalCredit += $Amount->credit;
                            @endphp
                        @endforeach
                        <tr>
                            <td style="text-align: right">{{__('lng.TotalDebit')}}</td>
                            <td>@currency($TotalDebit)</td>
                            <td style="text-align: right">{{__('lng.TotalCredit')}}</td>
                            <td>@currency($TotalCredit)</td>
                        </tr>
                        <tr>
                            <td colspan="3" style="text-align: right">{{ __('lng.ClosingBalance') }}</td>
                            <td>
                                @if ($TotalDebit - $TotalCredit >= 0)
                                    @currency($TotalDebit - $TotalCredit) DR
                                @else
                                    @currency(abs($TotalDebit - $TotalCredit)) CR
                                @endif
                            </td>
                        </tr>
        
                    </tbody>
                </table>
                </div>
            </div>
        </div>

            {{--START  DAY BOOK PRINT AND EXPORT SECTION --}}


            <div class="card-footer">
                <div class="d-flex  justify-content-end p-2">
                    <form method="POST" action="{{ route('ReportExcel') }}">
                        @csrf
                        
                        <input type="hidden" name="subhead" value="DayBook">
                        <input type="hidden" name="Search[]" value="Date">
                        <input type="hidden" name="Search[]" value="{{$DateFrom}} - {{$DateTo}}">
                        <input type="hidden" name="Search[]" value="Ledger">
                        <input type="hidden" name="Search[]" value="{{$Ledger}}">
                            
                        @php $no=0; @endphp
                        @foreach ($LedgerPostings as $LedgerPosting)
                        @php $DTs =  date("d-m-Y",strtotime($LedgerPosting->date)); @endphp 
                        <input type="hidden" name="arr[id][]" value="{{++$no}}">
                        <input type="hidden" name="arr[Date][]" value="{{$DTs}}">
                        <input type="hidden" name="arr[Invoice][]" value="{{$LedgerPosting->invoicenumber}}">
                        <input type="hidden" name="arr[VoucherType][]" value="{{$LedgerPosting->vouchertype->title }}">
                        <input type="hidden" name="arr[VoucherNumber][]" value="{{$LedgerPosting->vouchernumber}}">
                        <input type="hidden" name="arr[Ledger][]" value="{{$LedgerPosting->accountledger->title}}">
                        <input type="hidden" name="arr[Debit][]" value="@currency($LedgerPosting->debit)">
                        <input type="hidden" name="arr[Credit][]" value="@currency($LedgerPosting->credit)">
                        @endforeach
                        <input type="hidden" name="arr[Ledger][]" value="Total">
                        <input type="hidden" name="arr[Debit][]" value="@currency($TotalDebit)">
                        <input type="hidden" name="arr[Credit][]" value="@currency($TotalCredit)">
                        <input type="hidden" name="arr[Debit][]" value="{{ __('lng.ClosingBalance') }}">
                        <input type="hidden" name="arr[Credit][]" value="@currency(abs($TotalDebit - $TotalCredit))">
            
                        <input type="hidden" name="total[]" value="OpeningBalance">
                        <input type="hidden" name="total[]" value="@currency(abs($OpeningBalance))">
            
                        <button 
                        @if (!$LedgerPostings->count())
                            disabled
                        @endif
                         type="submit" class="btn btn-success btn-icon-split mr-2">
                            <span class="icon text-white-50">
                                <i class="fas fa-file-export"></i>
                            </span>
                            <span class="text">{{ __('lng.Export') }}</span>
                        </button>
                    </form>
                    <form method="POST" action="{{ route('DayBookPrint') }}" enctype='multipart/form-data'>
                        @csrf
                        <input type="hidden" name="from" id="FromDate" value="{{$DateFrom}}">
                        <input type="hidden" name="to" id="ToDate" value="{{$DateTo}}">
                        <input type="hidden" name="ledger_id" id="LedgerID" value="{{$LedgerID}}">
                        <input type="hidden" name="detailed_summery" value="{{$Detailed}}">
                        <button 
                        @if (!$LedgerPostings->count())
                            disabled
                        @endif
                        type="submit" class="btn btn-info btn-icon-split">
                            <span class="icon text-white-50">
                                <i class="fas fa-print"></i>
                            </span>
                            <span class="text">{{ __('lng.Print') }}</span>
                        </button>
                    </form>
                </div>
            </div>

            {{--END  DAY BOOK PRINT AND EXPORT SECTION --}}
    </div>

{{-- <script>
    // SearchDayBook();
    function SearchDayBook() {
        var From = document.getElementById('dtFrom').value;
        var To = document.getElementById('dtTo').value;
        var Ledger = document.getElementById('cbLedger').value;
        var DetailedSummery=document.getElementsByName('DetailedSummery');
        var Detailed=0;
        for(i = 0; i < DetailedSummery.length; i++) {
                if(DetailedSummery[i].checked){
                Detailed=DetailedSummery[i].value;
            }
        }
        $.ajax({
            url: '{{ route('DayBookSearch') }}',
            method: "get",
            data: {_token: '{{ csrf_token() }}',from:From,to:To,ledger:Ledger,Detailed:Detailed},
            success: function (response){  
                document.getElementById('dataTable').innerHTML=response; 
            }
        }); 
    }

    function Detailed(Value){
        var Detailed=document.getElementById('Detailed').value;
        if(Detailed == 0){
            document.getElementById('Detailed').value=1;
        }else{
            document.getElementById('Detailed').value=0;
        }
    }
</script> --}}

@endsection