@extends('layouts.app')
@section('title', __('Account Summary Report'))

@section('content')

    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>{{ __('Account Summary Report') }}</h1>
    </section>

    <section class="content">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    <div class="col-md-3">
                        <label for="">Account Category:</label>
                        {!! Form::select(
                            'account_category',
                            [
                                '' => 'All',
                                'bank' => 'Bank Account',
                                'return' => 'Return Account',
                                'expence' => 'Expence Account',
                                'purchase' => 'Purchase Account',
                            ],
                            null,
                            ['class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'account_category'],
                        ) !!}
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-map-marker"></i>
                                </span>
                                <select class="form-control select2" id="location_id" name="location_id" multiple>
                                    @foreach ($business_locations as $business_location)
                                        <option value="{{ $business_location->id }}">{{ $business_location->name }} </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('transaction_date_range', __('report.date_range') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                {!! Form::text('transaction_date_range', null, [
                                    'class' => 'form-control',
                                    'readonly',
                                    'placeholder' => __('report.date_range'),
                                ]) !!}
                            </div>
                        </div>
                    </div>
                @endcomponent
            </div>
        </div>
        <div class="row">
            <div class="col-md-12">
                @component('components.widget', ['class' => 'box-primary'])
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped" id="account_summary_table">
                            <thead>
                                <tr>
                                    <th>@lang('lang_v1.name')</th>
                                    <th>@lang('lang_v1.account_type')</th>
                                    <th>@lang('sale.location')</th>
                                    <th>@lang('account.account_number')</th>
                                    <th>@lang('Debit')</th>
                                    <th>@lang('Credit')</th>
                                    <th>@lang('lang_v1.balance')</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr class="bg-gray font-17 footer-total text-center">
                                    <td colspan="4"><strong>@lang('sale.total'):</strong></td>
                                    <td class="footer_debit_total_balance"></td>
                                    <td class="footer_credit_total_balance"></td>
                                    <td class="footer_total_balance"></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                @endcomponent
            </div>
        </div>
    </section>
@endsection

@section('javascript')
    <script>
        $(document).ready(function() {
            $('#al_date_filter').daterangepicker(dateRangeSettings, function(start, end) {
                $('#al_date_filter').val(
                    start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                );
                account_summary_table.ajax.reload();
            });
            $('#al_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                $('#al_date_filter').val('');
                account_summary_table.ajax.reload();
            });

            dateRangeSettings.startDate = moment().subtract(29, 'days');
            dateRangeSettings.endDate = moment();
            $('#transaction_date_range').daterangepicker(
                dateRangeSettings,
                function(start, end) {
                    $('#transaction_date_range').val(start.format(moment_date_format) + ' ~ ' + end.format(
                        moment_date_format));
                }
            );
            // capital_account_table
            account_summary_table = $('#account_summary_table').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: '/reports/account/summary',
                    data: function(d) {
                        var start = '';
                        var end = '';
                        if ($('#transaction_date_range').val()) {
                            start = $('input#transaction_date_range').data('daterangepicker').startDate
                                .format('YYYY-MM-DD');
                            end = $('input#transaction_date_range').data('daterangepicker').endDate
                                .format('YYYY-MM-DD');
                        }
                        d.start_date = start;
                        d.end_date = end;
                        d.account_category = $('#account_category').val();
                        d.location_id = $('#location_id').val();
                    }
                },
                columnDefs: [{
                    "targets": [0],
                    "orderable": false,
                    "searchable": false
                }],
                columns: [{
                        data: 'name',
                        name: 'accounts.name'
                    },
                    {
                        data: 'parent_account_type_name',
                        name: 'pat.name'
                    },
                    {
                        data: 'bussiness_location',
                        name: 'bussiness_location',
                        orderable: false
                    },
                    {
                        data: 'account_number',
                        name: 'accounts.account_number'
                    },
                    {
                        data: 'debit',
                        name: 'debit',
                        searchable: false,
                        orderable: false
                    },
                    {
                        data: 'credit',
                        name: 'credit',
                        searchable: false,
                        orderable: false
                    },
                    {
                        data: 'balance',
                        name: 'balance',
                        searchable: false
                    },
                ],
                "fnDrawCallback": function(oSettings) {
                    __currency_convert_recursively($('#account_summary_table'));
                },
                "footerCallback": function(row, data, start, end, display) {
                    var footer_total_balance = 0;
                    for (var r in data) {
                        footer_total_balance += $(data[r].balance).data('orig-value') ? parseFloat($(
                            data[r].balance).data('orig-value')) : 0;
                    }
                    $('.footer_total_balance').html(__currency_trans_from_en(footer_total_balance));
                    var footer_credit_total_balance = 0;
                    for (var r in data) {
                        footer_credit_total_balance += $(data[r].credit).data('orig-value') ?
                            parseFloat($(
                                data[r].credit).data('orig-value')) : 0;
                    }
                    $('.footer_credit_total_balance').html(__currency_trans_from_en(
                        footer_credit_total_balance));
                    var footer_debit_total_balance = 0;
                    for (var r in data) {
                        footer_debit_total_balance += $(data[r].debit).data('orig-value') ? parseFloat(
                            $(
                                data[r].debit).data('orig-value')) : 0;
                    }
                    $('.footer_debit_total_balance').html(__currency_trans_from_en(
                        footer_debit_total_balance));
                }
            });
            $('#account_category, #location_id, #transaction_date_range').change(function() {
                account_summary_table.ajax.reload();
            });
        });
    </script>
@endsection