@extends('fixed_asset.report.fixed_asset_summary.report')
@section('reporthomesection')
    <h4><b>Cost Center: {{ $costCen->name }}</b></h4>
    <div class="text-center">
        <span style="color:red">From {{ request()->start_date }}</span>
        <span style="color:red">To {{ request()->end_date }}</span>
    </div>
    <table class="display myTable  table-responsive table table-stripped table-bordered mt-3">
        <thead>
            <tr>
                <th rowspan="2">SL</th>
                <th rowspan="2">PARTICULARS</th>
                <th colspan="5" style="text-align:center;">
                    COST
                </th>
                <th></th>
                <th colspan="5" style="text-align:center;">
                    DEPRECIATION
                </th>
                <th rowspan="2">W.D.V </th>
            </tr>
            <tr>

                <th>Opening As
                </th>
                <th>Addition During <br> The Year</th>
                <th>Disposal During<br>The Year</th>
                <th>Adjustment During<br>The Year</th>
                <th>Closing As
                </th>
                <th>Rate<br>%</th>
                <th>Opening As
                </th>
                <th>Charge During <br> The Year</th>
                <th>Disposal During<br>The Year</th>
                <th>Adjustment During<br>The Year</th>
                <th>Closing As At

                </th>

            </tr>
        </thead>
        <tbody id="DataResult">
            @php($i = 0)
            @foreach ($category as $cate)
                <tr>
                    <td>{{ ++$i }}</td>
                    <td>{{ $cate->name_eng }}</td>
                    <td>{{ $costOpening = $cate->adding->sum('amount') - $cate->adjustmentOut->sum('amount') }}</td>
                    <td>{{ $cate->adding->sum('amount') }}</td>
                    <td></td>
                    <td>{{ $cate->adjustmentOut->sum('amount') }}</td>
                    <td>{{ $costClosing = $costOpening + $cate->adding->sum('amount') - $cate->adjustmentOut->sum('amount') }}
                    </td>
                    <td></td>
                    <td>{{ $openingDepre = $cate->addingDepreciation->sum('amount') - $cate->adjustmentOutDepreciation->sum('amount') }}
                    </td>
                    <td>{{ $cate->addingDepreciation->sum('amount') }}</td>
                    <td></td>
                    <td>{{ $cate->adjustmentOutDepreciation->sum('amount') }}</td>
                    <td>{{ $depreClosing = $cate->addingDepreciation->sum('amount') + $openingDepre - $cate->adjustmentOutDepreciation->sum('amount') }}
                    </td>
                    <td>{{ $costClosing - $depreClosing }}</td>
                </tr>
            @endforeach
        </tbody>
    </table>
@endsection