⚝
One Hat Cyber Team
⚝
Your IP:
172.22.0.1
Server IP:
151.80.20.34
Server:
Linux 794f04d97d5e 5.15.0-143-generic #153-Ubuntu SMP Fri Jun 13 19:10:45 UTC 2025 x86_64
Server Software:
Apache/2.4.62 (Debian)
PHP Version:
8.2.28
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
var
/
www
/
html
/
resources
/
views
/
chartOfAccount
/
View File Name :
show.blade.php
@extends('layouts.admin') @section('page-title') {{ __('Account Drilldown Report') }} @endsection @section('breadcrumb') <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">{{ __('Dashboard') }}</a></li> <li class="breadcrumb-item"><a href="{{ route('chart-of-account.index') }}">{{ __('Chart of Account') }}</a></li> <li class="breadcrumb-item">{{ __('Account Drilldown Report') }}</li> <li class="breadcrumb-item">{{ ucwords($account->code . ' - ' . $account->name) }}</li> @endsection @section('content') <div class="row"> <div class="col-sm-12"> <div class="mt-2 " id="multiCollapseExample1"> <div class="card"> <div class="card-body"> {{ Form::open(['route' => ['chart-of-account.show', $account->id], 'method' => 'GET', 'id' => 'report_drilldown']) }} {{-- @dd($account->name) --}} <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"> {{ Form::label('start_date', __('Start Date'), ['class' => 'form-label']) }} {{ Form::date('start_date', $filter['startDateRange'], ['class' => 'month-btn 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' => 'month-btn 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('account', __('Account'), ['class' => 'form-label']) }} {{ Form::select('account', $accounts, isset($_GET['account']) ? $_GET['account'] : '', ['class' => 'form-control select']) }} </div> </div> </div> </div> <div class="col-auto"> <div class="row"> <div class="col-auto mt-4"> <a href="#" class="btn btn-sm btn-primary" onclick="document.getElementById('report_drilldown').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('chart-of-account.show', $account->id) }}" 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> <div id="printableArea"> <div class="row mt-2"> <div class="col-3"> {{-- <input type="hidden" value="{{__('Ledger').' '.'Report of'.' '.$filter['startDateRange'].' to '.$filter['endDateRange']}}" id="filename"> --}} <div class="card p-4 mb-4"> <h6 class="mb-0">{{ __('Report') }} :</h6> <h7 class="text-sm mb-0">{{ __('Account Drilldown') }}</h7> </div> </div> @if (!empty($account)) <div class="col-3"> <div class="card p-4 mb-4"> <h6 class="mb-0">{{ __('Account Name') }} :</h6> <h7 class="text-sm mb-0">{{ $account->name }}</h7> </div> </div> <div class="col-3"> <div class="card p-4 mb-4"> <h6 class="mb-0">{{ __('Account Code') }} :</h6> <h7 class="text-sm mb-0">{{ $account->code }}</h7> </div> </div> @endif <div class="col-3"> <div class="card p-4 mb-4"> <h6 class="mb-0">{{ __('Duration') }} :</h6> <h7 class="text-sm mb-0">{{ $filter['startDateRange'] . ' to ' . $filter['endDateRange'] }}</h7> </div> </div> </div> <div class="row mb-4"> <div class="col-12 mb-4"> <div class="card"> <div class="card-body table-border-style"> <div class="table-responsive"> <table class="table"> <thead> <tr> <th> {{ __('Account Name') }}</th> <th> {{ __('Name') }}</th> <th> {{ __('Transaction Type') }}</th> <th> {{ __('Transaction Date') }}</th> <th> {{ __('Debit') }}</th> <th> {{ __('Credit') }}</th> <th> {{ __('Balance') }}</th> </tr> </thead> <tbody> @php $balance = 0; $totalDebit = 0; $totalCredit = 0; $chartDatas = App\Models\Utility::getAccountData($account->id, $filter['startDateRange'], $filter['endDateRange']); $accountName = \App\Models\ChartOfAccount::find($account->id); @endphp @foreach ($chartDatas['invoice'] as $invoiceData) <tr> <td>{{ $accountName->name }}</td> @php $invoice = \App\Models\Invoice::where('id', $invoiceData->invoice_id)->first(); @endphp <td>{{ !empty($invoice->customer) ? $invoice->customer->name : '-' }}</td> <td>{{ \Auth::user()->invoiceNumberFormat($invoice->invoice_id) }}</td> <td>{{ $invoiceData->created_at->format('d-m-Y') }}</td> <td>-</td> @php $total = $invoiceData->price * $invoiceData->quantity; $balance += $total; $totalCredit += $total; @endphp <td>{{ \Auth::user()->priceFormat($total) }}</td> <td>{{ \Auth::user()->priceFormat($balance) }}</td> </tr> @endforeach @foreach ($chartDatas['invoicepayment'] as $invoicePaymentData) <tr> <td>{{ $accountName->name }}</td> @php $invoice = \App\Models\Invoice::where('id', $invoicePaymentData->invoice_id)->first(); @endphp <td>{{ !empty($invoice->customer) ? $invoice->customer->name : '-' }}</td> <td>{{ \Auth::user()->invoiceNumberFormat($invoice->invoice_id) }} {{ __(' Manually Payment') }}</td> <td>{{ $invoicePaymentData->created_at->format('d-m-Y') }}</td> <td>-</td> <td>{{ \Auth::user()->priceFormat($invoicePaymentData->amount) }}</td> @php $balance += $invoicePaymentData->amount; $totalCredit += $invoicePaymentData->amount; @endphp <td>{{ \Auth::user()->priceFormat($balance) }}</td> </tr> @endforeach @foreach ($chartDatas['revenue'] as $revenueData) <tr> <td>{{ $accountName->name }}</td> <td>{{ !empty($revenueData->customer) ? $revenueData->customer->name : '-' }} </td> <td>{{ __('Revenue') }}</td> <td>{{ $revenueData->created_at->format('d-m-Y') }}</td> <td>-</td> <td>{{ \Auth::user()->priceFormat($revenueData->amount) }}</td> @php $balance += $revenueData->amount; $totalCredit += $revenueData->amount; @endphp <td>{{ \Auth::user()->priceFormat($balance) }}</td> </tr> @endforeach @foreach ($chartDatas['bill'] as $billProduct) <tr> <td>{{ $accountName->name }}</td> @php $bill = \App\Models\Bill::find($billProduct->bill_id); $vendor = \App\Models\Vender::find(!empty($bill) ? $bill->vender_id : ''); @endphp <td>{{ !empty($vendor) ? $vendor->name : '-' }}</td> <td>{{ \Auth::user()->billNumberFormat($bill->bill_id) }}</td> <td>{{ $billProduct->created_at->format('d-m-Y') }}</td> @php $total = $billProduct->price * $billProduct->quantity; $balance -= $total; $totalCredit -= $total; @endphp <td>{{ \Auth::user()->priceFormat($total) }}</td> <td>-</td> <td>{{ \Auth::user()->priceFormat($balance) }}</td> </tr> @endforeach @foreach ($chartDatas['billdata'] as $billData) @php $bill = \App\Models\Bill::find($billData->ref_id); $vendor = \App\Models\Vender::find(!empty($bill) ? $bill->vender_id : ''); @endphp <tr> <td>{{ $accountName->name }}</td> <td>{{ !empty($vendor) ? $vendor->name : '-' }}</td> @if (!empty($bill->bill_id)) <td>{{ \Auth::user()->billNumberFormat($bill->bill_id) }}</td> @else <td>-</td> @endif <td>{{ $billData->created_at->format('d-m-Y') }}</td> <td>{{ \Auth::user()->priceFormat($billData->price) }}</td> <td>-</td> @php $balance -= $billData->price; $totalDebit -= $billData->price; @endphp <td>{{ \Auth::user()->priceFormat($balance) }}</td> </tr> @endforeach @foreach ($chartDatas['billpayment'] as $billPaymentData) @php $bill = \App\Models\BillPayment::where('bill_id', $billPaymentData->bill_id)->first(); $billId = \App\Models\Bill::find($billPaymentData->bill_id); $vendor = \App\Models\Vender::find($billId->vender_id); @endphp <tr> <td>{{ $accountName->name }}</td> <td>{{ !empty($vendor) ? $vendor->name : '-' }}</td> <td>{{ \Auth::user()->billNumberFormat($billId->bill_id) }}{{ __(' Manually Payment') }} </td> <td>{{ $billPaymentData->created_at->format('d-m-Y') }}</td> <td>{{ \Auth::user()->priceFormat($billPaymentData->amount) }}</td> <td>-</td> @php $balance += $billPaymentData->amount; $totalDebit += $billPaymentData->amount; @endphp <td>{{ \Auth::user()->priceFormat($totalCredit - $totalDebit) }}</td> </tr> @endforeach @foreach ($chartDatas['payment'] as $paymentData) @php $vendor = \App\Models\Vender::find($paymentData->vender_id); @endphp <tr> <td>{{ $accountName->name }}</td> <td>{{ !empty($vendor) ? $vendor->name : '-' }}</td> <td>{{ __('Payment') }}</td> <td>{{ $paymentData->created_at->format('d-m-Y') }}</td> <td>{{ \Auth::user()->priceFormat($paymentData->amount) }}</td> <td>-</td> @php $balance += $paymentData->amount; $totalDebit += $paymentData->amount; @endphp <td>{{ \Auth::user()->priceFormat($totalCredit - $totalDebit) }}</td> </tr> @endforeach @php $debit = 0; $credit = 0; @endphp @foreach ($chartDatas['journalItem'] as $journalItemData) <tr> <td>{{ $accountName->name }}</td> <td>{{ '-' }}</td> <td>{{ AUth::user()->journalNumberFormat($journalItemData->journal_id) }} </td> <td>{{ $journalItemData->created_at->format('d-m-Y') }}</td> <td>{{ Auth::user()->priceFormat($journalItemData->debit) }}</td> <td>{{ \Auth::user()->priceFormat($journalItemData->credit) }}</td> <td> @if ($journalItemData->debit) @php $balance-= $journalItemData->debit @endphp @else @php $balance+= $journalItemData->credit @endphp @endif {{ \Auth::user()->priceFormat($balance) }} </td> </tr> @endforeach </tbody> </table> </div> </div> </div> </div> </div> </div> @endsection