Viewing file:  profit_loss.blade.php (41.33 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
@extends('layouts.admin')
@section('page-title')
{{ __('Profit & Loss') }}
@endsection
@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('dashboard') }}">{{ __('Dashboard') }}</a></li>
<li class="breadcrumb-item">{{ __('Profit & Loss') }}</li>
@endsection
@push('script-page')
<script type="text/javascript" src="{{ asset('js/html2pdf.bundle.min.js') }}"></script>
<script>
var filename = $('#filename').val();
function saveAsPDF() {
var printContents = document.getElementById('printableArea').innerHTML;
var originalContents = document.body.innerHTML;
document.body.innerHTML = printContents;
window.print();
document.body.innerHTML = originalContents;
}
</script>
<script>
$(document).ready(function() {
$("#filter").click(function() {
$("#show_filter").toggle();
});
});
</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' => ['profit.loss.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" id="filter">
<button id="filter" class="btn btn-sm btn-primary"><i class="ti ti-filter"></i></button>
</div>
<div class="float-end me-2">
<a href="{{ route('report.profit.loss', 'horizontal') }}" class="btn btn-sm btn-primary" data-bs-toggle="tooltip"
title="{{ __('Horizontal View') }}" data-original-title="{{ __('Horizontal View') }}"><i
class="ti ti-separator-vertical"></i></a>
</div>
@endsection
@section('content')
<div class="row justify-content-center">
{{-- <div class="col-sm-8">
<div class="mt-2 " id="multiCollapseExample1">
<div class="card" id="show_filter" style="display:none;">
<div class="card-body">
{{ Form::open(['route' => ['report.profit.loss'], 'method' => 'GET', 'id' => 'report_trial_balance']) }}
<div class="row align-items-center justify-content-end">
<div class="col-xl-10">
<div class="row">
<div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
<div class="btn-box">
</div>
</div>
<div class="col-xl-3 col-lg-3 col-md-6 col-sm-12 col-12">
<div class="btn-box">
</div>
</div>
<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>
</div>
</div>
<div class="col-auto mt-4">
<div class="row">
<div class="col-auto">
<a href="#" class="btn btn-sm btn-primary"
onclick="document.getElementById('report_trial_balance').submit(); return false;"
data-bs-toggle="tooltip" title="{{ __('Apply') }}"
data-original-title="{{ __('apply') }}">
<span class="btn-inner--icon"><i class="ti ti-search"></i></span>
</a>
<a href="{{ route('report.profit.loss') }}" class="btn btn-sm btn-danger "
data-bs-toggle="tooltip" title="{{ __('Reset') }}"
data-original-title="{{ __('Reset') }}">
<span class="btn-inner--icon"><i
class="ti ti-trash-off text-white-off "></i></span>
</a>
</div>
</div>
</div>
</div>
</div>
{{ Form::close() }}
</div>
</div>
</div> --}}
<div class="col-md-8">
<div class="mt-2" id="multiCollapseExample1">
<div class="card" id="show_filter" style="display:none;">
<div class="card-body">
{{ Form::open(['route' => ['report.profit.loss'], 'method' => 'GET', 'id' => 'report_profit_loss']) }}
<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.profit.loss', ['vertical', 'collapse']) }}"
class="text-white" id="collapse"> {{ __('Collapse') }} </a>
</label>
<label class="btn btn-primary year-label active">
<a href="{{ route('report.profit.loss', ['vertical', '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>
<div class="col-auto mt-4">
<a href="#" class="btn btn-sm btn-primary"
onclick="document.getElementById('report_profit_loss').submit(); return false;"
data-bs-toggle="tooltip" title="{{ __('Apply') }}"
data-original-title="{{ __('apply') }}">
<span class="btn-inner--icon"><i class="ti ti-search"></i></span>
</a>
<a href="{{ route('report.profit.loss') }}" class="btn btn-sm btn-danger "
data-bs-toggle="tooltip" title="{{ __('Reset') }}"
data-original-title="{{ __('Reset') }}">
<span class="btn-inner--icon"><i
class="ti ti-trash-off text-white-off "></i></span>
</a>
</div>
</div>
</div>
</div>
</div>
</div>
{{ Form::close() }}
</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-8">
<div class="card">
<div class="card-body {{ $collapseView == 'expand' ? 'collapse-view' : '' }}">
<div class="account-main-title mb-5">
<h5>{{ 'Profit & Loss of ' . $user->name . ' as of ' . $filter['startDateRange'] . ' to ' . $filter['endDateRange'] }}
</h4>
</div>
<div
class="aacount-title d-flex align-items-center justify-content-between border-top border-bottom py-2">
<h6 class="mb-0">{{ __('Account') }}</h6>
<h6 class="mb-0 text-center">{{ _('Account Code') }}</h6>
<h6 class="mb-0 text-end">{{ __('Total') }}</h6>
</div>
@php
$totalIncome = 0;
$netProfit = 0;
$totalCosts = 0;
$grossProfit = 0;
@endphp
@foreach ($totalAccounts as $accounts)
@if ($accounts['Type'] == 'Income')
<div class="account-main-inner border-bottom py-2">
<p class="fw-bold mb-2">{{ $accounts['Type'] }}</p>
@foreach ($accounts['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-3">
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($record['netAmount']) }}
</p>
</div>
@endif
@if (!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == '')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($record['netAmount']) }}</p>
</div>
@endif
@php
if ($record['account_name'] === 'Total Income') {
$totalIncome = $record['netAmount'];
}
if ($record['account_name'] == 'Total Costs of Goods Sold') {
$totalCosts = $record['netAmount'];
}
$grossProfit = $totalIncome - $totalCosts;
@endphp
@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-3">
@if ($record['account'] == 'parent')
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($record['netAmount']) }}
</p>
</div>
@endif
@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-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($record['netAmount']) }}</p>
</div>
@endif
@php
if ($record['account_name'] === 'Total Income') {
$totalIncome = $record['netAmount'];
}
if ($record['account_name'] == 'Total Costs of Goods Sold') {
$totalCosts = $record['netAmount'];
}
$grossProfit = $totalIncome - $totalCosts;
@endphp
@endforeach
@endif
@endforeach
<div class="account-inner d-flex align-items-center justify-content-between">
<p class="fw-bold mb-2">
{{ $record['account_name'] ? $record['account_name'] : '' }}
</p>
<p class="fw-bold mb-2 text-end">
{{ $record['netAmount'] ? \Auth::user()->priceFormat($record['netAmount']) : \Auth::user()->priceFormat(0) }}
</p>
</div>
</div>
@endif
@if ($accounts['Type'] == 'Costs of Goods Sold')
<div class="account-main-inner border-bottom py-2">
<p class="fw-bold mb-2">{{ $accounts['Type'] }}</p>
@foreach ($accounts['account'] as $records)
@if ($collapseView == 'collapse')
@foreach ($records as $key => $record)
@php
if ($record['netAmount'] > 0) {
$netAmount = $record['netAmount'];
} else {
$netAmount = -$record['netAmount'];
}
@endphp
@if ($record['account'] == 'parentTotal')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($netAmount) }}
</p>
</div>
@endif
@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-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($netAmount) }}</p>
</div>
@endif
@php
if ($record['account_name'] === 'Total Income') {
$totalIncome = $netAmount;
}
if ($record['account_name'] == 'Total Costs of Goods Sold') {
$totalCosts = $netAmount;
}
$grossProfit = $totalIncome - $totalCosts;
@endphp
@endforeach
@else
@foreach ($records as $key => $record)
@php
if ($record['netAmount'] > 0) {
$netAmount = $record['netAmount'];
} else {
$netAmount = -$record['netAmount'];
}
@endphp
@if ($record['account'] == 'parent' || $record['account'] == 'parentTotal')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
@if ($record['account'] == 'parent')
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($netAmount) }}
</p>
</div>
@endif
@if (
(!preg_match('/\btotal\b/i', $record['account_name']) && $record['account'] == ''))
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($netAmount) }}</p>
</div>
@endif
@php
if ($record['account_name'] === 'Total Income') {
$totalIncome = $netAmount;
}
if ($record['account_name'] == 'Total Costs of Goods Sold') {
$totalCosts = $netAmount;
}
$grossProfit = $totalIncome - $totalCosts;
@endphp
@endforeach
@endif
@endforeach
<div class="account-inner d-flex align-items-center justify-content-between">
<p class="fw-bold mb-2">
{{ $record['account_name'] ? $record['account_name'] : '' }}
</p>
<p class="fw-bold mb-2 text-end">
{{ $record['netAmount'] ? \Auth::user()->priceFormat($netAmount) : \Auth::user()->priceFormat(0) }}
</p>
</div>
</div>
@endif
@endforeach
@if ($grossProfit > 0)
<div class="account-inner d-flex align-items-center justify-content-between border-bottom">
<p></p>
<p class="fw-bold mb-2 text-center">{{ __('Gross Profit') }}</p>
<p class="text-primary mb-2 float-end text-end">
{{ \Auth::user()->priceFormat($grossProfit) }}</p>
</div>
@endif
@foreach ($totalAccounts as $accounts)
@if ($accounts['Type'] == 'Expenses')
<div class="account-main-inner border-bottom py-2">
<p class="fw-bold mb-2">{{ $accounts['Type'] }}</p>
@foreach ($accounts['account'] as $records)
@if ($collapseView == 'collapse')
@foreach ($records as $key => $record)
@php
if ($record['netAmount'] > 0) {
$netAmount = $record['netAmount'];
} else {
$netAmount = -$record['netAmount'];
}
@endphp
@if ($record['account'] == 'parentTotal')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($netAmount) }}
</p>
</div>
@endif
@if (
!preg_match('/\btotal\b/i', $record['account_name']) &&
$record['account'] == '')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($netAmount) }}</p>
</div>
@endif
@php
if ($record['account_name'] === 'Total Income') {
$totalIncome = $record['netAmount'];
}
if ($record['account_name'] == 'Total Costs of Goods Sold') {
$totalCosts = $record['netAmount'];
}
$grossProfit = $totalIncome - $totalCosts;
@endphp
@endforeach
@else
@foreach ($records as $key => $record)
@php
if ($record['netAmount'] > 0) {
$netAmount = $record['netAmount'];
} else {
$netAmount = -$record['netAmount'];
}
@endphp
@if ($record['account'] == 'parent' || $record['account'] == 'parentTotal')
<div
class="account-inner d-flex align-items-center justify-content-between ps-3">
@if ($record['account'] == 'parent')
<div class="mb-2 ms-2 account-arrow">
<div class="">
<a
href="{{ route('report.profit.loss', ['vertical', '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">
{{ \Auth::user()->priceFormat($netAmount) }}
</p>
</div>
@endif
@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-3">
<p class="mb-2 ms-4"><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">
{{ \Auth::user()->priceFormat($netAmount) }}</p>
</div>
@endif
@php
if ($record['account_name'] == 'Total Expenses') {
$totalCosts = $netAmount;
}
$netProfit = $grossProfit - $totalCosts;
@endphp
@endforeach
@endif
@endforeach
<div class="account-inner d-flex align-items-center justify-content-between">
<p class="fw-bold mb-2">
{{ $record['account_name'] ? $record['account_name'] : '' }}
</p>
<p class="fw-bold mb-2 text-end">
{{ $record['netAmount'] ? \Auth::user()->priceFormat($netAmount) : \Auth::user()->priceFormat(0) }}
</p>
</div>
</div>
<div class="account-inner d-flex align-items-center justify-content-between border-bottom">
<p></p>
<p class="fw-bold mb-2 text-center">{{ __('Net Profit/Loss') }}</p>
<p class="text-primary mb-2 float-end text-end">
{{ \Auth::user()->priceFormat($netProfit) }}</p>
</div>
@endif
@endforeach
</div>
</div>
</div>
</div>
@endsection
|