@extends('admin.layout.master')
@section('title','TRAIL BALANCE STATEMENT')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number] {
    height: 35px !important;
}
</style> 
@endsection
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'TRAIL BALANCE STATEMENT (DETAILS)'])
    
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.trail_balance_statement')}}" method="get">
            @include('accounts.reports.search_form',['ledger'=>0])
        </form>
    </div>
                    
    <div class="card-body"  style="padding-top:2px" id="divTableDataHolder">
        {{-- @if(Request()->ledger_id) --}}
        <div class="row">
            <div class="col-md-12">          
                
                <div class="card-box">
                   
                     @php
                        $printData['start_date']=Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y');
                        $printData['end_date']=Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y');
                        $routeName=Route::currentRouteName();   
                        $printData=getPrintData($routeName,$printData);
                    @endphp
                     <style type="text/css">{!!$printData['style_css']!!}</style>
                     {!!$printData['head']!!}
                    <div class="card-body">
                        <div class="row">
                            
                            <div class="col-md-12 table-responsive-sm" style="padding-bottom: 15px;">
                                <div class="pro_trans_table">
                                    <table  class="display table table-bordered" id="dynamic-table" >
                                        <thead>
                                            <tr>
                                                <th style="border:1px solid;" class="text-center" colspan="3">Perticulars</th>
                                                <th style="border:1px solid;" class="text-center" colspan="2">Balance Before<br>{{ date('d-m-y',strtotime(Request()->start_date))}}</th>
                                                <th style="border:1px solid;" class="text-center" colspan="2">Transaction<br>
                                                    {{ date('d-m-y',strtotime(Request()->start_date)).' To '.date('d-m-y',strtotime(Request()->end_date))}}</th>
                                                <th style="border:1px solid;" class="text-center" colspan="2">Balance<br>
                                                    {{ 'AT '.date('d-m-y',strtotime(Request()->end_date))}}</th>
                                            </tr>
                                            <tr>
                                                <th style="border:1px solid;">SL</th>
                                                <th style="border:1px solid;">Account No</th>
                                                <th style="border:1px solid;">Account Name</th>
                                                <th style="border:1px solid;">Debit</th>
                                                <th style="border:1px solid;">Credit</th>
                                                <th style="border:1px solid;">Debit</th>
                                                <th style="border:1px solid;">Credit</th>
                                                <th style="border:1px solid;">Debit</th>
                                                <th style="border:1px solid;">Credit</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                        @php 
                                            $total_b_dr_amount=0;
                                            $total_b_cr_amount=0;
                                            $total_dr_amount=0;
                                            $total_cr_amount=0;
                                            $total_e_dr_amount=0;
                                            $total_e_cr_amount=0; 
                                        @endphp
                                            @forelse ($ledgers as $k=>$ledger)
                                            @if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced) || array_key_exists($ledger->id,$ledgerWiseBalance) || array_key_exists($ledger->id,$ledgerWiseEndingBalance))
                                                <tr>
                                                    @php
                                                        $b_dr_amount=0;
                                                        $b_cr_amount=0;
                                                        $dr_amount=0;
                                                        $cr_amount=0;
                                                        $e_dr_amount=0;
                                                        $e_cr_amount=0;
                                                        if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced)){
                                                                $name=$ledgerWiseBeginningBalanced[$ledger->id]['name'];
                                                                if($ledgerWiseBeginningBalanced[$ledger->id]['amount']>0){
                                                                    $b_dr_amount=$ledgerWiseBeginningBalanced[$ledger->id]['amount'];
                                                                }else{
                                                                $b_cr_amount=abs($ledgerWiseBeginningBalanced[$ledger->id]['amount']);
                                                                }
                                                                //$b_cr_amount=($ledgerWiseBeginningBalanced[$ledger->id]['amount']<0)?abs($ledgerWiseBeginningBalanced[$ledger->id]['amount']):0;
                                                            
                                                        }
                                                            if(array_key_exists($ledger->id,$ledgerWiseBalance)){
                                                            $name=$ledgerWiseBalance[$ledger->id]['name'];
                                                            if($ledgerWiseBalance[$ledger->id]['amount']>0){
                                                                    $dr_amount=$ledgerWiseBalance[$ledger->id]['amount'];
                                                                }else{
                                                                $cr_amount=abs($ledgerWiseBalance[$ledger->id]['amount']);
                                                                }
                                                        }
                                                            if(array_key_exists($ledger->id,$ledgerWiseEndingBalance)){
                                                            $name=$ledgerWiseEndingBalance[$ledger->id]['name'];
                                                            if($ledgerWiseEndingBalance[$ledger->id]['amount']>0){
                                                                    $e_dr_amount=$ledgerWiseEndingBalance[$ledger->id]['amount'];
                                                                }else{
                                                                $e_cr_amount=abs($ledgerWiseEndingBalance[$ledger->id]['amount']);
                                                                }
                                                        }

                                                        $total_b_dr_amount+=$b_dr_amount;
                                                        $total_b_cr_amount+=$b_cr_amount;
                                                        $total_dr_amount+=$dr_amount;
                                                        $total_cr_amount+=$cr_amount;
                                                        $total_e_dr_amount+=$e_dr_amount;
                                                        $total_e_cr_amount+=$e_cr_amount;
                                                    @endphp
                                                    <th>{{ $k++ }}</th>
                                                    <th>{{$ledger->auto_code}}</th>
                                                    <th> {{$name}}</th>
                                                    <th class="text-right">{{ number_format($b_dr_amount??0,2) }}</th>
                                                    <th class="text-right">{{ number_format($b_cr_amount??0,2) }}</th>
                                                    <th class="text-right">{{ number_format($dr_amount??0,2) }}</th>
                                                    <th class="text-right">{{ number_format($cr_amount??0,2) }}</th>
                                                    <th class="text-right">{{ number_format($e_dr_amount??0,2) }}</th>
                                                    <th class="text-right">{{ number_format($e_cr_amount??0,2) }}</th>
                                                    
                                                </tr>
                                            @endif
                                            @empty
                                            @endforelse
                                                
                                            
                                            
                                        </tbody>
                                        <tfoot>
                                            <tr>

                                            <th colspan="3"> Total Transaction</th>
                                                <th class="text-right">{{ number_format($total_b_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($total_b_cr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($total_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($total_cr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($total_e_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($total_e_cr_amount??0,2) }}</th>
                                                    
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>

                            </div>
                            
                        </div>
                    </form>
                    {{-- <button type="button"  class="btn btn-primary btn-sm" onclick="hideBox()">
                        <span class="fa fa-refresh"></span>
                    </button> --}}
                    </div>
                </div>
            {{-- </form> --}}
            </div>
        </div>
        {{-- @endif --}}
    </div>
</div>
           
@endsection
@section('script')
<script>
$('#cost_center_id').select2();
</script>
@stop