@extends('admin.layout.master')
@section('title','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: var(--tableHeader);
           padding: 5px !important;
           color: white !important;
        }
.card-body{
    padding:.25rem !important;
}
</style> 
@endsection
@section ('content')
@section ('content')
<div class="card sina-card">
    @include('admin.layout.title_header', ['title'=>'LEDGER REPORT'])
    
    <div class="card-body" style="padding-bottom:0">
        <form action="{{route(Request::route()->getName())}}" method="get">
            <div class="row mb-0 m-0 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">{{__('obs.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-3 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id">{{__('obs.ledger')}}</label>
                        <select name="ledger_id" style="width:100%" id="ledger_id" required>
                            @if(Request()->ledger_id)
                                <option value="{{$ledger->id}}">{{ $ledger->name.' - '.$ledger->auto_code }}</option>
                            @endif
                            {{-- @forelse ($ledgers as $l)   
                                <option value="{{$l->id}}">{{ $l->name.' - '.$l->auto_code }}</option>
                            @empty
                            @endforelse --}}
                        </select>
                    </div>
                    <div class="col-md-6 col-12 d-flex flex-wrap pr-0 mb-1">
                    <label for="cost_id">{{__('obs.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;">{{__('obs.date_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>
        <input type="hidden" id="marketing_admin" value="{{marketing_customer()?1:0}}">
    </div>
    <div class="card-body"  style="padding-top:2px" id="divTableDataHolder">
        <div class="row">
            <div class="col-md-12">          
                
                <div class="card-box">
                    @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()->end_date?date('d-M-Y',strtotime(Request()->end_date)):date('d-M-Y');
                        $printData['ledger_name']=$ledger?$ledger->name:'ledger not found';
                        $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">
                                    <div class="input-group row justify-content-start" style="position: sticky; top: 80px;z-index:25000">
                                        <div class="input-group-append" style="margin-left:15px;">
                                            <button type="button" class="btn-xs btn-warning hidden_content" onclick="showButton(2)"><i class="fa fa-wrench"></i></button>
                                            <button type="button" class="btn-xs btn-danger hidden_content" onclick="showButton(3)"><i class="fa fa-eraser"></i></button>
                                        </div>
                                    </div>
                                    <table class="table table-bordered">
                                        <thead>
                                        <tr>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">{{__('obs.date')}}</th>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">{{__('obs.voucher_no')}}</th>
                                            <th class="text-nowrap text-center" style="width: 25%;padding: 0">{{__('obs.particulars')}}</th>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">{{__('obs.reff')}}</th>
                                            <th class="text-nowrap text-center" style="width: 10%;padding: 0">{{__('obs.note')}}</th>
                                            <th class="text-nowrap text-center" style="width: 15%;padding: 0">{{__('obs.dr')}}</th>
                                            <th class="text-nowrap text-center" style="width: 15%;padding: 0">{{__('obs.cr')}}</th>
                                            <th class="text-nowrap text-center" style="width: 15%;padding: 0">{{__('obs.balance')}}</th>
                                        </tr>
                                        </thead>
                                                @php
                                                    $c_amount=0;
                                                    $d_amount=0;
                                                    $amount=0;
                                                    $show_multiple=0;
                                                    $printUrlArray=['','purchase-print?id=','purchase-print?id=','sell-print?id=','sell-print?id=','adjustment-print?id=','adjustment-print?id=','adjustment-print?id=','issue-print?id=','issue-print?id=','store_transfer-print?model=0&store_invoice_id=', 'store_transfer-print?model=1&store_invoice_id=', 'production-print?id=', 'opening-print?id=','','','adjustment-print?id=', 'purchase-contract-print?id=', 'sales-contract-print?id='];
                                                @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-left" style="padding: 0 2px;">{{'--'}}</td>
                                                <td class="text-left" style="padding: 0 2px;">
                                                    <b>{{'Beginning Balance'}}</b>
                                                </td>
                                                <td class="text-nowrap text-left" style="padding: 0 2px;"></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>=0)
                                                    {{number_format($b_balance,2)}}
                                                        @php
                                                            $d_amount+=$b_balance;
                                                            $amount+=$b_balance;
                                                        @endphp
                                                    @endif
                                                </td>
                                                <td class="text-nowrap text-right" style="padding: 0 2px;">
                                                    @if($b_balance<0)
                                                    @php
                                                        $minusTrimedBalance=abs($b_balance);
                                                        $c_amount+=$minusTrimedBalance;
                                                        $amount-=$minusTrimedBalance;
                                                    @endphp
                                                    {{number_format($minusTrimedBalance,2)}}
                                                    @endif
                                                </td>
                                                @if($r_type==1)
                                                    <td class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount>=0?number_format($amount,2).'(dr)':(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
                                            </tr>
                                            @forelse ($vouchers as $jr)
                                                @php
                                                    $reff=$jr->voucher->reffInvoice??$jr->voucher->reffFgInvoice;
                                                    $creditLedger=$jr->oppsiteJr->where('type',$jr->type==0?1:0);
                                                    $drCounter=count($jr->oppsiteJr->where('type',$jr->type));
                                                    $groupType=$creditLedger->where('group_type',$jr->group_type);
                                                    $str='';
                                                    $rowspan=1;
                                                    $tr='';

                                                    if(count($groupType)>0){
                                                        if($show_multiple && $drCounter==1){
                                                            foreach($groupType as $opp){
                                                                if($rowspan==1){
                                                                    $str.=$opp->globalLedger?$opp->globalLedger->name:'Ledger Missing';
                                                                }
                                                                if(count($groupType)>1){
                                                                    $str.=' - '.$opp->amount.'<br>';
                                                                }
                                                            }
                                                        }else{
                                                            $str.=$groupType->first()->globalLedger?$groupType->first()->globalLedger->name:'Ledger Missing';
                                                        }
                                                    }elseif(count($creditLedger)>0){
                                                        if($show_multiple && $drCounter==1){
                                                            foreach($creditLedger as $ocl){
                                                                $str.=$ocl->globalLedger?$ocl->globalLedger->name:'Ledger Missing';
                                                                if(count($creditLedger)>1){
                                                                    $str.=' - '.(number_format($ocl->amount,2)).'<br>';
                                                                }
                                                            }
                                                        }else{
                                                            $str.=$creditLedger->first()->globalLedger?$creditLedger->first()->globalLedger->name:'Ledger Missing';
                                                        }
                                                    }
                                                        
                                                @endphp
                                            <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-left" style="padding: 0 2px;">
                                                <a target="_blank" href="{{ route('voucher.voucher_details',['voucher_id'=>$jr->voucher->id]) }}" class="text-dark">
                                                    {{$jr->voucher->voucher_no}}
                                                </a>
                                            </td>
                                            <td class="text-left" style="padding: 0 2px;">
                                                {!!$str!!}
                                            </td>
                                            <td class="text-nowrap text-left" style="padding: 0 2px;">
                                                @if($reff)
                                                    @if(!$reff->ref_type)
                                                        <a target="_blank" href="{{ editInvoiceLink($reff->id,$reff->transaction_type) }}" style="display:none;padding:0 !important;" class="btn-xs btn-warning hidden_edit_btn"><i class="fa fa-wrench"></i></a>
                                                    @endif
                                                    <a target="_blank" href="{{ '/'.$printUrlArray[$reff->transaction_type].$reff->id }}" class="text-dark">{{$reff->invoice_no}}</a>
                
                                                @endif
                                            </td>
                                            <td class="text-left" style="padding: 0 2px;">@if($jr->voucher->bill_date){{$jr->voucher->bill_date?'Bill Date : '.date('d-m-Y',strtotime($jr->voucher->bill_date)).'Bill No : '.$jr->voucher->bill_no:''}}<br>@endif{{$jr->note??$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).'(dr)':(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
                                        </tr>
                                            @empty
                                                
                                            @endforelse
                                        </tbody>
                                        <tfoot>
                                            <tr>    
                                                <th class="text-nowrap text-right" style="width: 10%;padding: 0 2px;" colspan="4">
                                                    {{'TOTAL '}}
                                                <th class="text-nowrap text-left" style="padding: 0 2px;"></th>
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">
                                                        {{number_format($d_amount,2)}}
                                                </th>
                                                <th class="text-nowrap text-right" style="padding: 0 2px;">
                                                    {{number_format($c_amount,2)}}
                                                </th>
                                                @if($r_type==1)
                                                    <th class="text-nowrap text-right" style="padding: 0 2px;">{{ $amount=0 ? '': ($amount > 0?number_format($amount,2).'(dr)':(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>
                                        </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>
                    {!!$printData['foot']!!}
                </div>
            {{-- </form> --}}
            </div>
        </div>
    </div>
</div>
@endsection
@section('script')
<script>
    $('#ledger_id').select2({ 
                    minimumInputLength: 3,
                    // tags: [],
                    ajax: {
                        url: "{{route('accounts_settings.ledger_search')}}",
                        dataType: 'json',
                        type: "GET",
                        quietMillis: 50,
                        data: function (term) {
                            // row_id= $(term.element).attr('data-row_id');
                            // var group_code=$('#group_row-'+100).val();
                            return {
                                _token: $("input[name='_token']").val(),
                                marketing_admin: $("#marketing_admin").val(),
                                search_type: 2,
                                group_code:null,
                                name: term
                            };
                        },
                        processResults: function (data) {
                            return {
                                results: $.map(data, function (item) {
                                    return {
                                        text: item.auto_code + ' -- ' + item.name,
                                        id: item.id
                                    }
                                })
                            };
                        }
                    }                                                   
                });
    $('#cost_center_id').select2();
    const showButton=(type)=>{
        if(type==3){
            $('.hidden_create_btn').hide();
            $('.hidden_edit_btn').hide();
        }else if(type==1){
            $('.hidden_create_btn').show();
            $('.hidden_edit_btn').hide();
        }else{
            $('.hidden_edit_btn').show();
            $('.hidden_create_btn').hide();
        }
    }
    
</script>
@stop