@extends('admin.reports.sales.index')

@section('reports_content')
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-body">
                    <div class="row header-controls" id="article_buttons">
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>@lang('crm.estimate_status')</label>
                                <select class="form-control multiselect report-select" multiple="multiple" name="status" data-fouc>
                                    @foreach($statuses as $key => $status)
                                        <option value="{{ $key }}">{{ $status }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>@lang('crm.sale_agent_string')</label>
                                <select class="form-control multiselect report-select" multiple="multiple" name="sale_agent" data-fouc>
                                    @foreach($sale_agents as $agent)
                                        <option value="{{ $agent['sale_agent'] }}">{{ $agent['full_name'] }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group">
                                <label>@lang('crm.period_datepicker')</label>
                                <select class="form-control select report-select"  name="months" data-fouc>
                                    <option value="">@lang('crm.report_sales_months_all_time')</option>
                                    <option value="this_month">@lang('crm.this_month')</option>
                                    <option value="1">@lang('crm.last_month')</option>
                                    <option value="this_year">@lang('crm.this_year')</option>
                                    <option value="last_year">@lang('crm.last_year')</option>
                                    <option value="3" data-subtext="{{ local_date_format(date('Y-m-01', strtotime("-2 MONTH"))) }} - {{local_date_format(date('Y-m-t'))}}">@lang('crm.report_sales_months_three_months')</option>
                                    <option value="6" data-subtext="{{ local_date_format(date('Y-m-01', strtotime("-5 MONTH"))) }} - {{local_date_format(date('Y-m-t'))}}">@lang('crm.report_sales_months_six_months')</option>
                                    <option value="12" data-subtext="{{ local_date_format(date('Y-m-01', strtotime("-11 MONTH"))) }} - {{local_date_format(date('Y-m-t'))}}">@lang('crm.report_sales_months_twelve_months')</option>
                                </select>
                            </div>
                        </div>
                    </div>

                    <table class="table" id="appendix-table">
                        <thead>
                            <th>@lang('crm.estimate_dt_table_heading_number')</th>
                            <th>@lang('crm.estimate_dt_table_heading_amount')</th>
                            <th>@lang('crm.client')</th>
                            <th>@lang('crm.estimate_dt_table_heading_date')</th>
                            <th>@lang('crm.estimate_dt_table_heading_expirydate')</th>
                            <th>@lang('crm.expense_add_edit_reference_no')</th>
                            <th>@lang('crm.estimate_status')</th>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
            </div>

            <div class="card">
                <div class="card-body">
                    <h5 class="card-title">Current Appendix Profit</h5>

                    <div class="table-responsive">
                        <table class="table" id="appendix-profit-table">
                            <thead>
                                <th>Total Count</th>
                                <th>Gross Profit</th>
                                <th>Net Profit</th>
                                <th>Company Profit</th>
                                <th>Total Balance</th>
                            </thead>
                            <tbody>
                                @if(!empty($profits))
                                    @foreach($profits as $currency => $profit)
                                        <tr>
                                            <td>{{ $currency }} <span class="badge badge-primary badge-pill ml-2">{{ $profit['count'] }}</span></td>
                                            <td>{!! $profit['profit_gross'] !!}</td>
                                            <td>{!! $profit['profit_net'] !!}</td>
                                            <td>{!! $profit['profit_cbc'] !!}</td>
                                            <td>{!! $profit['profit_total'] !!}</td>
                                        </tr>
                                    @endforeach
                                @endif
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
@stop

@section('scripts_scope')

    <script>
        $(document).ready(function () {
            let table = $('#appendix-table').DataTable({
                'processing': true,
                'serverSide': true,
                'serverMethod': 'post',
                'ajax': {
                    'url': '{{ url('admin/reports/sales/getAppendixReport') }}',
                    'data': function ( d ) {
                        d.status = $('select[name="status"]').val();
                        d.sale_agent = $('select[name="sale_agent"]').val();
                        d.months = $('select[name="months"]').val();
                    }
                },
                'columns': [
                    {data: 'number'},
                    {data: 'total'},
                    {data: 'customer'},
                    {data: 'date'},
                    {data: 'expirydate'},
                    {data: 'reference'},
                    {data: 'status'},
                ],
            });

            $('.report-select').on('change', function () {
                table.ajax.reload();
            })

            $('#appendix-profit-table').DataTable({
                'processing': false,
                'serverSide': false,
            });
        });

    </script>

@stop