@extends('admin.layouts.main')

@section('title')
    {{ trans('finance.general_ledger') }}
@endsection

@section('content')
    <main>
        <div class="two-col">
          
            @include('admin.common.sidebar')

            <div class="right-sec">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0)">{{ @trans('finance.finance_reports') }}</a></li>
                        <li class="breadcrumb-item active" aria-current="page">{{ @trans('finance.general_ledger') }}</li>
                    </ol>
                </nav>

                <div class="top-bar d-flex align-items-center">
                    <h2>{{ @trans('finance.general_ledger') }}</h2>
                    <div class="right-table-container ml-auto">
                        <div class="right-table-container ml-auto">
                            @if(Auth::user()->franchise && Auth::user()->franchise->countries && Auth::user()->franchise->countries->currency_code)
                            <label class="pt-2 pr-2" style="font-size: 14px;">(Amounts are in {{ Auth::user()->franchise->countries->currency_code }})</label>
                            @else
                            <label class="pt-2 pr-2" style="font-size: 14px;">(Amounts are in TZS)</label>
                            @endif
                            <a href="javascript:void(0)" class="btn btn-em" data-toggle="modal" data-target="#filter">
                                @if(count($params) > 0)
                                    <img src="{{ asset('img/admin/ic_filter_edit.svg') }}" class="mr-1" alt="filter" />Edit Filter
                                @else
                                <img src="{{ asset('img/admin/ic_filter.svg') }}" alt="" class="mr-1">{{ @trans('job.filter') }}</a>
                                @endif
                            </a>
                            <a href="javascript:void()" class="btn btn-em btnExport" target="_blank">Export</a>
                            <button class="btn btn-em scrollTableLeft pl-2 pr-2" title="Scoll Left"><i class="material-icons">chevron_left</i></button>
                            <button class="btn btn-em scrollTableRight pl-2 pr-2" title="Scoll Right"><i class="material-icons">chevron_right</i></button>
                        </div>
                    </div>
                </div>
                <div class="table-wrapper">
                    <div class="table-data first-col-fix">
                        <div class="table-responsive table-bordered">
                            <table class="table" id="mtcTable">
                                <thead>
                                    <tr>
                                        <th class="text-center" rowspan="2" style="min-width:180px"></th>
                                        @foreach ($deptList as $dept)
                                            <th @if($dept->subdepts_count > 0) colspan="{{ $dept->subdepts_count }}" @endif class="text-center top-head 
                                                @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif">{{ $dept->name }}</th>
                                        @endforeach
                                        <th rowspan="2" class="text-center table-cl-red">Total</th>
                                    </tr>
                                    <tr>
                                        @foreach ($deptList as $dept)
                                            @if($dept->subdepts_count > 0)
                                                @foreach($dept->subdepts as $sub_dept)
                                                    <th class="text-center @if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif" 
                                                        style="min-width:120px;">{{ $sub_dept->name }}</th>
                                                @endforeach
                                            @else
                                                <th class="text-center @if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif" style="min-width:120px;">-</th>
                                            @endif
                                        @endforeach
                                    </tr>
                                </thead>
                                <tbody>
                                    <!-- start invoices -->
                                        <!-- start tr for b2b invoices -->
                                        <tr>
                                            @php $b2bSumTotal = '0' @endphp
                                            <td class="text-right" style="min-width:185px;width:185px;max-width:185px">B2B</td>
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @php $b2bSumTotal += $subDeptSums[$sub_dept->id]['b2bsum'] @endphp 
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right">{{ $subDeptSums[$sub_dept->id]['b2bsum'] ? number_format($subDeptSums[$sub_dept->id]['b2bsum'], 2) : '' }}</td>
                                                    @endforeach
                                                @else
                                                    @php $b2bSumTotal += $deptSums[$dept->id]['b2bsum'] @endphp 
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right">{{ $deptSums[$dept->id]['b2bsum'] ? number_format($deptSums[$dept->id]['b2bsum'], 2) : ''}}</td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right">{{ $b2bSumTotal ? number_format($b2bSumTotal, 2) : '' }}</td>
                                        </tr>
                                        <!-- end tr for b2b invoices -->
                                        <!-- start tr for b2b invoices -->
                                        <tr>
                                            @php $b2cSumTotal = '0' @endphp
                                            <td class="text-right" style="min-width:185px;width:185px;max-width:185px">B2C</td>
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @php $b2cSumTotal += $subDeptSums[$sub_dept->id]['b2csum'] @endphp 
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right">{{ $subDeptSums[$sub_dept->id]['b2csum'] ? number_format($subDeptSums[$sub_dept->id]['b2csum'], 2) : '' }}</td>
                                                    @endforeach
                                                @else
                                                    @php $b2cSumTotal += $deptSums[$dept->id]['b2csum'] @endphp 
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right">{{ $deptSums[$dept->id]['b2csum'] ? number_format($deptSums[$dept->id]['b2csum'], 2) : ''}}</td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right">{{ $b2cSumTotal ? number_format($b2cSumTotal, 2) : '' }}</td>
                                        </tr>
                                        <!-- end tr for b2b invoices -->
                                    <!-- end invoices -->

                                    <!-- start total revenue -->
                                        <!-- start invoice total revenue -->
                                        <tr>
                                            <td class="text-right" style="min-width:185px;width:185px;max-width:185px" rowspan="2"><strong>Total Revenue</strong></td>
                                            @php $invoiceSumTotal = $b2bSumTotal + $b2cSumTotal @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right"><strong>{{ $subDeptSums[$sub_dept->id]['total'] ? number_format($subDeptSums[$sub_dept->id]['total'], 2) : '' }}</strong></td>
                                                    @endforeach
                                                @else
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" rowspan="2"><strong>{{ $deptSums[$dept->id]['total'] ? number_format($deptSums[$dept->id]['total'], 2) : ''}}</strong></td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right" rowspan="2"><strong>{{ $invoiceSumTotal ? number_format($invoiceSumTotal, 2) : '' }}</strong></td>
                                        </tr>
                                        <!-- end invoice total revenue -->

                                        <!-- start dept invoice total revenue -->
                                        <tr>
                                            @php $deptTotalRevenue = []; @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @isset($deptTotalRevenue[$dept->id])
                                                            @php $deptTotalRevenue[$dept->id] += $subDeptSums[$sub_dept->id]['total']; @endphp
                                                        @else
                                                            @php $deptTotalRevenue[$dept->id] = $subDeptSums[$sub_dept->id]['total']; @endphp
                                                        @endisset
                                                    @endforeach
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" colspan="{{ $dept->subdepts_count }}"><strong>{{ $deptTotalRevenue[$dept->id] ? number_format($deptTotalRevenue[$dept->id], 2) : '' }}</strong></td>
                                                @endif
                                            @endforeach
                                        </tr>
                                        <!-- end dept invoice total revenue -->
                                    <!-- end total revenue -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start cost of goods sold -->
                                        <!-- start print cogs amount (department and subdepartment wise) -->
                                        <tr>
                                            @php $cogsSumTotal = '0' @endphp
                                            <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">Cost of Goods Sold</td>
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @php $cogsSumTotal += $accountSubDepts[$sub_dept->id]['cogs_total'] @endphp 
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right">{{ $accountSubDepts[$sub_dept->id]['cogs_total'] ? number_format($accountSubDepts[$sub_dept->id]['cogs_total'], 2) : '' }}</td>
                                                    @endforeach
                                                @else
                                                    @php $cogsSumTotal += $accountDepts[$dept->id]['cogs_total'] @endphp
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" rowspan="2">{{ $accountDepts[$dept->id]['cogs_total'] ? number_format($accountDepts[$dept->id]['cogs_total'], 2) : ''}}</td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right" rowspan="2">{{ $cogsSumTotal ? number_format($cogsSumTotal, 2) : '' }}</td>
                                        </tr>
                                        <!-- end print cogs amount -->
                                        <!-- start print cogs amount (department wise) -->
                                        <tr>
                                            @php $cogsTotalRevenue = []; @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @isset($cogsTotalRevenue[$dept->id])
                                                            @php $cogsTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp
                                                        @else
                                                            @php $cogsTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp
                                                        @endisset
                                                    @endforeach
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" colspan="{{ $dept->subdepts_count }}">{{ $cogsTotalRevenue[$dept->id] ? number_format($cogsTotalRevenue[$dept->id], 2) : '' }}</td>
                                                @endif
                                            @endforeach
                                        </tr>
                                        <!-- end print cogs amount (department wise) -->
                                    <!-- end cost of goods sold -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start gross margin -->
                                        <!-- start print gross margin amount (department and subdepartment wise) -->
                                        <tr>
                                            <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px"><strong>Gross Margin</strong></td>
                                            @php $grossMarginTotal = $b2bSumTotal + $b2cSumTotal - $cogsSumTotal @endphp
                                            @php $firstSubDeptGrossMargin = []; @endphp
                                            @php $firstDeptGrossMargin = []; @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @php $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] = $subDeptSums[$sub_dept->id]['total'] - $accountSubDepts[$sub_dept->id]['cogs_total']; @endphp
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right"><strong>{{ $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] ? number_format($firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) : '' }}</strong></td>
                                                    @endforeach
                                                @else
                                                    @php $firstDeptGrossMargin[$dept->id] = $deptSums[$dept->id]['total'] - $accountDepts[$dept->id]['cogs_total']; @endphp
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" rowspan="2"><strong>{{ $firstDeptGrossMargin[$dept->id] ? number_format($firstDeptGrossMargin[$dept->id], 2) : ''}}</strong></td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right" rowspan="2"><strong>{{ $grossMarginTotal ? number_format($grossMarginTotal, 2) : '' }}</strong></td>
                                        </tr>
                                        <!-- end print gross margin amount (department and subdepartment wise) -->
                                        <!-- start print gross margin amount (department wise) -->
                                        <tr>
                                            @php $secSubdeptgrossMarginTotal = []; @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @php $secSubdeptgrossMarginTotal[$dept->id] = (int)$deptTotalRevenue[$dept->id] - (int)$cogsTotalRevenue[$dept->id]; @endphp
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" colspan="{{ $dept->subdepts_count }}"><strong>{{ $secSubdeptgrossMarginTotal[$dept->id] ? number_format($secSubdeptgrossMarginTotal[$dept->id], 2) : '' }}</strong></td>
                                                @endif
                                            @endforeach
                                        </tr>
                                        <!-- end print gross margin amount (department wise) -->
                                    <!-- end gross margin -->

                                    <!-- start sales of gross margin -->
                                        <!-- start print sales of gross margin (department and sub department wise) -->
                                        <tr>
                                            <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of Sales</td>
                                            @php $firstSubDeptGrossMarginSales = []; @endphp
                                            @php $firstDeptGrossMarginSales = []; @endphp
                                            @if($grossMarginTotal && $grossMarginTotal != 0 && $invoiceSumTotal != 0)
                                                @php $firstGrossMarginSalesTotalPercentage = number_format(($grossMarginTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp
                                            @elseif($grossMarginTotal && $grossMarginTotal != 0 && $invoiceSumTotal == 0)
                                                @php $firstGrossMarginSalesTotalPercentage = 'N/A'; @endphp
                                            @else
                                                @php $firstGrossMarginSalesTotalPercentage = ''; @endphp
                                            @endif
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @foreach ($dept->subdepts as $sub_dept)
                                                        @if(isset($firstSubDeptGrossMargin[$dept->id][$sub_dept->id]) && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0)
                                                            @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = number_format(($firstSubDeptGrossMargin[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp
                                                        @elseif($firstSubDeptGrossMargin[$dept->id][$sub_dept->id] && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0)
                                                            @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                            text-right">{{ $firstSubDeptGrossMarginSales[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                    @endforeach
                                                @else
                                                    @if(isset($firstDeptGrossMargin[$dept->id]) && $firstDeptGrossMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0)
                                                        @php $firstDeptGrossMarginSales[$dept->id] = number_format(($firstDeptGrossMargin[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp
                                                    @elseif($firstDeptGrossMargin[$dept->id] && $firstDeptGrossMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                        @php $firstDeptGrossMarginSales[$dept->id] = 'N/A'; @endphp
                                                    @else
                                                        @php $firstDeptGrossMarginSales[$dept->id] = ''; @endphp
                                                    @endif
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" rowspan="2">{{ $firstDeptGrossMarginSales[$dept->id] ?? ''}}</td>
                                                @endif
                                            @endforeach
                                            <td class="table-cl-red text-right" rowspan="2">{{ $firstGrossMarginSalesTotalPercentage ?? '' }}</td>
                                        </tr>
                                        <!-- end print sales of gross margin (department and sub department wise) -->
                                        <!-- start print sales of gross margin (department wise) -->
                                        <tr>
                                            @php $secSubDeptGrossMarginSales = []; @endphp
                                            @foreach ($deptList as $dept)
                                                @if($dept->subdepts_count > 0)
                                                    @if(isset($secSubdeptgrossMarginTotal[$dept->id]) && $secSubdeptgrossMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0)
                                                        @php $secSubDeptGrossMarginSales[$dept->id] = number_format(($secSubdeptgrossMarginTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp
                                                    @elseif($secSubdeptgrossMarginTotal[$dept->id] && $secSubdeptgrossMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0)
                                                        @php $secSubDeptGrossMarginSales[$dept->id] = 'N/A'; @endphp
                                                    @else
                                                        @php $secSubDeptGrossMarginSales[$dept->id] = ''; @endphp
                                                    @endif
                                                    <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                        text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptGrossMarginSales[$dept->id] ?? '' }}</td>
                                                @endif
                                            @endforeach
                                        </tr>
                                        <!-- end print sales of gross margin (department wise) -->
                                    <!-- end sales of gross margin -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start human capital -->
                                        <!-- start human capital amounts (department and sub department wise)-->
                                            <tr>
                                                @php $hmcSumTotal = '0' @endphp
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">Human Capital</td>
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $hmcSumTotal += $accountSubDepts[$sub_dept->id]['hmc_total'] @endphp 
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $accountSubDepts[$sub_dept->id]['hmc_total'] ? number_format($accountSubDepts[$sub_dept->id]['hmc_total'], 2) : '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @php $hmcSumTotal += $accountDepts[$dept->id]['hmc_total'] @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $accountDepts[$dept->id]['hmc_total'] ? number_format($accountDepts[$dept->id]['hmc_total'], 2) : ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $hmcSumTotal ? number_format($hmcSumTotal, 2) : '' }}</td>
                                            </tr>
                                        <!-- end human capital amounts (department and sub department wise)-->
                                        <!-- start human capital amounts (department wise)-->
                                            <tr>
                                                @php $hmcsTotalRevenue = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @isset($hmcsTotalRevenue[$dept->id])
                                                                @php $hmcsTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp
                                                            @else
                                                                @php $hmcsTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp
                                                            @endisset
                                                        @endforeach
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $hmcsTotalRevenue[$dept->id] ? number_format($hmcsTotalRevenue[$dept->id], 2) : '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end human capital amounts (department wise)-->
                                    <!-- end human capital -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start contribution margin -->
                                        <!-- start print contribution margin (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px"><strong>Contribution Margin</strong></td>
                                                @php $contMarginTotal = $grossMarginTotal - $hmcSumTotal @endphp
                                                @php $firstSubDeptContMargin = []; @endphp
                                                @php $firstDeptContMargin = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $firstSubDeptContMargin[$dept->id][$sub_dept->id] = $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['hmc_total']; @endphp
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right"><strong>{{ $firstSubDeptContMargin[$dept->id][$sub_dept->id] ? number_format($firstSubDeptContMargin[$dept->id][$sub_dept->id], 2) : '' }}</strong></td>
                                                        @endforeach
                                                    @else
                                                        @php $firstDeptContMargin[$dept->id] = $firstDeptGrossMargin[$dept->id] - $accountDepts[$dept->id]['hmc_total']; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2"><strong>{{ $firstDeptContMargin[$dept->id] ? number_format($firstDeptContMargin[$dept->id], 2) : ''}}</strong></td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2"><strong>{{ $contMarginTotal ? number_format($contMarginTotal, 2) : '' }}</strong></td>
                                            </tr>
                                        <!-- end pring contribution margin (department and sub department wise) -->
                                        <!-- start print contribution margin (department wise) -->
                                            <tr>
                                                @php $secSubdeptContMarginTotal = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @php $secSubdeptContMarginTotal[$dept->id] = $secSubdeptgrossMarginTotal[$dept->id] - $hmcsTotalRevenue[$dept->id]; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}"><strong>{{ $secSubdeptContMarginTotal[$dept->id] ? number_format($secSubdeptContMarginTotal[$dept->id], 2) : '' }}</strong></td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end pring contribution margin (department wise) -->
                                    <!-- end contribution margin -->

                                    <!-- start sales of contribution margin -->
                                        <!-- start print sales of contribution margin (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of Sales</td>
                                                @php $firstSubDeptContMarginSales = []; @endphp
                                                @php $firstDeptContMarginSales = []; @endphp
                                                @if($contMarginTotal && $contMarginTotal != 0 && $invoiceSumTotal != 0)
                                                    @php $firstContMarginSalesTotalPercentage = number_format(($contMarginTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp
                                                @elseif($contMarginTotal && $contMarginTotal != 0 && $invoiceSumTotal == 0)
                                                    @php $firstContMarginSalesTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstContMarginSalesTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($firstSubDeptContMargin[$dept->id][$sub_dept->id]) && $firstSubDeptContMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0)
                                                                @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = number_format(($firstSubDeptContMargin[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp
                                                            @elseif($firstSubDeptContMargin[$dept->id][$sub_dept->id] && $firstSubDeptContMargin[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0)
                                                                @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptContMarginSales[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($firstDeptContMargin[$dept->id]) && $firstDeptContMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0)
                                                            @php $firstDeptContMarginSales[$dept->id] = number_format(($firstDeptContMargin[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp
                                                        @elseif(isset($firstDeptContMargin[$dept->id]) && $firstDeptContMargin[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptContMarginSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptContMarginSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptContMarginSales[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstContMarginSalesTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end print sales of contribution margin (department and sub department wise) -->
                                        <!-- start print sales of contribution margin (department wise) -->
                                            <tr>
                                                @php $secSubDeptContMarginSales = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($secSubdeptContMarginTotal[$dept->id]) && $secSubdeptContMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0)
                                                            @php $secSubDeptContMarginSales[$dept->id] = number_format(($secSubdeptContMarginTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($secSubdeptContMarginTotal[$dept->id]) && $secSubdeptContMarginTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0)
                                                            @php $secSubDeptContMarginSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptContMarginSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptContMarginSales[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- start print sales of contribution margin (department wise) -->
                                    <!-- end sales of contribution margin -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start operating expense -->
                                        <!-- start operating expense amounts (department and sub department wise)-->
                                            <tr>
                                                @php $opeSumTotal = '0' @endphp
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">Operating Expense</td>
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $opeSumTotal += $accountSubDepts[$sub_dept->id]['ope_total'] @endphp 
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $accountSubDepts[$sub_dept->id]['ope_total'] ? number_format($accountSubDepts[$sub_dept->id]['ope_total'], 2) : '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @php $opeSumTotal += $accountDepts[$dept->id]['ope_total'] @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $accountDepts[$dept->id]['ope_total'] ? number_format($accountDepts[$dept->id]['ope_total'], 2) : ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $opeSumTotal ? number_format($opeSumTotal, 2) : '' }}</td>
                                            </tr>
                                        <!-- end operating expense amounts (department and sub department wise)-->
                                        <!-- start operating expense amounts (department wise)-->
                                            <tr>
                                                @php $opeTotalRevenue = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @isset($opeTotalRevenue[$dept->id])
                                                                @php $opeTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['ope_total']; @endphp
                                                            @else
                                                                @php $opeTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['ope_total']; @endphp
                                                            @endisset
                                                        @endforeach
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $opeTotalRevenue[$dept->id] ? number_format($opeTotalRevenue[$dept->id], 2) : '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end operating expense amounts (department wise)-->
                                    <!-- end operating expense -->

                                    <!-- start sales of operating expense -->
                                        <!-- start pring sales of operating expense (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of Sales</td>
                                                @php $firstSubDeptOpeSales = []; @endphp
                                                @php $firstDeptOpeSales = []; @endphp
                                                @if($opeSumTotal && $opeSumTotal != 0 && $invoiceSumTotal != 0)
                                                    @php $firstOpeSalesTotalPercentage = number_format(($opeSumTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp
                                                @elseif($opeSumTotal && $opeSumTotal != 0 && $invoiceSumTotal == 0)
                                                    @php $firstOpeSalesTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstOpeSalesTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($accountSubDepts[$sub_dept->id]['ope_total']) && $accountSubDepts[$sub_dept->id]['ope_total'] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0)
                                                                @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = number_format(($accountSubDepts[$sub_dept->id]['ope_total'] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) .'%'; @endphp
                                                            @elseif(isset($accountSubDepts[$sub_dept->id]['ope_total']) && $accountSubDepts[$sub_dept->id]['ope_total'] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0)
                                                                @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptOpeSales[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptOpeSales[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($accountDepts[$dept->id]['ope_total']) && $accountDepts[$dept->id]['ope_total'] != 0 && $deptSums[$dept->id]['total'] != 0)
                                                            @php $firstDeptOpeSales[$dept->id] = number_format(($accountDepts[$dept->id]['ope_total'] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp
                                                        @elseif(isset($accountDepts[$dept->id]['ope_total']) && $accountDepts[$dept->id]['ope_total'] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptOpeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptOpeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptOpeSales[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstOpeSalesTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end pring sales of operating expense (department and sub department wise) -->
                                        <!-- start pring sales of operating expense (department wise) -->
                                            <tr>
                                                @php $secSubDeptOpeSales = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($opeTotalRevenue[$dept->id]) && $opeTotalRevenue[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0)
                                                            @php $secSubDeptOpeSales[$dept->id] = number_format(($opeTotalRevenue[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($opeTotalRevenue[$dept->id]) && $opeTotalRevenue[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0)
                                                            @php $secSubDeptOpeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptOpeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptOpeSales[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end pring sales of operating expense (department wise) -->
                                    <!-- end sales of operating expense -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start net operationg income -->
                                        <!-- start net operating income (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px"><strong>Net Operating Income</strong></td>
                                                @php $netOpeIncomeTotal = $contMarginTotal - $opeSumTotal @endphp
                                                @php $firstSubDeptNetOpeIncome = []; @endphp
                                                @php $firstDeptNetOpeIncome = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] = $firstSubDeptContMargin[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['ope_total']; @endphp
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right"><strong>{{ $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] ? number_format($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id], 2) : '' }}</strong></td>
                                                        @endforeach
                                                    @else
                                                        @php $firstDeptNetOpeIncome[$dept->id] = $firstDeptContMargin[$dept->id] - $accountDepts[$dept->id]['ope_total']; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2"><strong>{{ $firstDeptNetOpeIncome[$dept->id] ? number_format($firstDeptNetOpeIncome[$dept->id], 2) : ''}}</strong></td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2"><strong>{{ $netOpeIncomeTotal ? number_format($netOpeIncomeTotal, 2) : '' }}</strong></td>
                                            </tr>
                                        <!-- end net operating income (department and sub department wise) -->
                                        <!-- start net operating income (department wise) -->
                                            <tr>
                                                @php $secSubdeptNetOpeIncomeTotal = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @php $secSubdeptNetOpeIncomeTotal[$dept->id] = $secSubdeptContMarginTotal[$dept->id] - $opeTotalRevenue[$dept->id]; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}"><strong>{{ $secSubdeptNetOpeIncomeTotal[$dept->id] ? number_format($secSubdeptNetOpeIncomeTotal[$dept->id], 2) : '' }}</strong></td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end net operating income (department wise) -->
                                    <!-- end net operationg income -->

                                    <!-- start sales of net operating system -->
                                        <!-- start print sales of net operating system (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of Sales</td>
                                                @php $firstSubDeptNetOpeIncomeSales = []; @endphp
                                                @php $firstDeptNetOpeIncomeSales = []; @endphp
                                                @if($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $invoiceSumTotal != 0)
                                                    @php $firstNetOpeIncomeSalesTotalPercentage = number_format(($netOpeIncomeTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp
                                                @elseif($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $invoiceSumTotal == 0)
                                                    @php $firstNetOpeIncomeSalesTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstNetOpeIncomeSalesTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0)
                                                                @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = number_format(($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp
                                                            @elseif(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0)
                                                                @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptNetOpeIncomeSales[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0)
                                                            @php $firstDeptNetOpeIncomeSales[$dept->id] = number_format(($firstDeptNetOpeIncome[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp
                                                        @elseif(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptNetOpeIncomeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptNetOpeIncomeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptNetOpeIncomeSales[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstNetOpeIncomeSalesTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end print sales of net operating system -->
                                        <!-- start print sales of net operating system (department wise) -->
                                            <tr>
                                                @php $secSubDeptNetOpeIncomeSales = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0)
                                                            @php $secSubDeptNetOpeIncomeSales[$dept->id] = number_format(($secSubdeptNetOpeIncomeTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0)
                                                            @php $secSubDeptNetOpeIncomeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptNetOpeIncomeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptNetOpeIncomeSales[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print sales of net operating system -->
                                    <!-- end sales of net operating system -->

                                    <!-- start gross margin of net operating system -->
                                        <!-- start print gross margin of net operating system (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of GM</td>
                                                @php $firstSubDeptNetOpeIncomeGm = []; @endphp
                                                @php $firstDeptNetOpeIncomeGm = []; @endphp
                                                @if($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $grossMarginTotal != 0)
                                                    @php $firstNetOpeIncomeGmTotalPercentage = number_format(($netOpeIncomeTotal * 100) / $grossMarginTotal, 2) . '%'; @endphp
                                                @elseif($netOpeIncomeTotal && $netOpeIncomeTotal != 0 && $grossMarginTotal == 0)
                                                    @php $firstNetOpeIncomeGmTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstNetOpeIncomeGmTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0)
                                                                @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = number_format(($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] * 100) / $firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) . '%'; @endphp
                                                            @elseif(isset($firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] == 0)
                                                                @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptNetOpeIncomeGm[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $firstDeptGrossMargin[$dept->id] != 0)
                                                            @php $firstDeptNetOpeIncomeGm[$dept->id] = number_format(($firstDeptNetOpeIncome[$dept->id] * 100) / $firstDeptGrossMargin[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($firstDeptNetOpeIncome[$dept->id]) && $firstDeptNetOpeIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptNetOpeIncomeGm[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptNetOpeIncomeGm[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptNetOpeIncomeGm[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstNetOpeIncomeGmTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end print gross margin of net operating system (department and sub department wise) -->
                                        <!-- start print gross margin of net operating system (department wise) -->
                                            <tr>
                                                @php $secSubDeptNetOpeIncomeGm = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] != 0)
                                                            @php $secSubDeptNetOpeIncomeGm[$dept->id] = number_format(($secSubdeptNetOpeIncomeTotal[$dept->id] * 100) / (int)$secSubdeptgrossMarginTotal[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($secSubdeptNetOpeIncomeTotal[$dept->id]) && $secSubdeptNetOpeIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] == 0)
                                                            @php $secSubDeptNetOpeIncomeGm[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptNetOpeIncomeGm[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptNetOpeIncomeGm[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print gross margin of net operating system (department wise) -->
                                    <!-- end gross margin of net operating system -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start investment -->
                                        <!-- start print investment amount (department and sub department wise) -->
                                            <tr>
                                                @php $investmentSumTotal = '0' @endphp
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">Investment</td>
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $investmentSumTotal += $accountSubDepts[$sub_dept->id]['inst_total'] @endphp 
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $accountSubDepts[$sub_dept->id]['inst_total'] ? number_format($accountSubDepts[$sub_dept->id]['inst_total'], 2) : '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @php $investmentSumTotal += $accountDepts[$dept->id]['inst_total'] @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $accountDepts[$dept->id]['inst_total'] ? number_format($accountDepts[$dept->id]['inst_total'], 2) : ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $investmentSumTotal ? number_format($investmentSumTotal, 2) : '' }}</td>
                                            </tr>
                                        <!-- end print investment amount (department and sub department wise) -->
                                        <!-- start print investment amount (department wise) -->
                                            <tr>
                                                @php $investmentTotalRevenue = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @isset($investmentTotalRevenue[$dept->id])
                                                                @php $investmentTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['inst_total']; @endphp
                                                            @else
                                                                @php $investmentTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['inst_total']; @endphp
                                                            @endisset
                                                        @endforeach
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $investmentTotalRevenue[$dept->id] ? number_format($investmentTotalRevenue[$dept->id], 2) : '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print investment amount (department wise) -->
                                    <!-- end investment -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start net income -->
                                        <!-- start print net income (department and subdepartment wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px"><strong>Net Income</strong></td>
                                                @php $netIncomeTotal = $netOpeIncomeTotal - $investmentSumTotal @endphp
                                                @php $firstSubDeptNetIncome = []; @endphp
                                                @php $firstDeptNetIncome = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $firstSubDeptNetIncome[$dept->id][$sub_dept->id] = $firstSubDeptNetOpeIncome[$dept->id][$sub_dept->id] - $accountSubDepts[$sub_dept->id]['inst_total']; @endphp
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right"><strong>{{ $firstSubDeptNetIncome[$dept->id][$sub_dept->id] ? number_format($firstSubDeptNetIncome[$dept->id][$sub_dept->id], 2) : '' }}</strong></td>
                                                        @endforeach
                                                    @else
                                                        @php $firstDeptNetIncome[$dept->id] = $firstDeptNetOpeIncome[$dept->id] - $accountDepts[$dept->id]['inst_total']; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2"><strong>{{ $firstDeptNetIncome[$dept->id] ? number_format($firstDeptNetIncome[$dept->id], 2) : ''}}</strong></td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2"><strong>{{ $netIncomeTotal ? number_format($netIncomeTotal, 2) : '' }}</strong></td>
                                            </tr>
                                        <!-- end print net income (department and subdepartment wise) -->
                                        <!-- start print net income (department wise) -->
                                            <tr>
                                                @php $secSubdeptNetIncomeTotal = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @php $secSubdeptNetIncomeTotal[$dept->id] = $secSubdeptNetOpeIncomeTotal[$dept->id] - $investmentTotalRevenue[$dept->id]; @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}"><strong>{{ $secSubdeptNetIncomeTotal[$dept->id] ? number_format($secSubdeptNetIncomeTotal[$dept->id], 2) : '' }}</strong></td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print net income (department wise) -->
                                    <!-- end net income -->

                                    <!-- start sales of net income -->
                                        <!-- start print sales of net income (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of Sales</td>
                                                @php $firstSubDeptNetIncomeSales = []; @endphp
                                                @php $firstDeptNetIncomeSales = []; @endphp
                                                @if($netIncomeTotal && $netIncomeTotal != 0 && $invoiceSumTotal != 0)
                                                    @php $firstNetIncomeSalesTotalPercentage = number_format(($netIncomeTotal * 100) / $invoiceSumTotal, 2) . '%'; @endphp
                                                @elseif($netIncomeTotal && $netIncomeTotal != 0 && $invoiceSumTotal == 0)
                                                    @php $firstNetIncomeSalesTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstNetIncomeSalesTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] != 0)
                                                                @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = number_format(($firstSubDeptNetIncome[$dept->id][$sub_dept->id] * 100) / $subDeptSums[$sub_dept->id]['total'], 2) . '%'; @endphp
                                                            @elseif(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $subDeptSums[$sub_dept->id]['total'] == 0)
                                                                @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptNetIncomeSales[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] != 0)
                                                            @php $firstDeptNetIncomeSales[$dept->id] = number_format(($firstDeptNetIncome[$dept->id] * 100) / $deptSums[$dept->id]['total'], 2) . '%'; @endphp
                                                        @elseif(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptNetIncomeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptNetIncomeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptNetIncomeSales[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstNetIncomeSalesTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end print sales of net income (department and sub department wise) -->
                                        <!-- start print sales of net income (department wise) -->
                                            <tr>
                                                @php $secSubDeptNetIncomeSales = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] != 0)
                                                            @php $secSubDeptNetIncomeSales[$dept->id] = number_format(($secSubdeptNetIncomeTotal[$dept->id] * 100) / (int)$deptTotalRevenue[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $deptTotalRevenue[$dept->id] == 0)
                                                            @php $secSubDeptNetIncomeSales[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptNetIncomeSales[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptNetIncomeSales[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print sales of net income (department wise) -->
                                    <!-- end sales of net income -->

                                    <!-- start gross margin of net income -->
                                        <!-- start print gross margin of net income (department and sub department wise) -->
                                            <tr>
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">as % of GM</td>
                                                @php $firstSubDeptNetIncomeGm = []; @endphp
                                                @php $firstDeptNetIncomeGm = []; @endphp
                                                @if($netIncomeTotal && $netIncomeTotal != 0 && $grossMarginTotal != 0)
                                                    @php $firstNetIncomeGmTotalPercentage = number_format(($netIncomeTotal * 100) / $grossMarginTotal, 2) . '%'; @endphp
                                                @elseif($netIncomeTotal && $netIncomeTotal != 0 && $grossMarginTotal == 0)
                                                    @php $firstNetIncomeGmTotalPercentage = 'N/A'; @endphp
                                                @else
                                                    @php $firstNetIncomeGmTotalPercentage = ''; @endphp
                                                @endif
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @if(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] != 0)
                                                                @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = number_format(($firstSubDeptNetIncome[$dept->id][$sub_dept->id] * 100) / $firstSubDeptGrossMargin[$dept->id][$sub_dept->id], 2) . '%'; @endphp
                                                            @elseif(isset($firstSubDeptNetIncome[$dept->id][$sub_dept->id]) && $firstSubDeptNetIncome[$dept->id][$sub_dept->id] != 0 && $firstSubDeptGrossMargin[$dept->id][$sub_dept->id] == 0)
                                                                @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = 'N/A'; @endphp
                                                            @else
                                                                @php $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] = ''; @endphp
                                                            @endif
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $firstSubDeptNetIncomeGm[$dept->id][$sub_dept->id] ?? '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @if(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $firstDeptGrossMargin[$dept->id] != 0)
                                                            @php $firstDeptNetIncomeGm[$dept->id] = number_format(($firstDeptNetIncome[$dept->id] * 100) / $firstDeptGrossMargin[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($firstDeptNetIncome[$dept->id]) && $firstDeptNetIncome[$dept->id] != 0 && $deptSums[$dept->id]['total'] == 0)
                                                            @php $firstDeptNetIncomeGm[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $firstDeptNetIncomeGm[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $firstDeptNetIncomeGm[$dept->id] ?? ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $firstNetIncomeGmTotalPercentage ?? '' }}</td>
                                            </tr>
                                        <!-- end print gross margin of net income (department and sub department wise) -->
                                        <!-- start print gross margin of net income (department wise) -->
                                            <tr>
                                                @php $secSubDeptNetIncomeGm = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @if(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] != 0)
                                                            @php $secSubDeptNetIncomeGm[$dept->id] = number_format(($secSubdeptNetIncomeTotal[$dept->id] * 100) / (int)$secSubdeptgrossMarginTotal[$dept->id], 2) . '%'; @endphp
                                                        @elseif(isset($secSubdeptNetIncomeTotal[$dept->id]) && $secSubdeptNetIncomeTotal[$dept->id] != 0 && $secSubdeptgrossMarginTotal[$dept->id] == 0)
                                                            @php $secSubDeptNetIncomeGm[$dept->id] = 'N/A'; @endphp
                                                        @else
                                                            @php $secSubDeptNetIncomeGm[$dept->id] = ''; @endphp
                                                        @endif
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $secSubDeptNetIncomeGm[$dept->id] ?? '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end print gross margin of net income (department wise) -->
                                    <!-- end gross margin of net income -->

                                    <tr>
                                        <td colspan="" class="addEmptyRow"></td>
                                    </tr>

                                    <!-- start tax -->
                                        <!-- start tax amounts (department and sub department wise)-->
                                            <tr>
                                                @php $taxSumTotal = '0' @endphp
                                                <td rowspan="2" class="text-right" style="min-width:185px;width:185px;max-width:185px">Tax</td>
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @php $taxSumTotal += $accountSubDepts[$sub_dept->id]['tax_total'] @endphp 
                                                            <td class="@if($loop->parent->odd) table-cl-purple @elseif($loop->parent->even) table-cl-yellow @endif 
                                                                text-right">{{ $accountSubDepts[$sub_dept->id]['tax_total'] ? number_format($accountSubDepts[$sub_dept->id]['tax_total'], 2) : '' }}</td>
                                                        @endforeach
                                                    @else
                                                        @php $taxSumTotal += $accountDepts[$dept->id]['tax_total'] @endphp
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" rowspan="2">{{ $accountDepts[$dept->id]['tax_total'] ? number_format($accountDepts[$dept->id]['tax_total'], 2) : ''}}</td>
                                                    @endif
                                                @endforeach
                                                <td class="table-cl-red text-right" rowspan="2">{{ $taxSumTotal ? number_format($taxSumTotal, 2) : '' }}</td>
                                            </tr>
                                        <!-- end tax amounts (department and sub department wise)-->
                                        <!-- start tax amounts (department wise)-->
                                            <tr>
                                                @php $taxTotalRevenue = []; @endphp
                                                @foreach ($deptList as $dept)
                                                    @if($dept->subdepts_count > 0)
                                                        @foreach ($dept->subdepts as $sub_dept)
                                                            @isset($taxTotalRevenue[$dept->id])
                                                                @php $taxTotalRevenue[$dept->id] += $accountSubDepts[$sub_dept->id]['tax_total']; @endphp
                                                            @else
                                                                @php $taxTotalRevenue[$dept->id] = $accountSubDepts[$sub_dept->id]['tax_total']; @endphp
                                                            @endisset
                                                        @endforeach
                                                        <td class="@if($loop->odd) table-cl-purple @elseif($loop->even) table-cl-yellow @endif 
                                                            text-right" colspan="{{ $dept->subdepts_count }}">{{ $taxTotalRevenue[$dept->id] ? number_format($taxTotalRevenue[$dept->id], 2) : '' }}</td>
                                                    @endif
                                                @endforeach
                                            </tr>
                                        <!-- end tax amounts (department wise)-->
                                    <!-- end tax -->

                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </main>
@endsection

@push('pageJs')
    <div class="modal right filter-modal" id="filter" tabindex="-1" role="dialog" aria-labelledby="filter">
        <div class="modal-dialog modal-md" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title" id="filter">{{ @trans('job.filter') }}</h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span
                            aria-hidden="true">&times;</span></button>
                </div>

                <div class="modal-body">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col-md-12">
                                <form id="frmSearchGLDateRange" action="{{ route('admin.general-ledger.index',['panel' => session('panel')])}}">
                                    <input type="hidden" name="start_date" id="start_date">
                                    <input type="hidden" name="end_date" id="end_date">
                                    <input type="hidden" name="dept_id" id="dept_id">
                                </form>
                                <div class="form-group btm-arrow select">
                                    <label class="control-label">Department</label>
                                    <select id="filter_dept_id" name="filter_dept_id" class="form-control">
                                        <option value="">Show All</option>
                                        @foreach($filterDeptList as $department)
                                            <option value="{{ $department->id }}" 
                                                @if(isset($params['dept_id']) && $params['dept_id'] == $department->id) selected @endif>{{ $department->name }}</option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="row">
                                    <div class="col-md-6 date">
                                        <label class="control-label">Start Date</label>
                                        <div class="input-group">
                                            <input type="text" class="form-control bg-white" id="cal_start_date" name="cal_start_date"
                                                placeholder="Select" autocomplete="off" readonly required 
                                                value="{{ \Carbon\Carbon::parse($params['start_date'])->format('m/Y') }}">
                                            <div class="input-group-addon">
                                                <span class="material-icons">date_range</span>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-6 date">
                                        <label class="control-label">End Date</label>
                                        <div class="input-group">
                                            <input type="text" class="form-control bg-white" id="cal_end_date" name="cal_end_date"
                                                placeholder="Select" autocomplete="off" readonly
                                                value="{{ \Carbon\Carbon::parse($params['end_date'])->format('m/Y') }}">
                                            <div class="input-group-addon">
                                                <span class="material-icons">date_range</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer d-flex justify-content-between">
                    <button type="submit" class="btn btn-em submitApplyBtn" >{{ @trans('job.update_filter') }}</button>
                    <a href="{{ route('admin.general-ledger.index',['panel' => Session::get('panel')]) }}"
                        class="btn btn-cncl">Clear</a>
                </div>
            </div>
        </div>
    </div>
@endpush

@push('pageJs')
    <script>
        var exportUrl =  '{{ route("admin.general-ledger.export", ["panel" => Session::get("panel")]) }}';
        var exportUrlParams = ("{!! http_build_query($params) !!}");
        $(document).ready(function() {

            $('.btnExport').attr('href', exportUrl + '?' + exportUrlParams);

            $(".table-data .table-responsive").freezeTable({
                'scrollable': true,
            });

            $(window).resize(function() {
                $(".table-data .table-responsive").freezeTable('update');
            });
            $(document).on('click', '.sidebar-icon', function() {
                setTimeout(() => {
                    $(".table-data .table-responsive").freezeTable('update');
                }, 500);
            });

            $columnCount = document.getElementById('mtcTable').rows[2].cells.length;
            $('.addEmptyRow').attr('colspan', $columnCount);

            var today = new Date();
			var $startDate = $('#cal_start_date');
			var $endDate = $('#cal_end_date');

			$startDate.datepicker({
				format: 'mm/yyyy',
				zIndex: 2048,
				autoHide: true,
				date: null,
				endDate: (today.getMonth() + 1) + '/' + today.getFullYear(),
			});
			$endDate.datepicker({
				autoHide: true,
				format: 'mm/yyyy',
				zIndex: 2048,
				date: null,
				startDate: $startDate.datepicker('getDate')
			});

			$startDate.on('change', function() {
				$endDate.datepicker('setStartDate', $startDate.datepicker('getDate'));
			});
			$endDate.on('change', function() {
				$startDate.datepicker('setEndDate', $endDate.datepicker('getDate'));
			});

			$('.submitApplyBtn').on('click', function() {
				$('#start_date').val(moment($('#cal_start_date').datepicker('getDate')).format('YYYY-MM'));
				$('#end_date').val(moment($('#cal_end_date').datepicker('getDate')).format('YYYY-MM'));
				$('#dept_id').val($('#filter_dept_id').val());
				$('#frmSearchGLDateRange').submit();
			});
        });
    </script>
@endpush

@push('pageCss')
    <style>
        table td {
            height: 50px;
        }
    </style>
@endpush