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.trial_balance' ))
@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.trial_balance')
</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('trial_bal_location_id', __('purchase.business_location') . ':') !!}
{!! Form::select('trial_bal_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.trial_balance') - <span id="hidden_date">{{@format_date('now')}}</span></h3>
</div>
<div class="box-body">
<table class="table table-border-center-col no-border table-pl-12" id="trial_balance_table">
<thead>
<tr class="bg-gray">
<th>@lang('account.trial_balance')</th>
<th>@lang('account.debit')</th>
<th>@lang('account.credit')</th>
</tr>
</thead>
<tbody>
<tr>
<th>@lang('account.supplier_due'):</th>
<td> </td>
<td>
<input type="hidden" id="hidden_supplier_due" class="debit">
<span class="remote-data" id="supplier_due">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
</tr>
<tr>
<th>@lang('account.customer_due'):</th>
<td>
<input type="hidden" id="hidden_customer_due" class="credit">
<span class="remote-data" id="customer_due">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
<td> </td>
</tr>
<tr>
<th>@lang('account.account_balances'):</th>
<td> </td>
<td> </td>
</tr>
</tbody>
<tbody id="account_balances_details">
</tbody>
{{--
<tbody>
<tr>
<th>@lang('account.capital_accounts'):</th>
<td> </td>
<td> </td>
</tr>
</tbody>
<tbody id="capital_account_balances_details"></tbody>
--}}
<tfoot>
<tr class="bg-gray">
<th>@lang('sale.total')</th>
<td>
<span class="remote-data" id="total_credit">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</td>
<td>
<span class="remote-data" id="total_debit">
<i class="fas fa-sync fa-spin fa-fw"></i>
</span>
</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_trial_balance();
$('#end_date').change( function() {
update_trial_balance();
$('#hidden_date').text($(this).val());
});
$('#trial_bal_location_id').change( function() {
update_trial_balance();
});
});
function update_trial_balance(){
var loader = '<i class="fas fa-sync fa-spin fa-fw"></i>';
$('span.remote-data').each( function() {
$(this).html(loader);
});
$('table#trial_balance_table tbody#capital_account_balances_details').html('<tr><td colspan="3"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>');
$('table#trial_balance_table tbody#account_balances_details').html('<tr><td colspan="3"><i class="fas fa-sync fa-spin fa-fw"></i></td></tr>');
var end_date = $('input#end_date').val();
var location_id = $('#trial_bal_location_id').val()
$.ajax({
url: "{{action([\App\Http\Controllers\AccountReportsController::class, 'trialBalance'])}}?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);
var account_balances = result.account_balances;
$('table#trial_balance_table tbody#account_balances_details').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="credit" value="' + accnt_bal + '">' + accnt_bal_with_sym + '</td><td> </td></tr>';
$('table#trial_balance_table tbody#account_balances_details').append(account_tr);
}
var capital_account_details = result.capital_account_details;
$('table#trial_balance_table tbody#capital_account_balances_details').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="credit" value="' + accnt_bal + '">' + accnt_bal_with_sym + '</td><td> </td></tr>';
$('table#trial_balance_table tbody#capital_account_balances_details').append(account_tr);
}
var total_debit = 0;
var total_credit = 0;
$('input.debit').each( function(){
total_debit += __read_number($(this));
});
$('input.credit').each( function(){
total_credit += __read_number($(this));
});
$('span#total_debit').text(__currency_trans_from_en(total_debit, true));
$('span#total_credit').text(__currency_trans_from_en(total_credit, true));
}
});
}
</script>
@endsection