@extends('layouts.master')

@section('page_title', 'Province Wise Sale Report')
@section('title', 'Province Wise Sale Report')
@section('main_item', 'Reports')
@section('sub_item', 'Province Wise Sale Report')

@section('content')

    <div class="col-12">
        <div class="card">
            <div id="accordion">

                <div class="border-bottom card-header" style="background-color: white; cursor: pointer;" data-toggle="collapse"
                    data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
                    <h4 class="mb-0 header-title">
                        Filter
                    </h4>
                </div>


                <div id="collapseOne" class="collapse show mt-3" aria-labelledby="headingOne" data-parent="#accordion">
            <div class="card-body">
                <div class="row">
                    <div class="col-md-4" hidden>
                        <div class="form-group">
                            <label style="font-weight: bold" for="supplier">Area</label>
                            <select class="form-control select2" id="area_id" name="area">
                                <option>Select</option>
                                @foreach ($areas as $area)
                                    <option value="{{ $area->id }}">{{ $area->province_name }}</option>
                                @endforeach
                            </select>
                        </div>
                    </div>
              
                    <div class="col-md-4" @if ($setting->business_location != '1') style="display: none" @endif>
                        <div class="form-group">
                            <label class="required" style="font-weight: bold">business Location</label>
                            <select class="form-control custom-select" id="business_location_id" name="business_location_id">
                                <option value="">All</option>
                                @if (Auth::user()->role_id == '1')
                                    @foreach ($business_locations as $business_location)
                                        @if ($business_location->is_active == '1')
                                            <option value="{{ $business_location->id }}">
                                                {{ $business_location->name }}
                                            </option>
                                        @else
                                        @endif
                                    @endforeach
                                @else
                                    @foreach ($business_locations as $business_location)
                                        @if ($business_location->is_active == '1')
                                            <option value="{{ $business_location->business_location_id }}">
                                                {{ $business_location->name }}
                                            </option>
                                        @else
                                        @endif
                                    @endforeach
                                @endif
                            </select>
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label style="font-weight: bold" for="supplier">Date Range</label>
                            <div class="input-group">
                                <input type="text" class="form-control" name="dates-d" id="reportrange" readonly>
                                <div class="input-group-append">
                                    <span class="input-group-text"><i class="dripicons-calendar"></i></span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div>
        </div>
    </div>
    <div class="col-12">
        <div class="card">
            <div class="card-body">
                <div class="col-xs-12">
                    <div class="box box-solid">
                        <div class="box-body">
                            <table class="table table-striped" id="laravel_datatable">
                                <thead class="thead-dark">
                                    <tr>
                                        <th>Province</th>
                                        {{-- <th>Business Location</th> --}}
                                        <th>Sale Count</th>
                                        <th>Total Sale</th>
                                    </tr>
                                </thead>
                                <tbody></tbody>
                            </table>
                        </div>

                        <div class="box-body">
                            <div id="myfirstchart" style="height: 400px;"></div>
                        </div>

                    </div>
                </div>
            </div>
            <!--end card-body-->
        </div>
        <!--end card-->
    </div>

@endsection
@section('scripts')
    <script>
        $(document).ready(function() {
            $('#mdate').val(moment(new Date()).format("YYYY-MM-DD"));
        })
        $(document).ready(function() {
            table = $('#laravel_datatable').DataTable({
                dom: 'Blfrtip',
                lengthMenu: [
                    [25, 50, 100, -1],
                    ['25 ', '50 ', '100', 'All']
                ],
                buttons: [
                    'copy', 'csv', 'excel', 'pdf', 'print'
                ],
                processing: true,
                serverSide: true,
                ajax: {
                    url: "{{ url('/reports/area-wise-sales') }}",
                    data: function(d) {
                        d.location_id = $('#business_location_id').val();
                        d.range = $('#reportrange').val();
                    },
                },
                columns: [{
                        data: 'province',
                        name: 'province'
                    },
                    // {
                    //     data: 'location_id',
                    //     name: 'location_id'
                    // },
                    {
                        data: 'count1',
                        name: 'count1'
                    },
                    {
                        data: 'total',
                        name: 'total'
                    }
                ]
            });

        });

        $(document).on('change', '#reportrange, #business_location_id', function() {
            table.ajax.reload();

        })
    </script>

@endsection