@extends('admin.layout.master')
@section('title','Group Ledger Report')
@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 {
           background: #ab3535;
           padding: 5px !important;
           color: white !important;
        }
.card-body{
    padding:.25rem !important;
}
</style> 
@endsection
@section ('content')
<div class="card sina-card">

    @include('admin.layout.title_header', ['title'=>'LEDGER REPORT (GROUP)'])
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route('reports.group_ledger_view')}}" method="get">
            @include('accounts.reports.search_form',['ledger'=>2])
            {{-- <div class="row mb-1 mt-1 pt-2" style="border:dashed 1px green">
                <div class="col-md-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="pay_type" style="min-width: 100%">C CENTER</label>
                    
                        <select name="cost_center_id" id="cost_center_id" style="min-width: 100%">
                            <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 class="col-md-4 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id">LEDGER</label>
                    
                    <select name="ledger_id[]" id="ledger_id" required multiple>
                        @forelse ($ledgers as $ledger)   
                        <option value="{{$ledger->id}}">{{ $ledger->name.' - '.$ledger->auto_code}}</option>
                        @empty
                        
                        @endforelse
                    </select>
                </div>
                <div class="col-md-5 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id" style="min-width: 100%">Date Range</label>
                    <div class="col-4 px-0">
                        <input type="date" class="form-control" name="start_date">
                    </div>
                    <div class="col-2 px-0 text-center">
                        <label for="cost_id">TO</label>
                    </div>
                    <div class="col-4 px-0">
                        <input type="date" class="form-control" name="end_date">
                    </div>
                    <div class="col-2 px-0 text-center">
                        <button type="submit" class="btn btn-danger">
                            <span class="fa fa-search"></span>
                        </button>
                    </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">
                @php
                    $r_type=1;
                    // $printData['start_date']=Request()->start_date?date('d-M-Y',strtotime(Request()->start_date)):date('d-M-Y');
                    // $printData['end_date']=Request()->date_to?date('d-M-Y',strtotime(Request()->date_to)):date('d-M-Y');
                    $routeName=Route::currentRouteName();   
                    $printData=getPrintData($routeName,[]);
                @endphp
                {!!$printData['head']!!}          
                @forelse ($ledger_ids as $ledger_id)
                <div class="card-box">
                    <h3 class="card-title text-center">
                        @if(count($ledgers->where('id',$ledger_id))>0)
                            {{ $ledgers->where('id',$ledger_id)->first()->name }}
                        @else
                            {{'ledger not found'}}
                        @endif
                    </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="table table-bordered">
                                        <thead>
                                        <tr>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">DATE</th>
                                            <th class="text-nowrap text-center" style="padding: 0">VOUCHER NO</th>
                                            <th class="text-nowrap text-center" style="padding: 0">PARTICULERS</th>
                                            <th class="text-nowrap text-center" style="padding: 0">NOTE</th>
                                            <th class="text-nowrap text-center" style="padding: 0">DR</th>
                                            <th class="text-nowrap text-center" style="padding: 0">CR</th>
                                            <th class="text-nowrap text-center" style="padding: 0">BALANCE</th>
                                        </tr>
                                        </thead>
                                                @php
                                                    $c_amount=0;
                                                    $d_amount=0;
                                                    $amount=0;
                                                @endphp
                                        <tbody class="item_tbody">
                                            <tr>    
                                                <td class="text-nowrap text-center" style="width: 10%;padding: 0 2px;">{{date('d-M-Y',strtotime(Request()->start_date)) }}</td>
                                                <td class="text-nowrap text-center" style="padding: 0 2px;">{{'--'}}</td>
                                                <td class="text-nowrap text-left" style="padding: 0 2px;">
                                                    {{'Beginning Balance'}}
                                                </td>
                                                <td class="text-nowrap text-left" style="padding: 0 2px;"></td>
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                    @if($b_balance[$ledger_id]>0)
                                                    {{number_format($b_balance[$ledger_id],2)}}
                                                        @php
                                                            $d_amount+=$b_balance[$ledger_id];
                                                            $amount+=$b_balance[$ledger_id];
                                                        @endphp
                                                    @endif
                                                </td>
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                    @if($b_balance[$ledger_id]<0)

                                                        @php
                                                            $minusTrimedBalance=abs($b_balance[$ledger_id]);
                                                            $c_amount+=$minusTrimedBalance;
                                                            $amount-=$minusTrimedBalance;
                                                        @endphp
                                                    
                                                        {{number_format($minusTrimedBalance,2)}}
                                                    @endif
                                                </td>
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</td>
                                            </tr>
                                            @forelse ($individualVouchers[$ledger_id] as $jr)
                                            <tr>    
                                            <td class="text-nowrap text-center" style="width: 10%;padding: 0 2px;">{{date('d-m-Y',strtotime($jr->date))}}</td>
                                            <td class="text-nowrap text-center" style="padding: 0 2px;">{{ $jr->voucher->voucher_no }}</td>
                                            <td class="text-nowrap text-left" style="padding: 0 2px;">
                                                @if($jr->type==0)
                                                    {{$jr->voucher->journals->where('type',1)->first()->ledger?$jr->voucher->journals->where('type',1)->first()->ledger->name:'Missing Ledger'}}
                                                    @else
                                                    {{$jr->voucher->journals->where('type',0)->first()->ledger?$jr->voucher->journals->where('type',0)->first()->ledger->name:'Missing Ledger'}}
                                                    {{-- {{$jr->voucher->journals->where('type',0)->first()->ledger->name}} --}}
                                                @endif
                                            </td>
                                            <td class="text-nowrap text-left" style="padding: 0 2px;">{{$jr->voucher->note}}</td>
                                            <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                @if($jr->type==0)
                                                {{number_format($jr->amount,2)}}
                                                    @php
                                                        $d_amount+=$jr->amount;
                                                        $amount+=$jr->amount;
                                                    @endphp
                                                @endif
                                            </td>
                                            <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                @if($jr->type==1)
                                                {{number_format($jr->amount,2)}}
                                                @php
                                                    $c_amount+=$jr->amount;
                                                    $amount-=$jr->amount;
                                                    @endphp
                                                @endif
                                            </td>
                                            @if($r_type==1)
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):(number_format(abs($amount),2)).' (cr)'}}</td>
                                            @else
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</td>
                                            @endif
                                            {{-- <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</td> --}}
                                        </tr>
                                            @empty
                                                
                                            @endforelse
                                        <tr>
                                            <th colspan="4" class="text-right">Transaction Total</th>
                                            <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $d_amount>=0?number_format($d_amount,2):'('.(number_format(abs($d_amount),2)).')'}}</th>
                                            <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $c_amount>=0?number_format($c_amount,2):'('.(number_format(abs($c_amount),2)).')'}}</th>
                                            @if($r_type==1)
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):(number_format(abs($amount),2)).' (cr)'}}</th>
                                            @else
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</th>
                                            @endif
                                            {{-- <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2):'('.(number_format(abs($amount),2)).')'}}</th> --}}
                                        </tr>
                                        </tbody>
                                        <tfoot>
                                            <tr>
                                                
                                            </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>
                @empty
                    
                @endforelse
            {{-- </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