@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-12 col-md-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-12 col-md-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>
            <div class="col-12 col-md-4 mb-2 float-right">
                <div class="input-group">
                    <select class="form-control" id="user_id" name="user_id">
                        <option value="">All Users</option>
                        @foreach ($users as $id => $user)  <!-- Note the change here -->
                            <option value="{{ $id }}">   <!-- Use $id as the value -->
                                {{ $user }}                <!-- Display the user name -->
                            </option>
                        @endforeach
                    </select>
                </div>
            </div>
            
        </form>
    </div>
    <div class="col-12 col-md-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 style="float: left" class="total_purchase" id="total_orders_count">
                                                {{ $total_orders_count }}
                                            </span>
                                            <span style="float: right;" id="total_orders_total">
                                                ₨ {{ number_format($total_orders_total, 2) }}
                                            </span>
                                        </td>
                                        
                                    </tr>
                                    
                                    <tr>
                                        <th><b>Pending Orders:</b></th>
                                        <td>
                                            <span style="float: left" id="pending_oders_count">{{ $pending_oders_count }}</span>
                                            <span style="float: right" id="pending_oders_total">
                                                ₨ {{number_format($pending_oders_total,2)}}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Hold Orders:</b></th>
                                        <td>
                                            <span style="float: left"  id="hold_oders_count">{{ $hold_oders_count }}</span>
                                            <span style="float: right" id="hold_oders_total">
                                                ₨ {{ number_format($hold_oders_total, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Cancel Orders:</b></th>
                                        <td>
                                            <span style="float: left"  id="cancel_oders_count">{{ $cancel_oders_count }}</span>
                                            <span style="float: right" id="cancel_oders_total">
                                                ₨ {{ number_format($cancel_oders_total, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Confirm Orders:</b></th>
                                        <td>
                                            <span style="float: left"  id="confirm_oders_count">{{ $confirm_oders_count }}</span>
                                            <span style="float: right" id="confirm_oders_total">
                                                ₨ {{ number_format($confirm_oders_total, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Not Confirm Orders:</b></th>
                                        <td>
                                            <span style="float: left" id="not_confirm_oders_count">{{ $not_confirm_oders_count }}</span>
                                            <span style="float: right" id="not_confirm_oders_total">
                                                ₨ {{ number_format($not_confirm_oders_total, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-12 col-md-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 style="float: left" id="dispatch_orders_count">
                                                {{ $dispatch_orders_count }}</span>
                                                <span style="float: right" id="dispatch_orders_total">
                                                    ₨ {{ number_format($dispatch_orders_total, 2) }}
                                                </span>
                                            </td>
                                    </tr>
                                    <tr>
                                        <th><b>Delivered Orders:</b></th>
                                        <td>
                                            <span style="float: left" id="delivered_orders_count">
                                                {{ $delivered_orders_count }}
                                            </span>
                                            <span style="float: right" id="delivered_orders_total">
                                                ₨ {{ number_format($delivered_orders_total, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Returned Orders:</b></th>
                                            <td>
                                                <span style="float: left" id="returned_orders_count">
                                                    {{ $returned_orders_count }}
                                                </span>
                                                <span style="float: right" id="returned_orders_total">
                                                    ₨ {{ number_format($returned_orders_total, 2) }}
                                                </span>
                                            </td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-12 col-md-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">₨
                                            <span>{{ 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 COD Payment:</b></th>
                                        <td style="text-align: right" id="total_COD_payments">
                                            <span>₨
                                                {{ number_format($total_COD_payments, 2) }}
                                            </span>
                                        </td>
                                    </tr>
                                    <tr>
                                        <th><b>Total 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>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </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">
                            <h3 class="text-muted mb-0">
                                Gross Profit :
                                <span class="gross_profit text-success" id="gross_profit">₨.
                                    {{ number_format($gross_profit, 2) }}
                            </h3>
                            <small class="help-block">(Total sale value - Item cost)</small>
                            <h3 class="text-muted mb-0">
                                <br>
                                Net Profit :
                                <span class="net_profit text-success" id="net_profit">₨.
                                    {{ number_format($net_profit, 2) }}</span>
                            </h3>
                            <small class="help-block">Gross Profit - (Total Courier Charge + Total Expenses )</small>
                        </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();
        });
        $('#user_id').change(function() {
            $('#filter-form').submit();
        });

            $('#filter-form').submit(function(event) {
                event.preventDefault();
                var reportrange = $('#reportrange').val();
                var location_id = $('#location_id').val();
                var user_id = $('#user_id').val();

                $.ajax({
                    url: "{{ url('reports/purchase-sell-dates') }}",
                    method: 'GET',
                    data: {
                        reportrange: reportrange,
                        location_id: location_id,
                        user_id: user_id
                    },
                    success: function(response) {
          
                        $('#total_orders_count').text(response['total_orders_count']);
                        $('#total_orders_total').text(response['total_orders_total']);
                        $('#pending_oders_count').text(response['pending_oders_count']);
                        $('#pending_oders_total').text(response['pending_oders_total']);
                        $('#hold_oders_count').text(response['hold_oders_count']);
                        $('#hold_oders_total').text(response['hold_oders_total']);
                        $('#cancel_oders_count').text(response['cancel_oders_count']);
                        $('#cancel_oders_total').text(response['cancel_oders_total']);
                        $('#confirm_oders_count').text(response['confirm_oders_count']);
                        $('#confirm_oders_total').text(response['confirm_oders_total']);
                        $('#not_confirm_oders_count').text(response['not_confirm_oders_count']);
                        $('#not_confirm_oders_total').text(response['not_confirm_oders_total']);
                        $('#dispatch_orders_count').text(response['dispatch_orders_count']);
                        $('#dispatch_orders_total').text(response['dispatch_orders_total']);
                        $('#delivered_orders_count').text(response['delivered_orders_count']);
                        $('#delivered_orders_total').text(response['delivered_orders_total']);
                        $('#returned_orders_count').text(response['returned_orders_count']);
                        $('#returned_orders_total').text(response['returned_orders_total']);
                        $('#total_sale').text(response['total_sale']);
                        $('#courier_cost').text(response['courier_cost']);
                        $('#actual_sale').text(response['actual_sale']);
                        $('#total_payments').text(response['total_payments']);
                        $('#total_COD_payments').text(response['total_COD_payments']);
                        $('#total_payments_due').text(response['total_payments_due']);
                        $('#total_expenses').text(response['total_expenses']);
                        $('#gross_profit').text(response['gross_profit']);
                        $('#net_profit').text(response['net_profit']);
                    }
                });
            });
        });
    </script>


@endsection