@extends('admin.layout.master')
@section('title','TRAIL BALANCE STATEMENT')
@section('custom_style')
<style>
input[type=text],input[type=file], input[type=number],input[type=date] {
    height: 30px !important;
}
.padding_apply{
    padding-left: 1px;
}
.table thead th {
    border: 1px solid black !important;
    text-align: center;
    vertical-align: middle;
    }
/* .table tbody td {
    border: 1px solid black !important;vertical-align: middle;padding: 2px 5px;
    } */
.card-body{
    padding:.25rem !important;
}

.table th, .table td {
            padding: 0px 5px;
            color: black;
        }
    .table th {
           padding: 5px !important;
        }
.card-body{
    padding:.25rem !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.trail_balance_group_by')}}" 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">
                    </h3>
                    <h5 class="card-title text-center">{{ 'From '.date('d-M-Y',strtotime(Request()->start_date)).' To '.date('d-M-Y',strtotime(Request()->end_date))}}</h5>
                    --}}
                    <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;">
                                                @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 && Request()->end_date!=null)?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y');
                                                    // $printData['ledger_name']=count($ledgers->where('id',Request()->ledger_id))>0?$ledgers->where('id',Request()->ledger_id)->first()->name:'ledger not found';
                                                    $routeName=Route::currentRouteName();   
                                                    $printData=getPrintData($routeName,$printData);
                                                @endphp
                                                 <style type="text/css">{!!$printData['style_css']!!}</style>
                                                {!!$printData['head']!!}
                                                </th>
                                            </tr>
                                            
                                            <tr>
                                                <th style="border:1px solid;" class="text-center" colspan="3">Perticulars</th>
                                                <th style="border:1px solid;" class="text-center" rowspan="2">Balance Before<br>{{ Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y') }}
                                                </th>
                                                <th style="border:1px solid;" class="text-center" colspan="2">Transaction<br>
                                                    {{ (Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y')).' To '.(Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y')) }}</th>
                                                <th style="border:1px solid;" class="text-center" rowspan="2">Balance<br>
                                                    {{ 'AT '.(Request()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y'))}}</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 ($searchedLedgersChild->groupBy('parent_id') as $parent_id=>$searchedLedgers)
                                            @php $lk=1; @endphp
                                                {{-- <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> --}}
                                                
                                                @forelse ($searchedLedgers as $k=>$ledger)
                                                    @if(array_key_exists($ledger->id,$ledgerWiseBeginningBalanced) || array_key_exists($ledger->id,$ledgerWiseBalance['dr']) || array_key_exists($ledger->id,$ledgerWiseBalance['cr']) || 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['dr'])){
                                                                    $name=$ledgerWiseBalance['dr'][$ledger->id]['name'];
                                                                    if($ledgerWiseBalance['dr'][$ledger->id]['amount']>0){
                                                                        $dr_amount=$ledgerWiseBalance['dr'][$ledger->id]['amount'];
                                                                    }
                                                                }
                                                                if(array_key_exists($ledger->id,$ledgerWiseBalance['cr'])){
                                                                    $name=$ledgerWiseBalance['cr'][$ledger->id]['name'];
                                                                    if($ledgerWiseBalance['cr'][$ledger->id]['amount']>0){
                                                                        $cr_amount=($ledgerWiseBalance['cr'][$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> 
                                                                <a href="{{route('reports.ledger_view',['ledger_id'=>$ledger->id,'cost_center_id'=>request()->cost_center_id,'start_date'=>request()->start_date??'2021-01-01','end_date'=>request()->end_date])}}">
                                                                {{$name}}
                                                                </a>
                                                            </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(abs($b_dr_amount-$b_cr_amount)??0,2).(($b_dr_amount-$b_cr_amount)>0?' (dr)':' (cr)') )}}</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> --}}
                                                            <th class="text-right">{{   ( number_format(abs($e_dr_amount-$e_cr_amount)??0,2).(($e_dr_amount-$e_cr_amount)>0?' (dr)':' (cr)') )  }}</th>                                                        
                                                        </tr>
                                                    @endif
                                                @empty
                                                @endforelse

                                            
                                            @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(abs($total_b_dr_amount-$total_b_cr_amount)??0,2).(($total_b_dr_amount-$total_b_cr_amount)>0?' (dr)':' (cr)') )  }}</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> --}}
                                                <th class="text-right">{{   ( number_format(abs($total_e_dr_amount-$total_e_cr_amount)??0,2).(($total_e_dr_amount-$total_e_cr_amount)>0?' (dr)':' (cr)') )  }}</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