@extends('admin::curd.preview') @section('heading') @stop @section('title') @stop @section('breadcrumb') @stop @section('entry') @stop @section('tools') @stop @section('content')
` Excel {{-- --}}

Depreciation Ref : {{ $asset_depreciation->ref }}

Depreciation Type : {{ $asset_depreciation->category }}

Status : {{ $asset_depreciation->status }}

@if (@$asset_depreciation->status == 'Posted')

Voucher No : {{ $asset_depreciation->voucher_number }}

Posted Date : {{ @date('d M , Y', strtotime($asset_depreciation->posted_date)) }}

@endif

Depreciation Amount : {{ $asset_depreciation->total_amount }}

Total Asset Count : {{ $asset_depreciation->asset_count }}

@if (@$asset_depreciation->category == 'Company Act') @else @endif @forelse($assets as $key => $val) @if (@$asset_depreciation->category == 'Company Act') @else @endif @empty @endif @if ($sum > 0) @if ($asset_depreciation->category == 'Company Act') @else @endif @endif

Assets

Sr Asset Ref Asset & Group Name Insurance No. Start Date End Date DaysSalvage Est Depreciation MethodPer%Asset Value Accu Depre. Opening Value Depreciation % Depreciation Amount Closing Value
{{ @$key + 1 }} {{ @$val->rfc ?: @$val->ref }} {{ @ucfirst($val->asset_name) }}
{{ @$asset_depreciation->category == 'Company Act' ? @$val->group_name : @$val->depreciation_group_name }}
{{ $val->ins_policy_no ?: '-' }} {{ @date('d M , Y', strtotime($val->start_date)) }} {{ @date('d M , Y', strtotime($val->end_date)) }} {{ $val->days }}{{ $val->sal_value }} {{ $val->est }} {{ @$val->asset_depreciation_type }}{{ $val->pre }}{{ $val->asset_value }} {{ $val->acc_dep }} {{ $val->asset_value - $val->acc_dep }} {{round(($val->amount / $val->asset_value)* 100,2) ?: '-' }} {{ $val->amount ?: '-' }} {{ $val->asset_value - $val->acc_dep - $val->amount }}
No Assets
Total {{ $opening_balance }} {!! $sum ? number_format($sum, 2, '.', '') : '-' !!} {{ $closing_balance }} Total {{ $opening_balance }} {!! $sum ? number_format($sum, 2, '.', '') : '-' !!} {{ $closing_balance }}
@stop