@extends('admin.layout.master')
@section('title','GORUP LEDGER DETAILS 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'])
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.group_legder_details')}}" method="get">
            @include('accounts.reports.search_form',['ledger'=>1])
            {{-- <div class="row mb-0 mt-0 pt-2"  style="border:dashed 1px green">
                <div class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-1">
                    <div class="col-3 px-0">
                        <label for="cost_id">LEDGER</label>
                    </div>
                    <div class="col-8 px-0">
                        <select name="ledger_id" id="ledger_id" required>
                            @forelse ($ledgers as $ledger)   
                            <option value="{{$ledger->id}}">{{ $ledger->name.' - '.$ledger->auto_code}}</option>
                            @empty
                                
                            @endforelse
                        </select>
                    </div>
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    <div class="col-5 px-0">
                        <label for="pay_type">C CENTER</label>
                    </div>
                    <div class="col-7 px-0">
                        <select name="cost_center_id" id="cost_center_id">
                            <option value="0">{{ 'ALL' }}</option>
                            @forelse ($cost_centers as $cost_center)   
                            <option value="{{$cost_center->id}}">{{ $cost_center->name }}</option>
                            @empty
                            @endforelse
                        </select>
                    </div>
                </div>
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    <div class="col-5 px-0">
                        <input type="date" class="form-control" name="start_date" value="{{Request()->start_date?date('Y-m-d',strtotime(Request()->start_date)):date('Y-m-d')}}">
                    </div>
                    <div class="col-2 px-0 text-center">
                        <label for="cost_id">TO</label>
                    </div>
                    <div class="col-5 px-0">
                        <input type="date" class="form-control" name="end_date" value="{{Request()->end_date?date('Y-m-d',strtotime(Request()->end_date)):date('Y-m-d')}}">
                    </div>
                </div>
                <div class="col-md-2 col-12 d-flex flex-wrap pr-0 mb-1">
                    <div class="col-12 px-0">
                        <div class="input-group">
                            <span class="input-group-text">Search</span>
                            <div class="input-group-append">
                                <button type="submit" class="btn btn-danger">
                                <span class="fa fa-search"></span>
                                </button>
                            </div>

                        </div>
                    </div>
                </div>
                
            </div> --}}
        </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">
                    {{-- <h3 class="card-title text-center">
                        
                        
                        {{'GROUP LEDGER DETAILS'}}

                    </h3>
                    <h5 class="card-title text-center">{{ 'From '.(Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y')).' To '.(Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y'))}}</h5>
                     --}}
                     @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,[]);
                    @endphp
                 {!!$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 colspan="9" class="th" style="text-align:right;padding:2px;">
                                                    {{date('d-M-Y h:i:s')}}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th colspan="9" class="th" style="text-align:center;padding:2px;">
                                                    {{active_branch_info()->name}}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th colspan="9" class="th" style="text-align:center;padding:2px;">
                                                    {{active_branch_info()->address}}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th colspan="9" class="th" style="text-align:center;padding:2px;">
                                                    {{active_branch_info()->phone}}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th colspan="9" class="th" style="text-align:center;padding:2px;">
                                                    <span class="highlight_vtitle">
                                                        GROUP LEDGER DETAILS
                                                    </span>
                                                </th>
                                            </tr> 
                                            <tr>
                                                <th colspan="9" class="th" style="text-align:center;padding:2px;">
                                                    {{ 'From '.date('d-M-Y',strtotime(Request()->start_date)).' To '.date('d-M-Y',strtotime(Request()->end_date))}}
                                                </th>
                                            </tr>
                                            <tr>
                                                <th class="th" colspan="9">
                                                    <hr class="hr" />
                                                </th>
                                            </tr> --}}
                                            <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 
                                            $lk=1; 
                                            $grand_total_b_dr_amount=0;
                                            $grand_total_b_cr_amount=0;
                                            $grand_total_dr_amount=0;
                                            $grand_total_cr_amount=0;
                                            $grand_total_e_dr_amount=0;
                                            $grand_total_e_cr_amount=0; 
                                        @endphp
                                            <tr>
                                                <th colspan="9" class="text-center text-white" style="background-color:#2D6161">
                                                    
                                                    @if(count($ledgers->where('id', Request()->ledger_id))>0)
                                                        {{$ledgers->where('id', Request()->ledger_id)->first()->name}}
                                                    @else
                                                        {{'ledger not found'}}
                                                    @endif
                                                </th>
                                            </tr>
                                            @forelse ($searchedLedger->child as $childledger)
                                            @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
                                            <tr>
                                                
                                                <th class="text-center text-white" style="background-color:#2D6161">
                                                        {{$lk++}}
                                                </th>
                                                <th class="text-center text-white" style="background-color:#2D6161">
                                                        {{$childledger->auto_code}}
                                                </th>
                                                <th class="text-left text-white" style="background-color:#2D6161">
                                                    <a href="{{route('reports.group_legder_details',['ledger_id'=>$childledger->id,'cost_center_id'=>Request()->cost_center_id,'start_date'=>Request()->start_date,'end_date'=>Request()->end_date])}}">
                                                        {{$childledger->name}}
                                                    </a>
                                                </th>
                                                @php
                                               
                                                $pattern = "/".$childledger->auto_code."/i";
                                                $searchedLedgers=collect($searchedLedgersChild)->filter(function ($item) use ($pattern) {
                                                        return preg_match($pattern, $item->auto_code);
                                                    });
                                                @endphp
                                                @forelse ($searchedLedgers as $k=>$ledger)
                                                    @if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced) || array_key_exists($ledger->id,$ledgerWiseBalance) || array_key_exists($ledger->id,$ledgerWiseEndingBalance))
                                                       
                                                       
                                                            @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']);
                                                                    }
                                                                }
                                                                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;

                                                                $grand_total_b_dr_amount+=$b_dr_amount;
                                                                $grand_total_b_cr_amount+=$b_cr_amount;
                                                                $grand_total_dr_amount+=$dr_amount;
                                                                $grand_total_cr_amount+=$cr_amount;
                                                                $grand_total_e_dr_amount+=$e_dr_amount;
                                                                $grand_total_e_cr_amount+=$e_cr_amount;
                                                            @endphp
                                                             {{-- <th>{{ ($k+1) }}</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> --}}
                                                        
                                                    @endif
                                                @empty
                                                @endforelse
                                                <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>
                                                
                                                {{-- @forelse ($searchedLedgers as $k=>$ledger)
                                                    @if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced) || array_key_exists($ledger->id,$ledgerWiseBalance) || array_key_exists($ledger->id,$ledgerWiseEndingBalance))
                                                        @if($lk==1)
                                                        <tr>
                                                            <th colspan="9" class="text-center text-white" style="background-color:#2D6161">
                                                                
                                                                @if(count($ledgers->where('id', $parent_id))>0)
                                                                    {{$ledgers->where('id', $parent_id)->first()->name}}
                                                                @else
                                                                    {{'ledger not found'}}
                                                                @endif
                                                            </th>
                                                        </tr>
                                                        @php $lk=0; @endphp
                                                        @endif
                                                        <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+1) }}</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 --}}

                                            
                                            @empty
                                                
                                            @endforelse
                                                
                                            
                                            
                                        </tbody>
                                        <tfoot>
                                            <tr>

                                            <th colspan="3"> Total Transaction</th>
                                                <th class="text-right">{{ number_format($grand_total_b_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($grand_total_b_cr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($grand_total_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($grand_total_cr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($grand_total_e_dr_amount??0,2) }}</th>
                                                <th class="text-right">{{ number_format($grand_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();
    $('#ledger_id').select2();
//    function excelPrint(){


// $(".lists").hide();
// $(".tr_class_b_remove").attr("class","border_remove");

//  window.open('data:application/vnd.ms-excel,' + encodeURIComponent(
            
//             $('div[id$=print]').html()
            
//             ));

// setTimeout(function() {
    
//     $(".border_remove").attr("class","tr_class_b_remove");
// $(".lists").show();

// }, 1000);

// }
</script>
@stop