@extends('layouts.app')
@section('title', __('Date Wise Net Profit'))
@section('content')
<section class="content-header"><h1>@lang('Date Wise Net Profit')</h1></section>
<section class="content">
    <div class="box box-primary">
        <div class="box-header with-border">
            <div class="row">
                <div class="col-md-4">{!! Form::text('date_range', null, ['class' => 'form-control', 'id' => 'date_range', 'placeholder' => __('Date Range'), 'readonly']) !!}</div>
                <div class="col-md-4">{!! Form::select('location_id', $locations, null, ['class' => 'form-control select2', 'id' => 'location_id', 'placeholder' => __('All Locations')]) !!}</div>
                <div class="col-md-4"><button class="btn btn-primary" id="apply_filter"><i class="fas fa-search"></i> @lang('Apply')</button></div>
            </div>
        </div>
        <div class="box-body">
            <table class="table table-bordered table-striped" id="profit_table" style="width:100%">
                <thead><tr><th>@lang('Date')</th><th class="text-right">@lang('Sales')</th><th class="text-right">@lang('COGS')</th><th class="text-right">@lang('Gross Profit')</th><th class="text-right">@lang('Expenses')</th><th class="text-right">@lang('Net Profit')</th></tr></thead>
            </table>
        </div>
    </div>
</section>
@endsection
@section('javascript')
<script>
$(document).ready(function() {
    $('#date_range').daterangepicker(dateRangeSettings, function(start, end) { $('#date_range').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)); });
    var table = $('#profit_table').DataTable({ processing: true, serverSide: true,
        ajax: { url: '{{ route("advancedreports.accounts-register.date-wise-net-profit") }}', data: function(d) { var dates = $('#date_range').val().split(' ~ '); d.start_date = dates[0]; d.end_date = dates[1]; d.location_id = $('#location_id').val(); } },
        columns: [{ data: 'report_date' },{ data: 'total_sales', className: 'text-right' },{ data: 'total_cogs', className: 'text-right' },{ data: 'gross_profit', className: 'text-right' },{ data: 'total_expenses', className: 'text-right' },{ data: 'net_profit', className: 'text-right' }]
    });
    $('#apply_filter').click(function() { table.ajax.reload(); });
});
</script>
@endsection