@extends('admin.layout.master')
@section('title','DEALER 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.dealer_balance')}}" method="get">
            <div class="row mb-0 mt-0 pt-2">
                <div class="col-md-3 col-sm-6 col-12 d-flex flex-wrap mb-1">
                    <label for="pay_type w-100">Region</label>
                    <select name="shop_id" id="shop_id" style="min-width: 100%;" onchange="setGroup()">
                        <option value="0" @if(Request()->shop_id && Request()->shop_id==0) selected @endif>{{ 'ALL' }}</option>
                        @forelse ($shopsList as $shop_d)
                            <option value="{{$shop_d->id}}" @if(Request()->shop_id && Request()->shop_id==$shop_d->id) selected @endif>{{ $shop_d->name }}</option>
                        @empty
                        @endforelse
                    </select>
                </div>
                <div class="col-md-3 col-sm-6 col-12 d-flex flex-wrap mb-1">
                    <label for="cost_id">GROUPS</label>
                    <select name="group_ids" style="width:100%" id="group_ids" required>
                        <option value="0" @if(Request()->group_ids && Request()->group_ids==0) selected @endif>{{ 'All Group' }}</option>
                        @forelse ($groups as $g_ledger)   
                            <option value="{{$g_ledger->id}}" @if(Request()->group_ids && Request()->group_ids==$g_ledger->id) selected @endif>{{ $g_ledger->name_eng.' - '.$g_ledger->code}}</option>
                        @empty
                            
                        @endforelse
                    </select>
                </div>
                <div class="col-md-6 col-12 d-flex flex-wrap mb-1">
                    <label for="cost_id">Date Range</label>
                    <div class="input-group">
                        <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')}}">
                        <span class="input-group-text" style="max-height: 30px;">TO</span>
                        <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 class="input-group-append">
                            <button type="submit" style="max-height: 30px;" class="btn btn-sm btn-danger">
                                <span class="fa fa-search"></span>
                            </button>
                        </div>
                    </div>
                </div>
            </div>
        </form>
    </div>
              
    <div class="card-body"  style="padding-top:2px" id="divTableDataHolder">
        @if(count($groups) && Request()->start_date)
        <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;">
                                @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);
                            
                                    $opening=0;
                                    $closing=0;
                                    $drSum=0;
                                    $crSum=0;
                                

                                @endphp
                                <style type="text/css">{!!$printData['style_css']!!}</style>
                                {!!$printData['head']!!}
                                @forelse (Request()->group_ids && Request()->group_ids!=0?$groups->where('id',Request()->group_ids):$groups as $group_details)
                                    @php
                                        $header='<div class="pro_trans_table">
                                            <table class="display table table-bordered" id="dynamic-table" >
                                                <thead>
                                                    <tr>
                                                        <th colspan="11" class="th text-center text-light" style="background-color:#002952;padding:2px;">'.($group_details->name_eng).'</th>
                                                    </tr>
                                                    
                                                    <tr>
                                                        <th style="border:1px solid;" class="text-center" colspan="4">Perticulars</th>
                                                        <th style="border:1px solid;" class="text-center" >Opening<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" >Closing<br>'.( (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">Limit<br>Apply</th>
                                                        <th style="border:1px solid;" class="text-center" rowspan="2">Limit</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;">Commission(%)</th>
                                                        <th style="border:1px solid;"></th>
                                                        <th style="border:1px solid;">Debit</th>
                                                        <th style="border:1px solid;">Credit</th>
                                                        <th style="border:1px solid;"></th>
                                                    </tr>
                                                </thead>
                                                <tbody>';
                                                $body='';
                                                $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;
                                                $showroom_accs = $group_details->parties()->pluck('account_id')->toArray(); 
                                                $lk=1; 
                                            @endphp
                                            @forelse ($showroom_accs as $searchedLedger)
                                                @php 
                                                    $b_dr_amount=0;
                                                    $b_cr_amount=0;
                                                    $dr_amount=0;
                                                    $cr_amount=0;
                                                    $e_dr_amount=0;
                                                    $e_cr_amount=0;
                                                @endphp
                                                    {{-- @if((array_key_exists($searchedLedger,$ledgerWiseBalance['dr']) && abs($ledgerWiseBalance['dr'][$searchedLedger]['amount'])>0) || (array_key_exists($searchedLedger,$ledgerWiseBalance['cr']) && abs($ledgerWiseBalance['cr'][$searchedLedger]['amount'])>0)) --}}
                                                    @if(array_key_exists($searchedLedger,$ledgerWiseBeginningBalanced) || array_key_exists($searchedLedger,$ledgerWiseBalance['dr']) || array_key_exists($searchedLedger,$ledgerWiseBalance['cr']) || array_key_exists($searchedLedger,$ledgerWiseEndingBalance))
                                                       @php
                                                            if(array_key_exists($searchedLedger,$ledgerWiseBeginningBalanced)){
                                                                $name=$ledgerWiseBeginningBalanced[$searchedLedger]['name'];
                                                                if($ledgerWiseBeginningBalanced[$searchedLedger]['amount']>0){
                                                                    $b_dr_amount=$ledgerWiseBeginningBalanced[$searchedLedger]['amount'];
                                                                }else{
                                                                    $b_cr_amount=abs($ledgerWiseBeginningBalanced[$searchedLedger]['amount']);
                                                                }
                                                                //$b_cr_amount=($ledgerWiseBeginningBalanced[$searchedLedger]['amount']<0)?abs($ledgerWiseBeginningBalanced[$searchedLedger]['amount']):0;
                                                            
                                                            }
                                                            if(array_key_exists($searchedLedger,$ledgerWiseBalance['dr'])){
                                                                $name=$ledgerWiseBalance['dr'][$searchedLedger]['name'];
                                                                if($ledgerWiseBalance['dr'][$searchedLedger]['amount']>0){
                                                                    $dr_amount=$ledgerWiseBalance['dr'][$searchedLedger]['amount'];
                                                                }
                                                            }
                                                            if(array_key_exists($searchedLedger,$ledgerWiseBalance['cr'])){
                                                                $name=$ledgerWiseBalance['cr'][$searchedLedger]['name'];
                                                                if($ledgerWiseBalance['cr'][$searchedLedger]['amount']>0){
                                                                    $cr_amount=($ledgerWiseBalance['cr'][$searchedLedger]['amount']);
                                                                }
                                                            }
                                                            if(array_key_exists($searchedLedger,$ledgerWiseEndingBalance)){
                                                                $name=$ledgerWiseEndingBalance[$searchedLedger]['name'];
                                                                if($ledgerWiseEndingBalance[$searchedLedger]['amount']>0){
                                                                    $e_dr_amount=$ledgerWiseEndingBalance[$searchedLedger]['amount'];
                                                                }else{
                                                                    $e_cr_amount=abs($ledgerWiseEndingBalance[$searchedLedger]['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
                                                    @endif
                                                    
                                                    @php
                                                        $party=$partiesDetails->where('account_id',$searchedLedger)->first();
                                                    @endphp
                                                    @if($party && ($e_dr_amount>0||$e_cr_amount>0||$dr_amount>0||$cr_amount>0||$b_dr_amount>0||$b_cr_amount>0))
                                                        @php
                                                            $url=route('reports.ledger_view',['dealer_balance'=>1,'ledger_id'=>$searchedLedger,'cost_center_id'=>request()->cost_center_id,'start_date'=>request()->start_date??'2021-01-01','end_date'=>request()->end_date]);
                                                            $body.='<tr>
                                                                        <th>'.( ($lk++) ).'</th>
                                                                        <th>'.($searchedLedger).'</th>
                                                                        <th> 
                                                                            <a href="'.$url.'" target="_blank">
                                                                                '.($party->name_eng).'
                                                                            </a>
                                                                        </th>
                                                                        <th class="text-center">'.($party->commission).'</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(abs($e_dr_amount-$e_cr_amount)??0,2).(($e_dr_amount-$e_cr_amount)>0?' (dr)':' (cr)') ).'</th>
                                                                        <th class="text-'.($party->limit_apply?'success':'danger').' text-center">'.(($party->limit_apply?'Yes':'No')).'</th>
                                                                        <th class="text-right">'.($party->credit_limit_amount??'').'</th>
                                                                    </tr>';
                                                        @endphp
                                                    @endif

                                            
                                            @empty
                                            @endforelse
                                            {{-- showroom_accs foreach --}}
                                                
                                            
                                        @if($total_e_dr_amount>0||$total_e_cr_amount>0)
                                            {!!$header!!}    
                                            {!!$body!!}    
                                            </tbody>
                                            <tfoot>
                                                <tr>
                                                    <th style="border-top:solid black 2px" colspan="3"> Total Transaction</th>
                                                    <th style="border-top:solid black 2px"></th>
                                                    <th style="border-top:solid black 2px" 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 style="border-top:solid black 2px" class="text-right">{{ number_format($total_dr_amount??0,2) }}</th>
                                                    <th style="border-top:solid black 2px" class="text-right">{{ number_format($total_cr_amount??0,2) }}</th>
                                                    <th style="border-top:solid black 2px" 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>
                                                    <th style="border-top:solid black 2px"></th>
                                                    <th style="border-top:solid black 2px"></th>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                    @php
                                        $opening+=($total_b_dr_amount-$total_b_cr_amount);
                                        $closing+=($total_e_dr_amount-$total_e_cr_amount);
                                        $drSum+=$total_dr_amount;
                                        $crSum+=$total_cr_amount;
                                    @endphp
                                    @endif
                                @empty
                                @endforelse 
                                {{-- group foreach --}}
                                <table class="display table table-bordered" id="dynamic-table" >
                                    <thead>
                                        <tr>
                                            <th colspan="4" class="th text-center text-light" style="background-color:#002952;padding:2px;">TOTAL SUMMERY</th>
                                        </tr>
                                        <tr>
                                            <th>Opening Balance</th>
                                            <th>Debit Balance</th>
                                            <th>Credit Balance</th>
                                            <th>Closing Balance</th>
                                        </tr>
                                        <tr>
                                            <th style="border-top:solid black 2px" class="text-right">{{ number_format(abs($opening)??0,2).(($opening)>0?' (dr)':' (cr)') }}</th>
                                            <th style="border-top:solid black 2px" class="text-right">{{ number_format(($drSum)??0,2) }}</th>
                                            <th style="border-top:solid black 2px" class="text-right">{{ number_format(($crSum)??0,2) }}</th>
                                            <th style="border-top:solid black 2px" class="text-right">{{ number_format(abs($closing)??0,2).(($closing)>0?' (dr)':' (cr)') }}</th>
                                        </tr>
                            </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();
    $('#group_ids').select2();
    $('#shop_id').select2();

    const setGroup=()=>{
    let shop_id=$('#shop_id').val();
    let dataStr='<option value="0">Not Found</option>';
    if(shop_id!=0){
        let link= "{{route('marketing.sr_list')}}";
        let data_param={
            shop_id:shop_id,
            status:1,
            type:1,
        }
        const setGroupData = data => { 
            if(data.length){
                dataStr='<option value="0">SELECT GROUP</option>';
                for (let i = 0; i < data.length; i++) {
                    dataStr+='<option value="'+data[i].id+'">'+data[i].name_eng+'</option>';
                }
            }
            $('#group_ids').html(dataStr);
        }
        ajaxCall(link,'GET',data_param, setGroupData);
    }else{
        $('#group_ids').html(dataStr);
    }
}
//    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