@extends('layouts.app')
@section('title', __('report.expense_report'))

@section('css')
    {!! Charts::styles(['highcharts']) !!}
@endsection

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>{{ __('report.expense_report')}}</h1>
</section>

<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary" id="accordion">
              <div class="box-header with-border">
                <h3 class="box-title">
                  <a data-toggle="collapse" data-parent="#accordion" href="#collapseFilter">
                    <i class="fa fa-filter" aria-hidden="true"></i> @lang('report.filters')
                  </a>
                </h3>
              </div>
              <div id="collapseFilter" class="panel-collapse active collapse in" aria-expanded="true">
                <div class="box-body">
                    <div class="col-md-4">
                        <div class="form-group">
                            {!! Form::label('location_id',  __('purchase.business_location') . ':') !!}
                            {!! Form::select('location_id', $business_locations, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'location_id']); !!}
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            {!! Form::label('category_id','Category:') !!}
                            {!! Form::select('category', $categories, null, ['placeholder' =>
                            __('report.all'), 'class' => 'form-control select2', 'style' => 'width:100%', 'id' => 'category_id']); !!}
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            {!! Form::label('trending_product_date_range', __('report.date_range') . ':') !!}
                            {!! Form::text('date_range', @format_date('first day of this month') . ' ~ ' . @format_date('last day of this month') , ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'id' => 'trending_product_date_range', 'readonly']); !!}
                        </div>
                    </div>
                </div>
              </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-md-12">
            <div class="box box-solid">
                <div class="box-body">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped" id="expense_report_table">
                            <thead>
                                <tr>
                                    <th>@lang('messages.date')</th>
                                    <th>@lang('purchase.ref_no')</th>
                                    <th>@lang('business.location')</th>
                                    <th>@lang('sale.payment_status')</th>
                                    <th>@lang('sale.total_amount')</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr class="bg-gray font-17 text-center footer-total">
                                    <td colspan="4"><strong>@lang('sale.total'):</strong></td>
                                    <td><span class="display_currency" id="footer_expense_total" data-currency_symbol ="true"></span></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

</section>
<!-- /.content -->

@endsection

@section('javascript')
    <script>
        $(document).ready( function(){
            if ($('#trending_product_date_range').length == 1) {
        $('#trending_product_date_range').daterangepicker(
            dateRangeSettings,
            function (start, end) {
                $('#trending_product_date_range span').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
                expense_table.ajax.reload();
            }
        );
        $('#trending_product_date_range').on('cancel.daterangepicker', function (ev, picker) {
            $('#trending_product_date_range').val('');
            expense_table.ajax.reload();
        });
    }
            var expense_table = $('#expense_report_table').DataTable({
                processing: true,
                serverSide: true,
                aaSorting: [[0, 'desc']],
                "ajax": {
                "url": "/reports/expense-report",
                "data": function (d) {
                d.category = $('select#category_id').val();
                d.location_id = $('select#location_id').val();

                var start = '';
                var end = '';
                if ($('input#trending_product_date_range').val()) {
                    start = $('input#trending_product_date_range').data('daterangepicker').startDate.format('YYYY-MM-DD');
                    end = $('input#trending_product_date_range').data('daterangepicker').endDate.format('YYYY-MM-DD');
                }
                d.start_date = start;
                d.end_date = end;
                console.log(d);
            }
        },
                columnDefs: [{
                    "targets": 4,
                    "orderable": false,
                    "searchable": false
                }],
                columns: [
                    { data: 'transaction_date', name: 'transaction_date' },
                    { data: 'ref_no', name: 'ref_no' },
                    { data: 'location_name', name: 'bl.name' },
                    { data: 'payment_status', name: 'payment_status' },
                    { data: 'final_total', name: 'final_total' },
                ],
                "fnDrawCallback": function (oSettings) {
                    var expense_total = sum_table_col($('#expense_report_table'), 'final-total');
                    $('#footer_expense_total').text(expense_total);

                    __currency_convert_recursively($('#expense_report_table'));
                }
            });
        });
        </script>
@endsection