One Hat Cyber Team

Edit File: balance_sheet_horizontal.blade.php

@extends('layouts.admin')
@section('page-title')
    {{ __('Balance Sheet') }}
@endsection
@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">{{ __('Dashboard') }}</a></li>
    <li class="breadcrumb-item">{{ __('Balance Sheet') }}</li>
@endsection
@push('script-page')
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>

function saveAsPDF() {
            var printContents = document.getElementById('printableArea').innerHTML;
            var originalContents = document.body.innerHTML;
            document.body.innerHTML = printContents;
            window.print();
            document.body.innerHTML = originalContents;
        }
    </script>

function callback() {
                var start_date = $(".startDate").val();
                var end_date = $(".endDate").val();

$('.start_date').val(start_date);
                $('.end_date').val(end_date);

}
        });
    </script>
@endpush

@section('action-btn')
    <div class="float-end">
        <a href="#" onclick="saveAsPDF()" class="btn btn-sm btn-primary me-1" data-bs-toggle="tooltip"
            title="{{ __('Print') }}" data-original-title="{{ __('Print') }}"><i class="ti ti-printer"></i></a>
    </div>

<div class="float-end me-2">
        {{ Form::open(['route' => ['balance.sheet.export']]) }}
        <input type="hidden" name="start_date" class="start_date">
        <input type="hidden" name="end_date" class="end_date">
        <button type="submit" class="btn btn-sm btn-primary" data-bs-toggle="tooltip" title="{{ __('Export') }}"
            data-original-title="{{ __('Export') }}"><i class="ti ti-file-export"></i></button>
        {{ Form::close() }}
    </div>

<div class="float-end me-2">
        <a href="{{ route('report.balance.sheet', 'vertical') }}" class="btn btn-sm btn-primary" data-bs-toggle="tooltip"
            title="{{ __('Vertical View') }}" data-original-title="{{ __('Vertical View') }}"><i
                class="ti ti-separator-horizontal"></i></a>
    </div>
@endsection

@section('content')
    <div class="mt-4">
        <div class="row justify-content-center">
            <div class="col-md-12">
                <div class="mt-2" id="multiCollapseExample1">
                    <div class="card" id="show_filter" style="display:none;">
                        <div class="card-body">
                            {{ Form::open(['route' => ['report.balance.sheet'], 'method' => 'GET', 'id' => 'report_bill_summary']) }}
                            <div class="col-xl-12">

<div class="row justify-content-between">
                                    <div class="col-xl-3 mt-4">
                                        <div class="btn-group btn-group-toggle" data-toggle="buttons"
                                            aria-label="Basic radio toggle button group">
                                            <label class="btn btn-primary month-label">
                                                <a href="{{ route('report.balance.sheet', ['horizontal', 'collapse']) }}"
                                                    class="text-white" id="collapse"> {{ __('Collapse') }} </a>
                                            </label>
                                            <label class="btn btn-primary year-label active">
                                                <a href="{{ route('report.balance.sheet', ['horizontal', 'expand']) }}"
                                                    class="text-white"> {{ __('Expand') }} </a>
                                            </label>
                                        </div>
                                    </div>
                                    <div class="col-xl-9">
                                        <div class="row justify-content-end align-items-center">
                                            <div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                                <div class="btn-box">
                                                    {{ Form::label('start_date', __('Start Date'), ['class' => 'form-label']) }}
                                                    {{ Form::date('start_date', $filter['startDateRange'], ['class' => 'startDate form-control']) }}
                                                </div>
                                            </div>

<div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
                                                <div class="btn-box">
                                                    {{ Form::label('end_date', __('End Date'), ['class' => 'form-label']) }}
                                                    {{ Form::date('end_date', $filter['endDateRange'], ['class' => 'endDate form-control']) }}
                                                </div>
                                            </div>
                                            <input type="hidden" name="view" value="horizontal">

</div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            {{ Form::close() }}
                        </div>
                    </div>
                </div>
            </div>
        </div>

@php
            $authUser = \Auth::user()->creatorId();
            $user = App\Models\User::find($authUser);
        @endphp

<div class="row justify-content-center" id="printableArea">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body {{ $collapseview == 'expand' ? 'collapse-view' : '' }}">
                        <div class="account-main-title mb-5">
                            <h5>{{ 'Balance Sheet of ' . $user->name . ' as of ' . $filter['startDateRange'] . ' to ' . $filter['endDateRange'] }}
                                </h4>
                        </div>

@php
                            $totalAmount = 0;
                        @endphp

<div class="row">
                            <div class="col-md-6">
                                <div class="aacount-title d-flex align-items-center justify-content-between border py-2">
                                    <h5 class="mb-0 ms-3">{{ __('Liabilities & Equity') }}</h5>
                                </div>
                                <div class="border-start border-end">
                                    @foreach ($totalAccounts as $type => $accounts)
                                        @if ($accounts != [] && $type != 'Assets')
                                            <div class="account-main-inner py-2">
                                                <p class="fw-bold ps-2 mb-2">{{ $type }}</p>
                                                @php
                                                    $total = 0;
                                                @endphp
                                                @foreach ($accounts as $account)
                                                    <div class="border-bottom py-2">
                                                        <p class="fw-bold ps-4 mb-2">
                                                            {{ $account['subType'] == true ? $account['subType'] : '' }}
                                                        </p>
                                                        @foreach ($account['account'] as $records)
                                                        @if ($collapseview == 'collapse')
                                                        @foreach ($records as $key => $record)
                                                            @if ($record['account'] == 'parentTotal')
                                                                <div
                                                                    class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                    <div class="mb-2 account-arrow">
                                                                        <div class="">
                                                                            <a
                                                                                href="{{ route('report.balance.sheet', ['horizontal', 'expand']) }}"><i
                                                                                    class="ti ti-chevron-down account-icon"></i></a>
                                                                        </div>
                                                                        <a href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                            class="text-primary">{{ str_replace('Total ', '', $record['account_name']) }}</a>
                                                                    </div>
                                                                    <p class="mb-2 ms-3 text-center">
                                                                        {{ $record['account_code'] }}</p>
                                                                    <p
                                                                        class="text-primary mb-2 float-end text-end me-3">
                                                                        {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                    </p>
                                                                </div>
                                                            @endif
                                                            @if (($key < count($account['account']) - 1 && $record['account'] == '') || $record['account'] != 'subAccount')
                                                                @if (
                                                                    (!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == '') ||
                                                                        $record['account'] == 'subAccount')
                                                                    <div
                                                                        class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                        <p class="mb-2 ms-3"><a
                                                                                href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                class="text-primary">{{ $record['account_name'] }}</a>
                                                                        </p>
                                                                        <p class="mb-2 text-center">
                                                                            {{ $record['account_code'] }}</p>
                                                                        <p
                                                                            class="text-primary mb-2 float-end text-end me-3">
                                                                            {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                        </p>
                                                                    </div>
                                                                @endif
                                                            @endif
                                                        @endforeach
                                                    @else
                                                        @foreach ($records as $key => $record)
                                                            @if ($record['account'] == 'parent' || $record['account'] == 'parentTotal')
                                                                <div
                                                                    class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                    @if ($record['account'] == 'parent')
                                                                        <div class="mb-2 account-arrow">
                                                                            <div class="">
                                                                                <a
                                                                                    href="{{ route('report.balance.sheet', ['horizontal', 'collapse']) }}"><i
                                                                                        class="ti ti-chevron-down account-icon"></i></a>
                                                                            </div>
                                                                            <a href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                class="{{ $record['account'] == 'parent' ? 'text-primary' : 'text-dark' }} fw-bold">{{ $record['account_name'] }}</a>
                                                                        </div>
                                                                    @else
                                                                        <p class="mb-2"><a href="#"
                                                                                class="text-dark fw-bold">{{ $record['account_name'] }}</a>
                                                                        </p>
                                                                    @endif
                                                                    <p class="mb-2 ms-3 text-center">
                                                                        {{ $record['account_code'] }}</p>
                                                                    <p
                                                                        class="text-dark fw-bold mb-2 float-end text-end me-3">
                                                                        {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                    </p>
                                                                </div>
                                                            @endif
                                                            @if (($key < count($account['account']) - 1 && $record['account'] == '') || $record['account'] == 'subAccount')
                                                                @if (
                                                                    (!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == '') ||
                                                                        $record['account'] == 'subAccount')
                                                                    <div
                                                                        class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                        <p class="mb-2 ms-3"><a
                                                                                href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                class="text-primary">{{ $record['account_name'] }}</a>
                                                                        </p>
                                                                        <p class="mb-2 text-center">
                                                                            {{ $record['account_code'] }}</p>
                                                                        <p
                                                                            class="text-primary mb-2 float-end text-end me-3">
                                                                            {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                        </p>
                                                                    </div>
                                                                @endif
                                                            @endif
                                                        @endforeach
                                                        @endif
                                                        @endforeach
                                                        <div
                                                            class="account-inner d-flex align-items-center justify-content-between ps-4">
                                                            <p class="fw-bold mb-2">
                                                                {{ $record['account_name'] ? $record['account_name'] : '' }}
                                                            </p>
                                                            <p class="fw-bold mb-2 text-end me-3">
                                                                {{ $record['netAmount'] ? \Auth::user()->priceFormat($record['netAmount']) : \Auth::user()->priceFormat(0) }}
                                                            </p>
                                                        </div>
                                                    </div>

@php
                                                        $total += $record['netAmount'] ? $record['netAmount'] : 0;
                                                    @endphp
                                                @endforeach
                                                <div
                                                    class="aacount-title d-flex align-items-center justify-content-between border-top border-bottom py-2 px-2 pe-0">
                                                    <h6 class="fw-bold mb-0">{{ 'Total for ' . $type }}</h6>
                                                    <h6 class="fw-bold mb-0 text-end me-3">
                                                        {{ \Auth::user()->priceFormat($total) }}</h6>
                                                </div>
                                                @php
                                                    if ($type != 'Assets') {
                                                        $totalAmount += $total;
                                                    }
                                                @endphp
                                            </div>
                                        @endif
                                    @endforeach
                                    @if ($totalAmount != 0)
                                        <div
                                            class="d-flex align-items-center justify-content-between border-bottom py-2 px-0">
                                            <h6 class="fw-bold mb-0 ms-2">{{ 'Total for Liabilities & Equity' }}</h6>
                                            <h6 class="fw-bold mb-0 text-end me-3">
                                                {{ \Auth::user()->priceFormat($totalAmount) }}</h6>
                                        </div>
                                    @endif
                                </div>

</div>

@php
                                $total = 0;
                                $totalAmounts = 0;
                            @endphp

<div class="col-md-6">
                                <div class="aacount-title d-flex align-items-center justify-content-between border py-2">
                                    <h5 class="mb-0 ms-3">{{ __('Assets') }}</h5>
                                </div>
                                <div class="border-start border-end">
                                    @foreach ($totalAccounts as $type => $accounts)
                                        @if ($accounts != [] && $type == 'Assets')
                                            <div class="account-main-inner py-2">
                                                @if ($type == 'Liabilities')
                                                    <p class="fw-bold mb-3"> {{ __('Liabilities & Equity') }}</p>
                                                @endif
                                                <p class="fw-bold ps-2 mb-2">{{ $type }}</p>
                                                @foreach ($accounts as $account)
                                                    <div class="border-bottom py-2">
                                                        <p class="fw-bold ps-4 mb-2">
                                                            {{ $account['subType'] == true ? $account['subType'] : '' }}
                                                        </p>
                                                        @foreach ($account['account'] as $records)
                                                            @if ($collapseview == 'collapse')
                                                                @foreach ($records as $key => $record)
                                                                    @if ($record['account'] == 'parentTotal')
                                                                        <div
                                                                            class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                            <div class="mb-2 account-arrow">
                                                                                <div class="">
                                                                                    <a
                                                                                        href="{{ route('report.balance.sheet', ['horizontal', 'expand']) }}"><i
                                                                                            class="ti ti-chevron-down account-icon"></i></a>
                                                                                </div>
                                                                                <a href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                    class="text-primary">{{ str_replace('Total ', '', $record['account_name']) }}</a>
                                                                            </div>
                                                                            <p class="mb-2 ms-3 text-center">
                                                                                {{ $record['account_code'] }}</p>
                                                                            <p
                                                                                class="text-primary mb-2 float-end text-end me-3">
                                                                                {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                            </p>
                                                                        </div>
                                                                    @endif
                                                                    @if (($key < count($account['account']) - 1 && $record['account'] == '') || $record['account'] != 'subAccount')
                                                                        @if (
                                                                            (!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == '') ||
                                                                                $record['account'] == 'subAccount')
                                                                            <div
                                                                                class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                                <p class="mb-2 ms-3"><a
                                                                                        href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                        class="text-primary">{{ $record['account_name'] }}</a>
                                                                                </p>
                                                                                <p class="mb-2 text-center">
                                                                                    {{ $record['account_code'] }}</p>
                                                                                <p
                                                                                    class="text-primary mb-2 float-end text-end me-3">
                                                                                    {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                                </p>
                                                                            </div>
                                                                        @endif
                                                                    @endif
                                                                @endforeach
                                                            @else
                                                                @foreach ($records as $key => $record)
                                                                    @if ($record['account'] == 'parent' || $record['account'] == 'parentTotal')
                                                                        <div
                                                                            class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                            @if ($record['account'] == 'parent')
                                                                                <div class="mb-2 account-arrow">
                                                                                    <div class="">
                                                                                        <a
                                                                                            href="{{ route('report.balance.sheet', ['horizontal', 'collapse']) }}"><i
                                                                                                class="ti ti-chevron-down account-icon"></i></a>
                                                                                    </div>
                                                                                    <a href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                        class="{{ $record['account'] == 'parent' ? 'text-primary' : 'text-dark' }} fw-bold">{{ $record['account_name'] }}</a>
                                                                                </div>
                                                                            @else
                                                                                <p class="mb-2"><a href="#"
                                                                                        class="text-dark fw-bold">{{ $record['account_name'] }}</a>
                                                                                </p>
                                                                            @endif
                                                                            <p class="mb-2 ms-3 text-center">
                                                                                {{ $record['account_code'] }}</p>
                                                                            <p
                                                                                class="text-dark fw-bold mb-2 float-end text-end me-3">
                                                                                {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                            </p>
                                                                        </div>
                                                                    @endif
                                                                    @if (($key < count($account['account']) - 1 && $record['account'] == '') || $record['account'] == 'subAccount')
                                                                        @if (
                                                                            (!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == '') ||
                                                                                $record['account'] == 'subAccount')
                                                                            <div
                                                                                class="account-inner d-flex align-items-center justify-content-between ps-5">
                                                                                <p class="mb-2 ms-3"><a
                                                                                        href="{{ route('report.ledger', $record['account_id']) }}?account={{ $record['account_id'] }}"
                                                                                        class="text-primary">{{ $record['account_name'] }}</a>
                                                                                </p>
                                                                                <p class="mb-2 text-center">
                                                                                    {{ $record['account_code'] }}</p>
                                                                                <p
                                                                                    class="text-primary mb-2 float-end text-end me-3">
                                                                                    {{ \Auth::user()->priceFormat($record['netAmount']) }}
                                                                                </p>
                                                                            </div>
                                                                        @endif
                                                                    @endif
                                                                @endforeach
                                                                @endif
                                                            @endforeach

<div
                                                                class="account-inner d-flex align-items-center justify-content-between ps-4">
                                                                <p class="fw-bold mb-2">
                                                                    {{ $record['account_name'] ? $record['account_name'] : 0 }}
                                                                </p>
                                                                <p class="fw-bold mb-2 text-end me-3">
                                                                    {{ $record['netAmount'] ? \Auth::user()->priceFormat($record['netAmount']) : \Auth::user()->priceFormat(0) }}
                                                                </p>
                                                            </div>
                                                    </div>

@php
                                                        $total += $record['netAmount'] ? $record['netAmount'] : 0;
                                                    @endphp
                                                @endforeach
                                                @php
                                                    if ($type == 'Assets') {
                                                        $totalAmounts += $total;
                                                    }
                                                @endphp

</div>
                                        @endif
                                    @endforeach
                                    @if ($totalAmounts != 0)
                                        <div
                                            class="d-flex align-items-center justify-content-between border-bottom py-2 px-0">
                                            <h6 class="fw-bold mb-0 ms-2">{{ 'Total for Assets' }}</h6>
                                            <h6 class="fw-bold mb-0 text-end me-3">
                                                {{ \Auth::user()->priceFormat($totalAmounts) }}</h6>
                                        </div>
                                    @endif
                                </div>

</div>
                        </div>

</div>
                </div>
            </div>
        </div>
    </div>
@endsection