@extends('layouts.master')

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

@section('content')

    <div class="col-sm-12 text-right">
        <form id="filter-form">
            <div class="input-group col-4 mb-2 float-right">
                <input type="text" class="form-control" name="dates-d" id="reportrange" readonly
                    style="background-color:white">
                <span class="input-group-append">
                    <button type="submit" class="btn btn-primary">Filter</button>
                </span>
            </div>
            <div class="col-4 mb-2 float-right">
                <div class="input-group">
                    <select class="form-control" id="location_id" name="location_id">
                        <option value="">All Location</option>
                        @if (Auth::user()->role_id == '1')
                            @foreach ($users_access_location as $business_location)
                                @if ($business_location->is_active == '1')
                                    <option value="{{ $business_location->id }}">
                                        {{ $business_location->name }}
                                    </option>
                                @else
                                @endif
                            @endforeach
                        @else
                            @foreach ($users_access_location 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>
        </form>
    </div>
    <div class="col-4">
        <div class="card">
            <div class="card-body">
                <div class="col-xs-6">
                    <div class="box box-solid">
                        <div class="box-body">
                            <table class="table table-striped">
                                <tbody>
                                    <tr>
                                        <th><b>Total Orders:</b></th>
                                        <td>
                                            <span class="total_purchase" id="total_orders_count">
                                                {{ $total_orders_count }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Pending Orders:</b></th>
                                        <td>
                                            <span id="pending_oders_count">{{ $pending_oders_count }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Hold Orders:</b></th>
                                        <td>
                                            <span id="hold_oders_count">{{ $hold_oders_count }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Cancel Orders:</b></th>
                                        <td>
                                            <span id="cancel_oders_count">{{ $cancel_oders_count }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Confirm Orders:</b></th>
                                        <td>
                                            <span id="confirm_oders_count">{{ $confirm_oders_count }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Not Confirm Orders:</b></th>
                                        <td>
                                            <span id="not_confirm_oders_count">{{ $not_confirm_oders_count }}</span>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-4">
        <div class="card">
            <div class="card-body">
                <div class="col-xs-6">
                    <div class="box box-solid">
                        <div class="box-body">
                            <table class="table table-striped">
                                <tbody>
                                    <tr>
                                        <th><b>Dispatch Orders:</b></th>
                                        <td>
                                            <span id="dispatch_orders_count">
                                                {{ $dispatch_orders_count }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Delivered Orders:</b></th>
                                        <td>
                                            <span id="delivered_orders_count">
                                                {{ $delivered_orders_count }}</span>
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Returned Orders:</b></th>
                                        <td>
                                            <span id="returned_orders_count">
                                                {{ $returned_orders_count }}</span>
                                            </span>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-4">
        <div class="card">
            <div class="card-body">
                <div class="col-xs-6">
                    <div class="box box-solid">
                        <div class="box-body">
                            <table class="table table-striped">
                                <tbody>
                                    <tr>
                                        <th><b>Total Delivered Sales:</b></th>
                                        <td style="text-align: right" id="total_sale">₨
                                            <span>
                                                {{ number_format($total_sale, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total Courier Charge:</b></th>
                                        <td style="text-align: right" id="courier_cost">₨
                                            <span>{{ number_format($courier_cost, 2) }}</span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Actual Sale:</b></th>
                                        <td style="text-align: right" id="actual_sale">₨
                                            {{ number_format($actual_sale, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total Online Payment:</b></th>
                                        <td style="text-align: right" id="total_payments">
                                            <span>₨
                                                {{ number_format($total_payments, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total Courier Payment:</b></th>
                                        <td style="text-align: right" id="total_courier_cost">
                                            <span>₨
                                                {{ number_format($total_courier_cost, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Due Payment:</b></th>
                                        <td style="text-align: right" id="total_payments_due">
                                            <span>₨
                                                {{ number_format($total_payments_due, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total Expenses:</b></th>
                                        <td style="text-align: right" id="total_expenses">
                                            <span>₨
                                                {{ number_format($total_expenses, 2) }}
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total Stock Adjustment:</b></th>
                                        <td style="text-align: right" id="stock_adjest">
                                            <span>₨
                                                {{ number_format($stock_adjest, 2) }}
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection
@section('scripts')
<script>
    $(document).ready(function() {
        // $('#location_id').change(function() {
        //     $('#filter-form').submit();
        // });

        // $('#reportrange').change(function() {
        //     $('#filter-form').submit();
        // });
        
            $('#filter-form').submit(function(event) {
                event.preventDefault();
                var reportrange = $('#reportrange').val();
                var location_id = $('#location_id').val();
                $.ajax({
                    url: "{{ url('reports/purchase-sell-dates') }}",
                    method: 'GET',
                    data: {
                        reportrange: reportrange,
                        location_id: location_id
                    },
                    success: function(response) {
                        // Update the new data
                        let id = response;
                        $('#total_orders_count').text(id['total_orders_count']);
                        $('#pending_oders_count').text(id['pending_oders_count']);
                        $('#hold_oders_count').text(id['hold_oders_count']);
                        $('#cancel_oders_count').text(id['cancel_oders_count']);
                        $('#confirm_oders_count').text(id['confirm_oders_count']);
                        $('#not_confirm_oders_count').text(id['not_confirm_oders_count']);
                        $('#dispatch_orders_count').text(id['dispatch_orders_count']);
                        $('#delivered_orders_count').text(id['delivered_orders_count']);
                        $('#returned_orders_count').text(id['returned_orders_count']);
                        $('#total_sale').text(id['total_sale']);
                        $('#courier_cost').text(id['courier_cost']);
                        $('#actual_sale').text(id['actual_sale']);
                        $('#total_payments').text(id['total_payments']);
                        $('#total_courier_cost').text(id['total_courier_cost']);
                        $('#total_payments_due').text(id['total_payments_due']);
                        $('#total_expenses').text(id['total_expenses']);
                        $('#gross_profit').text(id['gross_profit']);
                        $('#net_profit').text(id['net_profit']);
                        $('#stock_adjest').text(id['stock_adjest']);
                    }
                });
            });
        });
    </script>


@endsection