@extends('admin.layout.master')
@section('title',__('obs.balance_sheet').' '.__('obs.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'=>__('obs.balance_sheet').' '.__('obs.statement')])
                    <div class="card-body" style="padding-bottom:0">
                        <form action="{{route('reports.balance_sheet')}}" method="get">
                            @include('accounts.reports.search_form',['ledger'=>0])
                        {{-- <div class="form-group">
                            <div class="row">
                                <div class="input-group col-7">
                                    <div class="input-group-prepend">
                                        <span class="input-group-text">COST CENTER</span>
                                    </div>
                                    <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 class="input-group col-5">
                              
                                            <input type="date" class="form-control bsdatepicker" id="date_to" name="date_to" value="{{ (Request()->date_to?date('Y-m-d',strtotime(Request()->date_to)):date('Y-m-d'))}}"> 
                               
                                        <div class="input-group-append">
                                            <button type="submit" class="btn 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(Request()->ledger_id) --}}
                        <div class="row">
                            <div class="col-md-12">          
                               
                                <div class="card-box">
                                @php
                                    // $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,$printData);
                                @endphp
                                    <style type="text/css">{!!$printData['style_css']!!}</style>
                                    {!!$printData['head']!!}
                                    {{-- <h3 class="card-title text-center"> {{'BALANCE SHEET STATEMENT'}}</h3>
                                    
                                    <h5 class="card-title text-center">{{ 'For the end of '.(Request()->date_to?date('d-M-Y',strtotime(Request()->date_to)):date('d-M-Y'))}}</h5>
                                   --}}
                                    <div class="card-body">
                                        <div class="row">
                                            
                                            <div class="col-sm-12">

                                                <table style="width: 100%">
                                                    <tbody style="background:white">
                                                        <tr style="border:1px solid;">
                                                            <td class="text-center" style="border-right:1px solid;">
                                                                <strong>{{__('obs.particulars')}}</strong></td>
                                                            <td class="text-center" style="border-right:1px solid;">
                                                                <strong>{{__('obs.note')}}</strong></td>
                                                            <td class="text-right"
                                                                style="border-right:1px solid;width:150px;">
                                                                {{-- <div class="col-sm-12" style="border-bottom:2px solid">
                                                                    <strong>Amount Details</strong>
                                                                </div> --}}
                                                                <div class="col-sm-12">
                                                                    <strong>{{__('obs.taka')}}</strong>
                                                                </div>
                                                            </td>
                                                            <td class="text-right" style="width:150px;">
                                                                {{-- <div class="col-sm-12" style="border-bottom:2px solid">
                                                                    <strong></strong></div> --}}
                                                                <div class="col-sm-12"><strong>{{__('obs.taka')}}</strong></div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <th style="text-align:left; border-bottom:2px solid;"><i>{{__('obs.assets')}}:</i></th>
                                                            <td colspan="3"></td>

                                                        </tr>
                                                        @php
                                                            $total_assets=0;
                                                        @endphp
                                                        @forelse ($parentLedgerDataWithGroup[1] as $assetsGroup)
                                                            <tr>
                                                                <td style="text-align:left">{{$assetsGroup['name'].'--'.$assetsGroup['code']}} </td>
                                                                <td></td>
                                                                <td style="text-align:right;font-weight:bold;">
                                                                    <div class="col-sm-12">
                                                                        @php
                                                                        $amount=0;
                                                                            foreach($assetsGroup['ledger_ids'] as $ledger){
                                                                                $amount+=$e_balance[$ledger['ledger_id']];
                                                                                $total_assets+=$e_balance[$ledger['ledger_id']];
                                                                            }
                                                                        @endphp
                                                                        {{$amount>0?number_format(abs($amount),2):'('.number_format($amount,2).')'}}
                                                                    </div>
                                                                </td>
                                                                <td style="text-align:right;font-weight:bold;">
                                                                    <div class="col-sm-12"> </div>
                                                                </td>
                                                            </tr>
                                                            
                                                        @empty
                                                            
                                                        @endforelse

                                                        <tr>
                                                            <td style="text-align:left"><strong>{{__('obs.total_assets')}} </strong></td>
                                                            <td></td>
                                                            <td style="text-align:right; border-top:2px solid;"> 
                                                                <div class="col-sm-12">
                                                                    <strong></strong>
                                                                </div>
                                                            </td>
                                                            <td style="text-align:right; border-bottom:2px dashed;">
                                                                <div class="col-sm-12">
                                                                    <strong>{{$total_assets>0?number_format(abs($total_assets),2):'('.number_format($total_assets,2).')'}}</strong>

                                                                </div>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <th style="text-align:left; border-bottom:2px solid;"><i>{{__('obs.equity_&_liabilities')}}:</i></th>
                                                            <td colspan="3"></td>

                                                        </tr>
                                                        @php
                                                            $total_liabilities=0;
                                                        @endphp
                                                    @forelse ($parentLedgerDataWithGroup[2] as $liabilitiesGroup)
                                                        <tr>
                                                            <td style="text-align:left">{{$liabilitiesGroup['name'].'--'.$liabilitiesGroup['code']}} </td>
                                                            <td></td>
                                                            <td style="text-align:right;font-weight:bold;">
                                                                <div class="col-sm-12">
                                                                    @php
                                                                    $amount=0;
                                                                        foreach($liabilitiesGroup['ledger_ids'] as $ledger){
                                                                            $amount+=$e_balance[$ledger['ledger_id']];
                                                                            $total_liabilities+=$e_balance[$ledger['ledger_id']];
                                                                        }
                                                                    @endphp
                                                                    {{$amount>0?number_format($amount,2):'('.number_format(abs($amount),2).')'}}
                                                                </div>
                                                            </td>
                                                            <td style="text-align:right;font-weight:bold;">
                                                                <div class="col-sm-12"> </div>
                                                            </td>
                                                        </tr>
                                                        
                                                    @empty
                                                        
                                                    @endforelse

                                                    <tr>
                                                        <td style="text-align:left"><strong>{{__('obs.total_liabilities')}}</strong></td>
                                                        <td></td>
                                                        <td style="text-align:right; border-top:2px solid;">
                                                            <div class="col-sm-12">
                                                                <strong>{{$total_liabilities<0?number_format(abs($total_liabilities),2):'('.number_format($total_liabilities,2).')'}}</strong>
                                                                
                                                            </div>
                                                        </td>
                                                        <td style="text-align:right;">
                                                            <div class="col-sm-12">

                                                            </div>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td style="text-align:left"><i>{{__('obs.net_income')}}</i></td>
                                                        <td></td>
                                                        <td style="text-align:right;">
                                                            <div class="col-sm-12">
                                                                <strong>{{number_format($profit,2)}}</strong>
                                                            </div>
                                                        </td>
                                                        <td style="text-align:right;">
                                                            <div class="col-sm-12">
                                                            </div>
                                                        </td>
                                                    </tr>
                                                    <tr>
                                                        <td style="text-align:left"><strong>{{__('obs.total_equity_&_liabilities')}}</strong></td>
                                                        <td></td>
                                                        <td style="text-align:right; border-top:2px solid;">
                                                            <div class="col-sm-12">
                                                                <strong></strong>
                                                            </div>
                                                        </td>
                                                        <td style="text-align:right; border-bottom:2px dashed;">
                                                            <div class="col-sm-12">
                                                                @php
                                                                    $balance=(abs($total_liabilities)+$profit)
                                                                @endphp
                                                                <strong>{{$balance>0?number_format(abs($balance),2):'('.number_format($balance,2).')'}}</strong>

                                                            </div>
                                                        </td>
                                                    </tr>
                                                </tbody>


                                                </table>
                                                
                            
                            
                                            </div>
                                            
                                        </div>
                                    </form>
                                   
                                    </div>
                                </div>
                            </div>
                        </div>
                        {{-- @endif --}}
                    </div>
                </div>
            {{-- </div>
        </div>
    </div>
</div> --}}

@endsection
@section('script')
<script>
//    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