@extends('layouts.master')

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

@section('content')
    <style>
        div.dt-buttons {
            position: relative;
            float: right;
        }

        div.dataTables_filter {
            margin-top: 7px
        }
    </style>
    <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">
                        <form action="{{ url('reports/store-wise-sales') }}" method="get" id="filter_form">
                            <div class="row">
                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label style="font-weight: bold" for="supplier">Store</label>
                                        <select class="form-control select2" id="user_id" name="user_id">
                                            <option value="">All</option>
                                            @foreach ($stores as $user)
                                                <option value="{{ $user->id }}"
                                                    @if (request('user_id') == $user->id) selected @endif>{{ $user->store_name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-md-3">
                                    <div class="form-group">
                                        <label style="font-weight: bold" for="reportrange"> Date </label>
                                        <div class="input-group">
                                            <input type="text" class="form-control" name="dates" 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>
                                <button type="submit" class="btn btn-primary px-5 py-2 submit-filters" id="btn-search"
                                    data-type="table">Filter</button>
                                <a href="{{ url('reports/store-wise-sales') }}"
                                    class="btn btn-danger px-5 py-2">Reset</a>
                            </div>
                            <div>
                                <a href="{{ url('reports/store-wise-sales') }}"
                                    class="btn btn-primary float-right px-3 py-2 mt-2 mb-1 submit-filters" style="position: relative;"
                                    data-type="excel">Download
                                    Excel</a>
                                <span id="btn_print">
                                    <button type="button" id="print" class="btn btn-primary float-right px-5 py-2 mr-1 mt-2 mb-1"
                                        style="position: relative;">Print</button></span>
                            </div>
                            <input type="hidden" name="data_type" id="data_type" value="">
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="h6">Total Sale</div>
                <h4><span>Rs.{{ number_format($total_sale, 2) }} </span></h4>
                
                
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="h6">Total Sales Return</div>
                <h4><span>Rs.{{ number_format($total_sale_return, 2) }} </span></h4>
                
            </div>
        </div>
    </div>
    <div class="col-md-4">
        <div class="card">
            <div class="card-body">
                <div class="h6">Grand Total</div>
                <h4><span>Rs.{{ number_format($total_value, 2) }} </span></h4>
                
            </div>
        </div>
    </div>

    <div class="col-md-12" id="print_ariea">
        <div class="card">
            <div class="card-body">
                <div class="table-responsive dash-social">
                    <table id="laravel_datatable" class="table table-striped">
                        <thead class="thead-dark">
                            <tr>
                               
                                <th>Order ID</th>
                                <th>Payment Status</th>
                                <th>Total Value</th>
                                <th>Total Paid</th>
                                <th>Commission {{$display_term}} </th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach ($sales as $sale)
                                <tr>
                                    <td>
                                        @if (!empty($sale->invoice_no))
                                            {{ $sale->invoice_no }}
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        @if ($sale->payment_status == 'due')
                                            <a id="view_payments" href="javascript:void(0)"
                                                data-href="{{ route('oder.view_payment', $sale->id) }}"><span
                                                    class="badge badge-warning">Pending</span></a>
                                        @elseif ($sale->payment_status == 'online')
                                            <a id="view_payments" href="javascript:void(0)"
                                                data-href="{{ route('oder.view_payment', $sale->id) }}"><span
                                                    class="badge badge-success">Online</span></a>
                                        @elseif ($sale->payment_status == 'paid')
                                            <a id="view_payments" href="javascript:void(0)"
                                                data-href="{{ route('oder.view_payment', $sale->id) }}"><span
                                                    class="badge badge-success">Paid</span></a>
                                        @elseif ($sale->payment_status == 'partial')
                                            <a id="view_payments" href="javascript:void(0)"
                                                data-href="{{ route('oder.view_payment', $sale->id) }}"><span
                                                    class="badge badge-secondary">Partial</span></a>
                                        @elseif ($sale->payment_status == 'canceled')
                                            <span class="badge badge-danger">Canceled</span>
                                        @else
                                            <a id="view_payments" href="javascript:void(0)"
                                                data-href="{{ route('oder.view_payment', $sale->id) }}"><span
                                                    class="badge badge-info">Not
                                                    Available</span></a>
                                        @endif
                                    </td>
                                    <td>{{ number_format($sale->invoice_nettotal, 2) }}</td>
                                    <td>
                                        @php
                                            $paid_amount = App\SalePayment::where('sale_id', $sale->id)->sum('amount');
                                        @endphp
                                        {{ number_format($paid_amount, 2) }}</td>
                                    <td>{{ number_format($sale->agent_commission, 2) }}</td>
                                    
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                    <div class="d-flex justify-content-end">
                        {{ $sales->appends($_GET)->links() }}
                    </div>
                    <div>
                        
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('scripts')
    <script>
        $(document).on('click', '.submit-filters', function(e) {
            e.preventDefault()
            let data_type = $(this).data('type');
            $('#data_type').val(data_type);
            $('#filter_form').submit();
        });

        $(document).on('click', '#print', function() {
            $('#btn_print').hide();
            $("#print_ariea").show();
            window.print();
            $('#btn_print').show();
        });


        $(document).ready(function() {
            var getUrlParameter = function getUrlParameter(sParam) {
                var sPageURL = decodeURIComponent(window.location.search.substring(1)),
                    sURLVariables = sPageURL.split('&'),
                    sParameterName,
                    i;
                for (i = 0; i < sURLVariables.length; i++) {
                    sParameterName = sURLVariables[i].split('=');

                    if (sParameterName[0] === sParam) {
                        return sParameterName[1] === undefined ? true : sParameterName[1];
                    }
                }
            };
            var report_date = getUrlParameter('dates');
            myString = report_date.split('+-+').join('/');
            var result = myString.split('/');
            $('#reportrange').daterangepicker({
                startDate: result[0],
                endDate: result[1],
                ranges: {
                    'All Data': ['2020-01-01', moment()],
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Day before yesterday': [moment().subtract(2, 'days'), moment().subtract(2, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                    'This Month': [moment().startOf('month'), moment().endOf('month')],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
                        'month').endOf(
                        'month')],
                    'Last 6 Months': [moment().subtract(5, 'month'), moment()],
                },
                locale: {
                    format: 'Y-M-DD'
                }
            });
        });
    </script>
@endsection