@if (count($yearEndPendingBranchIds)>0)

    <div id="pendingYearEndInfoDiv">
        <p>There are </p>
        <a href="javascript:;" id="showDetails">
            {{count($yearEndPendingBranchIds)}} branche's
        </a>
        <p> year closing pending!!</p>
    </div>
    <br>

    @php
        $pendingBrances = DB::table('gnr_branch')
            ->whereIn('id',$yearEndPendingBranchIds)
            ->orderBy('branchCode')
            ->select(DB::raw("CONCAT(LPAD(branchCode, 3, 0), ' - ', name) AS nameWithCode"))
           ->get();

    @endphp         

<div id="pendingYearEndModal" class="modal fade" role="dialog">
  <div class="modal-dialog">

    <div class="modal-content">
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal">&times;</button>
        <h4 class="modal-title">Year End Pending Branches</h4>
      </div>
      <div class="modal-body">
        @foreach ($pendingBrances as $pendingBranch)
            <p style="color: black;">{{ $pendingBranch->nameWithCode }}</p>
        @endforeach
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
      </div>
    </div>

  </div>
</div>
@endif

<div id="printDiv">
    <div class="row" style="padding-bottom: 10px; text-align: center; vertical-align: middle; color: black; font-weight: bold; ">
        <span style="font-size:14px;">{{$reportHeader['companyName']}}</span><br/>
        <span style="font-size:11px;">{{$reportHeader['address']}}</span><br/>
        <span style="font-size:11px;">{{'Reporting '.$reportHeader['reportingLevel'].' & Code: '.$reportHeader['xyzName']}}</span><br/>
        <span style="text-decoration: underline;  font-size:14px;">Ratio Analysis Statement</span>
    </div>

    {{-- report info div --}}
    @php
        use Carbon\Carbon;
        $reportDate = Carbon::parse($filDate)->format('F,Y');
        $printDate = Carbon::now()->format('d-m-Y');
    @endphp
    <div class="row" style="margin-bottom:15px;">
        <div class="col-lg-12">
            <table style="color:black; font-size: 11px; border-collapse: collapse; width:100%;" >
                <tbody>
                    <tr>
                        <td>Reporting Month : {{$reportDate}}</td>
                        <td style="text-align: right;">Print Date : {{$printDate}}
                    </tr>
            </table>
        </div>        
    </div>
    {{-- end report info div --}}

    <div class="row">
        <div class="col-lg-12">
            <div class="table-responsive">
                <table class="table table-striped table-bordered pomisOne" border="1pt solid ash" style="color:black; border-collapse: collapse;">
                    <thead>
                        <tr>
                            <th rowspan="2">SL#</th>
                            <th rowspan="2">Particulars</th>
                            <th rowspan="2">রেশিও সমূহ</th>
                            <th rowspan="2">Formula</th>
                            <th rowspan="2" colspan="2">Standard</th>
                            <th colspan="3">Month wise Financial Status of last 3 months</th>
                            <th colspan="3">Year wise Financial Status of last 3 years</th>
                        </tr>
                        <tr>
                            <th>{{ $reportingDate->format('F Y') }}</th>
                            <th>{{ $previous1stMonth->format('F Y') }}</th>
                            <th>{{ $previous2ndMonth->format('F Y') }}</th>

                            <th>{{ 'FY '.@$currentFiscalYear->name }}</th>
                            <th>{{ 'FY '.@$previous1stFiscalYear->name }}</th>
                            <th>{{ 'FY '.@$previous2ndFiscalYear->name }}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php
                            $sl = 0;
                            $up = 1;
                        @endphp
                        @foreach ($ratioAnalysisCategories as $category)
                            <tr class="grandTotal">
                                <td colspan="12" class="ratioAnalysisCategory" style="padding-left: 10% !important;">{{ $category->title.' ('. $category->tilteBangla.')' }}</td>
                            </tr>
                            @php
                                $thisComponents = $ratioAnalysisComponents->where('categoryIdFk',$category->id);
                            @endphp

                            @foreach ($thisComponents as $component)
                                {{-- @if ($sl == 0) --}}
                                    <tr>
                                        <td rowspan="{{$initials[$component->id]['rowspan']}}">{{$sl+1}}</td>
                                        <td>{{$initials[$component->id]['name']}}</td>
                                        <td>{{$initials[$component->id]['nameBangla']}}</td>
                                        <td>{{$initials[$component->id]['formula']}}</td>
                                        <td>{{$initials[$component->id]['standardRateText']}}</td>
                                        <td  width="25px;">{{$initials[$component->id]['standardIndicator']}}</td>
                                        <td>{{isset($initials[$component->id]['currMonth']['ratio']) ? $initials[$component->id]['currMonth']['ratio'] : ""}}</td>
                                        <td>{{isset($initials[$component->id]['pre1Month']['ratio']) ? $initials[$component->id]['pre1Month']['ratio'] : ""}}</td>
                                        <td>{{isset($initials[$component->id]['pre2Month']['ratio']) ? $initials[$component->id]['pre2Month']['ratio'] : ""}}</td>
                                        <td>{{isset($initials[$component->id]['currFy']['ratio']) ? $initials[$component->id]['currFy']['ratio'] : ""}}</td>
                                        <td>{{isset($initials[$component->id]['pre1Fy']['ratio']) ? $initials[$component->id]['pre1Fy']['ratio'] : ""}}</td>
                                        <td>{{isset($initials[$component->id]['pre2Fy']['ratio']) ? $initials[$component->id]['pre2Fy']['ratio'] : ""}}</td>
                                    </tr>
                                    @if ($reportType == 'details')
                                        <tr>
                                            @foreach ($initials[$component->id]['details'] as $itemName=>$item)
                                                <td colspan="5" style="text-align:left;">{{$itemName}}</td>
                                                @foreach ($item as $value)
                                                    <td style="{{$value['style']}}">{{$value['value']}}</td>
                                                @endforeach
                                                </tr>
                                            @endforeach
                                        
                                    @endif
                                {{-- @endif --}}

                                {{-- <tr>
                                    <td>{{ $sl+1 }}</td>
                                    <td class="name">{{ $component->name }}</td>
                                    <td class="name">{{ $component->nameBangla }}</td>
                                    <td class="name">{{ $component->standardRateText }}</td>
                                    @if ($component->standardIndicator==1)
                                        <td width="25px;">(≥ ↑)</td>                                        
                                    @else
                                        <td width="25px;">(≤ ↓)</td>                                        
                                    @endif
                                    <td>{{ $currMonth[$sl] }}</td>
                                    <td>{{ $pre1stMonth[$sl] }}</td>
                                    <td>{{ $pre2ndMonth[$sl] }}</td>
                                    @if ($currentFiscalYear!=null)
                                        <td>{{ $currFY[$sl] }}</td>
                                    @else
                                        <td></td>
                                    @endif
                                    @if ($previous1stFiscalYear!=null)
                                        <td>{{ $pre1stFY[$sl] }}</td>
                                    @else
                                        <td></td>
                                    @endif
                                    @if ($previous2ndFiscalYear!=null)
                                        <td>{{ $pre2ndFY[$sl] }}</td>
                                    @else
                                        <td></td>
                                    @endif
                                </tr> --}}
                                @php
                                    $sl++;
                                @endphp
                            @endforeach {{-- end components --}}

                        @endforeach {{-- end category --}}
                    </tbody>
                </table>
            </div>      {{-- responseDIV --}}
        </div> 
    </div>  {{-- end first table --}}

    

</div>      {{-- printDiv DIV --}}

@php
    $time_elapsed_secs = microtime(true) - $start;
    // echo 'Execution Time: '.$time_elapsed_secs.' sec';
@endphp


<style type="text/css">
    .pomisOne > thead > tr > td, .pomisOne > tbody > tr > td, .pomisOne > thead > tr > th, .pomisOne > tbody > tr > th {
        padding: 2px !important;
        font-size: 10px !important;
        text-transform: capitalize!important;
    }

    .pomisOne > thead > tr .sNo {
        width: 23px !important;
    }
    .pomisOne > thead > tr .code {
        width: 90px !important;
    }
    .pomisOne > thead > tr .priPro {
        width: 55px !important;
    }
    .pomisOne > thead > tr .name {
        width: 72px !important;
    }
    .pomisOne > thead > tr .spouse {
        width: 72px !important;
    }
    .pomisOne > thead > tr .opBalance {
        width: 60px !important;
    }
    .pomisOne > thead > tr .weeks {
        width: 75px !important;
    }
    .pomisOne > thead > tr .balance {
        width: 60px !important;
    }

    .subTotalTr td{
        background-color: #9cb1d3;
    }
    .grandTotal td{
        background-color: #819bc4;
    }
    .funTotal td{
        background-color: #8296b7;
    }
    .allFunOrgTotal td{
        background-color: #55729e;
    }
    .note{
        color: white;
        font-size: 10px;
        margin-top: 1px;
    }
    .ratioAnalysisCategory{
        text-align: left !important;
        font-weight: bold;
        height: 18px;
    }
    #pendingYearEndInfoDiv {
        outline: 2px solid orange;
        width: 30%;
        margin-left: 1%;
        color: white;
        background-color: #4c4c66;
    }
    #pendingYearEndInfoDiv p{
        color: white;
    }
    #pendingYearEndInfoDiv *{
        display: inline-block;
    }
    #pendingYearEndInfoDiv a{
        color: #c9d0db;
    }
    #pendingYearEndModal{
        padding-top: 5%;
        color: black;
    }
</style>

<script type="text/javascript">
    $("#loadingModal").hide();
    $(document).ready(function() {
        $("#showDetails").click(function(event) {
            $("#pendingYearEndModal").modal('show');
        });
    });
</script>