Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory : /home/fdshops/public_html/resources/views/account_reports/ |
@extends('layouts.app')
@section('title', __( 'account.balance_sheet' ))
@section('content')
<!-- Content Header (Page header) -->
<section class="content-header">
<h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">@lang( 'account.balance_sheet')
</h1>
</section>
<!-- Main content -->
<section class="content">
<div class="row no-print">
<div class="col-sm-12">
@component('components.filters', ['title' => __('report.filters')])
<div class="col-md-3">
<div class="form-group">
{!! Form::label('bal_sheet_location_id', __('purchase.business_location') . ':') !!}
{!! Form::select('bal_sheet_location_id', $business_locations, null, ['class' => 'form-control select2', 'style' => 'width:100%']); !!}
</div>
</div>
<div class="col-sm-3 col-xs-6">
<label for="end_date">@lang('messages.filter_by_date'):</label>
<div class="input-group">
<span class="input-group-addon">
<i class="fa fa-calendar"></i>
</span>
<input type="text" id="end_date" value="{{@format_date('now')}}" class="form-control" readonly>
</div>
</div>
@endcomponent
</div>
</div>
<br>
<div class="box box-solid">
<div class="box-header print_section">
<h3 class="box-title">{{session()->get('business.name')}} - @lang( 'account.balance_sheet') - <span id="hidden_date">{{@format_date('now')}}</span></h3>
</div>
<div class="box-body">
<table class="table table-border-center no-border table-pl-12">
<thead>
<tr class="bg-gray">
<th>@lang( 'account.liability')</th>
<th>@lang( 'account.assets')</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<table class="table">
<tr>
<th>@lang('account.supplier_due'):</th>
<td>
<input type="hidden" id="hidden_supplier_due" class="liability">
<span class="remote-data" id="supplier_due">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
</tr>
</table>
</td>
<td>
<table class="table" id="assets_table">
<tbody>
<tr>
<th>@lang('account.customer_due'):</th>
<td>
<input type="hidden" id="hidden_customer_due" class="asset">
<span class="remote-data" id="customer_due">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
</tr>
<tr>
<th>@lang('report.closing_stock'):</th>
<td>
<input type="hidden" id="hidden_closing_stock" class="asset">
<span class="remote-data" id="closing_stock">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
</tr>
<tr>
<th colspan="2">@lang('account.account_balances'):</th>
</tr>
</tbody>
<tbody id="account_balances" class="pl-20-td">
<tr><td colspan="2"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>
</tbody>
{{--
<tbody>
<tr>
<th colspan="2">@lang('account.capital_accounts'):</th>
</tr>
</tbody>
<tbody id="capital_account_balances" class="pl-20-td">
<tr><td colspan="2"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>
</tbody>
--}}
</table>
</td>
</tr>
</tbody>
<tfoot>
<tr class="bg-gray">
<td>
<table class="table bg-gray mb-0 no-border">
<tr>
<th>
@lang('account.total_liability'):
</th>
<td>
<span id="total_liabilty"><i class="fas fa-sync fa-spin fa-fw"></i></span>
</td>
</tr>
</table>
</td>
<td>
<table class="table bg-gray mb-0 no-border">
<tr>
<th>
@lang('account.total_assets'):
</th>
<td>
<span id="total_assets"><i class="fas fa-sync fa-spin fa-fw"></i></span>
</td>
</tr>
</table>
</td>
</tr>
</tfoot>
</table>
</div>
<div class="box-footer">
<button type="button" class="tw-dw-btn tw-dw-btn-primary tw-text-white no-print pull-right"onclick="window.print()">
<i class="fa fa-print"></i> @lang('messages.print')</button>
</div>
</div>
</section>
<!-- /.content -->
@stop
@section('javascript')
<script type="text/javascript">
$(document).ready( function(){
//Date picker
$('#end_date').datepicker({
autoclose: true,
format: datepicker_date_format
});
update_balance_sheet();
$('#end_date').change( function() {
update_balance_sheet();
$('#hidden_date').text($(this).val());
});
$('#bal_sheet_location_id').change( function() {
update_balance_sheet();
});
});
function update_balance_sheet(){
var loader = '<i class="fas fa-sync fa-spin fa-fw"></i>';
$('span.remote-data').each( function() {
$(this).html(loader);
});
$('table#assets_table tbody#account_balances').html('<tr><td colspan="2"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>');
$('table#assets_table tbody#capital_account_balances').html('<tr><td colspan="2"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>');
var end_date = $('input#end_date').val();
var location_id = $('#bal_sheet_location_id').val()
$.ajax({
url: "{{action([\App\Http\Controllers\AccountReportsController::class, 'balanceSheet'])}}?end_date=" + end_date + '&location_id=' + location_id,
dataType: "json",
success: function(result){
$('span#supplier_due').text(__currency_trans_from_en(result.supplier_due, true));
__write_number($('input#hidden_supplier_due'), result.supplier_due);
$('span#customer_due').text(__currency_trans_from_en(result.customer_due, true));
__write_number($('input#hidden_customer_due'), result.customer_due);
$('span#closing_stock').text(__currency_trans_from_en(result.closing_stock, true));
__write_number($('input#hidden_closing_stock'), result.closing_stock);
var account_balances = result.account_balances;
$('table#assets_table tbody#account_balances').html('');
for (var key in account_balances) {
var accnt_bal = __currency_trans_from_en(result.account_balances[key]);
var accnt_bal_with_sym = __currency_trans_from_en(result.account_balances[key], true);
var account_tr = '<tr><td class="pl-20-td">' + key + ':</td><td><input type="hidden" class="asset" value="' + accnt_bal + '">' + accnt_bal_with_sym + '</td></tr>';
$('table#assets_table tbody#account_balances').append(account_tr);
}
var capital_account_details = result.capital_account_details;
$('table#assets_table tbody#capital_account_balances').html('');
for (var key in capital_account_details) {
var accnt_bal = __currency_trans_from_en(result.capital_account_details[key]);
var accnt_bal_with_sym = __currency_trans_from_en(result.capital_account_details[key], true);
var account_tr = '<tr><td class="pl-20-td">' + key + ':</td><td><input type="hidden" class="asset" value="' + accnt_bal + '">' + accnt_bal_with_sym + '</td></tr>';
$('table#assets_table tbody#capital_account_balances').append(account_tr);
}
var total_liabilty = 0;
var total_assets = 0;
$('input.liability').each( function(){
total_liabilty += __read_number($(this));
});
$('input.asset').each( function(){
total_assets += __read_number($(this));
});
$('span#total_liabilty').text(__currency_trans_from_en(total_liabilty, true));
$('span#total_assets').text(__currency_trans_from_en(total_assets, true));
}
});
}
</script>
@endsection